home *** CD-ROM | disk | FTP | other *** search
/ Chip 2003 July / CMCD0703.ISO / Software / Freeware / Programare / bugzero / WEB-INF / classes / sql / create_table_field.sql < prev    next >
Encoding:
Text File  |  2003-05-14  |  355 b   |  11 lines
  1. # create the fieldset table
  2. CREATE TABLE fieldset (
  3.   project_id VARCHAR(50) NOT NULL,
  4.   field_name INT NOT NULL,
  5.   item VARCHAR(200) NOT NULL,
  6.   item_order INT NOT NULL,
  7.   CONSTRAINT fieldset_pk PRIMARY KEY (project_id, field_name, item),    
  8.   CONSTRAINT fieldset_project FOREIGN KEY (project_id)
  9.     REFERENCES project
  10.     ON_DELETE_CASCADE
  11. )