-- ========================================================================
-- Copyright (C) 2020 		Open-DSI      <support@open-dsi.fr>
--
-- This program is free software; you can redistribute it and/or modify
-- it under the terms of the GNU General Public License as published by
-- the Free Software Foundation; either version 3 of the License, or
-- (at your option) any later version.
--
-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-- GNU General Public License for more details.
--
-- You should have received a copy of the GNU General Public License
-- along with this program. If not, see <http://www.gnu.org/licenses/>.
--
-- ========================================================================

-- Contenu de la table `llx_c_sirene_country`
l
DROP TABLE `llx_c_sirene_country`;

create table llx_c_sirene_country
(
    rowid INT NOT NULL AUTO_INCREMENT,
    code_sirene  varchar(255) not null,
    country_code varchar(255) not null,
    country_code_iso varchar(255) not null,
    country_label varchar(255) not null,
    PRIMARY KEY (`rowid`)
);


INSERT INTO `llx_c_sirene_country` (`code_sirene`, `country_code`, `country_code_iso`, `country_label`) VALUES
('-1',  'FR',  'FRA', 'France' ),
('99131',  'BE',  'BEL', 'Belgium' ),
('99127',  'IT',  'ITA', 'Italy' ),
('99134',  'ES',  'ESP', 'Spain' ),
('99109',  'DE',  'DEU', 'Germany' ),
('99140',  'CH',  'CHE', 'Switzerland' ),
('99132',  'GB',  'GBR', 'United Kingdom' ),
('99136',  'IE',  'IRL', 'Irland' ),
('99216',  'CN',  'CHN', 'China' ),
('99351',  'TN',  'TUN', 'Tunisia' ),
('99404',  'US',  'USA', 'United States' ),
('99350',  'MA',  'MAR', 'Maroc' ),
('99352',  'DZ',  'DZA', 'Algeria' ),
('99401',  'CA',  'CAN', 'Canada' ),
('99345',  'TG',  'TGO', 'Togo' ),
('99328',  'GA',  'GAB', 'Gabon' ),
('99135',  'NL',  'NLD', 'Nederland' ),
('99112',  'HU',  'HUN', 'Hongrie' ),
('99123',  'RU',  'RUS', 'Russia' ),
('99104',  'SE',  'SWE', 'Sweden' ),
('99326',  'CI',  'CIV', 'Côte dIvoire' ),
('99341',  'SN',  'SEN', 'Senegal' ),
('99415',  'AR',  'ARG', 'Argentine' ),
('99322',  'CM',  'CMR', 'Cameroun' ),
('99139',  'PT',  'PRT', 'Portugal' ),
('99201',  'SA',  'SAU', 'Saudi Arabia' ),
('99138',  'MC',  'MCO', 'Monaco' ),
('99501',  'AU',  'AUS', 'Australia' ),
('99226',  'SG',  'SGP', 'Singapour' ),
('99212',  'AF',  'AFG', 'Afghanistan' ),
('99125',  'AL',  'ALB', 'Albanie' ),
('99505',  'AS',  'ASM', 'Samoa américaines' ),
('99130',  'AD',  'AND', 'Andorre' ),
('99395',  'AO',  'AGO', 'Angola' ),
('99425',  'AI',  'AIA', 'Anguilla' ),
('99441',  'AG',  'ATG', 'Antigua-et-Barbuda' ),
('99252',  'AM',  'ARM', 'Arménie' ),
('99135',  'AW',  'ABW', 'Aruba' ),
('99110',  'AT',  'AUT', 'Autriche' ),
('99253',  'AZ',  'AZE', 'Azerbaïdjan' ),
('99436',  'BS',  'BHS', 'Bahamas' ),
('99249',  'BH',  'BHR', 'Bahreïn' ),
('99246',  'BD',  'BGD', 'Bangladesh' ),
('99434',  'BB',  'BRB', 'Barbade' ),
('99148',  'BY',  'BLR', 'Biélorussie' ),
('99429',  'BZ',  'BLZ', 'Belize' ),
('99327',  'BJ',  'BEN', 'Bénin' ),
('99425',  'BM',  'BMU', 'Bermudes' ),
('99214',  'BT',  'BTN', 'Bhoutan' ),
('99418',  'BO',  'BOL', 'Bolivie' ),
('99118',  'BA',  'BIH', 'Bosnie-Herzégovine' ),
('99347',  'BW',  'BWA', 'Botswana' ),
('99103',  'BV',  'BVT', 'Ile Bouvet' ),
('99416',  'BR',  'BRA', 'Brazil' ),
('99308',  'IO',  'IOT', 'Territoire britannique de lOcéan Indien' ),
('99225',  'BN',  'BRN', 'Brunei' ),
('99111',  'BG',  'BGR', 'Bulgarie' ),
('99331',  'BF',  'BFA', 'Burkina Faso' ),
('99321',  'BI',  'BDI', 'Burundi' ),
('99234',  'KH',  'KHM', 'Cambodge' ),
('99396',  'CV',  'CPV', 'Cap-Vert' ),
('99425',  'KY',  'CYM', 'Iles Cayman' ),
('99323',  'CF',  'CAF', 'République centrafricaine' ),
('99344',  'TD',  'TCD', 'Tchad' ),
('99417',  'CL',  'CHL', 'Chili' ),
('99501',  'CX',  'CXR', 'Ile Christmas' ),
('99501',  'CC',  'CCK', 'Iles des Cocos (Keeling)' ),
('99419',  'CO',  'COL', 'Colombie' ),
('99397',  'KM',  'COM', 'Comores' ),
('99324',  'CG',  'COG', 'Congo' ),
('99312',  'CD',  'COD', 'République démocratique du Congo' ),
('99502',  'CK',  'COK', 'Iles Cook' ),
('99406',  'CR',  'CRI', 'Costa Rica' ),
('99119',  'HR',  'HRV', 'Croatie' ),
('99407',  'CU',  'CUB', 'Cuba' ),
('99116',  'CZ',  'CZE', 'République Tchèque' ),
('99101',  'DK',  'DNK', 'Danemark' ),
('99399',  'DJ',  'DJI', 'Djibouti' ),
('99438',  'DM',  'DMA', 'Dominique' ),
('99408',  'DO',  'DOM', 'République Dominicaine' ),
('99420',  'EC',  'ECU', 'Equateur' ),
('99301',  'EG',  'EGY', 'Egypte' ),
('99414',  'SV',  'SLV', 'Salvador' ),
('99314',  'GQ',  'GNQ', 'Guinée Equatoriale' ),
('99317',  'ER',  'ERI', 'Erythrée' ),
('99106',  'EE',  'EST', 'Estonia' ),
('99315',  'ET',  'ETH', 'Ethiopie' ),
('99427',  'FK',  'FLK', 'Iles Falkland' ),
('99101',  'FO',  'FRO', 'Iles Féroé' ),
('99508',  'FJ',  'FJI', 'Iles Fidji' ),
('99105',  'FI',  'FIN', 'Finlande' ),
('99428',  'GF',  'GUF', 'Guyane française' ),
('99304',  'GM',  'GMB', 'Gambie' ),
('99255',  'GE',  'GEO', 'Georgia' ),
('99329',  'GH',  'GHA', 'Ghana' ),
('99133',  'GI',  'GIB', 'Gibraltar' ),
('99126',  'GR',  'GRC', 'Greece' ),
('99430',  'GL',  'GRL', 'Groenland' ),
('99435',  'GD',  'GRD', 'Grenade' ),
('99505',  'GU',  'GUM', 'Guam' ),
('99409',  'GT',  'GTM', 'Guatemala' ),
('99330',  'GN',  'GIN', 'Guinea' ),
('99392',  'GW',  'GNB', 'Guinea-Bissao' ),
('99410',  'HT',  'HTI', 'Haiti' ),
('99501',  'HM',  'HMD', 'Iles Heard et McDonald' ),
('99129',  'VA',  'VAT', 'Saint-Siège (Vatican)' ),
('99411',  'HN',  'HND', 'Honduras' ),
('99230',  'HK',  'HKG', 'Hong Kong' ),
('99102',  'IS',  'ISL', 'Islande' ),
('99223',  'IN',  'IND', 'India' ),
('99231',  'ID',  'IDN', 'Indonésie' ),
('99204',  'IR',  'IRN', 'Iran' ),
('99203',  'IQ',  'IRQ', 'Iraq' ),
('99207',  'IL',  'ISR', 'Israel' ),
('99426',  'JM',  'JAM', 'Jamaïque' ),
('99217',  'JP',  'JPN', 'Japon' ),
('99222',  'JO',  'JOR', 'Jordanie' ),
('99256',  'KZ',  'KAZ', 'Kazakhstan' ),
('99332',  'KE',  'KEN', 'Kenya' ),
('99513',  'KI',  'KIR', 'Kiribati' ),
('99237',  'KP',  'PRK', 'North Corea' ),
('99237',  'KR',  'KOR', 'South Corea' ),
('99240',  'KW',  'KWT', 'Koweït' ),
('99257',  'KG',  'KGZ', 'Kirghizistan' ),
('99241',  'LA',  'LAO', 'Laos' ),
('99107',  'LV',  'LVA', 'Lettonie' ),
('99205',  'LB',  'LBN', 'Liban' ),
('99348',  'LS',  'LSO', 'Lesotho' ),
('99302',  'LR',  'LBR', 'Liberia' ),
('99316',  'LY',  'LBY', 'Libye' ),
('99113',  'LI',  'LIE', 'Liechtenstein' ),
('99108',  'LT',  'LTU', 'Lituanie' ),
('99137',  'LU',  'LUX', 'Luxembourg' ),
('99232',  'MO',  'MAC', 'Macao' ),
('99156',  'MK',  'MKD', 'ex-République yougoslave de Macédoine' ),
('99333',  'MG',  'MDG', 'Madagascar' ),
('99334',  'MW',  'MWI', 'Malawi' ),
('99227',  'MY',  'MYS', 'Malaisie' ),
('99229',  'MV',  'MDV', 'Maldives' ),
('99335',  'ML',  'MLI', 'Mali' ),
('99144',  'MT',  'MLT', 'Malte' ),
('99515',  'MH',  'MHL', 'Iles Marshall' ),
('99336',  'MR',  'MRT', 'Mauritanie' ),
('99390',  'MU',  'MUS', 'Maurice' ),
('99405',  'MX',  'MEX', 'Mexique' ),
('99516',  'FM',  'FSM', 'Micronésie' ),
('99151',  'MD',  'MDA', 'Moldavie' ),
('99242',  'MN',  'MNG', 'Mongolie' ),
('99425',  'MS',  'MSR', 'Monserrat' ),
('99393',  'MZ',  'MOZ', 'Mozambique' ),
('99224',  'MM',  'MMR', 'Birmanie (Myanmar)' ),
('99311',  'NA',  'NAM', 'Namibie' ),
('99507',  'NR',  'NRU', 'Nauru' ),
('99215',  'NP',  'NPL', 'Népal' ),
('99502',  'NZ',  'NZL', 'Nouvelle-Zélande' ),
('99412',  'NI',  'NIC', 'Nicaragua' ),
('99337',  'NE',  'NER', 'Niger' ),
('99338',  'NG',  'NGA', 'Nigeria' ),
('99502',  'NU',  'NIU', 'Nioué' ),
('99501',  'NF',  'NFK', 'Ile Norfolk' ),
('99505',  'MP',  'MNP', 'Mariannes du Nord' ),
('99103',  'NO',  'NOR', 'Norvège' ),
('99250',  'OM',  'OMN', 'Oman' ),
('99213',  'PK',  'PAK', 'Pakistan' ),
('99517',  'PW',  'PLW', 'Palaos' ),
('99261',  'PS',  'PSE', 'Territoire Palestinien Occupé' ),
('99413',  'PA',  'PAN', 'Panama' ),
('99510',  'PG',  'PNG', 'Papouasie-Nouvelle-Guinée' ),
('99421',  'PY',  'PRY', 'Paraguay' ),
('99422',  'PE',  'PER', 'Peru' ),
('99220',  'PH',  'PHL', 'Philippines' ),
('99503',  'PN',  'PCN', 'Iles Pitcairn' ),
('99122',  'PL',  'POL', 'Pologne' ),
('99432',  'PR',  'PRI', 'Porto Rico' ),
('99248',  'QA',  'QAT', 'Qatar' ),
('99114',  'RO',  'ROU', 'Roumanie' ),
('99340',  'RW',  'RWA', 'Rwanda' ),
('99306',  'SH',  'SHN', 'Sainte-Hélène' ),
('99442',  'KN',  'KNA', 'Saint-Christophe-et-Niévès' ),
('99439',  'LC',  'LCA', 'Sainte-Lucie' ),
('99440',  'VC',  'VCT', 'Saint-Vincent-et-les-Grenadines' ),
('99506',  'WS',  'WSM', 'Samoa' ),
('99128',  'SM',  'SMR', 'Saint-Marin' ),
('99394',  'ST',  'STP', 'Sao Tomé-et-Principe' ),
('99121',  'RS',  'SRB', 'Serbie' ),
('99398',  'SC',  'SYC', 'Seychelles' ),
('99342',  'SL',  'SLE', 'Sierra Leone' ),
('99117',  'SK',  'SVK', 'Slovaquie' ),
('99145',  'SI',  'SVN', 'Slovénie' ),
('99512',  'SB',  'SLB', 'Iles Salomon' ),
('99318',  'SO',  'SOM', 'Somalie' ),
('99303',  'ZA',  'ZAF', 'South Africa' ),
('99427',  'GS',  'SGS', 'Iles Géorgie du Sud et Sandwich du Sud' ),
('99235',  'LK',  'LKA', 'Sri Lanka' ),
('99343',  'SD',  'SDN', 'Soudan' ),
('99437',  'SR',  'SUR', 'Suriname' ),
('99103',  'SJ',  'SJM', 'Iles Svalbard et Jan Mayen' ),
('99391',  'SZ',  'SWZ', 'Swaziland' ),
('99206',  'SY',  'SYR', 'Syrie' ),
('99236',  'TW',  'TWN', 'Taïwan' ),
('99259',  'TJ',  'TJK', 'Tadjikistan' ),
('99309',  'TZ',  'TZA', 'Tanzanie' ),
('99219',  'TH',  'THA', 'Thaïlande' ),
('99262',  'TL',  'TLS', 'Timor Oriental' ),
('99502',  'TK',  'TKL', 'Tokélaou' ),
('99509',  'TO',  'TON', 'Tonga' ),
('99433',  'TT',  'TTO', 'Trinité-et-Tobago' ),
('99208',  'TR',  'TUR', 'Turquie' ),
('99260',  'TM',  'TKM', 'Turkménistan' ),
('99425',  'TC',  'TCA', 'Iles Turks-et-Caicos' ),
('99511',  'TV',  'TUV', 'Tuvalu' ),
('99339',  'UG',  'UGA', 'Ouganda' ),
('99155',  'UA',  'UKR', 'Ukraine' ),
('99247',  'AE',  'ARE', 'United Arab Emirates' ),
('99423',  'UY',  'URY', 'Uruguay' ),
('99258',  'UZ',  'UZB', 'Ouzbékistan' ),
('99514',  'VU',  'VUT', 'Vanuatu' ),
('99424',  'VE',  'VEN', 'Vénézuela' ),
('99243',  'VN',  'VNM', 'Viêt Nam' ),
('99425',  'VG',  'VGB', 'Iles Vierges britanniques' ),
('99432',  'VI',  'VIR', 'Iles Vierges américaines' ),
('99389',  'EH',  'ESH', 'Sahara occidental' ),
('99251',  'YE',  'YEM', 'Yémen' ),
('99346',  'ZM',  'ZMB', 'Zambie' ),
('99310',  'ZW',  'ZWE', 'Zimbabwe' ),
('99132',  'GG',  'GGY', 'Guernesey' ),
('99132',  'IM',  'IMN', 'Ile de Man' ),
('99132',  'JE',  'JEY', 'Jersey' ),
('99120',  'ME',  'MNE', 'Monténégro' ),
('99445',  'MF',  'MAF', 'Saint-Martin' ),
('99157',  'XK',  'XKX', 'Kosovo' ),
('99444',  'CW',  'CUW', 'Curaçao' );


