-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Apr 27, 2018 at 12:58 PM
-- Server version: 10.1.30-MariaDB
-- PHP Version: 5.6.33

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: `tagor`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `username`, `password`) VALUES
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3');

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

--
-- Table structure for table `laporan`
--

CREATE TABLE `laporan` (
  `id_lapor` varchar(20) NOT NULL,
  `nama` varchar(200) NOT NULL,
  `lat` double NOT NULL,
  `lang` double NOT NULL,
  `alamat` text NOT NULL,
  `komentar` text NOT NULL,
  `respone` text NOT NULL,
  `rating` int(10) NOT NULL,
  `id_petugas` varchar(20) NOT NULL,
  `tanggal` varchar(100) NOT NULL,
  `status` varchar(200) NOT NULL,
  `foto` varchar(200) NOT NULL,
  `foto_sesudah` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `laporan`
--

INSERT INTO `laporan` (`id_lapor`, `nama`, `lat`, `lang`, `alamat`, `komentar`, `respone`, `rating`, `id_petugas`, `tanggal`, `status`, `foto`, `foto_sesudah`) VALUES
('15787', 'asdsad', 0, 0, 'asdsad', 'asd', 'oke', 0, '123', '27-04-2018', 'Selesai', '5uF4Kp4qEv.png', 'xcOflSSI7W.png'),
('1909', 'Mahmud', 0, 0, 'Jl.AM.Sangadji', 'asda', 'Oke sudah kami tangani, terima kasih laporannya..', 0, '123', '21-04-2018', 'Selesai', '13HixfVnPP.jpeg', 'lDXOIF7YTl.png'),
('19497', 'Firman', 0, 0, 'Jl. Soya', 'Got Balakang Soya Kotor, Mampet, Sampah-sampah berserakan di jalan', '', 0, '', '23-03-2018', 'Menunggu', 'dYd0xfkGTy.png', ''),
('2355', 'Fitra', 0, 0, 'asdasd', 'asdqweqwe', '', 0, '', '21-04-2018', 'Menunggu', 'h5e2fMcQge.png', ''),
('26948', 'Dinda', 0, 0, 'Jl. Sirimau', 'Batu merah Got Mampet, Sampah-sampah berserakan di jalanan', '', 0, '', '23-03-2018', 'Menunggu', 'dYd0xfkGTy.png', ''),
('6763', 'Tarjo', 0, 0, 'Jl. Pattimura', 'Tolong', '', 0, '', '12-04-2018', 'Menunggu', '4APTXlbQzM.jpg', '');

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

--
-- Table structure for table `laporan_backup`
--

CREATE TABLE `laporan_backup` (
  `id_lapor` varchar(20) NOT NULL,
  `id_user` int(11) NOT NULL,
  `lat` double NOT NULL,
  `lang` double NOT NULL,
  `alamat` text NOT NULL,
  `komentar` text NOT NULL,
  `respone` text NOT NULL,
  `rating` int(10) NOT NULL,
  `id_petugas` varchar(20) NOT NULL,
  `tanggal` varchar(100) NOT NULL,
  `status` varchar(200) NOT NULL,
  `foto` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `laporan_backup`
--

INSERT INTO `laporan_backup` (`id_lapor`, `id_user`, `lat`, `lang`, `alamat`, `komentar`, `respone`, `rating`, `id_petugas`, `tanggal`, `status`, `foto`) VALUES
('1909', 0, 0, 0, 'asdasd', 'asda', '', 0, '', '21-04-2018', 'Menunggu', '13HixfVnPP.jpeg'),
('19497', 1, 0, 0, 'Jl. Soya', 'Got Balakang Soya Kotor, Mampet, Sampah-sampah berserakan di jalan', '', 0, '', '23-03-2018', 'Menunggu', 'dYd0xfkGTy.png'),
('26948', 1, 0, 0, 'Jl. Sirimau', 'Batu merah Got Mampet, Sampah-sampah berserakan di jalanan', '', 0, '', '23-03-2018', 'Menunggu', 'dYd0xfkGTy.png'),
('6763', 0, 0, 0, 'Jl. Pattimura', 'Tolong', '', 0, '', '12-04-2018', 'Menunggu', '4APTXlbQzM.jpg');

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

--
-- Table structure for table `petugas`
--

CREATE TABLE `petugas` (
  `id_petugas` varchar(20) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `alamat` text NOT NULL,
  `telp` varchar(20) NOT NULL,
  `password` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `petugas`
--

INSERT INTO `petugas` (`id_petugas`, `nama`, `alamat`, `telp`, `password`) VALUES
('123', 'Maimun', 'Batu Merah', '081113123123', '$2y$10$95H9zI.PypYHcmxQCq7m1eRgvLsx3ERGiyHYGCn9ilUag.9/avICK');

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

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

CREATE TABLE `user` (
  `id_user` int(11) NOT NULL,
  `nama` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `telp` varchar(30) NOT NULL,
  `username` varchar(200) NOT NULL,
  `password` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `user` (`id_user`, `nama`, `email`, `telp`, `username`, `password`) VALUES
(1, 'Maimun', 'asd@gmail.com', '123', 'asd', '$2y$10$95H9zI.PypYHcmxQCq7m1eRgvLsx3ERGiyHYGCn9ilUag.9/avICK');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admin`
--
ALTER TABLE `admin`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `laporan`
--
ALTER TABLE `laporan`
  ADD PRIMARY KEY (`id_lapor`);

--
-- Indexes for table `laporan_backup`
--
ALTER TABLE `laporan_backup`
  ADD PRIMARY KEY (`id_lapor`);

--
-- Indexes for table `petugas`
--
ALTER TABLE `petugas`
  ADD PRIMARY KEY (`id_petugas`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`id_user`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `id_user` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
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 */;
