summaryrefslogtreecommitdiff
path: root/schema.sql
diff options
context:
space:
mode:
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)
);
+