-- https://www.phpmyadmin.net/
--
START TRANSACTION;
;
;
;
;
--
-- Database: `danidslk_jctraka`
--

-- --------------------------------------------------------
--
-- Table structure for table `closed_reports`
--

CREATE TABLE `closed_reports` (
  `id` int(11) NOT NULL,
  `document_id` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `details` text NOT NULL,
  `initial` varchar(10) DEFAULT NULL,
  `instructor_type` varchar(255) DEFAULT NULL,
  `instructor_uid` varchar(255) NOT NULL,
  `points` int(11) DEFAULT 0,
  `service_num` varchar(255) DEFAULT NULL,
  `status` enum('closed') DEFAULT 'closed',
  `student_uid` varchar(255) DEFAULT NULL,
  `surname` varchar(255) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_by` varchar(255) NOT NULL,
  `updated_by` varchar(255) DEFAULT NULL
) ENGINE = MyISAM DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `confirmed_reports`
--

CREATE TABLE `confirmed_reports` (
  `id` int(11) NOT NULL,
  `document_id` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `details` text NOT NULL,
  `initial` varchar(10) DEFAULT NULL,
  `instructor_type` varchar(255) DEFAULT NULL,
  `instructor_uid` varchar(255) NOT NULL,
  `points` int(11) DEFAULT 0,
  `service_num` varchar(255) DEFAULT NULL,
  `status` enum('confirmed') DEFAULT 'confirmed',
  `student_uid` varchar(255) DEFAULT NULL,
  `surname` varchar(255) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_by` varchar(255) NOT NULL,
  `updated_by` varchar(255) DEFAULT NULL
) ENGINE = MyISAM DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `conversations`
--

CREATE TABLE `conversations` (
  `id` int(11) NOT NULL,
  `document_id` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `created_by` varchar(255) NOT NULL,
  `is_group` tinyint(1) DEFAULT 0,
  `members` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`members`)),
  `name` varchar(255) DEFAULT NULL
) ENGINE = MyISAM DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;
--
-- Dumping data for table `conversations`
--

INSERT INTO `conversations` (
    `id`,
    `document_id`,
    `created_at`,
    `created_by`,
    `is_group`,
    `members`,
    `name`
  )
VALUES (
    36,
    '620fee99-c18e-47b4-aef8-97910be88ae2',
    '2024-11-02 00:39:23',
    'NCS44001',
    1,
    '[\"19\", \"21\", \"22\"]',
    'Ubuntu Again'
  ),
  (
    37,
    '81cc3b64-7226-4bed-801e-7b6263cfdf14',
    '2024-11-02 00:43:23',
    'NCS44001',
    1,
    '[\"19\", \"21\", \"22\"]',
    'Ubuntu Now'
  ),
  (
    33,
    '1873bf0a-803e-4f87-9a67-189123be168c',
    '2024-11-01 09:50:52',
    'NCS44001',
    1,
    '[\"19\", \"21\", \"22\"]',
    'Senior Course 13-25'
  ),
  (
    34,
    '3962afbd-5319-47f9-9b12-ff8d09ba1b4b',
    '2024-11-01 09:51:15',
    'NCS44001',
    1,
    '[\"19\", \"21\", \"22\"]',
    'Senior Course 13-25'
  ),
  (
    35,
    '41f39ab1-49cb-451c-b560-e70a9800dde5',
    '2024-11-01 10:44:00',
    'NCS44001',
    1,
    '[\"19\", \"21\", \"22\"]',
    'SC 12 2005 GRP'
  ),
  (
    32,
    '143931d9-437d-43c2-9f71-280f99a87dfe',
    '2024-11-01 09:30:15',
    'NCS44001',
    1,
    '[\"19\", \"21\", \"22\"]',
    'Senior Course 12-25'
  ),
  (
    31,
    '77bd96fa-0aa9-450e-beb5-381dbadc94ca',
    '2024-11-01 09:19:53',
    'NCS44001',
    1,
    '[\"19\", \"\", \"21\", \"22\"]',
    'Senior Course 12-25'
  ),
  (
    26,
    '036ac553-a1a1-426a-aa55-3cde69a0c162',
    '2024-10-31 11:22:56',
    'NCS43212',
    0,
    '[\"11\", \"14\"]',
    'individual'
  ),
  (
    27,
    '893461f5-7685-4a89-b09d-d4e89c2ee997',
    '2024-10-31 11:28:22',
    'NCS00043',
    1,
    '[\"12\", \"11\", \"14\"]',
    'Test Group Chat Video'
  ),
  (
    28,
    '48eb6a8e-e36f-4cf8-abc8-1265f96aec80',
    '2024-10-31 12:30:46',
    'NCS44001',
    1,
    '[\"19\", \"21\", \"22\"]',
    'Ubuntu Course1'
  ),
  (
    29,
    '408fd66f-74bc-4d1e-9918-6bd8e5a5d78b',
    '2024-11-01 08:11:09',
    'NCS44616',
    1,
    '[\"8\", \"21\", \"22\"]',
    'This is Ubuntu'
  ),
  (
    30,
    'c4fe382b-b121-4451-bcda-2570cf5e412b',
    '2024-11-01 08:11:20',
    'NCS44616',
    1,
    '[\"8\", \"21\", \"22\"]',
    'This is Ubuntu'
  ),
  (
    38,
    '00d01e46-3d3a-4b7b-a497-beadc0995e2c',
    '2024-11-02 00:54:48',
    'NCS44001',
    1,
    '[\"19\", \"21\", \"22\"]',
    'New Group'
  ),
  (
    39,
    'e83bda4b-9ed4-4d1d-a490-1658a82732ce',
    '2024-11-02 01:17:36',
    'NCS44001',
    0,
    '[\"19\", \"20\"]',
    'individual'
  ),
  (
    40,
    '2cd71461-9cea-4c61-8679-3e3b9e61cbb7',
    '2024-11-02 01:30:49',
    'NCS44444',
    0,
    '[\"10\", \"\"]',
    'individual'
  ),
  (
    41,
    'f1f8345d-da99-4e6f-841c-1722dcafbd8b',
    '2024-11-02 09:03:18',
    'NCS44001',
    1,
    '[\"19\", \"21\", \"22\"]',
    'New Day'
  ),
  (
    42,
    '757acf12-5efc-4f8c-a58c-5587cf0c7960',
    '2024-11-02 15:20:32',
    'NCS12345',
    0,
    '[\"1\", \"4\"]',
    'individual'
  ),
  (
    43,
    '31b9f013-b8a3-4e7d-90e1-13516041bb50',
    '2024-11-04 16:57:47',
    'NCS41000',
    0,
    '[\"23\", \"19\"]',
    'individual'
  ),
  (
    44,
    '3a389853-7af7-496c-8669-c22e74e64827',
    '2024-11-05 23:03:10',
    'NCS41000',
    1,
    '[\"23\", \"9\", \"17\", \"15\"]',
    'JC 10 2024'
  ),
  (
    45,
    'c0e71a4c-f112-459d-93ee-da1034dbc6b8',
    '2024-11-05 23:03:31',
    'NCS41000',
    1,
    '[\"23\", \"9\", \"17\", \"15\"]',
    'JC 10 2024'
  ),
  (
    46,
    '981732b4-7f0e-4238-a997-385d2c818101',
    '2024-11-05 23:05:29',
    'NCS44001',
    1,
    '[\"19\", \"9\", \"17\", \"15\"]',
    'JC 10 2024'
  ),
  (
    47,
    '231a67ee-d801-438a-9947-f412c683e24b',
    '2024-11-05 23:25:24',
    'NCS44001',
    1,
    '[\"19\", \"22\", \"21\"]',
    'Ubuntu Course 25'
  ),
  (
    48,
    '47eff495-3b37-4ef7-966a-ce8b0590216e',
    '2024-11-05 23:25:25',
    'NCS44001',
    1,
    '[\"19\", \"22\", \"21\"]',
    'Ubuntu Course 25'
  ),
  (
    49,
    'ceb65886-292f-40be-9a7f-0df969d5ad11',
    '2024-11-05 23:50:00',
    'NCS45112',
    0,
    '[\"24\", \"19\"]',
    'Individual Conversation'
  ),
  (
    50,
    '02564276-c07c-4f5d-be76-de497938166c',
    '2024-11-08 07:36:39',
    'NCS41000',
    1,
    '[\"23\", \"7\", \"8\", \"9\", \"10\"]',
    'UbuntuTest'
  ),
  (
    51,
    'df56774a-1e42-4bac-978b-cdb524274d08',
    '2024-11-08 07:40:58',
    'NCS44001',
    1,
    '[\"19\", \"14\"]',
    'Junior Course 2024'
  ),
  (
    52,
    '1193e0b2-0b03-4a50-a894-416aba4ead82',
    '2024-11-08 07:42:32',
    'NCS44001',
    1,
    '[\"19\", \"22\", \"21\"]',
    'Ubuntu Course 25'
  ),
  (
    53,
    '2235d6f5-5013-47a2-a725-458d5352ff89',
    '2024-11-08 07:44:25',
    'NCS44001',
    1,
    '[\"19\", \"9\", \"17\", \"15\"]',
    'JC 10 2024'
  ),
  (
    54,
    '4baa0f1e-a3bd-45d7-8c7f-96e38cbf25ea',
    '2024-11-08 07:53:22',
    'NCS44001',
    1,
    '[\"19\", \"1\", \"4\", \"5\", \"6\", \"7\", \"8\", \"9\", \"10\", \"11\", \"12\"]',
    'New Group Ubuntu'
  ),
  (
    55,
    'bee21629-cb28-4cfb-9dc5-5b35c21ea2b4',
    '2024-11-08 07:59:42',
    'NCS44001',
    0,
    '[\"19\", \"21\"]',
    'Individual Conversation'
  ),
  (
    56,
    '28cd3743-4a3f-4102-810a-0bf366e4f343',
    '2024-11-16 11:28:40',
    'NCS12345',
    0,
    '[\"1\", \"7\"]',
    'Individual Conversation'
  ),
  (
    57,
    'e1d1e385-970b-4d36-86f2-52649d1a2c14',
    '2024-11-16 11:29:14',
    'NCS12345',
    1,
    '[\"1\", \"9\", \"17\", \"15\"]',
    'JC 10 2024'
  ),
  (
    58,
    'bcb928b1-d0ae-43f5-9a3e-d0c213f05e30',
    '2024-11-16 11:49:57',
    'NCS44001',
    1,
    '[\"19\", \"22\", \"21\"]',
    'Ubuntu Course 25'
  ),
  (
    59,
    '3267db7c-99ed-47fd-a2ee-48a35797b1c8',
    '2024-12-02 17:19:17',
    'NCS43212',
    1,
    '[\"11\", \"14\"]',
    'Junior Course 2024'
  ),
  (
    60,
    '62915588-a9a3-4775-ab5b-c8c4707d4826',
    '2024-12-02 17:20:36',
    'NCS43212',
    1,
    '[\"11\", \"22\", \"21\"]',
    'Ubuntu Course 25'
  ),
  (
    61,
    '469c179a-cfd4-4930-b555-93acc2eb7e5d',
    '2024-12-02 18:05:57',
    'NCS44001',
    1,
    '[\"19\", \"22\", \"21\"]',
    'Ubuntu Course 25'
  ),
  (
    62,
    '268293e1-3c45-434f-95e9-6fab3636f45a',
    '2024-12-05 11:30:40',
    'NCS46001',
    1,
    '[\"25\", \"29\", \"34\", \"38\", \"27\", \"32\", \"43\", \"35\", \"41\", \"26\", \"31\", \"30\", \"37\", \"40\", \"44\", \"33\", \"28\", \"45\", \"36\", \"39\", \"42\"]',
    'SC 12 25'
  ),
  (
    63,
    'cdf8d1e9-760e-4118-9e31-21b6f9e0d296',
    '2024-12-05 12:18:42',
    'NCS46022',
    0,
    '[\"46\", \"25\"]',
    'Individual Conversation'
  ),
  (
    64,
    'e1c53b1c-d112-4bf7-9a27-4c65eb1bb8cd',
    '2024-12-07 03:18:03',
    'NCS46001',
    1,
    '[\"25\", \"29\", \"34\", \"38\", \"27\", \"32\", \"43\", \"35\", \"41\", \"26\", \"31\", \"30\", \"37\", \"40\", \"55\", \"44\", \"33\", \"28\", \"45\", \"36\", \"39\", \"42\"]',
    'SC 12 25'
  ),
  (
    65,
    '368e4a0b-6148-4af3-a114-1c99ea144a39',
    '2024-12-07 12:24:07',
    'NCS46026',
    0,
    '[\"50\", \"25\"]',
    'Individual Conversation'
  ),
  (
    66,
    'cfe45e41-c41b-41c8-8cd8-8a7f487c600c',
    '2024-12-07 12:35:40',
    'NCS46022',
    0,
    '[\"46\", \"\"]',
    'Individual Conversation'
  ),
  (
    67,
    'bb3128d7-3dd1-42a9-a4a7-83d984b4346d',
    '2024-12-07 12:43:03',
    'NCS46022',
    0,
    '[\"46\", \"61\"]',
    'Individual Conversation'
  ),
  (
    68,
    'bc26d9d0-7298-4fab-9ccd-bc541a9dadb1',
    '2024-12-14 20:27:01',
    'NCS46024',
    1,
    '[\"48\", \"29\", \"34\", \"38\", \"27\", \"32\", \"43\", \"35\", \"41\", \"60\", \"26\", \"59\", \"31\", \"30\", \"37\", \"40\", \"55\", \"44\", \"33\", \"28\", \"45\", \"36\", \"39\", \"42\"]',
    'SC 12 25'
  );
-- --------------------------------------------------------
--
-- Table structure for table `conversation_members`
--

CREATE TABLE `conversation_members` (
  `conversation_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `added_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE = MyISAM DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;
--
-- Dumping data for table `conversation_members`
--

INSERT INTO `conversation_members` (`conversation_id`, `user_id`, `added_at`)
VALUES (45, 23, '2024-11-05 23:03:31'),
  (48, 19, '2024-11-05 23:25:25'),
  (47, 21, '2024-11-05 23:25:24'),
  (47, 22, '2024-11-05 23:25:24'),
  (47, 19, '2024-11-05 23:25:24'),
  (46, 15, '2024-11-05 23:05:29'),
  (46, 17, '2024-11-05 23:05:29'),
  (46, 9, '2024-11-05 23:05:29'),
  (46, 19, '2024-11-05 23:05:29'),
  (45, 15, '2024-11-05 23:03:31'),
  (45, 17, '2024-11-05 23:03:31'),
  (45, 9, '2024-11-05 23:03:31'),
  (44, 15, '2024-11-05 23:03:10'),
  (44, 17, '2024-11-05 23:03:10'),
  (44, 9, '2024-11-05 23:03:10'),
  (44, 23, '2024-11-05 23:03:10'),
  (43, 19, '2024-11-04 16:57:47'),
  (43, 23, '2024-11-04 16:57:47'),
  (42, 4, '2024-11-02 15:20:32'),
  (42, 1, '2024-11-02 15:20:32'),
  (41, 22, '2024-11-02 09:03:18'),
  (41, 21, '2024-11-02 09:03:18'),
  (41, 19, '2024-11-02 09:03:18'),
  (40, 0, '2024-11-02 01:30:49'),
  (40, 10, '2024-11-02 01:30:49'),
  (39, 20, '2024-11-02 01:17:36'),
  (39, 19, '2024-11-02 01:17:36'),
  (38, 22, '2024-11-02 00:54:48'),
  (38, 21, '2024-11-02 00:54:48'),
  (38, 19, '2024-11-02 00:54:48'),
  (37, 22, '2024-11-02 00:43:23'),
  (37, 21, '2024-11-02 00:43:23'),
  (37, 19, '2024-11-02 00:43:23'),
  (36, 22, '2024-11-02 00:39:23'),
  (36, 21, '2024-11-02 00:39:23'),
  (36, 19, '2024-11-02 00:39:23'),
  (35, 22, '2024-11-01 10:44:00'),
  (35, 21, '2024-11-01 10:44:00'),
  (35, 19, '2024-11-01 10:44:00'),
  (34, 22, '2024-11-01 09:51:15'),
  (34, 21, '2024-11-01 09:51:15'),
  (34, 19, '2024-11-01 09:51:15'),
  (33, 22, '2024-11-01 09:50:52'),
  (33, 21, '2024-11-01 09:50:52'),
  (33, 19, '2024-11-01 09:50:52'),
  (32, 22, '2024-11-01 09:30:15'),
  (32, 21, '2024-11-01 09:30:15'),
  (32, 19, '2024-11-01 09:30:15'),
  (31, 22, '2024-11-01 09:19:53'),
  (31, 21, '2024-11-01 09:19:53'),
  (31, 0, '2024-11-01 09:19:53'),
  (31, 19, '2024-11-01 09:19:53'),
  (30, 22, '2024-11-01 08:11:20'),
  (30, 21, '2024-11-01 08:11:20'),
  (30, 8, '2024-11-01 08:11:20'),
  (29, 22, '2024-11-01 08:11:10'),
  (29, 21, '2024-11-01 08:11:10'),
  (29, 8, '2024-11-01 08:11:10'),
  (28, 22, '2024-10-31 12:30:46'),
  (28, 21, '2024-10-31 12:30:46'),
  (28, 19, '2024-10-31 12:30:46'),
  (27, 14, '2024-10-31 11:28:22'),
  (27, 11, '2024-10-31 11:28:22'),
  (27, 12, '2024-10-31 11:28:22'),
  (26, 14, '2024-10-31 11:22:56'),
  (26, 11, '2024-10-31 11:22:56'),
  (48, 22, '2024-11-05 23:25:25'),
  (48, 21, '2024-11-05 23:25:25'),
  (49, 24, '2024-11-05 23:50:00'),
  (49, 19, '2024-11-05 23:50:00'),
  (50, 23, '2024-11-07 20:36:39'),
  (50, 7, '2024-11-07 20:36:39'),
  (50, 8, '2024-11-07 20:36:39'),
  (50, 9, '2024-11-07 20:36:39'),
  (50, 10, '2024-11-07 20:36:39'),
  (51, 19, '2024-11-07 20:40:58'),
  (51, 14, '2024-11-07 20:40:58'),
  (52, 19, '2024-11-07 20:42:32'),
  (52, 22, '2024-11-07 20:42:32'),
  (52, 21, '2024-11-07 20:42:32'),
  (53, 19, '2024-11-07 20:44:25'),
  (53, 9, '2024-11-07 20:44:25'),
  (53, 17, '2024-11-07 20:44:25'),
  (53, 15, '2024-11-07 20:44:25'),
  (54, 19, '2024-11-07 20:53:22'),
  (54, 1, '2024-11-07 20:53:22'),
  (54, 4, '2024-11-07 20:53:22'),
  (54, 5, '2024-11-07 20:53:22'),
  (54, 6, '2024-11-07 20:53:22'),
  (54, 7, '2024-11-07 20:53:22'),
  (54, 8, '2024-11-07 20:53:22'),
  (54, 9, '2024-11-07 20:53:22'),
  (54, 10, '2024-11-07 20:53:22'),
  (54, 11, '2024-11-07 20:53:22'),
  (54, 12, '2024-11-07 20:53:22'),
  (55, 19, '2024-11-07 20:59:42'),
  (55, 21, '2024-11-07 20:59:42'),
  (56, 1, '2024-11-17 00:28:40'),
  (56, 7, '2024-11-17 00:28:40'),
  (57, 1, '2024-11-17 00:29:14'),
  (57, 9, '2024-11-17 00:29:14'),
  (57, 17, '2024-11-17 00:29:14'),
  (57, 15, '2024-11-17 00:29:14'),
  (58, 19, '2024-11-17 00:49:57'),
  (58, 22, '2024-11-17 00:49:57'),
  (58, 21, '2024-11-17 00:49:57'),
  (59, 11, '2024-12-02 06:19:17'),
  (59, 14, '2024-12-02 06:19:17'),
  (60, 11, '2024-12-02 06:20:36'),
  (60, 22, '2024-12-02 06:20:36'),
  (60, 21, '2024-12-02 06:20:36'),
  (61, 19, '2024-12-02 07:05:57'),
  (61, 22, '2024-12-02 07:05:57'),
  (61, 21, '2024-12-02 07:05:57'),
  (62, 25, '2024-12-06 00:30:40'),
  (62, 29, '2024-12-06 00:30:40'),
  (62, 34, '2024-12-06 00:30:40'),
  (62, 38, '2024-12-06 00:30:40'),
  (62, 27, '2024-12-06 00:30:40'),
  (62, 32, '2024-12-06 00:30:40'),
  (62, 43, '2024-12-06 00:30:40'),
  (62, 35, '2024-12-06 00:30:40'),
  (62, 41, '2024-12-06 00:30:40'),
  (62, 26, '2024-12-06 00:30:40'),
  (62, 31, '2024-12-06 00:30:40'),
  (62, 30, '2024-12-06 00:30:40'),
  (62, 37, '2024-12-06 00:30:40'),
  (62, 40, '2024-12-06 00:30:40'),
  (62, 44, '2024-12-06 00:30:40'),
  (62, 33, '2024-12-06 00:30:40'),
  (62, 28, '2024-12-06 00:30:40'),
  (62, 45, '2024-12-06 00:30:40'),
  (62, 36, '2024-12-06 00:30:40'),
  (62, 39, '2024-12-06 00:30:40'),
  (62, 42, '2024-12-06 00:30:40'),
  (63, 46, '2024-12-06 01:18:42'),
  (63, 25, '2024-12-06 01:18:42'),
  (64, 25, '2024-12-06 16:18:03'),
  (64, 29, '2024-12-06 16:18:03'),
  (64, 34, '2024-12-06 16:18:03'),
  (64, 38, '2024-12-06 16:18:03'),
  (64, 27, '2024-12-06 16:18:03'),
  (64, 32, '2024-12-06 16:18:03'),
  (64, 43, '2024-12-06 16:18:03'),
  (64, 35, '2024-12-06 16:18:03'),
  (64, 41, '2024-12-06 16:18:03'),
  (64, 26, '2024-12-06 16:18:03'),
  (64, 31, '2024-12-06 16:18:03'),
  (64, 30, '2024-12-06 16:18:03'),
  (64, 37, '2024-12-06 16:18:03'),
  (64, 40, '2024-12-06 16:18:03'),
  (64, 55, '2024-12-06 16:18:03'),
  (64, 44, '2024-12-06 16:18:03'),
  (64, 33, '2024-12-06 16:18:03'),
  (64, 28, '2024-12-06 16:18:03'),
  (64, 45, '2024-12-06 16:18:03'),
  (64, 36, '2024-12-06 16:18:03'),
  (64, 39, '2024-12-06 16:18:03'),
  (64, 42, '2024-12-06 16:18:03'),
  (65, 50, '2024-12-08 01:24:07'),
  (65, 25, '2024-12-08 01:24:07'),
  (66, 46, '2024-12-08 01:35:40'),
  (66, 0, '2024-12-08 01:35:41'),
  (67, 46, '2024-12-08 01:43:03'),
  (67, 61, '2024-12-08 01:43:03'),
  (68, 48, '2024-12-14 09:27:01'),
  (68, 29, '2024-12-14 09:27:01'),
  (68, 34, '2024-12-14 09:27:01'),
  (68, 38, '2024-12-14 09:27:01'),
  (68, 27, '2024-12-14 09:27:01'),
  (68, 32, '2024-12-14 09:27:01'),
  (68, 43, '2024-12-14 09:27:01'),
  (68, 35, '2024-12-14 09:27:01'),
  (68, 41, '2024-12-14 09:27:01'),
  (68, 60, '2024-12-14 09:27:01'),
  (68, 26, '2024-12-14 09:27:01'),
  (68, 59, '2024-12-14 09:27:01'),
  (68, 31, '2024-12-14 09:27:01'),
  (68, 30, '2024-12-14 09:27:01'),
  (68, 37, '2024-12-14 09:27:01'),
  (68, 40, '2024-12-14 09:27:01'),
  (68, 55, '2024-12-14 09:27:01'),
  (68, 44, '2024-12-14 09:27:01'),
  (68, 33, '2024-12-14 09:27:01'),
  (68, 28, '2024-12-14 09:27:01'),
  (68, 45, '2024-12-14 09:27:01'),
  (68, 36, '2024-12-14 09:27:01'),
  (68, 39, '2024-12-14 09:27:01'),
  (68, 42, '2024-12-14 09:27:01');
-- --------------------------------------------------------
--
-- Table structure for table `courses`
--

CREATE TABLE `courses` (
  `id` int(11) NOT NULL,
  `document_id` varchar(255) NOT NULL,
  `course_id` varchar(255) NOT NULL,
  `course_title` varchar(255) NOT NULL,
  `course_type` enum('SC', 'JC') NOT NULL,
  `course_year` year(4) NOT NULL,
  `date_posted` timestamp NULL DEFAULT current_timestamp(),
  `description` text DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `is_open` tinyint(1) DEFAULT 1,
  `proposed_fail_grade` int(11) DEFAULT NULL,
  `proposed_pass_grade` int(11) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `students` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`students`)),
  `total_activities` int(11) DEFAULT 0,
  `total_registered_students` int(11) DEFAULT 0,
  `created_by` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `last_updated_by` varchar(255) DEFAULT NULL,
  `activities` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`activities`)),
  `kilometer_walk_total_distance` int(11) DEFAULT 0 COMMENT 'Expected total distance (in km) for students',
  `kilometer_walk_current_distance` int(11) DEFAULT 0 COMMENT 'Current total distance (in km) walked by all students'
) ENGINE = MyISAM DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;
--
-- Dumping data for table `courses`
--

INSERT INTO `courses` (
    `id`,
    `document_id`,
    `course_id`,
    `course_title`,
    `course_type`,
    `course_year`,
    `date_posted`,
    `description`,
    `end_date`,
    `is_open`,
    `proposed_fail_grade`,
    `proposed_pass_grade`,
    `start_date`,
    `students`,
    `total_activities`,
    `total_registered_students`,
    `created_by`,
    `created_at`,
    `updated_at`,
    `last_updated_by`,
    `activities`,
    `kilometer_walk_total_distance`,
    `kilometer_walk_current_distance`
  )
VALUES (
    2,
    '1266b841-531f-4773-accf-752622a8edb5',
    '1266b841-531f-4773-accf-752622a8edb5',
    'Junior Course 2024',
    'JC',
    '2024',
    '2024-10-23 22:40:29',
    NULL,
    NULL,
    1,
    30,
    75,
    NULL,
    NULL,
    1,
    3,
    'NCS12345',
    '2024-10-23 22:40:29',
    '2024-12-19 18:07:18',
    NULL,
    '[\"6\"]',
    300,
    0
  ),
  (
    3,
    '3e9e12db-d5e6-49f8-8dca-e420ad2f4419',
    '3e9e12db-d5e6-49f8-8dca-e420ad2f4419',
    'Senior Course 24',
    'SC',
    '2024',
    '2024-10-23 22:49:48',
    NULL,
    NULL,
    1,
    35,
    80,
    NULL,
    NULL,
    1,
    1,
    'NCS12345',
    '2024-10-23 22:49:48',
    '2024-12-19 18:07:18',
    NULL,
    '[\"6\"]',
    300,
    0
  ),
  (
    4,
    '328ea85e-d54d-449e-b4de-e40f2ef69c40',
    '328ea85e-d54d-449e-b4de-e40f2ef69c40',
    'JC 10 2024',
    'JC',
    '2024',
    '2024-10-26 15:34:36',
    NULL,
    NULL,
    1,
    40,
    100,
    NULL,
    NULL,
    0,
    7,
    'NCS12345',
    '2024-10-26 15:34:36',
    '2024-12-19 18:07:18',
    NULL,
    '[\"6\",\"8\"]',
    300,
    0
  ),
  (
    5,
    '81fb445b-3688-4b1a-bcb3-711c93b78bff',
    '81fb445b-3688-4b1a-bcb3-711c93b78bff',
    'Ubuntu Course 25',
    'SC',
    '2024',
    '2024-10-28 22:04:46',
    NULL,
    NULL,
    0,
    40,
    100,
    NULL,
    NULL,
    0,
    6,
    'NCS12345',
    '2024-10-28 22:04:46',
    '2024-12-19 18:07:18',
    NULL,
    '[\"10\",\"9\",\"6\"]',
    300,
    0
  ),
  (
    7,
    '4e03c169-72e1-4ac3-b58a-a77858322eaa',
    '4e03c169-72e1-4ac3-b58a-a77858322eaa',
    'SC 12 25',
    'SC',
    '2025',
    '2024-12-05 23:10:49',
    NULL,
    NULL,
    0,
    40,
    100,
    NULL,
    NULL,
    0,
    28,
    'NCS12345',
    '2024-12-05 23:10:49',
    '2024-12-19 18:07:18',
    NULL,
    '[\"10\",\"9\",\"11\",\"6\",\"8\"]',
    300,
    0
  ),
  (
    8,
    'dfda830a-5381-4d79-8a63-5113f76ecd0f',
    'dfda830a-5381-4d79-8a63-5113f76ecd0f',
    'JC 21 25',
    'JC',
    '2025',
    '2024-12-06 15:50:06',
    NULL,
    NULL,
    1,
    39,
    100,
    NULL,
    NULL,
    0,
    12,
    'NCS12345',
    '2024-12-06 15:50:06',
    '2024-12-19 18:07:18',
    NULL,
    '[\"9\",\"11\",\"5\",\"6\",\"8\"]',
    300,
    0
  ),
  (
    9,
    '9f1a2e90-4f4b-4e04-aea4-712300786e4f',
    '9f1a2e90-4f4b-4e04-aea4-712300786e4f',
    'SC12/25',
    'SC',
    '2025',
    '2024-12-06 15:53:21',
    NULL,
    NULL,
    1,
    39,
    100,
    NULL,
    NULL,
    0,
    0,
    'NCS12345',
    '2024-12-06 15:53:21',
    '2024-12-19 18:07:18',
    NULL,
    '[\"10\",\"9\",\"11\",\"6\",\"8\"]',
    300,
    0
  ),
  (
    10,
    '45f1fde5-47a1-41aa-99d5-27ff3726a554',
    '45f1fde5-47a1-41aa-99d5-27ff3726a554',
    'SC 13 25',
    'SC',
    '2025',
    '2024-12-16 16:48:21',
    NULL,
    NULL,
    1,
    40,
    75,
    NULL,
    NULL,
    0,
    10,
    'NCS12345',
    '2024-12-16 16:48:21',
    '2024-12-19 18:07:18',
    NULL,
    '[\"11\",\"12\",\"6\",\"8\"]',
    300,
    0
  ),
  (
    11,
    '546b91e9-7168-489e-82ce-21b5f20d44bf',
    '546b91e9-7168-489e-82ce-21b5f20d44bf',
    'SC 22 26',
    'SC',
    '2024',
    '2024-12-20 05:04:03',
    NULL,
    NULL,
    1,
    39,
    100,
    NULL,
    NULL,
    0,
    6,
    'NCS12345',
    '2024-12-20 05:04:03',
    '2024-12-20 05:11:43',
    NULL,
    '[\"10\",\"9\",\"11\",\"12\",\"6\",\"8\"]',
    300,
    0
  );
-- --------------------------------------------------------
--
-- Table structure for table `course_activities`
--

CREATE TABLE `course_activities` (
  `id` int(11) NOT NULL,
  `document_id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `course_type` enum('SC', 'JC', 'both') NOT NULL,
  `date_posted` timestamp NULL DEFAULT current_timestamp(),
  `punishment` int(11) DEFAULT NULL,
  `created_by` varchar(255) NOT NULL,
  `updated_by` varchar(255) DEFAULT NULL
) ENGINE = MyISAM DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;
--
-- Dumping data for table `course_activities`
--

INSERT INTO `course_activities` (
    `id`,
    `document_id`,
    `name`,
    `course_type`,
    `date_posted`,
    `punishment`,
    `created_by`,
    `updated_by`
  )
VALUES (
    5,
    'adb5cb6d-cafa-4e66-b3a1-4a0a462d9a08',
    'Rehearsals',
    'JC',
    '2024-10-23 18:17:27',
    4,
    'NCS12345',
    'NCS12345'
  ),
  (
    6,
    'ea98f0c6-fd71-48c9-a12d-21e8aa7dbcde',
    'Sports',
    'both',
    '2024-10-23 18:35:11',
    3,
    'NCS12345',
    NULL
  ),
  (
    7,
    '3db705b2-0f3d-4d0f-b20d-ae2e529536a9',
    'Mess',
    'JC',
    '2024-10-25 00:16:39',
    3,
    'NCS12345',
    NULL
  ),
  (
    8,
    '2894ed60-4fdb-480d-882a-ed091d399ef7',
    'Syndicate Class',
    'both',
    '2024-10-25 12:25:41',
    4,
    'NCS12345',
    NULL
  ),
  (
    9,
    '32146347-b273-4e7b-a3fd-a6045b3a1660',
    'Mess Activities',
    'both',
    '2024-10-28 20:29:29',
    2,
    'NCS12345',
    NULL
  ),
  (
    10,
    '29e8ec02-170f-41fb-8202-2808d38111db',
    'Kilometer Walk',
    'both',
    '2024-10-28 20:29:55',
    3,
    'NCS12345',
    NULL
  ),
  (
    11,
    '04c2dc46-c1ea-4b5c-bfd2-505b6e0c28f1',
    'Morning Drill',
    'both',
    '2024-10-28 20:30:18',
    3,
    'NCS12345',
    NULL
  ),
  (
    12,
    'cb201e68-c95b-4de4-9f55-50a7c30a1dae',
    'Shining Parade',
    'SC',
    '2024-12-06 16:16:16',
    4,
    'NCS12345',
    NULL
  );
-- --------------------------------------------------------
--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` int(11) NOT NULL,
  `conversation_id` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `content` text NOT NULL,
  `sent_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `is_read` tinyint(1) DEFAULT 0,
  `acknowledged_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`acknowledged_list`))
) ENGINE = MyISAM DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;
--
-- Dumping data for table `messages`
--

INSERT INTO `messages` (
    `id`,
    `conversation_id`,
    `sender_id`,
    `content`,
    `sent_at`,
    `is_read`,
    `acknowledged_list`
  )
VALUES (
    17,
    28,
    19,
    'Hello all',
    '2024-10-31 13:52:42',
    0,
    NULL
  ),
  (
    16,
    27,
    11,
    'Kindly stay patient',
    '2024-10-31 11:29:33',
    0,
    NULL
  ),
  (
    15,
    27,
    12,
    'Where are all the students?',
    '2024-10-31 11:28:57',
    0,
    NULL
  ),
  (
    14,
    26,
    11,
    'Where exactly the code dey hosted?',
    '2024-10-31 11:26:34',
    0,
    NULL
  ),
  (
    13,
    26,
    14,
    'I dey',
    '2024-10-31 11:26:08',
    0,
    NULL
  ),
  (
    12,
    26,
    11,
    'how far?',
    '2024-10-31 11:25:04',
    0,
    NULL
  ),
  (
    18,
    27,
    12,
    'What\'s happening at the Mess?',
    '2024-10-31 16:56:53',
    0,
    '[\"14\"]'
  ),
  (
    19,
    27,
    12,
    'Kindly respond',
    '2024-10-31 16:59:06',
    0,
    NULL
  ),
  (
    20,
    27,
    11,
    'No nothing is happening, everything is calm.',
    '2024-10-31 16:59:34',
    0,
    '[\"14\"]'
  ),
  (
    21,
    29,
    8,
    'Hi Chiefs of Ubuntu',
    '2024-11-01 08:12:37',
    0,
    NULL
  ),
  (
    22,
    31,
    19,
    'Errr',
    '2024-11-01 09:30:32',
    0,
    NULL
  ),
  (
    23,
    32,
    19,
    'Hello world',
    '2024-11-01 09:38:01',
    0,
    NULL
  ),
  (
    24,
    34,
    19,
    'Report to John Enoh Hall by 2359 hrs',
    '2024-11-01 09:52:18',
    0,
    '[\"21\"]'
  ),
  (
    25,
    27,
    12,
    'You all should come to the Mess by 12pm',
    '2024-11-01 13:58:06',
    0,
    '[\"14\"]'
  ),
  (
    26,
    27,
    11,
    'All students report to the mess',
    '2024-11-01 14:26:58',
    0,
    '[\"14\"]'
  ),
  (
    27,
    27,
    12,
    'Hello World',
    '2024-11-01 15:27:36',
    0,
    NULL
  ),
  (
    28,
    27,
    12,
    'Can you see this?',
    '2024-11-01 15:29:08',
    0,
    NULL
  ),
  (
    29,
    26,
    11,
    'Hello Mohammed',
    '2024-11-01 15:54:10',
    0,
    NULL
  ),
  (
    30,
    26,
    14,
    'Good day Sir',
    '2024-11-01 15:54:41',
    0,
    NULL
  ),
  (
    31,
    26,
    11,
    'You need to report to the mess ASAP',
    '2024-11-01 16:05:44',
    0,
    NULL
  ),
  (
    32,
    27,
    12,
    'Mic Test 1 and 2',
    '2024-11-01 19:25:42',
    0,
    NULL
  ),
  (
    33,
    27,
    12,
    'Are you there, are you active?',
    '2024-11-01 19:26:03',
    0,
    '[\"14\"]'
  ),
  (
    34,
    27,
    11,
    'Can you all see this?',
    '2024-11-01 19:27:10',
    0,
    NULL
  ),
  (35, 27, 11, '?', '2024-11-01 19:28:02', 0, NULL),
  (
    36,
    27,
    11,
    'Hello',
    '2024-11-01 19:29:02',
    0,
    NULL
  ),
  (
    37,
    27,
    12,
    'Good day',
    '2024-11-01 20:37:42',
    0,
    NULL
  ),
  (
    38,
    27,
    11,
    'How are you doing.',
    '2024-11-01 20:37:59',
    0,
    NULL
  ),
  (
    39,
    27,
    12,
    'I am fine Sir',
    '2024-11-01 20:38:41',
    0,
    NULL
  ),
  (
    40,
    27,
    11,
    'That\'s great',
    '2024-11-01 20:41:07',
    0,
    '[\"14\"]'
  ),
  (
    41,
    26,
    14,
    'Mr. Effiong',
    '2024-11-01 21:13:00',
    0,
    NULL
  ),
  (
    42,
    27,
    11,
    'Hello everyone',
    '2024-11-02 07:25:54',
    0,
    NULL
  ),
  (
    43,
    27,
    12,
    'What\'s happening?',
    '2024-11-02 07:26:08',
    0,
    NULL
  ),
  (
    44,
    27,
    12,
    'Mohammed come to the Mess by 9am',
    '2024-11-02 07:27:08',
    0,
    NULL
  ),
  (
    45,
    27,
    11,
    'This is a video test for this morning ',
    '2024-11-02 07:29:52',
    0,
    '[\"14\"]'
  ),
  (
    46,
    27,
    12,
    'What\'s the meeting time this afternoon?',
    '2024-11-02 07:31:20',
    0,
    NULL
  ),
  (
    47,
    27,
    11,
    '15:00',
    '2024-11-02 07:31:39',
    0,
    '[\"14\"]'
  ),
  (
    48,
    41,
    19,
    'Hello all',
    '2024-11-02 09:03:44',
    0,
    '[\"21\"]'
  ),
  (
    49,
    37,
    19,
    'Report to Ahmed Makarfi Hall',
    '2024-11-02 09:20:25',
    0,
    NULL
  ),
  (
    50,
    37,
    19,
    'Ahmed Makarfi Hall',
    '2024-11-02 09:23:25',
    0,
    NULL
  ),
  (
    51,
    43,
    23,
    'Hello good morning',
    '2024-11-04 16:58:38',
    0,
    NULL
  ),
  (
    52,
    43,
    19,
    'Good morning Sir',
    '2024-11-04 16:59:51',
    0,
    NULL
  ),
  (
    53,
    43,
    19,
    'Am just seeing your message',
    '2024-11-04 22:17:43',
    0,
    NULL
  ),
  (
    54,
    43,
    23,
    'Ok Pse give me a reason why the Report on NCS55112 was not acknowlwdged',
    '2024-11-04 22:20:14',
    0,
    NULL
  ),
  (
    55,
    43,
    19,
    'Sorry I didn\'t get the notification on time',
    '2024-11-05 15:27:50',
    0,
    NULL
  ),
  (
    56,
    43,
    19,
    'I will work on the above observation explicitly ',
    '2024-11-05 22:59:51',
    0,
    NULL
  ),
  (
    57,
    43,
    23,
    'OK that\'s nice',
    '2024-11-05 23:01:20',
    0,
    NULL
  ),
  (
    58,
    44,
    23,
    'Hello all',
    '2024-11-05 23:04:18',
    0,
    NULL
  ),
  (
    59,
    44,
    23,
    'Hello',
    '2024-11-05 23:12:32',
    0,
    NULL
  ),
  (
    60,
    46,
    19,
    'Hello all',
    '2024-11-05 23:22:26',
    0,
    NULL
  ),
  (
    61,
    48,
    19,
    'Hello all members of Ubuntu Course',
    '2024-11-05 23:26:24',
    0,
    '[\"21\"]'
  ),
  (
    62,
    49,
    24,
    'Hello Sir the student is on admission.',
    '2024-11-05 23:50:46',
    0,
    NULL
  ),
  (
    63,
    49,
    19,
    'It\'s Ok',
    '2024-11-05 23:51:24',
    0,
    NULL
  ),
  (
    64,
    44,
    23,
    'Good morning all',
    '2024-11-06 11:36:53',
    0,
    NULL
  ),
  (
    65,
    46,
    19,
    'Good morning Students. The time for the rehearsal has been rescheduled to 1030hrs today Thur 7 Dec 22',
    '2024-11-06 17:03:11',
    0,
    '[\"9\"]'
  ),
  (
    66,
    48,
    19,
    'Good morning Students. The time for the rehearsal has been rescheduled to 1030hrs today Thur 7 Dec 22',
    '2024-11-06 17:03:39',
    0,
    NULL
  ),
  (
    67,
    43,
    19,
    'Good morning Students. The time for the rehearsal has been rescheduled to 1030hrs today Thur 7 Dec 22',
    '2024-11-06 17:20:41',
    0,
    NULL
  ),
  (
    68,
    43,
    19,
    'Evening Sir, I have the list of students for this course.',
    '2024-11-07 19:36:43',
    0,
    NULL
  ),
  (
    69,
    50,
    23,
    'Hi all.',
    '2024-11-07 20:38:01',
    0,
    NULL
  ),
  (
    70,
    53,
    19,
    'Hello',
    '2024-11-07 20:44:40',
    0,
    NULL
  ),
  (
    71,
    54,
    19,
    'Hello all',
    '2024-11-07 20:54:23',
    0,
    NULL
  ),
  (
    72,
    55,
    19,
    'Hello ',
    '2024-11-07 21:01:17',
    0,
    NULL
  ),
  (
    73,
    54,
    19,
    'You there?',
    '2024-11-07 22:01:53',
    0,
    NULL
  ),
  (
    74,
    54,
    19,
    'World',
    '2024-11-07 22:02:56',
    0,
    NULL
  ),
  (75, 54, 19, 'Yo', '2024-11-07 22:03:41', 0, NULL),
  (
    76,
    53,
    19,
    'World',
    '2024-11-07 22:04:18',
    0,
    NULL
  ),
  (
    77,
    53,
    19,
    'Hi everyone',
    '2024-11-07 22:08:28',
    0,
    '[\"9\"]'
  ),
  (
    78,
    54,
    19,
    'Everyone here?',
    '2024-11-07 22:09:06',
    0,
    NULL
  ),
  (
    79,
    54,
    19,
    'Anyone here?',
    '2024-11-07 22:10:14',
    0,
    NULL
  ),
  (
    80,
    43,
    19,
    'Hello',
    '2024-11-08 20:37:24',
    0,
    NULL
  ),
  (81, 43, 23, 'Hi', '2024-11-08 20:39:54', 0, NULL),
  (
    82,
    57,
    1,
    'Good day all',
    '2024-11-17 00:29:35',
    0,
    NULL
  ),
  (
    83,
    58,
    19,
    'Hello all',
    '2024-11-17 00:50:49',
    0,
    NULL
  ),
  (
    84,
    58,
    19,
    'Hello all pse let\'s meet at parade ground by 1800 hrs',
    '2024-11-30 16:55:53',
    0,
    NULL
  ),
  (
    85,
    59,
    11,
    'Hello world',
    '2024-12-02 06:19:50',
    0,
    NULL
  ),
  (
    86,
    60,
    11,
    'Hello World ',
    '2024-12-02 06:20:58',
    0,
    NULL
  ),
  (
    87,
    62,
    25,
    'Hello Students Welcome to Senior Course Pse be available on the parade ground by 1000 hrs',
    '2024-12-06 00:31:50',
    0,
    '[\"29\", \"31\", \"35\", \"39\", \"42\", \"26\", \"44\", \"37\"]'
  ),
  (
    88,
    63,
    25,
    'Hi Doctor',
    '2024-12-06 01:21:34',
    0,
    NULL
  ),
  (
    89,
    63,
    46,
    'Hello',
    '2024-12-06 13:35:31',
    0,
    NULL
  ),
  (
    90,
    64,
    25,
    'All Students are to report to the parade ground by 23.59 hrs',
    '2024-12-06 16:19:29',
    0,
    '[\"27\", \"28\", \"29\", \"30\", \"31\", \"32\"]'
  ),
  (
    91,
    64,
    25,
    'Students are to come for rehearsals by 1700 hrs',
    '2024-12-06 16:45:03',
    0,
    NULL
  ),
  (
    92,
    65,
    50,
    'Good evening',
    '2024-12-08 01:26:10',
    0,
    NULL
  ),
  (
    93,
    65,
    25,
    'Hi evening',
    '2024-12-08 01:28:05',
    0,
    NULL
  ),
  (
    94,
    63,
    46,
    'How are you.',
    '2024-12-08 01:34:16',
    0,
    NULL
  ),
  (
    95,
    67,
    46,
    'Hello',
    '2024-12-08 01:43:13',
    0,
    NULL
  ),
  (96, 67, 61, 'Hi', '2024-12-08 01:44:16', 0, NULL),
  (
    97,
    64,
    25,
    'You are to come for rehearsals',
    '2024-12-14 09:23:30',
    0,
    '[\"36\"]'
  );
-- --------------------------------------------------------
--
-- Table structure for table `officer_rank`
--

CREATE TABLE `officer_rank` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `abbreviation` varchar(10) NOT NULL,
  `officer_type` enum('senior', 'junior') NOT NULL
) ENGINE = MyISAM DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;
--
-- Dumping data for table `officer_rank`
--

INSERT INTO `officer_rank` (`id`, `name`, `abbreviation`, `officer_type`)
VALUES (
    4,
    'Assistant Superintendent of Customs Grade II',
    'ASC II',
    'senior'
  ),
  (
    6,
    'Deputy Superintendent of  Customs',
    'DSC',
    'senior'
  ),
  (
    7,
    'Assistant Comptroller of Customs',
    'CSC',
    'senior'
  ),
  (
    8,
    'Assistant Comptroller of Customs',
    'AC',
    'senior'
  ),
  (
    9,
    'Deputy Comptroller of Customs',
    'DC',
    'senior'
  ),
  (10, 'Comptroller of Customs', 'CC', 'senior'),
  (
    11,
    'Assistant Comptroller-General',
    'ACG',
    'senior'
  ),
  (
    12,
    'Deputy Comptroller-General',
    'DCG',
    'senior'
  ),
  (
    13,
    'Comptroller General of Customs',
    'CGC',
    'senior'
  ),
  (14, 'Customs Assistant II', 'CAII', 'junior'),
  (15, 'Customs Assistant I', 'CAI', 'junior'),
  (16, 'Inspector of Customs', 'IC', 'junior'),
  (
    17,
    'Assistant Inspector of Customs',
    'AIC',
    'junior'
  ),
  (18, 'Customs Assistant III', 'CA III', 'junior'),
  (
    19,
    'Assistant Superintendent of Customs I',
    'ASC I',
    'senior'
  ),
  (20, 'Superintendent of Customs', 'SC', 'senior'),
  (21, 'Lance Corporal', 'LCPL', 'junior'),
  (22, 'Corporal', 'CPL', 'junior');
-- --------------------------------------------------------
--
-- Table structure for table `reports`
--

CREATE TABLE `reports` (
  `id` int(11) NOT NULL,
  `document_id` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `details` text NOT NULL,
  `initial` varchar(10) DEFAULT NULL,
  `instructor_type` varchar(255) DEFAULT NULL,
  `instructor_uid` varchar(255) NOT NULL,
  `points` int(11) DEFAULT 0,
  `service_num` varchar(255) DEFAULT NULL,
  `status` enum('open', 'closed', 'appealed', 'confirmed') DEFAULT 'open',
  `appeal_message` text DEFAULT NULL,
  `student_uid` varchar(255) DEFAULT NULL,
  `surname` varchar(255) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_by` varchar(255) NOT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `course_id` int(11) NOT NULL,
  `appealed` tinyint(1) NOT NULL DEFAULT 0
) ENGINE = MyISAM DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;
--
-- Dumping data for table `reports`
--

INSERT INTO `reports` (
    `id`,
    `document_id`,
    `created_at`,
    `details`,
    `initial`,
    `instructor_type`,
    `instructor_uid`,
    `points`,
    `service_num`,
    `status`,
    `appeal_message`,
    `student_uid`,
    `surname`,
    `type`,
    `updated_at`,
    `created_by`,
    `updated_by`,
    `course_id`,
    `appealed`
  )
VALUES (
    1,
    '914f5aa2-52da-45f1-a510-1a18ef9da359',
    '2024-10-27 06:39:56',
    'Report to the Parade Ground by 2300 hrs',
    NULL,
    NULL,
    '8',
    0,
    NULL,
    'closed',
    NULL,
    NULL,
    NULL,
    'Blanket Report',
    '2024-10-26 22:39:56',
    'NCS44616',
    NULL,
    0,
    0
  ),
  (
    2,
    'e7e50864-01d6-4f6f-8c15-e4c2f178f5bd',
    '2024-10-27 07:25:27',
    'Punishment for missing class',
    NULL,
    NULL,
    '8',
    5,
    NULL,
    'closed',
    NULL,
    NULL,
    NULL,
    'Blanket Report',
    '2024-10-26 23:25:27',
    'NCS44616',
    NULL,
    0,
    0
  ),
  (
    3,
    'aaa75641-cb46-48cf-afab-ddda3081bad3',
    '2024-10-27 13:55:33',
    'Non compliance with Rehearsals',
    NULL,
    NULL,
    '8',
    8,
    NULL,
    'closed',
    NULL,
    NULL,
    NULL,
    'Blanket Report',
    '2024-10-27 05:55:33',
    'NCS44616',
    NULL,
    0,
    0
  ),
  (
    4,
    'e5efba24-be43-430a-996f-03421019a8a3',
    '2024-10-28 18:05:54',
    'Late to rehearsals',
    NULL,
    'both',
    'c298da11-1178-4ae1-8f8b-3ff29e014e0b',
    4,
    'NCS48391',
    'closed',
    'Please forgive us, we are sorry.!!!',
    'NCS48391',
    'CC MR BEANS',
    'Rehearsals',
    '2024-10-28 18:07:53',
    'NCS00043',
    'NCS43212',
    4,
    1
  ),
  (
    5,
    'ca63880b-14e8-4d3c-9ecf-e0e893aa7312',
    '2024-10-28 18:08:38',
    'Does not attend sporting activity.',
    NULL,
    'both',
    'c298da11-1178-4ae1-8f8b-3ff29e014e0b',
    3,
    'NCS48391',
    'closed',
    NULL,
    'NCS48391',
    'CC MR BEANS',
    'Sports',
    '2024-10-28 18:08:47',
    'NCS00043',
    'NCS43212',
    4,
    0
  ),
  (
    6,
    'ad060f59-ba22-4fe0-945e-e227709a433e',
    '2024-10-28 18:09:17',
    'Not maintaining neatness',
    NULL,
    'both',
    'c298da11-1178-4ae1-8f8b-3ff29e014e0b',
    4,
    'NCS48391',
    'closed',
    'Don\'t forgive us, we are not sorry.!!!',
    'NCS48391',
    'CC MR BEANS',
    'Syndicate Class',
    '2024-10-28 18:11:13',
    'NCS00043',
    'NCS43212',
    4,
    1
  ),
  (
    7,
    '8ab64881-dd92-42f4-8454-35c7e324af16',
    '2024-10-28 22:21:31',
    'He didn\'t come out for sports',
    NULL,
    'both',
    '0a37a350-ad05-4ba7-92b1-a6199896db2e',
    3,
    'NCS44003',
    'confirmed',
    NULL,
    'NCS44003',
    'CSC MM Abubakar',
    'Sports',
    '2024-10-28 22:22:32',
    'NCS44002',
    'NCS44001',
    5,
    0
  ),
  (
    8,
    '16e8eef7-e17a-48ce-9efb-095a6035f39e',
    '2024-10-28 22:25:08',
    'He left the Parade ground late',
    NULL,
    'both',
    '0a37a350-ad05-4ba7-92b1-a6199896db2e',
    3,
    'NCS44003',
    'confirmed',
    NULL,
    'NCS44003',
    'CSC MM Abubakar',
    'Sports',
    '2024-11-16 09:15:34',
    'NCS44002',
    'NCS44001',
    5,
    0
  ),
  (
    9,
    '5421dfaa-53fc-46c2-bd91-69b541a5b479',
    '2024-10-28 22:25:26',
    'He ran',
    NULL,
    'both',
    '0a37a350-ad05-4ba7-92b1-a6199896db2e',
    3,
    'NCS44003',
    'closed',
    NULL,
    'NCS44003',
    'CSC MM Abubakar',
    'Sports',
    '2024-11-16 09:15:27',
    'NCS44002',
    'NCS44001',
    5,
    0
  ),
  (
    10,
    'b8d00d8f-0b4b-415b-8ccf-7c2adbb3c3c0',
    '2024-10-28 22:25:44',
    'He ran',
    NULL,
    'both',
    '0a37a350-ad05-4ba7-92b1-a6199896db2e',
    3,
    'NCS44003',
    'confirmed',
    NULL,
    'NCS44003',
    'CSC MM Abubakar',
    'Kilometer Walk',
    '2024-10-31 17:34:39',
    'NCS44002',
    'NCS44001',
    5,
    0
  ),
  (
    11,
    '71103bb9-dca0-4cbb-aea4-4ba84ed9f7d2',
    '2024-10-28 22:26:50',
    'He didn\'t show',
    NULL,
    'both',
    '0a37a350-ad05-4ba7-92b1-a6199896db2e',
    3,
    'NCS44003',
    'confirmed',
    NULL,
    'NCS44003',
    'CSC MM Abubakar',
    'Mess',
    '2024-10-28 22:31:49',
    'NCS44002',
    'NCS44001',
    5,
    0
  ),
  (
    12,
    '6b092fc3-7c8a-4410-8484-d29255c21dd1',
    '2024-10-28 22:30:52',
    'He didn\'t show up',
    NULL,
    'both',
    '0a37a350-ad05-4ba7-92b1-a6199896db2e',
    3,
    'NCS44004',
    'confirmed',
    NULL,
    'NCS44004',
    'CSC ET Egbelonu',
    'Morning Drill',
    '2024-10-28 22:31:37',
    'NCS44002',
    'NCS44001',
    5,
    0
  ),
  (
    13,
    '7d9e3d42-5421-4a90-b440-6a3298c16333',
    '2024-10-29 06:33:17',
    'Ubuntu',
    NULL,
    NULL,
    '19',
    20,
    NULL,
    'closed',
    NULL,
    NULL,
    NULL,
    'Blanket Report',
    '2024-10-28 22:33:17',
    'NCS44001',
    NULL,
    5,
    0
  ),
  (
    14,
    '60061a72-f470-4792-bc94-c97b0d7854b7',
    '2024-10-29 06:34:55',
    'Ubuntu',
    NULL,
    NULL,
    '19',
    30,
    NULL,
    'closed',
    NULL,
    NULL,
    NULL,
    'Blanket Report',
    '2024-10-28 22:34:55',
    'NCS44001',
    NULL,
    5,
    0
  ),
  (
    15,
    'd4446bdd-9282-4693-a7a0-a688273b52d0',
    '2024-10-29 06:35:21',
    'Ubuntu',
    NULL,
    NULL,
    '19',
    16,
    NULL,
    'closed',
    NULL,
    NULL,
    NULL,
    'Blanket Report',
    '2024-10-28 22:35:21',
    'NCS44001',
    NULL,
    5,
    0
  ),
  (
    16,
    '969b1de4-7e98-42f1-94cf-4758a3129d99',
    '2024-10-31 19:31:13',
    'No details lol',
    NULL,
    NULL,
    '11',
    3,
    NULL,
    'closed',
    NULL,
    NULL,
    NULL,
    'Blanket Report',
    '2024-10-31 11:31:13',
    'NCS43212',
    NULL,
    4,
    0
  ),
  (
    17,
    'c901e20f-1f2f-441d-8fe1-05df1e15ed23',
    '2024-10-31 17:30:35',
    'He didn\'t go for drill',
    NULL,
    'both',
    '0a37a350-ad05-4ba7-92b1-a6199896db2e',
    3,
    'NCS93812',
    'open',
    NULL,
    'NCS93812',
    'AIC AK Mohammed',
    'Morning Drill',
    '2024-10-31 17:30:35',
    'NCS44002',
    NULL,
    2,
    0
  ),
  (
    18,
    '79d47c82-e631-48cb-ba34-97a1248b0173',
    '2024-10-31 17:38:34',
    'Mess',
    NULL,
    'both',
    '0a37a350-ad05-4ba7-92b1-a6199896db2e',
    2,
    'NCS44004',
    'confirmed',
    NULL,
    'NCS44004',
    'CSC ET Egbelonu',
    'Mess Activities',
    '2024-11-16 09:12:14',
    'NCS44002',
    'NCS44001',
    5,
    0
  ),
  (
    19,
    '78b95aa0-ca4d-4bb8-9a93-9222d8796a02',
    '2024-11-06 13:21:37',
    'The student with SVC NO: 55321 TO Taaefook arrived at the Syndicate Class 5 minutes late.',
    NULL,
    'both',
    'c298da11-1178-4ae1-8f8b-3ff29e014e0b',
    3,
    'NCS44566',
    'closed',
    'I would like to appeal the report regarding my late arrival to Syndicate Class. I was delayed due to a medical emergency that required immediate attention, which prevented me from arriving on time. I understand the importance of punctuality, but my health condition was a priority at that moment. I kindly request that this be taken into consideration when reviewing the report.',
    'NCS44566',
    'CSC ED Okpon',
    'Kilometer Walk',
    '2024-11-06 13:57:11',
    'NCS00043',
    'NCS43212',
    4,
    1
  ),
  (
    20,
    '91eb004d-ac9b-406f-8576-331dafe6d3cf',
    '2024-11-16 19:12:46',
    'Punish',
    NULL,
    NULL,
    '19',
    8,
    NULL,
    'closed',
    NULL,
    NULL,
    NULL,
    'Blanket Report',
    '2024-11-16 09:12:46',
    'NCS44001',
    NULL,
    5,
    0
  ),
  (
    21,
    'ff06d0dc-59b8-48b0-ad50-faae3be4d700',
    '2024-12-06 01:07:54',
    'He wasn\'t present for morning drill',
    NULL,
    'both',
    'e7216179-fc8b-476d-96c0-cf3f3702b442',
    3,
    'NCS46005',
    'open',
    NULL,
    'NCS46005',
    'CSC AA Adeoye',
    'Morning Drill',
    '2024-12-06 01:07:54',
    'NCS46023',
    NULL,
    7,
    0
  ),
  (
    22,
    '76f02a57-795a-4761-8898-e7459c1b6376',
    '2024-12-06 01:08:35',
    'He didn\'t show up for drill',
    NULL,
    'both',
    'e7216179-fc8b-476d-96c0-cf3f3702b442',
    3,
    'NCS46007',
    'closed',
    'I wasnt late for the early morning drill',
    'NCS46007',
    'CSC FA Abba',
    'Morning Drill',
    '2024-12-06 01:32:32',
    'NCS46023',
    'NCS46001',
    7,
    1
  ),
  (
    23,
    'f5f916d2-1db7-439e-a853-c1e677b4a8de',
    '2024-12-06 01:11:44',
    'He didn\'t go to class',
    NULL,
    'both',
    '6228d8ad-a012-429c-a85a-882c4a5d7b84',
    4,
    'NCS46008',
    'confirmed',
    NULL,
    'NCS46008',
    'CSC AR Monye',
    'Syndicate Class',
    '2024-12-06 01:29:57',
    'NCS46025',
    'NCS46001',
    7,
    0
  ),
  (
    24,
    'fc05ade1-8b52-4ab4-a17d-f22bd623b043',
    '2024-12-06 11:31:28',
    'He didn’t show up',
    NULL,
    'both',
    'e7216179-fc8b-476d-96c0-cf3f3702b442',
    3,
    'NCS46010',
    'closed',
    'I actually reported for morning drill on time',
    'NCS46010',
    'CSC AE Ezeh',
    'Morning Drill',
    '2024-12-06 11:35:07',
    'NCS46023',
    'NCS46001',
    7,
    1
  ),
  (
    25,
    '6a93e34d-ea41-4d9d-b79b-baf9e7294674',
    '2024-12-06 11:45:20',
    'He didn\'t come to morning drill',
    NULL,
    'both',
    'e7216179-fc8b-476d-96c0-cf3f3702b442',
    3,
    'NCS46010',
    'confirmed',
    NULL,
    'NCS46010',
    'CSC AE Ezeh',
    'Morning Drill',
    '2024-12-06 11:46:42',
    'NCS46023',
    'NCS46001',
    7,
    0
  ),
  (
    26,
    '106bdf73-60db-47ee-83e3-c733802a49fd',
    '2024-12-06 13:45:17',
    'Not serious, does not attend mess activities.',
    NULL,
    'both',
    'c298da11-1178-4ae1-8f8b-3ff29e014e0b',
    3,
    'NCS44566',
    'open',
    NULL,
    'NCS44566',
    'CSC ED Okpon',
    'Mess',
    '2024-12-06 13:45:17',
    'NCS00043',
    NULL,
    4,
    0
  ),
  (
    27,
    '728a9b3d-5da3-4bb8-b25f-eb9736e2701b',
    '2024-12-06 14:20:33',
    'He left the mess early.',
    NULL,
    'both',
    'e7216179-fc8b-476d-96c0-cf3f3702b442',
    2,
    'NCS46005',
    'closed',
    'Yes I actually came to the mess early',
    'NCS46005',
    'CSC AA Adeoye',
    'Mess Activities',
    '2024-12-06 14:25:05',
    'NCS46023',
    'NCS46001',
    7,
    1
  ),
  (
    28,
    'bb147124-a00f-49e4-a9d8-87acb369d35c',
    '2024-12-06 16:02:23',
    'He didn\'t come for the morning drill',
    NULL,
    'both',
    '6228d8ad-a012-429c-a85a-882c4a5d7b84',
    3,
    'NCS46012',
    'open',
    NULL,
    'NCS46012',
    'CSC Z Iboromah',
    'Morning Drill',
    '2024-12-06 16:02:23',
    'NCS46025',
    NULL,
    7,
    0
  ),
  (
    29,
    '85479c68-382b-4e69-ae7f-5299917e7f10',
    '2024-12-06 16:02:57',
    'He came late',
    NULL,
    'both',
    '6228d8ad-a012-429c-a85a-882c4a5d7b84',
    4,
    'NCS46010',
    'open',
    NULL,
    'NCS46010',
    'CSC AE Ezeh',
    'Rehearsals',
    '2024-12-06 16:02:57',
    'NCS46025',
    NULL,
    7,
    0
  ),
  (
    30,
    '439fb436-29e9-49a5-b6cd-766eb0df0a59',
    '2024-12-06 16:04:15',
    'He didn\'t go for kilometer walk on the 7 Dec 24',
    NULL,
    'both',
    '6228d8ad-a012-429c-a85a-882c4a5d7b84',
    3,
    'NCS46006',
    'closed',
    'I acually came for kilometer walk but had an accident and was hospitalized',
    'NCS46006',
    'CSC JZ Mani',
    'Kilometer Walk',
    '2024-12-06 16:09:27',
    'NCS46025',
    'NCS46001',
    7,
    1
  ),
  (
    31,
    'fb2e153b-a987-4364-a422-58317cd648ac',
    '2024-12-07 21:52:23',
    'He didn’t come to Class.',
    NULL,
    'both',
    '6228d8ad-a012-429c-a85a-882c4a5d7b84',
    4,
    'NCS46005',
    'confirmed',
    NULL,
    'NCS46005',
    'CSC AA Adeoye',
    'Syndicate Class',
    '2024-12-08 01:20:02',
    'NCS46025',
    'NCS46001',
    7,
    0
  ),
  (
    32,
    '0981e360-bdc6-408e-ba75-104f666d58c5',
    '2024-12-09 19:14:45',
    'He is on drill',
    NULL,
    'both',
    'e7216179-fc8b-476d-96c0-cf3f3702b442',
    3,
    'NCS48391',
    'open',
    NULL,
    'NCS48391',
    'CC MR BEANS',
    'Morning Drill',
    '2024-12-09 19:14:45',
    'NCS46023',
    NULL,
    4,
    0
  ),
  (
    33,
    'b7b476b7-d73b-4f5a-a75a-45824a5a9150',
    '2024-12-10 18:41:30',
    'He',
    NULL,
    'both',
    'e7216179-fc8b-476d-96c0-cf3f3702b442',
    4,
    'NCS44520',
    'open',
    NULL,
    'NCS44520',
    'CSC I AKANO',
    'Rehearsals',
    '2024-12-10 18:41:30',
    'NCS46023',
    NULL,
    8,
    0
  ),
  (
    34,
    'a126ec7f-a949-4514-af7e-2ef0bc91860a',
    '2024-12-11 00:32:45',
    'He ran',
    NULL,
    'both',
    'e7216179-fc8b-476d-96c0-cf3f3702b442',
    2,
    'NCS44488',
    'open',
    NULL,
    'NCS44488',
    'AC ER Okoi',
    'Mess Activities',
    '2024-12-11 00:32:45',
    'NCS46023',
    NULL,
    4,
    0
  ),
  (
    35,
    'b7dd98c6-0a9e-4cf9-a435-1d497ae66075',
    '2024-12-11 00:33:17',
    'How',
    NULL,
    'both',
    'e7216179-fc8b-476d-96c0-cf3f3702b442',
    3,
    'NCS44520',
    'open',
    NULL,
    'NCS44520',
    'CSC I AKANO',
    'Morning Drill',
    '2024-12-11 00:33:17',
    'NCS46023',
    NULL,
    8,
    0
  ),
  (
    36,
    '032b879a-5a03-4051-98b9-ca800c4e98e2',
    '2024-12-11 00:33:38',
    'He did ',
    NULL,
    'both',
    'e7216179-fc8b-476d-96c0-cf3f3702b442',
    2,
    'NCS44520',
    'open',
    NULL,
    'NCS44520',
    'CSC I AKANO',
    'Mess Activities',
    '2024-12-11 00:33:38',
    'NCS46023',
    NULL,
    8,
    0
  ),
  (
    37,
    '364f32cf-04ce-4230-b102-ebd38c9bf37f',
    '2024-12-11 00:33:56',
    'Ge',
    NULL,
    'both',
    'e7216179-fc8b-476d-96c0-cf3f3702b442',
    3,
    'NCS44520',
    'open',
    NULL,
    'NCS44520',
    'CSC I AKANO',
    'Mess',
    '2024-12-11 00:33:56',
    'NCS46023',
    NULL,
    8,
    0
  ),
  (
    38,
    '28a6f5c2-1042-4189-818a-7eeb40de4f04',
    '2024-12-11 00:52:08',
    'He',
    NULL,
    'both',
    'e7216179-fc8b-476d-96c0-cf3f3702b442',
    3,
    'NCS44489',
    'open',
    NULL,
    'NCS44489',
    'AC F Ibrahim',
    'Morning Drill',
    '2024-12-11 00:52:08',
    'NCS46023',
    NULL,
    8,
    0
  ),
  (
    39,
    '2adb217a-fd90-488e-bd68-c20a4b2bec5e',
    '2024-12-11 01:04:58',
    'Absent at Mess.',
    NULL,
    'both',
    '6228d8ad-a012-429c-a85a-882c4a5d7b84',
    2,
    'NCS44489',
    'open',
    NULL,
    'NCS44489',
    'AC F Ibrahim',
    'Mess Activities',
    '2024-12-11 01:04:58',
    'NCS46025',
    NULL,
    8,
    0
  ),
  (
    40,
    '289906e4-9bf5-4fea-8352-b1e5ba2462b9',
    '2024-12-11 23:22:36',
    'He was absent',
    NULL,
    'both',
    'e7216179-fc8b-476d-96c0-cf3f3702b442',
    3,
    'NCS47004',
    'open',
    NULL,
    'NCS47004',
    'CSC EP Oteri',
    'Morning Drill',
    '2024-12-11 23:22:36',
    'NCS46023',
    NULL,
    8,
    0
  ),
  (
    41,
    '3042a276-a8a2-4622-a57a-d7430cc961b1',
    '2024-12-11 23:23:32',
    'He was late for the drill.',
    NULL,
    'both',
    'e7216179-fc8b-476d-96c0-cf3f3702b442',
    3,
    'NCS47005',
    'closed',
    'I attended morning drill in earnest Sir',
    'NCS47005',
    'CSC E Mbukpa',
    'Morning Drill',
    '2024-12-11 23:39:11',
    'NCS46023',
    'NCS47777',
    8,
    1
  ),
  (
    42,
    '262e6716-20b4-4327-b009-462771ac7b0b',
    '2024-12-11 23:49:59',
    'He failed',
    NULL,
    'both',
    'e7216179-fc8b-476d-96c0-cf3f3702b442',
    4,
    'NCS48391',
    'open',
    NULL,
    'NCS48391',
    'CC MR BEANS',
    'Rehearsals',
    '2024-12-11 23:49:59',
    'NCS46023',
    NULL,
    4,
    0
  ),
  (
    43,
    '8460b4c2-3f8b-48e8-9ea5-b3ac716fdedc',
    '2024-12-12 08:10:19',
    'He stayed back',
    NULL,
    NULL,
    '5f4c6dba-5924-4b22-af5f-5db41c51c8f9',
    2,
    'NCS47005',
    'open',
    NULL,
    'NCS47005',
    'CSC E Mbukpa',
    'Mess Activities',
    '2024-12-12 08:10:19',
    'NCS47010',
    NULL,
    8,
    0
  ),
  (
    44,
    'ab4f6b81-cdd7-4f9e-914b-c704713acbcf',
    '2024-12-12 08:14:54',
    'He’s crying',
    NULL,
    NULL,
    '35dd431c-e77c-4141-b745-a69aadadaee0',
    3,
    'NCS47005',
    'open',
    NULL,
    'NCS47005',
    'CSC E Mbukpa',
    'Morning Drill',
    '2024-12-12 08:14:54',
    'NCS47011',
    NULL,
    8,
    0
  ),
  (
    45,
    '63ccaae0-2e6b-450e-a852-d51dcff5ef07',
    '2024-12-14 08:52:44',
    'He didn’t go',
    NULL,
    'both',
    'e7216179-fc8b-476d-96c0-cf3f3702b442',
    3,
    'NCS48391',
    'open',
    NULL,
    'NCS48391',
    'CC MR BEANS',
    'Mess',
    '2024-12-14 08:52:44',
    'NCS46023',
    NULL,
    4,
    0
  ),
  (
    46,
    'de5b2c22-7a2c-4240-9bb3-f1c121dcd617',
    '2024-12-15 10:07:13',
    'He didn’t report',
    NULL,
    'both',
    'e7216179-fc8b-476d-96c0-cf3f3702b442',
    2,
    'NCS42134',
    'open',
    NULL,
    'NCS42134',
    'ACG GF Ifeanyi',
    'Mess Activities',
    '2024-12-15 10:07:13',
    'NCS46023',
    NULL,
    4,
    0
  ),
  (
    47,
    '20fb3799-64c3-4907-b049-30c365af209a',
    '2024-12-16 16:42:44',
    'He didn’t pay for his drink',
    NULL,
    NULL,
    '9e033460-0488-495b-b06f-90437ac8395a',
    2,
    'NCS47004',
    'open',
    NULL,
    'NCS47004',
    'CSC EP Oteri',
    'Mess Activities',
    '2024-12-16 16:42:44',
    'NCS46001',
    NULL,
    8,
    0
  ),
  (
    48,
    '08e2e919-9525-46ca-bbc1-c7ddc3dc6e77',
    '2024-12-16 17:10:27',
    'He didn’t show up',
    NULL,
    NULL,
    '48051b7b-4b46-4201-bf73-acc0201d83d3',
    3,
    'NCS47066',
    'closed',
    NULL,
    'NCS47066',
    'CSC E Zacharry',
    'Morning Drill',
    '2024-12-16 17:29:43',
    'NCS47062',
    'NCS47060',
    10,
    0
  ),
  (
    49,
    'eb63fa01-8481-47ad-8ef4-e21bc444ac25',
    '2024-12-16 17:11:51',
    'His clothes were dirty ',
    NULL,
    NULL,
    '034566f9-869f-4d50-96eb-ea538e80956a',
    4,
    'NCS47069',
    'confirmed',
    NULL,
    'NCS47069',
    'CSC ER Okon',
    'Shining Parade',
    '2024-12-16 17:29:39',
    'NCS47061',
    'NCS47060',
    10,
    0
  ),
  (
    50,
    'c21709d1-b49c-4ea1-a5b6-c79c019dbb22',
    '2024-12-16 17:13:44',
    'He came late.',
    NULL,
    NULL,
    '48051b7b-4b46-4201-bf73-acc0201d83d3',
    4,
    'NCS47070',
    'confirmed',
    NULL,
    'NCS47070',
    'CSC AR Omiete',
    'Rehearsals',
    '2024-12-16 17:35:37',
    'NCS47062',
    'NCS47060',
    10,
    0
  ),
  (
    51,
    '3974c1e6-0b81-4430-ae50-acc6fd572074',
    '2024-12-16 17:15:16',
    'He came late for Sports.',
    NULL,
    NULL,
    '48051b7b-4b46-4201-bf73-acc0201d83d3',
    3,
    'NCS47065',
    'confirmed',
    NULL,
    'NCS47065',
    'CSC R Ogah',
    'Sports',
    '2024-12-16 17:29:34',
    'NCS47062',
    'NCS47060',
    10,
    0
  ),
  (
    52,
    '160d7136-ca9c-499e-a0eb-d7c711e004c2',
    '2024-12-16 18:31:52',
    'He slept off',
    NULL,
    NULL,
    '48051b7b-4b46-4201-bf73-acc0201d83d3',
    2,
    'NCS47005',
    'open',
    NULL,
    'NCS47005',
    'CSC E Mbukpa',
    'Mess Activities',
    '2024-12-16 18:31:52',
    'NCS47062',
    NULL,
    8,
    0
  ),
  (
    53,
    'ab033c35-3fa9-4413-aed1-d66fa6c2b4e0',
    '2024-12-16 18:33:05',
    'Slept off a ',
    NULL,
    NULL,
    '48051b7b-4b46-4201-bf73-acc0201d83d3',
    3,
    'NCS44488',
    'open',
    NULL,
    'NCS44488',
    'AC ER Okoi',
    'Kilometer Walk',
    '2024-12-16 18:33:05',
    'NCS47062',
    NULL,
    4,
    0
  ),
  (
    54,
    '47d3e048-0214-4945-9fa4-608d2038258d',
    '2024-12-19 11:40:19',
    'He was sick',
    NULL,
    'both',
    '7f7c4ffd-bf52-4c75-89b3-c02bef21e33e',
    4,
    'NCS47005',
    'open',
    NULL,
    'NCS47005',
    'CSC E Mbukpa',
    'Rehearsals',
    '2024-12-19 11:40:19',
    'NCS47063',
    NULL,
    8,
    0
  ),
  (
    55,
    'e3585fe9-409b-422b-ad2c-91251e52e939',
    '2024-12-19 11:45:08',
    'He slept',
    NULL,
    'both',
    '7f7c4ffd-bf52-4c75-89b3-c02bef21e33e',
    2,
    'NCS47070',
    'open',
    NULL,
    'NCS47070',
    'CSC AR Omiete',
    'Mess Activities',
    '2024-12-19 11:45:08',
    'NCS47063',
    NULL,
    10,
    0
  ),
  (
    56,
    '654591bf-08d3-4f30-8448-e4a6989e1a01',
    '2024-12-19 17:32:19',
    'He didn’t go to the Mess',
    NULL,
    'both',
    '7f7c4ffd-bf52-4c75-89b3-c02bef21e33e',
    2,
    'NCS47066',
    'open',
    NULL,
    'NCS47066',
    'CSC E Zacharry',
    'Mess Activities',
    '2024-12-19 17:32:19',
    'NCS47063',
    NULL,
    10,
    0
  ),
  (
    57,
    'bb53ff30-243b-4009-a6cc-d2533da46444',
    '2024-12-19 17:32:19',
    'He didn’t go to the Mess',
    NULL,
    'both',
    '7f7c4ffd-bf52-4c75-89b3-c02bef21e33e',
    2,
    'NCS47066',
    'open',
    NULL,
    'NCS47066',
    'CSC E Zacharry',
    'Mess Activities',
    '2024-12-19 17:32:19',
    'NCS47063',
    NULL,
    10,
    0
  );
-- --------------------------------------------------------
--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(11) NOT NULL,
  `name` enum(
    'Student',
    'Admin',
    'Instructor',
    'Term Coordinator',
    'Chief Instructor',
    'Deputy Commandant',
    'Commandant',
    'Member of Directing Staff',
    'SuperAdmin',
    'Medical',
    'Member of Administrative Staff',
    'Course Officer'
  ) DEFAULT NULL
) ENGINE = MyISAM DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;
--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`)
VALUES (1, 'Student'),
  (2, 'Admin'),
  (3, 'Instructor'),
  (4, 'Term Coordinator'),
  (5, 'Chief Instructor'),
  (6, 'Deputy Commandant'),
  (7, 'Commandant'),
  (8, 'Member of Directing Staff'),
  (9, 'SuperAdmin'),
  (10, 'Medical'),
  (11, 'Member of Administrative Staff'),
  (12, 'Course Officer');
-- --------------------------------------------------------
--
-- Table structure for table `role_permissions`
--

CREATE TABLE `role_permissions` (
  `id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `permission` varchar(255) NOT NULL,
  `route` varchar(255) NOT NULL
) ENGINE = MyISAM DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `service_paper_assignments`
--

CREATE TABLE `service_paper_assignments` (
  `id` int(11) NOT NULL,
  `coordinator_id` int(11) NOT NULL,
  `sponsored_ds_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `course_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE = MyISAM DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;
--
-- Dumping data for table `service_paper_assignments`
--

INSERT INTO `service_paper_assignments` (
    `id`,
    `coordinator_id`,
    `sponsored_ds_id`,
    `category_id`,
    `course_id`,
    `created_at`
  )
VALUES (1, 49, 49, 1, 7, '2024-12-11 12:12:40'),
  (2, 49, 49, 3, 7, '2024-12-11 23:01:49'),
  (3, 74, 74, 1, 10, '2024-12-16 18:45:11'),
  (4, 79, 79, 1, 10, '2024-12-16 18:50:31');
-- --------------------------------------------------------
--
-- Table structure for table `service_paper_categories`
--

CREATE TABLE `service_paper_categories` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `course_type` enum('Senior Course', 'Junior Course', 'Both') NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_by` text NOT NULL
) ENGINE = MyISAM DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;
--
-- Dumping data for table `service_paper_categories`
--

INSERT INTO `service_paper_categories` (
    `id`,
    `title`,
    `course_type`,
    `created_at`,
    `updated_at`,
    `created_by`
  )
VALUES (
    1,
    'Individual Service Paper',
    'Both',
    '2024-12-11 16:44:23',
    '2024-12-11 11:44:23',
    'NCS12345'
  ),
  (
    2,
    'WAM Service Paper',
    'Senior Course',
    '2024-12-11 16:49:51',
    '2024-12-11 11:49:51',
    'NCS12345'
  ),
  (
    3,
    'Leadership Service Paper',
    'Senior Course',
    '2024-12-11 17:07:00',
    '2024-12-11 12:07:00',
    'NCS44444'
  );
-- --------------------------------------------------------
--
-- Table structure for table `service_paper_stages`
--

CREATE TABLE `service_paper_stages` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `stage_name` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `start_timestamp` datetime NOT NULL,
  `end_timestamp` datetime NOT NULL,
  `duration_days` int(11) GENERATED ALWAYS AS (
    to_days(`end_timestamp`) - to_days(`start_timestamp`)
  ) STORED,
  `course_id` int(11) NOT NULL,
  `punishment_point` int(11) NOT NULL DEFAULT 0
) ENGINE = MyISAM DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `student_service_papers`
--

CREATE TABLE `student_service_papers` (
  `id` int(11) NOT NULL,
  `student_id` int(11) NOT NULL,
  `supervising_ds_id` int(11) NOT NULL,
  `chief_instructor_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `stage_id` int(11) NOT NULL,
  `stage_status` enum('Pending', 'Submitted', 'Approved') DEFAULT 'Pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `course_id` int(11) NOT NULL
) ENGINE = MyISAM DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;
--
-- Triggers `users`
--
DELIMITER $$
END $$ DELIMITER;
DELIMITER $$
END $$ DELIMITER;
DELIMITER $$
-- Increment count for the new course
UPDATE courses
SET total_registered_students = total_registered_students + 1
WHERE id = NEW.course_id;
END IF;
END $$ DELIMITER;
--
-- Indexes for dumped tables
--

--
-- Indexes for table `closed_reports`
--
ALTER TABLE `closed_reports`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `confirmed_reports`
--
ALTER TABLE `confirmed_reports`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `conversations`
--
ALTER TABLE `conversations`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `conversation_members`
--
ALTER TABLE `conversation_members`
ADD PRIMARY KEY (`conversation_id`, `user_id`),
  ADD KEY `user_id` (`user_id`);
--
-- Indexes for table `courses`
--
ALTER TABLE `courses`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `course_activities`
--
ALTER TABLE `course_activities`
ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);
--
-- Indexes for table `messages`
--
ALTER TABLE `messages`
ADD PRIMARY KEY (`id`),
  ADD KEY `conversation_id` (`conversation_id`),
  ADD KEY `sender_id` (`sender_id`);
--
-- Indexes for table `officer_rank`
--
ALTER TABLE `officer_rank`
ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);
--
-- Indexes for table `reports`
--
ALTER TABLE `reports`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `role_permissions`
--
ALTER TABLE `role_permissions`
ADD PRIMARY KEY (`id`),
  ADD KEY `role_id` (`role_id`);
--
-- Indexes for table `service_paper_assignments`
--
ALTER TABLE `service_paper_assignments`
ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_assignment` (
    `coordinator_id`,
    `sponsored_ds_id`,
    `category_id`
  ),
  ADD KEY `sponsored_ds_id` (`sponsored_ds_id`),
  ADD KEY `category_id` (`category_id`),
  ADD KEY `fk_course_id` (`course_id`);
--
-- Indexes for table `service_paper_categories`
--
ALTER TABLE `service_paper_categories`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `service_paper_stages`
--
ALTER TABLE `service_paper_stages`
ADD PRIMARY KEY (`id`),
  ADD KEY `category_id` (`category_id`),
  ADD KEY `fk_course_id` (`course_id`);
--
-- Indexes for table `student_service_papers`
--
ALTER TABLE `student_service_papers`
ADD PRIMARY KEY (`id`),
  ADD KEY `student_id` (`student_id`),
  ADD KEY `supervising_ds_id` (`supervising_ds_id`),
  ADD KEY `chief_instructor_id` (`chief_instructor_id`),
  ADD KEY `stage_id` (`stage_id`),
  ADD KEY `fk_course_id` (`course_id`),
  ADD KEY `fk_category_id` (`category_id`);
--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `closed_reports`
--
ALTER TABLE `closed_reports`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `confirmed_reports`
--
ALTER TABLE `confirmed_reports`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `conversations`
--
ALTER TABLE `conversations`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,
  AUTO_INCREMENT = 69;
--
-- AUTO_INCREMENT for table `courses`
--
ALTER TABLE `courses`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,
  AUTO_INCREMENT = 12;
--
-- AUTO_INCREMENT for table `course_activities`
--
ALTER TABLE `course_activities`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,
  AUTO_INCREMENT = 13;
--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,
  AUTO_INCREMENT = 98;
--
-- AUTO_INCREMENT for table `officer_rank`
--
ALTER TABLE `officer_rank`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,
  AUTO_INCREMENT = 23;
--
-- AUTO_INCREMENT for table `reports`
--
ALTER TABLE `reports`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,
  AUTO_INCREMENT = 58;
--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,
  AUTO_INCREMENT = 13;
--
-- AUTO_INCREMENT for table `role_permissions`
--
ALTER TABLE `role_permissions`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `service_paper_assignments`
--
ALTER TABLE `service_paper_assignments`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,
  AUTO_INCREMENT = 5;
--
-- AUTO_INCREMENT for table `service_paper_categories`
--
ALTER TABLE `service_paper_categories`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,
  AUTO_INCREMENT = 4;
--
-- AUTO_INCREMENT for table `service_paper_stages`
--
ALTER TABLE `service_paper_stages`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `student_service_papers`
--
ALTER TABLE `student_service_papers`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;
;
;
;