mdl_context[edit]

columns[edit]

MariaDB [moodle_db]> show columns from mdl_context;
+--------------+--------------+------+-----+---------+----------------+
| Field        | Type         | Null | Key | Default | Extra          |
+--------------+--------------+------+-----+---------+----------------+
| id           | bigint(10)   | NO   | PRI | NULL    | auto_increment |
| contextlevel | bigint(10)   | NO   | MUL | 0       |                |
| instanceid   | bigint(10)   | NO   | MUL | 0       |                |
| path         | varchar(255) | YES  | MUL | NULL    |                |
| depth        | tinyint(2)   | NO   |     | 0       |                |
| locked       | tinyint(2)   | NO   |     | 0       |                |
+--------------+--------------+------+-----+---------+----------------+

select[edit]

MariaDB [moodle_db]> select * from mdl_context where contextlevel='40';
+-------+--------------+------------+---------------------------+-------+--------+
| id    | contextlevel | instanceid | path                      | depth | locked |
+-------+--------------+------------+---------------------------+-------+--------+
|     3 |           40 |          1 | /1/3                      |     2 |      0 |
|    17 |           40 |          2 | /1/17                     |     2 |      0 |
|    18 |           40 |          3 | /1/17/1973/3551/18        |     5 |      0 |
|    21 |           40 |          6 | /1/50/21                  |     3 |      0 |
|    29 |           40 |          7 | /1/3/29                   |     3 |      0 |
|    50 |           40 |          8 | /1/50                     |     2 |      0 |
|    51 |           40 |          9 | /1/50/51                  |     3 |      0 |
|    52 |           40 |         10 | /1/557/52                 |     3 |      0 |
|    77 |           40 |         11 | /1/50/77                  |     3 |      0 |
|   557 |           40 |         12 | /1/557                    |     2 |      0 |
|  1016 |           40 |         14 | /1/17/1973/1016           |     4 |      0 |
|  1017 |           40 |         15 | /1/17/1973/1016/1017      |     5 |      0 |
|  1018 |           40 |         16 | /1/17/1973/1016/1018      |     5 |      0 |
|  1019 |           40 |         17 | /1/17/1973/1016/1019      |     5 |      0 |
|  1361 |           40 |         18 | /1/1361                   |     2 |      0 |
|  1513 |           40 |         19 | /1/50/1513                |     3 |      0 |
|  1515 |           40 |         20 | /1/3/1515                 |     3 |      0 |
|  1724 |           40 |         21 | /1/17/1973/3551/1724      |     5 |      0 |
|  1973 |           40 |         22 | /1/17/1973                |     3 |      0 |
|  1974 |           40 |         23 | /1/17/1973/1974           |     4 |      0 |
|  1975 |           40 |         24 | /1/17/1973/1974/1975      |     5 |      0 |
|  1976 |           40 |         25 | /1/17/1973/1974/1976      |     5 |      0 |
|  1977 |           40 |         26 | /1/17/1973/1974/1977      |     5 |      0 |
|  1978 |           40 |         27 | /1/17/1973/1974/1978      |     5 |      0 |
|  1979 |           40 |         28 | /1/17/1973/3551/1979      |     5 |      0 |
|  2104 |           40 |         29 | /1/17/2104                |     3 |      0 |
|  2134 |           40 |         30 | /1/17/1973/3551/2134      |     5 |      0 |
|  3551 |           40 |         31 | /1/17/1973/3551           |     4 |      0 |
|  3553 |           40 |         32 | /1/17/1973/6843/3553      |     5 |      0 |
|  3571 |           40 |         33 | /1/17/1973/6843/3571      |     5 |      0 |
|  3573 |           40 |         34 | /1/17/1973/6843/3573      |     5 |      0 |
|  3594 |           40 |         35 | /1/17/1973/3551/3594      |     5 |      0 |
|  3595 |           40 |         36 | /1/17/1973/6843/3595      |     5 |      0 |
|  3643 |           40 |         37 | /1/3643                   |     2 |      0 |
|  3688 |           40 |         39 | /1/17/1973/6843/3553/3688 |     6 |      0 |
|  6470 |           40 |         40 | /1/17/1973/6843/6470      |     5 |      0 |
|  6843 |           40 |         41 | /1/17/1973/6843           |     4 |      0 |
|  6844 |           40 |         42 | /1/17/6844                |     3 |      0 |
|  6845 |           40 |         43 | /1/17/1973/6845           |     4 |      0 |
|  7023 |           40 |         44 | /1/17/7023                |     3 |      0 |
|  8457 |           40 |         46 | /1/17/1973/8457           |     4 |      0 |
|  8458 |           40 |         47 | /1/17/1973/8457/8458      |     5 |      0 |
|  8459 |           40 |         48 | /1/17/1973/8457/8459      |     5 |      0 |
|  8460 |           40 |         49 | /1/17/1973/8457/8460      |     5 |      0 |
|  8461 |           40 |         50 | /1/17/1973/8457/8461      |     5 |      0 |
|  8473 |           40 |         51 | /1/17/8473                |     3 |      0 |
|  9195 |           40 |         52 | /1/9195                   |     2 |      0 |
|  9763 |           40 |         53 | /1/9763                   |     2 |      0 |
| 10137 |           40 |         54 | /1/10137                  |     2 |      0 |
| 10145 |           40 |         55 | /1/17/10145               |     3 |      0 |
| 11075 |           40 |         56 | /1/17/1973/11075          |     4 |      0 |
| 11552 |           40 |         57 | /1/17/11552               |     3 |      0 |
| 14130 |           40 |         58 | /1/17/1973/14130          |     4 |      0 |
| 14214 |           40 |         59 | /1/17/14214               |     3 |      0 |
| 17461 |           40 |         60 | /1/17461                  |     2 |      0 |
| 17462 |           40 |         61 | /1/17461/17462            |     3 |      0 |
| 17673 |           40 |         62 | /1/17/1973/17673          |     4 |      0 |
| 20352 |           40 |         63 | /1/17461/20352            |     3 |      0 |
| 22409 |           40 |         65 | /1/17/1973/30938/22409    |     5 |      0 |
| 22410 |           40 |         66 | /1/17/1973/30938/22410    |     5 |      0 |
| 22567 |           40 |         67 | /1/17/1973/22567          |     4 |      0 |
| 30938 |           40 |         68 | /1/17/1973/30938          |     4 |      0 |
+-------+--------------+------------+---------------------------+-------+--------+

トップ   編集 凍結 差分 バックアップ 添付 複製 名前変更 リロード   新規 ページ一覧 検索 最終更新   ヘルプ   最終更新のRSS
Last-modified: 2025-02-04 (火) 10:44:31