--
-- Host: 127.0.0.1    Database: edcollectivite
-- ------------------------------------------------------


--
-- Table structure for table `Activity`
--

CREATE TABLE `Activity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `date` datetime NOT NULL,
  `repasMidi` tinyint(1) DEFAULT NULL,
  `repasSoir` tinyint(1) DEFAULT NULL,
  `hotel` tinyint(1) DEFAULT NULL,
  `kmParcouru` double NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_55026B0CA76ED395` (`user_id`),
  CONSTRAINT `FK_55026B0CA76ED395` FOREIGN KEY (`user_id`) REFERENCES `fos_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Activity`
--

INSERT INTO `Activity` VALUES (1,1,'2015-06-17 00:00:00',1,1,1,285);

--
-- Table structure for table `Article`
--

CREATE TABLE `Article` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `designation` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `prix` double NOT NULL,
  `unite` int(11) NOT NULL,
  `fournisseur` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `tva` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Article`
--

INSERT INTO `Article` VALUES (1,'101','DESHERBANT TOTAL PJT',63.3,2,'QUATRIS',20),(2,'207','OMPS CONTENEUR',78.6,2,'QUATRIS',20),(3,'203','DETERGENT SOLLO E50',25.1,2,'QUATRIS',20),(4,'401','RATICIDE PRO BLE',49,1,'QUATRIS',20),(5,'502-1','TRACING BLANC',69.2,3,'KILOUTOU',20),(8,'409','REPULSIF R.P PRO',49.3,2,'PEF DISTRIBUTION',20),(10,'402','RATICIDE PRO BLOC',59.75,1,'QUATRIS',20),(11,'102','DEVATOL PJT',145.2,2,'PUTEAUX SA',20),(12,'103','GARDENET GRANULE',83.4,1,'PUTEAUX SA',20),(13,'104','FLORANID GAZON',35.97,1,'PUTEAUX SA',20),(14,'105','FERTIL LIQUID',40.7,2,'PUTEAUX SA',20),(15,'106','FLORADUR A',9.9,2,'PUTEAUX SA',20),(17,'108','DESHERBEUR ECOLOGIQUE',159.4,3,'JARDILAND',20),(18,'107','STADOR BLANC',27.2,1,'SELVES',20),(19,'109','DESHERBINET',63.8,3,'POLE VERT',20),(20,'110','KIT PHYTOSANITAIRE',199.9,3,'POLE VERT',20),(21,'111','INDICATEUR PFC',226.3,2,'PUTEAUX SA',20),(22,'201','DESODORISANT',44.6,3,'THOUY',20),(23,'201-1','DESODORISANT MENTHE BACTERICIDE',44.6,3,'THOUY',20),(24,'201-2','DESODORISANT FLEURS BLANCHES',44.6,3,'THOUY',20),(25,'201-3','DESODORISANT CITRON',44.6,3,'THOUY',20),(26,'201-4','DESODORISANT MANDARINE',44.6,3,'THOUY',20),(27,'201-5','DESODORISANT FRUITS ROUGES',44.6,3,'THOUY',20),(28,'202-1','ONE SHOT BACTERICIDE',80.15,3,'THOUY',20),(29,'202-2','ONE SHOT INSECTICIDE',84.2,3,'THOUY',20),(30,'204','DETERGENT SOLLO C60',29.2,2,'QUATRIS',20),(31,'205','DETERGENT ECOLABEL',37.2,2,'THOUY',20),(32,'206','BRINOX',41.2,2,'QUATRIS',20),(33,'211','SAVON MICROBILLES',39.7,2,'QUATRIS',20),(34,'507-7-1','ANTIROUILLE VERT RAL 6005',126.4,2,'SELVES',20),(35,'508-1','LASURE BOIS CHÊNE CLAIR',106.1,2,'SELVES',20),(36,'403-1','INSECTICIDE SGF',61.4,3,'THOUY',20),(37,'1000','BALAI PLAT 60CM',0,3,'THOUY',20),(38,'408','REPULSIF R.CC',59.3,2,'QUATRIS',20),(39,'214','GEL WC ECOLOGIQUE',30.9,2,'THOUY',20),(40,'301','ANTIMOUSSE ECO',29.9,2,'QUATRIS',20),(41,'212','SAVON NACREE',22.34,2,'THOUY',20),(42,'602','DISTRIBUTEUR DE SAVON',0,3,'THOUY',20),(43,'502-3','TRACING JAUNE',69.2,3,'KILOUTOU',20),(44,'306','TRAITEMENT MVS',9.9,1,'KILOUTOU',20),(45,'1001','CANNE DE TRACAGE',0,3,'KILOUTOU',20),(46,'305','SUPER ABSORBANT',11.35,1,'QUATRIS',20),(47,'304','DEVERGLACANT P',10.7,1,'QUATRIS',20),(48,'213','GEL HYDROALCOOLIQUE',67.6,2,'THOUY',20),(49,'404','INSECTICIDE BARRAGE',53.8,2,'PEF DISTRIBUTION',20),(50,'216','DEBOUCHEUR PUISSANT',46.2,2,'QUATRIS',20),(51,'601-0','POSTE D\'APPATAGE',0,3,'AEDES',20),(52,'217','TARAX - TRAITEMENT FOSSE',14.71,3,'LECLERC',20),(53,'402-SP','RATICIDE BLOC PRO',59.9,1,'QUATRIS',20),(54,'606-0','SECHE MAIN ELECTRIQUE',0,3,'THOUY',20),(55,'504-V','PEGAKOTE VERT RAL 6005',118.2,1,'SELVES',20),(56,'210','VAISSELLE BRIO',29.44,2,'THOUY',20),(57,'001','PROJAV',9.1,2,'LE CARRE FARRAGO',20),(58,'002','PROTECTAG',88.8,2,'QUATRIS',20),(59,'205-1','DEGRAISSANT ECOLABEL',39.2,2,'QUATRIS',20),(60,'604-0','PULVERISATEUR 12 LITRES',0,3,'BRICO DEPOT',20),(61,'215','PASTILLES URINOIRS',2.15,3,'THOUY',20),(62,'510','DILUANT NETTOYANT',31.2,2,'SELVES',20),(63,'308','DEGRIP\'LUB',34.2,3,'QUATRIS',20),(64,'307','RESINET',38.7,2,'QUATRIS',20),(65,'501-1','PEINTURE TYPHON BLANC',39.6,1,'QUATRIS',20),(66,'403-3','INSECTICIDE SIR',68.25,3,'THOUY',20),(67,'204','DETERGENT SOLLO C60',29.2,2,'QUATRIS',20),(68,'602-0','PULVERISATEUR 1 LITRE',0,3,'POLE VERT',20),(69,'1002','PULVERISATEUR 16 LITRES',0,3,'POLE VERT',20),(70,'603-0','PULVERISATEUR 5 LITRES',0,3,'POLE VERT',20),(71,'303','DECAPANT SCALP SD',54.35,1,'SELVES',20);

--
-- Table structure for table `BonLivraison`
--

CREATE TABLE `BonLivraison` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `date_bl` datetime NOT NULL,
  `date_bc` datetime NOT NULL,
  `date_facturation` datetime NOT NULL,
  `date_livraison` datetime NOT NULL,
  `status` int(11) NOT NULL,
  `date_reglement` datetime NOT NULL,
  `numeroBl` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `numero_bc` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `uniteTotal` int(11) NOT NULL,
  `kgTotal` double NOT NULL,
  `quantiteTotal` double NOT NULL,
  `litreTotal` double NOT NULL,
  `client_ville` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `client_code_postal` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `client_nombre_habitants` int(11) NOT NULL,
  `client_nom_maire` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `client_contact_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `client_contact_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `client_contact_3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `client_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `client_position` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `client_societe` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `num_vendeur` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nom_vendeur` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_697BB02FFF5D922B` (`numeroBl`),
  UNIQUE KEY `UNIQ_697BB02F20876610` (`numero_bc`),
  KEY `IDX_697BB02F19EB6921` (`client_id`),
  CONSTRAINT `FK_697BB02F19EB6921` FOREIGN KEY (`client_id`) REFERENCES `Client` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `BonLivraison`
--

INSERT INTO `BonLivraison` VALUES (7,6,'2015-05-07 00:00:00','2015-04-29 00:00:00','2015-05-11 00:00:00','2015-05-07 00:00:00',3,'2015-06-10 00:00:00','39450','00591',0,0,2,8,'ROQUETAILLADE','11300',192,'SIRET jean','Mairie 04 68 31 50 27\r\nPerso 04 68 31 23 25\r\nPort 06 29 97 20 89','Empl. ROMERO\r\n07 61 51 63 33',NULL,'mairie-roquetaillade@orange.fr','GA 37','MAIRIE DE ROQUETAILLADE','37+39',NULL),(8,7,'2015-05-13 00:00:00','2015-04-30 00:00:00','2015-05-18 00:00:00','2015-05-13 00:00:00',3,'2015-06-17 00:00:00','39451','00621',0,0,1,5,'MAIRIE DE TRILLA','66220',54,'FOURCADE didier','Mairie 04 68 59 00 91\r\nPerso 04 68 59 07 23\r\nPort 06 84 31 60 34',NULL,NULL,'mairietrilla@orange.fr','HA 39','MAIRIE DE TRILLA','37+39',NULL),(9,8,'2015-05-13 00:00:00','2015-04-28 00:00:00','2015-05-17 00:00:00','2015-05-13 00:00:00',3,'2015-06-17 00:00:00','39452','00589',0,0,1,5,'APPELLE','81700',71,'POUYANNE christophe','Mairie 05 63 75 06 00\r\nPerso 05 63 75 08 39',NULL,NULL,'mairie-appelle@orange.fr','FA 35','MAIRIE DE APPELLE','37+39',NULL),(10,9,'2015-05-06 00:00:00','2015-04-28 00:00:00','2015-05-10 00:00:00','2015-05-06 00:00:00',3,'2015-06-10 00:00:00','39453','00588',8,0,3,20,'LA SAUZIERE SAINT JEAN','81630',213,'PRADIER francis','Mairie 05 63 40 55 55\r\nPerso 05 63 40 55 76\r\nPort 06 85 61 38 49',NULL,NULL,'mairie.la-sauziere-st-jean@wanadoo.fr','EA 33','MAIRIE DE LA SAUZIERE SAINT JEAN','37+39',NULL),(11,10,'2015-05-06 00:00:00','2015-04-28 00:00:00','2015-05-10 00:00:00','2015-05-06 00:00:00',3,'2015-06-10 00:00:00','39454','00616',0,6,1,0,'ANDILLAC','81140',102,'BROS jacques','Mairie 05 63 33 95 91\r\nPerso 05 63 33 91 92\r\nPort 06 77 54 20 40',NULL,NULL,'mairieandillac@orange.fr','FA 33','MAIRIE DE ANDILLAC','37+39',NULL),(13,12,'2015-05-06 00:00:00','2015-04-29 00:00:00','2015-05-10 00:00:00','2015-05-06 00:00:00',3,'2015-06-10 00:00:00','39456','00653',0,0,2,40,'PARISOT','82160',504,'BESSEDE daniel','Mairie 05 63 65 71 62\r\nPortA 06 81 03 80 60','Maire\r\nKERESTEDJIAN frédéric',NULL,'mairie-parisot@info82.com','EA 32','MAIRIE DE PARISOT','43',NULL),(14,13,'2015-05-06 00:00:00','2015-04-29 00:00:00','2015-05-10 00:00:00','2015-05-06 00:00:00',3,'2015-06-10 00:00:00','39457','00550',2,0,4,46,'PUYJOURDES','46260',79,'GENDRAS dominique','Mairie 05 65 40 71 83\r\nPerso 05 65 40 71 41\r\nPort 06 26 26 10 95',NULL,NULL,'mairie.puyjourdes@orange.fr','EA 31','MAIRIE DE PUYJOURDES','43',NULL),(15,14,'2015-05-06 00:00:00','2015-04-29 00:00:00','2015-05-11 00:00:00','2015-05-06 00:00:00',3,'2015-06-10 00:00:00','39458','00549',7,50,6,70,'LUGAGNAC','46260',104,'CRAYSSAC gyl','Mairie 05 65 24 30 91\r\nPerso 05 65 31 57 52\r\nPort 06 86 96 14 72','Adj M. COSTES\r\n06 24 56 33 41',NULL,'mairie.lugagnac@orange.fr','EA 31','MAIRIE DE LUGAGNAC','43',NULL),(16,15,'2015-05-06 00:00:00','0015-04-27 00:00:00','2015-05-10 00:00:00','2015-05-06 00:00:00',3,'2015-06-10 00:00:00','39459','00617',0,10,1,0,'GAJA ET VILLEDIEU','11300',309,'TINE michel','Mairie 04 68 31 15 24',NULL,NULL,'gaja-villedieu.commune@wanadoo.fr','GA 37','MAIRIE DE GAJA ET VILLEDIEU','37',NULL),(18,20,'2015-05-19 00:00:00','2015-04-22 00:00:00','2015-05-25 00:00:00','2015-05-19 00:00:00',3,'2015-06-25 00:00:00','39460','00901',0,20,2,5,'SAINT CHRISTOL','84390',611,'BONNEFOY henri','Mairie 04 90 75 01 05\r\nPerso 04 90 75 00 65',NULL,NULL,'mairie-stchristol@wanadoo.fr','VA 33','MAIRIE DE SAINT CHRISTOL','44',NULL),(19,22,'2015-05-19 00:00:00','2015-04-29 00:00:00','2015-05-25 00:00:00','2015-05-19 00:00:00',3,'2015-06-25 00:00:00','39461','00903',0,70,3,5,'CAVAILLON','84304',0,'HERNANDEZ laurent (resp)','Port 06 81 25 91 71',NULL,NULL,'l.hernandez@ch-cavaillon.fr','TA 34','C.H.I. CAVAILLON-LAURIS','44',NULL),(20,24,'2015-05-19 00:00:00','2015-04-29 00:00:00','2015-05-25 00:00:00','2015-05-19 00:00:00',3,'2015-06-25 00:00:00','39462','00904',0,25,2,5,'SAINT ROMAIN EN VIENNOIS','84110',745,'BERTRAND alain','Mairie 04 90 46 41 98\r\nPerso 04 90 46 43 38',NULL,NULL,'mairie84116@gmail.com','TA 32','MAIRIE DE SAINT ROMAIN EN VIENNOIS','44',NULL),(21,26,'2015-05-19 00:00:00','2015-05-07 00:00:00','2015-05-25 00:00:00','2015-05-19 00:00:00',1,'2015-06-25 00:00:00','39463','00911',0,25,1,0,'MEREUIL','05700',78,'REYNAUD odyle','Mairie 04 92 67 09 58\r\nPerso 04 92 67 08 34',NULL,NULL,'mairie.mereuil@wanadoo.fr','VA 31','MAIRIE DE MEREUIL','44',NULL),(22,27,'2015-05-19 00:00:00','2015-05-06 00:00:00','2015-05-25 00:00:00','2015-05-19 00:00:00',3,'2015-06-25 00:00:00','39464','00907',0,0,2,9.5,'MAUBEC','84660',1900,'MASSIP frédéric','Mairie 04 90 76 92 09','Resp.achats TAMPORAIN christian\r\n06 85 92 06 79',NULL,'mairiemaubec@wanadoo.fr','TA 34','MAIRIE DE MAUBEC','44',NULL),(23,28,'2015-05-19 00:00:00','2015-05-06 00:00:00','2015-05-25 00:00:00','2015-05-19 00:00:00',3,'2015-06-25 00:00:00','39465','00908',0,0,2,11,'LES BEAUMETTES','84220',196,'ARAGONES claire','Mairie 04 90 72 22 60',NULL,NULL,'mairie.lesbeaumettes@wanadoo.fr','TA 34','MAIRIE DE LES BEAUMETTES','44',NULL),(24,29,'2015-05-19 00:00:00','2015-05-07 00:00:00','2015-05-25 00:00:00','2015-05-19 00:00:00',3,'2015-06-25 00:00:00','39466','00628',0,0,1,5,'REGAT','09600',62,'MORELL michel','Mairie 05 61 01 82 92\r\nPerso 05 61 01 21 41\r\nPort 06 33 96 83 66',NULL,NULL,'regat@voila.fr','EA 37','MAIRIE DE REGAT','37',NULL),(25,30,'2015-05-19 00:00:00','2015-05-06 00:00:00','2015-05-25 00:00:00','2015-05-19 00:00:00',3,'2015-06-25 00:00:00','39467','00625',0,20,1,0,'FAUCH','81120',392,'ROUMEGOUX robert','Mairie 05 63 55 54 16\r\nPerso 05 63 55 56 81\r\nPort 06 21 06 54 98',NULL,NULL,'mairiefauch@e-kiwi.fr','GA 34','MAIRIE DE FAUCH','37',NULL),(26,31,'2015-05-19 00:00:00','2015-05-06 00:00:00','2015-05-25 00:00:00','2015-05-19 00:00:00',3,'2015-06-25 00:00:00','39468','00623',0,0,1,10,'MONTELS','81140',86,'RAU ludovic','Mairie 05 63 33 21 45',NULL,NULL,'mairie81176@gmail.com','EA 33','MAIRIE DE MONTELS','37',NULL),(27,32,'2015-05-19 00:00:00','2015-05-06 00:00:00','2015-05-25 00:00:00','2015-05-19 00:00:00',3,'2015-06-25 00:00:00','39469','00622',0,20,2,20,'LIVERS CAZELLES','81170',226,'DONNADIEU denis','Mairie 05 63 56 00 72\r\nPerso 05 63 56 05 10',NULL,NULL,'mairie.liverscazelles@orange.fr','FA 33','MAIRIE DE LIVERS CAZELLES','37',NULL),(28,33,'2015-06-17 00:00:00','2015-05-07 00:00:00','2015-06-22 00:00:00','2015-06-17 00:00:00',3,'2015-07-22 00:00:00','39470','00660',0,0,1,5,'AUJOLS','46090',243,'DEJEAN genevieve','Mairie 05 65 24 72 12\r\nPerso 05 65 31 61 84',NULL,NULL,'mairie.aujols@orange.fr','DA 31','MAIRIE DE AUJOLS','43',NULL),(29,34,'2015-05-19 00:00:00','2015-05-06 00:00:00','2015-05-25 00:00:00','2015-05-19 00:00:00',3,'2015-06-25 00:00:00','39471','00658',12,2,5,26,'PEGUILHAN','31350',221,'BROCAS michel','Mairie 05 61 88 75 76\r\nPerso 05 61 88 75 55',NULL,NULL,'mairiepeguilhan@orange.fr','Z 36','MAIRIE DE PEGUILHAN','43',NULL),(30,35,'2015-05-19 00:00:00','2015-05-06 00:00:00','2015-05-25 00:00:00','2015-05-19 00:00:00',3,'2015-06-25 00:00:00','39472','00598',0,0,2,10,'SAINTE DODE','32170',238,'TUJAGUE hervé','Mairie 05 62 67 04 41\r\nPerso 05 62 67 00 25\r\nPort 06 08 60 70 42',NULL,NULL,'sainte.dode@wanadoo.fr','Y 36','MAIRIE DE SAINTE DODE','39',NULL),(31,38,'2015-05-19 00:00:00','2015-05-07 00:00:00','2015-05-25 00:00:00','2015-05-19 00:00:00',1,'2015-06-25 00:00:00','39473','00703',22,0,2,5,'ARTELENS SOUIN','65400',121,'Mme DULOUT andrée','Mairie 05 62 97 53 28\r\nPerso 05 62 90 32 86\r\nPort 06 14 80 84 43',NULL,NULL,'mairie-artelenssouin@orange.fr','W 38','MAIRIE DE ARTELENS SOUIN','39',NULL),(32,39,'2015-05-19 00:00:00','2015-05-07 00:00:00','2015-05-25 00:00:00','2015-05-19 00:00:00',3,'2015-06-25 00:00:00','39474','00701',0,0,1,20,'BAZILLAC','65140',374,'ROCHETEAU charles','Mairie 05 62 96 24 23\r\nPerso 05 62 96 28 80\r\nPort 06 81 65 56 73',NULL,NULL,'commune.de.bazillac@orange.fr','X 36','MAIRIE DE BAZILLAC','39',NULL),(33,40,'2015-05-19 00:00:00','2015-03-04 00:00:00','2015-05-25 00:00:00','2015-05-19 00:00:00',3,'2015-06-25 00:00:00','39475','00390',4,10,2,0,'SAINTE JULIETTE SUR VIAUR','12120',544,'WOROU simon','Mairie 05 65 69 46 06\r\nPort 06 32 54 42 60','Acheteur rodez',NULL,'mairie.stejuliette@wanadoo.fr','HA 32','MAIRIE DE SAINTE JULIETTE SUR VIAUR','37',NULL),(34,11,'2015-05-06 00:00:00','2015-04-30 00:00:00','2015-05-12 00:00:00','2015-05-06 00:00:00',3,'2015-06-12 00:00:00','39455','00656',1,2,4,6,'LA MAGDELAINE SUR TARN','31340',609,'NARDUCCI isabelle','Mairie 05 61 35 33 44\r\nPort 06 46 17 69 39',NULL,NULL,'mairie.magdelaine@gmail.com','DA 34','MAIRIE DE LA MAGDELAINE SUR TARN','43',NULL),(35,41,'2015-06-04 00:00:00','2015-05-19 00:00:00','2015-06-08 00:00:00','2015-06-04 00:00:00',3,'2015-07-08 00:00:00','39476','00629',0,0,2,20,'PAULHENC','15230',283,'ESTAMPE jean-pierre','Mairie 04 71 23 31 35\r\nPerso 04 71 23 31 33\r\nPort 06 72 57 39 61',NULL,NULL,'paulhenc.mairie@wanadoo.fr','JA 29','MAIRIE DE PAULHENC','37',NULL),(36,42,'2015-06-04 00:00:00','2015-05-20 00:00:00','2015-06-08 00:00:00','2015-06-04 00:00:00',3,'2015-07-08 00:00:00','39477','00631',6,0,5,44.5,'PEUX ET COUFFOULEUX','12360',109,'DEJOB alain','Mairie 05 65 49 55 74\r\nPort 06 78 25 11 25',NULL,NULL,'commune.couffouleux@orange.fr','JA 34','MAIRIE DE PEUX ET COUFFOULEUX','37',NULL),(37,43,'2015-06-04 00:00:00','2015-05-20 00:00:00','2015-06-08 00:00:00','2015-06-04 00:00:00',3,'2015-07-08 00:00:00','39478','00632',6,0,5,20,'MURASSON','12370',212,'SICARD michèle','Mairie 05 65 99 90 65\r\nPerso 05 65 99 90 99','entretien fait par le sivom du bel monte',NULL,'mairie-murasson@wanadoo.fr','IA 34','MAIRIE DE MURASSON','37',NULL),(38,44,'2015-06-04 00:00:00','2015-05-20 00:00:00','2015-06-08 00:00:00','2015-06-04 00:00:00',3,'2015-07-08 00:00:00','39479','00671',0,0,2,45,'NANTHIAT','24800',291,'MEYNIER paul','Mairie 05 53 62 12 14\r\nPerso 05 53 62 12 79',NULL,NULL,'mairie.nanthiat@wanadoo.fr','BA 27','MAIRIE DE NANTHIAT','43',NULL),(39,45,'2015-06-04 00:00:00','2015-05-19 00:00:00','2015-06-08 00:00:00','2015-06-04 00:00:00',3,'2015-07-08 00:00:00','39480','00667',0,0,1,18,'LIGNE','16140',158,'AUTHIER alain','Mairie 05 45 39 01 73\r\nPerso 05 45 22 70 30',NULL,NULL,'mairiedeligne@wanadoo.fr','X 24','MAIRIE DE LIGNE','43',NULL),(40,46,'2015-06-04 00:00:00','2015-05-19 00:00:00','2015-06-08 00:00:00','2015-06-04 00:00:00',3,'2015-06-08 00:00:00','39481','00666',1,100,3,30,'VILLOGNON','16230',389,'GUITTON claude','Mairie 05 45 39 03 40\r\nPerso 05 45 39 03 51',NULL,NULL,'mairie.villognon@wanadoo.fr','X 25','MAIRIE DE VILLOGNON','43',NULL),(41,47,'2015-06-15 00:00:00','2015-05-22 00:00:00','2015-06-22 00:00:00','2015-06-15 00:00:00',3,'2015-07-22 00:00:00','39482','00719',0,8,2,5,'LE FUGERET','04240',227,'PESCE andré','Mairie 04 92 83 20 16\r\nPort 06 08 34 70 26',NULL,NULL,'le.fugeret.mairie@wanadoo.fr','AB 33','MAIRIE DE LE FUGERET','39',NULL),(42,48,'2015-06-17 00:00:00','2015-05-21 00:00:00','2015-06-22 00:00:00','2015-06-17 00:00:00',3,'2015-07-22 00:00:00','39483','00716',3,0,4,19.5,'BEZAUDUN LES ALPES','06510',143,'ARNAUD jean-paul','Mairie 04 93 59 12 34\r\nPerso 04 93 59 11 69',NULL,NULL,'mairie.bezaudun@wanadoo.fr','CB 34','MAIRIE DE BEZAUDUN LES ALPES','39',NULL),(43,49,'2015-06-17 00:00:00','2015-05-19 00:00:00','2015-06-22 00:00:00','2015-06-17 00:00:00',3,'2015-07-22 00:00:00','39484','00711',0,0,3,33,'VILLARS-COLMARS','04370',209,'BLACHE patricia (1ere ADJ)','Mairie 04 92 83 43 01',NULL,NULL,'mairievillarscolmars@orange.fr','ZA 32','MAIRIE DE VILLARS-COLMARS','39',NULL),(44,50,'2015-06-17 00:00:00','2015-05-19 00:00:00','2015-06-22 00:00:00','2015-06-17 00:00:00',3,'2015-07-22 00:00:00','39485','00710',0,0,2,30,'LA MURE ARGENS','04170',324,'DELSAUX alain','Mairie 04 92 89 10 72\r\nPerso 04 92 83 06 62',NULL,NULL,'mairie.lamureargens@gmail.com','ZA 33','MAIRIE DE LA MURE ARGENS','39',NULL),(45,51,'2015-06-17 00:00:00','2015-05-19 00:00:00','2015-06-22 00:00:00','2015-06-17 00:00:00',3,'2015-07-22 00:00:00','39486','00708',0,0,3,29.5,'VALERNES','04200',231,'EULOGE gérard','Mairie 04 92 62 16 46\r\nPerso 04 92 31 59 54',NULL,NULL,'mairie-de-valernes@orange.fr','XA 32','MAIRIE DE VALERNES','39',NULL),(46,52,'2015-06-17 00:00:00','2015-05-19 00:00:00','2015-06-22 00:00:00','2015-06-17 00:00:00',3,'2015-07-22 00:00:00','39487','00707',12,0,3,10,'MISON','04200',849,'GAY robert','Mairie 04 92 62 21 17\r\nPerso 04 92 62 21 71\r\nPort 06 85 80 13 49',NULL,NULL,'mairie.mison@orange.fr','WA 32','MAIRIE DE MISON','39',NULL),(47,53,'2015-06-17 00:00:00','2015-05-18 00:00:00','2015-06-22 00:00:00','2015-06-17 00:00:00',3,'2015-07-22 00:00:00','39488','00706',6,0,2,10,'GAJAN','30730',725,'POUDEVIGNE jean-louis','Mairie 04 66 35 02 91',NULL,NULL,'contact@gajan.fr','PA 33','MAIRIE DE GAJAN','39',NULL),(48,54,'2015-06-17 00:00:00','2015-05-22 00:00:00','2015-06-22 00:00:00','2015-06-17 00:00:00',3,'2015-07-22 00:00:00','39489','00633',0,0,1,10,'TOURBES','34120',1628,'SERVELLERA frédéric (4ème ADJ)','Mairie 04 67 98 15 02\r\nPerso 04 67 98 34 78\r\nPort 06 08 67 35 30',NULL,NULL,'mairie@tourbes.fr','LA 35','MAIRIE DE TOURBES','37',NULL),(49,55,'2015-06-17 00:00:00','2015-05-22 00:00:00','2015-06-22 00:00:00','2015-06-17 00:00:00',1,'2015-07-22 00:00:00','39490','00635',0,0,1,20,'HEREPIAN','34600',1479,'FONTES régis (4ème ADJ)','Mairie 04 67 95 04 55',NULL,NULL,'r.fontes@mairieherepian.fr','KA 35','MAIRIE DE HEREPIAN','37',NULL),(50,56,'2015-06-17 00:00:00','2015-05-21 00:00:00','2015-06-22 00:00:00','2015-06-17 00:00:00',3,'2015-07-22 00:00:00','39491','00673',6,15,3,5,'OEYRELUY','40180',1094,'DAGUERRE jean-louis','Mairie 05 58 57 81 10\r\nPort 06 79 89 58 35',NULL,NULL,'mairie@ville-oeyreluy.fr','R 34','MAIRIE DE OEYRELUY','43',NULL),(51,57,'2015-06-17 00:00:00','2015-05-18 00:00:00','2015-06-22 00:00:00','2015-06-17 00:00:00',3,'2015-07-22 00:00:00','39492','00664',0,0,1,10,'SAINTE MARIE DE GOSSE','40390',878,'M. SERRES (RESP.TECH)','Mairie 05 59 56 32 16\r\nPort 06 73 77 04 53',NULL,NULL,'mairie.ste-marie-de-gosse@wanadoo.fr','R 35','MAIRIE DE SAINTE MARIE DE GOSSE','43',NULL),(52,58,'2015-06-17 00:00:00','2015-05-18 00:00:00','2015-06-22 00:00:00','2015-06-17 00:00:00',3,'2015-07-22 00:00:00','39493','00661',0,15,4,50,'LIT ET MIXE','40170',1441,'M. LEBERE (RESP.TECH)','Mairie 05 58 42 83 10\r\nPerso 05 58 42 50 50',NULL,NULL,'mairie@lit-et-mixe.com','Q 33','MAIRIE DE LIT ET MIXE','43',NULL),(53,59,'2015-06-17 00:00:00','2015-05-19 00:00:00','2015-06-22 00:00:00','2015-06-17 00:00:00',3,'2015-07-22 00:00:00','39494','00665',8,0,4,15,'MAREUIL','16170',350,'RODET claudine','Mairie 05 45 21 74 01\r\nPerso 05 45 96 51 47\r\nPort 06 26 90 15 56',NULL,NULL,'mareuilcharente@orange.fr','W 25','MAIRIE DE MAREUIL','43',NULL),(54,60,'2015-06-17 00:00:00','2015-05-20 00:00:00','2015-06-22 00:00:00','2015-06-17 00:00:00',3,'2015-07-22 00:00:00','39495','00920',40,4,5,15,'ASPERJOC','07600',361,'CHIRAUSSEL alain','Mairie 04 75 37 47 12',NULL,NULL,'mairieasperjoc@inforoutes-ardeche.fr','PA 30','MAIRIE DE ASPERJOC','44',NULL),(55,61,'2015-06-17 00:00:00','2015-05-21 00:00:00','2015-06-22 00:00:00','2015-06-17 00:00:00',3,'2015-07-22 00:00:00','39496','00923',0,25,4,45,'LE ROUX','07560',43,'COUDENE patrick','Mairie 04 75 38 95 06',NULL,NULL,'mairie.le-roux@wanadoo.fr','OA 30','MAIRIE DE LE ROUX','44',NULL),(56,62,'2015-06-17 00:00:00','2015-05-21 00:00:00','2015-06-22 00:00:00','2015-06-17 00:00:00',3,'2015-07-22 00:00:00','39497','00924',0,0,3,10.5,'DOMPNAC','07260',82,'MME DETE marie-christine','Mairie 04 75 36 95 01',NULL,NULL,'mairie.dompnac@ozone.net','OA 30','MAIRIE DE DOMPNAC','44',NULL),(57,63,'2015-06-03 00:00:00','2015-05-29 00:00:00','2015-06-08 00:00:00','2015-06-03 00:00:00',3,'2015-07-08 00:00:00','39498','00682',1,0,3,50,'RANVILLE BREUILLAUD','16140',178,'BALLERY patrice (RESP.TECH)','Mairie 05 45 21 00 14\r\nPerso 05 45 21 03 77',NULL,NULL,'mairie.ranville.breuillaud@wanadoo.fr','W 25','MAIRIE DE RANVILLE BREUILLAUD','43',NULL),(58,65,'2015-06-03 00:00:00','2015-05-27 00:00:00','2015-06-08 00:00:00','2015-06-03 00:00:00',3,'2015-07-08 00:00:00','39499','00677',0,0,1,5,'FAUGUEROLLES','47400',559,'MME DE PARSCAU maryline','Mairie 05 53 83 40 35\r\nPerso 05 53 83 40 80',NULL,NULL,'communedefauguerolles.47@wanadoo.fr','X 31','MAIRIE DE FAUGUEROLLES','43',NULL),(59,44,'2015-06-03 00:00:00','2015-05-29 00:00:00','2015-06-08 00:00:00','2015-06-03 00:00:00',3,'2015-07-08 00:00:00','39500','00683',0,0,1,90,'NANTHIAT','24800',291,'MEYNIER paul','Mairie 05 53 62 12 14\r\nPerso 05 53 62 12 79',NULL,NULL,'mairie.nanthiat@wanadoo.fr','BA 27','MAIRIE DE NANTHIAT','43',NULL),(60,67,'2015-06-24 00:00:00','2015-05-28 00:00:00','2015-06-16 00:00:00','2015-06-24 00:00:00',3,'2015-07-16 00:00:00','39501','00678',0,0,2,20,'LABASTIDE CHALOSSE','40700',117,'BRISE roland','Mairie 05 58 79 01 24\r\nPerso 05 58 79 04 61',NULL,NULL,'mairie.labastide-chalosse@wanadoo.fr','T 35','MAIRIE DE LABASTIDE CHALOSSE','43',NULL),(61,72,'2015-06-03 00:00:00','2015-05-28 00:00:00','2015-06-08 00:00:00','2015-06-03 00:00:00',3,'2015-07-08 00:00:00','39502','00720',0,50,1,0,'LES ANGLES','65100',141,'MME LACAZE yvette','Mairie 05 62 42 92 76\r\nPerso 05 62 42 93 62',NULL,NULL,'mairie.lesangles@wanadoo.fr','W 37','MAIRIE DE LES ANGLES','39',NULL),(62,73,'2015-06-03 00:00:00','2015-05-28 00:00:00','2015-06-08 00:00:00','2015-06-03 00:00:00',3,'2015-07-08 00:00:00','39503','00721',1,0,3,10,'BULAN','65130',61,'MME COLOMES marie-rose','Mairie 05 62 39 01 71',NULL,NULL,'-','X 37','MAIRIE DE BULAN','39',NULL),(63,75,'2015-06-03 00:00:00','2015-05-29 00:00:00','2015-06-08 00:00:00','2015-06-03 00:00:00',3,'2015-07-08 00:00:00','39504','00639',6,0,1,0,'LE TRUEL','12430',363,'M. ALIBERT (ADJ)','Mairie 05 65 46 57 66\r\nPort 06 85 09 38 44','Maire : AURIOL daniel','Adj travaille à la comcom','mairie.letruel@wanadoo.fr','IA 33','MAIRIE DE LE TRUEL','37',NULL),(64,76,'2015-06-04 00:00:00','2015-05-30 00:00:00','2015-06-08 00:00:00','2015-06-04 00:00:00',1,'2015-07-08 00:00:00','39505','00429',12,45,8,158,'CALMONT','31560',1610,'M. MUNOZ (ADJ)','Mairie 05 61 02 10 16\r\nPort 06 84 76 47 52',NULL,'CLIENT BLOQUE VENDEUR 29','mairie.calmont.31@wanadoo.fr','DA 36','MAIRIE DE CALMONT','28+29',NULL),(65,77,'2015-06-04 00:00:00','2015-05-28 00:00:00','2015-06-08 00:00:00','2015-06-04 00:00:00',3,'2015-07-08 00:00:00','39506','00927',0,50,1,0,'PRADONS','07120',295,'RIEU yves','Mairie 04 75 39 68 68\r\nPerso 04 75 35 56 87\r\nPort 06 85 14 02 02',NULL,NULL,'mairie.pradons@orange.fr','QA 31','MAIRIE DE PRADONS','44',NULL),(66,78,'2015-06-24 00:00:00','2015-06-10 00:00:00','2015-06-29 00:00:00','2015-06-24 00:00:00',1,'2015-07-29 00:00:00','39507','00941',9,0,2,10,'DEVESSET','07320',271,'ROCHE étienne','Mairie 04 75 30 00 99\r\nPerso 04 75 30 17 71\r\nPort 06 38 51 13 03',NULL,NULL,'mairie.devesset@inforoutes.fr','QA 28','MAIRIE DE DEVESSET','44',NULL),(67,17,'2015-06-10 00:00:00','2015-05-18 00:00:00','2015-06-15 00:00:00','2015-06-10 00:00:00',3,'2015-07-15 00:00:00','39508','00913',0,0,2,40,'RAPALE','20246',131,'FONDACCI DE PAOLI jean-claude','Mairie 04 95 37 66 47\r\nPerso 04 95 37 65 47\r\nPort 06 25 05 02 54',NULL,NULL,'mairiederapale@wanadoo.fr','LB 39','MAIRIE DE RAPALE','28+29',NULL),(68,79,'2015-06-10 00:00:00','2015-05-18 00:00:00','2015-06-15 00:00:00','2015-06-10 00:00:00',1,'2015-07-15 00:00:00','39509','00916',43,0,6,60,'ECCICA SUARELLA','20117',684,'BARTOLOMEI jean-françois','Mairie 04 95 28 40 11\r\nPort 06 37 17 96 04','EMPL.COM Jeannot\r\n06 85 93 14 40','MAIRE : POLI pierre','mairie.eccicasuarella@wanadoo.fr','KB 42','MAIRIE DE ECCICA SUARELLA','28+29',NULL),(69,80,'2015-06-10 00:00:00','2015-05-20 00:00:00','2015-06-15 00:00:00','2015-06-10 00:00:00',3,'2015-07-15 00:00:00','39510','00917',0,0,3,30,'VALLE DI MEZZANA','20167',217,'LECA paul','Mairie 04 95 25 84 64\r\nPerso 04 95 25 62 32\r\nPort 06 10 02 29 17',NULL,NULL,'valle-di-mezzana@orange.fr','JB 42','MAIRIE DE VALLE DI MEZZANA','28+29',NULL),(70,81,'2015-06-10 00:00:00','2015-05-21 00:00:00','2015-06-15 00:00:00','2015-06-10 00:00:00',1,'2015-07-15 00:00:00','39511','00918',20,0,2,30,'MOLTIFAO','20218',549,'VINCENSINI augustin','Mairie 04 95 47 80 07\r\nPerso 04 95 47 69 31',NULL,NULL,'mairie.moltifao@orange.fr','LB 40','MAIRIE DE MOLTIFAO','28+29',NULL),(71,19,'2015-06-10 00:00:00','2015-05-22 00:00:00','2015-06-15 00:00:00','2015-06-10 00:00:00',3,'2015-07-15 00:00:00','39512','00919',0,10,1,0,'ROGLIANO','20247',458,'QUILICI patrice','Mairie 04 95 35 42 04\r\nPerso 04 95 35 45 51\r\nPort 06 15 03 15 58','MAIRIE ANNEXE :\r\nMACINAGGIO',NULL,'mairiederogliano@orange.fr','MB 38','MAIRIE DE ROGLIANO','29+28',NULL),(72,82,'2015-06-05 00:00:00','2015-06-05 00:00:00','2015-06-08 00:00:00','2015-06-05 00:00:00',3,'2015-07-08 00:00:00','39514','AUCUN',0,25,2,30,'SARRAZAC','24800',404,'CAZES jean-louis','Mairie 05 53 62 52 06\r\nPort 06 80 89 64 45',NULL,NULL,'mairie.sarrazac@wanadoo.fr','BA 27','MAIRIE DE SARRAZAC','43',NULL),(73,83,'2015-06-10 00:00:00','2015-06-04 00:00:00','2015-06-15 00:00:00','2015-06-10 00:00:00',3,'2015-07-15 00:00:00','39515','00643',0,0,2,15,'SAUCLIERES','12230',147,'ATCHER daniel','Mairie 05 65 62 26 77\r\nPerso 05 65 62 13 45\r\nPort 06 70 52 84 03',NULL,NULL,'mairie-sauclieres@wanadoo.fr','LA 33','MAIRIE DE SAUCLIERES','37',NULL),(74,84,'2015-06-10 00:00:00','2015-06-03 00:00:00','2015-06-15 00:00:00','2015-06-10 00:00:00',3,'2015-07-15 00:00:00','39516','00641',12,0,2,5,'SAINT IZAIRE','12480',317,'RAMONDENC gérard','Mairie 05 65 99 40 31\r\nPerso 05 65 99 43 81','Mairie : SELLAM jean-jacques',NULL,'mairie-stizaire@wanadoo.fr','IA 33','MAIRIE DE SAINT IZAIRE','37',NULL),(75,85,'2015-06-10 00:00:00','2015-06-04 00:00:00','2015-06-15 00:00:00','2015-06-10 00:00:00',3,'2015-07-15 00:00:00','39517','00687',14,25,9,49,'SAINT LAURENT DE GOSSE','40390',481,'M. COMETZ (ADJ)','Mairie 05 59 56 31 08','Maire : MME CAZALIS isabelle',NULL,'communesaintlaurentdegosse@orange.fr','R 35','MAIRIE DE SAINT LAURENT DE GOSSE','43',NULL),(76,86,'2015-06-17 00:00:00','2015-06-03 00:00:00','2015-06-22 00:00:00','2015-06-17 00:00:00',1,'2015-07-22 00:00:00','39518','00686',4,10,5,20,'MONTBRUN','46160',101,'RAUFFET sylvie','Mairie 05 65 40 60 71\r\nPort 06 24 94 32 65',NULL,NULL,'commune-de-montbrun@orange.fr','FA 31','MAIRIE DE MONTBRUN','43',NULL),(77,87,'2015-06-17 00:00:00','2015-06-03 00:00:00','2015-09-07 00:00:00','2015-06-17 00:00:00',1,'2015-10-07 00:00:00','39519','00684',1,0,3,22.5,'LARNAGOL','46160',157,'ORTALO-MAGNE andré','Mairie 05 65 31 23 70\r\nPerso 05 65 31 27 69\r\nPort 06 37 54 59 04',NULL,NULL,'mairie.larnagol@wanadoo.fr','EA 31','MAIRIE DE LARNAGOL','43',NULL),(78,88,'2015-06-17 00:00:00','2015-06-04 00:00:00','2015-06-22 00:00:00','2015-06-17 00:00:00',1,'2015-07-22 00:00:00','39520','00727',0,0,2,32,'IBAROLLE','64120',88,'CAZET jean-louis','Mairie 05 59 37 85 80\r\nPerso 05 59 37 82 24',NULL,NULL,'herrikoetxea-ibarla@wanadoo.fr','R 37','MAIRIE DE IBAROLLE','39',NULL),(79,89,'2015-06-17 00:00:00','2015-06-04 00:00:00','2015-06-22 00:00:00','2015-06-17 00:00:00',1,'2015-07-22 00:00:00','39521','00725',1,0,2,20,'LESCUN','64490',203,'CAUHAPE pierre félix','Mairie 05 59 34 78 80\r\nPerso 05 59 34 58 13',NULL,NULL,'courrier','T 38','MAIRIE DE LESCUN','39',NULL),(80,90,'2015-06-17 00:00:00','2015-06-04 00:00:00','2015-06-22 00:00:00','2015-06-17 00:00:00',1,'2015-07-22 00:00:00','39522','00936',2,0,4,10,'CHARPEY','26300',901,'COMTE jean-françois','Mairie 04 75 59 80 55',NULL,NULL,'mairie-de-charpey@wanadoo.fr','TA 29','MAIRIE DE CHARPEY','44',NULL),(81,91,'2015-06-17 00:00:00','2015-06-03 00:00:00','2015-06-22 00:00:00','2015-06-17 00:00:00',1,'2015-07-22 00:00:00','39523','00934',0,0,2,15,'LA ROCHE SUR GRANE','26400',161,'BONNET christian','Mairie 04 75 62 73 34\r\nPerso 04 75 25 22 44\r\nPort 06 85 91 47 17',NULL,NULL,'mairie.de.la.roche.sur.grane@wanadoo.fr','SA 30','MAIRIE DE LA ROCHE SUR GRANE','44',NULL),(82,92,'2015-06-17 00:00:00','2015-06-03 00:00:00','2015-06-22 00:00:00','2015-06-17 00:00:00',1,'2015-07-22 00:00:00','39524','00929',1,0,2,30,'CHANTEMERLE LES GRIGNAN','26230',231,'ORTIZ jacques','Mairie 04 75 98 50 49',NULL,NULL,'chantemerle.grignan@wanadoo.fr','SA 31','MAIRIE DE CHANTEMERLE LES GRIGNAN','44',NULL),(83,93,'2015-05-29 00:00:00','2015-05-27 00:00:00','2015-06-10 00:00:00','2015-05-29 00:00:00',3,'2015-07-10 00:00:00','39525','COLISSIMO',24,0,1,0,'GHISONI','20227',267,'M. COSTANTINI (1er ADJ)','Mairie 04 95 57 61 28\r\nPort 06 37 86 13 79','Maire : ALBERTINI don marc',NULL,'mairie.ghisoni@wanadoo.fr','LB 41','MAIRIE DE GHISONI','28+29',NULL),(84,94,'2015-06-17 00:00:00','2015-06-11 00:00:00','2015-06-22 00:00:00','2015-06-17 00:00:00',1,'2015-07-22 00:00:00','39526','00646',0,0,2,9.5,'BESSET','09500',119,'ALIBERT philippe','Mairie 05 61 68 85 89\r\nPort 06 42 63 07 88',NULL,NULL,'mairie.besset@orange.fr','EA 37','MAIRIE DE BESSET','37',NULL),(85,29,'2015-06-24 00:00:00','2015-06-10 00:00:00','2015-06-29 00:00:00','2015-06-24 00:00:00',1,'2015-07-29 00:00:00','39527','00644',7,0,2,0,'REGAT','09600',62,'MORELL michel','Mairie 05 61 01 82 92\r\nPerso 05 61 01 21 41\r\nPort 06 33 96 83 66',NULL,NULL,'regat@voila.fr','EA 37','MAIRIE DE REGAT','37',NULL),(86,95,'2015-06-17 00:00:00','2015-06-10 00:00:00','2015-06-22 00:00:00','2015-06-17 00:00:00',1,'2015-07-22 00:00:00','39528','00645',0,4,2,5,'LAPENNE','09500',131,'PALMADE lucien','Mairie 05 61 68 66 10\r\nPerso 05 61 68 66 04',NULL,NULL,'mairie-lapenne@wanadoo.fr','EA 37','MAIRIE DE LAPENNE','37',NULL),(87,97,'2015-06-19 00:00:00','2015-06-15 00:00:00','2015-06-22 00:00:00','2015-06-19 00:00:00',1,'2015-07-22 00:00:00','39529','00953',0,0,1,20,'ROUFFIAC TOLOSAN','31180',1404,'USZES laurent (2ème ADJ)','Mairie 05 61 09 11 27\r\nPerso 05 61 09 40 35\r\nPort 06 72 01 51 41','MAIRE : M. SOURZAC',NULL,'mairie-rouffiac-tolosan@wanadoo.fr','DA 34','MAIRIE DE ROUFFIAC TOLOSAN','28+36',NULL),(88,96,'2015-06-19 00:00:00','2015-06-10 00:00:00','2015-06-22 00:00:00','2015-06-19 00:00:00',1,'2015-07-22 00:00:00','39530','00921',0,0,1,10,'MAIRIE DE LESPINASSE','31150',1864,'M. LUBOWSKY (RESP.TECH)','Mairie 05 61 35 41 66\r\nPort 06 15 19 17 50',NULL,NULL,'dst@ville-lespinasse.fr','CA 34','MAIRIE DE LESPINASSE','28+29',NULL),(89,99,'2015-06-24 00:00:00','2015-06-11 00:00:00','2015-06-29 00:00:00','2015-06-24 00:00:00',1,'2015-07-29 00:00:00','39531','ED923',1,25,3,5,'SAINT REMY DE CHAUDES AIGUES','15110',118,'GENDRE vital','Mairie 04 71 23 57 45\r\nPerso 04 71 23 54 90\r\nPort 06 81 77 72 90',NULL,NULL,'mairie.st-remy-de-chaudes-aigues@wanadoo.fr','KA 29','MAIRIE DE SAINT REMY DE CHAUDES AIGUES','28+29',NULL),(90,100,'2015-06-24 00:00:00','2015-06-11 00:00:00','2015-06-29 00:00:00','2015-06-24 00:00:00',1,'2015-07-29 00:00:00','39532','ED924',7,0,6,49,'ESPINASSE','15110',80,'GENDRE christian','Mairie 04 71 23 55 11\r\nPerso 04 71 23 95 86\r\nPort 06 72 77 15 36',NULL,NULL,'espinasse.mairie@wanadoo.fr','IA 29','MAIRIE DE ESPINASSE','28+29',NULL),(91,101,'2015-07-08 00:00:00','2015-06-09 00:00:00','2015-07-13 00:00:00','2015-07-08 00:00:00',1,'2015-08-13 00:00:00','39533','00817',2,0,3,50,'VENACO','20231',657,'MEZZADRI michel','Mairie 04 95 47 00 15\r\nPort 06 19 07 08 77',NULL,NULL,'mairie.venaco@orange.fr','LB 41','MAIRIE DE VENACO','36',NULL),(92,102,'2015-06-24 00:00:00','2015-06-12 00:00:00','2015-06-29 00:00:00','2015-06-24 00:00:00',1,'2015-07-29 00:00:00','39534','00948',0,0,4,15.5,'LIOUX','84220',248,'FARGE francis','Mairie 04 90 05 61 64\r\nPerso 04 90 05 61 00\r\nPort 06 07 29 56 06',NULL,NULL,'mairie.lioux@wanadoo.fr','UA 33','MAIRIE DE LIOUX','44',NULL),(93,103,'2015-06-24 00:00:00','2015-06-11 00:00:00','2015-06-29 00:00:00','2015-06-24 00:00:00',1,'2015-07-29 00:00:00','39535','00946',2,0,2,10,'SAINT BARTHELEMY GROZON','07270',469,'JULIEN jean-paul (RESP.TECH)','Mairie 04 75 06 58 25\r\nPort 06 72 33 66 91','MAIRE : ESPENEL dominique',NULL,'ma-stbgr@inforoutes-ardeche.fr','RA 29','MAIRIE DE SAINT BARTHELEMY GROZON','44',NULL),(94,104,'2015-06-24 00:00:00','2015-06-11 00:00:00','2015-06-29 00:00:00','2015-06-24 00:00:00',1,'2015-07-29 00:00:00','39536','00945',1,0,2,5,'LABATIE D\'ANDAURE','07570',204,'MME REILLE chantal (1ère ADJE)','Mairie 04 75 06 68 62\r\nPerso 04 75 06 64 90\r\nPort 06 26 90 40 29','MAIRE : MARLIAC christian',NULL,'ma-labat@inforoutes-ardeche.fr','QA 28','MAIRIE DE LABATIE D\'ANDAURE','44',NULL),(95,105,'2015-06-24 00:00:00','2015-06-10 00:00:00','2015-06-29 00:00:00','2015-06-24 00:00:00',1,'2015-07-29 00:00:00','39537','00944',0,25,2,5,'SAINT JULIEN BOUTIERES','07310',215,'BLANCHIN andré','Mairie 04 75 30 44 00\r\nPerso 04 75 30 53 70\r\nPort 06 76 15 07 32',NULL,NULL,'mairie.st.julien.boutieres@inforoutes-ardeche.fr','QA 29','MAIRIE DE SAINT JULIEN BOUTIERES','44',NULL),(96,106,'2015-06-24 00:00:00','2015-06-10 00:00:00','2015-06-29 00:00:00','2015-06-24 00:00:00',1,'2015-07-29 00:00:00','39538','00933',0,0,1,5,'COLOMBIER LE VIEUX','07410',551,'FOUR béatrice','Mairie 04 75 06 72 25\r\nPerso 04 75 06 76 19',NULL,NULL,'ma-colux@inforoutes-ardeche.fr','RA 28','MAIRIE DE COLOMBIER LE VIEUX','44',NULL),(97,107,'2015-06-24 00:00:00','2015-06-10 00:00:00','2015-06-29 00:00:00','2015-06-24 00:00:00',1,'2015-07-29 00:00:00','39540','00942',0,0,2,30,'SAINT PIERRE SUR DOUX','07520',85,'VAUTARET michel','Mairie 04 75 30 05 87\r\nPerso 04 75 30 05 88\r\nPort 06 86 06 41 74',NULL,NULL,'mmtv@orange.fr','QA 28','MAIRIE DE SAINT PIERRE SUR DOUX','44',NULL),(98,108,'2015-06-24 00:00:00','2015-06-10 00:00:00','2015-06-29 00:00:00','2015-06-24 00:00:00',1,'2015-07-29 00:00:00','39541','00938',20,0,4,45,'SAINT VICTOR','07410',828,'AUDRAS maurice','Mairie 04 75 06 00 47\r\nPerso 04 75 06 85 08\r\nPort 06 08 03 89 64',NULL,NULL,'ma-stvic@inforoutes.fr','RA 28','MAIRIE DE SAINT VICTOR','44',NULL),(99,109,'2015-06-24 00:00:00','2015-06-10 00:00:00','2015-06-29 00:00:00','2015-06-24 00:00:00',3,'2015-07-29 00:00:00','39539','00939',0,0,1,20,'SAINT FELICIEN','07410',0,'BILLON cassandre','Tel 04 75 06 71 70',NULL,NULL,'cassandre.billon@gmail.com','RA 28','CAFE LE NORD','44',NULL),(100,110,'2015-06-24 00:00:00','2015-06-12 00:00:00','2015-06-29 00:00:00','2015-06-24 00:00:00',1,'2015-07-29 00:00:00','39542','00947',0,0,1,10,'BLAUVAC','84570',342,'RASPAIL max','Mairie 04 90 61 81 41\r\nPerso 04 90 61 80 84',NULL,NULL,'blauvac@wanadoo.fr','TA 33','MAIRIE DE BLAUVAC','44',NULL),(101,111,'2015-06-24 00:00:00','2015-06-10 00:00:00','2015-06-29 00:00:00','2015-06-24 00:00:00',1,'2015-07-29 00:00:00','39543','00731',12,0,5,53,'CHANDOLAS','07230',478,'MAHEY alain','Mairie 04 75 39 31 05\r\nPerso 04 75 39 34 14\r\nPort 06 07 67 62 78',NULL,NULL,'mairie.chandolas@orange.fr','PA 31','MAIRIE DE CHANDOLAS','39',NULL),(102,112,'2015-06-24 00:00:00','2015-06-10 00:00:00','2015-06-29 00:00:00','2015-06-24 00:00:00',1,'2015-07-29 00:00:00','39544','00733',12,0,1,0,'LA CAPELLE ET MASMOLENE','30700',400,'SAORIN jean-claude','Mairie 04 66 37 32 40\r\nPerso 04 66 37 32 50',NULL,NULL,'mairie.lacapelleetmasmolene@orange.fr','QA 33','MAIRIE DE LA CAPELLE ET MASMOLENE','39',NULL),(103,113,'2015-06-24 00:00:00','2015-06-11 00:00:00','2015-06-29 00:00:00','2015-06-24 00:00:00',1,'2015-07-29 00:00:00','39545','00735',0,0,1,20,'BEAULIEU','07460',400,'BORIE jean-françois','Mairie 04 75 39 32 06\r\nPerso 04 75 39 03 00',NULL,NULL,'mairie.beaulieu@inforoutes-ardeche.fr','PA 31','MAIRIE DE BEAULIEU','39',NULL),(104,114,'2015-06-24 00:00:00','2015-06-11 00:00:00','2015-06-29 00:00:00','2015-06-24 00:00:00',1,'2015-07-29 00:00:00','39546','00943',0,0,2,10,'SAINT JEURE D\'ANDAURE','07320',96,'SENECLAUZE henri','Mairie 04 75 30 11 86\r\nPerso 04 75 30 10 11\r\nPort 06 86 5138 62',NULL,NULL,'ma-stjda@inforoutes-ardeche.fr','QA 28','MAIRIE DE SAINT JEURE D\'ANDAURE','44',NULL);

--
-- Table structure for table `Client`
--

CREATE TABLE `Client` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `secteur` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `code_postal` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `contact1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contact2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contact3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ville` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `adresse` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `societe` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `position` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `numero_vendeur` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `nombre_habitants` int(11) NOT NULL,
  `date_relance` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=115 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Client`
--

INSERT INTO `Client` VALUES (6,'1-11300','11','11300','Mairie 04 68 31 50 27\r\nPerso 04 68 31 23 25\r\nPort 06 29 97 20 89','Empl. ROMERO\r\n07 61 51 63 33',NULL,'ROQUETAILLADE','SIRET jean','mairie-roquetaillade@orange.fr','-','MAIRIE DE ROQUETAILLADE','GA 37','37+39',192,'2015-04-29 00:00:00'),(7,'1-66220','66','66220','Mairie 04 68 59 00 91\r\nPerso 04 68 59 07 23\r\nPort 06 84 31 60 34',NULL,NULL,'MAIRIE DE TRILLA','FOURCADE didier','mairietrilla@orange.fr','-','MAIRIE DE TRILLA','HA 39','37+39',54,'2015-04-30 00:00:00'),(8,'1-81700','81','81700','Mairie 05 63 75 06 00\r\nPerso 05 63 75 08 39',NULL,NULL,'APPELLE','POUYANNE christophe','mairie-appelle@orange.fr','-','MAIRIE DE APPELLE','FA 35','37+39',71,'2015-04-28 00:00:00'),(9,'1-81630','81','81630','Mairie 05 63 40 55 55\r\nPerso 05 63 40 55 76\r\nPort 06 85 61 38 49',NULL,NULL,'LA SAUZIERE SAINT JEAN','PRADIER francis','mairie.la-sauziere-st-jean@wanadoo.fr','LE VIGUAS','MAIRIE DE LA SAUZIERE SAINT JEAN','EA 33','37+39',213,'2015-04-28 00:00:00'),(10,'1-81140','81','81140','Mairie 05 63 33 95 91\r\nPerso 05 63 33 91 92\r\nPort 06 77 54 20 40',NULL,NULL,'ANDILLAC','BROS jacques','mairieandillac@orange.fr','PAUSADOU','MAIRIE DE ANDILLAC','FA 33','37+39',102,'2015-04-28 00:00:00'),(11,'1-31340','31','31340','Mairie 05 61 35 33 44\r\nPort 06 46 17 69 39',NULL,NULL,'LA MAGDELAINE SUR TARN','NARDUCCI isabelle','mairie.magdelaine@gmail.com','-','MAIRIE DE LA MAGDELAINE SUR TARN','DA 34','43',609,'2015-04-30 00:00:00'),(12,'1-82160','82','82160','Mairie 05 63 65 71 62\r\nPortA 06 81 03 80 60','Maire\r\nKERESTEDJIAN frédéric',NULL,'PARISOT','BESSEDE daniel','mairie-parisot@info82.com','ROUTE DE CAYLUS','MAIRIE DE PARISOT','EA 32','43',504,'2015-04-29 00:00:00'),(13,'1-46260','46','46260','Mairie 05 65 40 71 83\r\nPerso 05 65 40 71 41\r\nPort 06 26 26 10 95',NULL,NULL,'PUYJOURDES','GENDRAS dominique','mairie.puyjourdes@orange.fr','-','MAIRIE DE PUYJOURDES','EA 31','43',79,'2015-04-29 00:00:00'),(14,'2-46260','46','46260','Mairie 05 65 24 30 91\r\nPerso 05 65 31 57 52\r\nPort 06 86 96 14 72','Adj M. COSTES\r\n06 24 56 33 41',NULL,'LUGAGNAC','CRAYSSAC gyl','mairie.lugagnac@orange.fr','-','MAIRIE DE LUGAGNAC','EA 31','43',104,'2015-04-29 00:00:00'),(15,'2-11300','11','11300','Mairie 04 68 31 15 24',NULL,NULL,'GAJA ET VILLEDIEU','TINE michel','gaja-villedieu.commune@wanadoo.fr','-','MAIRIE DE GAJA ET VILLEDIEU','GA 37','37',309,'2015-04-29 00:00:00'),(16,'1-20224','2B','2B224','Mairie 04 95 48 01 05\r\nPerso 04 95 48 03 94\r\nPort 06 03 36 45 66\r\nTrav 06 86 57 07 96',NULL,NULL,'ALBERTACCE','ALBERTINI pierre-françois','mairie.albertacce.corse@wanadoo.fr','-','MAIRIE DE ALBERTACCE','KB 40','28+29',200,'2014-04-16 00:00:00'),(17,'1-20246','20','20246','Mairie 04 95 37 66 47\r\nPerso 04 95 37 65 47\r\nPort 06 25 05 02 54',NULL,NULL,'RAPALE','FONDACCI DE PAOLI jean-claude','mairiederapale@wanadoo.fr','-','MAIRIE DE RAPALE','LB 39','28+29',131,'2015-05-18 00:00:00'),(18,'1-20246','2B','2B246','MAIRIE 04 95 37 70 70 \r\nPERSO 04 95 37 70 26',NULL,NULL,'SANTO PIETRO DI TENDA','TOMI marc','mairie.santo-pietro-di-tenda@orange.fr','CAMPIENDI','MAIRIE DE SANTO PIETRO DI TENDA','LB 39','29+28',332,'2014-05-22 00:00:00'),(19,'1-20247','20','20247','Mairie 04 95 35 42 04\r\nPerso 04 95 35 45 51\r\nPort 06 15 03 15 58','MAIRIE ANNEXE :\r\nMACINAGGIO',NULL,'ROGLIANO','QUILICI patrice','mairiederogliano@orange.fr','TERRAIN PRÊT DU PORT','MAIRIE DE ROGLIANO','MB 38','29+28',458,'2015-05-22 00:00:00'),(20,'1-84390','84','84390','Mairie 04 90 75 01 05\r\nPerso 04 90 75 00 65',NULL,NULL,'SAINT CHRISTOL','BONNEFOY henri','mairie-stchristol@wanadoo.fr','-','MAIRIE DE SAINT CHRISTOL','VA 33','44',611,'2015-04-22 00:00:00'),(21,'1-20253','2B','2B253','MAIRIE 04 95 37 08 49\r\nPERSO 04 95 37 10 42 \r\nPORT 06 24 47 30 42',NULL,NULL,'PATRIMONIO','POGGIOLI jose','mairie.patrimonio@mic.fr','-','MAIRIE DE PATRIMONIO','MB 39','29+28',685,NULL),(22,'1-84304','84','84304','Port 06 81 25 91 71',NULL,NULL,'CAVAILLON','HERNANDEZ laurent (resp)','l.hernandez@ch-cavaillon.fr','84304 CAVAILLON','C.H.I. CAVAILLON-LAURIS','TA 34','44',0,'2015-04-29 00:00:00'),(23,'1-20275','2B','2B275','MAIRIE 04 95 35 38 92\r\nPERSO 04 95 35 41 33\r\nPORT 06 27 33 12 29','SECRETAIRE MME BANIZETTE-\r\ngranaggiolo@orange.fr',NULL,'ERSA','MICHELI thomas','mairieersa@orange.fr','-','MAIRIE DE ERSA','MB 37','29+28',155,'2014-12-05 00:00:00'),(24,'1-84110','84','84110','Mairie 04 90 46 41 98\r\nPerso 04 90 46 43 38',NULL,NULL,'SAINT ROMAIN EN VIENNOIS','BERTRAND alain','mairie84116@gmail.com','-','MAIRIE DE SAINT ROMAIN EN VIENNOIS','TA 32','44',745,'2015-04-29 00:00:00'),(25,'1-20225','2B','2B225','MAIRIE 04 95 61 81 70 \r\nRESTO 04 95 61 73 95 \r\nPERSO 06 14 63 75 67',NULL,NULL,'CATERI','ANDREANI dominique','mairiedecateri@wanadoo.fr','-','MAIRIE DE CATERI','KB 39','29+28',219,NULL),(26,'1-05700','05','05700','Mairie 04 92 67 09 58\r\nPerso 04 92 67 08 34',NULL,NULL,'MEREUIL','REYNAUD odyle','mairie.mereuil@wanadoo.fr','-','MAIRIE DE MEREUIL','VA 31','44',78,'2015-05-07 00:00:00'),(27,'1-84660','84','84660','Mairie 04 90 76 92 09','Resp.achats TAMPORAIN christian\r\n06 85 92 06 79',NULL,'MAUBEC','MASSIP frédéric','mairiemaubec@wanadoo.fr','-','MAIRIE DE MAUBEC','TA 34','44',1900,'2015-05-06 00:00:00'),(28,'1-84220','84','84220','Mairie 04 90 72 22 60',NULL,NULL,'LES BEAUMETTES','ARAGONES claire','mairie.lesbeaumettes@wanadoo.fr','-','MAIRIE DE LES BEAUMETTES','TA 34','44',196,'2015-05-06 00:00:00'),(29,'1-09600','09','09600','Mairie 05 61 01 82 92\r\nPerso 05 61 01 21 41\r\nPort 06 33 96 83 66',NULL,NULL,'REGAT','MORELL michel','regat@voila.fr','-','MAIRIE DE REGAT','EA 37','37',62,'2015-05-07 00:00:00'),(30,'1-81120','81','81120','Mairie 05 63 55 54 16\r\nPerso 05 63 55 56 81\r\nPort 06 21 06 54 98',NULL,NULL,'FAUCH','ROUMEGOUX robert','mairiefauch@e-kiwi.fr','LYSARNARIE','MAIRIE DE FAUCH','GA 34','37',392,'2015-05-06 00:00:00'),(31,'2-81140','81','81140','Mairie 05 63 33 21 45',NULL,NULL,'MONTELS','RAU ludovic','mairie81176@gmail.com','-','MAIRIE DE MONTELS','EA 33','37',86,'2015-05-06 00:00:00'),(32,'1-81170','81','81170','Mairie 05 63 56 00 72\r\nPerso 05 63 56 05 10',NULL,NULL,'LIVERS CAZELLES','DONNADIEU denis','mairie.liverscazelles@orange.fr','LE CAMPS SOULET','MAIRIE DE LIVERS CAZELLES','FA 33','37',226,'2015-05-06 00:00:00'),(33,'1-46090','46','46090','Mairie 05 65 24 72 12\r\nPerso 05 65 31 61 84',NULL,NULL,'AUJOLS','DEJEAN genevieve','mairie.aujols@orange.fr','-','MAIRIE DE AUJOLS','DA 31','43',243,'2015-05-07 00:00:00'),(34,'1-31350','31','31350','Mairie 05 61 88 75 76\r\nPerso 05 61 88 75 55',NULL,NULL,'PEGUILHAN','BROCAS michel','mairiepeguilhan@orange.fr','-','MAIRIE DE PEGUILHAN','Z 36','43',221,'2015-05-06 00:00:00'),(35,'1-32170','32','32170','Mairie 05 62 67 04 41\r\nPerso 05 62 67 00 25\r\nPort 06 08 60 70 42',NULL,NULL,'SAINTE DODE','TUJAGUE hervé','sainte.dode@wanadoo.fr','-','MAIRIE DE SAINTE DODE','Y 36','39',238,'2015-05-06 00:00:00'),(36,'1-20217','2B','2B217','mairie 04 95 37 03 70 \r\nperso 04 95 37 10 63',NULL,'1ADJ MR CASTELLOTI JEAN 04 95 37 04 73 \r\nRESP VOIRIE MR ANTONNELI 06 17 92 38 82','SAINT- FLORENT','OLMETA claudy','mairie.saint-florent.corse@wanadoo.fr','-','MAIRIE DE SAINT-FLORENT','MB 39','29+28',1474,'2013-06-08 00:00:00'),(37,'1-20226','2B','2B226','MAIRIE  04 95 61 30 39 \r\nPERS  06 22 97 57 09',NULL,NULL,'OCCHIATANA','ORSONI Stephane','occhiatana@wanadoo.fr','-','MAIRIE DE OCCHIATANA','KB 39','29+28',163,'2014-12-04 00:00:00'),(38,'1-65400','65','65400','Mairie 05 62 97 53 28\r\nPerso 05 62 90 32 86\r\nPort 06 14 80 84 43',NULL,NULL,'ARTELENS SOUIN','Mme DULOUT andrée','mairie-artelenssouin@orange.fr','-','MAIRIE DE ARTELENS SOUIN','W 38','39',121,'2015-05-07 00:00:00'),(39,'1-65140','65','65140','Mairie 05 62 96 24 23\r\nPerso 05 62 96 28 80\r\nPort 06 81 65 56 73',NULL,NULL,'BAZILLAC','ROCHETEAU charles','commune.de.bazillac@orange.fr','-','MAIRIE DE BAZILLAC','X 36','39',374,'2015-05-07 00:00:00'),(40,'1-12120','12','12120','Mairie 05 65 69 46 06\r\nPort 06 32 54 42 60','Acheteur rodez',NULL,'SAINTE JULIETTE SUR VIAUR','WOROU simon','mairie.stejuliette@wanadoo.fr','-','MAIRIE DE SAINTE JULIETTE SUR VIAUR','HA 32','37',544,'2015-03-03 00:00:00'),(41,'1-15230','15','15230','Mairie 04 71 23 31 35\r\nPerso 04 71 23 31 33\r\nPort 06 72 57 39 61',NULL,NULL,'PAULHENC','ESTAMPE jean-pierre','paulhenc.mairie@wanadoo.fr','LAGARDE','MAIRIE DE PAULHENC','JA 29','37',283,'2015-05-19 00:00:00'),(42,'1-12360','12','12360','Mairie 05 65 49 55 74\r\nPort 06 78 25 11 25',NULL,NULL,'PEUX ET COUFFOULEUX','DEJOB alain','commune.couffouleux@orange.fr','COUFFOULEUX','MAIRIE DE PEUX ET COUFFOULEUX','JA 34','37',109,'2015-05-20 00:00:00'),(43,'1-12370','12','12370','Mairie 05 65 99 90 65\r\nPerso 05 65 99 90 99','entretien fait par le sivom du bel monte',NULL,'MURASSON','SICARD michèle','mairie-murasson@wanadoo.fr','-','MAIRIE DE MURASSON','IA 34','37',212,'2015-05-20 00:00:00'),(44,'1-24800','24','24800','Mairie 05 53 62 12 14\r\nPerso 05 53 62 12 79',NULL,NULL,'NANTHIAT','MEYNIER paul','mairie.nanthiat@wanadoo.fr','-','MAIRIE DE NANTHIAT','BA 27','43',291,'2015-05-20 00:00:00'),(45,'1-16140','16','16140','Mairie 05 45 39 01 73\r\nPerso 05 45 22 70 30',NULL,NULL,'LIGNE','AUTHIER alain','mairiedeligne@wanadoo.fr','-','MAIRIE DE LIGNE','X 24','43',158,'2015-05-19 00:00:00'),(46,'1-16230','16','16230','Mairie 05 45 39 03 40\r\nPerso 05 45 39 03 51',NULL,NULL,'VILLOGNON','GUITTON claude','mairie.villognon@wanadoo.fr','-','MAIRIE DE VILLOGNON','X 25','43',389,'2015-05-19 00:00:00'),(47,'1-04240','04','04240','Mairie 04 92 83 20 16\r\nPort 06 08 34 70 26',NULL,NULL,'LE FUGERET','PESCE andré','le.fugeret.mairie@wanadoo.fr','-','MAIRIE DE LE FUGERET','AB 33','39',227,'2015-05-22 00:00:00'),(48,'1-06510','06','06510','Mairie 04 93 59 12 34\r\nPerso 04 93 59 11 69',NULL,NULL,'BEZAUDUN LES ALPES','ARNAUD jean-paul','mairie.bezaudun@wanadoo.fr','-','MAIRIE DE BEZAUDUN LES ALPES','CB 34','39',143,'2015-05-21 00:00:00'),(49,'1-04370','04','04370','Mairie 04 92 83 43 01',NULL,NULL,'VILLARS-COLMARS','BLACHE patricia (1ere ADJ)','mairievillarscolmars@orange.fr','-','MAIRIE DE VILLARS-COLMARS','ZA 32','39',209,'2015-05-19 00:00:00'),(50,'1-04170','04','04170','Mairie 04 92 89 10 72\r\nPerso 04 92 83 06 62',NULL,NULL,'LA MURE ARGENS','DELSAUX alain','mairie.lamureargens@gmail.com','-','MAIRIE DE LA MURE ARGENS','ZA 33','39',324,'2015-05-19 00:00:00'),(51,'1-04200','04','04200','Mairie 04 92 62 16 46\r\nPerso 04 92 31 59 54',NULL,NULL,'VALERNES','EULOGE gérard','mairie-de-valernes@orange.fr','-','MAIRIE DE VALERNES','XA 32','39',231,'2015-05-19 00:00:00'),(52,'2-04200','04','04200','Mairie 04 92 62 21 17\r\nPerso 04 92 62 21 71\r\nPort 06 85 80 13 49',NULL,NULL,'MISON','GAY robert','mairie.mison@orange.fr','-','MAIRIE DE MISON','WA 32','39',849,'2015-05-19 00:00:00'),(53,'1-30730','30','30730','Mairie 04 66 35 02 91',NULL,NULL,'GAJAN','POUDEVIGNE jean-louis','contact@gajan.fr','-','MAIRIE DE GAJAN','PA 33','39',725,'2015-05-18 00:00:00'),(54,'1-34120','34','34120','Mairie 04 67 98 15 02\r\nPerso 04 67 98 34 78\r\nPort 06 08 67 35 30',NULL,NULL,'TOURBES','SERVELLERA frédéric (4ème ADJ)','mairie@tourbes.fr','-','MAIRIE DE TOURBES','LA 35','37',1628,'2015-05-22 00:00:00'),(55,'1-34600','34','34600','Mairie 04 67 95 04 55',NULL,NULL,'HEREPIAN','FONTES régis (4ème ADJ)','r.fontes@mairieherepian.fr','-','MAIRIE DE HEREPIAN','KA 35','37',1479,'2015-05-22 00:00:00'),(56,'1-40180','40','40180','Mairie 05 58 57 81 10\r\nPort 06 79 89 58 35',NULL,NULL,'OEYRELUY','DAGUERRE jean-louis','mairie@ville-oeyreluy.fr','-','MAIRIE DE OEYRELUY','R 34','43',1094,'2015-05-21 00:00:00'),(57,'1-40390','40','40390','Mairie 05 59 56 32 16\r\nPort 06 73 77 04 53',NULL,NULL,'SAINTE MARIE DE GOSSE','M. SERRES (RESP.TECH)','mairie.ste-marie-de-gosse@wanadoo.fr','-','MAIRIE DE SAINTE MARIE DE GOSSE','R 35','43',878,'2015-05-18 00:00:00'),(58,'1-40170','40','40170','Mairie 05 58 42 83 10\r\nPerso 05 58 42 50 50',NULL,NULL,'LIT ET MIXE','M. LEBERE (RESP.TECH)','mairie@lit-et-mixe.com','-','MAIRIE DE LIT ET MIXE','Q 33','43',1441,'2015-05-18 00:00:00'),(59,'1-16170','16','16170','Mairie 05 45 21 74 01\r\nPerso 05 45 96 51 47\r\nPort 06 26 90 15 56',NULL,NULL,'MAREUIL','RODET claudine','mareuilcharente@orange.fr','-','MAIRIE DE MAREUIL','W 25','43',350,'2015-05-19 00:00:00'),(60,'1-07600','07','07600','Mairie 04 75 37 47 12',NULL,NULL,'ASPERJOC','CHIRAUSSEL alain','mairieasperjoc@inforoutes-ardeche.fr','-','MAIRIE DE ASPERJOC','PA 30','44',361,'2015-05-20 00:00:00'),(61,'1-07560','07','07560','Mairie 04 75 38 95 06',NULL,NULL,'LE ROUX','COUDENE patrick','mairie.le-roux@wanadoo.fr','-','MAIRIE DE LE ROUX','OA 30','44',43,'2015-05-21 00:00:00'),(62,'1-07260','07','07260','Mairie 04 75 36 95 01',NULL,NULL,'DOMPNAC','MME DETE marie-christine','mairie.dompnac@ozone.net','-','MAIRIE DE DOMPNAC','OA 30','44',82,'2015-05-21 00:00:00'),(63,'2-16140','16','16140','Mairie 05 45 21 00 14\r\nPerso 05 45 21 03 77',NULL,NULL,'RANVILLE BREUILLAUD','BALLERY patrice (RESP.TECH)','mairie.ranville.breuillaud@wanadoo.fr','-','MAIRIE DE RANVILLE BREUILLAUD','W 25','43',178,'2015-05-29 00:00:00'),(64,'1-20232','2B','2B232','Mairie 04 95 39 01 09 port 06 88 07 55 61','MAIRE MR LECCIA',NULL,'OLETTA','MR PERFETTI etinne','oletta@wanadoo.fr','-','MAIRIE DE OLETTA','MB 39','28+29',830,'2015-04-23 00:00:00'),(65,'1-47400','47','47400','Mairie 05 53 83 40 35\r\nPerso 05 53 83 40 80',NULL,NULL,'FAUGUEROLLES','MME DE PARSCAU maryline','communedefauguerolles.47@wanadoo.fr','-','MAIRIE DE FAUGUEROLLES','X 31','43',559,'2015-05-27 00:00:00'),(66,'1-20213','2B','2B213','MAIRIE 04 95 36 55 44 PORT 06 13 83 07 23',NULL,'VOIRE A FOLLELI \r\nPAS VU','PENTA DI CASINCA','MR LUIGI christophe(resp tech)','mairie.pentadicasinca@wanadoo.fr','-','MAIRIE DE PENTA DI CASINCA','MB 40','28+29',2438,'2015-05-18 00:00:00'),(67,'1-40700','40','40700','Mairie 05 58 79 01 24\r\nPerso 05 58 79 04 61',NULL,NULL,'LABASTIDE CHALOSSE','BRISE roland','mairie.labastide-chalosse@wanadoo.fr','-','MAIRIE DE LABASTIDE CHALOSSE','T 35','43',117,'2015-05-28 00:00:00'),(68,'1-20230','2B','2B230','MAIRIE 04 95 36 91 15\r\nPERSO 04 95 36 99 06\r\nPort 06 12 49 97 92 - 06 67 67 91 15',NULL,NULL,'TALASANI','MR SEMIDEI louis-charles','mairietalasani@wanadoo.fr','-','MAIRIE DE TALASANI','MB 40','29+28',516,'2015-05-24 00:00:00'),(69,'1-20240','2B','2B240','MAIRIE 04 95 56 15 10\r\nPORT 06 29 27 10 65',NULL,NULL,'GHISONACCIA','MR MANCINI paul (RESP TECH)','mairie.ghisonaccia@wanadoo.fr','-','MAIRIE DE GHISONACCIA','MB 42','28+29',3168,'2015-05-24 00:00:00'),(70,'1-20270','2B','2B270','MAIRIE 04 95 57 00 73\r\nPORT 06 12 04 26 52',NULL,NULL,'ALERIA','MR LUCIANI jean-antoine (ADJ)','commune.aleria@orange.fr','LISTINCONE','MAIRIE DE ALERIA','MB 41','28+29',2042,'2015-04-20 00:00:00'),(71,'1-20270','2B','2B270','MAIRIE 04 95 56 60 33\r\nPORT 06 09 54 29 17',NULL,NULL,'AGHIONE','MR CASANOVA andre','commune.aghione@wanadoo.fr','-','MAIRIE DE AGHIONE','MB 41','28+29',245,'2014-12-01 00:00:00'),(72,'1-65100','65','65100','Mairie 05 62 42 92 76\r\nPerso 05 62 42 93 62',NULL,NULL,'LES ANGLES','MME LACAZE yvette','mairie.lesangles@wanadoo.fr','-','MAIRIE DE LES ANGLES','W 37','39',141,'2015-05-28 00:00:00'),(73,'1-65130','65','65130','Mairie 05 62 39 01 71',NULL,NULL,'BULAN','MME COLOMES marie-rose','-','-','MAIRIE DE BULAN','X 37','39',61,'2015-05-28 00:00:00'),(74,'1-20100','2A','2A100','MAIRIE 04 95 73 45 88\r\nPORT 06 07 47 91 75',NULL,NULL,'GIUNCHETO','MR PAOLINI francois','mairie.giuncheto@wanadoo.fr','-','MAIRIE DE GUINCHETO','KB 44','29+28',69,'2014-09-22 00:00:00'),(75,'1-12430','12','12430','Mairie 05 65 46 57 66\r\nPort 06 85 09 38 44','Maire : AURIOL daniel','Adj travaille à la comcom','LE TRUEL','M. ALIBERT (ADJ)','mairie.letruel@wanadoo.fr','-','MAIRIE DE LE TRUEL','IA 33','37',363,'2015-05-29 00:00:00'),(76,'1-31560','31','31560','Mairie 05 61 02 10 16\r\nPort 06 84 76 47 52',NULL,'CLIENT BLOQUE VENDEUR 29','CALMONT','M. MUNOZ (ADJ)','mairie.calmont.31@wanadoo.fr','-','MAIRIE DE CALMONT','DA 36','28+29',1610,'2015-05-30 00:00:00'),(77,'1-07120','07','07120','Mairie 04 75 39 68 68\r\nPerso 04 75 35 56 87\r\nPort 06 85 14 02 02',NULL,NULL,'PRADONS','RIEU yves','mairie.pradons@orange.fr','-','MAIRIE DE PRADONS','QA 31','44',295,'2015-05-28 00:00:00'),(78,'1-07320','07','07320','Mairie 04 75 30 00 99\r\nPerso 04 75 30 17 71\r\nPort 06 38 51 13 03',NULL,NULL,'DEVESSET','ROCHE étienne','mairie.devesset@inforoutes.fr','BERTHOUX','MAIRIE DE DEVESSET','QA 28','44',271,'2015-05-28 00:00:00'),(79,'1-20117','20','20117','Mairie 04 95 28 40 11\r\nPort 06 37 17 96 04','EMPL.COM Jeannot\r\n06 85 93 14 40','MAIRE : POLI pierre','ECCICA SUARELLA','BARTOLOMEI jean-françois','mairie.eccicasuarella@wanadoo.fr','-','MAIRIE DE ECCICA SUARELLA','KB 42','28+29',684,'2015-05-18 00:00:00'),(80,'1-20167','20','20167','Mairie 04 95 25 84 64\r\nPerso 04 95 25 62 32\r\nPort 06 10 02 29 17',NULL,NULL,'VALLE DI MEZZANA','LECA paul','valle-di-mezzana@orange.fr','-','MAIRIE DE VALLE DI MEZZANA','JB 42','28+29',217,'2015-05-20 00:00:00'),(81,'1-20218','20','20218','Mairie 04 95 47 80 07\r\nPerso 04 95 47 69 31',NULL,NULL,'MOLTIFAO','VINCENSINI augustin','mairie.moltifao@orange.fr','-','MAIRIE DE MOLTIFAO','LB 40','28+29',549,'2015-05-21 00:00:00'),(82,'2-24800','24','24800','Mairie 05 53 62 52 06\r\nPort 06 80 89 64 45',NULL,NULL,'SARRAZAC','CAZES jean-louis','mairie.sarrazac@wanadoo.fr','CAPUCHOU','MAIRIE DE SARRAZAC','BA 27','43',404,'2015-06-05 00:00:00'),(83,'1-12230','12','12230','Mairie 05 65 62 26 77\r\nPerso 05 65 62 13 45\r\nPort 06 70 52 84 03',NULL,NULL,'SAUCLIERES','ATCHER daniel','mairie-sauclieres@wanadoo.fr','-','MAIRIE DE SAUCLIERES','LA 33','37',147,'2015-06-04 00:00:00'),(84,'1-12480','12','12480','Mairie 05 65 99 40 31\r\nPerso 05 65 99 43 81','Mairie : SELLAM jean-jacques',NULL,'SAINT IZAIRE','RAMONDENC gérard','mairie-stizaire@wanadoo.fr','-','MAIRIE DE SAINT IZAIRE','IA 33','37',317,'2015-06-03 00:00:00'),(85,'2-40390','40','40390','Mairie 05 59 56 31 08','Maire : MME CAZALIS isabelle',NULL,'SAINT LAURENT DE GOSSE','M. COMETZ (ADJ)','communesaintlaurentdegosse@orange.fr','-','MAIRIE DE SAINT LAURENT DE GOSSE','R 35','43',481,'2015-06-04 00:00:00'),(86,'1-46160','46','46160','Mairie 05 65 40 60 71\r\nPort 06 24 94 32 65',NULL,NULL,'MONTBRUN','RAUFFET sylvie','commune-de-montbrun@orange.fr','-','MAIRIE DE MONTBRUN','FA 31','43',101,'2015-06-03 00:00:00'),(87,'2-46160','46','46160','Mairie 05 65 31 23 70\r\nPerso 05 65 31 27 69\r\nPort 06 37 54 59 04',NULL,NULL,'LARNAGOL','ORTALO-MAGNE andré','mairie.larnagol@wanadoo.fr','LE MOULIN','MAIRIE DE LARNAGOL','EA 31','43',157,'2015-06-03 00:00:00'),(88,'1-64120','64','64120','Mairie 05 59 37 85 80\r\nPerso 05 59 37 82 24',NULL,NULL,'IBAROLLE','CAZET jean-louis','herrikoetxea-ibarla@wanadoo.fr','ROUTE GAMIA','MAIRIE DE IBAROLLE','R 37','39',88,'2015-06-04 00:00:00'),(89,'1-64490','64','64490','Mairie 05 59 34 78 80\r\nPerso 05 59 34 58 13',NULL,NULL,'LESCUN','CAUHAPE pierre félix','courrier','-','MAIRIE DE LESCUN','T 38','39',203,'2015-06-04 00:00:00'),(90,'1-26300','26','26300','Mairie 04 75 59 80 55',NULL,NULL,'CHARPEY','COMTE jean-françois','mairie-de-charpey@wanadoo.fr','-','MAIRIE DE CHARPEY','TA 29','44',901,'2015-06-04 00:00:00'),(91,'1-26400','26','26400','Mairie 04 75 62 73 34\r\nPerso 04 75 25 22 44\r\nPort 06 85 91 47 17',NULL,NULL,'LA ROCHE SUR GRANE','BONNET christian','mairie.de.la.roche.sur.grane@wanadoo.fr','-','MAIRIE DE LA ROCHE SUR GRANE','SA 30','44',161,'2015-06-03 00:00:00'),(92,'1-26230','26','26230','Mairie 04 75 98 50 49',NULL,NULL,'CHANTEMERLE LES GRIGNAN','ORTIZ jacques','chantemerle.grignan@wanadoo.fr','-','MAIRIE DE CHANTEMERLE LES GRIGNAN','SA 31','44',231,'2015-06-03 00:00:00'),(93,'1-20227','20','20227','Mairie 04 95 57 61 28\r\nPort 06 37 86 13 79','Maire : ALBERTINI don marc',NULL,'GHISONI','M. COSTANTINI (1er ADJ)','mairie.ghisoni@wanadoo.fr','VILLAGE','MAIRIE DE GHISONI','LB 41','28+29',267,'2013-11-25 00:00:00'),(94,'1-09500','09','09500','Mairie 05 61 68 85 89\r\nPort 06 42 63 07 88',NULL,NULL,'BESSET','ALIBERT philippe','mairie.besset@orange.fr','BEOULYGUES','MAIRIE DE BESSET','EA 37','37',119,'2015-06-11 00:00:00'),(95,'2-09500','09','09500','Mairie 05 61 68 66 10\r\nPerso 05 61 68 66 04',NULL,NULL,'LAPENNE','PALMADE lucien','mairie-lapenne@wanadoo.fr','-','MAIRIE DE LAPENNE','EA 37','37',131,'2015-06-10 00:00:00'),(96,'1-31150','31','31150','Mairie 05 61 35 41 66\r\nPort 06 15 19 17 50',NULL,NULL,'MAIRIE DE LESPINASSE','M. LUBOWSKY (RESP.TECH)','dst@ville-lespinasse.fr','-','MAIRIE DE LESPINASSE','CA 34','28+29',1864,'2015-06-10 00:00:00'),(97,'1-31180','31','31180','Mairie 05 61 09 11 27\r\nPerso 05 61 09 40 35\r\nPort 06 72 01 51 41','MAIRE : M. SOURZAC',NULL,'ROUFFIAC TOLOSAN','USZES laurent (2ème ADJ)','mairie-rouffiac-tolosan@wanadoo.fr','-','MAIRIE DE ROUFFIAC TOLOSAN','DA 34','28+36',1404,'2015-06-15 00:00:00'),(99,'1-15110','15','15110','Mairie 04 71 23 57 45\r\nPerso 04 71 23 54 90\r\nPort 06 81 77 72 90',NULL,NULL,'SAINT REMY DE CHAUDES AIGUES','GENDRE vital','mairie.st-remy-de-chaudes-aigues@wanadoo.fr','LES FOURCHES','MAIRIE DE SAINT REMY DE CHAUDES AIGUES','KA 29','28+29',118,'2015-06-11 00:00:00'),(100,'1-15110','15','15110','Mairie 04 71 23 55 11\r\nPerso 04 71 23 95 86\r\nPort 06 72 77 15 36',NULL,NULL,'ESPINASSE','GENDRE christian','espinasse.mairie@wanadoo.fr','-','MAIRIE DE ESPINASSE','IA 29','28+29',80,'2015-06-11 00:00:00'),(101,'1-20231','20','20231','Mairie 04 95 47 00 15\r\nPort 06 19 07 08 77',NULL,NULL,'VENACO','MEZZADRI michel','mairie.venaco@orange.fr','RESTAU PLACE DU VILLAGE','MAIRIE DE VENACO','LB 41','36',657,'2015-06-09 00:00:00'),(102,'2-84220','84','84220','Mairie 04 90 05 61 64\r\nPerso 04 90 05 61 00\r\nPort 06 07 29 56 06',NULL,NULL,'LIOUX','FARGE francis','mairie.lioux@wanadoo.fr','VILLAGE','MAIRIE DE LIOUX','UA 33','44',248,'2015-06-12 00:00:00'),(103,'1-07270','07','07270','Mairie 04 75 06 58 25\r\nPort 06 72 33 66 91','MAIRE : ESPENEL dominique',NULL,'SAINT BARTHELEMY GROZON','JULIEN jean-paul (RESP.TECH)','ma-stbgr@inforoutes-ardeche.fr','-','MAIRIE DE SAINT BARTHELEMY GROZON','RA 29','44',469,'2015-06-11 00:00:00'),(104,'1-07570','07','07570','Mairie 04 75 06 68 62\r\nPerso 04 75 06 64 90\r\nPort 06 26 90 40 29','MAIRE : MARLIAC christian',NULL,'LABATIE D\'ANDAURE','MME REILLE chantal (1ère ADJE)','ma-labat@inforoutes-ardeche.fr','-','MAIRIE DE LABATIE D\'ANDAURE','QA 28','44',204,'2015-06-11 00:00:00'),(105,'1-07310','07','07310','Mairie 04 75 30 44 00\r\nPerso 04 75 30 53 70\r\nPort 06 76 15 07 32',NULL,NULL,'SAINT JULIEN BOUTIERES','BLANCHIN andré','mairie.st.julien.boutieres@inforoutes-ardeche.fr','SAUVERZAC','MAIRIE DE SAINT JULIEN BOUTIERES','QA 29','44',215,'2015-06-10 00:00:00'),(106,'1-07410','07','07410','Mairie 04 75 06 72 25\r\nPerso 04 75 06 76 19',NULL,NULL,'COLOMBIER LE VIEUX','FOUR béatrice','ma-colux@inforoutes-ardeche.fr','-','MAIRIE DE COLOMBIER LE VIEUX','RA 28','44',551,'2015-06-10 00:00:00'),(107,'1-07520','07','07520','Mairie 04 75 30 05 87\r\nPerso 04 75 30 05 88\r\nPort 06 86 06 41 74',NULL,NULL,'SAINT PIERRE SUR DOUX','VAUTARET michel','mmtv@orange.fr','-','MAIRIE DE SAINT PIERRE SUR DOUX','QA 28','44',85,'2015-06-10 00:00:00'),(108,'1-07410','07','07410','Mairie 04 75 06 00 47\r\nPerso 04 75 06 85 08\r\nPort 06 08 03 89 64',NULL,NULL,'SAINT VICTOR','AUDRAS maurice','ma-stvic@inforoutes.fr','-','MAIRIE DE SAINT VICTOR','RA 28','44',828,'2015-06-10 00:00:00'),(109,'2-07410','07','07410','Tel 04 75 06 71 70',NULL,NULL,'SAINT FELICIEN','BILLON cassandre','cassandre.billon@gmail.com','Place de l\'hôtel de ville','CAFE LE NORD','RA 28','44',0,'2015-06-10 00:00:00'),(110,'1-84570','84','84570','Mairie 04 90 61 81 41\r\nPerso 04 90 61 80 84',NULL,NULL,'BLAUVAC','RASPAIL max','blauvac@wanadoo.fr','-','MAIRIE DE BLAUVAC','TA 33','44',342,'2015-06-12 00:00:00'),(111,'1-07230','07','07230','Mairie 04 75 39 31 05\r\nPerso 04 75 39 34 14\r\nPort 06 07 67 62 78',NULL,NULL,'CHANDOLAS','MAHEY alain','mairie.chandolas@orange.fr','-','MAIRIE DE CHANDOLAS','PA 31','39',478,'2015-06-10 00:00:00'),(112,'1-30700','30','30700','Mairie 04 66 37 32 40\r\nPerso 04 66 37 32 50',NULL,NULL,'LA CAPELLE ET MASMOLENE','SAORIN jean-claude','mairie.lacapelleetmasmolene@orange.fr','-','MAIRIE DE LA CAPELLE ET MASMOLENE','QA 33','39',400,'2015-06-10 00:00:00'),(113,'1-07460','07','07460','Mairie 04 75 39 32 06\r\nPerso 04 75 39 03 00',NULL,NULL,'BEAULIEU','BORIE jean-françois','mairie.beaulieu@inforoutes-ardeche.fr','-','MAIRIE DE BEAULIEU','PA 31','39',400,'2015-06-11 00:00:00'),(114,'2-07320','07','07320','Mairie 04 75 30 11 86\r\nPerso 04 75 30 10 11\r\nPort 06 86 5138 62',NULL,NULL,'SAINT JEURE D\'ANDAURE','SENECLAUZE henri','ma-stjda@inforoutes-ardeche.fr','-','MAIRIE DE SAINT JEURE D\'ANDAURE','QA 28','44',96,'2015-06-11 00:00:00');

--
-- Table structure for table `Commande`
--

CREATE TABLE `Commande` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `article_id` int(11) DEFAULT NULL,
  `lot_id` int(11) DEFAULT NULL,
  `facture_id` int(11) DEFAULT NULL,
  `quantite` double DEFAULT NULL,
  `quantite_lot` int(11) DEFAULT NULL,
  `ordered_at` datetime NOT NULL,
  `tva` double DEFAULT NULL,
  `article_nom` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lot_nom` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `prix_article_ht` double NOT NULL,
  `prix_total_ht` double NOT NULL,
  `article_unite` int(11) DEFAULT NULL,
  `remise` double DEFAULT NULL,
  `bonLivraison_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_979CC42B7294869C` (`article_id`),
  KEY `IDX_979CC42BA8CBA5F7` (`lot_id`),
  KEY `IDX_979CC42BFE87FC16` (`bonLivraison_id`),
  KEY `IDX_979CC42B7F2DEE08` (`facture_id`),
  CONSTRAINT `FK_979CC42B7294869C` FOREIGN KEY (`article_id`) REFERENCES `Article` (`id`),
  CONSTRAINT `FK_979CC42B7F2DEE08` FOREIGN KEY (`facture_id`) REFERENCES `Facture` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_979CC42BA8CBA5F7` FOREIGN KEY (`lot_id`) REFERENCES `Lot` (`id`),
  CONSTRAINT `FK_979CC42BFE87FC16` FOREIGN KEY (`bonLivraison_id`) REFERENCES `BonLivraison` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=448 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Commande`
--

INSERT INTO `Commande` VALUES (1,1,NULL,NULL,20,NULL,'2015-03-26 18:55:25',20,'DESHERBANT TOTAL PJT',NULL,63.3,1266,2,0,NULL),(2,2,NULL,NULL,10,NULL,'2015-03-26 18:55:25',20,'OMPS CONTENEUR',NULL,78.6,786,2,0,NULL),(3,3,NULL,NULL,20,NULL,'2015-03-26 18:55:25',20,'DETERGENT SOLLO E50',NULL,25.1,502,2,0,NULL),(4,4,NULL,NULL,10,NULL,'2015-03-26 18:55:25',20,'RATICIDE PRO BLE',NULL,49,490,1,0,NULL),(5,NULL,1,NULL,NULL,1,'2015-03-26 18:55:25',NULL,NULL,'ORDINATEUR',0,0,NULL,0,NULL),(6,NULL,2,NULL,NULL,1,'2015-03-26 18:55:25',NULL,NULL,'TELEPHONE PORTABLE',0,0,NULL,0,NULL),(7,5,NULL,NULL,1,NULL,'2015-03-26 18:55:25',20,'TRACING BLANC',NULL,69.2,69.2,3,0,NULL),(8,8,NULL,NULL,10,NULL,'2015-03-27 15:30:26',20,'REPULSIF R.P PRO',NULL,49.3,493,2,0,NULL),(9,NULL,3,NULL,NULL,1,'2015-03-27 15:30:26',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,NULL),(14,10,NULL,NULL,2,NULL,'2015-03-27 19:47:37',20,'RATICIDE PRO BLOC',NULL,59.75,117.11,1,2,NULL),(15,10,NULL,NULL,2,NULL,'2015-03-27 19:55:43',20,'RATICIDE PRO BLOC',NULL,59.75,117.11,1,2,NULL),(16,NULL,6,NULL,NULL,1,'2015-03-27 19:55:43',NULL,NULL,'CUMUL',0,0,NULL,2,NULL),(17,12,NULL,NULL,20,NULL,'2015-04-08 11:54:24',20,'GARDENET GRANULE',NULL,83.4,1668,1,0,NULL),(18,33,NULL,NULL,18,NULL,'2015-04-08 11:54:24',20,'SAVON MICROBILLES',NULL,39.7,714.6,2,0,NULL),(19,NULL,3,NULL,NULL,1,'2015-04-08 11:54:24',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,NULL),(20,34,NULL,14,3,NULL,'2015-05-04 14:40:33',20,'ANTIROUILLE VERT RAL 6005',NULL,126.4,379.2,2,0,7),(21,35,NULL,14,5,NULL,'2015-05-04 14:40:33',20,'LASURE BOIS CHÊNE CLAIR',NULL,106.1,530.5,2,0,7),(22,NULL,3,14,NULL,1,'2015-05-04 14:40:33',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,7),(23,1,NULL,38,5,NULL,'2015-05-04 14:51:10',20,'DESHERBANT TOTAL PJT',NULL,63.3,316.5,2,0,8),(24,NULL,7,38,NULL,1,'2015-05-04 14:51:10',NULL,NULL,'COUTEAUX',0,0,NULL,0,8),(25,1,NULL,34,5,NULL,'2015-05-04 15:00:10',20,'DESHERBANT TOTAL PJT',NULL,63.3,316.5,2,0,9),(26,NULL,7,34,NULL,2,'2015-05-04 15:00:10',NULL,NULL,'COUTEAUX',0,0,NULL,0,9),(27,3,NULL,15,20,NULL,'2015-05-04 15:20:57',20,'DETERGENT SOLLO E50',NULL,25.1,502,2,0,10),(28,36,NULL,15,6,NULL,'2015-05-04 15:20:57',20,'INSECTICIDE SGF',NULL,61.4,368.4,3,0,10),(29,37,NULL,15,2,NULL,'2015-05-04 15:26:49',20,'BALAI PLAT 60CM',NULL,0,0,3,0,10),(30,NULL,7,15,NULL,1,'2015-05-04 15:27:06',NULL,NULL,'COUTEAUX',0,0,NULL,0,10),(31,10,NULL,17,6,NULL,'2015-05-04 16:16:24',20,'RATICIDE PRO BLOC',NULL,59.75,358.5,1,0,11),(32,NULL,7,17,NULL,1,'2015-05-04 16:16:24',NULL,NULL,'COUTEAUX',0,0,NULL,0,11),(33,38,NULL,NULL,5,NULL,'2015-05-04 16:32:52',20,'REPULSIF R.CC',NULL,59.3,296.5,2,0,NULL),(34,10,NULL,NULL,2,NULL,'2015-05-04 16:32:52',20,'RATICIDE PRO BLOC',NULL,59.75,119.5,1,0,NULL),(35,36,NULL,NULL,1,NULL,'2015-05-04 16:32:52',20,'INSECTICIDE SGF',NULL,61.4,61.4,3,0,NULL),(36,39,NULL,NULL,1,NULL,'2015-05-04 16:32:52',20,'GEL WC ECOLOGIQUE',NULL,30.9,30.9,2,0,NULL),(37,NULL,2,NULL,NULL,1,'2015-05-04 16:32:52',NULL,NULL,'TELEPHONE PORTABLE',0,0,NULL,0,NULL),(38,8,NULL,19,10,NULL,'2015-05-04 16:45:51',20,'REPULSIF R.P PRO',NULL,49.3,345.1,2,30,13),(39,40,NULL,19,30,NULL,'2015-05-04 16:45:51',20,'ANTIMOUSSE ECO',NULL,29.9,627.9,2,30,13),(40,NULL,9,19,NULL,1,'2015-05-04 16:46:58',NULL,NULL,'VIN',0,0,NULL,30,13),(41,NULL,10,19,NULL,1,'2015-05-04 16:46:58',NULL,NULL,'MALETTE OUTILS',0,0,NULL,30,13),(42,3,NULL,22,20,NULL,'2015-05-04 16:58:19',20,'DETERGENT SOLLO E50',NULL,25.1,502,2,0,14),(43,41,NULL,22,20,NULL,'2015-05-04 16:58:19',20,'SAVON NACREE',NULL,22.34,446.8,2,0,14),(44,39,NULL,22,6,NULL,'2015-05-04 16:58:19',20,'GEL WC ECOLOGIQUE',NULL,30.9,185.4,2,0,14),(45,42,NULL,22,2,NULL,'2015-05-04 16:58:19',20,'DISTRIBUTEUR DE SAVON',NULL,0,0,3,0,14),(46,NULL,3,22,NULL,1,'2015-05-04 16:58:19',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,14),(47,NULL,9,19,NULL,1,'2015-05-05 08:41:34',NULL,NULL,'VIN',0,0,NULL,30,13),(48,NULL,9,19,NULL,1,'2015-05-05 08:41:34',NULL,NULL,'VIN',0,0,NULL,30,13),(49,3,NULL,23,20,NULL,'2015-05-05 08:55:42',20,'DETERGENT SOLLO E50',NULL,25.1,502,2,0,15),(50,43,NULL,23,6,NULL,'2015-05-05 08:55:42',20,'TRACING JAUNE',NULL,69.2,415.2,3,0,15),(51,40,NULL,23,30,NULL,'2015-05-05 08:55:42',20,'ANTIMOUSSE ECO',NULL,29.9,897,2,0,15),(52,44,NULL,23,50,NULL,'2015-05-05 08:55:42',20,'TRAITEMENT MVS',NULL,9.9,495,1,0,15),(53,1,NULL,23,20,NULL,'2015-05-05 08:55:42',20,'DESHERBANT TOTAL PJT',NULL,63.3,1266,2,0,15),(54,45,NULL,23,1,NULL,'2015-05-05 08:55:42',20,'CANNE DE TRACAGE',NULL,0,0,3,0,15),(55,NULL,11,23,NULL,1,'2015-05-05 08:55:42',NULL,NULL,'MINI ORDINATEUR',0,0,NULL,0,15),(56,NULL,7,23,NULL,1,'2015-05-05 08:55:42',NULL,NULL,'COUTEAUX',0,0,NULL,0,15),(57,NULL,10,23,NULL,1,'2015-05-05 08:55:42',NULL,NULL,'MALETTE OUTILS',0,0,NULL,0,15),(58,NULL,9,23,NULL,1,'2015-05-05 08:55:42',NULL,NULL,'VIN',0,0,NULL,0,15),(59,NULL,9,23,NULL,1,'2015-05-05 08:55:42',NULL,NULL,'VIN',0,0,NULL,0,15),(60,NULL,9,23,NULL,1,'2015-05-05 08:55:42',NULL,NULL,'VIN',0,0,NULL,0,15),(61,10,NULL,24,10,NULL,'2015-05-05 09:03:00',20,'RATICIDE PRO BLOC',NULL,59.75,597.5,1,0,16),(62,NULL,2,24,NULL,1,'2015-05-05 09:03:00',NULL,NULL,'TELEPHONE PORTABLE',0,0,NULL,0,16),(63,1,NULL,NULL,5,NULL,'2015-05-06 11:46:10',20,'DESHERBANT TOTAL PJT',NULL,63.3,316.5,2,0,NULL),(64,2,NULL,NULL,5,NULL,'2015-05-06 11:46:10',20,'OMPS CONTENEUR',NULL,78.6,393,2,0,NULL),(65,NULL,1,NULL,NULL,1,'2015-05-06 11:46:10',NULL,NULL,'ORDINATEUR',0,0,NULL,0,NULL),(66,31,NULL,40,5,NULL,'2015-05-06 12:25:26',20,'DETERGENT ECOLABEL',NULL,37.2,186,2,0,18),(67,46,NULL,40,20,NULL,'2015-05-06 12:25:26',20,'SUPER ABSORBANT',NULL,11.35,227,1,0,18),(68,NULL,2,40,NULL,1,'2015-05-06 12:25:26',NULL,NULL,'TELEPHONE PORTABLE',0,0,NULL,0,18),(69,8,NULL,44,5,NULL,'2015-05-06 12:34:15',20,'REPULSIF R.P PRO',NULL,49.3,246.5,2,0,19),(70,44,NULL,44,50,NULL,'2015-05-06 12:34:15',20,'TRAITEMENT MVS',NULL,9.9,495,1,0,19),(71,13,NULL,44,20,NULL,'2015-05-06 12:34:15',20,'FLORANID GAZON',NULL,35.97,719.4,1,0,19),(72,NULL,10,44,NULL,1,'2015-05-06 12:34:15',NULL,NULL,'MALETTE OUTILS',0,0,NULL,0,19),(73,NULL,7,44,NULL,1,'2015-05-06 12:34:15',NULL,NULL,'COUTEAUX',0,0,NULL,0,19),(74,44,NULL,41,25,NULL,'2015-05-06 12:40:43',20,'TRAITEMENT MVS',NULL,9.9,247.5,1,0,20),(75,3,NULL,41,5,NULL,'2015-05-06 12:40:43',20,'DETERGENT SOLLO E50',NULL,25.1,125.5,2,0,20),(76,NULL,7,41,NULL,1,'2015-05-06 12:40:43',NULL,NULL,'COUTEAUX',0,0,NULL,0,20),(77,47,NULL,NULL,25,NULL,'2015-05-11 11:40:55',20,'DEVERGLACANT P',NULL,10.7,267.5,1,0,21),(78,NULL,7,NULL,NULL,1,'2015-05-11 11:40:55',NULL,NULL,'COUTEAUX',0,0,NULL,0,21),(79,3,NULL,42,5,NULL,'2015-05-11 11:49:37',20,'DETERGENT SOLLO E50',NULL,25.1,125.5,2,0,22),(80,33,NULL,42,4.5,NULL,'2015-05-11 11:49:37',20,'SAVON MICROBILLES',NULL,39.7,178.65,2,0,22),(81,NULL,7,42,NULL,1,'2015-05-11 11:49:37',NULL,NULL,'COUTEAUX',0,0,NULL,0,22),(82,33,NULL,39,9,NULL,'2015-05-11 12:00:31',20,'SAVON MICROBILLES',NULL,39.7,357.3,2,0,23),(83,48,NULL,39,2,NULL,'2015-05-11 12:00:31',20,'GEL HYDROALCOOLIQUE',NULL,67.6,135.2,2,0,23),(84,NULL,2,39,NULL,1,'2015-05-11 12:00:31',NULL,NULL,'TELEPHONE PORTABLE',0,0,NULL,0,23),(85,1,NULL,37,5,NULL,'2015-05-11 12:16:47',20,'DESHERBANT TOTAL PJT',NULL,63.3,316.5,2,0,24),(86,NULL,7,37,NULL,1,'2015-05-11 12:16:47',NULL,NULL,'COUTEAUX',0,0,NULL,0,24),(87,NULL,9,37,NULL,1,'2015-05-11 12:16:47',NULL,NULL,'VIN',0,0,NULL,0,24),(88,46,NULL,33,20,NULL,'2015-05-11 12:22:50',20,'SUPER ABSORBANT',NULL,11.35,227,1,0,25),(89,NULL,9,33,NULL,1,'2015-05-11 12:22:50',NULL,NULL,'VIN',0,0,NULL,0,25),(90,NULL,9,33,NULL,1,'2015-05-11 12:22:50',NULL,NULL,'VIN',0,0,NULL,0,25),(91,3,NULL,36,10,NULL,'2015-05-11 13:54:43',20,'DETERGENT SOLLO E50',NULL,25.1,251,2,0,26),(92,NULL,7,36,NULL,1,'2015-05-11 13:54:43',NULL,NULL,'COUTEAUX',0,0,NULL,0,26),(93,10,NULL,35,20,NULL,'2015-05-11 13:59:35',20,'RATICIDE PRO BLOC',NULL,59.75,1195,1,0,27),(95,NULL,2,35,NULL,1,'2015-05-11 13:59:35',NULL,NULL,'TELEPHONE PORTABLE',0,0,NULL,0,27),(96,NULL,3,35,NULL,1,'2015-05-11 13:59:35',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,27),(97,NULL,7,35,NULL,1,'2015-05-11 13:59:35',NULL,NULL,'COUTEAUX',0,0,NULL,0,27),(98,NULL,9,35,NULL,1,'2015-05-11 13:59:35',NULL,NULL,'VIN',0,0,NULL,0,27),(99,3,NULL,62,5,NULL,'2015-05-11 14:03:35',20,'DETERGENT SOLLO E50',NULL,25.1,125.5,2,0,28),(100,NULL,6,62,NULL,1,'2015-05-11 14:03:35',NULL,NULL,'CUMUL',0,0,NULL,0,28),(101,49,NULL,30,20,NULL,'2015-05-11 14:13:05',20,'INSECTICIDE BARRAGE',NULL,53.8,1076,2,0,29),(102,28,NULL,30,10,NULL,'2015-05-11 14:13:05',20,'ONE SHOT BACTERICIDE',NULL,80.15,801.5,3,0,29),(103,50,NULL,30,6,NULL,'2015-05-11 14:13:05',20,'DEBOUCHEUR PUISSANT',NULL,46.2,277.2,2,0,29),(104,10,NULL,30,2,NULL,'2015-05-11 14:13:05',20,'RATICIDE PRO BLOC',NULL,59.75,119.5,1,0,29),(105,51,NULL,30,2,NULL,'2015-05-11 14:13:05',20,'POSTE D\'APPATAGE',NULL,0,0,3,0,29),(106,NULL,3,30,NULL,1,'2015-05-11 14:13:05',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,29),(107,NULL,2,30,NULL,1,'2015-05-11 14:13:05',NULL,NULL,'TELEPHONE PORTABLE',0,0,NULL,0,29),(108,NULL,12,30,NULL,1,'2015-05-11 14:13:50',NULL,NULL,'BATTERIE CASSEROLES',0,0,NULL,0,29),(109,1,NULL,28,5,NULL,'2015-05-11 14:24:26',20,'DESHERBANT TOTAL PJT',NULL,63.3,316.5,2,0,30),(110,32,NULL,28,5,NULL,'2015-05-11 14:24:26',20,'BRINOX',NULL,41.2,206,2,0,30),(111,NULL,13,28,NULL,1,'2015-05-11 14:24:26',NULL,NULL,'MALETTE BOUCHER',0,0,NULL,0,30),(112,3,NULL,NULL,5,NULL,'2015-05-11 14:39:56',20,'DETERGENT SOLLO E50',NULL,25.1,125.5,2,0,31),(113,52,NULL,NULL,22,NULL,'2015-05-11 14:39:56',20,'TARAX - TRAITEMENT FOSSE',NULL,14.71,323.62,3,0,31),(114,NULL,14,NULL,NULL,1,'2015-05-11 14:39:56',NULL,NULL,'PLANCHA',0,0,NULL,0,31),(115,NULL,9,NULL,NULL,1,'2015-05-11 14:39:56',NULL,NULL,'VIN',0,0,NULL,0,31),(116,NULL,9,NULL,NULL,1,'2015-05-11 14:39:56',NULL,NULL,'VIN',0,0,NULL,0,31),(117,3,NULL,29,20,NULL,'2015-05-11 14:45:56',20,'DETERGENT SOLLO E50',NULL,25.1,502,2,0,32),(118,NULL,15,29,NULL,1,'2015-05-11 14:45:56',NULL,NULL,'DEBROUSSAILLEUSE',0,0,NULL,0,32),(119,53,NULL,32,10,NULL,'2015-05-11 14:59:17',20,'RATICIDE BLOC PRO',NULL,59.9,599,1,0,33),(120,51,NULL,32,4,NULL,'2015-05-11 14:59:17',20,'POSTE D\'APPATAGE',NULL,0,0,3,0,33),(121,38,NULL,21,5,NULL,'2015-05-12 17:55:27',20,'REPULSIF R.CC',NULL,59.3,296.5,2,0,34),(122,10,NULL,21,2,NULL,'2015-05-12 17:55:27',20,'RATICIDE PRO BLOC',NULL,59.75,119.5,1,0,34),(123,36,NULL,21,1,NULL,'2015-05-12 17:55:27',20,'INSECTICIDE SGF',NULL,61.4,61.4,3,0,34),(124,39,NULL,21,1,NULL,'2015-05-12 17:55:27',20,'GEL WC ECOLOGIQUE',NULL,30.9,30.9,2,0,34),(125,NULL,2,21,NULL,1,'2015-05-12 17:55:27',NULL,NULL,'TELEPHONE PORTABLE',0,0,NULL,0,34),(126,38,NULL,25,10,NULL,'2015-05-26 16:32:18',20,'REPULSIF R.CC',NULL,59.3,593,2,0,35),(127,1,NULL,25,10,NULL,'2015-05-26 16:32:18',20,'DESHERBANT TOTAL PJT',NULL,63.3,633,2,0,35),(128,NULL,10,25,NULL,1,'2015-05-26 16:32:18',NULL,NULL,'MALETTE OUTILS',0,0,NULL,0,35),(129,28,NULL,59,3,NULL,'2015-05-26 17:33:18',20,'ONE SHOT BACTERICIDE',NULL,80.15,240.45,3,0,36),(130,29,NULL,59,3,NULL,'2015-05-26 17:33:18',20,'ONE SHOT INSECTICIDE',NULL,84.2,252.6,3,0,36),(131,33,NULL,59,4.5,NULL,'2015-05-26 17:33:18',20,'SAVON MICROBILLES',NULL,39.7,178.65,2,0,36),(132,1,NULL,59,10,NULL,'2015-05-26 17:33:18',20,'DESHERBANT TOTAL PJT',NULL,63.3,633,2,0,36),(133,40,NULL,59,30,NULL,'2015-05-26 17:33:18',20,'ANTIMOUSSE ECO',NULL,29.9,897,2,0,36),(134,NULL,1,59,NULL,1,'2015-05-26 17:33:18',NULL,NULL,'ORDINATEUR',0,0,NULL,0,36),(135,1,NULL,60,5,NULL,'2015-05-27 09:07:54',20,'DESHERBANT TOTAL PJT',NULL,63.3,316.5,2,0,37),(136,3,NULL,60,10,NULL,'2015-05-27 09:07:54',20,'DETERGENT SOLLO E50',NULL,25.1,251,2,0,37),(137,28,NULL,60,3,NULL,'2015-05-27 09:07:54',20,'ONE SHOT BACTERICIDE',NULL,80.15,240.45,3,0,37),(138,29,NULL,60,3,NULL,'2015-05-27 09:07:54',20,'ONE SHOT INSECTICIDE',NULL,84.2,252.6,3,0,37),(139,38,NULL,60,5,NULL,'2015-05-27 09:07:54',20,'REPULSIF R.CC',NULL,59.3,296.5,2,0,37),(140,NULL,3,60,NULL,1,'2015-05-27 09:07:54',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,37),(141,NULL,7,60,NULL,1,'2015-05-27 09:07:54',NULL,NULL,'COUTEAUX',0,0,NULL,0,37),(142,1,NULL,27,15,NULL,'2015-05-27 09:18:09',20,'DESHERBANT TOTAL PJT',NULL,63.3,949.5,2,0,38),(143,40,NULL,27,30,NULL,'2015-05-27 09:18:09',20,'ANTIMOUSSE ECO',NULL,29.9,897,2,0,38),(144,NULL,9,27,NULL,1,'2015-05-27 09:18:09',NULL,NULL,'VIN',0,0,NULL,0,38),(145,NULL,9,27,NULL,1,'2015-05-27 09:18:09',NULL,NULL,'VIN',0,0,NULL,0,38),(146,NULL,14,27,NULL,1,'2015-05-27 09:18:09',NULL,NULL,'PLANCHA',0,0,NULL,0,38),(147,NULL,3,27,NULL,1,'2015-05-27 09:18:09',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,38),(148,NULL,10,27,NULL,1,'2015-05-27 09:18:09',NULL,NULL,'MALETTE OUTILS',0,0,NULL,0,38),(149,33,NULL,26,18,NULL,'2015-05-27 09:30:39',20,'SAVON MICROBILLES',NULL,39.7,714.6,2,0,39),(150,NULL,9,26,NULL,1,'2015-05-27 09:30:39',NULL,NULL,'VIN',0,0,NULL,0,39),(151,NULL,9,26,NULL,1,'2015-05-27 09:30:39',NULL,NULL,'VIN',0,0,NULL,0,39),(152,NULL,3,26,NULL,1,'2015-05-27 09:30:39',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,39),(153,40,NULL,50,30,NULL,'2015-05-27 09:43:25',20,'ANTIMOUSSE ECO',NULL,29.9,897,2,0,40),(154,47,NULL,50,100,NULL,'2015-05-27 09:43:25',20,'DEVERGLACANT P',NULL,10.7,1070,1,0,40),(155,54,NULL,50,1,NULL,'2015-05-27 09:43:25',20,'SECHE MAIN ELECTRIQUE',NULL,0,0,3,0,40),(156,2,NULL,72,5,NULL,'2015-05-27 10:49:39',20,'OMPS CONTENEUR',NULL,78.6,393,2,0,41),(157,NULL,3,72,NULL,1,'2015-05-27 10:49:39',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,41),(158,NULL,7,72,NULL,1,'2015-05-27 10:49:39',NULL,NULL,'COUTEAUX',0,0,NULL,0,41),(159,55,NULL,72,8,NULL,'2015-05-27 10:51:11',20,'PEGAKOTE VERT RAL 6005',NULL,118.2,945.6,1,0,41),(160,33,NULL,79,4.5,NULL,'2015-05-27 10:57:50',20,'SAVON MICROBILLES',NULL,39.7,178.65,2,0,42),(161,3,NULL,79,10,NULL,'2015-05-27 10:57:50',20,'DETERGENT SOLLO E50',NULL,25.1,251,2,0,42),(162,1,NULL,79,5,NULL,'2015-05-27 10:57:50',20,'DESHERBANT TOTAL PJT',NULL,63.3,316.5,2,0,42),(163,36,NULL,79,3,NULL,'2015-05-27 10:57:50',20,'INSECTICIDE SGF',NULL,61.4,184.2,3,0,42),(164,NULL,2,79,NULL,1,'2015-05-27 10:57:50',NULL,NULL,'TELEPHONE PORTABLE',0,0,NULL,0,42),(165,NULL,7,79,NULL,1,'2015-05-27 10:57:50',NULL,NULL,'COUTEAUX',0,0,NULL,0,42),(166,33,NULL,73,18,NULL,'2015-05-27 11:32:55',20,'SAVON MICROBILLES',NULL,39.7,714.6,2,0,43),(167,56,NULL,73,10,NULL,'2015-05-27 11:32:55',20,'VAISSELLE BRIO',NULL,29.44,294.4,2,0,43),(168,3,NULL,73,5,NULL,'2015-05-27 11:32:55',20,'DETERGENT SOLLO E50',NULL,25.1,125.5,2,0,43),(169,NULL,3,73,NULL,1,'2015-05-27 11:32:55',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,43),(170,NULL,9,73,NULL,1,'2015-05-27 11:32:55',NULL,NULL,'VIN',0,0,NULL,0,43),(172,38,NULL,76,20,NULL,'2015-05-27 11:48:19',20,'REPULSIF R.CC',NULL,59.3,1186,2,0,44),(173,NULL,3,76,NULL,1,'2015-05-27 11:48:19',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,44),(174,NULL,2,76,NULL,1,'2015-05-27 11:48:19',NULL,NULL,'TELEPHONE PORTABLE',0,0,NULL,0,44),(175,1,NULL,77,5,NULL,'2015-05-27 11:54:32',20,'DESHERBANT TOTAL PJT',NULL,63.3,316.5,2,0,45),(176,33,NULL,77,4.5,NULL,'2015-05-27 11:54:32',20,'SAVON MICROBILLES',NULL,39.7,178.65,2,0,45),(177,57,NULL,77,20,NULL,'2015-05-27 11:54:32',20,'PROJAV',NULL,9.1,182,2,0,45),(178,NULL,15,77,NULL,1,'2015-05-27 11:54:32',NULL,NULL,'DEBROUSSAILLEUSE',0,0,NULL,0,45),(179,NULL,9,77,NULL,1,'2015-05-27 11:54:32',NULL,NULL,'VIN',0,0,NULL,0,45),(180,5,NULL,78,6,NULL,'2015-05-27 14:15:33',20,'TRACING BLANC',NULL,69.2,415.2,3,0,46),(181,36,NULL,78,6,NULL,'2015-05-27 14:15:33',20,'INSECTICIDE SGF',NULL,61.4,368.4,3,0,46),(182,38,NULL,78,10,NULL,'2015-05-27 14:15:33',20,'REPULSIF R.CC',NULL,59.3,593,2,0,46),(183,NULL,10,78,NULL,1,'2015-05-27 14:15:33',NULL,NULL,'MALETTE OUTILS',0,0,NULL,0,46),(184,NULL,14,78,NULL,1,'2015-05-27 14:15:33',NULL,NULL,'PLANCHA',0,0,NULL,0,46),(185,1,NULL,58,10,NULL,'2015-05-27 14:21:42',20,'DESHERBANT TOTAL PJT',NULL,63.3,633,2,0,47),(186,36,NULL,58,6,NULL,'2015-05-27 14:21:42',20,'INSECTICIDE SGF',NULL,61.4,368.4,3,0,47),(187,NULL,2,58,NULL,1,'2015-05-27 14:21:42',NULL,NULL,'TELEPHONE PORTABLE',0,0,NULL,0,47),(188,NULL,3,58,NULL,1,'2015-05-27 14:21:42',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,47),(189,38,NULL,56,10,NULL,'2015-05-27 14:33:16',20,'REPULSIF R.CC',NULL,59.3,593,2,0,48),(190,NULL,3,56,NULL,1,'2015-05-27 14:33:16',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,48),(191,58,NULL,NULL,20,NULL,'2015-05-27 14:40:42',20,'PROTECTAG',NULL,88.8,1776,2,0,49),(192,NULL,16,NULL,NULL,1,'2015-05-27 14:40:42',NULL,NULL,'ORDI TABLETTE',0,0,NULL,0,49),(193,18,NULL,53,15,NULL,'2015-05-27 14:51:43',20,'STADOR BLANC',NULL,27.2,408,1,0,50),(194,3,NULL,53,5,NULL,'2015-05-27 14:51:43',20,'DETERGENT SOLLO E50',NULL,25.1,125.5,2,0,50),(195,36,NULL,53,6,NULL,'2015-05-27 14:51:43',20,'INSECTICIDE SGF',NULL,61.4,368.4,3,0,50),(196,NULL,17,53,NULL,1,'2015-05-27 14:52:11',NULL,NULL,'CHAMPAGNE',0,0,NULL,0,50),(197,11,NULL,52,10,NULL,'2015-05-27 14:59:23',20,'DEVATOL PJT',NULL,145.2,1452,2,0,51),(198,NULL,3,52,NULL,1,'2015-05-27 14:59:23',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,51),(199,NULL,2,52,NULL,1,'2015-05-27 14:59:23',NULL,NULL,'TELEPHONE PORTABLE',0,0,NULL,0,51),(200,11,NULL,54,10,NULL,'2015-05-27 15:05:41',20,'DEVATOL PJT',NULL,145.2,1452,2,0,52),(201,18,NULL,54,15,NULL,'2015-05-27 15:05:41',20,'STADOR BLANC',NULL,27.2,408,1,0,52),(202,40,NULL,54,30,NULL,'2015-05-27 15:05:41',20,'ANTIMOUSSE ECO',NULL,29.9,897,2,0,52),(204,NULL,3,54,NULL,1,'2015-05-27 15:05:41',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,52),(205,NULL,18,54,NULL,1,'2015-05-27 15:05:41',NULL,NULL,'TV',0,0,NULL,0,52),(206,59,NULL,54,10,NULL,'2015-05-27 15:09:26',20,'DEGRAISSANT ECOLABEL',NULL,39.2,392,2,0,52),(207,11,NULL,48,10,NULL,'2015-05-27 15:19:34',20,'DEVATOL PJT',NULL,145.2,1452,2,0,53),(208,36,NULL,48,6,NULL,'2015-05-27 15:19:34',20,'INSECTICIDE SGF',NULL,61.4,368.4,3,0,53),(209,8,NULL,48,5,NULL,'2015-05-27 15:19:34',20,'REPULSIF R.P PRO',NULL,49.3,246.5,2,0,53),(210,60,NULL,48,2,NULL,'2015-05-27 15:19:34',20,'PULVERISATEUR 12 LITRES',NULL,0,0,3,0,53),(211,NULL,12,48,NULL,1,'2015-05-27 15:19:34',NULL,NULL,'BATTERIE CASSEROLES',0,0,NULL,0,53),(212,NULL,3,48,NULL,1,'2015-05-27 15:19:34',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,53),(213,1,NULL,66,5,NULL,'2015-05-28 11:16:52',20,'DESHERBANT TOTAL PJT',NULL,63.3,316.5,2,0,54),(214,3,NULL,66,5,NULL,'2015-05-28 11:16:52',20,'DETERGENT SOLLO E50',NULL,25.1,125.5,2,0,54),(215,41,NULL,66,5,NULL,'2015-05-28 11:16:52',20,'SAVON NACREE',NULL,22.34,111.7,2,0,54),(216,61,NULL,66,40,NULL,'2015-05-28 11:16:52',20,'PASTILLES URINOIRS',NULL,2.15,86,3,0,54),(217,10,NULL,66,4,NULL,'2015-05-28 11:16:52',20,'RATICIDE PRO BLOC',NULL,59.75,239,1,0,54),(218,NULL,13,66,NULL,1,'2015-05-28 11:16:52',NULL,NULL,'MALETTE BOUCHER',0,0,NULL,0,54),(219,1,NULL,67,5,NULL,'2015-05-28 11:27:42',20,'DESHERBANT TOTAL PJT',NULL,63.3,316.5,2,0,55),(220,3,NULL,67,10,NULL,'2015-05-28 11:27:42',20,'DETERGENT SOLLO E50',NULL,25.1,251,2,0,55),(221,40,NULL,67,30,NULL,'2015-05-28 11:27:42',20,'ANTIMOUSSE ECO',NULL,29.9,897,2,0,55),(222,44,NULL,67,25,NULL,'2015-05-28 11:27:42',20,'TRAITEMENT MVS',NULL,9.9,247.5,1,0,55),(223,NULL,13,67,NULL,1,'2015-05-28 11:27:42',NULL,NULL,'MALETTE BOUCHER',0,0,NULL,0,55),(224,NULL,10,67,NULL,1,'2015-05-28 11:27:42',NULL,NULL,'MALETTE OUTILS',0,0,NULL,0,55),(225,3,NULL,68,5,NULL,'2015-05-29 11:26:32',20,'DETERGENT SOLLO E50',NULL,25.1,125.5,2,0,56),(226,33,NULL,68,4.5,NULL,'2015-05-29 11:26:32',20,'SAVON MICROBILLES',NULL,39.7,178.65,2,0,56),(227,48,NULL,68,1,NULL,'2015-05-29 11:26:32',20,'GEL HYDROALCOOLIQUE',NULL,67.6,67.6,2,0,56),(228,NULL,7,68,NULL,1,'2015-05-29 11:26:32',NULL,NULL,'COUTEAUX',0,0,NULL,0,56),(229,1,NULL,81,30,NULL,'2015-06-01 10:54:59',20,'DESHERBANT TOTAL PJT',NULL,63.3,1899,2,0,57),(230,31,NULL,81,20,NULL,'2015-06-01 10:54:59',20,'DETERGENT ECOLABEL',NULL,37.2,744,2,0,57),(231,60,NULL,81,1,NULL,'2015-06-01 10:54:59',20,'PULVERISATEUR 12 LITRES',NULL,0,0,3,0,57),(232,NULL,3,81,NULL,1,'2015-06-01 10:54:59',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,57),(233,NULL,3,81,NULL,1,'2015-06-01 10:54:59',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,57),(234,NULL,7,81,NULL,1,'2015-06-01 10:54:59',NULL,NULL,'COUTEAUX',0,0,NULL,0,57),(235,NULL,7,81,NULL,1,'2015-06-01 10:54:59',NULL,NULL,'COUTEAUX',0,0,NULL,0,57),(236,NULL,7,81,NULL,1,'2015-06-01 10:54:59',NULL,NULL,'COUTEAUX',0,0,NULL,0,57),(237,38,NULL,55,5,NULL,'2015-06-01 11:01:39',20,'REPULSIF R.CC',NULL,59.3,296.5,2,0,58),(238,NULL,7,55,NULL,1,'2015-06-01 11:01:39',NULL,NULL,'COUTEAUX',0,0,NULL,0,58),(239,40,NULL,47,90,NULL,'2015-06-01 11:05:31',20,'ANTIMOUSSE ECO',NULL,29.9,2287.35,2,15,59),(240,NULL,7,47,NULL,1,'2015-06-01 11:05:31',NULL,NULL,'COUTEAUX',0,0,NULL,15,59),(241,NULL,7,47,NULL,1,'2015-06-01 11:05:31',NULL,NULL,'COUTEAUX',0,0,NULL,15,59),(242,NULL,17,47,NULL,1,'2015-06-01 11:05:31',NULL,NULL,'CHAMPAGNE',0,0,NULL,15,59),(243,NULL,19,47,NULL,1,'2015-06-01 11:06:22',NULL,NULL,'TAILLE HAIE',0,0,NULL,15,59),(244,49,NULL,63,10,NULL,'2015-06-01 11:11:48',20,'INSECTICIDE BARRAGE',NULL,53.8,538,2,0,60),(245,1,NULL,63,10,NULL,'2015-06-01 11:11:48',20,'DESHERBANT TOTAL PJT',NULL,63.3,633,2,0,60),(250,NULL,3,63,NULL,1,'2015-06-01 11:11:48',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,60),(251,NULL,7,63,NULL,1,'2015-06-01 11:11:48',NULL,NULL,'COUTEAUX',0,0,NULL,0,60),(252,44,NULL,46,50,NULL,'2015-06-01 11:42:03',20,'TRAITEMENT MVS',NULL,9.9,495,1,0,61),(253,NULL,2,46,NULL,1,'2015-06-01 11:42:03',NULL,NULL,'TELEPHONE PORTABLE',0,0,NULL,0,61),(254,1,NULL,45,5,NULL,'2015-06-01 11:46:24',20,'DESHERBANT TOTAL PJT',NULL,63.3,316.5,2,0,62),(255,41,NULL,45,5,NULL,'2015-06-01 11:46:24',20,'SAVON NACREE',NULL,22.34,111.7,2,0,62),(256,42,NULL,45,1,NULL,'2015-06-01 11:46:24',20,'DISTRIBUTEUR DE SAVON',NULL,0,0,3,0,62),(257,NULL,7,45,NULL,1,'2015-06-01 11:46:24',NULL,NULL,'COUTEAUX',0,0,NULL,0,62),(258,36,NULL,57,6,NULL,'2015-06-01 13:53:50',20,'INSECTICIDE SGF',NULL,61.4,368.4,3,0,63),(259,NULL,7,57,NULL,1,'2015-06-01 13:53:50',NULL,NULL,'COUTEAUX',0,0,NULL,0,63),(260,33,NULL,NULL,18,NULL,'2015-06-01 16:39:45',20,'SAVON MICROBILLES',NULL,39.7,714.6,2,0,64),(261,62,NULL,NULL,30,NULL,'2015-06-01 16:39:45',20,'DILUANT NETTOYANT',NULL,31.2,936,2,0,64),(268,NULL,20,NULL,NULL,1,'2015-06-01 16:43:55',NULL,NULL,'CLIM',0,0,NULL,0,64),(269,NULL,20,NULL,NULL,1,'2015-06-01 16:43:55',NULL,NULL,'CLIM',0,0,NULL,0,64),(270,44,NULL,65,50,NULL,'2015-06-01 16:57:09',20,'TRAITEMENT MVS',NULL,9.9,495,1,0,65),(271,NULL,3,65,NULL,1,'2015-06-01 16:57:09',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,65),(272,14,NULL,NULL,10,NULL,'2015-06-01 17:07:26',20,'FERTIL LIQUID',NULL,40.7,407,2,0,66),(273,NULL,10,NULL,NULL,1,'2015-06-01 17:07:26',NULL,NULL,'MALETTE OUTILS',0,0,NULL,0,66),(274,5,NULL,NULL,9,NULL,'2015-06-01 17:16:11',20,'TRACING BLANC',NULL,69.2,622.8,3,0,66),(275,3,NULL,35,20,NULL,'2015-06-02 14:47:58',20,'DETERGENT SOLLO E50',NULL,25.1,502,2,0,NULL),(276,64,NULL,69,20,NULL,'2015-06-03 09:57:37',20,'RESINET',NULL,38.7,774,2,0,67),(277,1,NULL,69,20,NULL,'2015-06-03 09:57:37',20,'DESHERBANT TOTAL PJT',NULL,63.3,1266,2,0,67),(278,NULL,1,69,NULL,1,'2015-06-03 09:57:37',NULL,NULL,'ORDINATEUR',0,0,NULL,0,67),(279,NULL,7,69,NULL,1,'2015-06-03 09:57:37',NULL,NULL,'COUTEAUX',0,0,NULL,0,67),(280,1,NULL,NULL,40,NULL,'2015-06-03 10:17:03',20,'DESHERBANT TOTAL PJT',NULL,63.3,2532,2,0,68),(281,36,NULL,NULL,24,NULL,'2015-06-03 10:17:03',20,'INSECTICIDE SGF',NULL,61.4,1473.6,3,0,68),(282,49,NULL,NULL,20,NULL,'2015-06-03 10:17:03',20,'INSECTICIDE BARRAGE',NULL,53.8,1076,2,0,68),(283,66,NULL,NULL,12,NULL,'2015-06-03 10:17:03',20,'INSECTICIDE SIR',NULL,68.25,819,3,0,68),(284,5,NULL,NULL,6,NULL,'2015-06-03 10:17:03',20,'TRACING BLANC',NULL,69.2,415.2,3,0,68),(285,45,NULL,NULL,1,NULL,'2015-06-03 10:17:03',20,'CANNE DE TRACAGE',NULL,0,0,3,0,68),(286,NULL,18,NULL,NULL,1,'2015-06-03 10:17:03',NULL,NULL,'TV',0,0,NULL,0,68),(287,NULL,18,NULL,NULL,1,'2015-06-03 10:17:03',NULL,NULL,'TV',0,0,NULL,0,68),(288,NULL,1,NULL,NULL,1,'2015-06-03 10:17:03',NULL,NULL,'ORDINATEUR',0,0,NULL,0,68),(289,NULL,21,NULL,NULL,1,'2015-06-03 10:18:14',NULL,NULL,'DAGUE',0,0,NULL,0,68),(290,NULL,21,NULL,NULL,1,'2015-06-03 10:18:14',NULL,NULL,'DAGUE',0,0,NULL,0,68),(291,1,NULL,71,10,NULL,'2015-06-03 10:35:13',20,'DESHERBANT TOTAL PJT',NULL,63.3,633,2,0,69),(292,49,NULL,71,10,NULL,'2015-06-03 10:35:13',20,'INSECTICIDE BARRAGE',NULL,53.8,538,2,0,69),(293,67,NULL,71,10,NULL,'2015-06-03 10:38:17',20,'DETERGENT SOLLO C60',NULL,29.2,292,2,0,69),(294,NULL,10,71,NULL,1,'2015-06-03 10:38:17',NULL,NULL,'MALETTE OUTILS',0,0,NULL,0,69),(295,NULL,7,71,NULL,1,'2015-06-03 10:38:17',NULL,NULL,'COUTEAUX',0,0,NULL,0,69),(296,NULL,7,71,NULL,1,'2015-06-03 10:38:17',NULL,NULL,'COUTEAUX',0,0,NULL,0,69),(297,40,NULL,NULL,30,NULL,'2015-06-03 10:43:58',20,'ANTIMOUSSE ECO',NULL,29.9,897,2,0,70),(298,36,NULL,NULL,20,NULL,'2015-06-03 10:43:58',20,'INSECTICIDE SGF',NULL,61.4,1228,3,0,70),(299,NULL,18,NULL,NULL,1,'2015-06-03 10:43:58',NULL,NULL,'TV',0,0,NULL,0,70),(300,10,NULL,70,10,NULL,'2015-06-03 10:48:07',20,'RATICIDE PRO BLOC',NULL,59.75,597.5,1,0,71),(301,NULL,6,70,NULL,1,'2015-06-03 10:48:07',NULL,NULL,'CUMUL',0,0,NULL,0,71),(302,65,NULL,49,25,NULL,'2015-06-03 14:12:58',20,'PEINTURE TYPHON BLANC',NULL,39.6,990,1,0,72),(303,40,NULL,49,30,NULL,'2015-06-03 14:12:58',20,'ANTIMOUSSE ECO',NULL,29.9,897,2,0,72),(304,1,NULL,82,10,NULL,'2015-06-08 11:40:52',20,'DESHERBANT TOTAL PJT',NULL,63.3,633,2,0,73),(305,2,NULL,82,5,NULL,'2015-06-08 11:40:52',20,'OMPS CONTENEUR',NULL,78.6,393,2,0,73),(306,NULL,10,82,NULL,1,'2015-06-08 11:40:52',NULL,NULL,'MALETTE OUTILS',0,0,NULL,0,73),(307,8,NULL,83,5,NULL,'2015-06-08 11:45:22',20,'REPULSIF R.P PRO',NULL,49.3,246.5,2,0,74),(308,63,NULL,83,12,NULL,'2015-06-08 11:45:22',20,'DEGRIP\'LUB',NULL,34.2,410.4,3,0,74),(309,NULL,3,83,NULL,1,'2015-06-08 11:45:22',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,74),(310,44,NULL,80,25,NULL,'2015-06-08 11:53:59',20,'TRAITEMENT MVS',NULL,9.9,247.5,1,0,75),(311,33,NULL,80,9,NULL,'2015-06-08 11:53:59',20,'SAVON MICROBILLES',NULL,39.7,357.3,2,0,75),(312,5,NULL,80,6,NULL,'2015-06-08 11:53:59',20,'TRACING BLANC',NULL,69.2,415.2,3,0,75),(313,49,NULL,80,5,NULL,'2015-06-08 11:53:59',20,'INSECTICIDE BARRAGE',NULL,53.8,269,2,0,75),(314,40,NULL,80,30,NULL,'2015-06-08 11:53:59',20,'ANTIMOUSSE ECO',NULL,29.9,897,2,0,75),(315,36,NULL,80,6,NULL,'2015-06-08 11:53:59',20,'INSECTICIDE SGF',NULL,61.4,368.4,3,0,75),(316,60,NULL,80,1,NULL,'2015-06-08 11:53:59',20,'PULVERISATEUR 12 LITRES',NULL,0,0,3,0,75),(317,45,NULL,80,1,NULL,'2015-06-08 11:53:59',20,'CANNE DE TRACAGE',NULL,0,0,3,0,75),(318,NULL,10,80,NULL,1,'2015-06-08 11:53:59',NULL,NULL,'MALETTE OUTILS',0,0,NULL,0,75),(319,NULL,3,80,NULL,1,'2015-06-08 11:53:59',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,75),(320,NULL,7,80,NULL,1,'2015-06-08 11:53:59',NULL,NULL,'COUTEAUX',0,0,NULL,0,75),(321,2,NULL,80,5,NULL,'2015-06-08 11:54:47',20,'OMPS CONTENEUR',NULL,78.6,393,2,0,75),(322,10,NULL,NULL,10,NULL,'2015-06-08 12:05:23',20,'RATICIDE PRO BLOC',NULL,59.75,597.5,1,0,76),(323,51,NULL,NULL,2,NULL,'2015-06-08 12:05:23',20,'POSTE D\'APPATAGE',NULL,0,0,3,0,76),(324,3,NULL,NULL,10,NULL,'2015-06-08 12:05:23',20,'DETERGENT SOLLO E50',NULL,25.1,251,2,0,76),(325,68,NULL,NULL,2,NULL,'2015-06-08 12:05:23',20,'PULVERISATEUR 1 LITRE',NULL,0,0,3,0,76),(326,11,NULL,NULL,10,NULL,'2015-06-08 12:05:23',20,'DEVATOL PJT',NULL,145.2,1452,2,0,76),(327,NULL,16,NULL,NULL,1,'2015-06-08 12:05:23',NULL,NULL,'ORDI TABLETTE',0,0,NULL,0,76),(328,11,NULL,NULL,10,NULL,'2015-06-08 12:12:19',20,'DEVATOL PJT',NULL,145.2,1452,2,0,77),(329,35,NULL,NULL,12.5,NULL,'2015-06-08 12:12:19',20,'LASURE BOIS CHÊNE CLAIR',NULL,106.1,1326.25,2,0,77),(330,NULL,16,NULL,NULL,1,'2015-06-08 12:12:19',NULL,NULL,'ORDI TABLETTE',0,0,NULL,0,77),(331,NULL,7,NULL,NULL,1,'2015-06-08 12:12:19',NULL,NULL,'COUTEAUX',0,0,NULL,0,77),(332,69,NULL,NULL,1,NULL,'2015-06-08 12:14:34',20,'PULVERISATEUR 16 LITRES',NULL,0,0,3,0,77),(333,1,NULL,NULL,20,NULL,'2015-06-08 12:24:31',20,'DESHERBANT TOTAL PJT',NULL,63.3,1266,2,0,78),(334,39,NULL,NULL,12,NULL,'2015-06-08 12:24:31',20,'GEL WC ECOLOGIQUE',NULL,30.9,370.8,2,0,78),(335,NULL,10,NULL,NULL,1,'2015-06-08 12:24:31',NULL,NULL,'MALETTE OUTILS',0,0,NULL,0,78),(336,NULL,3,NULL,NULL,1,'2015-06-08 12:24:31',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,78),(338,38,NULL,NULL,20,NULL,'2015-06-08 12:33:28',20,'REPULSIF R.CC',NULL,59.3,1186,2,0,79),(339,70,NULL,NULL,1,NULL,'2015-06-08 12:33:28',20,'PULVERISATEUR 5 LITRES',NULL,0,0,3,0,79),(340,NULL,3,NULL,NULL,1,'2015-06-08 12:33:28',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,79),(341,NULL,2,NULL,NULL,1,'2015-06-08 12:33:28',NULL,NULL,'TELEPHONE PORTABLE',0,0,NULL,0,79),(342,66,NULL,NULL,1,NULL,'2015-06-09 18:33:05',20,'INSECTICIDE SIR',NULL,68.25,68.25,3,0,80),(343,38,NULL,NULL,5,NULL,'2015-06-09 18:33:05',20,'REPULSIF R.CC',NULL,59.3,296.5,2,0,80),(344,3,NULL,NULL,5,NULL,'2015-06-09 18:33:05',20,'DETERGENT SOLLO E50',NULL,25.1,125.5,2,0,80),(345,68,NULL,NULL,1,NULL,'2015-06-09 18:33:05',20,'PULVERISATEUR 1 LITRE',NULL,0,0,3,0,80),(346,1,NULL,NULL,10,NULL,'2015-06-09 18:41:22',20,'DESHERBANT TOTAL PJT',NULL,63.3,633,2,0,81),(347,41,NULL,NULL,5,NULL,'2015-06-09 18:41:22',20,'SAVON NACREE',NULL,22.34,111.7,2,0,81),(348,NULL,3,NULL,NULL,1,'2015-06-09 18:41:22',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,81),(349,NULL,7,NULL,NULL,1,'2015-06-09 18:41:22',NULL,NULL,'COUTEAUX',0,0,NULL,0,81),(350,NULL,7,NULL,NULL,1,'2015-06-09 18:42:58',NULL,NULL,'COUTEAUX',0,0,NULL,0,80),(351,3,NULL,NULL,30,NULL,'2015-06-09 19:20:07',20,'DETERGENT SOLLO E50',NULL,25.1,753,2,0,82),(352,20,NULL,NULL,1,NULL,'2015-06-09 19:20:07',20,'KIT PHYTOSANITAIRE',NULL,199.9,199.9,3,0,82),(353,NULL,NULL,NULL,NULL,NULL,'2015-06-09 19:20:07',NULL,NULL,NULL,0,0,NULL,0,82),(354,NULL,10,NULL,NULL,1,'2015-06-09 19:20:07',NULL,NULL,'MALETTE OUTILS',0,0,NULL,0,82),(355,29,NULL,NULL,24,NULL,'2015-06-09 19:30:14',20,'ONE SHOT INSECTICIDE',NULL,84.2,2020.8,3,0,83),(356,NULL,6,NULL,NULL,1,'2015-06-09 19:30:14',NULL,NULL,'CUMUL',0,0,NULL,0,83),(357,49,NULL,NULL,5,NULL,'2015-06-15 14:07:17',20,'INSECTICIDE BARRAGE',NULL,53.8,269,2,0,84),(358,33,NULL,NULL,4.5,NULL,'2015-06-15 14:07:17',20,'SAVON MICROBILLES',NULL,39.7,178.65,2,0,84),(359,NULL,2,NULL,NULL,1,'2015-06-15 14:07:17',NULL,NULL,'TELEPHONE PORTABLE',0,0,NULL,0,84),(360,23,NULL,NULL,6,NULL,'2015-06-15 14:10:59',20,'DESODORISANT MENTHE BACTERICIDE',NULL,44.6,267.6,3,0,85),(361,28,NULL,NULL,1,NULL,'2015-06-15 14:10:59',20,'ONE SHOT BACTERICIDE',NULL,80.15,80.15,3,0,85),(362,NULL,7,NULL,NULL,1,'2015-06-15 14:10:59',NULL,NULL,'COUTEAUX',0,0,NULL,0,85),(363,3,NULL,NULL,5,NULL,'2015-06-15 14:14:59',20,'DETERGENT SOLLO E50',NULL,25.1,125.5,2,0,86),(364,10,NULL,NULL,4,NULL,'2015-06-15 14:14:59',20,'RATICIDE PRO BLOC',NULL,59.75,239,1,0,86),(365,NULL,7,NULL,NULL,1,'2015-06-15 14:14:59',NULL,NULL,'COUTEAUX',0,0,NULL,0,86),(366,71,NULL,NULL,20,NULL,'2015-06-16 14:54:55',20,'DECAPANT SCALP SD',NULL,54.35,1087,2,0,87),(367,NULL,6,NULL,NULL,1,'2015-06-16 14:54:55',NULL,NULL,'CUMUL',0,0,NULL,0,87),(368,1,NULL,NULL,10,NULL,'2015-06-16 14:57:14',20,'DESHERBANT TOTAL PJT',NULL,63.3,633,2,0,88),(369,NULL,6,NULL,NULL,1,'2015-06-16 14:57:14',NULL,NULL,'CUMUL',0,0,NULL,0,88),(370,40,NULL,NULL,30,NULL,'2015-06-17 10:32:09',20,'ANTIMOUSSE ECO',NULL,29.9,897,2,0,NULL),(371,64,NULL,NULL,20,NULL,'2015-06-17 10:32:09',20,'RESINET',NULL,38.7,774,2,0,NULL),(372,63,NULL,NULL,12,NULL,'2015-06-17 10:32:09',20,'DEGRIP\'LUB',NULL,34.2,410.4,3,0,NULL),(373,8,NULL,NULL,40,NULL,'2015-06-17 10:32:09',20,'REPULSIF R.P PRO',NULL,49.3,1972,2,0,NULL),(374,38,NULL,NULL,20,NULL,'2015-06-17 10:32:09',20,'REPULSIF R.CC',NULL,59.3,1186,2,0,NULL),(375,18,NULL,NULL,45,NULL,'2015-06-17 10:32:09',20,'STADOR BLANC',NULL,27.2,1224,1,0,NULL),(376,40,NULL,NULL,30,NULL,'2015-06-17 10:34:41',20,'ANTIMOUSSE ECO',NULL,29.9,897,2,0,64),(377,64,NULL,NULL,20,NULL,'2015-06-17 10:34:41',20,'RESINET',NULL,38.7,774,2,0,64),(378,63,NULL,NULL,12,NULL,'2015-06-17 10:34:41',20,'DEGRIP\'LUB',NULL,34.2,410.4,3,0,64),(379,8,NULL,NULL,40,NULL,'2015-06-17 10:34:41',20,'REPULSIF R.P PRO',NULL,49.3,1972,2,0,64),(380,38,NULL,NULL,20,NULL,'2015-06-17 10:34:41',20,'REPULSIF R.CC',NULL,59.3,1186,2,0,64),(381,18,NULL,NULL,45,NULL,'2015-06-17 10:34:41',20,'STADOR BLANC',NULL,27.2,1224,1,0,64),(382,3,NULL,76,10,NULL,'2015-06-17 11:28:07',20,'DETERGENT SOLLO E50',NULL,25.1,251,2,0,44),(383,1,NULL,NULL,5,NULL,'2015-06-17 14:43:40',20,'DESHERBANT TOTAL PJT',NULL,63.3,316.5,2,0,89),(384,44,NULL,NULL,25,NULL,'2015-06-17 14:43:40',20,'TRAITEMENT MVS',NULL,9.9,247.5,1,0,89),(385,63,NULL,NULL,1,NULL,'2015-06-17 14:43:40',20,'DEGRIP\'LUB',NULL,34.2,34.2,3,0,89),(386,NULL,22,NULL,NULL,1,'2015-06-17 14:45:50',NULL,NULL,'SECATEUR',0,0,NULL,0,89),(387,NULL,23,NULL,NULL,1,'2015-06-17 14:45:50',NULL,NULL,'CAFETIERE',0,0,NULL,0,89),(388,1,NULL,NULL,20,NULL,'2015-06-17 14:53:56',20,'DESHERBANT TOTAL PJT',NULL,63.3,1266,2,0,90),(389,3,NULL,NULL,10,NULL,'2015-06-17 14:53:56',20,'DETERGENT SOLLO E50',NULL,25.1,251,2,0,90),(390,30,NULL,NULL,10,NULL,'2015-06-17 14:53:56',20,'DETERGENT SOLLO C60',NULL,29.2,292,2,0,90),(391,29,NULL,NULL,1,NULL,'2015-06-17 14:53:56',20,'ONE SHOT INSECTICIDE',NULL,84.2,84.2,3,0,90),(392,33,NULL,NULL,9,NULL,'2015-06-17 14:53:56',20,'SAVON MICROBILLES',NULL,39.7,357.3,2,0,90),(393,36,NULL,NULL,6,NULL,'2015-06-17 14:53:56',20,'INSECTICIDE SGF',NULL,61.4,368.4,3,0,90),(394,NULL,16,NULL,NULL,1,'2015-06-17 14:53:56',NULL,NULL,'ORDI TABLETTE',0,0,NULL,0,90),(395,NULL,2,NULL,NULL,1,'2015-06-17 14:53:56',NULL,NULL,'TELEPHONE PORTABLE',0,0,NULL,0,90),(396,1,NULL,NULL,20,NULL,'2015-06-17 15:02:34',20,'DESHERBANT TOTAL PJT',NULL,63.3,1266,2,0,91),(397,40,NULL,NULL,30,NULL,'2015-06-17 15:02:34',20,'ANTIMOUSSE ECO',NULL,29.9,897,2,0,91),(398,60,NULL,NULL,2,NULL,'2015-06-17 15:02:34',20,'PULVERISATEUR 12 LITRES',NULL,0,0,3,0,91),(399,NULL,7,NULL,NULL,1,'2015-06-17 15:02:34',NULL,NULL,'COUTEAUX',0,0,NULL,0,91),(400,NULL,24,NULL,NULL,1,'2015-06-17 15:04:09',NULL,NULL,'STYLO',0,0,NULL,0,91),(401,30,NULL,NULL,5,NULL,'2015-06-17 15:12:23',20,'DETERGENT SOLLO C60',NULL,29.2,146,2,0,92),(402,33,NULL,NULL,4.5,NULL,'2015-06-17 15:12:23',20,'SAVON MICROBILLES',NULL,39.7,178.65,2,0,92),(403,48,NULL,NULL,1,NULL,'2015-06-17 15:12:23',20,'GEL HYDROALCOOLIQUE',NULL,67.6,67.6,2,0,92),(404,64,NULL,NULL,5,NULL,'2015-06-17 15:12:23',20,'RESINET',NULL,38.7,193.5,2,0,92),(405,NULL,3,NULL,NULL,1,'2015-06-17 15:12:23',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,92),(406,30,NULL,NULL,10,NULL,'2015-06-17 15:22:12',20,'DETERGENT SOLLO C60',NULL,29.2,292,2,0,93),(407,66,NULL,NULL,2,NULL,'2015-06-17 15:22:12',20,'INSECTICIDE SIR',NULL,68.25,136.5,3,0,93),(408,NULL,3,NULL,NULL,1,'2015-06-17 15:22:12',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,93),(409,1,NULL,NULL,5,NULL,'2015-06-17 16:06:56',20,'DESHERBANT TOTAL PJT',NULL,63.3,316.5,2,0,94),(410,66,NULL,NULL,1,NULL,'2015-06-17 16:06:56',20,'INSECTICIDE SIR',NULL,68.25,68.25,3,0,94),(411,NULL,7,NULL,NULL,1,'2015-06-17 16:06:56',NULL,NULL,'COUTEAUX',0,0,NULL,0,94),(412,47,NULL,NULL,25,NULL,'2015-06-17 16:16:32',20,'DEVERGLACANT P',NULL,10.7,267.5,1,0,95),(413,3,NULL,NULL,5,NULL,'2015-06-17 16:16:32',20,'DETERGENT SOLLO E50',NULL,25.1,125.5,2,0,95),(414,NULL,7,NULL,NULL,1,'2015-06-17 16:16:32',NULL,NULL,'COUTEAUX',0,0,NULL,0,95),(415,3,NULL,NULL,5,NULL,'2015-06-18 10:22:18',20,'DETERGENT SOLLO E50',NULL,25.1,125.5,2,0,96),(416,NULL,6,NULL,NULL,1,'2015-06-18 10:22:18',NULL,NULL,'CUMUL',0,0,NULL,0,96),(417,3,NULL,NULL,20,NULL,'2015-06-18 10:37:46',20,'DETERGENT SOLLO E50',NULL,25.1,502,2,0,97),(418,41,NULL,NULL,10,NULL,'2015-06-18 10:37:46',20,'SAVON NACREE',NULL,22.34,223.4,2,0,97),(419,NULL,3,NULL,NULL,1,'2015-06-18 10:37:46',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,97),(420,1,NULL,NULL,20,NULL,'2015-06-18 10:46:18',20,'DESHERBANT TOTAL PJT',NULL,63.3,1266,2,0,98),(421,3,NULL,NULL,20,NULL,'2015-06-18 10:46:18',20,'DETERGENT SOLLO E50',NULL,25.1,502,2,0,98),(422,8,NULL,NULL,5,NULL,'2015-06-18 10:46:18',20,'REPULSIF R.P PRO',NULL,49.3,246.5,2,0,98),(423,68,NULL,NULL,20,NULL,'2015-06-18 10:46:18',20,'PULVERISATEUR 1 LITRE',NULL,0,0,3,0,98),(424,NULL,16,NULL,NULL,1,'2015-06-18 10:46:18',NULL,NULL,'ORDI TABLETTE',0,0,NULL,0,98),(425,31,NULL,84,20,NULL,'2015-06-18 11:00:14',20,'DETERGENT ECOLABEL',NULL,37.2,744,2,0,99),(426,3,NULL,NULL,10,NULL,'2015-06-18 11:10:36',20,'DETERGENT SOLLO E50',NULL,25.1,251,2,0,100),(427,NULL,7,NULL,NULL,1,'2015-06-18 11:10:36',NULL,NULL,'COUTEAUX',0,0,NULL,0,100),(428,11,NULL,NULL,10,NULL,'2015-06-18 11:19:49',20,'DEVATOL PJT',NULL,145.2,1452,2,0,101),(429,48,NULL,NULL,3,NULL,'2015-06-18 11:19:49',20,'GEL HYDROALCOOLIQUE',NULL,67.6,202.8,2,0,101),(430,3,NULL,NULL,10,NULL,'2015-06-18 11:19:49',20,'DETERGENT SOLLO E50',NULL,25.1,251,2,0,101),(431,40,NULL,NULL,30,NULL,'2015-06-18 11:19:49',20,'ANTIMOUSSE ECO',NULL,29.9,897,2,0,101),(432,36,NULL,NULL,12,NULL,'2015-06-18 11:19:49',20,'INSECTICIDE SGF',NULL,61.4,736.8,3,0,101),(433,NULL,16,NULL,NULL,1,'2015-06-18 11:19:49',NULL,NULL,'ORDI TABLETTE',0,0,NULL,0,101),(434,NULL,2,NULL,NULL,1,'2015-06-18 11:19:49',NULL,NULL,'TELEPHONE PORTABLE',0,0,NULL,0,101),(435,NULL,3,NULL,NULL,1,'2015-06-18 11:19:49',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,101),(436,36,NULL,NULL,12,NULL,'2015-06-18 11:28:06',20,'INSECTICIDE SGF',NULL,61.4,736.8,3,0,102),(437,NULL,22,NULL,NULL,1,'2015-06-18 11:28:39',NULL,NULL,'SECATEUR',0,0,NULL,0,102),(438,NULL,22,NULL,NULL,1,'2015-06-18 11:28:39',NULL,NULL,'SECATEUR',0,0,NULL,0,102),(439,NULL,9,NULL,NULL,1,'2015-06-18 11:28:39',NULL,NULL,'VIN',0,0,NULL,0,102),(440,1,NULL,NULL,20,NULL,'2015-06-18 11:36:07',20,'DESHERBANT TOTAL PJT',NULL,63.3,1266,2,0,103),(441,NULL,3,NULL,NULL,1,'2015-06-18 11:36:07',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,103),(442,NULL,7,NULL,NULL,1,'2015-06-18 11:36:07',NULL,NULL,'COUTEAUX',0,0,NULL,0,103),(443,NULL,9,NULL,NULL,1,'2015-06-18 11:36:07',NULL,NULL,'VIN',0,0,NULL,0,103),(444,NULL,9,NULL,NULL,1,'2015-06-18 11:36:07',NULL,NULL,'VIN',0,0,NULL,0,103),(445,1,NULL,NULL,5,NULL,'2015-06-18 11:57:07',20,'DESHERBANT TOTAL PJT',NULL,63.3,316.5,2,0,104),(446,3,NULL,NULL,5,NULL,'2015-06-18 11:57:07',20,'DETERGENT SOLLO E50',NULL,25.1,125.5,2,0,104),(447,NULL,3,NULL,NULL,1,'2015-06-18 11:57:07',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,104);

--
-- Table structure for table `Configuration`
--

CREATE TABLE `Configuration` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `tel` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fax` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `siret` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `adresse` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `code_postal` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ville` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `contact` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `meetings_per_day` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Configuration`
--

INSERT INTO `Configuration` VALUES (1,'ED Collectivités','0973604763','0978604763','79776934600017','EURL au capital de 8000€','23 Avenue de Mayenne','82000','MONTAUBAN','edcollectivites@gmail.com',10);

--
-- Table structure for table `Lot`
--

CREATE TABLE `Lot` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `designation` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Lot`
--

INSERT INTO `Lot` VALUES (1,'18','ORDINATEUR'),(2,'22','TELEPHONE PORTABLE'),(3,'32','TABLETTE TACTILE'),(4,'2','APPAREIL PHOTO'),(5,'44','PULVERISATEUR'),(6,'0','CUMUL'),(7,'13','COUTEAUX'),(9,'6','VIN'),(10,'12','MALETTE OUTILS'),(11,'17','MINI ORDINATEUR'),(12,'10','BATTERIE CASSEROLES'),(13,'11','MALETTE BOUCHER'),(14,'9','PLANCHA'),(15,'46','DEBROUSSAILLEUSE'),(16,'16','ORDI TABLETTE'),(17,'20','CHAMPAGNE'),(18,'25','TV'),(19,'45','TAILLE HAIE'),(20,'43','CLIM'),(21,'15','DAGUE'),(22,'42','SECATEUR'),(23,'8','CAFETIERE'),(24,'37','STYLO');

--
-- Table structure for table `Meeting`
--

CREATE TABLE `Meeting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `date_debut` datetime NOT NULL,
  `date_fin` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_3AA8D8A519EB6921` (`client_id`),
  KEY `IDX_3AA8D8A5A76ED395` (`user_id`),
  CONSTRAINT `FK_3AA8D8A5A76ED395` FOREIGN KEY (`user_id`) REFERENCES `fos_user` (`id`),
  CONSTRAINT `FK_3AA8D8A519EB6921` FOREIGN KEY (`client_id`) REFERENCES `Client` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Meeting`
--


--
-- Table structure for table `NumeroTelephone`
--

CREATE TABLE `NumeroTelephone` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `designation` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `numero` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_C0ECCE2D19EB6921` (`client_id`),
  CONSTRAINT `FK_C0ECCE2D19EB6921` FOREIGN KEY (`client_id`) REFERENCES `Client` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `NumeroTelephone`
--



