1 'use strict';const a1136_0x382c=['CREATE\x20TABLE\x20`user_profiles`\x20(','\x20\x20INNER\x20JOIN\x20user_has_openchannel_accounts\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20701\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20sms_queues\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','\x20\x20SELECT\x20userId,\x20permissions,\x20null',')\x20ENGINE=InnoDB\x20DEFAULT\x20CHARSET=utf8;','3373UhhsFI','\x20\x20\x20\x20\x20\x20CASE','\x20\x20WHERE\x20x.sectionId\x20=\x20601;','ON\x20UPDATE\x20CASCADE','\x20\x20(','\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\x20FROM\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\x20\x20\x20GROUP\x20BY\x20resourceId,\x20sectionId','\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=\x20100\x20THEN\x20\x27Dashboards\x27','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(1301,\x201302,\x201303,\x201305,\x201306,\x201307,\x201308)\x20THEN\x20\x27Integrations\x27','\x20\x20ORDER\x20BY\x20GROUP_CONCAT(userId);','\x20\x20WHERE\x20name\x20in\x20(\x27Plugins\x27,\x20\x27CustomDashboards\x27);','\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\x20FROM\x20user_profile_has_sections\x20x','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20302\x20THEN\x20\x27Companies\x27','\x20\x20\x20\x20\x20\x20permissions\x20text\x20not\x20null,','UPDATE\x20tmpNormalizedResources\x20x','\x20\x20\x20\x20userId\x20text,','catch','DELETE\x20t1\x20FROM\x20tmpSections\x20t1,\x20tmpCustomResources\x20t2','\x20\x20SET\x20sectionId\x20=\x201801\x20WHERE\x20sectionId\x20between\x2088889\x20AND\x2099999;','\x20\x20SET\x20u.permissions\x20=\x20t.permissions','\x20\x20PRIMARY\x20KEY\x20(`id`),','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20tally\x20t','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201700\x20THEN\x20\x27DELETE\x27','\x20\x20WHERE\x20x.sectionId\x20=\x20502;','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(1201,\x201202,\x201203)\x20THEN\x20\x27Analytics\x27','INSERT\x20INTO\x20tmpSingleProfiles','INSERT\x20INTO\x20tmpNormalizedResources','info','finally','\x20\x20s.sectionId\x20permission,','\x20\x20WHERE\x20x.sectionId\x20=\x20701;','\x20\x20\x20\x20\x20\x20sectionId\x20int(11)','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20between\x2088889\x20AND\x2099999\x20THEN\x20\x27Plugins\x27','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(801,\x20802,\x20810)\x20THEN\x20\x27Openchannel\x27','CREATE\x20TABLE\x20tmpPermissions','\x20\x20ORDER\x20BY\x20id;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201400\x20THEN\x20\x27Settings\x27','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(1501,\x201502,\x201510)\x20THEN\x20\x27MotionDialer\x27','\x20\x20\x20\x20insertedId\x20int(11),','\x20\x20WHERE\x20role\x20=\x20\x27user\x27\x20and\x20permissions\x20is\x20not\x20null\x20and\x20permissions\x20<>\x20\x27\x27','\x20\x20SELECT\x20x.sectionId,\x20u.MailQueueId,\x20x.userId','\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\x20SELECT\x20x.sectionId,\x20u.FaxQueueId,\x20x.userId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ORDER\x20BY\x20users)\x20b','\x20\x20SET\x20insertedId\x20=\x20(SELECT','\x20\x20SET\x20name\x20=\x20(SELECT','\x20\x20\x20\x20\x20\x20WHEN\x20name\x20=\x20\x27Plugins\x27\x20THEN\x20(sectionId\x20-\x2088888)','\x20DROP\x20TABLE\x20IF\x20EXISTS\x20tally;','INSERT\x20INTO\x20tally\x20(n)','\x20\x20WHERE\x20userId\x20IN\x20(SELECT\x20split.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\x20SUBSTRING_INDEX(SUBSTRING_INDEX(r.userIds,\x20\x27,\x27,\x20t.n),\x20\x27,\x27,\x20-1)\x20userId','\x20\x20SELECT\x20id,\x20permissions,\x20null','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20800\x20THEN\x20\x27DELETE\x27','\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\x20in\x20(1401,\x201402,\x201403,\x201404,\x201405,\x201406,\x201407)\x20THEN\x20\x27DELETE\x27','\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=\x201302\x20THEN\x20\x27SalesforceAccounts\x27','removeColumn','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpFinalProfiles;','\x20\x20SELECT\x20name,\x20category,\x20sectionId,\x20enabled,\x20autoAssociation,\x20\x27red\x27,\x20now(),\x20now(),\x20userProfileId','\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\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201012\x20THEN\x20\x27Variables\x27','\x20\x20UNION','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201006\x20THEN\x20\x27Scheduler\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20name\x20=\x20\x27CustomDashboards\x27\x20THEN\x20(sectionId\x20-\x2099999)','\x20\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\x20SET\x20u.userProfileId\x20=\x201','\x20\x20\x20\x20\x20\x20userIds\x20varchar(255)\x20not\x20null,','\x20\x20WHERE\x20t1.name\x20=\x20t2.name\x20AND\x20t1.userProfileId\x20=\x20t2.userProfileId\x20AND\x20t1.sectionId\x20>\x20t2.sectionId;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20401\x20THEN\x20\x27VoiceQueues\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\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=\x20710\x20THEN\x20\x27Realtime\x27','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpExtractedResources;','\x20\x20FROM\x20tmpNormalizedSections','2815fbDhwj','UPDATE\x20users\x20u,\x20tmpFinalProfiles\x20f','sequelize','\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\x20SELECT\x20CONCAT(\x27Profile_\x27,\x20(SELECT\x20(@cnt\x20:=\x20@cnt\x20+\x201)\x20AS\x20rowNumber','\x20\x20WHERE\x20x.sectionId\x20=\x201501\x20AND\x20q.type\x20=\x20\x27outbound\x27;','\x20\x20SELECT\x20DISTINCT\x20permission,\x20userId,\x200','STRING','\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=\x201601\x20THEN\x20\x27DELETE\x27','\x20\x20);','\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\x20\x20\x20\x20\x20\x20\x20\x20ORDER\x20BY\x20users)\x20b','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x201103\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20square_projects\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','\x20\x20\x20\x20\x20\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\x20in\x20(901,\x20902,\x20910)\x20THEN\x20\x27Fax\x27','\x20\x20FROM\x20tmpSections\x20s','DELETE\x20FROM\x20tmpSections','\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\x20category\x20=\x20(SELECT','users','\x20\x20WHERE\x20x.sectionId\x20=\x20901;','\x20\x20FROM\x20users','then','\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\x20sectionId\x20int(11)\x20not\x20null,','\x20\x20KEY\x20`userProfileId`\x20(`userProfileId`),','\x20\x20`createdAt`\x20datetime\x20NOT\x20NULL,','UPDATE\x20tmpCustomResources','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20510\x20THEN\x20\x27Realtime\x27','\x20\x20\x20\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=\x201008\x20THEN\x20\x27Tags\x27','UPDATE\x20tmpSections','\x20\x20\x20\x20\x20\x20SUBSTRING_INDEX(SUBSTRING_INDEX(s.userId,\x20\x27,\x27,\x20t.n),\x20\x27,\x27,\x20-1)\x20userId','\x20\x20INNER\x20JOIN\x20user_has_sms_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','FOREIGN\x20KEY\x20(`userProfileId`)\x20','removeIndex\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=\x20801\x20THEN\x20\x27OpenchannelQueues\x27','1168850AwJkUe','\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\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=\x20402\x20THEN\x20\x27InboundRoutes\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20>=\x20100000\x20THEN\x20\x27CustomDashboards\x27','\x20\x20WHERE\x20userProfileId\x20is\x20null\x20AND\x20role\x20=\x20\x27user\x27;','resolve','\x20\x20FROM\x20tmpGroupedPermissions','3703452WMjWAO','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(1001,\x201002,\x201003,\x201004,\x201005,\x201006,\x201007,\x201008,\x201009,\x201010,\x201011,\x201012)\x20THEN\x20\x27Tools\x27','\x20\x20SET\x20r.sectionId\x20=\x20s.insertedId','\x20\x20SELECT\x20x.sectionId,\x20u.VoiceQueueId,\x20x.userId','\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=\x201300\x20THEN\x20\x27DELETE\x27','util','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20502\x20THEN\x20\x27ChatWebsites\x27','Changed\x20column\x20%s\x20in\x20table\x20%s','1242476hgLxdU','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201400\x20THEN\x20\x27Settings\x27','\x20\x20\x20\x20autoAssociation\x20tinyint\x20not\x20null,','\x20\x20GROUP\x20BY\x20permissions','\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\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=\x201500\x20THEN\x20\x27DELETE\x27','INSERT\x20INTO\x20tmpNormalizedPermissions','INSERT\x20INTO\x20tmpSharedProfiles','\x20\x20SET\x20profileId\x20=\x20(SELECT\x20(@cnt\x20:=\x20@cnt\x20+\x201)\x20AS\x20rowNumber','prototype','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20901\x20THEN\x20\x27FaxQueues\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201004\x20THEN\x20\x27Intervals\x27','DELETE\x20FROM\x20tmpNormalizedResources','\x20\x20\x20\x20resourceId\x20int(11)\x20not\x20null,','migration','\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)','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\x20FROM\x20(select\x20SUBSTRING_INDEX(SUBSTRING_INDEX(r.userIds,\x20\x27,\x27,\x20t.n),\x20\x27,\x27,\x20-1)\x20userId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201701\x20THEN\x20\x27Projects\x27','\x20\x20WHERE\x20u.id\x20=\x20t.userId;','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpPermissions;','\x20\x20\x20\x20category\x20varchar(255)\x20not\x20null,','\x20\x20SELECT\x20x.sectionId,\x20u.ChatWebsiteId,\x20x.userId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20400\x20THEN\x20\x27DELETE\x27','CREATE\x20TABLE\x20tmpSharedProfiles','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20),','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20603\x20THEN\x20\x27MailSubstatuses\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','515275AvnVpO','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpNormalizedResources;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20602\x20THEN\x20\x27MailAccounts\x27','\x20\x20INNER\x20JOIN\x20voice_queues\x20q\x20ON\x20u.VoiceQueueId\x20=\x20q.id','\x20\x20WHERE\x20u.id\x20=\x20f.userId;','\x20\x20INNER\x20JOIN\x20user_has_square_projects\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20411\x20THEN\x20\x27Realtime\x27','changeColumn','\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\x20sectionId\x20int(11)\x20not\x20null,','userProfileId','\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\x20r.sectionId\x20sectionId','\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`category`\x20varchar(255)\x20NOT\x20NULL,','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20END','stringify','\x20\x20`userProfileId`\x20int(11)\x20DEFAULT\x20NULL,','\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\x20WHERE\x20x.sectionId\x20=\x201103;','CREATE\x20TABLE\x20tally\x20(','\x20\x20END','reportId','\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\x20KEY\x20`compositeIndex`\x20(`resourceId`,`sectionId`),','voice_voicemail','\x20\x20SELECT\x20GROUP_CONCAT(sectionId\x20ORDER\x20BY\x20sectionId),\x20userId','\x20\x20FROM\x20tmpFinalProfiles;','\x20\x20\x20\x20\x20\x20\x20\x20SUBSTRING_INDEX(SUBSTRING_INDEX(fp.permissions,\x20\x27,\x27,\x20tally.n),\x20\x27,\x27,\x20-1)\x20permission,','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20902\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20fax_accounts\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','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\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=\x20910\x20THEN\x20\x27Realtime\x27','\x20\x20`description`\x20varchar(255)\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\x20\x20ORDER\x20BY\x20n)\x20AS\x20split','CREATE\x20TABLE\x20tmpNormalizedUsers','\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','sequence','\x20\x20`autoAssociation`\x20tinyint(1)\x20DEFAULT\x20NULL,','CREATE\x20TABLE\x20tmpFinalProfiles','final','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20CASE','INTEGER','\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','queryInterface','\x20\x20INNER\x20JOIN\x20tmpExtractedResources\x20cr\x20ON\x20cr.userId\x20=\x20s.userId\x20AND\x20cr.sectionId\x20=\x20s.sectionId\x20AND\x20cr.resourceId\x20IS\x20NOT\x20NULL;','UPDATE\x20users\x20u,\x20tmpNormalizedPermissions\x20t','\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\x20WHERE\x20split.userId\x20IN\x20(SELECT\x20*\x20FROM','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\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=\x201201\x20THEN\x20\x27Metrics\x27','\x20\x20SELECT\x20x.sectionId,\x20u.FaxAccountId,\x20x.userId','\x20\x20SELECT\x20*\x20FROM\x20tmpSharedProfiles','\x20\x20\x20\x20\x20\x20profileId\x20int(11)','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20CASE','INSERT\x20INTO\x20user_profile_has_sections\x20(name,\x20category,\x20sectionId,\x20enabled,\x20autoAssociation,\x20crudPermissions,\x20createdAt,\x20updatedAt,\x20userProfileId)','\x20\x20\x20\x20type\x20varchar(255)\x20not\x20null,','\x20\x20\x20\x20\x20\x20resourceId\x20text,','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpSharedProfiles;','\x20\x20`updatedAt`\x20datetime\x20NOT\x20NULL,','\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\x20SELECT\x20x.sectionId,\x20u.SquareProjectId,\x20x.userId','\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)','addIndex','\x20\x20\x20\x20insertedSectionId\x20int(11)\x20not\x20null,','tail','\x20\x20SELECT\x20x.sectionId,\x20u.SmsQueueId,\x20x.userId','\x20\x20KEY\x20`sectionId`\x20(`sectionId`),','\x20\x20\x20\x20\x20\x20END','INSERT\x20INTO\x20tmpExtractedResources','\x20\x20SELECT\x20x.sectionId,\x20u.OpenchannelAccountId,\x20x.userId','\x20\x20SELECT\x20userId,\x20permissions','\x20\x20INNER\x20JOIN\x20user_has_sms_accounts\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20SELECT\x20x.sectionId,\x20u.MailAccountId,\x20x.userId','\x20\x20ORDER\x20BY\x20userId;','addColumn','\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','40276QcYtco','\x20\x20FROM\x20tmpFinalProfiles\x20t','\x20\x20userId\x20int(11)','\x20\x20\x20\x20\x20\x20permissions\x20text\x20not\x20null','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20902\x20THEN\x20\x27FaxAccounts\x27','\x20\x20INNER\x20JOIN\x20user_has_chat_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201001\x20THEN\x20\x27CannedAnswers\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201003\x20THEN\x20\x27CustomDashboards\x27','\x20\x20WHERE\x20x.sectionId\x20=\x20801;','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201010\x20THEN\x20\x27Triggers\x27','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpNormalizedUsers;','\x20\x20INNER\x20JOIN\x20user_has_mail_accounts\x20u\x20ON\x20u.UserId\x20=\x20x.userId','renameColumn','\x20\x20SET','\x20\x20SELECT\x20\x27\x27,\x20\x27\x27,\x20permission,\x201,\x200,\x20profileId,\x20null,\x20userId','CREATE\x20TABLE\x20tmpSections','CREATE\x20TABLE\x20`user_profile_has_sections`\x20(','\x20\x20WHERE\x20x.sectionId\x20=\x20501;','CREATE\x20TABLE\x20tmpNormalizedPermissions','UPDATE\x20users\x20u','INSERT\x20INTO\x20tmpCustomResources','\x20\x20UNIQUE\x20KEY\x20`name`\x20(`name`)','\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\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHERE\x20position(\x27,\x27\x20in\x20b.users)\x20=\x200))','query\x20%s','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ELSE\x20\x27\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\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=\x20500\x20THEN\x20\x27DELETE\x27','enqueue','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20406\x20THEN\x20\x27Voicemails\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20407\x20THEN\x20\x27MusicOnHolds\x27','TRUNCATE\x20TABLE\x20tmpPermissions;','analytics_extracted_reports','\x20\x20n\x20INT\x20NOT\x20NULL\x20AUTO_INCREMENT\x20PRIMARY\x20KEY','\x20\x20INNER\x20JOIN\x20user_has_mail_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','table\x20dropped\x20%s','\x20\x20SELECT\x20name,\x20resourceId,\x20type,\x20now(),\x20now(),\x20insertedSectionId','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpCustomResources;','\x20\x20\x20\x20\x20\x20insertedSectionId\x20int(11)\x20not\x20null,','\x20\x20CONSTRAINT\x20`user_profile_has_resources_ibfk_1`\x20FOREIGN\x20KEY\x20(`sectionId`)\x20REFERENCES\x20`user_profile_has_sections`\x20(`id`)\x20ON\x20DELETE\x20CASCADE\x20ON\x20UPDATE\x20CASCADE','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(301,\x20302,\x20303,\x20304)\x20THEN\x20\x27ContactManager\x27','\x20\x20FROM\x20(SELECT','\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\x20SET\x20autoAssociation\x20=\x201\x20WHERE\x20sectionId\x20=\x20100;','\x20\x20INNER\x20JOIN\x20user_has_fax_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=\x201103\x20THEN\x20\x27SquareProjects\x27','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20900\x20THEN\x20\x27DELETE\x27','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpNormalizedSections;','\x20\x20WHERE\x20x.sectionId\x20=\x20602;','\x20\x20`name`\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=\x20409\x20THEN\x20\x27ChanSpies\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\x20SELECT\x20GROUP_CONCAT(userId),\x20permissions,\x20null','\x20\x20`crudPermissions`\x20varchar(255)\x20DEFAULT\x20NULL,','\x20\x20INNER\x20JOIN\x20user_has_voice_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','INSERT\x20INTO\x20tmpFinalProfiles','\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\x20SELECT\x20GROUP_CONCAT(id),\x20permissions,\x20null',',(SELECT\x200\x20AS\x20N\x20UNION\x20ALL\x20SELECT\x201\x20UNION\x20ALL\x20SELECT\x202\x20UNION\x20ALL\x20SELECT\x203\x20UNION\x20ALL\x20SELECT\x204\x20UNION\x20ALL\x20SELECT\x205\x20UNION\x20ALL\x20SELECT\x206\x20UNION\x20ALL\x20SELECT\x207\x20UNION\x20ALL\x20SELECT\x208\x20UNION\x20ALL\x20SELECT\x209)\x20d','151PAQPIE','\x20\x20FROM\x20tmpNormalizedUsers\x20x','\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\x20WHEN\x20sectionId\x20=\x20300\x20THEN\x20\x27DELETE\x27','\x20\x20WHERE\x20r.name\x20=\x20s.name\x20AND\x20r.userProfileId\x20=\x20s.userProfileId;','\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','query','\x20\x20`sectionId`\x20int(11)\x20DEFAULT\x20NULL,','\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20801\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20openchannel_queues\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)','INSERT\x20INTO\x20tmpPermissions','\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)','DROP\x20TABLE\x20IF\x20EXISTS\x20tmpSingleProfiles;','CREATE\x20TABLE\x20tmpResources','VALUES\x20(\x27Default\x27,\x20\x27red\x27,\x20NULL,\x20NOW(),\x20NOW());','\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\x20WHERE\x20x.sectionId\x20=\x20802;','\x20\x20\x20\x20\x20\x20type\x20varchar(255)\x20not\x20null,','\x20\x20INNER\x20JOIN\x20user_has_openchannel_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId','CREATE\x20TABLE\x20tmpNormalizedResources','\x20\x20\x20\x20name\x20varchar(255)\x20not\x20null,','\x20\x20\x20\x20permissions\x20text\x20not\x20null,','\x20\x20`crudPermissions`\x20varchar(255)\x20NOT\x20NULL\x20DEFAULT\x20\x27r\x27,','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20303\x20THEN\x20\x27Contacts\x27','UPDATE\x20tmpCustomResources\x20r,\x20tmpSections\x20s',',(SELECT\x200\x20AS\x20N\x20UNION\x20ALL\x20SELECT\x201\x20UNION\x20ALL\x20SELECT\x202\x20UNION\x20ALL\x20SELECT\x203\x20UNION\x20ALL\x20SELECT\x204\x20UNION\x20ALL\x20SELECT\x205\x20UNION\x20ALL\x20SELECT\x206\x20UNION\x20ALL\x20SELECT\x207\x20UNION\x20ALL\x20SELECT\x208\x20UNION\x20ALL\x20SELECT\x209)\x20e','\x20\x20\x20\x20t.permissions\x20permissions','\x20\x20SELECT\x20*\x20FROM\x20tmpSingleProfiles;',',(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\x20ORDER\x20BY\x20n)\x20AS\x20split;','removeIndex','\x20\x20SELECT\x20\x27\x27,\x20insertedId,\x20name,\x20sectionId,\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\x20INNER\x20JOIN\x20tmpPermissions\x20r\x20on\x20CHAR_LENGTH(r.userIds)\x20-\x20CHAR_LENGTH(REPLACE(r.userIds,\x20\x27,\x27,\x20\x27\x27))\x20>=\x20t.n-1','\x20\x20\x20\x20resourceId\x20text','\x20\x20\x20\x20enabled\x20tinyint\x20not\x20null,','REFERENCES\x20user_profiles(`id`)\x20','inspect','\x20\x20FROM\x20tmpNormalizedResources;','337EGhUyj','\x20\x20SELECT\x20*','\x20\x20SELECT\x20\x27\x27,\x20resourceId,\x20type,\x20insertedSectionId,\x20sectionId','\x20\x20SET\x20u.userProfileId\x20=\x20f.profileId','dropTable','\x20\x20SELECT\x20x.sectionId,\x20u.OpenchannelQueueId,\x20x.userId','\x20\x20SET\x20sectionId\x20=\x201003\x20WHERE\x20sectionId\x20>=\x20100000;','\x20\x20`resourceId`\x20int(11)\x20NOT\x20NULL,','\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\x20SUBSTRING_INDEX(fp.userId,\x20\x27,\x27,\x201)\x20userId','UPDATE\x20tmpSections\x20s','\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(501,\x20502,\x20510)\x20THEN\x20\x27Chat\x27','INSERT\x20INTO\x20tmpNormalizedUsers','\x20\x20INNER\x20JOIN\x20user_has_chat_websites\x20u\x20ON\x20u.UserId\x20=\x20x.userId','CREATE\x20TABLE\x20tmpCustomResources','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20CASE','\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','INSERT\x20INTO\x20tmpSections','\x20\x20CROSS\x20JOIN\x20(SELECT\x20@cnt\x20:=\x200)\x20as\x20dummy\x20LIMIT\x201)),\x20\x27red\x27,\x20now(),\x20now()','20OpvKrF','\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\x20`type`\x20varchar(255)\x20NOT\x20NULL,','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHERE\x20POSITION(\x27,\x27\x20in\x20r.userIds)\x20>\x200','\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20410\x20THEN\x20\x27VoicePrefixes\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','CREATE\x20TABLE\x20tmpGroupedPermissions','Removed\x20column\x20%s\x20from\x20%s','\x20\x20\x20\x20SUBSTRING_INDEX(SUBSTRING_INDEX(t.userIds,\x20\x27,\x27,\x20tally.n),\x20\x27,\x27,\x20-1)\x20userId,'];const a1136_0x46c9=function(_0x338850,_0x1d2f45){_0x338850=_0x338850-0x14b;let _0x382cd2=a1136_0x382c[_0x338850];return _0x382cd2;};const a1136_0x18723c=a1136_0x46c9;(function(_0x2f4fc2,_0x482890){const _0x5c6c91=a1136_0x46c9;while(!![]){try{const _0x2e25d4=parseInt(_0x5c6c91(0x22c))*-parseInt(_0x5c6c91(0x1be))+parseInt(_0x5c6c91(0x252))+-parseInt(_0x5c6c91(0x280))+-parseInt(_0x5c6c91(0x263))+parseInt(_0x5c6c91(0x1df))*-parseInt(_0x5c6c91(0x199))+-parseInt(_0x5c6c91(0x15e))*parseInt(_0x5c6c91(0x1d1))+parseInt(_0x5c6c91(0x25a));if(_0x2e25d4===_0x482890)break;else _0x2f4fc2['push'](_0x2f4fc2['shift']());}catch(_0x573b6f){_0x2f4fc2['push'](_0x2f4fc2['shift']());}}}(a1136_0x382c,0xcfc6d));const util=require(a1136_0x18723c(0x260)),logger=require('@config/logger')(a1136_0x18723c(0x272)),Sequence=function(){};Sequence[a1136_0x18723c(0x26d)][a1136_0x18723c(0x17a)]=function(_0x2d6d2f){const _0x6cfa62=a1136_0x18723c;this[_0x6cfa62(0x152)]=this[_0x6cfa62(0x152)]?this[_0x6cfa62(0x152)][_0x6cfa62(0x1fe)](_0x2d6d2f):_0x2d6d2f();};const Migration=function(_0x3ac2bd){const _0x1c63b3=a1136_0x18723c;this[_0x1c63b3(0x2ac)]=_0x3ac2bd,this[_0x1c63b3(0x2a5)]=new Sequence();};Migration[a1136_0x18723c(0x26d)]['changeColumn']=function(_0x40b2db,_0xe71b30,_0x46c5d3){const _0x210602=a1136_0x18723c,_0x20ad48=this;this[_0x210602(0x2a5)]['enqueue'](function(){const _0x45a94f=_0x210602;return _0x20ad48[_0x45a94f(0x2ac)][_0x45a94f(0x287)](_0x40b2db,_0xe71b30,_0x46c5d3)['then'](function(){const _0xb79883=_0x45a94f;logger[_0xb79883(0x1fd)](_0xb79883(0x262),_0xe71b30,_0x40b2db);})[_0x45a94f(0x1f2)](function(_0x5ef86b){const _0x203fcb=_0x45a94f;logger['info'](JSON[_0x203fcb(0x290)](_0x5ef86b));});});},Migration[a1136_0x18723c(0x26d)][a1136_0x18723c(0x15c)]=function(_0x47272e,_0x47c502,_0x508d4f){const _0x5be6b5=a1136_0x18723c,_0x4f5196=this;this[_0x5be6b5(0x2a5)]['enqueue'](function(){const _0x437f49=_0x5be6b5;return _0x4f5196[_0x437f49(0x2ac)][_0x437f49(0x15c)](_0x47272e,_0x47c502,_0x508d4f)[_0x437f49(0x243)](function(){logger['info']('Added\x20column\x20%s\x20to\x20%s',_0x47c502,_0x47272e);})[_0x437f49(0x1f2)](function(_0x49d634){const _0x39cfee=_0x437f49;logger[_0x39cfee(0x1fd)](JSON[_0x39cfee(0x290)](_0x49d634));});});},Migration['prototype'][a1136_0x18723c(0x1c2)]=function(_0x9de140){const _0x46cc78=a1136_0x18723c,_0x3bc070=this;this[_0x46cc78(0x2a5)][_0x46cc78(0x17a)](function(){const _0x8d590c=_0x46cc78;return _0x3bc070[_0x8d590c(0x2ac)][_0x8d590c(0x1c2)](_0x9de140,{'force':!![]})['then'](function(){const _0x27d0e6=_0x8d590c;logger['info'](_0x27d0e6(0x181),_0x9de140);})[_0x8d590c(0x1f2)](function(_0x2c4093){const _0x413a2a=_0x8d590c;logger[_0x413a2a(0x1fd)](JSON['stringify'](_0x2c4093));});});},Migration[a1136_0x18723c(0x26d)][a1136_0x18723c(0x150)]=function(_0xe3b3ba,_0x26b928,_0x4918c3){const _0x320ae2=a1136_0x18723c,_0x331862=this;this[_0x320ae2(0x2a5)][_0x320ae2(0x17a)](function(){const _0x3a4872=_0x320ae2;return _0x331862[_0x3a4872(0x2ac)][_0x3a4872(0x150)](_0xe3b3ba,_0x26b928,{'indexName':_0x4918c3})['then'](function(){const _0xc09597=_0x3a4872;logger[_0xc09597(0x1fd)]('addIndex\x20%s\x20%s\x20%s',_0xe3b3ba,_0x26b928['join'](','),_0x4918c3);})[_0x3a4872(0x1f2)](function(_0x1eb2dd){const _0x3e9f18=_0x3a4872;logger[_0x3e9f18(0x1fd)](JSON[_0x3e9f18(0x290)](_0x1eb2dd));});});},Migration['prototype']['removeIndex']=function(_0x30a1ee,_0x63be14){const _0xb297ba=a1136_0x18723c,_0x585e1c=this;this[_0xb297ba(0x2a5)][_0xb297ba(0x17a)](function(){const _0x2df903=_0xb297ba;return _0x585e1c[_0x2df903(0x2ac)][_0x2df903(0x1b6)](_0x30a1ee,_0x63be14)[_0x2df903(0x243)](function(){const _0x295938=_0x2df903;logger[_0x295938(0x1fd)](_0x295938(0x250),_0x30a1ee,_0x63be14);})[_0x2df903(0x1f2)](function(_0x55ddb0){const _0x4793a7=_0x2df903;logger[_0x4793a7(0x1fd)](JSON[_0x4793a7(0x290)](_0x55ddb0));});});},Migration['prototype'][a1136_0x18723c(0x19f)]=function(_0x52108e){const _0x571d11=a1136_0x18723c,_0x169ab8=this;this['sequence'][_0x571d11(0x17a)](function(){const _0x1b3a93=_0x571d11;return _0x169ab8[_0x1b3a93(0x2ac)][_0x1b3a93(0x22e)][_0x1b3a93(0x19f)](_0x52108e)['then'](function(){const _0x37e458=_0x1b3a93;logger['info'](_0x37e458(0x176),_0x52108e);})[_0x1b3a93(0x1f2)](function(_0x79a518){const _0x5057e1=_0x1b3a93;logger[_0x5057e1(0x1fd)](JSON[_0x5057e1(0x290)](_0x79a518));});});},Migration[a1136_0x18723c(0x26d)][a1136_0x18723c(0x21b)]=function(_0x316c19,_0x13a9fb){const _0x87d378=a1136_0x18723c,_0x2233b0=this;this['sequence'][_0x87d378(0x17a)](function(){const _0xde98e=_0x87d378;return _0x2233b0[_0xde98e(0x2ac)][_0xde98e(0x21b)](_0x316c19,_0x13a9fb)[_0xde98e(0x243)](function(){const _0x2c5097=_0xde98e;logger[_0x2c5097(0x1fd)](_0x2c5097(0x1d8),_0x13a9fb,_0x316c19);})['catch'](function(_0x30ae2a){const _0x278e4d=_0xde98e;logger[_0x278e4d(0x1fd)](util[_0x278e4d(0x1bc)](_0x30ae2a,{'showHidden':![],'depth':null}));});});},Migration['prototype'][a1136_0x18723c(0x16a)]=function(_0x236454,_0x3eed26,_0x343756){const _0x473c1c=a1136_0x18723c,_0x266272=this;this[_0x473c1c(0x2a5)][_0x473c1c(0x17a)](function(){const _0x28e01f=_0x473c1c;return _0x266272[_0x28e01f(0x2ac)][_0x28e01f(0x16a)](_0x236454,_0x3eed26,_0x343756)['then'](function(){const _0x54e599=_0x28e01f;logger[_0x54e599(0x1fd)]('Renamed\x20column\x20from\x20%s\x20to\x20%s\x20on\x20%s',_0x3eed26,_0x343756,_0x236454);})[_0x28e01f(0x1f2)](function(_0x56012e){const _0x20170c=_0x28e01f;logger['info'](util[_0x20170c(0x1bc)](_0x56012e,{'showHidden':![],'depth':null}));});});},Migration[a1136_0x18723c(0x26d)][a1136_0x18723c(0x2a8)]=function(_0x33fc41){const _0x139e64=a1136_0x18723c;this[_0x139e64(0x2a5)][_0x139e64(0x17a)](function(){return _0x33fc41();});},module['exports']={'up':function(_0x2db9aa,_0x1ada76){return new Promise(function(_0x369f66){const _0xbe2bdb=a1136_0x46c9,_0x1b1ee1=new Migration(_0x2db9aa);_0x1b1ee1[_0xbe2bdb(0x15c)](_0xbe2bdb(0x17e),_0xbe2bdb(0x296),{'type':_0x1ada76[_0xbe2bdb(0x2aa)]}),_0x1b1ee1[_0xbe2bdb(0x15c)]('analytics_extracted_reports','reportType',{'type':_0x1ada76[_0xbe2bdb(0x233)]}),_0x1b1ee1[_0xbe2bdb(0x15c)](_0xbe2bdb(0x240),_0xbe2bdb(0x28a),{'type':_0x1ada76['INTEGER']}),_0x1b1ee1[_0xbe2bdb(0x21b)](_0xbe2bdb(0x299),'name'),_0x1b1ee1['query'](_0xbe2bdb(0x1da)+'\x20\x20`id`\x20int(11)\x20NOT\x20NULL\x20AUTO_INCREMENT,'+_0xbe2bdb(0x18f)+_0xbe2bdb(0x1ae)+_0xbe2bdb(0x2a1)+_0xbe2bdb(0x247)+_0xbe2bdb(0x14c)+_0xbe2bdb(0x1f6)+_0xbe2bdb(0x173)+_0xbe2bdb(0x1de)),_0x1b1ee1[_0xbe2bdb(0x19f)]('INSERT\x20INTO\x20`user_profiles`\x20(`name`,\x20`crudPermissions`,\x20`description`,\x20`createdAt`,\x20`updatedAt`)'+_0xbe2bdb(0x1a6)),_0x1b1ee1[_0xbe2bdb(0x19f)]('ALTER\x20TABLE\x20`users`\x20'+_0xbe2bdb(0x29e)+_0xbe2bdb(0x24f)+_0xbe2bdb(0x1bb)+_0xbe2bdb(0x1e2)),_0x1b1ee1['query'](_0xbe2bdb(0x16e)+'\x20\x20`id`\x20int(11)\x20NOT\x20NULL\x20AUTO_INCREMENT,'+_0xbe2bdb(0x18f)+_0xbe2bdb(0x28e)+'\x20\x20`sectionId`\x20int(11)\x20NOT\x20NULL,'+'\x20\x20`enabled`\x20tinyint(1)\x20DEFAULT\x20NULL,'+_0xbe2bdb(0x2a6)+_0xbe2bdb(0x193)+_0xbe2bdb(0x247)+_0xbe2bdb(0x14c)+_0xbe2bdb(0x291)+_0xbe2bdb(0x1f6)+_0xbe2bdb(0x246)+'\x20\x20KEY\x20`compositeIndex`\x20(`sectionId`,`userProfileId`),'+'\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'+_0xbe2bdb(0x1de)),_0x1b1ee1[_0xbe2bdb(0x19f)]('CREATE\x20TABLE\x20`user_profile_has_resources`\x20('+'\x20\x20`id`\x20int(11)\x20NOT\x20NULL\x20AUTO_INCREMENT,'+'\x20\x20`name`\x20varchar(255)\x20NOT\x20NULL,'+_0xbe2bdb(0x1c5)+_0xbe2bdb(0x1d3)+'\x20\x20`createdAt`\x20datetime\x20NOT\x20NULL,'+_0xbe2bdb(0x14c)+_0xbe2bdb(0x1a0)+_0xbe2bdb(0x1f6)+_0xbe2bdb(0x154)+_0xbe2bdb(0x298)+_0xbe2bdb(0x185)+_0xbe2bdb(0x1de)),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x294)+_0xbe2bdb(0x17f)+');'),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x212)+'SELECT\x20NULL\x20FROM'+'(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'+_0xbe2bdb(0x1b4)+',(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'+_0xbe2bdb(0x198)+_0xbe2bdb(0x1b1)+';'),_0x1b1ee1['query'](_0xbe2bdb(0x204)+_0xbe2bdb(0x1e3)+_0xbe2bdb(0x225)+_0xbe2bdb(0x1ef)+'\x20\x20\x20\x20\x20\x20profileId\x20int(11)'+_0xbe2bdb(0x236)),_0x1b1ee1['query'](_0xbe2bdb(0x1a2)+_0xbe2bdb(0x215)+_0xbe2bdb(0x242)+_0xbe2bdb(0x209)+_0xbe2bdb(0x205)),_0x1b1ee1[_0xbe2bdb(0x19f)]('CREATE\x20TABLE\x20tmpNormalizedSections'+_0xbe2bdb(0x1e3)+_0xbe2bdb(0x289)+_0xbe2bdb(0x1f1)+_0xbe2bdb(0x1b9)+_0xbe2bdb(0x236)),_0x1b1ee1['query']('INSERT\x20INTO\x20tmpNormalizedSections'+_0xbe2bdb(0x232)+_0xbe2bdb(0x187)+_0xbe2bdb(0x25e)+'\x20\x20\x20\x20p.userIds\x20userId'+'\x20\x20FROM\x20tally\x20INNER\x20JOIN\x20tmpPermissions\x20p\x20ON\x20CHAR_LENGTH(p.permissions)\x20-\x20CHAR_LENGTH(REPLACE(p.permissions,\x20\x27,\x27,\x20\x27\x27))\x20>=\x20tally.n-1'+'\x20\x20ORDER\x20BY\x20n)\x20AS\x20split;'),_0x1b1ee1['query'](_0xbe2bdb(0x170)+_0xbe2bdb(0x1e3)+_0xbe2bdb(0x1ad)+_0xbe2bdb(0x267)+_0xbe2bdb(0x236)),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x26a)+_0xbe2bdb(0x29a)+_0xbe2bdb(0x22b)+'\x20\x20GROUP\x20BY\x20userId;'),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x2ae)+_0xbe2bdb(0x1f5)+_0xbe2bdb(0x277)),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x17d)),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x1a2)+_0xbe2bdb(0x197)+'\x20\x20FROM\x20users'+_0xbe2bdb(0x209)+_0xbe2bdb(0x266)+'\x20\x20ORDER\x20BY\x20GROUP_CONCAT(id);'),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x2a3)+'\x20\x20('+_0xbe2bdb(0x289)+_0xbe2bdb(0x1f1)+'\x20\x20\x20\x20resourceId\x20text'+_0xbe2bdb(0x236)),_0x1b1ee1['query'](_0xbe2bdb(0x1ca)+_0xbe2bdb(0x219)+_0xbe2bdb(0x187)+_0xbe2bdb(0x1ff)+_0xbe2bdb(0x24d)+'\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'+_0xbe2bdb(0x1b5)),_0x1b1ee1[_0xbe2bdb(0x19f)]('CREATE\x20TABLE\x20tmpExtractedResources\x20('+_0xbe2bdb(0x245)+'\x20\x20resourceId\x20int(11),'+_0xbe2bdb(0x160)+_0xbe2bdb(0x236)),_0x1b1ee1['query']('INSERT\x20INTO\x20tmpExtractedResources'+_0xbe2bdb(0x25d)+_0xbe2bdb(0x19a)+_0xbe2bdb(0x194)+_0xbe2bdb(0x283)+'\x20\x20WHERE\x20x.sectionId\x20=\x20401\x20AND\x20q.type\x20=\x20\x27inbound\x27;'),_0x1b1ee1[_0xbe2bdb(0x19f)]('INSERT\x20INTO\x20tmpExtractedResources'+'\x20\x20SELECT\x20x.sectionId,\x20u.ChatQueueId,\x20x.userId'+_0xbe2bdb(0x19a)+_0xbe2bdb(0x163)+_0xbe2bdb(0x16f)),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x156)+_0xbe2bdb(0x27a)+_0xbe2bdb(0x19a)+_0xbe2bdb(0x1cb)+_0xbe2bdb(0x1f9)),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x156)+_0xbe2bdb(0x20a)+_0xbe2bdb(0x19a)+_0xbe2bdb(0x180)+_0xbe2bdb(0x1e1)),_0x1b1ee1['query']('INSERT\x20INTO\x20tmpExtractedResources'+_0xbe2bdb(0x15a)+_0xbe2bdb(0x19a)+_0xbe2bdb(0x169)+_0xbe2bdb(0x18e)),_0x1b1ee1['query']('INSERT\x20INTO\x20tmpExtractedResources'+_0xbe2bdb(0x153)+_0xbe2bdb(0x19a)+_0xbe2bdb(0x24e)+_0xbe2bdb(0x200)),_0x1b1ee1[_0xbe2bdb(0x19f)]('INSERT\x20INTO\x20tmpExtractedResources'+'\x20\x20SELECT\x20x.sectionId,\x20u.SmsAccountId,\x20x.userId'+_0xbe2bdb(0x19a)+_0xbe2bdb(0x159)+'\x20\x20WHERE\x20x.sectionId\x20=\x20702;'),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x156)+_0xbe2bdb(0x1c3)+_0xbe2bdb(0x19a)+_0xbe2bdb(0x1aa)+_0xbe2bdb(0x166)),_0x1b1ee1['query']('INSERT\x20INTO\x20tmpExtractedResources'+_0xbe2bdb(0x157)+_0xbe2bdb(0x19a)+_0xbe2bdb(0x1db)+_0xbe2bdb(0x1a8)),_0x1b1ee1[_0xbe2bdb(0x19f)]('INSERT\x20INTO\x20tmpExtractedResources'+_0xbe2bdb(0x20c)+_0xbe2bdb(0x19a)+'\x20\x20INNER\x20JOIN\x20user_has_fax_queues\x20u\x20ON\x20u.UserId\x20=\x20x.userId'+_0xbe2bdb(0x241)),_0x1b1ee1[_0xbe2bdb(0x19f)]('INSERT\x20INTO\x20tmpExtractedResources'+_0xbe2bdb(0x2b3)+_0xbe2bdb(0x19a)+_0xbe2bdb(0x18a)+'\x20\x20WHERE\x20x.sectionId\x20=\x20902;'),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x156)+_0xbe2bdb(0x14e)+'\x20\x20FROM\x20tmpNormalizedUsers\x20x'+_0xbe2bdb(0x285)+_0xbe2bdb(0x293)),_0x1b1ee1['query'](_0xbe2bdb(0x156)+_0xbe2bdb(0x25d)+_0xbe2bdb(0x19a)+_0xbe2bdb(0x194)+_0xbe2bdb(0x283)+_0xbe2bdb(0x231)),_0x1b1ee1['query'](_0xbe2bdb(0x1d7)+_0xbe2bdb(0x1e3)+'\x20\x20\x20\x20\x20\x20userId\x20text\x20not\x20null,'+_0xbe2bdb(0x161)+_0xbe2bdb(0x236)),_0x1b1ee1[_0xbe2bdb(0x19f)]('INSERT\x20INTO\x20tmpGroupedPermissions'+_0xbe2bdb(0x158)+'\x20\x20FROM\x20(SELECT'+_0xbe2bdb(0x1d9)+_0xbe2bdb(0x1b2)+'\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\x20ORDER\x20BY\x20n)\x20AS\x20split;'),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x27c)+_0xbe2bdb(0x1e3)+_0xbe2bdb(0x225)+'\x20\x20\x20\x20\x20\x20permissions\x20text\x20not\x20null,'+_0xbe2bdb(0x2b5)+'\x20\x20);'),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x26b)+_0xbe2bdb(0x192)+_0xbe2bdb(0x259)+'\x20\x20WHERE\x20userId\x20NOT\x20IN\x20(SELECT\x20split.userId'+_0xbe2bdb(0x23e)+_0xbe2bdb(0x214)+_0xbe2bdb(0x1f7)+_0xbe2bdb(0x1b8)+'\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'+_0xbe2bdb(0x2a2)+'\x20\x20WHERE\x20split.userId\x20IN\x20(SELECT\x20*\x20FROM'+_0xbe2bdb(0x27f)+_0xbe2bdb(0x29f)+_0xbe2bdb(0x228)+_0xbe2bdb(0x238)+'\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))'+_0xbe2bdb(0x266)+_0xbe2bdb(0x1ea)),_0x1b1ee1[_0xbe2bdb(0x19f)]('CREATE\x20TABLE\x20tmpSingleProfiles'+_0xbe2bdb(0x1e3)+'\x20\x20\x20\x20\x20\x20userId\x20text\x20not\x20null,'+_0xbe2bdb(0x1ef)+_0xbe2bdb(0x2b5)+_0xbe2bdb(0x236)),_0x1b1ee1['query'](_0xbe2bdb(0x1fb)+_0xbe2bdb(0x1dd)+'\x20\x20FROM\x20tmpGroupedPermissions'+_0xbe2bdb(0x213)+_0xbe2bdb(0x275)+_0xbe2bdb(0x191)+_0xbe2bdb(0x1d4)+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ORDER\x20BY\x20n)\x20as\x20split'+_0xbe2bdb(0x2b0)+'\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'+_0xbe2bdb(0x268)+_0xbe2bdb(0x1e6)+_0xbe2bdb(0x20d)+_0xbe2bdb(0x175)+_0xbe2bdb(0x15b)),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x2a7)+_0xbe2bdb(0x1e3)+_0xbe2bdb(0x234)+_0xbe2bdb(0x1ef)+_0xbe2bdb(0x2b5)+_0xbe2bdb(0x236)),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x195)+_0xbe2bdb(0x2b4)+_0xbe2bdb(0x220)+_0xbe2bdb(0x1b3)),_0x1b1ee1['query']('INSERT\x20INTO\x20user_profiles\x20(name,\x20crudPermissions,\x20createdAt,\x20updatedAt)'+_0xbe2bdb(0x230)+_0xbe2bdb(0x15f)+_0xbe2bdb(0x1d0)+_0xbe2bdb(0x29b)),_0x1b1ee1[_0xbe2bdb(0x19f)]('UPDATE\x20tmpFinalProfiles'+_0xbe2bdb(0x26c)+'\x20\x20FROM\x20user_profiles\x20u'+_0xbe2bdb(0x254)),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x16d)+_0xbe2bdb(0x1e3)+_0xbe2bdb(0x1ac)+_0xbe2bdb(0x279)+'\x20\x20\x20\x20sectionId\x20int(11)\x20not\x20null,'+_0xbe2bdb(0x1ba)+_0xbe2bdb(0x265)+_0xbe2bdb(0x24a)+_0xbe2bdb(0x208)+'\x20\x20\x20\x20userId\x20text'+'\x20\x20);'),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x1cf)+_0xbe2bdb(0x16c)+_0xbe2bdb(0x187)+'\x20\x20\x20\x20\x20\x20\x20\x20fp.profileId\x20profileId,'+_0xbe2bdb(0x29c)+_0xbe2bdb(0x1c7)+'\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20tally'+_0xbe2bdb(0x1d6)+'\x20\x20\x20\x20\x20\x20\x20\x20ORDER\x20BY\x20n)\x20AS\x20split;'),_0x1b1ee1[_0xbe2bdb(0x19f)]('UPDATE\x20tmpSections'+_0xbe2bdb(0x16b)+'\x20\x20\x20\x20\x20\x20name\x20=\x20(SELECT'+_0xbe2bdb(0x1cd)+_0xbe2bdb(0x1e8)+_0xbe2bdb(0x2a4)+'\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'+_0xbe2bdb(0x15d)+_0xbe2bdb(0x23a)+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20203\x20THEN\x20\x27Telephones\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20204\x20THEN\x20\x27Teams\x27'+_0xbe2bdb(0x19c)+'\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'+_0xbe2bdb(0x1ee)+_0xbe2bdb(0x1af)+'\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'+_0xbe2bdb(0x27b)+_0xbe2bdb(0x227)+_0xbe2bdb(0x255)+'\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'+_0xbe2bdb(0x2af)+_0xbe2bdb(0x244)+_0xbe2bdb(0x17b)+_0xbe2bdb(0x17c)+'\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'+_0xbe2bdb(0x190)+_0xbe2bdb(0x1d5)+_0xbe2bdb(0x286)+_0xbe2bdb(0x179)+_0xbe2bdb(0x1ce)+_0xbe2bdb(0x261)+_0xbe2bdb(0x249)+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20600\x20THEN\x20\x27DELETE\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20601\x20THEN\x20\x27MailQueues\x27'+_0xbe2bdb(0x282)+_0xbe2bdb(0x27e)+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20610\x20THEN\x20\x27Realtime\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20700\x20THEN\x20\x27DELETE\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20701\x20THEN\x20\x27SmsQueues\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20702\x20THEN\x20\x27SmsAccounts\x27'+_0xbe2bdb(0x229)+_0xbe2bdb(0x216)+_0xbe2bdb(0x251)+'\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'+_0xbe2bdb(0x297)+_0xbe2bdb(0x18c)+_0xbe2bdb(0x26e)+_0xbe2bdb(0x162)+_0xbe2bdb(0x2a0)+'\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'+_0xbe2bdb(0x164)+'\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'+_0xbe2bdb(0x165)+_0xbe2bdb(0x26f)+'\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'+_0xbe2bdb(0x221)+_0xbe2bdb(0x2ab)+_0xbe2bdb(0x24b)+_0xbe2bdb(0x188)+_0xbe2bdb(0x167)+'\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'+_0xbe2bdb(0x21f)+_0xbe2bdb(0x28b)+'\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'+_0xbe2bdb(0x288)+_0xbe2bdb(0x18b)+'\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'+_0xbe2bdb(0x2b2)+_0xbe2bdb(0x174)+'\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'+_0xbe2bdb(0x25f)+_0xbe2bdb(0x22f)+_0xbe2bdb(0x21a)+_0xbe2bdb(0x178)+_0xbe2bdb(0x253)+_0xbe2bdb(0x2b1)+'\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'+_0xbe2bdb(0x223)+_0xbe2bdb(0x206)+_0xbe2bdb(0x218)+_0xbe2bdb(0x269)+_0xbe2bdb(0x20b)+_0xbe2bdb(0x1d2)+'\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'+_0xbe2bdb(0x1e4)+_0xbe2bdb(0x235)+_0xbe2bdb(0x1f8)+_0xbe2bdb(0x276)+_0xbe2bdb(0x202)+_0xbe2bdb(0x256)+_0xbe2bdb(0x177)+_0xbe2bdb(0x28f)+_0xbe2bdb(0x27d)+_0xbe2bdb(0x23f)+_0xbe2bdb(0x1e0)+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x20100\x20THEN\x20\x27Dashboards\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20>=\x20100000\x20THEN\x20\x27Tools\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(202,\x20203,\x20204)\x20THEN\x20\x27Staff\x27'+_0xbe2bdb(0x186)+_0xbe2bdb(0x19e)+_0xbe2bdb(0x1c9)+_0xbe2bdb(0x21e)+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(701,\x20702,\x20710)\x20THEN\x20\x27Sms\x27'+_0xbe2bdb(0x203)+_0xbe2bdb(0x23b)+_0xbe2bdb(0x25b)+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20in\x20(1101,\x201102,\x201103)\x20THEN\x20\x27CallySquare\x27'+_0xbe2bdb(0x1fa)+_0xbe2bdb(0x1e9)+_0xbe2bdb(0x264)+_0xbe2bdb(0x207)+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201600\x20THEN\x20\x27Help\x27'+'\x20\x20\x20\x20\x20\x20\x20\x20WHEN\x20sectionId\x20=\x201701\x20THEN\x20\x27jscripty\x27'+_0xbe2bdb(0x19b)+'\x20\x20\x20\x20\x20\x20\x20\x20ELSE\x20\x27\x27'+_0xbe2bdb(0x155)+_0xbe2bdb(0x236)),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x23d)+'\x20\x20WHERE\x20name\x20=\x20\x27DELETE\x27;'),_0x1b1ee1['query'](_0xbe2bdb(0x1cc)+_0xbe2bdb(0x1e3)+_0xbe2bdb(0x1ac)+_0xbe2bdb(0x279)+_0xbe2bdb(0x289)+_0xbe2bdb(0x1ba)+'\x20\x20\x20\x20autoAssociation\x20tinyint\x20not\x20null,'+_0xbe2bdb(0x24a)+_0xbe2bdb(0x208)+_0xbe2bdb(0x1e7)+_0xbe2bdb(0x236)),_0x1b1ee1['query'](_0xbe2bdb(0x172)+_0xbe2bdb(0x1bf)+'\x20\x20FROM\x20tmpSections'+_0xbe2bdb(0x1eb)),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x1f3)+_0xbe2bdb(0x226)),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x24c)+_0xbe2bdb(0x1f4)),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x24c)+_0xbe2bdb(0x1c4)),_0x1b1ee1['query'](_0xbe2bdb(0x24c)+_0xbe2bdb(0x189)),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x248)+_0xbe2bdb(0x20e)+_0xbe2bdb(0x2b6)+_0xbe2bdb(0x210)+_0xbe2bdb(0x222)+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20END'+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20);'),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x2b7)+_0xbe2bdb(0x21d)+_0xbe2bdb(0x1e5)),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x1c8)+'\x20\x20SET\x20insertedId\x20=\x20(SELECT\x20id'+_0xbe2bdb(0x1ed)+_0xbe2bdb(0x14d)),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x1b0)+_0xbe2bdb(0x25c)+_0xbe2bdb(0x19d)),_0x1b1ee1['query'](_0xbe2bdb(0x1a5)+'\x20\x20('+_0xbe2bdb(0x2b9)+_0xbe2bdb(0x1a9)+_0xbe2bdb(0x184)+_0xbe2bdb(0x201)+_0xbe2bdb(0x236)),_0x1b1ee1[_0xbe2bdb(0x19f)]('INSERT\x20INTO\x20tmpResources'+_0xbe2bdb(0x217)+_0xbe2bdb(0x23c)+_0xbe2bdb(0x2ad)),_0x1b1ee1['query'](_0xbe2bdb(0x1ab)+_0xbe2bdb(0x1e3)+'\x20\x20\x20\x20name\x20varchar(255)\x20not\x20null,'+_0xbe2bdb(0x271)+_0xbe2bdb(0x2b8)+_0xbe2bdb(0x151)+_0xbe2bdb(0x1ec)+_0xbe2bdb(0x236)),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x1fc)+_0xbe2bdb(0x1c0)+_0xbe2bdb(0x187)+_0xbe2bdb(0x292)+'\x20\x20\x20\x20\x20\x20\x20\x20r.type\x20type,'+'\x20\x20\x20\x20\x20\x20\x20\x20r.insertedSectionId\x20insertedSectionId,'+_0xbe2bdb(0x28c)+'\x20\x20\x20\x20\x20\x20\x20\x20FROM\x20tally'+_0xbe2bdb(0x28d)+'\x20\x20\x20\x20\x20\x20\x20\x20ORDER\x20BY\x20n)\x20AS\x20split;'),_0x1b1ee1['query']('INSERT\x20INTO\x20tmpNormalizedResources'+_0xbe2bdb(0x1b7)+'\x20\x20FROM\x20tmpCustomResources;'),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x1f0)+_0xbe2bdb(0x20f)+_0xbe2bdb(0x2a9)+_0xbe2bdb(0x237)+_0xbe2bdb(0x1c6)+_0xbe2bdb(0x273)+'\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20601\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20mail_queues\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)'+'\x20\x20\x20\x20\x20\x20WHEN\x20x.sectionId\x20=\x20602\x20THEN\x20COALESCE((SELECT\x20name\x20FROM\x20mail_accounts\x20WHERE\x20id\x20=\x20x.resourceId),\x27DELETE_MIGRATION\x27)'+_0xbe2bdb(0x1dc)+_0xbe2bdb(0x1a3)+_0xbe2bdb(0x1a1)+_0xbe2bdb(0x196)+'\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)'+_0xbe2bdb(0x29d)+_0xbe2bdb(0x239)+_0xbe2bdb(0x1a7)+'\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)'+_0xbe2bdb(0x14f)+_0xbe2bdb(0x295)+'\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20);'),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x270)+'\x20\x20WHERE\x20name\x20=\x20\x27DELETE_MIGRATION\x27;'),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x274)+_0xbe2bdb(0x182)+_0xbe2bdb(0x1bd)),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x22d)+_0xbe2bdb(0x1c1)+_0xbe2bdb(0x284)),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x171)+_0xbe2bdb(0x224)+_0xbe2bdb(0x257)),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x211)),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x278)),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x18d)),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x168)),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x22a)),_0x1b1ee1[_0xbe2bdb(0x19f)]('DROP\x20TABLE\x20IF\x20EXISTS\x20tmpGroupedPermissions;'),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x14b)),_0x1b1ee1['query'](_0xbe2bdb(0x1a4)),_0x1b1ee1['query'](_0xbe2bdb(0x21c)),_0x1b1ee1['query']('DROP\x20TABLE\x20IF\x20EXISTS\x20tmpSections;'),_0x1b1ee1[_0xbe2bdb(0x19f)](_0xbe2bdb(0x183)),_0x1b1ee1[_0xbe2bdb(0x19f)]('DROP\x20TABLE\x20IF\x20EXISTS\x20tmpResources;'),_0x1b1ee1['query'](_0xbe2bdb(0x281)),_0x1b1ee1['final'](_0x369f66);});},'down':function(){const _0x2e676a=a1136_0x18723c;return Promise[_0x2e676a(0x258)]();}};
git://repos.xcallymotion.com / motion-next.git / blob