-- Restaurant modules: delivery, reservations, waste
-- Run as MySQL admin (cPanel → MySQL or root)

CREATE DATABASE IF NOT EXISTS erp_delivery CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS erp_reservations CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS erp_waste CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

CREATE USER IF NOT EXISTS 'erp_delivery'@'localhost' IDENTIFIED BY 'R@mez1980';
CREATE USER IF NOT EXISTS 'erp_reservations'@'localhost' IDENTIFIED BY 'R@mez1980';
CREATE USER IF NOT EXISTS 'erp_waste'@'localhost' IDENTIFIED BY 'R@mez1980';

GRANT ALL PRIVILEGES ON erp_delivery.* TO 'erp_delivery'@'localhost';
GRANT ALL PRIVILEGES ON erp_reservations.* TO 'erp_reservations'@'localhost';
GRANT ALL PRIVILEGES ON erp_waste.* TO 'erp_waste'@'localhost';

FLUSH PRIVILEGES;