9 lines
283 B
SQL
9 lines
283 B
SQL
CREATE TABLE users (
|
|
id INTEGER PRIMARY KEY UNIQUE NOT NULL GENERATED ALWAYS AS IDENTITY,
|
|
username VARCHAR UNIQUE NOT NULL,
|
|
hashed_password VARCHAR NOT NULL,
|
|
created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
|
|
);
|
|
|
|
CREATE UNIQUE INDEX users_username_idx ON users(username);
|