Development:New enrolments in 2.0: Difference between revisions
No edit summary |
No edit summary |
||
| Line 36: | Line 36: | ||
| | | | ||
|- | |- | ||
| | | status | ||
| int(10) | | int(10) | ||
| 0 | | 0 | ||
Revision as of 21:57, 13 June 2010
Note: This page is a work-in-progress. Feedback and suggested improvements are welcome. Please join the discussion on moodle.org or use the page comments.
Template:Infobox Project Template:Moodle 2.0
Overview
The major difference from 1.6-1.9 enrolments is that the course enrolment information is stored again in a separate database table course_participants. The enrolment related information was move from course table to new enrol table which holds plugin instances. The old enrolment plugins need to be completely rewritten. Course category enrolments via role assignments is not possible any more, existing category enrolments are migrated to new cohorts and cohort enrolment plugin.
The benefits are:
- we can use SQL to find enrolled users in any course extremely quickly (much better performance)
- multiple enrolment plugins per course are full supported (includes more instances of the same type)
- new enrolment overview interface
- user enrolments may be suspended and reactivated
- plugin may prevent users to change/break enrolment synchronised with external systems
- finer access control, more flexible/configurable course settings UI
- no hardcoded enrolment behaviour - it is possible to completely replace guest access, self enrolments, etc. with custom plugins
Database structure changes
New table course_participants stores users participating in courses (aka enroled users).
| Field | Type | Default | Description |
|---|---|---|---|
| id | int(10) | auto-incrementing | |
| status | int(10) | 0 | 0 means active enrolment, 1 means suspended, anything else means inactive (user can not access course) and is defined by plugin |
| enrolid | int(10) | foreign key, references enrol.id | |
| userid | int(10) | foreign key, references user.id | |
| timestart | int(10) | 0 | time stamp, start of active participation period |
| timeend | int(10) | 0 | time stamp, end of active participation period |
| modifierid | int(10) | last user who modified enrolment, references user.id | |
| timemodified | int(10) | timestamp, last modification |
