clean this up when home

1 files changed, 14 insertions, 0 deletions

diff --git a/db/migrations/20190609161116_create_updates_table.js b/db/migrations/20190609161116_create_updates_table.js
new file mode 100644
index 0000000..c90e9bd
--- /dev/null
+++ b/db/migrations/20190609161116_create_updates_table.js
@@ -0,0 +1,14 @@
+exports.up = async function(knex, Promise) {
+  if (! await knex.schema.hasTable('updates')) {
+    await knex.schema.createTable('updates', table => {
+      table.string('available_version', 16).nullable();
+      table.dateTime('last_checked').nullable();
+    });
+  }
+};
+
+exports.down = async function(knex, Promise) {
+  if (await knex.schema.hasTable('updates')) {
+    await knex.schema.dropTable('updates');
+  }
+};