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;