-- MySQL dump 10.13 Distrib 8.0.21, for Win64 (x86_64) -- -- Host: localhost Database: elan_europ_production2 -- ------------------------------------------------------ -- Server version 8.0.21 /*!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 */; /*!50503 SET NAMES utf8 */; /*!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 `activity` -- DROP TABLE IF EXISTS `activity`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `activity` ( `act_id` int NOT NULL AUTO_INCREMENT, `act_code` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `act_nameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `act_active` tinyint(1) NOT NULL DEFAULT '1', `act_createdDate` timestamp NULL DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `act_updatedDate` datetime DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `act_deleted` int NOT NULL DEFAULT '0', `act_correspondance` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`act_id`) ) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `activity_detail` -- DROP TABLE IF EXISTS `activity_detail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `activity_detail` ( `actDet_id` bigint unsigned NOT NULL AUTO_INCREMENT, `act_id` int NOT NULL, `actDet_code` varchar(2) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `actDet_nameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `actDet_active` int NOT NULL DEFAULT '0', `actDet_createdDate` timestamp NULL DEFAULT NULL, `actDet_updatedDate` timestamp NULL DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `actDet_equipment` int NOT NULL DEFAULT '0', PRIMARY KEY (`actDet_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `article` -- DROP TABLE IF EXISTS `article`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `article` ( `art_id` int NOT NULL AUTO_INCREMENT, `art_ordre` int NOT NULL DEFAULT '0', `art_code` int DEFAULT NULL, `art_nameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `art_active` tinyint(1) NOT NULL DEFAULT '1', `art_createdDate` timestamp NULL DEFAULT NULL, `art_updatedDate` datetime DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `art_costPrice` decimal(10,2) DEFAULT NULL, `art_selPrice` decimal(10,2) DEFAULT NULL, `art_coef` decimal(10,2) DEFAULT NULL, `art_brand` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `art_supplierReference` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `art_reference` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`art_id`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `article_quote` -- DROP TABLE IF EXISTS `article_quote`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `article_quote` ( `artQuo_id` bigint unsigned NOT NULL AUTO_INCREMENT, `art_id` int DEFAULT NULL, `element_id` int DEFAULT NULL, `artQuo_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `artQuo_amountHt` double(8,2) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`artQuo_id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `authorised_ip` -- DROP TABLE IF EXISTS `authorised_ip`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `authorised_ip` ( `autIp_id` bigint unsigned NOT NULL AUTO_INCREMENT, `autIp_ipValue` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `autIp_active` int NOT NULL DEFAULT '0', `use_idCreator` int DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `autIp_createdDate` timestamp NULL DEFAULT NULL, `autIp_updatedDate` timestamp NULL DEFAULT NULL, `autIp_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `autIp_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`autIp_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2535 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `billingcompany` -- DROP TABLE IF EXISTS `billingcompany`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `billingcompany` ( `bil_id` int NOT NULL AUTO_INCREMENT, `bil_socialReason` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `bil_address1` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `bil_address2` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `cou_id` int NOT NULL, `bil_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `bil_fax` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `bil_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `tva_id` int DEFAULT NULL, `bil_comment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `bil_siret` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `bil_tvaIntra` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `payPer_id` int DEFAULT NULL, `bil_paymentPeriod` int DEFAULT NULL, `bil_active` tinyint(1) NOT NULL DEFAULT '1', `cus_id` int NOT NULL, `bil_createdDate` timestamp NULL DEFAULT NULL, `bil_updatedDate` datetime DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `bil_compteComptable` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `bil_deleted` int NOT NULL DEFAULT '0', `bil_zipCode` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `bil_city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`bil_id`) ) ENGINE=InnoDB AUTO_INCREMENT=432 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `bordereaux` -- DROP TABLE IF EXISTS `bordereaux`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `bordereaux` ( `bor_id` int unsigned NOT NULL AUTO_INCREMENT, `cus_id` int NOT NULL, `bil_id` int NOT NULL, `bor_createdDate` timestamp NOT NULL, `bor_updatedDate` timestamp NULL DEFAULT NULL, `bor_invoiceCount` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `bor_totalAmountHT` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `bor_totalAmountTTC` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`bor_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `call_incoming_outgoing` -- DROP TABLE IF EXISTS `call_incoming_outgoing`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `call_incoming_outgoing` ( `CalIncOut_id` bigint unsigned NOT NULL AUTO_INCREMENT, `CalIncOut_caller` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `CalIncOut_receiver` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `CalIncOut_statut` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `CalIncOut_sonnerie` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `CalIncOut_conversation` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `CalIncOut_totals` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `CalIncOut_cost` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `CalIncOut_reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `CalIncOut_play` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `CalIncOut_date` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `CalIncOut_createdDate` timestamp NOT NULL, `CalIncOut_updatedDate` date DEFAULT NULL, `use_idCreator` int DEFAULT NULL, PRIMARY KEY (`CalIncOut_id`) ) ENGINE=InnoDB AUTO_INCREMENT=150065 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `city` -- DROP TABLE IF EXISTS `city`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `city` ( `cit_id` int NOT NULL AUTO_INCREMENT, `cit_name` varchar(30) DEFAULT NULL, `cit_zc` varchar(10) DEFAULT NULL, `dep_id` int DEFAULT NULL, `reg_id` int DEFAULT NULL, `cou_id` int NOT NULL, `cit_updatedDate` datetime DEFAULT NULL, `use_idUpdater` int NOT NULL, `com_idUpdater` int NOT NULL, `cit_createdDate` timestamp NULL DEFAULT NULL, `use_idCreator` int NOT NULL, `com_idCreator` int NOT NULL, PRIMARY KEY (`cit_id`), KEY `CPC` (`cit_zc`), KEY `NomC` (`cit_name`) ) ENGINE=InnoDB AUTO_INCREMENT=37043 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `contact` -- DROP TABLE IF EXISTS `contact`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `contact` ( `con_id` int NOT NULL AUTO_INCREMENT, `con_firstname` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `con_lastname` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `con_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sig_id` int NOT NULL DEFAULT '0', `sit_id` int NOT NULL DEFAULT '0', `con_createdDate` timestamp NULL DEFAULT NULL, `con_updatedDate` datetime DEFAULT NULL, `use_idCreator` int NOT NULL, `use_idUpdater` int NOT NULL, `con_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `con_fonction` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `con_comment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `cus_id` int DEFAULT NULL, `pro_id` int DEFAULT NULL, PRIMARY KEY (`con_id`) ) ENGINE=InnoDB AUTO_INCREMENT=928 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `contract` -- DROP TABLE IF EXISTS `contract`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `contract` ( `con_id` bigint unsigned NOT NULL AUTO_INCREMENT, `con_startDate` date DEFAULT NULL, `con_endDate` date DEFAULT NULL, `con_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `con_deleted` int NOT NULL DEFAULT '0', `con_createdDate` date DEFAULT NULL, `con_updatedDate` date DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `con_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `con_refNumber` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `con_nbDiPrev` int DEFAULT NULL, `con_type` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'P', `con_typeContract` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'P', `cus_id` int NOT NULL, `con_estimatedCa` double(8,2) DEFAULT NULL, PRIMARY KEY (`con_id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `contract_file` -- DROP TABLE IF EXISTS `contract_file`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `contract_file` ( `conFil_id` bigint unsigned NOT NULL AUTO_INCREMENT, `con_id` int NOT NULL, `conFil_description` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `conFil_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `conFil_oldName` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `conFil_ext` varchar(4) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `conFil_createdDate` date DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `conFil_updatedDate` date DEFAULT NULL, `conFil_visibleProvider` int NOT NULL DEFAULT '1', `conFil_visibleSite` int NOT NULL DEFAULT '1', PRIMARY KEY (`conFil_id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `contract_invoice` -- DROP TABLE IF EXISTS `contract_invoice`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `contract_invoice` ( `conInv_id` bigint unsigned NOT NULL AUTO_INCREMENT, `con_id` int NOT NULL, `conInv_description` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `conInv_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `conInv_oldName` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `conInv_ext` varchar(4) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `conInv_intNb` int NOT NULL DEFAULT '0', `conInv_intList` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `conInv_amountHt` double(8,2) NOT NULL DEFAULT '0.00', `conInv_amountTtc` double(8,2) NOT NULL DEFAULT '0.00', `conInv_createdDate` date DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `conInv_updatedDate` date DEFAULT NULL, PRIMARY KEY (`conInv_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `country` -- DROP TABLE IF EXISTS `country`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `country` ( `cou_id` int NOT NULL AUTO_INCREMENT, `cou_nameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `cou_nameEn` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `cou_indicative` smallint NOT NULL, `cou_updatedDate` datetime DEFAULT NULL, `use_idUpdater` int NOT NULL, `com_idUpdater` int NOT NULL, `cou_createdDate` timestamp NULL DEFAULT NULL, `use_idCreator` int NOT NULL, `com_idCreator` int NOT NULL, PRIMARY KEY (`cou_id`) ) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `customer` -- DROP TABLE IF EXISTS `customer`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `customer` ( `cus_id` int NOT NULL AUTO_INCREMENT, `cus_socialReason` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `cus_address1` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `cus_address2` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `cou_id` int NOT NULL, `cus_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `cus_mobile` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `cus_fax` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `cus_prices` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `cus_active` tinyint(1) NOT NULL DEFAULT '1', `cus_createdDate` timestamp NULL DEFAULT NULL, `cus_updatedDate` datetime DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `cus_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `cus_zipCode` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `cus_city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `cus_comments` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `cus_juridicForm` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `cus_emailCompta` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`cus_id`), KEY `id` (`cus_id`) ) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `customer_invoice` -- DROP TABLE IF EXISTS `customer_invoice`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `customer_invoice` ( `cusInv_id` int NOT NULL AUTO_INCREMENT, `int_id` int NOT NULL, `cusInv_number` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `cusInv_achievementDate` date DEFAULT NULL, `cusInv_deadlineDate` date DEFAULT NULL, `cusInv_payed` int NOT NULL DEFAULT '0', `cusInv_paymentDate` date DEFAULT NULL, `cusInv_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `sta_id` int NOT NULL, `cusInv_amountHT` decimal(10,2) NOT NULL, `cusInv_tva` decimal(5,2) NOT NULL, `cusInv_amountTTC` decimal(10,2) NOT NULL, `use_idCreator` int DEFAULT NULL, `cusQuo_id` int NOT NULL DEFAULT '0', `cusInv_comment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `cusInv_createdDate` timestamp NULL DEFAULT NULL, `cusInv_updatedDate` datetime DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `cusInv_exported` int NOT NULL DEFAULT '0', `cusInv_exportedDate` datetime DEFAULT NULL, `cusInv_sended` tinyint unsigned DEFAULT NULL, `cusInv_dateSendedMailInvoice` datetime DEFAULT NULL, `tva_id` int DEFAULT NULL, `bil_id` int DEFAULT '0', `cusInv_lastRelaunchDate` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `cusInv_exportUserId` int DEFAULT NULL, `bor_id` int DEFAULT NULL, PRIMARY KEY (`cusInv_id`), KEY `cusQuo_id` (`cusQuo_id`), KEY `int_id` (`int_id`) ) ENGINE=InnoDB AUTO_INCREMENT=29488 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `customer_invoice_detail` -- DROP TABLE IF EXISTS `customer_invoice_detail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `customer_invoice_detail` ( `cusInvDet_id` bigint unsigned NOT NULL AUTO_INCREMENT, `cusInv_id` int NOT NULL, `art_id` int DEFAULT NULL, `cusInvDet_order` int DEFAULT NULL, `cusInvDet_name` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `cusInvDet_qty` decimal(10,2) DEFAULT '0.00', `cusInvDet_amountHT` decimal(10,2) DEFAULT '0.00', `cusInvDet_title` int NOT NULL DEFAULT '0', `cusInvDet_unit` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `cusInvDet_createdDate` datetime DEFAULT NULL, `cusInvDet_updatedDate` datetime DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `use_idCreator` int DEFAULT NULL, PRIMARY KEY (`cusInvDet_id`) ) ENGINE=InnoDB AUTO_INCREMENT=96427 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `customer_quote` -- DROP TABLE IF EXISTS `customer_quote`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `customer_quote` ( `cusQuo_id` int NOT NULL AUTO_INCREMENT, `int_id` int DEFAULT NULL, `cusQuo_number` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `cusQuo_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `cusQuo_achievementDate` date DEFAULT NULL, `cusQuo_replyDate` datetime DEFAULT NULL, `cusQuo_raisonRefus` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `sta_id` int DEFAULT NULL, `cusQuo_amountHT` decimal(10,2) DEFAULT NULL, `cusQuo_tva` decimal(5,2) DEFAULT NULL, `cusQuo_amountTTC` decimal(10,2) DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `cusInv_id` int DEFAULT '0', `cusQuo_createdDate` timestamp NULL DEFAULT NULL, `cusQuo_updatedDate` datetime DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `intFil_id_bpa` int DEFAULT NULL, `cusQuo_sended` tinyint unsigned DEFAULT NULL, `tva_id` int DEFAULT NULL, `cusQuo_conditions` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `cusQuo_sendedDate` date DEFAULT NULL, `cusQuo_lastRelaunchDate` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`cusQuo_id`), KEY `cusInv_id` (`cusInv_id`), KEY `int_id` (`int_id`) ) ENGINE=InnoDB AUTO_INCREMENT=20633 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `customer_quote_detail` -- DROP TABLE IF EXISTS `customer_quote_detail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `customer_quote_detail` ( `cusQuoDet_id` int NOT NULL AUTO_INCREMENT, `cusQuo_id` int NOT NULL, `cusInv_id` int NOT NULL DEFAULT '0', `art_id` int DEFAULT '0', `cusQuoDet_order` int DEFAULT NULL, `cusQuoDet_name` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `cusQuoDet_qty` decimal(10,2) DEFAULT '0.00', `cusQuoDet_amountHT` decimal(10,2) DEFAULT '0.00', `cusQuoDet_title` int DEFAULT '0', `cusQuoDet_unit` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `cusQuoDet_createdDate` datetime DEFAULT NULL, `cusQuoDet_updatedDate` datetime DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, PRIMARY KEY (`cusQuoDet_id`), KEY `cusQuo_id` (`cusQuo_id`), KEY `cusInv_id` (`cusInv_id`) ) ENGINE=InnoDB AUTO_INCREMENT=123313 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `customer_quote_detail_type` -- DROP TABLE IF EXISTS `customer_quote_detail_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `customer_quote_detail_type` ( `cusQuoDetTyp_id` bigint unsigned NOT NULL AUTO_INCREMENT, `cusQuoTyp_id` int DEFAULT NULL, `art_id` int DEFAULT NULL, `cusQuoDetTyp_order` int DEFAULT NULL, `cusQuoDetTyp_name` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `cusQuoDetTyp_qty` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `cusQuoDetTyp_amountHT` decimal(10,2) DEFAULT NULL, `cusQuoDetTyp_title` int DEFAULT NULL, `cusQuoDetTyp_unit` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `cusQuoDetTyp_createdDate` date DEFAULT NULL, `cusQuoDetTyp_updatedDate` date DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, PRIMARY KEY (`cusQuoDetTyp_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `customer_quote_type` -- DROP TABLE IF EXISTS `customer_quote_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `customer_quote_type` ( `cusQuoTyp_id` bigint unsigned NOT NULL AUTO_INCREMENT, `cusQuoTyp_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `cusQuoTyp_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `cusQuoTyp_amountHT` decimal(10,2) DEFAULT NULL, `cusQuoTyp_tva` decimal(5,2) DEFAULT NULL, `cusQuoTyp_amountTTC` decimal(10,2) DEFAULT NULL, `tva_id` int DEFAULT NULL, `cusQuoTyp_conditions` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `cusQuoTyp_createdDate` date DEFAULT NULL, `cusQuoTyp_updatedDate` date DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `cusQuoDetTyp_default` int DEFAULT '0', PRIMARY KEY (`cusQuoTyp_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `departement` -- DROP TABLE IF EXISTS `departement`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `departement` ( `dep_id` int NOT NULL AUTO_INCREMENT, `dep_code` char(3) NOT NULL DEFAULT '', `dep_name` varchar(255) DEFAULT NULL, `reg_id` int DEFAULT NULL, `cou_id` int NOT NULL, PRIMARY KEY (`dep_id`), KEY `Reference` (`reg_id`) ) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `divers` -- DROP TABLE IF EXISTS `divers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `divers` ( `div_id` int NOT NULL AUTO_INCREMENT, `div_order` tinyint NOT NULL, `div_abbrFr` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `div_abbrEn` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `div_libelleFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `div_libelleEn` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `div_texteFr` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `div_texteEn` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `div_active` tinyint(1) NOT NULL DEFAULT '1', `div_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `div_endMonth` tinyint NOT NULL, `div_defaut` tinyint(1) NOT NULL, `men_id` int NOT NULL, `div_value` int DEFAULT NULL, `div_updatedDate` datetime DEFAULT NULL, `div_createdDate` datetime DEFAULT NULL, `div_color` varchar(7) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `use_idCreator` int NOT NULL, `com_idCreator` int NOT NULL, `use_idUpdater` int NOT NULL, `com_idUpdater` int NOT NULL, PRIMARY KEY (`div_id`) ) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `equipment` -- DROP TABLE IF EXISTS `equipment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `equipment` ( `equ_id` bigint unsigned NOT NULL AUTO_INCREMENT, `act_id` int NOT NULL, `actDet_id` int DEFAULT NULL, `equ_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `equ_mark` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `equ_reference` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `equ_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `equ_createdDate` timestamp NULL DEFAULT NULL, `equ_updatedDate` timestamp NULL DEFAULT NULL, `use_idCreator` int DEFAULT NULL, PRIMARY KEY (`equ_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `equipment_site` -- DROP TABLE IF EXISTS `equipment_site`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `equipment_site` ( `equSit_id` bigint unsigned NOT NULL AUTO_INCREMENT, `equ_id` int NOT NULL, `sit_id` int NOT NULL, `equSit_serialNumber` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `equSit_internalNumber` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `equSit_nextActionDate` date DEFAULT NULL, `equSit_endGuaranteeDate` date DEFAULT NULL, `equSit_installDate` timestamp NULL DEFAULT NULL, `equSit_active` int NOT NULL DEFAULT '1', PRIMARY KEY (`equSit_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `failed_jobs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `connection` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `queue` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `payload` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `exception` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `failed_jobs_uuid_index` (`uuid`) ) ENGINE=InnoDB AUTO_INCREMENT=682 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `import_cusinv` -- DROP TABLE IF EXISTS `import_cusinv`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `import_cusinv` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `id_import` int NOT NULL DEFAULT '0', `int_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `cusInv_amountHT` double(8,2) DEFAULT NULL, `cusInv_amountTTC` double(8,2) DEFAULT NULL, `comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `staImp_id` int NOT NULL DEFAULT '0', `importable` int NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `import_int_cloturecompta` -- DROP TABLE IF EXISTS `import_int_cloturecompta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `import_int_cloturecompta` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `id_import` int NOT NULL DEFAULT '0', `int_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `importable` int NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `import_majcusinv` -- DROP TABLE IF EXISTS `import_majcusinv`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `import_majcusinv` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `id_import` int NOT NULL DEFAULT '0', `cusInv_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `cusInv_amountHT` double(8,2) DEFAULT NULL, `cusInv_paymentDate` date DEFAULT NULL, `comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `staImp_id` int NOT NULL DEFAULT '0', `importable` int NOT NULL DEFAULT '0', `cusInv_reglee` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `import_majproinv` -- DROP TABLE IF EXISTS `import_majproinv`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `import_majproinv` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `id_import` int NOT NULL DEFAULT '0', `proInv_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `proInv_amountHT` double(8,2) DEFAULT NULL, `proInv_paymentDate` date DEFAULT NULL, `comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `staImp_id` int NOT NULL DEFAULT '0', `importable` int NOT NULL DEFAULT '0', `proInv_reglee` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `import_proinv` -- DROP TABLE IF EXISTS `import_proinv`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `import_proinv` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `id_import` int NOT NULL DEFAULT '0', `proReq_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `proInv_amountHT` double(8,2) DEFAULT NULL, `proInv_amountTTC` double(8,2) DEFAULT NULL, `provider_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `staImp_id` int NOT NULL DEFAULT '0', `importable` int NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `intervention` -- DROP TABLE IF EXISTS `intervention`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `intervention` ( `int_id` int NOT NULL AUTO_INCREMENT, `int_nextId` int DEFAULT NULL, `int_number` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `sta_id` int NOT NULL, `cus_id` int NOT NULL, `sig_id` int NOT NULL, `sit_id` int NOT NULL, `bil_id` int DEFAULT NULL, `act_id` int NOT NULL, `int_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `int_desiredPlanningDate` date DEFAULT NULL, `int_closingDate` date DEFAULT NULL, `int_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `int_customerRef` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `int_category` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `int_idLinked` int DEFAULT NULL, `int_urgency` int DEFAULT '0', `int_complex` int DEFAULT '0', `int_astreinte` int DEFAULT '0', `int_updatedDate` datetime DEFAULT NULL, `int_createdDate` datetime DEFAULT NULL, `estRat_id` int DEFAULT NULL, `int_estimatedRate` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `int_excludeCA` int DEFAULT '0', `int_contractNumber` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `int_contact` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `use_idCreator` int DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `int_type` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `pro_idAssigned` int DEFAULT NULL, `use_idAssigned` int DEFAULT NULL, `use_idAgentAssigned` int DEFAULT NULL, `int_amountHT` double(8,2) DEFAULT NULL, `int_planningDate` date DEFAULT NULL, `int_deleted` int NOT NULL DEFAULT '0', `int_qualControlDate` date DEFAULT NULL, `int_prevId` int DEFAULT NULL, `actDet_id` int DEFAULT NULL, `int_achievementDate` date DEFAULT NULL, `con_id` int DEFAULT NULL, `int_travaux` int NOT NULL DEFAULT '0', `int_closed` int NOT NULL DEFAULT '0', `int_refused` int NOT NULL DEFAULT '0', `int_linkKey_provider` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `int_datePossible` date DEFAULT NULL, `int_dateLater` date DEFAULT NULL, `sitCon_id` int DEFAULT NULL, `int_clotureCompta` tinyint(1) DEFAULT '0', `int_dateClotureCompta` datetime DEFAULT NULL, `int_linkKey_customer` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `gcalendarEventId` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `wor_id` int DEFAULT NULL, `int_conStartDate` date DEFAULT NULL, `int_conEndDate` date DEFAULT NULL, `conInv_id` int DEFAULT NULL, `int_gpType` int DEFAULT '0', `int_archived` int DEFAULT '0', PRIMARY KEY (`int_id`), KEY `idx_int_type` (`int_type`), KEY `idx_int_statut` (`sta_id`), KEY `idx_int_site` (`sit_id`) ) ENGINE=InnoDB AUTO_INCREMENT=44292 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `intervention_connexion` -- DROP TABLE IF EXISTS `intervention_connexion`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `intervention_connexion` ( `intCon_id` int NOT NULL AUTO_INCREMENT, `int_id` int NOT NULL, `useLog_id` int NOT NULL, `intCon_createdDate` datetime NOT NULL, `intCon_updatedDate` datetime NOT NULL, `use_idCreator` int NOT NULL, `use_idUpdater` int NOT NULL, PRIMARY KEY (`intCon_id`), KEY `int_conne_int_id` (`int_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1041673 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `intervention_detail` -- DROP TABLE IF EXISTS `intervention_detail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `intervention_detail` ( `intDet_id` bigint unsigned NOT NULL AUTO_INCREMENT, `int_id` int NOT NULL, `use_idAssigned` int DEFAULT NULL, `pro_idAssigned` int DEFAULT NULL, `intDet_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `intDet_startDate` date DEFAULT NULL, `intDet_endDate` date DEFAULT NULL, `intDet_startHour` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `intDet_endHour` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `intDet_nbMinutes` int DEFAULT NULL, `intDet_createdDate` date DEFAULT NULL, `intDet_updatedDate` date DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, PRIMARY KEY (`intDet_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `intervention_equipment` -- DROP TABLE IF EXISTS `intervention_equipment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `intervention_equipment` ( `intEqu_id` bigint unsigned NOT NULL AUTO_INCREMENT, `equSit_id` int NOT NULL DEFAULT '0', `int_id` int NOT NULL, `intEqu_comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`intEqu_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `intervention_file` -- DROP TABLE IF EXISTS `intervention_file`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `intervention_file` ( `intFil_id` int NOT NULL AUTO_INCREMENT, `int_id` int NOT NULL DEFAULT '0', `intFil_name` varchar(255) NOT NULL DEFAULT '', `intFil_oldName` varchar(255) NOT NULL DEFAULT '', `intFil_ext` varchar(4) NOT NULL, `cat_id` int NOT NULL DEFAULT '0', `intFil_visibleCustomer` tinyint NOT NULL DEFAULT '0', `intFil_createdDate` timestamp NULL DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `intFil_updatedDate` datetime DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `intFil_description` varchar(255) DEFAULT NULL, `intFil_size` int DEFAULT NULL, `intFil_visibleProvider` int NOT NULL DEFAULT '0', PRIMARY KEY (`intFil_id`), KEY `int_id` (`int_id`) ) ENGINE=InnoDB AUTO_INCREMENT=249894 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `intervention_file_category` -- DROP TABLE IF EXISTS `intervention_file_category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `intervention_file_category` ( `intFilCat_id` bigint unsigned NOT NULL AUTO_INCREMENT, `intFilCat_order` int NOT NULL, `intFilCat_nameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `intFilCat_nameEn` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `intFilCat_active` int DEFAULT NULL, `intFilCat_updatedDate` datetime DEFAULT NULL, `intFilCat_createdDate` datetime DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `intFilCat_deleted` int DEFAULT NULL, `intFilCat_oldId` int DEFAULT NULL, `intFilCat_valParam` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `intFilCat_correspondance` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `intFilCat_forWorksites` int DEFAULT '1', PRIMARY KEY (`intFilCat_id`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `intervention_log` -- DROP TABLE IF EXISTS `intervention_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `intervention_log` ( `intLog_id` int NOT NULL AUTO_INCREMENT, `int_id` int NOT NULL, `intLog_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `intLog_texte` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `use_id` int NOT NULL, `intLog_createdDate` timestamp NULL DEFAULT NULL, `sta_id` int DEFAULT NULL, PRIMARY KEY (`intLog_id`), KEY `int_id` (`int_id`), KEY `use_id` (`use_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1692048 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `intervention_message` -- DROP TABLE IF EXISTS `intervention_message`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `intervention_message` ( `intMes_id` int NOT NULL AUTO_INCREMENT, `use_id` int DEFAULT NULL, `intMes_private` int DEFAULT '0', `intMes_to` varchar(1000) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `intMes_object` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `intMes_texte` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci, `int_id` int DEFAULT NULL, `intMes_updatedDate` datetime DEFAULT NULL, `intMes_createdDate` timestamp NULL DEFAULT NULL, `use_idCreator` int NOT NULL, `intMes_deleted` int DEFAULT '0', `intMes_attachHistory` int DEFAULT '0', `intMes_customer` int DEFAULT '0', `intMes_compta` int DEFAULT '0', `intMes_cc` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `intMes_moreAddresses` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `intMes_note` int DEFAULT '0', `intMes_noteDone` int DEFAULT '0', `intMes_noteAlertDate` date DEFAULT NULL, `intMess_noteUserAssigned` int DEFAULT NULL, `intMes_visibleTech` int NOT NULL DEFAULT '1', `intMes_pin` int DEFAULT '0', `intMes_provider` int DEFAULT '0', PRIMARY KEY (`intMes_id`), KEY `use_id` (`use_id`), KEY `int_id` (`int_id`), KEY `intMess_noteUserAssigned` (`intMess_noteUserAssigned`), KEY `use_idCreator` (`use_idCreator`) ) ENGINE=InnoDB AUTO_INCREMENT=819407 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `intervention_status_group` -- DROP TABLE IF EXISTS `intervention_status_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `intervention_status_group` ( `intStaGro_id` int NOT NULL AUTO_INCREMENT, `intStaGro_order` tinyint NOT NULL, `intStaGro_libelleFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `intStaGro_active` tinyint(1) NOT NULL DEFAULT '1', `intStaGro_isCustomer` tinyint(1) NOT NULL DEFAULT '0', `intStaGro_createdDate` timestamp NULL DEFAULT NULL, `intStaGro_updatedDate` datetime DEFAULT NULL, `use_idUpdater` int NOT NULL, `com_idUpdater` int NOT NULL, `use_idCreator` int NOT NULL, `com_idCreator` int NOT NULL, PRIMARY KEY (`intStaGro_id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `jobs` -- DROP TABLE IF EXISTS `jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `jobs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `payload` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `attempts` tinyint unsigned NOT NULL, `reserved_at` int unsigned DEFAULT NULL, `available_at` int unsigned NOT NULL, `created_at` int unsigned NOT NULL, PRIMARY KEY (`id`), KEY `jobs_queue_index` (`queue`) ) ENGINE=InnoDB AUTO_INCREMENT=184901 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `langue` -- DROP TABLE IF EXISTS `langue`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `langue` ( `lan_id` smallint unsigned NOT NULL AUTO_INCREMENT, `lan_libelle` varchar(50) NOT NULL DEFAULT '', `lan_abbr` varchar(5) NOT NULL DEFAULT '', `lan_picto` varchar(255) NOT NULL DEFAULT '', `lan_actif` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`lan_id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `legal_status` -- DROP TABLE IF EXISTS `legal_status`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `legal_status` ( `legSta_id` bigint unsigned NOT NULL AUTO_INCREMENT, `legSta_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `legSta_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`legSta_id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `migrations` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `batch` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=146 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `model_has_permissions` -- DROP TABLE IF EXISTS `model_has_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `model_has_permissions` ( `permission_id` bigint unsigned NOT NULL, `model_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `model_id` bigint unsigned NOT NULL, PRIMARY KEY (`permission_id`,`model_id`,`model_type`), KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`), CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `model_has_roles` -- DROP TABLE IF EXISTS `model_has_roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `model_has_roles` ( `role_id` bigint unsigned NOT NULL, `model_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `model_id` bigint unsigned NOT NULL, PRIMARY KEY (`role_id`,`model_id`,`model_type`), KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`), CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `notifications` -- DROP TABLE IF EXISTS `notifications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `notifications` ( `id` char(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `notifiable_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `notifiable_id` bigint unsigned NOT NULL, `data` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `read_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `notifications_user` -- DROP TABLE IF EXISTS `notifications_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `notifications_user` ( `use_id` char(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `create_user` int NOT NULL DEFAULT '0', `add_proQuo_presta` int NOT NULL DEFAULT '0', `int_planification_presta` int NOT NULL DEFAULT '0', `int_realisation_presta` int NOT NULL DEFAULT '0', `add_int_site` int NOT NULL DEFAULT '0', `add_int_message` int NOT NULL DEFAULT '0', PRIMARY KEY (`use_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `parameter` -- DROP TABLE IF EXISTS `parameter`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `parameter` ( `par_id` bigint unsigned NOT NULL AUTO_INCREMENT, `par_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `par_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `par_descriptionFr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `par_descriptionEn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `par_value` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`par_id`) ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `payment_periods` -- DROP TABLE IF EXISTS `payment_periods`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `payment_periods` ( `payPer_id` bigint unsigned NOT NULL AUTO_INCREMENT, `payPer_order` int NOT NULL DEFAULT '0', `payPer_nameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `payPer_nameEn` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `payPer_value` int DEFAULT NULL, `payPer_endMonth` int NOT NULL DEFAULT '0', `payPer_dayNextMonth` int DEFAULT NULL, `payPer_active` int DEFAULT NULL, `payPer_updatedDate` datetime DEFAULT NULL, `payPer_createdDate` datetime DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `payPer_deleted` int DEFAULT NULL, PRIMARY KEY (`payPer_id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `permissions` -- DROP TABLE IF EXISTS `permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `permissions` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `guard_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `prospect` -- DROP TABLE IF EXISTS `prospect`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `prospect` ( `pro_id` bigint unsigned NOT NULL AUTO_INCREMENT, `pro_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_synonymous` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_nature` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_group` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_address1` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_address2` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_zipCode` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_fax` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_web` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_actions` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_comments` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_request` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `pro_descStatus` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_dateActionComm` date DEFAULT NULL, `pro_dateActiontech` date DEFAULT NULL, `pro_createdDate` datetime DEFAULT NULL, `pro_updatedDate` datetime DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, PRIMARY KEY (`pro_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `provider` -- DROP TABLE IF EXISTS `provider`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `provider` ( `pro_id` int NOT NULL AUTO_INCREMENT, `pro_socialReason` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `pro_siret` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_address1` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_address2` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `cou_id` int DEFAULT NULL, `pro_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_mobile` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_fax` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_active` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', `pro_lat` decimal(11,8) DEFAULT NULL, `pro_lng` decimal(11,8) DEFAULT NULL, `pro_formattedAddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_maxInterventionInProgress` int DEFAULT NULL, `pro_prices` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `pro_comment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `pro_private` tinyint(1) NOT NULL DEFAULT '1', `pro_createdDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `pro_updatedDate` datetime DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `pro_forceCoordonnate` int NOT NULL DEFAULT '0', `pro_zipCode` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_tvaDefault` int DEFAULT '1', `pro_satisfactionQuality` int DEFAULT NULL, `pro_deleted` int NOT NULL DEFAULT '0', `pro_numTva` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_apeCode` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_juridicForm` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_autoEntrep` int NOT NULL DEFAULT '0', `pro_numberCompta` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_astreinte` int NOT NULL DEFAULT '0', `pro_urgency` int NOT NULL DEFAULT '0', `pro_satisfactionReactivity` decimal(5,2) DEFAULT NULL, `pro_satisfactionPrice` decimal(5,2) DEFAULT NULL, `pro_satisfactionPunctuality` decimal(5,2) DEFAULT NULL, `pro_satisfactionPresentation` decimal(5,2) DEFAULT NULL, `pro_satisfactionDetails` decimal(5,2) DEFAULT NULL, `pro_ribIban` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_ribBic` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_ribDomiciliation` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_docsUpToDate` int NOT NULL DEFAULT '0', `pro_caLastYear` int DEFAULT NULL, `pro_caElan` int DEFAULT NULL, `pro_externalCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_contactName` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `pro_emailCompta` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `payPer_id` int DEFAULT NULL, PRIMARY KEY (`pro_id`) ) ENGINE=InnoDB AUTO_INCREMENT=9107 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `provider_defaults` -- DROP TABLE IF EXISTS `provider_defaults`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `provider_defaults` ( `proDef_id` bigint unsigned NOT NULL AUTO_INCREMENT, `pro_id` int NOT NULL, `act_ids` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `proDef_createdDate` timestamp NULL DEFAULT NULL, `proDef_updatedDate` timestamp NULL DEFAULT NULL, `dep_ids` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, PRIMARY KEY (`proDef_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `provider_file` -- DROP TABLE IF EXISTS `provider_file`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `provider_file` ( `proFil_id` int NOT NULL AUTO_INCREMENT, `pro_id` int NOT NULL DEFAULT '0', `proFil_name` varchar(255) NOT NULL DEFAULT '', `proFil_oldName` varchar(255) NOT NULL DEFAULT '', `proFil_ext` varchar(4) NOT NULL, `cat_id` int NOT NULL DEFAULT '0', `proFil_dueDate` date DEFAULT NULL, `proFil_createdDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `use_idCreator` int NOT NULL, `proFil_updatedDate` timestamp NULL DEFAULT NULL, `proFil_description` varchar(255) DEFAULT NULL, `proFil_obligatory` tinyint(1) DEFAULT '0', `util1` varchar(20) DEFAULT NULL, PRIMARY KEY (`proFil_id`), KEY `int_id` (`pro_id`) ) ENGINE=InnoDB AUTO_INCREMENT=11074 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `provider_file_category` -- DROP TABLE IF EXISTS `provider_file_category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `provider_file_category` ( `proFilCat_id` bigint unsigned NOT NULL AUTO_INCREMENT, `proFilCat_order` int DEFAULT NULL, `proFilCat_nameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `proFilCat_nameEn` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `proFilCat_active` int DEFAULT NULL, `proFilCat_updatedDate` datetime DEFAULT NULL, `proFilCat_createdDate` datetime DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `proFilCat_deleted` int DEFAULT NULL, `proFilCat_obligatory` tinyint(1) DEFAULT '0', PRIMARY KEY (`proFilCat_id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `provider_invoice` -- DROP TABLE IF EXISTS `provider_invoice`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `provider_invoice` ( `proInv_id` int NOT NULL AUTO_INCREMENT, `int_id` int DEFAULT NULL, `pro_id` int DEFAULT NULL, `proInv_number` int DEFAULT NULL, `proInv_achievementDate` date DEFAULT NULL, `proInv_deadlineDate` date DEFAULT NULL, `proInv_payed` int DEFAULT '0', `proInv_paymentDate` date DEFAULT NULL, `proInv_providerNumber` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sta_id` int DEFAULT NULL, `proInv_amountHT` double DEFAULT NULL, `proInv_tva` double DEFAULT NULL, `proInv_amountTTC` double DEFAULT NULL, `use_idCreator` int NOT NULL, `proReq_id` int DEFAULT NULL, `proInv_comment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `use_idUpdater` int DEFAULT NULL, `proInv_createdDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `proInv_updatedDate` datetime DEFAULT NULL, `proInv_InvoiceDate` date DEFAULT NULL, `proInv_exported` tinyint(1) DEFAULT '0', `proInv_exportedDate` datetime DEFAULT NULL, `tva_id` int DEFAULT NULL, `intFil_id` int DEFAULT NULL, `proInv_avoir` int DEFAULT '0', `proInv_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `proInv_validated` int DEFAULT '0', `proInv_validatedDate` date DEFAULT NULL, `tva_taux` decimal(4,2) NOT NULL DEFAULT '0.00', `proInv_motifRefus` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `proInv_receiptDate` date DEFAULT NULL, `proInv_exportUserId` int DEFAULT NULL, PRIMARY KEY (`proInv_id`), KEY `cusQuo_id` (`proReq_id`), KEY `int_id` (`int_id`) ) ENGINE=InnoDB AUTO_INCREMENT=30391 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `provider_invoice_export_compta` -- DROP TABLE IF EXISTS `provider_invoice_export_compta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `provider_invoice_export_compta` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `proInv_id` int DEFAULT NULL, `exportDate` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `provider_link_activity` -- DROP TABLE IF EXISTS `provider_link_activity`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `provider_link_activity` ( `proAct_id` int NOT NULL AUTO_INCREMENT, `pro_id` int NOT NULL, `act_id` int NOT NULL, `proLinAct_createdDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `use_idCreator` int DEFAULT NULL, PRIMARY KEY (`proAct_id`), KEY `pro_id` (`pro_id`,`act_id`) ) ENGINE=InnoDB AUTO_INCREMENT=82114 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `provider_quote` -- DROP TABLE IF EXISTS `provider_quote`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `provider_quote` ( `proQuo_id` int NOT NULL AUTO_INCREMENT, `int_id` int NOT NULL, `proQuo_number` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `pro_id` int NOT NULL, `proQuo_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `proQuo_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `proQuo_requestDate` date DEFAULT NULL, `proQuo_desiredDateReturn` date DEFAULT NULL, `proQuo_realDateReturn` date DEFAULT NULL, `sta_id` int NOT NULL, `proQuo_amountHT` double DEFAULT NULL, `proQuo_tva` double DEFAULT NULL, `proQuo_amountTTC` double DEFAULT NULL, `proQuo_nbRelance` int NOT NULL DEFAULT '0', `use_idCreator` int NOT NULL, `proQuo_createdDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `proQuo_updatedDate` datetime DEFAULT NULL, `proReq_id` int DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `tva_id` int DEFAULT NULL, `intFil_id` int DEFAULT NULL, `proQuo_lastRelaunchDate` date DEFAULT NULL, `proQuo_RelaunchCount` int DEFAULT '0', `proQuo_autoRelaunchCount` int DEFAULT '0', `intFil_id_bpa` int DEFAULT NULL, `proQuo_validated` int NOT NULL DEFAULT '0', `proQuo_validatedDate` date DEFAULT NULL, `proQuo_visitDate` date DEFAULT NULL, `proQuo_satisfactionReactivity` int DEFAULT NULL, `proQuo_satisfactionPrice` int DEFAULT NULL, `proQuo_satisfactionDetails` int DEFAULT NULL, `proQuo_predefinedText1` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `proQuo_predefinedText2` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, PRIMARY KEY (`proQuo_id`), KEY `int_id` (`int_id`), KEY `pro_id` (`pro_id`), KEY `int_id_2` (`int_id`) ) ENGINE=InnoDB AUTO_INCREMENT=45556 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `provider_request` -- DROP TABLE IF EXISTS `provider_request`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `provider_request` ( `proReq_id` int NOT NULL AUTO_INCREMENT, `int_id` int NOT NULL, `proReq_number` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `pro_id` int NOT NULL, `proReq_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `proReq_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `proReq_requestDate` date DEFAULT NULL, `proReq_planningDate` date DEFAULT NULL, `proReq_qualityControlDate` date DEFAULT NULL, `proReq_achievementDate` date DEFAULT NULL, `sta_id` int NOT NULL, `proReq_amountHT` double DEFAULT NULL, `proReq_tva` double DEFAULT NULL, `proReq_amountTTC` double DEFAULT NULL, `proReq_satisfactionQuality` int DEFAULT NULL, `proReq_satisfactionComment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `proReq_nbRelance` int NOT NULL DEFAULT '0', `proReq_createdDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `proReq_updatedDate` datetime DEFAULT NULL, `proQuo_id` int DEFAULT NULL, `proInv_id` int DEFAULT NULL, `use_idCreator` int NOT NULL, `use_idUpdater` int DEFAULT NULL, `proReq_TVAType` int DEFAULT NULL, `proReq_InvoiceDate` date DEFAULT NULL, `tva_id` int DEFAULT NULL, `intFilBi_id` int DEFAULT NULL, `proReq_lastRelaunchDate` date DEFAULT NULL, `proReq_satisfactionPunctuality` int DEFAULT NULL, `proReq_satisfactionPresentation` int DEFAULT NULL, `proReq_linkKey` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `proReq_linkKey_binumeric` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `proReq_linkKey_binumeric_cus` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `proReq_predefinedText1` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `proReq_predefinedText2` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, PRIMARY KEY (`proReq_id`), KEY `int_id` (`int_id`), KEY `pro_id` (`pro_id`), KEY `int_id_2` (`int_id`) ) ENGINE=InnoDB AUTO_INCREMENT=38181 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `provider_request_bi` -- DROP TABLE IF EXISTS `provider_request_bi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `provider_request_bi` ( `proReqBi_id` bigint unsigned NOT NULL AUTO_INCREMENT, `proReq_id` int NOT NULL DEFAULT '0', `int_id` int NOT NULL DEFAULT '0', `proReqBi_job` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `proReqBi_equipment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `proReqBi_nbPeople` int NOT NULL DEFAULT '1', `proReqBi_customerComment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `proReqBi_nameSignataire` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `proReqBi_validated` int NOT NULL DEFAULT '0', `proReqBi_validatedTime` datetime DEFAULT NULL, `proReqBi_date` datetime DEFAULT NULL, `proReqBi_dateTech` datetime DEFAULT NULL, `proReqBi_dateValidCus` datetime DEFAULT NULL, `proReqBi_step` int DEFAULT '0', `proReqBi_filesTech` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `proReqBi_providerComment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `proReqBi_spentTimeHours` int DEFAULT NULL, `proReqBi_spentTimeMn` int DEFAULT NULL, `intFil_idTampon` int DEFAULT '0', `intFil_idSignature` int DEFAULT '0', PRIMARY KEY (`proReqBi_id`) ) ENGINE=InnoDB AUTO_INCREMENT=5584 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `provider_tmp` -- DROP TABLE IF EXISTS `provider_tmp`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `provider_tmp` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `nom` varchar(255) DEFAULT NULL, `compte` varchar(30) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=481 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `region` -- DROP TABLE IF EXISTS `region`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `region` ( `reg_id` int NOT NULL AUTO_INCREMENT, `reg_code` int DEFAULT NULL, `reg_name` varchar(255) DEFAULT NULL, PRIMARY KEY (`reg_id`) ) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `rights_admin` -- DROP TABLE IF EXISTS `rights_admin`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `rights_admin` ( `rig_id` bigint unsigned NOT NULL AUTO_INCREMENT, `rig_element` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `rig_admin` int NOT NULL DEFAULT '1', `rig_responsable` int NOT NULL DEFAULT '1', `rig_agent` int NOT NULL DEFAULT '1', `rig_comptable` int NOT NULL DEFAULT '1', PRIMARY KEY (`rig_id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `role_has_permissions` -- DROP TABLE IF EXISTS `role_has_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `role_has_permissions` ( `permission_id` bigint unsigned NOT NULL, `role_id` bigint unsigned NOT NULL, PRIMARY KEY (`permission_id`,`role_id`), KEY `role_has_permissions_role_id_foreign` (`role_id`), CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE, CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `roles` -- DROP TABLE IF EXISTS `roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `roles` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `guard_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `secteur` -- DROP TABLE IF EXISTS `secteur`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `secteur` ( `sec_id` bigint unsigned NOT NULL AUTO_INCREMENT, `sec_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `sec_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sig_id` int DEFAULT NULL, `bil_id` int DEFAULT NULL, `sec_active` int NOT NULL DEFAULT '0', `sec_updatedDate` datetime DEFAULT NULL, `sec_createdDate` datetime DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `sec_deleted` int NOT NULL DEFAULT '0', `sec_dirName` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sec_correspondance` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`sec_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `sign` -- DROP TABLE IF EXISTS `sign`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `sign` ( `sig_id` int NOT NULL AUTO_INCREMENT, `cus_id` int DEFAULT NULL, `sig_socialReason` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `sig_address1` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sig_address2` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `cou_id` int NOT NULL, `sig_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sig_fax` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sig_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `bil_id` int DEFAULT NULL, `sig_active` int NOT NULL DEFAULT '0', `sig_createdDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `sig_updatedDate` datetime DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `sig_deleted` int NOT NULL DEFAULT '0', `sig_zipCode` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sig_city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sig_prices` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `sig_mailInvoice` tinyint unsigned DEFAULT NULL, `sig_recipientInvoiceEmails` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sig_recipientQuoteEmails` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sig_codeWs` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sig_emailCompta` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sig_biNumeric` int DEFAULT '0', PRIMARY KEY (`sig_id`), KEY `cus_id` (`cus_id`), KEY `cou_id` (`cou_id`) ) ENGINE=InnoDB AUTO_INCREMENT=271 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `site` -- DROP TABLE IF EXISTS `site`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `site` ( `sit_id` int NOT NULL AUTO_INCREMENT, `sit_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `sit_code` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sit_address1` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sit_address2` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `cou_id` int DEFAULT NULL, `sit_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sit_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sit_comment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `sig_id` int NOT NULL, `sit_active` tinyint(1) NOT NULL DEFAULT '1', `sit_lat` decimal(11,8) DEFAULT NULL, `sit_lng` decimal(11,8) DEFAULT NULL, `sit_formattedAddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sit_createdDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `sit_updatedDate` datetime DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `sit_hours` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `sit_type` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sit_typePlace` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sit_emailDirector` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sitImp_id` int DEFAULT NULL, `sec_id` int NOT NULL DEFAULT '0', `sit_surface` int DEFAULT NULL, `sit_internalComment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `sit_openDate` timestamp NULL DEFAULT NULL, `sit_correspondance` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sit_respName` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sit_code1` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sit_portable` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sit_deleted` int NOT NULL DEFAULT '0', `bil_id` int DEFAULT NULL, `sit_zipCode` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sit_city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`sit_id`), KEY `ens_id` (`sig_id`), KEY `cou_id` (`cou_id`), KEY `sig_id` (`sig_id`) ) ENGINE=InnoDB AUTO_INCREMENT=9673 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `site_control` -- DROP TABLE IF EXISTS `site_control`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `site_control` ( `sitCon_id` bigint unsigned NOT NULL AUTO_INCREMENT, `sig_id` int NOT NULL, `sit_id` int NOT NULL, `act_id` int NOT NULL, `pro_idAssigned` int DEFAULT NULL, `sitCon_realised` int NOT NULL DEFAULT '0', `sitCon_action` int NOT NULL DEFAULT '0', `sitCon_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `sitCon_deleted` int DEFAULT '0', `sitCon_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `sitCon_visitDate` date DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `sitCon_createdDate` timestamp NULL DEFAULT NULL, `sitCon_updatedDate` timestamp NULL DEFAULT NULL, `actDet_id` int DEFAULT NULL, `sitCon_remindDate` timestamp NULL DEFAULT NULL, PRIMARY KEY (`sitCon_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `site_control_file` -- DROP TABLE IF EXISTS `site_control_file`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `site_control_file` ( `sitConFil_id` bigint unsigned NOT NULL AUTO_INCREMENT, `sitCon_id` int NOT NULL, `sitConFil_description` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `sitConFil_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sitConFil_oldName` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sitConFil_type` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `sitConFil_ext` varchar(4) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `sitConFil_createdDate` timestamp NULL DEFAULT NULL, `sitConFil_updatedDate` timestamp NULL DEFAULT NULL, `sitConFil_visibleProvider` int NOT NULL DEFAULT '1', `sitConFil_visibleSite` int NOT NULL DEFAULT '1', PRIMARY KEY (`sitConFil_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `site_file` -- DROP TABLE IF EXISTS `site_file`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `site_file` ( `sitFil_id` bigint unsigned NOT NULL AUTO_INCREMENT, `sit_id` int NOT NULL, `sitFil_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `sitFil_oldName` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `sitFil_ext` varchar(4) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `cat_id` int NOT NULL, `sitFil_createdDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `use_idCreator` int NOT NULL, `sitFil_updatedDate` timestamp NULL DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `sitFil_deleted` int DEFAULT NULL, `sitFil_description` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sitFil_visibleProvider` int NOT NULL DEFAULT '1', `sitFil_visibleSite` int NOT NULL DEFAULT '1', PRIMARY KEY (`sitFil_id`) ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `site_implantation` -- DROP TABLE IF EXISTS `site_implantation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `site_implantation` ( `sitImp_id` bigint unsigned NOT NULL AUTO_INCREMENT, `sitImp_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`sitImp_id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `site_temp` -- DROP TABLE IF EXISTS `site_temp`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `site_temp` ( `sit_id` int NOT NULL AUTO_INCREMENT, `sit_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `sit_code` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sit_address1` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sit_address2` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `cou_id` int DEFAULT NULL, `sit_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sit_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sit_comment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `sig_id` int NOT NULL, `sit_active` tinyint(1) NOT NULL DEFAULT '1', `sit_lat` decimal(11,8) DEFAULT NULL, `sit_lng` decimal(11,8) DEFAULT NULL, `sit_formattedAddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sit_createdDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `sit_updatedDate` datetime DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `sit_hours` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `sit_type` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sit_typePlace` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sit_emailDirector` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sitImp_id` int DEFAULT NULL, `sec_id` int NOT NULL DEFAULT '0', `sit_surface` int DEFAULT NULL, `sit_internalComment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `sit_openDate` timestamp NULL DEFAULT NULL, `sit_correspondance` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sit_respName` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sit_code1` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sit_portable` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sit_deleted` int NOT NULL DEFAULT '0', `bil_id` int DEFAULT NULL, `sit_zipCode` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sit_city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `importer` int NOT NULL DEFAULT '1', PRIMARY KEY (`sit_id`) ) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `status` -- DROP TABLE IF EXISTS `status`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `status` ( `sta_id` bigint unsigned NOT NULL AUTO_INCREMENT, `sta_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `sta_oldId` int DEFAULT NULL, `sta_order` int DEFAULT NULL, `sta_nameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `sta_nameEn` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sta_active` int NOT NULL DEFAULT '1', `sta_updatedDate` datetime DEFAULT NULL, `sta_createdDate` datetime DEFAULT NULL, `sta_color` varchar(7) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `sta_deleted` int DEFAULT NULL, `sta_preventive` int DEFAULT NULL, `staGro_id` int DEFAULT NULL, `sta_curative` int DEFAULT NULL, `sta_cliNameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `sta_proNameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`sta_id`) ) ENGINE=InnoDB AUTO_INCREMENT=402 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `status_group` -- DROP TABLE IF EXISTS `status_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `status_group` ( `staGro_id` bigint unsigned NOT NULL AUTO_INCREMENT, `staGro_order` int NOT NULL DEFAULT '0', `staGro_libelleFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `staGro_active` int NOT NULL DEFAULT '1', `staGro_createdDate` date DEFAULT NULL, `staGro_updatedDate` date DEFAULT NULL, `staGro_cliNameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `staGro_proNameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `staGro_bgClient` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `staGro_visibleClient` int NOT NULL DEFAULT '0', PRIMARY KEY (`staGro_id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `status_params` -- DROP TABLE IF EXISTS `status_params`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `status_params` ( `staPar_id` bigint unsigned NOT NULL AUTO_INCREMENT, `staPar_type` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `staPar_code` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `staPar_descriptionFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `staPar_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`staPar_id`) ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `status_rules` -- DROP TABLE IF EXISTS `status_rules`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `status_rules` ( `staRul_id` bigint unsigned NOT NULL AUTO_INCREMENT, `staRul_table` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `staRul_type` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `staRul_active` int NOT NULL DEFAULT '1', `staRul_staId` int NOT NULL, `staRul_destStaId` int NOT NULL, `use_idCreator` int DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `staRul_createdDate` timestamp NULL DEFAULT NULL, `staRul_updatedDate` timestamp NULL DEFAULT NULL, `staRul_tableDest` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`staRul_id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `texte` -- DROP TABLE IF EXISTS `texte`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `texte` ( `tex_id` int NOT NULL AUTO_INCREMENT, `tex_nameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `tex_nameEn` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `tex_textFr` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `tex_textEn` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `tex_type` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `tex_code` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `tex_mailObject` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`tex_id`) ) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `todo_list` -- DROP TABLE IF EXISTS `todo_list`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `todo_list` ( `todLis_id` bigint unsigned NOT NULL AUTO_INCREMENT, `todLis_startDate` date DEFAULT NULL, `todLis_endDate` date DEFAULT NULL, `todLis_text` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `todLis_createdDate` datetime DEFAULT NULL, `todLis_updatedDate` datetime DEFAULT NULL, `use_idCreator` int DEFAULT NULL, PRIMARY KEY (`todLis_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `tva` -- DROP TABLE IF EXISTS `tva`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tva` ( `tva_id` int NOT NULL AUTO_INCREMENT, `tva_order` int DEFAULT NULL, `tva_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `tva_value` decimal(5,2) NOT NULL, `tva_active` tinyint(1) NOT NULL DEFAULT '1', `cou_id` int NOT NULL, `tva_createdDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `tva_updatedDate` datetime DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `com_idUpdater` int DEFAULT NULL, `use_idCreator` int NOT NULL, `com_idCreator` int DEFAULT NULL, `tva_autoliquidation` tinyint(1) DEFAULT '0', `tva_exoneration` tinyint(1) DEFAULT '0', `tva_comCompVentes` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `tva_comCompAchats` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `tva_comCompVentesHt` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `tva_comCompAchatsHt` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`tva_id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `tvatype` -- DROP TABLE IF EXISTS `tvatype`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tvatype` ( `tvatype_id` int NOT NULL AUTO_INCREMENT, `tvatype_order` tinyint NOT NULL, `tvatype_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `tvatype_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `tvatype_active` tinyint(1) NOT NULL DEFAULT '1', `cou_id` int NOT NULL, `tvatype_createdDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `tvatype_updatedDate` datetime DEFAULT NULL, `use_idUpdater` int NOT NULL, `com_idUpdater` int NOT NULL, `use_idCreator` int NOT NULL, `com_idCreator` int NOT NULL, PRIMARY KEY (`tvatype_id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `unity` -- DROP TABLE IF EXISTS `unity`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `unity` ( `uni_id` bigint unsigned NOT NULL AUTO_INCREMENT, `uni_order` int DEFAULT NULL, `uni_value` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `uni_description` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `uni_active` tinyint(1) DEFAULT '1', `uni_updatedDate` datetime DEFAULT NULL, `uni_createdDate` datetime DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `use_idCreator` int DEFAULT NULL, PRIMARY KEY (`uni_id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `user_astreinte` -- DROP TABLE IF EXISTS `user_astreinte`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_astreinte` ( `useAst_id` bigint unsigned NOT NULL AUTO_INCREMENT, `use_id` int DEFAULT NULL, `useAst_etatAstreinte` tinyint(1) NOT NULL DEFAULT '1', `useAst_startDate` datetime DEFAULT NULL, `useAst_endDate` datetime DEFAULT NULL, PRIMARY KEY (`useAst_id`) ) ENGINE=InnoDB AUTO_INCREMENT=9585 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `user_customer` -- DROP TABLE IF EXISTS `user_customer`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_customer` ( `useCus_id` int NOT NULL AUTO_INCREMENT, `use_id` int DEFAULT '0', `cus_id` int DEFAULT '0', `useCus_createdDate` timestamp NULL DEFAULT NULL, `use_idCreator` int NOT NULL DEFAULT '0', PRIMARY KEY (`useCus_id`), KEY `cus_id` (`cus_id`), KEY `use_id` (`use_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `user_log` -- DROP TABLE IF EXISTS `user_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_log` ( `useLog_id` int NOT NULL AUTO_INCREMENT, `use_id` int NOT NULL, `useLog_ip` varchar(255) DEFAULT NULL, `useLog_valid` tinyint(1) NOT NULL DEFAULT '0', `useLog_connexion` tinyint(1) NOT NULL DEFAULT '0', `useLog_connectionDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `useLog_lastActionDate` datetime DEFAULT NULL, `useLog_lastAction` varchar(255) DEFAULT NULL, PRIMARY KEY (`useLog_id`), KEY `use_id` (`use_id`) ) ENGINE=InnoDB AUTO_INCREMENT=18899 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `user_params` -- DROP TABLE IF EXISTS `user_params`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_params` ( `usePar_id` bigint unsigned NOT NULL AUTO_INCREMENT, `use_id` int NOT NULL, `usePar_diNewOnglet` int NOT NULL DEFAULT '1', `usePar_editPdfOption` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'see', `usePar_template` int NOT NULL DEFAULT '2', PRIMARY KEY (`usePar_id`) ) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `user_sign` -- DROP TABLE IF EXISTS `user_sign`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_sign` ( `useSig_id` int NOT NULL AUTO_INCREMENT, `use_id` int DEFAULT '0', `sig_id` int DEFAULT '0', `useSig_createdDate` timestamp NULL DEFAULT NULL, `use_idCreator` int NOT NULL DEFAULT '0', PRIMARY KEY (`useSig_id`), KEY `cus_id` (`sig_id`), KEY `use_id` (`use_id`) ) ENGINE=InnoDB AUTO_INCREMENT=279 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `user_wallet` -- DROP TABLE IF EXISTS `user_wallet`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_wallet` ( `useWal_id` bigint unsigned NOT NULL AUTO_INCREMENT, `use_id` int DEFAULT NULL, `wal_id` int DEFAULT NULL, PRIMARY KEY (`useWal_id`) ) ENGINE=InnoDB AUTO_INCREMENT=216 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `userbo` -- DROP TABLE IF EXISTS `userbo`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `userbo` ( `use_id` smallint unsigned NOT NULL AUTO_INCREMENT, `use_nom` varchar(255) NOT NULL DEFAULT '', `use_prenom` varchar(255) NOT NULL DEFAULT '', `use_login` varchar(255) NOT NULL DEFAULT '', `use_password` varchar(255) NOT NULL DEFAULT '', `use_niveau` int NOT NULL DEFAULT '1', `use_email` varchar(255) NOT NULL DEFAULT '', `use_actif` tinyint(1) NOT NULL DEFAULT '1', `use_created` datetime DEFAULT NULL, `use_modified` datetime DEFAULT NULL, `use_createdDate` datetime DEFAULT NULL, `use_updatedDate` datetime DEFAULT NULL, PRIMARY KEY (`use_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `userbo_type` -- DROP TABLE IF EXISTS `userbo_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `userbo_type` ( `useTyp_id` smallint unsigned NOT NULL AUTO_INCREMENT, `useTyp_niveau` int NOT NULL DEFAULT '0', `useTyp_libelle` varchar(255) NOT NULL DEFAULT '', `useTyp_actif` tinyint(1) NOT NULL DEFAULT '1', `useTyp_modified` datetime DEFAULT NULL, `useTyp_created` datetime DEFAULT NULL, PRIMARY KEY (`useTyp_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; /*!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 */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `use_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `use_mobile` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `use_active` tinyint(1) NOT NULL DEFAULT '1', `use_lastVisit` datetime DEFAULT NULL, `use_lastIP` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `created_at` datetime DEFAULT NULL, `role` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `token_2fa` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `token_2fa_expiry` datetime DEFAULT NULL, `use_fonction` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `use_pwdSendedDate` date DEFAULT NULL, `use_valProQuo` int NOT NULL DEFAULT '1', `use_valProInv` int NOT NULL DEFAULT '1', `use_roleAdd` int NOT NULL DEFAULT '1', `use_roleEdit` int NOT NULL DEFAULT '1', `use_roleDelete` int NOT NULL DEFAULT '1', `use_roleExport` int NOT NULL DEFAULT '1', `cus_id` int NOT NULL, `sig_id` int NOT NULL, `use_astreinte` tinyint(1) DEFAULT NULL, `use_logo` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `use_gmailAddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `use_useGmailCalendar` int DEFAULT '0', `use_assocTech` int DEFAULT '0', `use_address1` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `use_address2` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `use_zipCode` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `use_city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `cou_id` int DEFAULT NULL, `use_lat` decimal(11,8) DEFAULT NULL, `use_lng` decimal(11,8) DEFAULT NULL, `use_formattedAddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `active_ipFilter` int NOT NULL DEFAULT '1', `use_gpType` int DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `use_email` (`email`), KEY `id` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wallet` -- DROP TABLE IF EXISTS `wallet`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `wallet` ( `wal_id` bigint unsigned NOT NULL AUTO_INCREMENT, `wal_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `wal_managerName` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `wal_informations` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `wal_updatedDate` datetime DEFAULT NULL, `wal_createdDate` datetime DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `use_idCreator` int DEFAULT NULL, PRIMARY KEY (`wal_id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wallet_objectif` -- DROP TABLE IF EXISTS `wallet_objectif`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `wallet_objectif` ( `walObj_id` bigint unsigned NOT NULL AUTO_INCREMENT, `wal_id` int NOT NULL, `walObj_month` varchar(7) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `walObj_caValue` int DEFAULT NULL, `walObj_margeBruteValue` double DEFAULT NULL, `walObj_productivityValue` int DEFAULT NULL, PRIMARY KEY (`walObj_id`) ) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wallet_sign` -- DROP TABLE IF EXISTS `wallet_sign`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `wallet_sign` ( `walSig_id` bigint unsigned NOT NULL AUTO_INCREMENT, `wal_id` int DEFAULT NULL, `sig_id` int DEFAULT NULL, PRIMARY KEY (`walSig_id`) ) ENGINE=InnoDB AUTO_INCREMENT=10103 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `worksite` -- DROP TABLE IF EXISTS `worksite`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `worksite` ( `wor_id` bigint unsigned NOT NULL AUTO_INCREMENT, `cus_id` int NOT NULL, `sig_id` int NOT NULL, `sit_id` int NOT NULL, `sta_id` int DEFAULT NULL, `wor_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `wor_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `wor_refNumber` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `wor_createdDate` date DEFAULT NULL, `wor_closingDate` date DEFAULT NULL, `wor_estimatedAmount` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `worCat_id` int DEFAULT NULL, `wor_closed` int NOT NULL DEFAULT '0', `wor_startDate` date DEFAULT NULL, `wor_endDate` date DEFAULT NULL, `wor_sinister` int NOT NULL DEFAULT '0', `wor_updatedDate` date DEFAULT NULL, `wor_responsibleThird` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `wor_sinisterDate` date DEFAULT NULL, `wor_deductibleAmount` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `wor_provisionAmount` decimal(10,2) DEFAULT NULL, PRIMARY KEY (`wor_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `worksite_budgets` -- DROP TABLE IF EXISTS `worksite_budgets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `worksite_budgets` ( `worBud_id` bigint unsigned NOT NULL AUTO_INCREMENT, `act_id` int DEFAULT NULL, `wor_id` int DEFAULT NULL, `worBud_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `worBud_createdDate` date DEFAULT NULL, `worBud_updatedDate` date DEFAULT NULL, PRIMARY KEY (`worBud_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `worksite_category` -- DROP TABLE IF EXISTS `worksite_category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `worksite_category` ( `worCat_id` bigint unsigned NOT NULL AUTO_INCREMENT, `worCat_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `worCat_createdDate` date DEFAULT NULL, `worCat_active` int NOT NULL DEFAULT '1', `use_idCreator` int DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `worCat_updatedDate` date DEFAULT NULL, PRIMARY KEY (`worCat_id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `worksite_file` -- DROP TABLE IF EXISTS `worksite_file`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `worksite_file` ( `worFil_id` bigint unsigned NOT NULL AUTO_INCREMENT, `wor_id` int DEFAULT NULL, `worFil_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `worFil_oldName` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `worFil_ext` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `worFil_createdDate` date DEFAULT NULL, `wor_closingDate` date DEFAULT NULL, `wor_estimatedAmount` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `worFil_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `worFil_deleted` int DEFAULT NULL, `worFil_size` int DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `worFil_updatedDate` date DEFAULT NULL, `cat_id` int DEFAULT NULL, PRIMARY KEY (`worFil_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `worksite_reimbursement` -- DROP TABLE IF EXISTS `worksite_reimbursement`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `worksite_reimbursement` ( `worRei_id` bigint unsigned NOT NULL AUTO_INCREMENT, `wor_id` int DEFAULT NULL, `worRei_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `worRei_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `worRei_amountHt` decimal(11,2) DEFAULT NULL, `worRei_payed` int NOT NULL DEFAULT '0', `worRei_createdDate` date DEFAULT NULL, `use_idCreator` int DEFAULT NULL, `use_idUpdater` int DEFAULT NULL, `worRei_updatedDate` date DEFAULT NULL, PRIMARY KEY (`worRei_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!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 2026-02-13 16:07:00