From 2f117a22cd21fa4fb67a3b2d687485795f86d030 Mon Sep 17 00:00:00 2001
From: Wu Cheng-Han
Date: Sat, 30 Jul 2016 11:21:38 +0800
Subject: Add support of saving authors and authorship

---
 .../20160703062241-support-authorship.js           | 28 ++++++++++++++++++++++
 1 file changed, 28 insertions(+)
 create mode 100644 lib/migrations/20160703062241-support-authorship.js

(limited to 'lib/migrations/20160703062241-support-authorship.js')

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;
+  }
+};
-- 
cgit v1.2.3