1ALTER TABLE `tbldomains` CHANGE `urlforwarding` `dnsmanagement` TEXT NOT NULL ;
  2UPDATE `tblconfiguration` SET setting='DomainDNSManagement' WHERE setting='DomainURLForwarding' ;
  3ALTER TABLE `tbldomainpricing` ADD `dnsmanagement` TEXT NOT NULL AFTER `renew` , ADD `emailforwarding` TEXT NOT NULL AFTER `dnsmanagement` ;
  4INSERT INTO `tblconfiguration` (`setting` ,`value` )VALUES ('DomainIDProtection','5.00');
  5ALTER TABLE `tbldomainpricing` ADD `idprotection` TEXT NOT NULL AFTER `emailforwarding` ;
  6ALTER TABLE `tbldomainpricing` ADD `eppcode` TEXT NOT NULL AFTER `idprotection` ;
  7ALTER TABLE `tbldomains` ADD `idprotection` TEXT NOT NULL ;
  8ALTER TABLE `tblclients` CHANGE `status` `status` ENUM( "Active", "Inactive" ) NOT NULL ;
  9ALTER TABLE `tblhosting` CHANGE `domainstatus` `domainstatus` ENUM( "Pending", "Active", "Suspended", "Terminated" ) NOT NULL ;
 10ALTER TABLE `tblhostingaddons` CHANGE `status` `status` ENUM( "Pending", "Active", "Suspended", "Terminated" ) NOT NULL ;
 11ALTER TABLE `tbldomains` CHANGE `status` `status` ENUM( "Pending", "Active", "Expired" ) NOT NULL ;
 12DELETE FROM tblemailtemplates WHERE type='addon';
 13DELETE FROM tblemailtemplates WHERE name='Domain Subscription Payment Confirmation';
 14DELETE FROM tblemailtemplates WHERE name='Subscription Payment Confirmation';
 15DELETE FROM tblemailtemplates WHERE name='Subscription Payment Due';
 16INSERT INTO `tblemailtemplates` (type,name,subject,message) VALUES ('domain', 'Domain Transfer Initiated', 'Domain Transfer Initiated', '<p>Dear [CustomerName], </p><p>Thank you for your domain transfer order. Your order has been received and we have now initiated the transfer process. The details of the domain purchase are below: </p><p>Domain: [Domain]<br />Registration Length: [RegPeriod]<br />Transfer Price: [FirstPaymentAmount]<br />Renewal Price: [RecurringAmount]<br />Next Due Date: [NextDueDate] </p><p>You may login to your client area at [ClientAreaLink] to manage your domain. </p><p>[Signature] </p>');
 17INSERT INTO `tblemailtemplates` (type,name,subject,message) VALUES ('domain', 'Domain Renewal Confirmation', 'Domain Renewal Confirmation', '<p>Dear [CustomerName], </p><p>Thank you for your domain renewal order. Your domain renewal request for the domain listed below has now been completed.</p><p>Domain: [Domain]<br />Renewal Length: [RegPeriod]<br />Renewal Price: [RecurringAmount]<br />Next Due Date: [NextDueDate] </p><p>You may login to your client area at [ClientAreaLink] to manage your domain. </p><p>[Signature] </p>');
 18INSERT INTO `tblemailtemplates` (type,name,subject,message) VALUES ('domain', 'Upcoming Domain Renewal Notice', 'Upcoming Domain Renewal Notice', '<p>Dear [CustomerName], </p><p>The domain name listed below will expire in [DaysUntilExpiry] days.</p><p>[Domain] - [NextDueDate]</p><p>To ensure the domain does not expire, you should renew it now. You can do this from the domains management section of our client area here: [ClientAreaLink]</p><p>Should you allow the domain to expire, you will be able to renew it for up to 30 days after the renewal date. During this time, the domain will not be accessible so any web site or email services associated with it will stop working.</p><p>[Signature]</p>');
 19INSERT INTO `tblconfiguration` (`setting` ,`value` )VALUES ('DomainRenewalNotices', '30,7,-3,0,0');
 20UPDATE tblpaymentgateways SET value='Invoices' WHERE gateway='paypal' AND setting='type' ;
 21UPDATE tblpaymentgateways SET value='PayPal' WHERE gateway='paypal' AND setting='name' ;
 22UPDATE tblhosting SET paymentmethod='paypal' WHERE paymentmethod='paypalinvoices';
 23UPDATE tblhostingaddons SET paymentmethod='paypal' WHERE paymentmethod='paypalinvoices';
 24UPDATE tbldomains SET paymentmethod='paypal' WHERE paymentmethod='paypalinvoices';
 25UPDATE tblinvoices SET paymentmethod='paypal' WHERE paymentmethod='paypalinvoices';
 26UPDATE tblaccounts SET gateway='paypal' WHERE gateway='paypalinvoices';
 27UPDATE tblorders SET paymentmethod='paypal' WHERE paymentmethod='paypalinvoices';
 28DELETE FROM tblpaymentgateways WHERE gateway='paypal' AND setting='style' ;
 29DELETE FROM tblpaymentgateways WHERE gateway='paypalinvoices';
 30INSERT INTO `tblpaymentgateways` (`gateway`, `type`, `setting`, `name`, `description`) VALUES ('paypal', 'yesno', 'forcesubscriptions', 'Force Subscriptions', 'Check to hide the one time payment button when a subscription can be created');
 31ALTER TABLE `tbltickets` ADD `replyingadmin` INT( 1 ) NOT NULL , ADD `replyingtime` DATETIME NOT NULL ;
 32INSERT INTO `tblconfiguration` (`setting` ,`value` )VALUES ('SequentialInvoiceNumbering', '');
 33INSERT INTO `tblconfiguration` (`setting` ,`value` )VALUES ('SequentialInvoiceNumberFormat', '{NUMBER}');
 34INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('SequentialInvoiceNumberValue', '1');
 35DELETE FROM tblconfiguration WHERE setting='InvoiceSubscriptionPayments';
 36ALTER TABLE `tblservers` CHANGE `primarynameserver` `nameserver1` TEXT NOT NULL ,CHANGE `primarynameserverip` `nameserver1ip` TEXT NOT NULL ,CHANGE `secondarynameserver` `nameserver2` TEXT NOT NULL ,CHANGE `secondarynameserverip` `nameserver2ip` TEXT NOT NULL ;
 37ALTER TABLE `tblservers` ADD `nameserver3` TEXT NOT NULL AFTER `nameserver2ip` ,ADD `nameserver3ip` TEXT NOT NULL AFTER `nameserver3` ,ADD `nameserver4` TEXT NOT NULL AFTER `nameserver3ip` ,ADD `nameserver4ip` TEXT NOT NULL AFTER `nameserver4` ;
 38INSERT INTO `tblconfiguration` (`setting` ,`value` )VALUES ('DefaultNameserver3', '');
 39INSERT INTO `tblconfiguration` (`setting` ,`value` )VALUES ('DefaultNameserver4', '');
 40ALTER TABLE `tblservers` ADD `accesshash` TEXT NOT NULL AFTER `password` ;
 41UPDATE `tblhosting` SET nextinvoicedate = nextduedate;
 42UPDATE `tbldomains` SET nextinvoicedate = nextduedate;
 43UPDATE `tblhostingaddons` SET nextinvoicedate = nextduedate;
 44