במ12[aspddfsdfsdfdrxcvxcvcxvxcvxcvxcvxcvxcvxcvxcvxcvxxvxcvxcvxcv;'

]]jkjjgdjffksdkdfdkfjgsldkfhgjkgjkhjkgjkdascxvxcvxcvjdklfgjslkdfgjlskdfgjdskfgj במ12[aspddfsdfsdfdrxcvxcvcxvxcvxcvxcvxcvxcvxcvxcvxcvxxvxcvxcvxcv;'

-- phpMyAdmin SQL Dump
-- version 4.0.10.18
-- https://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Apr 27, 2017 at 11:10 AM
-- Server version: 5.6.35-cll-lve
-- PHP Version: 5.6.30

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

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

--
-- Table structure for table `admin`
--

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

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `username`, `password`, `status`) VALUES
(1, 'admin', 'admin@12345', 1);

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

--
-- Table structure for table `category`
--

CREATE TABLE IF NOT EXISTS `category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(50) NOT NULL,
  `ranking` varchar(11) NOT NULL,
  `status` int(11) NOT NULL COMMENT '1=active,2=non-active',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `category`, `ranking`, `status`) VALUES
(1, 'Homepage', '1', 1),
(2, 'About', '2', 1),
(3, 'Activities', '#', 1),
(4, 'KVK Staff', '#', 1),
(5, 'Events', '0', 1),
(6, 'Gallery', '3', 1),
(7, 'Contact', '4', 1),
(8, 'Useful-Link', '5', 1),
(9, ' Useful Downloads', '0', 1);

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

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

CREATE TABLE IF NOT EXISTS `gallery` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `img_ext` varchar(100) NOT NULL,
  `ranking` int(10) NOT NULL,
  `added_date` datetime NOT NULL,
  `status` int(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=41 ;

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

INSERT INTO `gallery` (`id`, `title`, `img_ext`, `ranking`, `added_date`, `status`) VALUES
(1, 'Field Day on DSR of Rice/Basmati at village Dhana Shahid, Block Zira, Ferozepur on 09-07-15 by KVK Ferozepur', 'jpg', 0, '0000-00-00 00:00:00', 0),
(2, 'Mass Awareness programme on "Eradication of Congress grass, a noxious weed" ', 'jpg', 1, '2015-08-02 00:00:00', 0),
(3, 'Diagnostic Farmer Field Visit Sugarcrane Crop at Vill Ratol', 'jpg', 3, '2015-08-02 00:00:00', 0),
(4, 'Arvi Field Visit At Bareke', 'jpg', 4, '2015-08-02 00:00:00', 1),
(5, 'Recording of Talk on "Safe Use of Chemicals in Agriculture" At All India Radio', 'jpg', 5, '2015-08-02 00:00:00', 0),
(6, 'Farmers Training Camp in Collaboration with NFL, Ferozepur, 26-07-15', 'jpg', 6, '2015-08-02 00:00:00', 1),
(8, 'Campaign from 19- 22 August, 2015 -Practical strategies to  combat the menance of Whitefly on cotton in Villages of ferozepur, faridkot and muktsar from', 'jpg', 1, '2015-09-19 00:00:00', 1),
(9, 'Campaign from 19- 22 August, 2015 -Practical strategies to  combat the menance of Whitefly on cotton in Villages of ferozepur, faridkot and muktsar from', 'jpg', 1, '2015-09-19 00:00:00', 1),
(10, 'KIsan Sammelan Organised at Baje Ke, Ferozepur dated 24.8.2015', 'jpg', 2, '2015-09-19 00:00:00', 1),
(11, 'Survey on cottonfly problem by KVK Scientists  DAted 28.8.2015', 'jpg', 3, '2015-09-19 00:00:00', 1),
(12, 'Field Visit - Cotton and Brinjal  field visits at vill. Piyareana on 5.9.2015', 'jpg', 4, '2015-09-19 00:00:00', 1),
(13, 'Awareness Camp - Eradication of parthenium  an alternate host of mealy bug  at toot on 8.9.2015', 'jpg', 5, '2015-09-19 00:00:00', 1),
(14, 'Awareness Camp - Eradication of parthenium  an alternate host of mealy bug  at toot on 8.9.2015', 'jpg', 5, '2015-09-19 00:00:00', 1),
(15, 'Survey cum Campaign -Whitefly  attack on Bt cotton at vill Beehlewal, Dhab, Bhangekalan & Mamallo in  Faridkot and muktsar district', 'jpg', 6, '2015-09-19 00:00:00', 1),
(16, 'KVK Ferozepur Participated in  KIsan Divas at RS faridkot  dated 15.9.2015', 'jpg', 7, '2015-09-19 00:00:00', 1),
(17, 'Member BOM, PAU and Kinnow Queen Madam  Kamaljeet Kaur Danewalia  Watching the KVK fzr Exhibition on RS Faridkot Kisan Divas dated 15.9.2015', 'jpg', 0, '0000-00-00 00:00:00', 1),
(18, 'Kisan Goshthi- Cultivation of Mushropom at KVK , Ferozepur dated 18.9.2015', 'jpg', 8, '2015-09-19 00:00:00', 1),
(19, 'KVK in Media', 'jpg', 8, '2015-09-19 00:00:00', 1),
(20, 'Vocational Training on Mushroom Cultivation at KVK, FZR dated 14.9.15 - 18.9.2015', 'jpg', 10, '2015-09-20 00:00:00', 0),
(21, 'Vocational Training on Dhnigri Mushroom Cultivation at KVK FZr dated 14.9.15 - 18.9.15', 'jpg', 10, '2015-09-20 00:00:00', 0),
(22, 'Invited Lecture on Flower Cultivation during  Seminar Organised By Sahibjada Ajit Singh Public School on 17.11.15', 'jpg', 1, '2015-11-23 00:00:00', 1),
(23, 'Method demonstration on planting of flower seedling  at  Sahibjada Ajit Singh Public School during a seminar on 17.11 .15', 'jpg', 2, '2015-11-23 00:00:00', 1),
(24, 'Distribution of KVK training literature among the staff and students of Sahibjada Ajit Singh Public School', 'jpg', 3, '2015-11-23 00:00:00', 1),
(25, 'Distribution of Soil Health Cards on 5.12.2015 at KVK Ferozepur', 'jpg', 1, '2015-12-09 00:00:00', 1),
(26, 'Celebrations of Jai Kisan Jai Vigyan Diwas at Village Dhandi Qadim of District Fazilka', 'jpg', 1, '2015-12-29 00:00:00', 1),
(27, 'DD Jalandhar Coverage - Jai Kisan Jai Vigyan Diwas at Village Dhandi Qadim of District Fazilka', 'jpg', 1, '2015-12-29 00:00:00', 1),
(28, 'Literature distribution - On occasion of State Level Animal Fair and Milking Competiotion ; Dec 1, 2015', 'jpg', 1, '2015-12-29 00:00:00', 1),
(29, 'Farmer Field visit to Evaluate the Progress of  LOw Tunnel Technology in Capsicum crop at Vill. Loombri wala ; Dec 9, 2015', 'jpg', 3, '2015-12-29 00:00:00', 1),
(30, 'Diagnostic Visit- Gurmail Singh Vill Hastiwala ; Dec  9, 2015', 'jpg', 5, '2015-12-29 00:00:00', 1),
(31, 'Diagnostic field visit for chilly crop', 'jpg', 4, '2016-02-08 00:00:00', 1),
(32, 'Awareness camp at adopted village Changali Jadid, Ferozepur dated 8.3.2016', 'jpg', 1, '0000-00-00 00:00:00', 1),
(33, 'Kisan Camp at Adopted Village Karmoowala - 16.5.2016', 'jpg', 1, '2016-05-29 00:00:00', 1),
(34, 'Sh. Vaneet Kumar, ADC, Ferozepur interacting with farmers  of adopted village Dheera Patra during the   Kisan Samellan dated 18.5.2016', 'jpg', 2, '2016-05-29 00:00:00', 1),
(35, 'Field Day on  Summer Moong   in adopted village Dhira Patra  dated 18.5.2016', 'jpg', 2, '2016-05-29 00:00:00', 1),
(36, 'Campaign on soil and water tessting   in adopted village Dhira Patra  dated 10.5.2016', 'jpg', 3, '2016-05-29 00:00:00', 1),
(37, 'Honorable Member Parliament Sh.  S.S. Ghubhaya   inaugurating  the Kisan Sammellan on Pradhan Mantri Fasal Bima Yojana  at KVK, Ferozepur  dated 3.4.2016', 'jpg', 4, '2016-05-29 00:00:00', 1),
(38, 'Workshop on BASMATI EXPORT organised in collaboration with BEDF Meerut', '', 2, '0000-00-00 00:00:00', 1),
(39, 'Save Environment', 'jpg', 23, '2016-10-20 00:00:00', 1),
(40, 'Save Environment', 'jpg', 22, '2016-10-20 00:00:00', 1);

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

--
-- Table structure for table `gallery_horti`
--

CREATE TABLE IF NOT EXISTS `gallery_horti` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `img_ext` varchar(100) NOT NULL,
  `ranking` int(10) NOT NULL,
  `added_date` datetime NOT NULL,
  `status` int(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `gallery_horti`
--

INSERT INTO `gallery_horti` (`id`, `title`, `img_ext`, `ranking`, `added_date`, `status`) VALUES
(1, 'Arvi Field Visit At Bareke', 'jpg', 1, '2016-02-08 00:00:00', 1),
(2, 'Promotion of protected and off season cultivation of Indra Capsicum', 'jpg', 2, '2016-02-08 00:00:00', 1),
(3, 'Inspection and spot guidance of farmers field to avoid whitefly attack on potato crop at Butasinghwala Village', 'jpg', 3, '2016-02-08 00:00:00', 1),
(4, 'Method demostration on preparation of compost of mushroom at KVK Ferozeppur', 'jpg', 4, '2016-02-08 00:00:00', 1),
(5, 'Promotion and distribution of PAU recommended mushroom spawn', 'jpg', 5, '2016-02-08 00:00:00', 1),
(6, 'Farmer field visit to evaluate the progress of recommended low tunnel technology in capsicum crop at village Loombriwala by KVK Ferozepur Scientists', 'jpg', 6, '2016-02-08 00:00:00', 1),
(7, 'Diagnostic visit at farmer field of village Hastiwala dated 9.12.2015 by KVK Ferozepur Scientist', 'jpg', 7, '2016-02-08 00:00:00', 1),
(8, 'Diagnostic field visit for chilly crop', 'jpg', 15, '2016-02-09 00:00:00', 1),
(9, 'Exposure Visit at International Mega Food Technology Park', 'jpg', 2, '2016-02-09 00:00:00', 1),
(10, 'Introduction of new crop of marigold at KVK Ferozepur', 'jpg', 2, '2016-02-09 00:00:00', 1),
(12, 'Evaluation of Implemented Kitchen Gardens in Dhira Patra Adopted VIllage - May, 2016', 'jpg', 2, '0000-00-00 00:00:00', 1),
(13, 'Method demonstration on layout of soil and water management  in polyhouse during training vocational trainig  May, 2016', 'jpg', 1, '2016-05-29 00:00:00', 1),
(14, 'Vocational Training at KVK Ferozepur on poyhouse/ nethouse - May, 2016', 'jpg', 3, '2016-05-29 00:00:00', 1),
(15, 'Awareness programme opn Skill development  for rural women of adopted village wahkamour- may, 2016', 'jpg', 4, '2016-05-29 00:00:00', 1),
(16, 'Method demonstration on training and pruning of ber tree  dated 11.5.2016', 'jpg', 4, '2016-05-29 00:00:00', 1);

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

--
-- Table structure for table `news`
--

CREATE TABLE IF NOT EXISTS `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(150) NOT NULL,
  `content` varchar(255) NOT NULL,
  `added_date` datetime NOT NULL,
  `ranking` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id`, `title`, `content`, `added_date`, `ranking`, `status`) VALUES
(1, 'Quality Improvement', 'KVK conducted workshop on "Quality Improvement in Production of Basmati Rice for Export" on April1, 2015..', '2015-08-02 00:00:00', 1, 1),
(2, 'Farmers Activity', 'Let us all work towards putting the seed of thought in the mind of our farming community so that they can reap the harvest of motivation to adopt the latest technology in agriculture and allied activities', '2015-03-25 00:00:00', 2, 1),
(3, 'Awareness Camp Organised', 'KVK Ferozepur Organises an Awareness camp on "Eradication of parthenium  an alternate host of mealy bug" at Village Toot dated  8 Sept, 2015', '2015-09-19 00:00:00', 4, 1),
(4, 'Jai Kisan Jai Vigyan Diwas', 'KVK Ferozepur Celebrated  Jai Kisan Jai Vigyan Diwas at Vill Dhandi Qadim, Fazilka', '2015-12-29 00:00:00', 5, 1);

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

--
-- Table structure for table `php_pages`
--

CREATE TABLE IF NOT EXISTS `php_pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `page` varchar(50) NOT NULL,
  `title` varchar(50) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `php_pages`
--

INSERT INTO `php_pages` (`id`, `page`, `title`, `status`) VALUES
(1, 'index.php', 'Homepage', 1),
(2, 'about.php', 'About', 1),
(3, 'gallery.php', 'Gallery', 1),
(4, 'contact.php', 'Contcat US', 1),
(5, 'useful-links.php', 'Useful-Links', 1),
(6, 'mandate.php', 'Mandate', 1),
(7, 'district-profile.php', 'District-Profil', 1),
(8, 'infrastructure.php', 'Infrastructure', 1),
(9, 'facilities-for-farmers.php', 'Facilities For Farmers', 1),
(10, 'kisan-club.php', 'Kisan-Club', 1),
(11, 'awardee-farmers.php', 'Awardee Farmers', 1),
(12, 'farmers-innovation.php', 'Farmers Innovation', 1),
(13, 'teaching.php', 'Teaching', 1),
(14, 'non-teaching.php', 'Non-Teaching', 1),
(15, 'market-inforamtion.php', 'Market Information', 1),
(16, 'linkage.php', 'Linkage', 1);

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

--
-- Table structure for table `subcategory`
--

CREATE TABLE IF NOT EXISTS `subcategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) NOT NULL,
  `subcategory` varchar(50) NOT NULL,
  `ranking` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

--
-- Dumping data for table `subcategory`
--

INSERT INTO `subcategory` (`id`, `pid`, `subcategory`, `ranking`, `status`) VALUES
(1, 2, 'Mandate', 6, 1),
(2, 2, 'District Profile', 7, 1),
(3, 2, 'Thrust Area', 3, 1),
(4, 2, 'Infrastruct', 8, 1),
(5, 2, 'Other Services', 5, 1),
(6, 2, 'Facilities For Farmers', 9, 1),
(7, 3, 'Kisan-Club', 10, 1),
(8, 3, 'Awardee Farmers', 11, 1),
(9, 3, 'Farmers-Innovation', 12, 1),
(10, 3, 'Collaborations', 4, 1),
(11, 3, 'Reports', 5, 1),
(12, 4, 'Teaching', 13, 1),
(13, 4, 'Non-Teaching', 14, 1),
(14, 5, 'Gallery', 3, 1),
(15, 5, 'Ongoing Events', 3, 1),
(16, 5, 'Others', 3, 1),
(17, 8, 'Market Information', 15, 1),
(18, 8, 'Linkage', 16, 1),
(19, 9, 'Action Plan 2015-16', 0, 1);

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