ec0110f3a13c0061ce70733a6c033cbbeed9fe2d
[motion-next.git] / server / migrations / 2.0.34.js
1 const a913_0x334b=['team_has_mail_queues','ALTER\x20TABLE\x20mail_rooms\x20DROP\x20FOREIGN\x20KEY\x20mail_rooms_ibfk_1','enableCustomerWriting','userDisposition','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;','dialRecallInQueue','voice_recordings','Thanks\x20you\x20for\x20your\x20time!','ALTER\x20TABLE\x20mail_messages\x20DROP\x20COLUMN\x20MailMessageId','sendUnmanaged','final','openchannel_accounts','user_has_mail_queues','mail_attachments','ALTER\x20TABLE\x20mail_rooms\x20DROP\x20COLUMN\x20MailAccountId','fax_accounts','Removed\x20column\x20%s\x20from\x20%s','prototype','STRING','INTEGER','autoclose','BOOLEAN','cm_hopper_final','mail_applications','dropTable','active','enableFeedback','recallme','deviceModel','exports','rejectMethod','mail_servers_out','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;','enableUnmanagedNote','osVersion','UNSIGNED','rejectUrl','removeColumn','inspect','fax_attachments','acceptUrl','mail_accounts','waitingMessage','sequence','closeUrl','tail','queryInterface','Skip','custom','acceptMethod','mail_interactions','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_interactions','browserName','sequelize','authToken','ALTER\x20TABLE\x20mail_messages\x20DROP\x20COLUMN\x20MailRoomId','ALTER\x20TABLE\x20mail_messages\x20DROP\x20FOREIGN\x20KEY\x20mail_messages_ibfk_1','cm_hopper_history','Please\x20hold\x20and\x20we\x20will\x20answer\x20your\x20request\x20as\x20soon\x20as\x20possible.','Your\x20request\x20has\x20not\x20been\x20processed.','conditionAgreement','query','addIndex\x20%s\x20%s\x20%s','mail_messages','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;','deviceVendor','phone','dialRecallMeTimeout','Added\x20column\x20%s\x20to\x20%s','voice_queues','signature','mail_rooms','whiteLabel','chat_websites','deviceType','All\x20of\x20our\x20agents\x20are\x20busy\x20at\x20this\x20time.\x20Your\x20chat\x20is\x20very\x20important\x20to\x20us.','closingMessage','timeout','catch','enqueue','info','unmanagedMessage','state','chat_interactions','AttachmentId','mail_dispositions','skipUnmanaged','forwardTranscriptMessage','accountSid','stringify','../config/logger','ALTER\x20TABLE\x20mail_messages\x20DROP\x20COLUMN\x20UserId','then','addColumn','changeColumn','mail_servers_in','ALTER\x20TABLE\x20analytics_extracted_reports\x20DROP\x20FOREIGN\x20KEY\x20analytics_extracted_reports_ibfk_1','Send','key','Changed\x20column\x20%s\x20in\x20table\x20%s','user_has_mail_rooms','sms_accounts','util'];(function(_0x126476,_0x334bae){const _0x41a9d4=function(_0x3b2126){while(--_0x3b2126){_0x126476['push'](_0x126476['shift']());}};_0x41a9d4(++_0x334bae);}(a913_0x334b,0x118));const a913_0x41a9=function(_0x126476,_0x334bae){_0x126476=_0x126476-0x0;let _0x41a9d4=a913_0x334b[_0x126476];return _0x41a9d4;};const _0x120ab7=a913_0x41a9;'use strict';const logger=require(_0x120ab7('0x13'))('migration'),util=require(_0x120ab7('0x1f')),Sequence=function(){};Sequence[_0x120ab7('0x31')][_0x120ab7('0x8')]=function(_0x3b2126){const _0x332c27=_0x120ab7;this[_0x332c27('0x4d')]=this[_0x332c27('0x4d')]?this[_0x332c27('0x4d')]['finally'](_0x3b2126):_0x3b2126();};const Migration=function(_0x5a5e59){const _0x1508b6=_0x120ab7;this['queryInterface']=_0x5a5e59,this[_0x1508b6('0x4b')]=new Sequence();};Migration[_0x120ab7('0x31')][_0x120ab7('0x17')]=function(_0x39c6d3,_0x2d8eac,_0x34dc26){const _0x4cc08b=_0x120ab7,_0x4cdbf7=this;this['sequence'][_0x4cc08b('0x8')](function(){const _0x5bd93d=_0x4cc08b;return _0x4cdbf7[_0x5bd93d('0x4e')]['changeColumn'](_0x39c6d3,_0x2d8eac,_0x34dc26)[_0x5bd93d('0x15')](function(){const _0x2fadf9=_0x5bd93d;logger['info'](_0x2fadf9('0x1c'),_0x2d8eac,_0x39c6d3);})['catch'](function(_0x4b6664){const _0x386733=_0x5bd93d;logger['info'](JSON[_0x386733('0x12')](_0x4b6664));});});},Migration[_0x120ab7('0x31')]['addColumn']=function(_0x1c8e58,_0x18be6f,_0x137293){const _0x3cd4ad=_0x120ab7,_0x175601=this;this[_0x3cd4ad('0x4b')][_0x3cd4ad('0x8')](function(){const _0x29737b=_0x3cd4ad;return _0x175601[_0x29737b('0x4e')]['addColumn'](_0x1c8e58,_0x18be6f,_0x137293)[_0x29737b('0x15')](function(){const _0x2d75bd=_0x29737b;logger['info'](_0x2d75bd('0x65'),_0x18be6f,_0x1c8e58);})[_0x29737b('0x7')](function(_0x3d85bd){const _0x37c65d=_0x29737b;logger[_0x37c65d('0x9')](JSON[_0x37c65d('0x12')](_0x3d85bd));});});},Migration[_0x120ab7('0x31')][_0x120ab7('0x38')]=function(_0x4b6abf){const _0x5bd66c=_0x120ab7,_0x54c8a5=this;this[_0x5bd66c('0x4b')][_0x5bd66c('0x8')](function(){const _0x474469=_0x5bd66c;return _0x54c8a5[_0x474469('0x4e')][_0x474469('0x38')](_0x4b6abf,{'force':!![]})['then'](function(){const _0x227377=_0x474469;logger[_0x227377('0x9')]('table\x20dropped\x20%s',_0x4b6abf);})[_0x474469('0x7')](function(_0x33309d){const _0x21864a=_0x474469;logger[_0x21864a('0x9')](JSON[_0x21864a('0x12')](_0x33309d));});});},Migration[_0x120ab7('0x31')]['addIndex']=function(_0x5bc6f3,_0x157c4a,_0x58bace){const _0x12d930=_0x120ab7,_0xe63c0b=this;this[_0x12d930('0x4b')][_0x12d930('0x8')](function(){const _0x1c6f34=_0x12d930;return _0xe63c0b[_0x1c6f34('0x4e')]['addIndex'](_0x5bc6f3,_0x157c4a,{'indexName':_0x58bace})[_0x1c6f34('0x15')](function(){const _0x309338=_0x1c6f34;logger['info'](_0x309338('0x5f'),_0x5bc6f3,_0x157c4a['join'](','),_0x58bace);})[_0x1c6f34('0x7')](function(_0x2658e4){const _0x163d6f=_0x1c6f34;logger[_0x163d6f('0x9')](JSON[_0x163d6f('0x12')](_0x2658e4));});});},Migration['prototype'][_0x120ab7('0x5e')]=function(_0x173f9e){const _0x3cd339=_0x120ab7,_0x1a8991=this;this[_0x3cd339('0x4b')][_0x3cd339('0x8')](function(){const _0xbab41d=_0x3cd339;return _0x1a8991[_0xbab41d('0x4e')][_0xbab41d('0x56')][_0xbab41d('0x5e')](_0x173f9e)[_0xbab41d('0x15')](function(){const _0x54fe28=_0xbab41d;logger[_0x54fe28('0x9')]('query\x20%s',_0x173f9e);})['catch'](function(_0x338658){const _0x535127=_0xbab41d;logger[_0x535127('0x9')](JSON[_0x535127('0x12')](_0x338658));});});},Migration['prototype']['removeColumn']=function(_0x32c19e,_0x14cca7){const _0x3cdcb6=_0x120ab7,_0x55ed6b=this;this[_0x3cdcb6('0x4b')][_0x3cdcb6('0x8')](function(){const _0x35ab06=_0x3cdcb6;return _0x55ed6b['queryInterface'][_0x35ab06('0x45')](_0x32c19e,_0x14cca7)['then'](function(){const _0x18692f=_0x35ab06;logger[_0x18692f('0x9')](_0x18692f('0x30'),_0x14cca7,_0x32c19e);})[_0x35ab06('0x7')](function(_0x427ceb){const _0x25aa8d=_0x35ab06;logger['info'](util[_0x25aa8d('0x46')](_0x427ceb,{'showHidden':![],'depth':null}));});});},Migration[_0x120ab7('0x31')][_0x120ab7('0x2a')]=function(_0xae930c){const _0x17b141=_0x120ab7;this[_0x17b141('0x4b')]['enqueue'](function(){return _0xae930c();});},module[_0x120ab7('0x3d')]={'up':function(_0x3de9e5,_0x38ffbd){return new Promise(function(_0x454e6a){const _0x2bd4e0=a913_0x41a9,_0xdc1680=new Migration(_0x3de9e5);_0xdc1680['addColumn'](_0x2bd4e0('0x2'),_0x2bd4e0('0x1b'),{'type':_0x38ffbd[_0x2bd4e0('0x32')],'allowNull':![]}),_0xdc1680['addColumn'](_0x2bd4e0('0x2'),_0x2bd4e0('0x10'),{'type':_0x38ffbd[_0x2bd4e0('0x32')]}),_0xdc1680[_0x2bd4e0('0x16')](_0x2bd4e0('0x2'),'skipMessageButton',{'type':_0x38ffbd[_0x2bd4e0('0x32')],'defaultValue':_0x2bd4e0('0x4f')}),_0xdc1680[_0x2bd4e0('0x16')](_0x2bd4e0('0x2'),_0x2bd4e0('0x3a'),{'type':_0x38ffbd[_0x2bd4e0('0x35')],'defaultValue':![]}),_0xdc1680[_0x2bd4e0('0x16')]('chat_websites',_0x2bd4e0('0x22'),{'type':_0x38ffbd[_0x2bd4e0('0x35')],'defaultValue':![]}),_0xdc1680[_0x2bd4e0('0x16')](_0x2bd4e0('0x2'),_0x2bd4e0('0x5d'),{'type':_0x38ffbd['BOOLEAN'],'defaultValue':![]}),_0xdc1680[_0x2bd4e0('0x16')](_0x2bd4e0('0x2'),'waitingTitle',{'type':_0x38ffbd[_0x2bd4e0('0x32')],'defaultValue':_0x2bd4e0('0x4')}),_0xdc1680[_0x2bd4e0('0x16')]('chat_websites',_0x2bd4e0('0x4a'),{'type':_0x38ffbd[_0x2bd4e0('0x32')],'defaultValue':_0x2bd4e0('0x5b')}),_0xdc1680[_0x2bd4e0('0x16')](_0x2bd4e0('0x2'),_0x2bd4e0('0x34'),{'type':_0x38ffbd['BOOLEAN'],'defaultValue':!![]}),_0xdc1680[_0x2bd4e0('0x16')](_0x2bd4e0('0x2'),_0x2bd4e0('0xa'),{'type':_0x38ffbd[_0x2bd4e0('0x32')],'defaultValue':_0x2bd4e0('0x5c')}),_0xdc1680[_0x2bd4e0('0x16')](_0x2bd4e0('0x2'),_0x2bd4e0('0x41'),{'type':_0x38ffbd[_0x2bd4e0('0x35')],'defaultValue':!![]}),_0xdc1680['addColumn']('chat_websites',_0x2bd4e0('0x29'),{'type':_0x38ffbd[_0x2bd4e0('0x32')],'defaultValue':_0x2bd4e0('0x1a')}),_0xdc1680[_0x2bd4e0('0x16')](_0x2bd4e0('0x2'),_0x2bd4e0('0xf'),{'type':_0x38ffbd[_0x2bd4e0('0x32')],'defaultValue':_0x2bd4e0('0x4f')}),_0xdc1680[_0x2bd4e0('0x17')](_0x2bd4e0('0x2'),_0x2bd4e0('0x5'),{'type':_0x38ffbd[_0x2bd4e0('0x32')],'defaultValue':_0x2bd4e0('0x27')}),_0xdc1680[_0x2bd4e0('0x16')](_0x2bd4e0('0xc'),_0x2bd4e0('0x55'),{'type':_0x38ffbd[_0x2bd4e0('0x32')]}),_0xdc1680['addColumn']('chat_interactions','browserVersion',{'type':_0x38ffbd[_0x2bd4e0('0x32')]}),_0xdc1680[_0x2bd4e0('0x16')](_0x2bd4e0('0xc'),'osName',{'type':_0x38ffbd[_0x2bd4e0('0x32')]}),_0xdc1680[_0x2bd4e0('0x16')](_0x2bd4e0('0xc'),_0x2bd4e0('0x42'),{'type':_0x38ffbd[_0x2bd4e0('0x32')]}),_0xdc1680[_0x2bd4e0('0x16')]('chat_interactions',_0x2bd4e0('0x3c'),{'type':_0x38ffbd[_0x2bd4e0('0x32')]}),_0xdc1680['addColumn']('chat_interactions',_0x2bd4e0('0x62'),{'type':_0x38ffbd[_0x2bd4e0('0x32')]}),_0xdc1680['addColumn'](_0x2bd4e0('0xc'),_0x2bd4e0('0x3'),{'type':_0x38ffbd[_0x2bd4e0('0x32')]}),_0xdc1680['addColumn']('chat_messages',_0x2bd4e0('0xd'),{'type':_0x38ffbd['INTEGER']}),_0xdc1680['query'](_0x2bd4e0('0x53')),_0xdc1680[_0x2bd4e0('0x16')](_0x2bd4e0('0x66'),_0x2bd4e0('0x64'),{'type':_0x38ffbd[_0x2bd4e0('0x33')](0x5)[_0x2bd4e0('0x43')],'defaultValue':0x1e}),_0xdc1680[_0x2bd4e0('0x16')](_0x2bd4e0('0x66'),_0x2bd4e0('0x25'),{'type':_0x38ffbd['BOOLEAN'],'defaultValue':![]}),_0xdc1680[_0x2bd4e0('0x16')]('cm_hopper',_0x2bd4e0('0x3b'),{'type':_0x38ffbd[_0x2bd4e0('0x35')],'defaultValue':![]}),_0xdc1680[_0x2bd4e0('0x16')](_0x2bd4e0('0x36'),_0x2bd4e0('0x3b'),{'type':_0x38ffbd[_0x2bd4e0('0x35')],'defaultValue':![]}),_0xdc1680[_0x2bd4e0('0x16')](_0x2bd4e0('0x5a'),_0x2bd4e0('0x3b'),{'type':_0x38ffbd[_0x2bd4e0('0x35')],'defaultValue':![]}),_0xdc1680[_0x2bd4e0('0x16')](_0x2bd4e0('0x26'),_0x2bd4e0('0x23'),{'type':_0x38ffbd[_0x2bd4e0('0x32')]}),_0xdc1680[_0x2bd4e0('0x38')](_0x2bd4e0('0x1d')),_0xdc1680[_0x2bd4e0('0x5e')](_0x2bd4e0('0x21')),_0xdc1680[_0x2bd4e0('0x5e')](_0x2bd4e0('0x2e')),_0xdc1680[_0x2bd4e0('0x38')](_0x2bd4e0('0x0')),_0xdc1680['query'](_0x2bd4e0('0x19')),_0xdc1680[_0x2bd4e0('0x5e')](_0x2bd4e0('0x28')),_0xdc1680[_0x2bd4e0('0x5e')](_0x2bd4e0('0x59')),_0xdc1680[_0x2bd4e0('0x5e')](_0x2bd4e0('0x58')),_0xdc1680[_0x2bd4e0('0x5e')]('ALTER\x20TABLE\x20mail_messages\x20DROP\x20FOREIGN\x20KEY\x20mail_messages_ibfk_2'),_0xdc1680[_0x2bd4e0('0x5e')](_0x2bd4e0('0x14')),_0xdc1680[_0x2bd4e0('0x38')](_0x2bd4e0('0x60')),_0xdc1680[_0x2bd4e0('0x38')](_0x2bd4e0('0x2d')),_0xdc1680[_0x2bd4e0('0x38')](_0x2bd4e0('0xe')),_0xdc1680[_0x2bd4e0('0x38')](_0x2bd4e0('0x37')),_0xdc1680[_0x2bd4e0('0x38')](_0x2bd4e0('0x54')),_0xdc1680[_0x2bd4e0('0x38')](_0x2bd4e0('0x52')),_0xdc1680[_0x2bd4e0('0x38')](_0x2bd4e0('0x20')),_0xdc1680[_0x2bd4e0('0x38')](_0x2bd4e0('0x2c')),_0xdc1680[_0x2bd4e0('0x38')]('mail_queues'),_0xdc1680[_0x2bd4e0('0x45')](_0x2bd4e0('0x49'),'fidelity'),_0xdc1680[_0x2bd4e0('0x45')](_0x2bd4e0('0x49'),_0x2bd4e0('0x6')),_0xdc1680[_0x2bd4e0('0x45')]('mail_accounts',_0x2bd4e0('0x1')),_0xdc1680[_0x2bd4e0('0x45')](_0x2bd4e0('0x49'),_0x2bd4e0('0x48')),_0xdc1680[_0x2bd4e0('0x45')](_0x2bd4e0('0x49'),_0x2bd4e0('0x44')),_0xdc1680[_0x2bd4e0('0x45')](_0x2bd4e0('0x49'),_0x2bd4e0('0x51')),_0xdc1680[_0x2bd4e0('0x45')](_0x2bd4e0('0x49'),_0x2bd4e0('0x3e')),_0xdc1680[_0x2bd4e0('0x45')](_0x2bd4e0('0x49'),'actions'),_0xdc1680[_0x2bd4e0('0x45')](_0x2bd4e0('0x49'),_0x2bd4e0('0x4c')),_0xdc1680[_0x2bd4e0('0x45')](_0x2bd4e0('0x49'),'closeMethod'),_0xdc1680[_0x2bd4e0('0x45')]('mail_accounts',_0x2bd4e0('0x67')),_0xdc1680[_0x2bd4e0('0x45')](_0x2bd4e0('0x49'),_0x2bd4e0('0x50')),_0xdc1680[_0x2bd4e0('0x16')]('mail_accounts',_0x2bd4e0('0x39'),{'type':_0x38ffbd['BOOLEAN'],'defaultValue':!![]}),_0xdc1680[_0x2bd4e0('0x45')](_0x2bd4e0('0x3f'),_0x2bd4e0('0xb')),_0xdc1680[_0x2bd4e0('0x38')](_0x2bd4e0('0x18')),_0xdc1680[_0x2bd4e0('0x5e')](_0x2bd4e0('0x24')),_0xdc1680[_0x2bd4e0('0x5e')](_0x2bd4e0('0x61')),_0xdc1680[_0x2bd4e0('0x5e')](_0x2bd4e0('0x40')),_0xdc1680[_0x2bd4e0('0x38')](_0x2bd4e0('0x47')),_0xdc1680['addColumn'](_0x2bd4e0('0x1e'),_0x2bd4e0('0x63'),{'type':_0x38ffbd[_0x2bd4e0('0x32')]}),_0xdc1680[_0x2bd4e0('0x16')](_0x2bd4e0('0x1e'),_0x2bd4e0('0x11'),{'type':_0x38ffbd[_0x2bd4e0('0x32')]}),_0xdc1680[_0x2bd4e0('0x16')](_0x2bd4e0('0x1e'),_0x2bd4e0('0x57'),{'type':_0x38ffbd[_0x2bd4e0('0x32')]}),_0xdc1680[_0x2bd4e0('0x16')](_0x2bd4e0('0x1e'),_0x2bd4e0('0x1b'),{'type':_0x38ffbd[_0x2bd4e0('0x32')],'allowNull':![]}),_0xdc1680['query']('ALTER\x20TABLE\x20users\x20CONVERT\x20TO\x20CHARACTER\x20SET\x20utf8\x20COLLATE\x20utf8_bin;'),_0xdc1680[_0x2bd4e0('0x16')](_0x2bd4e0('0x2b'),_0x2bd4e0('0x1b'),{'type':_0x38ffbd['STRING'],'allowNull':![]}),_0xdc1680[_0x2bd4e0('0x16')](_0x2bd4e0('0x2f'),_0x2bd4e0('0x1b'),{'type':_0x38ffbd[_0x2bd4e0('0x32')],'allowNull':![]}),_0xdc1680[_0x2bd4e0('0x16')](_0x2bd4e0('0x49'),_0x2bd4e0('0x1b'),{'type':_0x38ffbd[_0x2bd4e0('0x32')],'allowNull':![]}),_0xdc1680[_0x2bd4e0('0x2a')](_0x454e6a);});},'down':function(){}};