diff options
| author | Jules Laplace <julescarbon@gmail.com> | 2018-05-29 00:15:13 +0200 |
|---|---|---|
| committer | Jules Laplace <julescarbon@gmail.com> | 2018-05-29 00:15:13 +0200 |
| commit | a77ddf4bf8ad8aeb91e2109a7c4a92149928b57b (patch) | |
| tree | bed9a31e1febb3824d4d273bd4821ab28449f82a /migrations/20180529000627_createUsers.js | |
| parent | bdab187f3d385a6b96c24135679af468d1e7892b (diff) | |
adding migrations!!
Diffstat (limited to 'migrations/20180529000627_createUsers.js')
| -rw-r--r-- | migrations/20180529000627_createUsers.js | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/migrations/20180529000627_createUsers.js b/migrations/20180529000627_createUsers.js new file mode 100644 index 0000000..3f86d5a --- /dev/null +++ b/migrations/20180529000627_createUsers.js @@ -0,0 +1,17 @@ +
+exports.up = function(knex, Promise) {
+ return knex.schema.createTable('users', function (table) {
+ table.increments()
+ table.string('username')
+ table.string('password')
+ table.string('realname')
+ table.string('level')
+ table.datetime('lastseen')
+ table.json('profile')
+ table.timestamps()
+ })
+};
+
+exports.down = function(knex, Promise) {
+ return knex.schema.dropTable('users')
+};
|