4 up: function(queryInterface, Sequelize) {
5 queryInterface.addColumn('sms_accounts', 'smstype', {
6 type: Sequelize.ENUM('basic', 'classic', 'classic+')
8 queryInterface.addColumn('sms_accounts', 'remote', {
11 queryInterface.changeColumn(
14 type: Sequelize.ENUM('twilio', 'skebby')
17 queryInterface.changeColumn(
20 type: Sequelize.STRING,
27 queryInterface.addColumn('sms_applications', 'SmsAccountId', Sequelize.INTEGER);
28 queryInterface.sequelize.query(
29 "ALTER TABLE sms_applications ADD CONSTRAINT sms_applications_ibfk_1 FOREIGN KEY (SmsAccountId) REFERENCES motion.sms_accounts(id) ON DELETE CASCADE ON UPDATE CASCADE;"
33 down: function(queryInterface, Sequelize) {
34 queryInterface.removeColumn('sms_accounts', 'smstype');
35 queryInterface.removeColumn('sms_accounts', 'remote');
36 queryInterface.changeColumn(
39 type: Sequelize.STRING
42 queryInterface.changeColumn(
45 type: Sequelize.INTEGER,
49 queryInterface.removeColumn('sms_applications', 'SmsAccountId');
50 queryInterface.sequelize.query(
51 'ALTER TABLE sms_applications DROP CONSTRAINT sms_applications_ibfk_1;'