Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement