home *** CD-ROM | disk | FTP | other *** search
/ Chip 2005 May / CMCD0505.ISO / Software / Shareware / Programare / bugzero / WEB-INF / classes / sql / create_table_file.sql < prev    next >
Encoding:
Text File  |  2004-09-26  |  373 b   |  12 lines
  1. # create the file attachment table
  2. CREATE TABLE $PROJECT_file (
  3.   trail_id INT NOT NULL,
  4.   filename VARCHAR(200) NOT NULL,
  5.   content_type VARCHAR(50) NOT NULL,
  6.   file_content LONGBINARY NOT NULL,
  7.   file_size INT,
  8.   CONSTRAINT $PROJECT2 PRIMARY KEY (trail_id, filename),    
  9.   CONSTRAINT $PROJECT3 FOREIGN KEY (trail_id)
  10.     REFERENCES $PROJECT_trail
  11.     ON DELETE CASCADE
  12. )