-- 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(5) DEFAULT NULL,
  `ticket_remaining` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 2015-04-23 (mon) update the length of ticket_not_used and ticket_remaining to 5 though i already updated the main sql for this table
ALTER TABLE `ticket_info` 
CHANGE `ticket_not_used` `ticket_not_used` VARCHAR(5) CHARSET utf8 COLLATE utf8_general_ci NULL, 
CHANGE `ticket_remaining` `ticket_remaining` VARCHAR(5) CHARSET utf8 COLLATE utf8_general_ci NULL;