Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE `mydb`;
- INSERT INTO AirPorts(FPKode, FPNavn, FPtlf) VALUES ('OSL', 'Gardermoen', '54545454');
- INSERT INTO AirPorts(FPKode, FPNavn, FPtlf) VALUES ('LON', 'London', '12345678');
- INSERT INTO AirPorts(FPKode, FPNavn, FPtlf) VALUES ('ALC', 'Alicante', '88888888');
- INSERT INTO AirPorts(FPKode, FPNavn, FPtlf) VALUES ('STA', 'Stavanger', '12312312');
- INSERT INTO AirPorts(FPKode, FPNavn, FPtlf) VALUES ('KJE', 'Kjevik', '43214321');
- INSERT INTO Runways(RKode, RPos, RLengde, AirPorts_FPKode) VALUES ('1111', 'Vest', '100', 'OSL');
- INSERT INTO Runways(RKode, RPos, RLengde, AirPorts_FPKode) VALUES ('2222', 'Nord', '120', 'OSL');
- INSERT INTO Runways(RKode, RPos, RLengde, AirPorts_FPKode) VALUES ('3333', 'Vest', '100', 'KJE');
- INSERT INTO Runways(RKode, RPos, RLengde, AirPorts_FPKode) VALUES ('4444', 'Oest', '400', 'ALC');
- INSERT INTO Runways(RKode, RPos, RLengde, AirPorts_FPKode) VALUES ('5555', 'Vest', '200', 'LON');
- INSERT INTO Airplanes(Fkode, Fselskap, MaxPass) VALUES ('666666', 'SAS', '256');
- INSERT INTO Airplanes(Fkode, Fselskap, MaxPass) VALUES ('321321', 'SAS', '330');
- INSERT INTO Airplanes(Fkode, Fselskap, MaxPass) VALUES ('673123', 'Norwegian', '120');
- INSERT INTO Airplanes(Fkode, Fselskap, MaxPass) VALUES ('456432', 'SAS', '256');
- INSERT INTO Airplanes(Fkode, Fselskap, MaxPass) VALUES ('787878', 'KLM', '300');
- INSERT INTO ArrivalsDeparture(Runways_RKode, Airplanes_FKode, AntPass, FReise, dato, tid) VALUES ('1111', '666666', '78', 'Ank', '2005-05-19', '14:23:11');
- INSERT INTO ArrivalsDeparture(Runways_RKode, Airplanes_FKode, AntPass, FReise, dato, tid) VALUES ('1111', '321321', '323', 'Avr', '2005-05-19', '15:23:11');
- INSERT INTO ArrivalsDeparture(Runways_RKode, Airplanes_FKode, AntPass, FReise, dato, tid) VALUES ('3333', '787878', '299', 'Ank', '2018-05-19', '08:34:54');
- INSERT INTO ArrivalsDeparture(Runways_RKode, Airplanes_FKode, AntPass, FReise, dato, tid) VALUES ('5555', '321321', '310', 'Avr', '2017-04-05', '00:32:13');
- INSERT INTO ArrivalsDeparture(Runways_RKode, Airplanes_FKode, AntPass, FReise, dato, tid) VALUES ('2222', '673123', '30', 'Ank', '2008-06-12', '19:13:51');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement