# --------------------------------------------------------
# VERSION UPDATING
# --------------------------------------------------------
UPDATE `setting` set value='2.7.0 RC1' WHERE name='ClientExec Version';

# --------------------------------------------------------
# TO REMEMBER SELECTED DASHBOARD TAB
# --------------------------------------------------------
INSERT INTO `customuserfields` VALUES (NULL, 'selectedDashboardTab', 0, 0, 1, 1, 20, 0, 0, 0, 0, 0, '');

# ---------------------------------------------------------
# UPDATE TO REBILLER EMAIL TEMPLATE
#----------------------------------------------------------
UPDATE `setting` SET `value`='Due Date: [DATE]\nInvoice # [INVOICENUMBER]\n\nATTN: [CLIENTNAME],\n\nYou currently have an overdue invoice of [AMOUNT] due on your account with [COMPANYNAME].\n\nInvoice Description:\n[INVOICEDESCRIPTION]\nTotal Due: [AMOUNT]\n\nPayment Instructions:\n1) Log into our client management site at [CLIENTAPPLICATIONURL] with your username and password\n2) Click on the "Billing" tab\n3) Select the invoice you want to pay\n4) Click on pay invoice\n\nWe greatly appreciate your efforts to ensure that payment is received in a timely matter.\n\nIf you have any questions regarding your account or if you wish to pay by check, please feel free to contact us.\n\nNote: This email will serve as an official invoice for this payment.\n\n[COMPANYNAME]\n[BILLINGEMAIL]' WHERE `value`='Due Date: [DATE]\nInvoice # [INVOICENUMBER]\n\nATTN: [CLIENTNAME],\n\nYou currently have an overdue balance of [AMOUNT] due on your account with [COMPANYNAME].\n\nInvoice Description:\n[INVOICEDESCRIPTION]\nTotal Due: [AMOUNT]\n\nPayment Instructions:\n1) Log into our client management site at [CLIENTAPPLICATIONURL] with your username and password\n2) Click on the "Billing" tab\n3) Select the invoice you want to pay\n4) Click on pay invoice\n\nWe greatly appreciate your efforts to ensure that payment is received in a timely matter.\n\nIf you have any questions regarding your account or if you wish to pay by check, please feel free to contact us.\n\nNote: This email will serve as an official invoice for this payment.\n\n[COMPANYNAME]\n[BILLINGEMAIL]';
