# phpMyAdmin SQL Dump
# version 2.5.7
# http://www.phpmyadmin.net
#
# Host: var.fluid.cs.cmu.edu
# Generation Time: Jul 31, 2004 at 06:12 PM
# Server version: 4.0.20
# PHP Version: 4.3.3
# 
# Database : `carnegielearning`
# 

# --------------------------------------------------------

#
# Table structure for table `tblAction`
#

DROP TABLE IF EXISTS tblAction;
CREATE TABLE tblAction (
  ID int(11) NOT NULL auto_increment,
  questionStepID int(11) NOT NULL default '0',
  actionTypeID int(11) NOT NULL default '0',
  resultTypeID int(11) default NULL,
  actionTime datetime NOT NULL default '0000-00-00 00:00:00',
  theOrder int(11) NOT NULL default '0',
  actionText text NOT NULL,
  resultText text,
  info text,
  PRIMARY KEY  (ID),
  KEY questionStepID (questionStepID,actionTypeID,resultTypeID)
) TYPE=InnoDB PACK_KEYS=0 AUTO_INCREMENT=12323 ;

# --------------------------------------------------------

#
# Table structure for table `tblActionType`
#

DROP TABLE IF EXISTS tblActionType;
CREATE TABLE tblActionType (
  ID int(11) NOT NULL auto_increment,
  name text NOT NULL,
  PRIMARY KEY  (ID)
) TYPE=InnoDB AUTO_INCREMENT=3 ;

# --------------------------------------------------------

#
# Table structure for table `tblAssistment`
#

DROP TABLE IF EXISTS tblAssistment;
CREATE TABLE tblAssistment (
  ID int(11) NOT NULL auto_increment,
  sourceID int(11) NOT NULL default '0',
  pedagogicalStrategyID int(11) default NULL,
  name text NOT NULL,
  className text NOT NULL,
  dfa text,
  decomposed text,
  partOf text,
  morph text,
  brdFilename text NOT NULL,
  image varchar(20) default NULL,
  PRIMARY KEY  (ID),
  KEY sourceID (sourceID),
  KEY pedagogicalStrategyID (pedagogicalStrategyID)
  CONSTRAINT `0_718` FOREIGN KEY (`sourceID`) REFERENCES `tblSource` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB AUTO_INCREMENT=48 ;

# --------------------------------------------------------

#
# Table structure for table `tblAssistmentFactorMap`
#

DROP TABLE IF EXISTS tblAssistmentFactorMap;
CREATE TABLE tblAssistmentFactorMap (
  ID int(11) NOT NULL auto_increment,
  assistmentID int(11) NOT NULL default '0',
  factorID int(11) NOT NULL default '0',
  value text NOT NULL,
  question text NOT NULL,
  PRIMARY KEY  (ID),
  KEY factorID (factorID),
  KEY assistmentID (assistmentID)
  CONSTRAINT `0_752` FOREIGN KEY (`assistmentID`) REFERENCES `tblAssistment` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `tblAssistmentKnowledgeComponentMap`
#

DROP TABLE IF EXISTS tblAssistmentKnowledgeComponentMap;
CREATE TABLE tblAssistmentKnowledgeComponentMap (
  ID int(11) NOT NULL auto_increment,
  assistmentID int(11) NOT NULL default '0',
  knowledgeComponentID int(11) NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY assistmentID (assistmentID),
  KEY knowledgeComponentID (knowledgeComponentID)
  CONSTRAINT `0_755` FOREIGN KEY (`assistmentID`) REFERENCES `tblAssistment` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB AUTO_INCREMENT=117 ;

# --------------------------------------------------------

#
# Table structure for table `tblAssistmentStandardMap`
#

DROP TABLE IF EXISTS tblAssistmentStandardMap;
CREATE TABLE tblAssistmentStandardMap (
  ID int(11) NOT NULL auto_increment,
  assistmentID int(11) NOT NULL default '0',
  standardID int(11) NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY assistmentID (assistmentID),
  KEY standardID (standardID)
  CONSTRAINT `0_758` FOREIGN KEY (`assistmentID`) REFERENCES `tblAssistment` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB PACK_KEYS=0 AUTO_INCREMENT=46 ;

# --------------------------------------------------------

#
# Table structure for table `tblAssistmentTestItemMap`
#

DROP TABLE IF EXISTS tblAssistmentTestItemMap;
CREATE TABLE tblAssistmentTestItemMap (
  ID int(11) NOT NULL auto_increment,
  assistmentID int(11) NOT NULL default '0',
  testItemID int(11) NOT NULL default '0',
  isSimilar tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY assistmentID (assistmentID),
  KEY testItemID (testItemID)
  CONSTRAINT `0_761` FOREIGN KEY (`assistmentID`) REFERENCES `tblAssistment` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `tblAttempt`
#

DROP TABLE IF EXISTS tblAttempt;
CREATE TABLE tblAttempt (
  ID int(11) NOT NULL auto_increment,
  questionStepID int(11) NOT NULL default '0',
  resultTypeID int(11) NOT NULL default '0',
  theOrder text NOT NULL,
  attemptText text NOT NULL,
  resultText text NOT NULL,
  info text NOT NULL,
  isFirstAttempt tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY questionStepID (questionStepID),
  KEY resultTypeID (resultTypeID)
  CONSTRAINT `0_764` FOREIGN KEY (`resultTypeID`) REFERENCES `tblResultType` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `tblClass`
#

DROP TABLE IF EXISTS tblClass;
CREATE TABLE tblClass (
  ID int(11) NOT NULL auto_increment,
  name text NOT NULL,
  teacherID int(11) NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY teacherID (teacherID)
) TYPE=InnoDB AUTO_INCREMENT=31 ;

# --------------------------------------------------------

#
# Table structure for table `tblClassCurriculumMap`
#

DROP TABLE IF EXISTS tblClassCurriculumMap;
CREATE TABLE tblClassCurriculumMap (
  ID int(11) NOT NULL auto_increment,
  classID int(11) NOT NULL default '0',
  curriculumID int(11) NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY classID (classID),
  KEY curriculumID (curriculumID)
  CONSTRAINT `0_733` FOREIGN KEY (`classID`) REFERENCES `tblClass` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `tblCurriculum`
#

DROP TABLE IF EXISTS tblCurriculum;
CREATE TABLE tblCurriculum (
  ID int(11) NOT NULL auto_increment,
  name text NOT NULL,
  PRIMARY KEY  (ID)
) TYPE=InnoDB AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `tblCurriculumAssistmentMap`
#

DROP TABLE IF EXISTS tblCurriculumAssistmentMap;
CREATE TABLE tblCurriculumAssistmentMap (
  ID int(11) NOT NULL auto_increment,
  curriculumID int(11) NOT NULL default '0',
  assistmentID int(11) NOT NULL default '0',
  theOrder text NOT NULL,
  PRIMARY KEY  (ID),
  KEY curriculumID (curriculumID),
  KEY assistmentID (assistmentID)
  CONSTRAINT `0_767` FOREIGN KEY (`assistmentID`) REFERENCES `tblAssistment` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `tblFactor`
#

DROP TABLE IF EXISTS tblFactor;
CREATE TABLE tblFactor (
  ID int(11) NOT NULL auto_increment,
  name text NOT NULL,
  description text NOT NULL,
  factorType text NOT NULL,
  PRIMARY KEY  (ID)
) TYPE=InnoDB AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `tblFactorPrerequisite`
#

DROP TABLE IF EXISTS tblFactorPrerequisite;
CREATE TABLE tblFactorPrerequisite (
  ID int(11) NOT NULL auto_increment,
  requiredFactorID int(11) NOT NULL default '0',
  resultingFactorID int(11) NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY resultingFactorID (resultingFactorID),
  KEY requiredFactorID (requiredFactorID)
  CONSTRAINT `0_770` FOREIGN KEY (`requiredFactorID`) REFERENCES `tblFactor` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `tblGroup`
#

DROP TABLE IF EXISTS tblGroup;
CREATE TABLE tblGroup (
  ID int(11) NOT NULL auto_increment,
  teacherID int(11) NOT NULL default '0',
  name text NOT NULL,
  description text NOT NULL,
  PRIMARY KEY  (ID),
  KEY teacherID (teacherID)
) TYPE=InnoDB AUTO_INCREMENT=5 ;

# --------------------------------------------------------

#
# Table structure for table `tblHintRequest`
#

DROP TABLE IF EXISTS tblHintRequest;
CREATE TABLE tblHintRequest (
  ID int(11) NOT NULL auto_increment,
  questionStepID int(11) NOT NULL default '0',
  requestTime text NOT NULL,
  level text NOT NULL,
  hintText text NOT NULL,
  PRIMARY KEY  (ID),
  KEY questionStepID (questionStepID)
) TYPE=InnoDB AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `tblKnowledgeComponent`
#

DROP TABLE IF EXISTS tblKnowledgeComponent;
CREATE TABLE tblKnowledgeComponent (
  ID int(11) NOT NULL auto_increment,
  name text NOT NULL,
  description text,
  example text,
  timetoteach text,
  transferModelID int(11) NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY transferModelID (transferModelID)
) TYPE=InnoDB AUTO_INCREMENT=247 ;

# --------------------------------------------------------

#
# Table structure for table `tblKnowledgeComponentPrerequisite`
#

DROP TABLE IF EXISTS tblKnowledgeComponentPrerequisite;
CREATE TABLE tblKnowledgeComponentPrerequisite (
  ID int(11) NOT NULL auto_increment,
  requiredKnowledgeComponentID int(11) NOT NULL default '0',
  resultingKnowledgeComponentID int(11) NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY resultingKnowledgeComponentID (resultingKnowledgeComponentID),
  KEY requiredKnowledgeComponentID (requiredKnowledgeComponentID)
  CONSTRAINT `0_775` FOREIGN KEY (`requiredKnowledgeComponentID`) REFERENCES `tblKnowledgeComponent` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `tblKnowledgeComponentRemedyMap`
#

DROP TABLE IF EXISTS tblKnowledgeComponentRemedyMap;
CREATE TABLE tblKnowledgeComponentRemedyMap (
  ID int(11) NOT NULL auto_increment,
  knowledgeComponentID int(11) NOT NULL default '0',
  remedyID int(11) NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY knowledgeComponentID (knowledgeComponentID),
  KEY remedyID (remedyID)
  CONSTRAINT `0_778` FOREIGN KEY (`remedyID`) REFERENCES `tblRemedy` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `tblLogParam`
#

DROP TABLE IF EXISTS tblLogParam;
CREATE TABLE tblLogParam (
  ID int(11) NOT NULL auto_increment,
  actionID int(11) NOT NULL default '0',
  paramName text NOT NULL,
  paramValue text NOT NULL,
  PRIMARY KEY  (ID),
  KEY actionID (actionID)
) TYPE=InnoDB AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `tblPedagogicalStrategy`
#

DROP TABLE IF EXISTS tblPedagogicalStrategy;
CREATE TABLE tblPedagogicalStrategy (
  ID int(11) NOT NULL auto_increment,
  name text NOT NULL,
  description text NOT NULL,
  PRIMARY KEY  (ID)
) TYPE=InnoDB AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `tblPerformance`
#

DROP TABLE IF EXISTS tblPerformance;
CREATE TABLE tblPerformance (
  ID int(11) NOT NULL default '0',
  studentID int(11) NOT NULL default '0',
  questionID int(11) NOT NULL default '0',
  passed tinyint(4) NOT NULL default '0',
  encountered tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY studentID (studentID,questionID)
) TYPE=InnoDB;

# --------------------------------------------------------

#
# Table structure for table `tblPostTestResult`
#

DROP TABLE IF EXISTS tblPostTestResult;
CREATE TABLE tblPostTestResult (
  ID int(11) NOT NULL auto_increment,
  studentID int(11) NOT NULL default '0',
  testFormID int(11) NOT NULL default '0',
  testDate text NOT NULL,
  PRIMARY KEY  (ID),
  KEY studentID (studentID),
  KEY testFormID (testFormID)
  CONSTRAINT `0_783` FOREIGN KEY (`studentID`) REFERENCES `tblStudent` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `tblPostTestScore`
#

DROP TABLE IF EXISTS tblPostTestScore;
CREATE TABLE tblPostTestScore (
  ID int(11) NOT NULL default '0',
  postTestResultID int(11) NOT NULL default '0',
  testItemID int(11) NOT NULL default '0',
  answer text NOT NULL,
  isCorrect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY postTestResultID (postTestResultID),
  KEY testItemID (testItemID)
  CONSTRAINT `0_786` FOREIGN KEY (`postTestResultID`) REFERENCES `tblPostTestResult` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB;

# --------------------------------------------------------

#
# Table structure for table `tblPreTestResult`
#

DROP TABLE IF EXISTS tblPreTestResult;
CREATE TABLE tblPreTestResult (
  ID int(11) NOT NULL default '0',
  studentID int(11) NOT NULL default '0',
  testFormID int(11) NOT NULL default '0',
  testDate text NOT NULL,
  PRIMARY KEY  (ID),
  KEY studentID (studentID),
  KEY testFormID (testFormID)
  CONSTRAINT `0_789` FOREIGN KEY (`studentID`) REFERENCES `tblStudent` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB;

# --------------------------------------------------------

#
# Table structure for table `tblPreTestScore`
#

DROP TABLE IF EXISTS tblPreTestScore;
CREATE TABLE tblPreTestScore (
  ID int(11) NOT NULL auto_increment,
  preTestResultID int(11) NOT NULL default '0',
  testItemID int(11) NOT NULL default '0',
  answer text NOT NULL,
  isCorrect tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY postTestResultID (preTestResultID),
  KEY testItemID (testItemID)
  CONSTRAINT `0_792` FOREIGN KEY (`preTestResultID`) REFERENCES `tblPreTestResult` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `tblQuestionStep`
#

DROP TABLE IF EXISTS tblQuestionStep;
CREATE TABLE tblQuestionStep (
  ID int(11) NOT NULL auto_increment,
  sessionID int(11) NOT NULL default '0',
  scaffoldID int(11) NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY sessionID (sessionID),
  KEY scaffoldID (scaffoldID)
  CONSTRAINT `0_747` FOREIGN KEY (`sessionID`) REFERENCES `tblSession` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB AUTO_INCREMENT=5221 ;

# --------------------------------------------------------

#
# Table structure for table `tblRemedy`
#

DROP TABLE IF EXISTS tblRemedy;
CREATE TABLE tblRemedy (
  ID int(11) NOT NULL auto_increment,
  description text NOT NULL,
  PRIMARY KEY  (ID)
) TYPE=InnoDB AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `tblReportingCategory`
#

DROP TABLE IF EXISTS tblReportingCategory;
CREATE TABLE tblReportingCategory (
  ID int(11) NOT NULL auto_increment,
  standardorgID int(11) NOT NULL default '0',
  description text NOT NULL,
  PRIMARY KEY  (ID),
  KEY standardorgID (standardorgID)
) TYPE=InnoDB AUTO_INCREMENT=6 ;

# --------------------------------------------------------

#
# Table structure for table `tblResultType`
#

DROP TABLE IF EXISTS tblResultType;
CREATE TABLE tblResultType (
  ID int(11) NOT NULL auto_increment,
  name text NOT NULL,
  PRIMARY KEY  (ID)
) TYPE=InnoDB AUTO_INCREMENT=6 ;

# --------------------------------------------------------

#
# Table structure for table `tblScaffold`
#

DROP TABLE IF EXISTS tblScaffold;
CREATE TABLE tblScaffold (
  ID int(11) NOT NULL auto_increment,
  assistmentID int(11) NOT NULL default '0',
  theOrder text NOT NULL,
  widgetName text NOT NULL,
  questionText text NOT NULL,
  answer text NOT NULL,
  isOriginalQuestion tinyint(1) NOT NULL default '0',
  image varchar(20) default NULL,
  PRIMARY KEY  (ID),
  KEY assistmentID (assistmentID)
) TYPE=InnoDB PACK_KEYS=0 AUTO_INCREMENT=237 ;

# --------------------------------------------------------

#
# Table structure for table `tblScaffoldKnowledgeComponentMap`
#

DROP TABLE IF EXISTS tblScaffoldKnowledgeComponentMap;
CREATE TABLE tblScaffoldKnowledgeComponentMap (
  ID int(11) NOT NULL auto_increment,
  scaffoldID int(11) NOT NULL default '0',
  knowledgeComponentID int(11) NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY scaffoldID (scaffoldID),
  KEY knowledgeComponentID (knowledgeComponentID)
  CONSTRAINT `0_795` FOREIGN KEY (`scaffoldID`) REFERENCES `tblScaffold` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB PACK_KEYS=0 AUTO_INCREMENT=260 ;

# --------------------------------------------------------

#
# Table structure for table `tblSchool`
#

DROP TABLE IF EXISTS tblSchool;
CREATE TABLE tblSchool (
  ID int(11) NOT NULL auto_increment,
  name text NOT NULL,
  state text NOT NULL,
  city text NOT NULL,
  PRIMARY KEY  (ID)
) TYPE=InnoDB AUTO_INCREMENT=103002 ;

# --------------------------------------------------------

#
# Table structure for table `tblSession`
#

DROP TABLE IF EXISTS tblSession;
CREATE TABLE tblSession (
  ID int(11) NOT NULL auto_increment,
  studentID int(11) NOT NULL default '0',
  ieSessionName text NOT NULL,
  startTime datetime NOT NULL default '0000-00-00 00:00:00',
  endTime datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (ID),
  KEY studentID (studentID)
) TYPE=InnoDB AUTO_INCREMENT=263 ;

# --------------------------------------------------------

#
# Table structure for table `tblSource`
#

DROP TABLE IF EXISTS tblSource;
CREATE TABLE tblSource (
  ID int(11) NOT NULL auto_increment,
  year text NOT NULL,
  name text NOT NULL,
  description text NOT NULL,
  image varchar(30) default NULL,
  PRIMARY KEY  (ID)
) TYPE=InnoDB AUTO_INCREMENT=39 ;

# --------------------------------------------------------

#
# Table structure for table `tblSourceKnowledgeComponentMap`
#

DROP TABLE IF EXISTS tblSourceKnowledgeComponentMap;
CREATE TABLE tblSourceKnowledgeComponentMap (
  ID int(11) NOT NULL auto_increment,
  sourceID int(11) NOT NULL default '0',
  knowledgeComponentID int(11) NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY sourceID (sourceID),
  KEY knowledgeComponentID (knowledgeComponentID)
  CONSTRAINT `0_798` FOREIGN KEY (`sourceID`) REFERENCES `tblSource` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `tblStandard`
#

DROP TABLE IF EXISTS tblStandard;
CREATE TABLE tblStandard (
  ID int(11) NOT NULL auto_increment,
  name text NOT NULL,
  reportingcategoryID int(11) NOT NULL default '0',
  description text NOT NULL,
  codedName varchar(9) default NULL,
  difficulty smallint(6) NOT NULL default '0',
  PRIMARY KEY  (ID),
  UNIQUE KEY codedName (codedName),
  KEY reportingcategoryID (reportingcategoryID)
) TYPE=InnoDB AUTO_INCREMENT=40 ;

# --------------------------------------------------------

#
# Table structure for table `tblStandardOrg`
#

DROP TABLE IF EXISTS tblStandardOrg;
CREATE TABLE tblStandardOrg (
  ID int(11) NOT NULL auto_increment,
  name text NOT NULL,
  standardyear text NOT NULL,
  PRIMARY KEY  (ID)
) TYPE=InnoDB AUTO_INCREMENT=2 ;

# --------------------------------------------------------

#
# Table structure for table `tblStudent`
#

DROP TABLE IF EXISTS tblStudent;
CREATE TABLE tblStudent (
  ID int(11) NOT NULL auto_increment,
  classID int(11) NOT NULL default '0',
  name text NOT NULL,
  username text NOT NULL,
  password text NOT NULL,
  curriculumID int(11) NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY classID (classID),
  KEY curriculumID (curriculumID)
  CONSTRAINT `0_736` FOREIGN KEY (`classID`) REFERENCES `tblClass` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB AUTO_INCREMENT=275 ;

# --------------------------------------------------------

#
# Table structure for table `tblStudentCurriculumDoneMap`
#

DROP TABLE IF EXISTS tblStudentCurriculumDoneMap;
CREATE TABLE tblStudentCurriculumDoneMap (
  ID int(11) NOT NULL auto_increment,
  studentID int(11) NOT NULL default '0',
  curriculumID int(11) NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY studentID (studentID),
  KEY curriculumID (curriculumID)
  CONSTRAINT `0_739` FOREIGN KEY (`curriculumID`) REFERENCES `tblCurriculum` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `tblStudentGroupMap`
#

DROP TABLE IF EXISTS tblStudentGroupMap;
CREATE TABLE tblStudentGroupMap (
  ID int(11) NOT NULL auto_increment,
  studentID int(11) NOT NULL default '0',
  groupID int(11) NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY studentID (studentID),
  KEY groupID (groupID)
  CONSTRAINT `0_742` FOREIGN KEY (`groupID`) REFERENCES `tblGroup` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB PACK_KEYS=0 AUTO_INCREMENT=51 ;

# --------------------------------------------------------

#
# Table structure for table `tblTeacher`
#

DROP TABLE IF EXISTS tblTeacher;
CREATE TABLE tblTeacher (
  ID int(11) NOT NULL auto_increment,
  name text NOT NULL,
  username text NOT NULL,
  password text NOT NULL,
  schoolID int(11) NOT NULL default '0',
  visitTimes text NOT NULL,
  PRIMARY KEY  (ID),
  KEY schoolID (schoolID)
) TYPE=InnoDB AUTO_INCREMENT=10 ;

# --------------------------------------------------------

#
# Table structure for table `tblTestForm`
#

DROP TABLE IF EXISTS tblTestForm;
CREATE TABLE tblTestForm (
  ID int(11) NOT NULL auto_increment,
  name text NOT NULL,
  PRIMARY KEY  (ID)
) TYPE=InnoDB AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `tblTestItem`
#

DROP TABLE IF EXISTS tblTestItem;
CREATE TABLE tblTestItem (
  ID int(11) NOT NULL auto_increment,
  testformID int(11) NOT NULL default '0',
  problemNo text NOT NULL,
  answer text NOT NULL,
  PRIMARY KEY  (ID),
  KEY testformID (testformID)
) TYPE=InnoDB AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `tblTransferModel`
#

DROP TABLE IF EXISTS tblTransferModel;
CREATE TABLE tblTransferModel (
  ID int(11) NOT NULL auto_increment,
  name text NOT NULL,
  description text NOT NULL,
  PRIMARY KEY  (ID)
) TYPE=InnoDB AUTO_INCREMENT=3 ;

#
# Constraints for dumped tables
#

#
# Constraints for table `tblAssistment`
#
ALTER TABLE `tblAssistment`

  ADD CONSTRAINT `0_717` FOREIGN KEY (`pedagogicalStrategyID`) REFERENCES `tblPedagogicalStrategy` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,;

#
# Constraints for table `tblAssistmentFactorMap`
#
ALTER TABLE `tblAssistmentFactorMap`

  ADD CONSTRAINT `0_751` FOREIGN KEY (`factorID`) REFERENCES `tblFactor` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,;

#
# Constraints for table `tblAssistmentKnowledgeComponentMap`
#
ALTER TABLE `tblAssistmentKnowledgeComponentMap`

  ADD CONSTRAINT `0_754` FOREIGN KEY (`knowledgeComponentID`) REFERENCES `tblKnowledgeComponent` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,;

#
# Constraints for table `tblAssistmentStandardMap`
#
ALTER TABLE `tblAssistmentStandardMap`

  ADD CONSTRAINT `0_757` FOREIGN KEY (`standardID`) REFERENCES `tblStandard` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,;

#
# Constraints for table `tblAssistmentTestItemMap`
#
ALTER TABLE `tblAssistmentTestItemMap`

  ADD CONSTRAINT `0_760` FOREIGN KEY (`testItemID`) REFERENCES `tblTestItem` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,;

#
# Constraints for table `tblAttempt`
#
ALTER TABLE `tblAttempt`

  ADD CONSTRAINT `0_763` FOREIGN KEY (`questionStepID`) REFERENCES `tblQuestionStep` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,;

#
# Constraints for table `tblClass`
#
ALTER TABLE `tblClass`

  ADD CONSTRAINT `0_728` FOREIGN KEY (`teacherID`) REFERENCES `tblTeacher` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;

#
# Constraints for table `tblClassCurriculumMap`
#
ALTER TABLE `tblClassCurriculumMap`

  ADD CONSTRAINT `0_732` FOREIGN KEY (`curriculumID`) REFERENCES `tblCurriculum` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,;

#
# Constraints for table `tblCurriculumAssistmentMap`
#
ALTER TABLE `tblCurriculumAssistmentMap`

  ADD CONSTRAINT `0_766` FOREIGN KEY (`curriculumID`) REFERENCES `tblCurriculum` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,;

#
# Constraints for table `tblFactorPrerequisite`
#
ALTER TABLE `tblFactorPrerequisite`

  ADD CONSTRAINT `0_769` FOREIGN KEY (`resultingFactorID`) REFERENCES `tblFactor` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,;

#
# Constraints for table `tblGroup`
#
ALTER TABLE `tblGroup`

  ADD CONSTRAINT `0_730` FOREIGN KEY (`teacherID`) REFERENCES `tblTeacher` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;

#
# Constraints for table `tblHintRequest`
#
ALTER TABLE `tblHintRequest`

  ADD CONSTRAINT `0_772` FOREIGN KEY (`questionStepID`) REFERENCES `tblQuestionStep` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;

#
# Constraints for table `tblKnowledgeComponent`
#
ALTER TABLE `tblKnowledgeComponent`

  ADD CONSTRAINT `0_749` FOREIGN KEY (`transferModelID`) REFERENCES `tblTransferModel` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;

#
# Constraints for table `tblKnowledgeComponentPrerequisite`
#
ALTER TABLE `tblKnowledgeComponentPrerequisite`

  ADD CONSTRAINT `0_774` FOREIGN KEY (`resultingKnowledgeComponentID`) REFERENCES `tblKnowledgeComponent` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,;

#
# Constraints for table `tblKnowledgeComponentRemedyMap`
#
ALTER TABLE `tblKnowledgeComponentRemedyMap`

  ADD CONSTRAINT `0_777` FOREIGN KEY (`knowledgeComponentID`) REFERENCES `tblKnowledgeComponent` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,;

#
# Constraints for table `tblPostTestResult`
#
ALTER TABLE `tblPostTestResult`

  ADD CONSTRAINT `0_782` FOREIGN KEY (`testFormID`) REFERENCES `tblTestForm` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,;

#
# Constraints for table `tblPostTestScore`
#
ALTER TABLE `tblPostTestScore`

  ADD CONSTRAINT `0_785` FOREIGN KEY (`testItemID`) REFERENCES `tblTestItem` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,;

#
# Constraints for table `tblPreTestResult`
#
ALTER TABLE `tblPreTestResult`

  ADD CONSTRAINT `0_788` FOREIGN KEY (`testFormID`) REFERENCES `tblTestForm` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,;

#
# Constraints for table `tblPreTestScore`
#
ALTER TABLE `tblPreTestScore`

  ADD CONSTRAINT `0_791` FOREIGN KEY (`testItemID`) REFERENCES `tblTestItem` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,;

#
# Constraints for table `tblQuestionStep`
#
ALTER TABLE `tblQuestionStep`

  ADD CONSTRAINT `0_746` FOREIGN KEY (`scaffoldID`) REFERENCES `tblScaffold` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,;

#
# Constraints for table `tblReportingCategory`
#
ALTER TABLE `tblReportingCategory`

  ADD CONSTRAINT `0_722` FOREIGN KEY (`standardorgID`) REFERENCES `tblStandardOrg` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;

#
# Constraints for table `tblScaffold`
#
ALTER TABLE `tblScaffold`

  ADD CONSTRAINT `0_720` FOREIGN KEY (`assistmentID`) REFERENCES `tblAssistment` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;

#
# Constraints for table `tblScaffoldKnowledgeComponentMap`
#
ALTER TABLE `tblScaffoldKnowledgeComponentMap`

  ADD CONSTRAINT `0_794` FOREIGN KEY (`knowledgeComponentID`) REFERENCES `tblKnowledgeComponent` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,;

#
# Constraints for table `tblSession`
#
ALTER TABLE `tblSession`

  ADD CONSTRAINT `0_744` FOREIGN KEY (`studentID`) REFERENCES `tblStudent` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;

#
# Constraints for table `tblSourceKnowledgeComponentMap`
#
ALTER TABLE `tblSourceKnowledgeComponentMap`

  ADD CONSTRAINT `0_797` FOREIGN KEY (`knowledgeComponentID`) REFERENCES `tblKnowledgeComponent` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,;

#
# Constraints for table `tblStandard`
#
ALTER TABLE `tblStandard`

  ADD CONSTRAINT `0_724` FOREIGN KEY (`reportingcategoryID`) REFERENCES `tblReportingCategory` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;

#
# Constraints for table `tblStudent`
#
ALTER TABLE `tblStudent`

  ADD CONSTRAINT `0_735` FOREIGN KEY (`curriculumID`) REFERENCES `tblCurriculum` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,;

#
# Constraints for table `tblStudentCurriculumDoneMap`
#
ALTER TABLE `tblStudentCurriculumDoneMap`

  ADD CONSTRAINT `0_738` FOREIGN KEY (`studentID`) REFERENCES `tblStudent` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,;

#
# Constraints for table `tblStudentGroupMap`
#
ALTER TABLE `tblStudentGroupMap`

  ADD CONSTRAINT `0_741` FOREIGN KEY (`studentID`) REFERENCES `tblStudent` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,;

#
# Constraints for table `tblTeacher`
#
ALTER TABLE `tblTeacher`

  ADD CONSTRAINT `0_726` FOREIGN KEY (`schoolID`) REFERENCES `tblSchool` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;

#
# Constraints for table `tblTestItem`
#
ALTER TABLE `tblTestItem`

  ADD CONSTRAINT `0_715` FOREIGN KEY (`testformID`) REFERENCES `tblTestForm` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;