diff options
Diffstat (limited to 'planetwars-server/migrations/2021-12-13-151129_sessions')
| -rw-r--r-- | planetwars-server/migrations/2021-12-13-151129_sessions/down.sql | 1 | ||||
| -rw-r--r-- | planetwars-server/migrations/2021-12-13-151129_sessions/up.sql | 5 |
2 files changed, 6 insertions, 0 deletions
diff --git a/planetwars-server/migrations/2021-12-13-151129_sessions/down.sql b/planetwars-server/migrations/2021-12-13-151129_sessions/down.sql new file mode 100644 index 0000000..54d1e93 --- /dev/null +++ b/planetwars-server/migrations/2021-12-13-151129_sessions/down.sql @@ -0,0 +1 @@ +DROP TABLE sessions;
\ No newline at end of file diff --git a/planetwars-server/migrations/2021-12-13-151129_sessions/up.sql b/planetwars-server/migrations/2021-12-13-151129_sessions/up.sql new file mode 100644 index 0000000..f8ec21b --- /dev/null +++ b/planetwars-server/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 |