1 files changed, 50 insertions, 0 deletions

diff --git a/server/models/application.ts b/server/models/application.ts
new file mode 100644
index 000000000..38a57e327
--- /dev/null
+++ b/server/models/application.ts
@@ -0,0 +1,50 @@
+module.exports = function (sequelize, DataTypes) {
+  const Application = sequelize.define('Application',
+    {
+      migrationVersion: {
+        type: DataTypes.INTEGER,
+        defaultValue: 0,
+        allowNull: false,
+        validate: {
+          isInt: true
+        }
+      }
+    },
+    {
+      classMethods: {
+        loadMigrationVersion,
+        updateMigrationVersion
+      }
+    }
+  )
+
+  return Application
+}
+
+// ---------------------------------------------------------------------------
+
+function loadMigrationVersion (callback) {
+  const query = {
+    attributes: [ 'migrationVersion' ]
+  }
+
+  return this.findOne(query).asCallback(function (err, data) {
+    const version = data ? data.migrationVersion : null
+
+    return callback(err, version)
+  })
+}
+
+function updateMigrationVersion (newVersion, transaction, callback) {
+  const options: { where?: any, transaction?: any } = {
+    where: {}
+  }
+
+  if (!callback) {
+    transaction = callback
+  } else {
+    options.transaction = transaction
+  }
+
+  return this.update({ migrationVersion: newVersion }, options).asCallback(callback)
+}