X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=schema.sql;h=5fc2635d4f85a6d20e57f9d8eb92097b08e52392;hb=c3c2bd39d9b8ddfc300550bb30f78e602862742e;hp=de827eac1c25d941336de70abd156e03d8222244;hpb=df2a7c9e88e74e862aa0e4abd612b7d8eaead236;p=technostate.git

diff --git a/schema.sql b/schema.sql
index de827ea..5fc2635 100644
--- a/schema.sql
+++ b/schema.sql
@@ -1,9 +1,10 @@
 
 CREATE TABLE PERSONS (
-  ID INT AUTO_INCREMENT PRIMARY KEY,
+  PERSON_ID INT AUTO_INCREMENT PRIMARY KEY,
   NAME VARCHAR(80) NOT NULL,
   EMAIL VARCHAR(80),
-  AFFILIATION VARCHAR(80)
+  AFFILIATION VARCHAR(80),
+  HOMEPAGE VARCHAR(80)
 );
 
 CREATE TABLE PERSONS_SETS (
@@ -14,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),
@@ -29,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,
@@ -39,8 +40,9 @@ 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)
 );
 
+