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);