35 lines
2.5 KiB
SQL
35 lines
2.5 KiB
SQL
insert into user(name, pw) values('a', '$argon2i$v=19$m=16,t=2,p=1$b2lmaG9pMzJvNDk$vXbHg45vkuMrQaP0XY184Q'); -- pw = 123
|
|
|
|
insert into route(name) values('RS (WiWö)');
|
|
insert into route(name) values('RAT (GuSp)');
|
|
|
|
INSERT INTO station(name, amount_people, lat, lng, pw, notes) VALUES('Geheimschrift',0,48.512695450984161028,14.493284225463868963, 'B4T81DN2', 'Das ist eine unbemannte Station');
|
|
INSERT INTO station(name, amount_people, lat, lng, pw) VALUES('Tierspuren',NULL,48.509795564624980102,14.4911384582519549, 'QW3RZBR4');
|
|
INSERT INTO station(name, amount_people, lat, lng, pw) VALUES('Blattkunde',NULL,48.514401188965464938,14.518775939941408025, 'SFG1JB19');
|
|
INSERT INTO station(name, amount_people, lat, lng, pw) VALUES('Knoten',NULL,48.506895512305042927,14.5021247863769549, 'TMFKUDPQ');
|
|
INSERT INTO station(name, amount_people, lat, lng, pw) VALUES('Twister',NULL,48.511728840637701408,14.504613876342775213, 'SS1GOO6G');
|
|
INSERT INTO station(name, amount_people, lat, lng, pw) VALUES('Wasserrutsche',NULL,48.508885762155230735,14.49834823608398615, 'Z9AVEYFT');
|
|
INSERT INTO station(name, amount_people, lat, lng, pw) VALUES('Nur RAT Station',NULL,48.488885762155230735,14.49834823608398615, 'MPVYGNBJ');
|
|
|
|
INSERT INTO route_station(route_id, station_id, pos) VALUES(1, 1, 2);
|
|
INSERT INTO route_station(route_id, station_id, pos) VALUES(1, 2, 4);
|
|
INSERT INTO route_station(route_id, station_id, pos) VALUES(1, 3, 6);
|
|
INSERT INTO route_station(route_id, station_id, pos) VALUES(1, 4, 8);
|
|
INSERT INTO route_station(route_id, station_id, pos) VALUES(1, 5, 10);
|
|
INSERT INTO route_station(route_id, station_id, pos) VALUES(1, 6, 12);
|
|
INSERT INTO route_station(route_id, station_id, pos) VALUES(2, 1, 2);
|
|
INSERT INTO route_station(route_id, station_id, pos) VALUES(2, 2, 4);
|
|
INSERT INTO route_station(route_id, station_id, pos) VALUES(2, 3, 6);
|
|
INSERT INTO route_station(route_id, station_id, pos) VALUES(2, 4, 8);
|
|
INSERT INTO route_station(route_id, station_id, pos) VALUES(2, 5, 10);
|
|
INSERT INTO route_station(route_id, station_id, pos) VALUES(2, 6, 12);
|
|
INSERT INTO route_station(route_id, station_id, pos) VALUES(2, 7, 14);
|
|
|
|
INSERT INTO team VALUES(1,'Wichtigen Wichtel',NULL,NULL,2,NULL,1);
|
|
INSERT INTO team VALUES(2,'Wunderlichen Wichtel',NULL,NULL,3,NULL,1);
|
|
INSERT INTO team VALUES(3,'Wandernden Wölflinge',NULL,NULL,4,NULL,1);
|
|
INSERT INTO team VALUES(4,'Guten Guides',NULL,NULL,5,NULL,2);
|
|
INSERT INTO team VALUES(5,'Genialen Guides',NULL,NULL,6,NULL,2);
|
|
INSERT INTO team VALUES(6,'Spärlich besetzten Späher',NULL,NULL,7,NULL,2);
|
|
INSERT INTO team VALUES(7,'Super Späher',NULL,NULL,2,NULL,2);
|