-- phpMyAdmin SQL Dump
-- version 3.4.10.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 13, 2018 at 03:58 AM
-- 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: `fixitall2`
--

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

--
-- Table structure for table `tbl_booking`
--

CREATE TABLE IF NOT EXISTS `tbl_booking` (
  `booking_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `booking_status` text NOT NULL,
  `booking_time` text NOT NULL,
  `booking_date` date NOT NULL,
  `user_id` text NOT NULL,
  `shop_id` bigint(20) NOT NULL,
  PRIMARY KEY (`booking_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;

--
-- Dumping data for table `tbl_booking`
--

INSERT INTO `tbl_booking` (`booking_id`, `booking_status`, `booking_time`, `booking_date`, `user_id`, `shop_id`) VALUES
(9, 'APPROVED', '15:00', '2018-12-20', 'mashi', 22),
(10, 'REJECT', '12:59', '2018-12-14', 'mashi', 24),
(11, 'PENDING', '12:00', '2018-12-14', 'nabeela', 26),
(12, 'REJECT', '10:59', '2018-12-18', 'mashi', 22),
(14, 'REJECT', '13:00', '2018-12-13', 'syahidah', 25),
(15, 'APPROVED', '13:00', '2018-12-13', 'syahidah', 25),
(18, 'PENDING', '16:01', '2018-12-20', 'mashi', 22),
(19, 'REJECT', '12:59', '2018-12-05', 'mashi', 22),
(20, 'REJECT', '09:00', '1889-12-10', 'mashi', 22),
(21, 'PENDING', '21:30', '2019-12-11', 'a', 27),
(22, 'PENDING', '21:30', '2019-12-11', 'a', 27),
(23, 'PENDING', '13:42', '0000-00-00', 'a', 27),
(24, 'PENDING', '02:01', '2018-12-07', 'jin', 24),
(25, 'PENDING', '13:59', '2018-12-28', 'mashi', 25);

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

--
-- Table structure for table `tbl_feedback`
--

CREATE TABLE IF NOT EXISTS `tbl_feedback` (
  `feedback_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `feedback_time` text NOT NULL,
  `feedback_date` text NOT NULL,
  `feedback_rating` text NOT NULL,
  `feedback_details` text NOT NULL,
  `booking_id` text NOT NULL,
  `user_id` text NOT NULL,
  `shop_id` text NOT NULL,
  PRIMARY KEY (`feedback_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;

--
-- Dumping data for table `tbl_feedback`
--

INSERT INTO `tbl_feedback` (`feedback_id`, `feedback_time`, `feedback_date`, `feedback_rating`, `feedback_details`, `booking_id`, `user_id`, `shop_id`) VALUES
(22, '05:05:16', '2018-12-12', '1', 'good', '', 'mashi', '22'),
(23, '11:11:19', '2018-12-13', '4', '', '', 'mashi', ''),
(24, '11:13:38', '2018-12-13', '3', 'ok la\r\n', '', 'mashi', '');

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

--
-- Table structure for table `tbl_shop`
--

CREATE TABLE IF NOT EXISTS `tbl_shop` (
  `shop_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `shop_name` text NOT NULL,
  `shop_password` text NOT NULL,
  `shop_address` text NOT NULL,
  `shop_email` text NOT NULL,
  `shop_phone` text NOT NULL,
  `shop_photo` text NOT NULL,
  `shop_operationhour` text NOT NULL,
  `feedback_id` text NOT NULL,
  `shop_username` text NOT NULL,
  `booking_status` text NOT NULL,
  `status` text NOT NULL,
  `shop_details` text NOT NULL,
  PRIMARY KEY (`shop_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;

--
-- Dumping data for table `tbl_shop`
--

INSERT INTO `tbl_shop` (`shop_id`, `shop_name`, `shop_password`, `shop_address`, `shop_email`, `shop_phone`, `shop_photo`, `shop_operationhour`, `feedback_id`, `shop_username`, `booking_status`, `status`, `shop_details`) VALUES
(22, 'tesco', 'b', 'tesco', 'tesco@tesco', '121212', 'carpenter-01.png', '7.00 - 8.00 pm', '', 'b', '', 'SHOP', 'HI ! COME TO OUR SHOP'),
(23, 'Berjaya', '12345', '12345', '12345@gmail.com', '12345', '1.png', '7.00 - 8.00 pm', '', 'Berjaya', '', 'SHOP', ''),
(24, 'One Carpenter', '12345', 'PT 46B, Jalan Pasir Puteh, Bangunan PKINK, 18500, Machang, Kelantan ', 'onecarpener@gmail.com', '09-975 0310', 'carpenter-01.png', '10.00 am - 6.00 pm', '', 'onecarpenter', '', 'SHOP', ''),
(25, 'Mechaneed', '123', '26, Jalan Tanjung, Pekan Machang, 18500 Machang, Kelantan', 'mechaneed@yahoo.com', '014-539 2521', 'a286f613988383.5627b7ad9014c.jpg', '7.00 - 8.00 pm', '', 'Mechaneed', '', 'SHOP', ''),
(26, 'Shoppee', '12345', 'Jalan Dato Hashim, Pekan Machang, 18500 Machang, Kelantan', 'shoppee@gmail.com', '076626231', 'Lighthouse.jpg', '10.00 am - 6.00 pm', '', 'shoppee', '', 'SHOP', ''),
(27, 'PlumberOne', '12345', 'Kota Bharu', 'plumberone@yahoo.com', '09828212', 'a.jpg', '10.00 am - 5.00 pm', '', 'plumberone', '', 'SHOP', ''),
(28, '', '', '', '', '', '', '', '', '', '', '', ''),
(29, '', '', '', '', '', '', '', '', '', '', '', 'HELLO. WE ARE HERE TO HELP YOU!'),
(30, '', '', '', '', '', '', '', '', '', '', '', 'SDHAHFJHHFJSJFKLAFL;ALF;LAF');

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

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

CREATE TABLE IF NOT EXISTS `tbl_user` (
  `user_id` int(20) NOT NULL AUTO_INCREMENT,
  `username` text NOT NULL,
  `user_phone` text NOT NULL,
  `user_email` text NOT NULL,
  `user_address` text NOT NULL,
  `user_password` text NOT NULL,
  `user_photo` text NOT NULL,
  `booking_status` text,
  `status` text NOT NULL,
  `user_name` text NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ;

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

INSERT INTO `tbl_user` (`user_id`, `username`, `user_phone`, `user_email`, `user_address`, `user_password`, `user_photo`, `booking_status`, `status`, `user_name`) VALUES
(8, 'mashi', '12345', 'mashi@gmail.com', '12345', '12345', 'mashi1200px-Park_Ji-min_at_Aladdin_fansign_in_September_2017_02.jpg', '', 'USER', 'Normashidayu Abu Bakar'),
(9, 'nabeela', '018929283', 'nabeela@gmail.com', 'Machang, Kelantan', '12345', 'nabeelaNeelofa.png', '', 'USER', 'Wan Nabeela'),
(10, 'syahidah', '014559955', 'syahidahshuhaimin00@gmail.com', 'Lot 1761 Kg Binjal Labok', '12345', 'syahidahIMG_9167.JPG', '', 'USER', 'Nur Syahidah Shuhaimin'),
(11, 'a', '1', 'a@a', 'a', 'a', 'a0.png', NULL, 'USER', ''),
(12, '', '2', 'a@a', '2', 'b', 'b2.MOHD IDZWAN BIN MOHD SALLEH (DR.).png', NULL, 'USER', ''),
(13, 'azim', '0199901291', 'sharulazim@gmail.com', 'Machang, Kelantan', '12345', 'azimdownload.png', NULL, '', 'ABDUL SHAHRUL AZIM BIN SUDIN'),
(14, 'fiqa', '0191231312', 'fiqa@yahoo.com', 'Machang, Kelantan', '12345', 'fiqadownload (1).png', NULL, '', 'AFIQAH NURFARHANA BINTI ROSLAN'),
(15, 'tesa', '0139912121', 'tes12@gmail.com', 'Machang, Kelantan', '12345', 'tesadownload (3).png', NULL, '', 'MAIZATUL NORATISA BINTI MAT NASIR'),
(16, 'alia', '0393921312', 'alia@gmail.com', 'Machang, Kelantan', '12345', 'aliadownload (2).png', NULL, '', 'ALIA FARHANA BINTI YUSOF'),
(17, 'marlisa', '0172212112', 'marlisa@gmail.com', 'Machang, Kelantan', '12345', 'marlisadownload (4).png', NULL, '', 'MARLISA SAZIELA BINTI MANSOR'),
(18, 'iqmal', '0179238123', 'iqmal@gmail.com', 'Machang, Kelantan', '12345', 'iqmal@gmail.comdownload (5).png', NULL, '', 'MOHAMAD IQMAL USSAIQ BIN ISMAIL'),
(19, 'alif', '0172312312', 'alif@gmail.com', 'Machang, Kelantan', '12345', 'alifdownload (6).png', NULL, '', 'MOHAMMAD ALIF FAISAL BIN SHAARI'),
(20, 'alif', '0179291309', 'zhafri@gmail.com', 'Machang, Kelantan', '12345', 'zhafri@gmail.com', NULL, '', 'MUHAMAD ALIF ZHAFRI BIN MD AZMAN'),
(21, 'aiman', '0172102901', 'aiman@yahoo.com', 'Machang, Kelantan', '1234', 'aimandownload (8).png', NULL, '', 'MUHAMAD AMER AIMAN B MOHD RAZANI'),
(22, 'badrul', '013992321', 'badrul@gmail.com', 'Machang, Kelantan', '12345', 'badruldownload (9).png', NULL, '', 'MUHAMAD BADRUL AMIN BIN CHE HUSIN'),
(23, 'hakim', '017238232', 'hakim@gmail.com', 'Machang, Kelantan', '12345', 'hakimdownload (10).png', NULL, '', 'MUHAMAD HAKIM BIN AHMAD DZARAWI'),
(24, 'mashiayu', '0191231312', 'mashiminho@gmail.com', 'Machang, Kelantan', '12345', 'mashiayuD2396F6D-10A5-44EF-A16B-3E96B795AE41.jpg', NULL, '', 'NORMASHIDAYU ABU BAKAR'),
(25, 'fahmi', '013222121', 'fahmiadzmi@gmail.com', 'Machang, Kelantan', '12345', 'MUHAMMAD FAHMI BIN MOHD ADZMIdownload (11).png', NULL, '', 'MUHAMMAD FAHMI BIN MOHD ADZMI'),
(26, 'kj', '017888212', 'kj@gmail.com', 'Machang, Kelantan', '12345', 'MUHAMMAD KHAIRI BIN JAMALLUDDINdownload (12).png', NULL, '', 'MUHAMMAD KHAIRI BIN JAMALLUDDIN'),
(27, 'luqman', '019823123', 'luqman@gmail.com', 'Machang, Kelantan', '12345', 'MUHAMMAD LUQMAN B RAZALIdownload (13).png', NULL, '', 'MUHAMMAD LUQMAN B RAZALI'),
(28, 'salleh', '018341214', 'salleh@gmail.com', 'Machang, Kelantan', '12345', 'MUHAMMAD SALEHUDDIN BIN ZAINAL MAZRIdownload (14).png', NULL, '', 'MUHAMMAD SALEHUDDIN BIN ZAINAL MAZRI'),
(29, 'yaya', '019888111', 'yaya22@gmail.com', 'Machang, Kelantan', '12345', 'NOR HIDAYAH BT LUDINdownload (15).png', NULL, '', 'NOR HIDAYAH BT LUDIN'),
(30, 'syafiqah', '0198881091', 'syafiqah@gmail.com', 'Machang, Kelantan', '12345', 'NUR SYAFIQAH ATHIRAH BINTI ZAMRIdownload (17).png', NULL, '', 'NUR SYAFIQAH ATHIRAH BINTI ZAMRI'),
(31, 'ira', '013323232', 'ira@gmail.com', 'Machang, Kelantan', '12345', 'NUR SYAHIRA BINTI AB RASIDdownload (18).png', NULL, '', 'NUR SYAHIRA BINTI AB RASID'),
(32, 'zurah', '017999012', 'zurah@gmail.com', 'Machang, Kelantan', '12345', 'NURUL NAZURAH BINTI WIRAdownload (19).png', NULL, '', 'NURUL NAZURAH BINTI WIRA'),
(33, 'rizqan', '013990909', 'rizqanminutes@gmail.com', 'Machang, Kelantan', '12345', 'RIZQAN BIN SAARIdownload (20).png', NULL, '', 'RIZQAN BIN SAARI'),
(34, 'arifah', '0178891821', 'arifah@gmail.com', 'Machang, Kelantan', '12345', 'SITI NOR ARIFAH BINTI ABD HALIMdownload (21).png', NULL, '', 'SITI NOR ARIFAH BINTI ABD HALIM'),
(35, 'nazif', '0139990001', 'nazif@gmail.com', 'Machang, Kelantan', '12345', 'SY MUHAMMAD NAZIF SY AHMADdownload (22).png', NULL, '', 'SY MUHAMMAD NAZIF SY AHMAD'),
(36, 'edira', '0139900901', 'edira@gmail.com', 'Machang, Kelantan', '12345', 'TENGKU ALIA EDIRA BINTI TUAN MD AZAHANdownload (23).png', NULL, '', 'TENGKU ALIA EDIRA BINTI TUAN MD AZAHAN'),
(37, 'agia', '019999999', 'gia12@gmail.com', 'Machang, Kelantan', '123456789', 'WAN AGIA ARISSA BT WAN MHD JUNNIDdownload (24).png', NULL, '', 'WAN AGIA ARISSA BT WAN MHD JUNNID'),
(38, 'namjoon', '019999912', 'namjoon@gmail.com', 'Kota Bharu, Kelantan', '12345', 'KIM NAMJOON39f12c26816c8338886c13abbef5c6c5.jpg', NULL, '', 'KIM NAMJOON'),
(39, 'jungkook', '013998191', 'jungkook@yahoo.com', 'Kota Bharu, Kelantan', '9089', 'Jeon Jungkook2E96AEAF-72A6-4A7F-8837-88F5CC3C59E2.jpg', NULL, '', 'Jeon Jungkook'),
(40, 'jimin', '013229222', 'jimin@gmail.com', 'Kota Bharu, Kelantan', '2212', 'Park Jimin1200px-Park_Ji-min_at_Aladdin_fansign_in_September_2017_02.jpg', NULL, '', 'Park Jimin'),
(41, 'jin', '0191231312', 'seokjin@gmail.com', 'Kota Bharu, Kelantan', '1111', 'Kim Seokjina881a4a07797e49a3ca4162d2a53c7ad.jpg', NULL, '', 'Kim Seokjin'),
(42, 'suga', '0139912121', 'yoongi@gmail.com', 'Kota Bharu, Kelantan', '11111', 'Min yoongi0fe26311f859768477cd0d2e58c2e13f.jpg', NULL, '', 'Min yoongi');

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