Changeset 22693 for branches/camp/camp-2_13-tax

Timestamp:

2013/03/10 09:31:04 (11 years ago)

Author:

yomoro

Message:

インストール時にMySQLで問題が発生するため、若干調整

Location:

branches/camp/camp-2_13-tax/html/install/sql

Files:

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

branches/camp/camp-2_13-tax/html/install/sql/create_table_mysql.sql

@@ -1225 +1225 @@
     tax_rate numeric NOT NULL DEFAULT 5,
     tax_adjust numeric NOT NULL DEFAULT 0,
-    apply_date timestamp,
+    apply_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
     member_id int NOT NULL,
     del_flg smallint NOT NULL DEFAULT 0,
-    create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    create_date timestamp NOT NULL,
     update_date timestamp NOT NULL,
     PRIMARY KEY (tax_rule_id)
 );
-
 
 CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id(255));

branches/camp/camp-2_13-tax/html/install/sql/create_table_pgsql.sql

@@ -1225 +1225 @@
     tax_rate numeric NOT NULL DEFAULT 5,
     tax_adjust numeric NOT NULL DEFAULT 0,
-    apply_date timestamp,
+    apply_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
     member_id int NOT NULL,
     del_flg smallint NOT NULL DEFAULT 0,
-    create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    create_date timestamp NOT NULL,
     update_date timestamp NOT NULL,
     PRIMARY KEY (tax_rule_id)
 );
-
 
 CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id);