* fix bug 7930: return the resulting selected array in the methods buildStaticInfoSel...
[TYPO3CMS/Extensions/static_info_tables.git] / ext_tables_static+adt.sql
1 # TYPO3 Extension Manager dump 1.1
2 #
3 #--------------------------------------------------------
4
5
6 #
7 # Table structure for table "static_territories"
8 #
9 DROP TABLE IF EXISTS static_territories;
10 CREATE TABLE static_territories (
11 uid int(11) unsigned auto_increment,
12 pid int(11) unsigned default '0',
13 tr_iso_nr int(11) unsigned default '0',
14 tr_parent_iso_nr int(11) unsigned default '0',
15 tr_name_en varchar(50) default '',
16 PRIMARY KEY (uid),
17 UNIQUE uid (uid)
18 );
19
20
21 INSERT INTO static_territories VALUES ('1', '0', '2', '0', 'Africa');
22 INSERT INTO static_territories VALUES ('2', '0', '9', '0', 'Oceania');
23 INSERT INTO static_territories VALUES ('3', '0', '19', '0', 'Americas');
24 INSERT INTO static_territories VALUES ('4', '0', '142', '0', 'Asia');
25 INSERT INTO static_territories VALUES ('5', '0', '150', '0', 'Europe');
26 INSERT INTO static_territories VALUES ('6', '0', '30', '142', 'Eastern Asia');
27 INSERT INTO static_territories VALUES ('7', '0', '35', '142', 'South-eastern Asia');
28 INSERT INTO static_territories VALUES ('8', '0', '143', '142', 'Central Asia');
29 INSERT INTO static_territories VALUES ('9', '0', '145', '142', 'Western Asia');
30 INSERT INTO static_territories VALUES ('10', '0', '39', '150', 'Southern Europe');
31 INSERT INTO static_territories VALUES ('11', '0', '151', '150', 'Eastern Europe');
32 INSERT INTO static_territories VALUES ('12', '0', '154', '150', 'Northern Europe');
33 INSERT INTO static_territories VALUES ('13', '0', '155', '150', 'Western Europe');
34 INSERT INTO static_territories VALUES ('16', '0', '5', '19', 'South America');
35 INSERT INTO static_territories VALUES ('17', '0', '13', '19', 'Central America');
36 INSERT INTO static_territories VALUES ('18', '0', '21', '19', 'Northern America');
37 INSERT INTO static_territories VALUES ('19', '0', '29', '19', 'Caribbean');
38 INSERT INTO static_territories VALUES ('20', '0', '11', '2', 'Western Africa');
39 INSERT INTO static_territories VALUES ('21', '0', '14', '2', 'Eastern Africa');
40 INSERT INTO static_territories VALUES ('22', '0', '15', '2', 'Northern Africa');
41 INSERT INTO static_territories VALUES ('23', '0', '17', '2', 'Middle Africa');
42 INSERT INTO static_territories VALUES ('24', '0', '18', '2', 'Southern Africa');
43 INSERT INTO static_territories VALUES ('25', '0', '53', '9', 'Australia and New Zealand');
44 INSERT INTO static_territories VALUES ('26', '0', '54', '9', 'Melanesia');
45 INSERT INTO static_territories VALUES ('27', '0', '57', '9', 'Micronesian Region');
46 INSERT INTO static_territories VALUES ('28', '0', '61', '9', 'Polynesia');
47 INSERT INTO static_territories VALUES ('30', '0', '34', '142', 'Southern Asia');
48
49
50 # TYPO3 Extension Manager dump 1.1
51 #
52 #--------------------------------------------------------
53
54
55 #
56 # Table structure for table "static_countries"
57 #
58 DROP TABLE IF EXISTS static_countries;
59 CREATE TABLE static_countries (
60 uid int(11) unsigned auto_increment,
61 pid int(11) unsigned default '0',
62 cn_iso_2 char(2) default '',
63 cn_iso_3 char(3) default '',
64 cn_iso_nr int(11) unsigned default '0',
65 cn_parent_tr_iso_nr int(11) unsigned default '0',
66 cn_official_name_local varchar(128) default '',
67 cn_official_name_en varchar(128) default '',
68 cn_capital varchar(45) default '',
69 cn_tldomain char(2) default '',
70 cn_currency_iso_3 char(3) default '',
71 cn_currency_iso_nr int(10) unsigned default '0',
72 cn_phone int(10) unsigned default '0',
73 cn_eu_member tinyint(3) unsigned default '0',
74 cn_address_format tinyint(3) unsigned default '0',
75 cn_zone_flag tinyint(4) default '0',
76 cn_short_local varchar(70) default '',
77 cn_short_en varchar(50) default '',
78 cn_uno_member tinyint(3) unsigned default '0',
79 PRIMARY KEY (uid),
80 UNIQUE uid (uid)
81 );
82
83
84 INSERT INTO static_countries VALUES ('1', '0', 'AD', 'AND', '20', '39', 'Principat d\'Andorra', 'Principality of Andorra', 'Andorra la Vella', 'ad', 'EUR', '978', '376', '0', '1', '0', 'Andorra', 'Andorra', '1');
85 INSERT INTO static_countries VALUES ('2', '0', 'AE', 'ARE', '784', '0', 'الإمارات العربيّة المتّحدة', 'United Arab Emirates', 'Abu Dhabi', 'ae', 'AED', '784', '971', '0', '1', '0', 'الإمارات العربيّة المتّحدة', 'United Arab Emirates', '1');
86 INSERT INTO static_countries VALUES ('3', '0', 'AF', 'AFG', '4', '34', 'د افغانستان اسلامي دولت', 'Islamic Republic of Afghanistan', 'Kabul', 'af', 'AFN', '971', '93', '0', '2', '0', 'افغانستان', 'Afghanistan', '1');
87 INSERT INTO static_countries VALUES ('4', '0', 'AG', 'ATG', '28', '29', 'Antigua and Barbuda', 'Antigua and Barbuda', 'St John\'s', 'ag', 'XCD', '951', '1268', '0', '1', '0', 'Antigua and Barbuda', 'Antigua and Barbuda', '1');
88 INSERT INTO static_countries VALUES ('5', '0', 'AI', 'AIA', '660', '29', 'Anguilla', 'Anguilla', 'The Valley', 'ai', 'XCD', '951', '1264', '0', '1', '0', 'Anguilla', 'Anguilla', '0');
89 INSERT INTO static_countries VALUES ('6', '0', 'AL', 'ALB', '8', '39', 'Republika e Shqipërisë', 'Republic of Albania', 'Tirana', 'al', 'ALL', '8', '355', '0', '1', '0', 'Shqipëria', 'Albania', '1');
90 INSERT INTO static_countries VALUES ('7', '0', 'AM', 'ARM', '51', '172', 'Հայաստանի Հանրապետություն', 'Republic of Armenia', 'Yerevan', 'am', 'AMD', '51', '374', '0', '1', '0', 'Հայաստան', 'Armenia', '1');
91 INSERT INTO static_countries VALUES ('8', '0', 'AN', 'ANT', '530', '29', 'Nederlandse Antillen', 'Netherlands Antilles', 'Willemstad', 'an', 'ANG', '532', '599', '0', '1', '0', 'Nederlandse Antillen', 'Netherlands Antilles', '0');
92 INSERT INTO static_countries VALUES ('9', '0', 'AO', 'AGO', '24', '17', 'República de Angola', 'Republic of Angola', 'Luanda', 'ao', 'AOA', '973', '244', '0', '1', '0', 'Angola', 'Angola', '1');
93 INSERT INTO static_countries VALUES ('10', '0', 'AQ', 'ATA', '10', '0', 'Antarctica', 'Antarctica', '', 'aq', '', '0', '67212', '0', '1', '0', 'Antarctica', 'Antarctica', '0');
94 INSERT INTO static_countries VALUES ('11', '0', 'AR', 'ARG', '32', '5', 'República Argentina', 'Argentine Republic', 'Buenos Aires', 'ar', 'ARS', '32', '54', '0', '2', '0', 'Argentina', 'Argentina', '1');
95 INSERT INTO static_countries VALUES ('12', '0', 'AS', 'ASM', '16', '61', 'Amerika Samoa', 'American Samoa', 'Pago Pago', 'as', 'USD', '840', '685', '0', '1', '0', 'Amerika Samoa', 'American Samoa', '0');
96 INSERT INTO static_countries VALUES ('13', '0', 'AT', 'AUT', '40', '155', 'Republik Österreich', 'Republic of Austria', 'Vienna', 'at', 'EUR', '978', '43', '1', '1', '0', 'Österreich', 'Austria', '1');
97 INSERT INTO static_countries VALUES ('14', '0', 'AU', 'AUS', '36', '53', 'Commonwealth of Australia', 'Commonwealth of Australia', 'Canberra', 'au', 'AUD', '36', '61', '0', '3', '0', 'Australia', 'Australia', '1');
98 INSERT INTO static_countries VALUES ('15', '0', 'AW', 'ABW', '533', '29', 'Aruba', 'Aruba', 'Oranjestad', 'aw', 'AWG', '533', '297', '0', '0', '0', 'Aruba', 'Aruba', '0');
99 INSERT INTO static_countries VALUES ('16', '0', 'AZ', 'AZE', '31', '172', 'Azərbaycan Respublikası', 'Republic of Azerbaijan', 'Baku', 'az', 'AZM', '31', '994', '0', '1', '0', 'Azərbaycan', 'Azerbaijan', '1');
100 INSERT INTO static_countries VALUES ('17', '0', 'BA', 'BIH', '70', '39', 'Bosna i Hercegovina / Босна и Херцеговина', 'Bosnia and Herzegovina', 'Sarajevo', 'ba', 'BAM', '977', '387', '0', '0', '0', 'BiH/БиХ', 'Bosnia and Herzegovina', '1');
101 INSERT INTO static_countries VALUES ('18', '0', 'BB', 'BRB', '52', '29', 'Barbados', 'Barbados', 'Bridgetown', 'bb', 'BBD', '52', '1246', '0', '1', '0', 'Barbados', 'Barbados', '1');
102 INSERT INTO static_countries VALUES ('19', '0', 'BD', 'BGD', '50', '34', 'গনপ্রজাতন্ত্রী বাংলা', 'People’s Republic of Bangladesh', 'Dhaka', 'bd', 'BDT', '50', '880', '0', '1', '0', 'বাংলাদেশ', 'Bangladesh', '1');
103 INSERT INTO static_countries VALUES ('20', '0', 'BE', 'BEL', '56', '155', 'Koninkrijk België / Royaume de Belgique', 'Kingdom of Belgium', 'Brussels', 'be', 'EUR', '978', '32', '1', '1', '0', 'Belgique', 'Belgium', '1');
104 INSERT INTO static_countries VALUES ('21', '0', 'BF', 'BFA', '854', '11', 'Burkina Faso', 'Burkina Faso', 'Ouagadougou', 'bf', 'XOF', '952', '226', '0', '1', '0', 'Burkina', 'Burkina Faso', '1');
105 INSERT INTO static_countries VALUES ('22', '0', 'BG', 'BGR', '100', '151', 'Република България', 'Republic of Bulgaria', 'Sofia', 'bg', 'BGL', '100', '359', '0', '1', '0', 'България', 'Bulgaria', '1');
106 INSERT INTO static_countries VALUES ('23', '0', 'BH', 'BHR', '48', '145', 'مملكة البحرين', 'Kingdom of Bahrain', 'Manama', 'bh', 'BHD', '48', '973', '0', '1', '0', 'البحري', 'Bahrain', '1');
107 INSERT INTO static_countries VALUES ('24', '0', 'BI', 'BDI', '108', '14', 'Republika y\'u Burundi', 'Republic of Burundi', 'Bujumbura', 'bi', 'BIF', '108', '257', '0', '1', '0', 'Burundi', 'Burundi', '1');
108 INSERT INTO static_countries VALUES ('25', '0', 'BJ', 'BEN', '204', '11', 'République du Bénin', 'Republic of Benin', 'Porto Novo', 'bj', 'XOF', '952', '229', '0', '1', '0', 'Bénin', 'Benin', '1');
109 INSERT INTO static_countries VALUES ('26', '0', 'BM', 'BMU', '60', '21', 'Bermuda', 'Bermuda', 'Hamilton', 'bm', 'BMD', '60', '1441', '0', '1', '0', 'Bermuda', 'Bermuda', '0');
110 INSERT INTO static_countries VALUES ('27', '0', 'BN', 'BRN', '96', '35', 'برني دارالسلام', 'Sultanate of Brunei', 'Bandar Seri Begawan', 'bn', 'BND', '96', '673', '0', '1', '0', 'دارالسلام', 'Brunei', '1');
111 INSERT INTO static_countries VALUES ('28', '0', 'BO', 'BOL', '68', '5', 'República de Bolivia', 'Republic of Bolivia', 'Sucre', 'bo', 'BOB', '68', '591', '0', '1', '0', 'Bolivia', 'Bolivia', '1');
112 INSERT INTO static_countries VALUES ('29', '0', 'BR', 'BRA', '76', '5', 'República Federativa do Brasil', 'Federative Republic of Brazil', 'Brasilia', 'br', 'BRL', '986', '55', '0', '9', '0', 'Brasil', 'Brazil', '1');
113 INSERT INTO static_countries VALUES ('30', '0', 'BS', 'BHS', '44', '29', 'Commonwealth of The Bahamas', 'Commonwealth of The Bahamas', 'Nassau', 'bs', 'BSD', '44', '1242', '0', '1', '0', 'The Bahamas', 'The Bahamas', '1');
114 INSERT INTO static_countries VALUES ('31', '0', 'BT', 'BTN', '64', '34', 'Druk-Yul', 'Kingdom of Bhutan', 'Thimphu', 'bt', 'BTN', '64', '975', '0', '1', '0', 'Druk-Yul', 'Bhutan', '1');
115 INSERT INTO static_countries VALUES ('32', '0', 'BV', 'BVT', '74', '0', 'Bouvet Island', 'Bouvet Island', '', 'bv', 'NOK', '578', '0', '0', '1', '0', 'Bouvet Island', 'Bouvet Island', '0');
116 INSERT INTO static_countries VALUES ('33', '0', 'BW', 'BWA', '72', '18', 'Republic of Botswana', 'Republic of Botswana', 'Gaborone', 'bw', 'BWP', '72', '267', '0', '1', '0', 'Botswana', 'Botswana', '1');
117 INSERT INTO static_countries VALUES ('34', '0', 'BY', 'BLR', '112', '172', 'Рэспубліка Беларусь', 'Republic of Belarus', 'Minsk', 'by', 'BYR', '974', '375', '0', '1', '0', 'Беларусь', 'Belarus', '1');
118 INSERT INTO static_countries VALUES ('35', '0', 'BZ', 'BLZ', '84', '13', 'Belize', 'Belize', 'Belmopan', 'bz', 'BZD', '84', '501', '0', '1', '0', 'Belize', 'Belize', '1');
119 INSERT INTO static_countries VALUES ('36', '0', 'CA', 'CAN', '124', '21', 'Canada', 'Canada', 'Ottawa', 'ca', 'CAD', '124', '1', '0', '4', '0', 'Canada', 'Canada', '1');
120 INSERT INTO static_countries VALUES ('37', '0', 'CC', 'CCK', '166', '53', 'Territory of Cocos (Keeling) Islands', 'Territory of Cocos (Keeling) Islands', 'Bantam', 'cc', 'AUD', '36', '6722', '0', '1', '0', 'Cocos (Keeling) Islands', 'Cocos (Keeling) Islands', '0');
121 INSERT INTO static_countries VALUES ('38', '0', 'CD', 'COD', '180', '17', 'République Démocratique du Congo', 'Democratic Republic of the Congo', 'Kinshasa', 'cd', 'CDF', '976', '0', '0', '0', '0', 'Congo', 'Congo', '1');
122 INSERT INTO static_countries VALUES ('39', '0', 'CF', 'CAF', '140', '17', 'République Centrafricaine', 'Central African Republic', 'Bangui', 'cf', 'XAF', '950', '236', '0', '1', '0', 'Centrafrique', 'Central African Republic', '1');
123 INSERT INTO static_countries VALUES ('40', '0', 'CG', 'COG', '178', '17', 'République du Congo', 'Republic of the Congo', 'Brazzaville', 'cg', 'XAF', '950', '242', '0', '1', '0', 'Congo-Brazzaville', 'Congo-Brazzaville', '1');
124 INSERT INTO static_countries VALUES ('41', '0', 'CH', 'CHE', '756', '155', 'Confédération suisse / Schweizerische Eidgenossenschaft', 'Swiss Confederation', 'Berne', 'ch', 'CHF', '756', '41', '0', '1', '0', 'Schweiz', 'Switzerland', '1');
125 INSERT INTO static_countries VALUES ('42', '0', 'CI', 'CIV', '384', '11', 'République de Côte d’Ivoire', 'Republic of Côte d\'Ivoire', 'Yamoussoukro', 'ci', 'XOF', '952', '225', '0', '2', '0', 'Côte d’Ivoire', 'Côte d’Ivoire', '1');
126 INSERT INTO static_countries VALUES ('43', '0', 'CK', 'COK', '184', '61', 'Cook Islands', 'Cook Islands', 'Avarua', 'ck', 'NZD', '554', '682', '0', '1', '0', 'Cook Islands', 'Cook Islands', '0');
127 INSERT INTO static_countries VALUES ('44', '0', 'CL', 'CHL', '152', '5', 'República de Chile', 'Republic of Chile', 'Santiago', 'cl', 'CLP', '152', '56', '0', '1', '0', 'Chile', 'Chile', '1');
128 INSERT INTO static_countries VALUES ('45', '0', 'CM', 'CMR', '120', '17', 'Republic of Cameroon / République du Cameroun', 'Republic of Cameroon', 'Yaoundé', 'cm', 'XAF', '950', '237', '0', '1', '0', 'Cameroun', 'Cameroon', '1');
129 INSERT INTO static_countries VALUES ('46', '0', 'CN', 'CHN', '156', '30', '中华人民共和国', 'People’s Republic of China', 'Beijing', 'cn', 'CNY', '156', '86', '0', '1', '0', '中华', 'China', '1');
130 INSERT INTO static_countries VALUES ('47', '0', 'CO', 'COL', '170', '5', 'República de Colombia', 'Republic of Colombia', 'Bogotá', 'co', 'COP', '170', '57', '0', '1', '0', 'Colombia', 'Colombia', '1');
131 INSERT INTO static_countries VALUES ('48', '0', 'CR', 'CRI', '188', '13', 'República de Costa Rica', 'Republic of Costa Rica', 'San José', 'cr', 'CRC', '188', '506', '0', '1', '0', 'Costa Rica', 'Costa Rica', '1');
132 INSERT INTO static_countries VALUES ('49', '0', 'CU', 'CUB', '192', '29', 'República de Cuba', 'Republic of Cuba', 'Havana', 'cu', 'CUP', '192', '53', '0', '1', '0', 'Cuba', 'Cuba', '1');
133 INSERT INTO static_countries VALUES ('50', '0', 'CV', 'CPV', '132', '11', 'República de Cabo Verde', 'Republic of Cape Verde', 'Praia', 'cv', 'CVE', '132', '238', '0', '1', '0', 'Cabo Verde', 'Cape Verde', '1');
134 INSERT INTO static_countries VALUES ('51', '0', 'CX', 'CXR', '162', '0', 'Territory of Christmas Island', 'Territory of Christmas Island', 'Flying Fish Cove', 'cx', 'AUD', '36', '6724', '0', '1', '0', 'Christmas Island', 'Christmas Island', '0');
135 INSERT INTO static_countries VALUES ('52', '0', 'CY', 'CYP', '196', '145', 'Κυπριακή Δημοκρατία / Kıbrıs Cumhuriyeti', 'Republic of Cyprus', 'Nicosia', 'cy', 'CYP', '196', '357', '1', '1', '0', 'Κύπρος / Kıbrıs', 'Cyprus', '1');
136 INSERT INTO static_countries VALUES ('53', '0', 'CZ', 'CZE', '203', '151', 'Česká republika', 'Czech Republic', 'Prague', 'cz', 'CZK', '203', '420', '1', '1', '0', 'Cesko', 'Czech Republic', '1');
137 INSERT INTO static_countries VALUES ('54', '0', 'DE', 'DEU', '276', '155', 'Bundesrepublik Deutschland', 'Federal Republic of Germany', 'Berlin', 'de', 'EUR', '978', '49', '1', '1', '0', 'Deutschland', 'Germany', '1');
138 INSERT INTO static_countries VALUES ('55', '0', 'DJ', 'DJI', '262', '14', 'جمهورية جيبوتي / République de Djibouti', 'Republic of Djibouti', 'Djibouti', 'dj', 'DJF', '262', '253', '0', '1', '0', 'جيبوتي /Djibouti', 'Djibouti', '1');
139 INSERT INTO static_countries VALUES ('56', '0', 'DK', 'DNK', '208', '154', 'Kongeriget Danmark', 'Kingdom of Denmark', 'Copenhagen', 'dk', 'DKK', '208', '45', '1', '1', '0', 'Danmark', 'Denmark', '1');
140 INSERT INTO static_countries VALUES ('57', '0', 'DM', 'DMA', '212', '29', 'Commonwealth of Dominica', 'Commonwealth of Dominica', 'Roseau', 'dm', 'XCD', '951', '1767', '0', '1', '0', 'Dominica', 'Dominica', '1');
141 INSERT INTO static_countries VALUES ('58', '0', 'DO', 'DOM', '214', '29', 'República Dominicana', 'Dominican Republic', 'Santo Domingo', 'do', 'DOP', '214', '1809', '0', '1', '0', 'Quisqueya', 'Dominican Republic', '1');
142 INSERT INTO static_countries VALUES ('59', '0', 'DZ', 'DZA', '12', '15', 'الجمهورية الجزائرية الديمقراطية', 'People’s Democratic Republic of Algeria', 'Algiers', 'dz', 'DZD', '12', '213', '0', '1', '0', 'الجزائ', 'Algeria', '1');
143 INSERT INTO static_countries VALUES ('60', '0', 'EC', 'ECU', '218', '5', 'República del Ecuador', 'Republic of Ecuador', 'Quito', 'ec', 'USD', '840', '593', '0', '1', '0', 'Ecuador', 'Ecuador', '1');
144 INSERT INTO static_countries VALUES ('61', '0', 'EE', 'EST', '233', '154', 'Eesti Vabariik', 'Republic of Estonia', 'Tallinn', 'ee', 'EEK', '233', '372', '1', '1', '0', 'Eesti', 'Estonia', '1');
145 INSERT INTO static_countries VALUES ('62', '0', 'EG', 'EGY', '818', '15', 'جمهوريّة مصر العربيّة', 'Arab Republic of Egypt', 'Cairo', 'eg', 'EGP', '818', '20', '0', '1', '0', 'مصر', 'Egypt', '1');
146 INSERT INTO static_countries VALUES ('63', '0', 'EH', 'ESH', '732', '15', 'الصحراء الغربية', 'Western Sahara', 'El Aaiún', 'eh', 'MAD', '504', '0', '0', '1', '0', 'الصحراء الغربي', 'Western Sahara', '0');
147 INSERT INTO static_countries VALUES ('64', '0', 'ER', 'ERI', '232', '14', 'ሃግሬ ኤርትራ', 'State of Eritrea', 'Asmara', 'er', 'ERN', '232', '291', '0', '1', '0', 'ኤርትራ', 'Eritrea', '1');
148 INSERT INTO static_countries VALUES ('65', '0', 'ES', 'ESP', '724', '39', 'Reino de España', 'Kingdom of Spain', 'Madrid', 'es', 'EUR', '978', '34', '1', '8', '0', 'España', 'Spain', '1');
149 INSERT INTO static_countries VALUES ('66', '0', 'ET', 'ETH', '231', '14', 'የኢትዮጵያ ፌዴራላዊ', 'Federal Democratic Republic of Ethiopia', 'Addis Ababa', 'et', 'ETB', '230', '251', '0', '1', '0', 'ኢትዮጵያ', 'Ethiopia', '1');
150 INSERT INTO static_countries VALUES ('67', '0', 'FI', 'FIN', '246', '154', 'Suomen Tasavalta / Republiken Finland', 'Republic of Finland', 'Helsinki', 'fi', 'EUR', '978', '358', '1', '1', '0', 'Suomi', 'Finland', '1');
151 INSERT INTO static_countries VALUES ('68', '0', 'FJ', 'FJI', '242', '54', 'Republic of the Fiji Islands / Matanitu Tu-Vaka-i-koya ko Vi', 'Republic of the Fiji Islands', 'Suva', 'fj', 'FJD', '242', '679', '0', '1', '0', 'Viti', 'Fiji', '1');
152 INSERT INTO static_countries VALUES ('69', '0', 'FK', 'FLK', '238', '5', 'Falkland Islands', 'Falkland Islands', 'Stanley', 'fk', 'FKP', '238', '500', '0', '1', '0', 'Falkland Islands', 'Falkland Islands', '0');
153 INSERT INTO static_countries VALUES ('70', '0', 'FM', 'FSM', '583', '57', 'Federated States of Micronesia', 'Federated States of Micronesia', 'Palikir', 'fm', 'USD', '840', '691', '0', '1', '0', 'Micronesia', 'Micronesia', '1');
154 INSERT INTO static_countries VALUES ('71', '0', 'FO', 'FRO', '234', '154', 'Føroyar / Færøerne', 'Faroe Islands', 'Thorshavn', 'fo', 'DKK', '208', '298', '0', '1', '0', 'Føroyar / Færøerne', 'Faroes', '0');
155 INSERT INTO static_countries VALUES ('72', '0', 'FR', 'FRA', '250', '155', 'République française', 'French Republic', 'Paris', 'fr', 'EUR', '978', '33', '1', '1', '0', 'France', 'France', '1');
156 INSERT INTO static_countries VALUES ('73', '0', 'GA', 'GAB', '266', '17', 'République Gabonaise', 'Gabonese Republic', 'Libreville', 'ga', 'XAF', '950', '241', '0', '1', '0', 'Gabon', 'Gabon', '1');
157 INSERT INTO static_countries VALUES ('74', '0', 'GB', 'GBR', '826', '154', 'United Kingdom of Great Britain and Northern', 'United Kingdom of Great Britain and Northern', 'London', 'uk', 'GBP', '826', '44', '1', '5', '0', 'United Kingdom', 'United Kingdom', '1');
158 INSERT INTO static_countries VALUES ('75', '0', 'GD', 'GRD', '308', '29', 'Grenada', 'Grenada', 'St George\'s', 'gd', 'XCD', '951', '1473', '0', '1', '0', 'Grenada', 'Grenada', '1');
159 INSERT INTO static_countries VALUES ('76', '0', 'GE', 'GEO', '268', '172', 'საქართველო', 'Georgia', 'Tbilisi', 'ge', 'GEL', '981', '995', '0', '1', '0', 'საქართველო', 'Georgia', '1');
160 INSERT INTO static_countries VALUES ('77', '0', 'GF', 'GUF', '254', '5', 'Guyane française', 'French Guiana', 'Cayenne', 'gf', 'EUR', '978', '594', '0', '1', '0', 'Guyane française', 'French Guiana', '0');
161 INSERT INTO static_countries VALUES ('78', '0', 'GH', 'GHA', '288', '11', 'Republic of Ghana', 'Republic of Ghana', 'Accra', 'gh', 'GHC', '288', '233', '0', '1', '0', 'Ghana', 'Ghana', '1');
162 INSERT INTO static_countries VALUES ('79', '0', 'GI', 'GIB', '292', '39', 'Gibraltar', 'Gibraltar', 'Gibraltar', 'gi', 'GIP', '292', '350', '0', '1', '0', 'Gibraltar', 'Gibraltar', '0');
163 INSERT INTO static_countries VALUES ('80', '0', 'GL', 'GRL', '304', '21', 'Kalaallit Nunaat / Grønland', 'Greenland', 'Nuuk', 'gl', 'DKK', '208', '299', '0', '1', '0', 'Grønland', 'Greenland', '0');
164 INSERT INTO static_countries VALUES ('81', '0', 'GM', 'GMB', '270', '11', 'Republic of The Gambia', 'Republic of The Gambia', 'Banjul', 'gm', 'GMD', '270', '220', '0', '1', '0', 'Gambia', 'Gambia', '1');
165 INSERT INTO static_countries VALUES ('82', '0', 'GN', 'GIN', '324', '11', 'République de Guinée', 'Republic of Guinea', 'Conakry', 'gn', 'GNF', '324', '224', '0', '1', '0', 'Guinée', 'Guinea', '1');
166 INSERT INTO static_countries VALUES ('83', '0', 'GP', 'GLP', '312', '29', 'Département de la Guadeloupe', 'Department of Guadeloupe', 'Basse Terre', 'gp', 'EUR', '978', '590', '0', '1', '0', 'Guadeloupe', 'Guadeloupe', '0');
167 INSERT INTO static_countries VALUES ('84', '0', 'GQ', 'GNQ', '226', '17', 'República de Guinea Ecuatorial', 'Republic of Equatorial Guinea', 'Malabo', 'gq', 'XAF', '950', '240', '0', '1', '0', 'Guinea Ecuatorial', 'Equatorial Guinea', '1');
168 INSERT INTO static_countries VALUES ('85', '0', 'GR', 'GRC', '300', '39', 'Ελληνική Δημοκρατία', 'Hellenic Republic', 'Athens', 'gr', 'EUR', '978', '30', '1', '1', '0', 'Ελλάδα', 'Greece', '1');
169 INSERT INTO static_countries VALUES ('86', '0', 'GS', 'SGS', '239', '0', 'South Georgia and the South Sandwich Islands', 'South Georgia and the South Sandwich Islands', '', 'gs', '', '0', '0', '0', '0', '0', 'South Georgia and the South Sandwich Islands', 'South Georgia and the South Sandwich Islands', '0');
170 INSERT INTO static_countries VALUES ('87', '0', 'GT', 'GTM', '320', '13', 'República de Guatemala', 'Republic of Guatemala', 'Guatemala City', 'gt', 'GTQ', '320', '502', '0', '1', '0', 'Guatemala', 'Guatemala', '1');
171 INSERT INTO static_countries VALUES ('88', '0', 'GU', 'GUM', '316', '57', 'The Territory of Guam / Guåhån', 'The Territory of Guam', 'Hagåtña', 'gu', 'USD', '840', '671', '0', '1', '0', 'Guåhån', 'Guam', '0');
172 INSERT INTO static_countries VALUES ('89', '0', 'GW', 'GNB', '624', '11', 'República da Guiné-Bissau', 'Republic of Guinea-Bissau', 'Bissau', 'gw', 'XOF', '952', '245', '0', '1', '0', 'Guiné-Bissau', 'Guinea-Bissau', '1');
173 INSERT INTO static_countries VALUES ('90', '0', 'GY', 'GUY', '328', '5', 'Co-operative Republic of Guyana', 'Co-operative Republic of Guyana', 'Georgetown', 'gy', 'GYD', '328', '592', '0', '1', '0', 'Guyana', 'Guyana', '1');
174 INSERT INTO static_countries VALUES ('91', '0', 'HK', 'HKG', '344', '30', '香港特別行政區', 'Hong Kong SAR of the People’s Republic of China', '', 'hk', 'HKD', '344', '852', '0', '1', '0', '香港', 'Hong Kong SAR of China', '0');
175 INSERT INTO static_countries VALUES ('92', '0', 'HN', 'HND', '340', '13', 'República de Honduras', 'Republic of Honduras', 'Tegucigalpa', 'hn', 'HNL', '340', '504', '0', '1', '0', 'Honduras', 'Honduras', '1');
176 INSERT INTO static_countries VALUES ('93', '0', 'HR', 'HRV', '191', '39', 'Republika Hrvatska', 'Republic of Croatia', 'Zagreb', 'hr', 'HRK', '191', '385', '0', '1', '0', 'Hrvatska', 'Croatia', '1');
177 INSERT INTO static_countries VALUES ('94', '0', 'HT', 'HTI', '332', '29', 'Repiblik d Ayiti / République d\'Haïti', 'Republic of Haiti', 'Port-au-Prince', 'ht', 'HTG', '332', '509', '0', '1', '0', 'Ayiti', 'Haiti', '1');
178 INSERT INTO static_countries VALUES ('95', '0', 'HU', 'HUN', '348', '151', 'Magyar Köztársaság', 'Republic of Hungary', 'Budapest', 'hu', 'HUF', '348', '36', '1', '1', '0', 'Magyarország', 'Hungary', '1');
179 INSERT INTO static_countries VALUES ('96', '0', 'ID', 'IDN', '360', '35', 'Republik Indonesia', 'Republic of Indonesia', 'Jakarta', 'id', 'IDR', '360', '62', '0', '2', '0', 'Indonesia', 'Indonesia', '1');
180 INSERT INTO static_countries VALUES ('97', '0', 'IE', 'IRL', '372', '154', 'Poblacht na hÉireann / Republic of Ireland', 'Republic of Ireland', 'Dublin', 'ie', 'EUR', '978', '353', '1', '1', '0', 'Éire', 'Ireland', '1');
181 INSERT INTO static_countries VALUES ('98', '0', 'IL', 'ISR', '376', '145', 'دولة إسرائيل / מדינת ישראלل', 'State of Israel', 'Tel Aviv', 'il', 'ILS', '376', '972', '0', '2', '0', 'ישראל', 'Israel', '1');
182 INSERT INTO static_countries VALUES ('99', '0', 'IN', 'IND', '356', '34', 'Bharat; Republic of India', 'Republic of India', 'New Delhi', 'in', 'INR', '356', '91', '0', '2', '0', 'India', 'India', '1');
183 INSERT INTO static_countries VALUES ('100', '0', 'IO', 'IOT', '86', '0', 'British Indian Ocean Territory', 'British Indian Ocean Territory', '', 'io', '', '0', '0', '0', '1', '0', 'British Indian Ocean Territory', 'British Indian Ocean Territory', '0');
184 INSERT INTO static_countries VALUES ('101', '0', 'IQ', 'IRQ', '368', '145', 'الجمهورية العراقية', 'Republic of Iraq', 'Baghdad', 'iq', 'IQD', '368', '964', '0', '1', '0', 'العراق / عيَراق', 'Iraq', '1');
185 INSERT INTO static_countries VALUES ('102', '0', 'IR', 'IRN', '364', '34', 'جمهوری اسلامی ايران', 'Islamic Republic of Iran', 'Tehran', 'ir', 'IRR', '364', '98', '0', '1', '0', 'ايران', 'Iran', '1');
186 INSERT INTO static_countries VALUES ('103', '0', 'IS', 'ISL', '352', '154', 'Lýðveldið Ísland', 'Republic of Iceland', 'Reykjavík', 'is', 'ISK', '352', '354', '0', '1', '0', 'Ísland', 'Iceland', '1');
187 INSERT INTO static_countries VALUES ('104', '0', 'IT', 'ITA', '380', '39', 'Repubblica Italiana', 'Italian Republic', 'Rome', 'it', 'EUR', '978', '39', '1', '7', '0', 'Italia', 'Italy', '1');
188 INSERT INTO static_countries VALUES ('105', '0', 'JM', 'JAM', '388', '29', 'Commonwealth of Jamaica', 'Commonwealth of Jamaica', 'Kingston', 'jm', 'JMD', '388', '1876', '0', '2', '0', 'Jamaica', 'Jamaica', '1');
189 INSERT INTO static_countries VALUES ('106', '0', 'JO', 'JOR', '400', '145', 'المملكة الأردنية الهاشمية', 'Hashemite Kingdom of Jordan', 'Amman', 'jo', 'JOD', '400', '962', '0', '1', '0', 'أردنّ', 'Jordan', '1');
190 INSERT INTO static_countries VALUES ('107', '0', 'JP', 'JPN', '392', '30', '日本国', 'Japan', 'Tokyo', 'jp', 'JPY', '392', '81', '0', '2', '0', '日本', 'Japan', '1');
191 INSERT INTO static_countries VALUES ('108', '0', 'KE', 'KEN', '404', '14', 'Jamhuri va Kenya', 'Republic of Kenia', 'Nairobi', 'ke', 'KES', '404', '254', '0', '1', '0', 'Kenya', 'Kenya', '1');
192 INSERT INTO static_countries VALUES ('109', '0', 'KG', 'KGZ', '417', '143', 'Кыргызстан', 'Kyrgyzstan', 'Bishkek', 'kg', 'KGS', '417', '7', '0', '1', '0', 'Кыргызстан', 'Kyrgyzstan', '1');
193 INSERT INTO static_countries VALUES ('110', '0', 'KH', 'KHM', '116', '35', 'Preăh Réachéanachâkr Kâmpŭchea', 'Kingdom of Cambodia', 'Phnom Penh', 'kh', 'KHR', '116', '855', '0', '1', '0', 'Kâmpŭchea', 'Cambodia', '1');
194 INSERT INTO static_countries VALUES ('111', '0', 'KI', 'KIR', '296', '57', 'Republic of Kiribati', 'Republic of Kiribati', 'Bairiki', 'ki', 'AUD', '36', '686', '0', '0', '0', 'Kiribati', 'Kiribati', '1');
195 INSERT INTO static_countries VALUES ('112', '0', 'KM', 'COM', '174', '14', 'Udzima wa Komori /Union des Comores /اتحاد القمر', 'Union of the Comoros', 'Moroni', 'km', 'KMF', '174', '269', '0', '1', '0', 'اتحاد القمر', 'Comoros', '1');
196 INSERT INTO static_countries VALUES ('113', '0', 'KN', 'KNA', '659', '29', 'Federation of Saint Kitts and Nevis', 'Federation of Saint Kitts and Nevis', 'Basseterre', 'kn', 'XCD', '951', '1869', '0', '1', '0', 'Saint Kitts and Nevis', 'Saint Kitts and Nevis', '1');
197 INSERT INTO static_countries VALUES ('114', '0', 'KP', 'PRK', '408', '30', '조선민주주의인민화국', 'Democratic People’s Republic of Korea', 'Pyongyang', 'kp', 'KPW', '408', '850', '0', '0', '0', '북조선', 'North Korea', '1');
198 INSERT INTO static_countries VALUES ('115', '0', 'KR', 'KOR', '410', '30', '대한민국', 'Republic of Korea', 'Seoul', 'kr', 'KRW', '410', '82', '0', '1', '0', '한국', 'South Korea', '1');
199 INSERT INTO static_countries VALUES ('116', '0', 'KW', 'KWT', '414', '145', 'دولة الكويت', 'State of Kuweit', 'Kuwait City', 'kw', 'KWD', '414', '965', '0', '1', '0', 'الكويت', 'Kuwait', '1');
200 INSERT INTO static_countries VALUES ('117', '0', 'KY', 'CYM', '136', '29', 'Cayman Islands', 'Cayman Islands', 'George Town', 'ky', 'KYD', '136', '1345', '0', '1', '0', 'Cayman Islands', 'Cayman Islands', '0');
201 INSERT INTO static_countries VALUES ('118', '0', 'KZ', 'KAZ', '398', '143', 'Қазақстан Республикасы /Республика Казахстан', 'Republic of Kazakhstan', 'Astana', 'kz', 'KZT', '398', '7', '0', '1', '0', 'Қазақстан /Казахстан', 'Kazakhstan', '1');
202 INSERT INTO static_countries VALUES ('119', '0', 'LA', 'LAO', '418', '35', 'ສາທາລະນະລັດປະຊາທິປະໄຕປະຊາຊົນລາວ', 'Lao People’s Democratic Republic', 'Vientiane', 'la', 'LAK', '418', '856', '0', '1', '0', 'ເມືອງລາວ', 'Laos', '1');
203 INSERT INTO static_countries VALUES ('120', '0', 'LB', 'LBN', '422', '145', 'الجمهوريّة اللبنانيّة', 'Republic of Lebanon', 'Beirut', 'lb', 'LBP', '422', '961', '0', '1', '0', 'لبنان', 'Lebanon', '1');
204 INSERT INTO static_countries VALUES ('121', '0', 'LC', 'LCA', '662', '29', 'Saint Lucia', 'Saint Lucia', 'Castries', 'lc', 'XCD', '951', '1758', '0', '1', '0', 'Saint Lucia', 'Saint Lucia', '1');
205 INSERT INTO static_countries VALUES ('122', '0', 'LI', 'LIE', '438', '155', 'Fürstentum Liechtenstein', 'Principality of Liechtenstein', 'Vaduz', 'li', 'CHF', '756', '41', '0', '1', '0', 'Liechtenstein', 'Liechtenstein', '1');
206 INSERT INTO static_countries VALUES ('123', '0', 'LK', 'LKA', '144', '34', 'ශ්‍රී ලංකා / இலங்கை சனநாயக சோஷலிசக் குடியரசு', 'Democratic Socialist Republic of Sri Lanka', 'Colombo', 'lk', 'LKR', '144', '94', '0', '2', '0', 'ශ්‍රී ලංකා / இலங்கை', 'Sri Lanka', '1');
207 INSERT INTO static_countries VALUES ('124', '0', 'LR', 'LBR', '430', '11', 'Republic of Liberia', 'Republic of Liberia', 'Monrovia', 'lr', 'LRD', '430', '231', '0', '1', '0', 'Liberia', 'Liberia', '1');
208 INSERT INTO static_countries VALUES ('125', '0', 'LS', 'LSO', '426', '18', 'Muso oa Lesotho / Kingdom of Lesotho', 'Kingdon of Lesotho', 'Maseru', 'ls', 'LSL', '426', '266', '0', '1', '0', 'Lesotho', 'Lesotho', '1');
209 INSERT INTO static_countries VALUES ('126', '0', 'LT', 'LTU', '440', '154', 'Lietuvos Respublika', 'Republic of Lithuania', 'Vilnius', 'lt', 'LTL', '440', '370', '1', '1', '0', 'Lietuva', 'Lithuania', '1');
210 INSERT INTO static_countries VALUES ('127', '0', 'LU', 'LUX', '442', '155', 'Grand-Duché de Luxembourg / Großherzogtum Luxemburg / Groussherzogtum Lëtzebuerg', 'Grand Duchy of Luxembourg', 'Luxembourg', 'lu', 'EUR', '978', '352', '1', '1', '0', 'Luxemburg', 'Luxembourg', '1');
211 INSERT INTO static_countries VALUES ('128', '0', 'LV', 'LVA', '428', '154', 'Latvijas Republika', 'Republic of Latvia', 'Riga', 'lv', 'LVL', '428', '371', '1', '1', '0', 'Latvija', 'Latvia', '1');
212 INSERT INTO static_countries VALUES ('129', '0', 'LY', 'LBY', '434', '15', 'الجماهيرية العربية الليبية الشعبية الإشتراكية ﺍﻟﻌﻆﻤﻰ', 'Great Socialist People’s Libyan Arab Jamahiriya', 'Tripoli', 'ly', 'LYD', '434', '218', '0', '1', '0', 'الليبية', 'Libya', '1');
213 INSERT INTO static_countries VALUES ('130', '0', 'MA', 'MAR', '504', '15', 'المملكة المغربية', 'Kingdom of Morocco', 'Rabat', 'ma', 'MAD', '504', '212', '0', '1', '0', 'المغربية', 'Morocco', '1');
214 INSERT INTO static_countries VALUES ('131', '0', 'MC', 'MCO', '492', '155', 'Principauté de Monaco / Principatu de Munegu', 'Principality of Monaco', 'Monaco', 'mc', 'EUR', '978', '377', '0', '1', '0', 'Monaco', 'Monaco', '1');
215 INSERT INTO static_countries VALUES ('132', '0', 'MD', 'MDA', '498', '172', 'Republica Moldova', 'Republic of Moldova', 'Chisinau', 'md', 'MDL', '498', '373', '0', '1', '0', 'Moldova', 'Moldova', '1');
216 INSERT INTO static_countries VALUES ('133', '0', 'MG', 'MDG', '450', '14', 'Repoblikan\'i Madagasikara / République de Madagascar', 'Republic of Madagascar', 'Antananarivo', 'mg', 'MGA', '969', '261', '0', '1', '0', 'Madagascar', 'Madagascar', '1');
217 INSERT INTO static_countries VALUES ('134', '0', 'MH', 'MHL', '584', '57', 'Aolepān Aorōkin M̧ajeļ / Republic of the Marshall Islands', 'Republic of the Marshall Islands', 'Dalap-Uliga-Darrit (DUD)', 'mh', 'USD', '840', '692', '0', '1', '0', 'Marshall Islands', 'Marshall Islands', '1');
218 INSERT INTO static_countries VALUES ('135', '0', 'MK', 'MKD', '807', '39', 'Република Македонија', 'Republic of Macedonia', 'Skopje', 'mk', 'MKD', '807', '389', '0', '1', '0', 'Македонија', 'Macedonia', '1');
219 INSERT INTO static_countries VALUES ('136', '0', 'ML', 'MLI', '466', '11', 'République du Mali', 'Republik Mali', 'Bamako', 'ml', 'XOF', '952', '223', '0', '1', '0', 'Mali', 'Mali', '1');
220 INSERT INTO static_countries VALUES ('137', '0', 'MM', 'MMR', '104', '35', 'Pyidaungzu Myanma Naingngandaw', 'Union of Myanmar', 'Yangon', 'mm', 'MMK', '104', '95', '0', '1', '0', 'Myanmar', 'Myanmar', '1');
221 INSERT INTO static_countries VALUES ('138', '0', 'MN', 'MNG', '496', '30', 'Монгол Улс', 'Mongolia', 'Ulan Bator', 'mn', 'MNT', '496', '976', '0', '1', '0', 'Монгол Улс', 'Mongolia', '1');
222 INSERT INTO static_countries VALUES ('139', '0', 'MO', 'MAC', '446', '30', '中華人民共和國澳門特別行政區 / Região Administrativa Especial de Macau da República Popular da China', 'Macao SAR of the People’s Republic of China', 'Macau', 'mo', 'MOP', '446', '853', '0', '1', '0', '澳門 / Macau', 'Macao SAR of China', '0');
223 INSERT INTO static_countries VALUES ('140', '0', 'MP', 'MNP', '580', '57', 'Commonwealth of the Northern Mariana Islands', 'Commonwealth of the Northern Mariana Islands', 'Garapan', 'mp', 'USD', '840', '1670', '0', '0', '0', 'Northern Marianas', 'Northern Marianas', '0');
224 INSERT INTO static_countries VALUES ('141', '0', 'MQ', 'MTQ', '474', '29', 'Département de la Martinique', 'Department of Martinique', 'Fort-de-France', 'mq', 'EUR', '978', '596', '0', '1', '0', 'Martinique', 'Martinique', '0');
225 INSERT INTO static_countries VALUES ('142', '0', 'MR', 'MRT', '478', '11', 'الجمهورية الإسلامية الموريتانية', 'Islamic Republic of Mauritania', 'Nouakchott', 'mr', 'MRO', '478', '222', '0', '1', '0', 'الموريتانية', 'Mauritania', '1');
226 INSERT INTO static_countries VALUES ('143', '0', 'MS', 'MSR', '500', '29', 'Montserrat', 'Montserrat', 'Plymouth', 'ms', 'XCD', '951', '1664', '0', '1', '0', 'Montserrat', 'Montserrat', '0');
227 INSERT INTO static_countries VALUES ('144', '0', 'MT', 'MLT', '470', '39', 'Repubblika ta\' Malta / Republic of Malta', 'Republic of Malta', 'Valletta', 'mt', 'MTL', '470', '356', '1', '1', '0', 'Malta', 'Malta', '1');
228 INSERT INTO static_countries VALUES ('145', '0', 'MU', 'MUS', '480', '14', 'Republic of Mauritius', 'Republic of Mauritius', 'Port Louis', 'mu', 'MUR', '480', '230', '0', '1', '0', 'Mauritius', 'Mauritius', '1');
229 INSERT INTO static_countries VALUES ('146', '0', 'MV', 'MDV', '462', '34', 'ދިވެހިރާއްޖޭގެ ޖުމުހޫރިއްޔާ', 'Republic of Maldives', 'Malé', 'mv', 'MVR', '462', '960', '0', '1', '0', 'ޖުމުހޫރިއްޔ', 'Maldives', '1');
230 INSERT INTO static_countries VALUES ('147', '0', 'MW', 'MWI', '454', '14', 'Republic of Malawi / Dziko la Malaŵi', 'Republic of Malawi', 'Lilongwe', 'mw', 'MWK', '454', '265', '0', '1', '0', 'Malawi', 'Malawi', '1');
231 INSERT INTO static_countries VALUES ('148', '0', 'MX', 'MEX', '484', '13', 'Estados Unidos Mexicanos', 'United Mexican States', 'Mexico City', 'mx', 'MXN', '484', '52', '0', '6', '0', 'México', 'Mexico', '1');
232 INSERT INTO static_countries VALUES ('149', '0', 'MY', 'MYS', '458', '35', 'ڤرسكوتوان مليسيا', 'Malaysia', 'Kuala Lumpur', 'my', 'MYR', '458', '60', '0', '1', '0', 'مليسيا', 'Malaysia', '1');
233 INSERT INTO static_countries VALUES ('150', '0', 'MZ', 'MOZ', '508', '14', 'República de Moçambique', 'Republic of Mozambique', 'Maputo', 'mz', 'MZM', '508', '258', '0', '1', '0', 'Moçambique', 'Mozambique', '1');
234 INSERT INTO static_countries VALUES ('151', '0', 'NA', 'NAM', '516', '18', 'Republic of Namibia', 'Republic of Namibia', 'Windhoek', 'na', 'NAD', '516', '264', '0', '1', '0', 'Namibia', 'Namibia', '1');
235 INSERT INTO static_countries VALUES ('152', '0', 'NC', 'NCL', '540', '54', 'Territoire de Nouvelle-Caledonie et Dépendances', 'Territory of New Caledonia', 'Nouméa', 'nc', 'XPF', '953', '687', '0', '1', '0', 'Nouvelle-Calédonie', 'New Caledonia', '0');
236 INSERT INTO static_countries VALUES ('153', '0', 'NE', 'NER', '562', '11', 'République du Niger', 'Republic of Niger', 'Niamey', 'ne', 'XOF', '952', '227', '0', '1', '0', 'Niger', 'Niger', '1');
237 INSERT INTO static_countries VALUES ('154', '0', 'NF', 'NFK', '574', '53', 'Territory of Norfolk Island', 'Territory of Norfolk Island', 'Kingston', 'nf', 'AUD', '36', '6723', '0', '1', '0', 'Norfolk Island', 'Norfolk Island', '0');
238 INSERT INTO static_countries VALUES ('155', '0', 'NG', 'NGA', '566', '11', 'Federal Republic of Nigeria', 'Federal Republic of Nigeria', 'Abuja', 'ng', 'NGN', '566', '234', '0', '1', '0', 'Nigeria', 'Nigeria', '1');
239 INSERT INTO static_countries VALUES ('156', '0', 'NI', 'NIC', '558', '13', 'República de Nicaragua', 'Republic of Nicaragua', 'Managua', 'ni', 'NIO', '558', '505', '0', '1', '0', 'Nicaragua', 'Nicaragua', '1');
240 INSERT INTO static_countries VALUES ('157', '0', 'NL', 'NLD', '528', '155', 'Koninkrijk der Nederlanden', 'Kingdom of the Netherlands', 'Amsterdam', 'nl', 'EUR', '978', '31', '1', '1', '0', 'Nederland', 'Netherlands', '1');
241 INSERT INTO static_countries VALUES ('158', '0', 'NO', 'NOR', '578', '154', 'Kongeriket Norge', 'Kingdom of Norway', 'Oslo', 'no', 'NOK', '578', '47', '0', '1', '0', 'Norge', 'Norway', '1');
242 INSERT INTO static_countries VALUES ('159', '0', 'NP', 'NPL', '524', '34', 'नेपाल अधिराज्य', 'Kingdom of Nepal', 'Kathmandu', 'np', 'NPR', '524', '977', '0', '1', '0', 'नेपाल', 'Nepal', '1');
243 INSERT INTO static_countries VALUES ('160', '0', 'NR', 'NRU', '520', '57', 'Ripublik Naoero', 'Republic of Nauru', 'Yaren', 'nr', 'AUD', '36', '674', '0', '1', '0', 'Naoero', 'Nauru', '1');
244 INSERT INTO static_countries VALUES ('161', '0', 'NU', 'NIU', '570', '61', 'Niue', 'Niue', 'Alofi', 'nu', 'NZD', '554', '683', '0', '1', '0', 'Niue', 'Niue', '0');
245 INSERT INTO static_countries VALUES ('162', '0', 'NZ', 'NZL', '554', '53', 'New Zealand / Aotearoa', 'New Zealand', 'Wellington', 'nz', 'NZD', '554', '64', '0', '2', '0', 'New Zealand / Aotearoa', 'New Zealand', '1');
246 INSERT INTO static_countries VALUES ('163', '0', 'OM', 'OMN', '512', '145', 'سلطنة عُمان', 'Sultanate of Oman', 'Muscat', 'om', 'OMR', '512', '968', '0', '1', '0', 'عُمان', 'Oman', '1');
247 INSERT INTO static_countries VALUES ('164', '0', 'PA', 'PAN', '591', '13', 'República de Panamá', 'Repulic of Panama', 'Panama City', 'pa', 'PAB', '590', '507', '0', '2', '0', 'Panamá', 'Panama', '1');
248 INSERT INTO static_countries VALUES ('165', '0', 'PE', 'PER', '604', '5', 'República del Perú', 'Republic of Peru', 'Lima', 'pe', 'PEN', '604', '51', '0', '2', '0', 'Perú', 'Peru', '1');
249 INSERT INTO static_countries VALUES ('166', '0', 'PF', 'PYF', '258', '61', 'Polynésie française', 'French Polynesia', 'Papeete', 'pf', 'XPF', '953', '689', '0', '1', '0', 'Polynésie française', 'French Polynesia', '0');
250 INSERT INTO static_countries VALUES ('167', '0', 'PG', 'PNG', '598', '54', 'Independent State of Papua New Guinea / Papua Niugini', 'Independent State of Papua New Guinea', 'Port Moresby', 'pg', 'PGK', '598', '675', '0', '1', '0', 'Papua New Guinea / Papua Niugini', 'Papua New Guinea', '1');
251 INSERT INTO static_countries VALUES ('168', '0', 'PH', 'PHL', '608', '35', 'Republika ng Pilipinas / Republic of the Philippines', 'Republic of the Philippines', 'Manila', 'ph', 'PHP', '608', '63', '0', '2', '0', 'Philippines', 'Philippines', '1');
252 INSERT INTO static_countries VALUES ('169', '0', 'PK', 'PAK', '586', '34', 'Islamic Republic of Pakistan / اسلامی جمہوریۂ پاکستان', 'Islamic Republic of Pakistan', 'Islamabad', 'pk', 'PKR', '586', '92', '0', '1', '0', 'پاکستان', 'Pakistan', '1');
253 INSERT INTO static_countries VALUES ('170', '0', 'PL', 'POL', '616', '151', 'Rzeczpospolita Polska', 'Republic of Poland', 'Warsaw', 'pl', 'PLN', '985', '48', '1', '1', '0', 'Polska', 'Poland', '1');
254 INSERT INTO static_countries VALUES ('171', '0', 'PM', 'SPM', '666', '21', 'Saint-Pierre-et-Miquelon', 'Saint Pierre and Miquelon', 'Saint-Pierre', 'pm', 'EUR', '978', '508', '0', '1', '0', 'Saint-Pierre-et-Miquelon', 'Saint Pierre and Miquelon', '0');
255 INSERT INTO static_countries VALUES ('172', '0', 'PN', 'PCN', '612', '61', 'Pitcairn Islands', 'Pitcairn Islands', 'Adamstown', 'pn', 'NZD', '554', '0', '0', '1', '0', 'Pitcairn Islands', 'Pitcairn Islands', '0');
256 INSERT INTO static_countries VALUES ('173', '0', 'PR', 'PRI', '630', '29', 'Estado Libre Asociado de Puerto Rico / Commonwealth of Puerto Rico', 'Commonwealth of Puerto Rico', 'San Juan', 'pr', 'USD', '840', '1787', '0', '2', '0', 'Puerto Rico', 'Puerto Rico', '0');
257 INSERT INTO static_countries VALUES ('174', '0', 'PT', 'PRT', '620', '39', 'República Portuguesa', 'Portuguese Republic', 'Lisbon', 'pt', 'EUR', '978', '351', '1', '1', '0', 'Portugal', 'Portugal', '1');
258 INSERT INTO static_countries VALUES ('175', '0', 'PW', 'PLW', '585', '57', 'Belu\'u era Belau / Republic of Palau', 'Republic of Palau', 'Koror', 'pw', 'USD', '840', '680', '0', '1', '0', 'Belau / Palau', 'Palau', '1');
259 INSERT INTO static_countries VALUES ('176', '0', 'PY', 'PRY', '600', '5', 'República del Paraguay / Tetä Paraguáype', 'Republic of Paraguay', 'Asunción', 'py', 'PYG', '600', '595', '0', '1', '0', 'Paraguay', 'Paraguay', '1');
260 INSERT INTO static_countries VALUES ('177', '0', 'QA', 'QAT', '634', '145', 'دولة قطر', 'State of Qatar', 'Doha', 'qa', 'QAR', '634', '974', '0', '1', '0', 'قطر', 'Qatar', '1');
261 INSERT INTO static_countries VALUES ('178', '0', 'RE', 'REU', '638', '14', 'Département de la Réunion', 'Department of Réunion', 'Saint-Denis', 're', 'EUR', '978', '262', '0', '1', '0', 'Réunion', 'Reunion', '0');
262 INSERT INTO static_countries VALUES ('179', '0', 'RO', 'ROU', '642', '151', 'România', 'Romania', 'Bucharest', 'ro', 'ROL', '642', '40', '0', '1', '0', 'România', 'Romania', '1');
263 INSERT INTO static_countries VALUES ('180', '0', 'RU', 'RUS', '643', '172', 'Российская Федерация', 'Russian Federation', 'Moscow', 'ru', 'RUB', '643', '7', '0', '1', '0', 'Росси́я', 'Russia', '1');
264 INSERT INTO static_countries VALUES ('181', '0', 'RW', 'RWA', '646', '14', 'Repubulika y\'u Rwanda / République Rwandaise', 'Republic of Rwanda', 'Kigali', 'rw', 'RWF', '646', '250', '0', '1', '0', 'Rwanda', 'Rwanda', '1');
265 INSERT INTO static_countries VALUES ('182', '0', 'SA', 'SAU', '682', '145', 'المملكة العربية السعودية', 'Kingdom of Saudi Arabia', 'Riyadh', 'sa', 'SAR', '682', '966', '0', '2', '0', 'السعودية', 'Saudi Arabia', '1');
266 INSERT INTO static_countries VALUES ('183', '0', 'SB', 'SLB', '90', '54', 'Solomon Islands', 'Solomon Islands', 'Honiara', 'sb', 'SBD', '90', '677', '0', '1', '0', 'Solomon Islands', 'Solomon Islands', '1');
267 INSERT INTO static_countries VALUES ('184', '0', 'SC', 'SYC', '690', '14', 'Repiblik Sesel / Republic of Seychelles / République des Seychelles', 'Republic of Seychelles', 'Victoria', 'sc', 'SCR', '690', '248', '0', '1', '0', 'Seychelles', 'Seychelles', '1');
268 INSERT INTO static_countries VALUES ('185', '0', 'SD', 'SDN', '736', '15', 'جمهورية السودان', 'Republic of the Sudan', 'Khartoum', 'sd', 'SDD', '736', '249', '0', '1', '0', 'السودان', 'Sudan', '1');
269 INSERT INTO static_countries VALUES ('186', '0', 'SE', 'SWE', '752', '154', 'Konungariket Sverige', 'Kingdom of Sweden', 'Stockholm', 'se', 'SEK', '752', '46', '1', '1', '0', 'Sverige', 'Sweden', '1');
270 INSERT INTO static_countries VALUES ('187', '0', 'SG', 'SGP', '702', '35', 'Republic of Singapore / 新加坡共和国 / Republik Singapura / சிங்கப்பூர் குடியரசு', 'Republic of Singapore', 'Singapore', 'sg', 'SGD', '702', '65', '0', '2', '0', 'Singapore', 'Singapore', '1');
271 INSERT INTO static_countries VALUES ('188', '0', 'SH', 'SHN', '654', '11', 'Saint Helena', 'Saint Helena', 'Jamestown', 'sh', 'SHP', '654', '290', '0', '1', '0', 'Saint Helena', 'Saint Helena', '0');
272 INSERT INTO static_countries VALUES ('189', '0', 'SI', 'SVN', '705', '39', 'Republika Slovenija', 'Republic of Slovenia', 'Ljubljana', 'si', 'SIT', '705', '386', '1', '1', '0', 'Slovenija', 'Slovenia', '1');
273 INSERT INTO static_countries VALUES ('190', '0', 'SJ', 'SJM', '744', '154', 'Svalbard', 'Svalbard', 'Longyearbyen', 'sj', 'NOK', '578', '47', '0', '1', '0', 'Svalbard', 'Svalbard', '0');
274 INSERT INTO static_countries VALUES ('191', '0', 'SK', 'SVK', '703', '151', 'Slovenská republika', 'Slovak Republic', 'Bratislava', 'sk', 'SKK', '703', '421', '1', '1', '0', 'Slovensko', 'Slovakia', '1');
275 INSERT INTO static_countries VALUES ('192', '0', 'SL', 'SLE', '694', '11', 'Republic of Sierra Leone', 'Republic of Sierra Leone', 'Freetown', 'sl', 'SLL', '694', '232', '0', '1', '0', 'Sierra Leone', 'Sierra Leone', '1');
276 INSERT INTO static_countries VALUES ('193', '0', 'SM', 'SMR', '674', '39', 'Serenissima Repubblica di San Marino', 'Most Serene Republic of San Marino', 'San Marino', 'sm', 'EUR', '978', '378', '0', '1', '0', 'San Marino', 'San Marino', '1');
277 INSERT INTO static_countries VALUES ('194', '0', 'SN', 'SEN', '686', '11', 'République de Sénégal', 'Republic of Senegal', 'Dakar', 'sn', 'XOF', '952', '221', '0', '1', '0', 'Sénégal', 'Senegal', '1');
278 INSERT INTO static_countries VALUES ('195', '0', 'SO', 'SOM', '706', '14', 'Soomaaliya', 'Somalia', 'Mogadishu', 'so', 'SOS', '706', '252', '0', '1', '0', 'Soomaaliya', 'Somalia', '1');
279 INSERT INTO static_countries VALUES ('196', '0', 'SR', 'SUR', '740', '5', 'Republiek Suriname', 'Republic of Surinam', 'Paramaribo', 'sr', 'SRD', '968', '597', '0', '1', '0', 'Suriname', 'Suriname', '1');
280 INSERT INTO static_countries VALUES ('197', '0', 'ST', 'STP', '678', '17', 'República Democrática de São Tomé e Príncipe', 'Democratic Republic of São Tomé e Príncipe', 'São Tomé', 'st', 'STD', '678', '239', '0', '1', '0', 'São Tomé e Príncipe', 'São Tomé e Príncipe', '1');
281 INSERT INTO static_countries VALUES ('198', '0', 'SV', 'SLV', '222', '13', 'República de El Salvador', 'Republic of El Salvador', 'San Salvador', 'sv', 'SVC', '222', '503', '0', '1', '0', 'El Salvador', 'El Salvador', '1');
282 INSERT INTO static_countries VALUES ('199', '0', 'SY', 'SYR', '760', '145', 'الجمهوريّة العربيّة السّوريّة', 'Syrian Arab Republic', 'Damascus', 'sy', 'SYP', '760', '963', '0', '1', '0', 'سوري', 'Syria', '1');
283 INSERT INTO static_countries VALUES ('200', '0', 'SZ', 'SWZ', '748', '18', 'Umboso weSwatini / Kingdom of Swaziland', 'Kingdom of Swaziland', 'Mbabane', 'sz', 'SZL', '748', '268', '0', '1', '0', 'weSwatini', 'Swaziland', '1');
284 INSERT INTO static_countries VALUES ('201', '0', 'TC', 'TCA', '796', '29', 'Turks and Caicos Islands', 'Turks and Caicos Islands', 'Cockburn Town', 'tc', 'USD', '840', '1649', '0', '1', '0', 'Turks and Caicos Islands', 'Turks and Caicos Islands', '0');
285 INSERT INTO static_countries VALUES ('202', '0', 'TD', 'TCD', '148', '17', 'جمهورية تشاد / République du Tchad', 'Republic of Chad', 'N\'Djamena', 'td', 'XAF', '950', '235', '0', '1', '0', 'تشاد / Tchad', 'Chad', '1');
286 INSERT INTO static_countries VALUES ('203', '0', 'TF', 'ATF', '260', '0', 'Terres australes françaises', 'French Southern Territories', '', 'tf', '', '0', '0', '0', '0', '0', 'Terres australes françaises', 'French Southern Territories', '0');
287 INSERT INTO static_countries VALUES ('204', '0', 'TG', 'TGO', '768', '11', 'République Togolaise', 'Republic of Togo', 'Lomé', 'tg', 'XOF', '952', '228', '0', '1', '0', 'Togo', 'Togo', '1');
288 INSERT INTO static_countries VALUES ('205', '0', 'TH', 'THA', '764', '35', 'ราชอาณาจักรไทย', 'Kingdom of Thailand', 'Bangkok', 'th', 'THB', '764', '66', '0', '2', '0', 'ไทย', 'Thailand', '1');
289 INSERT INTO static_countries VALUES ('206', '0', 'TJ', 'TJK', '762', '143', 'Ҷумҳурии Тоҷикистон', 'Republic of Tajikistan', 'Dushanbe', 'tj', 'TJS', '972', '7', '0', '1', '0', 'Тоҷикистон', 'Tajikistan', '1');
290 INSERT INTO static_countries VALUES ('207', '0', 'TK', 'TKL', '772', '61', 'Tokelau', 'Tokelau', 'Fakaofo', 'tk', 'NZD', '554', '0', '0', '1', '0', 'Tokelau', 'Tokelau', '0');
291 INSERT INTO static_countries VALUES ('208', '0', 'TM', 'TKM', '795', '143', 'Türkmenistan Jumhuriyäti', 'Republic of Turkmenistan', 'Ashgabat', 'tm', 'TMM', '795', '7', '0', '1', '0', 'Türkmenistan', 'Turkmenistan', '1');
292 INSERT INTO static_countries VALUES ('209', '0', 'TN', 'TUN', '788', '15', 'الجمهورية التونسية', 'Republic of Tunisia', 'Tunis', 'tn', 'TND', '788', '216', '0', '1', '0', 'التونسية', 'Tunisia', '1');
293 INSERT INTO static_countries VALUES ('210', '0', 'TO', 'TON', '776', '61', 'Pule\'anga Fakatu\'i \'o Tonga / Kingdom of Tonga', 'Kingdom of Tonga', 'Nuku\'alofa', 'to', 'TOP', '776', '676', '0', '1', '0', 'Tonga', 'Tonga', '1');
294 INSERT INTO static_countries VALUES ('211', '0', 'TL', 'TLS', '626', '35', 'Repúblika Demokrátika Timor Lorosa\'e / República Democrática de Timor-Leste', 'Democratic Republic of Timor-Leste', 'Dili', 'tp', 'TPE', '626', '670', '0', '1', '0', 'Timor Lorosa\'e', 'Timor-Leste', '1');
295 INSERT INTO static_countries VALUES ('212', '0', 'TR', 'TUR', '792', '145', 'Türkiye Cumhuriyeti', 'Republic of Turkey', 'Ankara', 'tr', 'TRY', '949', '90', '0', '1', '0', 'Türkiye', 'Turkey', '1');
296 INSERT INTO static_countries VALUES ('213', '0', 'TT', 'TTO', '780', '29', 'Republic of Trinidad and Tobago', 'Republic of Trinidad and Tobago', 'Port of Spain', 'tt', 'TTD', '780', '1868', '0', '1', '0', 'Trinidad and Tobago', 'Trinidad and Tobago', '1');
297 INSERT INTO static_countries VALUES ('214', '0', 'TV', 'TUV', '798', '61', 'Tuvalu', 'Tuvalu', 'Fongafale', 'tv', 'AUD', '36', '688', '0', '1', '0', 'Tuvalu', 'Tuvalu', '1');
298 INSERT INTO static_countries VALUES ('215', '0', 'TW', 'TWN', '158', '30', '中華民國', 'Republic of China', 'Taipei', 'tw', 'TWD', '901', '886', '0', '1', '0', '中華', 'Taiwan', '0');
299 INSERT INTO static_countries VALUES ('216', '0', 'TZ', 'TZA', '834', '14', 'Jamhuri ya Muungano wa Tanzania', 'United Republic of Tanzania', 'Dodoma', 'tz', 'TZS', '834', '255', '0', '1', '0', 'Tanzania', 'Tanzania', '1');
300 INSERT INTO static_countries VALUES ('217', '0', 'UA', 'UKR', '804', '172', 'Україна', 'Ukraine', 'Kiev', 'ua', 'UAH', '980', '380', '0', '1', '0', 'Україна', 'Ukraine', '1');
301 INSERT INTO static_countries VALUES ('218', '0', 'UG', 'UGA', '800', '14', 'Republic of Uganda', 'Republic of Uganda', 'Kampala', 'ug', 'UGX', '800', '256', '0', '1', '0', 'Uganda', 'Uganda', '1');
302 INSERT INTO static_countries VALUES ('219', '0', 'UM', 'UMI', '581', '0', 'United States Minor Outlying Islands', 'United States Minor Outlying Islands', '', 'um', 'USD', '840', '0', '0', '0', '0', 'United States Minor Outlying Islands', 'United States Minor Outlying Islands', '0');
303 INSERT INTO static_countries VALUES ('220', '0', 'US', 'USA', '840', '21', 'United States of America', 'United States of America', 'Washington DC', 'us', 'USD', '840', '1', '0', '3', '1', 'United States', 'United States', '1');
304 INSERT INTO static_countries VALUES ('221', '0', 'UY', 'URY', '858', '5', 'República Oriental del Uruguay', 'Eastern Republic of Uruguay', 'Montevideo', 'uy', 'UYU', '858', '598', '0', '1', '0', 'Uruguay', 'Uruguay', '1');
305 INSERT INTO static_countries VALUES ('222', '0', 'UZ', 'UZB', '860', '143', 'O‘zbekiston Respublikasi', 'Republic of Uzbekistan', 'Tashkent', 'uz', 'UZS', '860', '7', '0', '1', '0', 'O‘zbekiston', 'Uzbekistan', '1');
306 INSERT INTO static_countries VALUES ('223', '0', 'VA', 'VAT', '336', '39', 'Status Civitatis Vaticanae / Città del Vaticano', 'Vatican City', 'Vatican City', 'va', 'EUR', '978', '396', '0', '1', '0', 'Vaticano', 'Vatican City', '0');
307 INSERT INTO static_countries VALUES ('224', '0', 'VC', 'VCT', '670', '29', 'Saint Vincent and the Grenadines', 'Saint Vincent and the Grenadines', 'Kingstown', 'vc', 'XCD', '951', '1784', '0', '1', '0', 'Saint Vincent and the Grenadines', 'Saint Vincent and the Grenadines', '1');
308 INSERT INTO static_countries VALUES ('225', '0', 'VE', 'VEN', '862', '5', 'República Bolivariana de Venezuela', 'Bolivarian Republic of Venezuela', 'Caracas', 've', 'VEB', '862', '58', '0', '1', '0', 'Venezuela', 'Venezuela', '1');
309 INSERT INTO static_countries VALUES ('226', '0', 'VG', 'VGB', '92', '29', 'British Virgin Islands', 'British Virgin Islands', 'Road Town', 'vg', 'USD', '840', '1284', '0', '1', '0', 'British Virgin Islands', 'British Virgin Islands', '0');
310 INSERT INTO static_countries VALUES ('227', '0', 'VI', 'VIR', '850', '29', 'United States Virgin Islands', 'United States Virgin Islands', 'Charlotte Amalie', 'vi', 'USD', '840', '1340', '0', '1', '0', 'US Virgin Islands', 'US Virgin Islands', '0');
311 INSERT INTO static_countries VALUES ('228', '0', 'VN', 'VNM', '704', '35', 'Cộng Hòa Xã Hội Chủ Nghĩa Việt Nam', 'Socialist Republic of Vietnam', 'Hanoi', 'vn', 'VND', '704', '84', '0', '1', '0', 'Việt Nam', 'Vietnam', '1');
312 INSERT INTO static_countries VALUES ('229', '0', 'VU', 'VUT', '548', '54', 'Ripablik blong Vanuatu / Republic of Vanuatu / République du Vanuatu', 'Republic of Vanuatu', 'Port Vila', 'vu', 'VUV', '548', '678', '0', '1', '0', 'Vanuatu', 'Vanuatu', '1');
313 INSERT INTO static_countries VALUES ('230', '0', 'WF', 'WLF', '876', '61', 'Territoire de Wallis et Futuna', 'Territory of Wallis and Futuna Islands', 'Mata-Utu', 'wf', 'XPF', '953', '681', '0', '1', '0', 'Wallis and Futuna', 'Wallis and Futuna', '0');
314 INSERT INTO static_countries VALUES ('231', '0', 'WS', 'WSM', '882', '61', 'Malo Sa\'oloto Tuto\'atasi o Samoa / Independent State of Samoa', 'Independent State of Samoa', 'Apia', 'ws', 'WST', '882', '685', '0', '1', '0', 'Samoa', 'Samoa', '1');
315 INSERT INTO static_countries VALUES ('232', '0', 'YE', 'YEM', '887', '145', 'الجمهوريّة اليمنية', 'Republic of Yemen', 'San\'a', 'ye', 'YER', '886', '967', '0', '1', '0', 'اليمنية', 'Yemen', '1');
316 INSERT INTO static_countries VALUES ('233', '0', 'YT', 'MYT', '175', '14', 'Mayotte', 'Mayotte', 'Mamoudzou', 'yt', 'EUR', '978', '269', '0', '0', '0', 'Mayotte', 'Mayotte', '0');
317 INSERT INTO static_countries VALUES ('235', '0', 'ZA', 'ZAF', '710', '18', 'Republic of South Africa / Republiek van Suid-Afrika / Rephaboliki ya Afrika-Borwa', 'Republic of South Africa', 'Pretoria', 'za', 'ZAR', '710', '27', '0', '2', '0', 'Afrika-Borwa', 'South Africa', '1');
318 INSERT INTO static_countries VALUES ('236', '0', 'ZM', 'ZMB', '894', '14', 'Republic of Zambia', 'Republic of Zambia', 'Lusaka', 'zm', 'ZMK', '894', '260', '0', '1', '0', 'Zambia', 'Zambia', '1');
319 INSERT INTO static_countries VALUES ('237', '0', 'ZW', 'ZWE', '716', '14', 'Republic of Zimbabwe', 'Republic of Zimbabwe', 'Harare', 'zw', 'ZWD', '716', '263', '0', '1', '0', 'Zimbabwe', 'Zimbabwe', '1');
320 INSERT INTO static_countries VALUES ('238', '0', 'PS', 'PSE', '275', '145', 'Palestinian territories', 'Palestinian territories', '', 'ps', '0', '0', '0', '0', '0', '0', 'Palestine', 'Palestine', '0');
321 INSERT INTO static_countries VALUES ('239', '0', 'CS', 'CSG', '891', '39', 'Државна заједница Србија и Црна Гора', 'State Union of Serbia and Montenegro', 'Belgrade', 'cs', 'CSD', '891', '381', '0', '0', '0', 'Србија и Црна Гора', 'Serbia and Montenegro', '1');
322 INSERT INTO static_countries VALUES ('240', '0', 'AX', 'ALA', '248', '154', 'Åland Islands', 'Åland Islands', 'Mariehamn', 'fi', 'EUR', '978', '35818', '1', '0', '0', 'Åland Islands', 'Åland Islands', '0');
323 INSERT INTO static_countries VALUES ('241', '0', 'HM', 'HMD', '334', '53', 'Heard Island and McDonald Islands', 'Heard Island and McDonald Islands', '', '', 'AUD', '36', '0', '0', '0', '0', 'Heard Island and McDonald Islands', 'Heard Island and McDonald Islands', '0');
324
325
326 # TYPO3 Extension Manager dump 1.1
327 #
328 #--------------------------------------------------------
329
330
331 #
332 # Table structure for table "static_country_zones"
333 #
334 DROP TABLE IF EXISTS static_country_zones;
335 CREATE TABLE static_country_zones (
336 uid int(11) unsigned auto_increment,
337 pid int(11) unsigned default '0',
338 zn_country_iso_2 char(2) default '',
339 zn_country_iso_3 char(3) default '',
340 zn_country_iso_nr int(11) unsigned default '0',
341 zn_code varchar(45) default '',
342 zn_name_local varchar(128) default '',
343 zn_name_en varchar(50) default '',
344 PRIMARY KEY (uid),
345 UNIQUE uid (uid)
346 );
347
348
349 INSERT INTO static_country_zones VALUES ('1', '0', 'US', 'USA', '840', 'AL', 'Alabama', '');
350 INSERT INTO static_country_zones VALUES ('2', '0', 'US', 'USA', '840', 'AK', 'Alaska', '');
351 INSERT INTO static_country_zones VALUES ('4', '0', 'US', 'USA', '840', 'AZ', 'Arizona', '');
352 INSERT INTO static_country_zones VALUES ('5', '0', 'US', 'USA', '840', 'AR', 'Arkansas', '');
353 INSERT INTO static_country_zones VALUES ('12', '0', 'US', 'USA', '840', 'CA', 'California', '');
354 INSERT INTO static_country_zones VALUES ('13', '0', 'US', 'USA', '840', 'CO', 'Colorado', '');
355 INSERT INTO static_country_zones VALUES ('14', '0', 'US', 'USA', '840', 'CT', 'Connecticut', '');
356 INSERT INTO static_country_zones VALUES ('15', '0', 'US', 'USA', '840', 'DE', 'Delaware', '');
357 INSERT INTO static_country_zones VALUES ('16', '0', 'US', 'USA', '840', 'DC', 'District of Columbia', '');
358 INSERT INTO static_country_zones VALUES ('18', '0', 'US', 'USA', '840', 'FL', 'Florida', '');
359 INSERT INTO static_country_zones VALUES ('19', '0', 'US', 'USA', '840', 'GA', 'Georgia', '');
360 INSERT INTO static_country_zones VALUES ('20', '0', 'US', 'USA', '840', 'GU', 'Guam', '');
361 INSERT INTO static_country_zones VALUES ('21', '0', 'US', 'USA', '840', 'HI', 'Hawaii', '');
362 INSERT INTO static_country_zones VALUES ('22', '0', 'US', 'USA', '840', 'ID', 'Idaho', '');
363 INSERT INTO static_country_zones VALUES ('23', '0', 'US', 'USA', '840', 'IL', 'Illinois', '');
364 INSERT INTO static_country_zones VALUES ('24', '0', 'US', 'USA', '840', 'IN', 'Indiana', '');
365 INSERT INTO static_country_zones VALUES ('25', '0', 'US', 'USA', '840', 'IA', 'Iowa', '');
366 INSERT INTO static_country_zones VALUES ('26', '0', 'US', 'USA', '840', 'KS', 'Kansas', '');
367 INSERT INTO static_country_zones VALUES ('27', '0', 'US', 'USA', '840', 'KY', 'Kentucky', '');
368 INSERT INTO static_country_zones VALUES ('28', '0', 'US', 'USA', '840', 'LA', 'Louisiana', '');
369 INSERT INTO static_country_zones VALUES ('29', '0', 'US', 'USA', '840', 'ME', 'Maine', '');
370 INSERT INTO static_country_zones VALUES ('31', '0', 'US', 'USA', '840', 'MD', 'Maryland', '');
371 INSERT INTO static_country_zones VALUES ('32', '0', 'US', 'USA', '840', 'MA', 'Massachusetts', '');
372 INSERT INTO static_country_zones VALUES ('33', '0', 'US', 'USA', '840', 'MI', 'Michigan', '');
373 INSERT INTO static_country_zones VALUES ('34', '0', 'US', 'USA', '840', 'MN', 'Minnesota', '');
374 INSERT INTO static_country_zones VALUES ('35', '0', 'US', 'USA', '840', 'MS', 'Mississippi', '');
375 INSERT INTO static_country_zones VALUES ('36', '0', 'US', 'USA', '840', 'MO', 'Missouri', '');
376 INSERT INTO static_country_zones VALUES ('37', '0', 'US', 'USA', '840', 'MT', 'Montana', '');
377 INSERT INTO static_country_zones VALUES ('38', '0', 'US', 'USA', '840', 'NE', 'Nebraska', '');
378 INSERT INTO static_country_zones VALUES ('39', '0', 'US', 'USA', '840', 'NV', 'Nevada', '');
379 INSERT INTO static_country_zones VALUES ('40', '0', 'US', 'USA', '840', 'NH', 'New Hampshire', '');
380 INSERT INTO static_country_zones VALUES ('41', '0', 'US', 'USA', '840', 'NJ', 'New Jersey', '');
381 INSERT INTO static_country_zones VALUES ('42', '0', 'US', 'USA', '840', 'NM', 'New Mexico', '');
382 INSERT INTO static_country_zones VALUES ('43', '0', 'US', 'USA', '840', 'NY', 'New York', '');
383 INSERT INTO static_country_zones VALUES ('44', '0', 'US', 'USA', '840', 'NC', 'North Carolina', '');
384 INSERT INTO static_country_zones VALUES ('45', '0', 'US', 'USA', '840', 'ND', 'North Dakota', '');
385 INSERT INTO static_country_zones VALUES ('47', '0', 'US', 'USA', '840', 'OH', 'Ohio', '');
386 INSERT INTO static_country_zones VALUES ('48', '0', 'US', 'USA', '840', 'OK', 'Oklahoma', '');
387 INSERT INTO static_country_zones VALUES ('49', '0', 'US', 'USA', '840', 'OR', 'Oregon', '');
388 INSERT INTO static_country_zones VALUES ('51', '0', 'US', 'USA', '840', 'PA', 'Pennsylvania', '');
389 INSERT INTO static_country_zones VALUES ('52', '0', 'US', 'USA', '840', 'PR', 'Puerto Rico', '');
390 INSERT INTO static_country_zones VALUES ('53', '0', 'US', 'USA', '840', 'RI', 'Rhode Island', '');
391 INSERT INTO static_country_zones VALUES ('54', '0', 'US', 'USA', '840', 'SC', 'South Carolina', '');
392 INSERT INTO static_country_zones VALUES ('55', '0', 'US', 'USA', '840', 'SD', 'South Dakota', '');
393 INSERT INTO static_country_zones VALUES ('56', '0', 'US', 'USA', '840', 'TN', 'Tenessee', '');
394 INSERT INTO static_country_zones VALUES ('57', '0', 'US', 'USA', '840', 'TX', 'Texas', '');
395 INSERT INTO static_country_zones VALUES ('58', '0', 'US', 'USA', '840', 'UT', 'Utah', '');
396 INSERT INTO static_country_zones VALUES ('59', '0', 'US', 'USA', '840', 'VT', 'Vermont', '');
397 INSERT INTO static_country_zones VALUES ('61', '0', 'US', 'USA', '840', 'VA', 'Virginia', '');
398 INSERT INTO static_country_zones VALUES ('62', '0', 'US', 'USA', '840', 'WA', 'Washington', '');
399 INSERT INTO static_country_zones VALUES ('63', '0', 'US', 'USA', '840', 'WV', 'West Virginia', '');
400 INSERT INTO static_country_zones VALUES ('64', '0', 'US', 'USA', '840', 'WI', 'Wisconsin', '');
401 INSERT INTO static_country_zones VALUES ('65', '0', 'US', 'USA', '840', 'WY', 'Wyoming', '');
402 INSERT INTO static_country_zones VALUES ('66', '0', 'CA', 'CAN', '124', 'AB', 'Alberta', '');
403 INSERT INTO static_country_zones VALUES ('67', '0', 'CA', 'CAN', '124', 'BC', 'British Columbia', '');
404 INSERT INTO static_country_zones VALUES ('68', '0', 'CA', 'CAN', '124', 'MB', 'Manitoba', '');
405 INSERT INTO static_country_zones VALUES ('69', '0', 'CA', 'CAN', '124', 'NF', 'Newfoundland and Labrabor', '');
406 INSERT INTO static_country_zones VALUES ('70', '0', 'CA', 'CAN', '124', 'NB', 'New Brunswick', '');
407 INSERT INTO static_country_zones VALUES ('71', '0', 'CA', 'CAN', '124', 'NS', 'Nova Scotia', '');
408 INSERT INTO static_country_zones VALUES ('72', '0', 'CA', 'CAN', '124', 'NT', 'Northwest Territories', '');
409 INSERT INTO static_country_zones VALUES ('73', '0', 'CA', 'CAN', '124', 'NU', 'Nunavut', '');
410 INSERT INTO static_country_zones VALUES ('74', '0', 'CA', 'CAN', '124', 'ON', 'Ontario', '');
411 INSERT INTO static_country_zones VALUES ('75', '0', 'CA', 'CAN', '124', 'PE', 'Prince Edward Island', '');
412 INSERT INTO static_country_zones VALUES ('76', '0', 'CA', 'CAN', '124', 'QC', 'Québec', 'Quebec');
413 INSERT INTO static_country_zones VALUES ('77', '0', 'CA', 'CAN', '124', 'SK', 'Saskatchewan', '');
414 INSERT INTO static_country_zones VALUES ('78', '0', 'CA', 'CAN', '124', 'YT', 'Yukon Territory', '');
415 INSERT INTO static_country_zones VALUES ('79', '0', 'DE', 'DEU', '276', 'NDS', 'Niedersachsen', '');
416 INSERT INTO static_country_zones VALUES ('80', '0', 'DE', 'DEU', '276', 'BAW', 'Baden-Württemberg', '');
417 INSERT INTO static_country_zones VALUES ('81', '0', 'DE', 'DEU', '276', 'BAY', 'Bayern', '');
418 INSERT INTO static_country_zones VALUES ('82', '0', 'DE', 'DEU', '276', 'BER', 'Berlin', '');
419 INSERT INTO static_country_zones VALUES ('83', '0', 'DE', 'DEU', '276', 'BRG', 'Brandenburg', '');
420 INSERT INTO static_country_zones VALUES ('84', '0', 'DE', 'DEU', '276', 'BRE', 'Bremen', '');
421 INSERT INTO static_country_zones VALUES ('85', '0', 'DE', 'DEU', '276', 'HAM', 'Hamburg', '');
422 INSERT INTO static_country_zones VALUES ('86', '0', 'DE', 'DEU', '276', 'HES', 'Hessen', '');
423 INSERT INTO static_country_zones VALUES ('87', '0', 'DE', 'DEU', '276', 'MEC', 'Mecklenburg-Vorpommern', '');
424 INSERT INTO static_country_zones VALUES ('88', '0', 'DE', 'DEU', '276', 'NRW', 'Nordrhein-Westfalen', '');
425 INSERT INTO static_country_zones VALUES ('89', '0', 'DE', 'DEU', '276', 'RHE', 'Rheinland-Pfalz', '');
426 INSERT INTO static_country_zones VALUES ('90', '0', 'DE', 'DEU', '276', 'SAR', 'Saarland', '');
427 INSERT INTO static_country_zones VALUES ('91', '0', 'DE', 'DEU', '276', 'SAS', 'Sachsen', '');
428 INSERT INTO static_country_zones VALUES ('92', '0', 'DE', 'DEU', '276', 'SAC', 'Sachsen-Anhalt', '');
429 INSERT INTO static_country_zones VALUES ('93', '0', 'DE', 'DEU', '276', 'SCN', 'Schleswig-Holstein', '');
430 INSERT INTO static_country_zones VALUES ('94', '0', 'DE', 'DEU', '276', 'THE', 'Thüringen', '');
431 INSERT INTO static_country_zones VALUES ('95', '0', 'AT', 'AUT', '40', 'WI', 'Wien', '');
432 INSERT INTO static_country_zones VALUES ('96', '0', 'AT', 'AUT', '40', 'NO', 'Niederösterreich', '');
433 INSERT INTO static_country_zones VALUES ('97', '0', 'AT', 'AUT', '40', 'OO', 'Oberösterreich', '');
434 INSERT INTO static_country_zones VALUES ('98', '0', 'AT', 'AUT', '40', 'SB', 'Salzburg', '');
435 INSERT INTO static_country_zones VALUES ('99', '0', 'AT', 'AUT', '40', 'KN', 'Kärnten', '');
436 INSERT INTO static_country_zones VALUES ('100', '0', 'AT', 'AUT', '40', 'ST', 'Steiermark', '');
437 INSERT INTO static_country_zones VALUES ('101', '0', 'AT', 'AUT', '40', 'TI', 'Tirol', '');
438 INSERT INTO static_country_zones VALUES ('102', '0', 'AT', 'AUT', '40', 'BL', 'Burgenland', '');
439 INSERT INTO static_country_zones VALUES ('103', '0', 'AT', 'AUT', '40', 'VB', 'Vorarlberg', '');
440 INSERT INTO static_country_zones VALUES ('104', '0', 'CH', 'CHE', '756', 'AG', 'Aargau', '');
441 INSERT INTO static_country_zones VALUES ('105', '0', 'CH', 'CHE', '756', 'AI', 'Appenzell Innerrhoden', '');
442 INSERT INTO static_country_zones VALUES ('106', '0', 'CH', 'CHE', '756', 'AR', 'Appenzell Ausserrhoden', '');
443 INSERT INTO static_country_zones VALUES ('107', '0', 'CH', 'CHE', '756', 'BE', 'Bern', '');
444 INSERT INTO static_country_zones VALUES ('108', '0', 'CH', 'CHE', '756', 'BL', 'Basel-Landschaft', '');
445 INSERT INTO static_country_zones VALUES ('109', '0', 'CH', 'CHE', '756', 'BS', 'Basel-Stadt', '');
446 INSERT INTO static_country_zones VALUES ('110', '0', 'CH', 'CHE', '756', 'FR', 'Freiburg', '');
447 INSERT INTO static_country_zones VALUES ('111', '0', 'CH', 'CHE', '756', 'GE', 'Genf', '');
448 INSERT INTO static_country_zones VALUES ('112', '0', 'CH', 'CHE', '756', 'GL', 'Glarus', '');
449 INSERT INTO static_country_zones VALUES ('113', '0', 'CH', 'CHE', '756', 'GR', 'Graubünden', '');
450 INSERT INTO static_country_zones VALUES ('114', '0', 'CH', 'CHE', '756', 'JU', 'Jura', '');
451 INSERT INTO static_country_zones VALUES ('115', '0', 'CH', 'CHE', '756', 'LU', 'Luzern', '');
452 INSERT INTO static_country_zones VALUES ('116', '0', 'CH', 'CHE', '756', 'NE', 'Neuenburg', '');
453 INSERT INTO static_country_zones VALUES ('117', '0', 'CH', 'CHE', '756', 'NW', 'Nidwalden', '');
454 INSERT INTO static_country_zones VALUES ('118', '0', 'CH', 'CHE', '756', 'OW', 'Obwalden', '');
455 INSERT INTO static_country_zones VALUES ('119', '0', 'CH', 'CHE', '756', 'SG', 'St. Gallen', '');
456 INSERT INTO static_country_zones VALUES ('120', '0', 'CH', 'CHE', '756', 'SH', 'Schaffhausen', '');
457 INSERT INTO static_country_zones VALUES ('121', '0', 'CH', 'CHE', '756', 'SO', 'Solothurn', '');
458 INSERT INTO static_country_zones VALUES ('122', '0', 'CH', 'CHE', '756', 'SZ', 'Schwyz', '');
459 INSERT INTO static_country_zones VALUES ('123', '0', 'CH', 'CHE', '756', 'TG', 'Thurgau', '');
460 INSERT INTO static_country_zones VALUES ('124', '0', 'CH', 'CHE', '756', 'TI', 'Tessin', '');
461 INSERT INTO static_country_zones VALUES ('125', '0', 'CH', 'CHE', '756', 'UR', 'Uri', '');
462 INSERT INTO static_country_zones VALUES ('126', '0', 'CH', 'CHE', '756', 'VD', 'Waadt', '');
463 INSERT INTO static_country_zones VALUES ('127', '0', 'CH', 'CHE', '756', 'VS', 'Wallis', '');
464 INSERT INTO static_country_zones VALUES ('128', '0', 'CH', 'CHE', '756', 'ZG', 'Zug', '');
465 INSERT INTO static_country_zones VALUES ('129', '0', 'CH', 'CHE', '756', 'ZH', 'Zürich', '');
466 INSERT INTO static_country_zones VALUES ('130', '0', 'ES', 'ESP', '724', 'Alava', 'Alava', '');
467 INSERT INTO static_country_zones VALUES ('131', '0', 'ES', 'ESP', '724', 'Malaga', 'Malaga', '');
468 INSERT INTO static_country_zones VALUES ('132', '0', 'ES', 'ESP', '724', 'Segovia', 'Segovia', '');
469 INSERT INTO static_country_zones VALUES ('133', '0', 'ES', 'ESP', '724', 'Granada', 'Granada', '');
470 INSERT INTO static_country_zones VALUES ('134', '0', 'ES', 'ESP', '724', 'Jaen', 'Jaen', '');
471 INSERT INTO static_country_zones VALUES ('135', '0', 'ES', 'ESP', '724', 'Sevilla', 'Sevilla', '');
472 INSERT INTO static_country_zones VALUES ('136', '0', 'ES', 'ESP', '724', 'Barcelona', 'Barcelona', '');
473 INSERT INTO static_country_zones VALUES ('137', '0', 'ES', 'ESP', '724', 'Valencia', 'Valencia', '');
474 INSERT INTO static_country_zones VALUES ('138', '0', 'ES', 'ESP', '724', 'Alicante', 'Alicante', '');
475 INSERT INTO static_country_zones VALUES ('139', '0', 'ES', 'ESP', '724', 'Almeria', 'Almeria', '');
476 INSERT INTO static_country_zones VALUES ('140', '0', 'ES', 'ESP', '724', 'Asturias', 'Asturias', '');
477 INSERT INTO static_country_zones VALUES ('141', '0', 'ES', 'ESP', '724', 'Avila', 'Avila', '');
478 INSERT INTO static_country_zones VALUES ('142', '0', 'ES', 'ESP', '724', 'Badajoz', 'Badajoz', '');
479 INSERT INTO static_country_zones VALUES ('143', '0', 'ES', 'ESP', '724', 'Burgos', 'Burgos', '');
480 INSERT INTO static_country_zones VALUES ('144', '0', 'ES', 'ESP', '724', 'Caceres', 'Caceres', '');
481 INSERT INTO static_country_zones VALUES ('145', '0', 'ES', 'ESP', '724', 'Cadiz', 'Cadiz', '');
482 INSERT INTO static_country_zones VALUES ('146', '0', 'ES', 'ESP', '724', 'Cantabria', 'Cantabria', '');
483 INSERT INTO static_country_zones VALUES ('147', '0', 'ES', 'ESP', '724', 'Castellon', 'Castellon', '');
484 INSERT INTO static_country_zones VALUES ('148', '0', 'ES', 'ESP', '724', 'Ceuta', 'Ceuta', '');
485 INSERT INTO static_country_zones VALUES ('149', '0', 'ES', 'ESP', '724', 'Ciudad Real', 'Ciudad Real', '');
486 INSERT INTO static_country_zones VALUES ('150', '0', 'ES', 'ESP', '724', 'Cordoba', 'Cordoba', '');
487 INSERT INTO static_country_zones VALUES ('151', '0', 'ES', 'ESP', '724', 'Cuenca', 'Cuenca', '');
488 INSERT INTO static_country_zones VALUES ('152', '0', 'ES', 'ESP', '724', 'Girona', 'Girona', '');
489 INSERT INTO static_country_zones VALUES ('153', '0', 'ES', 'ESP', '724', 'Las Palmas', 'Las Palmas', '');
490 INSERT INTO static_country_zones VALUES ('154', '0', 'ES', 'ESP', '724', 'Guadalajara', 'Guadalajara', '');
491 INSERT INTO static_country_zones VALUES ('155', '0', 'ES', 'ESP', '724', 'Guipuzcoa', 'Guipuzcoa', '');
492 INSERT INTO static_country_zones VALUES ('156', '0', 'ES', 'ESP', '724', 'Huelva', 'Huelva', '');
493 INSERT INTO static_country_zones VALUES ('157', '0', 'ES', 'ESP', '724', 'Huesca', 'Huesca', '');
494 INSERT INTO static_country_zones VALUES ('158', '0', 'ES', 'ESP', '724', 'A Coruña', 'A Coruña', '');
495 INSERT INTO static_country_zones VALUES ('159', '0', 'ES', 'ESP', '724', 'La Rioja', 'La Rioja', '');
496 INSERT INTO static_country_zones VALUES ('160', '0', 'ES', 'ESP', '724', 'Leon', 'Leon', '');
497 INSERT INTO static_country_zones VALUES ('161', '0', 'ES', 'ESP', '724', 'Lugo', 'Lugo', '');
498 INSERT INTO static_country_zones VALUES ('162', '0', 'ES', 'ESP', '724', 'Lleida', 'Lleida', '');
499 INSERT INTO static_country_zones VALUES ('163', '0', 'ES', 'ESP', '724', 'Madrid', 'Madrid', '');
500 INSERT INTO static_country_zones VALUES ('164', '0', 'ES', 'ESP', '724', 'Baleares', 'Baleares', '');
501 INSERT INTO static_country_zones VALUES ('166', '0', 'ES', 'ESP', '724', 'Murcia', 'Murcia', '');
502 INSERT INTO static_country_zones VALUES ('167', '0', 'ES', 'ESP', '724', 'Navarra', 'Navarra', '');
503 INSERT INTO static_country_zones VALUES ('168', '0', 'ES', 'ESP', '724', 'Ourense', 'Ourense', '');
504 INSERT INTO static_country_zones VALUES ('169', '0', 'ES', 'ESP', '724', 'Palencia', 'Palencia', '');
505 INSERT INTO static_country_zones VALUES ('170', '0', 'ES', 'ESP', '724', 'Pontevedra', 'Pontevedra', '');
506 INSERT INTO static_country_zones VALUES ('171', '0', 'ES', 'ESP', '724', 'Salamanca', 'Salamanca', '');
507 INSERT INTO static_country_zones VALUES ('172', '0', 'ES', 'ESP', '724', 'Soria', 'Soria', '');
508 INSERT INTO static_country_zones VALUES ('173', '0', 'ES', 'ESP', '724', 'Tarragona', 'Tarragona', '');
509 INSERT INTO static_country_zones VALUES ('174', '0', 'ES', 'ESP', '724', 'Tenerife', 'Tenerife', '');
510 INSERT INTO static_country_zones VALUES ('175', '0', 'ES', 'ESP', '724', 'Teruel', 'Teruel', '');
511 INSERT INTO static_country_zones VALUES ('176', '0', 'ES', 'ESP', '724', 'Toledo', 'Toledo', '');
512 INSERT INTO static_country_zones VALUES ('177', '0', 'ES', 'ESP', '724', 'Valladolid', 'Valladolid', '');
513 INSERT INTO static_country_zones VALUES ('178', '0', 'ES', 'ESP', '724', 'Vizcaya', 'Vizcaya', '');
514 INSERT INTO static_country_zones VALUES ('179', '0', 'ES', 'ESP', '724', 'Zamora', 'Zamora', '');
515 INSERT INTO static_country_zones VALUES ('180', '0', 'ES', 'ESP', '724', 'Zaragoza', 'Zaragoza', '');
516 INSERT INTO static_country_zones VALUES ('181', '0', 'ES', 'ESP', '724', 'Melilla', 'Melilla', '');
517 INSERT INTO static_country_zones VALUES ('182', '0', 'MX', 'MEX', '484', 'AGS', 'Aguascalientes', '');
518 INSERT INTO static_country_zones VALUES ('183', '0', 'MX', 'MEX', '484', 'BCS', 'Baja California Sur', '');
519 INSERT INTO static_country_zones VALUES ('184', '0', 'MX', 'MEX', '484', 'BC', 'Baja California Norte', '');
520 INSERT INTO static_country_zones VALUES ('185', '0', 'MX', 'MEX', '484', 'CAM', 'Campeche', '');
521 INSERT INTO static_country_zones VALUES ('186', '0', 'MX', 'MEX', '484', 'CHIS', 'Chiapas', '');
522 INSERT INTO static_country_zones VALUES ('187', '0', 'MX', 'MEX', '484', 'CHIH', 'Chihuahua', '');
523 INSERT INTO static_country_zones VALUES ('188', '0', 'MX', 'MEX', '484', 'COAH', 'Coahuila', '');
524 INSERT INTO static_country_zones VALUES ('189', '0', 'MX', 'MEX', '484', 'COL', 'Colima', '');
525 INSERT INTO static_country_zones VALUES ('190', '0', 'MX', 'MEX', '484', 'DIF', 'Distrito Federal', '');
526 INSERT INTO static_country_zones VALUES ('191', '0', 'MX', 'MEX', '484', 'DGO', 'Durango', '');
527 INSERT INTO static_country_zones VALUES ('192', '0', 'MX', 'MEX', '484', 'GTO', 'Guanajuato', '');
528 INSERT INTO static_country_zones VALUES ('193', '0', 'MX', 'MEX', '484', 'GRO', 'Guerrero', '');
529 INSERT INTO static_country_zones VALUES ('194', '0', 'MX', 'MEX', '484', 'HGO', 'Hidalgo', '');
530 INSERT INTO static_country_zones VALUES ('195', '0', 'MX', 'MEX', '484', 'JAL', 'Jalisco', '');
531 INSERT INTO static_country_zones VALUES ('196', '0', 'MX', 'MEX', '484', 'MEX', 'México', '');
532 INSERT INTO static_country_zones VALUES ('197', '0', 'MX', 'MEX', '484', 'MICH', 'Michoacán', '');
533 INSERT INTO static_country_zones VALUES ('198', '0', 'MX', 'MEX', '484', 'MOR', 'Morelos', '');
534 INSERT INTO static_country_zones VALUES ('199', '0', 'MX', 'MEX', '484', 'NAY', 'Nayarit', '');
535 INSERT INTO static_country_zones VALUES ('200', '0', 'MX', 'MEX', '484', 'NL', 'Nuevo León', '');
536 INSERT INTO static_country_zones VALUES ('201', '0', 'MX', 'MEX', '484', 'OAX', 'Oaxaca', '');
537 INSERT INTO static_country_zones VALUES ('202', '0', 'MX', 'MEX', '484', 'PUE', 'Puebla', '');
538 INSERT INTO static_country_zones VALUES ('203', '0', 'MX', 'MEX', '484', 'QRO', 'Querétaro', '');
539 INSERT INTO static_country_zones VALUES ('204', '0', 'MX', 'MEX', '484', 'QROO', 'Quintana Roo', '');
540 INSERT INTO static_country_zones VALUES ('205', '0', 'MX', 'MEX', '484', 'SLP', 'San Luis Potosí', '');
541 INSERT INTO static_country_zones VALUES ('206', '0', 'MX', 'MEX', '484', 'SIN', 'Sinaloa', '');
542 INSERT INTO static_country_zones VALUES ('207', '0', 'MX', 'MEX', '484', 'SON', 'Sonora', '');
543 INSERT INTO static_country_zones VALUES ('208', '0', 'MX', 'MEX', '484', 'TAB', 'Tabasco', '');
544 INSERT INTO static_country_zones VALUES ('209', '0', 'MX', 'MEX', '484', 'TAMPS', 'Tamaulipas', '');
545 INSERT INTO static_country_zones VALUES ('210', '0', 'MX', 'MEX', '484', 'TLAX', 'Tlaxcala', '');
546 INSERT INTO static_country_zones VALUES ('211', '0', 'MX', 'MEX', '484', 'VER', 'Veracruz', '');
547 INSERT INTO static_country_zones VALUES ('212', '0', 'MX', 'MEX', '484', 'YUC', 'Yucatán', '');
548 INSERT INTO static_country_zones VALUES ('213', '0', 'MX', 'MEX', '484', 'ZAC', 'Zacatecas', '');
549 INSERT INTO static_country_zones VALUES ('214', '0', 'AU', 'AUS', '36', 'ACT', 'Australian Capital Territory', '');
550 INSERT INTO static_country_zones VALUES ('215', '0', 'AU', 'AUS', '36', 'NSW', 'New South Wales', '');
551 INSERT INTO static_country_zones VALUES ('216', '0', 'AU', 'AUS', '36', 'NT', 'Northern Territory', '');
552 INSERT INTO static_country_zones VALUES ('217', '0', 'AU', 'AUS', '36', 'QLD', 'Queensland', '');
553 INSERT INTO static_country_zones VALUES ('218', '0', 'AU', 'AUS', '36', 'SA', 'South Australia', '');
554 INSERT INTO static_country_zones VALUES ('219', '0', 'AU', 'AUS', '36', 'TAS', 'Tasmania', '');
555 INSERT INTO static_country_zones VALUES ('220', '0', 'AU', 'AUS', '36', 'VIC', 'Victoria', '');
556 INSERT INTO static_country_zones VALUES ('221', '0', 'AU', 'AUS', '36', 'WA', 'Western Australia', '');
557 INSERT INTO static_country_zones VALUES ('222', '0', 'IT', 'ITA', '380', 'AG', 'Agrigento', '');
558 INSERT INTO static_country_zones VALUES ('223', '0', 'IT', 'ITA', '380', 'AL', 'Alessandria', '');
559 INSERT INTO static_country_zones VALUES ('224', '0', 'IT', 'ITA', '380', 'AN', 'Ancona', '');
560 INSERT INTO static_country_zones VALUES ('225', '0', 'IT', 'ITA', '380', 'AO', 'Aosta', '');
561 INSERT INTO static_country_zones VALUES ('226', '0', 'IT', 'ITA', '380', 'AP', 'Ascoli Piceno', '');
562 INSERT INTO static_country_zones VALUES ('227', '0', 'IT', 'ITA', '380', 'AQ', 'L\'Aquila', '');
563 INSERT INTO static_country_zones VALUES ('228', '0', 'IT', 'ITA', '380', 'AR', 'Arezzo', '');
564 INSERT INTO static_country_zones VALUES ('229', '0', 'IT', 'ITA', '380', 'AT', 'Asti', '');
565 INSERT INTO static_country_zones VALUES ('230', '0', 'IT', 'ITA', '380', 'AV', 'Avellino', '');
566 INSERT INTO static_country_zones VALUES ('231', '0', 'IT', 'ITA', '380', 'BA', 'Bari', '');
567 INSERT INTO static_country_zones VALUES ('232', '0', 'IT', 'ITA', '380', 'BG', 'Bergamo', '');
568 INSERT INTO static_country_zones VALUES ('233', '0', 'IT', 'ITA', '380', 'BI', 'Biella', '');
569 INSERT INTO static_country_zones VALUES ('234', '0', 'IT', 'ITA', '380', 'BL', 'Belluno', '');
570 INSERT INTO static_country_zones VALUES ('235', '0', 'IT', 'ITA', '380', 'BN', 'Benevento', '');
571 INSERT INTO static_country_zones VALUES ('236', '0', 'IT', 'ITA', '380', 'BO', 'Bologna', '');
572 INSERT INTO static_country_zones VALUES ('237', '0', 'IT', 'ITA', '380', 'BR', 'Brindisi', '');
573 INSERT INTO static_country_zones VALUES ('238', '0', 'IT', 'ITA', '380', 'BS', 'Brescia', '');
574 INSERT INTO static_country_zones VALUES ('239', '0', 'IT', 'ITA', '380', 'BZ', 'Bolzano', '');
575 INSERT INTO static_country_zones VALUES ('240', '0', 'IT', 'ITA', '380', 'CA', 'Cagliari', '');
576 INSERT INTO static_country_zones VALUES ('241', '0', 'IT', 'ITA', '380', 'CB', 'Campobasso', '');
577 INSERT INTO static_country_zones VALUES ('242', '0', 'IT', 'ITA', '380', 'CE', 'Caserta', '');
578 INSERT INTO static_country_zones VALUES ('243', '0', 'IT', 'ITA', '380', 'CH', 'Chieti', '');
579 INSERT INTO static_country_zones VALUES ('244', '0', 'IT', 'ITA', '380', 'CL', 'Caltanissetta', '');
580 INSERT INTO static_country_zones VALUES ('245', '0', 'IT', 'ITA', '380', 'CN', 'Cuneo', '');
581 INSERT INTO static_country_zones VALUES ('246', '0', 'IT', 'ITA', '380', 'CO', 'Como', '');
582 INSERT INTO static_country_zones VALUES ('247', '0', 'IT', 'ITA', '380', 'CR', 'Cremona', '');
583 INSERT INTO static_country_zones VALUES ('248', '0', 'IT', 'ITA', '380', 'CS', 'Cosenza', '');
584 INSERT INTO static_country_zones VALUES ('249', '0', 'IT', 'ITA', '380', 'CT', 'Catania', '');
585 INSERT INTO static_country_zones VALUES ('250', '0', 'IT', 'ITA', '380', 'CZ', 'Catanzaro', '');
586 INSERT INTO static_country_zones VALUES ('251', '0', 'IT', 'ITA', '380', 'EN', 'Enna', '');
587 INSERT INTO static_country_zones VALUES ('252', '0', 'IT', 'ITA', '380', 'FE', 'Ferrara', '');
588 INSERT INTO static_country_zones VALUES ('253', '0', 'IT', 'ITA', '380', 'FG', 'Foggia', '');
589 INSERT INTO static_country_zones VALUES ('254', '0', 'IT', 'ITA', '380', 'FI', 'Firenze', '');
590 INSERT INTO static_country_zones VALUES ('255', '0', 'IT', 'ITA', '380', 'FO', 'Forli', '');
591 INSERT INTO static_country_zones VALUES ('256', '0', 'IT', 'ITA', '380', 'FR', 'Frosinone', '');
592 INSERT INTO static_country_zones VALUES ('257', '0', 'IT', 'ITA', '380', 'GE', 'Genova', '');
593 INSERT INTO static_country_zones VALUES ('258', '0', 'IT', 'ITA', '380', 'GO', 'Gorizia', '');
594 INSERT INTO static_country_zones VALUES ('259', '0', 'IT', 'ITA', '380', 'GR', 'Grosseto', '');
595 INSERT INTO static_country_zones VALUES ('260', '0', 'IT', 'ITA', '380', 'IM', 'Imperia', '');
596 INSERT INTO static_country_zones VALUES ('261', '0', 'IT', 'ITA', '380', 'IS', 'Isernia', '');
597 INSERT INTO static_country_zones VALUES ('262', '0', 'IT', 'ITA', '380', 'KR', 'Crotone', '');
598 INSERT INTO static_country_zones VALUES ('263', '0', 'IT', 'ITA', '380', 'LC', 'Lecco', '');
599 INSERT INTO static_country_zones VALUES ('264', '0', 'IT', 'ITA', '380', 'LE', 'Lecce', '');
600 INSERT INTO static_country_zones VALUES ('265', '0', 'IT', 'ITA', '380', 'LI', 'Livorno', '');
601 INSERT INTO static_country_zones VALUES ('266', '0', 'IT', 'ITA', '380', 'LO', 'Lodi', '');
602 INSERT INTO static_country_zones VALUES ('267', '0', 'IT', 'ITA', '380', 'LT', 'Latina', '');
603 INSERT INTO static_country_zones VALUES ('268', '0', 'IT', 'ITA', '380', 'LU', 'Lucca', '');
604 INSERT INTO static_country_zones VALUES ('269', '0', 'IT', 'ITA', '380', 'MC', 'Macerata', '');
605 INSERT INTO static_country_zones VALUES ('270', '0', 'IT', 'ITA', '380', 'ME', 'Messina', '');
606 INSERT INTO static_country_zones VALUES ('271', '0', 'IT', 'ITA', '380', 'MI', 'Milano', '');
607 INSERT INTO static_country_zones VALUES ('272', '0', 'IT', 'ITA', '380', 'MN', 'Mantova', '');
608 INSERT INTO static_country_zones VALUES ('273', '0', 'IT', 'ITA', '380', 'MO', 'Modena', '');
609 INSERT INTO static_country_zones VALUES ('274', '0', 'IT', 'ITA', '380', 'MS', 'Massa Carrara', '');
610 INSERT INTO static_country_zones VALUES ('275', '0', 'IT', 'ITA', '380', 'MT', 'Matera', '');
611 INSERT INTO static_country_zones VALUES ('276', '0', 'IT', 'ITA', '380', 'NA', 'Napoli', '');
612 INSERT INTO static_country_zones VALUES ('277', '0', 'IT', 'ITA', '380', 'NO', 'Novara', '');
613 INSERT INTO static_country_zones VALUES ('278', '0', 'IT', 'ITA', '380', 'NU', 'Nuoro', '');
614 INSERT INTO static_country_zones VALUES ('279', '0', 'IT', 'ITA', '380', 'OR', 'Oristano', '');
615 INSERT INTO static_country_zones VALUES ('280', '0', 'IT', 'ITA', '380', 'PA', 'Palermo', '');
616 INSERT INTO static_country_zones VALUES ('281', '0', 'IT', 'ITA', '380', 'PC', 'Piacenza', '');
617 INSERT INTO static_country_zones VALUES ('282', '0', 'IT', 'ITA', '380', 'PD', 'Padova', '');
618 INSERT INTO static_country_zones VALUES ('283', '0', 'IT', 'ITA', '380', 'PE', 'Pescara', '');
619 INSERT INTO static_country_zones VALUES ('284', '0', 'IT', 'ITA', '380', 'PG', 'Perugia', '');
620 INSERT INTO static_country_zones VALUES ('285', '0', 'IT', 'ITA', '380', 'PI', 'Pisa', '');
621 INSERT INTO static_country_zones VALUES ('286', '0', 'IT', 'ITA', '380', 'PN', 'Pordenone', '');
622 INSERT INTO static_country_zones VALUES ('287', '0', 'IT', 'ITA', '380', 'PR', 'Parma', '');
623 INSERT INTO static_country_zones VALUES ('288', '0', 'IT', 'ITA', '380', 'PS', 'Pesora', '');
624 INSERT INTO static_country_zones VALUES ('289', '0', 'IT', 'ITA', '380', 'PT', 'Pistoia', '');
625 INSERT INTO static_country_zones VALUES ('290', '0', 'IT', 'ITA', '380', 'PV', 'Pavia', '');
626 INSERT INTO static_country_zones VALUES ('291', '0', 'IT', 'ITA', '380', 'PO', 'Prato', '');
627 INSERT INTO static_country_zones VALUES ('292', '0', 'IT', 'ITA', '380', 'PZ', 'Potenza', '');
628 INSERT INTO static_country_zones VALUES ('293', '0', 'IT', 'ITA', '380', 'RA', 'Ravenna', '');
629 INSERT INTO static_country_zones VALUES ('294', '0', 'IT', 'ITA', '380', 'RC', 'Reggio Calabria', '');
630 INSERT INTO static_country_zones VALUES ('295', '0', 'IT', 'ITA', '380', 'RE', 'Reggio Emilia', '');
631 INSERT INTO static_country_zones VALUES ('296', '0', 'IT', 'ITA', '380', 'RG', 'Ragusa', '');
632 INSERT INTO static_country_zones VALUES ('297', '0', 'IT', 'ITA', '380', 'RI', 'Rieti', '');
633 INSERT INTO static_country_zones VALUES ('298', '0', 'IT', 'ITA', '380', 'RM', 'Roma', '');
634 INSERT INTO static_country_zones VALUES ('299', '0', 'IT', 'ITA', '380', 'RN', 'Rimini', '');
635 INSERT INTO static_country_zones VALUES ('300', '0', 'IT', 'ITA', '380', 'RO', 'Rovigo', '');
636 INSERT INTO static_country_zones VALUES ('301', '0', 'IT', 'ITA', '380', 'SA', 'Salerno', '');
637 INSERT INTO static_country_zones VALUES ('302', '0', 'IT', 'ITA', '380', 'SI', 'Siena', '');
638 INSERT INTO static_country_zones VALUES ('303', '0', 'IT', 'ITA', '380', 'SO', 'Sondrio', '');
639 INSERT INTO static_country_zones VALUES ('304', '0', 'IT', 'ITA', '380', 'SP', 'La Spezia', '');
640 INSERT INTO static_country_zones VALUES ('305', '0', 'IT', 'ITA', '380', 'SR', 'Siracusa', '');
641 INSERT INTO static_country_zones VALUES ('306', '0', 'IT', 'ITA', '380', 'SS', 'Sassari', '');
642 INSERT INTO static_country_zones VALUES ('307', '0', 'IT', 'ITA', '380', 'SV', 'Savona', '');
643 INSERT INTO static_country_zones VALUES ('308', '0', 'IT', 'ITA', '380', 'TA', 'Taranto', '');
644 INSERT INTO static_country_zones VALUES ('309', '0', 'IT', 'ITA', '380', 'TE', 'Teramo', '');
645 INSERT INTO static_country_zones VALUES ('310', '0', 'IT', 'ITA', '380', 'TN', 'Trento', '');
646 INSERT INTO static_country_zones VALUES ('311', '0', 'IT', 'ITA', '380', 'TO', 'Torino', '');
647 INSERT INTO static_country_zones VALUES ('312', '0', 'IT', 'ITA', '380', 'TP', 'Trapani', '');
648 INSERT INTO static_country_zones VALUES ('313', '0', 'IT', 'ITA', '380', 'TR', 'Terni', '');
649 INSERT INTO static_country_zones VALUES ('314', '0', 'IT', 'ITA', '380', 'TS', 'Trieste', '');
650 INSERT INTO static_country_zones VALUES ('315', '0', 'IT', 'ITA', '380', 'TV', 'Treviso', '');
651 INSERT INTO static_country_zones VALUES ('316', '0', 'IT', 'ITA', '380', 'UD', 'Udine', '');
652 INSERT INTO static_country_zones VALUES ('317', '0', 'IT', 'ITA', '380', 'VA', 'Varese', '');
653 INSERT INTO static_country_zones VALUES ('318', '0', 'IT', 'ITA', '380', 'VC', 'Vercelli', '');
654 INSERT INTO static_country_zones VALUES ('319', '0', 'IT', 'ITA', '380', 'VE', 'Venezia', '');
655 INSERT INTO static_country_zones VALUES ('320', '0', 'IT', 'ITA', '380', 'VI', 'Vicenza', '');
656 INSERT INTO static_country_zones VALUES ('321', '0', 'IT', 'ITA', '380', 'VP', 'Verbania', '');
657 INSERT INTO static_country_zones VALUES ('322', '0', 'IT', 'ITA', '380', 'VR', 'Verona', '');
658 INSERT INTO static_country_zones VALUES ('323', '0', 'IT', 'ITA', '380', 'VT', 'Viterbo', '');
659 INSERT INTO static_country_zones VALUES ('324', '0', 'IT', 'ITA', '380', 'VV', 'Vibo Valentia', '');
660 INSERT INTO static_country_zones VALUES ('325', '0', 'GB', 'GBR', '826', 'ALD', 'Alderney', '');
661 INSERT INTO static_country_zones VALUES ('326', '0', 'GB', 'GBR', '826', 'ARM', 'Armagh', '');
662 INSERT INTO static_country_zones VALUES ('327', '0', 'GB', 'GBR', '826', 'ATM', 'Antrim', '');
663 INSERT INTO static_country_zones VALUES ('328', '0', 'GB', 'GBR', '826', 'BDS', 'Borders', '');
664 INSERT INTO static_country_zones VALUES ('329', '0', 'GB', 'GBR', '826', 'BFD', 'Bedfordshire', '');
665 INSERT INTO static_country_zones VALUES ('330', '0', 'GB', 'GBR', '826', 'BIR', 'Birmingham', '');
666 INSERT INTO static_country_zones VALUES ('331', '0', 'GB', 'GBR', '826', 'BLG', 'Blaenau Gwent', '');
667 INSERT INTO static_country_zones VALUES ('332', '0', 'GB', 'GBR', '826', 'BRI', 'Bridgend', '');
668 INSERT INTO static_country_zones VALUES ('333', '0', 'GB', 'GBR', '826', 'BRK', 'Berkshire', '');
669 INSERT INTO static_country_zones VALUES ('334', '0', 'GB', 'GBR', '826', 'BRS', 'Bristol', '');
670 INSERT INTO static_country_zones VALUES ('335', '0', 'GB', 'GBR', '826', 'BUX', 'Buckinghamshire', '');
671 INSERT INTO static_country_zones VALUES ('336', '0', 'GB', 'GBR', '826', 'CAP', 'Caerphilly', '');
672 INSERT INTO static_country_zones VALUES ('337', '0', 'GB', 'GBR', '826', 'CAR', 'Cardiff', '');
673 INSERT INTO static_country_zones VALUES ('338', '0', 'GB', 'GBR', '826', 'CAS', 'Carmarthenshire', '');
674 INSERT INTO static_country_zones VALUES ('339', '0', 'GB', 'GBR', '826', 'CBA', 'Cumbria', '');
675 INSERT INTO static_country_zones VALUES ('340', '0', 'GB', 'GBR', '826', 'CBE', 'Cambridgeshire', '');
676 INSERT INTO static_country_zones VALUES ('341', '0', 'GB', 'GBR', '826', 'CER', 'Ceredigion', '');
677 INSERT INTO static_country_zones VALUES ('342', '0', 'GB', 'GBR', '826', 'CHI', 'Channel Islands', '');
678 INSERT INTO static_country_zones VALUES ('343', '0', 'GB', 'GBR', '826', 'CHS', 'Cheshire', '');
679 INSERT INTO static_country_zones VALUES ('344', '0', 'GB', 'GBR', '826', 'CLD', 'Clwyd', '');
680 INSERT INTO static_country_zones VALUES ('345', '0', 'GB', 'GBR', '826', 'CNL', 'Cornwall', '');
681 INSERT INTO static_country_zones VALUES ('346', '0', 'GB', 'GBR', '826', 'CON', 'Conway', '');
682 INSERT INTO static_country_zones VALUES ('347', '0', 'GB', 'GBR', '826', 'CTR', 'Central', '');
683 INSERT INTO static_country_zones VALUES ('348', '0', 'GB', 'GBR', '826', 'CVE', 'Cleveland', '');
684 INSERT INTO static_country_zones VALUES ('349', '0', 'GB', 'GBR', '826', 'DEN', 'Denbighshire', '');
685 INSERT INTO static_country_zones VALUES ('350', '0', 'GB', 'GBR', '826', 'DFD', 'Dyfed', '');
686 INSERT INTO static_country_zones VALUES ('351', '0', 'GB', 'GBR', '826', 'DGL', 'Dumfries and Galloway', '');
687 INSERT INTO static_country_zones VALUES ('352', '0', 'GB', 'GBR', '826', 'DHM', 'Durham', '');
688 INSERT INTO static_country_zones VALUES ('353', '0', 'GB', 'GBR', '826', 'DOR', 'Dorset', '');
689 INSERT INTO static_country_zones VALUES ('354', '0', 'GB', 'GBR', '826', 'DVN', 'Devon', '');
690 INSERT INTO static_country_zones VALUES ('355', '0', 'GB', 'GBR', '826', 'DWN', 'Down', '');
691 INSERT INTO static_country_zones VALUES ('356', '0', 'GB', 'GBR', '826', 'DYS', 'Derbyshire', '');
692 INSERT INTO static_country_zones VALUES ('357', '0', 'GB', 'GBR', '826', 'ESX', 'Essex', '');
693 INSERT INTO static_country_zones VALUES ('358', '0', 'GB', 'GBR', '826', 'FER', 'Fermanagh', '');
694 INSERT INTO static_country_zones VALUES ('359', '0', 'GB', 'GBR', '826', 'FFE', 'Fife', '');
695 INSERT INTO static_country_zones VALUES ('360', '0', 'GB', 'GBR', '826', 'FLI', 'Flintshire', '');
696 INSERT INTO static_country_zones VALUES ('361', '0', 'GB', 'GBR', '826', 'FMH', 'County Fermanagh', '');
697 INSERT INTO static_country_zones VALUES ('362', '0', 'GB', 'GBR', '826', 'GDD', 'Gwynedd', '');
698 INSERT INTO static_country_zones VALUES ('363', '0', 'GB', 'GBR', '826', 'GLO', 'Gloucestershire', '');
699 INSERT INTO static_country_zones VALUES ('364', '0', 'GB', 'GBR', '826', 'GLR', 'Gloucester', '');
700 INSERT INTO static_country_zones VALUES ('365', '0', 'GB', 'GBR', '826', 'GNM', 'Mid Glamorgan', '');
701 INSERT INTO static_country_zones VALUES ('366', '0', 'GB', 'GBR', '826', 'GNS', 'South Glamorgan', '');
702 INSERT INTO static_country_zones VALUES ('367', '0', 'GB', 'GBR', '826', 'GNW', 'West Glamorgan', '');
703 INSERT INTO static_country_zones VALUES ('368', '0', 'GB', 'GBR', '826', 'GRN', 'Grampian', '');
704 INSERT INTO static_country_zones VALUES ('369', '0', 'GB', 'GBR', '826', 'GUR', 'Guernsey', '');
705 INSERT INTO static_country_zones VALUES ('370', '0', 'GB', 'GBR', '826', 'GWT', 'Gwent', '');
706 INSERT INTO static_country_zones VALUES ('371', '0', 'GB', 'GBR', '826', 'HBS', 'Humberside', '');
707 INSERT INTO static_country_zones VALUES ('372', '0', 'GB', 'GBR', '826', 'HFD', 'Hertfordshire', '');
708 INSERT INTO static_country_zones VALUES ('373', '0', 'GB', 'GBR', '826', 'HLD', 'Highlands', '');
709 INSERT INTO static_country_zones VALUES ('374', '0', 'GB', 'GBR', '826', 'HPH', 'Hampshire', '');
710 INSERT INTO static_country_zones VALUES ('375', '0', 'GB', 'GBR', '826', 'HWR', 'Hereford and Worcester', '');
711 INSERT INTO static_country_zones VALUES ('376', '0', 'GB', 'GBR', '826', 'IOM', 'Isle of Man', '');
712 INSERT INTO static_country_zones VALUES ('377', '0', 'GB', 'GBR', '826', 'IOW', 'Isle of Wight', '');
713 INSERT INTO static_country_zones VALUES ('378', '0', 'GB', 'GBR', '826', 'ISL', 'Isle of Anglesey', '');
714 INSERT INTO static_country_zones VALUES ('379', '0', 'GB', 'GBR', '826', 'JER', 'Jersey', '');
715 INSERT INTO static_country_zones VALUES ('380', '0', 'GB', 'GBR', '826', 'KNT', 'Kent', '');
716 INSERT INTO static_country_zones VALUES ('381', '0', 'GB', 'GBR', '826', 'LCN', 'Lincolnshire', '');
717 INSERT INTO static_country_zones VALUES ('382', '0', 'GB', 'GBR', '826', 'LDN', 'Greater London', '');
718 INSERT INTO static_country_zones VALUES ('383', '0', 'GB', 'GBR', '826', 'LDR', 'Londonderry', '');
719 INSERT INTO static_country_zones VALUES ('384', '0', 'GB', 'GBR', '826', 'LEC', 'Leicestershire', '');
720 INSERT INTO static_country_zones VALUES ('385', '0', 'GB', 'GBR', '826', 'LNH', 'Lancashire', '');
721 INSERT INTO static_country_zones VALUES ('386', '0', 'GB', 'GBR', '826', 'LON', 'London', '');
722 INSERT INTO static_country_zones VALUES ('387', '0', 'GB', 'GBR', '826', 'LTE', 'East Lothian', '');
723 INSERT INTO static_country_zones VALUES ('388', '0', 'GB', 'GBR', '826', 'LTM', 'Mid Lothian', '');
724 INSERT INTO static_country_zones VALUES ('389', '0', 'GB', 'GBR', '826', 'LTW', 'West Lothian', '');
725 INSERT INTO static_country_zones VALUES ('390', '0', 'GB', 'GBR', '826', 'MCH', 'Greater Manchester', '');
726 INSERT INTO static_country_zones VALUES ('391', '0', 'GB', 'GBR', '826', 'MER', 'Merthyr Tydfil', '');
727 INSERT INTO static_country_zones VALUES ('392', '0', 'GB', 'GBR', '826', 'MON', 'Monmouthshire', '');
728 INSERT INTO static_country_zones VALUES ('393', '0', 'GB', 'GBR', '826', 'MSY', 'Merseyside', '');
729 INSERT INTO static_country_zones VALUES ('394', '0', 'GB', 'GBR', '826', 'NET', 'Neath Port Talbot', '');
730 INSERT INTO static_country_zones VALUES ('395', '0', 'GB', 'GBR', '826', 'NEW', 'Newport', '');
731 INSERT INTO static_country_zones VALUES ('396', '0', 'GB', 'GBR', '826', 'NHM', 'Northamptonshire', '');
732 INSERT INTO static_country_zones VALUES ('397', '0', 'GB', 'GBR', '826', 'NLD', 'Northumberland', '');
733 INSERT INTO static_country_zones VALUES ('398', '0', 'GB', 'GBR', '826', 'NOR', 'Norfolk', '');
734 INSERT INTO static_country_zones VALUES ('399', '0', 'GB', 'GBR', '826', 'NOT', 'Nottinghamshire', '');
735 INSERT INTO static_country_zones VALUES ('400', '0', 'GB', 'GBR', '826', 'NWH', 'North West Highlands', '');
736 INSERT INTO static_country_zones VALUES ('401', '0', 'GB', 'GBR', '826', 'OFE', 'Oxfordshire', '');
737 INSERT INTO static_country_zones VALUES ('402', '0', 'GB', 'GBR', '826', 'ORK', 'Orkney', '');
738 INSERT INTO static_country_zones VALUES ('403', '0', 'GB', 'GBR', '826', 'PEM', 'Pembrokeshire', '');
739 INSERT INTO static_country_zones VALUES ('404', '0', 'GB', 'GBR', '826', 'PWS', 'Powys', '');
740 INSERT INTO static_country_zones VALUES ('405', '0', 'GB', 'GBR', '826', 'SCD', 'Strathclyde', '');
741 INSERT INTO static_country_zones VALUES ('406', '0', 'GB', 'GBR', '826', 'SFD', 'Staffordshire', '');
742 INSERT INTO static_country_zones VALUES ('407', '0', 'GB', 'GBR', '826', 'SFK', 'Suffolk', '');
743 INSERT INTO static_country_zones VALUES ('408', '0', 'GB', 'GBR', '826', 'SLD', 'Shetland', '');
744 INSERT INTO static_country_zones VALUES ('409', '0', 'GB', 'GBR', '826', 'SOM', 'Somerset', '');
745 INSERT INTO static_country_zones VALUES ('410', '0', 'GB', 'GBR', '826', 'SPE', 'Shropshire', '');
746 INSERT INTO static_country_zones VALUES ('411', '0', 'GB', 'GBR', '826', 'SRK', 'Sark', '');
747 INSERT INTO static_country_zones VALUES ('412', '0', 'GB', 'GBR', '826', 'SRY', 'Surrey', '');
748 INSERT INTO static_country_zones VALUES ('413', '0', 'GB', 'GBR', '826', 'SWA', 'Swansea', '');
749 INSERT INTO static_country_zones VALUES ('414', '0', 'GB', 'GBR', '826', 'SXE', 'East Sussex', '');
750 INSERT INTO static_country_zones VALUES ('415', '0', 'GB', 'GBR', '826', 'SXW', 'West Sussex', '');
751 INSERT INTO static_country_zones VALUES ('416', '0', 'GB', 'GBR', '826', 'TAF', 'Rhondda Cynon Taff', '');
752 INSERT INTO static_country_zones VALUES ('417', '0', 'GB', 'GBR', '826', 'TOR', 'Torfaen', '');
753 INSERT INTO static_country_zones VALUES ('418', '0', 'GB', 'GBR', '826', 'TWR', 'Tyne and Wear', '');
754 INSERT INTO static_country_zones VALUES ('419', '0', 'GB', 'GBR', '826', 'TYR', 'Tyrone', '');
755 INSERT INTO static_country_zones VALUES ('420', '0', 'GB', 'GBR', '826', 'TYS', 'Tayside', '');
756 INSERT INTO static_country_zones VALUES ('421', '0', 'GB', 'GBR', '826', 'VAL', 'Vale of Glamorgan', '');
757 INSERT INTO static_country_zones VALUES ('422', '0', 'GB', 'GBR', '826', 'WIL', 'Western Isles', '');
758 INSERT INTO static_country_zones VALUES ('423', '0', 'GB', 'GBR', '826', 'WKS', 'Warwickshire', '');
759 INSERT INTO static_country_zones VALUES ('424', '0', 'GB', 'GBR', '826', 'WLT', 'Wiltshire', '');
760 INSERT INTO static_country_zones VALUES ('425', '0', 'GB', 'GBR', '826', 'WMD', 'West Midlands', '');
761 INSERT INTO static_country_zones VALUES ('426', '0', 'GB', 'GBR', '826', 'WRE', 'Wrexham', '');
762 INSERT INTO static_country_zones VALUES ('427', '0', 'GB', 'GBR', '826', 'YSN', 'North Yorkshire', '');
763 INSERT INTO static_country_zones VALUES ('428', '0', 'GB', 'GBR', '826', 'YSS', 'South Yorkshire', '');
764 INSERT INTO static_country_zones VALUES ('429', '0', 'GB', 'GBR', '826', 'YSW', 'West Yorkshire', '');
765 INSERT INTO static_country_zones VALUES ('430', '0', 'IE', 'IRL', '372', 'CAR', 'Carlow', '');
766 INSERT INTO static_country_zones VALUES ('431', '0', 'IE', 'IRL', '372', 'CAV', 'Cavan', '');
767 INSERT INTO static_country_zones VALUES ('432', '0', 'IE', 'IRL', '372', 'CLA', 'Clare', '');
768 INSERT INTO static_country_zones VALUES ('433', '0', 'IE', 'IRL', '372', 'COR', 'Cork', '');
769 INSERT INTO static_country_zones VALUES ('434', '0', 'IE', 'IRL', '372', 'DON', 'Donegal', '');
770 INSERT INTO static_country_zones VALUES ('435', '0', 'IE', 'IRL', '372', 'DUB', 'Dublin', '');
771 INSERT INTO static_country_zones VALUES ('436', '0', 'IE', 'IRL', '372', 'GAL', 'Galway', '');
772 INSERT INTO static_country_zones VALUES ('437', '0', 'IE', 'IRL', '372', 'KER', 'Kerry', '');
773 INSERT INTO static_country_zones VALUES ('438', '0', 'IE', 'IRL', '372', 'KIL', 'Kildare', '');
774 INSERT INTO static_country_zones VALUES ('439', '0', 'IE', 'IRL', '372', 'KLK', 'Kilkenny', '');
775 INSERT INTO static_country_zones VALUES ('440', '0', 'IE', 'IRL', '372', 'LAO', 'Laois', '');
776 INSERT INTO static_country_zones VALUES ('441', '0', 'IE', 'IRL', '372', 'LEI', 'Leitrim', '');
777 INSERT INTO static_country_zones VALUES ('442', '0', 'IE', 'IRL', '372', 'LIM', 'Limerick', '');
778 INSERT INTO static_country_zones VALUES ('443', '0', 'IE', 'IRL', '372', 'LON', 'Longford', '');
779 INSERT INTO static_country_zones VALUES ('444', '0', 'IE', 'IRL', '372', 'LOU', 'Louth', '');
780 INSERT INTO static_country_zones VALUES ('445', '0', 'IE', 'IRL', '372', 'MAY', 'Mayo', '');
781 INSERT INTO static_country_zones VALUES ('446', '0', 'IE', 'IRL', '372', 'MEA', 'Meath', '');
782 INSERT INTO static_country_zones VALUES ('447', '0', 'IE', 'IRL', '372', 'MON', 'Monaghan', '');
783 INSERT INTO static_country_zones VALUES ('448', '0', 'IE', 'IRL', '372', 'OFF', 'Offaly', '');
784 INSERT INTO static_country_zones VALUES ('449', '0', 'IE', 'IRL', '372', 'ROS', 'Roscommon', '');
785 INSERT INTO static_country_zones VALUES ('450', '0', 'IE', 'IRL', '372', 'SLI', 'Sligo', '');
786 INSERT INTO static_country_zones VALUES ('451', '0', 'IE', 'IRL', '372', 'TIP', 'Tipperary', '');
787 INSERT INTO static_country_zones VALUES ('452', '0', 'IE', 'IRL', '372', 'WAT', 'Waterford', '');
788 INSERT INTO static_country_zones VALUES ('453', '0', 'IE', 'IRL', '372', 'WES', 'Westmeath', '');
789 INSERT INTO static_country_zones VALUES ('454', '0', 'IE', 'IRL', '372', 'WEX', 'Wexford', '');
790 INSERT INTO static_country_zones VALUES ('455', '0', 'IE', 'IRL', '372', 'WIC', 'Wicklow', '');
791 INSERT INTO static_country_zones VALUES ('456', '0', 'BR', 'BRA', '76', 'AC', 'Acre', '');
792 INSERT INTO static_country_zones VALUES ('457', '0', 'BR', 'BRA', '76', 'AP', 'Amapá', '');
793 INSERT INTO static_country_zones VALUES ('458', '0', 'BR', 'BRA', '76', 'AL', 'Alagoas', '');
794 INSERT INTO static_country_zones VALUES ('459', '0', 'BR', 'BRA', '76', 'AM', 'Amazonas', '');
795 INSERT INTO static_country_zones VALUES ('460', '0', 'BR', 'BRA', '76', 'BA', 'Bahia', '');
796 INSERT INTO static_country_zones VALUES ('461', '0', 'BR', 'BRA', '76', 'CE', 'Ceará', '');
797 INSERT INTO static_country_zones VALUES ('462', '0', 'BR', 'BRA', '76', 'DF', 'Distrito Federal', '');
798 INSERT INTO static_country_zones VALUES ('463', '0', 'BR', 'BRA', '76', 'ES', 'Espírito Santo', '');
799 INSERT INTO static_country_zones VALUES ('464', '0', 'BR', 'BRA', '76', 'GO', 'Goiás', '');
800 INSERT INTO static_country_zones VALUES ('465', '0', 'BR', 'BRA', '76', 'MA', 'Maranhão', '');
801 INSERT INTO static_country_zones VALUES ('466', '0', 'BR', 'BRA', '76', 'MG', 'Minas Gerais', '');
802 INSERT INTO static_country_zones VALUES ('467', '0', 'BR', 'BRA', '76', 'MS', 'Mato Grosso do Sul', '');
803 INSERT INTO static_country_zones VALUES ('468', '0', 'BR', 'BRA', '76', 'MT', 'Mato Grosso', '');
804 INSERT INTO static_country_zones VALUES ('469', '0', 'BR', 'BRA', '76', 'PA', 'Pará', '');
805 INSERT INTO static_country_zones VALUES ('470', '0', 'BR', 'BRA', '76', 'PB', 'Paraíba', '');
806 INSERT INTO static_country_zones VALUES ('471', '0', 'BR', 'BRA', '76', 'PE', 'Pernambuco', '');
807 INSERT INTO static_country_zones VALUES ('472', '0', 'BR', 'BRA', '76', 'PI', 'Piauí', '');
808 INSERT INTO static_country_zones VALUES ('473', '0', 'BR', 'BRA', '76', 'PR', 'Paraná', '');
809 INSERT INTO static_country_zones VALUES ('474', '0', 'BR', 'BRA', '76', 'RJ', 'Rio de Janeiro', '');
810 INSERT INTO static_country_zones VALUES ('475', '0', 'BR', 'BRA', '76', 'RN', 'Rio Grande do Norte', '');
811 INSERT INTO static_country_zones VALUES ('476', '0', 'BR', 'BRA', '76', 'RO', 'Rondônia', '');
812 INSERT INTO static_country_zones VALUES ('477', '0', 'BR', 'BRA', '76', 'RR', 'Roraima', '');
813 INSERT INTO static_country_zones VALUES ('478', '0', 'BR', 'BRA', '76', 'RS', 'Rio Grande do Sul', '');
814 INSERT INTO static_country_zones VALUES ('479', '0', 'BR', 'BRA', '76', 'SC', 'Santa Catarina', '');
815 INSERT INTO static_country_zones VALUES ('480', '0', 'BR', 'BRA', '76', 'SE', 'Sergipe', '');
816 INSERT INTO static_country_zones VALUES ('481', '0', 'BR', 'BRA', '76', 'SP', 'São Paulo', '');
817 INSERT INTO static_country_zones VALUES ('482', '0', 'BR', 'BRA', '76', 'TO', 'Tocantins', '');
818
819
820 # TYPO3 Extension Manager dump 1.1
821 #
822 #--------------------------------------------------------
823
824
825 #
826 # Table structure for table "static_currencies"
827 #
828 DROP TABLE IF EXISTS static_currencies;
829 CREATE TABLE static_currencies (
830 uid int(11) unsigned auto_increment,
831 pid int(11) unsigned default '0',
832 cu_iso_3 char(3) default '',
833 cu_iso_nr int(11) unsigned default '0',
834 cu_name_en varchar(50) default '',
835 cu_symbol_left varchar(12) default '',
836 cu_symbol_right varchar(12) default '',
837 cu_thousands_point char(1) default '',
838 cu_decimal_point char(1) default '',
839 cu_decimal_digits tinyint(3) unsigned default '0',
840 cu_sub_name_en varchar(20) default '',
841 cu_sub_divisor int(11) default '1',
842 cu_sub_symbol_left varchar(12) default '',
843 cu_sub_symbol_right varchar(12) default '',
844 PRIMARY KEY (uid),
845 UNIQUE uid (uid),
846 KEY parent (pid)
847 );
848
849
850 INSERT INTO static_currencies VALUES ('2', '0', 'AED', '784', 'United Arab Emirates dirham', 'Dhs.', '', '.', ',', '2', 'fils', '100', '', '');
851 INSERT INTO static_currencies VALUES ('4', '0', 'ALL', '8', 'Albanian Lek', 'L', '', '.', ',', '2', 'qindarka', '100', '', '');
852 INSERT INTO static_currencies VALUES ('5', '0', 'AMD', '51', 'Armenian Dram', 'Dram', '', '.', ',', '2', 'luma', '100', '', '');
853 INSERT INTO static_currencies VALUES ('6', '0', 'ANG', '532', 'Netherlands Antillean gulden', 'NAƒ', '', '.', ',', '2', 'cent', '100', '', '');
854 INSERT INTO static_currencies VALUES ('7', '0', 'AOA', '973', 'Angolan Kwanza', 'Kz', '', '.', ',', '2', 'centavo', '100', '', '');
855 INSERT INTO static_currencies VALUES ('8', '0', 'ARS', '32', 'Argentine Peso', '$', '', '.', ',', '2', 'centavo', '100', '', '');
856 INSERT INTO static_currencies VALUES ('9', '0', 'AUD', '36', 'Australian Dollar', '$A', '', '.', ',', '2', 'cent', '100', '', '');
857 INSERT INTO static_currencies VALUES ('10', '0', 'AWG', '533', 'Aruban Guilder', 'Af.', '', '.', ',', '2', 'cent', '100', '', '');
858 INSERT INTO static_currencies VALUES ('11', '0', 'AZN', '944', 'Azerbaijani Manat', '', '', '.', ',', '2', 'qəpik', '100', '', '');
859 INSERT INTO static_currencies VALUES ('12', '0', 'BAM', '977', 'Bosnia-Herzegovina Convertible Mark', 'KM', '', '.', ',', '2', 'feninga', '100', '', '');
860 INSERT INTO static_currencies VALUES ('13', '0', 'BBD', '52', 'Barbados Dollar', 'Bds$', '', '.', ',', '2', 'cent', '100', '', '');
861 INSERT INTO static_currencies VALUES ('14', '0', 'BDT', '50', 'Bangladeshi taka', 'Tk', '', '.', ',', '2', 'paisa', '100', '', '');
862 INSERT INTO static_currencies VALUES ('16', '0', 'BGN', '975', 'Bulgarian Lev', 'lv', '', '.', ',', '2', 'stotinka', '100', '', '');
863 INSERT INTO static_currencies VALUES ('17', '0', 'BHD', '48', 'Bahraini Dinar', 'BD', '', '.', ',', '3', 'fils', '1000', '', '');
864 INSERT INTO static_currencies VALUES ('18', '0', 'BIF', '108', 'Burundi Franc', 'FBu', '', '.', '', '2', 'centime', '100', '', '');
865 INSERT INTO static_currencies VALUES ('19', '0', 'BMD', '60', 'Bermuda Dollar', 'BM$', '', '.', ',', '2', 'cent', '100', '', '');
866 INSERT INTO static_currencies VALUES ('20', '0', 'BND', '96', 'Brunei Dollar', 'B$', '', '.', ',', '2', 'sen', '100', '', '');
867 INSERT INTO static_currencies VALUES ('21', '0', 'BOB', '68', 'Boliviano', 'Bs', '', '.', ',', '2', 'centavo', '100', '', '');
868 INSERT INTO static_currencies VALUES ('23', '0', 'BRL', '986', 'Brazilian Real', 'R$', '', '.', ',', '2', 'centavo', '100', '', '');
869 INSERT INTO static_currencies VALUES ('24', '0', 'BSD', '44', 'Bahamian Dollar', '$', '', '.', ',', '2', 'cent', '100', '', '');
870 INSERT INTO static_currencies VALUES ('25', '0', 'BTN', '64', 'Bhutanese Ngultrum', 'Nu', '', '.', ',', '2', 'chetrum', '100', '', '');
871 INSERT INTO static_currencies VALUES ('26', '0', 'BWP', '72', 'Botswana pula', 'P', '', '.', ',', '2', 'thebe', '100', '', '');
872 INSERT INTO static_currencies VALUES ('27', '0', 'BYR', '974', 'Belarussian Ruble', 'Br', '', '.', ',', '2', 'kapiejka', '100', '', '');
873 INSERT INTO static_currencies VALUES ('28', '0', 'BZD', '84', 'Belize Dollar', 'BZ', '', '.', ',', '2', 'cent', '100', '', '');
874 INSERT INTO static_currencies VALUES ('29', '0', 'CAD', '124', 'Canadian Dollar', '$', '', '.', ',', '2', 'cent', '100', '', '¢');
875 INSERT INTO static_currencies VALUES ('30', '0', 'CDF', '976', 'Congolese franc', 'FC', '', '.', ',', '2', 'centime', '100', '', '');
876 INSERT INTO static_currencies VALUES ('31', '0', 'CHF', '756', 'Swiss franc', 'SFr.', '', '.', ',', '2', 'centime', '100', '', '');
877 INSERT INTO static_currencies VALUES ('33', '0', 'CLP', '152', 'Chilean Peso', '$', '', '.', '', '0', '', '1', '', '');
878 INSERT INTO static_currencies VALUES ('34', '0', 'CNY', '156', 'Chinese Yuan Renminbi', 'Ұ', '', '.', ',', '2', 'fen', '100', '', '');
879 INSERT INTO static_currencies VALUES ('35', '0', 'COP', '170', 'Colombian Peso', '$', '', '.', ',', '2', 'centavo', '100', '', '');
880 INSERT INTO static_currencies VALUES ('36', '0', 'CRC', '188', 'Costa Rican colón', '₡', '', '.', ',', '2', 'centimo', '100', '', '');
881 INSERT INTO static_currencies VALUES ('37', '0', 'CUP', '192', 'Cuban peso', 'Cub$', '', '.', ',', '2', 'centavo', '100', '', '');
882 INSERT INTO static_currencies VALUES ('38', '0', 'CVE', '132', 'Cape Verde Escudo', 'CVEsc.', '', '.', ',', '2', 'centavo', '100', '', '');
883 INSERT INTO static_currencies VALUES ('39', '0', 'CYP', '196', 'Cypriot pound', 'C£', '', '.', ',', '2', 'cent', '100', '', '');
884 INSERT INTO static_currencies VALUES ('40', '0', 'CZK', '203', 'Czech koruna', '', 'Kč', '.', ',', '2', 'haléř', '100', '', '');
885 INSERT INTO static_currencies VALUES ('41', '0', 'DJF', '262', 'Djibouti franc', 'FD', '', '.', '', '0', '', '1', '', '');
886 INSERT INTO static_currencies VALUES ('42', '0', 'DKK', '208', 'Danish krone', 'kr.', '', '.', ',', '2', 'Øre', '100', '', '');
887 INSERT INTO static_currencies VALUES ('43', '0', 'DOP', '214', 'Dominican peso', 'RD$', '', '.', ',', '2', 'centavo', '100', '', '');
888 INSERT INTO static_currencies VALUES ('44', '0', 'DZD', '12', 'Algerian Dinar', 'DA', '', '.', ',', '2', 'centime', '100', '', '');
889 INSERT INTO static_currencies VALUES ('45', '0', 'EEK', '233', 'Estonian kroon', '', 'ekr', '.', ',', '2', 'sent', '100', '', '');
890 INSERT INTO static_currencies VALUES ('46', '0', 'EGP', '818', 'Egyptian pound', 'LE', '', '.', ',', '2', 'piastre', '100', '', '');
891 INSERT INTO static_currencies VALUES ('47', '0', 'ERN', '232', 'Eritrean nakfa', 'Nfa', '', '.', ',', '2', 'cent', '100', '', '');
892 INSERT INTO static_currencies VALUES ('48', '0', 'ETB', '230', 'Ethiopian birr', 'Br', '', '.', ',', '2', 'santim', '100', '', '');
893 INSERT INTO static_currencies VALUES ('49', '0', 'EUR', '978', 'Euro', '€', '', '.', ',', '2', 'cent', '100', '¢', '');
894 INSERT INTO static_currencies VALUES ('50', '0', 'FJD', '242', 'Fijian dollar', 'FJ$', '', '.', ',', '2', 'cent', '100', '', '');
895 INSERT INTO static_currencies VALUES ('51', '0', 'FKP', '238', 'Falkland Islands pound', 'Fl£', '', '.', ',', '2', 'penny', '100', '', '');
896 INSERT INTO static_currencies VALUES ('52', '0', 'GBP', '826', 'Pound sterling', '£', '', ',', '.', '2', 'penny', '100', '', 'p');
897 INSERT INTO static_currencies VALUES ('53', '0', 'GEL', '981', 'Georgian lari', '', 'lari', '.', ',', '2', 'tetri', '100', '', '');
898 INSERT INTO static_currencies VALUES ('54', '0', 'GHC', '288', 'Ghanaian cedi', '', '', '.', ',', '2', 'pesewa', '100', '', '');
899 INSERT INTO static_currencies VALUES ('55', '0', 'GIP', '292', 'Gibraltar pound', '£', '', '.', ',', '2', 'penny', '100', '', '');
900 INSERT INTO static_currencies VALUES ('56', '0', 'GMD', '270', 'Gambian dalasi', 'D', '', '.', ',', '2', 'butut', '100', '', '');
901 INSERT INTO static_currencies VALUES ('57', '0', 'GNF', '324', 'Guinea Franc', 'GF', '', '.', '', '0', '', '1', '', '');
902 INSERT INTO static_currencies VALUES ('58', '0', 'GTQ', '320', 'Guatemalan quetzal', 'Q.', '', '.', ',', '2', 'centavo', '100', '', '');
903 INSERT INTO static_currencies VALUES ('59', '0', 'GWP', '624', 'Guinea-Bissau Peso', '', '', '.', ',', '2', '', '100', '', '');
904 INSERT INTO static_currencies VALUES ('60', '0', 'GYD', '328', 'Guyana Dollar', 'G$', '', '.', ',', '2', 'Cent', '100', '', '');
905 INSERT INTO static_currencies VALUES ('61', '0', 'HKD', '344', 'Hong Kong dollar', 'HK$', '', '.', ',', '2', 'cent', '100', '', '');
906 INSERT INTO static_currencies VALUES ('62', '0', 'HNL', '340', 'Honduran lempira', 'L', '', '.', ',', '2', 'centavo', '100', '', '');
907 INSERT INTO static_currencies VALUES ('63', '0', 'HRK', '191', 'Croatian kuna', 'kn', '', '.', ',', '2', 'lipa', '100', '', '');
908 INSERT INTO static_currencies VALUES ('64', '0', 'HTG', '332', 'Haitian gourde', 'Gde.', '', '.', ',', '2', 'centime', '100', '', '');
909 INSERT INTO static_currencies VALUES ('65', '0', 'HUF', '348', 'Hungarian forint', '', 'Ft', '.', ',', '2', 'fillér', '100', '', '');
910 INSERT INTO static_currencies VALUES ('66', '0', 'IDR', '360', 'Indonesian rupiah', 'Rp.', '', '.', ',', '2', 'sen', '100', '', '');
911 INSERT INTO static_currencies VALUES ('67', '0', 'ILS', '376', 'New Israeli Sheqel', '', 'NIS', '.', ',', '2', 'agora', '100', '', '');
912 INSERT INTO static_currencies VALUES ('68', '0', 'INR', '356', 'Indian rupee', 'Rs', '', '.', ',', '2', 'paisha', '100', '', '');
913 INSERT INTO static_currencies VALUES ('69', '0', 'IQD', '368', 'Iraqi dinar', 'ID', '', '.', ',', '3', 'fils', '1000', '', '');
914 INSERT INTO static_currencies VALUES ('70', '0', 'IRR', '364', 'Iranian rial', 'Rls', '', '.', ',', '2', 'dinar', '100', '', '');
915 INSERT INTO static_currencies VALUES ('71', '0', 'ISK', '352', 'Icelandic króna', '', 'ikr', '.', ',', '2', 'aurar', '100', '', '');
916 INSERT INTO static_currencies VALUES ('72', '0', 'JMD', '388', 'Jamaican dollar', 'J$', '', '.', ',', '2', 'cent', '100', '', '');
917 INSERT INTO static_currencies VALUES ('73', '0', 'JOD', '400', 'Jordanian dinar', 'JD', '', '.', ',', '2', 'piastre', '100', '', '');
918 INSERT INTO static_currencies VALUES ('74', '0', 'JPY', '392', 'Japanese yen', '¥', '', '.', '', '2', 'sen', '100', '', '');
919 INSERT INTO static_currencies VALUES ('75', '0', 'KES', '404', 'Kenyan shilling', 'Kshs.', '', '.', ',', '2', 'cent', '100', '', '');
920 INSERT INTO static_currencies VALUES ('76', '0', 'KGS', '417', 'Kyrgyzstani som', 'K.S.', '', '.', ',', '2', 'tyiyn', '100', '', '');
921 INSERT INTO static_currencies VALUES ('77', '0', 'KHR', '116', 'Cambodian riel', 'CR', '', '.', ',', '2', 'sen', '100', '', '');
922 INSERT INTO static_currencies VALUES ('78', '0', 'KMF', '174', 'Comorian Franc', 'CF', '', '.', '', '0', '', '1', '', '');
923 INSERT INTO static_currencies VALUES ('79', '0', 'KPW', '408', 'North Korean won', '₩n', '', '.', ',', '2', 'chon', '100', '', '');
924 INSERT INTO static_currencies VALUES ('80', '0', 'KRW', '410', 'South Corean won', '₩', '', '.', '', '2', 'jeon', '100', '', '');
925 INSERT INTO static_currencies VALUES ('81', '0', 'KWD', '414', 'Kuwaiti dinar', 'KD', '', '.', ',', '3', 'fils', '1000', '', '');
926 INSERT INTO static_currencies VALUES ('82', '0', 'KYD', '136', 'Cayman Islands Dollar', '$', '', '.', ',', '2', 'cent', '100', '', '');
927 INSERT INTO static_currencies VALUES ('83', '0', 'KZT', '398', 'Kazakhstani tenge', 'T', '', '.', ',', '2', 'tiyin', '100', '', '');
928 INSERT INTO static_currencies VALUES ('84', '0', 'LAK', '418', 'Lao kip', '₭', '', '.', ',', '2', 'at', '100', '', '');
929 INSERT INTO static_currencies VALUES ('85', '0', 'LBP', '422', 'Lebanese pound', '', 'LL', '.', ',', '2', 'piastre', '100', '', '');
930 INSERT INTO static_currencies VALUES ('86', '0', 'LKR', '144', 'Sri Lankan rupee', 'Re', '', '.', ',', '2', 'cent', '100', '', '');
931 INSERT INTO static_currencies VALUES ('87', '0', 'LRD', '430', 'Liberian dollar', 'Lib$', '', '.', ',', '2', 'cent', '100', '', '');
932 INSERT INTO static_currencies VALUES ('88', '0', 'LSL', '426', 'Lesotho loti', 'M', '', '.', ',', '2', 'sente', '100', '', '');
933 INSERT INTO static_currencies VALUES ('89', '0', 'LTL', '440', 'Lithuanian litas', '', 'Lt', '.', ',', '2', 'centas', '100', '', '');
934 INSERT INTO static_currencies VALUES ('90', '0', 'LVL', '428', 'Latvian lats', 'Ls', '', '.', ',', '2', 'santim', '100', '', '');
935 INSERT INTO static_currencies VALUES ('91', '0', 'LYD', '434', 'Libyan dinar', 'LD.', '', '.', ',', '3', 'dirham', '1000', '', '');
936 INSERT INTO static_currencies VALUES ('92', '0', 'MAD', '504', 'Moroccan dirham', 'Dh', '', '.', ',', '2', 'centime', '100', '', '');
937 INSERT INTO static_currencies VALUES ('93', '0', 'MDL', '498', 'Moldovan leu', '', '', '.', ',', '2', 'ban', '100', '', '');
938 INSERT INTO static_currencies VALUES ('95', '0', 'MKD', '807', 'Macedonian denar', 'Den', '', '.', ',', '2', 'deni', '100', '', '');
939 INSERT INTO static_currencies VALUES ('96', '0', 'MMK', '104', 'Myanmar kyat', 'K', '', '.', ',', '2', 'pya', '100', '', '');
940 INSERT INTO static_currencies VALUES ('97', '0', 'MNT', '496', 'Mongolian tugrug', '₮', '', '.', ',', '2', 'mongo', '100', '', '');
941 INSERT INTO static_currencies VALUES ('98', '0', 'MOP', '446', 'Macanese pataca', 'Pat.', '', '.', ',', '2', 'avo', '100', '', '');
942 INSERT INTO static_currencies VALUES ('99', '0', 'MRO', '478', 'Mauritanian ouguiya', 'UM', '', '.', ',', '2', 'khoum', '100', '', '');
943 INSERT INTO static_currencies VALUES ('100', '0', 'MTL', '470', 'Maltese lira', 'Lm', '', '.', ',', '2', 'cent', '100', '', '');
944 INSERT INTO static_currencies VALUES ('101', '0', 'MUR', '480', 'Mauritian rupee', 'Rs', '', '.', ',', '2', 'cent', '100', '', '');
945 INSERT INTO static_currencies VALUES ('102', '0', 'MVR', '462', 'Maldivian rufiyaa', 'Rf', '', '.', ',', '2', 'laari', '100', '', '');
946 INSERT INTO static_currencies VALUES ('103', '0', 'MWK', '454', 'Malawian kwacha', 'MK', '', '.', ',', '2', 'tambala', '100', '', '');
947 INSERT INTO static_currencies VALUES ('104', '0', 'MXN', '484', 'Mexican peso', '$', '', '.', ',', '2', 'centavo', '100', '', '');
948 INSERT INTO static_currencies VALUES ('106', '0', 'MYR', '458', 'Malaysian ringgit', 'RM', '', '.', ',', '2', 'sen', '100', '', '');
949 INSERT INTO static_currencies VALUES ('107', '0', 'MZM', '508', 'Mozambican metical', '', 'Mt', '.', ',', '2', 'centavo', '100', '', '');
950 INSERT INTO static_currencies VALUES ('108',