-- ========================================
-- TEAM SESSIONS BLIND MODE FEATURE
-- Add blind_mode column to team_sessions table
-- Copy and paste this into phpMyAdmin SQL tab
-- ========================================

-- Add blind_mode column to team_sessions
ALTER TABLE `team_sessions` 
ADD COLUMN `blind_mode` TINYINT(1) NOT NULL DEFAULT 0 
COMMENT '0 = collaborative (all see all votes), 1 = blind (participants only see own votes)' 
AFTER `status`;

-- Verify the column was added
DESCRIBE team_sessions;

-- ========================================
-- VERIFICATION QUERY
-- ========================================
SELECT 
  TABLE_NAME, 
  COLUMN_NAME, 
  COLUMN_TYPE, 
  COLUMN_DEFAULT,
  COLUMN_COMMENT
FROM information_schema.COLUMNS 
WHERE TABLE_SCHEMA = DATABASE() 
  AND TABLE_NAME = 'team_sessions'
  AND COLUMN_NAME = 'blind_mode';

