update_settings.sql

UPDATE civicrm_setting SET value = 's:2:"59";' WHERE name = 'activity_type'; 

UPDATE civicrm_setting SET value = 's:2:"60";' WHERE name = 'activity_type_letter'; 

UPDATE civicrm_setting SET value = 's:1:"Y";' WHERE name = 'auto_renew_membership'; 

UPDATE civicrm_setting SET value = 's:6:"1,8,22";' WHERE name = 'collection_days'; 

UPDATE civicrm_setting SET value = 's:2:"15";' WHERE name = 'collection_interval'; 

UPDATE civicrm_setting SET value = 's:14:"Address Line 1";' WHERE name = 'company_address1'; 

UPDATE civicrm_setting SET value = 's:14:"Address Line 2";' WHERE name = 'company_address2'; 

UPDATE civicrm_setting SET value = 's:14:"Address Line 3";' WHERE name = 'company_address3'; 

UPDATE civicrm_setting SET value = 's:14:"Address Line 4";' WHERE name = 'company_address4'; 

UPDATE civicrm_setting SET value = 's:14:"Address County";' WHERE name = 'company_county'; 

UPDATE civicrm_setting SET value = 's:17:"Veda Test Company";' WHERE name = 'company_name'; 

UPDATE civicrm_setting SET value = 's:16:"Address Postcode";' WHERE name = 'company_postcode'; 

UPDATE civicrm_setting SET value = 's:12:"Address Town";' WHERE name = 'company_town'; 

UPDATE civicrm_setting SET value = 's:20:"vedaconsulting.co.uk";' WHERE name = 'domain_name'; 

UPDATE civicrm_setting SET value = 's:32:"fred.bloggs@vedaconsulting.co.uk";' WHERE name = 'email_address'; 

UPDATE civicrm_setting SET value = 's:1:"8";' WHERE name = 'payment_instrument_id'; 

UPDATE civicrm_setting SET value = 's:6:"123456";' WHERE name = 'service_user_number'; 

UPDATE civicrm_setting SET value = 's:13:"0171 567 4545";' WHERE name = 'telephone_number'; 

UPDATE civicrm_setting SET value = 's:3:"WEB";' WHERE name = 'transaction_prefix';