-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Hôte : localhost
-- Généré le : ven. 20 jan. 2023 à 09:53
-- Version du serveur :  10.3.36-MariaDB-0+deb10u2
-- Version de PHP : 7.3.31-1~deb10u2

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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 : `dist_rs`
--

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

--
-- Structure de la table `recensement_goutinel`
--

CREATE TABLE `recensement_goutinel` (
  `id` int(11) NOT NULL,
  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `latitude` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `longitude` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `adresse` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `gouvernorat_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `gouvernorat` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `delegation_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `delegation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `localite_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `localite` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `code_postale` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `activite_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `activite` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ferme` tinyint(1) DEFAULT NULL,
  `categorie1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `categorie1_libelle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dn_categorie1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dn_marque_categorie1` int(11) DEFAULT NULL,
  `categorie2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `categorie2_libelle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dn_categorie2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dn_marque_categorie2` int(11) DEFAULT NULL,
  `categorie3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `categorie3_libelle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dn_categorie3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dn_marque_categorie3` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `recensement_goutinel`
--
ALTER TABLE `recensement_goutinel`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`),
  ADD KEY `code_2` (`code`),
  ADD KEY `gouvernorat_code` (`gouvernorat_code`),
  ADD KEY `gouvernorat` (`gouvernorat`),
  ADD KEY `delegation_code` (`delegation_code`),
  ADD KEY `delegation` (`delegation`),
  ADD KEY `localite_code` (`localite_code`),
  ADD KEY `localite` (`localite`),
  ADD KEY `activite_code` (`activite_code`),
  ADD KEY `ferme` (`ferme`),
  ADD KEY `categorie1` (`categorie1`),
  ADD KEY `categorie1_libelle` (`categorie1_libelle`),
  ADD KEY `categorie2` (`categorie2`),
  ADD KEY `categorie2_libelle` (`categorie2_libelle`),
  ADD KEY `categorie3` (`categorie3`),
  ADD KEY `categorie3_libelle` (`categorie3_libelle`);
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 */;