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)