芝麻web文件管理V1.00

编辑当前文件:/home/pulsehostuk9/public_html/portal.pulsehost.co.uk/resources/sql/upgrade330.sql

ALTER TABLE `tblproducts` ADD `order` INT( 1 ) NOT NULL ;

INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('LateFeeType', 'Percentage');

CREATE TABLE IF NOT EXISTS `tblnotes` (
`id` INT( 1 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`userid` INT( 10 ) UNSIGNED ZEROFILL NOT NULL ,
`adminid` INT( 1 ) NOT NULL ,
`created` DATETIME NOT NULL ,
`modified` DATETIME NOT NULL ,
`note` TEXT COLLATE utf8_unicode_ci NOT NULL
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

ALTER TABLE `tblproductconfigoptionssub` ADD `setup` DECIMAL( 10, 2 ) NOT NULL AFTER `optionname` ;

ALTER TABLE `tblemailtemplates` ADD `copyto` TEXT NOT NULL ;
ALTER TABLE `tblemailtemplates` ADD `plaintext` INT( 1 ) NOT NULL ;

ALTER TABLE `tblinvoices` ADD `invoicenum` TEXT NOT NULL AFTER `id` ;

ALTER TABLE `tbldownloads` ADD `productdownload` TEXT NOT NULL ;
ALTER TABLE `tblproducts` ADD `downloads` TEXT NOT NULL AFTER `affiliatepayamount` ;

UPDATE tblconfiguration SET setting='SendFirstOverdueInvoiceReminder' WHERE setting='SendOverdueInvoiceReminders';
INSERT INTO `tblconfiguration` (`setting` ,`value` )VALUES ('SendSecondOverdueInvoiceReminder', '0');
INSERT INTO `tblconfiguration` (`setting` ,`value` )VALUES ('SendThirdOverdueInvoiceReminder', '0');

UPDATE tblemailtemplates SET name='First Invoice Overdue Notice' WHERE name='Invoice Overdue Notice';
UPDATE tblemailtemplates SET subject='First Invoice Overdue Notice' WHERE subject='Invoice Overdue Notice';

INSERT INTO `tblemailtemplates` (type,name,subject,message) VALUES ( 'invoice', 'Second Invoice Overdue Notice', 'Second Invoice Overdue Notice', ' Dear [CustomerName], This is the second billing notice that your invoice no. [InvoiceNo] which was generated on [InvoiceDate] is now overdue. Your payment method is: [PaymentMethod] Invoice: [InvoiceNo] Balance Due: [Balance] Due Date: [DueDate] You can login to your client area to view and pay the invoice at [InvoiceLink] Your login details are as follows: Email Address: [CustomerEmail] Password: [CAPassword] [Signature] ');
INSERT INTO `tblemailtemplates` (type,name,subject,message) VALUES ( 'invoice', 'Third Invoice Overdue Notice', 'Third Invoice Overdue Notice', ' Dear [CustomerName], 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. Your payment method is: [PaymentMethod] Invoice: [InvoiceNo] Balance Due: [Balance] Due Date: [DueDate] You can login to your client area to view and pay the invoice at [InvoiceLink] Your login details are as follows: Email Address: [CustomerEmail] Password: [CAPassword] [Signature] ');