-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Apr 12, 2019 at 09:33 AM
-- Server version: 10.1.38-MariaDB
-- PHP Version: 7.1.27

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
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 utf8mb4 */;

--
-- Database: `adarsh_access`
--

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

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

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `role` int(11) DEFAULT '1' COMMENT '1=>Super Admin, 2=>Admin',
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT '1' COMMENT '1=>Active, 0=>Deleted'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `admin` (`id`, `role`, `username`, `password`, `status`) VALUES
(1, 1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 1);

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

--
-- Table structure for table `booking`
--

CREATE TABLE `booking` (
  `id` int(11) NOT NULL,
  `book_code` varchar(100) DEFAULT NULL,
  `cust_id` int(11) NOT NULL,
  `shopper_id` int(11) NOT NULL,
  `prod_id` int(11) NOT NULL,
  `booked_date` datetime DEFAULT NULL,
  `prod_price` double DEFAULT NULL,
  `vat` double DEFAULT NULL,
  `shipping_charge` double DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `commission` double DEFAULT NULL,
  `shopper_amount` double DEFAULT NULL,
  `qty` varchar(45) DEFAULT NULL,
  `delivery_time` date DEFAULT NULL,
  `track_status` varchar(50) DEFAULT NULL COMMENT 'Shipping Track Status',
  `status` int(11) DEFAULT '1' COMMENT '0=>Cancelled, 1=>Booked, 2=>Processing, 3=>Completed'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `brand`
--

CREATE TABLE `brand` (
  `id` int(11) NOT NULL,
  `brand_name` varchar(50) DEFAULT NULL,
  `brand_name_arab` varchar(50) DEFAULT NULL,
  `brand_image` varchar(150) DEFAULT NULL,
  `status` int(11) DEFAULT '1' COMMENT '1=>Active, 0=> Inactive/Deleted'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `brand`
--

INSERT INTO `brand` (`id`, `brand_name`, `brand_name_arab`, `brand_image`, `status`) VALUES
(1, 'PUMA', '555', './uploads/brand/1554985669black5.jpg', 1),
(2, 'PUMA', 'sfsfsf', './uploads/brand/1554985836blue2.jpg', 1),
(3, 'vvv', 'bbbb', './uploads/brand/1555050576green4.png', 1);

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

--
-- Table structure for table `cart`
--

CREATE TABLE `cart` (
  `id` int(11) NOT NULL,
  `cust_id` int(11) NOT NULL,
  `shopper_id` int(11) NOT NULL,
  `prod_id` int(11) NOT NULL,
  `qty` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT '1' COMMENT '1=>Active, 0=>Inactive/Deleted'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

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

CREATE TABLE `category` (
  `id` int(11) NOT NULL,
  `cat_name` varchar(50) DEFAULT NULL,
  `cat_name_arab` varchar(50) DEFAULT NULL,
  `cat_image` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT '1' COMMENT '1=>Active, 0=>Inactive/Deleted'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `category` (`id`, `cat_name`, `cat_name_arab`, `cat_image`, `status`) VALUES
(1, 'Mobile', '', '/assets/upload/mobile.png', 0),
(2, 'Fridge', 'rr', './uploads/category/1554983236blue2.jpg', 1),
(3, 'cat11', 'catarb', './uploads/category/1554983100black5.jpg', 1),
(4, 'test', 'catarb', './uploads/category/1555050316black5.jpg', 1),
(5, 'rrrrrrrrrr', 'rrrrrrrrrrrr', './uploads/category/1555050383black5.jpg', 1);

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

--
-- Table structure for table `currency`
--

CREATE TABLE `currency` (
  `id` int(11) NOT NULL,
  `country_name` varchar(50) DEFAULT NULL,
  `symbol` varchar(5) DEFAULT NULL,
  `rate` double DEFAULT NULL COMMENT 'Rate Converted into SAR (1 USD = 3.75 SAR) ',
  `code` varchar(5) NOT NULL,
  `flag` varchar(100) NOT NULL,
  `status` int(11) DEFAULT '1' COMMENT '1=>Active, 2=>Inactive/Deleted'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `currency`
--

INSERT INTO `currency` (`id`, `country_name`, `symbol`, `rate`, `code`, `flag`, `status`) VALUES
(1, 'India', '₹', 0.054, '+91', '/assets/uploads/india.png', 1);

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

--
-- Table structure for table `customer`
--

CREATE TABLE `customer` (
  `id` int(11) NOT NULL,
  `user_type` int(11) NOT NULL DEFAULT '1',
  `name` varchar(45) DEFAULT NULL,
  `name_arab` varchar(55) DEFAULT NULL,
  `email_id` varchar(50) DEFAULT NULL,
  `code` varchar(10) NOT NULL,
  `phone_no` varchar(15) DEFAULT NULL,
  `dob` varchar(25) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `address_arab` varchar(250) DEFAULT NULL,
  `profile_photo` varchar(255) DEFAULT NULL,
  `assist_name` varchar(45) DEFAULT NULL,
  `assist_name_arab` varchar(250) DEFAULT NULL,
  `assist_code` varchar(10) NOT NULL,
  `assist_phone_no` varchar(25) DEFAULT NULL,
  `assist_email_id` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `customer`
--

INSERT INTO `customer` (`id`, `user_type`, `name`, `name_arab`, `email_id`, `code`, `phone_no`, `dob`, `address`, `address_arab`, `profile_photo`, `assist_name`, `assist_name_arab`, `assist_code`, `assist_phone_no`, `assist_email_id`) VALUES
(1, 1, 'Customer', 'fgfgfg', 'customer@nuvento.com', '343', '9400882745', '31-07-1990', 'Nuvento Kochi', 'gdgdg@srsg.rd', '/assets/images/admin.jpg', 'Nuvento Support', 'sdgdg', '44', '354754754', 'ssfsg@sgd.hf'),
(2, 1, 'Martin', NULL, 'martin@nuvento.com', '', '7209638547', '30/09/2000', 'Nuvento Kochi', NULL, NULL, 'Support', NULL, '', '7777777777', 'support@nuvento.com'),
(3, 1, 'Martin', NULL, 'martin_news@nuvento.com', '', '7209638577', '30/09/2000', 'Nuvento Kochi', NULL, NULL, 'Support', NULL, '', '7777777888', 'support@nuvento.com'),
(5, 1, 'Martin', NULL, 'martin_tester@nuvento.com', '+91', '7209638333', '30/09/2000', 'Nuvento Kochi', NULL, NULL, 'Support', NULL, '+91', '7777777777', 'support@nuvento.com'),
(6, 1, 'royraju', 'arabicroy', 'roy@gmail.com', '91', '64544455454', '44/77/7777', 'sdgfdhfdhf', 'adsfsfs', 'uploads/customer/1555041833_driver_car.jpg', 'sdgdgdgd', 'sfsfssssssss', '44', '454657575', 'dsgsdg@kdgjdg.dgdg'),
(7, 1, 'hhh', 'ffffffff', 'hhh@sfsf.fhf', '91', '45446464', '44/77/7777', 'dfhdfhf', 'fhfhf', 'uploads/customer/1555042169_blue2.jpg', 'fff', 'hhh', '65', '345464646', 'fgdgd@ssgs.fhf'),
(8, 1, 'agr', 'grr', 'ddf@fzsf.gg', '91', '13646436', '44/77/7777', 'dsfhfhdf', 'fdghgg', 'uploads/customer/1555042456_red1.jpeg', 'sdgsdg', 'gggggggggggg', '546575', '65768658', 'ssfgf@gdgd.dgd'),
(9, 1, 'dfdd', 'truckdvrtx', 'ajil.techware1@gmail.com', '9999999999', '9999999999', '44/77/7777', 'info', 'dfdfd', 'uploads/customer/1555045046_blue2.jpg', 'dfdf', 'dfdf', '66', '4646464', 'dfdf@afsf.fdgdf'),
(10, 1, 'ajil', 'ajilarb', 'ajil.techware333@gmail.com', '9999999999', '91', '44/77/7777', 'info', 'sdgds', 'uploads/customer/1555052661_benzz.jpg', 'assssssss', 'ghghg', '3456789876', '2222222224', 'cook@gmail.com');

--
-- Triggers `customer`
--
DELIMITER $$
CREATE TRIGGER `customer_AFTER_INSERT` AFTER INSERT ON `customer` FOR EACH ROW BEGIN
INSERT INTO users (user_id, user_type,username)
Values (NEW.id, 1,NEW.email_id);
END
$$
DELIMITER ;

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

--
-- Table structure for table `customer_address`
--

CREATE TABLE `customer_address` (
  `id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `address_type` int(11) DEFAULT '1' COMMENT '1=> Home, 2=>Work',
  `name` varchar(50) DEFAULT NULL,
  `phone_no` varchar(15) DEFAULT NULL,
  `pincode` varchar(15) DEFAULT NULL,
  `building` varchar(100) DEFAULT NULL,
  `area` varchar(100) DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `state` varchar(50) DEFAULT NULL,
  `landmark` varchar(100) DEFAULT NULL,
  `status` int(11) DEFAULT '1' COMMENT '1=>Active, 0=>Inactive/Deleted'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cust_shopper_wish`
--

CREATE TABLE `cust_shopper_wish` (
  `id` int(11) NOT NULL,
  `wish_id` int(11) NOT NULL,
  `cust_id` int(11) NOT NULL,
  `shopper_id` int(11) NOT NULL,
  `curr_id` int(11) NOT NULL,
  `cost` double DEFAULT NULL,
  `delivery_time` varchar(50) DEFAULT NULL,
  `status` int(11) DEFAULT '1' COMMENT '1=>Request, 2=>Accept, 0=>Decline'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `favourite`
--

CREATE TABLE `favourite` (
  `id` int(11) NOT NULL,
  `cust_id` int(11) NOT NULL,
  `prod_id` int(11) NOT NULL,
  `status` int(11) DEFAULT '1' COMMENT '1=>Active, 0=>Inactive/Deleted'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `notification`
--

CREATE TABLE `notification` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `order_address`
--

CREATE TABLE `order_address` (
  `id` int(11) NOT NULL,
  `booking_id` int(11) NOT NULL,
  `address_type` int(11) DEFAULT '1' COMMENT '1=> Home, 2=>Work',
  `name` varchar(50) DEFAULT NULL,
  `phone_no` varchar(15) DEFAULT NULL,
  `pincode` varchar(15) DEFAULT NULL,
  `building` varchar(100) DEFAULT NULL,
  `area` varchar(100) DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `state` varchar(50) DEFAULT NULL,
  `landmark` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `curr_id` int(11) NOT NULL,
  `cat_id` int(11) NOT NULL,
  `sub_cat_id` int(11) NOT NULL,
  `brand_id` int(11) NOT NULL,
  `prod_name` varchar(255) DEFAULT NULL,
  `prod_desc` text,
  `price` double DEFAULT NULL,
  `delivery_time` varchar(50) DEFAULT NULL,
  `location` varchar(100) DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT '1' COMMENT '1=>Active, 0=>Inactive/Deleted',
  `wish_flag` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `prod_galley`
--

CREATE TABLE `prod_galley` (
  `id` int(11) NOT NULL,
  `prod_id` int(11) NOT NULL,
  `media_url` varchar(100) DEFAULT NULL,
  `media_type` int(11) DEFAULT '1' COMMENT '1=>Image, 2=> Video',
  `status` int(11) DEFAULT '1' COMMENT '1=>Active, 0=>Inactive/Deleted'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `recent`
--

CREATE TABLE `recent` (
  `id` int(11) NOT NULL,
  `cust_id` int(11) NOT NULL,
  `prod_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `title` varchar(55) DEFAULT NULL,
  `title_short` varchar(55) DEFAULT NULL,
  `country_flag` varchar(55) DEFAULT NULL,
  `currency` varchar(55) DEFAULT NULL,
  `site_logo` varchar(250) DEFAULT NULL,
  `fav_icon` varchar(250) DEFAULT NULL,
  `commission` double DEFAULT NULL,
  `vat` double DEFAULT NULL,
  `smtp_host` varchar(50) DEFAULT NULL,
  `smtp_username` varchar(45) DEFAULT NULL,
  `smtp_password` varchar(100) DEFAULT NULL,
  `smtp_port` int(11) DEFAULT NULL,
  `google_api_key` varchar(450) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `title`, `title_short`, `country_flag`, `currency`, `site_logo`, `fav_icon`, `commission`, `vat`, `smtp_host`, `smtp_username`, `smtp_password`, `smtp_port`, `google_api_key`) VALUES
(0, 'dgdg', 'gg', 'fdddddd', '$', 'uploads/services/1555051648_black5.jpg', 'uploads/services/1555051648_brown6.jpg', 55, NULL, NULL, 'gfgf', '12345', NULL, 'fgfhfhfh');

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

--
-- Table structure for table `shopper`
--

CREATE TABLE `shopper` (
  `id` int(11) NOT NULL,
  `user_type` int(11) NOT NULL DEFAULT '2',
  `name` varchar(45) DEFAULT NULL,
  `name_arab` varchar(55) DEFAULT NULL,
  `email_id` varchar(50) DEFAULT NULL,
  `code` int(55) DEFAULT NULL,
  `phone_no` varchar(15) DEFAULT NULL,
  `shop_name` varchar(50) DEFAULT NULL,
  `shop_name_arab` varchar(55) DEFAULT NULL,
  `dob` varchar(25) DEFAULT NULL,
  `profile_photo` varchar(255) DEFAULT NULL,
  `commission` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shopper`
--

INSERT INTO `shopper` (`id`, `user_type`, `name`, `name_arab`, `email_id`, `code`, `phone_no`, `shop_name`, `shop_name_arab`, `dob`, `profile_photo`, `commission`) VALUES
(1, 2, 'Shopper', '', 'shopper@nuvento.com', 5, '9072127102', 'Nuvento', 'lll', '31/08/1990', '/assets/images/admin.jpg', 10),
(2, 2, 'zzzzzzz', 'z', 'zzzz@ggg.fgf', 91, '5555555', 'zxc', 'zcc', '44/77/7777', 'uploads/shopper/1555045170_brown6.jpg', 4),
(3, 2, 'dgdgd', 'ddg', 'kksk@sss.ssf', NULL, '54464646464', 'dgdgdg', 'dddd', '44/77/7777', 'uploads/shopper/1555050855_brown6.jpg', 4),
(4, 2, 'bhhg', 'truckdvrtx', 'ajil.techware551@gmail.com', NULL, '464757575', 'dgdg', 'hghg', '44/77/7777', 'uploads/shopper/1555052967_brown6.jpg', 0);

--
-- Triggers `shopper`
--
DELIMITER $$
CREATE TRIGGER `shopper_AFTER_INSERT` AFTER INSERT ON `shopper` FOR EACH ROW BEGIN
INSERT INTO users (user_id, user_type, username)
Values (NEW.id, 2, NEW.email_id);
END
$$
DELIMITER ;

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

--
-- Table structure for table `sub_category`
--

CREATE TABLE `sub_category` (
  `id` int(11) NOT NULL,
  `sub_cat_name` varchar(50) DEFAULT NULL,
  `sub_cat_name_arab` varchar(50) DEFAULT NULL,
  `sub_cat_image` varchar(100) DEFAULT NULL,
  `status` int(11) DEFAULT '1' COMMENT '1=>Active, 0=>inactive',
  `cat_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sub_category`
--

INSERT INTO `sub_category` (`id`, `sub_cat_name`, `sub_cat_name_arab`, `sub_cat_image`, `status`, `cat_id`) VALUES
(1, 'Iphone', 'ee', './uploads/subcategory/1554984154steve-jobs.jpg', 1, 1),
(2, 'Samsung', NULL, '/assets/images/samsung.png', 1, 1),
(3, 'LG', NULL, '/assets/images/lg.png', 1, 2),
(4, 'sct1', 'scat arb', './uploads/subcategory/1554984013red1.jpeg', 1, 3),
(5, 'dddd', 'scat arb', './uploads/subcategory/1555050708black5.jpg', 1, 5);

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

--
-- Table structure for table `transaction`
--

CREATE TABLE `transaction` (
  `id` int(11) NOT NULL,
  `booking_id` int(11) NOT NULL,
  `book_code` varchar(100) DEFAULT NULL,
  `trans_date` datetime DEFAULT NULL,
  `trans_id` varchar(50) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `status` int(11) DEFAULT NULL COMMENT '1=>Success, 0=>Failure'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `user_type` int(11) DEFAULT NULL COMMENT '1=>Customer, 2=>Shopper, 0=> Admin',
  `user_id` int(11) DEFAULT '0',
  `username` varchar(100) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT '0' COMMENT '1=>Active, 0=>Inactive, 2=>Deleted'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `user_type`, `user_id`, `username`, `password`, `status`) VALUES
(1, 1, 1, 'customer@nuvento.com', 'e10adc3949ba59abbe56e057f20f883e', 1),
(2, 2, 1, 'shopper@nuvento.com', 'e10adc3949ba59abbe56e057f20f883e', 1),
(3, 1, 2, 'martin@nuvento.com', NULL, 0),
(4, 1, 3, 'martin_news@nuvento.com', NULL, 0),
(6, 1, 5, 'martin_tester@nuvento.com', 'e10adc3949ba59abbe56e057f20f883e', 1),
(12, 1, 8, 'ddf@fzsf.gg', NULL, 0),
(13, 2, 0, 'cookf@gmail.com', 'f384782368b3b5393a53e98150328d41', 1),
(15, 1, 9, 'ajil.techware1@gmail.com', NULL, 0),
(16, 2, 0, 'zzzz@ggg.fgf', '025f4ed201f2b880c8651e0643dba7e3', 1),
(17, 2, 2, 'zzzz@ggg.fgf', NULL, 0),
(18, 2, 0, 'kksk@sss.ssf', 'e6998394ce15266347b7b9e3094e5d7e', 1),
(19, 2, 3, 'kksk@sss.ssf', NULL, 0),
(20, 1, 10, 'ajil.techware333@gmail.com', NULL, 0),
(21, 2, 4, 'ajil.techware551@gmail.com', NULL, 0);

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

--
-- Table structure for table `wish`
--

CREATE TABLE `wish` (
  `id` int(11) NOT NULL,
  `cust_id` int(11) NOT NULL,
  `cat_id` int(11) NOT NULL,
  `post_date` varchar(10) NOT NULL,
  `sub_cat_id` int(11) NOT NULL,
  `prod_name` varchar(50) DEFAULT NULL,
  `description` text,
  `status` int(11) DEFAULT '1' COMMENT '1=>Active, 0=>Inactive/Deleted'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wish`
--

INSERT INTO `wish` (`id`, `cust_id`, `cat_id`, `post_date`, `sub_cat_id`, `prod_name`, `description`, `status`) VALUES
(1, 1, 1, '2019-04-08', 1, 'Iphone XS 64 GB', 'Advanced Face ID. Security is simple when your face is your password. You can unlock your iPhone and log in to apps, accounts and more with a glance. It’s the most secure facial authentication ever in a smartphone. And now it’s even faster', 1),
(2, 1, 1, '2019-04-09', 1, 'Iphone XS 64 GB', 'Advanced Face ID. Security is simple when your face is your password. You can unlock your iPhone and log in to apps, accounts and more with a glance. It’s the most secure facial authentication ever in a smartphone. And now it’s even faster', 1),
(3, 1, 1, '2019-04-10', 1, 'Iphone XS 64 GB', 'Advanced Face ID. Security is simple when your face is your password. You can unlock your iPhone and log in to apps, accounts and more with a glance. It’s the most secure facial authentication ever in a smartphone. And now it’s even faster', 1),
(4, 1, 1, '2019-04-10', 1, 'Iphone XS 64 GB', 'Advanced Face ID. Security is simple when your face is your password. You can unlock your iPhone and log in to apps, accounts and more with a glance. It’s the most secure facial authentication ever in a smartphone. And now it’s even faster', 1),
(5, 1, 1, '2019-04-10', 1, 'Iphone XS 64 GB', 'Advanced Face ID. Security is simple when your face is your password. You can unlock your iPhone and log in to apps, accounts and more with a glance. It’s the most secure facial authentication ever in a smartphone. And now it’s even faster', 1),
(6, 1, 1, '2019-04-10', 1, 'Iphone XS 64 GB', 'Advanced Face ID. Security is simple when your face is your password. You can unlock your iPhone and log in to apps, accounts and more with a glance. It’s the most secure facial authentication ever in a smartphone. And now it’s even faster', 1),
(7, 1, 1, '2019-04-10', 1, 'Iphone XS 64 GB', 'Advanced Face ID. Security is simple when your face is your password. You can unlock your iPhone and log in to apps, accounts and more with a glance. It’s the most secure facial authentication ever in a smartphone. And now it’s even faster', 1),
(8, 1, 1, '2019-04-10', 1, 'Ipad', 'New Ipod $500', 1);

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

--
-- Table structure for table `wish_media`
--

CREATE TABLE `wish_media` (
  `id` int(11) NOT NULL,
  `wish_id` int(11) NOT NULL,
  `url` varchar(100) DEFAULT NULL,
  `status` int(11) DEFAULT '1' COMMENT '1=>Active, 0=>Deleted'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wish_media`
--

INSERT INTO `wish_media` (`id`, `wish_id`, `url`, `status`) VALUES
(1, 1, 'assets/uploads/post_141043.jpg', 1),
(2, 1, 'assets/uploads/post_832965.jpg', 1),
(3, 1, 'assets/uploads/post_331771.jpg', 1),
(4, 2, 'assets/uploads/post_246155.jpg', 1),
(5, 2, 'assets/uploads/post_743383.jpg', 1),
(6, 2, 'assets/uploads/post_961739.jpg', 1),
(7, 3, 'assets/uploads/post_678522.jpg', 1),
(8, 3, 'assets/uploads/post_673325.jpg', 1),
(9, 3, 'assets/uploads/post_613738.jpg', 1),
(10, 4, 'assets/uploads/post_838875.jpg', 1),
(11, 4, 'assets/uploads/post_663459.jpg', 1),
(12, 4, 'assets/uploads/post_508337.jpg', 1),
(13, 5, 'assets/uploads/post_710656.jpg', 1),
(14, 5, 'assets/uploads/post_983065.jpg', 1),
(15, 5, 'assets/uploads/post_869342.jpg', 1),
(16, 6, 'assets/uploads/post_999677.jpg', 1),
(17, 6, 'assets/uploads/post_234718.jpg', 1),
(18, 6, 'assets/uploads/post_718787.jpg', 1),
(19, 7, 'assets/uploads/post_937548.jpg', 1),
(20, 7, 'assets/uploads/post_550848.jpg', 1),
(21, 7, 'assets/uploads/post_586649.jpg', 1),
(22, 8, 'assets/uploads/post_944501.jpg', 1),
(23, 8, 'assets/uploads/post_979695.jpg', 1),
(24, 8, 'assets/uploads/post_600306.jpg', 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admin`
--
ALTER TABLE `admin`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `booking`
--
ALTER TABLE `booking`
  ADD PRIMARY KEY (`id`,`cust_id`,`shopper_id`,`prod_id`),
  ADD KEY `fk_booking_customer1_idx` (`cust_id`),
  ADD KEY `fk_booking_shopper1_idx` (`shopper_id`),
  ADD KEY `fk_booking_products1_idx` (`prod_id`);

--
-- Indexes for table `brand`
--
ALTER TABLE `brand`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cart`
--
ALTER TABLE `cart`
  ADD PRIMARY KEY (`id`,`cust_id`,`shopper_id`,`prod_id`),
  ADD KEY `fk_cart_customer1_idx` (`cust_id`),
  ADD KEY `fk_cart_shopper1_idx` (`shopper_id`),
  ADD KEY `fk_cart_products1_idx` (`prod_id`);

--
-- Indexes for table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `currency`
--
ALTER TABLE `currency`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `customer`
--
ALTER TABLE `customer`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `customer_address`
--
ALTER TABLE `customer_address`
  ADD PRIMARY KEY (`id`,`customer_id`),
  ADD KEY `fk_customer_address_customer1_idx` (`customer_id`);

--
-- Indexes for table `cust_shopper_wish`
--
ALTER TABLE `cust_shopper_wish`
  ADD PRIMARY KEY (`id`,`wish_id`,`cust_id`,`shopper_id`,`curr_id`),
  ADD KEY `fk_cust_shopper_wish_customer1_idx` (`cust_id`),
  ADD KEY `fk_cust_shopper_wish_wish2_idx` (`wish_id`),
  ADD KEY `fk_cust_shopper_wish_shopper1_idx` (`shopper_id`),
  ADD KEY `fk_cust_shopper_wish_currency1` (`curr_id`);

--
-- Indexes for table `favourite`
--
ALTER TABLE `favourite`
  ADD PRIMARY KEY (`id`,`cust_id`,`prod_id`),
  ADD KEY `fk_favourite_customer1_idx` (`cust_id`),
  ADD KEY `fk_favourite_products1_idx` (`prod_id`);

--
-- Indexes for table `notification`
--
ALTER TABLE `notification`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `order_address`
--
ALTER TABLE `order_address`
  ADD PRIMARY KEY (`id`,`booking_id`),
  ADD KEY `fk_order_address_booking1_idx` (`booking_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`,`curr_id`,`cat_id`,`sub_cat_id`,`brand_id`),
  ADD KEY `fk_products_currency1_idx` (`curr_id`),
  ADD KEY `fk_products_brand1_idx` (`brand_id`),
  ADD KEY `fk_products_category1_idx` (`cat_id`),
  ADD KEY `fk_products_sub_category1_idx` (`sub_cat_id`);

--
-- Indexes for table `prod_galley`
--
ALTER TABLE `prod_galley`
  ADD PRIMARY KEY (`id`,`prod_id`),
  ADD KEY `fk_prod_galley_products1_idx` (`prod_id`);

--
-- Indexes for table `recent`
--
ALTER TABLE `recent`
  ADD PRIMARY KEY (`id`,`cust_id`,`prod_id`),
  ADD KEY `fk_recent_customer1_idx` (`cust_id`),
  ADD KEY `fk_recent_products1_idx` (`prod_id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `shopper`
--
ALTER TABLE `shopper`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sub_category`
--
ALTER TABLE `sub_category`
  ADD PRIMARY KEY (`id`,`cat_id`),
  ADD KEY `fk_sub_category_category1_idx` (`cat_id`);

--
-- Indexes for table `transaction`
--
ALTER TABLE `transaction`
  ADD PRIMARY KEY (`id`,`booking_id`),
  ADD KEY `fk_transaction_booking1_idx` (`booking_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `wish`
--
ALTER TABLE `wish`
  ADD PRIMARY KEY (`id`,`cust_id`,`cat_id`,`sub_cat_id`),
  ADD KEY `fk_wish_category1_idx` (`cat_id`),
  ADD KEY `fk_wish_customer1_idx` (`cust_id`),
  ADD KEY `fk_wish_sub_category1_idx` (`sub_cat_id`);

--
-- Indexes for table `wish_media`
--
ALTER TABLE `wish_media`
  ADD PRIMARY KEY (`id`,`wish_id`),
  ADD KEY `fk_wish_media_wish1_idx` (`wish_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `booking`
--
ALTER TABLE `booking`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `brand`
--
ALTER TABLE `brand`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `cart`
--
ALTER TABLE `cart`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `customer`
--
ALTER TABLE `customer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `customer_address`
--
ALTER TABLE `customer_address`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cust_shopper_wish`
--
ALTER TABLE `cust_shopper_wish`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `favourite`
--
ALTER TABLE `favourite`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notification`
--
ALTER TABLE `notification`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `order_address`
--
ALTER TABLE `order_address`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `prod_galley`
--
ALTER TABLE `prod_galley`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `recent`
--
ALTER TABLE `recent`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `shopper`
--
ALTER TABLE `shopper`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `sub_category`
--
ALTER TABLE `sub_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `transaction`
--
ALTER TABLE `transaction`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `wish`
--
ALTER TABLE `wish`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `wish_media`
--
ALTER TABLE `wish_media`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `booking`
--
ALTER TABLE `booking`
  ADD CONSTRAINT `fk_booking_customer1` FOREIGN KEY (`cust_id`) REFERENCES `customer` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_booking_products1` FOREIGN KEY (`prod_id`) REFERENCES `products` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_booking_shopper1` FOREIGN KEY (`shopper_id`) REFERENCES `shopper` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `cart`
--
ALTER TABLE `cart`
  ADD CONSTRAINT `fk_cart_customer1` FOREIGN KEY (`cust_id`) REFERENCES `customer` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_cart_products1` FOREIGN KEY (`prod_id`) REFERENCES `products` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_cart_shopper1` FOREIGN KEY (`shopper_id`) REFERENCES `shopper` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `customer_address`
--
ALTER TABLE `customer_address`
  ADD CONSTRAINT `fk_customer_address_customer1` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `cust_shopper_wish`
--
ALTER TABLE `cust_shopper_wish`
  ADD CONSTRAINT `fk_cust_shopper_wish_currency1` FOREIGN KEY (`curr_id`) REFERENCES `currency` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_cust_shopper_wish_customer1` FOREIGN KEY (`cust_id`) REFERENCES `customer` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_cust_shopper_wish_shopper1` FOREIGN KEY (`shopper_id`) REFERENCES `shopper` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_cust_shopper_wish_wish2` FOREIGN KEY (`wish_id`) REFERENCES `wish` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `favourite`
--
ALTER TABLE `favourite`
  ADD CONSTRAINT `fk_favourite_customer1` FOREIGN KEY (`cust_id`) REFERENCES `customer` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_favourite_products1` FOREIGN KEY (`prod_id`) REFERENCES `products` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `order_address`
--
ALTER TABLE `order_address`
  ADD CONSTRAINT `fk_order_address_booking1` FOREIGN KEY (`booking_id`) REFERENCES `booking` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `fk_products_brand1` FOREIGN KEY (`brand_id`) REFERENCES `brand` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_products_category1` FOREIGN KEY (`cat_id`) REFERENCES `category` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_products_currency1` FOREIGN KEY (`curr_id`) REFERENCES `currency` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_products_sub_category1` FOREIGN KEY (`sub_cat_id`) REFERENCES `sub_category` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `prod_galley`
--
ALTER TABLE `prod_galley`
  ADD CONSTRAINT `fk_prod_galley_products1` FOREIGN KEY (`prod_id`) REFERENCES `products` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `recent`
--
ALTER TABLE `recent`
  ADD CONSTRAINT `fk_recent_customer1` FOREIGN KEY (`cust_id`) REFERENCES `customer` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_recent_products1` FOREIGN KEY (`prod_id`) REFERENCES `products` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `sub_category`
--
ALTER TABLE `sub_category`
  ADD CONSTRAINT `fk_sub_category_category1` FOREIGN KEY (`cat_id`) REFERENCES `category` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `transaction`
--
ALTER TABLE `transaction`
  ADD CONSTRAINT `fk_transaction_booking1` FOREIGN KEY (`booking_id`) REFERENCES `booking` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `wish`
--
ALTER TABLE `wish`
  ADD CONSTRAINT `fk_wish_category1` FOREIGN KEY (`cat_id`) REFERENCES `category` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_wish_customer1` FOREIGN KEY (`cust_id`) REFERENCES `customer` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_wish_sub_category1` FOREIGN KEY (`sub_cat_id`) REFERENCES `sub_category` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `wish_media`
--
ALTER TABLE `wish_media`
  ADD CONSTRAINT `fk_wish_media_wish1` FOREIGN KEY (`wish_id`) REFERENCES `wish` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
COMMIT;

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