-INSERT INTO civicrm_setting
- ( domain_id, contact_id, is_domain, group_name, name, value )
-VALUES
- ( @domainID, NULL, 1, 'CiviCRM Preferences', 'contact_view_options', 's:28:"\ 11\ 12\ 13\ 14\ 15\ 16\ 17\ 18\ 19\ 110\ 111\ 113\ 1";' ),
- ( @domainID, NULL, 1, 'CiviCRM Preferences', 'contact_edit_options', 's:22:"\ 11\ 12\ 13\ 14\ 15\ 16\ 17\ 18\ 19\ 111\ 1";' ),
- ( @domainID, NULL, 1, 'CiviCRM Preferences', 'advanced_search_options', 's:46:"\ 11\ 12\ 13\ 14\ 15\ 16\ 17\ 18\ 19\ 110\ 111\ 112\ 113\ 115\ 116\ 117\ 118\ 119\ 1";' ),
- ( @domainID, NULL, 1, 'CiviCRM Preferences', 'user_dashboard_options', 's:15:"\ 11\ 12\ 13\ 14\ 15\ 17\ 18\ 1";' ),
- ( @domainID, NULL, 1, 'CiviCRM Preferences', 'address_options', 's:23:"\ 11\ 12\ 13\ 14\ 15\ 16\ 18\ 19\ 110\ 111\ 1";' ),
- ( @domainID, NULL, 1, 'CiviCRM Preferences', 'address_format', 's:198:"{contact.address_name}
-{contact.street_address}
-{contact.supplemental_address_1}
-{contact.supplemental_address_2}
-{contact.city}{, }{contact.state_province}{ }{contact.postal_code}
-{contact.country}";' ),
- ( @domainID, NULL, 1, 'CiviCRM Preferences', 'mailing_format', 's:195:"{contact.addressee}
-{contact.street_address}
-{contact.supplemental_address_1}
-{contact.supplemental_address_2}
-{contact.city}{, }{contact.state_province}{ }{contact.postal_code}
-{contact.country}";' ),
- ( @domainID, NULL, 1, 'CiviCRM Preferences', 'display_name_format', 's:102:"{contact.individual_prefix}{ }{contact.first_name}{ }{contact.last_name}{ }{contact.individual_suffix}";' ),
- ( @domainID, NULL, 1, 'CiviCRM Preferences', 'sort_name_format', 's:43:"{contact.last_name}{, }{contact.first_name}";' ),
- ( @domainID, NULL, 1, 'CiviCRM Preferences', 'editor_id', 's:1:"2";' ),
- ( @domainID, NULL, 1, 'CiviCRM Preferences', 'contact_ajax_check_similar', 's:1:"1";' ),
- ( @domainID, NULL, 1, 'CiviCRM Preferences', 'activity_assignee_notification', 's:1:"1";' ),
- ( @domainID, NULL, 1, 'CiviCRM Preferences', 'contact_autocomplete_options', 's:5:"\ 11\ 12\ 1";' ),
- ( @domainID, NULL, 1, 'CiviCRM Preferences', 'contact_reference_options', 's:5:"\ 11\ 12\ 1";' ),
- ( @domainID, NULL, 1, 'Address Standardization Preferences', 'address_standardization_provider', NULL ),
- ( @domainID, NULL, 1, 'Address Standardization Preferences', 'address_standardization_userid', NULL ),
- ( @domainID, NULL, 1, 'Address Standardization Preferences', 'address_standardization_url', NULL ),
- ( @domainID, NULL, 1, 'Campaign Preferences', 'tag_unconfirmed', 's:11:"Unconfirmed";' ),
- ( @domainID, NULL, 1, 'Campaign Preferences', 'petition_contacts', 's:17:"Petition Contacts";' ),
- ( @domainID, NULL, 1, 'Event Preferences' , 'enable_cart', 's:1:"0";' ),
- ( @domainID, NULL, 1, 'Mailing Preferences', 'profile_double_optin', 's:1:"1";' ),
- ( @domainID, NULL, 1, 'Mailing Preferences', 'profile_add_to_group_double_optin', 's:1:"0";' ),
- ( @domainID, NULL, 1, 'Mailing Preferences', 'track_civimail_replies', 's:1:"0";' ),
- ( @domainID, NULL, 1, 'Mailing Preferences', 'civimail_workflow', 's:1:"0";' ),
- ( @domainID, NULL, 1, 'Mailing Preferences', 'civimail_server_wide_lock', 's:1:"0";' ),
- ( @domainID, NULL, 1, 'Mailing Preferences', 'mailing_backend', 'a:1:{s:15:"outBound_option";s:1:"3";}' ),
- ( @domainID, NULL, 1, 'Member Preferences' , 'default_renewal_contribution_page', NULL ),
- ( @domainID, NULL, 1, 'Multi Site Preferences', 'is_enabled', 's:1:"0";' ),
- ( @domainID, NULL, 1, 'Multi Site Preferences', 'uniq_email_per_site', 's:1:"0";' ),
- ( @domainID, NULL, 1, 'Multi Site Preferences', 'domain_group_id', 's:1:"0";' ),
- ( @domainID, NULL, 1, 'Multi Site Preferences', 'event_price_set_domain_id', 's:1:"0";' ),
- ( @domainID, NULL, 1, 'Directory Preferences', 'uploadDir' , NULL ),
- ( @domainID, NULL, 1, 'Directory Preferences', 'imageUploadDir' , NULL ),
- ( @domainID, NULL, 1, 'Directory Preferences', 'customFileUploadDir', NULL ),
- ( @domainID, NULL, 1, 'Directory Preferences', 'customTemplateDir' , NULL ),
- ( @domainID, NULL, 1, 'Directory Preferences', 'customPHPPathDir' , NULL ),
- ( @domainID, NULL, 1, 'Directory Preferences', 'extensionsDir' , NULL ),
- ( @domainID, NULL, 1, 'URL Preferences', 'userFrameworkResourceURL' , NULL ),
- ( @domainID, NULL, 1, 'URL Preferences', 'imageUploadURL' , NULL ),
- ( @domainID, NULL, 1, 'URL Preferences', 'customCSSURL' , NULL ),
- ( @domainID, NULL, 1, 'URL Preferences', 'extensionsURL' , NULL );