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

CREATE TABLE IF NOT EXISTS `deal_navigation` (
  `nav_id` int(11) NOT NULL AUTO_INCREMENT,
  `nav_name` varchar(255) NOT NULL,
  `nav_parent` int(11) NOT NULL,
  `nav_url` varchar(255) NOT NULL,
  `nav_status` tinyint(6) NOT NULL,
  `nav_date` datetime NOT NULL,
  `nav_update` datetime NOT NULL,
  `nav_order` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`nav_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=118 ;

--
-- Dumping data for table `deal_navigation`
--

INSERT INTO `deal_navigation` (`nav_id`, `nav_name`, `nav_parent`, `nav_url`, `nav_status`, `nav_date`, `nav_update`, `nav_order`) VALUES
(1, 'Brand', 0, 'brand/', 1, '2014-11-06 15:49:31', '2014-11-06 15:49:31', 0),
(2, 'Store', 0, 'store/', 1, '2014-11-18 16:54:43', '2014-11-18 16:54:43', 0),
(3, 'Types', 0, 'types/', 1, '2014-11-18 17:41:19', '2014-11-18 17:53:44', 0),
(4, 'Catogery', 0, 'catogery/', 1, '2014-11-18 18:11:30', '2014-11-18 18:18:28', 0),
(5, 'Color', 0, 'color/', 1, '2014-11-18 18:11:51', '2014-11-18 18:18:41', 0),
(6, 'Coupon', 0, 'coupon/', 1, '2014-11-21 15:57:47', '2014-11-21 15:57:47', 0),
(7, 'Inactive coupon', 6, 'coupon/?navid', 1, '2014-11-22 19:28:05', '2014-11-22 19:30:33', 0),
(8, 'Deals', 0, 'dealsback/', 1, '2014-11-24 19:26:26', '2016-07-14 12:37:17', 0),
(9, 'Active Deals', 8, 'dealsback/?navid', 1, '2014-11-24 19:27:20', '2016-07-14 12:37:36', 0),
(10, 'Inactive Deals', 8, 'dealsback/?navid', 1, '2014-11-24 19:27:45', '2016-07-14 12:37:44', 0),
(11, 'Special', 0, 'speciallist/', 1, '2014-11-25 18:55:20', '2015-03-26 18:36:09', 0),
(12, 'Banner', 0, 'banner/', 1, '2014-11-26 16:54:03', '2014-11-26 16:54:03', 0),
(13, 'Product', 0, 'product/', 1, '2014-12-02 15:30:52', '2014-12-02 15:45:06', 0),
(14, 'Active Product', 13, 'product/?type=1&navid', 1, '2014-12-02 15:43:39', '2014-12-02 15:43:39', 0),
(15, 'Inactive Product', 13, 'product/?type=1&navid', 1, '2014-12-02 15:43:56', '2014-12-02 15:43:56', 0),
(16, 'Coumpetrs/', 0, 'coumpetrs/', 1, '2014-12-08 18:16:17', '2014-12-08 18:16:17', 0),
(17, 'Inactive Coumpetrs', 16, 'coumpetrs/?type=1&navid', 1, '2014-12-08 18:17:55', '2014-12-08 18:17:55', 0),
(18, 'Active Coumpetrs', 16, 'coumpetrs/?type=1&navid', 1, '2014-12-08 18:18:19', '2014-12-08 18:18:19', 0),
(19, 'Camera', 0, 'camera', 1, '2014-12-08 18:18:53', '2014-12-08 18:18:53', 0),
(20, 'Inactive Camera', 19, 'camera/?type=1&navid', 1, '2014-12-08 18:19:21', '2014-12-08 18:19:21', 0),
(21, 'Active Camera', 19, 'camera/?type=1&navid', 1, '2014-12-08 18:19:43', '2014-12-08 18:19:43', 0),
(22, 'Fashion', 0, 'fashion/', 1, '2014-12-08 18:23:45', '2014-12-08 18:23:45', 0),
(23, 'Inactive Fashion', 22, 'fashion/?type=1&navid', 1, '2014-12-08 18:24:24', '2014-12-08 18:24:24', 0),
(24, 'Active Facebook', 22, 'fashion/?type=1&navid', 1, '2014-12-08 18:24:55', '2014-12-08 18:24:55', 0),
(25, 'Feeds', 0, 'feeds/', 1, '2014-12-10 13:34:10', '2014-12-10 13:34:10', 0),
(26, 'Feeds DownLoad', 25, 'feeds/?type=1&navid', 1, '2014-12-10 13:35:12', '2014-12-10 13:35:12', 0),
(27, 'Feeds Upload', 25, 'feeds/?type=1&navid', 1, '2014-12-10 13:35:25', '2014-12-10 13:35:25', 0),
(28, 'Feeds Add New', 27, 'feeds/addnew/?type=1&navid', 1, '2014-12-11 14:05:37', '2014-12-11 14:05:37', 0),
(29, 'feeds upload Update', 27, 'feeds/updatenew/?type=1&navid', 1, '2014-12-11 14:06:24', '2014-12-11 14:06:24', 0),
(30, 'Feeds Store Download', 25, 'feeds/storedown/?type=1&navid', 1, '2014-12-11 17:07:07', '2014-12-11 17:07:07', 0),
(31, 'Feed store Upload', 25, 'feeds/storeup/?type=1&navid', 1, '2014-12-11 17:07:58', '2014-12-11 17:07:58', 0),
(32, 'Feeds Store New', 31, 'feeds/storenew/?type=1&navid', 1, '2014-12-11 17:09:01', '2014-12-11 17:09:01', 0),
(33, 'Feeds Store Update', 31, 'feeds/storeupdate/?type=1&navid', 1, '2014-12-11 17:09:39', '2014-12-11 17:09:39', 0),
(34, 'Home Product', 25, 'feeds/home/?type=1&navid', 1, '2014-12-12 18:22:46', '2014-12-12 18:22:46', 0),
(35, 'Home Coupon', 25, 'feeds/homecoupan/?type=1&navid', 1, '2014-12-12 18:23:24', '2014-12-12 18:23:24', 0),
(36, 'Deals And coupon Download', 25, 'feeds/dncd/?type=1&navid', 1, '2014-12-12 18:24:23', '2014-12-17 17:33:06', 0),
(37, 'Deals N Coupon Upload', 25, 'feeds/dncup/?type=1&navid', 1, '2014-12-12 18:24:52', '2014-12-17 17:34:45', 0),
(38, 'Add', 37, 'feeds/dncupadd/?type=1&navid', 1, '2014-12-12 18:25:23', '2014-12-17 17:34:17', 0),
(39, 'Update', 37, 'feeds/dncupup/?type=1&navid', 0, '2014-12-12 18:25:41', '2014-12-17 17:34:58', 0),
(40, 'Pixcel Commission', 0, 'commission/', 1, '2014-12-18 12:50:29', '2014-12-18 12:50:29', 0),
(41, 'Pixcel Tracking', 0, 'pixceltracking/', 1, '2014-12-18 13:15:25', '2014-12-18 13:15:43', 0),
(42, 'Reports', 0, 'report/', 1, '2014-12-24 13:37:46', '2014-12-24 13:37:46', 0),
(43, 'Mis Report', 42, 'report/mis/?type=1&navid', 1, '2014-12-29 12:04:37', '2014-12-29 12:47:28', 0),
(44, 'Price Filter', 0, 'pricefilter/', 1, '2015-01-07 13:48:42', '2015-01-07 13:48:42', 0),
(45, 'Special', 0, 'speciallist/', 1, '2015-01-30 13:48:30', '2015-03-26 18:36:19', 0),
(46, 'User Report', 0, 'siteuser/', 1, '2015-02-05 11:37:40', '2015-02-05 11:37:40', 0),
(47, 'Registred User', 46, 'siteuser/?type=1&navid', 1, '2015-02-05 11:38:36', '2015-02-05 11:38:36', 0),
(48, 'Confirm Payment', 46, 'payout/confirm/?type=1&navid', 1, '2015-02-05 11:39:31', '2015-02-05 11:39:31', 0),
(49, 'Paid Payment', 46, 'payout/paid/?type=1&navid', 1, '2015-02-05 11:40:09', '2015-02-05 11:40:09', 0),
(50, 'Missing', 0, 'missing/', 1, '2015-03-13 16:10:22', '2015-03-13 16:12:16', 0),
(51, 'Notification', 0, 'notification/', 1, '2015-03-26 18:27:34', '2015-03-28 13:28:24', 0),
(52, 'Product review', 0, 'productreview/', 1, '2015-03-28 11:58:25', '2015-03-30 17:01:49', 0),
(53, 'active Review', 52, 'productreview/?type=1&navid', 0, '2015-03-30 17:28:55', '2015-03-31 16:53:47', 0),
(54, 'Inactive Review', 52, 'productreview/?type=2&navid', 0, '2015-03-30 17:30:10', '2015-03-31 16:53:57', 0),
(55, 'Upload Daily Product', 27, 'product/downloaddailyup/?type=1&navid', 1, '2015-04-30 16:04:31', '2015-04-30 16:04:31', 0),
(56, 'Trafic', 0, 'trafic/', 1, '2015-05-06 17:25:59', '2015-05-06 17:25:59', 0),
(57, 'Cms', 0, 'cms/', 1, '2015-06-16 11:03:38', '2015-06-16 11:06:27', 0),
(58, 'Crm User', 0, 'crmuser/', 1, '2015-07-09 13:33:26', '2015-08-01 10:09:55', 0),
(59, 'Customer', 0, 'customer/', 1, '2015-07-09 16:35:50', '2015-07-09 16:35:50', 0),
(60, 'Customer Data', 0, 'customerdata/', 1, '2015-07-15 16:25:45', '2015-07-15 16:25:45', 0),
(61, 'Crm Team', 0, 'crmteam/', 1, '2015-07-20 10:39:33', '2015-07-20 10:39:33', 0),
(62, 'Download Csv', 0, 'downloadcsv/', 1, '2015-07-30 09:57:36', '2015-07-30 09:57:36', 0),
(63, 'Bookmyshow Active', 6, 'coupon/?navid', 1, '2015-08-10 15:00:19', '2015-08-10 15:00:19', 0),
(64, 'Bookmyshow Inactive', 6, 'coupon/?navid', 1, '2015-08-10 15:00:35', '2015-08-10 15:00:35', 0),
(65, 'Message List', 0, 'messagelist/', 1, '2015-08-12 13:40:40', '2015-08-12 13:40:40', 0),
(66, 'Revenue Status', 0, 'revenue/', 1, '2015-08-12 13:41:02', '2015-08-12 13:41:02', 0),
(67, 'DownLoad Csv', 46, 'payout/cashdown/?type=1&navid', 1, '2015-08-14 13:44:48', '2015-08-14 13:44:48', 0),
(68, 'Send Mail', 0, 'sendmail/', 1, '2015-08-26 11:38:50', '2015-08-26 11:39:12', 0),
(69, 'Dnp Credit', 46, 'siteuser/usercredit/?type=1&navid', 1, '2015-09-09 17:45:41', '2015-09-09 17:50:24', 0),
(70, 'User Account Info', 0, 'useraccountinfo/', 1, '2015-10-13 13:41:57', '2015-10-13 13:41:57', 0),
(71, 'Feeds Meta update', 25, 'feeds/meta/?type=1&navid', 1, '2015-10-15 16:42:33', '2015-10-15 16:43:47', 0),
(72, 'Festive Offer', 0, 'festiveoffer/', 1, '2015-10-21 12:26:19', '2015-10-21 12:26:40', 0),
(73, 'Festive Coupon', 25, 'feeds/festivecoupan/?type=1&navid', 1, '2015-10-23 16:40:37', '2015-10-23 16:40:37', 0),
(74, 'Notification Report', 51, 'notificationreport/?navid', 1, '2015-10-28 14:25:13', '2016-02-03 11:05:00', 0),
(75, 'User App', 46, 'userapplist/?type=1&navid', 1, '2015-11-18 15:15:34', '2015-11-18 15:15:34', 0),
(76, 'App Report', 0, 'appreport/', 1, '2015-11-23 18:32:58', '2015-11-23 18:32:58', 0),
(77, 'Affiliate Network', 0, 'adsnetwork/', 1, '2015-11-23 18:37:39', '2015-11-23 19:03:46', 0),
(78, 'User Bank Info', 0, 'useraccountverify/', 1, '2015-12-24 16:29:31', '2015-12-24 16:29:52', 0),
(79, 'App Version', 0, 'appversion/', 1, '2016-01-13 18:35:27', '2016-01-13 18:35:27', 0),
(80, 'Direct Url', 0, 'openurl/', 1, '2016-01-22 14:59:08', '2016-01-22 14:59:31', 0),
(81, 'B2B USER', 0, 'bappuser/', 1, '2016-01-27 17:27:26', '2016-01-27 17:27:26', 0),
(82, 'B2B Roles', 81, 'bappuser/roles/?navid', 1, '2016-01-27 17:27:55', '2016-01-27 17:27:55', 0),
(83, 'B2B Commission', 81, 'bappuser/commission/?navid', 1, '2016-01-27 17:28:15', '2016-01-27 17:28:15', 0),
(84, 'App Target Location', 0, 'applocation/', 1, '2016-01-27 17:34:53', '2016-01-27 17:34:53', 0),
(85, 'Country', 84, 'applocation/country/?navid', 1, '2016-01-27 17:35:41', '2016-01-27 17:35:41', 0),
(86, 'State', 84, 'applocation/state/?navid', 1, '2016-01-27 17:35:56', '2016-01-27 17:35:56', 0),
(87, 'District', 84, 'applocation/district/?navid', 1, '2016-01-27 17:36:13', '2016-01-27 17:36:13', 0),
(88, 'B2B Config', 81, 'bappuser/config/?navid', 1, '2016-01-27 18:57:29', '2016-01-27 18:57:29', 0),
(89, 'Notification Tracking', 0, 'notificationreport/', 0, '2016-02-01 14:10:34', '2016-02-03 11:05:58', 0),
(90, 'Cpl Report', 0, 'cplreport/', 1, '2016-02-24 12:01:19', '2016-02-24 12:01:19', 0),
(91, 'App Delay', 81, 'bappuser/configdelay/?navid', 1, '2016-03-29 18:32:27', '2016-03-29 18:32:27', 0),
(92, 'Affiliate Traffic', 56, 'affiliatetraffic/?navid', 1, '2016-04-12 13:59:05', '2016-04-12 14:06:14', 0),
(93, 'B2B Transaction', 81, 'btobtransaction/?navid', 1, '2016-04-15 13:29:53', '2016-04-15 13:29:53', 0),
(94, 'B2B Csv', 81, 'btobcsv/?navid', 1, '2016-04-19 15:39:17', '2016-04-19 15:39:17', 0),
(95, 'B2B User Wallet Status', 81, 'btobwalletstatus/?navid', 1, '2016-04-20 16:32:38', '2016-04-20 16:32:38', 0),
(96, 'B2B Tagging', 81, 'btobtagging/?navid', 1, '2016-04-25 12:09:01', '2016-04-25 12:09:01', 0),
(97, 'Gift Voucher', 0, 'giftvoucher/', 1, '2016-04-26 15:59:41', '2016-04-26 15:59:58', 0),
(98, 'Voucher Request', 97, 'giftvoucher/voucherrequest/?navid', 1, '2016-04-27 16:00:57', '2016-04-27 16:00:57', 0),
(99, 'Pro Offer', 0, 'prooffer/', 1, '2016-05-03 10:33:16', '2016-05-03 10:33:16', 0),
(100, 'Pro User', 99, 'prouser/?navid', 1, '2016-05-03 10:34:53', '2016-05-04 17:51:04', 0),
(101, 'Pro Amount', 99, 'prouser/amount/?navid', 1, '2016-05-05 13:08:53', '2016-05-05 15:06:08', 0),
(102, 'Pro Location', 99, 'prolocation/?navid', 1, '2016-05-05 15:16:24', '2016-05-05 15:16:24', 0),
(103, 'Pro Order', 99, 'proorder/?navid', 1, '2016-05-12 10:54:25', '2016-05-12 10:54:25', 0),
(104, 'Manage App', 0, 'manageapp/', 1, '2016-05-18 13:23:49', '2016-05-18 13:23:49', 0),
(105, 'Mobile Operator', 0, 'mobileoperator/', 1, '2016-05-20 18:01:47', '2016-05-20 18:01:47', 0),
(106, 'Pro payment', 99, 'propayment/?navid', 1, '2016-06-09 17:14:56', '2016-06-09 17:14:56', 0),
(107, 'Career-Job', 0, 'adminjob/', 1, '2016-06-16 11:51:17', '2016-06-16 11:51:17', 0),
(108, 'Job Position List', 107, 'adminjob/position?navid', 1, '2016-06-16 11:52:30', '2016-06-16 11:53:14', 0),
(109, 'Frontnavigation(New Ui)', 4, 'frontnavigation/?navid', 1, '2016-06-29 17:53:26', '2016-06-29 17:55:25', 0),
(110, 'Appliances', 0, 'appliances/', 1, '2016-07-08 15:09:32', '2016-07-08 15:09:32', 0),
(111, 'Active Applinaces', 110, 'appliances/?type=1&navid', 1, '2016-07-08 15:10:58', '2016-07-08 15:10:58', 0),
(112, 'Inactive Appliances', 110, 'applinaces/?type=1&navid', 1, '2016-07-08 15:11:36', '2016-07-08 15:11:53', 0),
(113, 'Bank', 0, 'bank/', 1, '2016-07-14 12:13:14', '2016-07-14 12:13:14', 0),
(114, 'Navigation', 0, 'navigation/', 1, '2017-04-11 21:29:28', '2017-04-11 21:29:28', 0),
(115, 'Add Parent', 114, 'navigation/add-parent?navid', 1, '2017-04-11 21:31:57', '2017-04-12 10:57:02', 0),
(116, 'Add Child', 114, 'navigation/add-child/?navid', 1, '2017-04-11 21:33:29', '2017-04-12 10:56:53', 0),
(117, 'Linkmydeal Offer', 0, 'linkdealoffer/', 1, '2017-04-28 22:39:43', '2017-04-28 22:39:43', 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 */;
