-- Create the database
CREATE DATABASE IF NOT EXISTS kenyan_pos CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- Use the database
USE kenyan_pos;

-- Show confirmation
SELECT 'Database kenyan_pos created successfully!' as message;