-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1:3306
-- Généré le : mer. 06 sep. 2023 à 15:24
-- Version du serveur :  8.0.21
-- Version de PHP : 7.3.21

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Base de données : `econseil`
--

-- --------------------------------------------------------

--
-- Structure de la table `commune`
--

DROP TABLE IF EXISTS `commune`;
CREATE TABLE IF NOT EXISTS `commune` (
  `id_commune` int NOT NULL AUTO_INCREMENT,
  `com_id_dept` int DEFAULT '0',
  `nom_commune` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '',
  `com_id_region` int DEFAULT NULL,
  PRIMARY KEY (`id_commune`)
) ENGINE=InnoDB AUTO_INCREMENT=202 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `commune`
--

INSERT INTO `commune` (`id_commune`, `com_id_dept`, `nom_commune`, `com_id_region`) VALUES
(1, 11, 'FRESCO', NULL),
(2, 11, 'SASSANDRA', NULL),
(3, 24, 'MEAGUI', NULL),
(4, 24, 'BUYO', NULL),
(5, 24, 'GUEYO', NULL),
(6, 24, 'SOUBRE', NULL),
(7, 24, 'GRAND ZATTRY', NULL),
(8, 24, 'MAYO', NULL),
(9, 27, 'SAN PEDRO', NULL),
(10, 27, 'GRAND BEREBY', NULL),
(11, 2, 'TOUBA', NULL),
(12, 27, 'GRABO', NULL),
(13, 19, 'ABENGOUROU', NULL),
(14, 19, 'NIABLE', NULL),
(15, 19, 'AGNIBILEKRO', NULL),
(16, 19, 'BETTIE', NULL),
(17, 28, 'ABOISSO', NULL),
(18, 28, 'AYAME', NULL),
(19, 28, 'MAFERE', NULL),
(20, 28, 'ADIAKE', NULL),
(21, 28, 'ASSINIE MAFIA', NULL),
(22, 28, 'GRAND BASSAM', NULL),
(23, 28, 'BONOUA', NULL),
(24, 28, 'TIAPOUM', NULL),
(25, 9, 'GOULIA', NULL),
(26, 9, 'KANIASSO', NULL),
(27, 9, 'MINIGNAN', NULL),
(28, 9, 'TIENKO', NULL),
(29, 20, 'GBELEBAN', NULL),
(30, 20, 'SEYDOUGOU', NULL),
(31, 20, 'MADINANI', NULL),
(32, 20, 'BAKO', NULL),
(33, 20, 'DIOULATIEDOUGOU', NULL),
(34, 20, 'ODIENNE', NULL),
(35, 20, 'TIEME', NULL),
(36, 20, 'SAMATIGUILA', NULL),
(37, 20, 'SEGUELON', NULL),
(38, 12, 'GAGNOA', NULL),
(39, 12, 'GUIBEROUA', NULL),
(40, 12, 'OURAGAHIO', NULL),
(41, 12, 'OUME', NULL),
(42, 12, 'DIEGONEFLA', NULL),
(43, 8, 'DIVO', NULL),
(44, 8, 'HIRE', NULL),
(45, 8, 'GUITRY', NULL),
(46, 8, 'LAKOTA', NULL),
(47, 8, 'ZIKISSO', NULL),
(48, 4, 'DIDIEVI', NULL),
(49, 4, 'TIE N?DIEKRO', NULL),
(50, 4, 'DJEKANOU', NULL),
(51, 4, 'TIEBISSOU', NULL),
(52, 4, 'KOKOUMBO', NULL),
(53, 4, 'TOUMODI', NULL),
(54, 18, 'DAOUKRO', NULL),
(55, 18, 'ETTROKRO', NULL),
(56, 18, 'OUELLE', NULL),
(57, 18, 'M?BAHIAKRO', NULL),
(58, 18, 'PRIKRO', NULL),
(59, 23, 'ARRAH', NULL),
(60, 23, 'BONGOUANOU', NULL),
(61, 23, 'M?BATTO', NULL),
(62, 23, 'ANOUMABA', NULL),
(63, 23, 'TIEMELEKRO', NULL),
(64, 25, 'BOCANDA', NULL),
(65, 25, 'DIMBOKRO', NULL),
(66, 1, 'AGBOVILLE', NULL),
(67, 1, 'AZAGUIE', NULL),
(68, 1, 'RUBINO', NULL),
(69, 1, 'SIKENSI', NULL),
(70, 1, 'TAABO', NULL),
(71, 1, 'TIASSALE', NULL),
(72, 1, 'N?DOUCI', NULL),
(73, 21, 'ADZOPE', NULL),
(74, 21, 'AGOU', NULL),
(75, 21, 'AFFERY', NULL),
(76, 21, 'AKOUPE', NULL),
(77, 21, 'ALEPE', NULL),
(78, 21, 'YAKASSE ATTOBROU', NULL),
(79, 15, 'DABOU', NULL),
(80, 15, 'GRAND LAHOU', NULL),
(81, 15, 'JACQUEVILLE', NULL),
(82, 10, 'BEOUMI', NULL),
(83, 10, 'BODOKRO', NULL),
(84, 10, 'BOTRO', NULL),
(85, 10, 'DIABO', NULL),
(86, 10, 'BOUAKE', NULL),
(87, 10, 'BROBO', NULL),
(88, 10, 'DJEBONOUA', NULL),
(89, 10, 'SAKASSOU', NULL),
(90, 16, 'BASSAWA', NULL),
(91, 16, 'BONIEREDOUGOU', NULL),
(92, 16, 'DABAKALA', NULL),
(93, 16, 'FOUMBOLO', NULL),
(94, 16, 'SATAMA SOKORO', NULL),
(95, 16, 'SATAMA SOKOURA', NULL),
(96, 16, 'KATIOLA', NULL),
(97, 16, 'FRONAN', NULL),
(98, 16, 'NIAKARAMADOUGOU', NULL),
(99, 16, 'TAFIRE', NULL),
(100, 16, 'TORTIYA', NULL),
(101, 7, 'BLOLEQUIN', NULL),
(102, 7, 'GUIGLO', NULL),
(103, 7, 'TAI', NULL),
(104, 7, 'TOULEPLEU', NULL),
(105, 14, 'BANGOLO', NULL),
(106, 14, 'DUEKOUE', NULL),
(107, 14, 'FACOBLY', NULL),
(108, 14, 'KOUIBLY', NULL),
(109, 30, 'BIANKOUMA', NULL),
(110, 30, 'GBONNE', NULL),
(111, 30, 'DANANE', NULL),
(112, 30, 'MAN', NULL),
(113, 30, 'LOGOUALE', NULL),
(114, 30, 'SANGOUINE', NULL),
(115, 30, 'SIPILOU', NULL),
(116, 30, 'ZOUAN HOUNIEN', NULL),
(117, 30, 'BINHOUYE', NULL),
(118, 17, 'BEDIALA', NULL),
(119, 17, 'DALOA', NULL),
(120, 17, 'GBOGUHE', NULL),
(121, 17, 'ISSIA', NULL),
(122, 17, 'SAIOUA', NULL),
(123, 17, 'VAVOUA', NULL),
(124, 17, 'ZOUKOUGBEU', NULL),
(125, 22, 'BOUAFLE', NULL),
(126, 22, 'BONON', NULL),
(127, 22, 'SINFRA', NULL),
(128, 22, 'GOHITAFLA', NULL),
(129, 22, 'ZUENOULA', NULL),
(130, 26, 'DIKODOUGOU', NULL),
(131, 26, 'GUIEMBRE', NULL),
(132, 26, 'KORHOGO', NULL),
(133, 26, 'KARAKORO', NULL),
(134, 26, 'KOMBORODOUGOU', NULL),
(135, 26, 'NAPIE', NULL),
(136, 26, 'NIOFOIN', NULL),
(137, 26, 'SIRASSO', NULL),
(138, 26, 'TIORONIARADOUGOU', NULL),
(139, 26, 'M?BENGUE', NULL),
(140, 26, 'SINEMATIALI', NULL),
(141, 29, 'KONG', NULL),
(142, 29, 'FERKESSEDOUGOU', NULL),
(143, 29, 'KOUMBALA', NULL),
(144, 29, 'OUANGOLODOUGOU', NULL),
(145, 29, 'DIAWALA', NULL),
(146, 29, 'NIELLE', NULL),
(147, 32, 'BOUNDIALI', NULL),
(148, 32, 'KASSERE', NULL),
(149, 32, 'GBON', NULL),
(150, 32, 'KOLIA', NULL),
(151, 32, 'KOUTO', NULL),
(152, 32, 'KANAKONO', NULL),
(153, 32, 'TENGRELA', NULL),
(154, 3, 'DIANRA', NULL),
(155, 3, 'KONGASSO', NULL),
(156, 3, 'KOUNAHIRI', NULL),
(157, 3, 'MANKONO', NULL),
(158, 3, 'SARHALA', NULL),
(159, 3, 'TIENINGBOUE', NULL),
(160, 31, 'KANI', NULL),
(161, 31, 'DJIBROSSO', NULL),
(162, 31, 'MORONDO', NULL),
(163, 31, 'SEGUELA', NULL),
(164, 31, 'DUALLA', NULL),
(165, 31, 'MASSALA', NULL),
(166, 31, 'SIFIE', NULL),
(167, 31, 'WOROFLA', NULL),
(168, 2, 'BOOKO', NULL),
(169, 2, 'BOROTOU', NULL),
(170, 2, 'KORO', NULL),
(171, 2, 'KOONAN', NULL),
(172, 31, 'OUANINOU', NULL),
(173, 31, 'GUINTEGUELA', NULL),
(174, 27, 'TABOU', NULL),
(175, 6, 'BOUNA', NULL),
(176, 6, 'DOROPO', NULL),
(177, 6, 'NASSIAN', NULL),
(178, 6, 'TEHINI', NULL),
(179, 13, 'BONDOUKOU', NULL),
(180, 13, 'KOUASSI KOUASSIKRO', NULL),
(181, 13, 'KOUASSI DATTEKRO', NULL),
(182, 13, 'KOUN FAO', NULL),
(183, 13, 'SANDEGUE', NULL),
(184, 13, 'TANDA', NULL),
(185, 13, 'ASSUEFRY', NULL),
(186, 13, 'TRANSUA', NULL),
(187, -1, 'ABOBO', NULL),
(188, -1, 'ADJAME', NULL),
(189, -1, 'ANYAMA', NULL),
(190, -1, 'ATTECOUBE', NULL),
(191, -1, 'BINGERVILLE', NULL),
(192, -1, 'COCODY', NULL),
(193, -1, 'KOUMASSI', NULL),
(194, -1, 'MARCORY', NULL),
(195, -1, 'PLATEAU', NULL),
(196, -1, 'PORT BOUET', NULL),
(197, -1, 'SONGON', NULL),
(198, -1, 'TREICHVILLE', NULL),
(199, -1, 'YOPOUGON', NULL),
(200, -2, 'ATTIEGOUAKRO', NULL),
(201, -2, 'YAMOUSSOUKRO', NULL);

-- --------------------------------------------------------

--
-- Structure de la table `departement`
--

DROP TABLE IF EXISTS `departement`;
CREATE TABLE IF NOT EXISTS `departement` (
  `id_dept` int NOT NULL AUTO_INCREMENT,
  `dept_id_region` int DEFAULT '0',
  `nom_dept` varchar(250) DEFAULT '',
  PRIMARY KEY (`id_dept`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `departement`
--

INSERT INTO `departement` (`id_dept`, `dept_id_region`, `nom_dept`) VALUES
(12, 1, 'Agboville'),
(13, 1, 'Adzopé'),
(14, 2, 'Touba'),
(15, 3, 'San Pédro'),
(16, 3, 'Sassandra'),
(17, 3, 'Soubré'),
(18, 3, 'Tabou'),
(19, 4, 'Odiénné'),
(20, 5, 'Man'),
(21, 5, 'Bangolo'),
(22, 5, 'Biankouma'),
(23, 5, 'Danané'),
(24, 6, 'Gagnoa'),
(25, 6, 'Oumé'),
(26, 7, 'Daloa'),
(27, 7, 'Issia'),
(28, 7, 'Vavoua'),
(30, 8, 'Tiébissou'),
(31, 8, 'Toumodi'),
(32, 9, 'Alépé'),
(33, 9, 'Dabou'),
(34, 9, 'Grand-Lahou'),
(35, 9, 'Jacqueville'),
(36, 9, 'Tiassalé'),
(37, 10, 'Bouaflé'),
(38, 10, 'Sinfra'),
(39, 10, 'Zuénoula'),
(40, 11, 'Guiglo'),
(41, 11, 'Duékoué'),
(42, 11, 'Toulépleu'),
(43, 12, 'Abengourou'),
(44, 12, 'Agnibilékrou'),
(45, 13, 'Dimbokro'),
(46, 13, 'Bongouanou'),
(47, 13, 'Bocanda'),
(48, 13, 'Daoukro'),
(49, 13, 'M’bahiakro'),
(50, 14, 'Korhogo'),
(51, 14, 'Boundiali'),
(52, 14, 'Ferkéssédougou'),
(53, 14, 'Tengréla'),
(54, 15, 'Divo'),
(55, 15, 'Lakota'),
(56, 16, 'Aboisso'),
(57, 16, 'Adiaké'),
(58, 16, 'Grand-Bassam'),
(59, 17, 'Bouaké'),
(60, 17, 'Béoumi'),
(61, 17, 'Dabakala'),
(62, 17, 'Katiola'),
(63, 17, 'Sakassou'),
(64, 18, 'Séguéla'),
(65, 18, 'Mankono'),
(66, 19, 'Bondoukou'),
(67, 19, 'Bouna'),
(68, 19, 'Tanda');

-- --------------------------------------------------------

--
-- Structure de la table `district`
--

DROP TABLE IF EXISTS `district`;
CREATE TABLE IF NOT EXISTS `district` (
  `id_district` int NOT NULL AUTO_INCREMENT,
  `id_region` int DEFAULT '0',
  `nom_district` varchar(250) DEFAULT '',
  PRIMARY KEY (`id_district`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `district`
--

INSERT INTO `district` (`id_district`, `id_region`, `nom_district`) VALUES
(2, 8, 'Yamoussokro'),
(3, 9, 'Abidjan'),
(4, 0, 'DENGUELE'),
(5, 0, 'SAVANES'),
(6, 0, 'ZANZAN'),
(7, 0, 'WOROBA'),
(8, 0, 'VALLEE DU BANDAMA'),
(9, 0, 'MONTAGNES'),
(10, 0, 'SASSANDRA MARAHOUE'),
(11, 0, 'LACS'),
(12, 0, 'BAS SASSANDRA'),
(13, 0, 'GOH DJIBOUA'),
(14, 0, 'LAGUNES'),
(15, 0, 'COMOE');

-- --------------------------------------------------------

--
-- Structure de la table `elu_c`
--

DROP TABLE IF EXISTS `elu_c`;
CREATE TABLE IF NOT EXISTS `elu_c` (
  `id_elu_c` int NOT NULL AUTO_INCREMENT,
  `nom_elu_c` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `prenom_elu_c` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `profession_elu_c` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `contact_elu_c` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `email_elu_c` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `sexe_elu_c` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `statut_elu_c` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `numodre_elu_c` int DEFAULT NULL,
  `poste_organe_elu_c` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `elu_id_c` int DEFAULT NULL,
  `elu_id_qualite_c` int DEFAULT NULL,
  `elu_id_organe_c` int DEFAULT NULL,
  PRIMARY KEY (`id_elu_c`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Structure de la table `elu_r`
--

DROP TABLE IF EXISTS `elu_r`;
CREATE TABLE IF NOT EXISTS `elu_r` (
  `id_elu_r` int NOT NULL AUTO_INCREMENT,
  `nom_elu_r` varchar(250) DEFAULT NULL,
  `prenom_elu_r` varchar(250) DEFAULT NULL,
  `profession_elu_r` varchar(250) DEFAULT NULL,
  `contact_elu_r` varchar(250) DEFAULT NULL,
  `email_elu_r` varchar(250) DEFAULT NULL,
  `sexe_elu_r` varchar(250) DEFAULT NULL,
  `statut_elu_r` varchar(250) DEFAULT NULL,
  `numodre_elu_r` int DEFAULT NULL,
  `poste_organe_elu_r` varchar(250) DEFAULT NULL,
  `elu_id_r` int DEFAULT NULL,
  `elu_id_qualite_r` int DEFAULT NULL,
  `elu_id_organe_r` int DEFAULT NULL,
  PRIMARY KEY (`id_elu_r`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Structure de la table `organe_c`
--

DROP TABLE IF EXISTS `organe_c`;
CREATE TABLE IF NOT EXISTS `organe_c` (
  `id_organe_c` int NOT NULL AUTO_INCREMENT,
  `nom_organe_c` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id_organe_c`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Structure de la table `organe_r`
--

DROP TABLE IF EXISTS `organe_r`;
CREATE TABLE IF NOT EXISTS `organe_r` (
  `id_organe_r` int NOT NULL AUTO_INCREMENT,
  `nom_organe_r` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id_organe_r`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Structure de la table `qualite_c`
--

DROP TABLE IF EXISTS `qualite_c`;
CREATE TABLE IF NOT EXISTS `qualite_c` (
  `id_qualite_c` int NOT NULL AUTO_INCREMENT,
  `nom_qualite_c` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id_qualite_c`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Structure de la table `qualite_r`
--

DROP TABLE IF EXISTS `qualite_r`;
CREATE TABLE IF NOT EXISTS `qualite_r` (
  `id_qualite_r` int NOT NULL AUTO_INCREMENT,
  `nom_qualite_r` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id_qualite_r`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Structure de la table `region`
--

DROP TABLE IF EXISTS `region`;
CREATE TABLE IF NOT EXISTS `region` (
  `id_region` int NOT NULL AUTO_INCREMENT,
  `reg_id_district` int DEFAULT NULL,
  `nom_region` varchar(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `cheflieu_region` varchar(250) CHARACTER SET latin1 DEFAULT NULL,
  PRIMARY KEY (`id_region`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `region`
--

INSERT INTO `region` (`id_region`, `reg_id_district`, `nom_region`, `cheflieu_region`) VALUES
(-2, 2, 'YAMOUSSOUKRO', 'YAMOUSSOUKRO'),
(-1, 3, 'ABIDJAN', 'ABIDJAN'),
(1, 14, 'AGNEBY-TIASSA', 'AGBOVILLE'),
(2, 7, 'BAFING', 'TOUBA'),
(3, 7, 'BERE', 'MANKONO'),
(4, 11, 'BELIER', 'TOUMODI'),
(6, 6, 'BOUNKANI', 'BOUNA'),
(7, 9, 'CAVALLY', 'GUIGLO'),
(8, 13, 'LOH-DJIBOUA', 'DIVO'),
(9, 4, 'FOLON', 'MINIGNAN'),
(10, 8, 'GBEKE', 'BOUAKE'),
(11, 12, 'GBOKLE', 'SASSANDRA'),
(12, 13, 'GOH', 'GAGNOA'),
(13, 6, 'GONTOUGO', 'BONDOUKOU'),
(14, 9, 'GUEMON', 'DUEKOUE'),
(15, 14, 'GRAND-PONTS', 'DABOU'),
(16, 8, 'HAMBOL', 'KATIOLA'),
(17, 10, 'HAUT SASSANDRA', 'DALOA'),
(18, 11, 'IFFOU', 'DAOUKRO'),
(19, 15, 'INDENIE-DJUABLIN', 'ABENGOUROU'),
(20, 4, 'KABADOUGOU', 'ODIENNE'),
(21, 14, 'LA ME', 'ADZOPE'),
(22, 10, 'MARAHOUE', 'BOUAFLE'),
(23, 11, 'MORONOU', 'BONGOUANOU'),
(24, 12, 'NAWA', 'SOUBRE'),
(25, 11, 'N\'ZI', 'DIMBOKRO'),
(26, 5, 'PORO', 'KORHOGO'),
(27, 12, 'SAN PEDRO', 'SAN PEDRO'),
(28, 15, 'SUD-COMOE', 'ABOISSO'),
(29, 5, 'TCHOLOGO', 'FERKESSEDOUGOU'),
(30, 9, 'TONKPI', 'MAN'),
(31, 7, 'WORODOUGOU', 'SEGUELA'),
(32, 5, 'BAGOUE', 'BOUNDIALI');

-- --------------------------------------------------------

--
-- Structure de la table `utilisateur`
--

DROP TABLE IF EXISTS `utilisateur`;
CREATE TABLE IF NOT EXISTS `utilisateur` (
  `id_user` int NOT NULL AUTO_INCREMENT,
  `login` varchar(250) DEFAULT NULL,
  `mdp` varchar(250) DEFAULT NULL,
  `gp_user` varchar(250) DEFAULT NULL,
  `type_collectivite` varchar(250) DEFAULT NULL,
  `usr_id_collectivite` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
COMMIT;

/*!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 */;
