INSERT INTO client (client_id,nom,adresse) VALUES (2,'Blut','41 rue des voyageurs 95000 Cergy');


INSERT INTO delai (delai_id,Prop_30j,Prop_60j,Prop_90j) VALUES (13,1,0,0);

--INSERT INTO commande (commande_id, date_commande, date_livraison, client_id, paiement_id, delai_id)

INSERT INTO commande  VALUES (13,to_date('01/01/2009','DD/MM/YYYY'),to_date('15/01/2009','DD/MM/YYYY'),2,3,13);
INSERT INTO commande  VALUES (14,to_date('02/02/2009','DD/MM/YYYY'),to_date('16/02/2009','DD/MM/YYYY'),2,3,13);
INSERT INTO commande  VALUES (15,to_date('03/03/2009','DD/MM/YYYY'),to_date('17/03/2009','DD/MM/YYYY'),2,3,13);
INSERT INTO commande  VALUES (16,to_date('04/04/2009','DD/MM/YYYY'),to_date('18/04/2009','DD/MM/YYYY'),2,3,13);
INSERT INTO commande  VALUES (17,to_date('05/05/2009','DD/MM/YYYY'),to_date('19/05/2009','DD/MM/YYYY'),2,3,13);
INSERT INTO commande  VALUES (18,to_date('06/06/2009','DD/MM/YYYY'),to_date('20/06/2009','DD/MM/YYYY'),2,3,13);
INSERT INTO commande  VALUES (19,to_date('07/07/2009','DD/MM/YYYY'),to_date('21/07/2009','DD/MM/YYYY'),2,3,13);
INSERT INTO commande  VALUES (20,to_date('08/08/2009','DD/MM/YYYY'),to_date('22/08/2009','DD/MM/YYYY'),2,3,13);
INSERT INTO commande  VALUES (21,to_date('09/09/2009','DD/MM/YYYY'),to_date('23/09/2009','DD/MM/YYYY'),2,3,13);
INSERT INTO commande  VALUES (22,to_date('10/10/2009','DD/MM/YYYY'),to_date('24/10/2009','DD/MM/YYYY'),2,3,13);
INSERT INTO commande  VALUES (23,to_date('11/11/2009','DD/MM/YYYY'),to_date('25/11/2009','DD/MM/YYYY'),2,3,13);
INSERT INTO commande  VALUES (24,to_date('12/12/2009','DD/MM/YYYY'),to_date('26/12/2009','DD/MM/YYYY'),2,3,13);


INSERT INTO contient (commande_id,produit_id,quantite) VALUES (13,1,28);
INSERT INTO contient (commande_id,produit_id,quantite) VALUES (14,1,45);
INSERT INTO contient (commande_id,produit_id,quantite) VALUES (15,1,39);
INSERT INTO contient (commande_id,produit_id,quantite) VALUES (16,1,34);
INSERT INTO contient (commande_id,produit_id,quantite) VALUES (17,1,43);
INSERT INTO contient (commande_id,produit_id,quantite) VALUES (18,1,39);
INSERT INTO contient (commande_id,produit_id,quantite) VALUES (19,1,34);
INSERT INTO contient (commande_id,produit_id,quantite) VALUES (20,1,10);
INSERT INTO contient (commande_id,produit_id,quantite) VALUES (21,1,45);
INSERT INTO contient (commande_id,produit_id,quantite) VALUES (22,1,80);
INSERT INTO contient (commande_id,produit_id,quantite) VALUES (23,1,45);
INSERT INTO contient (commande_id,produit_id,quantite) VALUES (24,1,56);
