-- ============================================
-- Add extra fields to arenas table
-- Run this in phpMyAdmin or MySQL console
-- ============================================

ALTER TABLE arenas
ADD COLUMN description TEXT NULL AFTER name,
ADD COLUMN address VARCHAR(255) NULL AFTER description,
ADD COLUMN phone VARCHAR(50) NULL AFTER address,
ADD COLUMN email VARCHAR(100) NULL AFTER phone,
ADD COLUMN logo VARCHAR(255) NULL AFTER email,
ADD COLUMN is_active TINYINT(1) NOT NULL DEFAULT 1 AFTER logo;

-- Add index for active arenas
CREATE INDEX idx_arenas_active ON arenas(is_active);