Moodle/DB/mdl_role_allow_switch の変更点

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

#author("2025-02-04T01:36:34+00:00","default:iseki","iseki")
*** mdl_role_allow_switch 
**** columns
#author("2025-02-04T01:39:49+00:00","default:iseki","iseki")
** mdl_role_allow_switch 
*** columns
<pre>
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    |                |
+-------------+------------+------+-----+---------+----------------+
</pre>

**** select
*** select
<pre>
MariaDB [moodle_db]> select * from mdl_role_allow_switch;
+----+--------+-------------+
| id | roleid | allowswitch |
+----+--------+-------------+
|  1 |      1 |           3 |
|  2 |      1 |           4 |
|  3 |      1 |           5 |
|  4 |      1 |           6 |
|  5 |      2 |           4 |
|  6 |      2 |           5 |
|  7 |      2 |           6 |
|  8 |      3 |           4 |
|  9 |      3 |           5 |
| 10 |      3 |           6 |
| 11 |      4 |           5 |
| 12 |      4 |           6 |
+----+--------+-------------+
</pre>