aboutsummaryrefslogtreecommitdiffstats
path: root/migrations/2021-03-21-181750_create_sessions/up.sql
diff options
context:
space:
mode:
authorEllie Huxtable <e@elm.sh>2021-03-21 20:04:39 +0000
committerGitHub <noreply@github.com>2021-03-21 20:04:39 +0000
commitc9579cb9ca2a6a165d10f128e0af1dfd372e0c03 (patch)
tree1d4feecb422aae3cde1cc7cad54ccc73b2dae410 /migrations/2021-03-21-181750_create_sessions/up.sql
parentAdd TUI, resolve #19, #17, #16 (#21) (diff)
downloadatuin-c9579cb9ca2a6a165d10f128e0af1dfd372e0c03.zip
Implement server (#23)
* Add initial database and server setup * Set up all routes, auth, etc * Implement sessions, password auth, hashing with argon2, and history storage
Diffstat (limited to 'migrations/2021-03-21-181750_create_sessions/up.sql')
-rw-r--r--migrations/2021-03-21-181750_create_sessions/up.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/migrations/2021-03-21-181750_create_sessions/up.sql b/migrations/2021-03-21-181750_create_sessions/up.sql
new file mode 100644
index 00000000..b81705e2
--- /dev/null
+++ b/migrations/2021-03-21-181750_create_sessions/up.sql
@@ -0,0 +1,6 @@
+-- Your SQL goes here
+create table sessions (
+ id bigserial primary key,
+ user_id bigserial,
+ token varchar(128) unique not null
+);