diff options
-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) ); + |