-- phpMyAdmin SQL Dump
-- version 4.0.10deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 06, 2018 at 11:31 AM
-- Server version: 5.5.60-0ubuntu0.14.04.1
-- PHP Version: 5.5.9-1ubuntu4.25

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

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

--
-- Table structure for table `deals_banner`
--

CREATE TABLE IF NOT EXISTS `deals_banner` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `source` int(11) NOT NULL,
  `image` varchar(500) NOT NULL,
  `url` varchar(500) NOT NULL,
  `status` int(11) NOT NULL,
  `banner` int(11) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `create_date` datetime NOT NULL,
  `Banner_update_date` datetime NOT NULL,
  `banner_home` tinyint(4) NOT NULL,
  `type` smallint(6) NOT NULL,
  `site_show_banner` int(11) NOT NULL,
  `banner_order` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ;

--
-- Dumping data for table `deals_banner`
--

INSERT INTO `deals_banner` (`id`, `title`, `source`, `image`, `url`, `status`, `banner`, `start_date`, `end_date`, `create_date`, `Banner_update_date`, `banner_home`, `type`, `site_show_banner`, `banner_order`) VALUES
(1, 'movie', 0, 'sl1.png', 'www.grgr.com', 2, 1, '2018-09-17 00:00:00', '2018-09-18 00:00:00', '2018-09-24 11:16:53', '0000-00-00 00:00:00', 0, 0, 0, 1),
(2, 'movie', 0, 'sl2.png', 'wwdfdfbds', 2, 1, '2018-09-17 00:00:00', '2018-09-18 00:00:00', '2018-09-24 11:16:21', '0000-00-00 00:00:00', 0, 0, 0, 1),
(3, 'movie', 0, 'dhadak1.png', 'wqeeqwdeqw', 2, 0, '2018-09-19 00:00:00', '2018-09-20 00:00:00', '2018-09-24 11:16:47', '0000-00-00 00:00:00', 0, 0, 0, 0),
(4, 'home', 4, 'sr1.png', 'effegeg', 1, 0, '2018-09-19 00:00:00', '2018-09-20 00:00:00', '2018-09-19 11:30:31', '0000-00-00 00:00:00', 0, 0, 0, 0),
(5, 'kkkkk', 4, 'sl3.png', 'fgdfgfdgdf', 2, 1, '2018-09-22 00:00:00', '2018-09-23 00:00:00', '2018-09-24 11:15:34', '0000-00-00 00:00:00', 0, 0, 0, 0),
(6, 'iii', 4, 'sr2.png', 'gjhjgjg', 2, 0, '2018-09-22 00:00:00', '2018-09-23 00:00:00', '2018-09-24 11:16:42', '0000-00-00 00:00:00', 0, 0, 0, 0),
(7, 'dfd', 4, 'dhadak1.png', 'dfsd', 2, 0, '2018-09-24 00:00:00', '2018-09-25 00:00:00', '2018-09-28 10:45:10', '0000-00-00 00:00:00', 0, 0, 0, 0),
(8, 'efef', 4, 'sl2.png', 'erre', 2, 1, '2018-09-24 00:00:00', '2018-09-25 00:00:00', '2018-09-24 15:27:04', '0000-00-00 00:00:00', 0, 0, 0, 0),
(9, 'fgfdg', 4, 'sr2.png', 'vnv', 2, 1, '2018-09-24 00:00:00', '2018-09-25 00:00:00', '2018-09-24 13:19:02', '0000-00-00 00:00:00', 0, 0, 0, 0),
(10, 'sdgsdgsd', 0, 'm3.png', 'dgcfgfg', 2, 0, '2018-09-24 00:00:00', '2018-09-25 00:00:00', '2018-09-24 15:26:56', '0000-00-00 00:00:00', 0, 0, 0, 1),
(11, 'dss', 6, 'mv3.png', 'ytyutrut', 2, 1, '2018-09-24 00:00:00', '2018-09-25 00:00:00', '2018-09-24 15:29:02', '0000-00-00 00:00:00', 0, 0, 0, 1),
(12, 'gdfg', 0, 'flipkart.png', 'fhfh', 2, 1, '2018-09-24 00:00:00', '2018-09-25 00:00:00', '2018-09-24 15:29:49', '0000-00-00 00:00:00', 0, 0, 0, 0),
(13, 'nfghg', 6, 'sl1.png', 'fghfhfdfh', 2, 1, '2018-09-24 00:00:00', '2018-09-25 00:00:00', '2018-09-24 16:40:44', '0000-00-00 00:00:00', 0, 0, 0, 1),
(14, 'fdf', 4, 'sr1.png', 'dfhdh', 2, 1, '2018-09-24 00:00:00', '2018-09-25 00:00:00', '2018-09-28 10:44:25', '0000-00-00 00:00:00', 0, 0, 0, 0),
(15, 'fghfg', 4, 'sr1.png', 'fhfghfghf', 1, 1, '2018-09-24 00:00:00', '2018-09-25 00:00:00', '2018-09-28 11:33:31', '0000-00-00 00:00:00', 0, 0, 0, 4),
(16, 'nkl', 4, 'sl1.png', 'erwerw', 2, 0, '2018-09-24 00:00:00', '2018-09-25 00:00:00', '2018-09-28 12:11:36', '0000-00-00 00:00:00', 0, 0, 0, 1),
(17, 'xzczxc', 4, 'm4.png', 'sdsfsf', 2, 1, '2018-09-24 00:00:00', '2018-09-25 00:00:00', '2018-09-24 16:24:15', '0000-00-00 00:00:00', 0, 0, 0, 1),
(18, 'nkn', 0, 'm1.png', 'ujgugui', 2, 1, '2018-09-24 00:00:00', '2018-09-25 00:00:00', '2018-09-28 10:46:10', '0000-00-00 00:00:00', 0, 0, 0, 0),
(19, 'sdgdgd', 0, 'm2.png', 'bfd', 2, 1, '2018-09-24 00:00:00', '2018-09-25 00:00:00', '2018-09-28 10:45:49', '0000-00-00 00:00:00', 0, 0, 0, 1),
(20, 'fdffdf', 0, 'm3.png', 'dgdfgd', 2, 1, '2018-09-24 00:00:00', '2018-09-25 00:00:00', '2018-09-28 10:45:37', '0000-00-00 00:00:00', 0, 0, 0, 1),
(21, 'dvd', 0, 'dhadak1.png', 'ddgdg', 2, 1, '2018-09-24 00:00:00', '2018-09-25 00:00:00', '2018-09-28 11:32:59', '0000-00-00 00:00:00', 0, 0, 0, 1),
(22, 'gjgjg', 6, 'sl3.png', 'rgddgdr', 0, 0, '2018-09-28 00:00:00', '2018-09-29 00:00:00', '2018-09-28 12:11:32', '0000-00-00 00:00:00', 0, 0, 0, 2),
(23, 'adada', 4, 's2.jpg', 'adasdds', 2, 0, '2018-09-28 00:00:00', '2018-09-29 00:00:00', '2018-09-28 11:31:08', '0000-00-00 00:00:00', 0, 0, 0, 2),
(24, 'gjg', 0, 'tatacliq.png', 'ghfhfghfg', 2, 1, '2018-09-28 00:00:00', '2018-09-29 00:00:00', '2018-09-28 11:31:14', '0000-00-00 00:00:00', 0, 0, 0, 1),
(25, 'jjjjj', 6, 'sr1.png', 'vhfhdff', 2, 1, '2018-09-28 00:00:00', '2018-09-29 00:00:00', '2018-09-28 11:39:53', '0000-00-00 00:00:00', 0, 0, 0, 0),
(26, 'ngjgjg', 0, 'sl1.png', 'gdsgdgds', 2, 1, '2018-09-28 00:00:00', '2018-09-29 00:00:00', '2018-09-28 11:39:33', '0000-00-00 00:00:00', 0, 0, 0, 1),
(27, 'dv', 0, 'sr3.png', 'sffs', 0, 1, '2018-09-28 00:00:00', '2018-09-29 00:00:00', '2018-09-28 12:10:56', '0000-00-00 00:00:00', 0, 0, 0, 1),
(28, 'dgd', 0, 'sl1.png', 'fgdfgdfgdf', 0, 0, '2018-09-28 00:00:00', '2018-09-29 00:00:00', '2018-09-28 12:11:16', '0000-00-00 00:00:00', 0, 0, 0, 1),
(29, 'sfdf', 0, 'sr1.png', 'dfsdfdfsd', 0, 1, '2018-09-28 00:00:00', '2018-09-29 00:00:00', '2018-09-28 12:10:44', '0000-00-00 00:00:00', 0, 0, 0, 1),
(30, 'dasdsa', 0, 'mv1.png', 'sfsfa', 2, 1, '2018-09-28 00:00:00', '2018-09-29 00:00:00', '2018-09-28 12:10:26', '0000-00-00 00:00:00', 0, 0, 0, 1),
(31, 'rwerw', 0, 'm4.png', 'dsadsad', 2, 1, '2018-09-28 00:00:00', '2018-09-29 00:00:00', '2018-09-28 12:10:14', '0000-00-00 00:00:00', 0, 0, 0, 1),
(32, 'fdggd', 0, 'm3.png', 'gerterte', 0, 0, '2018-10-03 00:00:00', '2018-10-04 00:00:00', '2018-10-03 13:28:04', '0000-00-00 00:00:00', 0, 0, 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 */;
