-- PostgreSQL flavour of sqlite/0033_lidarr_requests.sql. CREATE TABLE lidarr_requests ( id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, user_id BIGINT NOT NULL REFERENCES users(id) ON DELETE CASCADE, artist_id BIGINT REFERENCES artists(id) ON DELETE SET NULL, artist_name TEXT NOT NULL, artist_key TEXT NOT NULL, artist_mbid TEXT, requested_at BIGINT NOT NULL, arrived_at BIGINT ); CREATE UNIQUE INDEX idx_lidarr_requests_artist ON lidarr_requests(user_id, artist_key); CREATE INDEX idx_lidarr_requests_time ON lidarr_requests(user_id, requested_at DESC);