Просмотр архива Отличный Хостинг

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_general_ci NOT
NULL
) DEFAULT CHARSET=utf8 COLLATE=utf8_general_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', '<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>');
INSERT 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>');

UPDATE
`tblconfiguration` SET `value` = '3.3.0' WHERE `setting`= 'Version';