UPDATE setting set value='1.098' where name='ClientExec Version';
ALTER TABLE `customuserfields` ADD `inSettings` SMALLINT DEFAULT '1' NOT NULL ;
ALTER TABLE `users` DROP `paymentterm`;
ALTER TABLE `users` DROP `nextbilldate`;
INSERT INTO customuserfields(name,type,isrequired,isChangable,isAdminOnly,width,myOrder,showcustomer,showadmin,InSignup,inSettings) VALUES ('TABLESORT_OutstandingInvoices', 0, 0, 0, 0, 20, 0, 0, 0, 0,0);
INSERT INTO customuserfields(name,type,isrequired,isChangable,isAdminOnly,width,myOrder,showcustomer,showadmin,InSignup,inSettings) VALUES ('TABLESORT_NeedingValidation', 0, 0, 0, 0, 20, 0, 0, 0, 0,0);
INSERT INTO customuserfields(name,type,isrequired,isChangable,isAdminOnly,width,myOrder,showcustomer,showadmin,InSignup,inSettings) VALUES ('TABLESORT_OpenTickets', 0, 0, 0, 0, 20, 0, 0, 0, 0,0);
INSERT INTO customuserfields(name,type,isrequired,isChangable,isAdminOnly,width,myOrder,showcustomer,showadmin,InSignup,inSettings) VALUES ('TABLESORT_PendingCustomers', 0, 0, 0, 0, 20, 0, 0, 0, 0,0);
INSERT INTO customuserfields(name,type,isrequired,isChangable,isAdminOnly,width,myOrder,showcustomer,showadmin,InSignup,inSettings) VALUES ('TABLESORT_UninvoicedWork', 0, 0, 0, 0, 20, 0, 0, 0, 0,0);
INSERT INTO setting(name,value,description,type,isrequired,istruefalse) VALUES ("Show Uninvoiced Work","1","Select Yes if you want ClientExec to show all uninvoiced work in dashboard.",11,1,1);
