-- Preserve whether a Province-link change was made under Platform or Province authority.
SET @add_province_link_actor_scope = IF(
  (SELECT COUNT(*) FROM information_schema.columns WHERE table_schema=DATABASE() AND table_name='province_link_audit' AND column_name='actor_scope')=0,
  "ALTER TABLE province_link_audit ADD COLUMN actor_scope ENUM('platform','province','unknown') NOT NULL DEFAULT 'unknown' AFTER actor_id",
  'SELECT 1'
);
PREPARE province_link_actor_stmt FROM @add_province_link_actor_scope;
EXECUTE province_link_actor_stmt;
DEALLOCATE PREPARE province_link_actor_stmt;