home *** CD-ROM | disk | FTP | other *** search
- # create the accesscode table
- CREATE TABLE accesscode (
- project_id VARCHAR(50) NOT NULL,
- person_id INT NOT NULL,
- access_code CHAR(8) NOT NULL,
- CONSTRAINT access_pk PRIMARY KEY (project_id, person_id),
- CONSTRAINT access_project FOREIGN KEY (project_id)
- REFERENCES project,
- CONSTRAINT access_person FOREIGN KEY (person_id)
- REFERENCES person
- ON_DELETE_CASCADE
- )