-- Run this in phpMyAdmin or MySQL CLI to create the database
CREATE DATABASE IF NOT EXISTS lawfirmV2_db CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- Verify database created
SHOW DATABASES LIKE 'lawfirmV2_db';

-- Use the database
USE lawfirmV2_db;

-- Show that database is empty (ready for migrations)
SHOW TABLES;
