8 lines
200 B
SQL
8 lines
200 B
SQL
-- 02.sql: create simple users table
|
|
CREATE TABLE IF NOT EXISTS users (
|
|
username TEXT PRIMARY KEY,
|
|
password TEXT NOT NULL, -- bcrypt hash
|
|
created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
|
|
);
|
|
|