Moodle/DB/mdl_role_allow_assign の変更点

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

#author("2025-02-04T01:36:54+00:00","default:iseki","iseki")
*** mdl_role_allow_assign
#author("2025-02-04T01:39:30+00:00","default:iseki","iseki")
** mdl_role_allow_assign

**** columns
*** columns
<pre>
MariaDB [moodle_db]> show columns from mdl_role_allow_assign;
+-------------+------------+------+-----+---------+----------------+
| Field       | Type       | Null | Key | Default | Extra          |
+-------------+------------+------+-----+---------+----------------+
| id          | bigint(10) | NO   | PRI | NULL    | auto_increment |
| roleid      | bigint(10) | NO   | MUL | 0       |                |
| allowassign | bigint(10) | NO   | MUL | 0       |                |
+-------------+------------+------+-----+---------+----------------+
</pre>

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