   `lastName` varchar(20) NOT NULL,
   `studentID` varchar(15) NOT NULL,
   `email` varchar(30) DEFAULT NULL,
-  `hostleName` varchar(25) NOT NULL,
+  `hostelName` varchar(25) NOT NULL,
   `roomNo` varchar(10) NOT NULL,
+  `roomKeyNo` varchar(10) NOT NULL,
+  `lockerKeyId` varchar(10) NOT NULL,
   `academicYear` varchar(10) NOT NULL,
+  `yearGroup` varchar(10) NOT NULL,
+  `semester` varchar(15) NOT NULL,
   `contact` varchar(11) NOT NULL,
   `issueDate` date NOT NULL,
   `roomKeyStatus` varchar(15) NOT NULL,

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--


  `firstName` varchar(20) NOT NULL,
  `lastName` varchar(20) NOT NULL,
  `managerId` varchar(15) NOT NULL,
  `email` varchar(50) DEFAULT NULL,
  `password` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `firstName`, `lastName`, `managerId`, `email`, `password`) VALUES
(12, 'Dorcas', 'Tamatey', 'dtamatey', 'dorcas.tamatey@ashesi.edu.gh', 'd894191b6bec8c3942e055836929a4b1'),
(13, 'Gloria', 'Tamatey', 'gtamatey', 'gtamatey@ashesi.edu.gh', '5736b335d2b79d0a98a067905b6e3b3f'),
(18, 'Prince', 'Ofori', 'pofori', 'pofori@ashesi.edu.gh', '34ea50e85135492b244314398c7bc301'),
(19, 'Mohammed ', 'Suala', 'msuala', 'msuala@ashesi.edu.gh', 'd652f5ffa6e133aa456765118783fe3a'),
(20, 'Mohammed ', 'Osmanu', 'mosmanu', 'mosmanu@ashesi.edu.gh', 'cc0315afa49cb999dd78e98a6e16835d'),
(24, 'Ali', 'Ibrahim', 'aibrahim', 'aibrahim@ashesi.edu.gh', 'f86ac59ae46a25d4a21b318eb1d6ab42'),
(25, 'Cathrine', 'Awuah Oppong', 'caoppong', 'caoppong@ashesi.edu.gh', '3d34ddbf71c1865c211903efd834053f'),
(26, 'Maku', 'Tamatey', 'mtamatey', 'maku@gmail.com', 'mtamatey');

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

--
-- Table structure for table `historic_data`
--

CREATE TABLE `historic_data` (
  `dataId` int(11) NOT NULL,
  `firstName` varchar(20) NOT NULL,
  `lastName` varchar(20) NOT NULL,
  `studentID` varchar(15) NOT NULL,
  `email` varchar(30) DEFAULT NULL,
  `hostelName` varchar(25) NOT NULL,
  `roomNo` varchar(10) NOT NULL,
  `keyNo` varchar(10) NOT NULL,
  `academicYear` varchar(10) NOT NULL,
  `yearGroup` varchar(10) NOT NULL,
  `semester` varchar(15) NOT NULL,
  `contact` varchar(11) NOT NULL,
  `issueDate` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `historic_data`
--

INSERT INTO `historic_data` (`dataId`, `firstName`, `lastName`, `studentID`, `email`, `hostelName`, `roomNo`, `keyNo`, `academicYear`, `yearGroup`, `semester`, `contact`, `issueDate`) VALUES
(1, 'Gladys', 'Lamptey', '87162019', 'gladys@gmail.com', 'Ephraim Amu', '206', '206_k1', '2016/2017', '2019', ' Fall', '0268763453', '2016-07-27'),
(2, 'Adwoa', 'Lawson', '12345', 'adwoa@gmail.com', 'Ephraim Amo', '206', '206_k2', '2016/2017', '2018', ' Fall', '0268236459', '2016-07-27'),
(3, 'Addelaid ', 'Boakye', '8374637', 'addelaid@gmail.com', 'Ephraim Amo', '206', '206_k3', '2017', '2019', ' Fall', '02484876488', '2016-07-27'),
(4, 'Dorcas', 'Tamatey', '65142016', 'dorcas.tamatey@gmail.com', 'Oteng Koranten', '208', 'k1', '2016/2017', '2017', ' Fall', '0268116462', '2016-08-29'),
(5, 'Gladys ', 'Nortey', '9384754', 'ashesi.hostel.manager@gmail.co', 'Oteng Koranteng', '837', 'k10', '2016/2017', '2017', ' Fall', '02837465', '2016-08-29'),
(6, 'Obed', 'Nortey', '9384750', 'dorcas.tamatey@ashesi.edu.gh', 'Oteng Koranteng', '837', 'k11', '2016/2017', '2017', ' Fall', '02837465', '2016-08-29'),
(7, 'Leticia', 'Adotey', '98674', 'leticia@gmail', 'Ephraim Amo', '8674', 'key1', '', '2020', ' Fall', '048743', '2016-08-31');

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

--
-- Table structure for table `lockerkey`
--

CREATE TABLE `lockerkey` (
  `lockerKeyId` int(11) NOT NULL,
  `lockerKey` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `lockerkey`
--

INSERT INTO `lockerkey` (`lockerKeyId`, `lockerKey`) VALUES
(2, '206_L2'),
(3, '206_L3'),
(1, '206_L4'),
(6, 'l65rg'),
(4, 'lfg'),
(5, 'locker1'),
(8, 'locker2');

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

