-- Table structure for table `llx_facturedet_extrafields`
--

CREATE TABLE `llx_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_facturedet_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_facturedet_extrafields`
--


--
-- Table structure for table `llx_facturedet_rec`
--

CREATE TABLE `llx_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `vat_src_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `tva_tx` double(6,3) DEFAULT NULL,
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax1_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `localtax2_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qty` double DEFAULT NULL,
  `remise_percent` double DEFAULT '0',
  `remise` double DEFAULT '0',
  `subprice` double(24,8) DEFAULT NULL,
  `subprice_ttc` double(24,8) DEFAULT '0.00000000',
  `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',
  `buy_price_ht` double(24,8) DEFAULT '0.00000000',
  `fk_product_fournisseur_price` int DEFAULT NULL,
  `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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fk_user_author` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `fk_multicurrency` int DEFAULT NULL,
  `multicurrency_code` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `multicurrency_subprice` double(24,8) DEFAULT '0.00000000',
  `multicurrency_subprice_ttc` 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',
  PRIMARY KEY (`rowid`),
  KEY `fk_facturedet_rec_fk_unit` (`fk_unit`),
  CONSTRAINT `fk_facturedet_rec_fk_unit` FOREIGN KEY (`fk_unit`) REFERENCES `llx_c_units` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_facturedet_rec`
--

INSERT INTO `llx_facturedet_rec` (`rowid`, `fk_facture`, `fk_parent_line`, `fk_product`, `product_type`, `label`, `description`, `vat_src_code`, `tva_tx`, `localtax1_tx`, `localtax1_type`, `localtax2_tx`, `localtax2_type`, `qty`, `remise_percent`, `remise`, `subprice`, `subprice_ttc`, `price`, `total_ht`, `total_tva`, `total_localtax1`, `total_localtax2`, `total_ttc`, `date_start_fill`, `date_end_fill`, `info_bits`, `buy_price_ht`, `fk_product_fournisseur_price`, `special_code`, `rang`, `fk_contract_line`, `fk_unit`, `import_key`, `fk_user_author`, `fk_user_modif`, `fk_multicurrency`, `multicurrency_code`, `multicurrency_subprice`, `multicurrency_subprice_ttc`, `multicurrency_total_ht`, `multicurrency_total_tva`, `multicurrency_total_ttc`) VALUES (2,2,NULL,1,1,NULL,'','',8.500,0.000,'0',0.000,'0',1,100,NULL,312.00000000,0.00000000,312.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0,0,0,0.00000000,NULL,0,2,NULL,NULL,NULL,NULL,NULL,1,'EUR',312.00000000,0.00000000,0.00000000,0.00000000,0.00000000),(3,2,NULL,5,1,NULL,'&nbsp;&nbsp;&nbsp;\r\n<ul>\r\n	<li>&nbsp;&nbsp;&nbsp; Fourniture d&#39;une assistance technique &agrave; la demande, en vue du maintien en condition op&eacute;rationnelle.<br />\r\n	&nbsp;</li>\r\n	<li>&nbsp;&nbsp;&nbsp; Configuration des terminaux tels que des ordinateurs, tablettes et imprimantes en suivant les bonnes pratiques.<br />\r\n	&nbsp;</li>\r\n	<li>&nbsp;&nbsp;&nbsp; Mise &agrave; jour p&eacute;riodique des images personnalis&eacute;es Windows 11 Professionnel et Windows 2016 LTSB.<br />\r\n	&nbsp;</li>\r\n	<li>&nbsp;&nbsp;&nbsp; Veille des mises &agrave; jour pour les logiciels non pris en charge par Endpoint Central.<br />\r\n	&nbsp;</li>\r\n	<li>&nbsp;&nbsp;&nbsp; Point hebdomadaire sur les demandes informatiques.<br />\r\n	&nbsp;</li>\r\n	<li>&nbsp;&nbsp;&nbsp; Rapport mensuel des demandes d&#39;assistance.</li>\r\n</ul>','',8.500,0.000,'0',0.000,'0',5,0,NULL,624.00000000,0.00000000,624.00000000,3120.00000000,265.20000000,0.00000000,0.00000000,3385.20000000,0,0,0,0.00000000,NULL,0,3,NULL,NULL,NULL,NULL,NULL,1,'EUR',624.00000000,0.00000000,3120.00000000,265.20000000,3385.20000000);

--
-- Table structure for table `llx_facturedet_rec_extrafields`
--

CREATE TABLE `llx_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_facturedet_rec_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_facturedet_rec_extrafields`
--


--
-- Table structure for table `llx_fichinter`
--

CREATE TABLE `llx_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ref_ext` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ref_client` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_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 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `note_private` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `note_public` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `model_pdf` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_main_doc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `import_key` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `extraparams` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `online_sign_ip` varchar(48) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `online_sign_name` varchar(64) COLLATE utf8mb4_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 `llx_societe` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_fichinter`
--

INSERT INTO `llx_fichinter` (`rowid`, `fk_soc`, `fk_projet`, `fk_contrat`, `ref`, `ref_ext`, `ref_client`, `entity`, `tms`, `datec`, `date_valid`, `datei`, `fk_user_author`, `fk_user_modif`, `fk_user_valid`, `fk_statut`, `dateo`, `datee`, `datet`, `duree`, `signed_status`, `description`, `note_private`, `note_public`, `model_pdf`, `last_main_doc`, `import_key`, `extraparams`, `online_sign_ip`, `online_sign_name`) VALUES (2,3,0,0,'(PROV2)',NULL,NULL,1,'2021-10-29 01:44:12','2021-10-29 01:39:11',NULL,NULL,3,3,NULL,0,'2021-10-28','2021-10-28',NULL,3600,NULL,'',NULL,NULL,'soleil',NULL,NULL,NULL,NULL,NULL),(3,18,0,0,'FI2210-0001',NULL,NULL,1,'2022-11-14 08:34:04','2022-10-03 15:09:27','2022-10-03 15:09:48',NULL,3,3,3,1,'2022-10-03','2022-10-03',NULL,3600,NULL,NULL,NULL,NULL,'soleil','ficheinter/FI2210-0001/FI2210-0001.pdf',NULL,NULL,NULL,NULL);

--
-- Table structure for table `llx_fichinter_extrafields`
--

CREATE TABLE `llx_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_ficheinter_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_fichinter_extrafields`
--


--
-- Table structure for table `llx_fichinter_rec`
--

CREATE TABLE `llx_fichinter_rec` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `title` varchar(50) COLLATE utf8mb4_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` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `modelpdf` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note_private` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `note_public` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `frequency` int DEFAULT NULL,
  `unit_frequency` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_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 `llx_projet` (`rowid`),
  CONSTRAINT `fk_fichinter_rec_fk_user_author` FOREIGN KEY (`fk_user_author`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_fichinter_rec`
--


--
-- Table structure for table `llx_fichinterdet`
--

CREATE TABLE `llx_fichinterdet` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_fichinter` int DEFAULT NULL,
  `fk_parent_line` int DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_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 `llx_fichinter` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_fichinterdet`
--

INSERT INTO `llx_fichinterdet` (`rowid`, `fk_fichinter`, `fk_parent_line`, `date`, `description`, `duree`, `rang`) VALUES (2,2,NULL,'2021-10-28 14:00:00','Nettoyage disque dur\r\nMise à jour Windows',3600,0),(3,3,NULL,'2022-10-03 00:00:00','Installation Office',3600,0);

--
-- Table structure for table `llx_fichinterdet_extrafields`
--

CREATE TABLE `llx_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_ficheinterdet_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_fichinterdet_extrafields`
--


--
-- Table structure for table `llx_fichinterdet_rec`
--

CREATE TABLE `llx_fichinterdet_rec` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_fichinter` int NOT NULL,
  `date` datetime DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `duree` int DEFAULT NULL,
  `rang` int DEFAULT '0',
  `total_ht` double(24,8) DEFAULT NULL,
  `subprice` double(24,8) DEFAULT NULL,
  `subprice_ttc` double(24,8) DEFAULT '0.00000000',
  `fk_parent_line` int DEFAULT NULL,
  `fk_product` int DEFAULT NULL,
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tva_tx` double(6,3) DEFAULT NULL,
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax1_type` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `localtax2_type` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_fichinterdet_rec`
--


--
-- Table structure for table `llx_holiday`
--

CREATE TABLE `llx_holiday` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ref_ext` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note_private` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `note_public` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `import_key` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `extraparams` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_holiday`
--


--
-- Table structure for table `llx_holiday_config`
--

CREATE TABLE `llx_holiday_config` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `idx_holiday_config` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_holiday_config`
--

INSERT INTO `llx_holiday_config` (`rowid`, `name`, `value`) VALUES (1,'lastUpdate','20221003145950');

--
-- Table structure for table `llx_holiday_extrafields`
--

CREATE TABLE `llx_holiday_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_holiday_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_holiday_extrafields`
--


--
-- Table structure for table `llx_holiday_logs`
--

CREATE TABLE `llx_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `prev_solde` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `new_solde` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_holiday_logs`
--


--
-- Table structure for table `llx_holiday_users`
--

CREATE TABLE `llx_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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_holiday_users`
--


--
-- Table structure for table `llx_hrm_evaluation`
--

CREATE TABLE `llx_hrm_evaluation` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `ref` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '(PROV)',
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `note_public` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `note_private` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `date_creation` datetime NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_user_creat` int NOT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `import_key` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `entity` int NOT NULL DEFAULT '1',
  `model_pdf` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_hrm_evaluation_rowid` (`rowid`),
  KEY `idx_hrm_evaluation_ref` (`ref`),
  KEY `llx_hrm_evaluation_fk_user_creat` (`fk_user_creat`),
  KEY `idx_hrm_evaluation_status` (`status`),
  CONSTRAINT `llx_hrm_evaluation_fk_user_creat` FOREIGN KEY (`fk_user_creat`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_hrm_evaluation`
--


--
-- Table structure for table `llx_hrm_evaluation_extrafields`
--

CREATE TABLE `llx_hrm_evaluation_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_evaluation_fk_object` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_hrm_evaluation_extrafields`
--


--
-- Table structure for table `llx_hrm_evaluationdet`
--

CREATE TABLE `llx_hrm_evaluationdet` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `date_creation` datetime NOT NULL,
  `tms` timestamp NOT 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`rowid`),
  KEY `idx_hrm_evaluationdet_rowid` (`rowid`),
  KEY `llx_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 `llx_hrm_evaluationdet_fk_evaluation` FOREIGN KEY (`fk_evaluation`) REFERENCES `llx_hrm_evaluation` (`rowid`),
  CONSTRAINT `llx_hrm_evaluationdet_fk_user_creat` FOREIGN KEY (`fk_user_creat`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_hrm_evaluationdet`
--


--
-- Table structure for table `llx_hrm_evaluationdet_extrafields`
--

CREATE TABLE `llx_hrm_evaluationdet_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_evaluationdet_fk_object` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_hrm_evaluationdet_extrafields`
--


--
-- Table structure for table `llx_hrm_job`
--

CREATE TABLE `llx_hrm_job` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `date_creation` datetime NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deplacement` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `note_public` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `note_private` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_hrm_job`
--


--
-- Table structure for table `llx_hrm_job_extrafields`
--

CREATE TABLE `llx_hrm_job_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_job_fk_object` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_hrm_job_extrafields`
--


--
-- Table structure for table `llx_hrm_job_user`
--

CREATE TABLE `llx_hrm_job_user` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `date_creation` datetime NOT NULL,
  `tms` timestamp NOT 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `note_public` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `note_private` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `fk_user_creat` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_hrm_job_user_rowid` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_hrm_job_user`
--


--
-- Table structure for table `llx_hrm_skill`
--

CREATE TABLE `llx_hrm_skill` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `date_creation` datetime NOT NULL,
  `tms` timestamp NOT 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 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `note_private` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`rowid`),
  KEY `idx_hrm_skill_rowid` (`rowid`),
  KEY `llx_hrm_skill_fk_user_creat` (`fk_user_creat`),
  KEY `idx_hrm_skill_skill_type` (`skill_type`),
  CONSTRAINT `llx_hrm_skill_fk_user_creat` FOREIGN KEY (`fk_user_creat`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_hrm_skill`
--


--
-- Table structure for table `llx_hrm_skill_extrafields`
--

CREATE TABLE `llx_hrm_skill_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_skill_fk_object` (`fk_object`),
  KEY `idx_skill_fk_object` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_hrm_skill_extrafields`
--


--
-- Table structure for table `llx_hrm_skilldet`
--

CREATE TABLE `llx_hrm_skilldet` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `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 `llx_hrm_skilldet_fk_user_creat` (`fk_user_creat`),
  KEY `llx_hrm_skilldet_fk_skill` (`fk_skill`),
  CONSTRAINT `llx_hrm_skilldet_fk_skill` FOREIGN KEY (`fk_skill`) REFERENCES `llx_hrm_skill` (`rowid`),
  CONSTRAINT `llx_hrm_skilldet_fk_user_creat` FOREIGN KEY (`fk_user_creat`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_hrm_skilldet`
--


--
-- Table structure for table `llx_hrm_skillrank`
--

CREATE TABLE `llx_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 NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_user_creat` int NOT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `objecttype` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_hrm_skillrank_rowid` (`rowid`),
  KEY `idx_hrm_skillrank_fk_skill` (`fk_skill`),
  KEY `llx_hrm_skillrank_fk_user_creat` (`fk_user_creat`),
  CONSTRAINT `llx_hrm_skillrank_fk_skill` FOREIGN KEY (`fk_skill`) REFERENCES `llx_hrm_skill` (`rowid`),
  CONSTRAINT `llx_hrm_skillrank_fk_user_creat` FOREIGN KEY (`fk_user_creat`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_hrm_skillrank`
--


--
-- Table structure for table `llx_import_model`
--

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

--
-- Dumping data for table `llx_import_model`
--


--
-- Table structure for table `llx_intracommreport`
--

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

--
-- Dumping data for table `llx_intracommreport`
--


--
-- Table structure for table `llx_inventory`
--

CREATE TABLE `llx_inventory` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `entity` int DEFAULT '0',
  `ref` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int DEFAULT '0',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_inventory` datetime DEFAULT NULL,
  `date_validation` datetime DEFAULT NULL,
  `import_key` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_inventory`
--

INSERT INTO `llx_inventory` (`rowid`, `entity`, `ref`, `date_creation`, `tms`, `fk_user_creat`, `fk_user_modif`, `fk_user_valid`, `fk_warehouse`, `fk_product`, `categories_product`, `status`, `title`, `date_inventory`, `date_validation`, `import_key`) VALUES (2,1,'test','2025-02-04 05:06:39','2025-02-04 05:06:52',3,3,3,6,NULL,'',1,'',NULL,'2025-02-04 05:06:47',NULL);

--
-- Table structure for table `llx_inventory_extrafields`
--

CREATE TABLE `llx_inventory_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_inventory_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_inventory_extrafields`
--


--
-- Table structure for table `llx_inventorydet`
--

CREATE TABLE `llx_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(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qty_stock` double DEFAULT NULL,
  `qty_view` 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 AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_inventorydet`
--

INSERT INTO `llx_inventorydet` (`rowid`, `datec`, `tms`, `fk_inventory`, `fk_warehouse`, `fk_product`, `batch`, `qty_stock`, `qty_view`, `qty_regulated`, `fk_movement`, `pmp_real`, `pmp_expected`) VALUES (4,'2025-02-04 05:06:47','2025-02-04 05:06:47',2,6,22,NULL,1,NULL,NULL,NULL,0,0),(5,'2025-02-04 05:06:47','2025-02-04 05:06:47',2,6,23,NULL,1,NULL,NULL,NULL,0,0),(6,'2025-02-04 05:06:47','2025-02-04 05:06:47',2,6,24,NULL,2,NULL,NULL,NULL,0,0);

--
-- Table structure for table `llx_knowledgemanagement_knowledgerecord`
--

CREATE TABLE `llx_knowledgemanagement_knowledgerecord` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `ref` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date_creation` datetime NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `last_main_doc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fk_user_creat` int NOT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `fk_user_valid` int DEFAULT NULL,
  `import_key` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `model_pdf` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `question` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `answer` longtext COLLATE utf8mb4_general_ci,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fk_ticket` int DEFAULT NULL,
  `fk_c_ticket_category` int DEFAULT NULL,
  `status` int NOT NULL,
  `lang` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `entity` int DEFAULT '1',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_knowledgemanagement_knowledgerecord`
--


--
-- Table structure for table `llx_knowledgemanagement_knowledgerecord_extrafields`
--

CREATE TABLE `llx_knowledgemanagement_knowledgerecord_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_knowledgerecord_fk_object` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_knowledgemanagement_knowledgerecord_extrafields`
--


--
-- Table structure for table `llx_links`
--

CREATE TABLE `llx_links` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `entity` int NOT NULL DEFAULT '1',
  `datea` datetime NOT NULL,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `objecttype` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `objectid` int NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_links` (`objectid`,`objecttype`,`label`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_links`
--


--
-- Table structure for table `llx_loan`
--

CREATE TABLE `llx_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fk_bank` int DEFAULT NULL,
  `capital` double(24,8) NOT NULL DEFAULT '0.00000000',
  `insurance_amount` double(24,8) DEFAULT '0.00000000',
  `datestart` date DEFAULT NULL,
  `dateend` date DEFAULT NULL,
  `nbterm` double DEFAULT NULL,
  `rate` double NOT NULL,
  `note_private` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `note_public` text CHARACTER SET utf8mb4 COLLATE utf8mb4_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `accountancy_account_insurance` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `accountancy_account_interest` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_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',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_loan`
--


--
-- Table structure for table `llx_loan_schedule`
--

CREATE TABLE `llx_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note_private` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `note_public` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `fk_bank` int NOT NULL,
  `fk_payment_loan` int DEFAULT NULL,
  `fk_user_creat` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_loan_schedule_ref` (`fk_loan`,`datep`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_loan_schedule`
--


--
-- Table structure for table `llx_localtax`
--

CREATE TABLE `llx_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_localtax`
--


--
-- Table structure for table `llx_mailing`
--

CREATE TABLE `llx_mailing` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `messtype` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT 'email',
  `statut` smallint DEFAULT '0',
  `titre` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `entity` int NOT NULL DEFAULT '1',
  `sujet` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `body` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `bgcolor` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bgimage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cible` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nbemail` int DEFAULT NULL,
  `email_from` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_from` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_replyto` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_errorsto` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tag` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_creat` datetime DEFAULT NULL,
  `date_valid` datetime DEFAULT NULL,
  `date_appro` datetime DEFAULT NULL,
  `date_envoi` 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_user_appro` int DEFAULT NULL,
  `extraparams` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `joined_file1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `joined_file2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `joined_file3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `joined_file4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `evenunsubscribe` smallint DEFAULT '0',
  `note_private` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `note_public` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_mailing` (`titre`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_mailing`
--


--
-- Table structure for table `llx_mailing_advtarget`
--

CREATE TABLE `llx_mailing_advtarget` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `name` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `entity` int NOT NULL DEFAULT '1',
  `fk_element` int NOT NULL,
  `type_element` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `filtervalue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_mailing_advtarget`
--


--
-- Table structure for table `llx_mailing_cibles`
--

CREATE TABLE `llx_mailing_cibles` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_mailing` int NOT NULL,
  `fk_contact` int NOT NULL,
  `lastname` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `firstname` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `other` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tag` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `statut` smallint NOT NULL DEFAULT '0',
  `source_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source_id` int DEFAULT NULL,
  `source_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_envoi` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `error_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_mailing_cibles`
--


--
-- Table structure for table `llx_mailing_unsubscribe`
--

CREATE TABLE `llx_mailing_unsubscribe` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `entity` int NOT NULL DEFAULT '1',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `unsubscribegroup` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_creat` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_mailing_unsubscribe` (`email`,`entity`,`unsubscribegroup`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_mailing_unsubscribe`
--


--
-- Table structure for table `llx_menu`
--

CREATE TABLE `llx_menu` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `menu_handler` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `entity` int NOT NULL DEFAULT '1',
  `module` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mainmenu` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `leftmenu` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fk_menu` int NOT NULL,
  `fk_mainmenu` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fk_leftmenu` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` int NOT NULL,
  `url` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `target` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `titre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `prefix` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `langs` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `level` smallint DEFAULT NULL,
  `perms` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `enabled` text CHARACTER SET utf8mb4 COLLATE utf8mb4_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=689 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_menu`
--

INSERT INTO `llx_menu` (`rowid`, `menu_handler`, `entity`, `module`, `type`, `mainmenu`, `leftmenu`, `fk_menu`, `fk_mainmenu`, `fk_leftmenu`, `position`, `url`, `target`, `titre`, `prefix`, `langs`, `level`, `perms`, `enabled`, `usertype`, `tms`) VALUES (540,'all',0,'api','left','tools','devtools_api',-1,'tools',NULL,100,'/api/index.php/explorer','_apiexplorer','ApiExplorer','<span class=\"fas fa-cogs  em080 paddingright pictofixedwidth\" style=\" color: #999;\"></span>','modulebuilder',NULL,'1','isModEnabled(\"api\")',0,'2024-08-03 05:37:12'),(607,'all',1,'sellyoursaas','top','sellyoursaas',NULL,0,NULL,NULL,200,'/sellyoursaas/backoffice/index.php','','__[SELLYOURSAAS_NAME]__','<img src=\"/sellyoursaas/img/object_sellyoursaas.png\" alt=\"\" class=\"paddingright2imp pictofixedwidth valignmiddle\">','',NULL,'$user->hasRight(\"sellyoursaas\", \"liens\", \"voir\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(608,'all',1,'sellyoursaas','left','sellyoursaas','mysaas_summary',-1,'sellyoursaas',NULL,100,'/sellyoursaas/backoffice/index.php','','Summary','<img src=\"/sellyoursaas/img/sellyoursaas.png\" alt=\"\" class=\"paddingright pictofixedwidth valignmiddle\">','sellyoursaas@sellyoursaas',NULL,'$user->hasRight(\"sellyoursaas\", \"read\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(609,'all',1,'sellyoursaas','left','sellyoursaas','mysaas_packages',-1,'sellyoursaas',NULL,210,'/sellyoursaas/packages_list.php','','Packages','<span class=\"fas fa-layer-group paddingright pictofixedwidth\" style=\"\"></span>','',NULL,'$user->hasRight(\"sellyoursaas\", \"read\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(610,'all',1,'sellyoursaas','left','sellyoursaas','mysaas_createpackage',-1,'sellyoursaas','mysaas_packages',211,'/sellyoursaas/packages_card.php?action=create','','NewPackage','','sellyoursaas@sellyoursaas',NULL,'$user->hasRight(\"sellyoursaas\", \"write\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(611,'all',1,'sellyoursaas','left','sellyoursaas','mysaas_live',-1,'sellyoursaas','mysaas_packages',212,'__[SELLYOURSAAS_REFS_URL]__','_refs','LiveRefsInstances','','sellyoursaas@sellyoursaas',NULL,'$user->hasRight(\"sellyoursaas\", \"read\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(612,'all',1,'sellyoursaas','left','sellyoursaas','mysaas_products',-1,'sellyoursaas',NULL,220,'/product/list.php?contextpage=sellyoursaasproducts&type=1&search_category_product_list[]=__[SELLYOURSAAS_DEFAULT_PRODUCT_CATEG]__','','Services','<span class=\"fas fa-concierge-bell paddingright pictofixedwidth\" style=\" color: #a69944;\"></span>','',NULL,'$user->hasRight(\"sellyoursaas\", \"read\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(613,'all',1,'sellyoursaas','left','sellyoursaas','mysaas_createproduct',-1,'sellyoursaas','mysaas_products',221,'/product/card.php?type=1&action=create&categories[]=__[SELLYOURSAAS_DEFAULT_PRODUCT_CATEG]__','','NewService','','',NULL,'$user->hasRight(\"sellyoursaas\", \"write\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(614,'all',1,'sellyoursaas','left','sellyoursaas','mysaas_registration',-1,'sellyoursaas','mysaas_products',229,'/sellyoursaas/registrationlinks_list.php','','RegistrationPages','<span class=\"far fa-file paddingright pictofixedwidth\" style=\"\"></span>','sellyoursaas@sellyoursaas',NULL,'$user->hasRight(\"sellyoursaas\", \"read\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(615,'all',1,'sellyoursaas','left','sellyoursaas','mysaas_customers',-1,'sellyoursaas',NULL,230,'/societe/list.php?contextpage=sellyoursaasprospectsclients&search_categ_cus=__[SELLYOURSAAS_DEFAULT_CUSTOMER_CATEG]__&sortfield=s.tms&sortorder=desc','','ProspectsOrCustomers','<span class=\"fas fa-building paddingright pictofixedwidth\" style=\" color: #6c6aa8;\"></span>','',NULL,'$user->hasRight(\"sellyoursaas\", \"read\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(616,'all',1,'sellyoursaas','left','sellyoursaas','mysaas_customers_create',-1,'sellyoursaas','mysaas_customers',231,'/societe/card.php?action=create&type=c&custcats[]=__[SELLYOURSAAS_DEFAULT_CUSTOMER_CATEG]__','','NewCustomer','','sellyoursaas@sellyoursaas',NULL,'$user->hasRight(\"sellyoursaas\", \"write\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(617,'all',1,'sellyoursaas','left','sellyoursaas','mysaas_customers_prospects',-1,'sellyoursaas','mysaas_customers',233,'/societe/list.php?contextpage=sellyoursaasprospects&search_categ_cus=__[SELLYOURSAAS_DEFAULT_CUSTOMER_CATEG]__&search_type=2,3&sortfield=s.tms&sortorder=desc','','Prospects','','',NULL,'$user->hasRight(\"sellyoursaas\", \"write\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(618,'all',1,'sellyoursaas','left','sellyoursaas','mysaas_customers_customers',-1,'sellyoursaas','mysaas_customers',234,'/societe/list.php?contextpage=sellyoursaasclients&search_categ_cus=__[SELLYOURSAAS_DEFAULT_CUSTOMER_CATEG]__&search_type=1,3&sortfield=s.tms&sortorder=desc','','Customers','','',NULL,'$user->hasRight(\"sellyoursaas\", \"write\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(619,'all',1,'sellyoursaas','left','sellyoursaas','mysaas_instances',-1,'sellyoursaas',NULL,240,'/contrat/list.php?leftmenu=contracts&contextpage=sellyoursaasinstances&search_product_category=__[SELLYOURSAAS_DEFAULT_PRODUCT_CATEG]__','','Instances','<span class=\"fas fa-suitcase  em092 infobox-contrat paddingright pictofixedwidth\" style=\"\"></span>','sellyoursaas@sellyoursaas',NULL,'$user->hasRight(\"sellyoursaas\", \"read\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(620,'all',1,'sellyoursaas','left','sellyoursaas','mysaas_instances_create',-1,'sellyoursaas','mysaas_instances',241,'/sellyoursaas/backoffice/newcustomerinstance.php?action=create','','NewInstance','','sellyoursaas@sellyoursaas',NULL,'$user->hasRight(\"sellyoursaas\", \"write\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(621,'all',1,'sellyoursaas','left','sellyoursaas','mysaas_instances_backup',-1,'sellyoursaas','mysaas_instances',245,'/contrat/list.php?leftmenu=contracts&contextpage=sellyoursaasinstancesbackup&sortfield=ef.latestbackup_date_ok&sortorder=asc&search_options_deployment_status=done&search_options_latestbackup_status=KO','','OnlineInstancesWithBackupErrors','','sellyoursaas@sellyoursaas',NULL,'$user->hasRight(\"sellyoursaas\", \"write\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(622,'all',1,'sellyoursaas','left','sellyoursaas','website',-1,'sellyoursaas',NULL,501,'__[SELLYOURSAAS_ACCOUNT_URL]__','_sellyoursaas_customer','CustomerPortal','<span class=\"fas fa-external-link-alt paddingright pictofixedwidth\" style=\"\"></span>','sellyoursaas@sellyoursaas',NULL,'$user->hasRight(\"sellyoursaas\", \"read\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(623,'all',1,'sellyoursaas','left','sellyoursaas','mysaas_resellerlist',-1,'sellyoursaas',NULL,601,'/societe/list.php?contextpage=sellyoursaasresellers&search_categ_sup=__[SELLYOURSAAS_DEFAULT_RESELLER_CATEG]__','','Resellers','<span class=\"fas fa-building paddingright pictofixedwidth\" style=\" color: #6c6aa8;\"></span>','',NULL,'$user->hasRight(\"sellyoursaas\", \"read\")','isModEnabled(\"sellyoursaas\") && getDolGlobalInt(\'SELLYOURSAAS_ALLOW_RESELLER_PROGRAM\')',0,'2025-03-05 03:56:07'),(624,'all',1,'sellyoursaas','left','sellyoursaas','mysaas_createreseller',-1,'sellyoursaas','mysaas_resellerlist',602,'/societe/card.php?action=create&type=f&options_dolicloud=no&suppcats[]=__[SELLYOURSAAS_DEFAULT_RESELLER_CATEG]__','','NewReseller','','sellyoursaas@sellyoursaas',NULL,'$user->hasRight(\"sellyoursaas\", \"write\")','isModEnabled(\"sellyoursaas\") && getDolGlobalInt(\'SELLYOURSAAS_ALLOW_RESELLER_PROGRAM\')',0,'2025-03-05 03:56:07'),(625,'all',1,'sellyoursaas','left','sellyoursaas','mysaas_pendingreseller',-1,'sellyoursaas','mysaas_resellerlist',602,'/societe/list.php?contextpage=sellyoursaasresellers&search_categ_sup=-2&search_options_date_apply_for_reseller_startday=1&search_options_date_apply_for_reseller_startmonth=1&search_options_date_apply_for_reseller_startyear=2000','','PendingResellers','','sellyoursaas@sellyoursaas',NULL,'$user->hasRight(\"sellyoursaas\", \"read\")','isModEnabled(\"sellyoursaas\") && getDolGlobalInt(\'SELLYOURSAAS_ALLOW_RESELLER_PROGRAM\')',0,'2025-03-05 03:56:07'),(626,'all',1,'sellyoursaas','left','sellyoursaas','sellyoursaas_blacklist',-1,'sellyoursaas',NULL,601,'','','SecurityTools','<span class=\"fas fa-ban paddingright pictofixedwidth\" style=\"\"></span>','',NULL,'$user->hasRight(\"sellyoursaas\", \"read\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(627,'all',1,'sellyoursaas','left','sellyoursaas','sellyoursaas_evilthidparties',-1,'sellyoursaas','sellyoursaas_blacklist',621,'/societe/list.php?contextpage=sellyoursaasevilthirdparties&search_options_spammer=1','','EvilThirdParties','','sellyoursaas@sellyoursaas',NULL,'$user->hasRight(\"sellyoursaas\", \"read\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(628,'all',1,'sellyoursaas','left','sellyoursaas','sellyoursaas_evilinstances',-1,'sellyoursaas','sellyoursaas_blacklist',622,'/contrat/list.php?contextpage=sellyoursaasevilinstances&search_options_spammer=1&search_product_category=__[SELLYOURSAAS_DEFAULT_PRODUCT_CATEG]__','','EvilInstances','','sellyoursaas@sellyoursaas',NULL,'$user->hasRight(\"sellyoursaas\", \"read\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(629,'all',1,'sellyoursaas','left','sellyoursaas','sellyoursaas_whitelistip',-1,'sellyoursaas','sellyoursaas_blacklist',641,'/sellyoursaas/whitelistip_list.php','','WhitelistIP','','',NULL,'$user->hasRight(\"sellyoursaas\", \"read\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(630,'all',1,'sellyoursaas','left','sellyoursaas','sellyoursaas_whitelistemail',-1,'sellyoursaas','sellyoursaas_blacklist',642,'/sellyoursaas/whitelistemail_list.php','','WhitelistEmail','','',NULL,'$user->hasRight(\"sellyoursaas\", \"read\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(631,'all',1,'sellyoursaas','left','sellyoursaas','sellyoursaas_blacklistip',-1,'sellyoursaas','sellyoursaas_blacklist',652,'/sellyoursaas/blacklistip_list.php','','BlacklistIP','','',NULL,'$user->hasRight(\"sellyoursaas\", \"read\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(632,'all',1,'sellyoursaas','left','sellyoursaas','sellyoursaas_blacklistfrom',-1,'sellyoursaas','sellyoursaas_blacklist',653,'/sellyoursaas/blacklistfrom_list.php','','BlacklistFrom','','',NULL,'$user->hasRight(\"sellyoursaas\", \"read\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(633,'all',1,'sellyoursaas','left','sellyoursaas','sellyoursaas_blacklistto',-1,'sellyoursaas','sellyoursaas_blacklist',654,'/sellyoursaas/blacklistto_list.php','','BlacklistTo','','',NULL,'$user->hasRight(\"sellyoursaas\", \"read\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(634,'all',1,'sellyoursaas','left','sellyoursaas','sellyoursaas_blacklistdir',-1,'sellyoursaas','sellyoursaas_blacklist',655,'/sellyoursaas/blacklistdir_list.php','','BlacklistDir','','',NULL,'$user->hasRight(\"sellyoursaas\", \"read\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(635,'all',1,'sellyoursaas','left','sellyoursaas','sellyoursaas_blacklistcontent',-1,'sellyoursaas','sellyoursaas_blacklist',656,'/sellyoursaas/blacklistcontent_list.php','','BlacklistContent','','',NULL,'$user->hasRight(\"sellyoursaas\", \"read\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(636,'all',1,'sellyoursaas','left','sellyoursaas','sellyoursaas_blacklistmails',-1,'sellyoursaas','sellyoursaas_blacklist',657,'/sellyoursaas/blacklistmail_list.php','','BlacklistMails','','',NULL,'$user->hasRight(\"sellyoursaas\", \"read\")','isModEnabled(\"sellyoursaas\")',0,'2025-03-05 03:56:07'),(639,'all',1,'emailcollector','left','home',NULL,-1,'home','admintools',400,'/admin/emailcollector_list.php?leftmenu=admintools','','EmailCollectors','','admin',NULL,'$user->admin','isModEnabled(\"emailcollector\") && preg_match(\'/^(admintools|all)/\', $leftmenu)',2,'2025-03-14 08:14:34'),(645,'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,'2025-04-01 21:49:47'),(646,'all',1,'agenda','left','agenda',NULL,645,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,'2025-04-01 21:49:47'),(647,'all',1,'agenda','left','agenda',NULL,646,NULL,NULL,101,'/comm/action/card.php?mainmenu=agenda&amp;leftmenu=agenda&action=create','','NewAction','','commercial',NULL,'($user->hasRight(\"agenda\", \"myactions\", \"create\") || $user->hasRight(\"agenda\", \"allactions\", \"create\"))','isModEnabled(\"agenda\")',2,'2025-04-01 21:49:47'),(648,'all',1,'agenda','left','agenda',NULL,646,NULL,NULL,140,'/comm/action/index.php?mainmenu=agenda&amp;leftmenu=agenda','','Calendar','','agenda',NULL,'$user->hasRight(\"agenda\", \"myactions\", \"read\")','isModEnabled(\"agenda\")',2,'2025-04-01 21:49:47'),(649,'all',1,'agenda','left','agenda',NULL,648,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,'2025-04-01 21:49:47'),(650,'all',1,'agenda','left','agenda',NULL,648,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,'2025-04-01 21:49:47'),(651,'all',1,'agenda','left','agenda',NULL,648,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,'2025-04-01 21:49:47'),(652,'all',1,'agenda','left','agenda',NULL,648,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,'2025-04-01 21:49:47'),(653,'all',1,'agenda','left','agenda',NULL,646,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,'2025-04-01 21:49:47'),(654,'all',1,'agenda','left','agenda',NULL,653,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,'2025-04-01 21:49:47'),(655,'all',1,'agenda','left','agenda',NULL,653,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,'2025-04-01 21:49:47'),(656,'all',1,'agenda','left','agenda',NULL,653,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,'2025-04-01 21:49:47'),(657,'all',1,'agenda','left','agenda',NULL,653,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,'2025-04-01 21:49:47'),(658,'all',1,'agenda','left','agenda',NULL,646,NULL,NULL,160,'/comm/action/rapport/index.php?mainmenu=agenda&amp;leftmenu=agenda','','Reportings','','agenda',NULL,'$user->hasRight(\"agenda\", \"allactions\", \"read\")','isModEnabled(\"agenda\")',2,'2025-04-01 21:49:47'),(659,'all',1,'agenda','left','agenda',NULL,646,NULL,NULL,170,'/categories/index.php?mainmenu=agenda&amp;leftmenu=agenda&type=10','','Categories','','agenda',NULL,'$user->hasRight(\"agenda\", \"allactions\", \"read\")','isModEnabled(\"category\")',2,'2025-04-01 21:49:47'),(660,'all',1,'cron','left','home',NULL,-1,'home','admintools',500,'/cron/list.php?leftmenu=admintools','','CronList','','cron',NULL,'$user->rights->cron->read','$conf->cron->enabled && preg_match(\'/^(admintools|all)/\', $leftmenu)',2,'2025-04-01 21:49:47'),(661,'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,'2025-04-01 21:49:47'),(662,'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,'2025-04-01 21:49:47'),(663,'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,'2025-04-01 21:49:47'),(664,'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,'2025-04-01 21:49:47'),(665,'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,'2025-04-01 21:49:47'),(666,'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,'2025-04-01 21:49:47'),(667,'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,'2025-04-01 21:49:47'),(668,'all',1,'printing','left','home',NULL,-1,'home','admintools',300,'/printing/index.php?mainmenu=home&leftmenu=admintools','','MenuDirectPrinting','','printing',NULL,'$user->rights->printing->read','$conf->printing->enabled && preg_match(\'/^(admintools|all)/\', $leftmenu)',0,'2025-04-01 21:49:47'),(669,'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,'2025-04-01 21:49:47'),(670,'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,'2025-04-01 21:49:47'),(671,'all',1,'resource','left','agenda','resource_list',-1,'agenda','resource',102,'/resource/list.php','','List','','resource',NULL,'$user->rights->resource->read','1',0,'2025-04-01 21:49:47'),(672,'all',1,'stripe','left','bank','stripe',-1,'bank',NULL,100,'','','StripeAccount','<span class=\"fab fa-stripe-s infobox-bank_account paddingright pictofixedwidth\" style=\"\"></span>','stripe',NULL,'$user->rights->banque->lire','isModEnabled(\"stripe\") && isModenabled(\"banque\")',0,'2025-04-01 21:49:47'),(673,'all',1,'stripe','left','bank',NULL,-1,'bank','stripe',102,'/stripe/charge.php','','StripeChargeList','','stripe',NULL,'$user->rights->banque->lire','isModEnabled(\"stripe\") && isModenabled(\"banque\") && getDolGlobalInt(\"MAIN_FEATURES_LEVEL\") >= 1',0,'2025-04-01 21:49:47'),(674,'all',1,'stripe','left','bank',NULL,-1,'bank','stripe',102,'/stripe/transaction.php','','StripeTransactionList','','stripe',NULL,'$user->rights->banque->lire','isModEnabled(\"stripe\") && isModenabled(\"banque\") && getDolGlobalInt(\"MAIN_FEATURES_LEVEL\") >= 2',0,'2025-04-01 21:49:47'),(675,'all',1,'stripe','left','bank',NULL,-1,'bank','stripe',103,'/stripe/payout.php','','StripePayoutList','','stripe',NULL,'$user->rights->banque->lire','isModEnabled(\"stripe\") && isModenabled(\"banque\")',0,'2025-04-01 21:49:47'),(676,'all',1,'takepos','top','takepos',NULL,0,NULL,NULL,1001,'/takepos/index.php','takepos','PointOfSaleShort','<span class=\"fas fa-cash-register infobox-bank_account pictofixedwidth\" style=\"\"></span>','cashdesk',NULL,'$user->hasRight(\"takepos\", \"run\")','isModEnabled(\"takepos\")',2,'2025-04-01 21:49:47'),(683,'all',1,'paiedolibarr','left','hrm','paielist',-1,'hrm',NULL,201,'/paiedolibarr/list.php','','paielist','','paiedolibarr@paiedolibarr',NULL,'($user->rights->paiedolibarr->lire)','1',2,'2025-04-02 19:43:25'),(684,'all',1,'paiedolibarr','left','hrm','paielist2',-1,'hrm','paielist',202,'/paiedolibarr/list.php','','listofpaie','','paiedolibarr@paiedolibarr',NULL,'($user->rights->paiedolibarr->lire)','1',2,'2025-04-02 19:43:25'),(685,'all',1,'paiedolibarr','left','hrm',NULL,-1,'hrm','paielist2',203,'/paiedolibarr/card.php?action=create','','NewPaie','','paiedolibarr@paiedolibarr',NULL,'($user->rights->paiedolibarr->creer)','1',2,'2025-04-02 19:43:25'),(686,'all',1,'paiedolibarr','left','hrm','paielist4',-1,'hrm','paielist',206,'/paiedolibarr/etat.php','','PayrollJournal','','paiedolibarr@paiedolibarr',NULL,'($user->rights->paiedolibarr->lire)','1',2,'2025-04-02 19:43:25'),(687,'all',1,'paiedolibarr','left','hrm','paielist3',-1,'hrm','paielist',207,'/paiedolibarr/rules/index.php','','paierules','','paiedolibarr@paiedolibarr',NULL,'($user->rights->paiedolibarr->lire)','1',2,'2025-04-02 19:43:25'),(688,'all',1,'paiedolibarr','left','hrm','Configuration',-1,'hrm','paielist',211,'paiedolibarr/admin/paiedolibarr_setup.php','','Setup','','paiedolibarr@paiedolibarr',NULL,'($user->rights->paiedolibarr->lire)','1',2,'2025-04-02 19:43:25');

--
-- Table structure for table `llx_mrp_mo`
--

CREATE TABLE `llx_mrp_mo` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `ref` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '(PROV)',
  `entity` int NOT NULL DEFAULT '1',
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qty` double NOT NULL,
  `fk_warehouse` int DEFAULT NULL,
  `fk_soc` int DEFAULT NULL,
  `note_public` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `note_private` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `date_creation` datetime NOT NULL,
  `date_valid` datetime DEFAULT NULL,
  `tms` timestamp NOT 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,
  `import_key` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model_pdf` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_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 `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_mrp_mo`
--


--
-- Table structure for table `llx_mrp_mo_extrafields`
--

CREATE TABLE `llx_mrp_mo_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_mrp_mo_fk_object` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_mrp_mo_extrafields`
--


--
-- Table structure for table `llx_mrp_production`
--

CREATE TABLE `llx_mrp_production` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_mo` int NOT NULL,
  `origin_id` int DEFAULT NULL,
  `origin_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fk_mrp_production` int DEFAULT NULL,
  `fk_stock_movement` int DEFAULT NULL,
  `date_creation` datetime NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_user_creat` int NOT NULL,
  `fk_user_modif` int DEFAULT NULL,
  `import_key` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_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 `llx_mrp_mo` (`rowid`),
  CONSTRAINT `fk_mrp_production_product` FOREIGN KEY (`fk_product`) REFERENCES `llx_product` (`rowid`),
  CONSTRAINT `fk_mrp_production_stock_movement` FOREIGN KEY (`fk_stock_movement`) REFERENCES `llx_stock_mouvement` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_mrp_production`
--


--
-- Table structure for table `llx_mrp_production_extrafields`
--

CREATE TABLE `llx_mrp_production_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) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_mrp_production_fk_object` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `llx_mrp_production_extrafields`
--


--
-- Table structure for table `llx_multicurrency`
--

CREATE TABLE `llx_multicurrency` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `date_create` datetime DEFAULT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `entity` int DEFAULT '1',
  `fk_user` int DEFAULT NULL,
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_multicurrency`
--

INSERT INTO `llx_multicurrency` (`rowid`, `date_create`, `code`, `name`, `entity`, `fk_user`, `tms`) VALUES (1,'2022-10-03 15:48:57','EUR','Euros (€)',1,2,'2025-04-01 21:49:44');

--
-- Table structure for table `llx_multicurrency_rate`
--

CREATE TABLE `llx_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',
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_multicurrency_rate`
--

INSERT INTO `llx_multicurrency_rate` (`rowid`, `date_sync`, `rate`, `fk_multicurrency`, `entity`, `rate_indirect`, `tms`) VALUES (1,'2022-10-03 15:48:57',1,1,1,0,'2025-04-01 21:49:44');

--
-- Table structure for table `llx_notify`
--

CREATE TABLE `llx_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'email',
  `type_target` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `objet_type` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `objet_id` int NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_notify`
--


--
-- Table structure for table `llx_notify_def`
--

CREATE TABLE `llx_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'email',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `threshold` double(24,8) DEFAULT NULL,
  `context` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `entity` int DEFAULT '1',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_notify_def`
--


--
-- Table structure for table `llx_notify_def_object`
--

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

--
-- Dumping data for table `llx_notify_def_object`
--


--
-- Table structure for table `llx_oauth_state`
--

CREATE TABLE `llx_oauth_state` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `service` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_oauth_state`
--


--
-- Table structure for table `llx_oauth_token`
--

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

--
-- Dumping data for table `llx_oauth_token`
--

INSERT INTO `llx_oauth_token` (`rowid`, `service`, `token`, `tokenstring`, `state`, `fk_soc`, `fk_user`, `fk_adherent`, `entity`, `restricted_ips`, `datec`, `tms`) VALUES (2,'Microsoft','dolcrypt:AES-256-CTR:b9d89ba0ef0b21b0:[encoded data, 4460 characters]',NULL,NULL,NULL,NULL,NULL,1,NULL,'2024-07-31 00:03:23','2024-07-31 04:03:23'),(3,'Microsoft-commercial','dolcrypt:AES-256-CTR:f8be505517600403:[encoded data, 4548 characters]',NULL,NULL,NULL,NULL,NULL,1,NULL,'2024-07-31 00:14:12','2024-10-19 13:49:06');

--
-- Table structure for table `llx_object_lang`
--

CREATE TABLE `llx_object_lang` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_object` int NOT NULL DEFAULT '0',
  `type_object` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `property` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lang` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `import_key` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_object_lang` (`fk_object`,`type_object`,`property`,`lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_object_lang`
--


--
-- Table structure for table `llx_onlinesignature`
--

CREATE TABLE `llx_onlinesignature` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `entity` int NOT NULL DEFAULT '1',
  `object_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pathoffile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_onlinesignature`
--


--
-- Table structure for table `llx_opensurvey_comments`
--

CREATE TABLE `llx_opensurvey_comments` (
  `id_comment` int unsigned NOT NULL AUTO_INCREMENT,
  `id_sondage` char(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `usercomment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ip` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_opensurvey_comments`
--


--
-- Table structure for table `llx_opensurvey_formquestions`
--

CREATE TABLE `llx_opensurvey_formquestions` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `id_sondage` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `question` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `available_answers` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_opensurvey_formquestions`
--


--
-- Table structure for table `llx_opensurvey_sondage`
--

CREATE TABLE `llx_opensurvey_sondage` (
  `id_sondage` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `entity` int NOT NULL DEFAULT '1',
  `commentaires` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `mail_admin` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nom_admin` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fk_user_creat` int NOT NULL,
  `titre` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_fin` datetime DEFAULT NULL,
  `status` int DEFAULT '1',
  `format` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_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 NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `sujet` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id_sondage`),
  KEY `idx_date_fin` (`date_fin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_opensurvey_sondage`
--


--
-- Table structure for table `llx_opensurvey_user_formanswers`
--

CREATE TABLE `llx_opensurvey_user_formanswers` (
  `fk_user_survey` int NOT NULL,
  `fk_question` int NOT NULL,
  `reponses` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_opensurvey_user_formanswers`
--


--
-- Table structure for table `llx_opensurvey_user_studs`
--

CREATE TABLE `llx_opensurvey_user_studs` (
  `id_users` int NOT NULL AUTO_INCREMENT,
  `nom` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_sondage` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `reponses` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ip` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_opensurvey_user_studs`
--


--
-- Table structure for table `llx_overwrite_trans`
--

CREATE TABLE `llx_overwrite_trans` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `entity` int NOT NULL DEFAULT '1',
  `lang` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transkey` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transvalue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_overwrite_trans` (`entity`,`lang`,`transkey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_overwrite_trans`
--


--
-- Table structure for table `llx_paiedolibarr_paies`
--

CREATE TABLE `llx_paiedolibarr_paies` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_user` int DEFAULT '0',
  `ref` varchar(255) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `period` date DEFAULT NULL,
  `salairebrut` double(24,4) DEFAULT '0.0000',
  `salairebimpo` double(24,4) DEFAULT '0.0000',
  `retenus` double(24,4) DEFAULT '0.0000',
  `salairenet` double(24,4) DEFAULT '0.0000',
  `netapayer` double(24,4) DEFAULT '0.0000',
  `comment` varchar(755) DEFAULT NULL,
  `datepay` date DEFAULT NULL,
  `mode_reglement_id` int DEFAULT NULL,
  `matricule` varchar(10) DEFAULT NULL,
  `situation_f` varchar(5) DEFAULT '0',
  `certificat` varchar(255) DEFAULT NULL,
  `nbrenfants` int DEFAULT NULL,
  `nbdaywork` int DEFAULT NULL,
  `fk_author` int DEFAULT NULL,
  `fk_lastedit` int DEFAULT NULL,
  `tms` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `entity` int NOT NULL DEFAULT '1',
  `worksite` varchar(255) DEFAULT NULL,
  `nbdayabsence` int DEFAULT NULL,
  `fk_salary` int DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `unique_paie` (`fk_user`,`period`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `llx_paiedolibarr_paies`
--


--
-- Table structure for table `llx_paiedolibarr_paies_extrafields`
--

CREATE TABLE `llx_paiedolibarr_paies_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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `llx_paiedolibarr_paies_extrafields`
--


--
-- Table structure for table `llx_paiedolibarr_paiesrules`
--

CREATE TABLE `llx_paiedolibarr_paiesrules` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_paie` int DEFAULT NULL,
  `numero` varchar(255) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `category` varchar(40) DEFAULT NULL,
  `amounttype` varchar(10) DEFAULT 'FIX',
  `amount` double(24,4) DEFAULT '0.0000',
  `taux` double(24,4) DEFAULT '0.0000',
  `formule_base` text,
  `formule_taux` text,
  `total` double(24,4) DEFAULT '0.0000',
  `formule` text,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `unique_paiecode` (`fk_paie`,`code`),
  CONSTRAINT `uk_fk_paie` FOREIGN KEY (`fk_paie`) REFERENCES `llx_paiedolibarr_paies` (`rowid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `llx_paiedolibarr_paiesrules`
--


--
-- Table structure for table `llx_paiedolibarr_rules`
--

CREATE TABLE `llx_paiedolibarr_rules` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `numero` varchar(255) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `category` varchar(40) DEFAULT NULL,
  `amounttype` varchar(10) DEFAULT 'FIX',
  `showdefault` smallint DEFAULT '0',
  `amount` double(24,4) DEFAULT '0.0000',
  `taux` double(24,4) DEFAULT '0.0000',
  `ordercalcul` int DEFAULT '0',
  `formule_base` text,
  `formule_taux` text,
  `formule` text,
  `total` double(24,4) DEFAULT '0.0000',
  `showcumul` int DEFAULT '0',
  `entity` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `unique_code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `llx_paiedolibarr_rules`
--


--
-- Table structure for table `llx_paiedolibarr_salaryscall`
--

CREATE TABLE `llx_paiedolibarr_salaryscall` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `degre` int NOT NULL,
  `year` int NOT NULL,
  `amount` double(24,4) DEFAULT '0.0000',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `llx_paiedolibarr_salaryscall`
--


--
-- Table structure for table `llx_paiement`
--

CREATE TABLE `llx_paiement` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ref_ext` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ext_payment_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ext_payment_site` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `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',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=176 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_paiement`
--

INSERT INTO `llx_paiement` (`rowid`, `ref`, `ref_ext`, `entity`, `datec`, `tms`, `datep`, `amount`, `multicurrency_amount`, `fk_paiement`, `num_paiement`, `note`, `ext_payment_id`, `ext_payment_site`, `fk_bank`, `fk_user_creat`, `fk_user_modif`, `statut`, `fk_export_compta`, `pos_change`) VALUES (2,'PAY2109-0002','',1,'2021-09-03 17:42:33','2021-09-03 17:42:34','2021-09-03 12:00:00',86.80000000,86.80000000,4,'','',NULL,NULL,4,3,NULL,0,0,0.00000000),(3,'PAY2109-0003','',1,'2021-09-06 15:19:18','2021-09-06 15:19:19','2021-09-06 12:00:00',43.40000000,43.40000000,2,'','',NULL,NULL,5,3,NULL,0,0,0.00000000),(4,'PAY2109-0004','',1,'2021-09-09 06:48:38','2021-09-09 06:48:39','2021-09-09 12:00:00',1323.70000000,1323.70000000,2,'','',NULL,NULL,6,3,NULL,0,0,0.00000000),(5,'PAY2109-0005','',1,'2021-09-12 18:20:41','2021-09-12 18:20:42','2021-09-10 12:00:00',4394.25000000,4394.25000000,2,'','',NULL,NULL,7,3,NULL,0,0,0.00000000),(6,'PAY2109-0006','',1,'2021-09-13 23:00:41','2021-09-13 23:00:43','2021-09-14 12:00:00',781.20000000,781.20000000,2,'','',NULL,NULL,8,3,NULL,0,0,0.00000000),(9,'PAY2110-0007','',1,'2021-10-06 00:27:14','2021-10-06 00:27:14','2021-10-04 12:00:00',108.50000000,108.50000000,2,'','',NULL,NULL,11,3,NULL,0,0,0.00000000),(11,'PAY2108-0008','',1,'2021-10-09 04:51:14','2021-10-09 04:51:14','2021-08-10 12:00:00',520.80000000,520.80000000,2,'','',NULL,NULL,14,3,NULL,0,0,0.00000000),(12,'PAY2110-0009','',1,'2021-10-15 17:18:22','2021-10-15 17:18:23','2021-10-14 12:00:00',368.90000000,368.90000000,2,'','',NULL,NULL,15,3,NULL,0,0,0.00000000),(13,'PAY2110-0010','',1,'2021-10-22 14:31:59','2021-10-22 14:31:59','2021-10-17 12:00:00',43.40000000,43.40000000,2,'','',NULL,NULL,16,2,NULL,0,0,0.00000000),(14,'PAY2110-0011','',1,'2021-10-28 00:08:27','2021-10-28 00:08:28','2021-10-22 12:00:00',21.70000000,21.70000000,2,'','',NULL,NULL,17,3,NULL,0,0,0.00000000),(15,'PAY2111-0012','',1,'2021-11-05 13:14:57','2021-11-05 13:14:59','2021-11-05 12:00:00',2343.60000000,2343.60000000,2,'','',NULL,NULL,18,3,NULL,0,0,0.00000000),(16,'PAY2111-0013','',1,'2021-11-22 17:37:56','2021-11-22 17:37:57','2021-11-22 12:00:00',1063.30000000,1063.30000000,2,'','',NULL,NULL,19,3,NULL,0,0,0.00000000),(17,'PAY2111-0014','',1,'2021-11-22 18:40:14','2021-11-22 18:40:15','2021-11-22 12:00:00',43.40000000,43.40000000,2,'','',NULL,NULL,20,3,NULL,0,0,0.00000000),(20,'PAY2112-0015','',1,'2022-01-03 16:36:37','2022-01-03 16:36:37','2021-12-10 12:00:00',1692.60000000,1692.60000000,2,'','',NULL,NULL,23,3,NULL,0,0,0.00000000),(21,'PAY2201-0016','',1,'2022-01-06 21:08:29','2022-01-06 21:08:29','2022-01-05 12:00:00',86.80000000,86.80000000,2,'','',NULL,NULL,24,3,NULL,0,0,0.00000000),(22,'PAY2201-0017','',1,'2022-01-22 15:02:03','2022-01-22 15:02:04','2022-01-12 12:00:00',3623.90000000,3623.90000000,2,'','',NULL,NULL,25,3,NULL,0,0,0.00000000),(23,'PAY2201-0018','',1,'2022-01-28 15:20:22','2022-01-28 15:20:23','2022-01-26 12:00:00',97.65000000,97.65000000,2,'','',NULL,NULL,26,3,NULL,0,0,0.00000000),(25,'PAY2202-0019','',1,'2022-02-04 15:56:51','2022-02-04 15:56:51','2022-02-03 12:00:00',3255.00000000,3255.00000000,2,'','',NULL,NULL,28,3,NULL,0,0,0.00000000),(26,'PAY2202-0020','',1,'2022-02-19 14:45:38','2022-02-19 14:45:39','2022-02-17 12:00:00',97.65000000,97.65000000,2,'','',NULL,NULL,29,3,NULL,0,0,0.00000000),(27,'PAY2202-0021','',1,'2022-02-22 20:04:21','2022-02-22 20:04:22','2022-02-21 12:00:00',43.40000000,43.40000000,2,'','',NULL,NULL,30,2,NULL,0,0,0.00000000),(29,'PAY2203-0022','',1,'2022-03-03 16:43:27','2022-03-03 16:43:28','2022-03-03 12:00:00',3255.00000000,3255.00000000,2,'','',NULL,NULL,32,3,NULL,0,0,0.00000000),(30,'PAY2203-0023','',1,'2022-03-30 14:14:19','2022-03-30 14:14:21','2022-03-08 12:00:00',32.55000000,32.55000000,2,'','',NULL,NULL,33,3,NULL,0,0,0.00000000),(31,'PAY2204-0024','',1,'2022-04-05 13:17:39','2022-04-05 13:17:40','2022-04-05 12:00:00',3255.00000000,3255.00000000,2,'','',NULL,NULL,34,3,NULL,0,0,0.00000000),(32,'PAY2204-0025','',1,'2022-04-21 23:33:07','2022-04-21 23:33:07','2022-04-21 12:00:00',86.80000000,86.80000000,2,'','',NULL,NULL,35,3,NULL,0,0,0.00000000),(33,'PAY2204-0026','',1,'2022-04-22 19:22:07','2022-04-22 19:22:08','2022-04-22 12:00:00',2343.60000000,2343.60000000,2,'','',NULL,NULL,36,3,NULL,0,0,0.00000000),(34,'PAY2205-0027','',1,'2022-05-03 16:29:56','2022-05-03 16:29:57','2022-05-03 12:00:00',3255.00000000,3255.00000000,2,'','',NULL,NULL,37,3,NULL,0,0,0.00000000),(35,'PAY2205-0028','',1,'2022-05-19 13:42:46','2022-05-19 13:42:47','2022-05-17 12:00:00',86.80000000,86.80000000,2,'','',NULL,NULL,38,3,NULL,0,0,0.00000000),(36,'PAY2206-0029','',1,'2022-06-28 13:11:48','2022-06-28 13:11:48','2022-06-03 12:00:00',3255.00000000,3255.00000000,2,'','',NULL,NULL,39,3,NULL,0,0,0.00000000),(37,'PAY2207-0030','',1,'2022-07-20 14:06:06','2022-07-20 14:06:07','2022-07-05 12:00:00',3255.00000000,3255.00000000,2,'','',NULL,NULL,40,3,NULL,0,0,0.00000000),(38,'PAY2208-0031','',1,'2022-08-01 10:54:12','2022-08-01 10:54:13','2022-08-01 12:00:00',260.40000000,260.40000000,2,'','',NULL,NULL,41,3,NULL,0,0,0.00000000),(39,'PAY2208-0032','',1,'2022-08-04 16:26:25','2022-08-04 16:26:26','2022-08-03 12:00:00',3255.00000000,3255.00000000,2,'','',NULL,NULL,42,3,NULL,0,0,0.00000000),(41,'PAY2208-0033','',1,'2022-08-05 13:27:31','2022-08-05 13:27:32','2022-08-05 12:00:00',651.00000000,651.00000000,7,'9336692 971000002908 619007105823','',NULL,NULL,44,3,NULL,0,0,0.00000000),(42,'PAY2208-0034','',1,'2022-08-31 07:03:54','2022-08-31 07:03:55','2022-08-30 12:00:00',217.00000000,217.00000000,2,'','',NULL,NULL,45,3,NULL,0,0,0.00000000),(43,'PAY2209-0035','',1,'2022-09-05 16:49:42','2022-09-05 16:49:42','2022-09-05 12:00:00',3255.00000000,3255.00000000,2,'','',NULL,NULL,46,3,NULL,0,0,0.00000000),(44,'PAY2209-0036','',1,'2022-09-30 17:12:07','2022-09-30 17:12:11','2022-09-30 12:00:00',1291.15000000,1291.15000000,2,'','',NULL,NULL,47,3,NULL,0,0,0.00000000),(45,'PAY2210-0037','',1,'2022-10-04 14:38:30','2022-10-04 14:38:30','2022-10-04 12:00:00',3255.00000000,3255.00000000,2,'','',NULL,NULL,48,3,NULL,0,0,0.00000000),(46,'PAY2210-0038','',1,'2022-10-27 15:29:05','2022-10-27 15:29:07','2022-10-24 12:00:00',360.76000000,360.76000000,2,'','',NULL,NULL,49,3,NULL,0,0,0.00000000),(47,'PAY2211-0039','',1,'2022-11-07 09:10:21','2022-11-07 08:10:21','2022-11-03 17:00:00',3255.00000000,3255.00000000,2,'','',NULL,NULL,50,3,NULL,0,0,0.00000000),(48,'PAY2211-0040','',1,'2022-11-07 09:38:00','2022-11-07 08:38:00','2022-11-07 17:00:00',2582.30000000,2582.30000000,2,'','',NULL,NULL,51,3,NULL,0,0,0.00000000),(49,'PAY2211-0041','',1,'2022-11-30 15:53:12','2022-11-30 14:53:12','2022-11-30 17:00:00',3255.00000000,3255.00000000,2,'','',NULL,NULL,159,3,NULL,0,0,0.00000000),(50,'PAY2212-0042','',1,'2022-12-07 20:49:39','2022-12-07 19:49:39','2022-12-05 17:00:00',3255.00000000,3255.00000000,2,'','',NULL,NULL,160,3,NULL,0,0,0.00000000),(52,'PAY2212-0043','',1,'2022-12-21 19:24:39','2022-12-21 18:24:39','2022-12-20 17:00:00',5487.39000000,5487.39000000,7,'','',NULL,NULL,162,3,NULL,0,0,0.00000000),(53,'PAY2302-0044','',1,'2023-02-20 14:11:22','2023-02-20 13:11:22','2023-02-17 17:00:00',3255.00000000,3255.00000000,2,'','',NULL,NULL,163,3,NULL,0,0,0.00000000),(54,'PAY2212-0045','',1,'2023-03-08 18:06:00','2023-03-08 17:06:01','2022-12-27 17:00:00',923.34000000,923.34000000,2,'','',NULL,NULL,164,3,NULL,0,0,0.00000000),(55,'PAY2308-0046','',1,'2023-08-28 20:12:59','2023-08-28 18:12:59','2023-08-26 18:00:00',549.00000000,549.00000000,2,'','',NULL,NULL,165,3,NULL,0,0,0.00000000),(56,'PAY2301-0047','',1,'2024-03-09 12:17:08','2024-03-09 16:17:08','2023-01-17 12:00:00',5.43000000,5.43000000,2,'','',NULL,NULL,168,3,NULL,0,0,0.00000000),(57,'PAY2212-0048','',1,'2024-04-02 09:18:30','2024-04-02 13:18:31','2022-12-29 12:00:00',32.55000000,32.55000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(58,'PAY2212-0049','',1,'2024-04-02 09:18:31','2024-04-02 13:18:31','2022-12-29 12:00:00',82.46000000,82.46000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(59,'PAY2301-0050','',1,'2024-04-02 09:19:35','2024-04-02 13:19:35','2023-01-16 12:00:00',59.68000000,59.68000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(61,'PAY2304-0052','',1,'2024-04-02 09:30:50','2024-04-02 13:30:50','2023-04-14 12:00:00',410.13000000,410.13000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(62,'PAY2403-0053','',1,'2024-04-02 11:08:18','2024-04-02 15:08:18','2024-03-20 12:00:00',668.36000000,668.36000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(63,'PAY2403-0054','',1,'2024-04-02 11:08:19','2024-04-02 15:08:19','2024-03-20 12:00:00',937.45000000,937.45000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(64,'PAY2403-0055','',1,'2024-04-02 11:10:13','2024-04-02 15:10:13','2024-03-12 12:00:00',3385.20000000,3385.20000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(65,'PAY2404-0056','',1,'2024-04-02 11:10:57','2024-04-02 15:10:57','2024-04-02 12:00:00',288.00000000,288.00000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(66,'PAY2403-0057','',1,'2024-04-02 11:37:44','2024-04-02 15:37:44','2024-03-15 12:00:00',254.98000000,254.98000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(67,'PAY2306-0058','',1,'2024-04-02 11:44:51','2024-04-02 15:44:51','2023-06-29 12:00:00',439.43000000,439.43000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(68,'PAY2306-0059','',1,'2024-04-02 11:44:52','2024-04-02 15:44:52','2023-06-29 12:00:00',59.68000000,59.68000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(69,'PAY2309-0060','',1,'2024-04-02 11:45:50','2024-04-02 15:45:50','2023-09-28 12:00:00',133.46000000,133.46000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(70,'PAY2401-0061','',1,'2024-04-02 11:49:06','2024-04-02 15:49:06','2024-01-08 12:00:00',3255.00000000,3255.00000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(71,'PAY2402-0062','',1,'2024-04-02 11:50:13','2024-04-02 15:50:13','2024-02-07 12:00:00',3385.20000000,3385.20000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(72,'PAY2305-0063','',1,'2024-04-02 11:54:19','2024-04-02 15:54:19','2023-05-15 12:00:00',150.82000000,150.82000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(73,'PAY2305-0064','',1,'2024-04-02 11:54:19','2024-04-02 15:54:19','2023-05-15 12:00:00',747.57000000,747.57000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(74,'PAY2309-0065','',1,'2024-04-02 11:55:36','2024-04-02 15:55:36','2023-09-19 12:00:00',5126.63000000,5126.63000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(75,'PAY2312-0066','',1,'2024-04-02 11:56:17','2024-04-02 15:56:17','2023-12-22 12:00:00',3906.00000000,3906.00000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(76,'PAY2306-0067','',1,'2024-04-02 11:57:22','2024-04-02 15:57:22','2023-06-14 12:00:00',544.13000000,544.13000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(77,'PAY2309-0068','',1,'2024-04-02 12:00:02','2024-04-02 16:00:02','2023-09-18 12:00:00',54.25000000,54.25000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(78,'PAY2312-0069','',1,'2024-04-02 12:02:01','2024-04-02 16:02:01','2023-12-15 12:00:00',54.24000000,54.24000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(79,'PAY2311-0070','',1,'2024-04-02 12:02:36','2024-04-02 16:02:36','2023-11-30 12:00:00',421.85000000,421.85000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(80,'PAY2309-0071','',1,'2024-04-02 12:03:23','2024-04-02 16:03:23','2023-09-01 12:00:00',43.94000000,43.94000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(81,'PAY2305-0072','',1,'2024-04-02 12:05:41','2024-04-02 16:05:41','2023-05-26 12:00:00',96.57000000,96.57000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(82,'PAY2305-0073','',1,'2024-04-02 12:05:41','2024-04-02 16:05:41','2023-05-26 12:00:00',94.40000000,94.40000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(83,'PAY2309-0074','',1,'2024-04-02 12:06:34','2024-04-02 16:06:34','2023-09-18 12:00:00',54.25000000,54.25000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(84,'PAY2311-0075','',1,'2024-04-02 12:08:23','2024-04-02 16:08:23','2023-11-01 12:00:00',48.83000000,48.83000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(85,'PAY2311-0076','',1,'2024-04-02 12:08:23','2024-04-02 16:08:23','2023-11-01 12:00:00',133.46000000,133.46000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(86,'PAY2303-0077','',1,'2024-04-02 12:11:42','2024-04-02 16:11:42','2023-03-22 12:00:00',74.87000000,74.87000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(87,'PAY2303-0078','',1,'2024-04-02 12:11:42','2024-04-02 16:11:42','2023-03-22 12:00:00',32.55000000,32.55000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(88,'PAY2306-0079','',1,'2024-04-02 12:12:03','2024-04-02 16:12:03','2023-06-05 12:00:00',5209.63000000,5209.63000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(89,'PAY2306-0080','',1,'2024-04-02 12:12:31','2024-04-02 16:12:31','2023-06-23 12:00:00',439.43000000,439.43000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(90,'PAY2309-0081','',1,'2024-04-02 12:12:52','2024-04-02 16:12:52','2023-09-15 12:00:00',325.50000000,325.50000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(91,'PAY2309-0082','',1,'2024-04-02 12:12:52','2024-04-02 16:12:52','2023-09-15 12:00:00',225.20000000,225.20000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(92,'PAY2311-0083','',1,'2024-04-02 12:13:22','2024-04-02 16:13:22','2023-11-22 12:00:00',10.85000000,10.85000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(93,'PAY2401-0084','',1,'2024-04-02 12:13:42','2024-04-02 16:13:42','2024-01-09 12:00:00',323.34000000,323.34000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(94,'PAY2305-0085','',1,'2024-04-02 12:15:24','2024-04-02 16:15:24','2023-05-02 12:00:00',19.53000000,19.53000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(95,'PAY2304-0086','',1,'2024-04-02 12:16:49','2024-04-02 16:16:49','2023-04-03 12:00:00',3255.00000000,3255.00000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(96,'PAY2404-0087','',1,'2024-04-02 12:22:34','2024-04-02 16:59:24','2024-04-03 12:00:00',3255.00000000,3255.00000000,2,'',NULL,NULL,NULL,0,3,3,0,0,0.00000000),(97,'PAY2311-0088','',1,'2024-04-02 12:25:49','2024-04-02 16:25:49','2023-11-16 12:00:00',133.46000000,133.46000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(98,'PAY2310-0089','',1,'2024-04-02 12:27:15','2024-04-02 16:27:15','2023-10-04 12:00:00',325.50000000,325.50000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(99,'PAY2301-0090','',1,'2024-04-02 12:27:53','2024-04-02 16:27:53','2023-01-17 12:00:00',5.43000000,5.43000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(100,'PAY2310-0091','',1,'2024-04-02 12:30:10','2024-04-02 16:30:10','2023-10-27 12:00:00',74.87000000,74.87000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(101,'PAY2305-0092','',1,'2024-04-02 12:36:34','2024-04-02 16:36:34','2023-05-08 12:00:00',3255.00000000,3255.00000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(102,'PAY2306-0093','',1,'2024-04-02 12:37:03','2024-04-02 16:37:03','2023-06-07 12:00:00',3255.00000000,3255.00000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(103,'PAY2307-0094','',1,'2024-04-02 12:37:23','2024-04-02 16:37:23','2023-07-06 12:00:00',3255.00000000,3255.00000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(104,'PAY2308-0095','',1,'2024-04-02 12:37:41','2024-04-02 16:37:41','2023-08-08 12:00:00',3255.00000000,3255.00000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(105,'PAY2309-0096','',1,'2024-04-02 12:38:00','2024-04-02 16:38:00','2023-09-06 12:00:00',3255.00000000,3255.00000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(106,'PAY2310-0097','',1,'2024-04-02 12:38:23','2024-04-02 16:38:23','2023-10-06 12:00:00',3255.00000000,3255.00000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(107,'PAY2311-0098','',1,'2024-04-02 12:38:47','2024-04-02 16:38:47','2023-11-08 12:00:00',3255.00000000,3255.00000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(108,'PAY2312-0099','',1,'2024-04-02 12:39:19','2024-04-02 16:39:19','2023-12-06 12:00:00',3255.00000000,3255.00000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(109,'PAY2404-0100','',1,'2024-04-15 06:27:06','2024-04-15 10:27:06','2024-04-15 12:00:00',84.63000000,84.63000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(110,'PAY2404-0101','',1,'2024-04-15 06:27:07','2024-04-15 10:27:07','2024-04-15 12:00:00',573.97000000,573.97000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(111,'PAY2404-0102','',1,'2024-04-30 01:51:48','2024-04-30 05:51:49','2024-04-29 12:00:00',96.57000000,96.57000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(112,'PAY2404-0103','',1,'2024-04-30 01:51:49','2024-04-30 05:51:49','2024-04-29 12:00:00',38.34000000,38.34000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(113,'PAY2405-0104','',1,'2024-05-03 03:38:57','2024-05-03 07:38:57','2024-05-03 12:00:00',3385.20000000,3385.20000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(114,'PAY2405-0105','',1,'2024-05-24 19:38:24','2024-05-24 23:38:24','2024-05-20 12:00:00',3385.20000000,3385.20000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(115,'PAY2406-0106','',1,'2024-06-04 08:12:05','2024-06-04 12:12:05','2024-06-04 12:00:00',877.12000000,877.12000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(116,'PAY2406-0107','',1,'2024-06-06 03:23:36','2024-06-06 07:23:36','2024-06-06 12:00:00',3385.20000000,3385.20000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(117,'PAY2406-0108','',1,'2024-06-13 18:11:45','2024-06-13 22:11:45','2024-06-12 12:00:00',128.03000000,128.03000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(118,'PAY2407-0109','',1,'2024-07-01 20:01:42','2024-07-02 00:01:42','2024-07-01 12:00:00',31.47000000,31.47000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(119,'PAY2407-0110','',1,'2024-07-05 12:12:06','2024-07-05 16:12:06','2024-07-02 12:00:00',313.57000000,313.57000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(120,'PAY2407-0111','',1,'2024-07-17 22:38:03','2024-07-18 02:38:03','2024-07-17 12:00:00',126.96000000,126.96000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(121,'PAY2407-0112','',1,'2024-07-17 22:39:33','2024-07-18 02:39:33','2024-07-17 12:00:00',3385.20000000,3385.20000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(122,'PAY2407-0113','',1,'2024-07-17 22:41:30','2024-07-18 02:41:30','2024-07-12 12:00:00',313.57000000,313.57000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(123,'PAY2407-0114','',1,'2024-07-31 06:54:06','2024-07-31 10:54:06','2024-07-31 12:00:00',304.89000000,304.89000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(125,'PAY2408-0115','',1,'2024-08-08 11:53:53','2024-08-08 15:53:53','2024-08-08 12:00:00',307.64000000,307.64000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(126,'PAY2408-0116','',1,'2024-08-13 03:12:09','2024-08-13 07:12:09','2024-08-13 12:00:00',3385.20000000,3385.20000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(127,'PAY2408-0117','',1,'2024-08-13 03:12:39','2024-08-13 07:12:39','2024-08-13 12:00:00',118.27000000,118.27000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(128,'PAY2408-0118','',1,'2024-08-16 11:24:38','2024-08-16 15:24:38','2024-08-16 12:00:00',313.57000000,313.57000000,2,'','',NULL,NULL,0,3,NULL,0,0,0.00000000),(129,'PAY2408-0119','',1,'2024-08-28 12:16:36','2024-08-28 16:16:36','2024-08-27 12:00:00',88.00000000,88.00000000,6,'','',NULL,NULL,170,3,NULL,0,0,0.00000000),(130,'PAY2408-0120','',1,'2024-08-29 10:04:06','2024-08-29 14:04:06','2024-08-29 12:00:00',99.90000000,99.90000000,2,'','',NULL,NULL,171,3,NULL,0,0,0.00000000),(131,'PAY2408-0121','',1,'2024-08-30 00:39:09','2024-08-30 04:39:09','2024-08-30 12:00:00',90.00000000,90.00000000,6,'','',NULL,NULL,172,3,NULL,0,0,0.00000000),(132,'PAY2408-0122','',1,'2024-08-30 10:01:04','2024-08-30 14:01:04','2024-08-30 12:00:00',313.57000000,313.57000000,2,'','',NULL,NULL,173,3,NULL,0,0,0.00000000),(133,'PAY2408-0123','',1,'2024-09-01 12:13:32','2024-09-01 16:13:32','2024-08-31 12:00:00',20.00000000,20.00000000,6,'','',NULL,NULL,174,3,NULL,0,0,0.00000000),(134,'PAY2409-0124','',1,'2024-09-05 06:54:29','2024-09-05 10:54:29','2024-09-05 12:00:00',187.71000000,187.71000000,2,'','',NULL,NULL,175,3,NULL,0,0,0.00000000),(135,'PAY2409-0125','',1,'2024-09-05 06:54:52','2024-09-05 10:54:53','2024-09-05 12:00:00',149.74000000,149.74000000,2,'','',NULL,NULL,176,3,NULL,0,0,0.00000000),(136,'PAY2409-0126','',1,'2024-09-10 06:27:40','2024-09-10 10:27:40','2024-09-10 12:00:00',3385.20000000,3385.20000000,2,'','',NULL,NULL,177,3,NULL,0,0,0.00000000),(137,'PAY2410-0127','',1,'2024-10-11 03:01:38','2024-10-11 07:01:38','2024-10-09 12:00:00',3385.20000000,3385.20000000,2,'','',NULL,NULL,179,3,NULL,0,0,0.00000000),(138,'PAY2410-0128','',1,'2024-10-16 06:05:00','2024-10-16 10:05:00','2024-10-16 12:00:00',298.00000000,298.00000000,2,'','',NULL,NULL,180,3,NULL,0,0,0.00000000),(139,'PAY2410-0129','',1,'2024-10-17 21:35:06','2024-10-18 01:35:06','2024-10-16 12:00:00',4638.38000000,4638.38000000,2,'','',NULL,NULL,181,3,NULL,0,0,0.00000000),(140,'PAY2410-0130','',1,'2024-10-23 07:59:36','2024-10-23 11:59:37','2024-10-23 12:00:00',96.57000000,96.57000000,2,'','',NULL,NULL,182,3,NULL,0,0,0.00000000),(141,'PAY2410-0131','',1,'2024-10-29 07:45:48','2024-10-29 11:45:49','2024-10-29 12:00:00',53.17000000,53.17000000,2,'','',NULL,NULL,183,3,NULL,0,0,0.00000000),(142,'PAY2411-0132','',1,'2024-11-01 08:51:44','2024-11-01 12:51:45','2024-11-01 12:00:00',3385.20000000,3385.20000000,2,'','',NULL,NULL,184,3,NULL,0,0,0.00000000),(143,'PAY2411-0133','',1,'2024-11-07 12:54:07','2024-11-07 16:54:07','2024-11-04 12:00:00',48.28000000,48.28000000,2,'','',NULL,NULL,185,3,NULL,0,0,0.00000000),(144,'PAY2411-0134','',1,'2024-11-25 10:50:14','2024-11-25 10:50:14','2024-11-23 16:00:00',269.62000000,269.62000000,2,'','',NULL,NULL,186,3,NULL,0,0,0.00000000),(145,'PAY2411-0135','',1,'2024-11-25 10:50:47','2024-11-25 10:50:47','2024-11-25 16:00:00',162.75000000,162.75000000,2,'','',NULL,NULL,187,3,NULL,0,0,0.00000000),(146,'PAY2412-0136','',1,'2024-12-04 17:17:15','2024-12-04 17:17:16','2024-12-02 16:00:00',43.40000000,43.40000000,2,'','',NULL,NULL,188,3,NULL,0,0,0.00000000),(147,'PAY2412-0137','',1,'2024-12-11 08:26:00','2024-12-11 08:26:00','2024-12-10 16:00:00',59.00000000,59.00000000,2,'','',NULL,NULL,189,3,NULL,0,0,0.00000000),(148,'PAY2412-0138','',1,'2024-12-13 17:13:42','2024-12-13 17:13:42','2024-12-13 16:00:00',41.04000000,41.04000000,2,'','',NULL,NULL,190,3,NULL,0,0,0.00000000),(149,'PAY2412-0139','',1,'2024-12-28 21:05:50','2024-12-28 21:05:51','2024-12-18 16:00:00',3385.20000000,3385.20000000,2,'','',NULL,NULL,191,3,NULL,0,0,0.00000000),(150,'PAY2412-0140','',1,'2024-12-28 21:06:44','2024-12-28 21:06:44','2024-12-27 16:00:00',178.00000000,178.00000000,2,'','',NULL,NULL,192,3,NULL,0,0,0.00000000),(151,'PAY2412-0141','',1,'2024-12-28 21:10:18','2024-12-28 21:10:18','2024-12-24 16:00:00',64.32000000,64.32000000,107,'','',NULL,NULL,193,3,NULL,0,0,0.00000000),(152,'PAY2412-0142','',1,'2024-12-30 08:29:33','2024-12-30 08:29:34','2024-12-30 16:00:00',3385.20000000,3385.20000000,2,'','',NULL,NULL,194,3,NULL,0,0,0.00000000),(153,'PAY2501-0143','',1,'2025-01-16 11:12:00','2025-01-16 11:12:01','2025-01-16 16:00:00',66.00000000,66.00000000,2,'','',NULL,NULL,195,3,NULL,0,0,0.00000000),(154,'PAY2501-0144','',1,'2025-01-30 23:15:54','2025-01-30 23:15:54','2025-01-30 16:00:00',29.57000000,29.57000000,2,'','',NULL,NULL,196,3,NULL,0,0,0.00000000),(155,'PAY2501-0145','',1,'2025-02-10 23:22:35','2025-02-10 23:22:36','2025-01-25 16:00:00',29.00000000,29.00000000,106,'','',NULL,NULL,197,3,NULL,0,0,0.00000000),(157,'PAY2502-0147','',1,'2025-02-25 10:50:16','2025-02-25 10:50:17','2025-02-25 16:00:00',313.32000000,313.32000000,2,'','',NULL,NULL,199,3,NULL,0,0,0.00000000),(158,'PAY2502-0148','',1,'2025-02-26 10:34:54','2025-02-26 10:34:54','2025-02-25 16:00:00',29.00000000,29.00000000,106,'','',NULL,NULL,200,3,NULL,0,0,0.00000000),(161,'PAY2502-0150','',1,'2025-02-27 13:55:52','2025-02-27 13:55:52','2025-02-27 16:00:00',50.00000000,50.00000000,2,'','',NULL,NULL,203,3,NULL,0,0,0.00000000),(162,'PAY2502-0151','',1,'2025-02-27 14:04:29','2025-02-27 14:04:29','2025-02-27 16:00:00',50.00000000,50.00000000,2,'','',NULL,NULL,204,3,NULL,0,0,0.00000000),(163,'PAY2502-0152','',1,'2025-02-28 00:27:56','2025-02-28 00:27:56','2025-02-27 16:00:00',29.00000000,29.00000000,106,'','',NULL,NULL,205,3,NULL,0,0,0.00000000),(164,'PAY2502-0153','',1,'2025-02-28 00:28:34','2025-02-28 00:28:34','2025-02-27 16:00:00',29.00000000,29.00000000,106,'','',NULL,NULL,206,3,NULL,0,0,0.00000000),(165,'PAY2503-0154','',1,'2025-03-04 13:23:47','2025-03-04 13:23:47','2025-03-04 16:00:00',889.10000000,889.10000000,2,'','',NULL,NULL,207,3,NULL,0,0,0.00000000),(166,'PAY2503-0155','',1,'2025-03-10 18:20:40','2025-03-10 18:20:40','2025-03-10 12:00:00',4.50000000,4.50000000,2,'','',NULL,NULL,208,3,NULL,0,0,0.00000000),(167,'PAY2503-0156','',1,'2025-03-10 18:29:08','2025-03-10 18:29:08','2025-03-10 12:00:00',4.50000000,4.50000000,2,'','',NULL,NULL,209,3,NULL,0,0,0.00000000),(168,'PAY2503-0157','',1,'2025-03-11 22:15:45','2025-03-11 22:15:45','2025-03-11 16:00:00',100.00000000,100.00000000,2,'','',NULL,NULL,210,3,NULL,0,0,0.00000000),(169,'PAY2503-0158','',1,'2025-03-12 18:58:53','2025-03-12 18:58:53','2025-03-12 16:00:00',16.28000000,16.28000000,2,'','',NULL,NULL,211,3,NULL,0,0,0.00000000),(170,'PAY2503-0159','',1,'2025-03-12 19:04:59','2025-03-12 19:04:59','2025-03-12 16:00:00',70.00000000,70.00000000,107,'','',NULL,NULL,212,3,NULL,0,0,0.00000000),(171,'PAY2503-0160','',1,'2025-03-12 20:55:38','2025-03-12 20:55:38','2025-03-12 16:00:00',29.00000000,29.00000000,106,'','',NULL,NULL,213,3,NULL,0,0,0.00000000),(172,'PAY2503-0161','',1,'2025-03-14 06:19:07','2025-03-14 06:19:08','2025-03-11 16:00:00',29.00000000,29.00000000,106,'','',NULL,NULL,218,3,NULL,0,0,0.00000000),(173,'PAY2503-0162','',1,'2025-03-26 15:14:38','2025-03-26 15:14:38','2025-03-26 12:00:00',29.00000000,29.00000000,106,'','',NULL,NULL,223,3,NULL,0,0,0.00000000),(174,'PAY2503-0163','',1,'2025-03-29 04:29:47','2025-03-29 04:29:47','2025-03-27 16:00:00',29.00000000,29.00000000,106,'','',NULL,NULL,224,3,NULL,0,0,0.00000000),(175,'PAY2503-0164','',1,'2025-03-29 04:30:58','2025-03-29 04:30:58','2025-03-27 16:00:00',29.00000000,29.00000000,106,'','',NULL,NULL,225,3,NULL,0,0,0.00000000);

--
-- Table structure for table `llx_paiement_facture`
--

CREATE TABLE `llx_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_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 `llx_facture` (`rowid`),
  CONSTRAINT `fk_paiement_facture_fk_paiement` FOREIGN KEY (`fk_paiement`) REFERENCES `llx_paiement` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=180 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_paiement_facture`
--

INSERT INTO `llx_paiement_facture` (`rowid`, `fk_paiement`, `fk_facture`, `amount`, `multicurrency_code`, `multicurrency_tx`, `multicurrency_amount`) VALUES (3,3,3,43.40000000,NULL,1.00000000,43.40000000),(6,4,9,520.80000000,NULL,1.00000000,520.80000000),(7,5,6,4394.25000000,NULL,1.00000000,4394.25000000),(8,6,12,781.20000000,NULL,1.00000000,781.20000000),(11,9,13,108.50000000,NULL,1.00000000,108.50000000),(13,11,2,520.80000000,NULL,1.00000000,520.80000000),(14,12,15,368.90000000,NULL,1.00000000,368.90000000),(15,13,17,43.40000000,NULL,1.00000000,43.40000000),(17,15,16,2343.60000000,NULL,1.00000000,2343.60000000),(18,16,20,412.30000000,NULL,1.00000000,412.30000000),(19,16,21,651.00000000,NULL,1.00000000,651.00000000),(20,17,22,43.40000000,NULL,1.00000000,43.40000000),(23,20,23,1692.60000000,NULL,1.00000000,1692.60000000),(25,22,35,3623.90000000,NULL,1.00000000,3623.90000000),(26,23,36,97.65000000,NULL,1.00000000,97.65000000),(28,25,38,3255.00000000,NULL,1.00000000,3255.00000000),(29,26,42,97.65000000,NULL,1.00000000,97.65000000),(30,27,43,43.40000000,NULL,1.00000000,43.40000000),(32,29,44,3255.00000000,NULL,1.00000000,3255.00000000),(33,30,41,32.55000000,NULL,1.00000000,32.55000000),(34,31,46,3255.00000000,NULL,1.00000000,3255.00000000),(35,32,45,86.80000000,NULL,1.00000000,86.80000000),(36,33,37,2343.60000000,NULL,1.00000000,2343.60000000),(37,34,49,3255.00000000,NULL,1.00000000,3255.00000000),(38,35,48,86.80000000,NULL,1.00000000,86.80000000),(39,36,52,3255.00000000,NULL,1.00000000,3255.00000000),(40,37,54,3255.00000000,NULL,1.00000000,3255.00000000),(42,39,56,3255.00000000,NULL,1.00000000,3255.00000000),(44,41,47,651.00000000,NULL,1.00000000,651.00000000),(45,42,55,217.00000000,NULL,1.00000000,217.00000000),(46,43,58,3255.00000000,NULL,1.00000000,3255.00000000),(47,44,59,1291.15000000,NULL,1.00000000,1291.15000000),(49,46,63,360.76000000,NULL,1.00000000,360.76000000),(50,47,62,3255.00000000,NULL,1.00000000,3255.00000000),(51,48,64,2582.30000000,NULL,1.00000000,2582.30000000),(52,49,68,3255.00000000,NULL,1.00000000,3255.00000000),(53,50,69,3255.00000000,NULL,1.00000000,3255.00000000),(55,52,57,5487.39000000,NULL,1.00000000,5487.39000000),(56,53,79,3255.00000000,NULL,1.00000000,3255.00000000),(57,54,76,923.34000000,NULL,1.00000000,923.34000000),(58,55,105,549.00000000,NULL,1.00000000,549.00000000),(59,56,71,5.43000000,'EUR',1.00000000,5.43000000),(60,57,75,32.55000000,'EUR',1.00000000,32.55000000),(61,58,74,82.46000000,'EUR',1.00000000,82.46000000),(62,59,78,59.68000000,'EUR',1.00000000,59.68000000),(64,61,81,410.13000000,'EUR',1.00000000,410.13000000),(70,67,97,439.43000000,'EUR',1.00000000,439.43000000),(71,68,95,59.68000000,'EUR',1.00000000,59.68000000),(72,69,107,133.46000000,'EUR',1.00000000,133.46000000),(75,72,90,150.82000000,'EUR',1.00000000,150.82000000),(76,73,89,747.57000000,'EUR',1.00000000,747.57000000),(77,74,109,5126.63000000,'EUR',1.00000000,5126.63000000),(79,76,99,544.13000000,'EUR',1.00000000,544.13000000),(80,77,111,54.25000000,'EUR',1.00000000,54.25000000),(82,79,122,421.85000000,'EUR',1.00000000,421.85000000),(83,80,108,43.94000000,'EUR',1.00000000,43.94000000),(84,81,87,96.57000000,'EUR',1.00000000,96.57000000),(85,82,85,94.40000000,'EUR',1.00000000,94.40000000),(86,83,112,54.25000000,'EUR',1.00000000,54.25000000),(87,84,119,48.83000000,'EUR',1.00000000,48.83000000),(88,85,115,133.46000000,'EUR',1.00000000,133.46000000),(89,86,80,74.87000000,'EUR',1.00000000,74.87000000),(90,87,72,32.55000000,'EUR',1.00000000,32.55000000),(91,88,92,5209.63000000,'EUR',1.00000000,5209.63000000),(92,89,98,439.43000000,'EUR',1.00000000,439.43000000),(93,90,110,325.50000000,'EUR',1.00000000,325.50000000),(94,91,106,225.20000000,'EUR',1.00000000,225.20000000),(95,92,118,10.85000000,'EUR',1.00000000,10.85000000),(97,94,84,19.53000000,'EUR',1.00000000,19.53000000),(98,95,86,3255.00000000,'EUR',1.00000000,3255.00000000),(99,96,83,3255.00000000,'EUR',1.00000000,3255.00000000),(100,97,120,133.46000000,'EUR',1.00000000,133.46000000),(101,98,113,325.50000000,'EUR',1.00000000,325.50000000),(102,99,73,5.43000000,'EUR',1.00000000,5.43000000),(103,100,116,74.87000000,'EUR',1.00000000,74.87000000),(104,101,91,3255.00000000,'EUR',1.00000000,3255.00000000),(105,102,100,3255.00000000,'EUR',1.00000000,3255.00000000),(106,103,101,3255.00000000,'EUR',1.00000000,3255.00000000),(107,104,102,3255.00000000,'EUR',1.00000000,3255.00000000),(108,105,103,3255.00000000,'EUR',1.00000000,3255.00000000),(109,106,114,3255.00000000,'EUR',1.00000000,3255.00000000),(110,107,121,3255.00000000,'EUR',1.00000000,3255.00000000),(126,123,159,304.89000000,'EUR',1.00000000,304.89000000),(128,125,167,307.64000000,'EUR',1.00000000,307.64000000),(129,126,162,3385.20000000,'EUR',1.00000000,3385.20000000),(130,127,161,118.27000000,'EUR',1.00000000,118.27000000),(131,128,165,313.57000000,'EUR',1.00000000,313.57000000),(132,129,168,88.00000000,'EUR',1.00000000,88.00000000),(133,130,160,99.90000000,'EUR',1.00000000,99.90000000),(134,131,169,90.00000000,'EUR',1.00000000,90.00000000),(135,132,166,313.57000000,'EUR',1.00000000,313.57000000),(136,133,172,20.00000000,'EUR',1.00000000,20.00000000),(137,134,163,187.71000000,'EUR',1.00000000,187.71000000),(138,135,164,149.74000000,'EUR',1.00000000,149.74000000),(139,136,170,3385.20000000,'EUR',1.00000000,3385.20000000),(140,137,182,3385.20000000,'EUR',1.00000000,3385.20000000),(141,138,179,298.00000000,'EUR',1.00000000,298.00000000),(142,139,173,4638.38000000,'EUR',1.00000000,4638.38000000),(143,140,174,96.57000000,'EUR',1.00000000,96.57000000),(144,141,180,53.17000000,'EUR',1.00000000,53.17000000),(145,142,187,3385.20000000,'EUR',1.00000000,3385.20000000),(146,143,188,48.28000000,'EUR',1.00000000,48.28000000),(147,144,178,20.62000000,'EUR',1.00000000,20.62000000),(148,144,189,249.00000000,'EUR',1.00000000,249.00000000),(149,145,184,162.75000000,'EUR',1.00000000,162.75000000),(150,146,183,43.40000000,'EUR',1.00000000,43.40000000),(151,147,192,59.00000000,'EUR',1.00000000,59.00000000),(152,148,194,41.04000000,'EUR',1.00000000,41.04000000),(153,149,190,3385.20000000,'EUR',1.00000000,3385.20000000),(154,150,195,178.00000000,'EUR',1.00000000,178.00000000),(155,151,196,64.32000000,'EUR',1.00000000,64.32000000),(156,152,193,3385.20000000,'EUR',1.00000000,3385.20000000),(157,153,191,66.00000000,'EUR',1.00000000,66.00000000),(158,154,198,29.57000000,'EUR',1.00000000,29.57000000),(159,155,199,29.00000000,'EUR',1.00000000,29.00000000),(161,157,200,313.32000000,'EUR',1.00000000,313.32000000),(162,158,203,29.00000000,'EUR',1.00000000,29.00000000),(165,161,206,50.00000000,'EUR',1.00000000,50.00000000),(166,162,208,50.00000000,'EUR',1.00000000,50.00000000),(167,163,209,29.00000000,'EUR',1.00000000,29.00000000),(168,164,210,29.00000000,'EUR',1.00000000,29.00000000),(169,165,211,889.10000000,'EUR',1.00000000,889.10000000),(170,166,208,4.50000000,'EUR',1.00000000,4.50000000),(171,167,206,4.50000000,'EUR',1.00000000,4.50000000),(172,168,212,100.00000000,'EUR',1.00000000,100.00000000),(173,169,202,16.28000000,'EUR',1.00000000,16.28000000),(174,170,213,70.00000000,'EUR',1.00000000,70.00000000),(175,171,214,29.00000000,'EUR',1.00000000,29.00000000),(176,172,201,29.00000000,'EUR',1.00000000,29.00000000),(177,173,215,29.00000000,'EUR',1.00000000,29.00000000),(178,174,216,29.00000000,'EUR',1.00000000,29.00000000),(179,175,217,29.00000000,'EUR',1.00000000,29.00000000);

--
-- Table structure for table `llx_paiementcharge`
--

CREATE TABLE `llx_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_paiementcharge`
--


--
-- Table structure for table `llx_paiementfourn`
--

CREATE TABLE `llx_paiementfourn` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `fk_bank` int NOT NULL,
  `statut` smallint NOT NULL DEFAULT '0',
  `model_pdf` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_paiementfourn`
--


--
-- Table structure for table `llx_paiementfourn_facturefourn`
--

CREATE TABLE `llx_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_paiementfourn_facturefourn`
--


--
-- Table structure for table `llx_partnership`
--

CREATE TABLE `llx_partnership` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `ref` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '(PROV)',
  `status` smallint NOT NULL DEFAULT '0',
  `fk_soc` int DEFAULT NULL,
  `fk_member` int DEFAULT NULL,
  `email_partnership` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `date_creation` datetime NOT NULL,
  `fk_user_creat` int DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_user_modif` int DEFAULT NULL,
  `note_private` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `note_public` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `last_main_doc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `count_last_url_check_error` int DEFAULT '0',
  `last_check_backlink` datetime DEFAULT NULL,
  `import_key` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `model_pdf` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fk_type` int NOT NULL DEFAULT '0',
  `url_to_check` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ip` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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 `llx_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=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_partnership`
--


--
-- Table structure for table `llx_partnership_extrafields`
--

CREATE TABLE `llx_partnership_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_partnership_extrafields` (`fk_object`),
  KEY `idx_partnership_fk_object` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_partnership_extrafields`
--


--
-- Table structure for table `llx_payment_donation`
--

CREATE TABLE `llx_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ext_payment_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ext_payment_site` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_payment_donation`
--


--
-- Table structure for table `llx_payment_expensereport`
--

CREATE TABLE `llx_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_payment_expensereport`
--


--
-- Table structure for table `llx_payment_loan`
--

CREATE TABLE `llx_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note_private` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `note_public` text CHARACTER SET utf8mb4 COLLATE utf8mb4_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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_payment_loan`
--


--
-- Table structure for table `llx_payment_salary`
--

CREATE TABLE `llx_payment_salary` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `datesp` date DEFAULT NULL,
  `dateep` date DEFAULT NULL,
  `entity` int NOT NULL DEFAULT '1',
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_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 `llx_user` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_payment_salary`
--


--
-- Table structure for table `llx_payment_various`
--

CREATE TABLE `llx_payment_various` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `num_payment` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subledger_account` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fk_projet` int DEFAULT NULL,
  `entity` int NOT NULL DEFAULT '1',
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `fk_bank` int DEFAULT NULL,
  `fk_user_author` int DEFAULT NULL,
  `fk_user_modif` int DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_payment_various`
--

INSERT INTO `llx_payment_various` (`rowid`, `ref`, `num_payment`, `label`, `tms`, `datec`, `datep`, `datev`, `sens`, `amount`, `fk_typepayment`, `accountancy_code`, `subledger_account`, `fk_projet`, `entity`, `note`, `fk_bank`, `fk_user_author`, `fk_user_modif`) VALUES (1,NULL,'','Paiement divers','2022-11-20 23:50:58','2022-11-21 00:50:58','2021-10-12','2021-10-12',0,17.66000000,3,'','',0,1,NULL,52,3,NULL),(2,NULL,'','Paiement divers','2022-11-21 00:04:00','2022-11-21 01:04:00','2021-10-12','2021-10-12',0,15.50000000,3,'','',0,1,NULL,53,3,NULL),(3,NULL,'','Note de frais creation SASU EKWITECH','2022-11-21 00:18:50','2022-11-21 01:18:50','2021-10-13','2021-10-13',0,1250.00000000,2,'','',0,1,NULL,54,3,NULL),(4,NULL,'','Paiement AMAZON US','2022-11-21 00:32:25','2022-11-21 01:32:25','2021-10-25','2021-10-25',0,168.77000000,6,'','',0,1,NULL,55,3,NULL),(5,NULL,'','Paiement divers','2022-11-21 00:33:54','2022-11-21 01:33:54','2021-10-29','2021-10-29',0,1.09000000,3,'','',0,1,NULL,56,3,NULL),(6,NULL,'','Frais banquaires','2022-11-21 01:11:44','2022-11-21 02:11:44','2021-11-01','2021-11-01',0,46.80000000,3,'','',0,1,NULL,57,3,NULL),(7,NULL,'','Paiement NOVE','2022-11-21 01:12:26','2022-11-21 02:12:26','2021-11-04','2021-11-04',0,53.20000000,6,'','',0,1,NULL,58,3,NULL),(8,NULL,'','Paiement AVDS','2022-11-21 01:13:03','2022-11-21 02:13:03','2021-11-11','2021-11-11',0,2604.00000000,2,'','',0,1,NULL,59,3,NULL),(9,NULL,'','Frais 1&1','2022-11-21 01:13:29','2022-11-21 02:13:29','2021-11-25','2021-11-25',0,1.09000000,3,'','',0,1,NULL,60,3,NULL),(10,NULL,'','Remboursement AMAZON US','2022-11-21 01:14:50','2022-11-21 02:14:50','2021-11-09','2021-11-09',1,9.98000000,6,'','',0,1,NULL,61,3,NULL),(11,NULL,'','Frais banquaires','2022-11-21 01:21:29','2022-11-21 02:21:29','2021-12-01','2021-12-01',0,46.80000000,3,'','',0,1,NULL,62,3,NULL),(12,NULL,'','Paiement AVDS','2022-11-21 01:23:39','2022-11-21 02:23:39','2021-12-02','2021-12-02',0,2604.00000000,2,'','',0,1,NULL,63,3,NULL),(13,NULL,'','Paiement AVDS','2022-11-21 01:24:56','2022-11-21 02:24:56','2021-12-13','2021-12-13',0,2604.00000000,2,'','',0,1,NULL,64,3,NULL),(14,NULL,'','Paiement AVDS','2022-11-21 01:25:46','2022-11-21 02:25:46','2021-12-16','2021-12-16',0,148.91000000,6,'','',0,1,NULL,65,3,NULL),(15,NULL,'','Paiement TC DE GUADELOUPE','2022-11-21 01:27:27','2022-11-21 02:27:27','2021-12-20','2021-12-20',0,76.01000000,6,'','',0,1,NULL,66,3,NULL),(16,NULL,'','Frais 1&1','2022-11-21 01:28:09','2022-11-21 02:28:09','2021-12-25','2021-12-25',0,1.09000000,6,'','',0,1,NULL,67,3,NULL),(17,NULL,'','Remboursement AMAZON US','2022-11-21 02:18:32','2022-11-21 03:18:32','2022-01-02','2022-01-02',1,8.81000000,6,'','',0,1,NULL,68,3,NULL),(18,NULL,'','Frais banquaires','2022-11-21 02:19:21','2022-11-21 03:19:21','2022-01-03','2022-01-03',0,46.80000000,3,'','',0,1,NULL,69,3,NULL),(19,NULL,'','Paiement AVDS','2022-11-21 02:22:35','2022-11-21 03:22:35','2022-01-14','2022-01-14',0,3255.00000000,2,'','',0,1,NULL,70,3,NULL),(20,NULL,'','Frais 1&1','2022-11-21 02:23:07','2022-11-21 03:23:07','2022-01-25','2022-01-25',0,1.09000000,6,'','',0,1,NULL,71,3,NULL),(21,NULL,'','Frais bancaires','2022-11-21 02:29:34','2022-11-21 03:29:34','2022-02-01','2022-02-01',0,46.80000000,3,'','',0,1,NULL,72,3,NULL),(22,NULL,'','Paiement AMAZON US','2022-11-21 02:30:24','2022-11-21 03:30:24','2022-02-04','2022-02-04',0,122.11000000,6,'','',0,1,NULL,73,3,NULL),(23,NULL,'','Paiement AVDS','2022-11-21 02:31:15','2022-11-21 03:31:15','2022-02-07','2022-02-07',0,2604.00000000,2,'','',0,1,NULL,74,3,NULL),(24,NULL,'','Paiement FOURNIBUR','2022-11-21 02:32:04','2022-11-21 03:32:04','2022-02-23','2022-02-23',0,31.02000000,6,'','',0,1,NULL,75,3,NULL),(25,NULL,'','Paiement IONOS','2022-11-21 02:33:22','2022-11-21 03:33:22','2022-02-26','2022-02-26',0,1.09000000,6,'','',0,1,NULL,76,3,NULL),(26,NULL,'','Frais bancaires','2022-11-21 02:34:43','2022-11-21 03:34:43','2022-02-01','2022-02-01',0,46.80000000,3,'','',0,1,NULL,77,3,NULL),(27,NULL,'','Remboursement note de frais NESMOND','2022-11-21 02:46:20','2022-11-21 03:46:20','2022-03-15','2022-03-15',1,47.05000000,2,'','',0,1,NULL,78,3,NULL),(28,NULL,'','Frais bancaires','2022-11-21 02:47:31','2022-11-21 03:47:31','2022-03-01','2022-03-01',0,46.80000000,3,'','',0,1,NULL,79,3,NULL),(29,NULL,'','Paiement AVDS','2022-11-21 02:48:05','2022-11-21 03:48:05','2022-03-04','2022-03-04',0,2604.00000000,2,'','',0,1,NULL,80,3,NULL),(30,NULL,'','Remboursement note de frais MTQ mars 2022','2022-11-21 02:50:22','2022-11-21 03:50:22','2022-03-21','2022-03-21',0,47.05000000,2,'','',0,1,NULL,81,3,NULL),(31,NULL,'','Paiement ABD','2022-11-21 02:51:35','2022-11-21 03:51:35','2022-03-24','2022-03-24',0,345.08000000,6,'','',0,1,NULL,82,3,NULL),(32,NULL,'','Paiement MICROFORCE','2022-11-21 02:52:16','2022-11-21 03:52:16','2022-03-24','2022-03-24',0,269.00000000,6,'','',0,1,NULL,83,3,NULL),(33,NULL,'','Paiement IONOS','2022-11-21 02:52:50','2022-11-21 03:52:50','2022-03-26','2022-03-26',0,1.09000000,6,'','',0,1,NULL,84,3,NULL),(34,NULL,'','Paiement NOVE','2022-11-21 02:53:22','2022-11-21 03:53:22','2022-03-26','2022-03-26',0,214.85000000,6,'','',0,1,NULL,85,3,NULL),(35,NULL,'','Frais bancaires','2022-11-21 02:59:34','2022-11-21 03:59:34','2022-04-01','2022-04-01',0,46.80000000,3,'','',0,1,NULL,86,3,NULL),(36,NULL,'','Paiement AVDS','2022-11-21 03:00:05','2022-11-21 04:00:05','2022-04-06','2022-04-06',0,2604.00000000,2,'','',0,1,NULL,87,3,NULL),(37,NULL,'','Paiement MICROSOFT','2022-11-21 03:00:54','2022-11-21 04:00:54','2022-04-12','2022-04-12',0,63.68000000,6,'','',0,1,NULL,88,3,NULL),(38,NULL,'','Paiement PC LEADER','2022-11-21 03:01:57','2022-11-21 04:01:57','2022-04-12','2022-04-12',0,13.00000000,6,'','',0,1,NULL,89,3,NULL),(39,NULL,'','Paiement IONOS','2022-11-21 03:02:29','2022-11-21 04:02:29','2022-04-26','2022-04-26',0,1.09000000,6,'','',0,1,NULL,90,3,NULL),(40,NULL,'','Frais bancaires','2022-11-21 03:06:32','2022-11-21 04:06:32','2022-05-01','2022-05-01',0,46.80000000,3,'','',0,1,NULL,91,3,NULL),(41,NULL,'','Paiement AVDS','2022-11-21 03:06:59','2022-11-21 04:06:59','2022-05-03','2022-05-03',0,3255.00000000,2,'','',0,1,NULL,92,3,NULL),(42,NULL,'','Paiement FOURNIBUR','2022-11-21 03:07:36','2022-11-21 04:07:36','2022-05-03','2022-05-03',0,26.95000000,6,'','',0,1,NULL,93,3,NULL),(43,NULL,'','Paiement MICROSOFT','2022-11-21 03:09:01','2022-11-21 04:09:01','2022-05-15','2022-05-15',0,23.92000000,6,'','',0,1,NULL,94,3,NULL),(44,NULL,'','Paiement IONOS','2022-11-21 03:09:41','2022-11-21 04:09:41','2022-05-26','2022-05-26',0,1.09000000,6,'','',0,1,NULL,95,3,NULL),(45,NULL,'','Frais bancaires','2022-11-21 03:14:06','2022-11-21 04:14:06','2022-06-01','2022-06-01',0,22.80000000,3,'','',0,1,NULL,96,3,NULL),(46,NULL,'','Frais bancaires','2022-11-21 03:14:33','2022-11-21 04:14:33','2022-06-01','2022-06-01',0,24.00000000,3,'','',0,1,NULL,97,3,NULL),(47,NULL,'','Paiement FREE','2022-11-21 03:15:21','2022-11-21 04:15:21','2022-06-01','2022-06-01',0,19.99000000,6,'','',0,1,NULL,98,3,NULL),(48,NULL,'','Paiement AVDS','2022-11-21 03:16:07','2022-11-21 04:16:07','2022-06-06','2022-06-06',0,2604.00000000,2,'','',0,1,NULL,99,3,NULL),(49,NULL,'','Paiement MICROSOFT','2022-11-21 03:16:52','2022-11-21 04:16:52','2022-06-10','2022-06-10',0,64.82000000,6,'','',0,1,NULL,100,3,NULL),(50,NULL,'','Paiement PC LEADER','2022-11-21 03:17:36','2022-11-21 04:17:36','2022-06-17','2022-06-17',0,218.00000000,6,'','',0,1,NULL,101,3,NULL),(51,NULL,'','Paiement OVH','2022-11-21 03:18:26','2022-11-21 04:18:26','2022-06-22','2022-06-22',0,35.77000000,6,'','',0,1,NULL,102,3,NULL),(52,NULL,'','Paiement IONOS','2022-11-21 03:20:12','2022-11-21 04:20:12','2022-06-26','2022-06-26',0,1.09000000,6,'','',0,1,NULL,103,3,NULL),(53,NULL,'','Paiement DUPLICOULEURS','2022-11-21 03:20:44','2022-11-21 04:20:44','2022-06-26','2022-06-26',0,15.40000000,6,'','',0,1,NULL,104,3,NULL),(54,NULL,'','Remboursement MICROSOFT','2022-11-21 03:21:45','2022-11-21 04:21:45','2022-06-09','2022-06-09',1,23.19000000,6,'','',0,1,NULL,105,3,NULL),(55,NULL,'','Frais bancaires','2022-11-21 03:24:23','2022-11-21 04:24:23','2022-07-01','2022-07-01',0,22.80000000,3,'','',0,1,NULL,106,3,NULL),(56,NULL,'','Frais bancaires','2022-11-21 03:25:06','2022-11-21 04:25:06','2022-07-01','2022-07-01',0,24.00000000,3,'','',0,1,NULL,107,3,NULL),(57,NULL,'','Paiement AVDS','2022-11-21 03:25:35','2022-11-21 04:25:35','2022-07-01','2022-07-01',0,2604.00000000,2,'','',0,1,NULL,108,3,NULL),(58,NULL,'','Paiement NOVE','2022-11-21 03:26:04','2022-11-21 04:26:04','2022-07-04','2022-07-04',0,91.00000000,6,'','',0,1,NULL,109,3,NULL),(59,NULL,'','Paiement NOVE','2022-11-21 03:27:12','2022-11-21 04:27:12','2022-07-06','2022-07-06',0,26.00000000,6,'','',0,1,NULL,110,3,NULL),(60,NULL,'','Paiement NOVE','2022-11-21 03:28:40','2022-11-21 04:28:40','2022-07-08','2022-07-08',0,26.00000000,6,'','',0,1,NULL,111,3,NULL),(61,NULL,'','Paiement TENORSHARE','2022-11-21 03:29:31','2022-11-21 04:29:31','2022-07-09','2022-07-09',0,69.99000000,6,'','',0,1,NULL,112,3,NULL),(62,NULL,'','Paiement MICROSOFT','2022-11-21 03:30:27','2022-11-21 04:30:27','2022-07-12','2022-07-12',0,68.51000000,6,'','',0,1,NULL,113,3,NULL),(63,NULL,'','Paiement NOVE','2022-11-21 03:31:04','2022-11-21 04:31:04','2022-07-13','2022-07-13',0,11.18000000,6,'','',0,1,NULL,114,3,NULL),(64,NULL,'','Paiement IONOS','2022-11-21 03:31:43','2022-11-21 04:31:43','2022-07-26','2022-07-26',0,1.09000000,6,'','',0,1,NULL,115,3,NULL),(65,NULL,'','Frais bancaires','2022-11-21 03:34:18','2022-11-21 04:34:18','2022-08-01','2022-08-01',0,22.80000000,3,'','',0,1,NULL,116,3,NULL),(66,NULL,'','Frais bancaires','2022-11-21 03:34:54','2022-11-21 04:34:54','2022-08-01','2022-08-01',0,24.00000000,3,'','',0,1,NULL,117,3,NULL),(67,NULL,'','Paiement AVDS','2022-11-21 03:35:43','2022-11-21 04:35:43','2022-08-05','2022-08-05',0,2604.00000000,2,'','',0,1,NULL,118,3,NULL),(68,NULL,'','Paiement MICROSOFT','2022-11-21 03:36:52','2022-11-21 04:36:52','2022-08-10','2022-08-10',0,67.75000000,6,'','',0,1,NULL,119,3,NULL),(69,NULL,'','Paiement NOVE','2022-11-21 03:37:32','2022-11-21 04:37:32','2022-08-10','2022-08-10',0,28.49000000,6,'','',0,1,NULL,120,3,NULL),(70,NULL,'','Paiement DRONANSYEL','2022-11-21 03:38:24','2022-11-21 04:38:24','2022-08-16','2022-08-16',0,5208.00000000,2,'','',0,1,NULL,121,3,NULL),(71,NULL,'','Paiement IONOS','2022-11-21 03:39:01','2022-11-21 04:39:01','2022-08-26','2022-08-26',0,1.09000000,6,'','',0,1,NULL,122,3,NULL),(72,NULL,'','Paiement KAZALINK','2022-11-21 03:40:06','2022-11-21 04:40:06','2022-08-31','2022-08-31',0,162.75000000,2,'','',0,1,NULL,123,3,NULL),(73,NULL,'','Frais bancaires','2022-11-21 04:00:02','2022-11-21 05:00:02','2022-09-01','2022-09-01',0,22.80000000,3,'','',0,1,NULL,124,3,NULL),(74,NULL,'','Frais bancaires','2022-11-21 04:00:35','2022-11-21 05:00:35','2022-09-01','2022-09-01',0,24.00000000,3,'','',0,1,NULL,125,3,NULL),(75,NULL,'','Paiement FREE','2022-11-21 04:01:48','2022-11-21 05:01:48','2022-09-05','2022-09-05',0,9.99000000,3,'','',0,1,NULL,126,3,NULL),(76,NULL,'','Paiement AVDS','2022-11-21 04:02:26','2022-11-21 05:02:26','2022-09-05','2022-09-05',0,2604.00000000,2,'','',0,1,NULL,127,3,NULL),(77,NULL,'','Paiement MICROSOFT','2022-11-21 04:03:05','2022-11-21 05:03:05','2022-09-10','2022-09-10',0,69.39000000,6,'','',0,1,NULL,128,3,NULL),(78,NULL,'','Paiement IONOS','2022-11-21 04:04:04','2022-11-21 05:04:04','2022-09-26','2022-09-26',0,1.09000000,6,'','',0,1,NULL,129,3,NULL),(79,NULL,'','Paiement FREE','2022-11-21 04:04:50','2022-11-21 05:04:50','2022-09-29','2022-09-29',0,9.99000000,3,'','',0,1,NULL,130,3,NULL),(80,NULL,'','Frais bancaires','2022-11-21 04:07:07','2022-11-21 05:07:07','2022-10-01','2022-10-01',0,22.80000000,3,'','',0,1,NULL,131,3,NULL),(81,NULL,'','Frais bancaires','2022-11-21 04:07:27','2022-11-21 05:07:27','2022-10-01','2022-10-01',0,24.00000000,3,'','',0,1,NULL,132,3,NULL),(82,NULL,'','Paiement MICROFORCE','2022-11-21 04:07:58','2022-11-21 05:07:58','2022-10-01','2022-10-01',0,15.00000000,6,'','',0,1,NULL,133,3,NULL),(83,NULL,'','Paiement AVDS','2022-11-21 04:08:44','2022-11-21 05:08:44','2022-10-05','2022-10-05',0,542.50000000,2,'','',0,1,NULL,134,3,NULL),(84,NULL,'','Paiement AVDS','2022-11-21 04:09:18','2022-11-21 05:09:18','2022-10-05','2022-10-05',0,542.50000000,2,'','',0,1,NULL,135,3,NULL),(85,NULL,'','Paiement AVDS','2022-11-21 04:09:44','2022-11-21 05:09:44','2022-10-05','2022-10-05',0,542.50000000,2,'','',0,1,NULL,136,3,NULL),(86,NULL,'','Paiement AVDS','2022-11-21 04:10:04','2022-11-21 05:10:04','2022-10-05','2022-10-05',0,542.50000000,2,'','',0,1,NULL,137,3,NULL),(87,NULL,'','Paiement AVDS','2022-11-21 04:10:23','2022-11-21 05:10:23','2022-10-05','2022-10-05',0,542.50000000,2,'','',0,1,NULL,138,3,NULL),(88,NULL,'','Paiement AVDS','2022-11-21 04:10:40','2022-11-21 05:10:40','2022-10-05','2022-10-05',0,542.50000000,2,'','',0,1,NULL,139,3,NULL),(89,NULL,'','Paiement AVDS','2022-11-21 04:11:00','2022-11-21 05:11:00','2022-10-05','2022-10-05',0,542.50000000,2,'','',0,1,NULL,140,3,NULL),(90,NULL,'','Paiement AVDS','2022-11-21 04:11:21','2022-11-21 05:11:21','2022-10-05','2022-10-05',0,542.50000000,2,'','',0,1,NULL,141,3,NULL),(91,NULL,'','Paiement divers','2022-11-21 04:11:53','2022-11-21 05:11:53','2022-10-05','2022-10-05',0,542.50000000,2,'','',0,1,NULL,142,3,NULL),(92,NULL,'','Paiement MICROSOFT','2022-11-21 04:12:44','2022-11-21 05:12:44','2022-10-10','2022-10-10',0,70.95000000,6,'','',0,1,NULL,143,3,NULL),(93,NULL,'','Paiement IONOS','2022-11-21 04:13:23','2022-11-21 05:13:23','2022-10-26','2022-10-26',0,8.68000000,6,'','',0,1,NULL,144,3,NULL),(94,NULL,'','Paiement FREE','2022-11-21 04:14:08','2022-11-21 05:14:08','2022-10-31','2022-10-31',0,9.99000000,3,'','',0,1,NULL,145,3,NULL),(95,NULL,'','Paiement AMAZON US','2022-11-21 04:14:35','2022-11-21 05:14:35','2022-10-31','2022-10-31',0,250.46000000,6,'','',0,1,NULL,146,3,NULL),(96,NULL,'','Paiement AMAZON US','2022-11-21 04:15:01','2022-11-21 05:15:01','2022-10-31','2022-10-31',0,95.34000000,6,'','',0,1,NULL,147,3,NULL),(97,NULL,'','Paiement AMAZON US','2022-11-21 04:15:24','2022-11-21 05:15:24','2022-10-31','2022-10-31',0,163.98000000,6,'','',0,1,NULL,148,3,NULL),(98,NULL,'','Frais bancaires','2022-11-21 04:19:33','2022-11-21 05:19:33','2022-11-01','2022-11-01',0,22.80000000,3,'','',0,1,NULL,149,3,NULL),(99,NULL,'','Frais bancaires','2022-11-21 04:20:06','2022-11-21 05:20:06','2022-11-01','2022-11-01',0,24.00000000,3,'','',0,1,NULL,150,3,NULL),(100,NULL,'','Paiement AVDS','2022-11-21 04:21:02','2022-11-21 05:21:02','2022-11-04','2022-11-04',0,542.50000000,2,'','',0,1,NULL,151,3,NULL),(101,NULL,'','Paiement AVDS','2022-11-21 04:21:34','2022-11-21 05:21:34','2022-11-04','2022-11-04',0,1953.00000000,2,'','',0,1,NULL,152,3,NULL),(102,NULL,'','Note de frais creation SASU EKWITECH','2022-11-21 04:23:04','2022-11-21 05:23:04','2022-11-05','2022-11-05',0,647.31000000,2,'','',0,1,NULL,153,3,NULL),(103,NULL,'','Paiement MICROSOFT','2022-11-21 04:24:25','2022-11-21 05:24:25','2022-11-09','2022-11-09',0,68.93000000,6,'','',0,1,NULL,154,3,NULL),(104,NULL,'','Paiement OCTOLOOKS','2022-11-21 04:26:18','2022-11-21 05:26:18','2022-11-11','2022-11-11',0,39.11000000,6,'','',0,1,NULL,155,3,NULL),(105,NULL,'','Remboursement AMAZON US','2022-11-21 04:26:58','2022-11-21 05:26:58','2022-11-15','2022-11-15',1,6.55000000,6,'','',0,1,NULL,156,3,NULL),(106,NULL,'','Remboursement AMAZON US','2022-11-21 04:27:19','2022-11-21 05:27:19','2022-11-15','2022-11-15',1,9.38000000,6,'','',0,1,NULL,157,3,NULL),(107,NULL,'','Paiement AVDS','2022-11-21 04:30:51','2022-11-21 05:30:51','2022-10-05','2022-10-05',0,1953.00000000,2,'','',0,1,NULL,158,3,NULL);

--
-- Table structure for table `llx_payment_vat`
--

CREATE TABLE `llx_payment_vat` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_tva` 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_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=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `llx_payment_vat`
--


--
-- Table structure for table `llx_paymentexpensereport_expensereport`
--

CREATE TABLE `llx_paymentexpensereport_expensereport` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_payment` int DEFAULT NULL,
  `fk_expensereport` int DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  `multicurrency_code` varchar(3) DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT '1.00000000',
  `multicurrency_amount` double(24,8) DEFAULT '0.00000000',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `llx_paymentexpensereport_expensereport`
--


--
-- Table structure for table `llx_pos_cash_fence`
--

CREATE TABLE `llx_pos_cash_fence` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `entity` int NOT NULL DEFAULT '1',
  `ref` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `posnumber` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fk_user_creat` int DEFAULT NULL,
  `fk_user_valid` int DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `import_key` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_pos_cash_fence`
--

INSERT INTO `llx_pos_cash_fence` (`rowid`, `entity`, `ref`, `label`, `opening`, `cash`, `card`, `cheque`, `status`, `date_creation`, `date_valid`, `day_close`, `month_close`, `year_close`, `posmodule`, `posnumber`, `fk_user_creat`, `fk_user_valid`, `tms`, `import_key`) VALUES (1,1,'1',NULL,0.01000000,0.01000000,NULL,NULL,1,'2022-10-04 05:52:36','2022-10-04 05:53:24',4,10,2022,'takepos','1',NULL,2,'2022-10-04 05:53:24',NULL),(2,1,'2',NULL,0.00000000,0.00000000,0.00000000,0.00000000,0,'2023-12-04 17:15:25',NULL,4,12,2023,'takepos','1',NULL,NULL,'2023-12-04 21:15:25',NULL),(3,1,'3',NULL,0.00000000,0.00000000,0.00000000,0.00000000,0,'2024-02-22 20:04:02',NULL,22,2,2024,'takepos','1',NULL,NULL,'2024-02-23 00:04:02',NULL),(4,1,'4',NULL,0.00000000,0.00000000,0.00000000,0.00000000,0,'2024-08-03 01:38:49',NULL,3,8,2024,'takepos','1',NULL,NULL,'2024-08-03 05:38:49',NULL),(5,1,'5',NULL,0.00000000,0.00000000,0.00000000,0.00000000,0,'2025-03-14 08:12:01',NULL,14,3,2025,'takepos','1',NULL,NULL,'2025-03-14 08:12:01',NULL),(6,1,'6',NULL,0.00000000,0.00000000,0.00000000,0.00000000,0,'2025-03-15 15:48:31',NULL,15,3,2025,'takepos','1',NULL,NULL,'2025-03-15 15:48:31',NULL);

--
-- Table structure for table `llx_prelevement`
--

CREATE TABLE `llx_prelevement` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_facture` int DEFAULT NULL,
  `fk_facture_fourn` int DEFAULT NULL,
  `fk_salary` int DEFAULT NULL,
  `fk_prelevement_lignes` int NOT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_prelevement_facture_fk_prelevement_lignes` (`fk_prelevement_lignes`),
  KEY `idx_prelevement_fk_prelevement_lignes` (`fk_prelevement_lignes`),
  CONSTRAINT `fk_prelevement_facture_fk_prelevement_lignes` FOREIGN KEY (`fk_prelevement_lignes`) REFERENCES `llx_prelevement_lignes` (`rowid`),
  CONSTRAINT `fk_prelevement_fk_prelevement_lignes` FOREIGN KEY (`fk_prelevement_lignes`) REFERENCES `llx_prelevement_lignes` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_prelevement`
--


--
-- Table structure for table `llx_prelevement_bons`
--

CREATE TABLE `llx_prelevement_bons` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'debit-order',
  `ref` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_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 CHARACTER SET utf8mb4 COLLATE utf8mb4_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,
  `fk_bank_account` int DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_prelevement_bons_ref` (`ref`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_prelevement_bons`
--


--
-- Table structure for table `llx_prelevement_demande`
--

CREATE TABLE `llx_prelevement_demande` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `entity` int NOT NULL DEFAULT '1',
  `fk_facture` int DEFAULT NULL,
  `fk_facture_fourn` int DEFAULT NULL,
  `fk_salary` int DEFAULT NULL,
  `sourcetype` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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,
  `fk_societe_rib` int DEFAULT NULL,
  `code_banque` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code_guichet` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cle_rib` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ext_payment_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ext_payment_site` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_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`),
  KEY `idx_prelevement_demande_fk_facture` (`fk_facture`),
  KEY `idx_prelevement_demande_fk_facture_fourn` (`fk_facture_fourn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_prelevement_demande`
--


--
-- Table structure for table `llx_prelevement_lignes`
--

CREATE TABLE `llx_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  `code_banque` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code_guichet` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cle_rib` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `fk_user` int DEFAULT NULL,
  `tms` timestamp NOT 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 `llx_prelevement_bons` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_prelevement_lignes`
--


--
-- Table structure for table `llx_prelevement_rejet`
--

CREATE TABLE `llx_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 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `afacturer` tinyint DEFAULT '0',
  `fk_facture` int DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_prelevement_rejet`
--


--
-- Table structure for table `llx_printer_receipt`
--

CREATE TABLE `llx_printer_receipt` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fk_type` int DEFAULT NULL,
  `fk_profile` int DEFAULT NULL,
  `parameter` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `entity` int DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_printer_receipt`
--


--
-- Table structure for table `llx_printer_receipt_template`
--

CREATE TABLE `llx_printer_receipt_template` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `template` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `entity` int DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_printer_receipt_template`
--

INSERT INTO `llx_printer_receipt_template` (`rowid`, `name`, `template`, `entity`) VALUES (2,'Exemple','{dol_align_center}\\r\\n{dol_print_text}{dol_value_mysoc_name}\\r\\n{dol_print_text}{dol_value_mysoc_address}\\r\\n{dol_print_text}{dol_value_mysoc_zip}{dol_value_mysoc_town}\\r\\n{dol_line_feed}\\r\\n{dol_print_text}Facture {dol_value_object_ref}\\r\\n{dol_line_feed}\\r\\n{dol_align_left}\\r\\n{dol_print_object_lines}\\r\\n{dol_line_feed}\\r\\n{dol_print_object_tax}\\r\\n{dol_line_feed}\\r\\n{dol_print_object_total}\\r\\n{dol_line_feed}\\r\\n{dol_cut_paper_full}',1);

--
-- Table structure for table `llx_printing`
--

CREATE TABLE `llx_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 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `printer_location` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `printer_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `copy` int NOT NULL DEFAULT '1',
  `module` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `driver` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `userid` int DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_printing`
--


--
-- Table structure for table `llx_prixmasse`
--

CREATE TABLE `llx_prixmasse` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_object` int NOT NULL DEFAULT '0',
  `fk_version` int NOT NULL DEFAULT '0',
  `fk_user_author` int NOT NULL DEFAULT '0',
  `total_ht_before` double(24,8) NOT NULL DEFAULT '0.00000000',
  `percent` double NOT NULL DEFAULT '0',
  `total_ht_after` double(24,8) NOT NULL DEFAULT '0.00000000',
  `datec` datetime NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `entity` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `llx_prixmasse`
--

INSERT INTO `llx_prixmasse` (`rowid`, `fk_object`, `fk_version`, `fk_user_author`, `total_ht_before`, `percent`, `total_ht_after`, `datec`, `tms`, `entity`) VALUES (3,5,0,3,140.00000000,0,140.00000000,'2021-10-02 21:56:41','2021-10-03 01:56:41',1),(4,5,0,3,140.00000000,0,140.00000000,'2021-10-02 21:56:58','2021-10-03 01:56:58',1),(5,6,0,3,140.00000000,0,140.00000000,'2021-10-02 21:56:41','2021-10-03 01:56:41',1),(6,6,0,3,140.00000000,0,140.00000000,'2021-10-02 21:56:58','2021-10-03 01:56:58',1),(9,9,0,3,600.00000000,-41.666666666667,350.00000000,'2021-10-28 23:23:02','2021-10-29 03:23:02',1),(10,10,0,3,140.00000000,0,140.00000000,'2021-10-02 21:56:41','2021-10-03 01:56:41',1),(11,10,0,3,140.00000000,0,140.00000000,'2021-10-02 21:56:58','2021-10-03 01:56:58',1),(12,21,0,3,0.00000000,0,0.00000000,'2022-06-23 17:53:07','2022-06-23 21:53:07',1);

--
-- Table structure for table `llx_prixmasse_hist`
--

CREATE TABLE `llx_prixmasse_hist` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_object` int NOT NULL DEFAULT '0',
  `fk_version` int NOT NULL DEFAULT '0',
  `fk_user_author` int NOT NULL DEFAULT '0',
  `total_ht_before` double(24,8) NOT NULL DEFAULT '0.00000000',
  `percent` double NOT NULL DEFAULT '0',
  `total_ht_after` double(24,8) NOT NULL DEFAULT '0.00000000',
  `datec` datetime NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `entity` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `llx_prixmasse_hist`
--


--
-- Table structure for table `llx_prixmasse_produits`
--

CREATE TABLE `llx_prixmasse_produits` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_produit` int NOT NULL DEFAULT '0',
  `datec` datetime NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `entity` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `llx_prixmasse_produits`
--


--
-- Table structure for table `llx_prixmassedet`
--

CREATE TABLE `llx_prixmassedet` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_prixmasse` int NOT NULL DEFAULT '0',
  `fk_version` int NOT NULL DEFAULT '0',
  `fk_object` int NOT NULL DEFAULT '0',
  `fk_objectdet` int NOT NULL DEFAULT '0',
  `datec` datetime NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `llx_prixmassedet`
--


--
-- Table structure for table `llx_prixmassedet_hist`
--

CREATE TABLE `llx_prixmassedet_hist` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_prixmasse` int NOT NULL DEFAULT '0',
  `fk_version` int NOT NULL DEFAULT '0',
  `fk_object` int NOT NULL DEFAULT '0',
  `fk_objectdet` int NOT NULL DEFAULT '0',
  `datec` datetime NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `llx_prixmassedet_hist`
--


--
-- Table structure for table `llx_product`
--

CREATE TABLE `llx_product` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `ref` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `entity` int NOT NULL DEFAULT '1',
  `ref_ext` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `note_public` mediumtext COLLATE utf8mb4_unicode_ci,
  `note` mediumtext COLLATE utf8mb4_unicode_ci,
  `customcode` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'HT',
  `price_label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cost_price` double(24,8) DEFAULT NULL,
  `default_vat_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `localtax2_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seuil_stock_alerte` float DEFAULT NULL,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `barcode` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fk_barcode_type` int DEFAULT NULL,
  `accountancy_code_sell` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `accountancy_code_sell_intra` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `accountancy_code_sell_export` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `accountancy_code_buy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `accountancy_code_buy_intra` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `accountancy_code_buy_export` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `partnumber` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `net_measure` float DEFAULT NULL,
  `net_measure_units` tinyint 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `finished` tinyint DEFAULT NULL,
  `hidden` tinyint DEFAULT '0',
  `import_key` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model_pdf` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fk_price_expression` int DEFAULT NULL,
  `desiredstock` float DEFAULT '0',
  `fk_unit` int DEFAULT NULL,
  `price_autogen` tinyint DEFAULT '0',
  `fk_project` int DEFAULT NULL,
  `batch_mask` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_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 utf8mb4_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 `idx_product_fk_project` (`fk_project`),
  KEY `fk_product_fk_unit` (`fk_unit`),
  KEY `fk_product_finished` (`finished`),
  KEY `fk_product_default_warehouse` (`fk_default_warehouse`),
  KEY `idx_product_entity_fk_product_type` (`entity`,`fk_product_type`),
  CONSTRAINT `fk_product_barcode_type` FOREIGN KEY (`fk_barcode_type`) REFERENCES `llx_c_barcode_type` (`rowid`),
  CONSTRAINT `fk_product_finished` FOREIGN KEY (`finished`) REFERENCES `llx_c_product_nature` (`code`),
  CONSTRAINT `fk_product_fk_country` FOREIGN KEY (`fk_country`) REFERENCES `llx_c_country` (`rowid`),
  CONSTRAINT `fk_product_fk_unit` FOREIGN KEY (`fk_unit`) REFERENCES `llx_c_units` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_product`
--

INSERT INTO `llx_product` (`rowid`, `ref`, `entity`, `ref_ext`, `datec`, `tms`, `fk_parent`, `label`, `description`, `note_public`, `note`, `customcode`, `fk_country`, `fk_state`, `price`, `price_ttc`, `price_min`, `price_min_ttc`, `price_base_type`, `price_label`, `cost_price`, `default_vat_code`, `tva_tx`, `recuperableonly`, `localtax1_tx`, `localtax1_type`, `localtax2_tx`, `localtax2_type`, `fk_user_author`, `fk_user_modif`, `tosell`, `tobuy`, `tobatch`, `sell_or_eat_by_mandatory`, `fk_product_type`, `duration`, `seuil_stock_alerte`, `url`, `barcode`, `fk_barcode_type`, `accountancy_code_sell`, `accountancy_code_sell_intra`, `accountancy_code_sell_export`, `accountancy_code_buy`, `accountancy_code_buy_intra`, `accountancy_code_buy_export`, `partnumber`, `net_measure`, `net_measure_units`, `weight`, `weight_units`, `length`, `length_units`, `width`, `width_units`, `height`, `height_units`, `surface`, `surface_units`, `volume`, `volume_units`, `stock`, `pmp`, `fifo`, `lifo`, `fk_default_warehouse`, `canvas`, `finished`, `hidden`, `import_key`, `model_pdf`, `fk_price_expression`, `desiredstock`, `fk_unit`, `price_autogen`, `fk_project`, `batch_mask`, `lifetime`, `qc_frequency`, `mandatory_period`, `fk_default_bom`, `fk_default_workstation`, `stockable_product`, `last_main_doc`) VALUES (1,'SUP-INF-DJ',1,NULL,'2021-07-28 06:10:11','2024-03-21 04:27:45',0,'Demi-journée support informatique','',NULL,'','',NULL,NULL,300.00000000,325.50000000,0.00000000,0.00000000,'HT',NULL,NULL,'85',8.500,0,0.000,'0',0.000,'0',2,3,0,0,0,0,1,'0.5d',0,NULL,NULL,NULL,'','','','','','',NULL,NULL,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,NULL,0,NULL,'',NULL,NULL,0,NULL,NULL,0,NULL),(2,'MO-INF-H-NIV1',1,NULL,'2021-07-28 06:12:21','2025-04-02 04:15:22',0,'Main d\'œuvre informatique niveau 1 (Heure)','',NULL,'','',NULL,NULL,109.00000000,118.27000000,90.00000000,97.65000000,'HT',NULL,NULL,NULL,8.500,0,0.000,'0',0.000,'0',2,3,1,0,0,0,1,'1h',0,NULL,NULL,NULL,'','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,NULL,'',0,0,NULL,NULL,NULL,0,NULL,0,NULL,'',NULL,NULL,0,0,NULL,0,NULL),(3,'SUP-INF-DH',1,NULL,'2021-07-28 06:15:53','2024-03-21 04:27:36',0,'Demi-heure support informatique','',NULL,'','',NULL,NULL,40.00000000,43.40000000,0.00000000,0.00000000,'HT',NULL,NULL,'85',8.500,0,0.000,'0',0.000,'0',2,3,0,0,0,0,1,'30i',0,NULL,NULL,NULL,'','','','','','',NULL,NULL,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,NULL,0,NULL,'',NULL,NULL,0,NULL,NULL,0,NULL),(4,'SUP-INF-QH',1,NULL,'2021-07-28 06:18:55','2024-03-21 04:33:03',0,'Quart d\'heure support informatique','',NULL,'','',NULL,NULL,20.00000000,21.70000000,0.00000000,0.00000000,'HT',NULL,NULL,'85',8.500,0,0.000,'0',0.000,'0',2,3,0,0,0,0,1,'15i',0,NULL,NULL,NULL,'','','','','','',NULL,NULL,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,NULL,0,NULL,'',NULL,NULL,0,NULL,NULL,0,NULL),(5,'SUP-INF-JR',1,NULL,'2021-07-28 10:36:19','2024-03-21 04:28:14',0,'Journée support informatique','',NULL,'','',NULL,NULL,600.00000000,651.00000000,0.00000000,0.00000000,'HT',NULL,NULL,'85',8.500,0,0.000,'0',0.000,'0',2,3,0,0,0,0,1,'1d',0,NULL,NULL,NULL,'','','','','','',NULL,NULL,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,NULL,0,NULL,'',NULL,NULL,0,NULL,NULL,0,NULL),(6,'M.2-2242-64',1,NULL,'2021-08-16 22:35:38','2024-03-21 04:26:28',0,'Disque M.2 2242 64 GO','',NULL,'','',NULL,NULL,40.00000000,43.40000000,0.00000000,0.00000000,'HT',NULL,NULL,'85',8.500,0,0.000,'0',0.000,'0',2,3,0,0,0,0,0,'',0,NULL,NULL,NULL,'','','','','','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,19.21000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,NULL,0,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(8,'SSD-250-SAMSUNG',1,NULL,'2021-10-02 21:42:01','2023-11-24 03:16:48',0,'Samsung SSD 870 EVO 250 Go','',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,'85',8.500,0,0.000,'0',0.000,'0',3,3,0,0,0,0,0,'',0,NULL,NULL,NULL,'','','','','','',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,NULL,0,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(9,'DDR3-SDRAM4G-KINGSTON',1,NULL,'2021-10-02 21:46:09','2024-03-21 04:16:19',0,'Kingston ValueRAM SO-DIMM 4 Go','',NULL,'','',NULL,NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',NULL,NULL,'85',8.500,0,0.000,'0',0.000,'0',3,3,0,0,0,0,0,'',0,NULL,NULL,NULL,'','','','','','',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,NULL,0,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(11,'DEP-ZONE-aa',1,NULL,'2022-01-06 18:48:50','2024-03-21 04:26:45',0,'Déplacement zone A','',NULL,'','',NULL,NULL,10.00000000,10.85000000,0.00000000,0.00000000,'HT',NULL,NULL,'85',8.500,0,0.000,'0',0.000,'0',3,3,0,0,0,0,1,'s',0,NULL,NULL,NULL,'','','','','','',NULL,NULL,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,NULL,0,NULL,'',NULL,NULL,0,NULL,NULL,0,NULL),(12,'HOU-TABA8-2022',1,NULL,'2022-02-02 10:23:00','2024-03-21 04:26:18',0,'Housse Samsung Galaxy Tab A8 2022','Housse de protection hybride antichoc et robuste avec b&eacute;quille pour Samsung Galaxy Tab A8 2022 Mod&egrave;le SM-X200/SM-X205 (Noir+Bleu)',NULL,'','',NULL,NULL,30.00000000,32.55000000,0.00000000,0.00000000,'HT',NULL,NULL,'85',8.500,0,0.000,'0',0.000,'0',3,3,0,0,0,0,0,'',0,NULL,NULL,NULL,'','','','','','',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,NULL,0,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(13,'DOUCHETTE-USB-01',1,NULL,'2022-06-15 17:57:20','2024-03-21 04:26:04',0,'DOUCHETTE SYMBOL - LS2208 USB - NOIR','',NULL,'','',NULL,NULL,120.00000000,130.20000000,0.00000000,0.00000000,'HT',NULL,NULL,'85',8.500,0,0.000,'0',0.000,'0',3,3,0,0,0,0,0,'',0,NULL,NULL,NULL,'','','','','','',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,NULL,0,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(14,'MO-INF-J-NIV1',1,NULL,'2023-08-11 13:36:19','2025-03-14 08:00:08',0,'Main d\'œuvre informatique niveau 1 (Journée)','',NULL,'','',NULL,NULL,790.00000000,857.15000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,8.500,0,0.000,'0',0.000,'0',3,3,1,0,0,0,1,'1d',0,NULL,NULL,NULL,'','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,NULL,'',0,0,NULL,NULL,NULL,0,NULL,0,NULL,'',NULL,NULL,0,0,NULL,0,NULL),(15,'H-MO-INF',1,NULL,'2023-08-14 13:18:45','2024-03-21 04:27:21',0,'Main d\'ouvre informatique','',NULL,'','',NULL,NULL,89.00000000,96.57000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,8.500,0,0.000,'0',0.000,'0',3,3,0,0,0,0,1,'1h',0,NULL,NULL,NULL,'','','','','','',NULL,NULL,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,NULL,0,NULL,'',NULL,NULL,0,NULL,NULL,0,NULL),(20,'Offre_unique_Dolibarr',1,NULL,'2024-09-14 10:43:02','2025-02-11 16:03:09',0,'Offre unique Dolibarr','<ul>\r\n	<li>H&eacute;berg&eacute; en France.</li>\r\n	<li>Sauvegarde quotidienne.</li>\r\n	<li>Mises &agrave; jour r&eacute;guli&egrave;re.</li>\r\n	<li>Assistance technique.</li>\r\n</ul>',NULL,'','',NULL,NULL,26.73000000,29.00000000,0.00000000,0.00000000,'TTC',NULL,NULL,NULL,8.500,0,0.000,'0',0.000,'0',3,3,1,0,0,0,1,'h',0,NULL,NULL,NULL,'','','','','','',NULL,NULL,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,NULL,0,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(22,'PFJ4151EU',1,NULL,'2025-02-03 23:10:12','2025-02-04 11:49:22',0,'Mi TV Box S (2nd Gen)','Cortex-A55, 2048 Mo, 8 Go, Google TV, Noir<br />\r\nGarantie: 2ans',NULL,'','',NULL,NULL,79.00000000,85.72000000,79.00000000,85.72000000,'HT',NULL,NULL,NULL,8.500,0,0.000,'0',0.000,'0',3,3,1,0,1,0,0,'',0,NULL,'040000000002',8,'','','','','','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,1,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,NULL,0,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(23,'ST1000DM010',1,NULL,'2025-02-03 23:58:01','2025-02-04 05:38:39',0,'Seagate BarraCuda 1 To','<p>Disque dur 3.5&quot; 1 To 7200 RPM 64 Mo Serial ATA 6 Gb/s (bulk)</p>\r\n\r\n<p>&nbsp;</p>',NULL,'','',NULL,NULL,45.00000000,45.00000000,42.00000000,42.00000000,'HT',NULL,NULL,NULL,0.000,0,0.000,'0',0.000,'0',3,3,1,0,0,0,0,'',0,NULL,NULL,NULL,'','','','','','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,1,0.00000000,NULL,NULL,6,'',NULL,0,NULL,NULL,NULL,0,NULL,0,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(24,'3303170070789',1,NULL,'2025-02-04 00:03:58','2025-02-04 05:37:46',0,'T\'nB Regular - Étui à rabat pour tablette','<p>Universel - Cuir artificiel - Rouge - 10 pouces</p>',NULL,'','',NULL,NULL,30.00000000,32.55000000,25.00000000,27.13000000,'HT',NULL,NULL,NULL,8.500,0,0.000,'0',0.000,'0',3,3,1,0,0,0,0,'',0,NULL,NULL,NULL,'','','','','','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,2,0.00000000,NULL,NULL,6,'',NULL,0,NULL,NULL,NULL,0,NULL,0,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(25,'LEN_ZG38C02761',1,NULL,'2025-02-04 00:13:09','2025-02-04 11:45:57',0,'Tab M10 HD Folio Case/Film Black','L&#39;&eacute;tui-clavier Lenovo Tab M10 et le film de protection apportent s&eacute;curit&eacute;, fiabilit&eacute; et autonomie exceptionnelle &agrave; votre tablette Lenovo.',NULL,'','',NULL,NULL,29.00000000,31.47000000,26.00000000,28.21000000,'HT',NULL,NULL,NULL,8.500,0,0.000,'0',0.000,'0',3,3,1,0,0,0,0,'',0,NULL,'040000000001',8,'','','','','','',NULL,NULL,NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,1,20.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,NULL,0,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(26,'MO-INF-J-NIV2',1,NULL,'2025-02-21 15:10:56','2025-03-14 08:00:44',0,'Main d\'œuvre informatique niveau 2 (Journée)','',NULL,'','',NULL,NULL,990.00000000,1074.15000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,8.500,0,0.000,'0',0.000,'0',2,3,1,0,0,0,1,'1d',0,NULL,NULL,NULL,'706','706','706','60','60','60',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,NULL,'',0,0,NULL,NULL,NULL,0,NULL,0,NULL,'',NULL,NULL,0,0,NULL,1,NULL),(27,'MO-INF-H-NIV2',1,NULL,'2025-02-21 15:12:18','2025-03-14 08:02:13',0,'Main d\'œuvre informatique niveau 2 (Heure)','',NULL,'','',NULL,NULL,139.00000000,150.82000000,0.00000000,0.00000000,'HT',NULL,NULL,NULL,8.500,0,0.000,'0',0.000,'0',2,3,1,0,0,0,1,'1h',0,NULL,NULL,NULL,'706','706','706','60','60','60',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,NULL,'',0,0,NULL,NULL,NULL,0,NULL,0,NULL,'',NULL,NULL,0,0,NULL,1,NULL),(28,'CREA_CPTE_STRIPE',1,NULL,'2025-02-27 00:10:52','2025-03-14 07:32:25',0,'Création compte Stripe','<ul>\r\n	<li>Cr&eacute;ation compte Stripe.</li>\r\n	<li>Configuration du compte.</li>\r\n	<li>D&eacute;marches pour v&eacute;rification et validation du compte.</li>\r\n</ul>',NULL,'','',NULL,NULL,54.38000000,59.00000000,0.00000000,0.00000000,'TTC',NULL,NULL,NULL,8.500,0,0.000,'0',0.000,'0',2,3,1,0,0,0,1,'0h',0,NULL,NULL,NULL,'706','706','706','60','60','60',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,NULL,0,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(29,'CREA_CPTE_PAYPAL',1,NULL,'2025-02-27 00:11:25','2025-03-14 07:31:47',0,'Création compte Paypal','<ul>\r\n	<li>Cr&eacute;ation compte Paypal.</li>\r\n	<li>Configuration du compte.</li>\r\n	<li>D&eacute;marches pour v&eacute;rification et validation du compte.</li>\r\n</ul>',NULL,'','',NULL,NULL,54.38000000,59.00000000,0.00000000,0.00000000,'TTC',NULL,NULL,NULL,8.500,0,0.000,'0',0.000,'0',2,3,1,0,0,0,1,'0h',0,NULL,NULL,NULL,'706','706','706','60','60','60',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,NULL,0,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(30,'CREA_CPTE_SUMUP',1,NULL,'2025-03-14 07:35:22','2025-03-14 07:35:52',0,'Création compte SumUp','',NULL,'','',NULL,NULL,54.38000000,59.00000000,0.00000000,0.00000000,'TTC',NULL,NULL,NULL,8.500,0,0.000,'0',0.000,'0',3,3,1,0,0,0,1,'0h',0,NULL,NULL,NULL,'706','706','706','60','60','60',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,NULL,'',0,0,NULL,NULL,NULL,0,NULL,0,NULL,'',NULL,NULL,0,0,NULL,1,NULL),(31,'Offre_unique_Nextcloud',1,NULL,'2025-03-14 07:37:25','2025-03-14 07:40:30',0,'Offre unique Nextcloud','',NULL,'','',NULL,NULL,26.73000000,29.00000000,0.00000000,0.00000000,'TTC',NULL,NULL,NULL,8.500,0,0.000,'0',0.000,'0',3,3,1,0,0,0,1,'0h',0,NULL,NULL,NULL,'706','706','706','60','60','60',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,NULL,'',0,0,NULL,NULL,NULL,0,NULL,0,NULL,'',NULL,NULL,0,0,NULL,1,NULL),(32,'CREA_CPTE_GOCARDLESS',1,NULL,'2025-03-14 07:42:16','2025-03-14 07:42:42',0,'Création compte GoCardless','',NULL,'','',NULL,NULL,54.38000000,59.00000000,0.00000000,0.00000000,'TTC',NULL,NULL,NULL,8.500,0,0.000,'0',0.000,'0',3,3,1,0,0,0,1,'0h',0,NULL,NULL,NULL,'706','706','706','60','60','60',NULL,NULL,NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0.00000000,NULL,NULL,NULL,'',0,0,NULL,NULL,NULL,0,NULL,0,NULL,'',NULL,NULL,0,NULL,NULL,1,NULL),(33,'Offre_unique_GLPI',1,NULL,'2025-03-14 07:47:18','2025-03-14 07:50:44',0,'Offre unique GLPI','',NULL,'','',NULL,NULL,26.73000000,29.00000000,0.00000000,0.00000000,'TTC',NULL,NULL,NULL,8.500,0,0.000,'0',0.000,'0',3,3,1,0,0,0,1,'0h',0,NULL,NULL,NULL,'706','706','706','60','60','60',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,0.00000000,NULL,NULL,NULL,'',0,0,NULL,NULL,NULL,0,NULL,0,NULL,'',NULL,NULL,0,0,NULL,1,NULL),(34,'PAIE_DOLIBARR',1,NULL,'2025-04-02 04:51:12','2025-04-02 04:51:53',0,'Paie Dolibarr','<p>Le Module &quot;Paie&quot; vous permet d&#39;assurer une très bonne gestion de votre paie sur Dolibarr, et de générer une situation de paie (mensuel ou annuel) de votre entreprise.</p>\r\n\r\n<section>&nbsp;</section>',NULL,'','',NULL,NULL,199.08000000,216.00000000,0.00000000,0.00000000,'TTC',NULL,NULL,NULL,8.500,0,0.000,'0',0.000,'0',3,3,1,1,0,0,0,'',0,NULL,NULL,NULL,'','','','','','',NULL,NULL,NULL,NULL,-6,NULL,-3,NULL,-3,NULL,-3,NULL,-6,NULL,-9,NULL,0.00000000,NULL,NULL,NULL,'',NULL,0,NULL,NULL,NULL,0,NULL,0,NULL,'',NULL,NULL,0,0,NULL,1,NULL);

--
-- Table structure for table `llx_product_association`
--

CREATE TABLE `llx_product_association` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_product_pere` int NOT NULL DEFAULT '0',
  `fk_product_fils` int NOT NULL DEFAULT '0',
  `qty` double DEFAULT NULL,
  `incdec` int DEFAULT '1',
  `rang` int DEFAULT '0',
  `import_key` varchar(14) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_association` (`fk_product_pere`,`fk_product_fils`),
  KEY `idx_product_association_fils` (`fk_product_fils`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_product_association`
--


--
-- Table structure for table `llx_product_attribute`
--

CREATE TABLE `llx_product_attribute` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `ref` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ref_ext` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` int NOT NULL DEFAULT '0',
  `entity` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_attribute_ref` (`ref`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_product_attribute`
--


--
-- Table structure for table `llx_product_attribute_combination`
--

CREATE TABLE `llx_product_attribute_combination` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_product_parent` int NOT NULL,
  `fk_product_child` int NOT NULL,
  `variation_price` double(24,8) NOT NULL,
  `variation_price_percentage` int DEFAULT NULL,
  `variation_weight` double NOT NULL,
  `variation_ref_ext` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `entity` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`rowid`),
  KEY `idx_product_att_com_product_parent` (`fk_product_parent`),
  KEY `idx_product_att_com_product_child` (`fk_product_child`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_product_attribute_combination`
--


--
-- Table structure for table `llx_product_attribute_combination2val`
--

CREATE TABLE `llx_product_attribute_combination2val` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_prod_combination` int NOT NULL,
  `fk_prod_attr` int NOT NULL,
  `fk_prod_attr_val` int NOT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_product_att_com2v_prod_combination` (`fk_prod_combination`),
  KEY `idx_product_att_com2v_prod_attr` (`fk_prod_attr`),
  KEY `idx_product_att_com2v_prod_attr_val` (`fk_prod_attr_val`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_product_attribute_combination2val`
--


--
-- Table structure for table `llx_product_attribute_combination_price_level`
--

CREATE TABLE `llx_product_attribute_combination_price_level` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_product_attribute_combination` int NOT NULL DEFAULT '1',
  `fk_price_level` int NOT NULL DEFAULT '1',
  `variation_price` double(24,8) NOT NULL,
  `variation_price_percentage` int DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `fk_product_attribute_combination` (`fk_product_attribute_combination`,`fk_price_level`),
  UNIQUE KEY `fk_product_attribute_combinati_2` (`fk_product_attribute_combination`,`fk_price_level`),
  UNIQUE KEY `uk_prod_att_comb_price_level` (`fk_product_attribute_combination`,`fk_price_level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_product_attribute_combination_price_level`
--


--
-- Table structure for table `llx_product_attribute_value`
--

CREATE TABLE `llx_product_attribute_value` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `fk_product_attribute` int NOT NULL,
  `ref` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `entity` int NOT NULL DEFAULT '1',
  `position` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_attribute_value` (`fk_product_attribute`,`ref`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_product_attribute_value`
--


--
-- Table structure for table `llx_product_batch`
--

CREATE TABLE `llx_product_batch` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_product_stock` int NOT NULL,
  `eatby` datetime DEFAULT NULL,
  `sellby` datetime DEFAULT NULL,
  `batch` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `qty` double NOT NULL DEFAULT '0',
  `import_key` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_batch` (`fk_product_stock`,`batch`),
  KEY `idx_fk_product_stock` (`fk_product_stock`),
  KEY `idx_batch` (`batch`),
  CONSTRAINT `fk_product_batch_fk_product_stock` FOREIGN KEY (`fk_product_stock`) REFERENCES `llx_product_stock` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_product_batch`
--

INSERT INTO `llx_product_batch` (`rowid`, `tms`, `fk_product_stock`, `eatby`, `sellby`, `batch`, `qty`, `import_key`) VALUES (1,'2025-02-04 11:49:22',5,NULL,NULL,'000000',1,NULL);

--
-- Table structure for table `llx_product_customer_price`
--

CREATE TABLE `llx_product_customer_price` (
  `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,
  `fk_product` int NOT NULL,
  `fk_soc` int NOT 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'HT',
  `default_vat_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `localtax2_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `fk_user` int DEFAULT NULL,
  `price_label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `import_key` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ref_customer` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_customer_price_fk_product_fk_soc` (`fk_product`,`fk_soc`),
  KEY `idx_product_customer_price_fk_user` (`fk_user`),
  KEY `idx_product_customer_price_fk_soc` (`fk_soc`),
  CONSTRAINT `fk_product_customer_price_fk_product` FOREIGN KEY (`fk_product`) REFERENCES `llx_product` (`rowid`),
  CONSTRAINT `fk_product_customer_price_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`),
  CONSTRAINT `fk_product_customer_price_fk_user` FOREIGN KEY (`fk_user`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_product_customer_price`
--


--
-- Table structure for table `llx_product_customer_price_extrafields`
--

CREATE TABLE `llx_product_customer_price_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_product_customer_price_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `llx_product_customer_price_extrafields`
--


--
-- Table structure for table `llx_product_customer_price_log`
--

CREATE TABLE `llx_product_customer_price_log` (
  `rowid` int NOT NULL AUTO_INCREMENT,
  `entity` int NOT NULL DEFAULT '1',
  `datec` datetime DEFAULT NULL,
  `fk_product` int NOT NULL,
  `fk_soc` int NOT NULL DEFAULT '0',
  `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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'HT',
  `default_vat_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `localtax2_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `fk_user` int DEFAULT NULL,
  `price_label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `import_key` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ref_customer` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_product_customer_price_log`
--


--
-- Table structure for table `llx_product_extrafields`
--

CREATE TABLE `llx_product_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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ecommerceng_stockable_product` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '1',
  `ecommerceng_description_1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ecommerceng_short_description_1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ecommerceng_wc_status_1_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ecommerceng_tax_class_1_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ecommerceng_wc_sale_price_1_1` double(24,8) DEFAULT NULL,
  `ecommerceng_wc_date_on_sale_from_1_1` date DEFAULT NULL,
  `ecommerceng_wc_date_on_sale_to_1_1` date DEFAULT NULL,
  `ecommerceng_wc_manage_stock_1_1` int DEFAULT '1',
  `ecommerceng_wc_dont_update_stock_1_1` int DEFAULT '0',
  `app_or_option` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `option_condition` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `availabelforresellers` int DEFAULT NULL,
  `package` int DEFAULT NULL,
  `resource_formula` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `resource_label` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `freeperioddays` int DEFAULT NULL,
  `directaccess` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sshaccesstype` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `typesupport` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `register_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `register_discountcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_template_trialreminder` int DEFAULT NULL,
  `email_template_trialsuspended` int DEFAULT NULL,
  `position` int DEFAULT NULL,
  `ecommerceng_wc_regular_price_1_1` double(24,8) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_extrafields` (`fk_object`)
) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_product_extrafields`
--

INSERT INTO `llx_product_extrafields` (`rowid`, `tms`, `fk_object`, `import_key`, `ecommerceng_stockable_product`, `ecommerceng_description_1`, `ecommerceng_short_description_1`, `ecommerceng_wc_status_1_1`, `ecommerceng_tax_class_1_1`, `ecommerceng_wc_sale_price_1_1`, `ecommerceng_wc_date_on_sale_from_1_1`, `ecommerceng_wc_date_on_sale_to_1_1`, `ecommerceng_wc_manage_stock_1_1`, `ecommerceng_wc_dont_update_stock_1_1`, `app_or_option`, `option_condition`, `availabelforresellers`, `package`, `resource_formula`, `resource_label`, `freeperioddays`, `directaccess`, `sshaccesstype`, `typesupport`, `register_text`, `register_discountcode`, `email_template_trialreminder`, `email_template_trialsuspended`, `position`, `ecommerceng_wc_regular_price_1_1`) VALUES (5,'2023-11-24 03:16:48',8,NULL,'0',NULL,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'2024-03-21 04:16:19',9,NULL,'0',NULL,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'2024-03-21 04:26:04',13,NULL,'0',NULL,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'2024-03-21 04:26:18',12,NULL,'0',NULL,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'2024-03-21 04:26:28',6,NULL,'0',NULL,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'2024-03-21 04:26:45',11,NULL,'0',NULL,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'2024-03-21 04:27:21',15,NULL,'0',NULL,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'2024-03-21 04:27:36',3,NULL,'0',NULL,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'2024-03-21 04:27:45',1,NULL,'0',NULL,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'2024-03-21 04:28:14',5,NULL,'0',NULL,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'2024-03-21 04:33:03',4,NULL,'0',NULL,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'2025-02-04 05:37:46',24,NULL,'1',NULL,NULL,'0',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'2025-02-04 05:38:39',23,NULL,'1',NULL,NULL,'0',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'2025-02-04 11:45:57',25,NULL,'1',NULL,NULL,'0',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,'2025-02-04 11:49:22',22,NULL,'1',NULL,NULL,'0',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'2025-02-11 16:03:09',20,NULL,'1',NULL,NULL,'0',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(71,'2025-03-14 07:31:47',29,NULL,'1',NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(72,'2025-03-14 07:32:25',28,NULL,'1',NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,'2025-03-14 07:35:52',30,NULL,'1',NULL,NULL,'0',NULL,NULL,NULL,NULL,1,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL),(76,'2025-03-14 07:40:30',31,NULL,'1',NULL,NULL,'0',NULL,NULL,NULL,NULL,1,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL),(78,'2025-03-14 07:42:42',32,NULL,'1',NULL,NULL,'0',NULL,NULL,NULL,NULL,1,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL),(83,'2025-03-14 07:50:44',33,NULL,'1',NULL,NULL,'0',NULL,NULL,NULL,NULL,1,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL),(88,'2025-03-14 08:00:08',14,NULL,'0',NULL,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL),(89,'2025-03-14 08:00:44',26,NULL,'1',NULL,NULL,'0',NULL,NULL,NULL,NULL,1,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL),(93,'2025-03-14 08:02:13',27,NULL,'1',NULL,NULL,'0',NULL,NULL,NULL,NULL,1,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL),(96,'2025-04-02 04:15:22',2,NULL,'0',NULL,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL),(98,'2025-04-02 04:51:53',34,NULL,'1',NULL,NULL,'0',NULL,NULL,NULL,NULL,1,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `llx_product_fournisseur_price`
--

CREATE TABLE `llx_product_fournisseur_price` (
  `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,
  `fk_product` int DEFAULT NULL,
  `fk_soc` int DEFAULT NULL,
  `ref_fourn` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `desc_fourn` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `fk_availability` int DEFAULT NULL,
  `price` double(24,8) DEFAULT '0.00000000',
  `quantity` double DEFAULT NULL,
  `remise_percent` double NOT NULL DEFAULT '0',
  `remise` double NOT NULL DEFAULT '0',
  `unitprice` double(24,8) DEFAULT '0.00000000',
  `charges` double(24,8) DEFAULT '0.00000000',
  `default_vat_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `barcode` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fk_barcode_type` int DEFAULT NULL,
  `tva_tx` double(6,3) NOT NULL,
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax1_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `localtax2_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `info_bits` int NOT NULL DEFAULT '0',
  `fk_user` int DEFAULT NULL,
  `fk_supplier_price_expression` int DEFAULT NULL,
  `import_key` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `delivery_time_days` int DEFAULT NULL,
  `supplier_reputation` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `packaging` double DEFAULT NULL,
  `fk_multicurrency` int DEFAULT NULL,
  `multicurrency_code` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT '1.00000000',
  `multicurrency_unitprice` double(24,8) DEFAULT NULL,
  `multicurrency_price` double(24,8) DEFAULT NULL,
  `status` int DEFAULT '1',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_fournisseur_price_ref` (`ref_fourn`,`fk_soc`,`quantity`,`entity`),
  UNIQUE KEY `uk_product_barcode` (`barcode`,`fk_barcode_type`,`entity`),
  KEY `idx_product_fournisseur_price_fk_user` (`fk_user`),
  KEY `idx_product_fourn_price_fk_product` (`fk_product`,`entity`),
  KEY `idx_product_fourn_price_fk_soc` (`fk_soc`,`entity`),
  KEY `idx_product_barcode` (`barcode`),
  KEY `idx_product_fk_barcode_type` (`fk_barcode_type`),
  CONSTRAINT `fk_product_fournisseur_price_barcode_type` FOREIGN KEY (`fk_barcode_type`) REFERENCES `llx_c_barcode_type` (`rowid`),
  CONSTRAINT `fk_product_fournisseur_price_fk_product` FOREIGN KEY (`fk_product`) REFERENCES `llx_product` (`rowid`),
  CONSTRAINT `fk_product_fournisseur_price_fk_user` FOREIGN KEY (`fk_user`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `llx_product_fournisseur_price`
--

INSERT INTO `llx_product_fournisseur_price` (`rowid`, `entity`, `datec`, `tms`, `fk_product`, `fk_soc`, `ref_fourn`, `desc_fourn`, `fk_availability`, `price`, `quantity`, `remise_percent`, `remise`, `unitprice`, `charges`, `default_vat_code`, `barcode`, `fk_barcode_type`, `tva_tx`, `localtax1_tx`, `localtax1_type`, `localtax2_tx`, `localtax2_type`, `info_bits`, `fk_user`, `fk_supplier_price_expression`, `import_key`, `delivery_time_days`, `supplier_reputation`, `packaging`, `fk_multicurrency`, `multicurrency_code`, `multicurrency_tx`, `multicurrency_unitprice`, `multicurrency_price`, `status`) VALUES (2,1,'2025-02-03 23:12:33','2025-02-03 23:12:33',22,26,'TU007','',0,68.90000000,1,0,0,68.90000000,0.00000000,NULL,NULL,NULL,8.500,0.000,'0',0.000,'0',0,3,NULL,NULL,NULL,NULL,NULL,NULL,'',1.00000000,NULL,0.00000000,1),(3,1,'2025-02-03 23:59:53','2025-02-03 23:59:53',23,26,'ST1000DM010','',0,45.00000000,1,0,0,45.00000000,0.00000000,NULL,NULL,NULL,0.000,0.000,'0',0.000,'0',0,3,NULL,NULL,NULL,NULL,NULL,NULL,'',1.00000000,NULL,0.00000000,1),(4,1,'2025-02-04 00:04:52','2025-02-04 00:04:52',24,86,'3303170070789','',0,19.35000000,1,0,0,19.35000000,0.00000000,NULL,NULL,NULL,0.000,0.000,'0',0.000,'0',0,3,NULL,NULL,NULL,NULL,NULL,NULL,'',1.00000000,NULL,0.00000000,1),(5,1,'2025-02-04 00:13:55','2025-02-04 00:13:55',25,71,'LEN_ZG38C02761','',0,20.00000000,1,0,0,20.00000000,0.00000000,NULL,NULL,NULL,8.500,0.000,'0',0.000,'0',0,3,NULL,NULL,NULL,NULL,NULL,NULL,'',1.00000000,NULL,0.00000000,1);

--
