22 lines
540 B
SQL
22 lines
540 B
SQL
-- migrate:up
|
|
CREATE TABLE users (
|
|
id SERIAL PRIMARY KEY,
|
|
username TEXT UNIQUE NOT NULL,
|
|
password_hash TEXT NOT NULL,
|
|
created_at TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP NOT NULL
|
|
);
|
|
|
|
CREATE TABLE sessions (
|
|
id VARCHAR(64) PRIMARY KEY,
|
|
user_id INT REFERENCES users(id) ON DELETE CASCADE NOT NULL,
|
|
expires_at TIMESTAMPTZ NOT NULL,
|
|
created_at TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP NOT NULL
|
|
);
|
|
|
|
CREATE INDEX idx_sessions_expires_at ON sessions(expires_at);
|
|
|
|
-- migrate:down
|
|
DROP TABLE sessions;
|
|
DROP TABLE users;
|
|
|