Ignore:
Timestamp:
2010/12/28 06:21:56 (12 years ago)
Author:
Seasoft
Message:

#829(mtb_pref を他の mtb_* と同等のテーブル定義に)

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

Legend:

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

    r19670 r19773  
    527527INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (539, 'dtb_order_detail', 'quantity', '数量'); 
    528528INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (540, 'dtb_order_detail', 'point_rate', 'ポイント付与率'); 
    529 INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (541, 'mtb_pref', 'pref_id', '都道府県ID'); 
    530 INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (542, 'mtb_pref', 'pref_name', '都道府県名'); 
    531 INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (543, 'mtb_pref', 'rank', '表示順位'); 
    532529INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (544, 'dtb_member', 'member_id', '管理者ID'); 
    533530INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (545, 'dtb_member', 'name', '管理者名称'); 
  • branches/version-2_5-dev/html/install/sql/create_table_mysql.sql

    r19761 r19773  
    750750) TYPE=InnoDB; 
    751751 
    752 CREATE TABLE mtb_pref ( 
    753     pref_id smallint NOT NULL, 
    754     pref_name text, 
    755     rank smallint NOT NULL DEFAULT 0, 
    756     PRIMARY KEY (pref_id) 
    757 ) TYPE=InnoDB; 
    758  
    759752CREATE TABLE dtb_member ( 
    760753    member_id int  NOT NULL, 
     
    883876) TYPE=InnoDB; 
    884877 
     878CREATE TABLE mtb_pref ( 
     879    id smallint NOT NULL, 
     880    name text, 
     881    rank smallint NOT NULL DEFAULT 0, 
     882    PRIMARY KEY (pref_id) 
     883) TYPE=InnoDB; 
    885884 
    886885CREATE TABLE mtb_permission ( 
  • branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql

    r19761 r19773  
    752752); 
    753753 
    754 CREATE TABLE mtb_pref ( 
    755     pref_id smallint NOT NULL, 
    756     pref_name text, 
    757     rank smallint NOT NULL DEFAULT 0, 
    758     PRIMARY KEY (pref_id) 
    759 ); 
    760  
    761754CREATE TABLE dtb_member ( 
    762755    member_id int NOT NULL, 
     
    885878); 
    886879 
     880CREATE TABLE mtb_pref ( 
     881    id text, 
     882    name text, 
     883    rank smallint NOT NULL DEFAULT 0, 
     884    PRIMARY KEY (id) 
     885); 
     886 
    887887CREATE TABLE mtb_permission ( 
    888888    id text, 
  • branches/version-2_5-dev/html/install/sql/insert_data.sql

    r19769 r19773  
    289289INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (117, 3, 'order_zip01', '郵便番号1', 15, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);                               
    290290INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (118, 3, 'order_zip02', '郵便番号2', 16, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    291 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (119, 3, '(SELECT pref_name FROM mtb_pref WHERE pref_id = dtb_order.order_pref)', '都道府県', 17, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     291INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (119, 3, '(SELECT name FROM mtb_pref WHERE id = dtb_order.order_pref)', '都道府県', 17, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    292292INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (120, 3, 'order_addr01', '住所1', 18, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);                                  
    293293INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (121, 3, 'order_addr02', '住所2', 19, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);                                  
     
    307307INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (135, 3, 'deliv_zip01', '郵便番号1', 33, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);                               
    308308INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (136, 3, 'deliv_zip02', '郵便番号2', 34, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    309 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (137, 3, '(SELECT pref_name FROM mtb_pref WHERE pref_id = dtb_order.deliv_pref)', '都道府県', 35, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     309INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (137, 3, '(SELECT name FROM mtb_pref WHERE id = dtb_order.deliv_pref)', '都道府県', 35, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    310310INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (138, 3, 'deliv_addr01', '住所1', 36, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);                                  
    311311INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (139, 3, 'deliv_addr02', '住所2', 37, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);                                  
     
    343343INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (171, 4, 'order_zip01', '郵便番号1', 16, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);                               
    344344INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (172, 4, 'order_zip02', '郵便番号2', 17, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    345 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (173, 4, '(SELECT pref_name FROM mtb_pref WHERE pref_id = dtb_order.order_pref)', '都道府県', 18, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     345INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (173, 4, '(SELECT name FROM mtb_pref WHERE id = dtb_order.order_pref)', '都道府県', 18, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    346346INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (174, 4, 'order_addr01', '住所1', 19, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);                                  
    347347INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (175, 4, 'order_addr02', '住所2', 20, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);                                  
     
    361361INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (189, 4, 'deliv_zip01', '郵便番号1', 34, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);                               
    362362INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (190, 4, 'deliv_zip02', '郵便番号2', 35, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    363 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (191, 4, '(SELECT pref_name FROM mtb_pref WHERE pref_id = dtb_order.deliv_pref)', '都道府県', 36, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     363INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (191, 4, '(SELECT name FROM mtb_pref WHERE id = dtb_order.deliv_pref)', '都道府県', 36, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    364364INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (192, 4, 'deliv_addr01', '住所1', 37, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    365365INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (193, 4, 'deliv_addr02', '住所2', 38, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     
    909909INSERT INTO mtb_permission (id, name, rank) VALUES ('/admin/search/delete_note.php', '1', 11); 
    910910 
    911 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (1, '北海道', 1); 
    912 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (2, '青森県', 2); 
    913 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (3, '岩手県', 3); 
    914 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (4, '宮城県', 4); 
    915 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (5, '秋田県', 5); 
    916 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (6, '山形県', 6); 
    917 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (7, '福島県', 7); 
    918 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (8, '茨城県', 8); 
    919 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (9, '栃木県', 9); 
    920 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (10, '群馬県', 10); 
    921 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (11, '埼玉県', 11); 
    922 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (12, '千葉県', 12); 
    923 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (13, '東京都', 13); 
    924 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (14, '神奈川県', 14); 
    925 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (15, '新潟県', 15); 
    926 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (16, '富山県', 16); 
    927 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (17, '石川県', 17); 
    928 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (18, '福井県', 18); 
    929 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (19, '山梨県', 19); 
    930 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (20, '長野県', 20); 
    931 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (21, '岐阜県', 21); 
    932 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (22, '静岡県', 22); 
    933 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (23, '愛知県', 23); 
    934 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (24, '三重県', 24); 
    935 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (25, '滋賀県', 25); 
    936 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (26, '京都府', 26); 
    937 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (27, '大阪府', 27); 
    938 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (28, '兵庫県', 28); 
    939 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (29, '奈良県', 29); 
    940 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (30, '和歌山県', 30); 
    941 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (31, '鳥取県', 31); 
    942 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (32, '島根県', 32); 
    943 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (33, '岡山県', 33); 
    944 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (34, '広島県', 34); 
    945 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (35, '山口県', 35); 
    946 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (36, '徳島県', 36); 
    947 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (37, '香川県', 37); 
    948 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (38, '愛媛県', 38); 
    949 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (39, '高知県', 39); 
    950 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (40, '福岡県', 40); 
    951 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (41, '佐賀県', 41); 
    952 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (42, '長崎県', 42); 
    953 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (43, '熊本県', 43); 
    954 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (44, '大分県', 44); 
    955 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (45, '宮崎県', 45); 
    956 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (46, '鹿児島県', 46); 
    957 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES (47, '沖縄県', 47); 
     911INSERT INTO mtb_pref (id, name, rank) VALUES (1, '北海道', 1); 
     912INSERT INTO mtb_pref (id, name, rank) VALUES (2, '青森県', 2); 
     913INSERT INTO mtb_pref (id, name, rank) VALUES (3, '岩手県', 3); 
     914INSERT INTO mtb_pref (id, name, rank) VALUES (4, '宮城県', 4); 
     915INSERT INTO mtb_pref (id, name, rank) VALUES (5, '秋田県', 5); 
     916INSERT INTO mtb_pref (id, name, rank) VALUES (6, '山形県', 6); 
     917INSERT INTO mtb_pref (id, name, rank) VALUES (7, '福島県', 7); 
     918INSERT INTO mtb_pref (id, name, rank) VALUES (8, '茨城県', 8); 
     919INSERT INTO mtb_pref (id, name, rank) VALUES (9, '栃木県', 9); 
     920INSERT INTO mtb_pref (id, name, rank) VALUES (10, '群馬県', 10); 
     921INSERT INTO mtb_pref (id, name, rank) VALUES (11, '埼玉県', 11); 
     922INSERT INTO mtb_pref (id, name, rank) VALUES (12, '千葉県', 12); 
     923INSERT INTO mtb_pref (id, name, rank) VALUES (13, '東京都', 13); 
     924INSERT INTO mtb_pref (id, name, rank) VALUES (14, '神奈川県', 14); 
     925INSERT INTO mtb_pref (id, name, rank) VALUES (15, '新潟県', 15); 
     926INSERT INTO mtb_pref (id, name, rank) VALUES (16, '富山県', 16); 
     927INSERT INTO mtb_pref (id, name, rank) VALUES (17, '石川県', 17); 
     928INSERT INTO mtb_pref (id, name, rank) VALUES (18, '福井県', 18); 
     929INSERT INTO mtb_pref (id, name, rank) VALUES (19, '山梨県', 19); 
     930INSERT INTO mtb_pref (id, name, rank) VALUES (20, '長野県', 20); 
     931INSERT INTO mtb_pref (id, name, rank) VALUES (21, '岐阜県', 21); 
     932INSERT INTO mtb_pref (id, name, rank) VALUES (22, '静岡県', 22); 
     933INSERT INTO mtb_pref (id, name, rank) VALUES (23, '愛知県', 23); 
     934INSERT INTO mtb_pref (id, name, rank) VALUES (24, '三重県', 24); 
     935INSERT INTO mtb_pref (id, name, rank) VALUES (25, '滋賀県', 25); 
     936INSERT INTO mtb_pref (id, name, rank) VALUES (26, '京都府', 26); 
     937INSERT INTO mtb_pref (id, name, rank) VALUES (27, '大阪府', 27); 
     938INSERT INTO mtb_pref (id, name, rank) VALUES (28, '兵庫県', 28); 
     939INSERT INTO mtb_pref (id, name, rank) VALUES (29, '奈良県', 29); 
     940INSERT INTO mtb_pref (id, name, rank) VALUES (30, '和歌山県', 30); 
     941INSERT INTO mtb_pref (id, name, rank) VALUES (31, '鳥取県', 31); 
     942INSERT INTO mtb_pref (id, name, rank) VALUES (32, '島根県', 32); 
     943INSERT INTO mtb_pref (id, name, rank) VALUES (33, '岡山県', 33); 
     944INSERT INTO mtb_pref (id, name, rank) VALUES (34, '広島県', 34); 
     945INSERT INTO mtb_pref (id, name, rank) VALUES (35, '山口県', 35); 
     946INSERT INTO mtb_pref (id, name, rank) VALUES (36, '徳島県', 36); 
     947INSERT INTO mtb_pref (id, name, rank) VALUES (37, '香川県', 37); 
     948INSERT INTO mtb_pref (id, name, rank) VALUES (38, '愛媛県', 38); 
     949INSERT INTO mtb_pref (id, name, rank) VALUES (39, '高知県', 39); 
     950INSERT INTO mtb_pref (id, name, rank) VALUES (40, '福岡県', 40); 
     951INSERT INTO mtb_pref (id, name, rank) VALUES (41, '佐賀県', 41); 
     952INSERT INTO mtb_pref (id, name, rank) VALUES (42, '長崎県', 42); 
     953INSERT INTO mtb_pref (id, name, rank) VALUES (43, '熊本県', 43); 
     954INSERT INTO mtb_pref (id, name, rank) VALUES (44, '大分県', 44); 
     955INSERT INTO mtb_pref (id, name, rank) VALUES (45, '宮崎県', 45); 
     956INSERT INTO mtb_pref (id, name, rank) VALUES (46, '鹿児島県', 46); 
     957INSERT INTO mtb_pref (id, name, rank) VALUES (47, '沖縄県', 47); 
    958958 
    959959INSERT INTO mtb_product_list_max (id, name, rank) VALUES (15, '15件', 0); 
Note: See TracChangeset for help on using the changeset viewer.