daily pastebin goal
32%
SHARE
TWEET

Untitled

a guest Feb 22nd, 2018 74 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2. drop database Flyplass;
  3. create database Flyplass;
  4. use Flyplass;
  5.  
  6.  
  7. create table Flyplass(
  8.  
  9. FPKode int (10),
  10. FNavn varchar(45),
  11. Telefon varchar(20),
  12.  
  13. Primary key (FPKode)
  14.  
  15. );
  16.  
  17.  
  18. create table Rullebane(
  19.  
  20. RKode int (20),
  21. Pos varchar (45),
  22. Lengde varchar (45),
  23.  
  24. FPKode int (10),/*Hentet fra Flyplass(Primær)*/
  25.  
  26. Primary key (RKode),
  27. Foreign key (FPKode) references Flyplass(FPKode)
  28. );
  29.  
  30.  
  31. create table Resie(
  32.  
  33. Dato int (10),
  34. Tid varchar(20),
  35. Avgang varchar (20),
  36. Ankomst varchar (20),
  37. Antpers varchar(20),
  38.  
  39. RKode int (20),
  40. FKode int(20),
  41.  
  42. primary key (Dato),
  43. foreign key (RKode) references Rullebane(RKode),
  44. foreign key (FKode) references Fly(FKode)
  45.  
  46. );
  47.  
  48.  
  49. create table Fly(
  50.  
  51. FKode int(20),
  52. FSelskap varchar (45),
  53. PPlass varchar (45),
  54.  
  55. primary key (FKode)
  56.  
  57. );
  58.  
  59. use Flyplass;
  60.  
  61. insert into Flyplass
  62. values ();
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top