-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Apr 06, 2022 at 03:07 AM
-- Server version: 5.7.36-cll-lve
-- PHP Version: 7.3.32

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

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

--
-- Table structure for table `chemical_states_new`
--

CREATE TABLE `chemical_states_new` (
  `STATE_ID` int(4) NOT NULL,
  `STATE_NAME` varchar(30) DEFAULT NULL,
  `ROOT_URL` varchar(100) DEFAULT NULL,
  `STATE_HOME` varchar(100) DEFAULT NULL,
  `LAST_PUBLISHED` varchar(12) DEFAULT NULL,
  `CREATED_BY` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `chemical_states_new`
--

INSERT INTO `chemical_states_new` (`STATE_ID`, `STATE_NAME`, `ROOT_URL`, `STATE_HOME`, `LAST_PUBLISHED`, `CREATED_BY`) VALUES
(1, 'Andhra Pradesh', 'https://www.indianconstructionindustry.com/indian_chemical_industry/andhra_pradesh.html', 'andhra_pradesh', NULL, ''),
(2, 'Assam', 'https://www.indianconstructionindustry.com/indian_chemical_industry/assam.html', 'assam', NULL, ''),
(3, 'Chandigarh', 'https://www.indianconstructionindustry.com/indian_chemical_industry/chandigarh.html', 'chandigarh', NULL, ''),
(4, 'Chattisgarh', 'https://www.indianconstructionindustry.com/indian_chemical_industry/chattisgarh.html', 'chattisgarh', NULL, ''),
(5, 'Daman & Diu', 'https://www.indianconstructionindustry.com/indian_chemical_industry/daman_diu.html', 'daman_diu', NULL, ''),
(6, 'Delhi', 'https://www.indianconstructionindustry.com/indian_chemical_industry/delhi.html', 'delhi', NULL, ''),
(8, 'Gujarat', 'https://www.indianconstructionindustry.com/indian_chemical_industry/gujarat.html', 'gujarat', NULL, ''),
(9, 'Haryana', 'https://www.indianconstructionindustry.com/indian_chemical_industry/haryana.html', 'haryana', NULL, ''),
(10, 'Jharkhand', 'https://www.indianconstructionindustry.com/indian_chemical_industry/jharkhand.html', 'jharkhand', NULL, ''),
(11, 'Karnataka', 'https://www.indianconstructionindustry.com/indian_chemical_industry/karnataka.html', 'karnataka', NULL, ''),
(12, 'Kerala', 'https://www.indianconstructionindustry.com/indian_chemical_industry/kerala.html', 'kerala', NULL, ''),
(13, 'Madhya Pradesh', 'https://www.indianconstructionindustry.com/indian_chemical_industry/madhya_pradesh.html', 'madhya_pradesh', NULL, ''),
(14, 'Maharashtra', 'https://www.indianconstructionindustry.com/indian_chemical_industry/maharashtra.html', 'maharashtra', NULL, ''),
(15, 'Orissa', 'https://www.indianconstructionindustry.com/indian_chemical_industry/orissa.html', 'orissa', NULL, ''),
(16, 'Pondicherry', 'https://www.indianconstructionindustry.com/indian_chemical_industry/pondicherry.html', 'pondicherry', NULL, ''),
(17, 'Punjab', 'https://www.indianconstructionindustry.com/indian_chemical_industry/punjab.html', 'punjab', NULL, ''),
(18, 'Rajasthan', 'https://www.indianconstructionindustry.com/indian_chemical_industry/rajasthan.html', 'rajasthan', NULL, ''),
(19, 'Tamil Nadu', 'https://www.indianconstructionindustry.com/indian_chemical_industry/tamilnadu.html', 'tamilnadu', NULL, ''),
(20, 'Uttar Pradesh', 'https://www.indianconstructionindustry.com/indian_chemical_industry/uttar_pradesh.html', 'uttar_pradesh', NULL, ''),
(21, 'Uttarakhand', 'https://www.indianconstructionindustry.com/indian_chemical_industry/uttarkhand.html', 'uttarkhand', NULL, ''),
(22, 'Uttaranchal', 'https://www.indianconstructionindustry.com/indian_chemical_industry/uttaranchal.html', 'uttaranchal', NULL, ''),
(23, 'West Bengal', 'https://www.indianconstructionindustry.com/indian_chemical_industry/west_bengal.html', 'west_bengal', NULL, ''),
(24, 'Telangana', 'https://www.indianconstructionindustry.com/indian_chemical_industry/telangana.html', 'telangana', NULL, ''),
(25, 'Himachal Pradesh', 'https://www.indianconstructionindustry.com/indian_chemical_industry/himachal_pradesh.html', 'himachal_pradesh', NULL, 'Sampath'),
(26, 'Goa', 'https://www.indianconstructionindustry.com/indian_chemical_industry/goa.html', 'goa', NULL, 'Sampath');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `chemical_states_new`
--
ALTER TABLE `chemical_states_new`
  ADD PRIMARY KEY (`STATE_ID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `chemical_states_new`
--
ALTER TABLE `chemical_states_new`
  MODIFY `STATE_ID` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
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 */;
