Changeset 19773 for branches/version-2_5-dev/html
- Timestamp:
- 2010/12/28 06:21:56 (13 years ago)
- 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 527 527 INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (539, 'dtb_order_detail', 'quantity', '数量'); 528 528 INSERT 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', '表示順位');532 529 INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (544, 'dtb_member', 'member_id', '管理者ID'); 533 530 INSERT 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 750 750 ) TYPE=InnoDB; 751 751 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 759 752 CREATE TABLE dtb_member ( 760 753 member_id int NOT NULL, … … 883 876 ) TYPE=InnoDB; 884 877 878 CREATE 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; 885 884 886 885 CREATE TABLE mtb_permission ( -
branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql
r19761 r19773 752 752 ); 753 753 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 761 754 CREATE TABLE dtb_member ( 762 755 member_id int NOT NULL, … … 885 878 ); 886 879 880 CREATE TABLE mtb_pref ( 881 id text, 882 name text, 883 rank smallint NOT NULL DEFAULT 0, 884 PRIMARY KEY (id) 885 ); 886 887 887 CREATE TABLE mtb_permission ( 888 888 id text, -
branches/version-2_5-dev/html/install/sql/insert_data.sql
r19769 r19773 289 289 INSERT 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); 290 290 INSERT 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);291 INSERT 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); 292 292 INSERT 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); 293 293 INSERT 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); … … 307 307 INSERT 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); 308 308 INSERT 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);309 INSERT 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); 310 310 INSERT 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); 311 311 INSERT 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); … … 343 343 INSERT 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); 344 344 INSERT 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);345 INSERT 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); 346 346 INSERT 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); 347 347 INSERT 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); … … 361 361 INSERT 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); 362 362 INSERT 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);363 INSERT 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); 364 364 INSERT 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); 365 365 INSERT 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); … … 909 909 INSERT INTO mtb_permission (id, name, rank) VALUES ('/admin/search/delete_note.php', '1', 11); 910 910 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);911 INSERT INTO mtb_pref (id, name, rank) VALUES (1, '北海道', 1); 912 INSERT INTO mtb_pref (id, name, rank) VALUES (2, '青森県', 2); 913 INSERT INTO mtb_pref (id, name, rank) VALUES (3, '岩手県', 3); 914 INSERT INTO mtb_pref (id, name, rank) VALUES (4, '宮城県', 4); 915 INSERT INTO mtb_pref (id, name, rank) VALUES (5, '秋田県', 5); 916 INSERT INTO mtb_pref (id, name, rank) VALUES (6, '山形県', 6); 917 INSERT INTO mtb_pref (id, name, rank) VALUES (7, '福島県', 7); 918 INSERT INTO mtb_pref (id, name, rank) VALUES (8, '茨城県', 8); 919 INSERT INTO mtb_pref (id, name, rank) VALUES (9, '栃木県', 9); 920 INSERT INTO mtb_pref (id, name, rank) VALUES (10, '群馬県', 10); 921 INSERT INTO mtb_pref (id, name, rank) VALUES (11, '埼玉県', 11); 922 INSERT INTO mtb_pref (id, name, rank) VALUES (12, '千葉県', 12); 923 INSERT INTO mtb_pref (id, name, rank) VALUES (13, '東京都', 13); 924 INSERT INTO mtb_pref (id, name, rank) VALUES (14, '神奈川県', 14); 925 INSERT INTO mtb_pref (id, name, rank) VALUES (15, '新潟県', 15); 926 INSERT INTO mtb_pref (id, name, rank) VALUES (16, '富山県', 16); 927 INSERT INTO mtb_pref (id, name, rank) VALUES (17, '石川県', 17); 928 INSERT INTO mtb_pref (id, name, rank) VALUES (18, '福井県', 18); 929 INSERT INTO mtb_pref (id, name, rank) VALUES (19, '山梨県', 19); 930 INSERT INTO mtb_pref (id, name, rank) VALUES (20, '長野県', 20); 931 INSERT INTO mtb_pref (id, name, rank) VALUES (21, '岐阜県', 21); 932 INSERT INTO mtb_pref (id, name, rank) VALUES (22, '静岡県', 22); 933 INSERT INTO mtb_pref (id, name, rank) VALUES (23, '愛知県', 23); 934 INSERT INTO mtb_pref (id, name, rank) VALUES (24, '三重県', 24); 935 INSERT INTO mtb_pref (id, name, rank) VALUES (25, '滋賀県', 25); 936 INSERT INTO mtb_pref (id, name, rank) VALUES (26, '京都府', 26); 937 INSERT INTO mtb_pref (id, name, rank) VALUES (27, '大阪府', 27); 938 INSERT INTO mtb_pref (id, name, rank) VALUES (28, '兵庫県', 28); 939 INSERT INTO mtb_pref (id, name, rank) VALUES (29, '奈良県', 29); 940 INSERT INTO mtb_pref (id, name, rank) VALUES (30, '和歌山県', 30); 941 INSERT INTO mtb_pref (id, name, rank) VALUES (31, '鳥取県', 31); 942 INSERT INTO mtb_pref (id, name, rank) VALUES (32, '島根県', 32); 943 INSERT INTO mtb_pref (id, name, rank) VALUES (33, '岡山県', 33); 944 INSERT INTO mtb_pref (id, name, rank) VALUES (34, '広島県', 34); 945 INSERT INTO mtb_pref (id, name, rank) VALUES (35, '山口県', 35); 946 INSERT INTO mtb_pref (id, name, rank) VALUES (36, '徳島県', 36); 947 INSERT INTO mtb_pref (id, name, rank) VALUES (37, '香川県', 37); 948 INSERT INTO mtb_pref (id, name, rank) VALUES (38, '愛媛県', 38); 949 INSERT INTO mtb_pref (id, name, rank) VALUES (39, '高知県', 39); 950 INSERT INTO mtb_pref (id, name, rank) VALUES (40, '福岡県', 40); 951 INSERT INTO mtb_pref (id, name, rank) VALUES (41, '佐賀県', 41); 952 INSERT INTO mtb_pref (id, name, rank) VALUES (42, '長崎県', 42); 953 INSERT INTO mtb_pref (id, name, rank) VALUES (43, '熊本県', 43); 954 INSERT INTO mtb_pref (id, name, rank) VALUES (44, '大分県', 44); 955 INSERT INTO mtb_pref (id, name, rank) VALUES (45, '宮崎県', 45); 956 INSERT INTO mtb_pref (id, name, rank) VALUES (46, '鹿児島県', 46); 957 INSERT INTO mtb_pref (id, name, rank) VALUES (47, '沖縄県', 47); 958 958 959 959 INSERT INTO mtb_product_list_max (id, name, rank) VALUES (15, '15件', 0);
Note: See TracChangeset
for help on using the changeset viewer.