onasty: migrations/20240613092407_users.up.sql (8d12ded)

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

Smirnov Oleksandr feat: notes manipulations for the note authors (#117)..., 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	);