summaryrefslogtreecommitdiffstats
path: root/backend/migrations/20200201152838_initial.js
diff options
context:
space:
mode:
Diffstat (limited to 'backend/migrations/20200201152838_initial.js')
-rw-r--r--backend/migrations/20200201152838_initial.js12
1 files changed, 12 insertions, 0 deletions
diff --git a/backend/migrations/20200201152838_initial.js b/backend/migrations/20200201152838_initial.js
new file mode 100644
index 0000000..3131525
--- /dev/null
+++ b/backend/migrations/20200201152838_initial.js
@@ -0,0 +1,12 @@
+exports.up = function(knex) {
+ return knex.schema.createTable('users', function(table) {
+ table.increments();
+ table.string('username').notNullable();
+ table.string('password').notNullable();
+ table.timestamps(true, true);
+ });
+};
+
+exports.down = function(knex) {
+ return knex.schema.dropTable('users');
+};