-- phpMyAdmin SQL Dump
-- version 5.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Oct 12, 2022 at 01:32 PM
-- Server version: 10.4.11-MariaDB
-- PHP Version: 7.4.2

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `tsredco`
--

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

--
-- Table structure for table `abstract_of_surveys`
--

CREATE TABLE `abstract_of_surveys` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `district` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `uib_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `survey_done_by` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `additional_details`
--

CREATE TABLE `additional_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `karach_dar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jilla` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `taluka` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gram` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `divabatti_kar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `aarogya_kar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `panipatti_kar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `panipatti_special_kar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `allotusers`
--

CREATE TABLE `allotusers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jilla` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `taluka` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gram` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `area_masters`
--

CREATE TABLE `area_masters` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `area_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `super_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sarpanch_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `bharanks`
--

CREATE TABLE `bharanks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `jilla` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `taluka` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gram` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `types` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amt` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ghasaras`
--

CREATE TABLE `ghasaras` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `jilla` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `taluka` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gram` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `types` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `०_२` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `३_५` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `६_१०` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `११_२०` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `२१_३०` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `३१_४०` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `४१_५०` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `५१_६०` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `६१_पेक्षा_जास्त` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `gramuserallots`
--

CREATE TABLE `gramuserallots` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jilla` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `taluka` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gram` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `gramusers`
--

CREATE TABLE `gramusers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `gram_panchayat_materials`
--

CREATE TABLE `gram_panchayat_materials` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `district` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mandal` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gram` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description_of_dismantled` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remark` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `inwards`
--

CREATE TABLE `inwards` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `jilla_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `maker_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `num_drivers` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `num_spd` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tiltable_adapters` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `led_wattage_18` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `led_wattage_35` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `led_wattage_70` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `led_wattage_110` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `led_wattage_190` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `buffer_stock` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(2, '2021_10_07_101639_create_area_masters_table', 1),
(3, '2021_10_07_104136_create_survey_infos_table', 1),
(4, '2021_10_07_104204_create_survey_details_table', 1),
(5, '2021_10_09_101837_create_registers_table', 1),
(6, '2021_11_27_084240_create_varnans_table', 1),
(7, '2021_11_27_110612_create_readyreknals_table', 1),
(8, '2021_11_27_110746_create_bharanks_table', 1),
(9, '2021_11_27_110835_create_ghasaras_table', 1),
(10, '2021_12_17_080911_create_additional_details_table', 1),
(11, '2022_02_20_104514_create_allotusers_table', 1),
(12, '2022_03_11_110330_create_gramusers_table', 1),
(13, '2022_03_11_114513_create_gramuserallots_table', 1),
(14, '2022_09_15_064102_create_gram_panchayat_materials_table', 1),
(15, '2022_09_18_055946_create_abstract_of_surveys_table', 1),
(16, '2022_10_12_100438_create_inwards_table', 2);

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

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `readyreknals`
--

CREATE TABLE `readyreknals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `jilla` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `taluka` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gram` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `types` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `registers`
--

CREATE TABLE `registers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `survey_details`
--

CREATE TABLE `survey_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sq_ft` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sq_mtr` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `readyreknal` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `depression` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bharank` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `survey_infos`
--

CREATE TABLE `survey_infos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `s_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jilla_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `taluka_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gram_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `location` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `road_width` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `road_confi` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `switch_point` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pole_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pole_other` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pole_side` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pole_height` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pole_spacing` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type_of_fixture` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fixture_wattage` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `warranty_existing` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Condition_existing` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `earth_condition` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `arms_clamps_required` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dedicated_available` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `netword_issue_1` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `netword_issue_2` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `LED_wattage` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remark` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cable_user` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `types_of_arms` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reducer_used` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `minimast_clamp_used` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `added_by` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `varnans`
--

CREATE TABLE `varnans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `row_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `abstract_of_surveys`
--
ALTER TABLE `abstract_of_surveys`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `additional_details`
--
ALTER TABLE `additional_details`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `allotusers`
--
ALTER TABLE `allotusers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `area_masters`
--
ALTER TABLE `area_masters`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bharanks`
--
ALTER TABLE `bharanks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ghasaras`
--
ALTER TABLE `ghasaras`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `gramuserallots`
--
ALTER TABLE `gramuserallots`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `gramusers`
--
ALTER TABLE `gramusers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `gram_panchayat_materials`
--
ALTER TABLE `gram_panchayat_materials`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `inwards`
--
ALTER TABLE `inwards`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `readyreknals`
--
ALTER TABLE `readyreknals`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `registers`
--
ALTER TABLE `registers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `survey_details`
--
ALTER TABLE `survey_details`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `survey_infos`
--
ALTER TABLE `survey_infos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `varnans`
--
ALTER TABLE `varnans`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
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 */;
