onasty: migrations/20240724122920_notes

onasty/migrations/20240724122920_notes_authors.up.sql (view raw)

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

CREATE TABLE notes_authors (
    id uuid PRIMARY KEY DEFAULT uuid_generate_v4(),
    note_id uuid REFERENCES notes (id) ON DELETE CASCADE,
    user_id uuid REFERENCES users (id) ON DELETE CASCADE,
    created_at timestamptz NOT NULL DEFAULT now()
);

1	CREATE TABLE notes_authors (
2	id uuid PRIMARY KEY DEFAULT uuid_generate_v4(),
3	note_id uuid REFERENCES notes (id) ON DELETE CASCADE,
4	user_id uuid REFERENCES users (id) ON DELETE CASCADE,
5	created_at timestamptz NOT NULL DEFAULT now()
6	);