CREATE DATABASE Facturation; USE Facturation; -- Suppression des tables DROP TABLE IF EXISTS DETAILS_COMMANDES; DROP TABLE IF EXISTS COMMANDES; DROP TABLE IF EXISTS PRODUITS; DROP TABLE IF EXISTS CLIENTS; -- Structure de la table `CLIENTS` CREATE TABLE CLIENTS ( CODE_CLIENT char(5) NOT NULL, SOCIETE varchar(40) NOT NULL, ADRESSE varchar(60) NOT NULL, VILLE varchar(30) NOT NULL, CODE_POSTAL varchar(10) NOT NULL, PAYS varchar(15) NOT NULL, CATEGORIE int(2) NOT NULL, PRIMARY KEY (CODE_CLIENT) )ENGINE = InnoDB; -- Structure de la table `PRODUITS` CREATE TABLE PRODUITS ( REF_PRODUIT int(6) NOT NULL, NOM_PRODUIT varchar(40) UNIQUE NOT NULL, PRIX_UNITAIRE float(8,2) NOT NULL CHECK (PRIX_UNITAIRE>=0), PRIMARY KEY (REF_PRODUIT) )ENGINE = InnoDB; -- Structure de la table `COMMANDES` CREATE TABLE COMMANDES ( NO_COMMANDE int(6) NOT NULL, DATE_COMMANDE date NOT NULL, CODE_CLIENT char(5) NOT NULL, PRIMARY KEY (NO_COMMANDE), FOREIGN KEY (CODE_CLIENT) REFERENCES CLIENTS (CODE_CLIENT) )ENGINE = InnoDB; -- Structure de la table `DETAILS_COMMANDES` CREATE TABLE DETAILS_COMMANDES ( NO_COMMANDE int(6) NOT NULL, REF_PRODUIT int(6) NOT NULL, QUANTITE int(5) NOT NULL DEFAULT 1, PRIMARY KEY (NO_COMMANDE,REF_PRODUIT), FOREIGN KEY (NO_COMMANDE) REFERENCES COMMANDES (NO_COMMANDE), FOREIGN KEY (REF_PRODUIT) REFERENCES PRODUITS (REF_PRODUIT) )ENGINE = InnoDB; -- Contenu de la table `CLIENTS` INSERT INTO `CLIENTS` VALUES('ALFKI', 'Alfreds Futterkiste', 'Obere Str. 57', 'Berlin', '12209', 'Allemagne', 2); INSERT INTO `CLIENTS` VALUES('AROUT', 'Around the Horn', '120 Hanover Sq.', 'London', 'WA1 1DP', 'Royaume-Uni', 2); INSERT INTO `CLIENTS` VALUES('BLAUS', 'Blauer See Delikatessen', 'Forsterstr. 57', 'Mannheim', '68306', 'Allemagne', 2); INSERT INTO `CLIENTS` VALUES('BONAP', 'Bon app''', '12, rue des Bouchers', 'Marseille', '13008', 'France', 2); INSERT INTO `CLIENTS` VALUES('BOTTM', 'Bottom-Dollar Markets', '23 Tsawassen Blvd.', 'Tsawassen', 'T2F 8M4', 'Canada', 2); INSERT INTO `CLIENTS` VALUES('BSBEV', 'B''s Beverages', 'Fauntleroy Circus', 'London', 'EC2 5NT', 'Royaume-Uni', 3); INSERT INTO `CLIENTS` VALUES('CACTU', 'Cactus Comidas para llevar', 'Cerrito 333', 'Buenos Aires', '1010', 'Argentine', 2); INSERT INTO `CLIENTS` VALUES('CHOPS', 'Chop-suey Chinese', 'Hauptstr. 29', 'Bern', '3012', 'Suisse', 0); INSERT INTO `CLIENTS` VALUES('CONSH', 'Consolidated Holdings', 'Berkeley Gardens12 Brewery ', 'London', 'WX1 6LT', 'Royaume-Uni', 3); INSERT INTO `CLIENTS` VALUES('DRACD', 'Drachenblut Delikatessen', 'Walserweg 21', 'Aachen', '52066', 'Allemagne', 2); INSERT INTO `CLIENTS` VALUES('DUMON', 'Du monde entier', '67, rue des Cinquante Otages', 'Nantes', '44000', 'France', 2); INSERT INTO `CLIENTS` VALUES('EASTC', 'Eastern Connection', '35 King George', 'London', 'WX3 6FW', 'Royaume-Uni', 2); INSERT INTO `CLIENTS` VALUES('ERNSH', 'Ernst Handel', 'Kirchgasse 6', 'Graz', '8010', 'Autriche', 1); INSERT INTO `CLIENTS` VALUES('FISSA', 'FISSA Fabrica Inter. Salchichas S.A.', 'Moralzarzal, 86', 'Madrid', '28034', 'Espagne', 1); INSERT INTO `CLIENTS` VALUES('FRANR', 'France restauration', '54, rue Royale', 'Nantes', '44000', 'France', 3); INSERT INTO `CLIENTS` VALUES('FRANS', 'Franchi S.p.A.', 'Via Monte Bianco 34', 'Torino', '10100', 'Italie', 1); INSERT INTO `CLIENTS` VALUES('FURIB', 'Furia Bacalhau e Frutos do Mar', 'Jardim das rosas n. 32', 'Lisboa', '1675', 'Portugal', 1); INSERT INTO `CLIENTS` VALUES('GODOS', 'Godos Cocina Típica', 'Romero, 33', 'Sevilla', '41101', 'Espagne', 3); INSERT INTO `CLIENTS` VALUES('HUNGO', 'Hungry Owl All-Night Grocers', '8 Johnstown Road', 'Cork', '2506', 'Irlande', 3); INSERT INTO `CLIENTS` VALUES('ISLAT', 'Island Trading', 'Garden HouseCrowther Way', 'Cowes', 'PO31 7PJ', 'Royaume-Uni', 2); INSERT INTO `CLIENTS` VALUES('LACOR', 'La corne d''abondance', '67, avenue de l''Europe', 'Versailles', '78000', 'France', 2); INSERT INTO `CLIENTS` VALUES('LAMAI', 'La maison d''Asie', '1 rue Alsace-Lorraine', 'Toulouse', '31000', 'France', 2); INSERT INTO `CLIENTS` VALUES('LAUGB', 'Laughing Bacchus Wine Cellars', '1900 Oak St.', 'Vancouver', 'V3F 2K1', 'Canada', 2); INSERT INTO `CLIENTS` VALUES('LEHMS', 'Lehmanns Marktstand', 'Magazinweg 7', 'Frankfurt a.M. ', '60528', 'Allemagne', 1); INSERT INTO `CLIENTS` VALUES('MAGAA', 'Magazzini Alimentari Riuniti', 'Via Ludovico il Moro 22', 'Bergamo', '24100', 'Italie', 1); INSERT INTO `CLIENTS` VALUES('MAISD', 'Maison Dewey', 'Rue Joseph-Bens 532', 'Bruxelles', 'B-1180', 'Belgique', 0); INSERT INTO `CLIENTS` VALUES('MORGK', 'Morgenstern Gesundkost', 'Heerstr. 22', 'Leipzig', '04179', 'Allemagne', 0); INSERT INTO `CLIENTS` VALUES('NORTS', 'North/South', 'South House300 Queensbridge', 'London', 'SW7 1RZ', 'Royaume-Uni', 1); INSERT INTO `CLIENTS` VALUES('PICCO', 'Piccolo und mehr', 'Geislweg 14', 'Salzburg', '5020', 'Autriche', 2); INSERT INTO `CLIENTS` VALUES('RANCH', 'Rancho grande', 'Av. del Libertador 900', 'Buenos Aires', '1010', 'Argentine', 2); INSERT INTO `CLIENTS` VALUES('REGGC', 'Reggiani Caseifici', 'Strada Provinciale 124', 'Reggio Emilia', '42100', 'Italie', 1); INSERT INTO `CLIENTS` VALUES('SEVES', 'Seven Seas Imports', '90 Wadhurst Rd.', 'London', 'OX15 4NB', 'Royaume-Uni', 3); INSERT INTO `CLIENTS` VALUES('VICTE', 'Victuailles en stock', '2, rue du Commerce', 'Lyon', '69004', 'France', 2); INSERT INTO `CLIENTS` VALUES('VINET', 'Vins et alcools Chevalier', '59 rue de l''Abbaye', 'Reims', '51100', 'France', 1); INSERT INTO `CLIENTS` VALUES('WANDK', 'Die Wandernde Kuh', 'Adenauerallee 900', 'Stuttgart', '70563', 'Allemagne', 3); INSERT INTO `CLIENTS` VALUES('WARTH', 'Wartian Herkku', 'Torikatu 38', 'Oulu', '90110', 'Finlande', 2); INSERT INTO `CLIENTS` VALUES('WILMK', 'Wilman Kala', 'Keskuskatu 45', 'Helsinki', '21240', 'Finlande', 3); INSERT INTO `CLIENTS` VALUES('WOLZA', 'Wolski Zajazd', 'ul. Filtrowa 68', 'Warszawa', '01-012', 'Pologne', 1); -- Contenu de la table `PRODUITS` INSERT INTO `PRODUITS` VALUES(1, 'Chai', 90.00); INSERT INTO `PRODUITS` VALUES(2, 'Chang', 95.00); INSERT INTO `PRODUITS` VALUES(3, 'Aniseed Syrup', 50.00); INSERT INTO `PRODUITS` VALUES(4, 'Chef Anton''s Cajun Seasoning', 110.00); INSERT INTO `PRODUITS` VALUES(5, 'Chef Anton''s Gumbo Mix', 106.00); INSERT INTO `PRODUITS` VALUES(6, 'Grandma''s Boysenberry Spread', 125.00); INSERT INTO `PRODUITS` VALUES(7, 'Uncle Bob''s Organic Dried Pears', 150.00); INSERT INTO `PRODUITS` VALUES(8, 'Northwoods Cranberry Sauce', 200.00); INSERT INTO `PRODUITS` VALUES(9, 'Mishi Kobe Niku', 485.00); INSERT INTO `PRODUITS` VALUES(10, 'Ikura', 155.00); INSERT INTO `PRODUITS` VALUES(11, 'Queso Cabrales', 105.00); INSERT INTO `PRODUITS` VALUES(12, 'Queso Manchego La Pastora', 190.00); INSERT INTO `PRODUITS` VALUES(13, 'Konbu', 30.00); INSERT INTO `PRODUITS` VALUES(14, 'Tofu', 116.00); INSERT INTO `PRODUITS` VALUES(15, 'Genen Shouyu', 78.00); INSERT INTO `PRODUITS` VALUES(16, 'Pavlova', 87.00); INSERT INTO `PRODUITS` VALUES(17, 'Alice Mutton', 195.00); INSERT INTO `PRODUITS` VALUES(18, 'Carnarvon Tigers', 313.00); INSERT INTO `PRODUITS` VALUES(19, 'Teatime Chocolate Biscuits', 46.00); INSERT INTO `PRODUITS` VALUES(20, 'Sir Rodney''s Marmalade', 405.00); INSERT INTO `PRODUITS` VALUES(21, 'Sir Rodney''s Scones', 50.00); INSERT INTO `PRODUITS` VALUES(27, 'Schoggi Schokolade', 220.00); INSERT INTO `PRODUITS` VALUES(30, 'Nord-Ost Matjeshering', 129.00); INSERT INTO `PRODUITS` VALUES(31, 'Gorgonzola Telino', 63.00); INSERT INTO `PRODUITS` VALUES(32, 'Mascarpone Fabioli', 160.00); INSERT INTO `PRODUITS` VALUES(33, 'Geitost', 13.00); INSERT INTO `PRODUITS` VALUES(34, 'Sasquatch Ale', 70.00); INSERT INTO `PRODUITS` VALUES(35, 'Steeleye Stout', 90.00); INSERT INTO `PRODUITS` VALUES(36, 'Inlagd Sill', 95.00); INSERT INTO `PRODUITS` VALUES(37, 'Gravad lax', 130.00); INSERT INTO `PRODUITS` VALUES(39, 'Chartreuse verte', 90.00); INSERT INTO `PRODUITS` VALUES(40, 'Boston Crab Meat', 92.00); INSERT INTO `PRODUITS` VALUES(41, 'Jack''s New England Clam Chowder', 48.00); INSERT INTO `PRODUITS` VALUES(42, 'Singaporean Hokkien Fried Mee', 70.00); INSERT INTO `PRODUITS` VALUES(43, 'Ipoh Coffee', 230.00); INSERT INTO `PRODUITS` VALUES(44, 'Gula Malacca', 97.00); INSERT INTO `PRODUITS` VALUES(46, 'Spegesild', 60.00); INSERT INTO `PRODUITS` VALUES(47, 'Zaanse koeken', 48.00); INSERT INTO `PRODUITS` VALUES(48, 'Chocolade', 64.00); INSERT INTO `PRODUITS` VALUES(49, 'Maxilaku', 100.00); INSERT INTO `PRODUITS` VALUES(50, 'Valkoinen suklaa', 81.00); INSERT INTO `PRODUITS` VALUES(51, 'Manjimup Dried Apples', 265.00); INSERT INTO `PRODUITS` VALUES(52, 'Filo Mix', 35.00); INSERT INTO `PRODUITS` VALUES(53, 'Perth Pasties', 164.00); INSERT INTO `PRODUITS` VALUES(56, 'Gnocchi di nonna Alice', 190.00); INSERT INTO `PRODUITS` VALUES(57, 'Ravioli Angelo', 98.00); INSERT INTO `PRODUITS` VALUES(58, 'Escargots de Bourgogne', 66.00); INSERT INTO `PRODUITS` VALUES(59, 'Raclette Courdavault', 275.00); INSERT INTO `PRODUITS` VALUES(60, 'Camembert Pierrot', 170.00); INSERT INTO `PRODUITS` VALUES(62, 'Tarte au sucre', 247.00); INSERT INTO `PRODUITS` VALUES(63, 'Vegie-spread', 220.00); INSERT INTO `PRODUITS` VALUES(65, 'Louisiana Fiery Hot Pepper Sauce', 105.00); INSERT INTO `PRODUITS` VALUES(66, 'Louisiana Hot Spiced Okra', 85.00); INSERT INTO `PRODUITS` VALUES(67, 'Laughing Lumberjack Lager', 70.00); INSERT INTO `PRODUITS` VALUES(68, 'Scottish Longbreads', 63.00); INSERT INTO `PRODUITS` VALUES(69, 'Gudbrandsdalsost', 180.00); INSERT INTO `PRODUITS` VALUES(70, 'Outback Lager', 75.00); INSERT INTO `PRODUITS` VALUES(72, 'Mozzarella di Giovanni', 174.00); INSERT INTO `PRODUITS` VALUES(74, 'Longlife Tofu', 50.00); -- Contenu de la table `COMMANDES` INSERT INTO `COMMANDES` VALUES(10248, '2008-02-04', 'VINET'); INSERT INTO `COMMANDES` VALUES(10251, '2008-09-08', 'VICTE'); INSERT INTO `COMMANDES` VALUES(10254, '2008-05-11', 'CHOPS'); INSERT INTO `COMMANDES` VALUES(10258, '2008-07-17', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10263, '2008-03-23', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10266, '2008-11-26', 'WARTH'); INSERT INTO `COMMANDES` VALUES(10270, '2008-12-01', 'WARTH'); INSERT INTO `COMMANDES` VALUES(10274, '2008-12-06', 'VINET'); INSERT INTO `COMMANDES` VALUES(10275, '2008-10-07', 'MAGAA'); INSERT INTO `COMMANDES` VALUES(10277, '2008-10-09', 'MORGK'); INSERT INTO `COMMANDES` VALUES(10279, '2008-04-13', 'LEHMS'); INSERT INTO `COMMANDES` VALUES(10284, '2008-02-19', 'LEHMS'); INSERT INTO `COMMANDES` VALUES(10288, '2008-07-23', 'REGGC'); INSERT INTO `COMMANDES` VALUES(10289, '2008-02-26', 'BSBEV'); INSERT INTO `COMMANDES` VALUES(10295, '2008-01-02', 'VINET'); INSERT INTO `COMMANDES` VALUES(10298, '2008-08-05', 'HUNGO'); INSERT INTO `COMMANDES` VALUES(10300, '2008-10-09', 'MAGAA'); INSERT INTO `COMMANDES` VALUES(10301, '2008-03-09', 'WANDK'); INSERT INTO `COMMANDES` VALUES(10303, '2008-02-11', 'GODOS'); INSERT INTO `COMMANDES` VALUES(10309, '2008-12-19', 'HUNGO'); INSERT INTO `COMMANDES` VALUES(10311, '2008-10-20', 'DUMON'); INSERT INTO `COMMANDES` VALUES(10312, '2008-07-23', 'WANDK'); INSERT INTO `COMMANDES` VALUES(10315, '2008-03-26', 'ISLAT'); INSERT INTO `COMMANDES` VALUES(10318, '2008-08-01', 'ISLAT'); INSERT INTO `COMMANDES` VALUES(10320, '2008-02-03', 'WARTH'); INSERT INTO `COMMANDES` VALUES(10321, '2008-07-03', 'ISLAT'); INSERT INTO `COMMANDES` VALUES(10328, '2008-11-14', 'FURIB'); INSERT INTO `COMMANDES` VALUES(10331, '2008-04-16', 'BONAP'); INSERT INTO `COMMANDES` VALUES(10333, '2008-07-18', 'WARTH'); INSERT INTO `COMMANDES` VALUES(10334, '2008-05-21', 'VICTE'); INSERT INTO `COMMANDES` VALUES(10335, '2008-07-22', 'HUNGO'); INSERT INTO `COMMANDES` VALUES(10340, '2008-12-29', 'BONAP'); INSERT INTO `COMMANDES` VALUES(10343, '2008-01-31', 'LEHMS'); INSERT INTO `COMMANDES` VALUES(10348, '2008-03-07', 'WANDK'); INSERT INTO `COMMANDES` VALUES(10350, '2008-12-11', 'LAMAI'); INSERT INTO `COMMANDES` VALUES(10351, '2008-12-11', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10352, '2008-12-12', 'FURIB'); INSERT INTO `COMMANDES` VALUES(10353, '2008-12-13', 'PICCO'); INSERT INTO `COMMANDES` VALUES(10355, '2008-03-15', 'AROUT'); INSERT INTO `COMMANDES` VALUES(10356, '2008-09-18', 'WANDK'); INSERT INTO `COMMANDES` VALUES(10358, '2008-08-20', 'LAMAI'); INSERT INTO `COMMANDES` VALUES(10359, '2008-07-21', 'SEVES'); INSERT INTO `COMMANDES` VALUES(10362, '2008-05-25', 'BONAP'); INSERT INTO `COMMANDES` VALUES(10363, '2008-05-26', 'DRACD'); INSERT INTO `COMMANDES` VALUES(10364, '2008-03-26', 'EASTC'); INSERT INTO `COMMANDES` VALUES(10368, '2008-10-29', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10370, '2008-02-03', 'CHOPS'); INSERT INTO `COMMANDES` VALUES(10371, '2008-09-03', 'LAMAI'); INSERT INTO `COMMANDES` VALUES(10373, '2008-06-05', 'HUNGO'); INSERT INTO `COMMANDES` VALUES(10374, '2008-08-05', 'WOLZA'); INSERT INTO `COMMANDES` VALUES(10377, '2008-08-09', 'SEVES'); INSERT INTO `COMMANDES` VALUES(10380, '2008-03-12', 'HUNGO'); INSERT INTO `COMMANDES` VALUES(10382, '2008-08-13', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10383, '2008-03-16', 'AROUT'); INSERT INTO `COMMANDES` VALUES(10388, '2008-12-19', 'SEVES'); INSERT INTO `COMMANDES` VALUES(10389, '2008-08-20', 'BOTTM'); INSERT INTO `COMMANDES` VALUES(10390, '2008-12-23', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10391, '2008-08-23', 'DRACD'); INSERT INTO `COMMANDES` VALUES(10392, '2008-03-24', 'PICCO'); INSERT INTO `COMMANDES` VALUES(10400, '2009-10-01', 'EASTC'); INSERT INTO `COMMANDES` VALUES(10402, '2009-05-02', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10403, '2009-01-03', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10404, '2009-11-03', 'MAGAA'); INSERT INTO `COMMANDES` VALUES(10410, '2009-03-10', 'BOTTM'); INSERT INTO `COMMANDES` VALUES(10411, '2009-03-10', 'BOTTM'); INSERT INTO `COMMANDES` VALUES(10412, '2009-10-13', 'WARTH'); INSERT INTO `COMMANDES` VALUES(10413, '2009-10-14', 'LAMAI'); INSERT INTO `COMMANDES` VALUES(10416, '2009-06-16', 'WARTH'); INSERT INTO `COMMANDES` VALUES(10422, '2009-02-22', 'FRANS'); INSERT INTO `COMMANDES` VALUES(10425, '2009-06-24', 'LAMAI'); INSERT INTO `COMMANDES` VALUES(10427, '2009-10-27', 'PICCO'); INSERT INTO `COMMANDES` VALUES(10428, '2009-08-28', 'REGGC'); INSERT INTO `COMMANDES` VALUES(10429, '2009-10-29', 'HUNGO'); INSERT INTO `COMMANDES` VALUES(10430, '0000-00-00', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10431, '2009-10-30', 'BOTTM'); INSERT INTO `COMMANDES` VALUES(10435, '2009-09-04', 'CONSH'); INSERT INTO `COMMANDES` VALUES(10437, '2009-03-05', 'WARTH'); INSERT INTO `COMMANDES` VALUES(10442, '2009-03-11', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10443, '2009-08-12', 'REGGC'); INSERT INTO `COMMANDES` VALUES(10448, '2009-08-17', 'RANCH'); INSERT INTO `COMMANDES` VALUES(10450, '2009-10-19', 'VICTE'); INSERT INTO `COMMANDES` VALUES(10453, '2009-07-21', 'AROUT'); INSERT INTO `COMMANDES` VALUES(10454, '2009-09-21', 'LAMAI'); INSERT INTO `COMMANDES` VALUES(10455, '2009-12-24', 'WARTH'); INSERT INTO `COMMANDES` VALUES(10459, '2009-07-27', 'VICTE'); INSERT INTO `COMMANDES` VALUES(10462, '2009-12-03', 'CONSH'); INSERT INTO `COMMANDES` VALUES(10464, '2009-07-04', 'FURIB'); INSERT INTO `COMMANDES` VALUES(10467, '2009-07-06', 'MAGAA'); INSERT INTO `COMMANDES` VALUES(10470, '2009-01-11', 'BONAP'); INSERT INTO `COMMANDES` VALUES(10471, '2009-12-11', 'BSBEV'); INSERT INTO `COMMANDES` VALUES(10472, '2009-05-12', 'SEVES'); INSERT INTO `COMMANDES` VALUES(10473, '2009-12-13', 'ISLAT'); INSERT INTO `COMMANDES` VALUES(10478, '2009-08-18', 'VICTE'); INSERT INTO `COMMANDES` VALUES(10484, '2009-04-24', 'BSBEV'); INSERT INTO `COMMANDES` VALUES(10489, '2009-03-28', 'PICCO'); INSERT INTO `COMMANDES` VALUES(10491, '2009-05-31', 'FURIB'); INSERT INTO `COMMANDES` VALUES(10492, '2009-01-01', 'BOTTM'); INSERT INTO `COMMANDES` VALUES(10493, '2009-04-02', 'LAMAI'); INSERT INTO `COMMANDES` VALUES(10495, '2009-03-03', 'LAUGB'); INSERT INTO `COMMANDES` VALUES(10497, '2009-04-04', 'LEHMS'); INSERT INTO `COMMANDES` VALUES(10500, '2009-12-09', 'LAMAI'); INSERT INTO `COMMANDES` VALUES(10501, '2009-06-09', 'BLAUS'); INSERT INTO `COMMANDES` VALUES(10503, '2009-06-11', 'HUNGO'); INSERT INTO `COMMANDES` VALUES(10509, '2009-02-17', 'BLAUS'); INSERT INTO `COMMANDES` VALUES(10511, '2009-09-18', 'BONAP'); INSERT INTO `COMMANDES` VALUES(10513, '2009-03-22', 'WANDK'); INSERT INTO `COMMANDES` VALUES(10514, '2009-05-22', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10516, '2009-08-24', 'HUNGO'); INSERT INTO `COMMANDES` VALUES(10517, '2009-07-24', 'NORTS'); INSERT INTO `COMMANDES` VALUES(10519, '2009-04-28', 'CHOPS'); INSERT INTO `COMMANDES` VALUES(10521, '2009-10-29', 'CACTU'); INSERT INTO `COMMANDES` VALUES(10522, '2009-08-30', 'LEHMS'); INSERT INTO `COMMANDES` VALUES(10523, '2009-03-01', 'SEVES'); INSERT INTO `COMMANDES` VALUES(10525, '2009-10-02', 'BONAP'); INSERT INTO `COMMANDES` VALUES(10526, '2009-04-05', 'WARTH'); INSERT INTO `COMMANDES` VALUES(10529, '2009-07-07', 'MAISD'); INSERT INTO `COMMANDES` VALUES(10530, '2009-10-08', 'PICCO'); INSERT INTO `COMMANDES` VALUES(10532, '2009-03-09', 'EASTC'); INSERT INTO `COMMANDES` VALUES(10534, '2009-09-12', 'LEHMS'); INSERT INTO `COMMANDES` VALUES(10536, '2009-09-14', 'LEHMS'); INSERT INTO `COMMANDES` VALUES(10538, '2009-03-15', 'BSBEV'); INSERT INTO `COMMANDES` VALUES(10539, '2009-12-16', 'BSBEV'); INSERT INTO `COMMANDES` VALUES(10546, '2009-05-23', 'VICTE'); INSERT INTO `COMMANDES` VALUES(10547, '2009-05-23', 'SEVES'); INSERT INTO `COMMANDES` VALUES(10550, '2009-08-28', 'GODOS'); INSERT INTO `COMMANDES` VALUES(10551, '2009-02-28', 'FURIB'); INSERT INTO `COMMANDES` VALUES(10553, '2009-11-30', 'WARTH'); INSERT INTO `COMMANDES` VALUES(10557, '2009-11-03', 'LEHMS'); INSERT INTO `COMMANDES` VALUES(10558, '2009-09-04', 'AROUT'); INSERT INTO `COMMANDES` VALUES(10562, '2009-09-09', 'REGGC'); INSERT INTO `COMMANDES` VALUES(10567, '2009-11-12', 'HUNGO'); INSERT INTO `COMMANDES` VALUES(10571, '2009-11-17', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10575, '2009-11-20', 'MORGK'); INSERT INTO `COMMANDES` VALUES(10578, '2009-03-24', 'BSBEV'); INSERT INTO `COMMANDES` VALUES(10582, '2009-12-27', 'BLAUS'); INSERT INTO `COMMANDES` VALUES(10583, '2009-08-30', 'WARTH'); INSERT INTO `COMMANDES` VALUES(10586, '2009-03-02', 'REGGC'); INSERT INTO `COMMANDES` VALUES(10592, '2009-01-08', 'LEHMS'); INSERT INTO `COMMANDES` VALUES(10593, '2009-02-09', 'LEHMS'); INSERT INTO `COMMANDES` VALUES(10595, '2009-07-10', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10597, '2009-06-11', 'PICCO'); INSERT INTO `COMMANDES` VALUES(10599, '2009-03-15', 'BSBEV'); INSERT INTO `COMMANDES` VALUES(10604, '2009-06-18', 'FURIB'); INSERT INTO `COMMANDES` VALUES(10609, '2009-11-24', 'DUMON'); INSERT INTO `COMMANDES` VALUES(10610, '2009-01-25', 'LAMAI'); INSERT INTO `COMMANDES` VALUES(10611, '2009-08-25', 'WOLZA'); INSERT INTO `COMMANDES` VALUES(10614, '2009-10-29', 'BLAUS'); INSERT INTO `COMMANDES` VALUES(10615, '2009-04-30', 'WILMK'); INSERT INTO `COMMANDES` VALUES(10620, '2009-07-05', 'LAUGB'); INSERT INTO `COMMANDES` VALUES(10621, '2009-01-05', 'ISLAT'); INSERT INTO `COMMANDES` VALUES(10629, '2009-10-12', 'GODOS'); INSERT INTO `COMMANDES` VALUES(10631, '2009-06-14', 'LAMAI'); INSERT INTO `COMMANDES` VALUES(10632, '2009-10-14', 'WANDK'); INSERT INTO `COMMANDES` VALUES(10633, '2009-10-15', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10635, '2009-04-18', 'MAGAA'); INSERT INTO `COMMANDES` VALUES(10636, '2009-06-19', 'WARTH'); INSERT INTO `COMMANDES` VALUES(10640, '2009-04-21', 'WANDK'); INSERT INTO `COMMANDES` VALUES(10643, '2009-03-25', 'AROUT'); INSERT INTO `COMMANDES` VALUES(10646, '2009-12-27', 'HUNGO'); INSERT INTO `COMMANDES` VALUES(10649, '2009-02-28', 'MAISD'); INSERT INTO `COMMANDES` VALUES(10651, '2009-05-01', 'WANDK'); INSERT INTO `COMMANDES` VALUES(10655, '2009-08-03', 'REGGC'); INSERT INTO `COMMANDES` VALUES(10661, '2009-06-09', 'HUNGO'); INSERT INTO `COMMANDES` VALUES(10663, '2009-11-10', 'BONAP'); INSERT INTO `COMMANDES` VALUES(10664, '2009-10-10', 'FURIB'); INSERT INTO `COMMANDES` VALUES(10667, '2009-03-12', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10668, '2009-08-15', 'WANDK'); INSERT INTO `COMMANDES` VALUES(10671, '2009-06-17', 'FRANR'); INSERT INTO `COMMANDES` VALUES(10673, '2009-05-18', 'WILMK'); INSERT INTO `COMMANDES` VALUES(10674, '2009-05-18', 'ISLAT'); INSERT INTO `COMMANDES` VALUES(10683, '2009-03-26', 'DUMON'); INSERT INTO `COMMANDES` VALUES(10686, '2009-12-30', 'PICCO'); INSERT INTO `COMMANDES` VALUES(10687, '2009-07-30', 'HUNGO'); INSERT INTO `COMMANDES` VALUES(10692, '2009-04-03', 'BSBEV'); INSERT INTO `COMMANDES` VALUES(10695, '2009-03-07', 'WILMK'); INSERT INTO `COMMANDES` VALUES(10698, '2009-08-09', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10699, '2009-09-09', 'MORGK'); INSERT INTO `COMMANDES` VALUES(10701, '2009-09-13', 'HUNGO'); INSERT INTO `COMMANDES` VALUES(10702, '2009-11-13', 'ALFKI'); INSERT INTO `COMMANDES` VALUES(10707, '2009-03-16', 'AROUT'); INSERT INTO `COMMANDES` VALUES(10710, '2009-01-20', 'FRANS'); INSERT INTO `COMMANDES` VALUES(10712, '2009-06-21', 'HUNGO'); INSERT INTO `COMMANDES` VALUES(10715, '2009-04-23', 'BONAP'); INSERT INTO `COMMANDES` VALUES(10716, '2009-10-24', 'RANCH'); INSERT INTO `COMMANDES` VALUES(10726, '2009-01-03', 'EASTC'); INSERT INTO `COMMANDES` VALUES(10727, '2009-10-03', 'REGGC'); INSERT INTO `COMMANDES` VALUES(10730, '2009-05-05', 'BONAP'); INSERT INTO `COMMANDES` VALUES(10731, '2009-03-06', 'CHOPS'); INSERT INTO `COMMANDES` VALUES(10732, '2009-12-06', 'BONAP'); INSERT INTO `COMMANDES` VALUES(10736, '2009-07-11', 'HUNGO'); INSERT INTO `COMMANDES` VALUES(10737, '2009-06-11', 'VINET'); INSERT INTO `COMMANDES` VALUES(10739, '2009-08-12', 'VINET'); INSERT INTO `COMMANDES` VALUES(10741, '2009-09-14', 'AROUT'); INSERT INTO `COMMANDES` VALUES(10742, '2009-07-14', 'BOTTM'); INSERT INTO `COMMANDES` VALUES(10743, '2009-02-17', 'AROUT'); INSERT INTO `COMMANDES` VALUES(10746, '2009-01-19', 'CHOPS'); INSERT INTO `COMMANDES` VALUES(10747, '2009-04-19', 'PICCO'); INSERT INTO `COMMANDES` VALUES(10749, '2009-07-20', 'ISLAT'); INSERT INTO `COMMANDES` VALUES(10750, '2009-08-21', 'WARTH'); INSERT INTO `COMMANDES` VALUES(10752, '2009-09-24', 'NORTS'); INSERT INTO `COMMANDES` VALUES(10753, '2009-02-25', 'FRANS'); INSERT INTO `COMMANDES` VALUES(10754, '2009-04-25', 'MAGAA'); INSERT INTO `COMMANDES` VALUES(10755, '2009-02-26', 'BONAP'); INSERT INTO `COMMANDES` VALUES(10760, '2009-05-01', 'MAISD'); INSERT INTO `COMMANDES` VALUES(10764, '2009-04-03', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10768, '2009-05-08', 'AROUT'); INSERT INTO `COMMANDES` VALUES(10771, '2009-04-10', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10772, '2009-07-10', 'LEHMS'); INSERT INTO `COMMANDES` VALUES(10773, '2009-03-11', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10776, '2009-12-15', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10779, '2009-01-16', 'MORGK'); INSERT INTO `COMMANDES` VALUES(10781, '2009-09-17', 'WARTH'); INSERT INTO `COMMANDES` VALUES(10782, '2009-12-17', 'CACTU'); INSERT INTO `COMMANDES` VALUES(10784, '2009-11-18', 'MAGAA'); INSERT INTO `COMMANDES` VALUES(10787, '2009-02-19', 'LAMAI'); INSERT INTO `COMMANDES` VALUES(10792, '2009-08-23', 'WOLZA'); INSERT INTO `COMMANDES` VALUES(10793, '2009-05-24', 'AROUT'); INSERT INTO `COMMANDES` VALUES(10795, '2009-10-24', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10797, '2009-04-25', 'DRACD'); INSERT INTO `COMMANDES` VALUES(10798, '2009-10-26', 'ISLAT'); INSERT INTO `COMMANDES` VALUES(10800, '2009-12-26', 'SEVES'); INSERT INTO `COMMANDES` VALUES(10804, '2009-10-30', 'SEVES'); INSERT INTO `COMMANDES` VALUES(10806, '2009-12-31', 'VICTE'); INSERT INTO `COMMANDES` VALUES(10807, '2009-05-31', 'FRANS'); INSERT INTO `COMMANDES` VALUES(10810, '2010-06-01', 'LAUGB'); INSERT INTO `COMMANDES` VALUES(10812, '2010-05-02', 'REGGC'); INSERT INTO `COMMANDES` VALUES(10814, '2010-11-05', 'VICTE'); INSERT INTO `COMMANDES` VALUES(10818, '2010-09-07', 'MAGAA'); INSERT INTO `COMMANDES` VALUES(10819, '2010-10-07', 'CACTU'); INSERT INTO `COMMANDES` VALUES(10825, '2010-05-09', 'DRACD'); INSERT INTO `COMMANDES` VALUES(10827, '2010-03-12', 'BONAP'); INSERT INTO `COMMANDES` VALUES(10828, '2010-08-13', 'RANCH'); INSERT INTO `COMMANDES` VALUES(10829, '2010-08-13', 'ISLAT'); INSERT INTO `COMMANDES` VALUES(10832, '2010-12-14', 'LAMAI'); INSERT INTO `COMMANDES` VALUES(10835, '2010-03-15', 'ALFKI'); INSERT INTO `COMMANDES` VALUES(10836, '2010-11-16', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10843, '2010-01-21', 'VICTE'); INSERT INTO `COMMANDES` VALUES(10844, '2010-03-21', 'PICCO'); INSERT INTO `COMMANDES` VALUES(10848, '2010-12-23', 'CONSH'); INSERT INTO `COMMANDES` VALUES(10850, '2010-08-23', 'VICTE'); INSERT INTO `COMMANDES` VALUES(10853, '2010-12-27', 'BLAUS'); INSERT INTO `COMMANDES` VALUES(10854, '2010-10-27', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10858, '2010-06-29', 'LACOR'); INSERT INTO `COMMANDES` VALUES(10860, '2010-03-29', 'FRANR'); INSERT INTO `COMMANDES` VALUES(10862, '2010-01-30', 'LEHMS'); INSERT INTO `COMMANDES` VALUES(10864, '2010-05-02', 'AROUT'); INSERT INTO `COMMANDES` VALUES(10869, '2010-08-04', 'SEVES'); INSERT INTO `COMMANDES` VALUES(10870, '2010-04-04', 'WOLZA'); INSERT INTO `COMMANDES` VALUES(10871, '2010-06-05', 'BONAP'); INSERT INTO `COMMANDES` VALUES(10872, '2010-08-05', 'GODOS'); INSERT INTO `COMMANDES` VALUES(10873, '2010-12-06', 'WILMK'); INSERT INTO `COMMANDES` VALUES(10874, '2010-09-06', 'GODOS'); INSERT INTO `COMMANDES` VALUES(10876, '2010-11-09', 'BONAP'); INSERT INTO `COMMANDES` VALUES(10879, '2010-10-10', 'WILMK'); INSERT INTO `COMMANDES` VALUES(10881, '2010-07-11', 'CACTU'); INSERT INTO `COMMANDES` VALUES(10888, '2010-10-16', 'GODOS'); INSERT INTO `COMMANDES` VALUES(10890, '2010-12-16', 'DUMON'); INSERT INTO `COMMANDES` VALUES(10891, '2010-07-17', 'LEHMS'); INSERT INTO `COMMANDES` VALUES(10892, '2010-03-17', 'MAISD'); INSERT INTO `COMMANDES` VALUES(10895, '2010-06-18', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10896, '2010-10-19', 'MAISD'); INSERT INTO `COMMANDES` VALUES(10897, '2010-10-19', 'HUNGO'); INSERT INTO `COMMANDES` VALUES(10906, '2010-09-25', 'WOLZA'); INSERT INTO `COMMANDES` VALUES(10908, '2010-08-26', 'REGGC'); INSERT INTO `COMMANDES` VALUES(10910, '2010-10-26', 'WILMK'); INSERT INTO `COMMANDES` VALUES(10911, '2010-04-26', 'GODOS'); INSERT INTO `COMMANDES` VALUES(10912, '2010-05-26', 'HUNGO'); INSERT INTO `COMMANDES` VALUES(10916, '2010-11-27', 'RANCH'); INSERT INTO `COMMANDES` VALUES(10918, '2010-10-02', 'BOTTM'); INSERT INTO `COMMANDES` VALUES(10920, '2010-10-03', 'AROUT'); INSERT INTO `COMMANDES` VALUES(10923, '2010-03-03', 'LAMAI'); INSERT INTO `COMMANDES` VALUES(10927, '2010-11-05', 'LACOR'); INSERT INTO `COMMANDES` VALUES(10932, '2010-06-06', 'BONAP'); INSERT INTO `COMMANDES` VALUES(10933, '2010-05-06', 'ISLAT'); INSERT INTO `COMMANDES` VALUES(10934, '2010-10-09', 'LEHMS'); INSERT INTO `COMMANDES` VALUES(10937, '2010-11-10', 'CACTU'); INSERT INTO `COMMANDES` VALUES(10939, '2010-02-10', 'MAGAA'); INSERT INTO `COMMANDES` VALUES(10940, '2010-06-11', 'BONAP'); INSERT INTO `COMMANDES` VALUES(10942, '2010-04-11', 'REGGC'); INSERT INTO `COMMANDES` VALUES(10943, '2010-07-11', 'BSBEV'); INSERT INTO `COMMANDES` VALUES(10944, '2010-04-12', 'BOTTM'); INSERT INTO `COMMANDES` VALUES(10945, '2010-05-12', 'MORGK'); INSERT INTO `COMMANDES` VALUES(10947, '2010-09-13', 'BSBEV'); INSERT INTO `COMMANDES` VALUES(10948, '2010-11-13', 'GODOS'); INSERT INTO `COMMANDES` VALUES(10949, '2010-02-13', 'BOTTM'); INSERT INTO `COMMANDES` VALUES(10950, '2010-09-16', 'MAGAA'); INSERT INTO `COMMANDES` VALUES(10952, '2010-06-16', 'ALFKI'); INSERT INTO `COMMANDES` VALUES(10953, '2010-01-16', 'AROUT'); INSERT INTO `COMMANDES` VALUES(10956, '2010-11-17', 'BLAUS'); INSERT INTO `COMMANDES` VALUES(10963, '2010-03-19', 'FURIB'); INSERT INTO `COMMANDES` VALUES(10966, '2010-09-20', 'CHOPS'); INSERT INTO `COMMANDES` VALUES(10968, '2010-03-23', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10971, '2010-08-24', 'FRANR'); INSERT INTO `COMMANDES` VALUES(10972, '2010-03-24', 'LACOR'); INSERT INTO `COMMANDES` VALUES(10973, '2010-11-24', 'LACOR'); INSERT INTO `COMMANDES` VALUES(10975, '2010-10-25', 'BOTTM'); INSERT INTO `COMMANDES` VALUES(10978, '2010-12-26', 'MAISD'); INSERT INTO `COMMANDES` VALUES(10979, '2010-12-26', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10982, '2010-04-27', 'BOTTM'); INSERT INTO `COMMANDES` VALUES(10985, '2010-04-30', 'HUNGO'); INSERT INTO `COMMANDES` VALUES(10987, '2010-08-31', 'EASTC'); INSERT INTO `COMMANDES` VALUES(10990, '2010-08-01', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(10998, '2010-10-03', 'WOLZA'); INSERT INTO `COMMANDES` VALUES(11004, '2010-09-07', 'MAISD'); INSERT INTO `COMMANDES` VALUES(11005, '2010-04-07', 'WILMK'); INSERT INTO `COMMANDES` VALUES(11008, '2010-11-08', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(11009, '2010-09-08', 'GODOS'); INSERT INTO `COMMANDES` VALUES(11010, '2010-04-09', 'REGGC'); INSERT INTO `COMMANDES` VALUES(11011, '2010-05-09', 'ALFKI'); INSERT INTO `COMMANDES` VALUES(11016, '2010-02-10', 'AROUT'); INSERT INTO `COMMANDES` VALUES(11017, '2010-06-13', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(11019, '2010-02-13', 'RANCH'); INSERT INTO `COMMANDES` VALUES(11023, '2010-03-14', 'BSBEV'); INSERT INTO `COMMANDES` VALUES(11024, '2010-07-15', 'EASTC'); INSERT INTO `COMMANDES` VALUES(11025, '2010-02-15', 'WARTH'); INSERT INTO `COMMANDES` VALUES(11026, '2010-08-15', 'FRANS'); INSERT INTO `COMMANDES` VALUES(11027, '2010-01-16', 'BOTTM'); INSERT INTO `COMMANDES` VALUES(11029, '2010-11-16', 'CHOPS'); INSERT INTO `COMMANDES` VALUES(11036, '2010-03-20', 'DRACD'); INSERT INTO `COMMANDES` VALUES(11037, '2010-05-21', 'GODOS'); INSERT INTO `COMMANDES` VALUES(11041, '2010-12-22', 'CHOPS'); INSERT INTO `COMMANDES` VALUES(11044, '2010-03-23', 'WOLZA'); INSERT INTO `COMMANDES` VALUES(11045, '2010-09-23', 'BOTTM'); INSERT INTO `COMMANDES` VALUES(11046, '2010-04-23', 'WANDK'); INSERT INTO `COMMANDES` VALUES(11047, '2010-12-24', 'EASTC'); INSERT INTO `COMMANDES` VALUES(11048, '2010-09-24', 'BOTTM'); INSERT INTO `COMMANDES` VALUES(11051, '2010-07-27', 'LAMAI'); INSERT INTO `COMMANDES` VALUES(11053, '2010-07-27', 'PICCO'); INSERT INTO `COMMANDES` VALUES(11054, '2010-03-28', 'CACTU'); INSERT INTO `COMMANDES` VALUES(11056, '2010-10-28', 'EASTC'); INSERT INTO `COMMANDES` VALUES(11057, '2010-08-29', 'NORTS'); INSERT INTO `COMMANDES` VALUES(11058, '2010-10-29', 'BLAUS'); INSERT INTO `COMMANDES` VALUES(11060, '0000-00-00', 'FRANS'); INSERT INTO `COMMANDES` VALUES(11062, '2010-07-30', 'REGGC'); INSERT INTO `COMMANDES` VALUES(11063, '2010-07-30', 'HUNGO'); INSERT INTO `COMMANDES` VALUES(11067, '2010-06-04', 'DRACD'); INSERT INTO `COMMANDES` VALUES(11070, '2010-08-05', 'LEHMS'); INSERT INTO `COMMANDES` VALUES(11072, '2010-11-05', 'ERNSH'); INSERT INTO `COMMANDES` VALUES(11076, '2010-08-06', 'BONAP'); -- Contenu de la table `DETAILS_COMMANDES` INSERT INTO `DETAILS_COMMANDES` VALUES(10248, 11, 12); INSERT INTO `DETAILS_COMMANDES` VALUES(10248, 42, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10248, 72, 5); INSERT INTO `DETAILS_COMMANDES` VALUES(10251, 57, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10251, 65, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10254, 74, 21); INSERT INTO `DETAILS_COMMANDES` VALUES(10258, 2, 50); INSERT INTO `DETAILS_COMMANDES` VALUES(10258, 5, 65); INSERT INTO `DETAILS_COMMANDES` VALUES(10258, 32, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10263, 16, 60); INSERT INTO `DETAILS_COMMANDES` VALUES(10263, 30, 60); INSERT INTO `DETAILS_COMMANDES` VALUES(10263, 74, 36); INSERT INTO `DETAILS_COMMANDES` VALUES(10266, 12, 12); INSERT INTO `DETAILS_COMMANDES` VALUES(10270, 36, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10270, 43, 25); INSERT INTO `DETAILS_COMMANDES` VALUES(10274, 72, 7); INSERT INTO `DETAILS_COMMANDES` VALUES(10275, 59, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10277, 62, 12); INSERT INTO `DETAILS_COMMANDES` VALUES(10279, 17, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10284, 27, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10284, 44, 21); INSERT INTO `DETAILS_COMMANDES` VALUES(10284, 60, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10284, 67, 5); INSERT INTO `DETAILS_COMMANDES` VALUES(10288, 68, 3); INSERT INTO `DETAILS_COMMANDES` VALUES(10289, 3, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10295, 56, 4); INSERT INTO `DETAILS_COMMANDES` VALUES(10298, 2, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10298, 36, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10298, 59, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10298, 62, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10300, 66, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10300, 68, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10301, 40, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10301, 56, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10303, 40, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10303, 65, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10303, 68, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10309, 4, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10309, 6, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10309, 42, 2); INSERT INTO `DETAILS_COMMANDES` VALUES(10309, 43, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10311, 42, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10311, 69, 7); INSERT INTO `DETAILS_COMMANDES` VALUES(10312, 43, 24); INSERT INTO `DETAILS_COMMANDES` VALUES(10312, 53, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10315, 34, 14); INSERT INTO `DETAILS_COMMANDES` VALUES(10315, 70, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10318, 41, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10321, 35, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10328, 59, 9); INSERT INTO `DETAILS_COMMANDES` VALUES(10328, 65, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10328, 68, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10333, 14, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10333, 21, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10334, 52, 8); INSERT INTO `DETAILS_COMMANDES` VALUES(10334, 68, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10335, 2, 7); INSERT INTO `DETAILS_COMMANDES` VALUES(10335, 31, 25); INSERT INTO `DETAILS_COMMANDES` VALUES(10335, 32, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10335, 51, 48); INSERT INTO `DETAILS_COMMANDES` VALUES(10340, 18, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10340, 41, 12); INSERT INTO `DETAILS_COMMANDES` VALUES(10340, 43, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10343, 68, 4); INSERT INTO `DETAILS_COMMANDES` VALUES(10348, 1, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10350, 50, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10350, 69, 18); INSERT INTO `DETAILS_COMMANDES` VALUES(10351, 41, 13); INSERT INTO `DETAILS_COMMANDES` VALUES(10351, 44, 77); INSERT INTO `DETAILS_COMMANDES` VALUES(10351, 65, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10353, 11, 12); INSERT INTO `DETAILS_COMMANDES` VALUES(10355, 57, 25); INSERT INTO `DETAILS_COMMANDES` VALUES(10356, 31, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10356, 69, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10358, 34, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10358, 36, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10359, 16, 56); INSERT INTO `DETAILS_COMMANDES` VALUES(10359, 31, 70); INSERT INTO `DETAILS_COMMANDES` VALUES(10359, 60, 80); INSERT INTO `DETAILS_COMMANDES` VALUES(10362, 51, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10363, 31, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10364, 69, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10368, 21, 5); INSERT INTO `DETAILS_COMMANDES` VALUES(10368, 57, 25); INSERT INTO `DETAILS_COMMANDES` VALUES(10370, 1, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10370, 74, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10371, 36, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10373, 58, 80); INSERT INTO `DETAILS_COMMANDES` VALUES(10374, 31, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10374, 58, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10377, 39, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10380, 30, 18); INSERT INTO `DETAILS_COMMANDES` VALUES(10380, 53, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10380, 60, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10380, 70, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10382, 5, 32); INSERT INTO `DETAILS_COMMANDES` VALUES(10382, 18, 9); INSERT INTO `DETAILS_COMMANDES` VALUES(10382, 33, 60); INSERT INTO `DETAILS_COMMANDES` VALUES(10382, 74, 50); INSERT INTO `DETAILS_COMMANDES` VALUES(10383, 13, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10383, 50, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10383, 56, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10388, 52, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10388, 53, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10389, 10, 16); INSERT INTO `DETAILS_COMMANDES` VALUES(10389, 62, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10389, 70, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10390, 31, 60); INSERT INTO `DETAILS_COMMANDES` VALUES(10390, 35, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10390, 46, 45); INSERT INTO `DETAILS_COMMANDES` VALUES(10390, 72, 24); INSERT INTO `DETAILS_COMMANDES` VALUES(10391, 13, 18); INSERT INTO `DETAILS_COMMANDES` VALUES(10392, 69, 50); INSERT INTO `DETAILS_COMMANDES` VALUES(10400, 35, 35); INSERT INTO `DETAILS_COMMANDES` VALUES(10400, 49, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10402, 63, 65); INSERT INTO `DETAILS_COMMANDES` VALUES(10403, 16, 21); INSERT INTO `DETAILS_COMMANDES` VALUES(10403, 48, 70); INSERT INTO `DETAILS_COMMANDES` VALUES(10404, 42, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10404, 49, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10410, 33, 49); INSERT INTO `DETAILS_COMMANDES` VALUES(10410, 59, 16); INSERT INTO `DETAILS_COMMANDES` VALUES(10411, 41, 25); INSERT INTO `DETAILS_COMMANDES` VALUES(10411, 44, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10411, 59, 9); INSERT INTO `DETAILS_COMMANDES` VALUES(10412, 14, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10413, 1, 24); INSERT INTO `DETAILS_COMMANDES` VALUES(10413, 62, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10416, 19, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10416, 53, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10416, 57, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10427, 14, 35); INSERT INTO `DETAILS_COMMANDES` VALUES(10428, 46, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10429, 50, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10429, 63, 35); INSERT INTO `DETAILS_COMMANDES` VALUES(10430, 17, 45); INSERT INTO `DETAILS_COMMANDES` VALUES(10430, 21, 50); INSERT INTO `DETAILS_COMMANDES` VALUES(10430, 56, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10430, 59, 70); INSERT INTO `DETAILS_COMMANDES` VALUES(10431, 17, 50); INSERT INTO `DETAILS_COMMANDES` VALUES(10431, 40, 50); INSERT INTO `DETAILS_COMMANDES` VALUES(10431, 47, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10435, 2, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10435, 72, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10437, 53, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10442, 11, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10442, 66, 60); INSERT INTO `DETAILS_COMMANDES` VALUES(10443, 11, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10448, 40, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10450, 10, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10453, 48, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10453, 70, 25); INSERT INTO `DETAILS_COMMANDES` VALUES(10454, 16, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10454, 33, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10454, 46, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10455, 39, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10455, 53, 50); INSERT INTO `DETAILS_COMMANDES` VALUES(10459, 7, 16); INSERT INTO `DETAILS_COMMANDES` VALUES(10459, 46, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10459, 72, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10462, 13, 1); INSERT INTO `DETAILS_COMMANDES` VALUES(10464, 4, 16); INSERT INTO `DETAILS_COMMANDES` VALUES(10464, 43, 3); INSERT INTO `DETAILS_COMMANDES` VALUES(10464, 56, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10464, 60, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10470, 18, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10471, 7, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10471, 56, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10472, 51, 18); INSERT INTO `DETAILS_COMMANDES` VALUES(10473, 33, 12); INSERT INTO `DETAILS_COMMANDES` VALUES(10478, 10, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10484, 21, 14); INSERT INTO `DETAILS_COMMANDES` VALUES(10484, 40, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10484, 51, 3); INSERT INTO `DETAILS_COMMANDES` VALUES(10489, 11, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10489, 16, 18); INSERT INTO `DETAILS_COMMANDES` VALUES(10491, 44, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10492, 42, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10493, 65, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10493, 66, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10493, 69, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10495, 41, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10497, 56, 14); INSERT INTO `DETAILS_COMMANDES` VALUES(10497, 72, 25); INSERT INTO `DETAILS_COMMANDES` VALUES(10500, 15, 12); INSERT INTO `DETAILS_COMMANDES` VALUES(10503, 14, 70); INSERT INTO `DETAILS_COMMANDES` VALUES(10503, 65, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10511, 4, 50); INSERT INTO `DETAILS_COMMANDES` VALUES(10511, 7, 50); INSERT INTO `DETAILS_COMMANDES` VALUES(10511, 8, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10513, 21, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10513, 32, 50); INSERT INTO `DETAILS_COMMANDES` VALUES(10514, 20, 39); INSERT INTO `DETAILS_COMMANDES` VALUES(10514, 56, 70); INSERT INTO `DETAILS_COMMANDES` VALUES(10514, 65, 39); INSERT INTO `DETAILS_COMMANDES` VALUES(10516, 18, 25); INSERT INTO `DETAILS_COMMANDES` VALUES(10516, 41, 80); INSERT INTO `DETAILS_COMMANDES` VALUES(10516, 42, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10517, 52, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10517, 59, 4); INSERT INTO `DETAILS_COMMANDES` VALUES(10517, 70, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10519, 10, 16); INSERT INTO `DETAILS_COMMANDES` VALUES(10519, 56, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10519, 60, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10521, 35, 3); INSERT INTO `DETAILS_COMMANDES` VALUES(10521, 41, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10521, 68, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10522, 1, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10522, 8, 24); INSERT INTO `DETAILS_COMMANDES` VALUES(10522, 30, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10522, 40, 25); INSERT INTO `DETAILS_COMMANDES` VALUES(10523, 17, 25); INSERT INTO `DETAILS_COMMANDES` VALUES(10523, 20, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10523, 37, 18); INSERT INTO `DETAILS_COMMANDES` VALUES(10523, 41, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10525, 36, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10525, 40, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10526, 1, 8); INSERT INTO `DETAILS_COMMANDES` VALUES(10526, 13, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10526, 56, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10529, 68, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10529, 69, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10530, 17, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10530, 43, 25); INSERT INTO `DETAILS_COMMANDES` VALUES(10532, 30, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10532, 66, 24); INSERT INTO `DETAILS_COMMANDES` VALUES(10534, 30, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10534, 40, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10536, 12, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10536, 31, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10536, 33, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10536, 60, 35); INSERT INTO `DETAILS_COMMANDES` VALUES(10538, 70, 7); INSERT INTO `DETAILS_COMMANDES` VALUES(10538, 72, 1); INSERT INTO `DETAILS_COMMANDES` VALUES(10539, 13, 8); INSERT INTO `DETAILS_COMMANDES` VALUES(10539, 21, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10539, 33, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10539, 49, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10546, 7, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10546, 35, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10546, 62, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10547, 32, 24); INSERT INTO `DETAILS_COMMANDES` VALUES(10547, 36, 60); INSERT INTO `DETAILS_COMMANDES` VALUES(10550, 17, 8); INSERT INTO `DETAILS_COMMANDES` VALUES(10550, 19, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10550, 21, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10551, 16, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10551, 35, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10551, 44, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10553, 11, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10553, 16, 14); INSERT INTO `DETAILS_COMMANDES` VALUES(10553, 31, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10553, 35, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10558, 47, 25); INSERT INTO `DETAILS_COMMANDES` VALUES(10558, 51, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10558, 52, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10558, 53, 18); INSERT INTO `DETAILS_COMMANDES` VALUES(10562, 33, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10562, 62, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10567, 31, 60); INSERT INTO `DETAILS_COMMANDES` VALUES(10567, 51, 3); INSERT INTO `DETAILS_COMMANDES` VALUES(10567, 59, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10571, 14, 11); INSERT INTO `DETAILS_COMMANDES` VALUES(10571, 42, 28); INSERT INTO `DETAILS_COMMANDES` VALUES(10575, 59, 12); INSERT INTO `DETAILS_COMMANDES` VALUES(10575, 63, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10575, 72, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10578, 35, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10578, 57, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10582, 57, 4); INSERT INTO `DETAILS_COMMANDES` VALUES(10583, 60, 24); INSERT INTO `DETAILS_COMMANDES` VALUES(10583, 69, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10586, 52, 4); INSERT INTO `DETAILS_COMMANDES` VALUES(10592, 15, 25); INSERT INTO `DETAILS_COMMANDES` VALUES(10593, 20, 21); INSERT INTO `DETAILS_COMMANDES` VALUES(10593, 69, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10595, 35, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10595, 69, 65); INSERT INTO `DETAILS_COMMANDES` VALUES(10597, 57, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10597, 65, 12); INSERT INTO `DETAILS_COMMANDES` VALUES(10599, 62, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10604, 48, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10609, 1, 3); INSERT INTO `DETAILS_COMMANDES` VALUES(10609, 10, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10609, 21, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10610, 36, 21); INSERT INTO `DETAILS_COMMANDES` VALUES(10611, 1, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10611, 2, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10611, 60, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10614, 11, 14); INSERT INTO `DETAILS_COMMANDES` VALUES(10614, 21, 8); INSERT INTO `DETAILS_COMMANDES` VALUES(10614, 39, 5); INSERT INTO `DETAILS_COMMANDES` VALUES(10620, 52, 5); INSERT INTO `DETAILS_COMMANDES` VALUES(10621, 19, 5); INSERT INTO `DETAILS_COMMANDES` VALUES(10621, 70, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10632, 2, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10632, 33, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10633, 12, 36); INSERT INTO `DETAILS_COMMANDES` VALUES(10633, 13, 13); INSERT INTO `DETAILS_COMMANDES` VALUES(10633, 62, 80); INSERT INTO `DETAILS_COMMANDES` VALUES(10635, 4, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10635, 5, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10636, 4, 25); INSERT INTO `DETAILS_COMMANDES` VALUES(10636, 58, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10640, 69, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10640, 70, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10643, 39, 21); INSERT INTO `DETAILS_COMMANDES` VALUES(10643, 46, 2); INSERT INTO `DETAILS_COMMANDES` VALUES(10646, 1, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10646, 10, 18); INSERT INTO `DETAILS_COMMANDES` VALUES(10649, 72, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10651, 19, 12); INSERT INTO `DETAILS_COMMANDES` VALUES(10655, 41, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10661, 39, 3); INSERT INTO `DETAILS_COMMANDES` VALUES(10661, 58, 49); INSERT INTO `DETAILS_COMMANDES` VALUES(10663, 40, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10663, 42, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10663, 51, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10664, 10, 24); INSERT INTO `DETAILS_COMMANDES` VALUES(10664, 56, 12); INSERT INTO `DETAILS_COMMANDES` VALUES(10664, 65, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10667, 69, 45); INSERT INTO `DETAILS_COMMANDES` VALUES(10668, 31, 8); INSERT INTO `DETAILS_COMMANDES` VALUES(10671, 16, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10671, 62, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10671, 65, 12); INSERT INTO `DETAILS_COMMANDES` VALUES(10673, 16, 3); INSERT INTO `DETAILS_COMMANDES` VALUES(10673, 42, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10673, 43, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10683, 52, 9); INSERT INTO `DETAILS_COMMANDES` VALUES(10686, 17, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10687, 9, 50); INSERT INTO `DETAILS_COMMANDES` VALUES(10687, 36, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10692, 63, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10695, 8, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10695, 12, 4); INSERT INTO `DETAILS_COMMANDES` VALUES(10698, 11, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10698, 17, 8); INSERT INTO `DETAILS_COMMANDES` VALUES(10698, 65, 65); INSERT INTO `DETAILS_COMMANDES` VALUES(10698, 70, 8); INSERT INTO `DETAILS_COMMANDES` VALUES(10699, 47, 12); INSERT INTO `DETAILS_COMMANDES` VALUES(10701, 59, 42); INSERT INTO `DETAILS_COMMANDES` VALUES(10702, 3, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10707, 57, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10707, 70, 28); INSERT INTO `DETAILS_COMMANDES` VALUES(10710, 19, 5); INSERT INTO `DETAILS_COMMANDES` VALUES(10710, 47, 5); INSERT INTO `DETAILS_COMMANDES` VALUES(10712, 53, 3); INSERT INTO `DETAILS_COMMANDES` VALUES(10712, 56, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10715, 10, 21); INSERT INTO `DETAILS_COMMANDES` VALUES(10716, 21, 5); INSERT INTO `DETAILS_COMMANDES` VALUES(10716, 51, 7); INSERT INTO `DETAILS_COMMANDES` VALUES(10726, 4, 25); INSERT INTO `DETAILS_COMMANDES` VALUES(10726, 11, 5); INSERT INTO `DETAILS_COMMANDES` VALUES(10727, 17, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10727, 56, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10727, 59, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10730, 16, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10730, 31, 3); INSERT INTO `DETAILS_COMMANDES` VALUES(10730, 65, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10731, 21, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10731, 51, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10736, 65, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10737, 13, 4); INSERT INTO `DETAILS_COMMANDES` VALUES(10737, 41, 12); INSERT INTO `DETAILS_COMMANDES` VALUES(10739, 36, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10739, 52, 18); INSERT INTO `DETAILS_COMMANDES` VALUES(10741, 2, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10742, 3, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10742, 60, 50); INSERT INTO `DETAILS_COMMANDES` VALUES(10742, 72, 35); INSERT INTO `DETAILS_COMMANDES` VALUES(10743, 46, 28); INSERT INTO `DETAILS_COMMANDES` VALUES(10746, 13, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10746, 42, 28); INSERT INTO `DETAILS_COMMANDES` VALUES(10746, 62, 9); INSERT INTO `DETAILS_COMMANDES` VALUES(10746, 69, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10747, 31, 8); INSERT INTO `DETAILS_COMMANDES` VALUES(10747, 41, 35); INSERT INTO `DETAILS_COMMANDES` VALUES(10747, 63, 9); INSERT INTO `DETAILS_COMMANDES` VALUES(10747, 69, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10749, 56, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10749, 59, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10750, 14, 5); INSERT INTO `DETAILS_COMMANDES` VALUES(10750, 59, 25); INSERT INTO `DETAILS_COMMANDES` VALUES(10752, 1, 8); INSERT INTO `DETAILS_COMMANDES` VALUES(10752, 69, 3); INSERT INTO `DETAILS_COMMANDES` VALUES(10753, 74, 5); INSERT INTO `DETAILS_COMMANDES` VALUES(10754, 40, 3); INSERT INTO `DETAILS_COMMANDES` VALUES(10755, 47, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10755, 56, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10755, 57, 14); INSERT INTO `DETAILS_COMMANDES` VALUES(10755, 69, 25); INSERT INTO `DETAILS_COMMANDES` VALUES(10760, 27, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10760, 43, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10764, 3, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10764, 39, 130); INSERT INTO `DETAILS_COMMANDES` VALUES(10768, 31, 50); INSERT INTO `DETAILS_COMMANDES` VALUES(10768, 60, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10772, 59, 25); INSERT INTO `DETAILS_COMMANDES` VALUES(10773, 17, 33); INSERT INTO `DETAILS_COMMANDES` VALUES(10773, 31, 70); INSERT INTO `DETAILS_COMMANDES` VALUES(10776, 31, 16); INSERT INTO `DETAILS_COMMANDES` VALUES(10776, 42, 12); INSERT INTO `DETAILS_COMMANDES` VALUES(10776, 51, 120); INSERT INTO `DETAILS_COMMANDES` VALUES(10779, 16, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10779, 62, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10781, 56, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10781, 74, 35); INSERT INTO `DETAILS_COMMANDES` VALUES(10782, 31, 1); INSERT INTO `DETAILS_COMMANDES` VALUES(10784, 36, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10784, 39, 2); INSERT INTO `DETAILS_COMMANDES` VALUES(10784, 72, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10787, 2, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10792, 2, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10792, 68, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10793, 41, 14); INSERT INTO `DETAILS_COMMANDES` VALUES(10793, 52, 8); INSERT INTO `DETAILS_COMMANDES` VALUES(10795, 16, 65); INSERT INTO `DETAILS_COMMANDES` VALUES(10795, 17, 35); INSERT INTO `DETAILS_COMMANDES` VALUES(10797, 11, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10798, 62, 2); INSERT INTO `DETAILS_COMMANDES` VALUES(10798, 72, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10800, 11, 50); INSERT INTO `DETAILS_COMMANDES` VALUES(10800, 51, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10804, 10, 36); INSERT INTO `DETAILS_COMMANDES` VALUES(10804, 49, 4); INSERT INTO `DETAILS_COMMANDES` VALUES(10806, 2, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10806, 65, 2); INSERT INTO `DETAILS_COMMANDES` VALUES(10806, 74, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10807, 40, 1); INSERT INTO `DETAILS_COMMANDES` VALUES(10810, 13, 7); INSERT INTO `DETAILS_COMMANDES` VALUES(10810, 70, 5); INSERT INTO `DETAILS_COMMANDES` VALUES(10812, 31, 16); INSERT INTO `DETAILS_COMMANDES` VALUES(10812, 72, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10814, 41, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10814, 43, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10814, 48, 8); INSERT INTO `DETAILS_COMMANDES` VALUES(10818, 32, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10818, 41, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10819, 43, 7); INSERT INTO `DETAILS_COMMANDES` VALUES(10825, 53, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10827, 10, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10827, 39, 21); INSERT INTO `DETAILS_COMMANDES` VALUES(10828, 20, 5); INSERT INTO `DETAILS_COMMANDES` VALUES(10829, 2, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10829, 8, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10829, 13, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10829, 60, 21); INSERT INTO `DETAILS_COMMANDES` VALUES(10832, 13, 3); INSERT INTO `DETAILS_COMMANDES` VALUES(10832, 44, 16); INSERT INTO `DETAILS_COMMANDES` VALUES(10835, 59, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10836, 35, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10836, 57, 24); INSERT INTO `DETAILS_COMMANDES` VALUES(10836, 60, 60); INSERT INTO `DETAILS_COMMANDES` VALUES(10843, 51, 4); INSERT INTO `DETAILS_COMMANDES` VALUES(10848, 5, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10848, 9, 3); INSERT INTO `DETAILS_COMMANDES` VALUES(10850, 33, 4); INSERT INTO `DETAILS_COMMANDES` VALUES(10850, 70, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10853, 18, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10854, 10, 100); INSERT INTO `DETAILS_COMMANDES` VALUES(10854, 13, 65); INSERT INTO `DETAILS_COMMANDES` VALUES(10858, 7, 5); INSERT INTO `DETAILS_COMMANDES` VALUES(10858, 27, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10858, 70, 4); INSERT INTO `DETAILS_COMMANDES` VALUES(10860, 51, 3); INSERT INTO `DETAILS_COMMANDES` VALUES(10862, 11, 25); INSERT INTO `DETAILS_COMMANDES` VALUES(10862, 52, 8); INSERT INTO `DETAILS_COMMANDES` VALUES(10864, 35, 4); INSERT INTO `DETAILS_COMMANDES` VALUES(10864, 67, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10869, 1, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10869, 11, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10869, 68, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10870, 35, 3); INSERT INTO `DETAILS_COMMANDES` VALUES(10870, 51, 2); INSERT INTO `DETAILS_COMMANDES` VALUES(10871, 6, 50); INSERT INTO `DETAILS_COMMANDES` VALUES(10871, 16, 12); INSERT INTO `DETAILS_COMMANDES` VALUES(10871, 17, 16); INSERT INTO `DETAILS_COMMANDES` VALUES(10872, 62, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10872, 65, 21); INSERT INTO `DETAILS_COMMANDES` VALUES(10873, 21, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10874, 10, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10876, 46, 21); INSERT INTO `DETAILS_COMMANDES` VALUES(10879, 40, 12); INSERT INTO `DETAILS_COMMANDES` VALUES(10879, 65, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10888, 2, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10888, 68, 18); INSERT INTO `DETAILS_COMMANDES` VALUES(10890, 17, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10890, 34, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10890, 41, 14); INSERT INTO `DETAILS_COMMANDES` VALUES(10891, 30, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10892, 59, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10895, 39, 45); INSERT INTO `DETAILS_COMMANDES` VALUES(10895, 40, 91); INSERT INTO `DETAILS_COMMANDES` VALUES(10895, 60, 100); INSERT INTO `DETAILS_COMMANDES` VALUES(10896, 56, 16); INSERT INTO `DETAILS_COMMANDES` VALUES(10897, 30, 36); INSERT INTO `DETAILS_COMMANDES` VALUES(10908, 7, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10908, 52, 14); INSERT INTO `DETAILS_COMMANDES` VALUES(10910, 19, 12); INSERT INTO `DETAILS_COMMANDES` VALUES(10910, 49, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10911, 1, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10911, 17, 12); INSERT INTO `DETAILS_COMMANDES` VALUES(10911, 67, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10912, 11, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10916, 16, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10916, 32, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10916, 57, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10918, 1, 60); INSERT INTO `DETAILS_COMMANDES` VALUES(10918, 60, 25); INSERT INTO `DETAILS_COMMANDES` VALUES(10920, 50, 24); INSERT INTO `DETAILS_COMMANDES` VALUES(10923, 42, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10923, 43, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10923, 67, 24); INSERT INTO `DETAILS_COMMANDES` VALUES(10927, 20, 5); INSERT INTO `DETAILS_COMMANDES` VALUES(10927, 52, 5); INSERT INTO `DETAILS_COMMANDES` VALUES(10932, 16, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10932, 62, 14); INSERT INTO `DETAILS_COMMANDES` VALUES(10932, 72, 16); INSERT INTO `DETAILS_COMMANDES` VALUES(10933, 53, 2); INSERT INTO `DETAILS_COMMANDES` VALUES(10934, 6, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10937, 34, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10939, 2, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10939, 67, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10940, 7, 8); INSERT INTO `DETAILS_COMMANDES` VALUES(10940, 13, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10942, 49, 28); INSERT INTO `DETAILS_COMMANDES` VALUES(10943, 13, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10943, 46, 15); INSERT INTO `DETAILS_COMMANDES` VALUES(10944, 11, 5); INSERT INTO `DETAILS_COMMANDES` VALUES(10944, 44, 18); INSERT INTO `DETAILS_COMMANDES` VALUES(10944, 56, 18); INSERT INTO `DETAILS_COMMANDES` VALUES(10945, 13, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10945, 31, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10947, 59, 4); INSERT INTO `DETAILS_COMMANDES` VALUES(10948, 50, 9); INSERT INTO `DETAILS_COMMANDES` VALUES(10948, 51, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10949, 6, 12); INSERT INTO `DETAILS_COMMANDES` VALUES(10949, 10, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10949, 17, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10949, 62, 60); INSERT INTO `DETAILS_COMMANDES` VALUES(10950, 4, 5); INSERT INTO `DETAILS_COMMANDES` VALUES(10952, 6, 16); INSERT INTO `DETAILS_COMMANDES` VALUES(10953, 20, 50); INSERT INTO `DETAILS_COMMANDES` VALUES(10953, 31, 50); INSERT INTO `DETAILS_COMMANDES` VALUES(10956, 21, 12); INSERT INTO `DETAILS_COMMANDES` VALUES(10956, 47, 14); INSERT INTO `DETAILS_COMMANDES` VALUES(10956, 51, 8); INSERT INTO `DETAILS_COMMANDES` VALUES(10963, 60, 2); INSERT INTO `DETAILS_COMMANDES` VALUES(10966, 37, 8); INSERT INTO `DETAILS_COMMANDES` VALUES(10966, 56, 12); INSERT INTO `DETAILS_COMMANDES` VALUES(10966, 62, 12); INSERT INTO `DETAILS_COMMANDES` VALUES(10968, 12, 30); INSERT INTO `DETAILS_COMMANDES` VALUES(10972, 17, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10972, 33, 7); INSERT INTO `DETAILS_COMMANDES` VALUES(10973, 41, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10975, 8, 16); INSERT INTO `DETAILS_COMMANDES` VALUES(10978, 8, 20); INSERT INTO `DETAILS_COMMANDES` VALUES(10978, 21, 40); INSERT INTO `DETAILS_COMMANDES` VALUES(10978, 40, 10); INSERT INTO `DETAILS_COMMANDES` VALUES(10978, 44, 6); INSERT INTO `DETAILS_COMMANDES` VALUES(10979, 7, 18); INSERT INTO `DETAILS_COMMANDES` VALUES(10979, 12, 20);