Moodle/DB/mdl_role
をテンプレートにして作成
[
トップ
] [
タイトル一覧
|
ページ一覧
|
新規
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
** mdl_role
*** columns
<pre>
MariaDB [moodle_db]> show columns from mdl_role;
+-------------+--------------+------+-----+---------+----...
| Field | Type | Null | Key | Default | Ext...
+-------------+--------------+------+-----+---------+----...
| id | bigint(10) | NO | PRI | NULL | aut...
| name | varchar(255) | NO | | | ...
| shortname | varchar(100) | NO | UNI | | ...
| description | longtext | NO | | NULL | ...
| sortorder | bigint(10) | NO | UNI | 0 | ...
| archetype | varchar(30) | NO | | | ...
+-------------+--------------+------+-----+---------+----...
</pre>
*** select
<pre>
MariaDB [moodle_db]> select * from mdl_role;
+----+------+----------------+-------------+-----------+-...
| id | name | shortname | description | sortorder | ...
+----+------+----------------+-------------+-----------+-...
| 1 | | manager | | 1 | ...
| 2 | | coursecreator | | 2 | ...
| 3 | | editingteacher | | 3 | ...
| 4 | | teacher | | 4 | ...
| 5 | | student | | 6 | ...
| 6 | | guest | | 8 | ...
| 7 | | user | | 5 | ...
| 8 | | frontpage | | 7 | ...
+----+------+----------------+-------------+-----------+-...
</pre>
終了行:
** mdl_role
*** columns
<pre>
MariaDB [moodle_db]> show columns from mdl_role;
+-------------+--------------+------+-----+---------+----...
| Field | Type | Null | Key | Default | Ext...
+-------------+--------------+------+-----+---------+----...
| id | bigint(10) | NO | PRI | NULL | aut...
| name | varchar(255) | NO | | | ...
| shortname | varchar(100) | NO | UNI | | ...
| description | longtext | NO | | NULL | ...
| sortorder | bigint(10) | NO | UNI | 0 | ...
| archetype | varchar(30) | NO | | | ...
+-------------+--------------+------+-----+---------+----...
</pre>
*** select
<pre>
MariaDB [moodle_db]> select * from mdl_role;
+----+------+----------------+-------------+-----------+-...
| id | name | shortname | description | sortorder | ...
+----+------+----------------+-------------+-----------+-...
| 1 | | manager | | 1 | ...
| 2 | | coursecreator | | 2 | ...
| 3 | | editingteacher | | 3 | ...
| 4 | | teacher | | 4 | ...
| 5 | | student | | 6 | ...
| 6 | | guest | | 8 | ...
| 7 | | user | | 5 | ...
| 8 | | frontpage | | 7 | ...
+----+------+----------------+-------------+-----------+-...
</pre>
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
