projects
/
technostate.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
bah
[technostate.git]
/
schema.sql
diff --git
a/schema.sql
b/schema.sql
index
64c12cd
..
5fc2635
100644
(file)
--- a/
schema.sql
+++ b/
schema.sql
@@
-15,7
+15,7
@@
CREATE TABLE PERSONS_SETS (
);
CREATE TABLE 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),
SETSTART DATETIME NOT NULL,
DURATION INT,
FILENAME VARCHAR(80),
@@
-30,7
+30,7
@@
CREATE TABLE SETS (
);
CREATE TABLE SHOWS (
);
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,
PERSON_ID INT,
SHOWSTART DATETIME NOT NULL,
DURATION INT,
@@
-40,7
+40,7
@@
CREATE TABLE SHOWS (
);
CREATE TABLE STUDIOS (
);
CREATE TABLE STUDIOS (
- ID INT AUTO_INCREMENT PRIMARY KEY,
+
STUDIO_
ID INT AUTO_INCREMENT PRIMARY KEY,
NAME VARCHAR(80),
ISLIVE CHAR(1)
);
NAME VARCHAR(80),
ISLIVE CHAR(1)
);