pkg/database/migrations/0001_initial.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

-- +goose Up
CREATE TABLE users (
    id int GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
    username varchar(20) UNIQUE NOT NULL,
    password char(60) NOT NULL
);

CREATE TABLE favourites (
    id int GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
    user_id int NOT NULL,
    event_guid uuid,
    event_id int,
    UNIQUE(user_id, event_guid, event_id),
    CONSTRAINT chk_favourites CHECK (event_guid IS NOT NULL OR event_id IS NOT NULL),
    FOREIGN KEY (user_id) REFERENCES users(id)
);