ALTER TABLE service_bindings ADD COLUMN health_check_providers TEXT;
ALTER TABLE service_bindings ADD COLUMN health_check_aggregate TEXT NOT NULL DEFAULT 'majority';
UPDATE service_bindings
SET health_check_providers = CASE
  WHEN health_check_provider = 'cloudflare' THEN '["cloudflare"]'
  ELSE '["local"]'
END
WHERE health_check_providers IS NULL;

ALTER TABLE service_groups ADD COLUMN health_check_providers TEXT;
ALTER TABLE service_groups ADD COLUMN health_check_aggregate TEXT NOT NULL DEFAULT 'majority';
UPDATE service_groups
SET health_check_providers = CASE
  WHEN health_check_provider = 'cloudflare' THEN '["cloudflare"]'
  ELSE '["local"]'
END
WHERE health_check_providers IS NULL;

ALTER TABLE app_settings ADD COLUMN globalping_token TEXT;
ALTER TABLE app_settings ADD COLUMN globalping_locations TEXT;
ALTER TABLE app_settings ADD COLUMN globalping_limit INTEGER;