Salut @Philazerty,
Oui, dans la v12.
Voici le script de migration (présent dans v11 vers v12) :
– Migration to the new regions (France)
UPDATE llx_c_regions set nom = ‹ Centre-Val de Loire › WHERE fk_pays = 1 AND code_region = 24;
insert into llx_c_regions (fk_pays,code_region,cheflieu,tncc,nom) values (1, 27, ‹ 21231 ›, 0, ‹ Bourgogne-Franche-Comté ›);
insert into llx_c_regions (fk_pays,code_region,cheflieu,tncc,nom) values (1, 28, ‹ 76540 ›, 0, ‹ Normandie ›);
insert into llx_c_regions (fk_pays,code_region,cheflieu,tncc,nom) values (1, 32, ‹ 59350 ›, 4, ‹ Hauts-de-France ›);
insert into llx_c_regions (fk_pays,code_region,cheflieu,tncc,nom) values (1, 44, ‹ 67482 ›, 2, ‹ Grand Est ›);
insert into llx_c_regions (fk_pays,code_region,cheflieu,tncc,nom) values (1, 75, ‹ 33063 ›, 0, ‹ Nouvelle-Aquitaine ›);
insert into llx_c_regions (fk_pays,code_region,cheflieu,tncc,nom) values (1, 76, ‹ 31355 ›, 1, ‹ Occitanie ›);
insert into llx_c_regions (fk_pays,code_region,cheflieu,tncc,nom) values (1, 84, ‹ 69123 ›, 1, ‹ Auvergne-Rhône-Alpes ›);
UPDATE llx_c_departements set fk_region = 27 WHERE fk_region = 26 OR fk_region = 43;
UPDATE llx_c_departements set fk_region = 28 WHERE fk_region = 25 OR fk_region = 23;
UPDATE llx_c_departements set fk_region = 32 WHERE fk_region = 22 OR fk_region = 31;
UPDATE llx_c_departements set fk_region = 44 WHERE fk_region = 21 OR fk_region = 41 OR fk_region = 42;
UPDATE llx_c_departements set fk_region = 75 WHERE fk_region = 54 OR fk_region = 74 OR fk_region = 72;
UPDATE llx_c_departements set fk_region = 76 WHERE fk_region = 73 OR fk_region = 91;
UPDATE llx_c_departements set fk_region = 84 WHERE fk_region = 82 OR fk_region = 83;
DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 21;
DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 22;
DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 23;
DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 25;
DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 26;
DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 31;
DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 41;
DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 42;
DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 43;
DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 54;
DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 72;
DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 73;
DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 74;
DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 82;
DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 83;
DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 91;
Pour les constantes, deux options :
- SOCIETE_DISABLE_STATE à supprimer pour afficher les régions.
- MAIN_SHOW_REGION_IN_STATE_SELECT (MAIN_SHOW_REGION_IN_STATE avant v12)
Bonne journée,