ALTER TABLE events
    ADD COLUMN registration_required TINYINT(1) NOT NULL DEFAULT 1 AFTER public_registration_enabled;

UPDATE events
SET registration_required = 1
WHERE registration_required IS NULL;