diff options
Diffstat (limited to 'migrations')
-rw-r--r-- | migrations/20240321225523_init.down.sql | 2 | ||||
-rw-r--r-- | migrations/20240321225523_init.up.sql | 8 |
2 files changed, 4 insertions, 6 deletions
diff --git a/migrations/20240321225523_init.down.sql b/migrations/20240321225523_init.down.sql index 1726abe..e3470ec 100644 --- a/migrations/20240321225523_init.down.sql +++ b/migrations/20240321225523_init.down.sql @@ -1 +1 @@ -DROP TABLE IF EXISTS sessions, users; +DROP TABLE IF EXISTS users, credentials; diff --git a/migrations/20240321225523_init.up.sql b/migrations/20240321225523_init.up.sql index 4ea79fe..ca86893 100644 --- a/migrations/20240321225523_init.up.sql +++ b/migrations/20240321225523_init.up.sql @@ -4,14 +4,12 @@ CREATE TABLE users ( uuid UUID NOT NULL PRIMARY KEY DEFAULT (uuid_generate_v4()), name VARCHAR(100) NOT NULL, email VARCHAR(255) NOT NULL UNIQUE, - password_hash VARCHAR(100) NOT NULL, session_epoch TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(), created_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(), updated_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW() ); - -CREATE TABLE sessions ( - jti UUID NOT NULL PRIMARY KEY DEFAULT (uuid_generate_v4()), - uuid UUID NOT NULL REFERENCES users ON DELETE CASCADE +CREATE TABLE credentials ( + uuid UUID NOT NULL PRIMARY KEY, + password_hash VARCHAR(100) NOT NULL ); |