Index: branches/version-2_13-dev/html/install/sql/drop_table.sql
===================================================================
--- branches/version-2_13-dev/html/install/sql/drop_table.sql (revision 21942)
+++ branches/version-2_13-dev/html/install/sql/drop_table.sql (revision 22736)
@@ -96,2 +96,4 @@
DROP TABLE dtb_api_config;
DROP TABLE dtb_api_account;
+DROP TABLE dtb_tax_rule;
+DROP TABLE mtb_country;
Index: branches/version-2_13-dev/html/install/sql/insert_data.sql
===================================================================
--- branches/version-2_13-dev/html/install/sql/insert_data.sql (revision 22551)
+++ branches/version-2_13-dev/html/install/sql/insert_data.sql (revision 22736)
@@ -1255,4 +1255,6 @@
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('LOGIN_RETRY_INTERVAL', '0', 1411, 'ログイン失敗時の遅延時間(秒)(ブルートフォースアタック対策)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MYPAGE_ORDER_STATUS_DISP_FLAG', 'true', 1412, 'MYページ：ご注文状況表示フラグ');
+INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DEFAULT_COUNTRY_ID', 392, 1413, 'デフォルト国コード ISO_3166-1に準拠');
+
INSERT INTO dtb_index_list (table_name, column_name, recommend_flg, recommend_comment) VALUES ('dtb_customer', 'email_mobile', 0, '会員数増加時のログイン処理速度を向上させたいときに試してみてください');
@@ -1279,2 +1281,254 @@
INSERT INTO dtb_index_list (table_name, column_name, recommend_flg, recommend_comment) VALUES ('dtb_product_categories', 'category_id', 2, 'カテゴリが多いときに試してみてください。');
INSERT INTO dtb_index_list (table_name, column_name, recommend_flg, recommend_comment) VALUES ('mtb_zip', 'zipcode', 2, '郵便番号検索が遅いときに試してみてください。郵便番号データの更新時には無効にしていることをおすすめします。');
+
+INSERT INTO dtb_tax_rule (tax_rule_id, apply_date, member_id, del_flg, create_date, update_date) VALUES (0, CURRENT_TIMESTAMP, 1, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
+
+INSERT INTO mtb_country (id, name, rank) VALUES (352,'アイスランド',1);
+INSERT INTO mtb_country (id, name, rank) VALUES (372,'アイルランド',2);
+INSERT INTO mtb_country (id, name, rank) VALUES (31,'アゼルバイジャン',3);
+INSERT INTO mtb_country (id, name, rank) VALUES (4,'アフガニスタン',4);
+INSERT INTO mtb_country (id, name, rank) VALUES (840,'アメリカ合衆国',5);
+INSERT INTO mtb_country (id, name, rank) VALUES (850,'アメリカ領ヴァージン諸島',6);
+INSERT INTO mtb_country (id, name, rank) VALUES (16,'アメリカ領サモア',7);
+INSERT INTO mtb_country (id, name, rank) VALUES (784,'アラブ首長国連邦',8);
+INSERT INTO mtb_country (id, name, rank) VALUES (12,'アルジェリア',9);
+INSERT INTO mtb_country (id, name, rank) VALUES (32,'アルゼンチン',10);
+INSERT INTO mtb_country (id, name, rank) VALUES (533,'アルバ',11);
+INSERT INTO mtb_country (id, name, rank) VALUES (8,'アルバニア',12);
+INSERT INTO mtb_country (id, name, rank) VALUES (51,'アルメニア',13);
+INSERT INTO mtb_country (id, name, rank) VALUES (660,'アンギラ',14);
+INSERT INTO mtb_country (id, name, rank) VALUES (24,'アンゴラ',15);
+INSERT INTO mtb_country (id, name, rank) VALUES (28,'アンティグア・バーブーダ',16);
+INSERT INTO mtb_country (id, name, rank) VALUES (20,'アンドラ',17);
+INSERT INTO mtb_country (id, name, rank) VALUES (887,'イエメン',18);
+INSERT INTO mtb_country (id, name, rank) VALUES (826,'イギリス',19);
+INSERT INTO mtb_country (id, name, rank) VALUES (86,'イギリス領インド洋地域',20);
+INSERT INTO mtb_country (id, name, rank) VALUES (92,'イギリス領ヴァージン諸島',21);
+INSERT INTO mtb_country (id, name, rank) VALUES (376,'イスラエル',22);
+INSERT INTO mtb_country (id, name, rank) VALUES (380,'イタリア',23);
+INSERT INTO mtb_country (id, name, rank) VALUES (368,'イラク',24);
+INSERT INTO mtb_country (id, name, rank) VALUES (364,'イラン|イラン・イスラム共和国',25);
+INSERT INTO mtb_country (id, name, rank) VALUES (356,'インド',26);
+INSERT INTO mtb_country (id, name, rank) VALUES (360,'インドネシア',27);
+INSERT INTO mtb_country (id, name, rank) VALUES (876,'ウォリス・フツナ',28);
+INSERT INTO mtb_country (id, name, rank) VALUES (800,'ウガンダ',29);
+INSERT INTO mtb_country (id, name, rank) VALUES (804,'ウクライナ',30);
+INSERT INTO mtb_country (id, name, rank) VALUES (860,'ウズベキスタン',31);
+INSERT INTO mtb_country (id, name, rank) VALUES (858,'ウルグアイ',32);
+INSERT INTO mtb_country (id, name, rank) VALUES (218,'エクアドル',33);
+INSERT INTO mtb_country (id, name, rank) VALUES (818,'エジプト',34);
+INSERT INTO mtb_country (id, name, rank) VALUES (233,'エストニア',35);
+INSERT INTO mtb_country (id, name, rank) VALUES (231,'エチオピア',36);
+INSERT INTO mtb_country (id, name, rank) VALUES (232,'エリトリア',37);
+INSERT INTO mtb_country (id, name, rank) VALUES (222,'エルサルバドル',38);
+INSERT INTO mtb_country (id, name, rank) VALUES (36,'オーストラリア',39);
+INSERT INTO mtb_country (id, name, rank) VALUES (40,'オーストリア',40);
+INSERT INTO mtb_country (id, name, rank) VALUES (248,'オーランド諸島',41);
+INSERT INTO mtb_country (id, name, rank) VALUES (512,'オマーン',42);
+INSERT INTO mtb_country (id, name, rank) VALUES (528,'オランダ',43);
+INSERT INTO mtb_country (id, name, rank) VALUES (288,'ガーナ',44);
+INSERT INTO mtb_country (id, name, rank) VALUES (132,'カーボベルデ',45);
+INSERT INTO mtb_country (id, name, rank) VALUES (831,'ガーンジー',46);
+INSERT INTO mtb_country (id, name, rank) VALUES (328,'ガイアナ',47);
+INSERT INTO mtb_country (id, name, rank) VALUES (398,'カザフスタン',48);
+INSERT INTO mtb_country (id, name, rank) VALUES (634,'カタール',49);
+INSERT INTO mtb_country (id, name, rank) VALUES (581,'合衆国領有小離島',50);
+INSERT INTO mtb_country (id, name, rank) VALUES (124,'カナダ',51);
+INSERT INTO mtb_country (id, name, rank) VALUES (266,'ガボン',52);
+INSERT INTO mtb_country (id, name, rank) VALUES (120,'カメルーン',53);
+INSERT INTO mtb_country (id, name, rank) VALUES (270,'ガンビア',54);
+INSERT INTO mtb_country (id, name, rank) VALUES (116,'カンボジア',55);
+INSERT INTO mtb_country (id, name, rank) VALUES (580,'北マリアナ諸島',56);
+INSERT INTO mtb_country (id, name, rank) VALUES (324,'ギニア',57);
+INSERT INTO mtb_country (id, name, rank) VALUES (624,'ギニアビサウ',58);
+INSERT INTO mtb_country (id, name, rank) VALUES (196,'キプロス',59);
+INSERT INTO mtb_country (id, name, rank) VALUES (192,'キューバ',60);
+INSERT INTO mtb_country (id, name, rank) VALUES (531,'キュラソー島|キュラソー',61);
+INSERT INTO mtb_country (id, name, rank) VALUES (300,'ギリシャ',62);
+INSERT INTO mtb_country (id, name, rank) VALUES (296,'キリバス',63);
+INSERT INTO mtb_country (id, name, rank) VALUES (417,'キルギス',64);
+INSERT INTO mtb_country (id, name, rank) VALUES (320,'グアテマラ',65);
+INSERT INTO mtb_country (id, name, rank) VALUES (312,'グアドループ',66);
+INSERT INTO mtb_country (id, name, rank) VALUES (316,'グアム',67);
+INSERT INTO mtb_country (id, name, rank) VALUES (414,'クウェート',68);
+INSERT INTO mtb_country (id, name, rank) VALUES (184,'クック諸島',69);
+INSERT INTO mtb_country (id, name, rank) VALUES (304,'グリーンランド',70);
+INSERT INTO mtb_country (id, name, rank) VALUES (162,'クリスマス島 (オーストラリア)|クリスマス島',71);
+INSERT INTO mtb_country (id, name, rank) VALUES (268,'グルジア',72);
+INSERT INTO mtb_country (id, name, rank) VALUES (308,'グレナダ',73);
+INSERT INTO mtb_country (id, name, rank) VALUES (191,'クロアチア',74);
+INSERT INTO mtb_country (id, name, rank) VALUES (136,'ケイマン諸島',75);
+INSERT INTO mtb_country (id, name, rank) VALUES (404,'ケニア',76);
+INSERT INTO mtb_country (id, name, rank) VALUES (384,'コートジボワール',77);
+INSERT INTO mtb_country (id, name, rank) VALUES (166,'ココス諸島|ココス（キーリング）諸島',78);
+INSERT INTO mtb_country (id, name, rank) VALUES (188,'コスタリカ',79);
+INSERT INTO mtb_country (id, name, rank) VALUES (174,'コモロ',80);
+INSERT INTO mtb_country (id, name, rank) VALUES (170,'コロンビア',81);
+INSERT INTO mtb_country (id, name, rank) VALUES (178,'コンゴ共和国',82);
+INSERT INTO mtb_country (id, name, rank) VALUES (180,'コンゴ民主共和国',83);
+INSERT INTO mtb_country (id, name, rank) VALUES (682,'サウジアラビア',84);
+INSERT INTO mtb_country (id, name, rank) VALUES (239,'サウスジョージア・サウスサンドウィッチ諸島',85);
+INSERT INTO mtb_country (id, name, rank) VALUES (882,'サモア',86);
+INSERT INTO mtb_country (id, name, rank) VALUES (678,'サントメ・プリンシペ',87);
+INSERT INTO mtb_country (id, name, rank) VALUES (652,'サン・バルテルミー島|サン・バルテルミー',88);
+INSERT INTO mtb_country (id, name, rank) VALUES (894,'ザンビア',89);
+INSERT INTO mtb_country (id, name, rank) VALUES (666,'サンピエール島・ミクロン島',90);
+INSERT INTO mtb_country (id, name, rank) VALUES (674,'サンマリノ',91);
+INSERT INTO mtb_country (id, name, rank) VALUES (663,'サン・マルタン (西インド諸島)|サン・マルタン（フランス領）',92);
+INSERT INTO mtb_country (id, name, rank) VALUES (694,'シエラレオネ',93);
+INSERT INTO mtb_country (id, name, rank) VALUES (262,'ジブチ',94);
+INSERT INTO mtb_country (id, name, rank) VALUES (292,'ジブラルタル',95);
+INSERT INTO mtb_country (id, name, rank) VALUES (832,'ジャージー',96);
+INSERT INTO mtb_country (id, name, rank) VALUES (388,'ジャマイカ',97);
+INSERT INTO mtb_country (id, name, rank) VALUES (760,'シリア|シリア・アラブ共和国',98);
+INSERT INTO mtb_country (id, name, rank) VALUES (702,'シンガポール',99);
+INSERT INTO mtb_country (id, name, rank) VALUES (534,'シント・マールテン|シント・マールテン（オランダ領）',100);
+INSERT INTO mtb_country (id, name, rank) VALUES (716,'ジンバブエ',101);
+INSERT INTO mtb_country (id, name, rank) VALUES (756,'スイス',102);
+INSERT INTO mtb_country (id, name, rank) VALUES (752,'スウェーデン',103);
+INSERT INTO mtb_country (id, name, rank) VALUES (729,'スーダン',104);
+INSERT INTO mtb_country (id, name, rank) VALUES (744,'スヴァールバル諸島およびヤンマイエン島',105);
+INSERT INTO mtb_country (id, name, rank) VALUES (724,'スペイン',106);
+INSERT INTO mtb_country (id, name, rank) VALUES (740,'スリナム',107);
+INSERT INTO mtb_country (id, name, rank) VALUES (144,'スリランカ',108);
+INSERT INTO mtb_country (id, name, rank) VALUES (703,'スロバキア',109);
+INSERT INTO mtb_country (id, name, rank) VALUES (705,'スロベニア',110);
+INSERT INTO mtb_country (id, name, rank) VALUES (748,'スワジランド',111);
+INSERT INTO mtb_country (id, name, rank) VALUES (690,'セーシェル',112);
+INSERT INTO mtb_country (id, name, rank) VALUES (226,'赤道ギニア',113);
+INSERT INTO mtb_country (id, name, rank) VALUES (686,'セネガル',114);
+INSERT INTO mtb_country (id, name, rank) VALUES (688,'セルビア',115);
+INSERT INTO mtb_country (id, name, rank) VALUES (659,'セントクリストファー・ネイビス',116);
+INSERT INTO mtb_country (id, name, rank) VALUES (670,'セントビンセント・グレナディーン|セントビンセントおよびグレナディーン諸島',117);
+INSERT INTO mtb_country (id, name, rank) VALUES (654,'セントヘレナ・アセンションおよびトリスタンダクーニャ',118);
+INSERT INTO mtb_country (id, name, rank) VALUES (662,'セントルシア',119);
+INSERT INTO mtb_country (id, name, rank) VALUES (706,'ソマリア',120);
+INSERT INTO mtb_country (id, name, rank) VALUES (90,'ソロモン諸島',121);
+INSERT INTO mtb_country (id, name, rank) VALUES (796,'タークス・カイコス諸島',122);
+INSERT INTO mtb_country (id, name, rank) VALUES (764,'タイ王国|タイ',123);
+INSERT INTO mtb_country (id, name, rank) VALUES (410,'大韓民国',124);
+INSERT INTO mtb_country (id, name, rank) VALUES (158,'台湾',125);
+INSERT INTO mtb_country (id, name, rank) VALUES (762,'タジキスタン',126);
+INSERT INTO mtb_country (id, name, rank) VALUES (834,'タンザニア',127);
+INSERT INTO mtb_country (id, name, rank) VALUES (203,'チェコ',128);
+INSERT INTO mtb_country (id, name, rank) VALUES (148,'チャド',129);
+INSERT INTO mtb_country (id, name, rank) VALUES (140,'中央アフリカ共和国',130);
+INSERT INTO mtb_country (id, name, rank) VALUES (156,'中華人民共和国|中国',131);
+INSERT INTO mtb_country (id, name, rank) VALUES (788,'チュニジア',132);
+INSERT INTO mtb_country (id, name, rank) VALUES (408,'朝鮮民主主義人民共和国',133);
+INSERT INTO mtb_country (id, name, rank) VALUES (152,'チリ',134);
+INSERT INTO mtb_country (id, name, rank) VALUES (798,'ツバル',135);
+INSERT INTO mtb_country (id, name, rank) VALUES (208,'デンマーク',136);
+INSERT INTO mtb_country (id, name, rank) VALUES (276,'ドイツ',137);
+INSERT INTO mtb_country (id, name, rank) VALUES (768,'トーゴ',138);
+INSERT INTO mtb_country (id, name, rank) VALUES (772,'トケラウ',139);
+INSERT INTO mtb_country (id, name, rank) VALUES (214,'ドミニカ共和国',140);
+INSERT INTO mtb_country (id, name, rank) VALUES (212,'ドミニカ国',141);
+INSERT INTO mtb_country (id, name, rank) VALUES (780,'トリニダード・トバゴ',142);
+INSERT INTO mtb_country (id, name, rank) VALUES (795,'トルクメニスタン',143);
+INSERT INTO mtb_country (id, name, rank) VALUES (792,'トルコ',144);
+INSERT INTO mtb_country (id, name, rank) VALUES (776,'トンガ',145);
+INSERT INTO mtb_country (id, name, rank) VALUES (566,'ナイジェリア',146);
+INSERT INTO mtb_country (id, name, rank) VALUES (520,'ナウル',147);
+INSERT INTO mtb_country (id, name, rank) VALUES (516,'ナミビア',148);
+INSERT INTO mtb_country (id, name, rank) VALUES (10,'南極',149);
+INSERT INTO mtb_country (id, name, rank) VALUES (570,'ニウエ',150);
+INSERT INTO mtb_country (id, name, rank) VALUES (558,'ニカラグア',151);
+INSERT INTO mtb_country (id, name, rank) VALUES (562,'ニジェール',152);
+INSERT INTO mtb_country (id, name, rank) VALUES (392,'日本',153);
+INSERT INTO mtb_country (id, name, rank) VALUES (732,'西サハラ',154);
+INSERT INTO mtb_country (id, name, rank) VALUES (540,'ニューカレドニア',155);
+INSERT INTO mtb_country (id, name, rank) VALUES (554,'ニュージーランド',156);
+INSERT INTO mtb_country (id, name, rank) VALUES (524,'ネパール',157);
+INSERT INTO mtb_country (id, name, rank) VALUES (574,'ノーフォーク島',158);
+INSERT INTO mtb_country (id, name, rank) VALUES (578,'ノルウェー',159);
+INSERT INTO mtb_country (id, name, rank) VALUES (334,'ハード島とマクドナルド諸島',160);
+INSERT INTO mtb_country (id, name, rank) VALUES (48,'バーレーン',161);
+INSERT INTO mtb_country (id, name, rank) VALUES (332,'ハイチ',162);
+INSERT INTO mtb_country (id, name, rank) VALUES (586,'パキスタン',163);
+INSERT INTO mtb_country (id, name, rank) VALUES (336,'バチカン|バチカン市国',164);
+INSERT INTO mtb_country (id, name, rank) VALUES (591,'パナマ',165);
+INSERT INTO mtb_country (id, name, rank) VALUES (548,'バヌアツ',166);
+INSERT INTO mtb_country (id, name, rank) VALUES (44,'バハマ',167);
+INSERT INTO mtb_country (id, name, rank) VALUES (598,'パプアニューギニア',168);
+INSERT INTO mtb_country (id, name, rank) VALUES (60,'バミューダ諸島|バミューダ',169);
+INSERT INTO mtb_country (id, name, rank) VALUES (585,'パラオ',170);
+INSERT INTO mtb_country (id, name, rank) VALUES (600,'パラグアイ',171);
+INSERT INTO mtb_country (id, name, rank) VALUES (52,'バルバドス',172);
+INSERT INTO mtb_country (id, name, rank) VALUES (275,'パレスチナ',173);
+INSERT INTO mtb_country (id, name, rank) VALUES (348,'ハンガリー',174);
+INSERT INTO mtb_country (id, name, rank) VALUES (50,'バングラデシュ',175);
+INSERT INTO mtb_country (id, name, rank) VALUES (626,'東ティモール',176);
+INSERT INTO mtb_country (id, name, rank) VALUES (612,'ピトケアン諸島|ピトケアン',177);
+INSERT INTO mtb_country (id, name, rank) VALUES (242,'フィジー',178);
+INSERT INTO mtb_country (id, name, rank) VALUES (608,'フィリピン',179);
+INSERT INTO mtb_country (id, name, rank) VALUES (246,'フィンランド',180);
+INSERT INTO mtb_country (id, name, rank) VALUES (64,'ブータン',181);
+INSERT INTO mtb_country (id, name, rank) VALUES (74,'ブーベ島',182);
+INSERT INTO mtb_country (id, name, rank) VALUES (630,'プエルトリコ',183);
+INSERT INTO mtb_country (id, name, rank) VALUES (234,'フェロー諸島',184);
+INSERT INTO mtb_country (id, name, rank) VALUES (238,'フォークランド諸島|フォークランド（マルビナス）諸島',185);
+INSERT INTO mtb_country (id, name, rank) VALUES (76,'ブラジル',186);
+INSERT INTO mtb_country (id, name, rank) VALUES (250,'フランス',187);
+INSERT INTO mtb_country (id, name, rank) VALUES (254,'フランス領ギアナ',188);
+INSERT INTO mtb_country (id, name, rank) VALUES (258,'フランス領ポリネシア',189);
+INSERT INTO mtb_country (id, name, rank) VALUES (260,'フランス領南方・南極地域',190);
+INSERT INTO mtb_country (id, name, rank) VALUES (100,'ブルガリア',191);
+INSERT INTO mtb_country (id, name, rank) VALUES (854,'ブルキナファソ',192);
+INSERT INTO mtb_country (id, name, rank) VALUES (96,'ブルネイ|ブルネイ・ダルサラーム',193);
+INSERT INTO mtb_country (id, name, rank) VALUES (108,'ブルンジ',194);
+INSERT INTO mtb_country (id, name, rank) VALUES (704,'ベトナム',195);
+INSERT INTO mtb_country (id, name, rank) VALUES (204,'ベナン',196);
+INSERT INTO mtb_country (id, name, rank) VALUES (862,'ベネズエラ|ベネズエラ・ボリバル共和国',197);
+INSERT INTO mtb_country (id, name, rank) VALUES (112,'ベラルーシ',198);
+INSERT INTO mtb_country (id, name, rank) VALUES (84,'ベリーズ',199);
+INSERT INTO mtb_country (id, name, rank) VALUES (604,'ペルー',200);
+INSERT INTO mtb_country (id, name, rank) VALUES (56,'ベルギー',201);
+INSERT INTO mtb_country (id, name, rank) VALUES (616,'ポーランド',202);
+INSERT INTO mtb_country (id, name, rank) VALUES (70,'ボスニア・ヘルツェゴビナ',203);
+INSERT INTO mtb_country (id, name, rank) VALUES (72,'ボツワナ',204);
+INSERT INTO mtb_country (id, name, rank) VALUES (535,'BES諸島|ボネール、シント・ユースタティウスおよびサバ',205);
+INSERT INTO mtb_country (id, name, rank) VALUES (68,'ボリビア|ボリビア多民族国',206);
+INSERT INTO mtb_country (id, name, rank) VALUES (620,'ポルトガル',207);
+INSERT INTO mtb_country (id, name, rank) VALUES (344,'香港',208);
+INSERT INTO mtb_country (id, name, rank) VALUES (340,'ホンジュラス',209);
+INSERT INTO mtb_country (id, name, rank) VALUES (584,'マーシャル諸島',210);
+INSERT INTO mtb_country (id, name, rank) VALUES (446,'マカオ',211);
+INSERT INTO mtb_country (id, name, rank) VALUES (807,'マケドニア共和国|マケドニア旧ユーゴスラビア共和国',212);
+INSERT INTO mtb_country (id, name, rank) VALUES (450,'マダガスカル',213);
+INSERT INTO mtb_country (id, name, rank) VALUES (175,'マヨット',214);
+INSERT INTO mtb_country (id, name, rank) VALUES (454,'マラウイ',215);
+INSERT INTO mtb_country (id, name, rank) VALUES (466,'マリ共和国|マリ',216);
+INSERT INTO mtb_country (id, name, rank) VALUES (470,'マルタ',217);
+INSERT INTO mtb_country (id, name, rank) VALUES (474,'マルティニーク',218);
+INSERT INTO mtb_country (id, name, rank) VALUES (458,'マレーシア',219);
+INSERT INTO mtb_country (id, name, rank) VALUES (833,'マン島',220);
+INSERT INTO mtb_country (id, name, rank) VALUES (583,'ミクロネシア連邦',221);
+INSERT INTO mtb_country (id, name, rank) VALUES (710,'南アフリカ共和国|南アフリカ',222);
+INSERT INTO mtb_country (id, name, rank) VALUES (728,'南スーダン',223);
+INSERT INTO mtb_country (id, name, rank) VALUES (104,'ミャンマー',224);
+INSERT INTO mtb_country (id, name, rank) VALUES (484,'メキシコ',225);
+INSERT INTO mtb_country (id, name, rank) VALUES (480,'モーリシャス',226);
+INSERT INTO mtb_country (id, name, rank) VALUES (478,'モーリタニア',227);
+INSERT INTO mtb_country (id, name, rank) VALUES (508,'モザンビーク',228);
+INSERT INTO mtb_country (id, name, rank) VALUES (492,'モナコ',229);
+INSERT INTO mtb_country (id, name, rank) VALUES (462,'モルディブ',230);
+INSERT INTO mtb_country (id, name, rank) VALUES (498,'モルドバ|モルドバ共和国',231);
+INSERT INTO mtb_country (id, name, rank) VALUES (504,'モロッコ',232);
+INSERT INTO mtb_country (id, name, rank) VALUES (496,'モンゴル国|モンゴル',233);
+INSERT INTO mtb_country (id, name, rank) VALUES (499,'モンテネグロ',234);
+INSERT INTO mtb_country (id, name, rank) VALUES (500,'モントセラト',235);
+INSERT INTO mtb_country (id, name, rank) VALUES (400,'ヨルダン',236);
+INSERT INTO mtb_country (id, name, rank) VALUES (418,'ラオス|ラオス人民民主共和国',237);
+INSERT INTO mtb_country (id, name, rank) VALUES (428,'ラトビア',238);
+INSERT INTO mtb_country (id, name, rank) VALUES (440,'リトアニア',239);
+INSERT INTO mtb_country (id, name, rank) VALUES (434,'リビア',240);
+INSERT INTO mtb_country (id, name, rank) VALUES (438,'リヒテンシュタイン',241);
+INSERT INTO mtb_country (id, name, rank) VALUES (430,'リベリア',242);
+INSERT INTO mtb_country (id, name, rank) VALUES (642,'ルーマニア',243);
+INSERT INTO mtb_country (id, name, rank) VALUES (442,'ルクセンブルク',244);
+INSERT INTO mtb_country (id, name, rank) VALUES (646,'ルワンダ',245);
+INSERT INTO mtb_country (id, name, rank) VALUES (426,'レソト',246);
+INSERT INTO mtb_country (id, name, rank) VALUES (422,'レバノン',247);
+INSERT INTO mtb_country (id, name, rank) VALUES (638,'レユニオン',248);
+INSERT INTO mtb_country (id, name, rank) VALUES (643,'ロシア|ロシア連邦',249);
Index: branches/version-2_13-dev/html/install/sql/create_table_mysql.sql
===================================================================
--- branches/version-2_13-dev/html/install/sql/create_table_mysql.sql (revision 22218)
+++ branches/version-2_13-dev/html/install/sql/create_table_mysql.sql (revision 22736)
@@ -74,4 +74,5 @@
zip01 text,
zip02 text,
+ country_id int,
pref smallint,
addr01 text,
@@ -88,4 +89,5 @@
law_zip01 text,
law_zip02 text,
+ law_country_id int,
law_pref smallint,
law_addr01 text,
@@ -109,6 +111,4 @@
law_term09 text,
law_term10 text,
- tax numeric NOT NULL DEFAULT 5,
- tax_rule smallint NOT NULL DEFAULT 1,
email01 text,
email02 text,
@@ -485,4 +485,5 @@
zip01 text,
zip02 text,
+ country_id int,
pref smallint,
addr01 text,
@@ -538,4 +539,5 @@
order_zip01 text,
order_zip02 text,
+ order_country_id int,
order_pref smallint,
order_addr01 text,
@@ -597,4 +599,5 @@
order_zip01 text,
order_zip02 text,
+ order_country_id int,
order_pref smallint,
order_addr01 text,
@@ -655,4 +658,5 @@
shipping_fax02 text,
shipping_fax03 text,
+ shipping_country_id int,
shipping_pref smallint,
shipping_zip01 text,
@@ -694,4 +698,5 @@
zip01 text,
zip02 text,
+ country_id int,
pref smallint,
addr01 text,
@@ -1100,4 +1105,11 @@
name text,
rank smallint NOT NULL,
+ PRIMARY KEY (id)
+);
+
+CREATE TABLE mtb_country (
+ id int,
+ name text,
+ rank int NOT NULL,
PRIMARY KEY (id)
);
@@ -1204,4 +1216,20 @@
);
+CREATE TABLE dtb_tax_rule (
+ tax_rule_id int NOT NULL,
+ country_id int NOT NULL DEFAULT 0,
+ pref_id int NOT NULL DEFAULT 0,
+ product_id int NOT NULL DEFAULT 0,
+ product_class_id int NOT NULL DEFAULT 0,
+ calc_rule smallint NOT NULL DEFAULT 1,
+ tax_rate numeric NOT NULL DEFAULT 5,
+ tax_adjust numeric NOT NULL DEFAULT 0,
+ apply_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ member_id int NOT NULL,
+ del_flg smallint NOT NULL DEFAULT 0,
+ create_date timestamp NOT NULL,
+ update_date timestamp NOT NULL,
+ PRIMARY KEY (tax_rule_id)
+);
CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id(255));
Index: branches/version-2_13-dev/html/install/sql/create_table_pgsql.sql
===================================================================
--- branches/version-2_13-dev/html/install/sql/create_table_pgsql.sql (revision 22218)
+++ branches/version-2_13-dev/html/install/sql/create_table_pgsql.sql (revision 22736)
@@ -74,4 +74,5 @@
zip01 text,
zip02 text,
+ country_id int,
pref smallint,
addr01 text,
@@ -88,4 +89,5 @@
law_zip01 text,
law_zip02 text,
+ law_country_id int,
law_pref smallint,
law_addr01 text,
@@ -109,6 +111,4 @@
law_term09 text,
law_term10 text,
- tax numeric NOT NULL DEFAULT 5,
- tax_rule smallint NOT NULL DEFAULT 1,
email01 text,
email02 text,
@@ -485,4 +485,5 @@
zip01 text,
zip02 text,
+ country_id int,
pref smallint,
addr01 text,
@@ -538,4 +539,5 @@
order_zip01 text,
order_zip02 text,
+ order_country_id int,
order_pref smallint,
order_addr01 text,
@@ -597,4 +599,5 @@
order_zip01 text,
order_zip02 text,
+ order_country_id int,
order_pref smallint,
order_addr01 text,
@@ -655,4 +658,5 @@
shipping_fax02 text,
shipping_fax03 text,
+ shipping_country_id int,
shipping_pref smallint,
shipping_zip01 text,
@@ -694,4 +698,5 @@
zip01 text,
zip02 text,
+ country_id int,
pref smallint,
addr01 text,
@@ -1100,4 +1105,11 @@
name text,
rank smallint NOT NULL,
+ PRIMARY KEY (id)
+);
+
+CREATE TABLE mtb_country (
+ id int,
+ name text,
+ rank int NOT NULL,
PRIMARY KEY (id)
);
@@ -1204,4 +1216,20 @@
);
+CREATE TABLE dtb_tax_rule (
+ tax_rule_id int NOT NULL,
+ country_id int NOT NULL DEFAULT 0,
+ pref_id int NOT NULL DEFAULT 0,
+ product_id int NOT NULL DEFAULT 0,
+ product_class_id int NOT NULL DEFAULT 0,
+ calc_rule smallint NOT NULL DEFAULT 1,
+ tax_rate numeric NOT NULL DEFAULT 5,
+ tax_adjust numeric NOT NULL DEFAULT 0,
+ apply_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ member_id int NOT NULL,
+ del_flg smallint NOT NULL DEFAULT 0,
+ create_date timestamp NOT NULL,
+ update_date timestamp NOT NULL,
+ PRIMARY KEY (tax_rule_id)
+);
CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id);