Changeset 18632

Timestamp:

2010/05/05 20:34:40 (14 years ago)

Author:

Seasoft

Message:

#715(dtb_send_customer テーブル定義を改善) 実装

Location:

branches/comu-ver2/html/install/sql

Files:

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

branches/comu-ver2/html/install/sql/create_table_mysql.sql

@@ -276 +276 @@
     email text,
     name text,
-    send_flag smallint
+    send_flag smallint,
+    PRIMARY KEY (send_id, customer_id)
 ) TYPE=InnoDB;
 

branches/comu-ver2/html/install/sql/create_table_pgsql.sql

@@ -273 +273 @@
 CREATE TABLE dtb_send_customer (
     customer_id int,
-    send_id serial NOT NULL,
+    send_id int NOT NULL,
     email text,
     name text,
-    send_flag smallint
+    send_flag smallint,
+    PRIMARY KEY (send_id, customer_id)
 );