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

CREATE TABLE ticket(
  -- Do not change any column that begins with tkt_
  tkt_id INTEGER PRIMARY KEY,
  tkt_uuid TEXT UNIQUE,
  tkt_mtime DATE,
  -- Add as many field as required below this line
  type TEXT,
  status TEXT,
  subsystem TEXT,
  priority TEXT,
  severity TEXT,
  foundin TEXT,
  private_contact TEXT,
  assignee TEXT,
  resolution TEXT,
  closer TEXT,
  title TEXT,
  comment TEXT,
  is_private INTEGER
);