UPDATE setting set value='1.096' where name='ClientExec Version';
ALTER TABLE `domains` ADD `shared` TINYINT DEFAULT '0' NOT NULL ;
ALTER TABLE `domains` ADD `nextbilldate` DATE;
ALTER TABLE `domains` ADD `paymentterm` TINYINT(4);
ALTER TABLE `recurringfee` ADD `nextbilldate` DATE;
ALTER TABLE `recurringfee` ADD `paymentterm` TINYINT(4);
UPDATE users set nextbilldate=dateActivated where nextbilldate < dateActivated and paymentterm=0;
INSERT INTO setting(name,value,description,type,isrequired,istruefalse) values ("All Current Users To Use Signup Script","1","Select Yes if you want ClientExec to allow current customers to sign up for new services by adding the ability for them to enter their current username and password.",10,1,1);
INSERT INTO setting(name,value,description,type,isrequired,istruefalse) values ("Show Open Support Tickets","1","Select Yes if you want ClientExec to show all open support tickets in dashboard.",11,1,1);
INSERT INTO setting(name,value,description,type,isrequired,istruefalse) values ("Show Customers Awaiting Approval","1","Select Yes if you want ClientExec to show all customers waiting approval in dashboard.",11,1,1);
INSERT INTO setting(name,value,description,type,isrequired,istruefalse) values ("Show Outstanding Invoices","1","Select Yes if you want ClientExec to show all outstanding invoices in dashboard.",11,1,1);
INSERT INTO setting(name,value,description,type,isrequired,istruefalse) values ("Show Credit Cards Needing Validation","0","Select Yes if you want ClientExec to show all customers with credit cards needing validation in dashboard.",11,1,1);
INSERT INTO setting(name,value,description,type,isrequired,istruefalse) values ("Highlight Selected Column","1","Select Yes if you want ClientExec to highlight the entire sorted column when clicking on a new header.",11,1,1);
