--
-- Hotels
--
INSERT INTO hotels(name, city, stars) VALUES ('L`excelsior', 'Nice', 3);
INSERT INTO hotels(name, city, stars) VALUES ('La nuit noire', 'Bordeaux', 2);
INSERT INTO hotels(name, city, stars) VALUES ('Hôtel de la gare', 'Bordeaux', 1);
INSERT INTO hotels(name, city, stars) VALUES ('Le grand hôtel', 'Nice', 4);
INSERT INTO hotels(name, city, stars) VALUES ('Hôtel chez soi', 'Lyon', 2);
INSERT INTO hotels(name, city, stars) VALUES ('Chez Philippe', 'Bordeaux', 2);
INSERT INTO hotels(name, city, stars) VALUES ('Hôtel terminus', 'Bordeaux', 1);
INSERT INTO hotels(name, city, stars) VALUES ('Hôtel terminus', 'Grenoble', 1);
INSERT INTO hotels(name, city, stars) VALUES ('Hôtel terminus', 'Nice', 1);
INSERT INTO hotels(name, city, stars) VALUES ('Hôtel des ambassadeurs', 'Grenoble', 3);
INSERT INTO hotels(name, city, stars) VALUES ('Hôtel des voyageurs', 'Nice', 3);
INSERT INTO hotels(name, city, stars) VALUES ('Grand hôtel', 'Grenoble', 4);


--
-- Clients
--
INSERT INTO clients(surname, first_name) VALUES ('Dupont', 'Marcel');
INSERT INTO clients(surname, first_name) VALUES ('Dupont', 'Paul');
INSERT INTO clients(surname, first_name) VALUES ('Dupont', 'Marie-Jeanne');
INSERT INTO clients(surname, first_name) VALUES ('Tourbirier', 'Edgar'); 
INSERT INTO clients(surname, first_name) VALUES ('Blesta', 'Nicole'); 
INSERT INTO clients(surname, first_name) VALUES ('Blesta', 'Amandine'); 
INSERT INTO clients(surname, first_name) VALUES ('Smith', 'John'); 
INSERT INTO clients(surname, first_name) VALUES ('Smith', 'T. Jack'); 
INSERT INTO clients(surname, first_name) VALUES ('Smith', 'Peter'); 
INSERT INTO clients(surname, first_name) VALUES ('Johnson', 'Eliott'); 
INSERT INTO clients(surname, first_name) VALUES ('Bachelard', 'Gaston'); 
INSERT INTO clients(surname, first_name) VALUES ('Rivoyre', 'Paul-Emile'); 
INSERT INTO clients(surname, first_name) VALUES ('Thioux', 'Luc'); 
INSERT INTO clients(surname, first_name) VALUES ('Thioux', 'Valere'); 
INSERT INTO clients(surname, first_name) VALUES ('Pollinion', 'Arthur'); 
INSERT INTO clients(surname, first_name) VALUES ('Loumilier', 'Valerie'); 
INSERT INTO clients(surname, first_name) VALUES ('Pitelli', 'Eleonore'); 
INSERT INTO clients(surname, first_name) VALUES ('Pitelli', 'Anna'); 
INSERT INTO clients(surname, first_name) VALUES ('Locatelli', 'Marie'); 
INSERT INTO clients(surname, first_name) VALUES ('Rodriguez', 'Romeo'); 
INSERT INTO clients(surname, first_name) VALUES ('Martin', 'Henri'); 
INSERT INTO clients(surname, first_name) VALUES ('Loteski', 'Emmanuel'); 
INSERT INTO clients(surname, first_name) VALUES ('Pollan', 'Andrew'); 
INSERT INTO clients(surname, first_name) VALUES ('Gilbert', 'Marc'); 
INSERT INTO clients(surname, first_name) VALUES ('de Malataverne', 'Alienor');
INSERT INTO clients(surname, first_name) VALUES ('Verdirion', 'Louis'); 
INSERT INTO clients(surname, first_name) VALUES ('Pollien', 'Louis'); 
INSERT INTO clients(surname, first_name) VALUES ('Mascoran', 'Paolo'); 
INSERT INTO clients(surname, first_name) VALUES ('Mili', 'Romain'); 
INSERT INTO clients(surname, first_name) VALUES ('Zotti', 'Frederic'); 
INSERT INTO clients(surname, first_name) VALUES ('Poudil', 'Achille'); 
INSERT INTO clients(surname, first_name) VALUES ('Meillan', 'Alain'); 
INSERT INTO clients(surname, first_name) VALUES ('Azouf', 'Rudy'); 
INSERT INTO clients(surname, first_name) VALUES ('Bouaziz', 'Fatima'); 
INSERT INTO clients(surname, first_name) VALUES ('ben Ictini', 'Karim'); 
INSERT INTO clients(surname, first_name) VALUES ('Ostier', 'Paul'); 
INSERT INTO clients(surname, first_name) VALUES ('Ostier', 'Raymond'); 
INSERT INTO clients(surname, first_name) VALUES ('Jurief', 'Anna'); 
INSERT INTO clients(surname, first_name) VALUES ('Volvodi', 'Xavier'); 
INSERT INTO clients(surname, first_name) VALUES ('Rimitian', 'Denis'); 
INSERT INTO clients(surname, first_name) VALUES ('Kergan', 'Abby'); 
INSERT INTO clients(surname, first_name) VALUES ('Roden', 'Helmut'); 
INSERT INTO clients(surname, first_name) VALUES ('van Bellin', 'Pete'); 
INSERT INTO clients(surname, first_name) VALUES ('Barthez', 'Fabien'); 
INSERT INTO clients(surname, first_name) VALUES ('Pioline', 'Cedric'); 
INSERT INTO clients(surname, first_name) VALUES ('Dupont', 'Marcel'); 
INSERT INTO clients(surname, first_name) VALUES ('Rimitian', 'Justine'); 
INSERT INTO clients(surname, first_name) VALUES ('Laville', 'Annie'); 
INSERT INTO clients(surname, first_name) VALUES ('Laville', 'Pierre'); 
INSERT INTO clients(surname, first_name) VALUES ('Alberti', 'Jacques'); 
INSERT INTO clients(surname, first_name) VALUES ('Romanitta', 'Henri'); 
INSERT INTO clients(surname, first_name) VALUES ('de Rotian', 'Sebastien'); 
INSERT INTO clients(surname, first_name) VALUES ('Martinez', 'Benedicte'); 
INSERT INTO clients(surname, first_name) VALUES ('Thornton', 'Anny A.'); 
INSERT INTO clients(surname, first_name) VALUES ('Questide', 'Sophie'); 
INSERT INTO clients(surname, first_name) VALUES ('Polanski', 'Roman'); 
INSERT INTO clients(surname, first_name) VALUES ('Pisatier', 'Thibaut'); 
INSERT INTO clients(surname, first_name) VALUES ('Paternostre', 'Monique'); 
INSERT INTO clients(surname, first_name) VALUES ('Laville', 'Michel'); 
INSERT INTO clients(surname, first_name) VALUES ('Truguil', 'Charles'); 
INSERT INTO clients(surname, first_name) VALUES ('Nitials', 'Wolfgang'); 
INSERT INTO clients(surname, first_name) VALUES ('Grista', 'Milo'); 
INSERT INTO clients(surname, first_name) VALUES ('Kriski', 'Frederic'); 
INSERT INTO clients(surname, first_name) VALUES ('Mouline', 'Diane'); 
INSERT INTO clients(surname, first_name) VALUES ('Lersther', 'Mary'); 
INSERT INTO clients(surname, first_name) VALUES ('Kiskiz', 'Amine'); 
INSERT INTO clients(surname, first_name) VALUES ('Fregier', 'Roland'); 
INSERT INTO clients(surname, first_name) VALUES ('Hijou', 'Joachim'); 
INSERT INTO clients(surname, first_name) VALUES ('Smith', 'John'); 
INSERT INTO clients(surname, first_name) VALUES ('Cax', 'Perrine'); 
INSERT INTO clients(surname, first_name) VALUES ('Milou', 'Ali'); 
INSERT INTO clients(surname, first_name) VALUES ('Luengo', 'Alejandro'); 
INSERT INTO clients(surname, first_name) VALUES ('Sperin', 'Karim'); 
INSERT INTO clients(surname, first_name) VALUES ('Lutefinnal', 'Sheila'); 
INSERT INTO clients(surname, first_name) VALUES ('Bombeur', 'Jean'); 
INSERT INTO clients(surname, first_name) VALUES ('Pitivier', 'Annick'); 
INSERT INTO clients(surname, first_name) VALUES ('Litrampe', 'Bernard'); 
INSERT INTO clients(surname, first_name) VALUES ('Janvier', 'Louis'); 
INSERT INTO clients(surname, first_name) VALUES ('Ytera', 'Kevin'); 
INSERT INTO clients(surname, first_name) VALUES ('Lambeschi', 'Renato'); 
INSERT INTO clients(surname, first_name) VALUES ('Colonna', 'Marc'); 
INSERT INTO clients(surname, first_name) VALUES ('Chevenol', 'Jean-Pierre'); 
INSERT INTO clients(surname, first_name) VALUES ('Pliaid', 'Emilie'); 
INSERT INTO clients(surname, first_name) VALUES ('Pistre', 'Meredith'); 
INSERT INTO clients(surname, first_name) VALUES ('Jonas', 'Jean'); 
INSERT INTO clients(surname, first_name) VALUES ('Némarre', 'Jean'); 
INSERT INTO clients(surname, first_name) VALUES ('van Mazout', 'Anton'); 
INSERT INTO clients(surname, first_name) VALUES ('Auster', 'Paul'); 
INSERT INTO clients(surname, first_name) VALUES ('Lester', 'Claudia'); 
INSERT INTO clients(surname, first_name) VALUES ('Llianos', 'Maria'); 
INSERT INTO clients(surname, first_name) VALUES ('Vitalis', 'Jean'); 
INSERT INTO clients(surname, first_name) VALUES ('Bosali', 'Dimitri'); 
INSERT INTO clients(surname, first_name) VALUES ('Martin', 'Guillaume'); 
INSERT INTO clients(surname, first_name) VALUES ('mac Ferry', 'Simon'); 
INSERT INTO clients(surname, first_name) VALUES ('Cohen', 'Louis-Jean'); 
INSERT INTO clients(surname, first_name) VALUES ('Hergrand', 'Marie'); 
INSERT INTO clients(surname, first_name) VALUES ('Delgrange', 'Zoe'); 
INSERT INTO clients(surname, first_name) VALUES ('Filetti', 'François'); 
INSERT INTO clients(surname, first_name) VALUES ('Loussa', 'Azzedine'); 
INSERT INTO clients(surname, first_name) VALUES ('Cheik', 'Hera'); 
INSERT INTO clients(surname, first_name) VALUES ('Durand', 'Sebastien'); 
INSERT INTO clients(surname, first_name) VALUES ('Durand', 'Jean-Paul'); 
INSERT INTO clients(surname, first_name) VALUES ('Durant', 'Beatrice'); 
INSERT INTO clients(surname, first_name) VALUES ('Marik', 'Cecile'); 
INSERT INTO clients(surname, first_name) VALUES ('Genet', 'Lola'); 
INSERT INTO clients(surname, first_name) VALUES ('Milarier', 'Sauveur'); 
INSERT INTO clients(surname, first_name) VALUES ('Preak', 'L. William'); 
INSERT INTO clients(surname, first_name) VALUES ('Postman', 'Nancy'); 
INSERT INTO clients(surname, first_name) VALUES ('Filatti', 'Jil'); 
INSERT INTO clients(surname, first_name) VALUES ('Jivabbin', 'Laurent'); 
INSERT INTO clients(surname, first_name) VALUES ('Boiron', 'Chantal'); 
INSERT INTO clients(surname, first_name) VALUES ('Boiron', 'Matthieu'); 
INSERT INTO clients(surname, first_name) VALUES ('Hebert', 'Renaud'); 
INSERT INTO clients(surname, first_name) VALUES ('da Fierto', 'Marcello'); 
INSERT INTO clients(surname, first_name) VALUES ('de Souza', 'Linda'); 
INSERT INTO clients(surname, first_name) VALUES ('Garnier', 'Valerie'); 
INSERT INTO clients(surname, first_name) VALUES ('Garnier', 'Sidonie'); 
INSERT INTO clients(surname, first_name) VALUES ('Emika', 'Benoit'); 
INSERT INTO clients(surname, first_name) VALUES ('Farge', 'Loic'); 
INSERT INTO clients(surname, first_name) VALUES ('Moulin', 'Karine'); 
INSERT INTO clients(surname, first_name) VALUES ('Oubert', 'Catherine'); 
INSERT INTO clients(surname, first_name) VALUES ('Audibert', 'Florence'); 
INSERT INTO clients(surname, first_name) VALUES ('Sermonni', 'Isabelle'); 
INSERT INTO clients(surname, first_name) VALUES ('Boiron', 'Chantal'); 
INSERT INTO clients(surname, first_name) VALUES ('Milacci', 'Carmela'); 
INSERT INTO clients(surname, first_name) VALUES ('Hermann', 'Jacques'); 
INSERT INTO clients(surname, first_name) VALUES ('Poli', 'Pierre'); 
INSERT INTO clients(surname, first_name) VALUES ('Dasteron', 'Fabien'); 
INSERT INTO clients(surname, first_name) VALUES ('Zateur', 'Nicolas'); 
INSERT INTO clients(surname, first_name) VALUES ('Prieur', 'Ludivine'); 
INSERT INTO clients(surname, first_name) VALUES ('Meillan', 'Alain'); 
INSERT INTO clients(surname, first_name) VALUES ('Piporoux', 'Olivier'); 
INSERT INTO clients(surname, first_name) VALUES ('Schtrom', 'Carl'); 
INSERT INTO clients(surname, first_name) VALUES ('Novel', 'Linda'); 
INSERT INTO clients(surname, first_name) VALUES ('Pistan', 'Philippe'); 
INSERT INTO clients(surname, first_name) VALUES ('Boubayeur', 'Serge'); 
INSERT INTO clients(surname, first_name) VALUES ('Hackman', 'Sarah'); 
INSERT INTO clients(surname, first_name) VALUES ('Addal', 'Brice'); 
INSERT INTO clients(surname, first_name) VALUES ('Scotto', 'Lucie'); 
INSERT INTO clients(surname, first_name) VALUES ('Bonnet', 'Lila'); 
INSERT INTO clients(surname, first_name) VALUES ('Traff', 'Nelly'); 
INSERT INTO clients(surname, first_name) VALUES ('Costa', 'Luigi'); 
INSERT INTO clients(surname, first_name) VALUES ('Lusear', 'Prune'); 
INSERT INTO clients(surname, first_name) VALUES ('Loiseau', 'Caroline'); 
INSERT INTO clients(surname, first_name) VALUES ('Dupont', 'Jeanne'); 
INSERT INTO clients(surname, first_name) VALUES ('Molinard', 'Julien'); 
INSERT INTO clients(surname, first_name) VALUES ('Laville', 'Abelard'); 
INSERT INTO clients(surname, first_name) VALUES ('Puchon', 'Trevor'); 
INSERT INTO clients(surname, first_name) VALUES ('Pignon', 'François'); 
INSERT INTO clients(surname, first_name) VALUES ('Verber', 'Jean'); 
INSERT INTO clients(surname, first_name) VALUES ('de Manille', 'Capucine'); 
INSERT INTO clients(surname, first_name) VALUES ('Vonloti', 'Gatien'); 
INSERT INTO clients(surname, first_name) VALUES ('Lippo', 'Henri'); 
INSERT INTO clients(surname, first_name) VALUES ('Drideur', 'Marc'); 
INSERT INTO clients(surname, first_name) VALUES ('Polanski', 'Marilou'); 
INSERT INTO clients(surname, first_name) VALUES ('Utrine', 'Lucas'); 
INSERT INTO clients(surname, first_name) VALUES ('Voltane', 'Robert'); 
INSERT INTO clients(surname, first_name) VALUES ('Stouss', 'Nicolas'); 
INSERT INTO clients(surname, first_name) VALUES ('Questard', 'Pacome'); 
INSERT INTO clients(surname, first_name) VALUES ('Ploigne', 'Jeremie'); 
INSERT INTO clients(surname, first_name) VALUES ('Khol', 'Helmut'); 
INSERT INTO clients(surname, first_name) VALUES ('Hyann', 'Kevin'); 
INSERT INTO clients(surname, first_name) VALUES ('Molini', 'Emilio'); 
INSERT INTO clients(surname, first_name) VALUES ('Kiwlowski', 'Ann'); 
INSERT INTO clients(surname, first_name) VALUES ('Chalan', 'Pierrick'); 
INSERT INTO clients(surname, first_name) VALUES ('Meunier', 'Hector'); 
INSERT INTO clients(surname, first_name) VALUES ('Agier', 'Paul'); 
INSERT INTO clients(surname, first_name) VALUES ('Aubert', 'Veronique'); 
INSERT INTO clients(surname, first_name) VALUES ('Ampala', 'Lino'); 
INSERT INTO clients(surname, first_name) VALUES ('Griache', 'Georges'); 
INSERT INTO clients(surname, first_name) VALUES ('Griarche', 'Gus'); 
INSERT INTO clients(surname, first_name) VALUES ('Asquita', 'Florence'); 
INSERT INTO clients(surname, first_name) VALUES ('Prieur', 'Paul-Louis'); 
INSERT INTO clients(surname, first_name) VALUES ('Junssen', 'Ruth'); 
INSERT INTO clients(surname, first_name) VALUES ('van Blitte', 'Jurgen'); 
INSERT INTO clients(surname, first_name) VALUES ('M Bolo', 'Amedee'); 
INSERT INTO clients(surname, first_name) VALUES ('Tadogne', 'Brice'); 
INSERT INTO clients(surname, first_name) VALUES ('Loubier', 'Carl'); 
INSERT INTO clients(surname, first_name) VALUES ('Rifiuque', 'Anatole'); 


--
-- Rooms
--

-- Hotel l'excelsior (Nice)
INSERT INTO rooms VALUES (10, 1, 1, 'simple', 71);
INSERT INTO rooms VALUES (11, 1, 1, 'simple', 71);
INSERT INTO rooms VALUES (12, 1, 1, 'double', 88);
INSERT INTO rooms VALUES (13, 1, 1, 'simple', 62);
INSERT INTO rooms VALUES (20, 1, 2, 'double', 90);
INSERT INTO rooms VALUES (21, 1, 2, 'simple', 68);
INSERT INTO rooms VALUES (22, 1, 2, 'simple', 68);
INSERT INTO rooms VALUES (23, 1, 2, 'double', 89);
-- Hotel la nuit noire (Bordeaux)
INSERT INTO rooms VALUES (1, 2, 1, 'simple', 45);
INSERT INTO rooms VALUES (2, 2, 1, 'simple', 48);
INSERT INTO rooms VALUES (3, 2, 1, 'double', 71);
INSERT INTO rooms VALUES (4, 2, 1, 'simple', 54);
INSERT INTO rooms VALUES (5, 2, 2, 'double', 86);
INSERT INTO rooms VALUES (6, 2, 2, 'simple', 58);
INSERT INTO rooms VALUES (7, 2, 2, 'simple', 58);
INSERT INTO rooms VALUES (8, 2, 2, 'double', 86);
INSERT INTO rooms VALUES (9, 2, 3, 'suite', 160);
INSERT INTO rooms VALUES (10, 2, 3, 'suite', 165);
-- Hotel l'hotel de la gare (Bordeaux)
INSERT INTO rooms VALUES (101, 3, 1, 'simple', 32);
INSERT INTO rooms VALUES (102, 3, 1, 'simple', 32);
INSERT INTO rooms VALUES (103, 3, 1, 'simple', 33);
INSERT INTO rooms VALUES (201, 3, 2, 'simple', 32);
INSERT INTO rooms VALUES (202, 3, 2, 'simple', 32);
INSERT INTO rooms VALUES (203, 3, 2, 'simple', 33);
INSERT INTO rooms VALUES (301, 3, 3, 'simple', 34);
INSERT INTO rooms VALUES (302, 3, 3, 'simple', 34);
INSERT INTO rooms VALUES (303, 3, 3, 'simple', 34);
INSERT INTO rooms VALUES (401, 3, 4, 'double', 42);
INSERT INTO rooms VALUES (402, 3, 4, 'double', 42);
-- Hotel grand hotel (Nice)
INSERT INTO rooms VALUES ( 1, 4, 0, 'other', 130);
INSERT INTO rooms VALUES (11, 4, 1, 'simple', 84);
INSERT INTO rooms VALUES (12, 4, 1, 'simple', 84);
INSERT INTO rooms VALUES (13, 4, 1, 'simple', 86);
INSERT INTO rooms VALUES (14, 4, 1, 'simple', 90);
INSERT INTO rooms VALUES (21, 4, 2, 'double', 120);
INSERT INTO rooms VALUES (22, 4, 2, 'double', 130);
INSERT INTO rooms VALUES (31, 4, 3, 'triple', 145);
INSERT INTO rooms VALUES (32, 4, 3, 'simple', 90);
-- Hotel l'hotel chez soi (Lyon)
INSERT INTO rooms VALUES (1, 5, 0, 'triple', 70);
INSERT INTO rooms VALUES (2, 5, 1, 'simple', 40);
INSERT INTO rooms VALUES (3, 5, 1, 'double', 55);
-- Hotel l'hotel chez Philippe (Bordeaux)
INSERT INTO rooms VALUES (1, 6, 1, 'double', 60);
INSERT INTO rooms VALUES (2, 6, 1, 'double', 60);
INSERT INTO rooms VALUES (3, 6, 1, 'double', 60);
INSERT INTO rooms VALUES (4, 6, 2, 'double', 62);
INSERT INTO rooms VALUES (5, 6, 2, 'double', 62);
INSERT INTO rooms VALUES (6, 6, 2, 'double', 62);
-- Hotel l'hotel terminus (Bordeaux)
INSERT INTO rooms VALUES (10, 7, 1, 'simple', 31);
INSERT INTO rooms VALUES (11, 7, 1, 'simple', 31);
INSERT INTO rooms VALUES (12, 7, 1, 'double', 42);
INSERT INTO rooms VALUES (20, 7, 2, 'simple', 31);
INSERT INTO rooms VALUES (21, 7, 2, 'simple', 31);
INSERT INTO rooms VALUES (22, 7, 2, 'double', 42);
INSERT INTO rooms VALUES (30, 7, 3, 'simple', 31);
INSERT INTO rooms VALUES (31, 7, 3, 'simple', 31);
INSERT INTO rooms VALUES (32, 7, 3, 'double', 42);
INSERT INTO rooms VALUES (40, 7, 4, 'simple', 20);
INSERT INTO rooms VALUES (41, 7, 4, 'simple', 20);
INSERT INTO rooms VALUES (42, 7, 4, 'simple', 20);
INSERT INTO rooms VALUES (43, 7, 4, 'simple', 18);
INSERT INTO rooms VALUES (44, 7, 4, 'simple', 18);
-- Hotel l'hotel terminus (Grenoble)
INSERT INTO rooms VALUES (100, 8, 1, 'simple', 29);
INSERT INTO rooms VALUES (101, 8, 1, 'simple', 29);
INSERT INTO rooms VALUES (102, 8, 1, 'simple', 28);
INSERT INTO rooms VALUES (200, 8, 2, 'simple', 28);
INSERT INTO rooms VALUES (201, 8, 2, 'simple', 29);
INSERT INTO rooms VALUES (202, 8, 2, 'simple', 29);
INSERT INTO rooms VALUES (300, 8, 3, 'simple', 30);
INSERT INTO rooms VALUES (301, 8, 3, 'simple', 31);
INSERT INTO rooms VALUES (302, 8, 3, 'double', 37);
INSERT INTO rooms VALUES (401, 8, 4, 'double', 37);
INSERT INTO rooms VALUES (402, 8, 4, 'simple', 20);
-- Hotel l'hotel terminus (Nice)
INSERT INTO rooms VALUES (1, 9, 1, 'simple', 31);
INSERT INTO rooms VALUES (2, 9, 1, 'simple', 31);
INSERT INTO rooms VALUES (3, 9, 1, 'simple', 32);
INSERT INTO rooms VALUES (4, 9, 2, 'simple', 32);
INSERT INTO rooms VALUES (5, 9, 2, 'simple', 32);
INSERT INTO rooms VALUES (6, 9, 2, 'double', 48);
-- Hotel l'hotel des ambassadeurs (Grenoble)
INSERT INTO rooms VALUES (100, 10, 1, 'double', 97);
INSERT INTO rooms VALUES (101, 10, 1, 'double', 110);
INSERT INTO rooms VALUES (200, 10, 2, 'double', 97);
INSERT INTO rooms VALUES (201, 10, 2, 'double', 97);
INSERT INTO rooms VALUES (202, 10, 2, 'triple', 141);
-- Hotel l'hotel des voyageurs (Nice)
INSERT INTO rooms VALUES (1, 11, 0, 'simple', 78);
INSERT INTO rooms VALUES (2, 11, 0, 'simple', 78);
INSERT INTO rooms VALUES (3, 11, 0, 'simple', 78);
INSERT INTO rooms VALUES (4, 11, 0, 'simple', 78);
INSERT INTO rooms VALUES (5, 11, 0, 'simple', 78);
INSERT INTO rooms VALUES (6, 11, 0, 'simple', 78);
INSERT INTO rooms VALUES (7, 11, 0, 'simple', 78);
INSERT INTO rooms VALUES (8, 11, 0, 'simple', 78);
INSERT INTO rooms VALUES (9, 11, 0, 'simple', 78);
INSERT INTO rooms VALUES (10, 11, 0, 'simple', 78);
INSERT INTO rooms VALUES (11, 11, 0, 'simple', 78);
INSERT INTO rooms VALUES (12, 11, 0, 'double', 91);
INSERT INTO rooms VALUES (13, 11, 0, 'double', 91);
INSERT INTO rooms VALUES (14, 11, 1, 'double', 91);
INSERT INTO rooms VALUES (15, 11, 1, 'double', 91);
INSERT INTO rooms VALUES (16, 11, 1, 'simple', 77);
INSERT INTO rooms VALUES (17, 11, 1, 'simple', 77);
INSERT INTO rooms VALUES (18, 11, 1, 'simple', 77);
INSERT INTO rooms VALUES (19, 11, 1, 'simple', 77);
INSERT INTO rooms VALUES (20, 11, 1, 'simple', 77);
INSERT INTO rooms VALUES (21, 11, 1, 'simple', 75);
INSERT INTO rooms VALUES (22, 11, 1, 'simple', 75);
INSERT INTO rooms VALUES (23, 11, 1, 'simple', 75);
INSERT INTO rooms VALUES (24, 11, 1, 'double', 80);
INSERT INTO rooms VALUES (25, 11, 1, 'double', 80);
INSERT INTO rooms VALUES (26, 11, 1, 'double', 80);
INSERT INTO rooms VALUES (27, 11, 2, 'triple', 109);
INSERT INTO rooms VALUES (28, 11, 2, 'triple', 109);
INSERT INTO rooms VALUES (29, 11, 2, 'simple', 72);
INSERT INTO rooms VALUES (30, 11, 2, 'simple', 72);
INSERT INTO rooms VALUES (31, 11, 2, 'simple', 72);
INSERT INTO rooms VALUES (32, 11, 2, 'simple', 72);
-- Hotel grand hotel (Grenoble)
INSERT INTO rooms VALUES (101, 12, 1, 'double', 130);
INSERT INTO rooms VALUES (102, 12, 1, 'double', 130);
INSERT INTO rooms VALUES (103, 12, 1, 'double', 130);
INSERT INTO rooms VALUES (104, 12, 1, 'double', 130);
INSERT INTO rooms VALUES (105, 12, 1, 'double', 130);
INSERT INTO rooms VALUES (106, 12, 1, 'double', 145);
INSERT INTO rooms VALUES (107, 12, 1, 'double', 145);
INSERT INTO rooms VALUES (201, 12, 2, 'double', 145);
INSERT INTO rooms VALUES (202, 12, 2, 'double', 145);
INSERT INTO rooms VALUES (203, 12, 2, 'double', 118);
INSERT INTO rooms VALUES (204, 12, 2, 'double', 118);
INSERT INTO rooms VALUES (205, 12, 2, 'double', 130);
INSERT INTO rooms VALUES (206, 12, 2, 'double', 145);
INSERT INTO rooms VALUES (207, 12, 2, 'double', 145);
INSERT INTO rooms VALUES (301, 12, 3, 'suite', 195);
INSERT INTO rooms VALUES (302, 12, 3, 'suite', 195);
INSERT INTO rooms VALUES (303, 12, 3, 'suite', 195);


--
-- Occupancies
--
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (1,2,9, DATE('2014-04-10'), DATE('2014-04-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (8,2,4, DATE('2014-04-08'), DATE('2014-03-28'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (11,2,1, DATE('2014-04-22'), DATE('2014-03-30'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (13,2,5, DATE('2014-04-21'), DATE('2014-03-27'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (16,1,10, DATE('2014-04-04'), DATE('2014-03-25'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (21,1,11, DATE('2014-04-02'), DATE('2014-03-12'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (22,1,12, DATE('2014-04-11'), DATE('2014-04-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (26,1,13, DATE('2014-04-10'), DATE('2014-04-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (27,1,20, NULL, DATE('2014-03-10'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (33,1,21, NULL, DATE('2014-03-10'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (35,1,22, DATE('2014-05'), DATE('2014-03-27'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (42,1,23, DATE('2014-05-01'), DATE('2014-03-30'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (43,3,102, DATE('2014-04-14'), DATE('2014-03-24'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (48,3,103, DATE('2014-04-15'), DATE('2014-03-31'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (49,3,202, DATE('2014-04-08'), DATE('2014-04-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (56,3,301, NULL, DATE('2014-03-10'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (58,3,302, DATE('2014-04-21'), DATE('2014-04-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (66,3,401, DATE('2014-04-09'), DATE('2014-03-22'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (67,4,1, DATE('2014-04-11'), DATE('2014-03-29'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (72,4,22, DATE('2014-04-10'), DATE('2014-03-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (73,4,31, DATE('2014-04-08'), DATE('2014-04-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (77,4,11, NULL, DATE('2014-03-31'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (78,5,1, DATE('2014-04-20'), DATE('2014-04-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (81,6,1, DATE('2014-05-05'), DATE('2014-03-22'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (82,6,2, NULL, DATE('2014-03-27'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (85,6,3, DATE('2014-04-12'), DATE('2014-03-18'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (87,6,4, DATE('2014-04-06'), DATE('2014-04-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (89,6,5, DATE('2014-04-05'), DATE('2014-03-30'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (93,6,6, DATE('2014-04-11'), DATE('2014-03-31'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (94,7,11, DATE('2014-04-12'), DATE('2014-04-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (96,7,12, DATE('2014-04-04'), DATE('2014-03-25'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (97,7,20, DATE('2014-04-02'), DATE('2014-03-25'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (99,7,21, DATE('2014-04-20'), DATE('2014-03-26'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (100,8,101, DATE('2014-04-21'), DATE('2014-03-31'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (102,8,102, DATE('2014-04-05'), DATE('2014-03-19'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (105,8,300, DATE('2014-04-09'), DATE('2014-03-13'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (107,9,1, DATE('2014-04-19'), DATE('2014-03-15'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (108,9,5, DATE('2014-04-04'), DATE('2014-04-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (110,9,6, DATE('2014-04-05'), DATE('2014-03-26'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (112,10,101, DATE('2014-04-08'), DATE('2014-03-26'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (113,10,200, DATE('2014-04-10'), DATE('2014-03-30'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (115,10,201, DATE('2014-04-13'), DATE('2014-03-31'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (118,10,202, DATE('2014-04-06'), DATE('2014-03-30'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (120,11,4, DATE('2014-04-09'), DATE('2014-03-30'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (122,11,5, DATE('2014-04-06'), DATE('2014-03-26'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (123,11,6, DATE('2014-04-10'), DATE('2014-03-21'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (127,11,7, DATE('2014-04-11'), DATE('2014-04-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (130,11,8, DATE('2014-04-12'), DATE('2014-04-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (132,11,10, DATE('2014-04-05'), DATE('2014-03-28'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (135,11,16, DATE('2014-04-11'), DATE('2014-03-28'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (137,11,27, DATE('2014-04-05'), DATE('2014-03-25'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (140,11,31, DATE('2014-04-05'), DATE('2014-03-24'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (141,12,101, DATE('2014-04-02'), DATE('2014-03-29'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (144,12,105, DATE('2014-04-07'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (146,12,107, DATE('2014-04-07'), DATE('2014-03-21'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (149,12,202, DATE('2014-04-10'), DATE('2014-04-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (150,12,206, DATE('2014-04-27'), DATE('2014-03-30'));
-- Past occupancies
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (1,5,2, DATE('2014-03-30'), DATE('2014-03-24'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (2,5,1, DATE('2014-04-01'), DATE('2014-03-28'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (2,5,1, DATE('2014-03-22'), DATE('2014-03-15'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (2,5,3, DATE('2014-03-10'), DATE('2014-03-03'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (3,5,2, DATE('2014-03-24'), DATE('2014-03-23'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (34,5,3, DATE('2014-03-14'), DATE('2014-03-12'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (142,5,1, DATE('2014-03-25'), DATE('2014-03-23'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (2,2,4, DATE('2014-03-27'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (3,2,1, DATE('2014-03-23'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (3,2,1, DATE('2014-03-14'), DATE('2014-03-11'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (4,2,1, DATE('2014-03-11'), DATE('2014-03-07'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (5,2,1, DATE('2014-03-05'), DATE('2014-03-03'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (6,2,1, DATE('2014-03-02'), DATE('2014-03-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (6,2,2, DATE('2014-03-26'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (9,2,2, DATE('2014-03-26'), DATE('2014-03-23'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (10,2,3, DATE('2014-03-27'), DATE('2014-03-25'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (12,2,3, DATE('2014-04-01'), DATE('2014-03-28'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (12,2,3, DATE('2014-03-15'), DATE('2014-03-05'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (94,2,5, DATE('2014-03-18'), DATE('2014-03-12'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (14,2,6, DATE('2014-04-01'), DATE('2014-03-30'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (15,2,6, DATE('2014-03-29'), DATE('2014-03-22'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (14,2,6, DATE('2014-03-22'), DATE('2014-03-15'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (17,2,8, DATE('2014-03-29'), DATE('2014-03-26'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (17,2,8, DATE('2014-03-19'), DATE('2014-03-18'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (18,2,9, DATE('2014-03-30'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (108,2,9, DATE('2014-03-19'), DATE('2014-03-18'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (108,2,9, DATE('2014-03-10'), DATE('2014-03-03'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (19,2,10, DATE('2014-03-31'), DATE('2014-03-15'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (96,2,10, DATE('2014-03-13'), DATE('2014-03-12'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (100,3,101, DATE('2014-03-27'), DATE('2014-03-25'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (19,3,101, DATE('2014-04-01'), DATE('2014-03-29'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (35,3,102, DATE('2014-03-24'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (26,3,103, DATE('2014-03-29'), DATE('2014-03-11'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (20,3,103, DATE('2014-03-11'), DATE('2014-03-10'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (26,3,103, DATE('2014-03-08'), DATE('2014-03-06'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (23,3,201, DATE('2014-03-10'), DATE('2014-03-09'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (23,3,201, DATE('2014-03-23'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (24,3,202, DATE('2014-03-27'), DATE('2014-03-13'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (25,3,203, DATE('2014-03-28'), DATE('2014-03-27'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (130,3,203, DATE('2014-03-24'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (35,3,301, DATE('2014-03-03'), DATE('2014-03-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (20,3,301, DATE('2014-03-05'), DATE('2014-03-03'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (28,3,301, DATE('2014-03-09'), DATE('2014-03-06'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (20,3,302, DATE('2014-03-27'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (28,3,303, DATE('2014-03-17'), DATE('2014-03-12'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (29,3,401, DATE('2014-03-22'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (30,3,402, DATE('2014-03-18'), DATE('2014-03-17'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (31,3,402, DATE('2014-03-25'), DATE('2014-03-21'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (32,3,402, DATE('2014-03-05'), DATE('2014-03-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (36,4,1, DATE('2014-03-27'), DATE('2014-03-25'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (67,4,1, DATE('2014-03-13'), DATE('2014-03-12'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (37,4,11, DATE('2014-03-30'), DATE('2014-03-27'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (37,4,11, DATE('2014-03-14'), DATE('2014-03-13'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (39,4,13, DATE('2014-03-27'), DATE('2014-03-12'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (38,4,14, DATE('2014-03-21'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (39,4,21, DATE('2014-03-31'), DATE('2014-03-30'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (40,4,21, DATE('2014-03-29'), DATE('2014-03-23'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (41,4,21, DATE('2014-03-22'), DATE('2014-03-21'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (44,4,22, DATE('2014-03-27'), DATE('2014-03-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (45,4,31, DATE('2014-04-01'), DATE('2014-03-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (46,4,32, DATE('2014-04-01'), DATE('2014-03-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (120,6,1, DATE('2014-03-25'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (47,6,1, DATE('2014-03-20'), DATE('2014-03-18'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (50,6,2, DATE('2014-03-25'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (50,6,2, DATE('2014-03-15'), DATE('2014-03-14'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (51,6,3, DATE('2014-03-18'), DATE('2014-03-17'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (52,6,4, DATE('2014-03-28'), DATE('2014-03-11'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (53,6,5, DATE('2014-03-21'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (87,6,5, DATE('2014-03-20'), DATE('2014-03-17'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (54,6,6, DATE('2014-03-25'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (55,6,6, DATE('2014-03-20'), DATE('2014-03-19'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (57,6,6, DATE('2014-03-19'), DATE('2014-03-12'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (87,6,6, DATE('2014-03-12'), DATE('2014-03-05'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (51,6,6, DATE('2014-03-04'), DATE('2014-03-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (78,7,10, DATE('2014-03-25'), DATE('2014-03-24'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (73,7,10, DATE('2014-03-23'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (74,7,11, DATE('2014-03-25'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (75,7,21, DATE('2014-03-21'), DATE('2014-03-13'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (54,7,21, DATE('2014-03-12'), DATE('2014-03-08'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (76,7,22, DATE('2014-03-22'), DATE('2014-03-14'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (77,7,30, DATE('2014-03-21'), DATE('2014-03-12'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (79,7,31, DATE('2014-03-15'), DATE('2014-03-14'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (78,7,32, DATE('2014-03-10'), DATE('2014-03-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (74,7,32, DATE('2014-03-18'), DATE('2014-03-11'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (80,7,40, DATE('2014-03-24'), DATE('2014-03-21'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (83,7,41, DATE('2014-03-24'), DATE('2014-03-21'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (83,8,100, DATE('2014-04-01'), DATE('2014-03-28'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (84,8,100, DATE('2014-03-17'), DATE('2014-03-11'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (86,8,101, DATE('2014-03-30'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (88,8,101, DATE('2014-03-20'), DATE('2014-03-19'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (90,8,101, DATE('2014-03-17'), DATE('2014-03-10'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (80,8,102, DATE('2014-03-18'), DATE('2014-03-11'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (91,8,102, DATE('2014-03-11'), DATE('2014-03-02'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (92,8,200, DATE('2014-04-01'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (95,8,201, DATE('2014-03-27'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (98,8,202, DATE('2014-03-27'), DATE('2014-03-22'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (101,8,300, DATE('2014-03-12'), DATE('2014-03-08'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (94,8,300, DATE('2014-03-07'), DATE('2014-03-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (103,8,301, DATE('2014-03-30'), DATE('2014-03-25'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (104,8,401, DATE('2014-03-27'), DATE('2014-03-13'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (43,9,1, DATE('2014-03-14'), DATE('2014-03-10'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (103,9,1, DATE('2014-03-10'), DATE('2014-03-07'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (106,9,2, DATE('2014-03-31'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (106,9,2, DATE('2014-03-16'), DATE('2014-03-15'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (91,9,3, DATE('2014-04-01'), DATE('2014-03-12'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (92,9,4, DATE('2014-03-19'), DATE('2014-03-17'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (109,9,5, DATE('2014-03-31'), DATE('2014-03-30'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (111,9,5, DATE('2014-03-30'), DATE('2014-03-29'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (114,9,5, DATE('2014-03-29'), DATE('2014-03-28'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (111,9,5, DATE('2014-03-27'), DATE('2014-03-25'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (109,9,6, DATE('2014-03-25'), DATE('2014-03-11'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (116,10,100, DATE('2014-03-31'), DATE('2014-03-30'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (114,10,100, DATE('2014-03-27'), DATE('2014-03-22'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (83,10,101, DATE('2014-03-14'), DATE('2014-03-13'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (117,10,200, DATE('2014-03-30'), DATE('2014-03-23'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (116,10,200, DATE('2014-03-22'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (80,10,201, DATE('2014-03-09'), DATE('2014-03-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (76,10,202, DATE('2014-03-12'), DATE('2014-03-10'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (119,11,1, DATE('2014-04-01'), DATE('2014-03-23'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (103,11,1, DATE('2014-03-22'), DATE('2014-03-11'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (121,11,2, DATE('2014-03-28'), DATE('2014-03-27'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (124,11,2, DATE('2014-03-27'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (125,11,3, DATE('2014-03-29'), DATE('2014-03-23'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (83,11,3, DATE('2014-03-10'), DATE('2014-03-04'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (43,11,3, DATE('2014-03-04'), DATE('2014-03-03'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (125,11,3, DATE('2014-03-03'), DATE('2014-03-02'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (126,11,3, DATE('2014-03-02'), DATE('2014-03-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (126,11,4, DATE('2014-03-30'), DATE('2014-03-24'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (128,11,4, DATE('2014-03-23'), DATE('2014-03-16'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (129,11,5, DATE('2014-03-22'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (131,11,6, DATE('2014-03-20'), DATE('2014-03-18'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (133,11,6, DATE('2014-03-17'), DATE('2014-03-15'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (131,11,6, DATE('2014-03-13'), DATE('2014-03-02'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (134,11,8, DATE('2014-03-29'), DATE('2014-03-23'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (138,11,8, DATE('2014-03-22'), DATE('2014-03-21'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (139,11,9, DATE('2014-04-01'), DATE('2014-03-06'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (128,11,9, DATE('2014-03-05'), DATE('2014-03-04'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (128,11,9, DATE('2014-03-03'), DATE('2014-03-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (143,11,10, DATE('2014-03-27'), DATE('2014-03-26'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (145,11,10, DATE('2014-03-23'), DATE('2014-03-19'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (147,11,10, DATE('2014-03-18'), DATE('2014-03-13'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (148,11,11, DATE('2014-03-31'), DATE('2014-03-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (149,11,12, DATE('2014-03-29'), DATE('2014-03-21'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (150,11,12, DATE('2014-03-20'), DATE('2014-03-17'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (151,11,12, DATE('2014-03-12'), DATE('2014-03-04'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (152,11,13, DATE('2014-03-27'), DATE('2014-03-04'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (74,11,13, DATE('2014-03-03'), DATE('2014-03-02'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (22,11,14, DATE('2014-03-28'), DATE('2014-03-10'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (153,11,15, DATE('2014-03-29'), DATE('2014-03-05'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (154,11,16, DATE('2014-03-14'), DATE('2014-03-11'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (155,11,17, DATE('2014-03-28'), DATE('2014-03-11'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (156,11,18, DATE('2014-03-25'), DATE('2014-03-15'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (157,11,19, DATE('2014-03-31'), DATE('2014-03-01'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (158,11,20, DATE('2014-04-01'), DATE('2014-03-29'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (159,11,20, DATE('2014-03-27'), DATE('2014-03-06'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (160,11,21, DATE('2014-03-30'), DATE('2014-03-29'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (154,11,21, DATE('2014-03-28'), DATE('2014-03-22'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (161,11,21, DATE('2014-03-22'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (162,11,23, DATE('2014-03-11'), DATE('2014-03-04'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (161,11,25, DATE('2014-03-12'), DATE('2014-03-06'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (163,11,25, DATE('2014-03-16'), DATE('2014-03-13'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (164,11,26, DATE('2014-03-30'), DATE('2014-03-28'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (165,11,27, DATE('2014-03-13'), DATE('2014-03-12'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (166,11,28, DATE('2014-03-27'), DATE('2014-03-11'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (162,11,30, DATE('2014-03-22'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (167,11,30, DATE('2014-03-31'), DATE('2014-03-15'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (168,11,30, DATE('2014-03-12'), DATE('2014-03-11'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (169,11,31, DATE('2014-03-27'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (170,11,31, DATE('2014-03-21'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (171,11,32, DATE('2014-03-30'), DATE('2014-03-21'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (172,12,101, DATE('2014-03-26'), DATE('2014-03-11'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (173,12,101, DATE('2014-03-10'), DATE('2014-03-08'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (174,12,102, DATE('2014-04-01'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (175,12,103, DATE('2014-03-21'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (176,12,106, DATE('2014-03-20'), DATE('2014-03-10'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (22,12,106, DATE('2014-03-08'), DATE('2014-03-07'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (177,12,107, DATE('2014-03-17'), DATE('2014-03-11'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (178,12,202, DATE('2014-03-30'), DATE('2014-03-24'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (179,12,202, DATE('2014-03-23'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (179,12,202, DATE('2014-03-12'), DATE('2014-03-11'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (177,12,203, DATE('2014-03-25'), DATE('2014-03-24'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (42,12,203, DATE('2014-03-21'), DATE('2014-03-20'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (23,12,204, DATE('2014-03-12'), DATE('2014-03-11'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (178,12,204, DATE('2014-03-09'), DATE('2014-03-05'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (23,12,205, DATE('2014-03-28'), DATE('2014-03-26'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (8,12,206, DATE('2014-03-28'), DATE('2014-03-23'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (42,12,206, DATE('2014-03-17'), DATE('2014-03-14'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (11,12,207, DATE('2014-03-29'), DATE('2014-03-03'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (49,12,301, DATE('2014-03-26'), DATE('2014-03-24'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (100,12,301, DATE('2014-03-22'), DATE('2014-03-16'));
INSERT INTO occupancies(client_id, hotel_id, room_id, date_to, date_from) VALUES (58,12,302, DATE('2014-03-27'), DATE('2014-03-18'));


--
-- Bookings
--
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (1,5,1,DATE('2014-05-11'), DATE('2014-05-15'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (2,5,2,DATE('2014-04-11'), DATE('2014-04-18'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (6,5,2,DATE('2014-04-05'), DATE('2014-04-06'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (6,7,30,DATE('2014-03-29'), DATE('2014-05-01'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (6,10,100,DATE('2014-06-11'), DATE('2014-06-14'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (13,6,2,DATE('2014-05-02'), DATE('2014-05-10'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (14,6,2,DATE('2014-03-28'), DATE('2014-05-01'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (14,4,21,DATE('2014-05-12'), DATE('2014-05-13'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (23,6,1,DATE('2014-05-04'), DATE('2014-05-09'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (28,8,100,DATE('2014-04-30'), DATE('2014-05-03'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (28,9,3,DATE('2014-04-13'), DATE('2014-04-14'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (107,8,301,DATE('2014-05-01'), DATE('2014-05-03'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (108,9,2,DATE('2014-05-03'), DATE('2014-05-20'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (94,9,3,DATE('2014-04-15'), DATE('2014-04-20'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (92,11,8,DATE('2014-05-09'), DATE('2014-05-10'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (80,11,9,DATE('2014-04-06'), DATE('2014-04-08'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (82,11,7,DATE('2014-05-07'), DATE('2014-05-12'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (47,11,20,DATE('2014-04-04'), DATE('2014-04-08'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (44,11,5,DATE('2014-04-07'), DATE('2014-05-07'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (40,11,9,DATE('2014-04-11'), DATE('2014-04-14'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (40,2,8,DATE('2014-05-01'), DATE('2014-05-05'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (40,1,23,DATE('2014-05-09'), DATE('2014-05-13'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (116,11,25,DATE('2014-04-04'), DATE('2014-04-05'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (120,11,25,DATE('2014-04-22'), DATE('2014-04-26'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (129,11,1,DATE('2014-04-04'), DATE('2014-04-08'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (129,12,205,DATE('2014-05-04'), DATE('2014-05-09'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (142,12,101,DATE('2014-04-04'), DATE('2014-06-06'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (142,5,2,DATE('2014-05-17'), DATE('2014-05-23'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (142,6,2,DATE('2014-05-27'), DATE('2014-06-02'));
INSERT INTO bookings(client_id, hotel_id, room_id, date_from, date_to) VALUES (148,12,202,DATE('2014-05-11'), DATE('2014-05-18'));

