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

START TRANSACTION;



--
-- Database: `crud`
--

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

--
-- Table structure for table `kontak`
--

CREATE TABLE `kontak` (
  `id` int(11) NOT NULL,
  `nama` varchar(150) NOT NULL,
  `nomor_hp` varchar(15) NOT NULL,
  `id_user` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `kontak`
--

INSERT INTO `kontak` (`id`, `nama`, `nomor_hp`, `id_user`) VALUES
(2, 'Mamang User ok', '083738393', 20),
(3, 'omuser', '0876584931', 21),
(6, 'Udin Sedunia Ok', '085697719971', 24);

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

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

CREATE TABLE `user` (
  `id` int(11) NOT NULL,
  `nama` varchar(150) NOT NULL,
  `username` varchar(25) NOT NULL,
  `password` varchar(150) NOT NULL,
  `admin` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `user` (`id`, `nama`, `username`, `password`, `admin`) VALUES
(1, 'Trimans Yogiana', 'trimans', '$2y$10$.AOeL/WUU6YyhOW/ztw69u5zuP8p8tBruewXYj8oTB3DNJu4FnyqK', 1),
(20, 'Mang User', 'manguser', '$2y$10$edubD9mDDiQsXAikImDs8ew76puOLIHiyFDjC2u6ODCn/I0mQJXAO', 0),
(21, 'omuser', 'omuser', '$2y$10$2To2cFoI9IDl0xEUxt2J6OT.gb5ohc5cxrnG153qqMG/uIBojYkJK', 0),
(24, 'Udin Sedunia', 'udin', '$2y$10$d8hZCbJMNSOQw/OyTkHIRuj36TXKAH9SyHq1OizCBMZR.3P.yh3hO', 0);

--
-- Indexes for dumped tables
--

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;
COMMIT;

