);
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)
);