Ignore:
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(配送設定・支払方法設定の仕様変更)

Location:
branches/version-2_5-dev/html/install/sql
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_5-dev/html/install/sql/create_table_mysql.sql

    r20068 r20110  
    159159    name text, 
    160160    service_name text, 
     161    remark text, 
    161162    confirm_url text, 
    162163    rank int, 
     
    167168    update_date timestamp NOT NULL, 
    168169    PRIMARY KEY (deliv_id) 
     170) ENGINE=InnoDB; 
     171 
     172CREATE TABLE dtb_payment_options ( 
     173    deliv_id int NOT NULL, 
     174    payment_id int NOT NULL, 
     175    rank int, 
     176    PRIMARY KEY (deliv_id, payment_id) 
    169177) ENGINE=InnoDB; 
    170178 
     
    215223    memo10 text, 
    216224    PRIMARY KEY (payment_id) 
    217 ) ENGINE=InnoDB; 
    218  
    219 CREATE TABLE dtb_payment_options ( 
    220     product_class_id int NOT NULL, 
    221     payment_id int NOT NULL, 
    222     rank int, 
    223     PRIMARY KEY(product_class_id, payment_id) 
    224225) ENGINE=InnoDB; 
    225226 
  • branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql

    r20068 r20110  
    159159    name text, 
    160160    service_name text, 
     161    remark text, 
    161162    confirm_url text, 
    162163    rank int, 
     
    167168    update_date timestamp NOT NULL, 
    168169    PRIMARY KEY (deliv_id) 
     170); 
     171 
     172CREATE TABLE dtb_payment_options ( 
     173    payment_id int NOT NULL, 
     174    deliv_id int NOT NULL, 
     175    rank int, 
     176    PRIMARY KEY (payment_id, deliv_id) 
    169177); 
    170178 
     
    215223    memo10 text, 
    216224    PRIMARY KEY (payment_id) 
    217 ); 
    218  
    219 CREATE TABLE dtb_payment_options ( 
    220     product_class_id int NOT NULL, 
    221     payment_id int NOT NULL, 
    222     rank int, 
    223     PRIMARY KEY(product_class_id, payment_id) 
    224225); 
    225226 
  • branches/version-2_5-dev/html/install/sql/insert_data.sql

    r20069 r20110  
    299299INSERT 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); 
    300300INSERT 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); 
     301 
     302INSERT INTO dtb_payment_options (deliv_id, payment_id, rank) VALUES (1, 1, 1); 
     303INSERT INTO dtb_payment_options (deliv_id, payment_id, rank) VALUES (1, 2, 2); 
     304INSERT INTO dtb_payment_options (deliv_id, payment_id, rank) VALUES (1, 3, 3); 
     305INSERT INTO dtb_payment_options (deliv_id, payment_id, rank) VALUES (1, 4, 4); 
     306INSERT INTO dtb_payment_options (deliv_id, payment_id, rank) VALUES (2, 3, 1); 
    301307 
    302308INSERT INTO dtb_delivfee (deliv_id, fee_id, fee, pref) VALUES (1, 1, 1000, 1); 
     
    587593INSERT 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); 
    588594INSERT 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); 
    589  
    590 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (1, 1, 1); 
    591 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (1, 2, 2); 
    592 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (1, 3, 3); 
    593 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (1, 4, 4); 
    594 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (2, 1, 1); 
    595 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (2, 2, 2); 
    596 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (2, 3, 3); 
    597 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (2, 4, 4); 
    598 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (3, 1, 1); 
    599 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (3, 2, 2); 
    600 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (3, 3, 3); 
    601 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (3, 4, 4); 
    602 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (4, 1, 1); 
    603 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (4, 2, 2); 
    604 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (4, 3, 3); 
    605 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (4, 4, 4); 
    606 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (5, 1, 1); 
    607 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (5, 2, 2); 
    608 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (5, 3, 3); 
    609 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (5, 4, 4); 
    610 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (6, 1, 1); 
    611 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (6, 2, 2); 
    612 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (6, 3, 3); 
    613 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (6, 4, 4); 
    614 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (7, 1, 1); 
    615 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (7, 2, 2); 
    616 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (7, 3, 3); 
    617 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (7, 4, 4); 
    618 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (8, 1, 1); 
    619 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (8, 2, 2); 
    620 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (8, 3, 3); 
    621 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (8, 4, 4); 
    622 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (9, 1, 1); 
    623 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (9, 2, 2); 
    624 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (9, 3, 3); 
    625 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (9, 4, 4); 
    626 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (10, 1, 1); 
    627 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (10, 2, 2); 
    628 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (10, 3, 3); 
    629 INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (10, 4, 4); 
    630595 
    631596INSERT INTO dtb_product_categories (product_id, category_id, rank) VALUES (1, 5, 1); 
Note: See TracChangeset for help on using the changeset viewer.