server/migrations/2.0.69.js

   1 const a948_0x470d=['addColumn','prefix','changeColumn','catch','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','prototype','stringify','DELETE\x20FROM\x20`voice_prefixes`','VoiceExtensionId','TEXT','removeColumn','voice_prefixes','report_jscripty_questions','voice_extensions','info','finally','tools_sounds','migration','line','INTEGER','query\x20%s','../config/logger','final','sequelize','Renamed\x20column\x20from\x20%s\x20to\x20%s\x20on\x20%s','cm_contacts','table\x20dropped\x20%s','then','VoicePrefixId','removeIndex','report_call','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','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)))','dropTable','callerIdAll','chat_websites','STRING','messageFontSize','sequence','util','addIndex','long','exports','Changed\x20column\x20%s\x20in\x20table\x20%s','tail','inspect','report_jscripty_answers','addIndex\x20%s\x20%s\x20%s','enqueue','query','answer','Removed\x20column\x20%s\x20from\x20%s','renameColumn','queryInterface'];(function(_0x6385ef,_0x470d0f){const _0x5e4bb2=function(_0x3bbbe4){while(--_0x3bbbe4){_0x6385ef['push'](_0x6385ef['shift']());}};_0x5e4bb2(++_0x470d0f);}(a948_0x470d,0x164));const a948_0x5e4b=function(_0x6385ef,_0x470d0f){_0x6385ef=_0x6385ef-0x0;let _0x5e4bb2=a948_0x470d[_0x6385ef];return _0x5e4bb2;};const _0xb1489a=a948_0x5e4b;'use strict';const util=require(_0xb1489a('0x7')),logger=require(_0xb1489a('0x2b'))(_0xb1489a('0x27')),Sequence=function(){};Sequence[_0xb1489a('0x1b')][_0xb1489a('0x10')]=function(_0x3bbbe4){const _0x595170=_0xb1489a;this['tail']=this['tail']?this[_0x595170('0xc')][_0x595170('0x25')](_0x3bbbe4):_0x3bbbe4();};const Migration=function(_0x45cad9){const _0x48a402=_0xb1489a;this[_0x48a402('0x15')]=_0x45cad9,this['sequence']=new Sequence();};Migration[_0xb1489a('0x1b')]['changeColumn']=function(_0x5d6018,_0x47b3b5,_0x1ae971){const _0x14701e=_0xb1489a,_0x202d8f=this;this[_0x14701e('0x6')]['enqueue'](function(){const _0x30a891=_0x14701e;return _0x202d8f[_0x30a891('0x15')][_0x30a891('0x18')](_0x5d6018,_0x47b3b5,_0x1ae971)[_0x30a891('0x31')](function(){const _0x4d9e1f=_0x30a891;logger[_0x4d9e1f('0x24')](_0x4d9e1f('0xb'),_0x47b3b5,_0x5d6018);})[_0x30a891('0x19')](function(_0x3d2932){const _0x549f16=_0x30a891;logger[_0x549f16('0x24')](JSON[_0x549f16('0x1c')](_0x3d2932));});});},Migration['prototype'][_0xb1489a('0x16')]=function(_0x54b2c0,_0x5f28d1,_0x3f9ebe){const _0x58ae88=_0xb1489a,_0x33082b=this;this[_0x58ae88('0x6')][_0x58ae88('0x10')](function(){const _0xe157e2=_0x58ae88;return _0x33082b[_0xe157e2('0x15')][_0xe157e2('0x16')](_0x54b2c0,_0x5f28d1,_0x3f9ebe)[_0xe157e2('0x31')](function(){const _0x609b7e=_0xe157e2;logger[_0x609b7e('0x24')]('Added\x20column\x20%s\x20to\x20%s',_0x5f28d1,_0x54b2c0);})['catch'](function(_0x8703ef){const _0x1e8151=_0xe157e2;logger[_0x1e8151('0x24')](JSON[_0x1e8151('0x1c')](_0x8703ef));});});},Migration[_0xb1489a('0x1b')][_0xb1489a('0x1')]=function(_0x3b7a17){const _0x3f0347=_0xb1489a,_0x4d098d=this;this[_0x3f0347('0x6')][_0x3f0347('0x10')](function(){const _0x1f4a7e=_0x3f0347;return _0x4d098d[_0x1f4a7e('0x15')][_0x1f4a7e('0x1')](_0x3b7a17,{'force':!![]})[_0x1f4a7e('0x31')](function(){const _0x4dc9dc=_0x1f4a7e;logger['info'](_0x4dc9dc('0x30'),_0x3b7a17);})[_0x1f4a7e('0x19')](function(_0x190be9){const _0x2eea54=_0x1f4a7e;logger[_0x2eea54('0x24')](JSON[_0x2eea54('0x1c')](_0x190be9));});});},Migration[_0xb1489a('0x1b')][_0xb1489a('0x8')]=function(_0x806964,_0x401224,_0x233228){const _0x5eca2f=_0xb1489a,_0xadbe8c=this;this[_0x5eca2f('0x6')][_0x5eca2f('0x10')](function(){const _0x7bac83=_0x5eca2f;return _0xadbe8c[_0x7bac83('0x15')][_0x7bac83('0x8')](_0x806964,_0x401224,{'indexName':_0x233228})[_0x7bac83('0x31')](function(){const _0x2d4d7a=_0x7bac83;logger['info'](_0x2d4d7a('0xf'),_0x806964,_0x401224['join'](','),_0x233228);})[_0x7bac83('0x19')](function(_0x1aebba){const _0x3bc7ab=_0x7bac83;logger[_0x3bc7ab('0x24')](JSON[_0x3bc7ab('0x1c')](_0x1aebba));});});},Migration[_0xb1489a('0x1b')][_0xb1489a('0x33')]=function(_0x55c633,_0x4f4387){const _0x45ea54=_0xb1489a,_0x223ffa=this;this[_0x45ea54('0x6')][_0x45ea54('0x10')](function(){const _0x3b5a85=_0x45ea54;return _0x223ffa['queryInterface'][_0x3b5a85('0x33')](_0x55c633,_0x4f4387)['then'](function(){logger['info']('removeIndex\x20%s\x20%s',_0x55c633,_0x4f4387);})['catch'](function(_0x585520){const _0x166fa1=_0x3b5a85;logger[_0x166fa1('0x24')](JSON[_0x166fa1('0x1c')](_0x585520));});});},Migration[_0xb1489a('0x1b')][_0xb1489a('0x11')]=function(_0x1f9ecb){const _0x40a5bf=_0xb1489a,_0x97665c=this;this[_0x40a5bf('0x6')][_0x40a5bf('0x10')](function(){const _0x1e129a=_0x40a5bf;return _0x97665c[_0x1e129a('0x15')][_0x1e129a('0x2d')]['query'](_0x1f9ecb)[_0x1e129a('0x31')](function(){const _0x35016a=_0x1e129a;logger['info'](_0x35016a('0x2a'),_0x1f9ecb);})['catch'](function(_0x4306fd){const _0x1e1d04=_0x1e129a;logger[_0x1e1d04('0x24')](JSON[_0x1e1d04('0x1c')](_0x4306fd));});});},Migration['prototype']['removeColumn']=function(_0x55de17,_0x46609f){const _0x2cc21e=_0xb1489a,_0x5021e7=this;this['sequence'][_0x2cc21e('0x10')](function(){const _0x205e3b=_0x2cc21e;return _0x5021e7[_0x205e3b('0x15')][_0x205e3b('0x20')](_0x55de17,_0x46609f)[_0x205e3b('0x31')](function(){const _0x341e87=_0x205e3b;logger[_0x341e87('0x24')](_0x341e87('0x13'),_0x46609f,_0x55de17);})[_0x205e3b('0x19')](function(_0x4804cd){const _0x536f64=_0x205e3b;logger['info'](util[_0x536f64('0xd')](_0x4804cd,{'showHidden':![],'depth':null}));});});},Migration[_0xb1489a('0x1b')][_0xb1489a('0x14')]=function(_0x466cff,_0x6b6dac,_0x5b56f6){const _0x8eb269=this;this['sequence']['enqueue'](function(){const _0x4e7cb2=a948_0x5e4b;return _0x8eb269[_0x4e7cb2('0x15')][_0x4e7cb2('0x14')](_0x466cff,_0x6b6dac,_0x5b56f6)[_0x4e7cb2('0x31')](function(){const _0x18da88=_0x4e7cb2;logger[_0x18da88('0x24')](_0x18da88('0x2e'),_0x6b6dac,_0x5b56f6,_0x466cff);})[_0x4e7cb2('0x19')](function(_0x49462b){const _0xd2fcf9=_0x4e7cb2;logger['info'](util[_0xd2fcf9('0xd')](_0x49462b,{'showHidden':![],'depth':null}));});});},Migration[_0xb1489a('0x1b')][_0xb1489a('0x2c')]=function(_0x4d0e3c){const _0x364f27=_0xb1489a;this['sequence'][_0x364f27('0x10')](function(){return _0x4d0e3c();});},module[_0xb1489a('0xa')]={'up':function(_0x22a2e2,_0x1f3dae){return new Promise(function(_0x23b3b0){const _0x3dbe6f=a948_0x5e4b,_0x1f1b24=new Migration(_0x22a2e2);_0x1f1b24['changeColumn'](_0x3dbe6f('0xe'),_0x3dbe6f('0x12'),{'type':_0x1f3dae[_0x3dbe6f('0x1f')](_0x3dbe6f('0x9'))}),_0x1f1b24[_0x3dbe6f('0x18')](_0x3dbe6f('0x22'),_0x3dbe6f('0x12'),{'type':_0x1f3dae[_0x3dbe6f('0x1f')](_0x3dbe6f('0x9'))}),_0x1f1b24['query'](_0x3dbe6f('0x0')),_0x1f1b24[_0x3dbe6f('0x18')](_0x3dbe6f('0x26'),'name',{'type':_0x1f3dae['STRING'],'unique':!![],'allowNull':![]}),_0x1f1b24[_0x3dbe6f('0x16')](_0x3dbe6f('0x3'),_0x3dbe6f('0x5'),{'type':_0x1f3dae[_0x3dbe6f('0x29')],'defaultValue':0xc}),_0x1f1b24[_0x3dbe6f('0x16')]('chat_websites','backgroundColor',{'type':_0x1f3dae[_0x3dbe6f('0x4')],'allowNull':![],'defaultValue':'#fafafa','validate':{'notEmpty':!![]}}),_0x1f1b24[_0x3dbe6f('0x16')](_0x3dbe6f('0x2f'),_0x3dbe6f('0x28'),{'type':_0x1f3dae[_0x3dbe6f('0x4')]}),_0x1f1b24[_0x3dbe6f('0x11')](_0x3dbe6f('0x1d')),_0x1f1b24['query']('DELETE\x20FROM\x20`user_has_voice_prefixes`'),_0x1f1b24[_0x3dbe6f('0x33')](_0x3dbe6f('0x21'),_0x3dbe6f('0x17')),_0x1f1b24[_0x3dbe6f('0x20')](_0x3dbe6f('0x21'),_0x3dbe6f('0x17')),_0x1f1b24[_0x3dbe6f('0x16')](_0x3dbe6f('0x21'),_0x3dbe6f('0x2'),{'type':_0x1f3dae['STRING']}),_0x1f1b24[_0x3dbe6f('0x16')](_0x3dbe6f('0x21'),_0x3dbe6f('0x1e'),{'type':_0x1f3dae[_0x3dbe6f('0x29')]}),_0x1f1b24[_0x3dbe6f('0x16')](_0x3dbe6f('0x23'),_0x3dbe6f('0x32'),{'type':_0x1f3dae['INTEGER']}),_0x1f1b24[_0x3dbe6f('0x11')](_0x3dbe6f('0x35')),_0x1f1b24[_0x3dbe6f('0x11')](_0x3dbe6f('0x1a')),_0x1f1b24[_0x3dbe6f('0x16')](_0x3dbe6f('0x34'),_0x3dbe6f('0x17'),{'type':_0x1f3dae[_0x3dbe6f('0x4')]}),_0x1f1b24[_0x3dbe6f('0x2c')](_0x23b3b0);});},'down':function(){}};