Moodle/role のバックアップ(No.2)

ROLE[edit]

DB[edit]

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