From 6e07c3de88791a0b342e0cc319590048117f9c2d Mon Sep 17 00:00:00 2001 From: Chocobozzz Date: Wed, 22 Mar 2017 21:15:55 +0100 Subject: Add video category support --- .../initializers/migrations/0030-video-category.js | 34 ++++++++++++++++++++++ 1 file changed, 34 insertions(+) create mode 100644 server/initializers/migrations/0030-video-category.js (limited to 'server/initializers/migrations') diff --git a/server/initializers/migrations/0030-video-category.js b/server/initializers/migrations/0030-video-category.js new file mode 100644 index 000000000..ada95b2fe --- /dev/null +++ b/server/initializers/migrations/0030-video-category.js @@ -0,0 +1,34 @@ +'use strict' + +const waterfall = require('async/waterfall') + +// utils = { transaction, queryInterface, sequelize, Sequelize } +exports.up = function (utils, finalCallback) { + const q = utils.queryInterface + const Sequelize = utils.Sequelize + + const data = { + type: Sequelize.INTEGER, + allowNull: false, + defaultValue: 0 + } + + waterfall([ + + function addCategoryColumn (callback) { + q.addColumn('Videos', 'category', data, { transaction: utils.transaction }).asCallback(function (err) { + return callback(err) + }) + }, + + function nullOnDefault (callback) { + data.defaultValue = null + + q.changeColumn('Videos', 'category', data, { transaction: utils.transaction }).asCallback(callback) + } + ], finalCallback) +} + +exports.down = function (options, callback) { + throw new Error('Not implemented.') +} -- cgit v1.2.3