-- =====================================================
-- Script de configuración MySQL 8.0
-- Motor: MySQL Community Server 8.0.45
-- Cliente: libmysql - mysqlnd 8.4.16
-- =====================================================

-- Crear base de datos con charset UTF8MB4 (soporte completo de Unicode)
CREATE DATABASE IF NOT EXISTS escuelas_deportivas
  CHARACTER SET utf8mb4
  COLLATE utf8mb4_unicode_ci;

-- Usar la base de datos
USE escuelas_deportivas;



-- Verificar charset de la base de datos
SELECT 
  DEFAULT_CHARACTER_SET_NAME AS 'Charset',
  DEFAULT_COLLATION_NAME AS 'Collation'
FROM information_schema.SCHEMATA 
WHERE SCHEMA_NAME = 'escuelas_deportivas';

-- Verificar variables de configuración importantes
SHOW VARIABLES LIKE 'character_set%';
SHOW VARIABLES LIKE 'collation%';
SHOW VARIABLES LIKE 'max_connections';
