Moodle/DB/mdl_role_context_levels の変更点

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

#author("2025-02-04T01:38:31+00:00","default:iseki","iseki")
#author("2025-02-04T01:38:37+00:00","default:iseki","iseki")
** mdl_role_context_levels  
*** columns
<pre>
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    |                |
+--------------+------------+------+-----+---------+----------------+
</pre>

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