"Fossies" - the Fresh Open Source Software Archive  

Source code changes of the file "sql/test_data_second_domain.mysql" between
civicrm-core-5.59.2.tar.gz and civicrm-core-5.59.3.tar.gz

About: CiviCRM is a constituent relationship management system designed to meet the needs of advocacy, non-profit and non-governmental groups.

test_data_second_domain.mysql  (civicrm-core-5.59.2)	:	test_data_second_domain.mysql  (civicrm-core-5.59.3)
skipping to change at line 881		skipping to change at line 881
INSERT INTO `civicrm_report_instance`		INSERT INTO `civicrm_report_instance`
( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_valu es`)		( `domain_id`, `title`, `report_id`, `description`, `permission`, `form_valu es`)
VALUES		VALUES
( @domainID, 'Mailing Detail Report', 'mailing/detail', 'Provides reporting on Intended and Successful Deliveries, Unsubscribes and Opt-outs, Replies and Fo rwards.', '', 'a:30:{s:6:"fields";a:6:{s:9:"sort_name";s:1:"1";s:12:"mailing_nam e";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_v alue";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:1 8:"delivery_status_op";s:2:"eq";s:21:"delivery_status_value";s:0:"";s:18:"is_uns ubscribed_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_rep lied_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:"Mail ing 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;}');		( @domainID, 'Mailing Detail Report', 'mailing/detail', 'Provides reporting on Intended and Successful Deliveries, Unsubscribes and Opt-outs, Replies and Fo rwards.', '', 'a:30:{s:6:"fields";a:6:{s:9:"sort_name";s:1:"1";s:12:"mailing_nam e";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_v alue";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:1 8:"delivery_status_op";s:2:"eq";s:21:"delivery_status_value";s:0:"";s:18:"is_uns ubscribed_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_rep lied_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:"Mail ing 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;}');
SET @instanceID:=LAST_INSERT_ID();		SET @instanceID:=LAST_INSERT_ID();
INSERT INTO civicrm_navigation		INSERT INTO civicrm_navigation
( domain_id, url, label, name, permission, permission_operator, parent_id, i s_active, has_separator, weight )		( domain_id, url, label, name, permission, permission_operator, parent_id, i s_active, has_separator, weight )
VALUES		VALUES
( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Ma iling Detail Report', 'Mailing Detail Report', 'administer CiviMail', 'OR', @rep ortlastID, '1', NULL, @instanceID+2 );		( @domainID, CONCAT('civicrm/report/instance/', @instanceID,'&reset=1'), 'Ma iling Detail Report', 'Mailing Detail Report', 'administer CiviMail', 'OR', @rep ortlastID, '1', NULL, @instanceID+2 );
UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @ instanceID;		UPDATE civicrm_report_instance SET navigation_id = LAST_INSERT_ID() WHERE id = @ instanceID;
UPDATE civicrm_domain SET version = '5.59.2';		UPDATE civicrm_domain SET version = '5.59.3';
End of changes. 1 change blocks.
0 lines changed or deleted		0 lines changed or added

---