INSERT INTO `guard_visits` (`id`, `user_id`, `checkpoint_id`, `photo`, `latitude`, `longitude`, `submitted_at`, `user_agent`, `ip_address`) VALUES
(16, 4, 6, 0x[BLOB], 30.6701257, 76.8428830, '2025-12-18 07:34:54', '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
(17, 4, 5, 0x[BLOB], 30.6701277, 76.8428848, '2025-12-19 04:05:45', '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
(18, 4, 4, 0x[BLOB], 30.6701420, 76.8428513, '2025-12-19 04:05:51', '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
(19, 4, 7, 0x[BLOB], 30.6701420, 76.8428513, '2025-12-19 04:05:58', '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
(20, 1, 5, 0x[BLOB], 30.6701166, 76.8428908, '2026-01-06 05:33:26', '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
(21, 1, 5, 0x[BLOB], 30.6701395, 76.8428750, '2026-01-06 06:33:19', '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
(22, 1, 5, 0x[BLOB], 30.6697456, 76.8422648, '2026-01-06 07:05:22', '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
(23, 1, 2, 0x[BLOB], 30.6700311, 76.8426093, '2026-01-06 07:09:59', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 0x00000000000000000000000000000001);

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

--
-- Table structure for table `units`
--

CREATE TABLE `units` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `code` varchar(100) DEFAULT '',
  `description` varchar(255) DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `units`
--

INSERT INTO `units` (`id`, `name`, `code`, `description`) VALUES
(1, 'Head Office Panchkula', 'Head Office Panchkula', 'Head Office Panchkula'),
(2, 'Baddi', 'Baddi', 'Baddi'),
(3, 'TVC Dappar', 'TVC Dappar', 'TVC Dappar'),
(4, 'VGFC', 'VGFC', 'VGFC');

--
-- Indexes for table `guard_visits`
--
ALTER TABLE `guard_visits`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `checkpoint_id` (`checkpoint_id`);

--
-- Indexes for table `units`
--
ALTER TABLE `units`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for table `guard_visits`
--
ALTER TABLE `guard_visits`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

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

--
-- Constraints for table `guard_visits`
--
ALTER TABLE `guard_visits`
  ADD CONSTRAINT `guard_visits_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `guard_visits_ibfk_2` FOREIGN KEY (`checkpoint_id`) REFERENCES `checkpoints` (`id`);
COMMIT;

