ALTER TABLE events
  ADD COLUMN available_capacity INT UNSIGNED NULL DEFAULT NULL AFTER capacity;

UPDATE events
SET available_capacity = capacity
WHERE available_capacity IS NULL AND capacity IS NOT NULL;
