-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

