Moodle/DB/mdl_role_allow_view の変更点

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

#author("2025-02-04T01:37:32+00:00","default:iseki","iseki")
*** mdl_role_allow_view
**** columns
#author("2025-02-04T01:40:05+00:00","default:iseki","iseki")
** mdl_role_allow_view
*** columns
<pre>
MariaDB [moodle_db]> show columns from mdl_role_allow_view;
+-----------+------------+------+-----+---------+----------------+
| Field     | Type       | Null | Key | Default | Extra          |
+-----------+------------+------+-----+---------+----------------+
| id        | bigint(10) | NO   | PRI | NULL    | auto_increment |
| roleid    | bigint(10) | NO   | MUL | NULL    |                |
| allowview | bigint(10) | NO   | MUL | NULL    |                |
+-----------+------------+------+-----+---------+----------------+
</pre>

**** select
*** select
<pre>
MariaDB [moodle_db]> select * from mdl_role_allow_view;
+----+--------+-----------+
| id | roleid | allowview |
+----+--------+-----------+
|  1 |      1 |         1 |
|  2 |      1 |         2 |
|  3 |      1 |         3 |
|  4 |      1 |         4 |
|  5 |      1 |         5 |
|  6 |      1 |         6 |
|  7 |      1 |         7 |
|  8 |      1 |         8 |
|  9 |      2 |         1 |
| 10 |      2 |         2 |
| 11 |      2 |         3 |
| 12 |      2 |         4 |
| 13 |      2 |         5 |
| 14 |      2 |         6 |
| 15 |      2 |         7 |
| 16 |      2 |         8 |
| 17 |      3 |         1 |
| 18 |      3 |         2 |
| 19 |      3 |         3 |
| 20 |      3 |         4 |
| 21 |      3 |         5 |
| 22 |      3 |         6 |
| 23 |      3 |         7 |
| 24 |      3 |         8 |
| 25 |      4 |         1 |
| 26 |      4 |         2 |
| 27 |      4 |         3 |
| 28 |      4 |         4 |
| 29 |      4 |         5 |
| 30 |      4 |         6 |
| 31 |      4 |         7 |
| 32 |      4 |         8 |
| 33 |      5 |         1 |
| 34 |      5 |         2 |
| 35 |      5 |         3 |
| 36 |      5 |         4 |
| 37 |      5 |         5 |
| 38 |      5 |         6 |
| 39 |      5 |         7 |
| 40 |      5 |         8 |
| 41 |      6 |         1 |
| 42 |      6 |         2 |
| 43 |      6 |         3 |
| 44 |      6 |         4 |
| 45 |      6 |         5 |
| 46 |      6 |         6 |
| 47 |      6 |         7 |
| 48 |      6 |         8 |
| 49 |      7 |         1 |
| 50 |      7 |         2 |
| 51 |      7 |         3 |
| 52 |      7 |         4 |
| 53 |      7 |         5 |
| 54 |      7 |         6 |
| 55 |      7 |         7 |
| 56 |      7 |         8 |
| 57 |      8 |         1 |
| 58 |      8 |         2 |
| 59 |      8 |         3 |
| 60 |      8 |         4 |
| 61 |      8 |         5 |
| 62 |      8 |         6 |
| 63 |      8 |         7 |
| 64 |      8 |         8 |
+----+--------+-----------+
</pre>