Posted to tcl by kbk at Fri Nov 30 02:02:37 GMT 2012view raw

  1. CREATE TABLE ticket(
  2. -- Do not change any column that begins with tkt_
  3. tkt_id INTEGER PRIMARY KEY,
  4. tkt_uuid TEXT UNIQUE,
  5. tkt_mtime DATE,
  6. -- Add as many field as required below this line
  7. type TEXT,
  8. status TEXT,
  9. subsystem TEXT,
  10. priority TEXT,
  11. severity TEXT,
  12. foundin TEXT,
  13. private_contact TEXT,
  14. assignee TEXT,
  15. resolution TEXT,
  16. closer TEXT,
  17. title TEXT,
  18. comment TEXT,
  19. is_private INTEGER
  20. );