-const a964_0x2f96=['\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','sequence','\x20\x20SELECT\x20*\x20FROM\x20tmpSharedProfiles','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201004\x20THEN\x20\x27Intervals\x27','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpGroupedPermissions;','\x20\x20WHERE\x20userProfileId\x20is\x20null\x20AND\x20role\x20=\x20\x27user\x27;','\x20\x20`updatedAt`\x20datetime\x20NOT\x20NULL,','UPDATE\x20tmpCustomResources\x20r,\x20tmpSections\x20s','\x20\x20KEY\x20`compositeIndex`\x20(`sectionId`,`userProfileId`),','\x20\x20`type`\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\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201203\x20THEN\x20\x27Reports\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201100\x20THEN\x20\x27DELETE\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20tmpNormalizedUsers','\x20\x20\x20\x20\x20\x20sectionId\x20int(11)','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHERE\x20position(\x27,\x27\x20in\x20b.users)\x20=\x200))','\x20\x20INNER\x20JOIN\x20voice_queues\x20q\x20ON\x20u.VoiceQueueId\x20=\x20q.id','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20802\x20THEN\x20\x27OpenchannelAccounts\x27','final','\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','ADD\x20CONSTRAINT\x20`users_ibfk_1`\x20','\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\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20402\x20THEN\x20\x27InboundRoutes\x27','FOREIGN\x20KEY\x20(`userProfileId`)\x20','\x20\x20category\x20=\x20(SELECT','\x20\x20\x20\x20\x20\x20WHEN\x20name\x20=\x20\x27Plugins\x27\x20THEN\x20(sectionId\x20-\x2088888)','DELETE\x20FROM\x20tmpSections','\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=\x20500\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=\x20601\x20THEN\x20\x27MailQueues\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\x20WHEN\x20sectionId\x20=\x20410\x20THEN\x20\x27VoicePrefixes\x27','\x20\x20WHERE\x20name\x20=\x20\x27DELETE_MIGRATION\x27;','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20401\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20voice_queues\x20WHERE\x20id\x20=\x20x.resourceId\x20AND\x20type\x20=\x20\x27inbound\x27),\x27DELETE_MIGRATION\x27)','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20810\x20THEN\x20\x27Realtime\x27','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20701\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20sms_queues\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20GROUP\x20BY\x20resourceId,\x20sectionId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20800\x20THEN\x20\x27DELETE\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ORDER\x20BY\x20users)\x20b','\x20\x20SELECT\x20\x27\x27,\x20resourceId,\x20type,\x20insertedSectionId,\x20sectionId','INSERT\x20INTO\x20tally\x20(n)','\x20\x20SET','INSERT\x20INTO\x20user_profile_has_sections\x20(name,\x20category,\x20sectionId,\x20enabled,\x20autoAssociation,\x20crudPermissions,\x20createdAt,\x20updatedAt,\x20userProfileId)','addColumn','\x20\x20WHERE\x20name\x20in\x20(\x27Plugins\x27,\x20\x27CustomDashboards\x27);','\x20\x20UNION','\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\x20insertedSectionId\x20int(11)\x20not\x20null,','\x20\x20SELECT\x20permission,\x20userId,\x200','\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\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\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ORDER\x20BY\x20users)\x20b','changeColumn','\x20\x20\x20\x20SUBSTRING_INDEX(SUBSTRING_INDEX(t.userIds,\x20\x27,\x27,\x20tally.n),\x20\x27,\x27,\x20-1)\x20userId,','\x20\x20\x20\x20t.permissions\x20permissions','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpPermissions;','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201701\x20THEN\x20\x27jscripty\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ORDER\x20BY\x20n)\x20AS\x20split','\x20\x20SELECT\x20name,\x20category,\x20sectionId,\x20enabled,\x20autoAssociation,\x20\x27red\x27,\x20now(),\x20now(),\x20userProfileId','\x20\x20FROM\x20tmpSections','reportType','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(1201,\x201202,\x201203)\x20THEN\x20\x27Analytics\x27','\x20\x20\x20\x20\x20\x20permissions\x20text\x20not\x20null,','renameColumn','\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\x20sectionId\x20int(11)\x20not\x20null,','Removed\x20column\x20%s\x20from\x20%s','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20700\x20THEN\x20\x27DELETE\x27','\x20\x20SET\x20r.sectionId\x20=\x20s.insertedId','\x20\x20);','\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\x20WHEN\x20name\x20=\x20\x27CustomDashboards\x27\x20THEN\x20(sectionId\x20-\x2099999)','CREATE\x20TABLE\x20tmpResources','CREATE\x20TABLE\x20tmpSharedProfiles','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201302\x20THEN\x20\x27SalesforceAccounts\x27','\x20\x20KEY\x20`sectionId`\x20(`sectionId`),','\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\x20END',',(SELECT\x200\x20AS\x20N\x20UNION\x20ALL\x20SELECT\x201\x20UNION\x20ALL\x20SELECT\x202\x20UNION\x20ALL\x20SELECT\x203\x20UNION\x20ALL\x20SELECT\x204\x20UNION\x20ALL\x20SELECT\x205\x20UNION\x20ALL\x20SELECT\x206\x20UNION\x20ALL\x20SELECT\x207\x20UNION\x20ALL\x20SELECT\x208\x20UNION\x20ALL\x20SELECT\x209)\x20d','\x20\x20\x20\x20\x20\x20SUBSTRING_INDEX(SUBSTRING_INDEX(s.userId,\x20\x27,\x27,\x20t.n),\x20\x27,\x27,\x20-1)\x20userId','\x20\x20`description`\x20varchar(255)\x20DEFAULT\x20NULL,','\x20\x20INNER\x20JOIN\x20user_has_mail_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','UPDATE\x20tmpSections','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(901,\x20902,\x20910)\x20THEN\x20\x27Fax\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201001\x20THEN\x20\x27CannedAnswers\x27','CREATE\x20TABLE\x20tmpExtractedResources\x20(','\x20\x20`crudPermissions`\x20varchar(255)\x20NOT\x20NULL\x20DEFAULT\x20\x27r\x27,','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20(SELECT\x20GROUP_CONCAT(userId\x20ORDER\x20BY\x20userId\x20ASC)\x20AS\x20users','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20409\x20THEN\x20\x27ChanSpies\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ELSE\x20\x27\x27','\x20\x20SELECT\x20id,\x20permissions,\x20null','INSERT\x20INTO\x20tmpFinalProfiles','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201600\x20THEN\x20\x27Help\x27','\x20\x20\x20\x20\x20\x20userId\x20text\x20not\x20null,','\x20\x20\x20\x20\x20\x20\x20\x20ORDER\x20BY\x20n)\x20AS\x20split;','\x20\x20SET\x20autoAssociation\x20=\x201\x20WHERE\x20sectionId\x20=\x20100;','\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','users','\x20\x20SELECT\x20x.sectionId,\x20u.OpenchannelQueueId,\x20x.userId','DELETE\x20t1\x20FROM\x20tmpSections\x20t1,\x20tmpCustomResources\x20t2','addIndex\x20%s\x20%s\x20%s','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201300\x20THEN\x20\x27DELETE\x27','addIndex','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpNormalizedUsers;','table\x20dropped\x20%s','INSERT\x20INTO\x20tmpSharedProfiles','UPDATE\x20users\x20u,\x20tmpFinalProfiles\x20f','\x20\x20KEY\x20`compositeIndex`\x20(`resourceId`,`sectionId`),','\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\x20SET\x20u.userProfileId\x20=\x201','\x20\x20INNER\x20JOIN\x20user_has_fax_accounts\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20`crudPermissions`\x20varchar(255)\x20DEFAULT\x20NULL,','\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\x20s.sectionId\x20permission,','CREATE\x20TABLE\x20tmpNormalizedPermissions','\x20\x20\x20\x20\x20\x20profileId\x20int(11)','\x20\x20\x20\x20userId\x20int(11)\x20not\x20null','INTEGER','\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\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))','INSERT\x20INTO\x20tmpSingleProfiles','\x20\x20WHERE\x20x.sectionId\x20=\x20702;','\x20\x20`autoAssociation`\x20tinyint(1)\x20DEFAULT\x20NULL,','\x20\x20SELECT\x20GROUP_CONCAT(id),\x20permissions,\x20null','analytics_extracted_reports','name','\x20\x20\x20\x20resourceId\x20int(11)\x20not\x20null,','\x20\x20ORDER\x20BY\x20n)\x20AS\x20split;','CREATE\x20TABLE\x20`user_profile_has_sections`\x20(','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20203\x20THEN\x20\x27Telephones\x27','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(401,\x20402,\x20403,\x20404,\x20405,\x20406,\x20407,\x20408,\x20409,\x20410,\x20411)\x20THEN\x20\x27Voice\x27','migration','\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\x20WHEN\x20sectionId\x20>=\x20100000\x20THEN\x20\x27Tools\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201301\x20THEN\x20\x27ZendeskAccounts\x27','\x20\x20`id`\x20int(11)\x20NOT\x20NULL\x20AUTO_INCREMENT,','\x20\x20SELECT\x20x.sectionId,\x20u.SmsQueueId,\x20x.userId','tail','\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\x20FROM\x20tally','\x20\x20SET\x20sectionId\x20=\x201003\x20WHERE\x20sectionId\x20>=\x20100000;','\x20\x20WHERE\x20x.sectionId\x20=\x20602;','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(202,\x20203,\x20204)\x20THEN\x20\x27Staff\x27','\x20\x20END','sequelize','\x20\x20FROM\x20tmpFinalProfiles\x20t','\x20\x20WHERE\x20x.sectionId\x20=\x20701;','\x20\x20SELECT\x20name,\x20resourceId,\x20type,\x20now(),\x20now(),\x20insertedSectionId','\x20\x20SELECT\x20*\x20FROM\x20tmpSingleProfiles;','TRUNCATE\x20TABLE\x20tmpPermissions;','\x20\x20WHERE\x20userId\x20NOT\x20IN\x20(SELECT\x20split.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=\x20502\x20THEN\x20\x27ChatWebsites\x27','\x20\x20FROM\x20tmpNormalizedUsers\x20x','CREATE\x20TABLE\x20tmpNormalizedResources','\x20\x20\x20\x20\x20\x20CASE','stringify',')\x20ENGINE=InnoDB\x20DEFAULT\x20CHARSET=utf8;','\x20\x20ORDER\x20BY\x20GROUP_CONCAT(id);','\x20\x20INNER\x20JOIN\x20user_has_square_projects\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20),','CREATE\x20TABLE\x20`user_profile_has_resources`\x20(','\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=\x201701\x20THEN\x20\x27Projects\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','INSERT\x20INTO\x20tmpCustomResources','Added\x20column\x20%s\x20to\x20%s','\x20\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)\x20c','\x20\x20FROM\x20tmpGroupedPermissions','prototype','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20801\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20openchannel_queues\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','\x20\x20SET\x20sectionId\x20=\x201801\x20WHERE\x20sectionId\x20between\x2088889\x20AND\x2099999;','\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','INSERT\x20INTO\x20tmpPermissions','\x20\x20FROM\x20tmpNormalizedResources;','\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','\x20\x20`createdAt`\x20datetime\x20NOT\x20NULL,','\x20\x20\x20\x20userId\x20text','then','\x20\x20FROM\x20tmpCustomResources;','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(601,\x20602,\x20603,\x20610)\x20THEN\x20\x27Mail\x27','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpResources;','\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=\x201006\x20THEN\x20\x27Scheduler\x27','\x20\x20FROM\x20user_profiles\x20u','\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\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20411\x20THEN\x20\x27Realtime\x27','VALUES\x20(\x27Default\x27,\x20\x27red\x27,\x20NULL,\x20NOW(),\x20NOW());','\x20\x20SELECT\x20x.sectionId,\x20u.SmsAccountId,\x20x.userId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20400\x20THEN\x20\x27DELETE\x27','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpSingleProfiles;','\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=\x201201\x20THEN\x20\x27Metrics\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);','\x20\x20WHERE\x20r.name\x20=\x20s.name\x20AND\x20r.userProfileId\x20=\x20s.userProfileId;','exports','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20CASE','\x20\x20\x20\x20\x20\x20type\x20varchar(255)\x20not\x20null,','\x20\x20SELECT\x20\x27\x27,\x20\x27\x27,\x20permission,\x201,\x200,\x20profileId,\x20null,\x20userId','\x20\x20PRIMARY\x20KEY\x20(`id`),','\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=\x201005\x20THEN\x20\x27Pauses\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ORDER\x20BY\x20n)\x20as\x20split','CREATE\x20TABLE\x20`user_profiles`\x20(','\x20\x20ORDER\x20BY\x20GROUP_CONCAT(userId);','\x20\x20\x20\x20enabled\x20tinyint\x20not\x20null,','\x20\x20\x20\x20\x20\x20\x20\x20fp.profileId\x20profileId,','UPDATE\x20tmpCustomResources','\x20\x20\x20\x20\x20\x20name\x20=\x20(SELECT','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20GROUP\x20BY\x20resourceId,\x20sectionId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20201\x20THEN\x20\x27DELETE\x27','\x20\x20FROM\x20(SELECT','\x20\x20\x20\x20\x20\x20permissions\x20text\x20not\x20null','\x20\x20WHERE\x20u.id\x20=\x20f.userId;','\x20\x20\x20\x20type\x20varchar(255)\x20not\x20null,','\x20\x20FROM\x20tmpFinalProfiles;','\x20\x20ORDER\x20BY\x20id;','INSERT\x20INTO\x20tmpGroupedPermissions','\x20\x20SET\x20name\x20=\x20(SELECT','\x20\x20FROM\x20users','\x20\x20INNER\x20JOIN\x20user_has_sms_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201011\x20THEN\x20\x27Trunks\x27','\x20\x20INNER\x20JOIN\x20user_has_openchannel_accounts\x20u\x20ON\x20u.UserId\x20=\x20x.userId','dropTable','\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=\x20300\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=\x201510\x20THEN\x20\x27Realtime\x27','ON\x20UPDATE\x20CASCADE','\x20\x20ORDER\x20BY\x20userId;','queryInterface','\x20\x20FROM\x20tmpSections;','\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\x20SUBSTRING_INDEX(SUBSTRING_INDEX(r.resourceId,\x20\x27,\x27,\x20tally.n),\x20\x27,\x27,\x20-1)\x20resourceId,','removeIndex','voice_voicemail','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20);','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\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',',(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=\x201202\x20THEN\x20\x27ExtractedReports\x27','CREATE\x20TABLE\x20tmpSections','CREATE\x20TABLE\x20tally\x20(','\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','removeIndex\x20%s\x20%s','UPDATE\x20users\x20u,\x20tmpNormalizedPermissions\x20t','INSERT\x20INTO\x20user_profiles\x20(name,\x20crudPermissions,\x20createdAt,\x20updatedAt)','\x20\x20SELECT\x20userId,\x20permissions,\x20null','\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\x20INNER\x20JOIN\x20user_has_fax_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','query\x20%s','\x20\x20SELECT\x20x.sectionId,\x20u.SquareProjectId,\x20x.userId','INSERT\x20INTO\x20tmpSections','ALTER\x20TABLE\x20`users`\x20','\x20\x20SELECT\x20userId,\x20permissions','\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=\x20301\x20THEN\x20\x27Lists\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201010\x20THEN\x20\x27Triggers\x27','CREATE\x20TABLE\x20tmpCustomResources','info','\x20DROP\x20TABLE\x20IF\x20EXISTS\x20tally;','\x20\x20\x20\x20\x20\x20userIds\x20varchar(255)\x20not\x20null,','\x20\x20`enabled`\x20tinyint(1)\x20DEFAULT\x20NULL,','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(301,\x20302,\x20303,\x20304)\x20THEN\x20\x27ContactManager\x27','INSERT\x20INTO\x20tmpNormalizedSections','CREATE\x20TABLE\x20tmpFinalProfiles','\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\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=\x20302\x20THEN\x20\x27Companies\x27','\x20\x20\x20\x20autoAssociation\x20tinyint\x20not\x20null,','join','removeColumn','\x20\x20WHERE\x20x.sectionId\x20=\x20601;','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpSections;','UPDATE\x20tmpFinalProfiles','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201400\x20THEN\x20\x27Settings\x27','\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','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpNormalizedResources;','DELETE\x20FROM\x20tmpNormalizedResources','\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=\x20407\x20THEN\x20\x27MusicOnHolds\x27','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20802\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20openchannel_accounts\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','INSERT\x20INTO\x20tmpResources','\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\x20WHERE\x20x.sectionId\x20=\x201501\x20AND\x20q.type\x20=\x20\x27outbound\x27;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20END','inspect','UPDATE\x20tmpSections\x20s','\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\x20p.userIds\x20userId','\x20\x20\x20\x20\x20\x20\x20\x20INNER\x20JOIN\x20tmpResources\x20r\x20ON\x20CHAR_LENGTH(r.resourceId)\x20-\x20CHAR_LENGTH(REPLACE(r.resourceId,\x20\x27,\x27,\x20\x27\x27))\x20>=\x20tally.n-1','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201501\x20THEN\x20\x27QueueCampaigns\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201502\x20THEN\x20\x27IvrCampaigns\x27','\x20\x20WHERE\x20userId\x20IN\x20(SELECT\x20split.userId','finally','\x20\x20WHERE\x20role\x20=\x20\x27user\x27\x20and\x20permissions\x20is\x20not\x20null\x20and\x20permissions\x20<>\x20\x27\x27','\x20\x20SELECT\x20*','\x20\x20SELECT\x20GROUP_CONCAT(sectionId\x20ORDER\x20BY\x20sectionId),\x20userId','\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\x20SELECT\x20x.sectionId,\x20u.MailAccountId,\x20x.userId','\x20\x20\x20\x20sectionId\x20int(11)\x20not\x20null,','INSERT\x20INTO\x20tmpNormalizedResources','\x20\x20userId\x20int(11)','\x20\x20\x20\x20insertedId\x20int(11),','\x20\x20\x20\x20name\x20varchar(255)\x20not\x20null,','\x20\x20\x20\x20permissions\x20text\x20not\x20null,','\x20\x20`sectionId`\x20int(11)\x20NOT\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=\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\x20CASE','\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\x20\x20\x20sectionId\x20int(11)','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201601\x20THEN\x20\x27DELETE\x27','CREATE\x20TABLE\x20tmpNormalizedSections','\x20\x20SELECT\x20\x27\x27,\x20insertedId,\x20name,\x20sectionId,\x20null','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20602\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20mail_accounts\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20(SELECT','\x20\x20SELECT\x20x.sectionId,\x20u.MailQueueId,\x20x.userId','\x20\x20SELECT\x20cr.resourceId,\x20name,\x20s.insertedId,\x20s.sectionId','\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=\x201009\x20THEN\x20\x27Templates\x27','UPDATE\x20tmpNormalizedResources\x20x','INSERT\x20INTO\x20user_profile_has_resources\x20(name,\x20resourceId,\x20type,\x20createdAt,\x20updatedAt,\x20sectionId)','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\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=\x20901\x20THEN\x20\x27FaxQueues\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\x20resourceId\x20text','REFERENCES\x20user_profiles(`id`)\x20','\x20\x20CONSTRAINT\x20`user_profile_has_sections_ibfk_1`\x20FOREIGN\x20KEY\x20(`userProfileId`)\x20REFERENCES\x20`user_profiles`\x20(`id`)\x20ON\x20DELETE\x20CASCADE\x20ON\x20UPDATE\x20CASCADE','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(1501,\x201502,\x201510)\x20THEN\x20\x27MotionDialer\x27','\x20\x20INNER\x20JOIN\x20user_has_openchannel_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20SELECT\x20x.sectionId,\x20u.VoiceQueueId,\x20x.userId','\x20\x20WHERE\x20x.sectionId\x20=\x20902;','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpExtractedResources;','\x20\x20WHERE\x20x.sectionId\x20=\x20901;','\x20\x20INNER\x20JOIN\x20user_has_voice_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20404\x20THEN\x20\x27InternalRoutes\x27','\x20\x20INNER\x20JOIN\x20tmpExtractedResources\x20cr\x20ON\x20cr.userId\x20=\x20s.userId\x20AND\x20cr.sectionId\x20=\x20s.sectionId\x20AND\x20cr.resourceId\x20IS\x20NOT\x20NULL;','\x20\x20`category`\x20varchar(255)\x20NOT\x20NULL,','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpNormalizedSections;','\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)','enqueue','catch','\x20\x20resourceId\x20int(11),','util','CREATE\x20TABLE\x20tmpPermissions','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpSharedProfiles;','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(501,\x20502,\x20510)\x20THEN\x20\x27Chat\x27','\x20\x20WHERE\x20x.sectionId\x20=\x201103;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20406\x20THEN\x20\x27Voicemails\x27','query','\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.OpenchannelAccountId,\x20x.userId','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=\x20510\x20THEN\x20\x27Realtime\x27','\x20\x20SELECT\x20x.sectionId,\x20u.ChatWebsiteId,\x20x.userId','\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'];(function(_0x46e00b,_0x2f968a){const _0x46fe8d=function(_0x5a40c3){while(--_0x5a40c3){_0x46e00b['push'](_0x46e00b['shift']());}};_0x46fe8d(++_0x2f968a);}(a964_0x2f96,0x1aa));const a964_0x46fe=function(_0x46e00b,_0x2f968a){_0x46e00b=_0x46e00b-0x0;let _0x46fe8d=a964_0x2f96[_0x46e00b];return _0x46fe8d;};const _0xbdeb=a964_0x46fe;'use strict';const util=require(_0xbdeb('0x113')),logger=require('../config/logger')(_0xbdeb('0x3e')),Sequence=function(){};Sequence[_0xbdeb('0x65')]['enqueue']=function(_0x5a40c3){const _0x5dfef8=_0xbdeb;this[_0x5dfef8('0x44')]=this[_0x5dfef8('0x44')]?this['tail'][_0x5dfef8('0xe0')](_0x5a40c3):_0x5a40c3();};const Migration=function(_0x41d7e0){const _0x6b2aca=_0xbdeb;this[_0x6b2aca('0xa1')]=_0x41d7e0,this[_0x6b2aca('0x121')]=new Sequence();};Migration[_0xbdeb('0x65')][_0xbdeb('0x154')]=function(_0x1dac51,_0x4a8020,_0x4e7193){const _0x45abf8=_0xbdeb,_0x140094=this;this[_0x45abf8('0x121')][_0x45abf8('0x110')](function(){const _0x43747c=_0x45abf8;return _0x140094[_0x43747c('0xa1')]['changeColumn'](_0x1dac51,_0x4a8020,_0x4e7193)['then'](function(){const _0x179582=_0x43747c;logger[_0x179582('0xbd')](_0x179582('0x11c'),_0x4a8020,_0x1dac51);})['catch'](function(_0x5e2c13){const _0x5c551e=_0x43747c;logger[_0x5c551e('0xbd')](JSON['stringify'](_0x5e2c13));});});},Migration[_0xbdeb('0x65')][_0xbdeb('0x14b')]=function(_0x484ead,_0x325794,_0x3259b5){const _0xf3e458=_0xbdeb,_0x3c35d6=this;this[_0xf3e458('0x121')][_0xf3e458('0x110')](function(){const _0x4d6d34=_0xf3e458;return _0x3c35d6['queryInterface'][_0x4d6d34('0x14b')](_0x484ead,_0x325794,_0x3259b5)[_0x4d6d34('0x6e')](function(){const _0x5bbfb7=_0x4d6d34;logger['info'](_0x5bbfb7('0x61'),_0x325794,_0x484ead);})[_0x4d6d34('0x111')](function(_0x21a7b2){const _0x4594c7=_0x4d6d34;logger[_0x4594c7('0xbd')](JSON['stringify'](_0x21a7b2));});});},Migration[_0xbdeb('0x65')][_0xbdeb('0x9b')]=function(_0x412d5f){const _0x5ac54c=_0xbdeb,_0x1f53a3=this;this[_0x5ac54c('0x121')][_0x5ac54c('0x110')](function(){const _0x3bd6f2=_0x5ac54c;return _0x1f53a3['queryInterface'][_0x3bd6f2('0x9b')](_0x412d5f,{'force':!![]})[_0x3bd6f2('0x6e')](function(){const _0x5c3419=_0x3bd6f2;logger['info'](_0x5c3419('0x23'),_0x412d5f);})[_0x3bd6f2('0x111')](function(_0x5108f3){const _0x1a6e28=_0x3bd6f2;logger['info'](JSON[_0x1a6e28('0x57')](_0x5108f3));});});},Migration[_0xbdeb('0x65')][_0xbdeb('0x21')]=function(_0x3f1ae1,_0x2df3f1,_0x5289c0){const _0x60220f=_0xbdeb,_0x294a07=this;this[_0x60220f('0x121')][_0x60220f('0x110')](function(){const _0x594858=_0x60220f;return _0x294a07[_0x594858('0xa1')][_0x594858('0x21')](_0x3f1ae1,_0x2df3f1,{'indexName':_0x5289c0})[_0x594858('0x6e')](function(){const _0x3b577b=_0x594858;logger['info'](_0x3b577b('0x1f'),_0x3f1ae1,_0x2df3f1[_0x3b577b('0xc8')](','),_0x5289c0);})[_0x594858('0x111')](function(_0x2f3c51){logger['info'](JSON['stringify'](_0x2f3c51));});});},Migration[_0xbdeb('0x65')][_0xbdeb('0xa5')]=function(_0x42a574,_0x21d337){const _0x4d4f66=_0xbdeb,_0x3f66ec=this;this[_0x4d4f66('0x121')][_0x4d4f66('0x110')](function(){const _0x1c0c96=_0x4d4f66;return _0x3f66ec[_0x1c0c96('0xa1')][_0x1c0c96('0xa5')](_0x42a574,_0x21d337)[_0x1c0c96('0x6e')](function(){const _0x58a685=_0x1c0c96;logger[_0x58a685('0xbd')](_0x58a685('0xae'),_0x42a574,_0x21d337);})[_0x1c0c96('0x111')](function(_0x5e7fab){const _0x43c21f=_0x1c0c96;logger[_0x43c21f('0xbd')](JSON[_0x43c21f('0x57')](_0x5e7fab));});});},Migration[_0xbdeb('0x65')][_0xbdeb('0x119')]=function(_0x3c944a){const _0x32b9d9=_0xbdeb,_0x59a54a=this;this[_0x32b9d9('0x121')][_0x32b9d9('0x110')](function(){const _0x1b7424=_0x32b9d9;return _0x59a54a[_0x1b7424('0xa1')][_0x1b7424('0x4b')]['query'](_0x3c944a)[_0x1b7424('0x6e')](function(){const _0x2a3ab5=_0x1b7424;logger[_0x2a3ab5('0xbd')](_0x2a3ab5('0xb4'),_0x3c944a);})[_0x1b7424('0x111')](function(_0x4cd272){const _0x2bf67d=_0x1b7424;logger['info'](JSON[_0x2bf67d('0x57')](_0x4cd272));});});},Migration[_0xbdeb('0x65')]['removeColumn']=function(_0x43663e,_0x17be22){const _0x50a9c3=this;this['sequence']['enqueue'](function(){const _0x4d353b=a964_0x46fe;return _0x50a9c3[_0x4d353b('0xa1')][_0x4d353b('0xc9')](_0x43663e,_0x17be22)[_0x4d353b('0x6e')](function(){const _0x5ec2fb=_0x4d353b;logger['info'](_0x5ec2fb('0x162'),_0x17be22,_0x43663e);})[_0x4d353b('0x111')](function(_0x4f82f9){const _0x4c98b5=_0x4d353b;logger[_0x4c98b5('0xbd')](util[_0x4c98b5('0xd8')](_0x4f82f9,{'showHidden':![],'depth':null}));});});},Migration[_0xbdeb('0x65')][_0xbdeb('0x15f')]=function(_0x2c401d,_0x46a21d,_0x684f63){const _0x29f363=_0xbdeb,_0x10a931=this;this[_0x29f363('0x121')][_0x29f363('0x110')](function(){const _0x3f6b59=_0x29f363;return _0x10a931['queryInterface']['renameColumn'](_0x2c401d,_0x46a21d,_0x684f63)[_0x3f6b59('0x6e')](function(){const _0x17ca86=_0x3f6b59;logger[_0x17ca86('0xbd')]('Renamed\x20column\x20from\x20%s\x20to\x20%s\x20on\x20%s',_0x46a21d,_0x684f63,_0x2c401d);})[_0x3f6b59('0x111')](function(_0x2ec9ff){const _0x549fed=_0x3f6b59;logger[_0x549fed('0xbd')](util['inspect'](_0x2ec9ff,{'showHidden':![],'depth':null}));});});},Migration['prototype'][_0xbdeb('0x132')]=function(_0x4eafe6){const _0x543904=_0xbdeb;this[_0x543904('0x121')][_0x543904('0x110')](function(){return _0x4eafe6();});},module[_0xbdeb('0x7f')]={'up':function(_0x85f2e0,_0x5b744a){return new Promise(function(_0x5a30fc){const _0x3d13b5=a964_0x46fe,_0x42d68b=new Migration(_0x85f2e0);_0x42d68b['addColumn'](_0x3d13b5('0x37'),'reportId',{'type':_0x5b744a[_0x3d13b5('0x30')]}),_0x42d68b[_0x3d13b5('0x14b')](_0x3d13b5('0x37'),_0x3d13b5('0x15c'),{'type':_0x5b744a['STRING']}),_0x42d68b[_0x3d13b5('0x14b')](_0x3d13b5('0x1c'),'userProfileId',{'type':_0x5b744a[_0x3d13b5('0x30')]}),_0x42d68b[_0x3d13b5('0xc9')](_0x3d13b5('0xa6'),_0x3d13b5('0x38')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x87')+'\x20\x20`id`\x20int(11)\x20NOT\x20NULL\x20AUTO_INCREMENT,'+'\x20\x20`name`\x20varchar(255)\x20NOT\x20NULL,'+_0x3d13b5('0x11')+_0x3d13b5('0xb')+'\x20\x20`createdAt`\x20datetime\x20NOT\x20NULL,'+'\x20\x20`updatedAt`\x20datetime\x20NOT\x20NULL,'+_0x3d13b5('0x83')+'\x20\x20UNIQUE\x20KEY\x20`name`\x20(`name`)'+')\x20ENGINE=InnoDB\x20DEFAULT\x20CHARSET=utf8;'),_0x42d68b[_0x3d13b5('0x119')]('INSERT\x20INTO\x20`user_profiles`\x20(`name`,\x20`crudPermissions`,\x20`description`,\x20`createdAt`,\x20`updatedAt`)'+_0x3d13b5('0x77')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0xb7')+_0x3d13b5('0x134')+_0x3d13b5('0x137')+_0x3d13b5('0x102')+_0x3d13b5('0x9f')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x3b')+_0x3d13b5('0x42')+'\x20\x20`name`\x20varchar(255)\x20NOT\x20NULL,'+_0x3d13b5('0x10d')+_0x3d13b5('0xec')+_0x3d13b5('0xc0')+_0x3d13b5('0x35')+_0x3d13b5('0x2a')+_0x3d13b5('0x6c')+_0x3d13b5('0x126')+_0x3d13b5('0x1')+_0x3d13b5('0x83')+'\x20\x20KEY\x20`userProfileId`\x20(`userProfileId`),'+_0x3d13b5('0x128')+_0x3d13b5('0x103')+_0x3d13b5('0x58')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x5c')+_0x3d13b5('0x42')+'\x20\x20`name`\x20varchar(255)\x20NOT\x20NULL,'+'\x20\x20`resourceId`\x20int(11)\x20NOT\x20NULL,'+_0x3d13b5('0x129')+_0x3d13b5('0x6c')+_0x3d13b5('0x126')+'\x20\x20`sectionId`\x20int(11)\x20DEFAULT\x20NULL,'+_0x3d13b5('0x83')+_0x3d13b5('0x6')+_0x3d13b5('0x26')+'\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'+_0x3d13b5('0x58')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0xac')+'\x20\x20n\x20INT\x20NOT\x20NULL\x20AUTO_INCREMENT\x20PRIMARY\x20KEY'+');'),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x148')+'SELECT\x20NULL\x20FROM'+_0x3d13b5('0x5f')+_0x3d13b5('0xa9')+_0x3d13b5('0x63')+_0x3d13b5('0x9')+',(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'+';'),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x114')+_0x3d13b5('0x62')+_0x3d13b5('0xbf')+_0x3d13b5('0x15e')+_0x3d13b5('0x2e')+'\x20\x20);'),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x69')+_0x3d13b5('0x15')+_0x3d13b5('0x97')+'\x20\x20WHERE\x20role\x20=\x20\x27user\x27\x20and\x20permissions\x20is\x20not\x20null\x20and\x20permissions\x20<>\x20\x27\x27'+_0x3d13b5('0x94')),_0x42d68b['query'](_0x3d13b5('0xf4')+_0x3d13b5('0x62')+_0x3d13b5('0xe6')+'\x20\x20\x20\x20userId\x20text,'+'\x20\x20\x20\x20resourceId\x20text'+_0x3d13b5('0x0')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0xc2')+'\x20\x20SELECT\x20DISTINCT\x20permission,\x20userId,\x200'+_0x3d13b5('0x8f')+_0x3d13b5('0x75')+_0x3d13b5('0xdb')+_0x3d13b5('0xf1')+_0x3d13b5('0x3a')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x2d')+'\x20\x20('+_0x3d13b5('0xeb')+_0x3d13b5('0x2f')+_0x3d13b5('0x0')),_0x42d68b['query']('INSERT\x20INTO\x20tmpNormalizedPermissions'+_0x3d13b5('0xe3')+'\x20\x20FROM\x20tmpNormalizedSections'+'\x20\x20GROUP\x20BY\x20userId;'),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0xaf')+_0x3d13b5('0x13e')+'\x20\x20WHERE\x20u.id\x20=\x20t.userId;'),_0x42d68b['query'](_0x3d13b5('0x50')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x69')+_0x3d13b5('0x36')+'\x20\x20FROM\x20users'+_0x3d13b5('0xe1')+_0x3d13b5('0x84')+_0x3d13b5('0x59')),_0x42d68b[_0x3d13b5('0x119')]('CREATE\x20TABLE\x20tmpNormalizedUsers'+_0x3d13b5('0x62')+_0x3d13b5('0xe6')+'\x20\x20\x20\x20userId\x20text,'+_0x3d13b5('0x101')+_0x3d13b5('0x0')),_0x42d68b[_0x3d13b5('0x119')]('INSERT\x20INTO\x20tmpNormalizedUsers'+_0x3d13b5('0x150')+_0x3d13b5('0x8f')+_0x3d13b5('0x2c')+_0x3d13b5('0xa')+'\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'+_0x3d13b5('0x3a')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x10')+_0x3d13b5('0x161')+_0x3d13b5('0x112')+_0x3d13b5('0xe8')+'\x20\x20);'),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x52')+_0x3d13b5('0x106')+'\x20\x20FROM\x20tmpNormalizedUsers\x20x'+'\x20\x20INNER\x20JOIN\x20user_has_voice_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId'+_0x3d13b5('0x130')+'\x20\x20WHERE\x20x.sectionId\x20=\x20401\x20AND\x20q.type\x20=\x20\x27inbound\x27;'),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x52')+'\x20\x20SELECT\x20x.sectionId,\x20u.ChatQueueId,\x20x.userId'+_0x3d13b5('0x54')+'\x20\x20INNER\x20JOIN\x20user_has_chat_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId'+'\x20\x20WHERE\x20x.sectionId\x20=\x20501;'),_0x42d68b['query'](_0x3d13b5('0x52')+_0x3d13b5('0x11e')+'\x20\x20FROM\x20tmpNormalizedUsers\x20x'+'\x20\x20INNER\x20JOIN\x20user_has_chat_websites\x20u\x20ON\x20u.UserId\x20=\x20x.userId'+'\x20\x20WHERE\x20x.sectionId\x20=\x20502;'),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x52')+_0x3d13b5('0xf8')+'\x20\x20FROM\x20tmpNormalizedUsers\x20x'+_0x3d13b5('0xc')+_0x3d13b5('0xca')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x52')+_0x3d13b5('0xe5')+_0x3d13b5('0x54')+'\x20\x20INNER\x20JOIN\x20user_has_mail_accounts\x20u\x20ON\x20u.UserId\x20=\x20x.userId'+_0x3d13b5('0x48')),_0x42d68b[_0x3d13b5('0x119')]('INSERT\x20INTO\x20tmpExtractedResources'+_0x3d13b5('0x43')+_0x3d13b5('0x54')+_0x3d13b5('0x98')+_0x3d13b5('0x4d')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x52')+_0x3d13b5('0x78')+'\x20\x20FROM\x20tmpNormalizedUsers\x20x'+'\x20\x20INNER\x20JOIN\x20user_has_sms_accounts\x20u\x20ON\x20u.UserId\x20=\x20x.userId'+_0x3d13b5('0x34')),_0x42d68b[_0x3d13b5('0x119')]('INSERT\x20INTO\x20tmpExtractedResources'+_0x3d13b5('0x1d')+_0x3d13b5('0x54')+_0x3d13b5('0x105')+'\x20\x20WHERE\x20x.sectionId\x20=\x20801;'),_0x42d68b[_0x3d13b5('0x119')]('INSERT\x20INTO\x20tmpExtractedResources'+_0x3d13b5('0x11b')+'\x20\x20FROM\x20tmpNormalizedUsers\x20x'+_0x3d13b5('0x9a')+'\x20\x20WHERE\x20x.sectionId\x20=\x20802;'),_0x42d68b[_0x3d13b5('0x119')]('INSERT\x20INTO\x20tmpExtractedResources'+'\x20\x20SELECT\x20x.sectionId,\x20u.FaxQueueId,\x20x.userId'+_0x3d13b5('0x54')+_0x3d13b5('0xb3')+_0x3d13b5('0x109')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x52')+'\x20\x20SELECT\x20x.sectionId,\x20u.FaxAccountId,\x20x.userId'+_0x3d13b5('0x54')+_0x3d13b5('0x29')+_0x3d13b5('0x107')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x52')+_0x3d13b5('0xb5')+_0x3d13b5('0x54')+_0x3d13b5('0x5a')+_0x3d13b5('0x117')),_0x42d68b['query'](_0x3d13b5('0x52')+'\x20\x20SELECT\x20x.sectionId,\x20u.VoiceQueueId,\x20x.userId'+_0x3d13b5('0x54')+_0x3d13b5('0x10a')+_0x3d13b5('0x130')+_0x3d13b5('0xd6')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0xef')+_0x3d13b5('0x62')+_0x3d13b5('0x18')+_0x3d13b5('0x90')+'\x20\x20);'),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x95')+_0x3d13b5('0xb8')+'\x20\x20FROM\x20(SELECT'+_0x3d13b5('0x155')+_0x3d13b5('0x156')+_0x3d13b5('0xda')+'\x20\x20ORDER\x20BY\x20n)\x20AS\x20split;'),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x4')+'\x20\x20('+_0x3d13b5('0xbf')+_0x3d13b5('0x15e')+_0x3d13b5('0x2e')+_0x3d13b5('0x0')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x24')+'\x20\x20SELECT\x20GROUP_CONCAT(userId),\x20permissions,\x20null'+'\x20\x20FROM\x20tmpGroupedPermissions'+_0x3d13b5('0x51')+_0x3d13b5('0xf7')+_0x3d13b5('0xfe')+'\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'+_0x3d13b5('0xa8')+'\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'+_0x3d13b5('0x159')+'\x20\x20WHERE\x20split.userId\x20IN\x20(SELECT\x20*\x20FROM'+_0x3d13b5('0x12')+'\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'+_0x3d13b5('0x8d')+_0x3d13b5('0x146')+_0x3d13b5('0x12f')+'\x20\x20GROUP\x20BY\x20permissions'+_0x3d13b5('0x88')),_0x42d68b[_0x3d13b5('0x119')]('CREATE\x20TABLE\x20tmpSingleProfiles'+_0x3d13b5('0x62')+_0x3d13b5('0x18')+'\x20\x20\x20\x20\x20\x20permissions\x20text\x20not\x20null,'+_0x3d13b5('0x2e')+_0x3d13b5('0x0')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x33')+_0x3d13b5('0xb1')+_0x3d13b5('0x64')+_0x3d13b5('0xdf')+'\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'+_0x3d13b5('0xb2')+_0x3d13b5('0x133')+_0x3d13b5('0x86')+'\x20\x20WHERE\x20split.userId\x20IN\x20(SELECT\x20*\x20FROM'+_0x3d13b5('0x11a')+_0x3d13b5('0x12d')+_0x3d13b5('0x144')+_0x3d13b5('0x153')+_0x3d13b5('0x32')+_0x3d13b5('0xa0')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0xc3')+_0x3d13b5('0x62')+_0x3d13b5('0x18')+_0x3d13b5('0x15e')+'\x20\x20\x20\x20\x20\x20profileId\x20int(11)'+_0x3d13b5('0x0')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x16')+_0x3d13b5('0x122')+_0x3d13b5('0x14d')+_0x3d13b5('0x4f')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0xb0')+'\x20\x20SELECT\x20CONCAT(\x27Profile_\x27,\x20(SELECT\x20(@cnt\x20:=\x20@cnt\x20+\x201)\x20AS\x20rowNumber'+_0x3d13b5('0x4c')+'\x20\x20CROSS\x20JOIN\x20(SELECT\x20@cnt\x20:=\x200)\x20as\x20dummy\x20LIMIT\x201)),\x20\x27red\x27,\x20now(),\x20now()'+_0x3d13b5('0x93')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0xcc')+'\x20\x20SET\x20profileId\x20=\x20(SELECT\x20(@cnt\x20:=\x20@cnt\x20+\x201)\x20AS\x20rowNumber'+_0x3d13b5('0x74')+_0x3d13b5('0xfa')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0xab')+_0x3d13b5('0x62')+_0x3d13b5('0xea')+_0x3d13b5('0x72')+_0x3d13b5('0xe6')+_0x3d13b5('0x89')+_0x3d13b5('0xc7')+_0x3d13b5('0x5d')+_0x3d13b5('0xe9')+_0x3d13b5('0x6d')+_0x3d13b5('0x0')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0xb6')+_0x3d13b5('0x82')+'\x20\x20FROM\x20(SELECT'+_0x3d13b5('0x8a')+_0x3d13b5('0x160')+'\x20\x20\x20\x20\x20\x20\x20\x20SUBSTRING_INDEX(fp.userId,\x20\x27,\x27,\x201)\x20userId'+_0x3d13b5('0x46')+_0x3d13b5('0xce')+_0x3d13b5('0x19')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0xd')+_0x3d13b5('0x149')+_0x3d13b5('0x8c')+_0x3d13b5('0x80')+'\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'+_0x3d13b5('0xee')+'\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'+_0x3d13b5('0x8e')+_0x3d13b5('0x13b')+_0x3d13b5('0x3c')+_0x3d13b5('0xad')+_0x3d13b5('0x9d')+_0x3d13b5('0xba')+_0x3d13b5('0xc6')+'\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'+_0x3d13b5('0x9c')+_0x3d13b5('0x79')+_0x3d13b5('0x3f')+_0x3d13b5('0x136')+_0x3d13b5('0x31')+_0x3d13b5('0x10b')+'\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'+_0x3d13b5('0x118')+_0x3d13b5('0xd2')+'\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'+_0x3d13b5('0x13')+_0x3d13b5('0x13f')+_0x3d13b5('0x76')+_0x3d13b5('0x13c')+'\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'+_0x3d13b5('0x53')+_0x3d13b5('0x11d')+'\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'+_0x3d13b5('0x13d')+'\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'+_0x3d13b5('0x2b')+_0x3d13b5('0x1b')+_0x3d13b5('0x163')+'\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'+_0x3d13b5('0x68')+'\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'+_0x3d13b5('0x145')+'\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'+_0x3d13b5('0x131')+_0x3d13b5('0x142')+_0x3d13b5('0xa3')+_0x3d13b5('0xff')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20902\x20THEN\x20\x27FaxAccounts\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20910\x20THEN\x20\x27Realtime\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201000\x20THEN\x20\x27DELETE\x27'+_0x3d13b5('0xf')+'\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'+_0x3d13b5('0x120')+_0x3d13b5('0x123')+_0x3d13b5('0x85')+_0x3d13b5('0x73')+'\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'+_0x3d13b5('0x45')+_0x3d13b5('0xfb')+_0x3d13b5('0xbb')+_0x3d13b5('0x99')+_0x3d13b5('0xc5')+_0x3d13b5('0x12c')+'\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\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\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201103\x20THEN\x20\x27SquareProjects\x27'+_0x3d13b5('0x12a')+_0x3d13b5('0x7c')+_0x3d13b5('0xaa')+_0x3d13b5('0x12b')+_0x3d13b5('0x20')+_0x3d13b5('0x41')+_0x3d13b5('0x5')+'\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\x20WHEN\x20sectionId\x20=\x201305\x20THEN\x20\x27SugarcrmAccounts\x27'+_0x3d13b5('0xd1')+_0x3d13b5('0xc4')+_0x3d13b5('0x151')+_0x3d13b5('0x6b')+_0x3d13b5('0xd5')+_0x3d13b5('0x135')+_0x3d13b5('0xdd')+_0x3d13b5('0xde')+_0x3d13b5('0x9e')+'\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'+_0x3d13b5('0xf3')+'\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'+_0x3d13b5('0x5e')+'\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'+_0x3d13b5('0xe4')+_0x3d13b5('0x14')+_0x3d13b5('0x8')+_0x3d13b5('0x5b')+_0x3d13b5('0x138')+_0x3d13b5('0x56')+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20100\x20THEN\x20\x27Dashboards\x27'+_0x3d13b5('0x40')+_0x3d13b5('0x49')+_0x3d13b5('0xc1')+_0x3d13b5('0x3d')+_0x3d13b5('0x116')+_0x3d13b5('0x70')+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(701,\x20702,\x20710)\x20THEN\x20\x27Sms\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(801,\x20802,\x20810)\x20THEN\x20\x27Openchannel\x27'+_0x3d13b5('0xe')+_0x3d13b5('0x11f')+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(1101,\x201102,\x201103)\x20THEN\x20\x27CallySquare\x27'+_0x3d13b5('0x15d')+_0x3d13b5('0x152')+_0x3d13b5('0xcd')+_0x3d13b5('0x104')+_0x3d13b5('0x17')+_0x3d13b5('0x158')+'\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'+'\x20\x20\x20\x20\x20\x20END'+_0x3d13b5('0x0')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x13a')+'\x20\x20WHERE\x20name\x20=\x20\x27DELETE\x27;'),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0xbc')+_0x3d13b5('0x62')+_0x3d13b5('0xea')+_0x3d13b5('0x72')+_0x3d13b5('0xe6')+_0x3d13b5('0x89')+_0x3d13b5('0xc7')+_0x3d13b5('0x5d')+_0x3d13b5('0xe9')+_0x3d13b5('0x6d')+_0x3d13b5('0x0')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x60')+_0x3d13b5('0xe2')+_0x3d13b5('0x15b')+_0x3d13b5('0x14c')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x1e')+'\x20\x20WHERE\x20t1.name\x20=\x20t2.name\x20AND\x20t1.userProfileId\x20=\x20t2.userProfileId\x20AND\x20t1.sectionId\x20>\x20t2.sectionId;'),_0x42d68b['query'](_0x3d13b5('0xd')+_0x3d13b5('0x67')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0xd')+_0x3d13b5('0x47')),_0x42d68b['query']('UPDATE\x20tmpSections'+_0x3d13b5('0x1a')),_0x42d68b['query'](_0x3d13b5('0x8b')+'\x20\x20SET\x20insertedId\x20=\x20(SELECT'+_0x3d13b5('0xf0')+_0x3d13b5('0x139')+_0x3d13b5('0x2')+_0x3d13b5('0xd7')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20);'),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x14a')+_0x3d13b5('0x15a')+_0x3d13b5('0xa2')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0xd9')+_0x3d13b5('0xed')+'\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'+_0x3d13b5('0x7d')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x127')+_0x3d13b5('0x164')+_0x3d13b5('0x7e')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x3')+_0x3d13b5('0x62')+'\x20\x20\x20\x20\x20\x20resourceId\x20text,'+_0x3d13b5('0x81')+_0x3d13b5('0x14f')+_0x3d13b5('0x12e')+'\x20\x20);'),_0x42d68b['query'](_0x3d13b5('0xd4')+_0x3d13b5('0xf9')+'\x20\x20FROM\x20tmpSections\x20s'+_0x3d13b5('0x10c')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x55')+'\x20\x20('+_0x3d13b5('0xea')+_0x3d13b5('0x39')+_0x3d13b5('0x92')+'\x20\x20\x20\x20insertedSectionId\x20int(11)\x20not\x20null,'+_0x3d13b5('0xf2')+_0x3d13b5('0x0')),_0x42d68b['query'](_0x3d13b5('0xe7')+_0x3d13b5('0x147')+'\x20\x20FROM\x20(SELECT'+_0x3d13b5('0xa4')+'\x20\x20\x20\x20\x20\x20\x20\x20r.type\x20type,'+'\x20\x20\x20\x20\x20\x20\x20\x20r.insertedSectionId\x20insertedSectionId,'+_0x3d13b5('0x7')+_0x3d13b5('0x46')+_0x3d13b5('0xdc')+_0x3d13b5('0x19')),_0x42d68b['query'](_0x3d13b5('0xe7')+_0x3d13b5('0xf5')+_0x3d13b5('0x6f')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0xfc')+_0x3d13b5('0x96')+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20CASE'+_0x3d13b5('0x141')+_0x3d13b5('0xb9')+'\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)'+_0x3d13b5('0x100')+_0x3d13b5('0xf6')+_0x3d13b5('0x143')+_0x3d13b5('0x7b')+_0x3d13b5('0x66')+_0x3d13b5('0xd3')+_0x3d13b5('0x27')+'\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\x20WHEN\x20x.sectionId\x20=\x201103\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20square_projects\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)'+_0x3d13b5('0x14e')+_0x3d13b5('0x10f')+'\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)'+_0x3d13b5('0x4a')+_0x3d13b5('0xa7')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0xd0')+_0x3d13b5('0x140')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0xfd')+_0x3d13b5('0x4e')+_0x3d13b5('0x6a')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x25')+'\x20\x20SET\x20u.userProfileId\x20=\x20f.profileId'+_0x3d13b5('0x91')),_0x42d68b[_0x3d13b5('0x119')]('UPDATE\x20users\x20u'+_0x3d13b5('0x28')+_0x3d13b5('0x125')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0xbe')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x157')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x10e')),_0x42d68b['query'](_0x3d13b5('0x22')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x108')),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x124')),_0x42d68b['query'](_0x3d13b5('0x115')),_0x42d68b['query'](_0x3d13b5('0x7a')),_0x42d68b[_0x3d13b5('0x119')]('DROP\x20TABLE\x20IF\x20EXISTS\x20tmpFinalProfiles;'),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0xcb')),_0x42d68b[_0x3d13b5('0x119')]('DROP\x20TABLE\x20IF\x20EXISTS\x20tmpCustomResources;'),_0x42d68b[_0x3d13b5('0x119')](_0x3d13b5('0x71')),_0x42d68b['query'](_0x3d13b5('0xcf')),_0x42d68b['final'](_0x5a30fc);});},'down':function(){}};
\ No newline at end of file
+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
git://repos.xcallymotion.com / motion-next.git / blobdiff