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)

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)

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)

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)

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)

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)