-
Notifications
You must be signed in to change notification settings - Fork 0
/
2468.sql
119 lines (114 loc) · 58.9 KB
/
2468.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
#2468.sql
# 1) New columns for pages table: communityID, personID
# 2) New columns for product table: communityID, memberID, personID
# 3) Changes to Pages report to include Community and Member where enabled
# 4) Fixes for report forms dealing with in-place theme editing:
# theme_banner, theme_accent_1, theme_accent_2, theme_accent_3, theme_accent_4, theme_accent_5
# 5) Set version information
# 1) New columns for pages table: communityID, personID
ALTER TABLE `pages`
ADD COLUMN `communityID` BIGINT(20) UNSIGNED DEFAULT 0 NOT NULL AFTER `systemID`,
ADD COLUMN `personID` BIGINT(20) UNSIGNED DEFAULT 0 NOT NULL AFTER `memberID`;
# 2) New columns for product table: communityID, memberID, personID
ALTER TABLE `product`
ADD COLUMN `communityID` BIGINT(20) UNSIGNED DEFAULT 0 NOT NULL AFTER `systemID`,
ADD COLUMN `memberID` BIGINT(20) UNSIGNED DEFAULT 0 NOT NULL AFTER `communityID`,
ADD COLUMN `personID` BIGINT(20) UNSIGNED DEFAULT 0 NOT NULL AFTER `memberID`;
# 3) Changes to Pages report to include Community and Member where enabled
DELETE FROM `report` WHERE `ID` IN (10);
DELETE FROM `report_columns` WHERE `ID` IN (1848063227,689913494,78,1811877963,107,106,1354100325);
INSERT INTO `report` (`ID`,`archive`,`archiveID`,`deleted`,`name`,`systemID`,`icon`,`seq`,`tab`,`label`,`archiveChanges`,`description`,`formComponentID`,`formTitle`,`help`,`listTypeID`,`permCOMMUNITYADMIN`,`permGROUPVIEWER`,`permGROUPEDITOR`,`permMASTERADMIN`,`permPUBLIC`,`permSYSADMIN`,`permSYSAPPROVER`,`permSYSEDITOR`,`permSYSLOGON`,`permSYSMEMBER`,`permUSERADMIN`,`popupFormHeight`,`popupFormWidth`,`primaryObject`,`primaryTable`,`reportComponentID`,`reportGroupBy`,`reportMembersGlobalEditors`,`reportSortBy`,`reportSQL_COMMUNITYADMIN`,`reportSQL_GROUPADMIN`,`reportSQL_MASTERADMIN`,`reportSQL_SYSADMIN`,`reportTitle`,`required_feature`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES (10,0,0,0,'pages',1,'[ICON]16 16 263 Manage Pages[/ICON]',606,'06.Content','Pages',0,'Only report columns used EXCEPT for site-specific toolbar overrides for WYSIWYG editor',1474354344,'Edit Page','_help_admin_pages',1,0,0,1,1,0,1,1,1,0,0,0,620,865,'Page','pages',1,'`pages`.`ID`',0,77,'','SELECT\r\n IF (`pages`.`communityID`!=0,(SELECT `title` FROM `community` AS `C` WHERE `C`.`ID` = `pages`.`communityID`),\'\') AS `community_name`,\r\n IF (`pages`.`memberID`!=0,(SELECT CONCAT(\'<span class=\"nowrap\">\',`service_addr_country`,IF(`service_addr_sp`!=\'\',CONCAT(\' | \',`service_addr_sp`),\'\'),\' | \',`service_addr_city`,\' | \',`title`,\'</span>\') FROM `community_member` AS `CM` WHERE `CM`.`ID` = `pages`.`memberID`),\'\') AS `memberName`,\r\n CONCAT(\'<a rel=\"external\" title=\"view this page\" href=\"\', TRIM(\'/\' FROM `system`.`URL`), \'/\', TRIM(\'/\' FROM `pages`.`path`), \'\">\', `pages`.`path`, \'</a>\') `pages_path`,\r\n `pages`.*,\r\n IF (`pages`.`parentID`=0,\"<span class=\'none\'>[None]</span>\",IF(ISNULL(`pp`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`pp`.`page`)) AS `parent_page`,\r\n COUNT(DISTINCT `ga`.`ID`) AS `groups`,\r\n IF (`pages`.`themeID`=1,\"<span class=\'default\'>[AUTO]</span>\",IF(ISNULL(`theme`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`theme`.`name`)) AS `theme_name`,\r\n IF (`pages`.`layoutID`=1,\"<span class=\'default\'>[AUTO]</span>\",IF(ISNULL(`layout`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`layout`.`name`)) AS `layoutName`,\r\n IF (`pages`.`componentID_post`=1,\'\',IF(ISNULL(`component_post`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`component_post`.`name`)) AS `component_post_name`,\r\n IF (`pages`.`componentID_pre`=1,\'\',IF(ISNULL(`component_pre`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`component_pre`.`name`)) AS `component_pre_name`,\r\n IF (`pages`.`navsuite1ID`=0,\"<span class=\'default\'>[AUTO]</span>\",IF(`pages`.`navsuite1ID`=1,\"<span class=\'none\'>[None]</span>\",IF (ISNULL(`navsuite1`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`navsuite1`.`name`))) AS `navsuite1_name`,\r\n IF (`pages`.`navsuite2ID`=0,\"<span class=\'default\'>[AUTO]</span>\",IF(`pages`.`navsuite2ID`=1,\"<span class=\'none\'>[None]</span>\",IF (ISNULL(`navsuite2`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`navsuite2`.`name`))) AS `navsuite2_name`,\r\n IF (`pages`.`navsuite3ID`=0,\"<span class=\'default\'>[AUTO]</span>\",IF(`pages`.`navsuite3ID`=1,\"<span class=\'none\'>[None]</span>\",IF (ISNULL(`navsuite3`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`navsuite3`.`name`))) AS `navsuite3_name`,\r\n IF (ISNULL(`system`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`system`.`textEnglish`) AS `systemTitle`\r\nFROM\r\n `pages`\r\nLEFT JOIN `pages` AS `pp` ON\r\n `pp`.`ID` = `pages`.`parentID`\r\nLEFT JOIN `system` ON\r\n `pages`.`systemID` = `system`.`ID`\r\nLEFT JOIN `theme` ON\r\n `theme`.`ID` = `pages`.`themeID`\r\nLEFT JOIN `layout` ON\r\n `pages`.`layoutID` = `layout`.`ID`\r\nLEFT JOIN `component` `component_pre` ON\r\n `pages`.`componentID_pre` = `component_pre`.`ID`\r\nLEFT JOIN `component` `component_post` ON\r\n `pages`.`componentID_post` = `component_post`.`ID`\r\nLEFT JOIN `navsuite` AS `navsuite1` ON\r\n `pages`.`navsuite1ID` = `navsuite1`.`ID`\r\nLEFT JOIN `navsuite` AS `navsuite2` ON\r\n `pages`.`navsuite2ID` = `navsuite2`.`ID`\r\nLEFT JOIN `navsuite` AS `navsuite3` ON\r\n `pages`.`navsuite3ID` = `navsuite3`.`ID`\r\nLEFT JOIN `group_assign` AS `ga` ON\r\n `ga`.`assign_type` = \'page\' AND\r\n `ga`.`assignID` = `pages`.`ID`\r\nLEFT JOIN `group_members` AS `gm` ON\r\n `gm`.`groupID` = `ga`.`groupID`\r\nWHERE\r\n `pages`.`systemID` = SYS_ID AND\r\n `gm`.`personID` = PERSON_ID','SELECT\r\n IF (`pages`.`communityID`!=0,(SELECT `title` FROM `community` AS `C` WHERE `C`.`ID` = `pages`.`communityID`),\'\') AS `community_name`,\r\n IF (`pages`.`memberID`!=0,(SELECT CONCAT(\'<span class=\"nowrap\">\',`service_addr_country`,IF(`service_addr_sp`!=\'\',CONCAT(\' | \',`service_addr_sp`),\'\'),\' | \',`service_addr_city`,\' | \',`title`,\'</span>\') FROM `community_member` AS `CM` WHERE `CM`.`ID` = `pages`.`memberID`),\'\') AS `memberName`,\r\n CONCAT(\'<a rel=\"external\" title=\"view this page\" href=\"\', TRIM(\'/\' FROM `system`.`URL`), \'/\', TRIM(\'/\' FROM `pages`.`path`), \'\">\', `pages`.`path`, \'</a>\') `pages_path`,\r\n `pages`.*,\r\n IF (`pages`.`parentID`=0,\"<span class=\'none\'>[None]</span>\",IF(ISNULL(`pp`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`pp`.`page`)) AS `parent_page`,\r\n COUNT(DISTINCT `ga`.`ID`) AS `groups`,\r\n IF (`pages`.`themeID`=1,\"<span class=\'default\'>[AUTO]</span>\",IF(ISNULL(`theme`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`theme`.`name`)) AS `theme_name`,\r\n IF (`pages`.`layoutID`=1,\"<span class=\'default\'>[AUTO]</span>\",IF(ISNULL(`layout`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`layout`.`name`)) AS `layoutName`,\r\n IF (`pages`.`componentID_post`=1,\'\',IF(ISNULL(`component_post`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`component_post`.`name`)) AS `component_post_name`,\r\n IF (`pages`.`componentID_pre`=1,\'\',IF(ISNULL(`component_pre`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`component_pre`.`name`)) AS `component_pre_name`,\r\n IF (`pages`.`navsuite1ID`=0,\"<span class=\'default\'>[AUTO]</span>\",IF(`pages`.`navsuite1ID`=1,\"<span class=\'none\'>[None]</span>\",IF (ISNULL(`navsuite1`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`navsuite1`.`name`))) AS `navsuite1_name`,\r\n IF (`pages`.`navsuite2ID`=0,\"<span class=\'default\'>[AUTO]</span>\",IF(`pages`.`navsuite2ID`=1,\"<span class=\'none\'>[None]</span>\",IF (ISNULL(`navsuite2`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`navsuite2`.`name`))) AS `navsuite2_name`,\r\n IF (`pages`.`navsuite3ID`=0,\"<span class=\'default\'>[AUTO]</span>\",IF(`pages`.`navsuite3ID`=1,\"<span class=\'none\'>[None]</span>\",IF (ISNULL(`navsuite3`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`navsuite3`.`name`))) AS `navsuite3_name`,\r\n IF (ISNULL(`system`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`system`.`textEnglish`) AS `systemTitle`\r\nFROM\r\n `pages`\r\nLEFT JOIN `pages` AS `pp` ON\r\n `pp`.`ID` = `pages`.`parentID`\r\nLEFT JOIN `system` ON\r\n `pages`.`systemID` = `system`.`ID`\r\nLEFT JOIN `theme` ON\r\n `theme`.`ID` = `pages`.`themeID`\r\nLEFT JOIN `layout` ON\r\n `pages`.`layoutID` = `layout`.`ID`\r\nLEFT JOIN `component` `component_pre` ON\r\n `pages`.`componentID_pre` = `component_pre`.`ID`\r\nLEFT JOIN `component` `component_post` ON\r\n `pages`.`componentID_post` = `component_post`.`ID`\r\nLEFT JOIN `navsuite` AS `navsuite1` ON\r\n `pages`.`navsuite1ID` = `navsuite1`.`ID`\r\nLEFT JOIN `navsuite` AS `navsuite2` ON\r\n `pages`.`navsuite2ID` = `navsuite2`.`ID`\r\nLEFT JOIN `navsuite` AS `navsuite3` ON\r\n `pages`.`navsuite3ID` = `navsuite3`.`ID`\r\nLEFT JOIN `group_assign` AS `ga` ON\r\n `ga`.`assign_type` = \'page\' AND\r\n `ga`.`assignID` = `pages`.`ID`\r\n#LEFT JOIN `group_members` AS `gm` ON `gm`.`groupID` = `ga`.`groupID`\r\nWHERE\r\n 1','SELECT\r\n IF (`pages`.`communityID`!=0,(SELECT `title` FROM `community` AS `C` WHERE `C`.`ID` = `pages`.`communityID`),\'\') AS `community_name`,\r\n IF (`pages`.`memberID`!=0,(SELECT CONCAT(\'<span class=\"nowrap\">\',`service_addr_country`,IF(`service_addr_sp`!=\'\',CONCAT(\' | \',`service_addr_sp`),\'\'),\' | \',`service_addr_city`,\' | \',`title`,\'</span>\') FROM `community_member` AS `CM` WHERE `CM`.`ID` = `pages`.`memberID`),\'\') AS `memberName`,\r\n CONCAT(\'<a rel=\"external\" title=\"view this page\" href=\"\', TRIM(\'/\' FROM `system`.`URL`), \'/\', TRIM(\'/\' FROM `pages`.`path`), \'\">\', `pages`.`path`, \'</a>\') `pages_path`,\r\n `pages`.*,\r\n IF (`pages`.`parentID`=0,\"<span class=\'none\'>[None]</span>\",IF(ISNULL(`pp`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`pp`.`page`)) AS `parent_page`,\r\n COUNT(DISTINCT `ga`.`ID`) AS `groups`,\r\n IF (`pages`.`themeID`=1,\"<span class=\'default\'>[AUTO]</span>\",IF(ISNULL(`theme`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`theme`.`name`)) AS `theme_name`,\r\n IF (`pages`.`layoutID`=1,\"<span class=\'default\'>[AUTO]</span>\",IF(ISNULL(`layout`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`layout`.`name`)) AS `layoutName`,\r\n IF (`pages`.`componentID_post`=1,\'\',IF(ISNULL(`component_post`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`component_post`.`name`)) AS `component_post_name`,\r\n IF (`pages`.`componentID_pre`=1,\'\',IF(ISNULL(`component_pre`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`component_pre`.`name`)) AS `component_pre_name`,\r\n IF (`pages`.`navsuite1ID`=0,\"<span class=\'default\'>[AUTO]</span>\",IF(`pages`.`navsuite1ID`=1,\"<span class=\'none\'>[None]</span>\",IF (ISNULL(`navsuite1`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`navsuite1`.`name`))) AS `navsuite1_name`,\r\n IF (`pages`.`navsuite2ID`=0,\"<span class=\'default\'>[AUTO]</span>\",IF(`pages`.`navsuite2ID`=1,\"<span class=\'none\'>[None]</span>\",IF (ISNULL(`navsuite2`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`navsuite2`.`name`))) AS `navsuite2_name`,\r\n IF (`pages`.`navsuite3ID`=0,\"<span class=\'default\'>[AUTO]</span>\",IF(`pages`.`navsuite3ID`=1,\"<span class=\'none\'>[None]</span>\",IF (ISNULL(`navsuite3`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`navsuite3`.`name`))) AS `navsuite3_name`,\r\n IF (ISNULL(`system`.`ID`),\"<span class=\'error\'>INVALID!</span>\",`system`.`textEnglish`) AS `systemTitle`\r\nFROM\r\n `pages`\r\nLEFT JOIN `pages` AS `pp` ON\r\n `pp`.`ID` = `pages`.`parentID`\r\nLEFT JOIN `system` ON\r\n `pages`.`systemID` = `system`.`ID`\r\nLEFT JOIN `theme` ON\r\n `theme`.`ID` = `pages`.`themeID`\r\nLEFT JOIN `layout` ON\r\n `pages`.`layoutID` = `layout`.`ID`\r\nLEFT JOIN `component` `component_pre` ON\r\n `pages`.`componentID_pre` = `component_pre`.`ID`\r\nLEFT JOIN `component` `component_post` ON\r\n `pages`.`componentID_post` = `component_post`.`ID`\r\nLEFT JOIN `navsuite` AS `navsuite1` ON\r\n `pages`.`navsuite1ID` = `navsuite1`.`ID`\r\nLEFT JOIN `navsuite` AS `navsuite2` ON\r\n `pages`.`navsuite2ID` = `navsuite2`.`ID`\r\nLEFT JOIN `navsuite` AS `navsuite3` ON\r\n `pages`.`navsuite3ID` = `navsuite3`.`ID`\r\nLEFT JOIN `group_assign` AS `ga` ON\r\n `ga`.`assign_type` = \'page\' AND\r\n `ga`.`assignID` = `pages`.`ID`\r\n#LEFT JOIN `group_members` AS `gm` ON `gm`.`groupID` = `ga`.`groupID`\r\nWHERE\r\n `pages`.`systemID` = SYS_ID','Administer Pages','',1,'2005-10-06 00:00:00','',1,'2016-10-16 17:37:37','127.0.0.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 (78,0,0,0,1,10,'',7,'0.','','edit','',0,'','',0,0,'','','',0,0,2,2,0,2,2,1,0,0,0,'page','Name for page (must be unique)','`pages`.`page`','Name','Name',1,'`pages`.`page` ASC','`pages`.`page` DESC','',0,1,'2005-10-06 00:00:00','',1,'2016-10-16 17:39:21','127.0.0.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 (106,0,0,0,1,10,'',11,'0.','','selector','',0,'','',0,0,'','','',0,0,2,2,0,2,2,2,0,0,0,'layoutName','','IF (`pages`.`layoutID`=1,\'[AUTO]\',IF(ISNULL(`layout`.`ID`),\'INVALID!\',`layout`.`name`))','Layout','Layout',1,'`layout`.`name` ASC','`layout`.`name` DESC','',0,1,'2005-10-06 00:00:00','',1,'2016-10-16 17:43:41','127.0.0.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 (107,0,0,0,1,10,'',10,'0.','','text','',0,'','',0,0,'','','',0,0,2,2,0,2,2,2,0,0,0,'title','','`pages`.`title`','Title','Title',1,'`pages`.`title` ASC','`pages`.`title` DESC','',0,1,'2005-10-06 00:00:00','',1,'2016-10-16 17:43:16','127.0.0.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 (689913494,0,0,0,1,10,'',6,'0.','MEMBER_ID','selector','memberID',0,'','Which member does this belong to?',0,0,'Member','SELECT\r\n 0 `seq`,\r\n \'\' `value`,\r\n \'(None)\' `text`,\r\n \'d0d0d0\' `color_background`,\r\n \'404040\' `color_text`\r\nUNION SELECT\r\n 1,\r\n `community_member`.`ID`,\r\n CONCAT(\r\n `system`.`textEnglish`,\': \',\r\n `service_addr_country`,\r\n IF(\r\n `service_addr_sp`!=\'\',\r\n CONCAT(\' | \',`service_addr_sp`),\r\n \'\'\r\n ),\r\n \' | \',`service_addr_city`,\' | \',`title`),\r\n IF(`system`.ID=SYS_ID,\'c0ffc0\',\'ffe0e0\'),\r\n \'000000\'\r\nFROM\r\n `community_member`\r\nINNER JOIN `system` ON\r\n `system`.`ID` = `community_member`.`systemID`\r\nORDER BY\r\n `seq`,`text`','SELECT\r\n 0 `seq`,\r\n \'\' `value`,\r\n \'(None)\' `text`,\r\n \'d0d0d0\' `color_background`,\r\n \'404040\' `color_text`\r\nUNION SELECT\r\n 1,\r\n `community_member`.`ID`,\r\n CONCAT(\r\n `service_addr_country`,\r\n IF(\r\n `service_addr_sp`!=\'\',\r\n CONCAT(\' | \',`service_addr_sp`),\r\n \'\'\r\n ),\r\n \' | \',`service_addr_city`,\' | \',`title`),\r\n \'c0ffc0\',\r\n \'000000\'\r\nFROM\r\n `community_member`\r\nWHERE\r\n `community_member`.`systemID` = SYS_ID\r\nORDER BY\r\n `seq`,`text`',0,0,0,2,0,2,2,0,0,0,0,'memberName','','COALESCE((SELECT CONCAT(`service_addr_country`,IF(`service_addr_sp`!=\'\',CONCAT(\' | \',`service_addr_sp`),\'\'),\' | \',`service_addr_city`,\' | \',`title`) FROM `community_member` AS `CM` WHERE `CM`.`ID` = `postings`.`memberID`),\'\')','Member','Member',1,'memberName=\'\',memberName ASC','memberName=\'\',memberName DESC','module-community',0,1,'2016-10-16 17:35:46','127.0.0.1',1,'2016-10-16 17:36:06','127.0.0.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 (1354100325,0,0,0,1,10,'',12,'0.','','selector','',0,'','',0,0,'','','',0,0,2,2,0,2,2,2,0,0,0,'theme_name','','IF (`pages`.`themeID`=1,\'[AUTO]\',IF(ISNULL(`theme`.`ID`),\'INVALID!\',`theme`.`name`))','Theme','Theme',1,'`theme_name` ASC','`theme_name` DESC','Themes',0,1,'2008-01-02 13:48:50','',1,'2016-10-16 17:44:00','127.0.0.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 (1811877963,0,0,0,1,10,'',8,'0.','','text','',0,'','',0,0,'','','',2,0,2,2,0,2,2,2,0,0,0,'pages_path','','`pages`.`path`','Path','Path',1,'`pages`.`path` ASC','`pages`.`path` DESC','',0,1,'2008-04-17 10:31:13','',1,'2016-10-16 17:39:31','127.0.0.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 (1848063227,0,0,0,1,10,'',5,'0.','0','selector','communityID',0,'','Which community does this belong to?',0,0,'Community','SELECT\r\n 0 `seq`,\r\n \'\' `value`,\r\n \'(None)\' `text`,\r\n \'d0d0d0\' `color_background`,\r\n \'404040\' `color_text`\r\nUNION SELECT\r\n 1,\r\n `community`.`ID`,\r\n CONCAT(\r\n `system`.`textEnglish`,\': \',\r\n `title`\r\n ),\r\n IF(`system`.ID=SYS_ID,\'c0ffc0\',\'ffe0e0\'),\r\n \'000000\'\r\nFROM\r\n `community`\r\nINNER JOIN `system` ON\r\n `system`.`ID` = `community`.`systemID`\r\nORDER BY\r\n `seq`,`text`','SELECT\r\n 0 `seq`,\r\n \'\' `value`,\r\n \'(None)\' `text`,\r\n \'d0d0d0\' `color_background`,\r\n \'404040\' `color_text`\r\nUNION SELECT\r\n 1,\r\n `community`.`ID`,\r\n `community`.`title`,\r\n \'c0ffc0\',\r\n \'000000\'\r\nFROM\r\n `community`\r\nWHERE\r\n `community`.`systemID` = SYS_ID\r\nORDER BY\r\n `seq`,`text`',0,0,0,2,0,2,2,0,0,0,0,'community_name','','COALESCE((SELECT `title` FROM `community` AS `C` WHERE `C`.`ID` = `postings`.`communityID`),\'\')','Community','Community',1,'community_name=\'\',community_name ASC','community_name=\'\',community_name DESC','module-community',0,1,'2016-10-16 17:35:42','127.0.0.1',1,'2016-10-16 17:36:06','127.0.0.1');
# 4) Fixes for report forms dealing with in-place theme editing:
# theme_banner, theme_accent_1, theme_accent_2, theme_accent_3, theme_accent_4, theme_accent_5
DELETE FROM `report` WHERE `ID` IN (1091071801,582376101,2134717818,290642889,920246873,1242434882);
INSERT INTO `report` (`ID`,`archive`,`archiveID`,`deleted`,`name`,`systemID`,`icon`,`seq`,`tab`,`label`,`archiveChanges`,`description`,`formComponentID`,`formTitle`,`help`,`listTypeID`,`permCOMMUNITYADMIN`,`permGROUPVIEWER`,`permGROUPEDITOR`,`permMASTERADMIN`,`permPUBLIC`,`permSYSADMIN`,`permSYSAPPROVER`,`permSYSEDITOR`,`permSYSLOGON`,`permSYSMEMBER`,`permUSERADMIN`,`popupFormHeight`,`popupFormWidth`,`primaryObject`,`primaryTable`,`reportComponentID`,`reportGroupBy`,`reportMembersGlobalEditors`,`reportSortBy`,`reportSQL_COMMUNITYADMIN`,`reportSQL_GROUPADMIN`,`reportSQL_MASTERADMIN`,`reportSQL_SYSADMIN`,`reportTitle`,`required_feature`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES (290642889,0,0,0,'theme_accent_4',1,'',0,'','',0,'',1,'Edit Theme Accent 2','',1,0,0,0,1,0,1,0,0,0,0,0,455,800,'Theme','theme',1,'',0,0,'','','','','','Themes',1,'2008-08-06 16:58:12','',1,'2016-10-15 05:51:11','127.0.0.1');
INSERT INTO `report` (`ID`,`archive`,`archiveID`,`deleted`,`name`,`systemID`,`icon`,`seq`,`tab`,`label`,`archiveChanges`,`description`,`formComponentID`,`formTitle`,`help`,`listTypeID`,`permCOMMUNITYADMIN`,`permGROUPVIEWER`,`permGROUPEDITOR`,`permMASTERADMIN`,`permPUBLIC`,`permSYSADMIN`,`permSYSAPPROVER`,`permSYSEDITOR`,`permSYSLOGON`,`permSYSMEMBER`,`permUSERADMIN`,`popupFormHeight`,`popupFormWidth`,`primaryObject`,`primaryTable`,`reportComponentID`,`reportGroupBy`,`reportMembersGlobalEditors`,`reportSortBy`,`reportSQL_COMMUNITYADMIN`,`reportSQL_GROUPADMIN`,`reportSQL_MASTERADMIN`,`reportSQL_SYSADMIN`,`reportTitle`,`required_feature`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES (582376101,0,0,0,'theme_accent_2',1,'',0,'','',0,'',1,'Edit Theme Accent 2','',1,0,0,0,1,0,1,0,0,0,0,0,455,800,'Theme','theme',1,'',0,0,'','','','','','Themes',1,'2008-08-06 16:07:37','',1,'2016-10-15 05:50:55','127.0.0.1');
INSERT INTO `report` (`ID`,`archive`,`archiveID`,`deleted`,`name`,`systemID`,`icon`,`seq`,`tab`,`label`,`archiveChanges`,`description`,`formComponentID`,`formTitle`,`help`,`listTypeID`,`permCOMMUNITYADMIN`,`permGROUPVIEWER`,`permGROUPEDITOR`,`permMASTERADMIN`,`permPUBLIC`,`permSYSADMIN`,`permSYSAPPROVER`,`permSYSEDITOR`,`permSYSLOGON`,`permSYSMEMBER`,`permUSERADMIN`,`popupFormHeight`,`popupFormWidth`,`primaryObject`,`primaryTable`,`reportComponentID`,`reportGroupBy`,`reportMembersGlobalEditors`,`reportSortBy`,`reportSQL_COMMUNITYADMIN`,`reportSQL_GROUPADMIN`,`reportSQL_MASTERADMIN`,`reportSQL_SYSADMIN`,`reportTitle`,`required_feature`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES (920246873,0,0,0,'theme_accent_5',1,'',0,'','',0,'',1,'Edit Theme Accent 5','',1,0,0,0,1,0,1,0,0,0,0,0,455,800,'Theme','theme',1,'',0,0,'','','','','','Themes',1,'2008-08-06 16:58:22','',1,'2016-10-15 05:51:20','127.0.0.1');
INSERT INTO `report` (`ID`,`archive`,`archiveID`,`deleted`,`name`,`systemID`,`icon`,`seq`,`tab`,`label`,`archiveChanges`,`description`,`formComponentID`,`formTitle`,`help`,`listTypeID`,`permCOMMUNITYADMIN`,`permGROUPVIEWER`,`permGROUPEDITOR`,`permMASTERADMIN`,`permPUBLIC`,`permSYSADMIN`,`permSYSAPPROVER`,`permSYSEDITOR`,`permSYSLOGON`,`permSYSMEMBER`,`permUSERADMIN`,`popupFormHeight`,`popupFormWidth`,`primaryObject`,`primaryTable`,`reportComponentID`,`reportGroupBy`,`reportMembersGlobalEditors`,`reportSortBy`,`reportSQL_COMMUNITYADMIN`,`reportSQL_GROUPADMIN`,`reportSQL_MASTERADMIN`,`reportSQL_SYSADMIN`,`reportTitle`,`required_feature`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES (1091071801,0,0,0,'theme_accent_1',1,'',0,'','',0,'',1,'Edit Theme Accent 1','',1,0,0,0,1,0,1,0,0,0,0,0,455,800,'Theme','theme',1,'',0,0,'','','','','','Themes',1,'2008-08-06 16:01:21','',1,'2016-10-15 05:50:40','127.0.0.1');
INSERT INTO `report` (`ID`,`archive`,`archiveID`,`deleted`,`name`,`systemID`,`icon`,`seq`,`tab`,`label`,`archiveChanges`,`description`,`formComponentID`,`formTitle`,`help`,`listTypeID`,`permCOMMUNITYADMIN`,`permGROUPVIEWER`,`permGROUPEDITOR`,`permMASTERADMIN`,`permPUBLIC`,`permSYSADMIN`,`permSYSAPPROVER`,`permSYSEDITOR`,`permSYSLOGON`,`permSYSMEMBER`,`permUSERADMIN`,`popupFormHeight`,`popupFormWidth`,`primaryObject`,`primaryTable`,`reportComponentID`,`reportGroupBy`,`reportMembersGlobalEditors`,`reportSortBy`,`reportSQL_COMMUNITYADMIN`,`reportSQL_GROUPADMIN`,`reportSQL_MASTERADMIN`,`reportSQL_SYSADMIN`,`reportTitle`,`required_feature`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES (1242434882,0,0,0,'theme_banner',1,'',0,'','',0,'',1,'Edit Theme Banner','',1,0,0,0,1,0,1,0,0,0,0,0,455,800,'Theme','theme',1,'',0,0,'','','','','','Themes',1,'2008-08-06 15:33:54','',1,'2016-10-15 05:47:40','127.0.0.1');
INSERT INTO `report` (`ID`,`archive`,`archiveID`,`deleted`,`name`,`systemID`,`icon`,`seq`,`tab`,`label`,`archiveChanges`,`description`,`formComponentID`,`formTitle`,`help`,`listTypeID`,`permCOMMUNITYADMIN`,`permGROUPVIEWER`,`permGROUPEDITOR`,`permMASTERADMIN`,`permPUBLIC`,`permSYSADMIN`,`permSYSAPPROVER`,`permSYSEDITOR`,`permSYSLOGON`,`permSYSMEMBER`,`permUSERADMIN`,`popupFormHeight`,`popupFormWidth`,`primaryObject`,`primaryTable`,`reportComponentID`,`reportGroupBy`,`reportMembersGlobalEditors`,`reportSortBy`,`reportSQL_COMMUNITYADMIN`,`reportSQL_GROUPADMIN`,`reportSQL_MASTERADMIN`,`reportSQL_SYSADMIN`,`reportTitle`,`required_feature`,`history_created_by`,`history_created_date`,`history_created_IP`,`history_modified_by`,`history_modified_date`,`history_modified_IP`) VALUES (2134717818,0,0,0,'theme_accent_3',1,'',0,'','',0,'',1,'Edit Theme Accent 2','',1,0,0,0,1,0,1,0,0,0,0,0,455,800,'Theme','theme',1,'',0,0,'','','','','','Themes',1,'2008-08-06 16:57:59','',1,'2016-10-15 05:51:04','127.0.0.1');
# 5) Set version information
UPDATE `system` SET `system`.`db_version` = '2468';
UPDATE `system` SET `system`.`db_cs_target` = '4445437e';
UPDATE `system` SET `system`.`db_detail` =
CONCAT(
'action|5c7aabd2, activity|53667216, address_substitution|8bb7ffea, block_layout|d2f20bb7, case_tasks|dcadc62c, cases|c0d09a18, category_assign|5c529179, colour_scheme|fe636999, comment|24ede7fb, community|5f5268c1, community_member|5711b2f0, community_membership|21e9f8d3, component|e28212b5, content_block|2db11c9b, custom_form|f1219e6a, ecl_tags|47084f56, field_templates|9de051e9, gateway_settings|46fb07ce, gateway_type|69a90feb, geocode_cache|c7bc07c8, group_assign|dd960004, ',
'group_members|dfd72a2, groups|4941bc7e, keyword_assign|d13eff96, keywords|810421c2, language_assign|1c07c6c7, layout|bf326523, listdata|1cd62fa9, listtype|c86f000e, mailidentity|fff16c11, mailqueue|1753bb33, mailqueue_item|45f8858b, mailtemplate|18f3a9e0, membership_rule|278776f1, navbuttons|edfc7aa1, navstyle|7ed4a40e, navsuite|780ee720, order_items|12f705c0, orders|15cdc87a, pages|549b37c9, payment_method|6b0332b9, person|89599ce9, poll|c548ae6e, poll_choice|d94a8f4e, postings|771864f7, ',
'product|3ee4f92, product_grouping|1d772a4d, product_relationship|79204adb, push_product_assign|4dc7bcf0, qb_config|35e6dae7, qb_connection|3227a7f0, qb_ident|66d8cb44, qb_import|9fd3eca9, qb_log|9dbab1ed, qb_notify|5e20c0e, qb_queue|7a5d98f7, qb_recur|c8f7849a, qb_ticket|109cc61a, qb_user|d423153e, registerevent|84bc52c6, report|64ac2daa, report_columns|3011c7b8, report_defaults|46822bae, report_filter|4a8d798, report_filter_criteria|8ba6845b, report_settings|46cec01, scheduled_task|89340e8, ',
'system|4db0028c, tax_code|c777f7b7, tax_regime|51aacb43, tax_rule|a9695788, tax_zone|5c46d8d7, theme|7f2ec543, widget|4b7331c8, DB_media.media|2d9994f1');
UPDATE `system` SET `system`.`classes_cs_target` = '4db935e5';
UPDATE `system` SET `system`.`classes_detail` =
CONCAT(
'class.action.php|1.0.23|18354|98e9e733, class.activity.php|1.0.19|7744|1a17c13d, class.ajax.php|1.0.26|18691|58364b32, class.akismet.php|0.41.f|7970|920d6584, class.array2xml.php|1.0.1|2292|76b4c130, class.article.php|1.0.42|15337|2ba75a58, class.backup.php|1.1.10|11389|cc614105, class.barcode.php|1.0.4|5031|eca9ae45, class.base.php|1.0.16|7016|2004f8cb, class.base_error.php|1.0.2|651|8fb940e8, class.beanstream_gateway.php|1.0.5|9725|37b53ef6, class.block_layout.php|1.0.70|37858|845bf6a1, ',
'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.1|54893|d9fe0916, class.chasepaymentech_gateway.php|1.0.7|12411|98e8b339, class.checkout.php|1.0.45|18809|e09f417c, 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.120|31091|80b3a380, class.community_article.php|1.0.4|869|d33c0cf8, class.community_display.php|1.0.48|109997|628a06a0, class.community_event.php|1.0.4|861|b4b31a0e, class.community_member.php|1.0.114|67229|68606a7a, class.community_member_article.php|1.0.4|892|77c26278, class.community_member_display.php|1.0.47|78628|84a74085, 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.10|7285|d2d26694, class.community_member_summary.php|1.0.21|48700|69179469, 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.7|8486|34404b81, ',
'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_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.5|10039|b86072cb, 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.75|49887|cf31ad4c, 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.3|3820|f85e8fd1, 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.78|115968|b105cdd7, class.country.php|1.0.1|837|39e46aa6, class.cpdf.php|1.0.0|100588|9fad0b3a, class.credit_memo.php|1.0.11|8123|7e84cfe4, class.crm_case.php|1.0.12|10043|6b5825b5, 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.42|61261|1aa39fa8, class.custom_registration.php|1.0.3|2300|daef5ff, class.displayable_item.php|1.0.160|86327|3851fe1f, ',
'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.109|75957|c842087d, class.event_recurrence.php|1.0.12|44204|d06fc64b, class.export.php|1.0.26|13475|d0f336fe, 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.33|19265|ebfb7c3d, class.gallery_image.php|1.0.24|15398|92c65361, class.gateway_setting.php|1.0.4|2805|a9b30269, 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.29|17865|5a3df4b0, 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.0|755|11fa6a89, class.help.php|1.0.7|6106|28485daf, class.history.php|1.0.5|2967|c07e3f8c, class.html.php|1.0.94|69768|dffce68c, class.html2text.php|1.0.1|18318|217d0b8b, class.http_raw_socket.php|1.0.0|2672|7fed2e0d, 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.40|43506|b3c33065, class.link.php|1.0.7|16868|12943bb5, class.listdata.php|1.0.5|1041|8c3cbbfa, class.listtype.php|1.0.7|6174|43030c10, 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.4|2587|1a524390, 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.44|34738|6620fcd6, 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.7|1062|b8d7eeeb, 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.71|59041|e158f6be, 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.19|35399|9b2fd8d3, ',
'class.page_vars.php|1.0.27|23531|7a97722a, class.password.php|1.0.0|2362|66a7578e, class.payment_method.php|1.0.11|10706|20bfa6ae, class.paypal_gateway.php|1.0.24|19829|7648cd63, class.pdf.php|1.0.1|367|69fcfaf5, class.person.php|1.0.128|101489|753df20, class.person_merge_profiles.php|1.0.4|21598|87939c99, class.php_excel.php|1.0.3|1225|b56aee05, class.phpmailer.php|2.0.1|139977|b8d312f6, class.phpop3.php|1.0.3|5666|d193def8, class.piwik.php|1.0.2|6826|448fdcc9, ',
'class.podcast.php|1.0.48|26094|525316fd, class.podcast_album.php|1.0.17|14791|dd665209, class.poll.php|1.0.10|11690|729a45e2, class.poll_choice.php|1.0.4|1072|c918aab3, class.portal.php|1.0.39|19518|94eeb59f, class.posting.php|1.0.128|70419|ab84dcaa, class.posting_contained.php|1.0.245|14541|ae756d29, class.posting_container.php|1.0.6|4966|351213a6, class.prayer_request.php|1.0.0|516|7c065020, class.product.php|1.0.84|64251|388fff9e, class.product_catalogue.php|1.0.32|21866|d9002ba2, ',
'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.4|8889|ee35aea5, 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.0|1967|b8bee9cb, 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.rating.php|1.0.6|4708|3c82c959, class.record.php|1.0.100|88216|c8e54369, class.refunditem.php|1.0.1|436|541168c3, class.register_event.php|1.0.23|14128|3ded3e43, class.remote.php|1.0.13|4946|cdd0cb1a, class.report.php|1.0.90|64317|ca11fcbb, class.report_column.php|1.0.138|174869|a72a93fb, class.report_column_download_pdf.php|1.0.2|6013|a8e3ea4c, class.report_column_report_field.php|1.0.31|46111|820a23bd, ',
'class.report_column_type.php|1.0.0|664|a52ba350, class.report_config.php|1.0.7|18829|f881457, 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.67|53546|6ef60cb6, class.report_form_field_lookup.php|1.0.3|8356|aaa48c7f, class.report_report.php|1.0.30|79117|13839563, class.report_settings.php|1.0.5|4097|b42169f2, class.rss.php|1.0.31|39116|ca5afd7c, ',
'class.rss_help.php|1.0.0|364|5477dd87, class.rss_proxy.php|1.0.3|2566|44b6751d, class.scheduled_task.php|1.0.4|3996|94b6eaa7, class.search.php|1.0.14|26229|b95252f4, class.services_json.php|1.0.1|34291|a3b8a85c, 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.4|1021|a8af9045, ',
'class.survey.php|1.0.18|9703|d9977b9b, class.survey_block.php|1.0.5|5735|4ff3b4d2, class.survey_response.php|1.0.1|685|355c5596, class.system.php|1.0.174|61059|dabf1d43, class.system_copy.php|1.0.9|25144|e649470e, class.system_edit.php|1.0.37|63431|19aeac1c, class.system_export.php|1.0.19|18192|281c5519, class.system_health.php|1.0.48|73903|7fd7e10a, class.table.php|1.0.5|2581|6d770ade, class.tax_code.php|1.0.1|1319|557edda, class.tax_regime.php|1.0.15|7401|a92add9b, ',
'class.tax_rule.php|1.0.1|797|9f60a7a9, class.tax_zone.php|1.0.4|3682|faeeccb8, 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.7|6544|6ec5a88, class.widget.php|1.0.9|27502|27582a66, class.xml2array.php|1.0.1|1730|18dcc68c, class.xml_sitemap.php|1.0.4|6422|29c69ee2, 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.7|9172|1e09cb83, component/adminpersonlookup.php|1.0.6|4897|de37ee56, component/articlesrotator.php|1.0.11|14960|b26f5b59, component/base.php|1.0.7|19662|9225a127, component/biblelinks.php|1.0.3|2394|1de8a289, 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.5|9513|ffbd3044, ',
'component/categorytabber.php|1.0.7|12855|eca1a8, component/changepassword.php|1.0.3|5552|3a8a8d3f, component/collectionviewer.php|1.0.57|56347|67d1e706, component/combotabber.php|1.0.13|15802|f1618cc4, component/communitiesdisplay.php|1.0.10|8202|fe3c214c, component/communitycalendar.php|1.0.3|972|cdae41c2, component/communitycollectionviewer.php|1.0.2|474|d7b5d693, component/communitymembercalendar.php|1.0.3|1228|aa631584, component/contentblock.php|1.0.3|4936|a4211712, ',
'component/contentgroupmembermirror.php|1.0.5|2314|56b24be4, 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.2|3757|2e54b1aa, 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.2|6061|b9afe379, component/searchwordcloud.php|1.0.4|9647|6637599b, component/twitter.php|1.0.0|2751|55692264, component/wowslider.php|1.0.14|22628|25b0b43b, emailbouncechecker.php|1.0.5|7458|b0555dca, httperror.php|1.0.0|1845|1c7d9f80, 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.2|32540|e7fd7d02, 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.20|17003|7c2f5f86, nav/buttonimage.php|1.0.10|43384|d8c4bdad, nav/drawnav.php|1.0.8|15411|d54b2460, ',
'nav/style.php|1.0.13|4752|bcb6fce1, nav/suite.php|1.0.42|25311|a666154b, output.php|1.0.3|4270|258841b8, pagedraw.php|1.0.1|27965|5905d5de, phpmailerexception.php|2.0.1|666|c53dc0ba, searchhandler.php|1.0.0|10122|15963cc7, ticket.php|1.0.0|1927|7f35831c');
UPDATE `system` SET `system`.`libraries_cs_target` = '8aa6aae3';
UPDATE `system` SET `system`.`libraries_detail` =
CONCAT(
'/codebase.php|4.9.0|, /db_connect.php|1.0.3|275ee15, /functions.php|1.0.20|afe6785b, /img.php|2.0.97|1de2f324, /fedex/rate.php|1.0.6|f776de9a, /getid3/getid3.php|1.8.3b|4905aad0, /images/icons.gif||dd734563, /images/icons-big.gif||c279ad3a, /images/labels.gif||37e90a7b, /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.271|70216d0e, /js/member.js|1.0.148|239686f6, /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.173|814b1647, /style/community.css|1.0.3|3868cec9, /style/labels.css|1.0.49|75a378f1, /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` = '74a6c733';
UPDATE `system` SET `system`.`reports_detail` =
CONCAT(
'actions_for_custom_form|364098362|42173a2c||c11c2a41||66840cda, actions_for_product|1237787286|114de3e4|5aadcccf|48b293e7||7db0a042, actions_for_report|1155849835|a4704377|2acf4b9c|a71a499e|2d9fcbb8|1931936a, address-substitutions|1788081331|b072d7b||e015d45|a7ddd779|840099e5, admin_groups|1452624876|db4e7e56||||bbe0b07d, admin_manage_refunds|1961884056|a9c102e0||||854826d5, articles|1156338204|ce843c77|bdae47c3|118153e4|9c825465|8580be76, ',
'block_layout|531875437|b3e00c24||c9cbb445|e844e3e5|8454e45f, cases|1692352206|bb6e23e3|ed9dca9f|22da5767|32638573|4aefece1, comments|1985320706|b382d30a|5a78a4af|958ebf39|7139c7a9|39243bb7, comments_hidden|156656266|d357a0dd|3d73b18c|2eb975a||75fcc6b6, comments_pending|726654655|5fc552ea|c3bcaee6|74f0dbdb||7047249c, comments_spam|1685148626|e176b404|ab282e59|52ae3610||4f432aa6, comment_changes|888081516|715cb4a3||2cb9cba2||c75be09c, ',
'community|1899073055|ced7a9c9|fd688f0b|9c7c3e0f|8638e08b|a582f6ca, community.articles|93810097|c0cd7ef9|5556eb5a|3d204cb3|d0883ad0|e63ff037, community.events|1304217624|5ec88da3|9e5054a9|8836dab|bf6c1d83|84f3ba8f, community.gallery-albums|522993388|d6ef516d|b922e68|cbfd7f29|c4ba32a3|5eb72c41, community.gallery-images|86967210|3845d8c1|f601a420|428fddf8|17dcad9e|166f574b, community.membership|1357442628|d298b273||8f8819ab|4aa25543|d5790de6, ',
'community.news-items|2036787717|cbbe80a2|2602c2ff|44e0bdaf|8f0395ee|1d467651, community.podcast-albums|887489900|65a3955b|5bc9341e|882172ff|8109803b|54ca5ca8, community.podcasts|413070900|2d7beb48|9d927f8|aee9350d|9f20647b|b58b4e9f, community.sponsorship-plans|2002167964|493f0cb9|48460222|257eb42e|2b5d6801|b5b952e, community_member|1902153511|bb81eee5|7e6439fc|3d95fc3f|966359b4|c8a53d3c, community_member.admins|59838467|d7c9d366|7e0aa25|d4feed27|5510c836|96ea7a81, ',
'community_member.articles|1897057515|645b7e39|e0fd409e|1e323f75|6a64eda3|c47cf904, community_member.contacts|546881527|c141089a|f8f8d972|e8818b74|8ddcd7c2|ef2b7610, community_member.dashboard.articles|100581518|f9009c4f|8c088bbb|4c9714e1||3e165e0, community_member.dashboard.events|778661710|821f786|7056653f|3a8bc352||d9f79213, community_member.dashboard.news-items|307302786|16edb422|4679983d|698e19fc||46ad4505, community_member.dashboard.podcasts|1958649010|cc016a85|2b78bde2|2c80f95a||e13d85da, ',
'community_member.emails|1007955862|3a6a952a||65e2da75|6a1da247|503f9ddb, community_member.events|1653494123|d5ca5a8f|ff5a4510|4f15d11d|9666ae76|b51f1596, community_member.event_recurrences|921385375|4fbca19a|62afa26e|6fac24b4|6e3b9ff7|89df8674, community_member.gallery-albums|155055207|3400f1e8|d86ebc74|5354fa81|9b8d39fc|e8c537d0, community_member.gallery-images|2018430577|7268e9c6|53181aaf|c3b9e0e5|8e420d83|b86c351c, community_member.membership|1894826559|2efeefc1||aae07868|ae1dcadb|4de28d6c, ',
'community_member.news-items|1641961006|10b5687|2bfe6ddf|73821501|14ec7461|60c63718, community_member.podcasts|997844663|a0b4e2fb|3131b1ff|5d405bdb|77e1fbf8|2b2f5813, community_member.podcast_albums|2033952651|32268213|3f7136b0|43501dc3|a4c9d333|377b24f2, community_member.signup|966413259|80ff28f4||4cd08e70|8a138212|e89f4d57, component|18|2700fe3c||b326fa9c|801edfde|b6de4f99, contact|455348469|65b6b21c|d41f24a4|95fe0d41|d67e4b1e|9e0e4578, Contact Lookup|1637270565|5a8e3307||9f547eea||b5d9e3d5, ',
'content_block|520026104|ab8fcb70||ff82c311|e6e56a49|c2b1da02, credit_memo_change_history|2098763691|6ee49fff||2533ebda||10463362, credit_memo_status|1476582498|3f93eb4||c5c53b4d||f867b3a4, custom-registration|1554477889|7d31f613||c9253bc3|76571384|4a016bd6, custom_forms|2008354714|549bf021||654676f9|98c5e745|24b3cd76, dashboard_persons_pending|192989725|4df4d69b||181caf4c||bdab1101, db_export|35|ebb261e8||||cd615433, ecl_tags|436943101|5a34b106||7791396d|66bbd6c5|5be9bd72, ',
'ecommerce_options|933478782|b1c1cbbb||||c2eae0c4, email_wizard|1762340055|718109a1||||d1689f8b, events|1|b779eba5|f808f2cb|c49de00a|29422c6|2fc0cbf0, event_recurrences|775190392|79acd96a|9a0762e7|46ab39be|e697cd7b|e2acc4c6, event_registrants|33|1b448c61||c8056634|8d98ee4f|ae8f1044, field_templates|653541528|e7ee46d4||918b8981|90ff51ee|c80aa42f, gallery-albums|643449733|c1721585|c387d8e1|ff7b1090|22a8c140|dbbbfc46, ',
'gallery-albums-for-gallery-album|1974205589|50e70211|ca949b6f|dafb2d05|c2c3e473|3bae72a8, gallery-images|735315841|773f0c02|dd9ff45a|166a5f7d|b81d9965|a3f37b51, gallery-images-for-gallery-album|157378518|aa3767bd|f5614a7d|9f544374|4aaa1d4a|c4ffd737, gateway_settings_beanstream|2100956420|584f6d1d||ab1b9de5|e4d9f2c2|677efb3f, gateway_settings_chasepaymentech|1256012063|45cf42c3||417a82b5|d0471838|837d9457, gateway_settings_paypal|1697487502|8836c53d||2f39518|cc197f37|56c58c1a, ',
'gateway_type|1692645997|a87286d0||6bbd70f8|2e03413|3429c04a, geocode-cache|655193664|33e50add|bcfb6a54|9d74aca3|f63c040f|a390b7a6, groups|794898891|9549a9e9||9c8b14d9|51379787|17ac486e, group_members|2016217854|f6cd3140||d96c012b|164361f7|9ecdc6e6, image_template|149372726|d00b2d95||c00624c9|6760c180|b62c2297, job-postings|905005130|ab3b59dd|a04c13cc|9d4d0e4c|e2a10b14|a44d6ebf, keywords|1950810505|7b0cf843||d22b9849|c680e791|e1d1cf8d, layouts|19|ba856cae||4f4e009e|d656b1e6|715a5822, ',
'links|624031849|adf12483|1681be13|9ae03770|a83bd828|546ca33e, links-for-link|1162752923|8541cb00|79e8ac48|4c7c0e0a|de386b71|4712f163, listdata|24|dea53221||8a340e84|e82bb0a7|1995402a, listdata_for_listtype|236636335|f4c96a32||78690420|32b45f24|363f5188, listtype|21|c9c161b1||7b689f00|dac24962|6a5d5da5, listtype_icon|101266328|8d55d8c5||||81cc15da, lst_column_types|13|2ad82610||8f363fa7|7920a796|1103b170, lst_country|2|dcd171fc||82d00471|724b2c90|892257e3, ',
'lst_delivery_method|37939353|25df03a5||c0bfc6fe|cc6d4921|209364d, lst_delivery_status|418462548|c3d17aa5||5c345c47|da2763c0|9b037494, lst_effective_period_units|1208253402|5c9ec4cf||834f5b02|e8e203c5|1a6f3304, lst_font_face|23|77147cf4||f68d2e7a|839b2fe3|b09baf3e, lst_language|46236542|7dfa98fb||30abdd8a|62d61cae|9f01a345, lst_payment_status|714505724|1b50dde0||40d5a568|94d03992|eaf25f26, lst_persontitle|4|20777c8b||811b5ad5|462b2873|bfd4521d, ',
'lst_product_grouping_columns|698451747|5d77996||24731e08|e58da73e|42a8cb80, lst_product_type|745648469|fd46a152||c93d2c3f|fa07b055|17c733c6, lst_refund_status|1216572200|7c0eb267||8a265be1|34c82d0a|7bb66666, lst_sp|5|eac6084f||e01a6613|f5e49c3a|c090eb93, mailidentity|126779465|9ecc5e5b||cc88226d|a7893236|f53fb39f, mail_broadcast|255|193726e3||||57704fd1, mail_queue|2138721438|fa7d9e44||ae6d85d4|6d2954de|ae8c9719, mail_queue_items|553239922|4a13eeca||30bcef83|e266e780|3e2d2251, ',
'mail_templates|38|e3ec4c8c|e5dfd3e6|989c585f|38aaa75|9019da64, manage_credit_memos|10208891|311420a3||dc89ac4f|4445b355|27c03b88, manage_orders|411402082|56e84c64|63c6b14|62877845|23970647|6adbde3, manage_refunds|1681469982|bcbc1cbc||2b3f5942|25a7eaed|a32667d6, media_for_person|778735493|7eab02cc||ccceddea||f49613ed, membership-list|24752744|21a69c93||7419e64b|15d4e0de|7ad140f2, membership_rules_for_system|1320435098|5b8e4a12||8bc2610f||1e5a7ef8, metadata|135519260|8870e53||9ba6c6f9||8ad85ce8, ',
'my_registered_events|27|581c45e||ecdafef7|edb7bf06|9f76d016, my_registration_list_for_event|32|be9f807a||273936a7||b8c7279, navbuttons|14|7a413819|df4e26ed|c13332ac|5f71c5e8|2fd4b4fe, navbuttons_for_navsuite|387825988|6b3d151c|ae262fee|5773c766|8a8beec1|3a6921ec, navstyle|1735323904|fd387335|9488a262|65cad30d|5e9c06c3|7064907b, navsuite|15|243e1b05|16c02437|22356e15|8b328469|9b55875e, news-items|1392271173|be03d8a2|b2c3ef2e|26ba06cd|4dad73c1|a352c093, ',
'order_billing|79997869|cf9a2d92||d451941b||6837b529, order_change_history|996754020|2d1c490c||1402edbf||c7aab127, order_gateway_result|651333054|8af547b2||7c84e02a||4462582, order_shipping|848619315|7612fca9||e584ad2||2b0caeca, order_status|593231666|65dd2d5||770027ce||362d4c7e, pages|10|c429d17e|367f9a6a|1b358dd1|d57536|666d38a3, payment_method|869930013|8fb16920||59aec872|ac602fe4|95068a9, persons_pending|12|ff2fa5ec||469d67ed|cb105e3e|8aae0dc0, ',
'person_emails|676174365|f1b044a7||62dc7a60|a2a6eaaa|de3e6134, person_groups|1159004324|3c96dba2|aa8c9176|2a363d4a|bd71ba72|6cb7caac, person_notes|1649793430|4159991f||b02b9376|5802d3b9|500178f0, person_orders|1855304946|8439bbf||68f76414|8d3d097b|33887292, person_view_for_order_1|702938128|62fea7e0||780c1827||c472ea9a, person_view_for_order_2|377863590|b391ddbb||f20cb65d||367dccc5, podcast-albums|742378424|c99dab6a|c6345fe0|afee960b|2ecbce20|351f4642, ',
'podcast-albums-for-podcast-album|1271328360|468d9539|451b8663|6709398|eadff7a4|5bc6d23a, podcasts|2116829793|26216c5f|c1b0cf61|e2acdcb7|f04f21a6|dcb6e296, podcasts-for-podcast-album|56401861|4a657eae|a0eb81b4|b2d18869|a9200fd7|c6b80907, poll|2005713144|dc311bfc||bc39b03f|a8e6bc57|f3e25a80, poll_choice|1277341866|659e3d50||71ba9daa|5228e708|2f01c3e8, product|458194221|6e75b346||3fba885d|9665ecc4|62c97610, product-relationships-for-gallery-album|1879544356|e5321b23||5e7f9d80|48bbcbd2|cfe2038b, ',
'product-relationships-for-gallery-image|497515852|b4a1873||c4b05768|4ae98757|53c9f890, products_for_event|47618369|2e9bd1ef|c6a3b248|da28dafa|a85cd518|31b3a108, products_for_product_grouping|1913031016|f02faeb9||9061155c|a3b50751|96f7228, products_overview|532951207|a29907fa||c19de9a9|b16c5728|568e1c8c, product_grouping|372915493|4f45b0da||ef47ebd2|bab26f90|927e131f, registered_events|28|87c4ebad||3f72404|9683d864|2816ff68, ',
'relationships_for_product|731150601|e33948a5||ec70162e|796b32e1|3c48d6a9, report|11|87ef6e1c||ce3a33aa|580961d0|75230c4f, report_columns|7|4e8a72a5||f2ef4481|15a2fa25|ab3f166a, report_columns_for_report|1902651071|515f3dd1||80ff28|6748942|1abe5cb0, scheduler|194710800|18cba00||297405f4|c3c8c890|6e94172f, shop_manage_orders|95595756|b3d463dc||||6b5ddcd3, shop_orders_overview|1728073570|1cff87a6||||f57d7428, signup|26|852c1063||8d465a93||ada5db75, site_icon|647162652|ec66e7c||||dcc2e8fa, ',
'sponsors-for-sponsorship-plan|1247696435|55fdb248|511a0631|e458821a|59603903|9410d8b8, survey|1348198425|24e06c56|3194eb2|40f27029|bb869569|46b1affa, survey_blocks_for_survey|2006131675|60c25b76||e32a680c|39fca07e|d2789215, survey_responses_for_survey|1345514723|3376858a||f8be2276|bbfcc933|82e4574f, system|8|54218367||228c148c|fc751526|686a8012, tasks_for_case|430675239|100cb722|a2b945cd|b53c800c|3e420dea|d4f94565, tax_codes|59942561|33c1460c||4366bd0b|425d1b83|cf121f9f, ',
'tax_regime|561152653|9e93052||3d1d1dd8|9f837237|a6317bb1, tax_regimes_for_tax_zone|46991177|3e29f9d3||12754cb0|71957a65|50d08cf, tax_rules_for_tax_regime|182209916|168ed203||952da000|debe9f11|c8670884, tax_zones|2067747233|e67ffbdb||b73eafd|7e4008c8|21052d94, theme|2120608782|ae942c8e||87bc59b4|f514247d|b170d8e7, theme_accent_1|1091071801|435b0abc||9abc76ec||8b87ddb0, theme_accent_2|582376101|e4078b1b||19f337a2||15ede43f, theme_accent_3|2134717818|41df4aab||aaac63a7||10c29841, ',
'theme_accent_4|290642889|6ba260||c7275d0||9c2cb60b, theme_accent_5|920246873|5e431c2e||4a0aba67||874b13ac, theme_banner|1242434882|84fc02ad||73da9400||b0bcb516, tickets|2119451158|d91d0049||2ec563f1|4d86006a|4d95f1a2, treb_view_listings|622536265|f4074657|9eafb08c|7ec913f7|ebfc28a8|825ebbd3, treb_view_room_listings|979751350|2315e738||a4f04e3b||eefaf240, user|6|8acbb71a|447dddd0|2840daec|fb8e1b5c|b5b55302, User Lookup|1599889923|281d53ee||20e5b6d0||c8b7651f, ',
'user_activity_orders|1178493635|b36d6dd6||||8f87813a, view_credit_memos_for_order|118589083|2133a231||f9e5796||205c5b98, view_registered_events_for_order|1040680974|82ace8e4||fc18f7bf||4cf50b44, visitor_stats|1327825126|883bba55||||f11fa627, widget|1861367917|a1ec1ee4||9fc2dedc|c7c789d5|85a83add, your_cases|36207315|bda8af82|d3f30135|5a1db2cf|7ecea621|866be436, your_order_history|581815015|34aabc0b||4b8ed1||19438013');