Manual:recentchanges テーブル

From mediawiki.org
This page is a translated version of the page Manual:Recentchanges table and the translation is 7% complete.
Manual:コンテンツ MediaWiki のデータベース レイアウト recentchanges テーブル
MediaWiki バージョン:
1.1

recentchanges テーブルには最も最近に行われたウィキの修正に関する情報が含まれています ($wgRCMaxAge より古い情報は含まれません、下記参照)。 The contents of this table are generated out of the tables page and revision ; they can be regenerated using the maintenance script rebuildrecentchanges.php . The recentchanges table itself is used to generate the recent changes pages, related changes pages, watchlists, and the list of new pages, and contains information such as editors' IP addresses (depending on the wiki's configuration) not found on other tables. The recentchanges table is very similar to the revision table, which is used for page history and user contributions listings. Differences include:

  • The recentchanges table also references the previous revision of the page
  • The recentchanges table also records logged events such as page moves and deletions
  • Items in the recentchanges table are periodically purged; those in the revision table are typically kept longer or indefinitely.
  • As said, an import of a page revision not only adds an entry to the revision table with the import date, but also one with the original date.

When pages are moved, their RC entries (specifically, rc_namespace and rc_title ) do not change.

フィールド

rc_id

MediaWiki バージョン:
1.5

This is the primary key for the table. (1.5 で導入)

rc_timestamp

Holds the timestamp of the change. Corresponds to rev_timestamp (and log_timestamp , in the case of log actions).

rc_cur_time

MediaWiki バージョン:
1.23

Had been deprecated, but was first held for backwards compatibility. (1.24wmf6 で除去)

rc_user

This is equal to the user_id of the user who made this change. The value for this field is 0 for anonymous edits, initialization scripts, and for some mass imports. Corresponds to rev_user (and log_user , in the case of log actions).

If you use rc_user = 0 to select anonymous edits, remember to set at least rc_type < 5 as well! On wikis using ウィキベース the results will otherwise be meaningless. On other wikis, bots or imports may be more relevant than you expect.

(1.31 で廃止予定); Deprecated in favor of rc_actor.

rc_user_text

This field holds the text of the username for the user that made the change, or the IP address if the change was made by an unregistered user. Corresponds to rev_user_text (and log_user_text , in the case of log actions).

(1.31 で廃止予定); Deprecated in favor of rc_actor.

rc_actor

MediaWiki バージョン:
1.31
Gerrit change 380669

This is a foreign key to actor_id in the actor table. Corresponds to revactor_actor (or log_actor in the case of log actions).

rc_namespace

The namespace number of the page that was subject to change. Corresponds to log_namespace , in the case of log actions.

If this row describes a logged action, this field has a value of -1 (NS_SPECIAL), as it records an entry for a Special:Log subpage.

rc_title

The name of the page that was subject to change, with the namespace stripped. This field stores information in text form. Corresponds to log_title, in the case of log actions.

rc_comment

MediaWiki バージョン:
1.32

This field holds a summary of the change (editor's comment on revision). This text is shown in the recent changes, related changes, watchlists, and, in the case of page creation, the list of new pages. (The revision table contains a copy (rev_comment) used for the history and user contributions pages. In the case of log actions, a copy is also in log_comment.) It is rendered in a subset of wiki markup.

(1.30 で廃止予定); rc_comment_id and the comment table should be used instead!

rc_comment_id

MediaWiki バージョン:
1.30

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

rc_minor

Records whether the user marked the change as 'minor'. If the value for this field is 1, then the change was declared as 'minor'; it is 0 otherwise. Many automated changes are marked as minor. Corresponds to rev_minor_edit.

rc_bot

Records whether the change was made by a 'bot account'. If the value for this field is 1, then the change was made by a 'bot' (i.e. a user with the 'bot' permission); it is 0 otherwise. It is possible for bots to avoid setting this flag on their change by including the parameter "bot=0" in the form submission. Also, users with the 'rollback' and 'markbotedits' permissions may retroactively mark their rollbacks and the edits being rolled back as bot edits by including the parameter "bot=1" in the rollback link.

rc_new

If the value for this field is 1, then this edit created a page; it is 0 otherwise.

rc_cur_id

This field links to the page_id key in the page table, which stores the metadata of the page. Corresponds to log_page, in the case of log actions.

rc_this_oldid

Links to the rev_id key of the new page revision (after the edit occurs) in the revision table.

rc_last_oldid

Links to rev_parent_id, i.e. the rev_id of the revision prior to this edit, which included the previous content of the page.

rc_type

MediaWiki バージョン:
1.2

This field stores the type of modification that was made to a page:

  • 0 (RC_EDIT) – edit of existing page
  • 1 (RC_NEW) – new page
  • 2 (RC_MOVE) – move (obsolete)
  • 3 (RC_LOG) – log action (added in MediaWiki 1.2)
  • 4 (RC_MOVE_OVER_REDIRECT) – move over redirect (obsolete)
  • 5 (RC_EXTERNAL) – An external recent change. Primarily used by Wikidata
  • 6 (RC_CATEGORIZE) – category membership change, see Manual:CategoryMembershipChanges (added in MediaWiki 1.27, Gerrit change 239060)

Extensions might use other types, e.g. StructuredDiscussions uses 142.

rc_source

MediaWiki バージョン:
1.23

The source of the change entry (replaces rc_type).

Allows specifying the type of change and for more flexibly specifying different types of RecentChange entries. For example, 'mw.edit', 'mw.log', 'mw.new' for core RecentChange types and 'wb' and 'flow' provided by extensions.

rc_moved_to_ns

MediaWiki バージョン:
1.2 – 1.20

This field stored the namespace of a page whenever it was moved. As of MediaWiki 1.8, it remained in the table for backwards compatibility only, and always has the value 0. It was removed entirely in MediaWiki 1.21.

rc_moved_to_title

MediaWiki バージョン:
1.2 – 1.20

This field stored the new page title of a page whenever it was moved. As of MediaWiki 1.8, it remained in the table for backwards compatibility only, and is always a null string. It was removed entirely in MediaWiki 1.21.

rc_patrolled

MediaWiki バージョン:
1.4

If the Recent Changes Patrol option ($wgUseRCPatrol ) is enabled, users may mark changes as having been reviewed to remove a warning flag on the RC list. A value of 0 indicates the change is unpatrolled, 1 indicates the change has been reviewed. (1.4 で導入)

MediaWiki バージョン:
1.31

rc_patrolled now has three states: "0" for unpatrolled, "1" for manually patrolled, and "2" for autopatrolled actions.

rc_ip

MediaWiki バージョン:
1.3

This field stores the IP address of the user specified on rc_user if $wgPutIPinRC is enabled. If $wgPutIPinRC is false, then the field will contain an empty string.

In some old MediaWiki versions this field was used to generate CheckUser reports, but it is now considered obsolete as CheckUser stores data in a separate cu_changes table. When the extension is set up, data from this field may be copied over a single time.

自動ブロック use it to automatically block the more recent IP used by a user who is blocked.

rc_old_len

MediaWiki バージョン:
1.9

This field stores the size, in bytes, of previous revision's text. This field is used to generate the added and removed characters feature in recent changes, related changes and watchlists.

rc_new_len

MediaWiki バージョン:
1.9

This field stores the size, in bytes, of the current revision's text. This field is used to generate the added and removed characters feature in recent changes, related changes and watchlists. Corresponds to rev_len .

rc_deleted

MediaWiki バージョン:
1.10

This field stores a value for this particular revision's visibility within the wiki. It was created to accommodate upcoming revisions to the deletion system. The field is analogous to rev_deleted or log_deleted .

rc_logid

MediaWiki バージョン:
1.10

This field is a foreign key to the logging table, which links to log_id if this row corresponds to a log entry. (1.10 で導入)

rc_log_type

MediaWiki バージョン:
1.10

If a log action is referenced in this row, this field stores the type of log action that was performed, and which is referenced in this row. Typical values are block, delete, import, makebot, move, newusers, protect, renameuser, rights, upload. This field is comparable to log_type .

rc_log_action

MediaWiki バージョン:
1.10

If a log action is referenced in this row, this field stores the type of log action that was performed, and which is referenced in this row. This field is comparable to log_action .

rc_params

MediaWiki バージョン:
1.10

This field will be a mirror of log_params , following the log_params text rewrite. (1.10 で導入)

スキーマの要約

MediaWiki バージョン:
1.36

DESCRIBE recentchanges;

+---------------+---------------------+------+-----+---------+----------------+
| Field         | Type                | Null | Key | Default | Extra          |
+---------------+---------------------+------+-----+---------+----------------+
| rc_id         | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| rc_timestamp  | binary(14)          | NO   | MUL | NULL    |                |
| rc_actor      | bigint(20) unsigned | NO   | MUL | NULL    |                |
| rc_namespace  | int(11)             | NO   | MUL | 0       |                |
| rc_title      | varbinary(255)      | NO   |     |         |                |
| rc_comment_id | bigint(20) unsigned | NO   |     | NULL    |                |
| rc_minor      | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_bot        | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_new        | tinyint(3) unsigned | NO   | MUL | 0       |                |
| rc_cur_id     | int(10) unsigned    | NO   | MUL | 0       |                |
| rc_this_oldid | int(10) unsigned    | NO   | MUL | 0       |                |
| rc_last_oldid | int(10) unsigned    | NO   |     | 0       |                |
| rc_type       | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_source     | varbinary(16)       | NO   |     |         |                |
| rc_patrolled  | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_ip         | varbinary(40)       | NO   | MUL |         |                |
| rc_old_len    | int(11)             | YES  |     | NULL    |                |
| rc_new_len    | int(11)             | YES  |     | NULL    |                |
| rc_deleted    | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_logid      | int(10) unsigned    | NO   |     | 0       |                |
| rc_log_type   | varbinary(255)      | YES  |     | NULL    |                |
| rc_log_action | varbinary(255)      | YES  |     | NULL    |                |
| rc_params     | blob                | YES  |     | NULL    |                |
+---------------+---------------------+------+-----+---------+----------------+
MediaWiki バージョン:
1.34 – 1.35

DESCRIBE recentchanges;

+---------------+---------------------+------+-----+---------+----------------+
| Field         | Type                | Null | Key | Default | Extra          |
+---------------+---------------------+------+-----+---------+----------------+
| rc_id         | int(11)             | NO   | PRI | NULL    | auto_increment |
| rc_timestamp  | varbinary(14)       | NO   | MUL |         |                |
| rc_actor      | bigint(20) unsigned | NO   | MUL | NULL    |                |
| rc_namespace  | int(11)             | NO   | MUL | 0       |                |
| rc_title      | varbinary(255)      | NO   |     |         |                |
| rc_comment_id | bigint(20) unsigned | NO   |     | NULL    |                |
| rc_minor      | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_bot        | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_new        | tinyint(3) unsigned | NO   | MUL | 0       |                |
| rc_cur_id     | int(10) unsigned    | NO   | MUL | 0       |                |
| rc_this_oldid | int(10) unsigned    | NO   | MUL | 0       |                |
| rc_last_oldid | int(10) unsigned    | NO   |     | 0       |                |
| rc_type       | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_source     | varbinary(16)       | NO   |     |         |                |
| rc_patrolled  | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_ip         | varbinary(40)       | NO   | MUL |         |                |
| rc_old_len    | int(11)             | YES  |     | NULL    |                |
| rc_new_len    | int(11)             | YES  |     | NULL    |                |
| rc_deleted    | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_logid      | int(10) unsigned    | NO   |     | 0       |                |
| rc_log_type   | varbinary(255)      | YES  |     | NULL    |                |
| rc_log_action | varbinary(255)      | YES  |     | NULL    |                |
| rc_params     | blob                | YES  |     | NULL    |                |
+---------------+---------------------+------+-----+---------+----------------+
MediaWiki バージョン:
1.33

DESCRIBE recentchanges;

+---------------+---------------------+------+-----+---------+----------------+
| Field         | Type                | Null | Key | Default | Extra          |
+---------------+---------------------+------+-----+---------+----------------+
| rc_id         | int(11)             | NO   | PRI | NULL    | auto_increment |
| rc_timestamp  | varbinary(14)       | NO   | MUL |         |                |
| rc_user       | int(10) unsigned    | NO   |     | 0       |                |
| rc_user_text  | varbinary(255)      | NO   | MUL |         |                |
| rc_actor      | bigint(20) unsigned | NO   | MUL | 0       |                |
| rc_namespace  | int(11)             | NO   | MUL | 0       |                |
| rc_title      | varbinary(255)      | NO   |     |         |                |
| rc_comment_id | bigint(20) unsigned | NO   |     | NULL    |                |
| rc_minor      | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_bot        | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_new        | tinyint(3) unsigned | NO   | MUL | 0       |                |
| rc_cur_id     | int(10) unsigned    | NO   | MUL | 0       |                |
| rc_this_oldid | int(10) unsigned    | NO   | MUL | 0       |                |
| rc_last_oldid | int(10) unsigned    | NO   |     | 0       |                |
| rc_type       | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_source     | varbinary(16)       | NO   |     |         |                |
| rc_patrolled  | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_ip         | varbinary(40)       | NO   | MUL |         |                |
| rc_old_len    | int(11)             | YES  |     | NULL    |                |
| rc_new_len    | int(11)             | YES  |     | NULL    |                |
| rc_deleted    | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_logid      | int(10) unsigned    | NO   |     | 0       |                |
| rc_log_type   | varbinary(255)      | YES  |     | NULL    |                |
| rc_log_action | varbinary(255)      | YES  |     | NULL    |                |
| rc_params     | blob                | YES  |     | NULL    |                |
+---------------+---------------------+------+-----+---------+----------------+
MediaWiki バージョン:
1.32

DESCRIBE recentchanges;

+---------------+---------------------+------+-----+---------+----------------+
| Field         | Type                | Null | Key | Default | Extra          |
+---------------+---------------------+------+-----+---------+----------------+
| rc_id         | int(11)             | NO   | PRI | NULL    | auto_increment |
| rc_timestamp  | varbinary(14)       | NO   | MUL |         |                |
| rc_user       | int(10) unsigned    | NO   |     | 0       |                |
| rc_user_text  | varbinary(255)      | NO   | MUL |         |                |
| rc_actor      | bigint(20) unsigned | NO   | MUL | 0       |                |
| rc_namespace  | int(11)             | NO   | MUL | 0       |                |
| rc_title      | varbinary(255)      | NO   |     |         |                |
| rc_comment    | varbinary(767)      | NO   |     |         |                |
| rc_comment_id | bigint(20) unsigned | NO   |     | 0       |                |
| rc_minor      | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_bot        | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_new        | tinyint(3) unsigned | NO   | MUL | 0       |                |
| rc_cur_id     | int(10) unsigned    | NO   | MUL | 0       |                |
| rc_this_oldid | int(10) unsigned    | NO   | MUL | 0       |                |
| rc_last_oldid | int(10) unsigned    | NO   |     | 0       |                |
| rc_type       | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_source     | varbinary(16)       | NO   |     |         |                |
| rc_patrolled  | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_ip         | varbinary(40)       | NO   | MUL |         |                |
| rc_old_len    | int(11)             | YES  |     | NULL    |                |
| rc_new_len    | int(11)             | YES  |     | NULL    |                |
| rc_deleted    | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_logid      | int(10) unsigned    | NO   |     | 0       |                |
| rc_log_type   | varbinary(255)      | YES  |     | NULL    |                |
| rc_log_action | varbinary(255)      | YES  |     | NULL    |                |
| rc_params     | blob                | YES  |     | NULL    |                |
+---------------+---------------------+------+-----+---------+----------------+
MediaWiki バージョン:
1.31

DESCRIBE recentchanges;

+---------------+---------------------+------+-----+---------+----------------+
| Field         | Type                | Null | Key | Default | Extra          |
+---------------+---------------------+------+-----+---------+----------------+
| rc_id         | int(11)             | NO   | PRI | NULL    | auto_increment |
| rc_timestamp  | varbinary(14)       | NO   | MUL |         |                |
| rc_user       | int(10) unsigned    | NO   |     | 0       |                |
| rc_user_text  | varbinary(255)      | NO   | MUL |         |                |
| rc_actor      | bigint(20) unsigned | NO   | MUL | 0       |                |
| rc_namespace  | int(11)             | NO   | MUL | 0       |                |
| rc_title      | varbinary(255)      | NO   |     |         |                |
| rc_comment    | varbinary(767)      | NO   |     |         |                |
| rc_comment_id | bigint(20) unsigned | NO   |     | 0       |                |
| rc_minor      | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_bot        | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_new        | tinyint(3) unsigned | NO   | MUL | 0       |                |
| rc_cur_id     | int(10) unsigned    | NO   | MUL | 0       |                |
| rc_this_oldid | int(10) unsigned    | NO   |     | 0       |                |
| rc_last_oldid | int(10) unsigned    | NO   |     | 0       |                |
| rc_type       | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_source     | varbinary(16)       | NO   |     |         |                |
| rc_patrolled  | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_ip         | varbinary(40)       | NO   | MUL |         |                |
| rc_old_len    | int(11)             | YES  |     | NULL    |                |
| rc_new_len    | int(11)             | YES  |     | NULL    |                |
| rc_deleted    | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_logid      | int(10) unsigned    | NO   |     | 0       |                |
| rc_log_type   | varbinary(255)      | YES  |     | NULL    |                |
| rc_log_action | varbinary(255)      | YES  |     | NULL    |                |
| rc_params     | blob                | YES  |     | NULL    |                |
+---------------+---------------------+------+-----+---------+----------------+
MediaWiki バージョン:
1.30

DESCRIBE recentchanges;

+---------------+---------------------+------+-----+---------+----------------+
| Field         | Type                | Null | Key | Default | Extra          |
+---------------+---------------------+------+-----+---------+----------------+
| rc_id         | int(11)             | NO   | PRI | NULL    | auto_increment |
| rc_timestamp  | varbinary(14)       | NO   | MUL |         |                |
| rc_user       | int(10) unsigned    | NO   |     | 0       |                |
| rc_user_text  | varbinary(255)      | NO   | MUL | NULL    |                |
| rc_namespace  | int(11)             | NO   | MUL | 0       |                |
| rc_title      | varbinary(255)      | NO   |     |         |                |
| rc_comment    | varbinary(767)      | NO   |     |         |                |
| rc_comment_id | bigint(20) unsigned | NO   |     | 0       |                |
| rc_minor      | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_bot        | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_new        | tinyint(3) unsigned | NO   | MUL | 0       |                |
| rc_cur_id     | int(10) unsigned    | NO   | MUL | 0       |                |
| rc_this_oldid | int(10) unsigned    | NO   |     | 0       |                |
| rc_last_oldid | int(10) unsigned    | NO   |     | 0       |                |
| rc_type       | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_source     | varbinary(16)       | NO   |     |         |                |
| rc_patrolled  | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_ip         | varbinary(40)       | NO   | MUL |         |                |
| rc_old_len    | int(11)             | YES  |     | NULL    |                |
| rc_new_len    | int(11)             | YES  |     | NULL    |                |
| rc_deleted    | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_logid      | int(10) unsigned    | NO   |     | 0       |                |
| rc_log_type   | varbinary(255)      | YES  |     | NULL    |                |
| rc_log_action | varbinary(255)      | YES  |     | NULL    |                |
| rc_params     | blob                | YES  |     | NULL    |                |
+---------------+---------------------+------+-----+---------+----------------+
MediaWiki バージョン:
1.25 – 1.29

DESCRIBE recentchanges;

+---------------+---------------------+------+-----+---------+----------------+
| Field         | Type                | Null | Key | Default | Extra          |
+---------------+---------------------+------+-----+---------+----------------+
| rc_id         | int(11)             | NO   | PRI | NULL    | auto_increment |
| rc_timestamp  | varbinary(14)       | NO   | MUL |         |                |
| rc_user       | int(10) unsigned    | NO   |     | 0       |                |
| rc_user_text  | varbinary(255)      | NO   | MUL | NULL    |                |
| rc_namespace  | int(11)             | NO   | MUL | 0       |                |
| rc_title      | varbinary(255)      | NO   |     |         |                |
| rc_comment    | varbinary(767)      | NO   |     |         |                |
| rc_minor      | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_bot        | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_new        | tinyint(3) unsigned | NO   | MUL | 0       |                |
| rc_cur_id     | int(10) unsigned    | NO   | MUL | 0       |                |
| rc_this_oldid | int(10) unsigned    | NO   |     | 0       |                |
| rc_last_oldid | int(10) unsigned    | NO   |     | 0       |                |
| rc_type       | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_source     | varbinary(16)       | NO   |     |         |                |
| rc_patrolled  | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_ip         | varbinary(40)       | NO   | MUL |         |                |
| rc_old_len    | int(11)             | YES  |     | NULL    |                |
| rc_new_len    | int(11)             | YES  |     | NULL    |                |
| rc_deleted    | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_logid      | int(10) unsigned    | NO   |     | 0       |                |
| rc_log_type   | varbinary(255)      | YES  |     | NULL    |                |
| rc_log_action | varbinary(255)      | YES  |     | NULL    |                |
| rc_params     | blob                | YES  |     | NULL    |                |
+---------------+---------------------+------+-----+---------+----------------+
MediaWiki バージョン:
1.24

DESCRIBE recentchanges;

+-------------------+---------------------+------+-----+---------+----------------+
| Field             | Type                | Null | Key | Default | Extra          |
+-------------------+---------------------+------+-----+---------+----------------+
| rc_id             | int(8)              | NO   | PRI | NULL    | AUTO_INCREMENT |
| rc_timestamp      | varbinary(14)       | NO   | MUL | NULL    |                |
| rc_user           | int(10) unsigned    | NO   |     | 0       |                |
| rc_user_text      | varchar(255) binary | NO   |     | NULL    |                |
| rc_namespace      | int(11)             | NO   | MUL | 0       |                |
| rc_title          | varchar(255) binary | NO   |     | NULL    |                |
| rc_comment        | varchar(255) binary | NO   |     | NULL    |                |
| rc_minor          | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_bot            | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_new            | tinyint(3) unsigned | NO   | MUL | 0       |                |
| rc_cur_id         | int(10) unsigned    | NO   | MUL | 0       |                |
| rc_this_oldid     | int(10) unsigned    | NO   |     | 0       |                |
| rc_last_oldid     | int(10) unsigned    | NO   |     | 0       |                |
| rc_type           | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_source         | varchar(16) binary  | NO   |     | NULL    |                |
| rc_patrolled      | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_ip             | varbinary(40)       | NO   | MUL | NULL    |                |
| rc_old_len        | int(10)             | YES  |     | NULL    |                |
| rc_new_len        | int(10)             | YES  |     | NULL    |                |
| rc_deleted        | tinyint(3) unsigned | NO   |     | NULL    |                |
| rc_logid          | int(10) unsigned    | NO   |     | NULL    |                |
| rc_log_type       | varbinary(255)      | YES  |     | NULL    |                |
| rc_log_action     | varbinary(255)      | YES  |     | NULL    |                |
| rc_params         | blob                | YES  |     | NULL    |                |
+-------------------+---------------------+------+-----+---------+----------------+
MediaWiki バージョン:
1.23

DESCRIBE recentchanges;

+-------------------+---------------------+------+-----+---------+----------------+
| Field             | Type                | Null | Key | Default | Extra          |
+-------------------+---------------------+------+-----+---------+----------------+
| rc_id             | int(8)              | NO   | PRI | NULL    | AUTO_INCREMENT |
| rc_timestamp      | varbinary(14)       | NO   | MUL | NULL    |                |
| rc_cur_time       | varbinary(14)       | NO   |     | NULL    |                |
| rc_user           | int(10) unsigned    | NO   |     | 0       |                |
| rc_user_text      | varchar(255) binary | NO   |     | NULL    |                |
| rc_namespace      | int(11)             | NO   | MUL | 0       |                |
| rc_title          | varchar(255) binary | NO   |     | NULL    |                |
| rc_comment        | varchar(255) binary | NO   |     | NULL    |                |
| rc_minor          | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_bot            | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_new            | tinyint(3) unsigned | NO   | MUL | 0       |                |
| rc_cur_id         | int(10) unsigned    | NO   | MUL | 0       |                |
| rc_this_oldid     | int(10) unsigned    | NO   |     | 0       |                |
| rc_last_oldid     | int(10) unsigned    | NO   |     | 0       |                |
| rc_type           | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_source         | varchar(16) binary  | NO   |     | NULL    |                |
| rc_patrolled      | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_ip             | varbinary(40)       | NO   | MUL | NULL    |                |
| rc_old_len        | int(10)             | YES  |     | NULL    |                |
| rc_new_len        | int(10)             | YES  |     | NULL    |                |
| rc_deleted        | tinyint(3) unsigned | NO   |     | NULL    |                |
| rc_logid          | int(10) unsigned    | NO   |     | NULL    |                |
| rc_log_type       | varbinary(255)      | YES  |     | NULL    |                |
| rc_log_action     | varbinary(255)      | YES  |     | NULL    |                |
| rc_params         | blob                | YES  |     | NULL    |                |
+-------------------+---------------------+------+-----+---------+----------------+
MediaWiki バージョン:
1.21 – 1.22

DESCRIBE recentchanges;

+-------------------+---------------------+------+-----+---------+----------------+
| Field             | Type                | Null | Key | Default | Extra          |
+-------------------+---------------------+------+-----+---------+----------------+
| rc_id             | int(8)              | NO   | PRI | NULL    | AUTO_INCREMENT |
| rc_timestamp      | varbinary(14)       | NO   | MUL | NULL    |                |
| rc_cur_time       | varbinary(14)       | NO   |     | NULL    |                |
| rc_user           | int(10) unsigned    | NO   |     | 0       |                |
| rc_user_text      | varchar(255) binary | NO   |     | NULL    |                |
| rc_namespace      | int(11)             | NO   | MUL | 0       |                |
| rc_title          | varchar(255) binary | NO   |     | NULL    |                |
| rc_comment        | varchar(255) binary | NO   |     | NULL    |                |
| rc_minor          | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_bot            | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_new            | tinyint(3) unsigned | NO   | MUL | 0       |                |
| rc_cur_id         | int(10) unsigned    | NO   | MUL | 0       |                |
| rc_this_oldid     | int(10) unsigned    | NO   |     | 0       |                |
| rc_last_oldid     | int(10) unsigned    | NO   |     | 0       |                |
| rc_type           | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_patrolled      | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_ip             | varbinary(40)       | NO   | MUL | NULL    |                |
| rc_old_len        | int(10)             | YES  |     | NULL    |                |
| rc_new_len        | int(10)             | YES  |     | NULL    |                |
| rc_deleted        | tinyint(3) unsigned | NO   |     | NULL    |                |
| rc_logid          | int(10) unsigned    | NO   |     | NULL    |                |
| rc_log_type       | varbinary(255)      | YES  |     | NULL    |                |
| rc_log_action     | varbinary(255)      | YES  |     | NULL    |                |
| rc_params         | blob                | YES  |     | NULL    |                |
+-------------------+---------------------+------+-----+---------+----------------+
MediaWiki バージョン:
1.11 – 1.20

DESCRIBE recentchanges;

+-------------------+---------------------+------+-----+---------+----------------+
| Field             | Type                | Null | Key | Default | Extra          |
+-------------------+---------------------+------+-----+---------+----------------+
| rc_id             | int(8)              | NO   | PRI | NULL    | AUTO_INCREMENT |
| rc_timestamp      | varbinary(14)       | NO   | MUL | NULL    |                |
| rc_cur_time       | varbinary(14)       | NO   |     | NULL    |                |
| rc_user           | int(10) unsigned    | NO   |     | 0       |                |
| rc_user_text      | varchar(255) binary | NO   |     | NULL    |                |
| rc_namespace      | int(11)             | NO   | MUL | 0       |                |
| rc_title          | varchar(255) binary | NO   |     | NULL    |                |
| rc_comment        | varchar(255) binary | NO   |     | NULL    |                |
| rc_minor          | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_bot            | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_new            | tinyint(3) unsigned | NO   | MUL | 0       |                |
| rc_cur_id         | int(10) unsigned    | NO   | MUL | 0       |                |
| rc_this_oldid     | int(10) unsigned    | NO   |     | 0       |                |
| rc_last_oldid     | int(10) unsigned    | NO   |     | 0       |                |
| rc_type           | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_moved_to_ns    | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_moved_to_title | varchar(255) binary | NO   |     | NULL    |                |
| rc_patrolled      | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_ip             | varbinary(40)       | NO   | MUL | NULL    |                |
| rc_old_len        | int(10)             | YES  |     | NULL    |                |
| rc_new_len        | int(10)             | YES  |     | NULL    |                |
| rc_deleted        | tinyint(3) unsigned | NO   |     | NULL    |                |
| rc_logid          | int(10) unsigned    | NO   |     | NULL    |                |
| rc_log_type       | varbinary(255)      | YES  |     | NULL    |                |
| rc_log_action     | varbinary(255)      | YES  |     | NULL    |                |
| rc_params         | blob                | YES  |     | NULL    |                |
+-------------------+---------------------+------+-----+---------+----------------+
MediaWiki バージョン:
1.10

DESCRIBE recentchanges;

+-------------------+---------------------+------+-----+---------+----------------+
| Field             | Type                | Null | Key | Default | Extra          |
+-------------------+---------------------+------+-----+---------+----------------+
| rc_id             | int(8)              | NO   | PRI | NULL    | AUTO_INCREMENT |
| rc_timestamp      | varbinary(14)       | NO   | MUL | NULL    |                |
| rc_cur_time       | varbinary(14)       | NO   |     | NULL    |                |
| rc_user           | int(10) unsigned    | NO   |     | 0       |                |
| rc_user_text      | varchar(255) binary | NO   |     | NULL    |                |
| rc_namespace      | int(11)             | NO   | MUL | 0       |                |
| rc_title          | varchar(255) binary | NO   |     | NULL    |                |
| rc_comment        | varchar(255) binary | NO   |     | NULL    |                |
| rc_minor          | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_bot            | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_new            | tinyint(3) unsigned | NO   | MUL | 0       |                |
| rc_cur_id         | int(10) unsigned    | NO   | MUL | 0       |                |
| rc_this_oldid     | int(10) unsigned    | NO   |     | 0       |                |
| rc_last_oldid     | int(10) unsigned    | NO   |     | 0       |                |
| rc_type           | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_moved_to_ns    | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_moved_to_title | varchar(255) binary | NO   |     | NULL    |                |
| rc_patrolled      | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_ip             | varbinary(40)       | NO   | MUL | NULL    |                |
| rc_old_len        | int(10)             | YES  |     | NULL    |                |
| rc_new_len        | int(10)             | YES  |     | NULL    |                |
| rc_deleted        | tinyint(3) unsigned | NO   |     | NULL    |                |
| rc_logid          | int(10) unsigned    | NO   |     | NULL    |                |
| rc_log_type       | varbinary(255)      | YES  |     | NULL    |                |
| rc_log_action     | varbinary(255)      | YES  |     | NULL    |                |
| rc_params         | blob                | NO   |     | NULL    |                |
+-------------------+---------------------+------+-----+---------+----------------+
MediaWiki バージョン:
1.9

DESCRIBE recentchanges;

+-------------------+---------------------+------+-----+---------+----------------+
| Field             | Type                | Null | Key | Default | Extra          |
+-------------------+---------------------+------+-----+---------+----------------+
| rc_id             | int(8)              | NO   | PRI | NULL    | AUTO_INCREMENT |
| rc_timestamp      | varchar(14) binary  | NO   | MUL | NULL    |                |
| rc_cur_time       | varchar(14) binary  | NO   |     | NULL    |                |
| rc_user           | int(10) unsigned    | NO   |     | 0       |                |
| rc_user_text      | varchar(255) binary | NO   |     | NULL    |                |
| rc_namespace      | int(11)             | NO   | MUL | 0       |                |
| rc_title          | varchar(255) binary | NO   |     | NULL    |                |
| rc_comment        | varchar(255) binary | NO   |     | NULL    |                |
| rc_minor          | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_bot            | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_new            | tinyint(3) unsigned | NO   | MUL | 0       |                |
| rc_cur_id         | int(10) unsigned    | NO   | MUL | 0       |                |
| rc_this_oldid     | int(10) unsigned    | NO   |     | 0       |                |
| rc_last_oldid     | int(10) unsigned    | NO   |     | 0       |                |
| rc_type           | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_moved_to_ns    | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_moved_to_title | varchar(255) binary | NO   |     | NULL    |                |
| rc_patrolled      | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_ip             | char(15)            | NO   | MUL | NULL    |                |
| rc_old_len        | int(10)             | YES  |     | NULL    |                |
| rc_new_len        | int(10)             | YES  |     | NULL    |                |
+-------------------+---------------------+------+-----+---------+----------------+
MediaWiki バージョン:
1.5 – 1.8

DESCRIBE recentchanges;

+-------------------+---------------------+------+-----+---------+----------------+
| Field             | Type                | Null | Key | Default | Extra          |
+-------------------+---------------------+------+-----+---------+----------------+
| rc_id             | int(8)              | NO   | PRI | NULL    | AUTO_INCREMENT |
| rc_timestamp      | varchar(14) binary  | NO   | MUL | NULL    |                |
| rc_cur_time       | varchar(14) binary  | NO   |     | NULL    |                |
| rc_user           | int(10) unsigned    | NO   |     | 0       |                |
| rc_user_text      | varchar(255) binary | NO   |     | NULL    |                |
| rc_namespace      | int(11)             | NO   | MUL | 0       |                |
| rc_title          | varchar(255) binary | NO   |     | NULL    |                |
| rc_comment        | varchar(255) binary | NO   |     | NULL    |                |
| rc_minor          | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_bot            | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_new            | tinyint(3) unsigned | NO   | MUL | 0       |                |
| rc_cur_id         | int(10) unsigned    | NO   | MUL | 0       |                |
| rc_this_oldid     | int(10) unsigned    | NO   |     | 0       |                |
| rc_last_oldid     | int(10) unsigned    | NO   |     | 0       |                |
| rc_type           | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_moved_to_ns    | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_moved_to_title | varchar(255) binary | NO   |     | NULL    |                |
| rc_patrolled      | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_ip             | char(15)            | NO   | MUL | NULL    |                |
+-------------------+---------------------+------+-----+---------+----------------+
MediaWiki バージョン:
1.4

DESCRIBE recentchanges;

+-------------------+---------------------+------+-----+---------+----------------+
| Field             | Type                | Null | Key | Default | Extra          |
+-------------------+---------------------+------+-----+---------+----------------+
| rc_id             | int(8)              | NO   | PRI | NULL    | AUTO_INCREMENT |
| rc_timestamp      | varchar(14) binary  | NO   | MUL | NULL    |                |
| rc_cur_time       | varchar(14) binary  | NO   |     | NULL    |                |
| rc_user           | int(10) unsigned    | NO   |     | 0       |                |
| rc_user_text      | varchar(255) binary | NO   |     | NULL    |                |
| rc_namespace      | tinyint(3) unsigned | NO   | MUL | 0       |                |
| rc_title          | varchar(255) binary | NO   |     | NULL    |                |
| rc_comment        | varchar(255) binary | NO   |     | NULL    |                |
| rc_minor          | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_bot            | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_new            | tinyint(3) unsigned | NO   | MUL | 0       |                |
| rc_cur_id         | int(10) unsigned    | NO   | MUL | 0       |                |
| rc_this_oldid     | int(10) unsigned    | NO   |     | 0       |                |
| rc_last_oldid     | int(10) unsigned    | NO   |     | 0       |                |
| rc_type           | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_moved_to_ns    | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_moved_to_title | varchar(255) binary | NO   |     | NULL    |                |
| rc_ip             | char(15)            | NO   | MUL | NULL    |                |
+-------------------+---------------------+------+-----+---------+----------------+
MediaWiki バージョン:
1.3

DESCRIBE recentchanges;

+-------------------+---------------------+------+-----+---------+-------+
| Field             | Type                | Null | Key | Default | Extra |
+-------------------+---------------------+------+-----+---------+-------+
| rc_timestamp      | varchar(14) binary  | NO   | MUL | NULL    |       |
| rc_cur_time       | varchar(14) binary  | NO   |     | NULL    |       |
| rc_user           | int(10) unsigned    | NO   |     | 0       |       |
| rc_user_text      | varchar(255) binary | NO   |     | NULL    |       |
| rc_namespace      | tinyint(3) unsigned | NO   | MUL | 0       |       |
| rc_title          | varchar(255) binary | NO   |     | NULL    |       |
| rc_comment        | varchar(255) binary | NO   |     | NULL    |       |
| rc_minor          | tinyint(3) unsigned | NO   |     | 0       |       |
| rc_bot            | tinyint(3) unsigned | NO   |     | 0       |       |
| rc_new            | tinyint(3) unsigned | NO   | MUL | 0       |       |
| rc_cur_id         | int(10) unsigned    | NO   | MUL | 0       |       |
| rc_this_oldid     | int(10) unsigned    | NO   |     | 0       |       |
| rc_last_oldid     | int(10) unsigned    | NO   |     | 0       |       |
| rc_type           | tinyint(3) unsigned | NO   |     | 0       |       |
| rc_moved_to_ns    | tinyint(3) unsigned | NO   |     | 0       |       |
| rc_moved_to_title | varchar(255) binary | NO   |     | NULL    |       |
| rc_ip             | char(15)            | NO   | MUL | NULL    |       |
+-------------------+---------------------+------+-----+---------+-------+
MediaWiki バージョン:
1.2

DESCRIBE recentchanges;

+-------------------+---------------------+------+-----+---------+-------+
| Field             | Type                | Null | Key | Default | Extra |
+-------------------+---------------------+------+-----+---------+-------+
| rc_timestamp      | varchar(14) binary  | NO   | MUL | NULL    |       |
| rc_cur_time       | varchar(14) binary  | NO   |     | NULL    |       |
| rc_user           | int(10) unsigned    | NO   |     | 0       |       |
| rc_user_text      | varchar(255) binary | NO   |     | NULL    |       |
| rc_namespace      | tinyint(3) unsigned | NO   | MUL | 0       |       |
| rc_title          | varchar(255) binary | NO   |     | NULL    |       |
| rc_comment        | varchar(255) binary | NO   |     | NULL    |       |
| rc_minor          | tinyint(3) unsigned | NO   |     | 0       |       |
| rc_bot            | tinyint(3) unsigned | NO   |     | 0       |       |
| rc_new            | tinyint(3) unsigned | NO   | MUL | 0       |       |
| rc_cur_id         | int(10) unsigned    | NO   | MUL | 0       |       |
| rc_this_oldid     | int(10) unsigned    | NO   |     | 0       |       |
| rc_last_oldid     | int(10) unsigned    | NO   |     | 0       |       |
| rc_type           | tinyint(3) unsigned | NO   |     | 0       |       |
| rc_moved_to_ns    | tinyint(3) unsigned | NO   |     | 0       |       |
| rc_moved_to_title | varchar(255) binary | NO   |     | NULL    |       |
+-------------------+---------------------+------+-----+---------+-------+
MediaWiki バージョン:
1.1

DESCRIBE recentchanges;

+-------------------+---------------------+------+-----+---------+-------+
| Field             | Type                | Null | Key | Default | Extra |
+-------------------+---------------------+------+-----+---------+-------+
| rc_timestamp      | varchar(14) binary  | NO   | MUL | NULL    |       |
| rc_cur_time       | varchar(14) binary  | NO   |     | NULL    |       |
| rc_user           | int(10) unsigned    | NO   |     | 0       |       |
| rc_user_text      | varchar(255) binary | NO   |     | NULL    |       |
| rc_namespace      | tinyint(3) unsigned | NO   | MUL | 0       |       |
| rc_title          | varchar(255) binary | NO   |     | NULL    |       |
| rc_comment        | varchar(255) binary | NO   |     | NULL    |       |
| rc_minor          | tinyint(3) unsigned | NO   |     | 0       |       |
| rc_bot            | tinyint(3) unsigned | NO   |     | 0       |       |
| rc_new            | tinyint(3) unsigned | NO   | MUL | 0       |       |
| rc_cur_id         | int(10) unsigned    | NO   | MUL | 0       |       |
| rc_this_oldid     | int(10) unsigned    | NO   |     | 0       |       |
| rc_last_oldid     | int(10) unsigned    | NO   |     | 0       |       |
+-------------------+---------------------+------+-----+---------+-------+

インデックス

MediaWiki バージョン:
1.36

SHOW INDEX IN recentchanges;

+---------------+------------+----------------------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table         | Non_unique | Key_name                         | Seq_in_index | Column_name   | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+---------------+------------+----------------------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| recentchanges |          0 | PRIMARY                          |            1 | rc_id         | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| recentchanges |          1 | rc_timestamp                     |            1 | rc_timestamp  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| recentchanges |          1 | rc_namespace_title_timestamp     |            1 | rc_namespace  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| recentchanges |          1 | rc_namespace_title_timestamp     |            2 | rc_title      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| recentchanges |          1 | rc_namespace_title_timestamp     |            3 | rc_timestamp  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| recentchanges |          1 | rc_cur_id                        |            1 | rc_cur_id     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| recentchanges |          1 | rc_new_name_timestamp            |            1 | rc_new        | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| recentchanges |          1 | rc_new_name_timestamp            |            2 | rc_namespace  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| recentchanges |          1 | rc_new_name_timestamp            |            3 | rc_timestamp  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| recentchanges |          1 | rc_ip                            |            1 | rc_ip         | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| recentchanges |          1 | rc_ns_actor                      |            1 | rc_namespace  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| recentchanges |          1 | rc_ns_actor                      |            2 | rc_actor      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| recentchanges |          1 | rc_actor                         |            1 | rc_actor      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| recentchanges |          1 | rc_actor                         |            2 | rc_timestamp  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| recentchanges |          1 | rc_name_type_patrolled_timestamp |            1 | rc_namespace  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| recentchanges |          1 | rc_name_type_patrolled_timestamp |            2 | rc_type       | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| recentchanges |          1 | rc_name_type_patrolled_timestamp |            3 | rc_patrolled  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| recentchanges |          1 | rc_name_type_patrolled_timestamp |            4 | rc_timestamp  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| recentchanges |          1 | rc_this_oldid                    |            1 | rc_this_oldid | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+---------------+------------+----------------------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

関連項目