1UPDATE `tblemailtemplates` SET name='Hosting Account Welcome Email' WHERE name='Hosting Account Welcome Email (cPanel)';
  2UPDATE `tblemailtemplates` SET custom='1' WHERE name='Hosting Account Welcome Email (DirectAdmin)';
  3UPDATE `tblemailtemplates` SET custom='1' WHERE name='Hosting Account Welcome Email (Plesk)';
  4
  5ALTER TABLE `tblpromotions` ADD `startdate` DATE NOT NULL AFTER `requiresexisting` ;
  6ALTER TABLE `tblpromotions` ADD `notes` TEXT NOT NULL ;
  7
  8ALTER TABLE `tbladdons` ADD `suspendproduct` TEXT NOT NULL AFTER `autoactivate` ;
  9
 10INSERT INTO `tblemailtemplates` (`id`, `type`, `name`, `subject`, `message`, `fromname`, `fromemail`, `disabled`, `custom`, `language`, `copyto`, `plaintext`) VALUES ('', 'admin', 'Escalation Rule Notification', '[Ticket ID: {$tickettid}] Escalation Rule Notification', '<p>The escalation rule {$name} has just been applied to this ticket.</p>\r\n<p>Client: {$clientname}<br />Department: {$deptname}<br />Subject: {$ticketsubject}<br />Priority: {$ticketpriority}<br />Status: {$ticketstatus}</p>\r\n<p>You can respond to this ticket by simply replying to this email or by logging into the administration area.</p>', '', '', '', '', '', '', 0);
 11
 12ALTER TABLE `tblcustomfields` ADD `showinvoice` TEXT NOT NULL AFTER `showorder` ;
 13
 14ALTER TABLE `tblproducts` ADD `autoterminatedays` INT( 4) NOT NULL AFTER `freedomaintlds` ,
 15ADD `autoterminateemail` TEXT NOT NULL AFTER `autoterminatedays` ;
 16
 17INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('GenerateRandomUsername', '');
 18
 19ALTER TABLE `tblservers` ADD `assignedips` TEXT NOT NULL AFTER `ipaddress` ;
 20
 21ALTER TABLE `tblquotes` ADD `proposal` TEXT NOT NULL AFTER `total` ;
 22
 23INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('AddFundsRequireOrder', 'on');
 24
 25INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('GroupSimilarLineItems', 'on');
 26
 27INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('ProrataClientsAnniversaryDate', '');
 28
 29INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('TCPDFFont', 'helvetica');
 30
 31ALTER TABLE `tblservers` CHANGE `active` `active` INT(1) NOT NULL ;
 32ALTER TABLE `tblservers` ADD `disabled` INT(1) NOT NULL ;
 33
 34ALTER TABLE `tblemailtemplates` ADD `attachments` TEXT NOT NULL AFTER `message` ;
 35
 36ALTER TABLE `tblpromotions` ADD `upgrades` INT(1) NOT NULL AFTER `recurfor` ,
 37ADD `upgradeconfig` TEXT NOT NULL AFTER `upgrades` ;
 38
 39INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('CancelInvoiceOnCancellation', 'on');
 40