Changeset 20051 for branches/version-2_5-dev/html

Timestamp:

2011/01/30 18:38:52 (11 years ago)

Author:

Seasoft

Message:

#869(create_date, update_date 列の定義が、表やDBによるバラツキがある) 実装漏れ対応

Location:

branches/version-2_5-dev/html/install/sql

Files:

• create_table_mysql.sql (modified) (2 diffs)
• create_table_pgsql.sql (modified) (1 diff)

branches/version-2_5-dev/html/install/sql/create_table_mysql.sql

@@ -1214 +1214 @@
     param_value text,
     url text,
-    create_date timestamp NOT NULL DEFAULT now()
+    create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
 );
 
@@ -1222 +1222 @@
     token text NOT NULL,
     next_url text NOT NULL,
-    create_date timestamp NOT NULL DEFAULT now(),
+    create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
     email text,
     receive_date timestamp

branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql

@@ -739 +739 @@
     rank int,
     create_date timestamp NOT NULL DEFAULT now(),
-    update_date timestamp,
+    update_date timestamp NOT NULL,
     del_flg smallint NOT NULL DEFAULT 0,
     PRIMARY KEY (shipping_id, order_id)