source: iPeer/app/config/sql/ipeer.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: 56.9 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
558--
559-- Table structure for table `users`
560--
561
562DROP TABLE IF EXISTS `users`;
563CREATE TABLE IF NOT EXISTS `users` (
564  `id` int(11) NOT NULL AUTO_INCREMENT,
565  `username` varchar(80) NOT NULL DEFAULT '',
566  `password` varchar(80) NOT NULL DEFAULT '',
567  `first_name` varchar(80) DEFAULT NULL,
568  `last_name` varchar(80) DEFAULT NULL,
569  `student_no` varchar(30) DEFAULT NULL,
570  `title` varchar(80) DEFAULT NULL,
571  `email` varchar(80) DEFAULT NULL,
572  `last_login` datetime DEFAULT NULL,
573  `last_logout` datetime DEFAULT NULL,
574  `last_accessed` varchar(10) DEFAULT NULL,
575  `record_status` char(1) NOT NULL DEFAULT 'A',
576  `creator_id` int(11) NOT NULL DEFAULT '0',
577  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
578  `updater_id` int(11) DEFAULT NULL,
579  `modified` datetime DEFAULT NULL,
580  `lti_id` int DEFAULT NULL,
581  PRIMARY KEY (`id`),
582  UNIQUE KEY `username` (`username`),
583  UNIQUE (`lti_id`)
584) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
585
586--
587-- Dumping data for table `users`
588--
589
590INSERT 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
591(1, 'root', '', 'Super', 'Admin', NULL, NULL, '', NULL, NULL, NULL, 'A', 1, NOW(), NULL, NOW(), NULL);
592
593
594-- --------------------------------------------------------
595
596--
597-- Table structure for table `faculties`
598--
599
600DROP TABLE IF EXISTS `faculties`;
601CREATE TABLE IF NOT EXISTS `faculties` (
602  `id` int(11) NOT NULL AUTO_INCREMENT,
603  `name` varchar(80) NOT NULL,
604  `creator_id` int(11) NOT NULL DEFAULT '0',
605  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
606  `updater_id` int(11) DEFAULT NULL,
607  `modified` datetime DEFAULT NULL,
608  PRIMARY KEY (`id`),
609  UNIQUE (`name`)
610) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
611
612-- --------------------------------------------------------
613
614--
615-- Table structure for table `departments`
616--
617
618DROP TABLE IF EXISTS `departments`;
619CREATE TABLE IF NOT EXISTS `departments` (
620  `id` int(11) NOT NULL AUTO_INCREMENT,
621  `name` varchar(80) NOT NULL,
622  `faculty_id` int NOT NULL,
623  `creator_id` int(11) NOT NULL DEFAULT '0',
624  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
625  `updater_id` int(11) DEFAULT NULL,
626  `modified` datetime DEFAULT NULL,
627  FOREIGN KEY (`faculty_id`) REFERENCES `faculties` (`id`) ON DELETE CASCADE,
628  PRIMARY KEY (`id`),
629  UNIQUE (`name`)
630) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
631
632-- --------------------------------------------------------
633
634--
635-- Table structure for table `course_departments`
636--
637
638DROP TABLE IF EXISTS `course_departments`;
639CREATE TABLE `course_departments` (
640  `id` int NOT NULL auto_increment,
641  `course_id` int NOT NULL,
642  `department_id` int NOT NULL,
643  FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE,
644  FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE CASCADE,
645  PRIMARY KEY  (`id`)
646) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
647
648-- --------------------------------------------------------
649
650--
651-- Table structure for table `email_merges`
652--
653
654DROP TABLE IF EXISTS `email_merges`;
655CREATE TABLE IF NOT EXISTS `email_merges` (
656  `id` int(11) NOT NULL AUTO_INCREMENT,
657  `key` varchar(80) NOT NULL,
658  `value` varchar(80) NOT NULL,
659  `table_name` varchar(80) NOT NULL,
660  `field_name` varchar(80) NOT NULL,
661  `created` datetime NOT NULL,
662  `modified` datetime NOT NULL,
663  PRIMARY KEY (`id`)
664) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
665
666--
667-- Dumping data for table `email_merges`
668--
669
670INSERT INTO `email_merges` (`id`, `key`, `value`, `table_name`, `field_name`, `created`, `modified`) VALUES
671(1, 'Username', '{{{USERNAME}}}', 'User', 'username', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
672(2, 'First Name', '{{{FIRSTNAME}}}', 'User', 'first_name', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
673(3, 'Last Name', '{{{LASTNAME}}}', 'User', 'last_name', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
674(4, 'Email Address', '{{{Email}}}', 'User', 'email', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
675
676-- --------------------------------------------------------
677
678--
679-- Table structure for table `email_schedules`
680--
681
682DROP TABLE IF EXISTS `email_schedules`;
683CREATE TABLE IF NOT EXISTS `email_schedules` (
684  `id` int(11) NOT NULL AUTO_INCREMENT,
685  `subject` varchar(80) NOT NULL,
686  `content` text NOT NULL,
687  `date` datetime NOT NULL,
688  `from` varchar(80) NOT NULL,
689  `to` varchar(600) NOT NULL,
690  `course_id` int(11) DEFAULT NULL,
691  `event_id` int(11) DEFAULT NULL,
692  `grp_id` int(11) DEFAULT NULL,
693  `sent` tinyint(1) NOT NULL DEFAULT '0',
694  `creator_id` int(11) NOT NULL,
695  `created` datetime NOT NULL,
696  PRIMARY KEY (`id`)
697) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
698
699-- --------------------------------------------------------
700
701--
702-- Table structure for table `email_templates`
703--
704
705DROP TABLE IF EXISTS `email_templates`;
706CREATE TABLE IF NOT EXISTS `email_templates` (
707  `id` int(11) NOT NULL AUTO_INCREMENT,
708  `name` varchar(80) NOT NULL,
709  `description` text NOT NULL,
710  `subject` varchar(80) NOT NULL,
711  `content` text NOT NULL,
712  `availability` tinyint(4) NOT NULL,
713  `creator_id` int(11) NOT NULL DEFAULT '0',
714  `created` datetime NOT NULL DEFAULT '0000-00-00',
715  `updater_id` int(11) DEFAULT NULL,
716  `updated` datetime DEFAULT NULL,
717  PRIMARY KEY (`id`)
718) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
719
720INSERT INTO `email_templates` (`id`, `name`, `description`, `subject`, `content`, `availability`, `creator_id`, `created`, `updater_id`, `updated`) VALUES
721(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);
722
723-- --------------------------------------------------------
724
725--
726-- Table structure for table `evaluation_mixeval_details`
727--
728
729DROP TABLE IF EXISTS `evaluation_mixeval_details`;
730CREATE TABLE IF NOT EXISTS `evaluation_mixeval_details` (
731  `id` int(11) NOT NULL AUTO_INCREMENT,
732  `evaluation_mixeval_id` int(11) NOT NULL DEFAULT '0',
733  `question_number` int(11) NOT NULL DEFAULT '0',
734  `question_comment` text,
735  `selected_lom` int(11) NOT NULL DEFAULT '0',
736  `grade` double(12,2) NOT NULL DEFAULT '0.00',
737  `record_status` char(1) NOT NULL DEFAULT 'A',
738  `creator_id` int(11) NOT NULL DEFAULT '0',
739  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
740  `updater_id` int(11) DEFAULT NULL,
741  `modified` datetime DEFAULT NULL,
742  PRIMARY KEY (`id`),
743  UNIQUE KEY `evaluation_mixeval_id` (`evaluation_mixeval_id`,`question_number`)
744) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
745
746-- --------------------------------------------------------
747
748--
749-- Table structure for table `evaluation_mixevals`
750--
751
752DROP TABLE IF EXISTS `evaluation_mixevals`;
753CREATE TABLE IF NOT EXISTS `evaluation_mixevals` (
754  `id` int(11) NOT NULL AUTO_INCREMENT,
755  `evaluator` int(11) NOT NULL DEFAULT '0',
756  `evaluatee` int(11) NOT NULL DEFAULT '0',
757  `score` double(12,2) NOT NULL DEFAULT '0.00',
758  `comment_release` int(1) NOT NULL DEFAULT '0',
759  `grade_release` int(1) NOT NULL DEFAULT '0',
760  `grp_event_id` int(11) NOT NULL DEFAULT '0',
761  `event_id` int(11) NOT NULL DEFAULT '0',
762  `record_status` char(1) NOT NULL DEFAULT 'A',
763  `creator_id` int(11) NOT NULL DEFAULT '0',
764  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
765  `updater_id` int(11) DEFAULT NULL,
766  `modified` datetime DEFAULT NULL,
767  PRIMARY KEY (`id`)
768) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
769
770
771-- --------------------------------------------------------
772
773--
774-- Table structure for table `evaluation_rubric_details`
775--
776
777DROP TABLE IF EXISTS `evaluation_rubric_details`;
778CREATE TABLE IF NOT EXISTS `evaluation_rubric_details` (
779  `id` int(11) NOT NULL AUTO_INCREMENT,
780  `evaluation_rubric_id` int(11) NOT NULL DEFAULT '0',
781  `criteria_number` int(11) NOT NULL DEFAULT '0',
782  `criteria_comment` varchar(255) DEFAULT NULL,
783  `selected_lom` int(11) NOT NULL DEFAULT '0',
784  `grade` double(12,2) NOT NULL DEFAULT '0.00',
785  `record_status` char(1) NOT NULL DEFAULT 'A',
786  `creator_id` int(11) NOT NULL DEFAULT '0',
787  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
788  `updater_id` int(11) DEFAULT NULL,
789  `modified` datetime DEFAULT NULL,
790  PRIMARY KEY (`id`),
791  UNIQUE KEY `evaluation_rubric_id` (`evaluation_rubric_id`,`criteria_number`)
792) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
793
794-- --------------------------------------------------------
795
796--
797-- Table structure for table `evaluation_rubrics`
798--
799
800DROP TABLE IF EXISTS `evaluation_rubrics`;
801CREATE TABLE IF NOT EXISTS `evaluation_rubrics` (
802  `id` int(11) NOT NULL AUTO_INCREMENT,
803  `evaluator` int(11) NOT NULL DEFAULT '0',
804  `evaluatee` int(11) NOT NULL DEFAULT '0',
805  `comment` text,
806  `score` double(12,2) NOT NULL DEFAULT '0.00',
807  `comment_release` int(1) NOT NULL DEFAULT '0',
808  `grade_release` int(1) NOT NULL DEFAULT '0',
809  `grp_event_id` int(11) NOT NULL DEFAULT '0',
810  `event_id` int(11) NOT NULL DEFAULT '0',
811  `record_status` char(1) NOT NULL DEFAULT 'A',
812  `creator_id` int(11) NOT NULL DEFAULT '0',
813  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
814  `updater_id` int(11) DEFAULT NULL,
815  `modified` datetime DEFAULT NULL,
816  `rubric_id` int(11) NOT NULL DEFAULT '0',
817  PRIMARY KEY (`id`)
818) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
819
820-- --------------------------------------------------------
821
822--
823-- Table structure for table `evaluation_simples`
824--
825
826DROP TABLE IF EXISTS `evaluation_simples`;
827CREATE TABLE IF NOT EXISTS `evaluation_simples` (
828  `id` int(11) NOT NULL AUTO_INCREMENT,
829  `evaluator` int(11) NOT NULL DEFAULT '0',
830  `evaluatee` int(11) NOT NULL DEFAULT '0',
831  `score` int(5) NOT NULL DEFAULT '0',
832  `comment` text,
833  `release_status` int(1) NOT NULL DEFAULT '0',
834  `grp_event_id` int(11) NOT NULL DEFAULT '0',
835  `event_id` bigint(11) NOT NULL DEFAULT '0',
836  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
837  `grade_release` int(1) DEFAULT NULL,
838  `record_status` char(1) NOT NULL DEFAULT 'A',
839  `creator_id` int(11) NOT NULL DEFAULT '0',
840  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
841  `updater_id` int(11) DEFAULT NULL,
842  `modified` datetime DEFAULT NULL,
843  PRIMARY KEY (`id`)
844) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
845
846-- --------------------------------------------------------
847
848--
849-- Table structure for table `evaluation_submissions`
850--
851
852DROP TABLE IF EXISTS `evaluation_submissions`;
853CREATE TABLE IF NOT EXISTS `evaluation_submissions` (
854  `id` int(11) NOT NULL AUTO_INCREMENT,
855  `event_id` bigint(20) NOT NULL DEFAULT '0',
856  `grp_event_id` int(11) DEFAULT NULL,
857  `submitter_id` int(11) NOT NULL DEFAULT '0',
858  `submitted` tinyint(1) NOT NULL DEFAULT '0',
859  `date_submitted` datetime DEFAULT NULL,
860  `record_status` char(1) NOT NULL DEFAULT 'A',
861  `creator_id` int(11) NOT NULL DEFAULT '0',
862  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
863  `updater_id` int(11) DEFAULT NULL,
864  `modified` datetime DEFAULT NULL,
865  PRIMARY KEY (`id`),
866  UNIQUE KEY `grp_event_id` (`grp_event_id`,`submitter_id`)
867) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
868
869-- --------------------------------------------------------
870
871--
872-- Table structure for table `event_template_types`
873--
874
875DROP TABLE IF EXISTS `event_template_types`;
876CREATE TABLE IF NOT EXISTS `event_template_types` (
877  `id` int(11) NOT NULL AUTO_INCREMENT,
878  `type_name` varchar(50) NOT NULL DEFAULT '',
879  `table_name` varchar(50) NOT NULL DEFAULT '',
880  `model_name` varchar(80) NOT NULL DEFAULT '',
881  `display_for_selection` tinyint(1) NOT NULL DEFAULT '1',
882  `record_status` char(1) NOT NULL DEFAULT 'A',
883  `creator_id` int(11) NOT NULL DEFAULT '0',
884  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
885  `updater_id` int(11) DEFAULT NULL,
886  `modified` datetime DEFAULT NULL,
887  PRIMARY KEY (`id`),
888  UNIQUE KEY `type_name` (`type_name`),
889  UNIQUE KEY `table_name` (`table_name`)
890) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
891
892--
893-- Dumping data for table `event_template_types`
894--
895
896INSERT INTO `event_template_types` (`id`, `type_name`, `table_name`, `model_name`, `display_for_selection`, `record_status`, `creator_id`, `created`, `updater_id`, `modified`) VALUES
897(1, 'SIMPLE', 'simple_evaluations', 'SimpleEvaluation', 1, 'A', 0, '0000-00-00 00:00:00', NULL, NULL),
898(2, 'RUBRIC', 'rubrics', 'Rubric', 1, 'A', 0, '0000-00-00 00:00:00', NULL, NULL),
899(3, 'SURVEY', 'surveys', '', 1, 'A', 0, '0000-00-00 00:00:00', NULL, NULL),
900(4, 'MIX EVALUATION', 'mixevals', 'Mixeval', 1, 'A', 0, '2006-04-03 11:51:02', 0, '2006-04-06 15:31:48');
901
902-- --------------------------------------------------------
903
904--
905-- Table structure for table `events`
906--
907
908DROP TABLE IF EXISTS `events`;
909CREATE TABLE IF NOT EXISTS `events` (
910  `id` int(11) NOT NULL AUTO_INCREMENT,
911  `title` varchar(255) NOT NULL DEFAULT '',
912  `course_id` int(11) NOT NULL DEFAULT '0',
913  `description` text,
914  `event_template_type_id` int(20) NOT NULL DEFAULT '0',
915  `template_id` int(11) NOT NULL DEFAULT '2',
916  `self_eval` varchar(11) NOT NULL DEFAULT '',
917  `com_req` int(11) NOT NULL DEFAULT '0',
918  `due_date` datetime DEFAULT NULL,
919  `release_date_begin` datetime DEFAULT NULL,
920  `release_date_end` datetime DEFAULT NULL,
921  `result_release_date_begin` datetime DEFAULT NULL,
922  `result_release_date_end` datetime DEFAULT NULL,
923  `record_status` char(1) NOT NULL DEFAULT 'A',
924  `creator_id` int(11) NOT NULL DEFAULT '0',
925  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
926  `updater_id` int(11) DEFAULT NULL,
927  `modified` datetime DEFAULT NULL,
928  PRIMARY KEY (`id`)
929) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
930
931-- --------------------------------------------------------
932
933--
934-- Table structure for table `group_events`
935--
936
937DROP TABLE IF EXISTS `group_events`;
938CREATE TABLE IF NOT EXISTS `group_events` (
939  `id` int(11) NOT NULL AUTO_INCREMENT,
940  `group_id` int(11) NOT NULL DEFAULT '0',
941  `event_id` int(11) NOT NULL DEFAULT '0',
942  `marked` varchar(20) NOT NULL DEFAULT 'not reviewed',
943  `grade` double(12,2) DEFAULT NULL,
944  `grade_release_status` varchar(20) NOT NULL DEFAULT 'None',
945  `comment_release_status` varchar(20) NOT NULL DEFAULT 'None',
946  `record_status` char(1) NOT NULL DEFAULT 'A',
947  `creator_id` int(11) NOT NULL DEFAULT '0',
948  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
949  `updater_id` int(11) DEFAULT NULL,
950  `modified` datetime DEFAULT NULL,
951  PRIMARY KEY (`id`),
952  UNIQUE KEY `group_id` (`event_id`,`group_id`)
953) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
954
955-- --------------------------------------------------------
956
957--
958-- Table structure for table `groups`
959--
960
961DROP TABLE IF EXISTS `groups`;
962CREATE TABLE IF NOT EXISTS `groups` (
963  `id` int(11) NOT NULL AUTO_INCREMENT,
964  `group_num` int(4) NOT NULL DEFAULT '0',
965  `group_name` varchar(80) DEFAULT NULL,
966  `course_id` int(11) DEFAULT NULL,
967  `record_status` varchar(1) NOT NULL DEFAULT 'A',
968  `creator_id` int(11) NOT NULL DEFAULT '0',
969  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
970  `updater_id` int(11) DEFAULT NULL,
971  `modified` datetime DEFAULT NULL,
972  PRIMARY KEY (`id`)
973) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
974
975-- --------------------------------------------------------
976
977--
978-- Table structure for table `groups_members`
979--
980
981DROP TABLE IF EXISTS `groups_members`;
982CREATE TABLE IF NOT EXISTS `groups_members` (
983  `id` int(11) NOT NULL AUTO_INCREMENT,
984  `group_id` int(11) NOT NULL DEFAULT '0',
985  `user_id` int(11) NOT NULL DEFAULT '0',
986  PRIMARY KEY (`id`),
987  KEY `group_id` (`group_id`)
988) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
989
990-- --------------------------------------------------------
991
992--
993-- Table structure for table `mixevals`
994--
995
996DROP TABLE IF EXISTS `mixevals`;
997CREATE TABLE IF NOT EXISTS `mixevals` (
998  `id` int(11) NOT NULL AUTO_INCREMENT,
999  `name` varchar(80) NOT NULL DEFAULT '',
1000  `zero_mark` tinyint(1) NOT NULL DEFAULT '0',
1001  `total_question` int(11) NOT NULL DEFAULT '0',
1002  `lickert_question_max` int(11) NOT NULL DEFAULT '0',
1003  `scale_max` int(11) NOT NULL DEFAULT '0',
1004  `prefill_question_max` int(11) DEFAULT NULL,
1005  `availability` varchar(10) NOT NULL DEFAULT 'public',
1006  `creator_id` int(11) NOT NULL DEFAULT '0',
1007  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1008  `updater_id` int(11) DEFAULT NULL,
1009  `modified` datetime DEFAULT NULL,
1010  PRIMARY KEY (`id`)
1011) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
1012
1013--
1014-- Dumping data for table `mixevals`
1015--
1016
1017INSERT INTO `mixevals` (`id`, `name`, `zero_mark`, `total_question`, `lickert_question_max`, `scale_max`, `prefill_question_max`, `availability`, `creator_id`, `created`, `updater_id`, `modified`) VALUES
1018(1, 'Default Mix Evalution', 0, 7, 3, 5, 3, 'public', 1, '2006-09-12 13:34:30', 1, '2006-09-12 13:47:57');
1019
1020-- --------------------------------------------------------
1021
1022--
1023-- Table structure for table `mixevals_question_descs`
1024--
1025
1026DROP TABLE IF EXISTS `mixevals_question_descs`;
1027CREATE TABLE IF NOT EXISTS `mixevals_question_descs` (
1028  `id` int(11) NOT NULL AUTO_INCREMENT,
1029  `question_id` int(11) NOT NULL DEFAULT '0',
1030  `scale_level` int(11) NOT NULL DEFAULT '0',
1031  `descriptor` varchar(255) DEFAULT NULL,
1032  PRIMARY KEY (`id`),
1033  KEY `question_num` (`question_id`)
1034) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
1035
1036--
1037-- Dumping data for table `mixevals_question_descs`
1038--
1039
1040INSERT INTO `mixevals_question_descs` (`id`, `question_id`, `scale_level`, `descriptor`) VALUES
1041(1, 1, 1, 'Lowest'),
1042(2, 1, 2, NULL),
1043(3, 1, 3, 'Middle'),
1044(4, 1, 4, NULL),
1045(5, 1, 5, 'Highest'),
1046(6, 2, 1, 'Lowest'),
1047(7, 2, 2, NULL),
1048(8, 2, 3, 'Middle'),
1049(9, 2, 4, NULL),
1050(10, 2, 5, 'Highest'),
1051(11, 3, 1, 'Lowest'),
1052(12, 3, 2, NULL),
1053(13, 3, 3, 'Middle'),
1054(14, 3, 4, NULL),
1055(15, 3, 5, 'Highest');
1056
1057-- --------------------------------------------------------
1058
1059--
1060-- Table structure for table `mixevals_questions`
1061--
1062
1063DROP TABLE IF EXISTS `mixevals_questions`;
1064CREATE TABLE IF NOT EXISTS `mixevals_questions` (
1065  `id` int(11) NOT NULL AUTO_INCREMENT,
1066  `mixeval_id` int(11) NOT NULL DEFAULT '0',
1067  `question_num` int(11) NOT NULL DEFAULT '0',
1068  `title` text,
1069  `instructions` text,
1070  `question_type` char(1) DEFAULT NULL,
1071  `required` tinyint(1) NOT NULL DEFAULT '1',
1072  `multiplier` int(11) NOT NULL DEFAULT '0',
1073  `scale_level` int(11) NOT NULL DEFAULT '0',
1074  `response_type` char(1) DEFAULT NULL,
1075  PRIMARY KEY (`id`)
1076) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
1077
1078
1079-- --------------------------------------------------------
1080
1081--
1082-- Table structure for table `oauth_clients`
1083-- This stores OAuth client credentials (AKA: consumer key and secret).
1084-- Client credentails are used to identify client software.
1085--
1086DROP TABLE IF EXISTS `oauth_clients`;
1087CREATE TABLE IF NOT EXISTS `oauth_clients` (
1088  `id` int(11) NOT NULL AUTO_INCREMENT,
1089  `user_id` int(11) NOT NULL,
1090  `key` varchar(255) NOT NULL,
1091  `secret` varchar(255) NOT NULL,
1092  `comment` text DEFAULT '',
1093  `enabled` tinyint(1) DEFAULT 1,
1094  PRIMARY KEY (`id`),
1095  FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
1096) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1097
1098-- --------------------------------------------------------
1099
1100--
1101-- Table structure for table `oauth_nonces`
1102-- Stores nonces to defeat replay attacks.
1103--
1104DROP TABLE IF EXISTS `oauth_nonces`;
1105CREATE TABLE IF NOT EXISTS `oauth_nonces` (
1106  `id` int(11) NOT NULL AUTO_INCREMENT,
1107  `nonce` varchar(255) NOT NULL,
1108  `expires` TIMESTAMP NOT NULL,
1109  PRIMARY KEY (`id`)
1110) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1111
1112-- --------------------------------------------------------
1113--
1114-- Table structure for table `oauth_tokens`
1115-- This stores OAuth token credentials (AKA: access token and secret).
1116-- Token credentials are used to identify a user.
1117--
1118
1119DROP TABLE IF EXISTS `oauth_tokens`;
1120CREATE TABLE IF NOT EXISTS `oauth_tokens` (
1121  `id` int(11) NOT NULL AUTO_INCREMENT,
1122  `user_id` int(11) NOT NULL,
1123  `key` varchar(255) NOT NULL,
1124  `secret` varchar(255) NOT NULL,
1125  `expires` date NOT NULL,
1126  `comment` text DEFAULT '',
1127  `enabled` tinyint(1) DEFAULT 1,
1128  PRIMARY KEY (`id`),
1129  FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
1130) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1131
1132-- --------------------------------------------------------
1133
1134--
1135-- Table structure for table `penalties`
1136--
1137
1138DROP TABLE IF EXISTS `penalties`;
1139CREATE TABLE IF NOT EXISTS `penalties` (
1140  `id` int(11) NOT NULL AUTO_INCREMENT,
1141  `event_id` int(11) DEFAULT NULL,
1142  `days_late` int(11) NOT NULL,
1143  `percent_penalty` int(11) NOT NULL,
1144  PRIMARY KEY (`id`),
1145  FOREIGN KEY (`event_id`) REFERENCES `events` (`id`) ON DELETE CASCADE
1146) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=36 ;
1147
1148-- --------------------------------------------------------
1149
1150--
1151-- Table structure for table `personalizes`
1152--
1153
1154DROP TABLE IF EXISTS `personalizes`;
1155CREATE TABLE IF NOT EXISTS `personalizes` (
1156  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
1157  `user_id` int(11) NOT NULL DEFAULT '0',
1158  `attribute_code` varchar(80) DEFAULT NULL,
1159  `attribute_value` varchar(80) DEFAULT NULL,
1160  `created` datetime DEFAULT NULL,
1161  `updated` datetime DEFAULT NULL,
1162  PRIMARY KEY (`id`),
1163  KEY `user_id` (`user_id`,`attribute_code`)
1164) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
1165
1166-- --------------------------------------------------------
1167
1168--
1169-- Table structure for table `questions`
1170--
1171
1172DROP TABLE IF EXISTS `questions`;
1173CREATE TABLE IF NOT EXISTS `questions` (
1174  `id` int(11) NOT NULL AUTO_INCREMENT,
1175  `prompt` varchar(255) NOT NULL DEFAULT '',
1176  `type` varchar(1) DEFAULT NULL,
1177  `master` varchar(3) NOT NULL DEFAULT 'yes',
1178  PRIMARY KEY (`id`)
1179) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1180
1181-- --------------------------------------------------------
1182
1183--
1184-- Table structure for table `responses`
1185--
1186
1187DROP TABLE IF EXISTS `responses`;
1188CREATE TABLE IF NOT EXISTS `responses` (
1189  `id` int(11) NOT NULL AUTO_INCREMENT,
1190  `question_id` int(11) NOT NULL DEFAULT '0',
1191  `response` text NOT NULL,
1192  PRIMARY KEY (`id`)
1193) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1194
1195-- --------------------------------------------------------
1196
1197--
1198-- Table structure for table `roles`
1199--
1200
1201DROP TABLE IF EXISTS `roles`;
1202CREATE TABLE IF NOT EXISTS `roles` (
1203  `id` int(11) NOT NULL AUTO_INCREMENT,
1204  `name` varchar(255) NOT NULL,
1205  `created` datetime NOT NULL,
1206  `modified` datetime NOT NULL,
1207  PRIMARY KEY (`id`)
1208) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
1209
1210--
1211-- Dumping data for table `roles`
1212--
1213
1214INSERT INTO `roles` (`id`, `name`, `created`, `modified`) VALUES
1215(1, 'superadmin', '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1216(2, 'admin', '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1217(3, 'instructor', '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1218(4, 'tutor', '2010-10-27 16:17:29', '2010-10-27 16:17:29'),
1219(5, 'student', '2010-10-27 16:17:29', '2010-10-27 16:17:29');
1220
1221-- --------------------------------------------------------
1222
1223--
1224-- Table structure for table `roles_users`
1225--
1226
1227DROP TABLE IF EXISTS `roles_users`;
1228CREATE TABLE IF NOT EXISTS `roles_users` (
1229  `id` int(11) NOT NULL AUTO_INCREMENT,
1230  `role_id` int(11) NOT NULL,
1231  `user_id` int(11) NOT NULL,
1232  `created` datetime NOT NULL,
1233  `modified` datetime NOT NULL,
1234  PRIMARY KEY (`id`)
1235) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1236
1237--
1238-- Dumping data for table `roles_users`
1239--
1240
1241INSERT INTO `roles_users` (`role_id`, `user_id`, `created`, `modified`) VALUES
1242(1, 1, NOW(), NOW());
1243
1244-- --------------------------------------------------------
1245
1246--
1247-- Table structure for table `rubrics`
1248--
1249
1250DROP TABLE IF EXISTS `rubrics`;
1251CREATE TABLE IF NOT EXISTS `rubrics` (
1252  `id` int(11) NOT NULL AUTO_INCREMENT,
1253  `name` varchar(80) NOT NULL DEFAULT '',
1254  `zero_mark` tinyint(1) NOT NULL DEFAULT '0',
1255  `lom_max` int(11) DEFAULT NULL,
1256  `criteria` int(11) DEFAULT NULL,
1257  `availability` varchar(10) NOT NULL DEFAULT 'public',
1258  `template` varchar(20) NOT NULL DEFAULT 'horizontal',
1259  `creator_id` int(11) NOT NULL DEFAULT '0',
1260  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1261  `updater_id` int(11) DEFAULT NULL,
1262  `modified` datetime DEFAULT NULL,
1263  PRIMARY KEY (`id`)
1264) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1265
1266-- --------------------------------------------------------
1267
1268--
1269-- Table structure for table `rubrics_criteria_comments`
1270--
1271
1272DROP TABLE IF EXISTS `rubrics_criteria_comments`;
1273CREATE TABLE IF NOT EXISTS `rubrics_criteria_comments` (
1274  `id` int(11) NOT NULL AUTO_INCREMENT,
1275  `criteria_id` int(11) NOT NULL,
1276  `rubrics_loms_id` int(11) NOT NULL,
1277  `criteria_comment` varchar(255) DEFAULT NULL,
1278  PRIMARY KEY (`id`),
1279  KEY `criteria_id` (`criteria_id`),
1280  KEY `rubrics_loms_id` (`rubrics_loms_id`)
1281) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1282
1283-- --------------------------------------------------------
1284
1285--
1286-- Table structure for table `rubrics_criterias`
1287--
1288
1289DROP TABLE IF EXISTS `rubrics_criterias`;
1290CREATE TABLE IF NOT EXISTS `rubrics_criterias` (
1291  `id` int(11) NOT NULL AUTO_INCREMENT,
1292  `rubric_id` int(11) NOT NULL DEFAULT '0',
1293  `criteria_num` int(11) NOT NULL DEFAULT '999',
1294  `criteria` varchar(255) DEFAULT NULL,
1295  `multiplier` int(11) NOT NULL DEFAULT '0',
1296  PRIMARY KEY (`id`)
1297) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1298
1299-- --------------------------------------------------------
1300
1301--
1302-- Table structure for table `rubrics_loms`
1303--
1304
1305DROP TABLE IF EXISTS `rubrics_loms`;
1306CREATE TABLE IF NOT EXISTS `rubrics_loms` (
1307  `id` int(11) NOT NULL AUTO_INCREMENT,
1308  `rubric_id` int(11) NOT NULL DEFAULT '0',
1309  `lom_num` int(11) NOT NULL DEFAULT '999',
1310  `lom_comment` varchar(255) DEFAULT NULL,
1311  PRIMARY KEY (`id`)
1312) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1313
1314-- --------------------------------------------------------
1315
1316--
1317-- Table structure for table `simple_evaluations`
1318--
1319
1320DROP TABLE IF EXISTS `simple_evaluations`;
1321CREATE TABLE IF NOT EXISTS `simple_evaluations` (
1322  `id` int(11) NOT NULL AUTO_INCREMENT,
1323  `name` varchar(50) NOT NULL DEFAULT '',
1324  `description` text NOT NULL,
1325  `point_per_member` int(10) NOT NULL DEFAULT '0',
1326  `record_status` char(1) NOT NULL DEFAULT 'A',
1327  `availability` varchar(10) NOT NULL DEFAULT 'public',
1328  `creator_id` int(11) NOT NULL DEFAULT '0',
1329  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1330  `updater_id` int(11) DEFAULT NULL,
1331  `modified` datetime DEFAULT NULL,
1332  PRIMARY KEY (`id`)
1333) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1334
1335-- --------------------------------------------------------
1336
1337--
1338-- Table structure for table `survey_group_members`
1339--
1340
1341DROP TABLE IF EXISTS `survey_group_members`;
1342CREATE TABLE IF NOT EXISTS `survey_group_members` (
1343  `id` int(11) NOT NULL AUTO_INCREMENT,
1344  `group_set_id` int(11) DEFAULT '0',
1345  `group_id` int(11) NOT NULL DEFAULT '0',
1346  `user_id` int(11) NOT NULL DEFAULT '0',
1347  PRIMARY KEY (`id`)
1348) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1349
1350-- --------------------------------------------------------
1351
1352--
1353-- Table structure for table `survey_group_sets`
1354--
1355
1356DROP TABLE IF EXISTS `survey_group_sets`;
1357CREATE TABLE IF NOT EXISTS `survey_group_sets` (
1358  `id` int(11) NOT NULL AUTO_INCREMENT,
1359  `survey_id` int(11) NOT NULL DEFAULT '0',
1360  `set_description` text NOT NULL,
1361  `num_groups` int(11) NOT NULL DEFAULT '0',
1362  `date` int(11) NOT NULL DEFAULT '0',
1363  `released` int(1) NOT NULL DEFAULT '0',
1364  PRIMARY KEY (`id`),
1365  KEY `survey_id` (`survey_id`)
1366) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1367
1368-- --------------------------------------------------------
1369
1370--
1371-- Table structure for table `survey_groups`
1372--
1373
1374DROP TABLE IF EXISTS `survey_groups`;
1375CREATE TABLE IF NOT EXISTS `survey_groups` (
1376  `id` int(11) NOT NULL AUTO_INCREMENT,
1377  `group_set_id` int(11) NOT NULL DEFAULT '0',
1378  `group_number` int(11) NOT NULL DEFAULT '0',
1379  PRIMARY KEY (`id`)
1380) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1381
1382-- --------------------------------------------------------
1383
1384--
1385-- Table structure for table `survey_inputs`
1386--
1387
1388DROP TABLE IF EXISTS `survey_inputs`;
1389CREATE TABLE IF NOT EXISTS `survey_inputs` (
1390  `id` int(11) NOT NULL AUTO_INCREMENT,
1391  `event_id` int(11) NOT NULL DEFAULT '0',
1392  `user_id` int(11) NOT NULL DEFAULT '0',
1393  `question_id` int(11) NOT NULL DEFAULT '0',
1394  `sub_id` int(11) DEFAULT NULL,
1395  `chkbx_id` int(11) DEFAULT NULL,
1396  `response_text` text,
1397  `response_id` int(11) DEFAULT NULL,
1398  PRIMARY KEY (`id`)
1399) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1400
1401-- --------------------------------------------------------
1402
1403--
1404-- Table structure for table `survey_questions`
1405--
1406
1407DROP TABLE IF EXISTS `survey_questions`;
1408CREATE TABLE IF NOT EXISTS `survey_questions` (
1409  `id` int(11) NOT NULL AUTO_INCREMENT,
1410  `survey_id` int(11) NOT NULL DEFAULT '0',
1411  `number` int(11) NOT NULL DEFAULT '9999',
1412  `question_id` int(11) NOT NULL DEFAULT '0',
1413  PRIMARY KEY (`id`),
1414  KEY `question_id` (`question_id`),
1415  KEY `survey_id` (`survey_id`)
1416) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1417
1418-- --------------------------------------------------------
1419
1420--
1421-- Table structure for table `surveys`
1422--
1423
1424DROP TABLE IF EXISTS `surveys`;
1425CREATE TABLE IF NOT EXISTS `surveys` (
1426  `id` int(11) NOT NULL AUTO_INCREMENT,
1427  `course_id` int(11) NOT NULL DEFAULT '0',
1428  `user_id` int(11) NOT NULL DEFAULT '1',
1429  `name` varchar(255) NOT NULL,
1430  `availability` varchar(10) NOT NULL DEFAULT 'public',
1431  `due_date` datetime DEFAULT NULL,
1432  `release_date_begin` datetime DEFAULT NULL,
1433  `release_date_end` datetime DEFAULT NULL,
1434  `released` tinyint(1) NOT NULL DEFAULT '0',
1435  `creator_id` int(11) NOT NULL DEFAULT '0',
1436  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1437  `updater_id` int(11) DEFAULT NULL,
1438  `modified` datetime DEFAULT NULL,
1439  PRIMARY KEY (`id`)
1440) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1441
1442-- --------------------------------------------------------
1443
1444--
1445-- Table structure for table `sys_parameters`
1446--
1447
1448DROP TABLE IF EXISTS `sys_parameters`;
1449CREATE TABLE IF NOT EXISTS `sys_parameters` (
1450  `id` int(11) NOT NULL AUTO_INCREMENT,
1451  `parameter_code` varchar(80) NOT NULL DEFAULT '',
1452  `parameter_value` text,
1453  `parameter_type` char(1) NOT NULL DEFAULT '',
1454  `description` varchar(255) DEFAULT NULL,
1455  `record_status` char(1) NOT NULL DEFAULT 'A',
1456  `creator_id` int(11) NOT NULL DEFAULT '0',
1457  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1458  `updater_id` int(11) DEFAULT NULL,
1459  `modified` datetime DEFAULT NULL,
1460  PRIMARY KEY (`id`),
1461  UNIQUE KEY `parameter_code` (`parameter_code`)
1462) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 ;
1463
1464--
1465-- Dumping data for table `sys_parameters`
1466--
1467
1468INSERT INTO `sys_parameters` (`id`, `parameter_code`, `parameter_value`, `parameter_type`, `description`, `record_status`, `creator_id`, `created`, `updater_id`, `modified`) VALUES
1469(1, 'system.soft_delete_enable', 'true', 'B', 'Whether soft deletion of records is enabled.', 'A', 0, NOW(), 0, NOW()),
1470(2, 'system.debug_mode', '0', 'I', 'Debug Mode of the system', 'A', 0, NOW(), NULL, NOW()),
1471(3, 'system.debug_verbosity', '1', 'I', NULL, 'A', 0, NOW(), NULL, NOW()),
1472(6, 'system.super_admin', 'root', 'S', NULL, 'A', 0, NOW(), NULL, NOW()),
1473(7, 'system.upload_dir', 'uploads/', 'S', NULL, 'A', 0, NOW(), NULL, NOW()),
1474(9, 'display.page_title', 'iPeer v2 with TeamMaker', 'S', 'Page title show in HTML.', 'A', 0, NOW(), 0, NOW()),
1475(10, 'display.logo_file', 'LayoutLogoDefault.gif', 'S', 'Logo image name.', 'A', 0, NOW(), 0, NOW()),
1476(11, 'display.login_logo_file', 'LayoutLoginLogoDefault.gif', 'S', 'Login Image File Name.', 'A', 0, NOW(), 0, NOW()),
1477(13, 'custom.login_control', 'ipeer', 'S', 'The login control for iPeer: ipeer; CWL: UBC_CWL', 'A', 0, NOW(), NULL, NOW()),
1478(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()),
1479(15, 'system.admin_email', 'Please enter the iPeer administrator\\''s email address.', 'S', NULL, 'A', 0, NOW(), NULL, NOW()),
1480(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()),
1481(17, 'system.password_reset_emailsubject', 'iPeer Password Reset Notification', 'S', NULL, 'A', 0, NOW(), NULL, NOW()),
1482(18, 'display.date_format', 'D, M j, Y g:i a', 'S', 'date format preference', 'A', 0, NOW(), NULL, NOW()),
1483(20, 'database.version', '4', 'I', 'database version', 'A', 0, NOW(), NULL, NOW()),
1484(21, 'email.port', '25', 'S', 'port number for email smtp option', 'A', '0', NOW(), NULL , NOW()),
1485(22, 'email.host', 'localhost', 'S', 'host address for email smtp option', 'A', '0', NOW(), NULL , NOW()),
1486(23, 'email.username', '', 'S', 'username for email smtp option', 'A', '0', NOW(), NULL , NOW()),
1487(24, 'email.password', '', 'S', 'password for email smtp option', 'A', '0', NOW(), NULL , NOW()),
1488(25, 'display.contact_info', 'noreply@ipeer.ctlt.ubc.ca', 'S', 'Contact Info', 'A', 0, NOW(), 0, NOW()),
1489(26, 'display.login.header', '', 'S', 'Login Info Header', 'A', 0, NOW(), 0, NOW()),
1490(27, 'display.login.footer', '', 'S', 'Login Info Footer', 'A', 0, NOW(), 0, NOW()),
1491(28, 'display.vocabulary.department', 'Department', 'S', 'Department vocabulary', 'A', 0, NOW(), 0, NOW());
1492
1493-- --------------------------------------------------------
1494
1495--
1496-- Table structure for table `user_courses`
1497--
1498
1499DROP TABLE IF EXISTS `user_courses`;
1500CREATE TABLE IF NOT EXISTS `user_courses` (
1501  `id` int(11) NOT NULL AUTO_INCREMENT,
1502  `user_id` int(11) NOT NULL DEFAULT '0',
1503  `course_id` int(11) NOT NULL DEFAULT '0',
1504  `access_right` varchar(1) NOT NULL DEFAULT 'O',
1505  `record_status` varchar(1) NOT NULL DEFAULT 'A',
1506  `creator_id` int(11) NOT NULL DEFAULT '0',
1507  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1508  `updater_id` int(11) DEFAULT NULL,
1509  `modified` datetime DEFAULT NULL,
1510  PRIMARY KEY (`id`),
1511  UNIQUE no_duplicates (`course_id`,`user_id`),
1512  FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
1513  FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE
1514) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1515
1516-- --------------------------------------------------------
1517
1518--
1519-- Table structure for table `user_enrols`
1520--
1521
1522DROP TABLE IF EXISTS `user_enrols`;
1523CREATE TABLE IF NOT EXISTS `user_enrols` (
1524  `id` int(11) NOT NULL AUTO_INCREMENT,
1525  `course_id` int(11) NOT NULL DEFAULT '0',
1526  `user_id` int(11) NOT NULL DEFAULT '0',
1527  `record_status` varchar(1) NOT NULL DEFAULT 'A',
1528  `creator_id` int(11) NOT NULL DEFAULT '0',
1529  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1530  `updater_id` int(11) DEFAULT NULL,
1531  `modified` datetime DEFAULT NULL,
1532  PRIMARY KEY (`id`),
1533  UNIQUE no_duplicates (`course_id`,`user_id`),
1534  FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
1535  FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE
1536) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1537
1538-- --------------------------------------------------------
1539
1540--
1541-- Table structure for table `user_faculties`
1542--
1543
1544DROP TABLE IF EXISTS `user_faculties`;
1545CREATE TABLE `user_faculties` (
1546  `id` int NOT NULL auto_increment,
1547  `user_id` int NOT NULL,
1548  `faculty_id` int NOT NULL,
1549  FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
1550  FOREIGN KEY (`faculty_id`) REFERENCES `faculties` (`id`) ON DELETE CASCADE,
1551  PRIMARY KEY  (`id`)
1552) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1553
1554-- --------------------------------------------------------
1555
1556--
1557-- Table structure for table `user_tutors`
1558--
1559
1560DROP TABLE IF EXISTS `user_tutors`;
1561CREATE TABLE IF NOT EXISTS `user_tutors` (
1562  `id` int(11) NOT NULL AUTO_INCREMENT,
1563  `user_id` int(11) NOT NULL DEFAULT '0',
1564  `course_id` int(11) NOT NULL DEFAULT '0',
1565  `creator_id` int(11) NOT NULL DEFAULT '0',
1566  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1567  `updater_id` int(11) DEFAULT NULL,
1568  `modified` datetime DEFAULT NULL,
1569  PRIMARY KEY (`id`),
1570  UNIQUE no_duplicates (`course_id`,`user_id`),
1571  FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
1572  FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE
1573) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1574
1575
1576SET foreign_key_checks = 1;
Note: See TracBrowser for help on using the repository browser.