diff options
Diffstat (limited to 'migrations/20240321225523_init.up.sql')
| -rw-r--r-- | migrations/20240321225523_init.up.sql | 15 |
1 files changed, 9 insertions, 6 deletions
diff --git a/migrations/20240321225523_init.up.sql b/migrations/20240321225523_init.up.sql index 7ae6aab..4ea79fe 100644 --- a/migrations/20240321225523_init.up.sql +++ b/migrations/20240321225523_init.up.sql @@ -5,10 +5,13 @@ CREATE TABLE users ( name VARCHAR(100) NOT NULL, email VARCHAR(255) NOT NULL UNIQUE, password_hash VARCHAR(100) NOT NULL, - created_at TIMESTAMP - WITH - TIME ZONE DEFAULT NOW(), - updated_at TIMESTAMP - WITH - TIME ZONE DEFAULT NOW() + 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 ); |