-- Table structure for table `t1zhf_facturedet_extrafields`
--

CREATE TABLE `t1zhf_facturedet_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int NOT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `show_total_ht` int DEFAULT NULL,
  `show_reduc` int DEFAULT NULL,
  `subtotal_nc` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `subtotal_show_qty` int DEFAULT NULL,
  `hideblock` int DEFAULT NULL,
  `reflinenumber` varchar(128) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_facturedet_extrafields` (`fk_object`)
) ENGINE=InnoDB AUTO_INCREMENT=402 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_facturedet_extrafields`
--

INSERT INTO `t1zhf_facturedet_extrafields` VALUES (1,'2019-01-10 17:46:37',4,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'2019-01-10 17:53:11',5,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'2019-01-10 17:53:11',6,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'2019-01-10 17:53:11',7,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'2019-01-10 17:53:11',10,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'2019-01-10 17:53:11',11,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'2019-01-10 17:55:05',13,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'2019-01-10 17:55:05',14,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'2019-01-10 17:55:05',15,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'2019-01-10 17:55:05',18,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'2019-01-10 17:55:05',19,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'2019-01-10 17:59:51',21,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'2019-01-10 17:59:51',22,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'2019-01-10 17:59:51',23,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'2019-01-10 17:59:51',26,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'2019-01-10 17:59:51',27,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'2019-01-10 18:02:50',29,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'2019-01-10 18:02:50',30,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'2019-01-10 18:02:50',31,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'2019-01-10 18:02:50',34,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'2019-01-10 18:02:50',35,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'2019-01-14 11:08:50',37,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,'2019-02-18 11:25:04',49,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,'2019-02-18 11:25:13',50,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,'2019-02-18 11:26:54',51,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,'2019-02-18 11:26:54',52,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(63,'2019-02-18 11:28:12',53,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,'2019-02-18 11:28:12',54,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,'2019-02-18 11:29:37',55,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(68,'2019-02-18 11:29:37',56,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(71,'2019-02-20 13:48:37',63,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,'2019-02-20 13:49:02',59,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(75,'2019-02-20 13:49:18',60,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(76,'2019-02-20 13:49:34',64,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(77,'2019-02-20 13:49:44',65,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(81,'2019-02-20 14:27:57',73,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(82,'2019-02-20 15:52:28',68,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(83,'2019-02-20 15:52:28',69,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(84,'2019-02-20 15:52:28',72,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(85,'2019-02-20 17:51:46',75,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(86,'2019-02-20 17:51:46',76,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(87,'2019-02-20 17:51:46',77,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(88,'2019-02-20 17:51:46',78,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(89,'2019-02-20 17:51:46',79,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(90,'2019-02-20 17:51:47',80,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(91,'2019-02-20 17:51:47',81,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(93,'2019-02-20 17:53:58',83,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(94,'2019-02-20 17:53:58',84,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(95,'2019-02-20 17:53:58',85,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(96,'2019-02-20 17:53:58',86,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(97,'2019-02-20 17:53:58',87,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(98,'2019-02-20 17:53:58',88,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(99,'2019-02-20 17:54:19',82,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(100,'2019-02-20 17:57:18',89,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(103,'2019-02-20 17:57:18',92,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(104,'2019-02-20 17:57:18',93,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(105,'2019-02-20 17:57:18',94,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(106,'2019-02-20 17:57:18',95,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(107,'2019-02-20 17:57:36',90,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(108,'2019-02-20 17:57:50',91,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(109,'2019-02-20 17:59:27',96,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(110,'2019-02-20 17:59:27',97,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(111,'2019-02-20 17:59:27',98,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(114,'2019-02-20 17:59:27',101,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(115,'2019-02-20 17:59:27',102,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(116,'2019-02-20 17:59:45',99,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(117,'2019-02-20 17:59:52',100,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(118,'2019-02-20 18:02:27',103,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(119,'2019-02-20 18:02:27',104,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(120,'2019-02-20 18:02:27',105,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(121,'2019-02-20 18:02:27',106,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(122,'2019-02-20 18:02:27',107,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(124,'2019-02-20 18:02:27',109,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(125,'2019-02-20 18:03:16',108,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(126,'2019-02-20 18:06:43',110,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(127,'2019-02-20 18:06:43',111,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(128,'2019-02-20 18:06:44',112,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(129,'2019-02-20 18:06:44',113,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(130,'2019-02-20 18:06:44',114,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(132,'2019-02-20 18:06:44',116,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(133,'2019-02-20 18:07:04',115,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(134,'2019-02-20 18:08:42',117,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(135,'2019-02-20 18:08:42',118,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(136,'2019-02-20 18:08:42',119,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(137,'2019-02-20 18:08:42',120,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(138,'2019-02-20 18:08:42',121,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(140,'2019-02-20 18:08:42',123,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(141,'2019-02-20 18:08:58',122,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(142,'2019-02-20 18:10:19',124,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(143,'2019-02-20 18:10:19',125,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(144,'2019-02-20 18:10:19',126,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(145,'2019-02-20 18:10:19',127,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(146,'2019-02-20 18:10:19',128,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(147,'2019-02-20 18:10:19',129,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(149,'2019-02-20 18:10:33',130,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(152,'2019-02-22 16:51:00',133,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(153,'2019-02-22 16:51:00',134,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(154,'2019-02-22 16:51:00',135,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(155,'2019-02-22 16:51:00',136,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(156,'2019-02-22 16:51:00',137,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(157,'2019-02-22 16:52:26',131,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(158,'2019-02-22 16:52:47',132,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(203,'2019-02-22 17:02:43',138,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(204,'2019-02-22 17:02:43',139,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(205,'2019-02-22 17:02:43',140,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(206,'2019-02-22 17:02:43',141,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(207,'2019-02-22 17:02:43',142,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(208,'2019-02-22 17:02:43',143,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(209,'2019-02-22 17:02:43',144,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(225,'2019-03-05 15:45:28',153,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(226,'2019-03-05 15:45:28',154,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(227,'2019-03-05 15:45:28',155,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(228,'2019-03-05 15:45:28',156,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(229,'2019-03-05 15:45:28',157,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(232,'2019-03-05 15:45:41',159,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(235,'2019-03-05 15:47:41',158,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(236,'2019-03-05 15:51:01',160,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(237,'2019-03-05 15:51:01',161,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(238,'2019-03-05 15:51:01',162,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(239,'2019-03-05 15:51:01',163,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(240,'2019-03-05 15:51:01',164,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(242,'2019-03-05 15:51:01',166,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(243,'2019-03-05 15:51:40',165,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(245,'2019-06-14 12:44:33',168,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(247,'2019-06-14 12:44:33',170,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(248,'2019-06-14 12:44:33',171,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(249,'2019-06-14 12:44:33',172,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(250,'2019-06-14 12:44:33',173,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(251,'2019-06-14 12:44:33',174,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(252,'2019-06-14 12:45:04',169,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(253,'2019-06-14 13:19:52',175,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(254,'2019-07-13 09:01:41',176,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(255,'2019-07-14 19:05:47',178,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(261,'2019-09-06 13:24:43',181,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(262,'2019-09-06 13:24:43',182,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(264,'2019-09-06 13:24:43',185,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(265,'2019-09-06 13:24:43',186,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(266,'2019-09-06 13:24:43',187,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(278,'2019-09-09 13:26:38',201,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(280,'2019-09-09 13:26:57',203,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(281,'2020-06-22 13:19:37',207,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(282,'2020-06-22 13:19:37',208,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(283,'2020-06-22 13:19:37',209,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(284,'2020-06-22 13:19:37',212,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(285,'2021-03-08 16:26:24',219,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(286,'2021-03-08 16:26:24',220,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(287,'2021-03-24 10:53:06',221,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(288,'2021-03-24 10:53:06',222,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(290,'2021-05-25 14:02:15',224,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(292,'2021-05-25 14:04:58',225,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(294,'2021-05-25 14:07:05',226,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(296,'2021-05-26 14:27:29',228,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(297,'2021-05-26 14:27:29',229,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(298,'2021-05-26 14:27:57',227,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(301,'2021-05-26 14:28:50',232,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(303,'2021-05-26 14:30:09',230,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(304,'2021-05-26 14:30:25',231,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(308,'2021-05-26 14:31:16',233,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(309,'2021-05-26 14:31:16',234,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(310,'2021-05-26 14:31:16',235,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(312,'2021-07-08 09:09:37',237,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(313,'2021-07-08 09:09:37',238,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(314,'2021-07-08 09:09:37',239,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(315,'2021-07-08 09:09:37',240,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(317,'2021-07-08 09:09:37',242,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(318,'2021-07-08 09:09:37',243,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(319,'2021-07-08 09:09:37',244,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(320,'2021-07-08 09:10:03',236,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(321,'2021-07-08 09:10:22',241,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(323,'2021-07-08 09:13:47',246,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(324,'2021-07-08 09:13:47',247,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(326,'2021-07-08 09:13:47',249,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(327,'2021-07-08 09:13:47',250,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(328,'2021-07-08 09:13:47',251,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(329,'2021-07-08 09:13:47',252,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(330,'2021-07-08 09:13:47',253,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(331,'2021-07-08 09:14:03',245,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(332,'2021-07-08 09:14:24',248,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(342,'2021-07-08 09:18:45',254,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(343,'2021-07-08 09:18:45',255,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(344,'2021-07-08 09:18:45',256,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(345,'2021-07-08 09:18:45',257,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(346,'2021-07-08 09:18:45',258,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(347,'2021-07-08 09:18:45',259,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(348,'2021-07-08 09:18:45',260,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(349,'2021-07-08 09:18:45',261,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(350,'2021-07-08 09:18:45',262,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(351,'2021-07-16 13:33:54',263,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(352,'2021-07-16 13:33:54',264,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(353,'2021-07-16 13:33:54',265,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(354,'2021-07-16 13:33:54',266,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(355,'2022-02-18 15:26:07',268,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(356,'2022-02-18 15:26:07',269,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(357,'2022-02-18 15:26:07',270,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(358,'2023-04-25 09:10:57',271,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(359,'2023-04-25 09:10:57',272,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(360,'2023-04-25 09:10:57',273,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(362,'2024-09-09 13:52:34',284,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(363,'2024-09-09 13:52:34',285,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(364,'2024-09-09 13:52:34',286,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(366,'2024-09-09 13:52:34',288,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(367,'2024-09-09 13:52:34',291,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(368,'2024-09-09 13:52:34',292,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(370,'2024-09-09 13:53:16',283,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(371,'2024-09-18 09:29:33',301,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(372,'2024-09-18 09:29:33',302,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(373,'2024-09-18 09:29:33',303,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(374,'2024-09-18 09:29:33',304,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(375,'2024-09-18 09:29:33',305,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(376,'2024-09-18 09:29:33',308,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(377,'2024-09-18 09:29:33',309,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(378,'2024-09-18 09:29:33',310,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(396,'2024-11-29 16:31:53',316,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(398,'2024-11-29 16:40:58',321,NULL,NULL,NULL,NULL,-1,NULL,NULL),(399,'2024-11-29 16:41:16',325,NULL,NULL,NULL,NULL,-1,NULL,NULL),(400,'2024-11-29 16:41:36',328,NULL,NULL,NULL,NULL,-1,NULL,NULL),(401,'2024-11-29 16:43:06',322,NULL,NULL,NULL,NULL,-1,NULL,NULL);

--
-- Table structure for table `t1zhf_facturedet_rec`
--

CREATE TABLE `t1zhf_facturedet_rec` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_facture` int NOT NULL,
  `fk_parent_line` int DEFAULT NULL,
  `fk_product` int DEFAULT NULL,
  `product_type` int DEFAULT '0',
  `label` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb3_unicode_ci,
  `vat_src_code` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT '',
  `tva_tx` double(6,3) DEFAULT NULL,
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax1_type` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `localtax2_type` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `qty` double DEFAULT NULL,
  `remise_percent` double DEFAULT '0',
  `remise` double DEFAULT '0',
  `subprice` double(24,8) DEFAULT NULL,
  `price` double(24,8) DEFAULT NULL,
  `total_ht` double(24,8) DEFAULT NULL,
  `total_tva` double(24,8) DEFAULT NULL,
  `total_localtax1` double(24,8) DEFAULT '0.00000000',
  `total_localtax2` double(24,8) DEFAULT '0.00000000',
  `total_ttc` double(24,8) DEFAULT NULL,
  `date_start_fill` int DEFAULT '0',
  `date_end_fill` int DEFAULT '0',
  `info_bits` int DEFAULT '0',
  `special_code` int unsigned DEFAULT '0',
  `rang` int DEFAULT '0',
  `fk_contract_line` int DEFAULT NULL,
  `fk_unit` int DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fk_multicurrency` int DEFAULT NULL,
  `multicurrency_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `multicurrency_subprice` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ht` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_tva` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ttc` double(24,8) DEFAULT '0.00000000',
  `buy_price_ht` double(24,8) DEFAULT '0.00000000',
  `fk_product_fournisseur_price` int DEFAULT NULL,
  `fk_user_author` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `fk_facturedet_rec_fk_unit` (`fk_unit`),
  CONSTRAINT `fk_facturedet_rec_fk_unit` FOREIGN KEY (`fk_unit`) REFERENCES `t1zhf_c_units` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_facturedet_rec`
--


--
-- Table structure for table `t1zhf_facturedet_rec_extrafields`
--

CREATE TABLE `t1zhf_facturedet_rec_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int NOT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_facturedet_rec_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_facturedet_rec_extrafields`
--


--
-- Table structure for table `t1zhf_fichinter`
--

CREATE TABLE `t1zhf_fichinter` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_soc` int NOT NULL,
  `fk_projet` int DEFAULT '0',
  `fk_contrat` int DEFAULT '0',
  `ref` varchar(30) COLLATE utf8mb3_unicode_ci NOT NULL,
  `ref_ext` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `ref_client` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `entity` int NOT NULL DEFAULT '1',
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `date_valid` datetime DEFAULT NULL,
  `datei` date DEFAULT NULL,
  `fk_user_author` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `fk_user_valid` int DEFAULT NULL,
  `fk_statut` smallint DEFAULT '0',
  `dateo` date DEFAULT NULL,
  `datee` date DEFAULT NULL,
  `datet` date DEFAULT NULL,
  `duree` double DEFAULT NULL,
  `signed_status` smallint DEFAULT NULL,
  `description` text COLLATE utf8mb3_unicode_ci,
  `note_private` text COLLATE utf8mb3_unicode_ci,
  `note_public` text COLLATE utf8mb3_unicode_ci,
  `model_pdf` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `last_main_doc` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `extraparams` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `online_sign_ip` varchar(48) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `online_sign_name` varchar(64) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_fichinter_ref` (`ref`,`entity`),
  KEY `idx_fichinter_fk_soc` (`fk_soc`),
  CONSTRAINT `fk_fichinter_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `t1zhf_societe` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_fichinter`
--

INSERT INTO `t1zhf_fichinter` VALUES (1,3,1,0,'FI1902-0001',NULL,NULL,1,'2019-02-08 14:21:27','2019-02-08 14:42:42','2019-02-08 15:21:27',NULL,1,1,3,1,'2019-02-08','2019-02-08',NULL,54600,NULL,NULL,NULL,NULL,'soleil',NULL,NULL,NULL,NULL,NULL),(2,4,2,0,'(PROV2)',NULL,NULL,1,'2019-02-08 14:30:55','2019-02-08 15:30:43',NULL,NULL,4,4,NULL,0,'2019-02-08','2019-02-08',NULL,28800,NULL,NULL,NULL,NULL,'soleil',NULL,NULL,NULL,NULL,NULL),(3,4,3,0,'FI1906-0002',NULL,NULL,1,'2019-06-05 12:38:48','2019-06-05 14:37:04','2019-06-05 14:38:48',NULL,1,1,1,1,'2019-06-05','2019-06-06',NULL,39600,NULL,NULL,NULL,NULL,'soleil',NULL,NULL,NULL,NULL,NULL),(4,4,3,0,'FI1906-0003',NULL,NULL,1,'2019-06-21 09:05:05','2019-06-14 15:14:37','2019-06-14 15:18:02',NULL,1,1,1,0,'2019-06-14','2019-06-14',NULL,28800,NULL,NULL,NULL,NULL,'soleil',NULL,NULL,NULL,NULL,NULL),(5,4,3,0,'FI1907-0004',NULL,NULL,1,'2019-09-09 12:48:24','2019-07-14 21:03:37','2019-09-09 14:48:02',NULL,1,1,4,3,'2019-07-14','2019-07-14',NULL,3600,NULL,NULL,NULL,NULL,'soleil',NULL,NULL,NULL,NULL,NULL),(6,4,8,0,'(PROV6)',NULL,NULL,1,'2019-09-09 13:16:31','2019-09-09 15:16:31',NULL,NULL,1,1,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'soleil',NULL,NULL,NULL,NULL,NULL),(7,4,8,0,'FI1909-0005',NULL,NULL,1,'2019-09-09 13:22:37','2019-09-09 15:19:54','2019-09-09 15:22:37',NULL,1,1,1,1,'2019-09-09','2019-09-09',NULL,28800,NULL,'essais',NULL,'chantier formeuse de caisse','soleil',NULL,NULL,NULL,NULL,NULL),(8,10,3,0,'FI2105-0006',NULL,NULL,1,'2021-05-26 14:55:18','2021-05-26 16:42:01','2021-05-26 16:55:18',NULL,1,1,1,1,'2021-05-27','2021-05-27',NULL,10800,NULL,'dépannage moteur',NULL,NULL,'soleil',NULL,NULL,NULL,NULL,NULL),(9,10,3,0,'FI2105-0007',NULL,NULL,1,'2021-05-26 15:01:43','2021-05-26 17:01:33','2021-05-26 17:01:43',NULL,1,1,1,1,'2021-05-26','2021-05-26',NULL,3600,NULL,NULL,NULL,NULL,'soleil',NULL,NULL,NULL,NULL,NULL),(10,1,12,0,'FI2107-0008',NULL,NULL,1,'2021-07-16 13:46:03','2021-07-16 15:45:08','2021-07-16 15:46:03',NULL,1,1,1,1,'2021-07-16','2021-07-16',NULL,7200,NULL,'réparation fuite',NULL,NULL,'soleil',NULL,NULL,NULL,NULL,NULL),(11,7,13,0,'FI2107-0009',NULL,NULL,1,'2021-07-16 14:23:58','2021-07-16 16:22:10','2021-07-16 16:23:58',NULL,1,1,1,1,'2021-07-16','2021-07-16',NULL,3600,NULL,NULL,NULL,NULL,'soleil',NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `t1zhf_fichinter_extrafields`
--

CREATE TABLE `t1zhf_fichinter_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int NOT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_ficheinter_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_fichinter_extrafields`
--


--
-- Table structure for table `t1zhf_fichinter_rec`
--

CREATE TABLE `t1zhf_fichinter_rec` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `title` varchar(50) COLLATE utf8mb3_unicode_ci NOT NULL,
  `entity` int NOT NULL DEFAULT '1',
  `fk_soc` int DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `fk_contrat` int DEFAULT '0',
  `fk_user_author` int DEFAULT NULL,
  `fk_projet` int DEFAULT NULL,
  `duree` double DEFAULT NULL,
  `description` mediumtext COLLATE utf8mb3_unicode_ci,
  `modelpdf` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `note_private` mediumtext COLLATE utf8mb3_unicode_ci,
  `note_public` mediumtext COLLATE utf8mb3_unicode_ci,
  `frequency` int DEFAULT NULL,
  `unit_frequency` varchar(2) COLLATE utf8mb3_unicode_ci DEFAULT 'm',
  `date_when` datetime DEFAULT NULL,
  `date_last_gen` datetime DEFAULT NULL,
  `nb_gen_done` int DEFAULT NULL,
  `nb_gen_max` int DEFAULT NULL,
  `auto_validate` int DEFAULT NULL,
  `status` smallint DEFAULT '0',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `idx_fichinter_rec_uk_titre` (`title`,`entity`),
  KEY `idx_fichinter_rec_fk_soc` (`fk_soc`),
  KEY `idx_fichinter_rec_fk_user_author` (`fk_user_author`),
  KEY `idx_fichinter_rec_fk_projet` (`fk_projet`),
  CONSTRAINT `fk_fichinter_rec_fk_projet` FOREIGN KEY (`fk_projet`) REFERENCES `t1zhf_projet` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_fichinter_rec_fk_user_author` FOREIGN KEY (`fk_user_author`) REFERENCES `t1zhf_user` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_fichinter_rec`
--


--
-- Table structure for table `t1zhf_fichinterdet`
--

CREATE TABLE `t1zhf_fichinterdet` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_fichinter` int DEFAULT NULL,
  `fk_parent_line` int DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `description` text COLLATE utf8mb3_unicode_ci,
  `duree` int DEFAULT NULL,
  `rang` int DEFAULT '0',
  PRIMARY KEY (`rowid`),
  KEY `idx_fichinterdet_fk_fichinter` (`fk_fichinter`),
  CONSTRAINT `fk_fichinterdet_fk_fichinter` FOREIGN KEY (`fk_fichinter`) REFERENCES `t1zhf_fichinter` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_fichinterdet`
--

INSERT INTO `t1zhf_fichinterdet` VALUES (1,1,NULL,'2019-02-08 09:00:00','câblage armoire',28800,0),(2,1,NULL,'2019-02-08 14:00:00','Modif cablage armoir',14400,0),(3,1,NULL,'2019-02-08 08:30:00','Test',11400,0),(4,2,NULL,'2019-02-08 11:00:00','mep',28800,0),(5,3,NULL,'2019-06-05 09:00:00','meca',18000,0),(6,3,NULL,'2019-06-06 08:00:00','electro',21600,0),(7,4,NULL,'2019-06-14 09:00:00','chmt courroie',28800,0),(8,5,NULL,'2019-07-14 03:00:00','Changement contacteur',3600,0),(9,7,NULL,'2019-09-09 00:00:00','main_d_oeuvre - mo<br />\r\n<br />\r\n(Quantit&eacute;: 10)<br />\r\n<br />\r\nchanger oooo',28800,0),(10,8,NULL,'2021-05-27 08:00:00','d&eacute;pannage moteur',10800,0),(11,9,NULL,'2021-05-26 00:00:00','d&eacute;pannage moteur<br> (Quantit&eacute;: 3)',3600,0),(12,10,NULL,'2021-07-16 00:00:00','R&eacute;paration fuite',7200,0),(14,11,NULL,'2021-07-16 00:00:00','reno',3600,0);

--
-- Table structure for table `t1zhf_fichinterdet_extrafields`
--

CREATE TABLE `t1zhf_fichinterdet_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int NOT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_ficheinterdet_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_fichinterdet_extrafields`
--


--
-- Table structure for table `t1zhf_fichinterdet_rec`
--

CREATE TABLE `t1zhf_fichinterdet_rec` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_fichinter` int NOT NULL,
  `date` datetime DEFAULT NULL,
  `description` mediumtext COLLATE utf8mb3_unicode_ci,
  `duree` int DEFAULT NULL,
  `rang` int DEFAULT '0',
  `total_ht` double(24,8) DEFAULT NULL,
  `subprice` double(24,8) DEFAULT NULL,
  `fk_parent_line` int DEFAULT NULL,
  `fk_product` int DEFAULT NULL,
  `label` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `tva_tx` double(6,3) DEFAULT NULL,
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax1_type` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `localtax2_type` varchar(1) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `qty` double DEFAULT NULL,
  `remise_percent` double DEFAULT '0',
  `fk_remise_except` int DEFAULT NULL,
  `price` double(24,8) DEFAULT NULL,
  `total_tva` double(24,8) DEFAULT NULL,
  `total_localtax1` double(24,8) DEFAULT '0.00000000',
  `total_localtax2` double(24,8) DEFAULT '0.00000000',
  `total_ttc` double(24,8) DEFAULT NULL,
  `product_type` int DEFAULT '0',
  `date_start` datetime DEFAULT NULL,
  `date_end` datetime DEFAULT NULL,
  `info_bits` int DEFAULT '0',
  `buy_price_ht` double(24,8) DEFAULT '0.00000000',
  `fk_product_fournisseur_price` int DEFAULT NULL,
  `fk_code_ventilation` int NOT NULL DEFAULT '0',
  `special_code` int unsigned DEFAULT '0',
  `fk_unit` int DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_fichinterdet_rec`
--


--
-- Table structure for table `t1zhf_holiday`
--

CREATE TABLE `t1zhf_holiday` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) COLLATE utf8mb3_unicode_ci NOT NULL,
  `ref_ext` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `entity` int NOT NULL DEFAULT '1',
  `fk_user` int NOT NULL,
  `fk_user_create` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `fk_type` int NOT NULL,
  `date_create` datetime NOT NULL,
  `description` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `date_debut` date NOT NULL,
  `date_fin` date NOT NULL,
  `halfday` int DEFAULT '0',
  `statut` int NOT NULL DEFAULT '1',
  `fk_validator` int NOT NULL,
  `date_valid` datetime DEFAULT NULL,
  `fk_user_valid` int DEFAULT NULL,
  `date_refuse` datetime DEFAULT NULL,
  `fk_user_refuse` int DEFAULT NULL,
  `date_cancel` datetime DEFAULT NULL,
  `fk_user_cancel` int DEFAULT NULL,
  `detail_refuse` varchar(250) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `note_private` text COLLATE utf8mb3_unicode_ci,
  `note_public` text COLLATE utf8mb3_unicode_ci,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `extraparams` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `date_approval` datetime DEFAULT NULL,
  `fk_user_approve` int DEFAULT NULL,
  `nb_open_day` double(24,8) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_holiday_entity` (`entity`),
  KEY `idx_holiday_fk_user` (`fk_user`),
  KEY `idx_holiday_fk_user_create` (`fk_user_create`),
  KEY `idx_holiday_date_create` (`date_create`),
  KEY `idx_holiday_date_debut` (`date_debut`),
  KEY `idx_holiday_date_fin` (`date_fin`),
  KEY `idx_holiday_fk_validator` (`fk_validator`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_holiday`
--

INSERT INTO `t1zhf_holiday` VALUES (1,'HL2306-0001',NULL,1,3,1,NULL,5,'2023-06-02 08:40:03','','2023-06-01','2023-06-03',0,3,1,'2023-06-02 08:40:13',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-06-02 06:40:27',NULL,NULL,'2023-06-02 08:40:27',1,NULL);

--
-- Table structure for table `t1zhf_holiday_config`
--

CREATE TABLE `t1zhf_holiday_config` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `name` varchar(128) COLLATE utf8mb3_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `idx_holiday_config` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_holiday_config`
--

INSERT INTO `t1zhf_holiday_config` VALUES (1,'lastUpdate','20230602083914');

--
-- Table structure for table `t1zhf_holiday_extrafields`
--

CREATE TABLE `t1zhf_holiday_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NULL DEFAULT NULL,
  `fk_object` int NOT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_holiday_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_holiday_extrafields`
--


--
-- Table structure for table `t1zhf_holiday_logs`
--

CREATE TABLE `t1zhf_holiday_logs` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `date_action` datetime NOT NULL,
  `fk_user_action` int NOT NULL,
  `fk_user_update` int NOT NULL,
  `fk_type` int NOT NULL,
  `type_action` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `prev_solde` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `new_solde` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_holiday_logs`
--

INSERT INTO `t1zhf_holiday_logs` VALUES (1,'2023-06-02 08:40:27',1,3,5,'Congés - HL2306-0001','0','-2');

--
-- Table structure for table `t1zhf_holiday_users`
--

CREATE TABLE `t1zhf_holiday_users` (
  `fk_user` int NOT NULL,
  `fk_type` int NOT NULL,
  `nb_holiday` double NOT NULL DEFAULT '0',
  UNIQUE KEY `uk_holiday_users` (`fk_user`,`fk_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_holiday_users`
--

INSERT INTO `t1zhf_holiday_users` VALUES (3,5,-2);

--
-- Table structure for table `t1zhf_hrm_evaluation`
--

CREATE TABLE `t1zhf_hrm_evaluation` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `ref` varchar(128) NOT NULL DEFAULT '(PROV)',
  `label` varchar(255) DEFAULT NULL,
  `description` text,
  `note_public` text,
  `note_private` text,
  `date_creation` datetime NOT NULL,
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_user_creat` int NOT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `status` smallint NOT NULL,
  `date_eval` date DEFAULT NULL,
  `fk_user` int NOT NULL,
  `fk_job` int NOT NULL,
  `last_main_doc` varchar(255) DEFAULT NULL,
  `entity` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`rowid`),
  KEY `idx_hrm_evaluation_rowid` (`rowid`),
  KEY `idx_hrm_evaluation_ref` (`ref`),
  KEY `t1zhf_hrm_evaluation_fk_user_creat` (`fk_user_creat`),
  KEY `idx_hrm_evaluation_status` (`status`),
  CONSTRAINT `t1zhf_hrm_evaluation_fk_user_creat` FOREIGN KEY (`fk_user_creat`) REFERENCES `t1zhf_user` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1zhf_hrm_evaluation`
--

INSERT INTO `t1zhf_hrm_evaluation` VALUES (2,'EVAL2306-0001','','',NULL,NULL,'2023-06-02 08:32:05','2023-06-02 06:32:19',1,NULL,NULL,1,'2023-06-02',6,1,NULL,1),(3,'EVAL2306-0002','','',NULL,NULL,'2023-06-02 08:32:56','2023-06-02 06:33:08',1,NULL,NULL,1,'2023-06-02',5,1,NULL,1),(4,'EVAL2306-0003','','',NULL,NULL,'2023-06-02 08:38:22','2023-06-02 06:38:31',1,NULL,NULL,1,'2023-06-02',3,1,NULL,1);

--
-- Table structure for table `t1zhf_hrm_evaluation_extrafields`
--

CREATE TABLE `t1zhf_hrm_evaluation_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_evaluation_fk_object` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1zhf_hrm_evaluation_extrafields`
--


--
-- Table structure for table `t1zhf_hrm_evaluationdet`
--

CREATE TABLE `t1zhf_hrm_evaluationdet` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `date_creation` datetime NOT NULL,
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_user_creat` int NOT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `fk_skill` int NOT NULL,
  `fk_evaluation` int NOT NULL,
  `rankorder` int NOT NULL,
  `required_rank` int NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `comment` text,
  PRIMARY KEY (`rowid`),
  KEY `idx_hrm_evaluationdet_rowid` (`rowid`),
  KEY `t1zhf_hrm_evaluationdet_fk_user_creat` (`fk_user_creat`),
  KEY `idx_hrm_evaluationdet_fk_skill` (`fk_skill`),
  KEY `idx_hrm_evaluationdet_fk_evaluation` (`fk_evaluation`),
  CONSTRAINT `t1zhf_hrm_evaluationdet_fk_evaluation` FOREIGN KEY (`fk_evaluation`) REFERENCES `t1zhf_hrm_evaluation` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `t1zhf_hrm_evaluationdet_fk_user_creat` FOREIGN KEY (`fk_user_creat`) REFERENCES `t1zhf_user` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1zhf_hrm_evaluationdet`
--

INSERT INTO `t1zhf_hrm_evaluationdet` VALUES (1,'2023-06-02 08:32:05','2023-06-02 06:32:05',1,1,1,2,2,1,NULL,NULL),(2,'2023-06-02 08:32:05','2023-06-02 06:32:05',1,1,2,2,0,1,NULL,NULL),(3,'2023-06-02 08:32:56','2023-06-02 06:32:56',1,1,1,3,3,1,NULL,NULL),(4,'2023-06-02 08:32:56','2023-06-02 06:32:56',1,1,2,3,2,1,NULL,NULL),(5,'2023-06-02 08:38:22','2023-06-02 06:38:22',1,1,1,4,1,1,NULL,NULL),(6,'2023-06-02 08:38:22','2023-06-02 06:38:22',1,1,2,4,1,1,NULL,NULL);

--
-- Table structure for table `t1zhf_hrm_evaluationdet_extrafields`
--

CREATE TABLE `t1zhf_hrm_evaluationdet_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_evaluationdet_fk_object` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1zhf_hrm_evaluationdet_extrafields`
--


--
-- Table structure for table `t1zhf_hrm_job`
--

CREATE TABLE `t1zhf_hrm_job` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `label` varchar(255) NOT NULL,
  `description` text,
  `date_creation` datetime NOT NULL,
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deplacement` varchar(255) DEFAULT NULL,
  `note_public` text,
  `note_private` text,
  `fk_user_creat` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_hrm_job_rowid` (`rowid`),
  KEY `idx_hrm_job_label` (`label`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1zhf_hrm_job`
--

INSERT INTO `t1zhf_hrm_job` VALUES (1,'usineur cn','','2023-06-02 08:23:41','2023-06-02 06:23:41','0',NULL,NULL,1,NULL);

--
-- Table structure for table `t1zhf_hrm_job_extrafields`
--

CREATE TABLE `t1zhf_hrm_job_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_job_fk_object` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1zhf_hrm_job_extrafields`
--


--
-- Table structure for table `t1zhf_hrm_job_user`
--

CREATE TABLE `t1zhf_hrm_job_user` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `description` text,
  `date_creation` datetime NOT NULL,
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_contrat` int DEFAULT NULL,
  `fk_user` int DEFAULT NULL,
  `fk_job` int NOT NULL,
  `date_start` date DEFAULT NULL,
  `date_end` date DEFAULT NULL,
  `abort_comment` varchar(255) DEFAULT NULL,
  `note_public` text,
  `note_private` text,
  `fk_user_creat` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_hrm_job_user_rowid` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1zhf_hrm_job_user`
--

INSERT INTO `t1zhf_hrm_job_user` VALUES (1,'','2023-06-02 08:24:09','2023-06-02 06:24:09',NULL,5,1,'2022-06-02','2025-06-02',NULL,NULL,NULL,1,NULL),(2,'','2023-06-02 08:30:35','2023-06-02 06:30:35',NULL,6,1,'2021-06-02','2026-06-02',NULL,NULL,NULL,1,NULL),(3,'','2023-06-02 08:36:19','2023-06-02 06:36:19',NULL,3,1,'2021-06-02','2025-06-02',NULL,NULL,NULL,1,NULL),(4,'','2023-06-02 08:37:04','2023-06-02 06:37:04',NULL,3,1,'2023-06-02','2029-06-02',NULL,NULL,NULL,1,NULL);

--
-- Table structure for table `t1zhf_hrm_skill`
--

CREATE TABLE `t1zhf_hrm_skill` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `label` varchar(255) DEFAULT NULL,
  `description` text,
  `date_creation` datetime NOT NULL,
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_user_creat` int NOT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `required_level` int NOT NULL,
  `date_validite` int NOT NULL,
  `temps_theorique` double(24,8) NOT NULL,
  `skill_type` int NOT NULL,
  `note_public` text,
  `note_private` text,
  PRIMARY KEY (`rowid`),
  KEY `idx_hrm_skill_rowid` (`rowid`),
  KEY `t1zhf_hrm_skill_fk_user_creat` (`fk_user_creat`),
  KEY `idx_hrm_skill_skill_type` (`skill_type`),
  CONSTRAINT `t1zhf_hrm_skill_fk_user_creat` FOREIGN KEY (`fk_user_creat`) REFERENCES `t1zhf_user` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1zhf_hrm_skill`
--

INSERT INTO `t1zhf_hrm_skill` VALUES (1,'fraisage cn','usiner sur cn','2023-06-02 08:22:52','2023-06-02 06:22:52',1,1,0,0,0.00000000,0,NULL,NULL),(2,'tournage cn','','2023-06-02 08:23:09','2023-06-02 06:23:09',1,NULL,0,0,0.00000000,0,NULL,NULL);

--
-- Table structure for table `t1zhf_hrm_skill_extrafields`
--

CREATE TABLE `t1zhf_hrm_skill_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_skill_fk_object` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1zhf_hrm_skill_extrafields`
--


--
-- Table structure for table `t1zhf_hrm_skilldet`
--

CREATE TABLE `t1zhf_hrm_skilldet` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `description` text,
  `fk_user_creat` int NOT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `fk_skill` int NOT NULL,
  `rankorder` int DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_hrm_skilldet_rowid` (`rowid`),
  KEY `t1zhf_hrm_skilldet_fk_user_creat` (`fk_user_creat`),
  KEY `t1zhf_hrm_skilldet_fk_skill` (`fk_skill`),
  CONSTRAINT `t1zhf_hrm_skilldet_fk_skill` FOREIGN KEY (`fk_skill`) REFERENCES `t1zhf_hrm_skill` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `t1zhf_hrm_skilldet_fk_user_creat` FOREIGN KEY (`fk_user_creat`) REFERENCES `t1zhf_user` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1zhf_hrm_skilldet`
--

INSERT INTO `t1zhf_hrm_skilldet` VALUES (1,'de base',1,1,1,1),(2,'autonome',1,1,1,2),(3,'formateur',1,1,1,3),(4,'Pas de description 1',1,NULL,2,1),(5,'Pas de description 2',1,NULL,2,2),(6,'Pas de description 3',1,NULL,2,3);

--
-- Table structure for table `t1zhf_hrm_skillrank`
--

CREATE TABLE `t1zhf_hrm_skillrank` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_skill` int NOT NULL,
  `rankorder` int NOT NULL,
  `fk_object` int NOT NULL,
  `date_creation` datetime NOT NULL,
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_user_creat` int NOT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `objecttype` varchar(128) NOT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_hrm_skillrank_rowid` (`rowid`),
  KEY `idx_hrm_skillrank_fk_skill` (`fk_skill`),
  KEY `t1zhf_hrm_skillrank_fk_user_creat` (`fk_user_creat`),
  CONSTRAINT `t1zhf_hrm_skillrank_fk_skill` FOREIGN KEY (`fk_skill`) REFERENCES `t1zhf_hrm_skill` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `t1zhf_hrm_skillrank_fk_user_creat` FOREIGN KEY (`fk_user_creat`) REFERENCES `t1zhf_user` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1zhf_hrm_skillrank`
--

INSERT INTO `t1zhf_hrm_skillrank` VALUES (1,1,1,1,'2023-06-02 08:27:49','2023-06-02 06:27:49',1,1,'job'),(2,2,1,1,'2023-06-02 08:27:53','2023-06-02 06:27:53',1,1,'job');

--
-- Table structure for table `t1zhf_import_model`
--

CREATE TABLE `t1zhf_import_model` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_user` int NOT NULL DEFAULT '0',
  `label` varchar(50) COLLATE utf8mb3_unicode_ci NOT NULL,
  `type` varchar(64) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `field` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `entity` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_import_model` (`label`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_import_model`
--


--
-- Table structure for table `t1zhf_intracommreport`
--

CREATE TABLE `t1zhf_intracommreport` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) COLLATE utf8mb3_unicode_ci NOT NULL,
  `entity` int NOT NULL DEFAULT '1',
  `type_declaration` varchar(32) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `periods` varchar(32) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `mode` varchar(32) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `content_xml` mediumtext COLLATE utf8mb3_unicode_ci,
  `type_export` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_intracommreport`
--


--
-- Table structure for table `t1zhf_inventory`
--

CREATE TABLE `t1zhf_inventory` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `entity` int DEFAULT '0',
  `ref` varchar(48) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `date_creation` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_user_creat` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `fk_user_valid` int DEFAULT NULL,
  `fk_warehouse` int DEFAULT NULL,
  `fk_product` int DEFAULT NULL,
  `categories_product` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `status` int DEFAULT '0',
  `title` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `date_inventory` datetime DEFAULT NULL,
  `date_validation` datetime DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_inventory_ref` (`ref`,`entity`),
  KEY `idx_inventory_tms` (`tms`),
  KEY `idx_inventory_date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_inventory`
--


--
-- Table structure for table `t1zhf_inventory_extrafields`
--

CREATE TABLE `t1zhf_inventory_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_inventory_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1zhf_inventory_extrafields`
--


--
-- Table structure for table `t1zhf_inventorydet`
--

CREATE TABLE `t1zhf_inventorydet` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_inventory` int DEFAULT '0',
  `fk_warehouse` int DEFAULT '0',
  `fk_product` int DEFAULT '0',
  `batch` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `qty_view` double DEFAULT NULL,
  `qty_stock` double DEFAULT NULL,
  `qty_regulated` double DEFAULT NULL,
  `fk_movement` int DEFAULT NULL,
  `pmp_real` double DEFAULT NULL,
  `pmp_expected` double DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_inventorydet` (`fk_inventory`,`fk_warehouse`,`fk_product`,`batch`),
  KEY `idx_inventorydet_tms` (`tms`),
  KEY `idx_inventorydet_datec` (`datec`),
  KEY `idx_inventorydet_fk_inventory` (`fk_inventory`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_inventorydet`
--


--
-- Table structure for table `t1zhf_knowledgemanagement_knowledgerecord`
--

CREATE TABLE `t1zhf_knowledgemanagement_knowledgerecord` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `ref` varchar(128) NOT NULL,
  `date_creation` datetime NOT NULL,
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `last_main_doc` varchar(255) DEFAULT NULL,
  `fk_user_creat` int NOT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `fk_user_valid` int DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `model_pdf` varchar(255) DEFAULT NULL,
  `question` text NOT NULL,
  `answer` longtext,
  `url` varchar(255) DEFAULT NULL,
  `fk_ticket` int DEFAULT NULL,
  `fk_c_ticket_category` int DEFAULT NULL,
  `status` int NOT NULL,
  `lang` varchar(6) DEFAULT NULL,
  `entity` int DEFAULT '1',
  PRIMARY KEY (`rowid`),
  KEY `idx_knowledgemanagement_knowledgerecord_rowid` (`rowid`),
  KEY `idx_knowledgemanagement_knowledgerecord_ref` (`ref`),
  KEY `t1zhf_knowledgemanagement_knowledgerecord_fk_user_creat` (`fk_user_creat`),
  KEY `idx_knowledgemanagement_knowledgerecord_status` (`status`),
  CONSTRAINT `t1zhf_knowledgemanagement_knowledgerecord_fk_user_creat` FOREIGN KEY (`fk_user_creat`) REFERENCES `t1zhf_user` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1zhf_knowledgemanagement_knowledgerecord`
--

INSERT INTO `t1zhf_knowledgemanagement_knowledgerecord` VALUES (1,'KM2306-0001','2023-06-01 19:13:48','2023-06-01 17:13:55',NULL,1,NULL,1,NULL,NULL,'qui','moi',NULL,NULL,NULL,1,'',1);

--
-- Table structure for table `t1zhf_knowledgemanagement_knowledgerecord_extrafields`
--

CREATE TABLE `t1zhf_knowledgemanagement_knowledgerecord_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_knowledgerecord_fk_object` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1zhf_knowledgemanagement_knowledgerecord_extrafields`
--


--
-- Table structure for table `t1zhf_links`
--

CREATE TABLE `t1zhf_links` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `entity` int NOT NULL DEFAULT '1',
  `datea` datetime NOT NULL,
  `url` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `label` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `objecttype` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `objectid` int NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_links` (`objectid`,`objecttype`,`label`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_links`
--

INSERT INTO `t1zhf_links` VALUES (1,1,'2019-01-09 08:52:55','https://www.aqtisplus.com/dolibarr/htdocs/compta/facture/document.php?id=2','lien bidon','facture',2),(2,1,'2019-06-24 09:16:36','http://www.aciers-caso.com/Documentation','catalogue','societe',5),(3,1,'2019-07-13 11:14:18','https://www.aqtisplus.com/dolibarr/htdocs/nomenclature/nomenclature.php?fk_product=24','HES52','project',7),(4,1,'2019-07-13 11:14:50','https://www.aqtisplus.com/dolibarr/htdocs/nomenclature/nomenclature.php?fk_product=24','HES52','societe',4),(5,1,'2019-07-13 11:19:06','https://www.aqtisplus.com/dolibarr/htdocs/societe/card.php?socid=4','Google','product',24),(6,1,'2020-06-22 15:02:49','https://www.castorama.fr/','prod','propal',16),(7,1,'2021-03-08 16:51:00','https://nohowstyle.com/fr/009-baskets-en-blanc','chay','societe',6),(8,1,'2021-10-19 15:33:43','https://www.ebay.fr/?mkevt=1&mkcid=2&mkrid=709-162318-301183-6&keyword=conducive&crlp=1634648071401400015&MT_ID=562786&device=Computers&cmpgn=218623','ebay','project',1),(9,1,'2023-05-09 15:31:01','https://www.cedeo.fr/p/sanitaire/meuble-double-vasque-jolie-mome-longueur-120-cm-4-tiroirs-poudre-A6867253','Meuble JOLIE MOME','project',15),(10,1,'2024-09-09 15:26:13','https://www.leroymerlin.fr/login.html?error=login_required&error_description=The+user+is+not+logged+in&state=c3RhdGU9SzNXY1hwc19oZG45SVBZMnFQaFAzcnFsNDlOWW9qclZnWWRILVBMc2xQVT0mY2xpZW50X2lkPW13dUVZVlFtZFQwTWh3UHN2VXhBJnJlZGlyZWN0X3VyaT1odHRwczovL3d3dy5sZX','lm','contact',1);

--
-- Table structure for table `t1zhf_listgpt`
--

CREATE TABLE `t1zhf_listgpt` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `label` varchar(64) DEFAULT NULL,
  `gptquery` text,
  `gptsql` text,
  `titlemenu` varchar(20) DEFAULT NULL,
  `mainmenu` varchar(50) DEFAULT NULL,
  `leftmenu` varchar(50) DEFAULT NULL,
  `posmenu` varchar(50) DEFAULT '100',
  `author` varchar(50) DEFAULT NULL,
  `active` int DEFAULT NULL,
  `perms` text,
  `entity` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1zhf_listgpt`
--


--
-- Table structure for table `t1zhf_listgpt_table`
--

CREATE TABLE `t1zhf_listgpt_table` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `keywords` text,
  `table_element` text,
  `entity` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1zhf_listgpt_table`
--

INSERT INTO `t1zhf_listgpt_table` VALUES (1,'compte','t1zhf_accounting_account(rowid, label,account_number, account_parent, label)',1),(2,'action','t1zhf_actioncomm(rowid, ref, datec, label, priority, location)',1),(3,'operation, compte','t1zhf_bank(rowid, datec, amount, label, fk_account, fk_user_author, fk_type, num_releve, num_chq, numero_compte, fk_bordereau, banque, emetteur)',1),(4,'produit, catégorie','t1zhf_categorie_product(fk_categorie, fk_product, import_key)',1),(5,'fournisseur, produit, clients','t1zhf_categorie(rowid, label, type, fk_soc, visible, date_creation, fk_user_creat, fk_user_modif)',1),(6,'intervention','t1zhf_fichinter(rowid, fk_projet, fk_soc, fk_contrat, ref, datec, fk_statut, duree)',1),(7,'congé','t1zhf_holiday(rowid, ref, entity, fk_type, date_create, date_debut, date_fin, halfday, statut, date_valid, date_refuse)',1),(8,'détail, commande, client','t1zhf_commandedet(rowid, fk_commande, fk_product, label, tva_tx, qty, remise_percent, remise, price, subprice, total_ht, total_tva, total_ttc, product_type, date_start, date_end, buy_price_ht, fk_product_fournisseur_price, fk_commandefourndet)',1),(9,'commande, client','t1zhf_commande(rowid, ref, entity, fk_soc, fk_projet, date_creation, date_valid, date_cloture, date_commande, fk_statut, amount_ht, remise_percent, remise, total_tva, total_ht, total_ttc, fk_cond_reglement, fk_mode_reglement, date_livraison, fk_shipping_method, fk_warehouse, fk_delivery_address)',1),(10,'produit, service','t1zhf_product(rowid, ref, entity, datec,	label, price, price_ttc, tva_tx, fk_product_type, weight, weight_units, length, length_units, width, width_units, height, height_unit, volume, stock, pmp, lifetime, fk_project)',1),(11,'produit, entrepot, stock','t1zhf_product_stock(rowid, fk_product, fk_entrepot)',1),(12,'projet','t1zhf_projet(rowid, fk_soc, datec, ref, public, fk_statut, budget_amount)',1),(13,'propal','t1zhf_propal(rowid, ref, entity, fk_soc, fk_projet, datec, fin_validite, date_valid, date_signature, date_cloture, fk_statut, price, remise_percent, remise, total_ht, total_tva, total_ttc, fk_cond_reglement, fk_mode_reglement, date_livraison, fk_shipping_method, fk_warehouse, fk_delivery_address)',1),(14,'propal, detail','t1zhf_propaldet(rowid, ref, entity, fk_soc, fk_projet, datec, fin_validite, date_valid, date_signature, date_cloture, fk_statut, price, remise_percent, remise, total_ht, total_tva, total_ttc, fk_cond_reglement, fk_mode_reglement, date_livraison, fk_shipping_method, fk_warehouse, fk_delivery_address)',1),(15,'stock, entrepot','t1zhf_stock_mouvement(rowid, datem, fk_product, fk_entrepot, value, price, type_mouvement, label, fk_project, fk_origin, origintype, fk_projet)',1),(16,'facture, fournisseur','t1zhf_facture_fourn(rowid, ref, type, fk_soc, datec, libelle, paye, amount, remise, tva, total, total_ht, total_tva,total_ttc, fk_statut, fk_projet, fk_account, fk_cond_reglement, fk_mode_reglement, date_lim_reglement, fk_transport_mode)',1),(17,'commande, fournisseur','t1zhf_commande_fournisseur(rowid, ref, entity, fk_soc, fk_projet, date_creation, date_valid, date_approve, date_commande, source,	fk_statut, amount_ht, remise_percent, remise, total_tva, total_ht, total_ttc, date_livraison, fk_account, fk_cond_reglement, fk_mode_reglement)',1),(18,'commande, fournisseur, produit, detail','t1zhf_commande_fournisseurdet(rowid, fk_commande, fk_product, ref, label, tva_tx, qty, remise_percent, remise, total_ht, total_tva, total_ttc, product_type, date_start, date_end)',1),(19,'ticket','t1zhf_ticket(rowid, entity, ref, track_id, fk_soc, fk_project, fk_statut, resolution, progress, timing, type_code, category_code, datec)',1),(20,'user','t1zhf_user(rowid, entity, datec, tms, login, pass, civilite, lastname, firstname, user_mobile, email, admin, fk_societe, datelastlogin)',1),(21,'fabrication, ordre, bom','t1zhf_bom_bom(rowid, entity, ref, bomtype, label, fk_product, fk_warehouse, qty, date_creation, date_valid, status)',1),(22,'salaire , employe','t1zhf_salary(rowid, ref, datec, salary, amount, fk_projet, fk_typepayment, num_payment, label,fk_bank, paye, fk_account)',1),(23,'lot, produit, fabrication','t1zhf_mrp_mo(rowid, ref, entity, label, qty, fk_warehouse, date_creation, date_valid, status, fk_product, date_start_planned, date_end_planned, fk_bom, fk_project)',1),(24,'commande , fournisseur, propal','t1zhf_supplier_proposal(rowid, ref, entity, fk_soc, fk_projet, datec, date_valid, date_cloture, fk_statut, price, remise_percent, remise, total_ht, total_tva, total_ttc,	fk_account,	fk_currency, fk_cond_reglement,	fk_mode_reglement, date_livraison, fk_shipping_method)',1),(25,'frais , remboursement, projet','t1zhf_expensereport(rowid, ref, total_ht, total_tva, total_ttc, date_debut, date_fin, date_valid, date_approve, date_refuse, fk_user_author, fk_user_creat, fk_user_modif, fk_user_valid, fk_user_validator, fk_user_approve, fk_user_refuse, fk_statut, fk_c_paiement, paid)',1),(26,'facture','t1zhf_facture(rowid, ref, entity, type, fk_soc, datec, date_valid, date_closing, paye, remise_percent, remise, total_tva, total_ht, total_ttc, fk_projet, fk_cond_reglement,	fk_mode_reglement)',1),(27,'client, tiers, fournisseur','t1zhf_societe(rowid, nom, entity, statut, code_client, code_fournisseur, code_compta, code_compta_fournisseur, address, zip, town, fk_departement, fk_pays, fk_account, phone, fax, url, email,fk_effectif, fk_typent, fk_forme_juridique, fk_currency, siren, siret,	fk_prospectlevel, customer_bad,	customer_rate, supplier_rate, remise_client, remise_supplier, mode_reglement, cond_reglement, transport_mode, mode_reglement_supplier, cond_reglement_supplier, transport_mode_supplier, fk_shipping_method, barcode, fk_barcode_type, price_level,	fk_warehouse, datec)',1),(28,'pays, country','t1zhf_c_country(rowid, code, code_iso, libelle, active)',1);

--
-- Table structure for table `t1zhf_loan`
--

CREATE TABLE `t1zhf_loan` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `entity` int NOT NULL DEFAULT '1',
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `label` varchar(80) COLLATE utf8mb3_unicode_ci NOT NULL,
  `fk_bank` int DEFAULT NULL,
  `capital` double(24,8) NOT NULL DEFAULT '0.00000000',
  `datestart` date DEFAULT NULL,
  `dateend` date DEFAULT NULL,
  `nbterm` double DEFAULT NULL,
  `rate` double NOT NULL,
  `note_private` text COLLATE utf8mb3_unicode_ci,
  `note_public` text COLLATE utf8mb3_unicode_ci,
  `capital_position` double(24,8) DEFAULT '0.00000000',
  `date_position` date DEFAULT NULL,
  `paid` smallint NOT NULL DEFAULT '0',
  `accountancy_account_capital` varchar(32) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `accountancy_account_insurance` varchar(32) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `accountancy_account_interest` varchar(32) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fk_projet` int DEFAULT NULL,
  `fk_user_author` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `active` tinyint NOT NULL DEFAULT '1',
  `insurance_amount` double(24,8) DEFAULT '0.00000000',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_loan`
--


--
-- Table structure for table `t1zhf_loan_schedule`
--

CREATE TABLE `t1zhf_loan_schedule` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_loan` int DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datep` datetime DEFAULT NULL,
  `amount_capital` double(24,8) DEFAULT '0.00000000',
  `amount_insurance` double(24,8) DEFAULT '0.00000000',
  `amount_interest` double(24,8) DEFAULT '0.00000000',
  `fk_typepayment` int NOT NULL,
  `num_payment` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `note_private` text COLLATE utf8mb3_unicode_ci,
  `note_public` text COLLATE utf8mb3_unicode_ci,
  `fk_bank` int NOT NULL,
  `fk_user_creat` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `fk_payment_loan` int DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_loan_schedule_ref` (`fk_loan`,`datep`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_loan_schedule`
--


--
-- Table structure for table `t1zhf_localtax`
--

CREATE TABLE `t1zhf_localtax` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `entity` int NOT NULL DEFAULT '1',
  `localtaxtype` tinyint DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datep` date DEFAULT NULL,
  `datev` date DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `label` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8mb3_unicode_ci,
  `fk_bank` int DEFAULT NULL,
  `fk_user_creat` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_localtax`
--


--
-- Table structure for table `t1zhf_mailing`
--

CREATE TABLE `t1zhf_mailing` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `messtype` varchar(16) COLLATE utf8mb3_unicode_ci DEFAULT 'email',
  `statut` smallint DEFAULT '0',
  `titre` varchar(128) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `entity` int NOT NULL DEFAULT '1',
  `sujet` varchar(128) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `body` mediumtext COLLATE utf8mb3_unicode_ci,
  `bgcolor` varchar(8) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `bgimage` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cible` varchar(60) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `nbemail` int DEFAULT NULL,
  `email_from` varchar(160) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name_from` varchar(128) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email_replyto` varchar(160) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email_errorsto` varchar(160) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `tag` varchar(128) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `date_creat` datetime DEFAULT NULL,
  `date_valid` datetime DEFAULT NULL,
  `date_appro` datetime DEFAULT NULL,
  `date_envoi` datetime DEFAULT NULL,
  `fk_user_creat` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `fk_user_valid` int DEFAULT NULL,
  `fk_user_appro` int DEFAULT NULL,
  `extraparams` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `joined_file1` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `joined_file2` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `joined_file3` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `joined_file4` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `tms` timestamp NULL DEFAULT NULL,
  `evenunsubscribe` smallint DEFAULT '0',
  `note_private` text COLLATE utf8mb3_unicode_ci,
  `note_public` text COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_mailing` (`titre`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_mailing`
--


--
-- Table structure for table `t1zhf_mailing_advtarget`
--

CREATE TABLE `t1zhf_mailing_advtarget` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `name` varchar(180) COLLATE utf8mb3_unicode_ci NOT NULL,
  `entity` int NOT NULL DEFAULT '1',
  `fk_element` int NOT NULL,
  `type_element` varchar(180) COLLATE utf8mb3_unicode_ci NOT NULL,
  `filtervalue` text COLLATE utf8mb3_unicode_ci,
  `fk_user_author` int NOT NULL,
  `datec` datetime NOT NULL,
  `fk_user_mod` int NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_advtargetemailing_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_mailing_advtarget`
--


--
-- Table structure for table `t1zhf_mailing_cibles`
--

CREATE TABLE `t1zhf_mailing_cibles` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_mailing` int NOT NULL,
  `fk_contact` int NOT NULL,
  `lastname` varchar(160) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `firstname` varchar(160) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email` varchar(160) COLLATE utf8mb3_unicode_ci NOT NULL,
  `other` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `tag` varchar(64) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `statut` smallint NOT NULL DEFAULT '0',
  `source_url` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `source_id` int DEFAULT NULL,
  `source_type` varchar(32) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `date_envoi` datetime DEFAULT NULL,
  `error_text` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `tms` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_mailing_cibles` (`fk_mailing`,`email`),
  KEY `idx_mailing_cibles_email` (`email`),
  KEY `idx_mailing_cibles_tag` (`tag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_mailing_cibles`
--


--
-- Table structure for table `t1zhf_mailing_unsubscribe`
--

CREATE TABLE `t1zhf_mailing_unsubscribe` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `entity` int NOT NULL DEFAULT '1',
  `email` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `unsubscribegroup` varchar(128) COLLATE utf8mb3_unicode_ci DEFAULT '',
  `ip` varchar(128) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `date_creat` datetime DEFAULT NULL,
  `tms` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_mailing_unsubscribe` (`email`,`entity`,`unsubscribegroup`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_mailing_unsubscribe`
--


--
-- Table structure for table `t1zhf_menu`
--

CREATE TABLE `t1zhf_menu` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `menu_handler` varchar(16) COLLATE utf8mb3_unicode_ci NOT NULL,
  `entity` int NOT NULL DEFAULT '1',
  `module` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `type` varchar(4) COLLATE utf8mb3_unicode_ci NOT NULL,
  `mainmenu` varchar(100) COLLATE utf8mb3_unicode_ci NOT NULL,
  `leftmenu` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fk_menu` int NOT NULL,
  `fk_mainmenu` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fk_leftmenu` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `position` int NOT NULL,
  `url` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `target` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `titre` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `prefix` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `langs` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `level` smallint DEFAULT NULL,
  `perms` text COLLATE utf8mb3_unicode_ci,
  `enabled` text COLLATE utf8mb3_unicode_ci,
  `usertype` int NOT NULL DEFAULT '0',
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`rowid`),
  KEY `idx_menu_menuhandler_type` (`menu_handler`,`type`)
) ENGINE=InnoDB AUTO_INCREMENT=401 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_menu`
--

INSERT INTO `t1zhf_menu` VALUES (92,'all',1,'process','left','',NULL,-1,'commercial','orders',110,'/process/commande/fullcalendar.php','','CalendarProcess',NULL,'process@process',NULL,'1','1',2,'2019-05-02 10:58:08'),(93,'all',1,'process','left','',NULL,-1,'commercial','orders_suppliers',110,'/process/fourn/commande/fullcalendar.php','','CalendarProcess',NULL,'process@process',NULL,'1','1',2,'2019-05-02 10:58:08'),(94,'all',1,'process','left','',NULL,-1,'commercial','propals',110,'/process/propal/fullcalendar.php','','CalendarProcess',NULL,'process@process',NULL,'1','1',2,'2019-05-02 10:58:08'),(95,'all',1,'process','left','',NULL,-1,'billing','customers_bills',110,'/process/facture/fullcalendar.php','','CalendarProcess',NULL,'process@process',NULL,'1','1',2,'2019-05-02 10:58:08'),(96,'all',1,'process','left','',NULL,-1,'billing','suppliers_bills',110,'/process/fourn/facture/fullcalendar.php','','CalendarProcess',NULL,'process@process',NULL,'1','1',2,'2019-05-02 10:58:08'),(97,'all',1,'process','left','',NULL,-1,'project','projects',122,'/process/projet/fullcalendar.php','','CalendarProcess',NULL,'process@process',NULL,'1','1',2,'2019-05-02 10:58:08'),(98,'all',1,'process','left','agenda','agenda',79,'agenda','agenda',102,'/process/action/fullcalendar.php','','AgendaProcess',NULL,'process@process',NULL,'$user->rights->agenda->allactions->read','1',2,'2019-05-02 10:58:08'),(99,'all',1,'process','left','',NULL,-1,'commercial','ficheinter',100,'/process/fichinter/fullcalendar.php','','CalendarProcess',NULL,'process@process',NULL,'1','1',2,'2019-05-02 10:58:08'),(100,'all',1,'process','left','',NULL,-1,'products','factory',110,'/process/factory/fullcalendar.php','','CalendarProcess',NULL,'process@process',NULL,'1','1',2,'2019-05-02 10:58:08'),(101,'all',1,'process','left','',NULL,-1,'products','equipement',110,'/process/equipement/fullcalendar.php','','Agenda',NULL,'process@process',NULL,'1','1',2,'2019-05-02 10:58:08'),(102,'all',1,'process','left','',NULL,-1,'products','move',110,'/process/localise/fullcalendar.php','','Agenda',NULL,'process@process',NULL,'1','1',2,'2019-05-02 10:58:08'),(138,'all',1,'cdav','left','companies','contacts',-1,'companies','contacts',190,'/cdav/cdavurls.php?type=CardDAV&amp;leftmenu=contacts','','CardDAVurl',NULL,'cdav@cdav',NULL,'$user->rights->societe->contact->lire','$conf->cdav->enabled',0,'2020-10-16 13:33:27'),(139,'all',1,'cdav','left','agenda',NULL,-1,'agenda',NULL,190,'/cdav/cdavurls.php?type=CalDAV&amp;mainmenu=agenda','','CalDAVurl',NULL,'cdav@cdav',NULL,'$user->rights->agenda->myactions->read','$conf->cdav->enabled',0,'2020-10-16 13:33:27'),(140,'all',1,'cdav','left','agenda',NULL,-1,'agenda',NULL,190,'/cdav/cdavurls.php?type=ICS&amp;mainmenu=agenda','','ICSurl',NULL,'cdav@cdav',NULL,'$user->rights->agenda->myactions->read','$conf->cdav->enabled',0,'2020-10-16 13:33:27'),(184,'all',1,'ship2bill','left','products','sendings',-1,'products','sendings',100,'/ship2bill/ship2bill.php','','Exp&eacute;ditions facturables',NULL,'',NULL,'$user->rights->ship2bill->read && $user->rights->expedition->lire','$conf->ship2bill->enabled',2,'2021-06-07 12:20:31'),(220,'all',1,'partnership','left','companies','partnership',-1,'companies',NULL,1101,'/partnership/partnership_list.php','','Partnership','<span class=\"fas fa-handshake  em080 paddingright pictofixedwidth\" style=\" color: #6c6aa8;\"></span>','partnership',NULL,'$user->rights->partnership->read','$conf->partnership->enabled',2,'2023-05-30 15:18:45'),(221,'all',1,'partnership','left','companies','partnership_new',-1,'companies','partnership',1102,'/partnership/partnership_card.php?action=create','','NewPartnership','','partnership',NULL,'$user->rights->partnership->write','$conf->partnership->enabled',2,'2023-05-30 15:18:45'),(222,'all',1,'partnership','left','companies','partnership_list',-1,'companies','partnership',1103,'/partnership/partnership_list.php','','ListOfPartnerships','','partnership',NULL,'$user->rights->partnership->read','$conf->partnership->enabled',2,'2023-05-30 15:18:45'),(226,'all',1,'eventorganization','left','project','eventorganization',-1,'project',NULL,1001,'','','EventOrganizationMenuLeft','<span class=\"fas fa-project-diagram  em088 infobox-project paddingright pictofixedwidth\" style=\"\"></span>','eventorganization',NULL,'$user->rights->eventorganization->read','$conf->eventorganization->enabled',2,'2023-05-30 15:19:47'),(227,'all',1,'eventorganization','left','project',NULL,-1,'project','eventorganization',1002,'/projet/list.php?search_usage_event_organization=1&search_status=99&mainmenu=project&contextpage=organizedevents','','List','','eventorganization@eventorganization',NULL,'$user->rights->eventorganization->read','$conf->eventorganization->enabled',2,'2023-05-30 15:19:47'),(228,'all',1,'eventorganization','left','project',NULL,-1,'project','eventorganization',1003,'/projet/card.php?leftmenu=projects&action=create&usage_organize_event=1&usage_opportunity=0','','New','','eventorganization@eventorganization',NULL,'$user->rights->eventorganization->write','$conf->eventorganization->enabled',2,'2023-05-30 15:19:47'),(229,'all',1,'eventorganization','left','project','eventorganizationconforbooth',-1,'project',NULL,1004,'','','ConferenceOrBooth','<span class=\"fas fa-chalkboard-teacher  em088 infobox-project paddingright pictofixedwidth\" style=\"\"></span>','eventorganization',NULL,'$user->rights->eventorganization->read','$conf->eventorganization->enabled',2,'2023-05-30 15:19:47'),(230,'all',1,'eventorganization','left','project',NULL,-1,'project','eventorganizationconforbooth',1005,'/eventorganization/conferenceorbooth_list.php?mainmenu=project','','List','','eventorganization',NULL,'$user->rights->eventorganization->read','$conf->eventorganization->enabled',2,'2023-05-30 15:19:47'),(231,'all',1,'eventorganization','left','project',NULL,-1,'project','eventorganizationconforbooth',1006,'/eventorganization/conferenceorbooth_card.php?leftmenu=projects&action=create','','New','','eventorganization',NULL,'$user->rights->eventorganization->write','$conf->eventorganization->enabled',2,'2023-05-30 15:19:47'),(314,'all',1,'scaninvoices','left','billing','supplier_bills_scaninvoices',-1,'billing','suppliers_bills',1001,'/scaninvoices/filestoimport_list.php','','ModuleScanInvoicesImportListing','','scaninvoices@scaninvoices',NULL,'$user->rights->scaninvoices->read','$conf->scaninvoices->enabled',2,'2024-09-18 09:12:21'),(315,'all',1,'scaninvoices','left','billing','supplier_bills_manual_import',-1,'billing','supplier_bills_scaninvoices',1002,'/scaninvoices/importinvoice.php','','ModuleScanInvoicesNameManual','','scaninvoices@scaninvoices',NULL,'$user->rights->scaninvoices->write','$conf->scaninvoices->enabled',2,'2024-09-18 09:12:21'),(316,'all',1,'scaninvoices','left','billing','supplier_bills_auto_import',-1,'billing','supplier_bills_scaninvoices',1003,'/scaninvoices/importauto.php','','ModuleScanInvoicesImportAuto','','scaninvoices@scaninvoices',NULL,'$user->rights->scaninvoices->write','$conf->scaninvoices->enabled',2,'2024-09-18 09:12:21'),(329,'all',1,'nomenclature','left','products','nomenclature',-1,'products',NULL,100,'/nomenclature/massUpdate.php','','massUpdateMenu','','nomenclature@nomenclature',NULL,'$user->hasRight(\"nomenclature\",\"global\",\"massUpdate\")','isModEnabled(\"nomenclature\")',0,'2024-09-23 14:36:00'),(330,'all',1,'nomenclature','left','products','nomenclature',-1,'products','product',100,'/nomenclature/list.php','','Nomenclatures','','nomenclature@nomenclature',NULL,'$user->hasRight(\"nomenclature\",\"read\")','isModEnabled(\"nomenclature\")',0,'2024-09-23 14:36:00'),(331,'all',1,'workstationatm','left','project','workstationatmList',-1,'project',NULL,300,'/workstationatm/workstation.php','','Poste de charge','','workstationatm@workstationatm',NULL,'$user->hasRight(\"workstationatm\",\"all\",\"read\")','',2,'2024-09-23 14:36:05'),(332,'all',1,'workstationatm','left','project','workstationatmList',-1,'project','workstationatmList',301,'/workstationatm/workstation.php?action=new','','Nouveau poste de travail','','workstationatm@workstationatm',NULL,'$user->hasRight(\"workstationatm\",\"all\",\"read\")','',2,'2024-09-23 14:36:05'),(333,'all',1,'workstationatm','left','of','workstationatmList',-1,'of',NULL,211,'/workstationatm/workstation.php','','Poste de charge','','workstationatm@workstationatm',NULL,'$user->hasRight(\"workstationatm\",\"all\",\"read\")','$conf->workstationatm->enabled',2,'2024-09-23 14:36:05'),(334,'all',1,'workstationatm','left','of','workstationatmList',-1,'of','workstationatmList',222,'/workstationatm/workstation.php?action=new','','Nouveau poste de travail','','workstationatm@workstationatm',NULL,'$user->hasRight(\"workstationatm\",\"all\",\"read\")','$conf->workstationatm->enabled',2,'2024-09-23 14:36:05'),(335,'all',1,'of','top','of',NULL,0,NULL,NULL,100,'/of/liste_of.php','','GPAO','','of@of',NULL,'$user->hasRight(\"of\",\"of\",\"lire\")','$user->hasRight(\"of\",\"of\",\"lire\")',2,'2024-09-23 14:36:10'),(336,'all',1,'of','left','of','assetOFlist',-1,'of',NULL,300,'/of/liste_of.php','','AssetProductionOrder','','',NULL,'$user->hasRight(\"of\",\"of\",\"lire\")','',2,'2024-09-23 14:36:10'),(337,'all',1,'of','left','of',NULL,-1,'of','assetOFlist',312,'/of/liste_of.php?search_status_of=DRAFT','','AssetProductionOrderDraft','','',NULL,'$user->hasRight(\"of\",\"of\",\"lire\")','',2,'2024-09-23 14:36:10'),(338,'all',1,'of','left','of',NULL,-1,'of','assetOFlist',313,'/of/liste_of.php?search_status_of=NEEDOFFER','','AssetProductionOrderNEEDOFFER','','',NULL,'$user->hasRight(\"of\",\"of\",\"lire\")','',2,'2024-09-23 14:36:10'),(339,'all',1,'of','left','of','AssetProdSOrder',-1,'of','assetOFlist',314,'/of/liste_of.php?search_status_of=ONORDER','','AssetProductionOrderONORDER','','',NULL,'$user->hasRight(\"of\",\"of\",\"lire\")','',2,'2024-09-23 14:36:10'),(340,'all',1,'of','left','of','AssetProductionOrderONORDER',-1,'of','AssetProdSOrder',315,'/of/liste_of.php?mode=supplier_order','','AssetProductionSupplierOrder','','',NULL,'$user->hasRight(\"of\",\"of\",\"lire\")','',2,'2024-09-23 14:36:10'),(341,'all',1,'of','left','of',NULL,-1,'of','assetOFlist',316,'/of/liste_of.php?search_status_of=VALID','','AssetProductionOrderVALID','','',NULL,'$user->hasRight(\"of\",\"of\",\"lire\")','',2,'2024-09-23 14:36:10'),(342,'all',1,'of','left','of',NULL,-1,'of','assetOFlist',317,'/of/liste_of.php?search_status_of=OPEN','','AssetProductionOrderOPEN','','',NULL,'$user->hasRight(\"of\",\"of\",\"lire\")','',2,'2024-09-23 14:36:10'),(343,'all',1,'of','left','of',NULL,-1,'of','assetOFlist',318,'/of/liste_of.php?search_status_of=CLOSE','','AssetProductionOrderCLOSE','','',NULL,'$user->hasRight(\"of\",\"of\",\"lire\")','',2,'2024-09-23 14:36:10'),(344,'all',1,'of','left','of',NULL,-1,'of','assetOFlist',319,'/of/liste_of.php?mode=non_compliant','','AssetProductionOrderNONCOMPLIANT','','',NULL,'$user->hasRight(\"of\",\"of\",\"lire\")','getDolGlobalInt(\"OF_MANAGE_NON_COMPLIANT\")',2,'2024-09-23 14:36:10'),(345,'all',1,'of','left','of',NULL,-1,'of','assetOFlist',320,'/of/fiche_of.php?action=new','','AssetNewProductionOrder','','',NULL,'$user->hasRight(\"of\",\"of\",\"lire\")','',2,'2024-09-23 14:36:10'),(346,'all',1,'of','left','of',NULL,-1,'of','assetOFlist',321,'/of/shipable_prev.php','','ShippablePrevReport','','',NULL,'$user->hasRight(\"of\",\"of\",\"lire\")','',2,'2024-09-23 14:36:10'),(356,'all',1,'bookcal','left','agenda','bookcal',-1,'agenda',NULL,1101,'/bookcal/bookcalindex.php','','MenuBookcalIndex','<span class=\"fas fa-calendar-check paddingright pictofixedwidth em92\" style=\"\"></span>','bookcal',NULL,'$user->rights->bookcal->calendar->read','1',0,'2024-09-25 16:30:29'),(357,'all',1,'bookcal','left','agenda','bookcal_calendar_list',-1,'agenda','bookcal',1102,'/bookcal/calendar_list.php','','Calendar','','bookcal',NULL,'$user->rights->bookcal->calendar->read','$conf->bookcal->enabled',2,'2024-09-25 16:30:29'),(358,'all',1,'bookcal','left','agenda','bookcal_new',-1,'agenda','bookcal_calendar_list',1103,'/bookcal/calendar_card.php?action=create','','NewCalendar','','bookcal',NULL,'$user->rights->bookcal->calendar->read','$conf->bookcal->enabled',2,'2024-09-25 16:30:29'),(359,'all',1,'bookcal','left','agenda','bookcal_availabilities',-1,'agenda','bookcal',1204,'/bookcal/availabilities_list.php','','Availabilities','','bookcal',NULL,'$user->rights->bookcal->availabilities->read','$conf->bookcal->enabled',2,'2024-09-25 16:30:29'),(360,'all',1,'bookcal','left','agenda','bookcal_availabilities',-1,'agenda','bookcal_availabilities',1205,'/bookcal/availabilities_card.php?action=create','','NewAvailabilities','','bookcal',NULL,'$user->rights->bookcal->availabilities->read','$conf->bookcal->enabled',2,'2024-09-25 16:30:29'),(361,'all',1,'agenda','top','agenda',NULL,0,NULL,NULL,86,'/comm/action/index.php','','TMenuAgenda','<span class=\"fas fa-calendar-alt infobox-action pictofixedwidth\" style=\"\"></span>','agenda',NULL,'$user->hasRight(\"agenda\", \"myactions\", \"read\") || $user->hasRight(\"resource\", \"read\")','isModEnabled(\"agenda\") || isModEnabled(\"resource\")',2,'2024-09-25 16:59:52'),(362,'all',1,'agenda','left','agenda',NULL,361,NULL,NULL,100,'/comm/action/index.php?mainmenu=agenda&amp;leftmenu=agenda','','Actions','<span class=\"fas fa-calendar-alt infobox-action paddingright pictofixedwidth\" style=\"\"></span>','agenda',NULL,'$user->hasRight(\"agenda\", \"myactions\", \"read\")','isModEnabled(\"agenda\")',2,'2024-09-25 16:59:52'),(363,'all',1,'agenda','left','agenda',NULL,362,NULL,NULL,101,'/comm/action/card.php?mainmenu=agenda&amp;leftmenu=agenda&amp;action=create','','NewAction','','commercial',NULL,'($user->hasRight(\"agenda\", \"myactions\", \"create\") || $user->hasRight(\"agenda\", \"allactions\", \"create\"))','isModEnabled(\"agenda\")',2,'2024-09-25 16:59:52'),(364,'all',1,'agenda','left','agenda',NULL,362,NULL,NULL,140,'/comm/action/index.php?mainmenu=agenda&amp;leftmenu=agenda','','Calendar','','agenda',NULL,'$user->hasRight(\"agenda\", \"myactions\", \"read\")','isModEnabled(\"agenda\")',2,'2024-09-25 16:59:52'),(365,'all',1,'agenda','left','agenda',NULL,364,NULL,NULL,141,'/comm/action/index.php?mainmenu=agenda&amp;leftmenu=agenda&amp;status=todo&amp;filter=mine','','MenuToDoMyActions','','agenda',NULL,'$user->hasRight(\"agenda\", \"myactions\", \"read\")','isModEnabled(\"agenda\")',2,'2024-09-25 16:59:52'),(366,'all',1,'agenda','left','agenda',NULL,364,NULL,NULL,142,'/comm/action/index.php?mainmenu=agenda&amp;leftmenu=agenda&amp;status=done&amp;filter=mine','','MenuDoneMyActions','','agenda',NULL,'$user->hasRight(\"agenda\", \"myactions\", \"read\")','isModEnabled(\"agenda\")',2,'2024-09-25 16:59:52'),(367,'all',1,'agenda','left','agenda',NULL,364,NULL,NULL,143,'/comm/action/index.php?mainmenu=agenda&amp;leftmenu=agenda&amp;status=todo&amp;filtert=-1','','MenuToDoActions','','agenda',NULL,'$user->hasRight(\"agenda\", \"allactions\", \"read\")','isModEnabled(\"agenda\")',2,'2024-09-25 16:59:52'),(368,'all',1,'agenda','left','agenda',NULL,364,NULL,NULL,144,'/comm/action/index.php?mainmenu=agenda&amp;leftmenu=agenda&amp;status=done&amp;filtert=-1','','MenuDoneActions','','agenda',NULL,'$user->hasRight(\"agenda\", \"allactions\", \"read\")','isModEnabled(\"agenda\")',2,'2024-09-25 16:59:52'),(369,'all',1,'agenda','left','agenda',NULL,362,NULL,NULL,110,'/comm/action/list.php?mode=show_list&amp;mainmenu=agenda&amp;leftmenu=agenda','','List','','agenda',NULL,'$user->hasRight(\"agenda\", \"myactions\", \"read\")','isModEnabled(\"agenda\")',2,'2024-09-25 16:59:52'),(370,'all',1,'agenda','left','agenda',NULL,369,NULL,NULL,111,'/comm/action/list.php?mode=show_list&amp;mainmenu=agenda&amp;leftmenu=agenda&amp;status=todo&amp;filter=mine','','MenuToDoMyActions','','agenda',NULL,'$user->hasRight(\"agenda\", \"myactions\", \"read\")','isModEnabled(\"agenda\")',2,'2024-09-25 16:59:52'),(371,'all',1,'agenda','left','agenda',NULL,369,NULL,NULL,112,'/comm/action/list.php?mode=show_list&amp;mainmenu=agenda&amp;leftmenu=agenda&amp;status=done&amp;filter=mine','','MenuDoneMyActions','','agenda',NULL,'$user->hasRight(\"agenda\", \"myactions\", \"read\")','isModEnabled(\"agenda\")',2,'2024-09-25 16:59:52'),(372,'all',1,'agenda','left','agenda',NULL,369,NULL,NULL,113,'/comm/action/list.php?mode=show_list&amp;mainmenu=agenda&amp;leftmenu=agenda&amp;status=todo&amp;filtert=-1','','MenuToDoActions','','agenda',NULL,'$user->hasRight(\"agenda\", \"allactions\", \"read\")','isModEnabled(\"agenda\")',2,'2024-09-25 16:59:52'),(373,'all',1,'agenda','left','agenda',NULL,369,NULL,NULL,114,'/comm/action/list.php?mode=show_list&amp;mainmenu=agenda&amp;leftmenu=agenda&amp;status=done&amp;filtert=-1','','MenuDoneActions','','agenda',NULL,'$user->hasRight(\"agenda\", \"allactions\", \"read\")','isModEnabled(\"agenda\")',2,'2024-09-25 16:59:52'),(374,'all',1,'agenda','left','agenda',NULL,362,NULL,NULL,160,'/comm/action/rapport/index.php?mainmenu=agenda&amp;leftmenu=agenda','','Reportings','','agenda',NULL,'$user->hasRight(\"agenda\", \"allactions\", \"read\")','isModEnabled(\"agenda\")',2,'2024-09-25 16:59:52'),(375,'all',1,'agenda','left','agenda',NULL,362,NULL,NULL,170,'/categories/index.php?mainmenu=agenda&amp;leftmenu=agenda&type=10','','Categories','','agenda',NULL,'$user->hasRight(\"agenda\", \"allactions\", \"read\")','isModEnabled(\"category\")',2,'2024-09-25 16:59:52'),(376,'all',1,'barcode','left','tools','barcodeprint',-1,'tools',NULL,200,'/barcode/printsheet.php?mainmenu=tools&leftmenu=barcodeprint','','BarCodePrintsheet','<span class=\"fas fa-barcode paddingright pictofixedwidth\" style=\"\"></span>','products',NULL,'$user->hasRight(\"barcode\", \"read\")','isModEnabled(\"barcode\")',0,'2024-09-25 16:59:52'),(377,'all',1,'barcode','left','home',NULL,-1,'home','admintools',300,'/barcode/codeinit.php?mainmenu=home&leftmenu=admintools','','MassBarcodeInit','','products',NULL,'$user->admin','isModEnabled(\"barcode\") && preg_match(\'/^(admintools|all)/\',$leftmenu)',0,'2024-09-25 16:59:52'),(378,'all',1,'blockedlog','left','tools','blockedlogbrowser',-1,'tools',NULL,200,'/blockedlog/admin/blockedlog_list.php?mainmenu=tools&leftmenu=blockedlogbrowser','','BrowseBlockedLog','<span class=\"fas fa-cogs  em080 paddingright pictofixedwidth\" style=\" color: #999;\"></span>','blockedlog',NULL,'$user->hasRight(\"blockedlog\", \"read\")','isModEnabled(\"blockedlog\")',2,'2024-09-25 16:59:52'),(379,'all',1,'ecm','top','ecm',NULL,0,NULL,NULL,82,'/ecm/index.php','','MenuECM','<span class=\"fas fa-folder-open pictofixedwidth\" style=\"\"></span>','ecm',NULL,'$user->rights->ecm->read || $user->rights->ecm->upload || $user->rights->ecm->setup','isModEnabled(\"ecm\")',2,'2024-09-25 16:59:52'),(380,'all',1,'ecm','left','ecm','ecm',-1,'ecm',NULL,101,'/ecm/index.php?mainmenu=ecm&leftmenu=ecm','','ECMArea','<span class=\"fas fa-folder-open paddingright pictofixedwidth\" style=\"\"></span>','ecm',NULL,'$user->rights->ecm->read || $user->rights->ecm->upload','$user->rights->ecm->read || $user->rights->ecm->upload',2,'2024-09-25 16:59:52'),(381,'all',1,'ecm','left','ecm','ecm_manual',-1,'ecm','ecm',102,'/ecm/index.php?action=file_manager&mainmenu=ecm&leftmenu=ecm','','ECMSectionsManual','','ecm',NULL,'$user->rights->ecm->read || $user->rights->ecm->upload','$user->rights->ecm->read || $user->rights->ecm->upload',2,'2024-09-25 16:59:52'),(382,'all',1,'ecm','left','ecm',NULL,-1,'ecm','ecm',103,'/ecm/index_auto.php?action=file_manager&mainmenu=ecm&leftmenu=ecm','','ECMSectionsAuto','','ecm',NULL,'$user->rights->ecm->read || $user->rights->ecm->upload','($user->rights->ecm->read || $user->rights->ecm->upload) && !getDolGlobalInt(\"ECM_AUTO_TREE_HIDEN\")',2,'2024-09-25 16:59:52'),(383,'all',1,'ecm','left','ecm',NULL,-1,'ecm','ecm',104,'/ecm/index_medias.php?action=file_manager&mainmenu=ecm&leftmenu=ecm','','ECMSectionsMedias','','ecm',NULL,'$user->rights->ecm->read || $user->rights->ecm->upload','($user->rights->ecm->read || $user->rights->ecm->upload) && getDolGlobalInt(\"MAIN_FEATURES_LEVEL\") == 2',2,'2024-09-25 16:59:52'),(384,'all',1,'margins','left','billing','margins',-1,'billing',NULL,100,'/margin/index.php','','Margins','<span class=\"fas fa-calculator infobox-bank_account paddingright pictofixedwidth\" style=\"\"></span>','margins',NULL,'$user->rights->margins->liretous','isModEnabled(\"margin\")',2,'2024-09-25 16:59:54'),(385,'all',1,'resource','left','agenda','resource',-1,'agenda',NULL,100,'/resource/list.php','','MenuResourceIndex','<span class=\"fas fa-laptop-house  em092 infobox-action paddingright pictofixedwidth em92\" style=\"\"></span>','resource',NULL,'$user->rights->resource->read','1',0,'2024-09-25 16:59:54'),(386,'all',1,'resource','left','agenda','resource_add',-1,'agenda','resource',101,'/resource/card.php?action=create','','MenuResourceAdd','','resource',NULL,'$user->rights->resource->write','1',0,'2024-09-25 16:59:54'),(387,'all',1,'resource','left','agenda','resource_list',-1,'agenda','resource',102,'/resource/list.php','','List','','resource',NULL,'$user->rights->resource->read','1',0,'2024-09-25 16:59:54'),(394,'all',1,'mylist','top','patastools','mylist',0,NULL,NULL,100,'/mylist/core/patastools.php?mainmenu=patastools&leftmenu=mylist','','PatasTools','','mylist@mylist',NULL,'','1',0,'2024-10-30 10:54:12'),(395,'all',1,'mylist','left','patastools','mylist',-1,'patastools',NULL,110,'/mylist/index.php','','myList','','mylist@mylist',NULL,'$user->rights->mylist->setup','1',2,'2024-10-30 10:54:12'),(396,'all',1,'mylist','left','',NULL,-1,'patastools','mylist',110,'/mylist/card.php?action=create','','NewList','','mylist@mylist',NULL,'$user->rights->mylist->setup','1',2,'2024-10-30 10:54:12'),(397,'all',1,'mylist','left','',NULL,-1,'patastools','mylist',110,'/mylist/list.php','','mylist','','mylist@mylist',NULL,'$user->rights->mylist->setup','1',2,'2024-10-30 10:54:12'),(398,'all',1,'mylist','left','',NULL,-1,'patastools','mylist',110,'/mylist/card.php?action=importexport','','ImportList','','mylist@mylist',NULL,'$user->rights->mylist->setup','1',2,'2024-10-30 10:54:12'),(399,'all',1,'listgpt','left','patastools','listgpt',-1,'patastools',NULL,120,'/listgpt/index.php','','ListGPT','<img src=\"/dolibarr/htdocs/custom/listgpt/img/object_listgpt.png\" alt=\"\" style=\"padding-right: 10px\">','listgpt@listgpt',NULL,'$user->hasRight(\"listgpt\", \"lire\")','1',2,'2024-10-30 11:38:03'),(400,'all',1,'visualquery','left','home','visualquery',-1,'home',NULL,100,'/visualquery/src/index.php','_blank','VisualQueryWithIcon','','visualquery@visualquery',NULL,'$user->rights->visualquery->use','1',2,'2024-10-31 10:16:07');

--
-- Table structure for table `t1zhf_mrp_mo`
--

CREATE TABLE `t1zhf_mrp_mo` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `ref` varchar(128) COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '(PROV)',
  `entity` int NOT NULL DEFAULT '1',
  `label` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `qty` double NOT NULL,
  `fk_warehouse` int DEFAULT NULL,
  `fk_soc` int DEFAULT NULL,
  `note_public` mediumtext COLLATE utf8mb3_unicode_ci,
  `note_private` mediumtext COLLATE utf8mb3_unicode_ci,
  `date_creation` datetime NOT NULL,
  `date_valid` datetime DEFAULT NULL,
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_user_creat` int NOT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `fk_user_valid` int DEFAULT NULL,
  `model_pdf` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `status` int NOT NULL,
  `fk_product` int NOT NULL,
  `date_start_planned` datetime DEFAULT NULL,
  `date_end_planned` datetime DEFAULT NULL,
  `fk_bom` int DEFAULT NULL,
  `fk_project` int DEFAULT NULL,
  `last_main_doc` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `mrptype` int DEFAULT '0',
  `fk_parent_line` int DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_mrp_mo_ref` (`ref`),
  KEY `idx_mrp_mo_entity` (`entity`),
  KEY `idx_mrp_mo_fk_soc` (`fk_soc`),
  KEY `fk_mrp_mo_fk_user_creat` (`fk_user_creat`),
  KEY `idx_mrp_mo_status` (`status`),
  KEY `idx_mrp_mo_fk_product` (`fk_product`),
  KEY `idx_mrp_mo_date_start_planned` (`date_start_planned`),
  KEY `idx_mrp_mo_date_end_planned` (`date_end_planned`),
  KEY `idx_mrp_mo_fk_bom` (`fk_bom`),
  KEY `idx_mrp_mo_fk_project` (`fk_project`),
  CONSTRAINT `fk_mrp_mo_fk_user_creat` FOREIGN KEY (`fk_user_creat`) REFERENCES `t1zhf_user` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_mrp_mo`
--

INSERT INTO `t1zhf_mrp_mo` VALUES (1,'MO2305-0001',1,NULL,1,1,NULL,NULL,NULL,'2023-05-30 18:37:07','2023-05-30 18:37:12','2023-05-30 16:37:36',1,NULL,1,NULL,NULL,3,5,NULL,NULL,1,NULL,NULL,0,NULL),(2,'MO2305-0002',1,NULL,10,1,NULL,NULL,NULL,'2023-05-30 18:59:35','2023-05-30 18:59:58','2023-05-30 17:01:38',1,1,1,NULL,NULL,3,5,'2023-05-29 00:00:00','2023-05-30 00:00:00',1,NULL,NULL,0,NULL),(3,'MO2409-0003',1,NULL,3,1,NULL,NULL,NULL,'2024-09-23 19:00:25','2024-09-23 19:00:34','2024-09-23 17:00:55',1,NULL,1,NULL,NULL,3,5,NULL,NULL,1,NULL,NULL,0,NULL);

--
-- Table structure for table `t1zhf_mrp_mo_extrafields`
--

CREATE TABLE `t1zhf_mrp_mo_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NULL DEFAULT NULL,
  `fk_object` int NOT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_mrp_mo_fk_object` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_mrp_mo_extrafields`
--


--
-- Table structure for table `t1zhf_mrp_production`
--

CREATE TABLE `t1zhf_mrp_production` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_mo` int NOT NULL,
  `origin_id` int DEFAULT NULL,
  `origin_type` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `position` int NOT NULL DEFAULT '0',
  `fk_product` int NOT NULL,
  `fk_warehouse` int DEFAULT NULL,
  `qty` double NOT NULL DEFAULT '1',
  `qty_frozen` smallint DEFAULT '0',
  `disable_stock_change` smallint DEFAULT '0',
  `batch` varchar(128) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `role` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fk_mrp_production` int DEFAULT NULL,
  `fk_stock_movement` int DEFAULT NULL,
  `date_creation` datetime NOT NULL,
  `tms` timestamp NULL DEFAULT NULL,
  `fk_user_creat` int NOT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fk_default_workstation` int DEFAULT NULL,
  `fk_unit` int DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `fk_mrp_production_product` (`fk_product`),
  KEY `fk_mrp_production_stock_movement` (`fk_stock_movement`),
  KEY `idx_mrp_production_fk_mo` (`fk_mo`),
  CONSTRAINT `fk_mrp_production_mo` FOREIGN KEY (`fk_mo`) REFERENCES `t1zhf_mrp_mo` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_mrp_production_product` FOREIGN KEY (`fk_product`) REFERENCES `t1zhf_product` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_mrp_production_stock_movement` FOREIGN KEY (`fk_stock_movement`) REFERENCES `t1zhf_stock_mouvement` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_mrp_production`
--

INSERT INTO `t1zhf_mrp_production` VALUES (1,1,NULL,NULL,1,5,NULL,1,NULL,0,NULL,'toproduce',NULL,NULL,'2023-05-30 18:37:07',NULL,1,NULL,NULL,NULL,NULL),(2,1,1,'bomline',1,4,NULL,2,NULL,0,NULL,'toconsume',NULL,NULL,'2023-05-30 18:37:07',NULL,1,NULL,NULL,NULL,NULL),(3,1,2,'bomline',2,59,NULL,1,NULL,0,NULL,'toconsume',NULL,NULL,'2023-05-30 18:37:07',NULL,1,NULL,NULL,NULL,NULL),(4,1,3,'bomline',3,51,NULL,1,NULL,0,NULL,'toconsume',NULL,NULL,'2023-05-30 18:37:07',NULL,1,NULL,NULL,NULL,NULL),(5,1,NULL,NULL,0,4,1,2,NULL,0,'','consumed',2,67,'2023-05-30 18:37:36',NULL,1,NULL,NULL,NULL,NULL),(6,1,NULL,NULL,1,59,1,1,NULL,0,'','consumed',3,68,'2023-05-30 18:37:36',NULL,1,NULL,NULL,NULL,NULL),(7,1,NULL,NULL,2,51,NULL,1,NULL,0,'','consumed',4,NULL,'2023-05-30 18:37:36',NULL,1,NULL,NULL,NULL,NULL),(8,1,NULL,NULL,0,5,1,1,NULL,0,'','produced',1,69,'2023-05-30 18:37:36',NULL,1,NULL,NULL,NULL,NULL),(13,2,NULL,NULL,1,5,NULL,10,NULL,0,NULL,'toproduce',NULL,NULL,'2023-05-30 18:59:44',NULL,1,NULL,NULL,NULL,NULL),(14,2,1,'bomline',1,4,NULL,20,NULL,0,NULL,'toconsume',NULL,NULL,'2023-05-30 18:59:44',NULL,1,NULL,NULL,NULL,NULL),(15,2,2,'bomline',2,59,NULL,10,NULL,0,NULL,'toconsume',NULL,NULL,'2023-05-30 18:59:44',NULL,1,NULL,NULL,NULL,NULL),(16,2,3,'bomline',3,51,NULL,10,NULL,0,NULL,'toconsume',NULL,NULL,'2023-05-30 18:59:44',NULL,1,NULL,NULL,NULL,NULL),(17,2,NULL,NULL,0,4,1,10,NULL,0,'','consumed',14,71,'2023-05-30 19:00:57',NULL,1,NULL,NULL,NULL,NULL),(18,2,NULL,NULL,1,59,1,5,NULL,0,'','consumed',15,72,'2023-05-30 19:00:57',NULL,1,NULL,NULL,NULL,NULL),(19,2,NULL,NULL,2,51,NULL,8,NULL,0,'','consumed',16,NULL,'2023-05-30 19:00:57',NULL,1,NULL,NULL,NULL,NULL),(20,2,NULL,NULL,0,4,1,10,NULL,0,'','consumed',14,73,'2023-05-30 19:01:38',NULL,1,NULL,NULL,NULL,NULL),(21,2,NULL,NULL,1,59,1,5,NULL,0,'','consumed',15,74,'2023-05-30 19:01:38',NULL,1,NULL,NULL,NULL,NULL),(22,2,NULL,NULL,2,51,NULL,2,NULL,0,'','consumed',16,NULL,'2023-05-30 19:01:38',NULL,1,NULL,NULL,NULL,NULL),(23,2,NULL,NULL,0,5,1,10,NULL,0,'','produced',13,75,'2023-05-30 19:01:38',NULL,1,NULL,NULL,NULL,NULL),(24,3,NULL,NULL,1,5,NULL,3,0,0,NULL,'toproduce',NULL,NULL,'2024-09-23 19:00:25',NULL,1,NULL,NULL,NULL,1),(25,3,1,'bomline',1,4,NULL,6,0,0,NULL,'toconsume',NULL,NULL,'2024-09-23 19:00:25',NULL,1,NULL,NULL,NULL,1),(26,3,2,'bomline',2,59,NULL,3,0,0,NULL,'toconsume',NULL,NULL,'2024-09-23 19:00:25',NULL,1,NULL,NULL,NULL,1),(27,3,3,'bomline',3,51,NULL,3,0,0,NULL,'toconsume',NULL,NULL,'2024-09-23 19:00:25',NULL,1,NULL,NULL,NULL,4),(28,3,NULL,NULL,0,4,1,6,0,0,'','consumed',25,113,'2024-09-23 19:00:55',NULL,1,NULL,NULL,NULL,NULL),(29,3,NULL,NULL,1,59,1,3,0,0,'','consumed',26,114,'2024-09-23 19:00:55',NULL,1,NULL,NULL,NULL,NULL),(30,3,NULL,NULL,2,51,NULL,3,0,0,'','consumed',27,NULL,'2024-09-23 19:00:55',NULL,1,NULL,NULL,NULL,NULL),(31,3,NULL,NULL,0,5,1,3,0,0,'','produced',24,115,'2024-09-23 19:00:55',NULL,1,NULL,NULL,NULL,NULL);

--
-- Table structure for table `t1zhf_mrp_production_extrafields`
--

CREATE TABLE `t1zhf_mrp_production_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_mrp_production_fk_object` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1zhf_mrp_production_extrafields`
--


--
-- Table structure for table `t1zhf_multicurrency`
--

CREATE TABLE `t1zhf_multicurrency` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `date_create` datetime DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `entity` int DEFAULT '1',
  `fk_user` int DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_multicurrency`
--


--
-- Table structure for table `t1zhf_multicurrency_rate`
--

CREATE TABLE `t1zhf_multicurrency_rate` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `date_sync` datetime DEFAULT NULL,
  `rate` double NOT NULL DEFAULT '0',
  `fk_multicurrency` int NOT NULL,
  `entity` int DEFAULT '1',
  `rate_indirect` double DEFAULT '0',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_multicurrency_rate`
--


--
-- Table structure for table `t1zhf_mylist`
--

CREATE TABLE `t1zhf_mylist` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `label` varchar(50) NOT NULL,
  `description` text,
  `titlemenu` varchar(20) DEFAULT NULL,
  `mainmenu` varchar(50) DEFAULT NULL,
  `leftmenu` varchar(50) DEFAULT NULL,
  `posmenu` varchar(50) DEFAULT '100',
  `elementtab` varchar(50) DEFAULT NULL,
  `author` varchar(50) DEFAULT NULL,
  `active` int DEFAULT NULL,
  `perms` text,
  `langs` text,
  `fieldinit` text,
  `fieldused` text,
  `querylist` text,
  `querydo` text,
  `forceall` int DEFAULT NULL,
  `export` int DEFAULT NULL,
  `datatable` int DEFAULT '0',
  `categories` varchar(10) DEFAULT NULL,
  `model_pdf` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1zhf_mylist`
--

INSERT INTO `t1zhf_mylist` VALUES (4,'Liste Devis','','Liste M','','','100','','patrice neveu',1,'1','','',NULL,'from llx_propal as p, llx_propaldet as pd where p.rowid = pd.fk_propal','',0,0,0,NULL,''),(5,'Liste P','','Liste P','project','projects','123','','patrice neveu',0,'1','','',NULL,'FROM llx_projet as p, llx_societe as s, llx_c_lead_status as t where p.fk_soc = s.rowid and p.fk_opp_status = t.rowid and p.fk_statut = 1\r\nORDER BY p.dateo desc','',0,0,0,NULL,''),(6,'Liste des produits','','myList','','','100','','patas-monkey.com',0,'$user->rights->produit->lire','product','',NULL,'FROM t1zhf_product as p LEFT JOIN t1zhf_product_extrafields as extra ON p.rowid = extra.fk_object WHERE p.fk_product_type = 0 AND p.entity IN (1)','',0,0,0,NULL,''),(21,'liste clients 2','','','','','100','','ListGPT',0,'','','',NULL,'\nFROM  t1zhf_societe s\nWHERE s.client = 1\nORDER BY s.nom ASC\n','',NULL,NULL,0,NULL,NULL),(22,'listeclient','je veux la liste des clients','','','','100','','ListGPT',0,'','','',NULL,'FROM t1zhf_societe s\r\nWHERE s.client = 1\r\nORDER BY s.nom ASC','',0,0,0,NULL,''),(23,'listeclient3','liste des facture avec nom du client','','','','100','','ListGPT',0,'','','',NULL,'FROM  t1zhf_societe s\r\nINNER JOIN t1zhf_facture fa ON s.rowid = fa.fk_soc\r\nWHERE s.client = 1\r\nORDER BY s.nom','',NULL,NULL,0,NULL,NULL);

--
-- Table structure for table `t1zhf_mylistdet`
--

CREATE TABLE `t1zhf_mylistdet` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fieldname` varchar(255) NOT NULL,
  `alias` varchar(64) NOT NULL,
  `fk_mylist` int NOT NULL,
  `tms` timestamp NULL DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `type` varchar(20) DEFAULT NULL,
  `pos` int DEFAULT NULL,
  `param` text,
  `align` varchar(10) DEFAULT '100',
  `enabled` varchar(255) DEFAULT NULL,
  `visible` int DEFAULT NULL,
  `filter` int DEFAULT NULL,
  `width` int DEFAULT NULL,
  `widthpdf` int DEFAULT NULL,
  `sumreport` int DEFAULT NULL,
  `avgreport` int DEFAULT NULL,
  `filterinit` varchar(255) DEFAULT NULL,
  `updatekey` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1zhf_mylistdet`
--

INSERT INTO `t1zhf_mylistdet` VALUES (23,'p.rowid','',4,NULL,'p.rowid','Number',1,'Propal:/comm/propal/class/propal.class.php','left','1',1,1,25,0,0,0,'',NULL),(24,'p.ref','',4,NULL,'p.ref','Text',2,'','left','1',1,1,150,0,0,0,'',NULL),(26,'pd.rowid','',4,NULL,'pd.rowid','Text',5,'','left','1',1,1,100,NULL,NULL,NULL,'',NULL),(27,'pd.qty','',4,NULL,'pd.qty','Text',6,'','left','1',1,1,100,0,0,0,'',NULL),(28,'pd.subprice','',4,NULL,'pd.subprice','Text',7,'','left','1',1,1,100,NULL,NULL,NULL,'',NULL),(29,'pd.total_ht','',4,NULL,'pd.total_ht','Text',8,'','left','1',1,1,100,NULL,NULL,NULL,'',NULL),(30,'p.ref','',5,NULL,'Reference','Text',1,'Project:/projet/class/project.class.php','left','1',1,1,25,0,0,0,'',NULL),(31,'p.title','',5,NULL,'Projet','Text',1,'','left','1',1,1,150,0,0,0,'',NULL),(32,'s.nom','',5,NULL,'Client','Text',3,'','left','1',1,1,100,0,0,0,'',NULL),(33,'p.description','',5,NULL,'Description','Text',4,'','left','1',1,1,200,0,0,0,'',NULL),(34,'t.label','',5,NULL,'Statut','Text',5,'','left','1',1,1,100,0,0,0,'',NULL),(35,'p.opp_amount','',5,NULL,'Montant','Price',6,'','left','1',1,1,100,0,0,0,'',NULL),(36,'p.rowid','',6,NULL,'ref','List',1,'Product:/product/class/product.class.php','left','1',1,1,0,0,0,0,'',NULL),(37,'p.label','',6,NULL,'label','Text',2,'','left','1',1,1,0,0,0,0,'',NULL),(38,'p.tms','',6,NULL,'DateModif','Date',3,'','left','1',1,1,0,0,0,0,'',NULL),(39,'p.price_ttc','',6,NULL,'pricettc','Number',4,'','right','1',1,1,0,0,0,0,'',NULL),(40,'p.stock','',6,NULL,'stock','Number',5,'','right','1',1,1,0,0,0,0,'',NULL),(41,'p.seuil_stock_alerte','',6,NULL,'alertstock','Number',6,'','right','1',1,1,0,0,0,0,'',NULL),(42,'p.tosell','',6,NULL,'tosell','Boolean',7,'','center','1',1,1,0,0,0,0,'',NULL),(43,'p.tobuy','',6,NULL,'tobuy','Boolean',8,'','center','1',1,1,0,0,0,0,'',NULL),(44,'p.pmp','',6,NULL,'pmp','Number',9,'','right','1',1,1,0,0,0,0,'',NULL),(102,'f.rowid','',21,NULL,'ref','List',1,'Facture:/compta/facture/class/facture.class.php:facture:facnumber','left','1',1,0,0,0,0,0,'',NULL),(103,'f.ref_client','',21,NULL,'RefClient','Text',2,'','left','1',0,0,0,0,0,0,'',NULL),(104,'f.datef','',21,NULL,'Date','Date',3,'','center','1',1,1,0,0,0,0,'',NULL),(105,'s.nom','',21,NULL,'Nom','Text',4,'','left','1',0,0,0,0,0,0,'',NULL);

--
-- Table structure for table `t1zhf_myobject`
--

CREATE TABLE `t1zhf_myobject` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `entity` int NOT NULL DEFAULT '1',
  `label` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `qty` int DEFAULT NULL,
  `status` int DEFAULT NULL,
  `date_creation` datetime NOT NULL,
  `tms` timestamp NOT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_myobject`
--


--
-- Table structure for table `t1zhf_myobject_extrafields`
--

CREATE TABLE `t1zhf_myobject_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NULL DEFAULT NULL,
  `fk_object` int NOT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_myobject_extrafields`
--


--
-- Table structure for table `t1zhf_mytable`
--

CREATE TABLE `t1zhf_mytable` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `entity` int NOT NULL DEFAULT '1',
  `fk_othertable` int NOT NULL,
  `name` varchar(189) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_fk_othertable` (`fk_othertable`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_mytable`
--


--
-- Table structure for table `t1zhf_nomenclature`
--

CREATE TABLE `t1zhf_nomenclature` (
  `rowid` int NOT NULL DEFAULT '0',
  `date_cre` datetime DEFAULT NULL,
  `date_maj` datetime DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fk_object` int NOT NULL DEFAULT '0',
  `fk_nomenclature_parent` int NOT NULL DEFAULT '0',
  `is_default` int NOT NULL DEFAULT '0',
  `qty_reference` double NOT NULL DEFAULT '0',
  `totalPRCMO_PMP` double NOT NULL DEFAULT '0',
  `totalPRCMO_OF` double NOT NULL DEFAULT '0',
  `totalPRCMO` double NOT NULL DEFAULT '0',
  `object_type` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `note_private` longtext COLLATE utf8mb3_unicode_ci,
  `non_secable` int NOT NULL DEFAULT '0',
  `marge_object` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `date_cre` (`date_cre`),
  KEY `date_maj` (`date_maj`),
  KEY `fk_object` (`fk_object`),
  KEY `fk_nomenclature_parent` (`fk_nomenclature_parent`),
  KEY `is_default` (`is_default`),
  KEY `qty_reference` (`qty_reference`),
  KEY `object_type` (`object_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_nomenclature`
--

INSERT INTO `t1zhf_nomenclature` VALUES (1,'2019-01-10 18:05:16','2024-09-23 16:02:04','veloroute',5,0,1,1,0,0,725,'product','',0,''),(4,'2019-02-11 13:05:36','2019-02-11 13:05:36','',8,0,0,1,0,0,0,'product','',0,NULL),(6,'2019-02-20 14:32:52','2024-09-23 16:02:04','veloroute2',9,0,1,1,0,0,518,'product','',0,''),(7,'2019-02-28 11:32:32','2019-02-28 11:33:55','',11,0,0,1,0,0,364,'product','',0,NULL),(10,'2019-07-13 10:51:28','2024-09-23 16:02:03','',4,0,0,1,0,0,0,'product','',0,''),(11,'2019-07-13 10:53:13','2019-07-13 10:54:00','',22,0,0,1,0,0,0,'product','',0,NULL),(12,'2019-07-13 11:11:22','2024-09-23 16:28:35','',24,0,0,1,0,0,1.1,'product','',0,''),(13,'2019-07-13 11:12:35','2024-09-23 16:28:34','',25,0,0,1,0,0,180,'product','',0,''),(14,'2019-07-14 20:31:31','2024-09-23 16:28:35','Tournage',27,0,0,1,0,0,0,'product','',0,''),(15,'2019-07-14 20:36:01','2019-07-14 20:36:08','',28,0,0,1,0,0,0,'product','',0,NULL),(20,'2019-12-09 11:18:23','2019-12-09 11:18:23','',8,1,0,1,0,0,175,'commande','',0,NULL),(23,'2020-06-22 15:08:07','2020-06-22 15:08:07','',12,1,0,1,0,0,190,'commande','',0,NULL),(24,'2020-06-22 15:08:07','2020-06-22 15:08:07','',13,13,0,1,0,0,0,'commande','',0,NULL),(25,'2020-06-22 15:08:07','2020-06-22 15:08:07','',15,1,0,1,0,0,170,'commande','',0,NULL),(28,'2021-05-26 16:22:59','2021-05-26 16:22:59','',29,13,0,1,0,0,160,'commande','',0,NULL),(29,'2021-07-08 11:06:55','2021-07-08 11:06:55','',34,7,0,1,0,0,364,'commande','',0,NULL),(30,'2021-07-08 11:06:55','2021-07-08 11:06:55','',40,13,0,1,0,0,69,'commande','',0,NULL),(31,'2021-07-15 14:55:07','2021-07-16 09:08:28','',47,0,0,1,0,0,200,'product','',0,NULL),(33,'2021-07-16 09:59:38','2021-07-16 10:20:14','',49,0,0,1,0,0,320,'product','',0,NULL),(34,'2021-07-16 10:29:27','2021-07-16 10:43:50','',147,33,0,1,0,0,1020,'propal','',0,NULL),(35,'2021-07-16 10:37:59','2021-07-16 10:45:01','',149,33,0,1,0,0,1120,'propal','',0,NULL),(36,'2021-07-16 11:01:56','2021-07-16 11:03:51','',54,0,0,1,0,0,1400,'product','',0,NULL),(37,'2021-07-16 11:06:34','2021-07-16 11:33:19','',152,36,0,1,0,0,1680,'propal','',0,NULL),(38,'2021-07-16 11:09:14','2021-07-16 11:09:27','',154,36,0,1,0,0,960,'propal','',0,NULL),(39,'2021-10-19 15:40:02','2021-10-19 15:40:02','',163,1,0,1,0,0,695,'propal','',0,NULL),(40,'2021-10-19 15:43:43','2021-10-19 15:43:43','',44,1,0,1,0,0,695,'commande','',0,NULL),(41,'2021-12-14 09:16:15','2021-12-14 09:18:19','',164,1,0,1,0,0,759,'propal','',0,NULL),(42,'2021-12-14 09:20:45','2021-12-14 09:21:14','',165,6,0,1,0,0,445,'propal','',0,NULL),(43,'2022-02-18 16:13:31','2022-02-18 16:14:06','',166,13,0,1,0,0,125,'propal','',0,NULL),(44,'2022-02-18 16:24:59','2022-02-18 16:24:59','',45,13,0,1,0,0,125,'commande','',0,NULL),(45,'2024-09-18 10:50:08','2024-09-18 10:53:40','caisson',69,0,0,1,0,0,99.2475,'product','',0,''),(46,'2024-09-18 11:02:27','2024-09-18 11:02:27','',61,45,0,1,0,0,138.495,'commande','',0,''),(47,'2024-09-18 11:02:37','2024-09-18 11:02:37','',62,45,0,1,0,0,138.495,'commande','',0,''),(48,'2024-09-18 11:02:58','2024-09-18 11:02:58','',63,0,0,1,0,0,0,'commande','',0,''),(49,'2024-09-18 11:03:40','2024-09-18 11:03:40','',296,0,0,1,0,0,0,'facture','',0,''),(50,'2024-09-18 11:04:36','2024-09-18 11:04:36','',297,0,0,1,0,0,0,'facture','',0,''),(51,'2024-09-18 11:05:31','2024-09-18 11:05:31','',298,0,0,1,0,0,0,'facture','',0,''),(52,'2024-09-18 11:07:28','2024-09-18 11:07:28','',64,45,0,1,0,0,138.495,'commande','',0,''),(53,'2024-09-18 11:08:02','2024-09-18 11:08:02','',65,0,0,1,0,0,0,'commande','',0,''),(54,'2024-09-18 11:09:17','2024-09-18 11:09:17','',66,0,0,1,0,0,0,'commande','',0,''),(55,'2024-09-18 11:10:44','2024-09-18 11:10:44','',299,13,0,1,0,0,120,'facture','',0,''),(56,'2024-09-18 11:15:36','2024-09-18 11:15:36','',197,0,0,1,0,0,0,'propal','',0,''),(57,'2024-09-18 11:15:45','2024-09-18 11:15:45','',198,36,0,1,0,0,1680,'propal','',0,''),(58,'2024-09-18 11:23:04','2024-09-18 11:23:04','',199,45,0,1,0,0,138.495,'propal','',0,''),(59,'2024-09-18 11:23:31','2024-09-18 11:23:31','',155,0,0,1,0,0,0,'propal','',0,''),(60,'2024-09-18 11:23:31','2024-09-18 11:23:31','',156,33,0,1,0,0,320,'propal','',0,''),(61,'2024-09-18 11:23:31','2024-09-18 11:23:31','',157,33,0,1,0,0,320,'propal','',0,''),(62,'2024-09-18 11:23:31','2024-09-18 11:23:31','',158,0,0,1,0,0,0,'propal','',0,''),(63,'2024-09-18 11:23:31','2024-09-18 11:23:31','',159,0,0,1,0,0,0,'propal','',0,''),(64,'2024-09-18 11:23:31','2024-09-18 11:23:31','',160,36,0,1,0,0,1680,'propal','',0,''),(65,'2024-09-18 11:23:31','2024-09-18 11:23:31','',161,36,0,1,0,0,1680,'propal','',0,''),(66,'2024-09-18 11:23:31','2024-09-18 11:23:31','',162,0,0,1,0,0,0,'propal','',0,''),(67,'2024-09-18 11:30:14','2024-09-18 11:30:14','',312,45,0,1,0,0,138.495,'facture','',0,''),(68,'2024-09-18 11:39:29','2024-09-18 11:39:29','',313,45,0,1,0,0,99.2475,'facture','',0,''),(69,'2024-09-18 11:42:40','2024-09-18 11:42:40','',67,45,0,1,0,0,99.2475,'commande','',0,''),(70,'2024-09-18 11:43:23','2024-09-18 11:43:23','',53,0,0,1,0,0,0,'commande','',0,''),(71,'2024-09-18 11:43:23','2024-09-18 11:43:23','',54,0,0,1,0,0,0,'commande','',0,''),(72,'2024-09-18 12:07:20','2024-09-18 12:07:20','',68,45,0,1,0,0,138.495,'commande','',0,''),(73,'2024-09-18 12:09:45','2024-09-18 12:09:45','',314,45,0,1,0,0,138.495,'facture','',0,''),(74,'2024-09-18 12:24:06','2024-09-18 12:24:06','',69,10,0,1,0,0,0,'commande','',0,''),(75,'2024-09-18 18:32:09','2024-09-18 18:32:09','',70,45,0,1,0,0,256.2375,'commande','',0,''),(76,'2024-09-18 18:40:13','2024-09-18 18:40:13','',71,12,0,1,0,0,12.1,'commande','',0,''),(77,'2024-09-18 18:49:27','2024-09-18 18:49:27','',72,12,0,1,0,0,48.4,'commande','',0,''),(78,'2024-09-18 18:52:24','2024-09-18 18:52:25','',73,0,0,1,0,0,0,'commande','',0,''),(79,'2024-09-18 18:54:04','2024-09-18 18:54:04','',74,0,0,1,0,0,0,'commande','',0,''),(80,'2024-09-18 18:56:36','2024-09-18 18:56:36','',75,45,0,1,0,0,256.2375,'commande','',0,''),(81,'2024-09-23 16:21:22','2024-09-23 16:21:22','',76,1,0,1,0,0,2265,'commande','',0,''),(82,'2024-09-23 16:32:52','2024-09-23 16:32:52','',77,13,0,1,0,0,180,'commande','',0,''),(83,'2024-09-23 18:39:22','2024-09-23 18:39:22','',78,45,0,1,0,0,138.495,'commande','',0,''),(84,'2024-09-23 18:56:39','2024-09-23 18:56:39','',79,1,0,1,0,0,7550,'commande','',0,''),(85,'2024-09-23 19:14:17','2024-09-23 19:14:17','',80,0,0,1,0,0,0,'commande','',0,''),(86,'2024-11-29 14:19:26','2024-11-29 14:19:26','',315,0,0,1,0,0,0,'facture','',0,''),(87,'2024-11-29 14:25:08','2024-11-29 14:25:08','',317,0,0,1,0,0,0,'facture','',0,''),(88,'2024-11-29 14:27:30','2024-11-29 14:27:30','',319,0,0,1,0,0,0,'facture','',0,''),(89,'2024-11-29 14:27:40','2024-11-29 14:27:41','',320,0,0,1,0,0,0,'facture','',0,''),(90,'2024-11-29 17:32:12','2024-11-29 17:32:12','',323,0,0,1,0,0,0,'facture','',0,''),(91,'2024-11-29 17:32:45','2024-11-29 17:32:45','',324,0,0,1,0,0,0,'facture','',0,''),(92,'2024-11-29 17:35:28','2024-11-29 17:35:28','',326,0,0,1,0,0,0,'facture','',0,''),(93,'2024-11-29 17:35:50','2024-11-29 17:35:50','',327,0,0,1,0,0,0,'facture','',0,'');

--
-- Table structure for table `t1zhf_nomenclature_coef`
--

CREATE TABLE `t1zhf_nomenclature_coef` (
  `rowid` int NOT NULL DEFAULT '0',
  `date_cre` datetime DEFAULT NULL,
  `date_maj` datetime DEFAULT NULL,
  `label` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `code_type` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `type` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `tx` double NOT NULL DEFAULT '0',
  `entity` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`rowid`),
  KEY `date_cre` (`date_cre`),
  KEY `date_maj` (`date_maj`),
  KEY `code_type` (`code_type`),
  KEY `type` (`type`),
  KEY `entity` (`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_nomenclature_coef`
--

INSERT INTO `t1zhf_nomenclature_coef` VALUES (1,'2019-01-10 16:39:43','2021-07-16 10:17:21','Marge Total','Coef. de marge','coef_marge','nomenclature',1.1,1),(2,'2019-01-14 12:17:52','2021-07-16 10:16:54','MargeAtelier','Coefficient sur main d\'oeuvre','margea','workstation',1.2,1),(3,'2019-01-14 12:23:11','2021-07-16 10:16:45','CoeffMarge','Coefficient sur nomenclature','CoeffMarge','nomenclature',1.2,1),(4,'2019-01-14 12:27:16','2019-01-14 12:27:16','PasdeCoeff','','PasdeCoeff','nomenclature',1,1),(5,'2024-09-18 10:22:30','2024-09-18 10:22:30','Marge Finale','Coef. du prix de vente conseillé','coef_final','pricefinal',1.1,1);

--
-- Table structure for table `t1zhf_nomenclature_coef_object`
--

CREATE TABLE `t1zhf_nomenclature_coef_object` (
  `rowid` int NOT NULL DEFAULT '0',
  `date_cre` datetime DEFAULT NULL,
  `date_maj` datetime DEFAULT NULL,
  `fk_object` int NOT NULL DEFAULT '0',
  `type_object` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `code_type` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `type` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `tx_object` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`rowid`),
  KEY `date_cre` (`date_cre`),
  KEY `date_maj` (`date_maj`),
  KEY `fk_object` (`fk_object`),
  KEY `type_object` (`type_object`),
  KEY `code_type` (`code_type`),
  KEY `type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_nomenclature_coef_object`
--


--
-- Table structure for table `t1zhf_nomenclature_feedback`
--

CREATE TABLE `t1zhf_nomenclature_feedback` (
  `rowid` int NOT NULL DEFAULT '0',
  `date_cre` datetime DEFAULT NULL,
  `date_maj` datetime DEFAULT NULL,
  `fk_origin` int NOT NULL DEFAULT '0',
  `fk_nomenclature` int NOT NULL DEFAULT '0',
  `fk_product` int NOT NULL DEFAULT '0',
  `fk_warehouse` int NOT NULL DEFAULT '0',
  `origin` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `stockAllowed` double NOT NULL DEFAULT '0',
  `qtyUsed` double NOT NULL DEFAULT '0',
  `note` longtext COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`rowid`),
  KEY `date_cre` (`date_cre`),
  KEY `date_maj` (`date_maj`),
  KEY `fk_origin` (`fk_origin`),
  KEY `fk_nomenclature` (`fk_nomenclature`),
  KEY `fk_product` (`fk_product`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_nomenclature_feedback`
--


--
-- Table structure for table `t1zhf_nomenclature_workstation`
--

CREATE TABLE `t1zhf_nomenclature_workstation` (
  `rowid` int NOT NULL DEFAULT '0',
  `date_cre` datetime DEFAULT NULL,
  `date_maj` datetime DEFAULT NULL,
  `fk_workstation` int NOT NULL DEFAULT '0',
  `fk_nomenclature` int NOT NULL DEFAULT '0',
  `rang` int NOT NULL DEFAULT '0',
  `unifyRang` int NOT NULL DEFAULT '0',
  `nb_hour` double NOT NULL DEFAULT '0',
  `nb_hour_prepare` double NOT NULL DEFAULT '0',
  `nb_hour_manufacture` double NOT NULL DEFAULT '0',
  `nb_days_before_beginning` double NOT NULL DEFAULT '0',
  `note_private` longtext COLLATE utf8mb3_unicode_ci,
  `code_type` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `date_cre` (`date_cre`),
  KEY `date_maj` (`date_maj`),
  KEY `fk_workstation` (`fk_workstation`),
  KEY `fk_nomenclature` (`fk_nomenclature`),
  KEY `rang` (`rang`),
  KEY `unifyRang` (`unifyRang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_nomenclature_workstation`
--

INSERT INTO `t1zhf_nomenclature_workstation` VALUES (1,'2019-01-10 18:31:23','2024-09-23 16:02:04',1,1,1,0,1,0,1,0,'','margea'),(2,'2019-01-10 18:32:21','2024-09-23 16:02:04',2,1,2,0,2,0,2,0,'','margea'),(11,'2019-02-20 14:32:52','2024-09-23 16:02:04',1,6,1,0,1,0,1,0,'','margea'),(12,'2019-02-20 14:32:52','2024-09-23 16:02:04',2,6,2,0,2,0,2,0,'','margea'),(13,'2019-02-20 14:35:01','2024-09-23 16:02:04',3,6,3,0,4,0,4,0,'','margea'),(14,'2019-02-28 11:33:33','2019-02-28 11:33:55',2,7,1,0,2,0,2,10,'','margea'),(21,'2019-12-09 11:18:23','2019-12-09 11:18:23',1,20,1,0,1,0,1,0,'','margea'),(22,'2019-12-09 11:18:23','2019-12-09 11:18:23',2,20,2,0,2,0,2,0,'','margea'),(27,'2020-06-22 15:08:07','2020-06-22 15:08:07',1,23,1,0,1,0,1,0,'','margea'),(28,'2020-06-22 15:08:07','2020-06-22 15:08:07',2,23,2,0,2,0,2,0,'','margea'),(29,'2020-06-22 15:08:07','2020-06-22 15:08:07',1,25,1,0,1,0,1,0,'','margea'),(30,'2020-06-22 15:08:07','2020-06-22 15:08:07',2,25,2,0,2,0,2,0,'','margea'),(35,'2021-05-26 16:22:59','2021-05-26 16:22:59',2,28,1,0,2,0,2,0,'','margea'),(36,'2021-07-08 11:06:55','2021-07-08 11:06:55',2,29,1,0,2,0,2,10,'','margea'),(37,'2021-07-16 11:02:08','2021-07-16 11:03:51',5,36,1,0,4,0,4,0,'','margea'),(38,'2021-07-16 11:02:14','2021-07-16 11:03:51',4,36,2,0,24,0,24,0,'','margea'),(39,'2021-07-16 11:06:34','2021-07-16 11:33:19',5,37,1,0,4,0,4,0,'','margea'),(40,'2021-07-16 11:06:34','2021-07-16 11:33:19',4,37,2,0,24,0,24,0,'','margea'),(41,'2021-07-16 11:09:14','2021-07-16 11:09:27',5,38,1,0,4,0,4,0,'','margea'),(42,'2021-07-16 11:09:14','2021-07-16 11:09:27',4,38,2,0,12,0,12,0,'','margea'),(43,'2021-10-19 15:40:02','2021-10-19 15:40:02',1,39,1,0,1,0,1,0,'','margea'),(44,'2021-10-19 15:40:02','2021-10-19 15:40:02',2,39,2,0,1,0,1,0,'','margea'),(45,'2021-10-19 15:43:43','2021-10-19 15:43:43',1,40,1,0,1,0,1,0,'','margea'),(46,'2021-10-19 15:43:43','2021-10-19 15:43:43',2,40,2,0,1,0,1,0,'','margea'),(47,'2021-12-14 09:16:15','2021-12-14 09:18:19',1,41,1,0,1,0,1,0,'','margea'),(48,'2021-12-14 09:16:15','2021-12-14 09:18:19',2,41,2,0,2,0,2,0,'','margea'),(49,'2021-12-14 09:20:45','2021-12-14 09:21:14',1,42,1,0,1,0,1,0,'','margea'),(50,'2021-12-14 09:20:45','2021-12-14 09:21:14',2,42,2,0,2,0,2,0,'','margea'),(51,'2021-12-14 09:20:45','2021-12-14 09:21:14',3,42,3,0,4,0,4,0,'','margea'),(52,'2024-09-18 10:53:14','2024-09-18 10:53:40',1,45,1,0,1.5,1,0.5,1,'','margea'),(53,'2024-09-18 11:02:27','2024-09-18 11:02:27',1,46,1,0,1.5,1,0.5,1,'','margea'),(54,'2024-09-18 11:02:37','2024-09-18 11:02:37',1,47,1,0,1.5,1,0.5,1,'','margea'),(55,'2024-09-18 11:07:28','2024-09-18 11:07:28',1,52,1,0,1.5,1,0.5,1,'','margea'),(56,'2024-09-18 11:15:45','2024-09-18 11:15:45',5,57,1,0,4,0,4,0,'','margea'),(57,'2024-09-18 11:15:45','2024-09-18 11:15:45',4,57,2,0,24,0,24,0,'','margea'),(58,'2024-09-18 11:23:04','2024-09-18 11:23:04',1,58,1,0,1.5,1,0.5,1,'','margea'),(59,'1970-01-01 01:00:00','2024-09-18 11:23:31',5,64,1,0,4,0,4,0,'','margea'),(60,'1970-01-01 01:00:00','2024-09-18 11:23:31',4,64,2,0,24,0,24,0,'','margea'),(61,'1970-01-01 01:00:00','2024-09-18 11:23:31',5,65,1,0,4,0,4,0,'','margea'),(62,'1970-01-01 01:00:00','2024-09-18 11:23:31',4,65,2,0,24,0,24,0,'','margea'),(63,'2024-09-18 11:30:14','2024-09-18 11:30:14',1,67,1,0,1.5,1,0.5,1,'','margea'),(64,'2024-09-18 11:39:29','2024-09-18 11:39:29',1,68,1,0,1.5,1,0.5,1,'','margea'),(65,'2024-09-18 11:42:40','2024-09-18 11:42:40',1,69,1,0,1.5,1,0.5,1,'','margea'),(66,'2024-09-18 12:07:20','2024-09-18 12:07:20',1,72,1,0,1.5,1,0.5,1,'','margea'),(67,'2024-09-18 12:09:45','2024-09-18 12:09:45',1,73,1,0,1.5,1,0.5,1,'','margea'),(68,'2024-09-18 18:32:09','2024-09-18 18:32:09',1,75,1,0,1.5,1,0.5,1,'','margea'),(69,'2024-09-18 18:56:36','2024-09-18 18:56:36',1,80,1,0,1.5,1,0.5,1,'','margea'),(70,'2024-09-23 16:21:22','2024-09-23 16:21:22',1,81,1,0,1,0,1,0,'','margea'),(71,'2024-09-23 16:21:22','2024-09-23 16:21:22',2,81,2,0,2,0,2,0,'','margea'),(72,'2024-09-23 16:28:22','2024-09-23 16:28:34',1,13,1,0,1,0,1,0,'','margea'),(73,'2024-09-23 16:32:52','2024-09-23 16:32:52',1,82,1,0,1,0,1,0,'','margea'),(74,'2024-09-23 18:39:22','2024-09-23 18:39:22',1,83,1,0,1.5,1,0.5,1,'','margea'),(75,'2024-09-23 18:56:39','2024-09-23 18:56:39',1,84,1,0,1,0,1,0,'','margea'),(76,'2024-09-23 18:56:39','2024-09-23 18:56:39',2,84,2,0,2,0,2,0,'','margea');

--
-- Table structure for table `t1zhf_nomenclature_workstation_thm_object`
--

CREATE TABLE `t1zhf_nomenclature_workstation_thm_object` (
  `rowid` int NOT NULL DEFAULT '0',
  `date_cre` datetime DEFAULT NULL,
  `date_maj` datetime DEFAULT NULL,
  `fk_workstation` int NOT NULL DEFAULT '0',
  `fk_object` int NOT NULL DEFAULT '0',
  `type_object` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `thm_object` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`rowid`),
  KEY `date_cre` (`date_cre`),
  KEY `date_maj` (`date_maj`),
  KEY `fk_object` (`fk_object`),
  KEY `type_object` (`type_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_nomenclature_workstation_thm_object`
--


--
-- Table structure for table `t1zhf_nomenclaturedet`
--

CREATE TABLE `t1zhf_nomenclaturedet` (
  `rowid` int NOT NULL DEFAULT '0',
  `date_cre` datetime DEFAULT NULL,
  `date_maj` datetime DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fk_product` int NOT NULL DEFAULT '0',
  `fk_nomenclature` int NOT NULL DEFAULT '0',
  `is_imported` int NOT NULL DEFAULT '0',
  `rang` int NOT NULL DEFAULT '0',
  `unifyRang` int NOT NULL DEFAULT '0',
  `fk_unit` int NOT NULL DEFAULT '0',
  `code_type` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `code_type2` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fk_fournprice` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `workstations` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `qty` double NOT NULL DEFAULT '0',
  `qty_base` double NOT NULL DEFAULT '0',
  `price` double NOT NULL DEFAULT '0',
  `tx_custom` double NOT NULL DEFAULT '0',
  `tx_custom2` double NOT NULL DEFAULT '0',
  `loss_percent` double NOT NULL DEFAULT '0',
  `buying_price` double NOT NULL DEFAULT '0',
  `note_private` longtext COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`rowid`),
  KEY `date_cre` (`date_cre`),
  KEY `date_maj` (`date_maj`),
  KEY `fk_product` (`fk_product`),
  KEY `fk_nomenclature` (`fk_nomenclature`),
  KEY `is_imported` (`is_imported`),
  KEY `rang` (`rang`),
  KEY `unifyRang` (`unifyRang`),
  KEY `fk_unit` (`fk_unit`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_nomenclaturedet`
--

INSERT INTO `t1zhf_nomenclaturedet` VALUES (1,'2019-01-10 18:05:37','2024-09-23 16:02:04','',3,1,0,0,0,1,'PasdeCoeff','','costprice','',1,0,0,1,0,0,0,''),(2,'2019-01-10 18:05:45','2024-09-23 16:02:04','',4,1,0,1,0,1,'PasdeCoeff','','costprice','',2,0,0,1,0,0,0,''),(7,'2019-02-20 14:32:52','2024-09-23 16:02:04','',3,6,0,0,0,1,'PasdeCoeff','','','',1,0,0,0,0,0,0,''),(8,'2019-02-20 14:32:52','2024-09-23 16:02:04','',4,6,0,1,0,1,'PasdeCoeff','','','',2,0,0,0,0,0,0,''),(11,'2019-02-28 11:32:40','2019-02-28 11:33:55','',17,7,0,0,0,1,'coef_marge','','','',2,0,0,0,0,0,0,''),(14,'2019-07-13 10:51:42','2024-09-23 16:02:03','',22,10,0,0,0,1,'coef_marge','','','',20,0,0,0,0,0,0,''),(15,'2019-07-13 10:53:46','2019-07-13 10:54:00','',23,11,0,0,0,1,'coef_marge','','','',1,0,0,0,0,0,0,''),(16,'2019-07-13 11:11:31','2024-09-23 16:28:35','',25,12,0,0,0,1,'coef_marge','','','',1,0,0,0,0,0,10,''),(17,'2019-07-13 11:12:43','2024-09-23 16:28:34','',26,13,0,0,0,1,'coef_marge','coef_marge','costprice','',1,0,120,1.1,1.1,0,0,''),(18,'2019-07-14 20:31:39','2024-09-23 16:28:35','',24,14,0,0,0,1,'coef_marge','','','',1,0,0,0,0,0,11,''),(19,'2019-07-14 20:34:56','2024-09-23 16:28:35','',28,12,0,1,0,1,'coef_marge','','','',1,0,0,0,0,0,0,''),(20,'2019-07-14 20:36:08','2019-07-14 20:36:08','',29,15,0,0,0,1,'coef_marge','','','',1,0,0,0,0,0,0,''),(28,'2019-12-09 11:18:23','2019-12-09 11:18:23','',3,20,0,0,0,1,'PasdeCoeff','','','',1,0,0,0,0,0,0,''),(29,'2019-12-09 11:18:23','2019-12-09 11:18:23','',4,20,0,1,0,1,'PasdeCoeff','','','',2,0,0,0,0,0,0,''),(33,'2020-06-22 15:08:07','2020-06-22 15:08:07','',3,23,0,0,0,1,'PasdeCoeff','','','',1,0,0,0,0,0,0,''),(34,'2020-06-22 15:08:07','2020-06-22 15:08:07','',4,23,0,1,0,1,'PasdeCoeff','','','',2,0,0,0,0,0,0,''),(35,'2020-06-22 15:08:07','2020-06-22 15:08:07','',26,24,0,0,0,1,'coef_marge','','','',1,0,0,0,0,0,0,''),(36,'2020-06-22 15:08:07','2020-06-22 15:08:07','',3,25,0,0,0,1,'PasdeCoeff','','','',1,0,0,0,0,0,0,''),(40,'2021-05-26 16:22:59','2021-05-26 16:22:59','',26,28,0,0,0,1,'coef_marge','','','',2,0,50,0,0,0,0,''),(41,'2021-07-08 11:06:55','2021-07-08 11:06:55','',17,29,0,0,0,1,'coef_marge','','','',2,0,0,0,0,0,0,''),(42,'2021-07-08 11:06:55','2021-07-08 11:06:55','',26,30,0,0,0,1,'coef_marge','','','',1,0,69,0,0,0,0,''),(43,'2021-07-15 14:55:37','2021-07-16 09:08:28','',48,31,0,0,0,4,'coef_marge','','','',4,0,200,0,0,0,0,''),(45,'2021-07-16 09:08:28','2021-07-16 09:08:28','',46,31,0,1,0,1,'coef_marge','','','',1,0,0,0,0,0,0,''),(47,'2021-07-16 10:00:35','2021-07-16 10:20:14','',50,33,0,1,1,1,'coef_marge','','costprice','',1,0,0,20,0,0,0,''),(48,'2021-07-16 10:00:46','2021-07-16 10:20:14','',52,33,0,2,2,1,'coef_marge','','costprice','',1,0,0,1,0,0,0,''),(49,'2021-07-16 10:00:55','2021-07-16 10:20:14','',51,33,0,3,3,1,'coef_marge','','costprice','',1,0,0,1,0,0,0,''),(50,'2021-07-16 10:08:59','2021-07-16 10:20:14','',53,33,0,0,0,1,'coef_marge','','costprice','',1,0,0,1,0,0,0,''),(51,'2021-07-16 10:29:27','2021-07-16 10:43:51','',53,34,0,0,0,1,'CoeffMarge','','costprice','',1,0,0,1.2,0,0,500,''),(52,'2021-07-16 10:29:27','2021-07-16 10:43:51','',50,34,0,1,1,1,'CoeffMarge','','costprice','',50,0,0,1.2,0,0,0,''),(53,'2021-07-16 10:29:27','2021-07-16 10:43:51','',52,34,0,2,2,1,'CoeffMarge','','costprice','',2,0,0,1.2,0,0,0,''),(54,'2021-07-16 10:29:27','2021-07-16 10:43:51','',51,34,0,3,3,1,'CoeffMarge','','costprice','',4,0,0,1.2,0,0,0,''),(55,'2021-07-16 10:37:59','2021-07-16 10:45:01','',53,35,0,0,0,1,'CoeffMarge','','costprice','',1,0,700,1.2,0,0,0,''),(56,'2021-07-16 10:37:59','2021-07-16 10:45:01','',50,35,0,1,1,1,'CoeffMarge','','costprice','',50,0,0,1.2,0,0,0,''),(57,'2021-07-16 10:37:59','2021-07-16 10:45:01','',52,35,0,2,2,1,'CoeffMarge','','costprice','',2,0,0,1.2,0,0,0,''),(58,'2021-07-16 10:37:59','2021-07-16 10:45:01','',51,35,0,3,3,1,'CoeffMarge','','costprice','',4,0,0,1.2,0,0,0,''),(59,'2021-10-19 15:28:39','2024-09-23 16:02:04','',30,1,0,2,0,6,'coef_marge','','','',1,0,0,0,0,0,0,''),(60,'2021-10-19 15:40:02','2021-10-19 15:40:02','',3,39,0,0,0,1,'PasdeCoeff','','costprice','',1,0,0,1,0,0,0,''),(61,'2021-10-19 15:40:02','2021-10-19 15:40:02','',4,39,0,1,0,1,'PasdeCoeff','','costprice','',2,0,0,1,0,0,0,''),(62,'2021-10-19 15:40:02','2021-10-19 15:40:02','',30,39,0,2,0,6,'coef_marge','','costprice','',1,0,0,1.1,0,0,0,''),(63,'2021-10-19 15:43:43','2021-10-19 15:43:43','',3,40,0,0,0,1,'PasdeCoeff','','costprice','',1,0,0,1,0,0,0,''),(64,'2021-10-19 15:43:43','2021-10-19 15:43:43','',4,40,0,1,0,1,'PasdeCoeff','','costprice','',2,0,0,1,0,0,0,''),(65,'2021-10-19 15:43:43','2021-10-19 15:43:43','',30,40,0,2,0,6,'coef_marge','','costprice','',1,0,0,1.1,0,0,0,''),(66,'2021-12-14 09:16:15','2021-12-14 09:18:19','',3,41,0,0,0,1,'PasdeCoeff','','costprice','',1,0,0,1,0,0,0,''),(67,'2021-12-14 09:16:15','2021-12-14 09:18:19','',4,41,0,1,0,1,'CoeffMarge','','costprice','',2,0,0,1.2,0,0,0,''),(68,'2021-12-14 09:16:15','2021-12-14 09:18:19','',30,41,0,2,0,6,'coef_marge','','costprice','',1,0,0,1.1,0,0,0,''),(69,'2021-12-14 09:20:45','2021-12-14 09:21:14','',3,42,0,0,0,1,'PasdeCoeff','','costprice','',1,0,0,1,0,0,0,''),(70,'2021-12-14 09:20:45','2021-12-14 09:21:14','',4,42,0,1,0,1,'PasdeCoeff','','costprice','',2,0,0,1,0,0,0,''),(71,'2022-02-18 16:13:31','2022-02-18 16:14:06','',26,43,0,0,0,1,'coef_marge','','costprice','',1,0,120,1.1,0,0,0,''),(72,'2022-02-18 16:13:53','2022-02-18 16:14:06','',32,43,0,1,0,1,'coef_marge','','costprice','',1,0,5,1.1,0,0,0,''),(73,'2022-02-18 16:24:59','2022-02-18 16:24:59','',26,44,0,0,0,1,'coef_marge','','costprice','',1,0,120,1.1,0,0,0,''),(74,'2022-02-18 16:24:59','2022-02-18 16:24:59','',32,44,0,1,0,1,'coef_marge','','costprice','',1,0,5,1.1,0,0,0,''),(75,'2024-09-18 10:50:40','2024-09-18 10:53:40','',59,45,0,0,0,1,'CoeffMarge','','costprice','',1,0,0,1.2,0,0,2,''),(76,'2024-09-18 10:51:24','2024-09-18 10:53:40','',66,45,0,1,0,1,'coef_marge','','costprice','',0.5,0,0,1.1,0,0,0,''),(77,'2024-09-18 11:02:27','2024-09-18 11:02:27','',59,46,0,0,0,1,'CoeffMarge','','costprice','',1,0,0,1.2,0,0,2,''),(78,'2024-09-18 11:02:27','2024-09-18 11:02:27','',66,46,0,1,0,1,'coef_marge','','costprice','',0.5,0,0,1.1,0,0,0,''),(79,'2024-09-18 11:02:37','2024-09-18 11:02:37','',59,47,0,0,0,1,'CoeffMarge','','costprice','',1,0,0,1.2,0,0,2,''),(80,'2024-09-18 11:02:37','2024-09-18 11:02:37','',66,47,0,1,0,1,'coef_marge','','costprice','',0.5,0,0,1.1,0,0,0,''),(81,'2024-09-18 11:07:28','2024-09-18 11:07:28','',59,52,0,0,0,1,'CoeffMarge','','costprice','',1,0,0,1.2,0,0,2,''),(82,'2024-09-18 11:07:28','2024-09-18 11:07:28','',66,52,0,1,0,1,'coef_marge','','costprice','',0.5,0,0,1.1,0,0,0,''),(83,'2024-09-18 11:10:44','2024-09-18 11:10:44','',26,55,0,0,0,1,'coef_marge','','costprice','',1,0,120,1.1,0,0,0,''),(84,'2024-09-18 11:23:04','2024-09-18 11:23:04','',59,58,0,0,0,1,'CoeffMarge','','costprice','',1,0,0,1.2,0,0,2,''),(85,'2024-09-18 11:23:04','2024-09-18 11:23:04','',66,58,0,1,0,1,'coef_marge','','costprice','',0.5,0,0,1.1,0,0,0,''),(86,'1970-01-01 01:00:00','2024-09-18 11:23:31','',53,60,0,0,0,1,'coef_marge','','costprice','',1,0,0,1,0,0,0,''),(87,'1970-01-01 01:00:00','2024-09-18 11:23:31','',50,60,0,1,1,1,'coef_marge','','costprice','',1,0,0,20,0,0,0,''),(88,'1970-01-01 01:00:00','2024-09-18 11:23:31','',52,60,0,2,2,1,'coef_marge','','costprice','',1,0,0,1,0,0,0,''),(89,'1970-01-01 01:00:00','2024-09-18 11:23:31','',51,60,0,3,3,1,'coef_marge','','costprice','',1,0,0,1,0,0,0,''),(90,'1970-01-01 01:00:00','2024-09-18 11:23:31','',53,61,0,0,0,1,'coef_marge','','costprice','',1,0,0,1,0,0,0,''),(91,'1970-01-01 01:00:00','2024-09-18 11:23:31','',50,61,0,1,1,1,'coef_marge','','costprice','',1,0,0,20,0,0,0,''),(92,'1970-01-01 01:00:00','2024-09-18 11:23:31','',52,61,0,2,2,1,'coef_marge','','costprice','',1,0,0,1,0,0,0,''),(93,'1970-01-01 01:00:00','2024-09-18 11:23:31','',51,61,0,3,3,1,'coef_marge','','costprice','',1,0,0,1,0,0,0,''),(94,'2024-09-18 11:30:14','2024-09-18 11:30:14','',59,67,0,0,0,1,'CoeffMarge','','costprice','',1,0,0,1.2,0,0,2,''),(95,'2024-09-18 11:30:14','2024-09-18 11:30:14','',66,67,0,1,0,1,'coef_marge','','costprice','',0.5,0,0,1.1,0,0,0,''),(96,'2024-09-18 11:39:29','2024-09-18 11:39:29','',59,68,0,0,0,1,'CoeffMarge','','costprice','',1,0,0,1.2,0,0,2,''),(97,'2024-09-18 11:39:29','2024-09-18 11:39:29','',66,68,0,1,0,1,'coef_marge','','costprice','',0.5,0,0,1.1,0,0,0,''),(98,'2024-09-18 11:42:40','2024-09-18 11:42:40','',59,69,0,0,0,1,'CoeffMarge','','costprice','',1,0,0,1.2,0,0,2,''),(99,'2024-09-18 11:42:40','2024-09-18 11:42:40','',66,69,0,1,0,1,'coef_marge','','costprice','',0.5,0,0,1.1,0,0,0,''),(100,'2024-09-18 12:07:20','2024-09-18 12:07:20','',59,72,0,0,0,1,'CoeffMarge','','costprice','',1,0,0,1.2,0,0,2,''),(101,'2024-09-18 12:07:20','2024-09-18 12:07:20','',66,72,0,1,0,1,'coef_marge','','costprice','',0.5,0,0,1.1,0,0,0,''),(102,'2024-09-18 12:09:45','2024-09-18 12:09:45','',59,73,0,0,0,1,'CoeffMarge','','costprice','',1,0,0,1.2,0,0,2,''),(103,'2024-09-18 12:09:45','2024-09-18 12:09:45','',66,73,0,1,0,1,'coef_marge','','costprice','',0.5,0,0,1.1,0,0,0,''),(104,'2024-09-18 12:24:06','2024-09-18 12:24:06','',22,74,0,0,0,1,'coef_marge','','','',20,0,0,0,0,0,0,''),(105,'2024-09-18 18:32:09','2024-09-18 18:32:09','',59,75,0,0,0,1,'CoeffMarge','','costprice','',1,0,0,1.2,0,0,2,''),(106,'2024-09-18 18:32:09','2024-09-18 18:32:09','',66,75,0,1,0,1,'coef_marge','','costprice','',0.5,0,0,1.1,0,0,0,''),(107,'2024-09-18 18:40:13','2024-09-18 18:40:13','',25,76,0,0,0,1,'coef_marge','','','',1,0,0,0,0,0,10,''),(108,'2024-09-18 18:40:13','2024-09-18 18:40:13','',28,76,0,1,0,1,'coef_marge','','','',1,0,0,0,0,0,0,''),(109,'2024-09-18 18:49:27','2024-09-18 18:49:27','',25,77,0,0,0,1,'coef_marge','','','',1,0,0,0,0,0,10,''),(110,'2024-09-18 18:49:27','2024-09-18 18:49:27','',28,77,0,1,0,1,'coef_marge','','','',1,0,0,0,0,0,0,''),(111,'2024-09-18 18:56:36','2024-09-18 18:56:36','',59,80,0,0,0,1,'CoeffMarge','','costprice','',1,0,0,1.2,0,0,2,''),(112,'2024-09-18 18:56:36','2024-09-18 18:56:36','',66,80,0,1,0,1,'coef_marge','','costprice','',0.5,0,0,1.1,0,0,0,''),(113,'2024-09-23 16:21:22','2024-09-23 16:21:22','',3,81,0,0,0,1,'PasdeCoeff','','costprice','',1,0,0,1,0,0,0,''),(114,'2024-09-23 16:21:22','2024-09-23 16:21:22','',4,81,0,1,0,1,'PasdeCoeff','','costprice','',2,0,0,1,0,0,0,''),(115,'2024-09-23 16:21:22','2024-09-23 16:21:22','',30,81,0,2,0,6,'coef_marge','','','',1,0,0,0,0,0,0,''),(116,'2024-09-23 16:32:52','2024-09-23 16:32:52','',26,82,0,0,0,1,'coef_marge','coef_marge','costprice','',1,0,120,1.1,1.1,0,0,''),(117,'2024-09-23 18:39:22','2024-09-23 18:39:22','',59,83,0,0,0,1,'CoeffMarge','','costprice','',1,0,0,1.2,0,0,2,''),(118,'2024-09-23 18:39:22','2024-09-23 18:39:22','',66,83,0,1,0,1,'coef_marge','','costprice','',0.5,0,0,1.1,0,0,0,''),(119,'2024-09-23 18:56:39','2024-09-23 18:56:39','',3,84,0,0,0,1,'PasdeCoeff','','costprice','',1,0,0,1,0,0,0,''),(120,'2024-09-23 18:56:39','2024-09-23 18:56:39','',4,84,0,1,0,1,'PasdeCoeff','','costprice','',2,0,0,1,0,0,0,''),(121,'2024-09-23 18:56:39','2024-09-23 18:56:39','',30,84,0,2,0,6,'coef_marge','','','',1,0,0,0,0,0,0,'');

--
-- Table structure for table `t1zhf_notify`
--

CREATE TABLE `t1zhf_notify` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `daten` datetime DEFAULT NULL,
  `fk_action` int NOT NULL,
  `fk_soc` int DEFAULT NULL,
  `fk_contact` int DEFAULT NULL,
  `fk_user` int DEFAULT NULL,
  `type` varchar(16) COLLATE utf8mb3_unicode_ci DEFAULT 'email',
  `type_target` varchar(16) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `objet_type` varchar(24) COLLATE utf8mb3_unicode_ci NOT NULL,
  `objet_id` int NOT NULL,
  `email` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_notify`
--


--
-- Table structure for table `t1zhf_notify_def`
--

CREATE TABLE `t1zhf_notify_def` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` date DEFAULT NULL,
  `fk_action` int NOT NULL,
  `fk_soc` int DEFAULT NULL,
  `fk_contact` int DEFAULT NULL,
  `fk_user` int DEFAULT NULL,
  `type` varchar(16) COLLATE utf8mb3_unicode_ci DEFAULT 'email',
  `email` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `threshold` double(24,8) DEFAULT NULL,
  `context` varchar(128) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_notify_def`
--


--
-- Table structure for table `t1zhf_notify_def_object`
--

CREATE TABLE `t1zhf_notify_def_object` (
  `id` int NOT NULL AUTO_INCREMENT,
  `entity` int NOT NULL DEFAULT '1',
  `objet_type` varchar(16) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `objet_id` int NOT NULL,
  `type_notif` varchar(16) COLLATE utf8mb3_unicode_ci DEFAULT 'browser',
  `date_notif` datetime DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `moreparam` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_notify_def_object`
--


--
-- Table structure for table `t1zhf_oauth_state`
--

CREATE TABLE `t1zhf_oauth_state` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `service` varchar(36) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `state` varchar(128) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fk_user` int DEFAULT NULL,
  `fk_adherent` int DEFAULT NULL,
  `entity` int DEFAULT '1',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_oauth_state`
--


--
-- Table structure for table `t1zhf_oauth_token`
--

CREATE TABLE `t1zhf_oauth_token` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `service` varchar(36) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `token` text COLLATE utf8mb3_unicode_ci,
  `fk_soc` int DEFAULT NULL,
  `tokenstring` text COLLATE utf8mb3_unicode_ci,
  `state` text COLLATE utf8mb3_unicode_ci,
  `fk_user` int DEFAULT NULL,
  `fk_adherent` int DEFAULT NULL,
  `entity` int DEFAULT '1',
  `restricted_ips` varchar(200) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_oauth_token`
--


--
-- Table structure for table `t1zhf_object_lang`
--

CREATE TABLE `t1zhf_object_lang` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_object` int NOT NULL DEFAULT '0',
  `type_object` varchar(32) COLLATE utf8mb3_unicode_ci NOT NULL,
  `property` varchar(32) COLLATE utf8mb3_unicode_ci NOT NULL,
  `lang` varchar(5) COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '0',
  `value` mediumtext COLLATE utf8mb3_unicode_ci,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_object_lang` (`fk_object`,`type_object`,`property`,`lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_object_lang`
--


--
-- Table structure for table `t1zhf_onlinesignature`
--

CREATE TABLE `t1zhf_onlinesignature` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `entity` int NOT NULL DEFAULT '1',
  `object_type` varchar(32) COLLATE utf8mb3_unicode_ci NOT NULL,
  `object_id` int NOT NULL,
  `datec` datetime NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `ip` varchar(128) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pathoffile` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_onlinesignature`
--


--
-- Table structure for table `t1zhf_opensurvey_comments`
--

CREATE TABLE `t1zhf_opensurvey_comments` (
  `id_comment` int unsigned NOT NULL AUTO_INCREMENT,
  `id_sondage` char(16) COLLATE utf8mb3_unicode_ci NOT NULL,
  `comment` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `usercomment` text COLLATE utf8mb3_unicode_ci,
  `ip` varchar(250) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `date_creation` datetime DEFAULT NULL,
  PRIMARY KEY (`id_comment`),
  KEY `idx_id_comment` (`id_comment`),
  KEY `idx_id_sondage` (`id_sondage`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_opensurvey_comments`
--


--
-- Table structure for table `t1zhf_opensurvey_formquestions`
--

CREATE TABLE `t1zhf_opensurvey_formquestions` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `id_sondage` varchar(16) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `question` text COLLATE utf8mb3_unicode_ci,
  `available_answers` text COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_opensurvey_formquestions`
--


--
-- Table structure for table `t1zhf_opensurvey_sondage`
--

CREATE TABLE `t1zhf_opensurvey_sondage` (
  `id_sondage` varchar(16) COLLATE utf8mb3_unicode_ci NOT NULL,
  `entity` int NOT NULL DEFAULT '1',
  `commentaires` text COLLATE utf8mb3_unicode_ci,
  `mail_admin` varchar(128) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `nom_admin` varchar(64) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fk_user_creat` int NOT NULL,
  `titre` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `date_fin` datetime DEFAULT NULL,
  `status` int DEFAULT '1',
  `format` varchar(2) COLLATE utf8mb3_unicode_ci NOT NULL,
  `mailsonde` tinyint NOT NULL DEFAULT '0',
  `allow_comments` tinyint NOT NULL DEFAULT '1',
  `allow_spy` tinyint NOT NULL DEFAULT '1',
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `sujet` text COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`id_sondage`),
  KEY `idx_date_fin` (`date_fin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_opensurvey_sondage`
--


--
-- Table structure for table `t1zhf_opensurvey_user_formanswers`
--

CREATE TABLE `t1zhf_opensurvey_user_formanswers` (
  `fk_user_survey` int NOT NULL,
  `fk_question` int NOT NULL,
  `reponses` text COLLATE utf8mb3_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_opensurvey_user_formanswers`
--


--
-- Table structure for table `t1zhf_opensurvey_user_studs`
--

CREATE TABLE `t1zhf_opensurvey_user_studs` (
  `id_users` int NOT NULL AUTO_INCREMENT,
  `nom` varchar(64) COLLATE utf8mb3_unicode_ci NOT NULL,
  `id_sondage` varchar(16) COLLATE utf8mb3_unicode_ci NOT NULL,
  `reponses` varchar(200) COLLATE utf8mb3_unicode_ci NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ip` varchar(250) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `date_creation` datetime DEFAULT NULL,
  PRIMARY KEY (`id_users`),
  KEY `idx_opensurvey_user_studs_id_users` (`id_users`),
  KEY `idx_opensurvey_user_studs_nom` (`nom`),
  KEY `idx_opensurvey_user_studs_id_sondage` (`id_sondage`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_opensurvey_user_studs`
--


--
-- Table structure for table `t1zhf_overwrite_trans`
--

CREATE TABLE `t1zhf_overwrite_trans` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `entity` int NOT NULL DEFAULT '1',
  `lang` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `transkey` varchar(128) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `transvalue` text COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_overwrite_trans` (`entity`,`lang`,`transkey`)
) ENGINE=InnoDB AUTO_INCREMENT=910 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_overwrite_trans`
--

INSERT INTO `t1zhf_overwrite_trans` VALUES (809,1,'fr_FR','Projects','Chantier/Affaire'),(810,1,'fr_FR','SearchIntoProjects','Chantiers/Affaires'),(811,1,'fr_FR','RefProject','Réf. chantier'),(812,1,'fr_FR','ProjectRef','Ref chantier'),(813,1,'fr_FR','ProjectId','Id chantier'),(814,1,'fr_FR','ProjectLabel','Libellé chantier'),(815,1,'fr_FR','ProjectsArea','Espace chantiers'),(816,1,'fr_FR','ProjectStatus','Statut chantier'),(817,1,'fr_FR','PrivateProject','Contacts chantier'),(818,1,'fr_FR','ProjectsImContactFor','Chantiers dont je suis un contact explicite'),(819,1,'fr_FR','AllAllowedProjects','Tout chantier que je peux lire (les miens + public)'),(820,1,'fr_FR','AllProjects','Tous les chantiers'),(821,1,'fr_FR','MyProjectsDesc','Cette vue est limitée aux chantiers dont vous êtres contact'),(822,1,'fr_FR','ProjectsPublicDesc','Cette vue présente tous les chantiers pour lesquels vous êtes habilité à avoir une visibilité.'),(823,1,'fr_FR','TasksOnProjectsPublicDesc','Cette vue affiche toutes les tâches de chantiers selon vos permissions utilisateur'),(824,1,'fr_FR','ProjectsPublicTaskDesc','Cette vue présente tous les chantiers et tâches pour lesquels vous êtes habilité à avoir une visibilité.'),(825,1,'fr_FR','ProjectsDesc','Cette vue présente tous les chantiers (vos habilitations vous offrant une vue exhaustive).'),(826,1,'fr_FR','TasksOnProjectsDesc','Cette vue présente toutes les tâches sur tous les chantiers (vos permissions d\'utilisateur vous accordent la permission de voir tout).'),(827,1,'fr_FR','MyTasksDesc','Cette vue est limitée au chantiers ou tâches dont vous êtes contact'),(828,1,'fr_FR','OnlyOpenedProject','Seuls les chantiers ouverts sont visibles (les chantiers à l\'état brouillon ou fermé ne sont pas visibles).'),(829,1,'fr_FR','ClosedProjectsAreHidden','Les chantiers fermés ne sont pas visible.'),(830,1,'fr_FR','TasksPublicDesc','Cette vue présente tous les chantiers et tâches pour lesquels vous êtes habilité à avoir une visibilité.'),(831,1,'fr_FR','TasksDesc','Cette vue présente tous les chantiers et tâches (vos habilitations vous offrant une vue exhaustive).'),(832,1,'fr_FR','AllTaskVisibleButEditIfYouAreAssigned','Toutes les tâches des chantiers sont visibles mais il n\'est possible de saisir du temps passé que sur celles assignées à l\'utilisateur sélectionné.\nAssignez la tâche si elle ne l\'est pas déjà pour pouvoir saisir du temps dessus.'),(833,1,'fr_FR','OnlyYourTaskAreVisible','Seules les tâches qui vous sont assignées sont visibles. Assignez vous une tâche pour la voir et saisir du temps passé'),(834,1,'fr_FR','ImportDatasetTasks','Tâches des chantiers'),(835,1,'fr_FR','ProjectCategories','Catégories/tags de chantier'),(836,1,'fr_FR','NewProject','Nouveau chantier'),(837,1,'fr_FR','AddProject','Créer chantier'),(838,1,'fr_FR','DeleteAProject','Supprimer un chantier'),(839,1,'fr_FR','ConfirmDeleteAProject','Êtes-vous sûr de vouloir supprimer ce chantier ?'),(840,1,'fr_FR','OpenedProjects','Chantiers ouverts'),(841,1,'fr_FR','OpportunitiesStatusForOpenedProjects','Montant des opportunités des chantiers ouverts par statut'),(842,1,'fr_FR','OpportunitiesStatusForProjects','Montant des opportunités des chantiers par statut'),(843,1,'fr_FR','ShowProject','Afficher chantier'),(844,1,'fr_FR','SetProject','Définir chantier'),(845,1,'fr_FR','NoProject','Aucun chantier défini ou responsable'),(846,1,'fr_FR','NbOfProjects','Nombre de chantiers'),(847,1,'fr_FR','TasksOnOpenedProject','Tâches sur les chantiers ouverts'),(848,1,'fr_FR','MyProjects','Mes chantiers'),(849,1,'fr_FR','MyProjectsArea','Espace Mes chantiers'),(850,1,'fr_FR','ListProposalsAssociatedProject','Liste des propositions commerciales associées au chantier'),(851,1,'fr_FR','ListOrdersAssociatedProject','Liste des commandes clients associées au chantier'),(852,1,'fr_FR','ListInvoicesAssociatedProject','Liste des factures clients associées au chantier'),(853,1,'fr_FR','ListPredefinedInvoicesAssociatedProject','Liste des modèles de facture client associées au chantier'),(854,1,'fr_FR','ListSupplierOrdersAssociatedProject','Liste des commandes fournisseurs associées au chantier'),(855,1,'fr_FR','ListSupplierInvoicesAssociatedProject','Liste des factures fournisseurs associées au chantier'),(856,1,'fr_FR','ListContractAssociatedProject','Liste des contrats associés au chantier'),(857,1,'fr_FR','ListShippingAssociatedProject','Liste des expéditions associées avec le chantier'),(858,1,'fr_FR','ListFichinterAssociatedProject','Liste des interventions associées au chantier'),(859,1,'fr_FR','ListExpenseReportsAssociatedProject','Liste des notes de frais associées avec ce chantier'),(860,1,'fr_FR','ListDonationsAssociatedProject','Liste des dons associés au chantier'),(861,1,'fr_FR','ListVariousPaymentsAssociatedProject','Liste des frais divers liés au chantier'),(862,1,'fr_FR','ListActionsAssociatedProject','Liste des événements associés au chantier'),(863,1,'fr_FR','ListTaskTimeUserProject','Liste du temps consommé sur les tâches d\'un chantier'),(864,1,'fr_FR','ActivityOnProjectToday','Activité chantier aujourd\'hui'),(865,1,'fr_FR','ActivityOnProjectYesterday','Activité chantier hier'),(866,1,'fr_FR','ActivityOnProjectThisWeek','Activité sur les chantiers cette semaine'),(867,1,'fr_FR','ActivityOnProjectThisMonth','Activité sur les chantiers ce mois'),(868,1,'fr_FR','ActivityOnProjectThisYear','Activité sur les chantiers cette année'),(869,1,'fr_FR','ChildOfProjectTask','Fille du chantier/tâche'),(870,1,'fr_FR','NotOwnerOfProject','Non responsable de ce chantier privé'),(871,1,'fr_FR','CantRemoveProject','Ce chantier ne peut être supprimé car il est référencé par de nombreux objets (factures, commandes ou autre). voir la liste sur l\'onglet Reférents.'),(872,1,'fr_FR','ValidateProject','Valider chantier'),(873,1,'fr_FR','ConfirmValidateProject','Êtes-vous sûr de vouloir valider ce chantier ?'),(874,1,'fr_FR','CloseAProject','Clore chantier'),(875,1,'fr_FR','ConfirmCloseAProject','Êtes-vous sûr de vouloir clore ce chantier ?'),(876,1,'fr_FR','AlsoCloseAProject','Fermer également le chantier (laissez-le ouvert si vous devez suivre la production de tâches dessus)'),(877,1,'fr_FR','ReOpenAProject','Réouvrir chantier'),(878,1,'fr_FR','ConfirmReOpenAProject','Êtes-vous sûr de vouloir rouvrir ce chantier ?'),(879,1,'fr_FR','ProjectContact','Contacts chantier'),(880,1,'fr_FR','ActionsOnProject','Événements sur le chantier'),(881,1,'fr_FR','YouAreNotContactOfProject','Vous n\'êtes pas contact de ce chantier privé'),(882,1,'fr_FR','UserIsNotContactOfProject','L\'utilisateur n\'est pas un contact/adresse de ce chantier privé'),(883,1,'fr_FR','ProjectsDedicatedToThisThirdParty','Chantiers dédiés à ce tiers'),(884,1,'fr_FR','NoTasks','Aucune tâche pour ce chantier'),(885,1,'fr_FR','ThisWillAlsoRemoveTasks','Cette opération détruira également les tâches du chantier (<b>%s</b> tâches actuellement) et le suivi des consommés.'),(886,1,'fr_FR','IfNeedToUseOhterObjectKeepEmpty','Si des objets (facture, commande, ...), appartenant à un autre tiers que celui choisi, doivent être liés au chantier à créer, laisser vide afin de laisser le chantier multi-tiers.'),(887,1,'fr_FR','CloneProject','Cloner le chantier'),(888,1,'fr_FR','CloneProjectFiles','Cloner les pièces jointes du chantier'),(889,1,'fr_FR','CloneMoveDate','Mettre à jour les dates chantier/tâches à partir de maintenant'),(890,1,'fr_FR','ConfirmCloneProject','Êtes-vous sûr de vouloir cloner ce chantier ?'),(891,1,'fr_FR','ProjectsAndTasksLines','Chantiers et tâches'),(892,1,'fr_FR','ProjectCreatedInDolibarr','Chantier %s créé'),(893,1,'fr_FR','ProjectModifiedInDolibarr','Chantier %s modifié'),(894,1,'fr_FR','TypeContact_project_internal_PROJECTLEADER','Chef de chantier'),(895,1,'fr_FR','TypeContact_project_external_PROJECTLEADER','Chef de chantier'),(896,1,'fr_FR','DocumentModelBeluga','Modèle de document de rapport pour l\'aperçu chantier'),(897,1,'fr_FR','DocumentModelBaleine','Modèles de document de rapport de tâches de chantiers'),(898,1,'fr_FR','ProjectMustBeValidatedFirst','Le chantier doit être validé d\'abord'),(899,1,'fr_FR','ProjectsWithThisUserAsContact','Chantiers avec cet utilisateur comme contact'),(900,1,'fr_FR','ResourceNotAssignedToProject','Non assigné au chantier'),(901,1,'fr_FR','ManageTasks','Utiliser les chantiers pour suivre les tâches'),(902,1,'fr_FR','ManageOpportunitiesStatus','Utiliser les chantiers pour suivre les affaires / opportunités'),(903,1,'fr_FR','ProjectNbProjectByMonth','Nb de chantiers créés par mois'),(904,1,'fr_FR','ProjectsStatistics','Statistics sur les chantiers'),(905,1,'fr_FR','TasksStatistics','Statistiques sur le chantier/tâche principale'),(906,1,'fr_FR','OpenedProjectsByThirdparties','Chantiers ouverts par tiers'),(907,1,'fr_FR','LatestProjects','Les %s derniers chantiers'),(908,1,'fr_FR','LatestModifiedProjects','Les %s derniers chantiers modifiés'),(909,1,'fr_FR','AllowCommentOnProject','Autoriser les commentaires utilisateur sur les chantiers');

--
-- Table structure for table `t1zhf_paiement`
--

CREATE TABLE `t1zhf_paiement` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) COLLATE utf8mb3_unicode_ci NOT NULL,
  `ref_ext` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `entity` int NOT NULL DEFAULT '1',
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datep` datetime DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  `multicurrency_amount` double(24,8) DEFAULT '0.00000000',
  `fk_paiement` int NOT NULL,
  `num_paiement` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8mb3_unicode_ci,
  `fk_bank` int NOT NULL DEFAULT '0',
  `fk_user_creat` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `statut` smallint NOT NULL DEFAULT '0',
  `fk_export_compta` int NOT NULL DEFAULT '0',
  `pos_change` double(24,8) DEFAULT '0.00000000',
  `ext_payment_id` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `ext_payment_site` varchar(128) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_paiement`
--

INSERT INTO `t1zhf_paiement` VALUES (1,'PAY1901-0001',NULL,1,'2019-01-08 11:38:04','2019-01-08 10:38:04','2019-01-08 12:00:00',168.00000000,168.00000000,2,'','',2,1,NULL,0,0,0.00000000,NULL,NULL),(2,'PAY1903-0002',NULL,1,'2019-03-05 16:58:28','2019-03-05 15:58:30','2019-03-01 12:00:00',7675.28000000,7675.28000000,7,'14785','',3,1,NULL,0,0,0.00000000,NULL,NULL),(3,'PAY1912-0003',NULL,1,'2019-12-09 11:26:45','2019-12-09 10:26:45','2019-12-09 12:00:00',468.00000000,468.00000000,2,'','',4,1,NULL,0,0,0.00000000,NULL,NULL),(4,'PAY2001-0004',NULL,1,'2020-01-14 15:25:05','2020-01-14 14:25:05','2020-01-14 12:00:00',1500.00000000,1500.00000000,2,'123','',5,1,NULL,0,0,0.00000000,NULL,NULL),(5,'PAY2006-0005',NULL,1,'2020-06-22 15:25:38','2020-06-22 13:25:39','2020-06-22 12:00:00',20.00000000,20.00000000,2,'','',7,1,NULL,0,0,0.00000000,NULL,NULL),(6,'PAY2102-0006',NULL,1,'2021-02-11 15:04:19','2021-02-11 14:04:19','2021-02-11 12:00:00',384.00000000,384.00000000,7,'dfgsdfgsdf','',8,1,NULL,0,0,0.00000000,NULL,NULL),(7,'PAY2103-0007',NULL,1,'2021-03-24 12:00:48','2021-03-24 11:00:50','2021-03-24 12:00:00',17467.09000000,17467.09000000,2,'123456','',11,1,NULL,0,0,0.00000000,NULL,NULL),(8,'PAY2105-0008','',1,'2021-05-25 18:42:48','2021-05-25 16:42:50','2021-05-25 12:00:00',40887.07000000,40887.07000000,2,'','',13,1,NULL,0,0,0.00000000,NULL,NULL),(9,'PAY2105-0009','',1,'2021-05-25 18:43:39','2021-05-25 16:43:40','2021-05-25 12:00:00',28515.00000000,28515.00000000,6,'','',14,1,NULL,0,0,0.00000000,NULL,NULL),(10,'PAY2105-0010','',1,'2021-05-25 18:44:33','2021-05-25 16:44:33','2021-05-25 12:00:00',1250.80000000,1250.80000000,2,'','',15,1,NULL,0,0,0.00000000,NULL,NULL),(11,'PAY2105-0011','',1,'2021-05-25 18:44:57','2021-05-25 16:44:57','2021-05-25 12:00:00',8880.00000000,8880.00000000,2,'','',16,1,NULL,0,0,0.00000000,NULL,NULL),(12,'PAY2105-0012','',1,'2021-05-25 18:45:33','2021-05-25 16:45:33','2021-05-25 12:00:00',10.00000000,10.00000000,6,'','',17,1,NULL,0,0,0.00000000,NULL,NULL),(13,'PAY2110-0013','',1,'2021-10-19 16:01:30','2021-10-19 14:01:30','2021-10-19 12:00:00',16706.06000000,16706.06000000,2,'','',18,1,NULL,0,0,0.00000000,NULL,NULL),(14,'PAY2202-0014','',1,'2022-02-18 16:28:38','2022-02-18 15:28:38','2022-02-18 12:00:00',225.60000000,225.60000000,2,'','',19,1,NULL,0,0,0.00000000,NULL,NULL),(15,'PAY2304-0015','',1,'2023-04-25 11:45:01','2023-04-25 09:45:01','2023-04-25 12:00:00',422.00000000,422.00000000,2,'','',20,1,NULL,0,0,0.00000000,NULL,NULL),(16,'PAY2306-0016','',1,'2023-06-28 11:11:41','2023-06-28 09:11:41','2023-06-28 12:00:00',1200.00000000,1200.00000000,2,'','',21,1,NULL,0,0,0.00000000,NULL,NULL),(18,'PAY2306-0017','',1,'2023-06-28 11:42:08','2023-06-28 09:42:08','2023-06-28 12:00:00',1.50000000,1.50000000,7,'','',23,1,NULL,0,0,0.00000000,NULL,NULL),(19,'PAY2309-0018','',1,'2023-09-14 16:52:54','2023-09-14 14:52:55','2023-09-14 16:52:54',36.00000000,36.00000000,6,'','',24,1,NULL,0,0,0.00000000,NULL,NULL),(20,'PAY2309-0019','',1,'2023-09-14 17:02:34','2023-09-14 15:02:34','2023-09-14 17:02:34',158.40000000,158.40000000,7,'TC1-2309-0001','',25,1,NULL,0,0,0.00000000,NULL,NULL),(21,'PAY2409-0020','',1,'2024-09-09 15:59:19','2024-09-09 13:59:19','2024-09-09 12:00:00',5000.00000000,5000.00000000,2,'','',27,1,NULL,0,0,0.00000000,NULL,NULL);

--
-- Table structure for table `t1zhf_paiement_facture`
--

CREATE TABLE `t1zhf_paiement_facture` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_paiement` int DEFAULT NULL,
  `fk_facture` int DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  `multicurrency_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT '1.00000000',
  `multicurrency_amount` double(24,8) DEFAULT '0.00000000',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_paiement_facture` (`fk_paiement`,`fk_facture`),
  KEY `idx_paiement_facture_fk_facture` (`fk_facture`),
  KEY `idx_paiement_facture_fk_paiement` (`fk_paiement`),
  CONSTRAINT `fk_paiement_facture_fk_facture` FOREIGN KEY (`fk_facture`) REFERENCES `t1zhf_facture` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_paiement_facture_fk_paiement` FOREIGN KEY (`fk_paiement`) REFERENCES `t1zhf_paiement` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_paiement_facture`
--

INSERT INTO `t1zhf_paiement_facture` VALUES (1,1,1,168.00000000,NULL,1.00000000,168.00000000),(2,2,2,84.00000000,NULL,1.00000000,84.00000000),(3,2,4,84.00000000,NULL,1.00000000,84.00000000),(4,2,6,50.00000000,NULL,1.00000000,50.00000000),(5,2,7,307.20000000,NULL,1.00000000,307.20000000),(6,2,18,500.00000000,NULL,1.00000000,500.00000000),(7,2,26,6650.08000000,NULL,1.00000000,6650.08000000),(8,3,38,102.00000000,NULL,1.00000000,102.00000000),(9,3,39,366.00000000,NULL,1.00000000,366.00000000),(10,4,40,1500.00000000,NULL,1.00000000,1500.00000000),(11,5,41,20.00000000,NULL,1.00000000,20.00000000),(12,6,43,384.00000000,NULL,1.00000000,384.00000000),(13,7,6,26.80000000,NULL,1.00000000,26.80000000),(14,7,8,384.00000000,NULL,1.00000000,384.00000000),(15,7,18,169.37000000,NULL,1.00000000,169.37000000),(16,7,19,2000.00000000,NULL,1.00000000,2000.00000000),(17,7,29,9746.11000000,NULL,1.00000000,9746.11000000),(18,7,20,4016.26000000,NULL,1.00000000,4016.26000000),(19,7,30,1124.55000000,NULL,1.00000000,1124.55000000),(20,8,19,2685.63000000,NULL,1.00000000,2685.63000000),(21,8,21,374.85000000,NULL,1.00000000,374.85000000),(22,8,22,1499.40000000,NULL,1.00000000,1499.40000000),(23,8,32,30792.04000000,NULL,1.00000000,30792.04000000),(24,8,23,1874.25000000,NULL,1.00000000,1874.25000000),(25,8,24,268.50000000,NULL,1.00000000,268.50000000),(26,8,40,300.00000000,NULL,1.00000000,300.00000000),(27,8,42,480.00000000,NULL,1.00000000,480.00000000),(28,8,44,2400.00000000,NULL,1.00000000,2400.00000000),(29,8,45,212.40000000,NULL,1.00000000,212.40000000),(30,9,11,600.00000000,NULL,1.00000000,600.00000000),(31,9,12,960.00000000,NULL,1.00000000,960.00000000),(32,9,13,2340.00000000,NULL,1.00000000,2340.00000000),(33,9,14,3900.00000000,NULL,1.00000000,3900.00000000),(34,9,15,9660.00000000,NULL,1.00000000,9660.00000000),(35,9,35,11055.00000000,NULL,1.00000000,11055.00000000),(36,10,41,1250.80000000,NULL,1.00000000,1250.80000000),(37,11,46,888.00000000,NULL,1.00000000,888.00000000),(38,11,47,3552.00000000,NULL,1.00000000,3552.00000000),(39,11,48,4440.00000000,NULL,1.00000000,4440.00000000),(40,12,34,10.00000000,NULL,1.00000000,10.00000000),(41,13,52,1347.86000000,NULL,1.00000000,1347.86000000),(42,13,53,4284.00000000,NULL,1.00000000,4284.00000000),(43,13,54,5000.00000000,NULL,1.00000000,5000.00000000),(44,13,55,6074.20000000,NULL,1.00000000,6074.20000000),(45,14,57,225.60000000,NULL,1.00000000,225.60000000),(46,15,34,-10.00000000,NULL,1.00000000,-10.00000000),(47,15,56,432.00000000,NULL,1.00000000,432.00000000),(48,16,62,1200.00000000,NULL,1.00000000,1200.00000000),(50,18,63,1.50000000,NULL,1.00000000,1.50000000),(51,19,64,36.00000000,NULL,1.00000000,36.00000000),(52,20,65,158.40000000,NULL,1.00000000,158.40000000),(53,21,66,5000.00000000,'EUR',1.00000000,5000.00000000);

--
-- Table structure for table `t1zhf_paiementcharge`
--

CREATE TABLE `t1zhf_paiementcharge` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_charge` int DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datep` datetime DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  `fk_typepaiement` int NOT NULL,
  `num_paiement` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8mb3_unicode_ci,
  `fk_bank` int NOT NULL,
  `fk_user_creat` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_paiementcharge_fk_charge` (`fk_charge`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_paiementcharge`
--


--
-- Table structure for table `t1zhf_paiementfourn`
--

CREATE TABLE `t1zhf_paiementfourn` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `entity` int DEFAULT '1',
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `datep` datetime DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  `multicurrency_amount` double(24,8) DEFAULT '0.00000000',
  `fk_user_author` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `fk_paiement` int NOT NULL,
  `num_paiement` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8mb3_unicode_ci,
  `fk_bank` int NOT NULL,
  `statut` smallint NOT NULL DEFAULT '0',
  `model_pdf` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_paiementfourn`
--

INSERT INTO `t1zhf_paiementfourn` VALUES (1,'SPAY2102-0001',1,'2021-02-11 14:24:56','2021-02-11 15:24:56','2021-02-11 12:00:00',60.00000000,60.00000000,1,NULL,4,'','',9,0,NULL),(2,'SPAY2103-0002',1,'2021-03-08 16:34:34','2021-03-08 17:34:34','2021-03-08 12:00:00',600.00000000,600.00000000,1,NULL,2,'','',10,0,NULL),(3,'SPAY2105-0003',1,'2021-05-25 14:35:00','2021-05-25 16:35:00','2021-05-25 12:00:00',20.44000000,20.44000000,1,NULL,2,'','',12,0,NULL);

--
-- Table structure for table `t1zhf_paiementfourn_facturefourn`
--

CREATE TABLE `t1zhf_paiementfourn_facturefourn` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_paiementfourn` int DEFAULT NULL,
  `fk_facturefourn` int DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  `multicurrency_code` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT '1.00000000',
  `multicurrency_amount` double(24,8) DEFAULT '0.00000000',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_paiementfourn_facturefourn` (`fk_paiementfourn`,`fk_facturefourn`),
  KEY `idx_paiementfourn_facturefourn_fk_facture` (`fk_facturefourn`),
  KEY `idx_paiementfourn_facturefourn_fk_paiement` (`fk_paiementfourn`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_paiementfourn_facturefourn`
--

INSERT INTO `t1zhf_paiementfourn_facturefourn` VALUES (1,1,4,60.00000000,NULL,1.00000000,60.00000000),(2,2,5,600.00000000,NULL,1.00000000,600.00000000),(3,3,6,20.44000000,NULL,1.00000000,20.44000000);

--
-- Table structure for table `t1zhf_partnership`
--

CREATE TABLE `t1zhf_partnership` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `ref` varchar(128) NOT NULL DEFAULT '(PROV)',
  `status` smallint NOT NULL DEFAULT '0',
  `fk_soc` int DEFAULT NULL,
  `fk_member` int DEFAULT NULL,
  `email_partnership` varchar(64) DEFAULT NULL,
  `date_partnership_start` date NOT NULL,
  `date_partnership_end` date DEFAULT NULL,
  `entity` int NOT NULL DEFAULT '1',
  `reason_decline_or_cancel` text,
  `date_creation` datetime NOT NULL,
  `fk_user_creat` int DEFAULT NULL,
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_user_modif` int DEFAULT NULL,
  `note_private` text,
  `note_public` text,
  `last_main_doc` varchar(255) DEFAULT NULL,
  `count_last_url_check_error` int DEFAULT '0',
  `last_check_backlink` datetime DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `model_pdf` varchar(255) DEFAULT NULL,
  `fk_type` int NOT NULL DEFAULT '0',
  `url_to_check` varchar(255) DEFAULT NULL,
  `ip` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_partnership_ref` (`ref`,`entity`),
  UNIQUE KEY `uk_fk_type_fk_soc` (`fk_type`,`fk_soc`,`date_partnership_start`),
  UNIQUE KEY `uk_fk_type_fk_member` (`fk_type`,`fk_member`,`date_partnership_start`),
  KEY `idx_partnership_rowid` (`rowid`),
  KEY `idx_partnership_ref` (`ref`),
  KEY `idx_partnership_fk_soc` (`fk_soc`),
  KEY `t1zhf_partnership_fk_user_creat` (`fk_user_creat`),
  KEY `idx_partnership_status` (`status`),
  KEY `idx_partnership_fk_member` (`fk_member`),
  KEY `idx_partnership_entity` (`entity`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1zhf_partnership`
--

INSERT INTO `t1zhf_partnership` VALUES (1,'(PROV1)',0,5,NULL,NULL,'2023-06-01','2023-06-30',1,NULL,'2023-06-01 19:08:04',1,'2023-06-01 17:08:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'',NULL);

--
-- Table structure for table `t1zhf_partnership_extrafields`
--

CREATE TABLE `t1zhf_partnership_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int NOT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_partnership_extrafields` (`fk_object`),
  KEY `idx_partnership_fk_object` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1zhf_partnership_extrafields`
--


--
-- Table structure for table `t1zhf_payment_donation`
--

CREATE TABLE `t1zhf_payment_donation` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_donation` int DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datep` datetime DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  `fk_typepayment` int NOT NULL,
  `num_payment` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8mb3_unicode_ci,
  `ext_payment_id` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `ext_payment_site` varchar(128) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fk_bank` int NOT NULL,
  `fk_user_creat` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_payment_donation`
--


--
-- Table structure for table `t1zhf_payment_expensereport`
--

CREATE TABLE `t1zhf_payment_expensereport` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_expensereport` int DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datep` datetime DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  `fk_typepayment` int NOT NULL,
  `num_payment` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8mb3_unicode_ci,
  `fk_bank` int NOT NULL,
  `fk_user_creat` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_payment_expensereport`
--


--
-- Table structure for table `t1zhf_payment_loan`
--

CREATE TABLE `t1zhf_payment_loan` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_loan` int DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datep` datetime DEFAULT NULL,
  `amount_capital` double(24,8) DEFAULT '0.00000000',
  `amount_insurance` double(24,8) DEFAULT '0.00000000',
  `amount_interest` double(24,8) DEFAULT '0.00000000',
  `fk_typepayment` int NOT NULL,
  `num_payment` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `note_private` text COLLATE utf8mb3_unicode_ci,
  `note_public` text COLLATE utf8mb3_unicode_ci,
  `fk_bank` int NOT NULL,
  `fk_user_creat` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_payment_loan`
--


--
-- Table structure for table `t1zhf_payment_salary`
--

CREATE TABLE `t1zhf_payment_salary` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `fk_user` int DEFAULT NULL,
  `datep` datetime DEFAULT NULL,
  `datev` date DEFAULT NULL,
  `salary` double(24,8) DEFAULT NULL,
  `amount` double(24,8) NOT NULL DEFAULT '0.00000000',
  `fk_projet` int DEFAULT NULL,
  `fk_typepayment` int NOT NULL,
  `num_payment` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `label` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `datesp` date DEFAULT NULL,
  `dateep` date DEFAULT NULL,
  `entity` int NOT NULL DEFAULT '1',
  `note` text COLLATE utf8mb3_unicode_ci,
  `fk_bank` int DEFAULT NULL,
  `fk_user_author` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `fk_salary` int DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_payment_salary_ref` (`num_payment`),
  KEY `idx_payment_salary_user` (`fk_user`,`entity`),
  KEY `idx_payment_salary_datep` (`datep`),
  KEY `idx_payment_salary_datesp` (`datesp`),
  KEY `idx_payment_salary_dateep` (`dateep`),
  CONSTRAINT `fk_payment_salary_user` FOREIGN KEY (`fk_user`) REFERENCES `t1zhf_user` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_payment_salary`
--


--
-- Table structure for table `t1zhf_payment_various`
--

CREATE TABLE `t1zhf_payment_various` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `num_payment` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `label` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `datep` date DEFAULT NULL,
  `datev` date DEFAULT NULL,
  `sens` smallint NOT NULL DEFAULT '0',
  `amount` double(24,8) NOT NULL DEFAULT '0.00000000',
  `fk_typepayment` int NOT NULL,
  `accountancy_code` varchar(32) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fk_projet` int DEFAULT NULL,
  `entity` int NOT NULL DEFAULT '1',
  `note` text COLLATE utf8mb3_unicode_ci,
  `fk_bank` int DEFAULT NULL,
  `fk_user_author` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `subledger_account` varchar(32) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_payment_various`
--


--
-- Table structure for table `t1zhf_payment_vat`
--

CREATE TABLE `t1zhf_payment_vat` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_tva` int DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datep` datetime DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  `fk_typepaiement` int NOT NULL,
  `num_paiement` varchar(50) DEFAULT NULL,
  `note` text,
  `fk_bank` int NOT NULL,
  `fk_user_creat` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1zhf_payment_vat`
--


--
-- Table structure for table `t1zhf_pos_cash_fence`
--

CREATE TABLE `t1zhf_pos_cash_fence` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `entity` int NOT NULL DEFAULT '1',
  `ref` varchar(64) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `label` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `opening` double(24,8) DEFAULT '0.00000000',
  `cash` double(24,8) DEFAULT '0.00000000',
  `card` double(24,8) DEFAULT '0.00000000',
  `cheque` double(24,8) DEFAULT '0.00000000',
  `status` int DEFAULT NULL,
  `date_creation` datetime NOT NULL,
  `date_valid` datetime DEFAULT NULL,
  `day_close` int DEFAULT NULL,
  `month_close` int DEFAULT NULL,
  `year_close` int DEFAULT NULL,
  `posmodule` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `posnumber` varchar(30) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fk_user_creat` int DEFAULT NULL,
  `fk_user_valid` int DEFAULT NULL,
  `tms` timestamp NOT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_pos_cash_fence`
--


--
-- Table structure for table `t1zhf_prelevement`
--

CREATE TABLE `t1zhf_prelevement` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_facture` int DEFAULT NULL,
  `fk_prelevement_lignes` int NOT NULL,
  `fk_facture_fourn` int DEFAULT NULL,
  `fk_salary` int DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_prelevement_facture_fk_prelevement_lignes` (`fk_prelevement_lignes`),
  CONSTRAINT `fk_prelevement_facture_fk_prelevement_lignes` FOREIGN KEY (`fk_prelevement_lignes`) REFERENCES `t1zhf_prelevement_lignes` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_prelevement`
--


--
-- Table structure for table `t1zhf_prelevement_bons`
--

CREATE TABLE `t1zhf_prelevement_bons` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `ref` varchar(12) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `entity` int NOT NULL DEFAULT '1',
  `datec` datetime DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  `statut` smallint DEFAULT '0',
  `credite` smallint DEFAULT '0',
  `note` text COLLATE utf8mb3_unicode_ci,
  `date_trans` datetime DEFAULT NULL,
  `method_trans` smallint DEFAULT NULL,
  `fk_user_trans` int DEFAULT NULL,
  `date_credit` datetime DEFAULT NULL,
  `fk_user_credit` int DEFAULT NULL,
  `type` varchar(16) COLLATE utf8mb3_unicode_ci DEFAULT 'debit-order',
  `fk_bank_account` int DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_prelevement_bons_ref` (`ref`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_prelevement_bons`
--


--
-- Table structure for table `t1zhf_prelevement_demande`
--

CREATE TABLE `t1zhf_prelevement_demande` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_facture` int DEFAULT NULL,
  `amount` double(24,8) NOT NULL,
  `date_demande` datetime NOT NULL,
  `traite` smallint DEFAULT '0',
  `date_traite` datetime DEFAULT NULL,
  `fk_prelevement_bons` int DEFAULT NULL,
  `fk_user_demande` int NOT NULL,
  `code_banque` varchar(128) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `code_guichet` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `number` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cle_rib` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `entity` int DEFAULT NULL,
  `sourcetype` varchar(32) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `ext_payment_id` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `ext_payment_site` varchar(128) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fk_facture_fourn` int DEFAULT NULL,
  `fk_salary` int DEFAULT NULL,
  `type` varchar(12) COLLATE utf8mb3_unicode_ci DEFAULT '',
  PRIMARY KEY (`rowid`),
  KEY `idx_prelevement_facture_demande_fk_facture` (`fk_facture`),
  KEY `idx_prelevement_facture_demande_fk_facture_fourn` (`fk_facture_fourn`),
  KEY `idx_prelevement_demande_ext_payment_id` (`ext_payment_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_prelevement_demande`
--

INSERT INTO `t1zhf_prelevement_demande` VALUES (1,NULL,60.00000000,'2023-06-01 19:27:45',0,NULL,NULL,1,'','','','',1,'supplier_invoice',NULL,NULL,10,NULL,'ban');

--
-- Table structure for table `t1zhf_prelevement_lignes`
--

CREATE TABLE `t1zhf_prelevement_lignes` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_prelevement_bons` int DEFAULT NULL,
  `fk_soc` int NOT NULL,
  `statut` smallint DEFAULT '0',
  `client_nom` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  `code_banque` varchar(128) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `code_guichet` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `number` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cle_rib` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8mb3_unicode_ci,
  `fk_user` int DEFAULT NULL,
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`rowid`),
  KEY `idx_prelevement_lignes_fk_prelevement_bons` (`fk_prelevement_bons`),
  CONSTRAINT `fk_prelevement_lignes_fk_prelevement_bons` FOREIGN KEY (`fk_prelevement_bons`) REFERENCES `t1zhf_prelevement_bons` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_prelevement_lignes`
--


--
-- Table structure for table `t1zhf_prelevement_rejet`
--

CREATE TABLE `t1zhf_prelevement_rejet` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_prelevement_lignes` int DEFAULT NULL,
  `date_rejet` datetime DEFAULT NULL,
  `motif` int DEFAULT NULL,
  `date_creation` datetime DEFAULT NULL,
  `fk_user_creation` int DEFAULT NULL,
  `note` text COLLATE utf8mb3_unicode_ci,
  `afacturer` tinyint DEFAULT '0',
  `fk_facture` int DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_prelevement_rejet`
--


--
-- Table structure for table `t1zhf_printing`
--

CREATE TABLE `t1zhf_printing` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `printer_name` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `printer_location` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `printer_id` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `copy` int NOT NULL DEFAULT '1',
  `module` varchar(16) COLLATE utf8mb3_unicode_ci NOT NULL,
  `driver` varchar(16) COLLATE utf8mb3_unicode_ci NOT NULL,
  `userid` int DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_printing`
--


--
-- Table structure for table `t1zhf_process`
--

CREATE TABLE `t1zhf_process` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_element` int DEFAULT '0',
  `element` text COLLATE utf8mb3_unicode_ci,
  `color` text COLLATE utf8mb3_unicode_ci,
  `progress` int DEFAULT '0',
  `step` int DEFAULT NULL,
  `display` text COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_process`
--

INSERT INTO `t1zhf_process` VALUES (1,13,'propal','1',0,NULL,NULL),(2,31,'facture','2',0,NULL,NULL),(3,33,'facture',NULL,0,NULL,NULL);

--
-- Table structure for table `t1zhf_process_commande_extrafields`
--

CREATE TABLE `t1zhf_process_commande_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int NOT NULL,
  `process_color` text COLLATE utf8mb3_unicode_ci,
  `process_progress` int DEFAULT '0',
  `process_step` int DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_process_commande_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_process_commande_extrafields`
--


--
-- Table structure for table `t1zhf_process_commande_fourn_extrafields`
--

CREATE TABLE `t1zhf_process_commande_fourn_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int NOT NULL,
  `process_color` text COLLATE utf8mb3_unicode_ci,
  `process_progress` int DEFAULT '0',
  `process_step` int DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_process_commande_fourn_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_process_commande_fourn_extrafields`
--


--
-- Table structure for table `t1zhf_process_contrat_extrafields`
--

CREATE TABLE `t1zhf_process_contrat_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int NOT NULL,
  `process_color` text COLLATE utf8mb3_unicode_ci,
  `process_progress` int DEFAULT '0',
  `process_step` int DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_process_contrat_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_process_contrat_extrafields`
--


--
-- Table structure for table `t1zhf_process_element`
--

CREATE TABLE `t1zhf_process_element` (
  `element` text COLLATE utf8mb3_unicode_ci,
  `tablename` text COLLATE utf8mb3_unicode_ci,
  `mainmenu` text COLLATE utf8mb3_unicode_ci,
  `leftmenu` text COLLATE utf8mb3_unicode_ci,
  `langfile` text COLLATE utf8mb3_unicode_ci,
  `class` text COLLATE utf8mb3_unicode_ci,
  `querysql` text COLLATE utf8mb3_unicode_ci,
  `enabled` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_process_element`
--

INSERT INTO `t1zhf_process_element` VALUES ('propal','propale','commercial','propals',NULL,'comm/propal/class/propal.class.php',NULL,NULL),('commande','commande','commercial','orders',NULL,'commande/class/commande.class.php',NULL,NULL),('facture','facture','accountancy','customers_bills',NULL,'compta/facture/class/facture.class.php',NULL,NULL),('commande_fourn','commande_fournisseur','commercial','suppliers_orders',NULL,'fourn/class/fournisseur.commande.class.php',NULL,NULL),('facture_fourn','facture_fourn','accountancy','suppliers_bills',NULL,'fourn/class/fournisseur.facture.class.php',NULL,NULL),('propal','propale','commercial','propals',NULL,'comm/propal/class/propal.class.php',NULL,NULL),('commande','commande','commercial','orders',NULL,'commande/class/commande.class.php',NULL,NULL),('facture','facture','accountancy','customers_bills',NULL,'compta/facture/class/facture.class.php',NULL,NULL),('commande_fourn','commande_fournisseur','commercial','suppliers_orders',NULL,'fourn/class/fournisseur.commande.class.php',NULL,NULL),('facture_fourn','facture_fourn','accountancy','suppliers_bills',NULL,'fourn/class/fournisseur.facture.class.php',NULL,NULL),('propal','propale','commercial','propals',NULL,'comm/propal/class/propal.class.php',NULL,NULL),('commande','commande','commercial','orders',NULL,'commande/class/commande.class.php',NULL,NULL),('facture','facture','accountancy','customers_bills',NULL,'compta/facture/class/facture.class.php',NULL,NULL),('commande_fourn','commande_fournisseur','commercial','suppliers_orders',NULL,'fourn/class/fournisseur.commande.class.php',NULL,NULL),('facture_fourn','facture_fourn','accountancy','suppliers_bills',NULL,'fourn/class/fournisseur.facture.class.php',NULL,NULL),('propal','propale','commercial','propals',NULL,'comm/propal/class/propal.class.php',NULL,NULL),('commande','commande','commercial','orders',NULL,'commande/class/commande.class.php',NULL,NULL),('facture','facture','accountancy','customers_bills',NULL,'compta/facture/class/facture.class.php',NULL,NULL),('commande_fourn','commande_fournisseur','commercial','suppliers_orders',NULL,'fourn/class/fournisseur.commande.class.php',NULL,NULL),('facture_fourn','facture_fourn','accountancy','suppliers_bills',NULL,'fourn/class/fournisseur.facture.class.php',NULL,NULL),('propal','propale','commercial','propals',NULL,'comm/propal/class/propal.class.php',NULL,NULL),('commande','commande','commercial','orders',NULL,'commande/class/commande.class.php',NULL,NULL),('facture','facture','accountancy','customers_bills',NULL,'compta/facture/class/facture.class.php',NULL,NULL),('commande_fourn','commande_fournisseur','commercial','suppliers_orders',NULL,'fourn/class/fournisseur.commande.class.php',NULL,NULL),('facture_fourn','facture_fourn','accountancy','suppliers_bills',NULL,'fourn/class/fournisseur.facture.class.php',NULL,NULL);

--
-- Table structure for table `t1zhf_process_equipementevt_extrafields`
--

CREATE TABLE `t1zhf_process_equipementevt_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int NOT NULL,
  `process_color` text COLLATE utf8mb3_unicode_ci,
  `process_progress` int DEFAULT '0',
  `process_step` int DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_process_equipementevt_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_process_equipementevt_extrafields`
--


--
-- Table structure for table `t1zhf_process_factory_extrafields`
--

CREATE TABLE `t1zhf_process_factory_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int NOT NULL,
  `process_color` text COLLATE utf8mb3_unicode_ci,
  `process_progress` int DEFAULT '0',
  `process_step` int DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_process_factory_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_process_factory_extrafields`
--


--
-- Table structure for table `t1zhf_process_facture_extrafields`
--

CREATE TABLE `t1zhf_process_facture_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int NOT NULL,
  `process_color` text COLLATE utf8mb3_unicode_ci,
  `process_progress` int DEFAULT '0',
  `process_step` int DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_process_facture_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_process_facture_extrafields`
--


--
-- Table structure for table `t1zhf_process_facture_fourn_extrafields`
--

CREATE TABLE `t1zhf_process_facture_fourn_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int NOT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_process_facture_fourn_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_process_facture_fourn_extrafields`
--


--
-- Table structure for table `t1zhf_process_fichinter_extrafields`
--

CREATE TABLE `t1zhf_process_fichinter_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int NOT NULL,
  `process_color` text COLLATE utf8mb3_unicode_ci,
  `process_progress` int DEFAULT '0',
  `process_step` int DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_process_fichinter_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_process_fichinter_extrafields`
--


--
-- Table structure for table `t1zhf_process_lead_extrafields`
--

CREATE TABLE `t1zhf_process_lead_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int NOT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_process_lead_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_process_lead_extrafields`
--


--
-- Table structure for table `t1zhf_process_localisemove_extrafields`
--

CREATE TABLE `t1zhf_process_localisemove_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int NOT NULL,
  `process_color` text COLLATE utf8mb3_unicode_ci,
  `process_progress` int DEFAULT '0',
  `process_step` int DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_process_localisemove_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_process_localisemove_extrafields`
--


--
-- Table structure for table `t1zhf_process_propal_extrafields`
--

CREATE TABLE `t1zhf_process_propal_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int NOT NULL,
  `process_color` text COLLATE utf8mb3_unicode_ci,
  `process_progress` int DEFAULT '0',
  `process_step` int DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_process_propal_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_process_propal_extrafields`
--


--
-- Table structure for table `t1zhf_process_propal_fourn_extrafields`
--

CREATE TABLE `t1zhf_process_propal_fourn_extrafields` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int NOT NULL,
  `process_color` text COLLATE utf8mb3_unicode_ci,
  `process_progress` int DEFAULT '0',
  `process_step` int DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_process_propal_fourn_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_process_propal_fourn_extrafields`
--


--
-- Table structure for table `t1zhf_process_rights`
--

CREATE TABLE `t1zhf_process_rights` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_usergroup` int NOT NULL DEFAULT '0',
  `element` text COLLATE utf8mb3_unicode_ci,
  `color` text COLLATE utf8mb3_unicode_ci,
  `step` int DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_process_rights`
--


--
-- Table structure for table `t1zhf_product`
--

CREATE TABLE `t1zhf_product` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `ref` varchar(128) COLLATE utf8mb3_unicode_ci NOT NULL,
  `entity` int NOT NULL DEFAULT '1',
  `ref_ext` varchar(128) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_parent` int DEFAULT '0',
  `label` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb3_unicode_ci,
  `note_public` text COLLATE utf8mb3_unicode_ci,
  `note` text COLLATE utf8mb3_unicode_ci,
  `customcode` varchar(32) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fk_country` int DEFAULT NULL,
  `fk_state` int DEFAULT NULL,
  `price` double(24,8) DEFAULT '0.00000000',
  `price_ttc` double(24,8) DEFAULT '0.00000000',
  `price_min` double(24,8) DEFAULT '0.00000000',
  `price_min_ttc` double(24,8) DEFAULT '0.00000000',
  `price_base_type` varchar(3) COLLATE utf8mb3_unicode_ci DEFAULT 'HT',
  `price_label` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cost_price` double(24,8) DEFAULT NULL,
  `default_vat_code` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `tva_tx` double(6,3) DEFAULT NULL,
  `recuperableonly` int NOT NULL DEFAULT '0',
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax1_type` varchar(10) COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '0',
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `localtax2_type` varchar(10) COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '0',
  `fk_user_author` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `tosell` tinyint DEFAULT '1',
  `tobuy` tinyint DEFAULT '1',
  `tobatch` tinyint NOT NULL DEFAULT '0',
  `sell_or_eat_by_mandatory` tinyint NOT NULL DEFAULT '0',
  `fk_product_type` int DEFAULT '0',
  `duration` varchar(6) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `seuil_stock_alerte` float DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `barcode` varchar(180) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fk_barcode_type` int DEFAULT NULL,
  `accountancy_code_sell` varchar(32) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `accountancy_code_sell_intra` varchar(32) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `accountancy_code_sell_export` varchar(32) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `accountancy_code_buy` varchar(32) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `accountancy_code_buy_intra` varchar(32) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `accountancy_code_buy_export` varchar(32) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `partnumber` varchar(32) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `weight` float DEFAULT NULL,
  `weight_units` tinyint DEFAULT NULL,
  `length` float DEFAULT NULL,
  `length_units` tinyint DEFAULT NULL,
  `width` float DEFAULT NULL,
  `width_units` tinyint DEFAULT NULL,
  `height` float DEFAULT NULL,
  `height_units` tinyint DEFAULT NULL,
  `surface` float DEFAULT NULL,
  `surface_units` tinyint DEFAULT NULL,
  `volume` float DEFAULT NULL,
  `volume_units` tinyint DEFAULT NULL,
  `stock` double DEFAULT NULL,
  `pmp` double(24,8) NOT NULL DEFAULT '0.00000000',
  `fifo` double(24,8) DEFAULT NULL,
  `lifo` double(24,8) DEFAULT NULL,
  `fk_default_warehouse` int DEFAULT NULL,
  `canvas` varchar(32) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `finished` tinyint DEFAULT NULL,
  `hidden` tinyint DEFAULT '0',
  `import_key` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `model_pdf` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fk_price_expression` int DEFAULT NULL,
  `desiredstock` float DEFAULT NULL,
  `fk_unit` int DEFAULT NULL,
  `price_autogen` tinyint DEFAULT '0',
  `fk_project` int DEFAULT NULL,
  `net_measure` float DEFAULT NULL,
  `net_measure_units` tinyint DEFAULT NULL,
  `batch_mask` varchar(32) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `lifetime` int DEFAULT NULL,
  `qc_frequency` int DEFAULT NULL,
  `mandatory_period` tinyint DEFAULT '0',
  `fk_default_bom` int DEFAULT NULL,
  `fk_default_workstation` int DEFAULT NULL,
  `stockable_product` int NOT NULL DEFAULT '1',
  `last_main_doc` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_ref` (`ref`,`entity`),
  UNIQUE KEY `uk_product_barcode` (`barcode`,`fk_barcode_type`,`entity`),
  KEY `idx_product_label` (`label`),
  KEY `idx_product_barcode` (`barcode`),
  KEY `idx_product_import_key` (`import_key`),
  KEY `idx_product_seuil_stock_alerte` (`seuil_stock_alerte`),
  KEY `idx_product_fk_country` (`fk_country`),
  KEY `idx_product_fk_user_author` (`fk_user_author`),
  KEY `idx_product_fk_barcode_type` (`fk_barcode_type`),
  KEY `fk_product_fk_unit` (`fk_unit`),
  KEY `fk_product_default_warehouse` (`fk_default_warehouse`),
  KEY `idx_product_fk_project` (`fk_project`),
  KEY `fk_product_finished` (`finished`),
  KEY `idx_product_entity_fk_product_type` (`entity`,`fk_product_type`),
  CONSTRAINT `fk_product_barcode_type` FOREIGN KEY (`fk_barcode_type`) REFERENCES `t1zhf_c_barcode_type` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_product_default_warehouse` FOREIGN KEY (`fk_default_warehouse`) REFERENCES `t1zhf_entrepot` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_product_finished` FOREIGN KEY (`finished`) REFERENCES `t1zhf_c_product_nature` (`code`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_product_fk_country` FOREIGN KEY (`fk_country`) REFERENCES `t1zhf_c_country` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_product_fk_unit` FOREIGN KEY (`fk_unit`) REFERENCES `t1zhf_c_units` (`rowid`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `t1zhf_product`
--

INSERT INTO `t1zhf_product` VALUES (1,'MO1',1,NULL,'2019-01-08 11:17:12','2024-09-18 08:26:46',0,'Disque Dur 1To','',NULL,'','',NULL,NULL,70.00000000,84.00000000,70.00000000,84.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0,100,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(2,'MO2',1,NULL,'2019-01-08 11:18:29','2024-09-02 14:01:58',0,'Main d\'oeuvre réparation','',NULL,'','',NULL,NULL,55.00000000,66.00000000,55.00000000,66.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,0,0,0,1,'1h',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,NULL,'',0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL),(3,'s1',1,NULL,'2019-01-10 18:02:41','2024-09-23 14:38:55',0,'selle','',NULL,'','',NULL,NULL,10.00000000,12.00000000,10.00000000,12.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(4,'r1',1,NULL,'2019-01-10 18:03:57','2024-09-23 17:00:55',0,'roue','',NULL,'','',NULL,NULL,20.00000000,24.00000000,20.00000000,24.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',NULL,NULL,NULL,2,'','','','','','',NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,18,0.00000000,NULL,NULL,1,'',1,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(5,'velo',1,NULL,'2019-01-10 18:05:01','2024-09-23 17:00:55',0,'velo','',NULL,'','',NULL,NULL,300.00000000,360.00000000,300.00000000,360.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,0,0,0,0,'',NULL,NULL,NULL,NULL,'707','707','707','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,119,85.26000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(6,'formation',1,NULL,'2019-02-04 14:34:01','2024-09-02 14:01:58',0,'fomation','',NULL,'','',NULL,NULL,700.00000000,840.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,0,0,0,1,'2h',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,NULL,'',0,0,NULL,NULL,NULL,NULL,4,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL),(7,'guidoline',1,NULL,'2019-02-08 10:12:01','2019-05-02 10:17:13',0,'guidoline','',NULL,'','',NULL,NULL,100.00000000,120.00000000,50.00000000,60.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,2,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,10,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(8,'test',1,NULL,'2019-02-11 13:01:56','2019-02-11 12:01:56',0,'Testproduit','',NULL,'','',NULL,NULL,100.00000000,120.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',2,2,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(9,'velo2',1,NULL,'2019-02-20 14:32:38','2024-09-03 16:16:56',0,'velo2','',NULL,'','',NULL,NULL,570.00000000,684.00000000,500.00000000,600.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,0,0,0,0,'',NULL,NULL,NULL,2,'','','','','','',NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(10,'Etudes_preliminaires',1,NULL,'2019-02-20 18:18:31','2024-09-02 14:01:58',0,'Etudes préliminaires 5%','&Eacute;tudes pr&eacute;liminaires',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,1,'',NULL,NULL,NULL,NULL,'706','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,NULL,'',0,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL),(11,'Avant_projet__estimation',1,NULL,'2019-02-20 18:19:33','2024-09-02 14:01:58',0,'Avant projet, estimation 15%','Avant projet, estimation',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,1,'',NULL,NULL,NULL,NULL,'706','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,NULL,'',0,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL),(12,'Dossier_permis_de_construire',1,NULL,'2019-02-20 18:20:07','2024-09-02 14:01:58',0,'Dossier permis de construire 20%','Dossier permis de construire',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,1,'',NULL,NULL,NULL,NULL,'706','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,NULL,'',0,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL),(13,'Projet_et_dossier_de_consultation_des_entreprises',1,NULL,'2019-02-20 18:21:05','2024-09-02 14:01:58',0,'Projet et dossier de consultation des entreprises','Projet et dossier de consultation des entreprises',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,1,'',NULL,NULL,NULL,NULL,'706','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,NULL,'',0,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL),(14,'Marches',1,NULL,'2019-02-20 18:21:23','2024-09-02 14:01:58',0,'Marchés','March&eacute;s',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,1,'',NULL,NULL,NULL,NULL,'706','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,NULL,'',0,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL),(15,'Direction_et_comptabilite_des_travaux_(suivant_planning)',1,NULL,'2019-02-20 18:21:40','2024-09-02 14:01:58',0,'Direction et comptabilité des travaux (suivant planning)','Direction et comptabilit&eacute; des travaux (suivant planning)',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,1,'',NULL,NULL,NULL,NULL,'706','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,NULL,'',0,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL),(16,'Reception',1,NULL,'2019-02-20 18:23:00','2024-09-02 14:01:58',0,'Réception 2%','R&eacute;ception',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,1,'',NULL,NULL,NULL,NULL,'706','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,NULL,'',0,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL),(17,'w10',1,NULL,'2019-02-28 11:31:41','2019-02-28 10:31:41',0,'w10','',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(19,'guidoline_BL',1,NULL,'2019-05-02 12:16:08','2019-05-02 10:17:13',0,'guidoline','<strong>Couleur:</strong> Bleue',NULL,'','',NULL,NULL,110.00000000,132.00000000,50.00000000,60.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',2,2,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,10,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(20,'guidoline_RG',1,NULL,'2019-05-02 12:17:58','2019-05-02 10:17:58',0,'guidoline','<strong>Couleur:</strong> Rouge',NULL,'','',NULL,NULL,105.00000000,126.00000000,50.00000000,60.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',2,2,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,1,0,NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,10,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(21,'xc38_diam45',1,NULL,'2019-06-24 09:23:38','2023-05-11 12:31:32',0,'xc38 diam45','xc38 diam45<br />\r\nen &eacute;tir&eacute; 6 m coup&eacute;',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,0,1,0,0,0,'',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,NULL,0,6000,-3,NULL,-3,NULL,-3,NULL,0,NULL,0,46,1.42000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,6,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(22,'rayons',1,NULL,'2019-07-13 10:50:49','2024-09-23 14:43:12',0,'rayons','',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0,-50,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(23,'tige_rayon',1,NULL,'2019-07-13 10:53:00','2024-09-23 14:43:12',0,'tige rayon','',NULL,'','',NULL,NULL,0.20000000,0.24000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(24,'HES52',1,NULL,'2019-07-13 11:10:37','2024-09-18 16:44:16',0,'HES52','',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0,10,121.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(25,'Armoire_electrique',1,NULL,'2019-07-13 11:11:08','2024-09-18 16:42:57',0,'Armoire électrique','',NULL,'','',NULL,NULL,132.00000000,158.40000000,100.00000000,120.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',NULL,NULL,'123456',2,'','','','','','',NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,998,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,'standard',NULL,NULL,1,0,NULL,NULL,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(26,'contacteur',1,NULL,'2019-07-13 11:11:58','2024-09-23 14:29:48',0,'contacteur','',NULL,'attention pb de fissure','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'411','','','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,10.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(27,'Tournage',1,NULL,'2019-07-14 20:30:46','2019-07-14 18:30:46',0,'Tournage','',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(28,'Groupe_Hydraulique',1,NULL,'2019-07-14 20:33:57','2024-09-18 16:42:57',0,'Groupe Hydraulique','',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0,-1,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(29,'pompe_smc',1,NULL,'2019-07-14 20:35:34','2019-07-14 18:35:34',0,'pompe smc','',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(30,'cadre',1,NULL,'2019-09-04 12:42:40','2024-09-23 14:38:50',0,'cadre','124 description',NULL,'','',1,NULL,5.00000000,6.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',NULL,NULL,NULL,2,'','','','','','',NULL,10,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,-27,500.00000000,NULL,NULL,1,'',0,0,NULL,NULL,NULL,NULL,6,0,NULL,NULL,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(31,'125',1,NULL,'2019-09-04 12:42:51','2019-09-04 10:42:51',0,'125','',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(32,'126',1,NULL,'2019-09-04 12:43:05','2019-09-04 10:43:05',0,'125','',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(33,'147',1,NULL,'2019-09-04 12:43:18','2019-09-04 10:43:18',0,'125','',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(34,'159',1,NULL,'2019-09-04 12:43:33','2019-09-04 10:43:33',0,'159','',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(35,'148',1,NULL,'2019-09-04 12:43:44','2019-09-04 10:43:44',0,'148','',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(36,'1482',1,NULL,'2019-09-04 12:44:01','2019-09-04 10:44:01',0,'1482','',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(37,'rolement_6230',1,NULL,'2019-09-09 15:00:39','2019-09-09 13:00:39',0,'roulment','',NULL,'','',NULL,NULL,5.00000000,6.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(38,'main_d_oeuvre',1,NULL,'2019-09-09 15:06:30','2024-09-02 14:01:58',0,'mo','',NULL,'','',NULL,NULL,10.00000000,12.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,1,'h',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,NULL,'',0,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL),(39,'CREAC3',1,NULL,'2020-01-14 14:50:24','2023-06-28 09:36:21',0,'APPLIQUE VALIDEE C3','',NULL,'','',NULL,NULL,1.00000000,1.20000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,0,0,0,0,'',NULL,NULL,NULL,NULL,'707','','','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0,-1,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(40,'124_BL',1,NULL,'2020-11-02 12:12:10','2021-05-26 12:02:23',0,'124 Bleue','124 description<br><strong>Couleur:</strong> Bleue',NULL,'','',1,NULL,6.00000000,7.20000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,10,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,1945,10.00000000,NULL,NULL,1,'',0,0,NULL,NULL,NULL,NULL,6,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(41,'124_RG',1,NULL,'2020-11-02 12:12:27','2021-05-26 12:02:23',0,'124 Rouge','124 description<br><strong>Couleur:</strong> Rouge',NULL,'','',1,NULL,7.00000000,8.40000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,10,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,246,0.00000000,NULL,NULL,1,'',0,0,NULL,NULL,NULL,NULL,6,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(42,'124_JAU',1,NULL,'2020-11-02 12:13:04','2021-05-18 13:01:33',0,'124 jaune','124 description<br><strong>Couleur:</strong> jaune',NULL,'','',1,NULL,6.00000000,7.20000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'','','','',NULL,NULL,NULL,10,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,175,0.00000000,NULL,NULL,1,'',0,0,NULL,NULL,NULL,NULL,6,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(43,'hyui123',1,NULL,'2021-03-08 17:01:15','2021-05-26 12:02:23',0,'Table 120 x 80','',NULL,'','',1,NULL,1500.00000000,1800.00000000,1200.00000000,1440.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'707','','','607',NULL,NULL,NULL,50,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,500.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(44,'Matiere',1,NULL,'2021-05-25 14:53:03','2021-05-25 12:53:03',0,'Matiere','',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',NULL,NULL,NULL,NULL,'707','','','607',NULL,NULL,NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(45,'Ouvrage',1,NULL,'2021-05-25 14:56:17','2021-05-25 12:56:17',0,'Ouvrage','',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,0,0,0,0,'',NULL,NULL,NULL,NULL,'707','','','607',NULL,NULL,NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(46,'E1',1,NULL,'2021-07-08 12:16:16','2021-07-08 10:22:59',0,'Limon française','Escalier<br />\r\nDescription :<br />\r\nLimon Fer Plat ep 8 mm',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',0,NULL,NULL,NULL,'707','','','607','','',NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(47,'O1',1,NULL,'2021-07-15 14:46:27','2021-07-15 12:46:27',0,'Ouverture sur mur porteur','',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',0,NULL,NULL,NULL,'707','','','607','','',NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(48,'E2',1,NULL,'2021-07-15 14:50:12','2024-09-02 14:01:58',0,'Etayage divers avec chevalement','',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,1,'s',0,NULL,NULL,NULL,'706','','','604','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL),(49,'L1',1,NULL,'2021-07-16 09:48:53','2024-09-02 14:01:58',0,'Fourniture et pose d’un linteau','Fourniture et pose d&rsquo;un linteau fer I de section 140mm pour la d&eacute;pose de la cloison de s&eacute;paration entre la cuisine et le s&eacute;jour. Comprenant transport, d&eacute;coupe et assemblage au mortier de ciment. Longueur 300cm.',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,1,'s',0,NULL,NULL,NULL,'706','','','604','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL),(50,'Transport',1,NULL,'2021-07-16 09:51:13','2021-07-16 08:11:44',0,'Transport','',NULL,'','',NULL,NULL,1.00000000,1.20000000,0.00000000,0.00000000,'HT',NULL,1.00000000,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',0,NULL,NULL,NULL,'707','','','607','','',NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',1,0,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(51,'Assemblage',1,NULL,'2021-07-16 09:56:11','2024-09-02 14:01:58',0,'Assemblage','',NULL,'','',NULL,NULL,50.00000000,60.00000000,0.00000000,0.00000000,'HT',NULL,50.00000000,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,1,'s',0,NULL,NULL,NULL,'706','','','604','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL),(52,'Decoupe',1,NULL,'2021-07-16 09:56:43','2024-09-02 14:01:58',0,'Découpe','',NULL,'','',NULL,NULL,50.00000000,60.00000000,0.00000000,0.00000000,'HT',NULL,50.00000000,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,1,'s',0,NULL,NULL,NULL,'706','','','604','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL),(53,'Linteau',1,NULL,'2021-07-16 09:57:43','2021-07-16 08:08:26',0,'Linteau','',NULL,'','',NULL,NULL,200.00000000,240.00000000,0.00000000,0.00000000,'HT',NULL,200.00000000,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',0,NULL,NULL,NULL,'707','','','607','','',NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,1,NULL),(54,'CARR1',1,NULL,'2021-07-16 11:01:40','2024-09-02 14:01:58',0,'Carrelage','Fourniture et pr&eacute;paration du support avant la pose du carrelage dans la cuisine par produit accrocheur et/ou ragr&eacute;age.<br />\r\nFourniture et pose d&#39;un carrelage gr&egrave;s c&eacute;rame de dimensions entre 33x33 et 60x60 cm en pose droite, pose &agrave; la colle et jointoiement compris. Base d&#39;achat : 25,00 &euro; HT le m&sup2;.',NULL,'','',NULL,NULL,14.00000000,16.80000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,1,'s',0,NULL,NULL,NULL,'706','','','604','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL),(55,'JM120P51',1,NULL,'2023-05-09 14:51:39','2023-05-09 12:53:39',0,'Meuble JOLIE MOME','Fourniture meuble JOLIE MOME<br />\r\nL120*P51*H63<br />\r\nBaltique brillant<br />\r\navec double vasque blanche',NULL,'','',NULL,NULL,2703.00000000,2973.30000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,10.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',0,NULL,NULL,2,'707','','','607','','',NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(56,'JM35P30',1,NULL,'2023-05-09 14:52:36','2023-05-09 12:53:05',0,'Meuble bas JOLIE MOME','Fourniture meuble bas JOLIE MOME<br />\r\ndroite et gauche / charni&egrave;re droite et gauche<br />\r\nL35*P30*H63<br />\r\nBaltique brillant',NULL,'','',NULL,NULL,609.00000000,669.90000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,10.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',0,NULL,NULL,2,'707','','','607','','',NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(57,'Pose',1,NULL,'2023-05-09 14:54:56','2024-09-02 14:01:58',0,'Pose et fixation','',NULL,'','',NULL,NULL,240.00000000,264.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,10.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,1,'4h',0,NULL,NULL,2,'706','','','604','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,4,0,NULL,NULL,NULL,'',NULL,NULL,0,NULL,NULL,0,NULL),(58,'Prepa',1,NULL,'2023-05-09 14:55:45','2023-05-09 12:55:45',0,'Préparation, protection et nettoyage du chantier','',NULL,'','',NULL,NULL,240.00000000,288.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',0,NULL,NULL,2,'707','','','607','','',NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(59,'c1',1,NULL,'2023-05-30 18:29:00','2024-09-23 17:00:55',0,'cadre','',NULL,'','',NULL,NULL,10.00000000,12.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',0,NULL,NULL,2,'707','','','607','','',NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,18,0.00000000,NULL,NULL,1,'',1,0,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(61,'velo2_JAU',1,NULL,'2024-09-03 19:09:40','2024-09-03 17:09:40',0,'velo2 jaune','<strong>Couleur:</strong> jaune',NULL,'','',NULL,NULL,570.00000000,684.00000000,500.00000000,600.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,0,0,0,0,'0',NULL,NULL,NULL,2,'','','','','','',NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(62,'velo2_BL',1,NULL,'2024-09-03 19:10:29','2024-09-03 17:10:29',0,'velo2 Bleue','<strong>Couleur:</strong> Bleue',NULL,'','',NULL,NULL,570.00000000,684.00000000,500.00000000,600.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,0,0,0,0,'0',NULL,NULL,NULL,2,'','','','','','',NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(63,'velo2_RG',1,NULL,'2024-09-03 19:10:42','2024-09-03 17:10:42',0,'velo2 Rouge','<strong>Couleur:</strong> Rouge',NULL,'','',NULL,NULL,570.00000000,684.00000000,500.00000000,600.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,0,0,0,0,'0',NULL,NULL,NULL,2,'','','','','','',NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(66,'Pann',1,NULL,'2024-09-18 10:30:58','2024-09-23 16:38:12',0,'Panneau 2000 x 1500','Panneau m&eacute;lamin&eacute; blanc',NULL,'','',1,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',2,NULL,'1234567',2,'707','','','607','','',NULL,20,0,2000,-3,1500,-3,18,-3,3,0,54,-9,7.5,12.45000000,NULL,NULL,1,'',NULL,0,NULL,NULL,NULL,5,1,0,NULL,NULL,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(69,'meuble_cuisine',1,NULL,'2024-09-18 10:42:23','2024-09-23 16:38:17',0,'meuble cuisine','',NULL,'','',NULL,NULL,110.00000000,132.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'0',0,NULL,NULL,2,'707','','','607','','',NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,22,48.65000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(70,'produit',1,NULL,'2024-09-23 19:13:18','2024-09-23 17:15:33',0,'produit','',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,20.000,0,0.000,'0',0.000,'0',1,1,1,1,0,0,0,'',0,NULL,NULL,2,'707','','','607','','',NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,0,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,1,0,NULL,NULL,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL);

--
