altwiki
をテンプレートにして作成
[
トップ
] [
タイトル一覧
|
ページ一覧
|
新規
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
** ALTWiki [#yd88b9d9]
*** DFWiki を勝手に Moodle2 用に [#b1c147fe]
**** altwiki [#d7455988]
mysql> show columns from mdl_altwiki;
+--------------------+--------------+------+-----+------...
| Field | Type | Null | Key | Defau...
+--------------------+--------------+------+-----+------...
| id | bigint(10) | NO | PRI | NULL ...
| course | bigint(10) | NO | MUL | 0 ...
| name | varchar(255) | NO | | Wiki ...
| intro | longtext | YES | | NULL ...
| introformat | smallint(4) | NO | | 0 ...
| pagename | varchar(160) | NO | | ...
| timecreated | bigint(10) | NO | | 0 ...
| timemodified | bigint(10) | NO | | 0 ...
| editable | tinyint(1) | NO | | 1 ...
| attach | tinyint(1) | NO | | 0 ...
| upload | tinyint(1) | NO | | 0 ...
| restore | tinyint(1) | NO | | 0 ...
| editor | varchar(40) | NO | | dfwik...
| groupmode | tinyint(1) | NO | | 0 ...
| studentmode | tinyint(1) | NO | | 0 ...
| teacherdiscussion | tinyint(1) | NO | | 0 ...
| studentdiscussion | tinyint(1) | NO | | 0 ...
| evaluation | varchar(40) | NO | | noeva...
| notetype | varchar(40) | NO | | quant...
| editanothergroup | tinyint(1) | NO | | 0 ...
| editanotherstudent | tinyint(1) | NO | | 0 ...
| votemode | tinyint(1) | NO | | 0 ...
| listofteachers | tinyint(1) | NO | | 0 ...
| editorrows | smallint(4) | NO | | 25 ...
| editorcols | smallint(4) | NO | | 80 ...
| wikicourse | bigint(10) | NO | | 0 ...
+--------------------+--------------+------+-----+------...
26 rows in set (0.00 sec)
**** altwiki_pages [#s3094b47]
mysql> show columns from mdl_altwiki_pages;
+--------------+--------------+------+-----+----------+-...
| Field | Type | Null | Key | Default | ...
+--------------+--------------+------+-----+----------+-...
| id | bigint(10) | NO | PRI | NULL | ...
| pagename | varchar(160) | NO | MUL | pagename | ...
| version | mediumint(6) | NO | | 0 | ...
| content | longtext | NO | | NULL | ...
| userid | bigint(10) | NO | | 0 | ...
| author | varchar(100) | NO | | wiki | ...
| timecreated | bigint(10) | NO | | 0 | ...
| timemodified | bigint(10) | NO | | 0 | ...
| refs | longtext | NO | | NULL | ...
| hits | mediumint(6) | NO | | 0 | ...
| editable | tinyint(1) | NO | | 1 | ...
| highlight | tinyint(1) | NO | | 0 | ...
| altwiki | bigint(10) | NO | | 0 | ...
| editor | varchar(40) | NO | | dfwiki | ...
| groupid | bigint(10) | NO | | 0 | ...
| ownerid | bigint(10) | NO | | 0 | ...
| evaluation | longtext | NO | | NULL | ...
+--------------+--------------+------+-----+----------+-...
17 rows in set (0.00 sec)
**** altwiki_synonymous [#ca1a4a72]
mysql> show columns from mdl_altwiki_synonymous;
+----------+--------------+------+-----+---------+------...
| Field | Type | Null | Key | Default | Extra...
+----------+--------------+------+-----+---------+------...
| id | bigint(10) | NO | PRI | NULL | auto_...
| syn | varchar(160) | NO | MUL | | ...
| original | varchar(160) | NO | | | ...
| altwiki | bigint(10) | NO | | 0 | ...
| groupid | bigint(10) | NO | | 0 | ...
| ownerid | bigint(10) | NO | | 0 | ...
+----------+--------------+------+-----+---------+------...
6 rows in set (0.00 sec)
**** altwiki_votes [#cbd4a50c]
mysql> show columns from mdl_altwiki_votes;
+----------+--------------+------+-----+---------+------...
| Field | Type | Null | Key | Default | Extra...
+----------+--------------+------+-----+---------+------...
| id | bigint(10) | NO | PRI | NULL | auto_...
| pagename | varchar(160) | NO | | | ...
| version | bigint(10) | NO | | 0 | ...
| altwiki | tinyint(1) | NO | | NULL | ...
| username | varchar(100) | NO | | | ...
+----------+--------------+------+-----+---------+------...
5 rows in set (0.00 sec)
**** altwiki_resources [#c6443c8c]
mysql> show columns from mdl_altwiki_resources;
+----------+--------------+------+-----+---------+------...
| Field | Type | Null | Key | Default | Extra...
+----------+--------------+------+-----+---------+------...
| id | bigint(10) | NO | PRI | NULL | auto_...
| altwiki | bigint(10) | NO | MUL | 0 | ...
| pagename | varchar(160) | NO | | | ...
+----------+--------------+------+-----+---------+------...
3 rows in set (0.00 sec)
**** files [#x14cd037]
mysql> show columns from mdl_files;
+-------------------+--------------+------+-----+-------...
| Field | Type | Null | Key | Defaul...
+-------------------+--------------+------+-----+-------...
| id | bigint(10) | NO | PRI | NULL ...
| contenthash | varchar(40) | NO | MUL | ...
| pathnamehash | varchar(40) | NO | UNI | ...
| contextid | bigint(10) | NO | MUL | NULL ...
| component | varchar(100) | NO | MUL | ...
| filearea | varchar(50) | NO | | ...
| itemid | bigint(10) | NO | | NULL ...
| filepath | varchar(255) | NO | | ...
| filename | varchar(255) | NO | | ...
| userid | bigint(10) | YES | MUL | NULL ...
| filesize | bigint(10) | NO | | NULL ...
| mimetype | varchar(100) | YES | | NULL ...
| status | bigint(10) | NO | | 0 ...
| source | longtext | YES | | NULL ...
| author | varchar(255) | YES | | NULL ...
| license | varchar(255) | YES | | NULL ...
| timecreated | bigint(10) | NO | | NULL ...
| timemodified | bigint(10) | NO | | NULL ...
| sortorder | bigint(10) | NO | | 0 ...
| referencefileid | bigint(10) | YES | MUL | NULL ...
| referencelastsync | bigint(10) | YES | | NULL ...
| referencelifetime | bigint(10) | YES | | NULL ...
+-------------------+--------------+------+-----+-------...
22 rows in set (0.00 sec)
終了行:
** ALTWiki [#yd88b9d9]
*** DFWiki を勝手に Moodle2 用に [#b1c147fe]
**** altwiki [#d7455988]
mysql> show columns from mdl_altwiki;
+--------------------+--------------+------+-----+------...
| Field | Type | Null | Key | Defau...
+--------------------+--------------+------+-----+------...
| id | bigint(10) | NO | PRI | NULL ...
| course | bigint(10) | NO | MUL | 0 ...
| name | varchar(255) | NO | | Wiki ...
| intro | longtext | YES | | NULL ...
| introformat | smallint(4) | NO | | 0 ...
| pagename | varchar(160) | NO | | ...
| timecreated | bigint(10) | NO | | 0 ...
| timemodified | bigint(10) | NO | | 0 ...
| editable | tinyint(1) | NO | | 1 ...
| attach | tinyint(1) | NO | | 0 ...
| upload | tinyint(1) | NO | | 0 ...
| restore | tinyint(1) | NO | | 0 ...
| editor | varchar(40) | NO | | dfwik...
| groupmode | tinyint(1) | NO | | 0 ...
| studentmode | tinyint(1) | NO | | 0 ...
| teacherdiscussion | tinyint(1) | NO | | 0 ...
| studentdiscussion | tinyint(1) | NO | | 0 ...
| evaluation | varchar(40) | NO | | noeva...
| notetype | varchar(40) | NO | | quant...
| editanothergroup | tinyint(1) | NO | | 0 ...
| editanotherstudent | tinyint(1) | NO | | 0 ...
| votemode | tinyint(1) | NO | | 0 ...
| listofteachers | tinyint(1) | NO | | 0 ...
| editorrows | smallint(4) | NO | | 25 ...
| editorcols | smallint(4) | NO | | 80 ...
| wikicourse | bigint(10) | NO | | 0 ...
+--------------------+--------------+------+-----+------...
26 rows in set (0.00 sec)
**** altwiki_pages [#s3094b47]
mysql> show columns from mdl_altwiki_pages;
+--------------+--------------+------+-----+----------+-...
| Field | Type | Null | Key | Default | ...
+--------------+--------------+------+-----+----------+-...
| id | bigint(10) | NO | PRI | NULL | ...
| pagename | varchar(160) | NO | MUL | pagename | ...
| version | mediumint(6) | NO | | 0 | ...
| content | longtext | NO | | NULL | ...
| userid | bigint(10) | NO | | 0 | ...
| author | varchar(100) | NO | | wiki | ...
| timecreated | bigint(10) | NO | | 0 | ...
| timemodified | bigint(10) | NO | | 0 | ...
| refs | longtext | NO | | NULL | ...
| hits | mediumint(6) | NO | | 0 | ...
| editable | tinyint(1) | NO | | 1 | ...
| highlight | tinyint(1) | NO | | 0 | ...
| altwiki | bigint(10) | NO | | 0 | ...
| editor | varchar(40) | NO | | dfwiki | ...
| groupid | bigint(10) | NO | | 0 | ...
| ownerid | bigint(10) | NO | | 0 | ...
| evaluation | longtext | NO | | NULL | ...
+--------------+--------------+------+-----+----------+-...
17 rows in set (0.00 sec)
**** altwiki_synonymous [#ca1a4a72]
mysql> show columns from mdl_altwiki_synonymous;
+----------+--------------+------+-----+---------+------...
| Field | Type | Null | Key | Default | Extra...
+----------+--------------+------+-----+---------+------...
| id | bigint(10) | NO | PRI | NULL | auto_...
| syn | varchar(160) | NO | MUL | | ...
| original | varchar(160) | NO | | | ...
| altwiki | bigint(10) | NO | | 0 | ...
| groupid | bigint(10) | NO | | 0 | ...
| ownerid | bigint(10) | NO | | 0 | ...
+----------+--------------+------+-----+---------+------...
6 rows in set (0.00 sec)
**** altwiki_votes [#cbd4a50c]
mysql> show columns from mdl_altwiki_votes;
+----------+--------------+------+-----+---------+------...
| Field | Type | Null | Key | Default | Extra...
+----------+--------------+------+-----+---------+------...
| id | bigint(10) | NO | PRI | NULL | auto_...
| pagename | varchar(160) | NO | | | ...
| version | bigint(10) | NO | | 0 | ...
| altwiki | tinyint(1) | NO | | NULL | ...
| username | varchar(100) | NO | | | ...
+----------+--------------+------+-----+---------+------...
5 rows in set (0.00 sec)
**** altwiki_resources [#c6443c8c]
mysql> show columns from mdl_altwiki_resources;
+----------+--------------+------+-----+---------+------...
| Field | Type | Null | Key | Default | Extra...
+----------+--------------+------+-----+---------+------...
| id | bigint(10) | NO | PRI | NULL | auto_...
| altwiki | bigint(10) | NO | MUL | 0 | ...
| pagename | varchar(160) | NO | | | ...
+----------+--------------+------+-----+---------+------...
3 rows in set (0.00 sec)
**** files [#x14cd037]
mysql> show columns from mdl_files;
+-------------------+--------------+------+-----+-------...
| Field | Type | Null | Key | Defaul...
+-------------------+--------------+------+-----+-------...
| id | bigint(10) | NO | PRI | NULL ...
| contenthash | varchar(40) | NO | MUL | ...
| pathnamehash | varchar(40) | NO | UNI | ...
| contextid | bigint(10) | NO | MUL | NULL ...
| component | varchar(100) | NO | MUL | ...
| filearea | varchar(50) | NO | | ...
| itemid | bigint(10) | NO | | NULL ...
| filepath | varchar(255) | NO | | ...
| filename | varchar(255) | NO | | ...
| userid | bigint(10) | YES | MUL | NULL ...
| filesize | bigint(10) | NO | | NULL ...
| mimetype | varchar(100) | YES | | NULL ...
| status | bigint(10) | NO | | 0 ...
| source | longtext | YES | | NULL ...
| author | varchar(255) | YES | | NULL ...
| license | varchar(255) | YES | | NULL ...
| timecreated | bigint(10) | NO | | NULL ...
| timemodified | bigint(10) | NO | | NULL ...
| sortorder | bigint(10) | NO | | 0 ...
| referencefileid | bigint(10) | YES | MUL | NULL ...
| referencelastsync | bigint(10) | YES | | NULL ...
| referencelifetime | bigint(10) | YES | | NULL ...
+-------------------+--------------+------+-----+-------...
22 rows in set (0.00 sec)
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
