-- Table structure for table `am_facturedet_extrafields`
--

CREATE TABLE `am_facturedet_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) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_facturedet_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_facturedet_extrafields`
--


--
-- Table structure for table `am_facturedet_rec`
--

CREATE TABLE `am_facturedet_rec` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_facture` int(11) NOT NULL,
  `fk_parent_line` int(11) DEFAULT NULL,
  `fk_product` int(11) DEFAULT NULL,
  `product_type` int(11) DEFAULT '0',
  `label` varchar(255) DEFAULT NULL,
  `description` text,
  `tva_tx` double(6,3) DEFAULT '19.600',
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax1_type` varchar(10) DEFAULT NULL,
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `localtax2_type` varchar(10) DEFAULT NULL,
  `qty` double DEFAULT NULL,
  `remise_percent` double DEFAULT '0',
  `remise` double DEFAULT '0',
  `subprice` double(24,8) DEFAULT NULL,
  `price` double(24,8) DEFAULT NULL,
  `total_ht` double(24,8) DEFAULT NULL,
  `total_tva` double(24,8) DEFAULT NULL,
  `total_localtax1` double(24,8) DEFAULT '0.00000000',
  `total_localtax2` double(24,8) DEFAULT '0.00000000',
  `total_ttc` double(24,8) DEFAULT NULL,
  `info_bits` int(11) DEFAULT '0',
  `special_code` int(10) unsigned DEFAULT '0',
  `rang` int(11) DEFAULT '0',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=174 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_facturedet_rec`
--

INSERT INTO `am_facturedet_rec` VALUES (1,1,NULL,1,1,NULL,'(Pays d\'origine: Belgique)',21.000,0.000,NULL,0.000,NULL,11,0,NULL,190.00000000,190.00000000,2090.00000000,438.90000000,0.00000000,0.00000000,2528.90000000,0,0,1),(2,1,NULL,2,1,NULL,'',21.000,0.000,NULL,0.000,NULL,11,0,NULL,190.00000000,190.00000000,2090.00000000,438.90000000,0.00000000,0.00000000,2528.90000000,0,0,2),(3,1,NULL,6,1,NULL,'',21.000,0.000,NULL,0.000,NULL,11,0,NULL,190.00000000,190.00000000,2090.00000000,438.90000000,0.00000000,0.00000000,2528.90000000,0,0,3),(4,1,NULL,7,1,NULL,'',21.000,0.000,NULL,0.000,NULL,11,0,NULL,130.00000000,130.00000000,1430.00000000,300.30000000,0.00000000,0.00000000,1730.30000000,0,0,4),(5,1,NULL,11,1,NULL,'',21.000,0.000,NULL,0.000,NULL,11,0,NULL,150.00000000,150.00000000,1650.00000000,346.50000000,0.00000000,0.00000000,1996.50000000,0,0,5),(6,1,NULL,12,1,NULL,'',21.000,0.000,NULL,0.000,NULL,11,0,NULL,140.00000000,140.00000000,1540.00000000,323.40000000,0.00000000,0.00000000,1863.40000000,0,0,6),(7,1,NULL,47,1,NULL,'',21.000,0.000,NULL,0.000,NULL,11,0,NULL,190.00000000,190.00000000,2090.00000000,438.90000000,0.00000000,0.00000000,2528.90000000,0,0,7),(8,1,NULL,16,1,NULL,'',21.000,0.000,NULL,0.000,NULL,11,0,NULL,165.00000000,165.00000000,1815.00000000,381.15000000,0.00000000,0.00000000,2196.15000000,0,0,8),(9,1,NULL,17,1,NULL,'',21.000,0.000,NULL,0.000,NULL,11,0,NULL,180.00000000,180.00000000,1980.00000000,415.80000000,0.00000000,0.00000000,2395.80000000,0,0,9),(10,1,NULL,18,1,NULL,'',21.000,0.000,NULL,0.000,NULL,11,0,NULL,190.00000000,190.00000000,2090.00000000,438.90000000,0.00000000,0.00000000,2528.90000000,0,0,10),(11,1,NULL,44,1,NULL,'',0.000,0.000,NULL,0.000,NULL,1,0,NULL,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0,0,11),(12,2,NULL,21,1,NULL,'',21.000,0.000,NULL,0.000,NULL,11,0,NULL,190.00000000,190.00000000,2090.00000000,438.90000000,0.00000000,0.00000000,2528.90000000,0,0,1),(13,2,NULL,22,1,NULL,'',21.000,0.000,NULL,0.000,NULL,11,0,NULL,190.00000000,190.00000000,2090.00000000,438.90000000,0.00000000,0.00000000,2528.90000000,0,0,2),(14,2,NULL,23,1,NULL,'',21.000,0.000,NULL,0.000,NULL,11,0,NULL,190.00000000,190.00000000,2090.00000000,438.90000000,0.00000000,0.00000000,2528.90000000,0,0,3),(15,2,NULL,24,1,NULL,'',21.000,0.000,NULL,0.000,NULL,11,0,NULL,190.00000000,190.00000000,2090.00000000,438.90000000,0.00000000,0.00000000,2528.90000000,0,0,4),(16,2,NULL,25,1,NULL,'',21.000,0.000,NULL,0.000,NULL,11,0,NULL,100.00000000,100.00000000,1100.00000000,231.00000000,0.00000000,0.00000000,1331.00000000,0,0,5),(17,2,NULL,26,1,NULL,'',21.000,0.000,NULL,0.000,NULL,11,0,NULL,120.00000000,120.00000000,1320.00000000,277.20000000,0.00000000,0.00000000,1597.20000000,0,0,6),(18,2,NULL,52,1,NULL,'',21.000,0.000,NULL,0.000,NULL,11,0,NULL,190.00000000,190.00000000,2090.00000000,438.90000000,0.00000000,0.00000000,2528.90000000,0,0,7),(19,2,NULL,53,1,NULL,'',21.000,0.000,NULL,0.000,NULL,11,0,NULL,190.00000000,190.00000000,2090.00000000,438.90000000,0.00000000,0.00000000,2528.90000000,0,0,8),(20,2,NULL,54,1,NULL,'',21.000,0.000,NULL,0.000,NULL,11,0,NULL,125.00000000,125.00000000,1375.00000000,288.75000000,0.00000000,0.00000000,1663.75000000,0,0,9),(21,2,NULL,55,1,NULL,'',21.000,0.000,NULL,0.000,NULL,11,0,NULL,125.00000000,125.00000000,1375.00000000,288.75000000,0.00000000,0.00000000,1663.75000000,0,0,10),(22,2,NULL,44,1,NULL,'',0.000,0.000,NULL,0.000,NULL,1,0,NULL,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0,0,11),(43,5,NULL,45,1,NULL,'',21.000,0.000,NULL,0.000,NULL,59,0,NULL,75.00000000,75.00000000,4425.00000000,929.25000000,0.00000000,0.00000000,5354.25000000,0,0,1),(53,7,NULL,37,1,NULL,'',21.000,0.000,NULL,0.000,NULL,1688,0,NULL,0.40000000,0.40000000,675.20000000,141.79000000,0.00000000,0.00000000,816.99000000,0,0,1),(54,7,NULL,56,0,NULL,'(Pays d\'origine: Belgique)',21.000,0.000,NULL,0.000,NULL,3075,0,NULL,0.55000000,0.55000000,1691.25000000,355.16000000,0.00000000,0.00000000,2046.41000000,0,0,2),(55,7,NULL,41,1,NULL,'',21.000,0.000,NULL,0.000,NULL,25,0,NULL,8.00000000,8.00000000,200.00000000,42.00000000,0.00000000,0.00000000,242.00000000,0,0,3),(56,7,NULL,40,1,NULL,'',21.000,0.000,NULL,0.000,NULL,2745,0,NULL,0.40000000,0.40000000,1098.00000000,230.58000000,0.00000000,0.00000000,1328.58000000,0,0,4),(57,7,NULL,31,1,NULL,'',21.000,0.000,NULL,0.000,NULL,2700,0,NULL,0.40000000,0.40000000,1080.00000000,226.80000000,0.00000000,0.00000000,1306.80000000,0,0,5),(58,7,NULL,33,1,NULL,'',21.000,0.000,NULL,0.000,NULL,15,0,NULL,8.00000000,8.00000000,120.00000000,25.20000000,0.00000000,0.00000000,145.20000000,0,0,6),(59,7,NULL,34,1,NULL,'',21.000,0.000,NULL,0.000,NULL,14,0,NULL,8.00000000,8.00000000,112.00000000,23.52000000,0.00000000,0.00000000,135.52000000,0,0,7),(60,7,NULL,35,1,NULL,'',21.000,0.000,NULL,0.000,NULL,190,0,NULL,0.40000000,0.40000000,76.00000000,15.96000000,0.00000000,0.00000000,91.96000000,0,0,8),(61,7,NULL,42,1,NULL,'',21.000,0.000,NULL,0.000,NULL,31,0,NULL,120.00000000,120.00000000,3720.00000000,781.20000000,0.00000000,0.00000000,4501.20000000,0,0,9),(62,8,NULL,61,0,NULL,'Adresse de Location:&nbsp; 15 Dorent , 1620 Drogenbos',21.000,0.000,NULL,0.000,NULL,1,0,NULL,1000.00000000,1000.00000000,1000.00000000,210.00000000,0.00000000,0.00000000,1210.00000000,0,0,1),(63,8,NULL,61,0,NULL,'Adresse de Location:&nbsp; 15 Dorent , 1620 Drogenbos',21.000,0.000,NULL,0.000,NULL,1,0,NULL,1000.00000000,1000.00000000,1000.00000000,210.00000000,0.00000000,0.00000000,1210.00000000,0,0,2),(64,8,NULL,61,0,NULL,'Adresse de Location:&nbsp; 15 Dorent , 1620 Drogenbos',21.000,0.000,NULL,0.000,NULL,1,0,NULL,1000.00000000,1000.00000000,1000.00000000,210.00000000,0.00000000,0.00000000,1210.00000000,0,0,3),(65,9,NULL,59,1,NULL,'Conciergerie +Netoyage\n(Pays d\'origine: Belgique)',21.000,0.000,NULL,0.000,NULL,1,0,NULL,1250.00000000,1250.00000000,1250.00000000,262.50000000,0.00000000,0.00000000,1512.50000000,0,0,1),(66,10,NULL,59,1,NULL,'(Conciergerie +Nettoyage)\n(Pays d\'origine: Belgique)',21.000,0.000,NULL,0.000,NULL,1,0,NULL,1040.00000000,1040.00000000,1040.00000000,218.40000000,0.00000000,0.00000000,1258.40000000,0,0,1),(67,11,NULL,37,1,NULL,'',21.000,0.000,NULL,0.000,NULL,1599,0,NULL,0.40000000,0.40000000,639.60000000,134.32000000,0.00000000,0.00000000,773.92000000,0,0,1),(68,11,NULL,56,0,NULL,'(Pays d\'origine: Belgique)',21.000,0.000,NULL,0.000,NULL,5853,0,NULL,0.55000000,0.55000000,3219.15000000,676.02000000,0.00000000,0.00000000,3895.17000000,0,0,2),(69,11,NULL,41,1,NULL,'',21.000,0.000,NULL,0.000,NULL,40,0,NULL,8.00000000,8.00000000,320.00000000,67.20000000,0.00000000,0.00000000,387.20000000,0,0,3),(70,11,NULL,40,1,NULL,'',21.000,0.000,NULL,0.000,NULL,5288,0,NULL,0.40000000,0.40000000,2115.20000000,444.19000000,0.00000000,0.00000000,2559.39000000,0,0,4),(71,11,NULL,31,1,NULL,'',21.000,0.000,NULL,0.000,NULL,2440,0,NULL,0.40000000,0.40000000,976.00000000,204.96000000,0.00000000,0.00000000,1180.96000000,0,0,5),(72,11,NULL,33,1,NULL,'',21.000,0.000,NULL,0.000,NULL,13,0,NULL,8.00000000,8.00000000,104.00000000,21.84000000,0.00000000,0.00000000,125.84000000,0,0,6),(73,11,NULL,34,1,NULL,'',21.000,0.000,NULL,0.000,NULL,16,0,NULL,8.00000000,8.00000000,128.00000000,26.88000000,0.00000000,0.00000000,154.88000000,0,0,7),(74,11,NULL,35,1,NULL,'',21.000,0.000,NULL,0.000,NULL,360,0,NULL,0.40000000,0.40000000,144.00000000,30.24000000,0.00000000,0.00000000,174.24000000,0,0,8),(75,11,NULL,42,1,NULL,'',21.000,0.000,NULL,0.000,NULL,31,0,NULL,120.00000000,120.00000000,3720.00000000,781.20000000,0.00000000,0.00000000,4501.20000000,0,0,9),(76,11,NULL,39,1,NULL,'',21.000,0.000,NULL,0.000,NULL,431,0,NULL,0.40000000,0.40000000,172.40000000,36.20000000,0.00000000,0.00000000,208.60000000,0,0,10),(77,11,NULL,43,1,NULL,'(le 01/11/2013)',21.000,0.000,NULL,0.000,NULL,3,0,NULL,190.00000000,190.00000000,570.00000000,119.70000000,0.00000000,0.00000000,689.70000000,0,0,11),(78,11,NULL,43,1,NULL,'( le 11/11/2013',21.000,0.000,NULL,0.000,NULL,2,0,NULL,190.00000000,190.00000000,380.00000000,79.80000000,0.00000000,0.00000000,459.80000000,0,0,12),(79,11,NULL,44,1,NULL,'',0.000,0.000,NULL,0.000,NULL,1,0,NULL,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0,0,13),(80,12,NULL,70,1,NULL,'',21.000,0.000,NULL,0.000,NULL,432,0,NULL,7.50000000,7.50000000,3240.00000000,680.40000000,0.00000000,0.00000000,3920.40000000,0,0,1),(81,12,NULL,71,1,NULL,'',21.000,0.000,NULL,0.000,NULL,5108.4,0,NULL,0.30000000,0.30000000,1532.52000000,321.83000000,0.00000000,0.00000000,1854.35000000,0,0,2),(82,12,NULL,72,1,NULL,'',21.000,0.000,NULL,0.000,NULL,223,0,NULL,7.50000000,7.50000000,1672.50000000,351.23000000,0.00000000,0.00000000,2023.73000000,0,0,3),(83,12,NULL,73,1,NULL,'',21.000,0.000,NULL,0.000,NULL,6013.8,0,NULL,0.30000000,0.30000000,1804.14000000,378.87000000,0.00000000,0.00000000,2183.01000000,0,0,4),(84,12,NULL,74,1,NULL,'',21.000,0.000,NULL,0.000,NULL,396,0,NULL,7.50000000,7.50000000,2970.00000000,623.70000000,0.00000000,0.00000000,3593.70000000,0,0,5),(85,12,NULL,75,1,NULL,'',21.000,0.000,NULL,0.000,NULL,5146.8,0,NULL,0.30000000,0.30000000,1544.04000000,324.25000000,0.00000000,0.00000000,1868.29000000,0,0,6),(86,12,NULL,76,1,NULL,'',21.000,0.000,NULL,0.000,NULL,192,0,NULL,7.50000000,7.50000000,1440.00000000,302.40000000,0.00000000,0.00000000,1742.40000000,0,0,7),(87,12,NULL,77,1,NULL,'',21.000,0.000,NULL,0.000,NULL,3505.2,0,NULL,0.30000000,0.30000000,1051.56000000,220.83000000,0.00000000,0.00000000,1272.39000000,0,0,8),(88,12,NULL,78,1,NULL,'',21.000,0.000,NULL,0.000,NULL,515,0,NULL,7.50000000,7.50000000,3862.50000000,811.13000000,0.00000000,0.00000000,4673.63000000,0,0,9),(89,12,NULL,79,1,NULL,'',21.000,0.000,NULL,0.000,NULL,10972,0,NULL,0.30000000,0.30000000,3291.60000000,691.24000000,0.00000000,0.00000000,3982.84000000,0,0,10),(90,12,NULL,80,1,NULL,'',21.000,0.000,NULL,0.000,NULL,945,0,NULL,7.50000000,7.50000000,7087.50000000,1488.38000000,0.00000000,0.00000000,8575.88000000,0,0,11),(91,12,NULL,81,1,NULL,'',21.000,0.000,NULL,0.000,NULL,16374.5,0,NULL,0.30000000,0.30000000,4912.35000000,1031.59000000,0.00000000,0.00000000,5943.94000000,0,0,12),(92,12,NULL,82,1,NULL,'',21.000,0.000,NULL,0.000,NULL,264,0,NULL,7.50000000,7.50000000,1980.00000000,415.80000000,0.00000000,0.00000000,2395.80000000,0,0,13),(93,12,NULL,83,1,NULL,'',21.000,0.000,NULL,0.000,NULL,4518,0,NULL,0.30000000,0.30000000,1355.40000000,284.63000000,0.00000000,0.00000000,1640.03000000,0,0,14),(94,12,NULL,84,1,NULL,'',21.000,0.000,NULL,0.000,NULL,75,0,NULL,7.50000000,7.50000000,562.50000000,118.13000000,0.00000000,0.00000000,680.63000000,0,0,15),(95,12,NULL,86,1,NULL,'',21.000,0.000,NULL,0.000,NULL,3312.6,0,NULL,0.40000000,0.40000000,1325.04000000,278.26000000,0.00000000,0.00000000,1603.30000000,0,0,17),(96,12,NULL,85,1,NULL,'',21.000,0.000,NULL,0.000,NULL,691,0,NULL,0.30000000,0.30000000,207.30000000,43.53000000,0.00000000,0.00000000,250.83000000,0,0,18),(97,13,NULL,87,1,NULL,'',21.000,0.000,NULL,0.000,NULL,4659,0,NULL,0.40000000,0.40000000,1863.60000000,391.36000000,0.00000000,0.00000000,2254.96000000,0,0,2),(98,13,NULL,89,1,NULL,'',21.000,0.000,NULL,0.000,NULL,112,0,NULL,8.00000000,8.00000000,896.00000000,188.16000000,0.00000000,0.00000000,1084.16000000,0,0,3),(99,13,NULL,90,1,NULL,'Organisation Multidoses',21.000,0.000,NULL,0.000,NULL,1,0,NULL,1750.00000000,1750.00000000,1750.00000000,367.50000000,0.00000000,0.00000000,2117.50000000,0,0,4),(100,13,NULL,NULL,1,NULL,'Correction Tournée Ronse01 et ronse02:\r\nLundi à Vendredi : (3 jours x 19 drop x7.5€ drop) + (3 jours x 607,6 km* 0.30€)\r\nCorrection Kinder Vriend \r\n(6 jours x 1drop x 7.5€ )+ (6 jours x 96.6 km x 0.30€)',21.000,0.000,NULL,0.000,NULL,1,0,NULL,780.93000000,780.93000000,780.93000000,164.00000000,0.00000000,0.00000000,944.93000000,0,0,5),(101,13,NULL,NULL,1,NULL,'Multidose KK7, KK8, KK9\r\nKm: 786.5 Km drop: 23',21.000,0.000,NULL,0.000,NULL,1,0,NULL,498.60000000,498.60000000,498.60000000,104.71000000,0.00000000,0.00000000,603.31000000,0,0,6),(102,14,NULL,70,1,NULL,'',21.000,0.000,NULL,0.000,NULL,270,0,NULL,7.50000000,7.50000000,2025.00000000,425.25000000,0.00000000,0.00000000,2450.25000000,0,0,1),(103,14,NULL,71,1,NULL,'',21.000,0.000,NULL,0.000,NULL,4001,0,NULL,0.30000000,0.30000000,1200.30000000,252.06000000,0.00000000,0.00000000,1452.36000000,0,0,2),(104,14,NULL,72,1,NULL,'',21.000,0.000,NULL,0.000,NULL,184,0,NULL,7.50000000,7.50000000,1380.00000000,289.80000000,0.00000000,0.00000000,1669.80000000,0,0,3),(105,14,NULL,73,1,NULL,'',21.000,0.000,NULL,0.000,NULL,4755.4,0,NULL,0.30000000,0.30000000,1426.62000000,299.59000000,0.00000000,0.00000000,1726.21000000,0,0,4),(106,14,NULL,74,1,NULL,'',21.000,0.000,NULL,0.000,NULL,330,0,NULL,7.50000000,7.50000000,2475.00000000,519.75000000,0.00000000,0.00000000,2994.75000000,0,0,5),(107,14,NULL,75,1,NULL,'',21.000,0.000,NULL,0.000,NULL,4289,0,NULL,0.30000000,0.30000000,1286.70000000,270.21000000,0.00000000,0.00000000,1556.91000000,0,0,6),(108,14,NULL,76,1,NULL,'',21.000,0.000,NULL,0.000,NULL,160,0,NULL,7.50000000,7.50000000,1200.00000000,252.00000000,0.00000000,0.00000000,1452.00000000,0,0,7),(109,14,NULL,77,1,NULL,'',21.000,0.000,NULL,0.000,NULL,2921,0,NULL,0.30000000,0.30000000,876.30000000,184.02000000,0.00000000,0.00000000,1060.32000000,0,0,8),(110,14,NULL,78,1,NULL,'',21.000,0.000,NULL,0.000,NULL,356,0,NULL,7.50000000,7.50000000,2670.00000000,560.70000000,0.00000000,0.00000000,3230.70000000,0,0,9),(111,14,NULL,79,1,NULL,'',21.000,0.000,NULL,0.000,NULL,7846,0,NULL,0.30000000,0.30000000,2353.80000000,494.30000000,0.00000000,0.00000000,2848.10000000,0,0,10),(112,14,NULL,80,1,NULL,'',21.000,0.000,NULL,0.000,NULL,781,0,NULL,7.50000000,7.50000000,5857.50000000,1230.08000000,0.00000000,0.00000000,7087.58000000,0,0,11),(113,14,NULL,81,1,NULL,'',21.000,0.000,NULL,0.000,NULL,13486.64,0,NULL,0.30000000,0.30000000,4045.99000000,849.66000000,0.00000000,0.00000000,4895.65000000,0,0,12),(114,14,NULL,82,1,NULL,'',21.000,0.000,NULL,0.000,NULL,220,0,NULL,7.50000000,7.50000000,1650.00000000,346.50000000,0.00000000,0.00000000,1996.50000000,0,0,13),(115,14,NULL,83,1,NULL,'',21.000,0.000,NULL,0.000,NULL,3765,0,NULL,0.30000000,0.30000000,1129.50000000,237.20000000,0.00000000,0.00000000,1366.70000000,0,0,14),(116,14,NULL,84,1,NULL,'',21.000,0.000,NULL,0.000,NULL,60,0,NULL,7.50000000,7.50000000,450.00000000,94.50000000,0.00000000,0.00000000,544.50000000,0,0,15),(117,14,NULL,86,1,NULL,'',21.000,0.000,NULL,0.000,NULL,2540.6,0,NULL,0.40000000,0.40000000,1016.24000000,213.41000000,0.00000000,0.00000000,1229.65000000,0,0,17),(118,14,NULL,85,1,NULL,'',21.000,0.000,NULL,0.000,NULL,691,0,NULL,0.30000000,0.30000000,207.30000000,43.53000000,0.00000000,0.00000000,250.83000000,0,0,18),(119,14,NULL,44,1,NULL,'',0.000,0.000,NULL,0.000,NULL,1,0,NULL,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0,0,19),(138,16,NULL,70,1,NULL,'',21.000,0.000,NULL,0.000,NULL,270,0,NULL,7.50000000,7.50000000,2025.00000000,425.25000000,0.00000000,0.00000000,2450.25000000,0,0,1),(139,16,NULL,71,1,NULL,'',21.000,0.000,NULL,0.000,NULL,4001,0,NULL,0.30000000,0.30000000,1200.30000000,252.06000000,0.00000000,0.00000000,1452.36000000,0,0,2),(140,16,NULL,72,1,NULL,'',21.000,0.000,NULL,0.000,NULL,205,0,NULL,7.50000000,7.50000000,1537.50000000,322.88000000,0.00000000,0.00000000,1860.38000000,0,0,3),(141,16,NULL,73,1,NULL,'',21.000,0.000,NULL,0.000,NULL,4773,0,NULL,0.30000000,0.30000000,1431.90000000,300.70000000,0.00000000,0.00000000,1732.60000000,0,0,4),(142,16,NULL,74,1,NULL,'',21.000,0.000,NULL,0.000,NULL,340,0,NULL,7.50000000,7.50000000,2550.00000000,535.50000000,0.00000000,0.00000000,3085.50000000,0,0,5),(143,16,NULL,75,1,NULL,'',21.000,0.000,NULL,0.000,NULL,4377,0,NULL,0.30000000,0.30000000,1313.10000000,275.75000000,0.00000000,0.00000000,1588.85000000,0,0,6),(144,16,NULL,76,1,NULL,'',21.000,0.000,NULL,0.000,NULL,160,0,NULL,7.50000000,7.50000000,1200.00000000,252.00000000,0.00000000,0.00000000,1452.00000000,0,0,7),(145,16,NULL,77,1,NULL,'',21.000,0.000,NULL,0.000,NULL,3193,0,NULL,0.30000000,0.30000000,957.90000000,201.16000000,0.00000000,0.00000000,1159.06000000,0,0,8),(146,16,NULL,78,1,NULL,'',21.000,0.000,NULL,0.000,NULL,352,0,NULL,7.50000000,7.50000000,2640.00000000,554.40000000,0.00000000,0.00000000,3194.40000000,0,0,9),(147,16,NULL,79,1,NULL,'',21.000,0.000,NULL,0.000,NULL,8696,0,NULL,0.30000000,0.30000000,2608.80000000,547.85000000,0.00000000,0.00000000,3156.65000000,0,0,10),(148,16,NULL,80,1,NULL,'',21.000,0.000,NULL,0.000,NULL,871,0,NULL,7.50000000,7.50000000,6532.50000000,1371.83000000,0.00000000,0.00000000,7904.33000000,0,0,11),(149,16,NULL,81,1,NULL,'',21.000,0.000,NULL,0.000,NULL,15800.6,0,NULL,0.30000000,0.30000000,4740.18000000,995.44000000,0.00000000,0.00000000,5735.62000000,0,0,12),(150,16,NULL,82,1,NULL,'',21.000,0.000,NULL,0.000,NULL,260,0,NULL,7.50000000,7.50000000,1950.00000000,409.50000000,0.00000000,0.00000000,2359.50000000,0,0,13),(151,16,NULL,83,1,NULL,'',21.000,0.000,NULL,0.000,NULL,4136,0,NULL,0.30000000,0.30000000,1240.80000000,260.57000000,0.00000000,0.00000000,1501.37000000,0,0,14),(152,16,NULL,84,1,NULL,'',21.000,0.000,NULL,0.000,NULL,60,0,NULL,7.50000000,7.50000000,450.00000000,94.50000000,0.00000000,0.00000000,544.50000000,0,0,15),(153,16,NULL,86,1,NULL,'',21.000,0.000,NULL,0.000,NULL,2976.75,0,NULL,0.40000000,0.40000000,1190.70000000,250.05000000,0.00000000,0.00000000,1440.75000000,0,0,17),(154,16,NULL,85,1,NULL,'',21.000,0.000,NULL,0.000,NULL,691,0,NULL,0.30000000,0.30000000,207.30000000,43.53000000,0.00000000,0.00000000,250.83000000,0,0,18),(155,16,NULL,44,1,NULL,'',0.000,0.000,NULL,0.000,NULL,1,0,NULL,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0,0,19),(156,17,NULL,70,1,NULL,'',21.000,0.000,NULL,0.000,NULL,297,0,NULL,7.50000000,7.50000000,2227.50000000,467.78000000,0.00000000,0.00000000,2695.28000000,0,0,1),(157,17,NULL,71,1,NULL,'',21.000,0.000,NULL,0.000,NULL,4401.1,0,NULL,0.30000000,0.30000000,1320.33000000,277.27000000,0.00000000,0.00000000,1597.60000000,0,0,2),(158,17,NULL,72,1,NULL,'',21.000,0.000,NULL,0.000,NULL,228,0,NULL,7.50000000,7.50000000,1710.00000000,359.10000000,0.00000000,0.00000000,2069.10000000,0,0,3),(159,17,NULL,73,1,NULL,'',21.000,0.000,NULL,0.000,NULL,5491.8,0,NULL,0.30000000,0.30000000,1647.54000000,345.98000000,0.00000000,0.00000000,1993.52000000,0,0,4),(160,17,NULL,74,1,NULL,'',21.000,0.000,NULL,0.000,NULL,374,0,NULL,7.50000000,7.50000000,2805.00000000,589.05000000,0.00000000,0.00000000,3394.05000000,0,0,5),(161,17,NULL,75,1,NULL,'',21.000,0.000,NULL,0.000,NULL,4814.7,0,NULL,0.30000000,0.30000000,1444.41000000,303.33000000,0.00000000,0.00000000,1747.74000000,0,0,6),(162,17,NULL,76,1,NULL,'',21.000,0.000,NULL,0.000,NULL,176,0,NULL,7.50000000,7.50000000,1320.00000000,277.20000000,0.00000000,0.00000000,1597.20000000,0,0,7),(163,17,NULL,77,1,NULL,'',21.000,0.000,NULL,0.000,NULL,3682.8,0,NULL,0.30000000,0.30000000,1104.84000000,232.02000000,0.00000000,0.00000000,1336.86000000,0,0,8),(164,17,NULL,78,1,NULL,'',21.000,0.000,NULL,0.000,NULL,389,0,NULL,7.50000000,7.50000000,2917.50000000,612.68000000,0.00000000,0.00000000,3530.18000000,0,0,9),(165,17,NULL,79,1,NULL,'',21.000,0.000,NULL,0.000,NULL,9565.9,0,NULL,0.30000000,0.30000000,2869.77000000,602.65000000,0.00000000,0.00000000,3472.42000000,0,0,10),(166,17,NULL,80,1,NULL,'',21.000,0.000,NULL,0.000,NULL,936,0,NULL,7.50000000,7.50000000,7020.00000000,1474.20000000,0.00000000,0.00000000,8494.20000000,0,0,11),(167,17,NULL,81,1,NULL,'',21.000,0.000,NULL,0.000,NULL,16690.4,0,NULL,0.30000000,0.30000000,5007.12000000,1051.50000000,0.00000000,0.00000000,6058.62000000,0,0,12),(168,17,NULL,82,1,NULL,'',21.000,0.000,NULL,0.000,NULL,286,0,NULL,7.50000000,7.50000000,2145.00000000,450.45000000,0.00000000,0.00000000,2595.45000000,0,0,13),(169,17,NULL,83,1,NULL,'',21.000,0.000,NULL,0.000,NULL,4549.6,0,NULL,0.30000000,0.30000000,1364.88000000,286.62000000,0.00000000,0.00000000,1651.50000000,0,0,14),(170,17,NULL,84,1,NULL,'',21.000,0.000,NULL,0.000,NULL,70,0,NULL,7.50000000,7.50000000,525.00000000,110.25000000,0.00000000,0.00000000,635.25000000,0,0,15),(171,17,NULL,86,1,NULL,'',21.000,0.000,NULL,0.000,NULL,3038.9,0,NULL,0.40000000,0.40000000,1215.56000000,255.27000000,0.00000000,0.00000000,1470.83000000,0,0,17),(172,17,NULL,85,1,NULL,'',21.000,0.000,NULL,0.000,NULL,691,0,NULL,0.30000000,0.30000000,207.30000000,43.53000000,0.00000000,0.00000000,250.83000000,0,0,18),(173,17,NULL,44,1,NULL,'',0.000,0.000,NULL,0.000,NULL,1,0,NULL,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0,0,19);

--
-- Table structure for table `am_fichinter`
--

CREATE TABLE `am_fichinter` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_soc` int(11) NOT NULL,
  `fk_projet` int(11) DEFAULT '0',
  `fk_contrat` int(11) DEFAULT '0',
  `ref` varchar(30) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `date_valid` datetime DEFAULT NULL,
  `datei` date DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `fk_statut` smallint(6) DEFAULT '0',
  `duree` double DEFAULT NULL,
  `description` text,
  `note_private` text,
  `note_public` text,
  `model_pdf` varchar(255) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_fichinter_ref` (`ref`,`entity`),
  KEY `idx_fichinter_fk_soc` (`fk_soc`),
  CONSTRAINT `fk_fichinter_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `am_societe` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_fichinter`
--


--
-- Table structure for table `am_fichinter_extrafields`
--

CREATE TABLE `am_fichinter_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) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_ficheinter_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_fichinter_extrafields`
--


--
-- Table structure for table `am_fichinterdet`
--

CREATE TABLE `am_fichinterdet` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_fichinter` int(11) DEFAULT NULL,
  `fk_parent_line` int(11) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `description` text,
  `duree` int(11) DEFAULT NULL,
  `rang` int(11) DEFAULT '0',
  PRIMARY KEY (`rowid`),
  KEY `idx_fichinterdet_fk_fichinter` (`fk_fichinter`),
  CONSTRAINT `fk_fichinterdet_fk_fichinter` FOREIGN KEY (`fk_fichinter`) REFERENCES `am_fichinter` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_fichinterdet`
--


--
-- Table structure for table `am_holiday`
--

CREATE TABLE `am_holiday` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_user` int(11) NOT NULL,
  `date_create` datetime NOT NULL,
  `description` varchar(255) NOT NULL,
  `date_debut` date NOT NULL,
  `date_fin` date NOT NULL,
  `halfday` int(11) DEFAULT '0',
  `statut` int(11) NOT NULL DEFAULT '1',
  `fk_validator` int(11) NOT NULL,
  `date_valid` datetime DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `date_refuse` datetime DEFAULT NULL,
  `fk_user_refuse` int(11) DEFAULT NULL,
  `date_cancel` datetime DEFAULT NULL,
  `fk_user_cancel` int(11) DEFAULT NULL,
  `detail_refuse` varchar(250) DEFAULT NULL,
  `note_private` text,
  `note_public` text,
  `fk_user_create` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_holiday_fk_user` (`fk_user`),
  KEY `idx_holiday_date_debut` (`date_debut`),
  KEY `idx_holiday_date_fin` (`date_fin`),
  KEY `idx_holiday_fk_user_create` (`fk_user_create`),
  KEY `idx_holiday_date_create` (`date_create`),
  KEY `idx_holiday_fk_validator` (`fk_validator`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_holiday`
--


--
-- Table structure for table `am_holiday_config`
--

CREATE TABLE `am_holiday_config` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `value` text,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_holiday_config`
--

INSERT INTO `am_holiday_config` VALUES (1,'userGroup',NULL),(2,'lastUpdate',NULL),(3,'nbUser',NULL),(4,'delayForRequest','31'),(5,'AlertValidatorDelay','0'),(6,'AlertValidatorSolde','0'),(7,'nbHolidayDeducted','1'),(8,'nbHolidayEveryMonth','2.08334');

--
-- Table structure for table `am_holiday_events`
--

CREATE TABLE `am_holiday_events` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `name` varchar(255) NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_holiday_name` (`name`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_holiday_events`
--


--
-- Table structure for table `am_holiday_logs`
--

CREATE TABLE `am_holiday_logs` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `date_action` datetime NOT NULL,
  `fk_user_action` int(11) NOT NULL,
  `fk_user_update` int(11) NOT NULL,
  `type_action` varchar(255) NOT NULL,
  `prev_solde` varchar(255) NOT NULL,
  `new_solde` varchar(255) NOT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_holiday_logs`
--


--
-- Table structure for table `am_holiday_users`
--

CREATE TABLE `am_holiday_users` (
  `fk_user` int(11) NOT NULL,
  `nb_holiday` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`fk_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_holiday_users`
--


--
-- Table structure for table `am_import_model`
--

CREATE TABLE `am_import_model` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_user` int(11) NOT NULL DEFAULT '0',
  `label` varchar(50) NOT NULL,
  `type` varchar(20) NOT NULL,
  `field` text NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_import_model` (`label`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_import_model`
--


--
-- Table structure for table `am_links`
--

CREATE TABLE `am_links` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `datea` datetime NOT NULL,
  `url` varchar(255) NOT NULL,
  `label` varchar(255) NOT NULL,
  `objecttype` varchar(255) NOT NULL,
  `objectid` int(11) NOT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_links`
--


--
-- Table structure for table `am_livraison`
--

CREATE TABLE `am_livraison` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ref` varchar(30) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `fk_soc` int(11) NOT NULL,
  `ref_ext` varchar(30) DEFAULT NULL,
  `ref_int` varchar(30) DEFAULT NULL,
  `ref_customer` varchar(30) DEFAULT NULL,
  `date_creation` datetime DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `date_valid` datetime DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `date_delivery` date DEFAULT NULL,
  `fk_address` int(11) DEFAULT NULL,
  `fk_statut` smallint(6) DEFAULT '0',
  `total_ht` double(24,8) DEFAULT '0.00000000',
  `note_private` text,
  `note_public` text,
  `model_pdf` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `idx_livraison_uk_ref` (`ref`,`entity`),
  KEY `idx_livraison_fk_soc` (`fk_soc`),
  KEY `idx_livraison_fk_user_author` (`fk_user_author`),
  KEY `idx_livraison_fk_user_valid` (`fk_user_valid`),
  CONSTRAINT `fk_livraison_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `am_societe` (`rowid`),
  CONSTRAINT `fk_livraison_fk_user_author` FOREIGN KEY (`fk_user_author`) REFERENCES `am_user` (`rowid`),
  CONSTRAINT `fk_livraison_fk_user_valid` FOREIGN KEY (`fk_user_valid`) REFERENCES `am_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_livraison`
--


--
-- Table structure for table `am_livraisondet`
--

CREATE TABLE `am_livraisondet` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_livraison` int(11) DEFAULT NULL,
  `fk_origin_line` int(11) DEFAULT NULL,
  `fk_product` int(11) DEFAULT NULL,
  `description` text,
  `qty` double DEFAULT NULL,
  `subprice` double(24,8) DEFAULT '0.00000000',
  `total_ht` double(24,8) DEFAULT '0.00000000',
  `rang` int(11) DEFAULT '0',
  PRIMARY KEY (`rowid`),
  KEY `idx_livraisondet_fk_expedition` (`fk_livraison`),
  CONSTRAINT `fk_livraisondet_fk_livraison` FOREIGN KEY (`fk_livraison`) REFERENCES `am_livraison` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_livraisondet`
--


--
-- Table structure for table `am_localtax`
--

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

--
-- Dumping data for table `am_localtax`
--


--
-- Table structure for table `am_mailing`
--

CREATE TABLE `am_mailing` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `statut` smallint(6) DEFAULT '0',
  `titre` varchar(60) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `sujet` varchar(60) DEFAULT NULL,
  `body` mediumtext,
  `bgcolor` varchar(8) DEFAULT NULL,
  `bgimage` varchar(255) DEFAULT NULL,
  `cible` varchar(60) DEFAULT NULL,
  `nbemail` int(11) DEFAULT NULL,
  `email_from` varchar(160) DEFAULT NULL,
  `email_replyto` varchar(160) DEFAULT NULL,
  `email_errorsto` varchar(160) DEFAULT NULL,
  `tag` varchar(128) DEFAULT NULL,
  `date_creat` datetime DEFAULT NULL,
  `date_valid` datetime DEFAULT NULL,
  `date_appro` datetime DEFAULT NULL,
  `date_envoi` datetime DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `fk_user_appro` int(11) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  `joined_file1` varchar(255) DEFAULT NULL,
  `joined_file2` varchar(255) DEFAULT NULL,
  `joined_file3` varchar(255) DEFAULT NULL,
  `joined_file4` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_mailing`
--


--
-- Table structure for table `am_mailing_cibles`
--

CREATE TABLE `am_mailing_cibles` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_mailing` int(11) NOT NULL,
  `fk_contact` int(11) NOT NULL,
  `lastname` varchar(50) DEFAULT NULL,
  `firstname` varchar(50) DEFAULT NULL,
  `email` varchar(160) NOT NULL,
  `other` varchar(255) DEFAULT NULL,
  `tag` varchar(128) DEFAULT NULL,
  `statut` smallint(6) NOT NULL DEFAULT '0',
  `source_url` varchar(160) DEFAULT NULL,
  `source_id` int(11) DEFAULT NULL,
  `source_type` varchar(16) DEFAULT NULL,
  `date_envoi` datetime DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_mailing_cibles` (`fk_mailing`,`email`),
  KEY `idx_mailing_cibles_email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_mailing_cibles`
--


--
-- Table structure for table `am_menu`
--

CREATE TABLE `am_menu` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `menu_handler` varchar(16) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `module` varchar(64) DEFAULT NULL,
  `type` varchar(4) NOT NULL,
  `mainmenu` varchar(100) NOT NULL,
  `leftmenu` varchar(100) DEFAULT NULL,
  `fk_menu` int(11) NOT NULL,
  `fk_mainmenu` varchar(24) DEFAULT NULL,
  `fk_leftmenu` varchar(24) DEFAULT NULL,
  `position` int(11) NOT NULL,
  `url` varchar(255) NOT NULL,
  `target` varchar(100) DEFAULT NULL,
  `titre` varchar(255) NOT NULL,
  `langs` varchar(100) DEFAULT NULL,
  `level` smallint(6) DEFAULT NULL,
  `perms` varchar(255) DEFAULT NULL,
  `enabled` varchar(255) DEFAULT '1',
  `usertype` int(11) NOT NULL DEFAULT '0',
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `idx_menu_uk_menu` (`menu_handler`,`fk_menu`,`position`,`url`,`entity`),
  KEY `idx_menu_menuhandler_type` (`menu_handler`,`type`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_menu`
--

INSERT INTO `am_menu` VALUES (5,'all',1,'margin','left','accountancy','margins',-1,'accountancy',NULL,100,'/margin/index.php','','Margins','margins',NULL,'1','$conf->margin->enabled',2,'2013-06-15 20:20:32'),(6,'all',1,'ecm','top','ecm',NULL,0,NULL,NULL,100,'/ecm/index.php','','MenuECM','ecm',NULL,'$user->rights->ecm->read || $user->rights->ecm->upload || $user->rights->ecm->setup','$conf->ecm->enabled',2,'2015-04-05 21:11:19'),(7,'all',1,'ecm','left','ecm','ecm',-1,'ecm',NULL,101,'/ecm/index.php?mainmenu=ecm&leftmenu=ecm','','ECMArea','ecm',NULL,'$user->rights->ecm->read || $user->rights->ecm->upload','$user->rights->ecm->read || $user->rights->ecm->upload',2,'2015-04-05 21:11:19'),(8,'all',1,'ecm','left','ecm','ecm_manual',-1,'ecm','ecm',102,'/ecm/index.php?action=file_manager&mainmenu=ecm&leftmenu=ecm','','ECMSectionsManual','ecm',NULL,'$user->rights->ecm->read || $user->rights->ecm->upload','$user->rights->ecm->read || $user->rights->ecm->upload',2,'2015-04-05 21:11:19'),(9,'all',1,'ecm','left','ecm',NULL,-1,'ecm','ecm',103,'/ecm/index_auto.php?action=file_manager&mainmenu=ecm&leftmenu=ecm','','ECMSectionsAuto','ecm',NULL,'$user->rights->ecm->read || $user->rights->ecm->upload','$user->rights->ecm->read || $user->rights->ecm->upload',2,'2015-04-05 21:11:19');

--
-- Table structure for table `am_notify`
--

CREATE TABLE `am_notify` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `daten` datetime DEFAULT NULL,
  `fk_action` int(11) NOT NULL,
  `fk_contact` int(11) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `objet_type` varchar(24) NOT NULL,
  `objet_id` int(11) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_notify`
--


--
-- Table structure for table `am_notify_def`
--

CREATE TABLE `am_notify_def` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` date DEFAULT NULL,
  `fk_action` int(11) NOT NULL,
  `fk_soc` int(11) NOT NULL,
  `fk_contact` int(11) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `type` varchar(16) DEFAULT 'email',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_notify_def`
--


--
-- Table structure for table `am_opensurvey_comments`
--

CREATE TABLE `am_opensurvey_comments` (
  `id_comment` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_sondage` char(16) NOT NULL,
  `comment` text NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `usercomment` text,
  PRIMARY KEY (`id_comment`),
  KEY `idx_id_comment` (`id_comment`),
  KEY `idx_id_sondage` (`id_sondage`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_opensurvey_comments`
--


--
-- Table structure for table `am_opensurvey_sondage`
--

CREATE TABLE `am_opensurvey_sondage` (
  `id_sondage` varchar(16) NOT NULL,
  `id_sondage_admin` char(24) DEFAULT NULL,
  `commentaires` text,
  `mail_admin` varchar(128) DEFAULT NULL,
  `nom_admin` varchar(64) DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `titre` text NOT NULL,
  `date_fin` datetime NOT NULL,
  `format` varchar(2) NOT NULL,
  `mailsonde` tinyint(4) NOT NULL DEFAULT '0',
  `survey_link_visible` int(11) DEFAULT '1',
  `canedit` int(11) DEFAULT '0',
  `origin` varchar(64) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `sujet` text,
  `entity` int(11) NOT NULL DEFAULT '1',
  `allow_comments` tinyint(4) NOT NULL DEFAULT '1',
  `allow_spy` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_sondage`),
  KEY `idx_id_sondage_admin` (`id_sondage_admin`),
  KEY `idx_date_fin` (`date_fin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_opensurvey_sondage`
--


--
-- Table structure for table `am_opensurvey_user_studs`
--

CREATE TABLE `am_opensurvey_user_studs` (
  `id_users` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(64) NOT NULL,
  `id_sondage` varchar(16) NOT NULL,
  `reponses` varchar(100) NOT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_users`),
  KEY `idx_opensurvey_user_studs_id_users` (`id_users`),
  KEY `idx_opensurvey_user_studs_nom` (`nom`),
  KEY `idx_opensurvey_user_studs_id_sondage` (`id_sondage`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_opensurvey_user_studs`
--


--
-- Table structure for table `am_paiement`
--

CREATE TABLE `am_paiement` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datep` datetime DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  `fk_paiement` int(11) NOT NULL,
  `num_paiement` varchar(50) DEFAULT NULL,
  `note` text,
  `fk_bank` int(11) NOT NULL DEFAULT '0',
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `statut` smallint(6) NOT NULL DEFAULT '0',
  `fk_export_compta` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=272 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_paiement`
--

INSERT INTO `am_paiement` VALUES (1,1,'2013-07-12 20:23:55','2013-07-12 16:23:55','2013-03-31 12:00:00',5354.25000000,4,'','',2,2,NULL,0,0),(2,1,'2013-07-12 20:42:47','2013-07-12 16:42:47','2013-06-30 12:00:00',4900.50000000,4,'','',3,2,NULL,0,0),(3,1,'2014-01-17 16:55:04','2014-01-17 12:55:05','2014-01-16 12:00:00',1051112.44000000,2,'','',4,4,NULL,0,0),(4,1,'2014-01-17 16:56:34','2014-01-17 12:56:34','2014-01-16 12:00:00',0.30000000,2,'','',5,4,NULL,0,0),(5,1,'2014-01-20 13:16:00','2014-01-20 09:16:00','2013-01-07 12:00:00',22723.80000000,2,'','ref 12/088',6,5,NULL,0,0),(6,1,'2014-01-20 13:16:31','2014-01-20 09:16:31','2013-01-07 12:00:00',24512.20000000,2,'','',7,5,NULL,0,0),(7,1,'2014-01-20 13:26:12','2014-01-20 09:26:12','2013-01-14 12:00:00',20501.98000000,2,'','ref 95/97',8,5,NULL,0,0),(8,1,'2014-01-20 13:27:02','2014-01-20 09:27:02','2013-01-21 12:00:00',20830.15000000,2,'','ref 96 ',9,5,NULL,0,0),(9,1,'2014-01-20 13:27:28','2014-01-20 09:27:28','2013-02-04 12:00:00',18936.50000000,2,'','',10,5,NULL,0,0),(10,1,'2014-01-20 13:27:59','2014-01-20 09:27:59','2013-02-11 12:00:00',19299.50000000,2,'','',11,5,NULL,0,0),(11,1,'2014-01-20 13:28:23','2014-01-20 09:28:23','2013-01-18 12:00:00',19057.50000000,2,'','',12,5,NULL,0,0),(12,1,'2014-01-20 13:28:44','2014-01-20 09:28:44','2013-02-25 12:00:00',19057.50000000,2,'','',13,5,NULL,0,0),(13,1,'2014-01-20 13:29:09','2014-01-20 09:29:10','2013-03-04 12:00:00',18593.34000000,2,'','',14,5,NULL,0,0),(14,1,'2014-01-20 13:30:37','2014-01-20 09:30:37','2013-03-18 12:00:00',28092.28000000,2,'','',15,5,NULL,0,0),(15,1,'2014-12-15 13:53:27','2014-12-15 09:53:27','2014-12-15 12:00:00',4416.50000000,2,'','',4,4,NULL,0,0),(16,1,'2014-12-15 13:54:59','2014-12-15 09:54:59','2014-12-15 12:00:00',423.50000000,2,'','',5,4,NULL,0,0),(17,1,'2015-02-05 15:37:53','2015-02-05 11:37:53','2015-02-05 12:00:00',1324.08000000,2,'','',6,4,NULL,0,0),(18,1,'2015-02-18 12:56:08','2015-02-18 08:56:08','2014-10-08 12:00:00',26765.00000000,2,'','',7,3,NULL,0,0),(19,1,'2015-02-18 12:58:22','2015-02-18 08:58:22','2015-02-02 12:00:00',25370.07000000,2,'','',8,3,NULL,0,0),(20,1,'2015-02-18 13:01:41','2015-02-18 09:01:41','2015-02-01 12:00:00',1210.00000000,2,'','',9,3,NULL,0,0),(21,1,'2015-02-18 13:02:42','2015-02-18 09:02:42','2015-02-18 12:00:00',1203.71000000,2,'','',10,3,NULL,0,0),(22,1,'2015-02-18 13:16:03','2015-02-18 09:16:03','2014-06-11 12:00:00',10393.90000000,2,'','',11,3,NULL,0,0),(23,1,'2015-02-18 13:16:35','2015-02-18 09:16:35','2015-02-02 12:00:00',23340.90000000,2,'','',12,3,NULL,0,0),(24,1,'2015-02-18 13:17:07','2015-02-18 09:17:07','2014-03-04 12:00:00',968.00000000,2,'','',13,3,NULL,0,0),(25,1,'2015-02-18 13:17:39','2015-02-18 09:17:39','2014-02-05 12:00:00',1258.40000000,2,'','',14,3,NULL,0,0),(26,1,'2015-02-18 13:18:03','2015-02-18 09:18:03','2014-02-06 12:00:00',1452.00000000,2,'','',15,3,NULL,0,0),(27,1,'2015-02-18 13:18:36','2015-02-18 09:18:36','2014-08-04 12:00:00',484.00000000,2,'','',16,3,NULL,0,0),(28,1,'2015-02-18 13:19:00','2015-02-18 09:19:00','2015-02-17 12:00:00',242.00000000,4,'','',17,3,NULL,0,0),(29,1,'2015-02-18 13:20:32','2015-02-18 09:20:32','2014-11-05 12:00:00',0.20000000,2,'','',18,3,NULL,0,0),(30,1,'2015-02-18 13:25:56','2015-02-18 09:25:56','2015-02-18 12:00:00',114293.95000000,2,'','',19,3,NULL,0,0),(31,1,'2015-02-18 13:33:51','2015-02-18 09:33:51','2015-02-18 12:00:00',1013209.09000000,2,'','',20,3,NULL,0,0),(32,1,'2015-02-18 13:35:36','2015-02-18 09:35:36','2015-02-18 12:00:00',-433809.85000000,2,'','',21,3,NULL,0,0),(33,1,'2015-02-19 13:48:27','2015-02-19 09:48:27','2015-02-19 12:00:00',605.00000000,2,'','',22,3,NULL,0,0),(34,1,'2015-02-19 17:59:00','2015-02-19 13:59:00','2015-02-19 12:00:00',4934.57000000,2,'','',23,3,NULL,0,0),(35,1,'2015-02-19 17:59:35','2015-02-19 13:59:35','2015-02-19 12:00:00',40864.76000000,2,'','',24,3,NULL,0,0),(36,1,'2015-02-19 18:01:28','2015-02-19 14:01:29','2015-02-19 12:00:00',41023.56000000,2,'','',25,3,NULL,0,0),(37,1,'2015-02-19 18:02:39','2015-02-19 14:02:39','2015-02-19 12:00:00',4934.57000000,2,'','',26,3,NULL,0,0),(38,1,'2015-02-19 18:04:01','2015-02-19 14:04:01','2015-02-19 12:00:00',484.00000000,4,'','',27,3,NULL,0,0),(39,1,'2015-02-19 18:05:01','2015-02-19 14:05:01','2015-02-19 12:00:00',40652.40000000,2,'','',28,3,NULL,0,0),(40,1,'2015-02-19 18:05:30','2015-02-19 14:05:30','2015-02-19 12:00:00',49891.91000000,2,'','',29,3,NULL,0,0),(41,1,'2015-02-19 18:06:15','2015-02-19 14:06:15','2015-02-19 12:00:00',44650.94000000,2,'','',30,3,NULL,0,0),(42,1,'2015-02-19 18:07:26','2015-02-19 14:07:26','2015-02-19 12:00:00',4938.11000000,2,'','',31,3,NULL,0,0),(43,1,'2015-02-19 18:08:09','2015-02-19 14:08:10','2015-02-19 12:00:00',4022.86000000,2,'','',32,3,NULL,0,0),(44,1,'2015-02-19 18:09:01','2015-02-19 14:09:01','2015-02-19 12:00:00',49754.63000000,2,'','',33,3,NULL,0,0),(45,1,'2015-02-19 18:10:07','2015-02-19 14:10:07','2015-02-19 12:00:00',90260.21000000,2,'','',34,3,NULL,0,0),(46,1,'2015-02-19 18:11:11','2015-02-19 14:11:11','2015-02-19 12:00:00',99124.13000000,2,'','',35,3,NULL,0,0),(47,1,'2015-02-19 18:14:32','2015-02-19 14:14:32','2015-02-19 12:00:00',7042.00000000,2,'','',36,3,NULL,0,0),(48,1,'2015-02-19 18:18:11','2015-02-19 14:18:11','2015-02-19 12:00:00',30601.03000000,2,'','',37,3,NULL,0,0),(49,1,'2015-02-23 18:13:49','2015-02-23 14:13:49','2015-02-23 12:00:00',12097.73000000,2,'','',38,3,NULL,0,0),(50,1,'2015-02-23 18:30:32','2015-02-23 14:30:32','2015-02-23 12:00:00',12320.92000000,2,'','',39,3,NULL,0,0),(51,1,'2015-03-02 14:11:43','2015-03-02 10:11:43','2015-03-02 12:00:00',1203.71000000,2,'','',40,3,NULL,0,0),(52,1,'2015-03-05 17:33:51','2015-03-05 13:33:51','2015-03-05 12:00:00',4971.02000000,2,'','',41,3,NULL,0,0),(53,1,'2015-03-19 15:00:36','2015-03-19 11:00:36','2015-03-18 12:00:00',1936.00000000,2,'','',42,3,NULL,0,0),(54,1,'2015-03-25 13:53:41','2015-03-25 09:53:41','2015-03-25 12:00:00',1203.71000000,2,'','',43,3,NULL,0,0),(55,1,'2015-04-24 11:28:10','2015-04-24 07:28:10','2015-04-23 12:00:00',1553.35000000,2,'','',44,3,NULL,0,0),(56,1,'2015-04-24 13:37:37','2015-04-24 09:37:37','2015-04-02 12:00:00',6993.80000000,2,'','',45,3,NULL,0,0),(57,1,'2015-04-24 13:38:23','2015-04-24 09:38:23','2015-04-01 12:00:00',41052.21000000,2,'','',46,3,NULL,0,0),(58,1,'2015-04-24 13:39:03','2015-04-24 09:39:03','2015-04-05 12:00:00',41212.08000000,2,'','',47,3,NULL,0,0),(59,1,'2015-04-24 13:40:02','2015-04-24 09:40:02','2015-04-20 12:00:00',45715.24000000,2,'','',48,3,NULL,0,0),(60,1,'2015-04-24 13:47:22','2015-04-24 09:47:22','2015-04-01 12:00:00',2420.00000000,2,'','',49,3,NULL,0,0),(61,1,'2015-04-24 13:47:54','2015-04-24 09:47:54','2015-04-01 12:00:00',2420.00000000,4,'','',50,3,NULL,0,0),(62,1,'2015-05-07 11:11:53','2015-05-07 07:11:53','2015-05-06 12:00:00',6776.00000000,2,'','',51,3,NULL,0,0),(63,1,'2015-06-01 15:56:16','2015-06-01 11:56:16','2015-06-08 12:00:00',1295.73000000,2,'','',52,3,NULL,0,0),(64,1,'2015-06-01 15:57:37','2015-06-01 11:57:37','2015-05-08 12:00:00',705.31000000,2,'','',53,3,NULL,0,0),(65,1,'2015-06-02 15:00:22','2015-06-02 11:00:22','2015-06-01 12:00:00',5203.00000000,2,'','',54,3,NULL,0,0),(66,1,'2015-06-16 11:24:30','2015-06-16 07:24:30','2015-06-15 12:00:00',5977.40000000,2,'','',55,3,NULL,0,0),(67,1,'2015-06-18 11:51:29','2015-06-18 07:51:29','2015-06-18 12:00:00',1060.14000000,2,'','',56,3,NULL,0,0),(68,1,'2015-06-18 11:54:14','2015-06-18 07:54:14','2015-06-03 12:00:00',1177.94000000,2,'','',57,3,NULL,0,0),(69,1,'2015-08-27 12:45:54','2015-08-27 08:45:54','2015-07-07 12:00:00',1413.52000000,2,'','',58,3,NULL,0,0),(70,1,'2015-08-27 12:48:15','2015-08-27 08:48:15','2015-06-23 12:00:00',1060.14000000,2,'','',59,3,NULL,0,0),(71,1,'2015-08-27 12:49:01','2015-08-27 08:49:01','2015-06-23 12:00:00',1203.71000000,2,'','',60,3,NULL,0,0),(72,1,'2015-09-01 11:38:26','2015-09-01 07:38:26','2015-09-01 12:00:00',1295.73000000,2,'','',61,3,NULL,0,0),(73,1,'2015-09-15 10:34:19','2015-09-15 06:34:19','2015-04-30 12:00:00',53042.20000000,2,'','',62,3,NULL,0,0),(74,1,'2015-09-15 10:37:18','2015-09-15 06:37:19','2015-09-10 12:00:00',191096.60000000,2,'','',63,3,NULL,0,0),(75,1,'2015-09-16 12:15:29','2015-09-16 08:15:29','2015-09-16 12:00:00',2541.43000000,2,'','',64,3,NULL,0,0),(76,1,'2015-09-25 10:46:58','2015-09-25 06:46:58','2015-09-16 12:00:00',18343.60000000,2,'','',65,3,NULL,0,0),(77,1,'2015-09-30 13:23:01','2015-09-30 09:23:01','2015-09-29 12:00:00',1295.73000000,2,'','',66,3,NULL,0,0),(78,1,'2015-09-30 13:24:23','2015-09-30 09:24:23','2015-07-07 12:00:00',39420.73000000,2,'','',67,3,NULL,0,0),(79,1,'2015-09-30 13:25:15','2015-09-30 09:25:15','2015-08-04 12:00:00',106087.92000000,2,'','',68,3,NULL,0,0),(80,1,'2015-09-30 13:27:42','2015-09-30 09:27:43','2015-08-31 12:00:00',73692.97000000,2,'','',69,3,NULL,0,0),(81,1,'2015-10-06 15:21:57','2015-10-06 11:21:57','2015-10-01 12:00:00',25383.00000000,2,'','',70,3,NULL,0,0),(82,1,'2015-10-06 15:22:15','2015-10-06 11:22:15','2015-10-02 12:00:00',10000.00000000,2,'','',71,3,NULL,0,0),(83,1,'2015-10-06 15:22:29','2015-10-06 11:22:29','2015-10-06 12:00:00',20000.00000000,2,'','',72,3,NULL,0,0),(84,1,'2015-10-26 14:10:48','2015-10-26 10:10:48','2015-10-13 12:00:00',20000.00000000,2,'','',73,3,NULL,0,0),(85,1,'2015-10-26 14:14:35','2015-10-26 10:14:35','2015-10-26 12:00:00',20000.00000000,2,'','',74,3,NULL,0,0),(86,1,'2015-11-16 15:16:06','2015-11-16 11:16:06','2015-10-27 12:00:00',17510.00000000,2,'','',75,3,NULL,0,0),(89,1,'2015-11-16 15:19:58','2015-11-16 11:19:58','2015-11-13 12:00:00',544.50000000,4,'','',78,3,NULL,0,0),(92,1,'2015-11-18 12:15:28','2015-11-18 08:15:28','2015-11-09 12:00:00',20000.00000000,2,'','',81,3,NULL,0,0),(93,1,'2015-11-18 12:15:45','2015-11-18 08:15:45','2015-11-16 12:00:00',40000.00000000,2,'','',82,3,NULL,0,0),(94,1,'2015-11-18 12:16:00','2015-11-18 08:16:00','2015-11-18 12:00:00',13000.00000000,2,'','',83,3,NULL,0,0),(95,1,'2015-12-14 22:28:34','2015-12-14 18:28:34','2015-12-08 12:00:00',96276.80000000,2,'','',84,3,NULL,0,0),(96,1,'2015-12-14 22:32:53','2015-12-14 18:32:53','2015-12-14 12:00:00',4295.50000000,2,'','',85,3,NULL,0,0),(97,1,'2015-12-30 14:49:54','2015-12-30 10:49:54','2015-12-30 12:00:00',1721.93000000,2,'','',86,3,NULL,0,0),(98,1,'2016-01-01 02:07:43','2015-12-31 22:07:44','2015-12-30 12:00:00',10914.20000000,2,'','',87,3,NULL,0,0),(99,1,'2016-01-01 02:12:56','2015-12-31 22:12:56','2015-12-29 12:00:00',25000.00000000,2,'','',88,3,NULL,0,0),(100,1,'2016-01-01 02:15:32','2015-12-31 22:15:33','2016-01-01 12:00:00',20199.01000000,2,'','',89,3,NULL,0,0),(101,1,'2016-01-01 02:20:26','2015-12-31 22:20:26','2015-12-31 12:00:00',1291.45000000,2,'','',90,3,NULL,0,0),(102,1,'2016-01-06 23:39:01','2016-01-06 19:39:01','2016-01-06 12:00:00',1295.73000000,2,'','',91,3,NULL,0,0),(103,1,'2016-01-06 23:40:03','2016-01-06 19:40:04','2016-01-04 12:00:00',1295.73000000,2,'','',92,3,NULL,0,0),(104,1,'2016-01-06 23:41:33','2016-01-06 19:41:33','2016-01-02 12:00:00',7986.00000000,2,'','',93,3,NULL,0,0),(105,1,'2016-01-15 17:02:06','2016-01-15 13:02:06','2016-01-12 12:00:00',26000.00000000,2,'','',94,3,NULL,0,0),(106,1,'2016-01-15 17:06:28','2016-01-15 13:06:28','2016-01-15 12:00:00',26199.01000000,2,'','',95,3,NULL,0,0),(107,1,'2016-01-15 17:14:36','2016-01-15 13:14:37','2016-01-11 12:00:00',4050.80000000,2,'','',96,3,NULL,0,0),(108,1,'2016-01-30 16:48:22','2016-01-30 12:48:22','2016-01-21 12:00:00',5000.00000000,2,'','',97,3,NULL,0,0),(109,1,'2016-01-30 16:49:31','2016-01-30 12:49:31','2016-01-26 12:00:00',15000.00000000,2,'','',98,3,NULL,0,0),(110,1,'2016-01-30 16:57:26','2016-01-30 12:57:26','2016-01-30 12:00:00',3000.00000000,2,'','',99,3,NULL,0,0),(111,1,'2016-02-02 12:35:53','2016-02-02 08:35:53','2016-02-02 12:00:00',4320.00000000,2,'','',100,3,NULL,0,0),(112,1,'2016-02-03 22:15:53','2016-02-03 18:15:53','2016-02-01 12:00:00',5000.00000000,2,'','',101,3,NULL,0,0),(113,1,'2016-02-15 17:39:30','2016-02-15 13:39:30','2016-02-15 12:00:00',20000.00000000,2,'','',102,3,NULL,0,0),(114,1,'2016-02-19 11:44:32','2016-02-19 07:44:32','2016-02-17 12:00:00',15000.00000000,2,'','',103,3,NULL,0,0),(115,1,'2016-02-24 23:26:42','2016-02-24 19:26:42','2016-02-24 12:00:00',22320.00000000,2,'','',104,3,NULL,0,0),(116,1,'2016-02-25 01:36:59','2016-02-24 21:36:59','2016-02-10 12:00:00',49434.79000000,2,'','',105,3,NULL,0,0),(117,1,'2016-02-25 01:38:33','2016-02-24 21:38:33','2016-02-10 12:00:00',565.21000000,2,'','',106,3,NULL,0,0),(118,1,'2016-02-25 01:46:49','2016-02-24 21:46:49','2016-01-13 12:00:00',1934.86000000,2,'','',107,3,NULL,0,0),(119,1,'2016-03-03 14:28:17','2016-03-03 10:28:17','2016-02-28 12:00:00',5000.00000000,2,'','',108,3,NULL,0,0),(120,1,'2016-03-08 00:38:55','2016-03-07 20:38:55','2016-03-07 12:00:00',1452.00000000,4,'','',109,3,NULL,0,0),(121,1,'2016-03-08 15:44:58','2016-03-08 11:44:58','2016-03-08 12:00:00',20000.00000000,2,'','',110,3,NULL,0,0),(122,1,'2016-03-08 15:45:34','2016-03-08 11:45:34','2016-03-08 12:00:00',682.00000000,2,'','',111,3,NULL,0,0),(123,1,'2016-03-08 20:16:45','2016-03-08 16:16:46','2016-03-01 12:00:00',1396.79000000,2,'','',112,3,NULL,0,0),(124,1,'2016-03-08 20:19:53','2016-03-08 16:19:53','2016-03-01 12:00:00',25157.56000000,2,'','',113,3,NULL,0,0),(125,1,'2016-03-10 13:48:44','2016-03-10 09:48:44','2016-03-10 12:00:00',1898.56000000,2,'','',114,3,NULL,0,0),(126,1,'2016-03-20 19:03:53','2016-03-20 15:03:53','2016-03-16 12:00:00',16867.40000000,2,'','',115,3,NULL,0,0),(127,1,'2016-03-20 19:14:28','2016-03-20 15:14:28','2016-03-15 12:00:00',1291.45000000,2,'','',116,3,NULL,0,0),(128,1,'2016-03-24 19:49:16','2016-03-24 15:49:17','2016-03-24 12:00:00',1697.03000000,2,'','',117,3,NULL,0,0),(129,1,'2016-03-24 19:50:31','2016-03-24 15:50:31','2016-03-23 12:00:00',22000.00000000,2,'','',118,3,NULL,0,0),(130,1,'2016-04-15 23:44:09','2016-04-15 19:44:09','2016-04-08 12:00:00',24532.30000000,2,'','',119,3,NULL,0,0),(131,1,'2016-04-18 19:55:57','2016-04-18 15:55:57','2016-04-05 12:00:00',25000.00000000,2,'','',120,3,NULL,0,0),(132,1,'2016-04-18 19:56:30','2016-04-18 15:56:30','2016-04-11 12:00:00',25000.00000000,2,'','',121,3,NULL,0,0),(133,1,'2016-04-18 20:04:45','2016-04-18 16:04:45','2016-04-18 12:00:00',36320.75000000,2,'','',122,3,NULL,0,0),(134,1,'2016-04-18 20:08:14','2016-04-18 16:08:14','2016-04-06 12:00:00',1866.73000000,2,'','',123,3,NULL,0,0),(135,1,'2016-04-18 20:14:50','2016-04-18 16:14:50','2016-03-31 12:00:00',1697.03000000,2,'','',124,3,NULL,0,0),(136,1,'2016-04-25 12:35:02','2016-04-25 08:35:02','2016-04-25 12:00:00',1784.36000000,2,'','',125,4,NULL,0,0),(137,1,'2016-05-02 12:54:11','2016-05-02 08:54:11','2016-05-02 12:00:00',20000.00000000,2,'','',126,3,NULL,0,0),(138,1,'2016-05-13 00:51:49','2016-05-12 20:51:49','2016-05-09 12:00:00',20000.00000000,2,'','',127,3,NULL,0,0),(139,1,'2016-05-13 00:54:55','2016-05-12 20:54:55','2016-05-10 12:00:00',18033.84000000,2,'','',128,3,NULL,0,0),(140,1,'2016-05-18 15:44:27','2016-05-18 11:44:27','2016-04-07 12:00:00',9050.00000000,2,'','',129,3,NULL,0,0),(141,1,'2016-05-18 15:45:01','2016-05-18 11:45:01','2016-04-07 12:00:00',0.80000000,2,'','',130,3,NULL,0,0),(142,1,'2016-05-31 21:51:02','2016-05-31 17:51:02','2016-05-31 12:00:00',12364.99000000,2,'','',131,3,NULL,0,0),(143,1,'2016-05-31 21:53:35','2016-05-31 17:53:35','2016-05-23 12:00:00',15144.00000000,2,'','',132,3,NULL,0,0),(144,1,'2016-06-14 15:42:46','2016-06-14 11:42:46','2016-06-01 12:00:00',20000.00000000,2,'','',133,3,NULL,0,0),(145,1,'2016-06-14 15:44:03','2016-06-14 11:44:03','2016-06-03 12:00:00',20000.00000000,2,'','',134,3,NULL,0,0),(146,1,'2016-06-14 15:46:02','2016-06-14 11:46:03','2016-06-08 12:00:00',20849.50000000,2,'','',135,3,NULL,0,0),(147,1,'2016-06-15 11:14:49','2016-06-15 07:14:49','2016-06-15 12:00:00',4804.38000000,2,'','',136,3,NULL,0,0),(148,1,'2016-06-17 01:26:13','2016-06-16 21:26:14','2016-06-16 12:00:00',15000.00000000,2,'','',137,3,NULL,0,0),(149,1,'2016-06-22 13:12:10','2016-06-22 09:12:10','2016-06-22 12:00:00',5000.00000000,2,'','',138,3,NULL,0,0),(150,1,'2016-06-24 13:40:32','2016-06-24 09:40:32','2016-06-24 12:00:00',10000.00000000,2,'','',139,3,NULL,0,0),(151,1,'2016-06-24 13:42:36','2016-06-24 09:42:36','2016-06-24 12:00:00',3097.16000000,2,'','',140,3,NULL,0,0),(152,1,'2016-06-24 14:52:40','2016-06-24 10:52:40','2016-06-24 12:00:00',5000.00000000,2,'','',141,3,NULL,0,0),(153,1,'2016-06-30 21:38:30','2016-06-30 17:38:30','2016-06-30 12:00:00',17482.69000000,2,'','',142,3,NULL,0,0),(154,1,'2016-07-01 14:17:57','2016-07-01 10:17:57','2016-07-01 12:00:00',20000.00000000,2,'','',143,3,NULL,0,0),(155,1,'2016-07-06 15:03:47','2016-07-06 11:03:47','2016-07-06 12:00:00',10000.00000000,2,'','',144,3,NULL,0,0),(156,1,'2016-07-11 13:30:55','2016-07-11 09:30:55','2016-07-11 12:00:00',11367.10000000,2,'','',145,3,NULL,0,0),(157,1,'2016-07-18 19:13:23','2016-07-18 15:13:23','2016-07-18 12:00:00',1842.19000000,2,'','',146,3,NULL,0,0),(158,1,'2016-07-18 19:17:00','2016-07-18 15:17:00','2016-07-05 12:00:00',13146.65000000,2,'','',147,3,NULL,0,0),(159,1,'2016-07-18 19:22:22','2016-07-18 15:22:22','2016-07-12 12:00:00',3478.12000000,2,'','',148,3,NULL,0,0),(160,1,'2016-07-25 13:19:32','2016-07-25 09:19:32','2016-07-25 12:00:00',20000.00000000,2,'','',149,3,NULL,0,0),(161,1,'2016-07-26 23:53:42','2016-07-26 19:53:42','2016-07-20 12:00:00',2480.50000000,2,'','',150,3,NULL,0,0),(162,1,'2016-08-09 09:53:34','2016-08-09 05:53:34','2016-08-08 12:00:00',13842.40000000,2,'','',151,3,NULL,0,0),(163,1,'2016-08-09 09:55:00','2016-08-09 05:55:00','2016-08-04 12:00:00',38000.00000000,2,'','',152,3,NULL,0,0),(164,1,'2016-08-09 09:55:50','2016-08-09 05:55:50','2016-08-02 12:00:00',2000.00000000,2,'','',153,3,NULL,0,0),(165,1,'2016-08-09 09:57:56','2016-08-09 05:57:56','2016-08-09 12:00:00',15000.00000000,2,'','',154,3,NULL,0,0),(166,1,'2016-08-09 10:00:12','2016-08-09 06:00:13','2016-08-09 12:00:00',5000.00000000,2,'','',155,3,NULL,0,0),(167,1,'2016-08-10 11:14:38','2016-08-10 07:14:38','2016-08-10 12:00:00',1842.19000000,2,'','',156,3,NULL,0,0),(168,1,'2016-08-15 19:51:54','2016-08-15 15:51:54','2016-08-16 12:00:00',40000.00000000,2,'','',157,3,NULL,0,0),(169,1,'2016-08-22 13:51:42','2016-08-22 09:51:42','2016-08-19 12:00:00',1210.00000000,2,'','',158,3,NULL,0,0),(170,1,'2016-08-22 13:52:45','2016-08-22 09:52:45','2016-08-19 12:00:00',13203.52000000,2,'','',159,3,NULL,0,0),(171,1,'2016-08-25 13:20:38','2016-08-25 09:20:38','2016-08-25 12:00:00',10000.00000000,2,'','',160,3,NULL,0,0),(172,1,'2016-09-11 18:01:59','2016-09-11 14:01:59','2016-09-06 12:00:00',42999.39000000,2,'','',161,3,NULL,0,0),(173,1,'2016-09-13 16:59:00','2016-09-13 12:59:00','2016-09-12 12:00:00',1718.20000000,2,'','',162,3,NULL,0,0),(174,1,'2016-09-13 17:00:33','2016-09-13 13:00:33','2016-09-12 12:00:00',6709.04000000,2,'','',163,3,NULL,0,0),(175,1,'2016-09-13 17:02:13','2016-09-13 13:02:13','2016-09-12 12:00:00',2032.55000000,2,'','',164,3,NULL,0,0),(176,1,'2016-09-16 10:45:29','2016-09-16 06:45:29','2016-09-16 12:00:00',42661.80000000,2,'','',165,3,NULL,0,0),(177,1,'2016-09-28 19:56:02','2016-09-28 15:56:02','2016-09-28 12:00:00',20000.00000000,2,'','',166,3,NULL,0,0),(178,1,'2016-09-28 19:57:37','2016-09-28 15:57:37','2016-09-20 12:00:00',5000.00000000,2,'','',167,3,NULL,0,0),(179,1,'2016-10-11 19:46:58','2016-10-11 15:46:58','2016-10-10 12:00:00',52507.20000000,2,'','',168,3,NULL,0,0),(180,1,'2016-11-01 00:50:43','2016-10-31 20:50:43','2016-10-20 12:00:00',3868.12000000,2,'','',169,3,NULL,0,0),(181,1,'2016-11-01 01:00:50','2016-10-31 21:00:50','2016-10-21 12:00:00',30000.00000000,2,'','',170,3,NULL,0,0),(182,1,'2016-11-01 01:02:31','2016-10-31 21:02:31','2016-10-12 12:00:00',15000.00000000,2,'','',171,3,NULL,0,0),(183,1,'2016-11-01 01:12:44','2016-10-31 21:12:44','2016-10-04 12:00:00',10514.90000000,2,'','',172,3,NULL,0,0),(184,1,'2016-11-06 20:41:04','2016-11-06 16:41:04','2016-11-02 12:00:00',30985.68000000,2,'','',173,3,NULL,0,0),(185,1,'2016-11-10 16:56:24','2016-11-10 12:56:24','2016-11-09 12:00:00',3255.75000000,2,'','',174,3,NULL,0,0),(186,1,'2016-11-14 13:55:45','2016-11-14 09:55:45','2016-11-14 12:00:00',15000.00000000,2,'','',175,3,NULL,0,0),(187,1,'2016-11-28 23:06:35','2016-11-28 19:06:35','2016-11-25 12:00:00',20000.00000000,2,'','',176,3,NULL,0,0),(188,1,'2016-11-28 23:11:05','2016-11-28 19:11:06','2016-11-22 12:00:00',16676.22000000,2,'','',177,3,NULL,0,0),(189,1,'2016-11-28 23:12:20','2016-11-28 19:12:20','2016-11-18 12:00:00',18572.00000000,2,'','',178,3,NULL,0,0),(190,1,'2016-11-28 23:13:51','2016-11-28 19:13:51','2016-11-16 12:00:00',1734.41000000,2,'','',179,3,NULL,0,0),(191,1,'2016-11-28 23:18:57','2016-11-28 19:18:57','2016-11-09 12:00:00',484.00000000,2,'','',180,3,NULL,0,0),(192,1,'2016-12-09 16:31:55','2016-12-09 12:31:55','2016-12-09 12:00:00',1210.00000000,2,'','',181,3,NULL,0,0),(193,1,'2016-12-10 00:55:17','2016-12-09 20:55:17','2016-07-05 12:00:00',4840.00000000,2,'','',182,3,NULL,0,0),(194,1,'2016-12-15 12:08:17','2016-12-15 08:08:17','2016-12-14 12:00:00',6511.18000000,2,'','',183,3,NULL,0,0),(195,1,'2016-12-15 12:19:02','2016-12-15 08:19:02','2016-12-15 12:00:00',335.41000000,2,'','',184,3,NULL,0,0),(196,1,'2017-01-17 13:02:47','2017-01-17 09:02:47','2017-01-02 12:00:00',50000.00000000,2,'','',185,3,NULL,0,0),(197,1,'2017-01-19 19:17:45','2017-01-19 15:17:45','2017-01-18 12:00:00',16869.09000000,2,'','',186,3,NULL,0,0),(198,1,'2017-01-19 19:29:43','2017-01-19 15:29:43','2017-01-17 12:00:00',7487.90000000,2,'','',187,3,NULL,0,0),(199,1,'2017-01-19 19:55:43','2017-01-19 15:55:43','2017-01-19 12:00:00',1210.00000000,4,'','',188,3,NULL,0,0),(200,1,'2017-02-02 01:37:37','2017-02-01 21:37:37','2017-02-01 12:00:00',24517.02000000,2,'','',189,3,NULL,0,0),(201,1,'2017-02-02 01:38:10','2017-02-01 21:38:10','2017-02-01 12:00:00',1210.00000000,2,'','',190,3,NULL,0,0),(202,1,'2017-02-16 16:18:42','2017-02-16 12:18:42','2017-02-13 12:00:00',2459.33000000,2,'','',191,4,NULL,0,0),(203,1,'2017-02-16 16:21:17','2017-02-16 12:21:17','2017-02-02 12:00:00',280.84000000,2,'','',192,4,NULL,0,0),(204,1,'2017-03-03 12:04:22','2017-03-03 08:04:22','2017-03-03 12:00:00',1210.00000000,2,'','',193,4,NULL,0,0),(205,1,'2017-03-23 14:10:02','2017-03-23 10:10:02','2017-03-23 12:00:00',18446.45000000,2,'','',194,4,NULL,0,0),(206,1,'2017-04-11 14:07:21','2017-04-11 10:07:21','2017-04-11 12:00:00',1734.41000000,2,'','',195,4,NULL,0,0),(207,1,'2017-04-11 14:20:30','2017-04-11 10:20:30','2017-03-02 12:00:00',3255.75000000,2,'','',196,4,NULL,0,0),(208,1,'2017-04-11 14:23:05','2017-04-11 10:23:05','2016-12-22 12:00:00',57136.20000000,2,'','',197,4,NULL,0,0),(209,1,'2017-04-11 14:23:45','2017-04-11 10:23:45','2017-01-11 12:00:00',6171.00000000,2,'','',198,4,NULL,0,0),(210,1,'2017-04-25 07:45:03','2017-04-25 03:45:03','2017-04-25 12:00:00',15666.80000000,2,'','',199,4,NULL,0,0),(211,1,'2017-05-02 12:01:19','2017-05-02 08:01:20','2017-05-02 12:00:00',35424.80000000,2,'','',200,3,NULL,0,0),(212,1,'2017-05-08 12:40:01','2017-05-08 08:40:01','2017-05-08 12:00:00',7279.36000000,2,'','',201,4,NULL,0,0),(213,1,'2017-05-10 21:16:37','2017-05-10 17:16:37','2017-05-10 12:00:00',1210.00000000,2,'','',202,3,NULL,0,0),(214,1,'2017-05-24 17:29:32','2017-05-24 13:29:32','2017-05-24 12:00:00',10315.90000000,2,'','',203,4,NULL,0,0),(215,1,'2017-05-30 14:05:31','2017-05-30 10:05:31','2017-05-30 12:00:00',16782.70000000,2,'','',204,4,NULL,0,0),(216,1,'2017-06-12 14:49:47','2017-06-12 10:49:47','2017-06-12 12:00:00',6295.63000000,2,'','',205,4,NULL,0,0),(217,1,'2017-06-21 14:54:09','2017-06-21 10:54:09','2017-06-21 12:00:00',11419.98000000,2,'','',206,4,NULL,0,0),(218,1,'2017-07-01 01:00:17','2017-06-30 21:00:17','2017-06-27 12:00:00',20848.30000000,2,'','',207,3,NULL,0,0),(219,1,'2017-07-12 13:30:39','2017-07-12 09:30:39','2017-07-12 12:00:00',2000.00000000,2,'','',208,3,NULL,0,0),(220,1,'2017-08-01 15:56:34','2017-08-01 11:56:34','2017-08-01 12:00:00',11858.00000000,2,'','',209,4,NULL,0,0),(221,1,'2017-08-29 13:09:09','2017-08-29 09:09:09','2017-07-20 12:00:00',10000.00000000,2,'','',210,3,NULL,0,0),(222,1,'2017-08-29 13:20:27','2017-08-29 09:20:27','2017-08-29 12:00:00',9229.99000000,2,'','',211,3,NULL,0,0),(223,1,'2017-08-31 11:09:15','2017-08-31 07:09:15','2017-08-31 12:00:00',7000.00000000,2,'','',212,3,NULL,0,0),(224,1,'2017-09-05 12:40:00','2017-09-05 08:40:00','2017-09-05 12:00:00',6000.00000000,2,'','',213,3,NULL,0,0),(225,1,'2017-09-07 12:12:21','2017-09-07 08:12:21','2017-09-07 12:00:00',1210.00000000,2,'','',214,4,NULL,0,0),(226,1,'2017-09-13 18:02:20','2017-09-13 14:02:20','2017-04-26 12:00:00',143.99000000,2,'','',215,3,NULL,0,0),(227,1,'2017-09-29 11:22:48','2017-09-29 07:22:48','2017-09-29 12:00:00',10437.10000000,2,'','',216,3,NULL,0,0),(228,1,'2017-10-13 15:47:02','2017-10-13 11:47:02','2017-10-13 12:00:00',16488.67000000,2,'','',217,4,NULL,0,0),(229,1,'2017-10-21 13:24:52','2017-10-21 09:24:52','2017-10-03 12:00:00',3000.00000000,2,'','',218,3,NULL,0,0),(230,1,'2017-10-21 13:27:34','2017-10-21 09:27:34','2017-10-06 12:00:00',2000.00000000,2,'','',219,3,NULL,0,0),(231,1,'2017-11-01 21:05:03','2017-11-01 17:05:03','2017-11-01 12:00:00',22000.00000000,2,'','',220,3,NULL,0,0),(232,1,'2017-11-08 14:07:37','2017-11-08 10:07:37','2017-11-08 12:00:00',2768.48000000,2,'','',221,4,NULL,0,0),(233,1,'2017-11-08 14:07:56','2017-11-08 10:07:56','2017-11-08 12:00:00',-2768.48000000,2,'','',222,4,NULL,0,0),(234,1,'2017-11-09 11:47:29','2017-11-09 07:47:29','2017-11-02 12:00:00',26886.20000000,2,'','',223,3,NULL,0,0),(235,1,'2017-11-20 15:51:46','2017-11-20 11:51:47','2017-11-20 12:00:00',3006.85000000,2,'','',224,4,NULL,0,0),(236,1,'2017-11-21 10:46:42','2017-11-21 06:46:43','2017-11-21 12:00:00',5390.55000000,2,'','',225,4,NULL,0,0),(237,1,'2017-11-28 11:09:15','2017-11-28 07:09:15','2017-11-28 12:00:00',20000.00000000,2,'','',226,3,NULL,0,0),(238,1,'2017-12-04 23:06:28','2017-12-04 19:06:29','2017-09-29 12:00:00',11965.69000000,2,'','',227,3,NULL,0,0),(239,1,'2017-12-07 11:18:32','2017-12-07 07:18:32','2017-12-07 12:00:00',4636.25000000,2,'','',228,3,NULL,0,0),(240,1,'2017-12-11 16:23:15','2017-12-11 12:23:15','2017-12-11 12:00:00',3762.50000000,2,'','',229,3,NULL,0,0),(241,1,'2017-12-29 13:40:07','2017-12-29 09:40:07','2017-12-12 12:00:00',12000.00000000,2,'','',230,3,NULL,0,0),(242,1,'2017-12-29 13:41:38','2017-12-29 09:41:38','2017-12-29 12:00:00',16000.00000000,2,'','',231,3,NULL,0,0),(245,1,'2018-01-11 13:21:46','2018-01-11 12:21:46','2018-01-11 12:00:00',18762.50000000,2,'','',234,4,NULL,0,0),(246,1,'2018-01-23 12:39:33','2018-01-23 11:39:33','2018-01-23 12:00:00',2008.60000000,2,'','',235,4,NULL,0,0),(247,1,'2018-02-01 09:18:00','2018-02-01 08:18:00','2018-02-01 12:00:00',14588.13000000,2,'','',236,3,NULL,0,0),(248,1,'2018-02-01 11:00:35','2018-02-01 10:00:35','2018-02-01 12:00:00',1210.00000000,2,'','',237,4,NULL,0,0),(249,1,'2018-03-02 09:01:20','2018-03-02 08:01:21','2018-03-02 12:00:00',2008.60000000,2,'','',238,4,NULL,0,0),(250,1,'2018-03-19 13:36:45','2018-03-19 12:36:45','2018-03-19 12:00:00',1210.00000000,2,'','',239,4,NULL,0,0),(251,1,'2018-04-12 08:10:09','2018-04-12 06:10:09','2018-01-23 12:00:00',4524.19000000,2,'','',240,4,NULL,0,0),(252,1,'2018-05-14 09:46:45','2018-05-14 07:46:46','2018-05-14 12:00:00',18048.36000000,2,'','',241,4,NULL,0,0),(253,1,'2018-05-14 10:59:30','2018-05-14 08:59:30','2018-03-27 12:00:00',34938.11000000,2,'','',242,4,NULL,0,0),(254,1,'2018-05-14 11:06:13','2018-05-14 09:06:13','2018-03-27 12:00:00',22034.10000000,2,'','',243,4,NULL,0,0),(255,1,'2018-05-14 11:09:20','2018-05-14 09:09:20','2018-05-14 12:00:00',13034.10000000,2,'','',244,4,NULL,0,0),(256,1,'2018-05-14 14:31:13','2018-05-14 12:31:14','2018-05-15 12:00:00',23205.46000000,2,'','',245,4,NULL,0,0),(257,1,'2018-05-14 14:32:11','2018-05-14 12:32:11','2018-05-15 12:00:00',300.00000000,2,'','',246,4,NULL,0,0),(258,1,'2018-05-14 14:33:56','2018-05-14 12:33:56','2018-05-14 12:00:00',1210.00000000,2,'','',247,4,NULL,0,0),(259,1,'2018-06-01 13:35:46','2018-06-01 11:35:46','2018-06-02 12:00:00',16437.85000000,2,'','',248,4,NULL,0,0),(260,1,'2018-06-05 13:34:50','2018-06-05 11:34:51','2018-06-05 12:00:00',605.00000000,2,'','',249,4,NULL,0,0),(261,1,'2018-06-21 10:28:19','2018-06-21 08:28:19','2018-06-21 12:00:00',6133.10000000,2,'','',250,4,NULL,0,0),(262,1,'2018-06-25 11:54:16','2018-06-25 09:54:17','2018-06-25 12:00:00',3000.00000000,2,'','',251,4,NULL,0,0),(263,1,'2018-07-18 08:30:59','2018-07-18 06:30:59','2018-07-18 12:00:00',200.00000000,2,'','',252,4,NULL,0,0),(264,1,'2018-07-18 08:42:31','2018-07-18 06:42:31','2018-07-18 12:00:00',195.54000000,2,'','',253,4,NULL,0,0),(265,1,'2018-07-18 08:44:06','2018-07-18 06:44:06','2018-07-18 12:00:00',100.00000000,2,'','',254,4,NULL,0,0),(266,1,'2018-09-05 13:34:26','2018-09-05 11:34:26','2018-09-05 12:00:00',15000.00000000,2,'','',255,4,NULL,0,0),(267,1,'2018-09-05 13:35:43','2018-09-05 11:35:43','2018-09-05 12:00:00',3422.25000000,2,'','',256,4,NULL,0,0),(268,1,'2018-10-11 14:05:41','2018-10-11 12:05:41','2018-10-11 12:00:00',22100.00000000,2,'','',257,4,NULL,0,0),(269,1,'2018-10-22 12:14:53','2018-10-22 10:14:53','2018-10-22 12:00:00',10000.00000000,2,'','',258,4,NULL,0,0),(270,1,'2018-11-19 09:17:19','2018-11-19 08:17:19','2018-11-06 12:00:00',13150.00000000,2,'','',259,4,NULL,0,0),(271,1,'2018-12-10 10:43:31','2018-12-10 09:43:31','2018-12-10 12:00:00',11260.01000000,2,'','',260,4,NULL,0,0);

--
-- Table structure for table `am_paiement_facture`
--

CREATE TABLE `am_paiement_facture` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_paiement` int(11) DEFAULT NULL,
  `fk_facture` int(11) DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_paiement_facture` (`fk_paiement`,`fk_facture`),
  KEY `idx_paiement_facture_fk_facture` (`fk_facture`),
  KEY `idx_paiement_facture_fk_paiement` (`fk_paiement`),
  CONSTRAINT `fk_paiement_facture_fk_facture` FOREIGN KEY (`fk_facture`) REFERENCES `am_facture` (`rowid`),
  CONSTRAINT `fk_paiement_facture_fk_paiement` FOREIGN KEY (`fk_paiement`) REFERENCES `am_paiement` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=462 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_paiement_facture`
--

INSERT INTO `am_paiement_facture` VALUES (1,1,15,5354.25000000),(2,2,34,4900.50000000),(3,3,1,21259.70000000),(4,3,2,19057.50000000),(5,3,3,8296.23000000),(6,3,4,22869.00000000),(7,3,5,24901.80000000),(8,3,6,20963.25000000),(9,3,7,22826.65000000),(10,3,8,16498.35000000),(11,3,9,18676.35000000),(12,3,10,6550.47000000),(13,3,11,20164.65000000),(14,3,12,22826.65000000),(15,3,13,18331.50000000),(16,3,14,20751.20000000),(17,3,16,7891.13000000),(18,3,17,18331.50000000),(19,3,18,20751.50000000),(20,3,19,20164.65000000),(21,3,20,22826.65000000),(22,3,21,8113.29000000),(23,3,22,18331.50000000),(24,3,23,20751.50000000),(25,3,24,21429.10000000),(26,3,25,22826.65000000),(27,3,26,11606.81000000),(28,3,28,20751.50000000),(29,3,29,19723.00000000),(30,3,30,20751.50000000),(31,3,31,19723.00000000),(32,3,32,11327.53000000),(33,3,35,47728.45000000),(34,3,36,44806.30000000),(35,3,38,20751.50000000),(36,3,39,19481.00000000),(37,3,41,1911.80000000),(38,3,42,22826.65000000),(39,3,43,21429.10000000),(40,3,46,11118.02000000),(41,3,47,20751.50000000),(42,3,48,19481.00000000),(43,3,49,22826.65000000),(44,3,50,21429.10000000),(45,3,56,10269.08000000),(46,3,57,22826.65000000),(47,3,58,21429.10000000),(48,3,60,24901.80000000),(49,3,61,21562.20000000),(50,3,62,14946.34000000),(51,3,68,18676.35000000),(52,3,69,17532.90000000),(53,3,71,20751.50000000),(54,3,72,19481.00000000),(55,3,75,15110.90000000),(56,3,76,19809.44000000),(57,4,14,0.30000000),(58,5,82,22723.80000000),(59,6,82,24512.20000000),(60,7,82,20501.98000000),(61,8,82,20830.15000000),(62,9,82,18936.50000000),(63,10,82,19299.50000000),(64,11,82,19057.50000000),(65,12,82,19057.50000000),(66,13,82,18593.34000000),(67,14,82,28092.28000000),(68,15,150,4416.50000000),(69,16,106,423.50000000),(70,17,163,1324.08000000),(71,18,134,5324.00000000),(72,18,142,5566.00000000),(73,18,149,4719.00000000),(74,18,158,11156.00000000),(75,19,135,4549.60000000),(76,19,143,3993.00000000),(77,19,144,12138.72000000),(78,19,157,4688.75000000),(79,20,53,1210.00000000),(80,21,171,1203.71000000),(81,22,27,4827.90000000),(82,22,86,5566.00000000),(83,23,55,4537.50000000),(84,23,67,10297.10000000),(85,23,74,8506.30000000),(86,24,70,968.00000000),(87,25,66,1258.40000000),(88,26,84,1452.00000000),(89,27,107,484.00000000),(90,28,112,242.00000000),(91,29,158,0.20000000),(92,30,76,1171.96000000),(93,30,77,19481.00000000),(94,30,78,22826.65000000),(95,30,79,21429.10000000),(96,30,80,13338.01000000),(97,30,85,36047.23000000),(98,31,87,482015.00000000),(99,31,88,7004.86000000),(100,31,90,37310.70000000),(101,31,92,37812.81000000),(102,31,94,5128.27000000),(103,31,95,631.87000000),(104,31,96,37812.81000000),(105,31,97,41039.46000000),(106,31,98,5385.37000000),(107,31,99,42771.06000000),(108,31,100,6161.78000000),(109,31,105,39320.00000000),(110,31,108,39756.44000000),(111,31,109,5398.92000000),(112,31,110,40868.95000000),(113,31,113,7444.11000000),(114,31,115,36266.86000000),(115,31,117,2148.96000000),(116,31,118,44590.63000000),(117,31,119,6626.30000000),(118,31,120,44041.43000000),(119,31,122,43672.50000000),(120,32,87,-433809.85000000),(121,33,169,605.00000000),(122,34,123,4934.57000000),(123,35,124,40864.76000000),(124,36,125,41023.56000000),(125,37,127,4934.57000000),(126,38,121,484.00000000),(127,39,128,40652.40000000),(128,40,132,49891.91000000),(129,41,136,44650.94000000),(130,42,137,4938.11000000),(131,43,130,1245.17000000),(132,43,131,2777.69000000),(133,44,138,726.00000000),(134,44,140,726.00000000),(135,44,141,48302.63000000),(136,45,145,5821.65000000),(137,45,146,37648.95000000),(138,45,147,4938.11000000),(139,45,148,41125.50000000),(140,45,151,726.00000000),(141,46,152,6300.18000000),(142,46,153,45208.58000000),(143,46,154,47615.37000000),(144,47,155,726.00000000),(145,47,156,6316.00000000),(146,48,156,3.10000000),(147,48,159,30597.93000000),(148,49,159,12097.73000000),(149,50,162,12320.92000000),(150,51,173,1203.71000000),(151,52,164,726.00000000),(152,52,165,4245.02000000),(153,53,161,1936.00000000),(154,54,180,1203.71000000),(155,55,182,1553.35000000),(156,56,166,6993.80000000),(157,57,170,41052.21000000),(158,58,174,726.00000000),(159,58,172,40486.08000000),(160,59,177,5224.15000000),(161,59,179,40491.09000000),(162,60,167,2420.00000000),(163,61,168,2420.00000000),(164,62,178,6776.00000000),(165,63,187,1295.73000000),(166,64,186,705.31000000),(167,65,191,5203.00000000),(168,66,200,5977.40000000),(169,67,202,1060.14000000),(170,68,195,1177.94000000),(171,69,204,1413.52000000),(172,70,193,1060.14000000),(173,71,160,1203.71000000),(174,72,211,1295.73000000),(175,73,181,53042.20000000),(176,74,183,726.00000000),(177,74,184,5520.70000000),(178,74,185,43464.94000000),(179,74,188,46764.28000000),(180,74,189,5623.93000000),(181,74,190,726.00000000),(182,74,192,40109.05000000),(183,74,194,43368.45000000),(184,74,196,726.00000000),(185,74,197,4067.25000000),(186,75,175,67.76000000),(187,75,215,1177.94000000),(188,75,216,1295.73000000),(189,76,208,4791.60000000),(190,76,219,13552.00000000),(191,77,220,1295.73000000),(192,78,201,39420.73000000),(193,79,203,53266.41000000),(194,79,205,726.00000000),(195,79,206,4562.38000000),(196,79,209,47533.13000000),(197,80,210,726.00000000),(198,80,212,4819.00000000),(199,80,213,48025.48000000),(200,80,214,20122.49000000),(201,81,221,25383.00000000),(202,82,221,10000.00000000),(203,83,221,20000.00000000),(204,84,221,20000.00000000),(205,85,224,20000.00000000),(206,86,224,17510.00000000),(209,89,230,302.50000000),(210,89,231,242.00000000),(213,92,226,20000.00000000),(214,93,226,40000.00000000),(215,94,226,13000.00000000),(216,95,226,15668.80000000),(217,95,233,80608.00000000),(218,96,176,4295.50000000),(219,97,228,1721.93000000),(220,98,239,10914.20000000),(221,99,212,0.98000000),(222,99,214,23573.02000000),(223,99,217,726.00000000),(224,99,223,700.00000000),(225,100,237,20199.01000000),(226,101,235,1291.45000000),(227,102,225,1295.73000000),(228,103,222,1295.73000000),(229,104,240,7986.00000000),(230,105,237,26000.00000000),(231,106,241,26199.01000000),(232,107,245,4050.80000000),(233,108,241,5000.00000000),(234,109,241,15000.00000000),(235,110,247,3000.00000000),(236,111,247,4320.00000000),(237,112,245,5000.00000000),(238,113,247,20000.00000000),(239,114,247,15000.00000000),(240,115,249,22320.00000000),(241,116,229,1331.00000000),(242,116,236,16774.47000000),(243,116,244,28909.32000000),(244,116,243,1210.00000000),(245,116,250,1210.00000000),(246,117,223,26.00000000),(247,117,227,539.21000000),(248,118,232,1934.86000000),(249,119,249,5000.00000000),(250,120,254,1452.00000000),(251,121,249,15000.00000000),(252,121,257,5000.00000000),(253,122,257,682.00000000),(254,123,227,186.79000000),(255,123,234,1210.00000000),(256,124,251,24170.96000000),(257,124,256,986.60000000),(258,125,242,1898.56000000),(259,126,260,8228.00000000),(260,126,263,8639.40000000),(261,127,238,1291.45000000),(262,128,246,1697.03000000),(263,129,257,22000.00000000),(264,130,256,223.40000000),(265,130,258,20364.30000000),(266,130,259,3944.60000000),(267,131,257,25000.00000000),(268,132,257,25000.00000000),(269,133,268,36320.75000000),(270,134,252,1866.73000000),(271,135,248,1697.03000000),(272,136,255,1784.36000000),(273,137,268,20000.00000000),(274,138,268,20000.00000000),(275,139,266,1210.00000000),(276,139,267,16823.84000000),(277,140,264,9050.00000000),(278,141,264,0.80000000),(279,142,272,12364.99000000),(280,143,273,15144.00000000),(281,144,273,20000.00000000),(282,145,273,20000.00000000),(283,146,278,20849.50000000),(284,147,262,1996.90000000),(285,147,265,2807.48000000),(286,148,278,15000.00000000),(287,149,278,5000.00000000),(288,150,278,10000.00000000),(289,151,270,3097.16000000),(290,152,278,5000.00000000),(291,153,277,17482.69000000),(292,154,278,20000.00000000),(293,155,278,10000.00000000),(294,156,292,11367.10000000),(295,157,282,1842.19000000),(296,158,294,6733.65000000),(297,158,295,6413.00000000),(298,159,275,1635.93000000),(299,159,279,1842.19000000),(300,160,292,20000.00000000),(301,161,276,1210.00000000),(302,161,293,1270.50000000),(303,162,291,13842.40000000),(304,163,292,38000.00000000),(305,164,292,2000.00000000),(306,165,292,15000.00000000),(307,166,292,5000.00000000),(308,167,289,1842.19000000),(309,168,300,40000.00000000),(310,169,298,1210.00000000),(311,170,299,13203.52000000),(312,171,300,10000.00000000),(313,172,300,42999.39000000),(314,173,303,508.20000000),(315,173,305,1210.00000000),(316,174,296,1842.19000000),(317,174,297,1842.19000000),(318,174,302,3024.66000000),(319,175,304,2032.55000000),(320,176,307,42661.80000000),(321,177,307,20000.00000000),(322,178,307,5000.00000000),(323,179,307,25000.00000000),(324,179,317,27507.20000000),(325,180,308,1934.06000000),(326,180,312,1934.06000000),(327,181,317,30000.00000000),(328,182,317,15000.00000000),(329,183,309,4392.30000000),(330,183,310,3993.00000000),(331,183,311,2129.60000000),(332,184,306,16690.74000000),(333,184,314,14294.94000000),(334,185,319,3255.75000000),(335,186,317,15000.00000000),(336,187,324,20000.00000000),(337,188,320,1210.00000000),(338,188,321,15466.22000000),(339,189,324,18572.00000000),(340,190,318,1734.41000000),(341,191,280,484.00000000),(342,192,329,1210.00000000),(343,193,283,1210.00000000),(344,193,284,1210.00000000),(345,193,287,1210.00000000),(346,193,288,1210.00000000),(347,194,325,2930.18000000),(348,194,328,3581.00000000),(349,195,331,105.51000000),(350,195,332,229.90000000),(351,196,324,50000.00000000),(352,197,330,16869.09000000),(353,198,334,3906.90000000),(354,198,339,3581.00000000),(355,199,335,1210.00000000),(356,200,269,6836.50000000),(357,200,271,1210.00000000),(358,200,281,4658.50000000),(359,200,301,980.10000000),(360,200,313,1210.00000000),(361,200,315,211.75000000),(362,200,316,453.75000000),(363,200,336,1210.00000000),(364,200,338,7746.42000000),(365,201,290,1210.00000000),(366,202,341,2459.33000000),(367,203,340,93.29000000),(368,203,342,187.55000000),(369,204,347,1210.00000000),(370,205,345,13243.45000000),(371,205,350,3993.00000000),(372,205,352,1210.00000000),(373,206,274,1734.41000000),(374,207,343,3255.75000000),(375,208,333,57136.20000000),(376,209,337,6171.00000000),(377,210,346,15666.80000000),(378,211,346,5000.00000000),(379,211,351,20424.80000000),(380,211,354,10000.00000000),(381,212,353,1210.00000000),(382,212,355,6069.36000000),(383,213,356,1210.00000000),(384,214,354,10315.90000000),(385,215,357,16782.70000000),(386,216,358,5789.85000000),(387,216,359,505.78000000),(388,217,362,11419.98000000),(389,218,361,20848.30000000),(390,219,365,2000.00000000),(391,220,363,10648.00000000),(392,220,364,1210.00000000),(393,221,365,10000.00000000),(394,222,365,9229.99000000),(395,223,368,7000.00000000),(396,224,368,6000.00000000),(397,225,360,1210.00000000),(398,226,348,143.99000000),(399,227,368,7218.55000000),(400,227,371,3218.55000000),(401,228,367,1210.00000000),(402,228,369,14068.67000000),(403,228,370,1210.00000000),(404,229,371,3000.00000000),(405,230,371,2000.00000000),(406,231,371,12000.00000000),(407,231,374,10000.00000000),(408,232,376,2768.48000000),(409,233,380,-2768.48000000),(410,234,374,16886.20000000),(411,234,377,10000.00000000),(412,235,372,1796.85000000),(413,235,373,1210.00000000),(414,236,375,5390.55000000),(415,237,377,20000.00000000),(416,238,366,11965.69000000),(417,239,377,4636.25000000),(418,240,386,3762.50000000),(419,241,386,12000.00000000),(420,242,386,16000.00000000),(423,245,392,18762.50000000),(424,246,384,798.60000000),(425,246,385,1210.00000000),(426,247,392,14588.13000000),(427,248,378,1210.00000000),(428,249,394,798.60000000),(429,249,395,1210.00000000),(430,250,398,1210.00000000),(431,251,390,3314.19000000),(432,251,391,1210.00000000),(433,252,381,2768.48000000),(434,252,383,4192.65000000),(435,252,389,2994.75000000),(436,252,393,8092.48000000),(437,253,396,34938.11000000),(438,254,399,22034.10000000),(439,255,401,13034.10000000),(440,256,397,8518.40000000),(441,256,400,14687.06000000),(442,257,400,300.00000000),(443,258,402,1210.00000000),(444,259,403,16437.85000000),(445,260,406,605.00000000),(446,261,401,6133.10000000),(447,262,401,3000.00000000),(448,263,387,100.00000000),(449,263,388,100.00000000),(450,264,322,195.54000000),(451,265,382,100.00000000),(452,266,404,15000.00000000),(453,267,404,3422.25000000),(454,268,410,10000.00000000),(455,268,411,12100.00000000),(456,269,419,5000.00000000),(457,269,420,5000.00000000),(458,270,420,7100.00000000),(459,270,421,6050.00000000),(460,271,423,7260.00000000),(461,271,424,4000.01000000);

--
-- Table structure for table `am_paiementcharge`
--

CREATE TABLE `am_paiementcharge` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_charge` int(11) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datep` datetime DEFAULT NULL,
  `amount` double DEFAULT '0',
  `fk_typepaiement` int(11) NOT NULL,
  `num_paiement` varchar(50) DEFAULT NULL,
  `note` text,
  `fk_bank` int(11) NOT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_paiementcharge`
--


--
-- Table structure for table `am_paiementfourn`
--

CREATE TABLE `am_paiementfourn` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `datep` datetime DEFAULT NULL,
  `amount` double DEFAULT '0',
  `fk_user_author` int(11) DEFAULT NULL,
  `fk_paiement` int(11) NOT NULL,
  `num_paiement` varchar(50) DEFAULT NULL,
  `note` text,
  `fk_bank` int(11) NOT NULL,
  `statut` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_paiementfourn`
--


--
-- Table structure for table `am_paiementfourn_facturefourn`
--

CREATE TABLE `am_paiementfourn_facturefourn` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_paiementfourn` int(11) DEFAULT NULL,
  `fk_facturefourn` int(11) DEFAULT NULL,
  `amount` double(24,8) DEFAULT '0.00000000',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_paiementfourn_facturefourn` (`fk_paiementfourn`,`fk_facturefourn`),
  KEY `idx_paiementfourn_facturefourn_fk_facture` (`fk_facturefourn`),
  KEY `idx_paiementfourn_facturefourn_fk_paiement` (`fk_paiementfourn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_paiementfourn_facturefourn`
--


--
-- Table structure for table `am_payment_salary`
--

CREATE TABLE `am_payment_salary` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_user` int(11) NOT NULL,
  `datep` date DEFAULT NULL,
  `datev` date DEFAULT NULL,
  `amount` double NOT NULL DEFAULT '0',
  `fk_typepayment` int(11) NOT NULL,
  `num_payment` varchar(50) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `datesp` date DEFAULT NULL,
  `dateep` date DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `note` text,
  `fk_bank` int(11) DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_payment_salary`
--


--
-- Table structure for table `am_prelevement_bons`
--

CREATE TABLE `am_prelevement_bons` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(12) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `datec` datetime DEFAULT NULL,
  `amount` double DEFAULT '0',
  `statut` smallint(6) DEFAULT '0',
  `credite` smallint(6) DEFAULT '0',
  `note` text,
  `date_trans` datetime DEFAULT NULL,
  `method_trans` smallint(6) DEFAULT NULL,
  `fk_user_trans` int(11) DEFAULT NULL,
  `date_credit` datetime DEFAULT NULL,
  `fk_user_credit` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_prelevement_bons_ref` (`ref`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_prelevement_bons`
--


--
-- Table structure for table `am_prelevement_facture`
--

CREATE TABLE `am_prelevement_facture` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_facture` int(11) NOT NULL,
  `fk_prelevement_lignes` int(11) NOT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_prelevement_facture_fk_prelevement_lignes` (`fk_prelevement_lignes`),
  CONSTRAINT `fk_prelevement_facture_fk_prelevement_lignes` FOREIGN KEY (`fk_prelevement_lignes`) REFERENCES `am_prelevement_lignes` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_prelevement_facture`
--


--
-- Table structure for table `am_prelevement_facture_demande`
--

CREATE TABLE `am_prelevement_facture_demande` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_facture` int(11) NOT NULL,
  `amount` double NOT NULL,
  `date_demande` datetime NOT NULL,
  `traite` smallint(6) DEFAULT '0',
  `date_traite` datetime DEFAULT NULL,
  `fk_prelevement_bons` int(11) DEFAULT NULL,
  `fk_user_demande` int(11) NOT NULL,
  `code_banque` varchar(7) DEFAULT NULL,
  `code_guichet` varchar(6) DEFAULT NULL,
  `number` varchar(255) DEFAULT NULL,
  `cle_rib` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_prelevement_facture_demande`
--


--
-- Table structure for table `am_prelevement_lignes`
--

CREATE TABLE `am_prelevement_lignes` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_prelevement_bons` int(11) DEFAULT NULL,
  `fk_soc` int(11) NOT NULL,
  `statut` smallint(6) DEFAULT '0',
  `client_nom` varchar(255) DEFAULT NULL,
  `amount` double DEFAULT '0',
  `code_banque` varchar(7) DEFAULT NULL,
  `code_guichet` varchar(6) DEFAULT NULL,
  `number` varchar(255) DEFAULT NULL,
  `cle_rib` varchar(5) DEFAULT NULL,
  `note` text,
  PRIMARY KEY (`rowid`),
  KEY `idx_prelevement_lignes_fk_prelevement_bons` (`fk_prelevement_bons`),
  CONSTRAINT `fk_prelevement_lignes_fk_prelevement_bons` FOREIGN KEY (`fk_prelevement_bons`) REFERENCES `am_prelevement_bons` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_prelevement_lignes`
--


--
-- Table structure for table `am_prelevement_rejet`
--

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

--
-- Dumping data for table `am_prelevement_rejet`
--


--
-- Table structure for table `am_printer_ipp`
--

CREATE TABLE `am_printer_ipp` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `printer_name` text NOT NULL,
  `printer_location` text NOT NULL,
  `printer_uri` varchar(255) NOT NULL,
  `copy` int(11) NOT NULL DEFAULT '1',
  `module` varchar(16) NOT NULL,
  `login` varchar(32) NOT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_printer_ipp`
--


--
-- Table structure for table `am_product`
--

CREATE TABLE `am_product` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(128) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `ref_ext` varchar(128) DEFAULT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `virtual` tinyint(4) NOT NULL DEFAULT '0',
  `fk_parent` int(11) DEFAULT '0',
  `label` varchar(255) NOT NULL,
  `description` text,
  `note` text,
  `customcode` varchar(32) DEFAULT NULL,
  `fk_country` int(11) DEFAULT NULL,
  `price` double(24,8) DEFAULT '0.00000000',
  `price_ttc` double(24,8) DEFAULT '0.00000000',
  `price_min` double(24,8) DEFAULT '0.00000000',
  `price_min_ttc` double(24,8) DEFAULT '0.00000000',
  `price_base_type` varchar(3) DEFAULT 'HT',
  `tva_tx` double(6,3) DEFAULT NULL,
  `recuperableonly` int(11) NOT NULL DEFAULT '0',
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `fk_user_author` int(11) DEFAULT NULL,
  `tosell` tinyint(4) DEFAULT '1',
  `tobuy` tinyint(4) DEFAULT '1',
  `fk_product_type` int(11) DEFAULT '0',
  `duration` varchar(6) DEFAULT NULL,
  `seuil_stock_alerte` int(11) DEFAULT '0',
  `barcode` varchar(255) DEFAULT NULL,
  `fk_barcode_type` int(11) DEFAULT '0',
  `accountancy_code_sell` varchar(15) DEFAULT NULL,
  `accountancy_code_buy` varchar(15) DEFAULT NULL,
  `partnumber` varchar(32) DEFAULT NULL,
  `weight` float DEFAULT NULL,
  `weight_units` tinyint(4) DEFAULT NULL,
  `length` float DEFAULT NULL,
  `length_units` tinyint(4) DEFAULT NULL,
  `surface` float DEFAULT NULL,
  `surface_units` tinyint(4) DEFAULT NULL,
  `volume` float DEFAULT NULL,
  `volume_units` tinyint(4) DEFAULT NULL,
  `stock` int(11) DEFAULT NULL,
  `pmp` double(24,8) NOT NULL DEFAULT '0.00000000',
  `canvas` varchar(32) DEFAULT NULL,
  `finished` tinyint(4) DEFAULT NULL,
  `hidden` tinyint(4) DEFAULT '0',
  `import_key` varchar(14) DEFAULT NULL,
  `desiredstock` int(11) DEFAULT '0',
  `url` varchar(255) DEFAULT NULL,
  `tobatch` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_ref` (`ref`,`entity`),
  UNIQUE KEY `uk_product_barcode` (`barcode`,`fk_barcode_type`,`entity`),
  KEY `idx_product_label` (`label`),
  KEY `idx_product_barcode` (`barcode`),
  KEY `idx_product_import_key` (`import_key`)
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_product`
--

INSERT INTO `am_product` VALUES (1,'TourneeCharleroi01',1,NULL,'2013-06-18 15:35:38','2013-06-18 11:35:38',0,0,'Tournée Charleroi 01','','','',2,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(2,'TourneeCharleroi02',1,NULL,'2013-06-18 15:36:17','2013-06-18 11:36:17',0,0,'Tournée Charleroi 02','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(3,'TourneeCharleroi03',1,NULL,'2013-06-18 15:36:40','2013-06-18 11:36:40',0,0,'Tournée Charleroi 03','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(4,'TourneeCharleroi04',1,NULL,'2013-06-18 15:37:00','2013-06-18 11:37:00',0,0,'Tournée Charleroi 04','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(5,'TourneeCharleroi05',1,NULL,'2013-06-18 15:37:29','2013-06-18 11:37:29',0,0,'Tournée Charleroi 05','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(6,'TourneeStTrunden01',1,NULL,'2013-06-18 15:38:37','2013-06-18 11:38:37',0,0,'Tournée St Trunden 01','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(7,'TourneeStTrunden02',1,NULL,'2013-06-18 15:38:57','2013-06-19 10:23:54',0,0,'Tournée St Trunden 02','','','',NULL,130.00000000,157.30000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(8,'TourneeStTrunden03',1,NULL,'2013-06-18 15:39:24','2013-06-18 11:39:24',0,0,'Tournée St Trunden 03','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(9,'TourneeStTrunden04',1,NULL,'2013-06-18 15:39:47','2013-06-18 11:39:47',0,0,'Tournée St Trunden 04','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(10,'TourneeStTrunden05',1,NULL,'2013-06-18 15:40:10','2013-06-18 11:40:10',0,0,'Tournée St Trunden 05','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(11,'TourneeGand01',1,NULL,'2013-06-18 15:41:12','2013-06-18 11:41:12',0,0,'Tournée Gand 01','','','',NULL,150.00000000,181.50000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(12,'TourneeGand02',1,NULL,'2013-06-18 15:41:39','2013-06-18 11:41:39',0,0,'Tournée Gand 02','','','',NULL,140.00000000,169.40000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(13,'TourneeGand03',1,NULL,'2013-06-18 15:42:14','2013-06-18 11:42:14',0,0,'Tournée Gand 03','','','',NULL,140.00000000,169.40000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(14,'TourneeGand04',1,NULL,'2013-06-18 15:42:37','2013-06-18 11:42:37',0,0,'Tournée Gand 04','','','',NULL,140.00000000,169.40000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(15,'TourneeGand05',1,NULL,'2013-06-18 15:43:01','2013-06-18 11:43:01',0,0,'Tournée Gand 05','','','',NULL,140.00000000,169.40000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(16,'TourneeLiege01',1,NULL,'2013-06-19 12:47:19','2013-06-19 08:47:58',0,0,'Tournée Liège 01','','','',NULL,165.00000000,199.65000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(17,'TourneeLiege02',1,NULL,'2013-06-19 12:47:46','2013-06-19 08:47:46',0,0,'Tournée Liège 02','','','',NULL,180.00000000,217.80000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(18,'TourneeLiege03',1,NULL,'2013-06-19 12:48:22','2013-06-19 08:48:22',0,0,'Tournée Liège 03','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(19,'TourneeLiege04',1,NULL,'2013-06-19 12:49:04','2013-06-19 08:49:04',0,0,'Tournée Liège 04','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(20,'TourneeLiege05',1,NULL,'2013-06-19 12:49:32','2013-06-19 08:49:32',0,0,'Tournée Liège 05','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(21,'TourneeBXL01',1,NULL,'2013-06-19 12:50:16','2013-06-19 08:50:16',0,0,'Tournée Bruxelles 01','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(22,'TourneeBXL02',1,NULL,'2013-06-19 12:50:36','2013-06-19 08:50:36',0,0,'Tournée Bruxelles 02','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(23,'TourneeBXL03',1,NULL,'2013-06-19 12:50:59','2013-06-19 08:50:59',0,0,'Tournée Bruxelles 03','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(24,'TourneeBXL04',1,NULL,'2013-06-19 12:51:20','2013-06-19 08:51:20',0,0,'Tournée Bruxelles 04','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(25,'TourneeBXL05',1,NULL,'2013-06-19 12:51:40','2013-06-19 08:51:40',0,0,'Tournée Bruxelles 05','','','',NULL,100.00000000,121.00000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(26,'TourneeBXL06',1,NULL,'2013-06-19 12:52:09','2013-06-19 11:09:32',0,0,'Tournée Bruxelles 06','','','',NULL,120.00000000,145.20000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(27,'TourneeBXL07',1,NULL,'2013-06-19 12:52:29','2013-06-19 08:52:29',0,0,'Tournée Bruxelles 07','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(28,'TourneeBXL08',1,NULL,'2013-06-19 12:52:52','2013-06-19 08:53:02',0,0,'Tournée Bruxelles 08','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,0,0,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(29,'TourneeBXL09',1,NULL,'2013-06-19 12:53:24','2013-06-19 08:53:24',0,0,'Tournée Bruxelles 09','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(30,'TourneeBXL10',1,NULL,'2013-06-19 12:53:48','2013-06-19 08:53:48',0,0,'Tournée Bruxelles 10','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(31,'UrgPlusDe20kmRons',1,NULL,'2013-06-19 12:55:01','2013-06-19 08:55:01',0,0,'Course Urgences Rons + de 20 Km','','','',NULL,0.40000000,0.48400000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(32,'UrgPlusDe20kmStTrond',1,NULL,'2013-06-19 12:55:50','2013-06-19 08:55:50',0,0,'Course Urgences Saint-trond + de 20 Km','','','',NULL,0.40000000,0.48400000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(33,'UrgMoinsDe20kmStTrond',1,NULL,'2013-06-19 12:56:46','2013-06-19 08:56:46',0,0,'Course Urgences St Trond - de 20 Km','','','',NULL,8.00000000,9.68000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(34,'UrgMoinsDe20kmLiege',1,NULL,'2013-06-19 12:57:47','2013-06-19 08:57:47',0,0,'Course Urgences Liège - de 20 Km','','','',NULL,8.00000000,9.68000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(35,'UrgPlusDe20kmLiege',1,NULL,'2013-06-19 12:58:20','2013-06-19 08:58:20',0,0,'Course Urgences Liège + de 20 Km','','','',NULL,0.40000000,0.48400000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(36,'UrgMoinsDe20kmCharleroi',1,NULL,'2013-06-19 13:05:04','2013-06-19 09:05:04',0,0,'Course Urgences Charleroi - de 20 Km','','','',NULL,8.00000000,9.68000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(37,'UrgPlusDe20kmCharleroi',1,NULL,'2013-06-19 13:07:01','2013-06-19 09:07:01',0,0,'Course Urgences Charleroi + de 20 Km','','','',NULL,0.40000000,0.48400000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(38,'UrgMoinsDe20kmAnvers',1,NULL,'2013-06-19 13:07:45','2013-06-19 09:09:03',0,0,'Course Urgences Anvers - de 20 Km','','','',NULL,8.00000000,9.68000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(39,'UrgPlusDe20kmAnvers',1,NULL,'2013-06-19 13:09:27','2013-06-19 09:09:27',0,0,'Course Urgences Anvers + de 20 Km','','','',NULL,0.40000000,0.48400000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(40,'UrgPlusDe20kmBXL',1,NULL,'2013-06-19 13:12:49','2013-06-19 09:13:59',0,0,'Course Urgences Bruxelles + de 20 Km','','','',NULL,0.40000000,0.48400000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(41,'UrgMoinsDe20kmBXL',1,NULL,'2013-06-19 13:14:47','2013-06-19 09:14:47',0,0,'Course Urgences Bruxelles - de 20 Km','','','',NULL,8.00000000,9.68000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(42,'MultidoseRegulier',1,NULL,'2013-06-19 13:15:25','2013-06-19 09:16:01',0,0,'service et Organisation Multidose en date Régulière','','','',NULL,120.00000000,145.20000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(43,'MultidoseFeries',1,NULL,'2013-06-19 13:16:44','2013-06-19 09:16:44',0,0,'service et Organisation Multidose en date jours fériés','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(44,'LigneDate',1,NULL,'2013-06-19 13:29:00','2013-06-19 09:29:00',0,0,'Ligne Date','','','',NULL,0.00000000,0.00000000,0.00000000,0.00000000,'TTC',0.000,0,0.000,0.000,1,1,0,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(45,'TransportServiceXX',1,NULL,'2013-06-19 13:31:23','2013-06-19 09:31:23',0,0,'Transport Service Mois XX','','','',NULL,75.00000000,90.75000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(46,'EnlevementObjetEncombrant',1,NULL,'2013-06-19 13:33:17','2013-06-19 09:33:17',0,0,'Enlèvement Objet Encombrant','Ixelles Direct<br />\r\n60 Rue de la Concorde<br />\r\n1050 Ixelles','','',NULL,3990.00000000,4827.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(47,'TourneeRonse01',1,NULL,'2013-06-19 13:46:55','2013-06-19 09:46:55',0,0,'Tournée Ronse 01','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(48,'TourneeRonse02',1,NULL,'2013-06-19 13:47:38','2013-06-19 09:47:38',0,0,'Tournée Ronse 02','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(49,'TourneeRonse03',1,NULL,'2013-06-19 13:48:04','2013-06-19 09:48:04',0,0,'Tournée Ronse 03','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(50,'TourneeRonse04',1,NULL,'2013-06-19 13:48:30','2013-06-19 09:48:30',0,0,'Tournée Ronse 04','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(51,'TourneeRonse05',1,NULL,'2013-06-19 13:48:58','2013-06-19 09:48:58',0,0,'tournée ronse 05','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(52,'TourneeAnvers01',1,NULL,'2013-06-19 13:58:11','2013-06-19 09:58:11',0,0,'Tournée Anvers 01','','','',NULL,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(53,'TourneeAnvers02',1,NULL,'2013-06-19 13:58:51','2013-06-19 09:58:51',0,0,'Tournée Anvers 02','','','',NULL,155.00000000,187.55000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(54,'TourneeAnvers03',1,NULL,'2013-06-19 13:59:17','2013-06-19 09:59:17',0,0,'Tournée Anvers 03','','','',NULL,180.00000000,217.80000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(55,'TourneeAnvers04',1,NULL,'2013-06-19 13:59:42','2013-11-08 14:56:13',0,0,'Tournée Anvers 04','','','',NULL,125.00000000,151.25000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(56,'UrgPlus20kmzuinekerk',1,NULL,'2013-07-03 13:58:23','2013-07-03 09:58:23',0,0,'Courses Urgences zuinekerk','','','',2,0.55000000,0.66550000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,2,1,1,0,'',NULL,NULL,0,'','',NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0.00000000,'',1,0,NULL,0,NULL,0),(57,'Transport_18_palette',1,NULL,'2013-08-15 20:29:05','2013-08-15 16:39:33',0,0,'poid lourd','(Sint Niklas-genk)','','',2,240.00000000,290.40000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,2,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(58,'Enlèvement_objet_encombrant',1,NULL,'2013-08-15 20:37:58','2013-08-15 16:37:58',0,0,'Enlèvement objet encombrant','Place Roupe','','',2,1100.00000000,1331.00000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,2,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(59,'SOUTRAITANCE_DE_SERVICE',1,NULL,'2013-09-27 15:40:56','2013-11-07 16:14:24',0,0,'SOUTRAITANCE DE SERVICE','','','',2,1040.00000000,1258.40000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,2,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(60,'Enlèvement_objets_encombrant',1,NULL,'2013-09-29 19:23:30','2014-05-11 10:46:53',0,0,'Enlèvement objets encombrant','','','',2,400.00000000,484.00000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,2,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(61,'Loyer',1,NULL,'2013-10-23 14:03:58','2013-10-23 10:04:48',0,0,'Loyer','Adresse de Location:&nbsp; 15 Dorent , 1620 Drogenbos','','',NULL,1000.00000000,1210.00000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,2,1,1,0,'',NULL,NULL,0,'','',NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0.00000000,'',1,0,NULL,0,NULL,0),(62,'LIVRAISONS_Divers',1,NULL,'2013-11-12 16:36:27','2013-11-12 12:40:25',0,0,'LIVRAISONS Divers','Zuinekerke&nbsp; &amp; Brugges','','',2,370.00000000,447.70000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,2,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(63,'MAR-01',1,NULL,'2014-01-19 00:48:16','2014-01-18 20:48:16',0,0,'Marcinelle-01','Tournee Marcinelle 01','','',2,0.00000000,0.00000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,1,0,'',NULL,NULL,0,'','',NULL,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0.00000000,'',1,0,NULL,0,NULL,0),(64,'Km0.30',1,NULL,'2014-01-19 00:49:58','2014-01-18 21:06:26',0,0,'Caddy Km au prix de 0,40','Tarif au Km&nbsp;','','',NULL,0.30000000,0.36300000,0.30000000,0.36300000,'HT',21.000,0,0.000,0.000,5,1,1,0,'',NULL,NULL,0,'','',NULL,NULL,0,NULL,0,NULL,0,NULL,0,10000000,0.00000000,'',1,0,NULL,0,NULL,0),(65,'Km0.40',1,NULL,'2014-01-19 00:50:29','2014-01-18 21:05:59',0,0,'Camionette Hayon Km au prix de 0,40','','','',NULL,0.40000000,0.48400000,0.40000000,0.48400000,'HT',21.000,0,0.000,0.000,5,1,1,0,'',NULL,NULL,0,'','',NULL,NULL,0,NULL,0,NULL,0,NULL,0,10000000,0.00000000,'',1,0,NULL,0,NULL,0),(68,'Drop',1,NULL,'2014-01-19 00:58:39','2014-01-18 20:58:39',0,0,'Drop/Pickup','Drop&nbsp;','','',NULL,7.50000000,9.07500000,7.50000000,9.07500000,'HT',21.000,0,0.000,0.000,5,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(69,'Attente30min',1,NULL,'2014-01-19 01:07:41','2014-01-18 21:07:41',0,0,'Attente 30 min','','','',NULL,0.00000000,0.00000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,1,1,'0,50h',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(70,'Mar-01-Drop',1,NULL,'2014-01-23 15:50:15','2014-01-23 11:50:15',0,0,'Tournée Marcinelle  Drop','','','',NULL,7.50000000,9.07500000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(71,'Mar-01-km',1,NULL,'2014-01-23 15:50:42','2014-01-23 11:50:42',0,0,'Tournée Marcinelle  Km','','','',NULL,0.30000000,0.36300000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(72,'Ron-01-Drop',1,NULL,'2014-01-23 15:51:21','2014-01-23 11:51:21',0,0,'Tournée Ronse Drop','','','',NULL,7.50000000,9.07500000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(73,'Ron-01-Km',1,NULL,'2014-01-23 15:51:42','2014-01-23 11:51:42',0,0,'Tournée Ronse Km','','','',NULL,0.30000000,0.36300000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(74,'Liè-01-Drop',1,NULL,'2014-01-23 15:52:48','2014-01-23 11:52:48',0,0,'Torunée Liège Drop','','','',NULL,7.50000000,9.07500000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(75,'Liè-01-Km',1,NULL,'2014-01-23 15:53:08','2014-01-23 11:53:08',0,0,'Torunée Liège Km','','','',NULL,0.30000000,0.36300000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(76,'Gent-01-Drop',1,NULL,'2014-01-23 15:53:40','2014-06-16 10:23:59',0,0,'Tournée Gent Bruges Drop','','','',NULL,7.50000000,9.07500000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(77,'Gent-01-Km',1,NULL,'2014-01-23 15:54:12','2014-06-16 10:24:22',0,0,'Tournée Gent Bruges Km','','','',NULL,0.30000000,0.36300000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(78,'Eke-01-Drop',1,NULL,'2014-01-23 15:54:48','2014-01-23 11:54:48',0,0,'Tournée Ekeren Drop','','','',NULL,7.50000000,9.07500000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(79,'Eke-01-Km',1,NULL,'2014-01-23 15:55:19','2014-01-23 11:55:19',0,0,'Tournée Ekeren Km','','','',NULL,0.30000000,0.36300000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(80,'Brx-01-Drop',1,NULL,'2014-01-23 15:56:11','2014-01-23 11:57:57',0,0,'Tournées Bruxelles Drop','','','',NULL,7.50000000,9.07500000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(81,'Brx-01-Km',1,NULL,'2014-01-23 16:04:06','2014-01-23 12:04:06',0,0,'Tournée Bruxelles Km','','','',NULL,0.30000000,0.36300000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(82,'STR-01-Drop',1,NULL,'2014-01-23 16:06:16','2014-01-23 12:06:16',0,0,'Tournée Saint-Trond Drop','','','',NULL,7.50000000,9.07500000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(83,'STR-01-Km',1,NULL,'2014-01-23 16:06:32','2014-01-23 12:06:32',0,0,'Tournée Saint-Trond Km','','','',NULL,0.30000000,0.36300000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(84,'Zui-01-Drop',1,NULL,'2014-01-23 16:07:16','2014-01-23 12:07:16',0,0,'Tournée Zuinekercke Drop','','','',NULL,7.50000000,9.07500000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(85,'Zui-01-Km',1,NULL,'2014-01-23 16:07:47','2014-01-23 12:07:47',0,0,'Tournée Zuinekercke Km 0.30','','','',NULL,0.30000000,0.36300000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(86,'Zui-01-Km-Hay',1,NULL,'2014-01-23 16:08:13','2014-01-23 12:08:13',0,0,'Tournée Zuinekercke Km 0.40','','','',NULL,0.40000000,0.48400000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(87,'KMExpressSup20Km',1,NULL,'2014-02-04 15:09:56','2014-02-04 11:13:53',0,0,'KMExpress Supérieur à 20 km','','','',NULL,0.40000000,0.48400000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(88,'KmExpressINF20Km',1,NULL,'2014-02-04 15:10:37','2014-02-04 11:11:07',0,0,'Km Express Inférieur à 20 km','','','',NULL,8.00000000,9.68000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(89,'DropExpress',1,NULL,'2014-02-04 15:12:19','2014-02-04 11:13:30',0,0,'Drop Express','','','',NULL,8.00000000,9.68000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(90,'OrganisationMD',1,NULL,'2014-02-04 15:42:10','2014-02-04 11:42:10',0,0,'Organisatin Multi-Dose','Organisation Multidoses','','',NULL,1750.00000000,2117.50000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(91,'PDH-XX-Km',1,NULL,'2014-04-15 13:37:32','2014-04-15 09:40:57',0,0,'Tournées PDHX KM','','','',NULL,0.30000000,0.36300000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(93,'PDH-XX-Drop',1,NULL,'2014-04-15 13:40:08','2014-04-15 09:41:30',0,0,'Tournées PDHXX Drop','','','',NULL,7.50000000,9.07500000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(94,'Gent-XX-Km',1,NULL,'2014-04-15 14:40:39','2014-04-15 10:41:05',0,0,'Tournées Gent-XX KM','','','',NULL,0.30000000,0.36300000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(95,'Gent-XX-Drop',1,NULL,'2014-04-15 14:41:24','2014-04-15 10:41:37',0,0,'Tournées Gent-XX Drop','','','',NULL,7.50000000,9.07500000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(96,'Ronse-XX-Drop',1,NULL,'2014-04-15 14:45:00','2014-04-15 10:45:11',0,0,'Tournées Ronse-XX Drop','','','',NULL,7.50000000,9.07500000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(97,'Ronse-XX-Km',1,NULL,'2014-04-15 14:45:26','2014-04-15 10:45:36',0,0,'Tournées Ronse-XX KM','','','',NULL,0.30000000,0.36300000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(98,'Enlevement_Croix',1,NULL,'2014-05-11 14:18:15','2014-05-11 10:18:15',0,0,'Enlevement Croix','','','',NULL,350.00000000,423.50000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,2,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(99,'Enlevement_objet_encombran',1,NULL,'2014-06-03 12:41:28','2014-06-03 08:41:28',0,0,'Enlevement objet encombrant','','','',2,200.00000000,242.00000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,2,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(100,'Bruxelles_-_Genk',1,NULL,'2014-06-19 16:22:18','2014-06-19 12:29:17',0,0,'Bruxelles - Genk','240 Kilometres X 0.40 euros','','',NULL,96.00000000,116.16000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,4,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(101,'Main_d_oeuvre',1,NULL,'2014-06-19 16:22:58','2014-06-19 12:22:58',0,0,'Main d\'oeuvre','D&eacute;montage chambre froide + chargement','','',NULL,500.00000000,605.00000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,4,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(102,'Enlèvement_objets_encombrants',1,NULL,'2014-06-19 16:23:51','2014-06-19 12:23:51',0,0,'Enlèvement objets encombrants','Pharmacie Tiennen','','',NULL,700.00000000,847.00000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,4,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(103,'DX',1,NULL,'2014-10-06 16:05:34','2015-01-12 12:39:41',0,0,'Tri et Distribution BXL','','','',NULL,100.00000000,121.00000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,4,1,1,1,'',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0),(104,'TriManoeuvre',1,NULL,'2014-10-07 13:03:33','2014-10-07 09:03:33',0,0,'Tri & travail associé','','','',NULL,80.00000000,96.80000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,1,'1d',NULL,NULL,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00000000,'',0,0,NULL,0,NULL,0);

--
-- Table structure for table `am_product_association`
--

CREATE TABLE `am_product_association` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_product_pere` int(11) NOT NULL DEFAULT '0',
  `fk_product_fils` int(11) NOT NULL DEFAULT '0',
  `qty` double DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_association` (`fk_product_pere`,`fk_product_fils`),
  KEY `idx_product_association_fils` (`fk_product_fils`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_product_association`
--

INSERT INTO `am_product_association` VALUES (1,63,67,1),(2,63,66,1),(3,63,64,1),(4,63,68,1),(5,63,69,1);

--
-- Table structure for table `am_product_batch`
--

CREATE TABLE `am_product_batch` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_product_stock` int(11) NOT NULL,
  `eatby` datetime DEFAULT NULL,
  `sellby` datetime DEFAULT NULL,
  `batch` varchar(30) DEFAULT NULL,
  `qty` double NOT NULL DEFAULT '0',
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_fk_product_stock` (`fk_product_stock`),
  CONSTRAINT `fk_product_batch_fk_product_stock` FOREIGN KEY (`fk_product_stock`) REFERENCES `am_product_stock` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_product_batch`
--


--
-- Table structure for table `am_product_customer_price`
--

CREATE TABLE `am_product_customer_price` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_product` int(11) NOT NULL,
  `fk_soc` int(11) NOT NULL,
  `price` double(24,8) DEFAULT '0.00000000',
  `price_ttc` double(24,8) DEFAULT '0.00000000',
  `price_min` double(24,8) DEFAULT '0.00000000',
  `price_min_ttc` double(24,8) DEFAULT '0.00000000',
  `price_base_type` varchar(3) DEFAULT 'HT',
  `tva_tx` double(6,3) DEFAULT NULL,
  `recuperableonly` int(11) NOT NULL DEFAULT '0',
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `fk_user` int(11) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_customer_price_fk_product_fk_soc` (`fk_product`,`fk_soc`),
  KEY `idx_product_customer_price_fk_user` (`fk_user`),
  KEY `idx_product_customer_price_fk_soc` (`fk_soc`),
  CONSTRAINT `fk_customer_price_fk_product` FOREIGN KEY (`fk_product`) REFERENCES `am_product` (`rowid`),
  CONSTRAINT `fk_customer_price_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `am_societe` (`rowid`),
  CONSTRAINT `fk_product_customer_price_fk_user` FOREIGN KEY (`fk_user`) REFERENCES `am_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_product_customer_price`
--


--
-- Table structure for table `am_product_customer_price_log`
--

CREATE TABLE `am_product_customer_price_log` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `datec` datetime DEFAULT NULL,
  `fk_product` int(11) NOT NULL,
  `fk_soc` int(11) NOT NULL,
  `price` double(24,8) DEFAULT '0.00000000',
  `price_ttc` double(24,8) DEFAULT '0.00000000',
  `price_min` double(24,8) DEFAULT '0.00000000',
  `price_min_ttc` double(24,8) DEFAULT '0.00000000',
  `price_base_type` varchar(3) DEFAULT 'HT',
  `tva_tx` double(6,3) DEFAULT NULL,
  `recuperableonly` int(11) NOT NULL DEFAULT '0',
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `fk_user` int(11) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_product_customer_price_log`
--


--
-- Table structure for table `am_product_extrafields`
--

CREATE TABLE `am_product_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) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_product_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_product_extrafields`
--


--
-- Table structure for table `am_product_fournisseur_price`
--

CREATE TABLE `am_product_fournisseur_price` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_product` int(11) DEFAULT NULL,
  `fk_soc` int(11) DEFAULT NULL,
  `ref_fourn` varchar(30) DEFAULT NULL,
  `fk_availability` int(11) DEFAULT NULL,
  `price` double(24,8) DEFAULT '0.00000000',
  `quantity` double DEFAULT NULL,
  `remise_percent` double NOT NULL DEFAULT '0',
  `remise` double NOT NULL DEFAULT '0',
  `unitprice` double(24,8) DEFAULT '0.00000000',
  `charges` double(24,8) DEFAULT '0.00000000',
  `unitcharges` double(24,8) DEFAULT '0.00000000',
  `tva_tx` double(6,3) NOT NULL,
  `info_bits` int(11) NOT NULL DEFAULT '0',
  `fk_user` int(11) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_fournisseur_price_ref` (`ref_fourn`,`fk_soc`,`quantity`,`entity`),
  KEY `idx_product_fournisseur_price_fk_user` (`fk_user`),
  KEY `idx_product_fourn_price_fk_product` (`fk_product`,`entity`),
  KEY `idx_product_fourn_price_fk_soc` (`fk_soc`,`entity`),
  CONSTRAINT `fk_product_fournisseur_price_fk_product` FOREIGN KEY (`fk_product`) REFERENCES `am_product` (`rowid`),
  CONSTRAINT `fk_product_fournisseur_price_fk_user` FOREIGN KEY (`fk_user`) REFERENCES `am_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_product_fournisseur_price`
--


--
-- Table structure for table `am_product_fournisseur_price_log`
--

CREATE TABLE `am_product_fournisseur_price_log` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `datec` datetime DEFAULT NULL,
  `fk_product_fournisseur` int(11) NOT NULL,
  `price` double(24,8) DEFAULT '0.00000000',
  `quantity` double DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_product_fournisseur_price_log`
--


--
-- Table structure for table `am_product_lang`
--

CREATE TABLE `am_product_lang` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_product` int(11) NOT NULL DEFAULT '0',
  `lang` varchar(5) NOT NULL DEFAULT '0',
  `label` varchar(255) NOT NULL,
  `description` text,
  `note` text,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_product_lang` (`fk_product`,`lang`),
  CONSTRAINT `fk_product_lang_fk_product` FOREIGN KEY (`fk_product`) REFERENCES `am_product` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_product_lang`
--


--
-- Table structure for table `am_product_price`
--

CREATE TABLE `am_product_price` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) NOT NULL DEFAULT '1',
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `fk_product` int(11) NOT NULL,
  `date_price` datetime NOT NULL,
  `price_level` smallint(6) DEFAULT '1',
  `price` double(24,8) DEFAULT NULL,
  `price_ttc` double(24,8) DEFAULT NULL,
  `price_min` double(24,8) DEFAULT NULL,
  `price_min_ttc` double(24,8) DEFAULT NULL,
  `price_base_type` varchar(3) DEFAULT 'HT',
  `tva_tx` double(6,3) NOT NULL,
  `recuperableonly` int(11) NOT NULL DEFAULT '0',
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `fk_user_author` int(11) DEFAULT NULL,
  `tosell` tinyint(4) DEFAULT '1',
  `price_by_qty` int(11) NOT NULL DEFAULT '0',
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_product_price`
--

INSERT INTO `am_product_price` VALUES (1,1,'2013-06-18 11:35:38',1,'2013-06-18 15:35:38',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(2,1,'2013-06-18 11:36:17',2,'2013-06-18 15:36:17',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(3,1,'2013-06-18 11:36:40',3,'2013-06-18 15:36:40',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(4,1,'2013-06-18 11:37:00',4,'2013-06-18 15:37:00',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(5,1,'2013-06-18 11:37:29',5,'2013-06-18 15:37:29',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(6,1,'2013-06-18 11:38:37',6,'2013-06-18 15:38:37',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(7,1,'2013-06-18 11:38:57',7,'2013-06-18 15:38:57',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(8,1,'2013-06-18 11:39:24',8,'2013-06-18 15:39:24',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(9,1,'2013-06-18 11:39:47',9,'2013-06-18 15:39:47',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(10,1,'2013-06-18 11:40:10',10,'2013-06-18 15:40:10',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(11,1,'2013-06-18 11:41:12',11,'2013-06-18 15:41:12',1,150.00000000,181.50000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(12,1,'2013-06-18 11:41:39',12,'2013-06-18 15:41:39',1,140.00000000,169.40000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(13,1,'2013-06-18 11:42:14',13,'2013-06-18 15:42:14',1,140.00000000,169.40000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(14,1,'2013-06-18 11:42:37',14,'2013-06-18 15:42:37',1,140.00000000,169.40000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(15,1,'2013-06-18 11:43:01',15,'2013-06-18 15:43:01',1,140.00000000,169.40000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(16,1,'2013-06-19 08:47:19',16,'2013-06-19 12:47:19',1,180.00000000,217.80000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(17,1,'2013-06-19 08:47:46',17,'2013-06-19 12:47:46',1,180.00000000,217.80000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(18,1,'2013-06-19 08:47:58',16,'2013-06-19 12:47:58',1,165.00000000,199.65000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(19,1,'2013-06-19 08:48:22',18,'2013-06-19 12:48:22',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(20,1,'2013-06-19 08:49:04',19,'2013-06-19 12:49:04',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(21,1,'2013-06-19 08:49:32',20,'2013-06-19 12:49:32',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(22,1,'2013-06-19 08:50:16',21,'2013-06-19 12:50:16',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(23,1,'2013-06-19 08:50:36',22,'2013-06-19 12:50:36',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(24,1,'2013-06-19 08:50:59',23,'2013-06-19 12:50:59',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(25,1,'2013-06-19 08:51:20',24,'2013-06-19 12:51:20',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(26,1,'2013-06-19 08:51:40',25,'2013-06-19 12:51:40',1,100.00000000,121.00000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(27,1,'2013-06-19 08:52:09',26,'2013-06-19 12:52:09',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(28,1,'2013-06-19 08:52:29',27,'2013-06-19 12:52:29',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(29,1,'2013-06-19 08:52:52',28,'2013-06-19 12:52:52',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,0,0,NULL),(30,1,'2013-06-19 08:53:24',29,'2013-06-19 12:53:24',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(31,1,'2013-06-19 08:53:48',30,'2013-06-19 12:53:48',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(32,1,'2013-06-19 08:55:01',31,'2013-06-19 12:55:01',1,0.40000000,0.48400000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(33,1,'2013-06-19 08:55:50',32,'2013-06-19 12:55:50',1,0.40000000,0.48400000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(34,1,'2013-06-19 08:56:46',33,'2013-06-19 12:56:46',1,8.00000000,9.68000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(35,1,'2013-06-19 08:57:47',34,'2013-06-19 12:57:47',1,8.00000000,9.68000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(36,1,'2013-06-19 08:58:20',35,'2013-06-19 12:58:20',1,0.40000000,0.48400000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(37,1,'2013-06-19 09:05:04',36,'2013-06-19 13:05:04',1,8.00000000,9.68000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(38,1,'2013-06-19 09:07:01',37,'2013-06-19 13:07:01',1,0.40000000,0.48400000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(39,1,'2013-06-19 09:07:45',38,'2013-06-19 13:07:45',1,0.40000000,0.48400000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(40,1,'2013-06-19 09:09:03',38,'2013-06-19 13:09:03',1,8.00000000,9.68000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(41,1,'2013-06-19 09:09:27',39,'2013-06-19 13:09:27',1,0.40000000,0.48400000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(42,1,'2013-06-19 09:12:49',40,'2013-06-19 13:12:49',1,0.40000000,0.48400000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(43,1,'2013-06-19 09:14:47',41,'2013-06-19 13:14:47',1,8.00000000,9.68000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(44,1,'2013-06-19 09:15:25',42,'2013-06-19 13:15:25',1,120.00000000,145.20000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(45,1,'2013-06-19 09:16:44',43,'2013-06-19 13:16:44',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(46,1,'2013-06-19 09:29:00',44,'2013-06-19 13:29:00',1,0.00000000,0.00000000,0.00000000,0.00000000,'TTC',0.000,0,0.000,0.000,1,1,0,NULL),(47,1,'2013-06-19 09:31:23',45,'2013-06-19 13:31:23',1,75.00000000,90.75000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(48,1,'2013-06-19 09:33:17',46,'2013-06-19 13:33:17',1,3990.00000000,4827.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(49,1,'2013-06-19 09:46:55',47,'2013-06-19 13:46:55',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(50,1,'2013-06-19 09:47:38',48,'2013-06-19 13:47:38',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(51,1,'2013-06-19 09:48:04',49,'2013-06-19 13:48:04',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(52,1,'2013-06-19 09:48:30',50,'2013-06-19 13:48:30',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(53,1,'2013-06-19 09:48:58',51,'2013-06-19 13:48:58',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(54,1,'2013-06-19 09:58:11',52,'2013-06-19 13:58:11',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(55,1,'2013-06-19 09:58:51',53,'2013-06-19 13:58:51',1,155.00000000,187.55000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(56,1,'2013-06-19 09:59:17',54,'2013-06-19 13:59:17',1,180.00000000,217.80000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(57,1,'2013-06-19 09:59:42',55,'2013-06-19 13:59:42',1,190.00000000,229.90000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(58,1,'2013-06-19 10:23:54',7,'2013-06-19 14:23:54',1,130.00000000,157.30000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(59,1,'2013-06-19 11:09:32',26,'2013-06-19 15:09:32',1,120.00000000,145.20000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,1,1,0,NULL),(60,1,'2013-07-03 09:58:23',56,'2013-07-03 13:58:23',1,0.55000000,0.66550000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,2,1,0,NULL),(61,1,'2013-08-15 16:29:05',57,'2013-08-15 20:29:05',1,240.00000000,290.40000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,2,1,0,NULL),(62,1,'2013-08-15 16:37:58',58,'2013-08-15 20:37:58',1,1100.00000000,1331.00000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,2,1,0,NULL),(63,1,'2013-09-27 11:40:56',59,'2013-09-27 15:40:56',1,1250.00000000,1512.50000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,2,1,0,NULL),(64,1,'2013-09-29 15:23:30',60,'2013-09-29 19:23:30',1,1000.00000000,1210.00000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,2,1,0,NULL),(65,1,'2013-10-23 10:03:58',61,'2013-10-23 14:03:58',1,1000.00000000,1210.00000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,2,1,0,NULL),(66,1,'2013-11-07 16:14:24',59,'2013-11-07 20:14:24',1,1040.00000000,1258.40000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,2,1,0,NULL),(67,1,'2013-11-08 14:56:13',55,'2013-11-08 18:56:13',1,125.00000000,151.25000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,2,1,0,NULL),(68,1,'2013-11-12 12:36:27',62,'2013-11-12 16:36:27',1,370.00000000,447.70000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,2,1,0,NULL),(69,1,'2014-01-18 20:48:16',63,'2014-01-19 00:48:16',1,0.00000000,0.00000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(70,1,'2014-01-18 20:49:58',64,'2014-01-19 00:49:58',1,0.30000000,0.36300000,0.30000000,0.36300000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(71,1,'2014-01-18 20:50:29',65,'2014-01-19 00:50:29',1,0.40000000,0.48400000,0.40000000,0.48400000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(74,1,'2014-01-18 20:58:39',68,'2014-01-19 00:58:39',1,7.50000000,9.07500000,7.50000000,9.07500000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(75,1,'2014-01-18 21:07:41',69,'2014-01-19 01:07:41',1,0.00000000,0.00000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(76,1,'2014-01-23 11:50:15',70,'2014-01-23 15:50:15',1,7.50000000,9.07500000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(77,1,'2014-01-23 11:50:42',71,'2014-01-23 15:50:42',1,0.30000000,0.36300000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(78,1,'2014-01-23 11:51:21',72,'2014-01-23 15:51:21',1,7.50000000,9.07500000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(79,1,'2014-01-23 11:51:42',73,'2014-01-23 15:51:42',1,0.30000000,0.36300000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(80,1,'2014-01-23 11:52:48',74,'2014-01-23 15:52:48',1,7.50000000,9.07500000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(81,1,'2014-01-23 11:53:08',75,'2014-01-23 15:53:08',1,0.30000000,0.36300000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(82,1,'2014-01-23 11:53:40',76,'2014-01-23 15:53:40',1,7.50000000,9.07500000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(83,1,'2014-01-23 11:54:12',77,'2014-01-23 15:54:12',1,0.30000000,0.36300000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(84,1,'2014-01-23 11:54:48',78,'2014-01-23 15:54:48',1,7.50000000,9.07500000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(85,1,'2014-01-23 11:55:19',79,'2014-01-23 15:55:19',1,0.30000000,0.36300000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(86,1,'2014-01-23 11:56:11',80,'2014-01-23 15:56:11',1,0.00000000,0.00000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(87,1,'2014-01-23 11:57:57',80,'2014-01-23 15:57:57',1,7.50000000,9.07500000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(88,1,'2014-01-23 12:04:06',81,'2014-01-23 16:04:06',1,0.30000000,0.36300000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(89,1,'2014-01-23 12:06:16',82,'2014-01-23 16:06:16',1,7.50000000,9.07500000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(90,1,'2014-01-23 12:06:32',83,'2014-01-23 16:06:32',1,0.30000000,0.36300000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(91,1,'2014-01-23 12:07:16',84,'2014-01-23 16:07:16',1,7.50000000,9.07500000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(92,1,'2014-01-23 12:07:47',85,'2014-01-23 16:07:47',1,0.30000000,0.36300000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(93,1,'2014-01-23 12:08:13',86,'2014-01-23 16:08:13',1,0.40000000,0.48400000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(94,1,'2014-02-04 11:09:56',87,'2014-02-04 15:09:56',1,8.00000000,9.68000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(95,1,'2014-02-04 11:10:37',88,'2014-02-04 15:10:37',1,8.00000000,9.68000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,0,0,NULL),(96,1,'2014-02-04 11:11:56',87,'2014-02-04 15:11:56',1,0.40000000,0.48400000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(97,1,'2014-02-04 11:12:19',89,'2014-02-04 15:12:19',1,8.00000000,9.68000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(98,1,'2014-02-04 11:42:10',90,'2014-02-04 15:42:10',1,1750.00000000,2117.50000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,NULL),(99,1,'2014-04-15 09:37:32',91,'2014-04-15 13:37:32',1,0.30000000,0.36300000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,0,0,NULL),(103,1,'2014-04-15 09:40:08',93,'2014-04-15 13:40:08',1,7.50000000,9.07500000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,0,0,NULL),(104,1,'2014-04-15 10:40:39',94,'2014-04-15 14:40:39',1,0.30000000,0.36300000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,0,0,NULL),(105,1,'2014-04-15 10:41:24',95,'2014-04-15 14:41:24',1,7.50000000,9.07500000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,0,0,NULL),(106,1,'2014-04-15 10:45:00',96,'2014-04-15 14:45:00',1,7.50000000,9.07500000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,0,0,NULL),(107,1,'2014-04-15 10:45:26',97,'2014-04-15 14:45:26',1,0.30000000,0.36300000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,0,0,NULL),(108,1,'2014-05-11 10:18:15',98,'2014-05-11 14:18:15',1,350.00000000,423.50000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,2,1,0,NULL),(109,1,'2014-05-11 10:46:53',60,'2014-05-11 14:46:53',1,400.00000000,484.00000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,2,1,0,NULL),(110,1,'2014-06-03 08:41:28',99,'2014-06-03 12:41:28',1,200.00000000,242.00000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,2,1,0,NULL),(111,1,'2014-06-19 12:22:18',100,'2014-06-19 16:22:18',1,0.40000000,0.48400000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,4,1,0,NULL),(112,1,'2014-06-19 12:22:58',101,'2014-06-19 16:22:58',1,500.00000000,605.00000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,4,1,0,NULL),(113,1,'2014-06-19 12:23:51',102,'2014-06-19 16:23:51',1,700.00000000,847.00000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,4,1,0,NULL),(114,1,'2014-06-19 12:29:17',100,'2014-06-19 16:29:17',1,96.00000000,116.16000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,4,1,0,NULL),(115,1,'2014-10-06 12:05:34',103,'2014-10-06 16:05:34',1,100.00000000,121.00000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,4,1,0,NULL),(116,1,'2014-10-07 09:03:33',104,'2014-10-07 13:03:33',1,80.00000000,96.80000000,0.00000000,0.00000000,'HT',21.000,0,0.000,0.000,5,1,0,NULL);

--
-- Table structure for table `am_product_price_by_qty`
--

CREATE TABLE `am_product_price_by_qty` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_product_price` int(11) NOT NULL,
  `date_price` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `price` double(24,8) DEFAULT '0.00000000',
  `quantity` double DEFAULT NULL,
  `remise_percent` double NOT NULL DEFAULT '0',
  `remise` double NOT NULL DEFAULT '0',
  `unitprice` double(24,8) DEFAULT '0.00000000',
  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 `am_product_price` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_product_price_by_qty`
--


--
-- Table structure for table `am_product_stock`
--

CREATE TABLE `am_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,
  `pmp` double(24,8) NOT NULL DEFAULT '0.00000000',
  `import_key` varchar(14) 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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_product_stock`
--

INSERT INTO `am_product_stock` VALUES (1,'2014-01-18 21:05:59',65,1,10000000,0.00000000,NULL),(2,'2014-01-18 21:06:26',64,1,10000000,0.00000000,NULL);

--
-- Table structure for table `am_projet`
--

CREATE TABLE `am_projet` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_soc` int(11) DEFAULT NULL,
  `datec` date DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `dateo` date DEFAULT NULL,
  `datee` date DEFAULT NULL,
  `ref` varchar(50) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `title` varchar(255) NOT NULL,
  `description` text,
  `fk_user_creat` int(11) NOT NULL,
  `public` int(11) DEFAULT NULL,
  `fk_statut` smallint(6) NOT NULL DEFAULT '0',
  `note_private` text,
  `note_public` text,
  `model_pdf` varchar(255) 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 `am_societe` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_projet`
--


--
-- Table structure for table `am_projet_extrafields`
--

CREATE TABLE `am_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) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_projet_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_projet_extrafields`
--


--
-- Table structure for table `am_projet_task`
--

CREATE TABLE `am_projet_task` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(50) 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) NOT NULL,
  `description` text,
  `duration_effective` double NOT NULL DEFAULT '0',
  `planned_workload` double NOT NULL DEFAULT '0',
  `progress` int(11) DEFAULT '0',
  `priority` int(11) DEFAULT '0',
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_valid` int(11) DEFAULT NULL,
  `fk_statut` smallint(6) NOT NULL DEFAULT '0',
  `note_private` text,
  `note_public` text,
  `rang` int(11) DEFAULT '0',
  `model_pdf` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  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 `am_projet` (`rowid`),
  CONSTRAINT `fk_projet_task_fk_user_creat` FOREIGN KEY (`fk_user_creat`) REFERENCES `am_user` (`rowid`),
  CONSTRAINT `fk_projet_task_fk_user_valid` FOREIGN KEY (`fk_user_valid`) REFERENCES `am_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_projet_task`
--


--
-- Table structure for table `am_projet_task_extrafields`
--

CREATE TABLE `am_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) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_projet_task_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_projet_task_extrafields`
--


--
-- Table structure for table `am_projet_task_time`
--

CREATE TABLE `am_projet_task_time` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_task` int(11) NOT NULL,
  `task_date` date DEFAULT NULL,
  `task_duration` double DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  `thm` double(24,8) DEFAULT NULL,
  `note` text,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_projet_task_time`
--


--
-- Table structure for table `am_propal`
--

CREATE TABLE `am_propal` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(30) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `ref_ext` varchar(255) DEFAULT NULL,
  `ref_int` varchar(255) DEFAULT NULL,
  `ref_client` varchar(255) 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_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) DEFAULT NULL,
  `fk_cond_reglement` int(11) DEFAULT NULL,
  `fk_mode_reglement` int(11) DEFAULT NULL,
  `note_private` text,
  `note_public` text,
  `model_pdf` varchar(255) DEFAULT NULL,
  `date_livraison` date DEFAULT NULL,
  `fk_availability` int(11) DEFAULT NULL,
  `fk_input_reason` int(11) DEFAULT NULL,
  `import_key` varchar(14) DEFAULT NULL,
  `extraparams` varchar(255) DEFAULT NULL,
  `fk_delivery_address` int(11) DEFAULT NULL,
  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 `am_projet` (`rowid`),
  CONSTRAINT `fk_propal_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `am_societe` (`rowid`),
  CONSTRAINT `fk_propal_fk_user_author` FOREIGN KEY (`fk_user_author`) REFERENCES `am_user` (`rowid`),
  CONSTRAINT `fk_propal_fk_user_cloture` FOREIGN KEY (`fk_user_cloture`) REFERENCES `am_user` (`rowid`),
  CONSTRAINT `fk_propal_fk_user_valid` FOREIGN KEY (`fk_user_valid`) REFERENCES `am_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_propal`
--


--
-- Table structure for table `am_propal_extrafields`
--

CREATE TABLE `am_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) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_propal_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_propal_extrafields`
--


--
-- Table structure for table `am_propaldet`
--

CREATE TABLE `am_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) DEFAULT NULL,
  `description` text,
  `fk_remise_except` int(11) DEFAULT NULL,
  `tva_tx` double(6,3) DEFAULT '0.000',
  `localtax1_tx` double(6,3) DEFAULT '0.000',
  `localtax1_type` varchar(10) DEFAULT NULL,
  `localtax2_tx` double(6,3) DEFAULT '0.000',
  `localtax2_type` varchar(10) 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',
  PRIMARY KEY (`rowid`),
  KEY `idx_propaldet_fk_propal` (`fk_propal`),
  KEY `idx_propaldet_fk_product` (`fk_product`),
  CONSTRAINT `fk_propaldet_fk_propal` FOREIGN KEY (`fk_propal`) REFERENCES `am_propal` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_propaldet`
--


--
-- Table structure for table `am_propaldet_extrafields`
--

CREATE TABLE `am_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) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_propaldet_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_propaldet_extrafields`
--


--
-- Table structure for table `am_resource`
--

CREATE TABLE `am_resource` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `entity` int(11) DEFAULT NULL,
  `ref` varchar(255) DEFAULT NULL,
  `description` text,
  `fk_code_type_resource` varchar(32) DEFAULT NULL,
  `note_public` text,
  `note_private` text,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`rowid`),
  KEY `fk_code_type_resource_idx` (`fk_code_type_resource`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_resource`
--


--
-- Table structure for table `am_rights_def`
--

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

--
-- Dumping data for table `am_rights_def`
--



--
-- Table structure for table `am_societe`
--

CREATE TABLE `am_societe` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(60) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `ref_ext` varchar(128) DEFAULT NULL,
  `ref_int` varchar(60) DEFAULT NULL,
  `statut` tinyint(4) DEFAULT '0',
  `parent` int(11) DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datec` datetime DEFAULT NULL,
  `status` tinyint(4) DEFAULT '1',
  `code_client` varchar(24) DEFAULT NULL,
  `code_fournisseur` varchar(24) DEFAULT NULL,
  `code_compta` varchar(24) DEFAULT NULL,
  `code_compta_fournisseur` varchar(24) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `zip` varchar(25) DEFAULT NULL,
  `town` varchar(50) DEFAULT NULL,
  `fk_departement` int(11) DEFAULT '0',
  `fk_pays` int(11) DEFAULT '0',
  `phone` varchar(20) DEFAULT NULL,
  `fax` varchar(20) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `email` varchar(128) DEFAULT NULL,
  `skype` varchar(255) 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) DEFAULT NULL,
  `siren` varchar(128) DEFAULT NULL,
  `siret` varchar(128) DEFAULT NULL,
  `ape` varchar(128) DEFAULT NULL,
  `idprof4` varchar(128) DEFAULT NULL,
  `idprof5` varchar(128) DEFAULT NULL,
  `idprof6` varchar(128) DEFAULT NULL,
  `tva_intra` varchar(20) DEFAULT NULL,
  `capital` double DEFAULT NULL,
  `fk_stcomm` int(11) NOT NULL DEFAULT '0',
  `note_private` text,
  `note_public` text,
  `prefix_comm` varchar(5) DEFAULT NULL,
  `client` tinyint(4) DEFAULT '0',
  `fournisseur` tinyint(4) DEFAULT '0',
  `supplier_account` varchar(32) DEFAULT NULL,
  `fk_prospectlevel` varchar(12) DEFAULT NULL,
  `customer_bad` tinyint(4) DEFAULT '0',
  `customer_rate` double DEFAULT '0',
  `supplier_rate` double DEFAULT '0',
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `remise_client` double DEFAULT '0',
  `mode_reglement` tinyint(4) DEFAULT NULL,
  `cond_reglement` tinyint(4) DEFAULT NULL,
  `mode_reglement_supplier` int(11) DEFAULT NULL,
  `outstanding_limit` double(24,8) DEFAULT NULL,
  `cond_reglement_supplier` int(11) DEFAULT NULL,
  `tva_assuj` tinyint(4) DEFAULT '1',
  `localtax1_assuj` tinyint(4) DEFAULT '0',
  `localtax2_assuj` tinyint(4) DEFAULT '0',
  `barcode` varchar(255) DEFAULT NULL,
  `fk_barcode_type` int(11) DEFAULT '0',
  `price_level` int(11) DEFAULT NULL,
  `default_lang` varchar(6) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `canvas` varchar(32) DEFAULT NULL,
  `import_key` varchar(14) 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_barcode` (`barcode`,`fk_barcode_type`,`entity`),
  KEY `idx_societe_user_creat` (`fk_user_creat`),
  KEY `idx_societe_user_modif` (`fk_user_modif`),
  KEY `idx_societe_barcode` (`barcode`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_societe`
--

INSERT INTO `am_societe` VALUES (1,'Patrona Pharma Group',1,NULL,NULL,0,NULL,'2013-06-19 09:42:30','2013-06-19 13:34:58',1,'PATRONA PHARMA',NULL,NULL,NULL,'Avenue Henri Jaspar ,138','1060','Saint-Gilles',103,2,NULL,NULL,NULL,NULL,NULL,NULL,0,202,'0','','','','','','','be0859585888',0,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(2,'Winambi bvba',1,NULL,NULL,0,NULL,'2013-06-19 12:02:15','2013-06-19 13:36:44',1,'WINAMI',NULL,NULL,NULL,'edmond Machtens, 151','1080','Molenbeek Saint-Jean',103,2,NULL,NULL,NULL,NULL,NULL,NULL,0,201,'0','','','','','','','be0888700637',0,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(3,'Régie Des Bâtiments',1,NULL,NULL,0,NULL,'2013-06-19 09:37:44','2013-06-19 13:37:44',1,NULL,NULL,NULL,NULL,'Rue Jourdan , 95 bte 2','1060','Saint-Gilles',103,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,1,1,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(4,'AMIRA BEN TAHAR',1,NULL,NULL,0,NULL,'2013-09-27 11:30:07','2013-09-27 15:30:07',1,NULL,NULL,NULL,NULL,'RUE DES GRIOTTES 31','1180','UCCLE',103,2,NULL,NULL,NULL,NULL,NULL,NULL,2,200,'0','','','','','','','BE0874506963',0,0,NULL,NULL,NULL,0,1,NULL,NULL,0,0,0,2,2,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(5,'DELTA-RELAY SPRL',1,NULL,NULL,0,NULL,'2013-09-27 11:33:01','2013-09-27 15:33:01',1,NULL,NULL,NULL,NULL,'RUE DES GRIOTTES','1180','UCCLE',103,2,NULL,NULL,NULL,NULL,NULL,NULL,0,201,'0','','','','','','','BE0464107485',0,0,NULL,NULL,NULL,0,1,NULL,NULL,0,0,0,2,2,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(6,'Alphar Partners',1,NULL,NULL,0,NULL,'2013-09-29 14:26:16','2013-09-29 18:26:16',1,NULL,NULL,NULL,NULL,'18,rue du Fond du Mréchal','5020','Suarlée',0,2,'064679195','064679199',NULL,NULL,NULL,NULL,0,203,'0','','','','','','','BE0475639696',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,2,2,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(7,'Delta Relay Sprl',1,NULL,NULL,0,NULL,'2018-04-30 06:18:43','2013-09-29 18:43:02',1,NULL,NULL,NULL,NULL,'avenue Jupiter 178','1190','Forest',103,2,'484604852',NULL,NULL,'coralie@delta-relay.com',NULL,NULL,2,201,'0','','','','','','','BE0464107485',0,0,NULL,NULL,NULL,3,0,NULL,NULL,0,0,0,2,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(8,'AMIRA BEN TAHAR',1,NULL,NULL,0,NULL,'2013-09-29 14:45:37','2013-09-29 18:45:37',1,NULL,NULL,NULL,NULL,'Rue des Griottes 31','1180','UCCLE',103,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','Be0874506963',0,0,NULL,NULL,NULL,3,0,NULL,NULL,0,0,0,2,2,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(9,'Agence Immobilière Sociale Uccloise',1,NULL,NULL,0,NULL,'2013-11-27 09:24:19','2013-11-27 13:22:53',1,'A.I.S.U. - S.W.',NULL,NULL,NULL,'Rue Beeckman 89','1180','UCCLE',103,2,NULL,NULL,NULL,NULL,NULL,1,0,NULL,'0','','','','','','','be0469541069',0,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,2,2,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(10,'SA DPU BELGACOM',1,NULL,NULL,0,NULL,'2014-01-21 08:45:09','2014-01-21 12:45:08',1,NULL,'Belgacom',NULL,NULL,'Bvs du Roi Albert II 27B','1030','Schaerbeek',103,2,'+32080033500',NULL,NULL,NULL,NULL,NULL,2,202,'0','','','','','','','Be0202239951',0,0,NULL,NULL,NULL,0,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(11,'Walgraef',1,NULL,NULL,0,NULL,'2014-01-22 08:58:21','2014-01-22 12:58:21',1,NULL,NULL,NULL,NULL,'Tangedallaan 40','1850','grimbergen',105,2,NULL,NULL,NULL,NULL,NULL,1,8,NULL,'0','','','','','','','',0,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,5,5,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(12,'PSA FINANCE BELUX',1,NULL,NULL,0,NULL,'2014-01-23 07:41:50','2014-01-23 11:41:50',1,NULL,'479030',NULL,NULL,'Rue de l\'étoile 99','1180','UCCLE',103,2,'02/3707711',NULL,NULL,NULL,NULL,NULL,0,202,'0','','','','','','','be0417159386',0,0,NULL,NULL,NULL,0,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(13,'NV LANSON',1,NULL,NULL,0,NULL,'2014-01-23 11:26:20','2014-01-23 15:26:20',1,'34004',NULL,NULL,NULL,'Bollinckxstraat 15','1070','Anderlecht',103,2,'02/5225561','05/5225561',NULL,NULL,NULL,NULL,3,202,'0','','','','','','','be417915293',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(14,'ONSS',1,NULL,NULL,0,NULL,'2014-01-23 12:01:28','2014-01-23 16:01:28',1,NULL,NULL,NULL,NULL,'Place Victor Horta 11','1060','Saint-Gilles',103,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0,0,NULL,NULL,NULL,0,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(15,'MR Keymeulen',1,NULL,NULL,0,NULL,'2014-05-11 10:35:50','2014-05-11 14:35:50',1,NULL,NULL,NULL,NULL,'Rue Luciflore 19 bte 114','4300','Warem',0,2,NULL,NULL,NULL,NULL,NULL,NULL,8,NULL,'0','','','','','','','',0,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,2,2,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(16,'Mme Zaffenhaus',1,NULL,NULL,0,NULL,'2014-06-03 08:30:59','2014-06-03 12:30:59',1,NULL,NULL,NULL,NULL,'Wanderlaan 18','1800','Koningslo',0,2,NULL,NULL,NULL,NULL,NULL,1,8,NULL,'0','','','','','','','',0,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,2,2,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(17,'DE WOLF - DE GREEF BVBA',1,NULL,NULL,0,NULL,'2014-06-17 08:17:18','2014-06-17 11:50:58',1,NULL,NULL,NULL,NULL,'Lindenstraat 2','1742','Sint Katherina lombeek',0,2,'025826588',NULL,NULL,'gunther@dewolf-degreef.be',NULL,NULL,0,NULL,'0','','','','','','','0437099519',0,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(18,'AGC',1,NULL,NULL,0,NULL,'2014-07-23 09:48:06','2014-07-23 13:48:06',1,NULL,NULL,NULL,NULL,'place du manège 1','6000','Charleroi',0,2,'0486/309281',NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','0542694808',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(19,'SPRL LAKIS GROUP',1,NULL,NULL,0,NULL,'2014-09-22 07:34:05','2014-09-22 11:34:05',1,NULL,NULL,NULL,NULL,'Chaussée de Mons 57','1070','Anderlecht',103,2,'0477605549',NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(20,'Auto 7',1,NULL,NULL,0,NULL,'2014-09-22 07:45:19','2014-09-22 11:45:19',1,NULL,NULL,NULL,NULL,'Rue de Bourgogne 108','1180','UCCLE',103,2,NULL,NULL,NULL,'auto7.1620@gmail.com',NULL,NULL,0,NULL,'0','','','','','','','be0541743713',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(21,'Alya Group Services sprl',1,NULL,NULL,0,NULL,'2015-01-12 12:40:16','2014-10-06 16:02:08',1,'ALYA GROUP',NULL,NULL,NULL,'Rue dupont 6','1030','Schaerbeek',103,2,NULL,NULL,NULL,NULL,NULL,NULL,3,201,'0','','','','','','','BE0867416857 ',0,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(22,'P&P Logistiek VOF',1,NULL,NULL,0,NULL,'2014-10-07 07:48:55','2014-10-07 11:48:55',1,NULL,NULL,NULL,NULL,'Maretak 634','9250','Waasmunster',0,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','BE0842276932',0,0,NULL,NULL,NULL,1,0,NULL,NULL,0,0,0,5,5,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(23,'BAS Cleaning et services SPRL',1,NULL,NULL,0,NULL,'2014-10-23 11:08:09','2014-10-23 15:08:08',1,NULL,NULL,NULL,NULL,'Rue d Ellezelle, 145','9600','Ronse',0,2,'0484555614',NULL,NULL,'tunis.ian@hotmail.com',NULL,NULL,0,NULL,'0','','','','','','','BE 0500.850.590',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(24,'Zellik Pharma',1,NULL,NULL,0,NULL,'2015-01-15 11:47:13','2015-01-15 15:47:13',1,NULL,NULL,NULL,NULL,'Brusselsesteenweg 812','1731','Zellik',0,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','be 881 910 538',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(25,'Ali GAMADA',1,NULL,NULL,0,NULL,'2015-02-09 11:00:53','2015-02-09 15:00:53',1,NULL,NULL,NULL,NULL,'place du manège 1','6000','Charleroi',0,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(26,'arc\'s clean',1,NULL,NULL,0,NULL,'2015-02-09 11:32:19','2015-02-09 15:25:51',1,NULL,NULL,NULL,NULL,'rue du Village 63 bte 1','1070','Anderlecht',103,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','be0443695222',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(27,'De Meyst – Vanbellingen',1,NULL,NULL,0,NULL,'2015-02-16 09:31:22','2015-02-16 13:31:22',1,NULL,NULL,NULL,NULL,'Zagerijstraat 6 bus 3.02','3090','Overijse',103,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(28,'TESSOULI Abdel Aziz',1,NULL,NULL,0,NULL,'2015-03-02 09:14:43','2015-03-02 13:14:43',1,NULL,NULL,NULL,NULL,'Rue de la plume, 12','1000','Bruxelles',0,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0','','','','','','','',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(29,'PHARMA Force NV',1,NULL,NULL,0,NULL,'2015-11-03 11:38:52','2015-11-03 15:38:52',1,NULL,NULL,NULL,NULL,'Poortakkerstraat 41 G','9051','Sint denijs Westrem',0,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','be0859585888',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(30,'Kopczynski     Tomasz',1,NULL,NULL,0,NULL,'2015-11-10 13:40:28','2015-11-10 17:40:28',1,NULL,NULL,NULL,NULL,'89-50 Mosciska 43 Pologne',NULL,NULL,0,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(31,'ABEL TOITURE SPRL',1,NULL,NULL,0,NULL,'2016-02-18 08:50:32','2016-02-18 12:50:32',1,NULL,NULL,NULL,NULL,'rue de la grotte 15','1070','Anderlecht',0,2,NULL,NULL,NULL,'toiture.abel@gmail.com',NULL,NULL,0,NULL,NULL,'','','','','','','be0472173927',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(32,'Meddeb Mourad',1,NULL,NULL,0,NULL,'2016-02-25 11:40:37','2016-02-25 15:40:37',1,NULL,NULL,NULL,NULL,'Hastedon gardena 87','5002','St Servais',0,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(33,'LINE Risch',1,NULL,NULL,0,NULL,'2016-03-07 11:05:17','2016-03-07 15:05:17',1,NULL,NULL,NULL,NULL,'Rue Brogniez 189','1070','Anderlecht',0,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(34,'EAGLE EXPRESS',1,NULL,NULL,0,NULL,'2016-06-23 08:24:17','2016-06-23 12:24:17',1,NULL,NULL,NULL,NULL,'Chaussée d\'Alsemberg 842','1180','Uccle',0,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','0459.258.178',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(35,'ACTIUS Bvba',1,NULL,NULL,0,NULL,'2016-11-02 14:09:18','2016-11-02 18:09:18',1,NULL,NULL,NULL,NULL,'Rijksweg 10H bus 0-2','2880','Bornem',0,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','be0842276932',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(36,'ema Group',1,NULL,NULL,0,NULL,'2016-11-16 11:26:19','2016-11-16 15:26:19',1,NULL,NULL,NULL,NULL,'DE LIMBUG STIRUMLAAN 99/2','1780','Wemmel',0,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','BE 0533.756.85',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(37,'Hamza Salmi',1,NULL,NULL,0,NULL,'2016-12-19 10:20:35','2016-12-19 14:20:35',1,NULL,NULL,NULL,NULL,'rue de Merode 215','1060','st gilles',0,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(38,'Pharma 2 care',1,NULL,NULL,0,NULL,'2017-09-29 09:06:23','2017-09-29 13:06:23',1,NULL,NULL,NULL,NULL,'50 nieuwesesteenweg','8377','zuinnekerke',0,2,NULL,'0427391896',NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(39,'Innovative Pharma Partner',1,NULL,NULL,0,NULL,'2017-11-06 11:08:12','2017-11-06 15:08:12',1,NULL,NULL,NULL,NULL,'Nieuwe Steenweg 50','8377','zuinnekerke',0,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','	BE 0426.804.354 ',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(40,'NIEWIAROWSKI EUGENIUSZ',1,NULL,NULL,0,NULL,'2017-11-22 07:00:38','2017-11-22 11:00:38',1,NULL,NULL,NULL,NULL,'17-300 SIEMIATYCZE ULICA\r\nBARTOSZA GLOWACKIEGO 45',NULL,'pologne',0,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(41,'TYMOSIAK Sylwester',1,NULL,NULL,0,NULL,'2017-12-20 08:23:00','2017-12-20 12:23:00',1,NULL,NULL,NULL,NULL,'Malyszczyn 1\r\n17-315 GRODZISK\r\nPOLOGNE',NULL,NULL,0,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(42,'BEN TAHAR Amira',1,NULL,NULL,0,NULL,'2018-05-16 09:43:55','2018-05-16 11:43:55',1,NULL,NULL,NULL,NULL,'Rue des Griottes 31','1180','Uccle',0,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(43,'Ezzedine Ben MArzouk',1,NULL,NULL,0,NULL,'2018-05-16 10:41:19','2018-05-16 12:41:19',1,NULL,NULL,NULL,NULL,'Chaussée de Gand 253','1081','koekelberg',0,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(44,'MIROSLAW RADZISZEWSKI',1,NULL,NULL,0,NULL,'2018-09-21 06:04:09','2018-09-21 08:04:09',1,NULL,NULL,NULL,NULL,'MIROSLAW RADZISZEWSKI\r\n          OSNOWKA-WYREBY 27, \r\n          17-322 PERLEJEWO\r\n          POLOGNE',NULL,NULL,0,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(45,'PDS SA - CITROEN YSER',1,NULL,NULL,0,NULL,'2018-10-02 10:47:03','2018-10-02 12:47:02',1,NULL,NULL,NULL,NULL,'AVENUE JACQUES GEORGIN 15/19\r\n1030 SCHAERBEEK',NULL,NULL,0,2,NULL,NULL,NULL,'suzy.vandeput@citroen.com',NULL,NULL,0,NULL,NULL,'','','','','','','BE 0403.461.206',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(46,'PDS SA - CITROEN YSER',1,NULL,NULL,0,NULL,'2018-11-15 09:21:29','2018-11-15 10:21:29',1,NULL,NULL,NULL,NULL,'AVENUE JACQUES GEORGIN 15/19','1030','SCHAERBEEK',0,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','BE 0403.461.206',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(47,'KOLTUNIAK Tomasz Jerzy',1,NULL,NULL,0,NULL,'2018-12-12 07:12:22','2018-12-12 08:12:22',1,NULL,NULL,NULL,NULL,'11 LISTOPADA 170\r\n17-300 SIEMIATYCZE',NULL,'pologne',0,2,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','',0,0,NULL,NULL,NULL,3,1,NULL,NULL,0,0,0,4,4,0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `am_societe_address`
--

CREATE TABLE `am_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) DEFAULT NULL,
  `fk_soc` int(11) DEFAULT '0',
  `name` varchar(60) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `zip` varchar(10) DEFAULT NULL,
  `town` varchar(50) DEFAULT NULL,
  `fk_pays` int(11) DEFAULT '0',
  `phone` varchar(20) DEFAULT NULL,
  `fax` varchar(20) DEFAULT NULL,
  `note` text,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_societe_address`
--


--
-- Table structure for table `am_societe_commerciaux`
--

CREATE TABLE `am_societe_commerciaux` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_soc` int(11) DEFAULT NULL,
  `fk_user` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_societe_commerciaux` (`fk_soc`,`fk_user`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_societe_commerciaux`
--

INSERT INTO `am_societe_commerciaux` VALUES (1,1,1),(2,2,1),(3,3,1),(4,4,2),(5,5,2),(6,6,2),(7,7,2),(8,8,2),(9,9,2),(10,10,4),(11,11,5),(12,12,4),(13,13,4),(14,14,4),(15,15,2),(16,16,2),(17,17,4),(18,18,4),(19,19,4),(20,20,4),(21,21,4),(22,22,5),(23,23,4),(24,24,4),(25,25,4),(26,26,4),(27,27,4),(28,28,4),(29,29,4),(30,30,4),(31,31,4),(32,32,4),(33,33,4),(34,34,4),(35,35,4),(36,36,4),(37,37,4),(38,38,4),(39,39,4),(40,40,4),(41,41,4),(42,42,4),(43,43,4),(44,44,4),(45,45,4),(46,46,4),(47,47,4);

--
-- Table structure for table `am_societe_extrafields`
--

CREATE TABLE `am_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) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_societe_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_societe_extrafields`
--


--
-- Table structure for table `am_societe_log`
--

CREATE TABLE `am_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) DEFAULT NULL,
  `label` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_societe_log`
--


--
-- Table structure for table `am_societe_prices`
--

CREATE TABLE `am_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;

--
-- Dumping data for table `am_societe_prices`
--


--
-- Table structure for table `am_societe_remise`
--

CREATE TABLE `am_societe_remise` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_societe_remise`
--


--
-- Table structure for table `am_societe_remise_except`
--

CREATE TABLE `am_societe_remise_except` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_soc` int(11) NOT NULL,
  `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,
  `description` varchar(255) NOT NULL,
  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`),
  CONSTRAINT `fk_societe_remise_fk_facture` FOREIGN KEY (`fk_facture`) REFERENCES `am_facture` (`rowid`),
  CONSTRAINT `fk_societe_remise_fk_facture_line` FOREIGN KEY (`fk_facture_line`) REFERENCES `am_facturedet` (`rowid`),
  CONSTRAINT `fk_societe_remise_fk_facture_source` FOREIGN KEY (`fk_facture_source`) REFERENCES `am_facture` (`rowid`),
  CONSTRAINT `fk_societe_remise_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `am_societe` (`rowid`),
  CONSTRAINT `fk_societe_remise_fk_user` FOREIGN KEY (`fk_user`) REFERENCES `am_user` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_societe_remise_except`
--


--
-- Table structure for table `am_societe_rib`
--

CREATE TABLE `am_societe_rib` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_soc` int(11) NOT NULL,
  `datec` datetime DEFAULT NULL,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `label` varchar(30) DEFAULT NULL,
  `bank` varchar(255) DEFAULT NULL,
  `code_banque` varchar(7) DEFAULT NULL,
  `code_guichet` varchar(6) DEFAULT NULL,
  `number` varchar(255) DEFAULT NULL,
  `cle_rib` varchar(5) DEFAULT NULL,
  `bic` varchar(20) DEFAULT NULL,
  `iban_prefix` varchar(34) DEFAULT NULL,
  `domiciliation` varchar(255) DEFAULT NULL,
  `proprio` varchar(60) DEFAULT NULL,
  `owner_address` text,
  `default_rib` smallint(6) NOT NULL DEFAULT '0',
  `import_key` varchar(14) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_societe_rib`
--


--
-- Table structure for table `am_socpeople`
--

CREATE TABLE `am_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(128) DEFAULT NULL,
  `civilite` varchar(6) DEFAULT NULL,
  `lastname` varchar(50) DEFAULT NULL,
  `firstname` varchar(50) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `zip` varchar(10) DEFAULT NULL,
  `town` text,
  `fk_departement` int(11) DEFAULT NULL,
  `fk_pays` int(11) DEFAULT '0',
  `birthday` date DEFAULT NULL,
  `poste` varchar(80) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `phone_perso` varchar(30) DEFAULT NULL,
  `phone_mobile` varchar(30) DEFAULT NULL,
  `fax` varchar(30) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `jabberid` varchar(255) DEFAULT NULL,
  `skype` varchar(255) 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,
  `note_public` text,
  `default_lang` varchar(6) DEFAULT NULL,
  `canvas` varchar(32) DEFAULT NULL,
  `import_key` varchar(14) 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 `am_societe` (`rowid`),
  CONSTRAINT `fk_socpeople_user_creat_user_rowid` FOREIGN KEY (`fk_user_creat`) REFERENCES `am_user` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_socpeople`
--

INSERT INTO `am_socpeople` VALUES (1,'2014-01-22 12:58:21','2014-01-22 08:58:21',11,1,NULL,'MME','Walgraef','','Tangedallaan 40','1850','grimbergen',105,2,NULL,'','','','','','',NULL,NULL,0,0,5,5,NULL,NULL,NULL,NULL,NULL,1),(2,'2014-02-13 13:18:35','2014-02-13 09:18:35',1,1,NULL,'MR','Stroobants','Stefan','','','',NULL,2,NULL,'','','','','','stefan.stroobants@patrona.be','',NULL,0,0,5,5,'',NULL,NULL,NULL,NULL,1),(3,'2014-02-13 13:21:22','2014-02-13 09:21:22',1,1,NULL,'MR','Jacobs','Michael','','','',NULL,2,NULL,'','','','','','Michael.Jacobs@patrona.be','',NULL,0,0,5,5,'',NULL,NULL,NULL,NULL,1),(4,'2014-06-03 12:30:59','2014-06-03 08:30:59',16,1,NULL,'','Mme Zaffenhaus','','Wanderlaan 18','1800','Koningslo',NULL,2,NULL,'','','','','','',NULL,NULL,0,0,2,2,NULL,NULL,NULL,NULL,NULL,1),(5,'2014-10-07 13:15:05','2014-10-07 09:15:05',22,1,NULL,'MR','paul','Paul','','','',NULL,2,NULL,'','','','','','paul@pnplogistiek.be','',NULL,0,0,5,5,'',NULL,NULL,NULL,NULL,1),(6,'2014-11-03 13:47:14','2014-11-03 09:47:14',21,1,NULL,'','bessi','','','','',NULL,2,NULL,'','','','','','bessi.f@hotmail.com','',NULL,1,0,4,4,'',NULL,NULL,NULL,NULL,1),(7,'2015-01-15 15:48:38','2015-01-15 11:48:38',24,1,NULL,'','Zellik Pharma','','Brusselsesteenweg 812  ','1731','Zellik',NULL,2,NULL,'','','','','','Stefan.Stroobants@patrona.be','',NULL,0,0,4,4,'',NULL,NULL,NULL,NULL,1),(8,'2015-01-15 15:49:43','2015-01-15 11:49:43',24,1,NULL,'MR','Zellik Pharma','','Brusselsesteenweg 812 ','1731','Zellik',NULL,2,NULL,'','','','','','michael.jacobs@patrona.be','',NULL,0,0,4,4,'',NULL,NULL,NULL,NULL,1),(9,'2015-11-03 15:39:59','2015-11-03 11:39:59',29,1,NULL,'','Pharma Froce','','','','',NULL,2,NULL,'','','','','','michael.jacobs@patrona.be','','',0,0,4,4,'','',NULL,NULL,NULL,1),(10,'2015-11-03 15:40:22','2015-11-03 11:40:22',29,1,NULL,'','pharma Force','','','','',NULL,2,NULL,'','','','','','stefan.stroobants@patrona.be','','',0,0,4,4,'','',NULL,NULL,NULL,1);

--
-- Table structure for table `am_socpeople_extrafields`
--

CREATE TABLE `am_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) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_socpeople_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_socpeople_extrafields`
--


--
-- Table structure for table `am_stock_mouvement`
--

CREATE TABLE `am_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,
  `fk_entrepot` int(11) NOT NULL,
  `value` double DEFAULT NULL,
  `price` float(13,4) DEFAULT '0.0000',
  `type_mouvement` smallint(6) DEFAULT NULL,
  `fk_user_author` int(11) DEFAULT NULL,
  `label` varchar(128) DEFAULT NULL,
  `fk_origin` int(11) DEFAULT NULL,
  `origintype` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_stock_mouvement_fk_product` (`fk_product`),
  KEY `idx_stock_mouvement_fk_entrepot` (`fk_entrepot`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_stock_mouvement`
--

INSERT INTO `am_stock_mouvement` VALUES (1,'2014-01-18 21:05:59','2014-01-19 01:05:59',65,1,10000000,0.0000,0,5,'Km40',NULL,NULL),(2,'2014-01-18 21:06:26','2014-01-19 01:06:26',64,1,10000000,0.0000,0,5,'Km30',NULL,NULL);

--
-- Table structure for table `am_texts`
--

CREATE TABLE `am_texts` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `module` varchar(32) DEFAULT NULL,
  `typemodele` varchar(32) DEFAULT NULL,
  `sortorder` smallint(6) DEFAULT NULL,
  `private` smallint(6) NOT NULL DEFAULT '0',
  `fk_user` int(11) DEFAULT NULL,
  `title` varchar(128) DEFAULT NULL,
  `filename` varchar(128) DEFAULT NULL,
  `content` text,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_texts`
--


--
-- Table structure for table `am_tva`
--

CREATE TABLE `am_tva` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `tms` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `datep` date DEFAULT NULL,
  `datev` date DEFAULT NULL,
  `amount` double NOT NULL DEFAULT '0',
  `label` varchar(255) DEFAULT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `note` text,
  `fk_bank` int(11) DEFAULT NULL,
  `fk_user_creat` int(11) DEFAULT NULL,
  `fk_user_modif` int(11) DEFAULT NULL,
  `fk_typepayment` int(11) DEFAULT NULL,
  `num_payment` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_tva`
--


--
-- Table structure for table `am_user_alert`
--

CREATE TABLE `am_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;

--
-- Dumping data for table `am_user_alert`
--


--
-- Table structure for table `am_user_clicktodial`
--

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

--
-- Dumping data for table `am_user_clicktodial`
--


--
-- Table structure for table `am_user_extrafields`
--

CREATE TABLE `am_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) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `idx_user_extrafields` (`fk_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_user_extrafields`
--


--
-- Table structure for table `am_user_param`
--

CREATE TABLE `am_user_param` (
  `fk_user` int(11) NOT NULL,
  `entity` int(11) NOT NULL DEFAULT '1',
  `param` varchar(64) NOT NULL,
  `value` varchar(255) NOT NULL,
  UNIQUE KEY `uk_user_param` (`fk_user`,`param`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_user_param`
--


--
-- Table structure for table `am_user_rights`
--

CREATE TABLE `am_user_rights` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_user` int(11) NOT NULL,
  `fk_id` int(11) NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_user_rights` (`fk_user`,`fk_id`),
  CONSTRAINT `fk_user_rights_fk_user_user` FOREIGN KEY (`fk_user`) REFERENCES `am_user` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=1197 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_user_rights`
--

INSERT INTO `am_user_rights` VALUES (246,1,11),(239,1,12),(240,1,13),(242,1,14),(243,1,15),(245,1,16),(247,1,19),(376,1,21),(368,1,22),(370,1,24),(371,1,25),(373,1,26),(375,1,27),(377,1,28),(398,1,31),(395,1,32),(397,1,34),(399,1,38),(111,1,61),(108,1,62),(110,1,64),(112,1,67),(113,1,68),(155,1,81),(147,1,82),(149,1,84),(150,1,86),(152,1,87),(154,1,88),(156,1,89),(228,1,91),(225,1,92),(227,1,93),(229,1,94),(178,1,95),(179,1,96),(181,1,97),(182,1,98),(136,1,101),(131,1,102),(133,1,104),(134,1,105),(135,1,106),(137,1,109),(275,1,111),(266,1,112),(268,1,113),(270,1,114),(272,1,115),(274,1,116),(276,1,117),(383,1,121),(380,1,122),(382,1,125),(384,1,126),(235,1,151),(232,1,152),(234,1,153),(236,1,154),(82,1,161),(77,1,162),(79,1,163),(81,1,164),(83,1,165),(287,1,171),(284,1,172),(286,1,173),(288,1,178),(357,1,221),(354,1,222),(356,1,223),(358,1,229),(359,1,237),(360,1,238),(361,1,239),(403,1,241),(402,1,242),(404,1,243),(385,1,262),(391,1,281),(388,1,282),(390,1,283),(392,1,286),(1,1,341),(2,1,342),(3,1,343),(4,1,344),(104,1,531),(101,1,532),(103,1,534),(105,1,538),(280,1,701),(279,1,702),(281,1,703),(340,1,1001),(339,1,1002),(341,1,1003),(343,1,1004),(344,1,1005),(143,1,1101),(140,1,1102),(142,1,1104),(144,1,1109),(289,1,1181),(313,1,1182),(292,1,1183),(294,1,1184),(296,1,1185),(298,1,1186),(300,1,1187),(302,1,1188),(363,1,1201),(364,1,1202),(311,1,1231),(305,1,1232),(307,1,1233),(309,1,1234),(310,1,1235),(312,1,1236),(314,1,1237),(365,1,1251),(248,1,1321),(157,1,1421),(176,1,2501),(175,1,2503),(177,1,2515),(480,2,11),(481,2,12),(482,2,13),(483,2,14),(484,2,15),(485,2,16),(486,2,19),(515,2,21),(516,2,22),(517,2,24),(518,2,25),(519,2,26),(520,2,27),(521,2,28),(540,2,31),(541,2,32),(542,2,34),(543,2,38),(488,2,61),(489,2,62),(490,2,64),(491,2,67),(492,2,68),(449,2,81),(450,2,82),(451,2,84),(452,2,86),(453,2,87),(454,2,88),(455,2,89),(536,2,91),(537,2,92),(538,2,93),(539,2,94),(457,2,95),(458,2,96),(459,2,97),(460,2,98),(470,2,101),(471,2,102),(472,2,104),(473,2,105),(474,2,106),(475,2,109),(439,2,111),(440,2,112),(441,2,113),(442,2,114),(443,2,115),(444,2,116),(445,2,117),(522,2,121),(523,2,122),(524,2,125),(525,2,126),(544,2,151),(545,2,152),(546,2,153),(547,2,154),(461,2,161),(462,2,162),(463,2,163),(464,2,164),(465,2,165),(466,2,171),(467,2,172),(468,2,173),(469,2,178),(508,2,221),(509,2,222),(510,2,223),(511,2,229),(512,2,237),(513,2,238),(514,2,239),(446,2,241),(447,2,242),(448,2,243),(526,2,262),(527,2,281),(528,2,282),(529,2,283),(530,2,286),(423,2,341),(424,2,342),(425,2,343),(426,2,344),(548,2,531),(549,2,532),(550,2,534),(551,2,538),(428,2,701),(531,2,1001),(532,2,1002),(533,2,1003),(534,2,1004),(535,2,1005),(476,2,1101),(477,2,1102),(478,2,1104),(479,2,1109),(493,2,1181),(494,2,1182),(495,2,1183),(496,2,1184),(497,2,1185),(498,2,1186),(499,2,1187),(500,2,1188),(434,2,1201),(501,2,1231),(502,2,1232),(503,2,1233),(504,2,1234),(505,2,1235),(506,2,1236),(507,2,1237),(487,2,1321),(456,2,1421),(436,2,2501),(437,2,2503),(438,2,2515),(700,3,11),(701,3,12),(702,3,13),(703,3,14),(704,3,15),(705,3,16),(706,3,19),(671,3,21),(672,3,22),(673,3,24),(674,3,25),(675,3,26),(676,3,27),(677,3,28),(667,3,31),(668,3,32),(669,3,34),(670,3,38),(635,3,61),(636,3,62),(637,3,64),(638,3,67),(639,3,68),(596,3,81),(597,3,82),(598,3,84),(599,3,86),(600,3,87),(601,3,88),(602,3,89),(696,3,91),(697,3,92),(698,3,93),(699,3,94),(604,3,95),(605,3,96),(606,3,97),(607,3,98),(623,3,101),(624,3,102),(625,3,104),(626,3,105),(627,3,106),(628,3,109),(586,3,111),(587,3,112),(588,3,113),(589,3,114),(590,3,115),(591,3,116),(592,3,117),(682,3,121),(683,3,122),(684,3,125),(685,3,126),(663,3,151),(664,3,152),(665,3,153),(666,3,154),(608,3,161),(609,3,162),(610,3,163),(611,3,164),(612,3,165),(613,3,171),(614,3,172),(615,3,173),(616,3,178),(656,3,221),(657,3,222),(658,3,223),(659,3,229),(660,3,237),(661,3,238),(662,3,239),(593,3,241),(594,3,242),(595,3,243),(686,3,262),(687,3,281),(688,3,282),(689,3,283),(690,3,286),(570,3,341),(571,3,342),(572,3,343),(573,3,344),(678,3,531),(679,3,532),(680,3,534),(681,3,538),(617,3,701),(618,3,702),(619,3,703),(691,3,1001),(692,3,1002),(693,3,1003),(694,3,1004),(695,3,1005),(629,3,1101),(630,3,1102),(631,3,1104),(632,3,1109),(640,3,1181),(641,3,1182),(642,3,1183),(643,3,1184),(644,3,1185),(645,3,1186),(646,3,1187),(647,3,1188),(633,3,1201),(634,3,1202),(648,3,1231),(649,3,1232),(650,3,1233),(651,3,1234),(652,3,1235),(653,3,1236),(654,3,1237),(655,3,1251),(707,3,1321),(603,3,1421),(620,3,2501),(621,3,2503),(622,3,2515),(788,4,11),(789,4,12),(790,4,13),(791,4,14),(792,4,15),(793,4,16),(794,4,19),(821,4,21),(822,4,22),(823,4,24),(824,4,25),(825,4,26),(826,4,27),(827,4,28),(817,4,31),(818,4,32),(819,4,34),(820,4,38),(796,4,61),(797,4,62),(798,4,64),(799,4,67),(800,4,68),(752,4,81),(753,4,82),(754,4,84),(755,4,86),(756,4,87),(757,4,88),(758,4,89),(837,4,91),(838,4,92),(839,4,93),(840,4,94),(760,4,95),(761,4,96),(762,4,97),(763,4,98),(776,4,101),(777,4,102),(778,4,104),(779,4,105),(780,4,106),(781,4,109),(742,4,111),(743,4,112),(744,4,113),(745,4,114),(746,4,115),(747,4,116),(748,4,117),(841,4,121),(842,4,122),(843,4,125),(844,4,126),(850,4,151),(851,4,152),(852,4,153),(853,4,154),(764,4,161),(765,4,162),(766,4,163),(767,4,164),(768,4,165),(769,4,171),(770,4,172),(771,4,173),(772,4,178),(854,4,221),(855,4,222),(856,4,223),(857,4,229),(858,4,237),(859,4,238),(860,4,239),(749,4,241),(750,4,242),(751,4,243),(845,4,262),(846,4,281),(847,4,282),(848,4,283),(849,4,286),(726,4,341),(727,4,342),(728,4,343),(729,4,344),(828,4,531),(829,4,532),(830,4,534),(831,4,538),(773,4,701),(774,4,702),(775,4,703),(832,4,1001),(833,4,1002),(834,4,1003),(835,4,1004),(836,4,1005),(782,4,1101),(783,4,1102),(784,4,1104),(785,4,1109),(801,4,1181),(802,4,1182),(803,4,1183),(804,4,1184),(805,4,1185),(806,4,1186),(807,4,1187),(808,4,1188),(786,4,1201),(787,4,1202),(809,4,1231),(810,4,1232),(811,4,1233),(812,4,1234),(813,4,1235),(814,4,1236),(815,4,1237),(816,4,1251),(795,4,1321),(759,4,1421),(739,4,2501),(740,4,2503),(741,4,2515),(997,5,11),(998,5,12),(999,5,13),(1000,5,14),(1001,5,15),(1002,5,16),(1003,5,19),(961,5,21),(962,5,22),(963,5,24),(964,5,25),(965,5,26),(966,5,27),(967,5,28),(1005,5,31),(1006,5,32),(1007,5,34),(1008,5,38),(864,5,61),(905,5,81),(906,5,82),(907,5,84),(908,5,86),(909,5,87),(910,5,88),(911,5,89),(986,5,91),(987,5,92),(988,5,93),(989,5,94),(913,5,95),(914,5,96),(915,5,97),(916,5,98),(929,5,101),(930,5,102),(931,5,104),(932,5,105),(933,5,106),(934,5,109),(895,5,111),(896,5,112),(897,5,113),(898,5,114),(899,5,115),(900,5,116),(901,5,117),(972,5,121),(973,5,122),(974,5,125),(975,5,126),(957,5,151),(958,5,152),(959,5,153),(960,5,154),(917,5,161),(918,5,162),(919,5,163),(920,5,164),(921,5,165),(922,5,171),(923,5,172),(924,5,173),(925,5,178),(990,5,221),(991,5,222),(992,5,223),(993,5,229),(994,5,237),(995,5,238),(996,5,239),(902,5,241),(903,5,242),(904,5,243),(976,5,262),(977,5,281),(978,5,282),(979,5,283),(980,5,286),(879,5,341),(880,5,342),(881,5,343),(882,5,344),(968,5,531),(969,5,532),(970,5,534),(971,5,538),(926,5,701),(927,5,702),(928,5,703),(981,5,1001),(982,5,1002),(983,5,1003),(984,5,1004),(985,5,1005),(935,5,1101),(936,5,1102),(937,5,1104),(938,5,1109),(941,5,1181),(942,5,1182),(943,5,1183),(944,5,1184),(945,5,1185),(946,5,1186),(947,5,1187),(948,5,1188),(939,5,1201),(940,5,1202),(949,5,1231),(950,5,1232),(951,5,1233),(952,5,1234),(953,5,1235),(954,5,1236),(955,5,1237),(956,5,1251),(1004,5,1321),(912,5,1421),(892,5,2501),(893,5,2503),(894,5,2515),(1087,6,11),(1088,6,12),(1089,6,13),(1090,6,14),(1091,6,15),(1092,6,16),(1093,6,19),(1127,6,21),(1128,6,22),(1129,6,24),(1130,6,25),(1131,6,26),(1132,6,27),(1133,6,28),(1134,6,31),(1135,6,32),(1136,6,34),(1137,6,38),(1149,6,61),(1150,6,62),(1151,6,64),(1152,6,67),(1153,6,68),(1053,6,81),(1054,6,82),(1055,6,84),(1056,6,86),(1057,6,87),(1058,6,88),(1059,6,89),(1159,6,91),(1160,6,92),(1161,6,93),(1162,6,94),(1061,6,95),(1062,6,96),(1063,6,97),(1064,6,98),(1077,6,101),(1078,6,102),(1079,6,104),(1080,6,105),(1081,6,106),(1082,6,109),(1043,6,111),(1044,6,112),(1045,6,113),(1046,6,114),(1047,6,115),(1048,6,116),(1049,6,117),(1118,6,121),(1119,6,122),(1120,6,125),(1121,6,126),(1110,6,151),(1111,6,152),(1112,6,153),(1113,6,154),(1065,6,161),(1066,6,162),(1067,6,163),(1068,6,164),(1069,6,165),(1070,6,171),(1071,6,172),(1072,6,173),(1073,6,178),(1138,6,221),(1139,6,222),(1140,6,223),(1141,6,229),(1142,6,237),(1143,6,238),(1144,6,239),(1050,6,241),(1051,6,242),(1052,6,243),(1122,6,262),(1123,6,281),(1124,6,282),(1125,6,283),(1126,6,286),(1027,6,341),(1028,6,342),(1029,6,343),(1030,6,344),(1145,6,531),(1146,6,532),(1147,6,534),(1148,6,538),(1074,6,701),(1075,6,702),(1076,6,703),(1154,6,1001),(1155,6,1002),(1156,6,1003),(1157,6,1004),(1158,6,1005),(1083,6,1101),(1084,6,1102),(1085,6,1104),(1086,6,1109),(1095,6,1181),(1096,6,1182),(1097,6,1183),(1098,6,1184),(1099,6,1185),(1100,6,1186),(1101,6,1187),(1102,6,1188),(1038,6,1201),(1103,6,1231),(1104,6,1232),(1105,6,1233),(1106,6,1234),(1107,6,1235),(1108,6,1236),(1109,6,1237),(1094,6,1321),(1060,6,1421),(1040,6,2501),(1041,6,2503),(1042,6,2515),(1163,7,11),(1164,7,21),(1165,7,31),(1166,7,61),(1167,7,81),(1168,7,91),(1169,7,95),(1170,7,97),(1171,7,101),(1172,7,111),(1173,7,121),(1174,7,151),(1175,7,161),(1176,7,171),(1177,7,221),(1178,7,241),(1179,7,262),(1180,7,281),(1181,7,341),(1182,7,342),(1183,7,343),(1184,7,344),(1185,7,531),(1186,7,701),(1187,7,1001),(1188,7,1004),(1189,7,1101),(1190,7,1181),(1191,7,1182),(1192,7,1201),(1193,7,1231),(1194,7,2501),(1195,7,2503),(1196,7,2515);

--
-- Table structure for table `am_usergroup`
--

CREATE TABLE `am_usergroup` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) 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,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `uk_usergroup_name` (`nom`,`entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_usergroup`
--


--
-- Table structure for table `am_usergroup_rights`
--

CREATE TABLE `am_usergroup_rights` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_usergroup` int(11) NOT NULL,
  `fk_id` int(11) NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `fk_usergroup` (`fk_usergroup`,`fk_id`),
  CONSTRAINT `fk_usergroup_rights_fk_usergroup` FOREIGN KEY (`fk_usergroup`) REFERENCES `am_usergroup` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_usergroup_rights`
--


--
-- Table structure for table `am_usergroup_user`
--

CREATE TABLE `am_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 `am_user` (`rowid`),
  CONSTRAINT `fk_usergroup_user_fk_usergroup` FOREIGN KEY (`fk_usergroup`) REFERENCES `am_usergroup` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `am_usergroup_user`
--



