home *** CD-ROM | disk | FTP | other *** search
/ Chip 2005 May / CMCD0505.ISO / Software / Shareware / Programare / bugzero / WEB-INF / classes / sql / create_table_assignment.sql < prev    next >
Encoding:
Text File  |  2004-09-26  |  430 b   |  13 lines
  1. # create the assignment table
  2. CREATE TABLE assignment (
  3.   project_id VARCHAR(50) NOT NULL,
  4.   assignable VARCHAR(200) NOT NULL,
  5.   person_id INT NOT NULL,
  6.   sort_order INT NOT NULL,
  7.   CONSTRAINT assignment_pk PRIMARY KEY (project_id, assignable),    
  8.   CONSTRAINT assignment_project FOREIGN KEY (project_id)
  9.     REFERENCES project,
  10.   CONSTRAINT assignment_person FOREIGN KEY (person_id)
  11.     REFERENCES person
  12.     ON DELETE CASCADE
  13. )