diff options
| author | Ilion Beyst <ilion.beyst@gmail.com> | 2021-12-13 22:41:20 +0100 |
|---|---|---|
| committer | Ilion Beyst <ilion.beyst@gmail.com> | 2021-12-13 22:41:20 +0100 |
| commit | eabeb7ed7b641dea0b8e71ab33ab97b4ed7a4cda (patch) | |
| tree | 9cd2f38290fa059020feb049d8a2e2e91adac68b /backend/migrations/2021-12-13-151129_sessions | |
| parent | 8b4440f7236b0972c1a804eea4c8305b958ad03c (diff) | |
| download | planetwars.dev-eabeb7ed7b641dea0b8e71ab33ab97b4ed7a4cda.tar.xz planetwars.dev-eabeb7ed7b641dea0b8e71ab33ab97b4ed7a4cda.zip | |
start implementing basic login functionality
Diffstat (limited to 'backend/migrations/2021-12-13-151129_sessions')
| -rw-r--r-- | backend/migrations/2021-12-13-151129_sessions/down.sql | 1 | ||||
| -rw-r--r-- | backend/migrations/2021-12-13-151129_sessions/up.sql | 5 |
2 files changed, 6 insertions, 0 deletions
diff --git a/backend/migrations/2021-12-13-151129_sessions/down.sql b/backend/migrations/2021-12-13-151129_sessions/down.sql new file mode 100644 index 0000000..54d1e93 --- /dev/null +++ b/backend/migrations/2021-12-13-151129_sessions/down.sql @@ -0,0 +1 @@ +DROP TABLE sessions;
\ No newline at end of file diff --git a/backend/migrations/2021-12-13-151129_sessions/up.sql b/backend/migrations/2021-12-13-151129_sessions/up.sql new file mode 100644 index 0000000..f8ec21b --- /dev/null +++ b/backend/migrations/2021-12-13-151129_sessions/up.sql @@ -0,0 +1,5 @@ +CREATE TABLE sessions ( + id serial PRIMARY KEY, + user_id integer REFERENCES users(id) NOT NULL, + token VARCHAR(255) NOT NULL UNIQUE +)
\ No newline at end of file |