Add support of saving authors and authorship

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;
+  }
+};