Руководство:Архивная таблица

This page is a translated version of the page Manual:Archive table and the translation is 6% complete.
Outdated translations are marked like this.
Manual:Содержание MediaWiki database layout archive таблица

Архивная таблица - это место, где MediaWiki хранит информацию об удаленных страницах. Страницы могут быть восстановлены или восстановлены администратором MediaWiki с помощью специальной страницы. Начиная с MediaWiki 1.5, содержимое страниц остается в текстовой таблице; время удаления заносится в таблицу журналов.

When a page is deleted, all its old revisions move from the revision table to the archive table. When a page is then undeleted, its revisions are removed from the archive table, and recreated in the revision table.

The archive table is broadly related to the old table and revision table in layout; since Gerrit change 51675 it has a primary key: ar_id.

Previous to MediaWiki 1.5, content from the text table was moved here, so individual revisions had non-empty ar_text contents. That text could have been compressed, and in those cases, it was marked by gzip on the revision's ar_flags field. There is also not presently a record of when deletion occurred, making it hard to separate multiple delete cycles or distinguish old deletions from recent deletions of pages that haven't been edited in a long time.

Fields

ar_id

Версия MediaWiki:
1.22
Gerrit change 51675

Primary key.

ar_namespace

Basic page information: contains the namespace of the deleted revision. These contain the value in page_namespace .

ar_title

Basic page information: contains the page title of the deleted page, which is the same as page_title .

ar_text

Версия MediaWiki:
1.4

Before MediaWiki 1.5, old archived pages saved their text here. Old archived pages have ar_text_id set to NULL; they do not point to an entry in the text table. Instead, this field is the place where the text resides. Undeleting content from an old archived page undeletes the text from this field.

Версии MediaWiki:
1.5 – 1.30

In newly deleted pages (MediaWiki 1.5 and later), the revision text remains in the text table. Such newly deleted pages will not store text in the archive table, but will rather reference the separately existing text rows. However, for text from pages, which have been archived in MediaWiki 1.4 and before, the ar_text field will still be used!

Text may be gzipped or otherwise funky.

ar_comment

Версия MediaWiki:
1.32

Basic revision information: contains the edit summary of the deleted revision, analogous to rev_comment .

(устарело); ar_comment_id and the comment table should be used instead!

ar_comment_id

Версия MediaWiki:
1.30

This is a foreign key to comment_id in the comment table.

ar_user

Basic revision information: contains the user ID of the user who made the deleted revision; it is the same as user_id and rev_user . The value for this field is 0 for anonymous edits, initializations scripts, and for some mass imports.

(устарело в 1.31) While Перенос баз данных на систему исполнителей is being done, and depending on the configuration setting $wgActorTableSchemaMigrationStage , this field may be empty and the actor performing the edit can be stored in the ar_actor field instead.

ar_user_text

Basic revision information: This field contains the text of the editor's username, or the IP address of the editor if the deleted revision was done by an unregistered user. Comparable to rev_user_text .

(устарело в 1.31) While Перенос баз данных на систему исполнителей is being done, and depending on the configuration setting $wgActorTableSchemaMigrationStage , this field may be empty and the actor performing the edit can be stored in the ar_actor field instead.

ar_actor

Версия MediaWiki:
1.31

This is a foreign key to actor_id in the actor table.

ar_timestamp

This field contains the time at which the revision was originally saved. It is the equivalent of rev_timestamp .

This is not the timestamp of article deletion; that is saved in the deletion log entry, in the logging table's log_timestamp .

ar_minor_edit

Basic revision information: Records whether the user marked the deleted revision as a Малое изменение. If the value for this field is 1, then the edit is tagged as 'minor'; it is 0 otherwise. This is equivalent to rev_minor_edit .

ar_flags

Версия MediaWiki:
1.30

This field is similar to old_flags in the text table. It was added in MediaWiki 1.5, but is most likely unused: For revisions archived with older versions, it is not used as it was not there at the time of their deletion; a conversion, which would have added flags for revisions, which already had been archived when the update to MediaWiki 1.5 or newer was being done, was not applied. Texts of revisions archived with MediaWiki 1.5 or later do not use this field; they themselves stay in the text table; together with their flags staying in old_flags .

ar_rev_id

Версия MediaWiki:
1.5

When revisions are deleted, their unique rev_id is stored here so it can be retained after undeletion. This is necessary to retain permalinks to given revisions after accidental delete cycles or messy operations like history merges.

Old entries from 1.4 will be NULL here, and a new rev_id will be created on undeletion for those revisions.

ar_text_id

Версии MediaWiki:
1.5 – 1.34

Для редакций, удаленных в MediaWiki 1.5 и более поздних версиях, это ключ к old_id в таблице text ; то есть это ключ к сохраненному тексту в бэкэнде хранилища. To avoid breaking the block-compression scheme and otherwise making storage changes harder, the actual text is *not* deleted from the text table; rather, the text is merely hidden by removal of the page and revision entries. Comparable to rev_text_id .

(удалено в 1.35) This column was replaced by content.content_address.

Old entries deleted under MediaWiki 1.2-1.4 will have NULL values in this field, and their ar_text and ar_flags fields will be used to create a new text row upon undeletion.

ar_deleted

Версия MediaWiki:
1.10

This field is reserved for the RevDelete/Suppression (Oversight) system. Equivalent to rev_deleted .

ar_len

Версия MediaWiki:
1.10

This field contains the length of the deleted revision, in bytes. Analogous to rev_len .

ar_page_id

Версия MediaWiki:
1.11

Reference to the page_id of the deleted page this archive row was created from. Useful for sysadmin fixing of large pages merged together in the archives, or for cleanly undeleting a page at its original ID number if possible. Comparable to rev_page . Will be NULL for pages deleted prior to 1.11.

Note that because of MediaWiki supporting partial undeletion and history split/merge, there is no guarantee ar_page_id matches the page ID it's going to be undeleted to.

ar_parent_id

Версия MediaWiki:
1.13

The revision id of the previous revision to the page. Populated from rev_parent_id . Will be null for revisions deleted prior to 1.13. First edits to newly created articles (and therefore the creation of the article) can be identified by the value of this field being 0.

ar_sha1

Версия MediaWiki:
1.19

The SHA-1 text content hash in base-36. Populated from rev_sha1 .

ar_content_format

Версии MediaWiki:
1.21 – 1.34

Content format for the archived revision, which is NULL by default and only stored if it differs from the page's default.

(удалено в 1.35) This column was removed. The ContentHandler class is able to automatically detect the content format, and replaces this column.

ar_content_model

Версии MediaWiki:
1.21 – 1.34

Content model for the archived revision, which is NULL by default and only stored if it differs from the page's default, as determined by ContentHandler::getDefaultModelFor( $title ).

(удалено в 1.35) This column was replaced by content.content_model, which references content_models.model_id.

Schema summary

Версия MediaWiki:
1.36

DESCRIBE archive;

+---------------+---------------------+------+-----+---------+----------------+
| Field         | Type                | Null | Key | Default | Extra          |
+---------------+---------------------+------+-----+---------+----------------+
| ar_id         | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| ar_namespace  | int(11)             | NO   | MUL | 0       |                |
| ar_title      | varbinary(255)      | NO   |     |         |                |
| ar_comment_id | bigint(20) unsigned | NO   |     | NULL    |                |
| ar_actor      | bigint(20) unsigned | NO   | MUL | NULL    |                |
| ar_timestamp  | binary(14)          | NO   |     | NULL    |                |
| ar_minor_edit | tinyint(4)          | NO   |     | 0       |                |
| ar_rev_id     | int(10) unsigned    | NO   | UNI | NULL    |                |
| ar_deleted    | tinyint(3) unsigned | NO   |     | 0       |                |
| ar_len        | int(10) unsigned    | YES  |     | NULL    |                |
| ar_page_id    | int(10) unsigned    | YES  |     | NULL    |                |
| ar_parent_id  | int(10) unsigned    | YES  |     | NULL    |                |
| ar_sha1       | varbinary(32)       | NO   |     |         |                |
+---------------+---------------------+------+-----+---------+----------------+
Версия MediaWiki:
1.35

DESCRIBE archive;

+---------------+---------------------+------+-----+----------------+----------------+
| Field         | Type                | Null | Key | Default        | Extra          |
+---------------+---------------------+------+-----+----------------+----------------+
| ar_id         | int(10) unsigned    | NO   | PRI | NULL           | auto_increment |
| ar_namespace  | int(11)             | NO   | MUL | 0              |                |
| ar_title      | varbinary(255)      | NO   |     |                |                |
| ar_comment_id | bigint(20) unsigned | NO   |     | NULL           |                |
| ar_actor      | bigint(20) unsigned | NO   | MUL | NULL           |                |
| ar_timestamp  | binary(14)          | NO   |     |                |                |
| ar_minor_edit | tinyint(4)          | NO   |     | 0              |                |
| ar_rev_id     | int(10) unsigned    | NO   | UNI | NULL           |                |
| ar_deleted    | tinyint(3) unsigned | NO   |     | 0              |                |
| ar_len        | int(10) unsigned    | YES  |     | NULL           |                |
| ar_page_id    | int(10) unsigned    | YES  |     | NULL           |                |
| ar_parent_id  | int(10) unsigned    | YES  |     | NULL           |                |
| ar_sha1       | varbinary(32)       | NO   |     |                |                |
+---------------+---------------------+------+-----+----------------+----------------+
Версия MediaWiki:
1.34

DESCRIBE archive;

+-------------------+---------------------+------+-----+----------------+----------------+
| Field             | Type                | Null | Key | Default        | Extra          |
+-------------------+---------------------+------+-----+----------------+----------------+
| ar_id             | int(10) unsigned    | NO   | PRI | NULL           | auto_increment |
| ar_namespace      | int(11)             | NO   | MUL | 0              |                |
| ar_title          | varbinary(255)      | NO   |     |                |                |
| ar_comment_id     | bigint(20) unsigned | NO   |     | NULL           |                |
| ar_actor          | bigint(20) unsigned | NO   | MUL | NULL           |                |
| ar_timestamp      | binary(14)          | NO   |     |                |                |
| ar_minor_edit     | tinyint(4)          | NO   |     | 0              |                |
| ar_rev_id         | int(10) unsigned    | NO   | UNI | NULL           |                |
| ar_text_id        | int(10) unsigned    | NO   |     | 0              |                |
| ar_deleted        | tinyint(3) unsigned | NO   |     | 0              |                |
| ar_len            | int(10) unsigned    | YES  |     | NULL           |                |
| ar_page_id        | int(10) unsigned    | YES  |     | NULL           |                |
| ar_parent_id      | int(10) unsigned    | YES  |     | NULL           |                |
| ar_sha1           | varbinary(32)       | NO   |     |                |                |
| ar_content_model  | varbinary(32)       | YES  |     | NULL           |                |
| ar_content_format | varbinary(64)       | YES  |     | NULL           |                |
+-------------------+---------------------+------+-----+----------------+----------------+
Версия MediaWiki:
1.33

DESCRIBE archive;

+-------------------+---------------------+------+-----+----------------+----------------+
| Field             | Type                | Null | Key | Default        | Extra          |
+-------------------+---------------------+------+-----+----------------+----------------+
| ar_id             | int(10) unsigned    | NO   | PRI | NULL           | auto_increment |
| ar_namespace      | int(11)             | NO   | MUL | 0              |                |
| ar_title          | varbinary(255)      | NO   |     |                |                |
| ar_comment_id     | bigint(20) unsigned | NO   |     | NULL           |                |
| ar_user           | int(10) unsigned    | NO   |     | 0              |                |
| ar_user_text      | varbinary(255)      | NO   | MUL |                |                |
| ar_actor          | bigint(20) unsigned | NO   | MUL | 0              |                |
| ar_timestamp      | binary(14)          | NO   |     |                |                |
| ar_minor_edit     | tinyint(4)          | NO   |     | 0              |                |
| ar_rev_id         | int(10) unsigned    | NO   | UNI | NULL           |                |
| ar_text_id        | int(10) unsigned    | NO   |     | 0              |                |
| ar_deleted        | tinyint(3) unsigned | NO   |     | 0              |                |
| ar_len            | int(10) unsigned    | YES  |     | NULL           |                |
| ar_page_id        | int(10) unsigned    | YES  |     | NULL           |                |
| ar_parent_id      | int(10) unsigned    | YES  |     | NULL           |                |
| ar_sha1           | varbinary(32)       | NO   |     |                |                |
| ar_content_model  | varbinary(32)       | YES  |     | NULL           |                |
| ar_content_format | varbinary(64)       | YES  |     | NULL           |                |
+-------------------+---------------------+------+-----+----------------+----------------+
Версия MediaWiki:
1.32

DESCRIBE archive;

+-------------------+---------------------+------+-----+----------------+----------------+
| Field             | Type                | Null | Key | Default        | Extra          |
+-------------------+---------------------+------+-----+----------------+----------------+
| ar_id             | int(10) unsigned    | NO   | PRI | NULL           | auto_increment |
| ar_namespace      | int(11)             | NO   | MUL | 0              |                |
| ar_title          | varbinary(255)      | NO   |     |                |                |
| ar_comment        | varbinary(767)      | NO   |     |                |                |
| ar_comment_id     | bigint(20) unsigned | NO   |     | 0              |                |
| ar_user           | int(10) unsigned    | NO   |     | 0              |                |
| ar_user_text      | varbinary(255)      | NO   | MUL |                |                |
| ar_actor          | bigint(20) unsigned | NO   | MUL | 0              |                |
| ar_timestamp      | binary(14)          | NO   |     |                |                |
| ar_minor_edit     | tinyint(4)          | NO   |     | 0              |                |
| ar_rev_id         | int(10) unsigned    | NO   | UNI | NULL           |                |
| ar_text_id        | int(10) unsigned    | NO   |     | 0              |                |
| ar_deleted        | tinyint(3) unsigned | NO   |     | 0              |                |
| ar_len            | int(10) unsigned    | YES  |     | NULL           |                |
| ar_page_id        | int(10) unsigned    | YES  |     | NULL           |                |
| ar_parent_id      | int(10) unsigned    | YES  |     | NULL           |                |
| ar_sha1           | varbinary(32)       | NO   |     |                |                |
| ar_content_model  | varbinary(32)       | YES  |     | NULL           |                |
| ar_content_format | varbinary(64)       | YES  |     | NULL           |                |
+-------------------+---------------------+------+-----+----------------+----------------+
Версия MediaWiki:
1.31

DESCRIBE archive;

+-------------------+---------------------+------+-----+----------------+----------------+
| Field             | Type                | Null | Key | Default        | Extra          |
+-------------------+---------------------+------+-----+----------------+----------------+
| ar_id             | int(10) unsigned    | NO   | PRI | NULL           | auto_increment |
| ar_namespace      | int(11)             | NO   | MUL | 0              |                |
| ar_title          | varbinary(255)      | NO   |     |                |                |
| ar_comment        | varbinary(767)      | NO   |     |                |                |
| ar_comment_id     | bigint(20) unsigned | NO   |     | 0              |                |
| ar_user           | int(10) unsigned    | NO   |     | 0              |                |
| ar_user_text      | varbinary(255)      | NO   | MUL |                |                |
| ar_actor          | bigint(20) unsigned | NO   | MUL | 0              |                |
| ar_timestamp      | binary(14)          | NO   |     |                |                |
| ar_minor_edit     | tinyint(4)          | NO   |     | 0              |                |
| ar_rev_id         | int(10) unsigned    | NO   | MUL | NULL           |                |
| ar_text_id        | int(10) unsigned    | NO   |     | 0              |                |
| ar_deleted        | tinyint(3) unsigned | NO   |     | 0              |                |
| ar_len            | int(10) unsigned    | YES  |     | NULL           |                |
| ar_page_id        | int(10) unsigned    | YES  |     | NULL           |                |
| ar_parent_id      | int(10) unsigned    | YES  |     | NULL           |                |
| ar_sha1           | varbinary(32)       | NO   |     |                |                |
| ar_content_model  | varbinary(32)       | YES  |     | NULL           |                |
| ar_content_format | varbinary(64)       | YES  |     | NULL           |                |
+-------------------+---------------------+------+-----+----------------+----------------+
Версия MediaWiki:
1.30

DESCRIBE archive;

+-------------------+---------------------+------+-----+----------------+----------------+
| Field             | Type                | Null | Key | Default        | Extra          |
+-------------------+---------------------+------+-----+----------------+----------------+
| ar_id             | int(10) unsigned    | NO   | PRI | NULL           | auto_increment |
| ar_namespace      | int(11)             | NO   | MUL | 0              |                |
| ar_title          | varbinary(255)      | NO   |     |                |                |
| ar_text           | mediumblob          | NO   |     | NULL           |                |
| ar_comment        | varbinary(767)      | NO   |     |                |                |
| ar_comment_id     | bigint(20) unsigned | NO   |     | 0              |                |
| ar_user           | int(10) unsigned    | NO   |     | 0              |                |
| ar_user_text      | varbinary(255)      | NO   | MUL | NULL           |                |
| ar_timestamp      | binary(14)          | NO   |     |                |                |
| ar_minor_edit     | tinyint(4)          | NO   |     | 0              |                |
| ar_flags          | tinyblob            | NO   |     | NULL           |                |
| ar_rev_id         | int(10) unsigned    | YES  | MUL | NULL           |                |
| ar_text_id        | int(10) unsigned    | YES  |     | NULL           |                |
| ar_deleted        | tinyint(3) unsigned | NO   |     | 0              |                |
| ar_len            | int(10) unsigned    | YES  |     | NULL           |                |
| ar_page_id        | int(10) unsigned    | YES  |     | NULL           |                |
| ar_parent_id      | int(10) unsigned    | YES  |     | NULL           |                |
| ar_sha1           | varbinary(32)       | NO   |     |                |                |
| ar_content_model  | varbinary(32)       | YES  |     | NULL           |                |
| ar_content_format | varbinary(64)       | YES  |     | NULL           |                |
+-------------------+---------------------+------+-----+----------------+----------------+
Версии MediaWiki:
1.25 – 1.29

DESCRIBE archive;

+-------------------+---------------------+------+-----+----------------+----------------+
| Field             | Type                | Null | Key | Default        | Extra          |
+-------------------+---------------------+------+-----+----------------+----------------+
| ar_id             | int(10) unsigned    | NO   | PRI | NULL           | auto_increment |
| ar_namespace      | int(11)             | NO   | MUL | 0              |                |
| ar_title          | varbinary(255)      | NO   |     |                |                |
| ar_text           | mediumblob          | NO   |     | NULL           |                |
| ar_comment        | varbinary(767)      | NO   |     | NULL           |                |
| ar_user           | int(10) unsigned    | NO   |     | 0              |                |
| ar_user_text      | varbinary(255)      | NO   | MUL | NULL           |                |
| ar_timestamp      | binary(14)          | NO   |     |                |                |
| ar_minor_edit     | tinyint(4)          | NO   |     | 0              |                |
| ar_flags          | tinyblob            | NO   |     | NULL           |                |
| ar_rev_id         | int(10) unsigned    | YES  | MUL | NULL           |                |
| ar_text_id        | int(10) unsigned    | YES  |     | NULL           |                |
| ar_deleted        | tinyint(3) unsigned | NO   |     | 0              |                |
| ar_len            | int(10) unsigned    | YES  |     | NULL           |                |
| ar_page_id        | int(10) unsigned    | YES  |     | NULL           |                |
| ar_parent_id      | int(10) unsigned    | YES  |     | NULL           |                |
| ar_sha1           | varbinary(32)       | NO   |     |                |                |
| ar_content_model  | varbinary(32)       | YES  |     | NULL           |                |
| ar_content_format | varbinary(64)       | YES  |     | NULL           |                |
+-------------------+---------------------+------+-----+----------------+----------------+
Версии MediaWiki:
1.22 – 1.24

DESCRIBE archive;

+-------------------+---------------------+------+-----+----------------+----------------+
| Field             | Type                | Null | Key | Default        | Extra          |
+-------------------+---------------------+------+-----+----------------+----------------+
| ar_id             | int(10) unsigned    | NO   | PRI | NULL           | auto_increment |
| ar_namespace      | int(11)             | NO   | MUL | 0              |                |
| ar_title          | varbinary(255)      | NO   |     |                |                |
| ar_text           | mediumblob          | NO   |     | NULL           |                |
| ar_comment        | tinyblob            | NO   |     | NULL           |                |
| ar_user           | int(10) unsigned    | NO   |     | 0              |                |
| ar_user_text      | varbinary(255)      | NO   | MUL | NULL           |                |
| ar_timestamp      | binary(14)          | NO   |     |                |                |
| ar_minor_edit     | tinyint(4)          | NO   |     | 0              |                |
| ar_flags          | tinyblob            | NO   |     | NULL           |                |
| ar_rev_id         | int(10) unsigned    | YES  | MUL | NULL           |                |
| ar_text_id        | int(10) unsigned    | YES  |     | NULL           |                |
| ar_deleted        | tinyint(3) unsigned | NO   |     | 0              |                |
| ar_len            | int(10) unsigned    | YES  |     | NULL           |                |
| ar_page_id        | int(10) unsigned    | YES  |     | NULL           |                |
| ar_parent_id      | int(10) unsigned    | YES  |     | NULL           |                |
| ar_sha1           | varbinary(32)       | NO   |     |                |                |
| ar_content_model  | varbinary(32)       | YES  |     | NULL           |                |
| ar_content_format | varbinary(64)       | YES  |     | NULL           |                |
+-------------------+---------------------+------+-----+----------------+----------------+
Версия MediaWiki:
1.21

DESCRIBE archive;

+-------------------+---------------------+------+-----+----------------+-------+
| Field             | Type                | Null | Key | Default        | Extra |
+-------------------+---------------------+------+-----+----------------+-------+
| ar_namespace      | int(11)             | NO   | MUL | 0              |       |
| ar_title          | varbinary(255)      | NO   |     |                |       |
| ar_text           | mediumblob          | NO   |     | NULL           |       |
| ar_comment        | tinyblob            | NO   |     | NULL           |       |
| ar_user           | int(10) unsigned    | NO   |     | 0              |       |
| ar_user_text      | varbinary(255)      | NO   | MUL | NULL           |       |
| ar_timestamp      | binary(14)          | NO   |     |                |       |
| ar_minor_edit     | tinyint(4)          | NO   |     | 0              |       |
| ar_flags          | tinyblob            | NO   |     | NULL           |       |
| ar_rev_id         | int(10) unsigned    | YES  | MUL | NULL           |       |
| ar_text_id        | int(10) unsigned    | YES  |     | NULL           |       |
| ar_deleted        | tinyint(3) unsigned | NO   |     | 0              |       |
| ar_len            | int(10) unsigned    | YES  |     | NULL           |       |
| ar_page_id        | int(10) unsigned    | YES  |     | NULL           |       |
| ar_parent_id      | int(10) unsigned    | YES  |     | NULL           |       |
| ar_sha1           | varbinary(32)       | NO   |     |                |       |
| ar_content_model  | varbinary(32)       | YES  |     | NULL           |       |
| ar_content_format | varbinary(64)       | YES  |     | NULL           |       |
+-------------------+---------------------+------+-----+----------------+-------+
Версии MediaWiki:
1.19 – 1.20

DESCRIBE archive;

+---------------+---------------------+------+-----+----------------+-------+
| Field         | Type                | Null | Key | Default        | Extra |
+---------------+---------------------+------+-----+----------------+-------+
| ar_namespace  | int(11)             | NO   | MUL | 0              |       |
| ar_title      | varbinary(255)      | NO   |     |                |       |
| ar_text       | mediumblob          | NO   |     | NULL           |       |
| ar_comment    | tinyblob            | NO   |     | NULL           |       |
| ar_user       | int(10) unsigned    | NO   |     | 0              |       |
| ar_user_text  | varbinary(255)      | NO   | MUL | NULL           |       |
| ar_timestamp  | binary(14)          | NO   |     |                |       |
| ar_minor_edit | tinyint(4)          | NO   |     | 0              |       |
| ar_flags      | tinyblob            | NO   |     | NULL           |       |
| ar_rev_id     | int(10) unsigned    | YES  | MUL | NULL           |       |
| ar_text_id    | int(10) unsigned    | YES  |     | NULL           |       |
| ar_deleted    | tinyint(3) unsigned | NO   |     | 0              |       |
| ar_len        | int(10) unsigned    | YES  |     | NULL           |       |
| ar_page_id    | int(10) unsigned    | YES  |     | NULL           |       |
| ar_parent_id  | int(10) unsigned    | YES  |     | NULL           |       |
| ar_sha1       | varbinary(32)       | NO   |     |                |       |
+---------------+---------------------+------+-----+----------------+-------+
Версии MediaWiki:
1.17 – 1.18

DESCRIBE archive;

+---------------+---------------------+------+-----+----------------+-------+
| Field         | Type                | Null | Key | Default        | Extra |
+---------------+---------------------+------+-----+----------------+-------+
| ar_namespace  | int(11)             | NO   | MUL | 0              |       |
| ar_title      | varbinary(255)      | NO   |     |                |       |
| ar_text       | mediumblob          | NO   |     | NULL           |       |
| ar_comment    | tinyblob            | NO   |     | NULL           |       |
| ar_user       | int(10) unsigned    | NO   |     | 0              |       |
| ar_user_text  | varbinary(255)      | NO   | MUL | NULL           |       |
| ar_timestamp  | binary(14)          | NO   |     |                |       |
| ar_minor_edit | tinyint(4)          | NO   |     | 0              |       |
| ar_flags      | tinyblob            | NO   |     | NULL           |       |
| ar_rev_id     | int(10) unsigned    | YES  | MUL | NULL           |       |
| ar_text_id    | int(10) unsigned    | YES  |     | NULL           |       |
| ar_deleted    | tinyint(3) unsigned | NO   |     | 0              |       |
| ar_len        | int(10) unsigned    | YES  |     | NULL           |       |
| ar_page_id    | int(10) unsigned    | YES  |     | NULL           |       |
| ar_parent_id  | int(10) unsigned    | YES  |     | NULL           |       |
+---------------+---------------------+------+-----+----------------+-------+
Версии MediaWiki:
1.13 – 1.16

DESCRIBE archive;

+---------------+---------------------+------+-----+----------------+-------+
| Field         | Type                | Null | Key | Default        | Extra |
+---------------+---------------------+------+-----+----------------+-------+
| ar_namespace  | int(11)             | NO   | MUL | 0              |       |
| ar_title      | varbinary(255)      | NO   |     |                |       |
| ar_text       | mediumblob          | NO   |     | NULL           |       |
| ar_comment    | tinyblob            | NO   |     | NULL           |       |
| ar_user       | int(10) unsigned    | NO   |     | 0              |       |
| ar_user_text  | varbinary(255)      | NO   | MUL | NULL           |       |
| ar_timestamp  | binary(14)          | NO   |     |                |       |
| ar_minor_edit | tinyint(4)          | NO   |     | 0              |       |
| ar_flags      | tinyblob            | NO   |     | NULL           |       |
| ar_rev_id     | int(10) unsigned    | YES  |     | NULL           |       |
| ar_text_id    | int(10) unsigned    | YES  |     | NULL           |       |
| ar_deleted    | tinyint(3) unsigned | NO   |     | 0              |       |
| ar_len        | int(10) unsigned    | YES  |     | NULL           |       |
| ar_page_id    | int(10) unsigned    | YES  |     | NULL           |       |
| ar_parent_id  | int(10) unsigned    | YES  |     | NULL           |       |
+---------------+---------------------+------+-----+----------------+-------+
Версия MediaWiki:
1.12

DESCRIBE archive;

+---------------+---------------------+------+-----+---------+-------+
| Field         | Type                | Null | Key | Default | Extra |
+---------------+---------------------+------+-----+---------+-------+
| ar_namespace  | int(11)             | NO   | MUL | 0       |       |
| ar_title      | varbinary(255)      | NO   |     | NULL    |       |
| ar_text       | mediumblob          | NO   |     | NULL    |       |
| ar_comment    | tinyblob            | NO   |     | NULL    |       |
| ar_user       | int(5) unsigned     | NO   |     | 0       |       |
| ar_user_text  | varbinary(255)      | NO   | MUL | NULL    |       |
| ar_timestamp  | binary(14)          | NO   |     | NULL    |       |
| ar_minor_edit | tinyint(1)          | NO   |     | 0       |       |
| ar_flags      | tinyblob            | NO   |     | NULL    |       |
| ar_rev_id     | int(8) unsigned     | YES  |     | NULL    |       |
| ar_text_id    | int(8) unsigned     | YES  |     | NULL    |       |
| ar_deleted    | tinyint(1) unsigned | NO   |     | 0       |       |
| ar_len        | int(8) unsigned     | YES  |     | NULL    |       |
| ar_page_id    | int(10) unsigned    | YES  |     | NULL    |       |
+---------------+---------------------+------+-----+---------+-------+
Версия MediaWiki:
1.11

DESCRIBE archive;

+---------------+---------------------+------+-----+---------+-------+
| Field         | Type                | Null | Key | Default | Extra |
+---------------+---------------------+------+-----+---------+-------+
| ar_namespace  | int(11)             | NO   | MUL | 0       |       |
| ar_title      | varbinary(255)      | NO   |     | NULL    |       |
| ar_text       | mediumblob          | NO   |     | NULL    |       |
| ar_comment    | tinyblob            | NO   |     | NULL    |       |
| ar_user       | int(10) unsigned    | NO   |     | 0       |       |
| ar_user_text  | varbinary(255)      | NO   | MUL | NULL    |       |
| ar_timestamp  | binary(14)          | NO   |     | NULL    |       |
| ar_minor_edit | tinyint(4)          | NO   |     | 0       |       |
| ar_flags      | tinyblob            | NO   |     | NULL    |       |
| ar_rev_id     | int(10) unsigned    | YES  |     | NULL    |       |
| ar_text_id    | int(10) unsigned    | YES  |     | NULL    |       |
| ar_deleted    | tinyint(3) unsigned | NO   |     | 0       |       |
| ar_len        | int(10) unsigned    | YES  |     | NULL    |       |
| ar_page_id    | int(10) unsigned    | YES  |     | NULL    |       |
+---------------+---------------------+------+-----+---------+-------+
Версия MediaWiki:
1.10

DESCRIBE archive;

+---------------+---------------------+------+-----+---------+-------+
| Field         | Type                | Null | Key | Default | Extra |
+---------------+---------------------+------+-----+---------+-------+
| ar_namespace  | int(11)             | NO   | MUL | 0       |       |
| ar_title      | varbinary(255)      | NO   |     | NULL    |       |
| ar_text       | mediumblob          | NO   |     | NULL    |       |
| ar_comment    | tinyblob            | NO   |     | NULL    |       |
| ar_user       | int(5) unsigned     | NO   |     | 0       |       |
| ar_user_text  | varbinary(255)      | NO   |     | NULL    |       |
| ar_timestamp  | binary(14)          | NO   |     | NULL    |       |
| ar_minor_edit | tinyint(1)          | NO   |     | 0       |       |
| ar_flags      | tinyblob            | NO   |     | NULL    |       |
| ar_rev_id     | int(8) unsigned     | YES  |     | NULL    |       |
| ar_text_id    | int(8) unsigned     | YES  |     | NULL    |       |
| ar_deleted    | tinyint(1) unsigned | NO   |     | 0       |       |
| ar_len        | int(8) unsigned     | YES  |     | NULL    |       |
+---------------+---------------------+------+-----+---------+-------+
Версии MediaWiki:
1.5 – 1.9

DESCRIBE archive;

+---------------+---------------------+------+-----+---------+-------+
| Field         | Type                | Null | Key | Default | Extra |
+---------------+---------------------+------+-----+---------+-------+
| ar_namespace  | int(11)             | NO   | MUL | 0       |       |
| ar_title      | varbinary(255)      | NO   |     | NULL    |       |
| ar_text       | mediumblob          | NO   |     | NULL    |       |
| ar_comment    | tinyblob            | NO   |     | NULL    |       |
| ar_user       | int(5) unsigned     | NO   |     | 0       |       |
| ar_user_text  | varbinary(255)      | NO   |     | NULL    |       |
| ar_timestamp  | char(14)            | NO   |     | NULL    |       |
| ar_minor_edit | tinyint(1)          | NO   |     | 0       |       |
| ar_flags      | tinyblob            | NO   |     | NULL    |       |
| ar_rev_id     | int(8) unsigned     | YES  |     | NULL    |       |
| ar_text_id    | int(8) unsigned     | YES  |     | NULL    |       |
+---------------+---------------------+------+-----+---------+-------+
Версия MediaWiki:
1.4

DESCRIBE archive;

+---------------+---------------------+------+-----+---------+-------+
| Field         | Type                | Null | Key | Default | Extra |
+---------------+---------------------+------+-----+---------+-------+
| ar_namespace  | tinyint(2) unsigned |      | MUL | 0       |       |
| ar_title      | varbinary(255)      |      |     |         |       |
| ar_text       | mediumtext          |      |     | NULL    |       |
| ar_comment    | tinyblob            |      |     | NULL    |       |
| ar_user       | int(5) unsigned     |      |     | 0       |       |
| ar_user_text  | varbinary(255)      |      |     | NULL    |       |
| ar_timestamp  | char(14) binary     |      |     |         |       |
| ar_minor_edit | tinyint(1)          |      |     | 0       |       |
| ar_flags      | tinyblob            |      |     | NULL    |       |
+---------------+---------------------+------+-----+---------+-------+

Indexes

Версия MediaWiki:
1.36

SHOW INDEX IN archive;

+---------+------------+-------------------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table   | Non_unique | Key_name                | Seq_in_index | Column_name  | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+---------+------------+-------------------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| archive |          0 | PRIMARY                 |            1 | ar_id        | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| archive |          0 | ar_revid_uniq           |            1 | ar_rev_id    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| archive |          1 | ar_name_title_timestamp |            1 | ar_namespace | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| archive |          1 | ar_name_title_timestamp |            2 | ar_title     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| archive |          1 | ar_name_title_timestamp |            3 | ar_timestamp | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| archive |          1 | ar_actor_timestamp      |            1 | ar_actor     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| archive |          1 | ar_actor_timestamp      |            2 | ar_timestamp | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+---------+------------+-------------------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+