diff options
-rw-r--r-- | schema.sql | 6 |
1 files changed, 3 insertions, 3 deletions
@@ -15,7 +15,7 @@ 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), @@ -30,7 +30,7 @@ CREATE TABLE SETS ( ); 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, @@ -40,7 +40,7 @@ CREATE TABLE SHOWS ( ); CREATE TABLE STUDIOS ( - ID INT AUTO_INCREMENT PRIMARY KEY, + STUDIO_ID INT AUTO_INCREMENT PRIMARY KEY, NAME VARCHAR(80), ISLIVE CHAR(1) ); |