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

START TRANSACTION;



--
-- Database: `nesisoft_hopepress`
--

-- --------------------------------------------------------

--
-- Table structure for table `admin_logs`
--

CREATE TABLE `admin_logs` (
  `id` int(11) NOT NULL,
  `admin_id` int(11) NOT NULL,
  `action` varchar(255) NOT NULL,
  `action_type` enum('create','update','delete','view','export','other') DEFAULT 'other',
  `target_type` varchar(50) DEFAULT NULL,
  `target_id` int(11) DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`details`)),
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `admin_logs`
--

INSERT INTO `admin_logs` (`id`, `admin_id`, `action`, `action_type`, `target_type`, `target_id`, `ip_address`, `user_agent`, `details`, `created_at`) VALUES
(1, 1, 'create_service_template', 'create', 'service_template', 1, '154.161.170.18', NULL, '{\"name\":\"Workforce Service\",\"description\":\"Workforce Service\",\"service_type_id\":5,\"location\":\"Royal Ravico Hotel\",\"latitude\":5.602306999999999703732100897468626499176025390625,\"longitude\":-0.06023040000000000337987415832685655914247035980224609375,\"geofence_radius\":100,\"is_recurring\":false}', '2025-10-29 19:30:56'),
(2, 1, 'activate_service', 'create', 'service_occurrence', 1, '154.161.170.18', NULL, '{\"template_name\":\"Workforce Service\",\"occurrence_date\":\"2025-10-29\",\"start_time\":\"2025-10-29 19:00:00\",\"end_time\":\"2025-10-29 21:30:00\"}', '2025-10-29 19:31:27'),
(3, 1, 'activate_service', 'create', 'service_occurrence', 2, '89.187.185.185', NULL, '{\"template_name\":\"Workforce Service\",\"occurrence_date\":\"2025-11-01\",\"start_time\":\"2025-11-01 18:30:00\",\"end_time\":\"2025-11-01 20:30:00\"}', '2025-11-01 18:03:08'),
(4, 1, 'create_service_template', 'create', 'service_template', 2, '89.187.177.74', NULL, '{\"name\":\"Dominion Encounter Service\",\"description\":\"Dominion Encounter Service\",\"service_type_id\":1,\"location\":\"Royal Ravico Hotel\",\"latitude\":5.61025599999999968758856994099915027618408203125,\"longitude\":-0.0764289999999999969393371657133684493601322174072265625,\"geofence_radius\":100,\"is_recurring\":false}', '2025-11-01 19:00:05'),
(5, 1, 'activate_service', 'create', 'service_occurrence', 3, '89.187.177.74', NULL, '{\"template_name\":\"Dominion Encounter Service\",\"occurrence_date\":\"2025-11-01\",\"start_time\":\"2025-11-01 07:30:00\",\"end_time\":\"2025-11-01 12:30:00\"}', '2025-11-01 19:19:19'),
(6, 1, 'activate_service', 'create', 'service_occurrence', 4, '89.187.177.74', NULL, '{\"template_name\":\"Dominion Encounter Service\",\"occurrence_date\":\"2025-11-01\",\"start_time\":\"2025-11-01 20:00:00\",\"end_time\":\"2025-11-01 21:00:00\"}', '2025-11-01 19:48:59'),
(7, 1, 'activate_service', 'create', 'service_occurrence', 5, '89.187.177.74', NULL, '{\"template_name\":\"Dominion Encounter Service\",\"occurrence_date\":\"2025-11-01\",\"start_time\":\"2025-11-01 20:30:00\",\"end_time\":\"2025-11-01 21:30:00\"}', '2025-11-01 19:51:28'),
(8, 1, 'activate_service', 'create', 'service_occurrence', 6, '154.161.139.133', NULL, '{\"template_name\":\"Dominion Encounter Service\",\"occurrence_date\":\"2025-11-01\",\"start_time\":\"2025-11-01 23:00\",\"end_time\":\"2025-11-01 23:30\"}', '2025-11-01 22:22:41'),
(9, 1, 'create_department', 'create', 'department', 20, '154.161.177.32', NULL, '{\"name\":\"Pastors\"}', '2025-11-02 01:34:34'),
(10, 1, 'create_department', 'create', 'department', 21, '154.161.161.45', NULL, '{\"name\":\"Coordinating\"}', '2025-11-02 08:09:40'),
(11, 1, 'create new user', 'create', 'user', 32, '154.161.62.73', NULL, '{\"email\":\"admin@hpc.com\",\"role\":\"admin\"}', '2025-11-02 13:05:45'),
(12, 32, 'create new user', 'create', 'user', 37, '154.161.62.73', NULL, '{\"email\":\"boakyewaaelizabth39@gmail.com\",\"role\":\"worker\"}', '2025-11-02 13:40:55'),
(13, 32, 'create_service_template', 'create', 'service_template', 3, '154.160.26.8', NULL, '{\"name\":\"Commanding The Week\",\"description\":\"Commanding The Week\",\"service_type_id\":1,\"location\":\"Royal Ravico Hotel\",\"latitude\":46.46466000000000207137418328784406185150146484375,\"longitude\":75.4546399999999977126208250410854816436767578125,\"geofence_radius\":100,\"is_recurring\":false}', '2025-11-03 06:13:59'),
(14, 32, 'activate_service', 'create', 'service_occurrence', 7, '154.160.26.8', NULL, '{\"template_name\":\"Commanding The Week\",\"occurrence_date\":\"2025-11-03\",\"start_time\":\"2025-11-03 06:00\",\"end_time\":\"2025-11-03 07:00\"}', '2025-11-03 06:15:05'),
(15, 32, 'create_service_template', 'create', 'service_template', 4, '154.160.26.8', NULL, '{\"name\":\"Prophetic & Miracle Service\",\"description\":\"Prophetic & Miracle Service\",\"service_type_id\":1,\"location\":\"Royal Ravico Hotel \",\"latitude\":5.6087030000000002161186785087920725345611572265625,\"longitude\":-0.0764289999999999969393371657133684493601322174072265625,\"geofence_radius\":100,\"is_recurring\":false}', '2025-11-03 06:25:33'),
(16, 1, 'create_service_template', 'create', 'service_template', 5, '154.160.27.192', NULL, '{\"name\":\"Singles & Couples Summit\",\"description\":\"Singles & Couples Summit\",\"service_type_id\":2,\"location\":\"Royal Ravico Hotel\",\"latitude\":5.6102889999999998593693817383609712123870849609375,\"longitude\":-0.0763149999999999939515049618421471677720546722412109375,\"geofence_radius\":100,\"is_recurring\":false}', '2025-11-03 08:03:45'),
(17, 1, 'activate_service', 'create', 'service_occurrence', 8, '154.160.27.192', NULL, '{\"template_name\":\"Singles & Couples Summit\",\"occurrence_date\":\"2025-11-03\",\"start_time\":\"2025-11-03 18:00\",\"end_time\":\"2025-11-03 21:00\"}', '2025-11-03 08:06:43'),
(18, 1, 'activate_service', 'create', 'service_occurrence', 9, '154.161.135.25', NULL, '{\"template_name\":\"Workforce Service\",\"occurrence_date\":\"2025-11-05\",\"start_time\":\"2025-11-05 19:00:00\",\"end_time\":\"2025-11-05 21:00:00\"}', '2025-11-05 10:31:45'),
(19, 1, 'update_service_template', 'update', 'service_template', 1, '197.251.144.190', NULL, '{\"name\":\"Workforce Service\",\"description\":\"Workforce Service\",\"service_type_id\":5,\"location\":\"Royal Ravico Hotel\",\"latitude\":5.61025599999999968758856994099915027618408203125,\"longitude\":-0.0764289999999999969393371657133684493601322174072265625,\"geofence_radius\":100,\"is_recurring\":true,\"recurrence_pattern\":\"weekly\",\"recurrence_interval\":1,\"default_start_time\":\"19:00:00\",\"default_end_time\":\"21:30\",\"recurrence_start_date\":\"2025-11-05\",\"recurrence_end_date\":\"2039-11-05\",\"recurrence_days\":\"Wednesday\",\"id\":1}', '2025-11-05 17:56:41'),
(20, 1, 'activate_service', 'create', 'service_occurrence', 10, '154.161.191.201', NULL, '{\"template_name\":\"Prophetic & Miracle Service\",\"occurrence_date\":\"2025-11-07\",\"start_time\":\"2025-11-07 18:30:00\",\"end_time\":\"2025-11-07 21:30:00\"}', '2025-11-07 09:40:17'),
(21, 1, 'activate_service', 'create', 'service_occurrence', 11, '154.160.20.216', NULL, '{\"template_name\":\"Dominion Encounter Service\",\"occurrence_date\":\"2025-11-09\",\"start_time\":\"2025-11-09 07:30:00\",\"end_time\":\"2025-11-09 13:30:00\"}', '2025-11-09 06:30:57'),
(22, 1, 'create_department', 'create', 'department', 22, '154.160.23.73', NULL, '{\"name\":\"Receivers\"}', '2025-11-09 08:18:58'),
(23, 1, 'activate_service', 'create', 'service_occurrence', 12, '154.161.161.33', NULL, '{\"template_name\":\"Commanding The Week\",\"occurrence_date\":\"2025-11-10\",\"start_time\":\"2025-11-10 06:00:00\",\"end_time\":\"2025-11-10 07:00:00\"}', '2025-11-10 05:38:44'),
(24, 1, 'activate_service', 'create', 'service_occurrence', 13, '154.161.169.83', NULL, '{\"template_name\":\"Workforce Service\",\"occurrence_date\":\"2025-11-12\",\"start_time\":\"2025-11-12 19:00:00\",\"end_time\":\"2025-11-12 21:30:00\"}', '2025-11-12 15:31:03'),
(25, 1, 'activate_service', 'create', 'service_occurrence', 14, '45.222.194.100', NULL, '{\"template_name\":\"Prophetic & Miracle Service\",\"occurrence_date\":\"2025-11-14\",\"start_time\":\"2025-11-14 18:30:00\",\"end_time\":\"2025-11-14 21:30:00\"}', '2025-11-14 17:47:10'),
(26, 1, 'activate_service', 'create', 'service_occurrence', 15, '154.161.162.186', NULL, '{\"template_name\":\"Dominion Encounter Service\",\"occurrence_date\":\"2025-11-16\",\"start_time\":\"2025-11-16 07:30:00\",\"end_time\":\"2025-11-16 13:30:00\"}', '2025-11-16 07:13:28'),
(27, 1, 'activate_service', 'create', 'service_occurrence', 16, '154.161.133.48', NULL, '{\"template_name\":\"Workforce Service\",\"occurrence_date\":\"2025-11-19\",\"start_time\":\"2025-11-19 19:00:00\",\"end_time\":\"2025-11-19 21:30:00\"}', '2025-11-19 09:31:00'),
(28, 1, 'activate_service', 'create', 'service_occurrence', 17, '154.161.157.200', NULL, '{\"template_name\":\"Prophetic & Miracle Service\",\"occurrence_date\":\"2025-11-21\",\"start_time\":\"2025-11-21 18:30:00\",\"end_time\":\"2025-11-21 21:30:00\"}', '2025-11-21 18:11:11'),
(29, 1, 'activate_service', 'create', 'service_occurrence', 18, '154.161.1.195', NULL, '{\"template_name\":\"Dominion Encounter Service\",\"occurrence_date\":\"2025-11-23\",\"start_time\":\"2025-11-23 07:30:00\",\"end_time\":\"2025-11-23 13:30:00\"}', '2025-11-23 08:11:41'),
(30, 1, 'activate_service', 'create', 'service_occurrence', 19, '154.161.141.118', NULL, '{\"template_name\":\"Prophetic & Miracle Service\",\"occurrence_date\":\"2025-11-28\",\"start_time\":\"2025-11-28 18:30:00\",\"end_time\":\"2025-11-28 21:30:00\"}', '2025-11-28 16:04:42'),
(31, 1, 'activate_service', 'create', 'service_occurrence', 20, '154.161.163.32', NULL, '{\"template_name\":\"Dominion Encounter Service\",\"occurrence_date\":\"2025-11-30\",\"start_time\":\"2025-11-30 07:30:00\",\"end_time\":\"2025-11-30 13:30:00\"}', '2025-11-30 07:01:34'),
(32, 1, 'create_service_template', 'create', 'service_template', 6, '45.222.194.100', NULL, '{\"name\":\"7 DAYS OF FASTING & PRAYERS\",\"description\":\"7 DAYS OF FASTING & PRAYERS\",\"service_type_id\":4,\"location\":\"Royal Ravico Hotel \",\"latitude\":0.66600000000000003641531520770513452589511871337890625,\"longitude\":0.66600000000000003641531520770513452589511871337890625,\"geofence_radius\":100,\"is_recurring\":false}', '2025-12-02 17:24:11'),
(33, 1, 'activate_service', 'create', 'service_occurrence', 21, '45.222.194.100', NULL, '{\"template_name\":\"7 DAYS OF FASTING & PRAYERS\",\"occurrence_date\":\"2025-12-02\",\"start_time\":\"2025-12-02 18:30\",\"end_time\":\"2025-12-02 21:30\"}', '2025-12-02 17:24:49'),
(34, 1, 'activate_service', 'create', 'service_occurrence', 22, '154.161.174.191', NULL, '{\"template_name\":\"7 DAYS OF FASTING & PRAYERS\",\"occurrence_date\":\"2025-12-03\",\"start_time\":\"2025-12-03 18:30:00\",\"end_time\":\"2025-12-03 20:30\"}', '2025-12-03 17:00:36');

-- --------------------------------------------------------

--
-- Table structure for table `attendance`
--

CREATE TABLE `attendance` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `service_occurrence_id` int(11) NOT NULL,
  `clock_in_time` datetime NOT NULL,
  `clock_out_time` datetime DEFAULT NULL,
  `clock_in_latitude` decimal(10,8) DEFAULT NULL,
  `clock_in_longitude` decimal(11,8) DEFAULT NULL,
  `clock_out_latitude` decimal(10,8) DEFAULT NULL,
  `clock_out_longitude` decimal(11,8) DEFAULT NULL,
  `time_spent` int(11) DEFAULT NULL,
  `is_valid` tinyint(1) DEFAULT 1,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `attendance`
--

INSERT INTO `attendance` (`id`, `user_id`, `service_occurrence_id`, `clock_in_time`, `clock_out_time`, `clock_in_latitude`, `clock_in_longitude`, `clock_out_latitude`, `clock_out_longitude`, `time_spent`, `is_valid`, `notes`, `created_at`, `updated_at`) VALUES
(1, 2, 1, '2025-10-29 20:43:29', '2025-10-29 22:59:12', 5.61037780, -0.07639560, 5.61026670, -0.07640740, 75, 1, NULL, '2025-10-29 19:43:29', '2025-10-29 21:59:12'),
(2, 3, 1, '2025-10-29 20:58:21', '2025-10-29 23:18:29', 5.61019232, -0.07644973, 5.61016005, -0.07644867, 80, 1, NULL, '2025-10-29 19:58:21', '2025-10-29 22:18:29'),
(8, 3, 5, '2025-11-02 07:55:22', '2025-11-02 13:12:30', 5.61055744, -0.07587390, 5.61055744, -0.07587390, 317, 1, NULL, '2025-11-02 07:55:22', '2025-11-02 13:12:30'),
(9, 16, 5, '2025-11-02 08:06:49', '2025-11-02 13:12:30', 5.61046376, -0.07645555, 5.61055744, -0.07587390, 300, 1, NULL, '2025-11-02 08:06:49', '2025-11-14 17:51:47'),
(10, 17, 5, '2025-11-02 08:07:59', '2025-11-02 13:12:09', 5.61025209, -0.07625477, 5.61025209, -0.07625477, 304, 1, NULL, '2025-11-02 08:07:59', '2025-11-02 13:12:09'),
(11, 18, 5, '2025-11-02 08:10:19', '2025-11-02 13:19:59', 5.60999611, -0.07591161, 5.61039151, -0.07633804, 309, 1, NULL, '2025-11-02 08:10:19', '2025-11-02 13:19:59'),
(12, 15, 5, '2025-11-02 08:12:49', '2025-11-02 12:36:46', 5.61029450, -0.07623279, 5.61029450, -0.07623279, 263, 1, NULL, '2025-11-02 08:12:49', '2025-11-02 12:36:46'),
(13, 19, 5, '2025-11-02 08:13:47', '2025-11-02 13:05:36', 5.61031830, -0.07641650, 5.61037880, -0.07639540, 291, 1, NULL, '2025-11-02 08:13:47', '2025-11-02 13:05:36'),
(14, 12, 5, '2025-11-02 08:14:24', '2025-11-02 13:05:36', 5.61030300, -0.07639640, 5.61037880, -0.07639540, 280, 1, NULL, '2025-11-02 08:14:24', '2025-11-14 17:51:35'),
(15, 10, 5, '2025-11-02 08:37:18', '2025-11-02 13:25:11', 5.61055463, -0.07635884, 5.60967378, -0.07652609, 287, 1, NULL, '2025-11-02 08:37:18', '2025-11-02 13:25:11'),
(16, 27, 5, '2025-11-02 09:34:29', '2025-11-02 13:25:11', 5.61057060, -0.07606330, 5.60967378, -0.07652609, 150, 1, NULL, '2025-11-02 09:34:29', '2025-11-14 17:52:35'),
(17, 13, 5, '2025-11-02 10:54:19', '2025-11-02 13:03:11', 5.61022840, -0.07626590, 5.61024380, -0.07640750, 128, 1, NULL, '2025-11-02 10:54:19', '2025-11-02 13:03:11'),
(18, 2, 5, '2025-11-02 11:16:24', '2025-11-02 13:01:42', 5.61021470, -0.07625090, 5.61025780, -0.07640850, 105, 1, NULL, '2025-11-02 11:16:24', '2025-11-02 13:01:42'),
(19, 14, 5, '2025-11-02 12:13:06', '2025-11-02 12:46:12', 5.61022860, -0.07625770, 5.61038630, -0.07639620, 33, 1, NULL, '2025-11-02 12:13:06', '2025-11-02 12:46:12'),
(20, 22, 5, '2025-11-02 13:09:48', '2025-11-02 13:09:51', 5.61030859, -0.07641445, 5.61034134, -0.07643533, 0, 0, NULL, '2025-11-02 13:09:48', '2025-11-02 13:09:51'),
(21, 25, 5, '2025-11-02 13:14:37', '2025-11-02 13:14:39', 5.61031586, -0.07634724, 5.61031586, -0.07634724, 0, 0, NULL, '2025-11-02 13:14:37', '2025-11-02 13:14:39'),
(22, 35, 5, '2025-11-02 13:20:05', '2025-11-02 13:20:09', 5.61042170, -0.07631136, 5.61029685, -0.07646043, 0, 0, NULL, '2025-11-02 13:20:05', '2025-11-02 13:20:09'),
(23, 26, 5, '2025-11-02 13:29:41', '2025-11-02 13:29:51', 5.61030870, -0.07640160, 5.61037040, -0.07639590, 0, 0, NULL, '2025-11-02 13:29:41', '2025-11-02 13:29:51'),
(24, 33, 5, '2025-11-02 13:43:55', '2025-11-02 13:46:53', 5.61027260, -0.07640660, 5.61027260, -0.07640660, 2, 0, NULL, '2025-11-02 13:43:55', '2025-11-02 13:46:53'),
(25, 2, 7, '2025-11-03 06:20:04', '2025-11-03 07:09:29', 5.61029480, -0.07640380, 5.61025450, -0.07641070, 49, 1, NULL, '2025-11-03 06:20:04', '2025-11-03 07:09:29'),
(26, 28, 7, '2025-11-03 07:07:29', '2025-11-03 07:09:29', 5.61021980, -0.07646655, 5.61025450, -0.07641070, 0, 0, NULL, '2025-11-03 07:07:29', '2025-11-14 17:53:47'),
(27, 22, 7, '2025-11-03 07:09:40', '2025-11-03 07:09:43', 5.61029585, -0.07640600, 5.61038861, -0.07612543, 0, 0, NULL, '2025-11-03 07:09:40', '2025-11-03 07:09:43'),
(28, 13, 9, '2025-11-05 18:01:00', '2025-11-05 21:41:38', 5.61024810, -0.07640850, 5.61040560, -0.07644500, 220, 1, NULL, '2025-11-05 18:01:00', '2025-11-05 21:41:38'),
(29, 10, 9, '2025-11-05 18:04:58', '2025-11-05 22:00:24', 5.61018120, -0.07647126, 5.61018120, -0.07647126, 235, 1, NULL, '2025-11-05 18:04:58', '2025-11-05 22:00:24'),
(30, 18, 9, '2025-11-05 18:13:52', '2025-11-05 21:43:57', 5.61088028, -0.07689718, 5.61062192, -0.07658144, 210, 1, NULL, '2025-11-05 18:13:52', '2025-11-05 21:43:57'),
(31, 2, 9, '2025-11-05 18:32:23', '2025-11-05 21:41:33', 5.61022050, -0.07618620, 5.61042030, -0.07649750, 189, 1, NULL, '2025-11-05 18:32:23', '2025-11-05 21:41:33'),
(32, 41, 9, '2025-11-05 18:43:26', '2025-11-05 21:42:30', 5.61032450, -0.07629670, 5.61040460, -0.07637740, 179, 1, NULL, '2025-11-05 18:43:26', '2025-11-05 21:42:30'),
(33, 23, 9, '2025-11-05 18:50:18', '2025-11-05 21:42:32', 5.61024030, -0.07619700, 5.61040060, -0.07645090, 172, 1, NULL, '2025-11-05 18:50:18', '2025-11-05 21:42:32'),
(34, 17, 9, '2025-11-05 18:51:24', '2025-11-05 21:41:31', 5.61025209, -0.07625477, 5.61042693, -0.07644017, 170, 1, NULL, '2025-11-05 18:51:24', '2025-11-05 21:41:31'),
(35, 42, 9, '2025-11-05 19:04:51', NULL, 5.61022280, -0.07619120, NULL, NULL, NULL, 1, NULL, '2025-11-05 19:04:51', '2025-11-05 19:04:51'),
(36, 36, 9, '2025-11-05 19:13:26', '2025-11-05 21:42:53', 5.61035829, -0.07644083, 5.61051918, -0.07636135, 149, 1, NULL, '2025-11-05 19:13:26', '2025-11-05 21:42:53'),
(37, 15, 9, '2025-11-05 19:13:54', '2025-11-05 21:41:38', 5.61029450, -0.07623279, 5.61029450, -0.07623279, 147, 1, NULL, '2025-11-05 19:13:54', '2025-11-05 21:41:38'),
(38, 29, 9, '2025-11-05 19:19:28', '2025-11-05 21:42:09', 5.61051193, -0.07637278, 5.61042420, -0.07645351, 142, 1, NULL, '2025-11-05 19:19:28', '2025-11-05 21:42:09'),
(39, 12, 9, '2025-11-05 19:27:01', NULL, 5.61033000, -0.07609670, NULL, NULL, NULL, 1, NULL, '2025-11-05 19:27:01', '2025-11-05 19:27:01'),
(40, 16, 9, '2025-11-05 19:40:37', '2025-11-05 21:43:02', 5.61070031, -0.07643765, 5.61046394, -0.07645549, 122, 1, NULL, '2025-11-05 19:40:37', '2025-11-05 21:43:02'),
(41, 43, 9, '2025-11-05 19:50:29', '2025-11-05 21:41:56', 5.61046409, -0.07645549, 5.61057348, -0.07633872, 111, 1, NULL, '2025-11-05 19:50:29', '2025-11-05 21:41:56'),
(42, 45, 9, '2025-11-05 19:55:08', '2025-11-05 21:41:00', 5.61020620, -0.07619040, 5.61043130, -0.07652130, 105, 1, NULL, '2025-11-05 19:55:08', '2025-11-05 21:41:00'),
(43, 22, 9, '2025-11-05 19:55:16', '2025-11-05 19:55:54', 5.60987724, -0.07640217, 5.61028682, -0.07629489, 0, 0, NULL, '2025-11-05 19:55:16', '2025-11-05 19:55:54'),
(44, 26, 9, '2025-11-05 21:42:11', '2025-11-05 21:42:15', 5.61041120, -0.07648180, 5.61041120, -0.07648180, 0, 0, NULL, '2025-11-05 21:42:11', '2025-11-05 21:42:15'),
(45, 25, 9, '2025-11-05 21:43:13', '2025-11-05 21:43:15', 5.61031586, -0.07634724, 5.61031586, -0.07634724, 0, 0, NULL, '2025-11-05 21:43:13', '2025-11-05 21:43:15'),
(46, 10, 10, '2025-11-07 17:32:37', NULL, 5.61030627, -0.07607831, NULL, NULL, NULL, 1, NULL, '2025-11-07 17:32:37', '2025-11-07 17:32:37'),
(47, 13, 10, '2025-11-07 17:35:43', NULL, 5.61023140, -0.07620220, NULL, NULL, NULL, 1, NULL, '2025-11-07 17:35:43', '2025-11-07 17:35:43'),
(48, 17, 10, '2025-11-07 18:19:12', '2025-11-07 22:13:18', 5.61027054, -0.07630155, 5.61018782, -0.07621056, 234, 1, NULL, '2025-11-07 18:19:12', '2025-11-07 22:13:18'),
(49, 2, 10, '2025-11-07 18:43:19', '2025-11-07 21:44:37', 5.61042710, -0.07595170, 5.61022270, -0.07619350, 181, 1, NULL, '2025-11-07 18:43:19', '2025-11-07 21:44:37'),
(50, 41, 10, '2025-11-07 18:44:29', NULL, 5.61080180, -0.07655060, NULL, NULL, NULL, 1, NULL, '2025-11-07 18:44:29', '2025-11-07 18:44:29'),
(51, 42, 10, '2025-11-07 18:46:27', NULL, 5.61017737, -0.07619661, NULL, NULL, NULL, 1, NULL, '2025-11-07 18:46:27', '2025-11-07 18:46:27'),
(52, 12, 10, '2025-11-07 18:57:25', '2025-11-07 22:14:13', 5.61022490, -0.07618950, 5.61022510, -0.07618220, 196, 1, NULL, '2025-11-07 18:57:25', '2025-11-07 22:14:13'),
(53, 14, 10, '2025-11-07 18:59:20', '2025-11-07 22:17:04', 5.60948860, -0.07599060, 5.61022510, -0.07618220, 197, 1, NULL, '2025-11-07 18:59:20', '2025-11-07 22:17:04'),
(54, 43, 10, '2025-11-07 19:01:18', '2025-11-07 21:45:06', 5.61070632, -0.07619693, 5.61017721, -0.07619609, 163, 1, NULL, '2025-11-07 19:01:18', '2025-11-07 21:45:06'),
(55, 54, 10, '2025-11-07 19:04:27', '2025-11-07 22:14:45', 5.61030846, -0.07633590, 5.61030846, -0.07633590, 190, 1, NULL, '2025-11-07 19:04:27', '2025-11-07 22:14:45'),
(56, 3, 10, '2025-11-07 19:06:01', '2025-11-07 22:13:28', 5.61064117, -0.07630771, 5.61005163, -0.07602953, 187, 1, NULL, '2025-11-07 19:06:01', '2025-11-07 22:13:28'),
(57, 29, 10, '2025-11-07 19:18:53', '2025-11-07 22:13:48', 5.61053430, -0.07632726, 5.61018517, -0.07620863, 174, 1, NULL, '2025-11-07 19:18:53', '2025-11-07 22:13:48'),
(58, 16, 10, '2025-11-07 19:20:09', NULL, 5.61028233, -0.07613787, NULL, NULL, NULL, 1, NULL, '2025-11-07 19:20:09', '2025-11-07 19:20:09'),
(59, 51, 10, '2025-11-07 19:20:43', '2025-11-07 22:25:08', 5.61096340, -0.07632602, 5.61033721, -0.07636472, 184, 1, NULL, '2025-11-07 19:20:43', '2025-11-07 22:25:08'),
(60, 22, 10, '2025-11-07 19:39:58', '2025-11-07 22:13:24', 5.61011692, -0.07625837, 5.61017730, -0.07620033, 153, 1, NULL, '2025-11-07 19:39:58', '2025-11-07 22:13:24'),
(61, 25, 10, '2025-11-07 19:41:53', NULL, 5.61031586, -0.07634724, NULL, NULL, NULL, 1, NULL, '2025-11-07 19:41:53', '2025-11-07 19:41:53'),
(62, 15, 10, '2025-11-07 19:52:58', '2025-11-07 21:45:35', 5.61064997, -0.07613510, 5.61029450, -0.07623279, 112, 1, NULL, '2025-11-07 19:52:58', '2025-11-07 21:45:35'),
(63, 60, 10, '2025-11-07 20:04:51', '2025-11-07 21:39:41', 5.61005051, -0.07602804, 5.61016927, -0.07619985, 94, 1, NULL, '2025-11-07 20:04:51', '2025-11-07 21:39:41'),
(64, 39, 10, '2025-11-07 20:17:33', '2025-11-07 21:49:12', 5.61029411, -0.07621556, 5.61029411, -0.07621556, 91, 1, NULL, '2025-11-07 20:17:33', '2025-11-07 21:49:12'),
(65, 26, 10, '2025-11-07 21:45:29', NULL, 5.61022420, -0.07619240, NULL, NULL, NULL, 1, NULL, '2025-11-07 21:45:29', '2025-11-07 21:45:29'),
(66, 35, 10, '2025-11-07 21:45:49', NULL, 5.61023422, -0.07618905, NULL, NULL, NULL, 1, NULL, '2025-11-07 21:45:49', '2025-11-07 21:45:49'),
(67, 17, 11, '2025-11-09 07:14:05', '2025-11-09 12:55:00', 5.61027054, -0.07630155, 5.61018088, -0.07622181, 340, 1, NULL, '2025-11-09 07:14:05', '2025-11-09 12:55:00'),
(68, 41, 11, '2025-11-09 07:24:43', '2025-11-09 13:30:32', 5.61037360, -0.07638690, 5.61024590, -0.07619410, 365, 1, NULL, '2025-11-09 07:24:43', '2025-11-09 13:30:32'),
(69, 10, 11, '2025-11-09 07:30:28', '2025-11-09 12:45:43', 5.61037870, -0.07631547, 5.61014824, -0.07622569, 315, 1, NULL, '2025-11-09 07:30:28', '2025-11-09 12:45:43'),
(70, 18, 11, '2025-11-09 07:35:37', '2025-11-09 13:12:06', 5.61047580, -0.07640851, 5.60948753, -0.07651530, 336, 1, NULL, '2025-11-09 07:35:37', '2025-11-09 13:12:06'),
(71, 60, 11, '2025-11-09 07:38:48', '2025-11-09 12:43:40', 5.61005153, -0.07602954, 5.61005163, -0.07602953, 304, 1, NULL, '2025-11-09 07:38:48', '2025-11-09 12:43:40'),
(72, 69, 11, '2025-11-09 07:42:41', '2025-11-09 13:10:54', 5.61022510, -0.07618200, 5.61022530, -0.07618210, 328, 1, NULL, '2025-11-09 07:42:41', '2025-11-09 13:10:54'),
(73, 15, 11, '2025-11-09 07:52:38', '2025-11-09 13:23:54', 5.61055459, -0.07606348, 5.61029450, -0.07623279, 331, 1, NULL, '2025-11-09 07:52:38', '2025-11-09 13:23:54'),
(74, 35, 11, '2025-11-09 07:58:26', NULL, 5.61029158, -0.07631177, NULL, NULL, NULL, 1, NULL, '2025-11-09 07:58:26', '2025-11-09 07:58:26'),
(75, 72, 11, '2025-11-09 08:01:37', '2025-11-09 13:24:37', 5.61022865, -0.07624590, 5.61016293, -0.07625091, 323, 1, NULL, '2025-11-09 08:01:37', '2025-11-09 13:24:37'),
(76, 2, 11, '2025-11-09 08:02:12', '2025-11-09 13:28:44', 5.61022270, -0.07619050, 5.61023030, -0.07619740, 326, 1, NULL, '2025-11-09 08:02:12', '2025-11-09 13:28:44'),
(77, 42, 11, '2025-11-09 08:05:57', '2025-11-09 13:24:28', 5.61023520, -0.07626570, 5.61022600, -0.07618850, 318, 1, NULL, '2025-11-09 08:05:57', '2025-11-09 13:24:28'),
(78, 14, 11, '2025-11-09 08:11:25', '2025-11-09 13:00:52', 5.61042880, -0.07645410, 5.61023120, -0.07620100, 289, 1, NULL, '2025-11-09 08:11:25', '2025-11-09 13:00:52'),
(79, 29, 11, '2025-11-09 08:12:44', '2025-11-09 13:54:50', 5.61018317, -0.07620409, 5.60993862, -0.07656314, 342, 1, NULL, '2025-11-09 08:12:44', '2025-11-09 13:54:50'),
(80, 16, 11, '2025-11-09 08:13:25', NULL, 5.60970888, -0.07581662, NULL, NULL, NULL, 1, NULL, '2025-11-09 08:13:25', '2025-11-09 08:13:25'),
(81, 24, 11, '2025-11-09 08:18:35', '2025-11-09 12:44:05', 5.61025760, -0.07640850, 5.61023850, -0.07620130, 265, 1, NULL, '2025-11-09 08:18:35', '2025-11-09 12:44:05'),
(82, 43, 11, '2025-11-09 08:18:36', '2025-11-09 12:34:27', 5.61015362, -0.07616492, 5.61005163, -0.07602953, 255, 1, NULL, '2025-11-09 08:18:36', '2025-11-09 12:34:27'),
(83, 23, 11, '2025-11-09 08:20:26', '2025-11-09 12:23:08', 5.61042940, -0.07652550, 5.61069520, -0.07650730, 242, 1, NULL, '2025-11-09 08:20:26', '2025-11-09 12:23:08'),
(84, 27, 11, '2025-11-09 08:21:05', NULL, 5.61043090, -0.07648610, NULL, NULL, NULL, 1, NULL, '2025-11-09 08:21:05', '2025-11-09 08:21:05'),
(85, 74, 11, '2025-11-09 08:24:16', NULL, 5.61031652, -0.07632102, NULL, NULL, NULL, 1, NULL, '2025-11-09 08:24:16', '2025-11-09 08:24:16'),
(86, 50, 11, '2025-11-09 08:25:07', NULL, 5.61025310, -0.07640650, NULL, NULL, NULL, 1, NULL, '2025-11-09 08:25:07', '2025-11-09 08:25:07'),
(87, 22, 11, '2025-11-09 08:27:47', '2025-11-09 08:27:53', 5.61048078, -0.07611714, 5.61040644, -0.07627757, 0, 0, NULL, '2025-11-09 08:27:47', '2025-11-09 08:27:53'),
(88, 77, 11, '2025-11-09 08:33:49', '2025-11-09 13:27:24', 5.61046462, -0.07635200, 5.61019926, -0.07623374, 293, 1, NULL, '2025-11-09 08:33:49', '2025-11-09 13:27:24'),
(89, 68, 11, '2025-11-09 08:35:06', NULL, 5.61047010, -0.07577920, NULL, NULL, NULL, 1, NULL, '2025-11-09 08:35:06', '2025-11-09 08:35:06'),
(90, 67, 11, '2025-11-09 08:35:21', '2025-11-09 13:27:42', 5.61034730, -0.07643570, 5.61023770, -0.07619760, 292, 1, NULL, '2025-11-09 08:35:21', '2025-11-09 13:27:42'),
(91, 79, 11, '2025-11-09 08:35:50', '2025-11-09 13:30:11', 5.61034530, -0.07636950, 5.61039400, -0.07639200, 294, 1, NULL, '2025-11-09 08:35:50', '2025-11-09 13:30:11'),
(92, 28, 11, '2025-11-09 08:35:51', '2025-11-09 13:20:50', 5.61011119, -0.07616890, 5.61020593, -0.07623877, 284, 1, NULL, '2025-11-09 08:35:51', '2025-11-09 13:20:50'),
(93, 19, 11, '2025-11-09 08:48:52', '2025-11-09 13:29:26', 5.61041640, -0.07646390, 5.61020910, -0.07625230, 280, 1, NULL, '2025-11-09 08:48:52', '2025-11-09 13:29:26'),
(94, 63, 11, '2025-11-09 08:51:31', '2025-11-09 13:30:56', 5.61054407, -0.07636749, 5.61045911, -0.07588726, 279, 1, NULL, '2025-11-09 08:51:31', '2025-11-09 13:30:56'),
(95, 26, 11, '2025-11-09 09:00:48', NULL, 5.61038520, -0.07640160, NULL, NULL, NULL, 1, NULL, '2025-11-09 09:00:48', '2025-11-09 09:00:48'),
(96, 81, 11, '2025-11-09 09:00:56', NULL, 5.61036110, -0.07596540, NULL, NULL, NULL, 1, NULL, '2025-11-09 09:00:56', '2025-11-09 09:00:56'),
(97, 36, 11, '2025-11-09 09:06:24', NULL, 5.61035776, -0.07648015, NULL, NULL, NULL, 1, NULL, '2025-11-09 09:06:24', '2025-11-09 09:06:24'),
(98, 12, 11, '2025-11-09 09:12:04', '2025-11-09 13:13:01', 5.61022550, -0.07618630, 5.61022530, -0.07618210, 240, 1, NULL, '2025-11-09 09:12:04', '2025-11-09 13:13:01'),
(99, 82, 11, '2025-11-09 09:19:31', NULL, 5.61021029, -0.07624489, NULL, NULL, NULL, 1, NULL, '2025-11-09 09:19:31', '2025-11-09 09:19:31'),
(100, 25, 11, '2025-11-09 09:40:05', NULL, 5.61031586, -0.07634724, NULL, NULL, NULL, 1, NULL, '2025-11-09 09:40:05', '2025-11-09 09:40:05'),
(101, 3, 11, '2025-11-09 10:40:15', '2025-11-09 13:29:28', 5.61018296, -0.07620862, 5.61012444, -0.07621939, 169, 1, NULL, '2025-11-09 10:40:15', '2025-11-09 13:29:28'),
(102, 13, 11, '2025-11-09 11:29:18', NULL, 5.61051390, -0.07601520, NULL, NULL, NULL, 1, NULL, '2025-11-09 11:29:18', '2025-11-09 11:29:18'),
(103, 38, 11, '2025-11-09 13:29:30', '2025-11-09 13:29:35', 5.61006715, -0.07606898, 5.60998276, -0.07611430, 0, 0, NULL, '2025-11-09 13:29:30', '2025-11-09 13:29:35'),
(104, 22, 12, '2025-11-10 05:52:49', NULL, 5.61049881, -0.07605445, NULL, NULL, NULL, 1, NULL, '2025-11-10 05:52:49', '2025-11-10 05:52:49'),
(105, 28, 12, '2025-11-10 05:57:31', NULL, 5.61016289, -0.07627915, NULL, NULL, NULL, 1, NULL, '2025-11-10 05:57:31', '2025-11-10 05:57:31'),
(106, 10, 12, '2025-11-10 06:00:10', '2025-11-10 07:16:59', 5.61018990, -0.07621308, 5.61032840, -0.07621556, 76, 1, NULL, '2025-11-10 06:00:10', '2025-11-10 07:16:59'),
(107, 2, 12, '2025-11-10 06:14:21', NULL, 5.61028680, -0.07624900, NULL, NULL, NULL, 1, NULL, '2025-11-10 06:14:21', '2025-11-10 06:14:21'),
(108, 12, 12, '2025-11-10 06:15:23', NULL, 5.61024210, -0.07625030, NULL, NULL, NULL, 1, NULL, '2025-11-10 06:15:23', '2025-11-10 06:15:23'),
(109, 23, 12, '2025-11-10 06:16:28', NULL, 5.61023720, -0.07620750, NULL, NULL, NULL, 1, NULL, '2025-11-10 06:16:28', '2025-11-10 06:16:28'),
(110, 41, 12, '2025-11-10 06:17:18', NULL, 5.61029830, -0.07633810, NULL, NULL, NULL, 1, NULL, '2025-11-10 06:17:18', '2025-11-10 06:17:18'),
(111, 18, 13, '2025-11-12 18:12:16', '2025-11-12 21:39:42', 5.61016606, -0.07599722, 5.61045124, -0.07627733, 207, 1, NULL, '2025-11-12 18:12:16', '2025-11-12 21:39:42'),
(112, 10, 13, '2025-11-12 18:15:00', NULL, 5.61035061, -0.07631610, NULL, NULL, NULL, 1, NULL, '2025-11-12 18:15:00', '2025-11-12 18:15:00'),
(113, 17, 13, '2025-11-12 18:25:20', NULL, 5.61028733, -0.07630459, NULL, NULL, NULL, 1, NULL, '2025-11-12 18:25:20', '2025-11-12 18:25:20'),
(114, 74, 13, '2025-11-12 18:26:50', '2025-11-12 21:44:47', 5.61045725, -0.07626913, 5.61042979, -0.07643888, 197, 1, NULL, '2025-11-12 18:26:50', '2025-11-12 21:44:47'),
(115, 41, 13, '2025-11-12 18:36:55', '2025-11-12 21:43:43', 5.61035030, -0.07651310, 5.61049540, -0.07596020, 186, 1, NULL, '2025-11-12 18:36:55', '2025-11-12 21:43:43'),
(116, 42, 13, '2025-11-12 18:37:53', '2025-11-12 21:44:08', 5.61038320, -0.07651480, 5.61050620, -0.07591050, 186, 1, NULL, '2025-11-12 18:37:53', '2025-11-12 21:44:08'),
(117, 60, 13, '2025-11-12 18:46:09', NULL, 5.61005783, -0.07604322, NULL, NULL, NULL, 1, NULL, '2025-11-12 18:46:09', '2025-11-12 18:46:09'),
(118, 28, 13, '2025-11-12 18:57:30', '2025-11-12 21:43:53', 5.61022285, -0.07620806, 5.61062487, -0.07598037, 166, 1, NULL, '2025-11-12 18:57:30', '2025-11-12 21:43:53'),
(119, 69, 13, '2025-11-12 18:59:01', NULL, 5.61024510, -0.07620820, NULL, NULL, NULL, 1, NULL, '2025-11-12 18:59:01', '2025-11-12 18:59:01'),
(120, 2, 13, '2025-11-12 19:05:43', '2025-11-12 21:36:41', 5.61025520, -0.07622470, 5.61021720, -0.07619920, 150, 1, NULL, '2025-11-12 19:05:43', '2025-11-12 21:36:41'),
(121, 22, 13, '2025-11-12 19:09:51', '2025-11-12 21:36:31', 5.61043108, -0.07625679, 5.61023297, -0.07624432, 146, 1, NULL, '2025-11-12 19:09:51', '2025-11-12 21:36:31'),
(122, 72, 13, '2025-11-12 19:11:23', NULL, 5.61014945, -0.07611951, NULL, NULL, NULL, 1, NULL, '2025-11-12 19:11:23', '2025-11-12 19:11:23'),
(123, 43, 13, '2025-11-12 19:13:27', NULL, 5.61052880, -0.07616926, NULL, NULL, NULL, 1, NULL, '2025-11-12 19:13:27', '2025-11-12 19:13:27'),
(124, 25, 13, '2025-11-12 19:26:39', '2025-11-12 21:44:02', 5.61031586, -0.07634724, 5.61044137, -0.07611214, 137, 1, NULL, '2025-11-12 19:26:39', '2025-11-12 21:44:02'),
(125, 26, 13, '2025-11-12 19:27:11', '2025-11-12 21:34:27', 5.61033690, -0.07647950, 5.61039140, -0.07647530, 127, 1, NULL, '2025-11-12 19:27:11', '2025-11-12 21:34:27'),
(126, 15, 13, '2025-11-12 19:31:09', '2025-11-12 21:33:46', 5.61031791, -0.07633346, 5.61029450, -0.07623279, 122, 1, NULL, '2025-11-12 19:31:09', '2025-11-12 21:33:46'),
(127, 68, 13, '2025-11-12 19:36:47', NULL, 5.61033130, -0.07643170, NULL, NULL, NULL, 1, NULL, '2025-11-12 19:36:47', '2025-11-12 19:36:47'),
(128, 51, 13, '2025-11-12 19:40:55', '2025-11-12 21:37:05', 5.61026958, -0.07625776, 5.61008196, -0.07626886, 116, 1, NULL, '2025-11-12 19:40:55', '2025-11-12 21:37:05'),
(129, 3, 13, '2025-11-12 20:07:35', '2025-11-12 21:37:20', 5.61028356, -0.07630083, 5.61028356, -0.07630083, 89, 1, NULL, '2025-11-12 20:07:35', '2025-11-12 21:37:20'),
(130, 83, 13, '2025-11-12 20:57:06', NULL, 5.61021621, -0.07622848, NULL, NULL, NULL, 1, NULL, '2025-11-12 20:57:06', '2025-11-12 20:57:06'),
(131, 45, 13, '2025-11-12 21:36:11', '2025-11-12 21:36:16', 5.61032120, -0.07630750, 5.61029240, -0.07626040, 0, 0, NULL, '2025-11-12 21:36:11', '2025-11-12 21:36:16'),
(132, 18, 14, '2025-11-14 17:52:35', '2025-11-12 21:36:16', 5.61051232, -0.07632220, 5.61029240, -0.07626040, NULL, 1, NULL, '2025-11-14 17:52:35', '2025-11-14 18:07:00'),
(133, 10, 14, '2025-11-14 17:55:13', NULL, 5.61030150, -0.07614250, NULL, NULL, NULL, 1, NULL, '2025-11-14 17:55:13', '2025-11-14 17:55:13'),
(134, 22, 14, '2025-11-14 18:07:43', NULL, 5.61005820, -0.07613802, NULL, NULL, NULL, 1, NULL, '2025-11-14 18:07:43', '2025-11-14 18:07:43'),
(135, 17, 14, '2025-11-14 18:30:41', NULL, 5.61026454, -0.07628843, NULL, NULL, NULL, 1, NULL, '2025-11-14 18:30:41', '2025-11-14 18:30:41'),
(136, 66, 14, '2025-11-14 18:35:45', NULL, 5.61023060, -0.07619450, NULL, NULL, NULL, 1, NULL, '2025-11-14 18:35:45', '2025-11-14 18:35:45'),
(137, 28, 14, '2025-11-14 18:41:17', NULL, 5.61058105, -0.07630800, NULL, NULL, NULL, 1, NULL, '2025-11-14 18:41:17', '2025-11-14 18:41:17'),
(138, 42, 14, '2025-11-14 18:49:09', NULL, 5.61029790, -0.07613940, NULL, NULL, NULL, 1, NULL, '2025-11-14 18:49:09', '2025-11-14 18:49:09'),
(139, 72, 14, '2025-11-14 18:57:52', NULL, 5.61014656, -0.07612065, NULL, NULL, NULL, 1, NULL, '2025-11-14 18:57:52', '2025-11-14 18:57:52'),
(140, 2, 14, '2025-11-14 18:59:26', NULL, 5.61029290, -0.07613860, NULL, NULL, NULL, 1, NULL, '2025-11-14 18:59:26', '2025-11-14 18:59:26'),
(141, 25, 14, '2025-11-14 19:04:03', NULL, 5.61038829, -0.07609484, NULL, NULL, NULL, 1, NULL, '2025-11-14 19:04:03', '2025-11-14 19:04:03'),
(142, 33, 14, '2025-11-14 19:05:23', NULL, 5.61040470, -0.07651020, NULL, NULL, NULL, 1, NULL, '2025-11-14 19:05:23', '2025-11-14 19:05:23'),
(143, 26, 14, '2025-11-14 19:13:42', NULL, 5.61030880, -0.07614310, NULL, NULL, NULL, 1, NULL, '2025-11-14 19:13:42', '2025-11-14 19:13:42'),
(144, 12, 14, '2025-11-14 19:15:40', NULL, 5.61029120, -0.07614840, NULL, NULL, NULL, 1, NULL, '2025-11-14 19:15:40', '2025-11-14 19:15:40'),
(145, 36, 14, '2025-11-14 19:30:57', NULL, 5.61015307, -0.07620663, NULL, NULL, NULL, 1, NULL, '2025-11-14 19:30:57', '2025-11-14 19:30:57'),
(146, 69, 14, '2025-11-14 19:43:17', '2025-11-14 22:26:28', 5.61022900, -0.07618840, 5.61022310, -0.07619700, 163, 1, NULL, '2025-11-14 19:43:17', '2025-11-14 22:26:28'),
(147, 43, 14, '2025-11-14 19:54:39', NULL, 5.61026156, -0.07623503, NULL, NULL, NULL, 1, NULL, '2025-11-14 19:54:39', '2025-11-14 19:54:39'),
(148, 71, 14, '2025-11-14 19:54:40', '2025-11-14 22:26:40', 5.61024330, -0.07617330, 5.61022610, -0.07620560, 152, 1, NULL, '2025-11-14 19:54:40', '2025-11-14 22:26:40'),
(149, 29, 14, '2025-11-14 19:58:22', NULL, 5.61028113, -0.07626543, NULL, NULL, NULL, 1, NULL, '2025-11-14 19:58:22', '2025-11-14 19:58:22'),
(150, 3, 14, '2025-11-14 20:04:33', NULL, 5.61024059, -0.07621198, NULL, NULL, NULL, 1, NULL, '2025-11-14 20:04:33', '2025-11-14 20:04:33'),
(151, 19, 14, '2025-11-14 20:14:00', NULL, 5.61025250, -0.07635950, NULL, NULL, NULL, 1, NULL, '2025-11-14 20:14:00', '2025-11-14 20:14:00'),
(152, 2, 15, '2025-11-16 07:22:33', NULL, 5.61022500, -0.07619820, NULL, NULL, NULL, 1, NULL, '2025-11-16 07:22:33', '2025-11-16 07:22:33'),
(153, 17, 15, '2025-11-16 07:27:03', '2025-11-16 12:25:52', 5.61005895, -0.07604615, 5.61026454, -0.07628843, 298, 1, NULL, '2025-11-16 07:27:03', '2025-11-16 12:25:52'),
(154, 10, 15, '2025-11-16 07:39:29', '2025-11-16 13:11:31', 5.61023640, -0.07621310, 5.61034658, -0.07622332, 332, 1, NULL, '2025-11-16 07:39:29', '2025-11-16 13:11:31'),
(155, 72, 15, '2025-11-16 07:45:10', NULL, 5.61012648, -0.07614310, NULL, NULL, NULL, 1, NULL, '2025-11-16 07:45:10', '2025-11-16 07:45:10'),
(156, 18, 15, '2025-11-16 07:47:53', '2025-11-16 13:19:24', 5.61068973, -0.07616365, 5.61006876, -0.07632105, 331, 1, NULL, '2025-11-16 07:47:53', '2025-11-16 13:19:24'),
(157, 3, 15, '2025-11-16 08:01:45', '2025-11-16 13:25:53', 5.61028316, -0.07626749, 5.61025763, -0.07623499, 324, 1, NULL, '2025-11-16 08:01:45', '2025-11-16 13:25:53'),
(158, 42, 15, '2025-11-16 08:08:38', NULL, 5.61033890, -0.07614130, NULL, NULL, NULL, 1, NULL, '2025-11-16 08:08:38', '2025-11-16 08:08:38'),
(159, 35, 15, '2025-11-16 08:13:15', NULL, 5.61050081, -0.07597170, NULL, NULL, NULL, 1, NULL, '2025-11-16 08:13:15', '2025-11-16 08:13:15'),
(160, 29, 15, '2025-11-16 08:14:58', NULL, 5.61026155, -0.07624504, NULL, NULL, NULL, 1, NULL, '2025-11-16 08:14:58', '2025-11-16 08:14:58'),
(161, 68, 15, '2025-11-16 08:20:14', '2025-11-16 12:37:23', 5.61048290, -0.07579280, 5.61044070, -0.07601710, 257, 1, NULL, '2025-11-16 08:20:14', '2025-11-16 12:37:23'),
(162, 84, 15, '2025-11-16 08:23:44', NULL, 5.61029200, -0.07613890, NULL, NULL, NULL, 1, NULL, '2025-11-16 08:23:44', '2025-11-16 08:23:44'),
(163, 41, 15, '2025-11-16 08:24:32', NULL, 5.61030660, -0.07614850, NULL, NULL, NULL, 1, NULL, '2025-11-16 08:24:32', '2025-11-16 08:24:32'),
(164, 23, 15, '2025-11-16 08:26:01', '2025-11-19 19:16:39', 5.61029060, -0.07614600, 5.61040660, -0.07615040, 650, 1, NULL, '2025-11-16 08:26:01', '2025-11-19 19:16:39'),
(165, 22, 15, '2025-11-16 08:26:39', NULL, 5.61041269, -0.07608855, NULL, NULL, NULL, 1, NULL, '2025-11-16 08:26:39', '2025-11-16 08:26:39'),
(166, 24, 15, '2025-11-16 08:30:59', '2025-11-16 12:31:11', 5.61028690, -0.07615420, 5.61029650, -0.07614170, 240, 1, NULL, '2025-11-16 08:30:59', '2025-11-16 12:31:11'),
(167, 77, 15, '2025-11-16 08:34:12', NULL, 5.61021674, -0.07626845, NULL, NULL, NULL, 1, NULL, '2025-11-16 08:34:12', '2025-11-16 08:34:12'),
(168, 38, 15, '2025-11-16 08:36:33', NULL, 5.61016834, -0.07623864, NULL, NULL, NULL, 1, NULL, '2025-11-16 08:36:33', '2025-11-16 08:36:33'),
(169, 59, 15, '2025-11-16 08:38:33', NULL, 5.61074160, -0.07638520, NULL, NULL, NULL, 1, NULL, '2025-11-16 08:38:33', '2025-11-16 08:38:33'),
(170, 12, 15, '2025-11-16 08:43:15', NULL, 5.61023000, -0.07619450, NULL, NULL, NULL, 1, NULL, '2025-11-16 08:43:15', '2025-11-16 08:43:15'),
(171, 26, 15, '2025-11-16 08:45:38', '2025-11-16 13:34:56', 5.61050880, -0.07607730, 5.61022400, -0.07620450, 289, 1, NULL, '2025-11-16 08:45:38', '2025-11-16 13:34:56'),
(172, 36, 15, '2025-11-16 08:49:49', '2025-11-16 12:28:17', 5.61026181, -0.07622134, 5.61013535, -0.07606274, 218, 1, NULL, '2025-11-16 08:49:49', '2025-11-16 12:28:17'),
(173, 25, 15, '2025-11-16 08:50:52', NULL, 5.61064733, -0.07635735, NULL, NULL, NULL, 1, NULL, '2025-11-16 08:50:52', '2025-11-16 08:50:52'),
(174, 28, 15, '2025-11-16 09:01:55', '2025-11-16 12:42:44', 5.61031704, -0.07610231, 5.60998497, -0.07622649, 220, 1, NULL, '2025-11-16 09:01:55', '2025-11-16 12:42:44'),
(175, 83, 15, '2025-11-16 09:03:11', '2025-11-16 09:03:16', 5.61039581, -0.07620973, 5.61039581, -0.07620973, 0, 0, NULL, '2025-11-16 09:03:11', '2025-11-16 09:03:16'),
(176, 43, 15, '2025-11-16 09:03:14', '2025-11-16 12:42:34', 5.61023734, -0.07620860, 5.61008186, -0.07606275, 219, 1, NULL, '2025-11-16 09:03:14', '2025-11-16 12:42:34'),
(177, 27, 15, '2025-11-16 09:12:17', NULL, 5.61031350, -0.07611130, NULL, NULL, NULL, 1, NULL, '2025-11-16 09:12:17', '2025-11-16 09:12:17'),
(178, 67, 15, '2025-11-16 09:19:40', '2025-11-16 12:32:33', 5.61022580, -0.07620690, 5.61028840, -0.07615000, 192, 1, NULL, '2025-11-16 09:19:40', '2025-11-16 12:32:33'),
(179, 69, 15, '2025-11-16 09:20:19', '2025-11-16 12:01:37', 5.61067330, -0.07573170, 5.61022480, -0.07620160, 161, 1, NULL, '2025-11-16 09:20:19', '2025-11-16 12:01:37'),
(180, 39, 15, '2025-11-16 09:25:19', NULL, 5.61024371, -0.07624926, NULL, NULL, NULL, 1, NULL, '2025-11-16 09:25:19', '2025-11-16 09:25:19'),
(181, 16, 15, '2025-11-16 09:28:19', NULL, 5.61033786, -0.07631628, NULL, NULL, NULL, 1, NULL, '2025-11-16 09:28:19', '2025-11-16 09:28:19'),
(182, 87, 15, '2025-11-16 09:40:07', NULL, 5.61003371, -0.07616833, NULL, NULL, NULL, 1, NULL, '2025-11-16 09:40:07', '2025-11-16 09:40:07'),
(183, 63, 15, '2025-11-16 09:44:50', '2025-11-16 12:36:54', 5.61018885, -0.07618218, 5.61040962, -0.07605152, 172, 1, NULL, '2025-11-16 09:44:50', '2025-11-16 12:36:54'),
(184, 19, 15, '2025-11-16 10:34:26', NULL, 5.61030110, -0.07613920, NULL, NULL, NULL, 1, NULL, '2025-11-16 10:34:26', '2025-11-16 10:34:26'),
(185, 45, 15, '2025-11-16 12:47:49', NULL, 5.61022520, -0.07619890, NULL, NULL, NULL, 1, NULL, '2025-11-16 12:47:49', '2025-11-16 12:47:49'),
(186, 88, 15, '2025-11-16 13:10:06', '2025-11-16 13:10:16', 5.61042540, -0.07652600, 5.61035370, -0.07651600, 0, 0, NULL, '2025-11-16 13:10:06', '2025-11-16 13:10:16'),
(187, 10, 16, '2025-11-19 18:02:06', NULL, 5.61021280, -0.07620630, NULL, NULL, NULL, 1, NULL, '2025-11-19 18:02:06', '2025-11-19 18:02:06'),
(188, 36, 16, '2025-11-19 18:27:52', '2025-11-19 21:53:57', 5.61031917, -0.07622159, 5.61028344, -0.07624561, 206, 1, NULL, '2025-11-19 18:27:52', '2025-11-19 21:53:57'),
(189, 88, 16, '2025-11-19 18:32:31', NULL, 5.61022010, -0.07627590, NULL, NULL, NULL, 1, NULL, '2025-11-19 18:32:31', '2025-11-19 18:32:31'),
(190, 72, 16, '2025-11-19 18:33:06', '2025-11-19 21:55:01', 5.61025250, -0.07618270, 5.61050090, -0.07604850, 201, 1, NULL, '2025-11-19 18:33:06', '2025-11-19 21:55:01'),
(191, 18, 16, '2025-11-19 18:35:32', NULL, 5.61088028, -0.07689718, NULL, NULL, NULL, 1, NULL, '2025-11-19 18:35:32', '2025-11-19 18:35:32'),
(192, 17, 16, '2025-11-19 18:40:46', NULL, 5.61031036, -0.07630634, NULL, NULL, NULL, 1, NULL, '2025-11-19 18:40:46', '2025-11-19 18:40:46'),
(193, 28, 16, '2025-11-19 18:45:25', NULL, 5.61041685, -0.07625295, NULL, NULL, NULL, 1, NULL, '2025-11-19 18:45:25', '2025-11-19 18:45:25'),
(194, 23, 16, '2025-11-19 18:57:29', '2025-11-19 22:01:35', 5.61046900, -0.07636000, 5.60981300, -0.07593400, 184, 1, NULL, '2025-11-19 18:57:29', '2025-11-19 22:01:35'),
(195, 39, 16, '2025-11-19 19:05:06', NULL, 5.61023641, -0.07635649, NULL, NULL, NULL, 1, NULL, '2025-11-19 19:05:06', '2025-11-19 19:05:06'),
(196, 16, 16, '2025-11-19 19:08:00', NULL, 5.61048311, -0.07641435, NULL, NULL, NULL, 1, NULL, '2025-11-19 19:08:00', '2025-11-19 19:08:00'),
(197, 41, 16, '2025-11-19 19:16:59', NULL, 5.61047190, -0.07626560, NULL, NULL, NULL, 1, NULL, '2025-11-19 19:16:59', '2025-11-19 19:16:59'),
(198, 42, 16, '2025-11-19 19:17:11', NULL, 5.61042160, -0.07621410, NULL, NULL, NULL, 1, NULL, '2025-11-19 19:17:11', '2025-11-19 19:17:11'),
(199, 26, 16, '2025-11-19 19:21:29', NULL, 5.61047390, -0.07599060, NULL, NULL, NULL, 1, NULL, '2025-11-19 19:21:29', '2025-11-19 19:21:29'),
(200, 22, 16, '2025-11-19 19:21:36', NULL, 5.61047507, -0.07617969, NULL, NULL, NULL, 1, NULL, '2025-11-19 19:21:36', '2025-11-19 19:21:36'),
(201, 29, 16, '2025-11-19 19:32:08', '2025-11-19 21:54:40', 5.61029307, -0.07628898, 5.61029426, -0.07626263, 142, 1, NULL, '2025-11-19 19:32:08', '2025-11-19 21:54:40'),
(202, 25, 16, '2025-11-19 19:33:31', NULL, 5.61031586, -0.07634724, NULL, NULL, NULL, 1, NULL, '2025-11-19 19:33:31', '2025-11-19 19:33:31'),
(203, 33, 16, '2025-11-19 19:37:06', NULL, 5.61022110, -0.07620420, NULL, NULL, NULL, 1, NULL, '2025-11-19 19:37:06', '2025-11-19 19:37:06'),
(204, 54, 16, '2025-11-19 19:43:04', NULL, 5.61030952, -0.07633108, NULL, NULL, NULL, 1, NULL, '2025-11-19 19:43:04', '2025-11-19 19:43:04'),
(205, 3, 16, '2025-11-19 20:00:38', NULL, 5.61027042, -0.07626683, NULL, NULL, NULL, 1, NULL, '2025-11-19 20:00:38', '2025-11-19 20:00:38'),
(206, 2, 16, '2025-11-19 20:03:56', NULL, 5.61050450, -0.07606000, NULL, NULL, NULL, 1, NULL, '2025-11-19 20:03:56', '2025-11-19 20:03:56'),
(207, 67, 16, '2025-11-19 20:04:57', '2025-11-19 21:54:48', 5.61021390, -0.07620740, 5.61031550, -0.07616740, 109, 1, NULL, '2025-11-19 20:04:57', '2025-11-19 21:54:48'),
(208, 88, 17, '2025-11-21 18:38:38', NULL, 5.61028580, -0.07626850, NULL, NULL, NULL, 1, NULL, '2025-11-21 18:38:38', '2025-11-21 18:38:38'),
(209, 35, 17, '2025-11-21 18:39:42', NULL, 5.61049563, -0.07633570, NULL, NULL, NULL, 1, NULL, '2025-11-21 18:39:42', '2025-11-21 18:39:42'),
(210, 18, 17, '2025-11-21 18:50:34', '2025-11-21 22:09:56', 5.61028478, -0.07638569, 5.61031481, -0.07612731, 199, 1, NULL, '2025-11-21 18:50:34', '2025-11-21 22:09:56'),
(211, 43, 17, '2025-11-21 18:51:14', '2025-11-21 22:11:26', 5.61056137, -0.07590637, 5.61008309, -0.07606237, 200, 1, NULL, '2025-11-21 18:51:14', '2025-11-21 22:11:26'),
(212, 72, 17, '2025-11-21 18:56:57', '2025-11-21 22:21:19', 5.61013689, -0.07613958, 5.61009110, -0.07610894, 204, 1, NULL, '2025-11-21 18:56:57', '2025-11-21 22:21:19'),
(213, 10, 17, '2025-11-21 19:07:21', NULL, 5.61046790, -0.07606520, NULL, NULL, NULL, 1, NULL, '2025-11-21 19:07:21', '2025-11-21 19:07:21'),
(214, 28, 17, '2025-11-21 19:07:34', NULL, 5.61024463, -0.07623815, NULL, NULL, NULL, 1, NULL, '2025-11-21 19:07:34', '2025-11-21 19:07:34'),
(215, 22, 17, '2025-11-21 19:08:10', '2025-11-21 19:08:11', 5.61057735, -0.07630899, 5.61031851, -0.07650228, 0, 0, NULL, '2025-11-21 19:08:10', '2025-11-21 19:08:11'),
(216, 16, 17, '2025-11-21 19:08:24', NULL, 5.61065634, -0.07605957, NULL, NULL, NULL, 1, NULL, '2025-11-21 19:08:24', '2025-11-21 19:08:24'),
(217, 42, 17, '2025-11-21 19:24:29', NULL, 5.61040780, -0.07633920, NULL, NULL, NULL, 1, NULL, '2025-11-21 19:24:29', '2025-11-21 19:24:29'),
(218, 26, 17, '2025-11-21 19:35:59', NULL, 5.61046570, -0.07637030, NULL, NULL, NULL, 1, NULL, '2025-11-21 19:35:59', '2025-11-21 19:35:59'),
(219, 29, 17, '2025-11-21 19:39:02', NULL, 5.61032307, -0.07621722, NULL, NULL, NULL, 1, NULL, '2025-11-21 19:39:02', '2025-11-21 19:39:02'),
(220, 39, 17, '2025-11-21 19:57:54', NULL, 5.61034792, -0.07612034, NULL, NULL, NULL, 1, NULL, '2025-11-21 19:57:54', '2025-11-21 19:57:54'),
(221, 24, 17, '2025-11-21 22:25:12', NULL, 5.61021480, -0.07620740, NULL, NULL, NULL, 1, NULL, '2025-11-21 22:25:12', '2025-11-21 22:25:12'),
(222, 17, 17, '2025-11-21 22:29:53', '2025-11-21 22:29:55', 5.61026454, -0.07628843, 5.61026454, -0.07628843, 0, 0, NULL, '2025-11-21 22:29:53', '2025-11-21 22:29:55'),
(223, 23, 18, '2025-11-23 08:12:22', NULL, 5.61045400, -0.07642200, NULL, NULL, NULL, 1, NULL, '2025-11-23 08:12:22', '2025-11-23 08:12:22'),
(224, 35, 18, '2025-11-23 08:12:32', NULL, 5.61073564, -0.07651664, NULL, NULL, NULL, 1, NULL, '2025-11-23 08:12:32', '2025-11-23 08:12:32'),
(225, 3, 18, '2025-11-23 08:15:13', '2025-11-23 12:39:58', 5.61055800, -0.07631941, 5.61056406, -0.07621330, 264, 1, NULL, '2025-11-23 08:15:13', '2025-11-23 12:39:58'),
(226, 16, 18, '2025-11-23 08:29:56', NULL, 5.61056938, -0.07615617, NULL, NULL, NULL, 1, NULL, '2025-11-23 08:29:56', '2025-11-23 08:29:56'),
(227, 29, 18, '2025-11-23 08:41:29', NULL, 5.61055851, -0.07631891, NULL, NULL, NULL, 1, NULL, '2025-11-23 08:41:29', '2025-11-23 08:41:29'),
(228, 59, 18, '2025-11-23 08:45:34', NULL, 5.61080230, -0.07599060, NULL, NULL, NULL, 1, NULL, '2025-11-23 08:45:34', '2025-11-23 08:45:34'),
(229, 22, 18, '2025-11-23 08:45:41', NULL, 5.61037532, -0.07646513, NULL, NULL, NULL, 1, NULL, '2025-11-23 08:45:41', '2025-11-23 08:45:41'),
(230, 68, 18, '2025-11-23 08:51:37', NULL, 5.61054140, -0.07588670, NULL, NULL, NULL, 1, NULL, '2025-11-23 08:51:37', '2025-11-23 08:51:37'),
(231, 18, 18, '2025-11-23 08:52:40', '2025-11-23 12:32:09', 5.61047623, -0.07676640, 5.61057219, -0.07649140, 219, 1, NULL, '2025-11-23 08:52:40', '2025-11-23 12:32:09'),
(232, 72, 18, '2025-11-23 08:53:30', '2025-11-23 12:33:21', 5.61032118, -0.07650839, 5.61043270, -0.07654300, 219, 1, NULL, '2025-11-23 08:53:30', '2025-11-23 12:33:21'),
(233, 25, 18, '2025-11-23 08:59:23', NULL, 5.61099080, -0.07658257, NULL, NULL, NULL, 1, NULL, '2025-11-23 08:59:23', '2025-11-23 08:59:23'),
(234, 36, 18, '2025-11-23 09:02:11', NULL, 5.61056756, -0.07634291, NULL, NULL, NULL, 1, NULL, '2025-11-23 09:02:11', '2025-11-23 09:02:11'),
(235, 88, 18, '2025-11-23 09:09:14', '2025-11-23 12:22:16', 5.61029800, -0.07622820, 5.61037880, -0.07653830, 193, 1, NULL, '2025-11-23 09:09:14', '2025-11-23 12:22:16'),
(236, 19, 18, '2025-11-23 09:21:32', NULL, 5.61032910, -0.07652470, NULL, NULL, NULL, 1, NULL, '2025-11-23 09:21:32', '2025-11-23 09:21:32'),
(237, 28, 18, '2025-11-23 09:32:27', NULL, 5.61030894, -0.07628606, NULL, NULL, NULL, 1, NULL, '2025-11-23 09:32:27', '2025-11-23 09:32:27'),
(238, 83, 18, '2025-11-23 10:22:16', '2025-11-23 12:32:05', 5.61039581, -0.07620973, 5.61052640, -0.07622011, 129, 1, NULL, '2025-11-23 10:22:16', '2025-11-23 12:32:05'),
(239, 77, 18, '2025-11-23 10:46:40', NULL, 5.61030798, -0.07650609, NULL, NULL, NULL, 1, NULL, '2025-11-23 10:46:40', '2025-11-23 10:46:40'),
(240, 84, 18, '2025-11-23 10:48:10', NULL, 5.61029960, -0.07650860, NULL, NULL, NULL, 1, NULL, '2025-11-23 10:48:10', '2025-11-23 10:48:10'),
(241, 67, 18, '2025-11-23 11:49:10', '2025-11-23 12:27:21', 5.61049150, -0.07606960, 5.61032320, -0.07653040, 38, 1, NULL, '2025-11-23 11:49:10', '2025-11-23 12:27:21'),
(242, 26, 18, '2025-11-23 11:58:22', '2025-11-23 12:23:06', 5.61038860, -0.07653970, 5.61036090, -0.07653630, 24, 0, NULL, '2025-11-23 11:58:22', '2025-11-23 12:23:06'),
(243, 24, 18, '2025-11-23 11:59:18', NULL, 5.61042200, -0.07654040, NULL, NULL, NULL, 1, NULL, '2025-11-23 11:59:18', '2025-11-23 11:59:18'),
(244, 10, 19, '2025-11-28 18:13:32', '2025-11-28 23:00:45', 5.61041680, -0.07653350, 5.61040830, -0.07651450, 287, 1, NULL, '2025-11-28 18:13:32', '2025-11-28 23:00:45'),
(245, 36, 19, '2025-11-28 18:30:14', '2025-11-28 18:30:43', 5.61029095, -0.07631694, 5.61027108, -0.07620001, 0, 0, NULL, '2025-11-28 18:30:14', '2025-11-28 18:30:43'),
(246, 17, 19, '2025-11-28 18:32:00', '2025-11-28 21:48:33', 5.61026543, -0.07627489, 5.61023581, -0.07623646, 196, 1, NULL, '2025-11-28 18:32:00', '2025-11-28 21:48:33'),
(247, 28, 19, '2025-11-28 18:47:02', NULL, 5.61020087, -0.07634383, NULL, NULL, NULL, 1, NULL, '2025-11-28 18:47:02', '2025-11-28 18:47:02'),
(248, 18, 19, '2025-11-28 18:50:14', '2025-11-28 20:07:48', 5.61037504, -0.07646695, 5.61012265, -0.07623016, 77, 1, NULL, '2025-11-28 18:50:14', '2025-11-28 20:07:48'),
(249, 51, 19, '2025-11-28 18:51:26', '2025-11-28 21:44:10', 5.61032236, -0.07598972, 5.61022640, -0.07628436, 172, 1, NULL, '2025-11-28 18:51:26', '2025-11-28 21:44:10'),
(250, 41, 19, '2025-11-28 19:00:08', NULL, 5.61048970, -0.07606220, NULL, NULL, NULL, 1, NULL, '2025-11-28 19:00:08', '2025-11-28 19:00:08'),
(251, 42, 19, '2025-11-28 19:00:22', '2025-11-30 08:05:04', 5.61050460, -0.07606710, 5.61020920, -0.07621870, 784, 1, NULL, '2025-11-28 19:00:22', '2025-11-30 08:05:04'),
(252, 43, 19, '2025-11-28 19:11:42', '2025-11-28 22:01:38', 5.61024167, -0.07623365, 5.61023682, -0.07622904, 169, 1, NULL, '2025-11-28 19:11:42', '2025-11-28 22:01:38'),
(253, 26, 19, '2025-11-28 19:26:06', NULL, 5.61029480, -0.07618870, NULL, NULL, NULL, 1, NULL, '2025-11-28 19:26:06', '2025-11-28 19:26:06'),
(254, 3, 19, '2025-11-28 19:51:04', '2025-11-28 22:41:33', 5.61021158, -0.07621410, 5.61021002, -0.07621267, 170, 1, NULL, '2025-11-28 19:51:04', '2025-11-28 22:41:33'),
(255, 67, 19, '2025-11-28 19:52:42', '2025-11-28 22:35:13', 5.61033230, -0.07612970, 5.61023280, -0.07618530, 162, 1, NULL, '2025-11-28 19:52:42', '2025-11-28 22:35:13'),
(256, 35, 19, '2025-11-28 20:37:35', NULL, 5.61040724, -0.07630818, NULL, NULL, NULL, 1, NULL, '2025-11-28 20:37:35', '2025-11-28 20:37:35'),
(257, 13, 19, '2025-11-28 23:01:32', '2025-11-28 23:01:34', 5.61036862, -0.07622341, 5.61036812, -0.07622233, 0, 0, NULL, '2025-11-28 23:01:32', '2025-11-28 23:01:34'),
(258, 17, 20, '2025-11-30 07:01:46', NULL, 5.61024247, -0.07625598, NULL, NULL, NULL, 1, NULL, '2025-11-30 07:01:46', '2025-11-30 07:01:46'),
(259, 10, 20, '2025-11-30 07:39:00', NULL, 5.61041610, -0.07653310, NULL, NULL, NULL, 1, NULL, '2025-11-30 07:39:00', '2025-11-30 07:39:00'),
(260, 22, 20, '2025-11-30 07:57:01', NULL, 5.61033623, -0.07635169, NULL, NULL, NULL, 1, NULL, '2025-11-30 07:57:01', '2025-11-30 07:57:01'),
(261, 23, 20, '2025-11-30 07:58:28', '2025-11-30 13:11:02', 5.61053800, -0.07632300, 5.61018600, -0.07607800, 312, 1, NULL, '2025-11-30 07:58:28', '2025-11-30 13:11:02'),
(262, 42, 20, '2025-11-30 08:06:05', '2025-11-30 13:22:58', 5.61033780, -0.07644150, 5.61041790, -0.07653320, 316, 1, NULL, '2025-11-30 08:06:05', '2025-11-30 13:22:58'),
(263, 41, 20, '2025-11-30 08:06:18', '2025-11-30 13:22:45', 5.61022530, -0.07624600, 5.61040930, -0.07653140, 316, 1, NULL, '2025-11-30 08:06:18', '2025-11-30 13:22:45'),
(264, 60, 20, '2025-11-30 08:10:02', NULL, 5.61001586, -0.07600339, NULL, NULL, NULL, 1, NULL, '2025-11-30 08:10:02', '2025-11-30 08:10:02'),
(265, 35, 20, '2025-11-30 08:16:38', '2025-11-30 12:52:09', 5.61055791, -0.07635180, 5.61040724, -0.07630818, 275, 1, NULL, '2025-11-30 08:16:38', '2025-11-30 12:52:09'),
(266, 2, 20, '2025-11-30 08:22:10', '2025-11-30 13:18:38', 5.61021010, -0.07620910, 5.61023350, -0.07623560, 296, 1, NULL, '2025-11-30 08:22:10', '2025-11-30 13:18:38'),
(267, 43, 20, '2025-11-30 08:22:25', NULL, 5.61035207, -0.07635075, NULL, NULL, NULL, 1, NULL, '2025-11-30 08:22:25', '2025-11-30 08:22:25'),
(268, 54, 20, '2025-11-30 08:22:33', NULL, 5.61030952, -0.07633108, NULL, NULL, NULL, 1, NULL, '2025-11-30 08:22:33', '2025-11-30 08:22:33'),
(269, 18, 20, '2025-11-30 08:24:47', NULL, 5.61030143, -0.07637755, NULL, NULL, NULL, 1, NULL, '2025-11-30 08:24:47', '2025-11-30 08:24:47'),
(270, 3, 20, '2025-11-30 08:26:01', '2025-11-30 13:00:06', 5.61054897, -0.07591837, 5.61021065, -0.07619513, 274, 1, NULL, '2025-11-30 08:26:01', '2025-11-30 13:00:06'),
(271, 19, 20, '2025-11-30 08:26:09', NULL, 5.61024610, -0.07622510, NULL, NULL, NULL, 1, NULL, '2025-11-30 08:26:09', '2025-11-30 08:26:09'),
(272, 52, 20, '2025-11-30 08:29:37', NULL, 5.61025300, -0.07622140, NULL, NULL, NULL, 1, NULL, '2025-11-30 08:29:37', '2025-11-30 08:29:37'),
(273, 67, 20, '2025-11-30 08:31:46', NULL, 5.61022170, -0.07621230, NULL, NULL, NULL, 1, NULL, '2025-11-30 08:31:46', '2025-11-30 08:31:46'),
(274, 45, 20, '2025-11-30 08:34:14', '2025-11-30 13:09:52', 5.61024890, -0.07621820, 5.61021460, -0.07620770, 275, 1, NULL, '2025-11-30 08:34:14', '2025-11-30 13:09:52'),
(275, 59, 20, '2025-11-30 08:37:29', '2025-11-30 12:52:28', 5.61052900, -0.07644190, 5.61045240, -0.07634670, 254, 1, NULL, '2025-11-30 08:37:29', '2025-11-30 12:52:28'),
(276, 77, 20, '2025-11-30 08:45:04', NULL, 5.61019122, -0.07629433, NULL, NULL, NULL, 1, NULL, '2025-11-30 08:45:04', '2025-11-30 08:45:04'),
(277, 24, 20, '2025-11-30 08:47:03', '2025-11-30 14:42:52', 5.61037240, -0.07649280, 5.61092540, -0.07646810, 355, 1, NULL, '2025-11-30 08:47:03', '2025-11-30 14:42:52'),
(278, 68, 20, '2025-11-30 08:48:31', NULL, 5.61047390, -0.07569860, NULL, NULL, NULL, 1, NULL, '2025-11-30 08:48:31', '2025-11-30 08:48:31'),
(279, 36, 20, '2025-11-30 08:59:56', '2025-11-30 12:52:16', 5.61031245, -0.07627317, 5.61065008, -0.07629271, 232, 1, NULL, '2025-11-30 08:59:56', '2025-11-30 12:52:16'),
(280, 26, 20, '2025-11-30 09:07:53', NULL, 5.61048020, -0.07656850, NULL, NULL, NULL, 1, NULL, '2025-11-30 09:07:53', '2025-11-30 09:07:53'),
(281, 83, 20, '2025-11-30 09:12:42', '2025-11-30 13:19:01', 5.61052850, -0.07588993, 5.61024462, -0.07621556, 246, 1, NULL, '2025-11-30 09:12:42', '2025-11-30 13:19:01'),
(282, 28, 20, '2025-11-30 09:20:04', NULL, 5.61055723, -0.07618154, NULL, NULL, NULL, 1, NULL, '2025-11-30 09:20:04', '2025-11-30 09:20:04'),
(283, 39, 20, '2025-11-30 09:23:48', NULL, 5.61097641, -0.07647665, NULL, NULL, NULL, 1, NULL, '2025-11-30 09:23:48', '2025-11-30 09:23:48'),
(284, 36, 21, '2025-12-02 17:55:26', NULL, 5.61007756, -0.07602971, NULL, NULL, NULL, 1, NULL, '2025-12-02 17:55:26', '2025-12-02 17:55:26'),
(285, 2, 21, '2025-12-02 18:44:11', '2025-12-02 20:37:55', 5.61015910, -0.07598780, 5.61020880, -0.07621300, 113, 1, NULL, '2025-12-02 18:44:11', '2025-12-02 20:37:55');

-- --------------------------------------------------------

--
-- Table structure for table `certificates`
--

CREATE TABLE `certificates` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `service_template_id` int(11) NOT NULL,
  `certificate_number` varchar(50) NOT NULL,
  `attendances_completed` int(11) NOT NULL,
  `attendances_required` int(11) NOT NULL,
  `issue_date` date NOT NULL,
  `certificate_url` varchar(255) DEFAULT NULL,
  `is_downloaded` tinyint(1) DEFAULT 0,
  `first_downloaded_at` datetime DEFAULT NULL,
  `download_count` int(11) DEFAULT 0,
  `issued_by` int(11) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` text DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `departments`
--

INSERT INTO `departments` (`id`, `name`, `description`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Media', 'Handles all media-related activities including audio, video, and live streaming.', 1, '2025-10-29 19:17:37', '2025-10-29 19:17:37'),
(2, 'Ushers', 'Responsible for welcoming and seating attendees during services.', 1, '2025-10-29 19:17:37', '2025-10-29 19:17:37'),
(3, 'Welfare', 'Provides support and assistance to members in need.', 1, '2025-10-29 19:17:37', '2025-10-29 19:17:37'),
(4, 'Protocol', 'Ensures proper conduct and procedures during church events.', 1, '2025-10-29 19:17:37', '2025-10-29 19:17:37'),
(5, 'Music', 'Leads worship and music during services.', 1, '2025-10-29 19:17:37', '2025-10-29 19:17:37'),
(6, 'Finance', 'Manages the church financial resources and budgeting.', 1, '2025-10-29 19:17:37', '2025-10-29 19:17:37'),
(7, 'Administration', 'Oversees the administrative functions of the church.', 1, '2025-10-29 19:17:37', '2025-10-29 19:17:37'),
(8, 'Hospitality', 'Coordinates hospitality services including refreshments and meals.', 1, '2025-10-29 19:17:37', '2025-10-29 19:17:37'),
(9, 'Outreach', 'Organizes community outreach and evangelism programs.', 1, '2025-10-29 19:17:37', '2025-10-29 19:17:37'),
(10, 'Children', 'Focuses on programs and activities for children.', 1, '2025-10-29 19:17:37', '2025-10-29 19:17:37'),
(11, 'Youth', 'Engages and supports the youth members of the church.', 1, '2025-10-29 19:17:37', '2025-10-29 19:17:37'),
(12, 'Tech', 'Manages technical equipment and IT infrastructure.', 1, '2025-10-29 19:17:37', '2025-10-29 19:17:37'),
(13, 'Security', 'Ensures the safety and security of church members and property.', 1, '2025-10-29 19:17:37', '2025-10-29 19:17:37'),
(14, 'Cleaning', 'Maintains cleanliness and hygiene within church premises.', 1, '2025-10-29 19:17:37', '2025-10-29 19:17:37'),
(15, 'Maintenance', 'Handles repairs and upkeep of church facilities.', 1, '2025-10-29 19:17:37', '2025-10-29 19:17:37'),
(16, 'Parking', 'Manages parking arrangements during church events.', 1, '2025-10-29 19:17:37', '2025-10-29 19:17:37'),
(17, 'Counseling', 'Provides counseling services to members in need.', 1, '2025-10-29 19:17:37', '2025-10-29 19:17:37'),
(18, 'Prayer', 'Leads prayer sessions and spiritual support.', 1, '2025-10-29 19:17:37', '2025-10-29 19:17:37'),
(19, 'Evangelism', 'Focuses on spreading the gospel and church growth.', 1, '2025-10-29 19:17:37', '2025-10-29 19:17:37'),
(20, 'Pastors', 'Pastors', 1, '2025-11-02 01:34:34', '2025-11-02 01:34:34'),
(21, 'Coordinators', 'Coordinating', 1, '2025-11-02 08:09:39', '2025-11-02 13:24:18'),
(22, 'Receivers', 'Receivers', 1, '2025-11-09 08:18:58', '2025-11-09 08:18:58');

-- --------------------------------------------------------

--
-- Table structure for table `rewards`
--

CREATE TABLE `rewards` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `reward_type_id` int(11) NOT NULL,
  `certificate_template` text DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `reward_types`
--

CREATE TABLE `reward_types` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `description` text DEFAULT NULL,
  `requires_certificate` tinyint(1) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `reward_types`
--

INSERT INTO `reward_types` (`id`, `name`, `description`, `requires_certificate`, `created_at`) VALUES
(1, 'Physical Item', 'Tangible rewards like books, gifts, etc.', 0, '2025-10-29 19:17:37'),
(2, 'Meeting', 'One-on-one or group meeting with Senior Pastor', 0, '2025-10-29 19:17:37'),
(3, 'Travel', 'Travel opportunities or trips', 0, '2025-10-29 19:17:37'),
(4, 'Physical Certificate', 'Printed certificate of achievement', 1, '2025-10-29 19:17:37'),
(5, 'Digital Certificate', 'Downloadable digital certificate', 1, '2025-10-29 19:17:37'),
(6, 'Recognition', 'Public recognition or appreciation', 0, '2025-10-29 19:17:37'),
(7, 'Cash Prize', 'Monetary rewards or gift cards', 0, '2025-10-29 19:17:37');

-- --------------------------------------------------------

--
-- Table structure for table `service_occurrences`
--

CREATE TABLE `service_occurrences` (
  `id` int(11) NOT NULL,
  `service_template_id` int(11) NOT NULL,
  `occurrence_date` date NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime NOT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `was_cancelled` tinyint(1) DEFAULT 0,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `service_occurrences`
--

INSERT INTO `service_occurrences` (`id`, `service_template_id`, `occurrence_date`, `start_time`, `end_time`, `is_active`, `was_cancelled`, `notes`, `created_at`) VALUES
(1, 1, '2025-10-29', '2025-10-29 19:00:00', '2025-10-29 22:30:00', 1, 0, '', '2025-10-29 19:31:27'),
(5, 2, '2025-11-02', '2025-11-02 07:30:00', '2025-11-02 13:30:00', 1, 0, '', '2025-11-01 19:51:28'),
(6, 2, '2025-11-01', '2025-11-01 23:00:00', '2025-11-01 23:30:00', 1, 0, '', '2025-11-01 22:22:41'),
(7, 3, '2025-11-03', '2025-11-03 06:00:00', '2025-11-03 07:00:00', 1, 0, '', '2025-11-03 06:15:05'),
(9, 1, '2025-11-05', '2025-11-05 19:00:00', '2025-11-05 21:30:00', 1, 0, '', '2025-11-05 10:31:45'),
(10, 4, '2025-11-07', '2025-11-07 18:30:00', '2025-11-07 21:30:00', 1, 0, '', '2025-11-07 09:40:17'),
(11, 2, '2025-11-09', '2025-11-09 07:30:00', '2025-11-09 13:30:00', 1, 0, '', '2025-11-09 06:30:57'),
(12, 3, '2025-11-10', '2025-11-10 06:00:00', '2025-11-10 07:00:00', 1, 0, '', '2025-11-10 05:38:44'),
(13, 1, '2025-11-12', '2025-11-12 19:00:00', '2025-11-12 21:30:00', 1, 0, '', '2025-11-12 15:31:03'),
(14, 4, '2025-11-14', '2025-11-14 18:30:00', '2025-11-14 21:30:00', 1, 0, '', '2025-11-14 17:47:10'),
(15, 2, '2025-11-16', '2025-11-16 07:30:00', '2025-11-16 13:30:00', 1, 0, '', '2025-11-16 07:13:28'),
(16, 1, '2025-11-19', '2025-11-19 19:00:00', '2025-11-19 21:30:00', 1, 0, '', '2025-11-19 09:31:00'),
(17, 4, '2025-11-21', '2025-11-21 18:30:00', '2025-11-21 21:30:00', 1, 0, '', '2025-11-21 18:11:11'),
(18, 2, '2025-11-23', '2025-11-23 07:30:00', '2025-11-23 13:30:00', 1, 0, '', '2025-11-23 08:11:41'),
(19, 4, '2025-11-28', '2025-11-28 18:30:00', '2025-11-28 22:30:00', 1, 0, '', '2025-11-28 16:04:42'),
(20, 2, '2025-11-30', '2025-11-30 07:30:00', '2025-11-30 13:30:00', 1, 0, '', '2025-11-30 07:01:34'),
(21, 6, '2025-12-02', '2025-12-02 18:30:00', '2025-12-02 21:30:00', 1, 0, '', '2025-12-02 17:24:49'),
(22, 6, '2025-12-03', '2025-12-03 18:30:00', '2025-12-03 20:30:00', 1, 0, '', '2025-12-03 17:00:36');

-- --------------------------------------------------------

--
-- Table structure for table `service_rewards`
--

CREATE TABLE `service_rewards` (
  `id` int(11) NOT NULL,
  `service_template_id` int(11) NOT NULL,
  `reward_id` int(11) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `qr_code` varchar(255) DEFAULT NULL,
  `attendance_required` int(11) DEFAULT 1,
  `description` text DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `service_templates`
--

CREATE TABLE `service_templates` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `service_type_id` int(11) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `latitude` decimal(10,8) DEFAULT NULL,
  `longitude` decimal(11,8) DEFAULT NULL,
  `geofence_radius` int(11) DEFAULT 100,
  `is_recurring` tinyint(1) DEFAULT 0,
  `recurrence_pattern` enum('daily','weekly','monthly','none') DEFAULT 'none',
  `recurrence_interval` int(11) DEFAULT 1,
  `recurrence_days` set('Sunday','Monday','Tuesday','Wednesday','Thursday','Friday','Saturday') DEFAULT NULL,
  `recurrence_start_date` date DEFAULT NULL,
  `recurrence_end_date` date DEFAULT NULL,
  `default_start_time` time DEFAULT NULL,
  `default_end_time` time DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `service_templates`
--

INSERT INTO `service_templates` (`id`, `name`, `description`, `service_type_id`, `location`, `latitude`, `longitude`, `geofence_radius`, `is_recurring`, `recurrence_pattern`, `recurrence_interval`, `recurrence_days`, `recurrence_start_date`, `recurrence_end_date`, `default_start_time`, `default_end_time`, `is_active`) VALUES
(1, 'Workforce Service', 'Workforce Service', 5, 'Royal Ravico Hotel', 5.61025600, -0.07642900, 100, 1, 'weekly', 1, 'Wednesday', '2025-11-05', '2039-11-05', '19:00:00', '21:30:00', 1),
(2, 'Dominion Encounter Service', 'Dominion Encounter Service', 1, 'Royal Ravico Hotel', 5.61025600, -0.07642900, 100, 1, 'weekly', 1, 'Sunday', NULL, NULL, '07:30:00', '13:30:00', 1),
(3, 'Commanding The Week', 'Commanding The Week', 1, 'Royal Ravico Hotel', 5.61025600, -0.07642900, 100, 1, 'weekly', 1, 'Monday', NULL, NULL, '06:00:00', '07:00:00', 1),
(4, 'Prophetic & Miracle Service', 'Prophetic & Miracle Service', 1, 'Royal Ravico Hotel ', 5.61025600, -0.07642900, 100, 1, 'weekly', 1, 'Friday', NULL, NULL, '18:30:00', '21:30:00', 1),
(5, 'Singles & Couples Summit', 'Singles & Couples Summit', 2, 'Royal Ravico Hotel', 5.61028900, -0.07631500, 100, 0, 'none', 1, NULL, NULL, NULL, NULL, NULL, 1),
(6, '7 DAYS OF FASTING & PRAYERS', '7 DAYS OF FASTING & PRAYERS', 4, 'Royal Ravico Hotel ', 5.61028900, -0.07631500, 100, 1, 'daily', 1, NULL, '2025-12-02', '2025-12-06', '18:30:00', '21:30:00', 1);

-- --------------------------------------------------------

--
-- Table structure for table `service_types`
--

CREATE TABLE `service_types` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `description` text DEFAULT NULL,
  `allows_delegates` tinyint(1) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `service_types`
--

INSERT INTO `service_types` (`id`, `name`, `description`, `allows_delegates`, `created_at`) VALUES
(1, 'Regular Service', 'Standard weekly church services', 0, '2025-10-29 19:17:37'),
(2, 'Conference', 'Special conference events', 1, '2025-10-29 19:17:37'),
(3, 'Training', 'Training and development programs', 1, '2025-10-29 19:17:37'),
(4, 'Special Event', 'Other special church events', 1, '2025-10-29 19:17:37'),
(5, 'Midweek Service', 'Midweek services and prayer meetings', 0, '2025-10-29 19:17:37');

-- --------------------------------------------------------

--
-- Table structure for table `tickets`
--

CREATE TABLE `tickets` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `issued_by` int(11) NOT NULL,
  `ticket_type` enum('warning','violation','misconduct','absence') DEFAULT 'warning',
  `reason` text NOT NULL,
  `severity` enum('low','medium','high') DEFAULT 'medium',
  `issued_at` datetime DEFAULT current_timestamp(),
  `is_resolved` tinyint(1) DEFAULT 0,
  `resolved_at` datetime DEFAULT NULL,
  `resolved_by` int(11) DEFAULT NULL,
  `resolution_notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `users_service_rewards`
--

CREATE TABLE `users_service_rewards` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `service_reward_id` int(11) NOT NULL,
  `attendance_count` int(11) DEFAULT 0,
  `rewards_earned` int(11) DEFAULT 0,
  `last_attendance_date` datetime DEFAULT NULL,
  `is_redeemed` tinyint(1) DEFAULT 0,
  `redeemed_at` datetime DEFAULT NULL,
  `redeemed_by` int(11) DEFAULT NULL,
  `redemption_notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `user_roles`
--

CREATE TABLE `user_roles` (
  `id` int(11) NOT NULL,
  `role_name` varchar(50) NOT NULL,
  `role_description` text DEFAULT NULL,
  `role_level` int(11) NOT NULL,
  `can_clock_in` tinyint(1) DEFAULT 1,
  `can_view_own_attendance` tinyint(1) DEFAULT 1,
  `can_view_department_attendance` tinyint(1) DEFAULT 0,
  `can_issue_tickets` tinyint(1) DEFAULT 0,
  `can_resolve_tickets` tinyint(1) DEFAULT 0,
  `can_manage_users` tinyint(1) DEFAULT 0,
  `can_manage_services` tinyint(1) DEFAULT 0,
  `can_manage_rewards` tinyint(1) DEFAULT 0,
  `can_generate_reports` tinyint(1) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_roles`
--

INSERT INTO `user_roles` (`id`, `role_name`, `role_description`, `role_level`, `can_clock_in`, `can_view_own_attendance`, `can_view_department_attendance`, `can_issue_tickets`, `can_resolve_tickets`, `can_manage_users`, `can_manage_services`, `can_manage_rewards`, `can_generate_reports`, `created_at`, `updated_at`) VALUES
(1, 'delegate', 'Conference/Training attendee with limited access', 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, '2025-10-29 19:17:37', '2025-10-29 19:17:37'),
(2, 'worker', 'Regular church worker', 2, 1, 1, 0, 0, 0, 0, 0, 0, 0, '2025-10-29 19:17:37', '2025-10-29 19:17:37'),
(3, 'hod', 'Head of Department with supervisory privileges', 3, 1, 1, 1, 1, 1, 0, 0, 0, 1, '2025-10-29 19:17:37', '2025-10-29 19:17:37'),
(4, 'admin', 'Administrator with full management access', 4, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2025-10-29 19:17:37', '2025-10-29 19:17:37'),
(5, 'superadmin', 'Super Administrator with system-wide access', 5, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2025-10-29 19:17:37', '2025-10-29 19:17:37');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admin_logs`
--
ALTER TABLE `admin_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_admin_logs_admin_id` (`admin_id`),
  ADD KEY `idx_admin_logs_action_type` (`action_type`),
  ADD KEY `idx_admin_logs_target_type` (`target_type`),
  ADD KEY `idx_admin_logs_created_at` (`created_at`);

--
-- Indexes for table `attendance`
--
ALTER TABLE `attendance`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_user_service_attendance` (`user_id`,`service_occurrence_id`,`clock_in_time`),
  ADD KEY `idx_attendance_user_id` (`user_id`),
  ADD KEY `idx_attendance_service_occurrence_id` (`service_occurrence_id`),
  ADD KEY `idx_attendance_clock_in_time` (`clock_in_time`),
  ADD KEY `idx_attendance_is_valid` (`is_valid`);

--
-- Indexes for table `certificates`
--
ALTER TABLE `certificates`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `certificate_number` (`certificate_number`),
  ADD UNIQUE KEY `unique_user_service_certificate` (`user_id`,`service_template_id`),
  ADD KEY `fk_certificates_admin_users` (`issued_by`),
  ADD KEY `idx_certificates_user_id` (`user_id`),
  ADD KEY `idx_certificates_service_template_id` (`service_template_id`),
  ADD KEY `idx_certificates_certificate_number` (`certificate_number`),
  ADD KEY `idx_certificates_issue_date` (`issue_date`);

--
-- Indexes for table `departments`
--
ALTER TABLE `departments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`),
  ADD KEY `idx_departments_name` (`name`),
  ADD KEY `idx_departments_is_active` (`is_active`);

--
-- Indexes for table `rewards`
--
ALTER TABLE `rewards`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_rewards_name` (`name`),
  ADD KEY `idx_rewards_type` (`reward_type_id`),
  ADD KEY `idx_rewards_is_active` (`is_active`);

--
-- Indexes for table `reward_types`
--
ALTER TABLE `reward_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`),
  ADD KEY `idx_reward_types_name` (`name`);

--
-- Indexes for table `service_occurrences`
--
ALTER TABLE `service_occurrences`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_service_occurrence` (`service_template_id`,`occurrence_date`);

--
-- Indexes for table `service_rewards`
--
ALTER TABLE `service_rewards`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_service_rewards_service_template_id` (`service_template_id`),
  ADD KEY `idx_service_rewards_reward_id` (`reward_id`),
  ADD KEY `idx_service_rewards_start_date` (`start_date`),
  ADD KEY `idx_service_rewards_is_active` (`is_active`);

--
-- Indexes for table `service_templates`
--
ALTER TABLE `service_templates`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_service_templates_service_types` (`service_type_id`),
  ADD KEY `idx_service_templates_name` (`name`),
  ADD KEY `idx_service_templates_is_active` (`is_active`);

--
-- Indexes for table `service_types`
--
ALTER TABLE `service_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`),
  ADD KEY `idx_service_types_name` (`name`);

--
-- Indexes for table `tickets`
--
ALTER TABLE `tickets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_tickets_users_resolved` (`resolved_by`),
  ADD KEY `idx_tickets_user_id` (`user_id`),
  ADD KEY `idx_tickets_issued_by` (`issued_by`),
  ADD KEY `idx_tickets_is_resolved` (`is_resolved`),
  ADD KEY `idx_tickets_severity` (`severity`),
  ADD KEY `idx_tickets_issued_at` (`issued_at`);

--
-- Indexes for table `users_service_rewards`
--
ALTER TABLE `users_service_rewards`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_user_service_reward` (`user_id`,`service_reward_id`),
  ADD KEY `fk_users_service_rewards_service_rewards` (`service_reward_id`),
  ADD KEY `fk_users_service_rewards_admin_users` (`redeemed_by`),
  ADD KEY `idx_users_service_rewards_user_id` (`user_id`),
  ADD KEY `idx_users_service_rewards_attendance_count` (`attendance_count`),
  ADD KEY `idx_users_service_rewards_is_redeemed` (`is_redeemed`);

--
-- Indexes for table `user_roles`
--
ALTER TABLE `user_roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `role_name` (`role_name`),
  ADD KEY `idx_user_roles_role_name` (`role_name`),
  ADD KEY `idx_user_roles_role_level` (`role_level`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin_logs`
--
ALTER TABLE `admin_logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `attendance`
--
ALTER TABLE `attendance`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=286;

--
-- AUTO_INCREMENT for table `certificates`
--
ALTER TABLE `certificates`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `departments`
--
ALTER TABLE `departments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `rewards`
--
ALTER TABLE `rewards`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `reward_types`
--
ALTER TABLE `reward_types`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `service_occurrences`
--
ALTER TABLE `service_occurrences`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `service_rewards`
--
ALTER TABLE `service_rewards`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `service_templates`
--
ALTER TABLE `service_templates`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `service_types`
--
ALTER TABLE `service_types`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tickets`
--
ALTER TABLE `tickets`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users_service_rewards`
--
ALTER TABLE `users_service_rewards`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_roles`
--
ALTER TABLE `user_roles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `admin_logs`
--
ALTER TABLE `admin_logs`
  ADD CONSTRAINT `fk_admin_logs_users` FOREIGN KEY (`admin_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `attendance`
--
ALTER TABLE `attendance`
  ADD CONSTRAINT `fk_attendance_service_occurrences` FOREIGN KEY (`service_occurrence_id`) REFERENCES `service_occurrences` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_attendance_users` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `certificates`
--
ALTER TABLE `certificates`
  ADD CONSTRAINT `fk_certificates_admin_users` FOREIGN KEY (`issued_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_certificates_service_templates` FOREIGN KEY (`service_template_id`) REFERENCES `service_templates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_certificates_users` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `rewards`
--
ALTER TABLE `rewards`
  ADD CONSTRAINT `fk_rewards_reward_types` FOREIGN KEY (`reward_type_id`) REFERENCES `reward_types` (`id`) ON UPDATE CASCADE;

--
-- Constraints for table `service_occurrences`
--
ALTER TABLE `service_occurrences`
  ADD CONSTRAINT `fk_service_occurrences_service_templates` FOREIGN KEY (`service_template_id`) REFERENCES `service_templates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `service_rewards`
--
ALTER TABLE `service_rewards`
  ADD CONSTRAINT `fk_service_rewards_rewards` FOREIGN KEY (`reward_id`) REFERENCES `rewards` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_service_rewards_service_templates` FOREIGN KEY (`service_template_id`) REFERENCES `service_templates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `service_templates`
--
ALTER TABLE `service_templates`
  ADD CONSTRAINT `fk_service_templates_service_types` FOREIGN KEY (`service_type_id`) REFERENCES `service_types` (`id`) ON UPDATE CASCADE;

--
-- Constraints for table `tickets`
--
ALTER TABLE `tickets`
  ADD CONSTRAINT `fk_tickets_users` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_tickets_users_issued` FOREIGN KEY (`issued_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_tickets_users_resolved` FOREIGN KEY (`resolved_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `users_service_rewards`
--
ALTER TABLE `users_service_rewards`
  ADD CONSTRAINT `fk_users_service_rewards_admin_users` FOREIGN KEY (`redeemed_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_users_service_rewards_service_rewards` FOREIGN KEY (`service_reward_id`) REFERENCES `service_rewards` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_users_service_rewards_users` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

