-- Add visibility column to events table
-- Values: 'public' (default), 'private' (invite only), 'club_only' (club members only)

ALTER TABLE `events`
    ADD COLUMN `visibility` ENUM('public', 'private', 'club_only') NOT NULL DEFAULT 'public'
    AFTER `club_id`;

-- Backfill existing events as public
UPDATE `events` SET `visibility` = 'public' WHERE `visibility` IS NULL;
