summaryrefslogtreecommitdiff
path: root/schema.sql
diff options
context:
space:
mode:
authortrose <trose>1999-04-22 03:44:42 +0000
committertrose <trose>1999-04-22 03:44:42 +0000
commit4817181270336367daf080ee01866cf9bd1d4cc5 (patch)
treeaddc1042fdea498ea5149eaf5ce354c7b8b6e09c /schema.sql
parentdf2a7c9e88e74e862aa0e4abd612b7d8eaead236 (diff)
*** empty log message ***
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql6
1 files changed, 4 insertions, 2 deletions
diff --git a/schema.sql b/schema.sql
index de827ea..64c12cd 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 (
@@ -44,3 +45,4 @@ CREATE TABLE STUDIOS (
ISLIVE CHAR(1)
);
+