Manual talk:Revision table

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).

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: --AKA MBG 11:48, 11 September 2007 (UTC)
 * from within function "Revision::fetchRow". MySQL returned error "1054: Unknown column 'rev_len' in 'field list' (localhost)".

Hostnames
There's an old discussion here: m:Talk:Privacy_policy/Archives/2003. Apparently they were still shown on some Wiipedias in 2003. --Nemo 10:58, 18 August 2010 (UTC)

rev_sha1
Hi! I updated my wiki, but it doesn't show the actually pagecontent. As I've seen in the database, I recognized that the sha1-row isn't filled in in the newer revisions. How can I fill the rows? Sorry for my english. Arc96 (talk) 15:26, 7 July 2012 (UTC)
 * Hello, there's a maintenance script for it. It's not listed in the page yet but the name is quite descriptive, populate .php. Nemo 21:50, 10 July 2012 (UTC)

Indices
Is this style okay, or do we need to use a wikitable? E.g.:

The "show index in revision" format is easier to maintain, but doesn't tell you on one row what fields pertain to an index. Leucosticte (talk) 20:53, 4 November 2012 (UTC)