Diff
1155
1156
1156
oscommerce.sql
  |
1 | | - | # $Id: oscommerce.sql 1155 2006-11-22 01:30:04Z tech2000 $ |
| |
| 1 | + | # $Id: oscommerce.sql 1156 2006-11-22 15:10:47Z tech2000 $ |
|
2 | 2 | | # |
| |
3 | 3 | | # osCommerce, Open Source E-Commerce Solutions |
| |
4 | 4 | | # http://www.oscommerce.com |
| |
|
|
 |
… |
|
803 | 803 | | INSERT INTO osc_configuration_group VALUES ('17', 'Credit Cards', 'Credit card options', '17', '1'); |
| |
804 | 804 | | INSERT INTO osc_configuration_group VALUES ('18', 'Program Locations', 'Locations to certain programs on the server.', '18', '1'); |
| |
805 | 805 | | |
  |
806 | | - | INSERT INTO osc_countries VALUES (1,'د افغانستان اسلامي جمهوریت','AF','AFG',''); |
| |
807 | | - | INSERT INTO osc_countries VALUES (2,'Shqipërisë','AL','ALB',''); |
| |
808 | | - | INSERT INTO osc_countries VALUES (3,'الجزائر','DZ','DZA',''); |
| |
809 | | - | INSERT INTO osc_countries VALUES (4,'Amerika Samoa','AS','ASM',''); |
| |
| 806 | + | INSERT INTO osc_countries VALUES (1,'Afghanistan','AF','AFG',''); |
| |
| 807 | + | INSERT INTO osc_countries VALUES (2,'Albania','AL','ALB',''); |
| |
| 808 | + | INSERT INTO osc_countries VALUES (3,'Algeria','DZ','DZA',''); |
| |
| 809 | + | INSERT INTO osc_countries VALUES (4,'American Samoa','AS','ASM',''); |
|
810 | 810 | | INSERT INTO osc_countries VALUES (5,'Andorra','AD','AND',''); |
| |
811 | 811 | | INSERT INTO osc_countries VALUES (6,'Angola','AO','AGO',''); |
| |
812 | 812 | | INSERT INTO osc_countries VALUES (7,'Anguilla','AI','AIA',''); |
| |
813 | 813 | | INSERT INTO osc_countries VALUES (8,'Antarctica','AQ','ATA',''); |
| |
814 | 814 | | INSERT INTO osc_countries VALUES (9,'Antigua and Barbuda','AG','ATG',''); |
| |
815 | 815 | | INSERT INTO osc_countries VALUES (10,'Argentina','AR','ARG',":name\n:street_address\n:postcode :city\n:country"); |
  |
816 | | - | INSERT INTO osc_countries VALUES (11,'Հայաստան','AM','ARM',''); |
| |
| 816 | + | INSERT INTO osc_countries VALUES (11,'Armenia','AM','ARM',''); |
|
817 | 817 | | INSERT INTO osc_countries VALUES (12,'Aruba','AW','ABW',''); |
| |
818 | 818 | | INSERT INTO osc_countries VALUES (13,'Australia','AU','AUS',":name\n:street_address\n:suburb :state_code :postcode\n:country"); |
  |
819 | | - | INSERT INTO osc_countries VALUES (14,'Österreich','AT','AUT',":name\n:street_address\nA-:postcode :city\n:country"); |
| |
820 | | - | INSERT INTO osc_countries VALUES (15,'Azərbaycan','AZ','AZE',''); |
| |
| 819 | + | INSERT INTO osc_countries VALUES (14,'Austria','AT','AUT',":name\n:street_address\nA-:postcode :city\n:country"); |
| |
| 820 | + | INSERT INTO osc_countries VALUES (15,'Azerbaijan','AZ','AZE',''); |
|
821 | 821 | | INSERT INTO osc_countries VALUES (16,'Bahamas','BS','BHS',''); |
  |
822 | | - | INSERT INTO osc_countries VALUES (17,'مملكة البحرين','BH','BHR',''); |
| |
| 822 | + | INSERT INTO osc_countries VALUES (17,'Bahrain','BH','BHR',''); |
|
823 | 823 | | INSERT INTO osc_countries VALUES (18,'Bangladesh','BD','BGD',''); |
| |
824 | 824 | | INSERT INTO osc_countries VALUES (19,'Barbados','BB','BRB',''); |
  |
825 | | - | INSERT INTO osc_countries VALUES (20,'Беларусь','BY','BLR',''); |
| |
826 | | - | INSERT INTO osc_countries VALUES (21,'België','BE','BEL',":name\n:street_address\nB-:postcode :city\n:country"); |
| |
| 825 | + | INSERT INTO osc_countries VALUES (20,'Belarus','BY','BLR',''); |
| |
| 826 | + | INSERT INTO osc_countries VALUES (21,'Belgium','BE','BEL',":name\n:street_address\nB-:postcode :city\n:country"); |
|
827 | 827 | | INSERT INTO osc_countries VALUES (22,'Belize','BZ','BLZ',''); |
  |
828 | | - | INSERT INTO osc_countries VALUES (23,'Bémmin','BJ','BEN',''); |
| |
| 828 | + | INSERT INTO osc_countries VALUES (23,'Benin','BJ','BEN',''); |
|
829 | 829 | | INSERT INTO osc_countries VALUES (24,'Bermuda','BM','BMU',''); |
| |
830 | 830 | | INSERT INTO osc_countries VALUES (25,'Bhutan','BT','BTN',''); |
| |
831 | 831 | | INSERT INTO osc_countries VALUES (26,'Bolivia','BO','BOL',''); |
| |
832 | 832 | | INSERT INTO osc_countries VALUES (27,'Bosnia and Herzegowina','BA','BIH',''); |
| |
833 | 833 | | INSERT INTO osc_countries VALUES (28,'Botswana','BW','BWA',''); |
| |
834 | 834 | | INSERT INTO osc_countries VALUES (29,'Bouvet Island','BV','BVT',''); |
  |
835 | | - | INSERT INTO osc_countries VALUES (30,'Brasil','BR','BRA',":name\n:street_address\n:state\n:postcode\n:country"); |
| |
| 835 | + | INSERT INTO osc_countries VALUES (30,'Brazil','BR','BRA',":name\n:street_address\n:state\n:postcode\n:country"); |
|
836 | 836 | | INSERT INTO osc_countries VALUES (31,'British Indian Ocean Territory','IO','IOT',''); |
  |
837 | | - | INSERT INTO osc_countries VALUES (32,'Negara Brunei Darussalam','BN','BRN',''); |
| |
838 | | - | INSERT INTO osc_countries VALUES (33,'България','BG','BGR',''); |
| |
| 837 | + | INSERT INTO osc_countries VALUES (32,'Brunei Darussalam','BN','BRN',''); |
| |
| 838 | + | INSERT INTO osc_countries VALUES (33,'Bulgaria','BG','BGR',''); |
|
839 | 839 | | INSERT INTO osc_countries VALUES (34,'Burkina Faso','BF','BFA',''); |
| |
840 | 840 | | INSERT INTO osc_countries VALUES (35,'Burundi','BI','BDI',''); |
| |
841 | 841 | | INSERT INTO osc_countries VALUES (36,'Cambodia','KH','KHM',''); |
  |
842 | | - | INSERT INTO osc_countries VALUES (37,'Cameroun','CM','CMR',''); |
| |
| 842 | + | INSERT INTO osc_countries VALUES (37,'Cameroon','CM','CMR',''); |
|
843 | 843 | | INSERT INTO osc_countries VALUES (38,'Canada','CA','CAN',":name\n:street_address\n:city :state_code :postcode\n:country"); |
  |
844 | | - | INSERT INTO osc_countries VALUES (39,'Cabo Verde','CV','CPV',''); |
| |
| 844 | + | INSERT INTO osc_countries VALUES (39,'Cape Verde','CV','CPV',''); |
|
845 | 845 | | INSERT INTO osc_countries VALUES (40,'Cayman Islands','KY','CYM',''); |
  |
846 | | - | INSERT INTO osc_countries VALUES (41,'Ködörösêse tî Bêafrîka','CF','CAF',''); |
| |
847 | | - | INSERT INTO osc_countries VALUES (42,'TChad','TD','TCD',''); |
| |
| 846 | + | INSERT INTO osc_countries VALUES (41,'Central African Republic','CF','CAF',''); |
| |
| 847 | + | INSERT INTO osc_countries VALUES (42,'Chad','TD','TCD',''); |
|
848 | 848 | | INSERT INTO osc_countries VALUES (43,'Chile','CL','CHL',":name\n:street_address\n:city\n:country"); |
  |
849 | | - | INSERT INTO osc_countries VALUES (44,'中國','CN','CHN',":name\n:street_address\n:postcode :city\n:country"); |
| |
| 849 | + | INSERT INTO osc_countries VALUES (44,'China','CN','CHN',":name\n:street_address\n:postcode :city\n:country"); |
|
850 | 850 | | INSERT INTO osc_countries VALUES (45,'Christmas Island','CX','CXR',''); |
| |
851 | 851 | | INSERT INTO osc_countries VALUES (46,'Cocos (Keeling) Islands','CC','CCK',''); |
| |
852 | 852 | | INSERT INTO osc_countries VALUES (47,'Colombia','CO','COL',''); |
  |
853 | | - | INSERT INTO osc_countries VALUES (48,'Comores','KM','COM',''); |
| |
| 853 | + | INSERT INTO osc_countries VALUES (48,'Comoros','KM','COM',''); |
|
854 | 854 | | INSERT INTO osc_countries VALUES (49,'Congo','CG','COG',''); |
| |
855 | 855 | | INSERT INTO osc_countries VALUES (50,'Cook Islands','CK','COK',''); |
| |
856 | 856 | | INSERT INTO osc_countries VALUES (51,'Costa Rica','CR','CRI',''); |
  |
857 | | - | INSERT INTO osc_countries VALUES (52,'Côte D\'Ivoire','CI','CIV',''); |
| |
858 | | - | INSERT INTO osc_countries VALUES (53,'Hrvatska','HR','HRV',''); |
| |
| 857 | + | INSERT INTO osc_countries VALUES (52,'Cote D\'Ivoire','CI','CIV',''); |
| |
| 858 | + | INSERT INTO osc_countries VALUES (53,'Croatia','HR','HRV',''); |
|
859 | 859 | | INSERT INTO osc_countries VALUES (54,'Cuba','CU','CUB',''); |
  |
860 | | - | INSERT INTO osc_countries VALUES (55,'Κύπρος','CY','CYP',''); |
| |
861 | | - | INSERT INTO osc_countries VALUES (56,'Česká Republika','CZ','CZE',''); |
| |
862 | | - | INSERT INTO osc_countries VALUES (57,'Danmark','DK','DNK',":name\n:street_address\nDK-:postcode :city\n:country"); |
| |
863 | | - | INSERT INTO osc_countries VALUES (58,'Ǧībūtī','DJ','DJI',''); |
| |
| 860 | + | INSERT INTO osc_countries VALUES (55,'Cyprus','CY','CYP',''); |
| |
| 861 | + | INSERT INTO osc_countries VALUES (56,'Czech Republic','CZ','CZE',''); |
| |
| 862 | + | INSERT INTO osc_countries VALUES (57,'Denmark','DK','DNK',":name\n:street_address\nDK-:postcode :city\n:country"); |
| |
| 863 | + | INSERT INTO osc_countries VALUES (58,'Djibouti','DJ','DJI',''); |
|
864 | 864 | | INSERT INTO osc_countries VALUES (59,'Dominica','DM','DMA',''); |
| |
865 | 865 | | INSERT INTO osc_countries VALUES (60,'Dominican Republic','DO','DOM',''); |
  |
866 | | - | INSERT INTO osc_countries VALUES (61,'Timor Lorosa'e','TP','TMP',''); |
| |
| 866 | + | INSERT INTO osc_countries VALUES (61,'East Timor','TP','TMP',''); |
|
867 | 867 | | INSERT INTO osc_countries VALUES (62,'Ecuador','EC','ECU',''); |
  |
868 | | - | INSERT INTO osc_countries VALUES (63,'جمهورية مصر العربية','EG','EGY',''); |
| |
| 868 | + | INSERT INTO osc_countries VALUES (63,'Egypt','EG','EGY',''); |
|
869 | 869 | | INSERT INTO osc_countries VALUES (64,'El Salvador','SV','SLV',''); |
  |
870 | | - | INSERT INTO osc_countries VALUES (65,'Guinea Ecuatorial','GQ','GNQ',''); |
| |
871 | | - | INSERT INTO osc_countries VALUES (66,'Hagere Ertra','ER','ERI',''); |
| |
872 | | - | INSERT INTO osc_countries VALUES (67,'Eesti','EE','EST',''); |
| |
873 | | - | INSERT INTO osc_countries VALUES (68,'የኢትዮጵያ ፌዴራላዊ','ET','ETH',''); |
| |
| 870 | + | INSERT INTO osc_countries VALUES (65,'Equatorial Guinea','GQ','GNQ',''); |
| |
| 871 | + | INSERT INTO osc_countries VALUES (66,'Eritrea','ER','ERI',''); |
| |
| 872 | + | INSERT INTO osc_countries VALUES (67,'Estonia','EE','EST',''); |
| |
| 873 | + | INSERT INTO osc_countries VALUES (68,'Ethiopia','ET','ETH',''); |
|
874 | 874 | | INSERT INTO osc_countries VALUES (69,'Falkland Islands (Malvinas)','FK','FLK',''); |
| |
875 | 875 | | INSERT INTO osc_countries VALUES (70,'Faroe Islands','FO','FRO',''); |
| |
876 | 876 | | INSERT INTO osc_countries VALUES (71,'Fiji','FJ','FJI',''); |
  |
877 | | - | INSERT INTO osc_countries VALUES (72,'Suomi','FI','FIN',":name\n:street_address\nFIN-:postcode :city\n:country"); |
| |
| 877 | + | INSERT INTO osc_countries VALUES (72,'Finland','FI','FIN',":name\n:street_address\nFIN-:postcode :city\n:country"); |
|
878 | 878 | | INSERT INTO osc_countries VALUES (73,'France','FR','FRA',":name\n:street_address\n:postcode :city\n:country"); |
| |
879 | 879 | | INSERT INTO osc_countries VALUES (74,'France, Metropolitan','FX','FXX',":name\n:street_address\n:postcode :city\n:country"); |
| |
880 | 880 | | INSERT INTO osc_countries VALUES (75,'French Guiana','GF','GUF',":name\n:street_address\n:postcode :city\n:country"); |
  |
881 | | - | INSERT INTO osc_countries VALUES (76,'Polynésie Française','PF','PYF',":name\n:street_address\n:postcode :city\n:country"); |
| |
882 | | - | INSERT INTO osc_countries VALUES (77,'Terres Australes et Antarctiques Françaises','TF','ATF',":name\n:street_address\n:postcode :city\n:country"); |
| |
883 | | - | INSERT INTO osc_countries VALUES (78,'Gabonaise','GA','GAB',''); |
| |
| 881 | + | INSERT INTO osc_countries VALUES (76,'French Polynesia','PF','PYF',":name\n:street_address\n:postcode :city\n:country"); |
| |
| 882 | + | INSERT INTO osc_countries VALUES (77,'French Southern Territories','TF','ATF',":name\n:street_address\n:postcode :city\n:country"); |
| |
| 883 | + | INSERT INTO osc_countries VALUES (78,'Gabon','GA','GAB',''); |
|
884 | 884 | | INSERT INTO osc_countries VALUES (79,'Gambia','GM','GMB',''); |
  |
885 | | - | INSERT INTO osc_countries VALUES (80,'საქართველო','GE','GEO',''); |
| |
886 | | - | INSERT INTO osc_countries VALUES (81,'Deutschland','DE','DEU',":name\n:street_address\nD-:postcode :city\n:country"); |
| |
| 885 | + | INSERT INTO osc_countries VALUES (80,'Georgia','GE','GEO',''); |
| |
| 886 | + | INSERT INTO osc_countries VALUES (81,'Germany','DE','DEU',":name\n:street_address\nD-:postcode :city\n:country"); |
|
887 | 887 | | INSERT INTO osc_countries VALUES (82,'Ghana','GH','GHA',''); |
| |
888 | 888 | | INSERT INTO osc_countries VALUES (83,'Gibraltar','GI','GIB',''); |
  |
889 | | - | INSERT INTO osc_countries VALUES (84,'Ελλάδα','GR','GRC',''); |
| |
890 | | - | INSERT INTO osc_countries VALUES (85,'Kalaallit Nunaat','GL','GRL',":name\n:street_address\nDK-:postcode :city\n:country"); |
| |
| 889 | + | INSERT INTO osc_countries VALUES (84,'Greece','GR','GRC',''); |
| |
| 890 | + | INSERT INTO osc_countries VALUES (85,'Greenland','GL','GRL',":name\n:street_address\nDK-:postcode :city\n:country"); |
|
891 | 891 | | INSERT INTO osc_countries VALUES (86,'Grenada','GD','GRD',''); |
| |
892 | 892 | | INSERT INTO osc_countries VALUES (87,'Guadeloupe','GP','GLP',''); |
| |
893 | 893 | | INSERT INTO osc_countries VALUES (88,'Guam','GU','GUM',''); |
| |
894 | 894 | | INSERT INTO osc_countries VALUES (89,'Guatemala','GT','GTM',''); |
  |
895 | | - | INSERT INTO osc_countries VALUES (90,'Guinée','GN','GIN',''); |
| |
| 895 | + | INSERT INTO osc_countries VALUES (90,'Guinea','GN','GIN',''); |
|
896 | 896 | | INSERT INTO osc_countries VALUES (91,'Guinea-bissau','GW','GNB',''); |
| |
897 | 897 | | INSERT INTO osc_countries VALUES (92,'Guyana','GY','GUY',''); |
  |
898 | | - | INSERT INTO osc_countries VALUES (93,'Ayiti','HT','HTI',''); |
| |
| 898 | + | INSERT INTO osc_countries VALUES (93,'Haiti','HT','HTI',''); |
|
899 | 899 | | INSERT INTO osc_countries VALUES (94,'Heard and Mc Donald Islands','HM','HMD',''); |
| |
900 | 900 | | INSERT INTO osc_countries VALUES (95,'Honduras','HN','HND',''); |
  |
901 | | - | INSERT INTO osc_countries VALUES (96,'香港','HK','HKG',":name\n:street_address\n:city\n:country"); |
| |
902 | | - | INSERT INTO osc_countries VALUES (97,'Magyarország','HU','HUN',''); |
| |
903 | | - | INSERT INTO osc_countries VALUES (98,'Ísland','IS','ISL',":name\n:street_address\nIS:postcode :city\n:country"); |
| |
| 901 | + | INSERT INTO osc_countries VALUES (96,'Hong Kong','HK','HKG',":name\n:street_address\n:city\n:country"); |
| |
| 902 | + | INSERT INTO osc_countries VALUES (97,'Hungary','HU','HUN',''); |
| |
| 903 | + | INSERT INTO osc_countries VALUES (98,'Iceland','IS','ISL',":name\n:street_address\nIS:postcode :city\n:country"); |
|
904 | 904 | | INSERT INTO osc_countries VALUES (99,'India','IN','IND',":name\n:street_address\n:city-:postcode\n:country"); |
| |
905 | 905 | | INSERT INTO osc_countries VALUES (100,'Indonesia','ID','IDN',":name\n:street_address\n:city :postcode\n:country"); |
  |
906 | | - | INSERT INTO osc_countries VALUES (101,'ايران','IR','IRN',''); |
| |
907 | | - | INSERT INTO osc_countries VALUES (102,'العراق','IQ','IRQ',''); |
| |
908 | | - | INSERT INTO osc_countries VALUES (103,'Éire','IE','IRL',":name\n:street_address\nIE-:city\n:country"); |
| |
909 | | - | INSERT INTO osc_countries VALUES (104,'מְדִינַת יִשְׂרָאֵל','IL','ISR',":name\n:street_address\n:postcode :city\n:country"); |
| |
910 | | - | INSERT INTO osc_countries VALUES (105,'Italia','IT','ITA',":name\n:street_address\n:postcode-:city :state_code\n:country"); |
| |
| 906 | + | INSERT INTO osc_countries VALUES (101,'Iran (Islamic Republic of)','IR','IRN',''); |
| |
| 907 | + | INSERT INTO osc_countries VALUES (102,'Iraq','IQ','IRQ',''); |
| |
| 908 | + | INSERT INTO osc_countries VALUES (103,'Ireland','IE','IRL',":name\n:street_address\nIE-:city\n:country"); |
| |
| 909 | + | INSERT INTO osc_countries VALUES (104,'Israel','IL','ISR',":name\n:street_address\n:postcode :city\n:country"); |
| |
| 910 | + | INSERT INTO osc_countries VALUES (105,'Italy','IT','ITA',":name\n:street_address\n:postcode-:city :state_code\n:country"); |
|
911 | 911 | | INSERT INTO osc_countries VALUES (106,'Jamaica','JM','JAM',''); |
  |
912 | | - | INSERT INTO osc_countries VALUES (107,'日本','JP','JPN',":name\n:street_address, :suburb\n:city :postcode\n:country"); |
| |
913 | | - | INSERT INTO osc_countries VALUES (108,'الأردنّ','JO','JOR',''); |
| |
914 | | - | INSERT INTO osc_countries VALUES (109,'Қазақстан','KZ','KAZ',''); |
| |
| 912 | + | INSERT INTO osc_countries VALUES (107,'Japan','JP','JPN',":name\n:street_address, :suburb\n:city :postcode\n:country"); |
| |
| 913 | + | INSERT INTO osc_countries VALUES (108,'Jordan','JO','JOR',''); |
| |
| 914 | + | INSERT INTO osc_countries VALUES (109,'Kazakhstan','KZ','KAZ',''); |
|
915 | 915 | | INSERT INTO osc_countries VALUES (110,'Kenya','KE','KEN',''); |
| |
916 | 916 | | INSERT INTO osc_countries VALUES (111,'Kiribati','KI','KIR',''); |
  |
917 | | - | INSERT INTO osc_countries VALUES (112,'조선민주주의인민공화국','KP','PRK',''); |
| |
918 | | - | INSERT INTO osc_countries VALUES (113,'대한민국','KR','KOR',''); |
| |
919 | | - | INSERT INTO osc_countries VALUES (114,'الكويت','KW','KWT',''); |
| |
920 | | - | INSERT INTO osc_countries VALUES (115,'Кыргызстан','KG','KGZ',''); |
| |
921 | | - | INSERT INTO osc_countries VALUES (116,'ສາທາລະນະລັດ ປະຊາທິປະໄຕ ປະຊາຊົນລາວ','LA','LAO',''); |
| |
922 | | - | INSERT INTO osc_countries VALUES (117,'Latvija','LV','LVA',''); |
| |
| 917 | + | INSERT INTO osc_countries VALUES (112,'Korea, Democratic People\'s Republic of','KP','PRK',''); |
| |
| 918 | + | INSERT INTO osc_countries VALUES (113,'Korea, Republic of','KR','KOR',''); |
| |
| 919 | + | INSERT INTO osc_countries VALUES (114,'Kuwait','KW','KWT',''); |
| |
| 920 | + | INSERT INTO osc_countries VALUES (115,'Kyrgyzstan','KG','KGZ',''); |
| |
| 921 | + | INSERT INTO osc_countries VALUES (116,'Lao People\'s Democratic Republic','LA','LAO',''); |
| |
| 922 | + | INSERT INTO osc_countries VALUES (117,'Latvia','LV','LVA',''); |
|
923 | 923 | | INSERT INTO osc_countries VALUES (118,'Lebanon','LB','LBN',''); |
| |
924 | 924 | | INSERT INTO osc_countries VALUES (119,'Lesotho','LS','LSO',''); |
| |
925 | 925 | | INSERT INTO osc_countries VALUES (120,'Liberia','LR','LBR',''); |
  |
926 | | - | INSERT INTO osc_countries VALUES (121,'ليبيا','LY','LBY',''); |
| |
| 926 | + | INSERT INTO osc_countries VALUES (121,'Libyan Arab Jamahiriya','LY','LBY',''); |
|
927 | 927 | | INSERT INTO osc_countries VALUES (122,'Liechtenstein','LI','LIE',''); |
  |
928 | | - | INSERT INTO osc_countries VALUES (123,'Lietuva','LT','LTU',''); |
| |
| 928 | + | INSERT INTO osc_countries VALUES (123,'Lithuania','LT','LTU',''); |
|
929 | 929 | | INSERT INTO osc_countries VALUES (124,'Luxembourg','LU','LUX',":name\n:street_address\nL-:postcode :city\n:country"); |
  |
930 | | - | INSERT INTO osc_countries VALUES (125,'中華人民共和國澳門特別行政區','MO','MAC',''); |
| |
931 | | - | INSERT INTO osc_countries VALUES (126,'Република Македонија','MK','MKD',''); |
| |
932 | | - | INSERT INTO osc_countries VALUES (127,'Madagasikara','MG','MDG',''); |
| |
| 930 | + | INSERT INTO osc_countries VALUES (125,'Macau','MO','MAC',''); |
| |
| 931 | + | INSERT INTO osc_countries VALUES (126,'Macedonia, The Former Yugoslav Republic of','MK','MKD',''); |
| |
| 932 | + | INSERT INTO osc_countries VALUES (127,'Madagascar','MG','MDG',''); |
|
933 | 933 | | INSERT INTO osc_countries VALUES (128,'Malawi','MW','MWI',''); |
| |
934 | 934 | | INSERT INTO osc_countries VALUES (129,'Malaysia','MY','MYS',''); |
  |
935 | | - | INSERT INTO osc_countries VALUES (130,'ދިވެހިރާއްޖޭގެ ޖުމުހޫރިއްޔާ','MV','MDV',''); |
| |
| 935 | + | INSERT INTO osc_countries VALUES (130,'Maldives','MV','MDV',''); |
|
936 | 936 | | INSERT INTO osc_countries VALUES (131,'Mali','ML','MLI',''); |
| |
937 | 937 | | INSERT INTO osc_countries VALUES (132,'Malta','MT','MLT',''); |
| |
938 | 938 | | INSERT INTO osc_countries VALUES (133,'Marshall Islands','MH','MHL',''); |
| |
939 | 939 | | INSERT INTO osc_countries VALUES (134,'Martinique','MQ','MTQ',''); |
  |
940 | | - | INSERT INTO osc_countries VALUES (135,'موريتانية','MR','MRT',''); |
| |
| 940 | + | INSERT INTO osc_countries VALUES (135,'Mauritania','MR','MRT',''); |
|
941 | 941 | | INSERT INTO osc_countries VALUES (136,'Mauritius','MU','MUS',''); |
| |
942 | 942 | | INSERT INTO osc_countries VALUES (137,'Mayotte','YT','MYT',''); |
  |
943 | | - | INSERT INTO osc_countries VALUES (138,'México','MX','MEX',":name\n:street_address\n:postcode :city, :state_code\n:country"); |
| |
| 943 | + | INSERT INTO osc_countries VALUES (138,'Mexico','MX','MEX',":name\n:street_address\n:postcode :city, :state_code\n:country"); |
|
944 | 944 | | INSERT INTO osc_countries VALUES (139,'Micronesia, Federated States of','FM','FSM',''); |
| |
945 | 945 | | INSERT INTO osc_countries VALUES (140,'Moldova, Republic of','MD','MDA',''); |
| |
946 | 946 | | INSERT INTO osc_countries VALUES (141,'Monaco','MC','MCO',''); |
  |
947 | | - | INSERT INTO osc_countries VALUES (142,'Монгол Улс','MN','MNG',''); |
| |
| 947 | + | INSERT INTO osc_countries VALUES (142,'Mongolia','MN','MNG',''); |
|
948 | 948 | | INSERT INTO osc_countries VALUES (143,'Montserrat','MS','MSR',''); |
  |
949 | | - | INSERT INTO osc_countries VALUES (144,'المملكة المغربية','MA','MAR',''); |
| |
950 | | - | INSERT INTO osc_countries VALUES (145,'Moçambique','MZ','MOZ',''); |
| |
| 949 | + | INSERT INTO osc_countries VALUES (144,'Morocco','MA','MAR',''); |
| |
| 950 | + | INSERT INTO osc_countries VALUES (145,'Mozambique','MZ','MOZ',''); |
|
951 | 951 | | INSERT INTO osc_countries VALUES (146,'Myanmar','MM','MMR',''); |
| |
952 | 952 | | INSERT INTO osc_countries VALUES (147,'Namibia','NA','NAM',''); |
  |
953 | | - | INSERT INTO osc_countries VALUES (148,'Naoero','NR','NRU',''); |
| |
| 953 | + | INSERT INTO osc_countries VALUES (148,'Nauru','NR','NRU',''); |
|
954 | 954 | | INSERT INTO osc_countries VALUES (149,'Nepal','NP','NPL',''); |
  |
955 | | - | INSERT INTO osc_countries VALUES (150,'Nederland','NL','NLD',":name\n:street_address\n:postcode :city\n:country"); |
| |
| 955 | + | INSERT INTO osc_countries VALUES (150,'Netherlands','NL','NLD',":name\n:street_address\n:postcode :city\n:country"); |
|
956 | 956 | | INSERT INTO osc_countries VALUES (151,'Netherlands Antilles','AN','ANT',":name\n:street_address\n:postcode :city\n:country"); |
  |
957 | | - | INSERT INTO osc_countries VALUES (152,'Nouvelle-Calédonie','NC','NCL',''); |
| |
| 957 | + | INSERT INTO osc_countries VALUES (152,'New Caledonia','NC','NCL',''); |
|
958 | 958 | | INSERT INTO osc_countries VALUES (153,'New Zealand','NZ','NZL',":name\n:street_address\n:suburb\n:city :postcode\n:country"); |
| |
959 | 959 | | INSERT INTO osc_countries VALUES (154,'Nicaragua','NI','NIC',''); |
| |
960 | 960 | | INSERT INTO osc_countries VALUES (155,'Niger','NE','NER',''); |
| |
961 | 961 | | INSERT INTO osc_countries VALUES (156,'Nigeria','NG','NGA',''); |
| |
962 | 962 | | INSERT INTO osc_countries VALUES (157,'Niue','NU','NIU',''); |
| |
963 | 963 | | INSERT INTO osc_countries VALUES (158,'Norfolk Island','NF','NFK',''); |
| |
964 | 964 | | INSERT INTO osc_countries VALUES (159,'Northern Mariana Islands','MP','MNP',''); |
  |
965 | | - | INSERT INTO osc_countries VALUES (160,'Norge','NO','NOR',":name\n:street_address\nNO-:postcode :city\n:country"); |
| |
966 | | - | INSERT INTO osc_countries VALUES (161,'سلطنة عُمان','OM','OMN',''); |
| |
967 | | - | INSERT INTO osc_countries VALUES (162,'اسلامی جمہوریۂ پاکستان','PK','PAK',''); |
| |
| 965 | + | INSERT INTO osc_countries VALUES (160,'Norway','NO','NOR',":name\n:street_address\nNO-:postcode :city\n:country"); |
| |
| 966 | + | INSERT INTO osc_countries VALUES (161,'Oman','OM','OMN',''); |
| |
| 967 | + | INSERT INTO osc_countries VALUES (162,'Pakistan','PK','PAK',''); |
|
968 | 968 | | INSERT INTO osc_countries VALUES (163,'Palau','PW','PLW',''); |
  |
969 | | - | INSERT INTO osc_countries VALUES (164,'Panamá','PA','PAN',''); |
| |
| 969 | + | INSERT INTO osc_countries VALUES (164,'Panama','PA','PAN',''); |
|
970 | 970 | | INSERT INTO osc_countries VALUES (165,'Papua New Guinea','PG','PNG',''); |
| |
971 | 971 | | INSERT INTO osc_countries VALUES (166,'Paraguay','PY','PRY',''); |
  |
972 | | - | INSERT INTO osc_countries VALUES (167,'Perú','PE','PER',''); |
| |
973 | | - | INSERT INTO osc_countries VALUES (168,'Pilipinas','PH','PHL',''); |
| |
| 972 | + | INSERT INTO osc_countries VALUES (167,'Peru','PE','PER',''); |
| |
| 973 | + | INSERT INTO osc_countries VALUES (168,'Philippines','PH','PHL',''); |
|
974 | 974 | | INSERT INTO osc_countries VALUES (169,'Pitcairn','PN','PCN',''); |
  |
975 | | - | INSERT INTO osc_countries VALUES (170,'Polska','PL','POL',":name\n:street_address\n:postcode :city\n:country"); |
| |
| 975 | + | INSERT INTO osc_countries VALUES (170,'Poland','PL','POL',":name\n:street_address\n:postcode :city\n:country"); |
|
976 | 976 | | INSERT INTO osc_countries VALUES (171,'Portugal','PT','PRT',":name\n:street_address\n:postcode :city\n:country"); |
| |
977 | 977 | | INSERT INTO osc_countries VALUES (172,'Puerto Rico','PR','PRI',''); |
  |
978 | | - | INSERT INTO osc_countries VALUES (173,'قطر','QA','QAT',''); |
| |
| 978 | + | INSERT INTO osc_countries VALUES (173,'Qatar','QA','QAT',''); |
|
979 | 979 | | INSERT INTO osc_countries VALUES (174,'Reunion','RE','REU',''); |
  |
980 | | - | INSERT INTO osc_countries VALUES (175,'România','RO','ROM',''); |
| |
981 | | - | INSERT INTO osc_countries VALUES (176,'Росси́я','RU','RUS',":name\n:street_address\n:postcode :city\n:country"); |
| |
| 980 | + | INSERT INTO osc_countries VALUES (175,'Romania','RO','ROM',''); |
| |
| 981 | + | INSERT INTO osc_countries VALUES (176,'Russian Federation','RU','RUS',":name\n:street_address\n:postcode :city\n:country"); |
|
982 | 982 | | INSERT INTO osc_countries VALUES (177,'Rwanda','RW','RWA',''); |
| |
983 | 983 | | INSERT INTO osc_countries VALUES (178,'Saint Kitts and Nevis','KN','KNA',''); |
| |
984 | 984 | | INSERT INTO osc_countries VALUES (179,'Saint Lucia','LC','LCA',''); |
| |
985 | 985 | | INSERT INTO osc_countries VALUES (180,'Saint Vincent and the Grenadines','VC','VCT',''); |
| |
986 | 986 | | INSERT INTO osc_countries VALUES (181,'Samoa','WS','WSM',''); |
| |
987 | 987 | | INSERT INTO osc_countries VALUES (182,'San Marino','SM','SMR',''); |
  |
988 | | - | INSERT INTO osc_countries VALUES (183,'São Tomé e Príncipe','ST','STP',''); |
| |
989 | | - | INSERT INTO osc_countries VALUES (184,'المملكة العربية السعودية','SA','SAU',''); |
| |
990 | | - | INSERT INTO osc_countries VALUES (185,'Sénégal','SN','SEN',''); |
| |
| 988 | + | INSERT INTO osc_countries VALUES (183,'Sao Tome and Principe','ST','STP',''); |
| |
| 989 | + | INSERT INTO osc_countries VALUES (184,'Saudi Arabia','SA','SAU',''); |
| |
| 990 | + | INSERT INTO osc_countries VALUES (185,'Senegal','SN','SEN',''); |
|
991 | 991 | | INSERT INTO osc_countries VALUES (186,'Seychelles','SC','SYC',''); |
| |
992 | 992 | | INSERT INTO osc_countries VALUES (187,'Sierra Leone','SL','SLE',''); |
| |
993 | 993 | | INSERT INTO osc_countries VALUES (188,'Singapore','SG','SGP', ":name\n:street_address\n:city :postcode\n:country"); |
  |
994 | | - | INSERT INTO osc_countries VALUES (189,'Slovensko','SK','SVK',''); |
| |
995 | | - | INSERT INTO osc_countries VALUES (190,'Slovenija','SI','SVN',''); |
| |
| 994 | + | INSERT INTO osc_countries VALUES (189,'Slovakia (Slovak Republic)','SK','SVK',''); |
| |
| 995 | + | INSERT INTO osc_countries VALUES (190,'Slovenia','SI','SVN',''); |
|
996 | 996 | | INSERT INTO osc_countries VALUES (191,'Solomon Islands','SB','SLB',''); |
  |
997 | | - | INSERT INTO osc_countries VALUES (192,'Soomaaliya','SO','SOM',''); |
| |
| 997 | + | INSERT INTO osc_countries VALUES (192,'Somalia','SO','SOM',''); |
|
998 | 998 | | INSERT INTO osc_countries VALUES (193,'South Africa','ZA','ZAF',":name\n:street_address\n:suburb\n:city\n:postcode :country"); |
| |
999 | 999 | | INSERT INTO osc_countries VALUES (194,'South Georgia and the South Sandwich Islands','GS','SGS',''); |
  |
1000 | | - | INSERT INTO osc_countries VALUES (195,'España','ES','ESP',":name\n:street_address\n:postcode :city\n:country"); |
| |
| 1000 | + | INSERT INTO osc_countries VALUES (195,'Spain','ES','ESP',":name\n:street_address\n:postcode :city\n:country"); |
|
1001 | 1001 | | INSERT INTO osc_countries VALUES (196,'Sri Lanka','LK','LKA',''); |
| |
1002 | 1002 | | INSERT INTO osc_countries VALUES (197,'St. Helena','SH','SHN',''); |
  |
1003 | | - | INSERT INTO osc_countries VALUES (198,'Saint-Pierre et Miquelon','PM','SPM',''); |
| |
1004 | | - | INSERT INTO osc_countries VALUES (199,'السودان','SD','SDN',''); |
| |
| 1003 | + | INSERT INTO osc_countries VALUES (198,'St. Pierre and Miquelon','PM','SPM',''); |
| |
| 1004 | + | INSERT INTO osc_countries VALUES (199,'Sudan','SD','SDN',''); |
|
1005 | 1005 | | INSERT INTO osc_countries VALUES (200,'Suriname','SR','SUR',''); |
| |
1006 | 1006 | | INSERT INTO osc_countries VALUES (201,'Svalbard and Jan Mayen Islands','SJ','SJM',''); |
| |
1007 | 1007 | | INSERT INTO osc_countries VALUES (202,'Swaziland','SZ','SWZ',''); |
  |
1008 | | - | INSERT INTO osc_countries VALUES (203,'Sverige','SE','SWE',":name\n:street_address\n:postcode :city\n:country"); |
| |
1009 | | - | INSERT INTO osc_countries VALUES (204,'Schweiz','CH','CHE',":name\n:street_address\n:postcode :city\n:country"); |
| |
1010 | | - | INSERT INTO osc_countries VALUES (205,'سورية','SY','SYR',''); |
| |
1011 | | - | INSERT INTO osc_countries VALUES (206,'臺灣','TW','TWN',":name\n:street_address\n:city :postcode\n:country"); |
| |
1012 | | - | INSERT INTO osc_countries VALUES (207,'جمهوری تاجیکستان','TJ','TJK',''); |
| |
| 1008 | + | INSERT INTO osc_countries VALUES (203,'Sweden','SE','SWE',":name\n:street_address\n:postcode :city\n:country"); |
| |
| 1009 | + | INSERT INTO osc_countries VALUES (204,'Switzerland','CH','CHE',":name\n:street_address\n:postcode :city\n:country"); |
| |
| 1010 | + | INSERT INTO osc_countries VALUES (205,'Syrian Arab Republic','SY','SYR',''); |
| |
| 1011 | + | INSERT INTO osc_countries VALUES (206,'Taiwan','TW','TWN',":name\n:street_address\n:city :postcode\n:country"); |
| |
| 1012 | + | INSERT INTO osc_countries VALUES (207,'Tajikistan','TJ','TJK',''); |
|
1013 | 1013 | | INSERT INTO osc_countries VALUES (208,'Tanzania, United Republic of','TZ','TZA',''); |
| |
1014 | 1014 | | INSERT INTO osc_countries VALUES (209,'Thailand','TH','THA',''); |
  |
1015 | | - | INSERT INTO osc_countries VALUES (210,'Togolaise','TG','TGO',''); |
| |
| 1015 | + | INSERT INTO osc_countries VALUES (210,'Togo','TG','TGO',''); |
|
1016 | 1016 | | INSERT INTO osc_countries VALUES (211,'Tokelau','TK','TKL',''); |
| |
1017 | 1017 | | INSERT INTO osc_countries VALUES (212,'Tonga','TO','TON',''); |
| |
1018 | 1018 | | INSERT INTO osc_countries VALUES (213,'Trinidad and Tobago','TT','TTO',''); |
  |
1019 | | - | INSERT INTO osc_countries VALUES (214,'تونس','TN','TUN',''); |
| |
1020 | | - | INSERT INTO osc_countries VALUES (215,'Türkiye','TR','TUR',''); |
| |
1021 | | - | INSERT INTO osc_countries VALUES (216,'Türkmenistan Jumhuriyäti','TM','TKM',''); |
| |
| 1019 | + | INSERT INTO osc_countries VALUES (214,'Tunisia','TN','TUN',''); |
| |
| 1020 | + | INSERT INTO osc_countries VALUES (215,'Turkey','TR','TUR',''); |
| |
| 1021 | + | INSERT INTO osc_countries VALUES (216,'Turkmenistan','TM','TKM',''); |
|
1022 | 1022 | | INSERT INTO osc_countries VALUES (217,'Turks and Caicos Islands','TC','TCA',''); |
| |
1023 | 1023 | | INSERT INTO osc_countries VALUES (218,'Tuvalu','TV','TUV',''); |
| |
1024 | 1024 | | INSERT INTO osc_countries VALUES (219,'Uganda','UG','UGA',''); |
  |
1025 | | - | INSERT INTO osc_countries VALUES (220,'Україна','UA','UKR',''); |
| |
| 1025 | + | INSERT INTO osc_countries VALUES (220,'Ukraine','UA','UKR',''); |
|
1026 | 1026 | | INSERT INTO osc_countries VALUES (221,'United Arab Emirates','AE','ARE',''); |
| |
1027 | 1027 | | INSERT INTO osc_countries VALUES (222,'United Kingdom','GB','GBR',":name\n:street_address\n:city\n:postcode\n:country"); |
  |
1028 | | - | INSERT INTO osc_countries VALUES (223,'United States of America','US','USA',":name\n:street_address\n:city :state_code :postcode\n:country"); |
| |
| 1028 | + | INSERT INTO osc_countries VALUES (223,'United States','US','USA',":name\n:street_address\n:city :state_code :postcode\n:country"); |
|
1029 | 1029 | | INSERT INTO osc_countries VALUES (224,'United States Minor Outlying Islands','UM','UMI',''); |
| |
1030 | 1030 | | INSERT INTO osc_countries VALUES (225,'Uruguay','UY','URY',''); |
  |
1031 | | - | INSERT INTO osc_countries VALUES (226,'O‘zbekiston Respublikasi','UZ','UZB',''); |
| |
| 1031 | + | INSERT INTO osc_countries VALUES (226,'Uzbekistan','UZ','UZB',''); |
|
1032 | 1032 | | INSERT INTO osc_countries VALUES (227,'Vanuatu','VU','VUT',''); |
| |
1033 | 1033 | | INSERT INTO osc_countries VALUES (228,'Vatican City State (Holy See)','VA','VAT',''); |
| |
1034 | 1034 | | INSERT INTO osc_countries VALUES (229,'Venezuela','VE','VEN',''); |
  |
1035 | | - | INSERT INTO osc_countries VALUES (230,'Việt Nam','VN','VNM',''); |
| |
| 1035 | + | INSERT INTO osc_countries VALUES (230,'Viet Nam','VN','VNM',''); |
|
1036 | 1036 | | INSERT INTO osc_countries VALUES (231,'Virgin Islands (British)','VG','VGB',''); |
| |
1037 | 1037 | | INSERT INTO osc_countries VALUES (232,'Virgin Islands (U.S.)','VI','VIR',''); |
  |
1038 | | - | INSERT INTO osc_countries VALUES (233,'Wallis et Futuna','WF','WLF',''); |
| |
| 1038 | + | INSERT INTO osc_countries VALUES (233,'Wallis and Futuna Islands','WF','WLF',''); |
|
1039 | 1039 | | INSERT INTO osc_countries VALUES (234,'Western Sahara','EH','ESH',''); |
  |
1040 | | - | INSERT INTO osc_countries VALUES (235,'الجمهورية اليمنية','YE','YEM',''); |
| |
| 1040 | + | INSERT INTO osc_countries VALUES (235,'Yemen','YE','YEM',''); |
  |
1041 | 1041 | | INSERT INTO osc_countries VALUES (236,'Yugoslavia','YU','YUG',''); |
| |
1042 | 1042 | | INSERT INTO osc_countries VALUES (237,'Zaire','ZR','ZAR',''); |
| |
1043 | 1043 | | INSERT INTO osc_countries VALUES (238,'Zambia','ZM','ZMB',''); |
|