-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `kopimili_kkita`
--

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

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

CREATE TABLE `user` (
  `userid` int(5) NOT NULL,
  `email` char(191) NOT NULL,
  `password` varchar(255) NOT NULL,
  `nama_lengkap` varchar(35) NOT NULL,
  `alamat` text NOT NULL,
  `telepon` char(15) NOT NULL,
  `level` varchar(20) NOT NULL,
  `verifikasi` char(1) NOT NULL,
  `token` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `user` (`userid`, `email`, `password`, `nama_lengkap`, `alamat`, `telepon`, `level`, `verifikasi`, `token`) VALUES
(56, 'satria@gamil.com', '$2y$10$X7AEJLgmSnZpafn6l6zyfOzf9jjlv4rWT3htAGJbpX.UB8j5.5Ka6', 'satria12345', 'qiu', '0877622707249', 'user', 'Y', '1cc13a4c842195cd86029ed51d459f1750241a59784dec9050516dcbac049b59'),
(58, 'sahwan@gmail.com', '$2y$10$hLP8Cp/cvIfrcPOOyeuL6uNEJR1B8mhSMHdRsIEaIsNlEGXxhl6Ju', 'sahwan aryadi', 'amsterdam', '082340145133', 'user', 'N', '03e3f388f8ef262df4c14f92c995ae68f974e800f1f649bd66f5034ed3cd5663'),
(59, 'jayadi@gmail.com', 'b5be656a7060dd3525027d6763c33ca0', 'jayadi', 'yuuu', '987654321123456', 'user', 'Y', 'bd8da1c4c2783d6bb4e1f76bc8b7fd42f349be240294a30fe298833a7667c4e2'),
(60, 'admin@gmail.com', '7488e331b8b64e5794da3fa4eb10ad5d', 'admin', 'vn', '435677365214', 'user', 'Y', '427b8a4b8ca821e7fd89c3a31459651fc319433dd7a4abf48b72f7b72800c33f');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `userid` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;
COMMIT;

