1 const a1074_0x3fdd=['mail_servers_out','unmanagedMessage','cm_hopper','openchannel_accounts','exports','ALTER\x20TABLE\x20mail_messages\x20DROP\x20FOREIGN\x20KEY\x20mail_messages_ibfk_1','Send','prototype','acceptMethod','timeout','acceptUrl','user_has_mail_queues','dialRecallMeTimeout','waitingMessage','sequelize','Added\x20column\x20%s\x20to\x20%s','info','closingMessage','mail_servers_in','team_has_mail_queues','forwardTranscriptMessage','enableFeedback','addIndex\x20%s\x20%s\x20%s','state','mail_attachments','ALTER\x20TABLE\x20mail_messages\x20DROP\x20COLUMN\x20MailRoomId','then','dialRecallInQueue','rejectMethod','../config/logger','signature','skipMessageButton','queryInterface','query','custom','conditionAgreement','inspect','cm_hopper_final','mail_interactions','catch','sequence','accountSid','sendUnmanaged','recallme','ALTER\x20TABLE\x20analytics_extracted_reports\x20DROP\x20FOREIGN\x20KEY\x20analytics_extracted_reports_ibfk_1','addIndex','dropTable','authToken','mail_dispositions','Thanks\x20you\x20for\x20your\x20time!','ALTER\x20TABLE\x20mail_messages\x20DROP\x20COLUMN\x20UserId','browserVersion','addColumn','mail_accounts','Your\x20request\x20has\x20not\x20been\x20processed.','INTEGER','chat_websites','actions','mail_messages','Skip','fidelity','rejectUrl','stringify','All\x20of\x20our\x20agents\x20are\x20busy\x20at\x20this\x20time.\x20Your\x20chat\x20is\x20very\x20important\x20to\x20us.','closeUrl','mail_rooms','fax_accounts','deviceVendor','osName','enqueue','finally','STRING','chat_interactions','phone','sms_accounts','voice_queues','removeColumn','BOOLEAN','changeColumn','ALTER\x20TABLE\x20mail_messages\x20DROP\x20FOREIGN\x20KEY\x20mail_messages_ibfk_2','user_has_mail_interactions','voice_recordings','ALTER\x20TABLE\x20`chat_messages`\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ADD\x20CONSTRAINT\x20`chat_messages_ibfk_5`\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20FOREIGN\x20KEY\x20(`AttachmentId`)\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20REFERENCES\x20attachments(`id`)\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ON\x20UPDATE\x20CASCADE\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ON\x20DELETE\x20SET\x20NULL','key','waitingTitle','CREATE\x20TABLE\x20`mail_messages`\x20(\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20`id`\x20int(11)\x20NOT\x20NULL\x20AUTO_INCREMENT,\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20`body`\x20longtext\x20COLLATE\x20utf8mb4_unicode_ci\x20NOT\x20NULL,\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20`read`\x20tinyint(1)\x20DEFAULT\x20\x270\x27,\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20`direction`\x20enum(\x27in\x27,\x27out\x27)\x20COLLATE\x20utf8mb4_unicode_ci\x20NOT\x20NULL\x20DEFAULT\x20\x27out\x27,\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20`messageId`\x20varchar(190)\x20COLLATE\x20utf8mb4_unicode_ci\x20DEFAULT\x20NULL,\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20`from`\x20varchar(255)\x20COLLATE\x20utf8mb4_unicode_ci\x20DEFAULT\x20NULL,\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20`to`\x20longtext\x20COLLATE\x20utf8mb4_unicode_ci,\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20`cc`\x20longtext\x20COLLATE\x20utf8mb4_unicode_ci,\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20`bcc`\x20longtext\x20COLLATE\x20utf8mb4_unicode_ci,\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20`subject`\x20text\x20COLLATE\x20utf8mb4_unicode_ci,\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20`sentAt`\x20datetime\x20DEFAULT\x20NULL,\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20`createdAt`\x20datetime\x20NOT\x20NULL,\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20`updatedAt`\x20datetime\x20NOT\x20NULL,\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20`MailAccountId`\x20int(11)\x20DEFAULT\x20NULL,\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20`MailInteractionId`\x20int(11)\x20DEFAULT\x20NULL,\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20`UserId`\x20int(11)\x20DEFAULT\x20NULL,\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20`ContactId`\x20int(11)\x20DEFAULT\x20NULL,\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20PRIMARY\x20KEY\x20(`id`),\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20KEY\x20`MailAccountId`\x20(`MailAccountId`),\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20KEY\x20`MailInteractionId`\x20(`MailInteractionId`),\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20KEY\x20`UserId`\x20(`UserId`),\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20KEY\x20`ContactId`\x20(`ContactId`),\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20KEY\x20`messageId`\x20(`messageId`),\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20CONSTRAINT\x20`mail_messages_ibfk_1`\x20FOREIGN\x20KEY\x20(`MailAccountId`)\x20REFERENCES\x20`mail_accounts`\x20(`id`)\x20ON\x20DELETE\x20SET\x20NULL\x20ON\x20UPDATE\x20CASCADE,\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20CONSTRAINT\x20`mail_messages_ibfk_2`\x20FOREIGN\x20KEY\x20(`MailInteractionId`)\x20REFERENCES\x20`mail_interactions`\x20(`id`)\x20ON\x20DELETE\x20CASCADE\x20ON\x20UPDATE\x20CASCADE,\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20CONSTRAINT\x20`mail_messages_ibfk_3`\x20FOREIGN\x20KEY\x20(`UserId`)\x20REFERENCES\x20`users`\x20(`id`)\x20ON\x20DELETE\x20SET\x20NULL\x20ON\x20UPDATE\x20CASCADE,\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20CONSTRAINT\x20`mail_messages_ibfk_4`\x20FOREIGN\x20KEY\x20(`ContactId`)\x20REFERENCES\x20`cm_contacts`\x20(`id`)\x20ON\x20DELETE\x20CASCADE\x20ON\x20UPDATE\x20CASCADE\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20)\x20ENGINE=InnoDB\x20DEFAULT\x20CHARSET=utf8mb4\x20COLLATE=utf8mb4_unicode_ci;','ALTER\x20TABLE\x20mail_rooms\x20DROP\x20COLUMN\x20MailAccountId','enableUnmanagedNote','browserName','tail','CREATE\x20TABLE\x20`mail_interactions`\x20(\x20\x20\x20\x20\x20\x20\x20`id`\x20int(11)\x20NOT\x20NULL\x20AUTO_INCREMENT,\x20\x20\x20\x20\x20\x20\x20`closed`\x20tinyint(1)\x20DEFAULT\x20\x270\x27,\x20\x20\x20\x20\x20\x20\x20`closedAt`\x20datetime\x20DEFAULT\x20NULL,\x20\x20\x20\x20\x20\x20\x20`disposition`\x20varchar(255)\x20DEFAULT\x20NULL,\x20\x20\x20\x20\x20\x20\x20`note`\x20varchar(255)\x20DEFAULT\x20NULL,\x20\x20\x20\x20\x20\x20\x20`inReplyTo`\x20varchar(190)\x20DEFAULT\x20NULL,\x20\x20\x20\x20\x20\x20\x20`to`\x20varchar(255)\x20DEFAULT\x20NULL,\x20\x20\x20\x20\x20\x20\x20`cc`\x20longtext,\x20\x20\x20\x20\x20\x20\x20`subject`\x20text,\x20\x20\x20\x20\x20\x20\x20`createdAt`\x20datetime\x20NOT\x20NULL,\x20\x20\x20\x20\x20\x20\x20`updatedAt`\x20datetime\x20NOT\x20NULL,\x20\x20\x20\x20\x20\x20\x20`UserId`\x20int(11)\x20DEFAULT\x20NULL,\x20\x20\x20\x20\x20\x20\x20`MailAccountId`\x20int(11)\x20DEFAULT\x20NULL,\x20\x20\x20\x20\x20\x20\x20`ContactId`\x20int(11)\x20DEFAULT\x20NULL,\x20\x20\x20\x20\x20\x20\x20PRIMARY\x20KEY\x20(`id`),\x20\x20\x20\x20\x20\x20\x20KEY\x20`UserId`\x20(`UserId`),\x20\x20\x20\x20\x20\x20\x20KEY\x20`MailAccountId`\x20(`MailAccountId`),\x20\x20\x20\x20\x20\x20\x20KEY\x20`ContactId`\x20(`ContactId`),\x20\x20\x20\x20\x20\x20\x20CONSTRAINT\x20`mail_interactions_ibfk_1`\x20FOREIGN\x20KEY\x20(`UserId`)\x20REFERENCES\x20`users`\x20(`id`)\x20ON\x20DELETE\x20SET\x20NULL\x20ON\x20UPDATE\x20CASCADE,\x20\x20\x20\x20\x20\x20\x20CONSTRAINT\x20`mail_interactions_ibfk_2`\x20FOREIGN\x20KEY\x20(`MailAccountId`)\x20REFERENCES\x20`mail_accounts`\x20(`id`)\x20ON\x20DELETE\x20SET\x20NULL\x20ON\x20UPDATE\x20CASCADE,\x20\x20\x20\x20\x20\x20\x20CONSTRAINT\x20`mail_interactions_ibfk_3`\x20FOREIGN\x20KEY\x20(`ContactId`)\x20REFERENCES\x20`cm_contacts`\x20(`id`)\x20ON\x20UPDATE\x20CASCADE\x20\x20\x20\x20\x20)\x20ENGINE=InnoDB\x20DEFAULT\x20CHARSET=utf8;','UNSIGNED','deviceType','Please\x20hold\x20and\x20we\x20will\x20answer\x20your\x20request\x20as\x20soon\x20as\x20possible.','final','query\x20%s','user_has_mail_rooms','skipUnmanaged','ALTER\x20TABLE\x20mail_messages\x20DROP\x20COLUMN\x20MailMessageId','join'];(function(_0x2473b2,_0x5afcd5){const _0x3fdd85=function(_0x39624e){while(--_0x39624e){_0x2473b2['push'](_0x2473b2['shift']());}};_0x3fdd85(++_0x5afcd5);}(a1074_0x3fdd,0xa7));const a1074_0x3962=function(_0x2473b2,_0x5afcd5){_0x2473b2=_0x2473b2-0x1f3;let _0x3fdd85=a1074_0x3fdd[_0x2473b2];return _0x3fdd85;};const a1074_0x348d61=a1074_0x3962;'use strict';const logger=require(a1074_0x348d61(0x231))('migration'),util=require('util'),Sequence=function(){};Sequence[a1074_0x348d61(0x21b)]['enqueue']=function(_0x1a5ead){const _0x5b72c5=a1074_0x348d61;this[_0x5b72c5(0x209)]=this['tail']?this['tail'][_0x5b72c5(0x1f6)](_0x1a5ead):_0x1a5ead();};const Migration=function(_0x4975d6){const _0xe57fd8=a1074_0x348d61;this[_0xe57fd8(0x234)]=_0x4975d6,this[_0xe57fd8(0x23c)]=new Sequence();};Migration['prototype'][a1074_0x348d61(0x1fe)]=function(_0x30cada,_0x50af2a,_0x536983){const _0x1778d8=a1074_0x348d61,_0x23e8df=this;this[_0x1778d8(0x23c)]['enqueue'](function(){const _0x211f82=_0x1778d8;return _0x23e8df[_0x211f82(0x234)][_0x211f82(0x1fe)](_0x30cada,_0x50af2a,_0x536983)['then'](function(){logger['info']('Changed\x20column\x20%s\x20in\x20table\x20%s',_0x50af2a,_0x30cada);})[_0x211f82(0x23b)](function(_0xda967c){const _0x36ca59=_0x211f82;logger[_0x36ca59(0x224)](JSON[_0x36ca59(0x252)](_0xda967c));});});},Migration[a1074_0x348d61(0x21b)][a1074_0x348d61(0x248)]=function(_0x1c76ba,_0x9077e5,_0x5825e7){const _0x113483=a1074_0x348d61,_0x57ab9a=this;this[_0x113483(0x23c)][_0x113483(0x1f5)](function(){const _0x11c655=_0x113483;return _0x57ab9a[_0x11c655(0x234)]['addColumn'](_0x1c76ba,_0x9077e5,_0x5825e7)['then'](function(){const _0x183b23=_0x11c655;logger[_0x183b23(0x224)](_0x183b23(0x223),_0x9077e5,_0x1c76ba);})[_0x11c655(0x23b)](function(_0x9e9f7d){const _0x892cd6=_0x11c655;logger[_0x892cd6(0x224)](JSON[_0x892cd6(0x252)](_0x9e9f7d));});});},Migration[a1074_0x348d61(0x21b)][a1074_0x348d61(0x242)]=function(_0x496f23){const _0x38a085=this;this['sequence']['enqueue'](function(){const _0x5961ab=a1074_0x3962;return _0x38a085[_0x5961ab(0x234)][_0x5961ab(0x242)](_0x496f23,{'force':!![]})['then'](function(){logger['info']('table\x20dropped\x20%s',_0x496f23);})['catch'](function(_0x1df93e){const _0x343975=_0x5961ab;logger[_0x343975(0x224)](JSON[_0x343975(0x252)](_0x1df93e));});});},Migration['prototype'][a1074_0x348d61(0x241)]=function(_0x510541,_0x2178aa,_0x232abc){const _0x5e4d53=a1074_0x348d61,_0x1aba26=this;this[_0x5e4d53(0x23c)]['enqueue'](function(){const _0x53efc6=_0x5e4d53;return _0x1aba26['queryInterface'][_0x53efc6(0x241)](_0x510541,_0x2178aa,{'indexName':_0x232abc})[_0x53efc6(0x22e)](function(){const _0x20be95=_0x53efc6;logger['info'](_0x20be95(0x22a),_0x510541,_0x2178aa[_0x20be95(0x213)](','),_0x232abc);})[_0x53efc6(0x23b)](function(_0x4365d6){const _0x3ea9d9=_0x53efc6;logger['info'](JSON[_0x3ea9d9(0x252)](_0x4365d6));});});},Migration[a1074_0x348d61(0x21b)][a1074_0x348d61(0x235)]=function(_0x5c491d){const _0x11cc4e=a1074_0x348d61,_0x197c23=this;this[_0x11cc4e(0x23c)]['enqueue'](function(){const _0x587bac=_0x11cc4e;return _0x197c23['queryInterface'][_0x587bac(0x222)][_0x587bac(0x235)](_0x5c491d)[_0x587bac(0x22e)](function(){const _0x1ecd8d=_0x587bac;logger[_0x1ecd8d(0x224)](_0x1ecd8d(0x20f),_0x5c491d);})['catch'](function(_0x92ae3d){const _0x15ba86=_0x587bac;logger['info'](JSON[_0x15ba86(0x252)](_0x92ae3d));});});},Migration[a1074_0x348d61(0x21b)][a1074_0x348d61(0x1fc)]=function(_0x4929a7,_0x11e529){const _0x47fca1=a1074_0x348d61,_0x3bcf6c=this;this[_0x47fca1(0x23c)][_0x47fca1(0x1f5)](function(){const _0x9bab42=_0x47fca1;return _0x3bcf6c['queryInterface'][_0x9bab42(0x1fc)](_0x4929a7,_0x11e529)[_0x9bab42(0x22e)](function(){const _0x292770=_0x9bab42;logger[_0x292770(0x224)]('Removed\x20column\x20%s\x20from\x20%s',_0x11e529,_0x4929a7);})[_0x9bab42(0x23b)](function(_0x307b2e){const _0x23055a=_0x9bab42;logger[_0x23055a(0x224)](util[_0x23055a(0x238)](_0x307b2e,{'showHidden':![],'depth':null}));});});},Migration[a1074_0x348d61(0x21b)][a1074_0x348d61(0x20e)]=function(_0x5f3417){const _0x20aaca=a1074_0x348d61;this['sequence'][_0x20aaca(0x1f5)](function(){return _0x5f3417();});},module[a1074_0x348d61(0x218)]={'up':function(_0x3c21c8,_0x869c35){return new Promise(function(_0x57cea7){const _0x31e2e3=a1074_0x3962,_0x4fad56=new Migration(_0x3c21c8);_0x4fad56[_0x31e2e3(0x248)](_0x31e2e3(0x24c),_0x31e2e3(0x203),{'type':_0x869c35[_0x31e2e3(0x1f7)],'allowNull':![]}),_0x4fad56['addColumn']('chat_websites',_0x31e2e3(0x228),{'type':_0x869c35[_0x31e2e3(0x1f7)]}),_0x4fad56[_0x31e2e3(0x248)](_0x31e2e3(0x24c),_0x31e2e3(0x233),{'type':_0x869c35[_0x31e2e3(0x1f7)],'defaultValue':_0x31e2e3(0x24f)}),_0x4fad56[_0x31e2e3(0x248)](_0x31e2e3(0x24c),_0x31e2e3(0x229),{'type':_0x869c35[_0x31e2e3(0x1fd)],'defaultValue':![]}),_0x4fad56[_0x31e2e3(0x248)](_0x31e2e3(0x24c),'enableCustomerWriting',{'type':_0x869c35[_0x31e2e3(0x1fd)],'defaultValue':![]}),_0x4fad56[_0x31e2e3(0x248)]('chat_websites',_0x31e2e3(0x237),{'type':_0x869c35[_0x31e2e3(0x1fd)],'defaultValue':![]}),_0x4fad56['addColumn'](_0x31e2e3(0x24c),_0x31e2e3(0x204),{'type':_0x869c35[_0x31e2e3(0x1f7)],'defaultValue':_0x31e2e3(0x253)}),_0x4fad56[_0x31e2e3(0x248)](_0x31e2e3(0x24c),_0x31e2e3(0x221),{'type':_0x869c35[_0x31e2e3(0x1f7)],'defaultValue':_0x31e2e3(0x20d)}),_0x4fad56[_0x31e2e3(0x248)](_0x31e2e3(0x24c),'autoclose',{'type':_0x869c35[_0x31e2e3(0x1fd)],'defaultValue':!![]}),_0x4fad56['addColumn'](_0x31e2e3(0x24c),_0x31e2e3(0x215),{'type':_0x869c35[_0x31e2e3(0x1f7)],'defaultValue':_0x31e2e3(0x24a)}),_0x4fad56[_0x31e2e3(0x248)](_0x31e2e3(0x24c),_0x31e2e3(0x207),{'type':_0x869c35['BOOLEAN'],'defaultValue':!![]}),_0x4fad56[_0x31e2e3(0x248)](_0x31e2e3(0x24c),_0x31e2e3(0x23e),{'type':_0x869c35[_0x31e2e3(0x1f7)],'defaultValue':_0x31e2e3(0x21a)}),_0x4fad56[_0x31e2e3(0x248)]('chat_websites',_0x31e2e3(0x211),{'type':_0x869c35['STRING'],'defaultValue':_0x31e2e3(0x24f)}),_0x4fad56[_0x31e2e3(0x1fe)]('chat_websites',_0x31e2e3(0x225),{'type':_0x869c35[_0x31e2e3(0x1f7)],'defaultValue':_0x31e2e3(0x245)}),_0x4fad56[_0x31e2e3(0x248)](_0x31e2e3(0x1f8),_0x31e2e3(0x208),{'type':_0x869c35[_0x31e2e3(0x1f7)]}),_0x4fad56[_0x31e2e3(0x248)](_0x31e2e3(0x1f8),_0x31e2e3(0x247),{'type':_0x869c35[_0x31e2e3(0x1f7)]}),_0x4fad56[_0x31e2e3(0x248)](_0x31e2e3(0x1f8),_0x31e2e3(0x1f4),{'type':_0x869c35['STRING']}),_0x4fad56[_0x31e2e3(0x248)](_0x31e2e3(0x1f8),'osVersion',{'type':_0x869c35[_0x31e2e3(0x1f7)]}),_0x4fad56[_0x31e2e3(0x248)](_0x31e2e3(0x1f8),'deviceModel',{'type':_0x869c35['STRING']}),_0x4fad56['addColumn']('chat_interactions',_0x31e2e3(0x1f3),{'type':_0x869c35['STRING']}),_0x4fad56['addColumn'](_0x31e2e3(0x1f8),_0x31e2e3(0x20c),{'type':_0x869c35[_0x31e2e3(0x1f7)]}),_0x4fad56[_0x31e2e3(0x248)]('chat_messages','AttachmentId',{'type':_0x869c35['INTEGER']}),_0x4fad56[_0x31e2e3(0x235)](_0x31e2e3(0x202)),_0x4fad56[_0x31e2e3(0x248)](_0x31e2e3(0x1fb),_0x31e2e3(0x220),{'type':_0x869c35[_0x31e2e3(0x24b)](0x5)[_0x31e2e3(0x20b)],'defaultValue':0x1e}),_0x4fad56[_0x31e2e3(0x248)]('voice_queues',_0x31e2e3(0x22f),{'type':_0x869c35[_0x31e2e3(0x1fd)],'defaultValue':![]}),_0x4fad56[_0x31e2e3(0x248)](_0x31e2e3(0x216),'recallme',{'type':_0x869c35['BOOLEAN'],'defaultValue':![]}),_0x4fad56[_0x31e2e3(0x248)](_0x31e2e3(0x239),'recallme',{'type':_0x869c35[_0x31e2e3(0x1fd)],'defaultValue':![]}),_0x4fad56[_0x31e2e3(0x248)]('cm_hopper_history',_0x31e2e3(0x23f),{'type':_0x869c35['BOOLEAN'],'defaultValue':![]}),_0x4fad56[_0x31e2e3(0x248)](_0x31e2e3(0x201),'userDisposition',{'type':_0x869c35[_0x31e2e3(0x1f7)]}),_0x4fad56[_0x31e2e3(0x242)](_0x31e2e3(0x210)),_0x4fad56[_0x31e2e3(0x235)]('ALTER\x20TABLE\x20mail_rooms\x20DROP\x20FOREIGN\x20KEY\x20mail_rooms_ibfk_1'),_0x4fad56[_0x31e2e3(0x235)](_0x31e2e3(0x206)),_0x4fad56['dropTable'](_0x31e2e3(0x255)),_0x4fad56[_0x31e2e3(0x235)](_0x31e2e3(0x240)),_0x4fad56['query'](_0x31e2e3(0x212)),_0x4fad56[_0x31e2e3(0x235)](_0x31e2e3(0x219)),_0x4fad56['query'](_0x31e2e3(0x22d)),_0x4fad56[_0x31e2e3(0x235)](_0x31e2e3(0x1ff)),_0x4fad56[_0x31e2e3(0x235)](_0x31e2e3(0x246)),_0x4fad56[_0x31e2e3(0x242)](_0x31e2e3(0x24e)),_0x4fad56[_0x31e2e3(0x242)](_0x31e2e3(0x22c)),_0x4fad56[_0x31e2e3(0x242)](_0x31e2e3(0x244)),_0x4fad56['dropTable']('mail_applications'),_0x4fad56[_0x31e2e3(0x242)](_0x31e2e3(0x200)),_0x4fad56[_0x31e2e3(0x242)](_0x31e2e3(0x23a)),_0x4fad56[_0x31e2e3(0x242)](_0x31e2e3(0x227)),_0x4fad56[_0x31e2e3(0x242)](_0x31e2e3(0x21f)),_0x4fad56[_0x31e2e3(0x242)]('mail_queues'),_0x4fad56[_0x31e2e3(0x1fc)](_0x31e2e3(0x249),_0x31e2e3(0x250)),_0x4fad56[_0x31e2e3(0x1fc)]('mail_accounts',_0x31e2e3(0x21d)),_0x4fad56[_0x31e2e3(0x1fc)](_0x31e2e3(0x249),'whiteLabel'),_0x4fad56['removeColumn'](_0x31e2e3(0x249),_0x31e2e3(0x21e)),_0x4fad56[_0x31e2e3(0x1fc)](_0x31e2e3(0x249),_0x31e2e3(0x251)),_0x4fad56[_0x31e2e3(0x1fc)]('mail_accounts',_0x31e2e3(0x21c)),_0x4fad56[_0x31e2e3(0x1fc)](_0x31e2e3(0x249),_0x31e2e3(0x230)),_0x4fad56[_0x31e2e3(0x1fc)](_0x31e2e3(0x249),_0x31e2e3(0x24d)),_0x4fad56[_0x31e2e3(0x1fc)](_0x31e2e3(0x249),_0x31e2e3(0x254)),_0x4fad56[_0x31e2e3(0x1fc)](_0x31e2e3(0x249),'closeMethod'),_0x4fad56[_0x31e2e3(0x1fc)](_0x31e2e3(0x249),_0x31e2e3(0x232)),_0x4fad56['removeColumn'](_0x31e2e3(0x249),_0x31e2e3(0x236)),_0x4fad56[_0x31e2e3(0x248)]('mail_accounts','active',{'type':_0x869c35['BOOLEAN'],'defaultValue':!![]}),_0x4fad56[_0x31e2e3(0x1fc)](_0x31e2e3(0x214),_0x31e2e3(0x22b)),_0x4fad56[_0x31e2e3(0x242)](_0x31e2e3(0x226)),_0x4fad56[_0x31e2e3(0x235)](_0x31e2e3(0x20a)),_0x4fad56[_0x31e2e3(0x235)](_0x31e2e3(0x205)),_0x4fad56[_0x31e2e3(0x235)]('CREATE\x20TABLE\x20`attachments`\x20(\x20\x20\x20\x20\x20\x20\x20\x20\x20`id`\x20int(11)\x20NOT\x20NULL\x20AUTO_INCREMENT,\x20\x20\x20\x20\x20\x20\x20\x20\x20`name`\x20varchar(255)\x20DEFAULT\x20NULL,\x20\x20\x20\x20\x20\x20\x20\x20\x20`basename`\x20varchar(255)\x20DEFAULT\x20NULL,\x20\x20\x20\x20\x20\x20\x20\x20\x20`type`\x20varchar(255)\x20DEFAULT\x20NULL,\x20\x20\x20\x20\x20\x20\x20\x20\x20`createdAt`\x20datetime\x20NOT\x20NULL,\x20\x20\x20\x20\x20\x20\x20\x20\x20`updatedAt`\x20datetime\x20NOT\x20NULL,\x20\x20\x20\x20\x20\x20\x20\x20\x20`MailMessageId`\x20int(11)\x20DEFAULT\x20NULL,\x20\x20\x20\x20\x20\x20\x20\x20\x20PRIMARY\x20KEY\x20(`id`),\x20\x20\x20\x20\x20\x20\x20\x20\x20KEY\x20`MailMessageId`\x20(`MailMessageId`),\x20\x20\x20\x20\x20\x20\x20\x20\x20CONSTRAINT\x20`attachments_ibfk_1`\x20FOREIGN\x20KEY\x20(`MailMessageId`)\x20REFERENCES\x20`mail_messages`\x20(`id`)\x20ON\x20DELETE\x20CASCADE\x20ON\x20UPDATE\x20CASCADE\x20\x20\x20\x20\x20\x20\x20)\x20ENGINE=InnoDB\x20AUTO_INCREMENT=5\x20DEFAULT\x20CHARSET=utf8;'),_0x4fad56['dropTable']('fax_attachments'),_0x4fad56[_0x31e2e3(0x248)]('sms_accounts',_0x31e2e3(0x1f9),{'type':_0x869c35[_0x31e2e3(0x1f7)]}),_0x4fad56[_0x31e2e3(0x248)](_0x31e2e3(0x1fa),_0x31e2e3(0x23d),{'type':_0x869c35[_0x31e2e3(0x1f7)]}),_0x4fad56[_0x31e2e3(0x248)]('sms_accounts',_0x31e2e3(0x243),{'type':_0x869c35[_0x31e2e3(0x1f7)]}),_0x4fad56[_0x31e2e3(0x248)](_0x31e2e3(0x1fa),_0x31e2e3(0x203),{'type':_0x869c35['STRING'],'allowNull':![]}),_0x4fad56[_0x31e2e3(0x235)]('ALTER\x20TABLE\x20users\x20CONVERT\x20TO\x20CHARACTER\x20SET\x20utf8\x20COLLATE\x20utf8_bin;'),_0x4fad56[_0x31e2e3(0x248)](_0x31e2e3(0x217),_0x31e2e3(0x203),{'type':_0x869c35['STRING'],'allowNull':![]}),_0x4fad56['addColumn'](_0x31e2e3(0x256),_0x31e2e3(0x203),{'type':_0x869c35[_0x31e2e3(0x1f7)],'allowNull':![]}),_0x4fad56['addColumn'](_0x31e2e3(0x249),_0x31e2e3(0x203),{'type':_0x869c35[_0x31e2e3(0x1f7)],'allowNull':![]}),_0x4fad56[_0x31e2e3(0x20e)](_0x57cea7);});},'down':function(){}};
git://repos.xcallymotion.com / motion-next.git / blob