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       |                |
+--------------+--------------+------+-----+---------+----------------+

select[edit]

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 |

トップ   編集 凍結 差分 バックアップ 添付 複製 名前変更 リロード   新規 ページ一覧 検索 最終更新   ヘルプ   最終更新のRSS
Last-modified: 2025-02-04 (火) 10:38:17