-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Jun 29, 2025 at 06:57 AM
-- Server version: 10.11.10-MariaDB-log
-- PHP Version: 7.2.34

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `u196857292_lm`
--

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

--
-- Table structure for table `sv_clusters`
--

CREATE TABLE `sv_clusters` (
  `id` int(11) NOT NULL,
  `admin_id` int(11) DEFAULT NULL,
  `state_id` int(11) DEFAULT NULL,
  `district_id` int(11) DEFAULT NULL,
  `taluka_id` int(11) DEFAULT NULL,
  `en_title` varchar(255) DEFAULT NULL,
  `hi_title` varchar(255) DEFAULT NULL,
  `gu_title` varchar(255) DEFAULT NULL,
  `village_ids` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sv_clusters`
--

INSERT INTO `sv_clusters` (`id`, `admin_id`, `state_id`, `district_id`, `taluka_id`, `en_title`, `hi_title`, `gu_title`, `village_ids`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 14, 100, 'Arnej Cluster', 'अरणेज क्लस्टर', 'અરણેજ ક્લસ્ટર', '5506,5508,5514,5520,5523,5524,5525,5533,5535,5545,5548,5549,5553,5557,5559', '2025-06-12 13:08:38', '2025-06-25 08:02:43'),
(2, 1, 1, 7, 63, 'Devaliya Cluster', 'देवलिया क्लस्टर', 'દેવળીયા ક્લસ્ટર', '3392,3401,3404,3414,3416,3418,3420,3421,3422,3425,3427,3428,3439,3441,3449,3453,3454,3456,3461,3464,3469,3472,3475,3479,3485,3489,3493,3496,3499,3501,3505,3507', '2025-06-15 13:03:35', '2025-06-25 08:31:31'),
(3, 1, 1, 7, 63, 'Mota Khuntavada Cluster', 'मोटा खूंटावड़ा क्लस्टर', 'મોટા ખુંટાવડા ક્લસ્ટર', '3359,3360,3367,3371,3372,3373,3374,3384,3385,3387,3388,3389,3392,3396,3398,3406,3408,3419,3424,3431,3444,3458,3460,3462,3466,3468,3491,3497,14277', '2025-06-15 13:04:45', '2025-06-26 12:18:07'),
(4, 1, 1, 7, 62, 'Jesar Cluster', 'जेसर क्लस्टर', 'જેશર ક્લસ્ટર', '1038,1043,1067,1084,1091,3356,3358,3361,3362,3363,3364,3365,3368,3369,3370,3375,3376,3378,3379,3380,3381,3382,3383,3386,3390,3391,14279', '2025-06-15 13:05:59', '2025-06-26 12:43:28'),
(5, 1, 1, 7, 63, 'Kalsar', 'कालसर', 'કાળસાર', '3402,3405,3412,3433,3438,3457,3467,3476,3477,3481,3482,3490,3495,3500,3502,3504', '2025-06-16 07:03:11', '2025-06-25 08:37:33'),
(6, 1, 1, 7, 63, 'Bagadana', 'बगदाना', 'બગદાણા', '3395,3407,3413,3415,3417,3423,3432,3436,3442,3446,3448,3459,3463,3471,3483,3486,3487,3492,3503,3506', '2025-06-21 07:17:52', '2025-06-25 08:41:05'),
(7, 1, 1, 7, 63, 'Cluster Mahuva', 'Cluster 5', 'Cluster 5', '3455', '2025-06-21 07:18:38', '2025-06-25 08:27:54'),
(12, 1, 1, 7, 63, 'Otha', 'ओथा', 'ઓથા', '3394,3397,3399,3400,3409,3411,3426,3429,3430,3435,3437,3440,3443,3450,3451,3452,3465,3470,3473,3474,3478,3480,3484,3494', '2025-06-25 08:30:21', '2025-06-25 08:53:05'),
(13, 1, 1, 2, 21, 'Khadasali', 'खड़सली', 'ખડસલી', '1018,1020,1024,1025,1026,1027,1028,1031,1034,1036,1040,1041,1045,1053,1057,1058,1059,1061,1070,1087,1089', '2025-06-25 08:49:37', '2025-06-25 08:49:37'),
(14, 1, 1, 7, 66, 'Manar Cluster', 'मणार क्लस्टर', 'મણાર ક્લસ્ટર', '3317,3322,3550,3667,3671,3707,3711,3725,3728,3730,3748,3770,3777,3837,3847', '2025-06-26 07:45:13', '2025-06-26 07:45:13'),
(15, 1, 1, 7, 66, 'Maidhar Cluster', 'माइधार क्लस्टर', 'માઇધાર ક્લસ્ટર', '3509,3518,3542,3543,3547,3552,3555,3559,3577,3669,3675,3676,3677,3690,3695,3719,3733,3751,3768,3771,3776', '2025-06-26 09:08:49', '2025-06-26 09:08:49'),
(16, 1, 1, 7, 65, 'Aambala Cluster', 'आंबला क्लस्टर', 'આંબલા ક્લસ્ટર', '3541,3589,3590,3599,3601,3607,3625,3628,3632,3634,3635,3636,3640,3647,3648,3650,3651,3659,3661,3663,3666,14278', '2025-06-26 10:37:50', '2025-06-26 10:58:39');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `sv_clusters`
--
ALTER TABLE `sv_clusters`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
