Changeset 20110

Timestamp:

2011/02/07 14:10:05 (11 years ago)

Author:

nanasess

bzr:base-revision:

svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:20109

bzr:committer:

Kentaro Ohkouchi <ohkouchi@loop-az.jp>

bzr:file-ids:

html/install/sql/create_table_mysql.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcreate_table_mysql.sql
html/install/sql/create_table_pgsql.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcreate_table_pgsql.sql
html/install/sql/insert_data.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Finsert_data.sql

bzr:mapping-version:

v4

bzr:merge:

ohkouchi@loop-az.jp-20110207050620-8da8nhie94bm9gtn

bzr:repository-uuid:

1e3b908f-19a9-db11-a64c-001125224ba8

bzr:revision-id:

ohkouchi@loop-az.jp-20110207051000-4lr57yzizu4cgun1

bzr:revno:

2838

bzr:revprop:branch-nick:

branches/version-2_5-dev

bzr:root:

branches/version-2_5-dev

bzr:text-revisions:

html/install/sql/create_table_mysql.sql ohkouchi@loop-az.jp-20110207050620-8da8nhie94bm9gtn
html/install/sql/create_table_pgsql.sql ohkouchi@loop-az.jp-20110207050620-8da8nhie94bm9gtn
html/install/sql/insert_data.sql ohkouchi@loop-az.jp-20110207050620-8da8nhie94bm9gtn

bzr:timestamp:

2011-02-07 14:10:00.960999966 +0900

bzr:user-agent:

bzr2.2.1+bzr-svn1.0.4

svn:original-date:

2011-02-07T05:10:00.961000Z

Message:

#990(配送設定・支払方法設定の仕様変更)

• r20070 のコミット漏れ

Location:

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

Files:

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

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

@@ -159 +159 @@
     name text,
     service_name text,
+    remark text,
     confirm_url text,
     rank int,
@@ -167 +168 @@
     update_date timestamp NOT NULL,
     PRIMARY KEY (deliv_id)
+) ENGINE=InnoDB;
+
+CREATE TABLE dtb_payment_options (
+    deliv_id int NOT NULL,
+    payment_id int NOT NULL,
+    rank int,
+    PRIMARY KEY (deliv_id, payment_id)
 ) ENGINE=InnoDB;
 
@@ -215 +223 @@
     memo10 text,
     PRIMARY KEY (payment_id)
-) ENGINE=InnoDB;
-
-CREATE TABLE dtb_payment_options (
-    product_class_id int NOT NULL,
-    payment_id int NOT NULL,
-    rank int,
-    PRIMARY KEY(product_class_id, payment_id)
 ) ENGINE=InnoDB;
 

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

@@ -159 +159 @@
     name text,
     service_name text,
+    remark text,
     confirm_url text,
     rank int,
@@ -167 +168 @@
     update_date timestamp NOT NULL,
     PRIMARY KEY (deliv_id)
+);
+
+CREATE TABLE dtb_payment_options (
+    payment_id int NOT NULL,
+    deliv_id int NOT NULL,
+    rank int,
+    PRIMARY KEY (payment_id, deliv_id)
 );
 
@@ -215 +223 @@
     memo10 text,
     PRIMARY KEY (payment_id)
-);
-
-CREATE TABLE dtb_payment_options (
-    product_class_id int NOT NULL,
-    payment_id int NOT NULL,
-    rank int,
-    PRIMARY KEY(product_class_id, payment_id)
 );
 

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

@@ -299 +299 @@
 INSERT INTO dtb_deliv (deliv_id, product_type_id, name, service_name, confirm_url, rank, status, del_flg, creator_id, create_date, update_date) VALUES (1, 1, 'サンプル業者', 'サンプル業者', NULL, 1, 1, 0, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
 INSERT INTO dtb_deliv (deliv_id, product_type_id, name, service_name, confirm_url, rank, status, del_flg, creator_id, create_date, update_date) VALUES (2, 2, '配送無し(ダウンロード商品用)', 'なし', NULL, 1, 1, 0, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
+
+INSERT INTO dtb_payment_options (deliv_id, payment_id, rank) VALUES (1, 1, 1);
+INSERT INTO dtb_payment_options (deliv_id, payment_id, rank) VALUES (1, 2, 2);
+INSERT INTO dtb_payment_options (deliv_id, payment_id, rank) VALUES (1, 3, 3);
+INSERT INTO dtb_payment_options (deliv_id, payment_id, rank) VALUES (1, 4, 4);
+INSERT INTO dtb_payment_options (deliv_id, payment_id, rank) VALUES (2, 3, 1);
 
 INSERT INTO dtb_delivfee (deliv_id, fee_id, fee, pref) VALUES (1, 1, 1000, 1);
@@ -587 +593 @@
 INSERT INTO dtb_payment (payment_id, payment_method, charge, rule, rank, note, fix, status, del_flg, creator_id, create_date, update_date, payment_image, upper_rule, charge_flg, rule_min, upper_rule_max, module_id, module_path, memo01, memo02, memo03, memo04, memo05, memo06, memo07, memo08, memo09, memo10) VALUES (3, '銀行振込', 0, NULL, 2, NULL, 2, 1, 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
 INSERT INTO dtb_payment (payment_id, payment_method, charge, rule, rank, note, fix, status, del_flg, creator_id, create_date, update_date, payment_image, upper_rule, charge_flg, rule_min, upper_rule_max, module_id, module_path, memo01, memo02, memo03, memo04, memo05, memo06, memo07, memo08, memo09, memo10) VALUES (4, '代金引換', 0, NULL, 1, NULL, 2, 1, 0, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (1, 1, 1);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (1, 2, 2);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (1, 3, 3);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (1, 4, 4);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (2, 1, 1);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (2, 2, 2);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (2, 3, 3);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (2, 4, 4);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (3, 1, 1);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (3, 2, 2);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (3, 3, 3);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (3, 4, 4);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (4, 1, 1);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (4, 2, 2);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (4, 3, 3);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (4, 4, 4);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (5, 1, 1);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (5, 2, 2);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (5, 3, 3);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (5, 4, 4);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (6, 1, 1);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (6, 2, 2);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (6, 3, 3);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (6, 4, 4);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (7, 1, 1);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (7, 2, 2);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (7, 3, 3);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (7, 4, 4);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (8, 1, 1);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (8, 2, 2);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (8, 3, 3);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (8, 4, 4);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (9, 1, 1);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (9, 2, 2);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (9, 3, 3);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (9, 4, 4);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (10, 1, 1);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (10, 2, 2);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (10, 3, 3);
-INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (10, 4, 4);
 
 INSERT INTO dtb_product_categories (product_id, category_id, rank) VALUES (1, 5, 1);