-- phpMyAdmin SQL Dump
-- version 5.1.1deb5ubuntu1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: May 06, 2026 at 04:41 AM
-- Server version: 8.0.45-0ubuntu0.22.04.1
-- PHP Version: 8.2.30

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: `test_db`
--

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

--
-- Table structure for table `balance`
--

CREATE TABLE `balance` (
  `balance_id` int NOT NULL,
  `Sub_No` int DEFAULT NULL,
  `TotAmt` int DEFAULT NULL,
  `RecAmt` int DEFAULT NULL,
  `Bal` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `directory_table`
--

CREATE TABLE `directory_table` (
  `idDirectory_table` int DEFAULT NULL,
  `Sub_No` int DEFAULT NULL,
  `Name` varchar(250) DEFAULT NULL,
  `Add1` varchar(250) DEFAULT NULL,
  `Add2` varchar(250) DEFAULT NULL,
  `Add3` varchar(250) DEFAULT NULL,
  `State` varchar(250) DEFAULT NULL,
  `City` varchar(250) DEFAULT NULL,
  `Area` varchar(250) DEFAULT NULL,
  `Pincode` varchar(250) DEFAULT NULL,
  `Phone_O` varchar(250) DEFAULT NULL,
  `Phone_R` varchar(250) DEFAULT NULL,
  `Mobile` varchar(250) DEFAULT NULL,
  `Fax` varchar(250) DEFAULT NULL,
  `Email` varchar(250) DEFAULT NULL,
  `Est` varchar(250) DEFAULT NULL,
  `Closing` varchar(250) DEFAULT NULL,
  `Bussi` varchar(250) DEFAULT NULL,
  `Dispensing` varchar(250) DEFAULT NULL,
  `LC` varchar(250) DEFAULT NULL,
  `Loc` varchar(250) DEFAULT NULL,
  `Cent` varchar(250) DEFAULT NULL,
  `Vat` varchar(250) DEFAULT NULL,
  `Name_Dir` varchar(250) DEFAULT NULL,
  `Directory_of_Product` varchar(250) DEFAULT NULL,
  `Brands` varchar(250) DEFAULT NULL,
  `Wholesale` varchar(250) DEFAULT NULL,
  `manufacturer` varchar(250) DEFAULT NULL,
  `s_manufacturer` varchar(250) DEFAULT NULL,
  `Product_Range` varchar(250) DEFAULT NULL,
  `Other` varchar(250) DEFAULT NULL,
  `Saving_Time` varchar(250) DEFAULT NULL,
  `Users` varchar(250) DEFAULT NULL,
  `Website` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `directory_tableF`
--

CREATE TABLE `directory_tableF` (
  `iddirectory_tableF` int NOT NULL,
  `Sub_No` int DEFAULT NULL,
  `Name` varchar(250) DEFAULT NULL,
  `Add1` varchar(250) DEFAULT NULL,
  `Add2` varchar(250) DEFAULT NULL,
  `Add3` varchar(250) DEFAULT NULL,
  `Country` varchar(255) DEFAULT NULL,
  `State` varchar(250) DEFAULT NULL,
  `City` varchar(250) DEFAULT NULL,
  `Area` varchar(250) DEFAULT NULL,
  `Pin` varchar(250) DEFAULT NULL,
  `Phone_O` varchar(250) DEFAULT NULL,
  `Phone_R` varchar(250) DEFAULT NULL,
  `Mobile` varchar(250) DEFAULT NULL,
  `Fax` varchar(250) DEFAULT NULL,
  `Email` varchar(250) DEFAULT NULL,
  `Est` varchar(250) DEFAULT NULL,
  `Closing` varchar(250) DEFAULT NULL,
  `Bussi` varchar(250) DEFAULT NULL,
  `Dispensing` varchar(250) DEFAULT NULL,
  `LC` varchar(250) DEFAULT NULL,
  `Loc` varchar(250) DEFAULT NULL,
  `Cent` varchar(250) DEFAULT NULL,
  `Vat` varchar(250) DEFAULT NULL,
  `Name_Dir` varchar(250) DEFAULT NULL,
  `Directory_of_Product` varchar(250) DEFAULT NULL,
  `Brands` varchar(250) DEFAULT NULL,
  `Wholesale` varchar(250) DEFAULT NULL,
  `manufacturer` varchar(250) DEFAULT NULL,
  `s_manufacturer` varchar(250) DEFAULT NULL,
  `Product_Range` varchar(250) DEFAULT NULL,
  `Other` varchar(250) DEFAULT NULL,
  `Website` varchar(500) DEFAULT NULL,
  `Saving_Time` varchar(250) DEFAULT NULL,
  `Users` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `directory_tableOLD`
--

CREATE TABLE `directory_tableOLD` (
  `idDirectory_table` int NOT NULL,
  `Sub_No` int DEFAULT NULL,
  `Name` varchar(250) DEFAULT NULL,
  `Add1` varchar(250) DEFAULT NULL,
  `Add2` varchar(250) DEFAULT NULL,
  `Add3` varchar(250) DEFAULT NULL,
  `State` varchar(250) DEFAULT NULL,
  `City` varchar(250) DEFAULT NULL,
  `Area` varchar(250) DEFAULT NULL,
  `Pincode` varchar(250) DEFAULT NULL,
  `Phone_O` varchar(250) DEFAULT NULL,
  `Phone_R` varchar(250) DEFAULT NULL,
  `Mobile` varchar(250) DEFAULT NULL,
  `Fax` varchar(250) DEFAULT NULL,
  `Email` varchar(250) DEFAULT NULL,
  `Est` varchar(250) DEFAULT NULL,
  `Closing` varchar(250) DEFAULT NULL,
  `Bussi` varchar(250) DEFAULT NULL,
  `Dispensing` varchar(250) DEFAULT NULL,
  `LC` varchar(250) DEFAULT NULL,
  `Loc` varchar(250) DEFAULT NULL,
  `Cent` varchar(250) DEFAULT NULL,
  `Vat` varchar(250) DEFAULT NULL,
  `Name_Dir` varchar(250) DEFAULT NULL,
  `Directory_of_Product` varchar(250) DEFAULT NULL,
  `Brands` varchar(250) DEFAULT NULL,
  `Wholesale` varchar(250) DEFAULT NULL,
  `manufacturer` varchar(250) DEFAULT NULL,
  `s_manufacturer` varchar(250) DEFAULT NULL,
  `Product_Range` varchar(250) DEFAULT NULL,
  `Other` varchar(250) DEFAULT NULL,
  `Saving_Time` varchar(250) DEFAULT NULL,
  `Users` varchar(250) DEFAULT NULL,
  `Website` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint UNSIGNED NOT NULL,
  `reserved_at` int UNSIGNED DEFAULT NULL,
  `available_at` int UNSIGNED NOT NULL,
  `created_at` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `Labele_Print`
--

CREATE TABLE `Labele_Print` (
  `LID` int NOT NULL,
  `Sub_No` varchar(100) DEFAULT NULL,
  `Title` varchar(100) DEFAULT NULL,
  `Name` varchar(100) DEFAULT NULL,
  `Add1` varchar(100) DEFAULT NULL,
  `Add2` varchar(100) DEFAULT NULL,
  `Add3` varchar(100) DEFAULT NULL,
  `State` varchar(100) DEFAULT NULL,
  `City` varchar(100) DEFAULT NULL,
  `Pin` varchar(100) DEFAULT NULL,
  `Phone_O` varchar(100) DEFAULT NULL,
  `Phone_R` varchar(100) DEFAULT NULL,
  `Mobile` varchar(100) DEFAULT NULL,
  `DT_Fr` varchar(100) DEFAULT NULL,
  `DT_Upto` varchar(100) DEFAULT NULL,
  `Issue_No` varchar(100) DEFAULT NULL,
  `Issue_Year` varchar(100) DEFAULT NULL,
  `Issue_Month` varchar(100) DEFAULT NULL,
  `Mode` varchar(100) DEFAULT NULL,
  `Issue_Year_selected` varchar(100) DEFAULT NULL,
  `Prt_Date` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `ladger`
--

CREATE TABLE `ladger` (
  `ladgerID` int NOT NULL,
  `Sub_No` varchar(1000) DEFAULT NULL,
  `DT` varchar(1000) DEFAULT NULL,
  `Payment` varchar(1000) DEFAULT NULL,
  `Amount` int DEFAULT NULL,
  `Discount` int DEFAULT NULL,
  `Balance` int DEFAULT NULL,
  `Total` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1);

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

--
-- Table structure for table `onttimesubs`
--

CREATE TABLE `onttimesubs` (
  `OID` int NOT NULL,
  `Sub_No` varchar(100) DEFAULT NULL,
  `Date_Upto` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `Reminder`
--

CREATE TABLE `Reminder` (
  `Remid` int NOT NULL,
  `Sub_No` varchar(100) DEFAULT NULL,
  `DT_Fr` datetime DEFAULT NULL,
  `DT_UP` datetime DEFAULT NULL,
  `Amount` int DEFAULT NULL,
  `Dates` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `remindertext`
--

CREATE TABLE `remindertext` (
  `RemID` int DEFAULT NULL,
  `remindertext` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `State`
--

CREATE TABLE `State` (
  `SSID1` int NOT NULL,
  `State` varchar(100) DEFAULT NULL,
  `City` varchar(100) DEFAULT NULL,
  `Pin` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `state_city`
--

CREATE TABLE `state_city` (
  `idstate_city` int NOT NULL,
  `State` varchar(100) DEFAULT NULL,
  `City` varchar(100) DEFAULT NULL,
  `Pin` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `State_CityF`
--

CREATE TABLE `State_CityF` (
  `SID` int NOT NULL,
  `City` varchar(255) DEFAULT NULL,
  `State` varchar(255) DEFAULT NULL,
  `Country` varchar(255) DEFAULT NULL,
  `Pin` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Subs`
--

CREATE TABLE `Subs` (
  `SID` int NOT NULL,
  `Title` varchar(50) DEFAULT NULL,
  `Sub_No` bigint DEFAULT NULL,
  `Name` varchar(100) DEFAULT NULL,
  `Add1` varchar(250) DEFAULT NULL,
  `Add2` varchar(250) DEFAULT NULL,
  `Add3` varchar(250) DEFAULT NULL,
  `State` varchar(50) DEFAULT NULL,
  `City` varchar(50) DEFAULT NULL,
  `Pin` varchar(7) DEFAULT NULL,
  `Phone_O` varchar(200) DEFAULT NULL,
  `Phone_R` varchar(200) DEFAULT NULL,
  `Mobile` varchar(250) DEFAULT NULL,
  `Fax` varchar(50) DEFAULT NULL,
  `Email` varchar(200) DEFAULT NULL,
  `DT_Fr` datetime DEFAULT NULL,
  `ModePayment` varchar(50) DEFAULT NULL,
  `Date_of_Payment` datetime DEFAULT NULL,
  `Amount` bigint DEFAULT NULL,
  `Subs_Amount` bigint DEFAULT NULL,
  `Discount` bigint DEFAULT NULL,
  `Balance` bigint DEFAULT NULL,
  `DT_Upto` datetime DEFAULT NULL,
  `Status` varchar(50) DEFAULT NULL,
  `Mode` varchar(50) DEFAULT NULL,
  `Comment` varchar(50) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `CID` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Subs1`
--

CREATE TABLE `Subs1` (
  `SID` int NOT NULL,
  `Title` varchar(100) DEFAULT NULL,
  `Sub_No` int DEFAULT NULL,
  `Name` varchar(100) DEFAULT NULL,
  `Add1` varchar(100) DEFAULT NULL,
  `Add2` varchar(100) DEFAULT NULL,
  `Add3` varchar(100) DEFAULT NULL,
  `State` varchar(100) DEFAULT NULL,
  `City` varchar(100) DEFAULT NULL,
  `Pin` varchar(100) DEFAULT NULL,
  `Phone_O` varchar(100) DEFAULT NULL,
  `Phone_R` varchar(100) DEFAULT NULL,
  `Mobile` varchar(100) DEFAULT NULL,
  `Fax` varchar(100) DEFAULT NULL,
  `Email` varchar(100) DEFAULT NULL,
  `DT_Fr` varchar(100) DEFAULT NULL,
  `ModePayment` varchar(100) DEFAULT NULL,
  `Date_of_Payment` varchar(100) DEFAULT NULL,
  `Amount` varchar(100) DEFAULT NULL,
  `Subs_Amount` varchar(100) DEFAULT NULL,
  `Discount` varchar(100) DEFAULT NULL,
  `Balance` varchar(100) DEFAULT NULL,
  `DT_Upto` varchar(100) DEFAULT NULL,
  `Status` varchar(100) DEFAULT NULL,
  `Mode` varchar(100) DEFAULT NULL,
  `Comment` varchar(100) DEFAULT NULL,
  `Date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_BLBrandMaster`
--

CREATE TABLE `Tbl_BLBrandMaster` (
  `ID` int NOT NULL,
  `Sub_No` bigint DEFAULT NULL,
  `BID` varchar(50) DEFAULT NULL,
  `BName` varchar(50) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `CUID` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_BLColorMaster`
--

CREATE TABLE `Tbl_BLColorMaster` (
  `ID` int NOT NULL,
  `COID` varchar(50) DEFAULT NULL,
  `CoName` varchar(50) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `CUID` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_BLComapnyPersonMaster`
--

CREATE TABLE `Tbl_BLComapnyPersonMaster` (
  `ID` int NOT NULL,
  `CMID` varchar(50) DEFAULT NULL,
  `Sub_No` int DEFAULT NULL,
  `Name` varchar(50) DEFAULT NULL,
  `Add1` varchar(50) DEFAULT NULL,
  `Add2` varchar(50) DEFAULT NULL,
  `Add3` varchar(50) DEFAULT NULL,
  `State` varchar(50) DEFAULT NULL,
  `City` varchar(50) DEFAULT NULL,
  `Pin` varchar(50) DEFAULT NULL,
  `Mobile` varchar(50) DEFAULT NULL,
  `Phone` varchar(50) DEFAULT NULL,
  `Email` varchar(50) DEFAULT NULL,
  `Pan` varchar(50) DEFAULT NULL,
  `GSTnumber` varchar(50) DEFAULT NULL,
  `OP_Balance` decimal(18,2) DEFAULT NULL,
  `De_Ce` varchar(50) DEFAULT NULL,
  `Brand` varchar(50) DEFAULT NULL,
  `CUID` int DEFAULT NULL,
  `PNaration` varchar(50) DEFAULT NULL,
  `PDate` datetime DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_BLCompanyPaymentDetails`
--

CREATE TABLE `Tbl_BLCompanyPaymentDetails` (
  `ID` int NOT NULL,
  `FaYear` int DEFAULT NULL,
  `PID` varchar(50) DEFAULT NULL,
  `CMID` varchar(50) DEFAULT NULL,
  `BLID` varchar(50) DEFAULT NULL,
  `Sub_No` int DEFAULT NULL,
  `ModeofPayment` varchar(50) DEFAULT NULL,
  `CDetails` varchar(50) DEFAULT NULL,
  `Narations` varchar(50) DEFAULT NULL,
  `PDate` datetime DEFAULT NULL,
  `Amount` decimal(18,2) DEFAULT NULL,
  `TDS` decimal(18,2) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `Status` int DEFAULT '0',
  `CUID` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_BLCompanyPersonDetails`
--

CREATE TABLE `Tbl_BLCompanyPersonDetails` (
  `ID` int NOT NULL,
  `FaYear` int DEFAULT NULL,
  `RID` int DEFAULT NULL,
  `BLID` varchar(50) DEFAULT NULL,
  `CMID` varchar(50) DEFAULT NULL,
  `Sub_No` int DEFAULT NULL,
  `HSN` varchar(50) DEFAULT NULL,
  `Currency` varchar(50) DEFAULT NULL,
  `Pages` varchar(50) DEFAULT NULL,
  `NoPages` varchar(50) DEFAULT NULL,
  `Colors` varchar(50) DEFAULT NULL,
  `Rate` decimal(18,2) DEFAULT NULL,
  `Discountper` decimal(18,2) DEFAULT NULL,
  `Discountpvalue` decimal(18,2) DEFAULT NULL,
  `SGSTper` decimal(18,2) DEFAULT NULL,
  `SGSTValue` decimal(18,2) DEFAULT NULL,
  `CGSTper` decimal(18,2) DEFAULT NULL,
  `CGSTValue` decimal(18,2) DEFAULT NULL,
  `IGSTper` decimal(18,2) DEFAULT NULL,
  `IGSTValue` decimal(18,2) DEFAULT NULL,
  `Month` varchar(50) DEFAULT NULL,
  `GTotal` decimal(18,2) DEFAULT NULL,
  `GSTN` varchar(50) DEFAULT NULL,
  `BDate` datetime DEFAULT NULL,
  `Emailsent` text,
  `Ladgersent` text,
  `Brands` varchar(50) DEFAULT NULL,
  `Issue` int DEFAULT NULL,
  `POD` varchar(50) DEFAULT NULL,
  `PODstatus` int DEFAULT '0',
  `PODDates` datetime DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `CUID` int DEFAULT NULL,
  `Status` int DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_BLCurrencyMaster`
--

CREATE TABLE `Tbl_BLCurrencyMaster` (
  `ID` int NOT NULL,
  `CID` varchar(50) DEFAULT NULL,
  `CName` varchar(50) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `CUID` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_BLGSTNumber`
--

CREATE TABLE `Tbl_BLGSTNumber` (
  `ID` int NOT NULL,
  `GST` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_BLHSNMaster`
--

CREATE TABLE `Tbl_BLHSNMaster` (
  `ID` int NOT NULL,
  `HID` varchar(50) DEFAULT NULL,
  `HName` varchar(50) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `CUID` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_BLNoofPagesMaster`
--

CREATE TABLE `Tbl_BLNoofPagesMaster` (
  `ID` int NOT NULL,
  `NID` varchar(50) DEFAULT NULL,
  `NPage` varchar(50) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `CUID` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_BLPagesMaster`
--

CREATE TABLE `Tbl_BLPagesMaster` (
  `ID` int NOT NULL,
  `PID` varchar(50) DEFAULT NULL,
  `PName` varchar(50) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `CUID` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_CityMaster`
--

CREATE TABLE `Tbl_CityMaster` (
  `CtyId` varchar(50) NOT NULL,
  `CtyCode` varchar(50) NOT NULL,
  `CtyName` varchar(50) DEFAULT NULL,
  `StateId` varchar(50) NOT NULL,
  `CtyPin` varchar(50) DEFAULT NULL,
  `CntryCode` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_CityMasterF`
--

CREATE TABLE `Tbl_CityMasterF` (
  `CtyId` varchar(50) NOT NULL,
  `CtyCode` varchar(50) NOT NULL,
  `CtyName` varchar(50) DEFAULT NULL,
  `StateId` varchar(50) NOT NULL,
  `CtyPin` varchar(50) DEFAULT NULL,
  `CntryCode` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_Country`
--

CREATE TABLE `Tbl_Country` (
  `CntryId` varchar(50) NOT NULL,
  `CntryCode` varchar(50) NOT NULL,
  `CntryName` varchar(50) DEFAULT NULL,
  `CntryStatus` tinyint(1) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_CountryF`
--

CREATE TABLE `Tbl_CountryF` (
  `CntryId` varchar(50) NOT NULL,
  `CntryCode` varchar(50) NOT NULL,
  `CntryName` varchar(50) DEFAULT NULL,
  `CntryStatus` tinyint(1) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_CouriorCompanyMaster`
--

CREATE TABLE `Tbl_CouriorCompanyMaster` (
  `ID` int NOT NULL,
  `CID` varchar(50) DEFAULT NULL,
  `CName` varchar(100) DEFAULT NULL,
  `Address` varchar(200) DEFAULT NULL,
  `Phone` varchar(50) DEFAULT NULL,
  `CUID` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_CouriorDetails`
--

CREATE TABLE `Tbl_CouriorDetails` (
  `ID` int NOT NULL,
  `Sub_No` int DEFAULT NULL,
  `Title` varchar(50) DEFAULT NULL,
  `Name` varchar(50) DEFAULT NULL,
  `Address` varchar(200) DEFAULT NULL,
  `State` varchar(50) DEFAULT NULL,
  `City` varchar(50) DEFAULT NULL,
  `Pin` varchar(50) DEFAULT NULL,
  `Mobile` varchar(50) DEFAULT NULL,
  `IssueYear` int DEFAULT NULL,
  `IssueNo` int DEFAULT NULL,
  `IssueMonth` varchar(50) DEFAULT NULL,
  `Mode` varchar(50) DEFAULT NULL,
  `IssueSelectYear` varchar(50) DEFAULT NULL,
  `Barcode` varchar(50) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `Status` int DEFAULT '0',
  `CID` int DEFAULT NULL,
  `D_Date` datetime DEFAULT NULL,
  `Remarks` varchar(50) DEFAULT NULL,
  `UUID` int DEFAULT NULL,
  `CourierCMP` varchar(50) DEFAULT NULL,
  `PDate` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_DIRBusinessMaster`
--

CREATE TABLE `Tbl_DIRBusinessMaster` (
  `ID` int NOT NULL,
  `BID` varchar(50) DEFAULT NULL,
  `BName` varchar(100) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `CUI` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_DIRDirectoryofProductMaster`
--

CREATE TABLE `Tbl_DIRDirectoryofProductMaster` (
  `ID` int NOT NULL,
  `PID` varchar(50) DEFAULT NULL,
  `PName` varchar(200) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `CUI` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_DIRForeignDirecotryDeleteDataMaster`
--

CREATE TABLE `Tbl_DIRForeignDirecotryDeleteDataMaster` (
  `iddirectory_tableF` int NOT NULL,
  `Sub_No` int DEFAULT NULL,
  `Name` varchar(250) DEFAULT NULL,
  `Add1` varchar(250) DEFAULT NULL,
  `Add2` varchar(250) DEFAULT NULL,
  `Add3` varchar(250) DEFAULT NULL,
  `Country` varchar(255) DEFAULT NULL,
  `State` varchar(250) DEFAULT NULL,
  `City` varchar(250) DEFAULT NULL,
  `Area` varchar(250) DEFAULT NULL,
  `Pin` varchar(250) DEFAULT NULL,
  `Phone_O` varchar(250) DEFAULT NULL,
  `Phone_R` varchar(250) DEFAULT NULL,
  `Mobile` varchar(250) DEFAULT NULL,
  `Fax` varchar(250) DEFAULT NULL,
  `Email` varchar(250) DEFAULT NULL,
  `Est` varchar(250) DEFAULT NULL,
  `Closing` varchar(250) DEFAULT NULL,
  `Bussi` varchar(250) DEFAULT NULL,
  `Dispensing` varchar(250) DEFAULT NULL,
  `LC` varchar(250) DEFAULT NULL,
  `Loc` varchar(250) DEFAULT NULL,
  `Cent` varchar(250) DEFAULT NULL,
  `Vat` varchar(250) DEFAULT NULL,
  `Name_Dir` varchar(250) DEFAULT NULL,
  `Directory_of_Product` varchar(250) DEFAULT NULL,
  `Brands` varchar(250) DEFAULT NULL,
  `Wholesale` varchar(250) DEFAULT NULL,
  `manufacturer` varchar(250) DEFAULT NULL,
  `s_manufacturer` varchar(250) DEFAULT NULL,
  `Product_Range` varchar(250) DEFAULT NULL,
  `Other` varchar(250) DEFAULT NULL,
  `Website` varchar(500) DEFAULT NULL,
  `Saving_Time` varchar(250) DEFAULT NULL,
  `Users` varchar(250) DEFAULT NULL,
  `DeleteID` datetime DEFAULT NULL,
  `Remarks` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_DIRForeignDirecotryMaster`
--

CREATE TABLE `Tbl_DIRForeignDirecotryMaster` (
  `iddirectory_tableF` int NOT NULL,
  `Sub_No` int DEFAULT NULL,
  `Name` varchar(250) DEFAULT NULL,
  `Add1` varchar(250) DEFAULT NULL,
  `Add2` varchar(250) DEFAULT NULL,
  `Add3` varchar(250) DEFAULT NULL,
  `Country` varchar(255) DEFAULT NULL,
  `State` varchar(250) DEFAULT NULL,
  `City` varchar(250) DEFAULT NULL,
  `Area` varchar(250) DEFAULT NULL,
  `Pin` varchar(250) DEFAULT NULL,
  `Phone_O` varchar(250) DEFAULT NULL,
  `Phone_R` varchar(250) DEFAULT NULL,
  `Mobile` varchar(250) DEFAULT NULL,
  `Fax` varchar(250) DEFAULT NULL,
  `Email` varchar(250) DEFAULT NULL,
  `Est` varchar(250) DEFAULT NULL,
  `Closing` varchar(250) DEFAULT NULL,
  `Bussi` varchar(250) DEFAULT NULL,
  `Dispensing` varchar(250) DEFAULT NULL,
  `LC` varchar(250) DEFAULT NULL,
  `Loc` varchar(250) DEFAULT NULL,
  `Cent` varchar(250) DEFAULT NULL,
  `Vat` varchar(250) DEFAULT NULL,
  `Name_Dir` varchar(250) DEFAULT NULL,
  `Directory_of_Product` varchar(250) DEFAULT NULL,
  `Brands` varchar(250) DEFAULT NULL,
  `Wholesale` varchar(250) DEFAULT NULL,
  `manufacturer` varchar(250) DEFAULT NULL,
  `s_manufacturer` varchar(250) DEFAULT NULL,
  `Product_Range` varchar(250) DEFAULT NULL,
  `Other` varchar(250) DEFAULT NULL,
  `Website` varchar(500) DEFAULT NULL,
  `Saving_Time` varchar(250) DEFAULT NULL,
  `Users` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_DIRIndianDirecotryDeleteDataMaster`
--

CREATE TABLE `Tbl_DIRIndianDirecotryDeleteDataMaster` (
  `idDirectory_table` int NOT NULL,
  `Sub_No` int DEFAULT NULL,
  `Name` varchar(250) DEFAULT NULL,
  `Add1` varchar(250) DEFAULT NULL,
  `Add2` varchar(250) DEFAULT NULL,
  `Add3` varchar(250) DEFAULT NULL,
  `State` varchar(250) DEFAULT NULL,
  `City` varchar(250) DEFAULT NULL,
  `Area` varchar(250) DEFAULT NULL,
  `Pincode` varchar(7) DEFAULT NULL,
  `Phone_O` varchar(250) DEFAULT NULL,
  `Phone_R` varchar(250) DEFAULT NULL,
  `Mobile` varchar(250) DEFAULT NULL,
  `Fax` varchar(250) DEFAULT NULL,
  `Email` varchar(250) DEFAULT NULL,
  `Est` varchar(250) DEFAULT NULL,
  `Closing` varchar(250) DEFAULT NULL,
  `Bussi` varchar(250) DEFAULT NULL,
  `Dispensing` varchar(250) DEFAULT NULL,
  `LC` varchar(250) DEFAULT NULL,
  `Loc` varchar(250) DEFAULT NULL,
  `Cent` varchar(250) DEFAULT NULL,
  `Vat` varchar(250) DEFAULT NULL,
  `Name_Dir` varchar(250) DEFAULT NULL,
  `Directory_of_Product` varchar(250) DEFAULT NULL,
  `Brands` varchar(250) DEFAULT NULL,
  `Wholesale` varchar(250) DEFAULT NULL,
  `manufacturer` varchar(250) DEFAULT NULL,
  `s_manufacturer` varchar(250) DEFAULT NULL,
  `Product_Range` varchar(250) DEFAULT NULL,
  `Other` varchar(250) DEFAULT NULL,
  `Saving_Time` varchar(50) DEFAULT NULL,
  `Users` varchar(250) DEFAULT NULL,
  `Website` varchar(500) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `EmailSendDate` datetime DEFAULT NULL,
  `SMSSendDate` datetime DEFAULT NULL,
  `SendCUID` int DEFAULT NULL,
  `DeleteID` datetime DEFAULT NULL,
  `Remarks` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_DIRIndianDirecotryMaster`
--

CREATE TABLE `Tbl_DIRIndianDirecotryMaster` (
  `idDirectory_table` int NOT NULL,
  `Sub_No` int DEFAULT NULL,
  `Name` varchar(250) DEFAULT NULL,
  `Add1` varchar(250) DEFAULT NULL,
  `Add2` varchar(250) DEFAULT NULL,
  `Add3` varchar(250) DEFAULT NULL,
  `State` varchar(250) DEFAULT NULL,
  `City` varchar(250) DEFAULT NULL,
  `Area` varchar(250) DEFAULT NULL,
  `Pincode` varchar(250) DEFAULT NULL,
  `Phone_O` varchar(250) DEFAULT NULL,
  `Phone_R` varchar(250) DEFAULT NULL,
  `Mobile` varchar(250) DEFAULT NULL,
  `Fax` varchar(250) DEFAULT NULL,
  `Email` varchar(250) DEFAULT NULL,
  `Est` varchar(250) DEFAULT NULL,
  `Closing` varchar(250) DEFAULT NULL,
  `Bussi` varchar(250) DEFAULT NULL,
  `Dispensing` varchar(250) DEFAULT NULL,
  `LC` varchar(250) DEFAULT NULL,
  `Loc` varchar(250) DEFAULT NULL,
  `Cent` varchar(250) DEFAULT NULL,
  `Vat` varchar(250) DEFAULT NULL,
  `Name_Dir` varchar(250) DEFAULT NULL,
  `Directory_of_Product` varchar(250) DEFAULT NULL,
  `Brands` varchar(250) DEFAULT NULL,
  `Wholesale` varchar(250) DEFAULT NULL,
  `manufacturer` varchar(250) DEFAULT NULL,
  `s_manufacturer` varchar(250) DEFAULT NULL,
  `Product_Range` varchar(250) DEFAULT NULL,
  `Other` varchar(250) DEFAULT NULL,
  `Saving_Time` varchar(50) DEFAULT NULL,
  `Users` varchar(250) DEFAULT NULL,
  `Website` varchar(500) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `SendCUID` int DEFAULT NULL,
  `EmailSendDate` datetime DEFAULT NULL,
  `SMSSendDate` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_DIRManufactureMaster`
--

CREATE TABLE `Tbl_DIRManufactureMaster` (
  `ID` int NOT NULL,
  `MID` varchar(50) DEFAULT NULL,
  `MName` varchar(50) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `CUI` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_DIRProductRangeMaster`
--

CREATE TABLE `Tbl_DIRProductRangeMaster` (
  `ID` int NOT NULL,
  `PRID` varchar(50) DEFAULT NULL,
  `PRName` varchar(50) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `CUI` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_DIRSunGlassesMaster`
--

CREATE TABLE `Tbl_DIRSunGlassesMaster` (
  `ID` int NOT NULL,
  `SID` varchar(50) DEFAULT NULL,
  `SName` varchar(50) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `CUI` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_DIRWholsalerMaster`
--

CREATE TABLE `Tbl_DIRWholsalerMaster` (
  `ID` int NOT NULL,
  `WID` varchar(50) DEFAULT NULL,
  `WName` varchar(100) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `CUI` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_Domain`
--

CREATE TABLE `Tbl_Domain` (
  `DID` int NOT NULL,
  `Domain` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_EmailSettings`
--

CREATE TABLE `Tbl_EmailSettings` (
  `ID` int NOT NULL,
  `EmailID` varchar(50) DEFAULT NULL,
  `Password` varchar(50) DEFAULT NULL,
  `Port` int DEFAULT NULL,
  `Smtp` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_EmailTextMaster`
--

CREATE TABLE `Tbl_EmailTextMaster` (
  `ID` int NOT NULL,
  `EmailSubject` varchar(200) DEFAULT NULL,
  `EmailText` varchar(500) DEFAULT NULL,
  `EmailAtt` varchar(200) DEFAULT NULL,
  `CUID` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `Domain` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_FormDetails`
--

CREATE TABLE `Tbl_FormDetails` (
  `FormID` int NOT NULL,
  `FormName` varchar(50) NOT NULL,
  `Form` varchar(50) DEFAULT NULL,
  `FormStatus` tinyint(1) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `Uid` int DEFAULT NULL,
  `UseInDomain` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_FormPermission`
--

CREATE TABLE `Tbl_FormPermission` (
  `PermissionID` int NOT NULL,
  `BID` varchar(50) DEFAULT NULL,
  `Domain` varchar(50) DEFAULT NULL,
  `UserId` int NOT NULL,
  `FormId` int NOT NULL,
  `Pread` tinyint(1) NOT NULL,
  `Pwrite` tinyint(1) NOT NULL,
  `Pupdate` tinyint(1) NOT NULL,
  `Uid` int DEFAULT NULL,
  `Status` tinyint(1) DEFAULT NULL,
  `Createdate` datetime DEFAULT NULL,
  `Updatedate` datetime DEFAULT NULL,
  `UUid` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_LabelePrintDetails`
--

CREATE TABLE `Tbl_LabelePrintDetails` (
  `LID` int NOT NULL,
  `Sub_No` int DEFAULT NULL,
  `Title` varchar(50) DEFAULT NULL,
  `Name` varchar(50) DEFAULT NULL,
  `Add1` varchar(200) DEFAULT NULL,
  `Add2` varchar(200) DEFAULT NULL,
  `Add3` varchar(200) DEFAULT NULL,
  `State` varchar(50) DEFAULT NULL,
  `City` varchar(50) DEFAULT NULL,
  `Pin` varchar(50) DEFAULT NULL,
  `Phone_O` varchar(100) DEFAULT NULL,
  `Phone_R` varchar(100) DEFAULT NULL,
  `Mobile` varchar(200) DEFAULT NULL,
  `DT_Fr` datetime DEFAULT NULL,
  `DT_Upto` datetime DEFAULT NULL,
  `Issue_No` int DEFAULT NULL,
  `Issue_Year` int DEFAULT NULL,
  `Issue_Month` varchar(50) DEFAULT NULL,
  `Mode` varchar(50) DEFAULT NULL,
  `Issue_Year_selected` varchar(50) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `CID` int DEFAULT NULL,
  `CStatus` int DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_Ladger`
--

CREATE TABLE `Tbl_Ladger` (
  `ladgerID` int NOT NULL,
  `Sub_No` varchar(50) DEFAULT NULL,
  `DT` datetime DEFAULT NULL,
  `Payment` varchar(50) DEFAULT NULL,
  `Amount` bigint DEFAULT NULL,
  `Discount` bigint DEFAULT NULL,
  `Balance` bigint DEFAULT NULL,
  `Total` bigint DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `CID` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_LoginStatus`
--

CREATE TABLE `Tbl_LoginStatus` (
  `LoginID` varchar(50) DEFAULT NULL,
  `Domain` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_PaymentMode`
--

CREATE TABLE `Tbl_PaymentMode` (
  `ID` int DEFAULT NULL,
  `PaymentMode` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_Prefix`
--

CREATE TABLE `Tbl_Prefix` (
  `ID` int NOT NULL,
  `Prefix` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_ReminderText`
--

CREATE TABLE `Tbl_ReminderText` (
  `ID` int NOT NULL,
  `RText` varchar(500) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `CID` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_Rolemaster`
--

CREATE TABLE `Tbl_Rolemaster` (
  `RoleId` int NOT NULL,
  `RoleName` varchar(50) NOT NULL,
  `RoleDescription` varchar(50) DEFAULT NULL,
  `Uid` int DEFAULT NULL,
  `CreateDate` datetime DEFAULT NULL,
  `Status` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_SMSSetting`
--

CREATE TABLE `Tbl_SMSSetting` (
  `Auth` varchar(200) DEFAULT NULL,
  `SenderId` varchar(50) DEFAULT NULL,
  `Route` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_SMSSettings`
--

CREATE TABLE `Tbl_SMSSettings` (
  `ID` int NOT NULL,
  `SenderId` varchar(50) DEFAULT NULL,
  `Auth` varchar(250) DEFAULT NULL,
  `Route` varchar(50) DEFAULT NULL,
  `UserName` varchar(50) DEFAULT NULL,
  `Password` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_SMSTextMaster`
--

CREATE TABLE `Tbl_SMSTextMaster` (
  `ID` int NOT NULL,
  `SMSText` varchar(200) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `CUID` int DEFAULT NULL,
  `Domain` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_StateMaster`
--

CREATE TABLE `Tbl_StateMaster` (
  `ID` int NOT NULL,
  `StateId` varchar(50) NOT NULL,
  `StateCode` varchar(10) NOT NULL,
  `CntryId` varchar(50) NOT NULL,
  `StateName` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_StateMasterF`
--

CREATE TABLE `Tbl_StateMasterF` (
  `StateId` varchar(50) NOT NULL,
  `StateCode` varchar(10) NOT NULL,
  `CntryId` varchar(50) NOT NULL,
  `StateName` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_SubYSBS`
--

CREATE TABLE `Tbl_SubYSBS` (
  `YID` int NOT NULL,
  `DateFrom` datetime DEFAULT NULL,
  `DateTo` datetime DEFAULT NULL,
  `Amount` bigint DEFAULT NULL,
  `Year` int DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_TableADVT`
--

CREATE TABLE `Tbl_TableADVT` (
  `SID` int NOT NULL,
  `Title` varchar(50) DEFAULT NULL,
  `Sub_No` varchar(50) DEFAULT NULL,
  `Name` varchar(100) DEFAULT NULL,
  `Add1` varchar(250) DEFAULT NULL,
  `Add2` varchar(250) DEFAULT NULL,
  `Add3` varchar(250) DEFAULT NULL,
  `State` varchar(50) DEFAULT NULL,
  `City` varchar(50) DEFAULT NULL,
  `Pin` varchar(50) DEFAULT NULL,
  `Phone_O` varchar(200) DEFAULT NULL,
  `Phone_R` varchar(200) DEFAULT NULL,
  `Mobile` varchar(250) DEFAULT NULL,
  `Fax` varchar(50) DEFAULT NULL,
  `Email` varchar(200) DEFAULT NULL,
  `DT_Fr` datetime DEFAULT NULL,
  `Status` varchar(50) DEFAULT NULL,
  `Mode` varchar(50) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `CID` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_TableCompli`
--

CREATE TABLE `Tbl_TableCompli` (
  `SID` int NOT NULL,
  `Title` varchar(50) DEFAULT NULL,
  `Sub_No` varchar(50) DEFAULT NULL,
  `Name` varchar(100) DEFAULT NULL,
  `Add1` varchar(250) DEFAULT NULL,
  `Add2` varchar(250) DEFAULT NULL,
  `Add3` varchar(250) DEFAULT NULL,
  `State` varchar(50) DEFAULT NULL,
  `City` varchar(50) DEFAULT NULL,
  `Pin` varchar(50) DEFAULT NULL,
  `Phone_O` varchar(200) DEFAULT NULL,
  `Phone_R` varchar(200) DEFAULT NULL,
  `Mobile` varchar(250) DEFAULT NULL,
  `Fax` varchar(50) DEFAULT NULL,
  `Email` varchar(200) DEFAULT NULL,
  `DT_Fr` datetime DEFAULT NULL,
  `Status` varchar(50) DEFAULT NULL,
  `Mode` varchar(50) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `CID` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `Tbl_UserInformation`
--

CREATE TABLE `Tbl_UserInformation` (
  `UserInfoId` int NOT NULL,
  `BID` varchar(50) DEFAULT NULL,
  `Name` varchar(50) DEFAULT NULL,
  `Designation` varchar(50) DEFAULT NULL,
  `MobileNo` varchar(50) DEFAULT NULL,
  `UserLoginId` varchar(50) NOT NULL,
  `Password` varchar(50) NOT NULL,
  `MailPassword` varchar(50) DEFAULT NULL,
  `RoleId` int NOT NULL,
  `UserStatus` tinyint(1) NOT NULL DEFAULT '1',
  `Domain` varchar(50) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `Uid` int DEFAULT NULL,
  `Super` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 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 `balance`
--
ALTER TABLE `balance`
  ADD PRIMARY KEY (`balance_id`);

--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`),
  ADD KEY `cache_expiration_index` (`expiration`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`),
  ADD KEY `cache_locks_expiration_index` (`expiration`);

--
-- Indexes for table `directory_tableF`
--
ALTER TABLE `directory_tableF`
  ADD PRIMARY KEY (`iddirectory_tableF`);

--
-- Indexes for table `directory_tableOLD`
--
ALTER TABLE `directory_tableOLD`
  ADD PRIMARY KEY (`idDirectory_table`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

--
-- Indexes for table `Labele_Print`
--
ALTER TABLE `Labele_Print`
  ADD PRIMARY KEY (`LID`);

--
-- Indexes for table `ladger`
--
ALTER TABLE `ladger`
  ADD PRIMARY KEY (`ladgerID`);

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

--
-- Indexes for table `onttimesubs`
--
ALTER TABLE `onttimesubs`
  ADD PRIMARY KEY (`OID`);

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `Reminder`
--
ALTER TABLE `Reminder`
  ADD PRIMARY KEY (`Remid`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `State`
--
ALTER TABLE `State`
  ADD PRIMARY KEY (`SSID1`);

--
-- Indexes for table `state_city`
--
ALTER TABLE `state_city`
  ADD PRIMARY KEY (`idstate_city`);

--
-- Indexes for table `State_CityF`
--
ALTER TABLE `State_CityF`
  ADD PRIMARY KEY (`SID`);

--
-- Indexes for table `Subs`
--
ALTER TABLE `Subs`
  ADD PRIMARY KEY (`SID`);

--
-- Indexes for table `Subs1`
--
ALTER TABLE `Subs1`
  ADD PRIMARY KEY (`SID`);

--
-- Indexes for table `Tbl_BLBrandMaster`
--
ALTER TABLE `Tbl_BLBrandMaster`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Tbl_BLColorMaster`
--
ALTER TABLE `Tbl_BLColorMaster`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Tbl_BLComapnyPersonMaster`
--
ALTER TABLE `Tbl_BLComapnyPersonMaster`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Tbl_BLCompanyPaymentDetails`
--
ALTER TABLE `Tbl_BLCompanyPaymentDetails`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Tbl_BLCompanyPersonDetails`
--
ALTER TABLE `Tbl_BLCompanyPersonDetails`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Tbl_BLCurrencyMaster`
--
ALTER TABLE `Tbl_BLCurrencyMaster`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Tbl_BLGSTNumber`
--
ALTER TABLE `Tbl_BLGSTNumber`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Tbl_BLHSNMaster`
--
ALTER TABLE `Tbl_BLHSNMaster`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Tbl_BLNoofPagesMaster`
--
ALTER TABLE `Tbl_BLNoofPagesMaster`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Tbl_BLPagesMaster`
--
ALTER TABLE `Tbl_BLPagesMaster`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Tbl_CouriorCompanyMaster`
--
ALTER TABLE `Tbl_CouriorCompanyMaster`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Tbl_CouriorDetails`
--
ALTER TABLE `Tbl_CouriorDetails`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Tbl_DIRBusinessMaster`
--
ALTER TABLE `Tbl_DIRBusinessMaster`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Tbl_DIRDirectoryofProductMaster`
--
ALTER TABLE `Tbl_DIRDirectoryofProductMaster`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Tbl_DIRForeignDirecotryDeleteDataMaster`
--
ALTER TABLE `Tbl_DIRForeignDirecotryDeleteDataMaster`
  ADD PRIMARY KEY (`iddirectory_tableF`);

--
-- Indexes for table `Tbl_DIRForeignDirecotryMaster`
--
ALTER TABLE `Tbl_DIRForeignDirecotryMaster`
  ADD PRIMARY KEY (`iddirectory_tableF`);

--
-- Indexes for table `Tbl_DIRIndianDirecotryDeleteDataMaster`
--
ALTER TABLE `Tbl_DIRIndianDirecotryDeleteDataMaster`
  ADD PRIMARY KEY (`idDirectory_table`);

--
-- Indexes for table `Tbl_DIRIndianDirecotryMaster`
--
ALTER TABLE `Tbl_DIRIndianDirecotryMaster`
  ADD PRIMARY KEY (`idDirectory_table`);

--
-- Indexes for table `Tbl_DIRManufactureMaster`
--
ALTER TABLE `Tbl_DIRManufactureMaster`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Tbl_DIRProductRangeMaster`
--
ALTER TABLE `Tbl_DIRProductRangeMaster`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Tbl_DIRSunGlassesMaster`
--
ALTER TABLE `Tbl_DIRSunGlassesMaster`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Tbl_DIRWholsalerMaster`
--
ALTER TABLE `Tbl_DIRWholsalerMaster`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Tbl_Domain`
--
ALTER TABLE `Tbl_Domain`
  ADD PRIMARY KEY (`DID`);

--
-- Indexes for table `Tbl_EmailSettings`
--
ALTER TABLE `Tbl_EmailSettings`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Tbl_EmailTextMaster`
--
ALTER TABLE `Tbl_EmailTextMaster`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Tbl_FormDetails`
--
ALTER TABLE `Tbl_FormDetails`
  ADD PRIMARY KEY (`FormID`);

--
-- Indexes for table `Tbl_FormPermission`
--
ALTER TABLE `Tbl_FormPermission`
  ADD PRIMARY KEY (`PermissionID`);

--
-- Indexes for table `Tbl_LabelePrintDetails`
--
ALTER TABLE `Tbl_LabelePrintDetails`
  ADD PRIMARY KEY (`LID`);

--
-- Indexes for table `Tbl_Ladger`
--
ALTER TABLE `Tbl_Ladger`
  ADD PRIMARY KEY (`ladgerID`);

--
-- Indexes for table `Tbl_Prefix`
--
ALTER TABLE `Tbl_Prefix`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Tbl_ReminderText`
--
ALTER TABLE `Tbl_ReminderText`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Tbl_Rolemaster`
--
ALTER TABLE `Tbl_Rolemaster`
  ADD PRIMARY KEY (`RoleId`);

--
-- Indexes for table `Tbl_SMSSettings`
--
ALTER TABLE `Tbl_SMSSettings`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Tbl_SMSTextMaster`
--
ALTER TABLE `Tbl_SMSTextMaster`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Tbl_StateMaster`
--
ALTER TABLE `Tbl_StateMaster`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `Tbl_SubYSBS`
--
ALTER TABLE `Tbl_SubYSBS`
  ADD PRIMARY KEY (`YID`);

--
-- Indexes for table `Tbl_TableADVT`
--
ALTER TABLE `Tbl_TableADVT`
  ADD PRIMARY KEY (`SID`);

--
-- Indexes for table `Tbl_TableCompli`
--
ALTER TABLE `Tbl_TableCompli`
  ADD PRIMARY KEY (`SID`);

--
-- Indexes for table `Tbl_UserInformation`
--
ALTER TABLE `Tbl_UserInformation`
  ADD PRIMARY KEY (`UserInfoId`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `balance`
--
ALTER TABLE `balance`
  MODIFY `balance_id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `directory_tableF`
--
ALTER TABLE `directory_tableF`
  MODIFY `iddirectory_tableF` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `directory_tableOLD`
--
ALTER TABLE `directory_tableOLD`
  MODIFY `idDirectory_table` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Labele_Print`
--
ALTER TABLE `Labele_Print`
  MODIFY `LID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ladger`
--
ALTER TABLE `ladger`
  MODIFY `ladgerID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `onttimesubs`
--
ALTER TABLE `onttimesubs`
  MODIFY `OID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Reminder`
--
ALTER TABLE `Reminder`
  MODIFY `Remid` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `State`
--
ALTER TABLE `State`
  MODIFY `SSID1` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `state_city`
--
ALTER TABLE `state_city`
  MODIFY `idstate_city` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `State_CityF`
--
ALTER TABLE `State_CityF`
  MODIFY `SID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Subs`
--
ALTER TABLE `Subs`
  MODIFY `SID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Subs1`
--
ALTER TABLE `Subs1`
  MODIFY `SID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_BLBrandMaster`
--
ALTER TABLE `Tbl_BLBrandMaster`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_BLColorMaster`
--
ALTER TABLE `Tbl_BLColorMaster`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_BLComapnyPersonMaster`
--
ALTER TABLE `Tbl_BLComapnyPersonMaster`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_BLCompanyPaymentDetails`
--
ALTER TABLE `Tbl_BLCompanyPaymentDetails`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_BLCompanyPersonDetails`
--
ALTER TABLE `Tbl_BLCompanyPersonDetails`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_BLCurrencyMaster`
--
ALTER TABLE `Tbl_BLCurrencyMaster`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_BLGSTNumber`
--
ALTER TABLE `Tbl_BLGSTNumber`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_BLHSNMaster`
--
ALTER TABLE `Tbl_BLHSNMaster`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_BLNoofPagesMaster`
--
ALTER TABLE `Tbl_BLNoofPagesMaster`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_BLPagesMaster`
--
ALTER TABLE `Tbl_BLPagesMaster`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_CouriorCompanyMaster`
--
ALTER TABLE `Tbl_CouriorCompanyMaster`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_CouriorDetails`
--
ALTER TABLE `Tbl_CouriorDetails`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_DIRBusinessMaster`
--
ALTER TABLE `Tbl_DIRBusinessMaster`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_DIRDirectoryofProductMaster`
--
ALTER TABLE `Tbl_DIRDirectoryofProductMaster`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_DIRForeignDirecotryDeleteDataMaster`
--
ALTER TABLE `Tbl_DIRForeignDirecotryDeleteDataMaster`
  MODIFY `iddirectory_tableF` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_DIRForeignDirecotryMaster`
--
ALTER TABLE `Tbl_DIRForeignDirecotryMaster`
  MODIFY `iddirectory_tableF` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_DIRIndianDirecotryDeleteDataMaster`
--
ALTER TABLE `Tbl_DIRIndianDirecotryDeleteDataMaster`
  MODIFY `idDirectory_table` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_DIRIndianDirecotryMaster`
--
ALTER TABLE `Tbl_DIRIndianDirecotryMaster`
  MODIFY `idDirectory_table` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_DIRManufactureMaster`
--
ALTER TABLE `Tbl_DIRManufactureMaster`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_DIRProductRangeMaster`
--
ALTER TABLE `Tbl_DIRProductRangeMaster`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_DIRSunGlassesMaster`
--
ALTER TABLE `Tbl_DIRSunGlassesMaster`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_DIRWholsalerMaster`
--
ALTER TABLE `Tbl_DIRWholsalerMaster`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_Domain`
--
ALTER TABLE `Tbl_Domain`
  MODIFY `DID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_EmailSettings`
--
ALTER TABLE `Tbl_EmailSettings`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_EmailTextMaster`
--
ALTER TABLE `Tbl_EmailTextMaster`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_FormDetails`
--
ALTER TABLE `Tbl_FormDetails`
  MODIFY `FormID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_FormPermission`
--
ALTER TABLE `Tbl_FormPermission`
  MODIFY `PermissionID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_LabelePrintDetails`
--
ALTER TABLE `Tbl_LabelePrintDetails`
  MODIFY `LID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_Ladger`
--
ALTER TABLE `Tbl_Ladger`
  MODIFY `ladgerID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_Prefix`
--
ALTER TABLE `Tbl_Prefix`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_ReminderText`
--
ALTER TABLE `Tbl_ReminderText`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_Rolemaster`
--
ALTER TABLE `Tbl_Rolemaster`
  MODIFY `RoleId` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_SMSSettings`
--
ALTER TABLE `Tbl_SMSSettings`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_SMSTextMaster`
--
ALTER TABLE `Tbl_SMSTextMaster`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_StateMaster`
--
ALTER TABLE `Tbl_StateMaster`
  MODIFY `ID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_SubYSBS`
--
ALTER TABLE `Tbl_SubYSBS`
  MODIFY `YID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_TableADVT`
--
ALTER TABLE `Tbl_TableADVT`
  MODIFY `SID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_TableCompli`
--
ALTER TABLE `Tbl_TableCompli`
  MODIFY `SID` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Tbl_UserInformation`
--
ALTER TABLE `Tbl_UserInformation`
  MODIFY `UserInfoId` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint 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 */;