-- MySQL dump 10.13  Distrib 8.0.33, for Win64 (x86_64)
--
-- Host: localhost    Database: medvista
-- ------------------------------------------------------
-- Server version	8.0.33

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `llx_c_country`
--

DROP TABLE IF EXISTS `llx_c_country`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `llx_c_country` (
  `rowid` int NOT NULL,
  `code` varchar(2) NOT NULL,
  `code_iso` varchar(3) DEFAULT NULL,
  `numeric_code` varchar(3) DEFAULT NULL,
  `label` varchar(128) NOT NULL,
  `eec` tinyint NOT NULL DEFAULT '0',
  `active` tinyint NOT NULL DEFAULT '1',
  `favorite` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `idx_c_country_code` (`code`),
  UNIQUE KEY `idx_c_country_label` (`label`),
  UNIQUE KEY `idx_c_country_code_iso` (`code_iso`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `llx_c_country`
--

LOCK TABLES `llx_c_country` WRITE;
/*!40000 ALTER TABLE `llx_c_country` DISABLE KEYS */;
INSERT INTO `llx_c_country` VALUES (0,'',NULL,NULL,'-',0,1,1),(1,'FR','FRA','250','France',1,1,0),(2,'BE','BEL','056','Belgium',1,1,0),(3,'IT','ITA','380','Italy',1,1,0),(4,'ES','ESP','724','Spain',1,1,0),(5,'DE','DEU','276','Germany',1,1,0),(6,'CH','CHE','756','Switzerland',0,1,0),(7,'GB','GBR','826','United Kingdom',0,1,0),(8,'IE','IRL','372','Ireland',1,1,0),(9,'CN','CHN','156','China',0,1,0),(10,'TN','TUN','788','Tunisia',0,1,0),(11,'US','USA','840','United States',0,1,0),(12,'MA','MAR','504','Morocco',0,1,0),(13,'DZ','DZA','012','Algeria',0,1,0),(14,'CA','CAN','124','Canada',0,1,0),(15,'TG','TGO','768','Togo',0,1,0),(16,'GA','GAB','266','Gabon',0,1,0),(17,'NL','NLD','528','Netherlands',1,1,0),(18,'HU','HUN','348','Hungary',1,1,0),(19,'RU','RUS','643','Russia',0,1,0),(20,'SE','SWE','752','Sweden',1,1,0),(21,'CI','CIV','384','Côte d\'Ivoire',0,1,0),(22,'SN','SEN','686','Senegal',0,1,0),(23,'AR','ARG','032','Argentina',0,1,0),(24,'CM','CMR','120','Cameroun',0,1,0),(25,'PT','PRT','620','Portugal',1,1,0),(26,'SA','SAU','682','Saudi Arabia',0,1,0),(27,'MC','MCO','492','Monaco',1,1,0),(28,'AU','AUS','036','Australia',0,1,0),(29,'SG','SGP','702','Singapore',0,1,0),(30,'AF','AFG','004','Afghanistan',0,1,0),(31,'AX','ALA','248','Åland Island',0,1,0),(32,'AL','ALB','008','Albania',0,1,0),(33,'AS','ASM','016','American Samoa',0,1,0),(34,'AD','AND','020','Andorra',0,1,0),(35,'AO','AGO','024','Angola',0,1,0),(36,'AI','AIA','660','Anguilla',0,1,0),(37,'AQ','ATA','010','Antarctica',0,1,0),(38,'AG','ATG','028','Antigua and Barbuda',0,1,0),(39,'AM','ARM','051','Armenia',0,1,0),(40,'AW','ABW','533','Aruba',0,1,0),(41,'AT','AUT','040','Austria',1,1,0),(42,'AZ','AZE','031','Azerbaijan',0,1,0),(43,'BS','BHS','044','Bahamas',0,1,0),(44,'BH','BHR','048','Bahrain',0,1,0),(45,'BD','BGD','050','Bangladesh',0,1,0),(46,'BB','BRB','052','Barbados',0,1,0),(47,'BY','BLR','112','Belarus',0,1,0),(48,'BZ','BLZ','084','Belize',0,1,0),(49,'BJ','BEN','204','Benin',0,1,0),(50,'BM','BMU','060','Bermuda',0,1,0),(51,'BT','BTN','064','Bhutan',0,1,0),(52,'BO','BOL','068','Bolivia',0,1,0),(53,'BA','BIH','070','Bosnia and Herzegovina',0,1,0),(54,'BW','BWA','072','Botswana',0,1,0),(55,'BV','BVT','074','Bouvet Island',0,0,0),(56,'BR','BRA','076','Brazil',0,1,0),(57,'IO','IOT','086','British Indian Ocean Territory',0,1,0),(58,'BN','BRN','096','Brunei',0,1,0),(59,'BG','BGR','100','Bulgaria',1,1,0),(60,'BF','BFA','854','Burkina Faso',0,1,0),(61,'BI','BDI','108','Burundi',0,1,0),(62,'KH','KHM','116','Cambodge / Cambodia',0,1,0),(63,'CV','CPV','132','Cap-Vert',0,1,0),(64,'KY','CYM','136','Iles Cayman',0,1,0),(65,'CF','CAF','140','Central African Republic (CAR/RCA)',0,1,0),(66,'TD','TCD','148','Tchad',0,1,0),(67,'CL','CHL','152','Chile',0,1,0),(68,'CX','CXR','162','Ile Christmas',0,1,0),(69,'CC','CCK','166','Iles des Cocos (Keeling)',0,1,0),(70,'CO','COL','170','Colombie',0,1,0),(71,'KM','COM','174','Comores',0,1,0),(72,'CG','COG','178','Congo',0,1,0),(73,'CD','COD','180','DR Congo (RDC)',0,1,0),(74,'CK','COK','184','Iles Cook',0,1,0),(75,'CR','CRI','188','Costa Rica',0,1,0),(76,'HR','HRV','191','Croatia',1,1,0),(77,'CU','CUB','192','Cuba',0,1,0),(78,'CY','CYP','196','Cyprus',1,1,0),(79,'CZ','CZE','203','Czech Republic',1,1,0),(80,'DK','DNK','208','Denmark',1,1,0),(81,'DJ','DJI','262','Djibouti',0,1,0),(82,'DM','DMA','212','Dominica',0,1,0),(83,'DO','DOM','214','Dominican Republic',0,1,0),(84,'EC','ECU','218','Republic of Ecuador',0,1,0),(85,'EG','EGY','818','Egypt',0,1,0),(86,'SV','SLV','222','El Salvador',0,1,0),(87,'GQ','GNQ','226','Equatorial Guinea',0,1,0),(88,'ER','ERI','232','Eritrea',0,1,0),(89,'EE','EST','233','Estonia',1,1,0),(90,'ET','ETH','231','Ethiopia',0,1,0),(91,'FK','FLK','238','Falkland Islands',0,1,0),(92,'FO','FRO','234','Faroe Islands',0,1,0),(93,'FJ','FJI','242','Fidji Islands',0,1,0),(94,'FI','FIN','246','Finland',1,1,0),(95,'GF','GUF','254','French Guiana',0,1,0),(96,'PF','PYF','258','French Polynesia',0,1,0),(97,'TF','ATF','260','Terres australes françaises',0,1,0),(98,'GM','GMB','270','Gambie',0,1,0),(99,'GE','GEO','268','Georgia',0,1,0),(100,'GH','GHA','288','Ghana',0,1,0),(101,'GI','GIB','292','Gibraltar',0,1,0),(102,'GR','GRC','300','Greece',1,1,0),(103,'GL','GRL','304','Groenland',0,1,0),(104,'GD','GRD','308','Grenade',0,1,0),(106,'GU','GUM','316','Guam',0,1,0),(107,'GT','GTM','320','Guatemala',0,1,0),(108,'GN','GIN','324','Guinea',0,1,0),(109,'GW','GNB','624','Guinea-Bissao',0,1,0),(111,'HT','HTI','332','Haiti',0,1,0),(112,'HM','HMD','334','Iles Heard et McDonald',0,1,0),(113,'VA','VAT','336','Vatican City (Saint-Siège)',0,1,0),(114,'HN','HND','340','Honduras',0,1,0),(115,'HK','HKG','344','Hong Kong',0,1,0),(116,'IS','ISL','352','Islande',0,1,0),(117,'IN','IND','356','India',0,1,0),(118,'ID','IDN','360','Indonesia',0,1,0),(119,'IR','IRN','364','Iran',0,1,0),(120,'IQ','IRQ','368','Iraq',0,1,0),(121,'IL','ISR','376','Israel',0,1,0),(122,'JM','JAM','388','Jamaica',0,1,0),(123,'JP','JPN','392','Japan (Nippon)',0,1,0),(124,'JO','JOR','400','Jordanie',0,1,0),(125,'KZ','KAZ','398','Kazakhstan',0,1,0),(126,'KE','KEN','404','Kenya',0,1,0),(127,'KI','KIR','296','Kiribati',0,1,0),(128,'KP','PRK','408','North Corea',0,1,0),(129,'KR','KOR','410','South Corea',0,1,0),(130,'KW','KWT','414','Koweït',0,1,0),(131,'KG','KGZ','417','Kirghizistan',0,1,0),(132,'LA','LAO','418','Laos',0,1,0),(133,'LV','LVA','428','Lettonie',1,1,0),(134,'LB','LBN','422','Liban',0,1,0),(135,'LS','LSO','426','Lesotho',0,1,0),(136,'LR','LBR','430','Liberia',0,1,0),(137,'LY','LBY','434','Libye',0,1,0),(138,'LI','LIE','438','Liechtenstein',0,1,0),(139,'LT','LTU','440','Lituanie',1,1,0),(140,'LU','LUX','442','Luxembourg',1,1,0),(141,'MO','MAC','446','Macao',0,1,0),(142,'MK','MKD','807','North Macedonia',0,1,0),(143,'MG','MDG','450','Madagascar',0,1,0),(144,'MW','MWI','454','Malawi',0,1,0),(145,'MY','MYS','458','Malaisie',0,1,0),(146,'MV','MDV','462','Maldives',0,1,0),(147,'ML','MLI','466','Mali',0,1,0),(148,'MT','MLT','470','Malte',1,1,0),(149,'MH','MHL','584','Iles Marshall',0,1,0),(151,'MR','MRT','478','Mauritanie',0,1,0),(152,'MU','MUS','480','Maurice',0,1,0),(153,'YT','MYT','175','Mayotte',0,1,0),(154,'MX','MEX','484','Mexique',0,1,0),(155,'FM','FSM','583','Micronésie',0,1,0),(156,'MD','MDA','498','Moldavie',0,1,0),(157,'MN','MNG','496','Mongolie',0,1,0),(158,'MS','MSR','500','Monserrat',0,1,0),(159,'MZ','MOZ','508','Mozambique',0,1,0),(160,'MM','MMR','104','Birmanie (Myanmar)',0,1,0),(161,'NA','NAM','516','Namibie',0,1,0),(162,'NR','NRU','520','Nauru',0,1,0),(163,'NP','NPL','524','Népal',0,1,0),(165,'NC','NCL','540','New Caledonia',0,1,0),(166,'NZ','NZL','554','New Zealand',0,1,0),(167,'NI','NIC','558','Nicaragua',0,1,0),(168,'NE','NER','562','Niger',0,1,0),(169,'NG','NGA','566','Nigeria',0,1,0),(170,'NU','NIU','570','Niue',0,1,0),(171,'NF','NFK','574','Norfolk Island',0,1,0),(172,'MP','MNP','580','Northern Mariana Islands',0,1,0),(173,'NO','NOR','578','Norway',0,1,0),(174,'OM','OMN','512','Oman',0,1,0),(175,'PK','PAK','586','Pakistan',0,1,0),(176,'PW','PLW','585','Palau',0,1,0),(177,'PS','PSE','275','Palestinian territories',0,1,0),(178,'PA','PAN','591','Panama',0,1,0),(179,'PG','PNG','598','Papua New Guinea',0,1,0),(180,'PY','PRY','600','Paraguay',0,1,0),(181,'PE','PER','604','Peru',0,1,0),(182,'PH','PHL','608','Philippines',0,1,0),(183,'PN','PCN','612','Pitcairn Islands',0,1,0),(184,'PL','POL','616','Pologne',1,1,0),(185,'PR','PRI','630','Puerto Rico',0,1,0),(186,'QA','QAT','634','Qatar',0,1,0),(188,'RO','ROU','642','Romania',1,1,0),(189,'RW','RWA','646','Rwanda',0,1,0),(190,'SH','SHN','654','Saint Helena',0,1,0),(191,'KN','KNA','659','Saint Kitts and Nevis',0,1,0),(192,'LC','LCA','662','Saint Lucia',0,1,0),(193,'PM','SPM','666','Saint Pierre and Miquelon',0,1,0),(194,'VC','VCT','670','Saint Vincent and the Grenadines',0,1,0),(195,'WS','WSM','882','Samoa',0,1,0),(196,'SM','SMR','674','San Marino ',0,1,0),(197,'ST','STP','678','Saint Thomas and Prince',0,1,0),(198,'RS','SRB','688','Serbia',0,1,0),(199,'SC','SYC','690','Seychelles',0,1,0),(200,'SL','SLE','694','Sierra Leone',0,1,0),(201,'SK','SVK','703','Slovakia',1,1,0),(202,'SI','SVN','705','Slovenia',1,1,0),(203,'SB','SLB','090','Solomon Islands',0,1,0),(204,'SO','SOM','706','Somalia',0,1,0),(205,'ZA','ZAF','710','South Africa',0,1,0),(206,'GS','SGS','239','South Georgia and the South Sandwich Islands ',0,1,0),(207,'LK','LKA','144','Sri Lanka',0,1,0),(208,'SD','SDN','729','Sudan',0,1,0),(209,'SR','SUR','740','Suriname',0,1,0),(210,'SJ','SJM','744','Svalbard and Jan Mayen',0,1,0),(211,'SZ','SWZ','748','Swaziland / Eswatini',0,1,0),(212,'SY','SYR','760','Syria',0,1,0),(213,'TW','TWN','158','Taiwan',0,1,0),(214,'TJ','TJK','762','Tajikistan',0,1,0),(215,'TZ','TZA','834','Tanzania',0,1,0),(216,'TH','THA','764','Thailand',0,1,0),(217,'TL','TLS','626','Timor-Leste',0,1,0),(218,'TK','TKL','772','Tokelau',0,1,0),(219,'TO','TON','776','Tonga',0,1,0),(220,'TT','TTO','780','Trinidad and Tobago',0,1,0),(221,'TR','TUR','792','Turkey',0,1,0),(222,'TM','TKM','795','Turkmenistan',0,1,0),(223,'TC','TCA','796','Turks and Caicos Islands',0,1,0),(224,'TV','TUV','798','Tuvalu',0,1,0),(225,'UG','UGA','800','Uganda',0,1,0),(226,'UA','UKR','804','Ukraine',0,1,0),(227,'AE','ARE','784','United Arab Emirates',0,1,0),(228,'UM','UMI','581','United States Minor Outlying Islands',0,1,0),(229,'UY','URY','858','Uruguay',0,1,0),(230,'UZ','UZB','860','Uzbekistan',0,1,0),(231,'VU','VUT','548','Vanuatu',0,1,0),(232,'VE','VEN','862','Venezuela',0,1,0),(233,'VN','VNM','704','Vietnam',0,1,0),(234,'VG','VGB','092','British Virgin Islands',0,1,0),(235,'VI','VIR','850','Virgin Islands of the United States',0,1,0),(236,'WF','WLF','876','Wallis and Futuna',0,1,0),(237,'EH','ESH','732','Western Sahara',0,1,0),(238,'YE','YEM','887','Yemen',0,1,0),(239,'ZM','ZMB','894','Zambia',0,1,0),(240,'ZW','ZWE','716','Zimbabwe',0,1,0),(241,'GG','GGY','831','Guernsey',0,1,0),(242,'IM','IMN','833','Isle of Man',0,1,0),(243,'JE','JEY','832','Jersey',0,1,0),(244,'ME','MNE','499','Montenegro',0,1,0),(245,'BL','BLM','652','Saint-Barthélemy',0,1,0),(246,'MF','MAF','663','Saint-Martin',0,1,0),(247,'XK','XKX',NULL,'Kosovo',0,1,0),(300,'CW','CUW','531','Curaçao',0,1,0),(301,'SX','SXM','534','Sint Maarten',0,1,0);
/*!40000 ALTER TABLE `llx_c_country` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-09-13 20:12:11
