INSERT INTO HotelBis.Client
  VALUES(DEFAULT,'Dupont','Martin','martin.dupont@ici.fr','ici.fr');
INSERT INTO HotelBis.Client
  VALUES(DEFAULT,'Martin','Dupont','dupont.martin@ici.fr','ici.fr');
INSERT INTO HotelBis.Client
  VALUES(DEFAULT,'Dupont','Martin','martin.dupont@labas.fr','labas.fr');
INSERT INTO HotelBis.Client
  VALUES(DEFAULT,'Martin','Dupont','dupont.martin@labas.fr','labas.fr');
INSERT INTO HotelBis.Client
  VALUES(DEFAULT,'Durand','Durant','durant.durand@ailleurs.fr','ailleurs.fr');

INSERT INTO HotelBis.Reservation
  VALUES(DEFAULT,1,1,'2017-11-10','2017-11-15');
INSERT INTO HotelBis.Reservation
  VALUES(DEFAULT,2,1,'2017-11-20','2017-11-25');
INSERT INTO HotelBis.Reservation
  VALUES(DEFAULT,3,1,'2017-12-10','2017-12-15');
INSERT INTO HotelBis.Reservation
  VALUES(DEFAULT,4,1,'2017-12-20','2017-12-25');

INSERT INTO HotelBis.Recette
  VALUES(1,'2017-11-11 10:30:00', 'Bière', 1, 2);
INSERT INTO HotelBis.Recette
  VALUES(1,'2017-11-12 12:10:18', 'Pastis', 2, 1);
INSERT INTO HotelBis.Recette
  VALUES(1,'2017-11-12 12:30:14', 'Pastis', 1, 1);
