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 | |
| parent | 8b4440f7236b0972c1a804eea4c8305b958ad03c (diff) | |
| download | planetwars.dev-eabeb7ed7b641dea0b8e71ab33ab97b4ed7a4cda.tar.xz planetwars.dev-eabeb7ed7b641dea0b8e71ab33ab97b4ed7a4cda.zip | |
start implementing basic login functionality
Diffstat (limited to 'backend/migrations')
4 files changed, 13 insertions, 0 deletions
diff --git a/backend/migrations/2021-12-13-145111_users/down.sql b/backend/migrations/2021-12-13-145111_users/down.sql new file mode 100644 index 0000000..441087a --- /dev/null +++ b/backend/migrations/2021-12-13-145111_users/down.sql @@ -0,0 +1 @@ +DROP TABLE users;
\ No newline at end of file diff --git a/backend/migrations/2021-12-13-145111_users/up.sql b/backend/migrations/2021-12-13-145111_users/up.sql new file mode 100644 index 0000000..6ec7e01 --- /dev/null +++ b/backend/migrations/2021-12-13-145111_users/up.sql @@ -0,0 +1,6 @@ +CREATE TABLE users( + id SERIAL PRIMARY KEY, + username VARCHAR(52) NOT NULL, + password_salt BYTEA NOT NULL, + password_hash BYTEA NOT NULL +);
\ No newline at end of file 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 |