-- phpMyAdmin SQL Dump
-- version 4.0.10deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 06, 2018 at 11:38 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_deals`
--

CREATE TABLE IF NOT EXISTS `deals_deals` (
  `deals_id` int(11) NOT NULL AUTO_INCREMENT,
  `deals_name` varchar(255) NOT NULL,
  `deals_url` varchar(255) NOT NULL,
  `deals_title` varchar(256) NOT NULL,
  `deals_date` date NOT NULL,
  `deals_update` date NOT NULL,
  `deals_store` int(11) NOT NULL,
  `deals_expire` date NOT NULL,
  `deals_image` varchar(255) NOT NULL,
  `deals_store_image` varchar(255) NOT NULL,
  `deals_category` text NOT NULL,
  `deals_type` int(11) NOT NULL,
  `deals_show` int(11) NOT NULL,
  `deals_top` int(11) NOT NULL,
  `deals_description` longtext NOT NULL,
  `deals_mrp` decimal(10,2) DEFAULT NULL,
  `deals_offer` varchar(500) NOT NULL,
  `deals_price` decimal(10,2) DEFAULT NULL,
  `deals_source_product_id` varchar(255) NOT NULL,
  `deals_status` smallint(6) NOT NULL,
  `deals_keyword` varchar(512) NOT NULL,
  `deals_meta` varchar(512) NOT NULL,
  `deals_meta_description` varchar(512) NOT NULL,
  `deals_coupon` varchar(255) NOT NULL,
  `deals_home` tinyint(6) NOT NULL,
  PRIMARY KEY (`deals_id`),
  UNIQUE KEY `deals_source_product_id` (`deals_source_product_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `deals_deals`
--

INSERT INTO `deals_deals` (`deals_id`, `deals_name`, `deals_url`, `deals_title`, `deals_date`, `deals_update`, `deals_store`, `deals_expire`, `deals_image`, `deals_store_image`, `deals_category`, `deals_type`, `deals_show`, `deals_top`, `deals_description`, `deals_mrp`, `deals_offer`, `deals_price`, `deals_source_product_id`, `deals_status`, `deals_keyword`, `deals_meta`, `deals_meta_description`, `deals_coupon`, `deals_home`) VALUES
(2, '', 'https://www.amazon.in/', 'up to 70% off', '2018-09-14', '2018-09-14', 2, '2018-09-14', 'c5.jpeg', 'Flipkart-coupons-offers.jpg', '7', 0, 0, 0, '70% off on mobile phones', NULL, 'up to 70% off', 1190.00, '1536903702', 1, 'mobile phones coupons,offers on camera', 'up to 70% off on mobile phones', 'exciting offers on mobile ', '', 0),
(3, '', 'https://www.amazon.in/', 'best camera under 10000', '2018-09-14', '2018-09-14', 1, '2018-09-14', 'c6.jpeg', 'amazone.png', '7', 0, 0, 1, 'now buy camera on best discount', NULL, 'up to 25% off', 9999.00, '1536903690', 1, 'best discount, best offers', 'camera on best discount', 'camera on best discount', '', 0),
(4, '', 'jiljiojou', 'ffffffffff', '2018-09-14', '2018-09-14', 2, '2018-09-14', 'm1.png', 'Flipkart-coupons-offers.jpg', '0', 0, 0, 0, ' dasdsdadd ', NULL, 'up to 50% off', 4444.00, '1536903227', 2, 'offers,discount', 'mnndfdfiw', 'fwefwefefe', '', 0),
(5, '', 'dsfsfsdfsdf', ' sdffsf', '2018-09-14', '2018-09-14', 1, '2018-09-14', 'mv1.png', 'amazone.png', '7', 1, 0, 0, 'dfdfdfdd', NULL, '2d', 44444.00, '1536903277', 0, 'dfsfsf', 'fdsfsd', 'dfdsf', '3', 0),
(6, '', 'dvsdsf', 'cfsffs', '2018-09-14', '2018-09-14', 2, '2018-09-14', 'mv2.png', 'Flipkart-coupons-offers.jpg', '5', 1, 0, 0, 'asfdgsdg', NULL, 'ffasfas', 555.00, '1536903336', 0, 'fdsfdf', 'dsfsdf', 'sdfsdfsdf', 'fsfs', 0),
(7, '', 'sdasdadas', 'hhhhhh', '2018-09-14', '2018-09-14', 2, '2018-09-14', 'p7.png', 'Flipkart-coupons-offers.jpg', '7', 1, 0, 3, 'sdsdasdsad', NULL, '5', 323.00, '1536905404', 2, 'sdasdas', 'sdsadsad', 'dasdasdas', '42', 0),
(8, '', 'gdfgd', 'dfgsdfgsd', '2018-09-14', '2018-09-14', 2, '2018-09-14', 's1.jpg', 'Flipkart-coupons-offers.jpg', '7', 0, 0, 1, 'gsdgdfg', NULL, 'gdd', 545.00, '1536905141', 0, 'fsfsfs', 'dfsf', 'dgdgd', '', 0),
(9, '', 'iiiiiiiii', 'iiiiiiiiii', '2018-09-14', '2018-09-14', 2, '2018-09-14', 'mv5.png', 'Flipkart-coupons-offers.jpg', '2', 0, 0, 0, 'iiiiiiiiii', NULL, '35yii', 666666.00, '1536904796', 0, 'iiiiiiiiiii', 'iiiiiiiiii', 'iiiiiiii', '', 0);

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