-- Setup Test Database for Global Gala
-- Run this with MySQL admin privileges:
-- mysql -u root -p < database/setup-test-database.sql

-- Create test database
CREATE DATABASE IF NOT EXISTS showprima_test CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- Grant privileges to showprima user
GRANT ALL PRIVILEGES ON showprima_test.* TO 'showprima'@'localhost';

-- Flush privileges
FLUSH PRIVILEGES;

-- Show confirmation
SELECT 'Test database created successfully!' AS status;
SHOW DATABASES LIKE 'showprima%';