![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
#author("2025-02-04T01:38:07+00:00","default:iseki","iseki") #author("2025-02-04T01:38:17+00:00","default:iseki","iseki") ** mdl_role_capabilities *** columns <pre> 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 | | +--------------+--------------+------+-----+---------+----------------+ </pre> **** select *** select <pre> 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 | </pre>
