pkg/database/migrations/0003_multi_conference.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

-- +goose Up
CREATE TABLE conferences (
    id int GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
    url text NOT NULL,
    title text,
    venue text,
    city text
);

TRUNCATE TABLE favourites CONTINUE IDENTITY;
ALTER TABLE favourites ADD conference_id int NOT NULL REFERENCES conferences(id) ON DELETE CASCADE;
ALTER TABLE favourites DROP CONSTRAINT favourites_user_id_event_guid_event_id_key;
ALTER TABLE favourites ADD UNIQUE(user_id, event_guid, event_id, conference_id);