   ADD PRIMARY KEY (`id`);
 
 --
--- Indexes for table `criteria`
---
-ALTER TABLE `criteria`
-  ADD PRIMARY KEY (`id`);
-
---
--- Indexes for table `employee`
---
-ALTER TABLE `employee`
-  ADD PRIMARY KEY (`id`);
-
---
--- Indexes for table `position`
---
-ALTER TABLE `position`
-  ADD PRIMARY KEY (`id`);
-
---
--- Indexes for table `users`
---
-ALTER TABLE `users`
-  ADD PRIMARY KEY (`id`);
-
---
 -- AUTO_INCREMENT for dumped tables
 --
 
 --
--- AUTO_INCREMENT for table `calculation`
---
-ALTER TABLE `calculation`
-  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78;
---
 -- AUTO_INCREMENT for table `candidate`
 --
 ALTER TABLE `candidate`
-  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
---
--- AUTO_INCREMENT for table `criteria`
---
-ALTER TABLE `criteria`
-  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;
---
--- AUTO_INCREMENT for table `employee`
---
-ALTER TABLE `employee`
-  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
---
--- AUTO_INCREMENT for table `position`
---
-ALTER TABLE `position`
-  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
---
--- AUTO_INCREMENT for table `users`
---
-ALTER TABLE `users`
-  MODIFY `id` tinyint(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;COMMIT;
+  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;COMMIT;
 
 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: 25 Apr 2017 pada 01.49
-- Versi Server: 10.2.3-MariaDB-log
-- PHP Version: 7.1.1


--

INSERT INTO `candidate` (`id`, `position_id`, `name`, `born_in`, `born_at`, `gender`, `address`, `phone`, `formal_education`, `unformal_education`, `organization_experience`, `work_experience`, `skills`, `placement_plan`, `photo`, `email`, `last_education`, `examiner_comment`, `interviewer_comment`, `deleted`, `interviewed_at`, `examined_at`, `status`, `position_score`, `position_percentage`) VALUES
(1, 2, 'Rizki Herdatullah', 'Sumenep', '2017-04-25 14:24:00', '0', 'Probolinggo', '082234367866', '-', '-', 'AIESEC', 'Mascitra.com', 'Programming', 'Sumenep', '20170425140942.jpg', 'rizkiherda@gmail.com', 5, 'Ok', 'Good', '0', NULL, NULL, 3, NULL, NULL),
(2, 1, 'Ardyan', 'Jember', '2017-04-25 14:26:49', '0', 'Jember', '089893824', '', '', '', '', '', 'Jakarta', '', 'ardyan@gmail.com', 6, 'Good', 'Siap', '0', NULL, NULL, 3, NULL, NULL),
(3, 2, 'Redi', 'Probolinggo', '2017-04-25 14:27:32', '0', 'Jember', '08333234324', '', '', '', '', '', 'Surabaya', '', 'redi@gmail.com', 5, 'Sip', 'Ok', '0', NULL, NULL, 3, NULL, NULL),
(4, 1, 'Akbar', 'Pamekasan', '2017-04-25 14:27:54', '0', 'Pamekasan', '08222222222', '', '', '', '', '', '', '', 'akbar@gmail.com', 7, 'Ok', 'Sip', '0', NULL, NULL, 3, NULL, NULL),
(5, 2, 'Farida', 'Sumenep', '2017-04-25 14:27:19', '1', 'Probolinggo', '089898989898', '', '', '', '', '', 'Probolinggo', '', 'farida@farida.com', 5, 'Luar BIasa', 'Mantab', '0', NULL, NULL, 3, NULL, NULL),
(6, 1, 'Ayu', 'Jakarta', '2017-04-25 13:49:43', '1', 'Jakarta', '089898374313', '', '', '', '', '', NULL, '', 'ayu@ayu.com', 6, NULL, '', '1', NULL, NULL, -1, NULL, NULL),
(7, 1, 'Ayunda', 'Patrang', '2017-04-25 13:49:40', '1', 'Jember', '08333333333', '-', '-', '-', '-', '-', NULL, '', 'ayunda@ayunda.com', 6, NULL, 'Ok', '1', NULL, NULL, -1, NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `candidate`
