sql_andreas.sql

CREATE TABLE competitor
(
    competitorID INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
    name VARCHAR(40) NOT NULL,
    surname VARCHAR(40) NOT NULL,
    nationality VARCHAR(40) NOT NULL
);

CREATE TABLE vm.audience
(
    ticketID INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
    name VARCHAR(30) NOT NULL,
    surname VARCHAR(30) NOT NULL,
    adress VARCHAR(50) NOT NULL,
    phone VARCHAR(11) NOT NULL,
    tickettype VARCHAR(6) NOT NULL,
    excersize VARCHAR(10) NOT NULL
);

CREATE TABLE vm.happening
(
    Date VARCHAR(11) NOT NULL,
    Time VARCHAR(11) NOT NULL,
    Place VARCHAR(55) NOT NULL,
    PRIMARY KEY (Time, Place)
);

CREATE TABLE vm.audienceHappening
(
    tickedID INT NOT NULL,
    competitorID INT NOT NULL,
    visitors INT NOT NULL AUTO_INCREMENT,
    PRIMARY KEY (tickedID, visitors)
);