[pal-cvs 2608] [340] updated pompei db shema

Back to archive index

svnno****@sourc***** svnno****@sourc*****
2007年 7月 23日 (月) 09:12:48 JST


Revision: 340
          http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=340
Author:   takeharu
Date:     2007-07-23 09:12:47 +0900 (Mon, 23 Jul 2007)

Log Message:
-----------
updated pompei db shema

Modified Paths:
--------------
    pompei/trunk/mydbflute/dbflute-0.5.2/schema/project-schema-pompei.xml


-------------- next part --------------
Modified: pompei/trunk/mydbflute/dbflute-0.5.2/schema/project-schema-pompei.xml
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/schema/project-schema-pompei.xml	2007-07-23 00:10:38 UTC (rev 339)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/schema/project-schema-pompei.xml	2007-07-23 00:12:47 UTC (rev 340)
@@ -522,9 +522,11 @@
             name="SORT_ORDER" required="true" type="INTEGER"/>
     </table>
     <table name="PRODUCTS">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="AUTOINCREMENT: start 1 increment 1"
+            javaType="java.math.BigDecimal" name="PRODUCTS_ID"
+            primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
-            name="PRODUCTS_ID" primaryKey="true" required="true" type="INTEGER"/>
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="PRODUCTS_QUANTITY" required="true" type="INTEGER"/>
         <column dbType="VARCHAR" javaType="String" name="PRODUCTS_MODEL"
             size="12" type="VARCHAR"/>
@@ -549,9 +551,14 @@
         <column dbType="INTEGER" default="0"
             javaType="java.math.BigDecimal" name="PRODUCTS_ORDERED"
             required="true" type="INTEGER"/>
+        <foreign-key foreignTable="MANUFACTURERS" name="SQL070721073237390">
+            <reference foreign="MANUFACTURERS_ID" local="MANUFACTURERS_ID"/>
+        </foreign-key>
     </table>
     <table name="PRODUCTS_ATTRIBUTES">
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+        <column autoIncrement="true" dbType="INTEGER"
+            default="AUTOINCREMENT: start 1 increment 1"
+            javaType="java.math.BigDecimal"
             name="PRODUCTS_ATTRIBUTES_ID" primaryKey="true"
             required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
@@ -593,6 +600,9 @@
             size="255" type="VARCHAR"/>
         <column dbType="INTEGER" default="0"
             javaType="java.math.BigDecimal" name="PRODUCTS_VIEWED" type="INTEGER"/>
+        <foreign-key foreignTable="PRODUCTS" name="SQL070720101420291">
+            <reference foreign="PRODUCTS_ID" local="PRODUCTS_ID"/>
+        </foreign-key>
     </table>
     <table name="PRODUCTS_NOTIFICATIONS">
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
@@ -638,6 +648,11 @@
             name="PRODUCTS_ID" primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             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">
+            <reference foreign="PRODUCTS_ID" local="PRODUCTS_ID"/>
+        </foreign-key>
     </table>
     <table name="REVIEWS">
         <column dbType="INTEGER" javaType="java.math.BigDecimal"


pal-cvs メーリングリストの案内
Back to archive index