 -- AUTO_INCREMENT for table `user`
 --
 ALTER TABLE `user`
-  MODIFY `employee_id` int(11) NOT NULL AUTO_INCREMENT;
+  MODIFY `employee_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
 --
 -- Constraints for dumped tables
 --

-- Constraints for table `user`
--
ALTER TABLE `user`
  ADD CONSTRAINT `user_ibfk_2` FOREIGN KEY (`gender`) REFERENCES `gender` (`gender_id`),
  ADD CONSTRAINT `user_ibfk_3` FOREIGN KEY (`civil status`) REFERENCES `civil_status` (`cs_id`),
  ADD CONSTRAINT `user_ibfk_4` FOREIGN KEY (`position`) REFERENCES `position` (`position_id`);

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

--
ALTER TABLE `user`
  ADD PRIMARY KEY (`employee_id`),
  ADD KEY `position` (`position_id`),
  ADD KEY `civil status` (`civil_status_id`),
  ADD KEY `gender` (`gender_id`);

--
-- AUTO_INCREMENT for dumped tables
