-- Add visibility and team_id to the drills table
ALTER TABLE drills
ADD COLUMN visibility ENUM('private', 'team', 'public') NOT NULL DEFAULT 'private',
ADD COLUMN team_id INT NULL,
ADD FOREIGN KEY (team_id) REFERENCES teams(id) ON DELETE SET NULL;

-- Add visibility and team_id to the training_sessions table
ALTER TABLE training_sessions
ADD COLUMN visibility ENUM('private', 'team', 'public') NOT NULL DEFAULT 'private',
ADD COLUMN team_id INT NULL,
ADD FOREIGN KEY (team_id) REFERENCES teams(id) ON DELETE SET NULL;