-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Dec 13, 2018 at 06:19 AM
-- Server version: 5.7.23
-- PHP Version: 7.2.10

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
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 utf8mb4 */;

--
-- Database: `simplyask`
--

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

--
-- Table structure for table `tbl_category`
--

DROP TABLE IF EXISTS `tbl_category`;
CREATE TABLE IF NOT EXISTS `tbl_category` (
  `cat_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `cat_name` text NOT NULL,
  PRIMARY KEY (`cat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_category`
--

INSERT INTO `tbl_category` (`cat_id`, `cat_name`) VALUES
(1, 'Technology'),
(2, 'Education'),
(3, 'Health'),
(4, 'Agriculture'),
(5, 'Sport'),
(6, 'Veterinar'),
(7, 'Zoologies'),
(8, 'Architecture'),
(9, 'Social'),
(10, 'Culinary'),
(11, 'Beauty'),
(12, 'Lifestyle'),
(13, 'Programming'),
(14, 'System');

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

--
-- Table structure for table `tbl_data`
--

DROP TABLE IF EXISTS `tbl_data`;
CREATE TABLE IF NOT EXISTS `tbl_data` (
  `data_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `topic_id` text NOT NULL,
  `user_id` text NOT NULL,
  `data_name` text NOT NULL,
  PRIMARY KEY (`data_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

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

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

DROP TABLE IF EXISTS `tbl_feedback`;
CREATE TABLE IF NOT EXISTS `tbl_feedback` (
  `feedback_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `feedback_rating` double DEFAULT NULL,
  `feedback_content` text,
  `feedback_u_id` text NOT NULL,
  `feedback_u_status` text NOT NULL,
  PRIMARY KEY (`feedback_id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

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

INSERT INTO `tbl_feedback` (`feedback_id`, `feedback_rating`, `feedback_content`, `feedback_u_id`, `feedback_u_status`) VALUES
(10, 5, 'Good System', 'iqmal', 'status1'),
(9, 5, 'good system', 'iqmal', 'status1');

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

--
-- Table structure for table `tbl_topic`
--

DROP TABLE IF EXISTS `tbl_topic`;
CREATE TABLE IF NOT EXISTS `tbl_topic` (
  `topic_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` text NOT NULL,
  `cat_id` bigint(20) NOT NULL,
  `topic_name` text NOT NULL,
  `topic_date` date NOT NULL,
  `q` text NOT NULL,
  `att` text NOT NULL,
  `topic_price` text NOT NULL,
  PRIMARY KEY (`topic_id`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_topic`
--

INSERT INTO `tbl_topic` (`topic_id`, `user_id`, `cat_id`, `topic_name`, `topic_date`, `q`, `att`, `topic_price`) VALUES
(24, 'zhafri', 4, 'Agriculture', '2018-12-12', 'Tips on how to plant healthy vegetable', 'zhafri181212045732agriculture.jpg', 'Rm20'),
(23, 'amer', 2, 'Education', '2018-12-12', 'Tips for Score in Exam', 'amer181212045622education.jpg', 'RM30'),
(22, 'agia', 1, 'Industrial Revolution 4.0', '2018-12-12', 'Benefits of IR4.0', 'agia181212045455Technology.jpg', 'RM30'),
(21, 'yaya', 3, 'Health', '2018-12-12', 'Tips for reducing Blood Pressure', 'yaya181212045343health.png', 'RM50'),
(20, 'iqmal', 13, 'Programming problem', '2018-12-12', 'php', 'iqmal181212045259programming.png', 'RM40'),
(25, 'alif', 5, 'Sport', '2018-12-12', 'How to play Petanque', 'alif181212045839Sports.jpg', 'RM10'),
(26, 'nazurah', 6, 'Veterinar', '2018-12-12', 'Tips to take care pet', 'nazurah181212050043veterinar.jpg', 'RM100'),
(27, 'mell', 7, 'Zoologies', '2018-12-12', 'What is the scientific name for Kangaroo', 'mell181212050242zoologies.jpg', 'RM90'),
(28, 'nazif', 10, 'Culinary', '2018-12-12', 'Recipe for cooking the Fried Chicken', 'nazif181212050535culinary.jpg', 'RM50');

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

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

DROP TABLE IF EXISTS `tbl_user`;
CREATE TABLE IF NOT EXISTS `tbl_user` (
  `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 NOT NULL,
  `dateregister` date NOT NULL,
  `token` text NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;

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

INSERT INTO `tbl_user` (`user_id`, `username`, `password`, `name`, `ic`, `add1`, `add2`, `city`, `postcode`, `state`, `phone`, `email`, `picture`, `dateregister`, `token`) VALUES
(8, 'hakim', 'f366008d2e94ba2b02866db50c7abe93', 'hakim', 960715035089, 'PT299 KAMPUNG BADAK', '', 'BACHOK', 16300, 'KELANTAN', '01116926591', 'muhamadhakimahmaddzarawi@gmail.com', 'hakimhakim.PNG', '2018-12-05', 'token'),
(2, 'asri', 'a7e0dfa838cdc612b42302ff8c202db1', 'asri', 82726252524, 'KAMPUNG BULUH MERINDU', '', 'PASIR PUTEH', 86756, 'KELANTAN', '0124572618', 'asri@gmail.com', 'asriasri.JPG', '2018-11-29', 'token'),
(10, 'agia', '8e1142119bb4405fd279bee4bbaa68b6', 'WAN AGIA ARISSA BINTI WAN MUHD JUNNID', 961101037865, 'LOT 1722, TAMAN ADABI', 'KG JIAS', 'PASIR MAS', 17000, 'Kelantan', '0199891300', 'agiaarissa@gmail.com', 'agiaagia.PNG', '2018-12-05', 'token'),
(9, 'iqmal', '66349005470fb9304da9a6aa5556a027', 'MOHAMAD IQMAL USSAIQ BIN ISMAIL', 960120035674, 'Pantai Cahaya Bulan Merindu', '', 'Kota Bharu', 15300, 'Kelantan', '0178915621', 'iqmalussaiq@gmail.com', 'iqmalikmal.PNG', '2018-12-05', 'token'),
(11, 'yaya', '4409eae53c2e26a65cfc24b3a2359eb9', 'NOR HIDAYAH BINTI LUDIN', 98787864336, 'Pantai Cahaya Bulan Merindu', '', 'Kota Bharu', 15300, 'Kelantan', '0178915621', 'yaya@gmail.com', 'yayayaya.PNG', '2018-12-05', 'token'),
(12, 'azim', '1cdc05891432c130a2108fb01a472cb8', 'ABDUL SHAHRUL AZIM BIN SUDIN', 961101037665, 'LOT 1722, TAMAN ADABI', 'KG JIAS', 'PASIR MAS', 17000, 'Kelantan', '0199891312', 'azim@gmail.com', 'azimazim.png', '2018-12-11', 'token'),
(13, 'afiqah', '21a21e58c0048393a26b0af3d7dd6d16', 'AFIQAH NURFARHANA BINTI ROSLAN', 961101031245, 'LOT 1722, TAMAN ADABI', 'KG JIAS', 'PASIR MAS', 17000, 'Kelantan', '0199541300', 'afiqah@gmail.com', 'afiqahpikah.png', '2018-12-11', 'token'),
(14, 'alia', '86c8c6c90abd00c209e39736da1ec1fd', 'ALIA FARHANA BINTI YUSOF', 961102347865, 'Pantai Cahaya Bulan Merindu', '', 'Kota Bharu', 15300, 'Kelantan', '0178915621', 'alia@gmail.com', 'aliaalia.png', '2018-12-11', 'token'),
(15, 'tessa', '81f2190577663a61c0a327e2753e6307', 'MAIZATUL NORATISA BINTI MAT NASIR', 961101023865, 'Pantai Cahaya Bulan Merindu', '', 'Kota Bharu', 15300, 'Kelantan', '0178915671', 'tessa@gmail.com', 'tessatessa.png', '2018-12-11', 'token'),
(16, 'mell', '92d74ff04daaaf9643d28a02fac90a74', 'MARLISA SAZIELA BINTI MANSOR', 961101037876, 'LOT 1722, TAMAN ADABI', 'KG JIAS', 'PASIR MAS', 17000, 'Kelantan', '0199541300', 'mell@gmail.com', 'mellmell.png', '2018-12-11', 'token'),
(17, 'alif', '099a147c0c6bcd34009896b2cc88633c', 'MOHAMMAD ALIF FAISAL BIN SHAARI', 961101036543, 'Pantai Cahaya Bulan Merindu', '', 'Kota Bharu', 15300, 'Kelantan', '0178345621', 'alif@gmail.com', 'alifalif.png', '2018-12-11', 'token'),
(18, 'zhafri', '8c4d1d919e8afa2684d4d175ffeb0519', 'MUHAMAD ALIF ZHAFRI BIN MD AZMAN', 961101037824, 'LOT 1722, TAMAN ADABI', 'KG JIAS', 'PASIR MAS', 17000, 'Kelantan', '0199541312', 'zhafri@gmail.com', 'zhafrizhafri.png', '2018-12-11', 'token'),
(19, 'amer', '8db1b09d6cb44d4150b68a5310688024', 'MUHAMAD AMER AIMAN B MOHD RAZANI', 960715033452, 'LOT 1722, TAMAN ADABI', 'KG JIAS', 'PASIR MAS', 17000, 'Kelantan', '0199891314', 'amer@gmail.com', 'ameramer.png', '2018-12-11', 'token'),
(20, 'badrul', 'e7cd0359c0dd9da73b790eb9bc323714', 'MUHAMAD BADRUL AMIN BIN CHE HUSIN', 960715038907, 'Pantai Cahaya Bulan Merindu', '', 'Kota Bharu', 15300, 'Kelantan', '0178915785', 'badrul@gmail.com', 'badrulbadd.png', '2018-12-11', 'token'),
(21, 'fahmi', 'f11d50d63d3891a44c332e46d6d7d561', 'MUHAMMAD FAHMI BIN MOHD ADZMI', 960715036753, 'LOT 1722, TAMAN ADABI', 'KG JIAS', 'PASIR MAS', 17000, 'Kelantan', '0199891323', 'fahmi@gmail.com', 'fahmifahmi.png', '2018-12-11', 'token'),
(22, 'kj', '771f01104d905386a134a676167edccc', 'MUHAMMAD KHAIRI BIN JAMALLUDDIN', 383736252526398, 'Pantai Cahaya Bulan Merindu', '', 'Kota Bharu', 15300, 'Kelantan', '0178912463', 'kj@gmail.com', 'kjkj.png', '2018-12-11', 'token'),
(23, 'luqman', '4781c13b4bf9b7288a343fd274ff0310', 'MUHAMMAD LUQMAN B RAZALI', 3837362525254232, 'LOT 1722, TAMAN ADABI', 'KG JIAS', 'PASIR MAS', 17000, 'Kelantan', '0199541600', 'luqman@gmail.com', 'luqmanluqman.png', '2018-12-11', 'token'),
(24, 'salleh', '17fff3b1ce0f940abf4d338e72f5cd13', 'MUHAMMAD SALEHUDDIN BIN ZAINAL MAZRI', 961101037856, 'LOT 1722, TAMAN ADABI', 'KG JIAS', 'PASIR MAS', 17000, 'Kelantan', '0199548965', 'salleh@gmail.com', 'sallehsaleh.png', '2018-12-11', 'token'),
(25, 'mashi', 'e1e2f4baed93346ce3071d9f5d1eb867', 'NORMASHIDAYU BINTI ABU BAKAR', 961101037899, 'Pantai Cahaya Bulan Merindu', '', 'Kota Bharu', 15300, 'Kelantan', '0198915621', 'mashi@gmail.com', 'mashimashi.png', '2018-12-11', 'token'),
(26, 'tz', '73bb4387b3075739eacb9cd62ac4049c', 'NUR SYAFIQAH ATHIRAH BINTI ZAMRI', 961101037683, 'LOT 1722, TAMAN ADABI', 'KG JIAS', 'PASIR MAS', 17000, 'Kelantan', '0199891333', 'tz@gmail.com', 'tztz.png', '2018-12-11', 'token'),
(27, 'ira', '3c67080a1a09b022fb9d94e57a75ddad', 'NUR SYAHIRA BINTI AB RASID', 961101037809, 'LOT 1722, TAMAN ADABI', 'KG JIAS', 'PASIR MAS', 17000, 'Kelantan', '0199541345', 'ira@gmail.com', 'iraira.png', '2018-12-11', 'token'),
(28, 'nazurah', 'ac6234c57197486caf1c0d342dacc528', 'NURUL NAZURAH BINTI WIRA', 961101037433, 'LOT 1722, TAMAN ADABI', 'KG JIAS', 'PASIR MAS', 17000, 'Kelantan', '0199896786', 'nazurah@gmail.com', 'nazurahzurah.png', '2018-12-11', 'token'),
(29, 'rizqan', '064d173e60cc8151160cf0370956ace3', 'RIZQAN BIN SAARI', 961101065865, 'LOT 1722, TAMAN ADABI', 'KG JIAS', 'PASIR MAS', 17000, 'Kelantan', '0199541367', 'rizqan@gmail.com', 'rizqanrizqan.png', '2018-12-11', 'token'),
(30, 'eppa', 'f46ead6eb452485880580caf573cfc46', 'SITI NOR ARIFAH BINTI ABD HALIM', 961101037427, 'Pantai Cahaya Bulan Merindu', '', 'Kota Bharu', 15300, 'Kelantan', '0178915467', 'eppa@gmail.com', 'eppaeppa.png', '2018-12-11', 'token'),
(31, 'nazif', 'b21d5a7970915d15ad054a14c182cd05', 'SY MUHAMMAD NAZIF SY AHMAD', 961101037398, 'Pantai Cahaya Bulan Merindu', '', 'Kota Bharu', 15300, 'Kelantan', '0178912354', 'nazif@gmail.com', 'nazifnazif.png', '2018-12-11', 'token'),
(32, 'edira', 'f0bd534f134ebb46a57f3e3015b2eec5', 'TENGKU ALIA EDIRA BINTI TUAN MD AZAHAN', 961101037897, 'Pantai Cahaya Bulan Merindu', '', 'Kota Bharu', 15300, 'Kelantan', '0178315633', 'edira@gmail.com', 'ediraedira.png', '2018-12-11', 'token');
COMMIT;

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