-- phpMyAdmin SQL Dump
-- version 3.4.10.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 15, 2018 at 11:37 PM
-- Server version: 5.5.20
-- PHP Version: 5.3.10

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

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

--
-- Table structure for table `tbl_order`
--

CREATE TABLE IF NOT EXISTS `tbl_order` (
  `order_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` text NOT NULL,
  `tid` text NOT NULL,
  `totalpayment` text NOT NULL,
  `ccn` text,
  `cvv` text,
  PRIMARY KEY (`order_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `tbl_order`
--

INSERT INTO `tbl_order` (`order_id`, `user_id`, `tid`, `totalpayment`, `ccn`, `cvv`) VALUES
(2, '@admin', '@admin180507021054021054070518@admin', '2', '456456', '123'),
(3, '@admin', '@admin180507022441022441070518@admin', '28', '5856325633362225', '255'),
(4, '@admin', '3e38360a3b8498c2a9d02bd92582a3ea', '25', '225633256', '223'),
(5, 'a', 'b03d7478c24c0b80e2e38a5729e7c57a', '18', 'asdasdsa', 'asdassad'),
(6, 'a', '2d230ae0b9695c6888dfb8af1a6e4288', '42', 'asdasdsa', 'asdassad'),
(7, 'azim', '4896310749fe58b541594a27a82264de', '25', 'asdasdsa', 'asdassad'),
(8, 'amer', 'ed4f8a679cb3285ddd6b2410281a9055', '20', '912838188', '4123'),
(9, 'saleh', 'eeb57e451e5970afbb832800b738eb5b', '20', '', ''),
(10, 'saleh', '9a9546cc49f412d171eb087b3b79a52b', '20', '912818812', '1234'),
(11, 'luqman', 'c634b8975e7e771762ff9f3dae1d3f69', '20', '983882882', '6090');

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

--
-- Table structure for table `tbl_order_details`
--

CREATE TABLE IF NOT EXISTS `tbl_order_details` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `product_id` text NOT NULL,
  `quantity` text NOT NULL,
  `order_id` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `tbl_order_details`
--

INSERT INTO `tbl_order_details` (`id`, `product_id`, `quantity`, `order_id`) VALUES
(5, '3', '1', '@admin180507022441022441070518@admin'),
(4, '1', '1', '@admin180507021054021054070518@admin'),
(6, '2', '1', '@admin180507022441022441070518@admin'),
(7, '2', '1', '3e38360a3b8498c2a9d02bd92582a3ea'),
(8, '5', '1', 'b03d7478c24c0b80e2e38a5729e7c57a'),
(9, '7', '2', '2d230ae0b9695c6888dfb8af1a6e4288'),
(10, '2', '1', '4896310749fe58b541594a27a82264de'),
(11, '22', '1', 'ed4f8a679cb3285ddd6b2410281a9055'),
(12, '21', '1', 'eeb57e451e5970afbb832800b738eb5b'),
(13, '23', '1', '9a9546cc49f412d171eb087b3b79a52b'),
(14, '25', '1', 'c634b8975e7e771762ff9f3dae1d3f69');

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

--
-- Table structure for table `tbl_order_details_temp`
--

CREATE TABLE IF NOT EXISTS `tbl_order_details_temp` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` text NOT NULL,
  `product_id` text NOT NULL,
  `quantity` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

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

--
-- Table structure for table `tbl_product`
--

CREATE TABLE IF NOT EXISTS `tbl_product` (
  `product_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `product_name` text,
  `product_pic` text,
  `product_price` text,
  `product_author` text NOT NULL,
  `product_isbn` text NOT NULL,
  `product_descr` text NOT NULL,
  PRIMARY KEY (`product_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;

--
-- Dumping data for table `tbl_product`
--

INSERT INTO `tbl_product` (`product_id`, `product_name`, `product_pic`, `product_price`, `product_author`, `product_isbn`, `product_descr`) VALUES
(22, 'Mastering OpenCV 3 - Second Edition', 'admin181215113405a1812151044429781786466563-medium.jpg', '20.00', 'Roy Shilkrott', '9781786466563', 'Key FeaturesUpdated for OpenCV 3, this book covers new features that will help you unlock the full potential of OpenCV 3Written by a team of 7 experts'),
(21, 'More Money With Online', 'a1812151042049783959265973-medium.jpg', '20.00', 'Tuncer Akdemir', '9783959265973', 'ou will need to explore your talents and skills. See what you can do and is different from others. Focus on your skills and polish them. Choose a platform that you can use to let others know about your expertise. '),
(20, 'Three Asian Folk Songs', 'a1812151039519790901654426-medium.jpg', '20.00', 'Chunyuan Xiao', '9790901654426', 'Three Asian Folk Songs For Unaccompanied Womens Voices comprises of three folk songs from Japan, Indonesia & Inner Mongolia which is part of China. The first piece, Sakura, sakura is from Japan and it talks about the season of Sakura.'),
(23, 'Ilusi Sebuah Cinta', 'a181215104956CESB_Ilusi_Sebua_49b3fb21afcf2.jpg', '20.00', 'Diya Elora', '978-983-893-902-7', 'Cintaâ€¦ hadirnya membawa seribu kenangan yang tak mampu dilupakanâ€¦ perginya mengguris sekeping hati yang mendambakan ketulusan kasih dan kepercayaan.'),
(24, 'Dimensi Budaya Teknologi dalam Era Globalisasi', 'a1812151051369789835212673-medium.jpg', '20.00', 'Norhani Bakri', '978-983-52-1267-3', 'Budaya teknologi sesebuah masyarakat melibatkan cara penggunaan, pembinaan, dan penguasaan terhadap teknologi bagi memenuhi keperluan serta keinginan mereka dalam kehidupan. '),
(25, 'Pengkomputeran Selari', 'a1812151052489789835210754-medium.jpg', '20.00', 'Mohd Shahizan Othman, Lizawati Mi Yusuf, Norma Alias', '978-983-52-1075-4', 'Pengkomputeran selari merupakan gabungan berbilang pemproses atau berbilang teras yang tidak bersandar antara satu dengan yang lain dari segi ruang memori dan beroperasi secara bersama.'),
(26, 'SISTEM PANGKALAN DATA', 'a1812151054329789830468273-medium.jpg', '20.00', 'Mohd Helmy Abd Wahab', '978-983-2183-61-7', 'Sistem pangkalan data merupakan satu aspek yang penting dalam dunia pengkomputeran. Kebanyakan aplikasi berkomputer menggunakan pangkalan data untuk menyimpan, mengakses, serta mengurus data');

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

--
-- Table structure for table `tbl_rating`
--

CREATE TABLE IF NOT EXISTS `tbl_rating` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `product_id` text NOT NULL,
  `rating` text NOT NULL,
  `user_id` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `tbl_rating`
--

INSERT INTO `tbl_rating` (`id`, `product_id`, `rating`, `user_id`) VALUES
(1, '1', '5', '@admin'),
(2, '1', '3', '@admin'),
(3, '1', '3', '@admin'),
(4, '2', '3', '@admin'),
(5, '3', '4', '@admin'),
(6, '3', '5', '@admin'),
(7, '3', '3', '@admin'),
(8, '2', '5', '@admin');

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

--
-- Table structure for table `tbl_user`
--

CREATE TABLE IF NOT EXISTS `tbl_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` text NOT NULL,
  `password` text NOT NULL,
  `name` text NOT NULL,
  `ic` bigint(20) NOT NULL,
  `add1` text NOT NULL,
  `add2` text NOT NULL,
  `city` text NOT NULL,
  `postcode` bigint(20) NOT NULL,
  `state` text NOT NULL,
  `phone` text NOT NULL,
  `email` text NOT NULL,
  `picture` text,
  `dateregister` date NOT NULL,
  `token` text,
  `status` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `tbl_user`
--

INSERT INTO `tbl_user` (`id`, `username`, `password`, `name`, `ic`, `add1`, `add2`, `city`, `postcode`, `state`, `phone`, `email`, `picture`, `dateregister`, `token`, `status`) VALUES
(1, 'admin', '0cc175b9c0f1b6a831c399e269772661', 'ADMIN', 880523035409, 'LOT 1722, TAMAN ADABI', 'KG JIAS', 'PASIR MAS', 17000, 'KELANTAN', '0199891306', 'ADMIN@YAHOO.COM', 'aDesert.jpg', '2017-11-29', 'token', 'ADMIN'),
(2, '@admin', '888e931d6360ee143df0d552f955299a', 'rahimi', 888, 'a', 'a', 'a', 8888, 'a', 'a', 'a@a.com', '@adminuitm.png', '2018-05-06', 'token', 'USER'),
(3, 'azim', '81dc9bdb52d04dc20036dbd8313ed055', 'Abdul Shahrul Azim', 960901095085, 'Pauh', 'Jalan Bomba', 'Arau', 2600, 'Perlis', '01114992194', 'shahrulazim009@gmail.com', 'azimAZIM.PNG', '2018-12-15', 'token', 'ADMIN'),
(4, 'Riz', '81dc9bdb52d04dc20036dbd8313ed055', 'rizqan', 123212, 'asdsa', '', 'mchnag', 123211, 'Kelantan', '12312', 'riz@gmail.com', 'nophoto.png', '2018-12-15', 'token', 'USER'),
(5, 'saleh', '81dc9bdb52d04dc20036dbd8313ed055', 'Muhammad Sallehuddin', 960902095021, 'No 16, Kampung Belukar,', 'Jalan Pauh,', 'Arau', 2600, 'Perlis', '0124004260', 'saleh@gmail.com', 'nophoto.png', '2018-12-15', 'token', 'USER'),
(6, 'rizqan', '81dc9bdb52d04dc20036dbd8313ed055', 'rizqan shaari', 960906075032, 'Kampung Benut Susu', 'Jalan Kodiang', 'Pasir Mas', 2600, 'Kelantan', '019549012', 'riz@gmail.com', 'nophoto.png', '2018-12-15', 'token', 'USER'),
(7, 'Khairi', '81dc9bdb52d04dc20036dbd8313ed055', 'Khairi Jamaluddin', 9609012983919, 'No 17, Kampung Kodiang', 'Jalan Pauh', 'Kodiang', 2600, 'Kedah', '01627821839', 'kj@gmail.com', 'nophoto.png', '2018-12-15', 'token', 'USER'),
(8, 'amer', '81dc9bdb52d04dc20036dbd8313ed055', 'Mohammad Amer', 96090129193, 'No 18, Kampung Manjong', 'Jalan Padang Besar', 'Manjong', 2600, 'Perak', '01763262727', 'amer@gmail.com', 'nophoto.png', '2018-12-15', 'token', 'USER'),
(11, 'luqman', '81dc9bdb52d04dc20036dbd8313ed055', 'Luqman Bin Razali', 96123983219, 'Jalan Pengakalan Chepa', 'Pulai Chondong', 'Kota Bharu', 2600, 'Kelantan', '0127327818', 'luqman@gmail.com', 'nophoto.png', '2018-12-15', 'token', '');

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