-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jul 30, 2026 at 06:13 AM -- Server version: 10.4.32-MariaDB -- PHP Version: 8.2.12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!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 */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `innex` -- -- -------------------------------------------------------- -- -- Table structure for table `audit_logs` -- CREATE TABLE `audit_logs` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `action` varchar(255) NOT NULL, `auditable_type` varchar(255) DEFAULT NULL, `auditable_id` bigint(20) UNSIGNED DEFAULT NULL, `old_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`old_values`)), `new_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`new_values`)), `reason` text DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` text DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `audit_logs` -- INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `auditable_type`, `auditable_id`, `old_values`, `new_values`, `reason`, `ip_address`, `user_agent`, `created_at`) VALUES (1, 1, 'import.student_accounts', NULL, NULL, '[]', '{\"records\":30}', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-30 03:50:25'), (2, 1, 'competition.created', 'App\\Models\\Competition', 1, '[]', '{\"code\":\"INNODAY2026\",\"title\":\"Innovation Day 2026\",\"organiser\":\"Faculty of Computer Science and Technology\",\"venue\":\"FCUC Hall\",\"competition_date\":\"2026-08-11T16:00:00.000000Z\",\"registration_deadline\":\"2026-08-10T16:00:00.000000Z\",\"submission_deadline\":\"2026-08-10T16:00:00.000000Z\",\"status\":\"registration\",\"is_public\":true,\"categories\":[\"Mini Project\",\"Project-based\",\"Final Year Project\"],\"updated_at\":\"2026-07-30T03:54:09.000000Z\",\"created_at\":\"2026-07-30T03:54:09.000000Z\",\"id\":1}', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-30 03:54:09'), (3, 1, 'import.projects', NULL, NULL, '[]', '{\"records\":32}', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-30 04:00:19'), (4, 1, 'import.panel_accounts', NULL, NULL, '[]', '{\"records\":5}', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-30 04:06:56'), (5, 1, 'user.created', 'App\\Models\\User', 41, '[]', '{\"name\":\"Assoc. Prof. Ts. Dr. Chng Chern Wei\",\"username\":\"Dean\",\"email\":\"chernwei.chng@firstcity.edu.my\",\"role\":\"superadmin\",\"is_active\":true,\"student_id\":null,\"programme\":null,\"contact_no\":null,\"school_name\":null,\"locale\":\"en\",\"must_change_password\":true,\"updated_at\":\"2026-07-30T04:13:06.000000Z\",\"created_at\":\"2026-07-30T04:13:06.000000Z\",\"id\":41}', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-30 04:13:06'); -- -------------------------------------------------------- -- -- Table structure for table `cache` -- CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cache_locks` -- CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `certificates` -- CREATE TABLE `certificates` ( `id` bigint(20) UNSIGNED NOT NULL, `project_id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `certificate_no` varchar(255) NOT NULL, `verification_code` char(36) NOT NULL, `award_title` varchar(255) NOT NULL, `issued_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `issued_by` bigint(20) UNSIGNED NOT NULL, `revoked_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `competitions` -- CREATE TABLE `competitions` ( `id` bigint(20) UNSIGNED NOT NULL, `code` varchar(40) NOT NULL, `title` varchar(255) NOT NULL, `organiser` varchar(255) NOT NULL, `venue` varchar(255) DEFAULT NULL, `competition_date` date NOT NULL, `registration_deadline` datetime DEFAULT NULL, `submission_deadline` datetime DEFAULT NULL, `status` varchar(30) NOT NULL DEFAULT 'draft', `is_public` tinyint(1) NOT NULL DEFAULT 0, `categories` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`categories`)), `language_options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`language_options`)), `settings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`settings`)), `completed_at` timestamp NULL DEFAULT NULL, `completed_by` bigint(20) UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `competitions` -- INSERT INTO `competitions` (`id`, `code`, `title`, `organiser`, `venue`, `competition_date`, `registration_deadline`, `submission_deadline`, `status`, `is_public`, `categories`, `language_options`, `settings`, `completed_at`, `completed_by`, `created_at`, `updated_at`) VALUES (1, 'INNODAY2026', 'Innovation Day 2026', 'Faculty of Computer Science and Technology', 'FCUC Hall', '2026-08-12', '2026-08-11 00:00:00', '2026-08-11 00:00:00', 'registration', 1, '[\"Mini Project\",\"Project-based\",\"Final Year Project\"]', NULL, NULL, NULL, NULL, '2026-07-30 03:54:09', '2026-07-30 03:54:09'); -- -------------------------------------------------------- -- -- Table structure for table `evaluations` -- CREATE TABLE `evaluations` ( `id` bigint(20) UNSIGNED NOT NULL, `project_id` bigint(20) UNSIGNED NOT NULL, `panel_id` bigint(20) UNSIGNED NOT NULL, `rubric_id` bigint(20) UNSIGNED NOT NULL, `status` varchar(20) NOT NULL DEFAULT 'draft', `total_score` decimal(7,2) NOT NULL DEFAULT 0.00, `comments` text DEFAULT NULL, `justification` text DEFAULT NULL, `finalised_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `evaluation_scores` -- CREATE TABLE `evaluation_scores` ( `id` bigint(20) UNSIGNED NOT NULL, `evaluation_id` bigint(20) UNSIGNED NOT NULL, `rubric_criterion_id` bigint(20) UNSIGNED NOT NULL, `raw_score` decimal(7,2) NOT NULL, `weighted_score` decimal(7,2) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) NOT NULL, `connection` text NOT NULL, `queue` text NOT NULL, `payload` longtext NOT NULL, `exception` longtext NOT NULL, `failed_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `jobs` -- CREATE TABLE `jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `queue` varchar(255) NOT NULL, `payload` longtext NOT NULL, `attempts` tinyint(3) UNSIGNED NOT NULL, `reserved_at` int(10) UNSIGNED DEFAULT NULL, `available_at` int(10) UNSIGNED NOT NULL, `created_at` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `job_batches` -- CREATE TABLE `job_batches` ( `id` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `total_jobs` int(11) NOT NULL, `pending_jobs` int(11) NOT NULL, `failed_jobs` int(11) NOT NULL, `failed_job_ids` longtext NOT NULL, `options` mediumtext DEFAULT NULL, `cancelled_at` int(11) DEFAULT NULL, `created_at` int(11) NOT NULL, `finished_at` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '0001_01_01_000000_create_users_table', 1), (2, '2026_07_25_000100_create_picms_tables', 1); -- -------------------------------------------------------- -- -- Table structure for table `panel_assignments` -- CREATE TABLE `panel_assignments` ( `id` bigint(20) UNSIGNED NOT NULL, `project_id` bigint(20) UNSIGNED NOT NULL, `panel_id` bigint(20) UNSIGNED NOT NULL, `assigned_by` bigint(20) UNSIGNED NOT NULL, `assigned_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `password_reset_tokens` -- CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `projects` -- CREATE TABLE `projects` ( `id` bigint(20) UNSIGNED NOT NULL, `competition_id` bigint(20) UNSIGNED NOT NULL, `project_code` varchar(50) NOT NULL, `title` varchar(255) NOT NULL, `category` varchar(255) NOT NULL DEFAULT 'Open', `abstract` longtext DEFAULT NULL, `status` varchar(30) NOT NULL DEFAULT 'draft', `average_score` decimal(7,2) DEFAULT NULL, `rank` int(10) UNSIGNED DEFAULT NULL, `award_title` varchar(255) DEFAULT NULL, `submitted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `projects` -- INSERT INTO `projects` (`id`, `competition_id`, `project_code`, `title`, `category`, `abstract`, `status`, `average_score`, `rank`, `award_title`, `submitted_at`, `created_at`, `updated_at`) VALUES (1, 1, 'P001', 'Smart Bicycle Health and Security Monitoring System', 'Mini Project', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (2, 1, 'P002', 'Maximizing the Potential of ChatGPT: Strategies for Successful Implementation in the Education Sector', 'Project-based', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (3, 1, 'P003', 'Maximizing the Potential of ChatGPT: Strategies for Successful Implementation in the Education Sector', 'Project-based', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (4, 1, 'P004', 'Maximizing the Potential of ChatGPT: Strategies for Successful Implementation in the Education Sector', 'Project-based', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (5, 1, 'P005', 'EduVR Hall Tour using A-Frame', 'Final Year Project', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (6, 1, 'P006', 'CampusEats: Mobile Food Ordering System for FCUC', 'Final Year Project', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (7, 1, 'P007', 'Vision-based Remote Online Play Platform For Trading Card Game', 'Final Year Project', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (8, 1, 'P008', 'Community TechCare', 'Mini Assignment', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (9, 1, 'P009', 'GreenQuest Campus', 'Mini Assignment', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (10, 1, 'P010', 'FCST EventPass', 'Mini Assignment', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (11, 1, 'P011', 'FCST InnovateHub', 'Mini Assignment', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (12, 1, 'P012', 'FCST SkillSwap+', 'Mini Assignment', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (13, 1, 'P013', 'ResearchMatch FCST', 'Mini Assignment', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (14, 1, 'P014', 'Wireless Smart Bin', 'Final Year Project', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (15, 1, 'P015', 'First City Campus LostFoundHub', 'Mini Project', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (16, 1, 'P016', 'KeepItSafe: Your Offline Secure Password Manager', 'Final Year Project', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (17, 1, 'P017', 'Phishing Detection Tool using Natural Language Processing', 'Final Year Project', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (18, 1, 'P018', 'Information Governance for SAlFE', 'Project-based', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (19, 1, 'P019', 'Mental Health Awareness Application', 'Final Year Project', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (20, 1, 'P020', 'MonsterVision: An intelligent booking system for Monster Tennis KL', 'Final Year Project', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (21, 1, 'P021', 'Gamified Learning: An Educational System to Improve Spelling and Focus_in_Children', 'Final Year Project', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (22, 1, 'P022', 'ElderCare Connect: Mobile Elderly Care Application', 'Project-based', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (23, 1, 'P023', 'A Location - Based Event Aggregaration System Using Web Scraping', 'FInal Year Project', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (24, 1, 'P024', 'Web-based Fuzzy Logic Data Generation System', 'Project-based', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (25, 1, 'P025', 'Stock Market Prediction Model', 'Final Year Project', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (26, 1, 'P026', 'SmartShield Connect: AI-Enhanced Secure Distributed Communication Framework', 'Mini Project', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (27, 1, 'P027', 'Smart-Context-Aware Face Recognition Attendance System for Smart Classroom Environments', 'Mini Project', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (28, 1, 'P028', 'Lightweight Activity Detection', 'Project-based', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (29, 1, 'P029', 'Malaysian Cybercrime: Real-Worls Case Studies and Legal Frameworks', 'Project-based', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (30, 1, 'P030', 'Face Following Robotic Vehicle with Optimized Computer Vision Initialization', 'Final Year Project', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (31, 1, 'P031', 'Industrial IoT Predictive Maintenance System for Bearing Fault Detection Using Vibration and Acoustic Signals', 'Final Year Project', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (32, 1, 'P032', 'Fully Mechanical Prosthetic Finger', 'Final Year Project', '', 'draft', NULL, NULL, NULL, NULL, '2026-07-30 04:00:19', '2026-07-30 04:00:19'); -- -------------------------------------------------------- -- -- Table structure for table `project_files` -- CREATE TABLE `project_files` ( `id` bigint(20) UNSIGNED NOT NULL, `project_id` bigint(20) UNSIGNED NOT NULL, `type` varchar(30) NOT NULL, `original_name` varchar(255) NOT NULL, `path` varchar(255) NOT NULL, `mime_type` varchar(255) DEFAULT NULL, `size` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `uploaded_by` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `project_members` -- CREATE TABLE `project_members` ( `id` bigint(20) UNSIGNED NOT NULL, `project_id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `is_leader` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `project_members` -- INSERT INTO `project_members` (`id`, `project_id`, `user_id`, `is_leader`, `created_at`, `updated_at`) VALUES (1, 1, 2, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (2, 2, 3, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (3, 3, 4, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (4, 4, 5, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (5, 5, 6, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (6, 6, 7, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (7, 7, 8, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (8, 8, 9, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (9, 9, 10, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (10, 10, 11, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (11, 11, 12, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (12, 12, 13, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (13, 13, 14, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (14, 14, 15, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (15, 15, 16, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (16, 16, 17, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (17, 17, 18, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (18, 18, 19, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (19, 19, 20, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (20, 20, 21, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (21, 21, 22, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (22, 22, 23, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (23, 23, 23, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (24, 24, 24, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (25, 25, 25, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (26, 26, 25, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (27, 27, 26, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (28, 28, 27, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (29, 29, 28, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (30, 30, 29, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (31, 31, 30, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (32, 32, 31, 1, '2026-07-30 04:00:19', '2026-07-30 04:00:19'); -- -------------------------------------------------------- -- -- Table structure for table `rubrics` -- CREATE TABLE `rubrics` ( `id` bigint(20) UNSIGNED NOT NULL, `competition_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `description` text DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `rubric_criteria` -- CREATE TABLE `rubric_criteria` ( `id` bigint(20) UNSIGNED NOT NULL, `rubric_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `description` text DEFAULT NULL, `max_score` decimal(7,2) NOT NULL, `weightage` decimal(7,2) NOT NULL, `display_order` int(10) UNSIGNED NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `sessions` -- CREATE TABLE `sessions` ( `id` varchar(255) NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` text DEFAULT NULL, `payload` longtext NOT NULL, `last_activity` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sessions` -- INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('ojdMwpuEn4iNPe66RTvJ7YL6SUmFFJ7kVSx0mPgB', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiazdPOFBtdklGaGJLTjFyMmNhMHphWHlzZFJoSkhia0p5Q2FWSmNXVSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly9sb2NhbGhvc3QvSU5ORVgvcHVibGljL2xvZ2luIjtzOjU6InJvdXRlIjtzOjU6ImxvZ2luIjt9fQ==', 1785384791); -- -------------------------------------------------------- -- -- Table structure for table `supervisors` -- CREATE TABLE `supervisors` ( `id` bigint(20) UNSIGNED NOT NULL, `project_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) DEFAULT NULL, `organisation` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `supervisors` -- INSERT INTO `supervisors` (`id`, `project_id`, `name`, `email`, `organisation`, `created_at`, `updated_at`) VALUES (1, 1, 'Mr. Cham Kah Loon', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (2, 2, 'Asst. Prof. Ir. Dr. Tay Ching En Marcus', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (3, 3, 'Asst. Prof. Ir. Dr. Tay Ching En Marcus', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (4, 4, 'Asst. Prof. Ir. Dr. Tay Ching En Marcus', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (5, 5, 'Mr. Mohd Sukry Bin Mohd Taib', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (6, 6, 'Miss Nur Safura binti Mohd Rafee', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (7, 7, 'Mr. Mohd Norfitri Bin Nordin', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (8, 8, 'Mr. Ibrahim Bin Mohd Jamadi', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (9, 9, 'Mr. Ibrahim Bin Mohd Jamadi', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (10, 10, 'Mr. Ibrahim Bin Mohd Jamadi', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (11, 11, 'Mr. Ibrahim Bin Mohd Jamadi', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (12, 12, 'Mr. Ibrahim Bin Mohd Jamadi', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (13, 13, 'Mr. Ibrahim Mohd Jamadi', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (14, 14, 'Ir. Muammar Quadaffi bin Mohd Ariffin', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (15, 15, 'Dr. Seow Yoke May', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (16, 16, 'Dr. Ridhwan Hilmi', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (17, 17, 'Mr. Mohd Sukry Mohd Taib', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (18, 18, 'Lee Shy Yun', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (19, 19, 'Mr. Mohd Norfitri Bin Nordin', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (20, 20, 'Ir. Muammar Quadaffi bin Mohd Ariffin', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (21, 21, 'Ts. Siti Syahirah Binti Ibrahim', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (22, 22, 'Mr. Mohd Norfitri Bin Nordin', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (23, 23, 'Dr. Ridhwan Hilmi', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (24, 24, 'Mr. Mohd Norfitri Bin Nordin', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (25, 25, 'Mr. Ibrahim Bin Mohd Jamadi', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (26, 26, 'Assoc. Prof. Ts. Dr. Chng Chern Wei', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (27, 27, 'Mohd Sukry Bin Mohd Taib', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (28, 28, 'Ts. Siti Syahirah Binti Ibrahim', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (29, 29, 'Lee Shy Yun', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (30, 30, 'Asst. Prof. Ir. Dr. Tay Ching En Marcus', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (31, 31, 'Asst. Prof. Ir. Dr. Tay Ching En Marcus', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'), (32, 32, 'Ir. Muammar Quadaffi bin Mohd Ariffin', NULL, 'Faculty of Computer Science and Technology', '2026-07-30 04:00:19', '2026-07-30 04:00:19'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `username` varchar(100) NOT NULL, `email` varchar(255) NOT NULL, `role` varchar(40) NOT NULL DEFAULT 'student', `is_active` tinyint(1) NOT NULL DEFAULT 1, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `must_change_password` tinyint(1) NOT NULL DEFAULT 1, `locale` varchar(5) NOT NULL DEFAULT 'en', `student_id` varchar(80) DEFAULT NULL, `programme` varchar(255) DEFAULT NULL, `contact_no` varchar(50) DEFAULT NULL, `school_name` varchar(255) DEFAULT NULL, `photo_path` varchar(255) DEFAULT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `username`, `email`, `role`, `is_active`, `email_verified_at`, `password`, `must_change_password`, `locale`, `student_id`, `programme`, `contact_no`, `school_name`, `photo_path`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'INNEX Superadmin', 'superadmin', 'superadmin@innex.local', 'superadmin', 1, NULL, '$2y$12$eZY7Hqr4Eav/8vtanMJz7OSHpVTUGMhtTVWBCy4tJKMH6gEnz7BwW', 0, 'en', NULL, NULL, NULL, NULL, NULL, NULL, '2026-07-30 03:37:15', '2026-07-30 03:37:15'), (2, 'Loke Qin Hui', 'b2565', 'b2565@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$GbIB9M8KDV4xvN2RcFdhD.u8RW51zUMaWabFgNpS1d5fH5/RthYq.', 1, 'en', 'b2565', 'Foundation in Computer Science & Technology', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:16', '2026-07-30 03:50:16'), (3, 'Daeswin Balachandran', 'b2625', 'b2625@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$HyKupXRPVfjZ9vXH8TdBQePBP.kqkI7gtjvs5.1KrMvP1C0Hc06jK', 1, 'en', 'b2625', 'Foundation in Computer Science & Technology', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:16', '2026-07-30 03:50:16'), (4, 'Benjamin Lim Joon Yuen', 'b2626', 'b2626@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$vWSFchbBUUzPoopNAOcN1OaEXzONo0ZhRCKdVWZf9i54bBZGJ2rs2', 1, 'en', 'b2626', 'Foundation in Computer Science & Technology', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:17', '2026-07-30 03:50:17'), (5, 'Bryan Matthew Jalleh', 'b2648', 'b2648@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$OjrRn1i3aaB0GpEh.yBT1u19X/DhNlj07MscPSIalVbustOjIwZGe', 1, 'en', 'b2648', 'Foundation in Computer Science & Technology', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:17', '2026-07-30 03:50:17'), (6, 'Danya Loo Yixuan', 'b2564', 'b2564@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$2OkybVNY6.GVGhkbcafFXOEf83GYetneJ8hYRXCFUwZ4nC8i0JtAC', 1, 'en', 'b2564', 'Diploma in Information Technology', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:17', '2026-07-30 03:50:17'), (7, 'Stephanie Hew Pui Yan', 'b2567', 'b2567@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$Goxh5WIdOCdeTsa8Oj16i.ebslZ22i9SPEsbGU6lsr1nACR1Q.TYq', 1, 'en', 'b2567', 'Diploma in Information Technology', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:18', '2026-07-30 03:50:18'), (8, 'Howen Lim', 'b2542', 'b2542@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$E7Qcj7zcwRbrrzfyJRPmjeqSxVn8SL5YWy8Zf01nWGGCgslqvxC92', 1, 'en', 'b2542', 'Diploma in Information Technology', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:18', '2026-07-30 03:50:18'), (9, 'Soh Hok Jin', 'b2631', 'b2631@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$LnGtEqzYE18H98cYkEXF9.RBBd2dW1OCiW4UdE3cNy1rq/QPwhDtq', 1, 'en', 'b2631', 'Diploma in Information Technology', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:18', '2026-07-30 03:50:18'), (10, 'Hea Hang', 'b2647', 'b2647@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$76UvpUUSxta552Uz81lb5e1z6SQzWHTTPyYakRaHESPJTC7jLhoii', 1, 'en', 'b2647', 'Diploma in Information Technology', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:18', '2026-07-30 03:50:18'), (11, 'Wong Chen Han', 'b2669', 'b2669@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$6JUTvHoEYVQQoi93pC0gt.48AdyuiIvesBqWaIjxGSIn1RbkFLrwW', 1, 'en', 'b2669', 'Diploma in Information Technology', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:19', '2026-07-30 03:50:19'), (12, 'Ong Chuan Cheng', 'b2618', 'b2618@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$shDgzWqLt9OGSYYfB0bCxuciDP7CapKuL6w/1ouEzq0k.I0n24dce', 1, 'en', 'b2618', 'Diploma in Information Technology', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:19', '2026-07-30 03:50:19'), (13, 'Chen Xin Rou', 'b2586', 'b2586@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$xvOJIcqUBWbLtn6hp3qnHuakfeWZcsxVWdA/JWaLz3UsXii/WP1li', 1, 'en', 'b2586', 'Diploma in Information Technology', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:19', '2026-07-30 03:50:19'), (14, 'Cavis Lee Zi Xuan', 'b2596', 'b2596@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$GSjrlH/26tHwuv.WX0TpWevMgJAw04H8BmWAB0ufgc9PsWEasRshO', 1, 'en', 'b2596', 'Diploma in Information Technology', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:20', '2026-07-30 03:50:20'), (15, 'Alvis Ang Kim Lee', 'b2032', 'b2032@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$S20wBe7sSNQU//nxt57y2OXr4XgIoiNADoA1PY/xPd5zYQoqyzsUe', 1, 'en', 'b2032', 'Bachelor of Information Technology (Networking and Security) (Hons)', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:20', '2026-07-30 03:50:20'), (16, 'Ong Yi Lyn', 'b2494', 'b2494@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$IW5kvMhwNA9xzjjTIFhwJOJFotTfeJi2k8RndXON5zf8QFko3oTPu', 1, 'en', 'b2494', 'Bachelor of Information Technology (Networking and Security) (Hons)', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:20', '2026-07-30 03:50:20'), (17, 'Adzreza Syahmie Bin \'Adzzham Syahzany', 'b2390', 'b2390@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$tzAefjTg7mzKIMWZ3xKwXuD.CMwYmBCn.OFxQll7UFFlxUweBWLPG', 1, 'en', 'b2390', 'Bachelor of Information Technology (Networking and Security) (Hons)', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:20', '2026-07-30 03:50:20'), (18, 'Ng Yan Hui', 'b2103', 'b2103@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$TIPcSyiuCz8AikmTliTO4uDOyY2LBycBxcfhd4.Rgg64SRCCypwcy', 1, 'en', 'b2103', 'Bachelor of Information Technology (Networking and Security) (Hons)', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:21', '2026-07-30 03:50:21'), (19, 'Alvis Ang Kim Lee', 'b2094', 'b2094@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$Wc3xF/ZQ0JNxjT1jj1PZ..dSsHhmaNnyENibKBD1mU1QbWbNhDY.y', 1, 'en', 'b2094', 'Bachelor in Information Systems (Business Management) (Honours)', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:21', '2026-07-30 03:50:21'), (20, 'Ong Yi Lyn', 'b1863', 'b1863@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$3S4QS7S4baomBDq7ECNHhOHaoDsCt9t9M8Xfb.fXXhA4qIbRRzZm.', 1, 'en', 'b1863 ', 'Bachelor in Information Systems (Business Management) (Honours)', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:21', '2026-07-30 03:50:21'), (21, 'Jashlienne Quisha San Pedro', 'b2365', 'b2365@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$zLURFEWVgZOOg.dHgsQqoutFnmpoAjYpkwQihjep.0KSnmKRvOnqG', 1, 'en', 'b2365', 'Bachelor of Software Engineering (Honours)', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:22', '2026-07-30 03:50:22'), (22, 'Foo Huei Nie', 'b1920', 'b1920@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$XFYJLnNMJHtuZ8aRQDICzu7tCnlIZ98vFZM3j/QwCxkOViuhH6hyG', 1, 'en', 'b1920', 'Bachelor of Software Engineering (Honours)', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:22', '2026-07-30 03:50:22'), (23, 'Charles Thomas Morss', 'b2431', 'b2431@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$RTPzVJIArYp25MiKLNo2s.UMOyz4ZckeDyu4NWzf0r/PCggpHr2nG', 1, 'en', 'b2431', 'Bachelor in Computer Science (Intelligent Systems) (Honours)', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:22', '2026-07-30 03:50:22'), (24, 'Nataniel Su Chuan Hong', 'b2370', 'b2370@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$7M4jli1BcKrr929CjW7CeOWo2O6TNmjhdo4PQCVKO.W2SvV8YiFxy', 1, 'en', 'b2370', 'Bachelor in Computer Science (Intelligent Systems) (Honours)', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:22', '2026-07-30 03:50:22'), (25, 'Saahil Wasim Mollah', 'b2200', 'b2200@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$.fZ9YSRtTZoFdVyvjdERrucGx21XdnoB2KyHLmKluwf7WMoTWlG0q', 1, 'en', 'b2200', 'Bachelor in Computer Science (Intelligent Systems) (Honours)', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:23', '2026-07-30 03:50:23'), (26, 'Goh En Qi', 'b2310', 'b2310@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$vFn8WLR39sq2P4hBivmVxumCV47H7rJAWmBMrEfHgDL.c9RueF9ya', 1, 'en', 'b2310', 'Bachelor in Computer Science (Intelligent Systems) (Honours)', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:23', '2026-07-30 03:50:23'), (27, 'Chang Shun Ren', 'b2570', 'b2570@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$4AM1PZIY19Y5RsIa85MzFOb7tUitwJ57MNXVPLLGSnOKduj0PEwB6', 1, 'en', 'b2570', 'Bachelor in Computer Science (Intelligent Systems) (Honours)', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:23', '2026-07-30 03:50:23'), (28, 'Loh Jen Sen', 'b2010', 'b2010@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$vqZt7fp/A1AtdVNIbK2VXeC8mUlkARjiEpaLpHFVAubB9RgnQ4ZH2', 1, 'en', 'b2010', 'Bachelor in Computer Science (Intelligent Systems) (Honours)', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:24', '2026-07-30 03:50:24'), (29, 'Chin Zhi Kuang', 'b1558', 'b1558@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$e4jxQNvSzj53hfJUu34oCONwBwrQtYaGByR17zvezu9bRKp84bE/K', 1, 'en', 'b1558', 'Bachelor of Electronic Engineering', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:24', '2026-07-30 03:50:24'), (30, 'Venice Tam Yu Han', 'b1772', 'b1772@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$qezLmEvKMKIJhU5qXOyVQuidcdxZcshXwNx018aTqRI0ha3o3puU2', 1, 'en', 'b1772', 'Bachelor of Electronic Engineering', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:24', '2026-07-30 03:50:24'), (31, 'Krishen Bharathen', 'b1853', 'b1853@student.firstcity.edu.my', 'student', 1, NULL, '$2y$12$n1wVCORpi8jvhKEX82J88eD8MNrUAgm2uWqC4eec2Gu94x3l0toRu', 1, 'en', 'b1853', 'Bachelor of Mechanical Engineering', NULL, 'Faculty of Computer Science & Technology', NULL, NULL, '2026-07-30 03:50:24', '2026-07-30 03:50:24'), (36, 'Dr. Ahmad Zakwan Azizul Fata', 'panel001', 'zakwanfata@gmail.com', 'evaluation-panel', 1, NULL, '$2y$12$2LXxWTE2L1ppJsH.Rlzu8ek8l2RU57xnNcoMZu0NpzpZqVG5G4mda', 1, 'en', NULL, NULL, NULL, 'Sapura Secured Technologies', NULL, NULL, '2026-07-30 04:06:55', '2026-07-30 04:06:55'), (37, 'Alif Haikal Razak', 'panel002', 'alifhaikal88@gmail.com', 'evaluation-panel', 1, NULL, '$2y$12$949k2iAA1D9I3Pz2Uhqc8ujtC6Xd5lVUZc4VdMM7xC8QkfNB4S7VW', 1, 'en', NULL, NULL, NULL, 'AXAI DIGITAL SDN BHD', NULL, NULL, '2026-07-30 04:06:55', '2026-07-30 04:06:55'), (38, 'Firdaus Samad', 'panel003', 'firdausamad@gmail.com', 'evaluation-panel', 1, NULL, '$2y$12$ewRt0XWZduuUIfZD72vNCu8J/W.PZi4f9LKAvkMFVBsDe1zgSokgW', 1, 'en', NULL, NULL, NULL, 'Devduck Solutions', NULL, NULL, '2026-07-30 04:06:56', '2026-07-30 04:06:56'), (39, 'Mohd Zakir Yaakob', 'panel004', 'mzakir47@gmail.com', 'evaluation-panel', 1, NULL, '$2y$12$dZ6YospEzgN1EP5GvA7e3uawkUp4eRgB6JrCLqAh2gE2btWqLyWCu', 1, 'en', NULL, NULL, NULL, 'Kinara Business Solutions', NULL, NULL, '2026-07-30 04:06:56', '2026-07-30 04:06:56'), (40, 'Dieter Lim', 'panel005', 'dieter@vtcsolution.com', 'evaluation-panel', 1, NULL, '$2y$12$OWvfhnqAzk6Q67tSwOI/x.8vT75mbafpZyapyumh5nsOGSp1fLQs6', 1, 'en', NULL, NULL, NULL, 'VTC Solution Sdn. Bhd.', NULL, NULL, '2026-07-30 04:06:56', '2026-07-30 04:06:56'), (41, 'Assoc. Prof. Ts. Dr. Chng Chern Wei', 'Dean', 'chernwei.chng@firstcity.edu.my', 'superadmin', 1, NULL, '$2y$12$KjTw.HJh2NRrwRA1YVjZYeyX3roQeOZ5hg6Hc6dmiV3VJyNOsFWI6', 1, 'en', NULL, NULL, NULL, NULL, NULL, NULL, '2026-07-30 04:13:06', '2026-07-30 04:13:06'); -- -- Indexes for dumped tables -- -- -- Indexes for table `audit_logs` -- ALTER TABLE `audit_logs` ADD PRIMARY KEY (`id`), ADD KEY `audit_logs_user_id_foreign` (`user_id`), ADD KEY `audit_logs_auditable_type_auditable_id_index` (`auditable_type`,`auditable_id`), ADD KEY `audit_logs_action_index` (`action`); -- -- Indexes for table `cache` -- ALTER TABLE `cache` ADD PRIMARY KEY (`key`); -- -- Indexes for table `cache_locks` -- ALTER TABLE `cache_locks` ADD PRIMARY KEY (`key`); -- -- Indexes for table `certificates` -- ALTER TABLE `certificates` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `certificates_project_id_user_id_unique` (`project_id`,`user_id`), ADD UNIQUE KEY `certificates_certificate_no_unique` (`certificate_no`), ADD UNIQUE KEY `certificates_verification_code_unique` (`verification_code`), ADD KEY `certificates_user_id_foreign` (`user_id`), ADD KEY `certificates_issued_by_foreign` (`issued_by`); -- -- Indexes for table `competitions` -- ALTER TABLE `competitions` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `competitions_code_unique` (`code`), ADD KEY `competitions_completed_by_foreign` (`completed_by`), ADD KEY `competitions_status_index` (`status`); -- -- Indexes for table `evaluations` -- ALTER TABLE `evaluations` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `evaluations_project_id_panel_id_unique` (`project_id`,`panel_id`), ADD KEY `evaluations_panel_id_foreign` (`panel_id`), ADD KEY `evaluations_rubric_id_foreign` (`rubric_id`), ADD KEY `evaluations_status_index` (`status`); -- -- Indexes for table `evaluation_scores` -- ALTER TABLE `evaluation_scores` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `evaluation_scores_evaluation_id_rubric_criterion_id_unique` (`evaluation_id`,`rubric_criterion_id`), ADD KEY `evaluation_scores_rubric_criterion_id_foreign` (`rubric_criterion_id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `jobs` -- ALTER TABLE `jobs` ADD PRIMARY KEY (`id`), ADD KEY `jobs_queue_index` (`queue`); -- -- Indexes for table `job_batches` -- ALTER TABLE `job_batches` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `panel_assignments` -- ALTER TABLE `panel_assignments` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `panel_assignments_project_id_panel_id_unique` (`project_id`,`panel_id`), ADD KEY `panel_assignments_panel_id_foreign` (`panel_id`), ADD KEY `panel_assignments_assigned_by_foreign` (`assigned_by`); -- -- Indexes for table `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD PRIMARY KEY (`email`); -- -- Indexes for table `projects` -- ALTER TABLE `projects` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `projects_competition_id_project_code_unique` (`competition_id`,`project_code`), ADD KEY `projects_category_index` (`category`), ADD KEY `projects_status_index` (`status`); -- -- Indexes for table `project_files` -- ALTER TABLE `project_files` ADD PRIMARY KEY (`id`), ADD KEY `project_files_project_id_foreign` (`project_id`), ADD KEY `project_files_uploaded_by_foreign` (`uploaded_by`), ADD KEY `project_files_type_index` (`type`); -- -- Indexes for table `project_members` -- ALTER TABLE `project_members` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `project_members_project_id_user_id_unique` (`project_id`,`user_id`), ADD KEY `project_members_user_id_foreign` (`user_id`); -- -- Indexes for table `rubrics` -- ALTER TABLE `rubrics` ADD PRIMARY KEY (`id`), ADD KEY `rubrics_competition_id_foreign` (`competition_id`), ADD KEY `rubrics_is_active_index` (`is_active`); -- -- Indexes for table `rubric_criteria` -- ALTER TABLE `rubric_criteria` ADD PRIMARY KEY (`id`), ADD KEY `rubric_criteria_rubric_id_foreign` (`rubric_id`); -- -- Indexes for table `sessions` -- ALTER TABLE `sessions` ADD PRIMARY KEY (`id`), ADD KEY `sessions_user_id_index` (`user_id`), ADD KEY `sessions_last_activity_index` (`last_activity`); -- -- Indexes for table `supervisors` -- ALTER TABLE `supervisors` ADD PRIMARY KEY (`id`), ADD KEY `supervisors_project_id_foreign` (`project_id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_username_unique` (`username`), ADD UNIQUE KEY `users_email_unique` (`email`), ADD KEY `users_role_index` (`role`), ADD KEY `users_is_active_index` (`is_active`), ADD KEY `users_student_id_index` (`student_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `audit_logs` -- ALTER TABLE `audit_logs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `certificates` -- ALTER TABLE `certificates` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `competitions` -- ALTER TABLE `competitions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `evaluations` -- ALTER TABLE `evaluations` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `evaluation_scores` -- ALTER TABLE `evaluation_scores` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `jobs` -- ALTER TABLE `jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `panel_assignments` -- ALTER TABLE `panel_assignments` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `projects` -- ALTER TABLE `projects` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33; -- -- AUTO_INCREMENT for table `project_files` -- ALTER TABLE `project_files` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `project_members` -- ALTER TABLE `project_members` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33; -- -- AUTO_INCREMENT for table `rubrics` -- ALTER TABLE `rubrics` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `rubric_criteria` -- ALTER TABLE `rubric_criteria` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `supervisors` -- ALTER TABLE `supervisors` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42; -- -- Constraints for dumped tables -- -- -- Constraints for table `audit_logs` -- ALTER TABLE `audit_logs` ADD CONSTRAINT `audit_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `certificates` -- ALTER TABLE `certificates` ADD CONSTRAINT `certificates_issued_by_foreign` FOREIGN KEY (`issued_by`) REFERENCES `users` (`id`), ADD CONSTRAINT `certificates_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `certificates_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `competitions` -- ALTER TABLE `competitions` ADD CONSTRAINT `competitions_completed_by_foreign` FOREIGN KEY (`completed_by`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `evaluations` -- ALTER TABLE `evaluations` ADD CONSTRAINT `evaluations_panel_id_foreign` FOREIGN KEY (`panel_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `evaluations_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `evaluations_rubric_id_foreign` FOREIGN KEY (`rubric_id`) REFERENCES `rubrics` (`id`); -- -- Constraints for table `evaluation_scores` -- ALTER TABLE `evaluation_scores` ADD CONSTRAINT `evaluation_scores_evaluation_id_foreign` FOREIGN KEY (`evaluation_id`) REFERENCES `evaluations` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `evaluation_scores_rubric_criterion_id_foreign` FOREIGN KEY (`rubric_criterion_id`) REFERENCES `rubric_criteria` (`id`); -- -- Constraints for table `panel_assignments` -- ALTER TABLE `panel_assignments` ADD CONSTRAINT `panel_assignments_assigned_by_foreign` FOREIGN KEY (`assigned_by`) REFERENCES `users` (`id`), ADD CONSTRAINT `panel_assignments_panel_id_foreign` FOREIGN KEY (`panel_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `panel_assignments_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE; -- -- Constraints for table `projects` -- ALTER TABLE `projects` ADD CONSTRAINT `projects_competition_id_foreign` FOREIGN KEY (`competition_id`) REFERENCES `competitions` (`id`) ON DELETE CASCADE; -- -- Constraints for table `project_files` -- ALTER TABLE `project_files` ADD CONSTRAINT `project_files_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `project_files_uploaded_by_foreign` FOREIGN KEY (`uploaded_by`) REFERENCES `users` (`id`); -- -- Constraints for table `project_members` -- ALTER TABLE `project_members` ADD CONSTRAINT `project_members_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `project_members_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `rubrics` -- ALTER TABLE `rubrics` ADD CONSTRAINT `rubrics_competition_id_foreign` FOREIGN KEY (`competition_id`) REFERENCES `competitions` (`id`) ON DELETE CASCADE; -- -- Constraints for table `rubric_criteria` -- ALTER TABLE `rubric_criteria` ADD CONSTRAINT `rubric_criteria_rubric_id_foreign` FOREIGN KEY (`rubric_id`) REFERENCES `rubrics` (`id`) ON DELETE CASCADE; -- -- Constraints for table `supervisors` -- ALTER TABLE `supervisors` ADD CONSTRAINT `supervisors_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE; COMMIT; /*!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 */;