<commit_before>-- phpMyAdmin SQL Dump
-- version 2.6.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 27, 2006 at 10:51 AM
-- Server version: 4.1.11
-- PHP Version: 4.3.10-16
--
-- Database: `ipeer2`
--

-- --------------------------------------------------------

--
-- Table structure for table `acos`
--

DROP TABLE IF EXISTS `acos`;
CREATE TABLE IF NOT EXISTS `acos` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) DEFAULT NULL,
  `model` varchar(255) DEFAULT NULL,
  `foreign_key` int(10) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `lft` int(10) DEFAULT NULL,
  `rght` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`),
  KEY `alias` (`alias`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=365 ;

--
-- Dumping data for table `acos`
--

INSERT INTO `acos` (`id`, `parent_id`, `model`, `foreign_key`, `alias`, `lft`, `rght`) VALUES
(1, NULL, NULL, NULL, 'adminpage', 1, 2),
(2, NULL, NULL, NULL, 'controllers', 3, 692),
(3, 2, NULL, NULL, 'Pages', 4, 19),
(4, 3, NULL, NULL, 'display', 5, 6),
(5, 3, NULL, NULL, 'extractModel', 7, 8),
(6, 3, NULL, NULL, 'add', 9, 10),
(7, 3, NULL, NULL, 'edit', 11, 12),
(8, 3, NULL, NULL, 'index', 13, 14),
(9, 3, NULL, NULL, 'view', 15, 16),
(10, 3, NULL, NULL, 'delete', 17, 18),
(11, 2, NULL, NULL, 'Courses', 20, 47),
(12, 11, NULL, NULL, 'daysLate', 21, 22),
(13, 11, NULL, NULL, 'index', 23, 24),
(14, 11, NULL, NULL, 'ajaxList', 25, 26),
(15, 11, NULL, NULL, 'view', 27, 28),
(16, 11, NULL, NULL, 'home', 29, 30),
(17, 11, NULL, NULL, 'add', 31, 32),
(18, 11, NULL, NULL, 'edit', 33, 34),
(19, 11, NULL, NULL, 'delete', 35, 36),
(20, 11, NULL, NULL, 'addInstructor', 37, 38),
(21, 11, NULL, NULL, 'deleteInstructor', 39, 40),
(22, 11, NULL, NULL, 'checkDuplicateName', 41, 42),
(23, 11, NULL, NULL, 'update', 43, 44),
(24, 11, NULL, NULL, 'extractModel', 45, 46),
(25, 2, NULL, NULL, 'Departments', 48, 61),
(26, 25, NULL, NULL, 'index', 49, 50),
(27, 25, NULL, NULL, 'view', 51, 52),
(28, 25, NULL, NULL, 'add', 53, 54),
(29, 25, NULL, NULL, 'edit', 55, 56),
(30, 25, NULL, NULL, 'delete', 57, 58),
(31, 25, NULL, NULL, 'extractModel', 59, 60),
(32, 2, NULL, NULL, 'Emailer', 62, 95),
(33, 32, NULL, NULL, 'setUpAjaxList', 63, 64),
(34, 32, NULL, NULL, 'ajaxList', 65, 66),
(35, 32, NULL, NULL, 'index', 67, 68),
(36, 32, NULL, NULL, 'write', 69, 70),
(37, 32, NULL, NULL, 'cancel', 71, 72),
(38, 32, NULL, NULL, 'view', 73, 74),
(39, 32, NULL, NULL, 'addRecipient', 75, 76),
(40, 32, NULL, NULL, 'deleteRecipient', 77, 78),
(41, 32, NULL, NULL, 'getRecipient', 79, 80),
(42, 32, NULL, NULL, 'searchByUserId', 81, 82),
(43, 32, NULL, NULL, 'doMerge', 83, 84),
(44, 32, NULL, NULL, 'send', 85, 86),
(45, 32, NULL, NULL, 'extractModel', 87, 88),
(46, 32, NULL, NULL, 'add', 89, 90),
(47, 32, NULL, NULL, 'edit', 91, 92),
(48, 32, NULL, NULL, 'delete', 93, 94),
(49, 2, NULL, NULL, 'Emailtemplates', 96, 117),
(50, 49, NULL, NULL, 'setUpAjaxList', 97, 98),
(51, 49, NULL, NULL, 'ajaxList', 99, 100),
(52, 49, NULL, NULL, 'index', 101, 102),
(53, 49, NULL, NULL, 'add', 103, 104),
(54, 49, NULL, NULL, 'edit', 105, 106),
(55, 49, NULL, NULL, 'delete', 107, 108),
(56, 49, NULL, NULL, 'view', 109, 110),
(57, 49, NULL, NULL, 'displayTemplateContent', 111, 112),
(58, 49, NULL, NULL, 'displayTemplateSubject', 113, 114),
(59, 49, NULL, NULL, 'extractModel', 115, 116),
(60, 2, NULL, NULL, 'Evaltools', 118, 133),
(61, 60, NULL, NULL, 'index', 119, 120),
(62, 60, NULL, NULL, 'showAll', 121, 122),
(63, 60, NULL, NULL, 'extractModel', 123, 124),
(64, 60, NULL, NULL, 'add', 125, 126),
(65, 60, NULL, NULL, 'edit', 127, 128),
(66, 60, NULL, NULL, 'view', 129, 130),
(67, 60, NULL, NULL, 'delete', 131, 132),
(68, 2, NULL, NULL, 'Evaluations', 134, 209),
(69, 68, NULL, NULL, 'postProcess', 135, 136),
(70, 68, NULL, NULL, 'setUpAjaxList', 137, 138),
(71, 68, NULL, NULL, 'ajaxList', 139, 140),
(72, 68, NULL, NULL, 'view', 141, 142),
(73, 68, NULL, NULL, 'index', 143, 144),
(74, 68, NULL, NULL, 'search', 145, 146),
(75, 68, NULL, NULL, 'update', 147, 148),
(76, 68, NULL, NULL, 'test', 149, 150),
(77, 68, NULL, NULL, 'export', 151, 152),
(78, 68, NULL, NULL, 'makeSimpleEvaluation', 153, 154),
(79, 68, NULL, NULL, 'validSimpleEvalComplete', 155, 156),
(80, 68, NULL, NULL, 'makeSurveyEvaluation', 157, 158),
(81, 68, NULL, NULL, 'validSurveyEvalComplete', 159, 160),
(82, 68, NULL, NULL, 'makeRubricEvaluation', 161, 162),
(83, 68, NULL, NULL, 'validRubricEvalComplete', 163, 164),
(84, 68, NULL, NULL, 'completeEvaluationRubric', 165, 166),
(85, 68, NULL, NULL, 'makeMixevalEvaluation', 167, 168),
(86, 68, NULL, NULL, 'validMixevalEvalComplete', 169, 170),
(87, 68, NULL, NULL, 'completeEvaluationMixeval', 171, 172),
(88, 68, NULL, NULL, 'viewEvaluationResults', 173, 174),
(89, 68, NULL, NULL, 'viewSurveyGroupEvaluationResults', 175, 176),
(90, 68, NULL, NULL, 'studentViewEvaluationResult', 177, 178),
(91, 68, NULL, NULL, 'markEventReviewed', 179, 180),
(92, 68, NULL, NULL, 'markGradeRelease', 181, 182),
(93, 68, NULL, NULL, 'markCommentRelease', 183, 184),
(94, 68, NULL, NULL, 'changeAllCommentRelease', 185, 186),
(95, 68, NULL, NULL, 'changeAllGradeRelease', 187, 188),
(96, 68, NULL, NULL, 'viewGroupSubmissionDetails', 189, 190),
(97, 68, NULL, NULL, 'reReleaseEvaluation', 191, 192),
(98, 68, NULL, NULL, 'viewSurveySummary', 193, 194),
(99, 68, NULL, NULL, 'export_rubic', 195, 196),
(100, 68, NULL, NULL, 'export_test', 197, 198),
(101, 68, NULL, NULL, 'pre', 199, 200),
(102, 68, NULL, NULL, 'extractModel', 201, 202),
(103, 68, NULL, NULL, 'add', 203, 204),
(104, 68, NULL, NULL, 'edit', 205, 206),
(105, 68, NULL, NULL, 'delete', 207, 208),
(106, 2, NULL, NULL, 'Events', 210, 243),
(107, 106, NULL, NULL, 'postProcessData', 211, 212),
(108, 106, NULL, NULL, 'setUpAjaxList', 213, 214),
(109, 106, NULL, NULL, 'index', 215, 216),
(110, 106, NULL, NULL, 'ajaxList', 217, 218),
(111, 106, NULL, NULL, 'view', 219, 220),
(112, 106, NULL, NULL, 'eventTemplatesList', 221, 222),
(113, 106, NULL, NULL, 'add', 223, 224),
(114, 106, NULL, NULL, 'edit', 225, 226),
(115, 106, NULL, NULL, 'delete', 227, 228),
(116, 106, NULL, NULL, 'search', 229, 230),
(117, 106, NULL, NULL, 'checkDuplicateTitle', 231, 232),
(118, 106, NULL, NULL, 'viewGroups', 233, 234),
(119, 106, NULL, NULL, 'editGroup', 235, 236),
(120, 106, NULL, NULL, 'getAssignedGroups', 237, 238),
(121, 106, NULL, NULL, 'update', 239, 240),
(122, 106, NULL, NULL, 'extractModel', 241, 242),
(123, 2, NULL, NULL, 'Faculties', 244, 257),
(124, 123, NULL, NULL, 'index', 245, 246),
(125, 123, NULL, NULL, 'view', 247, 248),
(126, 123, NULL, NULL, 'add', 249, 250),
(127, 123, NULL, NULL, 'edit', 251, 252),
(128, 123, NULL, NULL, 'delete', 253, 254),
(129, 123, NULL, NULL, 'extractModel', 255, 256),
(130, 2, NULL, NULL, 'Framework', 258, 277),
(131, 130, NULL, NULL, 'calendarDisplay', 259, 260),
(132, 130, NULL, NULL, 'userInfoDisplay', 261, 262),
(133, 130, NULL, NULL, 'tutIndex', 263, 264),
(134, 130, NULL, NULL, 'extractModel', 265, 266),
(135, 130, NULL, NULL, 'add', 267, 268),
(136, 130, NULL, NULL, 'edit', 269, 270),
(137, 130, NULL, NULL, 'index', 271, 272),
(138, 130, NULL, NULL, 'view', 273, 274),
(139, 130, NULL, NULL, 'delete', 275, 276),
(140, 2, NULL, NULL, 'Groups', 278, 313),
(141, 140, NULL, NULL, 'postProcess', 279, 280),
(142, 140, NULL, NULL, 'setUpAjaxList', 281, 282),
(143, 140, NULL, NULL, 'index', 283, 284),
(144, 140, NULL, NULL, 'ajaxList', 285, 286),
(145, 140, NULL, NULL, 'goToClassList', 287, 288),
(146, 140, NULL, NULL, 'view', 289, 290),
(147, 140, NULL, NULL, 'add', 291, 292),
(148, 140, NULL, NULL, 'edit', 293, 294),
(149, 140, NULL, NULL, 'delete', 295, 296),
(150, 140, NULL, NULL, 'checkDuplicateName', 297, 298),
(151, 140, NULL, NULL, 'getQueryAttribute', 299, 300),
(152, 140, NULL, NULL, 'import', 301, 302),
(153, 140, NULL, NULL, 'addGroupByImport', 303, 304),
(154, 140, NULL, NULL, 'update', 305, 306),
(155, 140, NULL, NULL, 'export', 307, 308),
(156, 140, NULL, NULL, 'sendGroupEmail', 309, 310),
(157, 140, NULL, NULL, 'extractModel', 311, 312),
(158, 2, NULL, NULL, 'Home', 314, 329),
(159, 158, NULL, NULL, 'index', 315, 316),
(160, 158, NULL, NULL, 'studentIndex', 317, 318),
(161, 158, NULL, NULL, 'extractModel', 319, 320),
(162, 158, NULL, NULL, 'add', 321, 322),
(163, 158, NULL, NULL, 'edit', 323, 324),
(164, 158, NULL, NULL, 'view', 325, 326),
(165, 158, NULL, NULL, 'delete', 327, 328),
(166, 2, NULL, NULL, 'Install', 330, 351),
(167, 166, NULL, NULL, 'index', 331, 332),
(168, 166, NULL, NULL, 'install2', 333, 334),
(169, 166, NULL, NULL, 'install3', 335, 336),
(170, 166, NULL, NULL, 'install4', 337, 338),
(171, 166, NULL, NULL, 'install5', 339, 340),
(172, 166, NULL, NULL, 'gpl', 341, 342),
(173, 166, NULL, NULL, 'add', 343, 344),
(174, 166, NULL, NULL, 'edit', 345, 346),
(175, 166, NULL, NULL, 'view', 347, 348),
(176, 166, NULL, NULL, 'delete', 349, 350),
(177, 2, NULL, NULL, 'Lti', 352, 365),
(178, 177, NULL, NULL, 'index', 353, 354),
(179, 177, NULL, NULL, 'extractModel', 355, 356),
(180, 177, NULL, NULL, 'add', 357, 358),
(181, 177, NULL, NULL, 'edit', 359, 360),
(182, 177, NULL, NULL, 'view', 361, 362),
(183, 177, NULL, NULL, 'delete', 363, 364),
(184, 2, NULL, NULL, 'Mixevals', 366, 397),
(185, 184, NULL, NULL, 'postProcess', 367, 368),
(186, 184, NULL, NULL, 'setUpAjaxList', 369, 370),
(187, 184, NULL, NULL, 'index', 371, 372),
(188, 184, NULL, NULL, 'ajaxList', 373, 374),
(189, 184, NULL, NULL, 'view', 375, 376),
(190, 184, NULL, NULL, 'add', 377, 378),
(191, 184, NULL, NULL, 'deleteQuestion', 379, 380),
(192, 184, NULL, NULL, 'deleteDescriptor', 381, 382),
(193, 184, NULL, NULL, 'edit', 383, 384),
(194, 184, NULL, NULL, 'copy', 385, 386),
(195, 184, NULL, NULL, 'delete', 387, 388),
(196, 184, NULL, NULL, 'previewMixeval', 389, 390),
(197, 184, NULL, NULL, 'renderRows', 391, 392),
(198, 184, NULL, NULL, 'update', 393, 394),
(199, 184, NULL, NULL, 'extractModel', 395, 396),
(200, 2, NULL, NULL, 'Penalty', 398, 413),
(201, 200, NULL, NULL, 'save', 399, 400),
(202, 200, NULL, NULL, 'extractModel', 401, 402),
(203, 200, NULL, NULL, 'add', 403, 404),
(204, 200, NULL, NULL, 'edit', 405, 406),
(205, 200, NULL, NULL, 'index', 407, 408),
(206, 200, NULL, NULL, 'view', 409, 410),
(207, 200, NULL, NULL, 'delete', 411, 412),
(208, 2, NULL, NULL, 'Rubrics', 414, 437),
(209, 208, NULL, NULL, 'postProcess', 415, 416),
(210, 208, NULL, NULL, 'setUpAjaxList', 417, 418),
(211, 208, NULL, NULL, 'index', 419, 420),
(212, 208, NULL, NULL, 'ajaxList', 421, 422),
(213, 208, NULL, NULL, 'view', 423, 424),
(214, 208, NULL, NULL, 'add', 425, 426),
(215, 208, NULL, NULL, 'edit', 427, 428),
(216, 208, NULL, NULL, 'copy', 429, 430),
(217, 208, NULL, NULL, 'delete', 431, 432),
(218, 208, NULL, NULL, 'setForm_RubricName', 433, 434),
(219, 208, NULL, NULL, 'extractModel', 435, 436),
(220, 2, NULL, NULL, 'Searchs', 438, 467),
(221, 220, NULL, NULL, 'update', 439, 440),
(222, 220, NULL, NULL, 'index', 441, 442),
(223, 220, NULL, NULL, 'searchEvaluation', 443, 444),
(224, 220, NULL, NULL, 'searchResult', 445, 446),
(225, 220, NULL, NULL, 'searchInstructor', 447, 448),
(226, 220, NULL, NULL, 'eventBoxSearch', 449, 450),
(227, 220, NULL, NULL, 'formatSearchEvaluation', 451, 452),
(228, 220, NULL, NULL, 'formatSearchInstructor', 453, 454),
(229, 220, NULL, NULL, 'formatSearchEvaluationResult', 455, 456),
(230, 220, NULL, NULL, 'extractModel', 457, 458),
(231, 220, NULL, NULL, 'add', 459, 460),
(232, 220, NULL, NULL, 'edit', 461, 462),
(233, 220, NULL, NULL, 'view', 463, 464),
(234, 220, NULL, NULL, 'delete', 465, 466),
(235, 2, NULL, NULL, 'Simpleevaluations', 468, 489),
(236, 235, NULL, NULL, 'postProcess', 469, 470),
(237, 235, NULL, NULL, 'setUpAjaxList', 471, 472),
(238, 235, NULL, NULL, 'index', 473, 474),
(239, 235, NULL, NULL, 'ajaxList', 475, 476),
(240, 235, NULL, NULL, 'view', 477, 478),
(241, 235, NULL, NULL, 'add', 479, 480),
(242, 235, NULL, NULL, 'edit', 481, 482),
(243, 235, NULL, NULL, 'copy', 483, 484),
(244, 235, NULL, NULL, 'delete', 485, 486),
(245, 235, NULL, NULL, 'extractModel', 487, 488),
(246, 2, NULL, NULL, 'Surveygroups', 490, 523),
(247, 246, NULL, NULL, 'postProcess', 491, 492),
(248, 246, NULL, NULL, 'setUpAjaxList', 493, 494),
(249, 246, NULL, NULL, 'index', 495, 496),
(250, 246, NULL, NULL, 'ajaxList', 497, 498),
(251, 246, NULL, NULL, 'viewresult', 499, 500),
(252, 246, NULL, NULL, 'makegroups', 501, 502),
(253, 246, NULL, NULL, 'makegroupssearch', 503, 504),
(254, 246, NULL, NULL, 'maketmgroups', 505, 506),
(255, 246, NULL, NULL, 'savegroups', 507, 508),
(256, 246, NULL, NULL, 'release', 509, 510),
(257, 246, NULL, NULL, 'delete', 511, 512),
(258, 246, NULL, NULL, 'edit', 513, 514),
(259, 246, NULL, NULL, 'changegroupset', 515, 516),
(260, 246, NULL, NULL, 'extractModel', 517, 518),
(261, 246, NULL, NULL, 'add', 519, 520),
(262, 246, NULL, NULL, 'view', 521, 522),
(263, 2, NULL, NULL, 'Surveys', 524, 559),
(264, 263, NULL, NULL, 'setUpAjaxList', 525, 526),
(265, 263, NULL, NULL, 'index', 527, 528),
(266, 263, NULL, NULL, 'ajaxList', 529, 530),
(267, 263, NULL, NULL, 'view', 531, 532),
(268, 263, NULL, NULL, 'add', 533, 534),
(269, 263, NULL, NULL, 'edit', 535, 536),
(270, 263, NULL, NULL, 'copy', 537, 538),
(271, 263, NULL, NULL, 'delete', 539, 540),
(272, 263, NULL, NULL, 'checkDuplicateName', 541, 542),
(273, 263, NULL, NULL, 'releaseSurvey', 543, 544),
(274, 263, NULL, NULL, 'questionsSummary', 545, 546),
(275, 263, NULL, NULL, 'moveQuestion', 547, 548),
(276, 263, NULL, NULL, 'removeQuestion', 549, 550),
(277, 263, NULL, NULL, 'addQuestion', 551, 552),
(278, 263, NULL, NULL, 'editQuestion', 553, 554),
(279, 263, NULL, NULL, 'update', 555, 556),
(280, 263, NULL, NULL, 'extractModel', 557, 558),
(281, 2, NULL, NULL, 'Sysfunctions', 560, 579),
(282, 281, NULL, NULL, 'setUpAjaxList', 561, 562),
(283, 281, NULL, NULL, 'index', 563, 564),
(284, 281, NULL, NULL, 'ajaxList', 565, 566),
(285, 281, NULL, NULL, 'view', 567, 568),
(286, 281, NULL, NULL, 'edit', 569, 570),
(287, 281, NULL, NULL, 'delete', 571, 572),
(288, 281, NULL, NULL, 'update', 573, 574),
(289, 281, NULL, NULL, 'extractModel', 575, 576),
(290, 281, NULL, NULL, 'add', 577, 578),
(291, 2, NULL, NULL, 'Sysparameters', 580, 597),
(292, 291, NULL, NULL, 'setUpAjaxList', 581, 582),
(293, 291, NULL, NULL, 'index', 583, 584),
(294, 291, NULL, NULL, 'ajaxList', 585, 586),
(295, 291, NULL, NULL, 'view', 587, 588),
(296, 291, NULL, NULL, 'add', 589, 590),
(297, 291, NULL, NULL, 'edit', 591, 592),
(298, 291, NULL, NULL, 'delete', 593, 594),
(299, 291, NULL, NULL, 'extractModel', 595, 596),
(300, 2, NULL, NULL, 'Upgrade', 598, 615),
(301, 300, NULL, NULL, 'index', 599, 600),
(302, 300, NULL, NULL, 'step2', 601, 602),
(303, 300, NULL, NULL, 'checkPermission', 603, 604),
(304, 300, NULL, NULL, 'extractModel', 605, 606),
(305, 300, NULL, NULL, 'add', 607, 608),
(306, 300, NULL, NULL, 'edit', 609, 610),
(307, 300, NULL, NULL, 'view', 611, 612),
(308, 300, NULL, NULL, 'delete', 613, 614),
(309, 2, NULL, NULL, 'Users', 616, 657),
(310, 309, NULL, NULL, 'login', 617, 618),
(311, 309, NULL, NULL, 'logout', 619, 620),
(312, 309, NULL, NULL, 'ajaxList', 621, 622),
(313, 309, NULL, NULL, 'index', 623, 624),
(314, 309, NULL, NULL, 'goToClassList', 625, 626),
(315, 309, NULL, NULL, 'determineIfStudentFromThisData', 627, 628),
(316, 309, NULL, NULL, 'getSimpleEntrollmentLists', 629, 630),
(317, 309, NULL, NULL, 'view', 631, 632),
(318, 309, NULL, NULL, 'add', 633, 634),
(319, 309, NULL, NULL, 'edit', 635, 636),
(320, 309, NULL, NULL, 'editProfile', 637, 638),
(321, 309, NULL, NULL, 'delete', 639, 640),
(322, 309, NULL, NULL, 'drop', 641, 642),
(323, 309, NULL, NULL, 'checkDuplicateName', 643, 644),
(324, 309, NULL, NULL, 'resetPassword', 645, 646),
(325, 309, NULL, NULL, 'import', 647, 648),
(326, 309, NULL, NULL, 'importPreview', 649, 650),
(327, 309, NULL, NULL, 'importFile', 651, 652),
(328, 309, NULL, NULL, 'update', 653, 654),
(329, 309, NULL, NULL, 'extractModel', 655, 656),
(330, 2, NULL, NULL, 'V1', 658, 671),
(331, 330, NULL, NULL, 'users', 659, 660),
(332, 330, NULL, NULL, 'add', 661, 662),
(333, 330, NULL, NULL, 'edit', 663, 664),
(334, 330, NULL, NULL, 'index', 665, 666),
(335, 330, NULL, NULL, 'view', 667, 668),
(336, 330, NULL, NULL, 'delete', 669, 670),
(337, 2, NULL, NULL, 'Guard', 672, 691),
(338, 337, NULL, NULL, 'Guard', 673, 690),
(339, 338, NULL, NULL, 'login', 674, 675),
(340, 338, NULL, NULL, 'logout', 676, 677),
(341, 338, NULL, NULL, 'extractModel', 678, 679),
(342, 338, NULL, NULL, 'add', 680, 681),
(343, 338, NULL, NULL, 'edit', 682, 683),
(344, 338, NULL, NULL, 'index', 684, 685),
(345, 338, NULL, NULL, 'view', 686, 687),
(346, 338, NULL, NULL, 'delete', 688, 689),
(347, NULL, NULL, NULL, 'functions', 693, 746),
(348, 347, NULL, NULL, 'user', 694, 719),
(349, 348, NULL, NULL, 'superadmin', 695, 696),
(350, 348, NULL, NULL, 'admin', 697, 698),
(351, 348, NULL, NULL, 'instructor', 699, 700),
(352, 348, NULL, NULL, 'tutor', 701, 702),
(353, 348, NULL, NULL, 'student', 703, 704),
(354, 348, NULL, NULL, 'import', 705, 706),
(355, 348, NULL, NULL, 'password_reset', 707, 718),
(356, 355, NULL, NULL, 'superadmin', 708, 709),
(357, 355, NULL, NULL, 'admin', 710, 711),
(358, 355, NULL, NULL, 'instructor', 712, 713),
(359, 355, NULL, NULL, 'tutor', 714, 715),
(360, 355, NULL, NULL, 'student', 716, 717),
(361, 347, NULL, NULL, 'role', 720, 731),
(362, 361, NULL, NULL, 'superadmin', 721, 722),
(363, 361, NULL, NULL, 'admin', 723, 724),
(364, 361, NULL, NULL, 'instructor', 725, 726),
(365, 361, NULL, NULL, 'tutor', 727, 728),
(366, 361, NULL, NULL, 'student', 729, 730),
(367, 347, NULL, NULL, 'evaluation', 732, 733),
(368, 347, NULL, NULL, 'email', 734, 741),
(369, 368, NULL, NULL, 'allUsers', 735, 736),
(370, 368, NULL, NULL, 'allGroups', 737, 738),
(371, 368, NULL, NULL, 'allCourses', 739, 740),
(372, 347, NULL, NULL, 'emailtemplate', 742, 743),
(373, 347, NULL, NULL, 'viewstudentresults', 744, 745);

-- --------------------------------------------------------

--
-- Table structure for table `aros`
--

DROP TABLE IF EXISTS `aros`;
CREATE TABLE IF NOT EXISTS `aros` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) DEFAULT NULL,
  `model` varchar(255) DEFAULT NULL,
  `foreign_key` int(10) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `lft` int(10) DEFAULT NULL,
  `rght` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `aros`
--

INSERT INTO `aros` (`id`, `parent_id`, `model`, `foreign_key`, `alias`, `lft`, `rght`) VALUES
(1, NULL, 'Role', 1, NULL, 1, 2),
(2, NULL, 'Role', 2, NULL, 3, 4),
(3, NULL, 'Role', 3, NULL, 5, 6),
(4, NULL, 'Role', 4, NULL, 7, 8),
(5, NULL, 'Role', 5, NULL, 9, 10);

-- --------------------------------------------------------

--
-- Table structure for table `aros_acos`
--

DROP TABLE IF EXISTS `aros_acos`;
CREATE TABLE IF NOT EXISTS `aros_acos` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `aro_id` int(10) NOT NULL,
  `aco_id` int(10) NOT NULL,
  `_create` varchar(2) NOT NULL DEFAULT '0',
  `_read` varchar(2) NOT NULL DEFAULT '0',
  `_update` varchar(2) NOT NULL DEFAULT '0',
  `_delete` varchar(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ARO_ACO_KEY` (`aro_id`,`aco_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=60 ;

--
-- Dumping data for table `aros_acos`
--

INSERT INTO `aros_acos` (`id`, `aro_id`, `aco_id`, `_create`, `_read`, `_update`, `_delete`) VALUES
(1, 1, 2, '1', '1', '1', '1'),
(2, 1, 347, '1', '1', '1', '1'),
(3, 1, 60, '1', '1', '1', '1'),
(4, 1, 235, '1', '1', '1', '1'),
(5, 1, 208, '1', '1', '1', '1'),
(6, 1, 184, '1', '1', '1', '1'),
(7, 1, 263, '1', '1', '1', '1'),
(8, 1, 32, '1', '1', '1', '1'),
(9, 1, 49, '1', '1', '1', '1'),
(10, 1, 106, '1', '1', '1', '1'),
(11, 1, 123, '1', '1', '1', '1'),
(12, 1, 25, '1', '1', '1', '1'),
(13, 1, 140, '1', '1', '1', '1'),
(14, 1, 1, '1', '1', '1', '1'),
(15, 2, 2, '-1', '-1', '-1', '-1'),
(16, 2, 158, '1', '1', '1', '1'),
(17, 2, 11, '1', '1', '1', '1'),
(18, 2, 25, '1', '1', '1', '1'),
(19, 2, 32, '1', '1', '1', '1'),
(20, 2, 49, '1', '1', '1', '1'),
(21, 2, 60, '1', '1', '1', '1'),
(22, 2, 106, '1', '1', '1', '1'),
(23, 2, 140, '1', '1', '1', '1'),
(24, 2, 184, '1', '1', '1', '1'),
(25, 2, 208, '1', '1', '1', '1'),
(26, 2, 235, '1', '1', '1', '1'),
(27, 2, 263, '1', '1', '1', '1'),
(28, 2, 309, '1', '1', '1', '1'),
(29, 2, 347, '-1', '-1', '-1', '-1'),
(30, 2, 368, '1', '1', '1', '1'),
(31, 2, 372, '1', '1', '1', '1'),
(32, 2, 367, '1', '1', '1', '1'),
(33, 2, 348, '1', '1', '1', '1'),
(34, 2, 350, '-1', '1', '-1', '-1'),
(35, 2, 349, '-1', '-1', '-1', '-1'),
(36, 2, 1, '1', '1', '1', '1'),
(37, 3, 2, '-1', '-1', '-1', '-1'),
(38, 3, 158, '1', '1', '1', '1'),
(39, 3, 11, '1', '1', '1', '1'),
(40, 3, 17, '-1', '-1', '-1', '-1'),
(41, 3, 18, '-1', '-1', '-1', '-1'),
(42, 3, 32, '1', '1', '1', '1'),
(43, 3, 49, '1', '1', '1', '1'),
(44, 3, 60, '1', '1', '1', '1'),
(45, 3, 106, '1', '1', '1', '1'),
(46, 3, 140, '1', '1', '1', '1'),
(47, 3, 184, '1', '1', '1', '1'),
(48, 3, 208, '1', '1', '1', '1'),
(49, 3, 235, '1', '1', '1', '1'),
(50, 3, 263, '1', '1', '1', '1'),
(51, 3, 309, '1', '1', '1', '1'),
(52, 3, 347, '-1', '-1', '-1', '-1'),
(53, 3, 368, '1', '1', '1', '1'),
(54, 3, 369, '-1', '-1', '-1', '-1'),
(55, 3, 370, '-1', '-1', '-1', '-1'),
(56, 3, 371, '-1', '-1', '-1', '-1'),
(57, 3, 367, '1', '1', '-1', '-1'),
(58, 3, 348, '1', '1', '1', '1'),
(59, 3, 350, '-1', '-1', '-1', '-1'),
(60, 3, 349, '-1', '-1', '-1', '-1'),
(61, 3, 351, '-1', '1', '-1', '-1'),
(62, 4, 2, '-1', '-1', '-1', '-1'),
(63, 4, 158, '1', '1', '1', '1'),
(64, 4, 11, '-1', '-1', '-1', '-1'),
(65, 4, 32, '-1', '-1', '-1', '-1'),
(66, 4, 49, '-1', '-1', '-1', '-1'),
(67, 4, 60, '-1', '-1', '-1', '-1'),
(68, 4, 106, '-1', '-1', '-1', '-1'),
(69, 4, 140, '-1', '-1', '-1', '-1'),
(70, 4, 184, '-1', '-1', '-1', '-1'),
(71, 4, 208, '-1', '-1', '-1', '-1'),
(72, 4, 235, '-1', '-1', '-1', '-1'),
(73, 4, 263, '-1', '-1', '-1', '-1'),
(74, 4, 309, '-1', '-1', '-1', '-1'),
(75, 4, 347, '-1', '-1', '-1', '-1'),
(76, 5, 2, '-1', '-1', '-1', '-1'),
(77, 5, 158, '1', '1', '1', '1'),
(78, 5, 11, '-1', '-1', '-1', '-1'),
(79, 5, 32, '-1', '-1', '-1', '-1'),
(80, 5, 49, '-1', '-1', '-1', '-1'),
(81, 5, 60, '-1', '-1', '-1', '-1'),
(82, 5, 106, '-1', '-1', '-1', '-1'),
(83, 5, 140, '-1', '-1', '-1', '-1'),
(84, 5, 184, '-1', '-1', '-1', '-1'),
(85, 5, 208, '-1', '-1', '-1', '-1'),
(86, 5, 235, '-1', '-1', '-1', '-1'),
(87, 5, 263, '-1', '-1', '-1', '-1'),
(88, 5, 309, '-1', '-1', '-1', '-1'),
(89, 5, 347, '-1', '-1', '-1', '-1'),
(90, 5, 373, '1', '1', '1', '1');

-- --------------------------------------------------------

--
-- Table structure for table `courses`
--

DROP TABLE IF EXISTS `courses`;
CREATE TABLE `courses` (
  `id` int(11) NOT NULL auto_increment,
  `course` varchar(80) NOT NULL default '',
  `title` varchar(80) default NULL,
  `homepage` varchar(100) default NULL,
  `self_enroll` varchar(3) default 'off',
  `password` varchar(25) default NULL,
  `record_status` varchar(1) NOT NULL default 'A',
  `creator_id` int(11) NOT NULL default '0',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `updater_id` int(11) default NULL,
  `modified` datetime default NULL,
  `instructor_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `course` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `courses`
--

INSERT 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', NULL);
INSERT 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', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(80) NOT NULL DEFAULT '',
  `password` varchar(80) NOT NULL DEFAULT '',
  `first_name` varchar(80) DEFAULT NULL,
  `last_name` varchar(80) DEFAULT NULL,
  `student_no` varchar(30) DEFAULT NULL,<commit_msg>fixed a minor sql error for courses table<commit_after>-- phpMyAdmin SQL Dump
-- version 2.6.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 27, 2006 at 10:51 AM
-- Server version: 4.1.11
-- PHP Version: 4.3.10-16
--
-- Database: `ipeer2`
--

-- --------------------------------------------------------

--
-- Table structure for table `acos`
--

DROP TABLE IF EXISTS `acos`;
CREATE TABLE IF NOT EXISTS `acos` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) DEFAULT NULL,
  `model` varchar(255) DEFAULT NULL,
  `foreign_key` int(10) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `lft` int(10) DEFAULT NULL,
  `rght` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`),
  KEY `alias` (`alias`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=365 ;

--
-- Dumping data for table `acos`
--

INSERT INTO `acos` (`id`, `parent_id`, `model`, `foreign_key`, `alias`, `lft`, `rght`) VALUES
(1, NULL, NULL, NULL, 'adminpage', 1, 2),
(2, NULL, NULL, NULL, 'controllers', 3, 692),
(3, 2, NULL, NULL, 'Pages', 4, 19),
(4, 3, NULL, NULL, 'display', 5, 6),
(5, 3, NULL, NULL, 'extractModel', 7, 8),
(6, 3, NULL, NULL, 'add', 9, 10),
(7, 3, NULL, NULL, 'edit', 11, 12),
(8, 3, NULL, NULL, 'index', 13, 14),
(9, 3, NULL, NULL, 'view', 15, 16),
(10, 3, NULL, NULL, 'delete', 17, 18),
(11, 2, NULL, NULL, 'Courses', 20, 47),
(12, 11, NULL, NULL, 'daysLate', 21, 22),
(13, 11, NULL, NULL, 'index', 23, 24),
(14, 11, NULL, NULL, 'ajaxList', 25, 26),
(15, 11, NULL, NULL, 'view', 27, 28),
(16, 11, NULL, NULL, 'home', 29, 30),
(17, 11, NULL, NULL, 'add', 31, 32),
(18, 11, NULL, NULL, 'edit', 33, 34),
(19, 11, NULL, NULL, 'delete', 35, 36),
(20, 11, NULL, NULL, 'addInstructor', 37, 38),
(21, 11, NULL, NULL, 'deleteInstructor', 39, 40),
(22, 11, NULL, NULL, 'checkDuplicateName', 41, 42),
(23, 11, NULL, NULL, 'update', 43, 44),
(24, 11, NULL, NULL, 'extractModel', 45, 46),
(25, 2, NULL, NULL, 'Departments', 48, 61),
(26, 25, NULL, NULL, 'index', 49, 50),
(27, 25, NULL, NULL, 'view', 51, 52),
(28, 25, NULL, NULL, 'add', 53, 54),
(29, 25, NULL, NULL, 'edit', 55, 56),
(30, 25, NULL, NULL, 'delete', 57, 58),
(31, 25, NULL, NULL, 'extractModel', 59, 60),
(32, 2, NULL, NULL, 'Emailer', 62, 95),
(33, 32, NULL, NULL, 'setUpAjaxList', 63, 64),
(34, 32, NULL, NULL, 'ajaxList', 65, 66),
(35, 32, NULL, NULL, 'index', 67, 68),
(36, 32, NULL, NULL, 'write', 69, 70),
(37, 32, NULL, NULL, 'cancel', 71, 72),
(38, 32, NULL, NULL, 'view', 73, 74),
(39, 32, NULL, NULL, 'addRecipient', 75, 76),
(40, 32, NULL, NULL, 'deleteRecipient', 77, 78),
(41, 32, NULL, NULL, 'getRecipient', 79, 80),
(42, 32, NULL, NULL, 'searchByUserId', 81, 82),
(43, 32, NULL, NULL, 'doMerge', 83, 84),
(44, 32, NULL, NULL, 'send', 85, 86),
(45, 32, NULL, NULL, 'extractModel', 87, 88),
(46, 32, NULL, NULL, 'add', 89, 90),
(47, 32, NULL, NULL, 'edit', 91, 92),
(48, 32, NULL, NULL, 'delete', 93, 94),
(49, 2, NULL, NULL, 'Emailtemplates', 96, 117),
(50, 49, NULL, NULL, 'setUpAjaxList', 97, 98),
(51, 49, NULL, NULL, 'ajaxList', 99, 100),
(52, 49, NULL, NULL, 'index', 101, 102),
(53, 49, NULL, NULL, 'add', 103, 104),
(54, 49, NULL, NULL, 'edit', 105, 106),
(55, 49, NULL, NULL, 'delete', 107, 108),
(56, 49, NULL, NULL, 'view', 109, 110),
(57, 49, NULL, NULL, 'displayTemplateContent', 111, 112),
(58, 49, NULL, NULL, 'displayTemplateSubject', 113, 114),
(59, 49, NULL, NULL, 'extractModel', 115, 116),
(60, 2, NULL, NULL, 'Evaltools', 118, 133),
(61, 60, NULL, NULL, 'index', 119, 120),
(62, 60, NULL, NULL, 'showAll', 121, 122),
(63, 60, NULL, NULL, 'extractModel', 123, 124),
(64, 60, NULL, NULL, 'add', 125, 126),
(65, 60, NULL, NULL, 'edit', 127, 128),
(66, 60, NULL, NULL, 'view', 129, 130),
(67, 60, NULL, NULL, 'delete', 131, 132),
(68, 2, NULL, NULL, 'Evaluations', 134, 209),
(69, 68, NULL, NULL, 'postProcess', 135, 136),
(70, 68, NULL, NULL, 'setUpAjaxList', 137, 138),
(71, 68, NULL, NULL, 'ajaxList', 139, 140),
(72, 68, NULL, NULL, 'view', 141, 142),
(73, 68, NULL, NULL, 'index', 143, 144),
(74, 68, NULL, NULL, 'search', 145, 146),
(75, 68, NULL, NULL, 'update', 147, 148),
(76, 68, NULL, NULL, 'test', 149, 150),
(77, 68, NULL, NULL, 'export', 151, 152),
(78, 68, NULL, NULL, 'makeSimpleEvaluation', 153, 154),
(79, 68, NULL, NULL, 'validSimpleEvalComplete', 155, 156),
(80, 68, NULL, NULL, 'makeSurveyEvaluation', 157, 158),
(81, 68, NULL, NULL, 'validSurveyEvalComplete', 159, 160),
(82, 68, NULL, NULL, 'makeRubricEvaluation', 161, 162),
(83, 68, NULL, NULL, 'validRubricEvalComplete', 163, 164),
(84, 68, NULL, NULL, 'completeEvaluationRubric', 165, 166),
(85, 68, NULL, NULL, 'makeMixevalEvaluation', 167, 168),
(86, 68, NULL, NULL, 'validMixevalEvalComplete', 169, 170),
(87, 68, NULL, NULL, 'completeEvaluationMixeval', 171, 172),
(88, 68, NULL, NULL, 'viewEvaluationResults', 173, 174),
(89, 68, NULL, NULL, 'viewSurveyGroupEvaluationResults', 175, 176),
(90, 68, NULL, NULL, 'studentViewEvaluationResult', 177, 178),
(91, 68, NULL, NULL, 'markEventReviewed', 179, 180),
(92, 68, NULL, NULL, 'markGradeRelease', 181, 182),
(93, 68, NULL, NULL, 'markCommentRelease', 183, 184),
(94, 68, NULL, NULL, 'changeAllCommentRelease', 185, 186),
(95, 68, NULL, NULL, 'changeAllGradeRelease', 187, 188),
(96, 68, NULL, NULL, 'viewGroupSubmissionDetails', 189, 190),
(97, 68, NULL, NULL, 'reReleaseEvaluation', 191, 192),
(98, 68, NULL, NULL, 'viewSurveySummary', 193, 194),
(99, 68, NULL, NULL, 'export_rubic', 195, 196),
(100, 68, NULL, NULL, 'export_test', 197, 198),
(101, 68, NULL, NULL, 'pre', 199, 200),
(102, 68, NULL, NULL, 'extractModel', 201, 202),
(103, 68, NULL, NULL, 'add', 203, 204),
(104, 68, NULL, NULL, 'edit', 205, 206),
(105, 68, NULL, NULL, 'delete', 207, 208),
(106, 2, NULL, NULL, 'Events', 210, 243),
(107, 106, NULL, NULL, 'postProcessData', 211, 212),
(108, 106, NULL, NULL, 'setUpAjaxList', 213, 214),
(109, 106, NULL, NULL, 'index', 215, 216),
(110, 106, NULL, NULL, 'ajaxList', 217, 218),
(111, 106, NULL, NULL, 'view', 219, 220),
(112, 106, NULL, NULL, 'eventTemplatesList', 221, 222),
(113, 106, NULL, NULL, 'add', 223, 224),
(114, 106, NULL, NULL, 'edit', 225, 226),
(115, 106, NULL, NULL, 'delete', 227, 228),
(116, 106, NULL, NULL, 'search', 229, 230),
(117, 106, NULL, NULL, 'checkDuplicateTitle', 231, 232),
(118, 106, NULL, NULL, 'viewGroups', 233, 234),
(119, 106, NULL, NULL, 'editGroup', 235, 236),
(120, 106, NULL, NULL, 'getAssignedGroups', 237, 238),
(121, 106, NULL, NULL, 'update', 239, 240),
(122, 106, NULL, NULL, 'extractModel', 241, 242),
(123, 2, NULL, NULL, 'Faculties', 244, 257),
(124, 123, NULL, NULL, 'index', 245, 246),
(125, 123, NULL, NULL, 'view', 247, 248),
(126, 123, NULL, NULL, 'add', 249, 250),
(127, 123, NULL, NULL, 'edit', 251, 252),
(128, 123, NULL, NULL, 'delete', 253, 254),
(129, 123, NULL, NULL, 'extractModel', 255, 256),
(130, 2, NULL, NULL, 'Framework', 258, 277),
(131, 130, NULL, NULL, 'calendarDisplay', 259, 260),
(132, 130, NULL, NULL, 'userInfoDisplay', 261, 262),
(133, 130, NULL, NULL, 'tutIndex', 263, 264),
(134, 130, NULL, NULL, 'extractModel', 265, 266),
(135, 130, NULL, NULL, 'add', 267, 268),
(136, 130, NULL, NULL, 'edit', 269, 270),
(137, 130, NULL, NULL, 'index', 271, 272),
(138, 130, NULL, NULL, 'view', 273, 274),
(139, 130, NULL, NULL, 'delete', 275, 276),
(140, 2, NULL, NULL, 'Groups', 278, 313),
(141, 140, NULL, NULL, 'postProcess', 279, 280),
(142, 140, NULL, NULL, 'setUpAjaxList', 281, 282),
(143, 140, NULL, NULL, 'index', 283, 284),
(144, 140, NULL, NULL, 'ajaxList', 285, 286),
(145, 140, NULL, NULL, 'goToClassList', 287, 288),
(146, 140, NULL, NULL, 'view', 289, 290),
(147, 140, NULL, NULL, 'add', 291, 292),
(148, 140, NULL, NULL, 'edit', 293, 294),
(149, 140, NULL, NULL, 'delete', 295, 296),
(150, 140, NULL, NULL, 'checkDuplicateName', 297, 298),
(151, 140, NULL, NULL, 'getQueryAttribute', 299, 300),
(152, 140, NULL, NULL, 'import', 301, 302),
(153, 140, NULL, NULL, 'addGroupByImport', 303, 304),
(154, 140, NULL, NULL, 'update', 305, 306),
(155, 140, NULL, NULL, 'export', 307, 308),
(156, 140, NULL, NULL, 'sendGroupEmail', 309, 310),
(157, 140, NULL, NULL, 'extractModel', 311, 312),
(158, 2, NULL, NULL, 'Home', 314, 329),
(159, 158, NULL, NULL, 'index', 315, 316),
(160, 158, NULL, NULL, 'studentIndex', 317, 318),
(161, 158, NULL, NULL, 'extractModel', 319, 320),
(162, 158, NULL, NULL, 'add', 321, 322),
(163, 158, NULL, NULL, 'edit', 323, 324),
(164, 158, NULL, NULL, 'view', 325, 326),
(165, 158, NULL, NULL, 'delete', 327, 328),
(166, 2, NULL, NULL, 'Install', 330, 351),
(167, 166, NULL, NULL, 'index', 331, 332),
(168, 166, NULL, NULL, 'install2', 333, 334),
(169, 166, NULL, NULL, 'install3', 335, 336),
(170, 166, NULL, NULL, 'install4', 337, 338),
(171, 166, NULL, NULL, 'install5', 339, 340),
(172, 166, NULL, NULL, 'gpl', 341, 342),
(173, 166, NULL, NULL, 'add', 343, 344),
(174, 166, NULL, NULL, 'edit', 345, 346),
(175, 166, NULL, NULL, 'view', 347, 348),
(176, 166, NULL, NULL, 'delete', 349, 350),
(177, 2, NULL, NULL, 'Lti', 352, 365),
(178, 177, NULL, NULL, 'index', 353, 354),
(179, 177, NULL, NULL, 'extractModel', 355, 356),
(180, 177, NULL, NULL, 'add', 357, 358),
(181, 177, NULL, NULL, 'edit', 359, 360),
(182, 177, NULL, NULL, 'view', 361, 362),
(183, 177, NULL, NULL, 'delete', 363, 364),
(184, 2, NULL, NULL, 'Mixevals', 366, 397),
(185, 184, NULL, NULL, 'postProcess', 367, 368),
(186, 184, NULL, NULL, 'setUpAjaxList', 369, 370),
(187, 184, NULL, NULL, 'index', 371, 372),
(188, 184, NULL, NULL, 'ajaxList', 373, 374),
(189, 184, NULL, NULL, 'view', 375, 376),
(190, 184, NULL, NULL, 'add', 377, 378),
(191, 184, NULL, NULL, 'deleteQuestion', 379, 380),
(192, 184, NULL, NULL, 'deleteDescriptor', 381, 382),
(193, 184, NULL, NULL, 'edit', 383, 384),
(194, 184, NULL, NULL, 'copy', 385, 386),
(195, 184, NULL, NULL, 'delete', 387, 388),
(196, 184, NULL, NULL, 'previewMixeval', 389, 390),
(197, 184, NULL, NULL, 'renderRows', 391, 392),
(198, 184, NULL, NULL, 'update', 393, 394),
(199, 184, NULL, NULL, 'extractModel', 395, 396),
(200, 2, NULL, NULL, 'Penalty', 398, 413),
(201, 200, NULL, NULL, 'save', 399, 400),
(202, 200, NULL, NULL, 'extractModel', 401, 402),
(203, 200, NULL, NULL, 'add', 403, 404),
(204, 200, NULL, NULL, 'edit', 405, 406),
(205, 200, NULL, NULL, 'index', 407, 408),
(206, 200, NULL, NULL, 'view', 409, 410),
(207, 200, NULL, NULL, 'delete', 411, 412),
(208, 2, NULL, NULL, 'Rubrics', 414, 437),
(209, 208, NULL, NULL, 'postProcess', 415, 416),
(210, 208, NULL, NULL, 'setUpAjaxList', 417, 418),
(211, 208, NULL, NULL, 'index', 419, 420),
(212, 208, NULL, NULL, 'ajaxList', 421, 422),
(213, 208, NULL, NULL, 'view', 423, 424),
(214, 208, NULL, NULL, 'add', 425, 426),
(215, 208, NULL, NULL, 'edit', 427, 428),
(216, 208, NULL, NULL, 'copy', 429, 430),
(217, 208, NULL, NULL, 'delete', 431, 432),
(218, 208, NULL, NULL, 'setForm_RubricName', 433, 434),
(219, 208, NULL, NULL, 'extractModel', 435, 436),
(220, 2, NULL, NULL, 'Searchs', 438, 467),
(221, 220, NULL, NULL, 'update', 439, 440),
(222, 220, NULL, NULL, 'index', 441, 442),
(223, 220, NULL, NULL, 'searchEvaluation', 443, 444),
(224, 220, NULL, NULL, 'searchResult', 445, 446),
(225, 220, NULL, NULL, 'searchInstructor', 447, 448),
(226, 220, NULL, NULL, 'eventBoxSearch', 449, 450),
(227, 220, NULL, NULL, 'formatSearchEvaluation', 451, 452),
(228, 220, NULL, NULL, 'formatSearchInstructor', 453, 454),
(229, 220, NULL, NULL, 'formatSearchEvaluationResult', 455, 456),
(230, 220, NULL, NULL, 'extractModel', 457, 458),
(231, 220, NULL, NULL, 'add', 459, 460),
(232, 220, NULL, NULL, 'edit', 461, 462),
(233, 220, NULL, NULL, 'view', 463, 464),
(234, 220, NULL, NULL, 'delete', 465, 466),
(235, 2, NULL, NULL, 'Simpleevaluations', 468, 489),
(236, 235, NULL, NULL, 'postProcess', 469, 470),
(237, 235, NULL, NULL, 'setUpAjaxList', 471, 472),
(238, 235, NULL, NULL, 'index', 473, 474),
(239, 235, NULL, NULL, 'ajaxList', 475, 476),
(240, 235, NULL, NULL, 'view', 477, 478),
(241, 235, NULL, NULL, 'add', 479, 480),
(242, 235, NULL, NULL, 'edit', 481, 482),
(243, 235, NULL, NULL, 'copy', 483, 484),
(244, 235, NULL, NULL, 'delete', 485, 486),
(245, 235, NULL, NULL, 'extractModel', 487, 488),
(246, 2, NULL, NULL, 'Surveygroups', 490, 523),
(247, 246, NULL, NULL, 'postProcess', 491, 492),
(248, 246, NULL, NULL, 'setUpAjaxList', 493, 494),
(249, 246, NULL, NULL, 'index', 495, 496),
(250, 246, NULL, NULL, 'ajaxList', 497, 498),
(251, 246, NULL, NULL, 'viewresult', 499, 500),
(252, 246, NULL, NULL, 'makegroups', 501, 502),
(253, 246, NULL, NULL, 'makegroupssearch', 503, 504),
(254, 246, NULL, NULL, 'maketmgroups', 505, 506),
(255, 246, NULL, NULL, 'savegroups', 507, 508),
(256, 246, NULL, NULL, 'release', 509, 510),
(257, 246, NULL, NULL, 'delete', 511, 512),
(258, 246, NULL, NULL, 'edit', 513, 514),
(259, 246, NULL, NULL, 'changegroupset', 515, 516),
(260, 246, NULL, NULL, 'extractModel', 517, 518),
(261, 246, NULL, NULL, 'add', 519, 520),
(262, 246, NULL, NULL, 'view', 521, 522),
(263, 2, NULL, NULL, 'Surveys', 524, 559),
(264, 263, NULL, NULL, 'setUpAjaxList', 525, 526),
(265, 263, NULL, NULL, 'index', 527, 528),
(266, 263, NULL, NULL, 'ajaxList', 529, 530),
(267, 263, NULL, NULL, 'view', 531, 532),
(268, 263, NULL, NULL, 'add', 533, 534),
(269, 263, NULL, NULL, 'edit', 535, 536),
(270, 263, NULL, NULL, 'copy', 537, 538),
(271, 263, NULL, NULL, 'delete', 539, 540),
(272, 263, NULL, NULL, 'checkDuplicateName', 541, 542),
(273, 263, NULL, NULL, 'releaseSurvey', 543, 544),
(274, 263, NULL, NULL, 'questionsSummary', 545, 546),
(275, 263, NULL, NULL, 'moveQuestion', 547, 548),
(276, 263, NULL, NULL, 'removeQuestion', 549, 550),
(277, 263, NULL, NULL, 'addQuestion', 551, 552),
(278, 263, NULL, NULL, 'editQuestion', 553, 554),
(279, 263, NULL, NULL, 'update', 555, 556),
(280, 263, NULL, NULL, 'extractModel', 557, 558),
(281, 2, NULL, NULL, 'Sysfunctions', 560, 579),
(282, 281, NULL, NULL, 'setUpAjaxList', 561, 562),
(283, 281, NULL, NULL, 'index', 563, 564),
(284, 281, NULL, NULL, 'ajaxList', 565, 566),
(285, 281, NULL, NULL, 'view', 567, 568),
(286, 281, NULL, NULL, 'edit', 569, 570),
(287, 281, NULL, NULL, 'delete', 571, 572),
(288, 281, NULL, NULL, 'update', 573, 574),
(289, 281, NULL, NULL, 'extractModel', 575, 576),
(290, 281, NULL, NULL, 'add', 577, 578),
(291, 2, NULL, NULL, 'Sysparameters', 580, 597),
(292, 291, NULL, NULL, 'setUpAjaxList', 581, 582),
(293, 291, NULL, NULL, 'index', 583, 584),
(294, 291, NULL, NULL, 'ajaxList', 585, 586),
(295, 291, NULL, NULL, 'view', 587, 588),
(296, 291, NULL, NULL, 'add', 589, 590),
(297, 291, NULL, NULL, 'edit', 591, 592),
(298, 291, NULL, NULL, 'delete', 593, 594),
(299, 291, NULL, NULL, 'extractModel', 595, 596),
(300, 2, NULL, NULL, 'Upgrade', 598, 615),
(301, 300, NULL, NULL, 'index', 599, 600),
(302, 300, NULL, NULL, 'step2', 601, 602),
(303, 300, NULL, NULL, 'checkPermission', 603, 604),
(304, 300, NULL, NULL, 'extractModel', 605, 606),
(305, 300, NULL, NULL, 'add', 607, 608),
(306, 300, NULL, NULL, 'edit', 609, 610),
(307, 300, NULL, NULL, 'view', 611, 612),
(308, 300, NULL, NULL, 'delete', 613, 614),
(309, 2, NULL, NULL, 'Users', 616, 657),
(310, 309, NULL, NULL, 'login', 617, 618),
(311, 309, NULL, NULL, 'logout', 619, 620),
(312, 309, NULL, NULL, 'ajaxList', 621, 622),
(313, 309, NULL, NULL, 'index', 623, 624),
(314, 309, NULL, NULL, 'goToClassList', 625, 626),
(315, 309, NULL, NULL, 'determineIfStudentFromThisData', 627, 628),
(316, 309, NULL, NULL, 'getSimpleEntrollmentLists', 629, 630),
(317, 309, NULL, NULL, 'view', 631, 632),
(318, 309, NULL, NULL, 'add', 633, 634),
(319, 309, NULL, NULL, 'edit', 635, 636),
(320, 309, NULL, NULL, 'editProfile', 637, 638),
(321, 309, NULL, NULL, 'delete', 639, 640),
(322, 309, NULL, NULL, 'drop', 641, 642),
(323, 309, NULL, NULL, 'checkDuplicateName', 643, 644),
(324, 309, NULL, NULL, 'resetPassword', 645, 646),
(325, 309, NULL, NULL, 'import', 647, 648),
(326, 309, NULL, NULL, 'importPreview', 649, 650),
(327, 309, NULL, NULL, 'importFile', 651, 652),
(328, 309, NULL, NULL, 'update', 653, 654),
(329, 309, NULL, NULL, 'extractModel', 655, 656),
(330, 2, NULL, NULL, 'V1', 658, 671),
(331, 330, NULL, NULL, 'users', 659, 660),
(332, 330, NULL, NULL, 'add', 661, 662),
(333, 330, NULL, NULL, 'edit', 663, 664),
(334, 330, NULL, NULL, 'index', 665, 666),
(335, 330, NULL, NULL, 'view', 667, 668),
(336, 330, NULL, NULL, 'delete', 669, 670),
(337, 2, NULL, NULL, 'Guard', 672, 691),
(338, 337, NULL, NULL, 'Guard', 673, 690),
(339, 338, NULL, NULL, 'login', 674, 675),
(340, 338, NULL, NULL, 'logout', 676, 677),
(341, 338, NULL, NULL, 'extractModel', 678, 679),
(342, 338, NULL, NULL, 'add', 680, 681),
(343, 338, NULL, NULL, 'edit', 682, 683),
(344, 338, NULL, NULL, 'index', 684, 685),
(345, 338, NULL, NULL, 'view', 686, 687),
(346, 338, NULL, NULL, 'delete', 688, 689),
(347, NULL, NULL, NULL, 'functions', 693, 746),
(348, 347, NULL, NULL, 'user', 694, 719),
(349, 348, NULL, NULL, 'superadmin', 695, 696),
(350, 348, NULL, NULL, 'admin', 697, 698),
(351, 348, NULL, NULL, 'instructor', 699, 700),
(352, 348, NULL, NULL, 'tutor', 701, 702),
(353, 348, NULL, NULL, 'student', 703, 704),
(354, 348, NULL, NULL, 'import', 705, 706),
(355, 348, NULL, NULL, 'password_reset', 707, 718),
(356, 355, NULL, NULL, 'superadmin', 708, 709),
(357, 355, NULL, NULL, 'admin', 710, 711),
(358, 355, NULL, NULL, 'instructor', 712, 713),
(359, 355, NULL, NULL, 'tutor', 714, 715),
(360, 355, NULL, NULL, 'student', 716, 717),
(361, 347, NULL, NULL, 'role', 720, 731),
(362, 361, NULL, NULL, 'superadmin', 721, 722),
(363, 361, NULL, NULL, 'admin', 723, 724),
(364, 361, NULL, NULL, 'instructor', 725, 726),
(365, 361, NULL, NULL, 'tutor', 727, 728),
(366, 361, NULL, NULL, 'student', 729, 730),
(367, 347, NULL, NULL, 'evaluation', 732, 733),
(368, 347, NULL, NULL, 'email', 734, 741),
(369, 368, NULL, NULL, 'allUsers', 735, 736),
(370, 368, NULL, NULL, 'allGroups', 737, 738),
(371, 368, NULL, NULL, 'allCourses', 739, 740),
(372, 347, NULL, NULL, 'emailtemplate', 742, 743),
(373, 347, NULL, NULL, 'viewstudentresults', 744, 745);

-- --------------------------------------------------------

--
-- Table structure for table `aros`
--

DROP TABLE IF EXISTS `aros`;
CREATE TABLE IF NOT EXISTS `aros` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) DEFAULT NULL,
  `model` varchar(255) DEFAULT NULL,
  `foreign_key` int(10) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `lft` int(10) DEFAULT NULL,
  `rght` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `aros`
--

INSERT INTO `aros` (`id`, `parent_id`, `model`, `foreign_key`, `alias`, `lft`, `rght`) VALUES
(1, NULL, 'Role', 1, NULL, 1, 2),
(2, NULL, 'Role', 2, NULL, 3, 4),
(3, NULL, 'Role', 3, NULL, 5, 6),
(4, NULL, 'Role', 4, NULL, 7, 8),
(5, NULL, 'Role', 5, NULL, 9, 10);

-- --------------------------------------------------------

--
-- Table structure for table `aros_acos`
--

DROP TABLE IF EXISTS `aros_acos`;
CREATE TABLE IF NOT EXISTS `aros_acos` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `aro_id` int(10) NOT NULL,
  `aco_id` int(10) NOT NULL,
  `_create` varchar(2) NOT NULL DEFAULT '0',
  `_read` varchar(2) NOT NULL DEFAULT '0',
  `_update` varchar(2) NOT NULL DEFAULT '0',
  `_delete` varchar(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ARO_ACO_KEY` (`aro_id`,`aco_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=60 ;

--
-- Dumping data for table `aros_acos`
--

INSERT INTO `aros_acos` (`id`, `aro_id`, `aco_id`, `_create`, `_read`, `_update`, `_delete`) VALUES
(1, 1, 2, '1', '1', '1', '1'),
(2, 1, 347, '1', '1', '1', '1'),
(3, 1, 60, '1', '1', '1', '1'),
(4, 1, 235, '1', '1', '1', '1'),
(5, 1, 208, '1', '1', '1', '1'),
(6, 1, 184, '1', '1', '1', '1'),
(7, 1, 263, '1', '1', '1', '1'),
(8, 1, 32, '1', '1', '1', '1'),
(9, 1, 49, '1', '1', '1', '1'),
(10, 1, 106, '1', '1', '1', '1'),
(11, 1, 123, '1', '1', '1', '1'),
(12, 1, 25, '1', '1', '1', '1'),
(13, 1, 140, '1', '1', '1', '1'),
(14, 1, 1, '1', '1', '1', '1'),
(15, 2, 2, '-1', '-1', '-1', '-1'),
(16, 2, 158, '1', '1', '1', '1'),
(17, 2, 11, '1', '1', '1', '1'),
(18, 2, 25, '1', '1', '1', '1'),
(19, 2, 32, '1', '1', '1', '1'),
(20, 2, 49, '1', '1', '1', '1'),
(21, 2, 60, '1', '1', '1', '1'),
(22, 2, 106, '1', '1', '1', '1'),
(23, 2, 140, '1', '1', '1', '1'),
(24, 2, 184, '1', '1', '1', '1'),
(25, 2, 208, '1', '1', '1', '1'),
(26, 2, 235, '1', '1', '1', '1'),
(27, 2, 263, '1', '1', '1', '1'),
(28, 2, 309, '1', '1', '1', '1'),
(29, 2, 347, '-1', '-1', '-1', '-1'),
(30, 2, 368, '1', '1', '1', '1'),
(31, 2, 372, '1', '1', '1', '1'),
(32, 2, 367, '1', '1', '1', '1'),
(33, 2, 348, '1', '1', '1', '1'),
(34, 2, 350, '-1', '1', '-1', '-1'),
(35, 2, 349, '-1', '-1', '-1', '-1'),
(36, 2, 1, '1', '1', '1', '1'),
(37, 3, 2, '-1', '-1', '-1', '-1'),
(38, 3, 158, '1', '1', '1', '1'),
(39, 3, 11, '1', '1', '1', '1'),
(40, 3, 17, '-1', '-1', '-1', '-1'),
(41, 3, 18, '-1', '-1', '-1', '-1'),
(42, 3, 32, '1', '1', '1', '1'),
(43, 3, 49, '1', '1', '1', '1'),
(44, 3, 60, '1', '1', '1', '1'),
(45, 3, 106, '1', '1', '1', '1'),
(46, 3, 140, '1', '1', '1', '1'),
(47, 3, 184, '1', '1', '1', '1'),
(48, 3, 208, '1', '1', '1', '1'),
(49, 3, 235, '1', '1', '1', '1'),
(50, 3, 263, '1', '1', '1', '1'),
(51, 3, 309, '1', '1', '1', '1'),
(52, 3, 347, '-1', '-1', '-1', '-1'),
(53, 3, 368, '1', '1', '1', '1'),
(54, 3, 369, '-1', '-1', '-1', '-1'),
(55, 3, 370, '-1', '-1', '-1', '-1'),
(56, 3, 371, '-1', '-1', '-1', '-1'),
(57, 3, 367, '1', '1', '-1', '-1'),
(58, 3, 348, '1', '1', '1', '1'),
(59, 3, 350, '-1', '-1', '-1', '-1'),
(60, 3, 349, '-1', '-1', '-1', '-1'),
(61, 3, 351, '-1', '1', '-1', '-1'),
(62, 4, 2, '-1', '-1', '-1', '-1'),
(63, 4, 158, '1', '1', '1', '1'),
(64, 4, 11, '-1', '-1', '-1', '-1'),
(65, 4, 32, '-1', '-1', '-1', '-1'),
(66, 4, 49, '-1', '-1', '-1', '-1'),
(67, 4, 60, '-1', '-1', '-1', '-1'),
(68, 4, 106, '-1', '-1', '-1', '-1'),
(69, 4, 140, '-1', '-1', '-1', '-1'),
(70, 4, 184, '-1', '-1', '-1', '-1'),
(71, 4, 208, '-1', '-1', '-1', '-1'),
(72, 4, 235, '-1', '-1', '-1', '-1'),
(73, 4, 263, '-1', '-1', '-1', '-1'),
(74, 4, 309, '-1', '-1', '-1', '-1'),
(75, 4, 347, '-1', '-1', '-1', '-1'),
(76, 5, 2, '-1', '-1', '-1', '-1'),
(77, 5, 158, '1', '1', '1', '1'),
(78, 5, 11, '-1', '-1', '-1', '-1'),
(79, 5, 32, '-1', '-1', '-1', '-1'),
(80, 5, 49, '-1', '-1', '-1', '-1'),
(81, 5, 60, '-1', '-1', '-1', '-1'),
(82, 5, 106, '-1', '-1', '-1', '-1'),
(83, 5, 140, '-1', '-1', '-1', '-1'),
(84, 5, 184, '-1', '-1', '-1', '-1'),
(85, 5, 208, '-1', '-1', '-1', '-1'),
(86, 5, 235, '-1', '-1', '-1', '-1'),
(87, 5, 263, '-1', '-1', '-1', '-1'),
(88, 5, 309, '-1', '-1', '-1', '-1'),
(89, 5, 347, '-1', '-1', '-1', '-1'),
(90, 5, 373, '1', '1', '1', '1');

-- --------------------------------------------------------

--
-- Table structure for table `courses`
--

DROP TABLE IF EXISTS `courses`;
CREATE TABLE `courses` (
  `id` int(11) NOT NULL auto_increment,
  `course` varchar(80) NOT NULL default '',
  `title` varchar(80) default NULL,
  `homepage` varchar(100) default NULL,
  `self_enroll` varchar(3) default 'off',
  `password` varchar(25) default NULL,
  `record_status` varchar(1) NOT NULL default 'A',
  `creator_id` int(11) NOT NULL default '0',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `updater_id` int(11) default NULL,
  `modified` datetime default NULL,
  `instructor_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `course` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `courses`
--

INSERT 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);
INSERT 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);

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(80) NOT NULL DEFAULT '',
  `password` varchar(80) NOT NULL DEFAULT '',
  `first_name` varchar(80) DEFAULT NULL,
  `last_name` varchar(80) DEFAULT NULL,
  `student_no` varchar(30) DEFAULT NULL,
{'fraction_non_alphanumeric': 0.2759921285667432, 'fraction_numerical': 0.21195473925877337, 'mean_word_length': 4.493806306306307, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 6, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '2961194', 'n_tokens_mistral': 28634, 'n_tokens_neox': 20167, 'n_words': 7398}