'45870', 'Garduche', 'France', 'elinefaluche@email.com');
INSERT INTO Client (prenom, nom, adresse, code_postal, ville,
pays, email) VALUES ('Carine', 'Penni', 'Boulevard Haussman, 85',
'1514', 'Plasse', 'Suisse', 'cpenni@email.com');
INSERT INTO Client (prenom, nom, adresse, code_postal, ville,
pays, email) VALUES ('Virginie', 'Broussaille', 'Rue du Fleuve,
18', '45810', 'Houtsiplou', 'France', 'vibrousaille@email.com');
INSERT INTO Client (prenom, nom, adresse, code_postal, ville,
pays, email) VALUES ('Hannah', 'Durant', 'Rue des Pendus, 66',
'1514', 'Plasse', 'Suisse', 'hhdurant@email.com');
INSERT INTO Client (prenom, nom, adresse, code_postal, ville,
pays, email) VALUES ('Elodie', 'Delfour', 'Rue de Flore, 1',
'3250', 'Belville', 'Belgique', 'e.delfour@email.com');
INSERT INTO Client (prenom, nom, adresse, code_postal, ville,
pays, email) VALUES ('Joel', 'Kestau', NULL, NULL, NULL, NULL,
'joel.kestau@email.com');
-- Insertion de quelques adoptions
INSERT INTO Adoption (client_id, animal_id, date_reservation,
date_adoption, prix, paye) VALUES (1, 39, '2008-08-17', '2008-0817', 735.00, 1);
INSERT INTO Adoption (client_id, animal_id, date_reservation,
date_adoption, prix, paye) VALUES (1, 40, '2008-08-17', '2008-0817', 735.00, 1);
INSERT INTO Adoption (client_id, animal_id, date_reservation,
date_adoption, prix, paye) VALUES (2, 18, '2008-06-04', '2008-0604', 485.00, 1);
INSERT INTO Adoption (client_id, animal_id, date_reservation,
date_adoption, prix, paye) VALUES (3, 27, '2009-11-17', '2009-1117', 200.00, 1);
INSERT INTO Adoption (client_id, animal_id, date_reservation,
date_adoption, prix, paye) VALUES (4, 26, '2007-02-21', '2007-0221', 485.00, 1);
INSERT INTO Adoption (client_id, animal_id, date_reservation,
date_adoption, prix, paye) VALUES (4, 41, '2007-02-21', '2007-0221', 835.00, 1);
INSERT INTO Adoption (client_id, animal_id, date_reservation,
date_adoption, prix, paye) VALUES (5, 21, '2009-03-08', '2009-0308', 200.00, 1);
INSERT INTO Adoption (client_id, animal_id, date_reservation,
date_adoption, prix, paye) VALUES (6, 16, '2010-01-27', '2010-0127', 200.00, 1);
INSERT INTO Adoption (client_id, animal_id, date_reservation,
date_adoption, prix, paye) VALUES (7, 5, '2011-04-05', '2011-0405', 150.00, 1);
INSERT INTO Adoption (client_id, animal_id, date_reservation,
date_adoption, prix, paye) VALUES (8, 42, '2008-08-16', '2008-0816', 735.00, 1);
INSERT INTO Adoption (client_id, animal_id, date_reservation,
date_adoption, prix, paye) VALUES (9, 55, '2011-02-13', '2011-0213', 140.00, 1);
INSERT INTO Adoption (client_id, animal_id, date_reservation,
date_adoption, prix, paye) VALUES (9, 54, '2011-02-13', '2011-0213', 140.00, 1);
INSERT INTO Adoption (client_id, animal_id, date_reservation,
date_adoption, prix, paye) VALUES (10, 49, '2010-08-17', '2010-0817', 140.00, 1);
INSERT INTO Adoption (client_id, animal_id, date_reservation,
date_adoption, prix, paye) VALUES (11, 62, '2011-03-01', '2011-0301', 630.00, 1);
INSERT INTO Adoption (client_id, animal_id, date_reservation,
date_adoption, prix, paye) VALUES (12, 69, '2007-09-20', '2007-0920', 10.00, 1);
INSERT INTO Adoption (client_id, animal_id, date_reservation,
date_adoption, prix, paye) VALUES (13, 57, '2012-01-10', '2012-0110', 700.00, 1);
INSERT INTO Adoption (client_id, animal_id, date_reservation,
date_adoption, prix, paye) VALUES (14, 58, '2012-02-25', '2012-0225', 700.00, 1);
INSERT INTO Adoption (client_id, animal_id, date_reservation,
Partie 5 : Sécuriser et automatiser ses actions
235/414
www.openclassrooms.com