source: iPeer/app/config/sql/ipeer_samples_data.sql @ 14931e5

3.1.xdevhotfixpagodaboxticket463
Last change on this file since 14931e5 was 14931e5, checked in by Compass <pan.luo@…>, 6 years ago

Refactored studentViewEvaluationResult action in evaluation controller,
added more tests

  • Property mode set to 100644
File size: 91.5 KB
Line 
1-- phpMyAdmin SQL Dump
2-- version 2.6.2
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Jun 27, 2006 at 10:51 AM
7-- Server version: 4.1.11
8-- PHP Version: 4.3.10-16
9--
10-- Database: `ipeer2`
11--
12
13SET foreign_key_checks = 0;
14
15-- --------------------------------------------------------
16
17--
18-- Table structure for table `acos`
19--
20
21DROP TABLE IF EXISTS `acos`;
22CREATE TABLE IF NOT EXISTS `acos` (
23  `id` int(10) NOT NULL AUTO_INCREMENT,
24  `parent_id` int(10) DEFAULT NULL,
25  `model` varchar(255) DEFAULT NULL,
26  `foreign_key` int(10) DEFAULT NULL,
27  `alias` varchar(255) DEFAULT NULL,
28  `lft` int(10) DEFAULT NULL,
29  `rght` int(10) DEFAULT NULL,
30  PRIMARY KEY (`id`),
31  KEY `parent_id` (`parent_id`),
32  KEY `alias` (`alias`)
33) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=350 ;
34
35--
36-- Dumping data for table `acos`
37--
38
39INSERT INTO `acos` VALUES (1,NULL,NULL,NULL,'adminpage',1,2),(2,NULL,NULL,NULL,'controllers',3,622),(3,2,NULL,NULL,'Pages',4,17),(4,3,NULL,NULL,'display',5,6),(5,3,NULL,NULL,'add',7,8),(6,3,NULL,NULL,'edit',9,10),(7,3,NULL,NULL,'index',11,12),(8,3,NULL,NULL,'view',13,14),(9,3,NULL,NULL,'delete',15,16),(10,2,NULL,NULL,'Courses',18,35),(11,10,NULL,NULL,'daysLate',19,20),(12,10,NULL,NULL,'index',21,22),(13,10,NULL,NULL,'ajaxList',23,24),(14,10,NULL,NULL,'view',25,26),(15,10,NULL,NULL,'home',27,28),(16,10,NULL,NULL,'add',29,30),(17,10,NULL,NULL,'edit',31,32),(18,10,NULL,NULL,'delete',33,34),(19,2,NULL,NULL,'Departments',36,47),(20,19,NULL,NULL,'index',37,38),(21,19,NULL,NULL,'view',39,40),(22,19,NULL,NULL,'add',41,42),(23,19,NULL,NULL,'edit',43,44),(24,19,NULL,NULL,'delete',45,46),(25,2,NULL,NULL,'Emailer',48,79),(26,25,NULL,NULL,'setUpAjaxList',49,50),(27,25,NULL,NULL,'ajaxList',51,52),(28,25,NULL,NULL,'index',53,54),(29,25,NULL,NULL,'write',55,56),(30,25,NULL,NULL,'cancel',57,58),(31,25,NULL,NULL,'view',59,60),(32,25,NULL,NULL,'addRecipient',61,62),(33,25,NULL,NULL,'deleteRecipient',63,64),(34,25,NULL,NULL,'getRecipient',65,66),(35,25,NULL,NULL,'searchByUserId',67,68),(36,25,NULL,NULL,'doMerge',69,70),(37,25,NULL,NULL,'send',71,72),(38,25,NULL,NULL,'add',73,74),(39,25,NULL,NULL,'edit',75,76),(40,25,NULL,NULL,'delete',77,78),(41,2,NULL,NULL,'Emailtemplates',80,99),(42,41,NULL,NULL,'setUpAjaxList',81,82),(43,41,NULL,NULL,'ajaxList',83,84),(44,41,NULL,NULL,'index',85,86),(45,41,NULL,NULL,'add',87,88),(46,41,NULL,NULL,'edit',89,90),(47,41,NULL,NULL,'delete',91,92),(48,41,NULL,NULL,'view',93,94),(49,41,NULL,NULL,'displayTemplateContent',95,96),(50,41,NULL,NULL,'displayTemplateSubject',97,98),(51,2,NULL,NULL,'Evaltools',100,113),(52,51,NULL,NULL,'index',101,102),(53,51,NULL,NULL,'showAll',103,104),(54,51,NULL,NULL,'add',105,106),(55,51,NULL,NULL,'edit',107,108),(56,51,NULL,NULL,'view',109,110),(57,51,NULL,NULL,'delete',111,112),(58,2,NULL,NULL,'Evaluations',114,173),(59,58,NULL,NULL,'postProcess',115,116),(60,58,NULL,NULL,'setUpAjaxList',117,118),(61,58,NULL,NULL,'ajaxList',119,120),(62,58,NULL,NULL,'view',121,122),(63,58,NULL,NULL,'index',123,124),(64,58,NULL,NULL,'update',125,126),(65,58,NULL,NULL,'export',127,128),(66,58,NULL,NULL,'makeEvaluation',129,130),(67,58,NULL,NULL,'validSurveyEvalComplete',131,132),(68,58,NULL,NULL,'validRubricEvalComplete',133,134),(69,58,NULL,NULL,'completeEvaluationRubric',135,136),(70,58,NULL,NULL,'validMixevalEvalComplete',137,138),(71,58,NULL,NULL,'completeEvaluationMixeval',139,140),(72,58,NULL,NULL,'viewEvaluationResults',141,142),(73,58,NULL,NULL,'viewSurveyGroupEvaluationResults',143,144),(74,58,NULL,NULL,'studentViewEvaluationResult',145,146),(75,58,NULL,NULL,'markEventReviewed',147,148),(76,58,NULL,NULL,'markGradeRelease',149,150),(77,58,NULL,NULL,'markCommentRelease',151,152),(78,58,NULL,NULL,'changeAllCommentRelease',153,154),(79,58,NULL,NULL,'changeAllGradeRelease',155,156),(80,58,NULL,NULL,'viewGroupSubmissionDetails',157,158),(81,58,NULL,NULL,'viewSurveySummary',159,160),(82,58,NULL,NULL,'export_rubic',161,162),(83,58,NULL,NULL,'export_test',163,164),(84,58,NULL,NULL,'pre',165,166),(85,58,NULL,NULL,'add',167,168),(86,58,NULL,NULL,'edit',169,170),(87,58,NULL,NULL,'delete',171,172),(88,2,NULL,NULL,'Events',174,201),(89,88,NULL,NULL,'postProcessData',175,176),(90,88,NULL,NULL,'setUpAjaxList',177,178),(91,88,NULL,NULL,'index',179,180),(92,88,NULL,NULL,'ajaxList',181,182),(93,88,NULL,NULL,'view',183,184),(94,88,NULL,NULL,'eventTemplatesList',185,186),(95,88,NULL,NULL,'add',187,188),(96,88,NULL,NULL,'edit',189,190),(97,88,NULL,NULL,'delete',191,192),(98,88,NULL,NULL,'checkDuplicateTitle',193,194),(99,88,NULL,NULL,'viewGroups',195,196),(100,88,NULL,NULL,'editGroup',197,198),(101,88,NULL,NULL,'getAssignedGroups',199,200),(102,2,NULL,NULL,'Faculties',202,213),(103,102,NULL,NULL,'index',203,204),(104,102,NULL,NULL,'view',205,206),(105,102,NULL,NULL,'add',207,208),(106,102,NULL,NULL,'edit',209,210),(107,102,NULL,NULL,'delete',211,212),(108,2,NULL,NULL,'Framework',214,231),(109,108,NULL,NULL,'calendarDisplay',215,216),(110,108,NULL,NULL,'userInfoDisplay',217,218),(111,108,NULL,NULL,'tutIndex',219,220),(112,108,NULL,NULL,'add',221,222),(113,108,NULL,NULL,'edit',223,224),(114,108,NULL,NULL,'index',225,226),(115,108,NULL,NULL,'view',227,228),(116,108,NULL,NULL,'delete',229,230),(117,2,NULL,NULL,'Groups',232,259),(118,117,NULL,NULL,'postProcess',233,234),(119,117,NULL,NULL,'setUpAjaxList',235,236),(120,117,NULL,NULL,'index',237,238),(121,117,NULL,NULL,'ajaxList',239,240),(122,117,NULL,NULL,'goToClassList',241,242),(123,117,NULL,NULL,'view',243,244),(124,117,NULL,NULL,'add',245,246),(125,117,NULL,NULL,'edit',247,248),(126,117,NULL,NULL,'delete',249,250),(127,117,NULL,NULL,'import',251,252),(128,117,NULL,NULL,'addGroupByImport',253,254),(129,117,NULL,NULL,'export',255,256),(130,117,NULL,NULL,'sendGroupEmail',257,258),(131,2,NULL,NULL,'Home',260,271),(132,131,NULL,NULL,'index',261,262),(133,131,NULL,NULL,'add',263,264),(134,131,NULL,NULL,'edit',265,266),(135,131,NULL,NULL,'view',267,268),(136,131,NULL,NULL,'delete',269,270),(137,2,NULL,NULL,'Install',272,293),(138,137,NULL,NULL,'index',273,274),(139,137,NULL,NULL,'install2',275,276),(140,137,NULL,NULL,'install3',277,278),(141,137,NULL,NULL,'install4',279,280),(142,137,NULL,NULL,'install5',281,282),(143,137,NULL,NULL,'gpl',283,284),(144,137,NULL,NULL,'add',285,286),(145,137,NULL,NULL,'edit',287,288),(146,137,NULL,NULL,'view',289,290),(147,137,NULL,NULL,'delete',291,292),(148,2,NULL,NULL,'Lti',294,305),(149,148,NULL,NULL,'index',295,296),(150,148,NULL,NULL,'add',297,298),(151,148,NULL,NULL,'edit',299,300),(152,148,NULL,NULL,'view',301,302),(153,148,NULL,NULL,'delete',303,304),(154,2,NULL,NULL,'Mixevals',306,335),(155,154,NULL,NULL,'postProcess',307,308),(156,154,NULL,NULL,'setUpAjaxList',309,310),(157,154,NULL,NULL,'index',311,312),(158,154,NULL,NULL,'ajaxList',313,314),(159,154,NULL,NULL,'view',315,316),(160,154,NULL,NULL,'add',317,318),(161,154,NULL,NULL,'deleteQuestion',319,320),(162,154,NULL,NULL,'deleteDescriptor',321,322),(163,154,NULL,NULL,'edit',323,324),(164,154,NULL,NULL,'copy',325,326),(165,154,NULL,NULL,'delete',327,328),(166,154,NULL,NULL,'previewMixeval',329,330),(167,154,NULL,NULL,'renderRows',331,332),(168,154,NULL,NULL,'update',333,334),(169,2,NULL,NULL,'Oauthclients',336,347),(170,169,NULL,NULL,'index',337,338),(171,169,NULL,NULL,'add',339,340),(172,169,NULL,NULL,'edit',341,342),(173,169,NULL,NULL,'delete',343,344),(174,169,NULL,NULL,'view',345,346),(175,2,NULL,NULL,'Oauthtokens',348,359),(176,175,NULL,NULL,'index',349,350),(177,175,NULL,NULL,'add',351,352),(178,175,NULL,NULL,'edit',353,354),(179,175,NULL,NULL,'delete',355,356),(180,175,NULL,NULL,'view',357,358),(181,2,NULL,NULL,'Penalty',360,373),(182,181,NULL,NULL,'save',361,362),(183,181,NULL,NULL,'add',363,364),(184,181,NULL,NULL,'edit',365,366),(185,181,NULL,NULL,'index',367,368),(186,181,NULL,NULL,'view',369,370),(187,181,NULL,NULL,'delete',371,372),(188,2,NULL,NULL,'Rubrics',374,395),(189,188,NULL,NULL,'postProcess',375,376),(190,188,NULL,NULL,'setUpAjaxList',377,378),(191,188,NULL,NULL,'index',379,380),(192,188,NULL,NULL,'ajaxList',381,382),(193,188,NULL,NULL,'view',383,384),(194,188,NULL,NULL,'add',385,386),(195,188,NULL,NULL,'edit',387,388),(196,188,NULL,NULL,'copy',389,390),(197,188,NULL,NULL,'delete',391,392),(198,188,NULL,NULL,'setForm_RubricName',393,394),(199,2,NULL,NULL,'Searchs',396,423),(200,199,NULL,NULL,'update',397,398),(201,199,NULL,NULL,'index',399,400),(202,199,NULL,NULL,'searchEvaluation',401,402),(203,199,NULL,NULL,'searchResult',403,404),(204,199,NULL,NULL,'searchInstructor',405,406),(205,199,NULL,NULL,'eventBoxSearch',407,408),(206,199,NULL,NULL,'formatSearchEvaluation',409,410),(207,199,NULL,NULL,'formatSearchInstructor',411,412),(208,199,NULL,NULL,'formatSearchEvaluationResult',413,414),(209,199,NULL,NULL,'add',415,416),(210,199,NULL,NULL,'edit',417,418),(211,199,NULL,NULL,'view',419,420),(212,199,NULL,NULL,'delete',421,422),(213,2,NULL,NULL,'Simpleevaluations',424,443),(214,213,NULL,NULL,'postProcess',425,426),(215,213,NULL,NULL,'setUpAjaxList',427,428),(216,213,NULL,NULL,'index',429,430),(217,213,NULL,NULL,'ajaxList',431,432),(218,213,NULL,NULL,'view',433,434),(219,213,NULL,NULL,'add',435,436),(220,213,NULL,NULL,'edit',437,438),(221,213,NULL,NULL,'copy',439,440),(222,213,NULL,NULL,'delete',441,442),(223,2,NULL,NULL,'Surveygroups',444,475),(224,223,NULL,NULL,'postProcess',445,446),(225,223,NULL,NULL,'setUpAjaxList',447,448),(226,223,NULL,NULL,'index',449,450),(227,223,NULL,NULL,'ajaxList',451,452),(228,223,NULL,NULL,'viewresult',453,454),(229,223,NULL,NULL,'makegroups',455,456),(230,223,NULL,NULL,'makegroupssearch',457,458),(231,223,NULL,NULL,'maketmgroups',459,460),(232,223,NULL,NULL,'savegroups',461,462),(233,223,NULL,NULL,'release',463,464),(234,223,NULL,NULL,'delete',465,466),(235,223,NULL,NULL,'edit',467,468),(236,223,NULL,NULL,'changegroupset',469,470),(237,223,NULL,NULL,'add',471,472),(238,223,NULL,NULL,'view',473,474),(239,2,NULL,NULL,'Surveys',476,509),(240,239,NULL,NULL,'setUpAjaxList',477,478),(241,239,NULL,NULL,'index',479,480),(242,239,NULL,NULL,'ajaxList',481,482),(243,239,NULL,NULL,'view',483,484),(244,239,NULL,NULL,'add',485,486),(245,239,NULL,NULL,'edit',487,488),(246,239,NULL,NULL,'copy',489,490),(247,239,NULL,NULL,'delete',491,492),(248,239,NULL,NULL,'checkDuplicateName',493,494),(249,239,NULL,NULL,'releaseSurvey',495,496),(250,239,NULL,NULL,'questionsSummary',497,498),(251,239,NULL,NULL,'moveQuestion',499,500),(252,239,NULL,NULL,'removeQuestion',501,502),(253,239,NULL,NULL,'addQuestion',503,504),(254,239,NULL,NULL,'editQuestion',505,506),(255,239,NULL,NULL,'update',507,508),(256,2,NULL,NULL,'Sysparameters',510,525),(257,256,NULL,NULL,'setUpAjaxList',511,512),(258,256,NULL,NULL,'index',513,514),(259,256,NULL,NULL,'ajaxList',515,516),(260,256,NULL,NULL,'view',517,518),(261,256,NULL,NULL,'add',519,520),(262,256,NULL,NULL,'edit',521,522),(263,256,NULL,NULL,'delete',523,524),(264,2,NULL,NULL,'Upgrade',526,539),(265,264,NULL,NULL,'index',527,528),(266,264,NULL,NULL,'step2',529,530),(267,264,NULL,NULL,'add',531,532),(268,264,NULL,NULL,'edit',533,534),(269,264,NULL,NULL,'view',535,536),(270,264,NULL,NULL,'delete',537,538),(271,2,NULL,NULL,'Users',540,567),(272,271,NULL,NULL,'ajaxList',541,542),(273,271,NULL,NULL,'index',543,544),(274,271,NULL,NULL,'goToClassList',545,546),(275,271,NULL,NULL,'determineIfStudentFromThisData',547,548),(276,271,NULL,NULL,'view',549,550),(277,271,NULL,NULL,'add',551,552),(278,271,NULL,NULL,'edit',553,554),(279,271,NULL,NULL,'editProfile',555,556),(280,271,NULL,NULL,'delete',557,558),(281,271,NULL,NULL,'checkDuplicateName',559,560),(282,271,NULL,NULL,'resetPassword',561,562),(283,271,NULL,NULL,'import',563,564),(284,271,NULL,NULL,'update',565,566),(285,2,NULL,NULL,'V1',568,603),(286,285,NULL,NULL,'oauth',569,570),(287,285,NULL,NULL,'oauth_error',571,572),(288,285,NULL,NULL,'users',573,574),(289,285,NULL,NULL,'courses',575,576),(290,285,NULL,NULL,'groups',577,578),(291,285,NULL,NULL,'groupMembers',579,580),(292,285,NULL,NULL,'events',581,582),(293,285,NULL,NULL,'grades',583,584),(294,285,NULL,NULL,'departments',585,586),(295,285,NULL,NULL,'courseDepartments',587,588),(296,285,NULL,NULL,'userEvents',589,590),(297,285,NULL,NULL,'enrolment',591,592),(298,285,NULL,NULL,'add',593,594),(299,285,NULL,NULL,'edit',595,596),(300,285,NULL,NULL,'index',597,598),(301,285,NULL,NULL,'view',599,600),(302,285,NULL,NULL,'delete',601,602),(303,2,NULL,NULL,'Guard',604,621),(304,303,NULL,NULL,'Guard',605,620),(305,304,NULL,NULL,'login',606,607),(306,304,NULL,NULL,'logout',608,609),(307,304,NULL,NULL,'add',610,611),(308,304,NULL,NULL,'edit',612,613),(309,304,NULL,NULL,'index',614,615),(310,304,NULL,NULL,'view',616,617),(311,304,NULL,NULL,'delete',618,619),(312,NULL,NULL,NULL,'functions',623,686),(313,312,NULL,NULL,'user',624,651),(314,313,NULL,NULL,'superadmin',625,626),(315,313,NULL,NULL,'admin',627,628),(316,313,NULL,NULL,'instructor',629,630),(317,313,NULL,NULL,'tutor',631,632),(318,313,NULL,NULL,'student',633,634),(319,313,NULL,NULL,'import',635,636),(320,313,NULL,NULL,'password_reset',637,648),(321,320,NULL,NULL,'superadmin',638,639),(322,320,NULL,NULL,'admin',640,641),(323,320,NULL,NULL,'instructor',642,643),(324,320,NULL,NULL,'tutor',644,645),(325,320,NULL,NULL,'student',646,647),(326,313,NULL,NULL,'index',649,650),(327,312,NULL,NULL,'role',652,663),(328,327,NULL,NULL,'superadmin',653,654),(329,327,NULL,NULL,'admin',655,656),(330,327,NULL,NULL,'instructor',657,658),(331,327,NULL,NULL,'tutor',659,660),(332,327,NULL,NULL,'student',661,662),(333,312,NULL,NULL,'evaluation',664,667),(334,333,NULL,NULL,'export',665,666),(335,312,NULL,NULL,'email',668,675),(336,335,NULL,NULL,'allUsers',669,670),(337,335,NULL,NULL,'allGroups',671,672),(338,335,NULL,NULL,'allCourses',673,674),(339,312,NULL,NULL,'emailtemplate',676,677),(340,312,NULL,NULL,'viewstudentresults',678,679),(341,312,NULL,NULL,'viewemailaddresses',680,681),(342,312,NULL,NULL,'superadmin',682,683),(343,312,NULL,NULL,'coursemanager',684,685);
40
41
42-- --------------------------------------------------------
43
44--
45-- Table structure for table `aros`
46--
47
48DROP TABLE IF EXISTS `aros`;
49CREATE TABLE IF NOT EXISTS `aros` (
50  `id` int(10) NOT NULL AUTO_INCREMENT,
51  `parent_id` int(10) DEFAULT NULL,
52  `model` varchar(255) DEFAULT NULL,
53  `foreign_key` int(10) DEFAULT NULL,
54  `alias` varchar(255) DEFAULT NULL,
55  `lft` int(10) DEFAULT NULL,
56  `rght` int(10) DEFAULT NULL,
57  PRIMARY KEY (`id`)
58) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
59
60--
61-- Dumping data for table `aros`
62--
63
64INSERT INTO `aros` (`id`, `parent_id`, `model`, `foreign_key`, `alias`, `lft`, `rght`) VALUES
65(1, NULL, 'Role', 1, NULL, 1, 2),
66(2, NULL, 'Role', 2, NULL, 3, 4),
67(3, NULL, 'Role', 3, NULL, 5, 6),
68(4, NULL, 'Role', 4, NULL, 7, 8),
69(5, NULL, 'Role', 5, NULL, 9, 10);
70
71-- --------------------------------------------------------
72
73--
74-- Table structure for table `aros_acos`
75--
76
77DROP TABLE IF EXISTS `aros_acos`;
78CREATE TABLE IF NOT EXISTS `aros_acos` (
79  `id` int(10) NOT NULL AUTO_INCREMENT,
80  `aro_id` int(10) NOT NULL,
81  `aco_id` int(10) NOT NULL,
82  `_create` varchar(2) NOT NULL DEFAULT '0',
83  `_read` varchar(2) NOT NULL DEFAULT '0',
84  `_update` varchar(2) NOT NULL DEFAULT '0',
85  `_delete` varchar(2) NOT NULL DEFAULT '0',
86  PRIMARY KEY (`id`),
87  UNIQUE KEY `ARO_ACO_KEY` (`aro_id`,`aco_id`)
88) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=60 ;
89
90--
91-- Dumping data for table `aros_acos`
92--
93
94INSERT INTO `aros_acos` VALUES (1,1,2,'1','1','1','1'),(2,1,312,'1','1','1','1'),(3,1,51,'1','1','1','1'),(4,1,213,'1','1','1','1'),(5,1,188,'1','1','1','1'),(6,1,154,'1','1','1','1'),(7,1,239,'1','1','1','1'),(8,1,223,'1','1','1','1'),(9,1,25,'1','1','1','1'),(10,1,41,'1','1','1','1'),(11,1,88,'1','1','1','1'),(12,1,102,'1','1','1','1'),(13,1,19,'1','1','1','1'),(14,1,117,'1','1','1','1'),(15,1,1,'1','1','1','1'),(16,1,341,'1','1','1','1'),(17,1,342,'1','1','1','1'),(18,2,2,'-1','-1','-1','-1'),(19,2,131,'1','1','1','1'),(20,2,10,'1','1','1','1'),(21,2,19,'1','1','1','1'),(22,2,25,'1','1','1','1'),(23,2,41,'1','1','1','1'),(24,2,51,'1','1','1','1'),(25,2,58,'1','1','1','1'),(26,2,88,'1','1','1','1'),(27,2,117,'1','1','1','1'),(28,2,154,'1','1','1','1'),(29,2,188,'1','1','1','1'),(30,2,213,'1','1','1','1'),(31,2,239,'1','1','1','1'),(32,2,223,'1','1','1','1'),(33,2,271,'1','1','1','1'),(34,2,306,'1','1','1','1'),(35,2,171,'1','1','1','1'),(36,2,173,'1','1','1','1'),(37,2,177,'1','1','1','1'),(38,2,179,'1','1','1','1'),(39,2,312,'-1','-1','-1','-1'),(40,2,339,'1','1','1','1'),(41,2,333,'1','1','1','1'),(42,2,336,'1','1','1','1'),(43,2,313,'1','1','1','1'),(44,2,315,'-1','1','-1','-1'),(45,2,314,'-1','-1','-1','-1'),(46,2,1,'1','1','1','1'),(47,2,341,'1','1','1','1'),(48,2,343,'1','1','1','1'),(49,2,342,'-1','-1','-1','-1'),(50,3,2,'-1','-1','-1','-1'),(51,3,131,'1','1','1','1'),(52,3,10,'1','1','1','1'),(53,3,16,'-1','-1','-1','-1'),(54,3,17,'-1','-1','-1','-1'),(55,3,25,'1','1','1','1'),(56,3,41,'1','1','1','1'),(57,3,51,'1','1','1','1'),(58,3,58,'1','1','1','1'),(59,3,88,'1','1','1','1'),(60,3,117,'1','1','1','1'),(61,3,154,'1','1','1','1'),(62,3,188,'1','1','1','1'),(63,3,213,'1','1','1','1'),(64,3,239,'1','1','1','1'),(65,3,223,'1','1','1','1'),(66,3,271,'1','1','1','1'),(67,3,306,'1','1','1','1'),(68,3,171,'1','1','1','1'),(69,3,173,'1','1','1','1'),(70,3,177,'1','1','1','1'),(71,3,179,'1','1','1','1'),(72,3,312,'-1','-1','-1','-1'),(73,3,333,'1','1','-1','-1'),(74,3,313,'1','1','1','1'),(75,3,315,'-1','-1','-1','-1'),(76,3,314,'-1','-1','-1','-1'),(77,3,316,'-1','1','-1','-1'),(78,3,326,'-1','-1','-1','-1'),(79,3,341,'-1','-1','-1','-1'),(80,3,342,'-1','-1','-1','-1'),(81,3,343,'1','1','1','1'),(82,4,2,'-1','-1','-1','-1'),(83,4,131,'1','1','1','1'),(84,4,10,'-1','-1','-1','-1'),(85,4,25,'-1','-1','-1','-1'),(86,4,41,'-1','-1','-1','-1'),(87,4,51,'-1','-1','-1','-1'),(88,4,88,'-1','-1','-1','-1'),(89,4,117,'-1','-1','-1','-1'),(90,4,154,'-1','-1','-1','-1'),(91,4,188,'-1','-1','-1','-1'),(92,4,213,'-1','-1','-1','-1'),(93,4,239,'-1','-1','-1','-1'),(94,4,223,'-1','-1','-1','-1'),(95,4,271,'-1','-1','-1','-1'),(96,4,306,'1','1','1','1'),(97,4,66,'1','1','1','1'),(98,4,74,'1','1','1','1'),(99,4,69,'1','1','1','1'),(100,4,71,'1','1','1','1'),(101,4,279,'1','1','1','1'),(102,4,171,'1','1','1','1'),(103,4,173,'1','1','1','1'),(104,4,177,'1','1','1','1'),(105,4,179,'1','1','1','1'),(106,4,312,'-1','-1','-1','-1'),(107,4,341,'-1','-1','-1','-1'),(108,4,342,'-1','-1','-1','-1'),(109,5,2,'-1','-1','-1','-1'),(110,5,131,'1','1','1','1'),(111,5,10,'-1','-1','-1','-1'),(112,5,25,'-1','-1','-1','-1'),(113,5,41,'-1','-1','-1','-1'),(114,5,51,'-1','-1','-1','-1'),(115,5,88,'-1','-1','-1','-1'),(116,5,117,'-1','-1','-1','-1'),(117,5,154,'-1','-1','-1','-1'),(118,5,188,'-1','-1','-1','-1'),(119,5,213,'-1','-1','-1','-1'),(120,5,239,'-1','-1','-1','-1'),(121,5,223,'-1','-1','-1','-1'),(122,5,271,'-1','-1','-1','-1'),(123,5,306,'1','1','1','1'),(124,5,66,'1','1','1','1'),(125,5,74,'1','1','1','1'),(126,5,69,'1','1','1','1'),(127,5,71,'1','1','1','1'),(128,5,279,'1','1','1','1'),(129,5,171,'1','1','1','1'),(130,5,173,'1','1','1','1'),(131,5,177,'1','1','1','1'),(132,5,179,'1','1','1','1'),(133,5,312,'-1','-1','-1','-1'),(134,5,340,'1','1','1','1'),(135,5,341,'-1','-1','-1','-1'),(136,5,342,'-1','-1','-1','-1');
95
96-- --------------------------------------------------------
97
98--
99-- Table structure for table `courses`
100--
101
102DROP TABLE IF EXISTS `courses`;
103CREATE TABLE `courses` (
104  `id` int(11) NOT NULL auto_increment,
105  `course` varchar(80) NOT NULL default '',
106  `title` varchar(80) default NULL,
107  `homepage` varchar(100) default NULL,
108  `self_enroll` varchar(3) default 'off',
109  `password` varchar(25) default NULL,
110  `record_status` varchar(1) NOT NULL default 'A',
111  `creator_id` int(11) NOT NULL default '0',
112  `created` datetime NOT NULL default '0000-00-00 00:00:00',
113  `updater_id` int(11) default NULL,
114  `modified` datetime default NULL,
115  `instructor_id` int(11) NOT NULL default '0',
116  PRIMARY KEY  (`id`),
117  UNIQUE KEY `course` (`course`)
118) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
119
120--
121-- Dumping data for table `courses`
122--
123
124INSERT INTO `courses` VALUES (1, 'MECH 328', 'Mechanical Engineering Design Project', 'http://www.mech.ubc.ca', 'off', NULL, 'A', 1, '2006-06-20 14:14:45', NULL, '2006-06-20 14:14:45', 0);
125INSERT INTO `courses` VALUES (2, 'APSC 201', 'Technical Communication', 'http://www.apsc.ubc.ca', 'off', NULL, 'A', 1, '2006-06-20 14:15:38', NULL, '2006-06-20 14:39:31', 0);
126INSERT INTO `courses` VALUES (3, 'CPSC 101', 'Connecting with Computer Science', 'http://www.ugrad.cs.ubc.ca/~cs101/', 'off', NULL, 'I', 0, '2006-06-20 00:00:00', NULL, NULL, 0);
127-- --------------------------------------------------------
128
129--
130-- Table structure for table `users`
131--
132
133DROP TABLE IF EXISTS `users`;
134CREATE TABLE IF NOT EXISTS `users` (
135  `id` int(11) NOT NULL AUTO_INCREMENT,
136  `username` varchar(80) NOT NULL DEFAULT '',
137  `password` varchar(80) NOT NULL DEFAULT '',
138  `first_name` varchar(80) DEFAULT NULL,
139  `last_name` varchar(80) DEFAULT NULL,
140  `student_no` varchar(30) DEFAULT NULL,
141  `title` varchar(80) DEFAULT NULL,
142  `email` varchar(80) DEFAULT NULL,
143  `last_login` datetime DEFAULT NULL,
144  `last_logout` datetime DEFAULT NULL,
145  `last_accessed` varchar(10) DEFAULT NULL,
146  `record_status` char(1) NOT NULL DEFAULT 'A',
147  `creator_id` int(11) NOT NULL DEFAULT '0',
148  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
149  `updater_id` int(11) DEFAULT NULL,
150  `modified` datetime DEFAULT NULL,
151  `lti_id` int DEFAULT NULL,
152  PRIMARY KEY (`id`),
153  UNIQUE KEY `username` (`username`),
154  UNIQUE (`lti_id`)
155) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
156
157--
158-- Dumping data for table `users`
159--
160
161INSERT INTO `users` (`id`, `username`, `password`, `first_name`, `last_name`, `student_no`, `title`, `email`, `last_login`, `last_logout`, `last_accessed`, `record_status`, `creator_id`, `created`, `updater_id`, `modified`, `lti_id`) VALUES
162(1, 'root', 'b17c3f638781ecd22648b509e138c00f', 'Super', 'Admin', NULL, NULL, '', NULL, NULL, NULL, 'A', 1, NOW(), NULL, NOW(), NULL),
163(2, 'instructor1', 'b17c3f638781ecd22648b509e138c00f', 'Instructor', '1', NULL, 'Instructor', 'instructor1@email', NULL, NULL, NULL, 'A', 1, '2006-06-19 16:25:24', NULL, '2006-06-19 16:25:24', NULL),
164(3, 'instructor2', 'b17c3f638781ecd22648b509e138c00f', 'Instructor', '2', NULL, 'Professor', '', NULL, NULL, NULL, 'A', 1, '2006-06-20 14:17:02', NULL, '2006-06-20 14:17:02', NULL),
165(4, 'instructor3', 'b17c3f638781ecd22648b509e138c00f', 'Instructor', '3', NULL, 'Assistant Professor', '', NULL, NULL, NULL, 'A', 1, '2006-06-20 14:17:53', NULL, '2006-06-20 14:17:53', NULL),
166(5, '65498451', 'b17c3f638781ecd22648b509e138c00f', 'Ed', 'Student', '65498451', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 14:19:18', NULL, '2006-06-20 14:19:18', NULL),
167(6, '65468188', 'b17c3f638781ecd22648b509e138c00f', 'Alex', 'Student', '65468188', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 14:26:59', NULL, '2006-06-20 14:26:59', NULL),
168(7, '98985481', 'b17c3f638781ecd22648b509e138c00f', 'Matt', 'Student', '98985481', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 14:27:24', NULL, '2006-06-20 14:27:24', NULL),
169(8, '16585158', 'b17c3f638781ecd22648b509e138c00f', 'Chris', 'Student', '16585158', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 14:27:43', NULL, '2006-06-20 14:27:43', NULL),
170(9, '81121651', 'b17c3f638781ecd22648b509e138c00f', 'Johnny', 'Student', '81121651', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 14:28:08', NULL, '2006-06-20 14:28:08', NULL),
171(10, '87800283', 'b17c3f638781ecd22648b509e138c00f', 'Travis', 'Student', '87800283', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 14:28:29', NULL, '2006-06-20 14:28:29', NULL),
172(11, '68541180', 'b17c3f638781ecd22648b509e138c00f', 'Kelly', 'Student', '68541180', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 14:28:49', NULL, '2006-06-20 14:28:49', NULL),
173(12, '48451389', 'b17c3f638781ecd22648b509e138c00f', 'Peter', 'Student', '48451389', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 14:29:07', NULL, '2006-06-20 14:29:07', NULL),
174(13, '84188465', 'b17c3f638781ecd22648b509e138c00f', 'Damien', 'Student', '84188465', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 14:31:17', NULL, '2006-06-20 14:31:17', NULL),
175(14, '27701036', 'b17c3f638781ecd22648b509e138c00f', 'Hajar', 'Student', '27701036', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 14:47:34', NULL, '2006-06-20 14:47:34', NULL),
176(15, '48877031', 'b17c3f638781ecd22648b509e138c00f', 'Jennifer', 'Student', '48877031', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 15:00:35', NULL, '2006-06-20 15:00:35', NULL),
177(16, '25731063', 'b17c3f638781ecd22648b509e138c00f', 'Chad', 'Student', '25731063', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 15:01:09', NULL, '2006-06-20 15:01:09', NULL),
178(17, '37116036', 'b17c3f638781ecd22648b509e138c00f', 'Edna', 'Student', '37116036', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 15:01:24', NULL, '2006-06-20 15:01:24', NULL),
179(18, '76035030', 'b17c3f638781ecd22648b509e138c00f', 'Denny', 'Student', '76035030', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 15:01:52', NULL, '2006-06-20 15:01:52', NULL),
180(19, '90938044', 'b17c3f638781ecd22648b509e138c00f', 'Jonathan', 'Student', '90938044', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 15:02:20', NULL, '2006-06-20 15:02:20', NULL),
181(20, '88505045', 'b17c3f638781ecd22648b509e138c00f', 'Soroush', 'Student', '88505045', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 15:03:27', NULL, '2006-06-20 15:03:27', NULL),
182(21, '22784037', 'b17c3f638781ecd22648b509e138c00f', 'Nicole', 'Student', '22784037', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 15:03:47', NULL, '2006-06-20 15:03:47', NULL),
183(22, '37048022', 'b17c3f638781ecd22648b509e138c00f', 'Vivian', 'Student', '37048022', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 15:04:22', NULL, '2006-06-20 15:04:22', NULL),
184(23, '89947048', 'b17c3f638781ecd22648b509e138c00f', 'Trevor', 'Student', '89947048', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 15:05:55', NULL, '2006-06-20 15:05:55', NULL),
185(24, '39823059', 'b17c3f638781ecd22648b509e138c00f', 'Michael', 'Student', '39823059', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 15:06:20', NULL, '2006-06-20 15:06:20', NULL),
186(25, '35644039', 'b17c3f638781ecd22648b509e138c00f', 'Steven', 'Student', '35644039', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 15:06:46', NULL, '2006-06-20 15:06:46', NULL),
187(26, '19524032', 'b17c3f638781ecd22648b509e138c00f', 'Bill', 'Student', '19524032', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 15:07:01', NULL, '2006-06-20 15:07:01', NULL),
188(27, '40289059', 'b17c3f638781ecd22648b509e138c00f', 'Van Hong', 'Student', '40289059', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 15:07:37', NULL, '2006-06-20 15:07:37', NULL),
189(28, '38058020', 'b17c3f638781ecd22648b509e138c00f', 'Michael', 'Student', '38058020', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 15:08:04', NULL, '2006-06-20 15:08:04', NULL),
190(29, '38861035', 'b17c3f638781ecd22648b509e138c00f', 'Jonathan', 'Student', '38861035', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 15:08:31', NULL, '2006-06-20 15:08:31', NULL),
191(30, '27879030', 'b17c3f638781ecd22648b509e138c00f', 'Geoff', 'Student', '27879030', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 15:08:47', NULL, '2006-06-20 15:08:47', NULL),
192(31, '10186039', 'b17c3f638781ecd22648b509e138c00f', 'Hui', 'Student', '10186039', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 15:10:16', NULL, '2006-06-20 15:10:16', NULL),
193(32, '19803030', 'b17c3f638781ecd22648b509e138c00f', 'Bowinn', 'Student', '19803030', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-20 15:10:32', NULL, '2006-06-20 15:10:32', NULL),
194(33, '51516498', 'b17c3f638781ecd22648b509e138c00f', 'Joe', 'Student', '51516498', NULL, '', NULL, NULL, NULL, 'A', 1, '2006-06-21 08:44:09', 33, '2006-06-21 08:45:00', NULL),
195(34, 'admin1', 'b17c3f638781ecd22648b509e138c00f', '', '', '', '', '', NULL, NULL, NULL, 'A', 1, '2012-05-25 15:48:08', 1, '2012-05-25 15:48:08', NULL),
196(35, 'tutor1', 'b17c3f638781ecd22648b509e138c00f', 'Tutor', '1', '', '', '', NULL, NULL, NULL, 'A', 1, '2012-05-25 15:48:08', 1, '2012-05-25 15:48:08', NULL),
197(36, 'tutor2', 'b17c3f638781ecd22648b509e138c00f', 'Tutor', '2', '', '', '', NULL, NULL, NULL, 'A', 1, '2012-05-25 15:48:08', 1, '2012-05-25 15:48:08', NULL),
198(37, 'tutor3', 'b17c3f638781ecd22648b509e138c00f', 'Tutor', '3', '', '', '', NULL, NULL, NULL, 'A', 1, '2012-05-25 15:48:08', 1, '2012-05-25 15:48:08', NULL),
199(38, 'admin2', 'b17c3f638781ecd22648b509e138c00f', '', '', '', '', '', NULL, NULL, NULL, 'A', 1, '2012-05-25 15:48:08', 1, '2012-05-25 15:48:08', NULL);
200
201-- --------------------------------------------------------
202
203--
204-- Table structure for table `faculties`
205--
206
207DROP TABLE IF EXISTS `faculties`;
208CREATE TABLE IF NOT EXISTS `faculties` (
209  `id` int(11) NOT NULL AUTO_INCREMENT,
210  `name` varchar(80) NOT NULL,
211  `creator_id` int(11) NOT NULL DEFAULT '0',
212  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
213  `updater_id` int(11) DEFAULT NULL,
214  `modified` datetime DEFAULT NULL,
215  PRIMARY KEY (`id`),
216  UNIQUE (`name`)
217) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
218
219--
220-- Dumping data for table `faculties`
221--
222
223INSERT INTO `faculties` (`id`, `name`, `creator_id`, `created`, `updater_id`, `modified`) VALUES
224(1, 'Applied Science', 0, '0000-00-00 00:00:00', NULL, '2012-05-23 11:29:58'),
225(2, 'Science', 0, '0000-00-00 00:00:00', NULL, '2012-05-23 11:30:05');
226
227-- --------------------------------------------------------
228
229--
230-- Table structure for table `departments`
231--
232
233DROP TABLE IF EXISTS `departments`;
234CREATE TABLE IF NOT EXISTS `departments` (
235  `id` int(11) NOT NULL AUTO_INCREMENT,
236  `name` varchar(80) NOT NULL,
237  `faculty_id` int NOT NULL,
238  `creator_id` int(11) NOT NULL DEFAULT '0',
239  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
240  `updater_id` int(11) DEFAULT NULL,
241  `modified` datetime DEFAULT NULL,
242  FOREIGN KEY (`faculty_id`) REFERENCES `faculties` (`id`) ON DELETE CASCADE,
243  PRIMARY KEY (`id`),
244  UNIQUE (`name`)
245) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
246
247--
248-- Dumping data for table `departments`
249--
250
251INSERT INTO `departments` (`id`, `name`, `faculty_id`, `creator_id`, `created`, `updater_id`, `modified`) VALUES
252(1, 'MECH', 1, 0, '0000-00-00 00:00:00', NULL, '2012-05-23 11:30:41'),
253(2, 'APSC', 1, 0, '0000-00-00 00:00:00', NULL, '2012-05-23 11:30:57'),
254(3, 'CPSC', 2, 0, '0000-00-00 00:00:00', NULL, '2012-05-23 11:31:07');
255
256-- --------------------------------------------------------
257
258--
259-- Table structure for table `course_departments`
260--
261
262DROP TABLE IF EXISTS `course_departments`;
263CREATE TABLE `course_departments` (
264  `id` int NOT NULL auto_increment,
265  `course_id` int NOT NULL,
266  `department_id` int NOT NULL,
267  FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE,
268  FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE CASCADE,
269  PRIMARY KEY  (`id`)
270) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
271
272--
273-- Dumping data for table `course_departments`
274--
275
276INSERT INTO `course_departments` (`id`, `course_id`, `department_id`) VALUES
277(1, 2, 2),
278(2, 1, 1),
279(3, 3, 3);
280
281-- --------------------------------------------------------
282
283--
284-- Table structure for table `email_merges`
285--
286
287DROP TABLE IF EXISTS `email_merges`;
288CREATE TABLE IF NOT EXISTS `email_merges` (
289  `id` int(11) NOT NULL AUTO_INCREMENT,
290  `key` varchar(80) NOT NULL,
291  `value` varchar(80) NOT NULL,
292  `table_name` varchar(80) NOT NULL,
293  `field_name` varchar(80) NOT NULL,
294  `created` datetime NOT NULL,
295  `modified` datetime NOT NULL,
296  PRIMARY KEY (`id`)
297) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
298
299--
300-- Dumping data for table `email_merges`
301--
302
303INSERT INTO `email_merges` (`id`, `key`, `value`, `table_name`, `field_name`, `created`, `modified`) VALUES
304(1, 'Username', '{{{USERNAME}}}', 'User', 'username', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
305(2, 'First Name', '{{{FIRSTNAME}}}', 'User', 'first_name', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
306(3, 'Last Name', '{{{LASTNAME}}}', 'User', 'last_name', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
307(4, 'Email Address', '{{{Email}}}', 'User', 'email', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
308
309-- --------------------------------------------------------
310
311--
312-- Table structure for table `email_schedules`
313--
314
315DROP TABLE IF EXISTS `email_schedules`;
316CREATE TABLE IF NOT EXISTS `email_schedules` (
317  `id` int(11) NOT NULL AUTO_INCREMENT,
318  `subject` varchar(80) NOT NULL,
319  `content` text NOT NULL,
320  `date` datetime NOT NULL,
321  `from` varchar(80) NOT NULL,
322  `to` varchar(600) NOT NULL,
323  `course_id` int(11) DEFAULT NULL,
324  `event_id` int(11) DEFAULT NULL,
325  `grp_id` int(11) DEFAULT NULL,
326  `sent` tinyint(1) NOT NULL DEFAULT '0',
327  `creator_id` int(11) NOT NULL,
328  `created` datetime NOT NULL,
329  PRIMARY KEY (`id`)
330) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
331
332--
333-- Dumping data for table `email_schedules`
334--
335
336INSERT INTO `email_schedules` (`id`, `subject`, `content`, `date`, `from`, `to`, `course_id`, `event_id`, `grp_id`, `sent`, `creator_id`, `created`) VALUES
337(1, 'Email Template', 'Hello, {{{FIRSTNAME}}}', '2013-07-18 16:52:31', '1', '5;6;7;13;15;17;19;21;26;28;31;32;33', NULL, NULL, NULL, 0, 1, '2012-07-16 16:52:50'),
338(2, 'Email Template', 'Hello, {{{USERNAME}}}', '2011-07-18 16:52:31', '1', '5;6;7;13;15;17;19;21;26;28;31;32;33', NULL, NULL, NULL, 0, 1, '2010-07-16 16:57:50'),
339(3, 'Email Template', 'Hi, {{{USERNAME}}}', '2011-07-18 17:52:31', '1', '5;6;7;13;15;17;19;21;26;28;31;32;33', NULL, NULL, NULL, 1, 1, '2010-07-16 16:57:50');
340
341-- --------------------------------------------------------
342
343--
344-- Table structure for table `email_templates`
345--
346
347DROP TABLE IF EXISTS `email_templates`;
348CREATE TABLE IF NOT EXISTS `email_templates` (
349  `id` int(11) NOT NULL AUTO_INCREMENT,
350  `name` varchar(80) NOT NULL,
351  `description` text NOT NULL,
352  `subject` varchar(80) NOT NULL,
353  `content` text NOT NULL,
354  `availability` tinyint(4) NOT NULL,
355  `creator_id` int(11) NOT NULL DEFAULT '0',
356  `created` datetime NOT NULL DEFAULT '0000-00-00',
357  `updater_id` int(11) DEFAULT NULL,
358  `updated` datetime DEFAULT NULL,
359  PRIMARY KEY (`id`)
360) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
361
362--
363-- Dumping data for table `email_templates`
364--
365
366INSERT INTO `email_templates` (`id`, `name`, `description`, `subject`, `content`, `availability`, `creator_id`, `created`, `updater_id`, `updated`) VALUES
367(1, 'Submission Confirmation', 'template for submission confirmation', 'iPeer: Evaluation Submission Confirmation', 'Hi {{{FIRSTNAME}}}, \nYour evaluation has been submitted successfully. Thank you for your feedback!\n\n iPeer',1, 1, NOW(), NULL, NULL),
368(2, 'Email template example', 'This is an email template example', 'Email Template', 'Hello, {{{USERNAME}}}',1, 1, '0000-00-00', NULL, NULL),
369(3, 'Email template example2', 'email template ex2', 'Email Template2', 'Hello, {{{FIRSTNAME}}}',1, 2, '0000-00-00', NULL, NULL),
370(4, 'Email template example3', 'email temp example3', 'Email Template3', 'Hello,',1, 3, '0000-00-00', NULL, NULL);
371
372
373-- --------------------------------------------------------
374
375--
376-- Table structure for table `evaluation_mixeval_details`
377--
378
379DROP TABLE IF EXISTS `evaluation_mixeval_details`;
380CREATE TABLE IF NOT EXISTS `evaluation_mixeval_details` (
381  `id` int(11) NOT NULL AUTO_INCREMENT,
382  `evaluation_mixeval_id` int(11) NOT NULL DEFAULT '0',
383  `question_number` int(11) NOT NULL DEFAULT '0',
384  `question_comment` text,
385  `selected_lom` int(11) NOT NULL DEFAULT '0',
386  `grade` double(12,2) NOT NULL DEFAULT '0.00',
387  `record_status` char(1) NOT NULL DEFAULT 'A',
388  `creator_id` int(11) NOT NULL DEFAULT '0',
389  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
390  `updater_id` int(11) DEFAULT NULL,
391  `modified` datetime DEFAULT NULL,
392  PRIMARY KEY (`id`),
393  UNIQUE KEY `evaluation_mixeval_id` (`evaluation_mixeval_id`,`question_number`)
394) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
395
396--
397-- Dumping data for table `evaluation_mixeval_details`
398--
399
400INSERT INTO evaluation_mixeval_details (id, evaluation_mixeval_id, question_number, question_comment, selected_lom, grade, record_status, creator_id, created, updater_id, modified) VALUES
401(1, 1, 0, NULL, 5, 1.00, 'A', 7, '2012-07-13 10:38:20', 7, '2012-07-13 10:38:20'),
402(2, 1, 1, NULL, 5, 1.00, 'A', 7, '2012-07-13 10:38:20', 7, '2012-07-13 10:38:20'),
403(3, 1, 2, NULL, 5, 1.00, 'A', 7, '2012-07-13 10:38:20', 7, '2012-07-13 10:38:20'),
404(4, 1, 3, 'work very efficiently', 0, 0.00, 'A', 7, '2012-07-13 10:38:20', 7, '2012-07-13 10:38:20'),
405(5, 1, 4, 'Contributed his part', 0, 0.00, 'A', 7, '2012-07-13 10:38:20', 7, '2012-07-13 10:38:20'),
406(6, 1, 5, 'very easy to work with', 0, 0.00, 'A', 7, '2012-07-13 10:38:20', 7, '2012-07-13 10:38:20'),
407(7, 2, 0, NULL, 4, 0.80, 'A', 7, '2012-07-13 10:39:28', 7, '2012-07-13 10:39:28'),
408(8, 2, 1, NULL, 4, 0.80, 'A', 7, '2012-07-13 10:39:28', 7, '2012-07-13 10:39:28'),
409(9, 2, 2, NULL, 4, 0.80, 'A', 7, '2012-07-13 10:39:28', 7, '2012-07-13 10:39:28'),
410(10, 2, 3, 'Yes', 0, 0.00, 'A', 7, '2012-07-13 10:39:28', 7, '2012-07-13 10:39:28'),
411(11, 2, 4, 'He contributed in all parts of the project.', 0, 0.00, 'A', 7, '2012-07-13 10:39:28', 7, '2012-07-13 10:39:28'),
412(12, 2, 5, 'He is very easy to communicate with.', 0, 0.00, 'A', 7, '2012-07-13 10:39:28', 7, '2012-07-13 10:39:28'),
413(13, 3, 0, NULL, 5, 1.00, 'A', 31, '2012-07-13 10:42:49', 31, '2012-07-13 10:42:49'),
414(14, 3, 1, NULL, 5, 1.00, 'A', 31, '2012-07-13 10:42:49', 31, '2012-07-13 10:42:49'),
415(15, 3, 2, NULL, 5, 1.00, 'A', 31, '2012-07-13 10:42:49', 31, '2012-07-13 10:42:49'),
416(16, 3, 3, 'does great work', 0, 0.00, 'A', 31, '2012-07-13 10:42:49', 31, '2012-07-13 10:42:49'),
417(17, 3, 4, 'willing to do their part', 0, 0.00, 'A', 31, '2012-07-13 10:42:49', 31, '2012-07-13 10:42:49'),
418(18, 3, 5, 'absolutely easy to work with', 0, 0.00, 'A', 31, '2012-07-13 10:42:49', 31, '2012-07-13 10:42:49'),
419(19, 4, 0, NULL, 4, 0.80, 'A', 31, '2012-07-13 10:43:59', 31, '2012-07-13 10:43:59'),
420(20, 4, 1, NULL, 4, 0.80, 'A', 31, '2012-07-13 10:43:59', 31, '2012-07-13 10:43:59'),
421(21, 4, 2, NULL, 5, 1.00, 'A', 31, '2012-07-13 10:43:59', 31, '2012-07-13 10:43:59'),
422(22, 4, 3, 'produce efficient work', 0, 0.00, 'A', 31, '2012-07-13 10:43:59', 31, '2012-07-13 10:43:59'),
423(23, 4, 4, 'definitely', 0, 0.00, 'A', 31, '2012-07-13 10:43:59', 31, '2012-07-13 10:43:59'),
424(24, 4, 5, 'very easy to get along with', 0, 0.00, 'A', 31, '2012-07-13 10:43:59', 31, '2012-07-13 10:43:59'),
425(25, 5, 0, NULL, 4, 0.80, 'A', 5, '2012-07-13 15:19:26', 5, '2012-07-13 15:19:26'),
426(26, 5, 1, NULL, 4, 0.80, 'A', 5, '2012-07-13 15:19:26', 5, '2012-07-13 15:19:26'),
427(27, 5, 2, NULL, 4, 0.80, 'A', 5, '2012-07-13 15:19:26', 5, '2012-07-13 15:19:26'),
428(28, 5, 3, 'Yes', 0, 0.00, 'A', 5, '2012-07-13 15:19:26', 5, '2012-07-13 15:19:26'),
429(29, 5, 4, 'Yes', 0, 0.00, 'A', 5, '2012-07-13 15:19:26', 5, '2012-07-13 15:19:26'),
430(30, 5, 5, 'Yes', 0, 0.00, 'A', 5, '2012-07-13 15:19:26', 5, '2012-07-13 15:19:26');
431
432-- --------------------------------------------------------
433
434--
435-- Table structure for table `evaluation_mixevals`
436--
437
438DROP TABLE IF EXISTS `evaluation_mixevals`;
439CREATE TABLE IF NOT EXISTS `evaluation_mixevals` (
440  `id` int(11) NOT NULL AUTO_INCREMENT,
441  `evaluator` int(11) NOT NULL DEFAULT '0',
442  `evaluatee` int(11) NOT NULL DEFAULT '0',
443  `score` double(12,2) NOT NULL DEFAULT '0.00',
444  `comment_release` int(1) NOT NULL DEFAULT '0',
445  `grade_release` int(1) NOT NULL DEFAULT '0',
446  `grp_event_id` int(11) NOT NULL DEFAULT '0',
447  `event_id` int(11) NOT NULL DEFAULT '0',
448  `record_status` char(1) NOT NULL DEFAULT 'A',
449  `creator_id` int(11) NOT NULL DEFAULT '0',
450  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
451  `updater_id` int(11) DEFAULT NULL,
452  `modified` datetime DEFAULT NULL,
453  PRIMARY KEY (`id`)
454) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
455
456--
457-- Dumping data for table `evaluation_mixevals`
458--
459
460INSERT INTO evaluation_mixevals (id, evaluator, evaluatee, score, comment_release, grade_release, grp_event_id, event_id, record_status, creator_id, created, updater_id, modified) VALUES
461(1, 7, 5, 3.00, 0, 0, 5, 3, 'A', 7, '2012-07-13 10:38:20', 7, '2012-07-13 10:38:20'),
462(2, 7, 6, 2.40, 0, 0, 5, 3, 'A', 7, '2012-07-13 10:39:28', 7, '2012-07-13 10:39:28'),
463(3, 31, 32, 3.00, 0, 0, 6, 3, 'A', 31, '2012-07-13 10:42:49', 31, '2012-07-13 10:42:49'),
464(4, 31, 33, 2.60, 0, 0, 6, 3, 'A', 31, '2012-07-13 10:43:59', 31, '2012-07-13 10:43:59'),
465(5, 5, 6, 2.40, 0, 0, 5, 3, 'A', 5, '2012-07-13 15:19:26', 5, '2012-07-13 15:19:26');
466
467-- --------------------------------------------------------
468
469--
470-- Table structure for table `evaluation_rubric_details`
471--
472
473DROP TABLE IF EXISTS `evaluation_rubric_details`;
474CREATE TABLE IF NOT EXISTS `evaluation_rubric_details` (
475  `id` int(11) NOT NULL AUTO_INCREMENT,
476  `evaluation_rubric_id` int(11) NOT NULL DEFAULT '0',
477  `criteria_number` int(11) NOT NULL DEFAULT '0',
478  `criteria_comment` varchar(255) DEFAULT NULL,
479  `selected_lom` int(11) NOT NULL DEFAULT '0',
480  `grade` double(12,2) NOT NULL DEFAULT '0.00',
481  `record_status` char(1) NOT NULL DEFAULT 'A',
482  `creator_id` int(11) NOT NULL DEFAULT '0',
483  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
484  `updater_id` int(11) DEFAULT NULL,
485  `modified` datetime DEFAULT NULL,
486  PRIMARY KEY (`id`),
487  UNIQUE KEY `evaluation_rubric_id` (`evaluation_rubric_id`,`criteria_number`)
488) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
489
490--
491-- Dumping data for table `evaluation_rubric_details`
492--
493
494INSERT INTO evaluation_rubric_details (id, evaluation_rubric_id, criteria_number, criteria_comment, selected_lom, grade, record_status, creator_id, created, updater_id, modified) VALUES
495(1, 1, 1, 'always on time', 5, 5.00, 'A', 31, '2012-07-13 10:26:47', 31, '2012-07-13 10:26:47'),
496(2, 1, 2, 'willing to do their part', 5, 5.00, 'A', 31, '2012-07-13 10:26:47', 31, '2012-07-13 10:26:47'),
497(3, 1, 3, 'everything was done a day early', 5, 5.00, 'A', 31, '2012-07-13 10:26:47', 31, '2012-07-13 10:26:47'),
498(4, 2, 1, 'attended most meetings', 4, 4.00, 'A', 31, '2012-07-13 10:29:15', 31, '2012-07-13 10:29:15'),
499(5, 2, 2, 'very co-operative', 5, 5.00, 'A', 31, '2012-07-13 10:29:15', 31, '2012-07-13 10:29:15'),
500(6, 2, 3, 'finished all his work on time', 5, 5.00, 'A', 31, '2012-07-13 10:29:15', 31, '2012-07-13 10:29:15'),
501(7, 3, 1, 'Yes', 5, 5.00, 'A', 7, '2012-07-13 10:30:29', 7, '2012-07-13 10:30:29'),
502(8, 3, 2, 'Absolutely', 4, 4.00, 'A', 7, '2012-07-13 10:30:29', 7, '2012-07-13 10:30:29'),
503(9, 3, 3, 'Definitely', 5, 5.00, 'A', 7, '2012-07-13 10:30:29', 7, '2012-07-13 10:30:29'),
504(10, 4, 1, 'attended all of our team meetings', 5, 5.00, 'A', 7, '2012-07-13 10:31:19', 7, '2012-07-13 10:31:19'),
505(11, 4, 2, 'very helpful in all parts of the project', 5, 5.00, 'A', 7, '2012-07-13 10:31:19', 7, '2012-07-13 10:31:19'),
506(12, 4, 3, 'Yes', 5, 5.00, 'A', 7, '2012-07-13 10:31:19', 7, '2012-07-13 10:31:19');
507
508-- --------------------------------------------------------
509
510--
511-- Table structure for table `evaluation_rubrics`
512--
513
514DROP TABLE IF EXISTS `evaluation_rubrics`;
515CREATE TABLE IF NOT EXISTS `evaluation_rubrics` (
516  `id` int(11) NOT NULL AUTO_INCREMENT,
517  `evaluator` int(11) NOT NULL DEFAULT '0',
518  `evaluatee` int(11) NOT NULL DEFAULT '0',
519  `general_comment` text,
520  `score` double(12,2) NOT NULL DEFAULT '0.00',
521  `comment_release` int(1) NOT NULL DEFAULT '0',
522  `grade_release` int(1) NOT NULL DEFAULT '0',
523  `grp_event_id` int(11) NOT NULL DEFAULT '0',
524  `event_id` int(11) NOT NULL DEFAULT '0',
525  `record_status` char(1) NOT NULL DEFAULT 'A',
526  `creator_id` int(11) NOT NULL DEFAULT '0',
527  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
528  `updater_id` int(11) DEFAULT NULL,
529  `modified` datetime DEFAULT NULL,
530  `rubric_id` int(11) NOT NULL DEFAULT '0',
531  PRIMARY KEY (`id`)
532) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
533
534--
535-- Dumping data for table `evaluation_rubrics`
536--
537
538INSERT INTO evaluation_rubrics (id, evaluator, evaluatee, general_comment, score, comment_release, grade_release, grp_event_id, event_id, record_status, creator_id, created, updater_id, modified, rubric_id) VALUES
539(1, 31, 32, 'We work well together.', 15.00, 0, 0, 4, 2, 'A', 31, '2012-07-13 10:26:47', 31, '2012-07-13 10:26:47', 1),
540(2, 31, 33, 'He did a great job.', 14.00, 0, 0, 4, 2, 'A', 31, '2012-07-13 10:29:14', 31, '2012-07-13 10:29:15', 1),
541(3, 7, 5, 'Good group member.', 14.00, 0, 0, 3, 2, 'A', 7, '2012-07-13 10:30:29', 7, '2012-07-13 10:30:29', 1),
542(4, 7, 6, 'Good job.', 15.00, 0, 0, 3, 2, 'A', 7, '2012-07-13 10:31:19', 7, '2012-07-13 10:31:19', 1);
543
544-- --------------------------------------------------------
545
546--
547-- Table structure for table `evaluation_simples`
548--
549
550DROP TABLE IF EXISTS `evaluation_simples`;
551CREATE TABLE IF NOT EXISTS `evaluation_simples` (
552  `id` int(11) NOT NULL AUTO_INCREMENT,
553  `evaluator` int(11) NOT NULL DEFAULT '0',
554  `evaluatee` int(11) NOT NULL DEFAULT '0',
555  `score` int(5) NOT NULL DEFAULT '0',
556  `eval_comment` text,
557  `release_status` int(1) NOT NULL DEFAULT '0',
558  `grp_event_id` int(11) NOT NULL DEFAULT '0',
559  `event_id` bigint(11) NOT NULL DEFAULT '0',
560  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
561  `grade_release` int(1) DEFAULT NULL,
562  `record_status` char(1) NOT NULL DEFAULT 'A',
563  `creator_id` int(11) NOT NULL DEFAULT '0',
564  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
565  `updater_id` int(11) DEFAULT NULL,
566  `modified` datetime DEFAULT NULL,
567  PRIMARY KEY (`id`)
568) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
569
570--
571-- Dumping data for table `evaluation_simples`
572--
573
574INSERT INTO evaluation_simples (id, evaluator, evaluatee, score, eval_comment, release_status, grp_event_id, event_id, date_submitted, grade_release, record_status, creator_id, created, updater_id, modified) VALUES
575(1, 7, 5, 95, 'very hard working', 0, 1, 1, '2012-07-13 10:21:57', 0, 'A', 7, '2012-07-13 10:21:57', 7, '2012-07-13 10:21:57'),
576(2, 7, 6, 105, 'did a decent job', 0, 1, 1, '2012-07-13 10:21:57', 0, 'A', 7, '2012-07-13 10:21:57', 7, '2012-07-13 10:21:57'),
577(3, 31, 32, 125, 'very good job', 0, 2, 1, '2012-07-13 10:23:11', 0, 'A', 31, '2012-07-13 10:23:11', 31, '2012-07-13 10:23:11'),
578(4, 31, 33, 75, 'he participated', 0, 2, 1, '2012-07-13 10:23:11', 0, 'A', 31, '2012-07-13 10:23:11', 31, '2012-07-13 10:23:11'),
579(6, 5, 7, 105, '', 0, 7, 6, '2012-11-21 12:24:51', 0, 'A', 5, '2012-11-21 12:24:51', 5, '2012-11-21 12:24:51'),
580(7, 5, 6, 95, '', 0, 7, 6, '2012-11-21 12:24:51', 0, 'A', 5, '2012-11-21 12:24:51', 5, '2012-11-21 12:24:51'),
581(8, 5, 7, 105, '', 0, 10, 8, '2012-11-21 12:24:51', 0, 'A', 5, '2012-11-21 12:24:51', 5, '2012-11-21 12:24:51'),
582(9, 5, 6, 95, '', 0, 10, 8, '2012-11-21 12:24:51', 0, 'A', 5, '2012-11-21 12:24:51', 5, '2012-11-21 12:24:51');
583
584
585
586-- --------------------------------------------------------
587
588--
589-- Table structure for table `evaluation_submissions`
590--
591
592DROP TABLE IF EXISTS `evaluation_submissions`;
593CREATE TABLE IF NOT EXISTS `evaluation_submissions` (
594  `id` int(11) NOT NULL AUTO_INCREMENT,
595  `event_id` bigint(20) NOT NULL DEFAULT '0',
596  `grp_event_id` int(11) DEFAULT NULL,
597  `submitter_id` int(11) NOT NULL DEFAULT '0',
598  `submitted` tinyint(1) NOT NULL DEFAULT '0',
599  `date_submitted` datetime DEFAULT NULL,
600  `record_status` char(1) NOT NULL DEFAULT 'A',
601  `creator_id` int(11) NOT NULL DEFAULT '0',
602  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
603  `updater_id` int(11) DEFAULT NULL,
604  `modified` datetime DEFAULT NULL,
605  PRIMARY KEY (`id`),
606  UNIQUE KEY `grp_event_id` (`grp_event_id`,`submitter_id`)
607) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
608
609--
610-- Dumping data for table `evaluation_submissions`
611--
612
613INSERT INTO evaluation_submissions (id, event_id, grp_event_id, submitter_id, submitted, date_submitted, record_status, creator_id, created, updater_id, modified) VALUES
614(1, 1, 1, 7, 1, '2012-07-13 10:21:57', 'A', 7, '2012-07-13 10:21:57', 7, '2012-07-13 10:21:57'),
615(2, 2, 3, 7, 1, '2012-07-13 11:04:11', 'A', 7, '2012-07-13 11:04:11', 7, '2012-07-13 11:04:11'),
616(3, 3, 5, 7, 1, '2012-07-13 11:04:23', 'A', 7, '2012-07-13 11:04:23', 7, '2012-07-13 11:04:23'),
617(4, 1, 2, 31, 1, '2012-07-13 10:23:11', 'A', 31, '2012-07-13 10:23:11', 31, '2012-07-13 10:23:11'),
618(5, 2, 4, 31, 1, '2012-07-13 11:04:11', 'A', 31, '2012-07-13 11:04:11', 31, '2012-07-13 11:04:11'),
619(6, 3, 6, 31, 1, '2012-07-13 11:06:23', 'A', 31, '2012-07-13 11:06:23', 31, '2012-07-13 11:06:23'),
620(7, 4, NULL, 7, 1, '2012-07-13 11:23:31', 'A', 7, '2012-07-13 11:23:31', 7, '2012-07-13 11:23:31'),
621(8, 4, NULL, 31, 1, '2012-07-13 11:24:09', 'A', 31, '2012-07-13 11:24:09', 31, '2012-07-13 11:24:09'),
622(9, 5, NULL, 17, 1, '2012-07-17 10:10:10', 'A', 17, '2012-07-17 10:10:10', 17, '2012-07-17 10:10:10'),
623(10, 6, 7, 5, 1, '2012-11-21 12:24:51', 'A', 5, '2012-11-21 12:24:51', 5, '2012-11-21 12:24:51'),
624(11, 8, 10, 5, 1, '2012-11-21 12:24:51', 'A', 5, '2012-11-21 12:24:51', 5, '2012-11-21 12:24:51');
625
626
627-- --------------------------------------------------------
628
629--
630-- Table structure for table `event_template_types`
631--
632
633DROP TABLE IF EXISTS `event_template_types`;
634CREATE TABLE IF NOT EXISTS `event_template_types` (
635  `id` int(11) NOT NULL AUTO_INCREMENT,
636  `type_name` varchar(50) NOT NULL DEFAULT '',
637  `table_name` varchar(50) NOT NULL DEFAULT '',
638  `model_name` varchar(80) NOT NULL DEFAULT '',
639  `display_for_selection` tinyint(1) NOT NULL DEFAULT '1',
640  `record_status` char(1) NOT NULL DEFAULT 'A',
641  `creator_id` int(11) NOT NULL DEFAULT '0',
642  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
643  `updater_id` int(11) DEFAULT NULL,
644  `modified` datetime DEFAULT NULL,
645  PRIMARY KEY (`id`),
646  UNIQUE KEY `type_name` (`type_name`),
647  UNIQUE KEY `table_name` (`table_name`)
648) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
649
650--
651-- Dumping data for table `event_template_types`
652--
653
654INSERT INTO `event_template_types` (`id`, `type_name`, `table_name`, `model_name`, `display_for_selection`, `record_status`, `creator_id`, `created`, `updater_id`, `modified`) VALUES
655(1, 'SIMPLE', 'simple_evaluations', 'SimpleEvaluation', 1, 'A', 0, '0000-00-00 00:00:00', NULL, NULL),
656(2, 'RUBRIC', 'rubrics', 'Rubric', 1, 'A', 0, '0000-00-00 00:00:00', NULL, NULL),
657(3, 'SURVEY', 'surveys', '', 0, 'A', 0, '0000-00-00 00:00:00', NULL, NULL),
658(4, 'MIX EVALUATION', 'mixevals', 'Mixeval', 1, 'A', 0, '2006-04-03 11:51:02', 0, '2006-04-06 15:31:48');
659
660-- --------------------------------------------------------
661
662--
663-- Table structure for table `events`
664--
665
666DROP TABLE IF EXISTS `events`;
667CREATE TABLE IF NOT EXISTS `events` (
668  `id` int(11) NOT NULL AUTO_INCREMENT,
669  `title` varchar(255) NOT NULL DEFAULT '',
670  `course_id` int(11) NOT NULL DEFAULT '0',
671  `description` text,
672  `event_template_type_id` int(20) NOT NULL DEFAULT '0',
673  `template_id` int(11) NOT NULL DEFAULT '2',
674  `self_eval` varchar(11) NOT NULL DEFAULT '',
675  `com_req` int(11) NOT NULL DEFAULT '0',
676  `due_date` datetime DEFAULT NULL,
677  `release_date_begin` datetime DEFAULT NULL,
678  `release_date_end` datetime DEFAULT NULL,
679  `result_release_date_begin` datetime DEFAULT NULL,
680  `result_release_date_end` datetime DEFAULT NULL,
681  `record_status` char(1) NOT NULL DEFAULT 'A',
682  `creator_id` int(11) NOT NULL DEFAULT '0',
683  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
684  `updater_id` int(11) DEFAULT NULL,
685  `modified` datetime DEFAULT NULL,
686  PRIMARY KEY (`id`)
687) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
688
689--
690-- Dumping data for table `events`
691--
692
693INSERT INTO events (id, title, course_id, description, event_template_type_id, template_id, self_eval, com_req, due_date, release_date_begin, release_date_end, result_release_date_begin, result_release_date_end, record_status, creator_id, created, updater_id, modified) VALUES
694(1, 'Term 1 Evaluation', 1, '', 1, 1, '0', 0, '2013-07-02 16:34:43', '2011-06-16 16:34:49', '2023-07-22 16:34:53', '2024-07-04 16:34:43', '2024-07-30 16:34:43', 'A', 1, '2006-06-20 16:27:33', 1, '2006-06-21 08:51:20'),
695(2, 'Term Report Evaluation', 1, '', 2, 1, '0', 0, '2013-06-08 08:59:29', '2011-06-06 08:59:35', '2023-07-02 08:59:41', '2024-06-09 08:59:29', '2024-07-08 08:59:29', 'A', 1, '2006-06-21 08:52:20', 1, '2006-06-21 08:54:25'),
696(3, 'Project Evaluation', 1, '', 4, 1, '0', 0, '2013-07-02 09:00:28', '2011-06-07 09:00:35', '2023-07-09 09:00:39', '2023-07-04 09:00:28', '2024-07-12 09:00:28', 'A', 1, '2006-06-21 08:53:14', 1, '2006-06-21 09:07:26'),
697(4, 'Team Creation Survey', 1, NULL, 3, 1, '1', 1, '2013-07-31 11:20:00', '2012-07-01 11:20:00', '2013-12-31 11:20:00', NULL, NULL, 'A', 2, '2012-07-13 11:18:56', 2, '2012-07-13 11:18:56'),
698(5, 'Survey, all Q types', 1, NULL, 3, 2, '1', 1, '2013-07-31 11:20:00', '2012-07-01 11:20:00', '2013-12-31 11:20:00', NULL, NULL, 'A', 1, '2012-07-13 11:18:56', 1, '2012-07-13 11:18:56'),
699(6, 'simple evaluation 2', 1, '2nd simple evaluation', 1, 1, '0', 0, '2012-11-28 00:00:00', '2012-11-20 00:00:00', '2022-11-29 00:00:00', '2022-11-30 00:00:00', '2022-12-12 00:00:00', 'A', 1, '2012-11-21 12:23:13', 1, '2012-11-21 12:23:13'),
700(7, 'simple evaluation 3', 1, '3rd simple evaluation for testing overdue event', 1, 1, '0', 0, '2012-11-28 00:00:00', '2012-11-20 00:00:00', '2012-11-29 00:00:00', '2022-11-30 00:00:00', '2022-12-12 00:00:00', 'A', 1, '2012-11-21 12:23:13', 1, '2012-11-21 12:23:13'),
701(8, 'simple evaluation 4', 1, 'result released with submission', 1, 1, '0', 0, '2012-11-28 00:00:00', '2012-11-20 00:00:00', '2012-11-29 00:00:00', '2012-11-30 00:00:00', '2022-12-12 00:00:00', 'A', 1, '2012-11-21 12:23:13', 1, '2012-11-21 12:23:13'),
702(9, 'simple evaluation 5', 1, 'result released with no submission', 1, 1, '0', 0, '2012-11-28 00:00:00', '2012-11-20 00:00:00', '2012-11-29 00:00:00', '2012-11-30 00:00:00', '2022-12-12 00:00:00', 'A', 1, '2012-11-21 12:23:13', 1, '2012-11-21 12:23:13');
703
704-- --------------------------------------------------------
705
706--
707-- Table structure for table `group_events`
708--
709
710DROP TABLE IF EXISTS `group_events`;
711CREATE TABLE IF NOT EXISTS `group_events` (
712  `id` int(11) NOT NULL AUTO_INCREMENT,
713  `group_id` int(11) NOT NULL DEFAULT '0',
714  `event_id` int(11) NOT NULL DEFAULT '0',
715  `marked` varchar(20) NOT NULL DEFAULT 'not reviewed',
716  `grade` double(12,2) DEFAULT NULL,
717  `grade_release_status` varchar(20) NOT NULL DEFAULT 'None',
718  `comment_release_status` varchar(20) NOT NULL DEFAULT 'None',
719  `record_status` char(1) NOT NULL DEFAULT 'A',
720  `creator_id` int(11) NOT NULL DEFAULT '0',
721  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
722  `updater_id` int(11) DEFAULT NULL,
723  `modified` datetime DEFAULT NULL,
724  PRIMARY KEY (`id`),
725  UNIQUE KEY `group_id` (`event_id`,`group_id`)
726) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
727
728--
729-- Dumping data for table `group_events`
730--
731
732INSERT INTO `group_events` VALUES (1, 1, 1, 'not reviewed', NULL, 'None', 'None', 'A', 0, '2006-06-20 16:27:33', NULL, '2006-06-20 16:27:33');
733INSERT INTO `group_events` VALUES (2, 2, 1, 'not reviewed', NULL, 'None', 'None', 'A', 0, '2006-06-21 08:50:22', NULL, '2006-06-21 08:50:22');
734INSERT INTO `group_events` VALUES (3, 1, 2, 'not reviewed', NULL, 'None', 'None', 'A', 0, '2006-06-21 08:52:20', NULL, '2006-06-21 08:52:20');
735INSERT INTO `group_events` VALUES (4, 2, 2, 'not reviewed', NULL, 'None', 'None', 'A', 0, '2006-06-21 08:52:20', NULL, '2006-06-21 08:52:20');
736INSERT INTO `group_events` VALUES (5, 1, 3, 'not reviewed', NULL, 'None', 'None', 'A', 0, '2006-06-21 08:53:23', NULL, '2006-06-21 08:53:23');
737INSERT INTO `group_events` VALUES (6, 2, 3, 'not reviewed', NULL, 'None', 'None', 'A', 0, '2006-06-21 08:53:23', NULL, '2006-06-21 08:53:23');
738INSERT INTO `group_events` VALUES (7, 1, 6, 'not reviewed', NULL, 'None', 'None', 'A', 0, '0000-00-00 00:00:00', NULL, NULL);
739INSERT INTO `group_events` VALUES (8, 2, 6, 'not reviewed', NULL, 'None', 'None', 'A', 0, '0000-00-00 00:00:00', NULL, NULL);
740INSERT INTO `group_events` VALUES (9, 1, 7, 'not reviewed', NULL, 'None', 'None', 'A', 0, '0000-00-00 00:00:00', NULL, NULL);
741INSERT INTO `group_events` VALUES (10, 1, 8, 'not reviewed', NULL, 'None', 'None', 'A', 0, '0000-00-00 00:00:00', NULL, NULL);
742INSERT INTO `group_events` VALUES (11, 1, 9, 'not reviewed', NULL, 'None', 'None', 'A', 0, '0000-00-00 00:00:00', NULL, NULL);
743-- --------------------------------------------------------
744
745--
746-- Table structure for table `groups`
747--
748
749DROP TABLE IF EXISTS `groups`;
750CREATE TABLE IF NOT EXISTS `groups` (
751  `id` int(11) NOT NULL AUTO_INCREMENT,
752  `group_num` int(4) NOT NULL DEFAULT '0',
753  `group_name` varchar(80) DEFAULT NULL,
754  `course_id` int(11) DEFAULT NULL,
755  `record_status` varchar(1) NOT NULL DEFAULT 'A',
756  `creator_id` int(11) NOT NULL DEFAULT '0',
757  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
758  `updater_id` int(11) DEFAULT NULL,
759  `modified` datetime DEFAULT NULL,
760  PRIMARY KEY (`id`)
761) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
762
763--
764-- Dumping data for table `groups`
765--
766
767INSERT INTO `groups` VALUES (1, 1, 'Reapers', 1, 'A', 0, '2006-06-20 16:23:40', NULL, '2006-06-20 16:23:40');
768INSERT INTO `groups` VALUES (2, 2, 'Lazy Engineers', 1, 'A', 0, '2006-06-21 08:47:04', NULL, '2006-06-21 08:49:53');
769
770-- --------------------------------------------------------
771
772--
773-- Table structure for table `groups_members`
774--
775
776DROP TABLE IF EXISTS `groups_members`;
777CREATE TABLE IF NOT EXISTS `groups_members` (
778  `id` int(11) NOT NULL AUTO_INCREMENT,
779  `group_id` int(11) NOT NULL DEFAULT '0',
780  `user_id` int(11) NOT NULL DEFAULT '0',
781  PRIMARY KEY (`id`),
782  KEY `group_id` (`group_id`)
783) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
784
785--
786-- Dumping data for table `groups_members`
787--
788
789INSERT INTO `groups_members` VALUES (1, 1, 5);
790INSERT INTO `groups_members` VALUES (2, 1, 6);
791INSERT INTO `groups_members` VALUES (3, 1, 7);
792INSERT INTO `groups_members` VALUES (4, 1, 35);
793INSERT INTO `groups_members` VALUES (5, 2, 31);
794INSERT INTO `groups_members` VALUES (6, 2, 32);
795INSERT INTO `groups_members` VALUES (7, 2, 33);
796INSERT INTO `groups_members` VALUES (8, 2, 36);
797
798-- --------------------------------------------------------
799
800--
801-- Table structure for table `mixevals`
802--
803
804DROP TABLE IF EXISTS `mixevals`;
805CREATE TABLE IF NOT EXISTS `mixevals` (
806  `id` int(11) NOT NULL AUTO_INCREMENT,
807  `name` varchar(80) NOT NULL DEFAULT '',
808  `zero_mark` tinyint(1) NOT NULL DEFAULT '0',
809  `total_question` int(11) NOT NULL DEFAULT '0',
810  `lickert_question_max` int(11) NOT NULL DEFAULT '0',
811  `scale_max` int(11) NOT NULL DEFAULT '0',
812  `prefill_question_max` int(11) DEFAULT NULL,
813  `availability` varchar(10) NOT NULL DEFAULT 'public',
814  `creator_id` int(11) NOT NULL DEFAULT '0',
815  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
816  `updater_id` int(11) DEFAULT NULL,
817  `modified` datetime DEFAULT NULL,
818  PRIMARY KEY (`id`)
819) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
820
821--
822-- Dumping data for table `mixevals`
823--
824
825INSERT INTO `mixevals` (`id`, `name`, `zero_mark`, `total_question`, `lickert_question_max`, `scale_max`, `prefill_question_max`, `availability`, `creator_id`, `created`, `updater_id`, `modified`) VALUES
826(1, 'Default Mix Evalution', 0, 7, 3, 5, 3, 'public', 1, '2006-09-12 13:34:30', 1, '2006-09-12 13:47:57');
827
828-- --------------------------------------------------------
829
830--
831-- Table structure for table `mixevals_question_descs`
832--
833
834DROP TABLE IF EXISTS `mixevals_question_descs`;
835CREATE TABLE IF NOT EXISTS `mixevals_question_descs` (
836  `id` int(11) NOT NULL AUTO_INCREMENT,
837  `question_id` int(11) NOT NULL DEFAULT '0',
838  `scale_level` int(11) NOT NULL DEFAULT '0',
839  `descriptor` varchar(255) DEFAULT NULL,
840  PRIMARY KEY (`id`),
841  KEY `question_num` (`question_id`)
842) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
843
844--
845-- Dumping data for table `mixevals_question_descs`
846--
847
848INSERT INTO `mixevals_question_descs` (`id`, `question_id`, `scale_level`, `descriptor`) VALUES
849(1, 1, 1, 'Lowest'),
850(2, 1, 2, NULL),
851(3, 1, 3, 'Middle'),
852(4, 1, 4, NULL),
853(5, 1, 5, 'Highest'),
854(6, 2, 1, 'Lowest'),
855(7, 2, 2, NULL),
856(8, 2, 3, 'Middle'),
857(9, 2, 4, NULL),
858(10, 2, 5, 'Highest'),
859(11, 3, 1, 'Lowest'),
860(12, 3, 2, NULL),
861(13, 3, 3, 'Middle'),
862(14, 3, 4, NULL),
863(15, 3, 5, 'Highest');
864
865-- --------------------------------------------------------
866
867--
868-- Table structure for table `mixevals_questions`
869--
870
871DROP TABLE IF EXISTS `mixevals_questions`;
872CREATE TABLE IF NOT EXISTS `mixevals_questions` (
873  `id` int(11) NOT NULL AUTO_INCREMENT,
874  `mixeval_id` int(11) NOT NULL DEFAULT '0',
875  `question_num` int(11) NOT NULL DEFAULT '0',
876  `title` text,
877  `instructions` text,
878  `question_type` char(1) DEFAULT NULL,
879  `required` tinyint(1) NOT NULL DEFAULT '1',
880  `multiplier` int(11) NOT NULL DEFAULT '0',
881  `scale_level` int(11) NOT NULL DEFAULT '0',
882  `response_type` char(1) DEFAULT NULL,
883  PRIMARY KEY (`id`)
884) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
885
886--
887-- Dumping data for table `mixevals_questions`
888--
889
890INSERT INTO `mixevals_questions` (`id`, `mixeval_id`, `question_num`, `title`, `instructions`, `question_type`, `required`, `multiplier`, `scale_level`, `response_type`) VALUES
891(1, 1, 1, 'Participated in Team Meetings', NULL, 'S', 1, 1, 5, NULL),
892(2, 1, 2, 'Was Helpful and co-operative', NULL, 'S', 1, 1, 5, NULL),
893(3, 1, 3, 'Submitted work on time', NULL, 'S', 1, 1, 5, NULL),
894(4, 1, 4, 'Produced efficient work?', NULL, 'T', 1, 0, 5, 'S'),
895(5, 1, 5, 'Contributed?', NULL, 'T', 1, 0, 5, 'L'),
896(6, 1, 6, 'Easy to work with?', NULL, 'T', 0, 0, 5, 'S');
897
898-- --------------------------------------------------------
899
900--
901-- Table structure for table `oauth_clients`
902-- This stores OAuth client credentials (AKA: consumer key and secret).
903-- Client credentails are used to identify client software.
904--
905DROP TABLE IF EXISTS `oauth_clients`;
906CREATE TABLE IF NOT EXISTS `oauth_clients` (
907  `id` int(11) NOT NULL AUTO_INCREMENT,
908  `user_id` int(11) NOT NULL,
909  `key` varchar(255) NOT NULL,
910  `secret` varchar(255) NOT NULL,
911  `comment` text DEFAULT '',
912  `enabled` tinyint(1) DEFAULT 1,
913  PRIMARY KEY (`id`),
914  FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
915) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
916
917--
918-- Dumping data for table `oauth_clients`
919--
920
921INSERT INTO `oauth_clients` (`id`, `user_id`, `key`, `secret`, `comment`, `enabled`) VALUES
922(1, 1, 'i//dt5l+kFYk/', 'M++SgeLVtL//locYEjkb/aLg2Q/', '', 1);
923
924-- --------------------------------------------------------
925
926--
927-- Table structure for table `oauth_nonces`
928-- Stores nonces to defeat replay attacks.
929--
930DROP TABLE IF EXISTS `oauth_nonces`;
931CREATE TABLE IF NOT EXISTS `oauth_nonces` (
932  `id` int(11) NOT NULL AUTO_INCREMENT,
933  `nonce` varchar(255) NOT NULL,
934  `expires` TIMESTAMP NOT NULL,
935  PRIMARY KEY (`id`)
936) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
937
938-- --------------------------------------------------------
939--
940-- Table structure for table `oauth_tokens`
941-- This stores OAuth token credentials (AKA: access token and secret).
942-- Token credentials are used to identify a user.
943--
944
945DROP TABLE IF EXISTS `oauth_tokens`;
946CREATE TABLE IF NOT EXISTS `oauth_tokens` (
947  `id` int(11) NOT NULL AUTO_INCREMENT,
948  `user_id` int(11) NOT NULL,
949  `key` varchar(255) NOT NULL,
950  `secret` varchar(255) NOT NULL,
951  `expires` date NOT NULL,
952  `comment` text DEFAULT '',
953  `enabled` tinyint(1) DEFAULT 1,
954  PRIMARY KEY (`id`),
955  FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
956) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
957
958--
959-- Dumping data for table `oauth_tokens`
960--
961
962INSERT INTO `oauth_tokens` (`id`, `user_id`, `key`, `secret`, `expires`, `comment`, `enabled`) VALUES
963(1, 1, '//qu+Bfa/gr+C//p8//', '//Bgc3Ql+QQR/O+PEi6sJZG//', '2032-08-13', '', 1);
964-- --------------------------------------------------------
965
966--
967-- Table structure for table `penalties`
968--
969
970DROP TABLE IF EXISTS `penalties`;
971CREATE TABLE IF NOT EXISTS `penalties` (
972  `id` int(11) NOT NULL AUTO_INCREMENT,
973  `event_id` int(11) DEFAULT NULL,
974  `days_late` int(11) NOT NULL,
975  `percent_penalty` int(11) NOT NULL,
976  PRIMARY KEY (`id`),
977  FOREIGN KEY (`event_id`) REFERENCES `events` (`id`) ON DELETE CASCADE
978) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=36 ;
979
980--
981-- Dumping data for table `penalties`
982--
983
984INSERT INTO penalties (id, event_id, days_late, percent_penalty) VALUES
985(1, 1, 1, 20),
986(2, 1, 2, 40),
987(3, 1, 3, 60),
988(4, 1, 4, 100),
989(5, 2, 1, 15),
990(6, 2, 2, 30),
991(7, 2, 3, 45),
992(8, 2, 4, 60),
993(9, 6, 1, 5),
994(10, 6, 2, 10);
995
996-- --------------------------------------------------------
997
998--
999-- Table structure for table `personalizes`
1000--
1001
1002DROP TABLE IF EXISTS `personalizes`;
1003CREATE TABLE IF NOT EXISTS `personalizes` (
1004  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
1005  `user_id` int(11) NOT NULL DEFAULT '0',
1006  `attribute_code` varchar(80) DEFAULT NULL,
1007  `attribute_value` varchar(80) DEFAULT NULL,
1008  `created` datetime DEFAULT NULL,
1009  `updated` datetime DEFAULT NULL,
1010  PRIMARY KEY (`id`),
1011  KEY `user_id` (`user_id`,`attribute_code`)
1012) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
1013
1014--
1015-- Dumping data for table `personalizes`
1016--
1017
1018INSERT INTO `personalizes` VALUES (1, 1, 'Course.SubMenu.EvalEvents.Show', 'true', NULL, '2006-04-03 09:08:36');
1019INSERT INTO `personalizes` VALUES (2, 1, 'Course.SubMenu.SimpleEvals.Show', 'true', NULL, '2006-04-03 09:08:42');
1020INSERT INTO `personalizes` VALUES (3, 1, 'Course.SubMenu.Student.Show', 'true', NULL, '2006-04-03 09:08:47');
1021INSERT INTO `personalizes` VALUES (4, 1, 'Course.SubMenu.Group.Show', 'none', NULL, '2006-04-03 09:08:50');
1022INSERT INTO `personalizes` VALUES (5, 1, 'Course.SubMenu.EvalResults.Show', 'true', NULL, '2006-04-03 09:10:04');
1023INSERT INTO `personalizes` VALUES (6, 1, 'Course.SubMenu.Rubric.Show', 'true', NULL, '2006-04-04 14:40:46');
1024INSERT INTO `personalizes` VALUES (7, 1, 'Course.SubMenu.TeamMaker.Show', 'true', NULL, '2006-05-03 14:26:26');
1025INSERT INTO `personalizes` VALUES (8, 1, 'Mixeval.ListMenu.Limit.Show', '10', NULL, '2006-06-21 09:06:47');
1026INSERT INTO `personalizes` VALUES (9, 1, 'Course.ListMenu.Limit.Show', '10', '2006-06-21 09:06:52', '2006-06-21 09:06:52');
1027INSERT INTO `personalizes` VALUES (10, 1, 'Event.ListMenu.Limit.Show', '10', '2006-06-21 09:07:06', '2006-06-21 09:07:06');
1028INSERT INTO `personalizes` VALUES (11, 1, 'Survey.ListMenu.Limit.Show', '10', '2006-06-21 09:43:13', '2006-06-21 09:43:13');
1029INSERT INTO `personalizes` VALUES (12, 1, 'SurveyGroupSet.List.Limit.Show', '10', '2006-06-21 12:22:19', '2006-06-21 12:22:19');
1030INSERT INTO `personalizes` VALUES (13, 1, 'User.ListMenu.Limit.Show', '10', '2006-06-21 15:11:00', '2006-06-21 15:11:00');
1031INSERT INTO `personalizes` VALUES (14, 1, 'SimpleEval.ListMenu.Limit.Show', '10', '2006-06-21 15:12:56', '2006-06-21 15:12:56');
1032INSERT INTO `personalizes` VALUES (15, 1, 'Search.ListMenu.Limit.Show', '10', '2006-06-21 15:16:35', '2006-06-21 15:16:35');
1033INSERT INTO `personalizes` VALUES (16, 1, 'SysParam.ListMenu.Limit.Show', '10', '2006-06-21 15:16:37', '2006-06-21 15:16:37');
1034
1035-- --------------------------------------------------------
1036
1037--
1038-- Table structure for table `questions`
1039--
1040
1041DROP TABLE IF EXISTS `questions`;
1042CREATE TABLE IF NOT EXISTS `questions` (
1043  `id` int(11) NOT NULL AUTO_INCREMENT,
1044  `prompt` varchar(255) NOT NULL DEFAULT '',
1045  `type` varchar(1) DEFAULT NULL,
1046  `master` varchar(3) NOT NULL DEFAULT 'yes',
1047  PRIMARY KEY (`id`)
1048) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1049
1050--
1051-- Dumping data for table `questions`
1052--
1053
1054INSERT INTO `questions` VALUES (1, 'What was your GPA last term?', 'M', 'no');
1055INSERT INTO `questions` VALUES (2, 'Do you own a laptop?', 'M', 'no');
1056INSERT INTO `questions` VALUES (3, 'Testing out MC', 'M', 'no');
1057INSERT INTO `questions` VALUES (4, 'Testing out checkboxes', 'C', 'no');
1058INSERT INTO `questions` VALUES (5, 'Testing out single line answers', 'S', 'no');
1059INSERT INTO `questions` VALUES (6, 'Testing out multi-line long answers', 'L', 'no');
1060
1061-- --------------------------------------------------------
1062
1063--
1064-- Table structure for table `responses`
1065--
1066
1067DROP TABLE IF EXISTS `responses`;
1068CREATE TABLE IF NOT EXISTS `responses` (
1069  `id` int(11) NOT NULL AUTO_INCREMENT,
1070  `question_id` int(11) NOT NULL DEFAULT '0',
1071  `response` text NOT NULL,
1072  PRIMARY KEY (`id`)
1073) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1074
1075--
1076-- Dumping data for table `responses`
1077--
1078
1079INSERT INTO `responses` VALUES (1, 1, '4+');
1080INSERT INTO `responses` VALUES (2, 1, '3-4');
1081INSERT INTO `responses` VALUES (3, 1, '2-3');
1082INSERT INTO `responses` VALUES (4, 1, '<2');
1083INSERT INTO `responses` VALUES (5, 2, 'yes');
1084INSERT INTO `responses` VALUES (6, 2, 'no');
1085INSERT INTO `responses` VALUES (7, 3, 'A');
1086INSERT INTO `responses` VALUES (8, 3, 'B');
1087INSERT INTO `responses` VALUES (9, 3, 'C');
1088INSERT INTO `responses` VALUES (10, 3, 'D');
1089INSERT INTO `responses` VALUES (11, 4, 'choose me');
1090INSERT INTO `responses` VALUES (12, 4, 'no, me');
1091INSERT INTO `responses` VALUES (13, 4, 'me please');
1092
1093-- --------------------------------------------------------
1094
1095--
1096-- Table structure for table `roles`
1097--
1098
1099DROP TABLE IF EXISTS `roles`;
1100CREATE TABLE IF NOT EXISTS `roles` (
1101  `id` int(11) NOT NULL AUTO_INCREMENT,
1102  `name` varchar(255) NOT NULL,
1103  `created` datetime NOT NULL,
1104  `modified` datetime NOT NULL,
1105  PRIMARY KEY (`id`)
1106) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
1107
1108--
1109-- Dumping data for table `roles`
1110--
1111
1112INSERT INTO `roles` (`id`, `name`, `created`, `modified`) VALUES
1113(1, 'superadmin', '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1114(2, 'admin', '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1115(3, 'instructor', '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1116(4, 'tutor', '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1117(5, 'student', '2010-10-27 16:17:29', '2010-10-27 16:17:29');
1118
1119-- --------------------------------------------------------
1120
1121--
1122-- Table structure for table `roles_users`
1123--
1124
1125DROP TABLE IF EXISTS `roles_users`;
1126CREATE TABLE IF NOT EXISTS `roles_users` (
1127  `id` int(11) NOT NULL AUTO_INCREMENT,
1128  `role_id` int(11) NOT NULL,
1129  `user_id` int(11) NOT NULL,
1130  `created` datetime NOT NULL,
1131  `modified` datetime NOT NULL,
1132  PRIMARY KEY (`id`)
1133) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1134
1135--
1136-- Dumping data for table `roles_users`
1137--
1138
1139INSERT INTO `roles_users` (`role_id`, `user_id`, `created`, `modified`) VALUES
1140(1, 1, NOW(), NOW()),
1141(3, 2, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1142(3, 3, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1143(3, 4, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1144(5, 5, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1145(5, 6, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1146(5, 7, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1147(5, 8, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1148(5, 9, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1149(5, 10, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1150(5, 11, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1151(5, 12, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1152(5, 13, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1153(5, 14, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1154(5, 15, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1155(5, 16, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1156(5, 17, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1157(5, 18, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1158(5, 19, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1159(5, 20, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1160(5, 21, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1161(5, 22, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1162(5, 23, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1163(5, 24, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1164(5, 25, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1165(5, 26, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1166(5, 27, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1167(5, 28, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1168(5, 29, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1169(5, 30, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1170(5, 31, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1171(5, 32, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1172(5, 33, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1173(2, 34, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1174(4, 35, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1175(4, 36, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1176(4, 37, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1177(2, 38, '2010-10-27 16:17:29', '2010-10-27 16:17:29');
1178
1179-- --------------------------------------------------------
1180
1181--
1182-- Table structure for table `rubrics`
1183--
1184
1185DROP TABLE IF EXISTS `rubrics`;
1186CREATE TABLE IF NOT EXISTS `rubrics` (
1187  `id` int(11) NOT NULL AUTO_INCREMENT,
1188  `name` varchar(80) NOT NULL DEFAULT '',
1189  `zero_mark` tinyint(1) NOT NULL DEFAULT '0',
1190  `lom_max` int(11) DEFAULT NULL,
1191  `criteria` int(11) DEFAULT NULL,
1192  `availability` varchar(10) NOT NULL DEFAULT 'public',
1193  `template` varchar(20) NOT NULL DEFAULT 'horizontal',
1194  `creator_id` int(11) NOT NULL DEFAULT '0',
1195  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1196  `updater_id` int(11) DEFAULT NULL,
1197  `modified` datetime DEFAULT NULL,
1198  PRIMARY KEY (`id`)
1199) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1200
1201--
1202-- Dumping data for table `rubrics`
1203--
1204
1205INSERT INTO `rubrics` VALUES (1, 'Term Report Evaluation', 0, 5, 3, 'public', 'horizontal', 1, '2006-06-20 15:21:50', NULL, '2006-06-20 15:21:50');
1206
1207-- --------------------------------------------------------
1208
1209--
1210-- Table structure for table `rubrics_criteria_comments`
1211--
1212
1213DROP TABLE IF EXISTS `rubrics_criteria_comments`;
1214CREATE TABLE IF NOT EXISTS `rubrics_criteria_comments` (
1215  `id` int(11) NOT NULL AUTO_INCREMENT,
1216  `criteria_id` int(11) NOT NULL,
1217  `rubrics_loms_id` int(11) NOT NULL,
1218  `criteria_comment` varchar(255) DEFAULT NULL,
1219  PRIMARY KEY (`id`),
1220  KEY `criteria_id` (`criteria_id`),
1221  KEY `rubrics_loms_id` (`rubrics_loms_id`)
1222) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1223
1224--
1225-- Dumping data for table `rubrics_criteria_comments`
1226--
1227
1228INSERT INTO `rubrics_criteria_comments` VALUES (1, 1, 1, "No participation.");
1229INSERT INTO `rubrics_criteria_comments` VALUES (2, 1, 2, "Little participation.");
1230INSERT INTO `rubrics_criteria_comments` VALUES (3, 1, 3, "Some participation.");
1231INSERT INTO `rubrics_criteria_comments` VALUES (4, 1, 4, "Good participation.");
1232INSERT INTO `rubrics_criteria_comments` VALUES (5, 1, 5, "Great participation.");
1233INSERT INTO `rubrics_criteria_comments` VALUES (6, 2, 1, NULL);
1234INSERT INTO `rubrics_criteria_comments` VALUES (7, 2, 2, NULL);
1235INSERT INTO `rubrics_criteria_comments` VALUES (8, 2, 3, NULL);
1236INSERT INTO `rubrics_criteria_comments` VALUES (9, 2, 4, NULL);
1237INSERT INTO `rubrics_criteria_comments` VALUES (10, 2, 5, NULL);
1238INSERT INTO `rubrics_criteria_comments` VALUES (11, 3, 1, NULL);
1239INSERT INTO `rubrics_criteria_comments` VALUES (12, 3, 2, NULL);
1240INSERT INTO `rubrics_criteria_comments` VALUES (13, 3, 3, NULL);
1241INSERT INTO `rubrics_criteria_comments` VALUES (14, 3, 4, NULL);
1242INSERT INTO `rubrics_criteria_comments` VALUES (15, 3, 5, NULL);
1243
1244-- --------------------------------------------------------
1245
1246--
1247-- Table structure for table `rubrics_criterias`
1248--
1249
1250DROP TABLE IF EXISTS `rubrics_criterias`;
1251CREATE TABLE IF NOT EXISTS `rubrics_criterias` (
1252  `id` int(11) NOT NULL AUTO_INCREMENT,
1253  `rubric_id` int(11) NOT NULL DEFAULT '0',
1254  `criteria_num` int(11) NOT NULL DEFAULT '999',
1255  `criteria` varchar(255) DEFAULT NULL,
1256  `multiplier` int(11) NOT NULL DEFAULT '0',
1257  PRIMARY KEY (`id`)
1258) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1259
1260--
1261-- Dumping data for table `rubrics_criterias`
1262--
1263
1264INSERT INTO `rubrics_criterias` VALUES (1, 1, 1, 'Participated in Team Meetings', 5);
1265INSERT INTO `rubrics_criterias` VALUES (2, 1, 2, 'Was Helpful and Co-operative', 5);
1266INSERT INTO `rubrics_criterias` VALUES (3, 1, 3, 'Submitted Work on Time', 5);
1267
1268-- --------------------------------------------------------
1269
1270--
1271-- Table structure for table `rubrics_loms`
1272--
1273
1274DROP TABLE IF EXISTS `rubrics_loms`;
1275CREATE TABLE IF NOT EXISTS `rubrics_loms` (
1276  `id` int(11) NOT NULL AUTO_INCREMENT,
1277  `rubric_id` int(11) NOT NULL DEFAULT '0',
1278  `lom_num` int(11) NOT NULL DEFAULT '999',
1279  `lom_comment` varchar(255) DEFAULT NULL,
1280  PRIMARY KEY (`id`)
1281) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1282
1283--
1284-- Dumping data for table `rubrics_loms`
1285--
1286
1287INSERT INTO `rubrics_loms` VALUES (1, 1, 1, 'Poor');
1288INSERT INTO `rubrics_loms` VALUES (2, 1, 2, 'Below Average');
1289INSERT INTO `rubrics_loms` VALUES (3, 1, 3, 'Average');
1290INSERT INTO `rubrics_loms` VALUES (4, 1, 4, 'Above Average');
1291INSERT INTO `rubrics_loms` VALUES (5, 1, 5, 'Excellent');
1292
1293-- --------------------------------------------------------
1294
1295--
1296-- Table structure for table `simple_evaluations`
1297--
1298
1299DROP TABLE IF EXISTS `simple_evaluations`;
1300CREATE TABLE IF NOT EXISTS `simple_evaluations` (
1301  `id` int(11) NOT NULL AUTO_INCREMENT,
1302  `name` varchar(50) NOT NULL DEFAULT '',
1303  `description` text NOT NULL,
1304  `point_per_member` int(10) NOT NULL DEFAULT '0',
1305  `record_status` char(1) NOT NULL DEFAULT 'A',
1306  `availability` varchar(10) NOT NULL DEFAULT 'public',
1307  `creator_id` int(11) NOT NULL DEFAULT '0',
1308  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1309  `updater_id` int(11) DEFAULT NULL,
1310  `modified` datetime DEFAULT NULL,
1311  PRIMARY KEY (`id`)
1312) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1313
1314--
1315-- Dumping data for table `simple_evaluations`
1316--
1317
1318INSERT INTO `simple_evaluations` VALUES (1, 'Module 1 Project Evaluation', '', 100, 'A', 'public', 1, '2006-06-20 15:17:47', NULL, '2006-06-20 15:17:47');
1319
1320-- --------------------------------------------------------
1321
1322--
1323-- Table structure for table `survey_group_members`
1324--
1325
1326DROP TABLE IF EXISTS `survey_group_members`;
1327CREATE TABLE IF NOT EXISTS `survey_group_members` (
1328  `id` int(11) NOT NULL AUTO_INCREMENT,
1329  `group_set_id` int(11) DEFAULT '0',
1330  `group_id` int(11) NOT NULL DEFAULT '0',
1331  `user_id` int(11) NOT NULL DEFAULT '0',
1332  PRIMARY KEY (`id`)
1333) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1334
1335--
1336-- Dumping data for table `survey_group_members`
1337--
1338
1339INSERT INTO `survey_group_members` VALUES (25, 3, 5, 17);
1340INSERT INTO `survey_group_members` VALUES (26, 3, 5, 21);
1341INSERT INTO `survey_group_members` VALUES (27, 3, 5, 15);
1342INSERT INTO `survey_group_members` VALUES (28, 3, 5, 19);
1343INSERT INTO `survey_group_members` VALUES (29, 3, 6, 6);
1344INSERT INTO `survey_group_members` VALUES (30, 3, 6, 32);
1345INSERT INTO `survey_group_members` VALUES (31, 3, 6, 26);
1346INSERT INTO `survey_group_members` VALUES (32, 3, 6, 13);
1347INSERT INTO `survey_group_members` VALUES (33, 3, 7, 7);
1348INSERT INTO `survey_group_members` VALUES (34, 3, 7, 28);
1349INSERT INTO `survey_group_members` VALUES (35, 3, 7, 5);
1350INSERT INTO `survey_group_members` VALUES (36, 3, 7, 33);
1351
1352-- --------------------------------------------------------
1353
1354--
1355-- Table structure for table `survey_group_sets`
1356--
1357
1358DROP TABLE IF EXISTS `survey_group_sets`;
1359CREATE TABLE IF NOT EXISTS `survey_group_sets` (
1360  `id` int(11) NOT NULL AUTO_INCREMENT,
1361  `survey_id` int(11) NOT NULL DEFAULT '0',
1362  `set_description` text NOT NULL,
1363  `num_groups` int(11) NOT NULL DEFAULT '0',
1364  `date` int(11) NOT NULL DEFAULT '0',
1365  `released` int(1) NOT NULL DEFAULT '0',
1366  PRIMARY KEY (`id`),
1367  KEY `survey_id` (`survey_id`)
1368) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1369
1370--
1371-- Dumping data for table `survey_group_sets`
1372--
1373
1374INSERT INTO `survey_group_sets` VALUES (3, 1, 'test groupset', 3, 1150923956, 0);
1375
1376-- --------------------------------------------------------
1377
1378--
1379-- Table structure for table `survey_groups`
1380--
1381
1382DROP TABLE IF EXISTS `survey_groups`;
1383CREATE TABLE IF NOT EXISTS `survey_groups` (
1384  `id` int(11) NOT NULL AUTO_INCREMENT,
1385  `group_set_id` int(11) NOT NULL DEFAULT '0',
1386  `group_number` int(11) NOT NULL DEFAULT '0',
1387  PRIMARY KEY (`id`)
1388) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1389
1390--
1391-- Dumping data for table `survey_groups`
1392--
1393
1394INSERT INTO `survey_groups` VALUES (5, 3, 1);
1395INSERT INTO `survey_groups` VALUES (6, 3, 2);
1396INSERT INTO `survey_groups` VALUES (7, 3, 3);
1397
1398-- --------------------------------------------------------
1399
1400--
1401-- Table structure for table `survey_inputs`
1402--
1403
1404DROP TABLE IF EXISTS `survey_inputs`;
1405CREATE TABLE IF NOT EXISTS `survey_inputs` (
1406  `id` int(11) NOT NULL AUTO_INCREMENT,
1407  `survey_id` int(11) NOT NULL DEFAULT '0',
1408  `user_id` int(11) NOT NULL DEFAULT '0',
1409  `question_id` int(11) NOT NULL DEFAULT '0',
1410  `sub_id` int(11) DEFAULT NULL,
1411  `chkbx_id` int(11) DEFAULT NULL,
1412  `response_text` text,
1413  `response_id` int(11) DEFAULT NULL,
1414  PRIMARY KEY (`id`)
1415) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1416
1417--
1418-- Dumping data for table `survey_inputs`
1419--
1420
1421INSERT INTO survey_inputs (id, survey_id, user_id, question_id, sub_id, chkbx_id, response_text, response_id) VALUES
1422(1, 1, 7, 1, NULL, NULL, '4+', 1),
1423(2, 1, 7, 2, NULL, NULL, 'yes', 5),
1424(3, 1, 31, 1, NULL, NULL, '3-4', 2),
1425(4, 1, 31, 2, NULL, NULL, 'no', 6),
1426(5, 2, 17, 3, NULL, NULL, 'B', 8),
1427(6, 2, 17, 4, NULL, 0, 'choose me', 11),
1428(7, 2, 17, 4, NULL, 1, 'no, me', 12),
1429(8, 2, 17, 5, NULL, NULL, 'single line rah rah', 0),
1430(9, 2, 17, 6, NULL, NULL, 'long answer what what', 0);
1431
1432-- --------------------------------------------------------
1433
1434--
1435-- Table structure for table `survey_questions`
1436--
1437
1438DROP TABLE IF EXISTS `survey_questions`;
1439CREATE TABLE IF NOT EXISTS `survey_questions` (
1440  `id` int(11) NOT NULL AUTO_INCREMENT,
1441  `survey_id` int(11) NOT NULL DEFAULT '0',
1442  `number` int(11) NOT NULL DEFAULT '9999',
1443  `question_id` int(11) NOT NULL DEFAULT '0',
1444  PRIMARY KEY (`id`),
1445  KEY `question_id` (`question_id`),
1446  KEY `survey_id` (`survey_id`)
1447) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1448
1449--
1450-- Dumping data for table `survey_questions`
1451--
1452
1453INSERT INTO survey_questions (id, survey_id, number, question_id) VALUES
1454(1, 1, 1, 1),
1455(2, 1, 2, 2),
1456(3, 2, 1, 3),
1457(4, 2, 2, 4),
1458(5, 2, 3, 5),
1459(6, 2, 4, 6);
1460
1461-- --------------------------------------------------------
1462
1463--
1464-- Table structure for table `surveys`
1465--
1466
1467DROP TABLE IF EXISTS `surveys`;
1468CREATE TABLE IF NOT EXISTS `surveys` (
1469  `id` int(11) NOT NULL AUTO_INCREMENT,
1470  `course_id` int(11) NOT NULL DEFAULT '0',
1471  `user_id` int(11) NOT NULL DEFAULT '1',
1472  `name` varchar(255) NOT NULL,
1473  `due_date` datetime DEFAULT NULL,
1474  `release_date_begin` datetime DEFAULT NULL,
1475  `release_date_end` datetime DEFAULT NULL,
1476  `released` tinyint(1) NOT NULL DEFAULT '0',
1477  `creator_id` int(11) NOT NULL DEFAULT '0',
1478  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1479  `updater_id` int(11) DEFAULT NULL,
1480  `modified` datetime DEFAULT NULL,
1481  PRIMARY KEY (`id`)
1482) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1483
1484--
1485-- Dumping data for table `surveys`
1486--
1487
1488INSERT INTO surveys (id, course_id, user_id, name, due_date, release_date_begin, release_date_end, released, creator_id, created, updater_id, modified) VALUES
1489(1, 1, 1, 'Team Creation Survey', '2012-07-31 11:20:00', '2012-07-01 11:20:00', '2013-12-31 11:20:00', 0, 2, '2012-07-13 11:18:56', 2, '2012-07-13 11:18:56'),
1490(2, 1, 1, 'Survey, all Q types', '2012-07-31 11:20:00', '2012-07-01 11:20:00', '2013-12-31 11:20:00', 0, 1, '2012-07-13 11:18:56', 1, '2012-07-13 11:18:56');
1491-- --------------------------------------------------------
1492
1493--
1494-- Table structure for table `sys_parameters`
1495--
1496
1497DROP TABLE IF EXISTS `sys_parameters`;
1498CREATE TABLE IF NOT EXISTS `sys_parameters` (
1499  `id` int(11) NOT NULL AUTO_INCREMENT,
1500  `parameter_code` varchar(80) NOT NULL DEFAULT '',
1501  `parameter_value` text,
1502  `parameter_type` char(1) NOT NULL DEFAULT '',
1503  `description` varchar(255) DEFAULT NULL,
1504  `record_status` char(1) NOT NULL DEFAULT 'A',
1505  `creator_id` int(11) NOT NULL DEFAULT '0',
1506  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1507  `updater_id` int(11) DEFAULT NULL,
1508  `modified` datetime DEFAULT NULL,
1509  PRIMARY KEY (`id`),
1510  UNIQUE KEY `parameter_code` (`parameter_code`)
1511) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 ;
1512
1513--
1514-- Dumping data for table `sys_parameters`
1515--
1516
1517INSERT INTO `sys_parameters` (`id`, `parameter_code`, `parameter_value`, `parameter_type`, `description`, `record_status`, `creator_id`, `created`, `updater_id`, `modified`) VALUES
1518(1, 'system.soft_delete_enable', 'true', 'B', 'Whether soft deletion of records is enabled.', 'A', 0, NOW(), 0, NOW()),
1519(2, 'system.debug_mode', '0', 'I', 'Debug Mode of the system', 'A', 0, NOW(), NULL, NOW()),
1520(3, 'system.debug_verbosity', '1', 'I', NULL, 'A', 0, NOW(), NULL, NOW()),
1521(6, 'system.super_admin', 'root', 'S', NULL, 'A', 0, NOW(), NULL, NOW()),
1522(7, 'system.upload_dir', 'uploads/', 'S', NULL, 'A', 0, NOW(), NULL, NOW()),
1523(9, 'display.page_title', 'iPeer v2 with TeamMaker', 'S', 'Page title show in HTML.', 'A', 0, NOW(), 0, NOW()),
1524(10, 'display.logo_file', 'LayoutLogoDefault.gif', 'S', 'Logo image name.', 'A', 0, NOW(), 0, NOW()),
1525(11, 'display.login_logo_file', 'LayoutLoginLogoDefault.gif', 'S', 'Login Image File Name.', 'A', 0, NOW(), 0, NOW()),
1526(13, 'custom.login_control', 'ipeer', 'S', 'The login control for iPeer: ipeer; CWL: UBC_CWL', 'A', 0, NOW(), NULL, NOW()),
1527(14, 'custom.login_page_pathname', 'custom_ubc_cwl_login', 'S', 'The file pathname for the custom login page; CWL:custom_ubc_cwl_login', 'A', 0, NOW(), NULL, NOW()),
1528(15, 'system.admin_email', 'Please enter the iPeer administrator\\''s email address.', 'S', NULL, 'A', 0, NOW(), NULL, NOW()),
1529(16, 'system.password_reset_mail', 'Dear <user>,<br> Your password has been reset to <newpassword>. Please use this to log in from now on. <br><br>iPeer Administrator', 'S', NULL, 'A', 0, NOW(), NULL, NOW()),
1530(17, 'system.password_reset_emailsubject', 'iPeer Password Reset Notification', 'S', NULL, 'A', 0, NOW(), NULL, NOW()),
1531(18, 'display.date_format', 'D, M j, Y g:i a', 'S', 'date format preference', 'A', 0, NOW(), NULL, NOW()),
1532(20, 'database.version', '4', 'I', 'database version', 'A', 0, NOW(), NULL, NOW()),
1533(21, 'email.port', '25', 'S', 'port number for email smtp option', 'A', '0', NOW(), NULL , NOW()),
1534(22, 'email.host', 'localhost', 'S', 'host address for email smtp option', 'A', '0', NOW(), NULL , NOW()),
1535(23, 'email.username', '', 'S', 'username for email smtp option', 'A', '0', NOW(), NULL , NOW()),
1536(24, 'email.password', '', 'S', 'password for email smtp option', 'A', '0', NOW(), NULL , NOW()),
1537(25, 'display.contact_info', 'noreply@ipeer.ctlt.ubc.ca', 'S', 'Contact Info', 'A', 0, NOW(), 0, NOW());
1538
1539-- --------------------------------------------------------
1540
1541--
1542-- Table structure for table `user_courses`
1543--
1544
1545DROP TABLE IF EXISTS `user_courses`;
1546CREATE TABLE IF NOT EXISTS `user_courses` (
1547  `id` int(11) NOT NULL AUTO_INCREMENT,
1548  `user_id` int(11) NOT NULL DEFAULT '0',
1549  `course_id` int(11) NOT NULL DEFAULT '0',
1550  `access_right` varchar(1) NOT NULL DEFAULT 'O',
1551  `record_status` varchar(1) NOT NULL DEFAULT 'A',
1552  `creator_id` int(11) NOT NULL DEFAULT '0',
1553  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1554  `updater_id` int(11) DEFAULT NULL,
1555  `modified` datetime DEFAULT NULL,
1556  PRIMARY KEY (`id`),
1557  UNIQUE no_duplicates (`course_id`,`user_id`),
1558  FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
1559  FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE
1560) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1561
1562--
1563-- Dumping data for table `user_courses`
1564--
1565
1566INSERT INTO `user_courses` VALUES (1, 2, 1, 'A', 'A', 0, '2006-06-20 14:14:45', NULL, '2006-06-20 14:14:45');
1567INSERT INTO `user_courses` VALUES (2, 3, 2, 'A', 'A', 0, '2006-06-20 14:39:31', NULL, '2006-06-20 14:39:31');
1568INSERT INTO `user_courses` VALUES (3, 4, 2, 'A', 'A', 0, '2006-06-20 14:39:31', NULL, '2006-06-20 14:39:31');
1569INSERT INTO `user_courses` VALUES (4, 4, 3, 'A', 'A', 0, '2006-06-20 14:39:31', NULL, '2006-06-20 14:39:31');
1570
1571-- --------------------------------------------------------
1572
1573--
1574-- Table structure for table `user_enrols`
1575--
1576
1577DROP TABLE IF EXISTS `user_enrols`;
1578CREATE TABLE IF NOT EXISTS `user_enrols` (
1579  `id` int(11) NOT NULL AUTO_INCREMENT,
1580  `course_id` int(11) NOT NULL DEFAULT '0',
1581  `user_id` int(11) NOT NULL DEFAULT '0',
1582  `record_status` varchar(1) NOT NULL DEFAULT 'A',
1583  `creator_id` int(11) NOT NULL DEFAULT '0',
1584  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1585  `updater_id` int(11) DEFAULT NULL,
1586  `modified` datetime DEFAULT NULL,
1587  PRIMARY KEY (`id`),
1588  UNIQUE no_duplicates (`course_id`,`user_id`),
1589  FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
1590  FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE
1591) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1592
1593--
1594-- Dumping data for table `user_enrols`
1595--
1596
1597INSERT INTO `user_enrols` VALUES (1, 1, 5, 'A', 0, '2006-06-20 14:19:18', NULL, '2006-06-20 14:19:18');
1598INSERT INTO `user_enrols` VALUES (2, 1, 6, 'A', 0, '2006-06-20 14:26:59', NULL, '2006-06-20 14:26:59');
1599INSERT INTO `user_enrols` VALUES (3, 1, 7, 'A', 0, '2006-06-20 14:27:24', NULL, '2006-06-20 14:27:24');
1600INSERT INTO `user_enrols` VALUES (5, 2, 9, 'A', 0, '2006-06-20 14:28:08', NULL, '2006-06-20 14:28:08');
1601INSERT INTO `user_enrols` VALUES (6, 2, 10, 'A', 0, '2006-06-20 14:28:29', NULL, '2006-06-20 14:28:29');
1602INSERT INTO `user_enrols` VALUES (7, 2, 11, 'A', 0, '2006-06-20 14:28:49', NULL, '2006-06-20 14:28:49');
1603INSERT INTO `user_enrols` VALUES (8, 2, 12, 'A', 0, '2006-06-20 14:29:07', NULL, '2006-06-20 14:29:07');
1604INSERT INTO `user_enrols` VALUES (9, 1, 13, 'A', 0, '2006-06-20 14:31:17', NULL, '2006-06-20 14:31:17');
1605INSERT INTO `user_enrols` VALUES (11, 1, 15, 'A', 0, '2006-06-20 15:00:35', NULL, '2006-06-20 15:00:35');
1606INSERT INTO `user_enrols` VALUES (12, 2, 16, 'A', 0, '2006-06-20 15:01:09', NULL, '2006-06-20 15:01:09');
1607INSERT INTO `user_enrols` VALUES (13, 1, 17, 'A', 0, '2006-06-20 15:01:24', NULL, '2006-06-20 15:01:24');
1608INSERT INTO `user_enrols` VALUES (14, 2, 18, 'A', 0, '2006-06-20 15:01:52', NULL, '2006-06-20 15:01:52');
1609INSERT INTO `user_enrols` VALUES (15, 1, 19, 'A', 0, '2006-06-20 15:02:20', NULL, '2006-06-20 15:02:20');
1610INSERT INTO `user_enrols` VALUES (16, 2, 20, 'A', 0, '2006-06-20 15:03:27', NULL, '2006-06-20 15:03:27');
1611INSERT INTO `user_enrols` VALUES (17, 1, 21, 'A', 0, '2006-06-20 15:03:47', NULL, '2006-06-20 15:03:47');
1612INSERT INTO `user_enrols` VALUES (18, 2, 22, 'A', 0, '2006-06-20 15:04:22', NULL, '2006-06-20 15:04:22');
1613INSERT INTO `user_enrols` VALUES (19, 2, 23, 'A', 0, '2006-06-20 15:05:55', NULL, '2006-06-20 15:05:55');
1614INSERT INTO `user_enrols` VALUES (20, 2, 24, 'A', 0, '2006-06-20 15:06:20', NULL, '2006-06-20 15:06:20');
1615INSERT INTO `user_enrols` VALUES (21, 2, 25, 'A', 0, '2006-06-20 15:06:46', NULL, '2006-06-20 15:06:46');
1616INSERT INTO `user_enrols` VALUES (22, 1, 26, 'A', 0, '2006-06-20 15:07:01', NULL, '2006-06-20 15:07:01');
1617INSERT INTO `user_enrols` VALUES (23, 2, 27, 'A', 0, '2006-06-20 15:07:37', NULL, '2006-06-20 15:07:37');
1618INSERT INTO `user_enrols` VALUES (24, 1, 28, 'A', 0, '2006-06-20 15:08:04', NULL, '2006-06-20 15:08:04');
1619INSERT INTO `user_enrols` VALUES (25, 2, 29, 'A', 0, '2006-06-20 15:08:31', NULL, '2006-06-20 15:08:31');
1620INSERT INTO `user_enrols` VALUES (26, 2, 30, 'A', 0, '2006-06-20 15:08:47', NULL, '2006-06-20 15:08:47');
1621INSERT INTO `user_enrols` VALUES (27, 1, 31, 'A', 0, '2006-06-20 15:10:16', NULL, '2006-06-20 15:10:16');
1622INSERT INTO `user_enrols` VALUES (28, 1, 32, 'A', 0, '2006-06-20 15:10:32', NULL, '2006-06-20 15:10:32');
1623INSERT INTO `user_enrols` VALUES (29, 1, 33, 'A', 0, '2006-06-21 08:44:09', NULL, '2006-06-21 08:44:09');
1624INSERT INTO `user_enrols` VALUES (30, 2, 7, 'A', 0, '2006-06-21 08:44:09', NULL, '2006-06-21 08:44:09');
1625INSERT INTO `user_enrols` VALUES (31, 3, 33, 'A', 0, '2006-06-21 08:44:09', NULL, '2006-06-21 08:44:09');
1626INSERT INTO `user_enrols` VALUES (32, 3, 8, 'A', 0, '2006-06-21 08:44:09', NULL, '2006-06-21 08:44:09');
1627
1628-- --------------------------------------------------------
1629
1630--
1631-- Table structure for table `user_faculties`
1632--
1633
1634DROP TABLE IF EXISTS `user_faculties`;
1635CREATE TABLE `user_faculties` (
1636  `id` int NOT NULL auto_increment,
1637  `user_id` int NOT NULL,
1638  `faculty_id` int NOT NULL,
1639  FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
1640  FOREIGN KEY (`faculty_id`) REFERENCES `faculties` (`id`) ON DELETE CASCADE,
1641  PRIMARY KEY  (`id`)
1642) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1643
1644--
1645-- Dumping data for table `user_faculties`
1646--
1647
1648INSERT INTO `user_faculties` (`id`, `user_id`, `faculty_id`) VALUES
1649(1, 34, 1),
1650(2, 1, 1),
1651(3, 1, 2),
1652(4, 38, 2);
1653
1654-- --------------------------------------------------------
1655
1656--
1657-- Table structure for table `user_tutors`
1658--
1659
1660DROP TABLE IF EXISTS `user_tutors`;
1661CREATE TABLE IF NOT EXISTS `user_tutors` (
1662  `id` int(11) NOT NULL AUTO_INCREMENT,
1663  `user_id` int(11) NOT NULL DEFAULT '0',
1664  `course_id` int(11) NOT NULL DEFAULT '0',
1665  `creator_id` int(11) NOT NULL DEFAULT '0',
1666  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1667  `updater_id` int(11) DEFAULT NULL,
1668  `modified` datetime DEFAULT NULL,
1669  PRIMARY KEY (`id`),
1670  UNIQUE no_duplicates (`course_id`,`user_id`),
1671  FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
1672  FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE
1673) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1674
1675--
1676-- Dumping data for table `user_tutors`
1677--
1678
1679INSERT INTO user_tutors (id, user_id, course_id, creator_id, created, updater_id, modified) VALUES
1680(1, 35, 1, 0, '0000-00-00 00:00:00', NULL, '2012-07-13 09:45:57'),
1681(2, 36, 1, 0, '0000-00-00 00:00:00', NULL, '2012-07-13 09:48:16'),
1682(3, 37, 2, 0, '0000-00-00 00:00:00', NULL, '2012-07-13 09:48:24'),
1683(4, 37, 3, 0, '0000-00-00 00:00:00', NULL, '2012-07-13 09:48:24');
1684
1685SET foreign_key_checks = 1;
Note: See TracBrowser for help on using the repository browser.