-- ============================================
-- Chatbot Database Setup Script
-- ============================================
-- 
-- This script creates the database and user for the chatbot application.
-- 
-- IMPORTANT: Update the database name, username, and password 
-- in this file to match your config.php settings before running.
--
-- HOW TO USE:
-- 1. Open phpMyAdmin or MySQL command line
-- 2. Update the database name, username, and password below
-- 3. Run this entire script
-- 4. Update config.php with the same credentials
-- ============================================

-- Step 1: Create the database
CREATE DATABASE IF NOT EXISTS `thesol_chat` 
CHARACTER SET utf8mb4 
COLLATE utf8mb4_unicode_ci;



-- Step 4: Apply changes
FLUSH PRIVILEGES;

-- Step 5: Verify the setup
USE thesol_chat;



-- Show current database
SELECT DATABASE() AS current_database;

-- Show tables (will be empty until installation wizard runs)
SHOW TABLES;
