svnno****@sourc*****
svnno****@sourc*****
2007年 8月 24日 (金) 22:10:47 JST
Revision: 484
http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=484
Author: shinsuke
Date: 2007-08-24 22:10:46 +0900 (Fri, 24 Aug 2007)
Log Message:
-----------
updated schema
Modified Paths:
--------------
pompei/portlets/pompei-core/trunk/dbflute/schema/project-schema-pompei.xml
pompei/portlets/pompei-core/trunk/mydbflute/dbflute-0.5.2/schema/project-schema-pompei.xml
-------------- 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-08-24 13:09:39 UTC (rev 483)
+++ pompei/portlets/pompei-core/trunk/dbflute/schema/project-schema-pompei.xml 2007-08-24 13:10:46 UTC (rev 484)
@@ -33,7 +33,7 @@
<column dbType="INTEGER" default="0"
javaType="java.math.BigDecimal" name="ENTRY_ZONE_ID"
required="true" type="INTEGER"/>
- <foreign-key foreignTable="CUSTOMERS" name="SQL070725015931120">
+ <foreign-key foreignTable="CUSTOMERS" name="SQL070824094318840">
<reference foreign="CUSTOMERS_ID" local="CUSTOMERS_ID"/>
</foreign-key>
</table>
@@ -112,7 +112,7 @@
primaryKey="true" required="true" type="INTEGER"/>
<column dbType="VARCHAR" javaType="String"
name="CATEGORIES_NAME" required="true" size="32" type="VARCHAR"/>
- <foreign-key foreignTable="CATEGORIES" name="SQL070718023316900">
+ <foreign-key foreignTable="CATEGORIES" name="SQL070824094318880">
<reference foreign="CATEGORIES_ID" local="CATEGORIES_ID"/>
</foreign-key>
</table>
@@ -204,6 +204,8 @@
default="AUTOINCREMENT: start 1 increment 1"
javaType="java.math.BigDecimal" name="CUSTOMERS_ID"
primaryKey="true" required="true" type="INTEGER"/>
+ <column dbType="VARCHAR" javaType="String"
+ name="CUSTOMERS_PORTAL_ID" required="true" size="255" type="VARCHAR"/>
<column dbType="CHAR" javaType="String" name="CUSTOMERS_GENDER"
required="true" size="1" type="CHAR"/>
<column dbType="VARCHAR" javaType="String"
@@ -225,6 +227,9 @@
name="CUSTOMERS_PASSWORD" required="true" size="40" type="VARCHAR"/>
<column dbType="CHAR" javaType="String"
name="CUSTOMERS_NEWSLETTER" size="1" type="CHAR"/>
+ <foreign-key foreignTable="ADDRESS_BOOK" name="SQL070824094318900">
+ <reference foreign="ADDRESS_BOOK_ID" local="CUSTOMERS_DEFAULT_ADDRESS_ID"/>
+ </foreign-key>
</table>
<table name="CUSTOMERS_BASKET">
<column dbType="INTEGER" javaType="java.math.BigDecimal"
@@ -324,7 +329,7 @@
required="true" type="INTEGER"/>
<column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
name="DATE_LAST_CLICK" type="TIMESTAMP"/>
- <foreign-key foreignTable="MANUFACTURERS" name="SQL070719032256430">
+ <foreign-key foreignTable="MANUFACTURERS" name="SQL070824094319010">
<reference foreign="MANUFACTURERS_ID" local="MANUFACTURERS_ID"/>
</foreign-key>
</table>
@@ -434,9 +439,11 @@
name="CURRENCY_VALUE" size="14" type="DECIMAL"/>
</table>
<table name="ORDERS_PRODUCTS">
+ <column autoIncrement="true" dbType="INTEGER"
+ default="AUTOINCREMENT: start 1 increment 1"
+ javaType="java.math.BigDecimal" name="ORDERS_PRODUCTS_ID"
+ primaryKey="true" required="true" type="INTEGER"/>
<column dbType="INTEGER" javaType="java.math.BigDecimal"
- name="ORDERS_PRODUCTS_ID" primaryKey="true" required="true" type="INTEGER"/>
- <column dbType="INTEGER" javaType="java.math.BigDecimal"
name="ORDERS_ID" required="true" type="INTEGER"/>
<column dbType="INTEGER" javaType="java.math.BigDecimal"
name="PRODUCTS_ID" required="true" type="INTEGER"/>
@@ -452,10 +459,10 @@
name="PRODUCTS_TAX" required="true" size="7" type="DECIMAL"/>
<column dbType="INTEGER" javaType="java.math.BigDecimal"
name="PRODUCTS_QUANTITY" required="true" type="INTEGER"/>
- <foreign-key foreignTable="ORDERS" name="SQL070725000155571">
+ <foreign-key foreignTable="ORDERS" name="SQL070824094318311">
<reference foreign="ORDERS_ID" local="ORDERS_ID"/>
</foreign-key>
- <foreign-key foreignTable="PRODUCTS" name="SQL070725000155572">
+ <foreign-key foreignTable="PRODUCTS" name="SQL070824094318330">
<reference foreign="PRODUCTS_ID" local="PRODUCTS_ID"/>
</foreign-key>
</table>
@@ -566,7 +573,7 @@
<column dbType="INTEGER" default="0"
javaType="java.math.BigDecimal" name="PRODUCTS_ORDERED"
required="true" type="INTEGER"/>
- <foreign-key foreignTable="MANUFACTURERS" name="SQL070721073237390">
+ <foreign-key foreignTable="MANUFACTURERS" name="SQL070824094317871">
<reference foreign="MANUFACTURERS_ID" local="MANUFACTURERS_ID"/>
</foreign-key>
</table>
@@ -586,6 +593,9 @@
name="OPTIONS_VALUES_PRICE" required="true" size="15" type="DECIMAL"/>
<column dbType="CHAR" javaType="String" name="PRICE_PREFIX"
required="true" size="1" type="CHAR"/>
+ <foreign-key foreignTable="PRODUCTS" name="SQL070824094319050">
+ <reference foreign="PRODUCTS_ID" local="PRODUCTS_ID"/>
+ </foreign-key>
</table>
<table name="PRODUCTS_ATTRIBUTES_DOWNLOAD">
<column dbType="INTEGER" javaType="java.math.BigDecimal"
@@ -615,7 +625,7 @@
size="255" type="VARCHAR"/>
<column dbType="INTEGER" default="0"
javaType="java.math.BigDecimal" name="PRODUCTS_VIEWED" type="INTEGER"/>
- <foreign-key foreignTable="PRODUCTS" name="SQL070720101420291">
+ <foreign-key foreignTable="PRODUCTS" name="SQL070824094318011">
<reference foreign="PRODUCTS_ID" local="PRODUCTS_ID"/>
</foreign-key>
</table>
@@ -665,7 +675,7 @@
name="CATEGORIES_ID" primaryKey="true" required="true" type="INTEGER"/>
<column dbType="VARCHAR" javaType="String" name="COMMENT"
size="40" type="VARCHAR"/>
- <foreign-key foreignTable="PRODUCTS" name="SQL070721062541951">
+ <foreign-key foreignTable="PRODUCTS" name="SQL070824094318181">
<reference foreign="PRODUCTS_ID" local="PRODUCTS_ID"/>
</foreign-key>
</table>
Modified: pompei/portlets/pompei-core/trunk/mydbflute/dbflute-0.5.2/schema/project-schema-pompei.xml
===================================================================
--- pompei/portlets/pompei-core/trunk/mydbflute/dbflute-0.5.2/schema/project-schema-pompei.xml 2007-08-24 13:09:39 UTC (rev 483)
+++ pompei/portlets/pompei-core/trunk/mydbflute/dbflute-0.5.2/schema/project-schema-pompei.xml 2007-08-24 13:10:46 UTC (rev 484)
@@ -33,7 +33,7 @@
<column dbType="INTEGER" default="0"
javaType="java.math.BigDecimal" name="ENTRY_ZONE_ID"
required="true" type="INTEGER"/>
- <foreign-key foreignTable="CUSTOMERS" name="SQL070725015931120">
+ <foreign-key foreignTable="CUSTOMERS" name="SQL070824094318840">
<reference foreign="CUSTOMERS_ID" local="CUSTOMERS_ID"/>
</foreign-key>
</table>
@@ -112,7 +112,7 @@
primaryKey="true" required="true" type="INTEGER"/>
<column dbType="VARCHAR" javaType="String"
name="CATEGORIES_NAME" required="true" size="32" type="VARCHAR"/>
- <foreign-key foreignTable="CATEGORIES" name="SQL070718023316900">
+ <foreign-key foreignTable="CATEGORIES" name="SQL070824094318880">
<reference foreign="CATEGORIES_ID" local="CATEGORIES_ID"/>
</foreign-key>
</table>
@@ -204,6 +204,8 @@
default="AUTOINCREMENT: start 1 increment 1"
javaType="java.math.BigDecimal" name="CUSTOMERS_ID"
primaryKey="true" required="true" type="INTEGER"/>
+ <column dbType="VARCHAR" javaType="String"
+ name="CUSTOMERS_PORTAL_ID" required="true" size="255" type="VARCHAR"/>
<column dbType="CHAR" javaType="String" name="CUSTOMERS_GENDER"
required="true" size="1" type="CHAR"/>
<column dbType="VARCHAR" javaType="String"
@@ -225,6 +227,9 @@
name="CUSTOMERS_PASSWORD" required="true" size="40" type="VARCHAR"/>
<column dbType="CHAR" javaType="String"
name="CUSTOMERS_NEWSLETTER" size="1" type="CHAR"/>
+ <foreign-key foreignTable="ADDRESS_BOOK" name="SQL070824094318900">
+ <reference foreign="ADDRESS_BOOK_ID" local="CUSTOMERS_DEFAULT_ADDRESS_ID"/>
+ </foreign-key>
</table>
<table name="CUSTOMERS_BASKET">
<column dbType="INTEGER" javaType="java.math.BigDecimal"
@@ -324,7 +329,7 @@
required="true" type="INTEGER"/>
<column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
name="DATE_LAST_CLICK" type="TIMESTAMP"/>
- <foreign-key foreignTable="MANUFACTURERS" name="SQL070719032256430">
+ <foreign-key foreignTable="MANUFACTURERS" name="SQL070824094319010">
<reference foreign="MANUFACTURERS_ID" local="MANUFACTURERS_ID"/>
</foreign-key>
</table>
@@ -434,9 +439,11 @@
name="CURRENCY_VALUE" size="14" type="DECIMAL"/>
</table>
<table name="ORDERS_PRODUCTS">
+ <column autoIncrement="true" dbType="INTEGER"
+ default="AUTOINCREMENT: start 1 increment 1"
+ javaType="java.math.BigDecimal" name="ORDERS_PRODUCTS_ID"
+ primaryKey="true" required="true" type="INTEGER"/>
<column dbType="INTEGER" javaType="java.math.BigDecimal"
- name="ORDERS_PRODUCTS_ID" primaryKey="true" required="true" type="INTEGER"/>
- <column dbType="INTEGER" javaType="java.math.BigDecimal"
name="ORDERS_ID" required="true" type="INTEGER"/>
<column dbType="INTEGER" javaType="java.math.BigDecimal"
name="PRODUCTS_ID" required="true" type="INTEGER"/>
@@ -452,10 +459,10 @@
name="PRODUCTS_TAX" required="true" size="7" type="DECIMAL"/>
<column dbType="INTEGER" javaType="java.math.BigDecimal"
name="PRODUCTS_QUANTITY" required="true" type="INTEGER"/>
- <foreign-key foreignTable="ORDERS" name="SQL070725000155571">
+ <foreign-key foreignTable="ORDERS" name="SQL070824094318311">
<reference foreign="ORDERS_ID" local="ORDERS_ID"/>
</foreign-key>
- <foreign-key foreignTable="PRODUCTS" name="SQL070725000155572">
+ <foreign-key foreignTable="PRODUCTS" name="SQL070824094318330">
<reference foreign="PRODUCTS_ID" local="PRODUCTS_ID"/>
</foreign-key>
</table>
@@ -566,7 +573,7 @@
<column dbType="INTEGER" default="0"
javaType="java.math.BigDecimal" name="PRODUCTS_ORDERED"
required="true" type="INTEGER"/>
- <foreign-key foreignTable="MANUFACTURERS" name="SQL070721073237390">
+ <foreign-key foreignTable="MANUFACTURERS" name="SQL070824094317871">
<reference foreign="MANUFACTURERS_ID" local="MANUFACTURERS_ID"/>
</foreign-key>
</table>
@@ -586,6 +593,9 @@
name="OPTIONS_VALUES_PRICE" required="true" size="15" type="DECIMAL"/>
<column dbType="CHAR" javaType="String" name="PRICE_PREFIX"
required="true" size="1" type="CHAR"/>
+ <foreign-key foreignTable="PRODUCTS" name="SQL070824094319050">
+ <reference foreign="PRODUCTS_ID" local="PRODUCTS_ID"/>
+ </foreign-key>
</table>
<table name="PRODUCTS_ATTRIBUTES_DOWNLOAD">
<column dbType="INTEGER" javaType="java.math.BigDecimal"
@@ -615,7 +625,7 @@
size="255" type="VARCHAR"/>
<column dbType="INTEGER" default="0"
javaType="java.math.BigDecimal" name="PRODUCTS_VIEWED" type="INTEGER"/>
- <foreign-key foreignTable="PRODUCTS" name="SQL070720101420291">
+ <foreign-key foreignTable="PRODUCTS" name="SQL070824094318011">
<reference foreign="PRODUCTS_ID" local="PRODUCTS_ID"/>
</foreign-key>
</table>
@@ -665,7 +675,7 @@
name="CATEGORIES_ID" primaryKey="true" required="true" type="INTEGER"/>
<column dbType="VARCHAR" javaType="String" name="COMMENT"
size="40" type="VARCHAR"/>
- <foreign-key foreignTable="PRODUCTS" name="SQL070721062541951">
+ <foreign-key foreignTable="PRODUCTS" name="SQL070824094318181">
<reference foreign="PRODUCTS_ID" local="PRODUCTS_ID"/>
</foreign-key>
</table>