sales.sql

-- MySQL dump 10.13  Distrib 8.0.19, for macos10.15 (x86_64)
--
-- Host: localhost    Database: sales
-- ------------------------------------------------------
-- Server version	8.0.19

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

-- CREATE DATABASE IF NOT EXISTS sales;
USE sql6440943;


--
-- Table structure for table `supplier`
--

DROP TABLE IF EXISTS `supplier`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `supplier` (
  `num` int NOT NULL AUTO_INCREMENT,
  `society` varchar(60) DEFAULT NULL,
  `contact` varchar(30) DEFAULT NULL,
  `addres` varchar(40) DEFAULT NULL,
  `zipcode` varchar(5) DEFAULT NULL,
  `city` varchar(30) DEFAULT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `fax` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`num`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `supplier`
--

LOCK TABLES `supplier` WRITE;
/*!40000 ALTER TABLE `supplier` DISABLE KEYS */;
INSERT INTO `supplier` VALUES (1,'Bureau S.A.','Maurice Porteboeuf','121, Rue Montespan','74202','THONON','04 55 67 91 12','04 55 67 92 21'),(2,'Fournitures modernes','Francois Courtinaud','19, Rue Saint-Andre-des-Arts','17310','ARCENS','05 56 30 03 65','05 56 30 00 01'),(3,'Bergenod S.A.','Pascale Morizot','13, rue du 8 Mai 1945','16540','FONTAN','03 42 24 46 30','03 42 24 30 28'),(4,'Stationays du centre','Christine Chevillard','2, Rue Tronchet','27000','EVREUX','02 35 56 98 65','02 35 56 12 43'),(5,'Alpha plus','Christophe Hondel','17, Bd Picpus','71300','MONTCEAU LES MINES','03 11 34 58 45','03 11 45 79 33'),(6,'Ets Martin','Simone Bourguignon','12, rue Antoine Fee','56300','PONTIVY','02 47 43 89 01','02 47 43 89 27'),(7,'Editions entreprise','Aline Verney','7, rue Cartier Bresson','77200','TORCY','01 56 67 91 12','01 56 67 92 21'),(8,'Audio Max','Eric Fanarassou','145, av Aristide Briand','31037','TOULOUSE','05 68 66 67 65','05 68 55 68 76'),(9,'Info Media','Laurent Berthelod','9, rue Arthur Enaud','38000','GRENOBLE','04 45 56 43 43','04 45 56 67 54'),(10,'Les leathers modernes','Roger Grandbernard','23, rue de la gare','38600','FONTAINE','04 68 64 69 63','04 68 64 65 11');
/*!40000 ALTER TABLE `supplier` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `article`
--

DROP TABLE IF EXISTS `article`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `article` (
  `reference` varchar(6) NOT NULL DEFAULT '',
  `category` varchar(15) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `supplier` int DEFAULT NULL,
  `price` double DEFAULT NULL,
  `vat` double DEFAULT NULL,
  `stock` smallint DEFAULT NULL,
  `critical_stock` smallint DEFAULT NULL,
  PRIMARY KEY (`reference`),
  KEY `supplier_index` (`supplier`),
  CONSTRAINT `0_43` FOREIGN KEY (`supplier`) REFERENCES `supplier` (`num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `article`
--

LOCK TABLES `article` WRITE;
/*!40000 ALTER TABLE `article` DISABLE KEYS */;
INSERT INTO `article` VALUES ('05-303','Furniture','High chair',3,1090,20.6,55,20),('07-390','Furniture','Round table',1,1820,20.6,19,5),('08-151','Furniture','Midimu-hight cabinet',1,3995,20.6,8,5),('09-077','Furniture','Juxtaposable low cabinet',1,1430,20.6,16,5),('11-518','Furniture','Miniter desk',1,3190,20.6,18,5),('11-543','Furniture','Half ministr desk',1,2010,20.6,4,5),('11-573','Furniture','Secretary desk',1,2890,20.6,24,5),('11-583','Furniture','Dactylo desk',1,1890,20.6,18,5),('14-040','Furniture','Mobile 3-drawers cabinet',1,2410,20.6,8,10),('15-991','Furniture','Printer stand',9,1370,20.6,41,10),('25-069','Stationay','Archive box green (hundred)',5,344,20.6,912,200),('25-070','Stationay','Archive box red (hundred)',5,344,20.6,202,200),('25-071','Stationay','Archive box blue (hundred)',5,344,20.6,183,200),('25-072','Stationay','Archive box yellow (hundred)',5,344,20.6,479,200),('25-073','Stationay','Archive box black (hundred)',5,344,20.6,801,200),('25-074','Stationay','Archive box grey (hundred)',5,344,20.6,947,200),('25-075','Stationay','Archive box marron (hundred)',5,344,20.6,336,200),('31-068','Digital','USB stick, 2 GB',9,8.8,20.6,317,200),('31-069','Digital','USB stick, 4 GB',9,15.8,20.6,158,100),('31-070','Digital','USB stick, 16 GB',9,6.6,20.6,348,200),('31-071','Digital','USB stick, 32 GB',9,12.4,20.6,237,100),('31-072','Digital','Cardridge DC 300 XL/P',9,232.3,20.6,220,100),('31-073','Digital','Cardridge DC 600 A',9,240.7,20.6,451,100),('31-074','Digital','Cardridge DC 6150',9,285.5,20.6,315,100),('31-075','Digital','Cardridge DC 2000',9,211.7,20.6,364,100),('31-076','Digital','Cardridge DC 6320',9,377.5,20.6,405,100),('31-077','Digital','Cardridge DC 6525',9,429.5,20.6,232,100),('31-080','Audiovisual','Tape audio standard',8,15,20.6,107,30),('31-081','Audiovisual','Micro-Tape audio',8,36.6,20.6,86,20),('31-082','Audiovisual','Audioplayer secretary Sony',8,3290,20.6,5,5),('31-083','Audiovisual','Dictaphone Olympus DT 1010',8,2950,20.6,16,5),('31-084','Audiovisual','Pocket memo',8,896,20.6,21,5),('31-085','Audiovisual','Pocket memo professional',8,1750,20.6,19,5),('31-086','Audiovisual','Electronic diary office',9,730,20.6,15,5),('31-087','Audiovisual','Electronic diary pocket',9,393,20.6,15,5),('31-088','Audiovisual','Dictionnaire electronique multilingue',9,1490,20.6,21,5),('34-821','Furniture','Office chair manager velvet',3,4980,20.6,17,5),('34-824','Furniture','Office chair manager leather',10,5650,20.6,21,5),('35-520','Furniture','Office chair ',3,3820,20.6,12,10),('35-650','Furniture','Office chair visitor',3,1550,20.6,34,10),('38-103','Stationay','clutch pencil multi-usage',2,7.9,20.6,1386,300),('38-104','Stationay','Marker, extra fine point, red',2,7.4,20.6,967,300),('38-105','Stationay','Feutre aiguille, extra fine point, blue',2,7.4,20.6,669,300),('38-106','Stationay','Feutre aiguille, extra fine point, black',2,7.4,20.6,501,300),('38-107','Stationay','Feutre aiguille, extra fine point, green',2,7.4,20.6,1359,300),('38-108','Stationay','Marker with bevelled point, blue',2,12.5,20.6,1264,300),('38-109','Stationay','Marker with bevelled point, black',2,12.5,20.6,344,300),('38-110','Stationay','Marker with bevelled point, red',2,12.5,20.6,1424,300),('38-111','Stationay','Marker with bevelled point, green',2,12.5,20.6,1081,300),('38-112','Stationay','Rubber  (twenty)',5,88,20.6,325,100),('47-125','Stationay','L-pocket paper (fifty)',4,99,20.6,443,300),('47-160','Stationay','Files-folders (hundred)',4,137,20.6,1295,300),('65-041','Library','How to computerize you company',7,240.7,5.5,25,15),('65-042','Library','Interpreting finance report in 20 lessons',7,308.5,5.5,34,15),('65-043','Library','Easy accounting',7,191.1,5.5,19,15),('65-044','Library','Windows made easy',7,106.4,5.5,22,15),('65-045','Library','Practicing MS Access',7,275.2,5.5,33,15),('65-046','Library','Letter models for managers',7,554.1,5.5,65,15),('65-047','Library','Overheads under control',7,417.4,5.5,13,15),('65-048','Library','Speak to your banker',7,154.8,5.5,67,15),('68-184','Communication','Wireless phone Philips',8,1290,20.6,10,5),('68-185','Communication','phone multiple contacts',8,850,20.6,18,5),('68-186','Communication','Wireless intercom 3 posts',6,2120,20.6,23,5),('68-187','Communication','wireless intercom 2 posts',6,1036,20.6,10,5),('68-188','Communication','Recorder with musical waiting',6,1140,20.6,6,5),('68-189','Communication','Recorder with remote connection',6,1390,20.6,15,5),('68-190','Communication','Mini printer',9,1690,20.6,22,5),('68-191','Communication','Fax Sagem \"Fax 7\"',6,6050,20.6,16,5),('68-192','Communication','Cleaning kit for photocopy',6,310,20.6,38,20),('77-101','leatherwork','Leather bag for managers',10,1890,20.6,45,10),('77-102','leatherwork','Skai bag',10,790,20.6,30,20),('77-103','leatherwork','Luxury leather bag',10,3400,20.6,13,5),('77-104','leatherwork','Pilot case leather',10,4560,20.6,16,5),('77-105','leatherwork','Card-holder leather',10,860,20.6,84,20),('77-106','leatherwork','Blotter leather black',10,450,20.6,32,20),('77-107','leatherwork','Blotter leather natural',10,450,20.6,68,20),('82-032','leatherwork','Leather Bag Excellence',10,2350,20.6,9,5),('84-016','Stationay','Hanging files confort  V,  blue (hundred)',4,798,20.6,1363,300),('84-017','Stationay','Hanging files confort  V,  red (hundred)',4,799,20.6,621,300),('84-018','Stationay','Hanging files confort  V,  green (hundred)',4,800,20.6,279,300),('84-019','Stationay','Hanging files confort  V,  jaune (hundred)',4,801,20.6,921,300),('84-020','Stationay','Hanging files confort  V,  grey (hundred)',4,802,20.6,861,300),('84-021','Stationay','Hanging files confort   flat,  blue (hundred)',4,803,20.6,857,300),('84-022','Stationay','Hanging files confort   flat,  red (hundred)',4,804,20.6,260,300),('84-023','Stationay','Hanging files confort   flat,  green (hundred)',4,805,20.6,1159,300),('84-024','Stationay','Hanging files confort   flat,  jaune (hundred)',4,806,20.6,1353,300),('84-025','Stationay','Hanging files confort   flat,  grey (hundred)',4,807,20.6,469,300);
/*!40000 ALTER TABLE `article` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `client`
--

DROP TABLE IF EXISTS `client`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `client` (
  `num_client` int NOT NULL AUTO_INCREMENT,
  `society` varchar(60) DEFAULT NULL,
  `contact` varchar(30) DEFAULT NULL,
  `addres` varchar(40) DEFAULT NULL,
  `zipcode` varchar(5) DEFAULT NULL,
  `city` varchar(30) DEFAULT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `fax` varchar(15) DEFAULT NULL,
  `confirmation` tinyint(1) DEFAULT NULL,
  `payment` varchar(18) DEFAULT NULL,
  `Informations` mediumtext,
  `max_outstanding` double DEFAULT NULL,
  PRIMARY KEY (`num_client`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `client`
--

LOCK TABLES `client` WRITE;
/*!40000 ALTER TABLE `client` DISABLE KEYS */;
INSERT INTO `client` VALUES (1,'Frends of animals','Paul Masson','13, place Napoleon Bonaparte','77300','FONTAINEBLEAU','01 45 56 67 78','01 45 56 67 80',0,'Draft + 30 days','If command over + 30 000 F, transporter assurance',250000),(2,'Editions Black Jack','Jean Holdeux','Batiment Homere 47, rue du Bo','75001','PARIS','01 45 56 34 56','01 45 56 36 76',0,'Draft + 30 days','Delivery with Jet Service',150000),(3,'Kao Tech','Jerome Bosh','19, impasse Carriere-Mainguet','75011','PARIS','01 68 45 47 90','01 68 45 50 32',0,'Draft + 30 days','Client pick-up. Notify when ready',200000),(4,'Assurauto','Louis Lhermite','21, rue Uzes','75002','PARIS','01 34 56 98 65','01 34 56 12 43',0,'Cheque + reception','Notify if delay',100000),(5,'Point blue S.A.','Martine Houdon','18, place Saint-Sulpice','75006','PARIS','01 66 66 67 65','01 66 55 68 76',0,'Cheque + reception','Delevery with post mail',100000),(6,'Cabinet Martin','Paul Pons','157, Bd Saint-Germain','75005','PARIS','01 43 56 43 43','01 43 56 67 54',0,'Draft + 30 days','If command not full, partial bill',200000),(7,'Editions Corbeau','Pierre Hochon','2, rue du Cherche-Midi','75006','PARIS','01 65 45 65 45','01 65 45 65 46',0,'Draft + 90 days','High protection tropica packaging',450000),(8,'Audio Son','Maurice Marcellin','12, impasse du Cure','75018','PARIS','01 47 00 04 05','01 47 00 04 06',0,'Cheque + reception',NULL,50000),(9,'Info Systemes (France) S.A.','Brigitte Leclerc','B.P. 32','92406','PUTEAUX','01 34 34 34 54','01 34 34 34 43',0,'Draft + 90 days',NULL,450000),(10,'Restaurant le Cordon blue','Alain Dercourt','21, rue Maurice Ravel','92110','CLICHY','01 48 00 58 02','01 48 00 57 65',0,'Draft + 60 days',NULL,350000),(11,'Ecole Superieure des Arts Appliques','Michel Fermier','flateau de Moulon','91190','ORSAY','01 43 45 43 45','01 43 45 67 89',0,'Draft + 90 days',NULL,450000),(12,'Techniflex Consultants','Mylene Bergere','12, Rue Montespan','91000','EVRY','01 68 64 69 63','01 68 64 65 11',0,'Cheque + reception',NULL,100000),(13,'G.J.T.C.A','Guillaume Durand','18, Rue de Tournon','75006','PARIS','01 10 34 58 45','01 10 45 79 33',0,'Draft + 60 days',NULL,300000),(14,'Agrotechnique S.A.','Monique Sempaix','25, Rue Tronchet','75008','PARIS','01 46 43 89 01','01 46 43 89 27',0,'Draft + 90 days',NULL,450000),(15,'Konimai Japan','Francois Martichoux','Parc les Algorithmes','91194','GIF-SUR-YVETTE','01 55 67 91 12','01 55 67 92 21',0,'Draft + 90 days',NULL,400000),(16,'Dupont, Dupond & Associes','Alfred Lepont','29, Rue Saint-Andre-des-Arts','75006','PARIS','01 56 30 03 65','01 56 30 00 01',0,'Draft + 60 days',NULL,300000),(17,'Ets Monsaingeon','Leon Delisle','62, CD 13','95330','DOMONT','01 42 24 46 30','01 42 24 30 28',0,'Draft + 60 days',NULL,300000),(18,'Daniel Publicite S.A.','Pierre Gerard','130, rue du 8 Mai 1945','92000','NANTERRE','01 35 56 98 65','01 35 56 12 43',0,'Draft + 90 days',NULL,400000),(19,'SCADEC','Alice Bideau','41, rue Jean Didier','71300','MONTCEAU LES MINES','03 67 66 67 65','03 67 55 68 76',0,'Draft + 30 days',NULL,150000),(20,'ATM','Renee Blutte','87, rue Cartier Bresson','27000','EVREUX','02 44 56 43 43','02 44 56 67 54',0,'Draft + 90 days',NULL,450000),(21,'Ducarroz','Corine Favre','ZA Saint Ernel','56300','PONTIVY','02 66 45 65 45','02 66 45 65 46',0,'Draft + 30 days',NULL,150000),(22,'Jolivet SARL','Martine Salinier','Allee du flateau','77200','TORCY','01 48 00 04 05','01 48 00 04 06',0,'Draft + 30 days',NULL,250000),(23,'Bongard SA','Jeau-Claude Ayrault','45, av Aristide Briand','94110','ARCUEIL','01 35 34 34 54','01 35 34 34 43',0,'Draft + 60 days',NULL,300000),(24,'Fondrie Cafal','Fernand Aupee','171, route Espagne','31037','TOULOUSE','05 49 00 58 02','05 49 00 57 65',0,'Draft + 90 days',NULL,450000),(25,'Sofimet','Jacques Eutrope','3 , rue Lionne','38000','GRENOBLE','04 44 45 43 45','04 44 45 67 89',0,'Draft + 30 days',NULL,150000),(26,'QAMA','Raymond Mimouni','4, rue Baptist Marcet','38600','FONTAINE','04 69 64 69 63','04 69 64 65 11',0,'Draft + 60 days',NULL,350000),(27,'Viland SA','Antonio Lopes','10, rue Dieu','78534','BUC','01 11 34 58 45','01 11 45 79 33',0,'Draft + 60 days',NULL,300000),(28,'GAO','Jacques Flutteaux','48, rue de Montmartre','75002','PARIS','01 47 43 89 01','01 47 43 89 27',0,'Draft + 30 days',NULL,250000),(29,'Serma','Fabienne Lecleve','21, rue Leonard de Vinci','69120','VAULX EN VELIN','04 56 67 91 12','04 56 67 92 21',0,'Draft + 30 days',NULL,150000),(30,'Scamp','Robert Malon','484, rue Richelieu','73490','LA RAVOIRE','04 57 30 03 65','04 57 30 00 01',0,'Draft + 30 days',NULL,250000),(31,'CMEG','Claude Hinard','Le flat bois','14440','DOUVRES','02 43 24 46 30','02 43 24 30 28',0,'Draft + 90 days',NULL,450000),(32,'De Sa Texeira','Antoine Pangrani','rue Saint Gabriel','14480','CREUILLY','02 36 56 98 65','02 36 56 12 43',0,'Draft + 60 days',NULL,300000),(33,'SCGC','Emile Martinez','34, Bd Picpus','75012','PARIS','01 68 66 67 65','01 68 55 68 76',0,'Draft + 90 days',NULL,400000),(34,'Regreen SA','Michelle Guibert','3, rue de Metz','75010','PARIS','01 45 56 43 43','01 45 56 67 54',0,'Draft + 30 days',NULL,250000),(35,'Cebati','Simone Oblet','rue de la gare','85490','BENET','04 67 45 65 45','01 67 45 65 46',0,'Draft + 60 days',NULL,350000),(36,'Rival','Benjamin Capitao','route de Nogent','92230','GENNEVILLIERS','01 49 00 04 05','01 49 00 04 06',0,'Draft + 30 days',NULL,250000),(37,'Bertolino SA','Marie Lanies','1, rue Antoine Fee','30904','NIMES','04 36 34 34 54','04 36 34 34 43',0,'Draft + 90 days',NULL,400000),(38,'Moreau-Lathus','Joseph Siaou','37, rue Pave','30129','MANDUEL','04 50 00 58 02','04 50 00 57 65',0,'Cheque + reception',NULL,100000),(39,'Bati2000','Serafim Figueiredo','Place de la Gare','93500','PANTIN','01 45 45 43 45','01 45 45 67 89',0,'Draft + 90 days',NULL,450000),(40,'Renisco','Emile Leflot','rue Arthur Enaud','42330','SAINT-GALMIER','02 70 64 69 63','0270 64 65 11',0,'Draft + 30 days',NULL,250000),(41,'Serupa','Pierre Dalet','4, rue Florentin Thorel','26260','MARGES','03 12 34 58 45','03 12 45 79 33',0,'Draft + 60 days',NULL,300000),(42,'Ets Guy Mongeal','Robert Giffaut','10, rue Jean Fievet','74202','THONON','04 48 43 89 01','04 48 43 89 27',0,'Draft + 90 days',NULL,400000),(43,'SAGA','Roger Berche','6, Bd de Europe','17310','ARCENS','03 57 67 91 12','03 57 67 92 21',0,'Draft + 90 days',NULL,500000),(44,'SEEP SARL','Blanche Portecop','44, av. Jean Baptist Lebas','16540','FONTAN','03 58 30 03 65','03 58 30 00 01',0,'Draft + 60 days',NULL,300000),(45,'Desbrosses SA','Chantal Courtin','5, rue de Verdun','42120','LE COTEAU','03 44 24 46 30','03 44 24 30 28',0,'Draft + 30 days',NULL,200000),(46,'Chiavazza Constructions','Pascale Decity','12, rue Machefer','69140','RILLEUX','04 37 56 98 65','04 37 56 12 43',0,'Draft + 60 days',NULL,350000),(47,'Ateliers 92','Christian Chesnay','85, rue de Maubeuge','42155','POUILLY','04 69 66 67 65','04 69 55 68 76',0,'Draft + 30 days',NULL,150000),(48,'Entreprise de menuiserie Laure','Christophe Huart','19, rue Drouot','42153','RIORGES','02 46 56 43 43','02 46 56 67 54',0,'Draft + 30 days',NULL,150000),(49,'JJET peintures','Simone Boureau','147, rue du Temple','94404','VITRY','01 68 45 65 45','01 68 45 65 46',0,'Draft + 60 days',NULL,350000),(50,'ITG','Ginette Gaudemar','20, rue du Bourg Neuf','48150','MEYRUEIS','05 50 00 04 05','05 50 00 04 06',0,'Draft + 60 days',NULL,300000),(51,'Fichot et associes','Eric Zana','route des Landes','78250','HARDRICOURT','01 37 34 34 54','01 37 34 34 43',0,'Draft + 30 days',NULL,150000),(52,'M.E.I.','Laurent Bertucat','48, rue Paul Petit','67026','STRASBOURG','03 51 00 58 02','03 51 00 57 65',0,'Draft + 60 days',NULL,350000),(53,'Polzella SARL','Roger Grandgirard','Route de Grignols','69100','cityURBANNE','04 46 45 43 45','04 46 45 67 89',0,'Cheque + reception',NULL,100000),(54,'Novex','Jean Comte','67 rue Simon Dumartin','64000','PAU','05 71 64 69 63','05 71 64 65 11',0,'Cheque + reception',NULL,100000),(55,'Ertim SA','Alain Renard','55, rue Remoncourt','68200','MULHOUSE','03 13 34 58 45','03 13 45 79 33',0,'Draft + 30 days',NULL,200000),(56,'Cogeto','Francois Biziau','24, rue Saint Charles','77930','PERTHES','01 49 43 89 01','01 49 43 89 27',0,'Draft + 60 days',NULL,350000),(57,'Cabinet Goizet','Agnes Blanc','3, av. de la Gare','95700','ROISSY','01 58 67 91 12','01 58 67 92 21',0,'Draft + 90 days',NULL,400000),(58,'Architecture and Communication','Christian Gobert','110, rue Relles Goutes','78310','MAUREPAS','01 59 30 03 65','01 59 30 00 01',0,'Draft + 30 days',NULL,250000),(59,'Fanton renovation','Mario Lonni','53 rue du Fosse Blanc','94100','SAINT-MAUR','01 72 64 69 63','01 72 64 65 11',0,'Draft + 30 days',NULL,250000),(60,'Manulion','Michel Salom','34, rue Edouard Vaillant','69003','LYON','04 14 34 58 45','04 14 45 79 33',0,'Draft + 60 days',NULL,300000),(61,'VEGA SARL','Paul Vernant','45, Avenue du Quebec','91190','ORSAY','01 69 45 87 12','01 69 45 09 08',0,'Draft + 30 days',NULL,200000),(62,'LEGEND','Paul Turner','23 Bd Franklin Roosevelt','92160','ANTONY','01 46 66 57 89','01 46 66 23 12',0,'Draft + 60 days',NULL,350000),(63,'Hammers','Paul Schmidt','knowledge village','0000','Dubai','0567543243','0567543243',NULL,NULL,NULL,5000),(64,'MoneyMaker','Ali Muzafar','Dubai mall','0000','Dubai','0567543243','0567543243',NULL,NULL,NULL,10000);
/*!40000 ALTER TABLE `client` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `account`
--

DROP TABLE IF EXISTS `account`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `account` (
  `num_client` int NOT NULL,
  `username` varchar(45) NOT NULL,
  `password` varchar(128) NOT NULL,
  PRIMARY KEY (`num_client`),
  UNIQUE KEY `username_UNIQUE` (`username`),
  CONSTRAINT `num_client` FOREIGN KEY (`num_client`) REFERENCES `client` (`num_client`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `account`
--

LOCK TABLES `account` WRITE;
/*!40000 ALTER TABLE `account` DISABLE KEYS */;
INSERT INTO `account` VALUES (1,'Masson','$2a$10$HYjSXF2owaWixcHR5vmQZOR3FzohiQ5d222mZi0eTatVMS0gpNrM6'),(2,'Holdeux','$2a$10$V1Ey5uNcb0JWO2GWwvoDvetJ.6jg47LLNWSh2x2knpEUDUjpTy7FG'),(3,'Bosh','$2a$10$raeacrREupuPjYQt.W/Kz.9Pv8/snCqf7xwhurEWuGIDXSDxzN5Du'),(4,'Lhermite','$2a$10$goifuekA36VljpIgbPqKPeCzM8Rx.aPvzNweLAagEO3IN1TAxrhtW'),(5,'Houdon','$2a$10$pkxUVRBkoxCrRvx.VVORg.jcFLX23V16QVHsUYIbJSAbyNQJ/A2BO'),(6,'Pons','$2a$10$6hKV6UbtHaaq6yk6kSL8eu5Xaa.ijpWZKw0Hw7CZhIegKoflUKpCO'),(7,'Hochon','$2a$10$mJ2GJSnQ6.K5O7SzaRxhsOxvLJPRi3IynAOCTn8W307Ht7shSo8XC'),(8,'Marcellin','$2a$10$E7COZgW5i29RIcOhWOSFyOo7dUKbgtUkWjb7JDvHkJPRK8q9UXuKe'),(9,'Leclerc','$2a$10$L2KSD4FGhpqR96zu09UUrOEF20PfRruQDF2d.EnNUBtLSgBPq1CkO'),(10,'Dercourt','$2a$10$34HPyRgar0WiL3K09n1n8Oxux/Qot3e6upBVJb4Vmm2acebfxdyPq'),(11,'Fermier','$2a$10$.FXKO8Ylhs/kyWogKASSCONr6QezW1khsazx5KrC5dfX3QMlML3fW'),(12,'Bergere','$2a$10$NQE868LC6S0wnawp0Mibaub5hH5JaMZIuukvLpCOghvq4hkFMTTTW'),(13,'Durand','$2a$10$RI60xxCF8jOoRC.XqBf4qecEZ4vEHWFNVFqI9//pvkFENT3OoWwzO'),(14,'Sempaix','$2a$10$NoTkL4Tie8qsP94FimRbS.O2ipYIidGIJCR1IK2DXTDHeWLHVa5UO'),(15,'Martichoux','$2a$10$7Pe3.i2nxwllNrqWdf3Q1.OQh0ti7QGnGs.DTouiGOzEWztYlbui6'),(16,'Lepont','$2a$10$liMBJ6PQ2nf9FS//WfqvsO0GC8UBDOrB0NGMgml4BuDUIFQYp48HK'),(17,'Delisle','$2a$10$JfJ/uxnn.hcEOcPVkBDNle7zQqK7BMYD4VpLK3t9zW4ACtL7.oEiy'),(18,'Gerard','$2a$10$uk4lW7E8qrVmwloZNPNi2OWGsSv5sz/i7a/KzJ24tFt3pODfc.sUa'),(19,'Bideau','$2a$10$SBg0FtGH3VD8J0WcXlbIcu/qGNR6EeFZbZJZDY/usWENGzQT4lL7q'),(20,'Blutte','$2a$10$wvTEPls9TD7h.gvti3b5vupGJzdvFAuBy2iTpb3nWldaREXQ2DmjW'),(21,'Favre','$2a$10$5lEy.zaKALQkzvK2sObNNu1bHhSoRRcVwwr9n2KsHceoCk2NS77Ia'),(22,'Salinier','$2a$10$wNrldN9tlfIUpyOGRD0a1.cZC.dPDDIwnA7us0mM2PGAQvnpZM1SS'),(23,'Ayrault','$2a$10$4R1OBzc9DhIvX9fT99u5heXbtCjMORM872EMFTWcGnEfP4N38kHt6'),(24,'Aupee','$2a$10$dJi0nU1F2GaolfTbJrZmGefGvJy/Ns6hE.75psPBryW.g5Q5x.FH6'),(25,'Eutrope','$2a$10$YsJQxIolQ5b9jiQNBJHVlOrAWvOLYly7dEdL8kfm.Tfvn6LJqc9AO'),(26,'Mimouni','$2a$10$zPz6Eqm3npOOvRUWie.5ZuFi7Z3eurp9crapMUYv/gMboqUxuSGdG'),(27,'Lopes','$2a$10$Oz4chf/RTHl876GzBXSUb.cT/3nCQZRBxIeh.MQ7mawZqaPtw.Jgm'),(28,'Flutteaux','$2a$10$4kNE.YWCOktr5tYqVkHEXeCns6ESHffOJ56RKdFjloK4xNXPnZwm6'),(29,'Lecleve','$2a$10$ZUzhE2xLAN8H5658Fiq3RuvrVDUccN29592Ucb0OvMBY4.P9WXCzO'),(30,'Malon','$2a$10$O1FViOvMqr6APgmCkRd6ueLP1RDiCo/lyfRzli0/xwJ4CyLGDq4Da'),(31,'Hinard','$2a$10$KwpFD11JnDvOS6D3epfv6eHMKMqlr6IeOZ.nQOrfCHpTWiWKk48HC'),(32,'Pangrani','$2a$10$dv5jdNoSxpSolux6GW3KSu0ZuEDqzxrzkfUW7ouS2L3edoJ08w3ha'),(33,'Martinez','$2a$10$u8KbZQ/shqlLGjLdrsowmeVpvo9WXzpLqwU52M08YKFGt2wA3o0IO'),(34,'Guibert','$2a$10$S6QxSZk7FEnDw0Rfs2yEIuf4.uuaQ8HBBxwgQHOAP48YK5GUTeSea'),(35,'Oblet','$2a$10$/n4iYEWHqTxXjTNXoB3JvOBOM84QiHCBY9s7Sp.R7LvQhm1LTXvWe'),(36,'Capitao','$2a$10$qudmHUF.0MZ.5WMp1Wq98eDYHP18TR.2TY4YXN9tLkX1rm03mj.si'),(37,'Lanies','$2a$10$312qxDOGiiBDq8zQbkn7XOueKTUOTurk.OgH/Lk34BXee0df.A6Ma'),(38,'Siaou','$2a$10$.ekQFgSUid8d7XxKeVusPuSyvL7zQiaoRDgzGb3gA/DHBlJrw8Vga'),(39,'Figueiredo','$2a$10$3BaTvuaGxp5i.NoauRfQ0.Pm1FtVyV/NBlwTlLdHh6.OPp6LS44SK'),(40,'Leflot','$2a$10$fPjTEakk7HO.vStUDfd5KOSYhJ54Oo1tzJE4WZ.zSoLcK6eNl2jIq'),(41,'Dalet','$2a$10$z5iqYRKGU1EZS4fECqSFY.G7NV/VQqUfyaj2CoAQspTSzBWAnduru'),(42,'Giffaut','$2a$10$aJgc/QNbdHlSs0e5ZL8fnuTVMRjsjHmMhnGQUnEBykl63DSThcrRm'),(43,'Berche','$2a$10$TPT5Wa9voYh5V6DdbiOFTuKKdiOm7s6M966.ixBuKO.MLJgv1R/Pa'),(44,'Portecop','$2a$10$Lqz1Kr6L93nysCJlfTpAX.j0niTAoZlbpsJ4j6ClVLXzUkSmKP/Bi'),(45,'Courtin','$2a$10$gKn.HrLF8geQjG58ehYmmO8fwx1Db5rQlj9d06bVnLIx.7GbqeWZG'),(46,'Decity','$2a$10$iNuKUze37QctL2vPGFyfn.yKyp1ttRf3IBb0v6VtJxNI49Rm9alN2'),(47,'Chesnay','$2a$10$N6kQO58VDl4WMawTt79Opu1GTjYLOCQfW/xJsMdhUsSR0pUuwUqRG'),(48,'Huart','$2a$10$19oh/7bHtinlzVK4764OjuFxVys5nuxQMOJwsqC7GhJuY0lMXdtB2'),(49,'Boureau','$2a$10$NyXmKzsR89soMgs75vZoD.y6Z3Li.2YvJudpOcE.3I2.R6VjeXPKu'),(50,'Gaudemar','$2a$10$GPbDKo1EUxRdWusMDuAaqed3neG4nsGHrqKAcarYC4OayBrfXl4He'),(51,'Zana','$2a$10$E59bXQ14NdknAhqZTF6WVu7Styh2tpwF0To1B9pOLlscuIOirRwL6'),(52,'Bertucat','$2a$10$OmpTku8g7ErET3m/sa/HxukGXCNPYLQpo8pVIEiqTVIh27bGDhnN6'),(53,'Grandgirard','$2a$10$cIwdGnFHoBDomL4BESiJ3u.i.YeNG0sO9w9AoRzD0/TqrDekO0XMy'),(54,'Comte','$2a$10$En88H7M38Sv7xJh1I8Ibcu2mTDmLG3Ecd1e/F5nIxjeIxaau3dxM2'),(55,'Renard','$2a$10$begbNm8fd/s9LLgYEeeaFupv2/dAMbjwXtAWVOIdTeZgAl/d/k/Ky'),(56,'Biziau','$2a$10$CNOoejSIlc3A7lHyyfaJCemvfdmGM/IK6mOfXSRWIfVw59TQ8PJdi'),(57,'Blanc','$2a$10$XooPfVYUNtfy4xieIoEqdeDADJJ14RaccNmLtHWfBoV1UERsplYXa'),(58,'Gobert','$2a$10$ip4GijzaPqICZUHXadE8wOgsHrByo4ukzXDZvsYJlmqn.k2iP7l.y'),(59,'Lonni','$2a$10$hcu23gAuOH.tUA9ON2FF3.Z359MpaMYw4DSGxVMkBMxDTndvx3OGi'),(60,'Salom','$2a$10$3WMcVQWSeMppNprbfQu4N.tWMeTTHMcoFMh1c6TofADEorTQ5.oIC'),(61,'Vernant','$2a$10$.dkYKN00QRxU65voSmsrlug7L4eKMOubejwIm.17llzK9ORG336oO'),(62,'Turner','$2a$10$MM4oh7XIBlBdDkrvG8wVxOEuQ8VosoyJZ/DSbiV9mOGT2a5NISGBy'),(63,'Schmidt','$2a$10$cHIjpw8X4N0wN1Lo71DuQ.1rysN/ddIm6n2tKoazfzYdFqcHIKycC'),(64,'Muzafar','$2a$10$CmWwYH.mBb6.J.gcVh.ZXOOIDCGIjOKg2S2V7NtjFkGEJEAqYC7r2');
/*!40000 ALTER TABLE `account` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `guest`
--

DROP TABLE IF EXISTS `guest`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `guest` (
  `firstName` varchar(40) DEFAULT NULL,
  `lastName` varchar(40) DEFAULT NULL,
  `email` varchar(40) DEFAULT NULL,
  `homepage` varchar(80) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `webUse` varchar(40) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `guest`
--

LOCK TABLES `guest` WRITE;
/*!40000 ALTER TABLE `guest` DISABLE KEYS */;
INSERT INTO `guest` VALUES ('hadj','batatia','hadj@x.fr','http://x.f.fr','Rien du tout','Web Master');
/*!40000 ALTER TABLE `guest` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `invoice`
--

DROP TABLE IF EXISTS `invoice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoice` (
  `num_invoice` int NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `client` int DEFAULT NULL,
  `amount_EV` double DEFAULT NULL,
  `amount_VAT` double DEFAULT NULL,
  `amount_IV` double DEFAULT NULL,
  `payment_date` datetime DEFAULT NULL,
  `payment_amount` double DEFAULT NULL,
  `emit_draft` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`num_invoice`),
  KEY `i_client` (`client`),
  CONSTRAINT `0_72` FOREIGN KEY (`client`) REFERENCES `client` (`num_client`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `invoice`
--

LOCK TABLES `invoice` WRITE;
/*!40000 ALTER TABLE `invoice` DISABLE KEYS */;
INSERT INTO `invoice` VALUES (1,'1996-01-01 00:00:00',38,24960,4642.56,29602.56,NULL,NULL,1),(2,'1996-01-03 00:00:00',5,49697.6,9180.3496,58877.9496,NULL,NULL,1),(3,'1996-01-03 00:00:00',24,39523.8,7351.4268,46875.2268,NULL,NULL,1),(4,'1996-01-05 00:00:00',11,81737.6,15070.6216,96808.2216,NULL,NULL,1),(5,'1996-01-05 00:00:00',32,18232.6,3391.2636,21623.8636,NULL,NULL,1),(6,'1996-01-05 00:00:00',43,41731.3,7762.0218,49493.3218,NULL,NULL,1),(7,'1996-01-07 00:00:00',44,156367.8,29084.4108,185452.2108,NULL,NULL,1),(8,'1996-01-07 00:00:00',9,7143.8,1328.7468,8472.5468,NULL,NULL,1),(9,'1996-01-08 00:00:00',5,37229.4,6833.5972,44062.9972,NULL,NULL,1),(10,'1996-01-10 00:00:00',5,41834.8,7385.286,49220.086,NULL,NULL,1),(11,'1996-01-12 00:00:00',44,82132.1,15276.5706,97408.6706,NULL,NULL,1),(12,'1996-01-14 00:00:00',37,12592,2342.112,14934.112,NULL,NULL,1),(13,'1996-01-15 00:00:00',31,24524,4561.464,29085.464,NULL,NULL,1),(14,'1996-01-17 00:00:00',6,98084.9,18243.7914,116328.6914,NULL,NULL,1),(15,'1996-01-18 00:00:00',28,67895.6,12499.468,80395.068,NULL,NULL,1),(16,'1996-01-21 00:00:00',2,91489.3,16787.5764,108276.8764,NULL,NULL,1),(17,'1996-01-22 00:00:00',3,90996.6,16695.9604,107692.5604,NULL,NULL,1),(18,'1996-01-24 00:00:00',30,92598.7,17223.3582,109822.0582,NULL,NULL,1),(19,'1996-01-24 00:00:00',6,34563.5,6059.1945,40622.6945,NULL,NULL,1),(20,'1996-01-27 00:00:00',37,46282,8608.452,54890.452,NULL,NULL,1),(21,'1996-01-29 00:00:00',44,12023.6,2147.624,14171.224,NULL,NULL,1),(22,'1996-01-29 00:00:00',28,17101,3180.786,20281.786,NULL,NULL,1),(23,'1996-01-29 00:00:00',8,51102,9504.972,60606.972,NULL,NULL,1),(24,'1996-02-05 00:00:00',14,48367.5,8939.0032,57306.5032,NULL,NULL,1),(25,'1996-02-08 00:00:00',27,76200.1,14036.6118,90236.7118,NULL,NULL,1),(26,'1996-02-12 00:00:00',51,66301.3,12220.6525,78521.9525,NULL,NULL,1),(27,'1996-02-12 00:00:00',20,44392.1,8072.4826,52464.5826,NULL,NULL,1),(28,'1996-02-15 00:00:00',53,52885,9836.61,62721.61,NULL,NULL,1),(29,'1996-02-15 00:00:00',58,5442.6,852.949,6295.549,NULL,NULL,1),(30,'1996-02-28 00:00:00',5,78805,14657.73,93462.73,NULL,NULL,1),(31,'1996-03-07 00:00:00',45,61699.3,11255.885,72955.185,NULL,NULL,1),(32,'1996-03-08 00:00:00',49,9833,1828.938,11661.938,NULL,NULL,1),(33,'1996-03-09 00:00:00',22,114620,21319.32,135939.32,NULL,NULL,1),(34,'1996-03-10 00:00:00',42,59908.6,10952.7876,70861.3876,NULL,NULL,1),(35,'1996-03-12 00:00:00',26,23755,4418.43,28173.43,NULL,NULL,1),(36,'1996-03-14 00:00:00',37,107083.1,19917.4566,127000.5566,NULL,NULL,1),(37,'1996-03-14 00:00:00',13,38256,7115.616,45371.616,NULL,NULL,1),(38,'1996-03-15 00:00:00',51,41228,7668.408,48896.408,NULL,NULL,1),(39,'1996-03-15 00:00:00',54,55872,10392.192,66264.192,NULL,NULL,1),(40,'1996-03-16 00:00:00',61,124872.1,23226.2106,148098.3106,NULL,NULL,1),(41,'1996-03-17 00:00:00',57,52187.1,9348.568,61535.668,NULL,NULL,1),(42,'1996-03-21 00:00:00',24,56504,10509.744,67013.744,NULL,NULL,1),(43,'1996-03-23 00:00:00',26,73375.6,13298.275,86673.875,NULL,NULL,1),(44,'1996-03-23 00:00:00',58,24344.9,4270.5006,28615.4006,NULL,NULL,1),(45,'1996-03-24 00:00:00',60,61724.6,11251.3684,72975.9684,NULL,NULL,1),(46,'1996-03-24 00:00:00',14,77664,14445.504,92109.504,NULL,NULL,1),(47,'1996-03-26 00:00:00',25,38496.8,7160.4048,45657.2048,NULL,NULL,1),(48,'1996-03-28 00:00:00',6,32289.8,6005.9028,38295.7028,NULL,NULL,1),(49,'1996-03-28 00:00:00',30,57303,10658.358,67961.358,NULL,NULL,1),(50,'1996-03-28 00:00:00',40,45338.8,8175.7983,53514.5983,NULL,NULL,1),(51,'1996-03-30 00:00:00',9,15792.9,2937.4794,18730.3794,NULL,NULL,1),(52,'1996-03-30 00:00:00',58,64308.9,11870.3842,76179.2842,NULL,NULL,1),(53,'1996-03-31 00:00:00',36,27455.4,5051.37,32506.77,NULL,NULL,1),(54,'1996-04-03 00:00:00',6,1390.8,258.6888,1649.4888,NULL,NULL,1),(55,'1996-04-04 00:00:00',21,7706.2,1105.5912,8811.7912,NULL,NULL,1),(56,'1996-04-10 00:00:00',14,45444,8452.584,53896.584,NULL,NULL,1),(57,'1996-04-10 00:00:00',52,46027.8,8340.6978,54368.4978,NULL,NULL,1),(58,'1996-04-11 00:00:00',54,12233.6,1977.1626,14210.7626,NULL,NULL,1),(59,'1996-04-12 00:00:00',45,56132.5,10440.645,66573.145,NULL,NULL,1),(60,'1996-04-12 00:00:00',5,12586.1,2341.0146,14927.1146,NULL,NULL,1),(61,'1996-04-14 00:00:00',48,55508.2,10063.5601,65571.7601,NULL,NULL,1),(62,'1996-04-16 00:00:00',9,57044.4,10610.2584,67654.6584,NULL,NULL,1),(63,'1996-04-20 00:00:00',27,8705.3,1619.1858,10324.4858,NULL,NULL,1),(64,'1996-04-22 00:00:00',48,55647,10299.6188,65946.6188,NULL,NULL,1),(65,'1996-04-22 00:00:00',35,38727.5,7203.315,45930.815,NULL,NULL,1),(66,'1996-04-24 00:00:00',9,6218,957.69,7175.69,NULL,NULL,1),(67,'1996-04-28 00:00:00',29,87432,16262.352,103694.352,NULL,NULL,1),(68,'1996-04-28 00:00:00',48,11881.1,2015.2055,13896.3055,NULL,NULL,1),(69,'1996-04-30 00:00:00',21,340.5,26.5875,367.0875,NULL,NULL,1),(70,'1996-05-01 00:00:00',44,20574.8,3826.9128,24401.7128,NULL,NULL,1),(71,'1996-05-02 00:00:00',22,27854.6,5180.9556,33035.5556,NULL,NULL,1),(72,'1996-05-05 00:00:00',26,98345.7,17698.32,116044.02,NULL,NULL,1),(73,'1996-05-05 00:00:00',14,31909.4,5355.29,37264.69,NULL,NULL,1),(74,'1996-05-06 00:00:00',6,31434.2,5566.919,37001.119,NULL,NULL,1),(75,'1996-05-06 00:00:00',18,58351.6,10828.036,69179.636,NULL,NULL,1),(76,'1996-05-06 00:00:00',21,92603.4,17129.991,109733.391,NULL,NULL,1),(77,'1996-05-09 00:00:00',35,13943.1,2593.4166,16536.5166,NULL,NULL,1),(78,'1996-05-13 00:00:00',23,83145.6,15465.0816,98610.6816,NULL,NULL,1),(79,'1996-05-18 00:00:00',22,64961.7,12082.8762,77044.5762,NULL,NULL,1),(80,'1996-05-20 00:00:00',22,66286.6,12263.7552,78550.3552,NULL,NULL,1),(81,'1996-05-20 00:00:00',37,81891.7,15145.8285,97037.5285,NULL,NULL,1),(82,'1996-05-23 00:00:00',50,20640,3839.04,24479.04,NULL,NULL,1),(83,'1996-05-24 00:00:00',43,11519.9,2142.7014,13662.6014,NULL,NULL,1),(84,'1996-05-26 00:00:00',33,57435,10462.437,67897.437,NULL,NULL,1),(85,'1996-05-28 00:00:00',37,105420.6,19608.2316,125028.8316,NULL,NULL,1),(86,'1996-05-29 00:00:00',41,13319.9,2477.5014,15797.4014,NULL,NULL,1),(87,'1996-05-30 00:00:00',59,86321.4,15298.3908,101619.7908,NULL,NULL,1),(88,'1996-05-31 00:00:00',19,25060,4661.16,29721.16,NULL,NULL,1),(89,'1996-06-01 00:00:00',9,106589.2,19460.9789,126050.1789,NULL,NULL,1),(90,'1996-06-02 00:00:00',59,31292.2,5452.8942,36745.0942,NULL,NULL,1),(91,'1996-06-03 00:00:00',39,36152.5,6724.365,42876.865,NULL,NULL,1),(92,'1996-06-07 00:00:00',4,28166.2,5238.9132,33405.1132,NULL,NULL,1),(93,'1996-06-09 00:00:00',23,56584.5,10342.5746,66927.0746,NULL,NULL,1),(94,'1996-06-10 00:00:00',57,35437.3,6442.1943,41879.4943,NULL,NULL,1),(95,'1996-06-13 00:00:00',47,44847,7844.397,52691.397,NULL,NULL,1),(96,'1996-06-16 00:00:00',46,9495.4,1743.3766,11238.7766,NULL,NULL,1),(97,'1996-06-17 00:00:00',35,7937.1,1078.5846,9015.6846,NULL,NULL,1),(98,'1996-06-19 00:00:00',34,38050,7077.3,45127.3,NULL,NULL,1),(99,'1996-06-19 00:00:00',27,54334,10106.124,64440.124,NULL,NULL,1),(100,'1996-06-19 00:00:00',35,11731.6,2080.6312,13812.2312,NULL,NULL,1),(101,'1996-06-20 00:00:00',41,95783.4,17815.7124,113599.1124,NULL,NULL,1),(102,'1996-06-23 00:00:00',26,31922,5937.492,37859.492,NULL,NULL,1),(103,'1996-06-24 00:00:00',43,55254.2,10028.7087,65282.9087,NULL,NULL,1),(104,'1996-06-25 00:00:00',31,94073.8,17497.7268,111571.5268,NULL,NULL,1),(105,'1996-06-26 00:00:00',11,61981.8,11515.934,73497.734,NULL,NULL,1),(106,'1996-06-29 00:00:00',22,11312.1,2104.0506,13416.1506,NULL,NULL,1),(107,'1996-06-30 00:00:00',52,54248.6,10090.2396,64338.8396,NULL,NULL,1),(108,'1996-06-30 00:00:00',33,65974,12271.164,78245.164,NULL,NULL,1),(109,'1996-07-01 00:00:00',2,23652,4399.272,28051.272,NULL,NULL,1),(110,'1996-07-05 00:00:00',27,66963.7,12025.3979,78989.0979,NULL,NULL,1),(111,'1996-07-05 00:00:00',25,103833.2,19312.9752,123146.1752,NULL,NULL,1),(112,'1996-07-07 00:00:00',50,52851.5,9830.379,62681.879,NULL,NULL,1),(113,'1996-07-14 00:00:00',54,14162.6,2104.532,16267.132,NULL,NULL,1),(114,'1996-07-15 00:00:00',56,32573,5948.3415,38521.3415,NULL,NULL,1),(115,'1996-07-23 00:00:00',36,59399,11048.214,70447.214,NULL,NULL,1),(116,'1996-07-24 00:00:00',61,122638.1,22810.6866,145448.7866,NULL,NULL,1),(117,'1996-07-24 00:00:00',15,136147.2,25323.3792,161470.5792,NULL,NULL,1),(118,'1996-07-24 00:00:00',55,50646.9,9394.9618,60041.8618,NULL,NULL,1),(119,'1996-07-25 00:00:00',9,17647,3224.9902,20871.9902,NULL,NULL,1),(120,'1996-07-25 00:00:00',18,24728.8,4599.5568,29328.3568,NULL,NULL,1),(121,'1996-07-27 00:00:00',25,49927.6,9286.5336,59214.1336,NULL,NULL,1),(122,'1996-07-31 00:00:00',42,48561.2,8598.354,57159.554,NULL,NULL,1),(123,'1996-07-31 00:00:00',54,17984,3230.8968,21214.8968,NULL,NULL,1),(124,'1996-08-02 00:00:00',30,129703,24124.758,153827.758,NULL,NULL,1),(125,'1996-08-02 00:00:00',4,17501,3255.186,20756.186,NULL,NULL,1),(126,'1996-08-04 00:00:00',18,81832.5,15220.845,97053.345,NULL,NULL,1),(127,'1996-08-05 00:00:00',33,70852.4,13178.5464,84030.9464,NULL,NULL,1),(128,'1996-08-19 00:00:00',19,39544.7,7245.0777,46789.7777,NULL,NULL,1),(129,'1996-08-19 00:00:00',28,134485.9,24851.8326,159337.7326,NULL,NULL,1),(130,'1996-08-20 00:00:00',51,40342.4,7503.6864,47846.0864,NULL,NULL,1),(131,'1996-08-24 00:00:00',36,53666.8,9982.0248,63648.8248,NULL,NULL,1),(132,'1996-08-25 00:00:00',48,20476.5,3808.629,24285.129,NULL,NULL,1),(133,'1996-08-27 00:00:00',42,27486.5,5112.489,32598.989,NULL,NULL,1),(134,'1996-08-27 00:00:00',46,29768.1,5536.8666,35304.9666,NULL,NULL,1),(135,'1996-08-27 00:00:00',51,72063.1,12948.5247,85011.6247,NULL,NULL,1),(136,'1996-08-29 00:00:00',38,70238.3,12457.5187,82695.8187,NULL,NULL,1),(137,'1996-08-29 00:00:00',30,20810,3870.66,24680.66,NULL,NULL,1),(138,'1996-08-31 00:00:00',37,55210.5,10269.153,65479.653,NULL,NULL,1),(139,'1996-09-01 00:00:00',29,94195.9,17520.4374,111716.3374,NULL,NULL,1),(140,'1996-09-02 00:00:00',21,43357.4,7932.4808,51289.8808,NULL,NULL,1),(141,'1996-09-03 00:00:00',27,18338.2,3385.5436,21723.7436,NULL,NULL,1),(142,'1996-09-06 00:00:00',18,123826,23031.636,146857.636,NULL,NULL,1),(143,'1996-09-07 00:00:00',43,31270.9,5759.0356,37029.9356,NULL,NULL,1),(144,'1996-09-08 00:00:00',52,49118,9135.948,58253.948,NULL,NULL,1),(145,'1996-09-11 00:00:00',59,41555,7729.23,49284.23,NULL,NULL,1),(146,'1996-09-13 00:00:00',62,98910,18198.402,117108.402,NULL,NULL,1),(147,'1996-09-15 00:00:00',12,19842.2,3616.87,23459.07,NULL,NULL,1),(148,'1996-09-17 00:00:00',50,97829.5,18196.287,116025.787,NULL,NULL,1),(149,'1996-09-22 00:00:00',33,13493.3,2326.0263,15819.3263,NULL,NULL,1),(150,'1996-09-23 00:00:00',31,5079.5,780.906,5860.406,NULL,NULL,1),(151,'1996-09-28 00:00:00',45,58250.2,10570.546,68820.746,NULL,NULL,1),(152,'1996-10-03 00:00:00',60,6558.2,1219.8252,7778.0252,NULL,NULL,1),(153,'1996-10-05 00:00:00',13,110622.2,20575.7292,131197.9292,NULL,NULL,1),(154,'1996-10-05 00:00:00',54,2579,149.705,2728.705,NULL,NULL,1),(155,'1996-10-06 00:00:00',41,64475.7,11521.2732,75996.9732,NULL,NULL,1),(156,'1996-10-07 00:00:00',20,20366,3624.195,23990.195,NULL,NULL,1),(157,'1996-10-09 00:00:00',3,58310,10702.2805,69012.2805,NULL,NULL,1),(158,'1996-10-10 00:00:00',19,80772.5,14693.172,95465.672,NULL,NULL,1),(159,'1996-10-10 00:00:00',20,9806,1690.4794,11496.4794,NULL,NULL,1),(160,'1996-10-11 00:00:00',37,32584,6060.624,38644.624,NULL,NULL,1),(161,'1996-10-12 00:00:00',22,63323.8,11316.2422,74640.0422,NULL,NULL,1),(162,'1996-10-14 00:00:00',18,62407.1,11521.6929,73928.7929,NULL,NULL,1),(163,'1996-10-14 00:00:00',26,60574,11266.764,71840.764,NULL,NULL,1),(164,'1996-10-15 00:00:00',45,21480.4,3931.9504,25412.3504,NULL,NULL,1),(165,'1996-10-15 00:00:00',39,56451.8,10477.267,66929.067,NULL,NULL,1),(166,'1996-10-16 00:00:00',52,12894,2398.284,15292.284,NULL,NULL,1),(167,'1996-10-20 00:00:00',9,14643,2705.1532,17348.1532,NULL,NULL,1),(168,'1996-10-20 00:00:00',25,64392.2,11877.5202,76269.7202,NULL,NULL,1),(169,'1996-10-20 00:00:00',19,5110,950.46,6060.46,NULL,NULL,1),(170,'1996-10-22 00:00:00',41,92266,17161.476,109427.476,NULL,NULL,1),(171,'1996-10-22 00:00:00',25,5212,969.432,6181.432,NULL,NULL,1),(172,'1996-10-24 00:00:00',1,29672,5518.992,35190.992,NULL,NULL,1),(173,'1996-11-04 00:00:00',22,44818,8037.861,52855.861,NULL,NULL,1),(174,'1996-11-06 00:00:00',62,57348.4,10212.442,67560.842,NULL,NULL,1),(175,'1996-11-08 00:00:00',21,67811.6,12612.9576,80424.5576,NULL,NULL,1),(176,'1996-11-10 00:00:00',4,55860,10389.96,66249.96,NULL,NULL,1),(177,'1996-11-13 00:00:00',11,123196.4,22386.548,145582.948,NULL,NULL,1),(178,'1996-11-15 00:00:00',20,24400.8,4538.5488,28939.3488,NULL,NULL,1),(179,'1996-11-17 00:00:00',22,52531.8,9373.1988,61904.9988,NULL,NULL,1),(180,'1996-11-19 00:00:00',44,95638.1,17641.1282,113279.2282,NULL,NULL,1),(181,'1996-11-20 00:00:00',27,19365.8,3528.5478,22894.3478,NULL,NULL,1),(182,'1996-11-20 00:00:00',12,54050.4,9823.9672,63874.3672,NULL,NULL,1),(183,'1996-11-20 00:00:00',35,37779.6,6953.5146,44733.1146,NULL,NULL,1),(184,'1996-11-21 00:00:00',25,40851.1,7411.1187,48262.2187,NULL,NULL,1),(185,'1996-11-22 00:00:00',29,67161.8,12096.108,79257.908,NULL,NULL,1),(186,'1996-11-23 00:00:00',17,42946,7987.956,50933.956,NULL,NULL,1),(187,'1996-11-27 00:00:00',11,11411.7,1917.6922,13329.3922,NULL,NULL,1),(188,'1996-11-28 00:00:00',22,61507.6,11364.3288,72871.9288,NULL,NULL,1),(189,'1996-12-02 00:00:00',4,16115,2799.3966,18914.3966,NULL,NULL,1),(190,'1996-12-05 00:00:00',9,83203.5,15475.851,98679.351,NULL,NULL,1),(191,'1996-12-10 00:00:00',45,49553.4,9216.9324,58770.3324,NULL,NULL,1),(192,'1996-12-10 00:00:00',62,108245.9,20095.695,128341.595,NULL,NULL,1),(193,'1996-12-12 00:00:00',11,56307.2,9801.6332,66108.8332,NULL,NULL,1),(194,'1996-12-12 00:00:00',4,40858.7,7269.0087,48127.7087,NULL,NULL,1),(195,'1996-12-17 00:00:00',55,14276.3,2518.785,16795.085,NULL,NULL,1),(196,'1996-12-24 00:00:00',45,58077.6,10802.4336,68880.0336,NULL,NULL,1),(197,'1996-12-29 00:00:00',30,26863.2,4996.5552,31859.7552,NULL,NULL,1),(198,'1996-12-29 00:00:00',36,7774.1,1445.9826,9220.0826,NULL,NULL,1),(199,'1996-12-31 00:00:00',29,35723.6,6644.5896,42368.1896,NULL,NULL,1),(200,'1996-12-31 00:00:00',46,78889.1,14318.939,93208.039,NULL,NULL,1);
/*!40000 ALTER TABLE `invoice` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `invoice_line`
--

DROP TABLE IF EXISTS `invoice_line`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoice_line` (
  `num_line` int NOT NULL AUTO_INCREMENT,
  `num_invoice` int DEFAULT NULL,
  `ref_article` varchar(50) DEFAULT NULL,
  `quantity` smallint DEFAULT NULL,
  PRIMARY KEY (`num_line`),
  KEY `article_index` (`ref_article`),
  KEY `invoice_index` (`num_invoice`),
  CONSTRAINT `0_58` FOREIGN KEY (`num_invoice`) REFERENCES `invoice` (`num_invoice`),
  CONSTRAINT `0_61` FOREIGN KEY (`ref_article`) REFERENCES `article` (`reference`)
) ENGINE=InnoDB AUTO_INCREMENT=1501 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `invoice_line`
--

LOCK TABLES `invoice_line` WRITE;
/*!40000 ALTER TABLE `invoice_line` DISABLE KEYS */;
INSERT INTO `invoice_line` VALUES (1,84,'11-518',1),(2,177,'09-077',7),(3,172,'25-069',3),(4,90,'84-017',10),(5,158,'38-111',8),(6,126,'82-032',9),(7,124,'31-081',10),(8,16,'84-018',8),(9,2,'68-190',4),(10,43,'68-184',3),(11,38,'31-083',3),(12,192,'77-104',7),(13,117,'31-080',5),(14,36,'68-191',10),(15,16,'31-081',4),(16,165,'65-043',1),(17,79,'31-073',5),(18,129,'31-082',6),(19,126,'35-650',5),(20,39,'35-520',1),(21,199,'84-023',10),(22,128,'65-042',3),(23,18,'47-125',10),(24,114,'14-040',2),(25,102,'77-105',4),(26,31,'84-024',6),(27,147,'65-048',4),(28,6,'31-080',7),(29,131,'68-187',7),(30,11,'38-110',3),(31,95,'68-185',8),(32,42,'25-075',1),(33,33,'38-110',10),(34,72,'35-650',6),(35,25,'07-390',8),(36,130,'82-032',7),(37,62,'68-185',9),(38,65,'77-101',3),(39,200,'31-071',10),(40,6,'84-016',4),(41,80,'68-188',9),(42,144,'31-087',4),(43,46,'68-187',6),(44,43,'84-018',2),(45,60,'31-073',3),(46,97,'31-086',5),(47,25,'31-088',3),(48,52,'65-043',4),(49,122,'05-303',5),(50,11,'84-016',5),(51,19,'31-084',3),(52,131,'31-068',4),(53,195,'84-017',4),(54,186,'84-024',1),(55,57,'31-076',9),(56,162,'82-032',2),(57,26,'31-084',4),(58,156,'84-021',5),(59,118,'31-069',7),(60,142,'68-191',7),(61,107,'31-082',8),(62,132,'84-024',4),(63,41,'25-071',4),(64,120,'11-583',9),(65,136,'84-020',5),(66,61,'31-072',10),(67,93,'14-040',6),(68,91,'38-111',5),(69,25,'68-190',6),(70,101,'68-186',2),(71,41,'82-032',3),(72,107,'84-018',7),(73,191,'25-073',9),(74,136,'34-824',7),(75,53,'38-110',6),(76,181,'65-042',2),(77,99,'31-077',2),(78,126,'68-188',3),(79,131,'38-103',6),(80,77,'47-125',9),(81,85,'34-821',6),(82,159,'65-043',1),(83,68,'68-184',2),(84,108,'77-103',7),(85,107,'84-019',7),(86,200,'84-023',8),(87,30,'35-520',1),(88,53,'65-048',3),(89,193,'77-107',6),(90,193,'31-085',4),(91,46,'31-087',6),(92,147,'68-187',4),(93,23,'77-102',8),(94,126,'38-109',9),(95,117,'31-071',4),(96,37,'77-104',4),(97,128,'77-104',6),(98,47,'25-071',9),(99,200,'65-048',5),(100,99,'31-069',6),(101,178,'31-071',6),(102,84,'84-022',5),(103,61,'31-069',4),(104,43,'84-017',4),(105,184,'25-071',9),(106,142,'77-105',7),(107,136,'65-043',7),(108,200,'31-068',5),(109,113,'65-047',8),(110,58,'47-160',7),(111,100,'68-187',9),(112,119,'47-160',6),(113,170,'84-022',6),(114,18,'14-040',9),(115,189,'11-573',4),(116,107,'68-192',1),(117,155,'65-048',10),(118,4,'35-520',9),(119,173,'31-083',6),(120,142,'82-032',10),(121,55,'38-105',8),(122,57,'77-101',9),(123,144,'77-106',3),(124,45,'65-041',8),(125,147,'08-151',3),(126,73,'38-108',8),(127,84,'31-076',10),(128,89,'31-071',1),(129,41,'38-112',9),(130,182,'77-102',8),(131,18,'38-110',10),(132,153,'07-390',6),(133,186,'77-105',8),(134,136,'25-075',2),(135,118,'84-022',2),(136,153,'08-151',8),(137,75,'31-072',5),(138,182,'31-072',6),(139,163,'31-069',6),(140,118,'38-109',4),(141,143,'38-103',9),(142,20,'84-022',10),(143,71,'68-192',1),(144,145,'68-192',7),(145,147,'77-107',7),(146,89,'38-112',6),(147,126,'25-074',7),(148,33,'25-070',6),(149,18,'77-106',10),(150,168,'31-082',2),(151,73,'77-107',8),(152,194,'65-042',9),(153,183,'84-021',8),(154,80,'84-020',10),(155,193,'65-041',10),(156,14,'68-191',10),(157,121,'84-024',8),(158,20,'05-303',10),(159,133,'82-032',9),(160,108,'47-160',10),(161,121,'84-020',5),(162,178,'47-125',9),(163,38,'77-101',10),(164,175,'31-083',2),(165,44,'68-192',3),(166,76,'84-020',10),(167,44,'84-019',8),(168,170,'34-824',3),(169,180,'11-573',9),(170,94,'38-105',2),(171,76,'77-106',5),(172,111,'38-112',6),(173,97,'31-080',6),(174,174,'84-020',7),(175,67,'68-187',7),(176,11,'38-106',4),(177,111,'34-821',6),(178,145,'08-151',5),(179,21,'31-087',10),(180,179,'38-107',2),(181,72,'84-016',10),(182,142,'31-086',2),(183,74,'84-020',9),(184,118,'65-044',2),(185,133,'38-104',10),(186,157,'31-068',5),(187,114,'65-042',3),(188,45,'31-075',4),(189,197,'84-018',3),(190,136,'68-184',8),(191,173,'84-021',9),(192,60,'38-111',8),(193,110,'65-041',5),(194,37,'31-086',5),(195,158,'31-077',9),(196,83,'07-390',4),(197,153,'31-085',7),(198,96,'05-303',2),(199,180,'84-019',4),(200,56,'84-019',1),(201,131,'84-023',9),(202,113,'68-189',1),(203,7,'84-019',4),(204,155,'38-110',10),(205,128,'31-076',6),(206,99,'77-107',10),(207,165,'11-573',6),(208,111,'31-074',2),(209,93,'11-573',9),(210,166,'84-023',9),(211,129,'05-303',9),(212,102,'84-016',10),(213,121,'31-074',3),(214,70,'05-303',10),(215,73,'84-024',5),(216,162,'47-125',3),(217,100,'31-081',10),(218,168,'68-190',4),(219,41,'82-032',4),(220,177,'77-102',9),(221,74,'65-048',9),(222,75,'11-518',7),(223,12,'84-019',2),(224,199,'31-076',1),(225,59,'77-101',2),(226,72,'38-111',7),(227,124,'84-019',5),(228,113,'65-046',2),(229,155,'07-390',8),(230,183,'38-103',4),(231,194,'31-075',4),(232,95,'25-072',6),(233,9,'07-390',3),(234,184,'84-024',4),(235,74,'84-023',8),(236,34,'14-040',5),(237,136,'38-105',8),(238,50,'38-103',7),(239,141,'38-111',7),(240,24,'25-074',8),(241,195,'31-084',3),(242,141,'25-075',4),(243,140,'47-160',5),(244,151,'31-080',4),(245,7,'47-160',9),(246,155,'14-040',8),(247,85,'38-104',2),(248,160,'47-160',2),(249,117,'84-025',9),(250,23,'84-022',6),(251,61,'65-047',3),(252,1,'77-103',6),(253,61,'65-044',3),(254,41,'38-111',9),(255,93,'31-073',5),(256,101,'34-824',6),(257,193,'25-069',9),(258,88,'68-192',1),(259,67,'77-104',7),(260,174,'05-303',4),(261,103,'77-101',2),(262,95,'14-040',9),(263,20,'31-083',9),(264,31,'65-044',3),(265,107,'84-024',8),(266,63,'31-085',4),(267,5,'38-104',9),(268,161,'38-106',3),(269,87,'68-190',10),(270,87,'68-187',1),(271,5,'14-040',7),(272,73,'05-303',9),(273,174,'15-991',10),(274,90,'25-072',3),(275,16,'31-083',4),(276,81,'68-184',10),(277,45,'68-192',6),(278,62,'31-074',9),(279,107,'68-188',8),(280,129,'65-044',7),(281,194,'08-151',7),(282,98,'25-075',10),(283,137,'68-186',6),(284,124,'34-824',8),(285,80,'35-650',4),(286,90,'65-042',10),(287,191,'31-069',2),(288,105,'77-103',6),(289,78,'84-020',5),(290,178,'34-824',1),(291,168,'11-573',1),(292,159,'31-086',5),(293,66,'65-047',4),(294,10,'31-085',5),(295,179,'68-191',4),(296,187,'65-045',4),(297,164,'65-044',5),(298,4,'25-075',2),(299,170,'25-069',6),(300,198,'31-075',7),(301,193,'65-044',10),(302,111,'31-083',6),(303,6,'38-111',1),(304,155,'31-085',10),(305,23,'07-390',8),(306,78,'25-071',4),(307,28,'31-088',6),(308,21,'84-023',2),(309,19,'68-190',4),(310,162,'31-070',8),(311,31,'38-109',3),(312,136,'25-071',2),(313,76,'31-070',2),(314,176,'34-821',5),(315,15,'77-104',7),(316,187,'68-188',4),(317,107,'31-069',4),(318,35,'38-110',4),(319,142,'68-189',9),(320,146,'77-102',9),(321,182,'68-187',6),(322,131,'84-020',6),(323,7,'68-187',1),(324,151,'65-046',4),(325,157,'65-041',5),(326,114,'38-111',2),(327,81,'68-189',6),(328,14,'77-102',9),(329,18,'11-583',9),(330,88,'31-082',7),(331,24,'38-110',7),(332,126,'25-072',1),(333,108,'68-189',6),(334,141,'84-017',4),(335,61,'31-083',8),(336,157,'84-021',2),(337,64,'31-081',2),(338,45,'14-040',7),(339,161,'38-112',6),(340,124,'11-573',8),(341,117,'31-081',5),(342,119,'09-077',7),(343,140,'31-075',8),(344,84,'65-042',6),(345,138,'09-077',3),(346,81,'68-190',1),(347,183,'31-077',9),(348,159,'31-070',7),(349,40,'68-191',9),(350,79,'31-077',2),(351,191,'77-105',4),(352,138,'68-189',8),(353,164,'25-073',3),(354,6,'38-105',4),(355,92,'68-187',3),(356,77,'38-106',8),(357,49,'47-160',5),(358,7,'31-083',5),(359,109,'14-040',5),(360,188,'38-106',7),(361,118,'31-071',5),(362,17,'34-821',6),(363,87,'38-107',7),(364,196,'31-075',4),(365,190,'34-821',5),(366,116,'77-101',9),(367,158,'65-045',8),(368,145,'84-017',8),(369,58,'68-187',6),(370,143,'77-103',3),(371,154,'65-046',5),(372,157,'07-390',5),(373,191,'84-025',6),(374,185,'84-019',7),(375,90,'25-070',1),(376,30,'25-072',10),(377,76,'25-071',10),(378,155,'31-073',3),(379,103,'31-073',3),(380,84,'31-083',2),(381,41,'84-024',2),(382,19,'11-543',3),(383,121,'25-073',4),(384,11,'84-021',3),(385,192,'65-044',3),(386,61,'25-069',2),(387,111,'34-821',6),(388,9,'65-043',4),(389,127,'84-025',3),(390,42,'11-573',9),(391,135,'38-110',6),(392,107,'31-087',2),(393,106,'25-069',1),(394,7,'11-518',4),(395,38,'25-069',2),(396,14,'31-085',9),(397,153,'77-107',7),(398,191,'38-106',9),(399,93,'38-107',4),(400,184,'68-191',2),(401,15,'65-048',7),(402,187,'65-048',4),(403,171,'31-069',5),(404,135,'68-191',7),(405,37,'31-087',8),(406,122,'65-044',3),(407,185,'11-573',7),(408,63,'38-110',9),(409,139,'31-072',7),(410,30,'25-073',5),(411,13,'68-188',6),(412,92,'38-110',2),(413,61,'65-048',4),(414,36,'38-110',3),(415,177,'34-821',9),(416,130,'09-077',9),(417,59,'31-075',1),(418,109,'31-070',7),(419,49,'25-069',10),(420,29,'31-087',2),(421,99,'77-104',9),(422,143,'84-018',3),(423,129,'34-824',3),(424,16,'31-074',10),(425,179,'35-650',3),(426,146,'65-047',4),(427,48,'38-111',2),(428,42,'68-184',6),(429,33,'47-125',2),(430,103,'09-077',5),(431,72,'15-991',7),(432,117,'68-190',8),(433,78,'38-108',10),(434,69,'65-042',1),(435,162,'68-185',9),(436,146,'08-151',9),(437,76,'35-520',5),(438,127,'07-390',6),(439,117,'68-191',8),(440,34,'68-186',2),(441,200,'65-045',8),(442,148,'68-186',8),(443,156,'68-186',4),(444,135,'09-077',9),(445,123,'77-101',9),(446,197,'84-016',6),(447,97,'31-073',5),(448,175,'14-040',8),(449,116,'31-082',2),(450,26,'47-160',4),(451,90,'31-076',4),(452,94,'11-583',1),(453,78,'84-017',9),(454,131,'31-074',8),(455,8,'31-075',4),(456,39,'82-032',10),(457,149,'31-070',10),(458,128,'31-077',4),(459,55,'35-650',3),(460,28,'31-082',10),(461,131,'47-125',5),(462,28,'11-518',3),(463,158,'68-191',4),(464,77,'38-103',5),(465,172,'31-068',3),(466,17,'31-071',8),(467,3,'31-068',10),(468,70,'31-075',8),(469,64,'05-303',3),(470,123,'31-069',2),(471,119,'31-073',7),(472,25,'68-187',7),(473,18,'77-102',10),(474,148,'38-109',5),(475,3,'31-081',8),(476,75,'38-104',6),(477,58,'25-075',5),(478,103,'77-106',2),(479,52,'38-103',3),(480,2,'77-106',9),(481,191,'77-106',8),(482,14,'47-125',2),(483,6,'47-160',9),(484,143,'15-991',4),(485,52,'77-101',7),(486,141,'31-076',5),(487,167,'31-072',10),(488,142,'84-024',5),(489,87,'09-077',3),(490,37,'15-991',9),(491,158,'38-104',5),(492,31,'68-189',8),(493,151,'84-022',2),(494,151,'31-084',3),(495,116,'68-186',5),(496,40,'15-991',7),(497,106,'31-080',1),(498,9,'11-543',6),(499,15,'68-191',5),(500,87,'77-101',5),(501,95,'68-187',3),(502,31,'77-103',8),(503,190,'77-103',10),(504,60,'31-085',3),(505,177,'35-650',10),(506,119,'31-075',6),(507,121,'77-106',1),(508,58,'38-106',4),(509,44,'31-075',9),(510,161,'84-025',6),(511,22,'68-185',10),(512,163,'84-022',3),(513,53,'77-101',9),(514,185,'68-188',10),(515,184,'47-125',7),(516,22,'38-112',10),(517,74,'77-101',6),(518,108,'84-017',6),(519,148,'38-105',2),(520,98,'84-024',10),(521,101,'31-070',4),(522,77,'47-160',6),(523,125,'84-025',3),(524,173,'84-025',2),(525,129,'31-070',2),(526,88,'25-071',5),(527,19,'77-103',3),(528,106,'31-068',4),(529,111,'38-112',6),(530,159,'77-107',9),(531,75,'65-044',2),(532,189,'14-040',1),(533,190,'77-106',9),(534,76,'25-073',2),(535,106,'31-075',3),(536,169,'31-082',1),(537,179,'77-103',4),(538,56,'84-018',3),(539,56,'84-016',1),(540,16,'38-110',9),(541,86,'38-104',6),(542,174,'35-650',9),(543,4,'65-044',9),(544,81,'65-041',3),(545,91,'31-086',4),(546,150,'31-087',2),(547,180,'65-048',8),(548,94,'65-047',3),(549,8,'38-110',9),(550,193,'08-151',5),(551,127,'31-076',2),(552,26,'65-041',3),(553,51,'31-071',3),(554,196,'77-104',4),(555,153,'38-109',6),(556,194,'31-073',4),(557,126,'31-070',8),(558,168,'38-108',6),(559,63,'38-112',7),(560,12,'77-101',3),(561,115,'84-019',10),(562,18,'38-103',3),(563,104,'47-160',9),(564,6,'38-103',8),(565,7,'34-824',9),(566,157,'84-022',10),(567,143,'11-583',3),(568,101,'11-573',6),(569,34,'25-070',7),(570,72,'31-075',5),(571,122,'84-022',8),(572,166,'84-025',7),(573,116,'31-087',8),(574,117,'11-573',10),(575,11,'68-187',10),(576,104,'31-072',4),(577,91,'68-190',8),(578,141,'31-077',6),(579,168,'77-106',8),(580,1,'68-188',4),(581,141,'38-104',9),(582,150,'31-070',10),(583,8,'84-023',4),(584,89,'65-041',7),(585,170,'77-101',3),(586,81,'84-021',7),(587,72,'31-088',8),(588,66,'84-020',2),(589,79,'35-650',4),(590,63,'31-072',3),(591,60,'84-025',2),(592,10,'77-106',6),(593,61,'09-077',9),(594,25,'77-102',6),(595,16,'84-024',9),(596,142,'38-112',9),(597,34,'65-044',7),(598,43,'77-101',7),(599,7,'14-040',2),(600,182,'77-102',1),(601,71,'35-520',6),(602,175,'31-086',7),(603,74,'65-043',5),(604,86,'77-105',10),(605,192,'25-073',7),(606,25,'25-069',9),(607,60,'84-018',1),(608,182,'07-390',3),(609,146,'84-020',9),(610,18,'68-191',4),(611,175,'38-103',4),(612,142,'25-074',4),(613,199,'68-189',6),(614,115,'31-081',5),(615,2,'25-070',8),(616,61,'84-022',9),(617,62,'31-085',9),(618,124,'05-303',2),(619,138,'25-073',2),(620,78,'31-073',4),(621,126,'11-518',3),(622,51,'31-072',6),(623,34,'07-390',7),(624,121,'77-103',7),(625,187,'31-070',4),(626,130,'31-071',7),(627,140,'65-046',2),(628,152,'31-070',4),(629,162,'11-573',9),(630,25,'84-017',7),(631,24,'77-107',7),(632,117,'31-085',3),(633,79,'31-075',2),(634,180,'31-085',5),(635,134,'31-083',1),(636,159,'65-048',6),(637,40,'68-191',10),(638,142,'84-020',6),(639,105,'38-110',6),(640,171,'25-069',10),(641,27,'68-189',6),(642,76,'25-074',7),(643,153,'77-107',7),(644,65,'31-084',8),(645,91,'84-017',4),(646,174,'31-082',4),(647,186,'31-085',10),(648,159,'47-160',7),(649,16,'34-824',3),(650,146,'77-106',5),(651,133,'31-080',2),(652,6,'38-112',7),(653,56,'11-518',6),(654,136,'47-160',6),(655,29,'65-043',7),(656,2,'25-075',10),(657,27,'65-048',10),(658,156,'07-390',2),(659,115,'84-023',4),(660,175,'35-520',6),(661,28,'38-109',10),(662,122,'68-187',6),(663,2,'07-390',9),(664,34,'38-103',9),(665,103,'65-047',5),(666,30,'34-821',10),(667,149,'84-021',4),(668,111,'84-020',9),(669,18,'68-185',2),(670,86,'31-075',5),(671,149,'84-022',10),(672,77,'25-071',7),(673,120,'84-024',7),(674,68,'25-074',10),(675,30,'25-074',3),(676,112,'31-088',7),(677,69,'31-070',10),(678,165,'11-518',7),(679,41,'68-190',2),(680,146,'25-074',2),(681,43,'68-185',4),(682,148,'68-191',9),(683,86,'31-086',4),(684,152,'38-106',2),(685,184,'31-086',5),(686,146,'47-160',5),(687,34,'31-077',7),(688,165,'31-086',2),(689,66,'25-072',9),(690,105,'35-520',5),(691,112,'11-573',3),(692,8,'31-076',4),(693,45,'31-069',1),(694,148,'31-082',8),(695,184,'65-047',3),(696,155,'65-041',10),(697,187,'84-024',3),(698,61,'31-075',4),(699,116,'38-103',9),(700,64,'08-151',8),(701,59,'68-190',4),(702,190,'31-082',5),(703,21,'25-071',3),(704,21,'65-044',7),(705,64,'77-101',2),(706,105,'25-070',8),(707,141,'38-103',5),(708,72,'11-583',10),(709,82,'84-020',7),(710,162,'35-650',5),(711,50,'77-107',3),(712,61,'31-070',5),(713,142,'31-070',10),(714,138,'84-022',2),(715,138,'38-111',6),(716,110,'68-185',9),(717,104,'68-190',7),(718,25,'31-071',1),(719,167,'31-072',6),(720,101,'38-105',1),(721,83,'38-105',3),(722,151,'31-070',1),(723,8,'25-071',2),(724,36,'84-022',2),(725,140,'68-188',10),(726,109,'11-573',4),(727,132,'84-021',3),(728,168,'84-017',5),(729,170,'68-184',2),(730,164,'38-104',3),(731,120,'31-074',8),(732,15,'77-102',6),(733,196,'38-106',9),(734,72,'68-189',7),(735,194,'38-103',4),(736,72,'38-112',3),(737,158,'15-991',3),(738,151,'68-190',5),(739,157,'77-107',8),(740,61,'31-070',2),(741,188,'34-824',9),(742,102,'11-543',7),(743,73,'65-043',8),(744,177,'14-040',10),(745,200,'84-022',5),(746,135,'65-042',7),(747,48,'84-018',10),(748,17,'07-390',3),(749,53,'84-019',8),(750,108,'31-080',6),(751,56,'25-070',10),(752,19,'65-047',3),(753,38,'38-106',10),(754,116,'38-107',5),(755,49,'31-087',10),(756,194,'84-021',4),(757,138,'84-019',10),(758,155,'31-077',10),(759,8,'31-075',5),(760,158,'65-043',3),(761,103,'68-191',2),(762,43,'47-160',9),(763,108,'68-191',4),(764,129,'08-151',10),(765,41,'31-068',5),(766,32,'38-110',8),(767,178,'38-107',10),(768,25,'65-043',6),(769,31,'38-108',6),(770,155,'84-016',6),(771,184,'31-069',2),(772,151,'25-070',1),(773,101,'77-102',10),(774,153,'31-076',1),(775,3,'31-070',5),(776,173,'38-109',8),(777,82,'77-106',3),(778,80,'31-074',7),(779,154,'31-080',4),(780,34,'77-102',8),(781,114,'31-087',10),(782,65,'08-151',3),(783,102,'84-022',8),(784,32,'25-074',7),(785,196,'07-390',8),(786,179,'31-068',2),(787,46,'68-191',10),(788,48,'68-192',1),(789,81,'31-082',10),(790,174,'25-072',9),(791,157,'07-390',3),(792,180,'31-068',3),(793,172,'25-073',9),(794,112,'38-110',1),(795,61,'31-071',5),(796,44,'68-188',7),(797,40,'38-110',9),(798,183,'65-042',2),(799,41,'65-043',7),(800,10,'25-071',8),(801,176,'31-082',8),(802,195,'68-189',3),(803,70,'84-018',8),(804,27,'09-077',7),(805,35,'11-543',1),(806,81,'31-082',2),(807,52,'35-520',9),(808,87,'77-104',10),(809,139,'34-821',8),(810,187,'31-073',7),(811,83,'31-077',8),(812,168,'38-112',7),(813,85,'38-106',9),(814,42,'31-082',2),(815,6,'77-104',8),(816,124,'38-108',2),(817,96,'65-043',1),(818,75,'84-019',9),(819,113,'31-084',2),(820,123,'65-044',6),(821,72,'68-186',6),(822,112,'09-077',6),(823,7,'25-072',2),(824,169,'38-111',8),(825,7,'11-518',7),(826,174,'65-045',9),(827,152,'31-076',7),(828,80,'65-045',2),(829,24,'31-082',8),(830,141,'68-192',6),(831,181,'77-105',6),(832,193,'38-104',2),(833,139,'38-109',3),(834,157,'38-103',5),(835,148,'38-104',3),(836,45,'38-110',6),(837,60,'31-085',1),(838,64,'38-106',7),(839,34,'31-087',4),(840,99,'84-022',4),(841,114,'31-086',9),(842,16,'65-045',7),(843,160,'77-107',5),(844,85,'31-082',8),(845,168,'31-072',6),(846,179,'65-047',8),(847,33,'31-087',3),(848,57,'68-191',3),(849,112,'47-160',7),(850,114,'82-032',1),(851,77,'84-024',7),(852,184,'84-017',6),(853,57,'47-125',4),(854,45,'38-110',4),(855,75,'68-185',7),(856,195,'25-072',1),(857,141,'84-022',5),(858,117,'84-021',7),(859,134,'77-104',4),(860,162,'31-087',5),(861,146,'68-190',10),(862,61,'11-543',3),(863,190,'38-110',3),(864,106,'38-103',4),(865,167,'65-048',1),(866,62,'84-016',1),(867,117,'35-650',2),(868,87,'65-046',8),(869,50,'09-077',8),(870,172,'15-991',8),(871,91,'11-543',6),(872,86,'25-074',2),(873,10,'68-189',4),(874,38,'77-101',2),(875,188,'47-160',4),(876,184,'77-107',6),(877,36,'34-821',3),(878,27,'31-083',8),(879,132,'38-108',7),(880,136,'65-047',9),(881,119,'31-071',8),(882,91,'25-070',1),(883,158,'84-024',8),(884,30,'31-085',3),(885,122,'65-046',6),(886,144,'05-303',8),(887,123,'65-044',3),(888,92,'11-518',4),(889,84,'68-192',9),(890,67,'77-104',9),(891,21,'68-192',5),(892,35,'84-021',7),(893,130,'31-074',8),(894,134,'38-107',1),(895,179,'47-160',5),(896,34,'68-188',9),(897,3,'07-390',8),(898,80,'31-087',10),(899,115,'11-583',10),(900,96,'38-103',4),(901,132,'84-018',9),(902,180,'07-390',2),(903,90,'77-103',5),(904,36,'77-104',5),(905,172,'07-390',8),(906,95,'65-047',10),(907,79,'25-074',5),(908,55,'65-045',4),(909,161,'31-072',7),(910,182,'25-069',7),(911,43,'65-042',6),(912,128,'31-087',8),(913,24,'65-041',2),(914,93,'65-043',8),(915,28,'77-107',3),(916,50,'05-303',3),(917,25,'38-108',2),(918,14,'25-072',3),(919,157,'68-192',5),(920,79,'25-073',1),(921,124,'77-103',7),(922,179,'25-075',2),(923,173,'77-107',4),(924,3,'84-021',2),(925,129,'68-185',5),(926,103,'11-518',9),(927,61,'31-070',9),(928,14,'31-086',10),(929,192,'38-109',3),(930,71,'31-088',3),(931,76,'35-520',10),(932,94,'14-040',6),(933,136,'25-071',2),(934,146,'25-075',5),(935,23,'84-017',2),(936,152,'25-069',5),(937,34,'31-077',4),(938,104,'31-084',6),(939,48,'84-018',6),(940,91,'77-107',9),(941,119,'38-111',5),(942,105,'68-185',5),(943,79,'31-074',7),(944,183,'31-075',9),(945,151,'25-070',1),(946,104,'07-390',9),(947,149,'31-074',3),(948,180,'31-072',4),(949,138,'34-821',5),(950,45,'31-084',4),(951,62,'08-151',6),(952,118,'07-390',9),(953,161,'25-069',9),(954,179,'84-024',7),(955,19,'09-077',4),(956,164,'34-821',4),(957,29,'25-073',10),(958,26,'38-104',10),(959,68,'65-047',3),(960,38,'25-071',8),(961,114,'77-103',2),(962,153,'25-072',5),(963,161,'31-088',4),(964,186,'31-086',5),(965,98,'31-083',9),(966,84,'11-573',3),(967,176,'47-125',10),(968,162,'31-071',8),(969,49,'35-520',8),(970,74,'77-105',5),(971,36,'38-107',4),(972,3,'84-021',5),(973,163,'84-019',8),(974,139,'31-088',7),(975,197,'25-071',9),(976,191,'15-991',9),(977,76,'65-048',2),(978,185,'31-084',9),(979,53,'25-075',10),(980,41,'84-017',10),(981,197,'14-040',3),(982,137,'38-110',4),(983,110,'65-042',6),(984,7,'77-104',7),(985,71,'38-105',2),(986,142,'07-390',7),(987,113,'77-103',1),(988,26,'65-044',2),(989,199,'11-583',10),(990,24,'31-081',2),(991,193,'31-073',6),(992,157,'31-086',2),(993,200,'38-109',2),(994,44,'31-068',10),(995,104,'68-191',4),(996,119,'65-041',2),(997,128,'68-192',7),(998,70,'25-070',5),(999,19,'65-042',6),(1000,178,'31-086',6),(1001,81,'68-189',1),(1002,184,'65-044',3),(1003,104,'77-102',4),(1004,50,'65-042',7),(1005,129,'65-048',4),(1006,89,'68-185',5),(1007,95,'77-101',3),(1008,131,'77-103',8),(1009,161,'84-025',9),(1010,43,'77-103',5),(1011,143,'47-160',6),(1012,14,'31-072',4),(1013,44,'25-069',6),(1014,33,'77-104',9),(1015,76,'77-104',2),(1016,133,'31-075',9),(1017,173,'68-184',8),(1018,191,'11-583',9),(1019,196,'84-020',2),(1020,65,'31-075',5),(1021,30,'47-160',9),(1022,143,'65-041',2),(1023,58,'65-047',6),(1024,41,'31-083',6),(1025,44,'31-072',3),(1026,89,'68-186',7),(1027,116,'25-073',4),(1028,160,'34-821',5),(1029,56,'77-107',10),(1030,105,'84-019',8),(1031,7,'07-390',4),(1032,116,'77-104',9),(1033,59,'77-103',2),(1034,125,'77-106',8),(1035,127,'77-103',9),(1036,190,'77-103',1),(1037,106,'31-085',5),(1038,115,'34-821',1),(1039,89,'07-390',8),(1040,145,'38-112',9),(1041,127,'68-190',2),(1042,197,'14-040',1),(1043,171,'68-185',2),(1044,177,'84-022',9),(1045,78,'14-040',8),(1046,197,'38-104',8),(1047,175,'07-390',6),(1048,43,'65-048',7),(1049,89,'68-188',10),(1050,191,'31-075',8),(1051,189,'31-072',3),(1052,16,'84-025',2),(1053,24,'77-101',2),(1054,2,'84-022',7),(1055,197,'77-105',8),(1056,118,'25-069',9),(1057,115,'31-088',5),(1058,45,'38-111',4),(1059,4,'65-048',1),(1060,114,'38-111',9),(1061,151,'31-068',10),(1062,43,'08-151',6),(1063,16,'34-821',2),(1064,4,'31-069',4),(1065,176,'31-086',5),(1066,80,'14-040',6),(1067,65,'31-084',4),(1068,8,'31-070',3),(1069,50,'82-032',8),(1070,143,'68-185',4),(1071,67,'25-074',7),(1072,173,'65-047',6),(1073,59,'68-185',3),(1074,22,'25-070',9),(1075,118,'31-087',4),(1076,198,'38-104',9),(1077,31,'05-303',7),(1078,125,'77-107',5),(1079,39,'68-187',7),(1080,44,'68-185',3),(1081,131,'38-107',9),(1082,4,'77-104',10),(1083,181,'38-110',10),(1084,163,'34-824',7),(1085,34,'77-107',10),(1086,5,'84-019',1),(1087,116,'77-103',9),(1088,112,'68-191',4),(1089,97,'38-104',9),(1090,195,'38-112',4),(1091,82,'31-086',2),(1092,130,'84-017',1),(1093,105,'38-110',4),(1094,72,'65-046',9),(1095,33,'84-022',1),(1096,161,'34-824',5),(1097,157,'31-082',8),(1098,128,'25-069',7),(1099,24,'68-185',2),(1100,22,'38-111',10),(1101,200,'38-108',3),(1102,62,'05-303',6),(1103,192,'77-104',5),(1104,89,'38-103',4),(1105,85,'84-018',10),(1106,75,'84-022',5),(1107,129,'11-543',6),(1108,111,'68-192',2),(1109,134,'31-071',5),(1110,87,'65-044',5),(1111,77,'31-069',6),(1112,129,'77-102',4),(1113,130,'38-109',7),(1114,146,'14-040',8),(1115,155,'31-068',8),(1116,22,'77-107',10),(1117,10,'65-046',6),(1118,121,'31-072',4),(1119,30,'68-189',9),(1120,170,'68-191',7),(1121,114,'31-077',8),(1122,37,'38-110',8),(1123,184,'25-071',7),(1124,16,'11-573',10),(1125,94,'31-084',5),(1126,181,'25-072',6),(1127,124,'31-085',2),(1128,200,'77-103',3),(1129,42,'31-088',10),(1130,195,'65-043',6),(1131,158,'34-821',8),(1132,25,'35-520',6),(1133,104,'77-106',10),(1134,177,'65-046',8),(1135,117,'11-518',7),(1136,115,'84-020',3),(1137,78,'31-070',4),(1138,151,'08-151',8),(1139,99,'77-101',1),(1140,122,'11-573',8),(1141,150,'38-108',5),(1142,13,'31-088',7),(1143,195,'47-160',8),(1144,72,'31-075',10),(1145,168,'31-083',9),(1146,144,'25-073',9),(1147,139,'77-104',9),(1148,76,'65-041',2),(1149,180,'31-071',3),(1150,95,'25-070',5),(1151,73,'07-390',4),(1152,56,'84-025',3),(1153,195,'77-107',3),(1154,33,'84-018',10),(1155,141,'25-074',10),(1156,113,'31-087',9),(1157,117,'31-086',2),(1158,49,'68-188',5),(1159,116,'84-025',10),(1160,126,'68-192',7),(1161,182,'68-188',9),(1162,160,'68-184',4),(1163,196,'38-104',5),(1164,51,'31-073',2),(1165,64,'65-044',4),(1166,134,'38-107',3),(1167,136,'38-111',10),(1168,182,'77-107',6),(1169,127,'77-104',5),(1170,92,'68-192',1),(1171,100,'31-072',6),(1172,131,'68-192',4),(1173,144,'35-520',9),(1174,83,'31-074',4),(1175,24,'38-107',5),(1176,188,'38-108',10),(1177,21,'84-024',4),(1178,110,'65-046',1),(1179,161,'65-046',7),(1180,37,'38-112',9),(1181,106,'31-077',4),(1182,41,'65-047',4),(1183,153,'11-543',9),(1184,163,'38-106',9),(1185,76,'31-086',3),(1186,138,'38-103',5),(1187,145,'15-991',5),(1188,124,'08-151',6),(1189,124,'31-087',9),(1190,82,'25-072',9),(1191,79,'84-016',9),(1192,163,'84-021',7),(1193,163,'68-189',2),(1194,180,'31-075',6),(1195,85,'31-086',6),(1196,167,'84-017',10),(1197,87,'65-048',9),(1198,118,'31-074',5),(1199,80,'25-069',8),(1200,181,'84-024',5),(1201,26,'35-520',8),(1202,153,'08-151',7),(1203,168,'65-047',2),(1204,151,'47-160',2),(1205,89,'77-102',2),(1206,101,'84-021',9),(1207,193,'65-042',2),(1208,162,'25-075',10),(1209,80,'07-390',6),(1210,161,'31-072',3),(1211,196,'77-104',5),(1212,14,'31-075',1),(1213,199,'31-071',8),(1214,67,'84-020',6),(1215,48,'11-518',6),(1216,111,'68-186',8),(1217,119,'31-087',9),(1218,188,'25-070',8),(1219,188,'77-106',9),(1220,93,'84-025',10),(1221,3,'14-040',5),(1222,73,'68-185',3),(1223,94,'31-084',7),(1224,81,'84-025',2),(1225,141,'65-044',2),(1226,162,'34-821',1),(1227,84,'11-583',8),(1228,7,'25-073',7),(1229,77,'08-151',1),(1230,190,'31-081',10),(1231,68,'38-110',6),(1232,177,'84-018',1),(1233,51,'84-021',8),(1234,156,'31-088',2),(1235,186,'68-189',7),(1236,165,'68-188',7),(1237,118,'31-070',7),(1238,165,'31-084',8),(1239,86,'31-080',7),(1240,3,'47-125',10),(1241,43,'84-020',4),(1242,63,'31-076',1),(1243,45,'11-518',9),(1244,56,'84-024',7),(1245,137,'84-022',10),(1246,58,'25-075',3),(1247,101,'82-032',9),(1248,36,'31-084',8),(1249,64,'31-072',4),(1250,16,'84-019',5),(1251,167,'25-074',9),(1252,192,'47-125',10),(1253,19,'25-073',1),(1254,78,'68-184',8),(1255,54,'38-105',2),(1256,12,'25-070',5),(1257,9,'31-071',9),(1258,26,'35-520',8),(1259,139,'47-160',10),(1260,115,'34-824',1),(1261,182,'65-041',8),(1262,25,'82-032',1),(1263,71,'38-111',10),(1264,47,'35-520',8),(1265,33,'34-824',9),(1266,159,'31-069',6),(1267,200,'34-821',10),(1268,92,'09-077',7),(1269,75,'38-105',9),(1270,185,'77-102',7),(1271,14,'31-074',6),(1272,175,'31-086',5),(1273,78,'25-075',1),(1274,92,'84-023',2),(1275,38,'25-070',8),(1276,193,'25-073',3),(1277,177,'15-991',7),(1278,83,'38-103',7),(1279,81,'77-103',3),(1280,45,'84-017',10),(1281,46,'68-185',1),(1282,79,'25-073',1),(1283,188,'65-044',6),(1284,100,'65-044',8),(1285,181,'31-076',5),(1286,32,'84-018',9),(1287,142,'25-071',4),(1288,184,'31-072',7),(1289,84,'68-189',6),(1290,2,'11-518',3),(1291,142,'07-390',7),(1292,129,'31-077',7),(1293,132,'84-021',2),(1294,134,'68-186',4),(1295,11,'31-075',8),(1296,73,'65-047',8),(1297,85,'25-071',4),(1298,161,'84-025',2),(1299,195,'38-110',3),(1300,146,'84-016',7),(1301,96,'77-102',9),(1302,115,'77-105',10),(1303,142,'31-080',4),(1304,136,'25-074',4),(1305,53,'38-111',8),(1306,27,'68-192',3),(1307,178,'25-074',7),(1308,178,'31-084',5),(1309,23,'31-075',4),(1310,3,'31-083',2),(1311,114,'84-018',5),(1312,110,'84-023',9),(1313,129,'77-107',1),(1314,200,'25-069',2),(1315,185,'05-303',10),(1316,73,'31-071',10),(1317,14,'77-107',8),(1318,65,'68-189',5),(1319,85,'31-069',3),(1320,162,'14-040',2),(1321,104,'31-083',9),(1322,17,'65-041',8),(1323,57,'68-188',5),(1324,99,'38-109',6),(1325,110,'77-105',9),(1326,182,'35-520',4),(1327,47,'31-074',8),(1328,143,'68-192',9),(1329,72,'68-184',8),(1330,47,'47-125',6),(1331,89,'31-083',7),(1332,55,'65-045',6),(1333,97,'65-047',8),(1334,193,'31-086',9),(1335,12,'77-107',8),(1336,131,'84-018',4),(1337,123,'38-105',10),(1338,5,'47-125',5),(1339,39,'77-106',2),(1340,13,'84-024',9),(1341,135,'65-046',3),(1342,187,'31-073',6),(1343,140,'11-518',9),(1344,186,'31-086',6),(1345,116,'15-991',3),(1346,50,'77-106',3),(1347,151,'31-077',10),(1348,90,'38-112',8),(1349,17,'08-151',3),(1350,161,'31-080',10),(1351,151,'31-072',5),(1352,51,'05-303',7),(1353,94,'84-016',9),(1354,68,'65-043',2),(1355,182,'84-017',2),(1356,125,'77-102',9),(1357,92,'31-076',1),(1358,87,'84-021',4),(1359,85,'11-518',10),(1360,191,'77-106',8),(1361,47,'68-192',7),(1362,27,'31-071',7),(1363,133,'77-107',10),(1364,108,'68-190',2),(1365,75,'25-074',3),(1366,101,'08-151',1),(1367,118,'84-018',7),(1368,156,'65-045',5),(1369,178,'68-184',5),(1370,93,'77-102',7),(1371,183,'38-112',7),(1372,68,'77-105',5),(1373,136,'07-390',4),(1374,170,'25-070',10),(1375,185,'65-046',6),(1376,9,'31-077',5),(1377,85,'77-105',4),(1378,189,'65-046',3),(1379,49,'38-112',5),(1380,145,'31-084',6),(1381,129,'14-040',10),(1382,103,'31-070',10),(1383,60,'38-107',1),(1384,76,'84-025',8),(1385,121,'68-191',2),(1386,39,'77-103',6),(1387,118,'31-083',7),(1388,24,'84-020',10),(1389,134,'31-070',2),(1390,149,'65-042',5),(1391,72,'38-108',9),(1392,52,'08-151',4),(1393,130,'84-016',10),(1394,11,'84-024',9),(1395,18,'14-040',6),(1396,59,'31-082',10),(1397,78,'68-186',5),(1398,188,'68-185',3),(1399,181,'84-024',7),(1400,122,'84-024',5),(1401,82,'68-188',8),(1402,38,'31-076',10),(1403,169,'25-069',5),(1404,193,'84-016',8),(1405,17,'31-083',9),(1406,55,'47-125',5),(1407,198,'68-186',3),(1408,185,'25-070',7),(1409,31,'68-188',8),(1410,27,'38-110',2),(1411,75,'82-032',7),(1412,10,'31-080',10),(1413,24,'11-543',1),(1414,125,'68-186',1),(1415,50,'77-102',9),(1416,65,'25-074',7),(1417,164,'38-105',3),(1418,193,'65-048',10),(1419,44,'65-042',4),(1420,174,'65-043',7),(1421,11,'11-543',8),(1422,135,'38-103',8),(1423,56,'84-017',3),(1424,105,'31-083',3),(1425,132,'68-185',7),(1426,135,'77-101',7),(1427,89,'65-045',5),(1428,80,'31-084',7),(1429,200,'14-040',2),(1430,194,'15-991',4),(1431,35,'77-104',3),(1432,44,'65-048',6),(1433,79,'47-160',2),(1434,173,'11-583',2),(1435,57,'65-042',6),(1436,192,'34-821',10),(1437,31,'65-043',8),(1438,11,'77-103',10),(1439,89,'08-151',9),(1440,11,'84-022',8),(1441,32,'38-109',10),(1442,80,'31-075',6),(1443,17,'35-520',4),(1444,60,'25-073',7),(1445,59,'77-106',7),(1446,152,'84-017',3),(1447,105,'65-044',1),(1448,70,'38-104',2),(1449,161,'31-088',4),(1450,34,'65-044',8),(1451,153,'47-160',7),(1452,127,'31-080',3),(1453,78,'82-032',6),(1454,184,'31-085',3),(1455,20,'47-125',8),(1456,35,'84-016',3),(1457,48,'38-106',2),(1458,42,'68-192',3),(1459,110,'77-104',9),(1460,180,'34-824',9),(1461,2,'65-044',5),(1462,167,'38-105',5),(1463,151,'07-390',3),(1464,33,'68-187',10),(1465,78,'31-088',10),(1466,150,'65-045',5),(1467,56,'31-077',10),(1468,138,'31-084',5),(1469,193,'25-072',9),(1470,2,'31-072',3),(1471,129,'38-104',4),(1472,170,'15-991',10),(1473,54,'25-073',4),(1474,181,'31-071',6),(1475,84,'09-077',3),(1476,90,'38-105',6),(1477,23,'31-082',7),(1478,71,'38-104',2),(1479,7,'31-076',9),(1480,79,'34-821',9),(1481,64,'35-520',4),(1482,183,'34-821',5),(1483,110,'38-106',1),(1484,40,'31-081',6),(1485,10,'11-583',10),(1486,26,'38-109',10),(1487,121,'31-080',8),(1488,162,'65-041',3),(1489,150,'31-086',4),(1490,163,'31-086',5),(1491,46,'68-184',6),(1492,153,'31-068',5),(1493,49,'68-190',6),(1494,168,'34-824',2),(1495,49,'25-071',7),(1496,140,'38-107',2),(1497,126,'34-821',7),(1498,99,'31-076',8),(1499,170,'25-072',2),(1500,9,'68-186',8);
/*!40000 ALTER TABLE `invoice_line` ENABLE KEYS */;
UNLOCK TABLES;


--
-- Table structure for table `Draft`
--

DROP TABLE IF EXISTS `Draft`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Draft` (
  `num_invoice` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`num_invoice`),
  CONSTRAINT `0_63` FOREIGN KEY (`num_invoice`) REFERENCES `invoice` (`num_invoice`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Draft`
--

LOCK TABLES `Draft` WRITE;
/*!40000 ALTER TABLE `Draft` DISABLE KEYS */;
/*!40000 ALTER TABLE `Draft` ENABLE KEYS */;
UNLOCK TABLES;


--
-- Table structure for table `outstanding`
--

DROP TABLE IF EXISTS `outstanding`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `outstanding` (
  `num_client` int NOT NULL DEFAULT '0',
  `outstanding` double DEFAULT NULL,
  `last_command` datetime DEFAULT NULL,
  PRIMARY KEY (`num_client`),
  CONSTRAINT `0_53` FOREIGN KEY (`num_client`) REFERENCES `client` (`num_client`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `outstanding`
--

LOCK TABLES `outstanding` WRITE;
/*!40000 ALTER TABLE `outstanding` DISABLE KEYS */;
INSERT INTO `outstanding` VALUES (1,0,'1996-08-25 00:00:00'),(2,0,'1996-08-22 00:00:00'),(3,169180.25,'1996-12-29 00:00:00'),(4,35310.04,'1996-12-21 00:00:00'),(5,0,'1996-07-06 00:00:00'),(6,0,'1996-03-20 00:00:00'),(7,0,'1996-07-25 00:00:00'),(8,57597.79,'1996-10-11 00:00:00'),(9,0,'1996-05-27 00:00:00'),(10,0,'1996-01-02 00:00:00'),(11,0,'1996-04-01 00:00:00'),(12,0,'1996-09-08 00:00:00'),(13,0,'1996-05-19 00:00:00'),(14,0,'1996-08-06 00:00:00'),(15,0,'1996-01-15 00:00:00'),(16,316029.97,'1996-11-10 00:00:00'),(17,0,'1996-05-01 00:00:00'),(18,0,'1996-04-13 00:00:00'),(19,166790.39,'1996-10-13 00:00:00'),(20,0,'1996-05-31 00:00:00'),(21,113677.3,'1996-10-13 00:00:00'),(22,285041.49,'1996-10-11 00:00:00'),(23,0,'1996-01-20 00:00:00'),(24,0,'1996-09-10 00:00:00'),(25,0,'1996-04-07 00:00:00'),(26,0,'1996-06-08 00:00:00'),(27,0,'1996-06-25 00:00:00'),(28,0,'1996-09-01 00:00:00'),(29,0,'1996-08-28 00:00:00'),(30,235033.39,'1996-10-13 00:00:00'),(31,94523.83,'1996-12-25 00:00:00'),(32,0,'1996-07-20 00:00:00'),(33,0,'1996-03-24 00:00:00'),(34,0,'1996-03-08 00:00:00'),(35,0,'1996-09-21 00:00:00'),(36,0,'1996-09-08 00:00:00'),(37,0,'1996-07-07 00:00:00'),(38,0,'1996-01-18 00:00:00'),(39,0,'1996-02-23 00:00:00'),(40,0,'1996-01-16 00:00:00'),(41,0,'1996-01-23 00:00:00'),(42,0,'1996-05-02 00:00:00'),(43,0,'1996-06-24 00:00:00'),(44,0,'1996-05-28 00:00:00'),(45,224782.52,'1996-12-06 00:00:00'),(46,136194.11,'1996-10-30 00:00:00'),(47,170641.52,'1996-12-05 00:00:00'),(48,102350.11,'1996-12-27 00:00:00'),(49,0,'1996-01-13 00:00:00'),(50,0,'1996-02-12 00:00:00'),(51,0,'1996-01-11 00:00:00'),(52,254682.28,'1996-11-26 00:00:00'),(53,0,'1996-08-30 00:00:00'),(54,0,'1996-02-21 00:00:00'),(55,0,'1996-08-13 00:00:00'),(56,184167.97,'1996-10-06 00:00:00'),(57,0,'1996-06-03 00:00:00'),(58,184331.56,'1996-12-08 00:00:00'),(59,271079.43,'1996-09-30 00:00:00'),(60,0,'1996-07-26 00:00:00'),(61,0,'1996-04-14 00:00:00'),(62,0,'1996-07-11 00:00:00');
/*!40000 ALTER TABLE `outstanding` ENABLE KEYS */;
UNLOCK TABLES;


/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2021-09-29 10:59:43