Index: branches/version-2_5-dev/html/install/sql/create_table_mysql.sql
===================================================================
--- branches/version-2_5-dev/html/install/sql/create_table_mysql.sql	(revision 20053)
+++ branches/version-2_5-dev/html/install/sql/create_table_mysql.sql	(revision 20054)
@@ -65,5 +65,5 @@
     end_age smallint,
     member smallint,
-    order_date timestamp,
+    order_date datetime,
     create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
 ) ENGINE=InnoDB;
@@ -83,5 +83,5 @@
     create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
     update_date timestamp NOT NULL,
-    release_date timestamp NOT NULL,
+    release_date datetime NOT NULL,
     PRIMARY KEY (module_id)
 ) ENGINE=InnoDB;
@@ -273,6 +273,6 @@
     send_count int,
     complete_count int NOT NULL DEFAULT 0,
-    start_date timestamp,
-    end_date timestamp,
+    start_date datetime,
+    end_date datetime,
     search_data text,
     del_flg smallint NOT NULL DEFAULT 0,
@@ -436,5 +436,5 @@
     total numeric NOT NULL DEFAULT 0,
     total_average numeric NOT NULL DEFAULT 0,
-    order_date timestamp NOT NULL,
+    order_date datetime NOT NULL,
     create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
     year smallint NOT NULL,
@@ -461,5 +461,5 @@
     total_average numeric NOT NULL DEFAULT 0,
     hour smallint NOT NULL DEFAULT 0,
-    order_date timestamp,
+    order_date datetime,
     create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
 ) ENGINE=InnoDB;
@@ -516,5 +516,5 @@
 CREATE TABLE dtb_news (
     news_id int  NOT NULL,
-    news_date timestamp,
+    news_date datetime,
     rank int,
     news_title text NOT NULL,
@@ -547,5 +547,5 @@
     send_id int  NOT NULL,
     order_id int NOT NULL,
-    send_date timestamp,
+    send_date datetime,
     template_id int,
     creator_id int NOT NULL,
@@ -576,5 +576,5 @@
     sex smallint,
     job smallint,
-    birth timestamp,
+    birth datetime,
     password text,
     reminder smallint,
@@ -582,6 +582,6 @@
     salt text,
     secret_key varchar(50) NOT NULL UNIQUE,
-    first_buy_date timestamp,
-    last_buy_date timestamp,
+    first_buy_date datetime,
+    last_buy_date datetime,
     buy_times numeric DEFAULT 0,
     buy_total numeric DEFAULT 0,
@@ -619,5 +619,5 @@
     order_addr02 text,
     order_sex smallint,
-    order_birth timestamp,
+    order_birth datetime,
     order_job int,
     subtotal numeric,
@@ -637,6 +637,6 @@
     create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
     update_date timestamp NOT NULL,
-    commit_date timestamp,
-    payment_date timestamp,
+    commit_date datetime,
+    payment_date datetime,
     device_type_id int,
     del_flg smallint NOT NULL DEFAULT 0,
@@ -675,5 +675,5 @@
     order_addr02 text,
     order_sex smallint,
-    order_birth timestamp,
+    order_birth datetime,
     order_job int,
     subtotal numeric,
@@ -734,6 +734,6 @@
     shipping_time text,
     shipping_num text,
-    shipping_date timestamp,
-    shipping_commit_date timestamp,
+    shipping_date datetime,
+    shipping_commit_date datetime,
     rank int,
     create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
@@ -801,5 +801,5 @@
     create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
     update_date timestamp NOT NULL,
-    login_date timestamp,
+    login_date datetime,
     PRIMARY KEY (member_id)
 ) ENGINE=InnoDB;