2f5946a184
- Configuration complète Stripe pour les 3 environnements (DEV/REC/PROD) * DEV: Clés TEST Pierre (mode test) * REC: Clés TEST Client (mode test) * PROD: Clés LIVE Client (mode live) - Ajout de la gestion des bases de données immeubles/bâtiments * Configuration buildings_database pour DEV/REC/PROD * Service BuildingService pour enrichissement des adresses - Optimisations pages et améliorations ergonomie - Mises à jour des dépendances Composer - Nettoyage des fichiers obsolètes 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude <noreply@anthropic.com>
1089 lines
40 KiB
SQL
1089 lines
40 KiB
SQL
/*M!999999\- enable the sandbox mode */
|
|
-- MariaDB dump 10.19 Distrib 10.11.9-MariaDB, for debian-linux-gnu (x86_64)
|
|
--
|
|
-- Host: localhost Database: geosector
|
|
-- ------------------------------------------------------
|
|
-- Server version 10.11.9-MariaDB-deb12
|
|
|
|
/*!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 */;
|
|
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
|
/*!40103 SET TIME_ZONE='+00:00' */;
|
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|
|
|
--
|
|
-- Table structure for table `articles`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `articles`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `articles` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`fk_page` int(11) DEFAULT 0,
|
|
`row` int(11) DEFAULT 1,
|
|
`col` int(11) DEFAULT 1,
|
|
`libelle` varchar(45) DEFAULT NULL,
|
|
`ordre` int(11) DEFAULT 0,
|
|
`titre` varchar(200) DEFAULT NULL,
|
|
`chapeau` text DEFAULT NULL,
|
|
`texte` text DEFAULT NULL,
|
|
`icone` varchar(45) NOT NULL DEFAULT '',
|
|
`icone_position` int(11) DEFAULT 1,
|
|
`icone_size` int(11) DEFAULT 1,
|
|
`active` tinyint(1) DEFAULT 1,
|
|
PRIMARY KEY (`rowid`),
|
|
UNIQUE KEY `rowid_UNIQUE` (`rowid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `articles_pages`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `articles_pages`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `articles_pages` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`ordre` int(11) NOT NULL DEFAULT 0,
|
|
`libelle` varchar(75) NOT NULL DEFAULT '',
|
|
`script` varchar(45) NOT NULL DEFAULT '',
|
|
`admin` tinyint(1) DEFAULT 0,
|
|
`active` tinyint(1) DEFAULT 1,
|
|
PRIMARY KEY (`rowid`),
|
|
UNIQUE KEY `rowid_UNIQUE` (`rowid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `blog_articles`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `blog_articles`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `blog_articles` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`fk_entite` int(11) DEFAULT NULL,
|
|
`fk_page` int(11) DEFAULT NULL,
|
|
`lst_destinataires` text NOT NULL,
|
|
`libelle` varchar(75) NOT NULL,
|
|
`texte` text DEFAULT NULL,
|
|
`publie` tinyint(1) DEFAULT 1,
|
|
`date_publication` date DEFAULT NULL,
|
|
`date_fin_publication` date DEFAULT NULL,
|
|
`active` tinyint(1) DEFAULT 1,
|
|
PRIMARY KEY (`rowid`),
|
|
UNIQUE KEY `rowid_UNIQUE` (`rowid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=482 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `blog_pages`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `blog_pages`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `blog_pages` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`libelle` varchar(45) DEFAULT NULL,
|
|
`site` tinyint(1) DEFAULT 0,
|
|
`admin` tinyint(1) DEFAULT 0,
|
|
`script` varchar(20) DEFAULT 'accueil',
|
|
`active` tinyint(1) DEFAULT 1,
|
|
PRIMARY KEY (`rowid`),
|
|
UNIQUE KEY `rowid_UNIQUE` (`rowid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `email_counter`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `email_counter`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `email_counter` (
|
|
`id` int(11) NOT NULL DEFAULT 1,
|
|
`hour_start` timestamp NULL DEFAULT NULL,
|
|
`count` int(11) DEFAULT 0,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `email_queue`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `email_queue`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `email_queue` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`rowid` int(11) NOT NULL DEFAULT 0,
|
|
`to_email` varchar(255) DEFAULT NULL,
|
|
`subject` varchar(255) DEFAULT NULL,
|
|
`body` text DEFAULT NULL,
|
|
`headers` text DEFAULT NULL,
|
|
`created_at` timestamp NULL DEFAULT current_timestamp(),
|
|
`status` enum('pending','sent','failed') DEFAULT 'pending',
|
|
`attempts` int(11) DEFAULT 0,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=41279 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `medias`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `medias`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `medias` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`dir0` varchar(75) NOT NULL DEFAULT '',
|
|
`dir1` varchar(150) NOT NULL DEFAULT '',
|
|
`dir2` varchar(45) NOT NULL DEFAULT '',
|
|
`support` varchar(45) NOT NULL DEFAULT '',
|
|
`support_rowid` int(11) NOT NULL DEFAULT 0,
|
|
`fichier` varchar(250) NOT NULL DEFAULT '',
|
|
`type_fichier` varchar(5) NOT NULL DEFAULT 'pdf',
|
|
`description` varchar(100) NOT NULL DEFAULT '',
|
|
`position` char(1) NOT NULL DEFAULT 'd',
|
|
`hauteur` int(11) NOT NULL DEFAULT 0,
|
|
`largeur` int(11) NOT NULL DEFAULT 0,
|
|
`niveaugris` tinyint(1) NOT NULL DEFAULT 0,
|
|
`date_creat` datetime DEFAULT NULL,
|
|
`fk_user_creat` int(11) NOT NULL DEFAULT 0,
|
|
`date_modif` datetime DEFAULT NULL,
|
|
`fk_user_modif` int(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`rowid`),
|
|
UNIQUE KEY `rowid_UNIQUE` (`rowid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=339 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `ope_pass`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `ope_pass`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `ope_pass` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`fk_operation` int(11) NOT NULL DEFAULT 0,
|
|
`fk_sector` int(11) DEFAULT 0,
|
|
`fk_user` int(11) NOT NULL DEFAULT 0,
|
|
`fk_adresse` varchar(25) DEFAULT '',
|
|
`date_eve` datetime DEFAULT NULL,
|
|
`fk_type` int(11) DEFAULT 0,
|
|
`numero` varchar(10) NOT NULL DEFAULT '',
|
|
`rue` varchar(75) NOT NULL DEFAULT '',
|
|
`rue_bis` varchar(1) NOT NULL DEFAULT '',
|
|
`ville` varchar(75) NOT NULL DEFAULT '',
|
|
`lieudit` varchar(75) DEFAULT '',
|
|
`fk_habitat` int(11) DEFAULT 1,
|
|
`appt` varchar(5) DEFAULT NULL,
|
|
`niveau` varchar(5) DEFAULT NULL,
|
|
`chk_habitat_vide` tinyint(1) NOT NULL DEFAULT 0,
|
|
`gps_lat` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
|
|
`gps_lng` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
|
|
`libelle` varchar(45) NOT NULL DEFAULT '',
|
|
`montant` decimal(7,2) NOT NULL DEFAULT 0.00,
|
|
`fk_type_reglement` int(11) DEFAULT 1,
|
|
`remarque` text DEFAULT NULL,
|
|
`recu` varchar(50) DEFAULT NULL,
|
|
`email` varchar(75) DEFAULT '',
|
|
`email_erreur` varchar(30) DEFAULT '',
|
|
`chk_email_sent` tinyint(1) NOT NULL DEFAULT 0,
|
|
`phone` varchar(15) NOT NULL DEFAULT '',
|
|
`docremis` tinyint(1) DEFAULT 0,
|
|
`date_repasser` datetime DEFAULT NULL,
|
|
`nb_passages` int(11) DEFAULT 1,
|
|
`lot_nb_passages` int(11) DEFAULT 1,
|
|
`chk_gps_maj` tinyint(1) DEFAULT 0,
|
|
`chk_map_create` tinyint(1) DEFAULT 0,
|
|
`chk_mobile` tinyint(1) DEFAULT 0,
|
|
`chk_synchro` tinyint(1) DEFAULT 1,
|
|
`chk_api_adresse` tinyint(1) DEFAULT 0,
|
|
`chk_maj_adresse` tinyint(1) DEFAULT 0,
|
|
`anomalie` tinyint(1) DEFAULT 0,
|
|
`date_creat` datetime DEFAULT NULL,
|
|
`fk_user_creat` int(11) DEFAULT NULL,
|
|
`date_modif` datetime DEFAULT NULL,
|
|
`fk_user_modif` int(11) DEFAULT NULL,
|
|
`active` tinyint(1) NOT NULL DEFAULT 1,
|
|
PRIMARY KEY (`rowid`),
|
|
KEY `fk_operation` (`fk_operation`),
|
|
KEY `fk_sector` (`fk_sector`),
|
|
KEY `fk_user` (`fk_user`),
|
|
KEY `fk_type` (`fk_type`),
|
|
KEY `fk_type_reglement` (`fk_type_reglement`),
|
|
KEY `email` (`email`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=11583369 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `ope_pass_histo`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `ope_pass_histo`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `ope_pass_histo` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`fk_pass` int(11) DEFAULT NULL,
|
|
`fk_user` int(11) DEFAULT NULL,
|
|
`date_histo` datetime DEFAULT NULL,
|
|
`sujet` varchar(50) DEFAULT NULL,
|
|
`remarque` varchar(250) DEFAULT NULL,
|
|
PRIMARY KEY (`rowid`),
|
|
KEY `ope_pass_histo_fk_pass_IDX` (`fk_pass`) USING BTREE,
|
|
KEY `ope_pass_histo_date_histo_IDX` (`date_histo`) USING BTREE
|
|
) ENGINE=InnoDB AUTO_INCREMENT=45125 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `ope_pass_recus`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `ope_pass_recus`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `ope_pass_recus` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`fk_pass` int(11) DEFAULT NULL,
|
|
`chemin` varchar(100) DEFAULT NULL,
|
|
`nom_recu` varchar(50) DEFAULT NULL,
|
|
`date_recu` datetime DEFAULT NULL,
|
|
`date_creat_recu` datetime DEFAULT NULL,
|
|
`date_sent_recu` datetime DEFAULT NULL,
|
|
PRIMARY KEY (`rowid`),
|
|
UNIQUE KEY `rowid_UNIQUE` (`rowid`),
|
|
KEY `ope_pass_recus_fk_pass_IDX` (`fk_pass`) USING BTREE
|
|
) ENGINE=InnoDB AUTO_INCREMENT=140967 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `ope_users`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `ope_users`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `ope_users` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`fk_operation` int(11) NOT NULL DEFAULT 0,
|
|
`fk_user` int(11) NOT NULL DEFAULT 0,
|
|
`date_creat` datetime DEFAULT NULL,
|
|
`fk_user_creat` int(11) DEFAULT NULL,
|
|
`date_modif` datetime DEFAULT NULL,
|
|
`fk_user_modif` int(11) DEFAULT NULL,
|
|
`active` tinyint(1) NOT NULL DEFAULT 1,
|
|
PRIMARY KEY (`rowid`),
|
|
UNIQUE KEY `rowid_UNIQUE` (`rowid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=254796 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `ope_users_sectors`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `ope_users_sectors`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `ope_users_sectors` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`fk_operation` int(11) DEFAULT NULL,
|
|
`fk_user` int(11) DEFAULT NULL,
|
|
`fk_sector` int(11) DEFAULT NULL,
|
|
`active` tinyint(1) DEFAULT 1,
|
|
PRIMARY KEY (`rowid`),
|
|
UNIQUE KEY `rowid` (`rowid`),
|
|
KEY `fk_operation` (`fk_operation`),
|
|
KEY `fk_user` (`fk_user`),
|
|
KEY `fk_sector` (`fk_sector`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=203919 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `ope_users_suivis`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `ope_users_suivis`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `ope_users_suivis` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`fk_operation` int(11) DEFAULT NULL,
|
|
`fk_user` int(11) DEFAULT NULL,
|
|
`date_suivi` datetime DEFAULT NULL,
|
|
`latitude` varchar(20) DEFAULT NULL,
|
|
`longitude` varchar(20) DEFAULT NULL,
|
|
`vitesse` varchar(20) DEFAULT NULL,
|
|
PRIMARY KEY (`rowid`),
|
|
UNIQUE KEY `rowid_UNIQUE` (`rowid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=2820230 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `operations`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `operations`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `operations` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`fk_entite` int(11) DEFAULT 1,
|
|
`libelle` varchar(75) NOT NULL DEFAULT '',
|
|
`date_deb` date DEFAULT NULL,
|
|
`date_fin` date DEFAULT NULL,
|
|
`chk_api_adresse` tinyint(1) DEFAULT 0,
|
|
`chk_distinct_sectors` tinyint(1) DEFAULT 0,
|
|
`date_creat` datetime DEFAULT NULL,
|
|
`fk_user_creat` int(11) DEFAULT NULL,
|
|
`date_modif` datetime DEFAULT NULL,
|
|
`fk_user_modif` int(11) DEFAULT NULL,
|
|
`active` tinyint(1) DEFAULT 1,
|
|
PRIMARY KEY (`rowid`),
|
|
KEY `fk_entite` (`fk_entite`),
|
|
KEY `date_deb` (`date_deb`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=3507 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `operations_docs`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `operations_docs`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `operations_docs` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`fk_operation` int(11) NOT NULL DEFAULT 0,
|
|
`libelle` varchar(75) NOT NULL DEFAULT '',
|
|
`comment` text NOT NULL,
|
|
`active` tinyint(1) NOT NULL DEFAULT 1,
|
|
PRIMARY KEY (`rowid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `operations_eve_docs`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `operations_eve_docs`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `operations_eve_docs` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`fk_evenement` int(11) NOT NULL DEFAULT 0,
|
|
`fk_document` int(11) NOT NULL DEFAULT 0,
|
|
`date_creat` datetime DEFAULT NULL,
|
|
`fk_user_creat` int(11) DEFAULT NULL,
|
|
`date_modif` datetime DEFAULT NULL,
|
|
`fk_user_modif` int(11) DEFAULT NULL,
|
|
`active` tinyint(1) DEFAULT 1,
|
|
PRIMARY KEY (`rowid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `params`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `params`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `params` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`libelle` varchar(35) NOT NULL DEFAULT '',
|
|
`valeur` varchar(255) NOT NULL DEFAULT '',
|
|
`aide` varchar(150) NOT NULL DEFAULT '',
|
|
PRIMARY KEY (`rowid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `sectors`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `sectors`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `sectors` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`libelle` varchar(75) DEFAULT '',
|
|
`sector` text DEFAULT NULL,
|
|
`color` varchar(7) DEFAULT '#4B77BE',
|
|
`date_creat` datetime DEFAULT NULL,
|
|
`fk_user_creat` int(11) DEFAULT NULL,
|
|
`date_modif` datetime DEFAULT NULL,
|
|
`fk_user_modif` int(11) DEFAULT NULL,
|
|
`active` tinyint(1) DEFAULT 1,
|
|
PRIMARY KEY (`rowid`),
|
|
UNIQUE KEY `rowid_UNIQUE` (`rowid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=39675 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `sectors_adresses`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `sectors_adresses`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `sectors_adresses` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`fk_adresse` varchar(25) DEFAULT NULL,
|
|
`fk_sector` int(11) DEFAULT NULL,
|
|
`numero` varchar(5) DEFAULT NULL,
|
|
`rue_bis` varchar(5) DEFAULT NULL,
|
|
`rue` varchar(60) DEFAULT NULL,
|
|
`cp` varchar(5) DEFAULT NULL,
|
|
`ville` varchar(60) DEFAULT NULL,
|
|
`gps_lat` varchar(10) DEFAULT NULL,
|
|
`gps_lng` varchar(10) DEFAULT NULL,
|
|
PRIMARY KEY (`rowid`),
|
|
KEY `sectors_adresses_fk_sector_index` (`fk_sector`),
|
|
KEY `sectors_adresses_numero_index` (`numero`),
|
|
KEY `sectors_adresses_rue_index` (`rue`),
|
|
KEY `sectors_adresses_ville_index` (`ville`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=29621480 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `sectors_streets`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `sectors_streets`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `sectors_streets` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`fk_sector` int(11) DEFAULT NULL,
|
|
`fk_adresse` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
|
|
`osm_id` int(11) DEFAULT NULL,
|
|
`osm_lat` varchar(10) DEFAULT NULL,
|
|
`osm_lng` varchar(10) DEFAULT NULL,
|
|
`osm_name` varchar(50) DEFAULT NULL,
|
|
`osm_street` varchar(50) DEFAULT NULL,
|
|
`osm_number` varchar(10) DEFAULT NULL,
|
|
`osm_city` varchar(50) DEFAULT NULL,
|
|
`osm_date_creat` timestamp NULL DEFAULT NULL,
|
|
`date_creat` datetime DEFAULT NULL,
|
|
PRIMARY KEY (`rowid`),
|
|
UNIQUE KEY `rowid_UNIQUE` (`rowid`),
|
|
KEY `fk_sector` (`fk_sector`),
|
|
KEY `osm_lat` (`osm_lat`),
|
|
KEY `osm_lng` (`osm_lng`),
|
|
KEY `osm_name` (`osm_name`),
|
|
KEY `osm_city` (`osm_city`),
|
|
KEY `osm_street` (`osm_street`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=47868262 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `users`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `users`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `users` (
|
|
`rowid` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`fk_entite` int(11) DEFAULT 1,
|
|
`fk_titre` int(11) DEFAULT 1,
|
|
`num_adherent` int(11) NOT NULL DEFAULT 0,
|
|
`libelle` varchar(91) DEFAULT NULL,
|
|
`libelle_naissance` varchar(90) NOT NULL DEFAULT '',
|
|
`prenom` varchar(45) DEFAULT NULL,
|
|
`nom_tournee` varchar(60) DEFAULT '',
|
|
`username` varchar(50) DEFAULT '',
|
|
`userpass` varchar(60) DEFAULT NULL,
|
|
`userpswd` varchar(60) DEFAULT NULL,
|
|
`josh` tinyint(1) NOT NULL DEFAULT 0,
|
|
`telephone` varchar(15) DEFAULT NULL,
|
|
`mobile` varchar(15) DEFAULT NULL,
|
|
`email` varchar(100) DEFAULT '',
|
|
`email_secondaire` varchar(100) NOT NULL DEFAULT '',
|
|
`fk_role` int(11) DEFAULT 1,
|
|
`infos` varchar(200) NOT NULL DEFAULT '',
|
|
`ltt` varchar(10) DEFAULT '48.08',
|
|
`lng` varchar(10) DEFAULT '-1.68',
|
|
`sector` text DEFAULT NULL,
|
|
`alert_email` tinyint(1) DEFAULT 1,
|
|
`chk_suivi` tinyint(1) DEFAULT 0,
|
|
`date_naissance` date DEFAULT NULL,
|
|
`dept_naissance` varchar(2) NOT NULL DEFAULT '',
|
|
`commune_naissance` varchar(60) NOT NULL DEFAULT '',
|
|
`date_embauche` date DEFAULT NULL,
|
|
`anciennete` varchar(20) DEFAULT '-',
|
|
`fk_categorie` int(11) NOT NULL DEFAULT 0,
|
|
`fk_sous_categorie` int(11) NOT NULL DEFAULT 0,
|
|
`adresse_1` varchar(50) NOT NULL DEFAULT '',
|
|
`adresse_2` varchar(50) NOT NULL DEFAULT '',
|
|
`cp` varchar(5) NOT NULL DEFAULT '',
|
|
`ville` varchar(60) NOT NULL DEFAULT '',
|
|
`matricule` varchar(10) NOT NULL DEFAULT '',
|
|
`fk_grade` int(11) NOT NULL DEFAULT 0,
|
|
`chk_adherent_ud` tinyint(1) NOT NULL DEFAULT 0,
|
|
`chk_adherent_ur` tinyint(1) NOT NULL DEFAULT 0,
|
|
`chk_adherent_fns` tinyint(1) NOT NULL DEFAULT 0,
|
|
`chk_archive` tinyint(1) NOT NULL DEFAULT 0,
|
|
`chk_double_affectation` tinyint(1) NOT NULL DEFAULT 0,
|
|
`fk_user_creat` int(11) DEFAULT NULL,
|
|
`date_creat` datetime DEFAULT NULL,
|
|
`fk_user_modif` int(11) DEFAULT NULL,
|
|
`date_modif` datetime DEFAULT NULL,
|
|
`active` tinyint(1) DEFAULT 1,
|
|
PRIMARY KEY (`rowid`),
|
|
KEY `fk_entite` (`fk_entite`),
|
|
KEY `libelle` (`libelle`),
|
|
KEY `username` (`username`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=10029982 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `users_entites`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `users_entites`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `users_entites` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`appname` varchar(20) NOT NULL DEFAULT 'geo_sector',
|
|
`http_host` varchar(255) NOT NULL DEFAULT 'admin.geosector.fr adm.geosector.fr mobile.goesector.fr mob.geosector.fr',
|
|
`libelle` varchar(45) DEFAULT '',
|
|
`adresse1` varchar(45) DEFAULT '',
|
|
`adresse2` varchar(45) DEFAULT '',
|
|
`cp` varchar(5) DEFAULT '',
|
|
`ville` varchar(45) DEFAULT '',
|
|
`fk_region` int(11) DEFAULT NULL,
|
|
`fk_type` int(11) DEFAULT 1,
|
|
`tva_intra` varchar(15) DEFAULT '',
|
|
`rcs` varchar(45) DEFAULT '',
|
|
`siret` varchar(17) DEFAULT NULL,
|
|
`ape` varchar(5) DEFAULT '',
|
|
`tel1` varchar(20) DEFAULT '',
|
|
`tel2` varchar(20) DEFAULT '',
|
|
`couleur` varchar(10) DEFAULT '',
|
|
`prefecture` varchar(45) DEFAULT '',
|
|
`fk_titre_gerant` int(11) DEFAULT 1,
|
|
`gerant_prenom` varchar(45) DEFAULT '',
|
|
`gerant_nom` varchar(45) DEFAULT '',
|
|
`email` varchar(45) DEFAULT '',
|
|
`gps_lat` varchar(10) NOT NULL DEFAULT '',
|
|
`gps_lng` varchar(10) NOT NULL DEFAULT '',
|
|
`site_url` varchar(45) DEFAULT '',
|
|
`gerant_signature` varchar(45) DEFAULT '',
|
|
`tampon_signature` varchar(45) DEFAULT '',
|
|
`banque_libelle` varchar(25) DEFAULT '',
|
|
`banque_adresse` varchar(45) DEFAULT '',
|
|
`banque_cp` varchar(5) DEFAULT '',
|
|
`banque_ville` varchar(40) DEFAULT '',
|
|
`iban` varchar(30) DEFAULT '',
|
|
`bic` varchar(15) DEFAULT '',
|
|
`genbase` varchar(45) NOT NULL,
|
|
`groupebase` varchar(45) NOT NULL,
|
|
`userbase` varchar(45) NOT NULL,
|
|
`passbase` varchar(45) NOT NULL,
|
|
`demo` tinyint(1) DEFAULT 0,
|
|
`lib_vert` varchar(25) DEFAULT 'Effectué',
|
|
`lib_verts` varchar(25) DEFAULT 'Effectués',
|
|
`lib_orange` varchar(25) DEFAULT 'A repasser',
|
|
`lib_oranges` varchar(25) DEFAULT 'A repasser',
|
|
`lib_rouge` varchar(25) DEFAULT 'Refusé',
|
|
`lib_rouges` varchar(25) DEFAULT 'Refusés',
|
|
`lib_bleu` varchar(25) DEFAULT 'Autre (Don)',
|
|
`lib_bleus` varchar(25) DEFAULT 'Autres (Dons)',
|
|
`icon_siege` varchar(15) DEFAULT 'fire',
|
|
`icon_siege_color` varchar(15) DEFAULT 'red',
|
|
`btn_width` varchar(3) DEFAULT '100',
|
|
`chk_mdp_manuel` tinyint(1) NOT NULL DEFAULT 1,
|
|
`chk_copie_mail_recu` tinyint(1) NOT NULL DEFAULT 0,
|
|
`chk_accept_sms` tinyint(1) NOT NULL DEFAULT 0,
|
|
`nbmembres` int(11) DEFAULT 0,
|
|
`nbconnex` int(11) DEFAULT 0,
|
|
`date_modif` datetime DEFAULT NULL,
|
|
`fk_user_modif` int(11) DEFAULT NULL,
|
|
`active` tinyint(1) DEFAULT 1,
|
|
PRIMARY KEY (`rowid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1299 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `users_lastpos`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `users_lastpos`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `users_lastpos` (
|
|
`fk_user` int(11) NOT NULL,
|
|
`fk_operation` int(11) DEFAULT NULL,
|
|
`gps_lat` varchar(20) DEFAULT NULL,
|
|
`gps_lng` varchar(20) DEFAULT NULL,
|
|
`date_pos` datetime DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `x_civilites`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `x_civilites`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `x_civilites` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`libelle` varchar(45) DEFAULT NULL,
|
|
`active` tinyint(1) DEFAULT 1,
|
|
PRIMARY KEY (`rowid`),
|
|
UNIQUE KEY `rowid_UNIQUE` (`rowid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `x_departements`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `x_departements`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `x_departements` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`code` varchar(3) DEFAULT NULL,
|
|
`fk_region` int(11) DEFAULT 1,
|
|
`libelle` varchar(45) DEFAULT NULL,
|
|
`active` tinyint(1) DEFAULT 1,
|
|
PRIMARY KEY (`rowid`),
|
|
UNIQUE KEY `rowid_UNIQUE` (`rowid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `x_devises`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `x_devises`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `x_devises` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`code` varchar(3) DEFAULT NULL,
|
|
`symbole` varchar(6) DEFAULT NULL,
|
|
`libelle` varchar(45) DEFAULT NULL,
|
|
`active` tinyint(1) DEFAULT 1,
|
|
PRIMARY KEY (`rowid`),
|
|
UNIQUE KEY `rowid_UNIQUE` (`rowid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `x_entites_types`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `x_entites_types`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `x_entites_types` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`libelle` varchar(45) DEFAULT NULL,
|
|
`active` tinyint(1) DEFAULT NULL,
|
|
PRIMARY KEY (`rowid`),
|
|
UNIQUE KEY `rowid_UNIQUE` (`rowid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `x_pays`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `x_pays`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `x_pays` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`code` varchar(3) DEFAULT NULL,
|
|
`fk_continent` int(11) DEFAULT NULL,
|
|
`fk_devise` int(11) DEFAULT 1,
|
|
`libelle` varchar(45) DEFAULT NULL,
|
|
`active` tinyint(1) DEFAULT 1,
|
|
PRIMARY KEY (`rowid`),
|
|
UNIQUE KEY `rowid_UNIQUE` (`rowid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Table des pays avec leurs codes' `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `x_regions`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `x_regions`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `x_regions` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`fk_pays` int(11) DEFAULT 1,
|
|
`libelle` varchar(45) DEFAULT NULL,
|
|
`libelle_long` varchar(45) DEFAULT NULL,
|
|
`table_osm` varchar(45) DEFAULT NULL,
|
|
`departements` varchar(45) DEFAULT NULL,
|
|
`active` tinyint(1) DEFAULT 1,
|
|
PRIMARY KEY (`rowid`),
|
|
UNIQUE KEY `rowid_UNIQUE` (`rowid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `x_types_passages`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `x_types_passages`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `x_types_passages` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`libelle` varchar(10) DEFAULT NULL,
|
|
`color_button` varchar(15) DEFAULT NULL,
|
|
`color_mark` varchar(15) DEFAULT NULL,
|
|
`color_table` varchar(15) DEFAULT NULL,
|
|
`chk_active` tinyint(1) NOT NULL DEFAULT 1,
|
|
PRIMARY KEY (`rowid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `x_types_reglements`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `x_types_reglements`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `x_types_reglements` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`libelle` varchar(45) DEFAULT NULL,
|
|
`active` tinyint(1) DEFAULT 1,
|
|
PRIMARY KEY (`rowid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `x_users_categories`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `x_users_categories`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `x_users_categories` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`libelle` varchar(30) NOT NULL,
|
|
`active` tinyint(1) NOT NULL DEFAULT 1,
|
|
PRIMARY KEY (`rowid`),
|
|
KEY `x_users_categories__libelle` (`libelle`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `x_users_grades`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `x_users_grades`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `x_users_grades` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`libelle` varchar(90) NOT NULL DEFAULT '',
|
|
`active` tinyint(1) NOT NULL DEFAULT 1,
|
|
PRIMARY KEY (`rowid`),
|
|
KEY `x_users_grades__libelle` (`libelle`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=84 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `x_users_roles`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `x_users_roles`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `x_users_roles` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`libelle` varchar(45) DEFAULT NULL,
|
|
`active` tinyint(1) DEFAULT 1,
|
|
PRIMARY KEY (`rowid`),
|
|
UNIQUE KEY `rowid_UNIQUE` (`rowid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Les différents rôles des utilisateurs' `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `x_users_sous_categories`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `x_users_sous_categories`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `x_users_sous_categories` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`fk_user_categorie` int(11) NOT NULL,
|
|
`libelle` varchar(40) NOT NULL DEFAULT '',
|
|
`active` tinyint(1) NOT NULL DEFAULT 1,
|
|
PRIMARY KEY (`rowid`),
|
|
KEY `x_users_sous_categories__libelle` (`libelle`),
|
|
KEY `x_users_sous_categories_fk_user_categorie_index` (`fk_user_categorie`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `x_villes`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `x_villes`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `x_villes` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`fk_departement` int(11) DEFAULT 1,
|
|
`libelle` varchar(65) DEFAULT NULL,
|
|
`cp` varchar(5) DEFAULT NULL,
|
|
`code_insee` varchar(5) DEFAULT NULL,
|
|
`departement` varchar(65) DEFAULT NULL,
|
|
`active` tinyint(1) DEFAULT 1,
|
|
PRIMARY KEY (`rowid`),
|
|
UNIQUE KEY `rowid_UNIQUE` (`rowid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=38950 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `y_conf`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `y_conf`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `y_conf` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`admin` tinyint(1) NOT NULL DEFAULT 0,
|
|
`appenv` varchar(5) NOT NULL DEFAULT 'dev',
|
|
`apptitle` varchar(75) NOT NULL DEFAULT '',
|
|
`appversion` varchar(20) NOT NULL DEFAULT '0.5 du 15/01/2016',
|
|
`appscript` varchar(25) NOT NULL DEFAULT 'login',
|
|
`appicon` varchar(25) NOT NULL DEFAULT 'favicon.png',
|
|
`pathimg` varchar(45) NOT NULL DEFAULT '/files/img',
|
|
`pathupload` varchar(45) NOT NULL DEFAULT '/files/upload',
|
|
`brandgroupe` varchar(45) NOT NULL DEFAULT '',
|
|
`brandmulti` tinyint(1) DEFAULT 0,
|
|
`date_maintenance` datetime DEFAULT NULL,
|
|
`date_renouvellement` date DEFAULT NULL,
|
|
`piwikid` varchar(45) DEFAULT '0',
|
|
`googlid` varchar(45) DEFAULT '0',
|
|
`active` tinyint(1) DEFAULT 1,
|
|
PRIMARY KEY (`rowid`),
|
|
UNIQUE KEY `rowid_UNIQUE` (`rowid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `y_menus`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `y_menus`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `y_menus` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`type_menu` varchar(3) NOT NULL DEFAULT 'mnu',
|
|
`admin` tinyint(4) DEFAULT 0,
|
|
`only_type_entite` varchar(45) DEFAULT '',
|
|
`only_fk_entite` varchar(45) DEFAULT '',
|
|
`only_fk_role` varchar(45) DEFAULT '',
|
|
`divider_before` tinyint(1) DEFAULT 0,
|
|
`ordre` tinyint(4) DEFAULT 0,
|
|
`fk_parent` int(11) DEFAULT 0,
|
|
`libelle` varchar(45) DEFAULT '',
|
|
`icone` varchar(45) DEFAULT '',
|
|
`color` varchar(35) DEFAULT '',
|
|
`back-color` varchar(35) DEFAULT '',
|
|
`title` varchar(75) DEFAULT '',
|
|
`script` varchar(45) NOT NULL,
|
|
`script_command` varchar(45) DEFAULT '',
|
|
`active` tinyint(1) DEFAULT 1,
|
|
PRIMARY KEY (`rowid`),
|
|
UNIQUE KEY `rowid_UNIQUE` (`rowid`),
|
|
KEY `type_menu` (`type_menu`),
|
|
KEY `script` (`script`),
|
|
KEY `ordre` (`ordre`),
|
|
KEY `fk_parent` (`fk_parent`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `y_modules`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `y_modules`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `y_modules` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`fk_parent` int(11) DEFAULT 0,
|
|
`ordre` int(11) DEFAULT 0,
|
|
`libelle` varchar(45) NOT NULL,
|
|
`tip` varchar(150) DEFAULT '',
|
|
`description` text DEFAULT NULL,
|
|
`script` varchar(20) DEFAULT '',
|
|
`couleur` varchar(7) DEFAULT '#bcbcbc',
|
|
`icone` varchar(30) DEFAULT NULL,
|
|
`taille_tuile` int(11) DEFAULT 70,
|
|
`admin` tinyint(1) DEFAULT 1,
|
|
`active` tinyint(1) DEFAULT 0,
|
|
PRIMARY KEY (`rowid`),
|
|
UNIQUE KEY `rowid_UNIQUE` (`rowid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `y_modules_rules`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `y_modules_rules`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `y_modules_rules` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`fk_module` int(11) DEFAULT 0,
|
|
`libelle` varchar(30) NOT NULL DEFAULT '',
|
|
`tip` varchar(250) NOT NULL DEFAULT '',
|
|
`val_default` varchar(20) NOT NULL DEFAULT '',
|
|
`ce_apa` varchar(20) DEFAULT '',
|
|
`ce_csfouest` varchar(20) DEFAULT '',
|
|
`ce_demo` varchar(20) DEFAULT '',
|
|
`ce_natixis` varchar(20) DEFAULT '',
|
|
`ce_purina` varchar(20) DEFAULT '',
|
|
`ce_tfn44` varchar(20) DEFAULT '',
|
|
`ce_webasto` varchar(20) DEFAULT '',
|
|
`active` tinyint(1) NOT NULL DEFAULT 1,
|
|
PRIMARY KEY (`rowid`),
|
|
UNIQUE KEY `y_modules_regles_rowid_uindex` (`rowid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `y_pages`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `y_pages`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `y_pages` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`libelle` varchar(45) DEFAULT NULL,
|
|
`titre` varchar(75) DEFAULT NULL,
|
|
`tooltip` varchar(45) DEFAULT NULL,
|
|
`description` varchar(200) DEFAULT NULL,
|
|
`keywords` varchar(200) DEFAULT NULL,
|
|
`script` varchar(45) DEFAULT NULL,
|
|
`enmaintenance` tinyint(1) DEFAULT 0,
|
|
`admin` tinyint(1) DEFAULT 0,
|
|
`mail` tinyint(1) DEFAULT 0,
|
|
`admtools` tinyint(1) DEFAULT 0,
|
|
`magazine` tinyint(1) DEFAULT 0,
|
|
`files` tinyint(1) DEFAULT 1,
|
|
`maps` tinyint(1) DEFAULT 0,
|
|
`editor` tinyint(1) DEFAULT 0,
|
|
`jqui` tinyint(1) DEFAULT 0,
|
|
`form` tinyint(1) DEFAULT 0,
|
|
`sidebar` tinyint(1) DEFAULT 0,
|
|
`chart` tinyint(1) DEFAULT 0,
|
|
`agenda` tinyint(1) DEFAULT 0,
|
|
`scheduler` tinyint(1) DEFAULT 0,
|
|
`osm` tinyint(1) DEFAULT 0,
|
|
`zz` tinyint(1) DEFAULT 0,
|
|
`maintenance` tinyint(1) DEFAULT 0,
|
|
`layout` varchar(45) DEFAULT 'default.php',
|
|
`active` tinyint(1) DEFAULT 1,
|
|
PRIMARY KEY (`rowid`),
|
|
UNIQUE KEY `rowid_UNIQUE` (`rowid`),
|
|
KEY `script` (`script`),
|
|
KEY `admin` (`admin`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `z_logs`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `z_logs`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `z_logs` (
|
|
`date` datetime NOT NULL,
|
|
`ip` varchar(15) NOT NULL,
|
|
`host` varchar(50) NOT NULL,
|
|
`adrhost` varchar(50) NOT NULL,
|
|
`infos` varchar(200) DEFAULT '',
|
|
`fk_user` int(11) DEFAULT 0,
|
|
`page` varchar(200) NOT NULL,
|
|
`commentaire` text NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Table des logs' `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `z_sessions`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `z_sessions`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `z_sessions` (
|
|
`sid` text NOT NULL,
|
|
`fk_user` int(11) NOT NULL,
|
|
`role` varchar(10) DEFAULT NULL,
|
|
`date_modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
|
|
`ip` varchar(50) NOT NULL,
|
|
`browser` varchar(150) NOT NULL,
|
|
`data` mediumtext DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `z_stats`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `z_stats`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `z_stats` (
|
|
`rowid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`libelle` varchar(75) DEFAULT NULL,
|
|
`fk_user` int(11) DEFAULT NULL,
|
|
`date` datetime DEFAULT NULL,
|
|
`ip` varchar(15) DEFAULT NULL,
|
|
`browser` varchar(75) DEFAULT NULL,
|
|
`origine` varchar(45) DEFAULT NULL,
|
|
`status` varchar(10) DEFAULT NULL,
|
|
`active` tinyint(1) DEFAULT NULL,
|
|
PRIMARY KEY (`rowid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=215481 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci `PAGE_COMPRESSED`='ON';
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
|
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
|
/*!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 */;
|
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|
|
|
-- Dump completed on 2025-10-02 17:31:13
|