-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Dec 15, 2018 at 04:12 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: `enmdb`
--

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

--
-- Table structure for table `market`
--

CREATE TABLE IF NOT EXISTS `market` (
  `market_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `market_name` text NOT NULL,
  `market_location` text NOT NULL,
  PRIMARY KEY (`market_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;

--
-- Dumping data for table `market`
--

INSERT INTO `market` (`market_id`, `market_name`, `market_location`) VALUES
(1, 'sini', ''),
(2, 'situ', ''),
(3, 'situ', ''),
(4, 't', ''),
(5, 't', ''),
(6, 't', ''),
(7, 't', ''),
(8, 'qwertyuiop', ''),
(9, 'qwertyuiop', ''),
(10, 'qwertyuiop', ''),
(11, 'pochinki', ''),
(12, 'hsuHQ`', ''),
(13, '', ''),
(14, '', ''),
(15, '', ''),
(16, '', ''),
(17, '', ''),
(18, '', ''),
(19, '', ''),
(20, 'yuoo', 'rtui'),
(21, '', ''),
(22, 'adbuwh', 'hduwa'),
(23, 'asdfghjkl', 'qwertyuiop'),
(24, 'Bandar Baharu Kubang Kerian (Jalan Tok Kenali)', 'Kota Bharu'),
(25, 'Bandar Baharu Kubang Kerian (Jalan Tok Kenali)', 'asd');

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

--
-- Table structure for table `rating`
--

CREATE TABLE IF NOT EXISTS `rating` (
  `rating_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `stall_id` text NOT NULL,
  `user_id` text NOT NULL,
  `rating` text NOT NULL,
  `date_in` date DEFAULT NULL,
  PRIMARY KEY (`rating_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `rating`
--

INSERT INTO `rating` (`rating_id`, `stall_id`, `user_id`, `rating`, `date_in`) VALUES
(1, 'l', 'l', '1', NULL),
(2, '1', 'l', '1', NULL),
(3, '1', 'l', '1', NULL),
(4, '1', 'l', '5', NULL),
(5, '1', 'l', '4', NULL),
(6, '3', 'l', '5', NULL),
(7, '1', 'x', '3', NULL),
(8, '2', 'x', '3', NULL),
(9, '3', 'x', '5', NULL);

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

--
-- Table structure for table `stall`
--

CREATE TABLE IF NOT EXISTS `stall` (
  `stall_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `stall_name` text NOT NULL,
  `stall_cat` text NOT NULL,
  `stall_desc` text NOT NULL,
  `user_id` text NOT NULL,
  `market_id` text NOT NULL,
  PRIMARY KEY (`stall_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` text NOT NULL,
  `password` text NOT NULL,
  `name` text NOT NULL,
  `ic` text NOT NULL,
  `add1` text NOT NULL,
  `add2` text NOT NULL,
  `city` text NOT NULL,
  `postcode` text NOT NULL,
  `state` text NOT NULL,
  `phone` text NOT NULL,
  `email` text NOT NULL,
  `status` text NOT NULL,
  `picture` blob NOT NULL,
  `pic_type` text NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`user_id`, `username`, `password`, `name`, `ic`, `add1`, `add2`, `city`, `postcode`, `state`, `phone`, `email`, `status`, `picture`, `pic_type`) VALUES
(18, 'u', '7b774effe4a349c6dd82ad4f4f21d34c', 'u', 'u', 'u', 'u', 'u', 'u', 'u', 'u', 'u@gmail.com', 'visitor', [encoded data, 66910 characters], 'image/jpeg');
INSERT INTO `user` (`user_id`, `username`, `password`, `name`, `ic`, `add1`, `add2`, `city`, `postcode`, `state`, `phone`, `email`, `status`, `picture`, `pic_type`) VALUES
(11, 'FiqaFhana', '0cc175b9c0f1b6a831c399e269772661', 'Afiqah Nurfarhana Roslan', '960613-02-5680', 'No. 40, Lebuh Raya Pauh, Sintok,', 'Kampung Tradisi, Lembah Keriang,', 'Changloon', '06010', 'Kedah', '011-36312465', 'afiqahnurfarhana@gmail.com', 'visitor', 0x466971614668616e61414f4143393630372e6a7067, '');
INSERT INTO `user` (`user_id`, `username`, `password`, `name`, `ic`, `add1`, `add2`, `city`, `postcode`, `state`, `phone`, `email`, `status`, `picture`, `pic_type`) VALUES
(19, 'o', 'd95679752134a2d9eb61dbd7b91c4bcc', 'o', 'o', 'o', 'o', 'o', 'o', 'o', 'o', 'o@gmail.com', 'visitor', [encoded data, 51154 characters], 'image/jpeg');
INSERT INTO `user` (`user_id`, `username`, `password`, `name`, `ic`, `add1`, `add2`, `city`, `postcode`, `state`, `phone`, `email`, `status`, `picture`, `pic_type`) VALUES
(17, 'l', '2db95e8e1a9267b7a1188556b2013b33', 'Abdul Hadi Abdul Halim', 'l', 'Universiti Pendidikan Sultan Idris', '', 'Tanjung Malim', '35900', 'Perak', '0128749568', 'la@gmail.com', 'visitor', [encoded data, 98486 characters], 'image/jpeg');
INSERT INTO `user` (`user_id`, `username`, `password`, `name`, `ic`, `add1`, `add2`, `city`, `postcode`, `state`, `phone`, `email`, `status`, `picture`, `pic_type`) VALUES
(20, 'p', '83878c91171338902e0fe0fb97a8c47a', 'p', 'p', 'p', 'p', 'p', 'p', 'p', 'p', 'p@gmail.com', 'visitor', [encoded data, 122274 characters], 'image/jpeg');
INSERT INTO `user` (`user_id`, `username`, `password`, `name`, `ic`, `add1`, `add2`, `city`, `postcode`, `state`, `phone`, `email`, `status`, `picture`, `pic_type`) VALUES
(21, 'y', '415290769594460e2e485922904f345d', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y@gmail.com', 'visitor', [encoded data, 61814 characters], 'image/jpeg');
INSERT INTO `user` (`user_id`, `username`, `password`, `name`, `ic`, `add1`, `add2`, `city`, `postcode`, `state`, `phone`, `email`, `status`, `picture`, `pic_type`) VALUES
(22, 'j', '363b122c528f54df4a0446b6bab05515', 'jamilah jamilan jodi', '9012', 'j', 'j', 'j', 'j', 'j', 'j', 'j@gmail.com', 'vendor', [encoded data, 60050 characters], 'image/jpeg');
INSERT INTO `user` (`user_id`, `username`, `password`, `name`, `ic`, `add1`, `add2`, `city`, `postcode`, `state`, `phone`, `email`, `status`, `picture`, `pic_type`) VALUES
(23, 'x', '9dd4e461268c8034f5c8564e155c67a6', 'x', 'x', 'x', 'x', 'x', 'x', 'x', 'x', 'x@gmail.com', 'visitor', [encoded data, 70692 characters], 'image/png');
INSERT INTO `user` (`user_id`, `username`, `password`, `name`, `ic`, `add1`, `add2`, `city`, `postcode`, `state`, `phone`, `email`, `status`, `picture`, `pic_type`) VALUES
(25, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'Afiqah Nurfarhana Roslan', 'admin', 'admin', 'admin', 'admin', 'admin', 'admin', 'admin', 'admin@admin', 'admin', [encoded data, 78154 characters], 'image/jpeg}');
INSERT INTO `user` (`user_id`, `username`, `password`, `name`, `ic`, `add1`, `add2`, `city`, `postcode`, `state`, `phone`, `email`, `status`, `picture`, `pic_type`) VALUES
(26, 't', 'e358efa489f58062f10dd7316b65649e', 't', 't', 't', 't', 't', 't', 't', 't', 't@gmail.com', 'visitor', [encoded data, 67490 characters], 'image/jpeg');

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