The Code-Bin
Links
Home
Add your code!
All Listings
About
Latest Entry
Featured Scripts
Author's Website
Latest Entries
FFMPEG Thumbnail Scr...
PHP, 0.8KB
Jul. 29, 10:24pm
John
Z80 Assembler, 190 bytes
Feb. 17, 3:36am
John
Z80 Assembler, 176 bytes
Sep. 13, 2:19am
John
Z80 Assembler, 77 bytes
Sep. 13, 2:18am
John
Z80 Assembler, 209 bytes
Sep. 13, 2:17am
untitled MySQL Code
Posted by: bla | June 2, 2010 @ 3:26am
MySQL Code
[
Download
]
#CREATE DATABASE Hochschule DROP TABLE IF EXISTS Lehrveranstaltung_Studiengang; DROP TABLE IF EXISTS Studiengang_Dozent; DROP TABLE IF EXISTS Student_Lehrveranstaltung; DROP TABLE IF EXISTS Assistent_Dozent; DROP TABLE IF EXISTS Dozent_Lehrveranstaltung; DROP TABLE IF EXISTS Raum_Lehrveranstaltung; DROP TABLE IF EXISTS Lehrveranstaltung; DROP TABLE IF EXISTS Raum; DROP TABLE IF EXISTS Assistent; DROP TABLE IF EXISTS Student; DROP TABLE IF EXISTS Studiengang; DROP TABLE IF EXISTS Fachbereich; DROP TABLE IF EXISTS Dozent; CREATE TABLE Dozent ( id INT NOT NULL AUTO_INCREMENT, Name VARCHAR(50) NOT NULL, Geburtsdatum DATE NOT NULL, Adresse VARCHAR(100) NOT NULL, Tel INT NOT NULL, Photo blob NOT NULL, PRIMARY KEY (id), CHECK (Name!='') ) ENGINE=InnoDB; CREATE TABLE Fachbereich ( id INT NOT NULL AUTO_INCREMENT, name VARCHAR(30) NOT NULL, dekan VARCHAR(100) NOT NULL, gebaeude VARCHAR(10) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB; CREATE TABLE Studiengang ( id INT NOT NULL AUTO_INCREMENT, name VARCHAR(30) NOT NULL, fachbereich INT NOT NULL, PRIMARY KEY (id), Foreign Key (fachbereich) REFERENCES Fachbereich(id) ) ENGINE=InnoDB; CREATE TABLE Student ( id INT NOT NULL AUTO_INCREMENT, Name VARCHAR(50) NOT NULL, Geburtsdatum DATE NOT NULL, Adresse VARCHAR(100) NOT NULL, Studiengang INT NOT NULL, PRIMARY KEY (id), Foreign Key (Studiengang) REFERENCES Studiengang(id) ) ENGINE=InnoDB; CREATE TABLE Assistent ( id INT NOT NULL AUTO_INCREMENT, Name VARCHAR(50) NOT NULL, Geburtsdatum DATE NOT NULL, Adresse VARCHAR(100) NOT NULL, Tel INT NOT NULL, Studiengang INT NOT NULL, PRIMARY KEY (id), Foreign Key (Studiengang) REFERENCES Studiengang(id) ) ENGINE=InnoDB; CREATE TABLE Raum ( id INT NOT NULL AUTO_INCREMENT, Plaetze INT NOT NULL, Ausruestung Varchar(100), PRIMARY KEY (id), CHECK (Plaetze>0) ) ENGINE=InnoDB; CREATE TABLE Lehrveranstaltung ( id INT NOT NULL AUTO_INCREMENT, name VARCHAR(30) NOT NULL, themen VARCHAR(100) NOT NULL, PRIMARY KEY (id), UNIQUE(themen) ) ENGINE=InnoDB; # Relationstabellen CREATE TABLE Raum_Lehrveranstaltung ( Raum_id INT NOT NULL, Lehrveranstaltung_id INT NOT NULL, Foreign Key (Raum_id) references Raum(id), Foreign Key (Lehrveranstaltung_id) REFERENCES Lehrveranstaltung(id) ) ENGINE=InnoDB; CREATE TABLE Dozent_Lehrveranstaltung ( Dozent_id INT NOT NULL, Lehrveranstaltung_id INT NOT NULL, Foreign Key (Dozent_id) references Dozent(id), Foreign Key (Lehrveranstaltung_id) REFERENCES Lehrveranstaltung(id) ) ENGINE=InnoDB; CREATE TABLE Assistent_Dozent ( Assistent_id INT NOT NULL, Dozent_id INT NOT NULL, Foreign Key (Assistent_id) REFERENCES Assistent(id), Foreign Key (Dozent_id) REFERENCES Dozent(id) ) ENGINE=InnoDB; CREATE TABLE Student_Lehrveranstaltung ( Student_id INT NOT NULL, Lehrveranstaltung_id INT NOT NULL, Foreign Key (Student_id) references Student(id), Foreign Key (Lehrveranstaltung_id) REFERENCES Lehrveranstaltung(id) ) ENGINE=InnoDB; CREATE TABLE Studiengang_Dozent ( Studiengang_id INT NOT NULL, Dozent_id INT NOT NULL, Foreign Key (Studiengang_id) REFERENCES Studiengang(id), Foreign Key (Dozent_id) REFERENCES Dozent(id) ) ENGINE=InnoDB; CREATE TABLE Lehrveranstaltung_Studiengang ( Lehrveranstaltung_id INT NOT NULL, Studiengang_id INT NOT NULL, Foreign Key (Lehrveranstaltung_id) REFERENCES Lehrveranstaltung(id), Foreign Key (Studiengang_id) REFERENCES Studiengang(id) ) ENGINE=InnoDB;
Syntax Highlighting
[
Open in new window
]
Author Comments
none
Rating
4.61 / 8
41 Votes
http://codebin.yi.org/662
page generated in 0.01 seconds