-- تُنشأ القواعد فارغة عند أول إقلاع فقط (volume جديد).
CREATE DATABASE IF NOT EXISTS `mainDB` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS `rideDB` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS `locationDB` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS `transitDB` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS `paymentDB` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- إنشاء المستخدمين وإعطائهم الصلاحيات
CREATE USER IF NOT EXISTS 'intaleqapp-jordan-siro'@'%' IDENTIFIED BY '7B7skfibrexQrGCUG1Y8';
GRANT ALL PRIVILEGES ON `mainDB`.* TO 'intaleqapp-jordan-siro'@'%';

CREATE USER IF NOT EXISTS 'intaleqLocation'@'%' IDENTIFIED BY '9otdMyiExMTXwnoA32sP';
GRANT ALL PRIVILEGES ON `locationDB`.* TO 'intaleqLocation'@'%';

CREATE USER IF NOT EXISTS 'intaleq-rides'@'%' IDENTIFIED BY '0bHHMALEj4sqSmdT0avT';
GRANT ALL PRIVILEGES ON `rideDB`.* TO 'intaleq-rides'@'%';

CREATE USER IF NOT EXISTS 'siroTransitUser'@'%' IDENTIFIED BY 'eZiDYxCJ2yyGfC32zG0Z';
GRANT ALL PRIVILEGES ON `transitDB`.* TO 'siroTransitUser'@'%';

FLUSH PRIVILEGES;