Changeset 10817 for temp/branches/ec-cube-beta/html/install/sql

Timestamp:

2006/12/17 19:08:02 (19 years ago)

Author:

uehara

Message:

 

File:

• temp/branches/ec-cube-beta/html/install/sql/add/dtb_campaign_order_mysql.sql (modified) (2 diffs)

temp/branches/ec-cube-beta/html/install/sql/add/dtb_campaign_order_mysql.sql

@@ -21 +21 @@
     order_addr01 text,
     order_addr02 text,
-    order_sex int2,
-    order_birth timestamp,
-    order_job int4,
+    order_sex smallint,
+    order_birth datetime,
+    order_job int,
     deliv_name01 text,
     deliv_name02 text,
@@ -43 +43 @@
     cell03 text,
     payment_total numeric,
-    create_date timestamp NOT NULL DEFAULT now()
+    create_date datetime NOT NULL
 ) TYPE=InnoDB ;