Built motion from commit 973e3e332e1c8e2f84c4b0cd2e5af794131724f5. 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 3c5f88c..e0f1cbb 100644 (file)
--- a/server/migrations/2.1.0.js
+++ b/server/migrations/2.1.0.js
@@ -1 +1 @@
-const a964_0x505b=['\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','query','\x20\x20\x20\x20autoAssociation\x20tinyint\x20not\x20null,','\x20\x20PRIMARY\x20KEY\x20(`id`),','SELECT\x20NULL\x20FROM','join','\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\x20permissions\x20text\x20not\x20null','../config/logger','\x20\x20WHERE\x20x.sectionId\x20=\x20801;','\x20\x20\x20\x20enabled\x20tinyint\x20not\x20null,','\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','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(301,\x20302,\x20303,\x20304)\x20THEN\x20\x27ContactManager\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','\x20\x20SELECT\x20x.sectionId,\x20u.FaxAccountId,\x20x.userId','\x20\x20INNER\x20JOIN\x20voice_queues\x20q\x20ON\x20u.VoiceQueueId\x20=\x20q.id','\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\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(801,\x20802,\x20810)\x20THEN\x20\x27Openchannel\x27','\x20\x20WHERE\x20userId\x20NOT\x20IN\x20(SELECT\x20split.userId','\x20\x20\x20\x20\x20\x20\x20\x20r.insertedSectionId\x20insertedSectionId,','then','changeColumn','\x20\x20\x20\x20\x20\x20insertedSectionId\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=\x20400\x20THEN\x20\x27DELETE\x27','users','INSERT\x20INTO\x20tmpPermissions','INSERT\x20INTO\x20tmpSingleProfiles','\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','CREATE\x20TABLE\x20tmpSingleProfiles','\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','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpNormalizedResources;','\x20\x20\x20\x20\x20\x20\x20\x20SUBSTRING_INDEX(SUBSTRING_INDEX(r.resourceId,\x20\x27,\x27,\x20tally.n),\x20\x27,\x27,\x20-1)\x20resourceId,','\x20\x20KEY\x20`compositeIndex`\x20(`resourceId`,`sectionId`),','\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\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','\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','INSERT\x20INTO\x20user_profile_has_sections\x20(name,\x20category,\x20sectionId,\x20enabled,\x20autoAssociation,\x20crudPermissions,\x20createdAt,\x20updatedAt,\x20userProfileId)','REFERENCES\x20user_profiles(`id`)\x20','\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\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=\x20502\x20THEN\x20\x27ChatWebsites\x27','\x20\x20SELECT\x20id,\x20permissions,\x20null','\x20\x20WHERE\x20u.id\x20=\x20t.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\x20`enabled`\x20tinyint(1)\x20DEFAULT\x20NULL,','\x20\x20);','\x20\x20`type`\x20varchar(255)\x20NOT\x20NULL,','\x20\x20`sectionId`\x20int(11)\x20DEFAULT\x20NULL,','CREATE\x20TABLE\x20`user_profile_has_sections`\x20(','addIndex\x20%s\x20%s\x20%s','INSERT\x20INTO\x20tmpCustomResources','CREATE\x20TABLE\x20tmpCustomResources','\x20\x20`updatedAt`\x20datetime\x20NOT\x20NULL,','\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.type\x20=\x20\x27Plugins\x27\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20plugins\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=\x20302\x20THEN\x20\x27Companies\x27','\x20\x20\x20\x20\x20\x20resourceId\x20text,','Added\x20column\x20%s\x20to\x20%s','INSERT\x20INTO\x20tmpSections','\x20\x20\x20\x20t.permissions\x20permissions','\x20\x20KEY\x20`userProfileId`\x20(`userProfileId`),','\x20\x20INNER\x20JOIN\x20user_has_fax_accounts\x20u\x20ON\x20u.UserId\x20=\x20x.userId',')\x20ENGINE=InnoDB\x20DEFAULT\x20CHARSET=utf8;','\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','FOREIGN\x20KEY\x20(`userProfileId`)\x20','\x20\x20`resourceId`\x20int(11)\x20NOT\x20NULL,','\x20\x20FROM\x20tmpNormalizedUsers\x20x','\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=\x20405\x20THEN\x20\x27Contexts\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20CASE','\x20\x20`userProfileId`\x20int(11)\x20DEFAULT\x20NULL,','\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\x20SELECT\x20x.sectionId,\x20u.ChatWebsiteId,\x20x.userId','INSERT\x20INTO\x20tmpExtractedResources','\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\x20n\x20INT\x20NOT\x20NULL\x20AUTO_INCREMENT\x20PRIMARY\x20KEY','\x20\x20\x20\x20\x20\x20userIds\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=\x201500\x20THEN\x20\x27DELETE\x27','\x20\x20\x20\x20\x20\x20WHEN\x20name\x20=\x20\x27Plugins\x27\x20THEN\x20(sectionId\x20-\x2088888)','\x20\x20\x20\x20\x20\x20name\x20=\x20(SELECT','\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\x20WHERE\x20x.sectionId\x20=\x20501;','\x20\x20INNER\x20JOIN\x20user_has_openchannel_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId',',(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','\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\x27\x27,\x20resourceId,\x20type,\x20insertedSectionId,\x20sectionId','\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\x20WHERE\x20u.id\x20=\x20f.userId;','\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','\x20\x20sectionId\x20int(11)\x20not\x20null,','removeIndex\x20%s\x20%s','query\x20%s','\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','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=\x20304\x20THEN\x20\x27GlobalCustomFields\x27','\x20\x20WHERE\x20userProfileId\x20is\x20null\x20AND\x20role\x20=\x20\x27user\x27;','\x20\x20UNION','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(501,\x20502,\x20510)\x20THEN\x20\x27Chat\x27','\x20\x20WHERE\x20x.sectionId\x20=\x201103;','UPDATE\x20tmpSections','\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=\x201005\x20THEN\x20\x27Pauses\x27','CREATE\x20TABLE\x20tmpExtractedResources\x20(',',(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\x20tmpSections;','\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=\x201010\x20THEN\x20\x27Triggers\x27','UPDATE\x20tmpFinalProfiles','\x20\x20SELECT\x20userId,\x20permissions','UPDATE\x20users\x20u,\x20tmpNormalizedPermissions\x20t','\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20tally','util','\x20\x20WHERE\x20role\x20=\x20\x27user\x27\x20and\x20permissions\x20is\x20not\x20null\x20and\x20permissions\x20<>\x20\x27\x27','\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\x20x.sectionId\x20=\x20902;','\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\x20type\x20varchar(255)\x20not\x20null,','addColumn','\x20\x20\x20\x20name\x20varchar(255)\x20not\x20null,','\x20\x20INNER\x20JOIN\x20user_has_openchannel_accounts\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20INNER\x20JOIN\x20user_has_square_projects\x20u\x20ON\x20u.UserId\x20=\x20x.userId','INSERT\x20INTO\x20tmpGroupedPermissions','sequence','addIndex','\x20\x20INNER\x20JOIN\x20user_has_chat_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20\x20\x20userId\x20text,','\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\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=\x201303\x20THEN\x20\x27FreshdeskAccounts\x27','\x20\x20`name`\x20varchar(255)\x20NOT\x20NULL,','\x20\x20\x20\x20SUBSTRING_INDEX(SUBSTRING_INDEX(t.userIds,\x20\x27,\x27,\x20tally.n),\x20\x27,\x27,\x20-1)\x20userId,','\x20\x20\x20\x20\x20\x20profileId\x20int(11)','INSERT\x20INTO\x20tally\x20(n)','\x20\x20SELECT\x20*','\x20\x20\x20\x20sectionId\x20int(11)','CREATE\x20TABLE\x20tmpSections','\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\x20KEY\x20`sectionId`\x20(`sectionId`),','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpResources;','\x20\x20FROM\x20tmpCustomResources;','\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','ADD\x20CONSTRAINT\x20`users_ibfk_1`\x20','tail','\x20\x20WHERE\x20split.userId\x20IN\x20(SELECT\x20*\x20FROM','\x20\x20\x20\x20\x20\x20sectionId\x20int(11)','\x20\x20FROM\x20tmpNormalizedResources;','\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','sequelize','\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\x20t','\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\x20\x20\x20\x20\x20\x20\x20\x20WHERE\x20position(\x27,\x27\x20in\x20b.users)\x20=\x200))','\x20\x20INNER\x20JOIN\x20tmpExtractedResources\x20cr\x20ON\x20cr.userId\x20=\x20s.userId\x20AND\x20cr.sectionId\x20=\x20s.sectionId\x20AND\x20cr.resourceId\x20IS\x20NOT\x20NULL;','removeColumn','\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\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\x20WHEN\x20sectionId\x20=\x201600\x20THEN\x20\x27Help\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)','\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','queryInterface','dropTable','\x20\x20\x20\x20resourceId\x20int(11)\x20not\x20null,','\x20\x20CROSS\x20JOIN\x20(SELECT\x20@cnt\x20:=\x200)\x20as\x20dummy\x20LIMIT\x201)),\x20\x27red\x27,\x20now(),\x20now()','\x20\x20`crudPermissions`\x20varchar(255)\x20DEFAULT\x20NULL,','\x20\x20SELECT\x20x.sectionId,\x20u.SmsQueueId,\x20x.userId','\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','\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\x20WHERE\x20r.name\x20=\x20s.name\x20AND\x20r.userProfileId\x20=\x20s.userProfileId;','migration','\x20\x20WHERE\x20name\x20in\x20(\x27Plugins\x27,\x20\x27CustomDashboards\x27);','removeIndex','\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\x20INNER\x20JOIN\x20user_has_sms_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','CREATE\x20TABLE\x20tmpNormalizedUsers','inspect','INSERT\x20INTO\x20tmpFinalProfiles','stringify','\x20\x20SELECT\x20x.sectionId,\x20u.VoiceQueueId,\x20x.userId','\x20\x20resourceId\x20int(11),','\x20\x20SELECT\x20\x27\x27,\x20insertedId,\x20name,\x20sectionId,\x20null','\x20\x20\x20\x20p.userIds\x20userId','\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)','(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\x20\x20\x20\x20\x20\x20\x20\x20\x20END','TRUNCATE\x20TABLE\x20tmpPermissions;','\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\x20SELECT\x20x.sectionId,\x20u.FaxQueueId,\x20x.userId','\x20\x20WHERE\x20name\x20=\x20\x27DELETE\x27;','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(1101,\x201102,\x201103)\x20THEN\x20\x27CallySquare\x27','CREATE\x20TABLE\x20tmpPermissions','\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\x20SUBSTRING_INDEX(SUBSTRING_INDEX(p.permissions,\x20\x27,\x27,\x20tally.n),\x20\x27,\x27,\x20-1)\x20permission,','DELETE\x20FROM\x20tmpSections','\x20\x20FROM\x20tmpGroupedPermissions',',(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','INSERT\x20INTO\x20tmpNormalizedResources','name','userProfileId','\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\x20WHEN\x20sectionId\x20in\x20(1501,\x201502,\x201510)\x20THEN\x20\x27MotionDialer\x27','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpPermissions;','\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\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\x20WHEN\x20sectionId\x20=\x20910\x20THEN\x20\x27Realtime\x27','\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\x20WHEN\x20sectionId\x20between\x2088889\x20AND\x2099999\x20THEN\x20\x27AppZone\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20END','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpSharedProfiles;','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20100\x20THEN\x20\x27Dashboards\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\x20INNER\x20JOIN\x20user_has_voice_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','table\x20dropped\x20%s','\x20\x20FROM\x20users','\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\x20SET\x20autoAssociation\x20=\x201\x20WHERE\x20sectionId\x20=\x20100;','INTEGER','\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','\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','INSERT\x20INTO\x20tmpNormalizedPermissions','\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\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20810\x20THEN\x20\x27Realtime\x27','UPDATE\x20tmpCustomResources\x20r,\x20tmpSections\x20s','\x20\x20INNER\x20JOIN\x20user_has_sms_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\x20\x20FROM\x20user_profile_has_sections\x20x','exports','\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=\x20411\x20THEN\x20\x27Realtime\x27','\x20\x20INNER\x20JOIN\x20user_has_chat_websites\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20KEY\x20`compositeIndex`\x20(`sectionId`,`userProfileId`),','\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\x20r.sectionId\x20sectionId','\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\x20`createdAt`\x20datetime\x20NOT\x20NULL,','\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\x20WHEN\x20sectionId\x20=\x20700\x20THEN\x20\x27DELETE\x27','STRING','INSERT\x20INTO\x20tmpSharedProfiles','\x20DROP\x20TABLE\x20IF\x20EXISTS\x20tally;','ON\x20UPDATE\x20CASCADE','\x20\x20WHERE\x20t1.name\x20=\x20t2.name\x20AND\x20t1.userProfileId\x20=\x20t2.userProfileId\x20AND\x20t1.sectionId\x20>\x20t2.sectionId;','\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=\x20601\x20THEN\x20\x27MailQueues\x27','\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','finally','\x20\x20\x20\x20sectionId\x20int(11)\x20not\x20null,','\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=\x201202\x20THEN\x20\x27ExtractedReports\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','INSERT\x20INTO\x20tmpResources','\x20\x20\x20\x20\x20\x20\x20\x20fp.profileId\x20profileId,','\x20\x20ORDER\x20BY\x20userId;','\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\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20203\x20THEN\x20\x27Telephones\x27','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpGroupedPermissions;','CREATE\x20TABLE\x20tmpNormalizedPermissions','\x20\x20FROM\x20tmpSections\x20s','\x20\x20SELECT\x20GROUP_CONCAT(sectionId\x20ORDER\x20BY\x20sectionId),\x20userId','\x20\x20\x20\x20\x20\x20END','\x20\x20SELECT\x20x.sectionId,\x20u.SquareProjectId,\x20x.userId','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpSections;','\x20\x20SELECT\x20cr.resourceId,\x20name,\x20s.insertedId,\x20s.sectionId','\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','final','\x20\x20WHERE\x20x.sectionId\x20=\x20401\x20AND\x20q.type\x20=\x20\x27inbound\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=\x201103\x20THEN\x20\x27SquareProjects\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\x20FROM\x20tmpNormalizedUsers','\x20\x20SET\x20sectionId\x20=\x201801\x20WHERE\x20sectionId\x20between\x2088889\x20AND\x2099999;','\x20\x20\x20\x20\x20\x20permissions\x20text\x20not\x20null,','\x20\x20SELECT\x20userId,\x20permissions,\x20null','\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','CREATE\x20TABLE\x20tmpGroupedPermissions','\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`id`\x20int(11)\x20NOT\x20NULL\x20AUTO_INCREMENT,','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(1201,\x201202,\x201203)\x20THEN\x20\x27Analytics\x27','\x20\x20\x20\x20userId\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=\x201203\x20THEN\x20\x27Reports\x27','\x20\x20SELECT\x20GROUP_CONCAT(userId),\x20permissions,\x20null','\x20\x20SET\x20insertedId\x20=\x20(SELECT\x20id','\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\x20SELECT\x20name,\x20resourceId,\x20type,\x20now(),\x20now(),\x20insertedSectionId','\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\x20insertedId\x20int(11),','\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','INSERT\x20INTO\x20tmpNormalizedUsers','\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','Removed\x20column\x20%s\x20from\x20%s','UPDATE\x20tmpSections\x20s','\x20\x20SELECT\x20permission,\x20userId,\x200','\x20\x20\x20\x20\x20\x20userId\x20text\x20not\x20null,','\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\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\x20WHEN\x20sectionId\x20=\x201400\x20THEN\x20\x27Settings\x27','CREATE\x20TABLE\x20`user_profiles`\x20(','\x20\x20ORDER\x20BY\x20id;','CREATE\x20TABLE\x20tmpSharedProfiles','\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\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\x20\x20\x20\x20\x20ORDER\x20BY\x20n)\x20AS\x20split;','\x20\x20\x20\x20permissions\x20text\x20not\x20null,','INSERT\x20INTO\x20user_profile_has_resources\x20(name,\x20resourceId,\x20type,\x20createdAt,\x20updatedAt,\x20sectionId)','\x20\x20SELECT\x20x.sectionId,\x20u.ChatQueueId,\x20x.userId','\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\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=\x201510\x20THEN\x20\x27Realtime\x27','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201600\x20THEN\x20\x27Help\x27','\x20\x20WHERE\x20x.sectionId\x20=\x20502;','reportType','\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\x20=\x20401\x20THEN\x20\x27VoiceQueues\x27','\x20\x20SET\x20insertedId\x20=\x20(SELECT','\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\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201301\x20THEN\x20\x27ZendeskAccounts\x27','\x20\x20\x20\x20insertedSectionId\x20int(11)\x20not\x20null,','\x20\x20GROUP\x20BY\x20permissions','VALUES\x20(\x27Default\x27,\x20\x27red\x27,\x20NULL,\x20NOW(),\x20NOW());','\x20\x20s.sectionId\x20permission,','\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)','Renamed\x20column\x20from\x20%s\x20to\x20%s\x20on\x20%s','INSERT\x20INTO\x20tmpNormalizedSections','\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\x20SET','INSERT\x20INTO\x20`user_profiles`\x20(`name`,\x20`crudPermissions`,\x20`description`,\x20`createdAt`,\x20`updatedAt`)','\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\x20SET\x20u.userProfileId\x20=\x201','\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)','UPDATE\x20tmpNormalizedResources\x20x','\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`category`\x20varchar(255)\x20NOT\x20NULL,','enqueue','\x20\x20WHERE\x20x.sectionId\x20=\x20602;','\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=\x201300\x20THEN\x20\x27DELETE\x27','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpCustomResources;','\x20\x20\x20\x20userProfileId\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\x20INNER\x20JOIN\x20user_has_fax_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20SELECT\x20name,\x20category,\x20sectionId,\x20enabled,\x20autoAssociation,\x20\x27red\x27,\x20now(),\x20now(),\x20userProfileId','analytics_extracted_reports','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpNormalizedSections;','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20>=\x20100000\x20THEN\x20\x27Tools\x27','reportId','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpNormalizedUsers;','\x20\x20\x20\x20category\x20varchar(255)\x20not\x20null,','INSERT\x20INTO\x20user_profiles\x20(name,\x20crudPermissions,\x20createdAt,\x20updatedAt)','\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','CREATE\x20TABLE\x20tmpNormalizedResources','info','UPDATE\x20users\x20u,\x20tmpFinalProfiles\x20f','\x20\x20FROM\x20tmpSections','\x20\x20SELECT\x20x.sectionId,\x20u.MailQueueId,\x20x.userId','catch','\x20\x20(','prototype','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20),','\x20\x20FROM\x20(SELECT','\x20\x20SET\x20r.sectionId\x20=\x20s.insertedId','\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\x20WHERE\x20x.sectionId\x20=\x20601;'];(function(_0x3a8427,_0x505b74){const _0x1a00b0=function(_0x26962f){while(--_0x26962f){_0x3a8427['push'](_0x3a8427['shift']());}};_0x1a00b0(++_0x505b74);}(a964_0x505b,0x1d6));const a964_0x1a00=function(_0x3a8427,_0x505b74){_0x3a8427=_0x3a8427-0x0;let _0x1a00b0=a964_0x505b[_0x3a8427];return _0x1a00b0;};const _0x28f830=a964_0x1a00;'use strict';const util=require(_0x28f830('0x1')),logger=require(_0x28f830('0x102'))(_0x28f830('0x3a')),Sequence=function(){};Sequence['prototype']['enqueue']=function(_0x26962f){const _0x5d9b5b=_0x28f830;this['tail']=this[_0x5d9b5b('0x20')]?this[_0x5d9b5b('0x20')][_0x5d9b5b('0x86')](_0x26962f):_0x26962f();};const Migration=function(_0x321640){const _0x22447d=_0x28f830;this[_0x22447d('0x31')]=_0x321640,this[_0x22447d('0xc')]=new Sequence();};Migration[_0x28f830('0xf4')][_0x28f830('0x10f')]=function(_0x621942,_0x31797c,_0xc5fcd3){const _0x24c841=_0x28f830,_0x5a4d13=this;this['sequence'][_0x24c841('0xdc')](function(){const _0x3cfe1c=_0x24c841;return _0x5a4d13['queryInterface'][_0x3cfe1c('0x10f')](_0x621942,_0x31797c,_0xc5fcd3)[_0x3cfe1c('0x10e')](function(){const _0x248979=_0x3cfe1c;logger[_0x248979('0xee')](_0x248979('0x157'),_0x31797c,_0x621942);})['catch'](function(_0x1bb343){const _0x5955be=_0x3cfe1c;logger[_0x5955be('0xee')](JSON['stringify'](_0x1bb343));});});},Migration[_0x28f830('0xf4')]['addColumn']=function(_0x353a25,_0x5355c4,_0x5b20cf){const _0x334dec=_0x28f830,_0x258a24=this;this[_0x334dec('0xc')][_0x334dec('0xdc')](function(){const _0x2f09dd=_0x334dec;return _0x258a24[_0x2f09dd('0x31')][_0x2f09dd('0x7')](_0x353a25,_0x5355c4,_0x5b20cf)[_0x2f09dd('0x10e')](function(){const _0x943e19=_0x2f09dd;logger[_0x943e19('0xee')](_0x943e19('0x133'),_0x5355c4,_0x353a25);})[_0x2f09dd('0xf2')](function(_0x59330c){const _0xde8eb7=_0x2f09dd;logger[_0xde8eb7('0xee')](JSON[_0xde8eb7('0x42')](_0x59330c));});});},Migration[_0x28f830('0xf4')]['dropTable']=function(_0x24598a){const _0x515ac9=_0x28f830,_0x23dc70=this;this[_0x515ac9('0xc')][_0x515ac9('0xdc')](function(){const _0x3ab108=_0x515ac9;return _0x23dc70['queryInterface'][_0x3ab108('0x32')](_0x24598a,{'force':!![]})['then'](function(){const _0x58342e=_0x3ab108;logger[_0x58342e('0xee')](_0x58342e('0x65'),_0x24598a);})[_0x3ab108('0xf2')](function(_0x4d081c){const _0x4e9740=_0x3ab108;logger[_0x4e9740('0xee')](JSON[_0x4e9740('0x42')](_0x4d081c));});});},Migration[_0x28f830('0xf4')][_0x28f830('0xd')]=function(_0x58f88b,_0x3fc8d4,_0x568175){const _0x1f6aa8=_0x28f830,_0x1e3565=this;this[_0x1f6aa8('0xc')][_0x1f6aa8('0xdc')](function(){const _0x351a01=_0x1f6aa8;return _0x1e3565[_0x351a01('0x31')][_0x351a01('0xd')](_0x58f88b,_0x3fc8d4,{'indexName':_0x568175})['then'](function(){const _0xf09222=_0x351a01;logger[_0xf09222('0xee')](_0xf09222('0x12b'),_0x58f88b,_0x3fc8d4[_0xf09222('0xff')](','),_0x568175);})[_0x351a01('0xf2')](function(_0x130703){logger['info'](JSON['stringify'](_0x130703));});});},Migration[_0x28f830('0xf4')][_0x28f830('0x3c')]=function(_0x1c9533,_0x222c82){const _0x107c87=this;this['sequence']['enqueue'](function(){const _0x561050=a964_0x1a00;return _0x107c87['queryInterface'][_0x561050('0x3c')](_0x1c9533,_0x222c82)[_0x561050('0x10e')](function(){const _0x3016e4=_0x561050;logger['info'](_0x3016e4('0x154'),_0x1c9533,_0x222c82);})['catch'](function(_0x51b2bb){logger['info'](JSON['stringify'](_0x51b2bb));});});},Migration['prototype']['query']=function(_0xb60088){const _0x1cea5c=_0x28f830,_0x546302=this;this[_0x1cea5c('0xc')][_0x1cea5c('0xdc')](function(){const _0x13e400=_0x1cea5c;return _0x546302['queryInterface'][_0x13e400('0x25')][_0x13e400('0xfb')](_0xb60088)['then'](function(){const _0xe9acf7=_0x13e400;logger[_0xe9acf7('0xee')](_0xe9acf7('0x155'),_0xb60088);})[_0x13e400('0xf2')](function(_0x43775e){const _0x11dd97=_0x13e400;logger['info'](JSON[_0x11dd97('0x42')](_0x43775e));});});},Migration[_0x28f830('0xf4')]['removeColumn']=function(_0x5e926b,_0x16f4c1){const _0x64e552=_0x28f830,_0x5aa1fd=this;this['sequence'][_0x64e552('0xdc')](function(){const _0x3aed3c=_0x64e552;return _0x5aa1fd['queryInterface'][_0x3aed3c('0x2b')](_0x5e926b,_0x16f4c1)[_0x3aed3c('0x10e')](function(){const _0x2cd2e0=_0x3aed3c;logger['info'](_0x2cd2e0('0xb1'),_0x16f4c1,_0x5e926b);})[_0x3aed3c('0xf2')](function(_0x201f50){const _0x3529c1=_0x3aed3c;logger[_0x3529c1('0xee')](util[_0x3529c1('0x40')](_0x201f50,{'showHidden':![],'depth':null}));});});},Migration[_0x28f830('0xf4')]['renameColumn']=function(_0x263cea,_0x512206,_0x5685bf){const _0xa1794f=_0x28f830,_0x32f87e=this;this[_0xa1794f('0xc')]['enqueue'](function(){const _0xa9b1ec=_0xa1794f;return _0x32f87e[_0xa9b1ec('0x31')]['renameColumn'](_0x263cea,_0x512206,_0x5685bf)[_0xa9b1ec('0x10e')](function(){const _0x427389=_0xa9b1ec;logger[_0x427389('0xee')](_0x427389('0xd1'),_0x512206,_0x5685bf,_0x263cea);})[_0xa9b1ec('0xf2')](function(_0x468e6d){const _0x5cb05c=_0xa9b1ec;logger[_0x5cb05c('0xee')](util[_0x5cb05c('0x40')](_0x468e6d,{'showHidden':![],'depth':null}));});});},Migration[_0x28f830('0xf4')][_0x28f830('0x99')]=function(_0x3fefc7){const _0x59f27d=_0x28f830;this[_0x59f27d('0xc')][_0x59f27d('0xdc')](function(){return _0x3fefc7();});},module[_0x28f830('0x72')]={'up':function(_0x3ef521,_0x1ec3fa){return new Promise(function(_0x4e41c8){const _0x1b0e31=a964_0x1a00,_0x3f330e=new Migration(_0x3ef521);_0x3f330e[_0x1b0e31('0x7')]('analytics_extracted_reports',_0x1b0e31('0xe8'),{'type':_0x1ec3fa[_0x1b0e31('0x69')]}),_0x3f330e[_0x1b0e31('0x7')](_0x1b0e31('0xe5'),_0x1b0e31('0xc6'),{'type':_0x1ec3fa[_0x1b0e31('0x7e')]}),_0x3f330e[_0x1b0e31('0x7')](_0x1b0e31('0x112'),_0x1b0e31('0x57'),{'type':_0x1ec3fa['INTEGER']}),_0x3f330e['removeColumn']('voice_voicemail',_0x1b0e31('0x56')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0xb8')+'\x20\x20`id`\x20int(11)\x20NOT\x20NULL\x20AUTO_INCREMENT,'+'\x20\x20`name`\x20varchar(255)\x20NOT\x20NULL,'+'\x20\x20`crudPermissions`\x20varchar(255)\x20NOT\x20NULL\x20DEFAULT\x20\x27r\x27,'+'\x20\x20`description`\x20varchar(255)\x20DEFAULT\x20NULL,'+_0x1b0e31('0x7b')+_0x1b0e31('0x12e')+_0x1b0e31('0xfd')+'\x20\x20UNIQUE\x20KEY\x20`name`\x20(`name`)'+')\x20ENGINE=InnoDB\x20DEFAULT\x20CHARSET=utf8;'),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0xd5')+_0x1b0e31('0xce')),_0x3f330e[_0x1b0e31('0xfb')]('ALTER\x20TABLE\x20`users`\x20'+_0x1b0e31('0x1f')+_0x1b0e31('0x13a')+_0x1b0e31('0x11f')+_0x1b0e31('0x81')),_0x3f330e['query'](_0x1b0e31('0x12a')+_0x1b0e31('0xa4')+_0x1b0e31('0x13')+_0x1b0e31('0xdb')+'\x20\x20`sectionId`\x20int(11)\x20NOT\x20NULL,'+_0x1b0e31('0x126')+'\x20\x20`autoAssociation`\x20tinyint(1)\x20DEFAULT\x20NULL,'+_0x1b0e31('0x35')+'\x20\x20`createdAt`\x20datetime\x20NOT\x20NULL,'+_0x1b0e31('0x12e')+_0x1b0e31('0x140')+_0x1b0e31('0xfd')+_0x1b0e31('0x136')+_0x1b0e31('0x76')+_0x1b0e31('0x10')+_0x1b0e31('0x138')),_0x3f330e[_0x1b0e31('0xfb')]('CREATE\x20TABLE\x20`user_profile_has_resources`\x20('+'\x20\x20`id`\x20int(11)\x20NOT\x20NULL\x20AUTO_INCREMENT,'+_0x1b0e31('0x13')+_0x1b0e31('0x13b')+_0x1b0e31('0x128')+'\x20\x20`createdAt`\x20datetime\x20NOT\x20NULL,'+_0x1b0e31('0x12e')+_0x1b0e31('0x129')+_0x1b0e31('0xfd')+_0x1b0e31('0x1b')+_0x1b0e31('0x11a')+_0x1b0e31('0x5b')+_0x1b0e31('0x138')),_0x3f330e[_0x1b0e31('0xfb')]('CREATE\x20TABLE\x20tally\x20('+_0x1b0e31('0x145')+');'),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x16')+_0x1b0e31('0xfe')+_0x1b0e31('0x48')+',(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'+_0x1b0e31('0x14d')+_0x1b0e31('0x54')+_0x1b0e31('0x161')+';'),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x4f')+_0x1b0e31('0xf3')+_0x1b0e31('0x146')+_0x1b0e31('0x9f')+'\x20\x20\x20\x20\x20\x20profileId\x20int(11)'+_0x1b0e31('0x127')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x113')+_0x1b0e31('0x123')+_0x1b0e31('0x66')+_0x1b0e31('0x2')+_0x1b0e31('0xb9')),_0x3f330e[_0x1b0e31('0xfb')]('CREATE\x20TABLE\x20tmpNormalizedSections'+_0x1b0e31('0xf3')+_0x1b0e31('0x87')+_0x1b0e31('0xf')+'\x20\x20\x20\x20resourceId\x20text'+_0x1b0e31('0x127')),_0x3f330e['query'](_0x1b0e31('0xd2')+'\x20\x20SELECT\x20DISTINCT\x20permission,\x20userId,\x200'+_0x1b0e31('0xf6')+_0x1b0e31('0x51')+_0x1b0e31('0x46')+'\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'+_0x1b0e31('0x11')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x91')+_0x1b0e31('0xf3')+_0x1b0e31('0xbe')+_0x1b0e31('0xa6')+_0x1b0e31('0x127')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x6c')+_0x1b0e31('0x93')+'\x20\x20FROM\x20tmpNormalizedSections'+'\x20\x20GROUP\x20BY\x20userId;'),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x167')+'\x20\x20SET\x20u.permissions\x20=\x20t.permissions'+_0x1b0e31('0x124')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x4a')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x113')+'\x20\x20SELECT\x20GROUP_CONCAT(id),\x20permissions,\x20null'+_0x1b0e31('0x66')+_0x1b0e31('0x2')+'\x20\x20GROUP\x20BY\x20permissions'+_0x1b0e31('0x121')),_0x3f330e['query'](_0x1b0e31('0x3f')+_0x1b0e31('0xf3')+_0x1b0e31('0x87')+_0x1b0e31('0xf')+'\x20\x20\x20\x20resourceId\x20text'+_0x1b0e31('0x127')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0xaf')+_0x1b0e31('0xb3')+_0x1b0e31('0xf6')+_0x1b0e31('0xcf')+_0x1b0e31('0x50')+_0x1b0e31('0x1e')+_0x1b0e31('0x11')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x160')+_0x1b0e31('0x153')+_0x1b0e31('0x44')+_0x1b0e31('0x88')+_0x1b0e31('0x127')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x143')+_0x1b0e31('0x43')+'\x20\x20FROM\x20tmpNormalizedUsers\x20x'+_0x1b0e31('0x64')+_0x1b0e31('0x109')+_0x1b0e31('0x9a')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x143')+_0x1b0e31('0xc0')+_0x1b0e31('0x13c')+_0x1b0e31('0xe')+_0x1b0e31('0x14b')),_0x3f330e[_0x1b0e31('0xfb')]('INSERT\x20INTO\x20tmpExtractedResources'+_0x1b0e31('0x142')+_0x1b0e31('0x13c')+_0x1b0e31('0x75')+_0x1b0e31('0xc5')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x143')+_0x1b0e31('0xf1')+'\x20\x20FROM\x20tmpNormalizedUsers\x20x'+'\x20\x20INNER\x20JOIN\x20user_has_mail_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId'+_0x1b0e31('0xf9')),_0x3f330e['query'](_0x1b0e31('0x143')+'\x20\x20SELECT\x20x.sectionId,\x20u.MailAccountId,\x20x.userId'+_0x1b0e31('0x13c')+_0x1b0e31('0x83')+_0x1b0e31('0xdd')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x143')+_0x1b0e31('0x36')+_0x1b0e31('0x13c')+_0x1b0e31('0x3e')+'\x20\x20WHERE\x20x.sectionId\x20=\x20701;'),_0x3f330e['query']('INSERT\x20INTO\x20tmpExtractedResources'+'\x20\x20SELECT\x20x.sectionId,\x20u.SmsAccountId,\x20x.userId'+_0x1b0e31('0x13c')+_0x1b0e31('0x70')+'\x20\x20WHERE\x20x.sectionId\x20=\x20702;'),_0x3f330e['query'](_0x1b0e31('0x143')+'\x20\x20SELECT\x20x.sectionId,\x20u.OpenchannelQueueId,\x20x.userId'+'\x20\x20FROM\x20tmpNormalizedUsers\x20x'+_0x1b0e31('0x14c')+_0x1b0e31('0x103')),_0x3f330e['query'](_0x1b0e31('0x143')+_0x1b0e31('0x5c')+_0x1b0e31('0x13c')+_0x1b0e31('0x9')+'\x20\x20WHERE\x20x.sectionId\x20=\x20802;'),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x143')+_0x1b0e31('0x4c')+_0x1b0e31('0x13c')+_0x1b0e31('0xe3')+'\x20\x20WHERE\x20x.sectionId\x20=\x20901;'),_0x3f330e['query'](_0x1b0e31('0x143')+_0x1b0e31('0x108')+_0x1b0e31('0x13c')+_0x1b0e31('0x137')+_0x1b0e31('0x4')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x143')+_0x1b0e31('0x95')+_0x1b0e31('0x13c')+_0x1b0e31('0xa')+_0x1b0e31('0x15c')),_0x3f330e['query'](_0x1b0e31('0x143')+_0x1b0e31('0x43')+_0x1b0e31('0x13c')+_0x1b0e31('0x64')+_0x1b0e31('0x109')+'\x20\x20WHERE\x20x.sectionId\x20=\x201501\x20AND\x20q.type\x20=\x20\x27outbound\x27;'),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0xa2')+_0x1b0e31('0xf3')+'\x20\x20\x20\x20\x20\x20userId\x20text\x20not\x20null,'+_0x1b0e31('0x101')+'\x20\x20);'),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0xb')+_0x1b0e31('0x166')+_0x1b0e31('0xf6')+_0x1b0e31('0x14')+_0x1b0e31('0x135')+_0x1b0e31('0x85')+_0x1b0e31('0x11')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0xba')+_0x1b0e31('0xf3')+_0x1b0e31('0x146')+_0x1b0e31('0x9f')+_0x1b0e31('0x15')+_0x1b0e31('0x127')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x7f')+_0x1b0e31('0xa8')+_0x1b0e31('0x53')+_0x1b0e31('0x10c')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20(SELECT'+_0x1b0e31('0x73')+'\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'+_0x1b0e31('0x125')+_0x1b0e31('0x105')+'\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'+_0x1b0e31('0x21')+_0x1b0e31('0x141')+_0x1b0e31('0x2d')+_0x1b0e31('0xf8')+_0x1b0e31('0x1a')+_0x1b0e31('0x29')+_0x1b0e31('0xcd')+'\x20\x20ORDER\x20BY\x20GROUP_CONCAT(userId);'),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x116')+_0x1b0e31('0xf3')+_0x1b0e31('0xb4')+_0x1b0e31('0x9f')+_0x1b0e31('0x15')+_0x1b0e31('0x127')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x114')+_0x1b0e31('0xa0')+'\x20\x20FROM\x20tmpGroupedPermissions'+'\x20\x20WHERE\x20userId\x20IN\x20(SELECT\x20split.userId'+_0x1b0e31('0xc1')+_0x1b0e31('0x11c')+_0x1b0e31('0x100')+_0x1b0e31('0x28')+_0x1b0e31('0x21')+'\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'+_0x1b0e31('0x9d')+'\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'+_0x1b0e31('0xd3')+_0x1b0e31('0xa3')+_0x1b0e31('0x8d')),_0x3f330e[_0x1b0e31('0xfb')]('CREATE\x20TABLE\x20tmpFinalProfiles'+'\x20\x20('+_0x1b0e31('0xb4')+_0x1b0e31('0x9f')+_0x1b0e31('0x15')+'\x20\x20);'),_0x3f330e['query'](_0x1b0e31('0x41')+'\x20\x20SELECT\x20*\x20FROM\x20tmpSharedProfiles'+_0x1b0e31('0x15a')+'\x20\x20SELECT\x20*\x20FROM\x20tmpSingleProfiles;'),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0xeb')+'\x20\x20SELECT\x20CONCAT(\x27Profile_\x27,\x20(SELECT\x20(@cnt\x20:=\x20@cnt\x20+\x201)\x20AS\x20rowNumber'+_0x1b0e31('0x27')+_0x1b0e31('0x34')+'\x20\x20FROM\x20tmpFinalProfiles;'),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x165')+'\x20\x20SET\x20profileId\x20=\x20(SELECT\x20(@cnt\x20:=\x20@cnt\x20+\x201)\x20AS\x20rowNumber'+'\x20\x20FROM\x20user_profiles\x20u'+'\x20\x20CROSS\x20JOIN\x20(SELECT\x20@cnt\x20:=\x201)\x20as\x20dummy\x20LIMIT\x201)'),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x19')+_0x1b0e31('0xf3')+_0x1b0e31('0x8')+_0x1b0e31('0xea')+'\x20\x20\x20\x20sectionId\x20int(11)\x20not\x20null,'+'\x20\x20\x20\x20enabled\x20tinyint\x20not\x20null,'+_0x1b0e31('0xfc')+_0x1b0e31('0xe1')+_0x1b0e31('0xad')+'\x20\x20\x20\x20userId\x20text'+_0x1b0e31('0x127')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x134')+'\x20\x20SELECT\x20\x27\x27,\x20\x27\x27,\x20permission,\x201,\x200,\x20profileId,\x20null,\x20userId'+'\x20\x20FROM\x20(SELECT'+_0x1b0e31('0x8c')+_0x1b0e31('0x14a')+'\x20\x20\x20\x20\x20\x20\x20\x20SUBSTRING_INDEX(fp.userId,\x20\x27,\x27,\x201)\x20userId'+_0x1b0e31('0x0')+'\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'+_0x1b0e31('0xbd')),_0x3f330e['query'](_0x1b0e31('0x15d')+_0x1b0e31('0xd4')+_0x1b0e31('0x149')+_0x1b0e31('0x13f')+'\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'+_0x1b0e31('0xa1')+_0x1b0e31('0x30')+_0x1b0e31('0xb0')+_0x1b0e31('0xb6')+_0x1b0e31('0x8f')+_0x1b0e31('0x7a')+'\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'+_0x1b0e31('0x38')+_0x1b0e31('0x131')+'\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'+_0x1b0e31('0x158')+_0x1b0e31('0x111')+_0x1b0e31('0xc8')+'\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'+_0x1b0e31('0xae')+'\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'+_0x1b0e31('0x13e')+'\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'+_0x1b0e31('0x120')+_0x1b0e31('0xe2')+_0x1b0e31('0x5')+'\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'+_0x1b0e31('0x74')+'\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'+_0x1b0e31('0x115')+_0x1b0e31('0x122')+'\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\x20WHEN\x20sectionId\x20=\x20600\x20THEN\x20\x27DELETE\x27'+_0x1b0e31('0x84')+_0x1b0e31('0x37')+_0x1b0e31('0xaa')+'\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'+_0x1b0e31('0x7d')+'\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'+_0x1b0e31('0x13d')+_0x1b0e31('0x24')+_0x1b0e31('0x8a')+_0x1b0e31('0x2c')+'\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'+_0x1b0e31('0x6e')+_0x1b0e31('0x4b')+_0x1b0e31('0x14e')+_0x1b0e31('0x163')+_0x1b0e31('0x5d')+'\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'+_0x1b0e31('0x3d')+_0x1b0e31('0x117')+'\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'+_0x1b0e31('0xfa')+_0x1b0e31('0x15f')+'\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'+_0x1b0e31('0x98')+_0x1b0e31('0xb5')+_0x1b0e31('0x11b')+_0x1b0e31('0x164')+_0x1b0e31('0x152')+_0x1b0e31('0xde')+_0x1b0e31('0x6d')+_0x1b0e31('0x26')+_0x1b0e31('0x12f')+_0x1b0e31('0x9c')+_0x1b0e31('0x58')+'\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'+_0x1b0e31('0x89')+_0x1b0e31('0xa7')+_0x1b0e31('0xdf')+_0x1b0e31('0xcb')+_0x1b0e31('0x6b')+_0x1b0e31('0x12')+_0x1b0e31('0x144')+_0x1b0e31('0x6a')+'\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'+_0x1b0e31('0x107')+_0x1b0e31('0xec')+'\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'+_0x1b0e31('0x147')+'\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'+_0x1b0e31('0x67')+_0x1b0e31('0xc3')+_0x1b0e31('0x2e')+'\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'+_0x1b0e31('0xbb')+_0x1b0e31('0x150')+_0x1b0e31('0x15e')+_0x1b0e31('0x11d')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ELSE\x20\x27\x27'+_0x1b0e31('0x49')+_0x1b0e31('0xf5')+'\x20\x20category\x20=\x20(SELECT'+'\x20\x20\x20\x20\x20\x20CASE'+_0x1b0e31('0x62')+_0x1b0e31('0xe7')+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(202,\x20203,\x20204)\x20THEN\x20\x27Staff\x27'+_0x1b0e31('0x106')+_0x1b0e31('0xd6')+_0x1b0e31('0x15b')+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(601,\x20602,\x20603,\x20610)\x20THEN\x20\x27Mail\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(701,\x20702,\x20710)\x20THEN\x20\x27Sms\x27'+_0x1b0e31('0x10b')+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(901,\x20902,\x20910)\x20THEN\x20\x27Fax\x27'+_0x1b0e31('0x139')+_0x1b0e31('0x4e')+_0x1b0e31('0xa5')+_0x1b0e31('0xca')+_0x1b0e31('0xb7')+_0x1b0e31('0x59')+_0x1b0e31('0xc4')+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201701\x20THEN\x20\x27jscripty\x27'+_0x1b0e31('0x5f')+_0x1b0e31('0x78')+_0x1b0e31('0x94')+'\x20\x20);'),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x52')+_0x1b0e31('0x4d')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x12d')+'\x20\x20('+_0x1b0e31('0x8')+_0x1b0e31('0xea')+'\x20\x20\x20\x20sectionId\x20int(11)\x20not\x20null,'+_0x1b0e31('0x104')+_0x1b0e31('0xfc')+'\x20\x20\x20\x20userProfileId\x20int(11)\x20not\x20null,'+_0x1b0e31('0xad')+_0x1b0e31('0xc7')+_0x1b0e31('0x127')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x12c')+_0x1b0e31('0x17')+_0x1b0e31('0xf0')+_0x1b0e31('0x3b')),_0x3f330e[_0x1b0e31('0xfb')]('DELETE\x20t1\x20FROM\x20tmpSections\x20t1,\x20tmpCustomResources\x20t2'+_0x1b0e31('0x82')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x15d')+_0x1b0e31('0x9e')),_0x3f330e[_0x1b0e31('0xfb')]('UPDATE\x20tmpSections'+_0x1b0e31('0x7c')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x15d')+_0x1b0e31('0x68')),_0x3f330e[_0x1b0e31('0xfb')]('UPDATE\x20tmpCustomResources'+_0x1b0e31('0xc9')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20CASE'+_0x1b0e31('0x148')+_0x1b0e31('0xd8')+_0x1b0e31('0x60')+_0x1b0e31('0x77')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x11e')+_0x1b0e31('0xe4')+_0x1b0e31('0x162')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0xb2')+_0x1b0e31('0xa9')+_0x1b0e31('0x71')+_0x1b0e31('0xc2')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x6f')+_0x1b0e31('0xf7')+_0x1b0e31('0x39')),_0x3f330e[_0x1b0e31('0xfb')]('CREATE\x20TABLE\x20tmpResources'+_0x1b0e31('0xf3')+_0x1b0e31('0x132')+_0x1b0e31('0x9b')+_0x1b0e31('0x110')+_0x1b0e31('0x22')+_0x1b0e31('0x127')),_0x3f330e['query'](_0x1b0e31('0x8b')+_0x1b0e31('0x97')+_0x1b0e31('0x92')+_0x1b0e31('0x2a')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0xed')+_0x1b0e31('0xf3')+_0x1b0e31('0x8')+_0x1b0e31('0x33')+_0x1b0e31('0x6')+_0x1b0e31('0xcc')+_0x1b0e31('0x18')+_0x1b0e31('0x127')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x55')+_0x1b0e31('0x14f')+'\x20\x20FROM\x20(SELECT'+_0x1b0e31('0x119')+'\x20\x20\x20\x20\x20\x20\x20\x20r.type\x20type,'+_0x1b0e31('0x10d')+_0x1b0e31('0x79')+_0x1b0e31('0x0')+_0x1b0e31('0x156')+_0x1b0e31('0xbd')),_0x3f330e['query'](_0x1b0e31('0x55')+_0x1b0e31('0x45')+_0x1b0e31('0x1d')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0xd9')+'\x20\x20SET\x20name\x20=\x20(SELECT'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20CASE'+'\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)'+_0x1b0e31('0x8e')+'\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)'+_0x1b0e31('0x3')+_0x1b0e31('0x47')+_0x1b0e31('0xd0')+_0x1b0e31('0x5e')+'\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)'+_0x1b0e31('0xda')+_0x1b0e31('0x2f')+_0x1b0e31('0xbc')+_0x1b0e31('0xac')+_0x1b0e31('0x10a')+_0x1b0e31('0x130')+_0x1b0e31('0x63')+'\x20\x20END'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20);'),_0x3f330e[_0x1b0e31('0xfb')]('DELETE\x20FROM\x20tmpNormalizedResources'+'\x20\x20WHERE\x20name\x20=\x20\x27DELETE_MIGRATION\x27;'),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0xbf')+_0x1b0e31('0xab')+_0x1b0e31('0x23')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0xef')+'\x20\x20SET\x20u.userProfileId\x20=\x20f.profileId'+_0x1b0e31('0x151')),_0x3f330e['query']('UPDATE\x20users\x20u'+_0x1b0e31('0xd7')+_0x1b0e31('0x159')),_0x3f330e['query'](_0x1b0e31('0x80')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x5a')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0xe6')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0xe9')),_0x3f330e[_0x1b0e31('0xfb')]('DROP\x20TABLE\x20IF\x20EXISTS\x20tmpExtractedResources;'),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x90')),_0x3f330e['query'](_0x1b0e31('0x61')),_0x3f330e[_0x1b0e31('0xfb')]('DROP\x20TABLE\x20IF\x20EXISTS\x20tmpSingleProfiles;'),_0x3f330e['query']('DROP\x20TABLE\x20IF\x20EXISTS\x20tmpFinalProfiles;'),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x96')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0xe0')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x1c')),_0x3f330e[_0x1b0e31('0xfb')](_0x1b0e31('0x118')),_0x3f330e[_0x1b0e31('0x99')](_0x4e41c8);});},'down':function(){}};
\ No newline at end of file
+const a964_0x229e=['DROP\x20TABLE\x20IF\x20EXISTS\x20tmpNormalizedSections;','\x20\x20s.sectionId\x20permission,','\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\x20tmpSections','\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','\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\x20ORDER\x20BY\x20userId;','\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','\x20\x20SELECT\x20x.sectionId,\x20u.OpenchannelQueueId,\x20x.userId','\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\x20UNIQUE\x20KEY\x20`name`\x20(`name`)','\x20\x20WHERE\x20x.sectionId\x20=\x20801;','\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\x20WHEN\x20sectionId\x20=\x20710\x20THEN\x20\x27Realtime\x27','UPDATE\x20tmpFinalProfiles','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20(SELECT','INSERT\x20INTO\x20tmpCustomResources','\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\x20userId\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=\x20900\x20THEN\x20\x27DELETE\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20END','\x20\x20INNER\x20JOIN\x20voice_queues\x20q\x20ON\x20u.VoiceQueueId\x20=\x20q.id','\x20\x20ORDER\x20BY\x20GROUP_CONCAT(userId);','\x20\x20SELECT\x20\x27\x27,\x20insertedId,\x20name,\x20sectionId,\x20null','name','CREATE\x20TABLE\x20tmpGroupedPermissions','\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\x20SELECT\x20*\x20FROM\x20tmpSingleProfiles;','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20>=\x20100000\x20THEN\x20\x27Tools\x27','\x20\x20`name`\x20varchar(255)\x20NOT\x20NULL,','changeColumn','\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\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\x20KEY\x20`compositeIndex`\x20(`resourceId`,`sectionId`),','\x20\x20sectionId\x20int(11)\x20not\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)\x20a','\x20\x20WHERE\x20x.sectionId\x20=\x201501\x20AND\x20q.type\x20=\x20\x27outbound\x27;','\x20\x20\x20\x20\x20\x20WHEN\x20name\x20=\x20\x27Plugins\x27\x20THEN\x20(sectionId\x20-\x2088888)','\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=\x20408\x20THEN\x20\x27VoiceRecordings\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\x20users)\x20b','\x20\x20\x20\x20\x20\x20\x20\x20SUBSTRING_INDEX(SUBSTRING_INDEX(r.resourceId,\x20\x27,\x27,\x20tally.n),\x20\x27,\x27,\x20-1)\x20resourceId,','INSERT\x20INTO\x20tmpNormalizedResources','\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','INTEGER','\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\x20WHEN\x20sectionId\x20in\x20(1301,\x201302,\x201303,\x201305,\x201306,\x201307,\x201308)\x20THEN\x20\x27Integrations\x27','\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\x20\x20\x20\x20\x20r.insertedSectionId\x20insertedSectionId,','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(202,\x20203,\x20204)\x20THEN\x20\x27Staff\x27','\x20\x20WHERE\x20userProfileId\x20is\x20null\x20AND\x20role\x20=\x20\x27user\x27;','UPDATE\x20tmpNormalizedResources\x20x','\x20\x20SELECT\x20id,\x20permissions,\x20null','\x20\x20INNER\x20JOIN\x20user_has_openchannel_accounts\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20WHERE\x20x.sectionId\x20=\x20702;','\x20\x20KEY\x20`compositeIndex`\x20(`sectionId`,`userProfileId`),','\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\x20SUBSTRING_INDEX(fp.userId,\x20\x27,\x27,\x201)\x20userId','\x20\x20WHERE\x20x.sectionId\x20=\x20501;','\x20\x20CROSS\x20JOIN\x20(SELECT\x20@cnt\x20:=\x200)\x20as\x20dummy\x20LIMIT\x201)),\x20\x27red\x27,\x20now(),\x20now()','\x20\x20\x20\x20t.permissions\x20permissions','CREATE\x20TABLE\x20tmpNormalizedUsers','\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','../config/logger','\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','CREATE\x20TABLE\x20tmpNormalizedResources','\x20\x20\x20\x20\x20\x20profileId\x20int(11)','renameColumn','\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`createdAt`\x20datetime\x20NOT\x20NULL,','CREATE\x20TABLE\x20tmpNormalizedSections','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpSharedProfiles;','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\x20\x20\x20\x20\x20GROUP\x20BY\x20resourceId,\x20sectionId','\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\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201012\x20THEN\x20\x27Variables\x27','enqueue','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20),','\x20\x20FROM\x20tmpFinalProfiles\x20t','\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','UPDATE\x20users\x20u','sequence','\x20\x20\x20\x20autoAssociation\x20tinyint\x20not\x20null,','\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\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\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\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\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','catch','\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\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\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=\x20802\x20THEN\x20\x27OpenchannelAccounts\x27','INSERT\x20INTO\x20tmpNormalizedUsers','\x20\x20\x20\x20SUBSTRING_INDEX(SUBSTRING_INDEX(t.userIds,\x20\x27,\x27,\x20tally.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','\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','\x20\x20SET\x20autoAssociation\x20=\x201\x20WHERE\x20sectionId\x20=\x20100;','\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','inspect','\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\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','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpGroupedPermissions;','\x20\x20`userProfileId`\x20int(11)\x20DEFAULT\x20NULL,','\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=\x201100\x20THEN\x20\x27DELETE\x27','\x20\x20SELECT\x20x.sectionId,\x20u.OpenchannelAccountId,\x20x.userId','\x20\x20FROM\x20tmpCustomResources;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20CASE','CREATE\x20TABLE\x20tmpResources','migration','\x20\x20`sectionId`\x20int(11)\x20NOT\x20NULL,','\x20\x20SELECT\x20\x27\x27,\x20\x27\x27,\x20permission,\x201,\x200,\x20profileId,\x20null,\x20userId','\x20\x20WHERE\x20u.id\x20=\x20f.userId;','dropTable','\x20\x20\x20\x20insertedId\x20int(11),','INSERT\x20INTO\x20tmpExtractedResources','\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','addIndex','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20100\x20THEN\x20\x27Dashboards\x27','\x20\x20FROM\x20(SELECT','INSERT\x20INTO\x20tmpFinalProfiles','\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\x20WHERE\x20x.sectionId\x20=\x20701;','\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\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','info','\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','\x20\x20\x20\x20resourceId\x20text','\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\x20INNER\x20JOIN\x20user_has_mail_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\x20\x20WHEN\x20sectionId\x20=\x201502\x20THEN\x20\x27IvrCampaigns\x27','INSERT\x20INTO\x20tmpGroupedPermissions','\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=\x201102\x20THEN\x20\x27SquareRecordings\x27','\x20\x20SET\x20u.permissions\x20=\x20t.permissions','\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','reportType','\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\x20tmpSections;','analytics_extracted_reports','VALUES\x20(\x27Default\x27,\x20\x27red\x27,\x20NULL,\x20NOW(),\x20NOW());','\x20\x20n\x20INT\x20NOT\x20NULL\x20AUTO_INCREMENT\x20PRIMARY\x20KEY','ALTER\x20TABLE\x20`users`\x20','\x20\x20WHERE\x20x.sectionId\x20=\x20602;','\x20\x20FROM\x20tmpFinalProfiles;','UPDATE\x20tmpSections','Renamed\x20column\x20from\x20%s\x20to\x20%s\x20on\x20%s','\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\x20SELECT\x20permission,\x20userId,\x200','ADD\x20CONSTRAINT\x20`users_ibfk_1`\x20','\x20\x20INNER\x20JOIN\x20user_has_fax_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20WHERE\x20x.sectionId\x20=\x20502;','\x20\x20ORDER\x20BY\x20n)\x20AS\x20split;','userProfileId','\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\x20WHEN\x20x.sectionId\x20=\x20501\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20chat_queues\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','\x20\x20WHERE\x20x.sectionId\x20=\x20902;','\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','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(1501,\x201502,\x201510)\x20THEN\x20\x27MotionDialer\x27','prototype','\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\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\x20SELECT\x20CONCAT(\x27Profile_\x27,\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\x20WHEN\x20sectionId\x20=\x201001\x20THEN\x20\x27CannedAnswers\x27','\x20\x20SELECT\x20x.sectionId,\x20u.SmsQueueId,\x20x.userId','\x20\x20GROUP\x20BY\x20permissions','\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',',(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\x20SELECT\x20x.sectionId,\x20u.ChatWebsiteId,\x20x.userId','\x20\x20);','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpNormalizedResources;','\x20\x20\x20\x20permissions\x20text\x20not\x20null,','\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\x20INNER\x20JOIN\x20user_has_sms_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpNormalizedUsers;','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201400\x20THEN\x20\x27Settings\x27','ON\x20UPDATE\x20CASCADE','\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=\x201303\x20THEN\x20\x27FreshdeskAccounts\x27','\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);','users','INSERT\x20INTO\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\x20ORDER\x20BY\x20users)\x20b','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=\x20402\x20THEN\x20\x27InboundRoutes\x27','REFERENCES\x20user_profiles(`id`)\x20','removeColumn','util','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=\x201308\x20THEN\x20\x27VtigerAccounts\x27','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\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20610\x20THEN\x20\x27Realtime\x27','\x20\x20FROM\x20user_profiles\x20u','\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\x20SELECT\x20userId,\x20permissions,\x20null','\x20\x20SELECT\x20GROUP_CONCAT(id),\x20permissions,\x20null','\x20\x20`category`\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=\x201200\x20THEN\x20\x27DELETE\x27','\x20\x20KEY\x20`sectionId`\x20(`sectionId`),','\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\x20SET\x20profileId\x20=\x20(SELECT\x20(@cnt\x20:=\x20@cnt\x20+\x201)\x20AS\x20rowNumber','\x20\x20INNER\x20JOIN\x20user_has_openchannel_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20\x20\x20\x20\x20SUBSTRING_INDEX(SUBSTRING_INDEX(s.userId,\x20\x27,\x27,\x20t.n),\x20\x27,\x27,\x20-1)\x20userId','CREATE\x20TABLE\x20`user_profile_has_resources`\x20(','CREATE\x20TABLE\x20tmpNormalizedPermissions','\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`description`\x20varchar(255)\x20DEFAULT\x20NULL,','DROP\x20TABLE\x20IF\x20EXISTS\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(SELECT\x20GROUP_CONCAT(userId\x20ORDER\x20BY\x20userId\x20ASC)\x20as\x20users','CREATE\x20TABLE\x20`user_profile_has_sections`\x20(','\x20\x20SELECT\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','Removed\x20column\x20%s\x20from\x20%s','CREATE\x20TABLE\x20tmpPermissions','\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\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\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)','TRUNCATE\x20TABLE\x20tmpPermissions;','UPDATE\x20tmpSections\x20s','\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\x20\x20\x20SUBSTRING_INDEX(SUBSTRING_INDEX(p.permissions,\x20\x27,\x27,\x20tally.n),\x20\x27,\x27,\x20-1)\x20permission,','\x20\x20\x20\x20\x20\x20\x20\x20r.sectionId\x20sectionId','UPDATE\x20tmpCustomResources\x20r,\x20tmpSections\x20s','\x20DROP\x20TABLE\x20IF\x20EXISTS\x20tally;','\x20\x20SET\x20r.sectionId\x20=\x20s.insertedId','\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\x20category\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=\x20303\x20THEN\x20\x27Contacts\x27','\x20\x20\x20\x20\x20\x20resourceId\x20text,','\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\x20WHERE\x20name\x20=\x20\x27DELETE_MIGRATION\x27;','\x20\x20INNER\x20JOIN\x20user_has_sms_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=\x20409\x20THEN\x20\x27ChanSpies\x27','stringify','\x20\x20WHERE\x20u.id\x20=\x20t.userId;','INSERT\x20INTO\x20tmpNormalizedPermissions','\x20\x20END','\x20\x20SELECT\x20x.sectionId,\x20u.FaxQueueId,\x20x.userId','\x20\x20`crudPermissions`\x20varchar(255)\x20NOT\x20NULL\x20DEFAULT\x20\x27r\x27,','\x20\x20\x20\x20\x20\x20name\x20=\x20(SELECT','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpResources;',',(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\x20\x20\x20\x20\x20END','finally','\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\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201701\x20THEN\x20\x27jscripty\x27','then','STRING','\x20\x20resourceId\x20int(11),','\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=\x20501\x20THEN\x20\x27ChatQueues\x27','queryInterface','INSERT\x20INTO\x20tmpNormalizedSections','UPDATE\x20users\x20u,\x20tmpNormalizedPermissions\x20t','\x20\x20WHERE\x20role\x20=\x20\x27user\x27\x20and\x20permissions\x20is\x20not\x20null\x20and\x20permissions\x20<>\x20\x27\x27','\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','\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\x20insertedSectionId\x20int(11)\x20not\x20null,','CREATE\x20TABLE\x20tmpCustomResources','INSERT\x20INTO\x20tmpPermissions','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20END','sequelize',',(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','\x20\x20SELECT\x20x.sectionId,\x20u.ChatQueueId,\x20x.userId','\x20\x20\x20\x20\x20\x20type\x20varchar(255)\x20not\x20null,','\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=\x20702\x20THEN\x20\x27SmsAccounts\x27','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(801,\x20802,\x20810)\x20THEN\x20\x27Openchannel\x27','\x20\x20WHERE\x20name\x20=\x20\x27DELETE\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','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=\x201003\x20THEN\x20\x27CustomDashboards\x27','\x20\x20FROM\x20tmpNormalizedSections','\x20\x20SELECT\x20x.sectionId,\x20u.MailAccountId,\x20x.userId','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(701,\x20702,\x20710)\x20THEN\x20\x27Sms\x27','\x20\x20(','join','removeIndex','\x20\x20\x20\x20\x20\x20userId\x20text\x20not\x20null,','\x20\x20\x20\x20\x20\x20permissions\x20text\x20not\x20null,','\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20tally',',(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=\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=\x20101\x20THEN\x20\x27DELETE\x27','INSERT\x20INTO\x20tmpSharedProfiles','\x20\x20\x20\x20\x20\x20\x20\x20fp.profileId\x20profileId,','\x20\x20\x20\x20name\x20varchar(255)\x20not\x20null,','\x20\x20SET\x20u.userProfileId\x20=\x20f.profileId','query\x20%s','\x20\x20`type`\x20varchar(255)\x20NOT\x20NULL,','DELETE\x20t1\x20FROM\x20tmpSections\x20t1,\x20tmpCustomResources\x20t2','\x20\x20SELECT\x20cr.resourceId,\x20name,\x20s.insertedId,\x20s.sectionId','\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','INSERT\x20INTO\x20user_profile_has_resources\x20(name,\x20resourceId,\x20type,\x20createdAt,\x20updatedAt,\x20sectionId)','\x20\x20FROM\x20tmpSections','final','INSERT\x20INTO\x20tmpResources','DELETE\x20FROM\x20tmpSections','\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\x20userIds\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=\x20201\x20THEN\x20\x27DELETE\x27','\x20\x20SET\x20insertedId\x20=\x20(SELECT\x20id','\x20\x20FROM\x20tmpSections;','\x20\x20PRIMARY\x20KEY\x20(`id`),','\x20\x20INNER\x20JOIN\x20user_has_mail_accounts\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20CROSS\x20JOIN\x20(SELECT\x20@cnt\x20:=\x201)\x20as\x20dummy\x20LIMIT\x201)','\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','query','\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\x20r.type\x20type,','\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=\x201000\x20THEN\x20\x27DELETE\x27','\x20\x20SELECT\x20x.sectionId,\x20u.MailQueueId,\x20x.userId','\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\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(1101,\x201102,\x201103)\x20THEN\x20\x27CallySquare\x27','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpFinalProfiles;','\x20\x20SELECT\x20GROUP_CONCAT(sectionId\x20ORDER\x20BY\x20sectionId),\x20userId','tail','\x20\x20\x20\x20userProfileId\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=\x201600\x20THEN\x20\x27Help\x27','\x20\x20WHERE\x20userId\x20NOT\x20IN\x20(SELECT\x20split.userId','\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\x20=\x201500\x20THEN\x20\x27DELETE\x27','\x20\x20GROUP\x20BY\x20userId;','\x20\x20WHERE\x20split.userId\x20IN\x20(SELECT\x20*\x20FROM','CREATE\x20TABLE\x20tmpFinalProfiles','\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','UPDATE\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\x20SET\x20sectionId\x20=\x201003\x20WHERE\x20sectionId\x20>=\x20100000;','\x20\x20FROM\x20tmpSections\x20s','\x20\x20ORDER\x20BY\x20GROUP_CONCAT(id);','\x20\x20category\x20=\x20(SELECT','\x20\x20INNER\x20JOIN\x20user_has_chat_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','CREATE\x20TABLE\x20`user_profiles`\x20(','\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\x20SET\x20name\x20=\x20(SELECT','\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=\x201103\x20THEN\x20\x27SquareProjects\x27','\x20\x20FROM\x20tmpGroupedPermissions','\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\x20INNER\x20JOIN\x20tmpExtractedResources\x20cr\x20ON\x20cr.userId\x20=\x20s.userId\x20AND\x20cr.sectionId\x20=\x20s.sectionId\x20AND\x20cr.resourceId\x20IS\x20NOT\x20NULL;','addColumn','\x20\x20FROM\x20users','\x20\x20SET\x20sectionId\x20=\x201801\x20WHERE\x20sectionId\x20between\x2088889\x20AND\x2099999;','\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\x20WHEN\x20sectionId\x20=\x201510\x20THEN\x20\x27Realtime\x27','\x20\x20\x20\x20\x20\x20CASE','\x20\x20SELECT\x20*\x20FROM\x20tmpSharedProfiles'];(function(_0xdfd268,_0x229e36){const _0x2a21e0=function(_0x40fee0){while(--_0x40fee0){_0xdfd268['push'](_0xdfd268['shift']());}};_0x2a21e0(++_0x229e36);}(a964_0x229e,0x120));const a964_0x2a21=function(_0xdfd268,_0x229e36){_0xdfd268=_0xdfd268-0x0;let _0x2a21e0=a964_0x229e[_0xdfd268];return _0x2a21e0;};const _0x502eb3=a964_0x2a21;'use strict';const util=require(_0x502eb3('0xfe')),logger=require(_0x502eb3('0x80'))(_0x502eb3('0xaf')),Sequence=function(){};Sequence[_0x502eb3('0xe2')]['enqueue']=function(_0x40fee0){const _0x5a6337=_0x502eb3;this[_0x5a6337('0x21')]=this[_0x5a6337('0x21')]?this[_0x5a6337('0x21')][_0x5a6337('0x136')](_0x40fee0):_0x40fee0();};const Migration=function(_0x49ea86){const _0x253fe8=_0x502eb3;this[_0x253fe8('0x13e')]=_0x49ea86,this[_0x253fe8('0x92')]=new Sequence();};Migration[_0x502eb3('0xe2')]['changeColumn']=function(_0x5f271a,_0x461819,_0x2fa5ed){const _0x2a9164=_0x502eb3,_0x516dd1=this;this[_0x2a9164('0x92')][_0x2a9164('0x8d')](function(){const _0x19035d=_0x2a9164;return _0x516dd1[_0x19035d('0x13e')][_0x19035d('0x5f')](_0x5f271a,_0x461819,_0x2fa5ed)[_0x19035d('0x139')](function(){const _0x35c745=_0x19035d;logger[_0x35c745('0xbf')](_0x35c745('0xfa'),_0x461819,_0x5f271a);})[_0x19035d('0x99')](function(_0x347056){const _0x15aeb2=_0x19035d;logger['info'](JSON[_0x15aeb2('0x12c')](_0x347056));});});},Migration[_0x502eb3('0xe2')][_0x502eb3('0x3a')]=function(_0x32728a,_0x4f82ae,_0x4c30ff){const _0x1f5d27=_0x502eb3,_0x4fb9ce=this;this['sequence'][_0x1f5d27('0x8d')](function(){const _0x577496=_0x1f5d27;return _0x4fb9ce[_0x577496('0x13e')][_0x577496('0x3a')](_0x32728a,_0x4f82ae,_0x4c30ff)[_0x577496('0x139')](function(){const _0x588258=_0x577496;logger[_0x588258('0xbf')]('Added\x20column\x20%s\x20to\x20%s',_0x4f82ae,_0x32728a);})[_0x577496('0x99')](function(_0x385b9f){const _0x1f8107=_0x577496;logger[_0x1f8107('0xbf')](JSON[_0x1f8107('0x12c')](_0x385b9f));});});},Migration[_0x502eb3('0xe2')][_0x502eb3('0xb3')]=function(_0x4e46ec){const _0x9ef76f=_0x502eb3,_0x86946a=this;this[_0x9ef76f('0x92')]['enqueue'](function(){const _0x14fe26=_0x9ef76f;return _0x86946a[_0x14fe26('0x13e')][_0x14fe26('0xb3')](_0x4e46ec,{'force':!![]})['then'](function(){logger['info']('table\x20dropped\x20%s',_0x4e46ec);})[_0x14fe26('0x99')](function(_0x42821d){const _0x204d70=_0x14fe26;logger[_0x204d70('0xbf')](JSON['stringify'](_0x42821d));});});},Migration[_0x502eb3('0xe2')][_0x502eb3('0xb7')]=function(_0x1a0239,_0x156a4b,_0xc15a5a){const _0x4a26c5=_0x502eb3,_0x59549a=this;this['sequence'][_0x4a26c5('0x8d')](function(){const _0x281569=_0x4a26c5;return _0x59549a[_0x281569('0x13e')]['addIndex'](_0x1a0239,_0x156a4b,{'indexName':_0xc15a5a})[_0x281569('0x139')](function(){const _0x1ef2c7=_0x281569;logger[_0x1ef2c7('0xbf')]('addIndex\x20%s\x20%s\x20%s',_0x1a0239,_0x156a4b[_0x1ef2c7('0x158')](','),_0xc15a5a);})[_0x281569('0x99')](function(_0x408878){const _0x588afc=_0x281569;logger[_0x588afc('0xbf')](JSON[_0x588afc('0x12c')](_0x408878));});});},Migration[_0x502eb3('0xe2')][_0x502eb3('0x159')]=function(_0x446316,_0x4019aa){const _0x2a248c=_0x502eb3,_0x288fe0=this;this[_0x2a248c('0x92')][_0x2a248c('0x8d')](function(){const _0x2d0b27=_0x2a248c;return _0x288fe0[_0x2d0b27('0x13e')][_0x2d0b27('0x159')](_0x446316,_0x4019aa)[_0x2d0b27('0x139')](function(){logger['info']('removeIndex\x20%s\x20%s',_0x446316,_0x4019aa);})['catch'](function(_0x2f53a8){const _0x3f3dbb=_0x2d0b27;logger[_0x3f3dbb('0xbf')](JSON[_0x3f3dbb('0x12c')](_0x2f53a8));});});},Migration[_0x502eb3('0xe2')]['query']=function(_0x486bbd){const _0x475a21=_0x502eb3,_0x98d8ba=this;this[_0x475a21('0x92')][_0x475a21('0x8d')](function(){const _0x858505=_0x475a21;return _0x98d8ba[_0x858505('0x13e')][_0x858505('0x148')][_0x858505('0x16')](_0x486bbd)[_0x858505('0x139')](function(){const _0x590239=_0x858505;logger[_0x590239('0xbf')](_0x590239('0x3'),_0x486bbd);})['catch'](function(_0x1b2901){const _0xcd669a=_0x858505;logger[_0xcd669a('0xbf')](JSON[_0xcd669a('0x12c')](_0x1b2901));});});},Migration[_0x502eb3('0xe2')]['removeColumn']=function(_0x20c66e,_0x392fa4){const _0x3cf759=_0x502eb3,_0x387f57=this;this[_0x3cf759('0x92')][_0x3cf759('0x8d')](function(){const _0x567c2a=_0x3cf759;return _0x387f57['queryInterface'][_0x567c2a('0xfd')](_0x20c66e,_0x392fa4)[_0x567c2a('0x139')](function(){const _0x3d6454=_0x567c2a;logger[_0x3d6454('0xbf')](_0x3d6454('0x117'),_0x392fa4,_0x20c66e);})[_0x567c2a('0x99')](function(_0x242853){const _0x4f5179=_0x567c2a;logger[_0x4f5179('0xbf')](util[_0x4f5179('0xa4')](_0x242853,{'showHidden':![],'depth':null}));});});},Migration[_0x502eb3('0xe2')][_0x502eb3('0x84')]=function(_0x3ad18d,_0xbecb5a,_0x30fdc8){const _0x512e3d=_0x502eb3,_0x25e955=this;this['sequence'][_0x512e3d('0x8d')](function(){const _0x598d16=_0x512e3d;return _0x25e955['queryInterface'][_0x598d16('0x84')](_0x3ad18d,_0xbecb5a,_0x30fdc8)[_0x598d16('0x139')](function(){const _0x2527f9=_0x598d16;logger[_0x2527f9('0xbf')](_0x2527f9('0xd5'),_0xbecb5a,_0x30fdc8,_0x3ad18d);})[_0x598d16('0x99')](function(_0x23b683){const _0x4e062a=_0x598d16;logger['info'](util[_0x4e062a('0xa4')](_0x23b683,{'showHidden':![],'depth':null}));});});},Migration[_0x502eb3('0xe2')][_0x502eb3('0xa')]=function(_0x396970){const _0x2cf8ce=_0x502eb3;this['sequence'][_0x2cf8ce('0x8d')](function(){return _0x396970();});},module['exports']={'up':function(_0x285051,_0x182b0d){return new Promise(function(_0x34b20a){const _0x4ab040=a964_0x2a21,_0x14191e=new Migration(_0x285051);_0x14191e[_0x4ab040('0x3a')](_0x4ab040('0xce'),'reportId',{'type':_0x182b0d[_0x4ab040('0x6d')]}),_0x14191e[_0x4ab040('0x3a')](_0x4ab040('0xce'),_0x4ab040('0xcb'),{'type':_0x182b0d[_0x4ab040('0x13a')]}),_0x14191e[_0x4ab040('0x3a')](_0x4ab040('0xf7'),_0x4ab040('0xdc'),{'type':_0x182b0d[_0x4ab040('0x6d')]}),_0x14191e[_0x4ab040('0xfd')]('voice_voicemail',_0x4ab040('0x59')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x32')+_0x4ab040('0x14c')+'\x20\x20`name`\x20varchar(255)\x20NOT\x20NULL,'+_0x4ab040('0x131')+_0x4ab040('0x111')+_0x4ab040('0x86')+'\x20\x20`updatedAt`\x20datetime\x20NOT\x20NULL,'+_0x4ab040('0x12')+_0x4ab040('0x4b')+_0x4ab040('0x14d')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x101')+_0x4ab040('0xcf')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0xd1')+_0x4ab040('0xd8')+_0x4ab040('0x89')+_0x4ab040('0xfc')+_0x4ab040('0xf3')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x114')+_0x4ab040('0x14c')+_0x4ab040('0x5e')+_0x4ab040('0x107')+_0x4ab040('0xb0')+'\x20\x20`enabled`\x20tinyint(1)\x20DEFAULT\x20NULL,'+_0x4ab040('0x3d')+'\x20\x20`crudPermissions`\x20varchar(255)\x20DEFAULT\x20NULL,'+_0x4ab040('0x86')+'\x20\x20`updatedAt`\x20datetime\x20NOT\x20NULL,'+_0x4ab040('0xa8')+_0x4ab040('0x12')+'\x20\x20KEY\x20`userProfileId`\x20(`userProfileId`),'+_0x4ab040('0x78')+'\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'+_0x4ab040('0x14d')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x10e')+_0x4ab040('0x14c')+_0x4ab040('0x5e')+'\x20\x20`resourceId`\x20int(11)\x20NOT\x20NULL,'+_0x4ab040('0x4')+_0x4ab040('0x86')+'\x20\x20`updatedAt`\x20datetime\x20NOT\x20NULL,'+'\x20\x20`sectionId`\x20int(11)\x20DEFAULT\x20NULL,'+_0x4ab040('0x12')+_0x4ab040('0x109')+_0x4ab040('0x62')+_0x4ab040('0x8b')+')\x20ENGINE=InnoDB\x20DEFAULT\x20CHARSET=utf8;'),_0x14191e[_0x4ab040('0x16')]('CREATE\x20TABLE\x20tally\x20('+_0x4ab040('0xd0')+');'),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x152')+'SELECT\x20NULL\x20FROM'+_0x4ab040('0x64')+_0x4ab040('0x15d')+_0x4ab040('0x149')+_0x4ab040('0xea')+_0x4ab040('0x134')+';'),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x118')+_0x4ab040('0x157')+_0x4ab040('0xe')+_0x4ab040('0x15b')+_0x4ab040('0x83')+_0x4ab040('0xec')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x146')+_0x4ab040('0x75')+_0x4ab040('0x3b')+_0x4ab040('0x141')+'\x20\x20ORDER\x20BY\x20id;'),_0x14191e['query'](_0x4ab040('0x87')+_0x4ab040('0x157')+_0x4ab040('0x35')+'\x20\x20\x20\x20userId\x20text,'+_0x4ab040('0xc1')+_0x4ab040('0xec')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x13f')+'\x20\x20SELECT\x20DISTINCT\x20permission,\x20userId,\x200'+_0x4ab040('0xb9')+_0x4ab040('0x11f')+'\x20\x20\x20\x20p.userIds\x20userId'+'\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;'),_0x14191e['query'](_0x4ab040('0x10f')+_0x4ab040('0x157')+_0x4ab040('0xee')+_0x4ab040('0x53')+'\x20\x20);'),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x12e')+_0x4ab040('0x20')+_0x4ab040('0x154')+_0x4ab040('0x27')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x140')+_0x4ab040('0xc9')+_0x4ab040('0x12d')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x11c')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x146')+_0x4ab040('0x106')+_0x4ab040('0x3b')+_0x4ab040('0x141')+_0x4ab040('0xe8')+_0x4ab040('0x2f')),_0x14191e['query'](_0x4ab040('0x7e')+'\x20\x20('+_0x4ab040('0x35')+'\x20\x20\x20\x20userId\x20text,'+_0x4ab040('0xc1')+_0x4ab040('0xec')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x9e')+_0x4ab040('0xd7')+'\x20\x20FROM\x20(SELECT'+_0x4ab040('0x42')+_0x4ab040('0x10d')+_0x4ab040('0xbd')+_0x4ab040('0xdb')),_0x14191e[_0x4ab040('0x16')]('CREATE\x20TABLE\x20tmpExtractedResources\x20('+_0x4ab040('0x63')+_0x4ab040('0x13b')+'\x20\x20userId\x20int(11)'+'\x20\x20);'),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0xb5')+'\x20\x20SELECT\x20x.sectionId,\x20u.VoiceQueueId,\x20x.userId'+_0x4ab040('0x9b')+'\x20\x20INNER\x20JOIN\x20user_has_voice_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId'+_0x4ab040('0x56')+_0x4ab040('0xc7')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0xb5')+_0x4ab040('0x14a')+_0x4ab040('0x9b')+_0x4ab040('0x31')+_0x4ab040('0x7b')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0xb5')+_0x4ab040('0xeb')+_0x4ab040('0x9b')+'\x20\x20INNER\x20JOIN\x20user_has_chat_websites\x20u\x20ON\x20u.UserId\x20=\x20x.userId'+_0x4ab040('0xda')),_0x14191e[_0x4ab040('0x16')]('INSERT\x20INTO\x20tmpExtractedResources'+_0x4ab040('0x1b')+'\x20\x20FROM\x20tmpNormalizedUsers\x20x'+_0x4ab040('0xc3')+'\x20\x20WHERE\x20x.sectionId\x20=\x20601;'),_0x14191e['query'](_0x4ab040('0xb5')+_0x4ab040('0x155')+'\x20\x20FROM\x20tmpNormalizedUsers\x20x'+_0x4ab040('0x13')+_0x4ab040('0xd2')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0xb5')+_0x4ab040('0xe7')+_0x4ab040('0x9b')+_0x4ab040('0xf0')+_0x4ab040('0xbc')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0xb5')+'\x20\x20SELECT\x20x.sectionId,\x20u.SmsAccountId,\x20x.userId'+_0x4ab040('0x9b')+_0x4ab040('0x12a')+_0x4ab040('0x77')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0xb5')+_0x4ab040('0x49')+_0x4ab040('0x9b')+_0x4ab040('0x10c')+_0x4ab040('0x4c')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0xb5')+_0x4ab040('0xab')+_0x4ab040('0x9b')+_0x4ab040('0x76')+'\x20\x20WHERE\x20x.sectionId\x20=\x20802;'),_0x14191e['query'](_0x4ab040('0xb5')+_0x4ab040('0x130')+_0x4ab040('0x9b')+_0x4ab040('0xd9')+'\x20\x20WHERE\x20x.sectionId\x20=\x20901;'),_0x14191e['query'](_0x4ab040('0xb5')+'\x20\x20SELECT\x20x.sectionId,\x20u.FaxAccountId,\x20x.userId'+'\x20\x20FROM\x20tmpNormalizedUsers\x20x'+'\x20\x20INNER\x20JOIN\x20user_has_fax_accounts\x20u\x20ON\x20u.UserId\x20=\x20x.userId'+_0x4ab040('0xdf')),_0x14191e[_0x4ab040('0x16')]('INSERT\x20INTO\x20tmpExtractedResources'+'\x20\x20SELECT\x20x.sectionId,\x20u.SquareProjectId,\x20x.userId'+_0x4ab040('0x9b')+'\x20\x20INNER\x20JOIN\x20user_has_square_projects\x20u\x20ON\x20u.UserId\x20=\x20x.userId'+'\x20\x20WHERE\x20x.sectionId\x20=\x201103;'),_0x14191e[_0x4ab040('0x16')]('INSERT\x20INTO\x20tmpExtractedResources'+'\x20\x20SELECT\x20x.sectionId,\x20u.VoiceQueueId,\x20x.userId'+_0x4ab040('0x9b')+'\x20\x20INNER\x20JOIN\x20user_has_voice_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId'+_0x4ab040('0x56')+_0x4ab040('0x65')),_0x14191e['query'](_0x4ab040('0x5a')+'\x20\x20('+_0x4ab040('0x15a')+'\x20\x20\x20\x20\x20\x20permissions\x20text\x20not\x20null'+_0x4ab040('0xec')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0xc6')+_0x4ab040('0x19')+_0x4ab040('0xb9')+_0x4ab040('0x9f')+_0x4ab040('0x7d')+_0x4ab040('0x97')+_0x4ab040('0xdb')),_0x14191e[_0x4ab040('0x16')]('CREATE\x20TABLE\x20tmpSharedProfiles'+_0x4ab040('0x157')+_0x4ab040('0xe')+_0x4ab040('0x15b')+_0x4ab040('0x83')+_0x4ab040('0xec')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x160')+'\x20\x20SELECT\x20GROUP_CONCAT(userId),\x20permissions,\x20null'+'\x20\x20FROM\x20tmpGroupedPermissions'+_0x4ab040('0x24')+_0x4ab040('0x50')+_0x4ab040('0x110')+_0x4ab040('0x98')+_0x4ab040('0xa6')+_0x4ab040('0x9c')+_0x4ab040('0xca')+_0x4ab040('0x28')+'\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'+_0x4ab040('0x116')+_0x4ab040('0x8a')+_0x4ab040('0xf9')+_0x4ab040('0x61')+_0x4ab040('0xe8')+_0x4ab040('0x57')),_0x14191e[_0x4ab040('0x16')]('CREATE\x20TABLE\x20tmpSingleProfiles'+_0x4ab040('0x157')+_0x4ab040('0x15a')+'\x20\x20\x20\x20\x20\x20permissions\x20text\x20not\x20null,'+'\x20\x20\x20\x20\x20\x20profileId\x20int(11)'+'\x20\x20);'),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0xf8')+_0x4ab040('0x105')+_0x4ab040('0x37')+'\x20\x20WHERE\x20userId\x20IN\x20(SELECT\x20split.userId'+_0x4ab040('0x104')+_0x4ab040('0xc0')+'\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'+_0x4ab040('0x43')+_0x4ab040('0x28')+_0x4ab040('0x113')+_0x4ab040('0xdd')+_0x4ab040('0x10a')+_0x4ab040('0x69')+_0x4ab040('0x52')+_0x4ab040('0x47')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x29')+'\x20\x20('+_0x4ab040('0x15a')+_0x4ab040('0x15b')+_0x4ab040('0x83')+_0x4ab040('0xec')),_0x14191e['query'](_0x4ab040('0xba')+_0x4ab040('0x40')+'\x20\x20UNION'+_0x4ab040('0x5c')),_0x14191e[_0x4ab040('0x16')]('INSERT\x20INTO\x20user_profiles\x20(name,\x20crudPermissions,\x20createdAt,\x20updatedAt)'+_0x4ab040('0xe5')+_0x4ab040('0x8f')+_0x4ab040('0x7c')+_0x4ab040('0xd3')),_0x14191e['query'](_0x4ab040('0x4f')+_0x4ab040('0x10b')+_0x4ab040('0x103')+_0x4ab040('0x14')),_0x14191e[_0x4ab040('0x16')]('CREATE\x20TABLE\x20tmpSections'+_0x4ab040('0x157')+_0x4ab040('0x1')+_0x4ab040('0x125')+_0x4ab040('0x35')+'\x20\x20\x20\x20enabled\x20tinyint\x20not\x20null,'+_0x4ab040('0x93')+_0x4ab040('0x22')+_0x4ab040('0xb4')+_0x4ab040('0x25')+_0x4ab040('0xec')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x44')+_0x4ab040('0xb1')+_0x4ab040('0xb9')+_0x4ab040('0x0')+_0x4ab040('0xd6')+_0x4ab040('0x7a')+_0x4ab040('0x15c')+_0x4ab040('0x137')+_0x4ab040('0x67')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0xd4')+'\x20\x20SET'+_0x4ab040('0x132')+_0x4ab040('0xad')+_0x4ab040('0x11a')+_0x4ab040('0x15f')+_0x4ab040('0x7f')+_0x4ab040('0xf')+_0x4ab040('0xa9')+_0x4ab040('0x94')+_0x4ab040('0x15')+_0x4ab040('0x143')+_0x4ab040('0x81')+_0x4ab040('0x17')+_0x4ab040('0x126')+'\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'+'\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'+_0x4ab040('0x15e')+_0x4ab040('0xfb')+_0x4ab040('0x48')+_0x4ab040('0x11e')+_0x4ab040('0x4d')+_0x4ab040('0x33')+_0x4ab040('0x96')+_0x4ab040('0x68')+_0x4ab040('0x12b')+_0x4ab040('0x142')+_0x4ab040('0xe4')+'\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'+_0x4ab040('0x13d')+_0x4ab040('0xa1')+'\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'+_0x4ab040('0xe3')+_0x4ab040('0xef')+'\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'+'\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'+_0x4ab040('0x102')+_0x4ab040('0xcc')+'\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'+_0x4ab040('0x14e')+_0x4ab040('0x4e')+'\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'+_0x4ab040('0x119')+_0x4ab040('0x9d')+_0x4ab040('0xb6')+_0x4ab040('0x54')+_0x4ab040('0x90')+_0x4ab040('0xd')+_0x4ab040('0x6e')+_0x4ab040('0x1a')+_0x4ab040('0xe6')+_0x4ab040('0xbb')+_0x4ab040('0x153')+_0x4ab040('0x45')+_0x4ab040('0x151')+_0x4ab040('0x85')+_0x4ab040('0xa0')+_0x4ab040('0x2a')+'\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\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201010\x20THEN\x20\x27Triggers\x27'+_0x4ab040('0x7')+_0x4ab040('0x8c')+_0x4ab040('0xaa')+_0x4ab040('0x5b')+_0x4ab040('0xc8')+_0x4ab040('0x36')+_0x4ab040('0x108')+_0x4ab040('0x2c')+_0x4ab040('0x128')+'\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'+_0x4ab040('0xe0')+_0x4ab040('0x6c')+'\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'+_0x4ab040('0xf5')+_0x4ab040('0x9a')+'\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'+_0x4ab040('0x1d')+_0x4ab040('0x100')+_0x4ab040('0xe9')+_0x4ab040('0x13c')+_0x4ab040('0x26')+_0x4ab040('0x124')+_0x4ab040('0xc5')+_0x4ab040('0x3e')+_0x4ab040('0x23')+'\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'+_0x4ab040('0x60')+_0x4ab040('0x46')+_0x4ab040('0x79')+'\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\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ELSE\x20\x27\x27'+_0x4ab040('0x147')+_0x4ab040('0x8e')+_0x4ab040('0x30')+_0x4ab040('0x3f')+_0x4ab040('0xb8')+_0x4ab040('0x5d')+_0x4ab040('0x72')+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(301,\x20302,\x20303,\x20304)\x20THEN\x20\x27ContactManager\x27'+_0x4ab040('0xa3')+'\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'+_0x4ab040('0x156')+_0x4ab040('0x14f')+'\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'+_0x4ab040('0x1e')+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(1201,\x201202,\x201203)\x20THEN\x20\x27Analytics\x27'+_0x4ab040('0x6f')+_0x4ab040('0xf2')+_0x4ab040('0xe1')+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201600\x20THEN\x20\x27Help\x27'+_0x4ab040('0x138')+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20between\x2088889\x20AND\x2099999\x20THEN\x20\x27AppZone\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20ELSE\x20\x27\x27'+_0x4ab040('0x135')+'\x20\x20);'),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0xc')+_0x4ab040('0x150')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x145')+'\x20\x20('+'\x20\x20\x20\x20name\x20varchar(255)\x20not\x20null,'+_0x4ab040('0x125')+_0x4ab040('0x35')+'\x20\x20\x20\x20enabled\x20tinyint\x20not\x20null,'+_0x4ab040('0x93')+_0x4ab040('0x22')+_0x4ab040('0xb4')+_0x4ab040('0x25')+_0x4ab040('0xec')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x51')+_0x4ab040('0x115')+_0x4ab040('0x9')+'\x20\x20WHERE\x20name\x20in\x20(\x27Plugins\x27,\x20\x27CustomDashboards\x27);'),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x5')+'\x20\x20WHERE\x20t1.name\x20=\x20t2.name\x20AND\x20t1.userProfileId\x20=\x20t2.userProfileId\x20AND\x20t1.sectionId\x20>\x20t2.sectionId;'),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0xd4')+_0x4ab040('0x3c')),_0x14191e['query'](_0x4ab040('0xd4')+_0x4ab040('0x2d')),_0x14191e[_0x4ab040('0x16')]('UPDATE\x20tmpSections'+_0x4ab040('0xa2')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x2b')+'\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'+_0x4ab040('0x66')+_0x4ab040('0xc2')+_0x4ab040('0x55')+_0x4ab040('0xc4')),_0x14191e[_0x4ab040('0x16')]('INSERT\x20INTO\x20user_profile_has_sections\x20(name,\x20category,\x20sectionId,\x20enabled,\x20autoAssociation,\x20crudPermissions,\x20createdAt,\x20updatedAt,\x20userProfileId)'+_0x4ab040('0xf4')+_0x4ab040('0x11')),_0x14191e['query'](_0x4ab040('0x11d')+_0x4ab040('0x10')+_0x4ab040('0x95')+_0x4ab040('0xf6')),_0x14191e['query'](_0x4ab040('0x121')+_0x4ab040('0x123')+'\x20\x20WHERE\x20r.name\x20=\x20s.name\x20AND\x20r.userProfileId\x20=\x20s.userProfileId;'),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0xae')+_0x4ab040('0x157')+_0x4ab040('0x127')+_0x4ab040('0x14b')+_0x4ab040('0x144')+'\x20\x20\x20\x20\x20\x20sectionId\x20int(11)'+_0x4ab040('0xec')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0xb')+_0x4ab040('0x6')+_0x4ab040('0x2e')+_0x4ab040('0x39')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x82')+_0x4ab040('0x157')+_0x4ab040('0x1')+'\x20\x20\x20\x20resourceId\x20int(11)\x20not\x20null,'+'\x20\x20\x20\x20type\x20varchar(255)\x20not\x20null,'+'\x20\x20\x20\x20insertedSectionId\x20int(11)\x20not\x20null,'+'\x20\x20\x20\x20sectionId\x20int(11)'+_0x4ab040('0xec')),_0x14191e['query'](_0x4ab040('0x6b')+_0x4ab040('0xa5')+_0x4ab040('0xb9')+_0x4ab040('0x6a')+_0x4ab040('0x18')+_0x4ab040('0x71')+_0x4ab040('0x120')+_0x4ab040('0x15c')+_0x4ab040('0xbe')+'\x20\x20\x20\x20\x20\x20\x20\x20ORDER\x20BY\x20n)\x20AS\x20split;'),_0x14191e['query']('INSERT\x20INTO\x20tmpNormalizedResources'+_0x4ab040('0x58')+_0x4ab040('0xac')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x74')+_0x4ab040('0x34')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20CASE'+'\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)'+_0x4ab040('0xde')+'\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\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\x20WHEN\x20x.sectionId\x20=\x20602\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20mail_accounts\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)'+_0x4ab040('0x4a')+_0x4ab040('0x1c')+'\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)'+_0x4ab040('0x38')+'\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)'+_0x4ab040('0x70')+'\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)'+_0x4ab040('0x11b')+'\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\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)'+_0x4ab040('0x12f')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20);'),_0x14191e[_0x4ab040('0x16')]('DELETE\x20FROM\x20tmpNormalizedResources'+_0x4ab040('0x129')),_0x14191e['query'](_0x4ab040('0x8')+'\x20\x20SELECT\x20name,\x20resourceId,\x20type,\x20now(),\x20now(),\x20insertedSectionId'+'\x20\x20FROM\x20tmpNormalizedResources;'),_0x14191e[_0x4ab040('0x16')]('UPDATE\x20users\x20u,\x20tmpFinalProfiles\x20f'+_0x4ab040('0x2')+_0x4ab040('0xb2')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x91')+'\x20\x20SET\x20u.userProfileId\x20=\x201'+_0x4ab040('0x73')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x122')),_0x14191e[_0x4ab040('0x16')]('DROP\x20TABLE\x20IF\x20EXISTS\x20tmpPermissions;'),_0x14191e['query'](_0x4ab040('0x41')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0xf1')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0xff')),_0x14191e['query'](_0x4ab040('0xa7')),_0x14191e['query'](_0x4ab040('0x88')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x112')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x1f')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0xcd')),_0x14191e[_0x4ab040('0x16')]('DROP\x20TABLE\x20IF\x20EXISTS\x20tmpCustomResources;'),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0x133')),_0x14191e[_0x4ab040('0x16')](_0x4ab040('0xed')),_0x14191e[_0x4ab040('0xa')](_0x34b20a);});},'down':function(){}};
\ No newline at end of file