-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 21, 2013 at 01:27 PM
-- Server version: 5.5.24-log
-- PHP Version: 5.3.13

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: `sis`
--

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

--
-- Table structure for table `class`
--

CREATE TABLE IF NOT EXISTS `class` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `u_code` varchar(255) NOT NULL,
  `teacher_id` int(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `class`
--

INSERT INTO `class` (`id`, `u_code`, `teacher_id`) VALUES
(9, 'I101', 13),
(10, 'I111', 20),
(11, 'IO13', 13);

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

--
-- Table structure for table `grades`
--

CREATE TABLE IF NOT EXISTS `grades` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `stud_id` int(255) NOT NULL,
  `class_code` varchar(255) NOT NULL,
  `fullname` varchar(255) NOT NULL,
  `PQ1` int(255) NOT NULL,
  `PQ2` int(255) NOT NULL,
  `PQ3` int(255) NOT NULL,
  `PQ4` int(255) NOT NULL,
  `PQ5` int(255) NOT NULL,
  `PQ6` int(255) NOT NULL,
  `PQ7` int(255) NOT NULL,
  `PQ8` int(255) NOT NULL,
  `PQ9` int(255) NOT NULL,
  `PQ10` int(255) NOT NULL,
  `PCS1` int(255) NOT NULL,
  `PCS2` int(255) NOT NULL,
  `PPT` int(255) NOT NULL,
  `PEXAM` int(255) NOT NULL,
  `PEXAM2` int(255) NOT NULL,
  `PGRADE` int(255) NOT NULL,
  `DP1` varchar(255) NOT NULL,
  `DP2` varchar(255) NOT NULL,
  `DP3` varchar(255) NOT NULL,
  `DP4` varchar(255) NOT NULL,
  `DP5` varchar(255) NOT NULL,
  `DP6` varchar(255) NOT NULL,
  `DP7` varchar(255) NOT NULL,
  `DP8` varchar(255) NOT NULL,
  `DP9` varchar(255) NOT NULL,
  `DP10` varchar(255) NOT NULL,
  `DP11` varchar(255) NOT NULL,
  `MQ1` int(100) NOT NULL,
  `MQ2` int(100) NOT NULL,
  `MQ3` int(100) NOT NULL,
  `MQ4` int(100) NOT NULL,
  `MQ5` int(100) NOT NULL,
  `MQ6` int(100) NOT NULL,
  `MQ7` int(100) NOT NULL,
  `MQ8` int(100) NOT NULL,
  `MQ9` int(100) NOT NULL,
  `MQ10` int(100) NOT NULL,
  `MCS` int(100) NOT NULL,
  `MCS2` int(100) NOT NULL,
  `MPT` int(100) NOT NULL,
  `MEXAM1` int(100) NOT NULL,
  `MEXAM2` int(100) NOT NULL,
  `MEXAMM` int(100) NOT NULL,
  `MEXAMMM` int(100) NOT NULL,
  `MTG` int(100) NOT NULL,
  `MGRADE` int(100) NOT NULL,
  `DM1` varchar(200) NOT NULL,
  `DM2` varchar(200) NOT NULL,
  `DM3` varchar(200) NOT NULL,
  `DM4` varchar(200) NOT NULL,
  `DM5` varchar(200) NOT NULL,
  `DM6` varchar(200) NOT NULL,
  `DM7` varchar(200) NOT NULL,
  `DM8` varchar(200) NOT NULL,
  `DM9` varchar(200) NOT NULL,
  `DM10` varchar(200) NOT NULL,
  `DM11` varchar(200) NOT NULL,
  `DM12` varchar(200) NOT NULL,
  `SFQ1` int(100) NOT NULL,
  `SFQ2` int(100) NOT NULL,
  `SFQ3` int(100) NOT NULL,
  `SFQ4` int(100) NOT NULL,
  `SFQ5` int(100) NOT NULL,
  `SFQ6` int(100) NOT NULL,
  `SFQ7` int(100) NOT NULL,
  `SFQ8` int(100) NOT NULL,
  `SFQ9` int(100) NOT NULL,
  `SFQ10` int(100) NOT NULL,
  `SFCS` int(100) NOT NULL,
  `SFCS2` int(100) NOT NULL,
  `SFPT` int(100) NOT NULL,
  `SFEXAM` int(100) NOT NULL,
  `SFEXAM2` int(100) NOT NULL,
  `SFTG` int(100) NOT NULL,
  `SFGRADE` int(100) NOT NULL,
  `DSF1` varchar(200) NOT NULL,
  `DSF2` varchar(200) NOT NULL,
  `DSF3` varchar(200) NOT NULL,
  `DSF4` varchar(200) NOT NULL,
  `DSF5` varchar(200) NOT NULL,
  `DSF6` varchar(200) NOT NULL,
  `DSF7` varchar(200) NOT NULL,
  `DSF8` varchar(200) NOT NULL,
  `DSF9` varchar(200) NOT NULL,
  `DSF10` varchar(200) NOT NULL,
  `DSF11` varchar(200) NOT NULL,
  `FQ1` int(100) NOT NULL,
  `FQ2` int(100) NOT NULL,
  `FQ3` int(100) NOT NULL,
  `FQ4` int(100) NOT NULL,
  `FQ5` int(100) NOT NULL,
  `FQ6` int(100) NOT NULL,
  `FQ7` int(100) NOT NULL,
  `FQ8` int(100) NOT NULL,
  `FQ9` int(100) NOT NULL,
  `FQ10` int(100) NOT NULL,
  `FCS` int(100) NOT NULL,
  `FCS2` int(100) NOT NULL,
  `FPT` int(100) NOT NULL,
  `FEXAM` int(100) NOT NULL,
  `FEXAM2` int(100) NOT NULL,
  `FTG` int(100) NOT NULL,
  `FFGRADE` int(100) NOT NULL,
  `DF1` varchar(211) NOT NULL,
  `DF2` varchar(211) NOT NULL,
  `DF3` varchar(211) NOT NULL,
  `DF4` varchar(211) NOT NULL,
  `DF5` varchar(211) NOT NULL,
  `DF6` varchar(211) NOT NULL,
  `DF7` varchar(211) NOT NULL,
  `DF8` varchar(211) NOT NULL,
  `DF9` varchar(211) NOT NULL,
  `DF10` varchar(211) NOT NULL,
  `DF11` varchar(211) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;

--
-- Dumping data for table `grades`
--

INSERT INTO `grades` (`id`, `stud_id`, `class_code`, `fullname`, `PQ1`, `PQ2`, `PQ3`, `PQ4`, `PQ5`, `PQ6`, `PQ7`, `PQ8`, `PQ9`, `PQ10`, `PCS1`, `PCS2`, `PPT`, `PEXAM`, `PEXAM2`, `PGRADE`, `DP1`, `DP2`, `DP3`, `DP4`, `DP5`, `DP6`, `DP7`, `DP8`, `DP9`, `DP10`, `DP11`, `MQ1`, `MQ2`, `MQ3`, `MQ4`, `MQ5`, `MQ6`, `MQ7`, `MQ8`, `MQ9`, `MQ10`, `MCS`, `MCS2`, `MPT`, `MEXAM1`, `MEXAM2`, `MEXAMM`, `MEXAMMM`, `MTG`, `MGRADE`, `DM1`, `DM2`, `DM3`, `DM4`, `DM5`, `DM6`, `DM7`, `DM8`, `DM9`, `DM10`, `DM11`, `DM12`, `SFQ1`, `SFQ2`, `SFQ3`, `SFQ4`, `SFQ5`, `SFQ6`, `SFQ7`, `SFQ8`, `SFQ9`, `SFQ10`, `SFCS`, `SFCS2`, `SFPT`, `SFEXAM`, `SFEXAM2`, `SFTG`, `SFGRADE`, `DSF1`, `DSF2`, `DSF3`, `DSF4`, `DSF5`, `DSF6`, `DSF7`, `DSF8`, `DSF9`, `DSF10`, `DSF11`, `FQ1`, `FQ2`, `FQ3`, `FQ4`, `FQ5`, `FQ6`, `FQ7`, `FQ8`, `FQ9`, `FQ10`, `FCS`, `FCS2`, `FPT`, `FEXAM`, `FEXAM2`, `FTG`, `FFGRADE`, `DF1`, `DF2`, `DF3`, `DF4`, `DF5`, `DF6`, `DF7`, `DF8`, `DF9`, `DF10`, `DF11`) VALUES
(35, 19, 'I101', '', 50, 10, 10, 10, 200, 10, 10, 10, 10, 10, 100, 100, 0, 50, 75, 92, '01/23/2013', '01/19/2013', '01/23/2013', '01/24/2013', '01/26/2013', '01/04/2013', '01/05/2013', '01/25/2013', '01/29/2013', '01/27/2013', '', 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 50, 75, 0, 50, 50, 100, 75, 75, 84, '', '', '', '', '', '', '', '', '', '', '', '', 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 50, 75, 0, 50, 75, 75, 80, '', '', '', '', '', '', '', '', '', '', '', 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 50, 75, 0, 50, 75, 75, 78, '', '', '', '', '', '', '', '', '', '', ''),
(37, 21, 'I111', '', 5, 3, 2, 1, 8, 7, 6, 5, 8, 10, 53, 77, 0, 78, 89, 81, '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 50, 0, 0, 0, 0, 50, 50, 66, '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 50, 0, 0, 50, 50, 58, '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 50, 0, 0, 50, 50, 54, '', '', '', '', '', '', '', '', '', '', ''),
(39, 12, 'IO13', '', 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 100, 100, 0, 100, 100, 100, '', '', '', '', '', '', '', '', '', '', '', 10, 10, 50, 0, 0, 0, 0, 0, 0, 0, 0, 50, 0, 0, 10, 0, 50, 50, 75, '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 50, 0, 0, 50, 50, 63, '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 50, 0, 0, 50, 50, 57, '', '', '', '', '', '', '', '', '', '', '');

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

--
-- Table structure for table `offer`
--

CREATE TABLE IF NOT EXISTS `offer` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `schedule` varchar(255) NOT NULL,
  `units` varchar(255) NOT NULL,
  `stud` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;

--
-- Dumping data for table `offer`
--

INSERT INTO `offer` (`id`, `code`, `subject`, `description`, `schedule`, `units`, `stud`) VALUES
(17, 'i641', 'SOFTWARE ENGINEERING', 'Application', '6:30pm - 7:30pm MWF', '3', '2'),
(19, 'I101', 'FILIPINO 1', 'Unang Aralin', '7:30am - 8:30am MWF', '3', '1'),
(20, 'ITCS102', 'ENGLISH 2', 'Public Speaking', '6:30pm - 7:30pm TTHS', '3', '1'),
(21, 'IO13', 'PHYSICS', 'Introduction to Physics', '6:30pm - 7:30pm MWF', '3', '1'),
(22, 'I452', 'BIOLOGY', 'Study of Life', '6:30pm - 7:30pm TTHS', '3', '2'),
(23, 'i200', 'SOFTWARE ENGINEERING', 'Application', '4:30pm - 5:30pm TTHS', '3', '2'),
(24, 'I111', 'IT PRESENTATION SKILLS', 'Basic Computer', '6:30pm - 7:30pm MWF', '3', '2');

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

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

CREATE TABLE IF NOT EXISTS `student` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(255) NOT NULL,
  `lastname` varchar(255) NOT NULL,
  `middlename` varchar(255) NOT NULL,
  `birtdate` varchar(255) NOT NULL,
  `gender` varchar(255) NOT NULL,
  `courseandyear` varchar(255) NOT NULL,
  `contactnumber` varchar(255) NOT NULL,
  `emailaddress` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `avatar` varchar(255) NOT NULL,
  `account` int(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

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

INSERT INTO `student` (`id`, `firstname`, `lastname`, `middlename`, `birtdate`, `gender`, `courseandyear`, `contactnumber`, `emailaddress`, `address`, `type`, `avatar`, `account`) VALUES
(1, 'Administrator', '', 'admin', '', '', '', '', '', '', 'admin', '', 0),
(12, 'Crismar', 'Tiongco', 'Degamo', 'December 28 1990', 'Male', 'Bachelor of Science in Information Technology - 3rd Year', '09351964376', 'crismartiongco@gmail.com', '#47 Dominican Hill Malaya St. Baguio City', 'student', 'Koala.jpg', 1),
(13, 'Maria', 'Basa', 'teacher', 'July 20 1980', 'Female', 'Bachelor of Science in Information System - Doctoral', '442-4393', 'mariabasa@yahoo.com', '#34 Maria Basa, Subdv. Baguio City', 'teacher', 'Penguins.jpg', 1),
(16, 'Patrick', 'Arce', 'arce', 'January 1 1980', 'Male', 'Bachelor of Science in Information Technology - 1st Year', '', '', '', 'student', 'Desert.jpg', 1),
(17, 'asdasd', 'asd', '', 'January 1 1980', 'Male', 'Bachelor of Science in Information Technology - Masteral', '', '', '', 'teacher', 'default.gif', 1),
(18, 'Nick Angelo', 'Frias', 'matic', 'January 1 1980', 'Male', 'Bachelor of Science in Information Technology - 1st Year', '', '', '', 'student', 'default.gif', 1),
(19, 'Allan', 'Ventura', 'Baldo', 'January 1 1980', 'Male', 'Bachelor of Science in Information Technology - 1st Year', '', '', '', 'student', 'health-peanut.jpg', 1),
(20, 'Raymond', 'Castillo', 'master', 'January 1 1980', 'Male', 'Bachelor of Science in Information Technology - Masteral', '123123', 'teacher@yahoo.com', 'Uc', 'teacher', 'default.gif', 0),
(21, 'Rienos', 'Bucasas', 'hang', 'January 1 1980', 'Male', 'Bachelor of Science in Information Technology - 1st Year', '12313', 'budyo@yahoo.com', 'efsdfsdfs', 'student', 'default.gif', 1);

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

--
-- Table structure for table `subject`
--

CREATE TABLE IF NOT EXISTS `subject` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `stud_id` int(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `units` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `schedule` varchar(255) NOT NULL,
  `grade` int(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=84 ;

--
-- Dumping data for table `subject`
--

INSERT INTO `subject` (`id`, `stud_id`, `code`, `subject`, `units`, `description`, `schedule`, `grade`) VALUES
(79, 19, 'I101', 'FILIPINO 1', '3', 'Unang Aralin', '7:30am - 8:30am MWF', 0),
(81, 21, 'I111', 'IT PRESENTATION SKILLS', '3', 'Basic Computer', '6:30pm - 7:30pm MWF', 0),
(82, 16, 'I101', 'FILIPINO 1', '3', 'Unang Aralin', '7:30am - 8:30am MWF', 0),
(83, 12, 'IO13', 'PHYSICS', '3', 'Introduction to Physics', '6:30pm - 7:30pm MWF', 0);

/*!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 */;
