![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
#author("2025-02-04T01:44:31+00:00","default:iseki","iseki") ** mdl_context *** columns <pre> 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 | | +--------------+--------------+------+-----+---------+----------------+ </pre> *** select <pre> 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 | +-------+--------------+------------+---------------------------+-------+--------+ </pre>
