home *** CD-ROM | disk | FTP | other *** search
/ Chip 2005 May / CMCD0505.ISO / Software / Shareware / Programare / bugzero / WEB-INF / classes / sql / create_table_mailbox.sql < prev    next >
Encoding:
Text File  |  2004-02-18  |  423 b   |  14 lines
  1. # create the mailbox table
  2. # set mail_status to '0' to stop and "1" to start
  3. CREATE TABLE mailbox (
  4.   name VARCHAR(50) NOT NULL,
  5.   project_id VARCHAR(50) NOT NULL,
  6.   assignable VARCHAR(200),
  7.   refresh_minutes INT,
  8.   pop3 TEXT NOT NULL,
  9.   mailbox_status CHAR(1),
  10.   CONSTRAINT mailbox_pk PRIMARY KEY (name),    
  11.   CONSTRAINT mailbox_project FOREIGN KEY (project_id)
  12.     REFERENCES project
  13.     ON_DELETE_CASCADE
  14. )