-- phpMyAdmin SQL Dump -- version 4.5.1 -- http://www.phpmyadmin.net -- -- Host: 127.0.0.1 -- Generation Time: 06 Jun 2020 pada 08.28 -- Versi Server: 10.1.13-MariaDB -- PHP Version: 5.6.20 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: `psw2` -- -- -------------------------------------------------------- -- -- Struktur dari tabel `kamar` -- CREATE TABLE `kamar` ( `namakamar` varchar(255) NOT NULL, `tipekamar` varchar(255) NOT NULL, `nokamar` varchar(100) NOT NULL, `fotokamar` varchar(255) NOT NULL, `hargakamar` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `kamar` -- INSERT INTO `kamar` (`namakamar`, `tipekamar`, `nokamar`, `fotokamar`, `hargakamar`) VALUES ('HOTMANPARIS ROOM', 'Presidential Room', '20', '', '200000/Hari'), ('Awokawokaw', 'Superior Room', '1', '', '1500000'); -- -------------------------------------------------------- -- -- Struktur dari tabel `user` -- CREATE TABLE `user` ( `id` int(11) NOT NULL, `name` varchar(128) NOT NULL, `email` varchar(128) NOT NULL, `username` varchar(25) NOT NULL, `image` varchar(128) NOT NULL, `password` varchar(255) NOT NULL, `role_id` int(11) NOT NULL, `is_active` tinyint(1) NOT NULL, `date_created` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `user` -- INSERT INTO `user` (`id`, `name`, `email`, `username`, `image`, `password`, `role_id`, `is_active`, `date_created`) VALUES (1, 'Mohamad Muqiit Faturrahman', 'mmuqiit.f14@gmail.com', 'mmuqiit', '7H.jpg', '$2y$10$mTfO4jnUarsSJHPk8ElqdOOkMd9cJo.whKU/VUtgf0IBh/D0hU0tu', 1, 1, 1560266129), (3, 'Syifaa', 'Ipaa2240@gmail.com', 'sipaa', 'default.jpg', '$2y$10$toNUiK/n2LPee1FLIZEha.4ph87tQxBIMwpNTbJ9VcRmGrlEGsPey', 2, 1, 1560692251), (5, 'Fatur', 'fmohamadmuqiit@yahoo.com', 'fmuqiit', 'default.jpg', '$2y$10$05h7FBK9WCPMyHuLTaAkXOkIveyM.fWlQksYnjQs.BjwbjixUg.Ty', 2, 1, 1561043938); -- -------------------------------------------------------- -- -- Struktur dari tabel `users` -- CREATE TABLE `users` ( `user_id` int(11) NOT NULL, `username` varchar(64) NOT NULL, `password` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(20) NOT NULL, `tanggallahir` date NOT NULL, `alamat` varchar(100) NOT NULL, `kota` varchar(100) NOT NULL, `role_id` int(11) NOT NULL, `is_active` int(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `users` -- INSERT INTO `users` (`user_id`, `username`, `password`, `email`, `phone`, `tanggallahir`, `alamat`, `kota`, `role_id`, `is_active`) VALUES (14, 'asidopanjaitan', '$2y$10$41wfM14FKO8bIO.7VPGlQ.XziKRLK1C8QUJ0NEhH1GmBLZDLTPv5e', 'asidopanjaitan67@gmail.com', '081314668846', '2002-02-20', 'Jalan Patuan Anggi No.45', 'Porsea', 1, 1), (16, 'sotarDODO', '$2y$10$ZZdE8XqsOf21tixSFMEqTecwtKhIPP.5Xb5t/Tt42m7lVeucTnQGe', 'sotardodo@gmail.com', '0813123123123', '2020-02-20', 'OKE', 'OKE', 2, 1); -- -------------------------------------------------------- -- -- Struktur dari tabel `user_access_menu` -- CREATE TABLE `user_access_menu` ( `id` int(11) NOT NULL, `role_id` int(11) NOT NULL, `menu_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `user_access_menu` -- INSERT INTO `user_access_menu` (`id`, `role_id`, `menu_id`) VALUES (1, 1, 1), (2, 1, 2), (3, 2, 2), (6, 1, 3), (7, 1, 5); -- -------------------------------------------------------- -- -- Struktur dari tabel `user_menu` -- CREATE TABLE `user_menu` ( `id` int(11) NOT NULL, `menu` varchar(128) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `user_menu` -- INSERT INTO `user_menu` (`id`, `menu`) VALUES (1, 'Admin'), (2, 'User'), (3, 'Menu'); -- -------------------------------------------------------- -- -- Struktur dari tabel `user_role` -- CREATE TABLE `user_role` ( `id` int(11) NOT NULL, `role` varchar(128) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `user_role` -- INSERT INTO `user_role` (`id`, `role`) VALUES (1, 'Administrator'), (2, 'Member'); -- -------------------------------------------------------- -- -- Struktur dari tabel `user_sub_menu` -- CREATE TABLE `user_sub_menu` ( `id` int(11) NOT NULL, `menu_id` int(11) NOT NULL, `title` varchar(128) NOT NULL, `url` varchar(128) NOT NULL, `icon` varchar(128) NOT NULL, `is_active` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data untuk tabel `user_sub_menu` -- INSERT INTO `user_sub_menu` (`id`, `menu_id`, `title`, `url`, `icon`, `is_active`) VALUES (1, 1, 'Dashboard', 'admin', 'fas fa-fw fa-tachometer-alt', 1), (2, 2, 'My Profile', 'user', 'fas fa-fw fa-user', 1), (3, 2, 'Edit Profile', 'user/edit', 'fas fa-fw fa-user-edit', 1), (4, 3, 'Menu Management', 'menu', 'fas fa-fw fa-folder', 1), (5, 3, 'Submenu Management', 'menu/submenu', 'fas fa-fw fa-folder-open', 1), (7, 1, 'Role', 'admin/role', 'fas fa-fw fa-user-tie', 1), (8, 2, 'Change Password', 'user/changepass', 'fas fa-fw fa-key', 1); -- -------------------------------------------------------- -- -- Struktur dari tabel `user_token` -- CREATE TABLE `user_token` ( `id` int(11) NOT NULL, `email` varchar(128) NOT NULL, `token` varchar(128) NOT NULL, `date_created` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Indexes for dumped tables -- -- -- Indexes for table `user` -- ALTER TABLE `user` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`user_id`); -- -- Indexes for table `user_access_menu` -- ALTER TABLE `user_access_menu` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user_menu` -- ALTER TABLE `user_menu` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user_role` -- ALTER TABLE `user_role` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user_sub_menu` -- ALTER TABLE `user_sub_menu` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user_token` -- ALTER TABLE `user_token` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `user` -- ALTER TABLE `user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT for table `user_access_menu` -- ALTER TABLE `user_access_menu` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `user_menu` -- ALTER TABLE `user_menu` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `user_role` -- ALTER TABLE `user_role` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `user_sub_menu` -- ALTER TABLE `user_sub_menu` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `user_token` -- ALTER TABLE `user_token` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; /*!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 */;