svnno****@sourc*****
svnno****@sourc*****
2007年 9月 20日 (木) 18:04:47 JST
Revision: 572
http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=572
Author: shinsuke
Date: 2007-09-20 18:04:47 +0900 (Thu, 20 Sep 2007)
Log Message:
-----------
updated db
Modified Paths:
--------------
pompei/portlets/pompei-core/trunk/src/main/config/pompei.clay
pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql
pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/insert_data.sql
-------------- next part --------------
Modified: pompei/portlets/pompei-core/trunk/src/main/config/pompei.clay
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/config/pompei.clay 2007-09-20 00:56:01 UTC (rev 571)
+++ pompei/portlets/pompei-core/trunk/src/main/config/pompei.clay 2007-09-20 09:04:47 UTC (rev 572)
@@ -395,7 +395,7 @@
</table>
<table alias="" name="CUSTOMER" remarks="">
<table-description></table-description>
-<table-figure-bounds height="229" width="244" x="2328" y="787"/>
+<table-figure-bounds height="173" width="244" x="2328" y="787"/>
<column-list>
<column alias="" auto-increment="true" column-size="0" decimal-digits="0" default-value="" mandatory="true" name="CUSTOMER_ID" remarks="">
<column-description></column-description>
@@ -644,8 +644,8 @@
<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="false" name="DATE_ADDED" remarks="">
<column-description></column-description>
<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
-<variant type-name-pattern="TIMESTAMP"/>
<variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
+<variant type-name-pattern="TIMESTAMP"/>
</data-type>
</column>
</column-list>
@@ -792,12 +792,10 @@
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
-<column alias="" auto-increment="false" column-size="32700" decimal-digits="0" default-value="" mandatory="false" name="DESCRIPTION" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="DESCRIPTION" remarks="">
<column-description></column-description>
-<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
-<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
-<variant type-name-pattern="CHAR"/>
-<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n) BINARY"/>
+<data-type jdbc-type="-1" literal-prefix="'" literal-suffix="'" name="TEXT" selected-variant-pattern="TEXT">
+<variant type-name-pattern="TEXT"/>
</data-type>
</column>
</column-list>
@@ -1068,11 +1066,10 @@
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
-<column alias="" auto-increment="false" column-size="1000" decimal-digits="0" default-value="" mandatory="false" name="LONG_DESCRIPTION" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="LONG_DESCRIPTION" remarks="">
<column-description></column-description>
-<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
-<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
-<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
+<data-type jdbc-type="-1" literal-prefix="'" literal-suffix="'" name="TEXT" selected-variant-pattern="TEXT">
+<variant type-name-pattern="TEXT"/>
</data-type>
</column>
</column-list>
@@ -1143,8 +1140,8 @@
<column alias="" auto-increment="false" column-size="1" decimal-digits="0" default-value="" mandatory="true" name="CUSTOMER_GENDER" remarks="">
<column-description></column-description>
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
-<variant type-name-pattern="CHAR"/>
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
+<variant type-name-pattern="CHAR"/>
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n) BINARY"/>
</data-type>
</column>
@@ -2082,12 +2079,10 @@
<variant type-name-pattern="INTEGER"/>
</data-type>
</column>
-<column alias="" auto-increment="false" column-size="32700" decimal-digits="0" default-value="" mandatory="false" name="COMMENTS" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="COMMENT" remarks="">
<column-description></column-description>
-<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
-<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
-<variant type-name-pattern="CHAR"/>
-<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n) BINARY"/>
+<data-type jdbc-type="-1" literal-prefix="'" literal-suffix="'" name="TEXT" selected-variant-pattern="TEXT">
+<variant type-name-pattern="TEXT"/>
</data-type>
</column>
</column-list>
@@ -2146,12 +2141,10 @@
<variant precision-max="4000" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
</data-type>
</column>
-<column alias="" auto-increment="false" column-size="32700" decimal-digits="0" default-value="" mandatory="true" name="TEXT" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="true" name="COMMENT" remarks="">
<column-description></column-description>
-<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
-<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
-<variant type-name-pattern="CHAR"/>
-<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n) BINARY"/>
+<data-type jdbc-type="-1" literal-prefix="'" literal-suffix="'" name="TEXT" selected-variant-pattern="TEXT">
+<variant type-name-pattern="TEXT"/>
</data-type>
</column>
</column-list>
@@ -2177,7 +2170,7 @@
</table>
<table alias="" name="PRODUCT" remarks="">
<table-description></table-description>
-<table-figure-bounds height="-1" width="-1" x="2246" y="2372"/>
+<table-figure-bounds height="286" width="249" x="2246" y="2372"/>
<column-list>
<column alias="" auto-increment="true" column-size="0" decimal-digits="0" default-value="" mandatory="true" name="PRODUCT_ID" remarks="">
<column-description></column-description>
@@ -2192,6 +2185,13 @@
<variant type-name-pattern="BIGINT ZEROFILL"/>
</data-type>
</column>
+<column alias="" auto-increment="false" column-size="32" decimal-digits="0" default-value="" mandatory="false" name="MODEL" remarks="">
+<column-description></column-description>
+<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
+<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
+<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
+</data-type>
+</column>
<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="true" name="QUANTITY" remarks="">
<column-description></column-description>
<data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
@@ -2205,27 +2205,6 @@
<variant type-name-pattern="INTEGER ZEROFILL"/>
</data-type>
</column>
-<column alias="" auto-increment="false" column-size="32" decimal-digits="0" default-value="" mandatory="false" name="MODEL" remarks="">
-<column-description></column-description>
-<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
-<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
-<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
-</data-type>
-</column>
-<column alias="" auto-increment="false" column-size="64" decimal-digits="0" default-value="" mandatory="false" name="THUMBNAIL" remarks="">
-<column-description></column-description>
-<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
-<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
-<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
-</data-type>
-</column>
-<column alias="" auto-increment="false" column-size="64" decimal-digits="0" default-value="" mandatory="false" name="IMAGE" remarks="">
-<column-description></column-description>
-<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
-<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
-<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
-</data-type>
-</column>
<column alias="" auto-increment="false" column-size="15" decimal-digits="4" default-value="" mandatory="true" name="PRICE" remarks="">
<column-description></column-description>
<data-type jdbc-type="3" name="DECIMAL" selected-variant-pattern="DECIMAL(%p, %s)">
@@ -2239,41 +2218,47 @@
<variant precision-max="17" precision-min="0" precision-variable="%p" scale-max="128" scale-min="0" scale-variable="%s" type-name-pattern="DECIMAL(%p, %s) ZEROFILL"/>
</data-type>
</column>
-<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="true" name="DATE_ADDED" remarks="">
+<column alias="" auto-increment="false" column-size="5" decimal-digits="2" default-value="" mandatory="false" name="WEIGHT" remarks="">
<column-description></column-description>
-<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
-<variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
-<variant type-name-pattern="TIMESTAMP"/>
+<data-type jdbc-type="3" name="DECIMAL" selected-variant-pattern="DECIMAL(%p, %s)">
+<variant precision-max="17" precision-min="0" precision-variable="%n" type-name-pattern="DECIMAL(%n)"/>
+<variant precision-max="17" precision-min="0" precision-variable="%n" type-name-pattern="DECIMAL(%n) UNSIGNED"/>
+<variant precision-max="17" precision-min="0" precision-variable="%n" type-name-pattern="DECIMAL(%n) UNSIGNED ZEROFILL"/>
+<variant precision-max="17" precision-min="0" precision-variable="%n" type-name-pattern="DECIMAL(%n) ZEROFILL"/>
+<variant precision-max="17" precision-min="0" precision-variable="%p" scale-max="128" scale-min="0" scale-variable="%s" type-name-pattern="DECIMAL(%p, %s)"/>
+<variant precision-max="17" precision-min="0" precision-variable="%p" scale-max="128" scale-min="0" scale-variable="%s" type-name-pattern="DECIMAL(%p, %s) UNSIGNED"/>
+<variant precision-max="17" precision-min="0" precision-variable="%p" scale-max="128" scale-min="0" scale-variable="%s" type-name-pattern="DECIMAL(%p, %s) UNSIGNED ZEROFILL"/>
+<variant precision-max="17" precision-min="0" precision-variable="%p" scale-max="128" scale-min="0" scale-variable="%s" type-name-pattern="DECIMAL(%p, %s) ZEROFILL"/>
</data-type>
</column>
-<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="false" name="LAST_MODIFIED" remarks="">
+<column alias="" auto-increment="false" column-size="64" decimal-digits="0" default-value="" mandatory="false" name="IMAGE" remarks="">
<column-description></column-description>
-<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
-<variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
-<variant type-name-pattern="TIMESTAMP"/>
+<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
+<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
+<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
-<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="false" name="DATE_AVAILABLE" remarks="">
+<column alias="" auto-increment="false" column-size="64" decimal-digits="0" default-value="" mandatory="false" name="THUMBNAIL" remarks="">
<column-description></column-description>
-<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
-<variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
-<variant type-name-pattern="TIMESTAMP"/>
+<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
+<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
+<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
-<column alias="" auto-increment="false" column-size="5" decimal-digits="2" default-value="" mandatory="true" name="WEIGHT" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="STOCK" remarks="">
<column-description></column-description>
-<data-type jdbc-type="3" name="DECIMAL" selected-variant-pattern="DECIMAL(%p, %s)">
-<variant precision-max="17" precision-min="0" precision-variable="%p" scale-max="128" scale-min="0" scale-variable="%s" type-name-pattern="DECIMAL(%p, %s)"/>
-<variant precision-max="17" precision-min="0" precision-variable="%n" type-name-pattern="DECIMAL(%n)"/>
-<variant precision-max="17" precision-min="0" precision-variable="%n" type-name-pattern="DECIMAL(%n) UNSIGNED"/>
-<variant precision-max="17" precision-min="0" precision-variable="%n" type-name-pattern="DECIMAL(%n) UNSIGNED ZEROFILL"/>
-<variant precision-max="17" precision-min="0" precision-variable="%n" type-name-pattern="DECIMAL(%n) ZEROFILL"/>
-<variant precision-max="17" precision-min="0" precision-variable="%p" scale-max="128" scale-min="0" scale-variable="%s" type-name-pattern="DECIMAL(%p, %s) UNSIGNED"/>
-<variant precision-max="17" precision-min="0" precision-variable="%p" scale-max="128" scale-min="0" scale-variable="%s" type-name-pattern="DECIMAL(%p, %s) UNSIGNED ZEROFILL"/>
-<variant precision-max="17" precision-min="0" precision-variable="%p" scale-max="128" scale-min="0" scale-variable="%s" type-name-pattern="DECIMAL(%p, %s) ZEROFILL"/>
+<data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
+<variant type-name-pattern="INTEGER"/>
+<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n)"/>
+<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) UNSIGNED"/>
+<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) UNSIGNED ZEROFILL"/>
+<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) ZEROFILL"/>
+<variant type-name-pattern="INTEGER UNSIGNED"/>
+<variant type-name-pattern="INTEGER UNSIGNED ZEROFILL"/>
+<variant type-name-pattern="INTEGER ZEROFILL"/>
</data-type>
</column>
-<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="true" name="STATUS" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="0" mandatory="true" name="ORDERED" remarks="">
<column-description></column-description>
<data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
<variant type-name-pattern="INTEGER"/>
@@ -2286,7 +2271,7 @@
<variant type-name-pattern="INTEGER ZEROFILL"/>
</data-type>
</column>
-<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="TAX_CLASS_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="true" name="STATUS" remarks="">
<column-description></column-description>
<data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
<variant type-name-pattern="INTEGER"/>
@@ -2299,8 +2284,29 @@
<variant type-name-pattern="INTEGER ZEROFILL"/>
</data-type>
</column>
-<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="MANUFACTURER_ID" remarks="">
+<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="true" name="DATE_ADDED" remarks="">
<column-description></column-description>
+<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
+<variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
+<variant type-name-pattern="TIMESTAMP"/>
+</data-type>
+</column>
+<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="false" name="LAST_MODIFIED" remarks="">
+<column-description></column-description>
+<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
+<variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
+<variant type-name-pattern="TIMESTAMP"/>
+</data-type>
+</column>
+<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="false" name="DATE_AVAILABLE" remarks="">
+<column-description></column-description>
+<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
+<variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
+<variant type-name-pattern="TIMESTAMP"/>
+</data-type>
+</column>
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="TAX_CLASS_ID" remarks="">
+<column-description></column-description>
<data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
<variant type-name-pattern="INTEGER"/>
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n)"/>
@@ -2312,7 +2318,7 @@
<variant type-name-pattern="INTEGER ZEROFILL"/>
</data-type>
</column>
-<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="0" mandatory="true" name="ORDERED" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="MANUFACTURER_ID" remarks="">
<column-description></column-description>
<data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
<variant type-name-pattern="INTEGER"/>
@@ -2576,12 +2582,10 @@
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
-<column alias="" auto-increment="false" column-size="32700" decimal-digits="0" default-value="" mandatory="false" name="DESCRIPTION" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="DESCRIPTION" remarks="">
<column-description></column-description>
-<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
-<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
-<variant type-name-pattern="CHAR"/>
-<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n) BINARY"/>
+<data-type jdbc-type="-1" literal-prefix="'" literal-suffix="'" name="TEXT" selected-variant-pattern="TEXT">
+<variant type-name-pattern="TEXT"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="255" decimal-digits="0" default-value="" mandatory="false" name="URL" remarks="">
@@ -2917,7 +2921,7 @@
</table>
<table alias="" name="REVIEW" remarks="">
<table-description></table-description>
-<table-figure-bounds height="159" width="238" x="2479" y="2122"/>
+<table-figure-bounds height="159" width="267" x="2479" y="2122"/>
<column-list>
<column alias="" auto-increment="true" column-size="0" decimal-digits="0" default-value="" mandatory="true" name="REVIEW_ID" remarks="">
<column-description></column-description>
@@ -3055,12 +3059,10 @@
<variant type-name-pattern="INTEGER ZEROFILL"/>
</data-type>
</column>
-<column alias="" auto-increment="false" column-size="32700" decimal-digits="0" default-value="" mandatory="true" name="REVIEW_TEXT" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="true" name="COMMENT" remarks="">
<column-description></column-description>
-<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
-<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
-<variant type-name-pattern="CHAR"/>
-<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n) BINARY"/>
+<data-type jdbc-type="-1" literal-prefix="'" literal-suffix="'" name="TEXT" selected-variant-pattern="TEXT">
+<variant type-name-pattern="TEXT"/>
</data-type>
</column>
</column-list>
@@ -3127,11 +3129,11 @@
<column alias="" auto-increment="false" column-size="15" decimal-digits="4" default-value="" mandatory="true" name="BARGAIN_PRICE" remarks="">
<column-description></column-description>
<data-type jdbc-type="3" name="DECIMAL" selected-variant-pattern="DECIMAL(%p, %s)">
+<variant precision-max="17" precision-min="0" precision-variable="%p" scale-max="128" scale-min="0" scale-variable="%s" type-name-pattern="DECIMAL(%p, %s)"/>
<variant precision-max="17" precision-min="0" precision-variable="%n" type-name-pattern="DECIMAL(%n)"/>
<variant precision-max="17" precision-min="0" precision-variable="%n" type-name-pattern="DECIMAL(%n) UNSIGNED"/>
<variant precision-max="17" precision-min="0" precision-variable="%n" type-name-pattern="DECIMAL(%n) UNSIGNED ZEROFILL"/>
<variant precision-max="17" precision-min="0" precision-variable="%n" type-name-pattern="DECIMAL(%n) ZEROFILL"/>
-<variant precision-max="17" precision-min="0" precision-variable="%p" scale-max="128" scale-min="0" scale-variable="%s" type-name-pattern="DECIMAL(%p, %s)"/>
<variant precision-max="17" precision-min="0" precision-variable="%p" scale-max="128" scale-min="0" scale-variable="%s" type-name-pattern="DECIMAL(%p, %s) UNSIGNED"/>
<variant precision-max="17" precision-min="0" precision-variable="%p" scale-max="128" scale-min="0" scale-variable="%s" type-name-pattern="DECIMAL(%p, %s) UNSIGNED ZEROFILL"/>
<variant precision-max="17" precision-min="0" precision-variable="%p" scale-max="128" scale-min="0" scale-variable="%s" type-name-pattern="DECIMAL(%p, %s) ZEROFILL"/>
@@ -3154,15 +3156,15 @@
<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="false" name="START_DATE" remarks="">
<column-description></column-description>
<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
-<variant type-name-pattern="TIMESTAMP"/>
<variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
+<variant type-name-pattern="TIMESTAMP"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="26" decimal-digits="0" default-value="" mandatory="false" name="EXPIRE_DATE" remarks="">
<column-description></column-description>
<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
-<variant type-name-pattern="TIMESTAMP"/>
<variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
+<variant type-name-pattern="TIMESTAMP"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="1" mandatory="true" name="STATUS" remarks="">
@@ -3947,12 +3949,10 @@
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
-<column alias="" auto-increment="false" column-size="32700" decimal-digits="0" default-value="" mandatory="false" name="DESCRIPTION" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="DESCRIPTION" remarks="">
<column-description></column-description>
-<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
-<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
-<variant type-name-pattern="CHAR"/>
-<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n) BINARY"/>
+<data-type jdbc-type="-1" literal-prefix="'" literal-suffix="'" name="TEXT" selected-variant-pattern="TEXT">
+<variant type-name-pattern="TEXT"/>
</data-type>
</column>
</column-list>
@@ -4077,12 +4077,10 @@
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
-<column alias="" auto-increment="false" column-size="32700" decimal-digits="0" default-value="" mandatory="false" name="DESCRIPTION" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="DESCRIPTION" remarks="">
<column-description></column-description>
-<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
-<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
-<variant type-name-pattern="CHAR"/>
-<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n) BINARY"/>
+<data-type jdbc-type="-1" literal-prefix="'" literal-suffix="'" name="TEXT" selected-variant-pattern="TEXT">
+<variant type-name-pattern="TEXT"/>
</data-type>
</column>
</column-list>
Modified: pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql 2007-09-20 00:56:01 UTC (rev 571)
+++ pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql 2007-09-20 09:04:47 UTC (rev 572)
@@ -174,19 +174,20 @@
CREATE TABLE PRODUCT (
PRODUCT_ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 100, INCREMENT BY 1)
+ , MODEL VARCHAR(32)
, QUANTITY INTEGER NOT NULL
- , MODEL VARCHAR(32)
+ , PRICE DECIMAL(15, 4) NOT NULL
+ , WEIGHT DECIMAL(5, 2)
+ , IMAGE VARCHAR(64)
, THUMBNAIL VARCHAR(64)
- , IMAGE VARCHAR(64)
- , PRICE DECIMAL(15, 4) NOT NULL
+ , STOCK INTEGER
+ , ORDERED INTEGER NOT NULL DEFAULT 0
+ , STATUS INTEGER NOT NULL
, DATE_ADDED TIMESTAMP NOT NULL
, LAST_MODIFIED TIMESTAMP
, DATE_AVAILABLE TIMESTAMP
- , WEIGHT DECIMAL(5, 2) NOT NULL
- , STATUS INTEGER NOT NULL
, TAX_CLASS_ID INTEGER
, MANUFACTURER_ID INTEGER
- , ORDERED INTEGER NOT NULL DEFAULT 0
, PRIMARY KEY (PRODUCT_ID)
);
@@ -280,7 +281,7 @@
, LANGUAGE_ID INTEGER NOT NULL
, URL VARCHAR(255) NOT NULL
, SHORT_DESCRIPTION VARCHAR(100)
- , LONG_DESCRIPTION VARCHAR(1000)
+ , LONG_DESCRIPTION LONG VARCHAR
, PRIMARY KEY (LANGUAGE_ID, MANUFACTURER_ID)
);
@@ -324,14 +325,14 @@
, ORDER_STATUS_ID INTEGER NOT NULL
, DATE_ADDED TIMESTAMP NOT NULL
, CUSTOMER_NOTIFIED INTEGER DEFAULT 0
- , COMMENTS LONG VARCHAR
+ , COMMENT LONG VARCHAR
, PRIMARY KEY (ORDER_STATUS_HISTORY_ID)
);
CREATE TABLE ORDER_COMMENT (
ORDER_FORM_ID BIGINT NOT NULL
, TITLE VARCHAR(255) NOT NULL
- , TEXT LONG VARCHAR NOT NULL
+ , COMMENT LONG VARCHAR NOT NULL
, PRIMARY KEY (ORDER_FORM_ID)
);
@@ -377,7 +378,7 @@
CREATE TABLE REVIEW_DESCRIPTION (
REVIEW_ID BIGINT NOT NULL
, LANGUAGE_ID INTEGER NOT NULL
- , REVIEW_TEXT LONG VARCHAR NOT NULL
+ , COMMENT LONG VARCHAR NOT NULL
, PRIMARY KEY (LANGUAGE_ID, REVIEW_ID)
);
Modified: pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/insert_data.sql
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/insert_data.sql 2007-09-20 00:56:01 UTC (rev 571)
+++ pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/insert_data.sql 2007-09-20 09:04:47 UTC (rev 572)
@@ -1,337 +1,337 @@
-INSERT INTO language VALUES (1,'日本語','ja','icon.gif','japanese',1);
-INSERT INTO language VALUES (2,'English','en','icon.gif','english',2);
+INSERT INTO LANGUAGE VALUES (1,'日本語','ja','icon.gif','japanese',1);
+INSERT INTO LANGUAGE VALUES (2,'English','en','icon.gif','english',2);
-INSERT INTO country VALUES (1,'Afghanistan','AF','AFG');
-INSERT INTO country VALUES (2,'Albania','AL','ALB');
-INSERT INTO country VALUES (3,'Algeria','DZ','DZA');
-INSERT INTO country VALUES (4,'American Samoa','AS','ASM');
-INSERT INTO country VALUES (5,'Andorra','AD','AND');
-INSERT INTO country VALUES (6,'Angola','AO','AGO');
-INSERT INTO country VALUES (7,'Anguilla','AI','AIA');
-INSERT INTO country VALUES (8,'Antarctica','AQ','ATA');
-INSERT INTO country VALUES (9,'Antigua and Barbuda','AG','ATG');
-INSERT INTO country VALUES (10,'Argentina','AR','ARG');
-INSERT INTO country VALUES (11,'Armenia','AM','ARM');
-INSERT INTO country VALUES (12,'Aruba','AW','ABW');
-INSERT INTO country VALUES (13,'Australia','AU','AUS');
-INSERT INTO country VALUES (14,'Austria','AT','AUT');
-INSERT INTO country VALUES (15,'Azerbaijan','AZ','AZE');
-INSERT INTO country VALUES (16,'Bahamas','BS','BHS');
-INSERT INTO country VALUES (17,'Bahrain','BH','BHR');
-INSERT INTO country VALUES (18,'Bangladesh','BD','BGD');
-INSERT INTO country VALUES (19,'Barbados','BB','BRB');
-INSERT INTO country VALUES (20,'Belarus','BY','BLR');
-INSERT INTO country VALUES (21,'Belgium','BE','BEL');
-INSERT INTO country VALUES (22,'Belize','BZ','BLZ');
-INSERT INTO country VALUES (23,'Benin','BJ','BEN');
-INSERT INTO country VALUES (24,'Bermuda','BM','BMU');
-INSERT INTO country VALUES (25,'Bhutan','BT','BTN');
-INSERT INTO country VALUES (26,'Bolivia','BO','BOL');
-INSERT INTO country VALUES (27,'Bosnia and Herzegowina','BA','BIH');
-INSERT INTO country VALUES (28,'Botswana','BW','BWA');
-INSERT INTO country VALUES (29,'Bouvet Island','BV','BVT');
-INSERT INTO country VALUES (30,'Brazil','BR','BRA');
-INSERT INTO country VALUES (31,'British Indian Ocean Territory','IO','IOT');
-INSERT INTO country VALUES (32,'Brunei Darussalam','BN','BRN');
-INSERT INTO country VALUES (33,'Bulgaria','BG','BGR');
-INSERT INTO country VALUES (34,'Burkina Faso','BF','BFA');
-INSERT INTO country VALUES (35,'Burundi','BI','BDI');
-INSERT INTO country VALUES (36,'Cambodia','KH','KHM');
-INSERT INTO country VALUES (37,'Cameroon','CM','CMR');
-INSERT INTO country VALUES (38,'Canada','CA','CAN');
-INSERT INTO country VALUES (39,'Cape Verde','CV','CPV');
-INSERT INTO country VALUES (40,'Cayman Islands','KY','CYM');
-INSERT INTO country VALUES (41,'Central African Republic','CF','CAF');
-INSERT INTO country VALUES (42,'Chad','TD','TCD');
-INSERT INTO country VALUES (43,'Chile','CL','CHL');
-INSERT INTO country VALUES (44,'China','CN','CHN');
-INSERT INTO country VALUES (45,'Christmas Island','CX','CXR');
-INSERT INTO country VALUES (46,'Cocos (Keeling) Islands','CC','CCK');
-INSERT INTO country VALUES (47,'Colombia','CO','COL');
-INSERT INTO country VALUES (48,'Comoros','KM','COM');
-INSERT INTO country VALUES (49,'Congo','CG','COG');
-INSERT INTO country VALUES (50,'Cook Islands','CK','COK');
-INSERT INTO country VALUES (51,'Costa Rica','CR','CRI');
-INSERT INTO country VALUES (52,'Cote D''Ivoire','CI','CIV');
-INSERT INTO country VALUES (53,'Croatia','HR','HRV');
-INSERT INTO country VALUES (54,'Cuba','CU','CUB');
-INSERT INTO country VALUES (55,'Cyprus','CY','CYP');
-INSERT INTO country VALUES (56,'Czech Republic','CZ','CZE');
-INSERT INTO country VALUES (57,'Denmark','DK','DNK');
-INSERT INTO country VALUES (58,'Djibouti','DJ','DJI');
-INSERT INTO country VALUES (59,'Dominica','DM','DMA');
-INSERT INTO country VALUES (60,'Dominican Republic','DO','DOM');
-INSERT INTO country VALUES (61,'East Timor','TP','TMP');
-INSERT INTO country VALUES (62,'Ecuador','EC','ECU');
-INSERT INTO country VALUES (63,'Egypt','EG','EGY');
-INSERT INTO country VALUES (64,'El Salvador','SV','SLV');
-INSERT INTO country VALUES (65,'Equatorial Guinea','GQ','GNQ');
-INSERT INTO country VALUES (66,'Eritrea','ER','ERI');
-INSERT INTO country VALUES (67,'Estonia','EE','EST');
-INSERT INTO country VALUES (68,'Ethiopia','ET','ETH');
-INSERT INTO country VALUES (69,'Falkland Islands (Malvinas)','FK','FLK');
-INSERT INTO country VALUES (70,'Faroe Islands','FO','FRO');
-INSERT INTO country VALUES (71,'Fiji','FJ','FJI');
-INSERT INTO country VALUES (72,'Finland','FI','FIN');
-INSERT INTO country VALUES (73,'France','FR','FRA');
-INSERT INTO country VALUES (74,'France, Metropolitan','FX','FXX');
-INSERT INTO country VALUES (75,'French Guiana','GF','GUF');
-INSERT INTO country VALUES (76,'French Polynesia','PF','PYF');
-INSERT INTO country VALUES (77,'French Southern Territories','TF','ATF');
-INSERT INTO country VALUES (78,'Gabon','GA','GAB');
-INSERT INTO country VALUES (79,'Gambia','GM','GMB');
-INSERT INTO country VALUES (80,'Georgia','GE','GEO');
-INSERT INTO country VALUES (81,'Germany','DE','DEU');
-INSERT INTO country VALUES (82,'Ghana','GH','GHA');
-INSERT INTO country VALUES (83,'Gibraltar','GI','GIB');
-INSERT INTO country VALUES (84,'Greece','GR','GRC');
-INSERT INTO country VALUES (85,'Greenland','GL','GRL');
-INSERT INTO country VALUES (86,'Grenada','GD','GRD');
-INSERT INTO country VALUES (87,'Guadeloupe','GP','GLP');
-INSERT INTO country VALUES (88,'Guam','GU','GUM');
-INSERT INTO country VALUES (89,'Guatemala','GT','GTM');
-INSERT INTO country VALUES (90,'Guinea','GN','GIN');
-INSERT INTO country VALUES (91,'Guinea-bissau','GW','GNB');
-INSERT INTO country VALUES (92,'Guyana','GY','GUY');
-INSERT INTO country VALUES (93,'Haiti','HT','HTI');
-INSERT INTO country VALUES (94,'Heard and Mc Donald Islands','HM','HMD');
-INSERT INTO country VALUES (95,'Honduras','HN','HND');
-INSERT INTO country VALUES (96,'Hong Kong','HK','HKG');
-INSERT INTO country VALUES (97,'Hungary','HU','HUN');
-INSERT INTO country VALUES (98,'Iceland','IS','ISL');
-INSERT INTO country VALUES (99,'India','IN','IND');
-INSERT INTO country VALUES (100,'Indonesia','ID','IDN');
-INSERT INTO country VALUES (101,'Iran (Islamic Republic of)','IR','IRN');
-INSERT INTO country VALUES (102,'Iraq','IQ','IRQ');
-INSERT INTO country VALUES (103,'Ireland','IE','IRL');
-INSERT INTO country VALUES (104,'Israel','IL','ISR');
-INSERT INTO country VALUES (105,'Italy','IT','ITA');
-INSERT INTO country VALUES (106,'Jamaica','JM','JAM');
-INSERT INTO country VALUES (107,'Japan','JP','JPN');
-INSERT INTO country VALUES (108,'Jordan','JO','JOR');
-INSERT INTO country VALUES (109,'Kazakhstan','KZ','KAZ');
-INSERT INTO country VALUES (110,'Kenya','KE','KEN');
-INSERT INTO country VALUES (111,'Kiribati','KI','KIR');
-INSERT INTO country VALUES (112,'Korea, Democratic People''s Republic of','KP','PRK');
-INSERT INTO country VALUES (113,'Korea, Republic of','KR','KOR');
-INSERT INTO country VALUES (114,'Kuwait','KW','KWT');
-INSERT INTO country VALUES (115,'Kyrgyzstan','KG','KGZ');
-INSERT INTO country VALUES (116,'Lao People''s Democratic Republic','LA','LAO');
-INSERT INTO country VALUES (117,'Latvia','LV','LVA');
-INSERT INTO country VALUES (118,'Lebanon','LB','LBN');
-INSERT INTO country VALUES (119,'Lesotho','LS','LSO');
-INSERT INTO country VALUES (120,'Liberia','LR','LBR');
-INSERT INTO country VALUES (121,'Libyan Arab Jamahiriya','LY','LBY');
-INSERT INTO country VALUES (122,'Liechtenstein','LI','LIE');
-INSERT INTO country VALUES (123,'Lithuania','LT','LTU');
-INSERT INTO country VALUES (124,'Luxembourg','LU','LUX');
-INSERT INTO country VALUES (125,'Macau','MO','MAC');
-INSERT INTO country VALUES (126,'Macedonia, The Former Yugoslav Republic of','MK','MKD');
-INSERT INTO country VALUES (127,'Madagascar','MG','MDG');
-INSERT INTO country VALUES (128,'Malawi','MW','MWI');
-INSERT INTO country VALUES (129,'Malaysia','MY','MYS');
-INSERT INTO country VALUES (130,'Maldives','MV','MDV');
-INSERT INTO country VALUES (131,'Mali','ML','MLI');
-INSERT INTO country VALUES (132,'Malta','MT','MLT');
-INSERT INTO country VALUES (133,'Marshall Islands','MH','MHL');
-INSERT INTO country VALUES (134,'Martinique','MQ','MTQ');
-INSERT INTO country VALUES (135,'Mauritania','MR','MRT');
-INSERT INTO country VALUES (136,'Mauritius','MU','MUS');
-INSERT INTO country VALUES (137,'Mayotte','YT','MYT');
-INSERT INTO country VALUES (138,'Mexico','MX','MEX');
-INSERT INTO country VALUES (139,'Micronesia, Federated States of','FM','FSM');
-INSERT INTO country VALUES (140,'Moldova, Republic of','MD','MDA');
-INSERT INTO country VALUES (141,'Monaco','MC','MCO');
-INSERT INTO country VALUES (142,'Mongolia','MN','MNG');
-INSERT INTO country VALUES (143,'Montserrat','MS','MSR');
-INSERT INTO country VALUES (144,'Morocco','MA','MAR');
-INSERT INTO country VALUES (145,'Mozambique','MZ','MOZ');
-INSERT INTO country VALUES (146,'Myanmar','MM','MMR');
-INSERT INTO country VALUES (147,'Namibia','NA','NAM');
-INSERT INTO country VALUES (148,'Nauru','NR','NRU');
-INSERT INTO country VALUES (149,'Nepal','NP','NPL');
-INSERT INTO country VALUES (150,'Netherlands','NL','NLD');
-INSERT INTO country VALUES (151,'Netherlands Antilles','AN','ANT');
-INSERT INTO country VALUES (152,'New Caledonia','NC','NCL');
-INSERT INTO country VALUES (153,'New Zealand','NZ','NZL');
-INSERT INTO country VALUES (154,'Nicaragua','NI','NIC');
-INSERT INTO country VALUES (155,'Niger','NE','NER');
-INSERT INTO country VALUES (156,'Nigeria','NG','NGA');
-INSERT INTO country VALUES (157,'Niue','NU','NIU');
-INSERT INTO country VALUES (158,'Norfolk Island','NF','NFK');
-INSERT INTO country VALUES (159,'Northern Mariana Islands','MP','MNP');
-INSERT INTO country VALUES (160,'Norway','NO','NOR');
-INSERT INTO country VALUES (161,'Oman','OM','OMN');
-INSERT INTO country VALUES (162,'Pakistan','PK','PAK');
-INSERT INTO country VALUES (163,'Palau','PW','PLW');
-INSERT INTO country VALUES (164,'Panama','PA','PAN');
-INSERT INTO country VALUES (165,'Papua New Guinea','PG','PNG');
-INSERT INTO country VALUES (166,'Paraguay','PY','PRY');
-INSERT INTO country VALUES (167,'Peru','PE','PER');
-INSERT INTO country VALUES (168,'Philippines','PH','PHL');
-INSERT INTO country VALUES (169,'Pitcairn','PN','PCN');
-INSERT INTO country VALUES (170,'Poland','PL','POL');
-INSERT INTO country VALUES (171,'Portugal','PT','PRT');
-INSERT INTO country VALUES (172,'Puerto Rico','PR','PRI');
-INSERT INTO country VALUES (173,'Qatar','QA','QAT');
-INSERT INTO country VALUES (174,'Reunion','RE','REU');
-INSERT INTO country VALUES (175,'Romania','RO','ROM');
-INSERT INTO country VALUES (176,'Russian Federation','RU','RUS');
-INSERT INTO country VALUES (177,'Rwanda','RW','RWA');
-INSERT INTO country VALUES (178,'Saint Kitts and Nevis','KN','KNA');
-INSERT INTO country VALUES (179,'Saint Lucia','LC','LCA');
-INSERT INTO country VALUES (180,'Saint Vincent and the Grenadines','VC','VCT');
-INSERT INTO country VALUES (181,'Samoa','WS','WSM');
-INSERT INTO country VALUES (182,'San Marino','SM','SMR');
-INSERT INTO country VALUES (183,'Sao Tome and Principe','ST','STP');
-INSERT INTO country VALUES (184,'Saudi Arabia','SA','SAU');
-INSERT INTO country VALUES (185,'Senegal','SN','SEN');
-INSERT INTO country VALUES (186,'Seychelles','SC','SYC');
-INSERT INTO country VALUES (187,'Sierra Leone','SL','SLE');
-INSERT INTO country VALUES (188,'Singapore','SG','SGP');
-INSERT INTO country VALUES (189,'Slovakia (Slovak Republic)','SK','SVK');
-INSERT INTO country VALUES (190,'Slovenia','SI','SVN');
-INSERT INTO country VALUES (191,'Solomon Islands','SB','SLB');
-INSERT INTO country VALUES (192,'Somalia','SO','SOM');
-INSERT INTO country VALUES (193,'South Africa','ZA','ZAF');
-INSERT INTO country VALUES (194,'South Georgia and the South Sandwich Islands','GS','SGS');
-INSERT INTO country VALUES (195,'Spain','ES','ESP');
-INSERT INTO country VALUES (196,'Sri Lanka','LK','LKA');
-INSERT INTO country VALUES (197,'St. Helena','SH','SHN');
-INSERT INTO country VALUES (198,'St. Pierre and Miquelon','PM','SPM');
-INSERT INTO country VALUES (199,'Sudan','SD','SDN');
-INSERT INTO country VALUES (200,'Suriname','SR','SUR');
-INSERT INTO country VALUES (201,'Svalbard and Jan Mayen Islands','SJ','SJM');
-INSERT INTO country VALUES (202,'Swaziland','SZ','SWZ');
-INSERT INTO country VALUES (203,'Sweden','SE','SWE');
-INSERT INTO country VALUES (204,'Switzerland','CH','CHE');
-INSERT INTO country VALUES (205,'Syrian Arab Republic','SY','SYR');
-INSERT INTO country VALUES (206,'Taiwan','TW','TWN');
-INSERT INTO country VALUES (207,'Tajikistan','TJ','TJK');
-INSERT INTO country VALUES (208,'Tanzania, United Republic of','TZ','TZA');
-INSERT INTO country VALUES (209,'Thailand','TH','THA');
-INSERT INTO country VALUES (210,'Togo','TG','TGO');
-INSERT INTO country VALUES (211,'Tokelau','TK','TKL');
-INSERT INTO country VALUES (212,'Tonga','TO','TON');
-INSERT INTO country VALUES (213,'Trinidad and Tobago','TT','TTO');
-INSERT INTO country VALUES (214,'Tunisia','TN','TUN');
-INSERT INTO country VALUES (215,'Turkey','TR','TUR');
-INSERT INTO country VALUES (216,'Turkmenistan','TM','TKM');
-INSERT INTO country VALUES (217,'Turks and Caicos Islands','TC','TCA');
-INSERT INTO country VALUES (218,'Tuvalu','TV','TUV');
-INSERT INTO country VALUES (219,'Uganda','UG','UGA');
-INSERT INTO country VALUES (220,'Ukraine','UA','UKR');
-INSERT INTO country VALUES (221,'United Arab Emirates','AE','ARE');
-INSERT INTO country VALUES (222,'United Kingdom','GB','GBR');
-INSERT INTO country VALUES (223,'United States','US','USA');
-INSERT INTO country VALUES (224,'United States Minor Outlying Islands','UM','UMI');
-INSERT INTO country VALUES (225,'Uruguay','UY','URY');
-INSERT INTO country VALUES (226,'Uzbekistan','UZ','UZB');
-INSERT INTO country VALUES (227,'Vanuatu','VU','VUT');
-INSERT INTO country VALUES (228,'Vatican City State (Holy See)','VA','VAT');
-INSERT INTO country VALUES (229,'Venezuela','VE','VEN');
-INSERT INTO country VALUES (230,'Viet Nam','VN','VNM');
-INSERT INTO country VALUES (231,'Virgin Islands (British)','VG','VGB');
-INSERT INTO country VALUES (232,'Virgin Islands (U.S.)','VI','VIR');
-INSERT INTO country VALUES (233,'Wallis and Futuna Islands','WF','WLF');
-INSERT INTO country VALUES (234,'Western Sahara','EH','ESH');
-INSERT INTO country VALUES (235,'Yemen','YE','YEM');
-INSERT INTO country VALUES (236,'Yugoslavia','YU','YUG');
-INSERT INTO country VALUES (237,'Zaire','ZR','ZAR');
-INSERT INTO country VALUES (238,'Zambia','ZM','ZMB');
-INSERT INTO country VALUES (239,'Zimbabwe','ZW','ZWE');
+INSERT INTO COUNTRY VALUES (1,'Afghanistan','AF','AFG');
+INSERT INTO COUNTRY VALUES (2,'Albania','AL','ALB');
+INSERT INTO COUNTRY VALUES (3,'Algeria','DZ','DZA');
+INSERT INTO COUNTRY VALUES (4,'American Samoa','AS','ASM');
+INSERT INTO COUNTRY VALUES (5,'Andorra','AD','AND');
+INSERT INTO COUNTRY VALUES (6,'Angola','AO','AGO');
+INSERT INTO COUNTRY VALUES (7,'Anguilla','AI','AIA');
+INSERT INTO COUNTRY VALUES (8,'Antarctica','AQ','ATA');
+INSERT INTO COUNTRY VALUES (9,'Antigua and Barbuda','AG','ATG');
+INSERT INTO COUNTRY VALUES (10,'Argentina','AR','ARG');
+INSERT INTO COUNTRY VALUES (11,'Armenia','AM','ARM');
+INSERT INTO COUNTRY VALUES (12,'Aruba','AW','ABW');
+INSERT INTO COUNTRY VALUES (13,'Australia','AU','AUS');
+INSERT INTO COUNTRY VALUES (14,'Austria','AT','AUT');
+INSERT INTO COUNTRY VALUES (15,'Azerbaijan','AZ','AZE');
+INSERT INTO COUNTRY VALUES (16,'Bahamas','BS','BHS');
+INSERT INTO COUNTRY VALUES (17,'Bahrain','BH','BHR');
+INSERT INTO COUNTRY VALUES (18,'Bangladesh','BD','BGD');
+INSERT INTO COUNTRY VALUES (19,'Barbados','BB','BRB');
+INSERT INTO COUNTRY VALUES (20,'Belarus','BY','BLR');
+INSERT INTO COUNTRY VALUES (21,'Belgium','BE','BEL');
+INSERT INTO COUNTRY VALUES (22,'Belize','BZ','BLZ');
+INSERT INTO COUNTRY VALUES (23,'Benin','BJ','BEN');
+INSERT INTO COUNTRY VALUES (24,'Bermuda','BM','BMU');
+INSERT INTO COUNTRY VALUES (25,'Bhutan','BT','BTN');
+INSERT INTO COUNTRY VALUES (26,'Bolivia','BO','BOL');
+INSERT INTO COUNTRY VALUES (27,'Bosnia and Herzegowina','BA','BIH');
+INSERT INTO COUNTRY VALUES (28,'Botswana','BW','BWA');
+INSERT INTO COUNTRY VALUES (29,'Bouvet Island','BV','BVT');
+INSERT INTO COUNTRY VALUES (30,'Brazil','BR','BRA');
+INSERT INTO COUNTRY VALUES (31,'British Indian Ocean Territory','IO','IOT');
+INSERT INTO COUNTRY VALUES (32,'Brunei Darussalam','BN','BRN');
+INSERT INTO COUNTRY VALUES (33,'Bulgaria','BG','BGR');
+INSERT INTO COUNTRY VALUES (34,'Burkina Faso','BF','BFA');
+INSERT INTO COUNTRY VALUES (35,'Burundi','BI','BDI');
+INSERT INTO COUNTRY VALUES (36,'Cambodia','KH','KHM');
+INSERT INTO COUNTRY VALUES (37,'Cameroon','CM','CMR');
+INSERT INTO COUNTRY VALUES (38,'Canada','CA','CAN');
+INSERT INTO COUNTRY VALUES (39,'Cape Verde','CV','CPV');
+INSERT INTO COUNTRY VALUES (40,'Cayman Islands','KY','CYM');
+INSERT INTO COUNTRY VALUES (41,'Central African Republic','CF','CAF');
+INSERT INTO COUNTRY VALUES (42,'Chad','TD','TCD');
+INSERT INTO COUNTRY VALUES (43,'Chile','CL','CHL');
+INSERT INTO COUNTRY VALUES (44,'China','CN','CHN');
+INSERT INTO COUNTRY VALUES (45,'Christmas Island','CX','CXR');
+INSERT INTO COUNTRY VALUES (46,'Cocos (Keeling) Islands','CC','CCK');
+INSERT INTO COUNTRY VALUES (47,'Colombia','CO','COL');
+INSERT INTO COUNTRY VALUES (48,'Comoros','KM','COM');
+INSERT INTO COUNTRY VALUES (49,'Congo','CG','COG');
+INSERT INTO COUNTRY VALUES (50,'Cook Islands','CK','COK');
+INSERT INTO COUNTRY VALUES (51,'Costa Rica','CR','CRI');
+INSERT INTO COUNTRY VALUES (52,'Cote D''Ivoire','CI','CIV');
+INSERT INTO COUNTRY VALUES (53,'Croatia','HR','HRV');
+INSERT INTO COUNTRY VALUES (54,'Cuba','CU','CUB');
+INSERT INTO COUNTRY VALUES (55,'Cyprus','CY','CYP');
+INSERT INTO COUNTRY VALUES (56,'Czech Republic','CZ','CZE');
+INSERT INTO COUNTRY VALUES (57,'Denmark','DK','DNK');
+INSERT INTO COUNTRY VALUES (58,'Djibouti','DJ','DJI');
+INSERT INTO COUNTRY VALUES (59,'Dominica','DM','DMA');
+INSERT INTO COUNTRY VALUES (60,'Dominican Republic','DO','DOM');
+INSERT INTO COUNTRY VALUES (61,'East Timor','TP','TMP');
+INSERT INTO COUNTRY VALUES (62,'Ecuador','EC','ECU');
+INSERT INTO COUNTRY VALUES (63,'Egypt','EG','EGY');
+INSERT INTO COUNTRY VALUES (64,'El Salvador','SV','SLV');
+INSERT INTO COUNTRY VALUES (65,'Equatorial Guinea','GQ','GNQ');
+INSERT INTO COUNTRY VALUES (66,'Eritrea','ER','ERI');
+INSERT INTO COUNTRY VALUES (67,'Estonia','EE','EST');
+INSERT INTO COUNTRY VALUES (68,'Ethiopia','ET','ETH');
+INSERT INTO COUNTRY VALUES (69,'Falkland Islands (Malvinas)','FK','FLK');
+INSERT INTO COUNTRY VALUES (70,'Faroe Islands','FO','FRO');
+INSERT INTO COUNTRY VALUES (71,'Fiji','FJ','FJI');
+INSERT INTO COUNTRY VALUES (72,'Finland','FI','FIN');
+INSERT INTO COUNTRY VALUES (73,'France','FR','FRA');
+INSERT INTO COUNTRY VALUES (74,'France, Metropolitan','FX','FXX');
+INSERT INTO COUNTRY VALUES (75,'French Guiana','GF','GUF');
+INSERT INTO COUNTRY VALUES (76,'French Polynesia','PF','PYF');
+INSERT INTO COUNTRY VALUES (77,'French Southern Territories','TF','ATF');
+INSERT INTO COUNTRY VALUES (78,'Gabon','GA','GAB');
+INSERT INTO COUNTRY VALUES (79,'Gambia','GM','GMB');
+INSERT INTO COUNTRY VALUES (80,'Georgia','GE','GEO');
+INSERT INTO COUNTRY VALUES (81,'Germany','DE','DEU');
+INSERT INTO COUNTRY VALUES (82,'Ghana','GH','GHA');
+INSERT INTO COUNTRY VALUES (83,'Gibraltar','GI','GIB');
+INSERT INTO COUNTRY VALUES (84,'Greece','GR','GRC');
+INSERT INTO COUNTRY VALUES (85,'Greenland','GL','GRL');
+INSERT INTO COUNTRY VALUES (86,'Grenada','GD','GRD');
+INSERT INTO COUNTRY VALUES (87,'Guadeloupe','GP','GLP');
+INSERT INTO COUNTRY VALUES (88,'Guam','GU','GUM');
+INSERT INTO COUNTRY VALUES (89,'Guatemala','GT','GTM');
+INSERT INTO COUNTRY VALUES (90,'Guinea','GN','GIN');
+INSERT INTO COUNTRY VALUES (91,'Guinea-bissau','GW','GNB');
+INSERT INTO COUNTRY VALUES (92,'Guyana','GY','GUY');
+INSERT INTO COUNTRY VALUES (93,'Haiti','HT','HTI');
+INSERT INTO COUNTRY VALUES (94,'Heard and Mc Donald Islands','HM','HMD');
+INSERT INTO COUNTRY VALUES (95,'Honduras','HN','HND');
+INSERT INTO COUNTRY VALUES (96,'Hong Kong','HK','HKG');
+INSERT INTO COUNTRY VALUES (97,'Hungary','HU','HUN');
+INSERT INTO COUNTRY VALUES (98,'Iceland','IS','ISL');
+INSERT INTO COUNTRY VALUES (99,'India','IN','IND');
+INSERT INTO COUNTRY VALUES (100,'Indonesia','ID','IDN');
+INSERT INTO COUNTRY VALUES (101,'Iran (Islamic Republic of)','IR','IRN');
+INSERT INTO COUNTRY VALUES (102,'Iraq','IQ','IRQ');
+INSERT INTO COUNTRY VALUES (103,'Ireland','IE','IRL');
+INSERT INTO COUNTRY VALUES (104,'Israel','IL','ISR');
+INSERT INTO COUNTRY VALUES (105,'Italy','IT','ITA');
+INSERT INTO COUNTRY VALUES (106,'Jamaica','JM','JAM');
+INSERT INTO COUNTRY VALUES (107,'Japan','JP','JPN');
+INSERT INTO COUNTRY VALUES (108,'Jordan','JO','JOR');
+INSERT INTO COUNTRY VALUES (109,'Kazakhstan','KZ','KAZ');
+INSERT INTO COUNTRY VALUES (110,'Kenya','KE','KEN');
+INSERT INTO COUNTRY VALUES (111,'Kiribati','KI','KIR');
+INSERT INTO COUNTRY VALUES (112,'Korea, Democratic People''s Republic of','KP','PRK');
+INSERT INTO COUNTRY VALUES (113,'Korea, Republic of','KR','KOR');
+INSERT INTO COUNTRY VALUES (114,'Kuwait','KW','KWT');
+INSERT INTO COUNTRY VALUES (115,'Kyrgyzstan','KG','KGZ');
+INSERT INTO COUNTRY VALUES (116,'Lao People''s Democratic Republic','LA','LAO');
+INSERT INTO COUNTRY VALUES (117,'Latvia','LV','LVA');
+INSERT INTO COUNTRY VALUES (118,'Lebanon','LB','LBN');
+INSERT INTO COUNTRY VALUES (119,'Lesotho','LS','LSO');
+INSERT INTO COUNTRY VALUES (120,'Liberia','LR','LBR');
+INSERT INTO COUNTRY VALUES (121,'Libyan Arab Jamahiriya','LY','LBY');
+INSERT INTO COUNTRY VALUES (122,'Liechtenstein','LI','LIE');
+INSERT INTO COUNTRY VALUES (123,'Lithuania','LT','LTU');
+INSERT INTO COUNTRY VALUES (124,'Luxembourg','LU','LUX');
+INSERT INTO COUNTRY VALUES (125,'Macau','MO','MAC');
+INSERT INTO COUNTRY VALUES (126,'Macedonia, The Former Yugoslav Republic of','MK','MKD');
+INSERT INTO COUNTRY VALUES (127,'Madagascar','MG','MDG');
+INSERT INTO COUNTRY VALUES (128,'Malawi','MW','MWI');
+INSERT INTO COUNTRY VALUES (129,'Malaysia','MY','MYS');
+INSERT INTO COUNTRY VALUES (130,'Maldives','MV','MDV');
+INSERT INTO COUNTRY VALUES (131,'Mali','ML','MLI');
+INSERT INTO COUNTRY VALUES (132,'Malta','MT','MLT');
+INSERT INTO COUNTRY VALUES (133,'Marshall Islands','MH','MHL');
+INSERT INTO COUNTRY VALUES (134,'Martinique','MQ','MTQ');
+INSERT INTO COUNTRY VALUES (135,'Mauritania','MR','MRT');
+INSERT INTO COUNTRY VALUES (136,'Mauritius','MU','MUS');
+INSERT INTO COUNTRY VALUES (137,'Mayotte','YT','MYT');
+INSERT INTO COUNTRY VALUES (138,'Mexico','MX','MEX');
+INSERT INTO COUNTRY VALUES (139,'Micronesia, Federated States of','FM','FSM');
+INSERT INTO COUNTRY VALUES (140,'Moldova, Republic of','MD','MDA');
+INSERT INTO COUNTRY VALUES (141,'Monaco','MC','MCO');
+INSERT INTO COUNTRY VALUES (142,'Mongolia','MN','MNG');
+INSERT INTO COUNTRY VALUES (143,'Montserrat','MS','MSR');
+INSERT INTO COUNTRY VALUES (144,'Morocco','MA','MAR');
+INSERT INTO COUNTRY VALUES (145,'Mozambique','MZ','MOZ');
+INSERT INTO COUNTRY VALUES (146,'Myanmar','MM','MMR');
+INSERT INTO COUNTRY VALUES (147,'Namibia','NA','NAM');
+INSERT INTO COUNTRY VALUES (148,'Nauru','NR','NRU');
+INSERT INTO COUNTRY VALUES (149,'Nepal','NP','NPL');
+INSERT INTO COUNTRY VALUES (150,'Netherlands','NL','NLD');
+INSERT INTO COUNTRY VALUES (151,'Netherlands Antilles','AN','ANT');
+INSERT INTO COUNTRY VALUES (152,'New Caledonia','NC','NCL');
+INSERT INTO COUNTRY VALUES (153,'New Zealand','NZ','NZL');
+INSERT INTO COUNTRY VALUES (154,'Nicaragua','NI','NIC');
+INSERT INTO COUNTRY VALUES (155,'Niger','NE','NER');
+INSERT INTO COUNTRY VALUES (156,'Nigeria','NG','NGA');
+INSERT INTO COUNTRY VALUES (157,'Niue','NU','NIU');
+INSERT INTO COUNTRY VALUES (158,'Norfolk Island','NF','NFK');
+INSERT INTO COUNTRY VALUES (159,'Northern Mariana Islands','MP','MNP');
+INSERT INTO COUNTRY VALUES (160,'Norway','NO','NOR');
+INSERT INTO COUNTRY VALUES (161,'Oman','OM','OMN');
+INSERT INTO COUNTRY VALUES (162,'Pakistan','PK','PAK');
+INSERT INTO COUNTRY VALUES (163,'Palau','PW','PLW');
+INSERT INTO COUNTRY VALUES (164,'Panama','PA','PAN');
+INSERT INTO COUNTRY VALUES (165,'Papua New Guinea','PG','PNG');
+INSERT INTO COUNTRY VALUES (166,'Paraguay','PY','PRY');
+INSERT INTO COUNTRY VALUES (167,'Peru','PE','PER');
+INSERT INTO COUNTRY VALUES (168,'Philippines','PH','PHL');
+INSERT INTO COUNTRY VALUES (169,'Pitcairn','PN','PCN');
+INSERT INTO COUNTRY VALUES (170,'Poland','PL','POL');
+INSERT INTO COUNTRY VALUES (171,'Portugal','PT','PRT');
+INSERT INTO COUNTRY VALUES (172,'Puerto Rico','PR','PRI');
+INSERT INTO COUNTRY VALUES (173,'Qatar','QA','QAT');
+INSERT INTO COUNTRY VALUES (174,'Reunion','RE','REU');
+INSERT INTO COUNTRY VALUES (175,'Romania','RO','ROM');
+INSERT INTO COUNTRY VALUES (176,'Russian Federation','RU','RUS');
+INSERT INTO COUNTRY VALUES (177,'Rwanda','RW','RWA');
+INSERT INTO COUNTRY VALUES (178,'Saint Kitts and Nevis','KN','KNA');
+INSERT INTO COUNTRY VALUES (179,'Saint Lucia','LC','LCA');
+INSERT INTO COUNTRY VALUES (180,'Saint Vincent and the Grenadines','VC','VCT');
+INSERT INTO COUNTRY VALUES (181,'Samoa','WS','WSM');
+INSERT INTO COUNTRY VALUES (182,'San Marino','SM','SMR');
+INSERT INTO COUNTRY VALUES (183,'Sao Tome and Principe','ST','STP');
+INSERT INTO COUNTRY VALUES (184,'Saudi Arabia','SA','SAU');
+INSERT INTO COUNTRY VALUES (185,'Senegal','SN','SEN');
+INSERT INTO COUNTRY VALUES (186,'Seychelles','SC','SYC');
+INSERT INTO COUNTRY VALUES (187,'Sierra Leone','SL','SLE');
+INSERT INTO COUNTRY VALUES (188,'Singapore','SG','SGP');
+INSERT INTO COUNTRY VALUES (189,'Slovakia (Slovak Republic)','SK','SVK');
+INSERT INTO COUNTRY VALUES (190,'Slovenia','SI','SVN');
+INSERT INTO COUNTRY VALUES (191,'Solomon Islands','SB','SLB');
+INSERT INTO COUNTRY VALUES (192,'Somalia','SO','SOM');
+INSERT INTO COUNTRY VALUES (193,'South Africa','ZA','ZAF');
+INSERT INTO COUNTRY VALUES (194,'South Georgia and the South Sandwich Islands','GS','SGS');
+INSERT INTO COUNTRY VALUES (195,'Spain','ES','ESP');
+INSERT INTO COUNTRY VALUES (196,'Sri Lanka','LK','LKA');
+INSERT INTO COUNTRY VALUES (197,'St. Helena','SH','SHN');
+INSERT INTO COUNTRY VALUES (198,'St. Pierre and Miquelon','PM','SPM');
+INSERT INTO COUNTRY VALUES (199,'Sudan','SD','SDN');
+INSERT INTO COUNTRY VALUES (200,'Suriname','SR','SUR');
+INSERT INTO COUNTRY VALUES (201,'Svalbard and Jan Mayen Islands','SJ','SJM');
+INSERT INTO COUNTRY VALUES (202,'Swaziland','SZ','SWZ');
+INSERT INTO COUNTRY VALUES (203,'Sweden','SE','SWE');
+INSERT INTO COUNTRY VALUES (204,'Switzerland','CH','CHE');
+INSERT INTO COUNTRY VALUES (205,'Syrian Arab Republic','SY','SYR');
+INSERT INTO COUNTRY VALUES (206,'Taiwan','TW','TWN');
+INSERT INTO COUNTRY VALUES (207,'Tajikistan','TJ','TJK');
+INSERT INTO COUNTRY VALUES (208,'Tanzania, United Republic of','TZ','TZA');
+INSERT INTO COUNTRY VALUES (209,'Thailand','TH','THA');
+INSERT INTO COUNTRY VALUES (210,'Togo','TG','TGO');
+INSERT INTO COUNTRY VALUES (211,'Tokelau','TK','TKL');
+INSERT INTO COUNTRY VALUES (212,'Tonga','TO','TON');
+INSERT INTO COUNTRY VALUES (213,'Trinidad and Tobago','TT','TTO');
+INSERT INTO COUNTRY VALUES (214,'Tunisia','TN','TUN');
+INSERT INTO COUNTRY VALUES (215,'Turkey','TR','TUR');
+INSERT INTO COUNTRY VALUES (216,'Turkmenistan','TM','TKM');
+INSERT INTO COUNTRY VALUES (217,'Turks and Caicos Islands','TC','TCA');
+INSERT INTO COUNTRY VALUES (218,'Tuvalu','TV','TUV');
+INSERT INTO COUNTRY VALUES (219,'Uganda','UG','UGA');
+INSERT INTO COUNTRY VALUES (220,'Ukraine','UA','UKR');
+INSERT INTO COUNTRY VALUES (221,'United Arab Emirates','AE','ARE');
+INSERT INTO COUNTRY VALUES (222,'United Kingdom','GB','GBR');
+INSERT INTO COUNTRY VALUES (223,'United States','US','USA');
+INSERT INTO COUNTRY VALUES (224,'United States Minor Outlying Islands','UM','UMI');
+INSERT INTO COUNTRY VALUES (225,'Uruguay','UY','URY');
+INSERT INTO COUNTRY VALUES (226,'Uzbekistan','UZ','UZB');
+INSERT INTO COUNTRY VALUES (227,'Vanuatu','VU','VUT');
+INSERT INTO COUNTRY VALUES (228,'Vatican City State (Holy See)','VA','VAT');
+INSERT INTO COUNTRY VALUES (229,'Venezuela','VE','VEN');
+INSERT INTO COUNTRY VALUES (230,'Viet Nam','VN','VNM');
+INSERT INTO COUNTRY VALUES (231,'Virgin Islands (British)','VG','VGB');
+INSERT INTO COUNTRY VALUES (232,'Virgin Islands (U.S.)','VI','VIR');
+INSERT INTO COUNTRY VALUES (233,'Wallis and Futuna Islands','WF','WLF');
+INSERT INTO COUNTRY VALUES (234,'Western Sahara','EH','ESH');
+INSERT INTO COUNTRY VALUES (235,'Yemen','YE','YEM');
+INSERT INTO COUNTRY VALUES (236,'Yugoslavia','YU','YUG');
+INSERT INTO COUNTRY VALUES (237,'Zaire','ZR','ZAR');
+INSERT INTO COUNTRY VALUES (238,'Zambia','ZM','ZMB');
+INSERT INTO COUNTRY VALUES (239,'Zimbabwe','ZW','ZWE');
-INSERT INTO currency VALUES (1,'YEN','','円','###,###','2007-01-01 00:00:00','2007-01-01 00:00:00');
-INSERT INTO currency VALUES (2,'USD','$','','###,###.##','2007-01-01 00:00:00','2007-01-01 00:00:00');
+INSERT INTO CURRENCY VALUES (1,'YEN','','円','###,###','2007-01-01 00:00:00','2007-01-01 00:00:00');
+INSERT INTO CURRENCY VALUES (2,'USD','$','','###,###.##','2007-01-01 00:00:00','2007-01-01 00:00:00');
-INSERT INTO currency_description VALUES (1,1,'Japanese Yen','');
-INSERT INTO currency_description VALUES (2,2,'US Dollar','');
+INSERT INTO CURRENCY_DESCRIPTION VALUES (1,1,'Japanese Yen','');
+INSERT INTO CURRENCY_DESCRIPTION VALUES (2,2,'US Dollar','');
-INSERT INTO order_status VALUES ( 1 ,1,'2007-01-01 00:00:00','2007-01-01 00:00:00');
-INSERT INTO order_status VALUES ( 2 ,2,'2007-01-01 00:00:00','2007-01-01 00:00:00');
-INSERT INTO order_status VALUES ( 3 ,3,'2007-01-01 00:00:00','2007-01-01 00:00:00');
+INSERT INTO ORDER_STATUS VALUES ( 1 ,1,'2007-01-01 00:00:00','2007-01-01 00:00:00');
+INSERT INTO ORDER_STATUS VALUES ( 2 ,2,'2007-01-01 00:00:00','2007-01-01 00:00:00');
+INSERT INTO ORDER_STATUS VALUES ( 3 ,3,'2007-01-01 00:00:00','2007-01-01 00:00:00');
-INSERT INTO order_status_description VALUES ( 1, 2, 'Pending','');
-INSERT INTO order_status_description VALUES ( 1, 1, '保留','');
-INSERT INTO order_status_description VALUES ( 2, 2, 'Processing','');
-INSERT INTO order_status_description VALUES ( 2, 1, '処理中','');
-INSERT INTO order_status_description VALUES ( 3, 2, 'Delivered','');
-INSERT INTO order_status_description VALUES ( 3, 1, '配達済み','');
+INSERT INTO ORDER_STATUS_DESCRIPTION VALUES ( 1, 2, 'Pending','');
+INSERT INTO ORDER_STATUS_DESCRIPTION VALUES ( 1, 1, '保留','');
+INSERT INTO ORDER_STATUS_DESCRIPTION VALUES ( 2, 2, 'Processing','');
+INSERT INTO ORDER_STATUS_DESCRIPTION VALUES ( 2, 1, '処理中','');
+INSERT INTO ORDER_STATUS_DESCRIPTION VALUES ( 3, 2, 'Delivered','');
+INSERT INTO ORDER_STATUS_DESCRIPTION VALUES ( 3, 1, '配達済み','');
-- USA
-INSERT INTO zone VALUES (1,223,'AL','Alabama');
-INSERT INTO zone VALUES (2,223,'AK','Alaska');
-INSERT INTO zone VALUES (3,223,'AS','American Samoa');
-INSERT INTO zone VALUES (4,223,'AZ','Arizona');
-INSERT INTO zone VALUES (5,223,'AR','Arkansas');
-INSERT INTO zone VALUES (6,223,'AF','Armed Forces Africa');
-INSERT INTO zone VALUES (7,223,'AA','Armed Forces Americas');
-INSERT INTO zone VALUES (8,223,'AC','Armed Forces Canada');
-INSERT INTO zone VALUES (9,223,'AE','Armed Forces Europe');
-INSERT INTO zone VALUES (10,223,'AM','Armed Forces Middle East');
-INSERT INTO zone VALUES (11,223,'AP','Armed Forces Pacific');
-INSERT INTO zone VALUES (12,223,'CA','California');
-INSERT INTO zone VALUES (13,223,'CO','Colorado');
-INSERT INTO zone VALUES (14,223,'CT','Connecticut');
-INSERT INTO zone VALUES (15,223,'DE','Delaware');
-INSERT INTO zone VALUES (16,223,'DC','District of Columbia');
-INSERT INTO zone VALUES (17,223,'FM','Federated States Of Micronesia');
-INSERT INTO zone VALUES (18,223,'FL','Florida');
-INSERT INTO zone VALUES (19,223,'GA','Georgia');
-INSERT INTO zone VALUES (20,223,'GU','Guam');
-INSERT INTO zone VALUES (21,223,'HI','Hawaii');
-INSERT INTO zone VALUES (22,223,'ID','Idaho');
-INSERT INTO zone VALUES (23,223,'IL','Illinois');
-INSERT INTO zone VALUES (24,223,'IN','Indiana');
-INSERT INTO zone VALUES (25,223,'IA','Iowa');
-INSERT INTO zone VALUES (26,223,'KS','Kansas');
-INSERT INTO zone VALUES (27,223,'KY','Kentucky');
-INSERT INTO zone VALUES (28,223,'LA','Louisiana');
-INSERT INTO zone VALUES (29,223,'ME','Maine');
-INSERT INTO zone VALUES (30,223,'MH','Marshall Islands');
-INSERT INTO zone VALUES (31,223,'MD','Maryland');
-INSERT INTO zone VALUES (32,223,'MA','Massachusetts');
-INSERT INTO zone VALUES (33,223,'MI','Michigan');
-INSERT INTO zone VALUES (34,223,'MN','Minnesota');
-INSERT INTO zone VALUES (35,223,'MS','Mississippi');
-INSERT INTO zone VALUES (36,223,'MO','Missouri');
-INSERT INTO zone VALUES (37,223,'MT','Montana');
-INSERT INTO zone VALUES (38,223,'NE','Nebraska');
-INSERT INTO zone VALUES (39,223,'NV','Nevada');
-INSERT INTO zone VALUES (40,223,'NH','New Hampshire');
-INSERT INTO zone VALUES (41,223,'NJ','New Jersey');
-INSERT INTO zone VALUES (42,223,'NM','New Mexico');
-INSERT INTO zone VALUES (43,223,'NY','New York');
-INSERT INTO zone VALUES (44,223,'NC','North Carolina');
-INSERT INTO zone VALUES (45,223,'ND','North Dakota');
-INSERT INTO zone VALUES (46,223,'MP','Northern Mariana Islands');
-INSERT INTO zone VALUES (47,223,'OH','Ohio');
-INSERT INTO zone VALUES (48,223,'OK','Oklahoma');
-INSERT INTO zone VALUES (49,223,'OR','Oregon');
-INSERT INTO zone VALUES (50,223,'PW','Palau');
-INSERT INTO zone VALUES (51,223,'PA','Pennsylvania');
-INSERT INTO zone VALUES (52,223,'PR','Puerto Rico');
-INSERT INTO zone VALUES (53,223,'RI','Rhode Island');
-INSERT INTO zone VALUES (54,223,'SC','South Carolina');
-INSERT INTO zone VALUES (55,223,'SD','South Dakota');
-INSERT INTO zone VALUES (56,223,'TN','Tennessee');
-INSERT INTO zone VALUES (57,223,'TX','Texas');
-INSERT INTO zone VALUES (58,223,'UT','Utah');
-INSERT INTO zone VALUES (59,223,'VT','Vermont');
-INSERT INTO zone VALUES (60,223,'VI','Virgin Islands');
-INSERT INTO zone VALUES (61,223,'VA','Virginia');
-INSERT INTO zone VALUES (62,223,'WA','Washington');
-INSERT INTO zone VALUES (63,223,'WV','West Virginia');
-INSERT INTO zone VALUES (64,223,'WI','Wisconsin');
-INSERT INTO zone VALUES (65,223,'WY','Wyoming');
+INSERT INTO ZONE VALUES (1,223,'AL','Alabama');
+INSERT INTO ZONE VALUES (2,223,'AK','Alaska');
+INSERT INTO ZONE VALUES (3,223,'AS','American Samoa');
+INSERT INTO ZONE VALUES (4,223,'AZ','Arizona');
+INSERT INTO ZONE VALUES (5,223,'AR','Arkansas');
+INSERT INTO ZONE VALUES (6,223,'AF','Armed Forces Africa');
+INSERT INTO ZONE VALUES (7,223,'AA','Armed Forces Americas');
+INSERT INTO ZONE VALUES (8,223,'AC','Armed Forces Canada');
+INSERT INTO ZONE VALUES (9,223,'AE','Armed Forces Europe');
+INSERT INTO ZONE VALUES (10,223,'AM','Armed Forces Middle East');
+INSERT INTO ZONE VALUES (11,223,'AP','Armed Forces Pacific');
+INSERT INTO ZONE VALUES (12,223,'CA','California');
+INSERT INTO ZONE VALUES (13,223,'CO','Colorado');
+INSERT INTO ZONE VALUES (14,223,'CT','Connecticut');
+INSERT INTO ZONE VALUES (15,223,'DE','Delaware');
+INSERT INTO ZONE VALUES (16,223,'DC','District of Columbia');
+INSERT INTO ZONE VALUES (17,223,'FM','Federated States Of Micronesia');
+INSERT INTO ZONE VALUES (18,223,'FL','Florida');
+INSERT INTO ZONE VALUES (19,223,'GA','Georgia');
+INSERT INTO ZONE VALUES (20,223,'GU','Guam');
+INSERT INTO ZONE VALUES (21,223,'HI','Hawaii');
+INSERT INTO ZONE VALUES (22,223,'ID','Idaho');
+INSERT INTO ZONE VALUES (23,223,'IL','Illinois');
+INSERT INTO ZONE VALUES (24,223,'IN','Indiana');
+INSERT INTO ZONE VALUES (25,223,'IA','Iowa');
+INSERT INTO ZONE VALUES (26,223,'KS','Kansas');
+INSERT INTO ZONE VALUES (27,223,'KY','Kentucky');
+INSERT INTO ZONE VALUES (28,223,'LA','Louisiana');
+INSERT INTO ZONE VALUES (29,223,'ME','Maine');
+INSERT INTO ZONE VALUES (30,223,'MH','Marshall Islands');
+INSERT INTO ZONE VALUES (31,223,'MD','Maryland');
+INSERT INTO ZONE VALUES (32,223,'MA','Massachusetts');
+INSERT INTO ZONE VALUES (33,223,'MI','Michigan');
+INSERT INTO ZONE VALUES (34,223,'MN','Minnesota');
+INSERT INTO ZONE VALUES (35,223,'MS','Mississippi');
+INSERT INTO ZONE VALUES (36,223,'MO','Missouri');
+INSERT INTO ZONE VALUES (37,223,'MT','Montana');
+INSERT INTO ZONE VALUES (38,223,'NE','Nebraska');
+INSERT INTO ZONE VALUES (39,223,'NV','Nevada');
+INSERT INTO ZONE VALUES (40,223,'NH','New Hampshire');
+INSERT INTO ZONE VALUES (41,223,'NJ','New Jersey');
+INSERT INTO ZONE VALUES (42,223,'NM','New Mexico');
+INSERT INTO ZONE VALUES (43,223,'NY','New York');
+INSERT INTO ZONE VALUES (44,223,'NC','North Carolina');
+INSERT INTO ZONE VALUES (45,223,'ND','North Dakota');
+INSERT INTO ZONE VALUES (46,223,'MP','Northern Mariana Islands');
+INSERT INTO ZONE VALUES (47,223,'OH','Ohio');
+INSERT INTO ZONE VALUES (48,223,'OK','Oklahoma');
+INSERT INTO ZONE VALUES (49,223,'OR','Oregon');
+INSERT INTO ZONE VALUES (50,223,'PW','Palau');
+INSERT INTO ZONE VALUES (51,223,'PA','Pennsylvania');
+INSERT INTO ZONE VALUES (52,223,'PR','Puerto Rico');
+INSERT INTO ZONE VALUES (53,223,'RI','Rhode Island');
+INSERT INTO ZONE VALUES (54,223,'SC','South Carolina');
+INSERT INTO ZONE VALUES (55,223,'SD','South Dakota');
+INSERT INTO ZONE VALUES (56,223,'TN','Tennessee');
+INSERT INTO ZONE VALUES (57,223,'TX','Texas');
+INSERT INTO ZONE VALUES (58,223,'UT','Utah');
+INSERT INTO ZONE VALUES (59,223,'VT','Vermont');
+INSERT INTO ZONE VALUES (60,223,'VI','Virgin Islands');
+INSERT INTO ZONE VALUES (61,223,'VA','Virginia');
+INSERT INTO ZONE VALUES (62,223,'WA','Washington');
+INSERT INTO ZONE VALUES (63,223,'WV','West Virginia');
+INSERT INTO ZONE VALUES (64,223,'WI','Wisconsin');
+INSERT INTO ZONE VALUES (65,223,'WY','Wyoming');
-INSERT INTO zone VALUES (130,107,'JP','Japan');
+INSERT INTO ZONE VALUES (130,107,'JP','Japan');
-INSERT INTO tax_class VALUES (1, '消費税', '商品・製品の販売やサービスの提供などの取引に対して課税される税金', '2007-01-01 00:00:00', '2007-01-01 00:00:00');
-INSERT INTO tax_class VALUES (2, 'Taxable Goods', 'The following types of products are included non-food, services, etc', '2007-01-01 00:00:00', '2007-01-01 00:00:00');
+INSERT INTO TAX_CLASS VALUES (1, '消費税', '商品・製品の販売やサービスの提供などの取引に対して課税される税金', '2007-01-01 00:00:00', '2007-01-01 00:00:00');
+INSERT INTO TAX_CLASS VALUES (2, 'Taxable Goods', 'The following types of products are included non-food, services, etc', '2007-01-01 00:00:00', '2007-01-01 00:00:00');
-INSERT INTO tax_rate VALUES (1, 1, 1, 1, 7.0, 'FL TAX 7.0%', '2007-01-01 00:00:00', '2007-01-01 00:00:00');
-INSERT INTO tax_rate VALUES (2, 130, 2, 1, 5.0, '税率5.0%', '2007-01-01 00:00:00', '2007-01-01 00:00:00');
+INSERT INTO TAX_RATE VALUES (1, 1, 1, 1, 7.0, 'FL TAX 7.0%', '2007-01-01 00:00:00', '2007-01-01 00:00:00');
+INSERT INTO TAX_RATE VALUES (2, 130, 2, 1, 5.0, '税率5.0%', '2007-01-01 00:00:00', '2007-01-01 00:00:00');
-INSERT INTO category VALUES (0, '', null, 1, '2007-01-01 00:00:00', null);
+INSERT INTO CATEGORY VALUES (1, '', null, 1, '2007-01-01 00:00:00', null);