From a77ddf4bf8ad8aeb91e2109a7c4a92149928b57b Mon Sep 17 00:00:00 2001 From: Jules Laplace Date: Tue, 29 May 2018 00:15:13 +0200 Subject: adding migrations!! --- migrations/20170628233706_createJobs.js | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 migrations/20170628233706_createJobs.js (limited to 'migrations/20170628233706_createJobs.js') diff --git a/migrations/20170628233706_createJobs.js b/migrations/20170628233706_createJobs.js new file mode 100644 index 0000000..4b17c6f --- /dev/null +++ b/migrations/20170628233706_createJobs.js @@ -0,0 +1,15 @@ + +exports.up = function(knex, Promise) { + return knex.schema.createTable('jobs', function (table) { + table.increments() + table.string('name') + table.string('username') + table.boolean('completed') + table.string('tool') + table.timestamps() + }) +}; + +exports.down = function(knex, Promise) { + return knex.schema.dropTable('jobs') +}; -- cgit v1.2.3-70-g09d2