1ALTER TABLE `tblproducts` ADD `order` INT( 1 ) NOT NULL ;
  2
  3INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('LateFeeType', 'Percentage');
  4
  5CREATE TABLE IF NOT EXISTS `tblnotes` (
  6`id` INT( 1 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
  7`userid` INT( 10 ) UNSIGNED ZEROFILL NOT NULL ,
  8`adminid` INT( 1 ) NOT NULL ,
  9`created` DATETIME NOT NULL ,
 10`modified` DATETIME NOT NULL ,
 11`note` TEXT COLLATE utf8_unicode_ci NOT NULL
 12) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 13
 14ALTER TABLE `tblproductconfigoptionssub` ADD `setup` DECIMAL( 10, 2 ) NOT NULL AFTER `optionname` ;
 15
 16ALTER TABLE `tblemailtemplates` ADD `copyto` TEXT NOT NULL ;
 17ALTER TABLE `tblemailtemplates` ADD `plaintext` INT( 1 ) NOT NULL ;
 18
 19ALTER TABLE `tblinvoices` ADD `invoicenum` TEXT NOT NULL AFTER `id` ;
 20
 21ALTER TABLE `tbldownloads` ADD `productdownload` TEXT NOT NULL ;
 22ALTER TABLE `tblproducts` ADD `downloads` TEXT NOT NULL AFTER `affiliatepayamount` ;
 23
 24UPDATE tblconfiguration SET setting='SendFirstOverdueInvoiceReminder' WHERE setting='SendOverdueInvoiceReminders';
 25INSERT INTO `tblconfiguration` (`setting` ,`value` )VALUES ('SendSecondOverdueInvoiceReminder', '0');
 26INSERT INTO `tblconfiguration` (`setting` ,`value` )VALUES ('SendThirdOverdueInvoiceReminder', '0');
 27
 28UPDATE tblemailtemplates SET name='First Invoice Overdue Notice' WHERE name='Invoice Overdue Notice';
 29UPDATE tblemailtemplates SET subject='First Invoice Overdue Notice' WHERE subject='Invoice Overdue Notice';
 30
 31INSERT INTO `tblemailtemplates` (type,name,subject,message) VALUES ( 'invoice', 'Second Invoice Overdue Notice', 'Second Invoice Overdue Notice', '<p> Dear [CustomerName], </p> <p> This is the second billing notice that your invoice no. [InvoiceNo] which was generated on [InvoiceDate] is now overdue. </p> <p> Your payment method is: [PaymentMethod] </p> <p> Invoice: [InvoiceNo]<br /> Balance Due: [Balance]<br /> Due Date: [DueDate] </p> <p> You can login to your client area to view and pay the invoice at [InvoiceLink] </p> <p> Your login details are as follows: </p> <p> Email Address: [CustomerEmail]<br /> Password: [CAPassword] </p> <p> [Signature] </p>');
 32INSERT INTO `tblemailtemplates` (type,name,subject,message) VALUES ( 'invoice', 'Third Invoice Overdue Notice', 'Third Invoice Overdue Notice', '<p> Dear [CustomerName], </p> <p> This is the third and final billing notice that your invoice no. [InvoiceNo] which was generated on [InvoiceDate] is now overdue. Failure to make payment will result in account suspension.</p> <p> Your payment method is: [PaymentMethod] </p> <p> Invoice: [InvoiceNo]<br /> Balance Due: [Balance]<br /> Due Date: [DueDate] </p> <p> You can login to your client area to view and pay the invoice at [InvoiceLink] </p> <p> Your login details are as follows: </p> <p> Email Address: [CustomerEmail]<br /> Password: [CAPassword] </p> <p> [Signature] </p>');
 33