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