diff options
author | trose <trose> | 1999-04-22 03:44:42 +0000 |
---|---|---|
committer | trose <trose> | 1999-04-22 03:44:42 +0000 |
commit | 4817181270336367daf080ee01866cf9bd1d4cc5 (patch) | |
tree | addc1042fdea498ea5149eaf5ce354c7b8b6e09c /schema.sql | |
parent | df2a7c9e88e74e862aa0e4abd612b7d8eaead236 (diff) |
*** empty log message ***
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 6 |
1 files changed, 4 insertions, 2 deletions
@@ -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) ); + |