jam-cloud/db/up/plays_likes_counters.sql

ALTER TABLE recordings              ADD COLUMN play_count INTEGER NOT NULL DEFAULT 0;
ALTER TABLE music_sessions_history  ADD COLUMN play_count INTEGER NOT NULL DEFAULT 0;
ALTER TABLE recordings              ADD COLUMN like_count INTEGER NOT NULL DEFAULT 0;
ALTER TABLE music_sessions_history  ADD COLUMN like_count INTEGER NOT NULL DEFAULT 0;

CREATE INDEX music_sessions_plays_uniqkey ON music_sessions_plays (player_id, music_session_id);
CREATE INDEX recordings_plays_uniqkey ON recordings_plays (player_id, recording_id);