[pal-cvs 2775] [535] udpated db

svnno****@sourc***** svnno****@sourc*****
2007年 9月 4日 (火) 17:29:46 JST


Revision: 535
          http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=535
Author:   shinsuke
Date:     2007-09-04 17:29:46 +0900 (Tue, 04 Sep 2007)

Log Message:
-----------
udpated db

Modified Paths:
--------------
    pompei/portlets/pompei-core/trunk/dbflute/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-09-04 08:26:12 UTC (rev 534)
+++ pompei/portlets/pompei-core/trunk/dbflute/schema/project-schema-pompei.xml	2007-09-04 08:29:46 UTC (rev 535)
@@ -2,9 +2,9 @@
 <!DOCTYPE database SYSTEM "http://dbflute.sandbox.seasar.org/dtd/database.dtd">
 <!-- Autogenerated by JDBCToXMLSchema! -->
 <database name="APP">
-    <table name="ADDRESS_BOOK">
+    <table name="ADDRESS_BOOK" schema="APP" type="TABLE">
         <column autoIncrement="true" dbType="INTEGER"
-            default="AUTOINCREMENT: start 1 increment 1"
+            default="GENERATED_BY_DEFAULT"
             javaType="java.math.BigDecimal" name="ADDRESS_BOOK_ID"
             primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
@@ -14,6 +14,8 @@
         <column dbType="VARCHAR" javaType="String" name="ENTRY_COMPANY"
             size="32" type="VARCHAR"/>
         <column dbType="VARCHAR" javaType="String"
+            name="ENTRY_DEPARTMENT" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
             name="ENTRY_FIRSTNAME" required="true" size="32" type="VARCHAR"/>
         <column dbType="VARCHAR" javaType="String" name="ENTRY_LASTNAME"
             required="true" size="32" type="VARCHAR"/>
@@ -27,27 +29,43 @@
             required="true" size="32" type="VARCHAR"/>
         <column dbType="VARCHAR" javaType="String" name="ENTRY_STATE"
             size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="ENTRY_TELEPHONE" required="true" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="ENTRY_FAX"
+            size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="ENTRY_CELLPHONE" size="32" type="VARCHAR"/>
         <column dbType="INTEGER" default="0"
             javaType="java.math.BigDecimal" name="ENTRY_COUNTRY_ID"
             required="true" type="INTEGER"/>
         <column dbType="INTEGER" default="0"
             javaType="java.math.BigDecimal" name="ENTRY_ZONE_ID"
             required="true" type="INTEGER"/>
-        <foreign-key foreignTable="CUSTOMERS" name="SQL070824094318840">
+        <foreign-key foreignTable="COUNTRIES" name="FK_ADDRESS_BOOK_3">
+            <reference foreign="COUNTRIES_ID" local="ENTRY_COUNTRY_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="CUSTOMERS" name="FK_ADDRESS_BOOK_4">
             <reference foreign="CUSTOMERS_ID" local="CUSTOMERS_ID"/>
         </foreign-key>
+        <foreign-key foreignTable="ZONES" name="FK_ADDRESS_BOOK_2">
+            <reference foreign="ZONE_ID" local="ENTRY_ZONE_ID"/>
+        </foreign-key>
     </table>
-    <table name="ADDRESS_FORMAT">
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
-            name="ADDRESS_FORMAT_ID" primaryKey="true" required="true" type="INTEGER"/>
+    <table name="ADDRESS_FORMAT" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal" name="ADDRESS_FORMAT_ID"
+            primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="VARCHAR" javaType="String" name="ADDRESS_FORMAT"
             required="true" size="128" type="VARCHAR"/>
         <column dbType="VARCHAR" javaType="String"
             name="ADDRESS_SUMMARY" required="true" size="48" type="VARCHAR"/>
     </table>
-    <table name="BANNERS">
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
-            name="BANNERS_ID" primaryKey="true" required="true" type="INTEGER"/>
+    <table name="BANNERS" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal" name="BANNERS_ID"
+            primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="VARCHAR" javaType="String" name="BANNERS_TITLE"
             required="true" size="64" type="VARCHAR"/>
         <column dbType="VARCHAR" javaType="String" name="BANNERS_URL"
@@ -72,10 +90,12 @@
             javaType="java.math.BigDecimal" name="STATUS"
             required="true" type="INTEGER"/>
     </table>
-    <table name="BANNERS_HISTORY">
+    <table name="BANNERS_HISTORY" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal" name="BANNERS_HISTORY_ID"
+            primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
-            name="BANNERS_HISTORY_ID" primaryKey="true" required="true" type="INTEGER"/>
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="BANNERS_ID" required="true" type="INTEGER"/>
         <column dbType="INTEGER" default="0"
             javaType="java.math.BigDecimal" name="BANNERS_SHOWN"
@@ -85,25 +105,30 @@
             required="true" type="INTEGER"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
             name="BANNERS_HISTORY_DATE" required="true" type="TIMESTAMP"/>
+        <foreign-key foreignTable="BANNERS" name="FK_BANNERS_HISTORY_1">
+            <reference foreign="BANNERS_ID" local="BANNERS_ID"/>
+        </foreign-key>
     </table>
-    <table name="CATEGORIES">
+    <table name="CATEGORIES" schema="APP" type="TABLE">
         <column autoIncrement="true" dbType="INTEGER"
-            default="AUTOINCREMENT: start 1 increment 1"
+            default="GENERATED_BY_DEFAULT"
             javaType="java.math.BigDecimal" name="CATEGORIES_ID"
             primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="VARCHAR" javaType="String"
             name="CATEGORIES_IMAGE" size="64" type="VARCHAR"/>
         <column dbType="INTEGER" default="0"
-            javaType="java.math.BigDecimal" name="PARENT_ID"
-            required="true" type="INTEGER"/>
+            javaType="java.math.BigDecimal" name="PARENT_ID" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="SORT_ORDER" type="INTEGER"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
             name="DATE_ADDED" type="TIMESTAMP"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
             name="LAST_MODIFIED" type="TIMESTAMP"/>
+        <foreign-key foreignTable="CATEGORIES" name="FK_CATEGORIES_1">
+            <reference foreign="CATEGORIES_ID" local="PARENT_ID"/>
+        </foreign-key>
     </table>
-    <table name="CATEGORIES_DESCRIPTION">
+    <table name="CATEGORIES_DESCRIPTION" schema="APP" type="TABLE">
         <column dbType="INTEGER" default="0"
             javaType="java.math.BigDecimal" name="CATEGORIES_ID"
             primaryKey="true" required="true" type="INTEGER"/>
@@ -112,13 +137,18 @@
             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="SQL070824094318880">
+        <foreign-key foreignTable="CATEGORIES" name="SQL070831021756620">
             <reference foreign="CATEGORIES_ID" local="CATEGORIES_ID"/>
         </foreign-key>
+        <foreign-key foreignTable="LANGUAGES" name="FK_CATEGORIES_DESCRIPTION_2">
+            <reference foreign="LANGUAGES_ID" local="LANGUAGE_ID"/>
+        </foreign-key>
     </table>
-    <table name="CONFIGURATION">
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
-            name="CONFIGURATION_ID" primaryKey="true" required="true" type="INTEGER"/>
+    <table name="CONFIGURATION" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal" name="CONFIGURATION_ID"
+            primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="VARCHAR" javaType="String"
             name="CONFIGURATION_TITLE" required="true" size="64" type="VARCHAR"/>
         <column dbType="VARCHAR" javaType="String"
@@ -139,9 +169,14 @@
             size="255" type="VARCHAR"/>
         <column dbType="VARCHAR" javaType="String" name="SET_FUNCTION"
             size="255" type="VARCHAR"/>
+        <foreign-key foreignTable="CONFIGURATION_GROUP" name="FK_CONFIGURATION_1">
+            <reference foreign="CONFIGURATION_GROUP_ID" local="CONFIGURATION_GROUP_ID"/>
+        </foreign-key>
     </table>
-    <table name="CONFIGURATION_GROUP">
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+    <table name="CONFIGURATION_GROUP" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal"
             name="CONFIGURATION_GROUP_ID" primaryKey="true"
             required="true" type="INTEGER"/>
         <column dbType="VARCHAR" javaType="String"
@@ -154,20 +189,22 @@
         <column dbType="INTEGER" default="1"
             javaType="java.math.BigDecimal" name="VISIBLE" type="INTEGER"/>
     </table>
-    <table name="COUNTER">
+    <table name="COUNTER" schema="APP" type="TABLE">
         <column dbType="CHAR" javaType="String" name="STARTDATE"
             size="8" type="CHAR"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="COUNTER" type="INTEGER"/>
     </table>
-    <table name="COUNTER_HISTORY">
+    <table name="COUNTER_HISTORY" schema="APP" type="TABLE">
         <column dbType="CHAR" javaType="String" name="MONTH" size="8" type="CHAR"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="COUNTER" type="INTEGER"/>
     </table>
-    <table name="COUNTRIES">
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
-            name="COUNTRIES_ID" primaryKey="true" required="true" type="INTEGER"/>
+    <table name="COUNTRIES" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal" name="COUNTRIES_ID"
+            primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="VARCHAR" javaType="String" name="COUNTRIES_NAME"
             required="true" size="64" type="VARCHAR"/>
         <column dbType="CHAR" javaType="String"
@@ -177,9 +214,11 @@
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="ADDRESS_FORMAT_ID" required="true" type="INTEGER"/>
     </table>
-    <table name="CURRENCIES">
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
-            name="CURRENCIES_ID" primaryKey="true" required="true" type="INTEGER"/>
+    <table name="CURRENCIES" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal" name="CURRENCIES_ID"
+            primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="VARCHAR" javaType="String" name="TITLE"
             required="true" size="32" type="VARCHAR"/>
         <column dbType="CHAR" javaType="String" name="CODE"
@@ -199,9 +238,9 @@
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
             name="LAST_UPDATED" type="TIMESTAMP"/>
     </table>
-    <table name="CUSTOMERS">
+    <table name="CUSTOMERS" schema="APP" type="TABLE">
         <column autoIncrement="true" dbType="INTEGER"
-            default="AUTOINCREMENT: start 1 increment 1"
+            default="GENERATED_BY_DEFAULT"
             javaType="java.math.BigDecimal" name="CUSTOMERS_ID"
             primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="VARCHAR" javaType="String"
@@ -224,43 +263,64 @@
         <column dbType="VARCHAR" javaType="String" name="CUSTOMERS_FAX"
             size="32" type="VARCHAR"/>
         <column dbType="VARCHAR" javaType="String"
-            name="CUSTOMERS_PASSWORD" required="true" size="40" type="VARCHAR"/>
+            name="CUSTOMERS_CELLPHONE" size="32" 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">
+    <table name="CUSTOMERS_BASKET" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal" name="CUSTOMERS_BASKET_ID"
+            primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
-            name="CUSTOMERS_BASKET_ID" primaryKey="true" required="true" type="INTEGER"/>
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="CUSTOMERS_ID" required="true" type="INTEGER"/>
-        <column dbType="LONG VARCHAR" javaType="String"
-            name="PRODUCTS_ID" required="true" size="32700" type="LONGVARCHAR"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="PRODUCTS_ID" required="true" type="INTEGER"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="CUSTOMERS_BASKET_QUANTITY" required="true" type="INTEGER"/>
         <column dbType="DECIMAL" javaType="java.math.BigDecimal"
             name="FINAL_PRICE" size="15" type="DECIMAL"/>
         <column dbType="CHAR" javaType="String"
             name="CUSTOMERS_BASKET_DATE_ADDED" size="8" type="CHAR"/>
+        <foreign-key foreignTable="CUSTOMERS" name="FK_CUSTOMERS_BASKET_1">
+            <reference foreign="CUSTOMERS_ID" local="CUSTOMERS_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="PRODUCTS" name="FK_CUSTOMERS_BASKET_2">
+            <reference foreign="PRODUCTS_ID" local="PRODUCTS_ID"/>
+        </foreign-key>
     </table>
-    <table name="CUSTOMERS_BASKET_ATTRIBUTES">
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+    <table name="CUSTOMERS_BASKET_ATTRIBUTES" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal"
             name="CUSTOMERS_BASKET_ATTRIBUTES_ID" primaryKey="true"
             required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="CUSTOMERS_ID" required="true" type="INTEGER"/>
-        <column dbType="LONG VARCHAR" javaType="String"
-            name="PRODUCTS_ID" required="true" size="32700" type="LONGVARCHAR"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="PRODUCTS_ID" required="true" type="INTEGER"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="PRODUCTS_OPTIONS_ID" required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="PRODUCTS_OPTIONS_VALUE_ID" required="true" type="INTEGER"/>
+        <foreign-key foreignTable="CUSTOMERS" name="FK_CUSTOMERS_BASKET_ATTRIBUTES_1">
+            <reference foreign="CUSTOMERS_ID" local="CUSTOMERS_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="PRODUCTS" name="FK_CUSTOMERS_BASKET_ATTRIBUTES_2">
+            <reference foreign="PRODUCTS_ID" local="PRODUCTS_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="PRODUCTS_OPTIONS" name="FK_CUSTOMERS_BASKET_ATTRIBUTES_5">
+            <reference foreign="PRODUCTS_OPTIONS_ID" local="PRODUCTS_OPTIONS_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="PRODUCTS_OPTIONS_VALUES" name="FK_CUSTOMERS_BASKET_ATTRIBUTES_4">
+            <reference foreign="PRODUCTS_OPTIONS_VALUES_ID" local="PRODUCTS_OPTIONS_VALUE_ID"/>
+        </foreign-key>
     </table>
-    <table name="CUSTOMERS_INFO">
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
-            name="CUSTOMERS_INFO_ID" primaryKey="true" required="true" type="INTEGER"/>
+    <table name="CUSTOMERS_INFO" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal" name="CUSTOMERS_INFO_ID"
+            primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
             name="CUSTOMERS_INFO_DATE_OF_LAST_LOGON" type="TIMESTAMP"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
@@ -272,10 +332,47 @@
         <column dbType="INTEGER" default="0"
             javaType="java.math.BigDecimal"
             name="GLOBAL_PRODUCT_NOTIFICATIONS" type="INTEGER"/>
+        <foreign-key foreignTable="CUSTOMERS" name="FK_CUSTOMERS_INFO_1">
+            <reference foreign="CUSTOMERS_ID" local="CUSTOMERS_INFO_ID"/>
+        </foreign-key>
     </table>
-    <table name="GEO_ZONES">
+    <table name="DELIVERY_METHOD" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal" name="DELIVERY_METHOD_ID"
+            primaryKey="true" required="true" type="INTEGER"/>
+        <column dbType="VARCHAR" javaType="String" name="DELIVERY_CLASS"
+            required="true" size="128" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="DELIVERY_STATUS" required="true" size="1" type="VARCHAR"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
-            name="GEO_ZONE_ID" primaryKey="true" required="true" type="INTEGER"/>
+            name="SORT_ORDER" type="INTEGER"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="DATE_ADDED" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="LAST_MODIFIED" type="TIMESTAMP"/>
+    </table>
+    <table name="DELIVERY_METHOD_DESCRIPTION" schema="APP" type="TABLE">
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="DELIVERY_METHOD_ID"
+            primaryKey="true" required="true" type="INTEGER"/>
+        <column dbType="INTEGER" default="1"
+            javaType="java.math.BigDecimal" name="LANGUAGE_ID"
+            primaryKey="true" required="true" type="INTEGER"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="DELIVERY_METHOD_NAME" required="true" size="32" type="VARCHAR"/>
+        <foreign-key foreignTable="DELIVERY_METHOD" name="SQL070831021756940">
+            <reference foreign="DELIVERY_METHOD_ID" local="DELIVERY_METHOD_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="LANGUAGES" name="FK_DELIVERY_METHOD_DESCRIPTION_2">
+            <reference foreign="LANGUAGES_ID" local="LANGUAGE_ID"/>
+        </foreign-key>
+    </table>
+    <table name="GEO_ZONES" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal" name="GEO_ZONE_ID"
+            primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="VARCHAR" javaType="String" name="GEO_ZONE_NAME"
             required="true" size="32" type="VARCHAR"/>
         <column dbType="VARCHAR" javaType="String"
@@ -285,9 +382,11 @@
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
             name="DATE_ADDED" required="true" type="TIMESTAMP"/>
     </table>
-    <table name="LANGUAGES">
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
-            name="LANGUAGES_ID" primaryKey="true" required="true" type="INTEGER"/>
+    <table name="LANGUAGES" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal" name="LANGUAGES_ID"
+            primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="VARCHAR" javaType="String" name="NAME"
             required="true" size="32" type="VARCHAR"/>
         <column dbType="CHAR" javaType="String" name="CODE"
@@ -299,9 +398,9 @@
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="SORT_ORDER" type="INTEGER"/>
     </table>
-    <table name="MANUFACTURERS">
+    <table name="MANUFACTURERS" schema="APP" type="TABLE">
         <column autoIncrement="true" dbType="INTEGER"
-            default="AUTOINCREMENT: start 1 increment 1"
+            default="GENERATED_BY_DEFAULT"
             javaType="java.math.BigDecimal" name="MANUFACTURERS_ID"
             primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="VARCHAR" javaType="String"
@@ -313,7 +412,7 @@
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
             name="LAST_MODIFIED" type="TIMESTAMP"/>
     </table>
-    <table name="MANUFACTURERS_INFO">
+    <table name="MANUFACTURERS_INFO" schema="APP" type="TABLE">
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="MANUFACTURERS_ID" primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
@@ -329,13 +428,18 @@
             required="true" type="INTEGER"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
             name="DATE_LAST_CLICK" type="TIMESTAMP"/>
-        <foreign-key foreignTable="MANUFACTURERS" name="SQL070824094319010">
+        <foreign-key foreignTable="LANGUAGES" name="FK_MANUFACTURERS_INFO_2">
+            <reference foreign="LANGUAGES_ID" local="LANGUAGES_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="MANUFACTURERS" name="SQL070831021756730">
             <reference foreign="MANUFACTURERS_ID" local="MANUFACTURERS_ID"/>
         </foreign-key>
     </table>
-    <table name="NEWSLETTERS">
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
-            name="NEWSLETTERS_ID" primaryKey="true" required="true" type="INTEGER"/>
+    <table name="NEWSLETTERS" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal" name="NEWSLETTERS_ID"
+            primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="VARCHAR" javaType="String" name="TITLE"
             required="true" size="255" type="VARCHAR"/>
         <column dbType="LONG VARCHAR" javaType="String" name="CONTENT"
@@ -351,9 +455,9 @@
         <column dbType="INTEGER" default="0"
             javaType="java.math.BigDecimal" name="LOCKED" type="INTEGER"/>
     </table>
-    <table name="ORDERS">
+    <table name="ORDERS" schema="APP" type="TABLE">
         <column autoIncrement="true" dbType="INTEGER"
-            default="AUTOINCREMENT: start 1 increment 1"
+            default="GENERATED_BY_DEFAULT"
             javaType="java.math.BigDecimal" name="ORDERS_ID"
             primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
@@ -377,6 +481,8 @@
         <column dbType="VARCHAR" javaType="String"
             name="CUSTOMERS_TELEPHONE" required="true" size="32" type="VARCHAR"/>
         <column dbType="VARCHAR" javaType="String"
+            name="CUSTOMERS_CELLPHONE" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
             name="CUSTOMERS_EMAIL_ADDRESS" required="true" size="96" type="VARCHAR"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="CUSTOMERS_ADDRESS_FORMAT_ID" required="true" type="INTEGER"/>
@@ -385,6 +491,8 @@
         <column dbType="VARCHAR" javaType="String"
             name="DELIVERY_COMPANY" size="32" type="VARCHAR"/>
         <column dbType="VARCHAR" javaType="String"
+            name="DELIVERY_DEPARTMENT" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
             name="DELIVERY_STREET_ADDRESS" required="true" size="64" type="VARCHAR"/>
         <column dbType="VARCHAR" javaType="String"
             name="DELIVERY_SUBURB" size="32" type="VARCHAR"/>
@@ -396,6 +504,8 @@
             size="32" type="VARCHAR"/>
         <column dbType="VARCHAR" javaType="String"
             name="DELIVERY_COUNTRY" required="true" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="DELIVERY_TELEPHONE" size="32" type="VARCHAR"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="DELIVERY_ADDRESS_FORMAT_ID" required="true" type="INTEGER"/>
         <column dbType="VARCHAR" javaType="String" name="BILLING_NAME"
@@ -403,6 +513,8 @@
         <column dbType="VARCHAR" javaType="String"
             name="BILLING_COMPANY" size="32" type="VARCHAR"/>
         <column dbType="VARCHAR" javaType="String"
+            name="BILLING_DEPARTMENT" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
             name="BILLING_STREET_ADDRESS" required="true" size="64" type="VARCHAR"/>
         <column dbType="VARCHAR" javaType="String" name="BILLING_SUBURB"
             size="32" type="VARCHAR"/>
@@ -414,6 +526,8 @@
             size="32" type="VARCHAR"/>
         <column dbType="VARCHAR" javaType="String"
             name="BILLING_COUNTRY" required="true" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="BILLING_TELEPHONE" size="32" type="VARCHAR"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="BILLING_ADDRESS_FORMAT_ID" required="true" type="INTEGER"/>
         <column dbType="VARCHAR" javaType="String" name="PAYMENT_METHOD"
@@ -426,6 +540,8 @@
             size="32" type="VARCHAR"/>
         <column dbType="VARCHAR" javaType="String" name="CC_EXPIRES"
             size="4" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="DELIVERY_CLASS"
+            required="true" size="128" type="VARCHAR"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
             name="LAST_MODIFIED" type="TIMESTAMP"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
@@ -437,10 +553,25 @@
         <column dbType="CHAR" javaType="String" name="CURRENCY" size="3" type="CHAR"/>
         <column dbType="DECIMAL" javaType="java.math.BigDecimal"
             name="CURRENCY_VALUE" size="14" type="DECIMAL"/>
+        <foreign-key foreignTable="ADDRESS_FORMAT" name="FK_ORDERS_5">
+            <reference foreign="ADDRESS_FORMAT_ID" local="CUSTOMERS_ADDRESS_FORMAT_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="ADDRESS_FORMAT" name="FK_ORDERS_4">
+            <reference foreign="ADDRESS_FORMAT_ID" local="DELIVERY_ADDRESS_FORMAT_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="ADDRESS_FORMAT" name="FK_ORDERS_3">
+            <reference foreign="ADDRESS_FORMAT_ID" local="BILLING_ADDRESS_FORMAT_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="CUSTOMERS" name="SQL070831021756810">
+            <reference foreign="CUSTOMERS_ID" local="CUSTOMERS_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="ORDERS_STATUS" name="SQL070831021756860">
+            <reference foreign="ORDERS_STATUS_ID" local="ORDERS_STATUS_ID"/>
+        </foreign-key>
     </table>
-    <table name="ORDERS_PRODUCTS">
+    <table name="ORDERS_PRODUCTS" schema="APP" type="TABLE">
         <column autoIncrement="true" dbType="INTEGER"
-            default="AUTOINCREMENT: start 1 increment 1"
+            default="GENERATED_BY_DEFAULT"
             javaType="java.math.BigDecimal" name="ORDERS_PRODUCTS_ID"
             primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
@@ -459,15 +590,17 @@
             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="SQL070824094318311">
+        <foreign-key foreignTable="ORDERS" name="SQL070831021755891">
             <reference foreign="ORDERS_ID" local="ORDERS_ID"/>
         </foreign-key>
-        <foreign-key foreignTable="PRODUCTS" name="SQL070824094318330">
+        <foreign-key foreignTable="PRODUCTS" name="SQL070831021755892">
             <reference foreign="PRODUCTS_ID" local="PRODUCTS_ID"/>
         </foreign-key>
     </table>
-    <table name="ORDERS_PRODUCTS_ATTRIBUTES">
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+    <table name="ORDERS_PRODUCTS_ATTRIBUTES" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal"
             name="ORDERS_PRODUCTS_ATTRIBUTES_ID" primaryKey="true"
             required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
@@ -482,9 +615,17 @@
             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="ORDERS" name="FK_ORDERS_PRODUCTS_ATTRIBUTES_1">
+            <reference foreign="ORDERS_ID" local="ORDERS_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="PRODUCTS" name="FK_ORDERS_PRODUCTS_ATTRIBUTES_2">
+            <reference foreign="PRODUCTS_ID" local="ORDERS_PRODUCTS_ID"/>
+        </foreign-key>
     </table>
-    <table name="ORDERS_PRODUCTS_DOWNLOAD">
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+    <table name="ORDERS_PRODUCTS_DOWNLOAD" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal"
             name="ORDERS_PRODUCTS_DOWNLOAD_ID" primaryKey="true"
             required="true" type="INTEGER"/>
         <column dbType="INTEGER" default="0"
@@ -501,19 +642,36 @@
         <column dbType="INTEGER" default="0"
             javaType="java.math.BigDecimal" name="DOWNLOAD_COUNT"
             required="true" type="INTEGER"/>
+        <foreign-key foreignTable="ORDERS" name="FK_ORDERS_PRODUCTS_DOWNLOAD_1">
+            <reference foreign="ORDERS_ID" local="ORDERS_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="PRODUCTS" name="FK_ORDERS_PRODUCTS_DOWNLOAD_2">
+            <reference foreign="PRODUCTS_ID" local="ORDERS_PRODUCTS_ID"/>
+        </foreign-key>
     </table>
-    <table name="ORDERS_STATUS">
+    <table name="ORDERS_STATUS" schema="APP" type="TABLE">
         <column dbType="INTEGER" default="0"
             javaType="java.math.BigDecimal" name="ORDERS_STATUS_ID"
             primaryKey="true" required="true" type="INTEGER"/>
-        <column dbType="INTEGER" default="1"
-            javaType="java.math.BigDecimal" name="LANGUAGE_ID"
-            primaryKey="true" required="true" type="INTEGER"/>
+    </table>
+    <table name="ORDERS_STATUS_DESCRIPTION" schema="APP" type="TABLE">
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="ORDERS_STATUS_ID" primaryKey="true" required="true" type="INTEGER"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="LANGUAGE_ID" primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="VARCHAR" javaType="String"
             name="ORDERS_STATUS_NAME" required="true" size="32" type="VARCHAR"/>
+        <foreign-key foreignTable="LANGUAGES" name="FK_ORDERS_STATUS_DESCRIPTION_2">
+            <reference foreign="LANGUAGES_ID" local="LANGUAGE_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="ORDERS_STATUS" name="FK_ORDERS_STATUS_DESCRIPTION_1">
+            <reference foreign="ORDERS_STATUS_ID" local="ORDERS_STATUS_ID"/>
+        </foreign-key>
     </table>
-    <table name="ORDERS_STATUS_HISTORY">
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+    <table name="ORDERS_STATUS_HISTORY" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal"
             name="ORDERS_STATUS_HISTORY_ID" primaryKey="true"
             required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
@@ -526,11 +684,19 @@
             javaType="java.math.BigDecimal" name="CUSTOMER_NOTIFIED" type="INTEGER"/>
         <column dbType="LONG VARCHAR" javaType="String" name="COMMENTS"
             size="32700" type="LONGVARCHAR"/>
+        <foreign-key foreignTable="ORDERS" name="FK_ORDERS_STATUS_HISTORY_2">
+            <reference foreign="ORDERS_ID" local="ORDERS_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="ORDERS_STATUS" name="SQL070831021756900">
+            <reference foreign="ORDERS_STATUS_ID" local="ORDERS_STATUS_ID"/>
+        </foreign-key>
     </table>
-    <table name="ORDERS_TOTAL">
+    <table name="ORDERS_TOTAL" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal" name="ORDERS_TOTAL_ID"
+            primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
-            name="ORDERS_TOTAL_ID" primaryKey="true" required="true" type="INTEGER"/>
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="ORDERS_ID" required="true" type="INTEGER"/>
         <column dbType="VARCHAR" javaType="String" name="TITLE"
             required="true" size="255" type="VARCHAR"/>
@@ -542,10 +708,13 @@
             required="true" size="32" type="VARCHAR"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="SORT_ORDER" required="true" type="INTEGER"/>
+        <foreign-key foreignTable="ORDERS" name="FK_ORDERS_TOTAL_1">
+            <reference foreign="ORDERS_ID" local="ORDERS_ID"/>
+        </foreign-key>
     </table>
-    <table name="PRODUCTS">
+    <table name="PRODUCTS" schema="APP" type="TABLE">
         <column autoIncrement="true" dbType="INTEGER"
-            default="AUTOINCREMENT: start 1 increment 1"
+            default="GENERATED_BY_DEFAULT"
             javaType="java.math.BigDecimal" name="PRODUCTS_ID"
             primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
@@ -573,13 +742,16 @@
         <column dbType="INTEGER" default="0"
             javaType="java.math.BigDecimal" name="PRODUCTS_ORDERED"
             required="true" type="INTEGER"/>
-        <foreign-key foreignTable="MANUFACTURERS" name="SQL070824094317871">
+        <foreign-key foreignTable="MANUFACTURERS" name="SQL070831021755391">
             <reference foreign="MANUFACTURERS_ID" local="MANUFACTURERS_ID"/>
         </foreign-key>
+        <foreign-key foreignTable="TAX_CLASS" name="FK_PRODUCTS_2">
+            <reference foreign="TAX_CLASS_ID" local="PRODUCTS_TAX_CLASS_ID"/>
+        </foreign-key>
     </table>
-    <table name="PRODUCTS_ATTRIBUTES">
+    <table name="PRODUCTS_ATTRIBUTES" schema="APP" type="TABLE">
         <column autoIncrement="true" dbType="INTEGER"
-            default="AUTOINCREMENT: start 1 increment 1"
+            default="GENERATED_BY_DEFAULT"
             javaType="java.math.BigDecimal"
             name="PRODUCTS_ATTRIBUTES_ID" primaryKey="true"
             required="true" type="INTEGER"/>
@@ -593,11 +765,17 @@
             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">
+        <foreign-key foreignTable="PRODUCTS" name="SQL070831021756760">
             <reference foreign="PRODUCTS_ID" local="PRODUCTS_ID"/>
         </foreign-key>
+        <foreign-key foreignTable="PRODUCTS_OPTIONS" name="FK_PRODUCTS_ATTRIBUTES_2">
+            <reference foreign="PRODUCTS_OPTIONS_ID" local="OPTIONS_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="PRODUCTS_OPTIONS_VALUES" name="FK_PRODUCTS_ATTRIBUTES_3">
+            <reference foreign="PRODUCTS_OPTIONS_VALUES_ID" local="OPTIONS_VALUES_ID"/>
+        </foreign-key>
     </table>
-    <table name="PRODUCTS_ATTRIBUTES_DOWNLOAD">
+    <table name="PRODUCTS_ATTRIBUTES_DOWNLOAD" schema="APP" type="TABLE">
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="PRODUCTS_ATTRIBUTES_ID" primaryKey="true"
             required="true" type="INTEGER"/>
@@ -610,8 +788,11 @@
         <column dbType="INTEGER" default="0"
             javaType="java.math.BigDecimal"
             name="PRODUCTS_ATTRIBUTES_MAXCOUNT" type="INTEGER"/>
+        <foreign-key foreignTable="PRODUCTS_ATTRIBUTES" name="FK_PRODUCTS_ATTRIBUTES_DOWNLOAD_1">
+            <reference foreign="PRODUCTS_ATTRIBUTES_ID" local="PRODUCTS_ATTRIBUTES_ID"/>
+        </foreign-key>
     </table>
-    <table name="PRODUCTS_DESCRIPTION">
+    <table name="PRODUCTS_DESCRIPTION" schema="APP" type="TABLE">
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="PRODUCTS_ID" primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="INTEGER" default="1"
@@ -625,64 +806,108 @@
             size="255" type="VARCHAR"/>
         <column dbType="INTEGER" default="0"
             javaType="java.math.BigDecimal" name="PRODUCTS_VIEWED" type="INTEGER"/>
-        <foreign-key foreignTable="PRODUCTS" name="SQL070824094318011">
+        <foreign-key foreignTable="LANGUAGES" name="FK_PRODUCTS_DESCRIPTION_2">
+            <reference foreign="LANGUAGES_ID" local="LANGUAGE_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="PRODUCTS" name="SQL070831021755591">
             <reference foreign="PRODUCTS_ID" local="PRODUCTS_ID"/>
         </foreign-key>
     </table>
-    <table name="PRODUCTS_NOTIFICATIONS">
+    <table name="PRODUCTS_NOTIFICATIONS" schema="APP" type="TABLE">
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="PRODUCTS_ID" primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="CUSTOMERS_ID" primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
             name="DATE_ADDED" required="true" type="TIMESTAMP"/>
+        <foreign-key foreignTable="CUSTOMERS" name="FK_PRODUCTS_NOTIFICATIONS_2">
+            <reference foreign="CUSTOMERS_ID" local="CUSTOMERS_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="PRODUCTS" name="FK_PRODUCTS_NOTIFICATIONS_1">
+            <reference foreign="PRODUCTS_ID" local="PRODUCTS_ID"/>
+        </foreign-key>
     </table>
-    <table name="PRODUCTS_OPTIONS">
-        <column dbType="INTEGER" default="0"
+    <table name="PRODUCTS_OPTIONS" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
             javaType="java.math.BigDecimal" name="PRODUCTS_OPTIONS_ID"
             primaryKey="true" required="true" type="INTEGER"/>
-        <column dbType="INTEGER" default="1"
-            javaType="java.math.BigDecimal" name="LANGUAGE_ID"
-            primaryKey="true" required="true" type="INTEGER"/>
-        <column dbType="VARCHAR" default="" javaType="String"
+    </table>
+    <table name="PRODUCTS_OPTIONS_DESCRIPTION" schema="APP" type="TABLE">
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="PRODUCTS_OPTIONS_ID" primaryKey="true" required="true" type="INTEGER"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="LANGUAGE_ID" primaryKey="true" required="true" type="INTEGER"/>
+        <column dbType="VARCHAR" javaType="String"
             name="PRODUCTS_OPTIONS_NAME" required="true" size="32" type="VARCHAR"/>
+        <foreign-key foreignTable="LANGUAGES" name="FK_PRODUCTS_OPTIONS_DESCRIPTION_2">
+            <reference foreign="LANGUAGES_ID" local="LANGUAGE_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="PRODUCTS_OPTIONS" name="FK_PRODUCTS_OPTIONS_DESCRIPTION_1">
+            <reference foreign="PRODUCTS_OPTIONS_ID" local="PRODUCTS_OPTIONS_ID"/>
+        </foreign-key>
     </table>
-    <table name="PRODUCTS_OPTIONS_VALUES">
-        <column dbType="INTEGER" default="0"
+    <table name="PRODUCTS_OPTIONS_VALUES" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
             javaType="java.math.BigDecimal"
             name="PRODUCTS_OPTIONS_VALUES_ID" primaryKey="true"
             required="true" type="INTEGER"/>
-        <column dbType="INTEGER" default="1"
-            javaType="java.math.BigDecimal" name="LANGUAGE_ID"
-            primaryKey="true" required="true" type="INTEGER"/>
-        <column dbType="VARCHAR" default="" javaType="String"
+    </table>
+    <table name="PRODUCTS_OPTIONS_VALUES_DESCRIPTION" schema="APP" type="TABLE">
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="PRODUCTS_OPTIONS_VALUES_ID" primaryKey="true"
+            required="true" type="INTEGER"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="LANGUAGE_ID" primaryKey="true" required="true" type="INTEGER"/>
+        <column dbType="VARCHAR" javaType="String"
             name="PRODUCTS_OPTIONS_VALUES_NAME" required="true"
             size="64" type="VARCHAR"/>
+        <foreign-key foreignTable="LANGUAGES" name="FK_PRODUCTS_OPTIONS_VALUES_DESCRIPTION_2">
+            <reference foreign="LANGUAGES_ID" local="LANGUAGE_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="PRODUCTS_OPTIONS_VALUES" name="FK_PRODUCTS_OPTIONS_VALUES_DESCRIPTION_1">
+            <reference foreign="PRODUCTS_OPTIONS_VALUES_ID" local="PRODUCTS_OPTIONS_VALUES_ID"/>
+        </foreign-key>
     </table>
-    <table name="PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS">
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+    <table name="PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS"
+        schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal"
             name="PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS_ID"
             primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="PRODUCTS_OPTIONS_ID" required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="PRODUCTS_OPTIONS_VALUES_ID" required="true" type="INTEGER"/>
+        <foreign-key foreignTable="PRODUCTS_OPTIONS" name="FK_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS_1">
+            <reference foreign="PRODUCTS_OPTIONS_ID" local="PRODUCTS_OPTIONS_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="PRODUCTS_OPTIONS_VALUES" name="FK_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS_2">
+            <reference foreign="PRODUCTS_OPTIONS_VALUES_ID" local="PRODUCTS_OPTIONS_VALUES_ID"/>
+        </foreign-key>
     </table>
-    <table name="PRODUCTS_TO_CATEGORIES">
+    <table name="PRODUCTS_TO_CATEGORIES" schema="APP" type="TABLE">
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             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="SQL070824094318181">
+        <foreign-key foreignTable="CATEGORIES" name="FK_PRODUCTS_TO_CATEGORIES_2">
+            <reference foreign="CATEGORIES_ID" local="CATEGORIES_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="PRODUCTS" name="SQL070831021755780">
             <reference foreign="PRODUCTS_ID" local="PRODUCTS_ID"/>
         </foreign-key>
     </table>
-    <table name="REVIEWS">
+    <table name="REVIEWS" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal" name="REVIEWS_ID"
+            primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
-            name="REVIEWS_ID" primaryKey="true" required="true" type="INTEGER"/>
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="PRODUCTS_ID" required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="CUSTOMERS_ID" type="INTEGER"/>
@@ -697,16 +922,27 @@
         <column dbType="INTEGER" default="0"
             javaType="java.math.BigDecimal" name="REVIEWS_READ"
             required="true" type="INTEGER"/>
+        <foreign-key foreignTable="PRODUCTS" name="FK_REVIEWS_1">
+            <reference foreign="PRODUCTS_ID" local="PRODUCTS_ID"/>
+        </foreign-key>
     </table>
-    <table name="REVIEWS_DESCRIPTION">
+    <table name="REVIEWS_DESCRIPTION" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal" name="REVIEWS_ID"
+            primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
-            name="REVIEWS_ID" primaryKey="true" required="true" type="INTEGER"/>
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="LANGUAGES_ID" primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="LONG VARCHAR" javaType="String"
             name="REVIEWS_TEXT" required="true" size="32700" type="LONGVARCHAR"/>
+        <foreign-key foreignTable="LANGUAGES" name="FK_REVIEWS_DESCRIPTION_2">
+            <reference foreign="LANGUAGES_ID" local="LANGUAGES_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="REVIEWS" name="FK_REVIEWS_DESCRIPTION_1">
+            <reference foreign="REVIEWS_ID" local="REVIEWS_ID"/>
+        </foreign-key>
     </table>
-    <table name="SESSIONS">
+    <table name="SESSIONS" schema="APP" type="TABLE">
         <column dbType="VARCHAR" javaType="String" name="SESSKEY"
             primaryKey="true" required="true" size="32" type="VARCHAR"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
@@ -714,10 +950,12 @@
         <column dbType="LONG VARCHAR" javaType="String" name="VALUE"
             required="true" size="32700" type="LONGVARCHAR"/>
     </table>
-    <table name="SPECIALS">
+    <table name="SPECIALS" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal" name="SPECIALS_ID"
+            primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
-            name="SPECIALS_ID" primaryKey="true" required="true" type="INTEGER"/>
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="PRODUCTS_ID" required="true" type="INTEGER"/>
         <column dbType="DECIMAL" javaType="java.math.BigDecimal"
             name="SPECIALS_NEW_PRODUCTS_PRICE" required="true" size="15" type="DECIMAL"/>
@@ -732,10 +970,15 @@
         <column dbType="INTEGER" default="1"
             javaType="java.math.BigDecimal" name="STATUS"
             required="true" type="INTEGER"/>
+        <foreign-key foreignTable="PRODUCTS" name="FK_SPECIALS_1">
+            <reference foreign="PRODUCTS_ID" local="PRODUCTS_ID"/>
+        </foreign-key>
     </table>
-    <table name="TAX_CLASS">
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
-            name="TAX_CLASS_ID" primaryKey="true" required="true" type="INTEGER"/>
+    <table name="TAX_CLASS" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal" name="TAX_CLASS_ID"
+            primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="VARCHAR" javaType="String"
             name="TAX_CLASS_TITLE" required="true" size="32" type="VARCHAR"/>
         <column dbType="VARCHAR" javaType="String"
@@ -745,10 +988,12 @@
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
             name="DATE_ADDED" required="true" type="TIMESTAMP"/>
     </table>
-    <table name="TAX_RATES">
+    <table name="TAX_RATES" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal" name="TAX_RATES_ID"
+            primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
-            name="TAX_RATES_ID" primaryKey="true" required="true" type="INTEGER"/>
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="TAX_ZONE_ID" required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="TAX_CLASS_ID" required="true" type="INTEGER"/>
@@ -762,8 +1007,14 @@
             name="LAST_MODIFIED" type="TIMESTAMP"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
             name="DATE_ADDED" required="true" type="TIMESTAMP"/>
+        <foreign-key foreignTable="TAX_CLASS" name="FK_TAX_RATES_1">
+            <reference foreign="TAX_CLASS_ID" local="TAX_CLASS_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="ZONES" name="FK_TAX_RATES_2">
+            <reference foreign="ZONE_ID" local="TAX_ZONE_ID"/>
+        </foreign-key>
     </table>
-    <table name="WHOS_ONLINE">
+    <table name="WHOS_ONLINE" schema="APP" type="TABLE">
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="CUSTOMER_ID" type="INTEGER"/>
         <column dbType="VARCHAR" javaType="String" name="FULL_NAME"
@@ -778,21 +1029,31 @@
             name="TIME_LAST_CLICK" required="true" size="14" type="VARCHAR"/>
         <column dbType="VARCHAR" javaType="String" name="LAST_PAGE_URL"
             required="true" size="255" type="VARCHAR"/>
+        <foreign-key foreignTable="CUSTOMERS" name="FK_WHOS_ONLINE_1">
+            <reference foreign="CUSTOMERS_ID" local="CUSTOMER_ID"/>
+        </foreign-key>
     </table>
-    <table name="ZONES">
+    <table name="ZONES" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal" name="ZONE_ID"
+            primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
-            name="ZONE_ID" primaryKey="true" required="true" type="INTEGER"/>
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="ZONE_COUNTRY_ID" required="true" type="INTEGER"/>
         <column dbType="VARCHAR" javaType="String" name="ZONE_CODE"
             required="true" size="32" type="VARCHAR"/>
         <column dbType="VARCHAR" javaType="String" name="ZONE_NAME"
             required="true" size="32" type="VARCHAR"/>
+        <foreign-key foreignTable="COUNTRIES" name="FK_ZONES_1">
+            <reference foreign="COUNTRIES_ID" local="ZONE_COUNTRY_ID"/>
+        </foreign-key>
     </table>
-    <table name="ZONES_TO_GEO_ZONES">
+    <table name="ZONES_TO_GEO_ZONES" schema="APP" type="TABLE">
+        <column autoIncrement="true" dbType="INTEGER"
+            default="GENERATED_BY_DEFAULT"
+            javaType="java.math.BigDecimal" name="ASSOCIATION_ID"
+            primaryKey="true" required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
-            name="ASSOCIATION_ID" primaryKey="true" required="true" type="INTEGER"/>
-        <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="ZONE_COUNTRY_ID" required="true" type="INTEGER"/>
         <column dbType="INTEGER" javaType="java.math.BigDecimal"
             name="ZONE_ID" type="INTEGER"/>
@@ -802,5 +1063,11 @@
             name="LAST_MODIFIED" type="TIMESTAMP"/>
         <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
             name="DATE_ADDED" required="true" type="TIMESTAMP"/>
+        <foreign-key foreignTable="GEO_ZONES" name="FK_ZONES_TO_GEO_ZONES_2">
+            <reference foreign="GEO_ZONE_ID" local="GEO_ZONE_ID"/>
+        </foreign-key>
+        <foreign-key foreignTable="ZONES" name="FK_ZONES_TO_GEO_ZONES_1">
+            <reference foreign="ZONE_ID" local="ZONE_ID"/>
+        </foreign-key>
     </table>
 </database>


pal-cvs メーリングリストの案内