[pal-cvs 2799] [543] changed a type of CUSTOMERS_BASKET_DATE_ADDED to TIMESTAMP

svnno****@sourc***** svnno****@sourc*****
2007年 9月 6日 (木) 17:03:37 JST


Revision: 543
          http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=543
Author:   shinsuke
Date:     2007-09-06 17:03:36 +0900 (Thu, 06 Sep 2007)

Log Message:
-----------
changed a type of CUSTOMERS_BASKET_DATE_ADDED to TIMESTAMP

Modified Paths:
--------------
    pompei/portlets/pompei-core/trunk/src/main/config/pompei.clay
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/PompeiConstants.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsCustomersBasket.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/CustomersBasketDbm.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsCustomersBasketCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsCustomersBasketCQ.java
    pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/CustomersBasketCIQ.java
    pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql


-------------- next part --------------
Modified: pompei/portlets/pompei-core/trunk/src/main/config/pompei.clay
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/config/pompei.clay	2007-09-06 07:45:26 UTC (rev 542)
+++ pompei/portlets/pompei-core/trunk/src/main/config/pompei.clay	2007-09-06 08:03:36 UTC (rev 543)
@@ -353,7 +353,7 @@
 </table>
 <table alias="" name="CATEGORIES" remarks="">
 <table-description></table-description>
-<table-figure-bounds height="-1" width="-1" x="730" y="2829"/>
+<table-figure-bounds height="-1" width="-1" x="932" y="3037"/>
 <column-list>
 <column alias="" auto-increment="true" column-size="10" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="CATEGORIES_ID" remarks="">
 <column-description></column-description>
@@ -421,7 +421,7 @@
 </table>
 <table alias="" name="CATEGORIES_DESCRIPTION" remarks="">
 <table-description></table-description>
-<table-figure-bounds height="-1" width="-1" x="856" y="2667"/>
+<table-figure-bounds height="-1" width="-1" x="1057" y="2747"/>
 <column-list>
 <column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="0" mandatory="true" name="CATEGORIES_ID" remarks="">
 <column-description></column-description>
@@ -908,7 +908,7 @@
 </table>
 <table alias="" name="CUSTOMERS_BASKET" remarks="">
 <table-description></table-description>
-<table-figure-bounds height="-1" width="-1" x="261" y="2328"/>
+<table-figure-bounds height="-1" width="-1" x="278" y="2324"/>
 <column-list>
 <column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="CUSTOMERS_BASKET_ID" remarks="">
 <column-description></column-description>
@@ -942,11 +942,13 @@
 <variant precision-max="38" precision-min="1" precision-variable="%p" type-name-pattern="DECIMAL(%p)"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="8" decimal-digits="0" default-value="" mandatory="false" name="CUSTOMERS_BASKET_DATE_ADDED" remarks="">
+<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="true" name="CUSTOMERS_BASKET_DATE_ADDED" remarks="">
 <column-description></column-description>
-<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
-<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
-<variant type-name-pattern="CHAR"/>
+<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<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)"/>
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
 </column-list>
@@ -1354,7 +1356,7 @@
 </table>
 <table alias="" name="MANUFACTURERS" remarks="">
 <table-description></table-description>
-<table-figure-bounds height="-1" width="-1" x="621" y="2534"/>
+<table-figure-bounds height="-1" width="-1" x="510" y="2492"/>
 <column-list>
 <column alias="" auto-increment="true" column-size="10" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="MANUFACTURERS_ID" remarks="">
 <column-description></column-description>
@@ -1408,7 +1410,7 @@
 </table>
 <table alias="" name="MANUFACTURERS_INFO" remarks="">
 <table-description></table-description>
-<table-figure-bounds height="-1" width="-1" x="657" y="2353"/>
+<table-figure-bounds height="-1" width="-1" x="837" y="2321"/>
 <column-list>
 <column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="MANUFACTURERS_ID" remarks="">
 <column-description></column-description>
@@ -2605,7 +2607,7 @@
 </table>
 <table alias="" name="PRODUCTS_DESCRIPTION" remarks="">
 <table-description></table-description>
-<table-figure-bounds height="-1" width="-1" x="432" y="2886"/>
+<table-figure-bounds height="-1" width="-1" x="596" y="2742"/>
 <column-list>
 <column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="PRODUCTS_ID" remarks="">
 <column-description></column-description>
@@ -2835,7 +2837,7 @@
 </table>
 <table alias="" name="PRODUCTS_TO_CATEGORIES" remarks="">
 <table-description></table-description>
-<table-figure-bounds height="-1" width="-1" x="561" y="2686"/>
+<table-figure-bounds height="-1" width="-1" x="477" y="3034"/>
 <column-list>
 <column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="PRODUCTS_ID" remarks="">
 <column-description></column-description>

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/PompeiConstants.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/PompeiConstants.java	2007-09-06 07:45:26 UTC (rev 542)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/PompeiConstants.java	2007-09-06 08:03:36 UTC (rev 543)
@@ -32,4 +32,6 @@
     public static final String CATEGORIES_ID = "categoriesId";
 
     public static final String BREADCRUMB = "breadcrumb";
+
+    public static final String PRODUCTS_DESCRIPTION_LIST = "productsDescriptionList";
 }

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsCustomersBasket.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsCustomersBasket.java	2007-09-06 07:45:26 UTC (rev 542)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsCustomersBasket.java	2007-09-06 08:03:36 UTC (rev 543)
@@ -72,8 +72,8 @@
     /** The value of finalPrice. DECIMAL(15) */
     protected java.math.BigDecimal _finalPrice;
 
-    /** The value of customersBasketDateAdded. CHAR(8) */
-    protected String _customersBasketDateAdded;
+    /** The value of customersBasketDateAdded. TIMESTAMP : NotNull */
+    protected java.sql.Timestamp _customersBasketDateAdded;
 
     // ===================================================================================
     //                                                                         Constructor
@@ -260,26 +260,26 @@
         this._finalPrice = finalPrice;
     }
 
-    /** Column Annotation for S2Dao. CHAR(8) */
+    /** Column Annotation for S2Dao. TIMESTAMP : NotNull */
     public static final String customersBasketDateAdded_COLUMN = "CUSTOMERS_BASKET_DATE_ADDED";
 
     /**
      * Get the value of customersBasketDateAdded. <br />
-     * {CHAR(8)}
+     * {TIMESTAMP : NotNull}
      * 
      * @return The value of customersBasketDateAdded. (Nullable)
      */
-    public String getCustomersBasketDateAdded() {
+    public java.sql.Timestamp getCustomersBasketDateAdded() {
         return _customersBasketDateAdded;
     }
 
     /**
      * Set the value of customersBasketDateAdded. <br />
-     * {CHAR(8)}
+     * {TIMESTAMP : NotNull}
      * 
      * @param customersBasketDateAdded The value of customersBasketDateAdded. (Nullable)
      */
-    public void setCustomersBasketDateAdded(String customersBasketDateAdded) {
+    public void setCustomersBasketDateAdded(java.sql.Timestamp customersBasketDateAdded) {
         _modifiedProperties.addPropertyName("customersBasketDateAdded");
         this._customersBasketDateAdded = customersBasketDateAdded;
     }

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/CustomersBasketDbm.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/CustomersBasketDbm.java	2007-09-06 07:45:26 UTC (rev 542)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/CustomersBasketDbm.java	2007-09-06 08:03:36 UTC (rev 543)
@@ -103,7 +103,7 @@
     public static final String DB_NAME_CUSTOMERS_BASKET_QUANTITY = "CUSTOMERS_BASKET_QUANTITY";
     /** Db-name of FINAL_PRICE. DECIMAL(15) */
     public static final String DB_NAME_FINAL_PRICE = "FINAL_PRICE";
-    /** Db-name of CUSTOMERS_BASKET_DATE_ADDED. CHAR(8) */
+    /** Db-name of CUSTOMERS_BASKET_DATE_ADDED. TIMESTAMP : NotNull */
     public static final String DB_NAME_CUSTOMERS_BASKET_DATE_ADDED = "CUSTOMERS_BASKET_DATE_ADDED";
 
     /** @deprecated Deprecated! So use DB_NAME_CustomersBasketId. */
@@ -132,7 +132,7 @@
     public static final String PROPERTY_NAME_customersBasketQuantity = "customersBasketQuantity";
     /** Prop-name(JavaBeansRule) of finalPrice. DECIMAL(15) */
     public static final String PROPERTY_NAME_finalPrice = "finalPrice";
-    /** Prop-name(JavaBeansRule) of customersBasketDateAdded. CHAR(8) */
+    /** Prop-name(JavaBeansRule) of customersBasketDateAdded. TIMESTAMP : NotNull */
     public static final String PROPERTY_NAME_customersBasketDateAdded = "customersBasketDateAdded";
 
     // -----------------------------------------------------
@@ -148,7 +148,7 @@
     public static final String CAP_PROP_NAME_CustomersBasketQuantity = "CustomersBasketQuantity";
     /** Cap-prop-name of finalPrice. DECIMAL(15) */
     public static final String CAP_PROP_NAME_FinalPrice = "FinalPrice";
-    /** Cap-prop-name of customersBasketDateAdded. CHAR(8) */
+    /** Cap-prop-name of customersBasketDateAdded. TIMESTAMP : NotNull */
     public static final String CAP_PROP_NAME_CustomersBasketDateAdded = "CustomersBasketDateAdded";
 
     /** @deprecated Deprecated! So use CAP_PROP_NAME_CustomersBasketId. */
@@ -177,7 +177,7 @@
     public static final String UNCAP_PROP_NAME_customersBasketQuantity = "customersBasketQuantity";
     /** Uncap-prop-name of finalPrice. DECIMAL(15) */
     public static final String UNCAP_PROP_NAME_finalPrice = "finalPrice";
-    /** Uncap-prop-name of customersBasketDateAdded. CHAR(8) */
+    /** Uncap-prop-name of customersBasketDateAdded. TIMESTAMP : NotNull */
     public static final String UNCAP_PROP_NAME_customersBasketDateAdded = "customersBasketDateAdded";
 
     /** @deprecated Deprecated! So use UNCAP_PROP_NAME_CustomersBasketId. */
@@ -688,7 +688,7 @@
      * @return Column information of customersBasketDateAdded. (NotNull)
      */
     public ColumnInfo columnCustomersBasketDateAdded() {
-        return new ColumnInfo(this, "CUSTOMERS_BASKET_DATE_ADDED", "customersBasketDateAdded", String.class, false);
+        return new ColumnInfo(this, "CUSTOMERS_BASKET_DATE_ADDED", "customersBasketDateAdded", java.sql.Timestamp.class, false);
     }
 
     // ===================================================================================
@@ -911,7 +911,7 @@
         if (analyzer.init("PRODUCTS_ID", "productsId", "productsId")) { myEntity.setProductsId(analyzer.analyzeNumber(java.math.BigDecimal.class)); };
         if (analyzer.init("CUSTOMERS_BASKET_QUANTITY", "customersBasketQuantity", "customersBasketQuantity")) { myEntity.setCustomersBasketQuantity(analyzer.analyzeNumber(java.math.BigDecimal.class)); };
         if (analyzer.init("FINAL_PRICE", "finalPrice", "finalPrice")) { myEntity.setFinalPrice(analyzer.analyzeNumber(java.math.BigDecimal.class)); };
-        if (analyzer.init("CUSTOMERS_BASKET_DATE_ADDED", "customersBasketDateAdded", "customersBasketDateAdded")) { myEntity.setCustomersBasketDateAdded(analyzer.analyzeString(String.class)); };
+        if (analyzer.init("CUSTOMERS_BASKET_DATE_ADDED", "customersBasketDateAdded", "customersBasketDateAdded")) { myEntity.setCustomersBasketDateAdded(analyzer.analyzeDate(java.sql.Timestamp.class)); };
 
     }
 

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsCustomersBasketCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsCustomersBasketCQ.java	2007-09-06 07:45:26 UTC (rev 542)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsCustomersBasketCQ.java	2007-09-06 08:03:36 UTC (rev 543)
@@ -631,135 +631,73 @@
 
     /** Column uncapitalised java name of customersBasketDateAdded. */
     protected static final String UJ_customersBasketDateAdded = "customersBasketDateAdded";
-    
+                
     /**
      * Set the value of customersBasketDateAdded using equal. { = }
-     * If the value is null or empty-string, this condition is ignored.
      * 
      * @param customersBasketDateAdded The value of customersBasketDateAdded as equal.
      */
-    public void setCustomersBasketDateAdded_Equal(String customersBasketDateAdded) {
-        registerCustomersBasketDateAdded(ConditionKey.CK_EQUAL, filterRemoveEmptyString(customersBasketDateAdded));
+    public void setCustomersBasketDateAdded_Equal(java.sql.Timestamp customersBasketDateAdded) {
+        registerCustomersBasketDateAdded(ConditionKey.CK_EQUAL, customersBasketDateAdded);
     }
-                  
+      
     /**
      * Set the value of customersBasketDateAdded using notEqual. { != }
-     * If the value is null or empty-string, this condition is ignored.
      * 
      * @param customersBasketDateAdded The value of customersBasketDateAdded as notEqual.
      */
-    public void setCustomersBasketDateAdded_NotEqual(String customersBasketDateAdded) {
-        registerCustomersBasketDateAdded(ConditionKey.CK_NOT_EQUAL, filterRemoveEmptyString(customersBasketDateAdded));
+    public void setCustomersBasketDateAdded_NotEqual(java.sql.Timestamp customersBasketDateAdded) {
+        registerCustomersBasketDateAdded(ConditionKey.CK_NOT_EQUAL, customersBasketDateAdded);
     }
             
     /**
      * Set the value of customersBasketDateAdded using greaterThan. { &gt; }
-     * If the value is null or empty-string, this condition is ignored.
      * 
      * @param customersBasketDateAdded The value of customersBasketDateAdded as greaterThan.
      */
-    public void setCustomersBasketDateAdded_GreaterThan(String customersBasketDateAdded) {
-        registerCustomersBasketDateAdded(ConditionKey.CK_GREATER_THAN, filterRemoveEmptyString(customersBasketDateAdded));
+    public void setCustomersBasketDateAdded_GreaterThan(java.sql.Timestamp customersBasketDateAdded) {
+        registerCustomersBasketDateAdded(ConditionKey.CK_GREATER_THAN, customersBasketDateAdded);
     }
             
     /**
      * Set the value of customersBasketDateAdded using lessThan. { &lt; }
-     * If the value is null or empty-string, this condition is ignored.
      * 
      * @param customersBasketDateAdded The value of customersBasketDateAdded as lessThan.
      */
-    public void setCustomersBasketDateAdded_LessThan(String customersBasketDateAdded) {
-        registerCustomersBasketDateAdded(ConditionKey.CK_LESS_THAN, filterRemoveEmptyString(customersBasketDateAdded));
+    public void setCustomersBasketDateAdded_LessThan(java.sql.Timestamp customersBasketDateAdded) {
+        registerCustomersBasketDateAdded(ConditionKey.CK_LESS_THAN, customersBasketDateAdded);
     }
             
     /**
      * Set the value of customersBasketDateAdded using greaterEqual. { &gt;= }
-     * If the value is null or empty-string, this condition is ignored.
      * 
      * @param customersBasketDateAdded The value of customersBasketDateAdded as greaterEqual.
      */
-    public void setCustomersBasketDateAdded_GreaterEqual(String customersBasketDateAdded) {
-        registerCustomersBasketDateAdded(ConditionKey.CK_GREATER_EQUAL, filterRemoveEmptyString(customersBasketDateAdded));
+    public void setCustomersBasketDateAdded_GreaterEqual(java.sql.Timestamp customersBasketDateAdded) {
+        registerCustomersBasketDateAdded(ConditionKey.CK_GREATER_EQUAL, customersBasketDateAdded);
     }
             
     /**
      * Set the value of customersBasketDateAdded using lessEqual. { &lt;= }
-     * If the value is null or empty-string, this condition is ignored.
      * 
      * @param customersBasketDateAdded The value of customersBasketDateAdded as lessEqual.
      */
-    public void setCustomersBasketDateAdded_LessEqual(String customersBasketDateAdded) {
-        registerCustomersBasketDateAdded(ConditionKey.CK_LESS_EQUAL, filterRemoveEmptyString(customersBasketDateAdded));
+    public void setCustomersBasketDateAdded_LessEqual(java.sql.Timestamp customersBasketDateAdded) {
+        registerCustomersBasketDateAdded(ConditionKey.CK_LESS_EQUAL, customersBasketDateAdded);
     }
             
     /**
-     * Set the value of customersBasketDateAdded using prefixSearch. { like 'xxx%' }
-     * If the value is null or empty-string, this condition is ignored.
+     * Set the value of customersBasketDateAdded using from-to. { $fromDate <= COLUMN_NAME <= $toDate }
      * 
-     * @param customersBasketDateAdded The value of customersBasketDateAdded as prefixSearch.
+     * @param fromDate The from-date of customersBasketDateAdded. (Nullable)
+     * @param toDate The to-date of customersBasketDateAdded. (Nullable)
+     * @param fromToOption The option of from-to. (NotNull)
      */
-    public void setCustomersBasketDateAdded_PrefixSearch(String customersBasketDateAdded) {
-        registerCustomersBasketDateAdded(ConditionKey.CK_PREFIX_SEARCH, filterRemoveEmptyString(customersBasketDateAdded));
+    public void setCustomersBasketDateAdded_FromTo(java.sql.Timestamp fromDate, java.sql.Timestamp toDate, jp.sf.pal.pompei.allcommon.cbean.coption.FromToOption fromToOption) {
+        registerFromToQuery(fromDate, toDate, getCValueCustomersBasketDateAdded(), COL_CUSTOMERS_BASKET_DATE_ADDED, J_CustomersBasketDateAdded, UJ_customersBasketDateAdded, fromToOption);
     }
-            
+                          
     /**
-     * Set the value of customersBasketDateAdded using likeSearch. { like '%xxx%' }
-     * If the value is null or empty-string, this condition is ignored.
-     * You can invoke this method several times and the conditions are set up.
-     * 
-     * @param customersBasketDateAdded The value of customersBasketDateAdded as likeSearch.
-     * @param likeSearchOption The option of like-search. (NotNull)
-     */
-    public void setCustomersBasketDateAdded_LikeSearch(String customersBasketDateAdded, jp.sf.pal.pompei.allcommon.cbean.coption.LikeSearchOption likeSearchOption) {
-        registerLikeSearchQuery(ConditionKey.CK_LIKE_SEARCH, filterRemoveEmptyString(customersBasketDateAdded), getCValueCustomersBasketDateAdded(), COL_CUSTOMERS_BASKET_DATE_ADDED, J_CustomersBasketDateAdded, UJ_customersBasketDateAdded, likeSearchOption);
-    }
-            
-    /**
-     * Set the value of customersBasketDateAdded using inScope. { in ('a', 'b') }
-     * If the element in the list is null or empty-string, the condition-element is ignored.
-     * 
-     * @param customersBasketDateAddedList The value of customersBasketDateAdded as inScope.
-     */
-    public void setCustomersBasketDateAdded_InScope(java.util.List<String> customersBasketDateAddedList) {
-        registerCustomersBasketDateAdded(ConditionKey.CK_IN_SCOPE, filterRemoveEmptyStringFromList(customersBasketDateAddedList));
-    }
-
-    /**
-     * Set the value of customersBasketDateAdded using inScope. { in ('a', 'b') }
-     * If the element in the list is null or empty-string, the condition-element is ignored.
-     * 
-     * @param customersBasketDateAdded The value of customersBasketDateAdded as inScope.
-     * @param inScopeOption The option of in-scope. (NotNull)
-     */
-    public void setCustomersBasketDateAdded_InScope(String customersBasketDateAdded, jp.sf.pal.pompei.allcommon.cbean.coption.InScopeOption inScopeOption) {
-        registerInScopeQuery(ConditionKey.CK_IN_SCOPE, filterRemoveEmptyString(customersBasketDateAdded), getCValueCustomersBasketDateAdded(), COL_CUSTOMERS_BASKET_DATE_ADDED, J_CustomersBasketDateAdded, UJ_customersBasketDateAdded, inScopeOption);
-    }
-            
-    /**
-     * Set the value of customersBasketDateAdded using notInScope. { not in ('a', 'b') }
-     * If the element in the list is null or empty-string, the condition-element is ignored.
-     * 
-     * @param customersBasketDateAddedList The value of customersBasketDateAdded as notInScope.
-     */
-    public void setCustomersBasketDateAdded_NotInScope(java.util.List<String> customersBasketDateAddedList) {
-        registerCustomersBasketDateAdded(ConditionKey.CK_NOT_IN_SCOPE, filterRemoveEmptyStringFromList(customersBasketDateAddedList));
-    }
-                                                
-    /**
-     * Set the value of customersBasketDateAdded using isNull. { is null }
-     */
-    public void setCustomersBasketDateAdded_IsNull() {
-        registerCustomersBasketDateAdded(ConditionKey.CK_IS_NULL, DUMMY_OBJECT);
-    }
-
-    /**
-     * Set the value of customersBasketDateAdded using isNotNull. { is not null }
-     */
-    public void setCustomersBasketDateAdded_IsNotNull() {
-        registerCustomersBasketDateAdded(ConditionKey.CK_IS_NOT_NULL, DUMMY_OBJECT);
-    }
-        
-    /**
      * Register condition of customersBasketDateAdded.
      * 
      * @param key Condition key. (NotNull)

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsCustomersBasketCQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsCustomersBasketCQ.java	2007-09-06 07:45:26 UTC (rev 542)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsCustomersBasketCQ.java	2007-09-06 08:03:36 UTC (rev 543)
@@ -434,7 +434,7 @@
         return getCustomersBasketDateAdded();
     }
 
-                                                      
+                                
     /**
      * Add order-by of customersBasketDateAdded as ASC.
      * 

Modified: pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/CustomersBasketCIQ.java
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/CustomersBasketCIQ.java	2007-09-06 07:45:26 UTC (rev 542)
+++ pompei/portlets/pompei-core/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/CustomersBasketCIQ.java	2007-09-06 08:03:36 UTC (rev 543)
@@ -131,5 +131,5 @@
         return _myCQ.getCustomersBasketDateAdded();
     }
 
-                                                            
+                                      
 }

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-06 07:45:26 UTC (rev 542)
+++ pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql	2007-09-06 08:03:36 UTC (rev 543)
@@ -306,7 +306,7 @@
      , PRODUCTS_ID INTEGER NOT NULL
      , CUSTOMERS_BASKET_QUANTITY INTEGER NOT NULL
      , FINAL_PRICE DECIMAL(15,4)
-     , CUSTOMERS_BASKET_DATE_ADDED CHAR(8)
+     , CUSTOMERS_BASKET_DATE_ADDED TIMESTAMP NOT NULL
      , PRIMARY KEY (CUSTOMERS_BASKET_ID)
 );
 


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