Moodle/DB/mdl_context
をテンプレートにして作成
[
トップ
] [
タイトル一覧
|
ページ一覧
|
新規
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
** mdl_context
*** columns
<pre>
MariaDB [moodle_db]> show columns from mdl_context;
+--------------+--------------+------+-----+---------+---...
| Field | Type | Null | Key | Default | Ex...
+--------------+--------------+------+-----+---------+---...
| id | bigint(10) | NO | PRI | NULL | au...
| 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 cont...
+-------+--------------+------------+--------------------...
| id | contextlevel | instanceid | path ...
+-------+--------------+------------+--------------------...
| 3 | 40 | 1 | /1/3 ...
| 17 | 40 | 2 | /1/17 ...
| 18 | 40 | 3 | /1/17/1973/3551/18 ...
| 21 | 40 | 6 | /1/50/21 ...
| 29 | 40 | 7 | /1/3/29 ...
| 50 | 40 | 8 | /1/50 ...
| 51 | 40 | 9 | /1/50/51 ...
| 52 | 40 | 10 | /1/557/52 ...
| 77 | 40 | 11 | /1/50/77 ...
| 557 | 40 | 12 | /1/557 ...
| 1016 | 40 | 14 | /1/17/1973/1016 ...
| 1017 | 40 | 15 | /1/17/1973/1016/101...
| 1018 | 40 | 16 | /1/17/1973/1016/101...
| 1019 | 40 | 17 | /1/17/1973/1016/101...
| 1361 | 40 | 18 | /1/1361 ...
| 1513 | 40 | 19 | /1/50/1513 ...
| 1515 | 40 | 20 | /1/3/1515 ...
| 1724 | 40 | 21 | /1/17/1973/3551/172...
| 1973 | 40 | 22 | /1/17/1973 ...
| 1974 | 40 | 23 | /1/17/1973/1974 ...
| 1975 | 40 | 24 | /1/17/1973/1974/197...
| 1976 | 40 | 25 | /1/17/1973/1974/197...
| 1977 | 40 | 26 | /1/17/1973/1974/197...
| 1978 | 40 | 27 | /1/17/1973/1974/197...
| 1979 | 40 | 28 | /1/17/1973/3551/197...
| 2104 | 40 | 29 | /1/17/2104 ...
| 2134 | 40 | 30 | /1/17/1973/3551/213...
| 3551 | 40 | 31 | /1/17/1973/3551 ...
| 3553 | 40 | 32 | /1/17/1973/6843/355...
| 3571 | 40 | 33 | /1/17/1973/6843/357...
| 3573 | 40 | 34 | /1/17/1973/6843/357...
| 3594 | 40 | 35 | /1/17/1973/3551/359...
| 3595 | 40 | 36 | /1/17/1973/6843/359...
| 3643 | 40 | 37 | /1/3643 ...
| 3688 | 40 | 39 | /1/17/1973/6843/355...
| 6470 | 40 | 40 | /1/17/1973/6843/647...
| 6843 | 40 | 41 | /1/17/1973/6843 ...
| 6844 | 40 | 42 | /1/17/6844 ...
| 6845 | 40 | 43 | /1/17/1973/6845 ...
| 7023 | 40 | 44 | /1/17/7023 ...
| 8457 | 40 | 46 | /1/17/1973/8457 ...
| 8458 | 40 | 47 | /1/17/1973/8457/845...
| 8459 | 40 | 48 | /1/17/1973/8457/845...
| 8460 | 40 | 49 | /1/17/1973/8457/846...
| 8461 | 40 | 50 | /1/17/1973/8457/846...
| 8473 | 40 | 51 | /1/17/8473 ...
| 9195 | 40 | 52 | /1/9195 ...
| 9763 | 40 | 53 | /1/9763 ...
| 10137 | 40 | 54 | /1/10137 ...
| 10145 | 40 | 55 | /1/17/10145 ...
| 11075 | 40 | 56 | /1/17/1973/11075 ...
| 11552 | 40 | 57 | /1/17/11552 ...
| 14130 | 40 | 58 | /1/17/1973/14130 ...
| 14214 | 40 | 59 | /1/17/14214 ...
| 17461 | 40 | 60 | /1/17461 ...
| 17462 | 40 | 61 | /1/17461/17462 ...
| 17673 | 40 | 62 | /1/17/1973/17673 ...
| 20352 | 40 | 63 | /1/17461/20352 ...
| 22409 | 40 | 65 | /1/17/1973/30938/22...
| 22410 | 40 | 66 | /1/17/1973/30938/22...
| 22567 | 40 | 67 | /1/17/1973/22567 ...
| 30938 | 40 | 68 | /1/17/1973/30938 ...
+-------+--------------+------------+--------------------...
</pre>
終了行:
** mdl_context
*** columns
<pre>
MariaDB [moodle_db]> show columns from mdl_context;
+--------------+--------------+------+-----+---------+---...
| Field | Type | Null | Key | Default | Ex...
+--------------+--------------+------+-----+---------+---...
| id | bigint(10) | NO | PRI | NULL | au...
| 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 cont...
+-------+--------------+------------+--------------------...
| id | contextlevel | instanceid | path ...
+-------+--------------+------------+--------------------...
| 3 | 40 | 1 | /1/3 ...
| 17 | 40 | 2 | /1/17 ...
| 18 | 40 | 3 | /1/17/1973/3551/18 ...
| 21 | 40 | 6 | /1/50/21 ...
| 29 | 40 | 7 | /1/3/29 ...
| 50 | 40 | 8 | /1/50 ...
| 51 | 40 | 9 | /1/50/51 ...
| 52 | 40 | 10 | /1/557/52 ...
| 77 | 40 | 11 | /1/50/77 ...
| 557 | 40 | 12 | /1/557 ...
| 1016 | 40 | 14 | /1/17/1973/1016 ...
| 1017 | 40 | 15 | /1/17/1973/1016/101...
| 1018 | 40 | 16 | /1/17/1973/1016/101...
| 1019 | 40 | 17 | /1/17/1973/1016/101...
| 1361 | 40 | 18 | /1/1361 ...
| 1513 | 40 | 19 | /1/50/1513 ...
| 1515 | 40 | 20 | /1/3/1515 ...
| 1724 | 40 | 21 | /1/17/1973/3551/172...
| 1973 | 40 | 22 | /1/17/1973 ...
| 1974 | 40 | 23 | /1/17/1973/1974 ...
| 1975 | 40 | 24 | /1/17/1973/1974/197...
| 1976 | 40 | 25 | /1/17/1973/1974/197...
| 1977 | 40 | 26 | /1/17/1973/1974/197...
| 1978 | 40 | 27 | /1/17/1973/1974/197...
| 1979 | 40 | 28 | /1/17/1973/3551/197...
| 2104 | 40 | 29 | /1/17/2104 ...
| 2134 | 40 | 30 | /1/17/1973/3551/213...
| 3551 | 40 | 31 | /1/17/1973/3551 ...
| 3553 | 40 | 32 | /1/17/1973/6843/355...
| 3571 | 40 | 33 | /1/17/1973/6843/357...
| 3573 | 40 | 34 | /1/17/1973/6843/357...
| 3594 | 40 | 35 | /1/17/1973/3551/359...
| 3595 | 40 | 36 | /1/17/1973/6843/359...
| 3643 | 40 | 37 | /1/3643 ...
| 3688 | 40 | 39 | /1/17/1973/6843/355...
| 6470 | 40 | 40 | /1/17/1973/6843/647...
| 6843 | 40 | 41 | /1/17/1973/6843 ...
| 6844 | 40 | 42 | /1/17/6844 ...
| 6845 | 40 | 43 | /1/17/1973/6845 ...
| 7023 | 40 | 44 | /1/17/7023 ...
| 8457 | 40 | 46 | /1/17/1973/8457 ...
| 8458 | 40 | 47 | /1/17/1973/8457/845...
| 8459 | 40 | 48 | /1/17/1973/8457/845...
| 8460 | 40 | 49 | /1/17/1973/8457/846...
| 8461 | 40 | 50 | /1/17/1973/8457/846...
| 8473 | 40 | 51 | /1/17/8473 ...
| 9195 | 40 | 52 | /1/9195 ...
| 9763 | 40 | 53 | /1/9763 ...
| 10137 | 40 | 54 | /1/10137 ...
| 10145 | 40 | 55 | /1/17/10145 ...
| 11075 | 40 | 56 | /1/17/1973/11075 ...
| 11552 | 40 | 57 | /1/17/11552 ...
| 14130 | 40 | 58 | /1/17/1973/14130 ...
| 14214 | 40 | 59 | /1/17/14214 ...
| 17461 | 40 | 60 | /1/17461 ...
| 17462 | 40 | 61 | /1/17461/17462 ...
| 17673 | 40 | 62 | /1/17/1973/17673 ...
| 20352 | 40 | 63 | /1/17461/20352 ...
| 22409 | 40 | 65 | /1/17/1973/30938/22...
| 22410 | 40 | 66 | /1/17/1973/30938/22...
| 22567 | 40 | 67 | /1/17/1973/22567 ...
| 30938 | 40 | 68 | /1/17/1973/30938 ...
+-------+--------------+------------+--------------------...
</pre>
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
