onasty/migrations/20240613092407_users.up.sql(view raw)
1 2 3 4 5 6 7 8 9 |
CREATE TABLE users (
id uuid PRIMARY KEY DEFAULT uuid_generate_v4(),
username varchar(255) NOT NULL UNIQUE,
email varchar(255) NOT NULL UNIQUE,
password varchar(255) NOT NULL,
activated boolean NOT NULL DEFAULT FALSE,
created_at timestamptz NOT NULL DEFAULT now(),
last_login_at timestamptz NOT NULL DEFAULT now()
);
|