onasty: migrations/20240613092407_users.up.sql (218bb4e)

onasty/migrations/20240613092407_users.up.sql (view raw)

Smirnov Oleksandr run pg_format on all sql files (#45), 1 year ago

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()
);

1	CREATE TABLE users (
2	id uuid PRIMARY KEY DEFAULT uuid_generate_v4(),
3	username varchar(255) NOT NULL UNIQUE,
4	email varchar(255) NOT NULL UNIQUE,
5	password varchar(255) NOT NULL,
6	activated boolean NOT NULL DEFAULT FALSE,
7	created_at timestamptz NOT NULL DEFAULT now(),
8	last_login_at timestamptz NOT NULL DEFAULT now()
9	);