blob: 4ea79fe4acf98d4e4f0e6ec79b5917266fed150d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
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
);
|