0b9b79c261460517676165ffa98f1f0cbe289da5
[motion-next.git] / server / migrations / 2.0.34.js
1 const a912_0x4a3f=['active','recallme','ALTER\x20TABLE\x20mail_rooms\x20DROP\x20COLUMN\x20MailAccountId','stringify','chat_websites','exports','voice_recordings','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;','addIndex','addIndex\x20%s\x20%s\x20%s','user_has_mail_queues','osVersion','final','rejectUrl','enableFeedback','state','key','ALTER\x20TABLE\x20users\x20CONVERT\x20TO\x20CHARACTER\x20SET\x20utf8\x20COLLATE\x20utf8_bin;','enableUnmanagedNote','util','fax_accounts','mail_rooms','sequelize','Changed\x20column\x20%s\x20in\x20table\x20%s','actions','changeColumn','user_has_mail_interactions','mail_servers_out','Thanks\x20you\x20for\x20your\x20time!','signature','removeColumn','ALTER\x20TABLE\x20mail_messages\x20DROP\x20FOREIGN\x20KEY\x20mail_messages_ibfk_2','All\x20of\x20our\x20agents\x20are\x20busy\x20at\x20this\x20time.\x20Your\x20chat\x20is\x20very\x20important\x20to\x20us.','catch','sequence','Removed\x20column\x20%s\x20from\x20%s','sms_accounts','whiteLabel','Your\x20request\x20has\x20not\x20been\x20processed.','skipUnmanaged','query','Please\x20hold\x20and\x20we\x20will\x20answer\x20your\x20request\x20as\x20soon\x20as\x20possible.','conditionAgreement','chat_messages','prototype','browserName','mail_dispositions','rejectMethod','userDisposition','waitingMessage','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;','dropTable','closingMessage','deviceModel','team_has_mail_queues','unmanagedMessage','fidelity','dialRecallMeTimeout','addColumn','acceptMethod','join','Send','voice_queues','tail','browserVersion','ALTER\x20TABLE\x20mail_messages\x20DROP\x20COLUMN\x20MailMessageId','inspect','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;','mail_messages','dialRecallInQueue','mail_queues','mail_applications','ALTER\x20TABLE\x20analytics_extracted_reports\x20DROP\x20FOREIGN\x20KEY\x20analytics_extracted_reports_ibfk_1','Skip','chat_interactions','timeout','BOOLEAN','query\x20%s','then','enableCustomerWriting','cm_hopper','queryInterface','ALTER\x20TABLE\x20mail_messages\x20DROP\x20COLUMN\x20UserId','openchannel_accounts','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','user_has_mail_rooms','fax_attachments','mail_accounts','acceptUrl','osName','closeUrl','ALTER\x20TABLE\x20mail_rooms\x20DROP\x20FOREIGN\x20KEY\x20mail_rooms_ibfk_1','AttachmentId','enqueue','custom','STRING','info'];(function(_0x119a39,_0x4a3f56){const _0x1de5d6=function(_0x1afe4a){while(--_0x1afe4a){_0x119a39['push'](_0x119a39['shift']());}};_0x1de5d6(++_0x4a3f56);}(a912_0x4a3f,0xa4));const a912_0x1de5=function(_0x119a39,_0x4a3f56){_0x119a39=_0x119a39-0x0;let _0x1de5d6=a912_0x4a3f[_0x119a39];return _0x1de5d6;};const _0x24b056=a912_0x1de5;'use strict';const logger=require('../config/logger')('migration'),util=require(_0x24b056('0x31')),Sequence=function(){};Sequence[_0x24b056('0x4a')]['enqueue']=function(_0x1afe4a){const _0x24dbf7=_0x24b056;this[_0x24dbf7('0x5d')]=this[_0x24dbf7('0x5d')]?this[_0x24dbf7('0x5d')]['finally'](_0x1afe4a):_0x1afe4a();};const Migration=function(_0x2b6d5a){const _0x46df0a=_0x24b056;this[_0x46df0a('0xe')]=_0x2b6d5a,this[_0x46df0a('0x40')]=new Sequence();};Migration['prototype'][_0x24b056('0x37')]=function(_0x4f3a0a,_0x435a7b,_0x5affe8){const _0x83fd66=_0x24b056,_0x162ca0=this;this[_0x83fd66('0x40')][_0x83fd66('0x1a')](function(){const _0x3eb604=_0x83fd66;return _0x162ca0[_0x3eb604('0xe')][_0x3eb604('0x37')](_0x4f3a0a,_0x435a7b,_0x5affe8)['then'](function(){const _0x39f1f7=_0x3eb604;logger['info'](_0x39f1f7('0x35'),_0x435a7b,_0x4f3a0a);})[_0x3eb604('0x3f')](function(_0x7461d2){const _0x12b2b6=_0x3eb604;logger['info'](JSON[_0x12b2b6('0x21')](_0x7461d2));});});},Migration['prototype'][_0x24b056('0x58')]=function(_0x2cf514,_0x260309,_0xb3ff43){const _0x14054a=_0x24b056,_0x1f58f7=this;this[_0x14054a('0x40')][_0x14054a('0x1a')](function(){const _0x3a1e4d=_0x14054a;return _0x1f58f7[_0x3a1e4d('0xe')]['addColumn'](_0x2cf514,_0x260309,_0xb3ff43)[_0x3a1e4d('0xb')](function(){const _0xb68e9c=_0x3a1e4d;logger[_0xb68e9c('0x1d')]('Added\x20column\x20%s\x20to\x20%s',_0x260309,_0x2cf514);})[_0x3a1e4d('0x3f')](function(_0x488163){const _0x4b88ad=_0x3a1e4d;logger['info'](JSON[_0x4b88ad('0x21')](_0x488163));});});},Migration[_0x24b056('0x4a')][_0x24b056('0x51')]=function(_0x1e17dd){const _0x324f68=_0x24b056,_0x2f0c64=this;this['sequence'][_0x324f68('0x1a')](function(){const _0x4e353b=_0x324f68;return _0x2f0c64[_0x4e353b('0xe')][_0x4e353b('0x51')](_0x1e17dd,{'force':!![]})[_0x4e353b('0xb')](function(){const _0x1dd7f4=_0x4e353b;logger[_0x1dd7f4('0x1d')]('table\x20dropped\x20%s',_0x1e17dd);})['catch'](function(_0xea060a){const _0x8be5ef=_0x4e353b;logger[_0x8be5ef('0x1d')](JSON[_0x8be5ef('0x21')](_0xea060a));});});},Migration[_0x24b056('0x4a')][_0x24b056('0x26')]=function(_0x552d1e,_0x1b8474,_0x40dea4){const _0x51a3b6=_0x24b056,_0x340889=this;this[_0x51a3b6('0x40')][_0x51a3b6('0x1a')](function(){const _0x3b260b=_0x51a3b6;return _0x340889[_0x3b260b('0xe')][_0x3b260b('0x26')](_0x552d1e,_0x1b8474,{'indexName':_0x40dea4})[_0x3b260b('0xb')](function(){const _0x68c4c1=_0x3b260b;logger[_0x68c4c1('0x1d')](_0x68c4c1('0x27'),_0x552d1e,_0x1b8474[_0x68c4c1('0x5a')](','),_0x40dea4);})[_0x3b260b('0x3f')](function(_0x5cc7b3){const _0x3a0e29=_0x3b260b;logger[_0x3a0e29('0x1d')](JSON[_0x3a0e29('0x21')](_0x5cc7b3));});});},Migration['prototype'][_0x24b056('0x46')]=function(_0x4da04e){const _0x37ae78=_0x24b056,_0x19e01f=this;this[_0x37ae78('0x40')]['enqueue'](function(){const _0x52b9f8=_0x37ae78;return _0x19e01f['queryInterface'][_0x52b9f8('0x34')][_0x52b9f8('0x46')](_0x4da04e)[_0x52b9f8('0xb')](function(){const _0x2b122c=_0x52b9f8;logger[_0x2b122c('0x1d')](_0x2b122c('0xa'),_0x4da04e);})[_0x52b9f8('0x3f')](function(_0x1254a5){const _0x3eb034=_0x52b9f8;logger[_0x3eb034('0x1d')](JSON[_0x3eb034('0x21')](_0x1254a5));});});},Migration[_0x24b056('0x4a')][_0x24b056('0x3c')]=function(_0x2711fa,_0x106a1a){const _0x18cc58=_0x24b056,_0x47aa6e=this;this['sequence'][_0x18cc58('0x1a')](function(){const _0x5b4cfb=_0x18cc58;return _0x47aa6e[_0x5b4cfb('0xe')][_0x5b4cfb('0x3c')](_0x2711fa,_0x106a1a)[_0x5b4cfb('0xb')](function(){const _0x38e399=_0x5b4cfb;logger[_0x38e399('0x1d')](_0x38e399('0x41'),_0x106a1a,_0x2711fa);})['catch'](function(_0x5548f4){const _0x36492f=_0x5b4cfb;logger['info'](util[_0x36492f('0x60')](_0x5548f4,{'showHidden':![],'depth':null}));});});},Migration[_0x24b056('0x4a')][_0x24b056('0x2a')]=function(_0x2e03f5){const _0x43c1ce=_0x24b056;this['sequence'][_0x43c1ce('0x1a')](function(){return _0x2e03f5();});},module[_0x24b056('0x23')]={'up':function(_0x701e36,_0x42a1b4){return new Promise(function(_0x2d1cb5){const _0x325ae2=a912_0x1de5,_0x437c40=new Migration(_0x701e36);_0x437c40[_0x325ae2('0x58')](_0x325ae2('0x22'),_0x325ae2('0x2e'),{'type':_0x42a1b4[_0x325ae2('0x1c')],'allowNull':![]}),_0x437c40[_0x325ae2('0x58')](_0x325ae2('0x22'),'forwardTranscriptMessage',{'type':_0x42a1b4[_0x325ae2('0x1c')]}),_0x437c40['addColumn'](_0x325ae2('0x22'),'skipMessageButton',{'type':_0x42a1b4[_0x325ae2('0x1c')],'defaultValue':_0x325ae2('0x6')}),_0x437c40[_0x325ae2('0x58')](_0x325ae2('0x22'),_0x325ae2('0x2c'),{'type':_0x42a1b4[_0x325ae2('0x9')],'defaultValue':![]}),_0x437c40[_0x325ae2('0x58')](_0x325ae2('0x22'),_0x325ae2('0xc'),{'type':_0x42a1b4[_0x325ae2('0x9')],'defaultValue':![]}),_0x437c40[_0x325ae2('0x58')](_0x325ae2('0x22'),_0x325ae2('0x48'),{'type':_0x42a1b4[_0x325ae2('0x9')],'defaultValue':![]}),_0x437c40['addColumn'](_0x325ae2('0x22'),'waitingTitle',{'type':_0x42a1b4[_0x325ae2('0x1c')],'defaultValue':_0x325ae2('0x3e')}),_0x437c40['addColumn'](_0x325ae2('0x22'),_0x325ae2('0x4f'),{'type':_0x42a1b4['STRING'],'defaultValue':_0x325ae2('0x47')}),_0x437c40[_0x325ae2('0x58')]('chat_websites','autoclose',{'type':_0x42a1b4[_0x325ae2('0x9')],'defaultValue':!![]}),_0x437c40['addColumn'](_0x325ae2('0x22'),_0x325ae2('0x55'),{'type':_0x42a1b4[_0x325ae2('0x1c')],'defaultValue':_0x325ae2('0x44')}),_0x437c40[_0x325ae2('0x58')](_0x325ae2('0x22'),_0x325ae2('0x30'),{'type':_0x42a1b4[_0x325ae2('0x9')],'defaultValue':!![]}),_0x437c40[_0x325ae2('0x58')](_0x325ae2('0x22'),'sendUnmanaged',{'type':_0x42a1b4[_0x325ae2('0x1c')],'defaultValue':_0x325ae2('0x5b')}),_0x437c40['addColumn'](_0x325ae2('0x22'),_0x325ae2('0x45'),{'type':_0x42a1b4[_0x325ae2('0x1c')],'defaultValue':_0x325ae2('0x6')}),_0x437c40[_0x325ae2('0x37')](_0x325ae2('0x22'),_0x325ae2('0x52'),{'type':_0x42a1b4['STRING'],'defaultValue':_0x325ae2('0x3a')}),_0x437c40[_0x325ae2('0x58')](_0x325ae2('0x7'),_0x325ae2('0x4b'),{'type':_0x42a1b4[_0x325ae2('0x1c')]}),_0x437c40[_0x325ae2('0x58')](_0x325ae2('0x7'),_0x325ae2('0x5e'),{'type':_0x42a1b4[_0x325ae2('0x1c')]}),_0x437c40[_0x325ae2('0x58')](_0x325ae2('0x7'),_0x325ae2('0x16'),{'type':_0x42a1b4[_0x325ae2('0x1c')]}),_0x437c40[_0x325ae2('0x58')](_0x325ae2('0x7'),_0x325ae2('0x29'),{'type':_0x42a1b4[_0x325ae2('0x1c')]}),_0x437c40[_0x325ae2('0x58')](_0x325ae2('0x7'),_0x325ae2('0x53'),{'type':_0x42a1b4[_0x325ae2('0x1c')]}),_0x437c40['addColumn'](_0x325ae2('0x7'),'deviceVendor',{'type':_0x42a1b4[_0x325ae2('0x1c')]}),_0x437c40[_0x325ae2('0x58')](_0x325ae2('0x7'),'deviceType',{'type':_0x42a1b4[_0x325ae2('0x1c')]}),_0x437c40['addColumn'](_0x325ae2('0x49'),_0x325ae2('0x19'),{'type':_0x42a1b4['INTEGER']}),_0x437c40['query'](_0x325ae2('0x11')),_0x437c40[_0x325ae2('0x58')](_0x325ae2('0x5c'),_0x325ae2('0x57'),{'type':_0x42a1b4['INTEGER'](0x5)['UNSIGNED'],'defaultValue':0x1e}),_0x437c40['addColumn'](_0x325ae2('0x5c'),_0x325ae2('0x2'),{'type':_0x42a1b4[_0x325ae2('0x9')],'defaultValue':![]}),_0x437c40[_0x325ae2('0x58')](_0x325ae2('0xd'),_0x325ae2('0x1f'),{'type':_0x42a1b4['BOOLEAN'],'defaultValue':![]}),_0x437c40[_0x325ae2('0x58')]('cm_hopper_final',_0x325ae2('0x1f'),{'type':_0x42a1b4[_0x325ae2('0x9')],'defaultValue':![]}),_0x437c40[_0x325ae2('0x58')]('cm_hopper_history',_0x325ae2('0x1f'),{'type':_0x42a1b4[_0x325ae2('0x9')],'defaultValue':![]}),_0x437c40[_0x325ae2('0x58')](_0x325ae2('0x24'),_0x325ae2('0x4e'),{'type':_0x42a1b4[_0x325ae2('0x1c')]}),_0x437c40[_0x325ae2('0x51')](_0x325ae2('0x12')),_0x437c40[_0x325ae2('0x46')](_0x325ae2('0x18')),_0x437c40[_0x325ae2('0x46')](_0x325ae2('0x20')),_0x437c40['dropTable'](_0x325ae2('0x33')),_0x437c40[_0x325ae2('0x46')](_0x325ae2('0x5')),_0x437c40[_0x325ae2('0x46')](_0x325ae2('0x5f')),_0x437c40['query']('ALTER\x20TABLE\x20mail_messages\x20DROP\x20FOREIGN\x20KEY\x20mail_messages_ibfk_1'),_0x437c40[_0x325ae2('0x46')]('ALTER\x20TABLE\x20mail_messages\x20DROP\x20COLUMN\x20MailRoomId'),_0x437c40[_0x325ae2('0x46')](_0x325ae2('0x3d')),_0x437c40[_0x325ae2('0x46')](_0x325ae2('0xf')),_0x437c40['dropTable'](_0x325ae2('0x1')),_0x437c40[_0x325ae2('0x51')]('mail_attachments'),_0x437c40[_0x325ae2('0x51')](_0x325ae2('0x4c')),_0x437c40['dropTable'](_0x325ae2('0x4')),_0x437c40[_0x325ae2('0x51')](_0x325ae2('0x38')),_0x437c40[_0x325ae2('0x51')]('mail_interactions'),_0x437c40[_0x325ae2('0x51')](_0x325ae2('0x54')),_0x437c40[_0x325ae2('0x51')](_0x325ae2('0x28')),_0x437c40['dropTable'](_0x325ae2('0x3')),_0x437c40[_0x325ae2('0x3c')](_0x325ae2('0x14'),_0x325ae2('0x56')),_0x437c40['removeColumn']('mail_accounts',_0x325ae2('0x8')),_0x437c40[_0x325ae2('0x3c')](_0x325ae2('0x14'),_0x325ae2('0x43')),_0x437c40[_0x325ae2('0x3c')](_0x325ae2('0x14'),_0x325ae2('0x15')),_0x437c40[_0x325ae2('0x3c')](_0x325ae2('0x14'),_0x325ae2('0x2b')),_0x437c40[_0x325ae2('0x3c')](_0x325ae2('0x14'),_0x325ae2('0x59')),_0x437c40['removeColumn'](_0x325ae2('0x14'),_0x325ae2('0x4d')),_0x437c40[_0x325ae2('0x3c')]('mail_accounts',_0x325ae2('0x36')),_0x437c40[_0x325ae2('0x3c')](_0x325ae2('0x14'),_0x325ae2('0x17')),_0x437c40[_0x325ae2('0x3c')](_0x325ae2('0x14'),'closeMethod'),_0x437c40[_0x325ae2('0x3c')]('mail_accounts',_0x325ae2('0x3b')),_0x437c40[_0x325ae2('0x3c')](_0x325ae2('0x14'),_0x325ae2('0x1b')),_0x437c40[_0x325ae2('0x58')](_0x325ae2('0x14'),_0x325ae2('0x1e'),{'type':_0x42a1b4[_0x325ae2('0x9')],'defaultValue':!![]}),_0x437c40[_0x325ae2('0x3c')](_0x325ae2('0x39'),_0x325ae2('0x2d')),_0x437c40[_0x325ae2('0x51')]('mail_servers_in'),_0x437c40['query'](_0x325ae2('0x50')),_0x437c40[_0x325ae2('0x46')](_0x325ae2('0x25')),_0x437c40[_0x325ae2('0x46')](_0x325ae2('0x0')),_0x437c40[_0x325ae2('0x51')](_0x325ae2('0x13')),_0x437c40[_0x325ae2('0x58')]('sms_accounts','phone',{'type':_0x42a1b4[_0x325ae2('0x1c')]}),_0x437c40[_0x325ae2('0x58')](_0x325ae2('0x42'),'accountSid',{'type':_0x42a1b4[_0x325ae2('0x1c')]}),_0x437c40[_0x325ae2('0x58')](_0x325ae2('0x42'),'authToken',{'type':_0x42a1b4['STRING']}),_0x437c40['addColumn']('sms_accounts','key',{'type':_0x42a1b4['STRING'],'allowNull':![]}),_0x437c40[_0x325ae2('0x46')](_0x325ae2('0x2f')),_0x437c40['addColumn'](_0x325ae2('0x10'),_0x325ae2('0x2e'),{'type':_0x42a1b4['STRING'],'allowNull':![]}),_0x437c40[_0x325ae2('0x58')](_0x325ae2('0x32'),_0x325ae2('0x2e'),{'type':_0x42a1b4[_0x325ae2('0x1c')],'allowNull':![]}),_0x437c40[_0x325ae2('0x58')](_0x325ae2('0x14'),_0x325ae2('0x2e'),{'type':_0x42a1b4[_0x325ae2('0x1c')],'allowNull':![]}),_0x437c40[_0x325ae2('0x2a')](_0x2d1cb5);});},'down':function(){}};