-- 2015-03-20 create ticket_info table
CREATE TABLE `ticket_info` (
  `id` char(36) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `date_entered` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  `category` tinyint(4) DEFAULT NULL,
  `contact_id` char(36) DEFAULT NULL,
  `ticket_type` varchar(10) DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `ticket_not_used` varchar(2) DEFAULT NULL,
  `ticket_remaining` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;