| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/download/db/_Archive/ |
Upload File : |
-- MySQL Administrator dump 1.4 -- -- ------------------------------------------------------ -- Server version 4.1.14-nt /*!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 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -- -- Create schema cst -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ cst; USE cst; -- -- Table structure for table `cst`.`class` -- DROP TABLE IF EXISTS `class`; CREATE TABLE `class` ( `classId` int(10) unsigned NOT NULL auto_increment, `sessionId` int(10) unsigned NOT NULL default '0', `disciplineId` int(10) unsigned NOT NULL default '0', `classTitle` varchar(255) default NULL, `classCredits` float(3,2) default NULL, `classDescription` blob, `classInactive` tinyint(1) NOT NULL default '0', `classInactiveDate` datetime default NULL, `classInactiveComment` blob, `LastModified` datetime default NULL, `ModifiedBy` int(10) unsigned default NULL, PRIMARY KEY (`classId`), KEY `ModifiedBy` (`ModifiedBy`), KEY `disciplineId` (`disciplineId`), KEY `sessionId` (`sessionId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `cst`.`class` -- /*!40000 ALTER TABLE `class` DISABLE KEYS */; INSERT INTO `class` (`classId`,`sessionId`,`disciplineId`,`classTitle`,`classCredits`,`classDescription`,`classInactive`,`classInactiveDate`,`classInactiveComment`,`LastModified`,`ModifiedBy`) VALUES (1,1,4,'Test class 1',0.25,0x546869732069732066696C6C6572207465787420746F20726570726573656E74206120636C617373206465736372697074696F6E2E20546869732069732066696C6C6572207465787420746F20726570726573656E74206120636C617373206465736372697074696F6E2E20546869732069732066696C6C6572207465787420746F20726570726573656E74206120636C617373206465736372697074696F6E2E20546869732069732066696C6C6572207465787420746F20726570726573656E74206120636C617373206465736372697074696F6E2E20546869732069732066696C6C6572207465787420746F20726570726573656E74206120636C617373206465736372697074696F6E2E20546869732069732066696C6C6572207465787420746F20726570726573656E74206120636C617373206465736372697074696F6E2E20546869732069732066696C6C6572207465787420746F20726570726573656E74206120636C617373206465736372697074696F6E2E20546869732069732066696C6C6572207465787420746F20726570726573656E74206120636C617373206465736372697074696F6E2E20546869732069732066696C6C6572207465787420746F20726570726573656E74206120636C617373206465736372697074696F6E2E20546869732069732066696C6C6572207465787420746F20726570726573656E74206120636C617373206465736372697074696F6E2E,0,NULL,NULL,NULL,NULL), (2,1,3,'Test class 2',0.25,0x54686973206973206D6F72652066696C6C6572207465787420746F20726570726573656E74206120636C617373206465736372697074696F6E2E2054686973206973206D6F72652066696C6C6572207465787420746F20726570726573656E74206120636C617373206465736372697074696F6E2E2054686973206973206D6F72652066696C6C6572207465787420746F20726570726573656E74206120636C617373206465736372697074696F6E2E2054686973206973206D6F72652066696C6C6572207465787420746F20726570726573656E74206120636C617373206465736372697074696F6E2E2054686973206973206D6F72652066696C6C6572207465787420746F20726570726573656E74206120636C617373206465736372697074696F6E2E,0,NULL,NULL,NULL,NULL); INSERT INTO `class` (`classId`,`sessionId`,`disciplineId`,`classTitle`,`classCredits`,`classDescription`,`classInactive`,`classInactiveDate`,`classInactiveComment`,`LastModified`,`ModifiedBy`) VALUES (3,1,2,'Test class 3',0.50,0x54686973206973207374696C6C206D6F72652066696C6C6572207465787420746F20726570726573656E74206120636C617373206465736372697074696F6E2E2054686973206973207374696C6C206D6F72652066696C6C6572207465787420746F20726570726573656E74206120636C617373206465736372697074696F6E2E2054686973206973207374696C6C206D6F72652066696C6C6572207465787420746F20726570726573656E74206120636C617373206465736372697074696F6E2E,0,NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `class` ENABLE KEYS */; -- -- Table structure for table `cst`.`class_faculty` -- DROP TABLE IF EXISTS `class_faculty`; CREATE TABLE `class_faculty` ( `classId` int(10) unsigned NOT NULL auto_increment, `userId` int(10) unsigned NOT NULL default '0', `class_facultyIsPrimary` tinyint(1) default '0', `LastModified` datetime default NULL, `ModifiedBy` int(10) unsigned default NULL, PRIMARY KEY (`classId`,`userId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `cst`.`class_faculty` -- /*!40000 ALTER TABLE `class_faculty` DISABLE KEYS */; INSERT INTO `class_faculty` (`classId`,`userId`,`class_facultyIsPrimary`,`LastModified`,`ModifiedBy`) VALUES (1,1,0,NULL,NULL), (1,2,0,NULL,NULL), (1,8,0,NULL,NULL), (2,1,0,NULL,NULL), (2,2,0,NULL,NULL); /*!40000 ALTER TABLE `class_faculty` ENABLE KEYS */; -- -- Table structure for table `cst`.`class_student` -- DROP TABLE IF EXISTS `class_student`; CREATE TABLE `class_student` ( `classId` int(10) unsigned NOT NULL auto_increment, `userId` int(10) unsigned NOT NULL default '0' COMMENT 'Student''s userId', `class_studentInactive` tinyint(1) default '0', `class_studentInactiveDate` datetime default NULL, `class_studentInactiveComment` blob, `LastModified` datetime default NULL, `ModifiedBy` int(10) unsigned default NULL, PRIMARY KEY (`classId`,`userId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `cst`.`class_student` -- /*!40000 ALTER TABLE `class_student` DISABLE KEYS */; INSERT INTO `class_student` (`classId`,`userId`,`class_studentInactive`,`class_studentInactiveDate`,`class_studentInactiveComment`,`LastModified`,`ModifiedBy`) VALUES (1,1,0,NULL,NULL,NULL,NULL), (1,2,0,NULL,NULL,NULL,NULL), (1,8,0,NULL,NULL,NULL,NULL), (2,1,0,NULL,NULL,NULL,NULL), (2,2,0,NULL,NULL,NULL,NULL), (3,2,0,NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `class_student` ENABLE KEYS */; -- -- Table structure for table `cst`.`classgrade` -- DROP TABLE IF EXISTS `classgrade`; CREATE TABLE `classgrade` ( `classId` int(10) unsigned NOT NULL default '0', `userId` int(10) unsigned NOT NULL default '0', `classgradegrade` float default NULL, `classgradecomment` varchar(255) NOT NULL default '', `classgradeInactive` tinyint(1) NOT NULL default '0', `LastModified` datetime default NULL, `ModifiedBy` int(10) unsigned default NULL, PRIMARY KEY (`classId`,`userId`), KEY `ModifiedBy` (`ModifiedBy`), KEY `classId` (`classId`), KEY `userId` (`userId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `cst`.`classgrade` -- /*!40000 ALTER TABLE `classgrade` DISABLE KEYS */; /*!40000 ALTER TABLE `classgrade` ENABLE KEYS */; -- -- Table structure for table `cst`.`classtype` -- DROP TABLE IF EXISTS `classtype`; CREATE TABLE `classtype` ( `classtypeID` int(10) unsigned NOT NULL auto_increment, `classtypeName` varchar(10) NOT NULL default '', `classtypeInactive` tinyint(1) NOT NULL default '0', `LastModified` datetime default NULL, `ModifiedBy` int(10) unsigned default NULL, PRIMARY KEY (`classtypeID`), KEY `ModifiedBy` (`ModifiedBy`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `cst`.`classtype` -- /*!40000 ALTER TABLE `classtype` DISABLE KEYS */; INSERT INTO `classtype` (`classtypeID`,`classtypeName`,`classtypeInactive`,`LastModified`,`ModifiedBy`) VALUES (1,'Standard',0,NULL,1), (2,'Project',0,NULL,1); /*!40000 ALTER TABLE `classtype` ENABLE KEYS */; -- -- Table structure for table `cst`.`discipline` -- DROP TABLE IF EXISTS `discipline`; CREATE TABLE `discipline` ( `disciplineId` int(10) unsigned NOT NULL auto_increment, `disciplineName` varchar(16) NOT NULL default '', `disciplineDisplayOrder` tinyint(1) NOT NULL default '0', `disciplineDescription` varchar(255) default NULL, `disciplineInactive` tinyint(1) NOT NULL default '0', `LastModified` datetime default NULL, `ModifiedBy` int(10) unsigned default '0', PRIMARY KEY (`disciplineId`), KEY `ModifiedBy` (`ModifiedBy`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `cst`.`discipline` -- /*!40000 ALTER TABLE `discipline` DISABLE KEYS */; INSERT INTO `discipline` (`disciplineId`,`disciplineName`,`disciplineDisplayOrder`,`disciplineDescription`,`disciplineInactive`,`LastModified`,`ModifiedBy`) VALUES (1,'Math',2,NULL,0,NULL,1), (2,'Social Studies',4,NULL,0,NULL,1), (3,'Science',3,NULL,0,NULL,1), (4,'Language Arts',1,NULL,0,NULL,1), (5,'Electives',5,NULL,0,NULL,1); /*!40000 ALTER TABLE `discipline` ENABLE KEYS */; -- -- Table structure for table `cst`.`evaluation` -- DROP TABLE IF EXISTS `evaluation`; CREATE TABLE `evaluation` ( `evaluationId` int(10) unsigned NOT NULL auto_increment, `classId` int(10) unsigned NOT NULL default '0', `evaluationTitle` varchar(255) default NULL, `evaluationDescription` varchar(255) default NULL, `evaluationPoints` smallint(4) unsigned NOT NULL default '0', `evaluationWeight` float(4,2) unsigned NOT NULL default '1.00', `evaluationCritical` tinyint(1) NOT NULL default '0', `evaluationDueDate` date default NULL, `evaluationGradeBookCode` varchar(8) NOT NULL default '', `evaluationGradeBookOrder` tinyint(2) unsigned default NULL, `evaluationGradeBookIsHidden` tinyint(1) default '0', `evaluationInactive` tinyint(1) NOT NULL default '0', `LastModified` datetime default NULL, `ModifiedBy` int(10) unsigned default NULL, PRIMARY KEY (`evaluationId`), KEY `ModifiedBy` (`ModifiedBy`), KEY `classId` (`classId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `cst`.`evaluation` -- /*!40000 ALTER TABLE `evaluation` DISABLE KEYS */; INSERT INTO `evaluation` (`evaluationId`,`classId`,`evaluationTitle`,`evaluationDescription`,`evaluationPoints`,`evaluationWeight`,`evaluationCritical`,`evaluationDueDate`,`evaluationGradeBookCode`,`evaluationGradeBookOrder`,`evaluationGradeBookIsHidden`,`evaluationInactive`,`LastModified`,`ModifiedBy`) VALUES (1,1,'Test eval 1.1',NULL,10,2.00,0,'2005-11-01','Eval 1',1,0,0,NULL,NULL), (2,1,'Test eval 1.2',NULL,20,1.00,0,'2005-11-03','Eval 2',2,0,0,NULL,NULL), (3,2,'Test eval 2.1',NULL,10,2.00,0,'2005-11-01','Eval 1',1,0,0,NULL,NULL), (4,2,'Test eval 2.2',NULL,20,1.00,0,'2005-11-01','Eval 2',2,0,0,NULL,NULL), (5,2,'Test eval 2.3',NULL,10,1.00,0,'2005-11-30','Eval 3',3,0,0,NULL,NULL), (6,1,'Test eval 1.3',NULL,10,1.00,0,'2005-11-05','Eval 3',3,0,0,NULL,NULL), (7,3,'Test eval 3.1',NULL,10,1.00,0,'2005-11-30','Eval 1',NULL,0,0,NULL,NULL); /*!40000 ALTER TABLE `evaluation` ENABLE KEYS */; -- -- Table structure for table `cst`.`grade` -- DROP TABLE IF EXISTS `grade`; CREATE TABLE `grade` ( `gradeId` int(10) unsigned NOT NULL auto_increment, `evaluationId` int(10) unsigned NOT NULL default '0', `userId` int(10) unsigned NOT NULL default '0', `gradeGrade` float(6,3) default NULL, `gradeComment` varchar(255) NOT NULL default '', `gradeInactive` tinyint(1) NOT NULL default '0', `LastModified` datetime default NULL, `ModifiedBy` int(10) unsigned default NULL, PRIMARY KEY (`gradeId`), KEY `ModifiedBy` (`ModifiedBy`), KEY `evaluationId` (`evaluationId`), KEY `userId` (`userId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `cst`.`grade` -- /*!40000 ALTER TABLE `grade` DISABLE KEYS */; INSERT INTO `grade` (`gradeId`,`evaluationId`,`userId`,`gradeGrade`,`gradeComment`,`gradeInactive`,`LastModified`,`ModifiedBy`) VALUES (1,1,2,8.000,'This is a test grade',0,NULL,NULL), (2,2,2,NULL,'',0,NULL,NULL), (3,3,2,8.000,'',0,NULL,NULL), (4,6,2,10.000,'',0,NULL,NULL); /*!40000 ALTER TABLE `grade` ENABLE KEYS */; -- -- Table structure for table `cst`.`gradstandard` -- DROP TABLE IF EXISTS `gradstandard`; CREATE TABLE `gradstandard` ( `gradstandardId` int(10) unsigned NOT NULL auto_increment, `gradstandardTitle` varchar(255) default NULL, `gradstandardInactive` tinyint(1) NOT NULL default '0', `LastModified` datetime default NULL, `ModifiedBy` int(10) unsigned default NULL, PRIMARY KEY (`gradstandardId`), KEY `ModifiedBy` (`ModifiedBy`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `cst`.`gradstandard` -- /*!40000 ALTER TABLE `gradstandard` DISABLE KEYS */; INSERT INTO `gradstandard` (`gradstandardId`,`gradstandardTitle`,`gradstandardInactive`,`LastModified`,`ModifiedBy`) VALUES (1,'Reading, Listening, and Viewing Complex Information',0,'2005-10-17 00:00:00',1), (2,'Technical reading, Listening, and Viewing',0,NULL,1), (3,'This is a bogus but very long grad standard. This is a bogus but very long grad standard. This is a bogus but very long grad standard. This is a bogus but very long grad standard. This is a bogus but very long grad standard. This is a bogus but very long',0,NULL,1); /*!40000 ALTER TABLE `gradstandard` ENABLE KEYS */; -- -- Table structure for table `cst`.`gradstandardgrade` -- DROP TABLE IF EXISTS `gradstandardgrade`; CREATE TABLE `gradstandardgrade` ( `gradstandardgradeId` int(10) unsigned NOT NULL auto_increment, `gradstandardgradeGrade` varchar(5) NOT NULL default '', `gradstandardgradeInactive` tinyint(1) NOT NULL default '0', `LastModified` datetime default NULL, `ModifiedBy` int(10) unsigned default NULL, PRIMARY KEY (`gradstandardgradeId`), KEY `ModifiedBy` (`ModifiedBy`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `cst`.`gradstandardgrade` -- /*!40000 ALTER TABLE `gradstandardgrade` DISABLE KEYS */; INSERT INTO `gradstandardgrade` (`gradstandardgradeId`,`gradstandardgradeGrade`,`gradstandardgradeInactive`,`LastModified`,`ModifiedBy`) VALUES (1,'7-8',0,NULL,1), (2,'9-12',0,NULL,1); /*!40000 ALTER TABLE `gradstandardgrade` ENABLE KEYS */; -- -- Table structure for table `cst`.`gradstandardset` -- DROP TABLE IF EXISTS `gradstandardset`; CREATE TABLE `gradstandardset` ( `gradstandardsetId` int(10) unsigned NOT NULL auto_increment, `gradstandardsetTitle` varchar(64) default NULL, `gradstandardsetDescription` blob, `gradstandardgradeId` int(10) unsigned default NULL, `gradstandardsetInactive` tinyint(1) NOT NULL default '0', `LastModified` datetime default NULL, `ModifiedBy` int(10) unsigned default NULL, PRIMARY KEY (`gradstandardsetId`), KEY `gradstandardgradeId` (`gradstandardgradeId`), KEY `ModifiedBy` (`ModifiedBy`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `cst`.`gradstandardset` -- /*!40000 ALTER TABLE `gradstandardset` DISABLE KEYS */; INSERT INTO `gradstandardset` (`gradstandardsetId`,`gradstandardsetTitle`,`gradstandardsetDescription`,`gradstandardgradeId`,`gradstandardsetInactive`,`LastModified`,`ModifiedBy`) VALUES (1,'Read, Listen, and View',NULL,2,0,NULL,1); /*!40000 ALTER TABLE `gradstandardset` ENABLE KEYS */; -- -- Table structure for table `cst`.`gradstandardset_gradstandardsubset` -- DROP TABLE IF EXISTS `gradstandardset_gradstandardsubset`; CREATE TABLE `gradstandardset_gradstandardsubset` ( `gradstandardsetId` int(10) unsigned NOT NULL auto_increment, `gradstandardsubsetId` int(10) unsigned NOT NULL default '0', `LastModified` datetime default NULL, `ModifiedBy` int(10) unsigned default NULL, PRIMARY KEY (`gradstandardsetId`,`gradstandardsubsetId`), KEY `gradstandardId` (`gradstandardsubsetId`), KEY `ModifiedBy` (`ModifiedBy`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `cst`.`gradstandardset_gradstandardsubset` -- /*!40000 ALTER TABLE `gradstandardset_gradstandardsubset` DISABLE KEYS */; /*!40000 ALTER TABLE `gradstandardset_gradstandardsubset` ENABLE KEYS */; -- -- Table structure for table `cst`.`gradstandardsubset` -- DROP TABLE IF EXISTS `gradstandardsubset`; CREATE TABLE `gradstandardsubset` ( `gradstandardsubsetId` int(10) unsigned NOT NULL auto_increment, `gradstandardsubsetInactive` tinyint(1) NOT NULL default '0', `LastModified` datetime default NULL, `ModifiedBy` int(10) unsigned default NULL, PRIMARY KEY (`gradstandardsubsetId`), KEY `ModifiedBy` (`ModifiedBy`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `cst`.`gradstandardsubset` -- /*!40000 ALTER TABLE `gradstandardsubset` DISABLE KEYS */; INSERT INTO `gradstandardsubset` (`gradstandardsubsetId`,`gradstandardsubsetInactive`,`LastModified`,`ModifiedBy`) VALUES (1,0,NULL,1); /*!40000 ALTER TABLE `gradstandardsubset` ENABLE KEYS */; -- -- Table structure for table `cst`.`gradstandardsubset_gradstandard` -- DROP TABLE IF EXISTS `gradstandardsubset_gradstandard`; CREATE TABLE `gradstandardsubset_gradstandard` ( `gradstandardsubsetId` int(10) unsigned NOT NULL auto_increment, `gradstandardId` int(10) unsigned NOT NULL default '0', `gradstandardRequired` tinyint(1) NOT NULL default '0', `LastModified` datetime default NULL, `ModifiedBy` int(10) unsigned default NULL, PRIMARY KEY (`gradstandardsubsetId`,`gradstandardId`), KEY `gradstandardId` (`gradstandardId`), KEY `ModifiedBy` (`ModifiedBy`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `cst`.`gradstandardsubset_gradstandard` -- /*!40000 ALTER TABLE `gradstandardsubset_gradstandard` DISABLE KEYS */; /*!40000 ALTER TABLE `gradstandardsubset_gradstandard` ENABLE KEYS */; -- -- Table structure for table `cst`.`session` -- DROP TABLE IF EXISTS `session`; CREATE TABLE `session` ( `sessionId` int(10) unsigned NOT NULL auto_increment, `sessionYear` varchar(4) default NULL, `sessiontypeId` int(10) unsigned NOT NULL default '0', `sessionCode` varchar(5) NOT NULL default '', `sessionStart` date NOT NULL default '0000-00-00', `sessionEnd` date NOT NULL default '0000-00-00', `sessionInactive` tinyint(1) NOT NULL default '0', `LastModified` datetime default NULL, `ModifiedBy` int(10) unsigned default NULL, PRIMARY KEY (`sessionId`), KEY `sessiontypeId` (`sessiontypeId`), KEY `ModifiedBy` (`ModifiedBy`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `cst`.`session` -- /*!40000 ALTER TABLE `session` DISABLE KEYS */; INSERT INTO `session` (`sessionId`,`sessionYear`,`sessiontypeId`,`sessionCode`,`sessionStart`,`sessionEnd`,`sessionInactive`,`LastModified`,`ModifiedBy`) VALUES (1,'2005',1,'1','2005-09-06','2005-10-07',0,'2005-11-08 09:48:30',2), (2,'2005',1,'2','2005-10-10','2005-11-18',0,'2005-11-08 09:51:18',2), (3,'2005',1,'3','2005-11-21','2006-01-06',0,'2005-11-08 09:50:02',2), (4,'2005',1,'4','2006-01-09','2006-02-14',0,'2005-11-08 09:50:25',2), (5,'2005',1,'5','2006-02-15','2006-03-31',0,'2005-11-08 09:50:39',2), (6,'2005',1,'6','2006-04-03','2006-05-12',0,'2005-11-08 09:50:53',2), (7,'2004',1,'1','2004-09-01','2004-10-07',0,'2005-11-15 08:02:14',2), (8,'2004',1,'2','2004-10-11','2004-11-24',0,'2005-11-15 08:02:59',2), (9,'2004',1,'3','2004-11-30','2005-01-07',0,'2005-11-15 08:03:32',2), (10,'2004',1,'4','2005-01-10','2005-02-11',0,'2005-11-15 08:03:56',2), (11,'2004',1,'5','2005-02-14','2005-03-18',0,'2005-11-15 08:04:23',2), (12,'2004',1,'6','2005-03-28','2005-05-06',0,'2005-11-15 08:04:48',2); /*!40000 ALTER TABLE `session` ENABLE KEYS */; -- -- Table structure for table `cst`.`sessiontype` -- DROP TABLE IF EXISTS `sessiontype`; CREATE TABLE `sessiontype` ( `sessiontypeId` int(10) unsigned NOT NULL auto_increment, `sessiontypeCode` varchar(8) NOT NULL default '', `sessiontypeDescription` varchar(255) default NULL, `sessiontypeInactive` tinyint(1) NOT NULL default '0', `LastModified` datetime default NULL, `ModifiedBy` int(10) unsigned default NULL, PRIMARY KEY (`sessiontypeId`), KEY `ModifiedBy` (`ModifiedBy`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `cst`.`sessiontype` -- /*!40000 ALTER TABLE `sessiontype` DISABLE KEYS */; INSERT INTO `sessiontype` (`sessiontypeId`,`sessiontypeCode`,`sessiontypeDescription`,`sessiontypeInactive`,`LastModified`,`ModifiedBy`) VALUES (1,'Block','1/6 school year. Approx 25-30 days',0,NULL,NULL); /*!40000 ALTER TABLE `sessiontype` ENABLE KEYS */; -- -- Table structure for table `cst`.`user` -- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `userId` int(10) unsigned NOT NULL auto_increment, `userUsername` varchar(72) NOT NULL default '', `userPassword` varchar(16) default NULL, `userPermission` tinyint(1) NOT NULL default '8', `userFirstName` varchar(32) default NULL, `userMiddleName` varchar(32) default NULL, `userLastName` varchar(32) default NULL, `userNickname` varchar(16) default NULL, `userImage` varchar(128) default NULL, `userLastLogin` datetime default NULL, `userLoginCount` mediumint(4) default NULL, `userInactive` tinyint(1) NOT NULL default '0', `userComments` mediumblob, `LastModified` datetime default NULL, `ModifiedBy` int(10) unsigned default NULL, PRIMARY KEY (`userId`), KEY `ModifiedBy` (`ModifiedBy`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `cst`.`user` -- /*!40000 ALTER TABLE `user` DISABLE KEYS */; INSERT INTO `user` (`userId`,`userUsername`,`userPassword`,`userPermission`,`userFirstName`,`userMiddleName`,`userLastName`,`userNickname`,`userImage`,`userLastLogin`,`userLoginCount`,`userInactive`,`userComments`,`LastModified`,`ModifiedBy`) VALUES (1,'Admin','test',31,'Admin',NULL,'TestUser',NULL,'',NULL,NULL,0,NULL,NULL,NULL), (2,'jimm','bogus',31,'James',NULL,'Martinson','Jim','',NULL,NULL,0,NULL,NULL,NULL), (3,'Staff','test',4,'Staff',NULL,'TestUser',NULL,'',NULL,NULL,0,NULL,NULL,NULL), (4,'Student','test',8,'Student',NULL,'TestUser',NULL,'',NULL,NULL,0,NULL,NULL,NULL), (5,'Faculty','test',2,'Teacher',NULL,'TestUser',NULL,'',NULL,NULL,0,NULL,NULL,NULL), (6,'Work Study','test',16,'Work Study',NULL,'TestUser',NULL,'',NULL,NULL,0,NULL,NULL,NULL), (7,'test','test',0,'Test',NULL,'User',NULL,'',NULL,NULL,0,NULL,NULL,NULL), (8,'ramon','ramon',31,'Ramon',NULL,'Tidwell',NULL,'',NULL,NULL,0,NULL,NULL,NULL), (9,'Jim_M','',31,'Jim','','Martinson','','','2005-10-26 17:00:35',1,0,NULL,'2005-10-26 17:00:35',1), (10,'Eli.Adams','',8,'Eli','','Adams','','','2005-10-26 17:01:04',1,0,NULL,'2005-10-26 17:01:04',1); INSERT INTO `user` (`userId`,`userUsername`,`userPassword`,`userPermission`,`userFirstName`,`userMiddleName`,`userLastName`,`userNickname`,`userImage`,`userLastLogin`,`userLoginCount`,`userInactive`,`userComments`,`LastModified`,`ModifiedBy`) VALUES (34,'Aaron.Smith','',8,'Aaron','','Smith','','','0000-00-00 00:00:00',0,0,NULL,'2005-11-16 16:57:40',9), (35,'Adam.AveLallemant','',8,'Adam','','AveLallemant','','','0000-00-00 00:00:00',0,0,NULL,'2005-11-16 16:57:40',9), (36,'Administrator','',8,'Administrator','','','','','0000-00-00 00:00:00',0,0,NULL,'2005-11-16 16:57:40',9), (37,'Alex.Hard','',8,'Alex','','Hard','','','0000-00-00 00:00:00',0,0,NULL,'2005-11-16 16:57:40',9), (38,'Tiffani.Rushing','',8,'Tiffani','','Rushing','','','0000-00-00 00:00:00',0,0,NULL,'2005-11-16 16:57:40',9), (39,'Aaron.Schuler','',8,'Aaron','','Schuler','','','0000-00-00 00:00:00',0,0,NULL,'2005-11-16 17:11:37',9), (40,'Aaron.Schuler','',8,'Aaron','','Schuler','','','0000-00-00 00:00:00',0,0,NULL,'2005-11-16 17:14:18',9), (41,'Aisha.Fernandez','',8,'Aisha','','Fernandez','','','0000-00-00 00:00:00',0,0,NULL,'2005-11-16 17:14:31',9); /*!40000 ALTER TABLE `user` ENABLE KEYS */; -- -- Table structure for table `cst`.`userpermission` -- DROP TABLE IF EXISTS `userpermission`; CREATE TABLE `userpermission` ( `userpermissionId` int(10) unsigned NOT NULL default '0', `userpermissionName` varchar(12) NOT NULL default '', `userpermissionInactive` tinyint(1) default '0' COMMENT '0=active 1=inactive', `LastModified` datetime default NULL, `ModifiedBy` int(10) unsigned default NULL, PRIMARY KEY (`userpermissionId`), KEY `ModifiedBy` (`ModifiedBy`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `cst`.`userpermission` -- /*!40000 ALTER TABLE `userpermission` DISABLE KEYS */; INSERT INTO `userpermission` (`userpermissionId`,`userpermissionName`,`userpermissionInactive`,`LastModified`,`ModifiedBy`) VALUES (1,'Admin',0,NULL,NULL), (2,'Faculty',0,NULL,NULL), (4,'Staff',1,NULL,NULL), (8,'Student',0,NULL,NULL), (16,'Work Study',1,NULL,NULL); /*!40000 ALTER TABLE `userpermission` ENABLE KEYS */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;