summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--schema.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/schema.sql b/schema.sql
index 64c12cd..5fc2635 100644
--- a/schema.sql
+++ b/schema.sql
@@ -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)
);