1ALTER TABLE `tblannouncements` ADD `parentid` INT( 10 ) NOT NULL , ADD `language` TEXT NOT NULL ;
  2
  3ALTER TABLE `tblknowledgebase` ADD `parentid` INT( 10 ) NOT NULL , ADD `language` TEXT NOT NULL ;
  4ALTER TABLE `tblknowledgebasecats` ADD `catid` INT( 10 ) NOT NULL , ADD `language` TEXT NOT NULL ;
  5
  6ALTER TABLE `tbltickets` CHANGE `adminunread` `adminunread` TEXT NOT NULL ;
  7
  8ALTER TABLE `tblpromotions` ADD `requires` TEXT NOT NULL AFTER `appliesto` , ADD `requiresexisting` INT( 1 ) NOT NULL AFTER `requires` ;
  9
 10ALTER TABLE `tblcontacts` ADD `subaccount` INT( 1 ) NOT NULL DEFAULT '0' AFTER `phonenumber` ,
 11ADD `password` TEXT NOT NULL AFTER `subaccount` ,
 12ADD `permissions` TEXT NOT NULL AFTER `password`;
 13
 14INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('CreateDomainInvoiceDaysBefore', '');
 15INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('NoInvoiceEmailOnOrder', '');
 16INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('TaxInclusiveDeduct', '');
 17INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('LateFeeMinimum', '0.00');
 18INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('AutoProvisionExistingOnly', '');
 19
 20CREATE TABLE IF NOT EXISTS `tblticketstatuses` (
 21  `id` int(10) NOT NULL auto_increment,
 22  `title` text COLLATE utf8_unicode_ci NOT NULL,
 23  `color` text COLLATE utf8_unicode_ci NOT NULL,
 24  `sortorder` int(2) NOT NULL,
 25  `showactive` int(1) NOT NULL,
 26  `showawaiting` int(1) NOT NULL,
 27  `autoclose` int(1) NOT NULL,
 28  PRIMARY KEY  (`id`)
 29) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 30
 31INSERT INTO `tblticketstatuses` (`id`, `title`, `color`, `sortorder`, `showactive`, `showawaiting`, `autoclose`) VALUES
 32(1, 'Open', '#779500', 1, 1, 1, 0),
 33(2, 'Answered', '#000000', 2, 1, 0, 1),
 34(3, 'Customer-Reply', '#ff6600', 3, 1, 1, 1),
 35(4, 'Closed', '#888888', 10, 0, 0, 0),
 36(5, 'On Hold', '#224488', 5, 1, 0, 0),
 37(6, 'In Progress', '#cc0000', 6, 1, 0, 0);
 38
 39ALTER TABLE `tblhosting` ADD `promoid` INT( 10 ) NOT NULL AFTER `subscriptionid` ;
 40ALTER TABLE `tbldomains` ADD `promoid` INT( 10 ) NOT NULL AFTER `subscriptionid` ;
 41
 42ALTER TABLE `tblpricing` ADD `triennially` DECIMAL( 10, 2 ) NOT NULL ;
 43ALTER TABLE `tblpricing` ADD `tsetupfee` DECIMAL( 10, 2 ) NOT NULL AFTER `bsetupfee` ;
 44UPDATE tblpricing SET triennially='-1' WHERE type='product';
 45
 46INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('EnableDomainRenewalOrders', 'on');
 47INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('EnableMassPay', 'on');
 48
 49ALTER TABLE `tblorders` ADD `renewals` TEXT NOT NULL AFTER `transfersecret` ;
 50
 51ALTER TABLE `tblbillableitems` ADD `hours` DECIMAL( 5, 1 ) NOT NULL AFTER `description` ;
 52