ページ内コンテンツ
ALTWiki 
DFWiki を勝手に Moodle2 用に
altwiki
mysql> show columns from mdl_altwiki; +--------------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+--------------+------+-----+---------+----------------+ | id | bigint(10) | NO | PRI | NULL | auto_increment | | 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 | | dfwiki | | | groupmode | tinyint(1) | NO | | 0 | | | studentmode | tinyint(1) | NO | | 0 | | | teacherdiscussion | tinyint(1) | NO | | 0 | | | studentdiscussion | tinyint(1) | NO | | 0 | | | evaluation | varchar(40) | NO | | noeval | | | 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
mysql> show columns from mdl_altwiki_pages; +--------------+--------------+------+-----+----------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+----------+----------------+ | id | bigint(10) | NO | PRI | NULL | auto_increment | | 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
mysql> show columns from mdl_altwiki_synonymous; +----------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+----------------+ | id | bigint(10) | NO | PRI | NULL | auto_increment | | 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
mysql> show columns from mdl_altwiki_votes; +----------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+----------------+ | id | bigint(10) | NO | PRI | NULL | auto_increment | | 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
mysql> show columns from mdl_altwiki_resources; +----------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+----------------+ | id | bigint(10) | NO | PRI | NULL | auto_increment | | altwiki | bigint(10) | NO | MUL | 0 | | | pagename | varchar(160) | NO | | | | +----------+--------------+------+-----+---------+----------------+ 3 rows in set (0.00 sec)
files
mysql> show columns from mdl_files; +-------------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+--------------+------+-----+---------+----------------+ | id | bigint(10) | NO | PRI | NULL | auto_increment | | 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)
Counter: 1052,
today: 2,
yesterday: 1
最終更新: 2013-06-26 (水) 22:18:34 (JST) (3949d) by iseki
