summaryrefslogtreecommitdiff
path: root/migrations/2020-01-29-230359_create_users
diff options
context:
space:
mode:
authorKjetil Orbekk <kjetil.orbekk@gmail.com>2020-01-29 19:15:28 -0500
committerKjetil Orbekk <kjetil.orbekk@gmail.com>2020-01-29 19:15:28 -0500
commitc8db39dea2cf50dd1fa6c499600e09818b8db44a (patch)
treeb2eb940f9769323cd1d3e1c92bbe3c16d38d9dd6 /migrations/2020-01-29-230359_create_users
parent6c16bcd190328443f15029fc3ee2467b6c270eed (diff)
Add database support
Diffstat (limited to 'migrations/2020-01-29-230359_create_users')
-rw-r--r--migrations/2020-01-29-230359_create_users/down.sql1
-rw-r--r--migrations/2020-01-29-230359_create_users/up.sql5
2 files changed, 6 insertions, 0 deletions
diff --git a/migrations/2020-01-29-230359_create_users/down.sql b/migrations/2020-01-29-230359_create_users/down.sql
new file mode 100644
index 0000000..cc1f647
--- /dev/null
+++ b/migrations/2020-01-29-230359_create_users/down.sql
@@ -0,0 +1 @@
+DROP TABLE users;
diff --git a/migrations/2020-01-29-230359_create_users/up.sql b/migrations/2020-01-29-230359_create_users/up.sql
new file mode 100644
index 0000000..4b845dc
--- /dev/null
+++ b/migrations/2020-01-29-230359_create_users/up.sql
@@ -0,0 +1,5 @@
+CREATE TABLE users (
+ username varchar NOT NULL PRIMARY KEY,
+ -- bcrypt with cost 12
+ password varchar NOT NULL
+);