From dbc126b156f301c18d3963cd269dcd1eac040873 Mon Sep 17 00:00:00 2001
From: Cheng-Han, Wu
Date: Fri, 17 Jun 2016 16:09:33 +0800
Subject: Add support of saving note revision and improve app start and stop
 procedure to ensure data integrity

---
 lib/migrations/20160607060246-support-revision.js | 24 +++++++++++++++++++++++
 1 file changed, 24 insertions(+)
 create mode 100644 lib/migrations/20160607060246-support-revision.js

(limited to 'lib/migrations/20160607060246-support-revision.js')

diff --git a/lib/migrations/20160607060246-support-revision.js b/lib/migrations/20160607060246-support-revision.js
new file mode 100644
index 00000000..9721d7fc
--- /dev/null
+++ b/lib/migrations/20160607060246-support-revision.js
@@ -0,0 +1,24 @@
+'use strict';
+
+module.exports = {
+  up: function (queryInterface, Sequelize) {
+    queryInterface.addColumn('Notes', 'savedAt', Sequelize.DATE);
+    queryInterface.createTable('Revisions', {
+      id: Sequelize.UUID,
+      noteId: Sequelize.UUID,
+      patch: Sequelize.TEXT,
+      lastContent: Sequelize.TEXT,
+      content: Sequelize.TEXT,
+      length: Sequelize.INTEGER,
+      createdAt: Sequelize.DATE,
+      updatedAt: Sequelize.DATE
+    });
+    return;
+  },
+
+  down: function (queryInterface, Sequelize) {
+    queryInterface.dropTable('Revisions');
+    queryInterface.removeColumn('Notes', 'savedAt');
+    return;
+  }
+};
-- 
cgit v1.2.3