[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 4.2.7.mysql.tpl

-- CRM-11354 Fix empty permissions for report instances
UPDATE civicrm_report_instance SET permission = 'access CiviReport'
WHERE report_id = 'survey/detail' and permission = '';

UPDATE civicrm_report_instance SET permission = 'access CiviMail'
WHERE report_id = 'mailing/detail' and permission = '';

UPDATE civicrm_report_instance SET permission = 'access CiviMember'
WHERE report_id = 'member/contributionDetail' and permission = '';

UPDATE civicrm_report_instance SET permission = 'access CiviGrant'
WHERE report_id = 'grant/statistics' and permission = '';

UPDATE civicrm_report_instance SET permission = 'access CiviReport'
WHERE permission = '0' OR permission = '' OR permission IS NULL;
Commit	Line	Data
6a488035 TO	1	-- CRM-11354 Fix empty permissions for report instances
	2	UPDATE civicrm_report_instance SET permission = 'access CiviReport'
	3	WHERE report_id = 'survey/detail' and permission = '';
	4
	5	UPDATE civicrm_report_instance SET permission = 'access CiviMail'
	6	WHERE report_id = 'mailing/detail' and permission = '';
	7
	8	UPDATE civicrm_report_instance SET permission = 'access CiviMember'
	9	WHERE report_id = 'member/contributionDetail' and permission = '';
	10
	11	UPDATE civicrm_report_instance SET permission = 'access CiviGrant'
	12	WHERE report_id = 'grant/statistics' and permission = '';
	13
	14	UPDATE civicrm_report_instance SET permission = 'access CiviReport'
	15	WHERE permission = '0' OR permission = '' OR permission IS NULL;