-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Dec 13, 2018 at 05:40 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: `takeaction`
--

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

--
-- Table structure for table `tbl_admin`
--

DROP TABLE IF EXISTS `tbl_admin`;
CREATE TABLE IF NOT EXISTS `tbl_admin` (
  `admin_id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_username` varchar(50) NOT NULL,
  `admin_password` varchar(50) NOT NULL,
  `admin_ic` varchar(13) NOT NULL,
  `admin_email` varchar(50) NOT NULL,
  `admin_phonenumber` varchar(10) NOT NULL,
  PRIMARY KEY (`admin_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_admin`
--

INSERT INTO `tbl_admin` (`admin_id`, `admin_username`, `admin_password`, `admin_ic`, `admin_email`, `admin_phonenumber`) VALUES
(1, 'boss', '202cb962ac59075b964b07152d234b70', '950409035217', 'boss@gmail.com', '0169513370'),
(2, 'apih', '202cb962ac59075b964b07152d234b70', '950409059871', 'apih@gmail.com', '0169879950'),
(3, 'admin', '202cb962ac59075b964b07152d234b70', '950685012578', 'admin@gmail.com', '0169517780');

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

--
-- Table structure for table `tbl_comment`
--

DROP TABLE IF EXISTS `tbl_comment`;
CREATE TABLE IF NOT EXISTS `tbl_comment` (
  `comment_id` int(11) NOT NULL AUTO_INCREMENT,
  `comment_section` text NOT NULL,
  PRIMARY KEY (`comment_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_comment`
--

INSERT INTO `tbl_comment` (`comment_id`, `comment_section`) VALUES
(1, ''),
(2, 'hello'),
(3, 'hi'),
(4, 'noted'),
(5, 'Noted'),
(6, 'Noted');

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

--
-- Table structure for table `tbl_complaint`
--

DROP TABLE IF EXISTS `tbl_complaint`;
CREATE TABLE IF NOT EXISTS `tbl_complaint` (
  `complaint_id` int(11) NOT NULL AUTO_INCREMENT,
  `complaint_subject` text,
  `complaint_pic` text,
  `complaint_location` text,
  `complaint_explain` varchar(1000) DEFAULT NULL,
  `complaint_agency` text,
  PRIMARY KEY (`complaint_id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_complaint`
--

INSERT INTO `tbl_complaint` (`complaint_id`, `complaint_subject`, `complaint_pic`, `complaint_location`, `complaint_explain`, `complaint_agency`) VALUES
(28, 'Jalan Rosak', 'alif181213030317room.jpg', 'Depan UiTM Machang', 'Jalan berlubang yang akan mengakibatkan kemalangan.\r\n        ', 'DBKL'),
(29, 'Pencemaran Bunyi', 'alif181213030511', 'Perumahan SBJ', 'Kerja- kerja pembinaan', 'DBKL'),
(30, 'Masalah Sosial', 'alif181213031045', 'Taman SBJ', 'Maksiat berleluasa', 'PDRM'),
(31, 'Pokok Tumbang', 'shaariomar1812130529552014-12-14 11.18.16 1.jpg', 'Jalan belakang sekolah menengah hamzah', 'Pokok tumbang menghalang jalan ke laluan keluar simpang sekolah.\r\n        ', 'JKR'),
(32, 'Mat Moto', 'shaariomar1812130531362014-10-23 12.07.52 1.jpg', 'Perumahan Sri Jaya', 'Penunggang motosikal sering membuat kecoh di kawasan perumahan. dikhuatiri membahayakan keselamatan orang awam.\r\n        ', 'PDRM'),
(33, 'Vandalisme', 'shaariomar1812130532362014-12-05 07.24.20 2.jpg', 'Pondok telefon sekolah bandar', 'Public phone sering rosak walaupun sudah banyak kali dibaiki.\r\n        ', 'DBKL'),
(34, 'Parking', 'shaariomar1812130537292015-07-30 08.00.28 1.jpg', 'Parking Perumahan', 'Penduduk meletak kenderaan di hadapan rumah penduduk lain.\r\n        ', 'DBKL');

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

--
-- 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,
  `dateregister` date NOT NULL,
  `token` text,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 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
(7, 'alif', '202cb962ac59075b964b07152d234b70', 'Mohammad Alif Faisal', 950409035217, 'Pasir Mas', 'Kelantan', 'Pasir Mas', 17020, 'Kelantan', '0169513370', 'aliffaisal95@gmail.com', 'alif2016-01-30 12.13.18 1.jpg', '2018-12-11', 'token'),
(8, 'amir', '202cb962ac59075b964b07152d234b70', 'amirfaqif', 172898786541, 'a', 'aaaa', 'aaa', 12030, 'aaaaaa', '0187651146', 'amir@gmail.com', 'nophoto.png', '2018-12-11', 'token'),
(9, 'harith', '202cb962ac59075b964b07152d234b70', 'Harith Hashim', 950409025671, 'Raub', 'Pahang', 'Raub', 13027, 'Pahang', '0175287750', 'harith@gmail.com', 'nophoto.png', '2018-12-13', 'token'),
(10, 'azwani', '202cb962ac59075b964b07152d234b70', 'Azwani Mahmood', 950109274571, 'Pasir Mas', 'Kelantan', 'Pasir Mas', 17020, 'Kelantan', '0167825501', 'azwani@gmail.com', 'nophoto.png', '2018-12-13', 'token'),
(11, 'shaariomar', '202cb962ac59075b964b07152d234b70', 'Shaari bin Omar', 891027192836, 'Tumpat', 'Kelantan', 'Tumpat', 17020, 'Kelantan', '0125461455', 'shaariomar@gmail.com', 'nophoto.png', '2018-12-13', '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 */;
