source: iPeer/app/config/sql/ipeer_samples_data.sql @ 742d257

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

Add local vocabulary class for translation

Some time the displayed word may not fit the application. Added a local
vocabulary that allow user to set the word to what they want. e.g. at
UBC, the administration is not deep down to department level. So
changing department text to faculty and creating one to one
faculty-department is easier for administration.

  • Property mode set to 100644
File size: 93.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` (`id`, `parent_id`, `model`, `foreign_key`, `alias`, `lft`, `rght`) VALUES
40(1, NULL, NULL, NULL, 'adminpage', 1, 2),
41(2, NULL, NULL, NULL, 'controllers', 3, 574),
42(3, 2, NULL, NULL, 'Pages', 4, 17),
43(4, 3, NULL, NULL, 'display', 5, 6),
44(5, 3, NULL, NULL, 'add', 7, 8),
45(6, 3, NULL, NULL, 'edit', 9, 10),
46(7, 3, NULL, NULL, 'index', 11, 12),
47(8, 3, NULL, NULL, 'view', 13, 14),
48(9, 3, NULL, NULL, 'delete', 15, 16),
49(10, 2, NULL, NULL, 'Evaltools', 18, 31),
50(11, 10, NULL, NULL, 'index', 19, 20),
51(12, 10, NULL, NULL, 'showAll', 21, 22),
52(13, 10, NULL, NULL, 'add', 23, 24),
53(14, 10, NULL, NULL, 'edit', 25, 26),
54(15, 10, NULL, NULL, 'view', 27, 28),
55(16, 10, NULL, NULL, 'delete', 29, 30),
56(17, 2, NULL, NULL, 'Emailer', 32, 59),
57(18, 17, NULL, NULL, 'setUpAjaxList', 33, 34),
58(19, 17, NULL, NULL, 'ajaxList', 35, 36),
59(20, 17, NULL, NULL, 'index', 37, 38),
60(21, 17, NULL, NULL, 'write', 39, 40),
61(22, 17, NULL, NULL, 'cancel', 41, 42),
62(23, 17, NULL, NULL, 'view', 43, 44),
63(24, 17, NULL, NULL, 'addRecipient', 45, 46),
64(25, 17, NULL, NULL, 'deleteRecipient', 47, 48),
65(26, 17, NULL, NULL, 'getRecipient', 49, 50),
66(27, 17, NULL, NULL, 'searchByUserId', 51, 52),
67(28, 17, NULL, NULL, 'add', 53, 54),
68(29, 17, NULL, NULL, 'edit', 55, 56),
69(30, 17, NULL, NULL, 'delete', 57, 58),
70(31, 2, NULL, NULL, 'Users', 60, 87),
71(32, 31, NULL, NULL, 'ajaxList', 61, 62),
72(33, 31, NULL, NULL, 'index', 63, 64),
73(34, 31, NULL, NULL, 'goToClassList', 65, 66),
74(35, 31, NULL, NULL, 'determineIfStudentFromThisData', 67, 68),
75(36, 31, NULL, NULL, 'view', 69, 70),
76(37, 31, NULL, NULL, 'add', 71, 72),
77(38, 31, NULL, NULL, 'edit', 73, 74),
78(39, 31, NULL, NULL, 'editProfile', 75, 76),
79(40, 31, NULL, NULL, 'delete', 77, 78),
80(41, 31, NULL, NULL, 'checkDuplicateName', 79, 80),
81(42, 31, NULL, NULL, 'resetPassword', 81, 82),
82(43, 31, NULL, NULL, 'import', 83, 84),
83(44, 31, NULL, NULL, 'update', 85, 86),
84(45, 2, NULL, NULL, 'Mixevals', 88, 109),
85(46, 45, NULL, NULL, 'setUpAjaxList', 89, 90),
86(47, 45, NULL, NULL, 'index', 91, 92),
87(48, 45, NULL, NULL, 'ajaxList', 93, 94),
88(49, 45, NULL, NULL, 'view', 95, 96),
89(50, 45, NULL, NULL, 'add', 97, 98),
90(51, 45, NULL, NULL, 'deleteQuestion', 99, 100),
91(52, 45, NULL, NULL, 'deleteDescriptor', 101, 102),
92(53, 45, NULL, NULL, 'edit', 103, 104),
93(54, 45, NULL, NULL, 'copy', 105, 106),
94(55, 45, NULL, NULL, 'delete', 107, 108),
95(56, 2, NULL, NULL, 'V1', 110, 145),
96(57, 56, NULL, NULL, 'oauth', 111, 112),
97(58, 56, NULL, NULL, 'oauth_error', 113, 114),
98(59, 56, NULL, NULL, 'users', 115, 116),
99(60, 56, NULL, NULL, 'courses', 117, 118),
100(61, 56, NULL, NULL, 'groups', 119, 120),
101(62, 56, NULL, NULL, 'groupMembers', 121, 122),
102(63, 56, NULL, NULL, 'events', 123, 124),
103(64, 56, NULL, NULL, 'grades', 125, 126),
104(65, 56, NULL, NULL, 'departments', 127, 128),
105(66, 56, NULL, NULL, 'courseDepartments', 129, 130),
106(67, 56, NULL, NULL, 'userEvents', 131, 132),
107(68, 56, NULL, NULL, 'enrolment', 133, 134),
108(69, 56, NULL, NULL, 'add', 135, 136),
109(70, 56, NULL, NULL, 'edit', 137, 138),
110(71, 56, NULL, NULL, 'index', 139, 140),
111(72, 56, NULL, NULL, 'view', 141, 142),
112(73, 56, NULL, NULL, 'delete', 143, 144),
113(74, 2, NULL, NULL, 'Simpleevaluations', 146, 165),
114(75, 74, NULL, NULL, 'postProcess', 147, 148),
115(76, 74, NULL, NULL, 'setUpAjaxList', 149, 150),
116(77, 74, NULL, NULL, 'index', 151, 152),
117(78, 74, NULL, NULL, 'ajaxList', 153, 154),
118(79, 74, NULL, NULL, 'view', 155, 156),
119(80, 74, NULL, NULL, 'add', 157, 158),
120(81, 74, NULL, NULL, 'edit', 159, 160),
121(82, 74, NULL, NULL, 'copy', 161, 162),
122(83, 74, NULL, NULL, 'delete', 163, 164),
123(84, 2, NULL, NULL, 'Penalty', 166, 179),
124(85, 84, NULL, NULL, 'save', 167, 168),
125(86, 84, NULL, NULL, 'add', 169, 170),
126(87, 84, NULL, NULL, 'edit', 171, 172),
127(88, 84, NULL, NULL, 'index', 173, 174),
128(89, 84, NULL, NULL, 'view', 175, 176),
129(90, 84, NULL, NULL, 'delete', 177, 178),
130(91, 2, NULL, NULL, 'Home', 180, 191),
131(92, 91, NULL, NULL, 'index', 181, 182),
132(93, 91, NULL, NULL, 'add', 183, 184),
133(94, 91, NULL, NULL, 'edit', 185, 186),
134(95, 91, NULL, NULL, 'view', 187, 188),
135(96, 91, NULL, NULL, 'delete', 189, 190),
136(97, 2, NULL, NULL, 'Oauthclients', 192, 203),
137(98, 97, NULL, NULL, 'index', 193, 194),
138(99, 97, NULL, NULL, 'add', 195, 196),
139(100, 97, NULL, NULL, 'edit', 197, 198),
140(101, 97, NULL, NULL, 'delete', 199, 200),
141(102, 97, NULL, NULL, 'view', 201, 202),
142(103, 2, NULL, NULL, 'Surveys', 204, 231),
143(104, 103, NULL, NULL, 'setUpAjaxList', 205, 206),
144(105, 103, NULL, NULL, 'index', 207, 208),
145(106, 103, NULL, NULL, 'ajaxList', 209, 210),
146(107, 103, NULL, NULL, 'view', 211, 212),
147(108, 103, NULL, NULL, 'add', 213, 214),
148(109, 103, NULL, NULL, 'edit', 215, 216),
149(110, 103, NULL, NULL, 'copy', 217, 218),
150(111, 103, NULL, NULL, 'delete', 219, 220),
151(112, 103, NULL, NULL, 'questionsSummary', 221, 222),
152(113, 103, NULL, NULL, 'moveQuestion', 223, 224),
153(114, 103, NULL, NULL, 'removeQuestion', 225, 226),
154(115, 103, NULL, NULL, 'addQuestion', 227, 228),
155(116, 103, NULL, NULL, 'editQuestion', 229, 230),
156(117, 2, NULL, NULL, 'Evaluations', 232, 283),
157(118, 117, NULL, NULL, 'setUpAjaxList', 233, 234),
158(119, 117, NULL, NULL, 'ajaxList', 235, 236),
159(120, 117, NULL, NULL, 'view', 237, 238),
160(121, 117, NULL, NULL, 'index', 239, 240),
161(122, 117, NULL, NULL, 'export', 241, 242),
162(123, 117, NULL, NULL, 'makeEvaluation', 243, 244),
163(124, 117, NULL, NULL, 'validSurveyEvalComplete', 245, 246),
164(125, 117, NULL, NULL, 'validRubricEvalComplete', 247, 248),
165(126, 117, NULL, NULL, 'completeEvaluationRubric', 249, 250),
166(127, 117, NULL, NULL, 'validMixevalEvalComplete', 251, 252),
167(128, 117, NULL, NULL, 'completeEvaluationMixeval', 253, 254),
168(129, 117, NULL, NULL, 'viewEvaluationResults', 255, 256),
169(130, 117, NULL, NULL, 'studentViewEvaluationResult', 257, 258),
170(131, 117, NULL, NULL, 'markEventReviewed', 259, 260),
171(132, 117, NULL, NULL, 'markGradeRelease', 261, 262),
172(133, 117, NULL, NULL, 'markCommentRelease', 263, 264),
173(134, 117, NULL, NULL, 'changeAllCommentRelease', 265, 266),
174(135, 117, NULL, NULL, 'changeAllGradeRelease', 267, 268),
175(136, 117, NULL, NULL, 'viewGroupSubmissionDetails', 269, 270),
176(137, 117, NULL, NULL, 'viewSurveySummary', 271, 272),
177(138, 117, NULL, NULL, 'export_rubic', 273, 274),
178(139, 117, NULL, NULL, 'export_test', 275, 276),
179(140, 117, NULL, NULL, 'add', 277, 278),
180(141, 117, NULL, NULL, 'edit', 279, 280),
181(142, 117, NULL, NULL, 'delete', 281, 282),
182(143, 2, NULL, NULL, 'Rubrics', 284, 303),
183(144, 143, NULL, NULL, 'postProcess', 285, 286),
184(145, 143, NULL, NULL, 'setUpAjaxList', 287, 288),
185(146, 143, NULL, NULL, 'index', 289, 290),
186(147, 143, NULL, NULL, 'ajaxList', 291, 292),
187(148, 143, NULL, NULL, 'view', 293, 294),
188(149, 143, NULL, NULL, 'add', 295, 296),
189(150, 143, NULL, NULL, 'edit', 297, 298),
190(151, 143, NULL, NULL, 'copy', 299, 300),
191(152, 143, NULL, NULL, 'delete', 301, 302),
192(153, 2, NULL, NULL, 'Emailtemplates', 304, 323),
193(154, 153, NULL, NULL, 'setUpAjaxList', 305, 306),
194(155, 153, NULL, NULL, 'ajaxList', 307, 308),
195(156, 153, NULL, NULL, 'index', 309, 310),
196(157, 153, NULL, NULL, 'add', 311, 312),
197(158, 153, NULL, NULL, 'edit', 313, 314),
198(159, 153, NULL, NULL, 'delete', 315, 316),
199(160, 153, NULL, NULL, 'view', 317, 318),
200(161, 153, NULL, NULL, 'displayTemplateContent', 319, 320),
201(162, 153, NULL, NULL, 'displayTemplateSubject', 321, 322),
202(163, 2, NULL, NULL, 'Faculties', 324, 335),
203(164, 163, NULL, NULL, 'index', 325, 326),
204(165, 163, NULL, NULL, 'view', 327, 328),
205(166, 163, NULL, NULL, 'add', 329, 330),
206(167, 163, NULL, NULL, 'edit', 331, 332),
207(168, 163, NULL, NULL, 'delete', 333, 334),
208(169, 2, NULL, NULL, 'Departments', 336, 347),
209(170, 169, NULL, NULL, 'index', 337, 338),
210(171, 169, NULL, NULL, 'view', 339, 340),
211(172, 169, NULL, NULL, 'add', 341, 342),
212(173, 169, NULL, NULL, 'edit', 343, 344),
213(174, 169, NULL, NULL, 'delete', 345, 346),
214(175, 2, NULL, NULL, 'Sysparameters', 348, 363),
215(176, 175, NULL, NULL, 'setUpAjaxList', 349, 350),
216(177, 175, NULL, NULL, 'index', 351, 352),
217(178, 175, NULL, NULL, 'ajaxList', 353, 354),
218(179, 175, NULL, NULL, 'view', 355, 356),
219(180, 175, NULL, NULL, 'add', 357, 358),
220(181, 175, NULL, NULL, 'edit', 359, 360),
221(182, 175, NULL, NULL, 'delete', 361, 362),
222(183, 2, NULL, NULL, 'Install', 364, 385),
223(184, 183, NULL, NULL, 'index', 365, 366),
224(185, 183, NULL, NULL, 'install2', 367, 368),
225(186, 183, NULL, NULL, 'install3', 369, 370),
226(187, 183, NULL, NULL, 'install4', 371, 372),
227(188, 183, NULL, NULL, 'install5', 373, 374),
228(189, 183, NULL, NULL, 'gpl', 375, 376),
229(190, 183, NULL, NULL, 'add', 377, 378),
230(191, 183, NULL, NULL, 'edit', 379, 380),
231(192, 183, NULL, NULL, 'view', 381, 382),
232(193, 183, NULL, NULL, 'delete', 383, 384),
233(194, 2, NULL, NULL, 'Searchs', 386, 413),
234(195, 194, NULL, NULL, 'update', 387, 388),
235(196, 194, NULL, NULL, 'index', 389, 390),
236(197, 194, NULL, NULL, 'searchEvaluation', 391, 392),
237(198, 194, NULL, NULL, 'searchResult', 393, 394),
238(199, 194, NULL, NULL, 'searchInstructor', 395, 396),
239(200, 194, NULL, NULL, 'eventBoxSearch', 397, 398),
240(201, 194, NULL, NULL, 'formatSearchEvaluation', 399, 400),
241(202, 194, NULL, NULL, 'formatSearchInstructor', 401, 402),
242(203, 194, NULL, NULL, 'formatSearchEvaluationResult', 403, 404),
243(204, 194, NULL, NULL, 'add', 405, 406),
244(205, 194, NULL, NULL, 'edit', 407, 408),
245(206, 194, NULL, NULL, 'view', 409, 410),
246(207, 194, NULL, NULL, 'delete', 411, 412),
247(208, 2, NULL, NULL, 'Groups', 414, 433),
248(209, 208, NULL, NULL, 'setUpAjaxList', 415, 416),
249(210, 208, NULL, NULL, 'index', 417, 418),
250(211, 208, NULL, NULL, 'ajaxList', 419, 420),
251(212, 208, NULL, NULL, 'view', 421, 422),
252(213, 208, NULL, NULL, 'add', 423, 424),
253(214, 208, NULL, NULL, 'edit', 425, 426),
254(215, 208, NULL, NULL, 'delete', 427, 428),
255(216, 208, NULL, NULL, 'import', 429, 430),
256(217, 208, NULL, NULL, 'export', 431, 432),
257(218, 2, NULL, NULL, 'Oauthtokens', 434, 445),
258(219, 218, NULL, NULL, 'index', 435, 436),
259(220, 218, NULL, NULL, 'add', 437, 438),
260(221, 218, NULL, NULL, 'edit', 439, 440),
261(222, 218, NULL, NULL, 'delete', 441, 442),
262(223, 218, NULL, NULL, 'view', 443, 444),
263(224, 2, NULL, NULL, 'Courses', 446, 463),
264(225, 224, NULL, NULL, 'daysLate', 447, 448),
265(226, 224, NULL, NULL, 'index', 449, 450),
266(227, 224, NULL, NULL, 'ajaxList', 451, 452),
267(228, 224, NULL, NULL, 'view', 453, 454),
268(229, 224, NULL, NULL, 'home', 455, 456),
269(230, 224, NULL, NULL, 'add', 457, 458),
270(231, 224, NULL, NULL, 'edit', 459, 460),
271(232, 224, NULL, NULL, 'delete', 461, 462),
272(233, 2, NULL, NULL, 'Upgrade', 464, 477),
273(234, 233, NULL, NULL, 'index', 465, 466),
274(235, 233, NULL, NULL, 'step2', 467, 468),
275(236, 233, NULL, NULL, 'add', 469, 470),
276(237, 233, NULL, NULL, 'edit', 471, 472),
277(238, 233, NULL, NULL, 'view', 473, 474),
278(239, 233, NULL, NULL, 'delete', 475, 476),
279(240, 2, NULL, NULL, 'Surveygroups', 478, 507),
280(241, 240, NULL, NULL, 'postProcess', 479, 480),
281(242, 240, NULL, NULL, 'setUpAjaxList', 481, 482),
282(243, 240, NULL, NULL, 'index', 483, 484),
283(244, 240, NULL, NULL, 'ajaxList', 485, 486),
284(245, 240, NULL, NULL, 'makegroups', 487, 488),
285(246, 240, NULL, NULL, 'makegroupssearch', 489, 490),
286(247, 240, NULL, NULL, 'maketmgroups', 491, 492),
287(248, 240, NULL, NULL, 'savegroups', 493, 494),
288(249, 240, NULL, NULL, 'release', 495, 496),
289(250, 240, NULL, NULL, 'delete', 497, 498),
290(251, 240, NULL, NULL, 'edit', 499, 500),
291(252, 240, NULL, NULL, 'changegroupset', 501, 502),
292(253, 240, NULL, NULL, 'add', 503, 504),
293(254, 240, NULL, NULL, 'view', 505, 506),
294(255, 2, NULL, NULL, 'Events', 508, 525),
295(256, 255, NULL, NULL, 'postProcessData', 509, 510),
296(257, 255, NULL, NULL, 'setUpAjaxList', 511, 512),
297(258, 255, NULL, NULL, 'index', 513, 514),
298(259, 255, NULL, NULL, 'ajaxList', 515, 516),
299(260, 255, NULL, NULL, 'view', 517, 518),
300(261, 255, NULL, NULL, 'add', 519, 520),
301(262, 255, NULL, NULL, 'edit', 521, 522),
302(263, 255, NULL, NULL, 'delete', 523, 524),
303(264, 2, NULL, NULL, 'Framework', 526, 543),
304(265, 264, NULL, NULL, 'calendarDisplay', 527, 528),
305(266, 264, NULL, NULL, 'userInfoDisplay', 529, 530),
306(267, 264, NULL, NULL, 'tutIndex', 531, 532),
307(268, 264, NULL, NULL, 'add', 533, 534),
308(269, 264, NULL, NULL, 'edit', 535, 536),
309(270, 264, NULL, NULL, 'index', 537, 538),
310(271, 264, NULL, NULL, 'view', 539, 540),
311(272, 264, NULL, NULL, 'delete', 541, 542),
312(273, 2, NULL, NULL, 'Lti', 544, 555),
313(274, 273, NULL, NULL, 'index', 545, 546),
314(275, 273, NULL, NULL, 'add', 547, 548),
315(276, 273, NULL, NULL, 'edit', 549, 550),
316(277, 273, NULL, NULL, 'view', 551, 552),
317(278, 273, NULL, NULL, 'delete', 553, 554),
318(279, 2, NULL, NULL, 'Guard', 556, 573),
319(280, 279, NULL, NULL, 'Guard', 557, 572),
320(281, 280, NULL, NULL, 'login', 558, 559),
321(282, 280, NULL, NULL, 'logout', 560, 561),
322(283, 280, NULL, NULL, 'add', 562, 563),
323(284, 280, NULL, NULL, 'edit', 564, 565),
324(285, 280, NULL, NULL, 'index', 566, 567),
325(286, 280, NULL, NULL, 'view', 568, 569),
326(287, 280, NULL, NULL, 'delete', 570, 571),
327(288, NULL, NULL, NULL, 'functions', 575, 640),
328(289, 288, NULL, NULL, 'user', 576, 603),
329(290, 289, NULL, NULL, 'superadmin', 577, 578),
330(291, 289, NULL, NULL, 'admin', 579, 580),
331(292, 289, NULL, NULL, 'instructor', 581, 582),
332(293, 289, NULL, NULL, 'tutor', 583, 584),
333(294, 289, NULL, NULL, 'student', 585, 586),
334(295, 289, NULL, NULL, 'import', 587, 588),
335(296, 289, NULL, NULL, 'password_reset', 589, 600),
336(297, 296, NULL, NULL, 'superadmin', 590, 591),
337(298, 296, NULL, NULL, 'admin', 592, 593),
338(299, 296, NULL, NULL, 'instructor', 594, 595),
339(300, 296, NULL, NULL, 'tutor', 596, 597),
340(301, 296, NULL, NULL, 'student', 598, 599),
341(302, 289, NULL, NULL, 'index', 601, 602),
342(303, 288, NULL, NULL, 'role', 604, 615),
343(304, 303, NULL, NULL, 'superadmin', 605, 606),
344(305, 303, NULL, NULL, 'admin', 607, 608),
345(306, 303, NULL, NULL, 'instructor', 609, 610),
346(307, 303, NULL, NULL, 'tutor', 611, 612),
347(308, 303, NULL, NULL, 'student', 613, 614),
348(309, 288, NULL, NULL, 'evaluation', 616, 619),
349(310, 309, NULL, NULL, 'export', 617, 618),
350(311, 288, NULL, NULL, 'email', 620, 627),
351(312, 311, NULL, NULL, 'allUsers', 621, 622),
352(313, 311, NULL, NULL, 'allGroups', 623, 624),
353(314, 311, NULL, NULL, 'allCourses', 625, 626),
354(315, 288, NULL, NULL, 'emailtemplate', 628, 629),
355(316, 288, NULL, NULL, 'viewstudentresults', 630, 631),
356(317, 288, NULL, NULL, 'viewemailaddresses', 632, 633),
357(318, 288, NULL, NULL, 'superadmin', 634, 635),
358(319, 288, NULL, NULL, 'coursemanager', 636, 637),
359(320, 288, NULL, NULL, 'viewusername', 638, 639);
360
361-- --------------------------------------------------------
362
363--
364-- Table structure for table `aros`
365--
366
367DROP TABLE IF EXISTS `aros`;
368CREATE TABLE IF NOT EXISTS `aros` (
369  `id` int(10) NOT NULL AUTO_INCREMENT,
370  `parent_id` int(10) DEFAULT NULL,
371  `model` varchar(255) DEFAULT NULL,
372  `foreign_key` int(10) DEFAULT NULL,
373  `alias` varchar(255) DEFAULT NULL,
374  `lft` int(10) DEFAULT NULL,
375  `rght` int(10) DEFAULT NULL,
376  PRIMARY KEY (`id`)
377) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
378
379--
380-- Dumping data for table `aros`
381--
382
383INSERT INTO `aros` (`id`, `parent_id`, `model`, `foreign_key`, `alias`, `lft`, `rght`) VALUES
384(1, NULL, 'Role', 1, NULL, 1, 2),
385(2, NULL, 'Role', 2, NULL, 3, 4),
386(3, NULL, 'Role', 3, NULL, 5, 6),
387(4, NULL, 'Role', 4, NULL, 7, 8),
388(5, NULL, 'Role', 5, NULL, 9, 10);
389
390-- --------------------------------------------------------
391
392--
393-- Table structure for table `aros_acos`
394--
395
396DROP TABLE IF EXISTS `aros_acos`;
397CREATE TABLE IF NOT EXISTS `aros_acos` (
398  `id` int(10) NOT NULL AUTO_INCREMENT,
399  `aro_id` int(10) NOT NULL,
400  `aco_id` int(10) NOT NULL,
401  `_create` varchar(2) NOT NULL DEFAULT '0',
402  `_read` varchar(2) NOT NULL DEFAULT '0',
403  `_update` varchar(2) NOT NULL DEFAULT '0',
404  `_delete` varchar(2) NOT NULL DEFAULT '0',
405  PRIMARY KEY (`id`),
406  UNIQUE KEY `ARO_ACO_KEY` (`aro_id`,`aco_id`)
407) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=60 ;
408
409--
410-- Dumping data for table `aros_acos`
411--
412
413INSERT INTO `aros_acos` (`id`, `aro_id`, `aco_id`, `_create`, `_read`, `_update`, `_delete`) VALUES
414(1, 1, 2, '1', '1', '1', '1'),
415(2, 1, 288, '1', '1', '1', '1'),
416(3, 1, 1, '1', '1', '1', '1'),
417(4, 2, 2, '-1', '-1', '-1', '-1'),
418(5, 2, 91, '1', '1', '1', '1'),
419(6, 2, 224, '1', '1', '1', '1'),
420(7, 2, 169, '1', '1', '1', '1'),
421(8, 2, 17, '1', '1', '1', '1'),
422(9, 2, 153, '1', '1', '1', '1'),
423(10, 2, 10, '1', '1', '1', '1'),
424(11, 2, 117, '1', '1', '1', '1'),
425(12, 2, 255, '1', '1', '1', '1'),
426(13, 2, 208, '1', '1', '1', '1'),
427(14, 2, 45, '1', '1', '1', '1'),
428(15, 2, 143, '1', '1', '1', '1'),
429(16, 2, 74, '1', '1', '1', '1'),
430(17, 2, 103, '1', '1', '1', '1'),
431(18, 2, 240, '1', '1', '1', '1'),
432(19, 2, 31, '1', '1', '1', '1'),
433(20, 2, 282, '1', '1', '1', '1'),
434(21, 2, 99, '1', '1', '1', '1'),
435(22, 2, 101, '1', '1', '1', '1'),
436(23, 2, 220, '1', '1', '1', '1'),
437(24, 2, 222, '1', '1', '1', '1'),
438(25, 2, 288, '-1', '-1', '-1', '-1'),
439(26, 2, 315, '1', '1', '1', '1'),
440(27, 2, 309, '1', '1', '1', '1'),
441(28, 2, 312, '1', '1', '1', '1'),
442(29, 2, 289, '1', '1', '1', '1'),
443(30, 2, 291, '-1', '1', '-1', '-1'),
444(31, 2, 290, '-1', '-1', '-1', '-1'),
445(32, 2, 1, '1', '1', '1', '1'),
446(33, 2, 317, '1', '1', '1', '1'),
447(34, 2, 320, '1', '1', '1', '1'),
448(35, 2, 319, '1', '1', '1', '1'),
449(36, 2, 318, '-1', '-1', '-1', '-1'),
450(37, 3, 2, '-1', '-1', '-1', '-1'),
451(38, 3, 91, '1', '1', '1', '1'),
452(39, 3, 224, '1', '1', '1', '1'),
453(40, 3, 17, '1', '1', '1', '1'),
454(41, 3, 153, '1', '1', '1', '1'),
455(42, 3, 10, '1', '1', '1', '1'),
456(43, 3, 117, '1', '1', '1', '1'),
457(44, 3, 255, '1', '1', '1', '1'),
458(45, 3, 208, '1', '1', '1', '1'),
459(46, 3, 45, '1', '1', '1', '1'),
460(47, 3, 143, '1', '1', '1', '1'),
461(48, 3, 74, '1', '1', '1', '1'),
462(49, 3, 103, '1', '1', '1', '1'),
463(50, 3, 240, '1', '1', '1', '1'),
464(51, 3, 31, '1', '1', '1', '1'),
465(52, 3, 282, '1', '1', '1', '1'),
466(53, 3, 99, '1', '1', '1', '1'),
467(54, 3, 101, '1', '1', '1', '1'),
468(55, 3, 220, '1', '1', '1', '1'),
469(56, 3, 222, '1', '1', '1', '1'),
470(57, 3, 288, '-1', '-1', '-1', '-1'),
471(58, 3, 309, '1', '1', '-1', '-1'),
472(59, 3, 289, '1', '1', '1', '1'),
473(60, 3, 291, '-1', '-1', '-1', '-1'),
474(61, 3, 290, '-1', '-1', '-1', '-1'),
475(62, 3, 292, '-1', '1', '-1', '-1'),
476(63, 3, 302, '-1', '-1', '-1', '-1'),
477(64, 3, 317, '-1', '-1', '-1', '-1'),
478(65, 3, 318, '-1', '-1', '-1', '-1'),
479(66, 3, 319, '1', '1', '1', '1'),
480(67, 4, 2, '-1', '-1', '-1', '-1'),
481(68, 4, 91, '1', '1', '1', '1'),
482(69, 4, 224, '-1', '-1', '-1', '-1'),
483(70, 4, 17, '-1', '-1', '-1', '-1'),
484(71, 4, 153, '-1', '-1', '-1', '-1'),
485(72, 4, 10, '-1', '-1', '-1', '-1'),
486(73, 4, 255, '-1', '-1', '-1', '-1'),
487(74, 4, 208, '-1', '-1', '-1', '-1'),
488(75, 4, 45, '-1', '-1', '-1', '-1'),
489(76, 4, 143, '-1', '-1', '-1', '-1'),
490(77, 4, 74, '-1', '-1', '-1', '-1'),
491(78, 4, 103, '-1', '-1', '-1', '-1'),
492(79, 4, 240, '-1', '-1', '-1', '-1'),
493(80, 4, 31, '-1', '-1', '-1', '-1'),
494(81, 4, 282, '1', '1', '1', '1'),
495(82, 4, 123, '1', '1', '1', '1'),
496(83, 4, 130, '1', '1', '1', '1'),
497(84, 4, 126, '1', '1', '1', '1'),
498(85, 4, 128, '1', '1', '1', '1'),
499(86, 4, 39, '1', '1', '1', '1'),
500(87, 4, 288, '-1', '-1', '-1', '-1'),
501(88, 4, 317, '-1', '-1', '-1', '-1'),
502(89, 4, 318, '-1', '-1', '-1', '-1'),
503(90, 5, 2, '-1', '-1', '-1', '-1'),
504(91, 5, 91, '1', '1', '1', '1'),
505(92, 5, 224, '-1', '-1', '-1', '-1'),
506(93, 5, 17, '-1', '-1', '-1', '-1'),
507(94, 5, 153, '-1', '-1', '-1', '-1'),
508(95, 5, 10, '-1', '-1', '-1', '-1'),
509(96, 5, 255, '-1', '-1', '-1', '-1'),
510(97, 5, 208, '-1', '-1', '-1', '-1'),
511(98, 5, 45, '-1', '-1', '-1', '-1'),
512(99, 5, 143, '-1', '-1', '-1', '-1'),
513(100, 5, 74, '-1', '-1', '-1', '-1'),
514(101, 5, 103, '-1', '-1', '-1', '-1'),
515(102, 5, 240, '-1', '-1', '-1', '-1'),
516(103, 5, 31, '-1', '-1', '-1', '-1'),
517(104, 5, 282, '1', '1', '1', '1'),
518(105, 5, 123, '1', '1', '1', '1'),
519(106, 5, 130, '1', '1', '1', '1'),
520(107, 5, 126, '1', '1', '1', '1'),
521(108, 5, 128, '1', '1', '1', '1'),
522(109, 5, 39, '1', '1', '1', '1'),
523(110, 5, 99, '1', '1', '1', '1'),
524(111, 5, 101, '1', '1', '1', '1'),
525(112, 5, 220, '1', '1', '1', '1'),
526(113, 5, 222, '1', '1', '1', '1'),
527(114, 5, 288, '-1', '-1', '-1', '-1'),
528(115, 5, 316, '1', '1', '1', '1'),
529(116, 5, 317, '-1', '-1', '-1', '-1'),
530(117, 5, 318, '-1', '-1', '-1', '-1');
531
532-- --------------------------------------------------------
533
534--
535-- Table structure for table `courses`
536--
537
538DROP TABLE IF EXISTS `courses`;
539CREATE TABLE `courses` (
540  `id` int(11) NOT NULL auto_increment,
541  `course` varchar(80) NOT NULL default '',
542  `title` varchar(80) default NULL,
543  `homepage` varchar(100) default NULL,
544  `self_enroll` varchar(3) default 'off',
545  `password` varchar(25) default NULL,
546  `record_status` varchar(1) NOT NULL default 'A',
547  `creator_id` int(11) NOT NULL default '0',
548  `created` datetime NOT NULL default '0000-00-00 00:00:00',
549  `updater_id` int(11) default NULL,
550  `modified` datetime default NULL,
551  `instructor_id` int(11) NOT NULL default '0',
552  PRIMARY KEY  (`id`),
553  UNIQUE KEY `course` (`course`)
554) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
555
556--
557-- Dumping data for table `courses`
558--
559
560INSERT 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);
561INSERT 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);
562INSERT 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);
563-- --------------------------------------------------------
564
565--
566-- Table structure for table `users`
567--
568
569DROP TABLE IF EXISTS `users`;
570CREATE TABLE IF NOT EXISTS `users` (
571  `id` int(11) NOT NULL AUTO_INCREMENT,
572  `username` varchar(80) NOT NULL DEFAULT '',
573  `password` varchar(80) NOT NULL DEFAULT '',
574  `first_name` varchar(80) DEFAULT NULL,
575  `last_name` varchar(80) DEFAULT NULL,
576  `student_no` varchar(30) DEFAULT NULL,
577  `title` varchar(80) DEFAULT NULL,
578  `email` varchar(80) DEFAULT NULL,
579  `last_login` datetime DEFAULT NULL,
580  `last_logout` datetime DEFAULT NULL,
581  `last_accessed` varchar(10) DEFAULT NULL,
582  `record_status` char(1) NOT NULL DEFAULT 'A',
583  `creator_id` int(11) NOT NULL DEFAULT '0',
584  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
585  `updater_id` int(11) DEFAULT NULL,
586  `modified` datetime DEFAULT NULL,
587  `lti_id` int DEFAULT NULL,
588  PRIMARY KEY (`id`),
589  UNIQUE KEY `username` (`username`),
590  UNIQUE (`lti_id`)
591) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
592
593--
594-- Dumping data for table `users`
595--
596
597INSERT 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
598(1, 'root', 'b17c3f638781ecd22648b509e138c00f', 'Super', 'Admin', NULL, NULL, '', NULL, NULL, NULL, 'A', 1, NOW(), NULL, NOW(), NULL),
599(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),
600(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),
601(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),
602(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),
603(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),
604(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),
605(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),
606(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),
607(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),
608(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),
609(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),
610(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),
611(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),
612(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),
613(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),
614(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),
615(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),
616(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),
617(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),
618(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),
619(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),
620(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),
621(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),
622(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),
623(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),
624(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),
625(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),
626(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),
627(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),
628(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),
629(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),
630(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),
631(34, 'admin1', 'b17c3f638781ecd22648b509e138c00f', '', '', '', '', '', NULL, NULL, NULL, 'A', 1, '2012-05-25 15:48:08', 1, '2012-05-25 15:48:08', NULL),
632(35, 'tutor1', 'b17c3f638781ecd22648b509e138c00f', 'Tutor', '1', '', '', '', NULL, NULL, NULL, 'A', 1, '2012-05-25 15:48:08', 1, '2012-05-25 15:48:08', NULL),
633(36, 'tutor2', 'b17c3f638781ecd22648b509e138c00f', 'Tutor', '2', '', '', '', NULL, NULL, NULL, 'A', 1, '2012-05-25 15:48:08', 1, '2012-05-25 15:48:08', NULL),
634(37, 'tutor3', 'b17c3f638781ecd22648b509e138c00f', 'Tutor', '3', '', '', '', NULL, NULL, NULL, 'A', 1, '2012-05-25 15:48:08', 1, '2012-05-25 15:48:08', NULL),
635(38, 'admin2', 'b17c3f638781ecd22648b509e138c00f', '', '', '', '', '', NULL, NULL, NULL, 'A', 1, '2012-05-25 15:48:08', 1, '2012-05-25 15:48:08', NULL);
636
637-- --------------------------------------------------------
638
639--
640-- Table structure for table `faculties`
641--
642
643DROP TABLE IF EXISTS `faculties`;
644CREATE TABLE IF NOT EXISTS `faculties` (
645  `id` int(11) NOT NULL AUTO_INCREMENT,
646  `name` varchar(80) NOT NULL,
647  `creator_id` int(11) NOT NULL DEFAULT '0',
648  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
649  `updater_id` int(11) DEFAULT NULL,
650  `modified` datetime DEFAULT NULL,
651  PRIMARY KEY (`id`),
652  UNIQUE (`name`)
653) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
654
655--
656-- Dumping data for table `faculties`
657--
658
659INSERT INTO `faculties` (`id`, `name`, `creator_id`, `created`, `updater_id`, `modified`) VALUES
660(1, 'Applied Science', 0, '0000-00-00 00:00:00', NULL, '2012-05-23 11:29:58'),
661(2, 'Science', 0, '0000-00-00 00:00:00', NULL, '2012-05-23 11:30:05');
662
663-- --------------------------------------------------------
664
665--
666-- Table structure for table `departments`
667--
668
669DROP TABLE IF EXISTS `departments`;
670CREATE TABLE IF NOT EXISTS `departments` (
671  `id` int(11) NOT NULL AUTO_INCREMENT,
672  `name` varchar(80) NOT NULL,
673  `faculty_id` int NOT NULL,
674  `creator_id` int(11) NOT NULL DEFAULT '0',
675  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
676  `updater_id` int(11) DEFAULT NULL,
677  `modified` datetime DEFAULT NULL,
678  FOREIGN KEY (`faculty_id`) REFERENCES `faculties` (`id`) ON DELETE CASCADE,
679  PRIMARY KEY (`id`),
680  UNIQUE (`name`)
681) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
682
683--
684-- Dumping data for table `departments`
685--
686
687INSERT INTO `departments` (`id`, `name`, `faculty_id`, `creator_id`, `created`, `updater_id`, `modified`) VALUES
688(1, 'MECH', 1, 0, '0000-00-00 00:00:00', NULL, '2012-05-23 11:30:41'),
689(2, 'APSC', 1, 0, '0000-00-00 00:00:00', NULL, '2012-05-23 11:30:57'),
690(3, 'CPSC', 2, 0, '0000-00-00 00:00:00', NULL, '2012-05-23 11:31:07');
691
692-- --------------------------------------------------------
693
694--
695-- Table structure for table `course_departments`
696--
697
698DROP TABLE IF EXISTS `course_departments`;
699CREATE TABLE `course_departments` (
700  `id` int NOT NULL auto_increment,
701  `course_id` int NOT NULL,
702  `department_id` int NOT NULL,
703  FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE,
704  FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE CASCADE,
705  PRIMARY KEY  (`id`)
706) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
707
708--
709-- Dumping data for table `course_departments`
710--
711
712INSERT INTO `course_departments` (`id`, `course_id`, `department_id`) VALUES
713(1, 2, 2),
714(2, 1, 1),
715(3, 3, 3);
716
717-- --------------------------------------------------------
718
719--
720-- Table structure for table `email_merges`
721--
722
723DROP TABLE IF EXISTS `email_merges`;
724CREATE TABLE IF NOT EXISTS `email_merges` (
725  `id` int(11) NOT NULL AUTO_INCREMENT,
726  `key` varchar(80) NOT NULL,
727  `value` varchar(80) NOT NULL,
728  `table_name` varchar(80) NOT NULL,
729  `field_name` varchar(80) NOT NULL,
730  `created` datetime NOT NULL,
731  `modified` datetime NOT NULL,
732  PRIMARY KEY (`id`)
733) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
734
735--
736-- Dumping data for table `email_merges`
737--
738
739INSERT INTO `email_merges` (`id`, `key`, `value`, `table_name`, `field_name`, `created`, `modified`) VALUES
740(1, 'Username', '{{{USERNAME}}}', 'User', 'username', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
741(2, 'First Name', '{{{FIRSTNAME}}}', 'User', 'first_name', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
742(3, 'Last Name', '{{{LASTNAME}}}', 'User', 'last_name', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
743(4, 'Email Address', '{{{Email}}}', 'User', 'email', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
744
745-- --------------------------------------------------------
746
747--
748-- Table structure for table `email_schedules`
749--
750
751DROP TABLE IF EXISTS `email_schedules`;
752CREATE TABLE IF NOT EXISTS `email_schedules` (
753  `id` int(11) NOT NULL AUTO_INCREMENT,
754  `subject` varchar(80) NOT NULL,
755  `content` text NOT NULL,
756  `date` datetime NOT NULL,
757  `from` varchar(80) NOT NULL,
758  `to` varchar(600) NOT NULL,
759  `course_id` int(11) DEFAULT NULL,
760  `event_id` int(11) DEFAULT NULL,
761  `grp_id` int(11) DEFAULT NULL,
762  `sent` tinyint(1) NOT NULL DEFAULT '0',
763  `creator_id` int(11) NOT NULL,
764  `created` datetime NOT NULL,
765  PRIMARY KEY (`id`)
766) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
767
768--
769-- Dumping data for table `email_schedules`
770--
771
772INSERT INTO `email_schedules` (`id`, `subject`, `content`, `date`, `from`, `to`, `course_id`, `event_id`, `grp_id`, `sent`, `creator_id`, `created`) VALUES
773(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'),
774(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'),
775(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');
776
777-- --------------------------------------------------------
778
779--
780-- Table structure for table `email_templates`
781--
782
783DROP TABLE IF EXISTS `email_templates`;
784CREATE TABLE IF NOT EXISTS `email_templates` (
785  `id` int(11) NOT NULL AUTO_INCREMENT,
786  `name` varchar(80) NOT NULL,
787  `description` text NOT NULL,
788  `subject` varchar(80) NOT NULL,
789  `content` text NOT NULL,
790  `availability` tinyint(4) NOT NULL,
791  `creator_id` int(11) NOT NULL DEFAULT '0',
792  `created` datetime NOT NULL DEFAULT '0000-00-00',
793  `updater_id` int(11) DEFAULT NULL,
794  `updated` datetime DEFAULT NULL,
795  PRIMARY KEY (`id`)
796) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
797
798--
799-- Dumping data for table `email_templates`
800--
801
802INSERT INTO `email_templates` (`id`, `name`, `description`, `subject`, `content`, `availability`, `creator_id`, `created`, `updater_id`, `updated`) VALUES
803(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),
804(2, 'Email template example', 'This is an email template example', 'Email Template', 'Hello, {{{USERNAME}}}',1, 1, '0000-00-00', NULL, NULL),
805(3, 'Email template example2', 'email template ex2', 'Email Template2', 'Hello, {{{FIRSTNAME}}}',1, 2, '0000-00-00', NULL, NULL),
806(4, 'Email template example3', 'email temp example3', 'Email Template3', 'Hello,',1, 3, '0000-00-00', NULL, NULL);
807
808
809-- --------------------------------------------------------
810
811--
812-- Table structure for table `evaluation_mixeval_details`
813--
814
815DROP TABLE IF EXISTS `evaluation_mixeval_details`;
816CREATE TABLE IF NOT EXISTS `evaluation_mixeval_details` (
817  `id` int(11) NOT NULL AUTO_INCREMENT,
818  `evaluation_mixeval_id` int(11) NOT NULL DEFAULT '0',
819  `question_number` int(11) NOT NULL DEFAULT '0',
820  `question_comment` text,
821  `selected_lom` int(11) NOT NULL DEFAULT '0',
822  `grade` double(12,2) NOT NULL DEFAULT '0.00',
823  `record_status` char(1) NOT NULL DEFAULT 'A',
824  `creator_id` int(11) NOT NULL DEFAULT '0',
825  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
826  `updater_id` int(11) DEFAULT NULL,
827  `modified` datetime DEFAULT NULL,
828  PRIMARY KEY (`id`),
829  UNIQUE KEY `evaluation_mixeval_id` (`evaluation_mixeval_id`,`question_number`)
830) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
831
832--
833-- Dumping data for table `evaluation_mixeval_details`
834--
835
836INSERT INTO evaluation_mixeval_details (id, evaluation_mixeval_id, question_number, question_comment, selected_lom, grade, record_status, creator_id, created, updater_id, modified) VALUES
837(1, 1, 1, NULL, 5, 1.00, 'A', 7, '2012-07-13 10:38:20', 7, '2012-07-13 10:38:20'),
838(2, 1, 2, NULL, 5, 1.00, 'A', 7, '2012-07-13 10:38:20', 7, '2012-07-13 10:38:20'),
839(3, 1, 3, NULL, 5, 1.00, 'A', 7, '2012-07-13 10:38:20', 7, '2012-07-13 10:38:20'),
840(4, 1, 4, 'work very efficiently', 0, 0.00, 'A', 7, '2012-07-13 10:38:20', 7, '2012-07-13 10:38:20'),
841(5, 1, 5, 'Contributed his part', 0, 0.00, 'A', 7, '2012-07-13 10:38:20', 7, '2012-07-13 10:38:20'),
842(6, 1, 6, 'very easy to work with', 0, 0.00, 'A', 7, '2012-07-13 10:38:20', 7, '2012-07-13 10:38:20'),
843(7, 2, 1, NULL, 4, 0.80, 'A', 7, '2012-07-13 10:39:28', 7, '2012-07-13 10:39:28'),
844(8, 2, 2, NULL, 4, 0.80, 'A', 7, '2012-07-13 10:39:28', 7, '2012-07-13 10:39:28'),
845(9, 2, 3, NULL, 4, 0.80, 'A', 7, '2012-07-13 10:39:28', 7, '2012-07-13 10:39:28'),
846(10, 2, 4, 'Yes', 0, 0.00, 'A', 7, '2012-07-13 10:39:28', 7, '2012-07-13 10:39:28'),
847(11, 2, 5, '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'),
848(12, 2, 6, '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'),
849(13, 3, 1, NULL, 5, 1.00, 'A', 31, '2012-07-13 10:42:49', 31, '2012-07-13 10:42:49'),
850(14, 3, 2, NULL, 5, 1.00, 'A', 31, '2012-07-13 10:42:49', 31, '2012-07-13 10:42:49'),
851(15, 3, 3, NULL, 5, 1.00, 'A', 31, '2012-07-13 10:42:49', 31, '2012-07-13 10:42:49'),
852(16, 3, 4, 'does great work', 0, 0.00, 'A', 31, '2012-07-13 10:42:49', 31, '2012-07-13 10:42:49'),
853(17, 3, 5, 'willing to do their part', 0, 0.00, 'A', 31, '2012-07-13 10:42:49', 31, '2012-07-13 10:42:49'),
854(18, 3, 6, 'absolutely easy to work with', 0, 0.00, 'A', 31, '2012-07-13 10:42:49', 31, '2012-07-13 10:42:49'),
855(19, 4, 1, NULL, 4, 0.80, 'A', 31, '2012-07-13 10:43:59', 31, '2012-07-13 10:43:59'),
856(20, 4, 2, NULL, 4, 0.80, 'A', 31, '2012-07-13 10:43:59', 31, '2012-07-13 10:43:59'),
857(21, 4, 3, NULL, 5, 1.00, 'A', 31, '2012-07-13 10:43:59', 31, '2012-07-13 10:43:59'),
858(22, 4, 4, 'produce efficient work', 0, 0.00, 'A', 31, '2012-07-13 10:43:59', 31, '2012-07-13 10:43:59'),
859(23, 4, 5, 'definitely', 0, 0.00, 'A', 31, '2012-07-13 10:43:59', 31, '2012-07-13 10:43:59'),
860(24, 4, 6, 'very easy to get along with', 0, 0.00, 'A', 31, '2012-07-13 10:43:59', 31, '2012-07-13 10:43:59'),
861(25, 5, 1, NULL, 4, 0.80, 'A', 5, '2012-07-13 15:19:26', 5, '2012-07-13 15:19:26'),
862(26, 5, 2, NULL, 4, 0.80, 'A', 5, '2012-07-13 15:19:26', 5, '2012-07-13 15:19:26'),
863(27, 5, 3, NULL, 4, 0.80, 'A', 5, '2012-07-13 15:19:26', 5, '2012-07-13 15:19:26'),
864(28, 5, 4, 'Yes', 0, 0.00, 'A', 5, '2012-07-13 15:19:26', 5, '2012-07-13 15:19:26'),
865(29, 5, 5, 'Yes', 0, 0.00, 'A', 5, '2012-07-13 15:19:26', 5, '2012-07-13 15:19:26'),
866(30, 5, 6, 'Yes', 0, 0.00, 'A', 5, '2012-07-13 15:19:26', 5, '2012-07-13 15:19:26');
867
868-- --------------------------------------------------------
869
870--
871-- Table structure for table `evaluation_mixevals`
872--
873
874DROP TABLE IF EXISTS `evaluation_mixevals`;
875CREATE TABLE IF NOT EXISTS `evaluation_mixevals` (
876  `id` int(11) NOT NULL AUTO_INCREMENT,
877  `evaluator` int(11) NOT NULL DEFAULT '0',
878  `evaluatee` int(11) NOT NULL DEFAULT '0',
879  `score` double(12,2) NOT NULL DEFAULT '0.00',
880  `comment_release` int(1) NOT NULL DEFAULT '0',
881  `grade_release` int(1) NOT NULL DEFAULT '0',
882  `grp_event_id` int(11) NOT NULL DEFAULT '0',
883  `event_id` int(11) NOT NULL DEFAULT '0',
884  `record_status` char(1) NOT NULL DEFAULT 'A',
885  `creator_id` int(11) NOT NULL DEFAULT '0',
886  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
887  `updater_id` int(11) DEFAULT NULL,
888  `modified` datetime DEFAULT NULL,
889  PRIMARY KEY (`id`)
890) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
891
892--
893-- Dumping data for table `evaluation_mixevals`
894--
895
896INSERT 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
897(1, 7, 5, 3.00, 0, 0, 5, 3, 'A', 7, '2012-07-13 10:38:20', 7, '2012-07-13 10:38:20'),
898(2, 7, 6, 2.40, 0, 0, 5, 3, 'A', 7, '2012-07-13 10:39:28', 7, '2012-07-13 10:39:28'),
899(3, 31, 32, 3.00, 0, 0, 6, 3, 'A', 31, '2012-07-13 10:42:49', 31, '2012-07-13 10:42:49'),
900(4, 31, 33, 2.60, 0, 0, 6, 3, 'A', 31, '2012-07-13 10:43:59', 31, '2012-07-13 10:43:59'),
901(5, 5, 6, 2.40, 0, 0, 5, 3, 'A', 5, '2012-07-13 15:19:26', 5, '2012-07-13 15:19:26');
902
903-- --------------------------------------------------------
904
905--
906-- Table structure for table `evaluation_rubric_details`
907--
908
909DROP TABLE IF EXISTS `evaluation_rubric_details`;
910CREATE TABLE IF NOT EXISTS `evaluation_rubric_details` (
911  `id` int(11) NOT NULL AUTO_INCREMENT,
912  `evaluation_rubric_id` int(11) NOT NULL DEFAULT '0',
913  `criteria_number` int(11) NOT NULL DEFAULT '0',
914  `criteria_comment` varchar(255) DEFAULT NULL,
915  `selected_lom` int(11) NOT NULL DEFAULT '0',
916  `grade` double(12,2) NOT NULL DEFAULT '0.00',
917  `record_status` char(1) NOT NULL DEFAULT 'A',
918  `creator_id` int(11) NOT NULL DEFAULT '0',
919  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
920  `updater_id` int(11) DEFAULT NULL,
921  `modified` datetime DEFAULT NULL,
922  PRIMARY KEY (`id`),
923  UNIQUE KEY `evaluation_rubric_id` (`evaluation_rubric_id`,`criteria_number`)
924) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
925
926--
927-- Dumping data for table `evaluation_rubric_details`
928--
929
930INSERT INTO evaluation_rubric_details (id, evaluation_rubric_id, criteria_number, criteria_comment, selected_lom, grade, record_status, creator_id, created, updater_id, modified) VALUES
931(1, 1, 1, 'always on time', 5, 5.00, 'A', 31, '2012-07-13 10:26:47', 31, '2012-07-13 10:26:47'),
932(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'),
933(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'),
934(4, 2, 1, 'attended most meetings', 4, 4.00, 'A', 31, '2012-07-13 10:29:15', 31, '2012-07-13 10:29:15'),
935(5, 2, 2, 'very co-operative', 5, 5.00, 'A', 31, '2012-07-13 10:29:15', 31, '2012-07-13 10:29:15'),
936(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'),
937(7, 3, 1, 'Yes', 5, 5.00, 'A', 7, '2012-07-13 10:30:29', 7, '2012-07-13 10:30:29'),
938(8, 3, 2, 'Absolutely', 4, 4.00, 'A', 7, '2012-07-13 10:30:29', 7, '2012-07-13 10:30:29'),
939(9, 3, 3, 'Definitely', 5, 5.00, 'A', 7, '2012-07-13 10:30:29', 7, '2012-07-13 10:30:29'),
940(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'),
941(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'),
942(12, 4, 3, 'Yes', 5, 5.00, 'A', 7, '2012-07-13 10:31:19', 7, '2012-07-13 10:31:19');
943
944-- --------------------------------------------------------
945
946--
947-- Table structure for table `evaluation_rubrics`
948--
949
950DROP TABLE IF EXISTS `evaluation_rubrics`;
951CREATE TABLE IF NOT EXISTS `evaluation_rubrics` (
952  `id` int(11) NOT NULL AUTO_INCREMENT,
953  `evaluator` int(11) NOT NULL DEFAULT '0',
954  `evaluatee` int(11) NOT NULL DEFAULT '0',
955  `comment` text,
956  `score` double(12,2) NOT NULL DEFAULT '0.00',
957  `comment_release` int(1) NOT NULL DEFAULT '0',
958  `grade_release` int(1) NOT NULL DEFAULT '0',
959  `grp_event_id` int(11) NOT NULL DEFAULT '0',
960  `event_id` int(11) NOT NULL DEFAULT '0',
961  `record_status` char(1) NOT NULL DEFAULT 'A',
962  `creator_id` int(11) NOT NULL DEFAULT '0',
963  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
964  `updater_id` int(11) DEFAULT NULL,
965  `modified` datetime DEFAULT NULL,
966  `rubric_id` int(11) NOT NULL DEFAULT '0',
967  PRIMARY KEY (`id`)
968) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
969
970--
971-- Dumping data for table `evaluation_rubrics`
972--
973
974INSERT INTO evaluation_rubrics (id, evaluator, evaluatee, comment, score, comment_release, grade_release, grp_event_id, event_id, record_status, creator_id, created, updater_id, modified, rubric_id) VALUES
975(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),
976(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),
977(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),
978(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);
979
980-- --------------------------------------------------------
981
982--
983-- Table structure for table `evaluation_simples`
984--
985
986DROP TABLE IF EXISTS `evaluation_simples`;
987CREATE TABLE IF NOT EXISTS `evaluation_simples` (
988  `id` int(11) NOT NULL AUTO_INCREMENT,
989  `evaluator` int(11) NOT NULL DEFAULT '0',
990  `evaluatee` int(11) NOT NULL DEFAULT '0',
991  `score` int(5) NOT NULL DEFAULT '0',
992  `comment` text,
993  `release_status` int(1) NOT NULL DEFAULT '0',
994  `grp_event_id` int(11) NOT NULL DEFAULT '0',
995  `event_id` bigint(11) NOT NULL DEFAULT '0',
996  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
997  `grade_release` int(1) DEFAULT NULL,
998  `record_status` char(1) NOT NULL DEFAULT 'A',
999  `creator_id` int(11) NOT NULL DEFAULT '0',
1000  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1001  `updater_id` int(11) DEFAULT NULL,
1002  `modified` datetime DEFAULT NULL,
1003  PRIMARY KEY (`id`)
1004) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1005
1006--
1007-- Dumping data for table `evaluation_simples`
1008--
1009
1010INSERT INTO evaluation_simples (id, evaluator, evaluatee, score, comment, release_status, grp_event_id, event_id, date_submitted, grade_release, record_status, creator_id, created, updater_id, modified) VALUES
1011(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'),
1012(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'),
1013(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'),
1014(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'),
1015(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'),
1016(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'),
1017(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'),
1018(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');
1019
1020
1021
1022-- --------------------------------------------------------
1023
1024--
1025-- Table structure for table `evaluation_submissions`
1026--
1027
1028DROP TABLE IF EXISTS `evaluation_submissions`;
1029CREATE TABLE IF NOT EXISTS `evaluation_submissions` (
1030  `id` int(11) NOT NULL AUTO_INCREMENT,
1031  `event_id` bigint(20) NOT NULL DEFAULT '0',
1032  `grp_event_id` int(11) DEFAULT NULL,
1033  `submitter_id` int(11) NOT NULL DEFAULT '0',
1034  `submitted` tinyint(1) NOT NULL DEFAULT '0',
1035  `date_submitted` datetime DEFAULT NULL,
1036  `record_status` char(1) NOT NULL DEFAULT 'A',
1037  `creator_id` int(11) NOT NULL DEFAULT '0',
1038  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1039  `updater_id` int(11) DEFAULT NULL,
1040  `modified` datetime DEFAULT NULL,
1041  PRIMARY KEY (`id`),
1042  UNIQUE KEY `grp_event_id` (`grp_event_id`,`submitter_id`)
1043) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1044
1045--
1046-- Dumping data for table `evaluation_submissions`
1047--
1048
1049INSERT INTO evaluation_submissions (id, event_id, grp_event_id, submitter_id, submitted, date_submitted, record_status, creator_id, created, updater_id, modified) VALUES
1050(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'),
1051(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'),
1052(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'),
1053(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'),
1054(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'),
1055(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'),
1056(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'),
1057(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'),
1058(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'),
1059(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'),
1060(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');
1061
1062
1063-- --------------------------------------------------------
1064
1065--
1066-- Table structure for table `event_template_types`
1067--
1068
1069DROP TABLE IF EXISTS `event_template_types`;
1070CREATE TABLE IF NOT EXISTS `event_template_types` (
1071  `id` int(11) NOT NULL AUTO_INCREMENT,
1072  `type_name` varchar(50) NOT NULL DEFAULT '',
1073  `table_name` varchar(50) NOT NULL DEFAULT '',
1074  `model_name` varchar(80) NOT NULL DEFAULT '',
1075  `display_for_selection` tinyint(1) NOT NULL DEFAULT '1',
1076  `record_status` char(1) NOT NULL DEFAULT 'A',
1077  `creator_id` int(11) NOT NULL DEFAULT '0',
1078  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1079  `updater_id` int(11) DEFAULT NULL,
1080  `modified` datetime DEFAULT NULL,
1081  PRIMARY KEY (`id`),
1082  UNIQUE KEY `type_name` (`type_name`),
1083  UNIQUE KEY `table_name` (`table_name`)
1084) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
1085
1086--
1087-- Dumping data for table `event_template_types`
1088--
1089
1090INSERT INTO `event_template_types` (`id`, `type_name`, `table_name`, `model_name`, `display_for_selection`, `record_status`, `creator_id`, `created`, `updater_id`, `modified`) VALUES
1091(1, 'SIMPLE', 'simple_evaluations', 'SimpleEvaluation', 1, 'A', 0, '0000-00-00 00:00:00', NULL, NULL),
1092(2, 'RUBRIC', 'rubrics', 'Rubric', 1, 'A', 0, '0000-00-00 00:00:00', NULL, NULL),
1093(3, 'SURVEY', 'surveys', '', 1, 'A', 0, '0000-00-00 00:00:00', NULL, NULL),
1094(4, 'MIX EVALUATION', 'mixevals', 'Mixeval', 1, 'A', 0, '2006-04-03 11:51:02', 0, '2006-04-06 15:31:48');
1095
1096-- --------------------------------------------------------
1097
1098--
1099-- Table structure for table `events`
1100--
1101
1102DROP TABLE IF EXISTS `events`;
1103CREATE TABLE IF NOT EXISTS `events` (
1104  `id` int(11) NOT NULL AUTO_INCREMENT,
1105  `title` varchar(255) NOT NULL DEFAULT '',
1106  `course_id` int(11) NOT NULL DEFAULT '0',
1107  `description` text,
1108  `event_template_type_id` int(20) NOT NULL DEFAULT '0',
1109  `template_id` int(11) NOT NULL DEFAULT '2',
1110  `self_eval` varchar(11) NOT NULL DEFAULT '',
1111  `com_req` int(11) NOT NULL DEFAULT '0',
1112  `due_date` datetime DEFAULT NULL,
1113  `release_date_begin` datetime DEFAULT NULL,
1114  `release_date_end` datetime DEFAULT NULL,
1115  `result_release_date_begin` datetime DEFAULT NULL,
1116  `result_release_date_end` datetime DEFAULT NULL,
1117  `record_status` char(1) NOT NULL DEFAULT 'A',
1118  `creator_id` int(11) NOT NULL DEFAULT '0',
1119  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1120  `updater_id` int(11) DEFAULT NULL,
1121  `modified` datetime DEFAULT NULL,
1122  PRIMARY KEY (`id`)
1123) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1124
1125--
1126-- Dumping data for table `events`
1127--
1128
1129INSERT 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
1130(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'),
1131(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'),
1132(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'),
1133(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'),
1134(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'),
1135(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'),
1136(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'),
1137(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'),
1138(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');
1139
1140-- --------------------------------------------------------
1141
1142--
1143-- Table structure for table `group_events`
1144--
1145
1146DROP TABLE IF EXISTS `group_events`;
1147CREATE TABLE IF NOT EXISTS `group_events` (
1148  `id` int(11) NOT NULL AUTO_INCREMENT,
1149  `group_id` int(11) NOT NULL DEFAULT '0',
1150  `event_id` int(11) NOT NULL DEFAULT '0',
1151  `marked` varchar(20) NOT NULL DEFAULT 'not reviewed',
1152  `grade` double(12,2) DEFAULT NULL,
1153  `grade_release_status` varchar(20) NOT NULL DEFAULT 'None',
1154  `comment_release_status` varchar(20) NOT NULL DEFAULT 'None',
1155  `record_status` char(1) NOT NULL DEFAULT 'A',
1156  `creator_id` int(11) NOT NULL DEFAULT '0',
1157  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1158  `updater_id` int(11) DEFAULT NULL,
1159  `modified` datetime DEFAULT NULL,
1160  PRIMARY KEY (`id`),
1161  UNIQUE KEY `group_id` (`event_id`,`group_id`)
1162) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1163
1164--
1165-- Dumping data for table `group_events`
1166--
1167
1168INSERT 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');
1169INSERT 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');
1170INSERT 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');
1171INSERT 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');
1172INSERT 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');
1173INSERT 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');
1174INSERT INTO `group_events` VALUES (7, 1, 6, 'not reviewed', NULL, 'None', 'None', 'A', 0, '0000-00-00 00:00:00', NULL, NULL);
1175INSERT INTO `group_events` VALUES (8, 2, 6, 'not reviewed', NULL, 'None', 'None', 'A', 0, '0000-00-00 00:00:00', NULL, NULL);
1176INSERT INTO `group_events` VALUES (9, 1, 7, 'not reviewed', NULL, 'None', 'None', 'A', 0, '0000-00-00 00:00:00', NULL, NULL);
1177INSERT INTO `group_events` VALUES (10, 1, 8, 'not reviewed', NULL, 'None', 'None', 'A', 0, '0000-00-00 00:00:00', NULL, NULL);
1178INSERT INTO `group_events` VALUES (11, 1, 9, 'not reviewed', NULL, 'None', 'None', 'A', 0, '0000-00-00 00:00:00', NULL, NULL);
1179-- --------------------------------------------------------
1180
1181--
1182-- Table structure for table `groups`
1183--
1184
1185DROP TABLE IF EXISTS `groups`;
1186CREATE TABLE IF NOT EXISTS `groups` (
1187  `id` int(11) NOT NULL AUTO_INCREMENT,
1188  `group_num` int(4) NOT NULL DEFAULT '0',
1189  `group_name` varchar(80) DEFAULT NULL,
1190  `course_id` int(11) DEFAULT NULL,
1191  `record_status` varchar(1) NOT NULL DEFAULT 'A',
1192  `creator_id` int(11) NOT NULL DEFAULT '0',
1193  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1194  `updater_id` int(11) DEFAULT NULL,
1195  `modified` datetime DEFAULT NULL,
1196  PRIMARY KEY (`id`)
1197) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1198
1199--
1200-- Dumping data for table `groups`
1201--
1202
1203INSERT INTO `groups` VALUES (1, 1, 'Reapers', 1, 'A', 0, '2006-06-20 16:23:40', NULL, '2006-06-20 16:23:40');
1204INSERT INTO `groups` VALUES (2, 2, 'Lazy Engineers', 1, 'A', 0, '2006-06-21 08:47:04', NULL, '2006-06-21 08:49:53');
1205
1206-- --------------------------------------------------------
1207
1208--
1209-- Table structure for table `groups_members`
1210--
1211
1212DROP TABLE IF EXISTS `groups_members`;
1213CREATE TABLE IF NOT EXISTS `groups_members` (
1214  `id` int(11) NOT NULL AUTO_INCREMENT,
1215  `group_id` int(11) NOT NULL DEFAULT '0',
1216  `user_id` int(11) NOT NULL DEFAULT '0',
1217  PRIMARY KEY (`id`),
1218  KEY `group_id` (`group_id`)
1219) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1220
1221--
1222-- Dumping data for table `groups_members`
1223--
1224
1225INSERT INTO `groups_members` VALUES (1, 1, 5);
1226INSERT INTO `groups_members` VALUES (2, 1, 6);
1227INSERT INTO `groups_members` VALUES (3, 1, 7);
1228INSERT INTO `groups_members` VALUES (4, 1, 35);
1229INSERT INTO `groups_members` VALUES (5, 2, 31);
1230INSERT INTO `groups_members` VALUES (6, 2, 32);
1231INSERT INTO `groups_members` VALUES (7, 2, 33);
1232INSERT INTO `groups_members` VALUES (8, 2, 36);
1233
1234-- --------------------------------------------------------
1235
1236--
1237-- Table structure for table `mixevals`
1238--
1239
1240DROP TABLE IF EXISTS `mixevals`;
1241CREATE TABLE IF NOT EXISTS `mixevals` (
1242  `id` int(11) NOT NULL AUTO_INCREMENT,
1243  `name` varchar(80) NOT NULL DEFAULT '',
1244  `zero_mark` tinyint(1) NOT NULL DEFAULT '0',
1245  `total_question` int(11) NOT NULL DEFAULT '0',
1246  `lickert_question_max` int(11) NOT NULL DEFAULT '0',
1247  `scale_max` int(11) NOT NULL DEFAULT '0',
1248  `prefill_question_max` int(11) DEFAULT NULL,
1249  `availability` varchar(10) NOT NULL DEFAULT 'public',
1250  `creator_id` int(11) NOT NULL DEFAULT '0',
1251  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1252  `updater_id` int(11) DEFAULT NULL,
1253  `modified` datetime DEFAULT NULL,
1254  PRIMARY KEY (`id`)
1255) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
1256
1257--
1258-- Dumping data for table `mixevals`
1259--
1260
1261INSERT INTO `mixevals` (`id`, `name`, `zero_mark`, `total_question`, `lickert_question_max`, `scale_max`, `prefill_question_max`, `availability`, `creator_id`, `created`, `updater_id`, `modified`) VALUES
1262(1, 'Default Mix Evalution', 0, 7, 3, 5, 3, 'public', 1, '2006-09-12 13:34:30', 1, '2006-09-12 13:47:57');
1263
1264-- --------------------------------------------------------
1265
1266--
1267-- Table structure for table `mixevals_question_descs`
1268--
1269
1270DROP TABLE IF EXISTS `mixevals_question_descs`;
1271CREATE TABLE IF NOT EXISTS `mixevals_question_descs` (
1272  `id` int(11) NOT NULL AUTO_INCREMENT,
1273  `question_id` int(11) NOT NULL DEFAULT '0',
1274  `scale_level` int(11) NOT NULL DEFAULT '0',
1275  `descriptor` varchar(255) DEFAULT NULL,
1276  PRIMARY KEY (`id`),
1277  KEY `question_num` (`question_id`)
1278) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
1279
1280--
1281-- Dumping data for table `mixevals_question_descs`
1282--
1283
1284INSERT INTO `mixevals_question_descs` (`id`, `question_id`, `scale_level`, `descriptor`) VALUES
1285(1, 1, 1, 'Lowest'),
1286(2, 1, 2, NULL),
1287(3, 1, 3, 'Middle'),
1288(4, 1, 4, NULL),
1289(5, 1, 5, 'Highest'),
1290(6, 2, 1, 'Lowest'),
1291(7, 2, 2, NULL),
1292(8, 2, 3, 'Middle'),
1293(9, 2, 4, NULL),
1294(10, 2, 5, 'Highest'),
1295(11, 3, 1, 'Lowest'),
1296(12, 3, 2, NULL),
1297(13, 3, 3, 'Middle'),
1298(14, 3, 4, NULL),
1299(15, 3, 5, 'Highest');
1300
1301-- --------------------------------------------------------
1302
1303--
1304-- Table structure for table `mixevals_questions`
1305--
1306
1307DROP TABLE IF EXISTS `mixevals_questions`;
1308CREATE TABLE IF NOT EXISTS `mixevals_questions` (
1309  `id` int(11) NOT NULL AUTO_INCREMENT,
1310  `mixeval_id` int(11) NOT NULL DEFAULT '0',
1311  `question_num` int(11) NOT NULL DEFAULT '0',
1312  `title` text,
1313  `instructions` text,
1314  `question_type` char(1) DEFAULT NULL,
1315  `required` tinyint(1) NOT NULL DEFAULT '1',
1316  `multiplier` int(11) NOT NULL DEFAULT '0',
1317  `scale_level` int(11) NOT NULL DEFAULT '0',
1318  `response_type` char(1) DEFAULT NULL,
1319  PRIMARY KEY (`id`)
1320) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
1321
1322--
1323-- Dumping data for table `mixevals_questions`
1324--
1325
1326INSERT INTO `mixevals_questions` (`id`, `mixeval_id`, `question_num`, `title`, `instructions`, `question_type`, `required`, `multiplier`, `scale_level`, `response_type`) VALUES
1327(1, 1, 1, 'Participated in Team Meetings', NULL, 'S', 1, 1, 5, NULL),
1328(2, 1, 2, 'Was Helpful and co-operative', NULL, 'S', 1, 1, 5, NULL),
1329(3, 1, 3, 'Submitted work on time', NULL, 'S', 1, 1, 5, NULL),
1330(4, 1, 4, 'Produced efficient work?', NULL, 'T', 1, 0, 5, 'S'),
1331(5, 1, 5, 'Contributed?', NULL, 'T', 1, 0, 5, 'L'),
1332(6, 1, 6, 'Easy to work with?', NULL, 'T', 0, 0, 5, 'S');
1333
1334-- --------------------------------------------------------
1335
1336--
1337-- Table structure for table `oauth_clients`
1338-- This stores OAuth client credentials (AKA: consumer key and secret).
1339-- Client credentails are used to identify client software.
1340--
1341DROP TABLE IF EXISTS `oauth_clients`;
1342CREATE TABLE IF NOT EXISTS `oauth_clients` (
1343  `id` int(11) NOT NULL AUTO_INCREMENT,
1344  `user_id` int(11) NOT NULL,
1345  `key` varchar(255) NOT NULL,
1346  `secret` varchar(255) NOT NULL,
1347  `comment` text DEFAULT '',
1348  `enabled` tinyint(1) DEFAULT 1,
1349  PRIMARY KEY (`id`),
1350  FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
1351) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1352
1353--
1354-- Dumping data for table `oauth_clients`
1355--
1356
1357INSERT INTO `oauth_clients` (`id`, `user_id`, `key`, `secret`, `comment`, `enabled`) VALUES
1358(1, 1, 'i//dt5l+kFYk/', 'M++SgeLVtL//locYEjkb/aLg2Q/', '', 1);
1359
1360-- --------------------------------------------------------
1361
1362--
1363-- Table structure for table `oauth_nonces`
1364-- Stores nonces to defeat replay attacks.
1365--
1366DROP TABLE IF EXISTS `oauth_nonces`;
1367CREATE TABLE IF NOT EXISTS `oauth_nonces` (
1368  `id` int(11) NOT NULL AUTO_INCREMENT,
1369  `nonce` varchar(255) NOT NULL,
1370  `expires` TIMESTAMP NOT NULL,
1371  PRIMARY KEY (`id`)
1372) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1373
1374-- --------------------------------------------------------
1375--
1376-- Table structure for table `oauth_tokens`
1377-- This stores OAuth token credentials (AKA: access token and secret).
1378-- Token credentials are used to identify a user.
1379--
1380
1381DROP TABLE IF EXISTS `oauth_tokens`;
1382CREATE TABLE IF NOT EXISTS `oauth_tokens` (
1383  `id` int(11) NOT NULL AUTO_INCREMENT,
1384  `user_id` int(11) NOT NULL,
1385  `key` varchar(255) NOT NULL,
1386  `secret` varchar(255) NOT NULL,
1387  `expires` date NOT NULL,
1388  `comment` text DEFAULT '',
1389  `enabled` tinyint(1) DEFAULT 1,
1390  PRIMARY KEY (`id`),
1391  FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
1392) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1393
1394--
1395-- Dumping data for table `oauth_tokens`
1396--
1397
1398INSERT INTO `oauth_tokens` (`id`, `user_id`, `key`, `secret`, `expires`, `comment`, `enabled`) VALUES
1399(1, 1, '//qu+Bfa/gr+C//p8//', '//Bgc3Ql+QQR/O+PEi6sJZG//', '2032-08-13', '', 1);
1400-- --------------------------------------------------------
1401
1402--
1403-- Table structure for table `penalties`
1404--
1405
1406DROP TABLE IF EXISTS `penalties`;
1407CREATE TABLE IF NOT EXISTS `penalties` (
1408  `id` int(11) NOT NULL AUTO_INCREMENT,
1409  `event_id` int(11) DEFAULT NULL,
1410  `days_late` int(11) NOT NULL,
1411  `percent_penalty` int(11) NOT NULL,
1412  PRIMARY KEY (`id`),
1413  FOREIGN KEY (`event_id`) REFERENCES `events` (`id`) ON DELETE CASCADE
1414) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=36 ;
1415
1416--
1417-- Dumping data for table `penalties`
1418--
1419
1420INSERT INTO penalties (id, event_id, days_late, percent_penalty) VALUES
1421(1, 1, 1, 20),
1422(2, 1, 2, 40),
1423(3, 1, 3, 60),
1424(4, 1, 4, 100),
1425(5, 2, 1, 15),
1426(6, 2, 2, 30),
1427(7, 2, 3, 45),
1428(8, 2, 4, 60),
1429(9, 6, 1, 5),
1430(10, 6, 2, 10);
1431
1432-- --------------------------------------------------------
1433
1434--
1435-- Table structure for table `personalizes`
1436--
1437
1438DROP TABLE IF EXISTS `personalizes`;
1439CREATE TABLE IF NOT EXISTS `personalizes` (
1440  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
1441  `user_id` int(11) NOT NULL DEFAULT '0',
1442  `attribute_code` varchar(80) DEFAULT NULL,
1443  `attribute_value` varchar(80) DEFAULT NULL,
1444  `created` datetime DEFAULT NULL,
1445  `updated` datetime DEFAULT NULL,
1446  PRIMARY KEY (`id`),
1447  KEY `user_id` (`user_id`,`attribute_code`)
1448) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
1449
1450--
1451-- Dumping data for table `personalizes`
1452--
1453
1454INSERT INTO `personalizes` VALUES (1, 1, 'Course.SubMenu.EvalEvents.Show', 'true', NULL, '2006-04-03 09:08:36');
1455INSERT INTO `personalizes` VALUES (2, 1, 'Course.SubMenu.SimpleEvals.Show', 'true', NULL, '2006-04-03 09:08:42');
1456INSERT INTO `personalizes` VALUES (3, 1, 'Course.SubMenu.Student.Show', 'true', NULL, '2006-04-03 09:08:47');
1457INSERT INTO `personalizes` VALUES (4, 1, 'Course.SubMenu.Group.Show', 'none', NULL, '2006-04-03 09:08:50');
1458INSERT INTO `personalizes` VALUES (5, 1, 'Course.SubMenu.EvalResults.Show', 'true', NULL, '2006-04-03 09:10:04');
1459INSERT INTO `personalizes` VALUES (6, 1, 'Course.SubMenu.Rubric.Show', 'true', NULL, '2006-04-04 14:40:46');
1460INSERT INTO `personalizes` VALUES (7, 1, 'Course.SubMenu.TeamMaker.Show', 'true', NULL, '2006-05-03 14:26:26');
1461INSERT INTO `personalizes` VALUES (8, 1, 'Mixeval.ListMenu.Limit.Show', '10', NULL, '2006-06-21 09:06:47');
1462INSERT INTO `personalizes` VALUES (9, 1, 'Course.ListMenu.Limit.Show', '10', '2006-06-21 09:06:52', '2006-06-21 09:06:52');
1463INSERT INTO `personalizes` VALUES (10, 1, 'Event.ListMenu.Limit.Show', '10', '2006-06-21 09:07:06', '2006-06-21 09:07:06');
1464INSERT INTO `personalizes` VALUES (11, 1, 'Survey.ListMenu.Limit.Show', '10', '2006-06-21 09:43:13', '2006-06-21 09:43:13');
1465INSERT INTO `personalizes` VALUES (12, 1, 'SurveyGroupSet.List.Limit.Show', '10', '2006-06-21 12:22:19', '2006-06-21 12:22:19');
1466INSERT INTO `personalizes` VALUES (13, 1, 'User.ListMenu.Limit.Show', '10', '2006-06-21 15:11:00', '2006-06-21 15:11:00');
1467INSERT INTO `personalizes` VALUES (14, 1, 'SimpleEval.ListMenu.Limit.Show', '10', '2006-06-21 15:12:56', '2006-06-21 15:12:56');
1468INSERT INTO `personalizes` VALUES (15, 1, 'Search.ListMenu.Limit.Show', '10', '2006-06-21 15:16:35', '2006-06-21 15:16:35');
1469INSERT INTO `personalizes` VALUES (16, 1, 'SysParam.ListMenu.Limit.Show', '10', '2006-06-21 15:16:37', '2006-06-21 15:16:37');
1470
1471-- --------------------------------------------------------
1472
1473--
1474-- Table structure for table `questions`
1475--
1476
1477DROP TABLE IF EXISTS `questions`;
1478CREATE TABLE IF NOT EXISTS `questions` (
1479  `id` int(11) NOT NULL AUTO_INCREMENT,
1480  `prompt` varchar(255) NOT NULL DEFAULT '',
1481  `type` varchar(1) DEFAULT NULL,
1482  `master` varchar(3) NOT NULL DEFAULT 'yes',
1483  PRIMARY KEY (`id`)
1484) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1485
1486--
1487-- Dumping data for table `questions`
1488--
1489
1490INSERT INTO `questions` VALUES (1, 'What was your GPA last term?', 'M', 'no');
1491INSERT INTO `questions` VALUES (2, 'Do you own a laptop?', 'M', 'no');
1492INSERT INTO `questions` VALUES (3, 'Testing out MC', 'M', 'no');
1493INSERT INTO `questions` VALUES (4, 'Testing out checkboxes', 'C', 'no');
1494INSERT INTO `questions` VALUES (5, 'Testing out single line answers', 'S', 'no');
1495INSERT INTO `questions` VALUES (6, 'Testing out multi-line long answers', 'L', 'no');
1496
1497-- --------------------------------------------------------
1498
1499--
1500-- Table structure for table `responses`
1501--
1502
1503DROP TABLE IF EXISTS `responses`;
1504CREATE TABLE IF NOT EXISTS `responses` (
1505  `id` int(11) NOT NULL AUTO_INCREMENT,
1506  `question_id` int(11) NOT NULL DEFAULT '0',
1507  `response` text NOT NULL,
1508  PRIMARY KEY (`id`)
1509) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1510
1511--
1512-- Dumping data for table `responses`
1513--
1514
1515INSERT INTO `responses` VALUES (1, 1, '4+');
1516INSERT INTO `responses` VALUES (2, 1, '3-4');
1517INSERT INTO `responses` VALUES (3, 1, '2-3');
1518INSERT INTO `responses` VALUES (4, 1, '<2');
1519INSERT INTO `responses` VALUES (5, 2, 'yes');
1520INSERT INTO `responses` VALUES (6, 2, 'no');
1521INSERT INTO `responses` VALUES (7, 3, 'A');
1522INSERT INTO `responses` VALUES (8, 3, 'B');
1523INSERT INTO `responses` VALUES (9, 3, 'C');
1524INSERT INTO `responses` VALUES (10, 3, 'D');
1525INSERT INTO `responses` VALUES (11, 4, 'choose me');
1526INSERT INTO `responses` VALUES (12, 4, 'no, me');
1527INSERT INTO `responses` VALUES (13, 4, 'me please');
1528
1529-- --------------------------------------------------------
1530
1531--
1532-- Table structure for table `roles`
1533--
1534
1535DROP TABLE IF EXISTS `roles`;
1536CREATE TABLE IF NOT EXISTS `roles` (
1537  `id` int(11) NOT NULL AUTO_INCREMENT,
1538  `name` varchar(255) NOT NULL,
1539  `created` datetime NOT NULL,
1540  `modified` datetime NOT NULL,
1541  PRIMARY KEY (`id`)
1542) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
1543
1544--
1545-- Dumping data for table `roles`
1546--
1547
1548INSERT INTO `roles` (`id`, `name`, `created`, `modified`) VALUES
1549(1, 'superadmin', '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1550(2, 'admin', '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1551(3, 'instructor', '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1552(4, 'tutor', '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1553(5, 'student', '2010-10-27 16:17:29', '2010-10-27 16:17:29');
1554
1555-- --------------------------------------------------------
1556
1557--
1558-- Table structure for table `roles_users`
1559--
1560
1561DROP TABLE IF EXISTS `roles_users`;
1562CREATE TABLE IF NOT EXISTS `roles_users` (
1563  `id` int(11) NOT NULL AUTO_INCREMENT,
1564  `role_id` int(11) NOT NULL,
1565  `user_id` int(11) NOT NULL,
1566  `created` datetime NOT NULL,
1567  `modified` datetime NOT NULL,
1568  PRIMARY KEY (`id`)
1569) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1570
1571--
1572-- Dumping data for table `roles_users`
1573--
1574
1575INSERT INTO `roles_users` (`role_id`, `user_id`, `created`, `modified`) VALUES
1576(1, 1, NOW(), NOW()),
1577(3, 2, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1578(3, 3, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1579(3, 4, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1580(5, 5, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1581(5, 6, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1582(5, 7, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1583(5, 8, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1584(5, 9, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1585(5, 10, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1586(5, 11, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1587(5, 12, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1588(5, 13, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1589(5, 14, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1590(5, 15, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1591(5, 16, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1592(5, 17, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1593(5, 18, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1594(5, 19, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1595(5, 20, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1596(5, 21, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1597(5, 22, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1598(5, 23, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1599(5, 24, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1600(5, 25, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1601(5, 26, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1602(5, 27, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1603(5, 28, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1604(5, 29, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1605(5, 30, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1606(5, 31, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1607(5, 32, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1608(5, 33, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1609(2, 34, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1610(4, 35, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1611(4, 36, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1612(4, 37, '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1613(2, 38, '2010-10-27 16:17:29', '2010-10-27 16:17:29');
1614
1615-- --------------------------------------------------------
1616
1617--
1618-- Table structure for table `rubrics`
1619--
1620
1621DROP TABLE IF EXISTS `rubrics`;
1622CREATE TABLE IF NOT EXISTS `rubrics` (
1623  `id` int(11) NOT NULL AUTO_INCREMENT,
1624  `name` varchar(80) NOT NULL DEFAULT '',
1625  `zero_mark` tinyint(1) NOT NULL DEFAULT '0',
1626  `lom_max` int(11) DEFAULT NULL,
1627  `criteria` int(11) DEFAULT NULL,
1628  `availability` varchar(10) NOT NULL DEFAULT 'public',
1629  `template` varchar(20) NOT NULL DEFAULT 'horizontal',
1630  `creator_id` int(11) NOT NULL DEFAULT '0',
1631  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1632  `updater_id` int(11) DEFAULT NULL,
1633  `modified` datetime DEFAULT NULL,
1634  PRIMARY KEY (`id`)
1635) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1636
1637--
1638-- Dumping data for table `rubrics`
1639--
1640
1641INSERT 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');
1642
1643-- --------------------------------------------------------
1644
1645--
1646-- Table structure for table `rubrics_criteria_comments`
1647--
1648
1649DROP TABLE IF EXISTS `rubrics_criteria_comments`;
1650CREATE TABLE IF NOT EXISTS `rubrics_criteria_comments` (
1651  `id` int(11) NOT NULL AUTO_INCREMENT,
1652  `criteria_id` int(11) NOT NULL,
1653  `rubrics_loms_id` int(11) NOT NULL,
1654  `criteria_comment` varchar(255) DEFAULT NULL,
1655  PRIMARY KEY (`id`),
1656  KEY `criteria_id` (`criteria_id`),
1657  KEY `rubrics_loms_id` (`rubrics_loms_id`)
1658) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1659
1660--
1661-- Dumping data for table `rubrics_criteria_comments`
1662--
1663
1664INSERT INTO `rubrics_criteria_comments` VALUES (1, 1, 1, "No participation.");
1665INSERT INTO `rubrics_criteria_comments` VALUES (2, 1, 2, "Little participation.");
1666INSERT INTO `rubrics_criteria_comments` VALUES (3, 1, 3, "Some participation.");
1667INSERT INTO `rubrics_criteria_comments` VALUES (4, 1, 4, "Good participation.");
1668INSERT INTO `rubrics_criteria_comments` VALUES (5, 1, 5, "Great participation.");
1669INSERT INTO `rubrics_criteria_comments` VALUES (6, 2, 1, NULL);
1670INSERT INTO `rubrics_criteria_comments` VALUES (7, 2, 2, NULL);
1671INSERT INTO `rubrics_criteria_comments` VALUES (8, 2, 3, NULL);
1672INSERT INTO `rubrics_criteria_comments` VALUES (9, 2, 4, NULL);
1673INSERT INTO `rubrics_criteria_comments` VALUES (10, 2, 5, NULL);
1674INSERT INTO `rubrics_criteria_comments` VALUES (11, 3, 1, NULL);
1675INSERT INTO `rubrics_criteria_comments` VALUES (12, 3, 2, NULL);
1676INSERT INTO `rubrics_criteria_comments` VALUES (13, 3, 3, NULL);
1677INSERT INTO `rubrics_criteria_comments` VALUES (14, 3, 4, NULL);
1678INSERT INTO `rubrics_criteria_comments` VALUES (15, 3, 5, NULL);
1679
1680-- --------------------------------------------------------
1681
1682--
1683-- Table structure for table `rubrics_criterias`
1684--
1685
1686DROP TABLE IF EXISTS `rubrics_criterias`;
1687CREATE TABLE IF NOT EXISTS `rubrics_criterias` (
1688  `id` int(11) NOT NULL AUTO_INCREMENT,
1689  `rubric_id` int(11) NOT NULL DEFAULT '0',
1690  `criteria_num` int(11) NOT NULL DEFAULT '999',
1691  `criteria` varchar(255) DEFAULT NULL,
1692  `multiplier` int(11) NOT NULL DEFAULT '0',
1693  PRIMARY KEY (`id`)
1694) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1695
1696--
1697-- Dumping data for table `rubrics_criterias`
1698--
1699
1700INSERT INTO `rubrics_criterias` VALUES (1, 1, 1, 'Participated in Team Meetings', 5);
1701INSERT INTO `rubrics_criterias` VALUES (2, 1, 2, 'Was Helpful and Co-operative', 5);
1702INSERT INTO `rubrics_criterias` VALUES (3, 1, 3, 'Submitted Work on Time', 5);
1703
1704-- --------------------------------------------------------
1705
1706--
1707-- Table structure for table `rubrics_loms`
1708--
1709
1710DROP TABLE IF EXISTS `rubrics_loms`;
1711CREATE TABLE IF NOT EXISTS `rubrics_loms` (
1712  `id` int(11) NOT NULL AUTO_INCREMENT,
1713  `rubric_id` int(11) NOT NULL DEFAULT '0',
1714  `lom_num` int(11) NOT NULL DEFAULT '999',
1715  `lom_comment` varchar(255) DEFAULT NULL,
1716  PRIMARY KEY (`id`)
1717) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1718
1719--
1720-- Dumping data for table `rubrics_loms`
1721--
1722
1723INSERT INTO `rubrics_loms` VALUES (1, 1, 1, 'Poor');
1724INSERT INTO `rubrics_loms` VALUES (2, 1, 2, 'Below Average');
1725INSERT INTO `rubrics_loms` VALUES (3, 1, 3, 'Average');
1726INSERT INTO `rubrics_loms` VALUES (4, 1, 4, 'Above Average');
1727INSERT INTO `rubrics_loms` VALUES (5, 1, 5, 'Excellent');
1728
1729-- --------------------------------------------------------
1730
1731--
1732-- Table structure for table `simple_evaluations`
1733--
1734
1735DROP TABLE IF EXISTS `simple_evaluations`;
1736CREATE TABLE IF NOT EXISTS `simple_evaluations` (
1737  `id` int(11) NOT NULL AUTO_INCREMENT,
1738  `name` varchar(50) NOT NULL DEFAULT '',
1739  `description` text NOT NULL,
1740  `point_per_member` int(10) NOT NULL DEFAULT '0',
1741  `record_status` char(1) NOT NULL DEFAULT 'A',
1742  `availability` varchar(10) NOT NULL DEFAULT 'public',
1743  `creator_id` int(11) NOT NULL DEFAULT '0',
1744  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1745  `updater_id` int(11) DEFAULT NULL,
1746  `modified` datetime DEFAULT NULL,
1747  PRIMARY KEY (`id`)
1748) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1749
1750--
1751-- Dumping data for table `simple_evaluations`
1752--
1753
1754INSERT 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');
1755
1756-- --------------------------------------------------------
1757
1758--
1759-- Table structure for table `survey_group_members`
1760--
1761
1762DROP TABLE IF EXISTS `survey_group_members`;
1763CREATE TABLE IF NOT EXISTS `survey_group_members` (
1764  `id` int(11) NOT NULL AUTO_INCREMENT,
1765  `group_set_id` int(11) DEFAULT '0',
1766  `group_id` int(11) NOT NULL DEFAULT '0',
1767  `user_id` int(11) NOT NULL DEFAULT '0',
1768  PRIMARY KEY (`id`)
1769) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1770
1771--
1772-- Dumping data for table `survey_group_members`
1773--
1774
1775INSERT INTO `survey_group_members` VALUES (25, 3, 5, 17);
1776INSERT INTO `survey_group_members` VALUES (26, 3, 5, 21);
1777INSERT INTO `survey_group_members` VALUES (27, 3, 5, 15);
1778INSERT INTO `survey_group_members` VALUES (28, 3, 5, 19);
1779INSERT INTO `survey_group_members` VALUES (29, 3, 6, 6);
1780INSERT INTO `survey_group_members` VALUES (30, 3, 6, 32);
1781INSERT INTO `survey_group_members` VALUES (31, 3, 6, 26);
1782INSERT INTO `survey_group_members` VALUES (32, 3, 6, 13);
1783INSERT INTO `survey_group_members` VALUES (33, 3, 7, 7);
1784INSERT INTO `survey_group_members` VALUES (34, 3, 7, 28);
1785INSERT INTO `survey_group_members` VALUES (35, 3, 7, 5);
1786INSERT INTO `survey_group_members` VALUES (36, 3, 7, 33);
1787
1788-- --------------------------------------------------------
1789
1790--
1791-- Table structure for table `survey_group_sets`
1792--
1793
1794DROP TABLE IF EXISTS `survey_group_sets`;
1795CREATE TABLE IF NOT EXISTS `survey_group_sets` (
1796  `id` int(11) NOT NULL AUTO_INCREMENT,
1797  `survey_id` int(11) NOT NULL DEFAULT '0',
1798  `set_description` text NOT NULL,
1799  `num_groups` int(11) NOT NULL DEFAULT '0',
1800  `date` int(11) NOT NULL DEFAULT '0',
1801  `released` int(1) NOT NULL DEFAULT '0',
1802  PRIMARY KEY (`id`),
1803  KEY `survey_id` (`survey_id`)
1804) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1805
1806--
1807-- Dumping data for table `survey_group_sets`
1808--
1809
1810INSERT INTO `survey_group_sets` VALUES (3, 1, 'test groupset', 3, 1150923956, 0);
1811
1812-- --------------------------------------------------------
1813
1814--
1815-- Table structure for table `survey_groups`
1816--
1817
1818DROP TABLE IF EXISTS `survey_groups`;
1819CREATE TABLE IF NOT EXISTS `survey_groups` (
1820  `id` int(11) NOT NULL AUTO_INCREMENT,
1821  `group_set_id` int(11) NOT NULL DEFAULT '0',
1822  `group_number` int(11) NOT NULL DEFAULT '0',
1823  PRIMARY KEY (`id`)
1824) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1825
1826--
1827-- Dumping data for table `survey_groups`
1828--
1829
1830INSERT INTO `survey_groups` VALUES (5, 3, 1);
1831INSERT INTO `survey_groups` VALUES (6, 3, 2);
1832INSERT INTO `survey_groups` VALUES (7, 3, 3);
1833
1834-- --------------------------------------------------------
1835
1836--
1837-- Table structure for table `survey_inputs`
1838--
1839
1840DROP TABLE IF EXISTS `survey_inputs`;
1841CREATE TABLE IF NOT EXISTS `survey_inputs` (
1842  `id` int(11) NOT NULL AUTO_INCREMENT,
1843  `event_id` int(11) NOT NULL DEFAULT '0',
1844  `user_id` int(11) NOT NULL DEFAULT '0',
1845  `question_id` int(11) NOT NULL DEFAULT '0',
1846  `sub_id` int(11) DEFAULT NULL,
1847  `chkbx_id` int(11) DEFAULT NULL,
1848  `response_text` text,
1849  `response_id` int(11) DEFAULT NULL,
1850  PRIMARY KEY (`id`)
1851) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1852
1853--
1854-- Dumping data for table `survey_inputs`
1855--
1856
1857INSERT INTO survey_inputs (id, event_id, user_id, question_id, sub_id, chkbx_id, response_text, response_id) VALUES
1858(1, 4, 7, 1, NULL, NULL, '4+', 1),
1859(2, 4, 7, 2, NULL, NULL, 'yes', 5),
1860(3, 4, 31, 1, NULL, NULL, '3-4', 2),
1861(4, 4, 31, 2, NULL, NULL, 'no', 6),
1862(5, 5, 17, 3, NULL, NULL, 'B', 8),
1863(6, 5, 17, 4, NULL, 0, 'choose me', 11),
1864(7, 5, 17, 4, NULL, 1, 'no, me', 12),
1865(8, 5, 17, 5, NULL, NULL, 'single line rah rah', 0),
1866(9, 5, 17, 6, NULL, NULL, 'long answer what what', 0);
1867
1868-- --------------------------------------------------------
1869
1870--
1871-- Table structure for table `survey_questions`
1872--
1873
1874DROP TABLE IF EXISTS `survey_questions`;
1875CREATE TABLE IF NOT EXISTS `survey_questions` (
1876  `id` int(11) NOT NULL AUTO_INCREMENT,
1877  `survey_id` int(11) NOT NULL DEFAULT '0',
1878  `number` int(11) NOT NULL DEFAULT '9999',
1879  `question_id` int(11) NOT NULL DEFAULT '0',
1880  PRIMARY KEY (`id`),
1881  KEY `question_id` (`question_id`),
1882  KEY `survey_id` (`survey_id`)
1883) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1884
1885--
1886-- Dumping data for table `survey_questions`
1887--
1888
1889INSERT INTO survey_questions (id, survey_id, number, question_id) VALUES
1890(1, 1, 1, 1),
1891(2, 1, 2, 2),
1892(3, 2, 1, 3),
1893(4, 2, 2, 4),
1894(5, 2, 3, 5),
1895(6, 2, 4, 6);
1896
1897-- --------------------------------------------------------
1898
1899--
1900-- Table structure for table `surveys`
1901--
1902
1903DROP TABLE IF EXISTS `surveys`;
1904CREATE TABLE IF NOT EXISTS `surveys` (
1905  `id` int(11) NOT NULL AUTO_INCREMENT,
1906  `course_id` int(11) NOT NULL DEFAULT '0',
1907  `user_id` int(11) NOT NULL DEFAULT '1',
1908  `name` varchar(255) NOT NULL,
1909  `availability` varchar(10) NOT NULL DEFAULT 'public',
1910  `due_date` datetime DEFAULT NULL,
1911  `release_date_begin` datetime DEFAULT NULL,
1912  `release_date_end` datetime DEFAULT NULL,
1913  `released` tinyint(1) NOT NULL DEFAULT '0',
1914  `creator_id` int(11) NOT NULL DEFAULT '0',
1915  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1916  `updater_id` int(11) DEFAULT NULL,
1917  `modified` datetime DEFAULT NULL,
1918  PRIMARY KEY (`id`)
1919) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1920
1921--
1922-- Dumping data for table `surveys`
1923--
1924
1925INSERT INTO surveys (id, course_id, user_id, name, due_date, release_date_begin, release_date_end, released, creator_id, created, updater_id, modified) VALUES
1926(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'),
1927(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');
1928-- --------------------------------------------------------
1929
1930--
1931-- Table structure for table `sys_parameters`
1932--
1933
1934DROP TABLE IF EXISTS `sys_parameters`;
1935CREATE TABLE IF NOT EXISTS `sys_parameters` (
1936  `id` int(11) NOT NULL AUTO_INCREMENT,
1937  `parameter_code` varchar(80) NOT NULL DEFAULT '',
1938  `parameter_value` text,
1939  `parameter_type` char(1) NOT NULL DEFAULT '',
1940  `description` varchar(255) DEFAULT NULL,
1941  `record_status` char(1) NOT NULL DEFAULT 'A',
1942  `creator_id` int(11) NOT NULL DEFAULT '0',
1943  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1944  `updater_id` int(11) DEFAULT NULL,
1945  `modified` datetime DEFAULT NULL,
1946  PRIMARY KEY (`id`),
1947  UNIQUE KEY `parameter_code` (`parameter_code`)
1948) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 ;
1949
1950--
1951-- Dumping data for table `sys_parameters`
1952--
1953
1954INSERT INTO `sys_parameters` (`id`, `parameter_code`, `parameter_value`, `parameter_type`, `description`, `record_status`, `creator_id`, `created`, `updater_id`, `modified`) VALUES
1955(1, 'system.soft_delete_enable', 'true', 'B', 'Whether soft deletion of records is enabled.', 'A', 0, NOW(), 0, NOW()),
1956(2, 'system.debug_mode', '0', 'I', 'Debug Mode of the system', 'A', 0, NOW(), NULL, NOW()),
1957(3, 'system.debug_verbosity', '1', 'I', NULL, 'A', 0, NOW(), NULL, NOW()),
1958(6, 'system.super_admin', 'root', 'S', NULL, 'A', 0, NOW(), NULL, NOW()),
1959(7, 'system.upload_dir', 'uploads/', 'S', NULL, 'A', 0, NOW(), NULL, NOW()),
1960(9, 'display.page_title', 'iPeer v2 with TeamMaker', 'S', 'Page title show in HTML.', 'A', 0, NOW(), 0, NOW()),
1961(10, 'display.logo_file', 'LayoutLogoDefault.gif', 'S', 'Logo image name.', 'A', 0, NOW(), 0, NOW()),
1962(11, 'display.login_logo_file', 'LayoutLoginLogoDefault.gif', 'S', 'Login Image File Name.', 'A', 0, NOW(), 0, NOW()),
1963(13, 'custom.login_control', 'ipeer', 'S', 'The login control for iPeer: ipeer; CWL: UBC_CWL', 'A', 0, NOW(), NULL, NOW()),
1964(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()),
1965(15, 'system.admin_email', 'Please enter the iPeer administrator\\''s email address.', 'S', NULL, 'A', 0, NOW(), NULL, NOW()),
1966(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()),
1967(17, 'system.password_reset_emailsubject', 'iPeer Password Reset Notification', 'S', NULL, 'A', 0, NOW(), NULL, NOW()),
1968(18, 'display.date_format', 'D, M j, Y g:i a', 'S', 'date format preference', 'A', 0, NOW(), NULL, NOW()),
1969(20, 'database.version', '4', 'I', 'database version', 'A', 0, NOW(), NULL, NOW()),
1970(21, 'email.port', '25', 'S', 'port number for email smtp option', 'A', '0', NOW(), NULL , NOW()),
1971(22, 'email.host', 'localhost', 'S', 'host address for email smtp option', 'A', '0', NOW(), NULL , NOW()),
1972(23, 'email.username', '', 'S', 'username for email smtp option', 'A', '0', NOW(), NULL , NOW()),
1973(24, 'email.password', '', 'S', 'password for email smtp option', 'A', '0', NOW(), NULL , NOW()),
1974(25, 'display.contact_info', 'noreply@ipeer.ctlt.ubc.ca', 'S', 'Contact Info', 'A', 0, NOW(), 0, NOW()),
1975(26, 'display.login.header', '', 'S', 'Login Info Header', 'A', 0, NOW(), 0, NOW()),
1976(27, 'display.login.footer', '', 'S', 'Login Info Footer', 'A', 0, NOW(), 0, NOW()),
1977(28, 'display.vocabulary.department', 'Department', 'S', 'Department vocabulary', 'A', 0, NOW(), 0, NOW());
1978
1979-- --------------------------------------------------------
1980
1981--
1982-- Table structure for table `user_courses`
1983--
1984
1985DROP TABLE IF EXISTS `user_courses`;
1986CREATE TABLE IF NOT EXISTS `user_courses` (
1987  `id` int(11) NOT NULL AUTO_INCREMENT,
1988  `user_id` int(11) NOT NULL DEFAULT '0',
1989  `course_id` int(11) NOT NULL DEFAULT '0',
1990  `access_right` varchar(1) NOT NULL DEFAULT 'O',
1991  `record_status` varchar(1) NOT NULL DEFAULT 'A',
1992  `creator_id` int(11) NOT NULL DEFAULT '0',
1993  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1994  `updater_id` int(11) DEFAULT NULL,
1995  `modified` datetime DEFAULT NULL,
1996  PRIMARY KEY (`id`),
1997  UNIQUE no_duplicates (`course_id`,`user_id`),
1998  FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
1999  FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE
2000) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2001
2002--
2003-- Dumping data for table `user_courses`
2004--
2005
2006INSERT INTO `user_courses` VALUES (1, 2, 1, 'A', 'A', 0, '2006-06-20 14:14:45', NULL, '2006-06-20 14:14:45');
2007INSERT INTO `user_courses` VALUES (2, 3, 2, 'A', 'A', 0, '2006-06-20 14:39:31', NULL, '2006-06-20 14:39:31');
2008INSERT INTO `user_courses` VALUES (3, 4, 2, 'A', 'A', 0, '2006-06-20 14:39:31', NULL, '2006-06-20 14:39:31');
2009INSERT INTO `user_courses` VALUES (4, 4, 3, 'A', 'A', 0, '2006-06-20 14:39:31', NULL, '2006-06-20 14:39:31');
2010
2011-- --------------------------------------------------------
2012
2013--
2014-- Table structure for table `user_enrols`
2015--
2016
2017DROP TABLE IF EXISTS `user_enrols`;
2018CREATE TABLE IF NOT EXISTS `user_enrols` (
2019  `id` int(11) NOT NULL AUTO_INCREMENT,
2020  `course_id` int(11) NOT NULL DEFAULT '0',
2021  `user_id` int(11) NOT NULL DEFAULT '0',
2022  `record_status` varchar(1) NOT NULL DEFAULT 'A',
2023  `creator_id` int(11) NOT NULL DEFAULT '0',
2024  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2025  `updater_id` int(11) DEFAULT NULL,
2026  `modified` datetime DEFAULT NULL,
2027  PRIMARY KEY (`id`),
2028  UNIQUE no_duplicates (`course_id`,`user_id`),
2029  FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
2030  FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE
2031) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2032
2033--
2034-- Dumping data for table `user_enrols`
2035--
2036
2037INSERT INTO `user_enrols` VALUES (1, 1, 5, 'A', 0, '2006-06-20 14:19:18', NULL, '2006-06-20 14:19:18');
2038INSERT INTO `user_enrols` VALUES (2, 1, 6, 'A', 0, '2006-06-20 14:26:59', NULL, '2006-06-20 14:26:59');
2039INSERT INTO `user_enrols` VALUES (3, 1, 7, 'A', 0, '2006-06-20 14:27:24', NULL, '2006-06-20 14:27:24');
2040INSERT INTO `user_enrols` VALUES (5, 2, 9, 'A', 0, '2006-06-20 14:28:08', NULL, '2006-06-20 14:28:08');
2041INSERT INTO `user_enrols` VALUES (6, 2, 10, 'A', 0, '2006-06-20 14:28:29', NULL, '2006-06-20 14:28:29');
2042INSERT INTO `user_enrols` VALUES (7, 2, 11, 'A', 0, '2006-06-20 14:28:49', NULL, '2006-06-20 14:28:49');
2043INSERT INTO `user_enrols` VALUES (8, 2, 12, 'A', 0, '2006-06-20 14:29:07', NULL, '2006-06-20 14:29:07');
2044INSERT INTO `user_enrols` VALUES (9, 1, 13, 'A', 0, '2006-06-20 14:31:17', NULL, '2006-06-20 14:31:17');
2045INSERT INTO `user_enrols` VALUES (11, 1, 15, 'A', 0, '2006-06-20 15:00:35', NULL, '2006-06-20 15:00:35');
2046INSERT INTO `user_enrols` VALUES (12, 2, 16, 'A', 0, '2006-06-20 15:01:09', NULL, '2006-06-20 15:01:09');
2047INSERT INTO `user_enrols` VALUES (13, 1, 17, 'A', 0, '2006-06-20 15:01:24', NULL, '2006-06-20 15:01:24');
2048INSERT INTO `user_enrols` VALUES (14, 2, 18, 'A', 0, '2006-06-20 15:01:52', NULL, '2006-06-20 15:01:52');
2049INSERT INTO `user_enrols` VALUES (15, 1, 19, 'A', 0, '2006-06-20 15:02:20', NULL, '2006-06-20 15:02:20');
2050INSERT INTO `user_enrols` VALUES (16, 2, 20, 'A', 0, '2006-06-20 15:03:27', NULL, '2006-06-20 15:03:27');
2051INSERT INTO `user_enrols` VALUES (17, 1, 21, 'A', 0, '2006-06-20 15:03:47', NULL, '2006-06-20 15:03:47');
2052INSERT INTO `user_enrols` VALUES (18, 2, 22, 'A', 0, '2006-06-20 15:04:22', NULL, '2006-06-20 15:04:22');
2053INSERT INTO `user_enrols` VALUES (19, 2, 23, 'A', 0, '2006-06-20 15:05:55', NULL, '2006-06-20 15:05:55');
2054INSERT INTO `user_enrols` VALUES (20, 2, 24, 'A', 0, '2006-06-20 15:06:20', NULL, '2006-06-20 15:06:20');
2055INSERT INTO `user_enrols` VALUES (21, 2, 25, 'A', 0, '2006-06-20 15:06:46', NULL, '2006-06-20 15:06:46');
2056INSERT INTO `user_enrols` VALUES (22, 1, 26, 'A', 0, '2006-06-20 15:07:01', NULL, '2006-06-20 15:07:01');
2057INSERT INTO `user_enrols` VALUES (23, 2, 27, 'A', 0, '2006-06-20 15:07:37', NULL, '2006-06-20 15:07:37');
2058INSERT INTO `user_enrols` VALUES (24, 1, 28, 'A', 0, '2006-06-20 15:08:04', NULL, '2006-06-20 15:08:04');
2059INSERT INTO `user_enrols` VALUES (25, 2, 29, 'A', 0, '2006-06-20 15:08:31', NULL, '2006-06-20 15:08:31');
2060INSERT INTO `user_enrols` VALUES (26, 2, 30, 'A', 0, '2006-06-20 15:08:47', NULL, '2006-06-20 15:08:47');
2061INSERT INTO `user_enrols` VALUES (27, 1, 31, 'A', 0, '2006-06-20 15:10:16', NULL, '2006-06-20 15:10:16');
2062INSERT INTO `user_enrols` VALUES (28, 1, 32, 'A', 0, '2006-06-20 15:10:32', NULL, '2006-06-20 15:10:32');
2063INSERT INTO `user_enrols` VALUES (29, 1, 33, 'A', 0, '2006-06-21 08:44:09', NULL, '2006-06-21 08:44:09');
2064INSERT INTO `user_enrols` VALUES (30, 2, 7, 'A', 0, '2006-06-21 08:44:09', NULL, '2006-06-21 08:44:09');
2065INSERT INTO `user_enrols` VALUES (31, 3, 33, 'A', 0, '2006-06-21 08:44:09', NULL, '2006-06-21 08:44:09');
2066INSERT INTO `user_enrols` VALUES (32, 3, 8, 'A', 0, '2006-06-21 08:44:09', NULL, '2006-06-21 08:44:09');
2067
2068-- --------------------------------------------------------
2069
2070--
2071-- Table structure for table `user_faculties`
2072--
2073
2074DROP TABLE IF EXISTS `user_faculties`;
2075CREATE TABLE `user_faculties` (
2076  `id` int NOT NULL auto_increment,
2077  `user_id` int NOT NULL,
2078  `faculty_id` int NOT NULL,
2079  FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
2080  FOREIGN KEY (`faculty_id`) REFERENCES `faculties` (`id`) ON DELETE CASCADE,
2081  PRIMARY KEY  (`id`)
2082) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2083
2084--
2085-- Dumping data for table `user_faculties`
2086--
2087
2088INSERT INTO `user_faculties` (`id`, `user_id`, `faculty_id`) VALUES
2089(1, 34, 1),
2090(2, 1, 1),
2091(3, 1, 2),
2092(4, 38, 2);
2093
2094-- --------------------------------------------------------
2095
2096--
2097-- Table structure for table `user_tutors`
2098--
2099
2100DROP TABLE IF EXISTS `user_tutors`;
2101CREATE TABLE IF NOT EXISTS `user_tutors` (
2102  `id` int(11) NOT NULL AUTO_INCREMENT,
2103  `user_id` int(11) NOT NULL DEFAULT '0',
2104  `course_id` int(11) NOT NULL DEFAULT '0',
2105  `creator_id` int(11) NOT NULL DEFAULT '0',
2106  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2107  `updater_id` int(11) DEFAULT NULL,
2108  `modified` datetime DEFAULT NULL,
2109  PRIMARY KEY (`id`),
2110  UNIQUE no_duplicates (`course_id`,`user_id`),
2111  FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
2112  FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE
2113) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2114
2115--
2116-- Dumping data for table `user_tutors`
2117--
2118
2119INSERT INTO user_tutors (id, user_id, course_id, creator_id, created, updater_id, modified) VALUES
2120(1, 35, 1, 0, '0000-00-00 00:00:00', NULL, '2012-07-13 09:45:57'),
2121(2, 36, 1, 0, '0000-00-00 00:00:00', NULL, '2012-07-13 09:48:16'),
2122(3, 37, 2, 0, '0000-00-00 00:00:00', NULL, '2012-07-13 09:48:24'),
2123(4, 37, 3, 0, '0000-00-00 00:00:00', NULL, '2012-07-13 09:48:24');
2124
2125SET foreign_key_checks = 1;
Note: See TracBrowser for help on using the repository browser.