Changeset 22637


Ignore:
Timestamp:
2013/03/09 18:40:25 (11 years ago)
Author:
tao
Message:

とりあえず国マスタと会員情報に国IDを追加

Location:
branches/camp/camp-2_13-tax
Files:
6 edited

Legend:

Unmodified
Added
Removed
  • branches/camp/camp-2_13-tax/data/class/helper/SC_Helper_Customer.php

    r22569 r22637  
    9696            } 
    9797        } 
     98         
     99        //デフォルト国IDを追加 
     100        $arrData['contry_id'] = DEFAULT_COUNTRY_ID; 
    98101 
    99102        //-- 編集登録実行 
  • branches/camp/camp-2_13-tax/html/install/index.php

    r22619 r22637  
    3131    while (ob_end_clean()); 
    3232} 
     33 
     34define("DEFAULT_COUNTRY_ID",392); 
     35 
    3336require_once HTML_REALDIR . HTML2DATA_DIR . 'require_base.php'; 
    3437ob_start(); 
     
    577580    $sqlval['mypage_tpl'] = 'default1'; 
    578581    $sqlval['update_date'] = 'CURRENT_TIMESTAMP'; 
     582    $sqlval['country_id'] = DEFAULT_COUNTRY_ID; 
    579583    $objQuery = new SC_Query($arrDsn); 
    580584    $cnt = $objQuery->count('dtb_baseinfo'); 
  • branches/camp/camp-2_13-tax/html/install/sql/create_table_mysql.sql

    r22619 r22637  
    7474    zip01 text, 
    7575    zip02 text, 
     76    country_id int, 
    7677    pref smallint, 
    7778    addr01 text, 
     
    8889    law_zip01 text, 
    8990    law_zip02 text, 
     91    law_country_id int, 
    9092    law_pref smallint, 
    9193    law_addr01 text, 
     
    485487    zip01 text, 
    486488    zip02 text, 
     489    country_id int, 
    487490    pref smallint, 
    488491    addr01 text, 
     
    538541    order_zip01 text, 
    539542    order_zip02 text, 
     543    order_country_id int, 
    540544    order_pref smallint, 
    541545    order_addr01 text, 
     
    597601    order_zip01 text, 
    598602    order_zip02 text, 
     603    order_country_id int, 
    599604    order_pref smallint, 
    600605    order_addr01 text, 
     
    655660    shipping_fax02 text, 
    656661    shipping_fax03 text, 
     662    shipping_country_id int, 
    657663    shipping_pref smallint, 
    658664    shipping_zip01 text, 
     
    694700    zip01 text, 
    695701    zip02 text, 
     702    country_id int, 
    696703    pref smallint, 
    697704    addr01 text, 
     
    11001107    name text, 
    11011108    rank smallint NOT NULL, 
     1109    PRIMARY KEY (id) 
     1110); 
     1111 
     1112CREATE TABLE mtb_country ( 
     1113    id int, 
     1114    name text, 
     1115    rank int NOT NULL, 
    11021116    PRIMARY KEY (id) 
    11031117); 
  • branches/camp/camp-2_13-tax/html/install/sql/create_table_pgsql.sql

    r22619 r22637  
    7474    zip01 text, 
    7575    zip02 text, 
     76    country_id int, 
    7677    pref smallint, 
    7778    addr01 text, 
     
    8889    law_zip01 text, 
    8990    law_zip02 text, 
     91    law_country_id int, 
    9092    law_pref smallint, 
    9193    law_addr01 text, 
     
    485487    zip01 text, 
    486488    zip02 text, 
     489    country_id int, 
    487490    pref smallint, 
    488491    addr01 text, 
     
    538541    order_zip01 text, 
    539542    order_zip02 text, 
     543    order_country_id int, 
    540544    order_pref smallint, 
    541545    order_addr01 text, 
     
    597601    order_zip01 text, 
    598602    order_zip02 text, 
     603    order_country_id int, 
    599604    order_pref smallint, 
    600605    order_addr01 text, 
     
    655660    shipping_fax02 text, 
    656661    shipping_fax03 text, 
     662    shipping_country_id int, 
    657663    shipping_pref smallint, 
    658664    shipping_zip01 text, 
     
    694700    zip01 text, 
    695701    zip02 text, 
     702    country_id int, 
    696703    pref smallint, 
    697704    addr01 text, 
     
    11001107    name text, 
    11011108    rank smallint NOT NULL, 
     1109    PRIMARY KEY (id) 
     1110); 
     1111 
     1112CREATE TABLE mtb_country ( 
     1113    id int, 
     1114    name text, 
     1115    rank int NOT NULL, 
    11021116    PRIMARY KEY (id) 
    11031117); 
  • branches/camp/camp-2_13-tax/html/install/sql/drop_table.sql

    r22619 r22637  
    9797DROP TABLE dtb_api_account; 
    9898DROP TABLE dtb_tax_rule; 
     99DROP TABLE mtb_country; 
  • branches/camp/camp-2_13-tax/html/install/sql/insert_data.sql

    r22619 r22637  
    12551255INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('LOGIN_RETRY_INTERVAL', '0', 1411, 'ログイン失敗時の遅延時間(秒)(ブルートフォースアタック対策)'); 
    12561256INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MYPAGE_ORDER_STATUS_DISP_FLAG', 'true', 1412, 'MYページ:ご注文状況表示フラグ'); 
     1257INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DEFAULT_COUNTRY_ID', 392, 1413, 'デフォルト国コード ISO_3166-1に準拠'); 
     1258 
    12571259 
    12581260INSERT INTO dtb_index_list (table_name, column_name, recommend_flg, recommend_comment) VALUES ('dtb_customer', 'email_mobile', 0, '会員数増加時のログイン処理速度を向上させたいときに試してみてください'); 
     
    12801282INSERT INTO dtb_index_list (table_name, column_name, recommend_flg, recommend_comment) VALUES ('mtb_zip', 'zipcode', 2, '郵便番号検索が遅いときに試してみてください。郵便番号データの更新時には無効にしていることをおすすめします。'); 
    12811283INSERT INTO dtb_tax_rule (tax_rule_id, country_id, pref_id, product_id, product_class_id, calc_rule, tax_rate, tax_adjust, apply_date, del_flg, create_date,update_date) VALUES (0, 0, 0, 0, 0, 1, 5, 0, NULL, 0, CURRENT_TIMESTAMP,CURRENT_TIMESTAMP); 
     1284INSERT INTO mtb_ccontry (id, name, rank) VALUES (352,'アイスランド',1); 
     1285INSERT INTO mtb_ccontry (id, name, rank) VALUES (372,'アイルランド',2); 
     1286INSERT INTO mtb_ccontry (id, name, rank) VALUES (31,'アゼルバイジャン',3); 
     1287INSERT INTO mtb_ccontry (id, name, rank) VALUES (4,'アフガニスタン',4); 
     1288INSERT INTO mtb_ccontry (id, name, rank) VALUES (840,'アメリカ合衆国',5); 
     1289INSERT INTO mtb_ccontry (id, name, rank) VALUES (850,'アメリカ領ヴァージン諸島',6); 
     1290INSERT INTO mtb_ccontry (id, name, rank) VALUES (16,'アメリカ領サモア',7); 
     1291INSERT INTO mtb_ccontry (id, name, rank) VALUES (784,'アラブ首長国連邦',8); 
     1292INSERT INTO mtb_ccontry (id, name, rank) VALUES (12,'アルジェリア',9); 
     1293INSERT INTO mtb_ccontry (id, name, rank) VALUES (32,'アルゼンチン',10); 
     1294INSERT INTO mtb_ccontry (id, name, rank) VALUES (533,'アルバ',11); 
     1295INSERT INTO mtb_ccontry (id, name, rank) VALUES (8,'アルバニア',12); 
     1296INSERT INTO mtb_ccontry (id, name, rank) VALUES (51,'アルメニア',13); 
     1297INSERT INTO mtb_ccontry (id, name, rank) VALUES (660,'アンギラ',14); 
     1298INSERT INTO mtb_ccontry (id, name, rank) VALUES (24,'アンゴラ',15); 
     1299INSERT INTO mtb_ccontry (id, name, rank) VALUES (28,'アンティグア・バーブーダ',16); 
     1300INSERT INTO mtb_ccontry (id, name, rank) VALUES (20,'アンドラ',17); 
     1301INSERT INTO mtb_ccontry (id, name, rank) VALUES (887,'イエメン',18); 
     1302INSERT INTO mtb_ccontry (id, name, rank) VALUES (826,'イギリス',19); 
     1303INSERT INTO mtb_ccontry (id, name, rank) VALUES (86,'イギリス領インド洋地域',20); 
     1304INSERT INTO mtb_ccontry (id, name, rank) VALUES (92,'イギリス領ヴァージン諸島',21); 
     1305INSERT INTO mtb_ccontry (id, name, rank) VALUES (376,'イスラエル',22); 
     1306INSERT INTO mtb_ccontry (id, name, rank) VALUES (380,'イタリア',23); 
     1307INSERT INTO mtb_ccontry (id, name, rank) VALUES (368,'イラク',24); 
     1308INSERT INTO mtb_ccontry (id, name, rank) VALUES (364,'イラン|イラン・イスラム共和国',25); 
     1309INSERT INTO mtb_ccontry (id, name, rank) VALUES (356,'インド',26); 
     1310INSERT INTO mtb_ccontry (id, name, rank) VALUES (360,'インドネシア',27); 
     1311INSERT INTO mtb_ccontry (id, name, rank) VALUES (876,'ウォリス・フツナ',28); 
     1312INSERT INTO mtb_ccontry (id, name, rank) VALUES (800,'ウガンダ',29); 
     1313INSERT INTO mtb_ccontry (id, name, rank) VALUES (804,'ウクライナ',30); 
     1314INSERT INTO mtb_ccontry (id, name, rank) VALUES (860,'ウズベキスタン',31); 
     1315INSERT INTO mtb_ccontry (id, name, rank) VALUES (858,'ウルグアイ',32); 
     1316INSERT INTO mtb_ccontry (id, name, rank) VALUES (218,'エクアドル',33); 
     1317INSERT INTO mtb_ccontry (id, name, rank) VALUES (818,'エジプト',34); 
     1318INSERT INTO mtb_ccontry (id, name, rank) VALUES (233,'エストニア',35); 
     1319INSERT INTO mtb_ccontry (id, name, rank) VALUES (231,'エチオピア',36); 
     1320INSERT INTO mtb_ccontry (id, name, rank) VALUES (232,'エリトリア',37); 
     1321INSERT INTO mtb_ccontry (id, name, rank) VALUES (222,'エルサルバドル',38); 
     1322INSERT INTO mtb_ccontry (id, name, rank) VALUES (36,'オーストラリア',39); 
     1323INSERT INTO mtb_ccontry (id, name, rank) VALUES (40,'オーストリア',40); 
     1324INSERT INTO mtb_ccontry (id, name, rank) VALUES (248,'オーランド諸島',41); 
     1325INSERT INTO mtb_ccontry (id, name, rank) VALUES (512,'オマーン',42); 
     1326INSERT INTO mtb_ccontry (id, name, rank) VALUES (528,'オランダ',43); 
     1327INSERT INTO mtb_ccontry (id, name, rank) VALUES (288,'ガーナ',44); 
     1328INSERT INTO mtb_ccontry (id, name, rank) VALUES (132,'カーボベルデ',45); 
     1329INSERT INTO mtb_ccontry (id, name, rank) VALUES (831,'ガーンジー',46); 
     1330INSERT INTO mtb_ccontry (id, name, rank) VALUES (328,'ガイアナ',47); 
     1331INSERT INTO mtb_ccontry (id, name, rank) VALUES (398,'カザフスタン',48); 
     1332INSERT INTO mtb_ccontry (id, name, rank) VALUES (634,'カタール',49); 
     1333INSERT INTO mtb_ccontry (id, name, rank) VALUES (581,'合衆国領有小離島',50); 
     1334INSERT INTO mtb_ccontry (id, name, rank) VALUES (124,'カナダ',51); 
     1335INSERT INTO mtb_ccontry (id, name, rank) VALUES (266,'ガボン',52); 
     1336INSERT INTO mtb_ccontry (id, name, rank) VALUES (120,'カメルーン',53); 
     1337INSERT INTO mtb_ccontry (id, name, rank) VALUES (270,'ガンビア',54); 
     1338INSERT INTO mtb_ccontry (id, name, rank) VALUES (116,'カンボジア',55); 
     1339INSERT INTO mtb_ccontry (id, name, rank) VALUES (580,'北マリアナ諸島',56); 
     1340INSERT INTO mtb_ccontry (id, name, rank) VALUES (324,'ギニア',57); 
     1341INSERT INTO mtb_ccontry (id, name, rank) VALUES (624,'ギニアビサウ',58); 
     1342INSERT INTO mtb_ccontry (id, name, rank) VALUES (196,'キプロス',59); 
     1343INSERT INTO mtb_ccontry (id, name, rank) VALUES (192,'キューバ',60); 
     1344INSERT INTO mtb_ccontry (id, name, rank) VALUES (531,'キュラソー島|キュラソー',61); 
     1345INSERT INTO mtb_ccontry (id, name, rank) VALUES (300,'ギリシャ',62); 
     1346INSERT INTO mtb_ccontry (id, name, rank) VALUES (296,'キリバス',63); 
     1347INSERT INTO mtb_ccontry (id, name, rank) VALUES (417,'キルギス',64); 
     1348INSERT INTO mtb_ccontry (id, name, rank) VALUES (320,'グアテマラ',65); 
     1349INSERT INTO mtb_ccontry (id, name, rank) VALUES (312,'グアドループ',66); 
     1350INSERT INTO mtb_ccontry (id, name, rank) VALUES (316,'グアム',67); 
     1351INSERT INTO mtb_ccontry (id, name, rank) VALUES (414,'クウェート',68); 
     1352INSERT INTO mtb_ccontry (id, name, rank) VALUES (184,'クック諸島',69); 
     1353INSERT INTO mtb_ccontry (id, name, rank) VALUES (304,'グリーンランド',70); 
     1354INSERT INTO mtb_ccontry (id, name, rank) VALUES (162,'クリスマス島 (オーストラリア)|クリスマス島',71); 
     1355INSERT INTO mtb_ccontry (id, name, rank) VALUES (268,'グルジア',72); 
     1356INSERT INTO mtb_ccontry (id, name, rank) VALUES (308,'グレナダ',73); 
     1357INSERT INTO mtb_ccontry (id, name, rank) VALUES (191,'クロアチア',74); 
     1358INSERT INTO mtb_ccontry (id, name, rank) VALUES (136,'ケイマン諸島',75); 
     1359INSERT INTO mtb_ccontry (id, name, rank) VALUES (404,'ケニア',76); 
     1360INSERT INTO mtb_ccontry (id, name, rank) VALUES (384,'コートジボワール',77); 
     1361INSERT INTO mtb_ccontry (id, name, rank) VALUES (166,'ココス諸島|ココス(キーリング)諸島',78); 
     1362INSERT INTO mtb_ccontry (id, name, rank) VALUES (188,'コスタリカ',79); 
     1363INSERT INTO mtb_ccontry (id, name, rank) VALUES (174,'コモロ',80); 
     1364INSERT INTO mtb_ccontry (id, name, rank) VALUES (170,'コロンビア',81); 
     1365INSERT INTO mtb_ccontry (id, name, rank) VALUES (178,'コンゴ共和国',82); 
     1366INSERT INTO mtb_ccontry (id, name, rank) VALUES (180,'コンゴ民主共和国',83); 
     1367INSERT INTO mtb_ccontry (id, name, rank) VALUES (682,'サウジアラビア',84); 
     1368INSERT INTO mtb_ccontry (id, name, rank) VALUES (239,'サウスジョージア・サウスサンドウィッチ諸島',85); 
     1369INSERT INTO mtb_ccontry (id, name, rank) VALUES (882,'サモア',86); 
     1370INSERT INTO mtb_ccontry (id, name, rank) VALUES (678,'サントメ・プリンシペ',87); 
     1371INSERT INTO mtb_ccontry (id, name, rank) VALUES (652,'サン・バルテルミー島|サン・バルテルミー',88); 
     1372INSERT INTO mtb_ccontry (id, name, rank) VALUES (894,'ザンビア',89); 
     1373INSERT INTO mtb_ccontry (id, name, rank) VALUES (666,'サンピエール島・ミクロン島',90); 
     1374INSERT INTO mtb_ccontry (id, name, rank) VALUES (674,'サンマリノ',91); 
     1375INSERT INTO mtb_ccontry (id, name, rank) VALUES (663,'サン・マルタン (西インド諸島)|サン・マルタン(フランス領)',92); 
     1376INSERT INTO mtb_ccontry (id, name, rank) VALUES (694,'シエラレオネ',93); 
     1377INSERT INTO mtb_ccontry (id, name, rank) VALUES (262,'ジブチ',94); 
     1378INSERT INTO mtb_ccontry (id, name, rank) VALUES (292,'ジブラルタル',95); 
     1379INSERT INTO mtb_ccontry (id, name, rank) VALUES (832,'ジャージー',96); 
     1380INSERT INTO mtb_ccontry (id, name, rank) VALUES (388,'ジャマイカ',97); 
     1381INSERT INTO mtb_ccontry (id, name, rank) VALUES (760,'シリア|シリア・アラブ共和国',98); 
     1382INSERT INTO mtb_ccontry (id, name, rank) VALUES (702,'シンガポール',99); 
     1383INSERT INTO mtb_ccontry (id, name, rank) VALUES (534,'シント・マールテン|シント・マールテン(オランダ領)',100); 
     1384INSERT INTO mtb_ccontry (id, name, rank) VALUES (716,'ジンバブエ',101); 
     1385INSERT INTO mtb_ccontry (id, name, rank) VALUES (756,'スイス',102); 
     1386INSERT INTO mtb_ccontry (id, name, rank) VALUES (752,'スウェーデン',103); 
     1387INSERT INTO mtb_ccontry (id, name, rank) VALUES (729,'スーダン',104); 
     1388INSERT INTO mtb_ccontry (id, name, rank) VALUES (744,'スヴァールバル諸島およびヤンマイエン島',105); 
     1389INSERT INTO mtb_ccontry (id, name, rank) VALUES (724,'スペイン',106); 
     1390INSERT INTO mtb_ccontry (id, name, rank) VALUES (740,'スリナム',107); 
     1391INSERT INTO mtb_ccontry (id, name, rank) VALUES (144,'スリランカ',108); 
     1392INSERT INTO mtb_ccontry (id, name, rank) VALUES (703,'スロバキア',109); 
     1393INSERT INTO mtb_ccontry (id, name, rank) VALUES (705,'スロベニア',110); 
     1394INSERT INTO mtb_ccontry (id, name, rank) VALUES (748,'スワジランド',111); 
     1395INSERT INTO mtb_ccontry (id, name, rank) VALUES (690,'セーシェル',112); 
     1396INSERT INTO mtb_ccontry (id, name, rank) VALUES (226,'赤道ギニア',113); 
     1397INSERT INTO mtb_ccontry (id, name, rank) VALUES (686,'セネガル',114); 
     1398INSERT INTO mtb_ccontry (id, name, rank) VALUES (688,'セルビア',115); 
     1399INSERT INTO mtb_ccontry (id, name, rank) VALUES (659,'セントクリストファー・ネイビス',116); 
     1400INSERT INTO mtb_ccontry (id, name, rank) VALUES (670,'セントビンセント・グレナディーン|セントビンセントおよびグレナディーン諸島',117); 
     1401INSERT INTO mtb_ccontry (id, name, rank) VALUES (654,'セントヘレナ・アセンションおよびトリスタンダクーニャ',118); 
     1402INSERT INTO mtb_ccontry (id, name, rank) VALUES (662,'セントルシア',119); 
     1403INSERT INTO mtb_ccontry (id, name, rank) VALUES (706,'ソマリア',120); 
     1404INSERT INTO mtb_ccontry (id, name, rank) VALUES (90,'ソロモン諸島',121); 
     1405INSERT INTO mtb_ccontry (id, name, rank) VALUES (796,'タークス・カイコス諸島',122); 
     1406INSERT INTO mtb_ccontry (id, name, rank) VALUES (764,'タイ王国|タイ',123); 
     1407INSERT INTO mtb_ccontry (id, name, rank) VALUES (410,'大韓民国',124); 
     1408INSERT INTO mtb_ccontry (id, name, rank) VALUES (158,'台湾',125); 
     1409INSERT INTO mtb_ccontry (id, name, rank) VALUES (762,'タジキスタン',126); 
     1410INSERT INTO mtb_ccontry (id, name, rank) VALUES (834,'タンザニア',127); 
     1411INSERT INTO mtb_ccontry (id, name, rank) VALUES (203,'チェコ',128); 
     1412INSERT INTO mtb_ccontry (id, name, rank) VALUES (148,'チャド',129); 
     1413INSERT INTO mtb_ccontry (id, name, rank) VALUES (140,'中央アフリカ共和国',130); 
     1414INSERT INTO mtb_ccontry (id, name, rank) VALUES (156,'中華人民共和国|中国',131); 
     1415INSERT INTO mtb_ccontry (id, name, rank) VALUES (788,'チュニジア',132); 
     1416INSERT INTO mtb_ccontry (id, name, rank) VALUES (408,'朝鮮民主主義人民共和国',133); 
     1417INSERT INTO mtb_ccontry (id, name, rank) VALUES (152,'チリ',134); 
     1418INSERT INTO mtb_ccontry (id, name, rank) VALUES (798,'ツバル',135); 
     1419INSERT INTO mtb_ccontry (id, name, rank) VALUES (208,'デンマーク',136); 
     1420INSERT INTO mtb_ccontry (id, name, rank) VALUES (276,'ドイツ',137); 
     1421INSERT INTO mtb_ccontry (id, name, rank) VALUES (768,'トーゴ',138); 
     1422INSERT INTO mtb_ccontry (id, name, rank) VALUES (772,'トケラウ',139); 
     1423INSERT INTO mtb_ccontry (id, name, rank) VALUES (214,'ドミニカ共和国',140); 
     1424INSERT INTO mtb_ccontry (id, name, rank) VALUES (212,'ドミニカ国',141); 
     1425INSERT INTO mtb_ccontry (id, name, rank) VALUES (780,'トリニダード・トバゴ',142); 
     1426INSERT INTO mtb_ccontry (id, name, rank) VALUES (795,'トルクメニスタン',143); 
     1427INSERT INTO mtb_ccontry (id, name, rank) VALUES (792,'トルコ',144); 
     1428INSERT INTO mtb_ccontry (id, name, rank) VALUES (776,'トンガ',145); 
     1429INSERT INTO mtb_ccontry (id, name, rank) VALUES (566,'ナイジェリア',146); 
     1430INSERT INTO mtb_ccontry (id, name, rank) VALUES (520,'ナウル',147); 
     1431INSERT INTO mtb_ccontry (id, name, rank) VALUES (516,'ナミビア',148); 
     1432INSERT INTO mtb_ccontry (id, name, rank) VALUES (10,'南極',149); 
     1433INSERT INTO mtb_ccontry (id, name, rank) VALUES (570,'ニウエ',150); 
     1434INSERT INTO mtb_ccontry (id, name, rank) VALUES (558,'ニカラグア',151); 
     1435INSERT INTO mtb_ccontry (id, name, rank) VALUES (562,'ニジェール',152); 
     1436INSERT INTO mtb_ccontry (id, name, rank) VALUES (392,'日本',153); 
     1437INSERT INTO mtb_ccontry (id, name, rank) VALUES (732,'西サハラ',154); 
     1438INSERT INTO mtb_ccontry (id, name, rank) VALUES (540,'ニューカレドニア',155); 
     1439INSERT INTO mtb_ccontry (id, name, rank) VALUES (554,'ニュージーランド',156); 
     1440INSERT INTO mtb_ccontry (id, name, rank) VALUES (524,'ネパール',157); 
     1441INSERT INTO mtb_ccontry (id, name, rank) VALUES (574,'ノーフォーク島',158); 
     1442INSERT INTO mtb_ccontry (id, name, rank) VALUES (578,'ノルウェー',159); 
     1443INSERT INTO mtb_ccontry (id, name, rank) VALUES (334,'ハード島とマクドナルド諸島',160); 
     1444INSERT INTO mtb_ccontry (id, name, rank) VALUES (48,'バーレーン',161); 
     1445INSERT INTO mtb_ccontry (id, name, rank) VALUES (332,'ハイチ',162); 
     1446INSERT INTO mtb_ccontry (id, name, rank) VALUES (586,'パキスタン',163); 
     1447INSERT INTO mtb_ccontry (id, name, rank) VALUES (336,'バチカン|バチカン市国',164); 
     1448INSERT INTO mtb_ccontry (id, name, rank) VALUES (591,'パナマ',165); 
     1449INSERT INTO mtb_ccontry (id, name, rank) VALUES (548,'バヌアツ',166); 
     1450INSERT INTO mtb_ccontry (id, name, rank) VALUES (44,'バハマ',167); 
     1451INSERT INTO mtb_ccontry (id, name, rank) VALUES (598,'パプアニューギニア',168); 
     1452INSERT INTO mtb_ccontry (id, name, rank) VALUES (60,'バミューダ諸島|バミューダ',169); 
     1453INSERT INTO mtb_ccontry (id, name, rank) VALUES (585,'パラオ',170); 
     1454INSERT INTO mtb_ccontry (id, name, rank) VALUES (600,'パラグアイ',171); 
     1455INSERT INTO mtb_ccontry (id, name, rank) VALUES (52,'バルバドス',172); 
     1456INSERT INTO mtb_ccontry (id, name, rank) VALUES (275,'パレスチナ',173); 
     1457INSERT INTO mtb_ccontry (id, name, rank) VALUES (348,'ハンガリー',174); 
     1458INSERT INTO mtb_ccontry (id, name, rank) VALUES (50,'バングラデシュ',175); 
     1459INSERT INTO mtb_ccontry (id, name, rank) VALUES (626,'東ティモール',176); 
     1460INSERT INTO mtb_ccontry (id, name, rank) VALUES (612,'ピトケアン諸島|ピトケアン',177); 
     1461INSERT INTO mtb_ccontry (id, name, rank) VALUES (242,'フィジー',178); 
     1462INSERT INTO mtb_ccontry (id, name, rank) VALUES (608,'フィリピン',179); 
     1463INSERT INTO mtb_ccontry (id, name, rank) VALUES (246,'フィンランド',180); 
     1464INSERT INTO mtb_ccontry (id, name, rank) VALUES (64,'ブータン',181); 
     1465INSERT INTO mtb_ccontry (id, name, rank) VALUES (74,'ブーベ島',182); 
     1466INSERT INTO mtb_ccontry (id, name, rank) VALUES (630,'プエルトリコ',183); 
     1467INSERT INTO mtb_ccontry (id, name, rank) VALUES (234,'フェロー諸島',184); 
     1468INSERT INTO mtb_ccontry (id, name, rank) VALUES (238,'フォークランド諸島|フォークランド(マルビナス)諸島',185); 
     1469INSERT INTO mtb_ccontry (id, name, rank) VALUES (76,'ブラジル',186); 
     1470INSERT INTO mtb_ccontry (id, name, rank) VALUES (250,'フランス',187); 
     1471INSERT INTO mtb_ccontry (id, name, rank) VALUES (254,'フランス領ギアナ',188); 
     1472INSERT INTO mtb_ccontry (id, name, rank) VALUES (258,'フランス領ポリネシア',189); 
     1473INSERT INTO mtb_ccontry (id, name, rank) VALUES (260,'フランス領南方・南極地域',190); 
     1474INSERT INTO mtb_ccontry (id, name, rank) VALUES (100,'ブルガリア',191); 
     1475INSERT INTO mtb_ccontry (id, name, rank) VALUES (854,'ブルキナファソ',192); 
     1476INSERT INTO mtb_ccontry (id, name, rank) VALUES (96,'ブルネイ|ブルネイ・ダルサラーム',193); 
     1477INSERT INTO mtb_ccontry (id, name, rank) VALUES (108,'ブルンジ',194); 
     1478INSERT INTO mtb_ccontry (id, name, rank) VALUES (704,'ベトナム',195); 
     1479INSERT INTO mtb_ccontry (id, name, rank) VALUES (204,'ベナン',196); 
     1480INSERT INTO mtb_ccontry (id, name, rank) VALUES (862,'ベネズエラ|ベネズエラ・ボリバル共和国',197); 
     1481INSERT INTO mtb_ccontry (id, name, rank) VALUES (112,'ベラルーシ',198); 
     1482INSERT INTO mtb_ccontry (id, name, rank) VALUES (84,'ベリーズ',199); 
     1483INSERT INTO mtb_ccontry (id, name, rank) VALUES (604,'ペルー',200); 
     1484INSERT INTO mtb_ccontry (id, name, rank) VALUES (56,'ベルギー',201); 
     1485INSERT INTO mtb_ccontry (id, name, rank) VALUES (616,'ポーランド',202); 
     1486INSERT INTO mtb_ccontry (id, name, rank) VALUES (70,'ボスニア・ヘルツェゴビナ',203); 
     1487INSERT INTO mtb_ccontry (id, name, rank) VALUES (72,'ボツワナ',204); 
     1488INSERT INTO mtb_ccontry (id, name, rank) VALUES (535,'BES諸島|ボネール、シント・ユースタティウスおよびサバ',205); 
     1489INSERT INTO mtb_ccontry (id, name, rank) VALUES (68,'ボリビア|ボリビア多民族国',206); 
     1490INSERT INTO mtb_ccontry (id, name, rank) VALUES (620,'ポルトガル',207); 
     1491INSERT INTO mtb_ccontry (id, name, rank) VALUES (344,'香港',208); 
     1492INSERT INTO mtb_ccontry (id, name, rank) VALUES (340,'ホンジュラス',209); 
     1493INSERT INTO mtb_ccontry (id, name, rank) VALUES (584,'マーシャル諸島',210); 
     1494INSERT INTO mtb_ccontry (id, name, rank) VALUES (446,'マカオ',211); 
     1495INSERT INTO mtb_ccontry (id, name, rank) VALUES (807,'マケドニア共和国|マケドニア旧ユーゴスラビア共和国',212); 
     1496INSERT INTO mtb_ccontry (id, name, rank) VALUES (450,'マダガスカル',213); 
     1497INSERT INTO mtb_ccontry (id, name, rank) VALUES (175,'マヨット',214); 
     1498INSERT INTO mtb_ccontry (id, name, rank) VALUES (454,'マラウイ',215); 
     1499INSERT INTO mtb_ccontry (id, name, rank) VALUES (466,'マリ共和国|マリ',216); 
     1500INSERT INTO mtb_ccontry (id, name, rank) VALUES (470,'マルタ',217); 
     1501INSERT INTO mtb_ccontry (id, name, rank) VALUES (474,'マルティニーク',218); 
     1502INSERT INTO mtb_ccontry (id, name, rank) VALUES (458,'マレーシア',219); 
     1503INSERT INTO mtb_ccontry (id, name, rank) VALUES (833,'マン島',220); 
     1504INSERT INTO mtb_ccontry (id, name, rank) VALUES (583,'ミクロネシア連邦',221); 
     1505INSERT INTO mtb_ccontry (id, name, rank) VALUES (710,'南アフリカ共和国|南アフリカ',222); 
     1506INSERT INTO mtb_ccontry (id, name, rank) VALUES (728,'南スーダン',223); 
     1507INSERT INTO mtb_ccontry (id, name, rank) VALUES (104,'ミャンマー',224); 
     1508INSERT INTO mtb_ccontry (id, name, rank) VALUES (484,'メキシコ',225); 
     1509INSERT INTO mtb_ccontry (id, name, rank) VALUES (480,'モーリシャス',226); 
     1510INSERT INTO mtb_ccontry (id, name, rank) VALUES (478,'モーリタニア',227); 
     1511INSERT INTO mtb_ccontry (id, name, rank) VALUES (508,'モザンビーク',228); 
     1512INSERT INTO mtb_ccontry (id, name, rank) VALUES (492,'モナコ',229); 
     1513INSERT INTO mtb_ccontry (id, name, rank) VALUES (462,'モルディブ',230); 
     1514INSERT INTO mtb_ccontry (id, name, rank) VALUES (498,'モルドバ|モルドバ共和国',231); 
     1515INSERT INTO mtb_ccontry (id, name, rank) VALUES (504,'モロッコ',232); 
     1516INSERT INTO mtb_ccontry (id, name, rank) VALUES (496,'モンゴル国|モンゴル',233); 
     1517INSERT INTO mtb_ccontry (id, name, rank) VALUES (499,'モンテネグロ',234); 
     1518INSERT INTO mtb_ccontry (id, name, rank) VALUES (500,'モントセラト',235); 
     1519INSERT INTO mtb_ccontry (id, name, rank) VALUES (400,'ヨルダン',236); 
     1520INSERT INTO mtb_ccontry (id, name, rank) VALUES (418,'ラオス|ラオス人民民主共和国',237); 
     1521INSERT INTO mtb_ccontry (id, name, rank) VALUES (428,'ラトビア',238); 
     1522INSERT INTO mtb_ccontry (id, name, rank) VALUES (440,'リトアニア',239); 
     1523INSERT INTO mtb_ccontry (id, name, rank) VALUES (434,'リビア',240); 
     1524INSERT INTO mtb_ccontry (id, name, rank) VALUES (438,'リヒテンシュタイン',241); 
     1525INSERT INTO mtb_ccontry (id, name, rank) VALUES (430,'リベリア',242); 
     1526INSERT INTO mtb_ccontry (id, name, rank) VALUES (642,'ルーマニア',243); 
     1527INSERT INTO mtb_ccontry (id, name, rank) VALUES (442,'ルクセンブルク',244); 
     1528INSERT INTO mtb_ccontry (id, name, rank) VALUES (646,'ルワンダ',245); 
     1529INSERT INTO mtb_ccontry (id, name, rank) VALUES (426,'レソト',246); 
     1530INSERT INTO mtb_ccontry (id, name, rank) VALUES (422,'レバノン',247); 
     1531INSERT INTO mtb_ccontry (id, name, rank) VALUES (638,'レユニオン',248); 
     1532INSERT INTO mtb_ccontry (id, name, rank) VALUES (643,'ロシア|ロシア連邦',249); 
Note: See TracChangeset for help on using the changeset viewer.