mdl_role[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 | | | |
+-------------+--------------+------+-----+---------+----------------+
mdl_role_allow_override[edit]
MariaDB [moodle_db]> show columns from mdl_role_allow_override;
+---------------+------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+------------+------+-----+---------+----------------+
| id | bigint(10) | NO | PRI | NULL | auto_increment |
| roleid | bigint(10) | NO | MUL | 0 | |
| allowoverride | bigint(10) | NO | MUL | 0 | |
+---------------+------------+------+-----+---------+----------------+
mdl_role_allow_switch[edit]
MariaDB [moodle_db]> show columns from mdl_role_allow_switch ;
+-------------+------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+------------+------+-----+---------+----------------+
| id | bigint(10) | NO | PRI | NULL | auto_increment |
| roleid | bigint(10) | NO | MUL | NULL | |
| allowswitch | bigint(10) | NO | MUL | NULL | |
+-------------+------------+------+-----+---------+----------------+
mdl_role_allow_view[edit]
MariaDB [moodle_db]> show columns from mdl_role_allow_view;
+-----------+------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------+------+-----+---------+----------------+
| id | bigint(10) | NO | PRI | NULL | auto_increment |
| roleid | bigint(10) | NO | MUL | NULL | |
| allowview | bigint(10) | NO | MUL | NULL | |
+-----------+------------+------+-----+---------+----------------+
mdl_role_assignments[edit]
MariaDB [moodle_db]> show columns from mdl_role_assignments ;
+--------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+----------------+
| id | bigint(10) | NO | PRI | NULL | auto_increment |
| roleid | bigint(10) | NO | MUL | 0 | |
| contextid | bigint(10) | NO | MUL | 0 | |
| userid | bigint(10) | NO | MUL | 0 | |
| timemodified | bigint(10) | NO | | 0 | |
| modifierid | bigint(10) | NO | | 0 | |
| component | varchar(100) | NO | MUL | | |
| itemid | bigint(10) | NO | | 0 | |
| sortorder | bigint(10) | NO | MUL | 0 | |
+--------------+--------------+------+-----+---------+----------------+
MariaDB [moodle_db]> select * from mdl_role_assignments where userid='2';
+-----+--------+-----------+--------+--------------+------------+-----------+--------+-----------+
| id | roleid | contextid | userid | timemodified | modifierid | component | itemid | sortorder |
+-----+--------+-----------+--------+--------------+------------+-----------+--------+-----------+
| 637 | 3 | 30 | 2 | 1397049316 | 2 | | 0 | 0 |
+-----+--------+-----------+--------+--------------+------------+-----------+--------+-----------+
mdl_role_capabilities[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 |
mdl_role_context_levels[edit]
MariaDB [moodle_db]> show columns from mdl_role_context_levels;
+--------------+------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------+------+-----+---------+----------------+
| id | bigint(10) | NO | PRI | NULL | auto_increment |
| roleid | bigint(10) | NO | MUL | NULL | |
| contextlevel | bigint(10) | NO | MUL | NULL | |
+--------------+------------+------+-----+---------+----------------+
MariaDB [moodle_db]> select * from mdl_role_context_levels;
+----+--------+--------------+
| id | roleid | contextlevel |
+----+--------+--------------+
| 1 | 1 | 10 |
| 4 | 2 | 10 |
| 2 | 1 | 40 |
| 5 | 2 | 40 |
| 3 | 1 | 50 |
| 20 | 3 | 50 |
| 8 | 4 | 50 |
| 18 | 5 | 50 |
| 32 | 6 | 50 |
| 21 | 3 | 70 |
| 9 | 4 | 70 |
| 19 | 5 | 70 |
| 33 | 6 | 70 |
| 34 | 6 | 80 |
+----+--------+--------------+
mdl_role_names[edit]
MariaDB [moodle_db]> show columns from mdl_role_names;
+-----------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+----------------+
| id | bigint(10) | NO | PRI | NULL | auto_increment |
| roleid | bigint(10) | NO | MUL | 0 | |
| contextid | bigint(10) | NO | MUL | 0 | |
| name | varchar(255) | NO | | | |
+-----------+--------------+------+-----+---------+----------------+
MariaDB [moodle_db]> select * from mdl_role_names;
+----+--------+-----------+--------------------+
| id | roleid | contextid | name |
+----+--------+-----------+--------------------+
| 1 | 5 | 22 | メンバ |
| 2 | 3 | 22 | 委員 |
| 3 | 4 | 22 | サポート |
| 4 | 3 | 1562 | 担当 |
| 5 | 5 | 1562 | 教員 |
| 6 | 4 | 1562 | アシスタント |
| 7 | 3 | 10138 | 管理者 |
| 8 | 4 | 10138 | サポート |
| 9 | 5 | 10138 | 学系教員 |
| 10 | 3 | 10165 | 学科長 |
| 11 | 4 | 10165 | 管理補助 |
| 12 | 5 | 10165 | 教員 |
+----+--------+-----------+--------------------+
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
