T-SQL - DAIS - init

insert into Station values('01','CA');
insert into Station values('02','VR');
insert into Station values('03','ÚNL');
insert into Station values('04','BB');
insert into Station values('05','PRA');
insert into Station values('06','MI');
insert into Station values('07','BA');
insert into Station values('08','KE');
insert into Station values('09','TR');
insert into Station values('10','PÚCH');

insert into [User] values('1','[email protected]','firstname01','surname01','pass01');
insert into [User] values('2','[email protected]','firstname02','surname02','pass02');
insert into [User] values('3','[email protected]','firstname03','surname03','pass03');
insert into [User] values('4','[email protected]','firstname04','surname04','pass04');
insert into [User] values('5','[email protected]','firstname05','surname05','pass05');
insert into [User] values('6','[email protected]','firstname06','surname06','pass06');
insert into [User] values('7','[email protected]','firstname07','surname07','pass07');
insert into [User] values('8','[email protected]','firstname08','surname08','pass08');
insert into [User] values('9','[email protected]','firstname09','surname09','pass09');
insert into [User] values('10','[email protected]','firstname10','surname10','pass10');

insert into Staff values('01','fstaff01','sstaff01','d','02/21/2012 7:45','03/05/2012 21:00',20);
insert into Staff values('02','fstaff02','sstaff02','d','02/22/2012 21:00','03/24/2012 7:45',20);
insert into Staff values('03','fstaff03','sstaff03','d','02/25/2012 8:45','03/08/2012 21:00',20);
insert into Staff values('04','fstaff04','sstaff04','g','02/21/2012 8:00','02/27/2012 21:00',18);
insert into Staff values('05','fstaff05','sstaff05','g','02/21/2012 21:00','02/28/2012 8:00',18);
insert into Staff values('06','fstaff06','sstaff06','g','02/24/2012 8:00','03/03/2012 21:00',18);
insert into Staff values('07','fstaff07','sstaff07','s','02/22/2012 8:00','02/27/2012 21:00',15);
insert into Staff values('08','fstaff08','sstaff08','s','02/22/2012 21:00','02/28/2012 8:00',15);
insert into Staff values('09','fstaff09','sstaff09','s','02/11/2012 8:00','03/15/2012 20:00',15);
insert into Staff values('10','fstaff10','sstaff10','s','02/28/2012 7:45','03/31/2012 20:45',20);


insert into Train values('1','OS001','1','4.30','7:00:00','11:30:00','01','02');
insert into Train values('2','OS002','1','5.90','8:00:00','15:30:00','03','04');
insert into Train values('3','OS003','1','3.80','8:30:00','18:05:00','05','06');
insert into Train values('4','OS004','1','6.35','10:45:00','19:15:00','07','08');
insert into Train values('5','OS005','1','2.05','7:45:00','9:45:00','09','10');


insert into TrainRide values('01','2012-02-27','1');
insert into TrainRide values('06','02/27/2012','1');
insert into TrainRide values('02','02/23/2012','2');
insert into TrainRide values('03','02/24/2012','3');
insert into TrainRide values('04','02/22/2012','4');
insert into TrainRide values('05','02/25/2012','5');
insert into TrainRide values('07','02/28/2012','1');
insert into TrainRide values('08','03/02/2012','2');
insert into TrainRide values('09','03/06/2012','6');

insert into TrainCrew values('01','01');
insert into TrainCrew values('04','01');
insert into TrainCrew values('07','01');
insert into TrainCrew values('02','02');
insert into TrainCrew values('05','02');
insert into TrainCrew values('08','02');
insert into TrainCrew values('01','06');
insert into TrainCrew values('01','05');
insert into TrainCrew values('02','07');
insert into TrainCrew values('06','07');
insert into TrainCrew values('09','07');


insert into Reservation(coachnumber,seatnumber, reservationdate, idtrainride, iduser)
    values('1','2','02/19/2012 8:00:00','01','1');

insert into Reservation(coachnumber,seatnumber, reservationdate, idtrainride, iduser)
    values('2','3','02/22/2012 9:00','01','1');

insert into Reservation(coachnumber,seatnumber, reservationdate, idtrainride, iduser)
    values('2','1','02/25/2012 11:00','01','1');

insert into Reservation(coachnumber,seatnumber, reservationdate, idtrainride, iduser)
    values('2','1','02/25/2012 11:00','02','1');

insert into Reservation(coachnumber,seatnumber, reservationdate, idtrainride, iduser)
    values('1','3','02/20/2012 11:30','01','3');

insert into Reservation(coachnumber,seatnumber, reservationdate, idtrainride, iduser)
    values('1','1','02/21/2012 10:00','01','2');

insert into Reservation(coachnumber,seatnumber, reservationdate, idtrainride, iduser)
    values('1','3','02/16/2012 10:00','02','4');

insert into Reservation(coachnumber,seatnumber, reservationdate, idtrainride, iduser)
    values('1','2','02/22/2012 14:30','02','5');

insert into Reservation(coachnumber,seatnumber, reservationdate, idtrainride, iduser)
    values('1','2','02/22/2012 17:15','03','6');

insert into Reservation(coachnumber,seatnumber, reservationdate, idtrainride, iduser)
    values('1','2','02/21/2012 19:15','04','8');

insert into Reservation(coachnumber,seatnumber, reservationdate, idtrainride, iduser)
    values('1','2','02/24/2012 6:15','05','9');

insert into Reservation(coachnumber,seatnumber, reservationdate, idtrainride, iduser)
    values('2','2','02/26/2012 6:15','09','6');

insert into Reservation(coachnumber,seatnumber, reservationdate, idtrainride, iduser)
    values('3','1','02/28/2012 8:15','09','8');