onasty: migrations/20240716235210_notes.up.sql (0401811)

onasty/migrations/20240716235210_notes.up.sql (view raw)

Smirnov Oleksandr feat: notes manipulations for the note authors (#117)..., 1 year ago

CREATE TABLE notes (
    id uuid PRIMARY KEY DEFAULT uuid_generate_v4 (),
    content text NOT NULL,
    slug varchar(255) NOT NULL UNIQUE,
    burn_before_expiration boolean DEFAULT FALSE,
    created_at timestamptz NOT NULL DEFAULT now(),
    expires_at timestamptz
);

1	CREATE TABLE notes (
2	id uuid PRIMARY KEY DEFAULT uuid_generate_v4 (),
3	content text NOT NULL,
4	slug varchar(255) NOT NULL UNIQUE,
5	burn_before_expiration boolean DEFAULT FALSE,
6	created_at timestamptz NOT NULL DEFAULT now(),
7	expires_at timestamptz
8	);