-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jul 12, 2017 at 02:14 PM
-- Server version: 5.6.17
-- PHP Version: 5.5.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 utf8 */;

--
-- Database: `kissan`
--

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

--
-- Table structure for table `aircooled`
--

CREATE TABLE IF NOT EXISTS `aircooled` (
  `aircooled_id` int(11) NOT NULL AUTO_INCREMENT,
  `aircooled_img` varchar(50) NOT NULL,
  `aircooled_display` varchar(50) NOT NULL,
  PRIMARY KEY (`aircooled_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `aircooled`
--

INSERT INTO `aircooled` (`aircooled_id`, `aircooled_img`, `aircooled_display`) VALUES
(2, 'aircooled_2.jpg', 'Y'),
(3, 'aircooled_3.jpg', 'Y'),
(4, 'aircooled_4.jpg', 'Y');

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

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

CREATE TABLE IF NOT EXISTS `certificate` (
  `certificate_id` int(11) NOT NULL AUTO_INCREMENT,
  `certificate_img` varchar(50) NOT NULL,
  `certificate_display` varchar(50) NOT NULL,
  PRIMARY KEY (`certificate_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

--
-- Table structure for table `cornmill`
--

CREATE TABLE IF NOT EXISTS `cornmill` (
  `cornmill_id` int(11) NOT NULL AUTO_INCREMENT,
  `cornmill_img` varchar(50) NOT NULL,
  `cornmill_display` varchar(50) NOT NULL,
  PRIMARY KEY (`cornmill_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

--
-- Table structure for table `cyclonemill`
--

CREATE TABLE IF NOT EXISTS `cyclonemill` (
  `cyclonemill_id` int(11) NOT NULL AUTO_INCREMENT,
  `cyclonemill_img` varchar(50) NOT NULL,
  `cyclonemill_display` varchar(50) NOT NULL,
  PRIMARY KEY (`cyclonemill_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

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

--
-- Table structure for table `dieselengines`
--

CREATE TABLE IF NOT EXISTS `dieselengines` (
  `dieselengines_id` int(11) NOT NULL AUTO_INCREMENT,
  `dieselengines_img` varchar(50) NOT NULL,
  `dieselengines_display` varchar(50) NOT NULL,
  PRIMARY KEY (`dieselengines_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

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

CREATE TABLE IF NOT EXISTS `gallery` (
  `gallery_id` int(11) NOT NULL AUTO_INCREMENT,
  `gallery_img` varchar(50) NOT NULL,
  `gallery_display` varchar(50) NOT NULL,
  PRIMARY KEY (`gallery_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

--
-- Table structure for table `gravitymill`
--

CREATE TABLE IF NOT EXISTS `gravitymill` (
  `gravitymill_id` int(11) NOT NULL AUTO_INCREMENT,
  `gravitymill_img` varchar(50) NOT NULL,
  `gravitymill_display` varchar(50) NOT NULL,
  PRIMARY KEY (`gravitymill_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

--
-- Table structure for table `login`
--

CREATE TABLE IF NOT EXISTS `login` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `login`
--

INSERT INTO `login` (`id`, `username`, `password`) VALUES
(1, 'kissan', 'Kissan@2017');

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

--
-- Table structure for table `modelsengines`
--

CREATE TABLE IF NOT EXISTS `modelsengines` (
  `modelsengines_id` int(11) NOT NULL AUTO_INCREMENT,
  `modelsengines_img` varchar(50) NOT NULL,
  `modelsengines_display` varchar(50) NOT NULL,
  PRIMARY KEY (`modelsengines_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

--
-- Table structure for table `pumpset`
--

CREATE TABLE IF NOT EXISTS `pumpset` (
  `pumpset_id` int(11) NOT NULL AUTO_INCREMENT,
  `pumpset_img` varchar(50) NOT NULL,
  `pumpset_display` varchar(50) NOT NULL,
  PRIMARY KEY (`pumpset_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

--
-- Table structure for table `ricehuller`
--

CREATE TABLE IF NOT EXISTS `ricehuller` (
  `ricehuller_id` int(11) NOT NULL AUTO_INCREMENT,
  `ricehuller_img` varchar(50) NOT NULL,
  `ricehuller_display` varchar(50) NOT NULL,
  PRIMARY KEY (`ricehuller_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

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

CREATE TABLE IF NOT EXISTS `slider` (
  `slider_id` int(11) NOT NULL AUTO_INCREMENT,
  `slider_img` varchar(50) NOT NULL,
  `slider_display` varchar(50) NOT NULL,
  PRIMARY KEY (`slider_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

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

--
-- Table structure for table `watercooled`
--

CREATE TABLE IF NOT EXISTS `watercooled` (
  `watercooled_id` int(11) NOT NULL AUTO_INCREMENT,
  `watercooled_img` varchar(50) NOT NULL,
  `watercooled_display` varchar(50) NOT NULL,
  PRIMARY KEY (`watercooled_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

--
-- Table structure for table `waterpumps`
--

CREATE TABLE IF NOT EXISTS `waterpumps` (
  `waterpumps_id` int(11) NOT NULL AUTO_INCREMENT,
  `waterpumps_img` varchar(50) NOT NULL,
  `waterpumps_display` varchar(50) NOT NULL,
  PRIMARY KEY (`waterpumps_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

/*!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 */;