svnno****@sourc*****
svnno****@sourc*****
2007年 7月 25日 (水) 05:33:33 JST
Revision: 392
http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=392
Author: takeharu
Date: 2007-07-25 05:33:33 +0900 (Wed, 25 Jul 2007)
Log Message:
-----------
changed shema customers and address_book
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-24 20:31:56 UTC (rev 391)
+++ pompei/portlets/pompei-core/trunk/mydbflute/dbflute-0.5.2/schema/project-schema-pompei.xml 2007-07-24 20:33:33 UTC (rev 392)
@@ -3,9 +3,11 @@
<!-- Autogenerated by JDBCToXMLSchema! -->
<database name="APP">
<table name="ADDRESS_BOOK">
+ <column autoIncrement="true" dbType="INTEGER"
+ default="AUTOINCREMENT: start 1 increment 1"
+ javaType="java.math.BigDecimal" name="ADDRESS_BOOK_ID"
+ primaryKey="true" required="true" type="INTEGER"/>
<column dbType="INTEGER" javaType="java.math.BigDecimal"
- name="ADDRESS_BOOK_ID" primaryKey="true" required="true" type="INTEGER"/>
- <column dbType="INTEGER" javaType="java.math.BigDecimal"
name="CUSTOMERS_ID" required="true" type="INTEGER"/>
<column dbType="CHAR" javaType="String" name="ENTRY_GENDER"
required="true" size="1" type="CHAR"/>
@@ -31,6 +33,9 @@
<column dbType="INTEGER" default="0"
javaType="java.math.BigDecimal" name="ENTRY_ZONE_ID"
required="true" type="INTEGER"/>
+ <foreign-key foreignTable="CUSTOMERS" name="SQL070725015931120">
+ <reference foreign="CUSTOMERS_ID" local="CUSTOMERS_ID"/>
+ </foreign-key>
</table>
<table name="ADDRESS_FORMAT">
<column dbType="INTEGER" javaType="java.math.BigDecimal"
@@ -195,8 +200,10 @@
name="LAST_UPDATED" type="TIMESTAMP"/>
</table>
<table name="CUSTOMERS">
- <column dbType="INTEGER" javaType="java.math.BigDecimal"
- name="CUSTOMERS_ID" primaryKey="true" required="true" type="INTEGER"/>
+ <column autoIncrement="true" dbType="INTEGER"
+ default="AUTOINCREMENT: start 1 increment 1"
+ javaType="java.math.BigDecimal" name="CUSTOMERS_ID"
+ primaryKey="true" required="true" type="INTEGER"/>
<column dbType="CHAR" javaType="String" name="CUSTOMERS_GENDER"
required="true" size="1" type="CHAR"/>
<column dbType="VARCHAR" javaType="String"
@@ -218,6 +225,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="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"