bfd6d85e6061293f859a50315af76f490f94082f
[motion-next.git] / server / migrations / 2.0.34.js
1 const a913_0x42c7=['authToken','deviceVendor','voice_recordings','custom','mail_servers_in','sendUnmanaged','signature','join','then','addColumn','closeMethod','closingMessage','voice_queues','mail_messages','conditionAgreement','query','osVersion','fax_attachments','ALTER\x20TABLE\x20mail_messages\x20DROP\x20COLUMN\x20MailRoomId','../config/logger','stringify','ALTER\x20TABLE\x20mail_messages\x20DROP\x20FOREIGN\x20KEY\x20mail_messages_ibfk_2','inspect','enableCustomerWriting','fidelity','cm_hopper_history','forwardTranscriptMessage','STRING','dialRecallInQueue','exports','final','mail_accounts','addIndex\x20%s\x20%s\x20%s','chat_interactions','phone','ALTER\x20TABLE\x20mail_messages\x20DROP\x20FOREIGN\x20KEY\x20mail_messages_ibfk_1','tail','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','table\x20dropped\x20%s','All\x20of\x20our\x20agents\x20are\x20busy\x20at\x20this\x20time.\x20Your\x20chat\x20is\x20very\x20important\x20to\x20us.','ALTER\x20TABLE\x20analytics_extracted_reports\x20DROP\x20FOREIGN\x20KEY\x20analytics_extracted_reports_ibfk_1','query\x20%s','ALTER\x20TABLE\x20mail_rooms\x20DROP\x20COLUMN\x20MailAccountId','userDisposition','mail_applications','util','closeUrl','enableUnmanagedNote','sequence','BOOLEAN','Send','ALTER\x20TABLE\x20mail_rooms\x20DROP\x20FOREIGN\x20KEY\x20mail_rooms_ibfk_1','acceptUrl','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;','active','Please\x20hold\x20and\x20we\x20will\x20answer\x20your\x20request\x20as\x20soon\x20as\x20possible.','migration','addIndex','waitingMessage','dropTable','dialRecallMeTimeout','user_has_mail_rooms','cm_hopper_final','chat_messages','autoclose','recallme','removeColumn','queryInterface','rejectMethod','user_has_mail_queues','prototype','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;','Changed\x20column\x20%s\x20in\x20table\x20%s','ALTER\x20TABLE\x20users\x20CONVERT\x20TO\x20CHARACTER\x20SET\x20utf8\x20COLLATE\x20utf8_bin;','skipUnmanaged','browserVersion','rejectUrl','whiteLabel','mail_attachments','unmanagedMessage','enqueue','enableFeedback','user_has_mail_interactions','catch','INTEGER','mail_servers_out','AttachmentId','mail_queues','Skip','actions','chat_websites','finally','ALTER\x20TABLE\x20mail_messages\x20DROP\x20COLUMN\x20MailMessageId','changeColumn','sms_accounts','key','ALTER\x20TABLE\x20mail_messages\x20DROP\x20COLUMN\x20UserId','info'];(function(_0x24b062,_0x42c789){const _0x3f680b=function(_0x2477db){while(--_0x2477db){_0x24b062['push'](_0x24b062['shift']());}};_0x3f680b(++_0x42c789);}(a913_0x42c7,0x74));const a913_0x3f68=function(_0x24b062,_0x42c789){_0x24b062=_0x24b062-0x0;let _0x3f680b=a913_0x42c7[_0x24b062];return _0x3f680b;};const _0x13c128=a913_0x3f68;'use strict';const logger=require(_0x13c128('0x2'))(_0x13c128('0x28')),util=require(_0x13c128('0x1d')),Sequence=function(){};Sequence[_0x13c128('0x36')][_0x13c128('0x40')]=function(_0x2477db){const _0xefbd9=_0x13c128;this[_0xefbd9('0x13')]=this[_0xefbd9('0x13')]?this[_0xefbd9('0x13')][_0xefbd9('0x4b')](_0x2477db):_0x2477db();};const Migration=function(_0x1dbd4b){const _0x5538ed=_0x13c128;this[_0x5538ed('0x33')]=_0x1dbd4b,this['sequence']=new Sequence();};Migration[_0x13c128('0x36')][_0x13c128('0x4d')]=function(_0x5c9d47,_0x61f6aa,_0x4e6b28){const _0x4686b9=_0x13c128,_0x1b6adb=this;this[_0x4686b9('0x20')][_0x4686b9('0x40')](function(){const _0x371683=_0x4686b9;return _0x1b6adb[_0x371683('0x33')][_0x371683('0x4d')](_0x5c9d47,_0x61f6aa,_0x4e6b28)[_0x371683('0x5a')](function(){const _0x1d9715=_0x371683;logger[_0x1d9715('0x51')](_0x1d9715('0x38'),_0x61f6aa,_0x5c9d47);})[_0x371683('0x43')](function(_0x5eb09a){const _0x2d6ea4=_0x371683;logger['info'](JSON[_0x2d6ea4('0x3')](_0x5eb09a));});});},Migration[_0x13c128('0x36')][_0x13c128('0x5b')]=function(_0x4f0991,_0x50cfcd,_0xca5c71){const _0x2173e3=_0x13c128,_0x1153ac=this;this['sequence'][_0x2173e3('0x40')](function(){const _0x22ba06=_0x2173e3;return _0x1153ac['queryInterface'][_0x22ba06('0x5b')](_0x4f0991,_0x50cfcd,_0xca5c71)[_0x22ba06('0x5a')](function(){const _0x5a28ca=_0x22ba06;logger[_0x5a28ca('0x51')]('Added\x20column\x20%s\x20to\x20%s',_0x50cfcd,_0x4f0991);})['catch'](function(_0x585d17){const _0x2b0e00=_0x22ba06;logger[_0x2b0e00('0x51')](JSON[_0x2b0e00('0x3')](_0x585d17));});});},Migration['prototype'][_0x13c128('0x2b')]=function(_0x5dcd57){const _0x32679a=_0x13c128,_0x1d0093=this;this[_0x32679a('0x20')][_0x32679a('0x40')](function(){const _0x5f2674=_0x32679a;return _0x1d0093['queryInterface'][_0x5f2674('0x2b')](_0x5dcd57,{'force':!![]})[_0x5f2674('0x5a')](function(){const _0x11a728=_0x5f2674;logger[_0x11a728('0x51')](_0x11a728('0x16'),_0x5dcd57);})[_0x5f2674('0x43')](function(_0x2680e4){const _0xe6c848=_0x5f2674;logger[_0xe6c848('0x51')](JSON[_0xe6c848('0x3')](_0x2680e4));});});},Migration[_0x13c128('0x36')][_0x13c128('0x29')]=function(_0x4a33a9,_0x3ba163,_0x1adf2e){const _0x2415d7=_0x13c128,_0x1c78b1=this;this[_0x2415d7('0x20')]['enqueue'](function(){const _0x301d90=_0x2415d7;return _0x1c78b1[_0x301d90('0x33')][_0x301d90('0x29')](_0x4a33a9,_0x3ba163,{'indexName':_0x1adf2e})[_0x301d90('0x5a')](function(){const _0x213587=_0x301d90;logger[_0x213587('0x51')](_0x213587('0xf'),_0x4a33a9,_0x3ba163[_0x213587('0x59')](','),_0x1adf2e);})[_0x301d90('0x43')](function(_0x122e06){const _0x56c185=_0x301d90;logger['info'](JSON[_0x56c185('0x3')](_0x122e06));});});},Migration['prototype'][_0x13c128('0x61')]=function(_0x5c7d50){const _0x39d7cf=_0x13c128,_0x18c243=this;this[_0x39d7cf('0x20')][_0x39d7cf('0x40')](function(){const _0xaf968e=_0x39d7cf;return _0x18c243[_0xaf968e('0x33')]['sequelize'][_0xaf968e('0x61')](_0x5c7d50)['then'](function(){const _0x33096e=_0xaf968e;logger[_0x33096e('0x51')](_0x33096e('0x19'),_0x5c7d50);})[_0xaf968e('0x43')](function(_0x1bc5b1){const _0x55449c=_0xaf968e;logger['info'](JSON[_0x55449c('0x3')](_0x1bc5b1));});});},Migration[_0x13c128('0x36')]['removeColumn']=function(_0x502fa7,_0x14589d){const _0x1cfa7f=_0x13c128,_0x246d18=this;this['sequence'][_0x1cfa7f('0x40')](function(){const _0x34e980=_0x1cfa7f;return _0x246d18[_0x34e980('0x33')][_0x34e980('0x32')](_0x502fa7,_0x14589d)[_0x34e980('0x5a')](function(){const _0x548c64=_0x34e980;logger[_0x548c64('0x51')]('Removed\x20column\x20%s\x20from\x20%s',_0x14589d,_0x502fa7);})[_0x34e980('0x43')](function(_0x294cb2){const _0x1cfc14=_0x34e980;logger['info'](util[_0x1cfc14('0x5')](_0x294cb2,{'showHidden':![],'depth':null}));});});},Migration[_0x13c128('0x36')]['final']=function(_0x4e8dbb){const _0x1b3837=_0x13c128;this['sequence'][_0x1b3837('0x40')](function(){return _0x4e8dbb();});},module[_0x13c128('0xc')]={'up':function(_0x388790,_0x4d475e){return new Promise(function(_0x4d7f4e){const _0x400eae=a913_0x3f68,_0xea3293=new Migration(_0x388790);_0xea3293[_0x400eae('0x5b')](_0x400eae('0x4a'),'key',{'type':_0x4d475e['STRING'],'allowNull':![]}),_0xea3293['addColumn'](_0x400eae('0x4a'),_0x400eae('0x9'),{'type':_0x4d475e[_0x400eae('0xa')]}),_0xea3293[_0x400eae('0x5b')](_0x400eae('0x4a'),'skipMessageButton',{'type':_0x4d475e[_0x400eae('0xa')],'defaultValue':_0x400eae('0x48')}),_0xea3293['addColumn'](_0x400eae('0x4a'),_0x400eae('0x41'),{'type':_0x4d475e['BOOLEAN'],'defaultValue':![]}),_0xea3293[_0x400eae('0x5b')](_0x400eae('0x4a'),_0x400eae('0x6'),{'type':_0x4d475e['BOOLEAN'],'defaultValue':![]}),_0xea3293[_0x400eae('0x5b')]('chat_websites',_0x400eae('0x60'),{'type':_0x4d475e[_0x400eae('0x21')],'defaultValue':![]}),_0xea3293[_0x400eae('0x5b')]('chat_websites','waitingTitle',{'type':_0x4d475e[_0x400eae('0xa')],'defaultValue':_0x400eae('0x17')}),_0xea3293[_0x400eae('0x5b')](_0x400eae('0x4a'),_0x400eae('0x2a'),{'type':_0x4d475e[_0x400eae('0xa')],'defaultValue':_0x400eae('0x27')}),_0xea3293['addColumn']('chat_websites',_0x400eae('0x30'),{'type':_0x4d475e['BOOLEAN'],'defaultValue':!![]}),_0xea3293[_0x400eae('0x5b')](_0x400eae('0x4a'),_0x400eae('0x3f'),{'type':_0x4d475e[_0x400eae('0xa')],'defaultValue':'Your\x20request\x20has\x20not\x20been\x20processed.'}),_0xea3293[_0x400eae('0x5b')](_0x400eae('0x4a'),_0x400eae('0x1f'),{'type':_0x4d475e[_0x400eae('0x21')],'defaultValue':!![]}),_0xea3293['addColumn'](_0x400eae('0x4a'),_0x400eae('0x57'),{'type':_0x4d475e[_0x400eae('0xa')],'defaultValue':_0x400eae('0x22')}),_0xea3293['addColumn'](_0x400eae('0x4a'),_0x400eae('0x3a'),{'type':_0x4d475e[_0x400eae('0xa')],'defaultValue':_0x400eae('0x48')}),_0xea3293[_0x400eae('0x4d')]('chat_websites',_0x400eae('0x5d'),{'type':_0x4d475e[_0x400eae('0xa')],'defaultValue':'Thanks\x20you\x20for\x20your\x20time!'}),_0xea3293[_0x400eae('0x5b')](_0x400eae('0x10'),'browserName',{'type':_0x4d475e[_0x400eae('0xa')]}),_0xea3293['addColumn'](_0x400eae('0x10'),_0x400eae('0x3b'),{'type':_0x4d475e['STRING']}),_0xea3293[_0x400eae('0x5b')]('chat_interactions','osName',{'type':_0x4d475e['STRING']}),_0xea3293[_0x400eae('0x5b')](_0x400eae('0x10'),_0x400eae('0x62'),{'type':_0x4d475e[_0x400eae('0xa')]}),_0xea3293[_0x400eae('0x5b')]('chat_interactions','deviceModel',{'type':_0x4d475e[_0x400eae('0xa')]}),_0xea3293['addColumn'](_0x400eae('0x10'),_0x400eae('0x53'),{'type':_0x4d475e[_0x400eae('0xa')]}),_0xea3293[_0x400eae('0x5b')](_0x400eae('0x10'),'deviceType',{'type':_0x4d475e[_0x400eae('0xa')]}),_0xea3293['addColumn'](_0x400eae('0x2f'),_0x400eae('0x46'),{'type':_0x4d475e[_0x400eae('0x44')]}),_0xea3293[_0x400eae('0x61')](_0x400eae('0x15')),_0xea3293[_0x400eae('0x5b')]('voice_queues',_0x400eae('0x2c'),{'type':_0x4d475e[_0x400eae('0x44')](0x5)['UNSIGNED'],'defaultValue':0x1e}),_0xea3293[_0x400eae('0x5b')](_0x400eae('0x5e'),_0x400eae('0xb'),{'type':_0x4d475e[_0x400eae('0x21')],'defaultValue':![]}),_0xea3293[_0x400eae('0x5b')]('cm_hopper',_0x400eae('0x31'),{'type':_0x4d475e[_0x400eae('0x21')],'defaultValue':![]}),_0xea3293[_0x400eae('0x5b')](_0x400eae('0x2e'),_0x400eae('0x31'),{'type':_0x4d475e[_0x400eae('0x21')],'defaultValue':![]}),_0xea3293[_0x400eae('0x5b')](_0x400eae('0x8'),'recallme',{'type':_0x4d475e[_0x400eae('0x21')],'defaultValue':![]}),_0xea3293[_0x400eae('0x5b')](_0x400eae('0x54'),_0x400eae('0x1b'),{'type':_0x4d475e[_0x400eae('0xa')]}),_0xea3293[_0x400eae('0x2b')](_0x400eae('0x2d')),_0xea3293[_0x400eae('0x61')](_0x400eae('0x23')),_0xea3293[_0x400eae('0x61')](_0x400eae('0x1a')),_0xea3293[_0x400eae('0x2b')]('mail_rooms'),_0xea3293[_0x400eae('0x61')](_0x400eae('0x18')),_0xea3293[_0x400eae('0x61')](_0x400eae('0x4c')),_0xea3293[_0x400eae('0x61')](_0x400eae('0x12')),_0xea3293[_0x400eae('0x61')](_0x400eae('0x1')),_0xea3293['query'](_0x400eae('0x4')),_0xea3293['query'](_0x400eae('0x50')),_0xea3293['dropTable'](_0x400eae('0x5f')),_0xea3293['dropTable'](_0x400eae('0x3e')),_0xea3293['dropTable']('mail_dispositions'),_0xea3293[_0x400eae('0x2b')](_0x400eae('0x1c')),_0xea3293['dropTable'](_0x400eae('0x42')),_0xea3293[_0x400eae('0x2b')]('mail_interactions'),_0xea3293[_0x400eae('0x2b')]('team_has_mail_queues'),_0xea3293[_0x400eae('0x2b')](_0x400eae('0x35')),_0xea3293[_0x400eae('0x2b')](_0x400eae('0x47')),_0xea3293[_0x400eae('0x32')](_0x400eae('0xe'),_0x400eae('0x7')),_0xea3293['removeColumn'](_0x400eae('0xe'),'timeout'),_0xea3293['removeColumn'](_0x400eae('0xe'),_0x400eae('0x3d')),_0xea3293['removeColumn']('mail_accounts',_0x400eae('0x24')),_0xea3293[_0x400eae('0x32')](_0x400eae('0xe'),_0x400eae('0x3c')),_0xea3293[_0x400eae('0x32')](_0x400eae('0xe'),'acceptMethod'),_0xea3293[_0x400eae('0x32')](_0x400eae('0xe'),_0x400eae('0x34')),_0xea3293[_0x400eae('0x32')](_0x400eae('0xe'),_0x400eae('0x49')),_0xea3293[_0x400eae('0x32')](_0x400eae('0xe'),_0x400eae('0x1e')),_0xea3293['removeColumn'](_0x400eae('0xe'),_0x400eae('0x5c')),_0xea3293[_0x400eae('0x32')](_0x400eae('0xe'),_0x400eae('0x58')),_0xea3293[_0x400eae('0x32')](_0x400eae('0xe'),_0x400eae('0x55')),_0xea3293[_0x400eae('0x5b')]('mail_accounts',_0x400eae('0x26'),{'type':_0x4d475e[_0x400eae('0x21')],'defaultValue':!![]}),_0xea3293[_0x400eae('0x32')](_0x400eae('0x45'),'state'),_0xea3293[_0x400eae('0x2b')](_0x400eae('0x56')),_0xea3293[_0x400eae('0x61')](_0x400eae('0x25')),_0xea3293[_0x400eae('0x61')](_0x400eae('0x37')),_0xea3293[_0x400eae('0x61')]('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;'),_0xea3293[_0x400eae('0x2b')](_0x400eae('0x0')),_0xea3293['addColumn'](_0x400eae('0x4e'),_0x400eae('0x11'),{'type':_0x4d475e[_0x400eae('0xa')]}),_0xea3293['addColumn']('sms_accounts','accountSid',{'type':_0x4d475e[_0x400eae('0xa')]}),_0xea3293['addColumn'](_0x400eae('0x4e'),_0x400eae('0x52'),{'type':_0x4d475e[_0x400eae('0xa')]}),_0xea3293[_0x400eae('0x5b')]('sms_accounts',_0x400eae('0x4f'),{'type':_0x4d475e[_0x400eae('0xa')],'allowNull':![]}),_0xea3293[_0x400eae('0x61')](_0x400eae('0x39')),_0xea3293[_0x400eae('0x5b')](_0x400eae('0x14'),_0x400eae('0x4f'),{'type':_0x4d475e[_0x400eae('0xa')],'allowNull':![]}),_0xea3293[_0x400eae('0x5b')]('fax_accounts',_0x400eae('0x4f'),{'type':_0x4d475e[_0x400eae('0xa')],'allowNull':![]}),_0xea3293[_0x400eae('0x5b')]('mail_accounts',_0x400eae('0x4f'),{'type':_0x4d475e[_0x400eae('0xa')],'allowNull':![]}),_0xea3293[_0x400eae('0xd')](_0x4d7f4e);});},'down':function(){}};