-- 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;





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;
