home *** CD-ROM | disk | FTP | other *** search
/ Chip 2005 May / CMCD0505.ISO / Software / Shareware / Programare / bugzero / WEB-INF / classes / sql / create_table_fieldname.sql < prev    next >
Encoding:
Text File  |  2005-02-21  |  467 b   |  17 lines
  1. # create the fieldname table
  2. create table fieldname (
  3.   project_id VARCHAR(50) NOT NULL,
  4.   field_name INT NOT NULL,
  5.   field_label VARCHAR(255) NOT NULL,
  6.   field_type TINYINT,
  7.   field_default VARCHAR(255),
  8.   max_length INT,
  9.   mandatory CHAR(1),
  10.   denied_groups VARCHAR(255),
  11.   ro_groups VARCHAR(255),
  12.   CONSTRAINT fieldname_pk PRIMARY KEY (project_id, field_name),
  13.   CONSTRAINT fieldname_project FOREIGN KEY (project_id)
  14.     REFERENCES project
  15.     ON DELETE CASCADE
  16. )
  17.