svnno****@sourc*****
svnno****@sourc*****
2007年 7月 28日 (土) 04:02:53 JST
Revision: 405
http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=405
Author: takeharu
Date: 2007-07-28 04:02:53 +0900 (Sat, 28 Jul 2007)
Log Message:
-----------
changed db schema
Modified Paths:
--------------
pompei/portlets/pompei-core/trunk/mydbflute/dbflute-0.5.2/schema/project-schema-pompei.xml
-------------- next part --------------
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-07-27 19:01:16 UTC (rev 404)
+++ pompei/portlets/pompei-core/trunk/mydbflute/dbflute-0.5.2/schema/project-schema-pompei.xml 2007-07-27 19:02:53 UTC (rev 405)
@@ -225,9 +225,6 @@
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="SQL070725042252810">
- <reference foreign="ADDRESS_BOOK_ID" local="CUSTOMERS_DEFAULT_ADDRESS_ID"/>
- </foreign-key>
</table>
<table name="CUSTOMERS_BASKET">
<column dbType="INTEGER" javaType="java.math.BigDecimal"
@@ -350,9 +347,11 @@
javaType="java.math.BigDecimal" name="LOCKED" type="INTEGER"/>
</table>
<table name="ORDERS">
+ <column autoIncrement="true" dbType="INTEGER"
+ default="AUTOINCREMENT: start 1 increment 1"
+ javaType="java.math.BigDecimal" name="ORDERS_ID"
+ primaryKey="true" required="true" type="INTEGER"/>
<column dbType="INTEGER" javaType="java.math.BigDecimal"
- name="ORDERS_ID" primaryKey="true" required="true" type="INTEGER"/>
- <column dbType="INTEGER" javaType="java.math.BigDecimal"
name="CUSTOMERS_ID" required="true" type="INTEGER"/>
<column dbType="VARCHAR" javaType="String" name="CUSTOMERS_NAME"
required="true" size="64" type="VARCHAR"/>
@@ -427,7 +426,7 @@
<column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
name="DATE_PURCHASED" type="TIMESTAMP"/>
<column dbType="INTEGER" javaType="java.math.BigDecimal"
- name="ORDERS_STATUS" required="true" type="INTEGER"/>
+ name="ORDERS_STATUS_ID" required="true" type="INTEGER"/>
<column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
name="ORDERS_DATE_FINISHED" type="TIMESTAMP"/>
<column dbType="CHAR" javaType="String" name="CURRENCY" size="3" type="CHAR"/>
@@ -453,6 +452,12 @@
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">
+ <reference foreign="ORDERS_ID" local="ORDERS_ID"/>
+ </foreign-key>
+ <foreign-key foreignTable="PRODUCTS" name="SQL070725000155572">
+ <reference foreign="PRODUCTS_ID" local="PRODUCTS_ID"/>
+ </foreign-key>
</table>
<table name="ORDERS_PRODUCTS_ATTRIBUTES">
<column dbType="INTEGER" javaType="java.math.BigDecimal"