-- This script should only be used to 
-- upgrade from osTicket 1.2.5 to osTicket Community Edition (2006-08-12)

CREATE TABLE `ticket_assign` (
  `ticket` int(11) NOT NULL default '0',
  `assigned_to` int(5) NOT NULL default '0'
) ENGINE=MyISAM;

ALTER TABLE `ticket_banlist` ADD COLUMN `value_id` int(11) NOT NULL auto_increment PRIMARY KEY;

ALTER TABLE `ticket_categories` ADD COLUMN `popproto` tinyint(4) NOT NULL default '0' AFTER `poppass`;
ALTER TABLE `ticket_categories` ADD COLUMN `popssl` tinyint(4) NOT NULL default '0' AFTER `popproto`;
ALTER TABLE `ticket_categories` ADD COLUMN `popvcert` tinyint(4) NOT NULL default '0' AFTER `popssl`;

ALTER TABLE `ticket_config` ADD COLUMN `filetypes` text NOT NULL AFTER `root_url`;

ALTER TABLE `ticket_groups` ADD COLUMN `banlist` int(1) NOT NULL default '0' AFTER `user_group`;