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

START TRANSACTION;



--
-- Database: `asteknetsol_kissangroup`
--

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

--
-- Table structure for table `about`
--

CREATE TABLE `about` (
  `id` int(11) NOT NULL,
  `h1` varchar(200) COLLATE utf8mb3_bin NOT NULL,
  `p1` varchar(800) COLLATE utf8mb3_bin NOT NULL,
  `h2` varchar(200) COLLATE utf8mb3_bin NOT NULL,
  `h3` varchar(222) COLLATE utf8mb3_bin NOT NULL,
  `h4` varchar(222) COLLATE utf8mb3_bin NOT NULL,
  `h5` varchar(222) COLLATE utf8mb3_bin NOT NULL,
  `h6` varchar(222) COLLATE utf8mb3_bin NOT NULL,
  `h7` varchar(222) COLLATE utf8mb3_bin NOT NULL,
  `p2` varchar(800) COLLATE utf8mb3_bin NOT NULL,
  `p3` varchar(800) COLLATE utf8mb3_bin NOT NULL,
  `h8` varchar(222) COLLATE utf8mb3_bin NOT NULL,
  `p4` varchar(800) COLLATE utf8mb3_bin NOT NULL,
  `h9` varchar(222) COLLATE utf8mb3_bin NOT NULL,
  `p5` varchar(800) COLLATE utf8mb3_bin NOT NULL,
  `h10` varchar(222) COLLATE utf8mb3_bin NOT NULL,
  `p6` varchar(800) COLLATE utf8mb3_bin NOT NULL,
  `h11` varchar(222) COLLATE utf8mb3_bin NOT NULL,
  `p7` varchar(800) COLLATE utf8mb3_bin NOT NULL,
  `h12` varchar(222) COLLATE utf8mb3_bin NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

--
-- Dumping data for table `about`
--

INSERT INTO `about` (`id`, `h1`, `p1`, `h2`, `h3`, `h4`, `h5`, `h6`, `h7`, `p2`, `p3`, `h8`, `p4`, `h9`, `p5`, `h10`, `p6`, `h11`, `p7`, `h12`) VALUES
(1, 'About us - Kissan Iron Works ESTD 1966', 'Kissan group is a well renowned group of India and Kissan Iron Works is a one of the company of Kissan group. Since 1966 Kissan Iron Works as per certificate of government of India. Kissan Iron Works is a leading manufacturer of Diesel Engines, Water pumps &amp; pumping sets, which are mainly used in Agricultures, Industries, Home and General requirement for power Generation and water. Our brand name Kissan Shakti have grown today to a leading company for manufacturing and exporting Diesel Engines and other products.', 'PRODUCTS:-', 'Lister &amp; Petter type Diesel Engines (Water cooled &amp; Air cooled)', 'Water Pumps and Pumping set', 'Cyclone, Gravity, 1A &amp; 2A type Maize/corn Grinding Mill.', 'Rice Huller and Sugarcane Crusher', 'PRODUCT QUALITY :-', 'The products manufactured at Kissan Iron Works India are as per ISO 9001:2008 specification and are keeping in mind the customer\'s requirements and rapidly changing technology. The products are cost effective and to ensure quality each product undergoes a prescribed range of tests based on standards under the supervision of our Quality Inspectors.', 'High output, flexibility and comfort are all key features in our range of products. Our products offer straightforward, hassle-free irrigation and power generation with high productivity and consistent durability, as well as a choice of traditional or new modern designs.', 'INFRASTRUCTURE :-', 'Technical professional and experienced has led the company reach glorious heights since the beginning. Kissan Iron Works, India has production unit in Agra .Unit are well equipped with latest technology. Kissan Iron Works, India has a production capacity up to. 50,000 Diesel Engines, Pump sets and centrifugal water pumps per annum.', 'ACHIEVEMENTS :-', 'In line with our commitment towards Quality, we wish to inform you that our Company is registered as Government recognized Star Export House and It has been regularly winning Export Excellence awards from Engineering export promotion council of the ministry of commerce, Government of India towards maximum contribution in exports.', 'CLIENTELE :-', 'On time execution and timely delivery of our products has enabled us to gain a good repute amongst our clients in domestic as well as international market. Our products have been widely used and appreciated for their high quality and we have been able to maintain a long term relationship with our satisfied clients. We have set milestones in Latin America, Germany, Middle East, Asia, Africa and many more names in the ever growing client list.', 'WE AIM AT :-', 'The capability of Kissan Iron Works, India to satisfy clientele worldwide has made the company confident that it can serve and support customers better always.', 'WE INVITE NEW BUSINESS PROPOSALS, TIE -UPS AND BUSINESS VENTURES FROM ACROSS THE GLOBE.');

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

--
-- Table structure for table `certificate`
--

CREATE TABLE `certificate` (
  `certificate_id` int(11) NOT NULL,
  `certificate_img` varchar(50) NOT NULL,
  `certificate_display` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `certificate`
--

INSERT INTO `certificate` (`certificate_id`, `certificate_img`, `certificate_display`) VALUES
(14, 'certificate_14.jpg', 'Y'),
(15, 'certificate_15.jpg', 'Y'),
(16, 'certificate_16.jpg', 'Y'),
(17, 'certificate_17.jpg', 'Y'),
(18, 'certificate_18.jpg', 'Y'),
(19, 'certificate_19.jpg', 'Y'),
(20, 'certificate_20.jpg', 'Y'),
(21, 'certificate_21.jpg', 'Y'),
(22, 'certificate_22.jpg', 'Y'),
(23, 'certificate_23.jpg', 'Y'),
(24, 'certificate_24.jpg', 'Y'),
(25, 'certificate_25.jpg', 'Y');

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

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `gallery_id` int(11) NOT NULL,
  `gallery_img` varchar(50) NOT NULL,
  `gallery_display` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` (`gallery_id`, `gallery_img`, `gallery_display`) VALUES
(1, 'gallery_1.jpg', 'Y'),
(2, 'gallery_2.jpg', 'Y'),
(3, 'gallery_3.jpg', 'Y'),
(4, 'gallery_4.jpg', 'Y'),
(5, 'gallery_5.jpg', 'Y'),
(6, 'gallery_6.jpg', 'Y'),
(7, 'gallery_7.jpg', 'Y'),
(8, 'gallery_8.jpg', 'Y'),
(9, 'gallery_9.jpg', 'Y'),
(10, 'gallery_10.jpg', 'Y'),
(11, 'gallery_11.jpg', 'Y'),
(12, 'gallery_12.jpg', 'Y'),
(13, 'gallery_13.jpg', 'Y'),
(14, 'gallery_14.jpg', 'Y'),
(15, 'gallery_15.jpg', 'Y'),
(16, 'gallery_16.jpg', 'Y'),
(17, 'gallery_17.jpg', 'Y'),
(18, 'gallery_18.jpg', 'Y'),
(19, 'gallery_19.jpg', 'Y'),
(20, 'gallery_20.jpg', 'Y');

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

--
-- Table structure for table `network`
--

CREATE TABLE `network` (
  `network_id` int(11) NOT NULL,
  `network_img` varchar(50) COLLATE utf8mb3_bin NOT NULL,
  `network_display` varchar(50) COLLATE utf8mb3_bin NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

--
-- Dumping data for table `network`
--

INSERT INTO `network` (`network_id`, `network_img`, `network_display`) VALUES
(1, 'network_1.jpg', 'Y');

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

--
-- Table structure for table `slider`
--

CREATE TABLE `slider` (
  `slider_id` int(11) NOT NULL,
  `slider_img` varchar(50) NOT NULL,
  `slider_display` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `certificate`
--
ALTER TABLE `certificate`
  ADD PRIMARY KEY (`certificate_id`);

--
-- Indexes for table `gallery`
--
ALTER TABLE `gallery`
  ADD PRIMARY KEY (`gallery_id`);

--
-- Indexes for table `network`
--
ALTER TABLE `network`
  ADD PRIMARY KEY (`network_id`);

--
-- Indexes for table `slider`
--
ALTER TABLE `slider`
  ADD PRIMARY KEY (`slider_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `certificate`
--
ALTER TABLE `certificate`
  MODIFY `certificate_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `gallery`
--
ALTER TABLE `gallery`
  MODIFY `gallery_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

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

--
-- AUTO_INCREMENT for table `slider`
--
ALTER TABLE `slider`
  MODIFY `slider_id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

