Changeset 19671


Ignore:
Timestamp:
2010/11/16 14:32:55 (13 years ago)
Author:
nanasess
bzr:base-revision:
ohkouchi@loop-az.jp-20101115082842-ctyzag2ux61c9aoy
bzr:committer:
Kentaro Ohkouchi <ohkouchi@loop-az.jp>
bzr:file-ids:

docs/eccube-diagram.jude eccubediagram.jude-20101102081620-jpq1fqmox6ocmuj3-2
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/drop_table.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fdrop_table.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-20101116052559-cfmcbiuw7kfcihat
bzr:repository-uuid:
1e3b908f-19a9-db11-a64c-001125224ba8
bzr:revision-id:
ohkouchi@loop-az.jp-20101116052904-h7mow1fhe15vyybi
bzr:revno:
2401
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-20101116052520-j3aismmu1hc9jxrm
html/install/sql/create_table_pgsql.sql ohkouchi@loop-az.jp-20101116052520-j3aismmu1hc9jxrm
html/install/sql/drop_table.sql ohkouchi@loop-az.jp-20101116052559-cfmcbiuw7kfcihat
html/install/sql/insert_data.sql ohkouchi@loop-az.jp-20101116052559-cfmcbiuw7kfcihat
bzr:timestamp:
2010-11-16 14:29:04.240000010 +0900
bzr:user-agent:
bzr2.2.1+bzr-svn1.0.4
svn:original-date:
2010-11-16T05:29:04.240000Z
Message:

商品種別によってカートを分ける(#823)

  • 配送/支払関連のリレーションを修正
  • ER図修正
  • dtb_product_type_options, dtb_payment_options テーブル追加
Location:
branches/version-2_5-dev
Files:
5 edited

Legend:

Unmodified
Added
Removed

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

    r19670 r19671  
    156156CREATE TABLE dtb_deliv ( 
    157157    deliv_id int  NOT NULL, 
     158    product_type_id int, 
    158159    name text, 
    159160    service_name text, 
    … …  
    180181    fee text NOT NULL, 
    181182    pref smallint, 
    182     PRIMARY KEY (fee_id) 
     183    PRIMARY KEY (deliv_id, fee_id) 
    183184) TYPE=InnoDB; 
    184185 
    … …  
    188189    charge numeric, 
    189190    rule numeric, 
    190     deliv_id int DEFAULT 0, 
    191191    rank int, 
    192192    note text, 
    … …  
    215215    memo10 text, 
    216216    PRIMARY KEY (payment_id) 
     217) TYPE=InnoDB; 
     218 
     219CREATE 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) 
     224) TYPE=InnoDB; 
     225 
     226CREATE TABLE dtb_product_type_options ( 
     227    product_type_id int NOT NULL, 
     228    deliv_id int NOT NULL, 
     229    rank int, 
     230    PRIMARY KEY(product_type_id, deliv_id) 
    217231) TYPE=InnoDB; 
    218232 

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

    r19670 r19671  
    156156CREATE TABLE dtb_deliv ( 
    157157    deliv_id int NOT NULL, 
     158    product_type_id int, 
    158159    name text, 
    159160    service_name text, 
    … …  
    180181    fee text NOT NULL, 
    181182    pref smallint, 
    182     PRIMARY KEY (fee_id) 
     183    PRIMARY KEY (deliv_id, fee_id) 
    183184); 
    184185 
    … …  
    188189    charge numeric, 
    189190    rule numeric, 
    190     deliv_id int DEFAULT 0, 
    191191    rank int, 
    192192    note text, 
    … …  
    215215    memo10 text, 
    216216    PRIMARY KEY (payment_id) 
     217); 
     218 
     219CREATE 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) 
     224); 
     225 
     226CREATE TABLE dtb_product_type_options ( 
     227    product_type_id int NOT NULL, 
     228    deliv_id int NOT NULL, 
     229    rank int, 
     230    PRIMARY KEY(product_type_id, deliv_id) 
    217231); 
    218232 

  • branches/version-2_5-dev/html/install/sql/drop_table.sql

    r19670 r19671  
    9999DROP TABLE dtb_plugin; 
    100100DROP TABLE dtb_index_list; 
     101DROP TABLE dtb_payment_options; 
     102DROP TABLE dtb_product_type_options; 

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

    r19670 r19671  
    231231INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (185, 5, 'rank', '表示ランク', NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    232232 
    233 INSERT INTO dtb_deliv (deliv_id, name, service_name, confirm_url, rank, status, del_flg, creator_id, create_date, update_date) VALUES (1, 'サンプル業者', 'サンプル業者', NULL, 1, 1, 0, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     233INSERT 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); 
    234234 
    235235INSERT INTO dtb_delivfee (deliv_id, fee_id, fee, pref) VALUES (1, 1, '1000', 1); 
    … …  
    380380INSERT INTO dtb_pagelayout (page_id, page_name, url, php_dir, tpl_dir, filename, header_chk, footer_chk, edit_flg, author, description, keyword, update_url, create_date, update_date) VALUES (0, 'プレビューデータ', 'preview', NULL, NULL, NULL, 1, 1, 1, NULL, NULL, NULL, NULL, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    381381 
    382 INSERT INTO dtb_payment (payment_id, payment_method, charge, rule, deliv_id, 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 (1, 'クレジット', 0, NULL, 1, 5, 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); 
    383 INSERT INTO dtb_payment (payment_id, payment_method, charge, rule, deliv_id, 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 (2, '郵便振替', 0, NULL, 1, 4, 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); 
    384 INSERT INTO dtb_payment (payment_id, payment_method, charge, rule, deliv_id, 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, 1, 3, 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); 
    385 INSERT INTO dtb_payment (payment_id, payment_method, charge, rule, deliv_id, 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, 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); 
    386 INSERT INTO dtb_payment (payment_id, payment_method, charge, rule, deliv_id, 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 (5, '代金引換', 0, NULL, 1, 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); 
     382INSERT 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 (1, 'クレジット', 0, NULL, 5, 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); 
     383INSERT 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 (2, '郵便振替', 0, NULL, 4, 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); 
     384INSERT 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, 3, 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); 
     385INSERT 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, 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); 
     386INSERT 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 (5, '代金引換', 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); 
     387 
     388INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (1, 1, 1); 
     389INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (1, 2, 2); 
     390INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (1, 3, 3); 
     391INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (1, 4, 4); 
     392INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (1, 5, 5); 
     393INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (2, 1, 1); 
     394INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (2, 2, 2); 
     395INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (2, 3, 3); 
     396INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (2, 4, 4); 
     397INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (2, 5, 5); 
     398INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (3, 1, 1); 
     399INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (3, 2, 2); 
     400INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (3, 3, 3); 
     401INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (3, 4, 4); 
     402INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (3, 5, 5); 
     403INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (4, 1, 1); 
     404INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (4, 2, 2); 
     405INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (4, 3, 3); 
     406INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (4, 4, 4); 
     407INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (4, 5, 5); 
     408INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (5, 1, 1); 
     409INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (5, 2, 2); 
     410INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (5, 3, 3); 
     411INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (5, 4, 4); 
     412INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (5, 5, 5); 
     413INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (6, 1, 1); 
     414INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (6, 2, 2); 
     415INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (6, 3, 3); 
     416INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (6, 4, 4); 
     417INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (6, 5, 5); 
     418INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (7, 1, 1); 
     419INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (7, 2, 2); 
     420INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (7, 3, 3); 
     421INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (7, 4, 4); 
     422INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (7, 5, 5); 
     423INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (8, 1, 1); 
     424INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (8, 2, 2); 
     425INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (8, 3, 3); 
     426INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (8, 4, 4); 
     427INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (8, 5, 5); 
     428INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (9, 1, 1); 
     429INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (9, 2, 2); 
     430INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (9, 3, 3); 
     431INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (9, 4, 4); 
     432INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (9, 5, 5); 
     433INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (10, 1, 1); 
     434INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (10, 2, 2); 
     435INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (10, 3, 3); 
     436INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (10, 4, 4); 
     437INSERT INTO dtb_payment_options (product_class_id, payment_id, rank) VALUES (10, 5, 5); 
     438 
     439INSERT INTO dtb_product_type_options (product_type_id, deliv_id, rank) VALUES (1, 1, 1); 
    387440 
    388441INSERT INTO dtb_product_categories (product_id, category_id, rank) VALUES (1, 5, 1); 
Note: See TracChangeset for help on using the changeset viewer.