[Toolserver-l] Problem with tables in database

[Dmitry]

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)