-- phpMyAdmin SQL Dump
-- version 3.4.10.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 07, 2018 at 02:26 AM
-- Server version: 5.5.20
-- PHP Version: 5.3.10

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `social`
--
CREATE DATABASE `social` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `social`;

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

--
-- 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=4 ;

--
-- 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');

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

--
-- 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=7 ;

--
-- 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');

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

--
-- 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=12 ;

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

--
-- 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,
  PRIMARY KEY (`product_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

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

INSERT INTO `tbl_product` (`product_id`, `product_name`, `product_pic`, `product_price`) VALUES
(1, 'colgate', '@admin180506080600download.png', '2'),
(2, 'Darlie', '@admin180506083543uitm.png', '25'),
(3, 'as', '@admin180506083716playstore1.png', '3');

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

--
-- 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- 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`) VALUES
(1, 'a', '0cc175b9c0f1b6a831c399e269772661', 'MOHAMAD RAHIMI MOHAMAD ROSMAN', 880523035409, 'LOT 1722, TAMAN ADABI', 'KG JIAS', 'PASIR MAS', 17000, 'KELANTAN', '0199891306', 'RAHIMI.ROSMAN@YAHOO.COM', 'aDesert.jpg', '2017-11-29', 'token'),
(2, '@admin', '888e931d6360ee143df0d552f955299a', 'rahimi', 888, 'a', 'a', 'a', 8888, 'a', 'a', 'a@a.com', '@adminuitm.png', '2018-05-06', 'token');
