home *** CD-ROM | disk | FTP | other *** search
/ Chip 2003 July / CMCD0703.ISO / Software / Freeware / Programare / bugzero / WEB-INF / classes / sql / create_table_access.sql < prev    next >
Encoding:
Text File  |  2003-01-21  |  397 b   |  12 lines
  1. # create the accesscode table
  2. CREATE TABLE accesscode (
  3.   project_id VARCHAR(50) NOT NULL,
  4.   person_id INT NOT NULL,
  5.   access_code CHAR(8) NOT NULL,
  6.   CONSTRAINT access_pk PRIMARY KEY (project_id, person_id),    
  7.   CONSTRAINT access_project FOREIGN KEY (project_id)
  8.     REFERENCES project,
  9.   CONSTRAINT access_person FOREIGN KEY (person_id)
  10.     REFERENCES person
  11.     ON_DELETE_CASCADE
  12. )