home *** CD-ROM | disk | FTP | other *** search
/ Chip 2005 May / CMCD0505.ISO / Software / Shareware / Programare / bugzero / WEB-INF / classes / sql / create_table_email.sql < prev    next >
Encoding:
Text File  |  2005-01-08  |  355 b   |  13 lines
  1. # create the email template table
  2. CREATE TABLE email (
  3.   project_id VARCHAR(50) NOT NULL,
  4.   group_code VARCHAR(255) NOT NULL,
  5.   state VARCHAR(255),
  6.   email_subject VARCHAR(255),
  7.   email_body TEXT,
  8.   CONSTRAINT reminder_pk PRIMARY KEY (project_id,name),
  9.   CONSTRAINT reminder_project FOREIGN KEY (project_id)
  10.     REFERENCES project
  11.     ON DELETE CASCADE
  12. )
  13.