CREATE DATABASE IF NOT EXISTS anglican_church
    CHARACTER SET utf8mb4
    COLLATE utf8mb4_unicode_ci;

-- Optional local user. Badilisha password kabla ya ku-run kwenye production.
CREATE USER IF NOT EXISTS 'anglican_user'@'localhost'
    IDENTIFIED BY 'change_this_password';

GRANT ALL PRIVILEGES ON anglican_church.* TO 'anglican_user'@'localhost';
FLUSH PRIVILEGES;
