mdl_role[edit]

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

select[edit]

MariaDB [moodle_db]> select * from mdl_role;
+----+------+----------------+-------------+-----------+----------------+
| id | name | shortname      | description | sortorder | archetype      |
+----+------+----------------+-------------+-----------+----------------+
|  1 |      | manager        |             |         1 | manager        |
|  2 |      | coursecreator  |             |         2 | coursecreator  |
|  3 |      | editingteacher |             |         3 | editingteacher |
|  4 |      | teacher        |             |         4 | teacher        |
|  5 |      | student        |             |         6 | student        |
|  6 |      | guest          |             |         8 | guest          |
|  7 |      | user           |             |         5 | user           |
|  8 |      | frontpage      |             |         7 | frontpage      |
+----+------+----------------+-------------+-----------+----------------+

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