-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Dec 15, 2018 at 04:13 AM
-- Server version: 5.6.17
-- PHP Version: 5.5.12

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

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

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

CREATE TABLE IF NOT EXISTS `customer` (
  `customer_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `customer_ic` int(11) NOT NULL,
  `customer_name` text NOT NULL,
  `customer_email` text NOT NULL,
  `customer_add1` text NOT NULL,
  `customer_add2` text NOT NULL,
  `customer_postcode` text NOT NULL,
  `customer_state` text NOT NULL,
  `customer_city` text NOT NULL,
  `customer_phone` int(11) NOT NULL,
  `customer_password` text NOT NULL,
  `customer_username` text NOT NULL,
  `status` text NOT NULL,
  `picture` text NOT NULL,
  PRIMARY KEY (`customer_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

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

INSERT INTO `customer` (`customer_id`, `customer_ic`, `customer_name`, `customer_email`, `customer_add1`, `customer_add2`, `customer_postcode`, `customer_state`, `customer_city`, `customer_phone`, `customer_password`, `customer_username`, `status`, `picture`) VALUES
(1, 0, 'a', 'a@a', 'a', 'a', 'a', 'a', 'a', 0, '0cc175b9c0f1b6a831c399e269772661', 'a', 'customer', 'a@admin180506080600download.png'),
(2, 1, '1', '1', '1', '1', '1', '1', '1', 1, 'c4ca4238a0b923820dcc509a6f75849b', 'admin', 'ADMIN', ''),
(3, 0, '', 'a@a', 'a', 'a', 'a', 'a', 'a', 145225782, '0cc175b9c0f1b6a831c399e269772661', 'tz', 'customer', ''),
(6, 2147483647, 'syafiqah athirah', 'athirahzamri96@gmail.com', 'Hs (M) 4251 Taman K.P.A.T,', 'Kampung Telaga Mengkudu', '21400', 'Kuala Terengganu', 'Terengganu', 145225782, '81dc9bdb52d04dc20036dbd8313ed055', 'tyrahzamri', 'customer', ''),
(7, 2147483647, 'mashi', 'a@a', 'kampung ', 'kenat', '21500', 'aa', 'jertih', 1999999, '81dc9bdb52d04dc20036dbd8313ed055', 'mashidayu', 'customer', ''),
(8, 2147483647, 'Normashidayu', 'mashi@gmail.com', 'Jerteh', '', '22000', 'Terengganu', 'Jerteh', 148094918, '0cc175b9c0f1b6a831c399e269772661', 'mashi', 'customer', ''),
(9, 1027110424, 'Nur Syafiqah Zahirah Binti Zamri', 'syafiqah0010@gmail.com', 'HS (M) 4251 TAMAN K.P.A.T, ', 'Kampung Telaga Mengkudu', '21400', 'Kuala Terengganu', 'Marang', 139251898, '827ccb0eea8a706c4c34a16891f84e7b', 'syafiqazamri', 'customer', ''),
(10, 2147483647, 'Muhammad Adam Muhshi Bin Zamri', 'adammuhshi04@gmail.com', 'HS (M) 4251 TAMAN K.P.A.T,', 'Kampung Telaga Mengkudu', '21400', 'Kuala Terengganu', 'Marang', 199859009, '827ccb0eea8a706c4c34a16891f84e7b', 'adamzamri', 'customer', ''),
(11, 2147483647, 'Marlisa  Saziela Binti Mansor ', 'merlisa12@gmai.com', 'Bukit Ilmu ', 'Uitm ', '21500', 'Kuala Terengganu', 'Machang ', 123456789, '827ccb0eea8a706c4c34a16891f84e7b', 'lisamarliesa', 'customer', ''),
(12, 2147483647, 'Nurul Nazurah Binti Wira ', 'zurahnazurah96@gmail.com', 'Jalan Pantai ', 'Kampung Telaga ', '21400', 'Kuala Terengganu', 'Marang', 1213456789, '827ccb0eea8a706c4c34a16891f84e7b', 'zurahnazurah', 'customer', ''),
(13, 2147483647, 'Nurul Suliana Binti Yusoff', 'nsy96@gmail.com', 'Batu lapan, Taman Tas', 'Jalan Gambang', '21500', 'Pahang', 'Kuantan', 1312987654, '827ccb0eea8a706c4c34a16891f84e7b', 'yanaayusoff', 'customer', ''),
(14, 2147483647, 'Nur  Emilia Hassan ', 'emilia98@gmail.com', 'Lot 4189 Taman Perumahan', 'Tanah Merah', '21200', 'Kelantan', 'Tanah Merah', 1998003222, '827ccb0eea8a706c4c34a16891f84e7b', 'Emilia Hassan', 'customer', ''),
(15, 2147483647, 'Wan Agia Arissa Binti Wann Mhd Junnid ', 'babyagioo96@gmail.com', 'Lot pt 232 Jalan Bunga', '', '21800', 'Kota Bharu ', 'Kota Bharu', 18987655, '827ccb0eea8a706c4c34a16891f84e7b', 'agiaarissa', 'customer', ''),
(16, 2147483647, 'Muhammad Ridduan Bin Mohd Amin', 'ridduanamin96@gmail.com', 'Jaya Gading', 'Jalan Gambang', '20800', 'Pahang', 'Kuantan', 142020647, '827ccb0eea8a706c4c34a16891f84e7b', 'ridduanamin', 'customer', ''),
(17, 2147483647, 'Siti Zanariah Binti Mohd Azmi', 'sitizana11@gmail.com', 'Jalan Kepong Serada', '', '21400', 'Kuala Terengganu', 'Terengganu', 199859009, '827ccb0eea8a706c4c34a16891f84e7b', 'sitizana', 'customer', ''),
(18, 2147483647, 'Muhammad Adam Muhaimin Bin Zamri', 'adamMuhaimin@gmail.com', 'HS (M) 4251 TAMAN K.P.A.T,', 'Kampung Telaga Mengkudu', '21400', 'Kuala Terengganu', 'Marang', 139251898, '827ccb0eea8a706c4c34a16891f84e7b', 'adammuhaimin', 'customer', ''),
(19, 2147483647, 'Muhammad Adam Qhusyairie Bin Zamri', 'syafiqah0010@gmail.com', 'HS (M) 4251 TAMAN K.P.A.T,', 'Kampung Telaga Mengkudu', '21400', 'Kuala Terengganu', 'Marang', 139251898, '827ccb0eea8a706c4c34a16891f84e7b', 'adamQ', 'customer', '');

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

--
-- Table structure for table `liked`
--

CREATE TABLE IF NOT EXISTS `liked` (
  `liked_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `product_id` text NOT NULL,
  `customer_id` text NOT NULL,
  PRIMARY KEY (`liked_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `liked`
--

INSERT INTO `liked` (`liked_id`, `product_id`, `customer_id`) VALUES
(1, '2', 'a'),
(2, '3', 'a'),
(3, '4', 'a'),
(4, '2', 'mashi'),
(5, '3', 'mashi'),
(6, '4', 'mashi'),
(7, '1', 'Emilia Hassan'),
(8, '2', 'Emilia Hassan'),
(9, '3', 'Emilia Hassan'),
(10, '4', 'Emilia Hassan'),
(11, '4', 'Emilia Hassan'),
(12, '1', 'a'),
(13, '7', 'a'),
(14, '7', 'a'),
(15, '7', 'a'),
(16, '7', 'a');

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

--
-- Table structure for table `location`
--

CREATE TABLE IF NOT EXISTS `location` (
  `location_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `location_code` int(11) NOT NULL,
  `location_detail` text NOT NULL,
  `mall_id` int(11) NOT NULL,
  PRIMARY KEY (`location_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `mall`
--

CREATE TABLE IF NOT EXISTS `mall` (
  `mall_id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_name` text NOT NULL,
  `mall_detail` text NOT NULL,
  `mall_add1` text NOT NULL,
  `mall_add2` text NOT NULL,
  `mall_postcode` text NOT NULL,
  `mall_city` text NOT NULL,
  `mall_state` text NOT NULL,
  `mall_email` text NOT NULL,
  `mall_phone` text NOT NULL,
  `mall_contact` text NOT NULL,
  `mall_pwd` text NOT NULL,
  `mall_username` text NOT NULL,
  PRIMARY KEY (`mall_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `mall`
--

INSERT INTO `mall` (`mall_id`, `mall_name`, `mall_detail`, `mall_add1`, `mall_add2`, `mall_postcode`, `mall_city`, `mall_state`, `mall_email`, `mall_phone`, `mall_contact`, `mall_pwd`, `mall_username`) VALUES
(1, 'tesco', 'aaaaaa', 'a', 'a', 'a', 'a', 'a', 'b@b', 'a', 'a', '81dc9bdb52d04dc20036dbd8313ed055', 'tesco');

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

--
-- Table structure for table `product`
--

CREATE TABLE IF NOT EXISTS `product` (
  `product_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `product_name` text NOT NULL,
  `product_price` text NOT NULL,
  `product_pic` text NOT NULL,
  `shop_id` text NOT NULL,
  PRIMARY KEY (`product_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;

--
-- Dumping data for table `product`
--

INSERT INTO `product` (`product_id`, `product_name`, `product_price`, `product_pic`, `shop_id`) VALUES
(1, 'JEANS', 'RM 60.00', 'admin181210024038m1.jpg', 'admin'),
(3, 'BLACK PANT', 'RM 70.00', 'admin181212071930m10.jpg', 'admin'),
(4, 'BLUE JEANS', 'RM 60.00', 'admin181212072136m3.jpg', 'admin'),
(5, 'BLUE JEANS', 'RM 50.00', 'admin181212072349m15.jpg', 'admin'),
(6, 'BLUE JEANS', 'RM 70.00', 'admin181212073214m14.jpg', 'admin'),
(7, 'BLACK JEANS', 'RM 70.00', 'admin181212073440admin181212071930m10.jpg', 'admin'),
(8, 'TRACKSUIT PANT', 'RM 50.00', 'admin181212073613m9.jpg', 'admin'),
(9, 'MAN SHIRT ', 'RM 35.00', 'admin181213043053m2.jpg', 'admin'),
(10, 'MAN SHIRT ', 'RM 35.00', 'admin181213043210m12.jpg', 'admin'),
(11, 'LONG SLEEVE SHIRT', 'RM 45.00', 'admin181213043327m4.jpg', 'admin'),
(12, 'LONG SLEEVE SHIRT', 'RM 45.00', 'admin181213043356m5.jpg', 'admin'),
(13, 'LONG SLEEVE SHIRT', 'RM 45.00', 'admin181213043448m11.jpg', 'admin'),
(14, 'DRESS', 'RM 50.00', 'admin181213043845w2.jpg', 'admin'),
(15, 'DRESS', 'RM 50.00', 'admin181213043925w1.jpg', 'admin'),
(16, 'DRESS', 'RM 50.00', 'admin181213044030w3.jpg', 'admin'),
(17, 'DRESS', 'RM 50.00', 'admin181213044059w4.jpg', 'admin'),
(18, 'LONG SLEEVE SHIRT', 'RM 50.00', 'admin181213044502w13.jpg', 'admin'),
(19, 'LONG SLEEVE SHIRT', 'RM 50.00', 'admin181213044551w10.jpg', 'admin'),
(20, 'LONG SLEEVE SHIRT', 'RM 50.00', 'admin181213044641w11.jpg', 'admin'),
(21, 'LONG SLEEVE SHIRT', 'RM 50.00', 'admin181213044807w12.jpg', 'admin'),
(22, 'JUMPSUIT', 'RM 50.00', 'admin181213045014w18.jpg', 'admin'),
(23, 'JUMPSUIT', 'RM 70.00', 'admin181213045454w22.jpg', 'admin'),
(24, 'JUMPSUIT', 'RM 70.00', 'admin181213045512w20.jpg', 'admin'),
(25, 'JUMPSUIT', 'RM 70.00', 'admin181213045619w18.jpg', 'admin'),
(26, 'JEANS WOMEN', 'RM 65.00', 'admin181213045855w17.jpg', 'admin'),
(27, 'JEANS WOMEN', 'RM 65.00', 'admin181213045922w16.jpg', 'admin'),
(28, 'JEANS WOMEN', 'RM 65.00', 'admin181213050001w15.jpg', 'admin'),
(29, 'JEANS WOMEN', 'RM 65.00', 'admin181213050059w14.jpg', 'admin');

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

--
-- Table structure for table `review_p`
--

CREATE TABLE IF NOT EXISTS `review_p` (
  `review_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `review_comment` text NOT NULL,
  `customer_id` int(11) NOT NULL,
  `date_comment` date NOT NULL,
  `time_comment` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  PRIMARY KEY (`review_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `review_s`
--

CREATE TABLE IF NOT EXISTS `review_s` (
  `review_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `review_comment` text NOT NULL,
  `product_id` text NOT NULL,
  `username` text NOT NULL,
  PRIMARY KEY (`review_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `review_s`
--

INSERT INTO `review_s` (`review_id`, `review_comment`, `product_id`, `username`) VALUES
(1, 'asdas wqqwe', '2', 'a'),
(2, 'asdas wqqwe', '2', 'a'),
(3, 'nice', '1', 'a'),
(4, 'nice', '1', 'a'),
(5, 'good price', '29', 'Emilia Hassan'),
(6, 'good shop', '1', 'a');

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

--
-- Table structure for table `shop`
--

CREATE TABLE IF NOT EXISTS `shop` (
  `shop_id` bigint(50) NOT NULL AUTO_INCREMENT,
  `shop_name` text NOT NULL,
  `shop_location` text NOT NULL,
  `shop_detail` text NOT NULL,
  `shop_type` text NOT NULL,
  `shop_email` text NOT NULL,
  `shop_contact` text NOT NULL,
  `shop_phone` text NOT NULL,
  `shop_pwd` text NOT NULL,
  `shop_logo` text NOT NULL,
  `mall_id` bigint(11) NOT NULL,
  `shop_username` text NOT NULL,
  PRIMARY KEY (`shop_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `shop`
--

INSERT INTO `shop` (`shop_id`, `shop_name`, `shop_location`, `shop_detail`, `shop_type`, `shop_email`, `shop_contact`, `shop_phone`, `shop_pwd`, `shop_logo`, `mall_id`, `shop_username`) VALUES
(1, 'admin', 'admin', 'admin', 'admin', 'admin', '1', '1', 'admin', 'admin', 1, 'admin');

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