Built motion from commit df3e9871f6bcc3432fec345b2f4facbd4dba8b5c. Version 3.0.0...

[motion-next.git] / server / migrations / 2.1.0.js

diff --git a/server/migrations/2.1.0.js b/server/migrations/2.1.0.js
index 23acd1b..9374371 100644 (file)
--- a/server/migrations/2.1.0.js
+++ b/server/migrations/2.1.0.js
@@ -1 +1 @@
-const a964_0x28f6=['\x20\x20SET\x20sectionId\x20=\x201003\x20WHERE\x20sectionId\x20>=\x20100000;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHERE\x20s.userProfileId\x20=\x20x.userProfileId\x20AND\x20s.sectionId\x20=\x20x.sectionId);','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20600\x20THEN\x20\x27DELETE\x27','\x20\x20GROUP\x20BY\x20userId;','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20701\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20sms_queues\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201003\x20THEN\x20\x27CustomDashboards\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201101\x20THEN\x20\x27ODBC\x27','\x20\x20SET\x20sectionId\x20=\x201801\x20WHERE\x20sectionId\x20between\x2088889\x20AND\x2099999;','\x20\x20FROM\x20tally\x20INNER\x20JOIN\x20tmpPermissions\x20t\x20ON\x20CHAR_LENGTH(t.userIds)\x20-\x20CHAR_LENGTH(REPLACE(t.userIds,\x20\x27,\x27,\x20\x27\x27))\x20>=\x20tally.n-1','\x20\x20INNER\x20JOIN\x20user_has_sms_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x201103\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20square_projects\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','\x20\x20FROM\x20tally\x20t\x20INNER\x20JOIN\x20tmpNormalizedSections\x20s\x20ON\x20CHAR_LENGTH(s.userId)\x20-\x20CHAR_LENGTH(REPLACE(s.userId,\x20\x27,\x27,\x20\x27\x27))\x20>=\x20t.n-1','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20tally\x20t\x20INNER\x20JOIN\x20tmpPermissions\x20r\x20ON\x20CHAR_LENGTH(r.userIds)\x20-\x20CHAR_LENGTH(REPLACE(r.userIds,\x20\x27,\x27,\x20\x27\x27))\x20>=\x20t.n-1','ADD\x20CONSTRAINT\x20`users_ibfk_1`\x20','\x20\x20KEY\x20`compositeIndex`\x20(`sectionId`,`userProfileId`),','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(301,\x20302,\x20303,\x20304)\x20THEN\x20\x27ContactManager\x27','addIndex\x20%s\x20%s\x20%s','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20tmpNormalizedUsers','\x20\x20WHERE\x20t1.name\x20=\x20t2.name\x20AND\x20t1.userProfileId\x20=\x20t2.userProfileId\x20AND\x20t1.sectionId\x20>\x20t2.sectionId;','\x20\x20);','\x20\x20SELECT\x20x.sectionId,\x20u.FaxAccountId,\x20x.userId','\x20\x20\x20\x20resourceId\x20int(11)\x20not\x20null,','\x20\x20PRIMARY\x20KEY\x20(`id`),','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20between\x2088889\x20AND\x2099999\x20THEN\x20\x27AppZone\x27','\x20\x20SELECT\x20id,\x20permissions,\x20null','\x20\x20SELECT\x20GROUP_CONCAT(sectionId\x20ORDER\x20BY\x20sectionId),\x20userId','INSERT\x20INTO\x20tmpSharedProfiles','INSERT\x20INTO\x20tmpFinalProfiles','addColumn','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ELSE\x20\x27\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20(select\x20SUBSTRING_INDEX(SUBSTRING_INDEX(r.userIds,\x20\x27,\x27,\x20t.n),\x20\x27,\x27,\x20-1)\x20userId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201007\x20THEN\x20\x27Sounds\x27','UPDATE\x20tmpSections','\x20\x20SELECT\x20GROUP_CONCAT(id),\x20permissions,\x20null','addIndex','stringify','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20402\x20THEN\x20\x27InboundRoutes\x27','changeColumn','\x20\x20INNER\x20JOIN\x20user_has_openchannel_accounts\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201200\x20THEN\x20\x27DELETE\x27','then','\x20\x20\x20\x20\x20\x20userIds\x20varchar(255)\x20not\x20null,','\x20\x20WHERE\x20name\x20in\x20(\x27Plugins\x27,\x20\x27CustomDashboards\x27);','\x20\x20\x20\x20insertedSectionId\x20int(11)\x20not\x20null,','renameColumn','\x20\x20SELECT\x20*','\x20\x20\x20\x20resourceId\x20text','(SELECT\x200\x20AS\x20N\x20UNION\x20ALL\x20SELECT\x201\x20UNION\x20ALL\x20SELECT\x202\x20UNION\x20ALL\x20SELECT\x203\x20UNION\x20ALL\x20SELECT\x204\x20UNION\x20ALL\x20SELECT\x205\x20UNION\x20ALL\x20SELECT\x206\x20UNION\x20ALL\x20SELECT\x207\x20UNION\x20ALL\x20SELECT\x208\x20UNION\x20ALL\x20SELECT\x209)\x20a','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20>=\x20100000\x20THEN\x20\x27Tools\x27','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpFinalProfiles;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20GROUP\x20BY\x20resourceId,\x20sectionId','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(1301,\x201302,\x201303,\x201305,\x201306,\x201307,\x201308)\x20THEN\x20\x27Integrations\x27','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpGroupedPermissions;','\x20\x20FROM\x20users','\x20\x20WHERE\x20split.userId\x20IN\x20(SELECT\x20*\x20FROM','queryInterface','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20902\x20THEN\x20\x27FaxAccounts\x27','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(202,\x20203,\x20204)\x20THEN\x20\x27Staff\x27','\x20\x20`userProfileId`\x20int(11)\x20DEFAULT\x20NULL,','\x20\x20\x20\x20\x20\x20\x20\x20fp.profileId\x20profileId,','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201008\x20THEN\x20\x27Tags\x27','CREATE\x20TABLE\x20tmpResources','\x20\x20`sectionId`\x20int(11)\x20NOT\x20NULL,','\x20\x20SELECT\x20x.sectionId,\x20u.SquareProjectId,\x20x.userId','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(601,\x20602,\x20603,\x20610)\x20THEN\x20\x27Mail\x27','\x20\x20SELECT\x20x.sectionId,\x20u.FaxQueueId,\x20x.userId','\x20\x20WHERE\x20x.sectionId\x20=\x20702;','\x20\x20WHERE\x20userProfileId\x20is\x20null\x20AND\x20role\x20=\x20\x27user\x27;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20);','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201000\x20THEN\x20\x27DELETE\x27','\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20tally','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20(SELECT\x20GROUP_CONCAT(userId\x20ORDER\x20BY\x20userId\x20ASC)\x20as\x20users','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20510\x20THEN\x20\x27Realtime\x27','migration','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpNormalizedResources;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20tally\x20t',',(SELECT\x200\x20AS\x20N\x20UNION\x20ALL\x20SELECT\x201\x20UNION\x20ALL\x20SELECT\x202\x20UNION\x20ALL\x20SELECT\x203\x20UNION\x20ALL\x20SELECT\x204\x20UNION\x20ALL\x20SELECT\x205\x20UNION\x20ALL\x20SELECT\x206\x20UNION\x20ALL\x20SELECT\x207\x20UNION\x20ALL\x20SELECT\x208\x20UNION\x20ALL\x20SELECT\x209)\x20d','\x20\x20\x20\x20\x20\x20CASE','INSERT\x20INTO\x20tmpNormalizedSections','\x20\x20WHERE\x20r.name\x20=\x20s.name\x20AND\x20r.userProfileId\x20=\x20s.userProfileId;','\x20\x20INNER\x20JOIN\x20user_has_voice_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','STRING','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(701,\x20702,\x20710)\x20THEN\x20\x27Sms\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201600\x20THEN\x20\x27Help\x27','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20802\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20openchannel_accounts\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','INSERT\x20INTO\x20tmpExtractedResources','Added\x20column\x20%s\x20to\x20%s','prototype','\x20\x20ORDER\x20BY\x20userId;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201701\x20THEN\x20\x27Projects\x27','\x20\x20SELECT\x20CONCAT(\x27Profile_\x27,\x20(SELECT\x20(@cnt\x20:=\x20@cnt\x20+\x201)\x20AS\x20rowNumber','\x20\x20SET\x20name\x20=\x20(SELECT','INSERT\x20INTO\x20user_profile_has_sections\x20(name,\x20category,\x20sectionId,\x20enabled,\x20autoAssociation,\x20crudPermissions,\x20createdAt,\x20updatedAt,\x20userProfileId)','\x20\x20\x20\x20category\x20varchar(255)\x20not\x20null,','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20CASE','\x20\x20FROM\x20tmpFinalProfiles\x20t','reportId','\x20\x20\x20\x20userId\x20text','\x20\x20WHERE\x20name\x20=\x20\x27DELETE\x27;','inspect','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20601\x20THEN\x20\x27MailQueues\x27','\x20\x20\x20\x20name\x20varchar(255)\x20not\x20null,','\x20\x20WHERE\x20x.sectionId\x20=\x20401\x20AND\x20q.type\x20=\x20\x27inbound\x27;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201500\x20THEN\x20\x27DELETE\x27','UPDATE\x20users\x20u,\x20tmpNormalizedPermissions\x20t','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(901,\x20902,\x20910)\x20THEN\x20\x27Fax\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201002\x20THEN\x20\x27Dispositions\x27','\x20\x20\x20\x20\x20\x20WHEN\x20x.type\x20=\x20\x27Plugins\x27\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20plugins\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','\x20\x20INNER\x20JOIN\x20user_has_fax_accounts\x20u\x20ON\x20u.UserId\x20=\x20x.userId','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpExtractedResources;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20502\x20THEN\x20\x27ChatWebsites\x27','Changed\x20column\x20%s\x20in\x20table\x20%s','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20405\x20THEN\x20\x27Contexts\x27','final','\x20\x20INNER\x20JOIN\x20user_has_chat_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20INNER\x20JOIN\x20user_has_openchannel_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20INNER\x20JOIN\x20user_has_mail_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20`enabled`\x20tinyint(1)\x20DEFAULT\x20NULL,','\x20\x20CONSTRAINT\x20`user_profile_has_resources_ibfk_1`\x20FOREIGN\x20KEY\x20(`sectionId`)\x20REFERENCES\x20`user_profile_has_sections`\x20(`id`)\x20ON\x20DELETE\x20CASCADE\x20ON\x20UPDATE\x20CASCADE','\x20\x20`createdAt`\x20datetime\x20NOT\x20NULL,','\x20\x20UNIQUE\x20KEY\x20`name`\x20(`name`)','\x20\x20`type`\x20varchar(255)\x20NOT\x20NULL,','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20601\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20mail_queues\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201307\x20THEN\x20\x27ZohoAccounts\x27','\x20\x20WHERE\x20userId\x20NOT\x20IN\x20(SELECT\x20split.userId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20403\x20THEN\x20\x27OutboundRoutes\x27','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpNormalizedUsers;','UPDATE\x20tmpNormalizedResources\x20x','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHERE\x20POSITION(\x27,\x27\x20in\x20r.userIds)\x20>\x200','CREATE\x20TABLE\x20tmpSingleProfiles','dropTable','\x20\x20ORDER\x20BY\x20GROUP_CONCAT(id);','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20303\x20THEN\x20\x27Contacts\x27','\x20\x20\x20\x20enabled\x20tinyint\x20not\x20null,','\x20\x20SELECT\x20x.sectionId,\x20u.MailQueueId,\x20x.userId','\x20\x20WHERE\x20x.sectionId\x20=\x20802;','\x20\x20SET\x20insertedId\x20=\x20(SELECT\x20id','UPDATE\x20tmpFinalProfiles','\x20\x20SET','\x20\x20\x20\x20insertedId\x20int(11),','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20901\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20fax_queues\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ORDER\x20BY\x20users)\x20b','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20800\x20THEN\x20\x27DELETE\x27','Renamed\x20column\x20from\x20%s\x20to\x20%s\x20on\x20%s','\x20\x20SELECT\x20DISTINCT\x20permission,\x20userId,\x200','\x20\x20\x20\x20sectionId\x20int(11)\x20not\x20null,','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20408\x20THEN\x20\x27VoiceRecordings\x27','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20502\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20chat_websites\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','\x20\x20SELECT\x20name,\x20category,\x20sectionId,\x20enabled,\x20autoAssociation,\x20\x27red\x27,\x20now(),\x20now(),\x20userProfileId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20610\x20THEN\x20\x27Realtime\x27','CREATE\x20TABLE\x20tmpFinalProfiles','\x20\x20\x20\x20permissions\x20text\x20not\x20null,','\x20\x20SELECT\x20userId,\x20permissions,\x20null','sequelize','\x20\x20\x20\x20t.permissions\x20permissions','\x20\x20SET\x20insertedId\x20=\x20(SELECT','table\x20dropped\x20%s','UPDATE\x20tmpSections\x20s','INSERT\x20INTO\x20tmpCustomResources','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20901\x20THEN\x20\x27FaxQueues\x27','\x20\x20SELECT\x20*\x20FROM\x20tmpSingleProfiles;',')\x20ENGINE=InnoDB\x20DEFAULT\x20CHARSET=utf8;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201308\x20THEN\x20\x27VtigerAccounts\x27','finally','query','\x20\x20SELECT\x20GROUP_CONCAT(userId),\x20permissions,\x20null','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20300\x20THEN\x20\x27DELETE\x27','\x20\x20\x20\x20\x20\x20\x20\x20r.type\x20type,','CREATE\x20TABLE\x20tmpExtractedResources\x20(','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20100\x20THEN\x20\x27Dashboards\x27','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpSections;','\x20\x20SELECT\x20userId,\x20permissions','\x20\x20\x20\x20\x20\x20\x20\x20ORDER\x20BY\x20n)\x20AS\x20split;','\x20\x20\x20\x20SUBSTRING_INDEX(SUBSTRING_INDEX(p.permissions,\x20\x27,\x27,\x20tally.n),\x20\x27,\x27,\x20-1)\x20permission,','\x20\x20WHERE\x20x.sectionId\x20=\x201103;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20204\x20THEN\x20\x27Teams\x27','\x20\x20category\x20=\x20(SELECT','\x20\x20WHERE\x20name\x20=\x20\x27DELETE_MIGRATION\x27;','\x20\x20\x20\x20userId\x20int(11)\x20not\x20null','\x20\x20SET\x20u.permissions\x20=\x20t.permissions','\x20\x20FROM\x20tmpFinalProfiles;','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20501\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20chat_queues\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','CREATE\x20TABLE\x20`user_profile_has_sections`\x20(','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20701\x20THEN\x20\x27SmsQueues\x27','removeIndex','\x20\x20INNER\x20JOIN\x20user_has_sms_accounts\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20\x20\x20\x20\x20\x20\x20r.sectionId\x20sectionId','INSERT\x20INTO\x20tmpNormalizedResources','CREATE\x20TABLE\x20tmpSharedProfiles','\x20\x20UNION','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20401\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20voice_queues\x20WHERE\x20id\x20=\x20x.resourceId\x20AND\x20type\x20=\x20\x27inbound\x27),\x27DELETE_MIGRATION\x27)','info','Removed\x20column\x20%s\x20from\x20%s','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(1401,\x201402,\x201403,\x201404,\x201405,\x201406,\x201407)\x20THEN\x20\x27DELETE\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201001\x20THEN\x20\x27CannedAnswers\x27','\x20\x20WHERE\x20u.id\x20=\x20t.userId;','\x20\x20WHERE\x20x.sectionId\x20=\x20601;','\x20\x20SET\x20u.userProfileId\x20=\x201','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20407\x20THEN\x20\x27MusicOnHolds\x27','\x20\x20WHERE\x20x.sectionId\x20=\x20901;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20name\x20=\x20\x27CustomDashboards\x27\x20THEN\x20(sectionId\x20-\x2099999)','INSERT\x20INTO\x20tmpSections','\x20\x20\x20\x20SUBSTRING_INDEX(SUBSTRING_INDEX(t.userIds,\x20\x27,\x27,\x20tally.n),\x20\x27,\x27,\x20-1)\x20userId,','UPDATE\x20tmpCustomResources\x20r,\x20tmpSections\x20s','INSERT\x20INTO\x20user_profile_has_resources\x20(name,\x20resourceId,\x20type,\x20createdAt,\x20updatedAt,\x20sectionId)','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20810\x20THEN\x20\x27Realtime\x27','\x20\x20FROM\x20tmpSections','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201103\x20THEN\x20\x27SquareProjects\x27','\x20\x20FROM\x20tally\x20INNER\x20JOIN\x20tmpPermissions\x20p\x20ON\x20CHAR_LENGTH(p.permissions)\x20-\x20CHAR_LENGTH(REPLACE(p.permissions,\x20\x27,\x27,\x20\x27\x27))\x20>=\x20tally.n-1','CREATE\x20TABLE\x20tmpNormalizedResources','UPDATE\x20users\x20u','\x20\x20WHERE\x20x.sectionId\x20=\x20502;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201502\x20THEN\x20\x27IvrCampaigns\x27','\x20\x20ORDER\x20BY\x20GROUP_CONCAT(userId);','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20902\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20fax_accounts\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','\x20\x20`updatedAt`\x20datetime\x20NOT\x20NULL,','\x20\x20END','\x20\x20\x20\x20\x20\x20profileId\x20int(11)','\x20\x20`autoAssociation`\x20tinyint(1)\x20DEFAULT\x20NULL,','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ORDER\x20BY\x20n)\x20as\x20split','INSERT\x20INTO\x20tmpNormalizedPermissions','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201006\x20THEN\x20\x27Scheduler\x27','\x20\x20SELECT\x20x.sectionId,\x20u.OpenchannelQueueId,\x20x.userId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20200\x20THEN\x20\x27DELETE\x27','\x20\x20FROM\x20(SELECT','INSERT\x20INTO\x20tmpSingleProfiles','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20203\x20THEN\x20\x27Telephones\x27','\x20\x20WHERE\x20role\x20=\x20\x27user\x27\x20and\x20permissions\x20is\x20not\x20null\x20and\x20permissions\x20<>\x20\x27\x27','\x20\x20KEY\x20`sectionId`\x20(`sectionId`),','\x20\x20FROM\x20tmpNormalizedUsers\x20x','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20SUBSTRING_INDEX(SUBSTRING_INDEX(r.userIds,\x20\x27,\x27,\x20t.n),\x20\x27,\x27,\x20-1)\x20userId','\x20\x20SET\x20profileId\x20=\x20(SELECT\x20(@cnt\x20:=\x20@cnt\x20+\x201)\x20AS\x20rowNumber','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20GROUP\x20BY\x20resourceId,\x20sectionId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20500\x20THEN\x20\x27DELETE\x27','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201701\x20THEN\x20\x27jscripty\x27','\x20\x20INNER\x20JOIN\x20user_has_square_projects\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHERE\x20POSITION(\x27,\x27\x20in\x20r.userIds)\x20>\x200','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20603\x20THEN\x20\x27MailSubstatuses\x27','\x20\x20FROM\x20tmpSections;','\x20\x20\x20\x20\x20\x20\x20\x20INNER\x20JOIN\x20tmpResources\x20r\x20ON\x20CHAR_LENGTH(r.resourceId)\x20-\x20CHAR_LENGTH(REPLACE(r.resourceId,\x20\x27,\x27,\x20\x27\x27))\x20>=\x20tally.n-1','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHERE\x20position(\x27,\x27\x20in\x20b.users)\x20=\x200))','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201301\x20THEN\x20\x27ZendeskAccounts\x27','INSERT\x20INTO\x20tmpNormalizedUsers','removeColumn','\x20\x20WHERE\x20x.sectionId\x20=\x20501;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201510\x20THEN\x20\x27Realtime\x27','\x20\x20\x20\x20\x20\x20SUBSTRING_INDEX(SUBSTRING_INDEX(s.userId,\x20\x27,\x27,\x20t.n),\x20\x27,\x27,\x20-1)\x20userId','\x20\x20\x20\x20\x20\x20permissions\x20text\x20not\x20null,','reportType','enqueue','userProfileId','\x20\x20WHERE\x20x.sectionId\x20=\x20801;','\x20\x20SET\x20autoAssociation\x20=\x201\x20WHERE\x20sectionId\x20=\x20100;','DELETE\x20FROM\x20tmpNormalizedResources','INSERT\x20INTO\x20tmpResources','\x20\x20SELECT\x20x.sectionId,\x20u.OpenchannelAccountId,\x20x.userId','DELETE\x20FROM\x20tmpSections','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201303\x20THEN\x20\x27FreshdeskAccounts\x27','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20801\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20openchannel_queues\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','\x20\x20SELECT\x20x.sectionId,\x20u.ChatWebsiteId,\x20x.userId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20900\x20THEN\x20\x27DELETE\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201102\x20THEN\x20\x27SquareRecordings\x27','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x201501\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20voice_queues\x20WHERE\x20id\x20=\x20x.resourceId\x20AND\x20type\x20=\x20\x27outbound\x27),\x27DELETE_MIGRATION\x27)','SELECT\x20NULL\x20FROM','\x20\x20(','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20409\x20THEN\x20\x27ChanSpies\x27','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20100\x20THEN\x20\x27Dashboards\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201203\x20THEN\x20\x27Reports\x27','\x20\x20SELECT\x20\x27\x27,\x20insertedId,\x20name,\x20sectionId,\x20null','\x20\x20INNER\x20JOIN\x20user_has_mail_accounts\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201202\x20THEN\x20\x27ExtractedReports\x27','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20602\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20mail_accounts\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20501\x20THEN\x20\x27ChatQueues\x27','\x20\x20SELECT\x20\x27\x27,\x20\x27\x27,\x20permission,\x201,\x200,\x20profileId,\x20null,\x20userId','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20702\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20sms_accounts\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','\x20\x20`id`\x20int(11)\x20NOT\x20NULL\x20AUTO_INCREMENT,','\x20\x20userId\x20int(11)','\x20\x20`name`\x20varchar(255)\x20NOT\x20NULL,','\x20\x20\x20\x20\x20\x20type\x20varchar(255)\x20not\x20null,','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201400\x20THEN\x20\x27Settings\x27','\x20\x20CROSS\x20JOIN\x20(SELECT\x20@cnt\x20:=\x201)\x20as\x20dummy\x20LIMIT\x201)','\x20DROP\x20TABLE\x20IF\x20EXISTS\x20tally;','\x20\x20s.sectionId\x20permission,','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(1501,\x201502,\x201510)\x20THEN\x20\x27MotionDialer\x27','sequence',',(SELECT\x200\x20AS\x20N\x20UNION\x20ALL\x20SELECT\x201\x20UNION\x20ALL\x20SELECT\x202\x20UNION\x20ALL\x20SELECT\x203\x20UNION\x20ALL\x20SELECT\x204\x20UNION\x20ALL\x20SELECT\x205\x20UNION\x20ALL\x20SELECT\x206\x20UNION\x20ALL\x20SELECT\x207\x20UNION\x20ALL\x20SELECT\x208\x20UNION\x20ALL\x20SELECT\x209)\x20e','\x20\x20FROM\x20tmpNormalizedResources;','\x20\x20`description`\x20varchar(255)\x20DEFAULT\x20NULL,','\x20\x20\x20\x20\x20\x20\x20\x20r.insertedSectionId\x20insertedSectionId,','query\x20%s','FOREIGN\x20KEY\x20(`userProfileId`)\x20','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20400\x20THEN\x20\x27DELETE\x27','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpSingleProfiles;','\x20\x20\x20\x20\x20\x20WHEN\x20x.type\x20=\x20\x27CustomDashboards\x27\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20dashboards\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','removeIndex\x20%s\x20%s','\x20\x20\x20\x20\x20\x20insertedSectionId\x20int(11)\x20not\x20null,','\x20\x20\x20\x20\x20\x20END','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20802\x20THEN\x20\x27OpenchannelAccounts\x27','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpSharedProfiles;',',(SELECT\x200\x20AS\x20N\x20UNION\x20ALL\x20SELECT\x201\x20UNION\x20ALL\x20SELECT\x202\x20UNION\x20ALL\x20SELECT\x203\x20UNION\x20ALL\x20SELECT\x204\x20UNION\x20ALL\x20SELECT\x205\x20UNION\x20ALL\x20SELECT\x206\x20UNION\x20ALL\x20SELECT\x207\x20UNION\x20ALL\x20SELECT\x208\x20UNION\x20ALL\x20SELECT\x209)\x20b','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20406\x20THEN\x20\x27Voicemails\x27','\x20\x20`resourceId`\x20int(11)\x20NOT\x20NULL,','\x20\x20ORDER\x20BY\x20n)\x20AS\x20split;','catch','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20);','INTEGER','CREATE\x20TABLE\x20`user_profile_has_resources`\x20(','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20tmpNormalizedUsers','\x20\x20GROUP\x20BY\x20permissions','\x20\x20SET\x20r.sectionId\x20=\x20s.insertedId','tail','\x20\x20\x20\x20userProfileId\x20int(11)\x20not\x20null,','voice_voicemail','\x20\x20SELECT\x20\x27\x27,\x20resourceId,\x20type,\x20insertedSectionId,\x20sectionId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20(SELECT\x20GROUP_CONCAT(userId\x20ORDER\x20BY\x20userId\x20ASC)\x20AS\x20users','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201201\x20THEN\x20\x27Metrics\x27','DELETE\x20t1\x20FROM\x20tmpSections\x20t1,\x20tmpCustomResources\x20t2','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20202\x20THEN\x20\x27Agents\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20411\x20THEN\x20\x27Realtime\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201005\x20THEN\x20\x27Pauses\x27','\x20\x20SELECT\x20name,\x20resourceId,\x20type,\x20now(),\x20now(),\x20insertedSectionId','\x20\x20WHERE\x20x.sectionId\x20=\x201501\x20AND\x20q.type\x20=\x20\x27outbound\x27;','\x20\x20\x20\x20\x20\x20sectionId\x20int(11)','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201010\x20THEN\x20\x27Triggers\x27','\x20\x20\x20\x20\x20\x20name\x20=\x20(SELECT','ALTER\x20TABLE\x20`users`\x20','INSERT\x20INTO\x20tally\x20(n)','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201501\x20THEN\x20\x27QueueCampaigns\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20302\x20THEN\x20\x27Companies\x27','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(401,\x20402,\x20403,\x20404,\x20405,\x20406,\x20407,\x20408,\x20409,\x20410,\x20411)\x20THEN\x20\x27Voice\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20401\x20THEN\x20\x27VoiceQueues\x27','\x20\x20WHERE\x20userId\x20IN\x20(SELECT\x20split.userId','\x20\x20FROM\x20tmpCustomResources;','\x20\x20n\x20INT\x20NOT\x20NULL\x20AUTO_INCREMENT\x20PRIMARY\x20KEY','\x20\x20SELECT\x20x.sectionId,\x20u.SmsAccountId,\x20x.userId','VALUES\x20(\x27Default\x27,\x20\x27red\x27,\x20NULL,\x20NOW(),\x20NOW());','\x20\x20\x20\x20\x20\x20permissions\x20text\x20not\x20null','\x20\x20`crudPermissions`\x20varchar(255)\x20NOT\x20NULL\x20DEFAULT\x20\x27r\x27,','\x20\x20\x20\x20\x20\x20WHEN\x20name\x20=\x20\x27Plugins\x27\x20THEN\x20(sectionId\x20-\x2088888)','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201012\x20THEN\x20\x27Variables\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20301\x20THEN\x20\x27Lists\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201400\x20THEN\x20\x27Settings\x27','INSERT\x20INTO\x20tmpPermissions','INSERT\x20INTO\x20user_profiles\x20(name,\x20crudPermissions,\x20createdAt,\x20updatedAt)','\x20\x20\x20\x20\x20\x20userId\x20text\x20not\x20null,','TRUNCATE\x20TABLE\x20tmpPermissions;','CREATE\x20TABLE\x20tmpNormalizedUsers','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(1001,\x201002,\x201003,\x201004,\x201005,\x201006,\x201007,\x201008,\x201009,\x201010,\x201011,\x201012)\x20THEN\x20\x27Tools\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20304\x20THEN\x20\x27GlobalCustomFields\x27','CREATE\x20TABLE\x20tmpNormalizedPermissions','\x20\x20FROM\x20tmpGroupedPermissions','CREATE\x20TABLE\x20tmpCustomResources','\x20\x20sectionId\x20int(11)\x20not\x20null,','\x20\x20ORDER\x20BY\x20id;','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(1101,\x201102,\x201103)\x20THEN\x20\x27CallySquare\x27','\x20\x20INNER\x20JOIN\x20user_has_fax_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20INNER\x20JOIN\x20tmpPermissions\x20r\x20on\x20CHAR_LENGTH(r.userIds)\x20-\x20CHAR_LENGTH(REPLACE(r.userIds,\x20\x27,\x27,\x20\x27\x27))\x20>=\x20t.n-1','\x20\x20CONSTRAINT\x20`user_profile_has_sections_ibfk_1`\x20FOREIGN\x20KEY\x20(`userProfileId`)\x20REFERENCES\x20`user_profiles`\x20(`id`)\x20ON\x20DELETE\x20CASCADE\x20ON\x20UPDATE\x20CASCADE','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201300\x20THEN\x20\x27DELETE\x27','analytics_extracted_reports','\x20\x20INNER\x20JOIN\x20voice_queues\x20q\x20ON\x20u.VoiceQueueId\x20=\x20q.id','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20700\x20THEN\x20\x27DELETE\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20),','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201305\x20THEN\x20\x27SugarcrmAccounts\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201009\x20THEN\x20\x27Templates\x27'];(function(_0x2a4896,_0x28f619){const _0x369fc6=function(_0x4e7a54){while(--_0x4e7a54){_0x2a4896['push'](_0x2a4896['shift']());}};_0x369fc6(++_0x28f619);}(a964_0x28f6,0x1f0));const a964_0x369f=function(_0x2a4896,_0x28f619){_0x2a4896=_0x2a4896-0x0;let _0x369fc6=a964_0x28f6[_0x2a4896];return _0x369fc6;};const _0x247fa6=a964_0x369f;'use strict';const util=require('util'),logger=require('../config/logger')(_0x247fa6('0x133')),Sequence=function(){};Sequence[_0x247fa6('0x141')][_0x247fa6('0x76')]=function(_0x4e7a54){const _0x70a46a=_0x247fa6;this[_0x70a46a('0xb3')]=this[_0x70a46a('0xb3')]?this[_0x70a46a('0xb3')][_0x70a46a('0x20')](_0x4e7a54):_0x4e7a54();};const Migration=function(_0x380352){const _0x3915b6=_0x247fa6;this[_0x3915b6('0x121')]=_0x380352,this['sequence']=new Sequence();};Migration['prototype'][_0x247fa6('0x10f')]=function(_0x3d6a52,_0xfda9ae,_0x1f0a70){const _0x48faff=_0x247fa6,_0x32a8aa=this;this[_0x48faff('0x99')]['enqueue'](function(){const _0x4fb640=_0x48faff;return _0x32a8aa[_0x4fb640('0x121')][_0x4fb640('0x10f')](_0x3d6a52,_0xfda9ae,_0x1f0a70)[_0x4fb640('0x112')](function(){const _0x36f270=_0x4fb640;logger[_0x36f270('0x3c')](_0x36f270('0x159'),_0xfda9ae,_0x3d6a52);})['catch'](function(_0x30482f){const _0x2178e9=_0x4fb640;logger['info'](JSON[_0x2178e9('0x10d')](_0x30482f));});});},Migration[_0x247fa6('0x141')]['addColumn']=function(_0x1e95db,_0x18637a,_0x164067){const _0x59c488=_0x247fa6,_0x86f0b8=this;this[_0x59c488('0x99')]['enqueue'](function(){const _0x221bbe=_0x59c488;return _0x86f0b8[_0x221bbe('0x121')][_0x221bbe('0x106')](_0x1e95db,_0x18637a,_0x164067)[_0x221bbe('0x112')](function(){const _0x23348a=_0x221bbe;logger[_0x23348a('0x3c')](_0x23348a('0x140'),_0x18637a,_0x1e95db);})[_0x221bbe('0xac')](function(_0x96beb1){const _0x26f899=_0x221bbe;logger[_0x26f899('0x3c')](JSON[_0x26f899('0x10d')](_0x96beb1));});});},Migration['prototype'][_0x247fa6('0x16c')]=function(_0x3d11f0){const _0x540168=_0x247fa6,_0x2c4711=this;this[_0x540168('0x99')][_0x540168('0x76')](function(){const _0x3e552d=_0x540168;return _0x2c4711['queryInterface'][_0x3e552d('0x16c')](_0x3d11f0,{'force':!![]})['then'](function(){const _0x5a0a1b=_0x3e552d;logger[_0x5a0a1b('0x3c')](_0x5a0a1b('0x19'),_0x3d11f0);})[_0x3e552d('0xac')](function(_0x45117d){const _0xbf2737=_0x3e552d;logger['info'](JSON[_0xbf2737('0x10d')](_0x45117d));});});},Migration[_0x247fa6('0x141')][_0x247fa6('0x10c')]=function(_0x465422,_0x426b4b,_0x12bff5){const _0x5abdd9=_0x247fa6,_0x29ad6b=this;this[_0x5abdd9('0x99')][_0x5abdd9('0x76')](function(){const _0x5bc47c=_0x5abdd9;return _0x29ad6b['queryInterface']['addIndex'](_0x465422,_0x426b4b,{'indexName':_0x12bff5})[_0x5bc47c('0x112')](function(){const _0x2d99b8=_0x5bc47c;logger[_0x2d99b8('0x3c')](_0x2d99b8('0xfa'),_0x465422,_0x426b4b['join'](','),_0x12bff5);})[_0x5bc47c('0xac')](function(_0x42eaa0){const _0x11f6bb=_0x5bc47c;logger['info'](JSON[_0x11f6bb('0x10d')](_0x42eaa0));});});},Migration['prototype'][_0x247fa6('0x35')]=function(_0xb6cada,_0xa88d2a){const _0x5e8ba0=_0x247fa6,_0x24b97b=this;this[_0x5e8ba0('0x99')]['enqueue'](function(){const _0x226bef=_0x5e8ba0;return _0x24b97b[_0x226bef('0x121')][_0x226bef('0x35')](_0xb6cada,_0xa88d2a)['then'](function(){const _0x3123c4=_0x226bef;logger[_0x3123c4('0x3c')](_0x3123c4('0xa3'),_0xb6cada,_0xa88d2a);})[_0x226bef('0xac')](function(_0x2d75fd){const _0xafb5d5=_0x226bef;logger['info'](JSON[_0xafb5d5('0x10d')](_0x2d75fd));});});},Migration['prototype']['query']=function(_0x286878){const _0x20caa9=_0x247fa6,_0x242ecb=this;this[_0x20caa9('0x99')][_0x20caa9('0x76')](function(){const _0x2d1862=_0x20caa9;return _0x242ecb[_0x2d1862('0x121')][_0x2d1862('0x16')][_0x2d1862('0x21')](_0x286878)[_0x2d1862('0x112')](function(){const _0x1d1c87=_0x2d1862;logger[_0x1d1c87('0x3c')](_0x1d1c87('0x9e'),_0x286878);})[_0x2d1862('0xac')](function(_0x2e3196){const _0x1f6a26=_0x2d1862;logger['info'](JSON[_0x1f6a26('0x10d')](_0x2e3196));});});},Migration[_0x247fa6('0x141')][_0x247fa6('0x70')]=function(_0x56eee7,_0x2ff4b8){const _0x2ec7de=_0x247fa6,_0x3b1b27=this;this[_0x2ec7de('0x99')][_0x2ec7de('0x76')](function(){const _0x41f4ee=_0x2ec7de;return _0x3b1b27[_0x41f4ee('0x121')]['removeColumn'](_0x56eee7,_0x2ff4b8)[_0x41f4ee('0x112')](function(){const _0x3388dc=_0x41f4ee;logger[_0x3388dc('0x3c')](_0x3388dc('0x3d'),_0x2ff4b8,_0x56eee7);})['catch'](function(_0x1cac98){const _0x52143e=_0x41f4ee;logger['info'](util[_0x52143e('0x14d')](_0x1cac98,{'showHidden':![],'depth':null}));});});},Migration[_0x247fa6('0x141')][_0x247fa6('0x116')]=function(_0x3373b6,_0x3a4de5,_0x578421){const _0xeb9ca=_0x247fa6,_0x4e5593=this;this[_0xeb9ca('0x99')][_0xeb9ca('0x76')](function(){const _0x24b08c=_0xeb9ca;return _0x4e5593['queryInterface']['renameColumn'](_0x3373b6,_0x3a4de5,_0x578421)[_0x24b08c('0x112')](function(){const _0x5721cd=_0x24b08c;logger[_0x5721cd('0x3c')](_0x5721cd('0xc'),_0x3a4de5,_0x578421,_0x3373b6);})['catch'](function(_0x1319a4){const _0x5afd8e=_0x24b08c;logger[_0x5afd8e('0x3c')](util[_0x5afd8e('0x14d')](_0x1319a4,{'showHidden':![],'depth':null}));});});},Migration[_0x247fa6('0x141')][_0x247fa6('0x15b')]=function(_0x24229b){const _0x388243=_0x247fa6;this[_0x388243('0x99')][_0x388243('0x76')](function(){return _0x24229b();});},module['exports']={'up':function(_0x1799ec,_0xfad5a6){return new Promise(function(_0x3ababe){const _0x429067=a964_0x369f,_0x1850cc=new Migration(_0x1799ec);_0x1850cc[_0x429067('0x106')](_0x429067('0xe4'),_0x429067('0x14a'),{'type':_0xfad5a6[_0x429067('0xae')]}),_0x1850cc[_0x429067('0x106')](_0x429067('0xe4'),_0x429067('0x75'),{'type':_0xfad5a6[_0x429067('0x13b')]}),_0x1850cc[_0x429067('0x106')]('users',_0x429067('0x77'),{'type':_0xfad5a6[_0x429067('0xae')]}),_0x1850cc['removeColumn'](_0x429067('0xb5'),'name'),_0x1850cc[_0x429067('0x21')]('CREATE\x20TABLE\x20`user_profiles`\x20('+'\x20\x20`id`\x20int(11)\x20NOT\x20NULL\x20AUTO_INCREMENT,'+'\x20\x20`name`\x20varchar(255)\x20NOT\x20NULL,'+_0x429067('0xce')+_0x429067('0x9c')+_0x429067('0x161')+_0x429067('0x54')+'\x20\x20PRIMARY\x20KEY\x20(`id`),'+_0x429067('0x162')+_0x429067('0x1e')),_0x1850cc[_0x429067('0x21')]('INSERT\x20INTO\x20`user_profiles`\x20(`name`,\x20`crudPermissions`,\x20`description`,\x20`createdAt`,\x20`updatedAt`)'+_0x429067('0xcc')),_0x1850cc['query'](_0x429067('0xc2')+_0x429067('0xf7')+_0x429067('0x9f')+'REFERENCES\x20user_profiles(`id`)\x20'+'ON\x20UPDATE\x20CASCADE'),_0x1850cc[_0x429067('0x21')](_0x429067('0x33')+_0x429067('0x90')+_0x429067('0x92')+'\x20\x20`category`\x20varchar(255)\x20NOT\x20NULL,'+_0x429067('0x128')+_0x429067('0x15f')+_0x429067('0x57')+'\x20\x20`crudPermissions`\x20varchar(255)\x20DEFAULT\x20NULL,'+_0x429067('0x161')+'\x20\x20`updatedAt`\x20datetime\x20NOT\x20NULL,'+_0x429067('0x124')+_0x429067('0x100')+'\x20\x20KEY\x20`userProfileId`\x20(`userProfileId`),'+_0x429067('0xf8')+_0x429067('0xe2')+_0x429067('0x1e')),_0x1850cc[_0x429067('0x21')](_0x429067('0xaf')+_0x429067('0x90')+_0x429067('0x92')+_0x429067('0xaa')+_0x429067('0x163')+_0x429067('0x161')+_0x429067('0x54')+'\x20\x20`sectionId`\x20int(11)\x20DEFAULT\x20NULL,'+_0x429067('0x100')+_0x429067('0x61')+'\x20\x20KEY\x20`compositeIndex`\x20(`resourceId`,`sectionId`),'+_0x429067('0x160')+_0x429067('0x1e')),_0x1850cc['query']('CREATE\x20TABLE\x20tally\x20('+_0x429067('0xca')+');'),_0x1850cc[_0x429067('0x21')](_0x429067('0xc3')+_0x429067('0x84')+_0x429067('0x119')+_0x429067('0xa8')+',(SELECT\x200\x20AS\x20N\x20UNION\x20ALL\x20SELECT\x201\x20UNION\x20ALL\x20SELECT\x202\x20UNION\x20ALL\x20SELECT\x203\x20UNION\x20ALL\x20SELECT\x204\x20UNION\x20ALL\x20SELECT\x205\x20UNION\x20ALL\x20SELECT\x206\x20UNION\x20ALL\x20SELECT\x207\x20UNION\x20ALL\x20SELECT\x208\x20UNION\x20ALL\x20SELECT\x209)\x20c'+_0x429067('0x136')+_0x429067('0x9a')+';'),_0x1850cc[_0x429067('0x21')]('CREATE\x20TABLE\x20tmpPermissions'+_0x429067('0x85')+_0x429067('0x113')+'\x20\x20\x20\x20\x20\x20permissions\x20text\x20not\x20null,'+_0x429067('0x56')+_0x429067('0xfd')),_0x1850cc[_0x429067('0x21')](_0x429067('0xd3')+_0x429067('0x102')+_0x429067('0x11f')+'\x20\x20WHERE\x20role\x20=\x20\x27user\x27\x20and\x20permissions\x20is\x20not\x20null\x20and\x20permissions\x20<>\x20\x27\x27'+_0x429067('0xde')),_0x1850cc[_0x429067('0x21')]('CREATE\x20TABLE\x20tmpNormalizedSections'+'\x20\x20('+_0x429067('0xe')+'\x20\x20\x20\x20userId\x20text,'+_0x429067('0x118')+_0x429067('0xfd')),_0x1850cc[_0x429067('0x21')](_0x429067('0x138')+_0x429067('0xd')+_0x429067('0x5d')+_0x429067('0x2a')+'\x20\x20\x20\x20p.userIds\x20userId'+_0x429067('0x4d')+'\x20\x20ORDER\x20BY\x20n)\x20AS\x20split;'),_0x1850cc[_0x429067('0x21')](_0x429067('0xda')+_0x429067('0x85')+_0x429067('0x14')+_0x429067('0x2f')+_0x429067('0xfd')),_0x1850cc[_0x429067('0x21')](_0x429067('0x59')+_0x429067('0x103')+'\x20\x20FROM\x20tmpNormalizedSections'+_0x429067('0xed')),_0x1850cc[_0x429067('0x21')](_0x429067('0x152')+_0x429067('0x30')+_0x429067('0x40')),_0x1850cc[_0x429067('0x21')](_0x429067('0xd6')),_0x1850cc[_0x429067('0x21')](_0x429067('0xd3')+_0x429067('0x10b')+_0x429067('0x11f')+_0x429067('0x60')+_0x429067('0xb1')+_0x429067('0x0')),_0x1850cc['query'](_0x429067('0xd7')+'\x20\x20('+_0x429067('0xe')+'\x20\x20\x20\x20userId\x20text,'+_0x429067('0x118')+_0x429067('0xfd')),_0x1850cc[_0x429067('0x21')](_0x429067('0x6f')+'\x20\x20SELECT\x20permission,\x20userId,\x200'+_0x429067('0x5d')+_0x429067('0x97')+_0x429067('0x73')+_0x429067('0xf5')+_0x429067('0xab')),_0x1850cc[_0x429067('0x21')](_0x429067('0x25')+_0x429067('0xdd')+'\x20\x20resourceId\x20int(11),'+_0x429067('0x91')+_0x429067('0xfd')),_0x1850cc[_0x429067('0x21')](_0x429067('0x13f')+'\x20\x20SELECT\x20x.sectionId,\x20u.VoiceQueueId,\x20x.userId'+_0x429067('0x62')+_0x429067('0x13a')+_0x429067('0xe5')+_0x429067('0x150')),_0x1850cc[_0x429067('0x21')](_0x429067('0x13f')+'\x20\x20SELECT\x20x.sectionId,\x20u.ChatQueueId,\x20x.userId'+_0x429067('0x62')+_0x429067('0x15c')+_0x429067('0x71')),_0x1850cc[_0x429067('0x21')](_0x429067('0x13f')+_0x429067('0x80')+_0x429067('0x62')+'\x20\x20INNER\x20JOIN\x20user_has_chat_websites\x20u\x20ON\x20u.UserId\x20=\x20x.userId'+_0x429067('0x50')),_0x1850cc[_0x429067('0x21')](_0x429067('0x13f')+_0x429067('0x3')+_0x429067('0x62')+_0x429067('0x15e')+_0x429067('0x41')),_0x1850cc['query'](_0x429067('0x13f')+'\x20\x20SELECT\x20x.sectionId,\x20u.MailAccountId,\x20x.userId'+_0x429067('0x62')+_0x429067('0x8a')+'\x20\x20WHERE\x20x.sectionId\x20=\x20602;'),_0x1850cc[_0x429067('0x21')](_0x429067('0x13f')+'\x20\x20SELECT\x20x.sectionId,\x20u.SmsQueueId,\x20x.userId'+_0x429067('0x62')+_0x429067('0xf3')+'\x20\x20WHERE\x20x.sectionId\x20=\x20701;'),_0x1850cc[_0x429067('0x21')](_0x429067('0x13f')+_0x429067('0xcb')+'\x20\x20FROM\x20tmpNormalizedUsers\x20x'+_0x429067('0x36')+_0x429067('0x12c')),_0x1850cc['query'](_0x429067('0x13f')+_0x429067('0x5b')+'\x20\x20FROM\x20tmpNormalizedUsers\x20x'+_0x429067('0x15d')+_0x429067('0x78')),_0x1850cc[_0x429067('0x21')](_0x429067('0x13f')+_0x429067('0x7c')+_0x429067('0x62')+_0x429067('0x110')+_0x429067('0x4')),_0x1850cc[_0x429067('0x21')](_0x429067('0x13f')+_0x429067('0x12b')+_0x429067('0x62')+_0x429067('0xe0')+_0x429067('0x44')),_0x1850cc[_0x429067('0x21')](_0x429067('0x13f')+_0x429067('0xfe')+'\x20\x20FROM\x20tmpNormalizedUsers\x20x'+_0x429067('0x156')+'\x20\x20WHERE\x20x.sectionId\x20=\x20902;'),_0x1850cc[_0x429067('0x21')](_0x429067('0x13f')+_0x429067('0x129')+'\x20\x20FROM\x20tmpNormalizedUsers\x20x'+_0x429067('0x68')+_0x429067('0x2b')),_0x1850cc[_0x429067('0x21')](_0x429067('0x13f')+'\x20\x20SELECT\x20x.sectionId,\x20u.VoiceQueueId,\x20x.userId'+_0x429067('0x62')+_0x429067('0x13a')+'\x20\x20INNER\x20JOIN\x20voice_queues\x20q\x20ON\x20u.VoiceQueueId\x20=\x20q.id'+_0x429067('0xbe')),_0x1850cc[_0x429067('0x21')]('CREATE\x20TABLE\x20tmpGroupedPermissions'+_0x429067('0x85')+_0x429067('0xd5')+_0x429067('0xcd')+_0x429067('0xfd')),_0x1850cc[_0x429067('0x21')]('INSERT\x20INTO\x20tmpGroupedPermissions'+_0x429067('0x28')+_0x429067('0x5d')+_0x429067('0x47')+_0x429067('0x17')+_0x429067('0xf2')+'\x20\x20ORDER\x20BY\x20n)\x20AS\x20split;'),_0x1850cc[_0x429067('0x21')](_0x429067('0x39')+'\x20\x20('+_0x429067('0x113')+_0x429067('0x74')+_0x429067('0x56')+'\x20\x20);'),_0x1850cc[_0x429067('0x21')](_0x429067('0x104')+_0x429067('0x22')+_0x429067('0xdb')+_0x429067('0x166')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20(SELECT'+_0x429067('0x63')+_0x429067('0x135')+_0x429067('0xe1')+_0x429067('0x16a')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ORDER\x20BY\x20n)\x20AS\x20split'+_0x429067('0x120')+_0x429067('0xb7')+_0x429067('0xb0')+_0x429067('0x11c')+_0x429067('0xa')+_0x429067('0x6d')+_0x429067('0xb1')+_0x429067('0x52')),_0x1850cc[_0x429067('0x21')](_0x429067('0x16b')+_0x429067('0x85')+'\x20\x20\x20\x20\x20\x20userId\x20text\x20not\x20null,'+_0x429067('0x74')+'\x20\x20\x20\x20\x20\x20profileId\x20int(11)'+_0x429067('0xfd')),_0x1850cc[_0x429067('0x21')](_0x429067('0x5e')+_0x429067('0x15')+'\x20\x20FROM\x20tmpGroupedPermissions'+_0x429067('0xc8')+_0x429067('0x108')+_0x429067('0xf6')+_0x429067('0x69')+_0x429067('0x58')+_0x429067('0x120')+_0x429067('0x131')+_0x429067('0xfb')+_0x429067('0x65')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ORDER\x20BY\x20users)\x20b'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHERE\x20position(\x27,\x27\x20in\x20b.users)\x20=\x200))'+_0x429067('0x142')),_0x1850cc[_0x429067('0x21')](_0x429067('0x13')+'\x20\x20('+'\x20\x20\x20\x20\x20\x20userId\x20text\x20not\x20null,'+_0x429067('0x74')+_0x429067('0x56')+_0x429067('0xfd')),_0x1850cc[_0x429067('0x21')](_0x429067('0x105')+'\x20\x20SELECT\x20*\x20FROM\x20tmpSharedProfiles'+_0x429067('0x3a')+_0x429067('0x1d')),_0x1850cc[_0x429067('0x21')](_0x429067('0xd4')+_0x429067('0x144')+_0x429067('0x149')+'\x20\x20CROSS\x20JOIN\x20(SELECT\x20@cnt\x20:=\x200)\x20as\x20dummy\x20LIMIT\x201)),\x20\x27red\x27,\x20now(),\x20now()'+_0x429067('0x31')),_0x1850cc[_0x429067('0x21')](_0x429067('0x6')+_0x429067('0x64')+'\x20\x20FROM\x20user_profiles\x20u'+_0x429067('0x95')),_0x1850cc['query']('CREATE\x20TABLE\x20tmpSections'+_0x429067('0x85')+_0x429067('0x14f')+_0x429067('0x147')+_0x429067('0xe')+'\x20\x20\x20\x20enabled\x20tinyint\x20not\x20null,'+'\x20\x20\x20\x20autoAssociation\x20tinyint\x20not\x20null,'+_0x429067('0xb4')+_0x429067('0x8')+_0x429067('0x14b')+_0x429067('0xfd')),_0x1850cc['query'](_0x429067('0x46')+_0x429067('0x8e')+_0x429067('0x5d')+_0x429067('0x125')+'\x20\x20\x20\x20\x20\x20\x20\x20SUBSTRING_INDEX(SUBSTRING_INDEX(fp.permissions,\x20\x27,\x27,\x20tally.n),\x20\x27,\x27,\x20-1)\x20permission,'+'\x20\x20\x20\x20\x20\x20\x20\x20SUBSTRING_INDEX(fp.userId,\x20\x27,\x27,\x201)\x20userId'+'\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20tally'+'\x20\x20\x20\x20\x20\x20\x20\x20INNER\x20JOIN\x20tmpFinalProfiles\x20fp\x20ON\x20CHAR_LENGTH(fp.permissions)\x20-\x20CHAR_LENGTH(REPLACE(fp.permissions,\x20\x27,\x27,\x20\x27\x27))\x20>=\x20tally.n-1'+_0x429067('0x29')),_0x1850cc['query'](_0x429067('0x10a')+_0x429067('0x7')+_0x429067('0xc1')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20CASE'+_0x429067('0x26')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20101\x20THEN\x20\x27DELETE\x27'+_0x429067('0x5c')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20201\x20THEN\x20\x27DELETE\x27'+_0x429067('0xba')+_0x429067('0x5f')+_0x429067('0x2c')+_0x429067('0x23')+_0x429067('0xd1')+_0x429067('0xc5')+_0x429067('0x1')+_0x429067('0xd9')+_0x429067('0xa0')+_0x429067('0xc7')+_0x429067('0x10e')+_0x429067('0x167')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20404\x20THEN\x20\x27InternalRoutes\x27'+_0x429067('0x15a')+_0x429067('0xa9')+_0x429067('0x43')+_0x429067('0xf')+_0x429067('0x86')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20410\x20THEN\x20\x27VoicePrefixes\x27'+_0x429067('0xbb')+_0x429067('0x66')+_0x429067('0x8d')+_0x429067('0x158')+_0x429067('0x132')+_0x429067('0xec')+_0x429067('0x14e')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20602\x20THEN\x20\x27MailAccounts\x27'+_0x429067('0x6a')+_0x429067('0x12')+_0x429067('0xe6')+_0x429067('0x34')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20702\x20THEN\x20\x27SmsAccounts\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20710\x20THEN\x20\x27Realtime\x27'+_0x429067('0xb')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20801\x20THEN\x20\x27OpenchannelQueues\x27'+_0x429067('0xa6')+_0x429067('0x4a')+_0x429067('0x81')+_0x429067('0x1c')+_0x429067('0x122')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20910\x20THEN\x20\x27Realtime\x27'+_0x429067('0x12f')+_0x429067('0x3f')+_0x429067('0x154')+_0x429067('0xef')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201004\x20THEN\x20\x27Intervals\x27'+_0x429067('0xbc')+_0x429067('0x5a')+_0x429067('0x109')+_0x429067('0x126')+_0x429067('0xe9')+_0x429067('0xc0')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201011\x20THEN\x20\x27Trunks\x27'+_0x429067('0xd0')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201100\x20THEN\x20\x27DELETE\x27'+_0x429067('0xf0')+_0x429067('0x82')+_0x429067('0x4c')+_0x429067('0x111')+_0x429067('0xb8')+_0x429067('0x8b')+_0x429067('0x88')+_0x429067('0xe3')+_0x429067('0x6e')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201302\x20THEN\x20\x27SalesforceAccounts\x27'+_0x429067('0x7e')+_0x429067('0xe8')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201306\x20THEN\x20\x27DeskAccounts\x27'+_0x429067('0x165')+_0x429067('0x1f')+_0x429067('0xd2')+_0x429067('0x3e')+_0x429067('0x151')+_0x429067('0xc4')+_0x429067('0x51')+_0x429067('0x72')+_0x429067('0x13d')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201601\x20THEN\x20\x27DELETE\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201700\x20THEN\x20\x27DELETE\x27'+_0x429067('0x143')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20between\x2088889\x20AND\x2099999\x20THEN\x20\x27Plugins\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20>=\x20100000\x20THEN\x20\x27CustomDashboards\x27'+_0x429067('0x107')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20END'+_0x429067('0xe7')+_0x429067('0x2d')+_0x429067('0x137')+_0x429067('0x87')+_0x429067('0x11a')+_0x429067('0x123')+_0x429067('0xf9')+_0x429067('0xc6')+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(501,\x20502,\x20510)\x20THEN\x20\x27Chat\x27'+_0x429067('0x12a')+_0x429067('0x13c')+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(801,\x20802,\x20810)\x20THEN\x20\x27Openchannel\x27'+_0x429067('0x153')+_0x429067('0xd8')+_0x429067('0xdf')+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(1201,\x201202,\x201203)\x20THEN\x20\x27Analytics\x27'+_0x429067('0x11d')+_0x429067('0x94')+_0x429067('0x98')+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201600\x20THEN\x20\x27Help\x27'+_0x429067('0x67')+_0x429067('0x101')+'\x20\x20\x20\x20\x20\x20\x20\x20ELSE\x20\x27\x27'+_0x429067('0xa5')+'\x20\x20);'),_0x1850cc[_0x429067('0x21')](_0x429067('0x7d')+_0x429067('0x14c')),_0x1850cc[_0x429067('0x21')](_0x429067('0xdc')+_0x429067('0x85')+_0x429067('0x14f')+_0x429067('0x147')+_0x429067('0xe')+_0x429067('0x2')+'\x20\x20\x20\x20autoAssociation\x20tinyint\x20not\x20null,'+_0x429067('0xb4')+_0x429067('0x8')+_0x429067('0x14b')+_0x429067('0xfd')),_0x1850cc[_0x429067('0x21')](_0x429067('0x1b')+_0x429067('0x117')+_0x429067('0x4b')+_0x429067('0x114')),_0x1850cc[_0x429067('0x21')](_0x429067('0xb9')+_0x429067('0xfc')),_0x1850cc[_0x429067('0x21')](_0x429067('0x10a')+_0x429067('0xf1')),_0x1850cc[_0x429067('0x21')](_0x429067('0x10a')+_0x429067('0xea')),_0x1850cc[_0x429067('0x21')](_0x429067('0x10a')+_0x429067('0x79')),_0x1850cc[_0x429067('0x21')]('UPDATE\x20tmpCustomResources'+_0x429067('0x18')+_0x429067('0x148')+_0x429067('0xcf')+_0x429067('0x45')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20END'+_0x429067('0xad')),_0x1850cc['query'](_0x429067('0x146')+_0x429067('0x11')+_0x429067('0x6b')),_0x1850cc[_0x429067('0x21')](_0x429067('0x1a')+_0x429067('0x5')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20user_profile_has_sections\x20x'+_0x429067('0xeb')),_0x1850cc[_0x429067('0x21')](_0x429067('0x48')+_0x429067('0xb2')+_0x429067('0x139')),_0x1850cc[_0x429067('0x21')](_0x429067('0x127')+_0x429067('0x85')+'\x20\x20\x20\x20\x20\x20resourceId\x20text,'+_0x429067('0x93')+_0x429067('0xa4')+_0x429067('0xbf')+_0x429067('0xfd')),_0x1850cc['query'](_0x429067('0x7b')+'\x20\x20SELECT\x20cr.resourceId,\x20name,\x20s.insertedId,\x20s.sectionId'+'\x20\x20FROM\x20tmpSections\x20s'+'\x20\x20INNER\x20JOIN\x20tmpExtractedResources\x20cr\x20ON\x20cr.userId\x20=\x20s.userId\x20AND\x20cr.sectionId\x20=\x20s.sectionId\x20AND\x20cr.resourceId\x20IS\x20NOT\x20NULL;'),_0x1850cc[_0x429067('0x21')](_0x429067('0x4e')+'\x20\x20('+_0x429067('0x14f')+_0x429067('0xff')+'\x20\x20\x20\x20type\x20varchar(255)\x20not\x20null,'+_0x429067('0x115')+'\x20\x20\x20\x20sectionId\x20int(11)'+'\x20\x20);'),_0x1850cc[_0x429067('0x21')](_0x429067('0x38')+_0x429067('0xb6')+_0x429067('0x5d')+'\x20\x20\x20\x20\x20\x20\x20\x20SUBSTRING_INDEX(SUBSTRING_INDEX(r.resourceId,\x20\x27,\x27,\x20tally.n),\x20\x27,\x27,\x20-1)\x20resourceId,'+_0x429067('0x24')+_0x429067('0x9d')+_0x429067('0x37')+_0x429067('0x130')+_0x429067('0x6c')+_0x429067('0x29')),_0x1850cc[_0x429067('0x21')](_0x429067('0x38')+_0x429067('0x89')+_0x429067('0xc9')),_0x1850cc['query'](_0x429067('0x169')+_0x429067('0x145')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20CASE'+_0x429067('0x3b')+_0x429067('0x32')+_0x429067('0x10')+_0x429067('0x164')+_0x429067('0x8c')+_0x429067('0xee')+_0x429067('0x8f')+_0x429067('0x7f')+_0x429067('0x13e')+_0x429067('0x9')+_0x429067('0x53')+_0x429067('0xf4')+_0x429067('0x83')+_0x429067('0x155')+_0x429067('0xa2')+_0x429067('0x55')+_0x429067('0x12e')),_0x1850cc[_0x429067('0x21')](_0x429067('0x7a')+_0x429067('0x2e')),_0x1850cc[_0x429067('0x21')](_0x429067('0x49')+_0x429067('0xbd')+_0x429067('0x9b')),_0x1850cc[_0x429067('0x21')]('UPDATE\x20users\x20u,\x20tmpFinalProfiles\x20f'+'\x20\x20SET\x20u.userProfileId\x20=\x20f.profileId'+'\x20\x20WHERE\x20u.id\x20=\x20f.userId;'),_0x1850cc[_0x429067('0x21')](_0x429067('0x4f')+_0x429067('0x42')+_0x429067('0x12d')),_0x1850cc[_0x429067('0x21')](_0x429067('0x96')),_0x1850cc[_0x429067('0x21')]('DROP\x20TABLE\x20IF\x20EXISTS\x20tmpPermissions;'),_0x1850cc[_0x429067('0x21')]('DROP\x20TABLE\x20IF\x20EXISTS\x20tmpNormalizedSections;'),_0x1850cc[_0x429067('0x21')](_0x429067('0x168')),_0x1850cc[_0x429067('0x21')](_0x429067('0x157')),_0x1850cc[_0x429067('0x21')](_0x429067('0x11e')),_0x1850cc['query'](_0x429067('0xa7')),_0x1850cc[_0x429067('0x21')](_0x429067('0xa1')),_0x1850cc['query'](_0x429067('0x11b')),_0x1850cc['query'](_0x429067('0x27')),_0x1850cc[_0x429067('0x21')]('DROP\x20TABLE\x20IF\x20EXISTS\x20tmpCustomResources;'),_0x1850cc[_0x429067('0x21')]('DROP\x20TABLE\x20IF\x20EXISTS\x20tmpResources;'),_0x1850cc[_0x429067('0x21')](_0x429067('0x134')),_0x1850cc[_0x429067('0x15b')](_0x3ababe);});},'down':function(){}};
\ No newline at end of file
+const a964_0x159a=['INSERT\x20INTO\x20tmpFinalProfiles','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201303\x20THEN\x20\x27FreshdeskAccounts\x27','enqueue','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x201501\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20voice_queues\x20WHERE\x20id\x20=\x20x.resourceId\x20AND\x20type\x20=\x20\x27outbound\x27),\x27DELETE_MIGRATION\x27)','\x20\x20\x20\x20sectionId\x20int(11)','final','\x20\x20WHERE\x20u.id\x20=\x20f.userId;','\x20\x20FROM\x20tally\x20t\x20INNER\x20JOIN\x20tmpNormalizedSections\x20s\x20ON\x20CHAR_LENGTH(s.userId)\x20-\x20CHAR_LENGTH(REPLACE(s.userId,\x20\x27,\x27,\x20\x27\x27))\x20>=\x20t.n-1','CREATE\x20TABLE\x20`user_profiles`\x20(','CREATE\x20TABLE\x20tmpSharedProfiles','\x20\x20FROM\x20tmpGroupedPermissions','\x20\x20SELECT\x20\x27\x27,\x20resourceId,\x20type,\x20insertedSectionId,\x20sectionId','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpResources;','\x20\x20\x20\x20\x20\x20\x20\x20INNER\x20JOIN\x20tmpFinalProfiles\x20fp\x20ON\x20CHAR_LENGTH(fp.permissions)\x20-\x20CHAR_LENGTH(REPLACE(fp.permissions,\x20\x27,\x27,\x20\x27\x27))\x20>=\x20tally.n-1','\x20\x20SET\x20name\x20=\x20(SELECT','\x20\x20FROM\x20tmpSections\x20s','\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20tally','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201002\x20THEN\x20\x27Dispositions\x27','finally','catch','\x20\x20\x20\x20\x20\x20sectionId\x20int(11)','queryInterface','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x201103\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20square_projects\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','\x20\x20\x20\x20\x20\x20userIds\x20varchar(255)\x20not\x20null,','\x20\x20\x20\x20\x20\x20\x20\x20ORDER\x20BY\x20n)\x20AS\x20split;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20INNER\x20JOIN\x20tmpPermissions\x20r\x20on\x20CHAR_LENGTH(r.userIds)\x20-\x20CHAR_LENGTH(REPLACE(r.userIds,\x20\x27,\x27,\x20\x27\x27))\x20>=\x20t.n-1','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(301,\x20302,\x20303,\x20304)\x20THEN\x20\x27ContactManager\x27','\x20\x20SELECT\x20cr.resourceId,\x20name,\x20s.insertedId,\x20s.sectionId','\x20\x20\x20\x20\x20\x20\x20\x20r.insertedSectionId\x20insertedSectionId,','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpNormalizedResources;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20100\x20THEN\x20\x27Dashboards\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20900\x20THEN\x20\x27DELETE\x27','Removed\x20column\x20%s\x20from\x20%s','\x20\x20INNER\x20JOIN\x20user_has_openchannel_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','STRING','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(1301,\x201302,\x201303,\x201305,\x201306,\x201307,\x201308)\x20THEN\x20\x27Integrations\x27','\x20\x20\x20\x20SUBSTRING_INDEX(SUBSTRING_INDEX(t.userIds,\x20\x27,\x27,\x20tally.n),\x20\x27,\x27,\x20-1)\x20userId,','\x20\x20WHERE\x20x.sectionId\x20=\x20902;','\x20\x20\x20\x20\x20\x20profileId\x20int(11)','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20401\x20THEN\x20\x27VoiceQueues\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201308\x20THEN\x20\x27VtigerAccounts\x27','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpCustomResources;','\x20\x20WHERE\x20x.sectionId\x20=\x20701;','FOREIGN\x20KEY\x20(`userProfileId`)\x20','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20(SELECT','\x20\x20SELECT\x20userId,\x20permissions,\x20null','\x20\x20SELECT\x20userId,\x20permissions','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20201\x20THEN\x20\x27DELETE\x27','\x20\x20\x20\x20\x20\x20WHEN\x20x.type\x20=\x20\x27CustomDashboards\x27\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20dashboards\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','\x20\x20SET\x20autoAssociation\x20=\x201\x20WHERE\x20sectionId\x20=\x20100;','\x20\x20CROSS\x20JOIN\x20(SELECT\x20@cnt\x20:=\x200)\x20as\x20dummy\x20LIMIT\x201)),\x20\x27red\x27,\x20now(),\x20now()','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20801\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20openchannel_queues\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','INSERT\x20INTO\x20tmpPermissions','CREATE\x20TABLE\x20tmpSections','\x20\x20SELECT\x20\x27\x27,\x20\x27\x27,\x20permission,\x201,\x200,\x20profileId,\x20null,\x20userId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHERE\x20POSITION(\x27,\x27\x20in\x20r.userIds)\x20>\x200','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20802\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20openchannel_accounts\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','\x20\x20\x20\x20\x20\x20type\x20varchar(255)\x20not\x20null,','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20408\x20THEN\x20\x27VoiceRecordings\x27','UPDATE\x20tmpSections','\x20\x20n\x20INT\x20NOT\x20NULL\x20AUTO_INCREMENT\x20PRIMARY\x20KEY','ON\x20UPDATE\x20CASCADE','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20401\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20voice_queues\x20WHERE\x20id\x20=\x20x.resourceId\x20AND\x20type\x20=\x20\x27inbound\x27),\x27DELETE_MIGRATION\x27)','\x20\x20\x20\x20\x20\x20WHEN\x20name\x20=\x20\x27Plugins\x27\x20THEN\x20(sectionId\x20-\x2088888)','\x20\x20SELECT\x20x.sectionId,\x20u.ChatQueueId,\x20x.userId','\x20\x20WHERE\x20role\x20=\x20\x27user\x27\x20and\x20permissions\x20is\x20not\x20null\x20and\x20permissions\x20<>\x20\x27\x27','\x20\x20SELECT\x20name,\x20resourceId,\x20type,\x20now(),\x20now(),\x20insertedSectionId','DELETE\x20FROM\x20tmpSections','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpSections;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20602\x20THEN\x20\x27MailAccounts\x27','CREATE\x20TABLE\x20tmpNormalizedSections','renameColumn','\x20\x20SELECT\x20\x27\x27,\x20insertedId,\x20name,\x20sectionId,\x20null','\x20\x20SET\x20sectionId\x20=\x201801\x20WHERE\x20sectionId\x20between\x2088889\x20AND\x2099999;','\x20\x20s.sectionId\x20permission,','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20502\x20THEN\x20\x27ChatWebsites\x27','DELETE\x20FROM\x20tmpNormalizedResources','\x20\x20\x20\x20sectionId\x20int(11)\x20not\x20null,','inspect','\x20\x20SELECT\x20*\x20FROM\x20tmpSingleProfiles;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHERE\x20position(\x27,\x27\x20in\x20b.users)\x20=\x200))','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20902\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20fax_accounts\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','\x20\x20\x20\x20t.permissions\x20permissions','Added\x20column\x20%s\x20to\x20%s','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHERE\x20s.userProfileId\x20=\x20x.userProfileId\x20AND\x20s.sectionId\x20=\x20x.sectionId);','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20303\x20THEN\x20\x27Contacts\x27','userProfileId','\x20\x20\x20\x20\x20\x20\x20\x20SUBSTRING_INDEX(SUBSTRING_INDEX(fp.permissions,\x20\x27,\x27,\x20tally.n),\x20\x27,\x27,\x20-1)\x20permission,','\x20\x20\x20\x20userId\x20int(11)\x20not\x20null','\x20\x20WHERE\x20x.sectionId\x20=\x20502;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201600\x20THEN\x20\x27Help\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20405\x20THEN\x20\x27Contexts\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20tmpNormalizedUsers','\x20\x20GROUP\x20BY\x20permissions','\x20\x20\x20\x20insertedId\x20int(11),','CREATE\x20TABLE\x20tmpNormalizedResources','\x20\x20SELECT\x20id,\x20permissions,\x20null','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20901\x20THEN\x20\x27FaxQueues\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20701\x20THEN\x20\x27SmsQueues\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20404\x20THEN\x20\x27InternalRoutes\x27','\x20\x20SELECT\x20x.sectionId,\x20u.VoiceQueueId,\x20x.userId','\x20\x20CONSTRAINT\x20`user_profile_has_sections_ibfk_1`\x20FOREIGN\x20KEY\x20(`userProfileId`)\x20REFERENCES\x20`user_profiles`\x20(`id`)\x20ON\x20DELETE\x20CASCADE\x20ON\x20UPDATE\x20CASCADE','\x20\x20WHERE\x20x.sectionId\x20=\x20802;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20),','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20701\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20sms_queues\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201001\x20THEN\x20\x27CannedAnswers\x27','\x20\x20KEY\x20`compositeIndex`\x20(`sectionId`,`userProfileId`),','\x20\x20WHERE\x20x.sectionId\x20=\x20401\x20AND\x20q.type\x20=\x20\x27inbound\x27;','\x20\x20`crudPermissions`\x20varchar(255)\x20DEFAULT\x20NULL,','\x20\x20\x20\x20category\x20varchar(255)\x20not\x20null,','\x20\x20`enabled`\x20tinyint(1)\x20DEFAULT\x20NULL,','INSERT\x20INTO\x20tmpNormalizedUsers','\x20\x20`createdAt`\x20datetime\x20NOT\x20NULL,','sequence','\x20\x20\x20\x20autoAssociation\x20tinyint\x20not\x20null,','\x20\x20\x20\x20userId\x20text,','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(1401,\x201402,\x201403,\x201404,\x201405,\x201406,\x201407)\x20THEN\x20\x27DELETE\x27','ALTER\x20TABLE\x20`users`\x20','\x20\x20FROM\x20users','INSERT\x20INTO\x20tmpCustomResources','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20510\x20THEN\x20\x27Realtime\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ORDER\x20BY\x20n)\x20AS\x20split','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20610\x20THEN\x20\x27Realtime\x27','prototype','\x20\x20\x20\x20userId\x20text','INSERT\x20INTO\x20tmpNormalizedResources','\x20\x20INNER\x20JOIN\x20voice_queues\x20q\x20ON\x20u.VoiceQueueId\x20=\x20q.id','\x20\x20FROM\x20tmpNormalizedUsers\x20x','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20user_profile_has_sections\x20x','\x20\x20INNER\x20JOIN\x20user_has_square_projects\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20`id`\x20int(11)\x20NOT\x20NULL\x20AUTO_INCREMENT,',')\x20ENGINE=InnoDB\x20DEFAULT\x20CHARSET=utf8;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20400\x20THEN\x20\x27DELETE\x27','CREATE\x20TABLE\x20tmpFinalProfiles','\x20\x20\x20\x20name\x20varchar(255)\x20not\x20null,','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpSingleProfiles;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201100\x20THEN\x20\x27DELETE\x27','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(401,\x20402,\x20403,\x20404,\x20405,\x20406,\x20407,\x20408,\x20409,\x20410,\x20411)\x20THEN\x20\x27Voice\x27','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20>=\x20100000\x20THEN\x20\x27Tools\x27','addIndex\x20%s\x20%s\x20%s','stringify','\x20\x20SELECT\x20GROUP_CONCAT(id),\x20permissions,\x20null','\x20\x20resourceId\x20int(11),','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20name\x20=\x20\x27CustomDashboards\x27\x20THEN\x20(sectionId\x20-\x2099999)','\x20\x20SET\x20u.permissions\x20=\x20t.permissions','\x20\x20FROM\x20user_profiles\x20u','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20702\x20THEN\x20\x27SmsAccounts\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20402\x20THEN\x20\x27InboundRoutes\x27','Changed\x20column\x20%s\x20in\x20table\x20%s','\x20\x20\x20\x20permissions\x20text\x20not\x20null,','\x20\x20\x20\x20resourceId\x20text','tail','\x20\x20WHERE\x20x.sectionId\x20=\x20901;','\x20\x20WHERE\x20name\x20=\x20\x27DELETE\x27;','\x20\x20SET\x20sectionId\x20=\x201003\x20WHERE\x20sectionId\x20>=\x20100000;','\x20\x20`sectionId`\x20int(11)\x20DEFAULT\x20NULL,','\x20\x20`name`\x20varchar(255)\x20NOT\x20NULL,','removeColumn','\x20\x20FROM\x20tmpSections;','removeIndex\x20%s\x20%s','\x20\x20ORDER\x20BY\x20n)\x20AS\x20split;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20204\x20THEN\x20\x27Teams\x27','\x20\x20INNER\x20JOIN\x20user_has_sms_accounts\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20\x20\x20\x20\x20\x20\x20SUBSTRING_INDEX(fp.userId,\x20\x27,\x27,\x201)\x20userId','\x20\x20FROM\x20tmpNormalizedSections','\x20\x20INNER\x20JOIN\x20user_has_fax_accounts\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20END','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20200\x20THEN\x20\x27DELETE\x27','\x20\x20\x20\x20userProfileId\x20int(11)\x20not\x20null,','\x20\x20\x20\x20enabled\x20tinyint\x20not\x20null,','\x20\x20SET','sequelize','INSERT\x20INTO\x20tmpSharedProfiles','INSERT\x20INTO\x20`user_profiles`\x20(`name`,\x20`crudPermissions`,\x20`description`,\x20`createdAt`,\x20`updatedAt`)','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20);','then','\x20\x20\x20\x20p.userIds\x20userId','\x20\x20\x20\x20\x20\x20userId\x20text\x20not\x20null,','\x20\x20\x20\x20\x20\x20permissions\x20text\x20not\x20null,','CREATE\x20TABLE\x20tmpResources','\x20\x20\x20\x20resourceId\x20int(11)\x20not\x20null,','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201502\x20THEN\x20\x27IvrCampaigns\x27','\x20\x20SELECT\x20x.sectionId,\x20u.OpenchannelQueueId,\x20x.userId','\x20\x20\x20\x20\x20\x20WHEN\x20x.type\x20=\x20\x27Plugins\x27\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20plugins\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','\x20\x20FROM\x20tmpNormalizedResources;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20411\x20THEN\x20\x27Realtime\x27','\x20\x20);','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpExtractedResources;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201701\x20THEN\x20\x27Projects\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20END','\x20\x20SELECT\x20x.sectionId,\x20u.OpenchannelAccountId,\x20x.userId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20GROUP\x20BY\x20resourceId,\x20sectionId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201700\x20THEN\x20\x27DELETE\x27','\x20\x20SET\x20u.userProfileId\x20=\x201','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ORDER\x20BY\x20n)\x20as\x20split','\x20\x20(','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20702\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20sms_accounts\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201307\x20THEN\x20\x27ZohoAccounts\x27','\x20\x20SELECT\x20x.sectionId,\x20u.SquareProjectId,\x20x.userId','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(202,\x20203,\x20204)\x20THEN\x20\x27Staff\x27','UPDATE\x20users\x20u,\x20tmpNormalizedPermissions\x20t','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20(select\x20SUBSTRING_INDEX(SUBSTRING_INDEX(r.userIds,\x20\x27,\x27,\x20t.n),\x20\x27,\x27,\x20-1)\x20userId','addColumn','\x20\x20`description`\x20varchar(255)\x20DEFAULT\x20NULL,','\x20\x20INNER\x20JOIN\x20user_has_chat_websites\x20u\x20ON\x20u.UserId\x20=\x20x.userId','query','\x20\x20SELECT\x20GROUP_CONCAT(userId),\x20permissions,\x20null','\x20\x20SELECT\x20GROUP_CONCAT(sectionId\x20ORDER\x20BY\x20sectionId),\x20userId','CREATE\x20TABLE\x20tmpPermissions','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpSharedProfiles;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201510\x20THEN\x20\x27Realtime\x27','\x20\x20\x20\x20\x20\x20SUBSTRING_INDEX(SUBSTRING_INDEX(s.userId,\x20\x27,\x27,\x20t.n),\x20\x27,\x27,\x20-1)\x20userId','\x20\x20\x20\x20\x20\x20\x20\x20r.type\x20type,','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201302\x20THEN\x20\x27SalesforceAccounts\x27','\x20\x20SELECT\x20name,\x20category,\x20sectionId,\x20enabled,\x20autoAssociation,\x20\x27red\x27,\x20now(),\x20now(),\x20userProfileId','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpFinalProfiles;','\x20\x20CONSTRAINT\x20`user_profile_has_resources_ibfk_1`\x20FOREIGN\x20KEY\x20(`sectionId`)\x20REFERENCES\x20`user_profile_has_sections`\x20(`id`)\x20ON\x20DELETE\x20CASCADE\x20ON\x20UPDATE\x20CASCADE','\x20\x20`crudPermissions`\x20varchar(255)\x20NOT\x20NULL\x20DEFAULT\x20\x27r\x27,','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20>=\x20100000\x20THEN\x20\x27CustomDashboards\x27','\x20\x20\x20\x20\x20\x20resourceId\x20text,','\x20\x20`userProfileId`\x20int(11)\x20DEFAULT\x20NULL,',',(SELECT\x200\x20AS\x20N\x20UNION\x20ALL\x20SELECT\x201\x20UNION\x20ALL\x20SELECT\x202\x20UNION\x20ALL\x20SELECT\x203\x20UNION\x20ALL\x20SELECT\x204\x20UNION\x20ALL\x20SELECT\x205\x20UNION\x20ALL\x20SELECT\x206\x20UNION\x20ALL\x20SELECT\x207\x20UNION\x20ALL\x20SELECT\x208\x20UNION\x20ALL\x20SELECT\x209)\x20d','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20600\x20THEN\x20\x27DELETE\x27','\x20\x20FROM\x20tmpSections','info','(SELECT\x200\x20AS\x20N\x20UNION\x20ALL\x20SELECT\x201\x20UNION\x20ALL\x20SELECT\x202\x20UNION\x20ALL\x20SELECT\x203\x20UNION\x20ALL\x20SELECT\x204\x20UNION\x20ALL\x20SELECT\x205\x20UNION\x20ALL\x20SELECT\x206\x20UNION\x20ALL\x20SELECT\x207\x20UNION\x20ALL\x20SELECT\x208\x20UNION\x20ALL\x20SELECT\x209)\x20a','\x20\x20WHERE\x20x.sectionId\x20=\x201103;','\x20\x20\x20\x20\x20\x20\x20\x20r.sectionId\x20sectionId','CREATE\x20TABLE\x20tmpSingleProfiles','\x20\x20WHERE\x20x.sectionId\x20=\x20601;','\x20\x20FROM\x20tmpCustomResources;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201201\x20THEN\x20\x27Metrics\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20601\x20THEN\x20\x27MailQueues\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20SUBSTRING_INDEX(SUBSTRING_INDEX(r.userIds,\x20\x27,\x27,\x20t.n),\x20\x27,\x27,\x20-1)\x20userId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20302\x20THEN\x20\x27Companies\x27','UPDATE\x20tmpCustomResources\x20r,\x20tmpSections\x20s','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20203\x20THEN\x20\x27Telephones\x27','\x20\x20userId\x20int(11)','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201003\x20THEN\x20\x27CustomDashboards\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201101\x20THEN\x20\x27ODBC\x27','\x20\x20FROM\x20tmpFinalProfiles;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20700\x20THEN\x20\x27DELETE\x27','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpNormalizedUsers;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201601\x20THEN\x20\x27DELETE\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201203\x20THEN\x20\x27Reports\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20810\x20THEN\x20\x27Realtime\x27','\x20\x20\x20\x20\x20\x20\x20\x20ELSE\x20\x27\x27','\x20\x20SELECT\x20*\x20FROM\x20tmpSharedProfiles','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201200\x20THEN\x20\x27DELETE\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ORDER\x20BY\x20users)\x20b','\x20\x20INNER\x20JOIN\x20user_has_openchannel_accounts\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20INNER\x20JOIN\x20user_has_chat_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20304\x20THEN\x20\x27GlobalCustomFields\x27','INSERT\x20INTO\x20user_profiles\x20(name,\x20crudPermissions,\x20createdAt,\x20updatedAt)','VALUES\x20(\x27Default\x27,\x20\x27red\x27,\x20NULL,\x20NOW(),\x20NOW());','\x20\x20SELECT\x20x.sectionId,\x20u.FaxAccountId,\x20x.userId','CREATE\x20TABLE\x20tally\x20(','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20tally\x20t\x20INNER\x20JOIN\x20tmpPermissions\x20r\x20ON\x20CHAR_LENGTH(r.userIds)\x20-\x20CHAR_LENGTH(REPLACE(r.userIds,\x20\x27,\x27,\x20\x27\x27))\x20>=\x20t.n-1','UPDATE\x20tmpSections\x20s','dropTable','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201006\x20THEN\x20\x27Scheduler\x27','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(1201,\x201202,\x201203)\x20THEN\x20\x27Analytics\x27','../config/logger','users','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201701\x20THEN\x20\x27jscripty\x27','\x20\x20SET\x20r.sectionId\x20=\x20s.insertedId','\x20DROP\x20TABLE\x20IF\x20EXISTS\x20tally;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201012\x20THEN\x20\x27Variables\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20409\x20THEN\x20\x27ChanSpies\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20500\x20THEN\x20\x27DELETE\x27','\x20\x20FROM\x20(SELECT','\x20\x20\x20\x20\x20\x20END','\x20\x20`sectionId`\x20int(11)\x20NOT\x20NULL,','CREATE\x20TABLE\x20tmpExtractedResources\x20(','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201009\x20THEN\x20\x27Templates\x27','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(701,\x20702,\x20710)\x20THEN\x20\x27Sms\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201103\x20THEN\x20\x27SquareProjects\x27','INSERT\x20INTO\x20tmpExtractedResources','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201501\x20THEN\x20\x27QueueCampaigns\x27','migration','\x20\x20\x20\x20SUBSTRING_INDEX(SUBSTRING_INDEX(p.permissions,\x20\x27,\x27,\x20tally.n),\x20\x27,\x27,\x20-1)\x20permission,','CREATE\x20TABLE\x20tmpNormalizedPermissions','reportType','\x20\x20KEY\x20`userProfileId`\x20(`userProfileId`),','\x20\x20category\x20=\x20(SELECT','INTEGER','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20301\x20THEN\x20\x27Lists\x27','\x20\x20\x20\x20\x20\x20permissions\x20text\x20not\x20null','addIndex','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20202\x20THEN\x20\x27Agents\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201102\x20THEN\x20\x27SquareRecordings\x27','\x20\x20WHERE\x20t1.name\x20=\x20t2.name\x20AND\x20t1.userProfileId\x20=\x20t2.userProfileId\x20AND\x20t1.sectionId\x20>\x20t2.sectionId;','\x20\x20ORDER\x20BY\x20id;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20300\x20THEN\x20\x27DELETE\x27','\x20\x20INNER\x20JOIN\x20user_has_sms_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20WHERE\x20userId\x20NOT\x20IN\x20(SELECT\x20split.userId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201008\x20THEN\x20\x27Tags\x27','\x20\x20WHERE\x20x.sectionId\x20=\x20801;','changeColumn',',(SELECT\x200\x20AS\x20N\x20UNION\x20ALL\x20SELECT\x201\x20UNION\x20ALL\x20SELECT\x202\x20UNION\x20ALL\x20SELECT\x203\x20UNION\x20ALL\x20SELECT\x204\x20UNION\x20ALL\x20SELECT\x205\x20UNION\x20ALL\x20SELECT\x206\x20UNION\x20ALL\x20SELECT\x207\x20UNION\x20ALL\x20SELECT\x208\x20UNION\x20ALL\x20SELECT\x209)\x20b','\x20\x20WHERE\x20split.userId\x20IN\x20(SELECT\x20*\x20FROM','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20END','\x20\x20PRIMARY\x20KEY\x20(`id`),','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201005\x20THEN\x20\x27Pauses\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201301\x20THEN\x20\x27ZendeskAccounts\x27','ADD\x20CONSTRAINT\x20`users_ibfk_1`\x20','\x20\x20`updatedAt`\x20datetime\x20NOT\x20NULL,','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20601\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20mail_queues\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','\x20\x20WHERE\x20userId\x20IN\x20(SELECT\x20split.userId','\x20\x20UNIQUE\x20KEY\x20`name`\x20(`name`)','INSERT\x20INTO\x20tmpSingleProfiles','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(1501,\x201502,\x201510)\x20THEN\x20\x27MotionDialer\x27','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20501\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20chat_queues\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20901\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20fax_queues\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','removeIndex','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20tally\x20t','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20603\x20THEN\x20\x27MailSubstatuses\x27','CREATE\x20TABLE\x20tmpNormalizedUsers','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20801\x20THEN\x20\x27OpenchannelQueues\x27','\x20\x20SELECT\x20x.sectionId,\x20u.SmsAccountId,\x20x.userId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHERE\x20position(\x27,\x27\x20in\x20b.users)\x20=\x200))','\x20\x20INNER\x20JOIN\x20user_has_voice_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20WHERE\x20x.sectionId\x20=\x20702;','UPDATE\x20tmpFinalProfiles','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpPermissions;','\x20\x20`autoAssociation`\x20tinyint(1)\x20DEFAULT\x20NULL,','INSERT\x20INTO\x20tmpNormalizedSections',',(SELECT\x200\x20AS\x20N\x20UNION\x20ALL\x20SELECT\x201\x20UNION\x20ALL\x20SELECT\x202\x20UNION\x20ALL\x20SELECT\x203\x20UNION\x20ALL\x20SELECT\x204\x20UNION\x20ALL\x20SELECT\x205\x20UNION\x20ALL\x20SELECT\x206\x20UNION\x20ALL\x20SELECT\x207\x20UNION\x20ALL\x20SELECT\x208\x20UNION\x20ALL\x20SELECT\x209)\x20e'];(function(_0x19e6ac,_0x159a6d){const _0x48d7f5=function(_0x309b99){while(--_0x309b99){_0x19e6ac['push'](_0x19e6ac['shift']());}};_0x48d7f5(++_0x159a6d);}(a964_0x159a,0x8d));const a964_0x48d7=function(_0x19e6ac,_0x159a6d){_0x19e6ac=_0x19e6ac-0x0;let _0x48d7f5=a964_0x159a[_0x19e6ac];return _0x48d7f5;};const _0x2b683b=a964_0x48d7;'use strict';const util=require('util'),logger=require(_0x2b683b('0x79'))(_0x2b683b('0x8a')),Sequence=function(){};Sequence['prototype'][_0x2b683b('0xbd')]=function(_0x309b99){const _0x5b5793=_0x2b683b;this[_0x5b5793('0xa')]=this[_0x5b5793('0xa')]?this[_0x5b5793('0xa')][_0x5b5793('0xcd')](_0x309b99):_0x309b99();};const Migration=function(_0x46ec60){const _0x51c25b=_0x2b683b;this[_0x51c25b('0xd0')]=_0x46ec60,this['sequence']=new Sequence();};Migration[_0x2b683b('0x136')][_0x2b683b('0x9d')]=function(_0x4b5e10,_0x837f,_0x4336a8){const _0x4c23fe=_0x2b683b,_0x2d416e=this;this[_0x4c23fe('0x12c')][_0x4c23fe('0xbd')](function(){const _0x6c024e=_0x4c23fe;return _0x2d416e['queryInterface']['changeColumn'](_0x4b5e10,_0x837f,_0x4336a8)[_0x6c024e('0x22')](function(){const _0x36f77a=_0x6c024e;logger['info'](_0x36f77a('0x7'),_0x837f,_0x4b5e10);})[_0x6c024e('0xce')](function(_0x56cda3){const _0x339fac=_0x6c024e;logger['info'](JSON[_0x339fac('0x147')](_0x56cda3));});});},Migration['prototype'][_0x2b683b('0x3d')]=function(_0x5cab3a,_0x199e2f,_0x557f57){const _0x23a058=_0x2b683b,_0x2c0277=this;this[_0x23a058('0x12c')][_0x23a058('0xbd')](function(){const _0x172cc9=_0x23a058;return _0x2c0277['queryInterface'][_0x172cc9('0x3d')](_0x5cab3a,_0x199e2f,_0x557f57)[_0x172cc9('0x22')](function(){const _0x774f70=_0x172cc9;logger[_0x774f70('0x53')](_0x774f70('0x10e'),_0x199e2f,_0x5cab3a);})[_0x172cc9('0xce')](function(_0xe98707){const _0xb6b680=_0x172cc9;logger[_0xb6b680('0x53')](JSON[_0xb6b680('0x147')](_0xe98707));});});},Migration[_0x2b683b('0x136')][_0x2b683b('0x76')]=function(_0x4ceb31){const _0x56ce35=_0x2b683b,_0x23d24c=this;this[_0x56ce35('0x12c')]['enqueue'](function(){const _0x9952de=_0x56ce35;return _0x23d24c['queryInterface']['dropTable'](_0x4ceb31,{'force':!![]})[_0x9952de('0x22')](function(){const _0x43ae12=_0x9952de;logger[_0x43ae12('0x53')]('table\x20dropped\x20%s',_0x4ceb31);})[_0x9952de('0xce')](function(_0x494d65){const _0x596007=_0x9952de;logger[_0x596007('0x53')](JSON[_0x596007('0x147')](_0x494d65));});});},Migration[_0x2b683b('0x136')][_0x2b683b('0x93')]=function(_0x2a0ad9,_0x2d7160,_0x3c922c){const _0x1031b0=_0x2b683b,_0x279970=this;this[_0x1031b0('0x12c')][_0x1031b0('0xbd')](function(){const _0x27a52e=_0x1031b0;return _0x279970[_0x27a52e('0xd0')]['addIndex'](_0x2a0ad9,_0x2d7160,{'indexName':_0x3c922c})[_0x27a52e('0x22')](function(){const _0x1fd581=_0x27a52e;logger['info'](_0x1fd581('0x146'),_0x2a0ad9,_0x2d7160['join'](','),_0x3c922c);})['catch'](function(_0x1fef16){const _0x8d29b8=_0x27a52e;logger[_0x8d29b8('0x53')](JSON[_0x8d29b8('0x147')](_0x1fef16));});});},Migration['prototype'][_0x2b683b('0xad')]=function(_0x32f8be,_0x4fca08){const _0x59f83f=_0x2b683b,_0x2df792=this;this[_0x59f83f('0x12c')][_0x59f83f('0xbd')](function(){const _0x3dd7b2=_0x59f83f;return _0x2df792[_0x3dd7b2('0xd0')][_0x3dd7b2('0xad')](_0x32f8be,_0x4fca08)['then'](function(){const _0x1d8e11=_0x3dd7b2;logger[_0x1d8e11('0x53')](_0x1d8e11('0x12'),_0x32f8be,_0x4fca08);})[_0x3dd7b2('0xce')](function(_0xfd006c){const _0x3601cb=_0x3dd7b2;logger['info'](JSON[_0x3601cb('0x147')](_0xfd006c));});});},Migration[_0x2b683b('0x136')][_0x2b683b('0x40')]=function(_0x11e1b8){const _0x49b142=_0x2b683b,_0x5b50eb=this;this['sequence'][_0x49b142('0xbd')](function(){const _0x256f5a=_0x49b142;return _0x5b50eb[_0x256f5a('0xd0')][_0x256f5a('0x1e')][_0x256f5a('0x40')](_0x11e1b8)[_0x256f5a('0x22')](function(){const _0x14ebd9=_0x256f5a;logger[_0x14ebd9('0x53')]('query\x20%s',_0x11e1b8);})[_0x256f5a('0xce')](function(_0x4c48d3){const _0x3277ae=_0x256f5a;logger['info'](JSON[_0x3277ae('0x147')](_0x4c48d3));});});},Migration['prototype']['removeColumn']=function(_0x9c2896,_0x27a565){const _0x139e5a=_0x2b683b,_0x811f25=this;this[_0x139e5a('0x12c')][_0x139e5a('0xbd')](function(){const _0x1f5e91=_0x139e5a;return _0x811f25[_0x1f5e91('0xd0')][_0x1f5e91('0x10')](_0x9c2896,_0x27a565)[_0x1f5e91('0x22')](function(){const _0x3ad266=_0x1f5e91;logger[_0x3ad266('0x53')](_0x3ad266('0xdb'),_0x27a565,_0x9c2896);})['catch'](function(_0x278159){const _0x5cd2e4=_0x1f5e91;logger[_0x5cd2e4('0x53')](util[_0x5cd2e4('0x109')](_0x278159,{'showHidden':![],'depth':null}));});});},Migration[_0x2b683b('0x136')][_0x2b683b('0x102')]=function(_0x48ddaf,_0x54bf7,_0x2403a1){const _0x3241a5=_0x2b683b,_0x3ea6ec=this;this['sequence'][_0x3241a5('0xbd')](function(){const _0x544aa4=_0x3241a5;return _0x3ea6ec[_0x544aa4('0xd0')][_0x544aa4('0x102')](_0x48ddaf,_0x54bf7,_0x2403a1)['then'](function(){logger['info']('Renamed\x20column\x20from\x20%s\x20to\x20%s\x20on\x20%s',_0x54bf7,_0x2403a1,_0x48ddaf);})['catch'](function(_0x173183){const _0xe7ed17=_0x544aa4;logger[_0xe7ed17('0x53')](util['inspect'](_0x173183,{'showHidden':![],'depth':null}));});});},Migration[_0x2b683b('0x136')][_0x2b683b('0xc0')]=function(_0x192414){const _0x1b17ed=_0x2b683b;this[_0x1b17ed('0x12c')][_0x1b17ed('0xbd')](function(){return _0x192414();});},module['exports']={'up':function(_0x3f1c1f,_0x53ed26){return new Promise(function(_0x120022){const _0x44144d=a964_0x48d7,_0x3f1e46=new Migration(_0x3f1c1f);_0x3f1e46[_0x44144d('0x3d')]('analytics_extracted_reports','reportId',{'type':_0x53ed26[_0x44144d('0x90')]}),_0x3f1e46[_0x44144d('0x3d')]('analytics_extracted_reports',_0x44144d('0x8d'),{'type':_0x53ed26[_0x44144d('0xdd')]}),_0x3f1e46[_0x44144d('0x3d')](_0x44144d('0x7a'),_0x44144d('0x111'),{'type':_0x53ed26[_0x44144d('0x90')]}),_0x3f1e46[_0x44144d('0x10')]('voice_voicemail','name'),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0xc3')+_0x44144d('0x13d')+_0x44144d('0xf')+_0x44144d('0x4c')+_0x44144d('0x3e')+_0x44144d('0x12b')+_0x44144d('0xa5')+_0x44144d('0xa1')+_0x44144d('0xa8')+')\x20ENGINE=InnoDB\x20DEFAULT\x20CHARSET=utf8;'),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x20')+_0x44144d('0x71')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x130')+_0x44144d('0xa4')+_0x44144d('0xe6')+'REFERENCES\x20user_profiles(`id`)\x20'+_0x44144d('0xf8')),_0x3f1e46[_0x44144d('0x40')]('CREATE\x20TABLE\x20`user_profile_has_sections`\x20('+_0x44144d('0x13d')+_0x44144d('0xf')+'\x20\x20`category`\x20varchar(255)\x20NOT\x20NULL,'+_0x44144d('0x83')+_0x44144d('0x129')+_0x44144d('0xb8')+_0x44144d('0x127')+_0x44144d('0x12b')+'\x20\x20`updatedAt`\x20datetime\x20NOT\x20NULL,'+_0x44144d('0x4f')+_0x44144d('0xa1')+_0x44144d('0x8e')+_0x44144d('0x125')+_0x44144d('0x120')+_0x44144d('0x13e')),_0x3f1e46['query']('CREATE\x20TABLE\x20`user_profile_has_resources`\x20('+_0x44144d('0x13d')+_0x44144d('0xf')+'\x20\x20`resourceId`\x20int(11)\x20NOT\x20NULL,'+'\x20\x20`type`\x20varchar(255)\x20NOT\x20NULL,'+_0x44144d('0x12b')+_0x44144d('0xa5')+_0x44144d('0xe')+_0x44144d('0xa1')+'\x20\x20KEY\x20`sectionId`\x20(`sectionId`),'+'\x20\x20KEY\x20`compositeIndex`\x20(`resourceId`,`sectionId`),'+_0x44144d('0x4b')+')\x20ENGINE=InnoDB\x20DEFAULT\x20CHARSET=utf8;'),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x73')+_0x44144d('0xf7')+');'),_0x3f1e46[_0x44144d('0x40')]('INSERT\x20INTO\x20tally\x20(n)'+'SELECT\x20NULL\x20FROM'+_0x44144d('0x54')+_0x44144d('0x9e')+',(SELECT\x200\x20AS\x20N\x20UNION\x20ALL\x20SELECT\x201\x20UNION\x20ALL\x20SELECT\x202\x20UNION\x20ALL\x20SELECT\x203\x20UNION\x20ALL\x20SELECT\x204\x20UNION\x20ALL\x20SELECT\x205\x20UNION\x20ALL\x20SELECT\x206\x20UNION\x20ALL\x20SELECT\x207\x20UNION\x20ALL\x20SELECT\x208\x20UNION\x20ALL\x20SELECT\x209)\x20c'+_0x44144d('0x50')+_0x44144d('0xba')+';'),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x43')+_0x44144d('0x36')+'\x20\x20\x20\x20\x20\x20userIds\x20varchar(255)\x20not\x20null,'+_0x44144d('0x25')+_0x44144d('0xe1')+_0x44144d('0x2d')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0xef')+_0x44144d('0x11b')+_0x44144d('0x131')+'\x20\x20WHERE\x20role\x20=\x20\x27user\x27\x20and\x20permissions\x20is\x20not\x20null\x20and\x20permissions\x20<>\x20\x27\x27'+_0x44144d('0x97')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x101')+_0x44144d('0x36')+_0x44144d('0x108')+'\x20\x20\x20\x20userId\x20text,'+_0x44144d('0x9')+_0x44144d('0x2d')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0xb9')+'\x20\x20SELECT\x20DISTINCT\x20permission,\x20userId,\x200'+_0x44144d('0x81')+_0x44144d('0x8b')+_0x44144d('0x23')+'\x20\x20FROM\x20tally\x20INNER\x20JOIN\x20tmpPermissions\x20p\x20ON\x20CHAR_LENGTH(p.permissions)\x20-\x20CHAR_LENGTH(REPLACE(p.permissions,\x20\x27,\x27,\x20\x27\x27))\x20>=\x20tally.n-1'+'\x20\x20ORDER\x20BY\x20n)\x20AS\x20split;'),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x8c')+_0x44144d('0x36')+_0x44144d('0x8')+_0x44144d('0x113')+_0x44144d('0x2d')),_0x3f1e46[_0x44144d('0x40')]('INSERT\x20INTO\x20tmpNormalizedPermissions'+_0x44144d('0x42')+_0x44144d('0x17')+'\x20\x20GROUP\x20BY\x20userId;'),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x3b')+_0x44144d('0x3')+'\x20\x20WHERE\x20u.id\x20=\x20t.userId;'),_0x3f1e46[_0x44144d('0x40')]('TRUNCATE\x20TABLE\x20tmpPermissions;'),_0x3f1e46[_0x44144d('0x40')]('INSERT\x20INTO\x20tmpPermissions'+_0x44144d('0x0')+_0x44144d('0x131')+_0x44144d('0xfc')+'\x20\x20GROUP\x20BY\x20permissions'+'\x20\x20ORDER\x20BY\x20GROUP_CONCAT(id);'),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0xb0')+_0x44144d('0x36')+_0x44144d('0x108')+_0x44144d('0x12e')+_0x44144d('0x9')+_0x44144d('0x2d')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x12a')+'\x20\x20SELECT\x20permission,\x20userId,\x200'+_0x44144d('0x81')+_0x44144d('0x105')+_0x44144d('0x46')+_0x44144d('0xc2')+_0x44144d('0x13')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x84')+'\x20\x20sectionId\x20int(11)\x20not\x20null,'+_0x44144d('0x1')+_0x44144d('0x60')+_0x44144d('0x2d')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x88')+_0x44144d('0x11f')+_0x44144d('0x13a')+'\x20\x20INNER\x20JOIN\x20user_has_voice_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId'+_0x44144d('0x139')+_0x44144d('0x126')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x88')+_0x44144d('0xfb')+_0x44144d('0x13a')+_0x44144d('0x6e')+'\x20\x20WHERE\x20x.sectionId\x20=\x20501;'),_0x3f1e46['query'](_0x44144d('0x88')+'\x20\x20SELECT\x20x.sectionId,\x20u.ChatWebsiteId,\x20x.userId'+'\x20\x20FROM\x20tmpNormalizedUsers\x20x'+_0x44144d('0x3f')+_0x44144d('0x114')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x88')+'\x20\x20SELECT\x20x.sectionId,\x20u.MailQueueId,\x20x.userId'+'\x20\x20FROM\x20tmpNormalizedUsers\x20x'+'\x20\x20INNER\x20JOIN\x20user_has_mail_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId'+_0x44144d('0x58')),_0x3f1e46['query'](_0x44144d('0x88')+'\x20\x20SELECT\x20x.sectionId,\x20u.MailAccountId,\x20x.userId'+_0x44144d('0x13a')+'\x20\x20INNER\x20JOIN\x20user_has_mail_accounts\x20u\x20ON\x20u.UserId\x20=\x20x.userId'+'\x20\x20WHERE\x20x.sectionId\x20=\x20602;'),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x88')+'\x20\x20SELECT\x20x.sectionId,\x20u.SmsQueueId,\x20x.userId'+_0x44144d('0x13a')+_0x44144d('0x99')+_0x44144d('0xe5')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x88')+_0x44144d('0xb2')+_0x44144d('0x13a')+_0x44144d('0x15')+_0x44144d('0xb5')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x88')+_0x44144d('0x29')+_0x44144d('0x13a')+_0x44144d('0xdc')+_0x44144d('0x9c')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x88')+_0x44144d('0x31')+_0x44144d('0x13a')+_0x44144d('0x6d')+_0x44144d('0x121')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x88')+'\x20\x20SELECT\x20x.sectionId,\x20u.FaxQueueId,\x20x.userId'+_0x44144d('0x13a')+'\x20\x20INNER\x20JOIN\x20user_has_fax_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId'+_0x44144d('0xb')),_0x3f1e46[_0x44144d('0x40')]('INSERT\x20INTO\x20tmpExtractedResources'+_0x44144d('0x72')+_0x44144d('0x13a')+_0x44144d('0x18')+_0x44144d('0xe0')),_0x3f1e46['query']('INSERT\x20INTO\x20tmpExtractedResources'+_0x44144d('0x39')+'\x20\x20FROM\x20tmpNormalizedUsers\x20x'+_0x44144d('0x13c')+_0x44144d('0x55')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x88')+_0x44144d('0x11f')+_0x44144d('0x13a')+_0x44144d('0xb4')+_0x44144d('0x139')+'\x20\x20WHERE\x20x.sectionId\x20=\x201501\x20AND\x20q.type\x20=\x20\x27outbound\x27;'),_0x3f1e46['query']('CREATE\x20TABLE\x20tmpGroupedPermissions'+_0x44144d('0x36')+'\x20\x20\x20\x20\x20\x20userId\x20text\x20not\x20null,'+_0x44144d('0x92')+'\x20\x20);'),_0x3f1e46[_0x44144d('0x40')]('INSERT\x20INTO\x20tmpGroupedPermissions'+_0x44144d('0xe9')+'\x20\x20FROM\x20(SELECT'+_0x44144d('0xdf')+_0x44144d('0x10d')+'\x20\x20FROM\x20tally\x20INNER\x20JOIN\x20tmpPermissions\x20t\x20ON\x20CHAR_LENGTH(t.userIds)\x20-\x20CHAR_LENGTH(REPLACE(t.userIds,\x20\x27,\x27,\x20\x27\x27))\x20>=\x20tally.n-1'+_0x44144d('0x13')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0xc4')+_0x44144d('0x36')+_0x44144d('0xd2')+_0x44144d('0x25')+_0x44144d('0xe1')+_0x44144d('0x2d')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x1f')+_0x44144d('0x41')+_0x44144d('0xc5')+_0x44144d('0x9a')+_0x44144d('0xe7')+_0x44144d('0x5c')+_0x44144d('0xae')+_0x44144d('0xd4')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHERE\x20POSITION(\x27,\x27\x20in\x20r.userIds)\x20>\x200'+_0x44144d('0x134')+_0x44144d('0x9f')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20(SELECT\x20GROUP_CONCAT(userId\x20ORDER\x20BY\x20userId\x20ASC)\x20AS\x20users'+_0x44144d('0x117')+_0x44144d('0x32')+_0x44144d('0x6c')+_0x44144d('0xb3')+_0x44144d('0x118')+'\x20\x20ORDER\x20BY\x20GROUP_CONCAT(userId);'),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x57')+_0x44144d('0x36')+_0x44144d('0x24')+_0x44144d('0x25')+_0x44144d('0xe1')+_0x44144d('0x2d')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0xa9')+_0x44144d('0xe8')+_0x44144d('0xc5')+_0x44144d('0xa7')+_0x44144d('0x3c')+_0x44144d('0x74')+_0x44144d('0xf2')+_0x44144d('0x35')+'\x20\x20WHERE\x20split.userId\x20IN\x20(SELECT\x20*\x20FROM'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20(SELECT\x20GROUP_CONCAT(userId\x20ORDER\x20BY\x20userId\x20ASC)\x20as\x20users'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20tmpNormalizedUsers'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20GROUP\x20BY\x20resourceId,\x20sectionId'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ORDER\x20BY\x20users)\x20b'+_0x44144d('0x10b')+'\x20\x20ORDER\x20BY\x20userId;'),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x140')+_0x44144d('0x36')+_0x44144d('0x24')+_0x44144d('0x25')+'\x20\x20\x20\x20\x20\x20profileId\x20int(11)'+_0x44144d('0x2d')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0xbb')+_0x44144d('0x6a')+'\x20\x20UNION'+_0x44144d('0x10a')),_0x3f1e46['query'](_0x44144d('0x70')+'\x20\x20SELECT\x20CONCAT(\x27Profile_\x27,\x20(SELECT\x20(@cnt\x20:=\x20@cnt\x20+\x201)\x20AS\x20rowNumber'+'\x20\x20FROM\x20tmpFinalProfiles\x20t'+_0x44144d('0xed')+_0x44144d('0x63')),_0x3f1e46['query'](_0x44144d('0xb6')+'\x20\x20SET\x20profileId\x20=\x20(SELECT\x20(@cnt\x20:=\x20@cnt\x20+\x201)\x20AS\x20rowNumber'+_0x44144d('0x4')+'\x20\x20CROSS\x20JOIN\x20(SELECT\x20@cnt\x20:=\x201)\x20as\x20dummy\x20LIMIT\x201)'),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0xf0')+'\x20\x20('+'\x20\x20\x20\x20name\x20varchar(255)\x20not\x20null,'+'\x20\x20\x20\x20category\x20varchar(255)\x20not\x20null,'+_0x44144d('0x108')+'\x20\x20\x20\x20enabled\x20tinyint\x20not\x20null,'+_0x44144d('0x12d')+_0x44144d('0x1b')+_0x44144d('0x119')+_0x44144d('0x137')+_0x44144d('0x2d')),_0x3f1e46[_0x44144d('0x40')]('INSERT\x20INTO\x20tmpSections'+_0x44144d('0xf1')+_0x44144d('0x81')+'\x20\x20\x20\x20\x20\x20\x20\x20fp.profileId\x20profileId,'+_0x44144d('0x112')+_0x44144d('0x16')+_0x44144d('0xcb')+_0x44144d('0xc8')+_0x44144d('0xd3')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0xf6')+_0x44144d('0x1d')+'\x20\x20\x20\x20\x20\x20name\x20=\x20(SELECT'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20CASE'+_0x44144d('0xd9')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20101\x20THEN\x20\x27DELETE\x27'+_0x44144d('0x1a')+_0x44144d('0xea')+_0x44144d('0x94')+_0x44144d('0x5f')+_0x44144d('0x14')+_0x44144d('0x98')+_0x44144d('0x91')+_0x44144d('0x5d')+_0x44144d('0x110')+_0x44144d('0x6f')+_0x44144d('0x13f')+_0x44144d('0xe2')+_0x44144d('0x6')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20403\x20THEN\x20\x27OutboundRoutes\x27'+_0x44144d('0x11e')+_0x44144d('0x116')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20406\x20THEN\x20\x27Voicemails\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20407\x20THEN\x20\x27MusicOnHolds\x27'+_0x44144d('0xf5')+_0x44144d('0x7f')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20410\x20THEN\x20\x27VoicePrefixes\x27'+_0x44144d('0x2c')+_0x44144d('0x80')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20501\x20THEN\x20\x27ChatQueues\x27'+_0x44144d('0x106')+_0x44144d('0x133')+_0x44144d('0x51')+_0x44144d('0x5b')+_0x44144d('0x100')+_0x44144d('0xaf')+_0x44144d('0x135')+_0x44144d('0x64')+_0x44144d('0x11d')+_0x44144d('0x5')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20710\x20THEN\x20\x27Realtime\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20800\x20THEN\x20\x27DELETE\x27'+_0x44144d('0xb1')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20802\x20THEN\x20\x27OpenchannelAccounts\x27'+_0x44144d('0x68')+_0x44144d('0xda')+_0x44144d('0x11c')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20902\x20THEN\x20\x27FaxAccounts\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20910\x20THEN\x20\x27Realtime\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201000\x20THEN\x20\x27DELETE\x27'+_0x44144d('0x124')+_0x44144d('0xcc')+_0x44144d('0x61')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201004\x20THEN\x20\x27Intervals\x27'+_0x44144d('0xa2')+_0x44144d('0x77')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201007\x20THEN\x20\x27Sounds\x27'+_0x44144d('0x9b')+_0x44144d('0x85')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201010\x20THEN\x20\x27Triggers\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201011\x20THEN\x20\x27Trunks\x27'+_0x44144d('0x7e')+_0x44144d('0x143')+_0x44144d('0x62')+_0x44144d('0x95')+_0x44144d('0x87')+_0x44144d('0x6b')+_0x44144d('0x5a')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201202\x20THEN\x20\x27ExtractedReports\x27'+_0x44144d('0x67')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201300\x20THEN\x20\x27DELETE\x27'+_0x44144d('0xa3')+_0x44144d('0x48')+_0x44144d('0xbc')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201305\x20THEN\x20\x27SugarcrmAccounts\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201306\x20THEN\x20\x27DeskAccounts\x27'+_0x44144d('0x38')+_0x44144d('0xe3')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201400\x20THEN\x20\x27Settings\x27'+_0x44144d('0x12f')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201500\x20THEN\x20\x27DELETE\x27'+_0x44144d('0x89')+_0x44144d('0x28')+_0x44144d('0x45')+_0x44144d('0x115')+_0x44144d('0x66')+_0x44144d('0x33')+_0x44144d('0x2f')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20between\x2088889\x20AND\x2099999\x20THEN\x20\x27Plugins\x27'+_0x44144d('0x4d')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ELSE\x20\x27\x27'+_0x44144d('0x30')+_0x44144d('0x122')+_0x44144d('0x8f')+'\x20\x20\x20\x20\x20\x20CASE'+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20100\x20THEN\x20\x27Dashboards\x27'+_0x44144d('0x145')+_0x44144d('0x3a')+_0x44144d('0xd5')+_0x44144d('0x144')+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(501,\x20502,\x20510)\x20THEN\x20\x27Chat\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(601,\x20602,\x20603,\x20610)\x20THEN\x20\x27Mail\x27'+_0x44144d('0x86')+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(801,\x20802,\x20810)\x20THEN\x20\x27Openchannel\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(901,\x20902,\x20910)\x20THEN\x20\x27Fax\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(1001,\x201002,\x201003,\x201004,\x201005,\x201006,\x201007,\x201008,\x201009,\x201010,\x201011,\x201012)\x20THEN\x20\x27Tools\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(1101,\x201102,\x201103)\x20THEN\x20\x27CallySquare\x27'+_0x44144d('0x78')+_0x44144d('0xde')+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201400\x20THEN\x20\x27Settings\x27'+_0x44144d('0xaa')+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201600\x20THEN\x20\x27Help\x27'+_0x44144d('0x7b')+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20between\x2088889\x20AND\x2099999\x20THEN\x20\x27AppZone\x27'+_0x44144d('0x69')+_0x44144d('0x82')+'\x20\x20);'),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0xfe')+_0x44144d('0xc')),_0x3f1e46[_0x44144d('0x40')]('CREATE\x20TABLE\x20tmpCustomResources'+_0x44144d('0x36')+_0x44144d('0x141')+_0x44144d('0x128')+_0x44144d('0x108')+_0x44144d('0x1c')+_0x44144d('0x12d')+_0x44144d('0x1b')+_0x44144d('0x119')+_0x44144d('0x137')+_0x44144d('0x2d')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x132')+'\x20\x20SELECT\x20*'+_0x44144d('0x52')+'\x20\x20WHERE\x20name\x20in\x20(\x27Plugins\x27,\x20\x27CustomDashboards\x27);'),_0x3f1e46[_0x44144d('0x40')]('DELETE\x20t1\x20FROM\x20tmpSections\x20t1,\x20tmpCustomResources\x20t2'+_0x44144d('0x96')),_0x3f1e46[_0x44144d('0x40')]('UPDATE\x20tmpSections'+_0x44144d('0x104')),_0x3f1e46['query']('UPDATE\x20tmpSections'+_0x44144d('0xd')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0xf6')+_0x44144d('0xec')),_0x3f1e46['query']('UPDATE\x20tmpCustomResources'+'\x20\x20SET\x20insertedId\x20=\x20(SELECT'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20CASE'+_0x44144d('0xfa')+_0x44144d('0x2')+_0x44144d('0xa0')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20);'),_0x3f1e46[_0x44144d('0x40')]('INSERT\x20INTO\x20user_profile_has_sections\x20(name,\x20category,\x20sectionId,\x20enabled,\x20autoAssociation,\x20crudPermissions,\x20createdAt,\x20updatedAt,\x20userProfileId)'+_0x44144d('0x49')+_0x44144d('0x11')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x75')+'\x20\x20SET\x20insertedId\x20=\x20(SELECT\x20id'+_0x44144d('0x13b')+_0x44144d('0x10f')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x5e')+_0x44144d('0x7c')+'\x20\x20WHERE\x20r.name\x20=\x20s.name\x20AND\x20r.userProfileId\x20=\x20s.userProfileId;'),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x26')+'\x20\x20('+_0x44144d('0x4e')+_0x44144d('0xf4')+'\x20\x20\x20\x20\x20\x20insertedSectionId\x20int(11)\x20not\x20null,'+_0x44144d('0xcf')+'\x20\x20);'),_0x3f1e46['query']('INSERT\x20INTO\x20tmpResources'+_0x44144d('0xd6')+_0x44144d('0xca')+'\x20\x20INNER\x20JOIN\x20tmpExtractedResources\x20cr\x20ON\x20cr.userId\x20=\x20s.userId\x20AND\x20cr.sectionId\x20=\x20s.sectionId\x20AND\x20cr.resourceId\x20IS\x20NOT\x20NULL;'),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x11a')+'\x20\x20('+_0x44144d('0x141')+_0x44144d('0x27')+'\x20\x20\x20\x20type\x20varchar(255)\x20not\x20null,'+'\x20\x20\x20\x20insertedSectionId\x20int(11)\x20not\x20null,'+_0x44144d('0xbf')+_0x44144d('0x2d')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x138')+_0x44144d('0xc6')+_0x44144d('0x81')+'\x20\x20\x20\x20\x20\x20\x20\x20SUBSTRING_INDEX(SUBSTRING_INDEX(r.resourceId,\x20\x27,\x27,\x20tally.n),\x20\x27,\x27,\x20-1)\x20resourceId,'+_0x44144d('0x47')+_0x44144d('0xd7')+_0x44144d('0x56')+_0x44144d('0xcb')+'\x20\x20\x20\x20\x20\x20\x20\x20INNER\x20JOIN\x20tmpResources\x20r\x20ON\x20CHAR_LENGTH(r.resourceId)\x20-\x20CHAR_LENGTH(REPLACE(r.resourceId,\x20\x27,\x27,\x20\x27\x27))\x20>=\x20tally.n-1'+_0x44144d('0xd3')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x138')+_0x44144d('0x103')+_0x44144d('0x59')),_0x3f1e46[_0x44144d('0x40')]('UPDATE\x20tmpNormalizedResources\x20x'+_0x44144d('0xc9')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20CASE'+_0x44144d('0xf9')+_0x44144d('0xab')+'\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20502\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20chat_websites\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)'+_0x44144d('0xa6')+'\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20602\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20mail_accounts\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)'+_0x44144d('0x123')+_0x44144d('0x37')+_0x44144d('0xee')+_0x44144d('0xf3')+_0x44144d('0xac')+_0x44144d('0x10c')+_0x44144d('0xd1')+_0x44144d('0xbe')+_0x44144d('0x2a')+_0x44144d('0xeb')+_0x44144d('0x19')+_0x44144d('0x21')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x107')+'\x20\x20WHERE\x20name\x20=\x20\x27DELETE_MIGRATION\x27;'),_0x3f1e46['query']('INSERT\x20INTO\x20user_profile_has_resources\x20(name,\x20resourceId,\x20type,\x20createdAt,\x20updatedAt,\x20sectionId)'+_0x44144d('0xfd')+_0x44144d('0x2b')),_0x3f1e46[_0x44144d('0x40')]('UPDATE\x20users\x20u,\x20tmpFinalProfiles\x20f'+'\x20\x20SET\x20u.userProfileId\x20=\x20f.profileId'+_0x44144d('0xc1')),_0x3f1e46['query']('UPDATE\x20users\x20u'+_0x44144d('0x34')+'\x20\x20WHERE\x20userProfileId\x20is\x20null\x20AND\x20role\x20=\x20\x27user\x27;'),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x7d')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0xb7')),_0x3f1e46['query']('DROP\x20TABLE\x20IF\x20EXISTS\x20tmpNormalizedSections;'),_0x3f1e46['query'](_0x44144d('0x65')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x2e')),_0x3f1e46[_0x44144d('0x40')]('DROP\x20TABLE\x20IF\x20EXISTS\x20tmpGroupedPermissions;'),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x44')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x142')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0x4a')),_0x3f1e46['query'](_0x44144d('0xff')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0xe4')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0xc7')),_0x3f1e46[_0x44144d('0x40')](_0x44144d('0xd8')),_0x3f1e46['final'](_0x120022);});},'down':function(){}};
\ No newline at end of file