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

START TRANSACTION;



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

--
-- Table structure for table `guard_visits`
--

CREATE TABLE `guard_visits` (
  `id` bigint(20) NOT NULL,
  `user_id` int(11) NOT NULL,
  `checkpoint_id` int(11) NOT NULL,
  `photo` longblob DEFAULT NULL,
  `latitude` decimal(10,7) DEFAULT NULL,
  `longitude` decimal(10,7) DEFAULT NULL,
  `submitted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `user_agent` varchar(255) DEFAULT NULL,
  `ip_address` varbinary(16) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `guard_visits`
--

INSERT INTO `guard_visits` (`id`, `user_id`, `checkpoint_id`, `photo`, `latitude`, `longitude`, `submitted_at`, `user_agent`, `ip_address`) VALUES
(1, 1, 1, 0x[BLOB], 30.6701215, 76.8428652, '2025-12-18 06:19:29', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 0x00000000000000000000000000000001);
INSERT INTO `guard_visits` (`id`, `user_id`, `checkpoint_id`, `photo`, `latitude`, `longitude`, `submitted_at`, `user_agent`, `ip_address`) VALUES
(2, 1, 5, 0x[BLOB], 30.6701251, 76.8428704, '2025-12-18 06:21:08', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 0x00000000000000000000000000000001);
INSERT INTO `guard_visits` (`id`, `user_id`, `checkpoint_id`, `photo`, `latitude`, `longitude`, `submitted_at`, `user_agent`, `ip_address`) VALUES
(3, 1, 1, 0x[BLOB], 30.6701251, 76.8428704, '2025-12-18 06:21:21', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 0x00000000000000000000000000000001);
INSERT INTO `guard_visits` (`id`, `user_id`, `checkpoint_id`, `photo`, `latitude`, `longitude`, `submitted_at`, `user_agent`, `ip_address`) VALUES
(4, 1, 3, 0x[BLOB], 30.6701243, 76.8428689, '2025-12-18 06:21:31', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 0x00000000000000000000000000000001);
INSERT INTO `guard_visits` (`id`, `user_id`, `checkpoint_id`, `photo`, `latitude`, `longitude`, `submitted_at`, `user_agent`, `ip_address`) VALUES
(5, 3, 5, 0x[BLOB], 30.6701322, 76.8429827, '2025-12-18 07:15:21', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 0x00000000000000000000000000000001);
INSERT INTO `guard_visits` (`id`, `user_id`, `checkpoint_id`, `photo`, `latitude`, `longitude`, `submitted_at`, `user_agent`, `ip_address`) VALUES
(6, 3, 5, 0x[BLOB], 30.6701322, 76.8429827, '2025-12-18 07:15:29', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 0x00000000000000000000000000000001);
