mdl_role_capabilities[edit]
columns[edit]
MariaDB [moodle_db]> show columns from mdl_role_capabilities;
+--------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+----------------+
| id | bigint(10) | NO | PRI | NULL | auto_increment |
| contextid | bigint(10) | NO | MUL | 0 | |
| roleid | bigint(10) | NO | MUL | 0 | |
| capability | varchar(255) | NO | MUL | | |
| permission | bigint(10) | NO | | 0 | |
| timemodified | bigint(10) | NO | | 0 | |
| modifierid | bigint(10) | NO | MUL | 0 | |
+--------------+--------------+------+-----+---------+----------------+
MariaDB [moodle_db]> select * from mdl_role_capabilities;
+------+-----------+--------+----------------------------------------------------+------------+--------------+------------+
| id | contextid | roleid | capability | permission | timemodified | modifierid |
+------+-----------+--------+----------------------------------------------------+------------+--------------+------------+
| 1 | 1 | 1 | moodle/site:readallmessages | 1 | 1363148550 | 0 |
| 2 | 1 | 3 | moodle/site:readallmessages | 1 | 1363148550 | 0 |
| 3 | 1 | 1 | moodle/site:sendmessage | 1 | 1363148550 | 0 |
| 4 | 1 | 7 | moodle/site:sendmessage | 1 | 1363148550 | 0 |
| 5 | 1 | 1 | moodle/site:approvecourse | 1 | 1363148550 | 0 |
| 6 | 1 | 3 | moodle/backup:backupcourse | 1 | 1363148550 | 0 |
| 7 | 1 | 1 | moodle/backup:backupcourse | 1 | 1363148550 | 0 |
| 8 | 1 | 3 | moodle/backup:backupsection | 1 | 1363148550 | 0 |
| 9 | 1 | 1 | moodle/backup:backupsection | 1 | 1363148550 | 0 |
| 10 | 1 | 3 | moodle/backup:backupactivity | 1 | 1363148550 | 0 |
| 11 | 1 | 1 | moodle/backup:backupactivity | 1 | 1363148550 | 0 |
| 14 | 1 | 3 | moodle/backup:backuptargetimport | 1 | 1363148551 | 0 |
| 15 | 1 | 1 | moodle/backup:backuptargetimport | 1 | 1363148551 | 0 |
| 16 | 1 | 3 | moodle/backup:downloadfile | 1 | 1363148551 | 0 |
| 17 | 1 | 1 | moodle/backup:downloadfile | 1 | 1363148551 | 0 |
| 18 | 1 | 3 | moodle/backup:configure | 1 | 1363148551 | 0 |
| 19 | 1 | 1 | moodle/backup:configure | 1 | 1363148551 | 0 |
| 20 | 1 | 1 | moodle/backup:userinfo | 1 | 1363148551 | 0 |
| 21 | 1 | 1 | moodle/backup:anonymise | 1 | 1363148551 | 0 |
| 22 | 1 | 3 | moodle/restore:restorecourse | 1 | 1363148551 | 0 |