-- PostgreSQL flavour of sqlite/0031_outside_plays.sql. CREATE TABLE outside_plays ( user_id BIGINT NOT NULL REFERENCES users(id) ON DELETE CASCADE, idempotency_key TEXT NOT NULL, artist TEXT NOT NULL, artist_key TEXT NOT NULL, played_at BIGINT NOT NULL, PRIMARY KEY (user_id, idempotency_key) ); CREATE INDEX idx_outside_plays_time ON outside_plays(user_id, played_at);