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