-- 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 `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `org_id` int DEFAULT NULL,
  `role_id` bigint unsigned NOT NULL,
  `first_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `password_hash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `job_title` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `preferred_lang` enum('ar','en') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `reviewer_score` int DEFAULT NULL,
  `email_verified_at` datetime DEFAULT NULL,
  `last_login_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ic3_approved` tinyint(1) DEFAULT '0',
  `orcid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expertise` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  KEY `fk_users_role` (`role_id`),
  CONSTRAINT `fk_users_role` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,1,1,'System','Administrator','admin@jpu.edu.jo','$2y$12$OMwjJw6KwIeO//b.DLOxt.GAlbU6RUY41//GFV44DajPnaxLEmyXq',NULL,NULL,NULL,NULL,'ar',1,NULL,NULL,'2026-04-28 02:14:27','2026-04-18 20:08:39','2026-04-27 23:14:27',0,NULL,NULL),(2,1,3,'محمد','أبوشقير','shquier@gmail.com','$2y$12$4vojeDDeo8524w6Uz4TrV.UAMlPVlgEnG/KmL98z.IBnhX7taRU3e',NULL,NULL,NULL,NULL,'ar',1,NULL,NULL,'2026-04-27 21:26:12','2026-04-20 20:30:10','2026-04-27 18:26:12',0,NULL,NULL),(3,1,4,'محمد محمود صالح','أبوشقير','shquier@jpu.edu.jo','$2y$12$OMwjJw6KwIeO//b.DLOxt.GAlbU6RUY41//GFV44DajPnaxLEmyXq',NULL,NULL,NULL,NULL,'ar',1,NULL,NULL,'2026-04-27 21:09:16','2026-04-21 08:52:50','2026-04-27 18:09:16',0,NULL,NULL),(4,1,5,'باحث','مؤتمر 1','turnitin01.jpu@gmail.com','$2y$12$KaafSqPE5HvtW70U9DACk.5.5yuyW3.D/uqJUlRz1WL21WvBquxcy','0790000000','0790000000',NULL,NULL,'ar',1,NULL,NULL,'2026-04-27 21:26:14','2026-04-21 15:18:59','2026-04-27 23:34:58',0,NULL,NULL),(5,1,2,'آدمن','الدراسات الآسيوية','jpu.social@gmail.com','$2y$12$/0.qjRjC7QIl80NjiGpD6OYh7py8ZkwifqFe8T4V/hYvyz3jNYvNi','0779830983','0779830983',NULL,NULL,'ar',1,NULL,NULL,'2026-04-22 05:17:54','2026-04-22 00:57:19','2026-04-27 23:29:11',0,NULL,NULL),(6,1,1,'Seed','SuperAdmin','seed.superadmin@easychair.test','$2y$12$IED7V4uWkv0io4lQIK3YUuMvQi5WgwuMxGu1Jo0q87bmPpNTDfDhK','0790000001','0790000001',NULL,'System Manager','en',1,100,NULL,'2026-04-27 23:53:57','2026-04-27 18:44:53','2026-04-27 23:29:11',0,NULL,'Full platform administration'),(7,1,6,'Seed','OrgAdmin','seed.orgadmin@easychair.test','$2y$12$IED7V4uWkv0io4lQIK3YUuMvQi5WgwuMxGu1Jo0q87bmPpNTDfDhK','0790000002','0790000002',NULL,'Organization Admin','en',1,90,NULL,'2026-04-27 23:56:48','2026-04-27 18:44:53','2026-04-27 23:29:11',0,NULL,'Organization administration'),(8,1,7,'Seed','Organizer','seed.organizer@easychair.test','$2y$12$IED7V4uWkv0io4lQIK3YUuMvQi5WgwuMxGu1Jo0q87bmPpNTDfDhK','0790000003','0790000003',NULL,'Conference Organizer','en',1,88,NULL,'2026-04-27 23:59:20','2026-04-27 18:44:53','2026-04-27 23:29:11',0,NULL,'Event and conference operations'),(9,1,8,'Seed','Admin','seed.admin@easychair.test','$2y$12$IED7V4uWkv0io4lQIK3YUuMvQi5WgwuMxGu1Jo0q87bmPpNTDfDhK','0790000004','0790000004',NULL,'Conference Admin','en',1,85,NULL,'2026-04-28 00:01:06','2026-04-27 18:44:53','2026-04-27 23:29:11',0,NULL,'Conference administration'),(10,1,2,'Seed','Chair','seed.chair@easychair.test','$2y$12$IED7V4uWkv0io4lQIK3YUuMvQi5WgwuMxGu1Jo0q87bmPpNTDfDhK','0790000005','0790000005',NULL,'Conference Chair','en',1,95,NULL,'2026-04-28 00:01:43','2026-04-27 18:44:53','2026-04-27 23:29:11',0,NULL,'Scientific committee leadership'),(11,1,3,'Seed','TrackChair','seed.trackchair@easychair.test','$2y$12$IED7V4uWkv0io4lQIK3YUuMvQi5WgwuMxGu1Jo0q87bmPpNTDfDhK','0790000006','0790000006',NULL,'Track Chair','en',1,92,NULL,'2026-04-28 00:02:08','2026-04-27 18:44:53','2026-04-27 23:29:11',0,NULL,'Track review management'),(12,1,4,'Seed','Reviewer','seed.reviewer@easychair.test','$2y$12$IED7V4uWkv0io4lQIK3YUuMvQi5WgwuMxGu1Jo0q87bmPpNTDfDhK','0790000007','0790000007',NULL,'Reviewer','en',1,87,NULL,'2026-04-28 00:21:51','2026-04-27 18:44:53','2026-04-27 23:29:11',0,NULL,'AI, Cybersecurity, Software Engineering'),(13,1,5,'Seed','Author','seed.author@easychair.test','$2y$12$IED7V4uWkv0io4lQIK3YUuMvQi5WgwuMxGu1Jo0q87bmPpNTDfDhK','0790000008','0790000008',NULL,'Author / Researcher','en',1,50,NULL,'2026-04-28 00:22:21','2026-04-27 18:44:53','2026-04-27 23:29:11',0,NULL,'Author test account'),(14,4,6,'Seed','Org4Admin','seed.org4admin@easychair.test','$2y$12$IED7V4uWkv0io4lQIK3YUuMvQi5WgwuMxGu1Jo0q87bmPpNTDfDhK','0790000009','0790000009',NULL,'Organization 4 Admin','en',1,80,NULL,'2026-04-28 00:05:21','2026-04-27 18:44:53','2026-04-27 23:29:11',0,NULL,'Second organization isolation testing'),(15,1,4,'Bulk','Reviewer One','bulk.reviewer1@easychair.test','$2y$12$9bJF3n0P4mCOgYPsc3FBWuVd9hIeAA.tvS0e544KgFGOjOn1/dtCq','0791000001','0791000001',NULL,'Reviewer','en',1,NULL,NULL,NULL,'2026-04-27 22:38:06','2026-04-27 23:29:11',0,NULL,'AI, NLP, Cybersecurity'),(16,1,4,'Bulk','Reviewer Two','bulk.reviewer2@easychair.test','$2y$12$YmS5Hu1PFapOc2sMj46OMOXY7h2X6gWg8qHO2b8BnembBVjgZUnc.','0791000002','0791000002',NULL,'Reviewer','en',1,NULL,NULL,NULL,'2026-04-27 22:38:06','2026-04-27 23:29:11',0,NULL,'Software Engineering, Data Science');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_conferences`
--

DROP TABLE IF EXISTS `user_conferences`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_conferences` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `conference_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_user_conf` (`user_id`,`conference_id`),
  KEY `conference_id` (`conference_id`),
  CONSTRAINT `user_conferences_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_conferences_ibfk_2` FOREIGN KEY (`conference_id`) REFERENCES `conferences` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_conferences`
--

LOCK TABLES `user_conferences` WRITE;
/*!40000 ALTER TABLE `user_conferences` DISABLE KEYS */;
INSERT INTO `user_conferences` VALUES (1,3,1,4,'2026-04-27 04:41:28'),(2,4,1,5,'2026-04-27 04:41:28'),(4,6,1,1,'2026-04-27 18:44:53'),(5,6,3,1,'2026-04-27 18:44:53'),(6,6,2,1,'2026-04-27 18:44:53'),(7,7,1,6,'2026-04-27 18:44:53'),(8,7,2,6,'2026-04-27 18:44:53'),(9,8,1,7,'2026-04-27 18:44:53'),(10,8,2,7,'2026-04-27 18:44:53'),(11,9,1,8,'2026-04-27 18:44:53'),(12,10,1,2,'2026-04-27 18:44:53'),(13,11,1,3,'2026-04-27 18:44:53'),(14,12,1,4,'2026-04-27 18:44:53'),(15,13,1,5,'2026-04-27 18:44:53'),(16,14,3,6,'2026-04-27 18:44:53'),(17,15,3,4,'2026-04-27 22:38:06'),(18,16,3,4,'2026-04-27 22:38:06'),(19,15,2,4,'2026-04-27 22:45:25'),(20,16,2,4,'2026-04-27 22:45:25');
/*!40000 ALTER TABLE `user_conferences` 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  4:42:58
