Portal Application Laboratory

[pal-cvs 2491] [223] added mydbflute

svnno****@sourc***** svnno****@sourc*****
2007年 7月 10日 (火) 21:56:50 JST

• 前の記事 [pal-cvs 2490] [222] added mydbflute
• 次の記事 [pal-cvs 2492] [224] added mydbflute
• 記事の並び順: [ 日付 ] [ スレッド ] [ 件名 ] [ 著者 ]

Revision: 223
          http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=223
Author:   takeharu
Date:     2007-07-10 21:56:50 +0900 (Tue, 10 Jul 2007)

Log Message:
-----------
added mydbflute

Added Paths:
-----------
    pompei/trunk/mydbflute/dbflute-0.5.2/schema/
    pompei/trunk/mydbflute/dbflute-0.5.2/schema/project-schema-n2commerce.xml
    pompei/trunk/mydbflute/dbflute-0.5.2/schema/project-schema-pompei.xml
    pompei/trunk/mydbflute/dbflute-0.5.2/schema/readme.txt


-------------- next part --------------
Added: pompei/trunk/mydbflute/dbflute-0.5.2/schema/project-schema-n2commerce.xml
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/schema/project-schema-n2commerce.xml	2007-07-10 12:56:08 UTC (rev 222)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/schema/project-schema-n2commerce.xml	2007-07-10 12:56:50 UTC (rev 223)
@@ -0,0 +1,723 @@
+<?xml version="1.0"?>
+<!DOCTYPE database SYSTEM "http://dbflute.sandbox.seasar.org/dtd/database.dtd">
+<!-- Autogenerated by JDBCToXMLSchema! -->
+<database name="APP">
+    <table name="ADDRESS_BOOK">
+        <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"/>
+        <column dbType="VARCHAR" javaType="String" name="ENTRY_COMPANY"
+            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"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="ENTRY_STREET_ADDRESS" required="true" size="64" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="ENTRY_SUBURB"
+            size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="ENTRY_POSTCODE"
+            required="true" size="10" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="ENTRY_CITY"
+            required="true" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="ENTRY_STATE"
+            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"/>
+    </table>
+    <table name="ADDRESS_FORMAT">
+        <column dbType="INTEGER" 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"/>
+        <column dbType="VARCHAR" javaType="String" name="BANNERS_TITLE"
+            required="true" size="64" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="BANNERS_URL"
+            required="true" size="255" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="BANNERS_IMAGE"
+            required="true" size="64" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="BANNERS_GROUP"
+            required="true" size="10" type="VARCHAR"/>
+        <column dbType="LONG VARCHAR" javaType="String"
+            name="BANNERS_HTML_TEXT" size="32700" type="LONGVARCHAR"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="EXPIRES_IMPRESSIONS" type="INTEGER"/>
+        <column dbType="TIMESTAMP" default="NULL"
+            javaType="java.sql.Timestamp" name="EXPIRES_DATE" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" default="NULL"
+            javaType="java.sql.Timestamp" name="DATE_SCHEDULED" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="DATE_ADDED" required="true" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" default="NULL"
+            javaType="java.sql.Timestamp" name="DATE_STATUS_CHANGE" type="TIMESTAMP"/>
+        <column dbType="INTEGER" default="1"
+            javaType="java.math.BigDecimal" name="STATUS"
+            required="true" type="INTEGER"/>
+    </table>
+    <table name="BANNERS_HISTORY">
+        <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"
+            required="true" type="INTEGER"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="BANNERS_CLICKED"
+            required="true" type="INTEGER"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="BANNERS_HISTORY_DATE" required="true" type="TIMESTAMP"/>
+    </table>
+    <table name="CATEGORIES">
+        <column dbType="INTEGER" 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"/>
+        <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"/>
+    </table>
+    <table name="CATEGORIES_DESCRIPTION">
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="CATEGORIES_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="CATEGORIES_NAME" required="true" size="32" type="VARCHAR"/>
+    </table>
+    <table name="CONFIGURATION">
+        <column dbType="INTEGER" 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"
+            name="CONFIGURATION_KEY" required="true" size="64" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CONFIGURATION_VALUE" required="true" size="255" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CONFIGURATION_DESCRIPTION" required="true" size="255" type="VARCHAR"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="CONFIGURATION_GROUP_ID" required="true" type="INTEGER"/>
+        <column dbType="INTEGER" default="NULL"
+            javaType="java.math.BigDecimal" name="SORT_ORDER" type="INTEGER"/>
+        <column dbType="TIMESTAMP" default="NULL"
+            javaType="java.sql.Timestamp" name="LAST_MODIFIED" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="DATE_ADDED" required="true" type="TIMESTAMP"/>
+        <column dbType="VARCHAR" default="NULL" javaType="String"
+            name="USE_FUNCTION" size="255" type="VARCHAR"/>
+        <column dbType="VARCHAR" default="NULL" javaType="String"
+            name="SET_FUNCTION" size="255" type="VARCHAR"/>
+    </table>
+    <table name="CONFIGURATION_GROUP">
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="CONFIGURATION_GROUP_ID" primaryKey="true"
+            required="true" type="INTEGER"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CONFIGURATION_GROUP_TITLE" required="true" size="64" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CONFIGURATION_GROUP_DESCRIPTION" required="true"
+            size="255" type="VARCHAR"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="SORT_ORDER" type="INTEGER"/>
+        <column dbType="INTEGER" default="1"
+            javaType="java.math.BigDecimal" name="VISIBLE" type="INTEGER"/>
+    </table>
+    <table name="COUNTER">
+        <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">
+        <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"/>
+        <column dbType="VARCHAR" javaType="String" name="COUNTRIES_NAME"
+            required="true" size="64" type="VARCHAR"/>
+        <column dbType="CHAR" javaType="String"
+            name="COUNTRIES_ISO_CODE_2" required="true" size="2" type="CHAR"/>
+        <column dbType="CHAR" javaType="String"
+            name="COUNTRIES_ISO_CODE_3" required="true" size="3" type="CHAR"/>
+        <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"/>
+        <column dbType="VARCHAR" javaType="String" name="TITLE"
+            required="true" size="32" type="VARCHAR"/>
+        <column dbType="CHAR" javaType="String" name="CODE"
+            required="true" size="3" type="CHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="SYMBOL_LEFT"
+            size="12" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="SYMBOL_RIGHT"
+            size="12" type="VARCHAR"/>
+        <column dbType="CHAR" javaType="String" name="DECIMAL_POINT"
+            size="1" type="CHAR"/>
+        <column dbType="CHAR" javaType="String" name="THOUSANDS_POINT"
+            size="1" type="CHAR"/>
+        <column dbType="CHAR" javaType="String" name="DECIMAL_PLACES"
+            size="1" type="CHAR"/>
+        <column dbType="DOUBLE" javaType="java.math.BigDecimal"
+            name="VALUE" type="DOUBLE"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            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 dbType="CHAR" javaType="String" name="CUSTOMERS_GENDER"
+            required="true" size="1" type="CHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CUSTOMERS_FIRSTNAME" required="true" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CUSTOMERS_LASTNAME" required="true" size="32" type="VARCHAR"/>
+        <column dbType="TIMESTAMP" default="0000-00-00 00:00:00"
+            javaType="java.sql.Timestamp" name="CUSTOMERS_DOB"
+            required="true" type="TIMESTAMP"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CUSTOMERS_EMAIL_ADDRESS" required="true" size="96" type="VARCHAR"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="CUSTOMERS_DEFAULT_ADDRESS_ID" type="INTEGER"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CUSTOMERS_TELEPHONE" required="true" size="32" type="VARCHAR"/>
+        <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"/>
+        <column dbType="CHAR" javaType="String"
+            name="CUSTOMERS_NEWSLETTER" size="1" type="CHAR"/>
+    </table>
+    <table name="CUSTOMERS_BASKET">
+        <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="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"/>
+    </table>
+    <table name="CUSTOMERS_INFO">
+        <column dbType="INTEGER" 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"
+            name="CUSTOMERS_INFO_NUMBER_OF_LOGONS" type="INTEGER"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="CUSTOMERS_INFO_DATE_ACCOUNT_CREATED" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="CUSTOMERS_INFO_DATE_ACCOUNT_LAST_MODIFIED" type="TIMESTAMP"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal"
+            name="GLOBAL_PRODUCT_NOTIFICATIONS" type="INTEGER"/>
+    </table>
+    <table name="GEO_ZONES">
+        <column dbType="INTEGER" 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"
+            name="GEO_ZONE_DESCRIPTION" required="true" size="255" type="VARCHAR"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="LAST_MODIFIED" type="TIMESTAMP"/>
+        <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"/>
+        <column dbType="VARCHAR" javaType="String" name="NAME"
+            required="true" size="32" type="VARCHAR"/>
+        <column dbType="CHAR" javaType="String" name="CODE"
+            required="true" size="2" type="CHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="IMAGE"
+            size="64" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="DIRECTORY"
+            size="32" type="VARCHAR"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="SORT_ORDER" type="INTEGER"/>
+    </table>
+    <table name="MANUFACTURERS">
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="MANUFACTURERS_ID" primaryKey="true" required="true" type="INTEGER"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="MANUFACTURERS_NAME" required="true" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="MANUFACTURERS_IMAGE" size="64" type="VARCHAR"/>
+        <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="MANUFACTURERS_INFO">
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="MANUFACTURERS_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="VARCHAR" javaType="String"
+            name="MANUFACTURERS_URL" required="true" size="255" type="VARCHAR"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="URL_CLICKED"
+            required="true" type="INTEGER"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="DATE_LAST_CLICK" type="TIMESTAMP"/>
+    </table>
+    <table name="NEWSLETTERS">
+        <column dbType="INTEGER" 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"
+            required="true" size="32700" type="LONGVARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="MODULE"
+            required="true" size="255" type="VARCHAR"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="DATE_ADDED" required="true" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="DATE_SENT" type="TIMESTAMP"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="STATUS" type="INTEGER"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="LOCKED" type="INTEGER"/>
+    </table>
+    <table name="ORDERS">
+        <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"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CUSTOMERS_COMPANY" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CUSTOMERS_STREET_ADDRESS" required="true" size="64" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CUSTOMERS_SUBURB" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="CUSTOMERS_CITY"
+            required="true" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CUSTOMERS_POSTCODE" required="true" size="10" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CUSTOMERS_STATE" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CUSTOMERS_COUNTRY" required="true" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CUSTOMERS_TELEPHONE" required="true" 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"/>
+        <column dbType="VARCHAR" javaType="String" name="DELIVERY_NAME"
+            required="true" size="64" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="DELIVERY_COMPANY" 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"/>
+        <column dbType="VARCHAR" javaType="String" name="DELIVERY_CITY"
+            required="true" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="DELIVERY_POSTCODE" required="true" size="10" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="DELIVERY_STATE"
+            size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="DELIVERY_COUNTRY" required="true" 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"
+            required="true" size="64" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="BILLING_COMPANY" 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"/>
+        <column dbType="VARCHAR" javaType="String" name="BILLING_CITY"
+            required="true" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="BILLING_POSTCODE" required="true" size="10" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="BILLING_STATE"
+            size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="BILLING_COUNTRY" required="true" 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"
+            required="true" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="CC_TYPE"
+            size="20" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="CC_OWNER"
+            size="64" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="CC_NUMBER"
+            size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="CC_EXPIRES"
+            size="4" type="VARCHAR"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="LAST_MODIFIED" type="TIMESTAMP"/>
+        <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"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="ORDERS_DATE_FINISHED" type="TIMESTAMP"/>
+        <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"/>
+    </table>
+    <table name="ORDERS_PRODUCTS">
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="ORDERS_PRODUCTS_ID" primaryKey="true" required="true" type="INTEGER"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="ORDERS_ID" required="true" type="INTEGER"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="PRODUCTS_ID" required="true" type="INTEGER"/>
+        <column dbType="VARCHAR" javaType="String" name="PRODUCTS_MODEL"
+            size="12" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="PRODUCTS_NAME"
+            required="true" size="64" type="VARCHAR"/>
+        <column dbType="DECIMAL" javaType="java.math.BigDecimal"
+            name="PRODUCTS_PRICE" required="true" size="15" type="DECIMAL"/>
+        <column dbType="DECIMAL" javaType="java.math.BigDecimal"
+            name="FINAL_PRICE" required="true" size="15" type="DECIMAL"/>
+        <column dbType="DECIMAL" javaType="java.math.BigDecimal"
+            name="PRODUCTS_TAX" required="true" size="7" type="DECIMAL"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="PRODUCTS_QUANTITY" required="true" type="INTEGER"/>
+    </table>
+    <table name="ORDERS_PRODUCTS_ATTRIBUTES">
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="ORDERS_PRODUCTS_ATTRIBUTES_ID" primaryKey="true"
+            required="true" type="INTEGER"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="ORDERS_ID" required="true" type="INTEGER"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="ORDERS_PRODUCTS_ID" required="true" type="INTEGER"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="PRODUCTS_OPTIONS" required="true" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="PRODUCTS_OPTIONS_VALUES" required="true" size="32" type="VARCHAR"/>
+        <column dbType="DECIMAL" javaType="java.math.BigDecimal"
+            name="OPTIONS_VALUES_PRICE" required="true" size="15" type="DECIMAL"/>
+        <column dbType="CHAR" javaType="String" name="PRICE_PREFIX"
+            required="true" size="1" type="CHAR"/>
+    </table>
+    <table name="ORDERS_PRODUCTS_DOWNLOAD">
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="ORDERS_PRODUCTS_DOWNLOAD_ID" primaryKey="true"
+            required="true" type="INTEGER"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="ORDERS_ID"
+            required="true" type="INTEGER"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="ORDERS_PRODUCTS_ID"
+            required="true" type="INTEGER"/>
+        <column dbType="VARCHAR" default="" javaType="String"
+            name="ORDERS_PRODUCTS_FILENAME" required="true" size="255" type="VARCHAR"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="DOWNLOAD_MAXDAYS"
+            required="true" type="INTEGER"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="DOWNLOAD_COUNT"
+            required="true" type="INTEGER"/>
+    </table>
+    <table name="ORDERS_STATUS">
+        <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"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="ORDERS_STATUS_NAME" required="true" size="32" type="VARCHAR"/>
+    </table>
+    <table name="ORDERS_STATUS_HISTORY">
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="ORDERS_STATUS_HISTORY_ID" primaryKey="true"
+            required="true" type="INTEGER"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="ORDERS_ID" required="true" type="INTEGER"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="ORDERS_STATUS_ID" required="true" type="INTEGER"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="DATE_ADDED" required="true" type="TIMESTAMP"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="CUSTOMER_NOTIFIED" type="INTEGER"/>
+        <column dbType="LONG VARCHAR" javaType="String" name="COMMENTS"
+            size="32700" type="LONGVARCHAR"/>
+    </table>
+    <table name="PRODUCTS">
+        <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"/>
+        <column dbType="VARCHAR" javaType="String" name="PRODUCTS_IMAGE"
+            size="64" type="VARCHAR"/>
+        <column dbType="DECIMAL" javaType="java.math.BigDecimal"
+            name="PRODUCTS_PRICE" required="true" size="15" type="DECIMAL"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="PRODUCTS_DATE_ADDED" required="true" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="PRODUCTS_LAST_MODIFIED" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="PRODUCTS_DATE_AVAILABLE" type="TIMESTAMP"/>
+        <column dbType="DECIMAL" javaType="java.math.BigDecimal"
+            name="PRODUCTS_WEIGHT" required="true" size="5" type="DECIMAL"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="PRODUCTS_STATUS" required="true" type="INTEGER"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="PRODUCTS_TAX_CLASS_ID" required="true" type="INTEGER"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="MANUFACTURERS_ID" type="INTEGER"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="PRODUCTS_ORDERED"
+            required="true" type="INTEGER"/>
+    </table>
+    <table name="PRODUCTS_ATTRIBUTES">
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="PRODUCTS_ATTRIBUTES_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="OPTIONS_ID" required="true" type="INTEGER"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="OPTIONS_VALUES_ID" required="true" type="INTEGER"/>
+        <column dbType="DECIMAL" javaType="java.math.BigDecimal"
+            name="OPTIONS_VALUES_PRICE" required="true" size="15" type="DECIMAL"/>
+        <column dbType="CHAR" javaType="String" name="PRICE_PREFIX"
+            required="true" size="1" type="CHAR"/>
+    </table>
+    <table name="PRODUCTS_ATTRIBUTES_DOWNLOAD">
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="PRODUCTS_ATTRIBUTES_ID" primaryKey="true"
+            required="true" type="INTEGER"/>
+        <column dbType="VARCHAR" default="" javaType="String"
+            name="PRODUCTS_ATTRIBUTES_FILENAME" required="true"
+            size="255" type="VARCHAR"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal"
+            name="PRODUCTS_ATTRIBUTES_MAXDAYS" type="INTEGER"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal"
+            name="PRODUCTS_ATTRIBUTES_MAXCOUNT" type="INTEGER"/>
+    </table>
+    <table name="PRODUCTS_DESCRIPTION">
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="PRODUCTS_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"
+            name="PRODUCTS_NAME" required="true" size="64" type="VARCHAR"/>
+        <column dbType="LONG VARCHAR" javaType="String"
+            name="PRODUCTS_DESCRIPTION" size="32700" type="LONGVARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="PRODUCTS_URL"
+            size="255" type="VARCHAR"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="PRODUCTS_VIEWED" type="INTEGER"/>
+    </table>
+    <table name="PRODUCTS_NOTIFICATIONS">
+        <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"/>
+    </table>
+    <table name="PRODUCTS_OPTIONS">
+        <column dbType="INTEGER" default="0"
+            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"
+            name="PRODUCTS_OPTIONS_NAME" required="true" size="32" type="VARCHAR"/>
+    </table>
+    <table name="PRODUCTS_OPTIONS_VALUES">
+        <column dbType="INTEGER" default="0"
+            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"
+            name="PRODUCTS_OPTIONS_VALUES_NAME" required="true"
+            size="64" type="VARCHAR"/>
+    </table>
+    <table name="PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS">
+        <column dbType="INTEGER" 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"/>
+    </table>
+    <table name="PRODUCTS_TO_CATEGORIES">
+        <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"/>
+    </table>
+    <table name="REVIEWS">
+        <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"/>
+        <column dbType="VARCHAR" javaType="String" name="CUSTOMERS_NAME"
+            required="true" size="64" type="VARCHAR"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="REVIEWS_RATING" 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"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="REVIEWS_READ"
+            required="true" type="INTEGER"/>
+    </table>
+    <table name="REVIEWS_DESCRIPTION">
+        <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"/>
+    </table>
+    <table name="SESSIONS">
+        <column dbType="VARCHAR" javaType="String" name="SESSKEY"
+            primaryKey="true" required="true" size="32" type="VARCHAR"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="EXPIRY" required="true" type="INTEGER"/>
+        <column dbType="LONG VARCHAR" javaType="String" name="VALUE"
+            required="true" size="32700" type="LONGVARCHAR"/>
+    </table>
+    <table name="SPECIALS">
+        <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"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="SPECIALS_DATE_ADDED" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="SPECIALS_LAST_MODIFIED" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="EXPIRES_DATE" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="DATE_STATUS_CHANGE" type="TIMESTAMP"/>
+        <column dbType="INTEGER" default="1"
+            javaType="java.math.BigDecimal" name="STATUS"
+            required="true" type="INTEGER"/>
+    </table>
+    <table name="TAX_CLASS">
+        <column dbType="INTEGER" 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"
+            name="TAX_CLASS_DESCRIPTION" required="true" size="255" type="VARCHAR"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="LAST_MODIFIED" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="DATE_ADDED" required="true" type="TIMESTAMP"/>
+    </table>
+    <table name="TAX_RATES">
+        <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"/>
+        <column dbType="INTEGER" default="1"
+            javaType="java.math.BigDecimal" name="TAX_PRIORITY" type="INTEGER"/>
+        <column dbType="DECIMAL" javaType="java.math.BigDecimal"
+            name="TAX_RATE" required="true" size="7" type="DECIMAL"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="TAX_DESCRIPTION" required="true" size="255" type="VARCHAR"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="LAST_MODIFIED" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="DATE_ADDED" required="true" type="TIMESTAMP"/>
+    </table>
+    <table name="WHOS_ONLINE">
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="CUSTOMER_ID" type="INTEGER"/>
+        <column dbType="VARCHAR" javaType="String" name="FULL_NAME"
+            required="true" size="64" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="SESSION_ID"
+            required="true" size="128" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="IP_ADDRESS"
+            required="true" size="15" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="TIME_ENTRY"
+            required="true" size="14" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            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"/>
+    </table>
+    <table name="ZONES">
+        <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"/>
+    </table>
+    <table name="ZONES_TO_GEO_ZONES">
+        <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"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="GEO_ZONE_ID" type="INTEGER"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="LAST_MODIFIED" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="DATE_ADDED" required="true" type="TIMESTAMP"/>
+    </table>
+</database>

Added: 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-10 12:56:08 UTC (rev 222)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/schema/project-schema-pompei.xml	2007-07-10 12:56:50 UTC (rev 223)
@@ -0,0 +1,752 @@
+<?xml version="1.0"?>
+<!DOCTYPE database SYSTEM "http://dbflute.sandbox.seasar.org/dtd/database.dtd">
+<!-- Autogenerated by JDBCToXMLSchema! -->
+<database name="APP">
+    <table name="ADDRESS_BOOK">
+        <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"/>
+        <column dbType="VARCHAR" javaType="String" name="ENTRY_COMPANY"
+            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"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="ENTRY_STREET_ADDRESS" required="true" size="64" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="ENTRY_SUBURB"
+            size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="ENTRY_POSTCODE"
+            required="true" size="10" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="ENTRY_CITY"
+            required="true" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="ENTRY_STATE"
+            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"/>
+    </table>
+    <table name="ADDRESS_FORMAT">
+        <column dbType="INTEGER" 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"/>
+        <column dbType="VARCHAR" javaType="String" name="BANNERS_TITLE"
+            required="true" size="64" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="BANNERS_URL"
+            required="true" size="255" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="BANNERS_IMAGE"
+            required="true" size="64" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="BANNERS_GROUP"
+            required="true" size="10" type="VARCHAR"/>
+        <column dbType="LONG VARCHAR" javaType="String"
+            name="BANNERS_HTML_TEXT" size="32700" type="LONGVARCHAR"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="EXPIRES_IMPRESSIONS" type="INTEGER"/>
+        <column dbType="TIMESTAMP" default="NULL"
+            javaType="java.sql.Timestamp" name="EXPIRES_DATE" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" default="NULL"
+            javaType="java.sql.Timestamp" name="DATE_SCHEDULED" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="DATE_ADDED" required="true" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" default="NULL"
+            javaType="java.sql.Timestamp" name="DATE_STATUS_CHANGE" type="TIMESTAMP"/>
+        <column dbType="INTEGER" default="1"
+            javaType="java.math.BigDecimal" name="STATUS"
+            required="true" type="INTEGER"/>
+    </table>
+    <table name="BANNERS_HISTORY">
+        <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"
+            required="true" type="INTEGER"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="BANNERS_CLICKED"
+            required="true" type="INTEGER"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="BANNERS_HISTORY_DATE" required="true" type="TIMESTAMP"/>
+    </table>
+    <table name="CATEGORIES">
+        <column dbType="INTEGER" 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"/>
+        <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"/>
+    </table>
+    <table name="CATEGORIES_DESCRIPTION">
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="CATEGORIES_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="CATEGORIES_NAME" required="true" size="32" type="VARCHAR"/>
+    </table>
+    <table name="CONFIGURATION">
+        <column dbType="INTEGER" 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"
+            name="CONFIGURATION_KEY" required="true" size="64" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CONFIGURATION_VALUE" required="true" size="255" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CONFIGURATION_DESCRIPTION" required="true" size="255" type="VARCHAR"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="CONFIGURATION_GROUP_ID" required="true" type="INTEGER"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="SORT_ORDER" type="INTEGER"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="LAST_MODIFIED" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="DATE_ADDED" required="true" type="TIMESTAMP"/>
+        <column dbType="VARCHAR" javaType="String" name="USE_FUNCTION"
+            size="255" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="SET_FUNCTION"
+            size="255" type="VARCHAR"/>
+    </table>
+    <table name="CONFIGURATION_GROUP">
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="CONFIGURATION_GROUP_ID" primaryKey="true"
+            required="true" type="INTEGER"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CONFIGURATION_GROUP_TITLE" required="true" size="64" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CONFIGURATION_GROUP_DESCRIPTION" required="true"
+            size="255" type="VARCHAR"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="SORT_ORDER" type="INTEGER"/>
+        <column dbType="INTEGER" default="1"
+            javaType="java.math.BigDecimal" name="VISIBLE" type="INTEGER"/>
+    </table>
+    <table name="COUNTER">
+        <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">
+        <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"/>
+        <column dbType="VARCHAR" javaType="String" name="COUNTRIES_NAME"
+            required="true" size="64" type="VARCHAR"/>
+        <column dbType="CHAR" javaType="String"
+            name="COUNTRIES_ISO_CODE_2" required="true" size="2" type="CHAR"/>
+        <column dbType="CHAR" javaType="String"
+            name="COUNTRIES_ISO_CODE_3" required="true" size="3" type="CHAR"/>
+        <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"/>
+        <column dbType="VARCHAR" javaType="String" name="TITLE"
+            required="true" size="32" type="VARCHAR"/>
+        <column dbType="CHAR" javaType="String" name="CODE"
+            required="true" size="3" type="CHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="SYMBOL_LEFT"
+            size="12" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="SYMBOL_RIGHT"
+            size="12" type="VARCHAR"/>
+        <column dbType="CHAR" javaType="String" name="DECIMAL_POINT"
+            size="1" type="CHAR"/>
+        <column dbType="CHAR" javaType="String" name="THOUSANDS_POINT"
+            size="1" type="CHAR"/>
+        <column dbType="CHAR" javaType="String" name="DECIMAL_PLACES"
+            size="1" type="CHAR"/>
+        <column dbType="DOUBLE" javaType="java.math.BigDecimal"
+            name="VALUE" type="DOUBLE"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            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 dbType="CHAR" javaType="String" name="CUSTOMERS_GENDER"
+            required="true" size="1" type="CHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CUSTOMERS_FIRSTNAME" required="true" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CUSTOMERS_LASTNAME" required="true" size="32" type="VARCHAR"/>
+        <column dbType="TIMESTAMP" default="0000-00-00 00:00:00"
+            javaType="java.sql.Timestamp" name="CUSTOMERS_DOB"
+            required="true" type="TIMESTAMP"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CUSTOMERS_EMAIL_ADDRESS" required="true" size="96" type="VARCHAR"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="CUSTOMERS_DEFAULT_ADDRESS_ID" type="INTEGER"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CUSTOMERS_TELEPHONE" required="true" size="32" type="VARCHAR"/>
+        <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"/>
+        <column dbType="CHAR" javaType="String"
+            name="CUSTOMERS_NEWSLETTER" size="1" type="CHAR"/>
+    </table>
+    <table name="CUSTOMERS_BASKET">
+        <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="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"/>
+    </table>
+    <table name="CUSTOMERS_BASKET_ATTRIBUTES">
+        <column dbType="INTEGER" 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_OPTIONS_ID" required="true" type="INTEGER"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="PRODUCTS_OPTIONS_VALUE_ID" required="true" type="INTEGER"/>
+    </table>
+    <table name="CUSTOMERS_INFO">
+        <column dbType="INTEGER" 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"
+            name="CUSTOMERS_INFO_NUMBER_OF_LOGONS" type="INTEGER"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="CUSTOMERS_INFO_DATE_ACCOUNT_CREATED" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="CUSTOMERS_INFO_DATE_ACCOUNT_LAST_MODIFIED" type="TIMESTAMP"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal"
+            name="GLOBAL_PRODUCT_NOTIFICATIONS" type="INTEGER"/>
+    </table>
+    <table name="GEO_ZONES">
+        <column dbType="INTEGER" 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"
+            name="GEO_ZONE_DESCRIPTION" required="true" size="255" type="VARCHAR"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="LAST_MODIFIED" type="TIMESTAMP"/>
+        <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"/>
+        <column dbType="VARCHAR" javaType="String" name="NAME"
+            required="true" size="32" type="VARCHAR"/>
+        <column dbType="CHAR" javaType="String" name="CODE"
+            required="true" size="2" type="CHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="IMAGE"
+            size="64" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="DIRECTORY"
+            size="32" type="VARCHAR"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="SORT_ORDER" type="INTEGER"/>
+    </table>
+    <table name="MANUFACTURERS">
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="MANUFACTURERS_ID" primaryKey="true" required="true" type="INTEGER"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="MANUFACTURERS_NAME" required="true" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="MANUFACTURERS_IMAGE" size="64" type="VARCHAR"/>
+        <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="MANUFACTURERS_INFO">
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="MANUFACTURERS_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="VARCHAR" javaType="String"
+            name="MANUFACTURERS_URL" required="true" size="255" type="VARCHAR"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="URL_CLICKED"
+            required="true" type="INTEGER"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="DATE_LAST_CLICK" type="TIMESTAMP"/>
+    </table>
+    <table name="NEWSLETTERS">
+        <column dbType="INTEGER" 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"
+            required="true" size="32700" type="LONGVARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="MODULE"
+            required="true" size="255" type="VARCHAR"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="DATE_ADDED" required="true" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="DATE_SENT" type="TIMESTAMP"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="STATUS" type="INTEGER"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="LOCKED" type="INTEGER"/>
+    </table>
+    <table name="ORDERS">
+        <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"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CUSTOMERS_COMPANY" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CUSTOMERS_STREET_ADDRESS" required="true" size="64" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CUSTOMERS_SUBURB" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="CUSTOMERS_CITY"
+            required="true" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CUSTOMERS_POSTCODE" required="true" size="10" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CUSTOMERS_STATE" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CUSTOMERS_COUNTRY" required="true" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="CUSTOMERS_TELEPHONE" required="true" 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"/>
+        <column dbType="VARCHAR" javaType="String" name="DELIVERY_NAME"
+            required="true" size="64" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="DELIVERY_COMPANY" 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"/>
+        <column dbType="VARCHAR" javaType="String" name="DELIVERY_CITY"
+            required="true" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="DELIVERY_POSTCODE" required="true" size="10" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="DELIVERY_STATE"
+            size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="DELIVERY_COUNTRY" required="true" 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"
+            required="true" size="64" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="BILLING_COMPANY" 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"/>
+        <column dbType="VARCHAR" javaType="String" name="BILLING_CITY"
+            required="true" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="BILLING_POSTCODE" required="true" size="10" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="BILLING_STATE"
+            size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="BILLING_COUNTRY" required="true" 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"
+            required="true" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="CC_TYPE"
+            size="20" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="CC_OWNER"
+            size="64" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="CC_NUMBER"
+            size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="CC_EXPIRES"
+            size="4" type="VARCHAR"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="LAST_MODIFIED" type="TIMESTAMP"/>
+        <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"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="ORDERS_DATE_FINISHED" type="TIMESTAMP"/>
+        <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"/>
+    </table>
+    <table name="ORDERS_PRODUCTS">
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="ORDERS_PRODUCTS_ID" primaryKey="true" required="true" type="INTEGER"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="ORDERS_ID" required="true" type="INTEGER"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="PRODUCTS_ID" required="true" type="INTEGER"/>
+        <column dbType="VARCHAR" javaType="String" name="PRODUCTS_MODEL"
+            size="12" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="PRODUCTS_NAME"
+            required="true" size="64" type="VARCHAR"/>
+        <column dbType="DECIMAL" javaType="java.math.BigDecimal"
+            name="PRODUCTS_PRICE" required="true" size="15" type="DECIMAL"/>
+        <column dbType="DECIMAL" javaType="java.math.BigDecimal"
+            name="FINAL_PRICE" required="true" size="15" type="DECIMAL"/>
+        <column dbType="DECIMAL" javaType="java.math.BigDecimal"
+            name="PRODUCTS_TAX" required="true" size="7" type="DECIMAL"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="PRODUCTS_QUANTITY" required="true" type="INTEGER"/>
+    </table>
+    <table name="ORDERS_PRODUCTS_ATTRIBUTES">
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="ORDERS_PRODUCTS_ATTRIBUTES_ID" primaryKey="true"
+            required="true" type="INTEGER"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="ORDERS_ID" required="true" type="INTEGER"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="ORDERS_PRODUCTS_ID" required="true" type="INTEGER"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="PRODUCTS_OPTIONS" required="true" size="32" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="PRODUCTS_OPTIONS_VALUES" required="true" size="32" type="VARCHAR"/>
+        <column dbType="DECIMAL" javaType="java.math.BigDecimal"
+            name="OPTIONS_VALUES_PRICE" required="true" size="15" type="DECIMAL"/>
+        <column dbType="CHAR" javaType="String" name="PRICE_PREFIX"
+            required="true" size="1" type="CHAR"/>
+    </table>
+    <table name="ORDERS_PRODUCTS_DOWNLOAD">
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="ORDERS_PRODUCTS_DOWNLOAD_ID" primaryKey="true"
+            required="true" type="INTEGER"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="ORDERS_ID"
+            required="true" type="INTEGER"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="ORDERS_PRODUCTS_ID"
+            required="true" type="INTEGER"/>
+        <column dbType="VARCHAR" default="" javaType="String"
+            name="ORDERS_PRODUCTS_FILENAME" required="true" size="255" type="VARCHAR"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="DOWNLOAD_MAXDAYS"
+            required="true" type="INTEGER"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="DOWNLOAD_COUNT"
+            required="true" type="INTEGER"/>
+    </table>
+    <table name="ORDERS_STATUS">
+        <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"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="ORDERS_STATUS_NAME" required="true" size="32" type="VARCHAR"/>
+    </table>
+    <table name="ORDERS_STATUS_HISTORY">
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="ORDERS_STATUS_HISTORY_ID" primaryKey="true"
+            required="true" type="INTEGER"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="ORDERS_ID" required="true" type="INTEGER"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="ORDERS_STATUS_ID" required="true" type="INTEGER"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="DATE_ADDED" required="true" type="TIMESTAMP"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="CUSTOMER_NOTIFIED" type="INTEGER"/>
+        <column dbType="LONG VARCHAR" javaType="String" name="COMMENTS"
+            size="32700" type="LONGVARCHAR"/>
+    </table>
+    <table name="ORDERS_TOTAL">
+        <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"/>
+        <column dbType="VARCHAR" javaType="String" name="TEXT"
+            required="true" size="255" type="VARCHAR"/>
+        <column dbType="DECIMAL" javaType="java.math.BigDecimal"
+            name="VALUE" required="true" size="15" type="DECIMAL"/>
+        <column dbType="VARCHAR" javaType="String" name="OT_CLASS"
+            required="true" size="32" type="VARCHAR"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="SORT_ORDER" required="true" type="INTEGER"/>
+    </table>
+    <table name="PRODUCTS">
+        <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"/>
+        <column dbType="VARCHAR" javaType="String" name="PRODUCTS_IMAGE"
+            size="64" type="VARCHAR"/>
+        <column dbType="DECIMAL" javaType="java.math.BigDecimal"
+            name="PRODUCTS_PRICE" required="true" size="15" type="DECIMAL"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="PRODUCTS_DATE_ADDED" required="true" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="PRODUCTS_LAST_MODIFIED" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="PRODUCTS_DATE_AVAILABLE" type="TIMESTAMP"/>
+        <column dbType="DECIMAL" javaType="java.math.BigDecimal"
+            name="PRODUCTS_WEIGHT" required="true" size="5" type="DECIMAL"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="PRODUCTS_STATUS" required="true" type="INTEGER"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="PRODUCTS_TAX_CLASS_ID" required="true" type="INTEGER"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="MANUFACTURERS_ID" type="INTEGER"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="PRODUCTS_ORDERED"
+            required="true" type="INTEGER"/>
+    </table>
+    <table name="PRODUCTS_ATTRIBUTES">
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="PRODUCTS_ATTRIBUTES_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="OPTIONS_ID" required="true" type="INTEGER"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="OPTIONS_VALUES_ID" required="true" type="INTEGER"/>
+        <column dbType="DECIMAL" javaType="java.math.BigDecimal"
+            name="OPTIONS_VALUES_PRICE" required="true" size="15" type="DECIMAL"/>
+        <column dbType="CHAR" javaType="String" name="PRICE_PREFIX"
+            required="true" size="1" type="CHAR"/>
+    </table>
+    <table name="PRODUCTS_ATTRIBUTES_DOWNLOAD">
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="PRODUCTS_ATTRIBUTES_ID" primaryKey="true"
+            required="true" type="INTEGER"/>
+        <column dbType="VARCHAR" default="" javaType="String"
+            name="PRODUCTS_ATTRIBUTES_FILENAME" required="true"
+            size="255" type="VARCHAR"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal"
+            name="PRODUCTS_ATTRIBUTES_MAXDAYS" type="INTEGER"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal"
+            name="PRODUCTS_ATTRIBUTES_MAXCOUNT" type="INTEGER"/>
+    </table>
+    <table name="PRODUCTS_DESCRIPTION">
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="PRODUCTS_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"
+            name="PRODUCTS_NAME" required="true" size="64" type="VARCHAR"/>
+        <column dbType="LONG VARCHAR" javaType="String"
+            name="PRODUCTS_DESCRIPTION" size="32700" type="LONGVARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="PRODUCTS_URL"
+            size="255" type="VARCHAR"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="PRODUCTS_VIEWED" type="INTEGER"/>
+    </table>
+    <table name="PRODUCTS_NOTIFICATIONS">
+        <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"/>
+    </table>
+    <table name="PRODUCTS_OPTIONS">
+        <column dbType="INTEGER" default="0"
+            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"
+            name="PRODUCTS_OPTIONS_NAME" required="true" size="32" type="VARCHAR"/>
+    </table>
+    <table name="PRODUCTS_OPTIONS_VALUES">
+        <column dbType="INTEGER" default="0"
+            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"
+            name="PRODUCTS_OPTIONS_VALUES_NAME" required="true"
+            size="64" type="VARCHAR"/>
+    </table>
+    <table name="PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS">
+        <column dbType="INTEGER" 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"/>
+    </table>
+    <table name="PRODUCTS_TO_CATEGORIES">
+        <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"/>
+    </table>
+    <table name="REVIEWS">
+        <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"/>
+        <column dbType="VARCHAR" javaType="String" name="CUSTOMERS_NAME"
+            required="true" size="64" type="VARCHAR"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="REVIEWS_RATING" 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"/>
+        <column dbType="INTEGER" default="0"
+            javaType="java.math.BigDecimal" name="REVIEWS_READ"
+            required="true" type="INTEGER"/>
+    </table>
+    <table name="REVIEWS_DESCRIPTION">
+        <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"/>
+    </table>
+    <table name="SESSIONS">
+        <column dbType="VARCHAR" javaType="String" name="SESSKEY"
+            primaryKey="true" required="true" size="32" type="VARCHAR"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="EXPIRY" required="true" type="INTEGER"/>
+        <column dbType="LONG VARCHAR" javaType="String" name="VALUE"
+            required="true" size="32700" type="LONGVARCHAR"/>
+    </table>
+    <table name="SPECIALS">
+        <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"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="SPECIALS_DATE_ADDED" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="SPECIALS_LAST_MODIFIED" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="EXPIRES_DATE" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="DATE_STATUS_CHANGE" type="TIMESTAMP"/>
+        <column dbType="INTEGER" default="1"
+            javaType="java.math.BigDecimal" name="STATUS"
+            required="true" type="INTEGER"/>
+    </table>
+    <table name="TAX_CLASS">
+        <column dbType="INTEGER" 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"
+            name="TAX_CLASS_DESCRIPTION" required="true" size="255" type="VARCHAR"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="LAST_MODIFIED" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="DATE_ADDED" required="true" type="TIMESTAMP"/>
+    </table>
+    <table name="TAX_RATES">
+        <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"/>
+        <column dbType="INTEGER" default="1"
+            javaType="java.math.BigDecimal" name="TAX_PRIORITY" type="INTEGER"/>
+        <column dbType="DECIMAL" javaType="java.math.BigDecimal"
+            name="TAX_RATE" required="true" size="7" type="DECIMAL"/>
+        <column dbType="VARCHAR" javaType="String"
+            name="TAX_DESCRIPTION" required="true" size="255" type="VARCHAR"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="LAST_MODIFIED" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="DATE_ADDED" required="true" type="TIMESTAMP"/>
+    </table>
+    <table name="WHOS_ONLINE">
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="CUSTOMER_ID" type="INTEGER"/>
+        <column dbType="VARCHAR" javaType="String" name="FULL_NAME"
+            required="true" size="64" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="SESSION_ID"
+            required="true" size="128" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="IP_ADDRESS"
+            required="true" size="15" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String" name="TIME_ENTRY"
+            required="true" size="14" type="VARCHAR"/>
+        <column dbType="VARCHAR" javaType="String"
+            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"/>
+    </table>
+    <table name="ZONES">
+        <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"/>
+    </table>
+    <table name="ZONES_TO_GEO_ZONES">
+        <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"/>
+        <column dbType="INTEGER" javaType="java.math.BigDecimal"
+            name="GEO_ZONE_ID" type="INTEGER"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="LAST_MODIFIED" type="TIMESTAMP"/>
+        <column dbType="TIMESTAMP" javaType="java.sql.Timestamp"
+            name="DATE_ADDED" required="true" type="TIMESTAMP"/>
+    </table>
+</database>

Added: pompei/trunk/mydbflute/dbflute-0.5.2/schema/readme.txt
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/schema/readme.txt	2007-07-10 12:56:08 UTC (rev 222)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/schema/readme.txt	2007-07-10 12:56:50 UTC (rev 223)
@@ -0,0 +1 @@
+Directory for SchemaFile

• 前の記事 [pal-cvs 2490] [222] added mydbflute
• 次の記事 [pal-cvs 2492] [224] added mydbflute
• 記事の並び順: [ 日付 ] [ スレッド ] [ 件名 ] [ 著者 ]