INSERT INTO Hotel.TypeChambre
  VALUES('Single',47,'Lit simple, Douche, Petit déjeuner');
INSERT INTO Hotel.TypeChambre
  VALUES('Double',65,'Grand lit, Baignoire, Petit déjeuner');
INSERT INTO Hotel.TypeChambre
  VALUES('Workable',92,'Grand lit, Baignoire, Bureau, Internet illimité, Petit déjeuner');
INSERT INTO Hotel.TypeChambre
  VALUES('Indisponible',1,'Rénovation en cours');
-- Erreur
INSERT INTO Hotel.Chambres VALUES(1,2,'Double');
-- Normal
INSERT INTO Hotel.Chambres VALUES(1,1,'Single');
INSERT INTO Hotel.Chambres VALUES(1,2,'Single');
INSERT INTO Hotel.Chambres VALUES(1,3,'Indisponible');
INSERT INTO Hotel.Chambres VALUES(1,4,'Single');
INSERT INTO Hotel.Chambres VALUES(2,1,'Double');
INSERT INTO Hotel.Chambres VALUES(2,2,'Double');
INSERT INTO Hotel.Chambres VALUES(2,3,'Workable');
INSERT INTO Hotel.Chambres VALUES(3,1,'Workable');
INSERT INTO Hotel.Chambres VALUES(3,2,'Double');
INSERT INTO Hotel.Chambres VALUES(3,3,'Double');
-- Erreurs
INSERT INTO Hotel.Chambres VALUES(2,6,'Double');
INSERT INTO Hotel.Chambres VALUES(7,1,'Double');
INSERT INTO Hotel.PrixConsommation VALUES('Pepsi-Cola',2);
INSERT INTO Hotel.PrixConsommation VALUES('Téléphone',0.4);
INSERT INTO Hotel.PrixConsommation VALUES('Whisky-baby',9);
INSERT INTO Hotel.PrixConsommation VALUES('Sauna',11);

INSERT INTO Hotel.Clients
  VALUES(DEFAULT,'Duchemin','Albert','10 rue des Jumeaux à Strasbourg');
INSERT INTO Hotel.Clients
  VALUES(DEFAULT,'Duchemin','Albert','13 rue de la Paix à Saillans (33141)');
-- Les attributs : Etage, Numero, DateDebut, DateFin, NumClient
INSERT INTO Hotel.Reservations
  VALUES(1,2,'2011-02-26','2011-03-03',2);
INSERT INTO Hotel.Reservations
  VALUES(1,2,'2011-03-16','2011-03-21',2);
INSERT INTO Hotel.Reservations
  VALUES(1,2,'2011-04-16','2011-04-21',2);
INSERT INTO Hotel.Reservations
  VALUES(1,2,'2011-05-16','2011-05-21',2);
-- Erreur DateDebut > DateFin
INSERT INTO Hotel.Reservations
  VALUES(1,2,'2011-03-26','2011-03-23',2);
-- Erreur DateFin incorrecte
INSERT INTO Hotel.Reservations
  VALUES(1,2,'2011-02-20','2011-03-01',2);
-- Erreur DateDebut incorrecte
INSERT INTO Hotel.Reservations
  VALUES(1,2,'2011-02-28','2011-03-05',2);
