-- MySQL dump 10.13  Distrib 8.4.7, for Linux (x86_64)
--
-- Host: localhost    Database: shquier_easychair
-- ------------------------------------------------------
-- Server version	8.4.7-0ubuntu0.25.04.2

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `rbac_menu_items`
--

DROP TABLE IF EXISTS `rbac_menu_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `rbac_menu_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `menu_key` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `label_ar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `module_key` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort_order` int NOT NULL DEFAULT '100',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_rmi_menu_key` (`menu_key`),
  UNIQUE KEY `uq_rmi_url` (`url`),
  KEY `idx_rmi_module` (`module_key`),
  KEY `idx_rmi_active` (`is_active`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rbac_menu_items`
--

LOCK TABLES `rbac_menu_items` WRITE;
/*!40000 ALTER TABLE `rbac_menu_items` DISABLE KEYS */;
INSERT INTO `rbac_menu_items` VALUES (1,'admin_dashboard','Dashboard','لوحة التحكم','/easychair/admin/dashboard','fa-home','dashboard',10,1,'2026-04-28 02:48:41','2026-04-28 02:48:41'),(2,'admin_conferences','Conferences','قائمة مؤتمراتك','/easychair/admin/conferences','fa-folder','conferences',20,1,'2026-04-28 02:48:41','2026-04-28 02:48:41'),(3,'admin_organizations','Organizations','المؤسسات','/easychair/admin/organizations','fa-building','organizations',25,1,'2026-04-28 02:48:41','2026-04-28 02:48:41'),(4,'admin_users','Users','المستخدمون','/easychair/admin/users','fa-users','users',30,1,'2026-04-28 02:48:41','2026-04-28 02:48:41'),(5,'admin_roles','Roles','إدارة الصلاحيات','/easychair/admin/roles','fa-user-shield','roles',35,1,'2026-04-28 02:48:41','2026-04-28 02:48:41'),(6,'admin_submissions','Submissions','إدارة التقديمات','/easychair/admin/submissions','fa-inbox','submissions',40,1,'2026-04-28 02:48:41','2026-04-28 02:48:41'),(7,'admin_reviewers','Reviewers','المحكمون','/easychair/admin/reviewers','fa-user-check','reviewers',50,1,'2026-04-28 02:48:41','2026-04-28 02:48:41'),(8,'admin_reviewer_expertise','Reviewer Expertise','خبرات المحكمين','/easychair/admin/reviewer-expertise','fa-user-check','reviewers',51,1,'2026-04-28 02:48:41','2026-04-28 02:48:41'),(9,'admin_review_form','Review Form','نموذج التحكيم','/easychair/admin/review-form','fa-clipboard-list','review_form',60,1,'2026-04-28 02:48:41','2026-04-28 02:48:41'),(10,'admin_workflow','Workflow','سير العمل','/easychair/admin/workflow','fa-diagram-project','workflow',70,1,'2026-04-28 02:48:41','2026-04-28 02:48:41'),(11,'admin_workflow_notifications','Workflow Notifications','تنبيهات سير العمل','/easychair/admin/workflow-notifications','fa-bell','workflow',71,1,'2026-04-28 02:48:41','2026-04-28 02:48:41'),(12,'admin_decisions','Decisions','لوحة القرارات','/easychair/admin/decisions','fa-gavel','decisions',80,1,'2026-04-28 02:48:41','2026-04-28 02:48:41'),(13,'admin_email_templates','Email Templates','قوالب البريد','/easychair/admin/email-templates','fa-envelope-open-text','email_templates',90,1,'2026-04-28 02:48:41','2026-04-28 02:48:41'),(14,'admin_conference_mail','Conference Mail','بريد المؤتمر','/easychair/admin/conference-mail','fa-envelope-circle-check','conference_mail',95,1,'2026-04-28 02:48:41','2026-04-28 02:48:41'),(15,'admin_notification_broadcast','Notification Broadcast','إرسال إشعار','/easychair/admin/notification-broadcast','fa-bullhorn','notifications',100,1,'2026-04-28 02:48:41','2026-04-28 02:48:41'),(16,'admin_notification_audit','Notification Audit','تدقيق الإشعارات','/easychair/admin/notification-audit','fa-bell-circle-check','notifications',101,1,'2026-04-28 02:48:41','2026-04-28 02:48:41'),(17,'admin_notification_digest','Notification Digest','ملخص الإشعارات','/easychair/admin/notification-digest','fa-newspaper','notifications',102,1,'2026-04-28 02:48:41','2026-04-28 02:48:41'),(18,'admin_conference_home','Conference Homepage','بناء الصفحة الرئيسية','/easychair/admin/conference-home','fa-palette','homepage',110,1,'2026-04-28 02:48:41','2026-04-28 02:48:41'),(19,'admin_production','Production','الإنتاج Camera-ready','/easychair/admin/production','fa-industry','production',120,1,'2026-04-28 02:48:41','2026-04-28 02:48:41'),(20,'admin_issues','Issues','وقائع المؤتمر','/easychair/admin/issues','fa-book','issues',130,1,'2026-04-28 02:48:41','2026-04-28 02:48:41'),(21,'admin_certificates','Certificates','الشهادات','/easychair/admin/certificates','fa-certificate','certificates',140,1,'2026-04-28 02:48:41','2026-04-28 02:48:41'),(22,'admin_business','Conference Business','الجلسات والبرنامج','/easychair/admin/conference-business','fa-chalkboard-user','sessions',150,1,'2026-04-28 02:48:41','2026-04-28 02:48:41'),(23,'admin_profile_completion','Profile Completion','اكتمال الملفات','/easychair/admin/profile-completion','fa-chart-pie','profile_fields',160,1,'2026-04-28 02:48:41','2026-04-28 02:48:41'),(24,'admin_profile_fields','Profile Fields','حقول الملف الأكاديمي','/easychair/admin/profile-fields','fa-list-check','profile_fields',161,1,'2026-04-28 02:48:41','2026-04-28 02:48:41'),(25,'admin_rbac_matrix','RBAC Matrix','مصفوفة الصلاحيات','/easychair/admin/rbac-matrix','fa-sliders','rbac',999,1,'2026-04-28 02:48:41','2026-04-28 02:48:41');
/*!40000 ALTER TABLE `rbac_menu_items` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-04-28 13:46:26
