-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 13, 2011 at 08:06 AM
-- Server version: 5.5.8
-- PHP Version: 5.3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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: `onlinegradeinquiry`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE IF NOT EXISTS `admin` (
  `adminID` int(11) NOT NULL AUTO_INCREMENT,
  `UserName` varchar(150) NOT NULL,
  `Password` varchar(150) NOT NULL,
  PRIMARY KEY (`adminID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

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

INSERT INTO `admin` (`adminID`, `UserName`, `Password`) VALUES
(1, 'admin', 'admin'),
(2, 'administrator', 'admin'),
(4, 'adm', 'adm'),
(5, 'a', 'asdfasd'),
(6, 's', 's'),
(7, 'admin', 'admin');

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

--
-- Table structure for table `course`
--

CREATE TABLE IF NOT EXISTS `course` (
  `courseID` int(11) NOT NULL AUTO_INCREMENT,
  `coursetitle` varchar(50) NOT NULL,
  `coursedescription` varchar(150) NOT NULL,
  `prerequesit` varchar(50) NOT NULL,
  `hrsperweek` varchar(50) NOT NULL,
  `unit` int(11) NOT NULL,
  `dateadded` date NOT NULL,
  PRIMARY KEY (`courseID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;

--
-- Dumping data for table `course`
--

INSERT INTO `course` (`courseID`, `coursetitle`, `coursedescription`, `prerequesit`, `hrsperweek`, `unit`, `dateadded`) VALUES
(15, 'IS 311', 'Project Develpoment and Quality System', 'IS 212', '3', 3, '2011-09-30'),
(16, 'IS 312', 'Deployment, Maintenance, and Services', 'IS 212', '3', 3, '2011-09-30'),
(17, 'IS 313', 'Evaluation of Business Performance', 'IS 223', '3', 3, '2011-09-30'),
(18, 'IS 301', 'Information System w/ Non-Experimental Research', '', '5', 3, '2011-09-30'),
(19, 'IS 314', 'Operating System', '', '5', 3, '2011-09-30'),
(20, 'IS 316', 'Statistics', 'M COL ALG', '3', 3, '2011-09-30'),
(21, 'IS 315', 'Web Development', 'IS 213', '5', 3, '2011-09-30'),
(22, 'ENG TWB', 'Technical Writing: Business', 'ENG 3', '3', 3, '2011-09-30'),
(23, 'M INV', 'Math of Investment', 'M COL ALG', '3', 3, '2011-09-30'),
(24, 'Eng Plus', 'Communicative Grammar', '', '3', 3, '2011-10-06'),
(25, 'M COL ALG', 'college Algebra', '', '3', 3, '2011-10-06'),
(26, 'NS PHY SCI', 'Physical Science', '', '3', 3, '2011-10-06'),
(27, 'HUM 1', 'Arts, Man And Society', '', '3', 3, '2011-10-06'),
(28, 'Fil 1', 'Komunikasyun sa Akademikong Filipino', '', '3', 3, '2011-10-06'),
(29, 'IS 111', 'Fundamentals of  Info System/ Info. Management', '', '5', 3, '2011-10-06'),
(30, 'IS 112', 'Personal Productivity using Information System', '', '5', 3, '2011-10-06'),
(31, 'SS GEN PSYCH', 'General Psychology with Drug Addiction Education', '', '3', 3, '2011-10-06'),
(32, 'SS PHIL HIST', 'Philippine History', '', '3', 3, '2011-10-06'),
(33, 'PE 1', 'Physical Fitness', '', '2', 2, '2011-10-06'),
(34, 'NSTP 1', 'CWTS/ ROTC/ LTS', '', '3', 3, '2011-10-06');

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

--
-- Table structure for table `major`
--

CREATE TABLE IF NOT EXISTS `major` (
  `majorID` int(11) NOT NULL AUTO_INCREMENT,
  `programId` int(11) NOT NULL,
  `major` varchar(50) NOT NULL,
  `dateadded` date NOT NULL,
  PRIMARY KEY (`majorID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `major`
--

INSERT INTO `major` (`majorID`, `programId`, `major`, `dateadded`) VALUES
(1, 1, 'none', '2011-09-14'),
(2, 15, 'Math', '2011-09-07'),
(3, 16, 'English', '2011-09-07'),
(4, 7, 'Patyanay', '2011-09-09'),
(5, 15, 'T.L.E', '2011-09-27'),
(7, 16, 'Filipino', '2011-03-09'),
(8, 7, 'MIA', '2011-09-11'),
(9, 14, 'MPA', '2011-09-12'),
(11, 14, 'manman', '2011-09-22'),
(12, 16, 'edu', '2011-09-22');

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

--
-- Table structure for table `program`
--

CREATE TABLE IF NOT EXISTS `program` (
  `programId` int(11) NOT NULL AUTO_INCREMENT,
  `programtitle` varchar(50) NOT NULL,
  `programdescription` varchar(150) NOT NULL,
  `dateadded` date NOT NULL,
  PRIMARY KEY (`programId`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `program`
--

INSERT INTO `program` (`programId`, `programtitle`, `programdescription`, `dateadded`) VALUES
(1, 'BSIS', 'Bachelor of Science in Information System', '2011-09-03'),
(7, 'AIT', 'Asyuyit in inpormasyun teknology', '2011-09-14'),
(14, 'BSIT', 'Bachelor of Science in Industrial Technology', '2011-09-11'),
(15, 'BEED', 'Bachelor of Elementary Education', '2011-09-11'),
(16, 'BSED', 'Bachelor of Secondary Education', '2011-09-11');

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

--
-- Table structure for table `regularload`
--

CREATE TABLE IF NOT EXISTS `regularload` (
  `regualrloadId` int(11) NOT NULL AUTO_INCREMENT,
  `year` varchar(150) NOT NULL,
  `sem` varchar(150) NOT NULL,
  `program` varchar(150) NOT NULL,
  `major` varchar(150) NOT NULL,
  `courseID` int(11) NOT NULL,
  PRIMARY KEY (`regualrloadId`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;

--
-- Dumping data for table `regularload`
--

INSERT INTO `regularload` (`regualrloadId`, `year`, `sem`, `program`, `major`, `courseID`) VALUES
(3, 'III', '1st Semester', 'BSIS', 'none', 15),
(4, 'III', '1st Semester', 'BSIS', 'none', 16),
(5, 'III', '1st Semester', 'BSIS', 'none', 17),
(6, 'III', '1st Semester', 'BSIS', 'none', 18),
(7, 'III', '1st Semester', 'BSIS', 'none', 19),
(8, 'III', '1st Semester', 'BSIS', 'none', 20),
(9, 'III', '1st Semester', 'BSIS', 'none', 21),
(10, 'III', '1st Semester', 'BSIS', 'none', 22),
(11, 'III', '1st Semester', 'BSIS', 'none', 23),
(12, 'I', '1st Semester', 'BSIS', 'none', 24),
(13, 'I', '1st Semester', 'BSIS', 'none', 25),
(14, 'I', '1st Semester', 'BSIS', 'none', 26),
(15, 'I', '1st Semester', 'BSIS', 'none', 26),
(16, 'I', '1st Semester', 'BSIS', 'none', 27),
(17, 'I', '1st Semester', 'BSIS', 'none', 28),
(18, 'I', '1st Semester', 'BSIS', 'none', 29),
(19, 'I', '1st Semester', 'BSIS', 'none', 30),
(20, 'I', '1st Semester', 'BSIS', 'none', 31),
(21, 'I', '1st Semester', 'BSIS', 'none', 33),
(22, 'I', '1st Semester', 'BSIS', 'none', 34);

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

--
-- Table structure for table `regularloadtemp`
--

CREATE TABLE IF NOT EXISTS `regularloadtemp` (
  `regularloadtempID` int(11) NOT NULL AUTO_INCREMENT,
  `year` varchar(150) NOT NULL,
  `sem` varchar(150) NOT NULL,
  `program` varchar(150) NOT NULL,
  `major` varchar(150) NOT NULL,
  `courseID` int(11) NOT NULL,
  PRIMARY KEY (`regularloadtempID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `regularloadtemp`
--


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

--
-- Table structure for table `student`
--

CREATE TABLE IF NOT EXISTS `student` (
  `studentID` int(11) NOT NULL AUTO_INCREMENT,
  `UserName` int(10) NOT NULL,
  `Password` varchar(50) NOT NULL,
  `contactnumber` int(11) NOT NULL,
  `uploadphoto` varchar(200) NOT NULL,
  `lastname` varchar(50) NOT NULL,
  `firstname` varchar(50) NOT NULL,
  `middlename` varchar(50) NOT NULL,
  `address` varchar(150) NOT NULL,
  `parentguardian` varchar(50) NOT NULL,
  `gender` varchar(20) NOT NULL,
  `dateofbirth` date NOT NULL,
  `placeofbirth` varchar(150) NOT NULL,
  `scholarship` varchar(150) NOT NULL,
  `programId` int(11) NOT NULL,
  `elemschool` varchar(50) NOT NULL,
  `elemadd` varchar(150) NOT NULL,
  `elemschyr` varchar(50) NOT NULL,
  `secschool` varchar(50) NOT NULL,
  `secadd` varchar(150) NOT NULL,
  `secschyr` varchar(50) NOT NULL,
  `terschool` varchar(50) NOT NULL,
  `teradd` varchar(150) NOT NULL,
  `terschyr` varchar(50) NOT NULL,
  `dateadded` date NOT NULL,
  `position` varchar(50) NOT NULL,
  PRIMARY KEY (`studentID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=101 ;

--
-- Dumping data for table `student`
--

INSERT INTO `student` (`studentID`, `UserName`, `Password`, `contactnumber`, `uploadphoto`, `lastname`, `firstname`, `middlename`, `address`, `parentguardian`, `gender`, `dateofbirth`, `placeofbirth`, `scholarship`, `programId`, `elemschool`, `elemadd`, `elemschyr`, `secschool`, `secadd`, `secschyr`, `terschool`, `teradd`, `terschyr`, `dateadded`, `position`) VALUES
(88, 29000577, 'small213', 2147483647, 'a.jpg', 'Estremos', 'Alfallah', 'Sausa', 'fatima Subd,Talisay City', 'Jasmin Estremos', 'Male', '1987-11-21', 'Bacolod City', 'none', 1, 'School of Jesus', 'Talisay City,Negros Occidental', '1994-2000', 'Uno-r de Talisay', 'Talisay City,Negros Occidental', '2000-2004', 'West Negros College', 'Bacolod City,Negros Occidental', '2008-2009', '2011-09-30', 'Student'),
(89, 29000588, 'maryun', 2147483647, 'DSCN2275.JPG', 'camiling', 'Marione', '', 'talisay towne heights, talisay city', 'Mrs. Camiling', 'Male', '2011-09-01', 'Bacolod City', 'none', 1, 'EELMS', 'Talisay City,Negros Occidental', '2000-2004', 'RBLMHS', 'Talisay City,Negros Occidental', '2004-2008', 'CHMSC Talisay', 'Talisay City,Negros Occidental', '2009-present', '2011-09-30', 'Student'),
(92, 29000449, 'ian', 2147483647, 'DSC05288.JPG', 'Matula', 'Ian', 'Handsome', 'Sipalay City', 'Pabling', 'Male', '2011-10-10', 'Sipalay City', 'n/a', 1, 'Holy Trinity School', 'Sipalay City, Negros Occidental', '2000-2000', 'Holy Trinity School', 'Sipalay City, Negros Occidental', '2000-20002', 'Holy Trinity School', 'Sipalay City, Negros Occidental', '2000-2000', '2011-10-26', 'Student'),
(93, 29000515, 'erwin', 2147483647, 'erwin.jpg', 'Sta.Ana', 'Erwin Russel', 'Genovia', 'Brgy.Concepcion Talisay City Negros Occidental', 'Pabling', 'Male', '2011-10-04', 'Bacolod City', 'none', 1, 'Shema Christian Academy', 'Talisay City,Negros Occidental', '2000-2004', 'Uno-r de Talisay', 'Talisay City,Negros Occidental', '2004-2008', 'CHMSC Talisay', 'Talisay City,Negros Occidental', '2009-present', '2011-10-04', 'Student'),
(94, 29000312, 'mykel', 2147483647, 'mykel.jpg', 'Cachero', 'Michael Angelo', 'Baboy', 'CArmela Subd, Talisay City', 'Pabling', 'Male', '2011-10-11', 'Bacolod City', 'none', 1, 'CHMSC Talisay', 'Talisay City,Negros Occidental', '2000-2004', 'CHMSC Talisay', 'Talisay City,Negros Occidental', '2004-2008', 'CHMSC Talisay', 'Talisay City,Negros Occidental', '2009-present', '2011-10-04', 'Student'),
(95, 29000367, 'yung', 2147483647, 'yung.jpg', 'Abanilla', 'Julius', 'The Great', 'Hda.Violeta Silay City', 'Pabling', 'Male', '2011-10-04', 'Bacolod City', 'none', 1, 'Violeta Integrated School', 'Silay City', '2000-2004', 'Violeta Integrated School', 'Silay City', '2004-2008', 'CHMSC Talisay', 'Talisay City,Negros Occidental', '2009-present', '2011-10-04', 'Student'),
(96, 29000354, 'fritz', 2147483647, 'fritz.jpg', 'Segotier', 'Fritz Foulke', 'P-noid', 'Victorias City', 'Pabling', 'Male', '2011-10-04', 'Bacolod City', 'n/a', 1, 'Violeta Integrated School', 'Sipalay City, Negros Occidental', '2000-2004', 'Violeta Integrated School', 'Silay City', '2004-2008', 'CHMSC Talisay', 'Talisay City,Negros Occidental', '2009-present', '2011-10-04', 'Student'),
(97, 29000426, 'queen', 2147483647, 'queen.jpg', 'Malaga', 'Queenie Rose', 'The Great', 'talisay towne heights, talisay city', 'Pabling', 'Female', '2011-10-04', 'Bacolod City', 'n/a', 1, 'Holy Trinity School', 'Sipalay City, Negros Occidental', '2000-2004', 'Violeta Integrated School', 'Silay City', '2004-2008', 'CHMSC Talisay', 'Talisay City,Negros Occidental', '2009-present', '2011-10-04', 'Student'),
(98, 29000296, 'angie', 2147483647, 'ANGIE.jpg', 'Delima', 'Angie Mae', 'The Skipper', 'Talisay City', 'Pabling', 'Female', '2011-10-04', 'Bacolod City', 'none', 1, 'Bata Elementary School I', 'Brgy. Bata Bacolod City', '2000-2004', 'Bata Secondary School II', 'Brgy. Bata Bacolod City', '2004-2008', 'Bata Tertiary School III', 'Brgy. Bata Bacolod City', '2009-present', '2011-10-04', 'Student'),
(99, 29000143, 'mimi', 2147483647, '229299_1749763343565_1223296885_31571203_4896890_n.jpg', 'Casile', 'ANgel Mae', 'Gale', 'Menlo Village III', 'Zenaida Casile', 'Female', '2011-10-12', 'Bacolod City', 'n/a', 1, 'Living HEritage Christian Academy', 'Taculing Bacolod Cirty', '2000-2004', 'Living HEritage Christian Academy', 'Taculing Bacolod Cirty', '2004-2008', 'Living HEritage Christian Academy', 'Taculing Bacolod Cirty', '2009-present', '2011-10-18', 'Student'),
(100, 1, '1', 0, '189455_205299609484012_100000119235365_930493_1736709_n.jpg', 'qq', 'q', 'q', '', '', '--Select Gender--', '0000-00-00', '', '', 0, '', '', '', '', '', '', '', '', '', '0000-00-00', 'Student');

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

--
-- Table structure for table `studsem`
--

CREATE TABLE IF NOT EXISTS `studsem` (
  `studSemID` int(11) NOT NULL AUTO_INCREMENT,
  `studentID` int(11) NOT NULL,
  `schyr` varchar(150) NOT NULL,
  `sem` varchar(150) NOT NULL,
  `year` varchar(150) NOT NULL,
  `section` varchar(150) NOT NULL,
  `program` varchar(150) NOT NULL,
  `major` varchar(150) NOT NULL,
  `courseID` int(11) NOT NULL,
  `grades` double(50,1) NOT NULL,
  `remarks` varchar(150) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`studSemID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=110 ;

--
-- Dumping data for table `studsem`
--

INSERT INTO `studsem` (`studSemID`, `studentID`, `schyr`, `sem`, `year`, `section`, `program`, `major`, `courseID`, `grades`, `remarks`, `status`) VALUES
(20, 88, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 15, 0.0, '', 0),
(21, 88, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 16, 0.0, '', 0),
(22, 88, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 17, 0.0, '', 0),
(23, 88, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 18, 0.0, '', 0),
(24, 88, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 19, 0.0, '', 0),
(25, 88, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 20, 0.0, '', 0),
(26, 88, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 21, 0.0, '', 0),
(27, 88, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 22, 0.0, '', 0),
(28, 88, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 23, 0.0, '', 0),
(29, 89, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 15, 0.0, '', 0),
(30, 89, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 16, 0.0, '', 0),
(31, 89, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 17, 0.0, '', 0),
(32, 89, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 18, 0.0, '', 0),
(33, 89, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 19, 0.0, '', 0),
(34, 89, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 20, 0.0, '', 0),
(35, 89, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 21, 0.0, '', 0),
(36, 89, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 22, 0.0, '', 0),
(37, 89, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 23, 0.0, '', 0),
(38, 92, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 15, 0.0, '', 0),
(39, 92, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 16, 0.0, '', 0),
(40, 92, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 17, 0.0, '', 0),
(41, 92, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 18, 0.0, '', 0),
(42, 92, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 19, 0.0, '', 0),
(43, 92, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 20, 0.0, '', 0),
(44, 92, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 21, 0.0, '', 0),
(45, 92, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 22, 0.0, '', 0),
(46, 92, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 23, 0.0, '', 0),
(47, 93, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 15, 0.0, '', 0),
(48, 93, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 16, 0.0, '', 0),
(49, 93, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 18, 0.0, '', 0),
(50, 93, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 17, 0.0, '', 0),
(51, 93, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 19, 0.0, '', 0),
(52, 93, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 20, 0.0, '', 0),
(53, 93, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 21, 0.0, '', 0),
(54, 93, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 22, 0.0, '', 0),
(55, 93, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 23, 0.0, '', 0),
(56, 94, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 15, 0.0, '', 0),
(57, 94, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 16, 0.0, '', 0),
(58, 94, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 17, 0.0, '', 0),
(59, 94, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 18, 0.0, '', 0),
(60, 94, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 19, 0.0, '', 0),
(61, 94, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 20, 0.0, '', 0),
(62, 94, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 21, 0.0, '', 0),
(63, 94, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 22, 0.0, '', 0),
(64, 94, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 23, 0.0, '', 0),
(65, 95, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 15, 0.0, '', 0),
(66, 95, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 16, 10.0, '', 0),
(67, 95, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 17, 0.0, '', 0),
(68, 95, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 19, 0.0, '', 0),
(69, 95, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 20, 0.0, '', 0),
(70, 95, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 21, 0.0, '', 0),
(71, 95, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 22, 0.0, '', 0),
(72, 95, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 23, 0.0, '', 0),
(73, 96, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 15, 0.0, '', 0),
(74, 96, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 16, 0.0, '', 0),
(75, 96, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 17, 0.0, '', 0),
(76, 96, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 18, 0.0, '', 0),
(77, 96, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 19, 0.0, '', 0),
(78, 96, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 20, 0.0, '', 0),
(79, 96, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 21, 0.0, '', 0),
(80, 96, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 22, 0.0, '', 0),
(81, 96, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 23, 0.0, '', 0),
(82, 97, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 15, 0.0, '', 0),
(83, 97, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 16, 0.0, '', 0),
(84, 97, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 17, 0.0, '', 0),
(85, 97, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 18, 0.0, '', 0),
(86, 97, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 19, 0.0, '', 0),
(87, 97, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 20, 0.0, '', 0),
(88, 97, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 21, 0.0, '', 0),
(89, 97, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 22, 0.0, '', 0),
(90, 97, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 23, 0.0, '', 0),
(91, 98, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 15, 0.0, '', 0),
(92, 98, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 16, 0.0, '', 0),
(93, 98, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 17, 0.0, '', 0),
(94, 98, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 18, 1.0, '', 0),
(95, 98, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 19, 0.0, '', 0),
(96, 98, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 20, 0.0, '', 0),
(97, 98, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 21, 0.0, '', 0),
(98, 98, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 22, 0.0, '', 0),
(99, 98, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 23, 0.0, '', 0),
(100, 99, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 15, 0.0, '', 0),
(101, 99, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 16, 0.0, '', 0),
(102, 99, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 17, 0.0, '', 0),
(103, 99, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 18, 0.0, '', 0),
(104, 99, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 19, 0.0, '', 0),
(105, 99, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 20, 0.0, '', 0),
(106, 99, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 21, 0.0, '', 0),
(107, 99, '2010-2011', '1st Semester', 'III', 'B', 'BSIS', 'none', 22, 0.0, '', 0),
(108, 99, '2010-2011', '1st Semester', 'III', 'A', 'BSIS', 'none', 23, 0.0, '', 0),
(109, 100, '2010-2011', '1st Semester', 'I', 'A', 'BSIS', 'none', 15, 0.0, '', 0);

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

--
-- Table structure for table `studsemtemp`
--

CREATE TABLE IF NOT EXISTS `studsemtemp` (
  `studsemtempID` int(11) NOT NULL AUTO_INCREMENT,
  `studentID` int(11) NOT NULL,
  `schyr` varchar(150) NOT NULL,
  `sem` varchar(150) NOT NULL,
  `year` varchar(150) NOT NULL,
  `section` varchar(150) NOT NULL,
  `program` varchar(150) NOT NULL,
  `major` varchar(150) NOT NULL,
  `courseID` int(11) NOT NULL,
  `grades` double(50,2) NOT NULL,
  PRIMARY KEY (`studsemtempID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `studsemtemp`
--


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

--
-- Table structure for table `tcourse`
--

CREATE TABLE IF NOT EXISTS `tcourse` (
  `tcourseID` int(11) NOT NULL AUTO_INCREMENT,
  `teacherid` int(11) NOT NULL,
  `courseID` varchar(50) NOT NULL,
  `schyr` varchar(50) NOT NULL,
  `semester` varchar(50) NOT NULL,
  PRIMARY KEY (`tcourseID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;

--
-- Dumping data for table `tcourse`
--

INSERT INTO `tcourse` (`tcourseID`, `teacherid`, `courseID`, `schyr`, `semester`) VALUES
(32, 49, '15', '2010-2011', '1st Semester'),
(33, 49, '16', '2010-2011', '1st Semester'),
(34, 49, '17', '2010-2011', '1st Semester'),
(35, 49, '18', '2010-2011', '1st Semester'),
(36, 49, '19', '2010-2011', '1st Semester'),
(37, 49, '20', '2010-2011', '1st Semester'),
(38, 49, '21', '2010-2011', '1st Semester'),
(39, 50, '21', '2010-2011', '1st Semester');

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

--
-- Table structure for table `tcoursetemp`
--

CREATE TABLE IF NOT EXISTS `tcoursetemp` (
  `tcoursetempID` int(11) NOT NULL AUTO_INCREMENT,
  `teacherid` int(11) NOT NULL,
  `courseID` int(11) NOT NULL,
  `schyr` varchar(150) NOT NULL,
  `semester` varchar(150) NOT NULL,
  PRIMARY KEY (`tcoursetempID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tcoursetemp`
--


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

--
-- Table structure for table `teacher`
--

CREATE TABLE IF NOT EXISTS `teacher` (
  `teacherid` int(11) NOT NULL AUTO_INCREMENT,
  `UserName` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `contactnum` int(50) NOT NULL,
  `upload` varchar(150) NOT NULL,
  `lastname` varchar(50) NOT NULL,
  `firstname` varchar(50) NOT NULL,
  `middlename` varchar(50) NOT NULL,
  `address` varchar(50) NOT NULL,
  `position` varchar(50) NOT NULL,
  `dateadded` date NOT NULL,
  PRIMARY KEY (`teacherid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;

--
-- Dumping data for table `teacher`
--

INSERT INTO `teacher` (`teacherid`, `UserName`, `password`, `contactnum`, `upload`, `lastname`, `firstname`, `middlename`, `address`, `position`, `dateadded`) VALUES
(49, '29000999', 'langcoy', 2147483647, 'langcoy.jpg', 'Langcoy', 'Miss Grace', 'Gwapa', 'Silay City, Negros Occidental', 'Teacher', '2011-10-05'),
(50, '29000998', 'small', 2147483647, '1.jpg', 'Corugda', 'May ', 'Ann', 'Silay City, Negros Occidental', 'Teacher', '2011-10-19');

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

--
-- Table structure for table `tload`
--

CREATE TABLE IF NOT EXISTS `tload` (
  `tloadID` int(11) NOT NULL AUTO_INCREMENT,
  `teacherid` int(11) NOT NULL,
  `programId` int(11) NOT NULL,
  `major` varchar(150) NOT NULL,
  `year` varchar(150) NOT NULL,
  `section` varchar(150) NOT NULL,
  PRIMARY KEY (`tloadID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=53 ;

--
-- Dumping data for table `tload`
--

INSERT INTO `tload` (`tloadID`, `teacherid`, `programId`, `major`, `year`, `section`) VALUES
(48, 49, 1, 'none', 'III', 'A'),
(49, 49, 1, 'none', 'III', 'B'),
(51, 50, 1, 'none', 'III', 'A'),
(52, 50, 1, 'none', 'III', 'B');

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

--
-- Table structure for table `tloadtemp`
--

CREATE TABLE IF NOT EXISTS `tloadtemp` (
  `tloadtempID` int(11) NOT NULL AUTO_INCREMENT,
  `teacherid` int(11) NOT NULL,
  `programId` int(11) NOT NULL,
  `major` varchar(150) NOT NULL,
  `year` varchar(150) NOT NULL,
  `section` varchar(150) NOT NULL,
  PRIMARY KEY (`tloadtempID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tloadtemp`
--

