diff options
Diffstat (limited to '')
-rw-r--r-- | lib/migrations/20160703062241-support-authorship.js | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/lib/migrations/20160703062241-support-authorship.js b/lib/migrations/20160703062241-support-authorship.js new file mode 100644 index 00000000..239327ec --- /dev/null +++ b/lib/migrations/20160703062241-support-authorship.js @@ -0,0 +1,28 @@ +'use strict'; + +module.exports = { + up: function (queryInterface, Sequelize) { + queryInterface.addColumn('Notes', 'authorship', Sequelize.TEXT); + queryInterface.addColumn('Revisions', 'authorship', Sequelize.TEXT); + queryInterface.createTable('Authors', { + id: { + type: Sequelize.INTEGER, + primaryKey: true, + autoIncrement: true + }, + color: Sequelize.STRING, + noteId: Sequelize.UUID, + userId: Sequelize.UUID, + createdAt: Sequelize.DATE, + updatedAt: Sequelize.DATE + }); + return; + }, + + down: function (queryInterface, Sequelize) { + queryInterface.dropTable('Authors'); + queryInterface.removeColumn('Revisions', 'authorship'); + queryInterface.removeColumn('Notes', 'authorship'); + return; + } +}; |