Hi everyone.
I try to help to prepare statistics for a report to Wikimania, so we use selective list of `page_id`s and try to analyze revisions, logs and others info from ruwiki_p database. But there are some strange problems in using db.
For example, by http://www.mediawiki.org/wiki/Manual:Logging_table in table `logging` should be field `log_page` similar to `page_id`, but there is no such...
Also by http://www.mediawiki.org/wiki/Manual:Archive_table in table `archive` should be field `ar_comment`, but there is no such...
Maybe there are other bugs in db, but I found just these two, and they create difficulties in our work. Can anybody fix them? or what can you advice to do?
Dmitry.
In addition (dbname = ruwiki_p):
mysql> DESCRIBE logging; +---------------+---------------------+------+-----+----------------+------- + | Field | Type | Null | Key | Default | Extra | +---------------+---------------------+------+-----+----------------+------- + | log_id | int(10) unsigned | NO | | 0 | | | log_type | varchar(32) | NO | | | | | log_action | varchar(32) | NO | | | | | log_timestamp | varchar(14) | NO | | 19700101000000 | | | log_user | int(10) unsigned | NO | | 0 | | | log_namespace | int(11) | NO | | 0 | | | log_deleted | tinyint(3) unsigned | NO | | 0 | | | log_user_text | varchar(255) | NO | | | | | log_title | varchar(255) | NO | | | | | log_comment | varchar(255) | NO | | | | | log_params | longblob | NO | | NULL | | +---------------+---------------------+------+-----+----------------+------- + 11 rows in set (0.00 sec)
mysql> describe archive; +---------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------------+------+-----+---------+-------+ | ar_namespace | int(11) | NO | | 0 | | | ar_title | varchar(255) | NO | | | | | ar_user | int(5) unsigned | NO | | 0 | | | ar_user_text | varchar(255) | NO | | | | | ar_timestamp | varchar(14) | NO | | | | | ar_minor_edit | tinyint(1) | NO | | 0 | | | ar_flags | tinyblob | NO | | NULL | | | ar_rev_id | int(8) unsigned | YES | | NULL | | | ar_len | int(8) unsigned | YES | | NULL | | | ar_page_id | int(10) unsigned | YES | | NULL | | | ar_parent_id | int(10) unsigned | YES | | NULL | | +---------------+------------------+------+-----+---------+-------+ 11 rows in set (0.00 sec)