| Tickets | CREATE TABLE `Tickets` (
  `id` int(11) NOT NULL auto_increment,
  `EffectiveId` int(11) NOT NULL default '0',
  `Queue` int(11) NOT NULL default '0',
  `Type` varchar(16) default NULL,
  `IssueStatement` int(11) NOT NULL default '0',
  `Resolution` int(11) NOT NULL default '0',
  `Owner` int(11) NOT NULL default '0',
  `Subject` varchar(200) default '[no subject]',
  `InitialPriority` int(11) NOT NULL default '0',
  `FinalPriority` int(11) NOT NULL default '0',
  `Priority` int(11) NOT NULL default '0',
  `TimeEstimated` int(11) NOT NULL default '0',
  `TimeWorked` int(11) NOT NULL default '0',
  `Status` varchar(10) default NULL,
  `TimeLeft` int(11) NOT NULL default '0',
  `Told` datetime default NULL,
  `Starts` datetime default NULL,
  `Started` datetime default NULL,
  `Due` datetime default NULL,
  `Resolved` datetime default NULL,
  `LastUpdatedBy` int(11) NOT NULL default '0',
  `LastUpdated` datetime default NULL,
  `Creator` int(11) NOT NULL default '0',
  `Created` datetime default NULL,
  `Disabled` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `Tickets1` (`Queue`,`Status`),
  KEY `Tickets2` (`Owner`),
  KEY `Tickets6` (`EffectiveId`,`Type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |