text: -- phpMyAdmin SQL Dump
  -- version 4.7.4
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: Nov 24, 2017 at 07:52 AM
  -- Server version: 5.7.14-log
  -- PHP Version: 7.1.9
  
  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: `onlineshopbd`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `brands`
  --
  
  CREATE TABLE `brands` (
    `brand_id` int(100) NOT NULL,
    `brand_title` text NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `brands`
  --
  
  INSERT INTO `brands` (`brand_id`, `brand_title`) VALUES
  (1, 'Dell'),
  (2, 'Samsung'),
  (3, 'Apple'),
  (4, 'Sony'),
  (5, 'LG'),
  (6, 'Cloth Brand');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `cart`
  --
  
  CREATE TABLE `cart` (
    `id` int(10) NOT NULL,
    `p_id` int(10) NOT NULL,
    `ip_add` varchar(250) NOT NULL,
    `user_id` int(10) DEFAULT NULL,
    `qty` int(10) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `cart`
  --
  
  INSERT INTO `cart` (`id`, `p_id`, `ip_add`, `user_id`, `qty`) VALUES
  (4, 1, '127.0.0.1', -1, 1),
  (45, 2, '::1', 2, 1),
  (46, 3, '::1', 2, 1),
  (47, 1, '::1', 2, 1),
  (48, 6, '::1', -1, 1),
  (49, 3, '::1', -1, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `categories`
  --
  
  CREATE TABLE `categories` (
    `cat_id` int(100) NOT NULL,
    `cat_title` text NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `categories`
  --
  
  INSERT INTO `categories` (`cat_id`, `cat_title`) VALUES
  (1, 'Electronics'),
  (3, 'Mens Wear'),
  (5, 'Furnitures'),
  (6, 'Home Appliances'),
  (7, 'Electronics Gadgets');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `orders`
  --
  
  CREATE TABLE `orders` (
    `order_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `product_id` int(11) NOT NULL,
    `qty` int(11) NOT NULL,
    `trx_id` varchar(255) NOT NULL,
    `p_status` varchar(20) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `orders`
  --
  
  INSERT INTO `orders` (`order_id`, `user_id`, `product_id`, `qty`, `trx_id`, `p_status`) VALUES
  (1, 2, 7, 1, '07M47684BS5725041', 'Completed'),
  (2, 2, 2, 1, '07M47684BS5725041', 'Completed'),
  (3, 3, 3, 1, '95U1659819954324W', 'Completed'),
  (4, 4, 2, 1, '0HF46717G79376708', 'Completed');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `products`
  --
  
  CREATE TABLE `products` (
    `product_id` int(100) NOT NULL,
    `product_cat` int(100) NOT NULL,
    `product_brand` int(100) NOT NULL,
    `product_title` varchar(255) NOT NULL,
    `product_price` int(100) NOT NULL,
    `product_desc` text NOT NULL,
    `product_image` text NOT NULL,
    `product_keywords` text NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `products`
  --
  
  INSERT INTO `products` (`product_id`, `product_cat`, `product_brand`, `product_title`, `product_price`, `product_desc`, `product_image`, `product_keywords`) VALUES
  (1, 1, 2, 'Samsung Galaxy note 8', 80000, 'Samsung Galaxy note 8', '823201785242PM_635_samsung_galaxy_note_8.jpeg', 'samsung mobile electronics'),
  (2, 1, 3, 'iPhone X', 85000, 'iphone X', 'iphone-x-select-2017.png', 'mobile iphone apple'),
  (3, 1, 3, 'xiaomi redmi note 4', 18000, 'xiaomi redmi note 4', 'download (2).jpg', 'xiaomi redmi note 4'),
  (4, 1, 2, 'Samsung Galaxy s8 plus', 90000, 'Samsung Galaxy s8 plus', 'download (1).jpg', 'iphone apple mobile'),
  (5, 1, 2, 'samsung galaxy tab 4', 10000, 'samsung galaxy tab 4', 'download (5).jpg', 'samsung galaxy tab 4'),
  (6, 1, 1, 'dell xps 15', 35000, 'dell xps 15', 'images (6).jpg', 'dell xps 15'),
  (7, 1, 1, 'dell inspiron 14 5447', 50000, 'dell inspiron 14 5447', 'download (3).jpg', 'dell inspiron 14 5447'),
  (8, 1, 4, 'Sony', 40000, 'Sony Mobile', 'sony mobile.jpg', 'sony mobile'),
  (9, 1, 3, 'iPhone 5', 12000, 'iphone', 'white iphone.png', 'iphone apple mobile'),
  (10, 2, 6, 'Red Ladies dress', 1000, 'red dress for girls', 'red dress.jpg', 'red dress '),
  (11, 2, 6, 'Blue Heave dress', 1200, 'Blue dress', 'images (5).jpg', 'blue dress cloths'),
  (12, 2, 6, 'Ladies Casual Cloths', 1500, 'ladies casual summer two colors pleted', '7475-ladies-casual-dresses-summer-two-colors-pleated.jpg', 'girl dress cloths casual'),
  (13, 2, 6, 'SpringAutumnDress', 1200, 'girls dress', 'Spring-Autumn-Winter-Young-Ladies-Casual-Wool-Dress-Women-s-One-Piece-Dresse-Dating-Clothes-Medium.jpg_640x640.jpg', 'girl dress'),
  (14, 2, 6, 'Casual Dress', 1400, 'girl dress', 'download.jpg', 'ladies cloths girl'),
  (15, 2, 6, 'Formal Look', 1500, 'girl dress', 'shutterstock_203611819.jpg', 'ladies wears dress girl'),
  (16, 3, 6, 'Sweter for men', 600, '2012-Winter-Sweater-for-Men-for-better-outlook', '2012-Winter-Sweater-for-Men-for-better-outlook.jpg', 'black sweter cloth winter'),
  (17, 3, 6, 'Gents formal', 1000, 'gents formal look', 'gents-formal-250x250.jpg', 'gents wear cloths'),
  (19, 3, 6, 'Formal Coat', 3000, 'ad', 'images (1).jpg', 'coat blazer gents'),
  (20, 3, 6, 'Mens Sweeter', 1600, 'jg', 'Winter-fashion-men-burst-sweater.png', 'sweeter gents '),
  (21, 3, 6, 'T shirt', 800, 'ssds', 'IN-Mens-Apparel-Voodoo-Tiles-09._V333872612_.jpg', 'formal t shirt black'),
  (22, 4, 6, 'Yellow T shirt ', 1300, 'yello t shirt with pant', '1.0x0.jpg', 'kids yellow t shirt'),
  (23, 4, 6, 'Girls cloths', 1900, 'sadsf', 'GirlsClothing_Widgets.jpg', 'formal kids wear dress'),
  (24, 4, 6, 'Blue T shirt', 700, 'g', 'images.jpg', 'kids dress'),
  (25, 4, 6, 'Yellow girls dress', 750, 'as', 'images (3).jpg', 'yellow kids dress'),
  (26, 4, 6, 'Skyblue dress', 650, 'nbk', 'kids-wear-121.jpg', 'skyblue kids dress'),
  (27, 4, 6, 'Formal look', 690, 'sd', 'image28.jpg', 'formal kids dress'),
  (32, 5, 0, 'Book Shelf', 2500, 'book shelf', 'furniture-book-shelf-250x250.jpg', 'book shelf furniture'),
  (33, 6, 2, 'Refrigerator', 35000, 'Refrigerator', 'CT_WM_BTS-BTC-AppliancesHome_20150723.jpg', 'refrigerator samsung'),
  (34, 6, 4, 'Emergency Light', 1000, 'Emergency Light', 'emergency light.JPG', 'emergency light'),
  (35, 6, 0, 'Vaccum Cleaner', 6000, 'Vaccum Cleaner', 'images (2).jpg', 'Vaccum Cleaner'),
  (36, 6, 5, 'Iron', 1500, 'gj', 'iron.JPG', 'iron'),
  (37, 6, 5, 'LED TV', 20000, 'LED TV', 'images (4).jpg', 'led tv lg'),
  (38, 6, 4, 'Microwave Oven', 3500, 'Microwave Oven', 'images.jpg', 'Microwave Oven'),
  (39, 6, 5, 'Mixer Grinder', 2500, 'Mixer Grinder', 'singer-mixer-grinder-mg-46-medium_4bfa018096c25dec7ba0af40662856ef.jpg', 'Mixer Grinder'),
  (40, 2, 6, 'Formal girls dress', 3000, 'Formal girls dress', 'girl-walking.jpg', 'ladies'),
  (45, 1, 2, 'Samsung Galaxy Note 3', 10000, '0', 'samsung_galaxy_note3_note3neo.JPG', 'samsung galaxy Note 3 neo'),
  (46, 1, 2, 'Samsung Galaxy Note 3', 10000, '', 'samsung_galaxy_note3_note3neo.JPG', 'samsung galxaxy note 3 neo');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `user_info`
  --
  
  CREATE TABLE `user_info` (
    `user_id` int(10) NOT NULL,
    `first_name` varchar(100) NOT NULL,
    `last_name` varchar(100) NOT NULL,
    `email` varchar(300) NOT NULL,
    `password` varchar(300) NOT NULL,
    `mobile` varchar(10) NOT NULL,
    `address1` varchar(300) NOT NULL,
    `address2` varchar(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `user_info`
  --
  
  INSERT INTO `user_info` (`user_id`, `first_name`, `last_name`, `email`, `password`, `mobile`, `address1`, `address2`) VALUES
  (2, 'Arik', 'Intisar', 'arikdjxp@gmail.com', '25f9e794323b453885f5181f1b624d0b', '1712315444', 'fwewfeew', 'dsvs');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `brands`
  --
  ALTER TABLE `brands`
    ADD PRIMARY KEY (`brand_id`);
  
  --
  -- Indexes for table `cart`
  --
  ALTER TABLE `cart`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `categories`
  --
  ALTER TABLE `categories`
    ADD PRIMARY KEY (`cat_id`);
  
  --
  -- Indexes for table `orders`
  --
  ALTER TABLE `orders`
    ADD PRIMARY KEY (`order_id`);
  
  --
  -- Indexes for table `products`
  --
  ALTER TABLE `products`
    ADD PRIMARY KEY (`product_id`);
  
  --
  -- Indexes for table `user_info`
  --
  ALTER TABLE `user_info`
    ADD PRIMARY KEY (`user_id`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `brands`
  --
  ALTER TABLE `brands`
    MODIFY `brand_id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  
  --
  -- AUTO_INCREMENT for table `cart`
  --
  ALTER TABLE `cart`
    MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;
  
  --
  -- AUTO_INCREMENT for table `categories`
  --
  ALTER TABLE `categories`
    MODIFY `cat_id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
  
  --
  -- AUTO_INCREMENT for table `orders`
  --
  ALTER TABLE `orders`
    MODIFY `order_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  
  --
  -- AUTO_INCREMENT for table `products`
  --
  ALTER TABLE `products`
    MODIFY `product_id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;
  
  --
  -- AUTO_INCREMENT for table `user_info`
  --
  ALTER TABLE `user_info`
    MODIFY `user_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  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 */;
  