projects
/
technostate.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
changes for kirsten
[technostate.git]
/
schema.sql
diff --git
a/schema.sql
b/schema.sql
index
bb3c482
..
f26b40e
100644
(file)
--- a/
schema.sql
+++ b/
schema.sql
@@
-3,7
+3,7
@@
CREATE TABLE CREWS (
CREW VARCHAR(80) NOT NULL,
DESCRIPTION VARCHAR(160),
KEYWORDS VARCHAR(160),
CREW VARCHAR(80) NOT NULL,
DESCRIPTION VARCHAR(160),
KEYWORDS VARCHAR(160),
-
HOMEPAGE
VARCHAR(80),
+
URL
VARCHAR(80),
INDEX ( CREW_ID ),
INDEX ( NAME )
);
INDEX ( CREW_ID ),
INDEX ( NAME )
);
@@
-11,6
+11,7
@@
CREATE TABLE CREWS (
CREATE TABLE CREWS_PERSONS (
CREW_ID INT NOT NULL,
PERSON_ID INT NOT NULL,
CREATE TABLE CREWS_PERSONS (
CREW_ID INT NOT NULL,
PERSON_ID INT NOT NULL,
+ TITLE VARCHAR(80),
INDEX ( CREW_ID ),
INDEX ( PERSON_ID )
);
INDEX ( CREW_ID ),
INDEX ( PERSON_ID )
);
@@
-20,13
+21,29
@@
CREATE TABLE PERSONS (
NAME VARCHAR(80) NOT NULL,
DESCRIPTION VARCHAR(160),
EMAIL VARCHAR(80),
NAME VARCHAR(80) NOT NULL,
DESCRIPTION VARCHAR(160),
EMAIL VARCHAR(80),
-
HOMEPAGE
VARCHAR(80),
+
URL
VARCHAR(80),
KEYWORDS VARCHAR(160),
PICTURE LONGBLOB,
INDEX ( PERSON_ID ),
INDEX ( NAME )
);
KEYWORDS VARCHAR(160),
PICTURE LONGBLOB,
INDEX ( PERSON_ID ),
INDEX ( NAME )
);
+CREATE TABLE CONTACTS (
+ PERSON_ID INT PRIMARY KEY,
+ TITLE VARCHAR(80),
+ PHONE VARCHAR(80),
+ PAGER VARCHAR(20),
+ CELL VARCHAR(20),
+ FAX VARCHAR(10),
+ EMAIL VARCHAR(80),
+ ADDRESS1 VARCHAR(80),
+ ADDRESS2 VARCHAR(80),
+ CITY VARCHAR(80),
+ STATE VARCHAR(80),
+ ZIP VARCHAR(10),
+ COUNTRY CHAR(2),
+);
+
CREATE TABLE PERSONS_SETS (
PERSON_ID INT NOT NULL,
SET_ID INT NOT NULL,
CREATE TABLE PERSONS_SETS (
PERSON_ID INT NOT NULL,
SET_ID INT NOT NULL,
@@
-88,6
+105,10
@@
CREATE TABLE STUDIOS (
CREATE TABLE GEARS (
GEAR_ID INT AUTO_INCREMENT PRIMARY KEY,
CREATE TABLE GEARS (
GEAR_ID INT AUTO_INCREMENT PRIMARY KEY,
+ GEAR VARCHAR(80) NOT NULL,
+ DESCRIPTION VARCHAR(160),
+ PRICE FLOAT
+ URL VARCHAR(80),
);
CREATE TABLE PERSONS_GEARS (
);
CREATE TABLE PERSONS_GEARS (