UPDATE #application.settings.tableprefix#settings SET settingValue = WHERE setting = 'app_title' UPDATE #application.settings.tableprefix#settings SET settingValue = WHERE setting = 'default_style' UPDATE #application.settings.tableprefix#settings SET settingValue = WHERE setting = 'default_locale' UPDATE #application.settings.tableprefix#settings SET settingValue = WHERE setting = 'default_timezone' UPDATE #application.settings.tableprefix#settings SET settingValue = WHERE setting = 'company_name' UPDATE #application.settings.tableprefix#settings SET settingValue = WHERE setting = 'email_subject_prefix' UPDATE #application.settings.tableprefix#settings SET settingValue = WHERE setting = 'sms_subject_prefix' UPDATE #application.settings.tableprefix#settings SET settingValue = WHERE setting = 'enable_api' UPDATE #application.settings.tableprefix#settings SET settingValue = WHERE setting = 'api_key' UPDATE #application.settings.tableprefix#settings SET settingValue = WHERE setting = 'api_key' UPDATE #application.settings.tableprefix#settings SET settingValue = WHERE setting = 'googlecal_enable' UPDATE #application.settings.tableprefix#settings SET settingValue = WHERE setting = 'googlecal_user' UPDATE #application.settings.tableprefix#settings SET settingValue = WHERE setting = 'googlecal_pass' UPDATE #application.settings.tableprefix#settings SET settingValue = WHERE setting = 'googlecal_timezone' UPDATE #application.settings.tableprefix#settings SET settingValue = WHERE setting = 'googlecal_offset' UPDATE #application.settings.tableprefix#settings SET settingValue = WHERE setting = 'company_logo' UPDATE #application.settings.tableprefix#settings SET settingValue = '' WHERE setting = 'company_logo' UPDATE #application.settings.tableprefix#settings SET settingValue = WHERE setting = 'invoice_logo' UPDATE #application.settings.tableprefix#settings SET settingValue = '' WHERE setting = 'invoice_logo'