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 );