-
Notifications
You must be signed in to change notification settings - Fork 0
/
2553.sql
149 lines (142 loc) · 53.7 KB
/
2553.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
# 2553.sql
# 1) Added report filters for 'report_columns_for_report'
# 2) Added columns for Created and Modified and report filters for 'actions_for_custom_form'
# 3) Added columns for Created and Modified and report filters for 'actions_for_product'
# 4) Added columns for Created and Modified and report filters for 'membership_rules_for_system'
# 5) Renamed two filters for 'reports' to use isons
# 6) Set version information
SET SQL_SAFE_UPDATES=0;
# 1) Added report filters for 'report_columns_for_report'
DELETE FROM `report_settings` WHERE `reportID` IN (1902651071) AND (`destinationType`='global');
INSERT INTO `report_settings` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`destinationID`,`destinationType`,`reportID`,`report_columns_csv`,`report_filters_csv`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES (143241724,0,0,0,1,0,'global',1902651071,'','1446349119,1180426096,372368978,277730136,818942307',1,'2024-04-14 06:46:21','23.233.80.211',1,'2024-04-14 06:48:25','23.233.80.211');
# 2) Added columns for Created and Modified and report filters for 'actions_for_custom_form'
DELETE FROM `report_columns` WHERE `ID` IN (2117185167,1688471758);
DELETE FROM `report_filter_criteria` WHERE `filterID` IN (SELECT `ID` FROM `report_filter` WHERE `reportID` IN (364098362) AND (`destinationType`='global'));
DELETE FROM `report_filter` WHERE `reportID` IN (364098362) AND (`destinationType`='global');
DELETE FROM `report_settings` WHERE `reportID` IN (364098362) AND (`destinationType`='global');
INSERT INTO `report_columns` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`reportID`,`group_assign_csv`,`seq`,`tab`,`defaultValue`,`fieldType`,`formField`,`formFieldHeight`,`formFieldSpecial`,`formFieldTooltip`,`formFieldUnique`,`formFieldWidth`,`formLabel`,`formSelectorSQLMaster`,`formSelectorSQLMember`,`permCOMMUNITYADMIN`,`permGROUPVIEWER`,`permGROUPEDITOR`,`permMASTERADMIN`,`permPUBLIC`,`permSYSADMIN`,`permSYSAPPROVER`,`permSYSEDITOR`,`permSYSLOGON`,`permSYSMEMBER`,`permUSERADMIN`,`reportField`,`reportFieldSpecial`,`reportFilter`,`reportFilterLabel`,`reportLabel`,`reportSortBy_AZ`,`reportSortBy_a`,`reportSortBy_d`,`required_feature`,`required_feature_invert`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('1688471758','0','0','0','1',364098362,'',101,'','','date','','0','','','0','0','','','','0','0','0','1','0','1','0','0','0','0','0','history_modified_date','','`action`.`history_modified_date`','Date Modified','Date Modified',0,'`action`.`history_modified_date`=\'0000-00-00 00:00:00\',\r\n`action`.`history_modified_date` ASC','`action`.`history_modified_date`=\'0000-00-00 00:00:00\',\r\n`action`.`history_modified_date` DESC','','0','1','2024-04-14 18:08:37','192.168.10.1','1','2024-04-14 18:09:32','192.168.10.1');
INSERT INTO `report_columns` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`reportID`,`group_assign_csv`,`seq`,`tab`,`defaultValue`,`fieldType`,`formField`,`formFieldHeight`,`formFieldSpecial`,`formFieldTooltip`,`formFieldUnique`,`formFieldWidth`,`formLabel`,`formSelectorSQLMaster`,`formSelectorSQLMember`,`permCOMMUNITYADMIN`,`permGROUPVIEWER`,`permGROUPEDITOR`,`permMASTERADMIN`,`permPUBLIC`,`permSYSADMIN`,`permSYSAPPROVER`,`permSYSEDITOR`,`permSYSLOGON`,`permSYSMEMBER`,`permUSERADMIN`,`reportField`,`reportFieldSpecial`,`reportFilter`,`reportFilterLabel`,`reportLabel`,`reportSortBy_AZ`,`reportSortBy_a`,`reportSortBy_d`,`required_feature`,`required_feature_invert`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('2117185167','0','0','0','1',364098362,'',100,'','','date','','0','','','0','0','','','','0','0','0','1','0','1','0','0','0','0','0','history_created_date','','`action`.`history_created_date`','Created Date','Created Date',0,'`action`.`history_created_date` ASC','`action`.`history_created_date` DESC','','0','1','2024-04-14 18:06:58','192.168.10.1','1','2024-04-14 18:09:24','192.168.10.1');
INSERT INTO `report_filter` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`destinationID`,`destinationType`,`label`,`reportID`,`seq`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('870062285','0','0','0','1','0','global','[ICON]14 14 6912 (All Records - Unfiltered View)[/ICON](All)','364098362',0,'1','2024-04-14 18:04:59','192.168.10.1','1','2024-04-14 18:05:05','192.168.10.1');
INSERT INTO `report_filter` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`destinationID`,`destinationType`,`label`,`reportID`,`seq`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('1721495273','0','0','0','1','0','global','[ICON]17 17 6768 Modified Today[/ICON]','364098362',0,'1','2024-04-14 18:12:14','192.168.10.1','1','2024-04-14 18:12:21','192.168.10.1');
INSERT INTO `report_filter` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`destinationID`,`destinationType`,`label`,`reportID`,`seq`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('1820561406','0','0','0','1','0','global','[ICON]17 17 6751 Created Today[/ICON]','364098362',0,'1','2024-04-14 18:11:45','192.168.10.1','1','2024-04-14 18:11:54','192.168.10.1');
INSERT INTO `report_filter_criteria` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`filterID`,`filter_criterion`,`filter_matchmodeID`,`filter_seq`,`filter_value`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('456274229','0','0','0','1','1721495273','1688471758','11',1,'TODAY','1','2024-04-14 18:12:14','192.168.10.1','0','0000-00-00 00:00:00','');
INSERT INTO `report_filter_criteria` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`filterID`,`filter_criterion`,`filter_matchmodeID`,`filter_seq`,`filter_value`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('1472847645','0','0','0','1','870062285','','',1,'','1','2024-04-14 18:04:59','192.168.10.1','0','0000-00-00 00:00:00','');
INSERT INTO `report_filter_criteria` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`filterID`,`filter_criterion`,`filter_matchmodeID`,`filter_seq`,`filter_value`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('1805534595','0','0','0','1','1820561406','2117185167','11',1,'TODAY','1','2024-04-14 18:11:45','192.168.10.1','0','0000-00-00 00:00:00','');
INSERT INTO `report_settings` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`destinationID`,`destinationType`,`reportID`,`report_columns_csv`,`report_filters_csv`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('1387769748','0','0','0','1','0','global','364098362','','870062285,1820561406,1721495273','1','2024-04-14 18:05:05','192.168.10.1','1','2024-04-14 18:12:21','192.168.10.1');
# 3) Added columns for Created and Modified and report filters for 'actions_for_product'
DELETE FROM `report_columns` WHERE `ID` IN (136695730,1850622414);
DELETE FROM `report_filter_criteria` WHERE `filterID` IN (SELECT `ID` FROM `report_filter` WHERE `reportID` IN (1237787286) AND (`destinationType`='global'));
DELETE FROM `report_filter` WHERE `reportID` IN (1237787286) AND (`destinationType`='global');
DELETE FROM `report_settings` WHERE `reportID` IN (1237787286) AND (`destinationType`='global');
INSERT INTO `report_columns` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`reportID`,`group_assign_csv`,`seq`,`tab`,`defaultValue`,`fieldType`,`formField`,`formFieldHeight`,`formFieldSpecial`,`formFieldTooltip`,`formFieldUnique`,`formFieldWidth`,`formLabel`,`formSelectorSQLMaster`,`formSelectorSQLMember`,`permCOMMUNITYADMIN`,`permGROUPVIEWER`,`permGROUPEDITOR`,`permMASTERADMIN`,`permPUBLIC`,`permSYSADMIN`,`permSYSAPPROVER`,`permSYSEDITOR`,`permSYSLOGON`,`permSYSMEMBER`,`permUSERADMIN`,`reportField`,`reportFieldSpecial`,`reportFilter`,`reportFilterLabel`,`reportLabel`,`reportSortBy_AZ`,`reportSortBy_a`,`reportSortBy_d`,`required_feature`,`required_feature_invert`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('136695730','0','0','0','1',1237787286,'',100,'','','date','','0','','','0','0','','','','0','0','0','1','0','1','0','0','0','0','0','history_created_date','','`action`.`history_created_date`','Created Date','Created Date',0,'`action`.`history_created_date` ASC','`action`.`history_created_date` DESC','','0','1','2024-04-14 20:29:02','192.168.10.1','1','2024-04-14 20:29:38','192.168.10.1');
INSERT INTO `report_columns` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`reportID`,`group_assign_csv`,`seq`,`tab`,`defaultValue`,`fieldType`,`formField`,`formFieldHeight`,`formFieldSpecial`,`formFieldTooltip`,`formFieldUnique`,`formFieldWidth`,`formLabel`,`formSelectorSQLMaster`,`formSelectorSQLMember`,`permCOMMUNITYADMIN`,`permGROUPVIEWER`,`permGROUPEDITOR`,`permMASTERADMIN`,`permPUBLIC`,`permSYSADMIN`,`permSYSAPPROVER`,`permSYSEDITOR`,`permSYSLOGON`,`permSYSMEMBER`,`permUSERADMIN`,`reportField`,`reportFieldSpecial`,`reportFilter`,`reportFilterLabel`,`reportLabel`,`reportSortBy_AZ`,`reportSortBy_a`,`reportSortBy_d`,`required_feature`,`required_feature_invert`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('1850622414','0','0','0','1',1237787286,'',101,'','','date','','0','','','0','0','','','','0','0','0','1','0','1','0','0','0','0','0','history_modified_date','','`action`.`history_modified_date`','Date Modified','Date Modified',0,'`action`.`history_modified_date`=\'0000-00-00 00:00:00\',\r\n`action`.`history_modified_date` ASC','`action`.`history_modified_date`=\'0000-00-00 00:00:00\',\r\n`action`.`history_modified_date` DESC','','0','1','2024-04-14 20:29:06','192.168.10.1','1','2024-04-14 20:29:51','192.168.10.1');
INSERT INTO `report_filter` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`destinationID`,`destinationType`,`label`,`reportID`,`seq`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('1210206495','0','0','0','1','0','global','[ICON]17 17 6751 Created Today[/ICON]','1237787286',0,'1','2024-04-14 20:32:58','192.168.10.1','1','2024-04-14 20:33:04','192.168.10.1');
INSERT INTO `report_filter` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`destinationID`,`destinationType`,`label`,`reportID`,`seq`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('1359236124','0','0','0','1','0','global','[ICON]17 17 6768 Modified Today[/ICON]','1237787286',0,'1','2024-04-14 20:33:18','192.168.10.1','1','2024-04-14 20:33:23','192.168.10.1');
INSERT INTO `report_filter` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`destinationID`,`destinationType`,`label`,`reportID`,`seq`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('1512918163','0','0','0','1','0','global','[ICON]14 14 6912 (All Records - Unfiltered View)[/ICON](All)','1237787286',0,'1','2024-04-14 20:32:16','192.168.10.1','1','2024-04-14 20:32:22','192.168.10.1');
INSERT INTO `report_filter_criteria` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`filterID`,`filter_criterion`,`filter_matchmodeID`,`filter_seq`,`filter_value`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('4894253','0','0','0','1','1512918163','','',1,'','1','2024-04-14 20:32:16','192.168.10.1','0','0000-00-00 00:00:00','');
INSERT INTO `report_filter_criteria` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`filterID`,`filter_criterion`,`filter_matchmodeID`,`filter_seq`,`filter_value`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('108331608','0','0','0','1','1359236124','1850622414','11',1,'TODAY','1','2024-04-14 20:33:18','192.168.10.1','0','0000-00-00 00:00:00','');
INSERT INTO `report_filter_criteria` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`filterID`,`filter_criterion`,`filter_matchmodeID`,`filter_seq`,`filter_value`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('1109918449','0','0','0','1','1210206495','136695730','11',1,'TODAY','1','2024-04-14 20:32:58','192.168.10.1','0','0000-00-00 00:00:00','');
INSERT INTO `report_settings` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`destinationID`,`destinationType`,`reportID`,`report_columns_csv`,`report_filters_csv`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('1503719919','0','0','0','1','0','global','1237787286','','1512918163,1210206495,1359236124','1','2024-04-14 20:32:22','192.168.10.1','1','2024-04-14 20:33:23','192.168.10.1');
# 4) Added columns for Created and Modified and report filters for 'membership_rules_for_system'
DELETE FROM `report_columns` WHERE `ID` IN (1647634192,1501971221);
DELETE FROM `report_filter_criteria` WHERE `filterID` IN (SELECT `ID` FROM `report_filter` WHERE `reportID` IN (1320435098) AND (`destinationType`='global'));
DELETE FROM `report_filter` WHERE `reportID` IN (1320435098) AND (`destinationType`='global');
DELETE FROM `report_settings` WHERE `reportID` IN (1320435098) AND (`destinationType`='global');
INSERT INTO `report_columns` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`reportID`,`group_assign_csv`,`seq`,`tab`,`defaultValue`,`fieldType`,`formField`,`formFieldHeight`,`formFieldSpecial`,`formFieldTooltip`,`formFieldUnique`,`formFieldWidth`,`formLabel`,`formSelectorSQLMaster`,`formSelectorSQLMember`,`permCOMMUNITYADMIN`,`permGROUPVIEWER`,`permGROUPEDITOR`,`permMASTERADMIN`,`permPUBLIC`,`permSYSADMIN`,`permSYSAPPROVER`,`permSYSEDITOR`,`permSYSLOGON`,`permSYSMEMBER`,`permUSERADMIN`,`reportField`,`reportFieldSpecial`,`reportFilter`,`reportFilterLabel`,`reportLabel`,`reportSortBy_AZ`,`reportSortBy_a`,`reportSortBy_d`,`required_feature`,`required_feature_invert`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('1501971221','0','0','0','1',1320435098,'',501,'5.','','date','','0','','','0','0','','','','0','0','0','1','0','1','0','0','0','0','0','history_modified_date','','`membership_rule`.`history_modified_date`','Date Modified','Date Modified',0,'`membership_rule`.`history_modified_date`=\'0000-00-00 00:00:00\',\r\n`membership_rule`.`history_modified_date` ASC','`membership_rule`.`history_modified_date`=\'0000-00-00 00:00:00\',\r\n`membership_rule`.`history_modified_date` DESC','','0','1','2024-04-14 20:52:41','192.168.10.1','1','2024-04-14 20:55:12','192.168.10.1');
INSERT INTO `report_columns` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`reportID`,`group_assign_csv`,`seq`,`tab`,`defaultValue`,`fieldType`,`formField`,`formFieldHeight`,`formFieldSpecial`,`formFieldTooltip`,`formFieldUnique`,`formFieldWidth`,`formLabel`,`formSelectorSQLMaster`,`formSelectorSQLMember`,`permCOMMUNITYADMIN`,`permGROUPVIEWER`,`permGROUPEDITOR`,`permMASTERADMIN`,`permPUBLIC`,`permSYSADMIN`,`permSYSAPPROVER`,`permSYSEDITOR`,`permSYSLOGON`,`permSYSMEMBER`,`permUSERADMIN`,`reportField`,`reportFieldSpecial`,`reportFilter`,`reportFilterLabel`,`reportLabel`,`reportSortBy_AZ`,`reportSortBy_a`,`reportSortBy_d`,`required_feature`,`required_feature_invert`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('1647634192','0','0','0','1',1320435098,'',500,'5.','','date','','0','','','0','0','','','','0','0','0','1','0','1','0','0','0','0','0','history_created_date','','`membership_rule`.`history_created_date`','Created Date','Created Date',0,'`membership_rule`.`history_created_date` ASC','`membership_rule`.`history_created_date` DESC','','0','1','2024-04-14 20:52:35','192.168.10.1','1','2024-04-14 20:55:03','192.168.10.1');
INSERT INTO `report_filter` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`destinationID`,`destinationType`,`label`,`reportID`,`seq`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('88952225','0','0','0','1','0','global','[ICON]17 17 6768 Modified Today[/ICON]','1320435098',0,'1','2024-04-14 20:57:24','192.168.10.1','1','2024-04-14 20:57:29','192.168.10.1');
INSERT INTO `report_filter` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`destinationID`,`destinationType`,`label`,`reportID`,`seq`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('1266995311','0','0','0','1','0','global','[ICON]17 17 6751 Created Today[/ICON]','1320435098',0,'1','2024-04-14 20:57:06','192.168.10.1','1','2024-04-14 20:57:11','192.168.10.1');
INSERT INTO `report_filter` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`destinationID`,`destinationType`,`label`,`reportID`,`seq`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('2044857200','0','0','0','1','0','global','[ICON]14 14 6912 (All Records - Unfiltered View)[/ICON](All)','1320435098',0,'1','2024-04-14 20:51:44','192.168.10.1','1','2024-04-14 20:51:50','192.168.10.1');
INSERT INTO `report_filter_criteria` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`filterID`,`filter_criterion`,`filter_matchmodeID`,`filter_seq`,`filter_value`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('270830318','0','0','0','1','2044857200','','',1,'','1','2024-04-14 20:51:44','192.168.10.1','0','0000-00-00 00:00:00','');
INSERT INTO `report_filter_criteria` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`filterID`,`filter_criterion`,`filter_matchmodeID`,`filter_seq`,`filter_value`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('484093149','0','0','0','1','88952225','1501971221','11',1,'TODAY','1','2024-04-14 20:57:24','192.168.10.1','0','0000-00-00 00:00:00','');
INSERT INTO `report_filter_criteria` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`filterID`,`filter_criterion`,`filter_matchmodeID`,`filter_seq`,`filter_value`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('1975063004','0','0','0','1','1266995311','1647634192','11',1,'TODAY','1','2024-04-14 20:57:06','192.168.10.1','0','0000-00-00 00:00:00','');
INSERT INTO `report_settings` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`destinationID`,`destinationType`,`reportID`,`report_columns_csv`,`report_filters_csv`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('662783835','0','0','0','1','0','global','1320435098','','2044857200,1266995311,88952225','1','2024-04-14 20:51:50','192.168.10.1','1','2024-04-14 20:57:29','192.168.10.1');
# 5) Renamed two filters for 'reports' to use isons
DELETE FROM `report_filter` WHERE `ID` IN (244396519, 1160221571);
INSERT INTO `report_filter` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`destinationID`,`destinationType`,`label`,`reportID`,`seq`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('244396519','0','0','0','1','0','global','[ICON]17 17 6768 Modified Today[/ICON] Col','11',5,'1','2007-12-31 14:00:17','','1','2024-04-15 05:31:35','192.168.10.1');
INSERT INTO `report_filter` (`ID`,`archive`,`archiveID`,`deleted`,`systemID`,`destinationID`,`destinationType`,`label`,`reportID`,`seq`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES ('1160221571','0','0','0','1','0','global','[ICON]17 17 6751 Created Today[/ICON] Col','11',4,'1','2007-12-31 13:59:37','','1','2024-04-15 05:31:15','192.168.10.1');
# 6) Set version information
UPDATE `system` SET `system`.`db_version` = '2553';
UPDATE `system` SET `system`.`db_cs_target` = 'ad95509b';
UPDATE `system` SET `system`.`db_detail` =
CONCAT(
'action|f63dddc7, activity|806cffb, address_substitution|d57d1f2, block_layout|add5df35, case_tasks|1ae74ca1, cases|e6686822, category_assign|d1a4d177, colour_scheme|803761b3, comment|f11da527, community|47d34058, community_member|23e88ad8, community_membership|46759446, component|a8bd50e4, content_block|7802d81a, custom_form|7fcba208, ecl_tags|9825cf0b, field_templates|a9554f16, gateway_settings|31d149b1, gateway_type|23e69833, geocode_cache|a95b9cc9, group_assign|b13e761f, ',
'group_members|9b6ebd39, groups|236883b7, keyword_assign|cd5ece7c, keywords|121b3296, language_assign|9bd1ff1b, layout|236d04b4, listdata|2fa5a306, listtype|6beb1ecd, mailidentity|87cb790d, mailqueue|da889bff, mailqueue_item|139f13e7, mailtemplate|9c30c0ca, membership_rule|5f917be4, navbuttons|40eb9edc, navstyle|39819448, navsuite|fc23fffb, order_items|de356bee, orders|1a541b0b, pages|29bf1617, payment_method|af54117, person|f03c9ca9, poll|4db98c36, poll_choice|228daab1, postings|a52fffac, ',
'product|c0371780, product_grouping|1e06e2d5, product_relationship|455009f5, push_product_assign|c57d435d, qb_config|fe8b4b65, qb_connection|17854916, qb_ident|290bea44, qb_import|f13c6bfb, qb_log|19a1ee89, qb_notify|5b8362d, qb_queue|2b848122, qb_recur|5c922f9e, qb_ticket|67da600d, qb_user|a368a00c, registerevent|e717d651, report|1357aef4, report_columns|16ad8b4, report_defaults|f2f698e2, report_filter|c79e6f0, report_filter_criteria|b0c3b14c, report_settings|704601ed, scheduled_task|6b54bb42, ',
'system|3e36921, tax_code|cc3ae69f, tax_regime|bddef4c8, tax_rule|b9c8fd97, tax_zone|67cf2959, theme|280c1e92, widget|2926df7, DB_media.media|cf6ffe97');
UPDATE `system` SET `system`.`classes_cs_target` = 'fe21285a';
UPDATE `system` SET `system`.`classes_detail` =
CONCAT(
'class.action.php|1.0.24|23020|a6f08fd6, class.activity.php|1.0.19|7744|1a17c13d, class.ajax.php|1.0.27|18792|7494877b, class.akismet.php|0.41.f|7970|920d6584, class.array2xml.php|1.0.1|2292|76b4c130, class.article.php|1.0.43|15595|a17b027, class.backup.php|1.1.11|11438|cb917da8, class.bambora_gateway.php|1.0.7|11676|cc947f83, class.barcode.php|1.0.4|5031|eca9ae45, class.base.php|1.0.18|6808|191abeaa, class.base_error.php|1.0.2|651|8fb940e8, class.block_layout.php|1.0.74|37923|c1e87e08, ',
'class.bugtracker.php|1.0.8|11121|5e3f1001, class.captcha.php|1.0.1|5527|99d91fea, class.cart.php|1.0.7|6834|480b230a, class.category.php|1.0.3|3020|4b1dcf78, class.category_assign.php|1.0.5|1346|57230d08, class.cezpdf.php|1.0.2|54973|ef0be272, class.chasepaymentech_gateway.php|1.0.7|12411|98e8b339, class.checkout.php|1.0.46|18739|854172e9, class.ckfinder.php|1.0.6|3818|3d198b83, class.colour_scheme.php|1.0.3|4726|9a71cfb9, class.comment.php|1.0.19|24927|4c1c5efe, ',
'class.community.php|1.0.127|33873|91e8856b, class.community_article.php|1.0.4|869|d33c0cf8, class.community_display.php|1.0.63|113837|9d125589, class.community_event.php|1.0.5|1238|5efacaeb, class.community_member.php|1.0.128|76251|febf2890, class.community_member_article.php|1.0.4|892|77c26278, class.community_member_display.php|1.0.64|73406|603e9012, class.community_member_event.php|1.0.4|2036|e007820a, class.community_member_news_item.php|1.0.4|897|6d90769d, ',
'class.community_member_podcast.php|1.0.4|945|75b1ae85, class.community_member_posting.php|1.0.7|5042|da390d2e, class.community_member_resource.php|1.0.12|8421|e6c3c36a, class.community_member_summary.php|1.0.22|48611|678b35f5, class.community_membership.php|1.0.5|979|ce7e4fe5, class.community_news_item.php|1.0.4|868|92f8e5e, class.community_podcast.php|1.0.4|868|f608146d, class.community_posting.php|1.0.8|7647|ebbc7571, class.community_resource.php|1.0.10|8507|e7c78a73, ',
'class.community_sponsorship_plan.php|1.0.3|923|7cb49d72, class.component.php|1.0.108|1838|50dd744b, class.component_base.php|1.0.24|2822|e335d15f, class.component_community_gallery_album.php|1.0.0|868|eaca91fd, class.component_email_to_friend.php|1.0.0|11087|3ffac8bb, class.component_event_registration.php|1.0.7|17825|99d0ea24, class.component_events_map.php|1.0.6|10030|417266f, class.component_facebook_like.php|1.0.5|2867|dbd31416, class.component_flickr.php|1.0.0|2546|d56be417, ',
'class.component_folder_viewer.php|1.0.0|1496|86a2a83f, class.component_forgotten_password.php|1.0.1|1976|b0cf42f, class.component_form.php|1.0.0|1545|b6150d41, class.component_gallery_album.php|1.0.81|49681|f06570f6, class.component_gallery_album_gallery_image.php|1.0.3|1493|c626f759, class.component_gallery_fader.php|1.0.44|21994|430fcdb8, class.component_gallery_thumbnails.php|1.0.37|27278|491f573f, class.component_gc_weather.php|1.0.0|3618|169d1f1b, ',
'class.component_google_map.php|1.0.0|3418|6d601124, class.component_google_plusone.php|1.0.1|1408|aa58bd45, class.component_group_member_redirector.php|1.0.1|2433|ec0b11a2, class.component_image_fader.php|1.0.2|5135|a5654a7e, class.component_image_gallery.php|1.0.2|3979|c06ff2a0, class.component_image_text.php|1.0.0|2073|fafb7e6f, class.component_importer.php|1.0.2|1084|5fad515f, class.component_jumploader.php|1.0.7|5138|d3457cc0, class.component_language_button.php|1.0.1|2264|2fe3a328, ',
'class.component_member_search.php|1.0.13|30013|f690e66, class.component_order_detail.php|1.0.6|8774|2716b1d0, class.component_password_protect.php|1.0.4|3348|f3a11b0, class.component_paypal_return.php|1.0.1|2778|3bad72af, class.component_persons_listing.php|1.0.2|9070|c364832d, class.component_persons_map.php|1.0.2|5350|ade69cbe, class.component_poll.php|1.0.2|2208|6adce7d1, class.component_poll_archive.php|1.0.2|6877|2a685f9b, class.component_prayer_request.php|1.0.0|2918|ec7d1b95, ',
'class.component_product_dropdown.php|1.0.2|5160|2596d391, class.component_random_news.php|1.0.1|2875|22f34d84, class.component_related_block.php|1.0.4|5695|9a9bef64, class.component_remote_page_content.php|1.0.0|1370|d95e2965, class.component_rss_headlines.php|1.0.2|2163|59810422, class.component_search_date_picker.php|1.0.0|2609|f77806be, class.component_search_tag_cloud.php|1.0.0|1655|294f51a5, class.component_secure_email.php|1.0.0|2785|4ca1ff40, ',
'class.component_share_this.php|1.0.2|4896|adbdf122, class.component_shop.php|1.0.8|4944|12926bb6, class.component_signin.php|1.0.3|4935|d812fbd7, class.component_signup.php|1.0.2|11582|2ecaeb26, class.component_sitemap.php|1.0.4|4648|a5ff9be8, class.component_splash_page.php|1.0.0|1142|e57f991e, class.component_subscribe.php|1.0.1|2906|6138f722, class.component_survey.php|1.0.1|3319|9d020711, class.component_time_tracker.php|1.0.4|12108|66888f42, ',
'class.component_video_player.php|1.0.1|3186|64d49857, class.contact.php|1.0.5|910|68e9b1eb, class.content_block.php|1.0.9|951|2bb73e0f, class.context_menu.php|1.0.79|116442|148c07be, class.country.php|1.0.1|837|39e46aa6, class.cpdf.php|1.0.2|100612|6fd379d3, class.credit_memo.php|1.0.12|9019|c6a026ed, class.crm_case.php|1.0.14|11791|2408a392, class.crm_case_task.php|1.0.2|6044|12e74983, class.cron.php|1.0.11|1211|40735360, class.curl.php|1.0.1|1707|f9de57b2, ',
'class.custom_form.php|1.0.43|77112|bc48d4da, class.custom_registration.php|1.0.3|2300|daef5ff, class.displayable_item.php|1.0.164|91843|9083f98, class.droplib.php|2.1.0.d|53456|ed927455, class.dtd.php|1.0.0|384|a996428f, class.ecc_facebook.php|1.0.0|4565|6f282a51, class.ecl_tag.php|1.0.3|3182|76624a77, class.event.php|1.0.110|76170|da75f6de, class.event_recurrence.php|1.0.12|44204|d06fc64b, class.excel_export.php|1.0.1|14051|1d6a920, class.export.php|1.0.29|1904|ca152539, ',
'class.fck.php|1.0.25|3470|11eced5e, class.fdf.php|1.0.0|1752|62b82016, class.field_template.php|1.0.1|694|417ff657, class.filesystem.php|1.0.19|18706|1c841241, class.font_face.php|1.0.1|930|690325e1, class.gallery_album.php|1.0.36|19688|73bc14ff, class.gallery_image.php|1.0.27|16042|33066591, class.gateway_setting.php|1.0.5|2425|c02bd6b0, class.gateway_type.php|1.0.2|906|3cd3cf44, class.gc_weather.php|1.0.1|4530|ed1f3db7, class.google_map.php|1.0.48|4773|c6032914, ',
'class.group.php|1.0.30|17810|1dd0cbb1, class.group_assign.php|1.0.3|2556|890ed72, class.group_member.php|1.0.5|1255|7c27c8f6, class.group_wizard.php|1.0.14|15904|26beb6e8, class.gwsocket.php|1.0.0|4259|af934122, class.handler.php|1.0.1|834|78583859, class.help.php|1.0.8|7089|6a8ae55, class.history.php|1.0.5|2967|c07e3f8c, class.html.php|1.0.99|71226|f37e3f7, class.html2text.php|1.0.1|18318|217d0b8b, class.http_raw_socket.php|1.0.1|2743|bc5c864d, class.image_factory.php|1.0.10|12710|43335bdb, ',
'class.image_template.php|1.0.2|980|fa8e93a4, class.job_posting.php|1.0.20|6474|51ce59fa, class.jsmin.php|1.0.0|7763|8aa9202b, class.jumploader.php|1.1.1|6875|7ae89e29, class.keyword.php|1.0.11|12646|14a4c320, class.keyword_assign.php|1.0.2|1683|86d9d3cd, class.language.php|1.0.3|4116|5d71387, class.language_assign.php|1.0.1|2487|8974f40c, class.layout.php|1.0.45|44108|fd98a0c9, class.link.php|1.0.7|16868|12943bb5, class.listdata.php|1.0.5|1041|8c3cbbfa, class.listtype.php|1.0.11|7254|3edc23bf, ',
'class.lst_delivery_method.php|1.0.0|362|90060428, class.lst_delivery_status.php|1.0.0|401|7147e852, class.lst_effective_period_unit.php|1.0.0|397|60c1e9da, class.lst_language.php|1.0.0|343|2ba59612, class.lst_named_type.php|1.0.5|2556|37765696, class.lst_note_person_type.php|1.0.0|360|34916ccf, class.lst_payment_status.php|1.0.2|765|cf5b6db3, class.lst_persontitle.php|1.0.0|343|ccf0a81a, class.lst_product_type.php|1.0.0|347|53bcafa0, class.lst_refund_status.php|1.0.0|391|1678668a, ',
'class.mail_queue.php|1.0.46|25894|29e7f9, class.mail_queue_item.php|1.0.16|8254|6bf6c2a8, class.mail_template.php|1.0.13|5039|f445df4f, class.media.php|1.0.3|3387|3830441c, class.media_audioplayer.php|1.0.10|1717|d5994bf9, class.media_youtube.php|1.0.9|1543|5b7b3d1d, class.membership_rule.php|1.0.2|3749|dd7c8104, class.news_item.php|1.0.25|11396|50d2ef10, class.note.php|1.0.3|9406|773e3893, class.notification.php|1.0.4|4976|8c117e0, class.order.php|1.0.73|59058|905d92c9, ',
'class.orderitem.php|1.0.14|4193|2ef9938c, class.orders_overview.php|1.0.1|12377|67bf2cca, class.page.php|1.0.129|42635|31863517, class.page_edit.php|1.0.20|35363|620692dd, class.page_vars.php|1.0.27|23531|7a97722a, class.password.php|1.0.0|2362|66a7578e, class.payment_method.php|1.0.12|12751|f7064f6d, class.paypal_gateway.php|1.0.27|23336|8c5069aa, class.pdf.php|1.0.2|450|b03ab3a1, class.person.php|1.0.133|102100|3d9ae7f9, class.person_merge_profiles.php|1.0.5|22039|77d722ae, ',
'class.phpmailer.php|2.0.2|139547|2ec999d2, class.phpop3.php|1.0.4|5746|608ee4c2, class.piwik.php|1.0.7|12521|ba077817, class.podcast.php|1.0.48|26094|525316fd, class.podcast_album.php|1.0.17|14791|dd665209, class.poll.php|1.0.12|11564|6ac261dc, class.poll_choice.php|1.0.4|1072|c918aab3, class.portal.php|1.0.43|19101|e5ea2aed, class.posting.php|1.0.133|70601|f2e854d5, class.posting_contained.php|1.0.246|14564|92a23530, class.posting_container.php|1.0.7|5036|5525dc30, ',
'class.prayer_request.php|1.0.0|516|7c065020, class.product.php|1.0.86|64786|2f728098, class.product_catalogue.php|1.0.34|26243|545d73bd, class.product_catalogue_checkout.php|1.0.5|5601|38b354ad, class.product_catalogue_credit_memo.php|1.0.2|3809|4dde8ab1, class.product_catalogue_order_history.php|1.0.5|8132|648225a9, class.product_catalogue_shop.php|1.0.6|4975|825adfc5, class.product_grouping.php|1.0.8|2784|d11c50cf, class.product_grouping_column.php|1.0.1|2354|d009a62d, ',
'class.product_relationship.php|1.0.5|7749|40d5281e, class.push_product.php|1.0.1|2253|7ce2a7d9, class.push_product_assign.php|1.0.1|1295|91df8dcd, class.qrcode.php|1.0.0|25872|9552549b, class.quickbooks.php|1.0.31|47671|adf6bf32, class.record.php|1.0.107|89952|4a0afd46, class.refunditem.php|1.0.1|436|541168c3, class.register_event.php|1.0.23|14128|3ded3e43, class.remote.php|1.0.14|4969|16557366, class.report.php|1.0.96|64283|833fdd8f, class.report_column.php|1.0.148|38621|d4011762, ',
'class.report_column_download_pdf.php|1.0.2|6013|a8e3ea4c, class.report_column_form_field.php|1.0.0|140505|1f973873, class.report_column_report_field.php|1.0.34|46784|c89ecb70, class.report_column_type.php|1.0.0|664|a52ba350, class.report_config.php|1.0.9|23531|811b76c, class.report_defaults.php|1.0.3|1841|7fca07da, class.report_filter.php|1.0.17|14869|c728434f, class.report_filter_criteria.php|1.0.2|605|84f1a66e, class.report_form.php|1.0.69|53499|7124b33a, ',
'class.report_form_field_lookup.php|1.0.3|8356|aaa48c7f, class.report_report.php|1.0.39|86198|1f1d2d90, class.report_settings.php|1.0.5|4097|b42169f2, class.rss.php|1.0.32|39446|914ea1a6, class.rss_help.php|1.0.0|364|5477dd87, class.rss_proxy.php|1.0.3|2566|44b6751d, class.scheduled_task.php|1.0.5|4923|222bce17, class.search.php|1.0.14|26229|b95252f4, class.services_json.php|1.0.3|34212|c544bc8c, class.shipping.php|1.0.6|5454|e1856dbc, class.smtp.php|2.0.1|40105|c2a5250a, ',
'class.snoopy.php|1.2.4|38033|3da7574a, class.socketwriteread.php|1.0.0|2779|ce3717a6, class.sponsorship_plan.php|1.0.4|1789|e0b40d3c, class.state_province.php|1.0.5|655|a06da31a, class.survey.php|1.0.19|9740|5edbd85c, class.survey_block.php|1.0.5|5735|4ff3b4d2, class.survey_response.php|1.0.1|685|355c5596, class.system.php|1.0.199|64956|c339146a, class.system_copy.php|1.0.13|32361|60df9caf, class.system_edit.php|1.0.41|65438|560bfbaa, class.system_export.php|1.0.21|18756|c742681a, ',
'class.system_health.php|1.0.52|74724|9b67a1d, class.table.php|1.0.7|2742|26d4476d, class.tax_code.php|1.0.1|1319|557edda, class.tax_regime.php|1.0.16|7395|30a45da5, class.tax_rule.php|1.0.1|797|9f60a7a9, class.tax_zone.php|1.0.5|3337|77733990, class.theme.php|1.0.9|6750|1cef11b5, class.transformer.php|1.0.5|4532|d805fe7c, class.uploader.php|1.0.7|6068|68cb1cf7, class.user.php|1.0.9|7871|a1de280b, class.widget.php|1.0.9|27502|27582a66, class.xml2array.php|1.0.1|1730|18dcc68c, ',
'class.xml_sitemap.php|1.0.6|4874|fc029a8f, communitylisting.php|1.0.2|3001|7d2f4e0c, communitymemberlisting.php|1.0.1|3231|1d5871b4, communitymemberstats.php|1.0.0|3389|25ce535f, component/activitytabber.php|1.0.8|9218|529ed080, component/adminpersonlookup.php|1.0.6|4897|de37ee56, component/articlesrotator.php|1.0.13|15773|bef79f53, component/base.php|1.0.8|19665|a24f31b1, component/biblelinks.php|1.0.4|2534|13dbfdc5, component/breadcrumbs.php|1.0.7|4475|d00e3189, ',
'component/calendarlarge.php|1.0.31|23608|bdcf0a0d, component/calendarsmall.php|1.0.6|5526|c3894668, component/calendaryearly.php|1.0.3|8110|af90b37f, component/categorystacker.php|1.0.6|10243|8a8b1a46, component/categorytabber.php|1.0.9|13086|f9f445f2, component/changepassword.php|1.0.3|5552|3a8a8d3f, component/collectionviewer.php|1.0.59|61381|ba6dc2d9, component/combotabber.php|1.0.13|15802|f1618cc4, component/communitiesdisplay.php|1.0.11|8074|e1f653e5, ',
'component/communitycalendar.php|1.0.4|994|c60783a5, component/communitycollectionviewer.php|1.0.2|474|d7b5d693, component/communitymembercalendar.php|1.0.4|1210|4eb5b20e, component/contentblock.php|1.0.3|4936|a4211712, component/contentgroupmembermirror.php|1.0.6|2382|331e568d, component/contentsigninmirror.php|1.0.4|1661|8bfc480f, component/customform.php|1.0.6|8052|cf8df093, component/customiserbutton.php|1.0.5|4053|bf182b7d, component/dailybibleverse.php|1.0.2|2136|b7ecf29, ',
'component/documentcovers.php|1.0.2|4320|c2e431eb, component/documentreader.php|1.0.3|3358|d3abb1f, component/edityourprofile.php|1.0.2|3968|a50e25cc, component/emailform.php|1.0.3|7789|f1890768, component/emailnewslettersignup.php|1.0.4|13416|53ed23f7, component/emailoptin.php|1.0.2|4438|f3197c56, component/emailoptout.php|1.0.2|4479|6f7dd37c, component/emailunsubscribe.php|1.0.3|6468|70445a30, component/iconbookmark.php|1.0.2|2231|99aa440c, component/iconprintfriendly.php|1.0.2|1987|8ab1ee6a, ',
'component/iconsitemap.php|1.0.3|1992|d23d48f5, component/iconsocial.php|1.0.6|3650|4b33c6cf, component/icontextsizer.php|1.0.2|2752|dc9c9c60, component/inlinesignin.php|1.0.4|7094|5f87b3f7, component/latestyoutube.php|1.0.3|3783|5e34265a, component/navlinks.php|1.0.3|1979|54769563, component/prevnext.php|1.0.3|6752|817633c3, component/rssdisplayer.php|1.0.3|4264|619d6f6e, component/searchcategorylist.php|1.0.3|5986|e1cd3e81, component/searchwordcloud.php|1.0.5|9555|e13d9b74, ',
'component/twitter.php|1.0.1|2796|28865b6c, component/wowslider.php|1.0.17|22967|74e14e31, emailbouncechecker.php|1.0.5|7458|b0555dca, httperror.php|1.0.0|1845|1c7d9f80, lst_scrubber_data.php|1.0.0|982|b0a3dd47, mailbroadcastform.php|1.0.0|10437|ad4a2cf9, mailidentity.php|1.0.8|2716|24dd2e06, map/addresssubstitution.php|1.0.2|1306|4dccbc67, map/geocodecache.php|1.0.6|3412|a2983981, map/googlemap.php|1.0.5|32849|6a989957, matthiasmullie/minify/css.php|1.0.0|18204|58f1b374, ',
'matthiasmullie/minify/js.php|1.0.0|33065|435fe068, matthiasmullie/minify/minify.php|1.0.0|12435|c2626985, matthiasmullie/pathconverter/converter.php|1.0.0|5053|90533c43, nav/button.php|1.0.22|17035|cc8e96a9, nav/buttonimage.php|1.0.10|43384|d8c4bdad, nav/drawnav.php|1.0.10|15783|3bb986ff, nav/style.php|1.0.16|4752|604e952e, nav/suite.php|1.0.44|25469|19081dc, output.php|1.0.4|4240|e73d74de, pagedraw.php|1.0.2|28035|73c350e3, phpmailerexception.php|2.0.1|666|c53dc0ba, ',
'piiscrubber.php|1.0.0|6530|b9b08858, robotstxt.php|1.0.0|2597|19d39a26, searchhandler.php|1.0.0|10122|15963cc7, ticket.php|1.0.0|1927|7f35831c');
UPDATE `system` SET `system`.`libraries_cs_target` = 'be056f2d';
UPDATE `system` SET `system`.`libraries_detail` =
CONCAT(
'/codebase.php|5.8.10|, /db_connect.php|1.0.4|9d573197, /functions.php|1.0.22|813cdc31, /img.php|2.2.1|bd8e1d8d, /fedex/rate.php|1.0.6|f776de9a, /getid3/getid3.php|1.8.3b|4905aad0, /images/icons.gif||460db971, /images/icons-big.gif||c279ad3a, /images/labels.gif||646c2256, /js/ajaxupload.min.js|1.0.2|2b412eb, /js/ckeditor/ckeditor.js|// 4.5.3|374f2caf, /js/ckeditor/config.js|1.0.23|f838a546, /js/ckeditor/plugins/audio/plugin.js|1.0.4|2741ed91, /js/ckeditor/plugins/ecl/plugin.js|1.0.10|7a3004c8, ',
'/js/ckeditor/plugins/more/plugin.js|1.0.4|f2b6d5fe, /js/ckeditor/plugins/video/plugin.js|1.0.4|e4fbc59, /js/ckeditor/plugins/youtube/plugin.js|1.0.4|6198442f, /js/ckeditor/plugins/zonebreak/plugin.js|1.0.3|d499229d, /js/ecc.js|1.0.9|e48831a4, /js/functions.js|1.1.275|e1f10992, /js/member.js|1.0.154a4|4376118b, /js/jdplayer/mediaelement-and-player.min.js|2.13.1.c|4b4ede46, /js/jquery.min.js|1.11.0b|3f7a8cb1, /js/jquery-ui.min.js|1.10.4c|918dce94, /js/rss_reader.js|1.0.2|6d8fd7f3, ',
'/js/spectrum.min.js|1.2.0.b|62a09b61, /js/treeview.js|4.3.e|599ade11, /style/breadcrumbs.css|1.0.3|5449aa5f, /style/default.css|1.0.174|f3c92889, /style/community.css|1.0.8|29c13747, /style/labels.css|1.0.51|a344b4a1, /style/spectrum.min.css|1.2.0.c|481a359a, /style/pie.htc|1.0.0.b|7b7e50a2, /www/js/ckfinder/ckfinder.html|1.4.2.b|e15ec915, /www/js/ckfinder/config.php|1.4.2.G|f7a67103');
UPDATE `system` SET `system`.`reports_cs_target` = 'ff3f0823';
UPDATE `system` SET `system`.`reports_detail` =
CONCAT(
'actions_for_custom_form|364098362|42173a2c||6bc3a1fc|730e2d53|244a90fd|d67b9373|1132ae71, actions_for_product|1237787286|114de3e4|5aadcccf|879b21ab|1294b36|408b1624|249ae0d9|45cca669, actions_for_report|1155849835|a4704377|2acf4b9c|a71a499e|2d9fcbb8|91fea0b9|e31081a6|9df8e, address-substitutions|1788081331|b072d7b||e015d45|a7ddd779|1a1221bb|85d3197d|c8d259bb, admin_groups|1452624876|db4e7e56||||||ca1016c5, admin_manage_refunds|1961884056|a9c102e0||||||b5a228fd, ',
'articles|1156338204|ce843c77|bdae47c3|f326c780|a318d4cd|5eba3251|cddfddfb|44cb298a, block_layout|531875437|b3e00c24||c9cbb445|e844e3e5|f1e7eb7|daec4d0|f2c186, cases|1692352206|bb6e23e3|ed9dca9f|22da5767|32638573|fbdc53fb|95fd7eb|e2e48974, comments|1985320706|b382d30a|5a78a4af|958ebf39|7139c7a9|3c07260a|43c9e416|b8f87a72, comments_hidden|156656266|d357a0dd|3d73b18c|2eb975a||||5b780255, comments_pending|726654655|5fc552ea|c3bcaee6|74f0dbdb||||7a174892, ',
'comments_spam|1685148626|e176b404|ab282e59|52ae3610||||b80684e8, comment_changes|888081516|715cb4a3||2cb9cba2||||e61ef927, community|1899073055|ced7a9c9|fd688f0b|9c7c3e0f|8638e08b|55b7f654|4399ea17|589239ab, community.articles|93810097|c0cd7ef9|5556eb5a|3d204cb3|d0883ad0|23aa71af|37f64c0d|f849a219, community.events|1304217624|5ec88da3|9e5054a9|8836dab|bf6c1d83|2bc19b2a|827f80a3|caeba9e3, community.gallery-albums|522993388|d6ef516d|b922e68|cbfd7f29|c4ba32a3|2ed87c09|fb44cc62|ff7b1d0e, ',
'community.gallery-images|86967210|3845d8c1|f601a420|6fd93b39|17dcad9e|e5d0886e|ab9a41a4|5f0e8db4, community.membership|1357442628|d298b273||8f8819ab|4aa25543|9bac1518|6332c2c4|1e766c70, community.news-items|2036787717|cbbe80a2|2602c2ff|44e0bdaf|8f0395ee|ea12a5e2|da36de66|8a8d6e0, community.podcast-albums|887489900|65a3955b|5bc9341e|882172ff|8109803b|b4ee23b4|e489fd31|3646836e, community.podcasts|413070900|2d7beb48|9d927f8|aee9350d|9f20647b|1cfb08b1|8ff4bcfa|dfff93c8, ',
'community.sponsorship-plans|2002167964|493f0cb9|48460222|257eb42e|2b5d6801|76dd5235|3ef291be|20b77f6a, community_member|1902153511|bb81eee5|7e6439fc|3ad97bd5|966359b4|3b00d200|83594c86|e02504da, community_member.admins|59838467|d7c9d366|7e0aa25|d4feed27|5510c836|babc0c77|a3607fae|fe024555, community_member.articles|1897057515|645b7e39|e0fd409e|1e323f75|6a64eda3|161358ba|185afc45|742649af, community_member.contacts|546881527|c141089a|f8f8d972|e8818b74|8ddcd7c2|8cfd2384|b6af00db|8e4b0e79, ',
'community_member.dashboard.articles|100581518|f9009c4f|8c088bbb|4c9714e1||||f8467cc8, community_member.dashboard.events|778661710|821f786|7056653f|3a8bc352||||e40e731f, community_member.dashboard.news-items|307302786|16edb422|4679983d|698e19fc||||e0211ee5, community_member.dashboard.podcasts|1958649010|cc016a85|2b78bde2|2c80f95a||||7de5a215, community_member.emails|1007955862|3a6a952a||65e2da75|6a1da247|9673386f|8718c8fe|8a694728, ',
'community_member.events|1653494123|d5ca5a8f|ff5a4510|4f15d11d|9666ae76|478cc7c0|c2e0abf6|8a5d0f8b, community_member.event_recurrences|921385375|4fbca19a|62afa26e|6fac24b4|6e3b9ff7|d566ec87|e23978a8|3ca5222c, community_member.gallery-albums|155055207|3400f1e8|d86ebc74|5354fa81|9b8d39fc|aeee5ff8|1ec1b3d|a93db74d, community_member.gallery-images|2018430577|7268e9c6|53181aaf|11f5665a|8e420d83|a72182be|d243fa8a|fc59f1eb, ',
'community_member.membership|1894826559|2efeefc1||aae07868|ae1dcadb|a769ba50|8b33bd45|f081cb59, community_member.news-items|1641961006|10b5687|2bfe6ddf|73821501|14ec7461|b23e95f8|5b3dd8d8|8c07ecec, community_member.podcasts|997844663|a0b4e2fb|3131b1ff|5d405bdb|77e1fbf8|b844b7c9|16ea1e83|c8d4a0d, community_member.podcast_albums|2033952651|32268213|3f7136b0|43501dc3|a4c9d333|6ac581df|86640c41|1ee3e948, community_member.signup|966413259|80ff28f4||4cd08e70|8a138212|43385238|38c550f7|a8f3b81d, ',
'component|18|2700fe3c||b326fa9c|801edfde|b7a3ad6f|63ef475f|ac5d3a4d, contact|455348469|65b6b21c|d41f24a4|fe66ec8c|d67e4b1e|8ffb3e47|8204d9f0|1fb18966, Contact Lookup|1637270565|5a8e3307||9f547eea||||5eac2e53, content_block|520026104|ab8fcb70||ff82c311|e6e56a49|8f7e822f|489ff96f|f2fa3482, credit_memo_change_history|2098763691|6ee49fff||2533ebda||||73fb6167, credit_memo_status|1476582498|3f93eb4||c5c53b4d||||3e37aae, ',
'custom-registration|1554477889|7d31f613||c9253bc3|76571384|8760289d|205661d7|f061f850, custom_forms|2008354714|549bf021||654676f9|98c5e745|9802c6a9|6f43020a|d72ee6ee, dashboard_persons_pending|192989725|4df4d69b||181caf4c||||e84bb50a, db_export|35|ebb261e8||||||38d24ae, ecl_tags|436943101|5a34b106||7791396d|66bbd6c5|5972d1f8|7a14ddc3|848c9f54, ecommerce_options|933478782|b1c1cbbb||||||947c2bca, email_wizard|1762340055|718109a1||||||2327072f, ',
'events|1|b779eba5|f808f2cb|b9382d23|9e45d149|6b7a34b3|9d8afe94|900b73c4, event_recurrences|775190392|79acd96a|9a0762e7|f8bcae31|e697cd7b|c1ff1ed5|a35f6d53|52fe78c7, event_registrants|33|1b448c61||c8056634|8d98ee4f|c8235c49|512aedb5|c663566, field_templates|653541528|e7ee46d4||918b8981|90ff51ee|4d8c8575|80669166|2860f317, gallery-albums|643449733|c1721585|c387d8e1|9d5dfefb|64cb9935|e89f054c|e5e2b927|3001adf6, ',
'gallery-albums-for-gallery-album|1974205589|50e70211|ca949b6f|6c823861|135f011|9fa6b279|ba38b2a1|bad73abb, gallery-images|735315841|44aedff9|dd9ff45a|1a174935|2f4b62f1|4d01f2f2|87c89eff|fb2bb430, gallery-images-for-gallery-album|157378518|aa3767bd|f5614a7d|bc6478a|fe8a53ab|1642fced|7c19cc41|198a2164, gateway_settings_bambora|2100956420|a2efadd1||5e91af33|e4d9f2c2|99f0e114|2e6a2b1|beb1ceb, gateway_settings_chasepaymentech|1256012063|45cf42c3||417a82b5|d0471838|2db96dc6|39fced50|369294e9, ',
'gateway_settings_paypal|1697487502|8836c53d||2f39518|cc197f37|da1a4cca|5dac6c03|75bb98bd, gateway_type|1692645997|a87286d0||6bbd70f8|2e03413|48151fbb|607a010e|27a75e20, geocode-cache|655193664|33e50add|bcfb6a54|9d74aca3|f63c040f|91964c95|22543c3c|dff746a0, groups|794898891|9549a9e9||9c8b14d9|51379787|d1d33344|acced74f|96502564, group_members|2016217854|f6cd3140||d96c012b|164361f7|7b8bf7db|a566cc97|6e1036c9, image_template|149372726|d00b2d95||c00624c9|6760c180|49995c41|5c200f52|27587e90, ',
'job-postings|905005130|ab3b59dd|a04c13cc|5195b4f6|87ac688d|916a6a76|661bd6f1|b4038af9, keywords|1950810505|7b0cf843||d22b9849|c680e791|f212c7fc|e145e36b|4aaac7d6, layouts|19|ba856cae||4f4e009e|d656b1e6|a37056a4|296b8eb3|9662d0a3, links|624031849|adf12483|1681be13|9ae03770|a83bd828|650af760|f593e89e|79cfe39d, links-for-link|1162752923|8541cb00|79e8ac48|4c7c0e0a|de386b71|2c2f374e|1f3acf|f422d9df, listdata|24|dea53221||8a340e84|e82bb0a7|accf4bd1|60986601|4482f4e9, ',
'listdata_for_listtype|236636335|f4c96a32||78690420|32b45f24|5a81932|b2d2e683|d721012e, listtype|21|c9c161b1||568a7f00|dac24962|4eafc3d|851cc91e|cd36dbfd, listtype_icon|101266328|8d55d8c5||||||8dea51a0, lst_column_types|13|2ad82610||8f363fa7|7920a796|3e5a5f8f|d6582fe4|9f599465, lst_country|2|dcd171fc||82d00471|724b2c90|444e15a|92a3c005|b4fb020e, lst_delivery_method|37939353|25df03a5||c0bfc6fe|cc6d4921|f048119e|a90a4c3c|4a378a86, ',
'lst_delivery_status|418462548|c3d17aa5||5c345c47|da2763c0|b5c264d|c912f5d|ffddfc78, lst_effective_period_units|1208253402|5c9ec4cf||834f5b02|e8e203c5|eeda2442|bca1ae8e|8924c310, lst_font_face|23|77147cf4||f68d2e7a|839b2fe3|a8abace1|1dcf752a|575d7d1c, lst_language|46236542|7dfa98fb||30abdd8a|62d61cae|8ac11d3a|d77f25b0|a2d6167d, lst_payment_status|714505724|1b50dde0||40d5a568|94d03992|64951857|9fe45472|1a70b5b2, lst_persontitle|4|20777c8b||811b5ad5|462b2873|8c6c60b2|4595b7aa|7037fa7d, ',
'lst_product_grouping_columns|698451747|5d77996||24731e08|e58da73e|db63efa5|a146a120|cb16504d, lst_product_type|745648469|fd46a152||c93d2c3f|fa07b055|d11ccfd2|e30209bc|95545165, lst_refund_status|1216572200|7c0eb267||8a265be1|34c82d0a|c74c8c2d|f248f9a8|73853f2e, lst_scrubber_data|335019973|1380ea70||6e9378be|de2235d3|33acd3a9|7ad88498|b514912d, lst_sp|5|eac6084f||e01a6613|f5e49c3a|9e2aa83f|e9653724|970f8759, mailidentity|126779465|9ecc5e5b||cc88226d|a7893236|42b71ca0|4f76e295|cbf9c667, ',
'mail_broadcast|255|193726e3||||||e5a0e63d, mail_queue|2138721438|fa7d9e44||4791e66c|6d2954de|ff0797ac|e0ddb49b|66383ecc, mail_queue_items|553239922|4a13eeca||30bcef83|e266e780|2360617c|657e6677|14abc8c4, mail_templates|38|e3ec4c8c|e5dfd3e6|989c585f|38aaa75|df20defe|95281a5d|21bce762, manage_credit_memos|10208891|311420a3||dc89ac4f|4445b355|8d468351|769722cc|8ffd9f3d, manage_orders|411402082|56e84c64|63c6b14|62877845|23970647|e6c298ea|cbccf8e7|316af867, ',
'manage_refunds|1681469982|bcbc1cbc||2b3f5942|25a7eaed|ec25091b|3b9cf173|2eb107d7, media_for_person|778735493|7eab02cc||ccceddea||||f48e21fb, membership-list|24752744|21a69c93||7419e64b|15d4e0de|e47325e8|bc5f3773|c8f773dc, membership_rules_for_system|1320435098|5b8e4a12||64230cfe|b1cbf4d|b83c790d|1a765059|ad11acb7, metadata|135519260|8870e53||9ba6c6f9||||6f9af7f1, my_registered_events|27|581c45e||ecdafef7|edb7bf06|7ba0688b|cdbbf4e5|4c6499d8, ',
'my_registration_list_for_event|32|be9f807a||273936a7||||db16c031, navbuttons|14|7a413819|df4e26ed|e0b3ceca|2f1dcd6d|b501fe97|db929502|798f178e, navbuttons_for_navsuite|387825988|6b3d151c|ae262fee|280cf3c4|41ae1748|bdd145af|3530ef3|7972e6c4, navstyle|1735323904|fd387335|9488a262|65cad30d|5e9c06c3|bc7753a|b137296c|9c3d726e, navsuite|15|1845d43d|16c02437|22356e15|8b328469|1d216921|8473abdf|533dc8a5, news-items|1392271173|be03d8a2|b2c3ef2e|5a87d59d|9b24c683|da3f264c|eb3e4c35|2fe9c76, ',
'order_billing|79997869|cf9a2d92||d451941b||||64ada9cd, order_change_history|996754020|2d1c490c||1402edbf||||fd43efc7, order_gateway_result|651333054|8af547b2||7c84e02a||||d95133da, order_shipping|848619315|7612fca9||e584ad2||||9b9b8335, order_status|593231666|65dd2d5||770027ce||||553676fc, pages|10|c429d17e|367f9a6a|1b358dd1|d57536|ee6c84b|3a6ad60f|2c81493e, payment_method|869930013|8fb16920||59aec872|ac602fe4|990469b1|cbc3fc46|cb5698d8, ',
'persons_pending|12|ff2fa5ec||469d67ed|cb105e3e|3418155e|1c2ceb38|e78aaa82, person_emails|676174365|f1b044a7||62dc7a60|a2a6eaaa|e7816285|1ff5a90f|ce7d75c7, person_groups|1159004324|3c96dba2|aa8c9176|2a363d4a|bd71ba72|f8212ecd|d3c67c62|e7c4ddaa, person_notes|1649793430|4159991f||b02b9376|5802d3b9|54865470|ea50a9d1|9a1aef97, person_orders|1855304946|8439bbf||68f76414|8d3d097b|ac41f50e|6033cdbe|c116eb94, person_view_for_order_1|702938128|62fea7e0||780c1827||||5091b496, ',
'person_view_for_order_2|377863590|b391ddbb||f20cb65d||||bfbf82ff, podcast-albums|742378424|c99dab6a|c6345fe0|5bf1939b|28231d01|1eab5b3b|f81912c4|898b8825, podcast-albums-for-podcast-album|1271328360|468d9539|451b8663|e66b9718|f150c5a0|6a1c66c3|a7233dd8|e0c0deeb, podcasts|2116829793|26216c5f|c1b0cf61|2b71e63e|7351d9d6|5cffef55|d42c0ea3|4dc53684, podcasts-for-podcast-album|56401861|4a657eae|a0eb81b4|1c9cd409|8fba570e|250198f4|763ee41b|bc3abc97, ',
'poll|2005713144|dc311bfc||bc39b03f|a8e6bc57|8f33c687|75f2c825|1b0d21d8, poll_choice|1277341866|659e3d50||71ba9daa|5228e708|aa2b3bf2|2ee47c41|7fd50f6e, product|458194221|6e75b346||f0980e8c|9665ecc4|b21558e8|e2fcff33|c158c00d, product-relationships-for-gallery-album|1879544356|e5321b23||5e7f9d80|48bbcbd2|746284cc|a0564a55|105af71d, product-relationships-for-gallery-image|497515852|b4a1873||c4b05768|4ae98757|9478b41f|976075da|3420376c, ',
'products_for_event|47618369|2e9bd1ef|c6a3b248|26d88cf6|a85cd518|278abd33|df0e065f|157b29db, products_for_product_grouping|1913031016|f02faeb9||d849606e|a3b50751|c63c5c59|968f484a|ab90472, products_overview|532951207|a29907fa||e3df23fc|b16c5728|3f48cfa5|eb4fa7c0|8c9f1dfe, product_grouping|372915493|4f45b0da||d2af72eb|bab26f90|e2414b1d|631ec16d|d09935b2, registered_events|28|87c4ebad||3f72404|9683d864|58f3b20d|779497d6|2e2d6fa1, ',
'relationships_for_product|731150601|e33948a5||ec70162e|796b32e1|8f22af51|25124eef|e6bf8e66, report|11|87ef6e1c||ce3a33aa|866629dc|6a1835b1|3917d306|2d9fa931, report_columns|7|4e8a72a5||f2ef4481|15a2fa25|a024115d|5f83b1b9|763ab495, report_columns_for_report|1902651071|515f3dd1||80ff28|6748942|8ca95b4d|ec56223c|3ca3fab, scheduler|194710800|18cba00||d745e0f1|c3c8c890|9994edbe|c058de30|a784fa4a, shop_manage_orders|95595756|b3d463dc||||||be907a6c, ',
'shop_orders_overview|1728073570|1cff87a6||||||91d5f7e0, signup|26|852c1063||8d465a93||||d8a93258, site_icon|647162652|ec66e7c||||||db62a6ad, sponsors-for-sponsorship-plan|1247696435|55fdb248|511a0631|2d94a43c|59603903|6aa61435|4d3b7eb2|e99fa30e, survey|1348198425|24e06c56|3194eb2|2b67b997|bb869569|6b10fbcf|1eae77f7|de2b9f0c, survey_blocks_for_survey|2006131675|60c25b76||e32a680c|39fca07e|1be6f5d2|69f56758|ca86d0a3, ',
'survey_responses_for_survey|1345514723|3376858a||f8be2276|bbfcc933|80a0ba3e|ac7fd14|b401ffb, system|8|b41a4771||4c1f508a|fd179d1e|7a10f7dd|fa4e714f|aead12d0, tasks_for_case|430675239|100cb722|a2b945cd|b53c800c|3e420dea|3380b14b|44dae724|76064dc0, tax_codes|59942561|33c1460c||4366bd0b|425d1b83|e7d2fc65|4931d747|cbce9d6f, tax_regime|561152653|9e93052||3d1d1dd8|9f837237|100e7c60|4ed3cb30|1a533d7c, tax_regimes_for_tax_zone|46991177|3e29f9d3||12754cb0|71957a65|88a037d4|24ec4979|3cf3c6f0, ',
'tax_rules_for_tax_regime|182209916|168ed203||952da000|debe9f11|18f46d38|bd6e0d7d|fa5eb997, tax_zones|2067747233|e67ffbdb||b73eafd|7e4008c8|40f98019|23f1d797|f7c631e3, theme|2120608782|ae942c8e||87bc59b4|f514247d|62cdc97|7e302e07|cf6fbc07, theme_accent_1|1091071801|435b0abc||9abc76ec||||87479244, theme_accent_2|582376101|e4078b1b||19f337a2||||645900a2, theme_accent_3|2134717818|41df4aab||aaac63a7||||8c566ce2, theme_accent_4|290642889|6ba260||c7275d0||||5a164a4c, ',
'theme_accent_5|920246873|5e431c2e||4a0aba67||||1dec2c62, theme_banner|1242434882|84fc02ad||73da9400||||3c735b7a, tickets|2119451158|d91d0049||2ec563f1|4d86006a|d27d1670|a603be48|8b5e3bbf, treb_view_listings|622536265|f4074657|9eafb08c|7ec913f7|ebfc28a8|95781db6|f14c1f53|cd09f88f, treb_view_room_listings|979751350|2315e738||a4f04e3b||||382a2bdd, user|6|c175b6cc|447dddd0|945657bc|d74bc1cc|1234a290|eb544ba5|88a924c9, User Lookup|1599889923|281d53ee||20e5b6d0||||6b624aec, ',
'user_activity_orders|1178493635|b36d6dd6||||||24f6fb5a, view_credit_memos_for_order|118589083|2133a231||f9e5796||||dec1b120, view_registered_events_for_order|1040680974|82ace8e4||fc18f7bf||||9827066e, visitor_stats|1327825126|883bba55||||||7e905cb5, widget|1861367917|a1ec1ee4||9fc2dedc|c7c789d5|a938e49d|9cde2b36|7e5fa976, your_cases|36207315|bda8af82|d3f30135|5a1db2cf|7ecea621|fe1cf9ca|e1d535f0|10ed65b, your_order_history|581815015|34aabc0b||4b8ed1||||17b7c2e3');