Changeset 879ac8f in iPeer for app/config/sql/delta_5.sql


Ignore:
Timestamp:
2012-12-24T23:51:42-08:00 (6 years ago)
Author:
Compass <pan.luo@…>
Branches:
3.1.x, dev, hotfix, master, pagodabox, ticket463
Children:
be4e587
Parents:
a269d57
Message:

Change permission to allow admin to add admin

File:
1 edited

Legend:

Unmodified
Added
Removed
  • app/config/sql/delta_5.sql

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