rendered paste bodymysql> use wikidb_quality;
Database changed
mysql> describe ratedpage;
+--------------+-----------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-----------------+------+-----+---------+----------------+
| ratedpage_id | int(8) unsigned | NO | PRI | NULL | auto_increment |
| page_id | int(8) unsigned | NO | UNI | 0 | |
| rating | char(1) | NO | | T | |
+--------------+-----------------+------+-----+---------+----------------+
3 rows in set (0.08 sec)
mysql> describe ratedtext;
+--------------+-----------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-----------------+------+-----+---------+-------+
| ratedpage_id | int(8) unsigned | NO | PRI | | |
| html_text | mediumblob | YES | | NULL | |
| plain_text | mediumblob | YES | | NULL | |
| pos_text | mediumblob | YES | | NULL | |
| parsed_text | mediumblob | YES | | NULL | |
+--------------+-----------------+------+-----+---------+-------+
5 rows in set (0.02 sec)
mysql> describe features;
+--------------------------+-----------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------------+-----------------+------+-----+---------+-------+
| ratedpage_id | int(8) unsigned | NO | PRI | | |
| words | double | YES | | NULL | |
| averagewordlength | double | YES | | NULL | |
| averagenumberofsyllables | double | YES | | NULL | |
| numberofsentences | double | YES | | NULL | |
| averagesentencelength | double | YES | | NULL | |
| averagelengthofparagraph | double | YES | | NULL | |
| proportionofquestions | double | YES | | NULL | |
| conjunctions | double | YES | | NULL | |
| pronouns | double | YES | | NULL | |
| prepositions | double | YES | | NULL | |
| nominalizations | double | YES | | NULL | |
| colemanliau | double | YES | | NULL | |
| fleschindex | double | YES | | NULL | |
| kincaid | double | YES | | NULL | |
| smoggrading | double | YES | | NULL | |
| ari | double | YES | | NULL | |
| fogindex | double | YES | | NULL | |
| tobe | double | YES | | NULL | |
| lix | double | YES | | NULL | |
| age | double | YES | | NULL | |
| length | double | YES | | NULL | |
| templates | double | YES | | NULL | |
| external | double | YES | | NULL | |
| internal | double | YES | | NULL | |
| relative | double | YES | | NULL | |
| images | double | YES | | NULL | |
| paragraphs | double | YES | | NULL | |
| categories | double | YES | | NULL | |
| h2 | double | YES | | NULL | |
| h3 | double | YES | | NULL | |
| h4 | double | YES | | NULL | |
| interlanguagelinks | double | YES | | NULL | |
| referencecount | double | YES | | NULL | |
| pagerank | double | YES | | NULL | |
+--------------------------+-----------------+------+-----+---------+-------+
35 rows in set (0.02 sec)
mysql>