1ALTER TABLE `tblticketdepartments` ADD `piperepliesonly` TEXT NOT NULL AFTER `clientsonly` ;
  2
  3CREATE TABLE IF NOT EXISTS `tblservergroups` (
  4`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
  5`name` TEXT COLLATE utf8_unicode_ci NOT NULL ,
  6`filltype` INT( 1 ) NOT NULL
  7) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  8
  9
 10CREATE TABLE IF NOT EXISTS `tblservergroupsrel` (
 11`groupid` INT( 10 ) NOT NULL ,
 12`serverid` INT( 10 ) NOT NULL
 13) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 14
 15ALTER TABLE `tblproducts` DROP `defaultserver` ;
 16ALTER TABLE `tblproducts` ADD `servergroup` INT( 10 ) NOT NULL AFTER `servertype` ;
 17
 18INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('DisableSessionIPCheck', '');
 19
 20ALTER TABLE `tblclients` ADD `cardlastfour` TEXT NOT NULL AFTER `cardtype` ;
 21
 22ALTER TABLE `tbladdons` ADD `downloads` TEXT NOT NULL ,
 23ADD `autoactivate` TEXT NOT NULL ,
 24ADD `welcomeemail` INT( 10 ) NOT NULL ;
 25
 26ALTER TABLE `tblhostingaddons` ADD `addonid` INT( 10 ) NOT NULL AFTER `hostingid` ;
 27
 28ALTER TABLE `tblproductconfigoptions` ADD `hidden` INT( 1 ) NOT NULL ;
 29ALTER TABLE `tblproductconfigoptionssub` ADD `hidden` INT( 1 ) NOT NULL ;
 30
 31ALTER TABLE `tbltickets` ADD `cc` TEXT NOT NULL AFTER `email` ;
 32INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('DisableSupportTicketReplyEmailsLogging', '');
 33
 34CREATE TABLE IF NOT EXISTS `tblclientsfiles` (
 35`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
 36`userid` INT( 10 ) NOT NULL ,
 37`title` TEXT COLLATE utf8_unicode_ci NOT NULL ,
 38`filename` TEXT COLLATE utf8_unicode_ci NOT NULL ,
 39`adminonly` INT( 1 ) NOT NULL ,
 40`dateadded` DATE NOT NULL
 41) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 42
 43ALTER TABLE `tblclients` ADD `pwresetkey` TEXT NOT NULL , ADD `pwresetexpiry` INT( 10 ) NOT NULL ;
 44INSERT INTO `tblemailtemplates` (`id`, `type`, `name`, `subject`, `message`, `fromname`, `fromemail`, `disabled`, `custom`, `language`, `copyto`, `plaintext`) VALUES (NULL, 'general', 'Password Reset Validation', 'Your login details for {$company_name}', '<p>Dear {$client_name},</p><p>Recently a request was submitted to reset your password for our client area. If you did not request this, please ignore this email. It will expire and become useless in 2 hours time.</p><p>To reset your password, please visit the url below:<br /><a href="{$pw_reset_url}">{$pw_reset_url}</a></p><p>When you visit the link above, your password will be reset, and the new password will be emailed to you.</p><p>{$signature}</p>', '', '', '', '', '', '', '0');
 45INSERT INTO `tblemailtemplates` (`id`, `type`, `name`, `subject`, `message`, `fromname`, `fromemail`, `disabled`, `custom`, `language`, `copyto`, `plaintext`) VALUES (NULL, 'general', 'Password Reset Confirmation', 'Your new password for {$company_name}', '<p>Dear {$client_name},</p><p>As you requested, your password for our client area has now been reset.  Your new login details are as follows:</p><p>{$whmcs_link}<br />Email: {$client_email}<br />Password: {$client_password}</p><p>To change your password to something more memorable, after logging in go to My Details > Change Password.</p><p>{$signature}</p>', '', '', '', '', '', '', '0');
 46
 47ALTER TABLE `tblproducts` ADD `overagesenabled` INT( 1 ) NOT NULL AFTER `billingcycleupgrade` ,
 48ADD `overagesdisklimit` INT( 10 ) NOT NULL AFTER `overagesenabled` ,
 49ADD `overagesbwlimit` INT( 10 ) NOT NULL AFTER `overagesdisklimit` ,
 50ADD `overagesdiskprice` DECIMAL( 6, 4 ) NOT NULL AFTER `overagesbwlimit` ,
 51ADD `overagesbwprice` DECIMAL( 6, 4 ) NOT NULL AFTER `overagesdiskprice` ;
 52INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('OverageBillingMethod', '1');
 53
 54ALTER TABLE `tblproductconfigoptions` ADD `qtyminimum` INT( 10 ) NOT NULL AFTER `optiontype` ,
 55ADD `qtymaximum` INT( 10 ) NOT NULL AFTER `qtyminimum` ;
 56
 57ALTER TABLE `tblcustomfields` ADD `description` TEXT NOT NULL AFTER `fieldtype` ;
 58
 59INSERT INTO `tblconfiguration` (`setting` ,`value`)VALUES ('CCNeverStore', '');
 60INSERT INTO `tblconfiguration` (`setting` ,`value`)VALUES ('CCAllowCustomerDelete', '');
 61