--USER
INSERT INTO "User" VALUES(1,'marcel@gmail.com','Marcel','Čopík','heslo123');
INSERT INTO "User" VALUES(2,'gejza@gmail.com','Gejza','Bedeč','password');
INSERT INTO "User" VALUES(3,'viliam@gmail.com','Viliam','Mačo','pass');
INSERT INTO "User" VALUES(4,'moric@gmail.com','Moric','Gabriška','heslo123');
INSERT INTO "User" VALUES(5,'levoslav@gmail.com','Levoslav','Macúšek','password');
INSERT INTO "User" VALUES(6,'radoslav@gmail.com','Radoslav','Hajtún','heslo1');
INSERT INTO "User" VALUES(7,'tomas@gmail.com','Tomáš','Ďurovský','heslo123');
INSERT INTO "User" VALUES(8,'jaroslav@gmail.com','Jaroslav','Čalfa','pass25');
INSERT INTO "User" VALUES(9,'miroslav@gmail.com','Miroslav','Dusík','password');
INSERT INTO "User" VALUES(10,'maros@gmail.com','Maroš','Pacolák','heslo1');

--STATION
INSERT INTO station VALUES(1,'Turzovka');
INSERT INTO station VALUES(2,'Čadca');
INSERT INTO station VALUES(3,'Svrčinovec');
INSERT INTO station VALUES(4,'Třinec');
INSERT INTO station VALUES(5,'Český Tešín');
INSERT INTO station VALUES(6,'Bohumín');
INSERT INTO station VALUES(7,'Olomouc');
INSERT INTO station VALUES(8,'Ostrava');
INSERT INTO station VALUES(9,'Brno');
INSERT INTO station VALUES(10,'Praha');

--STAFF
INSERT INTO staff VALUES(1,'Roman','Oškerský','d',TO_DATE('04.01.2002','dd.mm.yyyy'),NULL,550);
INSERT INTO staff VALUES(2,'Ladislav','Pekelský','d',TO_DATE('24.05.2002','dd.mm.yyyy'),NULL,550);
INSERT INTO staff VALUES(3,'Marek','Fabšo','d',TO_DATE('15.05.2002','dd.mm.yyyy'),TO_DATE('13.03.2010','dd.mm.yyyy'),500);
INSERT INTO staff VALUES(4,'Ignác','Godarský','g',TO_DATE('16.05.2003','dd.mm.yyyy'),NULL,450);
INSERT INTO staff VALUES(5,'Matej','Harmečko','g',TO_DATE('23.01.2003','dd.mm.yyyy'),NULL,450);
INSERT INTO staff VALUES(6,'Milan','Kostra','g',TO_DATE('12.06.2008','dd.mm.yyyy'),NULL,450);
INSERT INTO staff VALUES(7,'Filip','Kemka','s',TO_DATE('05.11.2002','dd.mm.yyyy'),NULL,400);
INSERT INTO staff VALUES(8,'Jozef','Ratiborský','s',TO_DATE('04.07.2005','dd.mm.yyyy'),NULL,400);
INSERT INTO staff VALUES(9,'Ľubomír','Kriščák','s',TO_DATE('03.01.2006','dd.mm.yyyy'),NULL,400);
INSERT INTO staff VALUES(10,'Boris','Slamenka','s',TO_DATE('22.10.2002','dd.mm.yyyy'),TO_DATE('20.01.2012','dd.mm.yyyy'),400);

--TRAIN
INSERT INTO train VALUES(1,'train01',2,2,TO_DATE('08:00 01.01.0001','hh24:mi dd.mm.yyyy'),TO_DATE('08.55 01.01.0001','hh24:mi dd.mm.yyyy'),01,02);
INSERT INTO train VALUES(2,'train02',2,3,TO_DATE('09:00 01.01.0001','hh24:mi dd.mm.yyyy'),TO_DATE('09.55 01.01.0001','hh24:mi dd.mm.yyyy'),02,03);
INSERT INTO train VALUES(3,'train03',1,3,TO_DATE('10:00 01.01.0001','hh24:mi dd.mm.yyyy'),TO_DATE('10.55 01.01.0001','hh24:mi dd.mm.yyyy'),03,04);
INSERT INTO train VALUES(4,'train04',1,4,TO_DATE('11:00 01.01.0001','hh24:mi dd.mm.yyyy'),TO_DATE('11:55 01.01.0001','hh24:mi dd.mm.yyyy'),04,05);
INSERT INTO train VALUES(5,'train05',1,2,TO_DATE('12:00 01.01.0001','hh24:mi dd.mm.yyyy'),TO_DATE('12.55 01.01.0001','hh24:mi dd.mm.yyyy'),05,06);

--TRAINRIDE
INSERT INTO trainride  VALUES(1,TO_DATE('20.02.2012','dd.mm.yyyy'),1);
INSERT INTO trainride  VALUES(2,TO_DATE('20.02.2012','dd.mm.yyyy'),2);
INSERT INTO trainride  VALUES(3,TO_DATE('20.02.2012','dd.mm.yyyy'),3);
INSERT INTO trainride  VALUES(4,TO_DATE('20.02.2012','dd.mm.yyyy'),4);
INSERT INTO trainride  VALUES(5,TO_DATE('20.02.2012','dd.mm.yyyy'),5);

--TRAINCREW
INSERT INTO TrainCrew  VALUES(1,1);
INSERT INTO TrainCrew  VALUES(4,1);
INSERT INTO TrainCrew  VALUES(7,1);
INSERT INTO TrainCrew  VALUES(9,1);
INSERT INTO TrainCrew  VALUES(1,2);
INSERT INTO TrainCrew  VALUES(4,2);
INSERT INTO trainCrew  VALUES(7,2);
INSERT INTO TrainCrew  VALUES(9,2);
INSERT INTO TrainCrew  VALUES(2,3);
INSERT INTO TrainCrew  VALUES(5,3);
INSERT INTO trainCrew  VALUES(8,3);
INSERT INTO TrainCrew  VALUES(2,4);
INSERT INTO TrainCrew  VALUES(5,4);
INSERT INTO trainCrew  VALUES(8,4);
INSERT INTO TrainCrew  VALUES(2,5);
INSERT INTO TrainCrew  VALUES(5,5);
INSERT INTO trainCrew  VALUES(8,5);

--RESERVATION
INSERT INTO reservation  VALUES(1,1,1,1,TO_DATE('14:04 15.02.2012','hh24:mi dd.mm.yyyy'), TO_DATE('14:04 15.02.2012','hh24:mi dd.mm.yyyy'), NULL);
INSERT INTO reservation  VALUES(1,1,2,2,TO_DATE('16:55 15.02.2012','hh24:mi dd.mm.yyyy'), TO_DATE('14:04 15.02.2012','hh24:mi dd.mm.yyyy'), NULL);
INSERT INTO reservation  VALUES(1,1,3,3,TO_DATE('08:02 16.02.2012','hh24:mi dd.mm.yyyy'), TO_DATE('14:04 15.02.2012','hh24:mi dd.mm.yyyy'), NULL);
INSERT INTO reservation  VALUES(2,1,1,4,TO_DATE('19:25 17.02.2012','hh24:mi dd.mm.yyyy'), NULL, NULL);
INSERT INTO reservation  VALUES(2,1,2,5,TO_DATE('19:27 17.02.2012','hh24:mi dd.mm.yyyy'), NULL, NULL);