home *** CD-ROM | disk | FTP | other *** search
/ Chip 2003 July / CMCD0703.ISO / Software / Freeware / Programare / bugzero / WEB-INF / classes / sql / create_table_workflow.sql < prev    next >
Encoding:
Text File  |  2003-05-14  |  446 b   |  12 lines
  1. # create the workflow table
  2. # w_type = 1 for next_allowed states, 2 for current_allowed assignee, 3 for group.
  3. CREATE TABLE workflow (
  4.   project_id VARCHAR(50) NOT NULL,
  5.   w_name VARCHAR(50) NOT NULL,
  6.   w_type TINYINT NOT NULL,
  7.   w_allowed VARCHAR(255) NOT NULL,
  8.   CONSTRAINT workflow_pk PRIMARY KEY (project_id, w_name, w_type),    
  9.   CONSTRAINT workflow_project FOREIGN KEY (project_id)
  10.     REFERENCES project
  11.     ON_DELETE_CASCADE
  12. )