


DELETE FROM service;
ALTER TABLE service AUTO_INCREMENT = 1;
INSERT INTO service (name) VALUES ('STAT-LOC');                 -- 1
INSERT INTO service (name) VALUES ('CHIFFRE-AFFAIRE');          -- 2
INSERT INTO service (name) VALUES ('INDICATEUR-WRITE');         -- 3
INSERT INTO service (name) VALUES ('INDICATEUR-READ');          -- 4
INSERT INTO service (name) VALUES ('AGENDA-BE');                -- 5
INSERT INTO service (name) VALUES ('TAB-RMA');                  -- 6
INSERT INTO service (name) VALUES ('TAB-RMA-ADMIN');            -- 7
INSERT INTO service (name) VALUES ('TAB-RMA-ADMIN-LIGHT');      -- 8
INSERT INTO service (name) VALUES ('TAB-LOC');                  -- 9
INSERT INTO service (name) VALUES ('TAB-LOC-ADMIN');            -- 10
INSERT INTO service (name) VALUES ('TAB-CERTIF');               -- 11
INSERT INTO service (name) VALUES ('MODIFY-CERTIF');            -- 12
INSERT INTO service (name) VALUES ('DELETE-CERTIF');            -- 13
INSERT INTO service (name) VALUES ('ADD-NOTICE');               -- 14
INSERT INTO service (name) VALUES ('DELETE-NOTICE');            -- 15
INSERT INTO service (name) VALUES ('SUIVI-LOCATION');           -- 16
INSERT INTO service (name) VALUES ('GESTION-APP');              -- 17
INSERT INTO service (name) VALUES ('DATE-CERTIF');              -- 18
INSERT INTO service (name) VALUES ('RMA-RECEPTION');            -- 19
INSERT INTO service (name) VALUES ('SUIVI-LOCATION-CLIENT');     -- 20
INSERT INTO service (name) VALUES ('TAB-RMA-CLIENT');           -- 21
INSERT INTO service (name) VALUES ('DEMO');                     -- 22

DELETE FROM user_service;
-- ADMIN
INSERT INTO user_service (user_id, service_id) VALUES (1,1),(1,2),(1,4),(1,5),(1,8),(1,9),(1,10),(1,11),(1,12),(1,17), (1,12),(1,19);
-- NICOLAS
INSERT INTO user_service (user_id, service_id) VALUES (11,1),(11,2),(11,4),(11,18);
-- YOHAN
INSERT INTO user_service (user_id, service_id) VALUES (2,1),(2,2),(2,4),(2,5),(2,10),(2,11),(2,12),(2,19);
-- nmakni, viffouzar, tfrauenfelder, abenedetti
INSERT INTO user_service (user_id, service_id) VALUES (3,2),(3,4),(3,5),(3,11),(3,15),(3,18);
INSERT INTO user_service (user_id, service_id) VALUES (21,2),(21,4),(21,5),(21,11),(21,15),(21,18);
INSERT INTO user_service (user_id, service_id) VALUES (71,2),(71,4),(71,5),(71,11),(71,15),(71,18);
INSERT INTO user_service (user_id, service_id) VALUES (43,2),(43,4),(43,5),(43,11),(43,15),(43,18);
-- pderesende, ltosalli
INSERT INTO user_service (user_id, service_id) VALUES (4,4),(4,5),(4,18);
INSERT INTO user_service (user_id, service_id) VALUES (15,4),(15,5),(15,11),(15,18),(15,20);
-- mmagnard
INSERT INTO user_service (user_id, service_id) VALUES (9,4),(9,18);
-- sbert
INSERT INTO user_service (user_id, service_id) VALUES (14,1),(14,2),(14,4),(14,11),(14,15),(14,19);
-- user de démo de l'agenda et des rma - yohansaussier@gmail.com Fhj3JZxf7V
INSERT INTO user_service (user_id, service_id) VALUES (72,14);

