server/migrations/2.0.69.js

   1 const a1109_0x454d=['changeColumn','TEXT','query','inspect','removeIndex','../config/logger','INTEGER','util','name','addIndex\x20%s\x20%s\x20%s','addIndex','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','enqueue','sequelize','final','Added\x20column\x20%s\x20to\x20%s','join','STRING','then','cm_contacts','dropTable','prefix','prototype','renameColumn','addColumn','voice_prefixes','catch','report_call','queryInterface','VoiceExtensionId','table\x20dropped\x20%s','removeIndex\x20%s\x20%s','info','exports','migration','chat_websites','messageFontSize','sequence','callerIdAll','#fafafa','stringify','report_jscripty_questions','VoicePrefixId','tail','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','DELETE\x20FROM\x20`user_has_voice_prefixes`','Removed\x20column\x20%s\x20from\x20%s','long','removeColumn','Renamed\x20column\x20from\x20%s\x20to\x20%s\x20on\x20%s','answer'];(function(_0x346032,_0x356465){const _0x454d11=function(_0x48aa4a){while(--_0x48aa4a){_0x346032['push'](_0x346032['shift']());}};_0x454d11(++_0x356465);}(a1109_0x454d,0xf5));const a1109_0x48aa=function(_0x346032,_0x356465){_0x346032=_0x346032-0x77;let _0x454d11=a1109_0x454d[_0x346032];return _0x454d11;};const a1109_0xb9185a=a1109_0x48aa;'use strict';const util=require(a1109_0xb9185a(0x88)),logger=require(a1109_0xb9185a(0x86))(a1109_0xb9185a(0xa3)),Sequence=function(){};Sequence[a1109_0xb9185a(0x97)][a1109_0xb9185a(0x8d)]=function(_0x5055b0){const _0x1570c9=a1109_0xb9185a;this[_0x1570c9(0x79)]=this['tail']?this[_0x1570c9(0x79)]['finally'](_0x5055b0):_0x5055b0();};const Migration=function(_0xc193c5){this['queryInterface']=_0xc193c5,this['sequence']=new Sequence();};Migration[a1109_0xb9185a(0x97)][a1109_0xb9185a(0x81)]=function(_0x922934,_0x3815f7,_0x408077){const _0x4887b4=a1109_0xb9185a,_0x82126c=this;this[_0x4887b4(0xa6)][_0x4887b4(0x8d)](function(){const _0x588d76=_0x4887b4;return _0x82126c[_0x588d76(0x9d)]['changeColumn'](_0x922934,_0x3815f7,_0x408077)[_0x588d76(0x93)](function(){const _0x56ee93=_0x588d76;logger[_0x56ee93(0xa1)]('Changed\x20column\x20%s\x20in\x20table\x20%s',_0x3815f7,_0x922934);})[_0x588d76(0x9b)](function(_0x307b89){const _0x5613dc=_0x588d76;logger[_0x5613dc(0xa1)](JSON[_0x5613dc(0xa9)](_0x307b89));});});},Migration['prototype'][a1109_0xb9185a(0x99)]=function(_0x114247,_0x28f466,_0x149e5c){const _0x4199fe=a1109_0xb9185a,_0x229529=this;this['sequence'][_0x4199fe(0x8d)](function(){const _0x277023=_0x4199fe;return _0x229529[_0x277023(0x9d)]['addColumn'](_0x114247,_0x28f466,_0x149e5c)[_0x277023(0x93)](function(){const _0x3883b4=_0x277023;logger[_0x3883b4(0xa1)](_0x3883b4(0x90),_0x28f466,_0x114247);})['catch'](function(_0x145fa4){const _0x5081eb=_0x277023;logger[_0x5081eb(0xa1)](JSON[_0x5081eb(0xa9)](_0x145fa4));});});},Migration[a1109_0xb9185a(0x97)][a1109_0xb9185a(0x95)]=function(_0x56a74f){const _0x324b16=a1109_0xb9185a,_0x55f6a5=this;this[_0x324b16(0xa6)][_0x324b16(0x8d)](function(){const _0x141e7c=_0x324b16;return _0x55f6a5[_0x141e7c(0x9d)][_0x141e7c(0x95)](_0x56a74f,{'force':!![]})[_0x141e7c(0x93)](function(){const _0x321d50=_0x141e7c;logger['info'](_0x321d50(0x9f),_0x56a74f);})[_0x141e7c(0x9b)](function(_0x16850b){const _0x2c7add=_0x141e7c;logger[_0x2c7add(0xa1)](JSON['stringify'](_0x16850b));});});},Migration[a1109_0xb9185a(0x97)]['addIndex']=function(_0x47787b,_0xa3eab3,_0x45fa40){const _0x316249=a1109_0xb9185a,_0x133385=this;this[_0x316249(0xa6)]['enqueue'](function(){const _0x4d3a62=_0x316249;return _0x133385[_0x4d3a62(0x9d)][_0x4d3a62(0x8b)](_0x47787b,_0xa3eab3,{'indexName':_0x45fa40})[_0x4d3a62(0x93)](function(){const _0x170ecb=_0x4d3a62;logger[_0x170ecb(0xa1)](_0x170ecb(0x8a),_0x47787b,_0xa3eab3[_0x170ecb(0x91)](','),_0x45fa40);})[_0x4d3a62(0x9b)](function(_0x14c557){const _0x23bbd3=_0x4d3a62;logger[_0x23bbd3(0xa1)](JSON[_0x23bbd3(0xa9)](_0x14c557));});});},Migration[a1109_0xb9185a(0x97)][a1109_0xb9185a(0x85)]=function(_0x11cb0b,_0x578060){const _0x47ade4=a1109_0xb9185a,_0x3f146d=this;this[_0x47ade4(0xa6)][_0x47ade4(0x8d)](function(){const _0x434e05=_0x47ade4;return _0x3f146d[_0x434e05(0x9d)]['removeIndex'](_0x11cb0b,_0x578060)['then'](function(){const _0x6a968f=_0x434e05;logger[_0x6a968f(0xa1)](_0x6a968f(0xa0),_0x11cb0b,_0x578060);})[_0x434e05(0x9b)](function(_0x5b7dd4){const _0x4bc644=_0x434e05;logger[_0x4bc644(0xa1)](JSON['stringify'](_0x5b7dd4));});});},Migration[a1109_0xb9185a(0x97)][a1109_0xb9185a(0x83)]=function(_0x121221){const _0x44dd89=a1109_0xb9185a,_0x501607=this;this[_0x44dd89(0xa6)][_0x44dd89(0x8d)](function(){const _0x501e63=_0x44dd89;return _0x501607[_0x501e63(0x9d)][_0x501e63(0x8e)][_0x501e63(0x83)](_0x121221)[_0x501e63(0x93)](function(){const _0x1d8b0c=_0x501e63;logger[_0x1d8b0c(0xa1)]('query\x20%s',_0x121221);})['catch'](function(_0x1c8d75){const _0x359fdf=_0x501e63;logger[_0x359fdf(0xa1)](JSON[_0x359fdf(0xa9)](_0x1c8d75));});});},Migration[a1109_0xb9185a(0x97)][a1109_0xb9185a(0x7e)]=function(_0x4ba5e1,_0x1698f1){const _0x1043fc=a1109_0xb9185a,_0x5af4cf=this;this[_0x1043fc(0xa6)][_0x1043fc(0x8d)](function(){const _0x4ba382=_0x1043fc;return _0x5af4cf[_0x4ba382(0x9d)][_0x4ba382(0x7e)](_0x4ba5e1,_0x1698f1)[_0x4ba382(0x93)](function(){const _0x22f301=_0x4ba382;logger[_0x22f301(0xa1)](_0x22f301(0x7c),_0x1698f1,_0x4ba5e1);})['catch'](function(_0x18063b){logger['info'](util['inspect'](_0x18063b,{'showHidden':![],'depth':null}));});});},Migration[a1109_0xb9185a(0x97)][a1109_0xb9185a(0x98)]=function(_0x1d6a42,_0x18734d,_0x436eae){const _0x31e2ff=a1109_0xb9185a,_0x4a43b1=this;this['sequence'][_0x31e2ff(0x8d)](function(){const _0x2a5a49=_0x31e2ff;return _0x4a43b1[_0x2a5a49(0x9d)][_0x2a5a49(0x98)](_0x1d6a42,_0x18734d,_0x436eae)[_0x2a5a49(0x93)](function(){const _0x3df954=_0x2a5a49;logger[_0x3df954(0xa1)](_0x3df954(0x7f),_0x18734d,_0x436eae,_0x1d6a42);})[_0x2a5a49(0x9b)](function(_0x52ba3a){const _0x4bc1a1=_0x2a5a49;logger[_0x4bc1a1(0xa1)](util[_0x4bc1a1(0x84)](_0x52ba3a,{'showHidden':![],'depth':null}));});});},Migration[a1109_0xb9185a(0x97)][a1109_0xb9185a(0x8f)]=function(_0x3ad012){const _0x4e8e59=a1109_0xb9185a;this['sequence'][_0x4e8e59(0x8d)](function(){return _0x3ad012();});},module[a1109_0xb9185a(0xa2)]={'up':function(_0xdb6aa2,_0x1d26fd){return new Promise(function(_0x355f06){const _0x5750e0=a1109_0x48aa,_0x13b1ae=new Migration(_0xdb6aa2);_0x13b1ae['changeColumn']('report_jscripty_answers',_0x5750e0(0x80),{'type':_0x1d26fd[_0x5750e0(0x82)](_0x5750e0(0x7d))}),_0x13b1ae[_0x5750e0(0x81)](_0x5750e0(0x77),_0x5750e0(0x80),{'type':_0x1d26fd['TEXT']('long')}),_0x13b1ae[_0x5750e0(0x83)]('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)))'),_0x13b1ae['changeColumn']('tools_sounds',_0x5750e0(0x89),{'type':_0x1d26fd[_0x5750e0(0x92)],'unique':!![],'allowNull':![]}),_0x13b1ae[_0x5750e0(0x99)](_0x5750e0(0xa4),_0x5750e0(0xa5),{'type':_0x1d26fd[_0x5750e0(0x87)],'defaultValue':0xc}),_0x13b1ae[_0x5750e0(0x99)](_0x5750e0(0xa4),'backgroundColor',{'type':_0x1d26fd[_0x5750e0(0x92)],'allowNull':![],'defaultValue':_0x5750e0(0xa8),'validate':{'notEmpty':!![]}}),_0x13b1ae['addColumn'](_0x5750e0(0x94),'line',{'type':_0x1d26fd[_0x5750e0(0x92)]}),_0x13b1ae[_0x5750e0(0x83)]('DELETE\x20FROM\x20`voice_prefixes`'),_0x13b1ae[_0x5750e0(0x83)](_0x5750e0(0x7b)),_0x13b1ae[_0x5750e0(0x85)]('voice_prefixes','prefix'),_0x13b1ae[_0x5750e0(0x7e)](_0x5750e0(0x9a),'prefix'),_0x13b1ae[_0x5750e0(0x99)](_0x5750e0(0x9a),_0x5750e0(0xa7),{'type':_0x1d26fd[_0x5750e0(0x92)]}),_0x13b1ae[_0x5750e0(0x99)](_0x5750e0(0x9a),_0x5750e0(0x9e),{'type':_0x1d26fd['INTEGER']}),_0x13b1ae[_0x5750e0(0x99)]('voice_extensions',_0x5750e0(0x78),{'type':_0x1d26fd[_0x5750e0(0x87)]}),_0x13b1ae[_0x5750e0(0x83)](_0x5750e0(0x8c)),_0x13b1ae[_0x5750e0(0x83)](_0x5750e0(0x7a)),_0x13b1ae[_0x5750e0(0x99)](_0x5750e0(0x9c),_0x5750e0(0x96),{'type':_0x1d26fd[_0x5750e0(0x92)]}),_0x13b1ae[_0x5750e0(0x8f)](_0x355f06);});},'down':function(){}};