CREATE DATABASE if not exists `poj` COLLATE 'utf8_general_ci';
USE `poj`;

DROP TABLE IF EXISTS `reservation`;
CREATE TABLE `reservation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idC` int(11) DEFAULT NULL,
  `nbChambres` int(11) NOT NULL,
  `dateDebut` date NOT NULL,
  `nbJour` int(11) DEFAULT NULL,
  `categorie` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=498 DEFAULT CHARSET=utf8;

INSERT INTO `reservation` (`id`, `idC`, `nbChambres`, `dateDebut`, `nbJour`, `categorie`) VALUES
(64,	NULL,	2,	'2018-10-20',	NULL,	'premium'),
(71,	NULL,	2,	'2018-10-20',	NULL,	'premium'),
(78,	NULL,	2,	'2018-08-10',	NULL,	'premium'),
(85,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(92,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(99,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(106,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(113,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(120,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(127,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(134,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(141,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(148,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(155,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(162,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(169,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(176,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(183,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(190,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(197,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(204,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(211,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(218,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(225,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(232,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(239,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(246,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(253,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(260,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(267,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(274,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(281,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(288,	NULL,	1,	'2018-08-10',	NULL,	'premium'),
(295,	NULL,	2,	'2018-08-10',	NULL,	'luxe'),
(302,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(309,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(316,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(323,	NULL,	4,	'2018-08-12',	NULL,	'confort'),
(330,	NULL,	3,	'2018-07-12',	NULL,	'luxe'),
(337,	NULL,	1,	'2018-05-12',	NULL,	'confort'),
(344,	NULL,	2,	'2018-08-10',	NULL,	'premium'),
(351,	NULL,	3,	'2018-07-12',	NULL,	'luxe'),
(358,	NULL,	1,	'2018-05-12',	NULL,	'confort'),
(365,	NULL,	2,	'2018-08-10',	NULL,	'premium'),
(372,	NULL,	3,	'2018-07-12',	NULL,	'luxe'),
(379,	NULL,	1,	'2018-05-12',	NULL,	'confort'),
(386,	NULL,	2,	'2018-08-10',	NULL,	'premium'),
(393,	NULL,	3,	'2018-07-12',	NULL,	'luxe'),
(400,	NULL,	1,	'2018-05-12',	NULL,	'confort'),
(407,	NULL,	2,	'2018-08-10',	NULL,	'premium'),
(414,	NULL,	3,	'2018-07-12',	NULL,	'luxe'),
(421,	NULL,	1,	'2018-05-12',	NULL,	'confort'),
(428,	NULL,	2,	'2018-08-10',	NULL,	'premium'),
(435,	NULL,	3,	'2018-07-12',	NULL,	'luxe'),
(442,	NULL,	1,	'2018-05-12',	NULL,	'confort'),
(449,	NULL,	2,	'2018-08-10',	NULL,	'premium'),
(456,	NULL,	3,	'2018-07-12',	NULL,	'luxe'),
(463,	NULL,	1,	'2018-05-12',	NULL,	'confort'),
(470,	NULL,	2,	'2018-08-10',	NULL,	'premium'),
(477,	NULL,	3,	'2018-07-12',	NULL,	'luxe'),
(484,	NULL,	1,	'2018-05-12',	NULL,	'confort'),
(491,	NULL,	2,	'2018-08-10',	NULL,	'premium');