Changeset 18514

Timestamp:

2010/01/27 21:43:00 (14 years ago)

Author:

Seasoft

Message:

#578(都道府県ID　都道府県マスタと受注で型が異なる)を改修

Location:

branches/comu-ver2/html/install/sql

Files:

• create_table_mysql.sql (modified) (5 diffs)
• create_table_pgsql.sql (modified) (5 diffs)

branches/comu-ver2/html/install/sql/create_table_mysql.sql

@@ -615 +615 @@
     order_zip01 text,
     order_zip02 text,
-    order_pref text,
+    order_pref smallint,
     order_addr01 text,
     order_addr02 text,
@@ -633 +633 @@
     deliv_zip01 text,
     deliv_zip02 text,
-    deliv_pref text,
+    deliv_pref smallint,
     deliv_addr01 text,
     deliv_addr02 text,
@@ -697 +697 @@
     order_zip01 text,
     order_zip02 text,
-    order_pref text,
+    order_pref smallint,
     order_addr01 text,
     order_addr02 text,
@@ -715 +715 @@
     deliv_zip01 text,
     deliv_zip02 text,
-    deliv_pref text,
+    deliv_pref smallint,
     deliv_addr01 text,
     deliv_addr02 text,
@@ -773 +773 @@
     zip01 text,
     zip02 text,
-    pref text,
+    pref smallint,
     addr01 text,
     addr02 text,

branches/comu-ver2/html/install/sql/create_table_pgsql.sql

@@ -616 +616 @@
     order_zip01 text,
     order_zip02 text,
-    order_pref text,
+    order_pref smallint,
     order_addr01 text,
     order_addr02 text,
@@ -634 +634 @@
     deliv_zip01 text,
     deliv_zip02 text,
-    deliv_pref text,
+    deliv_pref smallint,
     deliv_addr01 text,
     deliv_addr02 text,
@@ -698 +698 @@
     order_zip01 text,
     order_zip02 text,
-    order_pref text,
+    order_pref smallint,
     order_addr01 text,
     order_addr02 text,
@@ -716 +716 @@
     deliv_zip01 text,
     deliv_zip02 text,
-    deliv_pref text,
+    deliv_pref smallint,
     deliv_addr01 text,
     deliv_addr02 text,
@@ -774 +774 @@
     zip01 text,
     zip02 text,
-    pref text,
+    pref smallint,
     addr01 text,
     addr02 text,