server/migrations/2.0.69.js

   1 const a1112_0x54ff=['update\x20voice_extensions\x20set\x20app\x20=\x20\x27ExecIf\x27,\x20appdata\x20=\x20CONCAT(\x27$[${LEN(${PREFIX-CALLERIDALL})}\x20>\x200]?Set(CALLERID(all)=${PREFIX-CALLERIDALL}):Set(\x27,\x20appdata,\x20\x27)\x27)\x20where\x20appdata\x20LIKE\x20CONCAT(\x27CALLERID(all)\x27,\x20\x27%\x27)\x20and\x20type\x20=\x20\x27outbound\x27','then','addIndex\x20%s\x20%s\x20%s','enqueue','changeColumn','prototype','catch','sequelize','renameColumn','UPDATE\x20tools_sounds\x20S1\x20JOIN\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20(SELECT\x20name\x20FROM\x20tools_sounds\x20GROUP\x20BY\x20name\x20HAVING\x20COUNT(id)\x20>\x201)\x20S2\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ON\x20S1.name\x20=\x20S2.name\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20SET\x20S1.name\x20=\x20CONCAT(S1.name,\x20\x27_\x27,\x20LOWER(LPAD(CONV(FLOOR(RAND()*POW(36,6)),\x2010,\x2036),\x206,\x200)))','prefix','tools_sounds','sequence','query','report_jscripty_questions','tail','INTEGER','Removed\x20column\x20%s\x20from\x20%s','dropTable','queryInterface','info','#fafafa','chat_websites','stringify','voice_prefixes','removeColumn','cm_contacts','final','removeIndex','STRING','query\x20%s','DELETE\x20FROM\x20`user_has_voice_prefixes`','exports','Added\x20column\x20%s\x20to\x20%s','table\x20dropped\x20%s','addIndex','migration','report_jscripty_answers','addColumn','../config/logger','VoicePrefixId','answer','finally','messageFontSize','Renamed\x20column\x20from\x20%s\x20to\x20%s\x20on\x20%s','VoiceExtensionId','inspect','TEXT','ALTER\x20TABLE\x20`voice_extensions`\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ADD\x20CONSTRAINT\x20`voice_extensions_ibfk_7`\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20FOREIGN\x20KEY\x20(`VoicePrefixId`)\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20REFERENCES\x20voice_prefixes(`id`)\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ON\x20UPDATE\x20CASCADE\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20ON\x20DELETE\x20CASCADE'];(function(_0x45f804,_0x420269){const _0x54ff2d=function(_0x9d664f){while(--_0x9d664f){_0x45f804['push'](_0x45f804['shift']());}};_0x54ff2d(++_0x420269);}(a1112_0x54ff,0x108));const a1112_0x9d66=function(_0x45f804,_0x420269){_0x45f804=_0x45f804-0x14d;let _0x54ff2d=a1112_0x54ff[_0x45f804];return _0x54ff2d;};const a1112_0x2d0bbd=a1112_0x9d66;'use strict';const util=require('util'),logger=require(a1112_0x2d0bbd(0x161))(a1112_0x2d0bbd(0x15e)),Sequence=function(){};Sequence[a1112_0x2d0bbd(0x170)][a1112_0x2d0bbd(0x16e)]=function(_0x2c6b95){const _0x414911=a1112_0x2d0bbd;this[_0x414911(0x17a)]=this[_0x414911(0x17a)]?this[_0x414911(0x17a)][_0x414911(0x164)](_0x2c6b95):_0x2c6b95();};const Migration=function(_0x17e271){const _0x5d8f09=a1112_0x2d0bbd;this['queryInterface']=_0x17e271,this[_0x5d8f09(0x177)]=new Sequence();};Migration['prototype'][a1112_0x2d0bbd(0x16f)]=function(_0x826163,_0xf6ead5,_0x43830d){const _0x270e10=a1112_0x2d0bbd,_0x5404a6=this;this['sequence'][_0x270e10(0x16e)](function(){const _0xb8d1bf=_0x270e10;return _0x5404a6[_0xb8d1bf(0x14d)][_0xb8d1bf(0x16f)](_0x826163,_0xf6ead5,_0x43830d)[_0xb8d1bf(0x16c)](function(){const _0x336504=_0xb8d1bf;logger[_0x336504(0x14e)]('Changed\x20column\x20%s\x20in\x20table\x20%s',_0xf6ead5,_0x826163);})[_0xb8d1bf(0x171)](function(_0x2bd454){const _0x30fb7e=_0xb8d1bf;logger['info'](JSON[_0x30fb7e(0x151)](_0x2bd454));});});},Migration[a1112_0x2d0bbd(0x170)][a1112_0x2d0bbd(0x160)]=function(_0x45f54f,_0xfdf431,_0x427ad2){const _0x16b106=a1112_0x2d0bbd,_0x32b820=this;this[_0x16b106(0x177)][_0x16b106(0x16e)](function(){const _0x438092=_0x16b106;return _0x32b820[_0x438092(0x14d)]['addColumn'](_0x45f54f,_0xfdf431,_0x427ad2)[_0x438092(0x16c)](function(){const _0x1dbebe=_0x438092;logger[_0x1dbebe(0x14e)](_0x1dbebe(0x15b),_0xfdf431,_0x45f54f);})[_0x438092(0x171)](function(_0x132ea6){const _0x5a27c6=_0x438092;logger['info'](JSON[_0x5a27c6(0x151)](_0x132ea6));});});},Migration[a1112_0x2d0bbd(0x170)][a1112_0x2d0bbd(0x17d)]=function(_0x1f62e5){const _0x302968=a1112_0x2d0bbd,_0x3cfb18=this;this[_0x302968(0x177)]['enqueue'](function(){const _0x97d2bc=_0x302968;return _0x3cfb18['queryInterface'][_0x97d2bc(0x17d)](_0x1f62e5,{'force':!![]})[_0x97d2bc(0x16c)](function(){const _0x2683d=_0x97d2bc;logger['info'](_0x2683d(0x15c),_0x1f62e5);})[_0x97d2bc(0x171)](function(_0x2468f0){const _0x2111d2=_0x97d2bc;logger[_0x2111d2(0x14e)](JSON[_0x2111d2(0x151)](_0x2468f0));});});},Migration[a1112_0x2d0bbd(0x170)][a1112_0x2d0bbd(0x15d)]=function(_0x17a107,_0x5292bb,_0x365416){const _0x26b526=a1112_0x2d0bbd,_0x542bf0=this;this[_0x26b526(0x177)][_0x26b526(0x16e)](function(){const _0x350328=_0x26b526;return _0x542bf0[_0x350328(0x14d)][_0x350328(0x15d)](_0x17a107,_0x5292bb,{'indexName':_0x365416})['then'](function(){const _0x3238a5=_0x350328;logger[_0x3238a5(0x14e)](_0x3238a5(0x16d),_0x17a107,_0x5292bb['join'](','),_0x365416);})[_0x350328(0x171)](function(_0x1e3d12){const _0x9852eb=_0x350328;logger['info'](JSON[_0x9852eb(0x151)](_0x1e3d12));});});},Migration[a1112_0x2d0bbd(0x170)][a1112_0x2d0bbd(0x156)]=function(_0x31ac82,_0x26049e){const _0x3ebac4=a1112_0x2d0bbd,_0x42f069=this;this[_0x3ebac4(0x177)][_0x3ebac4(0x16e)](function(){const _0x7890e6=_0x3ebac4;return _0x42f069[_0x7890e6(0x14d)][_0x7890e6(0x156)](_0x31ac82,_0x26049e)[_0x7890e6(0x16c)](function(){const _0x31fffe=_0x7890e6;logger[_0x31fffe(0x14e)]('removeIndex\x20%s\x20%s',_0x31ac82,_0x26049e);})[_0x7890e6(0x171)](function(_0x4e8791){const _0x1c45d3=_0x7890e6;logger[_0x1c45d3(0x14e)](JSON[_0x1c45d3(0x151)](_0x4e8791));});});},Migration['prototype'][a1112_0x2d0bbd(0x178)]=function(_0x1175da){const _0x266c5a=a1112_0x2d0bbd,_0x11cc80=this;this[_0x266c5a(0x177)][_0x266c5a(0x16e)](function(){const _0x1c132c=_0x266c5a;return _0x11cc80[_0x1c132c(0x14d)][_0x1c132c(0x172)][_0x1c132c(0x178)](_0x1175da)['then'](function(){const _0x31db0b=_0x1c132c;logger[_0x31db0b(0x14e)](_0x31db0b(0x158),_0x1175da);})['catch'](function(_0x4b6807){const _0x3e9e27=_0x1c132c;logger[_0x3e9e27(0x14e)](JSON[_0x3e9e27(0x151)](_0x4b6807));});});},Migration[a1112_0x2d0bbd(0x170)][a1112_0x2d0bbd(0x153)]=function(_0x3c7cc0,_0x987a07){const _0x39e383=a1112_0x2d0bbd,_0x28780d=this;this[_0x39e383(0x177)][_0x39e383(0x16e)](function(){const _0x46cbd7=_0x39e383;return _0x28780d[_0x46cbd7(0x14d)]['removeColumn'](_0x3c7cc0,_0x987a07)[_0x46cbd7(0x16c)](function(){const _0x335542=_0x46cbd7;logger[_0x335542(0x14e)](_0x335542(0x17c),_0x987a07,_0x3c7cc0);})['catch'](function(_0x5f0b68){const _0x1cc6fe=_0x46cbd7;logger['info'](util[_0x1cc6fe(0x168)](_0x5f0b68,{'showHidden':![],'depth':null}));});});},Migration[a1112_0x2d0bbd(0x170)][a1112_0x2d0bbd(0x173)]=function(_0x102827,_0x301487,_0x4f563b){const _0x9f1a2e=a1112_0x2d0bbd,_0x38d2cd=this;this[_0x9f1a2e(0x177)]['enqueue'](function(){const _0x30eb9c=_0x9f1a2e;return _0x38d2cd[_0x30eb9c(0x14d)][_0x30eb9c(0x173)](_0x102827,_0x301487,_0x4f563b)[_0x30eb9c(0x16c)](function(){const _0x2a40e=_0x30eb9c;logger[_0x2a40e(0x14e)](_0x2a40e(0x166),_0x301487,_0x4f563b,_0x102827);})[_0x30eb9c(0x171)](function(_0x26b3e8){const _0x5aaa09=_0x30eb9c;logger[_0x5aaa09(0x14e)](util[_0x5aaa09(0x168)](_0x26b3e8,{'showHidden':![],'depth':null}));});});},Migration[a1112_0x2d0bbd(0x170)][a1112_0x2d0bbd(0x155)]=function(_0x53fc91){const _0x3d26bf=a1112_0x2d0bbd;this[_0x3d26bf(0x177)][_0x3d26bf(0x16e)](function(){return _0x53fc91();});},module[a1112_0x2d0bbd(0x15a)]={'up':function(_0x1985bc,_0x1c2aa2){return new Promise(function(_0x570f4e){const _0x253d0c=a1112_0x9d66,_0x3df649=new Migration(_0x1985bc);_0x3df649[_0x253d0c(0x16f)](_0x253d0c(0x15f),'answer',{'type':_0x1c2aa2[_0x253d0c(0x169)]('long')}),_0x3df649['changeColumn'](_0x253d0c(0x179),_0x253d0c(0x163),{'type':_0x1c2aa2['TEXT']('long')}),_0x3df649[_0x253d0c(0x178)](_0x253d0c(0x174)),_0x3df649[_0x253d0c(0x16f)](_0x253d0c(0x176),'name',{'type':_0x1c2aa2[_0x253d0c(0x157)],'unique':!![],'allowNull':![]}),_0x3df649[_0x253d0c(0x160)]('chat_websites',_0x253d0c(0x165),{'type':_0x1c2aa2[_0x253d0c(0x17b)],'defaultValue':0xc}),_0x3df649[_0x253d0c(0x160)](_0x253d0c(0x150),'backgroundColor',{'type':_0x1c2aa2[_0x253d0c(0x157)],'allowNull':![],'defaultValue':_0x253d0c(0x14f),'validate':{'notEmpty':!![]}}),_0x3df649[_0x253d0c(0x160)](_0x253d0c(0x154),'line',{'type':_0x1c2aa2[_0x253d0c(0x157)]}),_0x3df649[_0x253d0c(0x178)]('DELETE\x20FROM\x20`voice_prefixes`'),_0x3df649[_0x253d0c(0x178)](_0x253d0c(0x159)),_0x3df649['removeIndex'](_0x253d0c(0x152),_0x253d0c(0x175)),_0x3df649[_0x253d0c(0x153)](_0x253d0c(0x152),_0x253d0c(0x175)),_0x3df649[_0x253d0c(0x160)](_0x253d0c(0x152),'callerIdAll',{'type':_0x1c2aa2[_0x253d0c(0x157)]}),_0x3df649[_0x253d0c(0x160)]('voice_prefixes',_0x253d0c(0x167),{'type':_0x1c2aa2[_0x253d0c(0x17b)]}),_0x3df649['addColumn']('voice_extensions',_0x253d0c(0x162),{'type':_0x1c2aa2[_0x253d0c(0x17b)]}),_0x3df649['query'](_0x253d0c(0x16a)),_0x3df649['query'](_0x253d0c(0x16b)),_0x3df649[_0x253d0c(0x160)]('report_call',_0x253d0c(0x175),{'type':_0x1c2aa2[_0x253d0c(0x157)]}),_0x3df649[_0x253d0c(0x155)](_0x570f4e);});},'down':function(){}};