• R/O
  • SSH
  • HTTPS

pal: Commit


Commit MetaInfo

Revision405 (tree)
Zeit2007-07-28 04:02:53
Autortakeharu

Log Message

changed db schema

Ändern Zusammenfassung

Diff

--- pompei/portlets/pompei-core/trunk/mydbflute/dbflute-0.5.2/schema/project-schema-pompei.xml (revision 404)
+++ pompei/portlets/pompei-core/trunk/mydbflute/dbflute-0.5.2/schema/project-schema-pompei.xml (revision 405)
@@ -225,9 +225,6 @@
225225 name="CUSTOMERS_PASSWORD" required="true" size="40" type="VARCHAR"/>
226226 <column dbType="CHAR" javaType="String"
227227 name="CUSTOMERS_NEWSLETTER" size="1" type="CHAR"/>
228- <foreign-key foreignTable="ADDRESS_BOOK" name="SQL070725042252810">
229- <reference foreign="ADDRESS_BOOK_ID" local="CUSTOMERS_DEFAULT_ADDRESS_ID"/>
230- </foreign-key>
231228 </table>
232229 <table name="CUSTOMERS_BASKET">
233230 <column dbType="INTEGER" javaType="java.math.BigDecimal"
@@ -350,9 +347,11 @@
350347 javaType="java.math.BigDecimal" name="LOCKED" type="INTEGER"/>
351348 </table>
352349 <table name="ORDERS">
350+ <column autoIncrement="true" dbType="INTEGER"
351+ default="AUTOINCREMENT: start 1 increment 1"
352+ javaType="java.math.BigDecimal" name="ORDERS_ID"
353+ primaryKey="true" required="true" type="INTEGER"/>
353354 <column dbType="INTEGER" javaType="java.math.BigDecimal"
354- name="ORDERS_ID" primaryKey="true" required="true" type="INTEGER"/>
355- <column dbType="INTEGER" javaType="java.math.BigDecimal"
356355 name="CUSTOMERS_ID" required="true" type="INTEGER"/>
357356 <column dbType="VARCHAR" javaType="String" name="CUSTOMERS_NAME"
358357 required="true" size="64" type="VARCHAR"/>
@@ -427,7 +426,7 @@
427426 <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
428427 name="DATE_PURCHASED" type="TIMESTAMP"/>
429428 <column dbType="INTEGER" javaType="java.math.BigDecimal"
430- name="ORDERS_STATUS" required="true" type="INTEGER"/>
429+ name="ORDERS_STATUS_ID" required="true" type="INTEGER"/>
431430 <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
432431 name="ORDERS_DATE_FINISHED" type="TIMESTAMP"/>
433432 <column dbType="CHAR" javaType="String" name="CURRENCY" size="3" type="CHAR"/>
@@ -453,6 +452,12 @@
453452 name="PRODUCTS_TAX" required="true" size="7" type="DECIMAL"/>
454453 <column dbType="INTEGER" javaType="java.math.BigDecimal"
455454 name="PRODUCTS_QUANTITY" required="true" type="INTEGER"/>
455+ <foreign-key foreignTable="ORDERS" name="SQL070725000155571">
456+ <reference foreign="ORDERS_ID" local="ORDERS_ID"/>
457+ </foreign-key>
458+ <foreign-key foreignTable="PRODUCTS" name="SQL070725000155572">
459+ <reference foreign="PRODUCTS_ID" local="PRODUCTS_ID"/>
460+ </foreign-key>
456461 </table>
457462 <table name="ORDERS_PRODUCTS_ATTRIBUTES">
458463 <column dbType="INTEGER" javaType="java.math.BigDecimal"
Show on old repository browser