UPDATE `help_tips_settings` SET `content`='The Monthly Discount Percentage is pre-set according to your RSA agreement with Credebt Exchange' WHERE `help_tip_id`=766 LIMIT 1;
UPDATE `help_tips_settings` SET `content`='Enter a higher Monthly Discount Percentage than your current RSA agreement with Credebt Exchange for faster trading' WHERE `help_tip_id`=768 LIMIT 1;
UPDATE `help_tips_settings` SET `content`='Check this box if you want the Credebt Exchange Collections Team to ensure payment of the invoice in the shortest possible time' WHERE `help_tip_id`=770 LIMIT 1;

UPDATE `mail_management` SET `mail_from_name`='Credebt Exchange Limited' WHERE `mail_id`=36 LIMIT 1;

UPDATE mail_management SET 
    mail_content=REPLACE(mail_content,"®",""),
    mail_content_text=REPLACE(mail_content_text,"®",""),
    mail_content=REPLACE(mail_content,"®",""),
    mail_content_text=REPLACE(mail_content_text,"®","");
    

UPDATE `bank_account` SET `bank_account_name`='Credebt Exchange' WHERE `account_id`=4 LIMIT 1;
UPDATE `bank_account` SET `bank_account_name`='Credebt Exchange' WHERE `account_id`=11 LIMIT 1;
UPDATE `bank_account` SET `bank_account_name`='Credebt Exchange' WHERE `account_id`=18 LIMIT 1;
UPDATE `contact_details` SET `first_name`='Credebt Exchange' WHERE `contact_id`=474 LIMIT 1;

UPDATE `manual_transactions_rejected` SET `delete_notes`='Invoice from Credebt Exchange entered incorrectly. No action required on your part. As this message is a \'Notice Only\' you may delete this once you have read it.We have since received notification that this payment is split between Meteor and Eircom' WHERE `trans_reject_id`=760 LIMIT 1;
UPDATE `manual_transactions_rejected` SET `delete_notes`='Notice Only (delete once read):- Invoice from Credebt Exchange entered incorrectly. No action required on your part. As this message is a \'Notice Only\' you may delete this once you have read it.' WHERE `trans_reject_id`=237 LIMIT 1;
UPDATE `manual_transactions_rejected` SET `delete_notes`='Notice Only (delete once read):- Invoice from Credebt Exchange from 2013-10-07 incorrectly charged leaving a balance of EUR 242.31 outstanding. This balance of charged EUR 242.31 will be charged this month. No action required on your part. As this message is a \'Notice Only\' you may delete this once you have read it.' WHERE `trans_reject_id`=184 LIMIT 1;
UPDATE `manual_transactions_rejected` SET `delete_notes`='Notice Only (delete once read):- Invoice from Credebt Exchange from 2014-02-18 not charged until this month. No action required on your part. As this message is a \'Notice Only\' you may delete this once you have read it.' WHERE `trans_reject_id`=183 LIMIT 1;

UPDATE `site_settings` SET `cheatsheet`='Hi there,\n\nI am ringing to get notice of assignment and want to make sure you ahve the invoice, that it is payable and that you realise you must pay Credebt Exchange. Can you confirm this for me please. hi' WHERE `site_setting_id`=1 LIMIT 1;
UPDATE `temp_registration` SET `first_name`='Credebt Exchange' WHERE `temp_reg_id`=214 LIMIT 1;
UPDATE `temp_registration` SET `organization_name`='Credebt Exchange' WHERE `temp_reg_id`=2 LIMIT 1;

UPDATE terms_table SET 
    inv_reg=REPLACE(inv_reg,"®",""),
    inv_reg=REPLACE(inv_reg,"®",""),

    tr_reg=REPLACE(tr_reg,"®",""),
    tr_reg=REPLACE(tr_reg,"®",""),

    inter_reg=REPLACE(inter_reg,"®",""),
    inter_reg=REPLACE(inter_reg,"®",""),

    ret_reg=REPLACE(ret_reg,"®",""),
    ret_reg=REPLACE(ret_reg,"®",""),

    inv_app_form=REPLACE(inv_app_form,"®",""),
    inv_app_form=REPLACE(inv_app_form,"®",""),

    tr_app_form=REPLACE(tr_app_form,"®",""),
    tr_app_form=REPLACE(tr_app_form,"®",""),

    ret_inv_contract=REPLACE(ret_inv_contract,"®",""),
    ret_inv_contract=REPLACE(ret_inv_contract,"®",""),

    etr_loan_terms=REPLACE(etr_loan_terms,"®",""),
    etr_loan_terms=REPLACE(etr_loan_terms,"®","");