 -- AUTO_INCREMENT for table `reservations`
 --
 ALTER TABLE `reservations`
-MODIFY `Reservation_ID` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
+MODIFY `Reservation_ID` int(10) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `return`
 --
 ALTER TABLE `return`
-MODIFY `Return_ID` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
+MODIFY `Return_ID` int(10) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `weeding`
 --

  `Month` int(2) NOT NULL,
  `Day` int(2) NOT NULL,
  `Year` int(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `holidays`
--

INSERT INTO `holidays` (`Holiday_ID`, `Holiday`, `Holiday_Type`, `Month`, `Day`, `Year`) VALUES
(2, 'All Classes are Suspended', 'Suspension', 9, 25, 2015);

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


  `Borrowers_ID` varchar(11) NOT NULL,
  `Date_Reserved` datetime NOT NULL,
  `Status` varchar(8) NOT NULL DEFAULT 'active'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

