 -- AUTO_INCREMENT for table `admin`
 --
 ALTER TABLE `admin`
-  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
+  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
+--
+-- AUTO_INCREMENT for table `historic_data`
+--
+ALTER TABLE `historic_data`
+  MODIFY `dataId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
+--
+-- AUTO_INCREMENT for table `lockerkey`
+--
+ALTER TABLE `lockerkey`
+  MODIFY `lockerKeyId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
 --
 -- AUTO_INCREMENT for table `maintainceissues`
 --
 ALTER TABLE `maintainceissues`
-  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
+  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
+--
+-- AUTO_INCREMENT for table `payment`
+--
+ALTER TABLE `payment`
+  MODIFY `theId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
+--
+-- AUTO_INCREMENT for table `roomkeyno`
+--
+ALTER TABLE `roomkeyno`
+  MODIFY `keyId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
+--
+-- AUTO_INCREMENT for table `rooms`
+--
+ALTER TABLE `rooms`
+  MODIFY `roomsId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
 --
 -- AUTO_INCREMENT for table `students`
 --
 ALTER TABLE `students`
-  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;
+  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
+--
+-- AUTO_INCREMENT for table `visitor`
+--
+ALTER TABLE `visitor`
+  MODIFY `visitorId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: May 06, 2016 at 05:42 PM
-- Server version: 10.1.9-MariaDB
-- PHP Version: 5.6.15


  ADD UNIQUE KEY `email` (`email`);

--
-- Indexes for table `historic_data`
--
ALTER TABLE `historic_data`
  ADD PRIMARY KEY (`dataId`),
  ADD UNIQUE KEY `studentID` (`studentID`),
  ADD UNIQUE KEY `email` (`email`);

--
-- Indexes for table `lockerkey`
--
ALTER TABLE `lockerkey`
  ADD PRIMARY KEY (`lockerKeyId`),
  ADD UNIQUE KEY `lockerKey` (`lockerKey`);

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

--
-- Indexes for table `payment`
--
ALTER TABLE `payment`
  ADD PRIMARY KEY (`theId`);

--
-- Indexes for table `roomkeyno`
--
ALTER TABLE `roomkeyno`
  ADD PRIMARY KEY (`keyId`),
  ADD UNIQUE KEY `key` (`room_key`);

--
-- Indexes for table `rooms`
--
ALTER TABLE `rooms`
  ADD PRIMARY KEY (`roomsId`),
  ADD UNIQUE KEY `roomNo` (`roomNo`);

--
-- Indexes for table `students`
