-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 15, 2019 at 06:22 AM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 7.1.11

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `dbtbi`
--

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

--
-- Table structure for table `tblaccounts`
--

CREATE TABLE `tblaccounts` (
  `ACCOUNTSID` int(11) NOT NULL,
  `USERNAME` varchar(50) NOT NULL,
  `PASSWORD` varchar(50) NOT NULL,
  `USERTYPE` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblaccounts`
--

INSERT INTO `tblaccounts` (`ACCOUNTSID`, `USERNAME`, `PASSWORD`, `USERTYPE`) VALUES
(1, 'Admin', '1010', 'Administrator'),
(2, 'Andrew', '111', 'Administrator'),
(3, 'Jesriel', '1234', 'Administrator'),
(5, 'Marc', '12', 'Administrator');

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

--
-- Table structure for table `tblanswer`
--

CREATE TABLE `tblanswer` (
  `ID` int(11) NOT NULL,
  `TEACHERID` int(11) NOT NULL,
  `STUDENTID` int(11) NOT NULL,
  `QUESTIONID` varchar(100) DEFAULT NULL,
  `ANSWER` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblanswer`
--

INSERT INTO `tblanswer` (`ID`, `TEACHERID`, `STUDENTID`, `QUESTIONID`, `ANSWER`) VALUES
(550, 6, 1234, 'My teacher demonstrates knowledge of content and related pedagogy', 3),
(551, 6, 1234, 'My teacher demonstrates knowledge of how students learn', 4),
(552, 6, 1234, 'My teacher demonstrates awareness of student skills and knowledge', 3),
(553, 6, 1234, 'My teacher projects respect ', 4),
(554, 6, 1234, 'My teacher demonstrates positive attitude and openness to students', 4),
(555, 6, 1234, 'My teacher demonstrates willingness to be flexible', 5),
(556, 6, 1234, 'My teacher creates a stimulating and effective environment for learning', 3),
(557, 6, 1234, 'My teacher establishes and maintains a disciplined environment', 2),
(558, 6, 1234, 'My teacher effectively organizes the class', 3),
(559, 6, 1234, 'My teacher has established procedures that govern student verbal participation during different type', 5),
(560, 6, 1234, 'My teacher has established procedures that govern student movement in the classroom during different', 4),
(561, 6, 1234, 'My teacher stops inappropriate behavior promptly and consistently, yet maintains the dignity of the ', 4),
(562, 6, 1234, 'My teacher\'s materials, supplies, and equipment are ready at the start of the lessons or instruction', 5),
(563, 6, 1234, 'My teacher releases my grades on time', 3),
(564, 6, 1234, 'My teacher observes promptness in reporting to class', 4),
(565, 6, 1234, 'My teacher begins lesson or instructional activity with an appropriate review of the previous lesson', 5),
(566, 6, 1234, 'My teacher speaks fluently and precisely', 4),
(567, 6, 1234, 'My teacher presents the lesson or instructional activity using concepts and language understandable ', 3),
(568, 6, 1234, 'My teacher provides relevant examples and demonstrations to illustrate concepts and skills', 4),
(569, 6, 1234, 'My teacher assigns tasks appropriate to student level', 4),
(570, 6, 1234, 'My teacher asks appropriate levels of questions', 4),
(571, 6, 1234, 'My teacher conducts lessons or instructional activities at an appropriate pace', 3),
(572, 6, 1234, 'My teacher makes assignments clear', 4),
(573, 6, 1234, 'My teacher summarizes the main point(s) at the end of the lesson or instructional activities', 4),
(574, 6, 1234, 'My teacher maintains clear, firm and reasonable work standards.', 4),
(575, 6, 1234, 'My teacher circulates during class to check all students’ performance', 4),
(576, 6, 1234, 'My teacher routinely uses oral, written or other work products to check student progress', 2),
(577, 6, 1234, 'My teacher develops an instructional plan based upon school and curricular goals', 3),
(578, 6, 1234, 'My teacher uses diagnostic information from tests and other assessment procedures to develop and rev', 4),
(579, 6, 1234, 'My teacher develops an instructional plan that matches/aligns objective, learning strategies, assess', 4),
(580, 6, 4321, 'My teacher demonstrates knowledge of content and related pedagogy', 4),
(581, 6, 4321, 'My teacher demonstrates knowledge of how students learn', 4),
(582, 6, 4321, 'My teacher demonstrates awareness of student skills and knowledge', 3),
(583, 6, 4321, 'My teacher projects respect ', 4),
(584, 6, 4321, 'My teacher demonstrates positive attitude and openness to students', 5),
(585, 6, 4321, 'My teacher demonstrates willingness to be flexible', 4),
(586, 6, 4321, 'My teacher creates a stimulating and effective environment for learning', 5),
(587, 6, 4321, 'My teacher establishes and maintains a disciplined environment', 4),
(588, 6, 4321, 'My teacher effectively organizes the class', 3),
(589, 6, 4321, 'My teacher has established procedures that govern student verbal participation during different type', 4),
(590, 6, 4321, 'My teacher has established procedures that govern student movement in the classroom during different', 3),
(591, 6, 4321, 'My teacher stops inappropriate behavior promptly and consistently, yet maintains the dignity of the ', 4),
(592, 6, 4321, 'My teacher\'s materials, supplies, and equipment are ready at the start of the lessons or instruction', 4),
(593, 6, 4321, 'My teacher releases my grades on time', 4),
(594, 6, 4321, 'My teacher observes promptness in reporting to class', 5),
(595, 6, 4321, 'My teacher begins lesson or instructional activity with an appropriate review of the previous lesson', 3),
(596, 6, 4321, 'My teacher speaks fluently and precisely', 5),
(597, 6, 4321, 'My teacher presents the lesson or instructional activity using concepts and language understandable ', 3),
(598, 6, 4321, 'My teacher provides relevant examples and demonstrations to illustrate concepts and skills', 4),
(599, 6, 4321, 'My teacher assigns tasks appropriate to student level', 5),
(600, 6, 4321, 'My teacher asks appropriate levels of questions', 4),
(601, 6, 4321, 'My teacher conducts lessons or instructional activities at an appropriate pace', 3),
(602, 6, 4321, 'My teacher makes assignments clear', 4),
(603, 6, 4321, 'My teacher summarizes the main point(s) at the end of the lesson or instructional activities', 4),
(604, 6, 4321, 'My teacher maintains clear, firm and reasonable work standards.', 4),
(605, 6, 4321, 'My teacher circulates during class to check all students’ performance', 3),
(606, 6, 4321, 'My teacher routinely uses oral, written or other work products to check student progress', 5),
(607, 6, 4321, 'My teacher develops an instructional plan based upon school and curricular goals', 4),
(608, 6, 4321, 'My teacher uses diagnostic information from tests and other assessment procedures to develop and rev', 4),
(609, 6, 4321, 'My teacher develops an instructional plan that matches/aligns objective, learning strategies, assess', 4),
(610, 6, 5678, 'My teacher demonstrates knowledge of content and related pedagogy', 2),
(611, 6, 5678, 'My teacher demonstrates knowledge of how students learn', 3),
(612, 6, 5678, 'My teacher demonstrates awareness of student skills and knowledge', 4),
(613, 6, 5678, 'My teacher projects respect ', 5),
(614, 6, 5678, 'My teacher demonstrates positive attitude and openness to students', 2),
(615, 6, 5678, 'My teacher demonstrates willingness to be flexible', 1),
(616, 6, 5678, 'My teacher creates a stimulating and effective environment for learning', 3),
(617, 6, 5678, 'My teacher establishes and maintains a disciplined environment', 1),
(618, 6, 5678, 'My teacher effectively organizes the class', 3),
(619, 6, 5678, 'My teacher has established procedures that govern student verbal participation during different type', 4),
(620, 6, 5678, 'My teacher has established procedures that govern student movement in the classroom during different', 4),
(621, 6, 5678, 'My teacher stops inappropriate behavior promptly and consistently, yet maintains the dignity of the ', 5),
(622, 6, 5678, 'My teacher\'s materials, supplies, and equipment are ready at the start of the lessons or instruction', 3),
(623, 6, 5678, 'My teacher releases my grades on time', 5),
(624, 6, 5678, 'My teacher observes promptness in reporting to class', 2),
(625, 6, 5678, 'My teacher begins lesson or instructional activity with an appropriate review of the previous lesson', 2),
(626, 6, 5678, 'My teacher speaks fluently and precisely', 4),
(627, 6, 5678, 'My teacher presents the lesson or instructional activity using concepts and language understandable ', 5),
(628, 6, 5678, 'My teacher provides relevant examples and demonstrations to illustrate concepts and skills', 3),
(629, 6, 5678, 'My teacher assigns tasks appropriate to student level', 5),
(630, 6, 5678, 'My teacher asks appropriate levels of questions', 3),
(631, 6, 5678, 'My teacher conducts lessons or instructional activities at an appropriate pace', 4),
(632, 6, 5678, 'My teacher makes assignments clear', 3),
(633, 6, 5678, 'My teacher summarizes the main point(s) at the end of the lesson or instructional activities', 4),
(634, 6, 5678, 'My teacher maintains clear, firm and reasonable work standards.', 5),
(635, 6, 5678, 'My teacher circulates during class to check all students’ performance', 3),
(636, 6, 5678, 'My teacher routinely uses oral, written or other work products to check student progress', 2),
(637, 6, 5678, 'My teacher develops an instructional plan based upon school and curricular goals', 1),
(638, 6, 5678, 'My teacher uses diagnostic information from tests and other assessment procedures to develop and rev', 1),
(639, 6, 1212, 'My teacher demonstrates knowledge of content and related pedagogy', 3),
(640, 6, 1212, 'My teacher demonstrates knowledge of how students learn', 3),
(641, 6, 1212, 'My teacher demonstrates awareness of student skills and knowledge', 5),
(642, 6, 1212, 'My teacher projects respect ', 5),
(643, 6, 1212, 'My teacher demonstrates positive attitude and openness to students', 5),
(644, 6, 1212, 'My teacher demonstrates willingness to be flexible', 4),
(645, 6, 1212, 'My teacher creates a stimulating and effective environment for learning', 5),
(646, 6, 1212, 'My teacher establishes and maintains a disciplined environment', 3),
(647, 6, 1212, 'My teacher effectively organizes the class', 5),
(648, 6, 1212, 'My teacher has established procedures that govern student verbal participation during different type', 5),
(649, 6, 1212, 'My teacher has established procedures that govern student movement in the classroom during different', 4),
(650, 6, 1212, 'My teacher stops inappropriate behavior promptly and consistently, yet maintains the dignity of the ', 3),
(651, 6, 1212, 'My teacher\'s materials, supplies, and equipment are ready at the start of the lessons or instruction', 3),
(652, 6, 1212, 'My teacher releases my grades on time', 5),
(653, 6, 1212, 'My teacher observes promptness in reporting to class', 5),
(654, 6, 1212, 'My teacher begins lesson or instructional activity with an appropriate review of the previous lesson', 5),
(655, 6, 1212, 'My teacher speaks fluently and precisely', 5),
(656, 6, 1212, 'My teacher presents the lesson or instructional activity using concepts and language understandable ', 3),
(657, 6, 1212, 'My teacher provides relevant examples and demonstrations to illustrate concepts and skills', 3),
(658, 6, 1212, 'My teacher assigns tasks appropriate to student level', 2),
(659, 6, 1212, 'My teacher asks appropriate levels of questions', 1),
(660, 6, 1212, 'My teacher conducts lessons or instructional activities at an appropriate pace', 5),
(661, 6, 1212, 'My teacher makes assignments clear', 5),
(662, 6, 1212, 'My teacher summarizes the main point(s) at the end of the lesson or instructional activities', 5),
(663, 6, 1212, 'My teacher maintains clear, firm and reasonable work standards.', 5),
(664, 6, 1212, 'My teacher circulates during class to check all students’ performance', 5),
(665, 6, 1212, 'My teacher routinely uses oral, written or other work products to check student progress', 5),
(666, 6, 1212, 'My teacher develops an instructional plan based upon school and curricular goals', 5),
(667, 6, 1212, 'My teacher uses diagnostic information from tests and other assessment procedures to develop and rev', 4),
(668, 6, 1212, 'My teacher develops an instructional plan that matches/aligns objective, learning strategies, assess', 4),
(669, 8, 1212, 'My teacher demonstrates knowledge of content and related pedagogy', 1),
(670, 8, 1212, 'My teacher demonstrates knowledge of how students learn', 2),
(671, 8, 1212, 'My teacher demonstrates awareness of student skills and knowledge', 3),
(672, 8, 1212, 'My teacher projects respect ', 4),
(673, 8, 1212, 'My teacher demonstrates positive attitude and openness to students', 5),
(674, 8, 1212, 'My teacher demonstrates willingness to be flexible', 1),
(675, 8, 1212, 'My teacher creates a stimulating and effective environment for learning', 2),
(676, 8, 1212, 'My teacher establishes and maintains a disciplined environment', 3),
(677, 8, 1212, 'My teacher effectively organizes the class', 4),
(678, 8, 1212, 'My teacher has established procedures that govern student verbal participation during different type', 5),
(679, 8, 1212, 'My teacher has established procedures that govern student movement in the classroom during different', 1),
(680, 8, 1212, 'My teacher stops inappropriate behavior promptly and consistently, yet maintains the dignity of the ', 2),
(681, 8, 1212, 'My teacher\'s materials, supplies, and equipment are ready at the start of the lessons or instruction', 3),
(682, 8, 1212, 'My teacher releases my grades on time', 4),
(683, 8, 1212, 'My teacher observes promptness in reporting to class', 5),
(684, 8, 1212, 'My teacher begins lesson or instructional activity with an appropriate review of the previous lesson', 1),
(685, 8, 1212, 'My teacher speaks fluently and precisely', 3),
(686, 8, 1212, 'My teacher presents the lesson or instructional activity using concepts and language understandable ', 4),
(687, 8, 1212, 'My teacher provides relevant examples and demonstrations to illustrate concepts and skills', 4),
(688, 8, 1212, 'My teacher assigns tasks appropriate to student level', 5),
(689, 8, 1212, 'My teacher asks appropriate levels of questions', 2),
(690, 8, 1212, 'My teacher conducts lessons or instructional activities at an appropriate pace', 2),
(691, 8, 1212, 'My teacher makes assignments clear', 3),
(692, 8, 1212, 'My teacher summarizes the main point(s) at the end of the lesson or instructional activities', 5),
(693, 8, 1212, 'My teacher maintains clear, firm and reasonable work standards.', 2),
(694, 8, 1212, 'My teacher circulates during class to check all students’ performance', 1),
(695, 8, 1212, 'My teacher routinely uses oral, written or other work products to check student progress', 4),
(696, 8, 1212, 'My teacher develops an instructional plan based upon school and curricular goals', 2),
(697, 8, 1212, 'My teacher uses diagnostic information from tests and other assessment procedures to develop and rev', 3),
(698, 8, 1212, 'My teacher develops an instructional plan that matches/aligns objective, learning strategies, assess', 2);

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

--
-- Table structure for table `tblcoments`
--

CREATE TABLE `tblcoments` (
  `ID` int(11) NOT NULL,
  `TEACHERID` int(11) NOT NULL,
  `COMMENTS` varchar(500) NOT NULL,
  `DATE` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblcoments`
--

INSERT INTO `tblcoments` (`ID`, `TEACHERID`, `COMMENTS`, `DATE`) VALUES
(1, 7, 'ADSDFSSLFSDFFS.DFS.F,DSF', '2019-01-11'),
(2, 6, 'dssadsfdsfdf', '2019-01-11'),
(3, 7, 'She is a good teacher. dapat tularan', '2019-01-11'),
(4, 6, 'ASAsAS', '2019-01-13'),
(5, 6, 'WERWEREWRWER', '2019-01-13'),
(6, 6, 'WEFDSFSDFD', '2019-01-13'),
(7, 6, ',n n,mn,n ,', '2019-01-14'),
(8, 6, 'jnjbb', '2019-01-14'),
(9, 6, '', '2019-01-15'),
(10, 8, 'fdsfsfdsf', '2019-01-15');

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

--
-- Table structure for table `tblevaluate`
--

CREATE TABLE `tblevaluate` (
  `EVALUATEID` int(11) NOT NULL,
  `Question` varchar(50) NOT NULL,
  `RATE` int(11) NOT NULL,
  `COMMENTS` int(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tblquestion`
--

CREATE TABLE `tblquestion` (
  `QUESTID` int(11) NOT NULL,
  `QUESTION` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblquestion`
--

INSERT INTO `tblquestion` (`QUESTID`, `QUESTION`) VALUES
(1, 'My teacher demonstrates knowledge of content and related pedagogy'),
(2, 'My teacher demonstrates knowledge of how students learn'),
(3, 'My teacher demonstrates awareness of student skills and knowledge'),
(4, 'My teacher projects respect '),
(5, 'My teacher demonstrates positive attitude and openness to students'),
(6, 'My teacher demonstrates willingness to be flexible'),
(7, 'My teacher creates a stimulating and effective environment for learning'),
(8, 'My teacher establishes and maintains a disciplined environment'),
(9, 'My teacher effectively organizes the class'),
(10, 'My teacher has established procedures that govern student verbal participation during different types of activities – whole class instruction, small group instruction, etc.'),
(11, 'My teacher has established procedures that govern student movement in the classroom during different types of instructional activities'),
(12, 'My teacher stops inappropriate behavior promptly and consistently, yet maintains the dignity of the student'),
(13, 'My teacher\'s materials, supplies, and equipment are ready at the start of the lessons or instructional activity'),
(14, 'My teacher releases my grades on time'),
(15, 'My teacher observes promptness in reporting to class'),
(16, 'My teacher begins lesson or instructional activity with an appropriate review of the previous lesson'),
(17, 'My teacher speaks fluently and precisely'),
(18, 'My teacher presents the lesson or instructional activity using concepts and language understandable to students'),
(19, 'My teacher provides relevant examples and demonstrations to illustrate concepts and skills'),
(20, 'My teacher assigns tasks appropriate to student level'),
(21, 'My teacher asks appropriate levels of questions'),
(22, 'My teacher conducts lessons or instructional activities at an appropriate pace'),
(23, 'My teacher makes assignments clear'),
(24, 'My teacher summarizes the main point(s) at the end of the lesson or instructional activities'),
(25, 'My teacher maintains clear, firm and reasonable work standards.'),
(26, 'My teacher circulates during class to check all students’ performance'),
(27, 'My teacher routinely uses oral, written or other work products to check student progress'),
(28, 'My teacher develops an instructional plan based upon school and curricular goals'),
(29, 'My teacher uses diagnostic information from tests and other assessment procedures to develop and revise objectives and/or tasks'),
(30, 'My teacher develops an instructional plan that matches/aligns objective, learning strategies, assessment and my needs at the appropriate levels of difficulty');

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

--
-- Table structure for table `tblresult`
--

CREATE TABLE `tblresult` (
  `ID` int(11) NOT NULL,
  `TEACHERNAME` varchar(50) NOT NULL,
  `SUBJECT` varchar(50) NOT NULL,
  `SCHEDULE` varchar(50) NOT NULL,
  `ANSWER` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tblschedule`
--

CREATE TABLE `tblschedule` (
  `ID` int(11) NOT NULL,
  `SUBJECT` varchar(50) NOT NULL,
  `AY` varchar(50) NOT NULL,
  `SEMESTER` varchar(50) NOT NULL,
  `UNIT` varchar(50) NOT NULL,
  `SCHEDULE` varchar(50) NOT NULL,
  `TIME` varchar(50) NOT NULL,
  `TEACHERID` int(11) NOT NULL,
  `GRADE` int(11) NOT NULL,
  `SECTION` varchar(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblschedule`
--

INSERT INTO `tblschedule` (`ID`, `SUBJECT`, `AY`, `SEMESTER`, `UNIT`, `SCHEDULE`, `TIME`, `TEACHERID`, `GRADE`, `SECTION`) VALUES
(10, 'Filipino', '2018-2019', '1', '3', 'Monday', '7:30 - 8:30', 6, 12, 'Earth'),
(11, 'English', '2018-2019', '1', '2', 'Monday', '7:30 - 8:30', 8, 12, 'Earth');

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

--
-- Table structure for table `tblstudents`
--

CREATE TABLE `tblstudents` (
  `STUDENTID` int(11) NOT NULL,
  `STUDENT NAME` varchar(50) NOT NULL,
  `GRADE` varchar(50) NOT NULL,
  `SECTION` varchar(11) NOT NULL,
  `IDNO` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblstudents`
--

INSERT INTO `tblstudents` (`STUDENTID`, `STUDENT NAME`, `GRADE`, `SECTION`, `IDNO`) VALUES
(17, 'James Dizon', '12', 'Earth', 1234),
(18, 'Julia Diaz', '12', 'Saturn', 4321),
(19, 'John Doe', '12', 'Mercury', 5678),
(20, 'James doe', '12', 'Earth', 1212);

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

--
-- Table structure for table `tblteachers`
--

CREATE TABLE `tblteachers` (
  `TEACHERSID` int(11) NOT NULL,
  `IMPLOYEEID` int(11) NOT NULL,
  `TEACHERSNAME` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblteachers`
--

INSERT INTO `tblteachers` (`TEACHERSID`, `IMPLOYEEID`, `TEACHERSNAME`) VALUES
(6, 20005, 'Andrew Cababag Braza'),
(8, 20006, 'John Doe'),
(9, 20007, 'Ana Manalastas');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tblaccounts`
--
ALTER TABLE `tblaccounts`
  ADD PRIMARY KEY (`ACCOUNTSID`);

--
-- Indexes for table `tblanswer`
--
ALTER TABLE `tblanswer`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `tblcoments`
--
ALTER TABLE `tblcoments`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `tblevaluate`
--
ALTER TABLE `tblevaluate`
  ADD PRIMARY KEY (`EVALUATEID`);

--
-- Indexes for table `tblquestion`
--
ALTER TABLE `tblquestion`
  ADD PRIMARY KEY (`QUESTID`);

--
-- Indexes for table `tblresult`
--
ALTER TABLE `tblresult`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `tblschedule`
--
ALTER TABLE `tblschedule`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `tblstudents`
--
ALTER TABLE `tblstudents`
  ADD PRIMARY KEY (`STUDENTID`);

--
-- Indexes for table `tblteachers`
--
ALTER TABLE `tblteachers`
  ADD PRIMARY KEY (`TEACHERSID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tblaccounts`
--
ALTER TABLE `tblaccounts`
  MODIFY `ACCOUNTSID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tblanswer`
--
ALTER TABLE `tblanswer`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=699;

--
-- AUTO_INCREMENT for table `tblcoments`
--
ALTER TABLE `tblcoments`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `tblevaluate`
--
ALTER TABLE `tblevaluate`
  MODIFY `EVALUATEID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblquestion`
--
ALTER TABLE `tblquestion`
  MODIFY `QUESTID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `tblresult`
--
ALTER TABLE `tblresult`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblschedule`
--
ALTER TABLE `tblschedule`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `tblstudents`
--
ALTER TABLE `tblstudents`
  MODIFY `STUDENTID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `tblteachers`
--
ALTER TABLE `tblteachers`
  MODIFY `TEACHERSID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
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 */;
