 ('Incitation à la haine raciale', 5),
 ('Publication de contenu illicite', 5),
 ('Insulte', 3),
-('Spam', 1),
-('Mochitude', 999);
+('Spam', 1);
 
 INSERT INTO `reports` (`user`, `reason`, `reported_by`, `reported_at`) VALUES 
 (3, 3, 2, '2017-07-13 14:37:56'),
 (3, 2, 2, '2017-07-13 19:22:03'),
-(2, 5, 3, '2017-07-13 23:05:04');
+(2, 4, 3, '2017-07-13 23:05:04');
 
 INSERT INTO `actions` (`user`, `action`, `action_by`, `action_at`) VALUES 
 (3, 'warn', 1, '2017-07-13 14:41:18'),

);	

CREATE TABLE `excluded` (
	`user` INT NOT NULL,
	`room` INT NOT NULL,
	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 `loans` (`user`, `item`, `status`) VALUES 
(7, 1, 1),
(7, 2, 2),
(7, 3, 3);

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');

INSERT INTO `rooms` (`name`, `admin`, `item`, `start_date`, `end_date`, `active`) VALUES 
('Salon test', 1, 1, '2017-07-10', '2017-07-24', 1),
('Salon test', 1, 3, '2017-07-10', '2017-07-24', 1),
('Salon test5', 2, 5, '2017-07-10', '2017-07-24', 0),
('Salon test6', 6, 4, '2017-07-10', '2017-07-24', 0),
('Salon test7', 7, 6, '2017-07-10', '2017-07-24', 0);
