};
module.exports = {
- up: function(queryInterface, Sequelize) {
- return new BPromise(function(resolve, reject) {
- var migration = new Migration(queryInterface);
- // START SETTINGS
- migration.addColumn('settings', 'defaultPageTitle', {
- type: Sequelize.BOOLEAN,
- defaultValue: true
- });
- migration.addColumn('settings', 'pageTitle', {
- type: Sequelize.STRING
- });
- // END SETTINGS
-
- // START VOICECONTEXT
- migration.checkVoiceContexts();
- // END VOICECONTEXT
-
- // START SALESFORCE CONF
- migration.addColumn('int_salesforce_configurations', 'moduleSearch', {
- type: Sequelize.ENUM('contact_lead', 'contact', 'lead'),
- defaultValue: 'contact_lead'
- });
- migration.addColumn('int_salesforce_configurations', 'moduleCreate', {
- type: Sequelize.ENUM('nothing', 'contact', 'lead'),
- defaultValue: 'lead'
- });
- // END SALESFORCE CONF
-
- // START FAX
- migration.query("INSERT INTO `voice_extensions` (`context`, `exten`, `priority`, `app`, `appdata`, `type`, `description`, `createdAt`, `updatedAt`) VALUES ('from-sip', 'xcally-motion-fax', '1', 'NoOp', '', 'system', 'Fax extensions auto generated', NOW(), NOW());");
-
- migration.query("INSERT INTO `voice_extensions` (`context`, `exten`, `priority`, `app`, `appdata`, `type`, `description`, `createdAt`, `updatedAt`) VALUES ('from-sip', 'xcally-motion-fax', '2', 'Set', 'CDR(type)=outbound-fax', 'system', 'Fax extensions auto generated', NOW(), NOW());");
-
- migration.query("INSERT INTO `voice_extensions` (`context`, `exten`, `priority`, `app`, `appdata`, `type`, `description`, `createdAt`, `updatedAt`) VALUES ('from-sip', 'xcally-motion-fax', '3', 'Wait', '6', 'system', 'Fax extensions auto generated', NOW(), NOW());");
-
- migration.query("INSERT INTO `voice_extensions` (`context`, `exten`, `priority`, `app`, `appdata`, `type`, `description`, `createdAt`, `updatedAt`) VALUES ('from-sip', 'xcally-motion-fax', '4', 'Set', 'FAXOPT(ecm)=${XMF-ECM}', 'system', 'Fax extensions auto generated', NOW(), NOW());");
-
- migration.query("INSERT INTO `voice_extensions` (`context`, `exten`, `priority`, `app`, `appdata`, `type`, `description`, `createdAt`, `updatedAt`) VALUES ('from-sip', 'xcally-motion-fax', '5', 'Set', 'FAXOPT(headerinfo)=${XMF-HEADERINFO}', 'system', 'Fax extensions auto generated', NOW(), NOW());");
-
- migration.query("INSERT INTO `voice_extensions` (`context`, `exten`, `priority`, `app`, `appdata`, `type`, `description`, `createdAt`, `updatedAt`) VALUES ('from-sip', 'xcally-motion-fax', '6', 'Set', 'FAXOPT(localstationid)=${XMF-LOCALSTATIONID}', 'system', 'Fax extensions auto generated', NOW(), NOW());");
-
- migration.query("INSERT INTO `voice_extensions` (`context`, `exten`, `priority`, `app`, `appdata`, `type`, `description`, `createdAt`, `updatedAt`) VALUES ('from-sip', 'xcally-motion-fax', '7', 'Set', 'FAXOPT(maxrate)=${XMF-MAXRATE}', 'system', 'Fax extensions auto generated', NOW(), NOW());");
-
- migration.query("INSERT INTO `voice_extensions` (`context`, `exten`, `priority`, `app`, `appdata`, `type`, `description`, `createdAt`, `updatedAt`) VALUES ('from-sip', 'xcally-motion-fax', '8', 'Set', 'FAXOPT(minrate)=${XMF-MINRATE}', 'system', 'Fax extensions auto generated', NOW(), NOW());");
-
- migration.query("INSERT INTO `voice_extensions` (`context`, `exten`, `priority`, `app`, `appdata`, `type`, `description`, `createdAt`, `updatedAt`) VALUES ('from-sip', 'xcally-motion-fax', '9', 'Set', 'FAXOPT(modem)=${XMF-MODEM}', 'system', 'Fax extensions auto generated', NOW(), NOW());");
-
- migration.query("INSERT INTO `voice_extensions` (`context`, `exten`, `priority`, `app`, `appdata`, `type`, `description`, `createdAt`, `updatedAt`) VALUES ('from-sip', 'xcally-motion-fax', '10', 'Set', 'FAXOPT(t38timeout)=${XMF-T38TIMEOUT}', 'system', 'Fax extensions auto generated', NOW(), NOW());");
-
- migration.query("INSERT INTO `voice_extensions` (`context`, `exten`, `priority`, `app`, `appdata`, `type`, `description`, `createdAt`, `updatedAt`) VALUES ('from-sip', 'xcally-motion-fax', '11', 'SendFax', '${XMF-PATH},d', 'system', 'Fax extensions auto generated', NOW(), NOW());");
-
- exec('chmod 775 /var/opt/motion2/server/files/attachments', function(err, stdout, stderr) {
- logger.info('Exec chmod',' Error :',JSON.stringify(err), stdout, stderr);
- exec('ls -la /var/opt/motion2/server/files', function(err, stdout, stderr) {
- logger.info('Ls :',' Error :',JSON.stringify(err), stdout, stderr);
- });
- });
- // END FAX
-
- // START CONTACT
- migration.addColumn('cm_contacts', 'deletedAt', {
- type: Sequelize.DATE,
- defaultValue: null
- });
- // END CONTACT
-
- // START FINAL
- migration.final(resolve);
- // END FINAL
+ up: function(queryInterface, Sequelize) {
+ return new BPromise(function(resolve, reject) {
+ var migration = new Migration(queryInterface);
+ // START SETTINGS
+ migration.addColumn('settings', 'defaultPageTitle', {
+ type: Sequelize.BOOLEAN,
+ defaultValue: true
+ });
+ migration.addColumn('settings', 'pageTitle', {
+ type: Sequelize.STRING
+ });
+ // END SETTINGS
+
+ // START VOICECONTEXT
+ migration.checkVoiceContexts();
+ // END VOICECONTEXT
+
+ // START SALESFORCE CONF
+ migration.addColumn('int_salesforce_configurations', 'moduleSearch', {
+ type: Sequelize.ENUM('contact_lead', 'contact', 'lead'),
+ defaultValue: 'contact_lead'
+ });
+ migration.addColumn('int_salesforce_configurations', 'moduleCreate', {
+ type: Sequelize.ENUM('nothing', 'contact', 'lead'),
+ defaultValue: 'lead'
+ });
+ // END SALESFORCE CONF
+
+ // START FAX
+ migration.query("INSERT INTO `voice_extensions` (`context`, `exten`, `priority`, `app`, `appdata`, `type`, `description`, `createdAt`, `updatedAt`) VALUES ('from-sip', 'xcally-motion-fax', '1', 'NoOp', '', 'system', 'Fax extensions auto generated', NOW(), NOW());");
+
+ migration.query("INSERT INTO `voice_extensions` (`context`, `exten`, `priority`, `app`, `appdata`, `type`, `description`, `createdAt`, `updatedAt`) VALUES ('from-sip', 'xcally-motion-fax', '2', 'Set', 'CDR(type)=outbound-fax', 'system', 'Fax extensions auto generated', NOW(), NOW());");
+
+ migration.query("INSERT INTO `voice_extensions` (`context`, `exten`, `priority`, `app`, `appdata`, `type`, `description`, `createdAt`, `updatedAt`) VALUES ('from-sip', 'xcally-motion-fax', '3', 'Wait', '6', 'system', 'Fax extensions auto generated', NOW(), NOW());");
+
+ migration.query("INSERT INTO `voice_extensions` (`context`, `exten`, `priority`, `app`, `appdata`, `type`, `description`, `createdAt`, `updatedAt`) VALUES ('from-sip', 'xcally-motion-fax', '4', 'Set', 'FAXOPT(ecm)=${XMF-ECM}', 'system', 'Fax extensions auto generated', NOW(), NOW());");
+
+ migration.query("INSERT INTO `voice_extensions` (`context`, `exten`, `priority`, `app`, `appdata`, `type`, `description`, `createdAt`, `updatedAt`) VALUES ('from-sip', 'xcally-motion-fax', '5', 'Set', 'FAXOPT(headerinfo)=${XMF-HEADERINFO}', 'system', 'Fax extensions auto generated', NOW(), NOW());");
+
+ migration.query("INSERT INTO `voice_extensions` (`context`, `exten`, `priority`, `app`, `appdata`, `type`, `description`, `createdAt`, `updatedAt`) VALUES ('from-sip', 'xcally-motion-fax', '6', 'Set', 'FAXOPT(localstationid)=${XMF-LOCALSTATIONID}', 'system', 'Fax extensions auto generated', NOW(), NOW());");
+
+ migration.query("INSERT INTO `voice_extensions` (`context`, `exten`, `priority`, `app`, `appdata`, `type`, `description`, `createdAt`, `updatedAt`) VALUES ('from-sip', 'xcally-motion-fax', '7', 'Set', 'FAXOPT(maxrate)=${XMF-MAXRATE}', 'system', 'Fax extensions auto generated', NOW(), NOW());");
+
+ migration.query("INSERT INTO `voice_extensions` (`context`, `exten`, `priority`, `app`, `appdata`, `type`, `description`, `createdAt`, `updatedAt`) VALUES ('from-sip', 'xcally-motion-fax', '8', 'Set', 'FAXOPT(minrate)=${XMF-MINRATE}', 'system', 'Fax extensions auto generated', NOW(), NOW());");
+
+ migration.query("INSERT INTO `voice_extensions` (`context`, `exten`, `priority`, `app`, `appdata`, `type`, `description`, `createdAt`, `updatedAt`) VALUES ('from-sip', 'xcally-motion-fax', '9', 'Set', 'FAXOPT(modem)=${XMF-MODEM}', 'system', 'Fax extensions auto generated', NOW(), NOW());");
+
+ migration.query("INSERT INTO `voice_extensions` (`context`, `exten`, `priority`, `app`, `appdata`, `type`, `description`, `createdAt`, `updatedAt`) VALUES ('from-sip', 'xcally-motion-fax', '10', 'Set', 'FAXOPT(t38timeout)=${XMF-T38TIMEOUT}', 'system', 'Fax extensions auto generated', NOW(), NOW());");
+
+ migration.query("INSERT INTO `voice_extensions` (`context`, `exten`, `priority`, `app`, `appdata`, `type`, `description`, `createdAt`, `updatedAt`) VALUES ('from-sip', 'xcally-motion-fax', '11', 'SendFax', '${XMF-PATH},d', 'system', 'Fax extensions auto generated', NOW(), NOW());");
+
+ exec('chmod 775 /var/opt/motion2/server/files/attachments', function(err, stdout, stderr) {
+ logger.info('Exec chmod', ' Error :', JSON.stringify(err), stdout, stderr);
+ exec('ls -la /var/opt/motion2/server/files', function(err, stdout, stderr) {
+ logger.info('Ls :', ' Error :', JSON.stringify(err), stdout, stderr);
});
- },
+ });
+ // END FAX
+
+ // START CONTACT
+ migration.addColumn('cm_contacts', 'deletedAt', {
+ type: Sequelize.DATE,
+ defaultValue: null
+ });
+ // END CONTACT
+
+ // START FINAL
+ migration.final(resolve);
+ // END FINAL
+ });
+ },
down: function(queryInterface, Sequelize) {
var migration = new Migration(queryInterface);
}
-};
+};
\ No newline at end of file