 );	
 
 CREATE TABLE `excluded` (
-	`user` INT NOT NULL,
-	`room` INT NOT NULL,
-	FOREIGN KEY (`user`) REFERENCES `users`(`id`),
-	FOREIGN KEY (`room`) REFERENCES `rooms`(`id`)
+ `user` INT NOT NULL,
+ `room` INT NOT NULL,
+ PRIMARY KEY (`id`, `room`),
+ FOREIGN KEY (`user`) REFERENCES `users`(`id`),
+ FOREIGN KEY (`room`) REFERENCES `rooms`(`id`)
 );
 
 CREATE TABLE `parameters` (

INSERT INTO `loan_status` (`name`, `color`) VALUES 
('Disponible', '#4CAF50'), ('Prêté', '#F44336'), ('Je le veux', '#2196F3');

INSERT INTO `parameters` (`key`, `value`) VALUES 
('home_concept', 'Lorem Ipsum'),
('home_highlights', '1|0|1|0|0|1');

INSERT INTO `pages` (`name`, `label`, `title`, `text`) VALUES 
('qui-sommes-nous', 'Qui sommes nous ?', 'Le Club des Critiques !', 'Nous s\'appelle Groot');
('banned', 'Banni');

INSERT INTO `users` (`ip_address`, `username`, `password`, `email`, `created_on`, `active`, `first_name`, `last_name`, `description`) VALUES
('127.0.0.1', 'Administrateur', '$2a$07$SeBknntpZror9uyftVopmu61qg0ms8Qv1yV6FG.kQOSM.9QhmTo36', 'admin@mail.com', '1268889823', '1', 'Jean-Michel', 'L\'Admin', 'Le Club des Critiques'),
('127.0.0.1', 'Serge', '$2a$07$SeBknntpZror9uyftVopmu61qg0ms8Qv1yV6FG.kQOSM.9QhmTo36', 'leo.foltzrahem@gmail.com', '1268889823', '1', 'Juanita', 'Banana', 'Fan de Henry Salvador'),
('127.0.0.1', 'Neo', '$2a$07$SeBknntpZror9uyftVopmu61qg0ms8Qv1yV6FG.kQOSM.9QhmTo36', 'yoann.flegeau@yahoo.com', '1268889823', '1', 'Shawn', 'Shawn', 'Cavalier'),
('127.0.0.1', 'Pedro', '$2a$07$SeBknntpZror9uyftVopmu61qg0ms8Qv1yV6FG.kQOSM.9QhmTo36', 'pedro@mail.com', '1268889823', '1', 'Pedro', 'Foot', 'Partie d\'un joueur de foot'),
('127.0.0.1', 'Miguel', '$2a$07$SeBknntpZror9uyftVopmu61qg0ms8Qv1yV6FG.kQOSM.9QhmTo36', 'miguel@mail.com', '1268889823', '1', 'Miguel', 'Foot', 'Partie d\'un joueur de foot'),
('127.0.0.1', 'Pauleta', '$2a$07$SeBknntpZror9uyftVopmu61qg0ms8Qv1yV6FG.kQOSM.9QhmTo36', 'pauleta@mail.com', '1268889823', '1', 'Pauleta ', 'Foot', 'Partie d\'un joueur de foot'),
('127.0.0.1', 'Eddie Malou', '$2a$07$SeBknntpZror9uyftVopmu61qg0ms8Qv1yV6FG.kQOSM.9QhmTo36', 'edie.malou@mail.com', '1268889823', '1', 'Edie', 'Malou', 'Philosophe');

INSERT INTO `users_groups` (`user_id`, `group_id`) VALUES 
(1, 1), (2, 3), (3, 4), (4, 2), (5, 2), (6, 2), (7, 2);
