1ALTER TABLE `tbladmins` ADD `homewidgets` TEXT NOT NULL ;
  2ALTER TABLE `tbladminroles` ADD `widgets` TEXT NOT NULL AFTER `name` ;
  3UPDATE `tbladminroles` SET `widgets`='activity_log,getting_started,income_forecast,income_overview,my_notes,network_status,open_invoices,orders_overview,paypal_addon,admin_activity,client_activity,system_overview,todo_list,whmcs_news' WHERE `id`=1;
  4UPDATE `tbladminroles` SET `widgets`='activity_log,getting_started,income_forecast,income_overview,my_notes,network_status,open_invoices,orders_overview,paypal_addon,client_activity,todo_list,whmcs_news' WHERE `id`=2;
  5UPDATE `tbladminroles` SET `widgets`='activity_log,getting_started,my_notes,todo_list,whmcs_news' WHERE `id`=3;
  6
  7INSERT INTO `tblemailtemplates` (`type`, `name`, `subject`, `message`, `plaintext`) VALUES ('admin', 'Support Ticket Department Reassigned', '[Ticket ID: {$ticket_tid}] Support Ticket Department Reassigned', '<p>The department this ticket is assigned to has been changed to a department you are a member of.</p><p>Client: {$client_name}{if $client_id} #{$client_id}{/if}<br />Department: {$ticket_department}<br />Subject: {$ticket_subject}<br />Priority: {$ticket_priority}</p><p>---<br />{$ticket_message}<br />---</p><p>You can respond to this ticket by simply replying to this email or through the admin area at the url below.</p><p><a href="{$whmcs_admin_url}supporttickets.php?action=viewticket&id={$ticket_id}">{$whmcs_admin_url}supporttickets.php?action=viewticket&id={$ticket_id}</a></p>', '0');
  8
  9INSERT INTO `tblconfiguration` ( `setting` , `value` ) VALUES ( 'AttachmentThumbnails','on' );
 10
 11ALTER TABLE `tblaffiliates` ADD `onetime` INT(1) NOT NULL AFTER `payamount` ;
 12ALTER TABLE `tblaffiliateshistory` ADD `description` TEXT NOT NULL AFTER `affaccid` ;
 13
 14ALTER TABLE `tblproducts` ADD `recurringcycles` INT(2) NOT NULL AFTER `freedomaintlds` ;
 15ALTER TABLE `tblproducts` ADD `allowqty` INT(1) NOT NULL AFTER `paytype`;
 16
 17INSERT INTO `tblemailtemplates` (`type`, `name`, `subject`, `message`, `plaintext`) VALUES('invoice', 'Invoice Refund Confirmation', 'Invoice Refund Confirmation', '<p>Dear {$client_name},</p>\r\n<p>This is confirmation that a {if $invoice_status eq "Refunded"}full{else}partial{/if} refund has been processed for Invoice #{$invoice_num}</p>\r\n<p>The refund has been {if $invoice_refund_type eq "credit"}credited to your account balance with us{else}returned via the payment method you originally paid with{/if}.</p>\r\n<p>{$invoice_html_contents}</p>\r\n<p>Amount Refunded: {$invoice_last_payment_amount}{if $invoice_last_payment_transid}<br />Transaction #: {$invoice_last_payment_transid}{/if}</p>\r\n<p>You may review your invoice history at any time by logging in to your client area.</p>\r\n<p>{$signature}</p>', 0);
 18
 19ALTER TABLE `tblservers` ADD `nameserver5` TEXT NOT NULL AFTER `nameserver4ip` ,
 20 ADD `nameserver5ip` TEXT NOT NULL AFTER `nameserver5`;
 21
 22CREATE TABLE IF NOT EXISTS `tblemailmarketer` (
 23  `id` int(10) NOT NULL AUTO_INCREMENT,
 24  `name` text COLLATE utf8_unicode_ci NOT NULL,
 25  `type` text COLLATE utf8_unicode_ci NOT NULL,
 26  `settings` text COLLATE utf8_unicode_ci NOT NULL,
 27  `disable` int(1) NOT NULL,
 28  PRIMARY KEY (`id`)
 29) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 30
 31ALTER TABLE `tblknowledgebase` ADD `order` INT(3) NOT NULL AFTER `private` ;
 32
 33CREATE TABLE IF NOT EXISTS `tblbundles` (
 34  `id` int(10) NOT NULL AUTO_INCREMENT,
 35  `name` text COLLATE utf8_unicode_ci NOT NULL,
 36  `validfrom` date NOT NULL,
 37  `validuntil` date NOT NULL,
 38  `uses` int(4) NOT NULL,
 39  `maxuses` int(4) NOT NULL,
 40  `itemdata` text COLLATE utf8_unicode_ci NOT NULL,
 41  `allowpromo` int(1) NOT NULL,
 42  PRIMARY KEY (`id`)
 43) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 44
 45CREATE TABLE IF NOT EXISTS `tblmodulelog` (
 46  `id` int(10) NOT NULL AUTO_INCREMENT,
 47  `date` DATETIME NOT NULL,
 48  `module` text COLLATE utf8_unicode_ci NOT NULL,
 49  `action` text COLLATE utf8_unicode_ci NOT NULL,
 50  `request` text COLLATE utf8_unicode_ci NOT NULL,
 51  `response` text COLLATE utf8_unicode_ci NOT NULL,
 52  `arrdata` text COLLATE utf8_unicode_ci NOT NULL,
 53  PRIMARY KEY (`id`)
 54) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 55
 56INSERT INTO `tbladminperms` (`roleid`, `permid`) VALUES ('1', '101'), ('2', '101'), ('1', '102'), ('1', '103');
 57
 58INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES('EmailGlobalHeader', '&lt;p&gt;&lt;a href=&quot;{$company_domain}&quot; target=&quot;_blank&quot;&gt;&lt;img src=&quot;{$company_logo_url}&quot; alt=&quot;{$company_name}&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;/p&gt;');
 59INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES('EmailGlobalFooter', '');
 60