Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*Löschen der DB, falls sie existiert*/
- drop database if exists learnpartyDB;
- /*Anlegen der DB*/
- create database learnpartyDB;
- /*Nutzen der DB*/
- use learnpartyDB;
- /*Anlegen der Tabellen und deren Relationen*/
- create table TBLTEAM
- (
- IDTEAM int primary key auto_increment,
- TEAMNAME varchar(30) not null unique,
- EMAIL varchar(50) not null,
- ANWESEND boolean
- );
- create table TBLSPIELER
- (
- IDSPIELER int primary key auto_increment,
- VORNAME varchar(20) not null,
- NACHNAME varchar(20) not null,
- NICKNAME varchar(20) not null unique,
- FITEAM int on delete cascade,
- FOREIGN KEY (FITEAM) REFERENCES TBLTEAM(IDTEAM)
- );
- create table TBLRUNDE
- (
- IDRUNDE int primary key auto_increment,
- BEZEICHNUNG varchar(20),
- STARTZEIT time not null,
- DAUER_MIN int,
- CONSTRAINT UC_ROUND UNIQUE(BEZEICHNUNG)
- );
- create table TBLSPIELEN
- (
- TISCH varchar(10) not null,
- TORETEAMA int not null default 0,
- TORETEAMB int not null default 0,
- FITEAMA int not null,
- FITEAMB int not null,
- FIRUNDE int not null,
- constraint PK_SPIEL PRIMARY KEY(FITEAMA, FITEAMB, FIRUNDE),
- FOREIGN KEY (FITEAMA) REFERENCES TBLTEAM(IDTEAM),
- FOREIGN KEY (FITEAMB) REFERENCES TBLTEAM(IDTEAM),
- FOREIGN KEY (FIRUNDE) REFERENCES TBLRUNDE(IDRUNDE) on delete cascade,
- constraint CHK_SPIEL check (FITEAMA <> FITEAMB)
- );
- create table TBLADMIN
- (
- IDADMIN varchar(8) primary key,
- NACHNAME varchar(20) not null,
- VORNAME varchar(15) not null,
- PASSWORD varchar(255) not null
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement