-- Clean cutover from scalar mood to polar + cached cartesian representation.
ALTER TABLE `TrackProfile`
    DROP COLUMN `mood`,
    ADD COLUMN `moodAngle` DOUBLE NULL,
    ADD COLUMN `moodRadius` DOUBLE NULL,
    ADD COLUMN `moodX` DOUBLE NULL,
    ADD COLUMN `moodY` DOUBLE NULL,
    ADD COLUMN `moodLabel` VARCHAR(191) NULL;

CREATE INDEX `TrackProfile_moodAngle_moodRadius_idx`
    ON `TrackProfile`(`moodAngle`, `moodRadius`);

CREATE INDEX `TrackProfile_moodX_moodY_idx`
    ON `TrackProfile`(`moodX`, `moodY`);
