Moodle/DB/mdl_role の変更点

• 追加された行はこの色です。
• 削除された行はこの色です。
• Moodle/DB/mdl_role へ行く。
• Moodle/DB/mdl_role の差分を削除

#author("2025-02-04T01:16:59+00:00","default:iseki","iseki")
*** mdl_role
**** columns
#author("2025-02-04T01:39:18+00:00","default:iseki","iseki")
** mdl_role
*** columns
<pre> 
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   |     |         |                |
+-------------+--------------+------+-----+---------+----------------+
</pre>

**** select
*** select
<pre>
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      |
+----+------+----------------+-------------+-----------+----------------+
</pre>