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

START TRANSACTION;



--
-- Database: `php8chittaranjan_maharespicon2026`
--

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

--
-- Table structure for table `access_log`
--

CREATE TABLE `access_log` (
  `access_log_id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `user_type` enum('Admin','Student') NOT NULL,
  `user_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `login_at` datetime NOT NULL,
  `logout_at` datetime NOT NULL,
  `login_ip` varchar(20) NOT NULL,
  `login_mode` enum('Web_App','Mobile_App') NOT NULL,
  `fcm_id` varchar(500) NOT NULL,
  `latitude` varchar(100) NOT NULL,
  `longitude` varchar(100) NOT NULL,
  `location` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `access_log`
--

INSERT INTO `access_log` (`access_log_id`, `user_id`, `user_type`, `user_name`, `login_at`, `logout_at`, `login_ip`, `login_mode`, `fcm_id`, `latitude`, `longitude`, `location`) VALUES
(1, 2, 'Admin', 'Admin', '2023-06-06 18:27:08', '2023-06-06 18:49:14', '106.213.85.88', 'Web_App', '', '', '', ''),
(2, 2, 'Admin', 'Admin', '2023-06-06 18:28:46', '0000-00-00 00:00:00', '106.213.85.88', 'Web_App', '', '', '', ''),
(3, 2, 'Admin', 'Admin', '2023-06-06 18:49:20', '0000-00-00 00:00:00', '106.213.85.88', 'Web_App', '', '', '', ''),
(4, 2, 'Admin', 'Admin', '2023-06-07 09:47:45', '0000-00-00 00:00:00', '106.213.87.25', 'Web_App', '', '', '', ''),
(5, 2, 'Admin', 'Admin', '2023-06-07 10:35:25', '2023-06-07 10:40:44', '106.213.87.25', 'Web_App', '', '', '', ''),
(6, 2, 'Admin', 'Admin', '2023-06-07 10:43:00', '0000-00-00 00:00:00', '106.213.87.25', 'Web_App', '', '', '', ''),
(7, 2, 'Admin', 'Admin', '2023-06-07 11:14:18', '2023-06-07 11:19:29', '106.213.87.25', 'Web_App', '', '', '', ''),
(8, 2, 'Admin', 'Admin', '2023-06-07 11:58:31', '2023-06-07 12:01:43', '106.213.87.25', 'Web_App', '', '', '', ''),
(9, 2, 'Admin', 'Admin', '2023-06-07 12:06:45', '0000-00-00 00:00:00', '106.213.87.25', 'Web_App', '', '', '', ''),
(10, 2, 'Admin', 'Admin', '2023-06-07 12:13:27', '2023-06-07 12:14:03', '106.213.87.25', 'Web_App', '', '', '', ''),
(11, 2, 'Admin', 'Admin', '2023-06-07 12:17:51', '2023-06-07 12:23:41', '106.213.87.25', 'Web_App', '', '', '', ''),
(12, 2, 'Admin', 'Admin', '2023-06-07 17:30:17', '0000-00-00 00:00:00', '106.213.87.25', 'Web_App', '', '', '', ''),
(13, 2, 'Admin', 'Admin', '2023-06-08 09:40:42', '0000-00-00 00:00:00', '106.213.80.116', 'Web_App', '', '', '', ''),
(14, 2, 'Admin', 'Admin', '2023-06-08 11:48:46', '0000-00-00 00:00:00', '106.213.80.116', 'Web_App', '', '', '', ''),
(15, 2, 'Admin', 'Admin', '2023-06-08 14:06:02', '0000-00-00 00:00:00', '106.213.80.116', 'Web_App', '', '', '', ''),
(16, 2, 'Admin', 'Admin', '2023-06-08 16:59:58', '2023-06-08 17:01:58', '106.213.80.116', 'Web_App', '', '', '', ''),
(17, 2, 'Admin', 'Admin', '2023-06-08 18:46:52', '0000-00-00 00:00:00', '106.213.80.116', 'Web_App', '', '', '', ''),
(18, 2, 'Admin', 'Admin', '2023-06-16 09:54:48', '0000-00-00 00:00:00', '106.213.81.243', 'Web_App', '', '', '', ''),
(19, 2, 'Admin', 'Admin', '2023-06-19 15:11:28', '0000-00-00 00:00:00', '106.201.242.253', 'Web_App', '', '', '', ''),
(20, 2, 'Admin', 'Admin', '2023-06-30 13:23:39', '0000-00-00 00:00:00', '115.247.14.38', 'Web_App', '', '', '', ''),
(21, 2, 'Admin', 'Admin', '2023-08-04 10:47:39', '0000-00-00 00:00:00', '106.213.83.141', 'Web_App', '', '', '', ''),
(22, 2, 'Admin', 'Admin', '2023-08-11 10:08:04', '0000-00-00 00:00:00', '106.213.87.231', 'Web_App', '', '', '', ''),
(23, 2, 'Admin', 'Admin', '2025-05-15 13:12:58', '2025-05-15 13:14:33', '106.213.87.46', 'Web_App', '', '', '', ''),
(24, 2, 'Admin', 'Admin', '2025-05-15 13:27:31', '0000-00-00 00:00:00', '106.213.87.46', 'Web_App', '', '', '', ''),
(25, 2, 'Admin', 'Admin', '2025-05-15 14:33:44', '0000-00-00 00:00:00', '106.213.87.46', 'Web_App', '', '', '', ''),
(26, 2, 'Admin', 'Admin', '2025-05-15 14:46:48', '0000-00-00 00:00:00', '106.213.87.46', 'Web_App', '', '', '', ''),
(27, 2, 'Admin', 'Admin', '2025-05-16 09:57:53', '2025-05-16 12:40:36', '106.213.85.98', 'Web_App', '', '', '', ''),
(28, 4, '', 'Breakfast', '2025-05-16 12:41:55', '2025-05-16 12:41:56', '106.213.85.98', 'Web_App', '', '', '', ''),
(29, 2, 'Admin', 'Admin', '2025-05-16 12:42:18', '2025-05-16 12:43:17', '106.213.85.98', 'Web_App', '', '', '', ''),
(30, 4, '', 'Breakfast', '2025-05-16 12:43:20', '2025-05-16 12:43:21', '106.213.85.98', 'Web_App', '', '', '', ''),
(31, 4, '', 'Breakfast', '2025-05-16 12:43:26', '2025-05-16 12:43:27', '106.213.85.98', 'Web_App', '', '', '', ''),
(32, 2, 'Admin', 'Admin', '2025-05-16 12:43:45', '2025-05-16 12:53:46', '106.213.85.98', 'Web_App', '', '', '', ''),
(33, 4, '', 'Breakfast', '2025-05-16 12:53:54', '2025-05-16 12:53:55', '106.213.85.98', 'Web_App', '', '', '', ''),
(34, 3, '', 'registration', '2025-05-16 12:54:03', '2025-05-16 12:54:04', '106.213.85.98', 'Web_App', '', '', '', ''),
(35, 2, 'Admin', 'Admin', '2025-05-16 12:54:11', '2025-05-16 12:57:26', '106.213.85.98', 'Web_App', '', '', '', ''),
(36, 4, '', 'Breakfast', '2025-05-16 12:57:31', '2025-05-16 12:57:31', '106.213.85.98', 'Web_App', '', '', '', ''),
(37, 4, '', 'Breakfast', '2025-05-16 12:57:43', '2025-05-16 12:57:44', '106.213.85.98', 'Web_App', '', '', '', ''),
(38, 2, 'Admin', 'Admin', '2025-05-16 12:57:55', '2025-05-16 13:05:23', '106.213.85.98', 'Web_App', '', '', '', ''),
(39, 4, '', 'Breakfast', '2025-05-16 13:05:30', '2025-05-16 13:05:30', '106.213.85.98', 'Web_App', '', '', '', ''),
(40, 2, 'Admin', 'Admin', '2025-05-16 13:06:03', '2025-05-16 13:06:36', '106.213.85.98', 'Web_App', '', '', '', ''),
(41, 4, '', 'Breakfast', '2025-05-16 13:06:42', '2025-05-16 13:06:43', '106.213.85.98', 'Web_App', '', '', '', ''),
(42, 4, '', 'Breakfast', '2025-05-16 13:07:33', '2025-05-16 13:07:34', '106.213.85.98', 'Web_App', '', '', '', ''),
(43, 2, 'Admin', 'Admin', '2025-05-16 13:07:42', '0000-00-00 00:00:00', '106.213.85.98', 'Web_App', '', '', '', ''),
(44, 4, '', 'Breakfast', '2025-05-16 13:08:50', '2025-05-16 13:10:32', '106.213.85.98', 'Web_App', '', '', '', ''),
(45, 4, '', 'Breakfast', '2025-05-16 13:10:35', '0000-00-00 00:00:00', '106.213.85.98', 'Web_App', '', '', '', ''),
(46, 2, 'Admin', 'Admin', '2025-05-23 09:52:46', '0000-00-00 00:00:00', '106.213.83.81', 'Web_App', '', '', '', ''),
(47, 2, 'Admin', 'Admin', '2025-05-23 11:57:49', '0000-00-00 00:00:00', '106.213.83.81', 'Web_App', '', '', '', ''),
(48, 2, 'Admin', 'Admin', '2025-05-23 15:13:55', '0000-00-00 00:00:00', '106.213.83.81', 'Web_App', '', '', '', ''),
(49, 2, 'Admin', 'Admin', '2025-05-26 10:27:33', '0000-00-00 00:00:00', '106.213.81.90', 'Web_App', '', '', '', ''),
(50, 2, 'Admin', 'Admin', '2025-05-26 10:30:24', '0000-00-00 00:00:00', '106.213.81.90', 'Web_App', '', '', '', ''),
(51, 2, 'Admin', 'Admin', '2025-05-26 10:38:01', '0000-00-00 00:00:00', '106.213.81.90', 'Web_App', '', '', '', ''),
(52, 2, 'Admin', 'Admin', '2025-05-26 15:02:42', '0000-00-00 00:00:00', '106.213.81.90', 'Web_App', '', '', '', ''),
(53, 2, 'Admin', 'Admin', '2025-05-26 15:19:18', '0000-00-00 00:00:00', '106.213.81.90', 'Web_App', '', '', '', ''),
(54, 2, 'Admin', 'Admin', '2025-05-27 11:07:00', '0000-00-00 00:00:00', '106.213.82.241', 'Web_App', '', '', '', ''),
(55, 2, 'Admin', 'Admin', '2025-05-29 14:50:08', '0000-00-00 00:00:00', '106.213.85.158', 'Web_App', '', '', '', ''),
(56, 2, 'Admin', 'Admin', '2025-05-29 18:48:19', '0000-00-00 00:00:00', '106.213.85.158', 'Web_App', '', '', '', ''),
(57, 2, 'Admin', 'Admin', '2025-06-02 10:27:00', '0000-00-00 00:00:00', '106.213.81.118', 'Web_App', '', '', '', ''),
(58, 2, 'Admin', 'Admin', '2025-06-02 13:14:02', '0000-00-00 00:00:00', '106.213.81.118', 'Web_App', '', '', '', ''),
(59, 2, 'Admin', 'Admin', '2025-06-03 10:21:07', '0000-00-00 00:00:00', '106.213.82.45', 'Web_App', '', '', '', ''),
(60, 2, 'Admin', 'Admin', '2025-06-03 10:24:03', '0000-00-00 00:00:00', '106.213.82.45', 'Web_App', '', '', '', ''),
(61, 2, 'Admin', 'Admin', '2025-06-03 10:34:39', '0000-00-00 00:00:00', '106.213.82.45', 'Web_App', '', '', '', ''),
(62, 2, 'Admin', 'Admin', '2025-06-03 19:28:53', '0000-00-00 00:00:00', '106.213.82.45', 'Web_App', '', '', '', ''),
(63, 2, 'Admin', 'Admin', '2025-06-04 10:09:54', '0000-00-00 00:00:00', '106.213.82.45', 'Web_App', '', '', '', ''),
(64, 2, 'Admin', 'Admin', '2025-06-04 10:35:09', '0000-00-00 00:00:00', '106.213.82.45', 'Web_App', '', '', '', ''),
(65, 2, 'Admin', 'Admin', '2025-06-04 12:14:14', '0000-00-00 00:00:00', '106.213.82.45', 'Web_App', '', '', '', ''),
(66, 2, 'Admin', 'Admin', '2025-06-04 16:57:46', '0000-00-00 00:00:00', '106.213.82.45', 'Web_App', '', '', '', ''),
(67, 2, 'Admin', 'Admin', '2025-06-04 18:15:26', '0000-00-00 00:00:00', '106.213.82.45', 'Web_App', '', '', '', ''),
(68, 2, 'Admin', 'Admin', '2025-06-05 10:03:27', '0000-00-00 00:00:00', '106.213.81.34', 'Web_App', '', '', '', ''),
(69, 2, 'Admin', 'Admin', '2025-06-05 12:25:56', '0000-00-00 00:00:00', '106.213.81.34', 'Web_App', '', '', '', ''),
(70, 2, 'Admin', 'Admin', '2025-06-05 15:03:43', '0000-00-00 00:00:00', '106.213.81.34', 'Web_App', '', '', '', ''),
(71, 2, 'Admin', 'Admin', '2025-06-05 15:10:09', '0000-00-00 00:00:00', '106.213.81.34', 'Web_App', '', '', '', ''),
(72, 2, 'Admin', 'Admin', '2025-06-05 16:39:25', '0000-00-00 00:00:00', '106.213.81.34', 'Web_App', '', '', '', ''),
(73, 2, 'Admin', 'Admin', '2025-06-06 10:02:07', '0000-00-00 00:00:00', '106.213.81.34', 'Web_App', '', '', '', ''),
(74, 2, 'Admin', 'Admin', '2025-06-06 10:30:28', '0000-00-00 00:00:00', '106.213.81.34', 'Web_App', '', '', '', ''),
(75, 2, 'Admin', 'Admin', '2025-06-06 13:25:48', '0000-00-00 00:00:00', '106.213.81.34', 'Web_App', '', '', '', ''),
(76, 2, 'Admin', 'Admin', '2025-06-06 13:31:22', '2025-06-06 15:15:29', '106.213.81.34', 'Web_App', '', '', '', ''),
(77, 4, '', 'Breakfast', '2025-06-06 15:15:35', '2025-06-06 15:39:55', '106.213.81.34', 'Web_App', '', '', '', ''),
(78, 2, 'Admin', 'Admin', '2025-06-06 15:16:21', '0000-00-00 00:00:00', '106.213.81.34', 'Web_App', '', '', '', ''),
(79, 2, 'Admin', 'Admin', '2025-06-06 15:40:06', '0000-00-00 00:00:00', '106.213.81.34', 'Web_App', '', '', '', ''),
(80, 2, 'Admin', 'Admin', '2025-06-06 15:57:16', '0000-00-00 00:00:00', '106.213.81.34', 'Web_App', '', '', '', ''),
(81, 2, 'Admin', 'Admin', '2025-06-06 16:00:49', '2025-06-06 16:00:53', '106.213.81.34', 'Web_App', '', '', '', ''),
(82, 4, '', 'Breakfast', '2025-06-06 16:00:59', '0000-00-00 00:00:00', '106.213.81.34', 'Web_App', '', '', '', ''),
(83, 2, 'Admin', 'Admin', '2025-06-06 17:39:40', '0000-00-00 00:00:00', '106.213.81.34', 'Web_App', '', '', '', ''),
(84, 2, 'Admin', 'Admin', '2025-06-06 19:55:36', '0000-00-00 00:00:00', '103.182.196.106', 'Web_App', '', '', '', ''),
(85, 2, 'Admin', 'Admin', '2025-06-07 07:06:16', '0000-00-00 00:00:00', '103.182.196.106', 'Web_App', '', '', '', ''),
(86, 2, 'Admin', 'Admin', '2025-06-09 12:12:17', '0000-00-00 00:00:00', '106.213.84.96', 'Web_App', '', '', '', ''),
(87, 2, 'Admin', 'Admin', '2025-06-16 17:42:50', '0000-00-00 00:00:00', '106.213.81.199', 'Web_App', '', '', '', ''),
(88, 2, 'Admin', 'Admin', '2025-07-07 14:39:54', '2025-07-07 14:51:38', '106.213.86.200', 'Web_App', '', '', '', ''),
(89, 2, 'Admin', 'Admin', '2025-07-07 15:18:08', '2025-07-07 15:43:11', '106.213.86.200', 'Web_App', '', '', '', ''),
(90, 2, 'Admin', 'Admin', '2025-07-07 15:43:25', '0000-00-00 00:00:00', '106.213.86.200', 'Web_App', '', '', '', ''),
(91, 2, 'Admin', 'Admin', '2025-08-21 13:20:24', '0000-00-00 00:00:00', '106.213.86.79', 'Web_App', '', '', '', ''),
(92, 2, 'Admin', 'Admin', '2025-08-22 10:23:43', '0000-00-00 00:00:00', '106.213.87.228', 'Web_App', '', '', '', ''),
(93, 2, 'Admin', 'Admin', '2025-08-22 10:35:10', '0000-00-00 00:00:00', '106.213.87.228', 'Web_App', '', '', '', ''),
(94, 2, 'Admin', 'Admin', '2025-08-22 13:26:53', '2025-08-22 14:50:49', '106.213.87.228', 'Web_App', '', '', '', ''),
(95, 2, 'Admin', 'Admin', '2025-08-22 14:07:38', '0000-00-00 00:00:00', '106.213.87.228', 'Web_App', '', '', '', ''),
(96, 4, '', 'Breakfast', '2025-08-22 14:51:01', '2025-08-22 14:52:04', '106.213.87.228', 'Web_App', '', '', '', ''),
(97, 2, 'Admin', 'Admin', '2025-08-22 14:52:14', '2025-08-22 14:54:47', '106.213.87.228', 'Web_App', '', '', '', ''),
(98, 5, '', 'Lunch', '2025-08-22 14:54:54', '2025-08-22 15:00:33', '106.213.87.228', 'Web_App', '', '', '', ''),
(99, 2, 'Admin', 'Admin', '2025-08-22 15:01:34', '2025-08-22 15:17:34', '106.213.87.228', 'Web_App', '', '', '', ''),
(100, 2, 'Admin', 'Admin', '2025-08-22 15:17:41', '0000-00-00 00:00:00', '106.213.81.55', 'Web_App', '', '', '', ''),
(101, 2, 'Admin', 'Admin', '2025-08-22 22:40:50', '0000-00-00 00:00:00', '103.182.196.72', 'Web_App', '', '', '', ''),
(102, 2, 'Admin', 'Admin', '2025-08-23 07:05:12', '0000-00-00 00:00:00', '106.213.80.34', 'Web_App', '', '', '', ''),
(103, 2, 'Admin', 'Admin', '2025-08-23 07:28:36', '0000-00-00 00:00:00', '103.249.97.80', 'Web_App', '', '', '', ''),
(104, 2, 'Admin', 'Admin', '2025-08-23 10:15:23', '0000-00-00 00:00:00', '152.59.57.206', 'Web_App', '', '', '', ''),
(105, 2, 'Admin', 'Admin', '2025-08-23 12:38:06', '0000-00-00 00:00:00', '110.173.186.179', 'Web_App', '', '', '', ''),
(106, 2, 'Admin', 'Admin', '2025-08-23 14:19:36', '0000-00-00 00:00:00', '110.173.186.179', 'Web_App', '', '', '', ''),
(107, 2, 'Admin', 'Admin', '2025-08-23 14:24:29', '0000-00-00 00:00:00', '110.173.186.179', 'Web_App', '', '', '', ''),
(108, 2, 'Admin', 'Admin', '2025-08-23 15:47:31', '0000-00-00 00:00:00', '106.78.36.73', 'Web_App', '', '', '', ''),
(109, 2, 'Admin', 'Admin', '2025-08-23 15:58:05', '0000-00-00 00:00:00', '103.249.97.80', 'Web_App', '', '', '', ''),
(110, 2, 'Admin', 'Admin', '2025-08-23 19:00:48', '0000-00-00 00:00:00', '110.173.186.179', 'Web_App', '', '', '', ''),
(111, 2, 'Admin', 'Admin', '2025-08-23 19:33:04', '0000-00-00 00:00:00', '110.173.186.179', 'Web_App', '', '', '', ''),
(112, 2, 'Admin', 'Admin', '2025-08-24 12:48:25', '0000-00-00 00:00:00', '110.173.186.179', 'Web_App', '', '', '', ''),
(113, 2, 'Admin', 'Admin', '2025-08-24 13:31:04', '0000-00-00 00:00:00', '110.173.186.179', 'Web_App', '', '', '', ''),
(114, 2, 'Admin', 'Admin', '2025-08-24 16:10:34', '0000-00-00 00:00:00', '110.173.186.179', 'Web_App', '', '', '', ''),
(115, 2, 'Admin', 'Admin', '2025-08-26 18:38:37', '0000-00-00 00:00:00', '106.213.83.132', 'Web_App', '', '', '', ''),
(116, 2, 'Admin', 'Admin', '2025-08-28 11:26:24', '0000-00-00 00:00:00', '115.242.240.178', 'Web_App', '', '', '', ''),
(117, 2, 'Admin', 'Admin', '2025-08-29 12:30:00', '0000-00-00 00:00:00', '106.213.87.29', 'Web_App', '', '', '', ''),
(118, 2, 'Admin', 'Admin', '2025-09-09 10:34:19', '0000-00-00 00:00:00', '106.213.82.247', 'Web_App', '', '', '', ''),
(119, 2, 'Admin', 'Admin', '2025-09-11 10:37:54', '0000-00-00 00:00:00', '103.182.196.72', 'Web_App', '', '', '', ''),
(120, 2, 'Admin', 'Admin', '2025-09-11 14:47:20', '2025-09-11 14:48:19', '103.182.196.72', 'Web_App', '', '', '', ''),
(121, 2, 'Admin', 'Admin', '2025-09-15 14:32:50', '0000-00-00 00:00:00', '106.213.85.235', 'Web_App', '', '', '', ''),
(122, 2, 'Admin', 'Admin', '2025-09-15 18:15:08', '0000-00-00 00:00:00', '106.213.85.235', 'Web_App', '', '', '', ''),
(123, 2, 'Admin', 'Admin', '2025-09-17 13:29:05', '0000-00-00 00:00:00', '106.213.85.235', 'Web_App', '', '', '', ''),
(124, 2, 'Admin', 'Admin', '2025-09-23 11:53:13', '0000-00-00 00:00:00', '106.213.82.28', 'Web_App', '', '', '', ''),
(125, 2, 'Admin', 'Admin', '2025-09-29 15:08:22', '0000-00-00 00:00:00', '106.213.84.206', 'Web_App', '', '', '', ''),
(126, 2, 'Admin', 'Admin', '2025-09-29 15:29:31', '0000-00-00 00:00:00', '106.213.84.206', 'Web_App', '', '', '', ''),
(127, 2, 'Admin', 'Admin', '2025-09-30 10:31:54', '0000-00-00 00:00:00', '106.213.82.187', 'Web_App', '', '', '', ''),
(128, 2, 'Admin', 'Admin', '2025-09-30 20:23:55', '0000-00-00 00:00:00', '152.59.60.83', 'Web_App', '', '', '', ''),
(129, 2, 'Admin', 'Admin', '2025-10-08 12:13:28', '0000-00-00 00:00:00', '106.213.86.39', 'Web_App', '', '', '', ''),
(130, 2, 'Admin', 'Admin', '2025-10-09 10:57:30', '0000-00-00 00:00:00', '106.213.86.39', 'Web_App', '', '', '', ''),
(131, 2, 'Admin', 'Admin', '2026-03-20 09:54:25', '0000-00-00 00:00:00', '106.213.83.159', 'Web_App', '', '', '', ''),
(132, 2, 'Admin', 'Admin', '2026-06-01 10:58:13', '0000-00-00 00:00:00', '103.181.22.234', 'Web_App', '', '', '', ''),
(133, 2, 'Admin', 'Admin', '2026-06-01 12:50:53', '0000-00-00 00:00:00', '103.181.22.234', 'Web_App', '', '', '', ''),
(134, 2, 'Admin', 'Admin', '2026-06-01 13:26:56', '0000-00-00 00:00:00', '103.181.22.234', 'Web_App', '', '', '', ''),
(135, 2, 'Admin', 'Admin', '2026-06-01 17:26:19', '0000-00-00 00:00:00', '103.181.22.234', 'Web_App', '', '', '', ''),
(136, 2, 'Admin', 'Admin', '2026-06-01 19:04:00', '2026-06-01 19:24:11', '103.181.22.234', 'Web_App', '', '', '', ''),
(137, 2, 'Admin', 'Admin', '2026-06-01 19:24:20', '0000-00-00 00:00:00', '103.181.22.234', 'Web_App', '', '', '', ''),
(138, 2, 'Admin', 'Admin', '2026-06-01 22:00:22', '0000-00-00 00:00:00', '103.181.22.235', 'Web_App', '', '', '', ''),
(139, 2, 'Admin', 'Admin', '2026-06-02 10:34:42', '0000-00-00 00:00:00', '103.181.22.234', 'Web_App', '', '', '', ''),
(140, 2, 'Admin', 'Admin', '2026-06-02 11:26:01', '0000-00-00 00:00:00', '103.181.22.234', 'Web_App', '', '', '', ''),
(141, 2, 'Admin', 'Admin', '2026-06-02 12:24:12', '0000-00-00 00:00:00', '103.181.22.234', 'Web_App', '', '', '', ''),
(142, 2, 'Admin', 'Admin', '2026-06-03 11:03:09', '0000-00-00 00:00:00', '103.181.22.224', 'Web_App', '', '', '', ''),
(143, 2, 'Admin', 'Admin', '2026-06-03 15:37:22', '0000-00-00 00:00:00', '103.181.22.224', 'Web_App', '', '', '', ''),
(144, 2, 'Admin', 'Admin', '2026-06-03 15:37:50', '0000-00-00 00:00:00', '103.181.22.224', 'Web_App', '', '', '', ''),
(145, 2, 'Admin', 'Admin', '2026-06-03 15:47:27', '0000-00-00 00:00:00', '103.181.22.224', 'Web_App', '', '', '', ''),
(146, 2, 'Admin', 'Admin', '2026-06-03 15:56:07', '0000-00-00 00:00:00', '103.181.22.224', 'Web_App', '', '', '', ''),
(147, 2, 'Admin', 'Admin', '2026-06-04 12:13:54', '0000-00-00 00:00:00', '103.181.22.225', 'Web_App', '', '', '', ''),
(148, 2, 'Admin', 'Admin', '2026-06-04 12:34:37', '0000-00-00 00:00:00', '103.181.22.225', 'Web_App', '', '', '', ''),
(149, 2, 'Admin', 'Admin', '2026-06-04 17:58:00', '0000-00-00 00:00:00', '103.181.22.225', 'Web_App', '', '', '', ''),
(150, 2, 'Admin', 'Admin', '2026-06-05 09:59:48', '0000-00-00 00:00:00', '103.181.22.226', 'Web_App', '', '', '', ''),
(151, 2, 'Admin', 'Admin', '2026-06-05 10:55:59', '0000-00-00 00:00:00', '103.181.22.226', 'Web_App', '', '', '', ''),
(152, 2, 'Admin', 'Admin', '2026-06-05 11:45:22', '0000-00-00 00:00:00', '103.181.22.226', 'Web_App', '', '', '', ''),
(153, 2, 'Admin', 'Admin', '2026-06-05 16:41:42', '0000-00-00 00:00:00', '103.181.22.226', 'Web_App', '', '', '', '');

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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `category_id` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fee` decimal(10,2) NOT NULL,
  `badge` text NOT NULL,
  `status` enum('Active','Inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_deleted` enum('No','Yes') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_updated_by` int(11) NOT NULL,
  `last_updated_date` datetime NOT NULL,
  `added_by` int(11) NOT NULL,
  `added_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`category_id`, `name`, `fee`, `badge`, `status`, `is_deleted`, `last_updated_by`, `last_updated_date`, `added_by`, `added_date`) VALUES
(1, 'Faculty', 0.00, '1780645981_59c739ef86acc8f9bcc8.jpg', 'Active', 'No', 2, '2026-06-05 13:23:01', 2, '2025-08-21 13:22:48'),
(2, 'Delegate', 0.00, '1780645964_ca7b5371f2bdf99d571b.jpg', 'Active', 'No', 2, '2026-06-05 13:22:44', 2, '2025-08-21 13:22:56'),
(3, 'Trade / Pharma', 0.00, '1780645954_4010956950d0c70f7e93.jpg', 'Active', 'No', 2, '2026-06-05 13:22:34', 2, '2025-08-21 13:23:17'),
(4, 'Coupons', 0.00, '1780645946_132968bd83eb372e0de8.jpg', 'Active', 'No', 2, '2026-06-05 13:22:26', 2, '2025-08-21 13:23:24'),
(5, 'Organizing Committee', 0.00, '1780645936_076c4325fce22a17afe7.jpg', 'Active', 'No', 2, '2026-06-05 13:22:16', 2, '2025-08-21 13:25:41'),
(6, 'Coupon', 0.00, '1780645926_216f7c22387161a70cf9.jpg', 'Active', 'No', 2, '2026-06-05 13:22:06', 2, '2025-08-21 13:50:20'),
(7, 'Spot Registration', 0.00, '1780645919_b32b7ef80f24c8e9f160.jpg', 'Active', 'No', 2, '2026-06-05 13:21:59', 2, '2025-08-21 14:03:29'),
(8, 'Delegate MMC REG', 0.00, '1780645854_a92fdd708a07d014a791.jpg', 'Active', 'No', 2, '2026-06-05 13:20:54', 2, '2025-08-26 18:44:26'),
(9, 'PG Student', 0.00, '1780645847_90e18145303643f2e4d9.jpg', 'Active', 'No', 2, '2026-06-05 13:20:47', 2, '2026-06-04 12:37:35');

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

--
-- Table structure for table `company`
--

CREATE TABLE `company` (
  `company_id` int(11) NOT NULL,
  `name` varchar(250) NOT NULL,
  `printing_name` varchar(250) NOT NULL,
  `phone_no` varchar(20) NOT NULL,
  `email_id` varchar(100) NOT NULL,
  `address` varchar(250) NOT NULL,
  `pin_code` varchar(50) NOT NULL,
  `city` text NOT NULL,
  `state_id` int(11) NOT NULL,
  `country_id` int(11) NOT NULL,
  `currency_code` varchar(20) NOT NULL,
  `company_logo` varchar(250) NOT NULL,
  `pan_no` varchar(50) NOT NULL,
  `gst_no` varchar(50) NOT NULL,
  `website` varchar(250) NOT NULL,
  `tnc_quotation` text NOT NULL,
  `tnc_invoice` text NOT NULL,
  `tnc_purchase_order` text NOT NULL,
  `bank_detail` text NOT NULL,
  `status` enum('Active','Inactive') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `is_deleted` enum('No','Yes') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `added_by` int(11) NOT NULL,
  `added_date` datetime NOT NULL,
  `last_updated_by` int(11) NOT NULL,
  `last_updated_date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `company`
--

INSERT INTO `company` (`company_id`, `name`, `printing_name`, `phone_no`, `email_id`, `address`, `pin_code`, `city`, `state_id`, `country_id`, `currency_code`, `company_logo`, `pan_no`, `gst_no`, `website`, `tnc_quotation`, `tnc_invoice`, `tnc_purchase_order`, `bank_detail`, `status`, `is_deleted`, `added_by`, `added_date`, `last_updated_by`, `last_updated_date`) VALUES
(1, 'Window Expert - Satpur', 'Window Expert', '111111', 'windowexpert@example.com', 'Window Expert, Satpur, Nashik', '422011', 'Nashik', 22, 1, 'INR', '1618489077_30d9c8afa43496af8227.png', '', '', 'http://www.example.com', '', '', '', 'Account Name: Window Expert<br>\r\nAccount Number: 123456789865<br>\r\nIFSC Code: ICIC0002330<br>\r\nBranch: Satpur, Nashik', 'Active', 'No', 20, '2020-12-18 18:28:22', 20, '2021-11-26 11:33:42'),
(2, 'Window Expert - Ambad', 'SRI Traders ', '2222222', 'we@example.com', 'Window Expert, Ambad, Nashik', '422010', 'Nashik', 22, 1, 'INR', '1618489077_30d9c8afa43496af8227.png', '', '', 'https://example.com', '', '', '', '', 'Active', 'No', 20, '2020-12-18 18:28:22', 20, '2021-11-26 11:35:27');

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

--
-- Table structure for table `config`
--

CREATE TABLE `config` (
  `config_id` int(10) UNSIGNED NOT NULL,
  `sms_url` text NOT NULL,
  `sms_mobile_no_field` varchar(50) NOT NULL,
  `sms_msg_field` varchar(50) NOT NULL,
  `whatsapp_base_url` varchar(500) NOT NULL,
  `whatsapp_interval_second` int(10) NOT NULL,
  `whatsapp_from_id` int(20) NOT NULL,
  `whatsapp_to_id` int(20) NOT NULL,
  `whatsapp_msg` text NOT NULL,
  `whatsapp_last_sent` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;



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

--
-- Table structure for table `country`
--

CREATE TABLE `country` (
  `country_id` int(10) UNSIGNED NOT NULL,
  `name` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `country`
--

INSERT INTO `country` (`country_id`, `name`) VALUES
(1, 'India');

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

--
-- Table structure for table `facility`
--

CREATE TABLE `facility` (
  `facility_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `category_id` varchar(100) NOT NULL,
  `is_default` enum('No','Yes') NOT NULL,
  `status` enum('Active','Inactive') NOT NULL,
  `is_deleted` enum('No','Yes') NOT NULL,
  `added_by` int(11) NOT NULL,
  `added_date` datetime NOT NULL,
  `last_updated_by` int(11) NOT NULL,
  `last_updated_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `facility`
--

INSERT INTO `facility` (`facility_id`, `name`, `category_id`, `is_default`, `status`, `is_deleted`, `added_by`, `added_date`, `last_updated_by`, `last_updated_date`) VALUES
(1, 'Breakfast 06-06-2026', '6,4,2,1,5,7', 'No', 'Active', 'No', 2, '2025-08-22 14:49:46', 2, '2026-06-04 16:28:26'),
(2, 'Lunch 06-06-2026', '6,4,2,8,1,5,9,7,3', 'No', 'Active', 'No', 2, '2025-08-22 14:53:26', 2, '2026-06-04 16:28:16');

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

--
-- Table structure for table `feedback`
--

CREATE TABLE `feedback` (
  `feedback_id` int(11) NOT NULL,
  `registration_id` int(20) NOT NULL,
  `speakers` varchar(100) NOT NULL,
  `content_of_talks` varchar(100) NOT NULL,
  `practical_usefullness` varchar(100) NOT NULL,
  `overall_arrangements` varchar(100) NOT NULL,
  `average` decimal(10,2) NOT NULL,
  `status` enum('Active','Inactive') NOT NULL,
  `is_deleted` enum('No','Yes') NOT NULL,
  `added_by` int(11) NOT NULL,
  `added_date` datetime NOT NULL,
  `last_updated_by` int(11) NOT NULL,
  `last_updated_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `menu`
--

CREATE TABLE `menu` (
  `menu_id` int(10) UNSIGNED NOT NULL,
  `title` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `parent_menu_id` int(11) NOT NULL,
  `controller` varchar(100) NOT NULL,
  `url` varchar(250) NOT NULL,
  `external_url` enum('No','Yes') NOT NULL,
  `open_in_new_tab` enum('No','Yes') NOT NULL,
  `icon` varchar(250) NOT NULL,
  `sequence` int(11) NOT NULL,
  `user_type` varchar(50) NOT NULL,
  `status` enum('Active','Inactive') NOT NULL,
  `is_deleted` enum('No','Yes') NOT NULL,
  `added_by` int(11) NOT NULL,
  `added_date` datetime NOT NULL,
  `last_updated_by` int(11) NOT NULL,
  `last_updated_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `menu`
--

INSERT INTO `menu` (`menu_id`, `title`, `parent_menu_id`, `controller`, `url`, `external_url`, `open_in_new_tab`, `icon`, `sequence`, `user_type`, `status`, `is_deleted`, `added_by`, `added_date`, `last_updated_by`, `last_updated_date`) VALUES
(1, 'Dashboard', 0, 'dashboard', 'dashboard', 'No', 'No', '<i class=\"fa la-dashboard\"></i>', 1, '', 'Active', 'No', 1, '2019-09-03 00:00:00', 1, '2019-09-03 00:00:00'),
(2, 'Setup', 0, '', '', 'No', 'No', '<i class=\"fa fa-cog\"></i>', 2, '', 'Active', 'No', 1, '2019-09-03 00:00:00', 1, '2019-09-03 00:00:00'),
(3, 'Master', 0, '', '', 'No', 'No', '<i class=\"fa fa-book\"></i>', 3, '', 'Active', 'Yes', 1, '2019-10-04 00:00:00', 1, '2019-10-04 00:00:00'),
(4, 'User', 2, 'users', 'users', 'No', 'No', '<i class=\"fa fa-user\"></i>', 1, '', 'Active', 'No', 1, '2019-09-03 00:00:00', 1, '2019-09-03 00:00:00'),
(5, 'Authorization', 2, 'authorize', 'authorize/user', 'No', 'No', '<i class=\"fa fa-key\"></i>', 2, '', 'Active', 'No', 1, '2019-10-04 00:00:00', 1, '2019-10-04 00:00:00'),
(6, 'Registration', 0, 'registration', 'registration', 'No', 'No', '<i class=\"fa fa-users\"></i>', 6, '', 'Active', 'No', 1, '2019-10-04 00:00:00', 1, '2019-10-04 00:00:00'),
(8, 'Facility', 2, 'facility', 'facility', 'No', 'No', '<i class=\"fas fa-calendar-alt\"></i>', 3, '', 'Active', 'No', 1, '2020-12-17 00:00:00', 1, '2020-12-17 00:00:00'),
(9, 'Attendance', 0, 'attendance', 'attendance', 'No', 'No', '<i class=\"fa fa-users\"></i>', 7, '', 'Active', 'No', 1, '2022-11-12 00:00:00', 1, '2022-11-12 00:00:00'),
(10, 'Quick Registration', 2, 'registration', 'registration/quick_add', 'No', 'No', '<i class=\"fa fa-users\"></i>', 4, '', 'Active', 'No', 1, '2019-10-04 00:00:00', 1, '2019-10-04 00:00:00'),
(11, 'Report', 0, '', '', 'No', 'No', '<i class=\"fa fa-book\"></i>', 9, '', 'Active', 'No', 1, '2019-10-04 00:00:00', 1, '2019-10-04 00:00:00'),
(12, 'Attendance Report', 11, 'report', 'report/attendance_cnt', 'No', 'No', '<i class=\"fas fa-calendar-alt\"></i>', 1, '', 'Active', 'No', 1, '2020-12-17 00:00:00', 1, '2020-12-17 00:00:00'),
(13, 'Spot Registration', 2, 'registration', 'registration/bulk_spot_add', 'No', 'No', '<i class=\"fas fa-calendar-alt\"></i>', 5, '', 'Active', 'No', 1, '2020-12-17 00:00:00', 1, '2020-12-17 00:00:00'),
(14, 'Feedback', 11, 'feedback', 'feedback', 'No', 'No', '<i class=\"fas fa-calendar-alt\"></i>', 1, '', 'Active', 'No', 1, '2020-12-17 00:00:00', 1, '2020-12-17 00:00:00'),
(15, 'Send Regi. No.', 11, 'supportive', 'supportive/send_regi_no', 'No', 'No', '<i class=\"fas fa-calendar-alt\"></i>', 1, '', 'Inactive', 'No', 1, '2020-12-17 00:00:00', 1, '2020-12-17 00:00:00'),
(16, 'Send Workshop', 11, 'supportive', 'supportive/send_workshop', 'No', 'No', '<i class=\"fas fa-calendar-alt\"></i>', 1, '', 'Inactive', 'No', 1, '2020-12-17 00:00:00', 1, '2020-12-17 00:00:00'),
(17, 'WhatsApp', 2, 'whatsapp', 'whatsapp/build_msg', 'No', 'No', '<i class=\"fab fa-whatsapp\"></i>', 6, '', 'Active', 'No', 1, '2023-01-19 00:00:00', 1, '2023-01-19 00:00:00'),
(18, 'Import', 2, 'import', 'import/registration', 'No', 'No', '<i class=\"fa fa-file\"></i>', 7, '', 'Active', 'No', 1, '2023-01-19 00:00:00', 1, '2023-01-19 00:00:00'),
(19, 'Print Badges', 0, 'print_badge', 'print_badge', 'No', 'No', '<i class=\"fa fa-file\"></i>', 10, '', 'Active', 'No', 1, '2023-01-19 00:00:00', 1, '2023-01-19 00:00:00'),
(20, 'Category', 2, 'category', 'category', 'No', 'No', '<i class=\"fa fa-file\"></i>', 8, '', 'Active', 'No', 1, '2023-01-19 00:00:00', 1, '2023-01-19 00:00:00'),
(21, 'Trade / Farma', 0, 'trade_farma', 'trade_farma', 'No', 'No', '<i class=\"fa fa-file\"></i>', 11, '', 'Inactive', 'Yes', 1, '2023-01-19 00:00:00', 1, '2023-01-19 00:00:00');

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

--
-- Table structure for table `registration_Org`
--

CREATE TABLE `registration_Org` (
  `registration_id` int(11) NOT NULL,
  `registration_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `registration_date` date DEFAULT NULL,
  `name` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_status` enum('Pending','Paid','Not applicable') DEFAULT NULL,
  `gender` varchar(50) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `sport_participation_type` varchar(100) DEFAULT NULL,
  `registration_fee` decimal(10,2) DEFAULT NULL,
  `sport_fee` decimal(10,2) DEFAULT NULL,
  `fee` decimal(10,2) DEFAULT NULL,
  `iap_life_membership_no` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mmc_registration_no` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_id` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile_whatsapp_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile_no_2` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(250) DEFAULT NULL,
  `paid_amount` decimal(10,2) DEFAULT NULL,
  `payment_mode` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_date` date DEFAULT NULL,
  `payment_request_id` varchar(250) DEFAULT NULL,
  `payment_transaction_no` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_bank_branch` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `aadhar_card_file` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `certificate_file` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `verification_code` varchar(50) DEFAULT NULL,
  `is_spot_registration` enum('No','Yes') NOT NULL DEFAULT 'No',
  `is_coupon` enum('No','Yes') NOT NULL DEFAULT 'No',
  `is_feedback_given` enum('No','Yes') DEFAULT NULL,
  `regi_no_sent_wahtsapp` enum('No','Yes') DEFAULT 'No',
  `whatsapp_msg_sent` enum('No','Yes','Skipped') NOT NULL,
  `status` enum('Active','Inactive') DEFAULT NULL,
  `is_deleted` enum('No','Yes') DEFAULT NULL,
  `added_by` int(11) DEFAULT NULL,
  `added_date` datetime DEFAULT NULL,
  `last_updated_by` int(11) DEFAULT NULL,
  `last_updated_date` datetime DEFAULT NULL,
  `payment_description_temp` varchar(250) DEFAULT NULL,
  `receipt_no` varchar(100) DEFAULT NULL,
  `pg_resp_1` longtext DEFAULT NULL,
  `pg_resp_2` longtext DEFAULT NULL,
  `workshop` varchar(500) DEFAULT NULL,
  `workshop_title` varchar(500) DEFAULT NULL,
  `is_all_facility` enum('No','Yes') NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `registration_sport`
--

CREATE TABLE `registration_sport` (
  `registration_sport_id` int(10) UNSIGNED NOT NULL,
  `registration_id` int(11) NOT NULL,
  `sport_id` int(10) NOT NULL,
  `fee` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sms`
--

CREATE TABLE `sms` (
  `sms_id` int(10) UNSIGNED NOT NULL,
  `base_url` text NOT NULL,
  `mobile_no_param_name` varchar(50) NOT NULL,
  `message_param_name` varchar(50) NOT NULL,
  `message_template` varchar(400) NOT NULL,
  `status` enum('Active','Inactive') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `sport`
--

CREATE TABLE `sport` (
  `sport_id` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `only_single` enum('No','Yes') NOT NULL,
  `single_fee` decimal(10,2) NOT NULL,
  `double_fee` decimal(10,2) NOT NULL,
  `status` enum('Active','Inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_deleted` enum('No','Yes') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `state`
--

CREATE TABLE `state` (
  `state_id` int(10) UNSIGNED NOT NULL,
  `name` varchar(250) NOT NULL,
  `tin` varchar(10) NOT NULL,
  `state_code` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `state`
--

INSERT INTO `state` (`state_id`, `name`, `tin`, `state_code`) VALUES
(1, 'Andaman Nicobar', '35', 'AN'),
(2, 'Andhra Pradesh', '37', 'AD'),
(3, 'Arunachal Pradesh', '12', 'AR'),
(4, 'Assam', '18', 'AS'),
(5, 'Bihar', '10', 'BR'),
(6, 'Chandigarh', '04', 'CH'),
(7, 'Chhattisgarh', '22', 'CG'),
(8, 'Dadra Nagar Haveli', '26', 'DNH'),
(9, 'Daman Diu', '26', 'DD'),
(10, 'Delhi', '07', 'DL'),
(11, 'Goa', '30', 'GA'),
(12, 'Gujarat', '24', 'GJ'),
(13, 'Haryana', '06', 'HR'),
(14, 'Himachal Pradesh', '02', 'HP'),
(15, 'Jammu Kashmir', '01', 'JK'),
(16, 'Jharkhand', '20', 'JH'),
(17, 'Karnataka', '29', 'KA'),
(18, 'Kerala', '32', 'KL'),
(19, 'Ladakh', '38', 'LA'),
(20, 'Lakshadweep', '31', 'LD'),
(21, 'Madhya Pradesh', '23', 'MP'),
(22, 'Maharashtra', '27', 'MH'),
(23, 'Manipur', '14', 'MN'),
(24, 'Meghalaya', '17', 'ML'),
(25, 'Mizoram', '15', 'MZ'),
(26, 'Nagaland', '13', 'NL'),
(27, 'Odisha', '21', 'OD'),
(28, 'Puducherry', '34', 'PY'),
(29, 'Punjab', '03', 'PB'),
(30, 'Rajasthan', '08', 'RJ'),
(31, 'Sikkim', '11', 'SK'),
(32, 'Tamil Nadu', '33', 'TN'),
(33, 'Telangana', '36', 'TS'),
(34, 'Tripura', '16', 'TR'),
(35, 'Uttar Pradesh', '09', 'UP'),
(36, 'Uttarakhand', '05', 'UK'),
(37, 'West Bengal', '19', 'WB');

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

--
-- Table structure for table `status`
--

CREATE TABLE `status` (
  `status_id` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `color_code` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `follow_up` enum('Yes','No') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `enquiry_status_management` enum('No','Yes') NOT NULL,
  `status` enum('Active','Inactive') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `is_deleted` enum('No','Yes') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `added_by` int(11) NOT NULL,
  `added_date` datetime NOT NULL,
  `last_updated_by` int(11) NOT NULL,
  `last_updated_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `status`
--

INSERT INTO `status` (`status_id`, `name`, `color_code`, `follow_up`, `enquiry_status_management`, `status`, `is_deleted`, `added_by`, `added_date`, `last_updated_by`, `last_updated_date`) VALUES
(1, 'Open', '#FFBF00', 'Yes', 'Yes', 'Active', 'No', 1, '2019-11-04 13:21:30', 2, '2021-11-29 14:56:18'),
(2, 'Closed', '#28a745', 'Yes', 'No', 'Active', 'No', 1, '2019-11-04 13:21:40', 1, '2019-11-07 12:22:09'),
(3, 'Cancelled', '#dc3545', 'Yes', 'No', 'Active', 'Yes', 1, '2019-11-07 12:22:24', 1, '2019-11-22 17:27:15'),
(4, 'Lost', '#dc3545', 'Yes', 'No', 'Active', 'No', 1, '2019-11-07 12:22:38', 1, '2019-11-14 17:38:43'),
(5, 'Confirmed', '#28a745', 'Yes', 'Yes', 'Active', 'No', 1, '2019-11-07 12:22:50', 2, '2021-11-30 12:31:34'),
(6, 'On-Hold', '', 'No', 'No', 'Active', 'Yes', 1, '2020-01-13 17:13:31', 1, '2020-01-13 17:14:24'),
(7, 'On Hold 1', '', 'Yes', 'No', 'Inactive', 'Yes', 20, '2020-12-18 15:46:33', 20, '2020-12-18 15:48:26'),
(8, 'Processed', '', 'No', 'Yes', 'Active', 'No', 2, '2021-12-01 10:21:33', 2, '2021-12-01 10:21:33'),
(9, 'Processed 2nd Stage', '', 'No', 'Yes', 'Active', 'No', 2, '2021-12-01 10:22:15', 2, '2021-12-01 10:22:15'),
(10, 'Ready to Dispatch', '', 'Yes', 'Yes', 'Active', 'No', 2, '2021-12-01 10:22:32', 2, '2021-12-01 10:22:32'),
(11, 'Dispatched ', '', 'No', 'Yes', 'Active', 'No', 2, '2021-12-01 10:23:10', 2, '2021-12-01 10:23:10'),
(12, 'Installation Done', '', 'Yes', 'Yes', 'Active', 'No', 2, '2021-12-01 10:23:39', 2, '2021-12-01 10:23:39'),
(13, 'Tested and Ready to Use', '', 'No', 'Yes', 'Active', 'No', 2, '2021-12-01 10:24:05', 2, '2021-12-01 10:24:05'),
(14, 'Payment Follow Up', '', 'Yes', 'Yes', 'Active', 'No', 2, '2021-12-23 15:50:23', 2, '2021-12-23 15:50:23');

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

--
-- Table structure for table `status_log`
--

CREATE TABLE `status_log` (
  `status_log_id` int(11) NOT NULL,
  `document_type_id` int(11) NOT NULL,
  `doc_entry_pk` int(20) NOT NULL,
  `status_id` int(11) NOT NULL,
  `status` enum('Active','Inactive') NOT NULL,
  `is_deleted` enum('No','Yes') NOT NULL,
  `added_by` int(11) NOT NULL,
  `added_date` datetime NOT NULL,
  `last_updated_by` int(11) NOT NULL,
  `last_updated_date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `taluka`
--

CREATE TABLE `taluka` (
  `taluka_id` int(10) UNSIGNED NOT NULL,
  `name` varchar(250) NOT NULL,
  `district_id` int(11) NOT NULL,
  `status` enum('Active','Inactive') NOT NULL,
  `is_deleted` enum('No','Yes') NOT NULL,
  `added_by` int(11) NOT NULL,
  `added_date` datetime NOT NULL,
  `last_updated_by` int(11) NOT NULL,
  `last_updated_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `taluka`
--

INSERT INTO `taluka` (`taluka_id`, `name`, `district_id`, `status`, `is_deleted`, `added_by`, `added_date`, `last_updated_by`, `last_updated_date`) VALUES
(1, '--', 1, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(2, '--', 2, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(3, '--', 3, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(4, '--', 4, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(5, '--', 5, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(6, '--', 6, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(7, '--', 7, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(8, '--', 8, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(9, '--', 9, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(10, '--', 10, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(11, '--', 11, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(12, '--', 12, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(13, '--', 13, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(14, '--', 14, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(15, '--', 15, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(16, '--', 16, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(17, '--', 17, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(18, '--', 18, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(19, '--', 19, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(20, '--', 20, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(21, '--', 21, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(22, '--', 22, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(23, '--', 23, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(24, '--', 24, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(25, '--', 25, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(26, '--', 26, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(27, '--', 27, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(28, '--', 28, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(29, '--', 29, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(30, '--', 30, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(31, '--', 31, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(32, '--', 32, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(33, '--', 33, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(34, '--', 34, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(35, '--', 35, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(36, '--', 36, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(37, '--', 37, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(38, '--', 38, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(39, '--', 39, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(40, '--', 40, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(41, '--', 41, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(42, '--', 42, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(43, '--', 43, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(44, '--', 44, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(45, '--', 45, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(46, '--', 46, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(47, '--', 47, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(48, '--', 48, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(49, '--', 49, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(50, '--', 50, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(51, '--', 51, 'Active', 'No', 20, '0000-00-00 00:00:00', 20, '0000-00-00 00:00:00'),
(52, '--', 52, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(53, '--', 53, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(54, '--', 54, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(55, '--', 55, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(56, '--', 56, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(57, '--', 57, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(58, '--', 58, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(59, '--', 59, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(60, '--', 60, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(61, '--', 61, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(62, '--', 62, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(63, '--', 63, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(64, '--', 64, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(65, '--', 65, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(66, '--', 66, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(67, '--', 67, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(68, '--', 68, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(69, '--', 69, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(70, '--', 70, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(71, '--', 71, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(72, '--', 72, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(73, '--', 73, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(74, '--', 74, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(75, '--', 75, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(76, '--', 76, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(77, '--', 77, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(78, '--', 78, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(79, '--', 79, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(80, '--', 80, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(81, '--', 81, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(82, '--', 82, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(83, '--', 83, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(84, '--', 84, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(85, '--', 85, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(86, '--', 86, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(87, '--', 87, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(88, '--', 88, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(89, '--', 89, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(90, '--', 90, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(91, '--', 91, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(92, '--', 92, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(93, '--', 93, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(94, '--', 94, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(95, '--', 95, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(96, '--', 96, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(97, '--', 97, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(98, '--', 98, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(99, '--', 99, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(100, '--', 100, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(101, '--', 101, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(102, '--', 102, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(103, '--', 103, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(104, '--', 104, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(105, '--', 105, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(106, '--', 106, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(107, '--', 107, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(108, '--', 108, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(109, '--', 109, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(110, '--', 110, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(111, '--', 111, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(112, '--', 112, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(113, '--', 113, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(114, '--', 114, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(115, '--', 115, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(116, '--', 116, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(117, '--', 117, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(118, '--', 118, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(119, '--', 119, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(120, '--', 120, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(121, '--', 121, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(122, '--', 122, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(123, '--', 123, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(124, '--', 124, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(125, '--', 125, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(126, '--', 126, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(127, '--', 127, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(128, '--', 128, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(129, '--', 129, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(130, '--', 130, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(131, '--', 131, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(132, '--', 132, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(133, '--', 133, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(134, '--', 134, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(135, '--', 135, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(136, '--', 136, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(137, '--', 137, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(138, '--', 138, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(139, '--', 139, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(140, '--', 140, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(141, '--', 141, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(142, '--', 142, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(143, '--', 143, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(144, '--', 144, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(145, '--', 145, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(146, '--', 146, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(147, '--', 147, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(148, '--', 148, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(149, '--', 149, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(150, '--', 150, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(151, '--', 151, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(152, '--', 152, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(153, '--', 153, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(154, '--', 154, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(155, '--', 155, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(156, '--', 156, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(157, '--', 157, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(158, '--', 158, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(159, '--', 159, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(160, '--', 160, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(161, '--', 161, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(162, '--', 162, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(163, '--', 163, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(164, '--', 164, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(165, '--', 165, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(166, '--', 166, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(167, '--', 167, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(168, '--', 168, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(169, '--', 169, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(170, '--', 170, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(171, '--', 171, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(172, '--', 172, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(173, '--', 173, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(174, '--', 174, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(175, '--', 175, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(176, '--', 176, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(177, '--', 177, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(178, '--', 178, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(179, '--', 179, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(180, '--', 180, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(181, '--', 181, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(182, '--', 182, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(183, '--', 183, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(184, '--', 184, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(185, '--', 185, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(186, '--', 186, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(187, '--', 187, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(188, '--', 188, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(189, '--', 189, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(190, '--', 190, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(191, '--', 191, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(192, '--', 192, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(193, '--', 193, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(194, '--', 194, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(195, '--', 195, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(196, '--', 196, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(197, '--', 197, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(198, '--', 198, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(199, '--', 199, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(200, '--', 200, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(201, '--', 201, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(202, '--', 202, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(203, '--', 203, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(204, '--', 204, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(205, '--', 205, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(206, '--', 206, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(207, '--', 207, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(208, '--', 208, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(209, '--', 209, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(210, '--', 210, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(211, '--', 211, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(212, '--', 212, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(213, '--', 213, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(214, '--', 214, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(215, '--', 215, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(216, '--', 216, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(217, '--', 217, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(218, '--', 218, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(219, '--', 219, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(220, '--', 220, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(221, '--', 221, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(222, '--', 222, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(223, '--', 223, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(224, '--', 224, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(225, '--', 225, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(226, '--', 226, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(227, '--', 227, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(228, '--', 228, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(229, '--', 229, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(230, '--', 230, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(231, '--', 231, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(232, '--', 232, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(233, '--', 233, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(234, '--', 234, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(235, '--', 235, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(236, '--', 236, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(237, '--', 237, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(238, '--', 238, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(239, '--', 239, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(240, '--', 240, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(241, '--', 241, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(242, '--', 242, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(243, '--', 243, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(244, '--', 244, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(245, '--', 245, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(246, '--', 246, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(247, '--', 247, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(248, '--', 248, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(249, '--', 249, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(250, '--', 250, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(251, '--', 251, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(252, '--', 252, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(253, '--', 253, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(254, '--', 254, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(255, '--', 255, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(256, '--', 256, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(257, '--', 257, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(258, '--', 258, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(259, '--', 259, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(260, '--', 260, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(261, '--', 261, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(262, '--', 262, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(263, '--', 263, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(264, '--', 264, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(265, '--', 265, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(266, '--', 266, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(267, '--', 267, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(268, '--', 268, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(269, '--', 269, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(270, '--', 270, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(271, '--', 271, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(272, '--', 272, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(273, '--', 273, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(274, '--', 274, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(275, '--', 275, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(276, '--', 276, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(277, '--', 277, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(278, '--', 278, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(279, '--', 279, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(280, '--', 280, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(281, '--', 281, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(282, '--', 282, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(283, '--', 283, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(284, '--', 284, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(285, '--', 285, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(286, '--', 286, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(287, '--', 287, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(288, '--', 288, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(289, '--', 289, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(290, '--', 290, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(291, '--', 291, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(292, '--', 292, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(293, '--', 293, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(294, '--', 294, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(295, '--', 295, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(296, '--', 296, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(297, '--', 297, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(298, '--', 298, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(299, '--', 299, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(300, '--', 300, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(301, '--', 301, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(302, '--', 302, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(303, '--', 303, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(304, '--', 304, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(305, '--', 305, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(306, '--', 306, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(307, '--', 307, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(308, '--', 308, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(309, '--', 309, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(310, '--', 310, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(311, '--', 311, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(312, '--', 312, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(313, '--', 313, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(314, '--', 314, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(315, '--', 315, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(316, '--', 316, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(317, '--', 317, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(318, '--', 318, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(319, '--', 319, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(320, '--', 320, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(321, '--', 321, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(322, '--', 322, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(323, '--', 323, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(324, '--', 324, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(325, '--', 325, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(326, '--', 326, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(327, '--', 327, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(328, '--', 328, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(329, '--', 329, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(330, '--', 330, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(331, '--', 331, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(332, '--', 332, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(333, '--', 333, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(334, '--', 334, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(335, '--', 335, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(336, '--', 336, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(337, '--', 337, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(338, '--', 338, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(339, '--', 339, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(340, '--', 340, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(341, '--', 341, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(342, '--', 342, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(343, '--', 343, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(344, '--', 344, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(345, '--', 345, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(346, '--', 346, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(347, '--', 347, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(348, '--', 348, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(349, '--', 349, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(350, '--', 350, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(351, '--', 351, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(352, '--', 352, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(353, '--', 353, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(354, '--', 354, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(355, '--', 355, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(356, '--', 356, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(357, '--', 357, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(358, '--', 358, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(359, '--', 359, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(360, '--', 360, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(361, '--', 361, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(362, '--', 362, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(363, '--', 363, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(364, '--', 364, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(365, '--', 365, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(366, '--', 366, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(367, '--', 367, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(368, '--', 368, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(369, '--', 369, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(370, '--', 370, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(371, '--', 371, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(372, '--', 372, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(373, '--', 373, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(374, '--', 374, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(375, '--', 375, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(376, '--', 376, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(377, '--', 377, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(378, '--', 378, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(379, '--', 379, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(380, '--', 380, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(381, '--', 381, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(382, '--', 382, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(383, '--', 383, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(384, '--', 384, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(385, '--', 385, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(386, '--', 386, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(387, '--', 387, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(388, '--', 388, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(389, '--', 389, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(390, '--', 390, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(391, '--', 391, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(392, '--', 392, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(393, '--', 393, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(394, '--', 394, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(395, '--', 395, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(396, '--', 396, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(397, '--', 397, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(398, '--', 398, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(399, '--', 399, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(400, '--', 400, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(401, '--', 401, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(402, '--', 402, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(403, '--', 403, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(404, '--', 404, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(405, '--', 405, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(406, '--', 406, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(407, '--', 407, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(408, '--', 408, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(409, '--', 409, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(410, '--', 410, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(411, '--', 411, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(412, '--', 412, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(413, '--', 413, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(414, '--', 414, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(415, '--', 415, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(416, '--', 416, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(417, '--', 417, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(418, '--', 418, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(419, '--', 419, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(420, '--', 420, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(421, '--', 421, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(422, '--', 422, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(423, '--', 423, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(424, '--', 424, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(425, '--', 425, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(426, '--', 426, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(427, '--', 427, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(428, '--', 428, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(429, '--', 429, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(430, '--', 430, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(431, '--', 431, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(432, '--', 432, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(433, '--', 433, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(434, '--', 434, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(435, '--', 435, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(436, '--', 436, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(437, '--', 437, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(438, '--', 438, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(439, '--', 439, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(440, '--', 440, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(441, '--', 441, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(442, '--', 442, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(443, '--', 443, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(444, '--', 444, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(445, '--', 445, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(446, '--', 446, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(447, '--', 447, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(448, '--', 448, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(449, '--', 449, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(450, '--', 450, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(451, '--', 451, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(452, '--', 452, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(453, '--', 453, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(454, '--', 454, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(455, '--', 455, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(456, '--', 456, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(457, '--', 457, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(458, '--', 458, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(459, '--', 459, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(460, '--', 460, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(461, '--', 461, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(462, '--', 462, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(463, '--', 463, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(464, '--', 464, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(465, '--', 465, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(466, '--', 466, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(467, '--', 467, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(468, '--', 468, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(469, '--', 469, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(470, '--', 470, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(471, '--', 471, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(472, '--', 472, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(473, '--', 473, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(474, '--', 474, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(475, '--', 475, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(476, '--', 476, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(477, '--', 477, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(478, '--', 478, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(479, '--', 479, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(480, '--', 480, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(481, '--', 481, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(482, '--', 482, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(483, '--', 483, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(484, '--', 484, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(485, '--', 485, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(486, '--', 486, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(487, '--', 487, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(488, '--', 488, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(489, '--', 489, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(490, '--', 490, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(491, '--', 491, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(492, '--', 492, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(493, '--', 493, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(494, '--', 494, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(495, '--', 495, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(496, '--', 496, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(497, '--', 497, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(498, '--', 498, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(499, '--', 499, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(500, '--', 500, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(501, '--', 501, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(502, '--', 502, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(503, '--', 503, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(504, '--', 504, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(505, '--', 505, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(506, '--', 506, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(507, '--', 507, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(508, '--', 508, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(509, '--', 509, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(510, '--', 510, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(511, '--', 511, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(512, '--', 512, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(513, '--', 513, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(514, '--', 514, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(515, '--', 515, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(516, '--', 516, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(517, '--', 517, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(518, '--', 518, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(519, '--', 519, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(520, '--', 520, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(521, '--', 521, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(522, '--', 522, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(523, '--', 523, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(524, '--', 524, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(525, '--', 525, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(526, '--', 526, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(527, '--', 527, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(528, '--', 528, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(529, '--', 529, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(530, '--', 530, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(531, '--', 531, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(532, '--', 532, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(533, '--', 533, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(534, '--', 534, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(535, '--', 535, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(536, '--', 536, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(537, '--', 537, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(538, '--', 538, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(539, '--', 539, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(540, '--', 540, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(541, '--', 541, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(542, '--', 542, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(543, '--', 543, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(544, '--', 544, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(545, '--', 545, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(546, '--', 546, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(547, '--', 547, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(548, '--', 548, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(549, '--', 549, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(550, '--', 550, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(551, '--', 551, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(552, '--', 552, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(553, '--', 553, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(554, '--', 554, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(555, '--', 555, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(556, '--', 556, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(557, '--', 557, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(558, '--', 558, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(559, '--', 559, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(560, '--', 560, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(561, '--', 561, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(562, '--', 562, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(563, '--', 563, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(564, '--', 564, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(565, '--', 565, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(566, '--', 566, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(567, '--', 567, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(568, '--', 568, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(569, '--', 569, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(570, '--', 570, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(571, '--', 571, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(572, '--', 572, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(573, '--', 573, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(574, '--', 574, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(575, '--', 575, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(576, '--', 576, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(577, '--', 577, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(578, '--', 578, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(579, '--', 579, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(580, '--', 580, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(581, '--', 581, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(582, '--', 582, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00');
INSERT INTO `taluka` (`taluka_id`, `name`, `district_id`, `status`, `is_deleted`, `added_by`, `added_date`, `last_updated_by`, `last_updated_date`) VALUES
(583, '--', 583, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(584, '--', 584, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(585, '--', 585, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(586, '--', 586, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(587, '--', 587, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(588, '--', 588, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(589, '--', 589, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(590, '--', 590, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(591, '--', 591, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(592, '--', 592, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(593, '--', 593, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(594, '--', 594, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(595, '--', 595, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(596, '--', 596, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(597, '--', 597, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(598, '--', 598, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(599, '--', 599, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(600, '--', 600, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(601, '--', 601, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(602, '--', 602, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(603, '--', 603, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(604, '--', 604, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(605, '--', 605, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(606, '--', 606, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(607, '--', 607, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(608, '--', 608, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(609, '--', 609, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(610, '--', 610, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(611, '--', 611, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(612, '--', 612, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(613, '--', 613, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(614, '--', 614, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(615, '--', 615, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(616, '--', 616, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(617, '--', 617, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(618, '--', 618, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(619, '--', 619, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(620, '--', 620, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(621, '--', 621, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(622, '--', 622, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(623, '--', 623, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(624, '--', 624, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(625, '--', 625, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(626, '--', 626, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(627, '--', 627, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(628, '--', 628, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(629, '--', 629, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(630, '--', 630, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(631, '--', 631, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(632, '--', 632, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(633, '--', 633, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(634, '--', 634, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(635, '--', 635, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(636, '--', 636, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(637, '--', 637, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(638, '--', 638, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(639, '--', 639, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(640, '--', 640, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(641, '--', 641, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(642, '--', 642, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(643, '--', 643, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(644, '--', 644, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(645, '--', 645, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(646, '--', 646, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(647, '--', 647, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(648, '--', 648, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(649, '--', 649, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(650, '--', 650, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(651, '--', 651, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(652, '--', 652, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(653, '--', 653, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(654, '--', 654, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(655, '--', 655, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(656, '--', 656, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(657, '--', 657, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(658, '--', 658, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(659, '--', 659, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(660, '--', 660, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(661, '--', 661, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(662, '--', 662, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(663, '--', 663, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(664, '--', 664, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(665, '--', 665, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(666, '--', 666, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(667, '--', 667, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(668, '--', 668, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(669, '--', 669, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(670, '--', 670, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(671, '--', 671, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(672, '--', 672, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(673, '--', 673, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(674, '--', 674, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(675, '--', 675, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(676, '--', 676, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(677, '--', 677, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(678, '--', 678, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(679, '--', 679, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(680, '--', 680, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(681, '--', 681, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(682, '--', 682, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(683, '--', 683, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(684, '--', 684, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(685, '--', 685, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(686, '--', 686, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(687, '--', 687, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(688, '--', 688, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(689, '--', 689, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(690, '--', 690, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(691, '--', 691, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(692, '--', 692, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(693, '--', 693, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(694, '--', 694, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(695, '--', 695, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(696, '--', 696, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(697, '--', 697, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(698, '--', 698, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(699, '--', 699, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(700, '--', 700, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(701, '--', 701, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(702, '--', 702, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(703, '--', 703, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(704, '--', 704, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(705, '--', 705, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(706, '--', 706, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(707, '--', 707, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(708, '--', 708, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(709, '--', 709, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(710, '--', 710, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(711, '--', 711, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(712, '--', 712, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(713, '--', 713, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(714, '--', 714, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(715, '--', 715, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(716, '--', 716, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(717, '--', 717, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(718, '--', 718, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(719, '--', 719, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(720, '--', 720, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(721, '--', 721, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(722, '--', 722, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(723, '--', 723, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(724, '--', 724, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(725, '--', 725, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(726, '--', 726, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(727, '--', 727, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(728, '--', 728, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(729, '--', 729, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(730, '--', 730, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(731, '--', 731, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(732, '--', 732, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(733, '--', 733, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(734, '--', 734, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(735, '--', 735, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(736, '--', 736, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(737, '--', 737, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(738, '--', 738, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(739, '--', 739, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(740, '--', 740, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00'),
(741, '--', 741, 'Active', 'No', 37, '0000-00-00 00:00:00', 37, '0000-00-00 00:00:00');

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

--
-- Table structure for table `transaction`
--

CREATE TABLE `transaction` (
  `transaction_id` int(11) NOT NULL,
  `registration_id` int(11) NOT NULL,
  `facility_id` int(11) NOT NULL,
  `status` enum('Active','Inactive') NOT NULL,
  `is_deleted` enum('No','Yes') NOT NULL,
  `added_by` int(11) NOT NULL,
  `added_date` datetime NOT NULL,
  `last_updated_by` int(11) NOT NULL,
  `last_updated_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transaction`
--

INSERT INTO `transaction` (`transaction_id`, `registration_id`, `facility_id`, `status`, `is_deleted`, `added_by`, `added_date`, `last_updated_by`, `last_updated_date`) VALUES
(1, 100, 1, 'Active', 'Yes', 2, '2026-06-05 17:16:28', 2, '2026-06-05 17:16:32');

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

--
-- Stand-in structure for view `view_sport_registration`
-- (See below for the actual view)
--
CREATE TABLE `view_sport_registration` (
`registration_id` int(11)
,`name` varchar(400)
,`mobile_whatsapp_no` varchar(100)
,`email_id` varchar(250)
,`sport_name` varchar(100)
,`payment_status` enum('Pending','Paid','Not applicable')
);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `access_log`
--
ALTER TABLE `access_log`
  ADD PRIMARY KEY (`access_log_id`);

--
-- Indexes for table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`category_id`);

--
-- Indexes for table `company`
--
ALTER TABLE `company`
  ADD PRIMARY KEY (`company_id`);

--
-- Indexes for table `config`
--
ALTER TABLE `config`
  ADD PRIMARY KEY (`config_id`);

--
-- Indexes for table `country`
--
ALTER TABLE `country`
  ADD PRIMARY KEY (`country_id`);

--
-- Indexes for table `facility`
--
ALTER TABLE `facility`
  ADD PRIMARY KEY (`facility_id`);

--
-- Indexes for table `feedback`
--
ALTER TABLE `feedback`
  ADD PRIMARY KEY (`feedback_id`);

--
-- Indexes for table `menu`
--
ALTER TABLE `menu`
  ADD PRIMARY KEY (`menu_id`),
  ADD KEY `menu_id` (`menu_id`,`title`,`parent_menu_id`,`url`,`icon`,`sequence`,`user_type`,`status`,`is_deleted`);

--
-- Indexes for table `registration_Org`
--
ALTER TABLE `registration_Org`
  ADD PRIMARY KEY (`registration_id`);

--
-- Indexes for table `registration_sport`
--
ALTER TABLE `registration_sport`
  ADD PRIMARY KEY (`registration_sport_id`);

--
-- Indexes for table `sms`
--
ALTER TABLE `sms`
  ADD PRIMARY KEY (`sms_id`);

--
-- Indexes for table `sport`
--
ALTER TABLE `sport`
  ADD PRIMARY KEY (`sport_id`);

--
-- Indexes for table `state`
--
ALTER TABLE `state`
  ADD PRIMARY KEY (`state_id`);

--
-- Indexes for table `status`
--
ALTER TABLE `status`
  ADD PRIMARY KEY (`status_id`);

--
-- Indexes for table `status_log`
--
ALTER TABLE `status_log`
  ADD PRIMARY KEY (`status_log_id`);

--
-- Indexes for table `taluka`
--
ALTER TABLE `taluka`
  ADD PRIMARY KEY (`taluka_id`);

--
-- Indexes for table `transaction`
--
ALTER TABLE `transaction`
  ADD PRIMARY KEY (`transaction_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `access_log`
--
ALTER TABLE `access_log`
  MODIFY `access_log_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=154;

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `category_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `company`
--
ALTER TABLE `company`
  MODIFY `company_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `config`
--
ALTER TABLE `config`
  MODIFY `config_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `country`
--
ALTER TABLE `country`
  MODIFY `country_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `facility`
--
ALTER TABLE `facility`
  MODIFY `facility_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `feedback`
--
ALTER TABLE `feedback`
  MODIFY `feedback_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `menu`
--
ALTER TABLE `menu`
  MODIFY `menu_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `registration_Org`
--
ALTER TABLE `registration_Org`
  MODIFY `registration_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `registration_sport`
--
ALTER TABLE `registration_sport`
  MODIFY `registration_sport_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sms`
--
ALTER TABLE `sms`
  MODIFY `sms_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sport`
--
ALTER TABLE `sport`
  MODIFY `sport_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `state`
--
ALTER TABLE `state`
  MODIFY `state_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `status`
--
ALTER TABLE `status`
  MODIFY `status_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `status_log`
--
ALTER TABLE `status_log`
  MODIFY `status_log_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `taluka`
--
ALTER TABLE `taluka`
  MODIFY `taluka_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=742;

--
-- AUTO_INCREMENT for table `transaction`
--
ALTER TABLE `transaction`
  MODIFY `transaction_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- Structure for view `view_sport_registration`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_sport_registration`  AS SELECT `r`.`registration_id` AS `registration_id`, `r`.`name` AS `name`, `r`.`mobile_whatsapp_no` AS `mobile_whatsapp_no`, `r`.`email_id` AS `email_id`, `s`.`name` AS `sport_name`, `r`.`payment_status` AS `payment_status` FROM ((`registration` `r` join `registration_sport` `rs` on(`r`.`registration_id` = `rs`.`registration_id`)) join `sport` `s` on(`rs`.`sport_id` = `s`.`sport_id`)) WHERE `r`.`is_deleted` = 'No' ORDER BY `r`.`registration_id` DESC ;
COMMIT;

