Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.4.3
-
Fix Version/s: 4.4.4
-
Component/s: None
-
Labels:None
Description
The following diff shows the missing fields (in some cases, just added comments) in an upgraded instance.
— update.report_instance.sql 2013-12-17 13:30:13.000000000 -0500
+++ install.report_instance.sql 2013-12-17 13:33:05.000000000 -0500
@@ -3,9 +3,11 @@
`domain_id` int(10) unsigned NOT NULL COMMENT 'Which Domain is this instance for',
`title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Report Instance Title.',
`report_id` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'FK to civicrm_option_value for the report template',
+ `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'when combined with report_id/template uniquely identifies the instance',
+ `args` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'arguments that are passed in the url when invoking the instance',
`description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Report Instance description.',
`permission` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'permission required to be able to run this instance',
- `grouprole` varchar(1024) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `grouprole` varchar(1024) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'role required to be able to run this instance',
`form_values` text COLLATE utf8_unicode_ci COMMENT 'Submitted form values for this report',
`is_active` tinyint(4) DEFAULT NULL COMMENT 'Is this entry active?',
`email_subject` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Subject of email',
@@ -14,8 +16,8 @@
`header` text COLLATE utf8_unicode_ci COMMENT 'comma-separated list of email addresses to send the report to',
`footer` text COLLATE utf8_unicode_ci COMMENT 'comma-separated list of email addresses to send the report to',
`navigation_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to navigation ID', - `is_reserved` tinyint(4) DEFAULT '0',
`drilldown_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to instance ID drilldown to',
+ `is_reserved` tinyint(4) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `FK_civicrm_report_instance_domain_id` (`domain_id`),
KEY `FK_civicrm_report_instance_navigation_id` (`navigation_id`),
@@ -23,4 +25,4 @@
CONSTRAINT `FK_civicrm_report_instance_domain_id` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`),
CONSTRAINT `FK_civicrm_report_instance_drilldown_id` FOREIGN KEY (`drilldown_id`) REFERENCES `civicrm_report_instance` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_civicrm_report_instance_navigation_id` FOREIGN KEY (`navigation_id`) REFERENCES `civicrm_navigation` (`id`) ON DELETE SET NULL