Advertisement
Guest User

Untitled

a guest
Feb 23rd, 2018
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 2.09 KB | None | 0 0
  1. USE `mydb`;
  2.  
  3. INSERT INTO AirPorts(FPKode, FPNavn, FPtlf) VALUES ('OSL', 'Gardermoen', '54545454');
  4. INSERT INTO AirPorts(FPKode, FPNavn, FPtlf) VALUES ('LON', 'London', '12345678');
  5. INSERT INTO AirPorts(FPKode, FPNavn, FPtlf) VALUES ('ALC', 'Alicante', '88888888');
  6. INSERT INTO AirPorts(FPKode, FPNavn, FPtlf) VALUES ('STA', 'Stavanger', '12312312');
  7. INSERT INTO AirPorts(FPKode, FPNavn, FPtlf) VALUES ('KJE', 'Kjevik', '43214321');
  8.  
  9. INSERT INTO Runways(RKode, RPos, RLengde, AirPorts_FPKode) VALUES ('1111', 'Vest', '100', 'OSL');
  10. INSERT INTO Runways(RKode, RPos, RLengde, AirPorts_FPKode) VALUES ('2222', 'Nord', '120', 'OSL');
  11. INSERT INTO Runways(RKode, RPos, RLengde, AirPorts_FPKode) VALUES ('3333', 'Vest', '100', 'KJE');
  12. INSERT INTO Runways(RKode, RPos, RLengde, AirPorts_FPKode) VALUES ('4444', 'Oest', '400', 'ALC');
  13. INSERT INTO Runways(RKode, RPos, RLengde, AirPorts_FPKode) VALUES ('5555', 'Vest', '200', 'LON');
  14.  
  15. INSERT INTO Airplanes(Fkode, Fselskap, MaxPass) VALUES ('666666', 'SAS', '256');
  16. INSERT INTO Airplanes(Fkode, Fselskap, MaxPass) VALUES ('321321', 'SAS', '330');
  17. INSERT INTO Airplanes(Fkode, Fselskap, MaxPass) VALUES ('673123', 'Norwegian', '120');
  18. INSERT INTO Airplanes(Fkode, Fselskap, MaxPass) VALUES ('456432', 'SAS', '256');
  19. INSERT INTO Airplanes(Fkode, Fselskap, MaxPass) VALUES ('787878', 'KLM', '300');
  20.  
  21. INSERT INTO ArrivalsDeparture(Runways_RKode, Airplanes_FKode, AntPass, FReise, dato, tid) VALUES ('1111', '666666', '78', 'Ank', '2005-05-19', '14:23:11');
  22. INSERT INTO ArrivalsDeparture(Runways_RKode, Airplanes_FKode, AntPass, FReise, dato, tid) VALUES ('1111', '321321', '323', 'Avr', '2005-05-19', '15:23:11');
  23. INSERT INTO ArrivalsDeparture(Runways_RKode, Airplanes_FKode, AntPass, FReise, dato, tid) VALUES ('3333', '787878', '299', 'Ank', '2018-05-19', '08:34:54');
  24. INSERT INTO ArrivalsDeparture(Runways_RKode, Airplanes_FKode, AntPass, FReise, dato, tid) VALUES ('5555', '321321', '310', 'Avr', '2017-04-05', '00:32:13');
  25. 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