-- Migration: Add is_secret column to teams table
-- Date: 2025-01-XX
-- Description: Adds is_secret column to teams table to allow creating secret teams that are not visible in personal settings for unauthorized users

-- ===== Add is_secret to teams =====
ALTER TABLE teams 
ADD COLUMN is_secret BOOLEAN DEFAULT FALSE NOT NULL AFTER description;

-- Add index for better query performance
ALTER TABLE teams 
ADD INDEX idx_is_secret (is_secret);

