Talk:Revision table
From MediaWiki.org
Trying to understand how some of the tables relate (Page,Archive,Revision,Text)... Is a current page's content also stored in the text table ? even though the field prefix is old_ ?
Yes, the content (current and past) is stored in text table. "Field names are a holdover from the 'old' revisions table in MediaWiki 1.4 and earlier" (tables.sql).
[edit] Problem with import wiki to MySQL
I have a dump of Simple Wikipedia of 9.9.2007 and MediaWiki version 1.11. Table revision in Simple WP has 9 fields, in MediaWiki - 11 fields.
So, when I have tried upload, I have got an error:
- mysql> source /simple20070909/revision.sql
- ERROR 1136 (21S01): Column count doesn't match value count at row 1
Remove two fields, source..., then add them back:
- mysql> ALTER TABLE revision DROP COLUMN rev_len, DROP COLUMN rev_parent_id;
- mysql> source /simple20070909/revision.sql
- mysql> ALTER TABLE revision ADD COLUMN rev_len INT(10) UNSIGNED DEFAULT NULL AFTER rev_deleted, ADD COLUMN rev_parent_id INT(10) UNSIGNED DEFAULT NULL AFTER rev_len;
If two fields were not added, then MediaWiki generates an error:
- from within function "Revision::fetchRow". MySQL returned error "1054: Unknown column 'rev_len' in 'field list' (localhost)".
--AKA MBG 11:48, 11 September 2007 (UTC)
