--
-- 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 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- 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=54 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',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-1','LASURE BOIS CHÊNE CLAIR',106.1,2,'SELVES',20),(36,'401','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','POSTE D\'APPATAGE',0,3,'AEDES',20),(52,'217','TARAX - TRAITEMENT FOSSE',14.71,3,'LECLERC',20),(53,'401-SP','RATICIDE BLOC PRO',59.9,1,'QUATRIS',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=35 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',1,'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',1,'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',1,'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',1,'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','HÔPITAL DE CAVAILLON','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',1,'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',1,'2015-06-25 00:00:00','39464','00907',0,0,2,9.5,'MAUBEC','84660',1900,'MASSIP FREDERIC','Mairie 04 90 76 92 09',NULL,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',1,'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',1,'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',1,'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',1,'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',1,'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-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','39470','00660',0,0,1,20,'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',1,'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',1,'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',1,'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',1,'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);

--
-- 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=41 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','2B','2B246','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,'2014-09-12 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','2B','2B247','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','-','MAIRIE DE ROGLIANO','MB 38','29+28',458,'2014-12-08 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','119, avenue de Georges Clémenceau','HÔPITAL DE CAVAILLON','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');

--
-- 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=126 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,NULL,5,NULL,'2015-05-04 14:51:10',20,'DESHERBANT TOTAL PJT',NULL,63.3,316.5,2,0,8),(24,NULL,7,NULL,NULL,1,'2015-05-04 14:51:10',NULL,NULL,'COUTEAUX',0,0,NULL,0,8),(25,1,NULL,NULL,5,NULL,'2015-05-04 15:00:10',20,'DESHERBANT TOTAL PJT',NULL,63.3,316.5,2,0,9),(26,NULL,7,NULL,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,493,2,0,13),(39,40,NULL,19,30,NULL,'2015-05-04 16:45:51',20,'ANTIMOUSSE ECO',NULL,29.9,897,2,0,13),(40,NULL,9,19,NULL,1,'2015-05-04 16:46:58',NULL,NULL,'VIN',0,0,NULL,0,13),(41,NULL,10,19,NULL,1,'2015-05-04 16:46:58',NULL,NULL,'MALETTE OUTILS',0,0,NULL,0,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,0,13),(48,NULL,9,19,NULL,1,'2015-05-05 08:41:34',NULL,NULL,'VIN',0,0,NULL,0,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,NULL,5,NULL,'2015-05-06 12:25:26',20,'DETERGENT ECOLABEL',NULL,37.2,186,2,0,18),(67,46,NULL,NULL,20,NULL,'2015-05-06 12:25:26',20,'SUPER ABSORBANT',NULL,11.35,227,1,0,18),(68,NULL,2,NULL,NULL,1,'2015-05-06 12:25:26',NULL,NULL,'TELEPHONE PORTABLE',0,0,NULL,0,18),(69,8,NULL,NULL,5,NULL,'2015-05-06 12:34:15',20,'REPULSIF R.P PRO',NULL,49.3,246.5,2,0,19),(70,44,NULL,NULL,50,NULL,'2015-05-06 12:34:15',20,'TRAITEMENT MVS',NULL,9.9,495,1,0,19),(71,13,NULL,NULL,20,NULL,'2015-05-06 12:34:15',20,'FLORANID GAZON',NULL,35.97,719.4,1,0,19),(72,NULL,10,NULL,NULL,1,'2015-05-06 12:34:15',NULL,NULL,'MALETTE OUTILS',0,0,NULL,0,19),(73,NULL,7,NULL,NULL,1,'2015-05-06 12:34:15',NULL,NULL,'COUTEAUX',0,0,NULL,0,19),(74,44,NULL,NULL,25,NULL,'2015-05-06 12:40:43',20,'TRAITEMENT MVS',NULL,9.9,247.5,1,0,20),(75,3,NULL,NULL,5,NULL,'2015-05-06 12:40:43',20,'DETERGENT SOLLO E50',NULL,25.1,125.5,2,0,20),(76,NULL,7,NULL,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,NULL,5,NULL,'2015-05-11 11:49:37',20,'DETERGENT SOLLO E50',NULL,25.1,125.5,2,0,22),(80,33,NULL,NULL,4.5,NULL,'2015-05-11 11:49:37',20,'SAVON MICROBILLES',NULL,39.7,178.65,2,0,22),(81,NULL,7,NULL,NULL,1,'2015-05-11 11:49:37',NULL,NULL,'COUTEAUX',0,0,NULL,0,22),(82,33,NULL,NULL,9,NULL,'2015-05-11 12:00:31',20,'SAVON MICROBILLES',NULL,39.7,357.3,2,0,23),(83,48,NULL,NULL,2,NULL,'2015-05-11 12:00:31',20,'GEL HYDROALCOOLIQUE',NULL,67.6,135.2,2,0,23),(84,NULL,2,NULL,NULL,1,'2015-05-11 12:00:31',NULL,NULL,'TELEPHONE PORTABLE',0,0,NULL,0,23),(85,1,NULL,NULL,5,NULL,'2015-05-11 12:16:47',20,'DESHERBANT TOTAL PJT',NULL,63.3,316.5,2,0,24),(86,NULL,7,NULL,NULL,1,'2015-05-11 12:16:47',NULL,NULL,'COUTEAUX',0,0,NULL,0,24),(87,NULL,9,NULL,NULL,1,'2015-05-11 12:16:47',NULL,NULL,'VIN',0,0,NULL,0,24),(88,46,NULL,NULL,20,NULL,'2015-05-11 12:22:50',20,'SUPER ABSORBANT',NULL,11.35,227,1,0,25),(89,NULL,9,NULL,NULL,1,'2015-05-11 12:22:50',NULL,NULL,'VIN',0,0,NULL,0,25),(90,NULL,9,NULL,NULL,1,'2015-05-11 12:22:50',NULL,NULL,'VIN',0,0,NULL,0,25),(91,3,NULL,NULL,10,NULL,'2015-05-11 13:54:43',20,'DETERGENT SOLLO E50',NULL,25.1,251,2,0,26),(92,NULL,7,NULL,NULL,1,'2015-05-11 13:54:43',NULL,NULL,'COUTEAUX',0,0,NULL,0,26),(93,10,NULL,NULL,20,NULL,'2015-05-11 13:59:35',20,'RATICIDE PRO BLOC',NULL,59.75,1195,1,0,27),(94,3,NULL,NULL,20,NULL,'2015-05-11 13:59:35',20,'DETERGENT SOLLO E50',NULL,25.1,502,2,0,27),(95,NULL,2,NULL,NULL,1,'2015-05-11 13:59:35',NULL,NULL,'TELEPHONE PORTABLE',0,0,NULL,0,27),(96,NULL,3,NULL,NULL,1,'2015-05-11 13:59:35',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,27),(97,NULL,7,NULL,NULL,1,'2015-05-11 13:59:35',NULL,NULL,'COUTEAUX',0,0,NULL,0,27),(98,NULL,9,NULL,NULL,1,'2015-05-11 13:59:35',NULL,NULL,'VIN',0,0,NULL,0,27),(99,3,NULL,NULL,20,NULL,'2015-05-11 14:03:35',20,'DETERGENT SOLLO E50',NULL,25.1,502,2,0,28),(100,NULL,3,NULL,NULL,1,'2015-05-11 14:03:35',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,28),(101,49,NULL,NULL,20,NULL,'2015-05-11 14:13:05',20,'INSECTICIDE BARRAGE',NULL,53.8,1076,2,0,29),(102,28,NULL,NULL,10,NULL,'2015-05-11 14:13:05',20,'ONE SHOT BACTERICIDE',NULL,80.15,801.5,3,0,29),(103,50,NULL,NULL,6,NULL,'2015-05-11 14:13:05',20,'DEBOUCHEUR PUISSANT',NULL,46.2,277.2,2,0,29),(104,10,NULL,NULL,2,NULL,'2015-05-11 14:13:05',20,'RATICIDE PRO BLOC',NULL,59.75,119.5,1,0,29),(105,51,NULL,NULL,2,NULL,'2015-05-11 14:13:05',20,'POSTE D\'APPATAGE',NULL,0,0,3,0,29),(106,NULL,3,NULL,NULL,1,'2015-05-11 14:13:05',NULL,NULL,'TABLETTE TACTILE',0,0,NULL,0,29),(107,NULL,2,NULL,NULL,1,'2015-05-11 14:13:05',NULL,NULL,'TELEPHONE PORTABLE',0,0,NULL,0,29),(108,NULL,12,NULL,NULL,1,'2015-05-11 14:13:50',NULL,NULL,'BATTERIE CASSEROLES',0,0,NULL,0,29),(109,1,NULL,NULL,5,NULL,'2015-05-11 14:24:26',20,'DESHERBANT TOTAL PJT',NULL,63.3,316.5,2,0,30),(110,32,NULL,NULL,5,NULL,'2015-05-11 14:24:26',20,'BRINOX',NULL,41.2,206,2,0,30),(111,NULL,13,NULL,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,NULL,20,NULL,'2015-05-11 14:45:56',20,'DETERGENT SOLLO E50',NULL,25.1,502,2,0,32),(118,NULL,15,NULL,NULL,1,'2015-05-11 14:45:56',NULL,NULL,'DEBROUSSAILLEUSE',0,0,NULL,0,32),(119,53,NULL,NULL,10,NULL,'2015-05-11 14:59:17',20,'RATICIDE BLOC PRO',NULL,59.9,599,1,0,33),(120,51,NULL,NULL,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);

--
-- 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=16 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');

--
-- 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=10 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`
--



