home *** CD-ROM | disk | FTP | other *** search
/ Chip 2005 May / CMCD0505.ISO / Software / Shareware / Programare / bugzero / WEB-INF / classes / sql / create_table_project.sql < prev    next >
Encoding:
Text File  |  2005-02-21  |  390 b   |  14 lines
  1. # create the project table
  2. # set project_status to 'D' to de-activate it, 'A' or NULL is for active.
  3. CREATE TABLE project (
  4.   project_id VARCHAR(50) NOT NULL,
  5.   project_name VARCHAR(255) NOT NULL,
  6.   project_ssn INT,
  7.   project_desc TEXT,
  8.   project_status CHAR(1),
  9.   field_order VARCHAR(255),
  10.   email VARCHAR(255),
  11.   email_subject VARCHAR(255),
  12.   email_body TEXT,
  13.   PRIMARY KEY (project_id)
  14. )