mdl_role[edit]
columns[edit]
MariaDB [moodle_db]> show columns from mdl_role;
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| id | bigint(10) | NO | PRI | NULL | auto_increment |
| name | varchar(255) | NO | | | |
| shortname | varchar(100) | NO | UNI | | |
| description | longtext | NO | | NULL | |
| sortorder | bigint(10) | NO | UNI | 0 | |
| archetype | varchar(30) | NO | | | |
+-------------+--------------+------+-----+---------+----------------+
MariaDB [moodle_db]> select * from mdl_role;
+----+------+----------------+-------------+-----------+----------------+
| id | name | shortname | description | sortorder | archetype |
+----+------+----------------+-------------+-----------+----------------+
| 1 | | manager | | 1 | manager |
| 2 | | coursecreator | | 2 | coursecreator |
| 3 | | editingteacher | | 3 | editingteacher |
| 4 | | teacher | | 4 | teacher |
| 5 | | student | | 6 | student |
| 6 | | guest | | 8 | guest |
| 7 | | user | | 5 | user |
| 8 | | frontpage | | 7 | frontpage |
+----+------+----------------+-------------+-----------+----------------+