-- Initialisation des pays et regions disponibles
INSERT INTO pays (id, continent_id, nom, date_creation, indicatif, code) VALUES (1, 1, 'Sénégal', NOW(), '+221', 'sn');
INSERT INTO pays (id, continent_id, nom, date_creation, indicatif, code) VALUES (3, 1, 'Burkina Faso', NOW(), '', 'bf');
INSERT INTO pays (id, continent_id, nom, date_creation, indicatif, code) VALUES (2, 1, 'Mali', NOW(), '', 'ml');
INSERT INTO pays (id, continent_id, nom, date_creation, indicatif, code) VALUES (4, 1, 'Niger', NOW(), '', 'ne');
INSERT INTO pays (id, continent_id, nom, date_creation, indicatif, code) VALUES (6, 1, 'Tchad', NOW(), '', 'td');
INSERT INTO pays (id, continent_id, nom, date_creation, indicatif, code) VALUES (5, 1, 'Mauritanie', NOW(), '', 'mr');


INSERT INTO region(pays_id, nom, date_creation) VALUES (1, "Dakar", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (1, "Diourbel", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (1, "Fatick", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (1, "Kaffrine", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (1, "Kaolack", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (1, "Kédougou", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (1, "Kolda", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (1, "Louga", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (1, "Matam", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (1, "Saint", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (1, "Sédhiou", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (1, "Tambacounda", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (1, "Thiès", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (1, "Ziguinchor", NOW());


INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Bamako", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Sikasso", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Ségou", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Gao", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Mopti", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Koutiala", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Kayes", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Kati", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Markala", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Kita", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "San", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Bougouni", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Timbuktu", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Djenné", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Banamba", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Bafoulabé", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Koulikoro", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Nara", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Kangaba", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Nioro", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Ménaka", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Goundam", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Tessalit", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Yélimané", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Kidal", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Bandiagara", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Ténenkou", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Douentza", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Niono", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Bla", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Diré", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Bankass", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Kadiolo", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Ansongo", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Dioila", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Barouéli", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Yorosso", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Tominian", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Koro", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Kolokani", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Yanfolila", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Kolondiéba", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Kéniéba", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Youwarou", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Niafunké", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Diéma", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Bourem", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Abeïbara", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Ké-Macina", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Gourma Rharous", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (2, "Ti-n-Essako", NOW());


INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Niamey", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Zinder", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Maradi", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Agadez", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Tahoua", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Arlit", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Gaya", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Dosso", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Diffa", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Ayorou", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Madaoua", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Tillabéri", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Nguigmi", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Gouré", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Magaria", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Kantché", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Bouza", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Aguié", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Madarounfa", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Mirriah", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Tessaoua", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Keïta", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Illéla", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Mayahi", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Loga", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Dakoro", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Téra", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Kollo", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Dogondoutchi", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Filingué", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Say", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Abalak", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Ouallam", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Tanout", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Tchintabaraden", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Tchirozérine", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Bilma", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Birnin Gaouré", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Guidan Roumdji", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Birnin Konni", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (4, "Maïné Soroa", NOW());


INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Ouagadougou", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Koudougou", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Ouahigouya", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Banfora", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Kaya", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Dédougou", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Tenkodogo", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Dori", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Réo", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Koupéla", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Kombissiri", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Nouna", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Gaoua", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Léo", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Diapaga", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Zorgo", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Yako", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Djibo", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Pô", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Tougan", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Boulsa", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Manga", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Diébougou", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Ziniaré", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Salanso", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Bogandé", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Sapouy", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Sebba", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Gaoua", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Komsilga", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Loumbila", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Saaba", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Kongoussi", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Kokologo", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Gourcy", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Boussouma", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Ouargaye", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Boussé", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Laye", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Zitenga", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Absouya", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Siglé", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Orodara", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Toéghin", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Sourgoubila", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Dapélogo", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Korsimoro", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Houndé", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Dano", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Niou", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Pabré", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Koubri", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Mané", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Toma", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Bingo", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Saponé", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Nagréongo", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Kayao", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Sindou", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Gaongo", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Titao", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Aribinda", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Oursi", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Batié", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Boromo", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Gayéri", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Déou", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Pama", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Tin-Akoff", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Bobo-Dioulasso", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Ourgou-Manéga", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Komki-Ipala", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Tanghin-Dassouri", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Gorom-Gorom", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (3, "Fada Ngourma", NOW());


INSERT INTO region(pays_id, nom, date_creation) VALUES (5, "Nouakchott", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (5, "Néma", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (5, "Nouadhibou", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (5, "Kiffa", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (5, "Zouerate", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (5, "Rosso", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (5, "Atar", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (5, "Tidjikja", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (5, "Boutilimit", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (5, "Bogué", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (5, "Aleg", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (5, "Fdérik", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (5, "Aioun", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (5, "Sélibaby", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (5, "Akjoujt", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (5, "Arafat", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (5, "Kaédi", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (5, "Tevragh Zeina", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (5, "Dar Naim", NOW());

INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Sarh", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Moundou", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Kelo", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Yao", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Abéché", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Fianga", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Koumra", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Doba", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Bongor", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Mongo", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Ati", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Laï", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Mao", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Moussoro", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Faya", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Bol", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Biltine", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Massenya", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Fada", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Pala", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Massakory", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Amdjarass", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Bardaï", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Pala Oua", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Goz-Beida", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Oum Hadjer", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "N’Djamena", NOW());
INSERT INTO region(pays_id, nom, date_creation) VALUES (6, "Am-Timan", NOW());