-- Add visibility to clubs
-- public: visible to everyone
-- private: only visible to members and the creator

ALTER TABLE `clubs`
    ADD COLUMN `visibility` ENUM('public', 'private') NOT NULL DEFAULT 'public' AFTER `localisation`;

UPDATE `clubs` SET `visibility` = 'public' WHERE `visibility` IS NULL;
