INSERT INTO Client VALUES(1, 'Lamy-Chappuis', 'Jason', '1986-09-09', '39220', 'Bois-d Amont');
INSERT INTO Client VALUES(2, 'Fourcade', 'Martin', '1988-09-14', '38250', 'Villard-de-Lans');
INSERT INTO Client VALUES(3, 'Tardivel', 'Pierre', '1963-11-26', '74000', 'Annecy');
INSERT INTO Client VALUES(4, 'Manaudou', 'Florent', '1990-11-12', '13000', 'Marseille');
INSERT INTO Client VALUES(5, 'Lavillenie', 'Renaud', '1986-09-18', '63170', 'Pérignat-les-Sarliève');
INSERT INTO Client VALUES(6, 'Gilot', 'Fabien', '1984-04-27', '13000', 'Marseille');

INSERT INTO Produit VALUES(1, 'Lunettes Cobra', 30 , 1);
INSERT INTO Produit VALUES(2, 'Perche Evolution', 472 , 3);
INSERT INTO Produit VALUES(3, 'Piolet Monte Bianco', 128, 2);
INSERT INTO Produit VALUES(4, 'Skis de piste CR78', 640, 5);
INSERT INTO Produit VALUES(5, 'Skis de fond X-IUM Skating', 429, 4);
INSERT INTO Produit VALUES(6, 'Maillot de bain Powerskin', 249, 1);
INSERT INTO Produit VALUES(7, 'Casque Sirocco', 83, 8);
INSERT INTO Produit VALUES(8, 'Mousqueton Goliath', 10, 7);
INSERT INTO Produit VALUES(9, 'Corde Diablo', 168, 6);

INSERT INTO Fournisseur VALUES(1, 'Arena');
INSERT INTO Fournisseur VALUES(2, 'Grivel');
INSERT INTO Fournisseur VALUES(3, 'Nordic');
INSERT INTO Fournisseur VALUES(4, 'Rossignol');
INSERT INTO Fournisseur VALUES(5, 'Dynastar');
INSERT INTO Fournisseur VALUES(6, 'Béal');
INSERT INTO Fournisseur VALUES(7, 'Simond');
INSERT INTO Fournisseur VALUES(8, 'Petzl');

INSERT INTO Commande VALUES(3, 8, '2014-02-24', 30);
INSERT INTO Commande VALUES(5, 2, '2014-01-08', 6);
INSERT INTO Commande VALUES(3, 7, '2013-12-04', 2);
INSERT INTO Commande VALUES(5, 5, '2013-11-20', 2);
INSERT INTO Commande VALUES(1, 5, '2013-10-28', 5);
INSERT INTO Commande VALUES(4, 1, '2014-06-13', 6);
INSERT INTO Commande VALUES(2, 5, '2013-09-16', 5);
INSERT INTO Commande VALUES(6, 6, '2014-04-12', 8);
INSERT INTO Commande VALUES(3, 3, '2014-05-20', 2);
INSERT INTO Commande VALUES(3, 9, '2014-05-20', 4);
INSERT INTO Commande VALUES(4, 6, '2014-03-13', 10);
INSERT INTO Commande VALUES(3, 4, '2013-11-07', 2);