projects
/
technostate.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
bugsquash
[technostate.git]
/
schema.sql
diff --git
a/schema.sql
b/schema.sql
index
de827ea
..
5fc2635
100644
(file)
--- a/
schema.sql
+++ b/
schema.sql
@@
-1,9
+1,10
@@
CREATE TABLE PERSONS (
CREATE TABLE PERSONS (
- ID INT AUTO_INCREMENT PRIMARY KEY,
+
PERSON_
ID INT AUTO_INCREMENT PRIMARY KEY,
NAME VARCHAR(80) NOT NULL,
EMAIL VARCHAR(80),
NAME VARCHAR(80) NOT NULL,
EMAIL VARCHAR(80),
- AFFILIATION VARCHAR(80)
+ AFFILIATION VARCHAR(80),
+ HOMEPAGE VARCHAR(80)
);
CREATE TABLE PERSONS_SETS (
);
CREATE TABLE PERSONS_SETS (
@@
-14,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),
@@
-29,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,
@@
-39,8
+40,9
@@
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)
);
+