text: -- phpMyAdmin SQL Dump
  -- version 4.0.4
  -- http://www.phpmyadmin.net
  --
  -- Host: 127.0.0.1
  -- Generation Time: Sep 08, 2015 at 04:13 PM
  -- Server version: 5.5.32
  -- PHP Version: 5.4.16
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  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 utf8 */;
  
  --
  -- Database: `talc`
  --
  CREATE DATABASE IF NOT EXISTS `talc` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
  USE `talc`;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `academicterm`
  --
  
  CREATE TABLE IF NOT EXISTS `academicterm` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `sch_year` varchar(10) NOT NULL,
    `semester` int(1) NOT NULL,
    `status` varchar(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
  
  --
  -- Dumping data for table `academicterm`
  --
  
  INSERT INTO `academicterm` (`id`, `sch_year`, `semester`, `status`) VALUES
  (1, '2015-2016', 1, 'active');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `accounts`
  --
  
  CREATE TABLE IF NOT EXISTS `accounts` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `empid` int(11) NOT NULL,
    `username` text NOT NULL,
    `password` text NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `designation`
  --
  
  CREATE TABLE IF NOT EXISTS `designation` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `designation` varchar(20) NOT NULL,
    `rate` double(10,2) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
  
  --
  -- Dumping data for table `designation`
  --
  
  INSERT INTO `designation` (`id`, `designation`, `rate`) VALUES
  (1, 'teacher', 0.00);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `employees`
  --
  
  CREATE TABLE IF NOT EXISTS `employees` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `empid` int(11) NOT NULL,
    `lname` varchar(100) NOT NULL,
    `fname` varchar(100) NOT NULL,
    `mname` varchar(100) NOT NULL,
    `address` text NOT NULL,
    `gender` varchar(1) NOT NULL,
    `contactno` varchar(13) NOT NULL,
    `designation` varchar(11) NOT NULL,
    `status` varchar(20) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `enrolment`
  --
  
  CREATE TABLE IF NOT EXISTS `enrolment` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `stud_id` int(11) NOT NULL,
    `yr_and_section` int(11) NOT NULL,
    `academicterm` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
  
  --
  -- Dumping data for table `enrolment`
  --
  
  INSERT INTO `enrolment` (`id`, `stud_id`, `yr_and_section`, `academicterm`) VALUES
  (1, 2, 1, 1),
  (2, 3, 2, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `sections`
  --
  
  CREATE TABLE IF NOT EXISTS `sections` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `yearlevel` int(11) NOT NULL,
    `section` varchar(50) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
  
  --
  -- Dumping data for table `sections`
  --
  
  INSERT INTO `sections` (`id`, `yearlevel`, `section`) VALUES
  (1, 1, 'kamias'),
  (2, 1, 'tangkong');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `student`
  --
  
  CREATE TABLE IF NOT EXISTS `student` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `stud_id` varchar(11) NOT NULL,
    `fname` varchar(100) NOT NULL,
    `mname` varchar(100) NOT NULL,
    `lname` varchar(100) NOT NULL,
    `address` varchar(1000) NOT NULL,
    `dateofbirth` date NOT NULL,
    `gender` varchar(1) NOT NULL,
    `contactno` varchar(13) NOT NULL,
    `guardian` varchar(100) NOT NULL,
    `guardianno` varchar(13) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
  
  --
  -- Dumping data for table `student`
  --
  
  INSERT INTO `student` (`id`, `stud_id`, `fname`, `mname`, `lname`, `address`, `dateofbirth`, `gender`, `contactno`, `guardian`, `guardianno`) VALUES
  (2, '', 'a', 's', 's', 'gg', '2015-09-09', 's', 'ggg', 'ggg', 'gggg'),
  (3, '', 'wer', 'wer', 'wer', 'werwer', '2015-09-19', 'w', 'werwer', 'werwer', 'werwer'),
  (4, '', 'fg', 'fg', 'fg', 'fg', '2015-09-18', 'f', 'fg', 'fg', 'fg');
  
  /*!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 */;
  