[pal-cvs 2837] [582] updated db(put required).

svnno****@sourc***** svnno****@sourc*****
2007年 9月 25日 (火) 16:09:41 JST


Revision: 582
          http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=582
Author:   shinsuke
Date:     2007-09-25 16:09:39 +0900 (Tue, 25 Sep 2007)

Log Message:
-----------
updated db(put required).

Modified Paths:
--------------
    pompei/portlets/pompei-core/trunk/dbflute/schema/project-schema-pompei.xml
    pompei/portlets/pompei-core/trunk/src/main/config/pompei.clay
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsCustomerBhv.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsCustomerDao.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsBargain.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsCategory.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsCustomer.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsCustomerBasketAttribute.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsGeoZone.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsManufacturer.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsOrderForm.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProduct.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsReview.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsTaxClass.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsTaxRate.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsZoneToGeoZone.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/BargainDbm.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/CategoryDbm.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/CustomerBasketAttributeDbm.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/CustomerDbm.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/GeoZoneDbm.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ManufacturerDbm.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/OrderFormDbm.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductDbm.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ReviewDbm.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/TaxClassDbm.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/TaxRateDbm.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ZoneToGeoZoneDbm.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsBargainCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsCategoryCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsCustomerBasketAttributeCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsCustomerCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsGeoZoneCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsManufacturerCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsOrderFormCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsProductCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsReviewCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsTaxClassCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsTaxRateCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsZoneToGeoZoneCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsBargainCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsCategoryCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsCustomerBasketAttributeCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsCustomerCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsGeoZoneCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsManufacturerCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsOrderFormCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsProductCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsReviewCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsTaxClassCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsTaxRateCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsZoneToGeoZoneCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/BargainCIQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/CategoryCIQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/CustomerBasketAttributeCIQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/CustomerCIQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/GeoZoneCIQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ManufacturerCIQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/OrderFormCIQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ProductCIQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ReviewCIQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/TaxClassCIQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/TaxRateCIQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ZoneToGeoZoneCIQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/web/admin/product/CategoryEditAction.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/web/admin/product/ManufacturerEditAction.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/web/admin/product/ProductEditAction.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/web/user/checkout/UserInfoEditAction.java
    pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql
    pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/insert_data.sql
    pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/insert_sample_data.sql


-------------- next part --------------
Modified: pompei/portlets/pompei-core/trunk/dbflute/schema/project-schema-pompei.xml
===================================================================
--- pompei/portlets/pompei-core/trunk/dbflute/schema/project-schema-pompei.xml	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/dbflute/schema/project-schema-pompei.xml	2007-09-25 07:09:39 UTC (rev 582)
@@ -65,9 +65,9 @@
         <column dbType="DECIMAL" javaType="java.math.BigDecimal"
             name="BARGAIN_PRICE" required="true" size="15" type="DECIMAL"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
-            name="DATE_ADDED" type="TIMESTAMP"/>
+            name="DATE_ADDED" required="true" type="TIMESTAMP"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
-            name="LAST_MODIFIED" type="TIMESTAMP"/>
+            name="LAST_MODIFIED" required="true" type="TIMESTAMP"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
             name="START_DATE" type="TIMESTAMP"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
@@ -119,11 +119,11 @@
         <column dbType="INTEGER" default="0"
             javaType="java.math.BigDecimal" name="PARENT_ID" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
-            name="SORT_ORDER" type="INTEGER"/>
+            name="SORT_ORDER" required="true" type="INTEGER"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
-            name="DATE_ADDED" type="TIMESTAMP"/>
+            name="DATE_ADDED" required="true" type="TIMESTAMP"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
-            name="LAST_MODIFIED" type="TIMESTAMP"/>
+            name="LAST_MODIFIED" required="true" type="TIMESTAMP"/>
         <foreign-key foreignTable="CATEGORY" name="FK_CATEGORIES_1">
             <reference foreign="CATEGORY_ID" local="PARENT_ID"/>
         </foreign-key>
@@ -212,6 +212,10 @@
             required="true" type="DATE"/>
         <column dbType="VARCHAR" javaType="String" name="EMAIL_ADDRESS"
             required="true" size="128" type="VARCHAR"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="LAST_MODIFIED" required="true" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="DATE_ADDED" required="true" type="TIMESTAMP"/>
     </table>
     <table name="CUSTOMER_BASKET" schema="APP" type="TABLE">
         <column autoIncrement="true" dbType="BIGINT"
@@ -250,7 +254,7 @@
         <column dbType="BIGINT" javaType="java.math.BigDecimal"
             name="PRODUCTS_OPTION_VALUE_ID" required="true" type="BIGINT"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
-            name="DATE_ADDED" type="TIMESTAMP"/>
+            name="DATE_ADDED" required="true" type="TIMESTAMP"/>
         <foreign-key foreignTable="CUSTOMER" name="FK_CUSTOMERS_BASKET_ATTRIBUTES_1">
             <reference foreign="CUSTOMER_ID" local="CUSTOMER_ID"/>
         </foreign-key>
@@ -308,9 +312,9 @@
         <column dbType="VARCHAR" javaType="String" name="NAME"
             required="true" size="32" type="VARCHAR"/>
         <column dbType="VARCHAR" javaType="String" name="DESCRIPTION"
-            required="true" size="255" type="VARCHAR"/>
+            size="255" type="VARCHAR"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
-            name="LAST_MODIFIED" type="TIMESTAMP"/>
+            name="LAST_MODIFIED" required="true" type="TIMESTAMP"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
             name="DATE_ADDED" required="true" type="TIMESTAMP"/>
     </table>
@@ -340,9 +344,9 @@
         <column dbType="VARCHAR" javaType="String" name="IMAGE"
             size="64" type="VARCHAR"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
-            name="DATE_ADDED" type="TIMESTAMP"/>
+            name="DATE_ADDED" required="true" type="TIMESTAMP"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
-            name="LAST_MODIFIED" type="TIMESTAMP"/>
+            name="LAST_MODIFIED" required="true" type="TIMESTAMP"/>
     </table>
     <table name="MANUFACTURER_DESCRIPTION" schema="APP" type="TABLE">
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
@@ -485,11 +489,11 @@
         <column dbType="VARCHAR" javaType="String"
             name="DELIVERY_METHOD_CODE" required="true" size="16" type="VARCHAR"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
-            name="LAST_MODIFIED" type="TIMESTAMP"/>
+            name="LAST_MODIFIED" required="true" type="TIMESTAMP"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="ORDER_STATUS_ID" required="true" type="INTEGER"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
-            name="PURCHASED_DATE" type="TIMESTAMP"/>
+            name="PURCHASED_DATE" required="true" type="TIMESTAMP"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
             name="FINISHED_DATE" type="TIMESTAMP"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
@@ -705,7 +709,7 @@
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
             name="DATE_ADDED" required="true" type="TIMESTAMP"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
-            name="LAST_MODIFIED" type="TIMESTAMP"/>
+            name="LAST_MODIFIED" required="true" type="TIMESTAMP"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
             name="DATE_AVAILABLE" type="TIMESTAMP"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
@@ -882,9 +886,9 @@
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="RATING" type="INTEGER"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
-            name="DATE_ADDED" type="TIMESTAMP"/>
+            name="DATE_ADDED" required="true" type="TIMESTAMP"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
-            name="LAST_MODIFIED" type="TIMESTAMP"/>
+            name="LAST_MODIFIED" required="true" type="TIMESTAMP"/>
         <foreign-key foreignTable="CUSTOMER" name="FK_REVIEWS_2">
             <reference foreign="CUSTOMER_ID" local="CUSTOMER_ID"/>
         </foreign-key>
@@ -914,9 +918,9 @@
         <column dbType="VARCHAR" javaType="String" name="NAME"
             required="true" size="32" type="VARCHAR"/>
         <column dbType="VARCHAR" javaType="String" name="DESCRIPTION"
-            required="true" size="255" type="VARCHAR"/>
+            size="255" type="VARCHAR"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
-            name="LAST_MODIFIED" type="TIMESTAMP"/>
+            name="LAST_MODIFIED" required="true" type="TIMESTAMP"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
             name="DATE_ADDED" required="true" type="TIMESTAMP"/>
     </table>
@@ -934,9 +938,9 @@
         <column dbType="DECIMAL" javaType="java.math.BigDecimal"
             name="RATE" required="true" size="7" type="DECIMAL"/>
         <column dbType="VARCHAR" javaType="String" name="DESCRIPTION"
-            required="true" size="255" type="VARCHAR"/>
+            size="255" type="VARCHAR"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
-            name="LAST_MODIFIED" type="TIMESTAMP"/>
+            name="LAST_MODIFIED" required="true" type="TIMESTAMP"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
             name="DATE_ADDED" required="true" type="TIMESTAMP"/>
         <foreign-key foreignTable="TAX_CLASS" name="FK_TAX_RATES_1">
@@ -973,7 +977,7 @@
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="GEO_ZONE_ID" type="INTEGER"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
-            name="LAST_MODIFIED" type="TIMESTAMP"/>
+            name="LAST_MODIFIED" required="true" type="TIMESTAMP"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
             name="DATE_ADDED" required="true" type="TIMESTAMP"/>
         <foreign-key foreignTable="COUNTRY" name="FK_ZONES_TO_GEO_ZONES_3">

Modified: pompei/portlets/pompei-core/trunk/src/main/config/pompei.clay
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/config/pompei.clay	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/config/pompei.clay	2007-09-25 07:09:39 UTC (rev 582)
@@ -219,30 +219,40 @@
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
+<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n)"/>
+<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) UNSIGNED"/>
+<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) UNSIGNED ZEROFILL"/>
+<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) ZEROFILL"/>
+<variant type-name-pattern="INTEGER UNSIGNED"/>
+<variant type-name-pattern="INTEGER UNSIGNED ZEROFILL"/>
+<variant type-name-pattern="INTEGER ZEROFILL"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="SORT_ORDER" remarks="" uid="1350e24:11525502e7d:-7fe3">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="true" name="SORT_ORDER" remarks="" uid="1350e24:11525502e7d:-7fe3">
 <column-description></column-description>
 <data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
 <variant type-name-pattern="INTEGER"/>
+<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n)"/>
+<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) UNSIGNED"/>
+<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) UNSIGNED ZEROFILL"/>
+<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) ZEROFILL"/>
+<variant type-name-pattern="INTEGER UNSIGNED"/>
+<variant type-name-pattern="INTEGER UNSIGNED ZEROFILL"/>
+<variant type-name-pattern="INTEGER ZEROFILL"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="DATE_ADDED" remarks="" uid="1350e24:11525502e7d:-7fe2">
+<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="true" name="DATE_ADDED" remarks="" uid="1350e24:11525502e7d:-7fe2">
 <column-description></column-description>
-<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
+<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
 <variant type-name-pattern="TIMESTAMP"/>
-<variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
+<variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="LAST_MODIFIED" remarks="" uid="1350e24:11525502e7d:-7fe1">
+<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="true" name="LAST_MODIFIED" remarks="" uid="1350e24:11525502e7d:-7fe1">
 <column-description></column-description>
-<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
+<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
 <variant type-name-pattern="TIMESTAMP"/>
-<variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
+<variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
 </data-type>
 </column>
 </column-list>
@@ -395,7 +405,7 @@
 </table>
 <table alias="" name="CUSTOMER" remarks="" uid="1350e24:11525502e7d:-7fd0">
 <table-description></table-description>
-<table-figure-bounds height="173" width="244" x="2328" y="787"/>
+<table-figure-bounds height="201" width="244" x="2328" y="787"/>
 <column-list>
 <column alias="" auto-increment="true" column-size="0" decimal-digits="0" default-value="" mandatory="true" name="CUSTOMER_ID" remarks="" uid="1350e24:11525502e7d:-7fce">
 <column-description></column-description>
@@ -455,6 +465,20 @@
 <variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
 </data-type>
 </column>
+<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="true" name="LAST_MODIFIED" remarks="" uid="554210:1153a1d1f91:-7fcd">
+<column-description></column-description>
+<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
+<variant type-name-pattern="TIMESTAMP"/>
+<variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
+</data-type>
+</column>
+<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="true" name="DATE_ADDED" remarks="" uid="554210:1153a1d1f91:-7fcc">
+<column-description></column-description>
+<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
+<variant type-name-pattern="TIMESTAMP"/>
+<variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
+</data-type>
+</column>
 </column-list>
 <primary-key alias="" name="SQL070831021755080" remarks="" uid="1350e24:11525502e7d:-7fcf">
 <primary-key-description></primary-key-description>
@@ -641,11 +665,11 @@
 <variant type-name-pattern="BIGINT ZEROFILL"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="false" name="DATE_ADDED" remarks="" uid="1350e24:11525502e7d:-7fb4">
+<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="true" name="DATE_ADDED" remarks="" uid="1350e24:11525502e7d:-7fb4">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
+<variant type-name-pattern="TIMESTAMP"/>
 <variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
-<variant type-name-pattern="TIMESTAMP"/>
 </data-type>
 </column>
 </column-list>
@@ -857,20 +881,18 @@
 <variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="255" decimal-digits="0" default-value="" mandatory="true" name="DESCRIPTION" remarks="" uid="1350e24:11525502e7d:-7f9c">
+<column alias="" auto-increment="false" column-size="255" decimal-digits="0" default-value="" mandatory="false" name="DESCRIPTION" remarks="" uid="1350e24:11525502e7d:-7f9c">
 <column-description></column-description>
 <data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
 <variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
 <variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="LAST_MODIFIED" remarks="" uid="1350e24:11525502e7d:-7f9b">
+<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="true" name="LAST_MODIFIED" remarks="" uid="1350e24:11525502e7d:-7f9b">
 <column-description></column-description>
-<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
+<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
 <variant type-name-pattern="TIMESTAMP"/>
-<variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
+<variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="true" name="DATE_ADDED" remarks="" uid="1350e24:11525502e7d:-7f9a">
@@ -990,22 +1012,18 @@
 <variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="DATE_ADDED" remarks="" uid="1350e24:11525502e7d:-7f8a">
+<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="true" name="DATE_ADDED" remarks="" uid="1350e24:11525502e7d:-7f8a">
 <column-description></column-description>
-<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
+<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
 <variant type-name-pattern="TIMESTAMP"/>
-<variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
+<variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="LAST_MODIFIED" remarks="" uid="1350e24:11525502e7d:-7f89">
+<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="true" name="LAST_MODIFIED" remarks="" uid="1350e24:11525502e7d:-7f89">
 <column-description></column-description>
-<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
+<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
 <variant type-name-pattern="TIMESTAMP"/>
-<variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
+<variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
 </data-type>
 </column>
 </column-list>
@@ -1463,13 +1481,11 @@
 <variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="LAST_MODIFIED" remarks="" uid="1350e24:11525502e7d:-7f4e">
+<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="true" name="LAST_MODIFIED" remarks="" uid="1350e24:11525502e7d:-7f4e">
 <column-description></column-description>
-<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
+<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
 <variant type-name-pattern="TIMESTAMP"/>
-<variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
+<variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="true" name="ORDER_STATUS_ID" remarks="" uid="1350e24:11525502e7d:-7f4d">
@@ -1485,11 +1501,11 @@
 <variant type-name-pattern="INTEGER ZEROFILL"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="false" name="PURCHASED_DATE" remarks="" uid="1350e24:11525502e7d:-7f4c">
+<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="true" name="PURCHASED_DATE" remarks="" uid="1350e24:11525502e7d:-7f4c">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
+<variant type-name-pattern="TIMESTAMP"/>
 <variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
-<variant type-name-pattern="TIMESTAMP"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="false" name="FINISHED_DATE" remarks="" uid="1350e24:11525502e7d:-7f4b">
@@ -2295,11 +2311,11 @@
 <variant type-name-pattern="TIMESTAMP"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="false" name="LAST_MODIFIED" remarks="" uid="1350e24:11525502e7d:-7efd">
+<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="true" name="LAST_MODIFIED" remarks="" uid="1350e24:11525502e7d:-7efd">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
+<variant type-name-pattern="TIMESTAMP"/>
 <variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
-<variant type-name-pattern="TIMESTAMP"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="false" name="DATE_AVAILABLE" remarks="" uid="1350e24:11525502e7d:-7efc">
@@ -2986,22 +3002,18 @@
 <variant type-name-pattern="INTEGER ZEROFILL"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="DATE_ADDED" remarks="" uid="1350e24:11525502e7d:-7eba">
+<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="true" name="DATE_ADDED" remarks="" uid="1350e24:11525502e7d:-7eba">
 <column-description></column-description>
-<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
+<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
 <variant type-name-pattern="TIMESTAMP"/>
-<variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
+<variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="LAST_MODIFIED" remarks="" uid="1350e24:11525502e7d:-7eb9">
+<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="true" name="LAST_MODIFIED" remarks="" uid="1350e24:11525502e7d:-7eb9">
 <column-description></column-description>
-<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
+<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
 <variant type-name-pattern="TIMESTAMP"/>
-<variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
+<variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
 </data-type>
 </column>
 </column-list>
@@ -3102,7 +3114,7 @@
 </table>
 <table alias="" name="BARGAIN" remarks="" uid="1350e24:11525502e7d:-7eb1">
 <table-description></table-description>
-<table-figure-bounds height="163" width="308" x="3027" y="3221"/>
+<table-figure-bounds height="163" width="308" x="2751" y="3207"/>
 <column-list>
 <column alias="" auto-increment="true" column-size="0" decimal-digits="0" default-value="" mandatory="true" name="BARGAIN_ID" remarks="" uid="1350e24:11525502e7d:-7eaf">
 <column-description></column-description>
@@ -3143,18 +3155,18 @@
 <variant precision-max="17" precision-min="0" precision-variable="%p" scale-max="128" scale-min="0" scale-variable="%s" type-name-pattern="DECIMAL(%p, %s) ZEROFILL"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="false" name="DATE_ADDED" remarks="" uid="1350e24:11525502e7d:-7eac">
+<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="true" name="DATE_ADDED" remarks="" uid="1350e24:11525502e7d:-7eac">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
+<variant type-name-pattern="TIMESTAMP"/>
 <variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
-<variant type-name-pattern="TIMESTAMP"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="false" name="LAST_MODIFIED" remarks="" uid="1350e24:11525502e7d:-7eab">
+<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="true" name="LAST_MODIFIED" remarks="" uid="1350e24:11525502e7d:-7eab">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
+<variant type-name-pattern="TIMESTAMP"/>
 <variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
-<variant type-name-pattern="TIMESTAMP"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="false" name="START_DATE" remarks="" uid="1350e24:11525502e7d:-7eaa">
@@ -3223,20 +3235,18 @@
 <variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="255" decimal-digits="0" default-value="" mandatory="true" name="DESCRIPTION" remarks="" uid="1350e24:11525502e7d:-7ea2">
+<column alias="" auto-increment="false" column-size="255" decimal-digits="0" default-value="" mandatory="false" name="DESCRIPTION" remarks="" uid="1350e24:11525502e7d:-7ea2">
 <column-description></column-description>
 <data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
 <variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
 <variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="LAST_MODIFIED" remarks="" uid="1350e24:11525502e7d:-7ea1">
+<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="true" name="LAST_MODIFIED" remarks="" uid="1350e24:11525502e7d:-7ea1">
 <column-description></column-description>
-<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
+<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
 <variant type-name-pattern="TIMESTAMP"/>
-<variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
+<variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="true" name="DATE_ADDED" remarks="" uid="1350e24:11525502e7d:-7ea0">
@@ -3324,20 +3334,18 @@
 <variant precision-max="17" precision-min="0" precision-variable="%p" scale-max="128" scale-min="0" scale-variable="%s" type-name-pattern="DECIMAL(%p, %s) ZEROFILL"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="255" decimal-digits="0" default-value="" mandatory="true" name="DESCRIPTION" remarks="" uid="1350e24:11525502e7d:-7e97">
+<column alias="" auto-increment="false" column-size="255" decimal-digits="0" default-value="" mandatory="false" name="DESCRIPTION" remarks="" uid="1350e24:11525502e7d:-7e97">
 <column-description></column-description>
 <data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
 <variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
 <variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="LAST_MODIFIED" remarks="" uid="1350e24:11525502e7d:-7e96">
+<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="true" name="LAST_MODIFIED" remarks="" uid="1350e24:11525502e7d:-7e96">
 <column-description></column-description>
-<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
+<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
 <variant type-name-pattern="TIMESTAMP"/>
-<variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
+<variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="true" name="DATE_ADDED" remarks="" uid="1350e24:11525502e7d:-7e95">
@@ -3478,13 +3486,11 @@
 <variant type-name-pattern="INTEGER"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="LAST_MODIFIED" remarks="" uid="1350e24:11525502e7d:-7e86">
+<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="true" name="LAST_MODIFIED" remarks="" uid="1350e24:11525502e7d:-7e86">
 <column-description></column-description>
-<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
+<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
 <variant type-name-pattern="TIMESTAMP"/>
-<variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
+<variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="true" name="DATE_ADDED" remarks="" uid="1350e24:11525502e7d:-7e85">

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsCustomerBhv.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsCustomerBhv.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsCustomerBhv.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -30,7 +30,7 @@
  *     CUSTOMER_ID
  * 
  * [column-property]
- *     CUSTOMER_ID, PORTAL_ID, GENDER, FIRSTNAME, LASTNAME, NICKNAME, DAY_OF_BIRTH, EMAIL_ADDRESS
+ *     CUSTOMER_ID, PORTAL_ID, GENDER, FIRSTNAME, LASTNAME, NICKNAME, DAY_OF_BIRTH, EMAIL_ADDRESS, LAST_MODIFIED, DATE_ADDED
  * 
  * [foreign-property]
  *     
@@ -1524,6 +1524,8 @@
         if (names.contains("nickname")) { destinationMyEntity.setNickname(sourceMyEntity.getNickname()); }
         if (names.contains("dayOfBirth")) { destinationMyEntity.setDayOfBirth(sourceMyEntity.getDayOfBirth()); }
         if (names.contains("emailAddress")) { destinationMyEntity.setEmailAddress(sourceMyEntity.getEmailAddress()); }
+        if (names.contains("lastModified")) { destinationMyEntity.setLastModified(sourceMyEntity.getLastModified()); }
+        if (names.contains("dateAdded")) { destinationMyEntity.setDateAdded(sourceMyEntity.getDateAdded()); }
 
     }
 

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsCustomerDao.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsCustomerDao.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsCustomerDao.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -11,7 +11,7 @@
  *     CUSTOMER_ID
  * 
  * [column-property]
- *     CUSTOMER_ID, PORTAL_ID, GENDER, FIRSTNAME, LASTNAME, NICKNAME, DAY_OF_BIRTH, EMAIL_ADDRESS
+ *     CUSTOMER_ID, PORTAL_ID, GENDER, FIRSTNAME, LASTNAME, NICKNAME, DAY_OF_BIRTH, EMAIL_ADDRESS, LAST_MODIFIED, DATE_ADDED
  * 
  * [foreign-property]
  *     
@@ -51,7 +51,7 @@
     public int getCountAll();
 
     /** SQL-Annotation for getListAll(). */
-    public static final String getListAll_SQL = "select CUSTOMER_ID, PORTAL_ID, GENDER, FIRSTNAME, LASTNAME, NICKNAME, DAY_OF_BIRTH, EMAIL_ADDRESS from CUSTOMER";
+    public static final String getListAll_SQL = "select CUSTOMER_ID, PORTAL_ID, GENDER, FIRSTNAME, LASTNAME, NICKNAME, DAY_OF_BIRTH, EMAIL_ADDRESS, LAST_MODIFIED, DATE_ADDED from CUSTOMER";
 
     /**
      * Get list as all.
@@ -61,7 +61,7 @@
     public java.util.List<Customer> getListAll();
 
     /** SQL-Annotation for getEntity(). */
-    public static final String getEntity_SQL = "select CUSTOMER_ID, PORTAL_ID, GENDER, FIRSTNAME, LASTNAME, NICKNAME, DAY_OF_BIRTH, EMAIL_ADDRESS from CUSTOMER where CUSTOMER.CUSTOMER_ID = /*customerId*/null";
+    public static final String getEntity_SQL = "select CUSTOMER_ID, PORTAL_ID, GENDER, FIRSTNAME, LASTNAME, NICKNAME, DAY_OF_BIRTH, EMAIL_ADDRESS, LAST_MODIFIED, DATE_ADDED from CUSTOMER where CUSTOMER.CUSTOMER_ID = /*customerId*/null";
 
     /** Args-Annotation for getEntity(). */
     public static final String getEntity_ARGS = "customerId";

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsBargain.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsBargain.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsBargain.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -66,10 +66,10 @@
     /** The value of bargainPrice. DECIMAL(15) : NotNull */
     protected java.math.BigDecimal _bargainPrice;
 
-    /** The value of dateAdded. TIMESTAMP */
+    /** The value of dateAdded. TIMESTAMP : NotNull */
     protected java.sql.Timestamp _dateAdded;
 
-    /** The value of lastModified. TIMESTAMP */
+    /** The value of lastModified. TIMESTAMP : NotNull */
     protected java.sql.Timestamp _lastModified;
 
     /** The value of startDate. TIMESTAMP */
@@ -218,12 +218,12 @@
         this._bargainPrice = bargainPrice;
     }
 
-    /** Column Annotation for S2Dao. TIMESTAMP */
+    /** Column Annotation for S2Dao. TIMESTAMP : NotNull */
     public static final String dateAdded_COLUMN = "DATE_ADDED";
 
     /**
      * Get the value of dateAdded. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @return The value of dateAdded. (Nullable)
      */
@@ -233,7 +233,7 @@
 
     /**
      * Set the value of dateAdded. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @param dateAdded The value of dateAdded. (Nullable)
      */
@@ -242,12 +242,12 @@
         this._dateAdded = dateAdded;
     }
 
-    /** Column Annotation for S2Dao. TIMESTAMP */
+    /** Column Annotation for S2Dao. TIMESTAMP : NotNull */
     public static final String lastModified_COLUMN = "LAST_MODIFIED";
 
     /**
      * Get the value of lastModified. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @return The value of lastModified. (Nullable)
      */
@@ -257,7 +257,7 @@
 
     /**
      * Set the value of lastModified. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @param lastModified The value of lastModified. (Nullable)
      */

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsCategory.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsCategory.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsCategory.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -66,13 +66,13 @@
     /** The value of parentId. INTEGER : Default=[0] : FK to CATEGORY */
     protected java.math.BigDecimal _parentId;
 
-    /** The value of sortOrder. INTEGER */
+    /** The value of sortOrder. INTEGER : NotNull */
     protected java.math.BigDecimal _sortOrder;
 
-    /** The value of dateAdded. TIMESTAMP */
+    /** The value of dateAdded. TIMESTAMP : NotNull */
     protected java.sql.Timestamp _dateAdded;
 
-    /** The value of lastModified. TIMESTAMP */
+    /** The value of lastModified. TIMESTAMP : NotNull */
     protected java.sql.Timestamp _lastModified;
 
     // ===================================================================================
@@ -212,12 +212,12 @@
         this._parentId = parentId;
     }
 
-    /** Column Annotation for S2Dao. INTEGER */
+    /** Column Annotation for S2Dao. INTEGER : NotNull */
     public static final String sortOrder_COLUMN = "SORT_ORDER";
 
     /**
      * Get the value of sortOrder. <br />
-     * {INTEGER}
+     * {INTEGER : NotNull}
      * 
      * @return The value of sortOrder. (Nullable)
      */
@@ -227,7 +227,7 @@
 
     /**
      * Set the value of sortOrder. <br />
-     * {INTEGER}
+     * {INTEGER : NotNull}
      * 
      * @param sortOrder The value of sortOrder. (Nullable)
      */
@@ -236,12 +236,12 @@
         this._sortOrder = sortOrder;
     }
 
-    /** Column Annotation for S2Dao. TIMESTAMP */
+    /** Column Annotation for S2Dao. TIMESTAMP : NotNull */
     public static final String dateAdded_COLUMN = "DATE_ADDED";
 
     /**
      * Get the value of dateAdded. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @return The value of dateAdded. (Nullable)
      */
@@ -251,7 +251,7 @@
 
     /**
      * Set the value of dateAdded. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @param dateAdded The value of dateAdded. (Nullable)
      */
@@ -260,12 +260,12 @@
         this._dateAdded = dateAdded;
     }
 
-    /** Column Annotation for S2Dao. TIMESTAMP */
+    /** Column Annotation for S2Dao. TIMESTAMP : NotNull */
     public static final String lastModified_COLUMN = "LAST_MODIFIED";
 
     /**
      * Get the value of lastModified. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @return The value of lastModified. (Nullable)
      */
@@ -275,7 +275,7 @@
 
     /**
      * Set the value of lastModified. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @param lastModified The value of lastModified. (Nullable)
      */

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsCustomer.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsCustomer.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsCustomer.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -14,7 +14,7 @@
  *     CUSTOMER_ID
  * 
  * [column-property]
- *     CUSTOMER_ID, PORTAL_ID, GENDER, FIRSTNAME, LASTNAME, NICKNAME, DAY_OF_BIRTH, EMAIL_ADDRESS
+ *     CUSTOMER_ID, PORTAL_ID, GENDER, FIRSTNAME, LASTNAME, NICKNAME, DAY_OF_BIRTH, EMAIL_ADDRESS, LAST_MODIFIED, DATE_ADDED
  * 
  * [foreign-property]
  *     
@@ -81,6 +81,12 @@
     /** The value of emailAddress. VARCHAR(128) : NotNull */
     protected String _emailAddress;
 
+    /** The value of lastModified. TIMESTAMP : NotNull */
+    protected java.sql.Timestamp _lastModified;
+
+    /** The value of dateAdded. TIMESTAMP : NotNull */
+    protected java.sql.Timestamp _dateAdded;
+
     // ===================================================================================
     //                                                                         Constructor
     //                                                                         ===========
@@ -338,20 +344,68 @@
         this._emailAddress = emailAddress;
     }
 
+    /** Column Annotation for S2Dao. TIMESTAMP : NotNull */
+    public static final String lastModified_COLUMN = "LAST_MODIFIED";
 
+    /**
+     * Get the value of lastModified. <br />
+     * {TIMESTAMP : NotNull}
+     * 
+     * @return The value of lastModified. (Nullable)
+     */
+    public java.sql.Timestamp getLastModified() {
+        return _lastModified;
+    }
+
+    /**
+     * Set the value of lastModified. <br />
+     * {TIMESTAMP : NotNull}
+     * 
+     * @param lastModified The value of lastModified. (Nullable)
+     */
+    public void setLastModified(java.sql.Timestamp lastModified) {
+        _modifiedProperties.addPropertyName("lastModified");
+        this._lastModified = lastModified;
+    }
+
+    /** Column Annotation for S2Dao. TIMESTAMP : NotNull */
+    public static final String dateAdded_COLUMN = "DATE_ADDED";
+
+    /**
+     * Get the value of dateAdded. <br />
+     * {TIMESTAMP : NotNull}
+     * 
+     * @return The value of dateAdded. (Nullable)
+     */
+    public java.sql.Timestamp getDateAdded() {
+        return _dateAdded;
+    }
+
+    /**
+     * Set the value of dateAdded. <br />
+     * {TIMESTAMP : NotNull}
+     * 
+     * @param dateAdded The value of dateAdded. (Nullable)
+     */
+    public void setDateAdded(java.sql.Timestamp dateAdded) {
+        _modifiedProperties.addPropertyName("dateAdded");
+        this._dateAdded = dateAdded;
+    }
+
+
     // ===================================================================================
     //                                                                     Classify Method
     //                                                                     ===============
-                
+                    
     // ===================================================================================
     //                                                        Classification Determination
     //                                                        ============================
-                
+                    
 
     // ===================================================================================
     //                                                               Classification Getter
     //                                                               =====================
-                
+                    
 
     // ===================================================================================
     //                                                                       Foreign Table
@@ -640,6 +694,8 @@
         sb.append(delimiter).append(getNickname());
         sb.append(delimiter).append(getDayOfBirth());
         sb.append(delimiter).append(getEmailAddress());
+        sb.append(delimiter).append(getLastModified());
+        sb.append(delimiter).append(getDateAdded());
 
         sb.delete(0, delimiter.length());
         sb.insert(0, "{").append("}");

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsCustomerBasketAttribute.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsCustomerBasketAttribute.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsCustomerBasketAttribute.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -72,7 +72,7 @@
     /** The value of productsOptionValueId. BIGINT : NotNull : FK to PRODUCT_OPTION_VALUE */
     protected java.math.BigDecimal _productsOptionValueId;
 
-    /** The value of dateAdded. TIMESTAMP */
+    /** The value of dateAdded. TIMESTAMP : NotNull */
     protected java.sql.Timestamp _dateAdded;
 
     // ===================================================================================
@@ -260,12 +260,12 @@
         this._productsOptionValueId = productsOptionValueId;
     }
 
-    /** Column Annotation for S2Dao. TIMESTAMP */
+    /** Column Annotation for S2Dao. TIMESTAMP : NotNull */
     public static final String dateAdded_COLUMN = "DATE_ADDED";
 
     /**
      * Get the value of dateAdded. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @return The value of dateAdded. (Nullable)
      */
@@ -275,7 +275,7 @@
 
     /**
      * Set the value of dateAdded. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @param dateAdded The value of dateAdded. (Nullable)
      */

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsGeoZone.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsGeoZone.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsGeoZone.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -63,10 +63,10 @@
     /** The value of name. VARCHAR(32) : NotNull */
     protected String _name;
 
-    /** The value of description. VARCHAR(255) : NotNull */
+    /** The value of description. VARCHAR(255) */
     protected String _description;
 
-    /** The value of lastModified. TIMESTAMP */
+    /** The value of lastModified. TIMESTAMP : NotNull */
     protected java.sql.Timestamp _lastModified;
 
     /** The value of dateAdded. TIMESTAMP : NotNull */
@@ -185,12 +185,12 @@
         this._name = name;
     }
 
-    /** Column Annotation for S2Dao. VARCHAR(255) : NotNull */
+    /** Column Annotation for S2Dao. VARCHAR(255) */
     public static final String description_COLUMN = "DESCRIPTION";
 
     /**
      * Get the value of description. <br />
-     * {VARCHAR(255) : NotNull}
+     * {VARCHAR(255)}
      * 
      * @return The value of description. (Nullable)
      */
@@ -200,7 +200,7 @@
 
     /**
      * Set the value of description. <br />
-     * {VARCHAR(255) : NotNull}
+     * {VARCHAR(255)}
      * 
      * @param description The value of description. (Nullable)
      */
@@ -209,12 +209,12 @@
         this._description = description;
     }
 
-    /** Column Annotation for S2Dao. TIMESTAMP */
+    /** Column Annotation for S2Dao. TIMESTAMP : NotNull */
     public static final String lastModified_COLUMN = "LAST_MODIFIED";
 
     /**
      * Get the value of lastModified. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @return The value of lastModified. (Nullable)
      */
@@ -224,7 +224,7 @@
 
     /**
      * Set the value of lastModified. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @param lastModified The value of lastModified. (Nullable)
      */

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsManufacturer.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsManufacturer.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsManufacturer.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -66,10 +66,10 @@
     /** The value of image. VARCHAR(64) */
     protected String _image;
 
-    /** The value of dateAdded. TIMESTAMP */
+    /** The value of dateAdded. TIMESTAMP : NotNull */
     protected java.sql.Timestamp _dateAdded;
 
-    /** The value of lastModified. TIMESTAMP */
+    /** The value of lastModified. TIMESTAMP : NotNull */
     protected java.sql.Timestamp _lastModified;
 
     // ===================================================================================
@@ -209,12 +209,12 @@
         this._image = image;
     }
 
-    /** Column Annotation for S2Dao. TIMESTAMP */
+    /** Column Annotation for S2Dao. TIMESTAMP : NotNull */
     public static final String dateAdded_COLUMN = "DATE_ADDED";
 
     /**
      * Get the value of dateAdded. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @return The value of dateAdded. (Nullable)
      */
@@ -224,7 +224,7 @@
 
     /**
      * Set the value of dateAdded. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @param dateAdded The value of dateAdded. (Nullable)
      */
@@ -233,12 +233,12 @@
         this._dateAdded = dateAdded;
     }
 
-    /** Column Annotation for S2Dao. TIMESTAMP */
+    /** Column Annotation for S2Dao. TIMESTAMP : NotNull */
     public static final String lastModified_COLUMN = "LAST_MODIFIED";
 
     /**
      * Get the value of lastModified. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @return The value of lastModified. (Nullable)
      */
@@ -248,7 +248,7 @@
 
     /**
      * Set the value of lastModified. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @param lastModified The value of lastModified. (Nullable)
      */

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsOrderForm.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsOrderForm.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsOrderForm.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -198,13 +198,13 @@
     /** The value of deliveryMethodCode. VARCHAR(16) : NotNull */
     protected String _deliveryMethodCode;
 
-    /** The value of lastModified. TIMESTAMP */
+    /** The value of lastModified. TIMESTAMP : NotNull */
     protected java.sql.Timestamp _lastModified;
 
     /** The value of orderStatusId. INTEGER : NotNull : FK to ORDER_STATUS */
     protected java.math.BigDecimal _orderStatusId;
 
-    /** The value of purchasedDate. TIMESTAMP */
+    /** The value of purchasedDate. TIMESTAMP : NotNull */
     protected java.sql.Timestamp _purchasedDate;
 
     /** The value of finishedDate. TIMESTAMP */
@@ -1421,12 +1421,12 @@
         this._deliveryMethodCode = deliveryMethodCode;
     }
 
-    /** Column Annotation for S2Dao. TIMESTAMP */
+    /** Column Annotation for S2Dao. TIMESTAMP : NotNull */
     public static final String lastModified_COLUMN = "LAST_MODIFIED";
 
     /**
      * Get the value of lastModified. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @return The value of lastModified. (Nullable)
      */
@@ -1436,7 +1436,7 @@
 
     /**
      * Set the value of lastModified. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @param lastModified The value of lastModified. (Nullable)
      */
@@ -1469,12 +1469,12 @@
         this._orderStatusId = orderStatusId;
     }
 
-    /** Column Annotation for S2Dao. TIMESTAMP */
+    /** Column Annotation for S2Dao. TIMESTAMP : NotNull */
     public static final String purchasedDate_COLUMN = "PURCHASED_DATE";
 
     /**
      * Get the value of purchasedDate. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @return The value of purchasedDate. (Nullable)
      */
@@ -1484,7 +1484,7 @@
 
     /**
      * Set the value of purchasedDate. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @param purchasedDate The value of purchasedDate. (Nullable)
      */

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProduct.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProduct.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProduct.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -87,7 +87,7 @@
     /** The value of dateAdded. TIMESTAMP : NotNull */
     protected java.sql.Timestamp _dateAdded;
 
-    /** The value of lastModified. TIMESTAMP */
+    /** The value of lastModified. TIMESTAMP : NotNull */
     protected java.sql.Timestamp _lastModified;
 
     /** The value of dateAvailable. TIMESTAMP */
@@ -404,12 +404,12 @@
         this._dateAdded = dateAdded;
     }
 
-    /** Column Annotation for S2Dao. TIMESTAMP */
+    /** Column Annotation for S2Dao. TIMESTAMP : NotNull */
     public static final String lastModified_COLUMN = "LAST_MODIFIED";
 
     /**
      * Get the value of lastModified. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @return The value of lastModified. (Nullable)
      */
@@ -419,7 +419,7 @@
 
     /**
      * Set the value of lastModified. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @param lastModified The value of lastModified. (Nullable)
      */

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsReview.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsReview.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsReview.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -72,10 +72,10 @@
     /** The value of rating. INTEGER */
     protected java.math.BigDecimal _rating;
 
-    /** The value of dateAdded. TIMESTAMP */
+    /** The value of dateAdded. TIMESTAMP : NotNull */
     protected java.sql.Timestamp _dateAdded;
 
-    /** The value of lastModified. TIMESTAMP */
+    /** The value of lastModified. TIMESTAMP : NotNull */
     protected java.sql.Timestamp _lastModified;
 
     // ===================================================================================
@@ -263,12 +263,12 @@
         this._rating = rating;
     }
 
-    /** Column Annotation for S2Dao. TIMESTAMP */
+    /** Column Annotation for S2Dao. TIMESTAMP : NotNull */
     public static final String dateAdded_COLUMN = "DATE_ADDED";
 
     /**
      * Get the value of dateAdded. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @return The value of dateAdded. (Nullable)
      */
@@ -278,7 +278,7 @@
 
     /**
      * Set the value of dateAdded. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @param dateAdded The value of dateAdded. (Nullable)
      */
@@ -287,12 +287,12 @@
         this._dateAdded = dateAdded;
     }
 
-    /** Column Annotation for S2Dao. TIMESTAMP */
+    /** Column Annotation for S2Dao. TIMESTAMP : NotNull */
     public static final String lastModified_COLUMN = "LAST_MODIFIED";
 
     /**
      * Get the value of lastModified. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @return The value of lastModified. (Nullable)
      */
@@ -302,7 +302,7 @@
 
     /**
      * Set the value of lastModified. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @param lastModified The value of lastModified. (Nullable)
      */

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsTaxClass.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsTaxClass.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsTaxClass.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -63,10 +63,10 @@
     /** The value of name. VARCHAR(32) : NotNull */
     protected String _name;
 
-    /** The value of description. VARCHAR(255) : NotNull */
+    /** The value of description. VARCHAR(255) */
     protected String _description;
 
-    /** The value of lastModified. TIMESTAMP */
+    /** The value of lastModified. TIMESTAMP : NotNull */
     protected java.sql.Timestamp _lastModified;
 
     /** The value of dateAdded. TIMESTAMP : NotNull */
@@ -185,12 +185,12 @@
         this._name = name;
     }
 
-    /** Column Annotation for S2Dao. VARCHAR(255) : NotNull */
+    /** Column Annotation for S2Dao. VARCHAR(255) */
     public static final String description_COLUMN = "DESCRIPTION";
 
     /**
      * Get the value of description. <br />
-     * {VARCHAR(255) : NotNull}
+     * {VARCHAR(255)}
      * 
      * @return The value of description. (Nullable)
      */
@@ -200,7 +200,7 @@
 
     /**
      * Set the value of description. <br />
-     * {VARCHAR(255) : NotNull}
+     * {VARCHAR(255)}
      * 
      * @param description The value of description. (Nullable)
      */
@@ -209,12 +209,12 @@
         this._description = description;
     }
 
-    /** Column Annotation for S2Dao. TIMESTAMP */
+    /** Column Annotation for S2Dao. TIMESTAMP : NotNull */
     public static final String lastModified_COLUMN = "LAST_MODIFIED";
 
     /**
      * Get the value of lastModified. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @return The value of lastModified. (Nullable)
      */
@@ -224,7 +224,7 @@
 
     /**
      * Set the value of lastModified. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @param lastModified The value of lastModified. (Nullable)
      */

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsTaxRate.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsTaxRate.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsTaxRate.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -72,10 +72,10 @@
     /** The value of rate. DECIMAL(7) : NotNull */
     protected java.math.BigDecimal _rate;
 
-    /** The value of description. VARCHAR(255) : NotNull */
+    /** The value of description. VARCHAR(255) */
     protected String _description;
 
-    /** The value of lastModified. TIMESTAMP */
+    /** The value of lastModified. TIMESTAMP : NotNull */
     protected java.sql.Timestamp _lastModified;
 
     /** The value of dateAdded. TIMESTAMP : NotNull */
@@ -266,12 +266,12 @@
         this._rate = rate;
     }
 
-    /** Column Annotation for S2Dao. VARCHAR(255) : NotNull */
+    /** Column Annotation for S2Dao. VARCHAR(255) */
     public static final String description_COLUMN = "DESCRIPTION";
 
     /**
      * Get the value of description. <br />
-     * {VARCHAR(255) : NotNull}
+     * {VARCHAR(255)}
      * 
      * @return The value of description. (Nullable)
      */
@@ -281,7 +281,7 @@
 
     /**
      * Set the value of description. <br />
-     * {VARCHAR(255) : NotNull}
+     * {VARCHAR(255)}
      * 
      * @param description The value of description. (Nullable)
      */
@@ -290,12 +290,12 @@
         this._description = description;
     }
 
-    /** Column Annotation for S2Dao. TIMESTAMP */
+    /** Column Annotation for S2Dao. TIMESTAMP : NotNull */
     public static final String lastModified_COLUMN = "LAST_MODIFIED";
 
     /**
      * Get the value of lastModified. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @return The value of lastModified. (Nullable)
      */
@@ -305,7 +305,7 @@
 
     /**
      * Set the value of lastModified. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @param lastModified The value of lastModified. (Nullable)
      */

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsZoneToGeoZone.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsZoneToGeoZone.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsZoneToGeoZone.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -69,7 +69,7 @@
     /** The value of geoZoneId. INTEGER : FK to GEO_ZONE */
     protected java.math.BigDecimal _geoZoneId;
 
-    /** The value of lastModified. TIMESTAMP */
+    /** The value of lastModified. TIMESTAMP : NotNull */
     protected java.sql.Timestamp _lastModified;
 
     /** The value of dateAdded. TIMESTAMP : NotNull */
@@ -236,12 +236,12 @@
         this._geoZoneId = geoZoneId;
     }
 
-    /** Column Annotation for S2Dao. TIMESTAMP */
+    /** Column Annotation for S2Dao. TIMESTAMP : NotNull */
     public static final String lastModified_COLUMN = "LAST_MODIFIED";
 
     /**
      * Get the value of lastModified. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @return The value of lastModified. (Nullable)
      */
@@ -251,7 +251,7 @@
 
     /**
      * Set the value of lastModified. <br />
-     * {TIMESTAMP}
+     * {TIMESTAMP : NotNull}
      * 
      * @param lastModified The value of lastModified. (Nullable)
      */

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/BargainDbm.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/BargainDbm.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/BargainDbm.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -99,9 +99,9 @@
     public static final String DB_NAME_PRODUCT_ID = "PRODUCT_ID";
     /** Db-name of BARGAIN_PRICE. DECIMAL(15) : NotNull */
     public static final String DB_NAME_BARGAIN_PRICE = "BARGAIN_PRICE";
-    /** Db-name of DATE_ADDED. TIMESTAMP */
+    /** Db-name of DATE_ADDED. TIMESTAMP : NotNull */
     public static final String DB_NAME_DATE_ADDED = "DATE_ADDED";
-    /** Db-name of LAST_MODIFIED. TIMESTAMP */
+    /** Db-name of LAST_MODIFIED. TIMESTAMP : NotNull */
     public static final String DB_NAME_LAST_MODIFIED = "LAST_MODIFIED";
     /** Db-name of START_DATE. TIMESTAMP */
     public static final String DB_NAME_START_DATE = "START_DATE";
@@ -136,9 +136,9 @@
     public static final String PROPERTY_NAME_productId = "productId";
     /** Prop-name(JavaBeansRule) of bargainPrice. DECIMAL(15) : NotNull */
     public static final String PROPERTY_NAME_bargainPrice = "bargainPrice";
-    /** Prop-name(JavaBeansRule) of dateAdded. TIMESTAMP */
+    /** Prop-name(JavaBeansRule) of dateAdded. TIMESTAMP : NotNull */
     public static final String PROPERTY_NAME_dateAdded = "dateAdded";
-    /** Prop-name(JavaBeansRule) of lastModified. TIMESTAMP */
+    /** Prop-name(JavaBeansRule) of lastModified. TIMESTAMP : NotNull */
     public static final String PROPERTY_NAME_lastModified = "lastModified";
     /** Prop-name(JavaBeansRule) of startDate. TIMESTAMP */
     public static final String PROPERTY_NAME_startDate = "startDate";
@@ -156,9 +156,9 @@
     public static final String CAP_PROP_NAME_ProductId = "ProductId";
     /** Cap-prop-name of bargainPrice. DECIMAL(15) : NotNull */
     public static final String CAP_PROP_NAME_BargainPrice = "BargainPrice";
-    /** Cap-prop-name of dateAdded. TIMESTAMP */
+    /** Cap-prop-name of dateAdded. TIMESTAMP : NotNull */
     public static final String CAP_PROP_NAME_DateAdded = "DateAdded";
-    /** Cap-prop-name of lastModified. TIMESTAMP */
+    /** Cap-prop-name of lastModified. TIMESTAMP : NotNull */
     public static final String CAP_PROP_NAME_LastModified = "LastModified";
     /** Cap-prop-name of startDate. TIMESTAMP */
     public static final String CAP_PROP_NAME_StartDate = "StartDate";
@@ -193,9 +193,9 @@
     public static final String UNCAP_PROP_NAME_productId = "productId";
     /** Uncap-prop-name of bargainPrice. DECIMAL(15) : NotNull */
     public static final String UNCAP_PROP_NAME_bargainPrice = "bargainPrice";
-    /** Uncap-prop-name of dateAdded. TIMESTAMP */
+    /** Uncap-prop-name of dateAdded. TIMESTAMP : NotNull */
     public static final String UNCAP_PROP_NAME_dateAdded = "dateAdded";
-    /** Uncap-prop-name of lastModified. TIMESTAMP */
+    /** Uncap-prop-name of lastModified. TIMESTAMP : NotNull */
     public static final String UNCAP_PROP_NAME_lastModified = "lastModified";
     /** Uncap-prop-name of startDate. TIMESTAMP */
     public static final String UNCAP_PROP_NAME_startDate = "startDate";

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/CategoryDbm.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/CategoryDbm.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/CategoryDbm.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -99,11 +99,11 @@
     public static final String DB_NAME_IMAGE = "IMAGE";
     /** Db-name of PARENT_ID. INTEGER : Default=[0] : FK to CATEGORY */
     public static final String DB_NAME_PARENT_ID = "PARENT_ID";
-    /** Db-name of SORT_ORDER. INTEGER */
+    /** Db-name of SORT_ORDER. INTEGER : NotNull */
     public static final String DB_NAME_SORT_ORDER = "SORT_ORDER";
-    /** Db-name of DATE_ADDED. TIMESTAMP */
+    /** Db-name of DATE_ADDED. TIMESTAMP : NotNull */
     public static final String DB_NAME_DATE_ADDED = "DATE_ADDED";
-    /** Db-name of LAST_MODIFIED. TIMESTAMP */
+    /** Db-name of LAST_MODIFIED. TIMESTAMP : NotNull */
     public static final String DB_NAME_LAST_MODIFIED = "LAST_MODIFIED";
 
     /** @deprecated Deprecated! So use DB_NAME_CategoryId. */
@@ -128,11 +128,11 @@
     public static final String PROPERTY_NAME_image = "image";
     /** Prop-name(JavaBeansRule) of parentId. INTEGER : Default=[0] : FK to CATEGORY */
     public static final String PROPERTY_NAME_parentId = "parentId";
-    /** Prop-name(JavaBeansRule) of sortOrder. INTEGER */
+    /** Prop-name(JavaBeansRule) of sortOrder. INTEGER : NotNull */
     public static final String PROPERTY_NAME_sortOrder = "sortOrder";
-    /** Prop-name(JavaBeansRule) of dateAdded. TIMESTAMP */
+    /** Prop-name(JavaBeansRule) of dateAdded. TIMESTAMP : NotNull */
     public static final String PROPERTY_NAME_dateAdded = "dateAdded";
-    /** Prop-name(JavaBeansRule) of lastModified. TIMESTAMP */
+    /** Prop-name(JavaBeansRule) of lastModified. TIMESTAMP : NotNull */
     public static final String PROPERTY_NAME_lastModified = "lastModified";
 
     // -----------------------------------------------------
@@ -144,11 +144,11 @@
     public static final String CAP_PROP_NAME_Image = "Image";
     /** Cap-prop-name of parentId. INTEGER : Default=[0] : FK to CATEGORY */
     public static final String CAP_PROP_NAME_ParentId = "ParentId";
-    /** Cap-prop-name of sortOrder. INTEGER */
+    /** Cap-prop-name of sortOrder. INTEGER : NotNull */
     public static final String CAP_PROP_NAME_SortOrder = "SortOrder";
-    /** Cap-prop-name of dateAdded. TIMESTAMP */
+    /** Cap-prop-name of dateAdded. TIMESTAMP : NotNull */
     public static final String CAP_PROP_NAME_DateAdded = "DateAdded";
-    /** Cap-prop-name of lastModified. TIMESTAMP */
+    /** Cap-prop-name of lastModified. TIMESTAMP : NotNull */
     public static final String CAP_PROP_NAME_LastModified = "LastModified";
 
     /** @deprecated Deprecated! So use CAP_PROP_NAME_CategoryId. */
@@ -173,11 +173,11 @@
     public static final String UNCAP_PROP_NAME_image = "image";
     /** Uncap-prop-name of parentId. INTEGER : Default=[0] : FK to CATEGORY */
     public static final String UNCAP_PROP_NAME_parentId = "parentId";
-    /** Uncap-prop-name of sortOrder. INTEGER */
+    /** Uncap-prop-name of sortOrder. INTEGER : NotNull */
     public static final String UNCAP_PROP_NAME_sortOrder = "sortOrder";
-    /** Uncap-prop-name of dateAdded. TIMESTAMP */
+    /** Uncap-prop-name of dateAdded. TIMESTAMP : NotNull */
     public static final String UNCAP_PROP_NAME_dateAdded = "dateAdded";
-    /** Uncap-prop-name of lastModified. TIMESTAMP */
+    /** Uncap-prop-name of lastModified. TIMESTAMP : NotNull */
     public static final String UNCAP_PROP_NAME_lastModified = "lastModified";
 
     /** @deprecated Deprecated! So use UNCAP_PROP_NAME_CategoryId. */

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/CustomerBasketAttributeDbm.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/CustomerBasketAttributeDbm.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/CustomerBasketAttributeDbm.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -103,7 +103,7 @@
     public static final String DB_NAME_PRODUCTS_OPTION_ID = "PRODUCTS_OPTION_ID";
     /** Db-name of PRODUCTS_OPTION_VALUE_ID. BIGINT : NotNull : FK to PRODUCT_OPTION_VALUE */
     public static final String DB_NAME_PRODUCTS_OPTION_VALUE_ID = "PRODUCTS_OPTION_VALUE_ID";
-    /** Db-name of DATE_ADDED. TIMESTAMP */
+    /** Db-name of DATE_ADDED. TIMESTAMP : NotNull */
     public static final String DB_NAME_DATE_ADDED = "DATE_ADDED";
 
     /** @deprecated Deprecated! So use DB_NAME_CustomersBasketAttributeId. */
@@ -132,7 +132,7 @@
     public static final String PROPERTY_NAME_productsOptionId = "productsOptionId";
     /** Prop-name(JavaBeansRule) of productsOptionValueId. BIGINT : NotNull : FK to PRODUCT_OPTION_VALUE */
     public static final String PROPERTY_NAME_productsOptionValueId = "productsOptionValueId";
-    /** Prop-name(JavaBeansRule) of dateAdded. TIMESTAMP */
+    /** Prop-name(JavaBeansRule) of dateAdded. TIMESTAMP : NotNull */
     public static final String PROPERTY_NAME_dateAdded = "dateAdded";
 
     // -----------------------------------------------------
@@ -148,7 +148,7 @@
     public static final String CAP_PROP_NAME_ProductsOptionId = "ProductsOptionId";
     /** Cap-prop-name of productsOptionValueId. BIGINT : NotNull : FK to PRODUCT_OPTION_VALUE */
     public static final String CAP_PROP_NAME_ProductsOptionValueId = "ProductsOptionValueId";
-    /** Cap-prop-name of dateAdded. TIMESTAMP */
+    /** Cap-prop-name of dateAdded. TIMESTAMP : NotNull */
     public static final String CAP_PROP_NAME_DateAdded = "DateAdded";
 
     /** @deprecated Deprecated! So use CAP_PROP_NAME_CustomersBasketAttributeId. */
@@ -177,7 +177,7 @@
     public static final String UNCAP_PROP_NAME_productsOptionId = "productsOptionId";
     /** Uncap-prop-name of productsOptionValueId. BIGINT : NotNull : FK to PRODUCT_OPTION_VALUE */
     public static final String UNCAP_PROP_NAME_productsOptionValueId = "productsOptionValueId";
-    /** Uncap-prop-name of dateAdded. TIMESTAMP */
+    /** Uncap-prop-name of dateAdded. TIMESTAMP : NotNull */
     public static final String UNCAP_PROP_NAME_dateAdded = "dateAdded";
 
     /** @deprecated Deprecated! So use UNCAP_PROP_NAME_CustomersBasketAttributeId. */

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/CustomerDbm.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/CustomerDbm.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/CustomerDbm.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -16,7 +16,7 @@
  *     CUSTOMER_ID
  * 
  * [column-property]
- *     CUSTOMER_ID, PORTAL_ID, GENDER, FIRSTNAME, LASTNAME, NICKNAME, DAY_OF_BIRTH, EMAIL_ADDRESS
+ *     CUSTOMER_ID, PORTAL_ID, GENDER, FIRSTNAME, LASTNAME, NICKNAME, DAY_OF_BIRTH, EMAIL_ADDRESS, LAST_MODIFIED, DATE_ADDED
  * 
  * [foreign-property]
  *     
@@ -109,6 +109,10 @@
     public static final String DB_NAME_DAY_OF_BIRTH = "DAY_OF_BIRTH";
     /** Db-name of EMAIL_ADDRESS. VARCHAR(128) : NotNull */
     public static final String DB_NAME_EMAIL_ADDRESS = "EMAIL_ADDRESS";
+    /** Db-name of LAST_MODIFIED. TIMESTAMP : NotNull */
+    public static final String DB_NAME_LAST_MODIFIED = "LAST_MODIFIED";
+    /** Db-name of DATE_ADDED. TIMESTAMP : NotNull */
+    public static final String DB_NAME_DATE_ADDED = "DATE_ADDED";
 
     /** @deprecated Deprecated! So use DB_NAME_CustomerId. */
     public static final String COLUMN_DB_NAME_OF_CustomerId = "CUSTOMER_ID";
@@ -126,6 +130,10 @@
     public static final String COLUMN_DB_NAME_OF_DayOfBirth = "DAY_OF_BIRTH";
     /** @deprecated Deprecated! So use DB_NAME_EmailAddress. */
     public static final String COLUMN_DB_NAME_OF_EmailAddress = "EMAIL_ADDRESS";
+    /** @deprecated Deprecated! So use DB_NAME_LastModified. */
+    public static final String COLUMN_DB_NAME_OF_LastModified = "LAST_MODIFIED";
+    /** @deprecated Deprecated! So use DB_NAME_DateAdded. */
+    public static final String COLUMN_DB_NAME_OF_DateAdded = "DATE_ADDED";
 
     // -----------------------------------------------------
     //                       Column Prop-Name(JavaBeansRule)
@@ -146,6 +154,10 @@
     public static final String PROPERTY_NAME_dayOfBirth = "dayOfBirth";
     /** Prop-name(JavaBeansRule) of emailAddress. VARCHAR(128) : NotNull */
     public static final String PROPERTY_NAME_emailAddress = "emailAddress";
+    /** Prop-name(JavaBeansRule) of lastModified. TIMESTAMP : NotNull */
+    public static final String PROPERTY_NAME_lastModified = "lastModified";
+    /** Prop-name(JavaBeansRule) of dateAdded. TIMESTAMP : NotNull */
+    public static final String PROPERTY_NAME_dateAdded = "dateAdded";
 
     // -----------------------------------------------------
     //                                  Column Cap-Prop-Name
@@ -166,6 +178,10 @@
     public static final String CAP_PROP_NAME_DayOfBirth = "DayOfBirth";
     /** Cap-prop-name of emailAddress. VARCHAR(128) : NotNull */
     public static final String CAP_PROP_NAME_EmailAddress = "EmailAddress";
+    /** Cap-prop-name of lastModified. TIMESTAMP : NotNull */
+    public static final String CAP_PROP_NAME_LastModified = "LastModified";
+    /** Cap-prop-name of dateAdded. TIMESTAMP : NotNull */
+    public static final String CAP_PROP_NAME_DateAdded = "DateAdded";
 
     /** @deprecated Deprecated! So use CAP_PROP_NAME_CustomerId. */
     public static final String COLUMN_CAP_PROP_NAME_OF_CustomerId = "CustomerId";
@@ -183,6 +199,10 @@
     public static final String COLUMN_CAP_PROP_NAME_OF_DayOfBirth = "DayOfBirth";
     /** @deprecated Deprecated! So use CAP_PROP_NAME_EmailAddress. */
     public static final String COLUMN_CAP_PROP_NAME_OF_EmailAddress = "EmailAddress";
+    /** @deprecated Deprecated! So use CAP_PROP_NAME_LastModified. */
+    public static final String COLUMN_CAP_PROP_NAME_OF_LastModified = "LastModified";
+    /** @deprecated Deprecated! So use CAP_PROP_NAME_DateAdded. */
+    public static final String COLUMN_CAP_PROP_NAME_OF_DateAdded = "DateAdded";
 
     // -----------------------------------------------------
     //                                Column Uncap-Prop-Name
@@ -203,6 +223,10 @@
     public static final String UNCAP_PROP_NAME_dayOfBirth = "dayOfBirth";
     /** Uncap-prop-name of emailAddress. VARCHAR(128) : NotNull */
     public static final String UNCAP_PROP_NAME_emailAddress = "emailAddress";
+    /** Uncap-prop-name of lastModified. TIMESTAMP : NotNull */
+    public static final String UNCAP_PROP_NAME_lastModified = "lastModified";
+    /** Uncap-prop-name of dateAdded. TIMESTAMP : NotNull */
+    public static final String UNCAP_PROP_NAME_dateAdded = "dateAdded";
 
     /** @deprecated Deprecated! So use UNCAP_PROP_NAME_CustomerId. */
     public static final String COLUMN_UNCAP_PROP_NAME_OF_CustomerId = "customerId";
@@ -220,6 +244,10 @@
     public static final String COLUMN_UNCAP_PROP_NAME_OF_DayOfBirth = "dayOfBirth";
     /** @deprecated Deprecated! So use UNCAP_PROP_NAME_EmailAddress. */
     public static final String COLUMN_UNCAP_PROP_NAME_OF_EmailAddress = "emailAddress";
+    /** @deprecated Deprecated! So use UNCAP_PROP_NAME_LastModified. */
+    public static final String COLUMN_UNCAP_PROP_NAME_OF_LastModified = "lastModified";
+    /** @deprecated Deprecated! So use UNCAP_PROP_NAME_DateAdded. */
+    public static final String COLUMN_UNCAP_PROP_NAME_OF_DateAdded = "dateAdded";
 
     // -----------------------------------------------------
     //                                          Foreign Name
@@ -284,6 +312,8 @@
         map.put(DB_NAME_NICKNAME.toLowerCase(), PROPERTY_NAME_nickname);
         map.put(DB_NAME_DAY_OF_BIRTH.toLowerCase(), PROPERTY_NAME_dayOfBirth);
         map.put(DB_NAME_EMAIL_ADDRESS.toLowerCase(), PROPERTY_NAME_emailAddress);
+        map.put(DB_NAME_LAST_MODIFIED.toLowerCase(), PROPERTY_NAME_lastModified);
+        map.put(DB_NAME_DATE_ADDED.toLowerCase(), PROPERTY_NAME_dateAdded);
 
         _dbNamePropertyNameKeyToLowerMap = java.util.Collections.unmodifiableMap(map);
         return _dbNamePropertyNameKeyToLowerMap;
@@ -306,6 +336,8 @@
         map.put(PROPERTY_NAME_nickname.toLowerCase(), DB_NAME_NICKNAME);
         map.put(PROPERTY_NAME_dayOfBirth.toLowerCase(), DB_NAME_DAY_OF_BIRTH);
         map.put(PROPERTY_NAME_emailAddress.toLowerCase(), DB_NAME_EMAIL_ADDRESS);
+        map.put(PROPERTY_NAME_lastModified.toLowerCase(), DB_NAME_LAST_MODIFIED);
+        map.put(PROPERTY_NAME_dateAdded.toLowerCase(), DB_NAME_DATE_ADDED);
 
         _propertyNameDbNameKeyToLowerMap = java.util.Collections.unmodifiableMap(map);
         return _propertyNameDbNameKeyToLowerMap;
@@ -330,6 +362,8 @@
         map.put(DB_NAME_NICKNAME, CAP_PROP_NAME_Nickname);
         map.put(DB_NAME_DAY_OF_BIRTH, CAP_PROP_NAME_DayOfBirth);
         map.put(DB_NAME_EMAIL_ADDRESS, CAP_PROP_NAME_EmailAddress);
+        map.put(DB_NAME_LAST_MODIFIED, CAP_PROP_NAME_LastModified);
+        map.put(DB_NAME_DATE_ADDED, CAP_PROP_NAME_DateAdded);
 
         _dbNameCapPropNameMap = java.util.Collections.unmodifiableMap(map);
         return _dbNameCapPropNameMap;
@@ -354,6 +388,8 @@
         map.put(DB_NAME_NICKNAME, UNCAP_PROP_NAME_nickname);
         map.put(DB_NAME_DAY_OF_BIRTH, UNCAP_PROP_NAME_dayOfBirth);
         map.put(DB_NAME_EMAIL_ADDRESS, UNCAP_PROP_NAME_emailAddress);
+        map.put(DB_NAME_LAST_MODIFIED, UNCAP_PROP_NAME_lastModified);
+        map.put(DB_NAME_DATE_ADDED, UNCAP_PROP_NAME_dateAdded);
 
         _dbNameUncapPropNameMap = java.util.Collections.unmodifiableMap(map);
         return _dbNameUncapPropNameMap;
@@ -378,6 +414,8 @@
         map.put(CAP_PROP_NAME_Nickname, DB_NAME_NICKNAME);
         map.put(CAP_PROP_NAME_DayOfBirth, DB_NAME_DAY_OF_BIRTH);
         map.put(CAP_PROP_NAME_EmailAddress, DB_NAME_EMAIL_ADDRESS);
+        map.put(CAP_PROP_NAME_LastModified, DB_NAME_LAST_MODIFIED);
+        map.put(CAP_PROP_NAME_DateAdded, DB_NAME_DATE_ADDED);
 
         _capPropNameDbNameMap = java.util.Collections.unmodifiableMap(map);
         return _capPropNameDbNameMap;
@@ -402,6 +440,8 @@
         map.put(CAP_PROP_NAME_Nickname, UNCAP_PROP_NAME_nickname);
         map.put(CAP_PROP_NAME_DayOfBirth, UNCAP_PROP_NAME_dayOfBirth);
         map.put(CAP_PROP_NAME_EmailAddress, UNCAP_PROP_NAME_emailAddress);
+        map.put(CAP_PROP_NAME_LastModified, UNCAP_PROP_NAME_lastModified);
+        map.put(CAP_PROP_NAME_DateAdded, UNCAP_PROP_NAME_dateAdded);
 
         _capPropNameUncapPropNameMap = java.util.Collections.unmodifiableMap(map);
         return _capPropNameUncapPropNameMap;
@@ -426,6 +466,8 @@
         map.put(UNCAP_PROP_NAME_nickname, DB_NAME_NICKNAME);
         map.put(UNCAP_PROP_NAME_dayOfBirth, DB_NAME_DAY_OF_BIRTH);
         map.put(UNCAP_PROP_NAME_emailAddress, DB_NAME_EMAIL_ADDRESS);
+        map.put(UNCAP_PROP_NAME_lastModified, DB_NAME_LAST_MODIFIED);
+        map.put(UNCAP_PROP_NAME_dateAdded, DB_NAME_DATE_ADDED);
 
         _uncapPropNameDbNameMap = java.util.Collections.unmodifiableMap(map);
         return _uncapPropNameDbNameMap;
@@ -450,6 +492,8 @@
         map.put(UNCAP_PROP_NAME_nickname, CAP_PROP_NAME_Nickname);
         map.put(UNCAP_PROP_NAME_dayOfBirth, CAP_PROP_NAME_DayOfBirth);
         map.put(UNCAP_PROP_NAME_emailAddress, CAP_PROP_NAME_EmailAddress);
+        map.put(UNCAP_PROP_NAME_lastModified, CAP_PROP_NAME_LastModified);
+        map.put(UNCAP_PROP_NAME_dateAdded, CAP_PROP_NAME_DateAdded);
 
         _uncapPropNameCapPropNameMap = java.util.Collections.unmodifiableMap(map);
         return _uncapPropNameCapPropNameMap;
@@ -666,6 +710,8 @@
         columnInfoList.add(columnNickname());
         columnInfoList.add(columnDayOfBirth());
         columnInfoList.add(columnEmailAddress());
+        columnInfoList.add(columnLastModified());
+        columnInfoList.add(columnDateAdded());
         return columnInfoList;
     }
 
@@ -721,7 +767,7 @@
      * @deprecated Please use getColumnInfoList()
      */
     public String getColumnDbNameCommaString() {
-        return "CUSTOMER_ID, PORTAL_ID, GENDER, FIRSTNAME, LASTNAME, NICKNAME, DAY_OF_BIRTH, EMAIL_ADDRESS";
+        return "CUSTOMER_ID, PORTAL_ID, GENDER, FIRSTNAME, LASTNAME, NICKNAME, DAY_OF_BIRTH, EMAIL_ADDRESS, LAST_MODIFIED, DATE_ADDED";
     }
 
     /**
@@ -772,6 +818,18 @@
     public ColumnInfo columnEmailAddress() {
         return new ColumnInfo(this, "EMAIL_ADDRESS", "emailAddress", String.class, false);
     }
+    /**
+     * @return Column information of lastModified. (NotNull)
+     */
+    public ColumnInfo columnLastModified() {
+        return new ColumnInfo(this, "LAST_MODIFIED", "lastModified", java.sql.Timestamp.class, false);
+    }
+    /**
+     * @return Column information of dateAdded. (NotNull)
+     */
+    public ColumnInfo columnDateAdded() {
+        return new ColumnInfo(this, "DATE_ADDED", "dateAdded", java.sql.Timestamp.class, false);
+    }
 
     // ===================================================================================
     //                                                                         Unique Info
@@ -1004,6 +1062,8 @@
         public RelationTrace columnNickname() { return fixTrace(_relationList, CustomerDbm.getInstance().columnNickname()); }
         public RelationTrace columnDayOfBirth() { return fixTrace(_relationList, CustomerDbm.getInstance().columnDayOfBirth()); }
         public RelationTrace columnEmailAddress() { return fixTrace(_relationList, CustomerDbm.getInstance().columnEmailAddress()); }
+        public RelationTrace columnLastModified() { return fixTrace(_relationList, CustomerDbm.getInstance().columnLastModified()); }
+        public RelationTrace columnDateAdded() { return fixTrace(_relationList, CustomerDbm.getInstance().columnDateAdded()); }
     }
 
     // ===================================================================================
@@ -1082,6 +1142,8 @@
         if (analyzer.init("NICKNAME", "nickname", "nickname")) { myEntity.setNickname(analyzer.analyzeString(String.class)); };
         if (analyzer.init("DAY_OF_BIRTH", "dayOfBirth", "dayOfBirth")) { myEntity.setDayOfBirth(analyzer.analyzeDate(java.util.Date.class)); };
         if (analyzer.init("EMAIL_ADDRESS", "emailAddress", "emailAddress")) { myEntity.setEmailAddress(analyzer.analyzeString(String.class)); };
+        if (analyzer.init("LAST_MODIFIED", "lastModified", "lastModified")) { myEntity.setLastModified(analyzer.analyzeDate(java.sql.Timestamp.class)); };
+        if (analyzer.init("DATE_ADDED", "dateAdded", "dateAdded")) { myEntity.setDateAdded(analyzer.analyzeDate(java.sql.Timestamp.class)); };
 
     }
 
@@ -1162,6 +1224,8 @@
         helpAppendingColumnValueString(sb, delimiter, equal, "NICKNAME", myEntity.getNickname());
         helpAppendingColumnValueString(sb, delimiter, equal, "DAY_OF_BIRTH", myEntity.getDayOfBirth());
         helpAppendingColumnValueString(sb, delimiter, equal, "EMAIL_ADDRESS", myEntity.getEmailAddress());
+        helpAppendingColumnValueString(sb, delimiter, equal, "LAST_MODIFIED", myEntity.getLastModified());
+        helpAppendingColumnValueString(sb, delimiter, equal, "DATE_ADDED", myEntity.getDateAdded());
 
         sb.delete(0, delimiter.length()).insert(0, mapMarkAndStartBrace).append(endBrace);
         return sb.toString();
@@ -1224,6 +1288,8 @@
         valueMap.put("NICKNAME", myEntity.getNickname());
         valueMap.put("DAY_OF_BIRTH", myEntity.getDayOfBirth());
         valueMap.put("EMAIL_ADDRESS", myEntity.getEmailAddress());
+        valueMap.put("LAST_MODIFIED", myEntity.getLastModified());
+        valueMap.put("DATE_ADDED", myEntity.getDateAdded());
         return valueMap;
     }
 
@@ -1254,6 +1320,8 @@
         valueMap.put("NICKNAME", helpGettingColumnStringValue(myEntity.getNickname()));
         valueMap.put("DAY_OF_BIRTH", helpGettingColumnStringValue(myEntity.getDayOfBirth()));
         valueMap.put("EMAIL_ADDRESS", helpGettingColumnStringValue(myEntity.getEmailAddress()));
+        valueMap.put("LAST_MODIFIED", helpGettingColumnStringValue(myEntity.getLastModified()));
+        valueMap.put("DATE_ADDED", helpGettingColumnStringValue(myEntity.getDateAdded()));
         return valueMap;
     }
 
@@ -1278,9 +1346,9 @@
     public String getPreparedInsertClause(PreparedInsertClauseOption preparedInsertClauseOption) {
         if (preparedInsertClauseOption.getTablePrefix() != null) {
             final String tablePrefix = preparedInsertClauseOption.getTablePrefix();
-            return "insert into " + tablePrefix + "CUSTOMER(CUSTOMER_ID, PORTAL_ID, GENDER, FIRSTNAME, LASTNAME, NICKNAME, DAY_OF_BIRTH, EMAIL_ADDRESS) values(? , ? , ? , ? , ? , ? , ? , ? )";
+            return "insert into " + tablePrefix + "CUSTOMER(CUSTOMER_ID, PORTAL_ID, GENDER, FIRSTNAME, LASTNAME, NICKNAME, DAY_OF_BIRTH, EMAIL_ADDRESS, LAST_MODIFIED, DATE_ADDED) values(? , ? , ? , ? , ? , ? , ? , ? , ? , ? )";
         }
-        return "insert into CUSTOMER(CUSTOMER_ID, PORTAL_ID, GENDER, FIRSTNAME, LASTNAME, NICKNAME, DAY_OF_BIRTH, EMAIL_ADDRESS) values(? , ? , ? , ? , ? , ? , ? , ? )";
+        return "insert into CUSTOMER(CUSTOMER_ID, PORTAL_ID, GENDER, FIRSTNAME, LASTNAME, NICKNAME, DAY_OF_BIRTH, EMAIL_ADDRESS, LAST_MODIFIED, DATE_ADDED) values(? , ? , ? , ? , ? , ? , ? , ? , ? , ? )";
     }
 
     // ===================================================================================

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/GeoZoneDbm.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/GeoZoneDbm.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/GeoZoneDbm.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -97,9 +97,9 @@
     public static final String DB_NAME_GEO_ZONE_ID = "GEO_ZONE_ID";
     /** Db-name of NAME. VARCHAR(32) : NotNull */
     public static final String DB_NAME_NAME = "NAME";
-    /** Db-name of DESCRIPTION. VARCHAR(255) : NotNull */
+    /** Db-name of DESCRIPTION. VARCHAR(255) */
     public static final String DB_NAME_DESCRIPTION = "DESCRIPTION";
-    /** Db-name of LAST_MODIFIED. TIMESTAMP */
+    /** Db-name of LAST_MODIFIED. TIMESTAMP : NotNull */
     public static final String DB_NAME_LAST_MODIFIED = "LAST_MODIFIED";
     /** Db-name of DATE_ADDED. TIMESTAMP : NotNull */
     public static final String DB_NAME_DATE_ADDED = "DATE_ADDED";
@@ -122,9 +122,9 @@
     public static final String PROPERTY_NAME_geoZoneId = "geoZoneId";
     /** Prop-name(JavaBeansRule) of name. VARCHAR(32) : NotNull */
     public static final String PROPERTY_NAME_name = "name";
-    /** Prop-name(JavaBeansRule) of description. VARCHAR(255) : NotNull */
+    /** Prop-name(JavaBeansRule) of description. VARCHAR(255) */
     public static final String PROPERTY_NAME_description = "description";
-    /** Prop-name(JavaBeansRule) of lastModified. TIMESTAMP */
+    /** Prop-name(JavaBeansRule) of lastModified. TIMESTAMP : NotNull */
     public static final String PROPERTY_NAME_lastModified = "lastModified";
     /** Prop-name(JavaBeansRule) of dateAdded. TIMESTAMP : NotNull */
     public static final String PROPERTY_NAME_dateAdded = "dateAdded";
@@ -136,9 +136,9 @@
     public static final String CAP_PROP_NAME_GeoZoneId = "GeoZoneId";
     /** Cap-prop-name of name. VARCHAR(32) : NotNull */
     public static final String CAP_PROP_NAME_Name = "Name";
-    /** Cap-prop-name of description. VARCHAR(255) : NotNull */
+    /** Cap-prop-name of description. VARCHAR(255) */
     public static final String CAP_PROP_NAME_Description = "Description";
-    /** Cap-prop-name of lastModified. TIMESTAMP */
+    /** Cap-prop-name of lastModified. TIMESTAMP : NotNull */
     public static final String CAP_PROP_NAME_LastModified = "LastModified";
     /** Cap-prop-name of dateAdded. TIMESTAMP : NotNull */
     public static final String CAP_PROP_NAME_DateAdded = "DateAdded";
@@ -161,9 +161,9 @@
     public static final String UNCAP_PROP_NAME_geoZoneId = "geoZoneId";
     /** Uncap-prop-name of name. VARCHAR(32) : NotNull */
     public static final String UNCAP_PROP_NAME_name = "name";
-    /** Uncap-prop-name of description. VARCHAR(255) : NotNull */
+    /** Uncap-prop-name of description. VARCHAR(255) */
     public static final String UNCAP_PROP_NAME_description = "description";
-    /** Uncap-prop-name of lastModified. TIMESTAMP */
+    /** Uncap-prop-name of lastModified. TIMESTAMP : NotNull */
     public static final String UNCAP_PROP_NAME_lastModified = "lastModified";
     /** Uncap-prop-name of dateAdded. TIMESTAMP : NotNull */
     public static final String UNCAP_PROP_NAME_dateAdded = "dateAdded";

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ManufacturerDbm.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ManufacturerDbm.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ManufacturerDbm.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -99,9 +99,9 @@
     public static final String DB_NAME_NAME = "NAME";
     /** Db-name of IMAGE. VARCHAR(64) */
     public static final String DB_NAME_IMAGE = "IMAGE";
-    /** Db-name of DATE_ADDED. TIMESTAMP */
+    /** Db-name of DATE_ADDED. TIMESTAMP : NotNull */
     public static final String DB_NAME_DATE_ADDED = "DATE_ADDED";
-    /** Db-name of LAST_MODIFIED. TIMESTAMP */
+    /** Db-name of LAST_MODIFIED. TIMESTAMP : NotNull */
     public static final String DB_NAME_LAST_MODIFIED = "LAST_MODIFIED";
 
     /** @deprecated Deprecated! So use DB_NAME_ManufacturerId. */
@@ -124,9 +124,9 @@
     public static final String PROPERTY_NAME_name = "name";
     /** Prop-name(JavaBeansRule) of image. VARCHAR(64) */
     public static final String PROPERTY_NAME_image = "image";
-    /** Prop-name(JavaBeansRule) of dateAdded. TIMESTAMP */
+    /** Prop-name(JavaBeansRule) of dateAdded. TIMESTAMP : NotNull */
     public static final String PROPERTY_NAME_dateAdded = "dateAdded";
-    /** Prop-name(JavaBeansRule) of lastModified. TIMESTAMP */
+    /** Prop-name(JavaBeansRule) of lastModified. TIMESTAMP : NotNull */
     public static final String PROPERTY_NAME_lastModified = "lastModified";
 
     // -----------------------------------------------------
@@ -138,9 +138,9 @@
     public static final String CAP_PROP_NAME_Name = "Name";
     /** Cap-prop-name of image. VARCHAR(64) */
     public static final String CAP_PROP_NAME_Image = "Image";
-    /** Cap-prop-name of dateAdded. TIMESTAMP */
+    /** Cap-prop-name of dateAdded. TIMESTAMP : NotNull */
     public static final String CAP_PROP_NAME_DateAdded = "DateAdded";
-    /** Cap-prop-name of lastModified. TIMESTAMP */
+    /** Cap-prop-name of lastModified. TIMESTAMP : NotNull */
     public static final String CAP_PROP_NAME_LastModified = "LastModified";
 
     /** @deprecated Deprecated! So use CAP_PROP_NAME_ManufacturerId. */
@@ -163,9 +163,9 @@
     public static final String UNCAP_PROP_NAME_name = "name";
     /** Uncap-prop-name of image. VARCHAR(64) */
     public static final String UNCAP_PROP_NAME_image = "image";
-    /** Uncap-prop-name of dateAdded. TIMESTAMP */
+    /** Uncap-prop-name of dateAdded. TIMESTAMP : NotNull */
     public static final String UNCAP_PROP_NAME_dateAdded = "dateAdded";
-    /** Uncap-prop-name of lastModified. TIMESTAMP */
+    /** Uncap-prop-name of lastModified. TIMESTAMP : NotNull */
     public static final String UNCAP_PROP_NAME_lastModified = "lastModified";
 
     /** @deprecated Deprecated! So use UNCAP_PROP_NAME_ManufacturerId. */

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/OrderFormDbm.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/OrderFormDbm.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/OrderFormDbm.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -187,11 +187,11 @@
     public static final String DB_NAME_DELIVERY_METHOD_ID = "DELIVERY_METHOD_ID";
     /** Db-name of DELIVERY_METHOD_CODE. VARCHAR(16) : NotNull */
     public static final String DB_NAME_DELIVERY_METHOD_CODE = "DELIVERY_METHOD_CODE";
-    /** Db-name of LAST_MODIFIED. TIMESTAMP */
+    /** Db-name of LAST_MODIFIED. TIMESTAMP : NotNull */
     public static final String DB_NAME_LAST_MODIFIED = "LAST_MODIFIED";
     /** Db-name of ORDER_STATUS_ID. INTEGER : NotNull : FK to ORDER_STATUS */
     public static final String DB_NAME_ORDER_STATUS_ID = "ORDER_STATUS_ID";
-    /** Db-name of PURCHASED_DATE. TIMESTAMP */
+    /** Db-name of PURCHASED_DATE. TIMESTAMP : NotNull */
     public static final String DB_NAME_PURCHASED_DATE = "PURCHASED_DATE";
     /** Db-name of FINISHED_DATE. TIMESTAMP */
     public static final String DB_NAME_FINISHED_DATE = "FINISHED_DATE";
@@ -420,11 +420,11 @@
     public static final String PROPERTY_NAME_deliveryMethodId = "deliveryMethodId";
     /** Prop-name(JavaBeansRule) of deliveryMethodCode. VARCHAR(16) : NotNull */
     public static final String PROPERTY_NAME_deliveryMethodCode = "deliveryMethodCode";
-    /** Prop-name(JavaBeansRule) of lastModified. TIMESTAMP */
+    /** Prop-name(JavaBeansRule) of lastModified. TIMESTAMP : NotNull */
     public static final String PROPERTY_NAME_lastModified = "lastModified";
     /** Prop-name(JavaBeansRule) of orderStatusId. INTEGER : NotNull : FK to ORDER_STATUS */
     public static final String PROPERTY_NAME_orderStatusId = "orderStatusId";
-    /** Prop-name(JavaBeansRule) of purchasedDate. TIMESTAMP */
+    /** Prop-name(JavaBeansRule) of purchasedDate. TIMESTAMP : NotNull */
     public static final String PROPERTY_NAME_purchasedDate = "purchasedDate";
     /** Prop-name(JavaBeansRule) of finishedDate. TIMESTAMP */
     public static final String PROPERTY_NAME_finishedDate = "finishedDate";
@@ -538,11 +538,11 @@
     public static final String CAP_PROP_NAME_DeliveryMethodId = "DeliveryMethodId";
     /** Cap-prop-name of deliveryMethodCode. VARCHAR(16) : NotNull */
     public static final String CAP_PROP_NAME_DeliveryMethodCode = "DeliveryMethodCode";
-    /** Cap-prop-name of lastModified. TIMESTAMP */
+    /** Cap-prop-name of lastModified. TIMESTAMP : NotNull */
     public static final String CAP_PROP_NAME_LastModified = "LastModified";
     /** Cap-prop-name of orderStatusId. INTEGER : NotNull : FK to ORDER_STATUS */
     public static final String CAP_PROP_NAME_OrderStatusId = "OrderStatusId";
-    /** Cap-prop-name of purchasedDate. TIMESTAMP */
+    /** Cap-prop-name of purchasedDate. TIMESTAMP : NotNull */
     public static final String CAP_PROP_NAME_PurchasedDate = "PurchasedDate";
     /** Cap-prop-name of finishedDate. TIMESTAMP */
     public static final String CAP_PROP_NAME_FinishedDate = "FinishedDate";
@@ -771,11 +771,11 @@
     public static final String UNCAP_PROP_NAME_deliveryMethodId = "deliveryMethodId";
     /** Uncap-prop-name of deliveryMethodCode. VARCHAR(16) : NotNull */
     public static final String UNCAP_PROP_NAME_deliveryMethodCode = "deliveryMethodCode";
-    /** Uncap-prop-name of lastModified. TIMESTAMP */
+    /** Uncap-prop-name of lastModified. TIMESTAMP : NotNull */
     public static final String UNCAP_PROP_NAME_lastModified = "lastModified";
     /** Uncap-prop-name of orderStatusId. INTEGER : NotNull : FK to ORDER_STATUS */
     public static final String UNCAP_PROP_NAME_orderStatusId = "orderStatusId";
-    /** Uncap-prop-name of purchasedDate. TIMESTAMP */
+    /** Uncap-prop-name of purchasedDate. TIMESTAMP : NotNull */
     public static final String UNCAP_PROP_NAME_purchasedDate = "purchasedDate";
     /** Uncap-prop-name of finishedDate. TIMESTAMP */
     public static final String UNCAP_PROP_NAME_finishedDate = "finishedDate";

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductDbm.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductDbm.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductDbm.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -113,7 +113,7 @@
     public static final String DB_NAME_STATUS = "STATUS";
     /** Db-name of DATE_ADDED. TIMESTAMP : NotNull */
     public static final String DB_NAME_DATE_ADDED = "DATE_ADDED";
-    /** Db-name of LAST_MODIFIED. TIMESTAMP */
+    /** Db-name of LAST_MODIFIED. TIMESTAMP : NotNull */
     public static final String DB_NAME_LAST_MODIFIED = "LAST_MODIFIED";
     /** Db-name of DATE_AVAILABLE. TIMESTAMP */
     public static final String DB_NAME_DATE_AVAILABLE = "DATE_AVAILABLE";
@@ -174,7 +174,7 @@
     public static final String PROPERTY_NAME_status = "status";
     /** Prop-name(JavaBeansRule) of dateAdded. TIMESTAMP : NotNull */
     public static final String PROPERTY_NAME_dateAdded = "dateAdded";
-    /** Prop-name(JavaBeansRule) of lastModified. TIMESTAMP */
+    /** Prop-name(JavaBeansRule) of lastModified. TIMESTAMP : NotNull */
     public static final String PROPERTY_NAME_lastModified = "lastModified";
     /** Prop-name(JavaBeansRule) of dateAvailable. TIMESTAMP */
     public static final String PROPERTY_NAME_dateAvailable = "dateAvailable";
@@ -206,7 +206,7 @@
     public static final String CAP_PROP_NAME_Status = "Status";
     /** Cap-prop-name of dateAdded. TIMESTAMP : NotNull */
     public static final String CAP_PROP_NAME_DateAdded = "DateAdded";
-    /** Cap-prop-name of lastModified. TIMESTAMP */
+    /** Cap-prop-name of lastModified. TIMESTAMP : NotNull */
     public static final String CAP_PROP_NAME_LastModified = "LastModified";
     /** Cap-prop-name of dateAvailable. TIMESTAMP */
     public static final String CAP_PROP_NAME_DateAvailable = "DateAvailable";
@@ -267,7 +267,7 @@
     public static final String UNCAP_PROP_NAME_status = "status";
     /** Uncap-prop-name of dateAdded. TIMESTAMP : NotNull */
     public static final String UNCAP_PROP_NAME_dateAdded = "dateAdded";
-    /** Uncap-prop-name of lastModified. TIMESTAMP */
+    /** Uncap-prop-name of lastModified. TIMESTAMP : NotNull */
     public static final String UNCAP_PROP_NAME_lastModified = "lastModified";
     /** Uncap-prop-name of dateAvailable. TIMESTAMP */
     public static final String UNCAP_PROP_NAME_dateAvailable = "dateAvailable";

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ReviewDbm.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ReviewDbm.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ReviewDbm.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -103,9 +103,9 @@
     public static final String DB_NAME_CUSTOMER_NICKNAME = "CUSTOMER_NICKNAME";
     /** Db-name of RATING. INTEGER */
     public static final String DB_NAME_RATING = "RATING";
-    /** Db-name of DATE_ADDED. TIMESTAMP */
+    /** Db-name of DATE_ADDED. TIMESTAMP : NotNull */
     public static final String DB_NAME_DATE_ADDED = "DATE_ADDED";
-    /** Db-name of LAST_MODIFIED. TIMESTAMP */
+    /** Db-name of LAST_MODIFIED. TIMESTAMP : NotNull */
     public static final String DB_NAME_LAST_MODIFIED = "LAST_MODIFIED";
 
     /** @deprecated Deprecated! So use DB_NAME_ReviewId. */
@@ -136,9 +136,9 @@
     public static final String PROPERTY_NAME_customerNickname = "customerNickname";
     /** Prop-name(JavaBeansRule) of rating. INTEGER */
     public static final String PROPERTY_NAME_rating = "rating";
-    /** Prop-name(JavaBeansRule) of dateAdded. TIMESTAMP */
+    /** Prop-name(JavaBeansRule) of dateAdded. TIMESTAMP : NotNull */
     public static final String PROPERTY_NAME_dateAdded = "dateAdded";
-    /** Prop-name(JavaBeansRule) of lastModified. TIMESTAMP */
+    /** Prop-name(JavaBeansRule) of lastModified. TIMESTAMP : NotNull */
     public static final String PROPERTY_NAME_lastModified = "lastModified";
 
     // -----------------------------------------------------
@@ -154,9 +154,9 @@
     public static final String CAP_PROP_NAME_CustomerNickname = "CustomerNickname";
     /** Cap-prop-name of rating. INTEGER */
     public static final String CAP_PROP_NAME_Rating = "Rating";
-    /** Cap-prop-name of dateAdded. TIMESTAMP */
+    /** Cap-prop-name of dateAdded. TIMESTAMP : NotNull */
     public static final String CAP_PROP_NAME_DateAdded = "DateAdded";
-    /** Cap-prop-name of lastModified. TIMESTAMP */
+    /** Cap-prop-name of lastModified. TIMESTAMP : NotNull */
     public static final String CAP_PROP_NAME_LastModified = "LastModified";
 
     /** @deprecated Deprecated! So use CAP_PROP_NAME_ReviewId. */
@@ -187,9 +187,9 @@
     public static final String UNCAP_PROP_NAME_customerNickname = "customerNickname";
     /** Uncap-prop-name of rating. INTEGER */
     public static final String UNCAP_PROP_NAME_rating = "rating";
-    /** Uncap-prop-name of dateAdded. TIMESTAMP */
+    /** Uncap-prop-name of dateAdded. TIMESTAMP : NotNull */
     public static final String UNCAP_PROP_NAME_dateAdded = "dateAdded";
-    /** Uncap-prop-name of lastModified. TIMESTAMP */
+    /** Uncap-prop-name of lastModified. TIMESTAMP : NotNull */
     public static final String UNCAP_PROP_NAME_lastModified = "lastModified";
 
     /** @deprecated Deprecated! So use UNCAP_PROP_NAME_ReviewId. */

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/TaxClassDbm.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/TaxClassDbm.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/TaxClassDbm.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -97,9 +97,9 @@
     public static final String DB_NAME_TAX_CLASS_ID = "TAX_CLASS_ID";
     /** Db-name of NAME. VARCHAR(32) : NotNull */
     public static final String DB_NAME_NAME = "NAME";
-    /** Db-name of DESCRIPTION. VARCHAR(255) : NotNull */
+    /** Db-name of DESCRIPTION. VARCHAR(255) */
     public static final String DB_NAME_DESCRIPTION = "DESCRIPTION";
-    /** Db-name of LAST_MODIFIED. TIMESTAMP */
+    /** Db-name of LAST_MODIFIED. TIMESTAMP : NotNull */
     public static final String DB_NAME_LAST_MODIFIED = "LAST_MODIFIED";
     /** Db-name of DATE_ADDED. TIMESTAMP : NotNull */
     public static final String DB_NAME_DATE_ADDED = "DATE_ADDED";
@@ -122,9 +122,9 @@
     public static final String PROPERTY_NAME_taxClassId = "taxClassId";
     /** Prop-name(JavaBeansRule) of name. VARCHAR(32) : NotNull */
     public static final String PROPERTY_NAME_name = "name";
-    /** Prop-name(JavaBeansRule) of description. VARCHAR(255) : NotNull */
+    /** Prop-name(JavaBeansRule) of description. VARCHAR(255) */
     public static final String PROPERTY_NAME_description = "description";
-    /** Prop-name(JavaBeansRule) of lastModified. TIMESTAMP */
+    /** Prop-name(JavaBeansRule) of lastModified. TIMESTAMP : NotNull */
     public static final String PROPERTY_NAME_lastModified = "lastModified";
     /** Prop-name(JavaBeansRule) of dateAdded. TIMESTAMP : NotNull */
     public static final String PROPERTY_NAME_dateAdded = "dateAdded";
@@ -136,9 +136,9 @@
     public static final String CAP_PROP_NAME_TaxClassId = "TaxClassId";
     /** Cap-prop-name of name. VARCHAR(32) : NotNull */
     public static final String CAP_PROP_NAME_Name = "Name";
-    /** Cap-prop-name of description. VARCHAR(255) : NotNull */
+    /** Cap-prop-name of description. VARCHAR(255) */
     public static final String CAP_PROP_NAME_Description = "Description";
-    /** Cap-prop-name of lastModified. TIMESTAMP */
+    /** Cap-prop-name of lastModified. TIMESTAMP : NotNull */
     public static final String CAP_PROP_NAME_LastModified = "LastModified";
     /** Cap-prop-name of dateAdded. TIMESTAMP : NotNull */
     public static final String CAP_PROP_NAME_DateAdded = "DateAdded";
@@ -161,9 +161,9 @@
     public static final String UNCAP_PROP_NAME_taxClassId = "taxClassId";
     /** Uncap-prop-name of name. VARCHAR(32) : NotNull */
     public static final String UNCAP_PROP_NAME_name = "name";
-    /** Uncap-prop-name of description. VARCHAR(255) : NotNull */
+    /** Uncap-prop-name of description. VARCHAR(255) */
     public static final String UNCAP_PROP_NAME_description = "description";
-    /** Uncap-prop-name of lastModified. TIMESTAMP */
+    /** Uncap-prop-name of lastModified. TIMESTAMP : NotNull */
     public static final String UNCAP_PROP_NAME_lastModified = "lastModified";
     /** Uncap-prop-name of dateAdded. TIMESTAMP : NotNull */
     public static final String UNCAP_PROP_NAME_dateAdded = "dateAdded";

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/TaxRateDbm.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/TaxRateDbm.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/TaxRateDbm.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -103,9 +103,9 @@
     public static final String DB_NAME_PRIORITY = "PRIORITY";
     /** Db-name of RATE. DECIMAL(7) : NotNull */
     public static final String DB_NAME_RATE = "RATE";
-    /** Db-name of DESCRIPTION. VARCHAR(255) : NotNull */
+    /** Db-name of DESCRIPTION. VARCHAR(255) */
     public static final String DB_NAME_DESCRIPTION = "DESCRIPTION";
-    /** Db-name of LAST_MODIFIED. TIMESTAMP */
+    /** Db-name of LAST_MODIFIED. TIMESTAMP : NotNull */
     public static final String DB_NAME_LAST_MODIFIED = "LAST_MODIFIED";
     /** Db-name of DATE_ADDED. TIMESTAMP : NotNull */
     public static final String DB_NAME_DATE_ADDED = "DATE_ADDED";
@@ -140,9 +140,9 @@
     public static final String PROPERTY_NAME_priority = "priority";
     /** Prop-name(JavaBeansRule) of rate. DECIMAL(7) : NotNull */
     public static final String PROPERTY_NAME_rate = "rate";
-    /** Prop-name(JavaBeansRule) of description. VARCHAR(255) : NotNull */
+    /** Prop-name(JavaBeansRule) of description. VARCHAR(255) */
     public static final String PROPERTY_NAME_description = "description";
-    /** Prop-name(JavaBeansRule) of lastModified. TIMESTAMP */
+    /** Prop-name(JavaBeansRule) of lastModified. TIMESTAMP : NotNull */
     public static final String PROPERTY_NAME_lastModified = "lastModified";
     /** Prop-name(JavaBeansRule) of dateAdded. TIMESTAMP : NotNull */
     public static final String PROPERTY_NAME_dateAdded = "dateAdded";
@@ -160,9 +160,9 @@
     public static final String CAP_PROP_NAME_Priority = "Priority";
     /** Cap-prop-name of rate. DECIMAL(7) : NotNull */
     public static final String CAP_PROP_NAME_Rate = "Rate";
-    /** Cap-prop-name of description. VARCHAR(255) : NotNull */
+    /** Cap-prop-name of description. VARCHAR(255) */
     public static final String CAP_PROP_NAME_Description = "Description";
-    /** Cap-prop-name of lastModified. TIMESTAMP */
+    /** Cap-prop-name of lastModified. TIMESTAMP : NotNull */
     public static final String CAP_PROP_NAME_LastModified = "LastModified";
     /** Cap-prop-name of dateAdded. TIMESTAMP : NotNull */
     public static final String CAP_PROP_NAME_DateAdded = "DateAdded";
@@ -197,9 +197,9 @@
     public static final String UNCAP_PROP_NAME_priority = "priority";
     /** Uncap-prop-name of rate. DECIMAL(7) : NotNull */
     public static final String UNCAP_PROP_NAME_rate = "rate";
-    /** Uncap-prop-name of description. VARCHAR(255) : NotNull */
+    /** Uncap-prop-name of description. VARCHAR(255) */
     public static final String UNCAP_PROP_NAME_description = "description";
-    /** Uncap-prop-name of lastModified. TIMESTAMP */
+    /** Uncap-prop-name of lastModified. TIMESTAMP : NotNull */
     public static final String UNCAP_PROP_NAME_lastModified = "lastModified";
     /** Uncap-prop-name of dateAdded. TIMESTAMP : NotNull */
     public static final String UNCAP_PROP_NAME_dateAdded = "dateAdded";

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ZoneToGeoZoneDbm.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ZoneToGeoZoneDbm.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ZoneToGeoZoneDbm.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -101,7 +101,7 @@
     public static final String DB_NAME_ZONE_ID = "ZONE_ID";
     /** Db-name of GEO_ZONE_ID. INTEGER : FK to GEO_ZONE */
     public static final String DB_NAME_GEO_ZONE_ID = "GEO_ZONE_ID";
-    /** Db-name of LAST_MODIFIED. TIMESTAMP */
+    /** Db-name of LAST_MODIFIED. TIMESTAMP : NotNull */
     public static final String DB_NAME_LAST_MODIFIED = "LAST_MODIFIED";
     /** Db-name of DATE_ADDED. TIMESTAMP : NotNull */
     public static final String DB_NAME_DATE_ADDED = "DATE_ADDED";
@@ -130,7 +130,7 @@
     public static final String PROPERTY_NAME_zoneId = "zoneId";
     /** Prop-name(JavaBeansRule) of geoZoneId. INTEGER : FK to GEO_ZONE */
     public static final String PROPERTY_NAME_geoZoneId = "geoZoneId";
-    /** Prop-name(JavaBeansRule) of lastModified. TIMESTAMP */
+    /** Prop-name(JavaBeansRule) of lastModified. TIMESTAMP : NotNull */
     public static final String PROPERTY_NAME_lastModified = "lastModified";
     /** Prop-name(JavaBeansRule) of dateAdded. TIMESTAMP : NotNull */
     public static final String PROPERTY_NAME_dateAdded = "dateAdded";
@@ -146,7 +146,7 @@
     public static final String CAP_PROP_NAME_ZoneId = "ZoneId";
     /** Cap-prop-name of geoZoneId. INTEGER : FK to GEO_ZONE */
     public static final String CAP_PROP_NAME_GeoZoneId = "GeoZoneId";
-    /** Cap-prop-name of lastModified. TIMESTAMP */
+    /** Cap-prop-name of lastModified. TIMESTAMP : NotNull */
     public static final String CAP_PROP_NAME_LastModified = "LastModified";
     /** Cap-prop-name of dateAdded. TIMESTAMP : NotNull */
     public static final String CAP_PROP_NAME_DateAdded = "DateAdded";
@@ -175,7 +175,7 @@
     public static final String UNCAP_PROP_NAME_zoneId = "zoneId";
     /** Uncap-prop-name of geoZoneId. INTEGER : FK to GEO_ZONE */
     public static final String UNCAP_PROP_NAME_geoZoneId = "geoZoneId";
-    /** Uncap-prop-name of lastModified. TIMESTAMP */
+    /** Uncap-prop-name of lastModified. TIMESTAMP : NotNull */
     public static final String UNCAP_PROP_NAME_lastModified = "lastModified";
     /** Uncap-prop-name of dateAdded. TIMESTAMP : NotNull */
     public static final String UNCAP_PROP_NAME_dateAdded = "dateAdded";

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsBargainCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsBargainCQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsBargainCQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -455,22 +455,8 @@
     public void setDateAdded_FromTo(java.sql.Timestamp fromDate, java.sql.Timestamp toDate, jp.sf.pal.pompei.allcommon.cbean.coption.FromToOption fromToOption) {
         registerFromToQuery(fromDate, toDate, getCValueDateAdded(), COL_DATE_ADDED, J_DateAdded, UJ_dateAdded, fromToOption);
     }
-                      
+                          
     /**
-     * Set the value of dateAdded using isNull. { is null }
-     */
-    public void setDateAdded_IsNull() {
-        registerDateAdded(ConditionKey.CK_IS_NULL, DUMMY_OBJECT);
-    }
-
-    /**
-     * Set the value of dateAdded using isNotNull. { is not null }
-     */
-    public void setDateAdded_IsNotNull() {
-        registerDateAdded(ConditionKey.CK_IS_NOT_NULL, DUMMY_OBJECT);
-    }
-        
-    /**
      * Register condition of dateAdded.
      * 
      * @param key Condition key. (NotNull)
@@ -565,22 +551,8 @@
     public void setLastModified_FromTo(java.sql.Timestamp fromDate, java.sql.Timestamp toDate, jp.sf.pal.pompei.allcommon.cbean.coption.FromToOption fromToOption) {
         registerFromToQuery(fromDate, toDate, getCValueLastModified(), COL_LAST_MODIFIED, J_LastModified, UJ_lastModified, fromToOption);
     }
-                      
+                          
     /**
-     * Set the value of lastModified using isNull. { is null }
-     */
-    public void setLastModified_IsNull() {
-        registerLastModified(ConditionKey.CK_IS_NULL, DUMMY_OBJECT);
-    }
-
-    /**
-     * Set the value of lastModified using isNotNull. { is not null }
-     */
-    public void setLastModified_IsNotNull() {
-        registerLastModified(ConditionKey.CK_IS_NOT_NULL, DUMMY_OBJECT);
-    }
-        
-    /**
      * Register condition of lastModified.
      * 
      * @param key Condition key. (NotNull)

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsCategoryCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsCategoryCQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsCategoryCQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -616,22 +616,8 @@
     public void setSortOrder_NotInScope(java.util.List<java.math.BigDecimal> sortOrderList) {
         registerSortOrder(ConditionKey.CK_NOT_IN_SCOPE, sortOrderList);
     }
-                                            
+                                                
     /**
-     * Set the value of sortOrder using isNull. { is null }
-     */
-    public void setSortOrder_IsNull() {
-        registerSortOrder(ConditionKey.CK_IS_NULL, DUMMY_OBJECT);
-    }
-
-    /**
-     * Set the value of sortOrder using isNotNull. { is not null }
-     */
-    public void setSortOrder_IsNotNull() {
-        registerSortOrder(ConditionKey.CK_IS_NOT_NULL, DUMMY_OBJECT);
-    }
-        
-    /**
      * Register condition of sortOrder.
      * 
      * @param key Condition key. (NotNull)
@@ -726,22 +712,8 @@
     public void setDateAdded_FromTo(java.sql.Timestamp fromDate, java.sql.Timestamp toDate, jp.sf.pal.pompei.allcommon.cbean.coption.FromToOption fromToOption) {
         registerFromToQuery(fromDate, toDate, getCValueDateAdded(), COL_DATE_ADDED, J_DateAdded, UJ_dateAdded, fromToOption);
     }
-                      
+                          
     /**
-     * Set the value of dateAdded using isNull. { is null }
-     */
-    public void setDateAdded_IsNull() {
-        registerDateAdded(ConditionKey.CK_IS_NULL, DUMMY_OBJECT);
-    }
-
-    /**
-     * Set the value of dateAdded using isNotNull. { is not null }
-     */
-    public void setDateAdded_IsNotNull() {
-        registerDateAdded(ConditionKey.CK_IS_NOT_NULL, DUMMY_OBJECT);
-    }
-        
-    /**
      * Register condition of dateAdded.
      * 
      * @param key Condition key. (NotNull)
@@ -836,22 +808,8 @@
     public void setLastModified_FromTo(java.sql.Timestamp fromDate, java.sql.Timestamp toDate, jp.sf.pal.pompei.allcommon.cbean.coption.FromToOption fromToOption) {
         registerFromToQuery(fromDate, toDate, getCValueLastModified(), COL_LAST_MODIFIED, J_LastModified, UJ_lastModified, fromToOption);
     }
-                      
+                          
     /**
-     * Set the value of lastModified using isNull. { is null }
-     */
-    public void setLastModified_IsNull() {
-        registerLastModified(ConditionKey.CK_IS_NULL, DUMMY_OBJECT);
-    }
-
-    /**
-     * Set the value of lastModified using isNotNull. { is not null }
-     */
-    public void setLastModified_IsNotNull() {
-        registerLastModified(ConditionKey.CK_IS_NOT_NULL, DUMMY_OBJECT);
-    }
-        
-    /**
      * Register condition of lastModified.
      * 
      * @param key Condition key. (NotNull)

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsCustomerBasketAttributeCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsCustomerBasketAttributeCQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsCustomerBasketAttributeCQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -716,22 +716,8 @@
     public void setDateAdded_FromTo(java.sql.Timestamp fromDate, java.sql.Timestamp toDate, jp.sf.pal.pompei.allcommon.cbean.coption.FromToOption fromToOption) {
         registerFromToQuery(fromDate, toDate, getCValueDateAdded(), COL_DATE_ADDED, J_DateAdded, UJ_dateAdded, fromToOption);
     }
-                      
+                          
     /**
-     * Set the value of dateAdded using isNull. { is null }
-     */
-    public void setDateAdded_IsNull() {
-        registerDateAdded(ConditionKey.CK_IS_NULL, DUMMY_OBJECT);
-    }
-
-    /**
-     * Set the value of dateAdded using isNotNull. { is not null }
-     */
-    public void setDateAdded_IsNotNull() {
-        registerDateAdded(ConditionKey.CK_IS_NOT_NULL, DUMMY_OBJECT);
-    }
-        
-    /**
      * Register condition of dateAdded.
      * 
      * @param key Condition key. (NotNull)

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsCustomerCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsCustomerCQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsCustomerCQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -1332,6 +1332,198 @@
     }
 
     abstract protected ConditionValue getCValueEmailAddress();
+      
+    /** Column db name of lastModified. */
+    protected static final String COL_LAST_MODIFIED = "LAST_MODIFIED";
+
+    /** Column java name of lastModified. */
+    protected static final String J_LastModified = "LastModified";
+
+    /** Column uncapitalised java name of lastModified. */
+    protected static final String UJ_lastModified = "lastModified";
+                
+    /**
+     * Set the value of lastModified using equal. { = }
+     * 
+     * @param lastModified The value of lastModified as equal.
+     */
+    public void setLastModified_Equal(java.sql.Timestamp lastModified) {
+        registerLastModified(ConditionKey.CK_EQUAL, lastModified);
+    }
+      
+    /**
+     * Set the value of lastModified using notEqual. { != }
+     * 
+     * @param lastModified The value of lastModified as notEqual.
+     */
+    public void setLastModified_NotEqual(java.sql.Timestamp lastModified) {
+        registerLastModified(ConditionKey.CK_NOT_EQUAL, lastModified);
+    }
+            
+    /**
+     * Set the value of lastModified using greaterThan. { &gt; }
+     * 
+     * @param lastModified The value of lastModified as greaterThan.
+     */
+    public void setLastModified_GreaterThan(java.sql.Timestamp lastModified) {
+        registerLastModified(ConditionKey.CK_GREATER_THAN, lastModified);
+    }
+            
+    /**
+     * Set the value of lastModified using lessThan. { &lt; }
+     * 
+     * @param lastModified The value of lastModified as lessThan.
+     */
+    public void setLastModified_LessThan(java.sql.Timestamp lastModified) {
+        registerLastModified(ConditionKey.CK_LESS_THAN, lastModified);
+    }
+            
+    /**
+     * Set the value of lastModified using greaterEqual. { &gt;= }
+     * 
+     * @param lastModified The value of lastModified as greaterEqual.
+     */
+    public void setLastModified_GreaterEqual(java.sql.Timestamp lastModified) {
+        registerLastModified(ConditionKey.CK_GREATER_EQUAL, lastModified);
+    }
+            
+    /**
+     * Set the value of lastModified using lessEqual. { &lt;= }
+     * 
+     * @param lastModified The value of lastModified as lessEqual.
+     */
+    public void setLastModified_LessEqual(java.sql.Timestamp lastModified) {
+        registerLastModified(ConditionKey.CK_LESS_EQUAL, lastModified);
+    }
+            
+    /**
+     * Set the value of lastModified using from-to. { $fromDate <= COLUMN_NAME <= $toDate }
+     * 
+     * @param fromDate The from-date of lastModified. (Nullable)
+     * @param toDate The to-date of lastModified. (Nullable)
+     * @param fromToOption The option of from-to. (NotNull)
+     */
+    public void setLastModified_FromTo(java.sql.Timestamp fromDate, java.sql.Timestamp toDate, jp.sf.pal.pompei.allcommon.cbean.coption.FromToOption fromToOption) {
+        registerFromToQuery(fromDate, toDate, getCValueLastModified(), COL_LAST_MODIFIED, J_LastModified, UJ_lastModified, fromToOption);
+    }
+                          
+    /**
+     * Register condition of lastModified.
+     * 
+     * @param key Condition key. (NotNull)
+     * @param value The value of lastModified. (Nullable)
+     */
+    protected void registerLastModified(ConditionKey key, Object value) {
+        registerQuery(key, value, getCValueLastModified(), COL_LAST_MODIFIED, J_LastModified, UJ_lastModified);
+    }
+
+    /**
+     * Register inline condition of lastModified.
+     * 
+     * @param key Condition key. (NotNull)
+     * @param value The value of lastModified. (Nullable)
+     */
+    protected void registerInlineLastModified(ConditionKey key, Object value) {
+        registerInlineQuery(key, value, getCValueLastModified(), COL_LAST_MODIFIED, J_LastModified, UJ_lastModified);
+    }
+
+    abstract protected ConditionValue getCValueLastModified();
+      
+    /** Column db name of dateAdded. */
+    protected static final String COL_DATE_ADDED = "DATE_ADDED";
+
+    /** Column java name of dateAdded. */
+    protected static final String J_DateAdded = "DateAdded";
+
+    /** Column uncapitalised java name of dateAdded. */
+    protected static final String UJ_dateAdded = "dateAdded";
+                
+    /**
+     * Set the value of dateAdded using equal. { = }
+     * 
+     * @param dateAdded The value of dateAdded as equal.
+     */
+    public void setDateAdded_Equal(java.sql.Timestamp dateAdded) {
+        registerDateAdded(ConditionKey.CK_EQUAL, dateAdded);
+    }
+      
+    /**
+     * Set the value of dateAdded using notEqual. { != }
+     * 
+     * @param dateAdded The value of dateAdded as notEqual.
+     */
+    public void setDateAdded_NotEqual(java.sql.Timestamp dateAdded) {
+        registerDateAdded(ConditionKey.CK_NOT_EQUAL, dateAdded);
+    }
+            
+    /**
+     * Set the value of dateAdded using greaterThan. { &gt; }
+     * 
+     * @param dateAdded The value of dateAdded as greaterThan.
+     */
+    public void setDateAdded_GreaterThan(java.sql.Timestamp dateAdded) {
+        registerDateAdded(ConditionKey.CK_GREATER_THAN, dateAdded);
+    }
+            
+    /**
+     * Set the value of dateAdded using lessThan. { &lt; }
+     * 
+     * @param dateAdded The value of dateAdded as lessThan.
+     */
+    public void setDateAdded_LessThan(java.sql.Timestamp dateAdded) {
+        registerDateAdded(ConditionKey.CK_LESS_THAN, dateAdded);
+    }
+            
+    /**
+     * Set the value of dateAdded using greaterEqual. { &gt;= }
+     * 
+     * @param dateAdded The value of dateAdded as greaterEqual.
+     */
+    public void setDateAdded_GreaterEqual(java.sql.Timestamp dateAdded) {
+        registerDateAdded(ConditionKey.CK_GREATER_EQUAL, dateAdded);
+    }
+            
+    /**
+     * Set the value of dateAdded using lessEqual. { &lt;= }
+     * 
+     * @param dateAdded The value of dateAdded as lessEqual.
+     */
+    public void setDateAdded_LessEqual(java.sql.Timestamp dateAdded) {
+        registerDateAdded(ConditionKey.CK_LESS_EQUAL, dateAdded);
+    }
+            
+    /**
+     * Set the value of dateAdded using from-to. { $fromDate <= COLUMN_NAME <= $toDate }
+     * 
+     * @param fromDate The from-date of dateAdded. (Nullable)
+     * @param toDate The to-date of dateAdded. (Nullable)
+     * @param fromToOption The option of from-to. (NotNull)
+     */
+    public void setDateAdded_FromTo(java.sql.Timestamp fromDate, java.sql.Timestamp toDate, jp.sf.pal.pompei.allcommon.cbean.coption.FromToOption fromToOption) {
+        registerFromToQuery(fromDate, toDate, getCValueDateAdded(), COL_DATE_ADDED, J_DateAdded, UJ_dateAdded, fromToOption);
+    }
+                          
+    /**
+     * Register condition of dateAdded.
+     * 
+     * @param key Condition key. (NotNull)
+     * @param value The value of dateAdded. (Nullable)
+     */
+    protected void registerDateAdded(ConditionKey key, Object value) {
+        registerQuery(key, value, getCValueDateAdded(), COL_DATE_ADDED, J_DateAdded, UJ_dateAdded);
+    }
+
+    /**
+     * Register inline condition of dateAdded.
+     * 
+     * @param key Condition key. (NotNull)
+     * @param value The value of dateAdded. (Nullable)
+     */
+    protected void registerInlineDateAdded(ConditionKey key, Object value) {
+        registerInlineQuery(key, value, getCValueDateAdded(), COL_DATE_ADDED, J_DateAdded, UJ_dateAdded);
+    }
+
+    abstract protected ConditionValue getCValueDateAdded();
   
     // ===================================================================================
     //                                                                      Basic Override

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsGeoZoneCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsGeoZoneCQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsGeoZoneCQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -454,8 +454,22 @@
     public void setDescription_NotInScope(java.util.List<String> descriptionList) {
         registerDescription(ConditionKey.CK_NOT_IN_SCOPE, filterRemoveEmptyStringFromList(descriptionList));
     }
-                                                    
+                                                
     /**
+     * Set the value of description using isNull. { is null }
+     */
+    public void setDescription_IsNull() {
+        registerDescription(ConditionKey.CK_IS_NULL, DUMMY_OBJECT);
+    }
+
+    /**
+     * Set the value of description using isNotNull. { is not null }
+     */
+    public void setDescription_IsNotNull() {
+        registerDescription(ConditionKey.CK_IS_NOT_NULL, DUMMY_OBJECT);
+    }
+        
+    /**
      * Register condition of description.
      * 
      * @param key Condition key. (NotNull)
@@ -550,22 +564,8 @@
     public void setLastModified_FromTo(java.sql.Timestamp fromDate, java.sql.Timestamp toDate, jp.sf.pal.pompei.allcommon.cbean.coption.FromToOption fromToOption) {
         registerFromToQuery(fromDate, toDate, getCValueLastModified(), COL_LAST_MODIFIED, J_LastModified, UJ_lastModified, fromToOption);
     }
-                      
+                          
     /**
-     * Set the value of lastModified using isNull. { is null }
-     */
-    public void setLastModified_IsNull() {
-        registerLastModified(ConditionKey.CK_IS_NULL, DUMMY_OBJECT);
-    }
-
-    /**
-     * Set the value of lastModified using isNotNull. { is not null }
-     */
-    public void setLastModified_IsNotNull() {
-        registerLastModified(ConditionKey.CK_IS_NOT_NULL, DUMMY_OBJECT);
-    }
-        
-    /**
      * Register condition of lastModified.
      * 
      * @param key Condition key. (NotNull)

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsManufacturerCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsManufacturerCQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsManufacturerCQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -598,22 +598,8 @@
     public void setDateAdded_FromTo(java.sql.Timestamp fromDate, java.sql.Timestamp toDate, jp.sf.pal.pompei.allcommon.cbean.coption.FromToOption fromToOption) {
         registerFromToQuery(fromDate, toDate, getCValueDateAdded(), COL_DATE_ADDED, J_DateAdded, UJ_dateAdded, fromToOption);
     }
-                      
+                          
     /**
-     * Set the value of dateAdded using isNull. { is null }
-     */
-    public void setDateAdded_IsNull() {
-        registerDateAdded(ConditionKey.CK_IS_NULL, DUMMY_OBJECT);
-    }
-
-    /**
-     * Set the value of dateAdded using isNotNull. { is not null }
-     */
-    public void setDateAdded_IsNotNull() {
-        registerDateAdded(ConditionKey.CK_IS_NOT_NULL, DUMMY_OBJECT);
-    }
-        
-    /**
      * Register condition of dateAdded.
      * 
      * @param key Condition key. (NotNull)
@@ -708,22 +694,8 @@
     public void setLastModified_FromTo(java.sql.Timestamp fromDate, java.sql.Timestamp toDate, jp.sf.pal.pompei.allcommon.cbean.coption.FromToOption fromToOption) {
         registerFromToQuery(fromDate, toDate, getCValueLastModified(), COL_LAST_MODIFIED, J_LastModified, UJ_lastModified, fromToOption);
     }
-                      
+                          
     /**
-     * Set the value of lastModified using isNull. { is null }
-     */
-    public void setLastModified_IsNull() {
-        registerLastModified(ConditionKey.CK_IS_NULL, DUMMY_OBJECT);
-    }
-
-    /**
-     * Set the value of lastModified using isNotNull. { is not null }
-     */
-    public void setLastModified_IsNotNull() {
-        registerLastModified(ConditionKey.CK_IS_NOT_NULL, DUMMY_OBJECT);
-    }
-        
-    /**
      * Register condition of lastModified.
      * 
      * @param key Condition key. (NotNull)

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsOrderFormCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsOrderFormCQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsOrderFormCQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -7135,22 +7135,8 @@
     public void setLastModified_FromTo(java.sql.Timestamp fromDate, java.sql.Timestamp toDate, jp.sf.pal.pompei.allcommon.cbean.coption.FromToOption fromToOption) {
         registerFromToQuery(fromDate, toDate, getCValueLastModified(), COL_LAST_MODIFIED, J_LastModified, UJ_lastModified, fromToOption);
     }
-                      
+                          
     /**
-     * Set the value of lastModified using isNull. { is null }
-     */
-    public void setLastModified_IsNull() {
-        registerLastModified(ConditionKey.CK_IS_NULL, DUMMY_OBJECT);
-    }
-
-    /**
-     * Set the value of lastModified using isNotNull. { is not null }
-     */
-    public void setLastModified_IsNotNull() {
-        registerLastModified(ConditionKey.CK_IS_NOT_NULL, DUMMY_OBJECT);
-    }
-        
-    /**
      * Register condition of lastModified.
      * 
      * @param key Condition key. (NotNull)
@@ -7367,22 +7353,8 @@
     public void setPurchasedDate_FromTo(java.sql.Timestamp fromDate, java.sql.Timestamp toDate, jp.sf.pal.pompei.allcommon.cbean.coption.FromToOption fromToOption) {
         registerFromToQuery(fromDate, toDate, getCValuePurchasedDate(), COL_PURCHASED_DATE, J_PurchasedDate, UJ_purchasedDate, fromToOption);
     }
-                      
+                          
     /**
-     * Set the value of purchasedDate using isNull. { is null }
-     */
-    public void setPurchasedDate_IsNull() {
-        registerPurchasedDate(ConditionKey.CK_IS_NULL, DUMMY_OBJECT);
-    }
-
-    /**
-     * Set the value of purchasedDate using isNotNull. { is not null }
-     */
-    public void setPurchasedDate_IsNotNull() {
-        registerPurchasedDate(ConditionKey.CK_IS_NOT_NULL, DUMMY_OBJECT);
-    }
-        
-    /**
      * Register condition of purchasedDate.
      * 
      * @param key Condition key. (NotNull)

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsProductCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsProductCQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsProductCQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -1725,22 +1725,8 @@
     public void setLastModified_FromTo(java.sql.Timestamp fromDate, java.sql.Timestamp toDate, jp.sf.pal.pompei.allcommon.cbean.coption.FromToOption fromToOption) {
         registerFromToQuery(fromDate, toDate, getCValueLastModified(), COL_LAST_MODIFIED, J_LastModified, UJ_lastModified, fromToOption);
     }
-                      
+                          
     /**
-     * Set the value of lastModified using isNull. { is null }
-     */
-    public void setLastModified_IsNull() {
-        registerLastModified(ConditionKey.CK_IS_NULL, DUMMY_OBJECT);
-    }
-
-    /**
-     * Set the value of lastModified using isNotNull. { is not null }
-     */
-    public void setLastModified_IsNotNull() {
-        registerLastModified(ConditionKey.CK_IS_NOT_NULL, DUMMY_OBJECT);
-    }
-        
-    /**
      * Register condition of lastModified.
      * 
      * @param key Condition key. (NotNull)

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsReviewCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsReviewCQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsReviewCQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -783,22 +783,8 @@
     public void setDateAdded_FromTo(java.sql.Timestamp fromDate, java.sql.Timestamp toDate, jp.sf.pal.pompei.allcommon.cbean.coption.FromToOption fromToOption) {
         registerFromToQuery(fromDate, toDate, getCValueDateAdded(), COL_DATE_ADDED, J_DateAdded, UJ_dateAdded, fromToOption);
     }
-                      
+                          
     /**
-     * Set the value of dateAdded using isNull. { is null }
-     */
-    public void setDateAdded_IsNull() {
-        registerDateAdded(ConditionKey.CK_IS_NULL, DUMMY_OBJECT);
-    }
-
-    /**
-     * Set the value of dateAdded using isNotNull. { is not null }
-     */
-    public void setDateAdded_IsNotNull() {
-        registerDateAdded(ConditionKey.CK_IS_NOT_NULL, DUMMY_OBJECT);
-    }
-        
-    /**
      * Register condition of dateAdded.
      * 
      * @param key Condition key. (NotNull)
@@ -893,22 +879,8 @@
     public void setLastModified_FromTo(java.sql.Timestamp fromDate, java.sql.Timestamp toDate, jp.sf.pal.pompei.allcommon.cbean.coption.FromToOption fromToOption) {
         registerFromToQuery(fromDate, toDate, getCValueLastModified(), COL_LAST_MODIFIED, J_LastModified, UJ_lastModified, fromToOption);
     }
-                      
+                          
     /**
-     * Set the value of lastModified using isNull. { is null }
-     */
-    public void setLastModified_IsNull() {
-        registerLastModified(ConditionKey.CK_IS_NULL, DUMMY_OBJECT);
-    }
-
-    /**
-     * Set the value of lastModified using isNotNull. { is not null }
-     */
-    public void setLastModified_IsNotNull() {
-        registerLastModified(ConditionKey.CK_IS_NOT_NULL, DUMMY_OBJECT);
-    }
-        
-    /**
      * Register condition of lastModified.
      * 
      * @param key Condition key. (NotNull)

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsTaxClassCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsTaxClassCQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsTaxClassCQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -488,8 +488,22 @@
     public void setDescription_NotInScope(java.util.List<String> descriptionList) {
         registerDescription(ConditionKey.CK_NOT_IN_SCOPE, filterRemoveEmptyStringFromList(descriptionList));
     }
-                                                    
+                                                
     /**
+     * Set the value of description using isNull. { is null }
+     */
+    public void setDescription_IsNull() {
+        registerDescription(ConditionKey.CK_IS_NULL, DUMMY_OBJECT);
+    }
+
+    /**
+     * Set the value of description using isNotNull. { is not null }
+     */
+    public void setDescription_IsNotNull() {
+        registerDescription(ConditionKey.CK_IS_NOT_NULL, DUMMY_OBJECT);
+    }
+        
+    /**
      * Register condition of description.
      * 
      * @param key Condition key. (NotNull)
@@ -584,22 +598,8 @@
     public void setLastModified_FromTo(java.sql.Timestamp fromDate, java.sql.Timestamp toDate, jp.sf.pal.pompei.allcommon.cbean.coption.FromToOption fromToOption) {
         registerFromToQuery(fromDate, toDate, getCValueLastModified(), COL_LAST_MODIFIED, J_LastModified, UJ_lastModified, fromToOption);
     }
-                      
+                          
     /**
-     * Set the value of lastModified using isNull. { is null }
-     */
-    public void setLastModified_IsNull() {
-        registerLastModified(ConditionKey.CK_IS_NULL, DUMMY_OBJECT);
-    }
-
-    /**
-     * Set the value of lastModified using isNotNull. { is not null }
-     */
-    public void setLastModified_IsNotNull() {
-        registerLastModified(ConditionKey.CK_IS_NOT_NULL, DUMMY_OBJECT);
-    }
-        
-    /**
      * Register condition of lastModified.
      * 
      * @param key Condition key. (NotNull)

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsTaxRateCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsTaxRateCQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsTaxRateCQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -744,8 +744,22 @@
     public void setDescription_NotInScope(java.util.List<String> descriptionList) {
         registerDescription(ConditionKey.CK_NOT_IN_SCOPE, filterRemoveEmptyStringFromList(descriptionList));
     }
-                                                    
+                                                
     /**
+     * Set the value of description using isNull. { is null }
+     */
+    public void setDescription_IsNull() {
+        registerDescription(ConditionKey.CK_IS_NULL, DUMMY_OBJECT);
+    }
+
+    /**
+     * Set the value of description using isNotNull. { is not null }
+     */
+    public void setDescription_IsNotNull() {
+        registerDescription(ConditionKey.CK_IS_NOT_NULL, DUMMY_OBJECT);
+    }
+        
+    /**
      * Register condition of description.
      * 
      * @param key Condition key. (NotNull)
@@ -840,22 +854,8 @@
     public void setLastModified_FromTo(java.sql.Timestamp fromDate, java.sql.Timestamp toDate, jp.sf.pal.pompei.allcommon.cbean.coption.FromToOption fromToOption) {
         registerFromToQuery(fromDate, toDate, getCValueLastModified(), COL_LAST_MODIFIED, J_LastModified, UJ_lastModified, fromToOption);
     }
-                      
+                          
     /**
-     * Set the value of lastModified using isNull. { is null }
-     */
-    public void setLastModified_IsNull() {
-        registerLastModified(ConditionKey.CK_IS_NULL, DUMMY_OBJECT);
-    }
-
-    /**
-     * Set the value of lastModified using isNotNull. { is not null }
-     */
-    public void setLastModified_IsNotNull() {
-        registerLastModified(ConditionKey.CK_IS_NOT_NULL, DUMMY_OBJECT);
-    }
-        
-    /**
      * Register condition of lastModified.
      * 
      * @param key Condition key. (NotNull)

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsZoneToGeoZoneCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsZoneToGeoZoneCQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsZoneToGeoZoneCQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -622,22 +622,8 @@
     public void setLastModified_FromTo(java.sql.Timestamp fromDate, java.sql.Timestamp toDate, jp.sf.pal.pompei.allcommon.cbean.coption.FromToOption fromToOption) {
         registerFromToQuery(fromDate, toDate, getCValueLastModified(), COL_LAST_MODIFIED, J_LastModified, UJ_lastModified, fromToOption);
     }
-                      
+                          
     /**
-     * Set the value of lastModified using isNull. { is null }
-     */
-    public void setLastModified_IsNull() {
-        registerLastModified(ConditionKey.CK_IS_NULL, DUMMY_OBJECT);
-    }
-
-    /**
-     * Set the value of lastModified using isNotNull. { is not null }
-     */
-    public void setLastModified_IsNotNull() {
-        registerLastModified(ConditionKey.CK_IS_NOT_NULL, DUMMY_OBJECT);
-    }
-        
-    /**
      * Register condition of lastModified.
      * 
      * @param key Condition key. (NotNull)

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsBargainCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsBargainCQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsBargainCQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -370,7 +370,7 @@
         return getDateAdded();
     }
 
-                                    
+                                
     /**
      * Add order-by of dateAdded as ASC.
      * 
@@ -412,7 +412,7 @@
         return getLastModified();
     }
 
-                                    
+                                
     /**
      * Add order-by of lastModified as ASC.
      * 

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsCategoryCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsCategoryCQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsCategoryCQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -414,7 +414,7 @@
         return getSortOrder();
     }
 
-                                                      
+                                                  
     /**
      * Add order-by of sortOrder as ASC.
      * 
@@ -456,7 +456,7 @@
         return getDateAdded();
     }
 
-                                    
+                                
     /**
      * Add order-by of dateAdded as ASC.
      * 
@@ -498,7 +498,7 @@
         return getLastModified();
     }
 
-                                    
+                                
     /**
      * Add order-by of lastModified as ASC.
      * 

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsCustomerBasketAttributeCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsCustomerBasketAttributeCQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsCustomerBasketAttributeCQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -466,7 +466,7 @@
         return getDateAdded();
     }
 
-                                    
+                                
     /**
      * Add order-by of dateAdded as ASC.
      * 

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsCustomerCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsCustomerCQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsCustomerCQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -198,6 +198,42 @@
         registerIncludedSelectColumn(aliasName, getRealColumnName("EMAIL_ADDRESS"));
     }
   
+    /**
+     * Include select-column of lastModified as mine.
+     * Alias name is java-name of this column.
+     * Be careful to whether your table have the same column.
+     */
+    public void includeAsMine_LastModified() {
+        registerIncludedSelectColumn("LastModified", getRealColumnName("LAST_MODIFIED"));
+    }
+
+    /**
+     * Include select-column of lastModified as mine.
+     * 
+     * @param aliasName Alias name. {select columnName as aliasName from ...} This should not contain comma. (NotNull)
+     */
+    public void includeAsMine_LastModified(String aliasName) {
+        registerIncludedSelectColumn(aliasName, getRealColumnName("LAST_MODIFIED"));
+    }
+  
+    /**
+     * Include select-column of dateAdded as mine.
+     * Alias name is java-name of this column.
+     * Be careful to whether your table have the same column.
+     */
+    public void includeAsMine_DateAdded() {
+        registerIncludedSelectColumn("DateAdded", getRealColumnName("DATE_ADDED"));
+    }
+
+    /**
+     * Include select-column of dateAdded as mine.
+     * 
+     * @param aliasName Alias name. {select columnName as aliasName from ...} This should not contain comma. (NotNull)
+     */
+    public void includeAsMine_DateAdded(String aliasName) {
+        registerIncludedSelectColumn(aliasName, getRealColumnName("DATE_ADDED"));
+    }
+  
     // ===================================================================================
     //                                                                               Query
     //                                                                               =====
@@ -733,6 +769,90 @@
         getSqlClause().registerOrderBy(getRealColumnName(COL_EMAIL_ADDRESS), null, false);return this;
     }
       
+    // /- - - - - - - - - - - - - - - - - - - - - - -
+    //   Column = [LAST_MODIFIED]
+    // - - - - - - - - -/
+
+    /** The attribute of lastModified. */
+    protected ConditionValue _lastModified;
+
+    /**
+     * Get the value of lastModified.
+     * 
+     * @return The value of lastModified.
+     */
+    public ConditionValue getLastModified() {
+        if (_lastModified == null) {
+            _lastModified = new ConditionValue();
+        }
+        return _lastModified;
+    }
+
+    protected ConditionValue getCValueLastModified() {
+        return getLastModified();
+    }
+
+                                
+    /**
+     * Add order-by of lastModified as ASC.
+     * 
+     * @return this. (NotNull)
+     */
+    public BsCustomerCQ addOrderBy_LastModified_Asc() {
+        getSqlClause().registerOrderBy(getRealColumnName(COL_LAST_MODIFIED), null, true);return this;
+    }
+
+    /**
+     * Add order-by of lastModified as DESC.
+     * 
+     * @return this. (NotNull)
+     */
+    public BsCustomerCQ addOrderBy_LastModified_Desc() {
+        getSqlClause().registerOrderBy(getRealColumnName(COL_LAST_MODIFIED), null, false);return this;
+    }
+      
+    // /- - - - - - - - - - - - - - - - - - - - - - -
+    //   Column = [DATE_ADDED]
+    // - - - - - - - - -/
+
+    /** The attribute of dateAdded. */
+    protected ConditionValue _dateAdded;
+
+    /**
+     * Get the value of dateAdded.
+     * 
+     * @return The value of dateAdded.
+     */
+    public ConditionValue getDateAdded() {
+        if (_dateAdded == null) {
+            _dateAdded = new ConditionValue();
+        }
+        return _dateAdded;
+    }
+
+    protected ConditionValue getCValueDateAdded() {
+        return getDateAdded();
+    }
+
+                                
+    /**
+     * Add order-by of dateAdded as ASC.
+     * 
+     * @return this. (NotNull)
+     */
+    public BsCustomerCQ addOrderBy_DateAdded_Asc() {
+        getSqlClause().registerOrderBy(getRealColumnName(COL_DATE_ADDED), null, true);return this;
+    }
+
+    /**
+     * Add order-by of dateAdded as DESC.
+     * 
+     * @return this. (NotNull)
+     */
+    public BsCustomerCQ addOrderBy_DateAdded_Desc() {
+        getSqlClause().registerOrderBy(getRealColumnName(COL_DATE_ADDED), null, false);return this;
+    }
+      
     // ===================================================================================
     //                                                                         Union Query
     //                                                                         ===========

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsGeoZoneCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsGeoZoneCQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsGeoZoneCQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -290,7 +290,7 @@
         return getDescription();
     }
 
-                                                  
+                                                      
     /**
      * Add order-by of description as ASC.
      * 
@@ -332,7 +332,7 @@
         return getLastModified();
     }
 
-                                    
+                                
     /**
      * Add order-by of lastModified as ASC.
      * 

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsManufacturerCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsManufacturerCQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsManufacturerCQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -364,7 +364,7 @@
         return getDateAdded();
     }
 
-                                    
+                                
     /**
      * Add order-by of dateAdded as ASC.
      * 
@@ -406,7 +406,7 @@
         return getLastModified();
     }
 
-                                    
+                                
     /**
      * Add order-by of lastModified as ASC.
      * 

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsOrderFormCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsOrderFormCQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsOrderFormCQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -3292,7 +3292,7 @@
         return getLastModified();
     }
 
-                                    
+                                
     /**
      * Add order-by of lastModified as ASC.
      * 
@@ -3392,7 +3392,7 @@
         return getPurchasedDate();
     }
 
-                                    
+                                
     /**
      * Add order-by of purchasedDate as ASC.
      * 

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsProductCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsProductCQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsProductCQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -1108,7 +1108,7 @@
         return getLastModified();
     }
 
-                                    
+                                
     /**
      * Add order-by of lastModified as ASC.
      * 

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsReviewCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsReviewCQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsReviewCQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -484,7 +484,7 @@
         return getDateAdded();
     }
 
-                                    
+                                
     /**
      * Add order-by of dateAdded as ASC.
      * 
@@ -526,7 +526,7 @@
         return getLastModified();
     }
 
-                                    
+                                
     /**
      * Add order-by of lastModified as ASC.
      * 

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsTaxClassCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsTaxClassCQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsTaxClassCQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -322,7 +322,7 @@
         return getDescription();
     }
 
-                                                  
+                                                      
     /**
      * Add order-by of description as ASC.
      * 
@@ -364,7 +364,7 @@
         return getLastModified();
     }
 
-                                    
+                                
     /**
      * Add order-by of lastModified as ASC.
      * 

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsTaxRateCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsTaxRateCQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsTaxRateCQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -470,7 +470,7 @@
         return getDescription();
     }
 
-                                                  
+                                                      
     /**
      * Add order-by of description as ASC.
      * 
@@ -512,7 +512,7 @@
         return getLastModified();
     }
 
-                                    
+                                
     /**
      * Add order-by of lastModified as ASC.
      * 

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsZoneToGeoZoneCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsZoneToGeoZoneCQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsZoneToGeoZoneCQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -408,7 +408,7 @@
         return getLastModified();
     }
 
-                                    
+                                
     /**
      * Add order-by of lastModified as ASC.
      * 

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/BargainCIQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/BargainCIQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/BargainCIQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -111,7 +111,7 @@
         return _myCQ.getDateAdded();
     }
 
-                                          
+                                      
     // /- - - - - - - - - - - - - - - - - - - - - - -
     //   Column = [LAST_MODIFIED]
     // - - - - - - - - -/
@@ -119,7 +119,7 @@
         return _myCQ.getLastModified();
     }
 
-                                          
+                                      
     // /- - - - - - - - - - - - - - - - - - - - - - -
     //   Column = [START_DATE]
     // - - - - - - - - -/

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/CategoryCIQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/CategoryCIQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/CategoryCIQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -133,7 +133,7 @@
         return _myCQ.getSortOrder();
     }
 
-                                                            
+                                                        
     // /- - - - - - - - - - - - - - - - - - - - - - -
     //   Column = [DATE_ADDED]
     // - - - - - - - - -/
@@ -141,7 +141,7 @@
         return _myCQ.getDateAdded();
     }
 
-                                          
+                                      
     // /- - - - - - - - - - - - - - - - - - - - - - -
     //   Column = [LAST_MODIFIED]
     // - - - - - - - - -/
@@ -149,5 +149,5 @@
         return _myCQ.getLastModified();
     }
 
-                                          
+                                      
 }

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/CustomerBasketAttributeCIQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/CustomerBasketAttributeCIQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/CustomerBasketAttributeCIQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -139,5 +139,5 @@
         return _myCQ.getDateAdded();
     }
 
-                                          
+                                      
 }

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/CustomerCIQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/CustomerCIQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/CustomerCIQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -194,4 +194,20 @@
     }
 
                                                         
+    // /- - - - - - - - - - - - - - - - - - - - - - -
+    //   Column = [LAST_MODIFIED]
+    // - - - - - - - - -/
+    protected ConditionValue getCValueLastModified() {
+        return _myCQ.getLastModified();
+    }
+
+                                      
+    // /- - - - - - - - - - - - - - - - - - - - - - -
+    //   Column = [DATE_ADDED]
+    // - - - - - - - - -/
+    protected ConditionValue getCValueDateAdded() {
+        return _myCQ.getDateAdded();
+    }
+
+                                      
 }

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/GeoZoneCIQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/GeoZoneCIQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/GeoZoneCIQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -108,7 +108,7 @@
         return _myCQ.getDescription();
     }
 
-                                                        
+                                                            
     // /- - - - - - - - - - - - - - - - - - - - - - -
     //   Column = [LAST_MODIFIED]
     // - - - - - - - - -/
@@ -116,7 +116,7 @@
         return _myCQ.getLastModified();
     }
 
-                                          
+                                      
     // /- - - - - - - - - - - - - - - - - - - - - - -
     //   Column = [DATE_ADDED]
     // - - - - - - - - -/

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ManufacturerCIQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ManufacturerCIQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ManufacturerCIQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -125,7 +125,7 @@
         return _myCQ.getDateAdded();
     }
 
-                                          
+                                      
     // /- - - - - - - - - - - - - - - - - - - - - - -
     //   Column = [LAST_MODIFIED]
     // - - - - - - - - -/
@@ -133,5 +133,5 @@
         return _myCQ.getLastModified();
     }
 
-                                          
+                                      
 }

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/OrderFormCIQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/OrderFormCIQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/OrderFormCIQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -516,7 +516,7 @@
         return _myCQ.getLastModified();
     }
 
-                                          
+                                      
     // /- - - - - - - - - - - - - - - - - - - - - - -
     //   Column = [ORDER_STATUS_ID]
     // - - - - - - - - -/
@@ -536,7 +536,7 @@
         return _myCQ.getPurchasedDate();
     }
 
-                                          
+                                      
     // /- - - - - - - - - - - - - - - - - - - - - - -
     //   Column = [FINISHED_DATE]
     // - - - - - - - - -/

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ProductCIQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ProductCIQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ProductCIQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -262,7 +262,7 @@
         return _myCQ.getLastModified();
     }
 
-                                          
+                                      
     // /- - - - - - - - - - - - - - - - - - - - - - -
     //   Column = [DATE_AVAILABLE]
     // - - - - - - - - -/

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ReviewCIQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ReviewCIQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ReviewCIQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -140,7 +140,7 @@
         return _myCQ.getDateAdded();
     }
 
-                                          
+                                      
     // /- - - - - - - - - - - - - - - - - - - - - - -
     //   Column = [LAST_MODIFIED]
     // - - - - - - - - -/
@@ -148,5 +148,5 @@
         return _myCQ.getLastModified();
     }
 
-                                          
+                                      
 }

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/TaxClassCIQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/TaxClassCIQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/TaxClassCIQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -117,7 +117,7 @@
         return _myCQ.getDescription();
     }
 
-                                                        
+                                                            
     // /- - - - - - - - - - - - - - - - - - - - - - -
     //   Column = [LAST_MODIFIED]
     // - - - - - - - - -/
@@ -125,7 +125,7 @@
         return _myCQ.getLastModified();
     }
 
-                                          
+                                      
     // /- - - - - - - - - - - - - - - - - - - - - - -
     //   Column = [DATE_ADDED]
     // - - - - - - - - -/

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/TaxRateCIQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/TaxRateCIQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/TaxRateCIQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -131,7 +131,7 @@
         return _myCQ.getDescription();
     }
 
-                                                        
+                                                            
     // /- - - - - - - - - - - - - - - - - - - - - - -
     //   Column = [LAST_MODIFIED]
     // - - - - - - - - -/
@@ -139,7 +139,7 @@
         return _myCQ.getLastModified();
     }
 
-                                          
+                                      
     // /- - - - - - - - - - - - - - - - - - - - - - -
     //   Column = [DATE_ADDED]
     // - - - - - - - - -/

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ZoneToGeoZoneCIQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ZoneToGeoZoneCIQ.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ZoneToGeoZoneCIQ.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -127,7 +127,7 @@
         return _myCQ.getLastModified();
     }
 
-                                          
+                                      
     // /- - - - - - - - - - - - - - - - - - - - - - -
     //   Column = [DATE_ADDED]
     // - - - - - - - - -/

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/web/admin/product/CategoryEditAction.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/web/admin/product/CategoryEditAction.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/web/admin/product/CategoryEditAction.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -7,6 +7,9 @@
 import java.util.List;
 import java.util.Map;
 
+import org.seasar.teeda.extension.annotation.takeover.TakeOver;
+import org.seasar.teeda.extension.annotation.takeover.TakeOverType;
+
 import jp.sf.pal.common.util.FacesMessageUtil;
 import jp.sf.pal.pompei.PompeiConstants;
 import jp.sf.pal.pompei.dxo.CategoryDxo;
@@ -73,17 +76,15 @@
             CategoryDescription cd = categoryService.getCategoryDescription(
                     categoryEditPage.getTargetId(), getLanguageService()
                             .getDefaultLanguage().getLanguageId());
-            Category c = cd.getCategory();
 
             getCategoryDxo().convert(cd, getCategoryEditPage());
             getCategoryDxo().convert(cd.getCategory(), getCategoryEditPage());
 
         } else {
             // insert
-            //TODO needs to use TakeOver on 
-            categoryEditPage.setName("");
-            categoryEditPage.setImage("");
-            categoryEditPage.setSortOrder(null);
+            //            categoryEditPage.setName("");
+            //            categoryEditPage.setImage("");
+            //            categoryEditPage.setSortOrder(null);
         }
 
         // redner FacesMessages
@@ -91,6 +92,7 @@
         return null;
     }
 
+    @TakeOver(type = TakeOverType.INCLUDE, properties = "mode,targetId,parentId")
     public Class<?> doUpdate() {
 
         List<Map<String, Object>> list = categoryEditPage.getBreadcrumbItems();
@@ -111,6 +113,8 @@
             d.setCategory(c);
             c.setParentId(parentId);
             categoryService.addCategoryDescription(d);
+
+            categoryEditPage.setTargetId(d.getCategoryId());
         } else {
             // update
             CategoryDescription d = getCategoryService()
@@ -129,7 +133,8 @@
             categoryService.updateCategoryDescription(d);
         }
 
-        categoryEditPage.setTargetId(parentId);
+        //needed?
+        //        categoryEditPage.setTargetId(parentId);
 
         //TODO put message
         return CategoryListPage.class;

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/web/admin/product/ManufacturerEditAction.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/web/admin/product/ManufacturerEditAction.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/web/admin/product/ManufacturerEditAction.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -59,7 +59,7 @@
         return null;
     }
 
-    @TakeOver(type = TakeOverType.INCLUDE, properties = "mode,targetId")
+    @TakeOver(type = TakeOverType.INCLUDE, properties = "mode,manufacturerId")
     public Class<?> doUpdate() {
         if (isUpdate()) {
             // update

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/web/admin/product/ProductEditAction.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/web/admin/product/ProductEditAction.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/web/admin/product/ProductEditAction.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -6,6 +6,9 @@
 import java.util.List;
 import java.util.Map;
 
+import org.seasar.teeda.extension.annotation.takeover.TakeOver;
+import org.seasar.teeda.extension.annotation.takeover.TakeOverType;
+
 import jp.sf.pal.common.CommonException;
 import jp.sf.pal.common.util.FacesMessageUtil;
 import jp.sf.pal.pompei.PompeiConstants;
@@ -92,16 +95,15 @@
             productDxo.convert(description, productEditPage);
         } else {
             //insert
-            // TODO needs to use TakeOver
-            productEditPage.setMode(PompeiConstants.INSERT_MODE);
-            productEditPage.setName("");
-            productEditPage.setModel("");
-            productEditPage.setImage("");
-            BigDecimal zero = new BigDecimal("0");
-            productEditPage.setPrice(zero);
-            productEditPage.setQuantity(zero);
-            productEditPage.setStatus(zero);
-            productEditPage.setWeight(zero);
+            //            productEditPage.setMode(PompeiConstants.INSERT_MODE);
+            //            productEditPage.setName("");
+            //            productEditPage.setModel("");
+            //            productEditPage.setImage("");
+            //            BigDecimal zero = new BigDecimal("0");
+            //            productEditPage.setPrice(zero);
+            //            productEditPage.setQuantity(zero);
+            //            productEditPage.setStatus(zero);
+            //            productEditPage.setWeight(zero);
         }
 
         // render faces messages
@@ -109,6 +111,7 @@
         return null;
     }
 
+    @TakeOver(type = TakeOverType.INCLUDE, properties = "mode,productId")
     public Class<?> doUpdate() {
         if (isInsert()) {
             // insert
@@ -155,13 +158,13 @@
     }
 
     private boolean isUpdate() {
-        String mode = productEditPage.getMode();
-        return mode != null && mode.equals(PompeiConstants.UPDATE_MODE);
+        return PompeiConstants.UPDATE_MODE.equals(getProductEditPage()
+                .getMode());
     }
 
     private boolean isInsert() {
-        String mode = productEditPage.getMode();
-        return mode != null && mode.equals(PompeiConstants.INSERT_MODE);
+        return PompeiConstants.INSERT_MODE.equals(getProductEditPage()
+                .getMode());
     }
 
     /**

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/web/user/checkout/UserInfoEditAction.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/web/user/checkout/UserInfoEditAction.java	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/web/user/checkout/UserInfoEditAction.java	2007-09-25 07:09:39 UTC (rev 582)
@@ -2,6 +2,7 @@
 
 import java.io.Serializable;
 import java.math.BigDecimal;
+import java.sql.Timestamp;
 import java.util.Date;
 import java.util.HashMap;
 
@@ -76,7 +77,10 @@
     }
 
     public Class<?> doRegister() {
+        Date now = new Date();
         Customer customer = new Customer();
+        customer.setDateAdded(new Timestamp(now.getTime()));
+        customer.setLastModified(new Timestamp(now.getTime()));
         AddressBook addressBook = new AddressBook();
         getCustomerDxo().convert(getUserInfoEditPage(), customer);
         getCustomerDxo().convert(getUserInfoEditPage(), addressBook);

Modified: pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql	2007-09-25 07:09:39 UTC (rev 582)
@@ -7,6 +7,8 @@
      , NICKNAME VARCHAR(64)
      , DAY_OF_BIRTH DATE NOT NULL DEFAULT '0000-00-00 00:00:00'
      , EMAIL_ADDRESS VARCHAR(128) NOT NULL
+     , LAST_MODIFIED TIMESTAMP NOT NULL
+     , DATE_ADDED TIMESTAMP NOT NULL
      , PRIMARY KEY (CUSTOMER_ID)
 );
 
@@ -24,8 +26,8 @@
 CREATE TABLE GEO_ZONE (
        GEO_ZONE_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , NAME VARCHAR(32) NOT NULL
-     , DESCRIPTION VARCHAR(255) NOT NULL
-     , LAST_MODIFIED TIMESTAMP
+     , DESCRIPTION VARCHAR(255)
+     , LAST_MODIFIED TIMESTAMP NOT NULL
      , DATE_ADDED TIMESTAMP NOT NULL
      , PRIMARY KEY (GEO_ZONE_ID)
 );
@@ -44,8 +46,8 @@
        MANUFACTURER_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , NAME VARCHAR(32) NOT NULL
      , IMAGE VARCHAR(64)
-     , DATE_ADDED TIMESTAMP
-     , LAST_MODIFIED TIMESTAMP
+     , DATE_ADDED TIMESTAMP NOT NULL
+     , LAST_MODIFIED TIMESTAMP NOT NULL
      , PRIMARY KEY (MANUFACTURER_ID)
 );
 
@@ -71,8 +73,8 @@
 CREATE TABLE TAX_CLASS (
        TAX_CLASS_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , NAME VARCHAR(32) NOT NULL
-     , DESCRIPTION VARCHAR(255) NOT NULL
-     , LAST_MODIFIED TIMESTAMP
+     , DESCRIPTION VARCHAR(255)
+     , LAST_MODIFIED TIMESTAMP NOT NULL
      , DATE_ADDED TIMESTAMP NOT NULL
      , PRIMARY KEY (TAX_CLASS_ID)
 );
@@ -171,9 +173,9 @@
      , ORDER_CARD_INFO_ID BIGINT
      , DELIVERY_METHOD_ID INTEGER
      , DELIVERY_METHOD_CODE VARCHAR(16) NOT NULL
-     , LAST_MODIFIED TIMESTAMP
+     , LAST_MODIFIED TIMESTAMP NOT NULL
      , ORDER_STATUS_ID INTEGER NOT NULL
-     , PURCHASED_DATE TIMESTAMP
+     , PURCHASED_DATE TIMESTAMP NOT NULL
      , FINISHED_DATE TIMESTAMP
      , CURRENCY_ID INTEGER
      , CURRENCY_CODE CHAR(3) NOT NULL
@@ -195,7 +197,7 @@
      , ORDERED INTEGER NOT NULL DEFAULT 0
      , STATUS INTEGER NOT NULL
      , DATE_ADDED TIMESTAMP NOT NULL
-     , LAST_MODIFIED TIMESTAMP
+     , LAST_MODIFIED TIMESTAMP NOT NULL
      , DATE_AVAILABLE TIMESTAMP
      , TAX_CLASS_ID INTEGER
      , MANUFACTURER_ID INTEGER
@@ -206,9 +208,9 @@
        CATEGORY_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , IMAGE VARCHAR(64)
      , PARENT_ID INTEGER DEFAULT 0
-     , SORT_ORDER INTEGER
-     , DATE_ADDED TIMESTAMP
-     , LAST_MODIFIED TIMESTAMP
+     , SORT_ORDER INTEGER NOT NULL
+     , DATE_ADDED TIMESTAMP NOT NULL
+     , LAST_MODIFIED TIMESTAMP NOT NULL
      , PRIMARY KEY (CATEGORY_ID)
 );
 
@@ -218,8 +220,8 @@
      , CUSTOMER_ID BIGINT
      , CUSTOMER_NICKNAME VARCHAR(64) NOT NULL
      , RATING INTEGER
-     , DATE_ADDED TIMESTAMP
-     , LAST_MODIFIED TIMESTAMP
+     , DATE_ADDED TIMESTAMP NOT NULL
+     , LAST_MODIFIED TIMESTAMP NOT NULL
      , PRIMARY KEY (REVIEW_ID)
 );
 
@@ -265,7 +267,7 @@
      , PRODUCT_ID BIGINT NOT NULL
      , PRODUCTS_OPTION_ID BIGINT NOT NULL
      , PRODUCTS_OPTION_VALUE_ID BIGINT NOT NULL
-     , DATE_ADDED TIMESTAMP
+     , DATE_ADDED TIMESTAMP NOT NULL
      , PRIMARY KEY (CUSTOMERS_BASKET_ATTRIBUTE_ID)
 );
 
@@ -386,8 +388,8 @@
        BARGAIN_ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
      , PRODUCT_ID BIGINT NOT NULL
      , BARGAIN_PRICE DECIMAL(15, 4) NOT NULL
-     , DATE_ADDED TIMESTAMP
-     , LAST_MODIFIED TIMESTAMP
+     , DATE_ADDED TIMESTAMP NOT NULL
+     , LAST_MODIFIED TIMESTAMP NOT NULL
      , START_DATE TIMESTAMP
      , EXPIRE_DATE TIMESTAMP
      , STATUS INTEGER NOT NULL DEFAULT 1
@@ -400,8 +402,8 @@
      , TAX_CLASS_ID INTEGER NOT NULL
      , PRIORITY INTEGER DEFAULT 1
      , RATE DECIMAL(7, 4) NOT NULL
-     , DESCRIPTION VARCHAR(255) NOT NULL
-     , LAST_MODIFIED TIMESTAMP
+     , DESCRIPTION VARCHAR(255)
+     , LAST_MODIFIED TIMESTAMP NOT NULL
      , DATE_ADDED TIMESTAMP NOT NULL
      , PRIMARY KEY (TAX_RATES_ID)
 );
@@ -411,7 +413,7 @@
      , COUNTRY_ID INTEGER NOT NULL
      , ZONE_ID INTEGER
      , GEO_ZONE_ID INTEGER
-     , LAST_MODIFIED TIMESTAMP
+     , LAST_MODIFIED TIMESTAMP NOT NULL
      , DATE_ADDED TIMESTAMP NOT NULL
      , PRIMARY KEY (ASSOCIATION_ID)
 );

Modified: pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/insert_data.sql
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/insert_data.sql	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/insert_data.sql	2007-09-25 07:09:39 UTC (rev 582)
@@ -22,5 +22,5 @@
 
 INSERT INTO TAX_RATE VALUES (1, 130, 1, 1, 5.0, '税率5.0%', '2007-01-01 00:00:00', '2007-01-01 00:00:00');
 
-INSERT INTO CATEGORY VALUES (1, '', null, 1, '2007-01-01 00:00:00', null);
+INSERT INTO CATEGORY VALUES (1, '', null, 1, '2007-01-01 00:00:00', '2007-01-01 00:00:00');
 

Modified: pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/insert_sample_data.sql
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/insert_sample_data.sql	2007-09-25 05:33:00 UTC (rev 581)
+++ pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/insert_sample_data.sql	2007-09-25 07:09:39 UTC (rev 582)
@@ -355,9 +355,9 @@
 INSERT INTO MANUFACTURER_DESCRIPTION VALUES (2,1,'http://www.microsoft.com/','ソフトウェア会社',NULL);
 INSERT INTO MANUFACTURER_DESCRIPTION VALUES (3,1,'http://www.warner.com',NULL,NULL);
 
-INSERT INTO PRODUCT VALUES (1,'MG200MMS',100,'1000.0000','100.00',NULL,NULL,0,1,'2007-09-20 12:31:53','2007-09-20 12:31:53','0000-00-00 00:00:00',1,1);
-INSERT INTO PRODUCT VALUES (2,'MG400-32MB',100,'2000.0000','200.00',NULL,NULL,0,1,'2007-09-20 12:32:34','2007-09-20 12:32:34','0000-00-00 00:00:00',1,1);
-INSERT INTO PRODUCT VALUES (3,'WINDOWS-XP',100,'10000.0000','100.00',NULL,NULL,0,1,'2007-09-20 12:33:59','2007-09-20 12:33:59','0000-00-00 00:00:00',1,2);
+INSERT INTO PRODUCT VALUES (1,'MG200MMS',100,1000.0000,100.00,NULL,NULL,0,1,'2007-09-20 12:31:53','2007-09-20 12:31:53',NULL,1,1);
+INSERT INTO PRODUCT VALUES (2,'MG400-32MB',100,2000.0000,200.00,NULL,NULL,0,1,'2007-09-20 12:32:34','2007-09-20 12:32:34',NULL,1,1);
+INSERT INTO PRODUCT VALUES (3,'WINDOWS-XP',100,10000.0000,100.00,NULL,NULL,0,1,'2007-09-20 12:33:59','2007-09-20 12:33:59',NULL,1,2);
 
 INSERT INTO PRODUCT_DESCRIPTION VALUES (1,1,'Matrox G200 MMS',NULL,NULL,0);
 INSERT INTO PRODUCT_DESCRIPTION VALUES (2,1,'Matrox G400 32MB',NULL,NULL,0);


pal-cvs メーリングリストの案内