 --
 
 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-20 00:02:04', '0', 'Probolinggo', '082234367866', '-', '-', 'AIESEC', 'Mascitra.com', 'Programming', 'Sumenep', '', 'rizkiherda@gmail.com', 5, 'Ok', 'Good', '0', NULL, NULL, 2, NULL, NULL),
-(2, 1, 'Ardyan', 'Jember', '2017-04-20 00:02:04', '0', 'Jember', '089893824', '', '', '', '', '', 'Jakarta', '', 'ardyan@gmail.com', 6, 'Good', 'Siap', '0', NULL, NULL, 2, NULL, NULL),
-(3, 2, 'Redi', 'Probolinggo', '2017-04-20 00:02:04', '0', 'Jember', '08333234324', '', '', '', '', '', 'Surabaya', '', 'redi@gmail.com', 5, 'Sip', 'Ok', '0', NULL, NULL, 2, NULL, NULL),
-(4, 1, 'Akbar', 'Pamekasan', '2017-04-25 01:21:15', '0', 'Pamekasan', '08222222222', '', '', '', '', '', '', '', 'akbar@gmail.com', 7, 'Ok', 'Sip', '0', NULL, NULL, 2, NULL, NULL),
-(5, 2, 'Farida', 'Sumenep', '2017-04-25 01:35:50', '1', 'Probolinggo', '089898989898', '', '', '', '', '', 'Probolinggo', '', 'farida@farida.com', 5, 'Luar BIasa', 'Mantab', '0', NULL, NULL, 2, NULL, NULL);
-
--- --------------------------------------------------------
-
---
--- Struktur dari tabel `criteria`
---
-
-CREATE TABLE `criteria` (
-  `id` int(11) NOT NULL,
-  `criteria_id` varchar(6) DEFAULT NULL,
-  `position_id` int(11) NOT NULL,
-  `weight` tinyint(2) NOT NULL,
-  `weight_value` double NOT NULL,
-  `stage` enum('0','1') NOT NULL COMMENT '1 - Wawancara\n2 - Uji Kemampuan'
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-
---
--- Dumping data untuk tabel `criteria`
---
-
-INSERT INTO `criteria` (`id`, `criteria_id`, `position_id`, `weight`, `weight_value`, `stage`) VALUES
-(1, 'CRI001', 1, 5, 0.1063829787234, '0'),
-(2, 'CRI002', 1, 4, 0.085106382978723, '0'),
-(3, 'CRI003', 1, 2, 0.042553191489362, '0'),
-(4, 'CRI004', 1, 3, 0.063829787234043, '0'),
-(5, 'CRI005', 1, 3, 0.063829787234043, '0'),
-(6, 'CRI006', 1, 5, 0.1063829787234, '0'),
-(7, 'CRI007', 1, 5, 0.1063829787234, '0'),
-(8, 'CRI008', 1, 4, 0.085106382978723, '0'),
-(9, 'CRI009', 1, 3, 0.063829787234043, '1'),
-(10, 'CRI010', 1, 3, 0.063829787234043, '1'),
-(11, 'CRI011', 1, 3, 0.063829787234043, '1'),
-(12, 'CRI012', 1, 4, 0.085106382978723, '1'),
-(13, 'CRI013', 1, 3, 0.063829787234043, '1'),
-(14, 'CRI001', 2, 3, 0.055555555555556, '0'),
-(15, 'CRI002', 2, 5, 0.092592592592593, '0'),
-(16, 'CRI003', 2, 4, 0.074074074074074, '0'),
-(17, 'CRI004', 2, 5, 0.092592592592593, '0'),
-(18, 'CRI005', 2, 4, 0.074074074074074, '0'),
-(19, 'CRI006', 2, 5, 0.092592592592593, '0'),
-(20, 'CRI007', 2, 5, 0.092592592592593, '0'),
-(21, 'CRI008', 2, 5, 0.092592592592593, '0'),
-(22, 'CRI009', 2, 4, 0.074074074074074, '0'),
-(23, 'CRI010', 2, 5, 0.092592592592593, '0'),
-(24, 'CRI011', 2, 2, 0.037037037037037, '0'),
-(25, 'CRI012', 2, 4, 0.074074074074074, '0'),
-(26, 'CRI013', 2, 3, 0.055555555555556, '0'),
-(27, 'CRI001', 4, 4, 0.083333333333333, '0'),
-(28, 'CRI002', 4, 4, 0.083333333333333, '0'),
-(29, 'CRI003', 4, 4, 0.083333333333333, '0'),
-(30, 'CRI004', 4, 3, 0.0625, '0'),
-(31, 'CRI005', 4, 3, 0.0625, '0'),
-(32, 'CRI006', 4, 4, 0.083333333333333, '0'),
-(33, 'CRI007', 4, 4, 0.083333333333333, '0'),
-(34, 'CRI008', 4, 4, 0.083333333333333, '0'),
-(35, 'CRI009', 4, 3, 0.0625, '0'),
-(36, 'CRI010', 4, 4, 0.083333333333333, '0'),
-(37, 'CRI011', 4, 5, 0.10416666666667, '0'),
-(38, 'CRI012', 4, 2, 0.041666666666667, '0'),
-(39, 'CRI013', 4, 4, 0.083333333333333, '0');
-
--- --------------------------------------------------------
-
---
--- Struktur dari tabel `employee`
---
-
-CREATE TABLE `employee` (
-  `id` int(11) NOT NULL,
-  `position_id` int(11) NOT NULL,
-  `name` varchar(255) DEFAULT NULL,
-  `born_in` varchar(255) DEFAULT NULL,
-  `born_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
-  `gender` enum('0','1') DEFAULT NULL,
-  `address` text DEFAULT NULL,
-  `phone` varchar(15) DEFAULT NULL,
-  `email` varchar(255) NOT NULL,
-  `date_started_work` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
-  `salary` int(11) DEFAULT NULL,
-  `deleted` enum('0','1') NOT NULL DEFAULT '0'
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-
---
--- Dumping data untuk tabel `employee`
---
-
-INSERT INTO `employee` (`id`, `position_id`, `name`, `born_in`, `born_at`, `gender`, `address`, `phone`, `email`, `date_started_work`, `salary`, `deleted`) VALUES
-(3, 2, 'Destian Yoga Pradipta', 'Bondowoso', '2017-04-21 18:30:30', '0', 'Bondowoso', '0822233332222', 'destian@destian.com', '2017-04-04 17:00:00', 40000, '0'),
-(4, 2, 'Farida', 'Sumenep', '0000-00-00 00:00:00', '1', 'Probolinggo', '08989898989', 'farida@farida.com', '2017-04-18 17:00:00', 5000, '0');
-
--- --------------------------------------------------------
-
---
--- Struktur dari tabel `position`
---
-
-CREATE TABLE `position` (
-  `id` int(11) NOT NULL,
-  `name` varchar(255) NOT NULL,
-  `deleted` enum('0','1') DEFAULT '0'
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-
---
--- Dumping data untuk tabel `position`
---
-
-INSERT INTO `position` (`id`, `name`, `deleted`) VALUES
-(1, 'Manajer', '0'),
-(2, 'Spesialis', '0'),
-(3, 'Sekertaris', '1');
-
--- --------------------------------------------------------
-
---
--- Struktur dari tabel `users`
---
-
-CREATE TABLE `users` (
-  `id` tinyint(4) NOT NULL,
-  `username` varchar(10) NOT NULL,
-  `password` varchar(100) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-
---
--- Dumping data untuk tabel `users`
---
-
-INSERT INTO `users` (`id`, `username`, `password`) VALUES
-(1, 'admin', '5f4dcc3b5aa765d61d8327deb882cf99');
+(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 `calculation`
---
-ALTER TABLE `calculation`
-  ADD PRIMARY KEY (`id`);
 
 --
 -- Indexes for table `candidate`

  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;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

--
-- Database: `recruit`
--

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

