delete from users;
delete from parkings;
delete from trafficobstructions;
delete from streets;
delete from numbers;

insert into Users (email,password,notification)

values
('antoine@hotmail.com','aaaa123',1),
('lucien@gmail.com','bbb456',1),
('maxime@gotmail.com','ccc789',0),
('theo@outlook.com','motDePasse',1),
('veronique@gmail.com','login',0),
('nicolas@gmail.com','945Bonjour',1),
('loic@outlook.com','Hello123',1),
('martin@gmail.com','C7to95',0),
('francois@hotmail.com','Hello_World',1),
('bill@microsoft.com','r98g4re9g',1);

insert into Streets (streetname)

values
('rue lucien nameche'),
('rue godefroid'),
('rue des noyers'),
('rue des petunias'),
('rue des pommiers'),
('rue alfred brasseur'),
('rue badoux'),
('rue alexandre colin');

insert into parkings (parkingname, availableplaces, occupiedplaces)

values
('Namur expo',475,58),
('Hotel de ville',350,70),
('Leopold',500,98),
('Du centre',160,150),
('Gifar',500,450),
('Beffroi',258,189),
('Casernes',670,540),
('De la gare',655,180),
('Mutualite chretienne',70,68),
('St Nicolas',276,210);

insert into numbers (number)

values
('1'),
('2'),
('3'),
('3A'),
('4'),
('5'),
('6'),

('1'),
('3'),
('4'),
('5'),
('6'),
('7B'),
('8'),
('10'),

('1'),
('2'),
('3'),
('4'),
('5A'),
('5B'),
('6'),
('7'),

('5B'),
('1'),
('2'),
('3'),
('4'),
('5'),
('6A'),
('6B'),

('1'),
('2'),
('3'),
('4'),
('5'),
('6'),
('7'),
('8'),
('9'),
('10'),

('1'),
('2'),
('3'),
('4'),
('4B'),
('5'),
('6'),
('7'),
('8'),

('1'),
('3'),
('4'),
('5'),
('6'),
('7'),
('8B'),

('1'),
('2'),
('3'),
('4'),
('5'),
('5A'),
('5B'),
('6'),
('7'),
('8');


/*insert into StreetUsers(iduser,idstreet)

values

(1,2),(1,3),(1,7),
(2,3),(2,8),
(3,1),
(5,6),(5,8),
(6,6),(6,1),
(7,5),
(8,4),(8,2),(8,5),
(9,5);*/


/*insertion de perturbations de type chantier*/

insert into TrafficObstructions(startdate,starthour,enddate,endhour,codetypeobstruction,trafficimpact,operator,idstreetstart)
values

('05-1-2017','12:10:00','05-8-2017','10:00:00','chantier','Circulation bloquée','VOO',3),
('07-6-2017','12:10:00','7-10-2017','10:00:00','chantier','Circulation sur une bande','VOO',4),
('02-9-2017','09:30:00','02-11-2017','10:00:00','chantier','Déviation','ORES',5);


/*Insertion de perturbations de type festivité*/

insert into TrafficObstructions(startdate,starthour,enddate,endhour,codetypeobstruction,trafficimpact,infofestivity,idstreetstart,idstreetend)
values

('5-26-2017','8:00:00','5-28-2017','00:00:00','festivité','Circulation impossible','Namur en mai',4,5);



/*Insertion de perturbations de type autre*/

insert into TrafficObstructions(startdate,starthour,enddate,endhour,codetypeobstruction,trafficimpact,infoother,idstreetstart,idstreetend)
values

('4-2-2017','8:00:00','4-9-2017','00:00:00','autre','Circulation partielle','Braderie',1,2);

DBCC CHECKIDENT(numbers,RESEED,0);
DBCC CHECKIDENT(users,RESEED,0);
DBCC CHECKIDENT(parkings,RESEED,0);
DBCC CHECKIDENT(streets,RESEED,0);
DBCC CHECKIDENT(trafficobstructions,RESEED,0);