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 (
ISLIVE CHAR(1)
);
+