Changeset 21715

Timestamp:

2012/04/09 02:33:16 (11 years ago)

Author:

Seasoft

Message:

#1718 (カテゴリー・メーカーが多重表示される場合がある)
#1613 (typo修正・ソース整形・ソースコメントの改善)

• 実質的には意味が無いと思うが、他との記述統一の観点で NOT NULL を明記した。

Location:

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

Files:

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

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

@@ -245 +245 @@
 
 CREATE TABLE dtb_send_customer (
-    customer_id int,
+    customer_id int NOT NULL,
     send_id int NOT NULL,
     email text,
@@ -816 +816 @@
     maker_id int NOT NULL,
     product_count int NOT NULL,
-    create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
+    create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    PRIMARY KEY (maker_id)
 );
 

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

@@ -245 +245 @@
 
 CREATE TABLE dtb_send_customer (
-    customer_id int,
+    customer_id int NOT NULL,
     send_id int NOT NULL,
     email text,
@@ -816 +816 @@
     maker_id int NOT NULL,
     product_count int NOT NULL,
-    create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
+    create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    PRIMARY KEY (maker_id)
 );