ALTER TABLE `#__jltcenter_events` ADD COLUMN `ticket_template` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `feature`;

CREATE TABLE IF NOT EXISTS `#__jltcenter_ticket_template` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `template_type` int(3) NOT NULL DEFAULT '0',
  `name` varchar(50) NOT NULL DEFAULT '',
  `email_title` varchar(250) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `ticket_remark` text NOT NULL,
  `background` varchar(255) NOT NULL DEFAULT '',
  `width` int(3) NOT NULL DEFAULT '0',
  `height` int(3) NOT NULL DEFAULT '0',
  `defualt` tinyint(1) NOT NULL DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;


