-- Store one canonical platform per provider service for simple customer filters.
ALTER TABLE services
    ADD COLUMN platform VARCHAR(60) NOT NULL DEFAULT 'Other' AFTER category_id,
    ADD COLUMN platform_locked TINYINT(1) NOT NULL DEFAULT 0 AFTER platform,
    ADD INDEX idx_services_platform_status (platform, status);

-- Run `php bin/classify_services.php` after this migration to backfill rows.