Re: [Dolibarr-dev] Fix of 3-letter ISO code in table llx_c_pays

[Oli Sennhauser]

Hi Laurent,

I got your point an I a agree with you.

Possibly it is better you run the command yourself again because I have 
not 100.0% sure clean data:

mysqldump -u root --skip-extended-insert --skip-extended-insert 
dolibarr  llx_c_pays | grep INSERT

INSERT INTO `llx_c_pays` VALUES (0,'',NULL,'-',0);
INSERT INTO `llx_c_pays` VALUES (1,'FR','FRA','France',1);
INSERT INTO `llx_c_pays` VALUES (2,'BE','BEL','Belgium',0);
INSERT INTO `llx_c_pays` VALUES (3,'IT','ITA','Italy',1);
INSERT INTO `llx_c_pays` VALUES (4,'ES','ESP','Spain',1);
INSERT INTO `llx_c_pays` VALUES (5,'DE','DEU','Germany',1);
INSERT INTO `llx_c_pays` VALUES (6,'CH','CHE','Switzerland',1);
INSERT INTO `llx_c_pays` VALUES (7,'GB','GBR','United Kingdom',1);
INSERT INTO `llx_c_pays` VALUES (8,'IE','IRL','Irland',0);
INSERT INTO `llx_c_pays` VALUES (9,'CN','CHN','China',1);
INSERT INTO `llx_c_pays` VALUES (10,'TN','TUN','Tunisia',0);
INSERT INTO `llx_c_pays` VALUES (11,'US','USA','United States',1);
INSERT INTO `llx_c_pays` VALUES (12,'MA','MAR','Maroc',0);
INSERT INTO `llx_c_pays` VALUES (13,'DZ','DZA','Algeria',0);
INSERT INTO `llx_c_pays` VALUES (14,'CA','CAN','Canada',0);
INSERT INTO `llx_c_pays` VALUES (15,'TG','TGO','Togo',0);
INSERT INTO `llx_c_pays` VALUES (16,'GA','GAB','Gabon',0);
INSERT INTO `llx_c_pays` VALUES (17,'NL','NLD','Nerderland',1);
INSERT INTO `llx_c_pays` VALUES (18,'HU','HUN','Hongrie',0);
INSERT INTO `llx_c_pays` VALUES (19,'RU','RUS','Russia',1);
INSERT INTO `llx_c_pays` VALUES (20,'SE','SWE','Sweden',0);
INSERT INTO `llx_c_pays` VALUES (21,'CI','CIV','Côte d\'Ivoire',0);
INSERT INTO `llx_c_pays` VALUES (22,'SN','SEN','Senegal',0);
INSERT INTO `llx_c_pays` VALUES (23,'AR','ARG','Argentine',0);
INSERT INTO `llx_c_pays` VALUES (24,'CM','CMR','Cameroun',0);
INSERT INTO `llx_c_pays` VALUES (25,'PT','PRT','Portugal',0);
INSERT INTO `llx_c_pays` VALUES (26,'SA','SAU','Saudi Arabia',0);
INSERT INTO `llx_c_pays` VALUES (27,'MC','MCO','Monaco',0);
INSERT INTO `llx_c_pays` VALUES (28,'AU','AUS','Australia',0);
INSERT INTO `llx_c_pays` VALUES (29,'SG','SGP','Singapour',0);
INSERT INTO `llx_c_pays` VALUES (30,'AF','AFG','Afghanistan',0);
INSERT INTO `llx_c_pays` VALUES (31,'AX','ALA','Iles Aland',0);
INSERT INTO `llx_c_pays` VALUES (32,'AL','ALB','Albanie',0);
INSERT INTO `llx_c_pays` VALUES (33,'AS','ASM','Samoa américaines',0);
INSERT INTO `llx_c_pays` VALUES (34,'AD','AND','Andorre',0);
INSERT INTO `llx_c_pays` VALUES (35,'AO','AGO','Angola',0);
INSERT INTO `llx_c_pays` VALUES (36,'AI','AIA','Anguilla',0);
INSERT INTO `llx_c_pays` VALUES (37,'AQ','ATA','Antarctique',0);
INSERT INTO `llx_c_pays` VALUES (38,'AG','ATG','Antigua-et-Barbuda',0);
INSERT INTO `llx_c_pays` VALUES (39,'AM','ARM','Arménie',0);
INSERT INTO `llx_c_pays` VALUES (40,'AW','ABW','Aruba',0);
INSERT INTO `llx_c_pays` VALUES (41,'AT','AUT','Autriche',1);
INSERT INTO `llx_c_pays` VALUES (42,'AZ','AZE','Azerbaïdjan',0);
INSERT INTO `llx_c_pays` VALUES (43,'BS','BHS','Bahamas',0);
INSERT INTO `llx_c_pays` VALUES (44,'BH','BHR','Bahreïn',0);
INSERT INTO `llx_c_pays` VALUES (45,'BD','BGD','Bangladesh',0);
INSERT INTO `llx_c_pays` VALUES (46,'BB','BRB','Barbade',0);
INSERT INTO `llx_c_pays` VALUES (47,'BY','BLR','Biélorussie',0);
INSERT INTO `llx_c_pays` VALUES (48,'BZ','BLZ','Belize',0);
INSERT INTO `llx_c_pays` VALUES (49,'BJ','BEN','Bénin',0);
INSERT INTO `llx_c_pays` VALUES (50,'BM','BMU','Bermudes',0);
INSERT INTO `llx_c_pays` VALUES (51,'BT','BTN','Bhoutan',0);
INSERT INTO `llx_c_pays` VALUES (52,'BO','BOL','Bolivie',0);
INSERT INTO `llx_c_pays` VALUES (53,'BA','BIH','Bosnie-Herzégovine',0);
INSERT INTO `llx_c_pays` VALUES (54,'BW','BWA','Botswana',0);
INSERT INTO `llx_c_pays` VALUES (55,'BV','BVT','Ile Bouvet',0);
INSERT INTO `llx_c_pays` VALUES (56,'BR','BRA','Brazil',0);
INSERT INTO `llx_c_pays` VALUES (57,'IO','IOT','Territoire britannique 
de l\'Océan Indien',0);
INSERT INTO `llx_c_pays` VALUES (58,'BN','BRN','Brunei',0);
INSERT INTO `llx_c_pays` VALUES (59,'BG','BGR','Bulgarie',0);
INSERT INTO `llx_c_pays` VALUES (60,'BF','BFA','Burkina Faso',0);
INSERT INTO `llx_c_pays` VALUES (61,'BI','BDI','Burundi',0);
INSERT INTO `llx_c_pays` VALUES (62,'KH','KHM','Cambodge',0);
INSERT INTO `llx_c_pays` VALUES (63,'CV','CPV','Cap-Vert',0);
INSERT INTO `llx_c_pays` VALUES (64,'KY','CYM','Iles Cayman',0);
INSERT INTO `llx_c_pays` VALUES (65,'CF','CAF','République 
centrafricaine',0);
INSERT INTO `llx_c_pays` VALUES (66,'TD','TCD','Tchad',0);
INSERT INTO `llx_c_pays` VALUES (67,'CL','CHL','Chili',0);
INSERT INTO `llx_c_pays` VALUES (68,'CX','CXR','Ile Christmas',0);
INSERT INTO `llx_c_pays` VALUES (69,'CC','CCK','Iles des Cocos 
(Keeling)',0);
INSERT INTO `llx_c_pays` VALUES (70,'CO','COL','Colombie',0);
INSERT INTO `llx_c_pays` VALUES (71,'KM','COM','Comores',0);
INSERT INTO `llx_c_pays` VALUES (72,'CG','COG','Congo',0);
INSERT INTO `llx_c_pays` VALUES (73,'CD','COD','République démocratique 
du Congo',0);
INSERT INTO `llx_c_pays` VALUES (74,'CK','COK','Iles Cook',0);
INSERT INTO `llx_c_pays` VALUES (75,'CR','CRI','Costa Rica',0);
INSERT INTO `llx_c_pays` VALUES (76,'HR','HRV','Croatie',0);
INSERT INTO `llx_c_pays` VALUES (77,'CU','CUB','Cuba',0);
INSERT INTO `llx_c_pays` VALUES (78,'CY','CYP','Chypre',0);
INSERT INTO `llx_c_pays` VALUES (79,'CZ','CZE','République Tchèque',0);
INSERT INTO `llx_c_pays` VALUES (80,'DK','DNK','Danemark',0);
INSERT INTO `llx_c_pays` VALUES (81,'DJ','DJI','Djibouti',0);
INSERT INTO `llx_c_pays` VALUES (82,'DM','DMA','Dominique',0);
INSERT INTO `llx_c_pays` VALUES (83,'DO','DOM','République Dominicaine',0);
INSERT INTO `llx_c_pays` VALUES (84,'EC','ECU','Equateur',0);
INSERT INTO `llx_c_pays` VALUES (85,'EG','EGY','Egypte',0);
INSERT INTO `llx_c_pays` VALUES (86,'SV','SLV','Salvador',0);
INSERT INTO `llx_c_pays` VALUES (87,'GQ','GNQ','Guinée Equatoriale',0);
INSERT INTO `llx_c_pays` VALUES (88,'ER','ERI','Erythrée',0);
INSERT INTO `llx_c_pays` VALUES (89,'EE','EST','Estonia',0);
INSERT INTO `llx_c_pays` VALUES (90,'ET','ETH','Ethiopie',0);
INSERT INTO `llx_c_pays` VALUES (91,'FK','FLK','Iles Falkland',0);
INSERT INTO `llx_c_pays` VALUES (92,'FO','FRO','Iles Féroé',0);
INSERT INTO `llx_c_pays` VALUES (93,'FJ','FJI','Iles Fidji',0);
INSERT INTO `llx_c_pays` VALUES (94,'FI','FIN','Finlande',0);
INSERT INTO `llx_c_pays` VALUES (95,'GF','GUF','Guyane française',0);
INSERT INTO `llx_c_pays` VALUES (96,'PF','PYF','Polynésie française',0);
INSERT INTO `llx_c_pays` VALUES (97,'TF','ATF','Terres australes 
françaises',0);
INSERT INTO `llx_c_pays` VALUES (98,'GM','GMB','Gambie',0);
INSERT INTO `llx_c_pays` VALUES (99,'GE','GEO','Georgia',0);
INSERT INTO `llx_c_pays` VALUES (100,'GH','GHA','Ghana',0);
INSERT INTO `llx_c_pays` VALUES (101,'GI','GIB','Gibraltar',0);
INSERT INTO `llx_c_pays` VALUES (102,'GR','GRC','Greece',0);
INSERT INTO `llx_c_pays` VALUES (103,'GL','GRL','Groenland',0);
INSERT INTO `llx_c_pays` VALUES (104,'GD','GRD','Grenade',0);
INSERT INTO `llx_c_pays` VALUES (106,'GU','GUM','Guam',0);
INSERT INTO `llx_c_pays` VALUES (107,'GT','GTM','Guatemala',0);
INSERT INTO `llx_c_pays` VALUES (108,'GN','GIN','Guinea',0);
INSERT INTO `llx_c_pays` VALUES (109,'GW','GNB','Guinea-Bissao',0);
INSERT INTO `llx_c_pays` VALUES (111,'HT','HTI','Haiti',0);
INSERT INTO `llx_c_pays` VALUES (112,'HM','HMD','Iles Heard et McDonald',0);
INSERT INTO `llx_c_pays` VALUES (113,'VA','VAT','Saint-Siège (Vatican)',0);
INSERT INTO `llx_c_pays` VALUES (114,'HN','HND','Honduras',0);
INSERT INTO `llx_c_pays` VALUES (115,'HK','HKG','Hong Kong',0);
INSERT INTO `llx_c_pays` VALUES (116,'IS','ISL','Islande',0);
INSERT INTO `llx_c_pays` VALUES (117,'IN','IND','India',0);
INSERT INTO `llx_c_pays` VALUES (118,'ID','IDN','Indonésie',0);
INSERT INTO `llx_c_pays` VALUES (119,'IR','IRN','Iran',0);
INSERT INTO `llx_c_pays` VALUES (120,'IQ','IRQ','Iraq',0);
INSERT INTO `llx_c_pays` VALUES (121,'IL','ISR','Israel',0);
INSERT INTO `llx_c_pays` VALUES (122,'JM','JAM','Jamaïque',0);
INSERT INTO `llx_c_pays` VALUES (123,'JP','JPN','Japon',1);
INSERT INTO `llx_c_pays` VALUES (124,'JO','JOR','Jordanie',0);
INSERT INTO `llx_c_pays` VALUES (125,'KZ','KAZ','Kazakhstan',0);
INSERT INTO `llx_c_pays` VALUES (126,'KE','KEN','Kenya',0);
INSERT INTO `llx_c_pays` VALUES (127,'KI','KIR','Kiribati',0);
INSERT INTO `llx_c_pays` VALUES (128,'KP','PRK','North Corea',0);
INSERT INTO `llx_c_pays` VALUES (129,'KR','KOR','South Corea',0);
INSERT INTO `llx_c_pays` VALUES (130,'KW','KWT','Koweït',0);
INSERT INTO `llx_c_pays` VALUES (131,'KG','KGZ','Kirghizistan',0);
INSERT INTO `llx_c_pays` VALUES (132,'LA','LAO','Laos',0);
INSERT INTO `llx_c_pays` VALUES (133,'LV','LVA','Lettonie',0);
INSERT INTO `llx_c_pays` VALUES (134,'LB','LBN','Liban',0);
INSERT INTO `llx_c_pays` VALUES (135,'LS','LSO','Lesotho',0);
INSERT INTO `llx_c_pays` VALUES (136,'LR','LBR','Liberia',0);
INSERT INTO `llx_c_pays` VALUES (137,'LY','LBY','Libye',0);
INSERT INTO `llx_c_pays` VALUES (138,'LI','LIE','Liechtenstein',1);
INSERT INTO `llx_c_pays` VALUES (139,'LT','LTU','Lituanie',0);
INSERT INTO `llx_c_pays` VALUES (140,'LU','LUX','Luxembourg',0);
INSERT INTO `llx_c_pays` VALUES (141,'MO','MAC','Macao',0);
INSERT INTO `llx_c_pays` VALUES (142,'MK','MKD','ex-République 
yougoslave de Macédoine',0);
INSERT INTO `llx_c_pays` VALUES (143,'MG','MDG','Madagascar',0);
INSERT INTO `llx_c_pays` VALUES (144,'MW','MWI','Malawi',0);
INSERT INTO `llx_c_pays` VALUES (145,'MY','MYS','Malaisie',0);
INSERT INTO `llx_c_pays` VALUES (146,'MV','MDV','Maldives',0);
INSERT INTO `llx_c_pays` VALUES (147,'ML','MLI','Mali',0);
INSERT INTO `llx_c_pays` VALUES (148,'MT','MLT','Malte',0);
INSERT INTO `llx_c_pays` VALUES (149,'MH','MHL','Iles Marshall',0);
INSERT INTO `llx_c_pays` VALUES (151,'MR','MRT','Mauritanie',0);
INSERT INTO `llx_c_pays` VALUES (152,'MU','MUS','Maurice',0);
INSERT INTO `llx_c_pays` VALUES (153,'YT','MYT','Mayotte',0);
INSERT INTO `llx_c_pays` VALUES (154,'MX','MEX','Mexique',0);
INSERT INTO `llx_c_pays` VALUES (155,'FM','FSM','Micronésie',0);
INSERT INTO `llx_c_pays` VALUES (156,'MD','MDA','Moldavie',0);
INSERT INTO `llx_c_pays` VALUES (157,'MN','MNG','Mongolie',0);
INSERT INTO `llx_c_pays` VALUES (158,'MS','MSR','Monserrat',0);
INSERT INTO `llx_c_pays` VALUES (159,'MZ','MOZ','Mozambique',0);
INSERT INTO `llx_c_pays` VALUES (160,'MM','MMR','Birmanie (Myanmar)',0);
INSERT INTO `llx_c_pays` VALUES (161,'NA','NAM','Namibie',0);
INSERT INTO `llx_c_pays` VALUES (162,'NR','NRU','Nauru',0);
INSERT INTO `llx_c_pays` VALUES (163,'NP','NPL','Népal',0);
INSERT INTO `llx_c_pays` VALUES (164,'AN',NULL,'Antilles néerlandaises',0);
INSERT INTO `llx_c_pays` VALUES (165,'NC','NCL','Nouvelle-Calédonie',0);
INSERT INTO `llx_c_pays` VALUES (166,'NZ','NZL','Nouvelle-Zélande',0);
INSERT INTO `llx_c_pays` VALUES (167,'NI','NIC','Nicaragua',0);
INSERT INTO `llx_c_pays` VALUES (168,'NE','NER','Niger',0);
INSERT INTO `llx_c_pays` VALUES (169,'NG','NGA','Nigeria',0);
INSERT INTO `llx_c_pays` VALUES (170,'NU','NIU','Nioué',0);
INSERT INTO `llx_c_pays` VALUES (171,'NF','NFK','Ile Norfolk',0);
INSERT INTO `llx_c_pays` VALUES (172,'MP','MNP','Mariannes du Nord',0);
INSERT INTO `llx_c_pays` VALUES (173,'NO','NOR','Norvège',0);
INSERT INTO `llx_c_pays` VALUES (174,'OM','OMN','Oman',0);
INSERT INTO `llx_c_pays` VALUES (175,'PK','PAK','Pakistan',0);
INSERT INTO `llx_c_pays` VALUES (176,'PW','PLW','Palaos',0);
INSERT INTO `llx_c_pays` VALUES (177,'PS','PSE','Territoire Palestinien 
Occupé',0);
INSERT INTO `llx_c_pays` VALUES (178,'PA','PAN','Panama',0);
INSERT INTO `llx_c_pays` VALUES 
(179,'PG','PNG','Papouasie-Nouvelle-Guinée',0);
INSERT INTO `llx_c_pays` VALUES (180,'PY','PRY','Paraguay',0);
INSERT INTO `llx_c_pays` VALUES (181,'PE','PER','Peru',0);
INSERT INTO `llx_c_pays` VALUES (182,'PH','PHL','Philippines',0);
INSERT INTO `llx_c_pays` VALUES (183,'PN','PCN','Iles Pitcairn',0);
INSERT INTO `llx_c_pays` VALUES (184,'PL','POL','Pologne',0);
INSERT INTO `llx_c_pays` VALUES (185,'PR','PRI','Porto Rico',0);
INSERT INTO `llx_c_pays` VALUES (186,'QA','QAT','Qatar',0);
INSERT INTO `llx_c_pays` VALUES (188,'RO','ROU','Roumanie',0);
INSERT INTO `llx_c_pays` VALUES (189,'RW','RWA','Rwanda',0);
INSERT INTO `llx_c_pays` VALUES (190,'SH','SHN','Sainte-Hélène',0);
INSERT INTO `llx_c_pays` VALUES 
(191,'KN','KNA','Saint-Christophe-et-Niévès',0);
INSERT INTO `llx_c_pays` VALUES (192,'LC','LCA','Sainte-Lucie',0);
INSERT INTO `llx_c_pays` VALUES 
(193,'PM','SPM','Saint-Pierre-et-Miquelon',0);
INSERT INTO `llx_c_pays` VALUES 
(194,'VC','VCT','Saint-Vincent-et-les-Grenadines',0);
INSERT INTO `llx_c_pays` VALUES (195,'WS','WSM','Samoa',0);
INSERT INTO `llx_c_pays` VALUES (196,'SM','SMR','Saint-Marin',0);
INSERT INTO `llx_c_pays` VALUES (197,'ST','STP','Sao Tomé-et-Principe',0);
INSERT INTO `llx_c_pays` VALUES (198,'RS','SRB','Serbie',0);
INSERT INTO `llx_c_pays` VALUES (199,'SC','SYC','Seychelles',0);
INSERT INTO `llx_c_pays` VALUES (200,'SL','SLE','Sierra Leone',0);
INSERT INTO `llx_c_pays` VALUES (201,'SK','SVK','Slovaquie',0);
INSERT INTO `llx_c_pays` VALUES (202,'SI','SVN','Slovénie',0);
INSERT INTO `llx_c_pays` VALUES (203,'SB','SLB','Iles Salomon',0);
INSERT INTO `llx_c_pays` VALUES (204,'SO','SOM','Somalie',0);
INSERT INTO `llx_c_pays` VALUES (205,'ZA','ZAF','Afrique du Sud',0);
INSERT INTO `llx_c_pays` VALUES (206,'GS','SGS','Iles Géorgie du Sud et 
Sandwich du Sud',0);
INSERT INTO `llx_c_pays` VALUES (207,'LK','LKA','Sri Lanka',0);
INSERT INTO `llx_c_pays` VALUES (208,'SD','SDN','Soudan',0);
INSERT INTO `llx_c_pays` VALUES (209,'SR','SUR','Suriname',0);
INSERT INTO `llx_c_pays` VALUES (210,'SJ','SJM','Iles Svalbard et Jan 
Mayen',0);
INSERT INTO `llx_c_pays` VALUES (211,'SZ','SWZ','Swaziland',0);
INSERT INTO `llx_c_pays` VALUES (212,'SY','SYR','Syrie',0);
INSERT INTO `llx_c_pays` VALUES (213,'TW','TWN','Taïwan',0);
INSERT INTO `llx_c_pays` VALUES (214,'TJ','TJK','Tadjikistan',0);
INSERT INTO `llx_c_pays` VALUES (215,'TZ','TZA','Tanzanie',0);
INSERT INTO `llx_c_pays` VALUES (216,'TH','THA','Thaïlande',0);
INSERT INTO `llx_c_pays` VALUES (217,'TL','TLS','Timor Oriental',0);
INSERT INTO `llx_c_pays` VALUES (218,'TK','TKL','Tokélaou',0);
INSERT INTO `llx_c_pays` VALUES (219,'TO','TON','Tonga',0);
INSERT INTO `llx_c_pays` VALUES (220,'TT','TTO','Trinité-et-Tobago',0);
INSERT INTO `llx_c_pays` VALUES (221,'TR','TUR','Turquie',0);
INSERT INTO `llx_c_pays` VALUES (222,'TM','TKM','Turkménistan',0);
INSERT INTO `llx_c_pays` VALUES (223,'TC','TCA','Iles Turks-et-Caicos',0);
INSERT INTO `llx_c_pays` VALUES (224,'TV','TUV','Tuvalu',0);
INSERT INTO `llx_c_pays` VALUES (225,'UG','UGA','Ouganda',0);
INSERT INTO `llx_c_pays` VALUES (226,'UA','UKR','Ukraine',0);
INSERT INTO `llx_c_pays` VALUES (227,'AE','ARE','Émirats arabes unis',0);
INSERT INTO `llx_c_pays` VALUES (228,'UM','UMI','Iles mineures éloignées 
des États-Unis',0);
INSERT INTO `llx_c_pays` VALUES (229,'UY','URY','Uruguay',0);
INSERT INTO `llx_c_pays` VALUES (230,'UZ','UZB','Ouzbékistan',0);
INSERT INTO `llx_c_pays` VALUES (231,'VU','VUT','Vanuatu',0);
INSERT INTO `llx_c_pays` VALUES (232,'VE','VEN','Vénézuela',0);
INSERT INTO `llx_c_pays` VALUES (233,'VN','VNM','Viêt Nam',0);
INSERT INTO `llx_c_pays` VALUES (234,'VG','VGB','Iles Vierges 
britanniques',0);
INSERT INTO `llx_c_pays` VALUES (235,'VI','VIR','Iles Vierges 
américaines',0);
INSERT INTO `llx_c_pays` VALUES (236,'WF','WLF','Wallis-et-Futuna',0);
INSERT INTO `llx_c_pays` VALUES (237,'EH','ESH','Sahara occidental',0);
INSERT INTO `llx_c_pays` VALUES (238,'YE','YEM','Yémen',0);
INSERT INTO `llx_c_pays` VALUES (239,'ZM','ZMB','Zambie',0);
INSERT INTO `llx_c_pays` VALUES (240,'ZW','ZWE','Zimbabwe',0);
INSERT INTO `llx_c_pays` VALUES (241,'GG','GGY','Guernesey',0);
INSERT INTO `llx_c_pays` VALUES (242,'IM','IMN','Ile de Man',0);
INSERT INTO `llx_c_pays` VALUES (243,'JE','JEY','Jersey',0);
INSERT INTO `llx_c_pays` VALUES (244,'ME','MNE','Monténégro',0);
INSERT INTO `llx_c_pays` VALUES (245,'BL','BLM','Saint-Barthélemy',0);
INSERT INTO `llx_c_pays` VALUES (246,'MF','MAF','Saint-Martin',0);

--

FromDual - Independent and Professional MySQL Services.

Oli Sennhauser                    CEO / Senior Consultant
Phone: +41 44 940 24 82           Mobile: +41 79 830 09 33
address@hidden       http://www.fromdual.com
Skype: oli_sennhauser             Twitter: fromdual