Created
March 12, 2015 17:44
-
-
Save AndreasJacobsen/c6a80b69b9e6f480b451 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
create table Ovelse2( | |
OvelseNr int(2) auto_increment, | |
Betegnelse varchar(20), | |
Dato varchar(10), | |
Tid varchar(5), | |
Sted varchar(20), | |
PRIMARY KEY(OvelseNr) | |
); | |
create table Publikum2( | |
PublikumsNr int(3) auto_increment, | |
Fornavn varchar(20), | |
Etternavn varchar(20), | |
Adresse varchar(25), | |
PostNr varchar(4), | |
Telefonnummer varchar(8), | |
Billettype varchar(20), | |
PRIMARY KEY(PublikumsNr), | |
FOREIGN KEY(PostNr) REFERENCES Post | |
); | |
create table Utover2( | |
UtoverNr int(2) auto_increment, | |
Fornavn varchar(20), | |
Etternavn varchar(20), | |
Adresse varchar(25), | |
PostNr varchar(4), | |
Telefonnummer varchar(8), | |
Nasjonalitet varchar(10), | |
PRIMARY KEY(UtoverNr), | |
FOREIGN KEY(PostNr) REFERENCES Post | |
); | |
create table Post2( | |
PostNr varchar(4), | |
Poststed varchar(20), | |
PRIMARY KEY(PostNr) | |
); | |
create table Publikumsliste2( | |
PublikumsNr int(3), | |
OvelseNr varchar(2), | |
PRIMARY KEY(PublikumsNr, OvelseNr), | |
FOREIGN KEY(PublikumsNr) REFERENCES Publikum2, | |
FOREIGN KEY(OvelseNr) REFERENCES Ovelse2 | |
); | |
create table Utoverliste2( | |
UtoverNr int(3), | |
OvelseNr varchar(2), | |
PRIMARY KEY(UtoverNr, OvelseNr), | |
FOREIGN KEY(UtoverNr) REFERENCES Publikum2, | |
FOREIGN KEY(OvelseNr) REFERENCES Ovelse2 | |
); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment