sql/test_data_second_domain.mysql

   1   SET @domainName := 'Second Domain';
   2   INSERT INTO civicrm_contact(sort_name, display_name, contact_type, organization_name)
   3   VALUES (@domainName, @domainName, 'Organization', @domainName);
   4   SET @contactID:=LAST_INSERT_ID();
   5   INSERT INTO civicrm_address ( contact_id, location_type_id, is_primary, is_billing, street_address, street_number, street_number_suffix, street_number_predirectional, street_name, street_type, street_number_postdirectional, street_unit, supplemental_address_1, supplemental_address_2, supplemental_address_3, city, county_id, state_province_id, postal_code_suffix, postal_code, usps_adc, country_id, geo_code_1, geo_code_2, timezone)
   6       VALUES
   7       ( @contactID, 1, 1, 1, '15 Main St', 15, 'S', NULL, 'Main', 'St', NULL, NULL, NULL, NULL, NULL, 'Collinsville', NULL, 1006, NULL, '6022', NULL, 1228, 41.8328, -72.9253, NULL);
   8
   9 SELECT @addId := id from civicrm_address where street_address = '15 Main St';
  10
  11 INSERT INTO civicrm_email (contact_id, location_type_id, email, is_primary, is_billing, on_hold, hold_date, reset_date)
  12       VALUES
  13       (@contactID, 1, 'domainemail2@example.org', 1, 0, 0, NULL, NULL);
  14
  15 SELECT @emailId := id from civicrm_email where email = 'domainemail2@example.org';
  16
  17 INSERT INTO civicrm_phone (contact_id, location_type_id, is_primary, is_billing, mobile_provider_id, phone, phone_type_id)
  18       VALUES
  19       (@contactID, 1, 1, 0, NULL,'204 555-1001', 1);
  20
  21 SELECT @phoneId := id from civicrm_phone where phone = '204 555-1001';
  22
  23 INSERT INTO civicrm_loc_block ( address_id, email_id, phone_id, address_2_id, email_2_id, phone_2_id)
  24       VALUES
  25       ( @addId, @emailId, @phoneId, NULL,NULL,NULL);
  26
  27 SELECT @locBlockId := id from civicrm_loc_block where phone_id = @phoneId AND email_id = @emailId AND address_id = @addId;
  28
  29   INSERT INTO civicrm_domain
  30   (name, version,contact_id) VALUES (@domainName, '4.2', @contactID);
  31   SELECT @domainID := id FROM civicrm_domain where name = 'Second Domain';
  32   INSERT INTO
  33    `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`, `component_id`, `domain_id`, `visibility_id`)
  34 VALUES
  35 -- from email address.
  36   (@option_group_id_fma, '"FIXME" <info@EXAMPLE.ORG>', '1', '"FIXME" <info@EXAMPLE.ORG>', NULL, 0, 1, 1, 'Default domain email address and from name.', 0, 0, 1, NULL, @domainID, NULL ),
  37
  38 -- Mail Approval Status Preferences
  39   (@option_group_id_mail_approval_status, 'Approved' , 1, 'Approved', NULL, 0, 1, 1, NULL, 0, 1, 1, @mailCompId, @domainID, NULL),
  40   (@option_group_id_mail_approval_status, 'Rejected' , 2, 'Rejected', NULL, 0, 0, 2, NULL, 0, 1, 1, @mailCompId, @domainID, NULL),
  41   (@option_group_id_mail_approval_status, 'None' , 3, 'None', NULL, 0, 0, 3, NULL, 0, 1, 1, @mailCompId, @domainID, NULL);
  42   INSERT INTO `civicrm_job`
  43     ( domain_id, run_frequency, last_run, name, description, api_entity, api_action, parameters, is_active )
  44 VALUES
  45     ( @domainID, 'Always' , NULL, 'Send Scheduled Mailings',      'Sends out scheduled CiviMail mailings',                                                       'job', 'process_mailing',         NULL, 0),
  46     ( @domainID, 'Hourly' , NULL, 'Fetch Bounces',                'Fetches bounces from mailings and writes them to mailing statistics',                         'job', 'fetch_bounces',           NULL, 0),
  47     ( @domainID, 'Hourly' , NULL, 'Process Inbound Emails',       'Inserts activity for a contact or a case by retrieving inbound emails from a mail directory',  'job', 'fetch_activities',        NULL, 0),
  48     ( @domainID, 'Daily' ,  NULL, 'Process Pledges',              'Updates pledge records and sends out reminders',                                              'job', 'process_pledge','send_reminders=[1 or 0] optional- 1 to send payment reminders', 0),
  49     ( @domainID, 'Daily' ,  NULL, 'Geocode and Parse Addresses',  'Retrieves geocodes (lat and long) and / or parses street addresses (populates street number, street name, etc.)', 'job', 'geocode', 'geocoding=[1 or 0] required\nparse=[1 or 0] required\nstart=[contact ID] optional-begin with this contact ID\nend=[contact ID] optional-process contacts with IDs less than this\nthrottle=[1 or 0] optional-1 adds five second sleep', 0),
  50     ( @domainID, 'Daily' ,  NULL, 'Update Greetings and Addressees','Goes through contact records and updates email and postal greetings, or addressee value',   'job', 'update_greeting','ct=[Individual or Household or Organization] required\ngt=[email_greeting or postal_greeting or addressee] required\nforce=[0 or 1] optional-0 update contacts with null value, 1 update all', 0),
  51     ( @domainID, 'Daily' ,  NULL, 'Mail Reports', 'Generates and sends out reports via email', 'job', 'mail_report','instanceId=[ID of report instance] required\nformat=[csv or print] optional-output CSV or print-friendly HTML, else PDF', 0),
  52     ( @domainID, 'Hourly' ,  NULL, 'Send Scheduled Reminders',     'Sends out scheduled reminders via email',                                                     'job', 'send_reminder',           NULL, 0),
  53     ( @domainID, 'Always' , NULL, 'Update Participant Statuses',  'Updates pending event participant statuses based on time',                                    'job', 'process_participant',     NULL, 0),
  54     ( @domainID, 'Daily' , NULL, 'Update Membership Statuses', 'Updates membership statuses. WARNING: Membership renewal reminders have been migrated to the Schedule Reminders functionality, which supports multiple renewal reminders.', 'job', 'process_membership',   NULL, 0),
  55     ( @domainID, 'Always' , NULL, 'Process Survey Respondents',   'Releases reserved survey respondents when they have been reserved for longer than the Release Frequency days specified for that survey.', 'job', 'process_respondent',NULL, 0),
  56     ( @domainID, 'Hourly' , NULL, 'Clean-up Temporary Data and Files','Removes temporary data and files, and clears old data from cache tables. Recommend running this job every hour to help prevent database and file system bloat.', 'job', 'cleanup', NULL, 0);
  57   -- Initial default state of system settings
  58
  59   INSERT INTO `civicrm_dashboard`
  60     ( `domain_id`, `label`, `url`, `permission`, `permission_operator`,  `is_active`, `fullscreen_url`, `is_reserved`)
  61     VALUES
  62     ( @domainID, 'Activities', 'civicrm/dashlet/activity&reset=1&snippet=5', 'access CiviCRM', NULL, 1, 'civicrm/dashlet/activity&reset=1&snippet=5&context=dashletFullscreen', 1),
  63     ( @domainID, 'My Cases', 'civicrm/dashlet/myCases&reset=1&snippet=5', 'access my cases and activities', NULL, 1, 'civicrm/dashlet/myCases&reset=1&snippet=5&context=dashletFullscreen', 1),
  64     ( @domainID, 'All Cases', 'civicrm/dashlet/allCases&reset=1&snippet=5', 'access all cases and activities', NULL, 1, 'civicrm/dashlet/allCases&reset=1&snippet=5&context=dashletFullscreen', 1),
  65     ( @domainID, 'Case Dashboard Dashlet', 'civicrm/dashlet/casedashboard&reset=1&snippet=5', 'access my cases and activities,access all cases and activities', 'OR', 1, 'civicrm/dashlet/casedashboard&reset=1&snippet=5&context=dashletFullscreen', 1);
  66
  67 -- navigation
  68
  69 INSERT INTO civicrm_navigation
  70  ( domain_id, label, name, url, permission, permission_operator, parent_id, is_active, has_separator, weight )
  71 VALUES
  72  ( @domainID, 'Home', 'Home', 'civicrm/dashboard&reset=1', NULL, '', NULL, 1, NULL, 0);
  73
  74 INSERT INTO civicrm_navigation
  75     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
  76 VALUES
  77     (  @domainID, NULL, 'Search',  'Search...',    NULL, '',  NULL, '1', NULL, 10 );
  78
  79 SET @searchlastID:=LAST_INSERT_ID();
  80
  81 INSERT INTO civicrm_navigation
  82     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
  83 VALUES
  84     ( @domainID, 'civicrm/contact/search&reset=1',                          'Find Contacts',      'Find Contacts', NULL, '',                      @searchlastID, '1', NULL, 1 ),
  85     ( @domainID, 'civicrm/contact/search/advanced&reset=1',                 'Advanced Search',    'Advanced Search', NULL, '', @searchlastID, '1', NULL, 2 ),
  86     ( @domainID, 'civicrm/contact/search/custom&csid=15&reset=1',           'Full-text Search',   'Full-text Search', NULL, '',                   @searchlastID, '1', NULL, 3 ),
  87     ( @domainID, 'civicrm/contact/search/builder&reset=1',                  'Search Builder',     'Search Builder', NULL, '',                     @searchlastID, '1', '1',  4 ),
  88     ( @domainID, 'civicrm/case/search&reset=1',                             'Find Cases',         'Find Cases', 'access my cases and activities,access all cases and activities', 'OR',            @searchlastID, '1', NULL, 5 ),
  89     ( @domainID, 'civicrm/contribute/search&reset=1',                       'Find Contributions', 'Find Contributions', 'access CiviContribute', '',  @searchlastID, '1', NULL, 6 ),
  90     ( @domainID, 'civicrm/mailing&reset=1',                                 'Find Mailings',      'Find Mailings', 'access CiviMail', '',         @searchlastID, '1', NULL, 7 ),
  91     ( @domainID, 'civicrm/member/search&reset=1',                           'Find Memberships',   'Find Memberships', 'access CiviMember', '',        @searchlastID, '1', NULL, 8 ),
  92     ( @domainID, 'civicrm/event/search&reset=1',                            'Find Participants',  'Find Participants',  'access CiviEvent', '',   @searchlastID, '1', NULL, 9 ),
  93     ( @domainID, 'civicrm/pledge/search&reset=1',                           'Find Pledges',       'Find Pledges', 'access CiviPledge', '',        @searchlastID, '1', NULL, 10 ),
  94     ( @domainID, 'civicrm/activity/search&reset=1',                         'Find Activities',    'Find Activities', NULL,  '',                   @searchlastID, '1', '1',  11 );
  95
  96 INSERT INTO civicrm_navigation
  97     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
  98 VALUES
  99     ( @domainID, 'civicrm/contact/search/custom/list&reset=1',              'Custom Searches', 'Custom Searches', NULL, '',                 @searchlastID, '1', NULL, 12 );
 100
 101 INSERT INTO civicrm_navigation
 102     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 103 VALUES
 104     ( @domainID, NULL,  'Contacts', 'Contacts', NULL, '', NULL, '1', NULL, 20 );
 105
 106 SET @contactlastID:=LAST_INSERT_ID();
 107 INSERT INTO civicrm_navigation
 108     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 109 VALUES
 110     ( @domainID, 'civicrm/contact/add&reset=1&ct=Individual',       'New Individual',         'New Individual',       'add contacts',     '',             @contactlastID, '1', NULL,  1 ),
 111     ( @domainID, 'civicrm/contact/add&reset=1&ct=Household',        'New Household',          'New Household',        'add contacts',     '',             @contactlastID, '1', NULL,  2 ),
 112        ( @domainID, 'civicrm/contact/add&reset=1&ct=Organization',  'New Organization',       'New Organization',     'add contacts',     '',             @contactlastID, '1', 1,     3 );
 113
 114
 115 INSERT INTO civicrm_navigation
 116     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 117 VALUES
 118     ( @domainID, 'civicrm/activity&reset=1&action=add&context=standalone',  'New Activity',           'New Activity',         NULL,               '',             @contactlastID, '1', NULL,  4 ),
 119     ( @domainID, 'civicrm/activity/email/add&atype=3&action=add&reset=1&context=standalone', 'New Email',   'New Email',      NULL,               '',             @contactlastID, '1', '1',   5 ),
 120     ( @domainID, 'civicrm/import/contact&reset=1',                          'Import Contacts',        'Import Contacts',      'import contacts',  '',             @contactlastID, '1', NULL,  6 ),
 121     ( @domainID, 'civicrm/import/activity&reset=1',                         'Import Activities',      'Import Activities',    'import contacts',  '',             @contactlastID, '1', '1',   7 ),
 122     ( @domainID, 'civicrm/group/add&reset=1',                               'New Group',              'New Group',            'edit groups',      '',             @contactlastID, '1', NULL,  8 ),
 123     ( @domainID, 'civicrm/group&reset=1',                                   'Manage Groups',          'Manage Groups',        'access CiviCRM',   '',             @contactlastID, '1', '1',   9 ),
 124     ( @domainID, 'civicrm/admin/tag&reset=1&action=add',                    'New Tag',                'New Tag',              'administer CiviCRM', '',           @contactlastID, '1', NULL, 10 ),
 125     ( @domainID, 'civicrm/admin/tag&reset=1',                               'Manage Tags (Categories)', 'Manage Tags (Categories)', 'administer CiviCRM', '',     @contactlastID, '1','1', 11 ),
 126     ( @domainID, 'civicrm/contact/deduperules&reset=1',  'Find and Merge Duplicate Contacts', 'Find and Merge Duplicate Contacts', 'administer dedupe rules,merge duplicate contacts', 'OR', @contactlastID, '1', NULL, 12 );
 127
 128 INSERT INTO civicrm_navigation
 129     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 130 VALUES
 131     ( @domainID, NULL,  'Contributions', 'Contributions', 'access CiviContribute', '',      NULL,           '1', NULL,  30 );
 132
 133 SET @contributionlastID:=LAST_INSERT_ID();
 134 INSERT INTO civicrm_navigation
 135     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 136 VALUES
 137     ( @domainID, 'civicrm/contribute&reset=1',                              'Dashboard',              'Dashboard',              'access CiviContribute', '', @contributionlastID, '1', NULL, 1 ),
 138     ( @domainID, 'civicrm/contribute/add&reset=1&action=add&context=standalone', 'New Contribution',  'New Contribution',       'access CiviContribute,edit contributions', 'AND', @contributionlastID, '1', NULL, 2 ),
 139     ( @domainID, 'civicrm/contribute/search&reset=1',                       'Find Contributions',     'Find Contributions',     'access CiviContribute', '', @contributionlastID, '1', NULL, 3 ),
 140     ( @domainID, 'civicrm/batch&reset=1',                       'Batches',     'Batches',             'access CiviContribute,access CiviMember', '', @contributionlastID, '1', NULL, 4 ),
 141     ( @domainID, 'civicrm/contribute/import&reset=1',                       'Import Contributions',   'Import Contributions',   'access CiviContribute,edit contributions', 'AND', @contributionlastID, '1', '1',  5 );
 142
 143 INSERT INTO civicrm_navigation
 144     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 145 VALUES
 146     ( @domainID,NULL, 'Pledges',  'Pledges', 'access CiviPledge', '', @contributionlastID, '1',  1,   5 );
 147
 148 SET @pledgelastID:=LAST_INSERT_ID();
 149 INSERT INTO civicrm_navigation
 150     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 151 VALUES
 152     ( @domainID, 'civicrm/pledge&reset=1',                                  'Dashboard',                  'Dashboard',                 'access CiviPledge',  '',  @pledgelastID,       '1', NULL, 1 ),
 153     ( @domainID, 'civicrm/pledge/add&reset=1&action=add&context=standalone', 'New Pledge',                'New Pledge',                'access CiviPledge,edit pledges',  'AND',  @pledgelastID,       '1', NULL, 2 ),
 154     ( @domainID, 'civicrm/pledge/search&reset=1',                           'Find Pledges',               'Find Pledges',              'access CiviPledge',  '',  @pledgelastID,       '1', NULL, 3 ),
 155     ( @domainID, 'civicrm/admin/contribute/add&reset=1&action=add',         'New Contribution Page',      'New Contribution Page',     'access CiviContribute,administer CiviCRM', 'AND',  @contributionlastID, '1', NULL, 6 ),
 156     ( @domainID, 'civicrm/admin/contribute&reset=1',                        'Manage Contribution Pages',  'Manage Contribution Pages', 'access CiviContribute,administer CiviCRM', 'AND',  @contributionlastID, '1', '1',  7 ),
 157     ( @domainID, 'civicrm/admin/pcp?reset=1&page_type=contribute',          'Personal Campaign Pages',    'Personal Campaign Pages',   'access CiviContribute,administer CiviCRM', 'AND',  @contributionlastID, '1', NULL, 8 ),
 158     ( @domainID, 'civicrm/admin/contribute/managePremiums&reset=1',         'Premiums (Thank-you Gifts)', 'Premiums',                  'access CiviContribute,administer CiviCRM', 'AND',  @contributionlastID, '1', 1,    9 ),
 159     ( @domainID, 'civicrm/admin/price&reset=1&action=add',                  'New Price Set',              'New Price Set',             'access CiviContribute,administer CiviCRM', 'AND',  @contributionlastID, '1', NULL, 10 ),
 160     ( @domainID, 'civicrm/admin/price&reset=1',                             'Manage Price Sets',          'Manage Price Sets',         'access CiviContribute,administer CiviCRM', 'AND',  @contributionlastID, '1', NULL, 11 );
 161
 162 INSERT INTO civicrm_navigation
 163     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 164 VALUES
 165     ( @domainID, NULL, 'Events',  'Events', 'access CiviEvent', '', NULL, '1', NULL, 40 );
 166
 167 SET @eventlastID:=LAST_INSERT_ID();
 168 INSERT INTO civicrm_navigation
 169     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 170 VALUES
 171     ( @domainID, 'civicrm/event&reset=1',                                   'Dashboard',          'CiviEvent Dashboard',  'access CiviEvent', '',    @eventlastID, '1', NULL, 1 ),
 172     ( @domainID, 'civicrm/participant/add&reset=1&action=add&context=standalone', 'Register Event Participant', 'Register Event Participant', 'access CiviEvent,edit event participants', 'AND', @eventlastID, '1', NULL, 2 ),
 173     ( @domainID, 'civicrm/event/search&reset=1',                            'Find Participants',  'Find Participants',    'access CiviEvent', '',    @eventlastID, '1', NULL, 3 ),
 174     ( @domainID, 'civicrm/event/import&reset=1',                            'Import Participants','Import Participants',  'access CiviEvent,edit event participants', 'AND',    @eventlastID, '1', '1',  4 ),
 175     ( @domainID, 'civicrm/event/add&reset=1&action=add',                    'New Event',          'New Event',            'access CiviEvent,edit all events', 'AND',    @eventlastID, '1', NULL, 5 ),
 176     ( @domainID, 'civicrm/event/manage&reset=1',                            'Manage Events',      'Manage Events',        'access CiviEvent,edit all events', 'AND',    @eventlastID, '1', 1, 6 ),
 177     ( @domainID, 'civicrm/admin/pcp?reset=1&page_type=event',               'Personal Campaign Pages',    'Personal Campaign Pages',   'access CiviEvent,administer CiviCRM', 'AND', @eventlastID, '1', 1, 7 ),
 178     ( @domainID, 'civicrm/admin/eventTemplate&reset=1',                     'Event Templates',    'Event Templates',      'access CiviEvent,edit all events', 'AND',    @eventlastID, '1', 1, 8 ),
 179     ( @domainID, 'civicrm/admin/price&reset=1&action=add',                  'New Price Set',      'New Price Set',        'access CiviEvent,edit all events', 'AND',    @eventlastID, '1', NULL, 9 ),
 180     ( @domainID, 'civicrm/admin/price&reset=1',                             'Manage Price Sets',  'Manage Price Sets',    'access CiviEvent,edit all events', 'AND',    @eventlastID, '1', NULL, 10 );
 181
 182 INSERT INTO civicrm_navigation
 183     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 184 VALUES
 185     ( @domainID, NULL, 'Mailings', 'Mailings', 'access CiviMail,create mailings,approve mailings,schedule mailings', 'OR', NULL, '1', NULL, 50 );
 186
 187 SET @mailinglastID:=LAST_INSERT_ID();
 188 INSERT INTO civicrm_navigation
 189     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 190 VALUES
 191     ( @domainID, 'civicrm/mailing/send&reset=1',                            'New Mailing', 'New Mailing',                                          'access CiviMail,create mailings', 'OR', @mailinglastID, '1', NULL, 1 ),
 192     ( @domainID, 'civicrm/mailing/browse/unscheduled&reset=1&scheduled=false', 'Draft and Unscheduled Mailings', 'Draft and Unscheduled Mailings', 'access CiviMail,create mailings,schedule mailings', 'OR', @mailinglastID, '1', NULL, 2 ),
 193     ( @domainID, 'civicrm/mailing/browse/scheduled&reset=1&scheduled=true', 'Scheduled and Sent Mailings', 'Scheduled and Sent Mailings',          'access CiviMail,approve mailings,create mailings,schedule mailings', 'OR', @mailinglastID, '1', NULL, 3 ),
 194     ( @domainID, 'civicrm/mailing/browse/archived&reset=1',                 'Archived Mailings', 'Archived Mailings',                              'access CiviMail,create mailings', 'OR', @mailinglastID, '1', 1,    4 ),
 195     ( @domainID, 'civicrm/admin/component&reset=1',                         'Headers, Footers, and Automated Messages', 'Headers, Footers, and Automated Messages', 'access CiviMail,administer CiviCRM', 'AND', @mailinglastID, '1', NULL, 5 ),
 196     ( @domainID, 'civicrm/admin/messageTemplates&reset=1',                  'Message Templates', 'Message Templates',                 'administer CiviCRM', '', @mailinglastID, '1', NULL, 6 ),
 197     ( @domainID, 'civicrm/admin/options/from_email&group=from_email_address&reset=1', 'From Email Addresses', 'From Email Addresses', 'administer CiviCRM', '', @mailinglastID, '1', 1, 7 ),
 198     ( @domainID, 'civicrm/sms/send?reset=1', 'New SMS', 'New SMS', 'administer CiviCRM', NULL, @mailinglastID, '1', 1, 8 );
 199 INSERT INTO civicrm_navigation
 200     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 201 VALUES
 202     ( @domainID, NULL, 'Memberships', 'Memberships', 'access CiviMember', '', NULL, '1', NULL, 60 );
 203
 204 SET @memberlastID:=LAST_INSERT_ID();
 205 INSERT INTO civicrm_navigation
 206     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 207 VALUES
 208     ( @domainID, 'civicrm/member&reset=1',                              'Dashboard',           'Dashboard',       'access CiviMember', '', @memberlastID, '1', NULL, 1 ),
 209     ( @domainID, 'civicrm/member/add&reset=1&action=add&context=standalone', 'New Membership', 'New Membership',  'access CiviMember,edit memberships', 'AND', @memberlastID, '1', NULL, 2 ),
 210     ( @domainID, 'civicrm/member/search&reset=1',                       'Find Memberships',    'Find Memberships','access CiviMember', '', @memberlastID, '1', NULL, 3 ),
 211     ( @domainID, 'civicrm/batch&reset=1',                       'Batches',    'Batches','access CiviMember,access CiviContribute', '', @memberlastID, '1', NULL, 4 ),
 212     ( @domainID, 'civicrm/member/import&reset=1',                       'Import Memberships',  'Import Members',  'access CiviMember,edit memberships', 'AND', @memberlastID, '1', 1, 5 ),
 213     ( @domainID, 'civicrm/admin/price&reset=1&action=add',              'New Price Set',       'New Price Set',   'access CiviMember,administer CiviCRM', 'AND',  @memberlastID, '1', NULL, 6 ),
 214     ( @domainID, 'civicrm/admin/price&reset=1',                         'Manage Price Sets',   'Manage Price Sets', 'access CiviMember,administer CiviCRM', 'AND',  @memberlastID, '1', NULL, 7 );
 215
 216
 217 INSERT INTO civicrm_navigation
 218     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 219 VALUES
 220     ( @domainID, NULL, 'Campaigns', 'Campaigns', 'interview campaign contacts,release campaign contacts,reserve campaign contacts,manage campaign,administer CiviCampaign,gotv campaign contacts', 'OR', NULL, '1', NULL, 70 );
 221
 222 SET @campaignlastID:=LAST_INSERT_ID();
 223 INSERT INTO civicrm_navigation
 224     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 225 VALUES
 226     ( @domainID, 'civicrm/campaign&reset=1',        'Dashboard', 'Dashboard', 'manage campaign,administer CiviCampaign', 'OR', @campaignlastID, '1', NULL, 1 );
 227 SET @campaigndashboardlastID:=LAST_INSERT_ID();
 228 INSERT INTO civicrm_navigation
 229     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 230 VALUES
 231     ( @domainID, 'civicrm/campaign&reset=1&subPage=survey',        'Surveys', 'Survey Dashboard', 'manage campaign,administer CiviCampaign', 'OR', @campaigndashboardlastID, '1', NULL, 1 ),
 232     ( @domainID, 'civicrm/campaign&reset=1&subPage=petition',        'Petitions', 'Petition Dashboard', 'manage campaign,administer CiviCampaign', 'OR', @campaigndashboardlastID, '1', NULL, 2 ),
 233     ( @domainID, 'civicrm/campaign&reset=1&subPage=campaign',        'Campaigns', 'Campaign Dashboard', 'manage campaign,administer CiviCampaign', 'OR', @campaigndashboardlastID, '1', NULL, 3 ),
 234     ( @domainID, 'civicrm/campaign/add&reset=1',        'New Campaign', 'New Campaign', 'manage campaign,administer CiviCampaign', 'OR', @campaignlastID, '1', NULL, 2 ),
 235     ( @domainID, 'civicrm/survey/add&reset=1',        'New Survey', 'New Survey', 'manage campaign,administer CiviCampaign', 'OR', @campaignlastID, '1', NULL, 3 ),
 236     ( @domainID, 'civicrm/petition/add&reset=1',        'New Petition', 'New Petition', 'manage campaign,administer CiviCampaign', 'OR', @campaignlastID, '1', NULL, 4 ),
 237     ( @domainID, 'civicrm/survey/search&reset=1&op=reserve', 'Reserve Respondents', 'Reserve Respondents', 'administer CiviCampaign,manage campaign,reserve campaign contacts', 'OR', @campaignlastID, '1', NULL, 5 ),
 238     ( @domainID, 'civicrm/survey/search&reset=1&op=interview', 'Interview Respondents', 'Interview Respondents', 'administer CiviCampaign,manage campaign,interview campaign contacts', 'OR', @campaignlastID, '1', NULL, 6 ),
 239     ( @domainID, 'civicrm/survey/search&reset=1&op=release', 'Release Respondents', 'Release Respondents', 'administer CiviCampaign,manage campaign,release campaign contacts', 'OR', @campaignlastID, '1', NULL, 7 ),
 240     ( @domainID, 'civicrm/campaign/gotv&reset=1', 'GOTV (Voter Tracking)', 'Voter Listing', 'administer CiviCampaign,manage campaign,release campaign contacts,gotv campaign contacts', 'OR', @campaignlastID, '1', NULL, 8 ),
 241     ( @domainID, 'civicrm/campaign/vote&reset=1', 'Conduct Survey', 'Conduct Survey', 'administer CiviCampaign,manage campaign,reserve campaign contacts,interview campaign contacts', 'OR', @campaignlastID, '1', NULL, 9 );
 242
 243 INSERT INTO civicrm_navigation
 244     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 245 VALUES
 246     ( @domainID, NULL, 'Cases', 'Cases', 'access my cases and activities,access all cases and activities', 'OR', NULL, '1', NULL, 80 );
 247
 248 SET @caselastID:=LAST_INSERT_ID();
 249 INSERT INTO civicrm_navigation
 250     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 251 VALUES
 252     ( @domainID, 'civicrm/case&reset=1',        'Dashboard', 'Dashboard', 'access my cases and activities,access all cases and activities', 'OR',       @caselastID, '1', NULL, 1 ),
 253     ( @domainID, 'civicrm/case/add&reset=1&action=add&atype=13&context=standalone', 'New Case', 'New Case', 'add cases,access all cases and activities', 'OR', @caselastID, '1', NULL, 2 ),
 254     ( @domainID, 'civicrm/case/search&reset=1', 'Find Cases', 'Find Cases', 'access my cases and activities,access all cases and activities', 'OR',     @caselastID, '1', 1, 3 );
 255
 256 INSERT INTO civicrm_navigation
 257     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 258 VALUES
 259     ( @domainID, NULL, 'Administer', 'Administer', 'administer CiviCRM', '', NULL, '1', NULL, 100 );
 260
 261 SET @adminlastID:=LAST_INSERT_ID();
 262 INSERT INTO civicrm_navigation
 263     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 264 VALUES
 265     ( @domainID, 'civicrm/admin&reset=1', 'Administration Console', 'Administration Console', 'administer CiviCRM', '', @adminlastID, '1', NULL, 1 );
 266
 267 SET @adminConsolelastID:=LAST_INSERT_ID();
 268 INSERT INTO civicrm_navigation
 269     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 270 VALUES
 271     ( @domainID, 'civicrm/admin/configtask&reset=1', 'Configuration Checklist', 'Configuration Checklist', 'administer CiviCRM', '', @adminConsolelastID, '1', NULL, 1 );
 272
 273 INSERT INTO civicrm_navigation
 274     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 275 VALUES
 276     ( @domainID, NULL, 'Customize Data and Screens', 'Customize Data and Screens', 'administer CiviCRM', '', @adminlastID, '1', NULL, 3 );
 277
 278 SET @CustomizelastID:=LAST_INSERT_ID();
 279 INSERT INTO civicrm_navigation
 280     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 281 VALUES
 282     ( @domainID, 'civicrm/admin/custom/group&reset=1',      'Custom Fields', 'Custom Fields',                             'administer CiviCRM', '',   @CustomizelastID, '1', NULL, 1 ),
 283     ( @domainID, 'civicrm/admin/uf/group&reset=1',          'Profiles', 'Profiles',                                       'administer CiviCRM', '',   @CustomizelastID, '1', NULL, 2 ),
 284     ( @domainID, 'civicrm/admin/tag&reset=1',               'Tags (Categories)', 'Tags (Categories)',                     'administer CiviCRM', '',   @CustomizelastID, '1', NULL, 3 ),
 285     ( @domainID, 'civicrm/admin/options/activity_type&reset=1&group=activity_type', 'Activity Types', 'Activity Types',   'administer CiviCRM', '',   @CustomizelastID, '1', NULL, 4 ),
 286     ( @domainID, 'civicrm/admin/reltype&reset=1',           'Relationship Types', 'Relationship Types',                   'administer CiviCRM', '',   @CustomizelastID, '1', NULL, 5 ),
 287     ( @domainID, 'civicrm/admin/options/subtype&reset=1',   'Contact Types','Contact Types',                              'administer CiviCRM', '',   @CustomizelastID, '1', NULL, 6 ),
 288     ( @domainID, 'civicrm/admin/setting/preferences/display&reset=1',   'Display Preferences', 'Display Preferences',     'administer CiviCRM', '',   @CustomizelastID, '1', NULL, 9 ),
 289     ( @domainID, 'civicrm/admin/setting/search&reset=1',    'Search Preferences',    'Search Preferences',                'administer CiviCRM', '',   @CustomizelastID, '1', NULL, 10 ),
 290     ( @domainID, 'civicrm/admin/menu&reset=1',              'Navigation Menu', 'Navigation Menu',                         'administer CiviCRM', '',   @CustomizelastID, '1', NULL, 11 ),
 291     ( @domainID, 'civicrm/admin/options/wordreplacements&reset=1','Word Replacements','Word Replacements',                'administer CiviCRM', '',   @CustomizelastID, '1', NULL, 12 ),
 292     ( @domainID, 'civicrm/admin/options/custom_search&reset=1&group=custom_search', 'Manage Custom Searches', 'Manage Custom Searches', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 13 );
 293
 294 INSERT INTO civicrm_navigation
 295     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 296 VALUES
 297     ( @domainID, NULL, 'Dropdown Options', 'Dropdown Options', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 8 );
 298
 299 SET @optionListlastID:=LAST_INSERT_ID();
 300 INSERT INTO civicrm_navigation
 301     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 302 VALUES
 303     ( @domainID, 'civicrm/admin/options/gender&reset=1&group=gender',                                                  'Gender Options',         'Gender Options',                           'administer CiviCRM', '',   @optionListlastID, '1', NULL,  1 ),
 304     ( @domainID, 'civicrm/admin/options/individual_prefix&group=individual_prefix&reset=1',                            'Individual Prefixes (Ms, Mr...)', 'Individual Prefixes (Ms, Mr...)', 'administer CiviCRM', '',   @optionListlastID, '1', NULL,  2 ),
 305     ( @domainID, 'civicrm/admin/options/individual_suffix&group=individual_suffix&reset=1',                            'Individual Suffixes (Jr, Sr...)', 'Individual Suffixes (Jr, Sr...)', 'administer CiviCRM', '',   @optionListlastID, '1', NULL,  3 ),
 306     ( @domainID, 'civicrm/admin/options/instant_messenger_service&group=instant_messenger_service&reset=1',            'Instant Messenger Services',     'Instant Messenger Services',       'administer CiviCRM', '',   @optionListlastID, '1', NULL,  4 ),
 307     ( @domainID, 'civicrm/admin/locationType&reset=1',                                                                 'Location Types (Home, Work...)', 'Location Types (Home, Work...)',   'administer CiviCRM', '',   @optionListlastID, '1', NULL,  5 ),
 308     ( @domainID, 'civicrm/admin/options/mobile_provider&group=mobile_provider&reset=1',                                'Mobile Phone Providers', 'Mobile Phone Providers',                   'administer CiviCRM', '',   @optionListlastID, '1', NULL,  6 ),
 309     ( @domainID, 'civicrm/admin/options/phone_type&group=phone_type&reset=1',                                          'Phone Types',            'Phone Types',                              'administer CiviCRM', '',   @optionListlastID, '1', NULL,  7 ),
 310     ( @domainID, 'civicrm/admin/options/website_type&group=website_type&reset=1',                                      'Website Types',          'Website Types',                            'administer CiviCRM', '',   @optionListlastID, '1', NULL,  8 );
 311
 312 INSERT INTO civicrm_navigation
 313     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 314 VALUES
 315     ( @domainID, NULL, 'Communications', 'Communications', 'administer CiviCRM', '', @adminlastID, '1', NULL, 4 );
 316
 317 SET @communicationslastID:=LAST_INSERT_ID();
 318 INSERT INTO civicrm_navigation
 319     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 320 VALUES
 321     ( @domainID, 'civicrm/admin/domain&action=update&reset=1',         'Organization Address and Contact Info', 'Organization Address and Contact Info',                                      'administer CiviCRM', '', @communicationslastID, '1', NULL, 1 ),
 322     ( @domainID, 'civicrm/admin/options/from_email_address&group=from_email_address&reset=1', 'FROM Email Addresses', 'FROM Email Addresses',                                                 'administer CiviCRM', '', @communicationslastID, '1', NULL, 2 ),
 323     ( @domainID, 'civicrm/admin/messageTemplates&reset=1',             'Message Templates',      'Message Templates',                                                                         'administer CiviCRM', '', @communicationslastID, '1', NULL, 3 ),
 324     ( @domainID, 'civicrm/admin/scheduleReminders&reset=1',              'Schedule Reminders',    'Schedule Reminders',                                                                       'administer CiviCRM', '', @communicationslastID, '1', NULL, 4 ),
 325     ( @domainID, 'civicrm/admin/options/preferred_communication_method&group=preferred_communication_method&reset=1',  'Preferred Communication Methods', 'Preferred Communication Methods',  'administer CiviCRM', '', @communicationslastID, '1', NULL, 5 ),
 326     ( @domainID, 'civicrm/admin/labelFormats&reset=1',                                  'Label Formats',                 'Label Formats',                                                     'administer CiviCRM', '', @communicationslastID, '1', NULL, 6 ),
 327     ( @domainID, 'civicrm/admin/pdfFormats&reset=1',                                    'Print Page (PDF) Formats',      'Print Page (PDF) Formats',                                          'administer CiviCRM', '', @communicationslastID, '1', NULL, 7 ),
 328     ( @domainID, 'civicrm/admin/options/email_greeting&group=email_greeting&reset=1',   'Email Greeting Formats',        'Email Greeting Formats',                                            'administer CiviCRM', '', @communicationslastID, '1', NULL, 8 ),
 329     ( @domainID, 'civicrm/admin/options/postal_greeting&group=postal_greeting&reset=1', 'Postal Greeting Formats',       'Postal Greeting Formats',                                           'administer CiviCRM', '', @communicationslastID, '1', NULL, 9 ),
 330     ( @domainID, 'civicrm/admin/options/addressee&group=addressee&reset=1',             'Addressee Formats',             'Addressee Formats',                                                 'administer CiviCRM', '', @communicationslastID, '1', NULL, 10 );
 331
 332 INSERT INTO civicrm_navigation
 333     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 334 VALUES
 335     ( @domainID, NULL, 'Localization', 'Localization', 'administer CiviCRM', '', @adminlastID, '1', NULL, 6 );
 336
 337 SET @locallastID:=LAST_INSERT_ID();
 338 INSERT INTO civicrm_navigation
 339     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 340 VALUES
 341     ( @domainID, 'civicrm/admin/setting/localization&reset=1',          'Languages, Currency, Locations', 'Languages, Currency, Locations',   'administer CiviCRM', '', @locallastID, '1', NULL, 1 ),
 342     ( @domainID, 'civicrm/admin/setting/preferences/address&reset=1',   'Address Settings',               'Address Settings',                 'administer CiviCRM', '', @locallastID, '1', NULL, 2 ),
 343     ( @domainID, 'civicrm/admin/setting/date&reset=1',                  'Date Formats',                   'Date Formats',                     'administer CiviCRM', '', @locallastID, '1', NULL, 3 ),
 344     ( @domainID, 'civicrm/admin/options/languages&group=languages&reset=1', 'Preferred Language Options', 'Preferred Language Options',       'administer CiviCRM', '', @locallastID, '1', NULL, 4 );
 345
 346 INSERT INTO civicrm_navigation
 347     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 348 VALUES
 349     ( @domainID, NULL,                                                  'Users and Permissions',          'Users and Permissions',            'administer CiviCRM', '', @adminlastID, '1', NULL, 7 );
 350
 351 SET @usersPermslastID:=LAST_INSERT_ID();
 352 INSERT INTO civicrm_navigation
 353     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 354 VALUES
 355     ( @domainID, 'civicrm/admin/access&reset=1',       'Permissions (Access Control)',    'Permissions (Access Control)',     'administer CiviCRM', '', @usersPermslastID, '1', NULL, 1 ),
 356     ( @domainID, 'civicrm/admin/synchUser&reset=1',    'Synchronize Users to Contacts',   'Synchronize Users to Contacts',    'administer CiviCRM', '', @usersPermslastID, '1', NULL, 2 );
 357
 358 INSERT INTO civicrm_navigation
 359     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 360 VALUES
 361     ( @domainID, NULL,                                 'System Settings',                 'System Settings',                      'administer CiviCRM', '', @adminlastID, '1', NULL, 8 );
 362
 363 SET @systemSettingslastID:=LAST_INSERT_ID();
 364 INSERT INTO civicrm_navigation
 365     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 366 VALUES
 367     ( @domainID, 'civicrm/admin/setting/component&reset=1', 'Enable CiviCRM Components', 'Enable Components',                                 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 1 ),
 368     ( @domainID, 'civicrm/admin/extensions&reset=1',        'Manage Extensions', 'Manage Extensions', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 2 ),
 369     ( @domainID, 'civicrm/admin/setting/smtp&reset=1',                  'Outbound Email (SMTP/Sendmail)', 'Outbound Email',                   'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 3 ),
 370     ( @domainID, 'civicrm/admin/paymentProcessor&reset=1',              'Payment Processors', 'Payment Processors',                           'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 4 ),
 371     ( @domainID, 'civicrm/admin/setting/mapping&reset=1',               'Mapping and Geocoding', 'Mapping and Geocoding',                     'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 5 ),
 372     ( @domainID, 'civicrm/admin/setting/misc&reset=1',                  'Undelete, Logging and ReCAPTCHA', 'Undelete, Logging and ReCAPTCHA', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 6 ),
 373     ( @domainID, 'civicrm/admin/setting/path&reset=1',                  'Directories',        'Directories',                                  'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 7 ),
 374     ( @domainID, 'civicrm/admin/setting/url&reset=1',                   'Resource URLs',      'Resource URLs',                                'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 8 ),
 375     ( @domainID, 'civicrm/admin/setting/updateConfigBackend&reset=1',   'Cleanup Caches and Update Paths', 'Cleanup Caches and Update Paths', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 9 ),
 376     ( @domainID, 'civicrm/admin/setting/uf&reset=1',                    'CMS Database Integration',    'CMS Integration',                     'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 10 ),
 377     ( @domainID, 'civicrm/admin/options/safe_file_extension&group=safe_file_extension&reset=1', 'Safe File Extensions', 'Safe File Extensions','administer CiviCRM', '',@systemSettingslastID, '1', NULL, 11 ),
 378     ( @domainID, 'civicrm/admin/options?reset=1',                       'Option Groups', 'Option Groups',                                     'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 12 ),
 379     ( @domainID, 'civicrm/admin/mapping&reset=1',                       'Import/Export Mappings', 'Import/Export Mappings',                   'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 13 ),
 380     ( @domainID, 'civicrm/admin/setting/debug&reset=1',                 'Debugging and Error Handling','Debugging and Error Handling',        'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 14 ),
 381     ( @domainID, 'civicrm/admin/setting/preferences/multisite&reset=1', 'Multi Site Settings', 'Multi Site Settings',                         'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 15 ),
 382     ( @domainID, 'civicrm/admin/job&reset=1',                           'Scheduled Jobs', 'Scheduled Jobs',                                   'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 16 ),
 383     ( @domainID, 'civicrm/admin/sms/provider?reset=1', 'SMS Providers', 'SMS Providers',                                  'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 17 );
 384
 385
 386 -- begin component admin menus
 387 INSERT INTO civicrm_navigation
 388     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 389 VALUES
 390     ( @domainID, NULL,                                             'CiviCampaign',              'CiviCampaign',              'administer CiviCampaign,administer CiviCRM', 'AND', @adminlastID, '1', NULL, 9 );
 391
 392 SET @adminCampaignlastID:=LAST_INSERT_ID();
 393 INSERT INTO civicrm_navigation
 394     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 395 VALUES
 396     ( @domainID, 'civicrm/admin/campaign/surveyType&reset=1',                            'Survey Types',  'Survey Types', 'administer CiviCampaign',    '', @adminCampaignlastID, '1', NULL, 1 ),
 397     ( @domainID, 'civicrm/admin/options/campaign_type&group=campaign_type&reset=1',      'Campaign Types',  'Campaign Types', 'administer CiviCampaign',    '', @adminCampaignlastID, '1', NULL, 2 ),
 398     ( @domainID, 'civicrm/admin/options/campaign_status&group=campaign_status&reset=1',  'Campaign Status',  'Campaign Status', 'administer CiviCampaign',    '', @adminCampaignlastID, '1', NULL, 3 ),
 399     ( @domainID, 'civicrm/admin/options/engagement_index&group=engagement_index&reset=1', 'Engagement Index',  'Engagement Index', 'administer CiviCampaign', '', @adminCampaignlastID, '1', NULL, 4 ),
 400     ( @domainID, 'civicrm/admin/setting/preferences/campaign&reset=1',                   'CiviCampaign Component Settings', 'CiviCampaign Component Settings','administer CiviCampaign', '', @adminCampaignlastID, '1', NULL, 5 );
 401
 402 INSERT INTO civicrm_navigation
 403     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 404 VALUES
 405     ( @domainID, NULL,  'CiviCase', 'CiviCase', 'administer CiviCase', NULL, @adminlastID, '1', NULL, 10 );
 406
 407 SET @adminCaselastID:=LAST_INSERT_ID();
 408 INSERT INTO civicrm_navigation
 409     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 410 VALUES
 411     ( @domainID, 'civicrm/admin/options/case_type&group=case_type&reset=1',            'Case Types',      'Case Types',      'administer CiviCase', NULL, @adminCaselastID, '1', NULL, 1 ),
 412     ( @domainID, 'civicrm/admin/options/redaction_rule&group=redaction_rule&reset=1',  'Redaction Rules', 'Redaction Rules', 'administer CiviCase', NULL, @adminCaselastID, '1', NULL, 2 ),
 413     ( @domainID, 'civicrm/admin/options/case_status&group=case_status&reset=1',  'Case Statuses', 'Case Statuses', 'administer CiviCase', NULL, @adminCaselastID, '1', NULL, 3 ),
 414     ( @domainID, 'civicrm/admin/options/encounter_medium&group=encounter_medium&reset=1',  'Encounter Medium', 'Encounter Medium', 'administer CiviCase', NULL, @adminCaselastID, '1', NULL, 4 );
 415
 416 INSERT INTO civicrm_navigation
 417     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 418 VALUES
 419     ( @domainID, NULL,  'CiviContribute', 'CiviContribute', 'access CiviContribute,administer CiviCRM', 'AND', @adminlastID, '1', NULL, 11 );
 420
 421 SET @adminContributelastID:=LAST_INSERT_ID();
 422 INSERT INTO civicrm_navigation
 423     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 424 VALUES
 425     ( @domainID, 'civicrm/admin/contribute&reset=1&action=add',            'New Contribution Page',      'New Contribution Page',     'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', NULL, 6 ),
 426     ( @domainID, 'civicrm/admin/contribute&reset=1',                       'Manage Contribution Pages',  'Manage Contribution Pages', 'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', '1',  7 ),
 427     ( @domainID, 'civicrm/admin/pcp?reset=1&page_type=contribute',                              'Personal Campaign Pages',    'Personal Campaign Pages',   'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', NULL, 8 ),
 428     ( @domainID, 'civicrm/admin/contribute/managePremiums&reset=1',        'Premiums (Thank-you Gifts)', 'Premiums',                  'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', 1,    9 ),
 429     ( @domainID, 'civicrm/admin/contribute/contributionType&reset=1',      'Contribution Types',         'Contribution Types',        'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', NULL, 10),
 430     ( @domainID, 'civicrm/admin/options/payment_instrument&group=payment_instrument&reset=1',  'Payment Instruments',    'Payment Instruments',   'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', NULL, 11 ),
 431     ( @domainID, 'civicrm/admin/options/accept_creditcard&group=accept_creditcard&reset=1',    'Accepted Credit Cards',  'Accepted Credit Cards', 'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', 1, 12 ),
 432     ( @domainID, 'civicrm/admin/price&reset=1&action=add',                  'New Price Set',              'New Price Set',             'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', NULL, 13 ),
 433     ( @domainID, 'civicrm/admin/price&reset=1',                             'Manage Price Sets',          'Manage Price Sets',         'access CiviContribute,administer CiviCRM', 'AND', @adminContributelastID, '1', NULL, 14 ),
 434     ( @domainID, 'civicrm/admin/paymentProcessor&reset=1',                  'Payment Processors',         'Payment Processors',        'administer CiviCRM', '',                          @adminContributelastID, '1', NULL, 15  );
 435
 436 INSERT INTO civicrm_navigation
 437     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 438 VALUES
 439     ( @domainID, NULL, 'CiviEvent', 'CiviEvent', 'access CiviEvent,administer CiviCRM', 'AND', @adminlastID, '1', NULL, 12 );
 440
 441 SET @adminEventlastID:=LAST_INSERT_ID();
 442 INSERT INTO civicrm_navigation
 443     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 444 VALUES
 445     ( @domainID, 'civicrm/event/add&reset=1&action=add',                   'New Event',          'New Event',                        'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', NULL, 1 ),
 446     ( @domainID, 'civicrm/event/manage&reset=1',                           'Manage Events',      'Manage Events',                    'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', 1,    2 ),
 447     ( @domainID, 'civicrm/admin/pcp?reset=1&page_type=event',                              'Personal Campaign Pages',    'Personal Campaign Pages',   'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', 1, 3 ),
 448     ( @domainID, 'civicrm/admin/eventTemplate&reset=1',                    'Event Templates',    'Event Templates',                  'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', 1,    4 ),
 449     ( @domainID, 'civicrm/admin/price&reset=1&action=add',                 'New Price Set',      'New Price Set',                    'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', NULL, 5 ),
 450     ( @domainID, 'civicrm/admin/price&reset=1',                            'Manage Price Sets',  'Manage Price Sets',                'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', 1,    6 ),
 451     ( @domainID, 'civicrm/admin/options/event_type&group=event_type&reset=1',  'Event Types',    'Event Types',                      'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', NULL, 7 ),
 452     ( @domainID, 'civicrm/admin/participant_status&reset=1',                   'Participant Statuses', 'Participant Statuses',       'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', NULL, 8 ),
 453     ( @domainID, 'civicrm/admin/options/participant_role&group=participant_role&reset=1', 'Participant Roles', 'Participant Roles',  'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', NULL, 9 ),
 454     ( @domainID, 'civicrm/admin/options/participant_listing&group=participant_listing&reset=1', 'Participant Listing Options', 'Participant Listing Options', 'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', NULL, 10 ),
 455     ( @domainID, 'civicrm/admin/options/event_badge&group=event_badge&reset=1', 'Event Badge Formats', 'Event Badge Formats', 'access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', NULL, 11 ),
 456     ( @domainID, 'civicrm/admin/paymentProcessor&reset=1',                  'Payment Processors', 'Payment Processors',              'administer CiviCRM', '',                     @adminEventlastID, '1', NULL, 12),
 457     ( @domainID, 'civicrm/admin/setting/preferences/event&reset=1',         'CiviEvent Component Settings', 'CiviEvent Component Settings','access CiviEvent,administer CiviCRM', 'AND', @adminEventlastID, '1', NULL, 13 );
 458
 459 INSERT INTO civicrm_navigation
 460     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 461 VALUES
 462     ( @domainID, NULL, 'CiviMail', 'CiviMail', 'access CiviMail,administer CiviCRM', 'AND', @adminlastID, '1', NULL, 14 );
 463
 464 SET @adminMailinglastID:=LAST_INSERT_ID();
 465 INSERT INTO civicrm_navigation
 466     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 467 VALUES
 468     ( @domainID, 'civicrm/admin/component&reset=1',            'Headers, Footers, and Automated Messages', 'Headers, Footers, and Automated Messages', 'access CiviMail,administer CiviCRM', 'AND', @adminMailinglastID, '1', NULL, 1 ),
 469     ( @domainID, 'civicrm/admin/messageTemplates&reset=1',     'Message Templates', 'Message Templates', 'administer CiviCRM', '',   @adminMailinglastID, '1', NULL, 2 ),
 470     ( @domainID, 'civicrm/admin/options/from_email&group=from_email_address&reset=1', 'From Email Addresses', 'From Email Addresses', 'administer CiviCRM', '', @adminMailinglastID, '1', NULL, 3 ),
 471     ( @domainID, 'civicrm/admin/mailSettings&reset=1',         'Mail Accounts', 'Mail Accounts', 'access CiviMail,administer CiviCRM', 'AND',           @adminMailinglastID, '1', NULL, 4 ),
 472     ( @domainID, 'civicrm/admin/mail&reset=1',                 'Mailer Settings', 'Mailer Settings', 'access CiviMail,administer CiviCRM', 'AND',           @adminMailinglastID, '1', NULL, 5 ),
 473     ( @domainID, 'civicrm/admin/setting/preferences/mailing&reset=1', 'CiviMail Component Settings', 'CiviMail Component Settings','access CiviMail,administer CiviCRM', 'AND', @adminMailinglastID, '1', NULL, 6 );
 474
 475 INSERT INTO civicrm_navigation
 476     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 477 VALUES
 478     ( @domainID, NULL, 'CiviMember', 'CiviMember', 'access CiviMember,administer CiviCRM', 'AND', @adminlastID, '1', NULL, 15 );
 479
 480 SET @adminMemberlastID:=LAST_INSERT_ID();
 481 INSERT INTO civicrm_navigation
 482     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 483 VALUES
 484     ( @domainID, 'civicrm/admin/member/membershipType&reset=1',    'Membership Types',        'Membership Types',        'access CiviMember,administer CiviCRM', 'AND', @adminMemberlastID, '1', NULL, 1 ),
 485     ( @domainID, 'civicrm/admin/member/membershipStatus&reset=1',  'Membership Status Rules', 'Membership Status Rules', 'access CiviMember,administer CiviCRM', 'AND', @adminMemberlastID, '1', 1, 2 ),
 486     ( @domainID, 'civicrm/admin/price&reset=1&action=add',         'New Price Set',           'New Price Set',           'access CiviMember,administer CiviCRM', 'AND', @adminMemberlastID, '1', NULL, 3 ),
 487     ( @domainID, 'civicrm/admin/price&reset=1',                    'Manage Price Sets',       'Manage Price Sets',       'access CiviMember,administer CiviCRM', 'AND', @adminMemberlastID, '1', NULL, 4 ),
 488     ( @domainID, 'civicrm/admin/setting/preferences/member&reset=1', 'CiviMember Component Settings', 'CiviMember Component Settings','access CiviMember,administer CiviCRM', 'AND', @adminMemberlastID, '1', NULL, 5 );
 489
 490 INSERT INTO civicrm_navigation
 491     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 492 VALUES
 493     ( @domainID, NULL,                                             'CiviReport',              'CiviReport',              'access CiviReport,administer CiviCRM', 'AND', @adminlastID, '1', NULL, 16 );
 494
 495 SET @adminReportlastID:=LAST_INSERT_ID();
 496 INSERT INTO civicrm_navigation
 497     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 498 VALUES
 499     ( @domainID, 'civicrm/report/list&reset=1',                            'Reports Listing',  'Reports Listing', 'access CiviReport',    '', @adminReportlastID, '1', NULL, 1 ),
 500     ( @domainID, 'civicrm/admin/report/template/list&reset=1',             'Create Reports from Templates', 'Create Reports from Templates', 'administer Reports', '', @adminReportlastID, '1', NULL, 2 ),
 501     ( @domainID, 'civicrm/admin/report/options/report_template&reset=1',   'Manage Templates', 'Manage Templates', 'administer Reports',  '', @adminReportlastID, '1', NULL, 3 ),
 502     ( @domainID, 'civicrm/admin/report/register&reset=1',                  'Register Report',  'Register Report',  'administer Reports',  '', @adminReportlastID, '1', NULL, 4 );
 503
 504 INSERT INTO civicrm_navigation
 505     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 506 VALUES
 507     ( @domainID, NULL, 'Help', 'Help', NULL, '',  NULL, '1', NULL, 110);
 508
 509 SET @adminHelplastID:=LAST_INSERT_ID();
 510 INSERT INTO civicrm_navigation
 511     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 512 VALUES
 513     ( @domainID, 'http://documentation.civicrm.org',   'Documentation',      'Documentation',    NULL, 'AND', @adminHelplastID, '1', NULL, 1 ),
 514     ( @domainID, 'http://forum.civicrm.org',           'Community Forums',   'Community Forums', NULL, 'AND', @adminHelplastID, '1', NULL, 2 ),
 515     ( @domainID, 'http://civicrm.org/participate',     'Participate',        'Participate',      NULL, 'AND', @adminHelplastID, '1', NULL, 3 ),
 516     ( @domainID, 'http://civicrm.org/aboutcivicrm',    'About',              'About',            NULL, 'AND', @adminHelplastID, '1', NULL, 4 );
 517
 518 INSERT INTO civicrm_navigation
 519     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 520 VALUES
 521     ( @domainID, NULL, 'Reports', 'Reports', 'access CiviReport', '',  NULL, '1', NULL, 95 );
 522
 523 SET @reportlastID:=LAST_INSERT_ID();
 524 INSERT INTO civicrm_navigation
 525     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 526 VALUES
 527     ( @domainID, 'civicrm/report/list&reset=1', 'Reports Listing', 'Reports Listing', 'access CiviReport', '', @reportlastID, '1', 1,    1 );
 528
 529 INSERT INTO civicrm_navigation
 530     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 531 VALUES
 532     ( @domainID, 'civicrm/admin/report/template/list&reset=1',  'Create Reports from Templates',  'Create Reports from Templates', 'administer Reports',  '', @reportlastID, '1', 1, 2 );
 533
 534 -- sample reports with navigation menus
 535
 536 INSERT INTO `civicrm_report_instance`
 537     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 538 VALUES
 539     (  @domainID, 'Constituent Report (Summary)', 'contact/summary', 'Provides a list of address and telephone information for constituent records in your system.', 'administer CiviCRM', 'a:31:{s:6:"fields";a:4:{s:9:"sort_name";s:1:"1";s:14:"street_address";s:1:"1";s:4:"city";s:1:"1";s:10:"country_id";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:9:"source_op";s:3:"has";s:12:"source_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:13:"country_id_op";s:2:"in";s:16:"country_id_value";a:0:{}s:20:"state_province_id_op";s:2:"in";s:23:"state_province_id_value";a:0:{}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"custom_1_op";s:2:"in";s:14:"custom_1_value";a:0:{}s:11:"custom_2_op";s:2:"in";s:14:"custom_2_value";a:0:{}s:17:"custom_3_relative";s:1:"0";s:13:"custom_3_from";s:0:"";s:11:"custom_3_to";s:0:"";s:11:"description";s:92:"Provides a list of address and telephone information for constituent records in your system.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:18:"administer CiviCRM";s:6:"groups";s:0:"";s:9:"domain_id";i:1;}');
 540 SET @instanceID:=LAST_INSERT_ID();
 541 INSERT INTO civicrm_navigation
 542     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 543 VALUES
 544     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'),     'Constituent Report (Summary)',       'Constituent Report (Summary)',     'administer CiviCRM',       '',  @reportlastID,  '1', NULL, @instanceID+2 );
 545 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 546
 547
 548 INSERT INTO `civicrm_report_instance`
 549     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 550 VALUES
 551     ( @domainID, 'Constituent Report (Detail)', 'contact/detail', 'Provides contact-related information on contributions, memberships, events and activities.', 'administer CiviCRM', 'a:25:{s:6:"fields";a:30:{s:9:"sort_name";s:1:"1";s:10:"country_id";s:1:"1";s:15:"contribution_id";s:1:"1";s:12:"total_amount";s:1:"1";s:20:"contribution_type_id";s:1:"1";s:12:"receive_date";s:1:"1";s:22:"contribution_status_id";s:1:"1";s:13:"membership_id";s:1:"1";s:18:"membership_type_id";s:1:"1";s:21:"membership_start_date";s:1:"1";s:19:"membership_end_date";s:1:"1";s:20:"membership_status_id";s:1:"1";s:14:"participant_id";s:1:"1";s:8:"event_id";s:1:"1";s:21:"participant_status_id";s:1:"1";s:7:"role_id";s:1:"1";s:25:"participant_register_date";s:1:"1";s:9:"fee_level";s:1:"1";s:10:"fee_amount";s:1:"1";s:15:"relationship_id";s:1:"1";s:20:"relationship_type_id";s:1:"1";s:12:"contact_id_b";s:1:"1";s:2:"id";s:1:"1";s:16:"activity_type_id";s:1:"1";s:7:"subject";s:1:"1";s:17:"source_contact_id";s:1:"1";s:18:"activity_date_time";s:1:"1";s:18:"activity_status_id";s:1:"1";s:17:"target_contact_id";s:1:"1";s:19:"assignee_contact_id";s:1:"1";}s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"custom_1_op";s:2:"in";s:14:"custom_1_value";a:0:{}s:11:"custom_2_op";s:2:"in";s:14:"custom_2_value";a:0:{}s:17:"custom_3_relative";s:1:"0";s:13:"custom_3_from";s:0:"";s:11:"custom_3_to";s:0:"";s:11:"description";s:90:"Provides contact-related information on contributions, memberships, events and activities.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:18:"administer CiviCRM";s:6:"groups";s:0:"";s:9:"domain_id";i:1;}');
 552 SET @instanceID:=LAST_INSERT_ID();
 553 INSERT INTO civicrm_navigation
 554     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 555 VALUES
 556     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'),     'Constituent Report (Detail)',        'Constituent Report (Detail)',      'administer CiviCRM',       '',  @reportlastID,  '1', NULL, @instanceID+2  );
 557 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 558
 559 INSERT INTO `civicrm_report_instance`
 560     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 561 VALUES
 562     ( @domainID, 'Activity Report ', 'activity', 'Provides a list of constituent activity including activity statistics for one/all contacts during a given date range(required)', 'administer CiviCRM', 'a:26:{s:6:"fields";a:6:{s:16:"contact_assignee";s:1:"1";s:14:"contact_target";s:1:"1";s:16:"activity_type_id";s:1:"1";s:16:"activity_subject";s:1:"1";s:18:"activity_date_time";s:1:"1";s:9:"status_id";s:1:"1";}s:17:"contact_source_op";s:3:"has";s:20:"contact_source_value";s:0:"";s:19:"contact_assignee_op";s:3:"has";s:22:"contact_assignee_value";s:0:"";s:17:"contact_target_op";s:3:"has";s:20:"contact_target_value";s:0:"";s:15:"current_user_op";s:2:"eq";s:18:"current_user_value";s:1:"0";s:27:"activity_date_time_relative";s:10:"this.month";s:23:"activity_date_time_from";s:0:"";s:21:"activity_date_time_to";s:0:"";s:19:"activity_subject_op";s:3:"has";s:22:"activity_subject_value";s:0:"";s:19:"activity_type_id_op";s:2:"in";s:22:"activity_type_id_value";a:0:{}s:12:"status_id_op";s:2:"in";s:15:"status_id_value";a:0:{}s:11:"description";s:126:"Provides a list of constituent activity including activity statistics for one/all contacts during a given date range(required)";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:18:"administer CiviCRM";s:6:"groups";s:0:"";s:9:"group_bys";N;s:9:"domain_id";i:1;}');
 563 SET @instanceID:=LAST_INSERT_ID();
 564 INSERT INTO civicrm_navigation
 565     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 566 VALUES
 567     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'),    'Activity Report',                    'activity',                                            'administer CiviCRM',       '',  @reportlastID,  '1', NULL, @instanceID+2 );
 568 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 569
 570 INSERT INTO `civicrm_report_instance`
 571     (`domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 572 VALUES
 573     ( @domainID, 'Current Employer Report', 'contact/currentEmployer', 'Provides detail list of employer employee relationships along with employment details.', 'administer CiviCRM', 'a:33:{s:6:"fields";a:5:{s:17:"organization_name";s:1:"1";s:9:"sort_name";s:1:"1";s:9:"job_title";s:1:"1";s:10:"start_date";s:1:"1";s:5:"email";s:1:"1";}s:20:"organization_name_op";s:3:"has";s:23:"organization_name_value";s:0:"";s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:19:"start_date_relative";s:1:"0";s:15:"start_date_from";s:0:"";s:13:"start_date_to";s:0:"";s:13:"country_id_op";s:2:"in";s:16:"country_id_value";a:0:{}s:20:"state_province_id_op";s:2:"in";s:23:"state_province_id_value";a:0:{}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"custom_1_op";s:2:"in";s:14:"custom_1_value";a:0:{}s:11:"custom_2_op";s:2:"in";s:14:"custom_2_value";a:0:{}s:17:"custom_3_relative";s:1:"0";s:13:"custom_3_from";s:0:"";s:11:"custom_3_to";s:0:"";s:11:"description";s:98:"Provides detail list of employer employee relationships along with employment details Ex Join Date";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:18:"administer CiviCRM";s:9:"domain_id";i:1;}');
 574 SET @instanceID:=LAST_INSERT_ID();
 575 INSERT INTO civicrm_navigation
 576     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 577 VALUES
 578     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'),    'Current Employer Report',                    'Current Employer Report',  'administer CiviCRM',       '',  @reportlastID,  '1', NULL, @instanceID+2 );
 579 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 580
 581
 582 INSERT INTO `civicrm_report_instance`
 583     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 584 VALUES
 585     ( @domainID, 'Relationship Report', 'contact/relationship', 'Gives relationship details between two contacts', 'administer CiviCRM', 'a:28:{s:6:"fields";a:4:{s:11:"sort_name_a";s:1:"1";s:11:"sort_name_b";s:1:"1";s:9:"label_a_b";s:1:"1";s:9:"label_b_a";s:1:"1";}s:14:"sort_name_a_op";s:3:"has";s:17:"sort_name_a_value";s:0:"";s:14:"sort_name_b_op";s:3:"has";s:17:"sort_name_b_value";s:0:"";s:17:"contact_type_a_op";s:2:"in";s:20:"contact_type_a_value";a:0:{}s:17:"contact_type_b_op";s:2:"in";s:20:"contact_type_b_value";a:0:{}s:12:"is_active_op";s:2:"eq";s:15:"is_active_value";s:0:"";s:23:"relationship_type_id_op";s:2:"eq";s:26:"relationship_type_id_value";s:0:"";s:13:"country_id_op";s:2:"in";s:16:"country_id_value";a:0:{}s:20:"state_province_id_op";s:2:"in";s:23:"state_province_id_value";a:0:{}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"description";s:19:"Relationship Report";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:18:"administer CiviCRM";s:6:"groups";s:0:"";s:9:"domain_id";i:1;}');
 586 SET @instanceID:=LAST_INSERT_ID();
 587 INSERT INTO civicrm_navigation
 588     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 589 VALUES
 590     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'),    'Relationship Report',                'Relationship Report',                                 'administer CiviCRM',       '',  @reportlastID,  '1', NULL, @instanceID+2 );
 591 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 592
 593
 594 INSERT INTO `civicrm_report_instance`
 595     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 596 VALUES
 597     ( @domainID, 'Contribution Summary Report', 'contribute/summary', 'Groups and totals contributions by criteria including contact, time period, contribution type, contributor location, etc.', 'access CiviContribute', 'a:42:{s:6:"fields";a:1:{s:12:"total_amount";s:1:"1";}s:13:"country_id_op";s:2:"in";s:16:"country_id_value";a:0:{}s:20:"state_province_id_op";s:2:"in";s:23:"state_province_id_value";a:0:{}s:21:"receive_date_relative";s:1:"0";s:17:"receive_date_from";s:0:"";s:15:"receive_date_to";s:0:"";s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:1:{i:0;s:1:"1";}s:23:"contribution_type_id_op";s:2:"in";s:26:"contribution_type_id_value";a:0:{}s:16:"total_amount_min";s:0:"";s:16:"total_amount_max";s:0:"";s:15:"total_amount_op";s:3:"lte";s:18:"total_amount_value";s:0:"";s:13:"total_sum_min";s:0:"";s:13:"total_sum_max";s:0:"";s:12:"total_sum_op";s:3:"lte";s:15:"total_sum_value";s:0:"";s:15:"total_count_min";s:0:"";s:15:"total_count_max";s:0:"";s:14:"total_count_op";s:3:"lte";s:17:"total_count_value";s:0:"";s:13:"total_avg_min";s:0:"";s:13:"total_avg_max";s:0:"";s:12:"total_avg_op";s:3:"lte";s:15:"total_avg_value";s:0:"";s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:9:"group_bys";a:1:{s:12:"receive_date";s:1:"1";}s:14:"group_bys_freq";a:1:{s:12:"receive_date";s:5:"MONTH";}s:11:"description";s:80:"Shows contribution statistics by month / week / year .. country / state .. type.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:21:"access CiviContribute";s:6:"groups";s:0:"";s:6:"charts";s:0:"";s:9:"domain_id";i:1;}');
 598 SET @instanceID:=LAST_INSERT_ID();
 599 INSERT INTO civicrm_navigation
 600     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 601 VALUES
 602     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'),     'Contribution Summary Report',             'Contribution Summary Report',           'access CiviContribute',    '',  @reportlastID,  '1', NULL, @instanceID+2 );
 603 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 604
 605
 606 INSERT INTO `civicrm_report_instance`
 607     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 608 VALUES
 609     ( @domainID, 'Contribution Detail Report', 'contribute/detail', 'Lists specific contributions by criteria including contact, time period, contribution type, contributor location, etc. Contribution summary report points to this report for contribution details.', 'access CiviContribute', 'a:34:{s:6:"fields";a:7:{s:9:"sort_name";s:1:"1";s:5:"email";s:1:"1";s:5:"phone";s:1:"1";s:10:"country_id";s:1:"1";s:20:"contribution_type_id";s:1:"1";s:12:"receive_date";s:1:"1";s:12:"total_amount";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:13:"country_id_op";s:2:"in";s:16:"country_id_value";a:0:{}s:20:"state_province_id_op";s:2:"in";s:23:"state_province_id_value";a:0:{}s:21:"receive_date_relative";s:1:"0";s:17:"receive_date_from";s:0:"";s:15:"receive_date_to";s:0:"";s:23:"contribution_type_id_op";s:2:"in";s:26:"contribution_type_id_value";a:0:{}s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:1:{i:0;s:1:"1";}s:16:"total_amount_min";s:0:"";s:16:"total_amount_max";s:0:"";s:15:"total_amount_op";s:3:"lte";s:18:"total_amount_value";s:0:"";s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:13:"ordinality_op";s:2:"in";s:16:"ordinality_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"description";s:126:"Lists detailed contribution(s) for one / all contacts. Contribution summary report points to this report for specific details.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:21:"access CiviContribute";s:9:"domain_id";i:1;}');
 610 SET @instanceID:=LAST_INSERT_ID();
 611 INSERT INTO civicrm_navigation
 612     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 613 VALUES
 614     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'),     'Contribution Detail Report',              'Contribution Detail Report',            'access CiviContribute',    '',  @reportlastID,  '1', NULL, @instanceID+2 );
 615 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 616
 617
 618 INSERT INTO `civicrm_report_instance`
 619     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 620 VALUES
 621     ( @domainID, 'Repeat Contribution Report', 'contribute/repeat', 'Given two date ranges, shows contacts who contributed in both the date ranges with the amount contributed in each and the percentage increase / decrease.', 'access CiviContribute', 'a:29:{s:6:"fields";a:3:{s:9:"sort_name";s:1:"1";s:13:"total_amount1";s:1:"1";s:13:"total_amount2";s:1:"1";}s:22:"receive_date1_relative";s:13:"previous.year";s:18:"receive_date1_from";s:0:"";s:16:"receive_date1_to";s:0:"";s:22:"receive_date2_relative";s:9:"this.year";s:18:"receive_date2_from";s:0:"";s:16:"receive_date2_to";s:0:"";s:17:"total_amount1_min";s:0:"";s:17:"total_amount1_max";s:0:"";s:16:"total_amount1_op";s:3:"lte";s:19:"total_amount1_value";s:0:"";s:17:"total_amount2_min";s:0:"";s:17:"total_amount2_max";s:0:"";s:16:"total_amount2_op";s:3:"lte";s:19:"total_amount2_value";s:0:"";s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:1:{i:0;s:1:"1";}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:9:"group_bys";a:1:{s:2:"id";s:1:"1";}s:11:"description";s:140:"Given two date ranges, shows contacts (and their contributions) who contributed in both the date ranges with percentage increase / decrease.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:21:"access CiviContribute";s:6:"groups";s:0:"";s:9:"domain_id";i:1;}');
 622 SET @instanceID:=LAST_INSERT_ID();
 623 INSERT INTO civicrm_navigation
 624     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 625 VALUES
 626     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'),     'Repeat Contribution Report',   'Repeat Contribution Report', 'access CiviContribute',    '',  @reportlastID,  '1', NULL, @instanceID+2 );
 627 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 628
 629
 630 INSERT INTO `civicrm_report_instance`
 631     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 632 VALUES
 633     ( @domainID, 'SYBUNT Report', 'contribute/sybunt', 'Some year(s) but not this year. Provides a list of constituents who donated at some time in the history of your organization but did not donate during the time period you specify.', 'access CiviContribute', 'a:18:{s:6:"fields";a:3:{s:9:"sort_name";s:1:"1";s:5:"email";s:1:"1";s:5:"phone";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:6:"yid_op";s:2:"eq";s:9:"yid_value";s:4:"2011";s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:1:{i:0;s:1:"1";}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"description";s:179:"Some year(s) but not this year. Provides a list of constituents who donated at some time in the history of your organization but did not donate during the time period you specify.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:21:"access CiviContribute";s:6:"charts";s:0:"";s:9:"domain_id";i:1;}');
 634 SET @instanceID:=LAST_INSERT_ID();
 635 INSERT INTO civicrm_navigation
 636     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 637 VALUES
 638     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'),     'SYBUNT Report',                      'SYBUNT Report',                                       'access CiviContribute',    '',  @reportlastID,  '1', NULL, @instanceID+2 );
 639 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 640
 641
 642 INSERT INTO `civicrm_report_instance`
 643     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 644 VALUES
 645     ( @domainID, 'LYBUNT Report', 'contribute/lybunt', 'Last year but not this year. Provides a list of constituents who donated last year but did not donate during the time period you specify as the current year.', 'access CiviContribute', 'a:19:{s:6:"fields";a:3:{s:9:"sort_name";s:1:"1";s:5:"email";s:1:"1";s:5:"phone";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:6:"yid_op";s:2:"eq";s:9:"yid_value";s:4:"2011";s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:1:{i:0;s:1:"1";}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"description";s:157:"Last year but not this year. Provides a list of constituents who donated last year but did not donate during the time period you specify as the current year.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:21:"access CiviContribute";s:6:"groups";s:0:"";s:6:"charts";s:0:"";s:9:"domain_id";i:1;}');
 646 SET @instanceID:=LAST_INSERT_ID();
 647 INSERT INTO civicrm_navigation
 648     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 649 VALUES
 650     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'),     'LYBUNT Report',                      'LYBUNT Report',                                       'access CiviContribute',    '',  @reportlastID,  '1', NULL, @instanceID+2 );
 651 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 652
 653 INSERT INTO `civicrm_report_instance`
 654     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 655 VALUES
 656     ( @domainID, 'Contributions by Organization Report', 'contribute/organizationSummary', 'Displays a detailed list of contributions grouped by organization, which includes contributions made by employees for the organisation.', 'access CiviContribute', 'a:20:{s:6:"fields";a:5:{s:17:"organization_name";s:1:"1";s:9:"sort_name";s:1:"1";s:12:"total_amount";s:1:"1";s:22:"contribution_status_id";s:1:"1";s:12:"receive_date";s:1:"1";}s:20:"organization_name_op";s:3:"has";s:23:"organization_name_value";s:0:"";s:23:"relationship_type_id_op";s:2:"eq";s:26:"relationship_type_id_value";s:5:"4_b_a";s:21:"receive_date_relative";s:1:"0";s:17:"receive_date_from";s:0:"";s:15:"receive_date_to";s:0:"";s:16:"total_amount_min";s:0:"";s:16:"total_amount_max";s:0:"";s:15:"total_amount_op";s:3:"lte";s:18:"total_amount_value";s:0:"";s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:1:{i:0;s:1:"1";}s:11:"description";s:193:"Displays a detailed contribution report for Organization relationships with contributors, as to if contribution done was  from an employee of some organization or from that Organization itself.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:21:"access CiviContribute";s:9:"domain_id";i:1;}');
 657 SET @instanceID:=LAST_INSERT_ID();
 658 INSERT INTO civicrm_navigation
 659     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 660 VALUES
 661     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'),    'Contributions by Organization Report', 'Contributions by Organization Report', 'access CiviContribute', '',  @reportlastID,  '1', NULL, @instanceID+2 );
 662 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 663
 664
 665 INSERT INTO `civicrm_report_instance`
 666     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 667 VALUES
 668     ( @domainID, 'Contributions by Household Report', 'contribute/householdSummary', 'Displays a detailed list of contributions grouped by household which includes contributions made by members of the household.', 'access CiviContribute', 'a:21:{s:6:"fields";a:5:{s:14:"household_name";s:1:"1";s:9:"sort_name";s:1:"1";s:12:"total_amount";s:1:"1";s:22:"contribution_status_id";s:1:"1";s:12:"receive_date";s:1:"1";}s:17:"household_name_op";s:3:"has";s:20:"household_name_value";s:0:"";s:23:"relationship_type_id_op";s:2:"eq";s:26:"relationship_type_id_value";s:5:"6_b_a";s:21:"receive_date_relative";s:1:"0";s:17:"receive_date_from";s:0:"";s:15:"receive_date_to";s:0:"";s:16:"total_amount_min";s:0:"";s:16:"total_amount_max";s:0:"";s:15:"total_amount_op";s:3:"lte";s:18:"total_amount_value";s:0:"";s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:1:{i:0;s:1:"1";}s:11:"description";s:213:"Provides a detailed report for Contributions made by contributors(Or Household itself) who are having a relationship with household (For ex a Contributor is Head of Household for some household or is a member of.)";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:21:"access CiviContribute";s:6:"groups";s:0:"";s:9:"domain_id";i:1;}');
 669 SET @instanceID:=LAST_INSERT_ID();
 670 INSERT INTO civicrm_navigation
 671     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 672 VALUES
 673     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'),    'Contributions by Household Report',    'Contributions by Household Report',    'access CiviContribute', '',  @reportlastID,  '1', NULL, @instanceID+2 );
 674 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 675
 676 INSERT INTO `civicrm_report_instance`
 677     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 678 VALUES
 679     ( @domainID, 'Top Donors Report', 'contribute/topDonor', 'Provides a list of the top donors during a time period you define. You can include as many donors as you want (for example, top 100 of your donors).', 'access CiviContribute', 'a:20:{s:6:"fields";a:2:{s:12:"display_name";s:1:"1";s:12:"total_amount";s:1:"1";}s:21:"receive_date_relative";s:9:"this.year";s:17:"receive_date_from";s:0:"";s:15:"receive_date_to";s:0:"";s:15:"total_range_min";s:0:"";s:15:"total_range_max";s:0:"";s:14:"total_range_op";s:2:"eq";s:17:"total_range_value";s:0:"";s:23:"contribution_type_id_op";s:2:"in";s:26:"contribution_type_id_value";a:0:{}s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:1:{i:0;s:1:"1";}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:11:"description";s:148:"Provides a list of the top donors during a time period you define. You can include as many donors as you want (for example, top 100 of your donors).";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:21:"access CiviContribute";s:6:"groups";s:0:"";}');
 680 SET @instanceID:=LAST_INSERT_ID();
 681 INSERT INTO civicrm_navigation
 682     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 683 VALUES
 684     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'),    'Top Donors Report',                  'Top Donors Report',            'access CiviContribute',   '',  @reportlastID,  '1', NULL, @instanceID+2 );
 685 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 686
 687 INSERT INTO `civicrm_report_instance`
 688     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 689 VALUES
 690     ( @domainID, 'Soft Credit Report', 'contribute/softcredit', 'Shows contributions made by contacts that have been soft-credited to other contacts.', 'access CiviContribute', 'a:23:{s:6:"fields";a:5:{s:21:"display_name_creditor";s:1:"1";s:24:"display_name_constituent";s:1:"1";s:14:"email_creditor";s:1:"1";s:14:"phone_creditor";s:1:"1";s:12:"total_amount";s:1:"1";}s:5:"id_op";s:2:"in";s:8:"id_value";a:0:{}s:21:"receive_date_relative";s:1:"0";s:17:"receive_date_from";s:0:"";s:15:"receive_date_to";s:0:"";s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:1:{i:0;s:1:"1";}s:16:"total_amount_min";s:0:"";s:16:"total_amount_max";s:0:"";s:15:"total_amount_op";s:3:"lte";s:18:"total_amount_value";s:0:"";s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"description";s:20:"Soft Credit details.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:21:"access CiviContribute";s:6:"groups";s:0:"";s:9:"domain_id";i:1;}');
 691 SET @instanceID:=LAST_INSERT_ID();
 692 INSERT INTO civicrm_navigation
 693     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 694 VALUES
 695     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'),     'Soft Credit Report',                 'Soft Credit Report',                                  'access CiviContribute',    '',  @reportlastID,  '1', NULL, @instanceID+2 );
 696 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 697
 698
 699 INSERT INTO `civicrm_report_instance`
 700     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 701 VALUES
 702     ( @domainID, 'Personal Campaign Page Summary', 'contribute/pcp', 'Summarizes amount raised and number of contributors for each Personal Campaign Page.', 'access CiviContribute', 'a:22:{s:6:"fields";a:8:{s:9:"sort_name";s:1:"1";s:10:"page_title";s:1:"1";s:5:"title";s:1:"1";s:11:"goal_amount";s:1:"1";s:8:"amount_1";s:1:"1";s:8:"amount_2";s:1:"1";s:7:"soft_id";s:1:"1";s:12:"receive_date";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:13:"page_title_op";s:3:"has";s:16:"page_title_value";s:0:"";s:8:"title_op";s:3:"has";s:11:"title_value";s:0:"";s:12:"amount_2_min";s:0:"";s:12:"amount_2_max";s:0:"";s:11:"amount_2_op";s:3:"lte";s:14:"amount_2_value";s:0:"";s:11:"description";s:35:"Shows Personal Campaign Page Report";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:21:"access CiviContribute";s:6:"groups";s:0:"";s:9:"domain_id";i:1;}');
 703 SET @instanceID:=LAST_INSERT_ID();
 704 INSERT INTO civicrm_navigation
 705     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 706 VALUES
 707     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'),     'Personal Campaign Page Summary',                 'Personal Campaign Page Summary',                                  'access CiviContribute',    '',  @reportlastID,  '1', NULL, @instanceID+2 );
 708 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 709
 710
 711 INSERT INTO `civicrm_report_instance`
 712     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 713 VALUES
 714     ( @domainID, 'Pledge Summary Report', 'pledge/detail', 'Summary of pledges including amount pledged, pledge status, next payment date, balance due, total amount paid etc.', 'access CiviPledge', 'a:27:{s:6:"fields";a:4:{s:9:"sort_name";s:1:"1";s:10:"country_id";s:1:"1";s:6:"amount";s:1:"1";s:9:"status_id";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:27:"pledge_create_date_relative";s:1:"0";s:23:"pledge_create_date_from";s:0:"";s:21:"pledge_create_date_to";s:0:"";s:17:"pledge_amount_min";s:0:"";s:17:"pledge_amount_max";s:0:"";s:16:"pledge_amount_op";s:3:"lte";s:19:"pledge_amount_value";s:0:"";s:6:"sid_op";s:2:"in";s:9:"sid_value";a:0:{}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"description";s:13:"Pledge Report";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:17:"access CiviPledge";s:6:"groups";s:0:"";s:9:"domain_id";i:1;}');
 715 SET @instanceID:=LAST_INSERT_ID();
 716 INSERT INTO civicrm_navigation
 717     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 718 VALUES
 719     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'),    'Pledge Summary Report',              'Pledge Summary Report',        'access CiviPledge',       '',  @reportlastID,  '1', NULL, @instanceID+2 );
 720 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 721
 722 INSERT INTO `civicrm_report_instance`
 723     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 724 VALUES
 725     ( @domainID, 'Pledged But not Paid Report', 'pledge/pbnp', 'Pledged but not Paid Report', 'access CiviPledge', 'a:17:{s:6:"fields";a:5:{s:9:"sort_name";s:1:"1";s:18:"pledge_create_date";s:1:"1";s:6:"amount";s:1:"1";s:14:"scheduled_date";s:1:"1";s:10:"country_id";s:1:"1";}s:27:"pledge_create_date_relative";s:1:"0";s:23:"pledge_create_date_from";s:0:"";s:21:"pledge_create_date_to";s:0:"";s:23:"contribution_type_id_op";s:2:"in";s:26:"contribution_type_id_value";a:0:{}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"description";s:27:"Pledged but not Paid Report";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:17:"access CiviPledge";s:6:"groups";s:0:"";s:9:"domain_id";i:1;}');
 726 SET @instanceID:=LAST_INSERT_ID();
 727 INSERT INTO civicrm_navigation
 728     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 729 VALUES
 730     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'),    'Pledged But not Paid Report',        'Pledged But not Paid Report',  'access CiviPledge',       '',  @reportlastID,  '1', NULL, @instanceID+2 );
 731 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 732
 733 INSERT INTO `civicrm_report_instance`
 734     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 735 VALUES
 736     ( @domainID, 'Bookkeeping Transactions Report', 'contribute/bookkeeping', 'Shows Bookkeeping Transactions Report', 'access CiviContribute', 'a:25:{s:6:"fields";a:10:{s:9:"sort_name";s:1:"1";s:12:"receive_date";s:1:"1";s:12:"total_amount";s:1:"1";s:20:"contribution_type_id";s:1:"1";s:7:"trxn_id";s:1:"1";s:10:"invoice_id";s:1:"1";s:12:"check_number";s:1:"1";s:21:"payment_instrument_id";s:1:"1";s:22:"contribution_status_id";s:1:"1";s:2:"id";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:21:"receive_date_relative";s:1:"0";s:17:"receive_date_from";s:0:"";s:15:"receive_date_to";s:0:"";s:23:"contribution_type_id_op";s:2:"in";s:26:"contribution_type_id_value";a:0:{}s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:1:{i:0;s:1:"1";}s:16:"total_amount_min";s:0:"";s:16:"total_amount_max";s:0:"";s:15:"total_amount_op";s:3:"lte";s:18:"total_amount_value";s:0:"";s:11:"description";s:37:"Shows Bookkeeping Transactions Report";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:21:"access CiviContribute";s:6:"groups";s:0:"";s:9:"domain_id";i:1;}');
 737 SET @instanceID:=LAST_INSERT_ID();
 738 INSERT INTO civicrm_navigation
 739     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 740 VALUES
 741     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Bookkeeping Transactions Report', 'Bookkeeping Transactions Report', 'access CiviContribute', '', @reportlastID, '1', NULL, @instanceID+2 );
 742
 743 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 744
 745
 746 INSERT INTO `civicrm_report_instance`
 747     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 748 VALUES
 749     ( @domainID, 'Membership Report (Summary)', 'member/summary', 'Provides a summary of memberships by type and join date.', 'access CiviMember', 'a:18:{s:6:"fields";a:2:{s:18:"membership_type_id";s:1:"1";s:12:"total_amount";s:1:"1";}s:18:"join_date_relative";s:1:"0";s:14:"join_date_from";s:0:"";s:12:"join_date_to";s:0:"";s:21:"membership_type_id_op";s:2:"in";s:24:"membership_type_id_value";a:0:{}s:12:"status_id_op";s:2:"in";s:15:"status_id_value";a:0:{}s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:0:{}s:9:"group_bys";a:2:{s:9:"join_date";s:1:"1";s:18:"membership_type_id";s:1:"1";}s:14:"group_bys_freq";a:1:{s:9:"join_date";s:5:"MONTH";}s:11:"description";s:56:"Provides a summary of memberships by type and join date.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:17:"access CiviMember";s:9:"domain_id";i:1;}');
 750 SET @instanceID:=LAST_INSERT_ID();
 751 INSERT INTO civicrm_navigation
 752     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 753 VALUES
 754     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'),     'Membership Report (Summary)',        'Membership Report (Summary)',      'access CiviMember',        '',  @reportlastID,  '1', NULL, @instanceID+2 );
 755 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 756
 757
 758 INSERT INTO `civicrm_report_instance`
 759     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 760 VALUES
 761     ( @domainID, 'Membership Report (Detail)', 'member/detail', 'Provides a list of members along with their membership status and membership details (Join Date, Start Date, End Date). Can also display contributions (payments) associated with each membership.', 'access CiviMember', 'a:28:{s:6:"fields";a:5:{s:9:"sort_name";s:1:"1";s:18:"membership_type_id";s:1:"1";s:21:"membership_start_date";s:1:"1";s:19:"membership_end_date";s:1:"1";s:4:"name";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:18:"join_date_relative";s:1:"0";s:14:"join_date_from";s:0:"";s:12:"join_date_to";s:0:"";s:23:"owner_membership_id_min";s:0:"";s:23:"owner_membership_id_max";s:0:"";s:22:"owner_membership_id_op";s:3:"lte";s:25:"owner_membership_id_value";s:0:"";s:6:"tid_op";s:2:"in";s:9:"tid_value";a:0:{}s:6:"sid_op";s:2:"in";s:9:"sid_value";a:0:{}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"description";s:119:"Provides a list of members along with their membership status and membership details (Join Date, Start Date, End Date).";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:17:"access CiviMember";s:9:"domain_id";i:1;}');
 762 SET @instanceID:=LAST_INSERT_ID();
 763 INSERT INTO civicrm_navigation
 764     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 765 VALUES
 766     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'),    'Membership Report (Detail)',         'Membership Report (Detail)',       'access CiviMember',        '',  @reportlastID,  '1', NULL, @instanceID+2 );
 767 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 768
 769 -- contribution and membership report
 770 INSERT INTO `civicrm_report_instance`
 771     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 772 VALUES
 773     ( @domainID, 'Contribution and Membership Details', 'member/contributionDetail', 'Contribution details for any type of contribution, plus associated membership information for contributions which are in payment for memberships.', '', 'a:67:{s:6:"fields";a:12:{s:9:"sort_name";s:1:"1";s:5:"email";s:1:"1";s:5:"phone";s:1:"1";s:20:"contribution_type_id";s:1:"1";s:12:"receive_date";s:1:"1";s:12:"total_amount";s:1:"1";s:18:"membership_type_id";s:1:"1";s:21:"membership_start_date";s:1:"1";s:19:"membership_end_date";s:1:"1";s:9:"join_date";s:1:"1";s:22:"membership_status_name";s:1:"1";s:10:"country_id";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:21:"receive_date_relative";s:1:"0";s:17:"receive_date_from";s:0:"";s:15:"receive_date_to";s:0:"";s:23:"contribution_type_id_op";s:2:"in";s:26:"contribution_type_id_value";a:0:{}s:24:"payment_instrument_id_op";s:2:"in";s:27:"payment_instrument_id_value";a:0:{}s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:0:{}s:16:"total_amount_min";s:0:"";s:16:"total_amount_max";s:0:"";s:15:"total_amount_op";s:3:"lte";s:18:"total_amount_value";s:0:"";s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:13:"ordinality_op";s:2:"in";s:16:"ordinality_value";a:0:{}s:18:"join_date_relative";s:1:"0";s:14:"join_date_from";s:0:"";s:12:"join_date_to";s:0:"";s:30:"membership_start_date_relative";s:1:"0";s:26:"membership_start_date_from";s:0:"";s:24:"membership_start_date_to";s:0:"";s:28:"membership_end_date_relative";s:1:"0";s:24:"membership_end_date_from";s:0:"";s:22:"membership_end_date_to";s:0:"";s:23:"owner_membership_id_min";s:0:"";s:23:"owner_membership_id_max";s:0:"";s:22:"owner_membership_id_op";s:3:"lte";s:25:"owner_membership_id_value";s:0:"";s:6:"tid_op";s:2:"in";s:9:"tid_value";a:0:{}s:6:"sid_op";s:2:"in";s:9:"sid_value";a:0:{}s:17:"street_number_min";s:0:"";s:17:"street_number_max";s:0:"";s:16:"street_number_op";s:3:"lte";s:19:"street_number_value";s:0:"";s:14:"street_name_op";s:3:"has";s:17:"street_name_value";s:0:"";s:15:"postal_code_min";s:0:"";s:15:"postal_code_max";s:0:"";s:14:"postal_code_op";s:3:"lte";s:17:"postal_code_value";s:0:"";s:7:"city_op";s:3:"has";s:10:"city_value";s:0:"";s:12:"county_id_op";s:2:"in";s:15:"county_id_value";a:0:{}s:20:"state_province_id_op";s:2:"in";s:23:"state_province_id_value";a:0:{}s:13:"country_id_op";s:2:"in";s:16:"country_id_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"description";s:35:"Contribution and Membership Details";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:1:"0";s:9:"domain_id";i:1;}{s:6:"fields";a:12:{s:9:"sort_name";s:1:"1";s:5:"email";s:1:"1";s:5:"phone";s:1:"1";s:20:"contribution_type_id";s:1:"1";s:12:"receive_date";s:1:"1";s:12:"total_amount";s:1:"1";s:18:"membership_type_id";s:1:"1";s:21:"membership_start_date";s:1:"1";s:19:"membership_end_date";s:1:"1";s:9:"join_date";s:1:"1";s:22:"membership_status_name";s:1:"1";s:10:"country_id";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:21:"receive_date_relative";s:1:"0";s:17:"receive_date_from";s:0:"";s:15:"receive_date_to";s:0:"";s:23:"contribution_type_id_op";s:2:"in";s:26:"contribution_type_id_value";a:0:{}s:24:"payment_instrument_id_op";s:2:"in";s:27:"payment_instrument_id_value";a:0:{}s:25:"contribution_status_id_op";s:2:"in";s:28:"contribution_status_id_value";a:0:{}s:16:"total_amount_min";s:0:"";s:16:"total_amount_max";s:0:"";s:15:"total_amount_op";s:3:"lte";s:18:"total_amount_value";s:0:"";s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:13:"ordinality_op";s:2:"in";s:16:"ordinality_value";a:0:{}s:18:"join_date_relative";s:1:"0";s:14:"join_date_from";s:0:"";s:12:"join_date_to";s:0:"";s:30:"membership_start_date_relative";s:1:"0";s:26:"membership_start_date_from";s:0:"";s:24:"membership_start_date_to";s:0:"";s:28:"membership_end_date_relative";s:1:"0";s:24:"membership_end_date_from";s:0:"";s:22:"membership_end_date_to";s:0:"";s:23:"owner_membership_id_min";s:0:"";s:23:"owner_membership_id_max";s:0:"";s:22:"owner_membership_id_op";s:3:"lte";s:25:"owner_membership_id_value";s:0:"";s:6:"tid_op";s:2:"in";s:9:"tid_value";a:0:{}s:6:"sid_op";s:2:"in";s:9:"sid_value";a:0:{}s:17:"street_number_min";s:0:"";s:17:"street_number_max";s:0:"";s:16:"street_number_op";s:3:"lte";s:19:"street_number_value";s:0:"";s:14:"street_name_op";s:3:"has";s:17:"street_name_value";s:0:"";s:15:"postal_code_min";s:0:"";s:15:"postal_code_max";s:0:"";s:14:"postal_code_op";s:3:"lte";s:17:"postal_code_value";s:0:"";s:7:"city_op";s:3:"has";s:10:"city_value";s:0:"";s:12:"county_id_op";s:2:"in";s:15:"county_id_value";a:0:{}s:20:"state_province_id_op";s:2:"in";s:23:"state_province_id_value";a:0:{}s:13:"country_id_op";s:2:"in";s:16:"country_id_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"description";s:35:"Contribution and Membership Details";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:1:"0";s:9:"domain_id";i:1;}');
 774 SET @instanceID:=LAST_INSERT_ID();
 775 INSERT INTO civicrm_navigation
 776     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 777 VALUES
 778     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Contribution and Membership Details', 'Contribution and Membership Details', 'access CiviMember', 'AND', @reportlastID, '1', NULL, @instanceID+2 );
 779 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 780
 781 INSERT INTO `civicrm_report_instance`
 782     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 783 VALUES
 784     ( @domainID, 'Membership Report (Lapsed)', 'member/lapse', 'Provides a list of memberships that lapsed or will lapse before the date you specify.', 'access CiviMember', 'a:16:{s:6:"fields";a:5:{s:9:"sort_name";s:1:"1";s:18:"membership_type_id";s:1:"1";s:19:"membership_end_date";s:1:"1";s:4:"name";s:1:"1";s:10:"country_id";s:1:"1";}s:6:"tid_op";s:2:"in";s:9:"tid_value";a:0:{}s:28:"membership_end_date_relative";s:1:"0";s:24:"membership_end_date_from";s:0:"";s:22:"membership_end_date_to";s:0:"";s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"description";s:85:"Provides a list of memberships that lapsed or will lapse before the date you specify.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:17:"access CiviMember";s:9:"domain_id";i:1;}');
 785 SET @instanceID:=LAST_INSERT_ID();
 786 INSERT INTO civicrm_navigation
 787     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 788 VALUES
 789     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'),    'Membership Report (Lapsed)',         'Membership Report (Lapsed)',       'access CiviMember',        '',  @reportlastID,  '1', NULL, @instanceID+2 );
 790 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 791
 792
 793 INSERT INTO `civicrm_report_instance`
 794     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 795 VALUES
 796     ( @domainID, 'Event Participant Report (List)', 'event/participantListing', 'Provides lists of participants for an event.', 'access CiviEvent', 'a:27:{s:6:"fields";a:4:{s:9:"sort_name";s:1:"1";s:8:"event_id";s:1:"1";s:9:"status_id";s:1:"1";s:7:"role_id";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:8:"email_op";s:3:"has";s:11:"email_value";s:0:"";s:11:"event_id_op";s:2:"in";s:14:"event_id_value";a:0:{}s:6:"sid_op";s:2:"in";s:9:"sid_value";a:0:{}s:6:"rid_op";s:2:"in";s:9:"rid_value";a:0:{}s:34:"participant_register_date_relative";s:1:"0";s:30:"participant_register_date_from";s:0:"";s:28:"participant_register_date_to";s:0:"";s:6:"eid_op";s:2:"in";s:9:"eid_value";a:0:{}s:11:"custom_4_op";s:2:"in";s:14:"custom_4_value";a:0:{}s:16:"blank_column_end";s:0:"";s:11:"description";s:44:"Provides lists of participants for an event.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:16:"access CiviEvent";s:6:"groups";s:0:"";s:7:"options";N;s:9:"domain_id";i:1;}');
 797 SET @instanceID:=LAST_INSERT_ID();
 798 INSERT INTO civicrm_navigation
 799     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 800 VALUES
 801     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'),    'Event Participant Report (List)',    'Event Participant Report (List)',  'access CiviEvent',         '',  @reportlastID,  '1', NULL, @instanceID+2 );
 802 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 803
 804
 805 INSERT INTO `civicrm_report_instance`
 806     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 807 VALUES
 808     ( @domainID, 'Event Income Report (Summary)', 'event/summary', 'Provides an overview of event income. You can include key information such as event ID, registration, attendance, and income generated to help you determine the success of an event.', 'access CiviEvent', 'a:18:{s:6:"fields";a:2:{s:5:"title";s:1:"1";s:13:"event_type_id";s:1:"1";}s:5:"id_op";s:2:"in";s:8:"id_value";a:0:{}s:16:"event_type_id_op";s:2:"in";s:19:"event_type_id_value";a:0:{}s:25:"event_start_date_relative";s:1:"0";s:21:"event_start_date_from";s:0:"";s:19:"event_start_date_to";s:0:"";s:23:"event_end_date_relative";s:1:"0";s:19:"event_end_date_from";s:0:"";s:17:"event_end_date_to";s:0:"";s:11:"description";s:181:"Provides an overview of event income. You can include key information such as event ID, registration, attendance, and income generated to help you determine the success of an event.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:16:"access CiviEvent";s:6:"charts";s:0:"";s:9:"domain_id";i:1;}');
 809 SET @instanceID:=LAST_INSERT_ID();
 810 INSERT INTO civicrm_navigation
 811     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 812 VALUES
 813     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'),    'Event Income Report (Summary)',      'Event Income Report (Summary)',    'access CiviEvent',         '',  @reportlastID,  '1', NULL, @instanceID+2 );
 814 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 815
 816
 817 INSERT INTO `civicrm_report_instance`
 818     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 819 VALUES
 820     ( @domainID, 'Event Income Report (Detail)', 'event/income', 'Helps you to analyze the income generated by an event. The report can include details by participant type, status and payment method.', 'access CiviEvent', 'a:7:{s:5:"id_op";s:2:"in";s:8:"id_value";N;s:11:"description";s:133:"Helps you to analyze the income generated by an event. The report can include details by participant type, status and payment method.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:16:"access CiviEvent";}');
 821 SET @instanceID:=LAST_INSERT_ID();
 822 INSERT INTO civicrm_navigation
 823     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 824 VALUES
 825     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'),    'Event Income Report (Detail)',       'Event Income Report (Detail)',     'access CiviEvent',         '',  @reportlastID,  '1', NULL, @instanceID+2 );
 826 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 827
 828
 829 INSERT INTO `civicrm_report_instance`
 830     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 831 VALUES
 832     ( @domainID, 'Attendee List', 'event/participantListing', 'Provides lists of event attendees.', 'access CiviEvent', 'a:27:{s:6:"fields";a:4:{s:9:"sort_name";s:1:"1";s:8:"event_id";s:1:"1";s:9:"status_id";s:1:"1";s:7:"role_id";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:8:"email_op";s:3:"has";s:11:"email_value";s:0:"";s:11:"event_id_op";s:2:"in";s:14:"event_id_value";a:0:{}s:6:"sid_op";s:2:"in";s:9:"sid_value";a:0:{}s:6:"rid_op";s:2:"in";s:9:"rid_value";a:0:{}s:34:"participant_register_date_relative";s:1:"0";s:30:"participant_register_date_from";s:0:"";s:28:"participant_register_date_to";s:0:"";s:6:"eid_op";s:2:"in";s:9:"eid_value";a:0:{}s:11:"custom_4_op";s:2:"in";s:14:"custom_4_value";a:0:{}s:16:"blank_column_end";s:0:"";s:11:"description";s:44:"Provides lists of participants for an event.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:16:"access CiviEvent";s:6:"groups";s:0:"";s:7:"options";N;s:9:"domain_id";i:1;}');
 833 SET @instanceID:=LAST_INSERT_ID();
 834 INSERT INTO civicrm_navigation
 835     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 836 VALUES
 837     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'),    'Attendee List',                      'Attendee List',                                       'access CiviEvent',         '',  @reportlastID,  '1', NULL, @instanceID+2 );
 838 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 839
 840
 841 INSERT INTO `civicrm_report_instance`
 842     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 843 VALUES
 844     ( @domainID, 'Mail Bounce Report', 'Mailing/bounce', 'Bounce Report for mailings', 'access CiviMail', 'a:33:{s:6:"fields";a:5:{s:2:"id";s:1:"1";s:10:"first_name";s:1:"1";s:9:"last_name";s:1:"1";s:11:"bounce_name";s:1:"1";s:5:"email";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:9:"source_op";s:3:"has";s:12:"source_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:15:"mailing_name_op";s:2:"in";s:18:"mailing_name_value";a:0:{}s:19:"bounce_type_name_op";s:2:"eq";s:22:"bounce_type_name_value";s:0:"";s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"custom_1_op";s:2:"in";s:14:"custom_1_value";a:0:{}s:11:"custom_2_op";s:2:"in";s:14:"custom_2_value";a:0:{}s:17:"custom_3_relative";s:1:"0";s:13:"custom_3_from";s:0:"";s:11:"custom_3_to";s:0:"";s:9:"order_bys";a:1:{i:1;a:1:{s:6:"column";s:1:"-";}}s:11:"description";s:26:"Bounce Report for mailings";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:15:"access CiviMail";s:6:"groups";s:0:"";s:6:"charts";s:0:"";s:9:"domain_id";i:1;}');
 845 SET @instanceID:=LAST_INSERT_ID( );
 846 INSERT INTO civicrm_navigation
 847     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 848 VALUES
 849     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Mail Bounce Report', 'Mail Bounce Report', 'access CiviMail', '',@reportlastID, '1', NULL, @instanceID+2 );
 850 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 851
 852
 853 INSERT INTO `civicrm_report_instance`
 854     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 855 VALUES
 856     ( @domainID, 'Mail Summary Report', 'Mailing/summary','Summary statistics for mailings','access CiviMail','a:25:{s:6:"fields";a:5:{s:4:"name";s:1:"1";s:11:"queue_count";s:1:"1";s:15:"delivered_count";s:1:"1";s:12:"bounce_count";s:1:"1";s:10:"open_count";s:1:"1";}s:15:"is_completed_op";s:2:"eq";s:18:"is_completed_value";s:1:"1";s:15:"mailing_name_op";s:2:"in";s:18:"mailing_name_value";a:0:{}s:9:"status_op";s:3:"has";s:12:"status_value";s:8:"Complete";s:11:"is_test_min";s:0:"";s:11:"is_test_max";s:0:"";s:10:"is_test_op";s:3:"lte";s:13:"is_test_value";s:1:"0";s:19:"start_date_relative";s:9:"this.year";s:15:"start_date_from";s:0:"";s:13:"start_date_to";s:0:"";s:17:"end_date_relative";s:9:"this.year";s:13:"end_date_from";s:0:"";s:11:"end_date_to";s:0:"";s:11:"description";s:31:"Summary statistics for mailings";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:15:"access CiviMail";s:6:"groups";s:0:"";s:6:"charts";s:0:"";s:9:"domain_id";i:1;}');
 857 SET @instanceID:=LAST_INSERT_ID( );
 858 INSERT INTO civicrm_navigation
 859     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 860 VALUES
 861     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Mail Summary Report', 'Mail Summary Report', 'access CiviMail', '',@reportlastID, '1', NULL, @instanceID+2 );
 862 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 863
 864
 865 INSERT INTO `civicrm_report_instance`
 866     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 867 VALUES
 868     ( @domainID, 'Mail Opened Report', 'Mailing/opened', 'Display contacts who opened emails from a mailing', 'access CiviMail', 'a:31:{s:6:"fields";a:5:{s:2:"id";s:1:"1";s:10:"first_name";s:1:"1";s:9:"last_name";s:1:"1";s:12:"mailing_name";s:1:"1";s:5:"email";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:9:"source_op";s:3:"has";s:12:"source_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:15:"mailing_name_op";s:2:"in";s:18:"mailing_name_value";a:0:{}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"custom_1_op";s:2:"in";s:14:"custom_1_value";a:0:{}s:11:"custom_2_op";s:2:"in";s:14:"custom_2_value";a:0:{}s:17:"custom_3_relative";s:1:"0";s:13:"custom_3_from";s:0:"";s:11:"custom_3_to";s:0:"";s:9:"order_bys";a:1:{i:1;a:1:{s:6:"column";s:1:"-";}}s:11:"description";s:49:"Display contacts who opened emails from a mailing";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:15:"access CiviMail";s:6:"groups";s:0:"";s:6:"charts";s:0:"";s:9:"domain_id";i:1;}');
 869 SET @instanceID:=LAST_INSERT_ID( );
 870 INSERT INTO civicrm_navigation
 871     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 872 VALUES
 873     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Mail Opened Report', 'Mail Opened Report', 'access CiviMail', '',@reportlastID, '1', NULL, @instanceID+2 );
 874 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 875
 876
 877 INSERT INTO `civicrm_report_instance`
 878     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 879 VALUES
 880     ( @domainID, 'Mail Clickthrough Report', 'Mailing/clicks', 'Display clicks from each mailing', 'access CiviMail', 'a:31:{s:6:"fields";a:6:{s:2:"id";s:1:"1";s:10:"first_name";s:1:"1";s:9:"last_name";s:1:"1";s:12:"mailing_name";s:1:"1";s:5:"email";s:1:"1";s:3:"url";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:9:"source_op";s:3:"has";s:12:"source_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:15:"mailing_name_op";s:2:"in";s:18:"mailing_name_value";a:0:{}s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:8:"tagid_op";s:2:"in";s:11:"tagid_value";a:0:{}s:11:"custom_1_op";s:2:"in";s:14:"custom_1_value";a:0:{}s:11:"custom_2_op";s:2:"in";s:14:"custom_2_value";a:0:{}s:17:"custom_3_relative";s:1:"0";s:13:"custom_3_from";s:0:"";s:11:"custom_3_to";s:0:"";s:9:"order_bys";a:1:{i:1;a:1:{s:6:"column";s:1:"-";}}s:11:"description";s:32:"Display clicks from each mailing";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:15:"access CiviMail";s:6:"groups";s:0:"";s:6:"charts";s:0:"";s:9:"domain_id";i:1;}');
 881 SET @instanceID:=LAST_INSERT_ID( );
 882 INSERT INTO civicrm_navigation
 883     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 884 VALUES
 885     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Mail Clickthrough Report', 'Mail Clickthrough Report', 'access CiviMail', '',@reportlastID, '1', NULL, @instanceID+2 );
 886 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 887
 888
 889 -- walk list survey report.
 890 INSERT INTO `civicrm_report_instance`
 891     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 892 VALUES
 893     (  @domainID, 'Survey Report (Detail)', 'survey/detail', 'Detailed report for canvassing, phone-banking, walk lists or other surveys.', '', 'a:39:{s:6:"fields";a:2:{s:9:"sort_name";s:1:"1";s:6:"result";s:1:"1";}s:22:"assignee_contact_id_op";s:2:"eq";s:25:"assignee_contact_id_value";s:0:"";s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:17:"street_number_min";s:0:"";s:17:"street_number_max";s:0:"";s:16:"street_number_op";s:3:"lte";s:19:"street_number_value";s:0:"";s:14:"street_name_op";s:3:"has";s:17:"street_name_value";s:0:"";s:15:"postal_code_min";s:0:"";s:15:"postal_code_max";s:0:"";s:14:"postal_code_op";s:3:"lte";s:17:"postal_code_value";s:0:"";s:7:"city_op";s:3:"has";s:10:"city_value";s:0:"";s:20:"state_province_id_op";s:2:"in";s:23:"state_province_id_value";a:0:{}s:13:"country_id_op";s:2:"in";s:16:"country_id_value";a:0:{}s:12:"survey_id_op";s:2:"in";s:15:"survey_id_value";a:0:{}s:12:"status_id_op";s:2:"eq";s:15:"status_id_value";s:1:"1";s:11:"custom_1_op";s:2:"in";s:14:"custom_1_value";a:0:{}s:11:"custom_2_op";s:2:"in";s:14:"custom_2_value";a:0:{}s:17:"custom_3_relative";s:1:"0";s:13:"custom_3_from";s:0:"";s:11:"custom_3_to";s:0:"";s:11:"description";s:75:"Detailed report for canvassing, phone-banking, walk lists or other surveys.";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:1:"0";s:6:"groups";s:0:"";s:9:"domain_id";i:1;}');
 894 SET @instanceID:=LAST_INSERT_ID();
 895 INSERT INTO civicrm_navigation
 896     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 897 VALUES
 898     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID, '&reset=1'), 'Survey Report (Detail)', 'Survey Report (Detail)', 'administer CiviCampaign,manage campaign,interview campaign contacts', 'OR', @reportlastID, '1', NULL, @instanceID+2 );
 899 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 900
 901 -- mailing detail report
 902 INSERT INTO `civicrm_report_instance`
 903     ( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_values`)
 904 VALUES
 905     ( @domainID, 'Mailing Detail Report', 'mailing/detail', 'Provides reporting on Intended and Successful Deliveries, Unsubscribes and Opt-outs, Replies and Forwards.', '', 'a:30:{s:6:"fields";a:6:{s:9:"sort_name";s:1:"1";s:12:"mailing_name";s:1:"1";s:11:"delivery_id";s:1:"1";s:14:"unsubscribe_id";s:1:"1";s:9:"optout_id";s:1:"1";s:5:"email";s:1:"1";}s:12:"sort_name_op";s:3:"has";s:15:"sort_name_value";s:0:"";s:6:"id_min";s:0:"";s:6:"id_max";s:0:"";s:5:"id_op";s:3:"lte";s:8:"id_value";s:0:"";s:13:"mailing_id_op";s:2:"in";s:16:"mailing_id_value";a:0:{}s:18:"delivery_status_op";s:2:"eq";s:21:"delivery_status_value";s:0:"";s:18:"is_unsubscribed_op";s:2:"eq";s:21:"is_unsubscribed_value";s:0:"";s:12:"is_optout_op";s:2:"eq";s:15:"is_optout_value";s:0:"";s:13:"is_replied_op";s:2:"eq";s:16:"is_replied_value";s:0:"";s:15:"is_forwarded_op";s:2:"eq";s:18:"is_forwarded_value";s:0:"";s:6:"gid_op";s:2:"in";s:9:"gid_value";a:0:{}s:9:"order_bys";a:1:{i:1;a:2:{s:6:"column";s:9:"sort_name";s:5:"order";s:3:"ASC";}}s:11:"description";s:21:"Mailing Detail Report";s:13:"email_subject";s:0:"";s:8:"email_to";s:0:"";s:8:"email_cc";s:0:"";s:10:"permission";s:1:"0";s:9:"parent_id";s:0:"";s:6:"groups";s:0:"";s:9:"domain_id";i:1;}');
 906 SET @instanceID:=LAST_INSERT_ID();
 907 INSERT INTO civicrm_navigation
 908     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
 909 VALUES
 910     ( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Mailing Detail Report', 'Mailing Detail Report', 'administer CiviMail', 'OR', @reportlastID, '1', NULL, @instanceID+2 );
 911 UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @instanceID;
 912 UPDATE civicrm_domain SET version = '5.47.alpha1';