14 lines
411 B
SQL
14 lines
411 B
SQL
-- +goose Up
|
|
CREATE TABLE
|
|
IF NOT EXISTS users (
|
|
id SERIAL PRIMARY KEY,
|
|
username VARCHAR(50) NOT NULL UNIQUE,
|
|
email VARCHAR(100) NOT NULL UNIQUE,
|
|
password_hash VARCHAR(255) NOT NULL,
|
|
roles JSONB NOT NULL DEFAULT '[]'::jsonb,
|
|
is_active BOOLEAN DEFAULT TRUE,
|
|
created_at TIMESTAMP NOT NULL DEFAULT NOW ()
|
|
);
|
|
|
|
-- +goose Down
|
|
DROP TABLE IF EXISTS users; |