The
recentchanges
table contains information about the latest modifications done to the wiki (not older than
$wgRCMaxAge
; see also below).
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.
Fields
[
edit
]
rc_id
[
edit
]
This is the primary key for the table.
(introduced in 1.5)
rc_timestamp
[
edit
]
Holds the
timestamp
of the change.
Corresponds to
rev_timestamp
(and
log_timestamp
, in the case of log actions).
rc_cur_time
[
edit
]
MediaWiki version:
|
≤
1.23
|
Had been deprecated, but was first held for backwards compatibility.
(removed in 1.24wmf6)
rc_user
[
edit
]
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
Wikibase
the results will otherwise be meaningless.
On other wikis, bots or imports may be more relevant than you expect.
(deprecated in 1.31)
;
Deprecated in favor of
rc_actor
.
rc_user_text
[
edit
]
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).
(deprecated in 1.31)
;
Deprecated in favor of
rc_actor
.
rc_actor
[
edit
]
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
[
edit
]
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
[
edit
]
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.
MediaWiki version:
|
≤
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.
(deprecated in 1.30)
;
rc_comment_id and the comment table should be used instead!
MediaWiki version:
|
≥
1.30
|
This is a foreign key to
comment_id
in the
comment
table.
rc_minor
[
edit
]
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
[
edit
]
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
[
edit
]
If the value for this field is 1, then this edit created a page; it is 0 otherwise.
rc_cur_id
[
edit
]
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
[
edit
]
Links to the
rev_id
key of the new page revision (after the edit occurs) in the
revision
table.
rc_last_oldid
[
edit
]
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
[
edit
]
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
[
edit
]
MediaWiki version:
|
≥
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
[
edit
]
MediaWiki versions:
|
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
[
edit
]
MediaWiki versions:
|
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
[
edit
]
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.
(introduced in 1.4)
MediaWiki version:
|
≥
1.31
|
rc_patrolled now has three states: "0" for unpatrolled, "1" for manually patrolled, and "2" for autopatrolled actions.
rc_ip
[
edit
]
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.
Autoblock
use it to automatically block the more recent IP used by a user who is blocked.
rc_old_len
[
edit
]
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
[
edit
]
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
[
edit
]
MediaWiki version:
|
≥
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
[
edit
]
MediaWiki version:
|
≥
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.
(introduced in 1.10)
rc_log_type
[
edit
]
MediaWiki version:
|
≥
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
[
edit
]
MediaWiki version:
|
≥
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
[
edit
]
MediaWiki version:
|
≥
1.10
|
This field will be a mirror of
log_params
, following the log_params text rewrite.
(introduced in 1.10)
Schema summary
[
edit
]
MediaWiki version:
|
≥
1.43
|
DESCRIBE
recentchanges
;
+---------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+---------------------+------+-----+---------+----------------+
| rc_id | bigint(20) 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 versions:
|
1.36 – 1.42
|
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 versions:
|
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 | |
+---------------+---------------------+------+-----+---------+----------------+
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 | |
+---------------+---------------------+------+-----+---------+----------------+
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 | |
+---------------+---------------------+------+-----+---------+----------------+
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 | |
+---------------+---------------------+------+-----+---------+----------------+
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 versions:
|
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 | |
+---------------+---------------------+------+-----+---------+----------------+
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 | |
+-------------------+---------------------+------+-----+---------+----------------+
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 versions:
|
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 versions:
|
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 | |
+-------------------+---------------------+------+-----+---------+----------------+
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 | |
+-------------------+---------------------+------+-----+---------+----------------+
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 versions:
|
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 | |
+-------------------+---------------------+------+-----+---------+----------------+
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 | |
+-------------------+---------------------+------+-----+---------+----------------+
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 | |
+-------------------+---------------------+------+-----+---------+-------+
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 | |
+-------------------+---------------------+------+-----+---------+-------+
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 | |
+-------------------+---------------------+------+-----+---------+-------+
Indexes
[
edit
]
MediaWiki version:
|
≥
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 | | |
+---------------+------------+----------------------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
See also
[
edit
]
|
---|
Engines
| |
---|
Technical documentation
| |
---|
Configuration
| |
---|
Development
| |
---|
Core tables
| |
---|