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 | |
+--------------+--------------+------+-----+---------+----------------+
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 |
+-------+--------------+------------+---------------------------+-------+--------+