CREATE TABLE PERSONS (
- ID INT AUTO_INCREMENT PRIMARY KEY,
+ PERSON_ID INT AUTO_INCREMENT PRIMARY KEY,
NAME VARCHAR(80) NOT NULL,
EMAIL VARCHAR(80),
- AFFILIATION VARCHAR(80)
+ AFFILIATION VARCHAR(80),
+ HOMEPAGE VARCHAR(80)
);
CREATE TABLE PERSONS_SETS (
);
CREATE TABLE SETS (
- ID INT AUTO_INCREMENT PRIMARY KEY,
+ SET_ID INT AUTO_INCREMENT PRIMARY KEY,
SETSTART DATETIME NOT NULL,
DURATION INT,
FILENAME VARCHAR(80),
);
CREATE TABLE SHOWS (
- ID INT AUTO_INCREMENT PRIMARY KEY,
+ SHOW_ID INT AUTO_INCREMENT PRIMARY KEY,
PERSON_ID INT,
SHOWSTART DATETIME NOT NULL,
DURATION INT,
);
CREATE TABLE STUDIOS (
- ID INT AUTO_INCREMENT PRIMARY KEY,
+ STUDIO_ID INT AUTO_INCREMENT PRIMARY KEY,
NAME VARCHAR(80),
ISLIVE CHAR(1)
);
+