Changeset 18023 for branches/comu-ver2/html

Timestamp:

2009/05/23 11:23:24 (15 years ago)

Author:

Seasoft

Message:

#472「管理機能の配送業者の追加でエラー」を修正。

Location:

branches/comu-ver2/html/install/sql

Files:

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

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

@@ -161 +161 @@
 CREATE TABLE dtb_delivtime (
     deliv_id int NOT NULL,
-    time_id int auto_increment primary key NOT NULL,
-    deliv_time text NOT NULL
+    time_id int NOT NULL,
+    deliv_time text NOT NULL,
+    PRIMARY KEY (deliv_id, time_id)
 ) TYPE=InnoDB ;
 

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

@@ -165 +165 @@
 CREATE TABLE dtb_delivtime (
     deliv_id int4 NOT NULL,
-    time_id serial NOT NULL,
+    time_id int4 NOT NULL,
     deliv_time text NOT NULL,
-    PRIMARY KEY (time_id)
+    PRIMARY KEY (deliv_id, time_id)
 );
 

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

@@ -310 +310 @@
 INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 47);
 
-INSERT INTO dtb_delivtime (deliv_id, deliv_time) VALUES (1, '午前');
-INSERT INTO dtb_delivtime (deliv_id, deliv_time) VALUES (1, '午後');
+INSERT INTO dtb_delivtime (deliv_id, time_id, deliv_time) VALUES (1, 1, '午前');
+INSERT INTO dtb_delivtime (deliv_id, time_id, deliv_time) VALUES (1, 2, '午後');
 
 INSERT INTO dtb_payment (payment_method,charge,rule,deliv_id,rank,note,fix,status,del_flg,creator_id,create_date,update_date,payment_image,upper_rule) VALUES ('郵便振替', 0, NULL, 1, 4, NULL, 2, 1, 0, 1, now(), now(), NULL, NULL);