-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: May 20, 2017 at 05:25 PM
-- Server version: 10.1.16-MariaDB
-- PHP Version: 7.0.9

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

--
-- Database: `hoteldb`
--

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

--
-- Table structure for table `laporankeuanganreceptionist`
--

CREATE TABLE `laporankeuanganreceptionist` (
  `id` int(10) UNSIGNED NOT NULL,
  `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `original_filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `laporankeuanganreceptionist`
--

INSERT INTO `laporankeuanganreceptionist` (`id`, `filename`, `mime`, `original_filename`, `created_at`, `updated_at`) VALUES
(2, 'php59C1.tmp.pdf', 'application/pdf', 'pembayaran_3.pdf', '2017-05-17 00:15:11', '2017-05-17 00:15:11');

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

--
-- Table structure for table `laporanpegawai`
--

CREATE TABLE `laporanpegawai` (
  `id` int(10) UNSIGNED NOT NULL,
  `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `original_filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `laporanpegawai`
--

INSERT INTO `laporanpegawai` (`id`, `filename`, `mime`, `original_filename`, `created_at`, `updated_at`) VALUES
(2, 'phpC117.tmp.pdf', 'application/pdf', 'Tes-Potensi-Akademik-TPA-Download-Gratis.pdf', '2017-05-17 02:11:24', '2017-05-17 02:11:24');

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

--
-- Table structure for table `laporantransaksireceptionist`
--

CREATE TABLE `laporantransaksireceptionist` (
  `id` int(10) UNSIGNED NOT NULL,
  `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `original_filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `laporantransaksireceptionist`
--

INSERT INTO `laporantransaksireceptionist` (`id`, `filename`, `mime`, `original_filename`, `created_at`, `updated_at`) VALUES
(2, 'php3800.tmp.ppt', 'application/vnd.ms-powerpoint', 'Facebook Presentation.ppt', '2017-05-17 00:15:02', '2017-05-17 00:15:02');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2017_05_17_023034_create_tbl_transaksi', 1),
(2, '2017_05_17_023257_create_tbl_receptionist', 2),
(3, '2017_05_17_023538_create_tbl_pegawai', 3),
(4, '2017_05_17_023920_create_tbl_gmaster', 4),
(5, '2017_05_17_024053_create_tbl_administrasi', 5),
(6, '2017_05_17_024234_create_tbl_transaksi', 6),
(7, '2017_05_17_024351_create_tbl_kamar', 7),
(8, '2017_05_17_024814_create_tbl_upload', 8),
(9, '2017_05_17_024942_create_tbl_laporanPegawai', 9),
(10, '2017_05_17_025145_create_tbl_verifikasi', 10),
(11, '2017_05_17_025505_create_tbl_users', 11),
(12, '2017_05_17_061354_create_tbl_uploadKeuanganReceptionist', 12),
(13, '2017_05_17_070444_create_tbl_uploadTransaksiReceptionist', 13),
(14, '2017_05_18_080646_create_tbl_verifikasiPengunjung', 14),
(15, '2017_05_18_084348_create_tbl_verifikasiMasalah', 15),
(16, '2017_05_20_071252_create_tbl_verifikasi_keuangan_manager', 16),
(17, '2017_05_20_071319_create_tbl_verifikasi_masalah_manager', 16),
(18, '2017_05_20_071332_create_tbl_verifikasi_pengunjung_manager', 16);

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

--
-- Table structure for table `tbl_administrasi`
--

CREATE TABLE `tbl_administrasi` (
  `id` int(10) UNSIGNED NOT NULL,
  `nip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `nama_administrasi` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `tahun_masuk` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `jabatan` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tbl_administrasi`
--

INSERT INTO `tbl_administrasi` (`id`, `nip`, `nama_administrasi`, `tahun_masuk`, `jabatan`, `user_id`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, '199704042015032007', 'Jenny Dolok Saribu', '2013', 'Administrasi', 113, NULL, '2017-05-16 20:42:23', '2017-05-16 20:42:23');

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

--
-- Table structure for table `tbl_gmaster`
--

CREATE TABLE `tbl_gmaster` (
  `id` int(10) UNSIGNED NOT NULL,
  `nip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `nama_gmaster` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `jabatan` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tbl_gmaster`
--

INSERT INTO `tbl_gmaster` (`id`, `nip`, `nama_gmaster`, `jabatan`, `user_id`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, '199702252014052001', 'Hendri Pakpahan', 'Master', 111, NULL, '2017-05-16 20:14:43', '2017-05-16 20:14:43');

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

--
-- Table structure for table `tbl_kamar`
--

CREATE TABLE `tbl_kamar` (
  `id` int(10) UNSIGNED NOT NULL,
  `jenis_kamar` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `harga_kamar` int(10) NOT NULL,
  `jumlah_kamar` int(10) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tbl_kamar`
--

INSERT INTO `tbl_kamar` (`id`, `jenis_kamar`, `harga_kamar`, `jumlah_kamar`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'VIP', 250000, 10, NULL, '2017-05-16 20:47:09', '2017-05-16 20:47:09'),
(2, 'Standart', 150000, 10, NULL, '2017-05-16 20:47:26', '2017-05-16 20:49:31'),
(3, 'Ekonomi', 100000, 10, NULL, '2017-05-16 20:47:40', '2017-05-16 20:47:40');

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

--
-- Table structure for table `tbl_pegawai`
--

CREATE TABLE `tbl_pegawai` (
  `id` int(10) UNSIGNED NOT NULL,
  `nip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `nama_pegawai` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `tahun_masuk` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `jabatan` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tbl_pegawai`
--

INSERT INTO `tbl_pegawai` (`id`, `nip`, `nama_pegawai`, `tahun_masuk`, `jabatan`, `user_id`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, '199814202016012010', 'Vedtra Purba', '2016', 'Pegawai', 114, NULL, '2017-05-17 02:08:42', '2017-05-17 02:08:42');

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

--
-- Table structure for table `tbl_receptionist`
--

CREATE TABLE `tbl_receptionist` (
  `id` int(10) UNSIGNED NOT NULL,
  `nip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `nama_receptionist` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `tahun_masuk` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `jabatan` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tbl_receptionist`
--

INSERT INTO `tbl_receptionist` (`id`, `nip`, `nama_receptionist`, `tahun_masuk`, `jabatan`, `user_id`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, '200012252014022004', 'Pangeran Aritonang', '2017', 'Receptionist', 110, NULL, '2017-05-16 20:09:28', '2017-05-16 20:09:28'),
(2, '200112222012012006', 'Sariaman Situmorang', '2006', 'Receptionist', 115, NULL, '2017-05-18 06:26:30', '2017-05-18 06:26:30'),
(3, '199510182012012008', 'Aldi Kogoya', '2008', 'Receptionist', 116, NULL, '2017-05-18 07:22:08', '2017-05-18 07:22:08'),
(4, '199314042015012004', 'Elfira Gultom', '2007', 'Receptionist', 117, NULL, '2017-05-18 07:25:13', '2017-05-18 07:25:13');

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

--
-- Table structure for table `tbl_transaksi`
--

CREATE TABLE `tbl_transaksi` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `jenis_kamar` int(10) UNSIGNED NOT NULL,
  `lama_menginap` int(10) NOT NULL,
  `kontak` varchar(225) COLLATE utf8_unicode_ci NOT NULL,
  `total_harga` int(10) NOT NULL,
  `jumlah_kamar` int(10) NOT NULL,
  `check_in` date NOT NULL,
  `check_out` date NOT NULL,
  `jumlah_total` int(10) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tbl_transaksi`
--

INSERT INTO `tbl_transaksi` (`id`, `nama`, `jenis_kamar`, `lama_menginap`, `kontak`, `total_harga`, `jumlah_kamar`, `check_in`, `check_out`, `jumlah_total`, `deleted_at`, `created_at`, `updated_at`) VALUES
(6, 'Rizky Purba', 3, 2, '081300000000', 200000, 1, '2017-05-03', '2017-05-02', 0, NULL, NULL, NULL),
(7, 'Stefani Manurung', 2, 2, '092324242321', 300000, 1, '2017-05-03', '2017-05-06', 0, NULL, NULL, NULL),
(8, 'Efraim Manalu', 1, 3, '081397025561', 750000, 1, '2017-05-21', '2017-05-24', 0, NULL, NULL, NULL),
(9, 'Ester Aritonang', 2, 2, '081398573401', 900000, 3, '2017-05-21', '2017-05-23', 0, NULL, NULL, NULL);

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

--
-- Table structure for table `upload`
--

CREATE TABLE `upload` (
  `id` int(10) UNSIGNED NOT NULL,
  `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `original_filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `upload`
--

INSERT INTO `upload` (`id`, `filename`, `mime`, `original_filename`, `created_at`, `updated_at`) VALUES
(2, 'php114C.tmp.pdf', 'application/pdf', '120-218-1-PB.pdf', '2017-05-17 00:14:52', '2017-05-17 00:14:52');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(10) UNSIGNED NOT NULL,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `role` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `password`, `role`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'manager', '$2y$10$DJ7fzsjErQ9g9g21Rq2jvuGG2xdnjZbTFBW4.NlXIMk0ApI1xZZZC', 'manager', 'd1nQ4PajFqvLFDZOO964qtBC9nyd1SbzjHQ0SnJiaCno1AOVJu18ejDJTQ60', '2017-01-13 07:06:23', '2017-05-20 08:15:32'),
(110, '200012252014022004', '$2y$10$arznbEPaTGGEarAtvozy5.wAf4AYJ9R9T/juKlUvsSJYeD2NO.Ee2', 'receptionist', 'QGa3sgcQis5Zi4VWOyJI61FOdUjowFKuVvmXrkPM5lArACrj2C2a5NPUAbmn', '2017-05-16 20:09:28', '2017-05-20 03:30:34'),
(111, '199702252014052001', '$2y$10$OUnvj3O8m3kwhWsQQMTA1uXTTe3SDz7jBk6Ai7s1/6SGyw4pIq/d2', 'gmaster', 'ZCJ0SXMbjBN7LB8D7awWI09Qa05qirya7J29PcjIEhz9aSKK1pMeV4ILeeWF', '2017-05-16 20:14:43', '2017-05-20 08:23:31'),
(112, '123131', '$2y$10$Ow3AC3XYCKAJJiGfH6UnHeP1FqHjBWtpl03f7lS6H7vbZHFs7K7Za', 'pegawai', NULL, '2017-05-16 20:29:15', '2017-05-16 20:29:15'),
(113, '199704042015032007', '$2y$10$OZxj.laivvhEXXrW3eIxBOM3J0jnjEpyCQSNCu2gLz7nXNe/qA7Mm', 'administrasi', 'G4xyU6laZcyub5XEzCx5btZh1v3IBMkvts9SnTUx3HEdCn4AxYUBe1vW3kag', '2017-05-16 20:42:23', '2017-05-20 03:03:46'),
(114, '199814202016012010', '$2y$10$Qx1APeBS/PK8wFV3f.dU..lizrwDMkAZYU54BQNhlfh1Vz8JVkgQS', 'pegawai', 'V1oO6lIaEal4GLhWYRDSwTPa6fpkqPa4LDZMuLlnftjUvBMdBGSOb5D18AcV', '2017-05-17 02:08:42', '2017-05-19 08:22:41'),
(115, '200112222012012006', '$2y$10$lQ6ynTEv2wLWYY483wUkt.PA5tVVlQfZpRyzTSr3Bc78Lm5NF0Mt6', 'receptionist', 'ssXox3aQ0xfBLvr93xMmOWffDjyLpzNvkziW65W8OQPA3CSyRhCFjALfrX3u', '2017-05-18 06:26:29', '2017-05-19 07:16:52'),
(116, '199510182012012008', '$2y$10$JXyqPeVwmrj96/YpdrUy.Ovfs/bIa95iRmhL7sbXBMPNbrl5XFoo2', 'receptionist', 'kIcwx025ypUwzWJiVjjNXkE5JMJmHDceczPfgEuXx1L0p5irHHlZyf43HCZ2', '2017-05-18 07:22:07', '2017-05-19 02:32:05'),
(117, '199314042015012004', '$2y$10$ZwZslLGH6q9Uq5NV.Y4tneHbFVSpSPtZ9nVkuxafPF12QaJKvT0Dm', 'receptionist', NULL, '2017-05-18 07:25:13', '2017-05-18 07:25:13');

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

--
-- Table structure for table `verifikasi`
--

CREATE TABLE `verifikasi` (
  `id` int(10) UNSIGNED NOT NULL,
  `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `original_filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `verifikasi`
--

INSERT INTO `verifikasi` (`id`, `filename`, `mime`, `original_filename`, `created_at`, `updated_at`) VALUES
(1, 'php10CA.tmp.pdf', 'application/pdf', '1_tpa1_tesverbal.pdf', '2017-05-18 01:02:32', '2017-05-18 01:02:32'),
(2, 'phpB88A.tmp.pdf', 'application/pdf', '12.pdf', '2017-05-20 00:45:00', '2017-05-20 00:45:00');

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

--
-- Table structure for table `verifikasi_keuangan_manager`
--

CREATE TABLE `verifikasi_keuangan_manager` (
  `id` int(10) UNSIGNED NOT NULL,
  `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `original_filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(225) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `verifikasi_keuangan_manager`
--

INSERT INTO `verifikasi_keuangan_manager` (`id`, `filename`, `mime`, `original_filename`, `status`, `created_at`, `updated_at`) VALUES
(6, 'phpF2D5.tmp.php', 'application/octet-stream', 'index.php', 'accept', '2017-05-20 01:37:40', '2017-05-20 07:14:12'),
(7, 'php79BF.tmp.php', 'application/octet-stream', 'proses.php', 'accept', '2017-05-20 03:06:43', '2017-05-20 08:12:25');

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

--
-- Table structure for table `verifikasi_masalah`
--

CREATE TABLE `verifikasi_masalah` (
  `id` int(10) UNSIGNED NOT NULL,
  `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `original_filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `verifikasi_masalah`
--

INSERT INTO `verifikasi_masalah` (`id`, `filename`, `mime`, `original_filename`, `created_at`, `updated_at`) VALUES
(2, 'phpD01B.tmp.pdf', 'application/pdf', 'W13S4a_.Net_Component.pdf', '2017-05-18 01:53:36', '2017-05-18 01:53:36');

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

--
-- Table structure for table `verifikasi_masalah_manager`
--

CREATE TABLE `verifikasi_masalah_manager` (
  `id` int(10) UNSIGNED NOT NULL,
  `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `original_filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(225) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `verifikasi_masalah_manager`
--

INSERT INTO `verifikasi_masalah_manager` (`id`, `filename`, `mime`, `original_filename`, `status`, `created_at`, `updated_at`) VALUES
(2, 'phpFF3D.tmp.css', 'text/css', 'style.css', 'accept', '2017-05-20 07:40:21', '2017-05-20 08:00:32');

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

--
-- Table structure for table `verifikasi_pengunjung`
--

CREATE TABLE `verifikasi_pengunjung` (
  `id` int(10) UNSIGNED NOT NULL,
  `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `original_filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `verifikasi_pengunjung`
--

INSERT INTO `verifikasi_pengunjung` (`id`, `filename`, `mime`, `original_filename`, `created_at`, `updated_at`) VALUES
(2, 'php4F21.tmp.pdf', 'application/pdf', '120-218-1-PB.pdf', '2017-05-18 01:57:25', '2017-05-18 01:57:25');

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

--
-- Table structure for table `verifikasi_pengunjung_manager`
--

CREATE TABLE `verifikasi_pengunjung_manager` (
  `id` int(10) UNSIGNED NOT NULL,
  `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `original_filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(225) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `verifikasi_pengunjung_manager`
--

INSERT INTO `verifikasi_pengunjung_manager` (`id`, `filename`, `mime`, `original_filename`, `status`, `created_at`, `updated_at`) VALUES
(2, 'php66A.tmp.js', 'application/javascript', 'metode.js', 'request', '2017-05-20 07:38:12', '2017-05-20 07:38:12'),
(3, 'php2364.tmp.php', 'application/octet-stream', 'index.php', 'request', '2017-05-20 08:15:28', '2017-05-20 08:15:28');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `tbl_transaksi`
--
ALTER TABLE `tbl_transaksi`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_transaksi_ibfk_1` (`jenis_kamar`);

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_username_unique` (`username`);

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `laporankeuanganreceptionist`
--
ALTER TABLE `laporankeuanganreceptionist`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `laporanpegawai`
--
ALTER TABLE `laporanpegawai`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `laporantransaksireceptionist`
--
ALTER TABLE `laporantransaksireceptionist`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
--
-- AUTO_INCREMENT for table `tbl_administrasi`
--
ALTER TABLE `tbl_administrasi`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `tbl_gmaster`
--
ALTER TABLE `tbl_gmaster`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `tbl_kamar`
--
ALTER TABLE `tbl_kamar`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `tbl_pegawai`
--
ALTER TABLE `tbl_pegawai`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `tbl_receptionist`
--
ALTER TABLE `tbl_receptionist`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `tbl_transaksi`
--
ALTER TABLE `tbl_transaksi`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `upload`
--
ALTER TABLE `upload`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=118;
--
-- AUTO_INCREMENT for table `verifikasi`
--
ALTER TABLE `verifikasi`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `verifikasi_keuangan_manager`
--
ALTER TABLE `verifikasi_keuangan_manager`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `verifikasi_masalah`
--
ALTER TABLE `verifikasi_masalah`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `verifikasi_masalah_manager`
--
ALTER TABLE `verifikasi_masalah_manager`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `verifikasi_pengunjung`
--
ALTER TABLE `verifikasi_pengunjung`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `verifikasi_pengunjung_manager`
--
ALTER TABLE `verifikasi_pengunjung_manager`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `tbl_transaksi`
--
ALTER TABLE `tbl_transaksi`
  ADD CONSTRAINT `tbl_transaksi_ibfk_1` FOREIGN KEY (`jenis_kamar`) REFERENCES `tbl_kamar` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

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