text: -- phpMyAdmin SQL Dump
  -- version 5.0.2
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1:3308
  -- Generation Time: Nov 20, 2020 at 09:11 AM
  -- Server version: 5.7.31
  -- PHP Version: 7.3.21
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  START TRANSACTION;
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  
  --
  -- Database: `attendance_tracking`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tbladmin`
  --
  
  DROP TABLE IF EXISTS `tbladmin`;
  CREATE TABLE IF NOT EXISTS `tbladmin` (
    `Id` int(10) NOT NULL AUTO_INCREMENT,
    `firstName` varchar(50) NOT NULL,
    `lastName` varchar(50) NOT NULL,
    `emailAddress` varchar(50) NOT NULL,
    `password` varchar(50) NOT NULL,
    PRIMARY KEY (`Id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tbladmin`
  --
  
  INSERT INTO `tbladmin` (`Id`, `firstName`, `lastName`, `emailAddress`, `password`) VALUES
  (1, 'Sadiq', 'Sadiq', 'Ahmedsodiq7@gmail.com', 'admin');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tblattendance`
  --
  
  DROP TABLE IF EXISTS `tblattendance`;
  CREATE TABLE IF NOT EXISTS `tblattendance` (
    `Id` int(10) NOT NULL AUTO_INCREMENT,
    `admissionNo` varchar(255) NOT NULL,
    `classId` varchar(10) NOT NULL,
    `classArmId` varchar(10) NOT NULL,
    `sessionTermId` varchar(10) NOT NULL,
    `status` varchar(10) NOT NULL,
    `dateTimeTaken` varchar(20) NOT NULL,
    PRIMARY KEY (`Id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=176 DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tblattendance`
  --
  
  INSERT INTO `tblattendance` (`Id`, `admissionNo`, `classId`, `classArmId`, `sessionTermId`, `status`, `dateTimeTaken`) VALUES
  (162, 'ASDFLKJ', '1', '2', '1', '1', '2020-11-01'),
  (163, 'HSKSDD', '1', '2', '1', '1', '2020-11-01'),
  (164, 'JSLDKJ', '1', '2', '1', '1', '2020-11-01'),
  (172, 'HSKDS9EE', '1', '4', '1', '1', '2020-11-01'),
  (171, 'JKADA', '1', '4', '1', '0', '2020-11-01'),
  (170, 'JSFSKDJ', '1', '4', '1', '1', '2020-11-01'),
  (173, 'ASDFLKJ', '1', '2', '1', '1', '2020-11-19'),
  (174, 'HSKSDD', '1', '2', '1', '1', '2020-11-19'),
  (175, 'JSLDKJ', '1', '2', '1', '1', '2020-11-19');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tblclass`
  --
  
  DROP TABLE IF EXISTS `tblclass`;
  CREATE TABLE IF NOT EXISTS `tblclass` (
    `Id` int(10) NOT NULL AUTO_INCREMENT,
    `className` varchar(255) NOT NULL,
    PRIMARY KEY (`Id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tblclass`
  --
  
  INSERT INTO `tblclass` (`Id`, `className`) VALUES
  (1, 'Basic 7(JSS1)'),
  (3, 'Basic 8(JSS2)');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tblclassarms`
  --
  
  DROP TABLE IF EXISTS `tblclassarms`;
  CREATE TABLE IF NOT EXISTS `tblclassarms` (
    `Id` int(10) NOT NULL AUTO_INCREMENT,
    `classId` varchar(10) NOT NULL,
    `classArmName` varchar(255) NOT NULL,
    `isAssigned` varchar(10) NOT NULL,
    PRIMARY KEY (`Id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tblclassarms`
  --
  
  INSERT INTO `tblclassarms` (`Id`, `classId`, `classArmName`, `isAssigned`) VALUES
  (2, '1', 'JSS1A', '1'),
  (4, '1', 'JSS1B', '1'),
  (5, '3', 'JSS2A', '0');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tblclassteacher`
  --
  
  DROP TABLE IF EXISTS `tblclassteacher`;
  CREATE TABLE IF NOT EXISTS `tblclassteacher` (
    `Id` int(10) NOT NULL AUTO_INCREMENT,
    `firstName` varchar(255) NOT NULL,
    `lastName` varchar(255) NOT NULL,
    `emailAddress` varchar(255) NOT NULL,
    `password` varchar(20) NOT NULL,
    `phoneNo` varchar(50) NOT NULL,
    `classId` varchar(10) NOT NULL,
    `classArmId` varchar(10) NOT NULL,
    `dateCreated` varchar(50) NOT NULL,
    PRIMARY KEY (`Id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tblclassteacher`
  --
  
  INSERT INTO `tblclassteacher` (`Id`, `firstName`, `lastName`, `emailAddress`, `password`, `phoneNo`, `classId`, `classArmId`, `dateCreated`) VALUES
  (1, 'Samuel', 'Samuel', 'Ahmedsodiq7@gmail.com', 'admin', '09089898999', '1', '2', '2020-10-31'),
  (4, 'Demola', 'Ade', 'Kumolu@gmail.com', '12345', '09672002882', '1', '4', '2020-11-01');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tblsessionterm`
  --
  
  DROP TABLE IF EXISTS `tblsessionterm`;
  CREATE TABLE IF NOT EXISTS `tblsessionterm` (
    `Id` int(10) NOT NULL AUTO_INCREMENT,
    `sessionName` varchar(50) NOT NULL,
    `termId` varchar(50) NOT NULL,
    `isActive` varchar(10) NOT NULL,
    `dateCreated` varchar(50) NOT NULL,
    PRIMARY KEY (`Id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tblsessionterm`
  --
  
  INSERT INTO `tblsessionterm` (`Id`, `sessionName`, `termId`, `isActive`, `dateCreated`) VALUES
  (1, '2019/2020', '1', '1', '2020-10-31'),
  (3, '2019/2020', '2', '0', '2020-10-31');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tblstudents`
  --
  
  DROP TABLE IF EXISTS `tblstudents`;
  CREATE TABLE IF NOT EXISTS `tblstudents` (
    `Id` int(10) NOT NULL AUTO_INCREMENT,
    `firstName` varchar(255) NOT NULL,
    `lastName` varchar(255) NOT NULL,
    `otherName` varchar(255) NOT NULL,
    `admissionNumber` varchar(255) NOT NULL,
    `password` varchar(50) NOT NULL,
    `classId` varchar(10) NOT NULL,
    `classArmId` varchar(10) NOT NULL,
    `dateCreated` varchar(50) NOT NULL,
    PRIMARY KEY (`Id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tblstudents`
  --
  
  INSERT INTO `tblstudents` (`Id`, `firstName`, `lastName`, `otherName`, `admissionNumber`, `password`, `classId`, `classArmId`, `dateCreated`) VALUES
  (1, 'sade', 'seyi', 'ola', 'ASDFLKJ', '12345', '1', '2', '2020-10-31'),
  (3, 'Samuel', 'Rosella', 'ope', 'HSKSDD', '12345', '1', '2', '2020-10-31'),
  (4, 'Daniel', 'Sam', 'Kola', 'JSLDKJ', '12345', '1', '2', '2020-10-31'),
  (5, 'Adewale', 'Ayo', 'Dada', 'JSFSKDJ', '12345', '1', '4', '2020-10-31'),
  (6, 'Jayeiola', 'Ahmad', 'kunle', 'JKADA', '12345', '1', '4', '2020-10-31'),
  (7, 'Smith', 'Mack', 'Mack', 'HSKDS9EE', '12345', '1', '4', '2020-10-31'),
  (8, 'Juliana', 'Debiie', 'Deborah', 'HDJDKOOEKD', '12345', '3', '5', '2020-10-31'),
  (9, 'bayo', 'Olawale', 'Kay', 'JKSDSDF', '12345', '3', '5', '2020-10-31');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tblterm`
  --
  
  DROP TABLE IF EXISTS `tblterm`;
  CREATE TABLE IF NOT EXISTS `tblterm` (
    `Id` int(10) NOT NULL AUTO_INCREMENT,
    `termName` varchar(20) NOT NULL,
    PRIMARY KEY (`Id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tblterm`
  --
  
  INSERT INTO `tblterm` (`Id`, `termName`) VALUES
  (1, 'First'),
  (2, 'Second'),
  (3, 'Third');
  COMMIT;
  
  /*!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 */;
  