-- Table structure for table `llx_product_price_by_qty`
--

CREATE TABLE `llx_product_price_by_qty` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_product_price` int(11) NOT NULL,
  `price` double(24,8) DEFAULT '0.00000000',
  `price_base_type` varchar(3) COLLATE utf8_unicode_ci DEFAULT 'HT',
  `quantity` double DEFAULT NULL,
  `remise_percent` double NOT NULL DEFAULT '0',
  `remise` double NOT NULL DEFAULT '0',
  `unitprice` double(24,8) DEFAULT '0.00000000',
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT '1.00000000',
  `multicurrency_price` double(24,8) DEFAULT NULL,
  `multicurrency_price_ttc` double(24,8) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_price_by_qty_level` (`fk_product_price`,`quantity`),
  KEY `idx_product_price_by_qty_fk_product_price` (`fk_product_price`),
  CONSTRAINT `fk_product_price_by_qty_fk_product_price` FOREIGN KEY (`fk_product_price`) REFERENCES `llx_product_price` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_product_price_by_qty`
--


--
-- Table structure for table `llx_product_pricerules`
--

CREATE TABLE `llx_product_pricerules` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `level` int(11) NOT NULL,
  `fk_level` int(11) NOT NULL,
  `var_percent` float NOT NULL,
  `var_min_percent` float NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `unique_level` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_product_pricerules`
--


--
-- Table structure for table `llx_product_stock`
--

CREATE TABLE `llx_product_stock` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_product` int(11) NOT NULL,
  `fk_entrepot` int(11) NOT NULL,
  `reel` double DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_stock` (`fk_product`,`fk_entrepot`),
  KEY `idx_product_stock_fk_product` (`fk_product`),
  KEY `idx_product_stock_fk_entrepot` (`fk_entrepot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_product_stock`
--


--
-- Table structure for table `llx_product_warehouse_properties`
--

CREATE TABLE `llx_product_warehouse_properties` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_product` int(11) NOT NULL,
  `fk_entrepot` int(11) NOT NULL,
  `seuil_stock_alerte` int(11) DEFAULT '0',
  `desiredstock` int(11) DEFAULT '0',
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_product_warehouse_properties`
--


--
-- Table structure for table `llx_projet`
--

CREATE TABLE `llx_projet` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_soc` int(11) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `dateo` date DEFAULT NULL,
  `datee` date DEFAULT NULL,
  `ref` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `fk_user_creat` int(11) NOT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `public` int(11) DEFAULT NULL,
  `fk_statut` int(11) NOT NULL DEFAULT '0',
  `fk_opp_status` int(11) DEFAULT NULL,
  `opp_percent` double(5,2) DEFAULT NULL,
  `date_close` datetime DEFAULT NULL,
  `fk_user_close` int(11) DEFAULT NULL,
  `note_private` text COLLATE utf8_unicode_ci,
  `note_public` text COLLATE utf8_unicode_ci,
  `opp_amount` double(24,8) DEFAULT NULL,
  `budget_amount` double(24,8) DEFAULT NULL,
  `bill_time` int(11) DEFAULT '0',
  `model_pdf` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_projet_ref` (`ref`,`entity`),
  KEY `idx_projet_fk_soc` (`fk_soc`),
  CONSTRAINT `fk_projet_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_projet`
--

INSERT INTO `llx_projet` (`rowid`, `fk_soc`, `datec`, `tms`, `dateo`, `datee`, `ref`, `entity`, `title`, `description`, `fk_user_creat`, `fk_user_modif`, `public`, `fk_statut`, `fk_opp_status`, `opp_percent`, `date_close`, `fk_user_close`, `note_private`, `note_public`, `opp_amount`, `budget_amount`, `bill_time`, `model_pdf`, `import_key`) VALUES (2,NULL,'2019-01-21 18:49:38','2019-01-21 18:50:59','2019-01-01',NULL,'PJ1901-0001',1,'BUREAU','',2,NULL,1,1,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(3,NULL,'2019-01-21 19:00:15','2019-01-21 19:01:07','2019-01-01',NULL,'PJ1901-0002',1,'CONSOMMABLES','',2,2,0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(4,NULL,'2019-01-21 19:02:51','2019-01-21 19:03:00','2019-01-01',NULL,'PJ1901-0003',1,'RESTAURATION','',2,NULL,0,1,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(5,NULL,'2019-01-21 19:03:42','2019-01-21 19:03:51','2019-01-01',NULL,'PJ1901-0004',1,'HELENE K LA BOUTIQUE','',2,NULL,0,1,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(6,6,'2019-01-29 10:05:09','2019-01-29 10:05:20','2018-11-10',NULL,'PJ1901-0005',1,'GUILAB','',2,NULL,0,1,6,100.00,NULL,NULL,NULL,NULL,320000000.00000000,NULL,0,NULL,NULL),(7,3,'2019-02-07 19:28:33','2019-02-07 19:28:54','2019-01-01',NULL,'PJ1902-0006',1,'LOCATION BUREAU','',2,NULL,0,1,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(8,31,'2019-03-08 16:49:55','2019-03-08 16:51:11','2019-03-08',NULL,'PJ1903-0007',1,'Maintenance Hôtel MLYS','',2,NULL,0,1,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(9,29,'2019-03-13 11:04:53','2019-03-13 11:04:53','2019-03-12','2019-04-09','PJ1903-0008',1,'MINIERE REBOUL ','',2,NULL,0,1,6,100.00,NULL,NULL,NULL,NULL,103298380.00000000,NULL,0,NULL,NULL),(10,26,'2019-03-18 14:44:25','2019-03-18 14:44:38','2019-03-18',NULL,'PJ1903-0009',1,'E2CI-CAPAGO','',2,NULL,0,1,6,100.00,NULL,NULL,NULL,NULL,NULL,362920014.00000000,0,NULL,NULL),(11,35,'2019-04-13 14:49:38','2019-04-13 14:50:14','2019-04-15','2019-05-31','PJ1904-0010',1,'Webb Fontaine','',2,NULL,0,1,6,100.00,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL);

--
-- Table structure for table `llx_projet_extrafields`
--

CREATE TABLE `llx_projet_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_projet_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_projet_extrafields`
--


--
-- Table structure for table `llx_projet_task`
--

CREATE TABLE `llx_projet_task` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `fk_projet` int(11) NOT NULL,
  `fk_task_parent` int(11) NOT NULL DEFAULT '0',
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `dateo` datetime DEFAULT NULL,
  `datee` datetime DEFAULT NULL,
  `datev` datetime DEFAULT NULL,
  `label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `duration_effective` double DEFAULT '0',
  `planned_workload` double DEFAULT '0',
  `progress` int(11) DEFAULT '0',
  `priority` int(11) DEFAULT '0',
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `fk_statut` smallint(6) NOT NULL DEFAULT '0',
  `note_private` text COLLATE utf8_unicode_ci,
  `note_public` text COLLATE utf8_unicode_ci,
  `rang` int(11) DEFAULT '0',
  `model_pdf` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_projet_task_ref` (`ref`,`entity`),
  KEY `idx_projet_task_fk_projet` (`fk_projet`),
  KEY `idx_projet_task_fk_user_creat` (`fk_user_creat`),
  KEY `idx_projet_task_fk_user_valid` (`fk_user_valid`),
  CONSTRAINT `fk_projet_task_fk_projet` FOREIGN KEY (`fk_projet`) REFERENCES `llx_projet` (`rowid`),
  CONSTRAINT `fk_projet_task_fk_user_creat` FOREIGN KEY (`fk_user_creat`) REFERENCES `llx_user` (`rowid`),
  CONSTRAINT `fk_projet_task_fk_user_valid` FOREIGN KEY (`fk_user_valid`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_projet_task`
--


--
-- Table structure for table `llx_projet_task_extrafields`
--

CREATE TABLE `llx_projet_task_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_projet_task_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_projet_task_extrafields`
--


--
-- Table structure for table `llx_projet_task_time`
--

CREATE TABLE `llx_projet_task_time` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_task` int(11) NOT NULL,
  `task_date` date DEFAULT NULL,
  `task_datehour` datetime DEFAULT NULL,
  `task_date_withhour` int(11) DEFAULT '0',
  `task_duration` double DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `thm` double(24,8) DEFAULT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  `invoice_line_id` int(11) DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `datec` date DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `note` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`rowid`),
  KEY `idx_projet_task_time_task` (`fk_task`),
  KEY `idx_projet_task_time_date` (`task_date`),
  KEY `idx_projet_task_time_datehour` (`task_datehour`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_projet_task_time`
--


--
-- Table structure for table `llx_propal`
--

CREATE TABLE `llx_propal` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `ref_ext` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref_int` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref_client` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_soc` int(11) DEFAULT NULL,
  `fk_projet` int(11) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `datep` date DEFAULT NULL,
  `fin_validite` datetime DEFAULT NULL,
  `date_valid` datetime DEFAULT NULL,
  `date_cloture` datetime DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `fk_user_cloture` int(11) DEFAULT NULL,
  `fk_statut` smallint(6) NOT NULL DEFAULT '0',
  `price` double DEFAULT '0',
  `remise_percent` double DEFAULT '0',
  `remise_absolue` double DEFAULT '0',
  `remise` double DEFAULT '0',
  `total_ht` double(24,8) DEFAULT '0.00000000',
  `tva` double(24,8) DEFAULT '0.00000000',
  `localtax1` double(24,8) DEFAULT '0.00000000',
  `localtax2` double(24,8) DEFAULT '0.00000000',
  `total` double(24,8) DEFAULT '0.00000000',
  `fk_account` int(11) DEFAULT NULL,
  `fk_currency` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_cond_reglement` int(11) DEFAULT NULL,
  `fk_mode_reglement` int(11) DEFAULT NULL,
  `note_private` text COLLATE utf8_unicode_ci,
  `note_public` text COLLATE utf8_unicode_ci,
  `model_pdf` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_main_doc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_livraison` date DEFAULT NULL,
  `fk_shipping_method` int(11) DEFAULT NULL,
  `fk_availability` int(11) DEFAULT NULL,
  `fk_input_reason` int(11) DEFAULT NULL,
  `fk_incoterms` int(11) DEFAULT NULL,
  `location_incoterms` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `extraparams` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_delivery_address` int(11) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT '1.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`),
  UNIQUE KEY `uk_propal_ref` (`ref`,`entity`),
  KEY `idx_propal_fk_soc` (`fk_soc`),
  KEY `idx_propal_fk_user_author` (`fk_user_author`),
  KEY `idx_propal_fk_user_valid` (`fk_user_valid`),
  KEY `idx_propal_fk_user_cloture` (`fk_user_cloture`),
  KEY `idx_propal_fk_projet` (`fk_projet`),
  KEY `idx_propal_fk_account` (`fk_account`),
  KEY `idx_propal_fk_currency` (`fk_currency`),
  CONSTRAINT `fk_propal_fk_projet` FOREIGN KEY (`fk_projet`) REFERENCES `llx_projet` (`rowid`),
  CONSTRAINT `fk_propal_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`),
  CONSTRAINT `fk_propal_fk_user_author` FOREIGN KEY (`fk_user_author`) REFERENCES `llx_user` (`rowid`),
  CONSTRAINT `fk_propal_fk_user_cloture` FOREIGN KEY (`fk_user_cloture`) REFERENCES `llx_user` (`rowid`),
  CONSTRAINT `fk_propal_fk_user_valid` FOREIGN KEY (`fk_user_valid`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_propal`
--

INSERT INTO `llx_propal` (`rowid`, `ref`, `entity`, `ref_ext`, `ref_int`, `ref_client`, `fk_soc`, `fk_projet`, `tms`, `datec`, `datep`, `fin_validite`, `date_valid`, `date_cloture`, `fk_user_author`, `fk_user_modif`, `fk_user_valid`, `fk_user_cloture`, `fk_statut`, `price`, `remise_percent`, `remise_absolue`, `remise`, `total_ht`, `tva`, `localtax1`, `localtax2`, `total`, `fk_account`, `fk_currency`, `fk_cond_reglement`, `fk_mode_reglement`, `note_private`, `note_public`, `model_pdf`, `last_main_doc`, `date_livraison`, `fk_shipping_method`, `fk_availability`, `fk_input_reason`, `fk_incoterms`, `location_incoterms`, `import_key`, `extraparams`, `fk_delivery_address`, `fk_multicurrency`, `multicurrency_code`, `multicurrency_tx`, `multicurrency_total_ht`, `multicurrency_total_tva`, `multicurrency_total_ttc`) VALUES (1,'PR1901-0003',1,NULL,NULL,'',7,NULL,'2019-02-07 17:55:10','2019-01-19 16:07:38','2019-01-19','2019-02-18 12:00:00','2019-02-07 17:53:07',NULL,2,NULL,2,NULL,0,0,NULL,NULL,0,66997010.00000000,12059461.80000000,0.00000000,0.00000000,79056471.79999998,NULL,NULL,6,NULL,'','','azur','propale/PR1901-0003/PR1901-0003.pdf',NULL,NULL,2,8,0,'',NULL,NULL,NULL,0,'GNF',1.00000000,66997010.00000000,12059461.80000000,79056471.80000000),(2,'PR1901-0001',1,NULL,NULL,'',20,NULL,'2019-02-22 18:26:36','2019-01-22 17:24:43','2019-01-22','2019-02-21 12:00:00','2019-02-22 18:26:19','2019-02-22 18:26:36',2,NULL,2,2,2,0,NULL,NULL,0,4930518.45000000,887493.32000000,0.00000000,0.00000000,5818011.77000000,NULL,NULL,1,NULL,'','','azur','propale/PR1901-0001/PR1901-0001.pdf',NULL,NULL,3,0,0,'',NULL,NULL,NULL,0,'GNF',1.00000000,4930518.45000000,887493.32000000,5818011.77000000),(3,'PR1901-0002',1,NULL,NULL,'',22,NULL,'2019-03-01 13:22:44','2019-01-26 16:36:36','2019-01-26','2019-02-25 12:00:00','2019-02-01 11:05:36','2019-03-01 13:22:44',2,NULL,2,2,2,0,NULL,NULL,0,1606000.00000000,289080.00000000,0.00000000,0.00000000,1895080.00000000,NULL,NULL,6,NULL,'','','azur','propale/PR1901-0002/PR1901-0002.pdf',NULL,NULL,2,0,0,'',NULL,NULL,NULL,0,'GNF',1.00000000,1606000.00000000,289080.00000000,1895080.00000000),(4,'PR1902-0004',1,NULL,NULL,'',26,NULL,'2019-04-29 12:58:04','2019-02-18 11:19:21','2019-02-18','2019-03-20 12:00:00','2019-03-19 18:52:13','2019-04-29 12:58:04',2,NULL,2,2,2,0,NULL,NULL,0,348957014.00000000,62812262.52000000,0.00000000,0.00000000,411769276.52000000,NULL,NULL,15,NULL,'','','azur','propale/PR1902-0004/PR1902-0004.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,0,'EUR',0.00009615,33552.21689610,6039.39904130,39591.61593740),(5,'PR1902-0005',1,NULL,NULL,'',28,NULL,'2019-02-25 17:16:59','2019-02-25 16:33:20','2019-02-25','2019-03-27 12:00:00','2019-02-25 17:16:59',NULL,2,NULL,2,NULL,1,0,NULL,NULL,0,40458200.00000000,7282476.00000000,0.00000000,0.00000000,47740676.00000000,NULL,NULL,1,NULL,'','','azur','propale/PR1902-0005/PR1902-0005.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,0,'GNF',1.00000000,40458200.00000000,7282476.00000000,47740676.00000000),(6,'PR1902-0006',1,NULL,NULL,'',29,NULL,'2019-03-13 11:08:08','2019-02-28 16:01:44','2019-02-28','2019-03-30 12:00:00','2019-03-12 09:55:45','2019-03-13 11:08:08',2,NULL,2,2,2,0,NULL,NULL,0,87541000.00000000,15757380.00000000,0.00000000,0.00000000,103298380.00000000,NULL,NULL,13,NULL,'12/03/2019\n12/03/2019','','azur','propale/PR1902-0006/PR1902-0006.pdf',NULL,NULL,1,0,0,'',NULL,NULL,NULL,0,'GNF',1.00000000,87541000.00000000,15757380.00000000,103298380.00000000),(7,'PR1903-0007',1,NULL,NULL,'',29,NULL,'2019-03-08 10:43:09','2019-03-08 10:40:52','2019-03-08','2019-04-07 12:00:00','2019-03-08 10:43:08',NULL,2,NULL,2,NULL,1,0,NULL,NULL,0,18500000.00000000,3330000.00000000,0.00000000,0.00000000,21830000.00000000,NULL,NULL,1,NULL,'','','azur','propale/PR1903-0007/PR1903-0007.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,0,'GNF',1.00000000,18500000.00000000,3330000.00000000,21830000.00000000),(8,'PR1903-0008',1,NULL,NULL,'',31,8,'2019-03-25 17:17:23','2019-03-08 16:51:42','2019-03-08','2019-04-07 12:00:00','2019-03-25 17:17:12','2019-03-25 17:17:23',2,NULL,2,2,2,0,NULL,NULL,0,1050000.00000000,189000.00000000,0.00000000,0.00000000,1239000.00000000,NULL,NULL,1,NULL,'','','azur','propale/PR1903-0008/PR1903-0008.pdf',NULL,NULL,2,0,0,'',NULL,NULL,NULL,0,'GNF',1.00000000,1050000.00000000,189000.00000000,1239000.00000000),(9,'PR1903-0009',1,NULL,NULL,'',32,NULL,'2019-03-13 19:48:00','2019-03-11 15:04:32','2019-03-11','2019-04-10 12:00:00','2019-03-13 19:48:00',NULL,2,NULL,2,NULL,1,0,NULL,NULL,0,55800000.00000000,10044000.00000000,0.00000000,0.00000000,65844000.00000000,NULL,NULL,1,NULL,'','','azur','propale/PR1903-0009/PR1903-0009.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,0,'GNF',1.00000000,55800000.00000000,10044000.00000000,65844000.00000000),(10,'PR1903-0010',1,NULL,NULL,'',31,8,'2019-03-11 16:24:59','2019-03-11 16:08:53','2019-03-11','2019-04-10 12:00:00','2019-03-11 16:24:59',NULL,2,NULL,2,NULL,1,0,NULL,NULL,0,13750000.00000000,2475000.00000000,0.00000000,0.00000000,16225000.00000000,NULL,NULL,14,NULL,'','','azur','propale/PR1903-0010/PR1903-0010.pdf',NULL,NULL,2,0,0,'',NULL,NULL,NULL,0,'GNF',1.00000000,13750000.00000000,2475000.00000000,16225000.00000000),(11,'(PROV11)',1,NULL,NULL,'',33,NULL,'2019-03-11 17:06:25','2019-03-11 16:44:05','2019-03-11','2019-04-10 12:00:00',NULL,NULL,2,NULL,NULL,NULL,0,0,NULL,NULL,0,199683800.00000000,35943084.00000000,0.00000000,0.00000000,235626884.00000000,NULL,NULL,1,NULL,'','','azur','propale/(PROV11)/(PROV11).pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,0,'GNF',1.00000000,199683800.00000000,35943084.00000000,235626884.00000000),(12,'PR1903-0012',1,NULL,NULL,'',35,11,'2019-04-13 14:53:01','2019-03-23 14:54:38','2019-03-23','2019-04-22 12:00:00','2019-04-13 14:36:57','2019-04-13 14:38:32',2,NULL,2,2,2,0,NULL,NULL,0,677547068.00000000,121958472.24000000,0.00000000,0.00000000,799505540.24000000,NULL,NULL,16,NULL,'','','azur','propale/PR1903-0012/PR1903-0012.pdf','2019-05-31',NULL,0,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,677547068.00000000,121958472.24000000,799505540.24000000),(13,'PR1903-0011',1,NULL,NULL,'',5,NULL,'2019-05-27 17:23:09','2019-03-23 16:37:35','2019-03-23','2019-04-22 12:00:00','2019-05-27 17:20:48','2019-05-27 17:23:09',2,NULL,2,2,2,0,NULL,NULL,0,48346250.00000000,8702325.00000000,0.00000000,0.00000000,57048575.00000000,NULL,NULL,14,NULL,'','','azur','propale/PR1903-0011/PR1903-0011.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,48346250.00000000,8702325.00000000,57048575.00000000),(14,'PR1903-0013',1,NULL,NULL,'',35,11,'2019-04-13 14:55:10','2019-03-27 14:50:54','2019-03-27','2019-04-26 12:00:00','2019-04-11 17:52:24','2019-04-13 14:55:10',2,NULL,2,2,2,0,NULL,NULL,0,761325110.00000000,137038519.79999998,0.00000000,0.00000000,898363629.80000000,NULL,NULL,14,NULL,'','','azur','propale/PR1903-0013/PR1903-0013.pdf','2019-05-31',NULL,1,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,761325110.00000000,137038519.80000000,898363629.80000000),(15,'PR1904-0014',1,NULL,NULL,'',36,NULL,'2019-04-09 10:26:21','2019-04-04 17:56:34','2019-04-04','2019-05-04 12:00:00','2019-04-09 10:26:21',NULL,2,NULL,2,NULL,1,0,NULL,NULL,0,503660941.16000000,90658969.45000000,0.00000000,0.00000000,594319910.81000000,NULL,NULL,13,NULL,'','','azur','propale/PR1904-0014/PR1904-0014.pdf',NULL,NULL,4,8,0,'',NULL,NULL,NULL,2,'EUR',0.00009615,48427.00000000,8716.86000000,57143.86000000),(16,'PR1904-0015',1,NULL,NULL,'',29,9,'2019-05-13 14:24:57','2019-04-08 16:51:00','2019-04-08','2019-05-08 12:00:00','2019-04-10 16:51:44','2019-05-13 14:24:57',2,NULL,2,2,2,0,NULL,NULL,0,13075000.00000000,2353500.00000000,0.00000000,0.00000000,15428500.00000000,NULL,NULL,1,NULL,'','','azur','propale/PR1904-0015/PR1904-0015.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,13075000.00000000,2353500.00000000,15428500.00000000),(17,'PR1904-0016',1,NULL,NULL,'',37,NULL,'2019-04-08 17:27:32','2019-04-08 17:22:11','2019-04-08','2019-05-08 12:00:00','2019-04-08 17:27:31',NULL,2,NULL,2,NULL,1,0,NULL,NULL,0,8455590.00000000,1522006.20000000,0.00000000,0.00000000,9977596.20000000,NULL,NULL,8,NULL,'','','azur','propale/PR1904-0016/PR1904-0016.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,8455590.00000000,1522006.20000000,9977596.20000000),(18,'(PROV18)',1,NULL,NULL,'',35,11,'2019-04-13 14:53:27','2019-04-13 14:33:02','2019-04-13','2019-05-13 12:00:00',NULL,NULL,2,NULL,NULL,NULL,0,0,NULL,NULL,0,375253200.00000000,67545576.00000000,0.00000000,0.00000000,442798776.00000000,NULL,NULL,13,NULL,'','','azur','propale/(PROV18)/(PROV18).pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,375253200.00000000,67545576.00000000,442798776.00000000),(19,'PR1904-0017',1,NULL,NULL,'',35,11,'2019-05-14 17:39:15','2019-04-13 15:02:07','2019-04-13','2019-05-13 12:00:00','2019-05-14 17:22:48','2019-05-14 17:29:15',2,NULL,2,2,0,0,NULL,NULL,0,148768100.00000000,26778258.00000000,0.00000000,0.00000000,175546358.00000000,NULL,NULL,13,NULL,'','','azur','propale/PR1904-0017/PR1904-0017.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,148768100.00000000,26778258.00000000,175546358.00000000),(20,'PR1904-0019',1,NULL,NULL,'',35,11,'2019-04-24 14:30:33','2019-04-18 09:28:05','2019-04-24','2019-05-24 12:00:00','2019-04-24 14:29:12','2019-04-24 14:30:33',2,NULL,2,2,2,0,NULL,NULL,0,105859159.00000000,19054648.62000000,0.00000000,0.00000000,124913807.62000000,NULL,NULL,13,NULL,'FACTURE','','azur','propale/PR1904-0019/PR1904-0019.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,105859159.00000000,19054648.62000000,124913807.62000000),(21,'PR1904-0018',1,NULL,NULL,'',6,NULL,'2019-04-29 16:52:38','2019-04-24 12:29:36','2019-04-24','2019-05-24 12:00:00','2019-04-29 16:52:38',NULL,2,NULL,2,NULL,1,0,NULL,NULL,0,38055600.00000000,6850008.00000000,0.00000000,0.00000000,44905608.00000000,NULL,NULL,13,NULL,'','','azur','propale/PR1904-0018/PR1904-0018.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,38055600.00000000,6850008.00000000,44905608.00000000),(24,'PR1904-0020',1,NULL,NULL,'',35,11,'2019-05-03 17:07:01','2019-04-30 12:04:29','2019-04-30','2019-05-30 12:00:00','2019-05-03 17:07:01',NULL,2,NULL,2,NULL,1,0,NULL,NULL,0,357815250.00000000,64406745.00000000,0.00000000,0.00000000,422221995.00000000,NULL,NULL,14,7,'','','azur','propale/PR1904-0020/PR1904-0020.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,357815250.00000000,64406745.00000000,422221995.00000000),(26,'PR1905-0022',1,NULL,NULL,'',38,NULL,'2019-05-06 19:21:40','2019-05-06 18:55:49','2019-05-06','2019-06-05 12:00:00','2019-05-06 19:21:39',NULL,2,NULL,2,NULL,1,0,NULL,NULL,0,17236000.00000000,3102480.00000000,0.00000000,0.00000000,20338480.00000000,NULL,NULL,14,NULL,'','','azur','propale/PR1905-0022/PR1905-0022.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,17236000.00000000,3102480.00000000,20338480.00000000),(27,'PR1905-0023',1,NULL,NULL,'',39,NULL,'2019-05-22 13:09:03','2019-05-06 19:24:14','2019-05-06','2019-06-05 12:00:00','2019-05-22 13:09:03',NULL,2,NULL,2,NULL,1,0,NULL,NULL,0,32968000.00000000,5934240.00000000,0.00000000,0.00000000,38902240.00000000,NULL,NULL,14,NULL,'','','azur','propale/PR1905-0023/PR1905-0023.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,32968000.00000000,5934240.00000000,38902240.00000000),(28,'PR1905-0024',1,NULL,NULL,'',29,9,'2019-05-15 18:02:50','2019-05-11 16:06:12','2019-05-11','2019-06-10 12:00:00','2019-05-11 16:10:07','2019-05-15 18:02:50',2,NULL,2,2,3,0,NULL,NULL,0,2988000.00000000,537840.00000000,0.00000000,0.00000000,3525840.00000000,NULL,NULL,1,NULL,'Travaux réalisé par le propriétaire Mr KEITA','','azur','propale/PR1905-0024/PR1905-0024.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,2988000.00000000,537840.00000000,3525840.00000000),(29,'PR1905-0025',1,NULL,NULL,'',40,10,'2019-05-13 19:13:52','2019-05-13 18:53:37','2019-05-13','2019-06-12 12:00:00','2019-05-13 19:13:52',NULL,2,NULL,2,NULL,1,0,NULL,NULL,0,12485295.00000000,2247353.10000000,0.00000000,0.00000000,14732648.10000000,NULL,NULL,14,NULL,'','','azur','propale/PR1905-0025/PR1905-0025.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,12485295.00000000,2247353.10000000,14732648.10000000),(30,'PR1905-0026',1,NULL,NULL,'',26,10,'2019-05-14 10:13:39','2019-05-14 10:04:20','2019-05-14','2019-06-13 12:00:00','2019-05-14 10:13:39',NULL,2,NULL,2,NULL,1,0,NULL,NULL,0,36827994.00000000,6629038.92000000,0.00000000,0.00000000,43457032.92000000,NULL,NULL,1,NULL,'','','azur','propale/PR1905-0026/PR1905-0026.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,36827994.00000000,6629038.92000000,43457032.92000000),(31,'PR1905-0027',1,NULL,NULL,'',6,NULL,'2019-05-14 17:17:58','2019-05-14 14:18:15','2019-05-14','2019-06-13 12:00:00','2019-05-14 17:17:58',NULL,2,NULL,2,NULL,1,0,NULL,NULL,0,279207500.00000000,50257350.00000000,0.00000000,0.00000000,329464850.00000000,NULL,NULL,15,NULL,'','','azur','propale/PR1905-0027/PR1905-0027.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,279207500.00000000,50257350.00000000,329464850.00000000),(33,'PR1905-0028',1,NULL,NULL,'',35,11,'2019-05-14 18:22:40','2019-05-14 18:17:01','2019-05-14','2019-06-13 12:00:00','2019-05-14 18:22:11','2019-05-14 18:22:40',2,NULL,2,2,2,0,NULL,NULL,0,695924770.69000000,0.00000000,0.00000000,0.00000000,695924770.69000000,NULL,NULL,17,7,'','MOBILIER DE BUREAU','azur','propale/PR1905-0028/PR1905-0028.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,695924770.69000000,0.00000000,695924770.69000000),(34,'PR1905-0029',1,NULL,NULL,'',29,9,'2019-05-15 17:55:47','2019-05-15 17:34:44','2019-05-15','2019-06-14 12:00:00','2019-05-15 17:55:47',NULL,2,NULL,2,NULL,1,0,NULL,NULL,0,10180000.00000000,1832400.00000000,0.00000000,0.00000000,12012400.00000000,NULL,NULL,17,NULL,'','','azur','propale/PR1905-0029/PR1905-0029.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,10180000.00000000,1832400.00000000,12012400.00000000),(35,'PR1905-0030',1,NULL,NULL,'',40,NULL,'2019-05-17 14:38:56','2019-05-17 14:17:05','2019-05-17','2019-06-16 14:17:05','2019-05-17 14:38:56',NULL,2,NULL,2,NULL,1,0,NULL,NULL,0,22446590.40000000,4040386.27000000,0.00000000,0.00000000,26486976.67000000,NULL,NULL,14,NULL,'','','azur','propale/PR1905-0030/PR1905-0030.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,22446590.40000000,4040386.27000000,26486976.67000000),(36,'PR1905-0031',1,NULL,NULL,'',35,11,'2019-05-23 16:52:55','2019-05-20 16:26:21','2019-05-20','2019-06-19 12:00:00','2019-05-23 16:52:55',NULL,2,NULL,2,NULL,1,0,NULL,NULL,0,31500000.00000000,5670000.00000000,0.00000000,0.00000000,37170000.00000000,NULL,NULL,1,NULL,'','','azur','propale/PR1905-0031/PR1905-0031.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,31500000.00000000,5670000.00000000,37170000.00000000),(37,'PR1905-0032',1,NULL,NULL,'',35,11,'2019-05-24 17:45:15','2019-05-20 16:43:57','2019-05-20','2019-06-19 12:00:00','2019-05-24 16:18:20','2019-05-24 17:45:15',2,NULL,2,2,2,0,NULL,NULL,0,52140000.00000000,9385200.00000000,0.00000000,0.00000000,61525200.00000000,NULL,NULL,17,NULL,'','','azur','propale/PR1905-0032/PR1905-0032.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,52140000.00000000,9385200.00000000,61525200.00000000),(38,'PR1905-0033',1,NULL,NULL,'',35,11,'2019-05-22 16:29:27','2019-05-22 16:23:38','2019-05-22','2019-06-21 16:23:38','2019-05-22 16:29:27',NULL,2,NULL,2,NULL,1,0,NULL,NULL,0,39600000.00000000,7128000.00000000,0.00000000,0.00000000,46728000.00000000,NULL,NULL,14,7,'','','azur','propale/PR1905-0033/PR1905-0033.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,39600000.00000000,7128000.00000000,46728000.00000000),(39,'PR1905-0034',1,NULL,NULL,'',41,NULL,'2019-05-24 16:41:36','2019-05-23 17:42:15','2019-05-23','2019-06-22 12:00:00','2019-05-24 16:41:36',NULL,2,NULL,2,NULL,1,0,NULL,NULL,0,192400000.00000000,34632000.00000000,0.00000000,0.00000000,227032000.00000000,NULL,NULL,1,NULL,'','','azur','propale/PR1905-0034/PR1905-0034.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,192400000.00000000,34632000.00000000,227032000.00000000),(40,'PR1905-0035',1,NULL,NULL,'',42,NULL,'2019-05-24 17:32:54','2019-05-24 16:48:03','2019-05-24','2019-06-23 12:00:00','2019-05-24 17:32:54',NULL,2,NULL,2,NULL,1,0,NULL,NULL,0,92500000.00000000,16650000.00000000,0.00000000,0.00000000,109150000.00000000,NULL,NULL,1,NULL,'','','azur','propale/PR1905-0035/PR1905-0035.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,92500000.00000000,16650000.00000000,109150000.00000000),(41,'PR1905-0036',1,NULL,NULL,'',35,11,'2019-05-24 17:44:15','2019-05-24 17:35:39','2019-05-24','2019-06-23 12:00:00','2019-05-24 17:44:14',NULL,2,NULL,2,NULL,1,0,NULL,NULL,0,25260000.00000000,4546800.00000000,0.00000000,0.00000000,29806800.00000000,NULL,NULL,13,NULL,'','','azur','propale/PR1905-0036/PR1905-0036.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,25260000.00000000,4546800.00000000,29806800.00000000),(42,'PR1905-0037',1,NULL,NULL,'',43,NULL,'2019-05-27 11:20:53','2019-05-27 10:45:48','2019-05-27','2019-06-26 12:00:00','2019-05-27 11:20:53',NULL,2,NULL,2,NULL,1,0,NULL,NULL,0,44020000.00000000,7923600.00000000,0.00000000,0.00000000,51943600.00000000,NULL,NULL,13,NULL,'','','azur','propale/PR1905-0037/PR1905-0037.pdf',NULL,NULL,0,0,0,'',NULL,NULL,NULL,1,'GNF',1.00000000,44020000.00000000,7923600.00000000,51943600.00000000);

--
-- Table structure for table `llx_propal_extrafields`
--

CREATE TABLE `llx_propal_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_propal_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_propal_extrafields`
--


--
-- Table structure for table `llx_propal_merge_pdf_product`
--

CREATE TABLE `llx_propal_merge_pdf_product` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_product` int(11) NOT NULL,
  `file_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `lang` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_mod` int(11) NOT NULL,
  `datec` datetime NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_propal_merge_pdf_product`
--


--
-- Table structure for table `llx_propaldet`
--

CREATE TABLE `llx_propaldet` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_propal` int(11) NOT NULL,
  `fk_parent_line` int(11) DEFAULT NULL,
  `fk_product` int(11) DEFAULT NULL,
  `label` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `fk_remise_except` int(11) DEFAULT NULL,
  `vat_src_code` varchar(10) COLLATE utf8_unicode_ci DEFAULT '',
  `tva_tx` double(6,3) DEFAULT '0.000',
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax1_type` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `localtax2_type` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `qty` double DEFAULT NULL,
  `remise_percent` double DEFAULT '0',
  `remise` double DEFAULT '0',
  `price` double DEFAULT NULL,
  `subprice` double(24,8) DEFAULT '0.00000000',
  `total_ht` double(24,8) DEFAULT '0.00000000',
  `total_tva` double(24,8) DEFAULT '0.00000000',
  `total_localtax1` double(24,8) DEFAULT '0.00000000',
  `total_localtax2` double(24,8) DEFAULT '0.00000000',
  `total_ttc` double(24,8) DEFAULT '0.00000000',
  `product_type` int(11) DEFAULT '0',
  `date_start` datetime DEFAULT NULL,
  `date_end` datetime DEFAULT NULL,
  `info_bits` int(11) DEFAULT '0',
  `buy_price_ht` double(24,8) DEFAULT '0.00000000',
  `fk_product_fournisseur_price` int(11) DEFAULT NULL,
  `special_code` int(11) DEFAULT '0',
  `rang` int(11) DEFAULT '0',
  `fk_unit` int(11) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `multicurrency_subprice` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ht` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_tva` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ttc` double(24,8) DEFAULT '0.00000000',
  PRIMARY KEY (`rowid`),
  KEY `idx_propaldet_fk_propal` (`fk_propal`),
  KEY `idx_propaldet_fk_product` (`fk_product`),
  KEY `fk_propaldet_fk_unit` (`fk_unit`),
  CONSTRAINT `fk_propaldet_fk_propal` FOREIGN KEY (`fk_propal`) REFERENCES `llx_propal` (`rowid`),
  CONSTRAINT `fk_propaldet_fk_unit` FOREIGN KEY (`fk_unit`) REFERENCES `llx_c_units` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=263 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_propaldet`
--

INSERT INTO `llx_propaldet` (`rowid`, `fk_propal`, `fk_parent_line`, `fk_product`, `label`, `description`, `fk_remise_except`, `vat_src_code`, `tva_tx`, `localtax1_tx`, `localtax1_type`, `localtax2_tx`, `localtax2_type`, `qty`, `remise_percent`, `remise`, `price`, `subprice`, `total_ht`, `total_tva`, `total_localtax1`, `total_localtax2`, `total_ttc`, `product_type`, `date_start`, `date_end`, `info_bits`, `buy_price_ht`, `fk_product_fournisseur_price`, `special_code`, `rang`, `fk_unit`, `fk_multicurrency`, `multicurrency_code`, `multicurrency_subprice`, `multicurrency_total_ht`, `multicurrency_total_tva`, `multicurrency_total_ttc`) VALUES (1,1,NULL,NULL,NULL,'Fourniture et r&eacute;alisation des moulures murales en pl&acirc;tre &quot;STAFF&quot; (ml)',NULL,'TVA',18.000,0.000,'1',0.000,'0',590,0,0,45000,45000.00000000,26550000.00000000,4779000.00000000,0.00000000,0.00000000,31329000.00000000,0,NULL,NULL,0,40000.00000000,NULL,0,1,NULL,NULL,'GNF',45000.00000000,26550000.00000000,4779000.00000000,31329000.00000000),(7,3,NULL,NULL,NULL,'Fourniture et r&eacute;alisation d&#39;un enduit de finition puis pon&ccedil;age sur la totalit&eacute; du mur impact&eacute; par l&#39;humidit&eacute; dans le salon&nbsp; (m2)',NULL,'TVA',18.000,0.000,'1',0.000,'0',10,0,0,50000,50000.00000000,500000.00000000,90000.00000000,0.00000000,0.00000000,590000.00000000,0,NULL,NULL,0,0.00000000,NULL,0,1,NULL,NULL,'GNF',50000.00000000,500000.00000000,90000.00000000,590000.00000000),(8,3,NULL,NULL,NULL,'Fourniture et application d&#39;une peinture de plafond dans la chambre (m2)',NULL,'TVA',18.000,0.000,'1',0.000,'0',16,0,0,NULL,17000.00000000,272000.00000000,48960.00000000,0.00000000,0.00000000,320960.00000000,0,NULL,NULL,0,0.00000000,NULL,0,2,NULL,NULL,'GNF',17000.00000000,272000.00000000,48960.00000000,320960.00000000),(9,3,NULL,NULL,NULL,'Founiture et application d&#39;une peinture de finition E5-58 sur les murs marrons de la chambre (m2)',NULL,'TVA',18.000,0.000,'1',0.000,'0',17,0,0,NULL,27000.00000000,459000.00000000,82620.00000000,0.00000000,0.00000000,541620.00000000,0,NULL,NULL,0,0.00000000,NULL,0,3,NULL,NULL,'GNF',27000.00000000,459000.00000000,82620.00000000,541620.00000000),(10,3,NULL,NULL,NULL,'Fourniture et application d&#39;une peinture de finition E8-16 sur le mur placo du salon + de chaque c&ocirc;t&eacute; de la porte d&#39;entr&eacute;e (m2)',NULL,'TVA',18.000,0.000,'1',0.000,'0',15,0,0,NULL,25000.00000000,375000.00000000,67500.00000000,0.00000000,0.00000000,442500.00000000,0,NULL,NULL,0,0.00000000,NULL,0,4,NULL,NULL,'GNF',25000.00000000,375000.00000000,67500.00000000,442500.00000000),(20,2,NULL,25,NULL,'Application d&#39;une couche de peinture de finition blanche mat (m2)<br />\r\n(Pays d&#39;origine: Guin&eacute;e)',NULL,'TVA',18.000,0.000,'1',0.000,'0',26,0,0,12786,12786.00000000,332436.00000000,59838.48000000,0.00000000,0.00000000,392274.48000000,0,NULL,NULL,0,10654.00000000,NULL,0,3,NULL,NULL,'GNF',12786.00000000,332436.00000000,59838.48000000,392274.48000000),(22,2,NULL,26,NULL,'',NULL,'TVA',18.000,0.000,'1',0.000,'0',26,0,0,11000,11000.00000000,286000.00000000,51480.00000000,0.00000000,0.00000000,337480.00000000,1,NULL,NULL,0,6000.00000000,NULL,0,4,NULL,NULL,'GNF',11000.00000000,286000.00000000,51480.00000000,337480.00000000),(26,2,NULL,23,NULL,'R&eacute;alisation d&#39;une cloison deux faces en parement simple BA13 Standart (m2)',NULL,'TVA',18.000,0.000,'1',0.000,'0',13,5,16926.35,321600.65,338527.00000000,4180808.45000000,752545.52000000,0.00000000,0.00000000,4933353.97000000,0,NULL,NULL,0,241805.00000000,NULL,0,1,NULL,NULL,'GNF',338527.00000000,4180808.45000000,752545.52000000,4933353.97000000),(27,2,NULL,24,NULL,'Application d&#39;une sous-couche pour placo-pl&acirc;tre (m2)<br />\r\n(Pays d&#39;origine: Guin&eacute;e)',NULL,'TVA',18.000,0.000,'1',0.000,'0',26,0,0,5049,5049.00000000,131274.00000000,23629.32000000,0.00000000,0.00000000,154903.32000000,0,NULL,NULL,0,3898.00000000,NULL,0,2,NULL,NULL,'GNF',5049.00000000,131274.00000000,23629.32000000,154903.32000000),(29,1,NULL,22,NULL,'Plafond suspendu en BA13 (m2)',NULL,'TVA',18.000,0.000,'1',0.000,'0',230,10,16700,150300,167000.00000000,34569000.00000000,6222420.00000000,0.00000000,0.00000000,40791420.00000000,0,NULL,NULL,0,119290.00000000,NULL,0,2,NULL,NULL,'GNF',167000.00000000,34569000.00000000,6222420.00000000,40791420.00000000),(30,1,NULL,24,NULL,'Application d&#39;une sous-couche pour placo-pl&acirc;tre (m2)<br />\r\n(Pays d&#39;origine: Guin&eacute;e)',NULL,'TVA',18.000,0.000,'1',0.000,'0',290,0,0,5069,5069.00000000,1470010.00000000,264601.80000000,0.00000000,0.00000000,1734611.80000000,0,NULL,NULL,0,3898.00000000,NULL,0,3,NULL,NULL,'GNF',5069.00000000,1470010.00000000,264601.80000000,1734611.80000000),(31,1,NULL,31,NULL,'Fourniture et application de deux couches de peinture plafond, finition blanc mat (m2).',NULL,'TVA',18.000,0.000,'1',0.000,'0',290,0,0,NULL,4200.00000000,1218000.00000000,219240.00000000,0.00000000,0.00000000,1437240.00000000,0,NULL,NULL,0,3600.00000000,NULL,0,4,NULL,NULL,'GNF',4200.00000000,1218000.00000000,219240.00000000,1437240.00000000),(32,1,NULL,26,NULL,'',NULL,'TVA',18.000,0.000,'1',0.000,'0',290,0,0,NULL,11000.00000000,3190000.00000000,574200.00000000,0.00000000,0.00000000,3764200.00000000,1,NULL,NULL,0,6000.00000000,NULL,0,5,NULL,NULL,'GNF',11000.00000000,3190000.00000000,574200.00000000,3764200.00000000),(35,4,NULL,NULL,NULL,'<u><strong>DEMOLITION (m2) :</strong></u><br />\r\n* D&eacute;molition de la ma&ccedil;onnerie et &eacute;vacuation des gravats.<br />\r\n* D&eacute;pose des portes existantes (1 simple et 1 double).',NULL,'TVA',18.000,0.000,'1',0.000,'0',26,10,39000,351000,390000.00000000,9126000.00000000,1642680.00000000,0.00000000,0.00000000,10768680.00000000,1,NULL,NULL,0,200000.00000000,NULL,0,2,NULL,NULL,'GNF',37.00000000,877.46490000,157.94368200,1035.40858200),(36,4,NULL,NULL,NULL,'<u><strong>MACONNERIE (m2) :</strong></u><br />\r\n* Fourniture et r&eacute;alisation de murs en ma&ccedil;onnerie ainsi que cr&eacute;pissage des deux c&ocirc;t&eacute;s.',NULL,'TVA',18.000,0.000,'1',0.000,'0',125,0,0,245000,245000.00000000,30625000.00000000,5512500.00000000,0.00000000,0.00000000,36137500.00000000,0,NULL,NULL,0,187500.00000000,NULL,0,3,NULL,NULL,'GNF',24.00000000,2944.59375000,530.02687500,3474.62062500),(44,4,NULL,NULL,NULL,'<u><strong>FIN DE CHANTIER (forfait) :</strong></u><br />\r\n* Nettoyage complet du chantier avant reception.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,6000000,6000000.00000000,6000000.00000000,1080000.00000000,0.00000000,0.00000000,7080000.00000000,1,NULL,NULL,0,4000000.00000000,NULL,0,16,NULL,NULL,'GNF',577.00000000,576.90000000,103.84200000,680.74200000),(45,4,NULL,NULL,NULL,'<u><strong>INSTALLATION (forfait) :</strong></u><br />\r\n* Installation du chantier et manutention des mat&eacute;riaux.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,10000000,10000000.00000000,10000000.00000000,1800000.00000000,0.00000000,0.00000000,11800000.00000000,1,NULL,NULL,0,6000000.00000000,NULL,0,1,NULL,NULL,'GNF',962.00000000,961.50000000,173.07000000,1134.57000000),(46,4,NULL,NULL,NULL,'<u><strong>FAUX-PLAFOND (m2) :</strong></u><br />\r\n* Installation d&#39;un faux plafond en dalle 600/600 (m2)',NULL,'TVA',18.000,0.000,'1',0.000,'0',400,0,0,75000,75000.00000000,30000000.00000000,5400000.00000000,0.00000000,0.00000000,35400000.00000000,0,NULL,NULL,0,70000.00000000,NULL,0,11,NULL,NULL,'GNF',7.00000000,2884.50000000,519.21000000,3403.71000000),(47,4,NULL,NULL,NULL,'<u><strong>PARQUET (m2) :</strong></u><br />\r\n* Main d&#39;oeuvre pour installation d&#39;un parquet flottant (m2)',NULL,'TVA',18.000,0.000,'1',0.000,'0',400,0,0,30000,30000.00000000,12000000.00000000,2160000.00000000,0.00000000,0.00000000,14160000.00000000,1,NULL,NULL,0,15000.00000000,NULL,0,12,NULL,NULL,'GNF',3.00000000,1153.80000000,207.68400000,1361.48400000),(48,4,NULL,NULL,NULL,'<u><strong>ELECTRICITE (unit&eacute;) :</strong></u><br />\r\n* Fourniture et installation du r&eacute;seau &eacute;lectrique prises, selon sch&eacute;ma transmis (unit&eacute;)',NULL,'TVA',18.000,0.000,'1',0.000,'0',158,0,0,241000,241000.00000000,38078000.00000000,6854040.00000000,0.00000000,0.00000000,44932040.00000000,0,NULL,NULL,0,186000.00000000,NULL,0,13,NULL,NULL,'GNF',23.00000000,3661.19970000,659.01594600,4320.21564600),(49,4,NULL,NULL,NULL,'<u><strong>ELECTRICITE (unit&eacute;) :</strong></u><br />\r\n* Fourniture et installation du r&eacute;seau &eacute;lectrique luminaire (dalle 600/600) selon sch&eacute;ma transmis.',NULL,'TVA',18.000,0.000,'1',0.000,'0',42,0,0,1168892,1168892.00000000,49093464.00000000,8836823.52000000,0.00000000,0.00000000,57930287.52000000,0,NULL,NULL,0,899000.00000000,NULL,0,14,NULL,NULL,'GNF',112.00000000,4720.33656360,849.66058145,5569.99714505),(50,4,NULL,NULL,NULL,'<u><strong>ELECTRICITE (unit&eacute;) :</strong></u><br />\r\n* Fourniture et installation de coffret &eacute;lectrique complet, selon le sch&eacute;ma transmis.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,17990800,17990800.00000000,17990800.00000000,3238344.00000000,0.00000000,0.00000000,21229144.00000000,0,NULL,NULL,0,15000000.00000000,NULL,0,15,NULL,NULL,'GNF',1730.00000000,1729.81542000,311.36677560,2041.18219560),(53,5,NULL,NULL,NULL,'R&eacute;alisation d&#39;un enduit sur les murs avec peinture &agrave; l&#39;huile (cela permet de reprendre la plan&eacute;it&eacute;e du mur ainsi que l&#39;adh&eacute;rence pour la peinture) (m2).',NULL,'TVA',18.000,0.000,'1',0.000,'0',130,0,0,27500,27500.00000000,3575000.00000000,643500.00000000,0.00000000,0.00000000,4218500.00000000,0,NULL,NULL,0,21160.00000000,NULL,0,1,NULL,NULL,'GNF',27500.00000000,3575000.00000000,643500.00000000,4218500.00000000),(54,5,NULL,1,NULL,'Ensemble pour r&eacute;aliser une contre-cloison simple parement en BA13 Standart.<br />\r\nL&#39;unit&eacute; de tarification est le m2.',NULL,'TVA',18.000,0.000,'1',0.000,'0',70,10,25000,225000,250000.00000000,15750000.00000000,2835000.00000000,0.00000000,0.00000000,18585000.00000000,0,NULL,NULL,0,142171.00000000,NULL,0,2,NULL,NULL,'GNF',250000.00000000,15750000.00000000,2835000.00000000,18585000.00000000),(55,5,NULL,25,NULL,'Application de deux couches de peinture murale, finition blanc mat (m2)<br />\r\n(Pays d&#39;origine: Guin&eacute;e)',NULL,'TVA',18.000,0.000,'1',0.000,'0',200,0,0,18786,18786.00000000,3757200.00000000,676296.00000000,0.00000000,0.00000000,4433496.00000000,0,NULL,NULL,0,15654.00000000,NULL,0,3,NULL,NULL,'GNF',18786.00000000,3757200.00000000,676296.00000000,4433496.00000000),(56,5,NULL,27,NULL,'Fourniture et pose d&#39;une climatisation 9000BTU',NULL,'TVA',18.000,0.000,'1',0.000,'0',4,10,0,NULL,3400000.00000000,12240000.00000000,2203200.00000000,0.00000000,0.00000000,14443200.00000000,0,NULL,NULL,0,2900000.00000000,NULL,0,5,NULL,NULL,'GNF',3400000.00000000,12240000.00000000,2203200.00000000,14443200.00000000),(57,5,NULL,NULL,NULL,'Fourniture et installation de WC (haute qualit&eacute;)',NULL,'TVA',18.000,0.000,'1',0.000,'0',2,0,0,NULL,1600000.00000000,3200000.00000000,576000.00000000,0.00000000,0.00000000,3776000.00000000,0,NULL,NULL,0,1400000.00000000,NULL,0,6,NULL,NULL,'GNF',1600000.00000000,3200000.00000000,576000.00000000,3776000.00000000),(58,5,NULL,NULL,NULL,'Fourniture et installation de lave-main',NULL,'TVA',18.000,0.000,'1',0.000,'0',2,0,0,NULL,600000.00000000,1200000.00000000,216000.00000000,0.00000000,0.00000000,1416000.00000000,0,NULL,NULL,0,450000.00000000,NULL,0,7,NULL,NULL,'GNF',600000.00000000,1200000.00000000,216000.00000000,1416000.00000000),(59,5,NULL,31,NULL,'Fourniture et application de deux couches de peinture plafond, finition blanc mat (m2).',NULL,'TVA',18.000,0.000,'1',0.000,'0',80,0,0,9200,9200.00000000,736000.00000000,132480.00000000,0.00000000,0.00000000,868480.00000000,0,NULL,NULL,0,8600.00000000,NULL,0,4,NULL,NULL,'GNF',9200.00000000,736000.00000000,132480.00000000,868480.00000000),(60,6,NULL,NULL,NULL,'FERRONERIE (forfait) :<br />\r\nFourniture et installation d&#39;une nouvelle porte m&eacute;tallique donnant acc&egrave;s &agrave; la piscine + garde de corps &agrave; c&ocirc;t&eacute;.<br />\r\nFourniture et installation de deux grilles de protection (deux fen&ecirc;tres de la chambre principale).<br />\r\nFourniture et installation de nouvelle grille de protection pour la porte d&#39;entr&eacute;e, la porte d&#39;acc&egrave;s &agrave; la piscine et la porte d&#39;acc&egrave;s au balcon de l&#39;&eacute;tage.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,10,2535000,22815000,25350000.00000000,22815000.00000000,4106700.00000000,0.00000000,0.00000000,26921700.00000000,0,NULL,NULL,0,18058000.00000000,NULL,0,1,NULL,NULL,'GNF',25350000.00000000,22815000.00000000,4106700.00000000,26921700.00000000),(61,6,NULL,NULL,NULL,'FERRONERIE (unit&eacute;) :<br />\r\nR&eacute;alisation et installation de garde corps le long des escaliers de l&#39;entr&eacute;e (unit&eacute;)<br />\r\nTubes rectangulaire galvanis&eacute;e 60*40 et 40*40 + protection antirouille.',NULL,'TVA',18.000,0.000,'1',0.000,'0',2,10,487500,4387500,4875000.00000000,8775000.00000000,1579500.00000000,0.00000000,0.00000000,10354500.00000000,0,NULL,NULL,0,3750000.00000000,NULL,0,2,NULL,NULL,'GNF',4875000.00000000,8775000.00000000,1579500.00000000,10354500.00000000),(63,6,NULL,NULL,NULL,'CUISINE (forfait) :<br />\r\nFourniture et installation des meubles en aluminium selon le plan actuel (prix pouvant vari&eacute; en fonction du choix)',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,6900000,6900000.00000000,6900000.00000000,1242000.00000000,0.00000000,0.00000000,8142000.00000000,0,NULL,NULL,0,5199000.00000000,NULL,0,3,NULL,NULL,'GNF',6900000.00000000,6900000.00000000,1242000.00000000,8142000.00000000),(65,6,NULL,NULL,NULL,'CUISINE (m2)<br />\r\nD&eacute;molition de la faience murale la cuisine puis reprise d&#39;enduit et de peinture.',NULL,'TVA',18.000,0.000,'1',0.000,'0',37,0,0,75000,75000.00000000,2775000.00000000,499500.00000000,0.00000000,0.00000000,3274500.00000000,0,NULL,NULL,0,45946.00000000,NULL,0,4,NULL,NULL,'GNF',75000.00000000,2775000.00000000,499500.00000000,3274500.00000000),(66,6,NULL,NULL,NULL,'CUISINE (m2)<br />\r\nR&eacute;novation du plan de travail de la cuisine. D&eacute;pose de la faience existante par repose d&#39;une faience neuve.',NULL,'TVA',18.000,0.000,'1',0.000,'0',16,0,0,203125,203125.00000000,3250000.00000000,585000.00000000,0.00000000,0.00000000,3835000.00000000,0,NULL,NULL,0,156250.00000000,NULL,0,5,NULL,NULL,'GNF',203125.00000000,3250000.00000000,585000.00000000,3835000.00000000),(67,6,NULL,NULL,NULL,'FENETRES (forfait) :<br />\r\nFourniture et installation de moustiquaires par l&#39;ext&eacute;rieur sur toutes les fen&ecirc;tes, sauf facade c&ocirc;t&eacute;e mer.<br />\r\nNettoyage et graissage des fen&ecirc;tres existantes.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,9500000,9500000.00000000,9500000.00000000,1710000.00000000,0.00000000,0.00000000,11210000.00000000,0,NULL,NULL,0,7500000.00000000,NULL,0,6,NULL,NULL,'GNF',9500000.00000000,9500000.00000000,1710000.00000000,11210000.00000000),(68,6,NULL,NULL,NULL,'FENETRES (forfait)<br />\r\nRemplacement du cadre de la porte d&#39;entr&eacute;e par un cadre trois rails avec moustiquaire.<br />\r\nRemplacement complet de l&#39;impost &agrave; droite de la porte d&#39;entr&eacute;e par une baie coulissante &eacute;quip&eacute; de sa moustiquaire.<br />\r\nInstallation d&#39;une moustiquaire sur rail pour la fen&ecirc;tre et porte fen&ecirc;tre de la chambre donnant acc&egrave;s &agrave; la piscine.<br />\r\nInstallation d&#39;une moustiquaire sur rail pour la baie donnant acc&egrave;s &agrave; balcon ainsi que la fen&ecirc;tre de la chambre principale.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,10000000,10000000.00000000,10000000.00000000,1800000.00000000,0.00000000,0.00000000,11800000.00000000,0,NULL,NULL,0,8000000.00000000,NULL,0,7,NULL,NULL,'GNF',10000000.00000000,10000000.00000000,1800000.00000000,11800000.00000000),(69,6,NULL,NULL,NULL,'PLOMBERIE (forfait) :<br />\r\nRemise en &eacute;tat de toute l&#39;installation de la maison, ainsi que les accessoires (abattants toilette, chasse d&#39;eau, etc).<br />\r\nNettoyage des cuves de reserve d&#39;eau.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,5,243000,4617000,4860000.00000000,4617000.00000000,831060.00000000,0.00000000,0.00000000,5448060.00000000,0,NULL,NULL,0,3735000.00000000,NULL,0,8,NULL,NULL,'GNF',4860000.00000000,4617000.00000000,831060.00000000,5448060.00000000),(70,6,NULL,NULL,NULL,'ELECTRICITE (forfait) :<br />\r\nFourniture et installation de 7 lampes projecteurs LED 100W<br />\r\nAchat de c&acirc;ble 3x2,5mm2 pour installation.<br />\r\nFourniture et installation de deux disjoncteurs diff&eacute;rentiels 30mA.<br />\r\nReprise de la mise &agrave; la terre.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,10,1276000,11484000,12760000.00000000,11484000.00000000,2067120.00000000,0.00000000,0.00000000,13551120.00000000,0,NULL,NULL,0,7240000.00000000,NULL,0,9,NULL,NULL,'GNF',12760000.00000000,11484000.00000000,2067120.00000000,13551120.00000000),(72,6,NULL,NULL,NULL,'MENUISERIE (forfait) :<br />\r\nRemise en &eacute;tat des trois portes d&eacute;grad&eacute;es + masticage et peinture.<br />\r\nRemplacement des 17 serrures d&eacute;grad&eacute;es par des serrures neuves (bonne qualit&eacute;).',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,10,825000,7425000,8250000.00000000,7425000.00000000,1336500.00000000,0.00000000,0.00000000,8761500.00000000,0,NULL,NULL,0,6400000.00000000,NULL,0,10,NULL,NULL,'GNF',8250000.00000000,7425000.00000000,1336500.00000000,8761500.00000000),(74,6,NULL,NULL,NULL,'OFFERT :<br />\r\nRemise en place de la grille du local groupe.<br />\r\nD&eacute;pose de la faience et r&eacute;novation du mur dans la salle de bain parentale.<br />\r\nD&eacute;pose des accessoires inutiles et emcombrants sur les facades.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,100,0,NULL,1.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0,NULL,NULL,0,1.00000000,NULL,0,11,NULL,NULL,'GNF',1.00000000,0.00000000,0.00000000,0.00000000),(75,7,NULL,27,NULL,'Fourniture et pose d&#39;une climatisation 9000BTU',NULL,'TVA',18.000,0.000,'1',0.000,'0',2,0,0,NULL,3400000.00000000,6800000.00000000,1224000.00000000,0.00000000,0.00000000,8024000.00000000,0,NULL,NULL,0,2900000.00000000,NULL,0,1,NULL,NULL,'GNF',3400000.00000000,6800000.00000000,1224000.00000000,8024000.00000000),(76,7,NULL,28,NULL,'Fourniture et pose d&#39;une climatisation 12000BTU',NULL,'TVA',18.000,0.000,'1',0.000,'0',3,0,0,NULL,3900000.00000000,11700000.00000000,2106000.00000000,0.00000000,0.00000000,13806000.00000000,0,NULL,NULL,0,3400000.00000000,NULL,0,2,NULL,NULL,'GNF',3900000.00000000,11700000.00000000,2106000.00000000,13806000.00000000),(77,8,NULL,NULL,NULL,'<u><strong>FORFAIT RENOVATION PEINTURE PAR CHAMBRE POUR MLYS1 :</strong></u><br />\r\n* Protection du mobilier.<br />\r\n* Reprise des enduits si n&eacute;cessaire (impacts, humidit&eacute;, etc).<br />\r\n* Fourniture et application de deux couches de peinture murale (couleurs identiques).<br />\r\n* Fourniture et application de deux couches de peinture blanche plafond.<br />\r\n<u>D&eacute;lai pr&eacute;vu par chambre : 3 jours.</u>',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,1050000,1050000.00000000,1050000.00000000,189000.00000000,0.00000000,0.00000000,1239000.00000000,0,NULL,NULL,0,900000.00000000,NULL,0,1,NULL,NULL,'GNF',1050000.00000000,1050000.00000000,189000.00000000,1239000.00000000),(78,9,NULL,NULL,NULL,'Fourniture paratonnerre &agrave; disposition d&#39;amor&ccedil;age rayon de protection 50m.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,10,4700000,42300000,47000000.00000000,42300000.00000000,7614000.00000000,0.00000000,0.00000000,49914000.00000000,0,NULL,NULL,0,35000000.00000000,NULL,0,1,NULL,NULL,'GNF',47000000.00000000,42300000.00000000,7614000.00000000,49914000.00000000),(79,9,NULL,NULL,NULL,'Main d&#39;oeuvre pour la pose du paratonnerre',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,10,1500000,13500000,15000000.00000000,13500000.00000000,2430000.00000000,0.00000000,0.00000000,15930000.00000000,1,NULL,NULL,0,12250000.00000000,NULL,0,2,NULL,NULL,'GNF',15000000.00000000,13500000.00000000,2430000.00000000,15930000.00000000),(80,10,NULL,NULL,NULL,'<u><strong>RENOVATION FACADE MLYS1 (m2) :</strong></u><br />\r\n* Fourniture et application de deux couches de peinture blanche sur les balcons, parties sup&eacute;rieures (roof) et colonnes montantes.',NULL,'TVA',18.000,0.000,'1',0.000,'0',200,0,0,25700,25700.00000000,5140000.00000000,925200.00000000,0.00000000,0.00000000,6065200.00000000,0,NULL,NULL,0,23400.00000000,NULL,0,1,NULL,NULL,'GNF',25700.00000000,5140000.00000000,925200.00000000,6065200.00000000),(81,10,NULL,NULL,NULL,'<u><strong>RENOVATION FACADE MLYS1 (forfait) :</strong></u><br />\r\n* Installation, location et d&eacute;pose d&#39;un &eacute;chaffaudage.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,1500000.00000000,1500000.00000000,270000.00000000,0.00000000,0.00000000,1770000.00000000,0,NULL,NULL,0,0.00000000,NULL,0,2,NULL,NULL,'GNF',1500000.00000000,1500000.00000000,270000.00000000,1770000.00000000),(82,10,NULL,NULL,NULL,'<u><strong>RENOVATION DES PEINTURES DES PARTIES COMMUNES MLYS1 (m2) :</strong></u><br />\r\n* Reprise des enduits si n&eacute;cessaire (impacts, humidit&eacute;s, etc),<br />\r\n* Fourniture et application de deux couches de peinture (couleur identique), dans la salle r&eacute;ception, restaurant et caf&eacute;.',NULL,'TVA',18.000,0.000,'1',0.000,'0',180,0,0,39500,39500.00000000,7110000.00000000,1279800.00000000,0.00000000,0.00000000,8389800.00000000,0,NULL,NULL,0,32155.00000000,NULL,0,3,NULL,NULL,'GNF',39500.00000000,7110000.00000000,1279800.00000000,8389800.00000000),(83,11,NULL,22,NULL,'Plafond suspendu en BA13 (m2)',NULL,'TVA',18.000,0.000,'1',0.000,'0',330,0,0,NULL,167000.00000000,55110000.00000000,9919800.00000000,0.00000000,0.00000000,65029800.00000000,0,NULL,NULL,0,119290.00000000,NULL,0,1,NULL,NULL,'GNF',167000.00000000,55110000.00000000,9919800.00000000,65029800.00000000),(84,11,NULL,23,NULL,'R&eacute;alisation d&#39;une cloison deux faces en parement simple BA13 Standart (m2)',NULL,'TVA',18.000,0.000,'1',0.000,'0',40,0,0,NULL,314345.00000000,12573800.00000000,2263284.00000000,0.00000000,0.00000000,14837084.00000000,0,NULL,NULL,0,241805.00000000,NULL,0,2,NULL,NULL,'GNF',314345.00000000,12573800.00000000,2263284.00000000,14837084.00000000),(85,11,NULL,NULL,NULL,'Fourniture et pose de carrelage sol (m2)',NULL,'TVA',18.000,0.000,'1',0.000,'0',400,0,0,NULL,210000.00000000,84000000.00000000,15120000.00000000,0.00000000,0.00000000,99120000.00000000,0,NULL,NULL,0,175000.00000000,NULL,0,3,NULL,NULL,'GNF',210000.00000000,84000000.00000000,15120000.00000000,99120000.00000000),(86,11,NULL,NULL,NULL,'Fourniture et pose de faience dans les salles de bains (m2)',NULL,'TVA',18.000,0.000,'1',0.000,'0',300,0,0,NULL,160000.00000000,48000000.00000000,8640000.00000000,0.00000000,0.00000000,56640000.00000000,0,NULL,NULL,0,125000.00000000,NULL,0,4,NULL,NULL,'GNF',160000.00000000,48000000.00000000,8640000.00000000,56640000.00000000),(87,4,NULL,NULL,NULL,'<u><strong>MACONNERIE (m2) :</strong></u><br />\r\n* Fourniture et r&eacute;alisation d&#39;un enduit de finition sur ma&ccedil;onnerie, pon&ccedil;age et peinture blanche (deux couches).',NULL,'TVA',18.000,0.000,'1',0.000,'0',250,0,0,36500,36500.00000000,9125000.00000000,1642500.00000000,0.00000000,0.00000000,10767500.00000000,0,NULL,NULL,0,25680.00000000,NULL,0,4,NULL,NULL,'GNF',4.00000000,877.36875000,157.92637500,1035.29512500),(88,4,NULL,NULL,NULL,'<u><strong>MENUISERIE (unit&eacute;) :</strong></u><br />\r\n* Fourniture et installation de porte aluminium blanc laqu&eacute; 90/200 (traverse, partie inf&eacute;rieure en panneau plein, partie sup&eacute;rieure en vitrage).<br />\r\nAluminium 12/10&egrave;me, verre 6mm, &eacute;paisseur cadre 7cm, quincailleries fournis.',NULL,'TVA',18.000,0.000,'1',0.000,'0',16,5,160000,3040000,3200000.00000000,48640000.00000000,8755200.00000000,0.00000000,0.00000000,57395200.00000000,0,NULL,NULL,0,2700000.00000000,NULL,0,7,NULL,NULL,'GNF',308.00000000,4676.73600000,841.81248000,5518.54848000),(89,4,NULL,NULL,NULL,'<u><strong>POSE CLOISON BA13 (m2) :</strong></u><br />\r\n* Main d&#39;oeuvre pour pose des cloisons en placo-pl&acirc;tre.<br />\r\n* Installation des armatures.<br />\r\n* Pose des plaques.<br />\r\n* R&eacute;alisation des enduits et pon&ccedil;age.<br />\r\n&nbsp;',NULL,'TVA',18.000,0.000,'1',0.000,'0',230,35,43750,81250,125000.00000000,18687500.00000000,3363750.00000000,0.00000000,0.00000000,22051250.00000000,1,NULL,NULL,0,59000.00000000,NULL,0,5,NULL,NULL,'GNF',12.00000000,1796.80312500,323.42456250,2120.22768750),(90,4,NULL,NULL,NULL,'<u><strong>MENUISERIE (unit&eacute;) :</strong></u><br />\r\n* Fourniture et installation de porte &quot;forte&quot; aluminium blanc laqu&eacute; 90/200<br />\r\nAluminium 12/10&egrave;me, panneau renforc&eacute;, quincailleries fournis.',NULL,'TVA',18.000,0.000,'1',0.000,'0',2,0,0,3400000,3400000.00000000,6800000.00000000,1224000.00000000,0.00000000,0.00000000,8024000.00000000,0,NULL,NULL,0,2900000.00000000,NULL,0,8,NULL,NULL,'GNF',327.00000000,653.82000000,117.68760000,771.50760000),(91,4,NULL,NULL,NULL,'<u><strong>PEINTURE (m2) :</strong></u><br />\r\n* Fourniture et application d&#39;un primaire pour BA13.<br />\r\n* Fourniture et application d&#39;une peinture de finition blanche (deux couches).<br />\r\n* Fourniture et application d&#39;une peinture de finition blanche en deux couches sur les maconneries existantes (200m2).',NULL,'TVA',18.000,0.000,'1',0.000,'0',750,0,0,28855,28855.00000000,21641250.00000000,3895425.00000000,0.00000000,0.00000000,25536675.00000000,0,NULL,NULL,0,19854.00000000,NULL,0,6,NULL,NULL,'GNF',3.00000000,2080.80618750,374.54511375,2455.35130125),(92,4,NULL,NULL,NULL,'<u><strong>MENUISERIE (m2) :</strong></u><br />\r\n* Fourniture et installation de baie vitr&eacute;e, cadre aluminium laqu&eacute; blanc, verre 6mm.',NULL,'TVA',18.000,0.000,'1',0.000,'0',25,0,0,1250000,1250000.00000000,31250000.00000000,5625000.00000000,0.00000000,0.00000000,36875000.00000000,0,NULL,NULL,0,1000000.00000000,NULL,0,9,NULL,NULL,'GNF',120.00000000,3004.68750000,540.84375000,3545.53125000),(93,4,NULL,NULL,NULL,'<u><strong>MENUISERIE (unit&eacute;) :</strong></u><br />\r\n* Fourniture et pose de Groom pour porte.',NULL,'TVA',18.000,0.000,'1',0.000,'0',18,0,0,550000,550000.00000000,9900000.00000000,1782000.00000000,0.00000000,0.00000000,11682000.00000000,0,NULL,NULL,0,500000.00000000,NULL,0,10,NULL,NULL,'GNF',53.00000000,951.88500000,171.33930000,1123.22430000),(94,12,NULL,NULL,NULL,'<u><strong>ETUDE DE PROJET :</strong></u><br />\r\n* Conception des plans de c&ocirc;tes et d&#39;am&eacute;nagement.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,5000000,5000000.00000000,5000000.00000000,900000.00000000,0.00000000,0.00000000,5900000.00000000,1,NULL,NULL,0,2500000.00000000,NULL,0,1,NULL,1,'GNF',5000000.00000000,5000000.00000000,900000.00000000,5900000.00000000),(95,12,NULL,NULL,NULL,'<u><strong>INSTALLATION DU CHANTIER (forfait) :</strong></u><br />\r\n* Approvisionnement des mat&eacute;riaux.<br />\r\n* Protection du sol carrelage par de l&#39;isorelle 5mm.<br />\r\n* Protection des poussi&egrave;res par du polyane.<br />\r\n&nbsp;',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,25000000.00000000,25000000.00000000,4500000.00000000,0.00000000,0.00000000,29500000.00000000,1,NULL,NULL,0,17000000.00000000,NULL,0,2,NULL,1,'GNF',25000000.00000000,25000000.00000000,4500000.00000000,29500000.00000000),(96,12,NULL,NULL,NULL,'<u><strong>DEMOLITION (m2) :</strong></u><br />\r\n* D&eacute;molition des ma&ccedil;onneries et &eacute;vacuation des gravats.<br />\r\n* D&eacute;placement des fluides &eacute;lectriques et plomberies, si n&eacute;cessaire.',NULL,'TVA',18.000,0.000,'1',0.000,'0',12,0,0,390000,390000.00000000,4680000.00000000,842400.00000000,0.00000000,0.00000000,5522400.00000000,0,NULL,NULL,0,200000.00000000,NULL,0,3,NULL,1,'GNF',390000.00000000,4680000.00000000,842400.00000000,5522400.00000000),(97,12,NULL,NULL,NULL,'<u><strong>MACONNERIE (m2) :</strong></u><br />\r\n* Fourniture et r&eacute;alisation d&#39;un enduit de finition sur les ma&ccedil;onneries du coin kitchennette, pon&ccedil;age et peinture blanche (deux couches).',NULL,'TVA',18.000,0.000,'1',0.000,'0',22,0,0,39500,39500.00000000,869000.00000000,156420.00000000,0.00000000,0.00000000,1025420.00000000,0,NULL,NULL,0,25680.00000000,NULL,0,4,NULL,1,'GNF',39500.00000000,869000.00000000,156420.00000000,1025420.00000000),(99,12,NULL,NULL,NULL,'<u><strong>ISOLANT (m2) :</strong></u><br />\r\n* Fourniture et pose d&#39;une isolation acoustique et thermique, sp&eacute;cifique aux cloisons distributives.<br />\r\n* Fourniture et pose d&#39;une isolation acoustique et thermique pour les cloisons et la plafond du DATA CENTER',NULL,'TVA',18.000,0.000,'1',0.000,'0',470,0,0,89500,89500.00000000,42065000.00000000,7571700.00000000,0.00000000,0.00000000,49636700.00000000,0,NULL,NULL,0,54123.00000000,NULL,0,7,NULL,1,'GNF',89500.00000000,42065000.00000000,7571700.00000000,49636700.00000000),(100,12,NULL,NULL,NULL,'<u><strong>PEINTURE (m2) :</strong></u><br />\r\n* Fourniture et application d&#39;un primaire d&#39;accrochage pour plaque de pl&acirc;tre BA13.<br />\r\n* Fourniture et application d&#39;une peinture de finition blanche sur les cloisons de pl&acirc;tre (deux couches).<br />\r\n* Ces deux proc&eacute;d&eacute;s seront &eacute;galement appliqu&eacute;s sur la zone DATA CENTER.',NULL,'TVA',18.000,0.000,'1',0.000,'0',750,0,0,34900,34900.00000000,26175000.00000000,4711500.00000000,0.00000000,0.00000000,30886500.00000000,0,NULL,NULL,0,19855.00000000,NULL,0,8,NULL,1,'GNF',34900.00000000,26175000.00000000,4711500.00000000,30886500.00000000),(101,12,NULL,NULL,NULL,'<u><strong>PEINTURE (m2) :</strong></u><br />\r\n* Fourniture et application d&#39;une peinture de finition blanche sur les ma&ccedil;onnerie existantes (deux couches).',NULL,'TVA',18.000,0.000,'1',0.000,'0',100,0,0,29900,29900.00000000,2990000.00000000,538200.00000000,0.00000000,0.00000000,3528200.00000000,0,NULL,NULL,0,17900.00000000,NULL,0,9,NULL,1,'GNF',29900.00000000,2990000.00000000,538200.00000000,3528200.00000000),(102,12,NULL,NULL,NULL,'<u><strong>CARRELAGE (ml) :</strong></u><br />\r\n* Fourniture et pose d&#39;une plinthe carrelage sur les bas de cloisons r&eacute;alisa&eacute;es.',NULL,'TVA',18.000,0.000,'1',0.000,'0',300,0,0,35000,35000.00000000,10500000.00000000,1890000.00000000,0.00000000,0.00000000,12390000.00000000,0,NULL,NULL,0,10000.00000000,NULL,0,10,NULL,1,'GNF',35000.00000000,10500000.00000000,1890000.00000000,12390000.00000000),(103,12,NULL,NULL,NULL,'<u><strong>MENUISERIE (unit&eacute;) :</strong></u><br />\r\n* Fourniture et installation de porte aluminium blanc laqu&eacute; 90/200 (traverse centrale avec la partie inf&eacute;rieure en panneau plein et la partie sup&eacute;rieure vitr&eacute;e).<br />\r\nAluminium 12/10&egrave;me, verre 6mm, quincaillerie fournis.',NULL,'TVA',18.000,0.000,'1',0.000,'0',14,0,0,3500000,3500000.00000000,49000000.00000000,8820000.00000000,0.00000000,0.00000000,57820000.00000000,0,NULL,NULL,0,2700000.00000000,NULL,0,13,NULL,1,'GNF',3500000.00000000,49000000.00000000,8820000.00000000,57820000.00000000),(104,12,NULL,NULL,NULL,'<u><strong>MENUISERIE (unit&eacute;) :</strong></u><br />\r\n* Fourniture et installation de baie vitr&eacute;e 1500/1000 (cadre aluminium laqu&eacute; blanc, verre 6mm).',NULL,'TVA',18.000,0.000,'1',0.000,'0',6,0,0,2250000,2250000.00000000,13500000.00000000,2430000.00000000,0.00000000,0.00000000,15930000.00000000,0,NULL,NULL,0,1500000.00000000,NULL,0,14,NULL,1,'GNF',2250000.00000000,13500000.00000000,2430000.00000000,15930000.00000000),(105,12,NULL,NULL,NULL,'<u><strong>ELECTRICITE (unit&eacute;) :</strong></u><br />\r\n* Fourniture et installation d&#39;un coffret &eacute;lectrique complet, munis de tous les disjoncteurs pour les luminaires, prises, prises ondul&eacute;es et climatisations.<br />\r\n* Fourniture et installation d&#39;un disjoncteur diff&eacute;rentiel 30mA pour la s&eacute;curit&eacute; du personnel.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,19500000,19500000.00000000,19500000.00000000,3510000.00000000,0.00000000,0.00000000,23010000.00000000,0,NULL,NULL,0,15000000.00000000,NULL,0,16,NULL,1,'GNF',19500000.00000000,19500000.00000000,3510000.00000000,23010000.00000000),(107,12,NULL,NULL,NULL,'<u><strong>FIN DE CHANTIER (forfait) :</strong></u><br />\r\n* Nettoyage complet du chantier avant r&eacute;ception.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,6000000,6000000.00000000,6000000.00000000,1080000.00000000,0.00000000,0.00000000,7080000.00000000,1,NULL,NULL,0,4000000.00000000,NULL,0,19,NULL,1,'GNF',6000000.00000000,6000000.00000000,1080000.00000000,7080000.00000000),(108,12,NULL,NULL,NULL,'<u><strong>CLOISONNEMENT PARTIE BUREAU (m2) :</strong></u><br />\r\n* Fourniture et installation des armatures m&eacute;tallique 48mm pour le cloisonnement des diff&egrave;rents espaces.<br />\r\n* Fourniture et r&eacute;alisation des cloisons en plaque de pl&acirc;tre BA13 hydrofuge, une peau de chaque c&ocirc;t&eacute;.<br />\r\n* Fourniture et r&eacute;alisation des enduits de finition et des pon&ccedil;age.',NULL,'TVA',18.000,0.000,'1',0.000,'0',350,0,0,365000,365000.00000000,127750000.00000000,22995000.00000000,0.00000000,0.00000000,150745000.00000000,0,NULL,NULL,0,257120.00000000,NULL,0,5,NULL,1,'GNF',365000.00000000,127750000.00000000,22995000.00000000,150745000.00000000),(109,12,NULL,NULL,NULL,'<u><strong>SANITAIRE (ensemble) :</strong></u><br />\r\n* Fourniture, pose et raccordement des &eacute;quipements de toilette (wc + lave-main).',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,4000000.00000000,4000000.00000000,720000.00000000,0.00000000,0.00000000,4720000.00000000,0,NULL,NULL,0,2500000.00000000,NULL,0,11,NULL,1,'GNF',4000000.00000000,4000000.00000000,720000.00000000,4720000.00000000),(110,13,NULL,NULL,NULL,'<u><strong>CLOISOINNEMENT DES BUREAUX DE L&#39;ARPT (m2) :</strong></u><br />\r\n* Fourniture et pose de cloison en plaque de pl&acirc;tre BA13 + r&eacute;alisation des enduits/bandes.<br />\r\n* Division du bureau de 12&egrave;me &eacute;tage en 4 bureaux distincts.<br />\r\n* Division des salles techniques du 12&egrave;me &eacute;tage en 2 bureaux distincts + r&eacute;hausse de deux cloisons actuelles.',NULL,'TVA',18.000,0.000,'1',0.000,'0',145,15,54750,310250,365000.00000000,44986250.00000000,8097525.00000000,0.00000000,0.00000000,53083775.00000000,0,NULL,NULL,0,257120.00000000,NULL,0,1,NULL,1,'GNF',365000.00000000,44986250.00000000,8097525.00000000,53083775.00000000),(111,12,NULL,NULL,NULL,'<u><strong>ELECTRICITE (unit&eacute;) :</strong></u><br />\r\n* Fourniture, c&acirc;ble puis branchement d&#39;un r&eacute;seau &eacute;lectrique luminaire selon l&#39;implantation des bureaux.<br />\r\nDalle LED 45w 600*600mm 6400K.',NULL,'TVA',18.000,0.000,'1',0.000,'0',54,0,0,1168992,1168992.00000000,63125568.00000000,11362602.23999999,0.00000000,0.00000000,74488170.24000000,0,NULL,NULL,0,899000.00000000,NULL,0,17,NULL,1,'GNF',1168992.00000000,63125568.00000000,11362602.23999999,74488170.24000000),(112,12,NULL,NULL,NULL,'<u><strong>ELECTRIQUE (unit&eacute;) :</strong></u><br />\r\n* Fourniture, c&acirc;ble puis branchement d&#39;un r&eacute;seau &eacute;lectrique prises standarts et ondul&eacute;es.',NULL,'TVA',18.000,0.000,'1',0.000,'0',145,0,0,260000,260000.00000000,37700000.00000000,6786000.00000000,0.00000000,0.00000000,44486000.00000000,0,NULL,NULL,0,186000.00000000,NULL,0,18,NULL,1,'GNF',260000.00000000,37700000.00000000,6786000.00000000,44486000.00000000),(113,14,NULL,NULL,NULL,'<u><strong>APPAREILS DE CLIMATISATIONS :</strong></u><br />\r\n* Unit&eacute;s ext&eacute;rieures A condenseur &agrave; air type VRV de Marque Ariwell.<br />\r\nType YCV450-H13<br />\r\n<br />\r\n&nbsp;',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,158184000,158184000.00000000,158184000.00000000,28473120.00000000,0.00000000,0.00000000,186657120.00000000,0,NULL,NULL,0,121680000.00000000,NULL,0,1,NULL,1,'GNF',158184000.00000000,158184000.00000000,28473120.00000000,186657120.00000000),(114,14,NULL,NULL,NULL,'<u><strong>APPAREILS DE CLIMATISATIONS :</strong></u><br />\r\n* Unit&eacute;s ext&eacute;rieures A condenseur &agrave; air type VRV de Marque Ariwell.<br />\r\nType YCV400-H13',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,149058000,149058000.00000000,149058000.00000000,26830440.00000000,0.00000000,0.00000000,175888440.00000000,0,NULL,NULL,0,114660000.00000000,NULL,0,2,NULL,1,'GNF',149058000.00000000,149058000.00000000,26830440.00000000,175888440.00000000),(115,14,NULL,NULL,NULL,'<u><strong>APPAREILS DE CLIMATISATIONS :</strong></u><br />\r\n* Cassettes encastrables carr&eacute;s type 4 voies et gainables VRV de Airwell.<br />\r\n* CBV016-N11<br />\r\n* CBV012-N11<br />\r\n* CBV0009-N11<br />\r\n&nbsp;',NULL,'TVA',18.000,0.000,'1',0.000,'0',21,0,0,10250526,10250526.00000000,215261046.00000000,38746988.27999999,0.00000000,0.00000000,254008034.28000000,0,NULL,NULL,0,7885020.00000000,NULL,0,3,NULL,1,'GNF',10250526.00000000,215261046.00000000,38746988.27999999,254008034.28000000),(116,14,NULL,NULL,NULL,'<u><strong>ACCESSOIRES D&#39;INSTALLATIONS :</strong></u><br />\r\n* Accessoires de suspensions cassettes.<br />\r\n* Kit de raccordement type REFNET TAU33/506.<br />\r\n* Tuyauterie 6.4/9.5/12.7/15.9/19.1/22.2/28.6.<br />\r\n* Machons isolants ARMAFLEX 6.4/9.5/12.7/15.9/19.1/22.2/28.6.<br />\r\n* Accessoires de suspensions connexions frigos 6.4/9.5/12.7/15.9/19.1/22.2/28.6.<br />\r\n* C&acirc;blage de la communicaton et t&eacute;l&eacute;commande.<br />\r\n* Support de groupe ext&eacute;rieur.<br />\r\n* Kit de soudure connexions frigos.',NULL,'TVA',18.000,0.000,'1',0.000,'0',23,0,0,8551750,8551750.00000000,196690250.00000000,35404245.00000000,0.00000000,0.00000000,232094495.00000000,0,NULL,NULL,0,6578269.00000000,NULL,0,4,NULL,1,'GNF',8551750.00000000,196690250.00000000,35404245.00000000,232094495.00000000),(117,14,NULL,NULL,NULL,'<u><strong>MAINS D&#39;OEUVRES :</strong></u><br />\r\n* Main d&#39;oeuvre installation Unit&eacute;s Int&eacute;rieures<br />\r\n* Main d&#39;oeuvre installation Unit&eacute;s Ext&eacute;rieures<br />\r\n* Main d&#39;oeuvre plomberie &eacute;vacuation condensat',NULL,'TVA',18.000,0.000,'1',0.000,'0',23,0,0,1831818,1831818.00000000,42131814.00000000,7583726.52000000,0.00000000,0.00000000,49715540.52000000,1,NULL,NULL,0,1409091.00000000,NULL,0,5,NULL,1,'GNF',1831818.00000000,42131814.00000000,7583726.52000000,49715540.52000000),(118,15,NULL,NULL,NULL,'<u><strong>PALISSADE AUTOPORTANTE (ml) :</strong></u><br />\r\n* Fourniture et pose d&#39;une palissade autoportante en contreplaqu&eacute; noir selon le plan fourni, hauteur 3.80m &eacute;paisseur 18mm.&nbsp;<br />\r\nLa palissade sera maintenue par une structure de poteaux m&eacute;talliques noirs sur pied.',NULL,'TVA',18.000,0.000,'1',0.000,'0',28,0,0,4544982,4544982.00000000,127259496.00000000,22906709.28000000,0.00000000,0.00000000,150166205.28000000,0,NULL,NULL,0,150.00000000,NULL,0,1,NULL,2,'EUR',437.00000000,12236.00000000,2202.48000000,14438.48000000),(119,15,NULL,NULL,NULL,'<u><strong>TRANSFERT MOBILIER (forfait) :</strong></u><br />\r\n* D&eacute;connexion du mobilier existant.<br />\r\n* Transfert du mobilier DFS/BAR &agrave; l&#39;endroit pr&eacute;vu.<br />\r\n* Installation du mobilier selon le plan pr&eacute;vu.<br />\r\n* Raccordement des diff&egrave;rents &eacute;l&egrave;ments.<br />\r\n* D&eacute;pose dans une zone de stockage de l&#39;aeroport le surplus de mobilier du BAR et du DFS, non utilis&eacute; dans la zone &eacute;ph&eacute;m&egrave;re.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,0,19760790.00000000,19760790.43000000,3556942.28000000,0.00000000,0.00000000,23317732.71000000,1,NULL,NULL,0,500.00000000,NULL,0,7,NULL,2,'EUR',1900.00000000,1900.00000000,342.00000000,2242.00000000),(120,15,NULL,NULL,NULL,'<u><strong>ELECTRICITE (unit&eacute;) :</strong></u><br />\r\n* Fourniture et branchement des prises &eacute;lectriques selon le plan fourni.',NULL,'TVA',18.000,0.000,'1',0.000,'0',23,0,0,436817,436817.00000000,10046791.00000000,1808422.38000000,0.00000000,0.00000000,11855213.38000000,0,NULL,NULL,0,30.00000000,NULL,0,2,NULL,2,'EUR',42.00000000,966.00000000,173.88000000,1139.88000000),(121,15,NULL,NULL,NULL,'<u><strong>MENUISERIE (unit&eacute;) :</strong></u><br />\r\n* Fourniture et int&eacute;gration d&#39;un bloc porte en bois double vantaux 180/210.<br />\r\n* Quincaillerie de fermeture, poignet, canon et b&eacute;quille.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,0,6188248.00000000,6188247.53000000,1113884.56000000,0.00000000,0.00000000,7302132.09000000,0,NULL,NULL,0,350.00000000,NULL,0,3,NULL,2,'EUR',595.00000000,595.00000000,107.10000000,702.10000000),(122,15,NULL,NULL,NULL,'<u><strong>PLOMBERIE (forfait) :</strong></u><br />\r\n* Fourniture et installation d&#39;un evier avec un syst&egrave;me d&#39;&eacute;vacuation provisoire.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,3120125.00000000,3120124.80000000,561622.50000000,0.00000000,0.00000000,3681747.50000000,0,NULL,NULL,0,200.00000000,NULL,0,5,NULL,2,'EUR',300.00000000,300.00000000,54.00000000,354.00000000),(123,15,NULL,NULL,NULL,'<u><strong>QUINCAILLERIE (forfait) :</strong></u><br />\r\n* Fourniture et installation de serrures pour les tirroirs de gondoles d&eacute;t&eacute;rior&eacute;es.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,0,1560062.00000000,1560062.40000000,280811.23000000,0.00000000,0.00000000,1840873.63000000,0,NULL,NULL,0,75.00000000,NULL,0,6,NULL,2,'EUR',150.00000000,150.00000000,27.00000000,177.00000000),(124,15,NULL,NULL,NULL,'<u><strong>MENUISERIE (unit&eacute;) :</strong></u><br />\r\n* Fourniture et installation de tablette PMR en bois pour les caisses du BAR et du DFS.',NULL,'TVA',18.000,0.000,'1',0.000,'0',2,0,0,0,2496100.00000000,4992199.69000000,898595.94000000,0.00000000,0.00000000,5890795.63000000,0,NULL,NULL,0,100.00000000,NULL,0,4,NULL,2,'EUR',240.00000000,480.00000000,86.40000000,566.40000000),(125,15,NULL,NULL,NULL,'<u><strong>PALISSADE DE CHANTIER (ml) :</strong></u><br />\r\n* Fourniture et pose d&#39;une palissade de chantier autoportante en contreplaqu&eacute; 18mm, hauteur 2,50m pour la zone de chantier selon les phases de travail.<br />\r\nLa palissade sera maintenue par une structure amovible compos&eacute;e de poteaux m&eacute;talliques sur pied&nbsp;&nbsp;',NULL,'TVA',18.000,0.000,'1',0.000,'0',100,0,0,0,3109724.00000000,310972438.90000000,55975039.00000000,0.00000000,0.00000000,366947477.90000004,0,NULL,NULL,0,113.00000000,NULL,0,8,NULL,2,'EUR',299.00000000,29900.00000000,5382.00000000,35282.00000000),(126,15,NULL,NULL,NULL,'<u><strong>FIN DU CHANTIER (forfait) :</strong></u><br />\r\n* D&eacute;pose et &eacute;vacuation du BAR et du DFS &eacute;ph&eacute;m&egrave;re lors de l&#39;ouverture d&eacute;finitve apr&egrave;s travaux.<br />\r\n* Grand n&eacute;ttoyage des diff&egrave;rentes zones de travaux et &eacute;ph&eacute;m&egrave;re.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,0,9360374.00000000,9360374.41000000,1684867.40000000,0.00000000,0.00000000,11045241.81000000,1,NULL,NULL,0,250.00000000,NULL,0,10,NULL,2,'EUR',900.00000000,900.00000000,162.00000000,1062.00000000),(127,15,NULL,NULL,NULL,'<u><strong>EVOLUTION DU CHANTIER (unit&eacute;) :</strong></u><br />\r\n* Mise &agrave; disposition d&#39;une &eacute;quipe pour la d&eacute;placement des palissades &agrave; chaque &eacute;volution des phases de travaux.<br />\r\n* D&eacute;pose et &eacute;vacuation des palissades de chantier &agrave; la fin des travaux.',NULL,'TVA',18.000,0.000,'1',0.000,'0',4,0,0,2600104,2600104.00000000,10400416.00000000,1872074.88000000,0.00000000,0.00000000,12272490.88000000,1,NULL,NULL,0,100.00000000,NULL,0,9,NULL,2,'EUR',250.00000000,1000.00000000,180.00000000,1180.00000000),(128,16,NULL,NULL,NULL,'<u><strong>PEINTURE (m2) :</strong></u><br />\r\n* Fourniture et application de deux couches de peinture couleur MF087 sur les deux fa&ccedil;ades c&ocirc;t&eacute;s MER et PISCINE.',NULL,'TVA',18.000,0.000,'1',0.000,'0',350,0,0,34500,34500.00000000,12075000.00000000,2173500.00000000,0.00000000,0.00000000,14248500.00000000,0,NULL,NULL,0,19188.00000000,NULL,0,1,NULL,1,'GNF',34500.00000000,12075000.00000000,2173500.00000000,14248500.00000000),(129,16,NULL,NULL,NULL,'<u><strong>ECHAFFAUDAGE (forfait) :</strong></u><br />\r\n* Mise &agrave; disposition et d&eacute;placement de l&#39;&eacute;chaffaudage au cours de l&#39;&eacute;volution du chantier.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,1000000,1000000.00000000,1000000.00000000,180000.00000000,0.00000000,0.00000000,1180000.00000000,1,NULL,NULL,0,1.00000000,NULL,0,2,NULL,1,'GNF',1000000.00000000,1000000.00000000,180000.00000000,1180000.00000000),(130,17,NULL,23,NULL,'R&eacute;alisation d&#39;une cloison deux faces en parement simple BA13 Standart (m2)',NULL,'TVA',18.000,0.000,'1',0.000,'0',22,0,0,NULL,314345.00000000,6915590.00000000,1244806.20000000,0.00000000,0.00000000,8160396.20000000,0,NULL,NULL,0,241805.00000000,NULL,0,1,NULL,1,'GNF',314345.00000000,6915590.00000000,1244806.20000000,8160396.20000000),(131,17,NULL,NULL,NULL,'Fournir et pose d&#39;un isolant phonique &agrave; l&#39;interieur de la cloison (m2).',NULL,'TVA',18.000,0.000,'1',0.000,'0',22,0,0,70000,70000.00000000,1540000.00000000,277200.00000000,0.00000000,0.00000000,1817200.00000000,0,NULL,NULL,0,50000.00000000,NULL,0,2,NULL,1,'GNF',70000.00000000,1540000.00000000,277200.00000000,1817200.00000000),(132,12,NULL,NULL,NULL,'<u><strong>CLOISONNEMENT + PLAFOND DATA CENTER ET SALLE ENERGIE (m2) :</strong></u><br />\r\n* Fourniture et installation des armatures m&eacute;tallique 48mm pour le cloisonnement des diff&egrave;rents espaces.<br />\r\n* Fourniture et r&eacute;alisation des cloisons en plaque de pl&acirc;tre BA13 Ignifug&eacute;, double peau de chaque c&ocirc;t&eacute; permettant un coupe feu de 1H.<br />\r\n* Fourniture et r&eacute;alisation des enduits de finition et des pon&ccedil;age.',NULL,'TVA',18.000,0.000,'1',0.000,'0',315,0,0,435000,435000.00000000,137025000.00000000,24664500.00000000,0.00000000,0.00000000,161689500.00000000,0,NULL,NULL,0,250000.00000000,NULL,0,6,NULL,1,'GNF',435000.00000000,137025000.00000000,24664500.00000000,161689500.00000000),(133,12,NULL,NULL,NULL,'<u><strong>MENUISERIE (unit&eacute;) :</strong></u><br />\r\n* Fourniture et installation d&#39;une porte coupe-feu 1H.',NULL,'TVA',18.000,0.000,'1',0.000,'0',2,0,0,46068750,46068750.00000000,92137500.00000000,16584750.00000000,0.00000000,0.00000000,108722250.00000000,0,NULL,NULL,0,35437500.00000000,NULL,0,15,NULL,1,'GNF',46068750.00000000,92137500.00000000,16584750.00000000,108722250.00000000),(134,12,NULL,NULL,NULL,'<u><strong>FAUX PLANCHER (m2) :</strong></u><br />\r\n* Fourniture et installation d&quot;un faux-plancher d&#39;une hauteur de 40cm dans la salle du DATA CENTER.',NULL,'TVA',18.000,0.000,'1',0.000,'0',9,0,0,1170000,1170000.00000000,10530000.00000000,1895400.00000000,0.00000000,0.00000000,12425400.00000000,0,NULL,NULL,0,900000.00000000,NULL,0,12,NULL,1,'GNF',1170000.00000000,10530000.00000000,1895400.00000000,12425400.00000000),(138,18,NULL,NULL,NULL,'<u><strong>DETECTION INCENDIE ZONE BUREAU (ensemble) :</strong></u><br />\r\n* 21 D&eacute;tecteurs optiques Type PL32020S<br />\r\n* 3 D&eacute;clencheurs manuels Type DM 3202<br />\r\n* 2 Diffuseurs sonores et lumineux Type SOLISTA<br />\r\n* 5 Diffuseurs sonores type DS Type ROLP-R<br />\r\nRaccordement - Programmation - Adressage - Essais - Formation.<br />\r\nR&eacute;alisation d&#39;un dossier d&#39;identit&eacute; avec plan d&#39;implantation.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,167353200.00000000,167353200.00000000,30123576.00000000,0.00000000,0.00000000,197476776.00000000,0,NULL,NULL,0,139461000.00000000,NULL,0,1,NULL,1,'GNF',167353200.00000000,167353200.00000000,30123576.00000000,197476776.00000000),(139,18,NULL,NULL,NULL,'<u><strong>VIDEO - SURVEILLANCE (ensemble) :</strong></u><br />\r\n* 1 Enregistreur num&eacute;rique jusqu&#39;&agrave; 2MO pour 4 cam&eacute;ras DVR16CH 1TB RAW-Dual HDMI&amp;VGA<br />\r\n* 2 Disques dur SATA 3TO<br />\r\n* 4 Cam&eacute;ras Int&eacute;rieures Type AHD CCTV IR Full HD<br />\r\n* 1 Ecran Vid&eacute;o informatique 22&quot; TFT Plat<br />\r\nProgrammation - Essais - Pose&amp;Installation - Formation.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,69300000.00000000,69300000.00000000,12474000.00000000,0.00000000,0.00000000,81774000.00000000,0,NULL,NULL,0,57750000.00000000,NULL,0,2,NULL,1,'GNF',69300000.00000000,69300000.00000000,12474000.00000000,81774000.00000000),(140,18,NULL,NULL,NULL,'<u><strong>CONTROLE D&#39;ACCES (ensemble) :</strong></u><br />\r\n* 1 Centrale de gestion contr&ocirc;le d&#39;acc&egrave;s avec lecteur de proximit&eacute; int&eacute;gr&eacute; Type CENTAUR CRT 3000L<br />\r\n* 3 Lecteurs de proximit&eacute; Anti-Vandale avec interface pour ELA<br />\r\n* 1 Logiciel de gestion de centrale Type LOGCT 3000<br />\r\n* 1 Alimentation 12Volts avec batterie en secours pour la centrale<br />\r\n* 3 Alimentation 12Volts pour les ventouses des portes contr&ocirc;l&eacute;es<br />\r\n* 3 D&eacute;clencheurs manuels vert Type &quot;PER 221122&quot;<br />\r\n* 3 Ventouses saillies 300kg avec relais et syst&egrave;me de fixation type ECS8000M<br />\r\n* 3 Boutons d&#39;ouverture de porte avec contact NO/NF Type Mosaic Legrand<br />\r\n* 1 Encodeur USB Type CDVR 125USB pour lecteur programmation des badges sur PC<br />\r\n* 15 Badges proximit&eacute; Type EM4102 Gris<br />\r\nR&eacute;alisation - Programmation - Adressage - Installation -Formation.&nbsp;',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,138600000.00000000,138600000.00000000,24948000.00000000,0.00000000,0.00000000,163548000.00000000,0,NULL,NULL,0,115500000.00000000,NULL,0,3,NULL,1,'GNF',138600000.00000000,138600000.00000000,24948000.00000000,163548000.00000000),(141,19,NULL,NULL,NULL,'<u><strong>INSTALLATION DU CHANTIER (forfait) :</strong></u><br />\r\n* Approvisionnement des mat&eacute;riaux.<br />\r\n* Protecteur des sols et des &eacute;l&egrave;ments pr&eacute;sents sur la chantier.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,9000000.00000000,9000000.00000000,1620000.00000000,0.00000000,0.00000000,10620000.00000000,0,NULL,NULL,0,4500000.00000000,NULL,0,1,NULL,1,'GNF',9000000.00000000,9000000.00000000,1620000.00000000,10620000.00000000),(142,19,NULL,NULL,NULL,'<u><strong>DEMOLITION (m2) :</strong></u><br />\r\n* D&eacute;molition des ma&ccedil;onneries et &eacute;vacuations des gravats.<br />\r\n* R&eacute;prise des finitions suite &agrave; la d&eacute;molition.',NULL,'TVA',18.000,0.000,'1',0.000,'0',12,0,0,390000,390000.00000000,4680000.00000000,842400.00000000,0.00000000,0.00000000,5522400.00000000,0,NULL,NULL,0,200000.00000000,NULL,0,2,NULL,1,'GNF',390000.00000000,4680000.00000000,842400.00000000,5522400.00000000),(143,19,NULL,NULL,NULL,'<u><strong>CLOISONNEMENT SALLE ARCHIVE ET MODIFICATION SALLE REUNION (m2) :</strong></u><br />\r\n* Fourniture et installation des armature m&eacute;tallique 48mm pour le cloisonnement des diff&eacute;rents espaces.<br />\r\n* Fourniture et r&eacute;alisation des cloisons en plaque de pl&acirc;tre BA13 (une peau de chaque c&ocirc;t&eacute;).<br />\r\n* Fourniture et r&eacute;alisation des enduits de finition et des pon&ccedil;ages.',NULL,'TVA',18.000,0.000,'1',0.000,'0',17,0,0,NULL,365000.00000000,6205000.00000000,1116900.00000000,0.00000000,0.00000000,7321900.00000000,0,NULL,NULL,0,257120.00000000,NULL,0,3,NULL,1,'GNF',365000.00000000,6205000.00000000,1116900.00000000,7321900.00000000),(144,19,NULL,NULL,NULL,'<u><strong>ISOLANT (m2) :</strong></u><br />\r\n* Fourniture et pose d&#39;une isolation acoustique et thermique, sp&eacute;cifique aux cloisons distributives.',NULL,'TVA',18.000,0.000,'1',0.000,'0',17,0,0,NULL,89500.00000000,1521500.00000000,273870.00000000,0.00000000,0.00000000,1795370.00000000,0,NULL,NULL,0,54123.00000000,NULL,0,4,NULL,1,'GNF',89500.00000000,1521500.00000000,273870.00000000,1795370.00000000),(145,19,NULL,NULL,NULL,'<u><strong>PEINTURE (m2) :</strong></u><br />\r\n* Fourniture et application d&#39;un primaire d&#39;accrochage pour plaque de pl&acirc;tre BA13.<br />\r\n* Fourniture et application d&#39;une peinture de finition blanche sur les cloisons de pl&acirc;tre (deux couches).',NULL,'TVA',18.000,0.000,'1',0.000,'0',34,0,0,NULL,34900.00000000,1186600.00000000,213588.00000000,0.00000000,0.00000000,1400188.00000000,0,NULL,NULL,0,19855.00000000,NULL,0,7,NULL,1,'GNF',34900.00000000,1186600.00000000,213588.00000000,1400188.00000000),(146,19,NULL,NULL,NULL,'<u><strong>PEINTURE (m2) :</strong></u><br />\r\n* Fourniture et application d&#39;une peinture de finition blanche sur les murs ma&ccedil;onnerie existantes (deux couches).<br />\r\n* Fourniture et application d&#39;une peinture de finition blanche sur les plafonds (deux couches).',NULL,'TVA',18.000,0.000,'1',0.000,'0',350,0,0,29900,29900.00000000,10465000.00000000,1883700.00000000,0.00000000,0.00000000,12348700.00000000,0,NULL,NULL,0,17900.00000000,NULL,0,8,NULL,1,'GNF',29900.00000000,10465000.00000000,1883700.00000000,12348700.00000000),(147,19,NULL,NULL,NULL,'<u><strong>MENUISERIE (unit&eacute;) :</strong></u><br />\r\n* Fourniture et pose d&#39;une porte aluminium blanc laqu&eacute; 80/200, pour la salle archive<br />\r\nAluminium 12/10&egrave;me, verre 6mm, quincaillerie fournis.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,3500000.00000000,3500000.00000000,630000.00000000,0.00000000,0.00000000,4130000.00000000,0,NULL,NULL,0,2500000.00000000,NULL,0,6,NULL,1,'GNF',3500000.00000000,3500000.00000000,630000.00000000,4130000.00000000),(148,19,NULL,NULL,NULL,'<u><strong>ELECTRICITE (unit&eacute;) :</strong></u><br />\r\n* Fourniture, c&acirc;blage puis branchement d&#39;un r&eacute;seau &eacute;lectrique prises standarts et ondul&eacute;es sous goulotte murale en p&eacute;rifirie des salles de r&eacute;unions et internet caf&eacute;.<br />\r\n(24 postes en raison de 2 prises standarts et 2 prises ondul&eacute;es par poste).',NULL,'TVA',18.000,0.000,'1',0.000,'0',96,0,0,430000,430000.00000000,41280000.00000000,7430400.00000000,0.00000000,0.00000000,48710400.00000000,0,NULL,NULL,0,286000.00000000,NULL,0,11,NULL,1,'GNF',430000.00000000,41280000.00000000,7430400.00000000,48710400.00000000),(149,19,NULL,NULL,NULL,'<u><strong>CARRELAGE (ml) :</strong></u><br />\r\n* Fourniture et pose de plinthes carrelage sur les bas de cloisons r&eacute;alis&eacute;es.',NULL,'TVA',18.000,0.000,'1',0.000,'0',12,0,0,NULL,35000.00000000,420000.00000000,75600.00000000,0.00000000,0.00000000,495600.00000000,0,NULL,NULL,0,10000.00000000,NULL,0,5,NULL,1,'GNF',35000.00000000,420000.00000000,75600.00000000,495600.00000000),(150,19,NULL,NULL,NULL,'<u><strong>ELECTRICITE (ml) :</strong></u><br />\r\n* Fourniture et mise en place du c&acirc;ble &eacute;lectrique de liaison du stabilisateur du 9&egrave;me &eacute;tage au compteur du 3&egrave;me &eacute;tage.<br />\r\nLa section du c&acirc;ble sera d&eacute;fini en rapport &agrave; la charge nominale.',NULL,'TVA',18.000,0.000,'1',0.000,'0',50,0,0,150000,150000.00000000,7500000.00000000,1350000.00000000,0.00000000,0.00000000,8850000.00000000,0,NULL,NULL,0,70000.00000000,NULL,0,9,NULL,1,'GNF',150000.00000000,7500000.00000000,1350000.00000000,8850000.00000000),(153,19,NULL,NULL,NULL,'<u><strong>FIN DE CHANTIER (forfait ) :</strong></u><br />\r\n* Nettoyage complet du chantier.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,3000000.00000000,3000000.00000000,540000.00000000,0.00000000,0.00000000,3540000.00000000,0,NULL,NULL,0,1000000.00000000,NULL,0,14,NULL,1,'GNF',3000000.00000000,3000000.00000000,540000.00000000,3540000.00000000),(160,20,NULL,NULL,NULL,'Panneau de Brassage 48 ports CAT6',NULL,'TVA',18.000,0.000,'1',0.000,'0',3,0,0,5850000,5850000.00000000,17550000.00000000,3159000.00000000,0.00000000,0.00000000,20709000.00000000,0,NULL,NULL,0,0.00000000,NULL,0,1,NULL,1,'GNF',5850000.00000000,17550000.00000000,3159000.00000000,20709000.00000000),(161,20,NULL,NULL,NULL,'800m de c&acirc;ble UTP Cat 6e',NULL,'TVA',18.000,0.000,'1',0.000,'0',800,0,0,10125,10125.00000000,8100000.00000000,1458000.00000000,0.00000000,0.00000000,9558000.00000000,0,NULL,NULL,0,0.00000000,NULL,0,2,NULL,1,'GNF',10125.00000000,8100000.00000000,1458000.00000000,9558000.00000000),(162,20,NULL,NULL,NULL,'Prise informatique Cat 6',NULL,'TVA',18.000,0.000,'1',0.000,'0',116,0,0,101250,101250.00000000,11745000.00000000,2114100.00000000,0.00000000,0.00000000,13859100.00000000,0,NULL,NULL,0,0.00000000,NULL,0,3,NULL,1,'GNF',101250.00000000,11745000.00000000,2114100.00000000,13859100.00000000),(163,20,NULL,NULL,NULL,'Boitier encastr&eacute;',NULL,'TVA',18.000,0.000,'1',0.000,'0',116,0,0,37800,37800.00000000,4384800.00000000,789264.00000000,0.00000000,0.00000000,5174064.00000000,0,NULL,NULL,0,0.00000000,NULL,0,4,NULL,1,'GNF',37800.00000000,4384800.00000000,789264.00000000,5174064.00000000),(164,20,NULL,NULL,NULL,'Cordon de brassage 1 m',NULL,'TVA',18.000,0.000,'1',0.000,'0',87,0,0,33750,33750.00000000,2936250.00000000,528525.00000000,0.00000000,0.00000000,3464775.00000000,0,NULL,NULL,0,0.00000000,NULL,0,5,NULL,1,'GNF',33750.00000000,2936250.00000000,528525.00000000,3464775.00000000),(165,20,NULL,NULL,NULL,'Cordon de brassage 3 m',NULL,'TVA',18.000,0.000,'1',0.000,'0',87,0,0,49275,49275.00000000,4286925.00000000,771646.50000000,0.00000000,0.00000000,5058571.50000000,0,NULL,NULL,0,0.00000000,NULL,0,6,NULL,1,'GNF',49275.00000000,4286925.00000000,771646.50000000,5058571.50000000),(167,20,NULL,NULL,NULL,'Fourniture de chemins de cables et accesoires',NULL,'TVA',18.000,0.000,'1',0.000,'0',56,0,0,NULL,109039.00000000,6106184.00000000,1099113.12000000,0.00000000,0.00000000,7205297.12000000,0,NULL,NULL,0,0.00000000,NULL,0,7,NULL,1,'GNF',109039.00000000,6106184.00000000,1099113.12000000,7205297.12000000),(168,20,NULL,NULL,NULL,'Approvisionnement pose de chemin de cable - passage des cables informatiques - raccordement des cables -&nbsp; fourniture d&#39;un boitier de recetage et essaie',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,50750000.00000000,50750000.00000000,9135000.00000000,0.00000000,0.00000000,59885000.00000000,0,NULL,NULL,0,0.00000000,NULL,0,8,NULL,1,'GNF',50750000.00000000,50750000.00000000,9135000.00000000,59885000.00000000),(169,21,NULL,NULL,NULL,'Installation et replie du chantier ( forfait)',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,10,150000,1350000,1500000.00000000,1350000.00000000,243000.00000000,0.00000000,0.00000000,1593000.00000000,0,NULL,NULL,0,0.00000000,NULL,0,1,NULL,1,'GNF',1500000.00000000,1350000.00000000,243000.00000000,1593000.00000000),(170,21,NULL,NULL,NULL,'Decapage des pav&eacute;es&nbsp; m2',NULL,'TVA',18.000,0.000,'1',0.000,'0',100.8,10,2500,22500,25000.00000000,2268000.00000000,408240.00000000,0.00000000,0.00000000,2676240.00000000,0,NULL,NULL,0,0.00000000,NULL,0,2,NULL,1,'GNF',25000.00000000,2268000.00000000,408240.00000000,2676240.00000000),(171,21,NULL,NULL,NULL,'Fouille de 15 cm de profondeur m3',NULL,'TVA',18.000,0.000,'1',0.000,'0',100000,10,1.5,13.5,15.00000000,1350000.00000000,243000.00000000,0.00000000,0.00000000,1593000.00000000,0,NULL,NULL,0,0.00000000,NULL,0,3,NULL,1,'GNF',15.00000000,1350000.00000000,243000.00000000,1593000.00000000),(172,21,NULL,NULL,NULL,'Beton sol arm&eacute; de 10 cm dose &agrave; 350 kg m3',NULL,'TVA',18.000,0.000,'1',0.000,'0',10.08,10,250000,2250000,2500000.00000000,22680000.00000000,4082400.00000000,0.00000000,0.00000000,26762400.00000000,0,NULL,NULL,0,0.00000000,NULL,0,4,NULL,1,'GNF',2500000.00000000,22680000.00000000,4082400.00000000,26762400.00000000),(173,21,NULL,NULL,NULL,'Pose des pav&eacute;es m2',NULL,'TVA',18.000,0.000,'1',0.000,'0',100.8,10,8000,72000,80000.00000000,7257600.00000000,1306368.00000000,0.00000000,0.00000000,8563968.00000000,0,NULL,NULL,0,0.00000000,NULL,0,5,NULL,1,'GNF',80000.00000000,7257600.00000000,1306368.00000000,8563968.00000000),(174,21,NULL,NULL,NULL,'Ouverture d&#39;une fen&ecirc;tre de 1,20*1,00 (forfait)',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,10,150000,1350000,1500000.00000000,1350000.00000000,243000.00000000,0.00000000,0.00000000,1593000.00000000,0,NULL,NULL,0,0.00000000,NULL,0,6,NULL,1,'GNF',1500000.00000000,1350000.00000000,243000.00000000,1593000.00000000),(175,21,NULL,NULL,NULL,'Fourniture et pose d&#39;une grille de 1,2m*1,00m',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,10,200000,1800000,2000000.00000000,1800000.00000000,324000.00000000,0.00000000,0.00000000,2124000.00000000,0,NULL,NULL,0,0.00000000,NULL,0,7,NULL,1,'GNF',2000000.00000000,1800000.00000000,324000.00000000,2124000.00000000),(176,24,NULL,NULL,NULL,'<u><strong>UNITE DE CLIMATISATION DE PRECISION :</strong></u><br />\r\n* Puissance froid (totale) : 12KW<br />\r\n* Volume d&#39;air : 3600m3/h<br />\r\n* Poids environ : 140kg<br />\r\n* R&eacute;frig&eacute;rant : R407C<br />\r\n<u><strong>OPTIONS :</strong></u><br />\r\n* Sonde humidit&eacute; ambiante et contr&ocirc;le deshumidification<br />\r\n* Alarme active eau sous le faux plancher<br />\r\n* Alarme fum&eacute;&eacute; / feu<br />\r\n* R&eacute;seau local master-slave',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,247138750,247138750.00000000,247138750.00000000,44484975.00000000,0.00000000,0.00000000,291623725.00000000,0,NULL,NULL,0,197711000.00000000,NULL,0,1,NULL,1,'GNF',247138750.00000000,247138750.00000000,44484975.00000000,291623725.00000000),(177,24,NULL,NULL,NULL,'<u><strong>MATERIEL D&#39;INSTALLATION :</strong></u><br />\r\n* Cuivre 5/8 (30m)<br />\r\n* Cuivre 3/8 (30m)<br />\r\n* Armaflex (70m)<br />\r\n* C&acirc;ble 3*1.5mm2 (60m)<br />\r\n* Coude 7/8 (18pcs)<br />\r\n* PVC 32 (40m)<br />\r\n* Chemin de c&acirc;ble + fixation (30m)<br />\r\n* Bouteille Gaz R410A (2pcs)<br />\r\n* C&acirc;ble &eacute;lectrique d&#39;alimentation 5*6mm (40m)<br />\r\n* Disjoncteur de protection 32A (1pcs)',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,38576500,38576500.00000000,38576500.00000000,6943770.00000000,0.00000000,0.00000000,45520270.00000000,0,NULL,NULL,0,19288250.00000000,NULL,0,2,NULL,1,'GNF',38576500.00000000,38576500.00000000,6943770.00000000,45520270.00000000),(178,24,NULL,NULL,NULL,'<u><strong>INTALLATION ET MISE EN SERVICE DES APPAREILS</strong></u>',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,12500000,12500000.00000000,12500000.00000000,2250000.00000000,0.00000000,0.00000000,14750000.00000000,1,NULL,NULL,0,10000000.00000000,NULL,0,3,NULL,1,'GNF',12500000.00000000,12500000.00000000,2250000.00000000,14750000.00000000),(179,24,NULL,NULL,NULL,'<u><strong>DEPLACEMENT ET MANUTENTION DES EQUIPEMENTS JUSQU&#39;A L&#39;EMPLACEMENT DEFINITIVE&nbsp;</strong></u>',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,20000000.00000000,20000000.00000000,3600000.00000000,0.00000000,0.00000000,23600000.00000000,1,NULL,NULL,0,20000000.00000000,NULL,0,4,NULL,1,'GNF',20000000.00000000,20000000.00000000,3600000.00000000,23600000.00000000),(180,24,NULL,NULL,NULL,'<u><strong>INSTALLATION D&#39;UNE CLIMATISATION DE BACK-UP</strong></u><br />\r\nAfin que l&#39;installation soit op&eacute;rationnelle, les travaux se feront en deux phases.<br />\r\n<strong>* PHASE 1 :</strong> Installation de la climatisation de back-up<br />\r\n<strong>* PHASE 2 :</strong> Installation du syst&egrave;me final &agrave; r&eacute;ception des &eacute;quipements<br />\r\n<br />\r\nSplit Mural 24000BTU<br />\r\nT&eacute;l&eacute;commande infra rouge.<br />\r\nTous les accessoires et les frais d&#39;installations.',NULL,'TVA',18.000,0.000,'1',0.000,'0',2,0,0,19800000,19800000.00000000,39600000.00000000,7128000.00000000,0.00000000,0.00000000,46728000.00000000,1,NULL,NULL,0,11974100.00000000,NULL,0,5,NULL,1,'GNF',19800000.00000000,39600000.00000000,7128000.00000000,46728000.00000000),(187,26,NULL,NULL,NULL,'<u><strong>MACONNERIE (m2) :</strong></u><br />\r\n* R&eacute;alisation d&#39;un bar en ma&ccedil;onnerie (brique de 15 + crepissage des deux faces).',NULL,'TVA',18.000,0.000,'1',0.000,'0',2.1,0,0,NULL,400000.00000000,840000.00000000,151200.00000000,0.00000000,0.00000000,991200.00000000,1,NULL,NULL,0,0.00000000,NULL,0,1,NULL,1,'GNF',400000.00000000,840000.00000000,151200.00000000,991200.00000000),(188,26,NULL,NULL,NULL,'<u><strong>PEINTURE MUR (m2) :</strong></u><br />\r\n* Fourniture et application de deux couches de peinture (teinte fonc&eacute;e) + reprise des enduits si n&eacute;cessaire.',NULL,'TVA',18.000,0.000,'1',0.000,'0',84,0,0,NULL,69000.00000000,5796000.00000000,1043280.00000000,0.00000000,0.00000000,6839280.00000000,1,NULL,NULL,0,51000.00000000,NULL,0,2,NULL,1,'GNF',69000.00000000,5796000.00000000,1043280.00000000,6839280.00000000),(189,26,NULL,NULL,NULL,'<u><strong>PEINTURE PLAFOND (m2) :</strong></u><br />\r\n* Fourniture et application de deux couches de peinture (teinte fonc&eacute;e) + reprise des enduits si n&eacute;cessaire.',NULL,'TVA',18.000,0.000,'1',0.000,'0',40,0,0,NULL,75000.00000000,3000000.00000000,540000.00000000,0.00000000,0.00000000,3540000.00000000,1,NULL,NULL,0,0.00000000,NULL,0,3,NULL,1,'GNF',75000.00000000,3000000.00000000,540000.00000000,3540000.00000000),(190,26,NULL,NULL,NULL,'<u><strong>INSTALLATION (forfait) :</strong></u><br />\r\n* Pose de la porte des toilettes.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,500000.00000000,500000.00000000,90000.00000000,0.00000000,0.00000000,590000.00000000,1,NULL,NULL,0,0.00000000,NULL,0,4,NULL,1,'GNF',500000.00000000,500000.00000000,90000.00000000,590000.00000000),(191,26,NULL,NULL,NULL,'<u><strong>ELECTRICITE (forfait) :</strong></u><br />\r\n* Repose des luminaires existants.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,1000000.00000000,1000000.00000000,180000.00000000,0.00000000,0.00000000,1180000.00000000,1,NULL,NULL,0,0.00000000,NULL,0,5,NULL,1,'GNF',1000000.00000000,1000000.00000000,180000.00000000,1180000.00000000),(192,26,NULL,NULL,NULL,'<u><strong>MACONNERIE (forfait) :</strong></u><br />\r\n* R&eacute;alisation d&#39;un plan de travail carrel&eacute;.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,2600000,2600000.00000000,2600000.00000000,468000.00000000,0.00000000,0.00000000,3068000.00000000,0,NULL,NULL,0,0.00000000,NULL,0,6,NULL,1,'GNF',2600000.00000000,2600000.00000000,468000.00000000,3068000.00000000),(193,26,NULL,NULL,NULL,'<u><strong>PLOMBERIE (forfait) :</strong></u><br />\r\n* Fourniture et r&eacute;alisation des arriv&eacute;es et &eacute;vacuations d&#39;eau.<br />\r\n* Fourniture et pose d&#39;un &eacute;vier et robinet.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,3500000,3500000.00000000,3500000.00000000,630000.00000000,0.00000000,0.00000000,4130000.00000000,0,NULL,NULL,0,0.00000000,NULL,0,7,NULL,1,'GNF',3500000.00000000,3500000.00000000,630000.00000000,4130000.00000000),(194,27,NULL,NULL,NULL,'<p><u><strong>FOURNITURE ET INSTALLATION D&#39;UN VISIOPHONE 1 POSTE AVEC CONTACT D&#39;OUVERTURE DE PORTE :</strong></u><br />\r\n<strong>Caract&egrave;ristiques :</strong><br />\r\nFa&ccedil;ades aimant&eacute;es interchangeables &agrave; volont&eacute; (noire ou blanche). Ouverture depuis la platine de rue avec les badges RFID. Double ouverture portail et serrure depuis l&#39;&eacute;cran int&eacute;rieur. M&eacute;morisation des visiteurs.</p>\r\n\r\n<p>Platine de rue : cam&eacute;ra avec angle de vue de 90&deg;, cam&eacute;ra r&eacute;glable &agrave; la verticale et &agrave; l&rsquo;horizontale, LED infrarouges pour la vision nocturne jusqu&rsquo;&agrave; 1,5m, porte nom avec r&eacute;tro &eacute;clairage. Ecran : &eacute;cran couleur TFT LCD 7&rsquo;&rsquo;, fa&ccedil;ades aimant&eacute;es interchangeables (noire ou blanche), luminosit&eacute; et contraste de l&rsquo;&eacute;cran r&eacute;glable, 7 m&eacute;lodies, volume de la sonnerie r&eacute;glable, volume de la voix r&eacute;glable. Installation : installation de la platine de rue : saillie, distance max platine et &eacute;cran int&eacute;rieur : 100m, 2 fils : 1m &ndash; 100m = 1,5mm2.</p>',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,6258000,6258000.00000000,6258000.00000000,1126440.00000000,0.00000000,0.00000000,7384440.00000000,0,NULL,NULL,0,2659650.00000000,NULL,0,1,NULL,1,'GNF',6258000.00000000,6258000.00000000,1126440.00000000,7384440.00000000),(195,27,NULL,NULL,NULL,'Transformateur modulaire 12Volts',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,1680000.00000000,1680000.00000000,302400.00000000,0.00000000,0.00000000,1982400.00000000,0,NULL,NULL,0,756000.00000000,NULL,0,2,NULL,1,'GNF',1680000.00000000,1680000.00000000,302400.00000000,1982400.00000000),(196,27,NULL,NULL,NULL,'G&acirc;che sp&eacute;cial pour l&#39;ouverture de la porte.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,630000.00000000,630000.00000000,113400.00000000,0.00000000,0.00000000,743400.00000000,0,NULL,NULL,0,267750.00000000,NULL,0,3,NULL,1,'GNF',630000.00000000,630000.00000000,113400.00000000,743400.00000000),(197,27,NULL,NULL,NULL,'Fourniture et r&eacute;alisation du c&acirc;blage &eacute;lectrique pour alimentation.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,400000.00000000,400000.00000000,72000.00000000,0.00000000,0.00000000,472000.00000000,1,NULL,NULL,0,300000.00000000,NULL,0,4,NULL,1,'GNF',400000.00000000,400000.00000000,72000.00000000,472000.00000000),(198,27,NULL,NULL,NULL,'Menuiserie pour pose de la g&acirc;che &eacute;lectrique sur la porte',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,1000000.00000000,1000000.00000000,180000.00000000,0.00000000,0.00000000,1180000.00000000,1,NULL,NULL,0,500000.00000000,NULL,0,5,NULL,1,'GNF',1000000.00000000,1000000.00000000,180000.00000000,1180000.00000000),(199,27,NULL,NULL,NULL,'Installation et essaies du syst&egrave;me.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,1000000.00000000,1000000.00000000,180000.00000000,0.00000000,0.00000000,1180000.00000000,1,NULL,NULL,0,500000.00000000,NULL,0,6,NULL,1,'GNF',1000000.00000000,1000000.00000000,180000.00000000,1180000.00000000),(200,19,NULL,NULL,NULL,'<u><strong>ILOT ACOUSTIQUE (unit&eacute;) :</strong></u><br />\r\nFourniture et pose d&#39;&icirc;lots acoustiques (environ 120*120*40) permettant la correction acoustique de la pi&egrave;ce par absorbtion des sons sur les deux faces. Les &icirc;lots permettent d&#39;atteindre un confort acoustique optimal en limitant les ph&eacute;nom&egrave;nes d&#39;&eacute;chos. Un syst&egrave;me d&#39;&eacute;clairage indirect par ruban LED sera install&eacute; sur certaines dalles.<br />\r\n&nbsp;',NULL,'TVA',18.000,0.000,'1',0.000,'0',12,0,0,NULL,3630000.00000000,43560000.00000000,7840800.00000000,0.00000000,0.00000000,51400800.00000000,0,NULL,NULL,0,2660000.00000000,NULL,0,13,NULL,1,'GNF',3630000.00000000,43560000.00000000,7840800.00000000,51400800.00000000),(201,19,NULL,NULL,NULL,'<u><strong>ELECTRICITE (forfait) :</strong></u><br />\r\n* Installation d&#39;un coffret &eacute;quip&eacute; des protections pour les prises ondul&eacute;es (disjoncteur diff&eacute;rentiel 30mA et disjoncteur 20A).',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,6760000,6760000.00000000,6760000.00000000,1216800.00000000,0.00000000,0.00000000,7976800.00000000,0,NULL,NULL,0,3240000.00000000,NULL,0,10,NULL,1,'GNF',6760000.00000000,6760000.00000000,1216800.00000000,7976800.00000000),(202,19,NULL,NULL,NULL,'<u><strong>CLIMATISATION (unit&eacute;) :</strong></u><br />\r\n* Fourniture et pose d&#39;une climatisation 18000BTU pour la salle internet caf&eacute;.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,9690000.00000000,9690000.00000000,1744200.00000000,0.00000000,0.00000000,11434200.00000000,0,NULL,NULL,0,8000000.00000000,NULL,0,12,NULL,1,'GNF',9690000.00000000,9690000.00000000,1744200.00000000,11434200.00000000),(203,28,NULL,NULL,NULL,'<u><strong>Fourniture et installation d&#39;un surpresseur :</strong></u><br />\r\n* Supresseur complet 05HP.<br />\r\n* Accessoires de pose (vannes d&#39;arr&ecirc;t laiton D32, clapets laiton D32, coudes laitons D32, mamellons galvanis&eacute;s).<br />\r\n* Flotteur m&eacute;canique et ses accessoires.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,2988000.00000000,2988000.00000000,537840.00000000,0.00000000,0.00000000,3525840.00000000,0,NULL,NULL,0,1660000.00000000,NULL,0,1,NULL,1,'GNF',2988000.00000000,2988000.00000000,537840.00000000,3525840.00000000),(204,29,NULL,NULL,NULL,'<u><strong>Montage et installation des meubles notifi&eacute;s ci-dessous (forfait) :</strong></u><br />\r\n* 2 Printer Cabinet.<br />\r\n* 2 Computer Cabinet.<br />\r\n* 7 Paper Box.<br />\r\n* 6 Prontdesk Standart.<br />\r\n* 3 Frontdesk Premium.<br />\r\n* 1 Desk Biom&egrave;tre (170*170).<br />\r\n* 1 Desk Biom&egrave;tre (180*200).<br />\r\n* 2 Photobooth<br />\r\n* 1 R&eacute;ception Desk 160.<br />\r\n* 1 S&eacute;curity Counter.<br />\r\n* 17 meubles Ik&eacute;a.<br />\r\n&nbsp;',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,9485295,9485295.00000000,9485295.00000000,1707353.10000000,0.00000000,0.00000000,11192648.10000000,1,NULL,NULL,0,6323530.00000000,NULL,0,1,NULL,1,'GNF',9485295.00000000,9485295.00000000,1707353.10000000,11192648.10000000),(205,29,NULL,NULL,NULL,'<u><strong>Installation de store (forfait) :</strong></u><br />\r\n* Montage, installation et r&eacute;glage des stores des fen&ecirc;tres ext&eacute;rieures.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,3000000.00000000,3000000.00000000,540000.00000000,0.00000000,0.00000000,3540000.00000000,1,NULL,NULL,0,1000000.00000000,NULL,0,2,NULL,1,'GNF',3000000.00000000,3000000.00000000,540000.00000000,3540000.00000000),(206,29,NULL,NULL,NULL,'<u><strong>Evacuation des d&eacute;chets et nettoyage apr&egrave;s l&#39;installation.</strong></u>',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,100,0,NULL,1500000.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,1,NULL,NULL,0,1000000.00000000,NULL,0,3,NULL,1,'GNF',1500000.00000000,0.00000000,0.00000000,0.00000000),(207,30,NULL,NULL,NULL,'<u><strong>MENUISERIE (unit&eacute;) :</strong></u><br />\r\n* Fourniture et installation de porte aluminium blanc laqu&eacute; 90/200 (traverse centrale).<br />\r\nAluminium 12/10&egrave;me, verre double, &eacute;paisseur cadre 7cm, quincailleries fournis.',NULL,'TVA',18.000,0.000,'1',0.000,'0',6,0,0,NULL,3500000.00000000,21000000.00000000,3780000.00000000,0.00000000,0.00000000,24780000.00000000,0,NULL,NULL,0,2000000.00000000,NULL,0,1,NULL,1,'GNF',3500000.00000000,21000000.00000000,3780000.00000000,24780000.00000000),(208,30,NULL,NULL,NULL,'<u><strong>CONTROLE D&#39;ACCES (unit&eacute;) :</strong></u><br />\r\n* Installation des syst&egrave;mes de contr&ocirc;le d&#39;acc&egrave;s, param&egrave;trage et formation.',NULL,'TVA',18.000,0.000,'1',0.000,'0',6,0,0,1899999,1899999.00000000,11399994.00000000,2051998.92000000,0.00000000,0.00000000,13451992.92000000,0,NULL,NULL,0,1583333.00000000,NULL,0,2,NULL,1,'GNF',1899999.00000000,11399994.00000000,2051998.92000000,13451992.92000000),(209,30,NULL,NULL,NULL,'<u><strong>ACCESOIRE POUR LE CONTR&Ocirc;LE D&#39;ACCES (ensemble) :</strong></u><br />\r\n* C&acirc;ble &eacute;lectrique NEXANS 3*2.5mm2.<br />\r\n* C&acirc;ble FTP cat&eacute;gorie 6 blind&eacute;.<br />\r\n* Gaine flexible diam&egrave;tre 25mm.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,4428000.00000000,4428000.00000000,797040.00000000,0.00000000,0.00000000,5225040.00000000,0,NULL,NULL,0,3690000.00000000,NULL,0,3,NULL,1,'GNF',4428000.00000000,4428000.00000000,797040.00000000,5225040.00000000),(210,31,NULL,NULL,NULL,'Barres TR 80/40',NULL,'TVA',18.000,0.000,'1',0.000,'0',35,0,0,377000,377000.00000000,13195000.00000000,2375100.00000000,0.00000000,0.00000000,15570100.00000000,0,NULL,NULL,0,290000.00000000,NULL,0,3,NULL,1,'GNF',377000.00000000,13195000.00000000,2375100.00000000,15570100.00000000),(211,31,NULL,NULL,NULL,'Barres TC 40*40',NULL,'TVA',18.000,0.000,'1',0.000,'0',90,0,0,169000,169000.00000000,15210000.00000000,2737800.00000000,0.00000000,0.00000000,17947800.00000000,0,NULL,NULL,0,130000.00000000,NULL,0,4,NULL,1,'GNF',169000.00000000,15210000.00000000,2737800.00000000,17947800.00000000),(212,31,NULL,NULL,NULL,'Barre de fer plat 30*8',NULL,'TVA',18.000,0.000,'1',0.000,'0',690,0,0,182000,182000.00000000,125580000.00000000,22604400.00000000,0.00000000,0.00000000,148184400.00000000,0,NULL,NULL,0,140000.00000000,NULL,0,5,NULL,1,'GNF',182000.00000000,125580000.00000000,22604400.00000000,148184400.00000000),(213,31,NULL,NULL,NULL,'Carton de baguette',NULL,'TVA',18.000,0.000,'1',0.000,'0',2,0,0,520000,520000.00000000,1040000.00000000,187200.00000000,0.00000000,0.00000000,1227200.00000000,0,NULL,NULL,0,400000.00000000,NULL,0,6,NULL,1,'GNF',520000.00000000,1040000.00000000,187200.00000000,1227200.00000000),(214,31,NULL,NULL,NULL,'Bidon de peinture',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,780000,780000.00000000,780000.00000000,140400.00000000,0.00000000,0.00000000,920400.00000000,0,NULL,NULL,0,600000.00000000,NULL,0,7,NULL,1,'GNF',780000.00000000,780000.00000000,140400.00000000,920400.00000000),(215,31,NULL,NULL,NULL,'Disque &agrave; couper',NULL,'TVA',18.000,0.000,'1',0.000,'0',50,0,0,19500,19500.00000000,975000.00000000,175500.00000000,0.00000000,0.00000000,1150500.00000000,0,NULL,NULL,0,15000.00000000,NULL,0,8,NULL,1,'GNF',19500.00000000,975000.00000000,175500.00000000,1150500.00000000),(216,31,NULL,NULL,NULL,'Transport',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,390000.00000000,390000.00000000,70200.00000000,0.00000000,0.00000000,460200.00000000,0,NULL,NULL,0,300000.00000000,NULL,0,11,NULL,1,'GNF',390000.00000000,390000.00000000,70200.00000000,460200.00000000),(217,31,NULL,NULL,NULL,'Main d&#39;oeuvre',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,19500000.00000000,19500000.00000000,3510000.00000000,0.00000000,0.00000000,23010000.00000000,0,NULL,NULL,0,15000000.00000000,NULL,0,12,NULL,1,'GNF',19500000.00000000,19500000.00000000,3510000.00000000,23010000.00000000),(218,31,NULL,NULL,NULL,'D&eacute;molition des barbelets existants plus &eacute;vacuation',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,20000000,20000000.00000000,20000000.00000000,3600000.00000000,0.00000000,0.00000000,23600000.00000000,1,NULL,NULL,0,10000000.00000000,NULL,0,2,NULL,1,'GNF',20000000.00000000,20000000.00000000,3600000.00000000,23600000.00000000),(219,31,NULL,NULL,NULL,'Travaux de ma&ccedil;onnerie pour fixation des barri&egrave;res',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,35000000.00000000,35000000.00000000,6300000.00000000,0.00000000,0.00000000,41300000.00000000,0,NULL,NULL,0,20000000.00000000,NULL,0,9,NULL,1,'GNF',35000000.00000000,35000000.00000000,6300000.00000000,41300000.00000000),(220,31,NULL,NULL,NULL,'Nettoyage du chantier',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,5000000.00000000,5000000.00000000,900000.00000000,0.00000000,0.00000000,5900000.00000000,1,NULL,NULL,0,2500000.00000000,NULL,0,13,NULL,1,'GNF',5000000.00000000,5000000.00000000,900000.00000000,5900000.00000000),(222,31,NULL,NULL,NULL,'Reprise des fissures + fourniture et application d&#39;une peinture speciale exterieures en deux couches (m2)',NULL,'TVA',18.000,0.000,'1',0.000,'0',875,0,0,42900,42900.00000000,37537500.00000000,6756750.00000000,0.00000000,0.00000000,44294250.00000000,0,NULL,NULL,0,0.00000000,NULL,0,10,NULL,1,'GNF',42900.00000000,37537500.00000000,6756750.00000000,44294250.00000000),(223,31,NULL,NULL,NULL,'Location d&#39;un echaffaudage pour intervention',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,5000000,5000000.00000000,5000000.00000000,900000.00000000,0.00000000,0.00000000,5900000.00000000,1,NULL,NULL,0,0.00000000,NULL,0,1,NULL,1,'GNF',5000000.00000000,5000000.00000000,900000.00000000,5900000.00000000),(224,33,NULL,NULL,NULL,'<strong>* Vente de mobilier de bureau</strong>, (voir liste ci-jointe).',NULL,'HT',0.000,0.000,'0',0.000,'0',1,3,19682306.31,636394570.69,656076877.00000000,636394570.69000000,0.00000000,0.00000000,0.00000000,636394570.69000000,0,NULL,NULL,0,459900000.00000000,NULL,0,1,NULL,1,'GNF',656076877.00000000,636394570.69000000,0.00000000,636394570.69000000),(225,33,NULL,NULL,NULL,'<strong>* Frais de transport de l&#39;usine au Port de Conakry.</strong>',NULL,'HT',0.000,0.000,'0',0.000,'0',1,0,0,38420200,38420200.00000000,38420200.00000000,0.00000000,0.00000000,0.00000000,38420200.00000000,1,NULL,NULL,0,0.00000000,NULL,0,2,NULL,1,'GNF',38420200.00000000,38420200.00000000,0.00000000,38420200.00000000),(226,33,NULL,NULL,NULL,'<strong>* Livraison du Port au Site de Webb Fontaine.<br />\r\n* D&eacute;chargement du container.<br />\r\n* Montage et installation du mobilier.</strong><br />\r\n<u><em>Le d&eacute;douanement est &agrave; la charge du client.</em></u>',NULL,'HT',0.000,0.000,'0',0.000,'0',1,0,0,21110000,21110000.00000000,21110000.00000000,0.00000000,0.00000000,0.00000000,21110000.00000000,1,NULL,NULL,0,0.00000000,NULL,0,3,NULL,1,'GNF',21110000.00000000,21110000.00000000,0.00000000,21110000.00000000),(227,34,NULL,NULL,NULL,'Fourniture de pied d&#39;Alpinia (unit&eacute;).',NULL,'TVA',18.000,0.000,'1',0.000,'0',15,0,0,20000,20000.00000000,300000.00000000,54000.00000000,0.00000000,0.00000000,354000.00000000,0,NULL,NULL,0,15000.00000000,NULL,0,1,NULL,1,'GNF',20000.00000000,300000.00000000,54000.00000000,354000.00000000),(228,34,NULL,NULL,NULL,'Fourniture de pied d&#39;Ibiscus (unit&eacute;).',NULL,'TVA',18.000,0.000,'1',0.000,'0',15,0,0,20000,20000.00000000,300000.00000000,54000.00000000,0.00000000,0.00000000,354000.00000000,0,NULL,NULL,0,15000.00000000,NULL,0,2,NULL,1,'GNF',20000.00000000,300000.00000000,54000.00000000,354000.00000000),(229,34,NULL,NULL,NULL,'Fourniture de pied deBouganvier Multi-couleurs (unit&eacute;).',NULL,'TVA',18.000,0.000,'1',0.000,'0',100,0,0,NULL,9000.00000000,900000.00000000,162000.00000000,0.00000000,0.00000000,1062000.00000000,0,NULL,NULL,0,7500.00000000,NULL,0,3,NULL,1,'GNF',9000.00000000,900000.00000000,162000.00000000,1062000.00000000),(230,34,NULL,NULL,NULL,'Fourniture de pied pour haie isolante mixte (unit&eacute;).',NULL,'TVA',18.000,0.000,'1',0.000,'0',60,0,0,8000,8000.00000000,480000.00000000,86400.00000000,0.00000000,0.00000000,566400.00000000,0,NULL,NULL,0,5000.00000000,NULL,0,4,NULL,1,'GNF',8000.00000000,480000.00000000,86400.00000000,566400.00000000),(231,34,NULL,NULL,NULL,'Fourniture de pied de Troton du Bresil (unit&eacute;)',NULL,'TVA',18.000,0.000,'1',0.000,'0',15,0,0,28000,28000.00000000,420000.00000000,75600.00000000,0.00000000,0.00000000,495600.00000000,0,NULL,NULL,0,20000.00000000,NULL,0,5,NULL,1,'GNF',28000.00000000,420000.00000000,75600.00000000,495600.00000000),(232,34,NULL,NULL,NULL,'Fourniture de Gason au sac (unit&eacute;).',NULL,'TVA',18.000,0.000,'1',0.000,'0',35,0,0,88000,88000.00000000,3080000.00000000,554400.00000000,0.00000000,0.00000000,3634400.00000000,0,NULL,NULL,0,80000.00000000,NULL,0,6,NULL,1,'GNF',88000.00000000,3080000.00000000,554400.00000000,3634400.00000000),(233,34,NULL,NULL,NULL,'Fourniture de terre v&eacute;g&eacute;tale noire (m3).',NULL,'TVA',18.000,0.000,'1',0.000,'0',8,0,0,235000,235000.00000000,1880000.00000000,338400.00000000,0.00000000,0.00000000,2218400.00000000,0,NULL,NULL,0,187500.00000000,NULL,0,7,NULL,1,'GNF',235000.00000000,1880000.00000000,338400.00000000,2218400.00000000),(234,34,NULL,NULL,NULL,'Livraison - Main d&#39;oeuvre - Am&eacute;nagement - Nettoyage du chantier',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,2400000.00000000,2400000.00000000,432000.00000000,0.00000000,0.00000000,2832000.00000000,1,NULL,NULL,0,2000000.00000000,NULL,0,8,NULL,1,'GNF',2400000.00000000,2400000.00000000,432000.00000000,2832000.00000000),(235,34,NULL,NULL,NULL,'Fourniture et livraison de granit (m3).<br />\r\n<em>&quot;Le tarif de livraison peut vari&eacute; en fonction de la quantit&eacute; au ratio du camion&quot;</em>',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,420000.00000000,420000.00000000,75600.00000000,0.00000000,0.00000000,495600.00000000,0,NULL,NULL,0,300000.00000000,NULL,0,9,NULL,1,'GNF',420000.00000000,420000.00000000,75600.00000000,495600.00000000),(237,35,NULL,NULL,NULL,'<u><strong>CONTROLE D&#39;ACCES (unit&eacute;) :</strong></u><br />\r\n* Installation des syst&egrave;mes de contr&ocirc;le d&#39;acc&egrave;s, param&egrave;trage et formation.',NULL,'TVA',18.000,0.000,'1',0.000,'0',12,20,379999.8,1519999.2,1899999.00000000,18239990.40000000,3283198.27000000,0.00000000,0.00000000,21523188.67000000,0,NULL,NULL,0,1150000.00000000,NULL,0,1,NULL,1,'GNF',1899999.00000000,18239990.40000000,3283198.27000000,21523188.67000000),(238,35,NULL,NULL,NULL,'<u><strong>ACCESOIRE POUR LE CONTR&Ocirc;LE D&#39;ACCES (ensemble) :</strong></u><br />\r\n* C&acirc;ble &eacute;lectrique NEXANS 3*2.5mm2.<br />\r\n* C&acirc;ble FTP cat&eacute;gorie 6 blind&eacute;.<br />\r\n* Gaine flexible diam&egrave;tre 25mm.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,5,221400,4206600,4428000.00000000,4206600.00000000,757188.00000000,0.00000000,0.00000000,4963788.00000000,0,NULL,NULL,0,4630000.00000000,NULL,0,2,NULL,1,'GNF',4428000.00000000,4206600.00000000,757188.00000000,4963788.00000000),(239,36,NULL,NULL,NULL,'<u><strong>FAUX-PLAFOND (420m2) :</strong></u><br />\r\n* R&eacute;alisation de la d&eacute;pose du faux-plafond existant pour intervention des travaux.<br />\r\n* Repose du faux-plafond avec toutes les modifications engeandr&eacute;es par les travaux d&#39;am&eacute;nagement r&eacute;alis&eacute;s.&nbsp;',NULL,'TVA',18.000,0.000,'1',0.000,'0',420,25,25000,75000,100000.00000000,31500000.00000000,5670000.00000000,0.00000000,0.00000000,37170000.00000000,1,NULL,NULL,0,70000.00000000,NULL,0,1,NULL,1,'GNF',100000.00000000,31500000.00000000,5670000.00000000,37170000.00000000),(240,37,NULL,NULL,NULL,'<u><strong>MENUISERIE (unit&eacute;) :</strong></u><br />\r\n* D&eacute;pose des portes d&#39;entr&eacute;es en bois existantes.<br />\r\n* Reprise des ma&ccedil;onneries de finitions et mise d&#39;aplomb pour pose des nouvelles portes.',NULL,'TVA',18.000,0.000,'1',0.000,'0',2,40,280000,420000,700000.00000000,840000.00000000,151200.00000000,0.00000000,0.00000000,991200.00000000,1,NULL,NULL,0,0.00000000,NULL,0,1,NULL,1,'GNF',700000.00000000,840000.00000000,151200.00000000,991200.00000000),(241,37,NULL,NULL,NULL,'<u><strong>MENUISERIE (unit&eacute;) :</strong></u><br />\r\n* Fourniture et pose de porte en verre s&eacute;curite 10mm, dimensions 210/90.<br />\r\n* Syst&egrave;me d&#39;ouverture interieure/exterieure avec verrous haut et bas.<br />\r\n* Poignet fournis.',NULL,'TVA',18.000,0.000,'1',0.000,'0',3,10,1900000,17100000,19000000.00000000,51300000.00000000,9234000.00000000,0.00000000,0.00000000,60534000.00000000,0,NULL,NULL,0,7500000.00000000,NULL,0,2,NULL,1,'GNF',19000000.00000000,51300000.00000000,9234000.00000000,60534000.00000000),(242,27,NULL,NULL,NULL,'<u><strong>MENUISERIE :</strong></u><br />\r\n* Fourniture et pose d&#39;une porte s&eacute;curit&eacute; couleur bois.<br />\r\n* Travaux d&#39;am&eacute;nagement et de finition pour pose de la porte.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,22000000,22000000.00000000,22000000.00000000,3960000.00000000,0.00000000,0.00000000,25960000.00000000,0,NULL,NULL,0,0.00000000,NULL,0,7,NULL,1,'GNF',22000000.00000000,22000000.00000000,3960000.00000000,25960000.00000000),(247,38,NULL,NULL,NULL,'<u><strong>INSTALLATION D&#39;UNE CLIMATISATION DE BACK-UP</strong></u><br />\r\nAfin que l&#39;installation soit op&eacute;rationnelle, les travaux se feront en deux phases.<br />\r\n<strong>* PHASE 1 :</strong> Installation de la climatisation de back-up<br />\r\n<strong>* PHASE 2 :</strong> Installation du syst&egrave;me final &agrave; r&eacute;ception des &eacute;quipements<br />\r\n<br />\r\nSplit Mural 24000BTU<br />\r\nT&eacute;l&eacute;commande infra rouge.<br />\r\nTous les accessoires et les frais d&#39;installations.',NULL,'TVA',18.000,0.000,'1',0.000,'0',2,0,0,NULL,19800000.00000000,39600000.00000000,7128000.00000000,0.00000000,0.00000000,46728000.00000000,1,NULL,NULL,0,11974100.00000000,NULL,0,1,NULL,1,'GNF',19800000.00000000,39600000.00000000,7128000.00000000,46728000.00000000),(249,39,NULL,NULL,NULL,'<u><strong>PLAFOND (m2) :</strong></u><br />\r\n* Fourniture et pose d&#39;un plafond en placopl&acirc;tre BA13.<br />\r\n* Installation des points de fixations et des fourrures.<br />\r\n* Poses des plaques et r&eacute;alisation des enduits.<br />\r\n* Pon&ccedil;age des enduits afin d&#39;optenir une surface pr&ecirc;te &agrave; peindre.',NULL,'TVA',18.000,0.000,'1',0.000,'0',500,0,0,329000,329000.00000000,164500000.00000000,29610000.00000000,0.00000000,0.00000000,194110000.00000000,0,NULL,NULL,0,120000.00000000,NULL,0,1,NULL,1,'GNF',329000.00000000,164500000.00000000,29610000.00000000,194110000.00000000),(250,39,NULL,NULL,NULL,'<u><strong>PLAFOND (m2) :</strong></u><br />\r\n* Fourniture et pose d&#39;un plafond en placopl&acirc;tre BA13 sur stucture d&eacute;j&agrave; &eacute;xistante.<br />\r\n* Pose des plaques et r&eacute;alisations des enduits.<br />\r\n* Pon&ccedil;age des enduits afin d&#39;optenir une surface pr&ecirc;te &agrave; peindre.',NULL,'TVA',18.000,0.000,'1',0.000,'0',100,0,0,279000,279000.00000000,27900000.00000000,5022000.00000000,0.00000000,0.00000000,32922000.00000000,0,NULL,NULL,0,90000.00000000,NULL,0,2,NULL,1,'GNF',279000.00000000,27900000.00000000,5022000.00000000,32922000.00000000),(251,40,NULL,NULL,NULL,'<strong><u>CLIMATISATION :</u></strong><br />\r\n* Fourniture et installation d&#39;une climatisation en colonne 50 000 BTU.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,24000000.00000000,24000000.00000000,4320000.00000000,0.00000000,0.00000000,28320000.00000000,0,NULL,NULL,0,16000000.00000000,NULL,0,2,NULL,1,'GNF',24000000.00000000,24000000.00000000,4320000.00000000,28320000.00000000),(252,40,NULL,NULL,NULL,'<u><strong>PLAFOND (m2) :</strong></u><br />\r\n* Fouriture et pose d&#39;un plafond en BA13 Hydrofug&eacute;.<br />\r\n* Installation d&#39;une structure primaire m&eacute;tallique.<br />\r\n* Fixation des plaques de placopl&acirc;tre BA13.<br />\r\n* R&eacute;alisation des enduits et pon&ccedil;age de ceux-ci pour optenir une surface pr&ecirc;te &agrave; peindre.',NULL,'TVA',18.000,0.000,'1',0.000,'0',50,0,0,245000,245000.00000000,12250000.00000000,2205000.00000000,0.00000000,0.00000000,14455000.00000000,0,NULL,NULL,0,120000.00000000,NULL,0,3,NULL,1,'GNF',245000.00000000,12250000.00000000,2205000.00000000,14455000.00000000),(253,40,NULL,NULL,NULL,'<u><strong>CLOISONNEMENT (m2) :</strong></u><br />\r\n* Fourniture et pose d&#39;une contrecloison en BA13 Hydrofug&eacute;.<br />\r\n* Installation d&#39;une structure primaire m&eacute;tallique.<br />\r\n* Fixation des plaques de placopl&acirc;tre BA13.<br />\r\n* R&eacute;alisation des enduits et pon&ccedil;age de ceux-ci pour optenir une surface pr&ecirc;te &agrave; peindre.<br />\r\n* Reprise des parties &eacute;lectriques pour adaptation &agrave; la contre-cloison.',NULL,'TVA',18.000,0.000,'1',0.000,'0',100,0,0,289000,289000.00000000,28900000.00000000,5202000.00000000,0.00000000,0.00000000,34102000.00000000,0,NULL,NULL,0,142000.00000000,NULL,0,4,NULL,1,'GNF',289000.00000000,28900000.00000000,5202000.00000000,34102000.00000000),(254,40,NULL,NULL,NULL,'<u><strong>ISOLATION (m2) :</strong></u><br />\r\n* Fourniture et pose d&#39;un isolant thermique dans les murs et plafond.<br />\r\n&nbsp;',NULL,'TVA',18.000,0.000,'1',0.000,'0',150,0,0,NULL,109000.00000000,16350000.00000000,2943000.00000000,0.00000000,0.00000000,19293000.00000000,0,NULL,NULL,0,75000.00000000,NULL,0,5,NULL,1,'GNF',109000.00000000,16350000.00000000,2943000.00000000,19293000.00000000),(255,40,NULL,NULL,NULL,'<u><strong>MANUTENTION :</strong></u><br />\r\nLivraison et manutention des mat&eacute;riaux sur site.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,8000000.00000000,8000000.00000000,1440000.00000000,0.00000000,0.00000000,9440000.00000000,1,NULL,NULL,0,4000000.00000000,NULL,0,1,NULL,1,'GNF',8000000.00000000,8000000.00000000,1440000.00000000,9440000.00000000),(256,40,NULL,NULL,NULL,'<u><strong>NETTOYAGE :</strong></u><br />\r\nNettoyage du chantier et &eacute;vacuation des gravats.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,3000000.00000000,3000000.00000000,540000.00000000,0.00000000,0.00000000,3540000.00000000,1,NULL,NULL,0,1500000.00000000,NULL,0,6,NULL,1,'GNF',3000000.00000000,3000000.00000000,540000.00000000,3540000.00000000),(257,41,NULL,NULL,NULL,'<u><strong>REVETEMENT SOL (m2) :</strong></u><br />\r\n* Fourniture et pose d&#39;un parquet stratifi&eacute; flottant dans la salle de r&eacute;union du 3&egrave;me &eacute;tage.<br />\r\n* Fourniture et pose d&#39;un polyane mattelass&eacute; sous le parquet, am&eacute;liorant les performence accoustique et hydrom&eacute;trique.&nbsp;',NULL,'TVA',18.000,0.000,'1',0.000,'0',60,0,0,NULL,357000.00000000,21420000.00000000,3855600.00000000,0.00000000,0.00000000,25275600.00000000,0,NULL,NULL,0,255000.00000000,NULL,0,1,NULL,1,'GNF',357000.00000000,21420000.00000000,3855600.00000000,25275600.00000000),(258,41,NULL,NULL,NULL,'<u><strong>FINITION (ml) :</strong></u><br />\r\n* Fourniture et pose d&#39;un quart de rond en bois, entre le parquet et la plinthe existante.',NULL,'TVA',18.000,0.000,'1',0.000,'0',32,0,0,120000,120000.00000000,3840000.00000000,691200.00000000,0.00000000,0.00000000,4531200.00000000,0,NULL,NULL,0,80000.00000000,NULL,0,2,NULL,1,'GNF',120000.00000000,3840000.00000000,691200.00000000,4531200.00000000),(259,42,NULL,NULL,NULL,'<u><strong>PLAFOND (m2) :</strong></u><br />\r\n* Fourniture et application d&#39;une peinture en deux couches sur tous les plafonds.<br />\r\n* Protection des &eacute;quipements actuels.',NULL,'TVA',18.000,0.000,'1',0.000,'0',360,0,0,NULL,33000.00000000,11880000.00000000,2138400.00000000,0.00000000,0.00000000,14018400.00000000,0,NULL,NULL,0,17000.00000000,NULL,0,1,NULL,1,'GNF',33000.00000000,11880000.00000000,2138400.00000000,14018400.00000000),(260,42,NULL,NULL,NULL,'<u><strong>MURS (m2) :</strong></u><br />\r\n* Reprise des enduits et fissures + pon&ccedil;age afin d&#39;optenir une finition propre.<br />\r\n* Fourniture et application d&#39;une peinture blanche en deux couches.<br />\r\n* Protection des &eacute;quipements actuels.',NULL,'TVA',18.000,0.000,'1',0.000,'0',760,0,0,NULL,39000.00000000,29640000.00000000,5335200.00000000,0.00000000,0.00000000,34975200.00000000,0,NULL,NULL,0,23000.00000000,NULL,0,2,NULL,1,'GNF',39000.00000000,29640000.00000000,5335200.00000000,34975200.00000000),(261,42,NULL,NULL,NULL,'<u><strong>NETTOYAGE (forfait) :</strong></u><br />\r\n* Nettoyage du chantier.',NULL,'TVA',18.000,0.000,'1',0.000,'0',1,0,0,NULL,2500000.00000000,2500000.00000000,450000.00000000,0.00000000,0.00000000,2950000.00000000,1,NULL,NULL,0,2000000.00000000,NULL,0,3,NULL,1,'GNF',2500000.00000000,2500000.00000000,450000.00000000,2950000.00000000),(262,13,NULL,NULL,NULL,'<u><strong>FINITION (ml) :</strong></u><br />\r\n* Fourniture et pose de baguette de finition en PVC sur les parties hautes des cloisons.',NULL,'TVA',18.000,0.000,'1',0.000,'0',48,0,0,NULL,70000.00000000,3360000.00000000,604800.00000000,0.00000000,0.00000000,3964800.00000000,0,NULL,NULL,0,50000.00000000,NULL,0,2,NULL,1,'GNF',70000.00000000,3360000.00000000,604800.00000000,3964800.00000000);

--
-- Table structure for table `llx_propaldet_extrafields`
--

CREATE TABLE `llx_propaldet_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_propaldet_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_propaldet_extrafields`
--


--
-- Table structure for table `llx_resource`
--

CREATE TABLE `llx_resource` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `ref` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `asset_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `fk_code_type_resource` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `date_valid` datetime DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `fk_statut` smallint(6) NOT NULL DEFAULT '0',
  `note_public` text COLLATE utf8_unicode_ci,
  `note_private` text COLLATE utf8_unicode_ci,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `extraparams` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_country` int(11) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_resource_ref` (`ref`,`entity`),
  KEY `fk_code_type_resource_idx` (`fk_code_type_resource`),
  KEY `idx_resource_fk_country` (`fk_country`),
  CONSTRAINT `fk_resource_fk_country` FOREIGN KEY (`fk_country`) REFERENCES `llx_c_country` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_resource`
--


--
-- Table structure for table `llx_resource_extrafields`
--

CREATE TABLE `llx_resource_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_resource_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_resource_extrafields`
--


--
-- Table structure for table `llx_rights_def`
--

CREATE TABLE `llx_rights_def` (
  `id` int(11) NOT NULL,
  `libelle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `module` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `perms` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `subperms` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bydefault` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`id`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_rights_def`
--

INSERT INTO `llx_rights_def` (`id`, `libelle`, `module`, `entity`, `perms`, `subperms`, `type`, `bydefault`) VALUES (11,'Read invoices','facture',1,'lire',NULL,'a',0),(12,'Create and update invoices','facture',1,'creer',NULL,'a',0),(13,'Devalidate invoices','facture',1,'invoice_advance','unvalidate','a',0),(14,'Validate invoices','facture',1,'invoice_advance','validate','a',0),(15,'Send invoices by email','facture',1,'invoice_advance','send','a',0),(16,'Issue payments on invoices','facture',1,'paiement',NULL,'a',0),(19,'Delete invoices','facture',1,'supprimer',NULL,'a',0),(21,'Read commercial proposals','propale',1,'lire',NULL,'r',0),(22,'Create and update commercial proposals','propale',1,'creer',NULL,'w',0),(24,'Validate commercial proposals','propale',1,'propal_advance','validate','d',0),(25,'Send commercial proposals to customers','propale',1,'propal_advance','send','d',0),(26,'Close commercial proposals','propale',1,'cloturer',NULL,'d',0),(27,'Delete commercial proposals','propale',1,'supprimer',NULL,'d',0),(28,'Exporting commercial proposals and attributes','propale',1,'export',NULL,'r',0),(31,'Read products','produit',1,'lire',NULL,'r',0),(32,'Create/modify products','produit',1,'creer',NULL,'w',0),(34,'Delete products','produit',1,'supprimer',NULL,'d',0),(38,'Export products','produit',1,'export',NULL,'r',0),(41,'Read projects and tasks (shared projects or projects I am contact for). Can also enter time consumed on assigned tasks (timesheet)','projet',1,'lire',NULL,'r',0),(42,'Create/modify projects and tasks (shared projects or projects I am contact for)','projet',1,'creer',NULL,'w',0),(44,'Delete project and tasks (shared projects or projects I am contact for)','projet',1,'supprimer',NULL,'d',0),(45,'Export projects','projet',1,'export',NULL,'d',0),(91,'Lire les charges','tax',1,'charges','lire','r',0),(92,'Creer/modifier les charges','tax',1,'charges','creer','w',0),(93,'Supprimer les charges','tax',1,'charges','supprimer','d',0),(94,'Exporter les charges','tax',1,'charges','export','r',0),(95,'Lire CA, bilans, resultats','compta',1,'resultat','lire','r',0),(111,'Lire les comptes bancaires','banque',1,'lire',NULL,'r',0),(112,'Creer/modifier montant/supprimer ecriture bancaire','banque',1,'modifier',NULL,'w',0),(113,'Configurer les comptes bancaires (creer, gerer categories)','banque',1,'configurer',NULL,'a',0),(114,'Rapprocher les ecritures bancaires','banque',1,'consolidate',NULL,'w',0),(115,'Exporter transactions et releves','banque',1,'export',NULL,'r',0),(116,'Virements entre comptes','banque',1,'transfer',NULL,'w',0),(117,'Gerer les envois de cheques','banque',1,'cheque',NULL,'w',0),(121,'Read third parties','societe',1,'lire',NULL,'r',0),(122,'Create and update third parties','societe',1,'creer',NULL,'w',0),(125,'Delete third parties','societe',1,'supprimer',NULL,'d',0),(126,'Export third parties','societe',1,'export',NULL,'r',0),(141,'Read all projects and tasks (also private projects I am not contact for)','projet',1,'all','lire','r',0),(142,'Create/modify all projects and tasks (also private projects I am not contact for). Can also enter time consumed on assigned tasks (timesheet)','projet',1,'all','creer','w',0),(144,'Delete all projects and tasks (also private projects I am not contact for)','projet',1,'all','supprimer','d',0),(241,'Lire les categories','categorie',1,'lire',NULL,'r',0),(242,'Creer/modifier les categories','categorie',1,'creer',NULL,'w',0),(243,'Supprimer les categories','categorie',1,'supprimer',NULL,'d',0),(251,'Consulter les autres utilisateurs','user',1,'user','lire','r',0),(252,'Consulter les permissions des autres utilisateurs','user',1,'user_advance','readperms','r',0),(253,'Creer/modifier utilisateurs internes et externes','user',1,'user','creer','w',0),(254,'Creer/modifier utilisateurs externes seulement','user',1,'user_advance','write','w',0),(255,'Modifier le mot de passe des autres utilisateurs','user',1,'user','password','w',0),(256,'Supprimer ou desactiver les autres utilisateurs','user',1,'user','supprimer','d',0),(262,'Read all third parties by internal users (otherwise only if commercial contact). Not effective for external users (limited to themselves).','societe',1,'client','voir','r',0),(281,'Read contacts','societe',1,'contact','lire','r',0),(282,'Create and update contact','societe',1,'contact','creer','w',0),(283,'Delete contacts','societe',1,'contact','supprimer','d',0),(286,'Export contacts','societe',1,'contact','export','d',0),(341,'Consulter ses propres permissions','user',1,'self_advance','readperms','r',0),(342,'Creer/modifier ses propres infos utilisateur','user',1,'self','creer','w',0),(343,'Modifier son propre mot de passe','user',1,'self','password','w',0),(344,'Modifier ses propres permissions','user',1,'self_advance','writeperms','w',0),(351,'Consulter les groupes','user',1,'group_advance','read','r',0),(352,'Consulter les permissions des groupes','user',1,'group_advance','readperms','r',0),(353,'Creer/modifier les groupes et leurs permissions','user',1,'group_advance','write','w',0),(354,'Supprimer ou desactiver les groupes','user',1,'group_advance','delete','d',0),(358,'Exporter les utilisateurs','user',1,'user','export','r',0),(511,'Read payments of employee salaries','salaries',1,'read',NULL,'r',0),(512,'Create/modify payments of empoyee salaries','salaries',1,'write',NULL,'w',0),(514,'Delete payments of employee salary','salaries',1,'delete',NULL,'d',0),(517,'Export payments of employee salaries','salaries',1,'export',NULL,'r',0),(531,'Read services','service',1,'lire',NULL,'r',0),(532,'Create/modify services','service',1,'creer',NULL,'w',0),(534,'Delete les services','service',1,'supprimer',NULL,'d',0),(538,'Export services','service',1,'export',NULL,'r',0),(1001,'Lire les stocks','stock',1,'lire',NULL,'r',0),(1002,'Creer/Modifier les stocks','stock',1,'creer',NULL,'w',0),(1003,'Supprimer les stocks','stock',1,'supprimer',NULL,'d',0),(1004,'Lire mouvements de stocks','stock',1,'mouvement','lire','r',0),(1005,'Creer/modifier mouvements de stocks','stock',1,'mouvement','creer','w',0),(1121,'Read supplier proposals','supplier_proposal',1,'lire',NULL,'w',0),(1122,'Create/modify supplier proposals','supplier_proposal',1,'creer',NULL,'w',0),(1123,'Validate supplier proposals','supplier_proposal',1,'validate_advance',NULL,'w',0),(1124,'Envoyer les demandes fournisseurs','supplier_proposal',1,'send_advance',NULL,'w',0),(1125,'Delete supplier proposals','supplier_proposal',1,'supprimer',NULL,'w',0),(1126,'Close supplier price requests','supplier_proposal',1,'cloturer',NULL,'w',0),(1181,'Consulter les fournisseurs','fournisseur',1,'lire',NULL,'r',0),(1182,'Consulter les commandes fournisseur','fournisseur',1,'commande','lire','r',0),(1183,'Creer une commande fournisseur','fournisseur',1,'commande','creer','w',0),(1184,'Valider une commande fournisseur','fournisseur',1,'supplier_order_advance','validate','w',0),(1185,'Approuver une commande fournisseur','fournisseur',1,'commande','approuver','w',0),(1186,'Commander une commande fournisseur','fournisseur',1,'commande','commander','w',0),(1187,'Receptionner une commande fournisseur','fournisseur',1,'commande','receptionner','d',0),(1188,'Supprimer une commande fournisseur','fournisseur',1,'commande','supprimer','d',0),(1189,'Check/Uncheck a supplier order reception','fournisseur',1,'commande_advance','check','w',0),(1191,'Exporter les commande fournisseurs, attributs','fournisseur',1,'commande','export','r',0),(1201,'Lire les exports','export',1,'lire',NULL,'r',0),(1202,'Creer/modifier un export','export',1,'creer',NULL,'w',0),(1231,'Consulter les factures fournisseur','fournisseur',1,'facture','lire','r',0),(1232,'Creer une facture fournisseur','fournisseur',1,'facture','creer','w',0),(1233,'Valider une facture fournisseur','fournisseur',1,'supplier_invoice_advance','validate','w',0),(1234,'Supprimer une facture fournisseur','fournisseur',1,'facture','supprimer','d',0),(1235,'Envoyer les factures par mail','fournisseur',1,'supplier_invoice_advance','send','a',0),(1236,'Exporter les factures fournisseurs, attributs et reglements','fournisseur',1,'facture','export','r',0),(1251,'Run mass imports of external data (data load)','import',1,'run',NULL,'r',0),(1321,'Export customer invoices, attributes and payments','facture',1,'facture','export','r',0),(1322,'Re-open a fully paid invoice','facture',1,'invoice_advance','reopen','r',0),(2401,'Read actions/tasks linked to his account','agenda',1,'myactions','read','r',0),(2402,'Create/modify actions/tasks linked to his account','agenda',1,'myactions','create','w',0),(2403,'Delete actions/tasks linked to his account','agenda',1,'myactions','delete','w',0),(2411,'Read actions/tasks of others','agenda',1,'allactions','read','r',0),(2412,'Create/modify actions/tasks of others','agenda',1,'allactions','create','w',0),(2413,'Delete actions/tasks of others','agenda',1,'allactions','delete','w',0),(2414,'Export actions/tasks of others','agenda',1,'export',NULL,'w',0),(2501,'Consulter/Télécharger les documents','ecm',1,'read',NULL,'r',0),(2503,'Soumettre ou supprimer des documents','ecm',1,'upload',NULL,'w',0),(2515,'Administrer les rubriques de documents','ecm',1,'setup',NULL,'w',0),(20001,'Read your own leave requests','holiday',1,'read',NULL,'w',0),(20002,'Create/modify your own leave requests','holiday',1,'write',NULL,'w',0),(20003,'Delete leave requests','holiday',1,'delete',NULL,'w',0),(20004,'Read leave requests for everybody','holiday',1,'read_all',NULL,'w',0),(20005,'Create/modify leave requests for everybody','holiday',1,'write_all',NULL,'w',0),(20006,'Setup leave requests of users (setup and update balance)','holiday',1,'define_holiday',NULL,'w',0),(20007,'Approve leave requests','holiday',1,'approve',NULL,'w',0),(23001,'Read cron jobs','cron',1,'read',NULL,'w',0),(23002,'Create cron Jobs','cron',1,'create',NULL,'w',0),(23003,'Delete cron Jobs','cron',1,'delete',NULL,'w',0),(23004,'Execute cron Jobs','cron',1,'execute',NULL,'w',0),(59001,'Visualiser les marges','margins',1,'liretous',NULL,'r',0),(59002,'Définir les marges','margins',1,'creer',NULL,'w',0),(59003,'Read every user margin','margins',1,'read','all','r',0),(63001,'Read resources','resource',1,'read',NULL,'w',0),(63002,'Create/Modify resources','resource',1,'write',NULL,'w',0),(63003,'Delete resources','resource',1,'delete',NULL,'w',0),(63004,'Link resources to agenda events','resource',1,'link',NULL,'w',0);

--
-- Table structure for table `llx_societe`
--

CREATE TABLE `llx_societe` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name_alias` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `ref_ext` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref_int` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `statut` tinyint(4) DEFAULT '0',
  `parent` int(11) DEFAULT NULL,
  `status` tinyint(4) DEFAULT '1',
  `code_client` varchar(24) COLLATE utf8_unicode_ci DEFAULT NULL,
  `code_fournisseur` varchar(24) COLLATE utf8_unicode_ci DEFAULT NULL,
  `code_compta` varchar(24) COLLATE utf8_unicode_ci DEFAULT NULL,
  `code_compta_fournisseur` varchar(24) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  `town` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_departement` int(11) DEFAULT '0',
  `fk_pays` int(11) DEFAULT '0',
  `fk_account` int(11) DEFAULT '0',
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fax` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `skype` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_effectif` int(11) DEFAULT '0',
  `fk_typent` int(11) DEFAULT '0',
  `fk_forme_juridique` int(11) DEFAULT '0',
  `fk_currency` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `siren` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `siret` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ape` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `idprof4` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `idprof5` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `idprof6` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tva_intra` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `capital` double(24,8) DEFAULT NULL,
  `fk_stcomm` int(11) NOT NULL DEFAULT '0',
  `note_private` text COLLATE utf8_unicode_ci,
  `note_public` text COLLATE utf8_unicode_ci,
  `model_pdf` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `prefix_comm` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `client` tinyint(4) DEFAULT '0',
  `fournisseur` tinyint(4) DEFAULT '0',
  `supplier_account` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_prospectlevel` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_incoterms` int(11) DEFAULT NULL,
  `location_incoterms` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `customer_bad` tinyint(4) DEFAULT '0',
  `customer_rate` double DEFAULT '0',
  `supplier_rate` double DEFAULT '0',
  `remise_client` double DEFAULT '0',
  `remise_supplier` double DEFAULT '0',
  `mode_reglement` tinyint(4) DEFAULT NULL,
  `cond_reglement` tinyint(4) DEFAULT NULL,
  `mode_reglement_supplier` tinyint(4) DEFAULT NULL,
  `cond_reglement_supplier` tinyint(4) DEFAULT NULL,
  `fk_shipping_method` int(11) DEFAULT NULL,
  `tva_assuj` tinyint(4) DEFAULT '1',
  `localtax1_assuj` tinyint(4) DEFAULT '0',
  `localtax1_value` double(6,3) DEFAULT NULL,
  `localtax2_assuj` tinyint(4) DEFAULT '0',
  `localtax2_value` double(6,3) DEFAULT NULL,
  `barcode` varchar(180) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_barcode_type` int(11) DEFAULT '0',
  `price_level` int(11) DEFAULT NULL,
  `outstanding_limit` double(24,8) DEFAULT NULL,
  `order_min_amount` double(24,8) DEFAULT NULL,
  `supplier_order_min_amount` double(24,8) DEFAULT NULL,
  `default_lang` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
  `logo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `canvas` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_entrepot` int(11) DEFAULT '0',
  `webservices_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `webservices_key` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_societe_prefix_comm` (`prefix_comm`,`entity`),
  UNIQUE KEY `uk_societe_code_client` (`code_client`,`entity`),
  UNIQUE KEY `uk_societe_code_fournisseur` (`code_fournisseur`,`entity`),
  UNIQUE KEY `uk_societe_barcode` (`barcode`,`fk_barcode_type`,`entity`),
  KEY `idx_societe_user_creat` (`fk_user_creat`),
  KEY `idx_societe_user_modif` (`fk_user_modif`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_societe`
--

INSERT INTO `llx_societe` (`rowid`, `nom`, `name_alias`, `entity`, `ref_ext`, `ref_int`, `statut`, `parent`, `status`, `code_client`, `code_fournisseur`, `code_compta`, `code_compta_fournisseur`, `address`, `zip`, `town`, `fk_departement`, `fk_pays`, `fk_account`, `phone`, `fax`, `url`, `email`, `skype`, `fk_effectif`, `fk_typent`, `fk_forme_juridique`, `fk_currency`, `siren`, `siret`, `ape`, `idprof4`, `idprof5`, `idprof6`, `tva_intra`, `capital`, `fk_stcomm`, `note_private`, `note_public`, `model_pdf`, `prefix_comm`, `client`, `fournisseur`, `supplier_account`, `fk_prospectlevel`, `fk_incoterms`, `location_incoterms`, `customer_bad`, `customer_rate`, `supplier_rate`, `remise_client`, `remise_supplier`, `mode_reglement`, `cond_reglement`, `mode_reglement_supplier`, `cond_reglement_supplier`, `fk_shipping_method`, `tva_assuj`, `localtax1_assuj`, `localtax1_value`, `localtax2_assuj`, `localtax2_value`, `barcode`, `fk_barcode_type`, `price_level`, `outstanding_limit`, `order_min_amount`, `supplier_order_min_amount`, `default_lang`, `logo`, `canvas`, `fk_entrepot`, `webservices_url`, `webservices_key`, `tms`, `datec`, `fk_user_creat`, `fk_user_modif`, `fk_multicurrency`, `multicurrency_code`, `import_key`) VALUES (1,'GESNY AFRICA','',1,NULL,NULL,0,NULL,1,NULL,'SU1901-0001',NULL,NULL,'Almamya - Commune de Kaloum BP-896',NULL,'CONAKRY',0,108,0,'00224627885143',NULL,NULL,'contact@gesnyafrica.com',NULL,NULL,0,NULL,NULL,'RCCM/GC-KAL/075.725B/2017','','NIF : 041922Z','','','','',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-15 17:22:55','2019-01-15 17:22:54',3,3,0,'',NULL),(2,'METAL GUINEE','',1,NULL,NULL,0,NULL,1,NULL,'SU1901-0002',NULL,NULL,'Cité des Médecins, Kipé - BP 3770',NULL,'CONAKRY',0,108,0,'00224628350109',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'RCCM GC-KAL/0296A/2004','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-15 17:28:46','2019-01-15 17:28:46',3,3,0,'',NULL),(3,'EMMANUEL BOU','',1,NULL,NULL,0,NULL,1,NULL,'SU1901-0003',NULL,NULL,'Immeuble FMR BP 6316',NULL,'CONAKRY',0,108,0,'00224622212321',NULL,NULL,'ebou@fmr-guinee.com',NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-15 17:40:43','2019-01-15 17:40:43',3,3,0,'',NULL),(4,'ARPT','',1,NULL,NULL,0,NULL,1,'CU1901-0001',NULL,NULL,NULL,'Quartier Almamya Commune de Kaloum BP 1500',NULL,'CONAKRY',0,108,0,'00224657666631',NULL,'www.arpt.gov.gn',NULL,NULL,NULL,5,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-16 17:27:41','2019-01-16 17:27:40',2,2,0,'',NULL),(5,'HASTINE','',1,NULL,NULL,0,NULL,1,'CU1901-0002','SU1901-0004',NULL,NULL,'Sise à Nongo Rue UNC BP-2256\r\nCommune de Ratoma',NULL,'CONAKRY',0,108,0,'00224622422307',NULL,NULL,'martinhassane@msn.com',NULL,NULL,0,NULL,NULL,'RCCM/GC-KAL058526A/2015','','','','','','',NULL,0,NULL,NULL,NULL,NULL,1,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-05-27 17:23:09','2019-01-16 17:52:47',2,2,1,'GNF',NULL),(6,'GUILAB','',1,NULL,NULL,0,NULL,1,'CU1901-0003',NULL,NULL,NULL,'Centre Emetteur de Kipé\r\nBP 1809',NULL,'CONAKRY',0,108,0,'00224622815383',NULL,'www.guilab.com.gn','cto@guilab.com.gn',NULL,NULL,100,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-18 12:22:02','2019-01-18 12:22:02',2,2,0,'',NULL),(7,'SILENCIO','',1,NULL,NULL,0,NULL,1,'CU1901-0004','SU1901-0005',NULL,NULL,'La Minière',NULL,'CONAKRY',0,108,0,'00224623058853',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-19 16:06:15','2019-01-19 16:06:15',2,2,0,'',NULL),(8,'MTN','',1,NULL,NULL,0,NULL,1,NULL,'SU1901-0006',NULL,NULL,'Quartier Almamya, Commune de Kaloum\r\nB.P. 3237',NULL,'CONAKRY',0,108,0,'00224664222222',NULL,'www.mtn.com.gn','businesssales@mtn.com.gn',NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-21 14:50:26','2019-01-21 14:44:06',2,2,0,'',NULL),(9,'MARCHE','',1,NULL,NULL,0,NULL,1,NULL,'SU1901-0007',NULL,NULL,'Marché Niger\r\nCommune de KALOUM',NULL,'CONAKRY',0,108,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-21 14:53:29','2019-01-21 14:46:29',2,2,0,'',NULL),(10,'TELEPHONIE','',1,NULL,NULL,0,NULL,1,NULL,'SU1901-0008',NULL,NULL,'Recharge Téléphonique de quartier',NULL,'CONAKRY',0,108,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-21 14:54:45','2019-01-21 14:54:45',2,2,0,'',NULL),(11,'SERVICE MÉNAGE','',1,NULL,NULL,0,NULL,1,NULL,'SU1901-0009',NULL,NULL,'',NULL,'CONAKRY',0,108,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-21 14:56:25','2019-01-21 14:56:25',2,2,0,'',NULL),(12,'KIOSQUE','',1,NULL,NULL,0,NULL,1,NULL,'SU1901-0010',NULL,NULL,'Quartier',NULL,'CONAKRY',0,108,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-21 14:58:05','2019-01-21 14:58:05',2,2,0,'',NULL),(13,'BATEQUIP','',1,NULL,NULL,0,NULL,1,NULL,'SU1901-0011',NULL,NULL,'B.P.591 Commune de Matam',NULL,'CONAKRY',0,108,0,'00224621996431',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-21 15:51:08','2019-01-21 15:51:07',2,2,0,'',NULL),(14,'CARBURANT','',1,NULL,NULL,0,NULL,1,NULL,'SU1901-0012',NULL,NULL,'Station',NULL,'CONAKRY',0,108,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-21 16:08:38','2019-01-21 16:08:38',2,2,0,'',NULL),(15,'DAHI','',1,NULL,NULL,0,NULL,1,NULL,'SU1901-0013',NULL,NULL,'B.P.4542 La Minière',NULL,'CONAKRY',0,108,0,'00224631357474',NULL,NULL,'jihad_dahi@hotmail.com',NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-21 16:12:36','2019-01-21 16:12:36',2,2,0,'',NULL),(16,'HEROES COFFEE','',1,NULL,NULL,0,NULL,1,NULL,'SU1901-0014',NULL,NULL,'Commune de Kaloum',NULL,'CONAKRY',0,108,0,'00224623690165',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-21 16:15:29','2019-01-21 16:15:29',2,2,0,'',NULL),(17,'BARRY Alhassane','',1,NULL,NULL,0,NULL,1,NULL,'SU1901-0015',NULL,NULL,'Carrefour Internationale\r\nCommune de Hamdalaye',NULL,'CONAKRY',0,108,0,'00224628999121',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-21 16:36:21','2019-01-21 16:36:21',2,2,0,'',NULL),(18,'CELESTIN','',1,NULL,NULL,0,NULL,1,NULL,'SU1901-0016',NULL,NULL,'Route du Niger\r\nCommune de Kaloum',NULL,'CONAKRY',0,108,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-21 16:42:22','2019-01-21 16:42:22',2,2,0,'',NULL),(19,'HELENE K LA BOUTIQUE','',1,NULL,NULL,0,NULL,1,'CU1901-0005',NULL,NULL,NULL,'Corniche Nord, la jetée\r\nLa Minière',NULL,'CONAKRY',0,108,0,'00224625328585',NULL,NULL,'helenchado@hotmail.com',NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-05-17 14:14:03','2019-01-21 19:15:36',2,2,1,'GNF',NULL),(20,'Rama DIALLO','PRESSING',1,NULL,NULL,0,NULL,1,'CU1901-0006',NULL,NULL,NULL,'Pont de kakembé\r\nCommune de Taouya',NULL,'CONAKRY',0,108,0,'00224628772968',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-02-22 18:26:36','2019-01-22 17:22:41',2,2,0,'',NULL),(21,'Ministère des Travaux Publics','',1,NULL,NULL,0,NULL,1,'CU1901-0007',NULL,NULL,NULL,'Boulevard de Commerce\r\nImmeuble Ministère des Travaux Publics\r\n3ème étage / bureau 301\r\nB.P.581',NULL,'CONAKRY',0,108,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-23 15:47:04','2019-01-23 15:47:03',2,2,0,'',NULL),(22,'SOCK Marcel','',1,NULL,NULL,0,NULL,1,'CU1901-0008',NULL,NULL,NULL,'Immeuble Almamya 5ème étage face à l’ascenseur\r\nCommune de Kaloum',NULL,'CONAKRY',0,108,0,'00224626869594',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-03-01 13:22:44','2019-01-26 16:35:39',2,2,0,'',NULL),(23,'PLADIS','',1,NULL,NULL,0,NULL,1,NULL,'SU1901-0017',NULL,NULL,'Complexe Futuris Logistic, Lot Ennouala, N°2, Dépot A3\r\nBld Moulay Ismail',NULL,'CASABLANCA',0,12,0,'00212522344459',NULL,'www;pladis.ma','contact@pladis.ma',NULL,NULL,0,NULL,NULL,'342795','31391148','18734293','4760808','000281490000011','','',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-29 10:54:02','2019-01-29 10:54:02',2,2,0,'',NULL),(24,'MT-SOLUTIONS','',1,NULL,NULL,0,NULL,1,NULL,'SU1901-0018',NULL,NULL,'Immeuble Airwell, Quartier Almamya\r\nCommune de Kaloum',NULL,'CONAKRY',0,108,0,'00224623646455',NULL,'www.mt-solutions.africa','callcenter@mt-solutions.africa',NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-29 15:40:51','2019-01-29 15:40:51',2,2,0,'',NULL),(25,'RESO','',1,NULL,NULL,0,NULL,1,NULL,'SU1901-0019',NULL,NULL,'6, rue des Tuileries','67460','SOUFFELWEYERSHEIM',74,1,0,'0388478425',NULL,NULL,'jean-francois.lavigne@reso.fr',NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,0,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-01-29 15:44:53','2019-01-29 15:44:53',2,2,0,'',NULL),(26,'E2CI','',1,NULL,NULL,0,NULL,1,'CU1902-0009',NULL,NULL,NULL,'Place de la Bougie, ACI2000',NULL,'BAMAKO',0,147,0,'0022371946784',NULL,NULL,'gseradieu@e2ci-sa.com',NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-04-29 12:58:04','2019-02-18 11:18:02',2,2,0,'',NULL),(27,'BARRY Saïkou','',1,NULL,NULL,0,NULL,1,'CU1902-0010',NULL,NULL,NULL,'',NULL,'CONAKRY',0,108,0,'00224622567065',NULL,NULL,'sakoubarry@gmail.com',NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-02-21 18:26:09','2019-02-21 18:26:09',2,2,0,'',NULL),(28,'Ibrahim CISSSE','',1,NULL,NULL,0,NULL,1,'CU1902-0011',NULL,NULL,NULL,'La Minière',NULL,'CONAKRY',0,108,0,'00224628531919',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-02-25 16:32:57','2019-02-25 16:32:57',2,2,0,'',NULL),(29,'Carine REBOUL','',1,NULL,NULL,0,NULL,1,'CU1902-0012',NULL,NULL,NULL,'La Minière',NULL,'CONAKRY',0,108,0,'00224629849701',NULL,NULL,'carine.reboul@gmail.com',NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-05-15 17:58:20','2019-02-28 16:00:48',2,2,1,'GNF',NULL),(30,'NAITE Moustapha','',1,NULL,NULL,0,NULL,1,'CU1903-0013',NULL,NULL,NULL,'Lambanyi',NULL,'CONAKRY',0,108,0,'00224622970000',NULL,NULL,'mnaite@yahoo.fr',NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-03-06 17:45:42','2019-03-06 17:45:42',2,2,0,'',NULL),(31,'Hôtel MLYS','',1,NULL,NULL,0,NULL,1,'CU1903-0014','SU1903-0020',NULL,NULL,'Quartier Almamya',NULL,'CONAKRY',0,108,0,'00224624299369',NULL,NULL,'contact@hotelmlys.com',NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,1,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-03-25 17:17:23','2019-03-08 16:47:49',2,2,0,'',NULL),(32,'SELEG','',1,NULL,NULL,0,NULL,1,'CU1903-0015','SU1903-0021',NULL,NULL,'Sandervalia 4ème avenue',NULL,'CONAKRY',0,108,0,'00224622266096',NULL,NULL,'etablissementseleg@gmail.com',NULL,NULL,0,NULL,NULL,'RCCM/GC-KAL/022.758B/2009','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-03-11 14:52:00','2019-03-11 14:52:00',2,2,0,'',NULL),(33,'ROZAN Denis','',1,NULL,NULL,0,NULL,1,'CU1903-0016',NULL,NULL,NULL,'La Minière',NULL,'CONAKRY',0,108,0,'00224627257876',NULL,NULL,'denis.group@heavymat.com',NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-03-11 16:43:34','2019-03-11 16:43:34',2,2,0,'',NULL),(34,'PARQUE Véronique','',1,NULL,NULL,0,NULL,1,'CU1903-0017',NULL,NULL,NULL,'Commune de Ratoma',NULL,'CONAKRY',0,108,0,'00224622214904',NULL,NULL,'veroparque@gmail.com',NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-03-12 11:51:26','2019-03-12 11:51:26',2,2,0,'',NULL),(35,'Webb Fontaine','',1,NULL,NULL,0,NULL,1,'CU1903-0018',NULL,NULL,NULL,'',NULL,NULL,0,108,0,NULL,NULL,NULL,'luciano.fernandez@webbfontaine.com',NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,1,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-05-14 17:24:57','2019-03-23 14:51:27',2,2,1,'GNF',NULL),(36,'ARCANE','',1,NULL,NULL,0,NULL,1,'CU1904-0019',NULL,NULL,NULL,'99 Quai de la marne','94345','JOINVILLE LE PONT CEDEX',0,1,0,'0033148855750',NULL,NULL,'moufida.blidi@arcane-concept.com',NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-04-04 17:55:23','2019-04-04 17:55:23',2,2,2,'EUR',NULL),(37,'Marifala','',1,NULL,NULL,0,NULL,1,'CU1904-0020',NULL,NULL,NULL,'',NULL,NULL,0,108,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-04-08 17:21:40','2019-04-08 17:21:40',2,2,1,'GNF',NULL),(38,'FOFANA Almamy','',1,NULL,NULL,0,NULL,1,'CU1905-0021','SU1905-0022',NULL,NULL,'',NULL,NULL,0,108,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-05-06 18:55:21','2019-05-06 18:55:21',2,2,1,'GNF',NULL),(39,'Ministère de l\'environnement et des eaux et forêts','',1,NULL,NULL,0,NULL,1,'CU1905-0022',NULL,NULL,NULL,'',NULL,'CONAKRY',0,108,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-05-07 13:41:23','2019-05-06 19:23:50',2,2,1,'GNF',NULL),(40,'CAPAGO','',1,NULL,NULL,0,NULL,1,'CU1905-0023',NULL,NULL,NULL,'Immeuble ZEIN, 6ème étage.',NULL,'CONAKRY',0,108,0,NULL,NULL,NULL,'preddy@capago.eu',NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-05-17 14:22:41','2019-05-10 16:23:09',2,2,1,'GNF',NULL),(41,'TAS International','',1,NULL,NULL,0,NULL,1,'CU1905-0024','SU1905-0023',NULL,NULL,'',NULL,'CONAKRY',0,108,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,1,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-05-23 17:39:15','2019-05-23 17:39:15',2,2,1,'GNF',NULL),(42,'Inconnu','',1,NULL,NULL,0,NULL,1,'CU1905-0025',NULL,NULL,NULL,'',NULL,'CONAKRY',0,108,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-05-24 16:47:26','2019-05-24 16:47:26',2,2,1,'GNF',NULL),(43,'Kadija','',1,NULL,NULL,0,NULL,1,'CU1905-0026',NULL,NULL,NULL,'',NULL,'CONAKRY',0,108,0,NULL,NULL,NULL,'bkhadija1940@gmail.com',NULL,NULL,0,NULL,NULL,'','','','','','','',NULL,0,NULL,NULL,NULL,NULL,3,0,NULL,'',0,NULL,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,NULL,0.000,NULL,0.000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2019-05-27 16:22:03','2019-05-27 10:45:07',2,2,1,'GNF',NULL);

--
-- Table structure for table `llx_societe_account`
--

CREATE TABLE `llx_societe_account` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) DEFAULT '1',
  `key_account` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `login` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `pass_encoding` varchar(24) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pass_crypted` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pass_temp` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_soc` int(11) DEFAULT NULL,
  `site` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_website` int(11) DEFAULT NULL,
  `note_private` text COLLATE utf8_unicode_ci,
  `date_last_login` datetime DEFAULT NULL,
  `date_previous_login` datetime DEFAULT NULL,
  `date_creation` datetime NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_user_creat` int(11) NOT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_societe_account_login_website_soc` (`entity`,`fk_soc`,`login`,`site`,`fk_website`),
  UNIQUE KEY `uk_societe_account_key_account_soc` (`entity`,`fk_soc`,`key_account`,`site`,`fk_website`),
  KEY `idx_societe_account_rowid` (`rowid`),
  KEY `idx_societe_account_login` (`login`),
  KEY `idx_societe_account_status` (`status`),
  KEY `idx_societe_account_fk_website` (`fk_website`),
  KEY `idx_societe_account_fk_soc` (`fk_soc`),
  CONSTRAINT `llx_societe_account_fk_societe` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`),
  CONSTRAINT `llx_societe_account_fk_website` FOREIGN KEY (`fk_website`) REFERENCES `llx_website` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_societe_account`
--


--
-- Table structure for table `llx_societe_address`
--

CREATE TABLE `llx_societe_address` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `label` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_soc` int(11) DEFAULT '0',
  `name` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `town` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_pays` int(11) DEFAULT '0',
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fax` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_societe_address`
--


--
-- Table structure for table `llx_societe_commerciaux`
--

CREATE TABLE `llx_societe_commerciaux` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_soc` int(11) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_societe_commerciaux` (`fk_soc`,`fk_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_societe_commerciaux`
--


--
-- Table structure for table `llx_societe_extrafields`
--

CREATE TABLE `llx_societe_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_societe_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_societe_extrafields`
--


--
-- Table structure for table `llx_societe_log`
--

CREATE TABLE `llx_societe_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `datel` datetime DEFAULT NULL,
  `fk_soc` int(11) DEFAULT NULL,
  `fk_statut` int(11) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `author` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `label` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_societe_log`
--


--
-- Table structure for table `llx_societe_prices`
--

CREATE TABLE `llx_societe_prices` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_soc` int(11) DEFAULT '0',
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `price_level` tinyint(4) DEFAULT '1',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_societe_prices`
--


--
-- Table structure for table `llx_societe_remise`
--

CREATE TABLE `llx_societe_remise` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `fk_soc` int(11) NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `remise_client` double(6,3) NOT NULL DEFAULT '0.000',
  `note` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_societe_remise`
--


--
-- Table structure for table `llx_societe_remise_except`
--

CREATE TABLE `llx_societe_remise_except` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `fk_soc` int(11) NOT NULL,
  `discount_type` int(11) NOT NULL DEFAULT '0',
  `datec` datetime DEFAULT NULL,
  `amount_ht` double(24,8) NOT NULL,
  `amount_tva` double(24,8) NOT NULL DEFAULT '0.00000000',
  `amount_ttc` double(24,8) NOT NULL DEFAULT '0.00000000',
  `tva_tx` double(6,3) NOT NULL DEFAULT '0.000',
  `fk_user` int(11) NOT NULL,
  `fk_facture_line` int(11) DEFAULT NULL,
  `fk_facture` int(11) DEFAULT NULL,
  `fk_facture_source` int(11) DEFAULT NULL,
  `fk_invoice_supplier_line` int(11) DEFAULT NULL,
  `fk_invoice_supplier` int(11) DEFAULT NULL,
  `fk_invoice_supplier_source` int(11) DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `multicurrency_amount_ht` double(24,8) NOT NULL DEFAULT '0.00000000',
  `multicurrency_amount_tva` double(24,8) NOT NULL DEFAULT '0.00000000',
  `multicurrency_amount_ttc` double(24,8) NOT NULL DEFAULT '0.00000000',
  PRIMARY KEY (`rowid`),
  KEY `idx_societe_remise_except_fk_user` (`fk_user`),
  KEY `idx_societe_remise_except_fk_soc` (`fk_soc`),
  KEY `idx_societe_remise_except_fk_facture_line` (`fk_facture_line`),
  KEY `idx_societe_remise_except_fk_facture` (`fk_facture`),
  KEY `idx_societe_remise_except_fk_facture_source` (`fk_facture_source`),
  KEY `idx_societe_remise_except_discount_type` (`discount_type`),
  KEY `fk_soc_remise_fk_invoice_supplier_line` (`fk_invoice_supplier_line`),
  KEY `fk_societe_remise_fk_invoice_supplier_source` (`fk_invoice_supplier`),
  CONSTRAINT `fk_soc_remise_fk_facture_line` FOREIGN KEY (`fk_facture_line`) REFERENCES `llx_facturedet` (`rowid`),
  CONSTRAINT `fk_soc_remise_fk_invoice_supplier_line` FOREIGN KEY (`fk_invoice_supplier_line`) REFERENCES `llx_facture_fourn_det` (`rowid`),
  CONSTRAINT `fk_soc_remise_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`),
  CONSTRAINT `fk_societe_remise_fk_facture` FOREIGN KEY (`fk_facture`) REFERENCES `llx_facture` (`rowid`),
  CONSTRAINT `fk_societe_remise_fk_facture_source` FOREIGN KEY (`fk_facture_source`) REFERENCES `llx_facture` (`rowid`),
  CONSTRAINT `fk_societe_remise_fk_invoice_supplier` FOREIGN KEY (`fk_invoice_supplier`) REFERENCES `llx_facture_fourn` (`rowid`),
  CONSTRAINT `fk_societe_remise_fk_invoice_supplier_source` FOREIGN KEY (`fk_invoice_supplier`) REFERENCES `llx_facture_fourn` (`rowid`),
  CONSTRAINT `fk_societe_remise_fk_user` FOREIGN KEY (`fk_user`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_societe_remise_except`
--

INSERT INTO `llx_societe_remise_except` (`rowid`, `entity`, `fk_soc`, `discount_type`, `datec`, `amount_ht`, `amount_tva`, `amount_ttc`, `tva_tx`, `fk_user`, `fk_facture_line`, `fk_facture`, `fk_facture_source`, `fk_invoice_supplier_line`, `fk_invoice_supplier`, `fk_invoice_supplier_source`, `description`, `multicurrency_amount_ht`, `multicurrency_amount_tva`, `multicurrency_amount_ttc`) VALUES (1,1,6,0,'2019-01-29 09:47:28',32007834.00000000,5761410.12000000,37769244.12000000,18.000,2,95,NULL,8,NULL,NULL,NULL,'(DEPOSIT)',32007834.00000000,5761410.12000000,37769244.12000000),(2,1,6,0,'2019-01-29 09:55:50',96023502.00000000,17284230.36000000,113307732.36000000,18.000,2,96,NULL,10,NULL,NULL,NULL,'(DEPOSIT)',96023502.00000000,17284230.36000000,113307732.36000000),(3,1,35,0,'2019-04-15 18:14:02',304530044.00000000,54815407.91999999,359345451.91999990,18.000,2,NULL,NULL,30,NULL,NULL,NULL,'(DEPOSIT)',0.00000000,0.00000000,0.00000000),(4,1,35,0,'2019-04-15 18:15:46',203264120.40000000,36587541.60000000,239851661.60000000,18.000,2,NULL,NULL,29,NULL,NULL,NULL,'(DEPOSIT)',0.00000000,0.00000000,0.00000000),(5,1,6,0,'2019-05-16 11:12:33',80019585.00000000,14403525.30000000,94423110.30000000,18.000,2,97,NULL,13,NULL,NULL,NULL,'(DEPOSIT)',80019585.00000000,14403525.30000000,94423110.30000000),(6,1,6,0,'2019-05-16 11:12:59',64015668.00000000,11522820.24000000,75538488.24000000,18.000,2,98,NULL,11,NULL,NULL,NULL,'(DEPOSIT)',64015668.00000000,11522820.24000000,75538488.24000000),(7,1,6,0,'2019-05-16 11:27:21',25926345.54000000,0.00000000,25926345.54000000,0.000,2,NULL,NULL,NULL,NULL,NULL,NULL,'Retenue sur TVA',25926345.54000000,0.00000000,25926345.54000000),(8,1,6,0,'2019-05-16 11:31:58',16003917.00000000,0.00000000,16003917.00000000,0.000,2,101,NULL,NULL,NULL,NULL,NULL,'Retenue sur TVA',16003917.00000000,0.00000000,16003917.00000000),(9,1,26,0,'2019-05-16 12:03:22',139582805.60000000,25124905.00799999,164707710.60799995,18.000,2,NULL,NULL,19,NULL,NULL,NULL,'(DEPOSIT)',13420.88675844,2415.75961652,15836.64637496),(10,1,35,0,'2019-05-16 12:21:52',59507240.00000000,10711303.20000000,70218543.20000000,18.000,2,NULL,NULL,41,NULL,NULL,NULL,'(DEPOSIT)',0.00000000,0.00000000,0.00000000),(11,1,35,0,'2019-05-20 17:07:25',556739816.55000000,0.00000000,556739816.55000000,0.000,2,NULL,NULL,42,NULL,NULL,NULL,'(DEPOSIT)',0.00000000,0.00000000,0.00000000),(12,1,35,0,'2019-05-23 16:08:41',135509413.60000000,24391694.52000000,159901108.52000000,18.000,2,NULL,NULL,46,NULL,NULL,NULL,'(DEPOSIT)',0.00000000,0.00000000,0.00000000),(13,1,35,0,'2019-05-25 10:14:28',41712000.00000000,7508160.00000000,49220160.00000000,18.000,2,NULL,NULL,48,NULL,NULL,NULL,'(DEPOSIT)',0.00000000,0.00000000,0.00000000);

--
-- Table structure for table `llx_societe_remise_supplier`
--

CREATE TABLE `llx_societe_remise_supplier` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `fk_soc` int(11) NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `remise_supplier` double(6,3) NOT NULL DEFAULT '0.000',
  `note` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_societe_remise_supplier`
--


--
-- Table structure for table `llx_societe_rib`
--

CREATE TABLE `llx_societe_rib` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ban',
  `label` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_soc` int(11) NOT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `bank` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `code_banque` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `code_guichet` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
  `number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cle_rib` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bic` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `iban_prefix` varchar(34) COLLATE utf8_unicode_ci DEFAULT NULL,
  `domiciliation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `proprio` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `owner_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `default_rib` smallint(6) NOT NULL DEFAULT '0',
  `rum` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_rum` date DEFAULT NULL,
  `frstrecur` varchar(16) COLLATE utf8_unicode_ci DEFAULT 'FRST',
  `last_four` varchar(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `card_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cvn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `exp_date_month` int(11) DEFAULT NULL,
  `exp_date_year` int(11) DEFAULT NULL,
  `country_code` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `approved` int(11) DEFAULT '0',
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ending_date` date DEFAULT NULL,
  `max_total_amount_of_all_payments` double(24,8) DEFAULT NULL,
  `preapproval_key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `starting_date` date DEFAULT NULL,
  `total_amount_of_all_payments` double(24,8) DEFAULT NULL,
  `stripe_card_ref` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_societe_rib` (`label`,`fk_soc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_societe_rib`
--


--
-- Table structure for table `llx_socpeople`
--

CREATE TABLE `llx_socpeople` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_soc` int(11) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `ref_ext` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `civility` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lastname` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `firstname` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  `town` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_departement` int(11) DEFAULT NULL,
  `fk_pays` int(11) DEFAULT '0',
  `birthday` date DEFAULT NULL,
  `poste` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone_perso` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone_mobile` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fax` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `jabberid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `skype` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `photo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_email` smallint(6) NOT NULL DEFAULT '0',
  `priv` smallint(6) NOT NULL DEFAULT '0',
  `fk_user_creat` int(11) DEFAULT '0',
  `fk_user_modif` int(11) DEFAULT NULL,
  `note_private` text COLLATE utf8_unicode_ci,
  `note_public` text COLLATE utf8_unicode_ci,
  `default_lang` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
  `canvas` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `statut` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`rowid`),
  KEY `idx_socpeople_fk_soc` (`fk_soc`),
  KEY `idx_socpeople_fk_user_creat` (`fk_user_creat`),
  CONSTRAINT `fk_socpeople_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`),
  CONSTRAINT `fk_socpeople_user_creat_user_rowid` FOREIGN KEY (`fk_user_creat`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_socpeople`
--

INSERT INTO `llx_socpeople` (`rowid`, `datec`, `tms`, `fk_soc`, `entity`, `ref_ext`, `civility`, `lastname`, `firstname`, `address`, `zip`, `town`, `fk_departement`, `fk_pays`, `birthday`, `poste`, `phone`, `phone_perso`, `phone_mobile`, `fax`, `email`, `jabberid`, `skype`, `photo`, `no_email`, `priv`, `fk_user_creat`, `fk_user_modif`, `note_private`, `note_public`, `default_lang`, `canvas`, `import_key`, `statut`) VALUES (1,'2019-01-15 17:30:54','2019-01-15 17:30:54',2,1,'','MR','LY','Daouda','','','',NULL,108,NULL,'Commercial','00224622575206','00224664294383','','','lydaouda62@yahoo.fr','','',NULL,0,0,3,3,'','',NULL,NULL,NULL,1);

--
-- Table structure for table `llx_socpeople_extrafields`
--

CREATE TABLE `llx_socpeople_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_socpeople_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_socpeople_extrafields`
--


--
-- Table structure for table `llx_stock_mouvement`
--

CREATE TABLE `llx_stock_mouvement` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datem` datetime DEFAULT NULL,
  `fk_product` int(11) NOT NULL,
  `batch` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `eatby` date DEFAULT NULL,
  `sellby` date DEFAULT NULL,
  `fk_entrepot` int(11) NOT NULL,
  `value` double DEFAULT NULL,
  `price` double(24,8) DEFAULT '0.00000000',
  `type_mouvement` smallint(6) DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `label` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `inventorycode` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_origin` int(11) DEFAULT NULL,
  `origintype` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `model_pdf` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_stock_mouvement_fk_product` (`fk_product`),
  KEY `idx_stock_mouvement_fk_entrepot` (`fk_entrepot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_stock_mouvement`
--


--
-- Table structure for table `llx_subscription`
--

CREATE TABLE `llx_subscription` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `fk_adherent` int(11) DEFAULT NULL,
  `dateadh` datetime DEFAULT NULL,
  `datef` date DEFAULT NULL,
  `subscription` double(24,8) DEFAULT NULL,
  `fk_bank` int(11) DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_subscription` (`fk_adherent`,`dateadh`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_subscription`
--


--
-- Table structure for table `llx_supplier_proposal`
--

CREATE TABLE `llx_supplier_proposal` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `ref_ext` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref_int` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_soc` int(11) DEFAULT NULL,
  `fk_projet` int(11) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `date_valid` datetime DEFAULT NULL,
  `date_cloture` datetime DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `fk_user_cloture` int(11) DEFAULT NULL,
  `fk_statut` smallint(6) NOT NULL DEFAULT '0',
  `price` double DEFAULT '0',
  `remise_percent` double DEFAULT '0',
  `remise_absolue` double DEFAULT '0',
  `remise` double DEFAULT '0',
  `total_ht` double(24,8) DEFAULT '0.00000000',
  `tva` double(24,8) DEFAULT '0.00000000',
  `localtax1` double(24,8) DEFAULT '0.00000000',
  `localtax2` double(24,8) DEFAULT '0.00000000',
  `total` double(24,8) DEFAULT '0.00000000',
  `fk_account` int(11) DEFAULT NULL,
  `fk_currency` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_cond_reglement` int(11) DEFAULT NULL,
  `fk_mode_reglement` int(11) DEFAULT NULL,
  `note_private` text COLLATE utf8_unicode_ci,
  `note_public` text COLLATE utf8_unicode_ci,
  `model_pdf` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_main_doc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_livraison` date DEFAULT NULL,
  `fk_shipping_method` int(11) DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `extraparams` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `multicurrency_tx` double(24,8) DEFAULT '1.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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_supplier_proposal`
--


--
-- Table structure for table `llx_supplier_proposal_extrafields`
--

CREATE TABLE `llx_supplier_proposal_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_supplier_proposal_extrafields`
--


--
-- Table structure for table `llx_supplier_proposaldet`
--

CREATE TABLE `llx_supplier_proposaldet` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_supplier_proposal` int(11) NOT NULL,
  `fk_parent_line` int(11) DEFAULT NULL,
  `fk_product` int(11) DEFAULT NULL,
  `label` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `fk_remise_except` int(11) DEFAULT NULL,
  `vat_src_code` varchar(10) COLLATE utf8_unicode_ci DEFAULT '',
  `tva_tx` double(6,3) DEFAULT '0.000',
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax1_type` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `localtax2_type` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `qty` double DEFAULT NULL,
  `remise_percent` double DEFAULT '0',
  `remise` double DEFAULT '0',
  `price` double DEFAULT NULL,
  `subprice` double(24,8) DEFAULT '0.00000000',
  `total_ht` double(24,8) DEFAULT '0.00000000',
  `total_tva` double(24,8) DEFAULT '0.00000000',
  `total_localtax1` double(24,8) DEFAULT '0.00000000',
  `total_localtax2` double(24,8) DEFAULT '0.00000000',
  `total_ttc` double(24,8) DEFAULT '0.00000000',
  `product_type` int(11) DEFAULT '0',
  `info_bits` int(11) DEFAULT '0',
  `buy_price_ht` double(24,8) DEFAULT '0.00000000',
  `fk_product_fournisseur_price` int(11) DEFAULT NULL,
  `special_code` int(11) DEFAULT '0',
  `rang` int(11) DEFAULT '0',
  `ref_fourn` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_multicurrency` int(11) DEFAULT NULL,
  `multicurrency_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `multicurrency_subprice` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ht` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_tva` double(24,8) DEFAULT '0.00000000',
  `multicurrency_total_ttc` double(24,8) DEFAULT '0.00000000',
  `fk_unit` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_supplier_proposaldet_fk_supplier_proposal` (`fk_supplier_proposal`),
  KEY `idx_supplier_proposaldet_fk_product` (`fk_product`),
  KEY `fk_supplier_proposaldet_fk_unit` (`fk_unit`),
  CONSTRAINT `fk_supplier_proposaldet_fk_supplier_proposal` FOREIGN KEY (`fk_supplier_proposal`) REFERENCES `llx_supplier_proposal` (`rowid`),
  CONSTRAINT `fk_supplier_proposaldet_fk_unit` FOREIGN KEY (`fk_unit`) REFERENCES `llx_c_units` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_supplier_proposaldet`
--


--
-- Table structure for table `llx_supplier_proposaldet_extrafields`
--

CREATE TABLE `llx_supplier_proposaldet_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_supplier_proposaldet_extrafields`
--


--
-- Table structure for table `llx_ticket`
--

CREATE TABLE `llx_ticket` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) DEFAULT '1',
  `ref` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `track_id` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `fk_soc` int(11) DEFAULT '0',
  `fk_project` int(11) DEFAULT '0',
  `origin_email` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_user_create` int(11) DEFAULT NULL,
  `fk_user_assign` int(11) DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `message` text COLLATE utf8_unicode_ci,
  `fk_statut` int(11) DEFAULT NULL,
  `resolution` int(11) DEFAULT NULL,
  `progress` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `timing` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type_code` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `category_code` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `severity_code` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `date_read` datetime DEFAULT NULL,
  `date_close` datetime DEFAULT NULL,
  `notify_tiers_at_create` tinyint(4) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_ticket_track_id` (`track_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_ticket`
--


--
-- Table structure for table `llx_ticket_extrafields`
--

CREATE TABLE `llx_ticket_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_ticket_extrafields`
--


--
-- Table structure for table `llx_ticket_msg`
--

CREATE TABLE `llx_ticket_msg` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) DEFAULT '1',
  `fk_track_id` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_user_action` int(11) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `message` text COLLATE utf8_unicode_ci,
  `private` int(11) DEFAULT '0',
  PRIMARY KEY (`rowid`),
  KEY `fk_ticket_msg_fk_track_id` (`fk_track_id`),
  CONSTRAINT `fk_ticket_msg_fk_track_id` FOREIGN KEY (`fk_track_id`) REFERENCES `llx_ticket` (`track_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_ticket_msg`
--


--
-- Table structure for table `llx_tva`
--

CREATE TABLE `llx_tva` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `datep` date DEFAULT NULL,
  `datev` date DEFAULT NULL,
  `amount` double(24,8) NOT NULL DEFAULT '0.00000000',
  `fk_typepayment` int(11) DEFAULT NULL,
  `num_payment` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `label` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `note` text COLLATE utf8_unicode_ci,
  `fk_bank` int(11) DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_tva`
--


--
-- Table structure for table `llx_user`
--

CREATE TABLE `llx_user` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `ref_ext` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref_int` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `employee` tinyint(4) DEFAULT '1',
  `fk_establishment` int(11) DEFAULT '0',
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `login` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `pass_encoding` varchar(24) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pass` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pass_crypted` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pass_temp` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `api_key` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `gender` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `civility` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lastname` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `firstname` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  `town` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_state` int(11) DEFAULT '0',
  `fk_country` int(11) DEFAULT '0',
  `birth` date DEFAULT NULL,
  `job` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `skype` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `office_phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `office_fax` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_mobile` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `signature` text COLLATE utf8_unicode_ci,
  `admin` smallint(6) DEFAULT '0',
  `module_comm` smallint(6) DEFAULT '1',
  `module_compta` smallint(6) DEFAULT '1',
  `fk_soc` int(11) DEFAULT NULL,
  `fk_socpeople` int(11) DEFAULT NULL,
  `fk_member` int(11) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `note_public` text COLLATE utf8_unicode_ci,
  `note` text COLLATE utf8_unicode_ci,
  `model_pdf` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `datelastlogin` datetime DEFAULT NULL,
  `datepreviouslogin` datetime DEFAULT NULL,
  `egroupware_id` int(11) DEFAULT NULL,
  `ldap_sid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `statut` tinyint(4) DEFAULT '1',
  `photo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lang` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
  `color` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
  `barcode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_barcode_type` int(11) DEFAULT '0',
  `accountancy_code` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nb_holiday` int(11) DEFAULT '0',
  `thm` double(24,8) DEFAULT NULL,
  `tjm` double(24,8) DEFAULT NULL,
  `salary` double(24,8) DEFAULT NULL,
  `salaryextra` double(24,8) DEFAULT NULL,
  `dateemployment` date DEFAULT NULL,
  `weeklyhours` double(16,8) DEFAULT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  `default_range` int(11) DEFAULT NULL,
  `default_c_exp_tax_cat` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_user_login` (`login`,`entity`),
  UNIQUE KEY `uk_user_fk_socpeople` (`fk_socpeople`),
  UNIQUE KEY `uk_user_fk_member` (`fk_member`),
  UNIQUE KEY `uk_user_api_key` (`api_key`),
  KEY `idx_user_fk_societe` (`fk_soc`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_user`
--

INSERT INTO `llx_user` (`rowid`, `entity`, `ref_ext`, `ref_int`, `employee`, `fk_establishment`, `datec`, `tms`, `fk_user_creat`, `fk_user_modif`, `login`, `pass_encoding`, `pass`, `pass_crypted`, `pass_temp`, `api_key`, `gender`, `civility`, `lastname`, `firstname`, `address`, `zip`, `town`, `fk_state`, `fk_country`, `birth`, `job`, `skype`, `office_phone`, `office_fax`, `user_mobile`, `email`, `signature`, `admin`, `module_comm`, `module_compta`, `fk_soc`, `fk_socpeople`, `fk_member`, `fk_user`, `note_public`, `note`, `model_pdf`, `datelastlogin`, `datepreviouslogin`, `egroupware_id`, `ldap_sid`, `openid`, `statut`, `photo`, `lang`, `color`, `barcode`, `fk_barcode_type`, `accountancy_code`, `nb_holiday`, `thm`, `tjm`, `salary`, `salaryextra`, `dateemployment`, `weeklyhours`, `import_key`, `default_range`, `default_c_exp_tax_cat`) VALUES (1,0,NULL,NULL,1,0,'2019-01-14 14:21:07','2019-05-11 13:16:47',NULL,NULL,'admin',NULL,NULL,'$2y$10$97zY31Dd9SZME5EkCm5qRudoACiLAgiVZxqqzuBKvvH3kqOs7OYvK',NULL,NULL,NULL,NULL,'SuperAdmin','','','','',NULL,NULL,NULL,'','','','','','info@mt-solutions.africa','',1,1,1,NULL,NULL,NULL,NULL,NULL,'',NULL,'2019-05-09 13:28:32','2019-01-14 14:21:22',NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,0,NULL,NULL,1,0,'2019-01-14 15:08:37','2019-05-10 15:54:27',NULL,NULL,'cedric',NULL,NULL,'$2y$10$VS/Ii.FirOpU.D4nKGHJ0epUvp/OuUPW5M5HrREFk4ZF7OTjWknCG',NULL,'2bv3wd46',NULL,NULL,'cedric','','','','',NULL,NULL,NULL,'','','','','','info@mt-solutions.africa','',1,1,1,NULL,NULL,NULL,NULL,NULL,'',NULL,'2019-05-30 14:01:04','2019-05-27 15:48:36',NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,1,NULL,NULL,1,0,'2019-01-14 15:57:51','2019-05-11 13:17:05',NULL,NULL,'info',NULL,NULL,'$2y$10$VQuIq7Q0QRegmKwxoevlPunf6lG8U/GS2LJx0X/lkoSDgdX4reL9S',NULL,'j1tzm5gd',NULL,NULL,'info','','','','',NULL,NULL,NULL,'','','','','','info@mt-solutions.africa','',0,1,1,NULL,NULL,NULL,NULL,NULL,'',NULL,'2019-01-15 17:12:05','2019-01-14 16:04:46',NULL,'',NULL,1,NULL,NULL,'',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,1,NULL,NULL,1,0,'2019-01-21 18:34:05','2019-05-16 14:34:54',NULL,NULL,'LOUA',NULL,NULL,'$2y$10$qJsaIiiom5qniZ1Z7MrnLeoPnoa.LyroeAs42jKWZapztXr07QEci',NULL,'8s03gwhb','woman',NULL,'LOUA','Charlotte','','','',NULL,NULL,NULL,'Assistante','','','','','','',0,1,1,NULL,NULL,NULL,NULL,NULL,'',NULL,'2019-05-14 15:45:08','2019-05-14 14:04:25',NULL,'',NULL,0,NULL,NULL,'',NULL,0,'',0,NULL,NULL,700000.00000000,NULL,'2019-01-01',NULL,NULL,NULL,NULL),(5,1,NULL,NULL,1,0,'2019-05-16 14:41:48','2019-05-16 14:42:52',NULL,NULL,'SOUMAH',NULL,NULL,'$2y$10$FmAlf7.8dHf.mw0sCg3xq.1TjOAzTYa2GKu1evRMsOFvmBboEaFBO',NULL,'p40qj3xh','man',NULL,'SOUMAH','Almamy','','','CONAKRY',NULL,108,'1987-05-10','','','','','625266060','soumahalmamy12@gmail.com','',0,1,1,NULL,NULL,NULL,2,NULL,'',NULL,'2019-05-18 10:36:31','2019-05-17 14:10:45',NULL,'',NULL,1,NULL,NULL,'ffffaa',NULL,0,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `llx_user_alert`
--

CREATE TABLE `llx_user_alert` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(11) DEFAULT NULL,
  `fk_contact` int(11) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_user_alert`
--


--
-- Table structure for table `llx_user_clicktodial`
--

CREATE TABLE `llx_user_clicktodial` (
  `fk_user` int(11) NOT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `login` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pass` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `poste` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`fk_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_user_clicktodial`
--


--
-- Table structure for table `llx_user_employment`
--

CREATE TABLE `llx_user_employment` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `ref` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref_ext` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `job` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(11) NOT NULL,
  `salary` double(24,8) DEFAULT NULL,
  `salaryextra` double(24,8) DEFAULT NULL,
  `weeklyhours` double(16,8) DEFAULT NULL,
  `dateemployment` date DEFAULT NULL,
  `dateemploymentend` date DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_user_employment` (`ref`,`entity`),
  KEY `fk_user_employment_fk_user` (`fk_user`),
  CONSTRAINT `fk_user_employment_fk_user` FOREIGN KEY (`fk_user`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_user_employment`
--


--
-- Table structure for table `llx_user_extrafields`
--

CREATE TABLE `llx_user_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_user_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_user_extrafields`
--


--
-- Table structure for table `llx_user_param`
--

CREATE TABLE `llx_user_param` (
  `fk_user` int(11) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `param` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  UNIQUE KEY `uk_user_param` (`fk_user`,`param`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_user_param`
--

INSERT INTO `llx_user_param` (`fk_user`, `entity`, `param`, `value`) VALUES (2,1,'MAIN_SELECTEDFIELDS_banktransactionlist','b.rowid,description,b.datev,type,b.num_chq,bu.label,b.debit,b.credit,balance,b.num_releve,b.conciliated,'),(2,1,'MAIN_SELECTEDFIELDS_invoicelist','f.facnumber,f.date,f.date_lim_reglement,s.nom,f.total_ht,dynamount_payed,rtp,f.fk_statut,'),(2,1,'MAIN_SELECTEDFIELDS_projectlist','p.budget_amount,p.ref,p.title,s.nom,p.dateo,p.datee,p.public,p.opp_amount,p.fk_opp_status,p.opp_percent,p.fk_statut,');

--
-- Table structure for table `llx_user_rib`
--

CREATE TABLE `llx_user_rib` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_user` int(11) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `label` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bank` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `code_banque` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `code_guichet` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
  `number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cle_rib` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bic` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL,
  `iban_prefix` varchar(34) COLLATE utf8_unicode_ci DEFAULT NULL,
  `domiciliation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `proprio` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `owner_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_user_rib`
--


--
-- Table structure for table `llx_user_rights`
--

CREATE TABLE `llx_user_rights` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `fk_user` int(11) NOT NULL,
  `fk_id` int(11) NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_user_rights` (`entity`,`fk_user`,`fk_id`),
  KEY `fk_user_rights_fk_user_user` (`fk_user`),
  CONSTRAINT `fk_user_rights_fk_user_user` FOREIGN KEY (`fk_user`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=539 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_user_rights`
--

INSERT INTO `llx_user_rights` (`rowid`, `entity`, `fk_user`, `fk_id`) VALUES (141,1,1,11),(128,1,1,12),(131,1,1,13),(133,1,1,14),(135,1,1,15),(138,1,1,16),(142,1,1,19),(49,1,1,21),(34,1,1,22),(37,1,1,24),(39,1,1,25),(42,1,1,26),(46,1,1,27),(50,1,1,28),(219,1,1,31),(212,1,1,32),(216,1,1,34),(220,1,1,38),(386,1,1,41),(379,1,1,42),(383,1,1,44),(387,1,1,45),(159,1,1,91),(152,1,1,92),(156,1,1,93),(160,1,1,94),(223,1,1,95),(199,1,1,111),(180,1,1,112),(184,1,1,113),(188,1,1,114),(192,1,1,115),(196,1,1,116),(200,1,1,117),(11,1,1,121),(4,1,1,122),(8,1,1,125),(12,1,1,126),(396,1,1,141),(393,1,1,142),(397,1,1,144),(261,1,1,241),(258,1,1,242),(262,1,1,243),(15,1,1,262),(27,1,1,281),(20,1,1,282),(24,1,1,283),(28,1,1,286),(173,1,1,511),(166,1,1,512),(170,1,1,514),(174,1,1,517),(235,1,1,531),(228,1,1,532),(232,1,1,534),(236,1,1,538),(245,1,1,1001),(242,1,1,1002),(246,1,1,1003),(251,1,1,1004),(252,1,1,1005),(121,1,1,1121),(106,1,1,1122),(110,1,1,1123),(114,1,1,1124),(118,1,1,1125),(122,1,1,1126),(53,1,1,1181),(81,1,1,1182),(58,1,1,1183),(61,1,1,1184),(64,1,1,1185),(68,1,1,1186),(72,1,1,1187),(78,1,1,1188),(75,1,1,1189),(82,1,1,1191),(269,1,1,1201),(270,1,1,1202),(99,1,1,1231),(88,1,1,1232),(91,1,1,1233),(94,1,1,1234),(97,1,1,1235),(100,1,1,1236),(265,1,1,1251),(145,1,1,1321),(147,1,1,1322),(406,1,1,2401),(403,1,1,2402),(407,1,1,2403),(416,1,1,2411),(413,1,1,2412),(417,1,1,2413),(420,1,1,2414),(483,1,1,2501),(480,1,1,2503),(484,1,1,2515),(458,1,1,20001),(439,1,1,20002),(443,1,1,20003),(451,1,1,20004),(455,1,1,20005),(459,1,1,20006),(447,1,1,20007),(283,1,1,23001),(276,1,1,23002),(280,1,1,23003),(284,1,1,23004),(203,1,1,59001),(205,1,1,59002),(207,1,1,59003),(432,1,1,63001),(425,1,1,63002),(429,1,1,63003),(433,1,1,63004),(143,1,2,11),(130,1,2,12),(132,1,2,13),(134,1,2,14),(136,1,2,15),(140,1,2,16),(144,1,2,19),(51,1,2,21),(36,1,2,22),(38,1,2,24),(40,1,2,25),(44,1,2,26),(48,1,2,27),(52,1,2,28),(221,1,2,31),(214,1,2,32),(218,1,2,34),(222,1,2,38),(388,1,2,41),(381,1,2,42),(385,1,2,44),(389,1,2,45),(161,1,2,91),(154,1,2,92),(158,1,2,93),(162,1,2,94),(224,1,2,95),(201,1,2,111),(182,1,2,112),(186,1,2,113),(190,1,2,114),(194,1,2,115),(198,1,2,116),(202,1,2,117),(13,1,2,121),(6,1,2,122),(10,1,2,125),(14,1,2,126),(398,1,2,141),(395,1,2,142),(399,1,2,144),(263,1,2,241),(260,1,2,242),(264,1,2,243),(16,1,2,262),(29,1,2,281),(22,1,2,282),(26,1,2,283),(30,1,2,286),(175,1,2,511),(168,1,2,512),(172,1,2,514),(176,1,2,517),(237,1,2,531),(230,1,2,532),(234,1,2,534),(238,1,2,538),(247,1,2,1001),(244,1,2,1002),(248,1,2,1003),(253,1,2,1004),(254,1,2,1005),(123,1,2,1121),(108,1,2,1122),(112,1,2,1123),(116,1,2,1124),(120,1,2,1125),(124,1,2,1126),(54,1,2,1181),(83,1,2,1182),(60,1,2,1183),(62,1,2,1184),(66,1,2,1185),(70,1,2,1186),(74,1,2,1187),(80,1,2,1188),(76,1,2,1189),(84,1,2,1191),(271,1,2,1201),(272,1,2,1202),(101,1,2,1231),(90,1,2,1232),(92,1,2,1233),(96,1,2,1234),(98,1,2,1235),(102,1,2,1236),(266,1,2,1251),(146,1,2,1321),(148,1,2,1322),(408,1,2,2401),(405,1,2,2402),(409,1,2,2403),(418,1,2,2411),(415,1,2,2412),(419,1,2,2413),(421,1,2,2414),(485,1,2,2501),(482,1,2,2503),(486,1,2,2515),(460,1,2,20001),(441,1,2,20002),(445,1,2,20003),(453,1,2,20004),(457,1,2,20005),(461,1,2,20006),(449,1,2,20007),(285,1,2,23001),(278,1,2,23002),(282,1,2,23003),(286,1,2,23004),(204,1,2,59001),(206,1,2,59002),(208,1,2,59003),(434,1,2,63001),(427,1,2,63002),(431,1,2,63003),(435,1,2,63004),(304,1,3,11),(305,1,3,12),(306,1,3,13),(307,1,3,14),(308,1,3,15),(309,1,3,16),(310,1,3,19),(337,1,3,21),(338,1,3,22),(339,1,3,24),(340,1,3,25),(341,1,3,26),(342,1,3,27),(343,1,3,28),(333,1,3,31),(334,1,3,32),(335,1,3,34),(336,1,3,38),(372,1,3,91),(373,1,3,92),(374,1,3,93),(375,1,3,94),(297,1,3,95),(287,1,3,111),(288,1,3,112),(289,1,3,113),(290,1,3,114),(291,1,3,115),(292,1,3,116),(293,1,3,117),(352,1,3,121),(353,1,3,122),(354,1,3,125),(355,1,3,126),(294,1,3,241),(295,1,3,242),(296,1,3,243),(356,1,3,262),(357,1,3,281),(358,1,3,282),(359,1,3,283),(360,1,3,286),(344,1,3,511),(345,1,3,512),(346,1,3,514),(347,1,3,517),(348,1,3,531),(349,1,3,532),(350,1,3,534),(351,1,3,538),(361,1,3,1001),(362,1,3,1002),(363,1,3,1003),(364,1,3,1004),(365,1,3,1005),(366,1,3,1121),(367,1,3,1122),(368,1,3,1123),(369,1,3,1124),(370,1,3,1125),(371,1,3,1126),(313,1,3,1181),(314,1,3,1182),(315,1,3,1183),(316,1,3,1184),(317,1,3,1185),(318,1,3,1186),(319,1,3,1187),(320,1,3,1188),(321,1,3,1189),(322,1,3,1191),(302,1,3,1201),(303,1,3,1202),(323,1,3,1231),(324,1,3,1232),(325,1,3,1233),(326,1,3,1234),(327,1,3,1235),(328,1,3,1236),(329,1,3,1251),(311,1,3,1321),(312,1,3,1322),(298,1,3,23001),(299,1,3,23002),(300,1,3,23003),(301,1,3,23004),(330,1,3,59001),(331,1,3,59002),(332,1,3,59003),(476,1,4,95),(462,1,4,111),(463,1,4,112),(464,1,4,113),(465,1,4,114),(466,1,4,115),(467,1,4,116),(468,1,4,117),(469,1,4,2401),(470,1,4,2402),(471,1,4,2403),(472,1,4,2411),(473,1,4,2412),(474,1,4,2413),(475,1,4,2414),(497,1,5,11),(498,1,5,12),(499,1,5,13),(500,1,5,14),(501,1,5,15),(502,1,5,16),(528,1,5,21),(529,1,5,22),(530,1,5,24),(531,1,5,25),(532,1,5,26),(534,1,5,28),(522,1,5,31),(523,1,5,32),(525,1,5,38),(526,1,5,41),(492,1,5,111),(489,1,5,112),(491,1,5,114),(493,1,5,117),(527,1,5,141),(494,1,5,241),(535,1,5,531),(536,1,5,532),(538,1,5,538),(506,1,5,1181),(507,1,5,1182),(508,1,5,1183),(509,1,5,1184),(510,1,5,1185),(511,1,5,1186),(512,1,5,1187),(514,1,5,1189),(515,1,5,1191),(496,1,5,1201),(516,1,5,1231),(517,1,5,1232),(518,1,5,1233),(520,1,5,1235),(521,1,5,1236),(504,1,5,1321),(505,1,5,1322),(495,1,5,2501);

--
-- Table structure for table `llx_usergroup`
--

CREATE TABLE `llx_usergroup` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `note` text COLLATE utf8_unicode_ci,
  `model_pdf` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_usergroup_name` (`nom`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_usergroup`
--


--
-- Table structure for table `llx_usergroup_extrafields`
--

CREATE TABLE `llx_usergroup_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_usergroup_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_usergroup_extrafields`
--


--
-- Table structure for table `llx_usergroup_rights`
--

CREATE TABLE `llx_usergroup_rights` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `fk_usergroup` int(11) NOT NULL,
  `fk_id` int(11) NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_usergroup_rights` (`entity`,`fk_usergroup`,`fk_id`),
  KEY `fk_usergroup_rights_fk_usergroup` (`fk_usergroup`),
  CONSTRAINT `fk_usergroup_rights_fk_usergroup` FOREIGN KEY (`fk_usergroup`) REFERENCES `llx_usergroup` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_usergroup_rights`
--


--
-- Table structure for table `llx_usergroup_user`
--

CREATE TABLE `llx_usergroup_user` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `fk_user` int(11) NOT NULL,
  `fk_usergroup` int(11) NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_usergroup_user` (`entity`,`fk_user`,`fk_usergroup`),
  KEY `fk_usergroup_user_fk_user` (`fk_user`),
  KEY `fk_usergroup_user_fk_usergroup` (`fk_usergroup`),
  CONSTRAINT `fk_usergroup_user_fk_user` FOREIGN KEY (`fk_user`) REFERENCES `llx_user` (`rowid`),
  CONSTRAINT `fk_usergroup_user_fk_usergroup` FOREIGN KEY (`fk_usergroup`) REFERENCES `llx_usergroup` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_usergroup_user`
--


--
-- Table structure for table `llx_website`
--

CREATE TABLE `llx_website` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `type_container` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'page',
  `entity` int(11) NOT NULL DEFAULT '1',
  `ref` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(11) DEFAULT '1',
  `fk_default_home` int(11) DEFAULT NULL,
  `virtualhost` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_user_create` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `date_creation` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_website_ref` (`ref`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_website`
--


--
-- Table structure for table `llx_website_extrafields`
--

CREATE TABLE `llx_website_extrafields` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_object` int(11) NOT NULL,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_website_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_website_extrafields`
--


--
-- Table structure for table `llx_website_page`
--

CREATE TABLE `llx_website_page` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_website` int(11) NOT NULL,
  `type_container` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'page',
  `pageurl` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `aliasalt` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lang` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_page` int(11) DEFAULT NULL,
  `htmlheader` text COLLATE utf8_unicode_ci,
  `content` mediumtext COLLATE utf8_unicode_ci,
  `status` int(11) DEFAULT '1',
  `grabbed_from` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fk_user_create` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `date_creation` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `import_key` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_website_page_url` (`fk_website`,`pageurl`),
  CONSTRAINT `fk_website_page_website` FOREIGN KEY (`fk_website`) REFERENCES `llx_website` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `llx_website_page`
--



