This dump file contains information about the current special roles granted to registered editors in that Wikipedia. Therefore, this is a static snapshot of the assignment of roles among users at the time of creation of the dump.
If you are rather interested in tracking the assignment and revocation of special roles
over time, you can find data about those actions in the
dump of logged events (compressed XML file), which can also be processed
with WikiDAT. Role change events correspond to <type> = rights.
Important: Currently, SQL dump files are only compatible with MySQL or MariaDB databases. Support for additional database engines like PostgreSQL is currently contemplated in WikiDAT's development roadmap but not implemented, yet.
These files are named using the following format:
File: {lang}-{date}-{user_groups}.sql.{compress}
Examples: eswiki-20150429-user_groups.sql.gzAll fields are mandatory and shown in {}. The meaning of each field is:
This file contains an SQL dump of the MediaWiki
user_groups table. The following excerpt provides the definition of this
table as embedded in the SQL dump.
mysql> describe user_groups;
+----------+-----------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-----------------+------+-----+---------+-------+
| ug_user | int(5) unsigned | NO | PRI | 0 | |
| ug_group | varbinary(255) | NO | PRI | | |
+----------+-----------------+------+-----+---------+-------+
2 rows in set (0.00 sec)Hence, each row in the table shows information about a single role currently granted to a certain user, at the time of dump production. As a result, users who hold various roles simultaneously have several entries, displaying one role per row (see below for an example).
Besides, it is important to remark that the default table definition, embedded in the
dump file, sets the table engine to InnoDB. However, since WikiDAT is focused on fast analytics
instead of favoring concurrent insertions/deletions, users can modify
on WikiDAT's
config file the database engine to use MyISAM (MySQL) or
Aria (MariaDB) instead.
The following table summarizes the most relevant user roles and their meaning. This is not a complete list. You can check the user access levels page on each Wikipedia language to find out the complete list of roles in that community.
| Tag | Role Name | Description |
|---|---|---|
abusefilter |
Edit Filter managers | These users can create, modify and delete edit filters. |
accountcreator |
Account creator | This right provides accesss to a special tool for opening a large number of accounts to people who request them. Additional info. |
autoreviewer |
Autopatrolled | Previously known as autoreviewer (hece the tag). Users with this role have their pages automatically marked as patrolled on the New Pages list. |
bot |
Bots (software programs) | These user accounts are approved beforehand to make specific type of edits on an automated or semi-automated fashion, driven by software programs. Important: despite a large proportion of bots are correctly identified as such in this table in most Wikipedia languages, there can be cases of bots in some languages that have not been flagged as such in this table. Therefore, it is not guaranteed that this table provides a complete list of all bots in a certain Wikipedia language. |
bureaucrat |
Bureaucrats | Exceptionally trusted users who are granted this role by the community
upon request.
Among other actions, they can add users to the administrator
and bot group, and they can also add users to their own
group (but not remove them). |
checkuser |
Checkusers | These users can access Special:Checkuser to review all IP addresses used by a user account editing the English Wikipedia, a list of all edits made by a certain IP or all users who have edited under the same IP address. |
confirmed |
Autoconfirmed and Confirmed users | The Autoconfrimed role is automatically granted by MediaWiki to users who meet certain restrictions for minium trust (for instance, in English Wikipedia is grated to accouts that are more than 4 days old and have made at least 10 edits). This level is required to move pages, edit semi-protected pages and upload files. The confirmed role is manually granted by administrators upon requests from users. Provides the same rights as Autoconfirmed. |
ipblock-exempt |
Ipblock-exempt | These users are excluded from autoblocks and blocks of single or ranges of IP addresses that are not performed with the "anonymous users only" setting. |
oversight |
Oversight | These users can hide revision of pages from any user permanently, using the Special:HideRevision tool. Besides, they can view a summary log of such actions on Special:Oversight. These users must be at least 18 years old and are request to disclosure their real identity to Wikimedia Foundation. |
reviewer |
Pending changes reviewer | These users can review edits from other users flagged by the pending changes protection plugin. |
rollbacker |
Rollback | Provides access to MediaWiki's rollback feature, that allows to revert the last consecutive edits made by a user on a given page with a sigle mouse click. |
sysop |
Administrator | This role is granted by the community upon request and after a voting process (whose rules may vary from one Wikipedia language to another). Among other actions, administrators can delete, protect and unprotect pages, block and unblock users and edit fully protected pages. additional details. |
The following code snippet shows an excerpt of the table content recovered from a dump file of this type.
MariaDB [enwiki_20150304]> select * from user_groups limit 20;
+---------+----------------+
| ug_user | ug_group |
+---------+----------------+
| 1 | autoreviewer |
| 1 | reviewer |
| 2 | sysop |
| 4 | sysop |
| 11 | sysop |
| 24 | checkuser |
| 24 | founder |
| 24 | oversight |
| 24 | sysop |
| 31 | sysop |
| 32 | accountcreator |
| 33 | sysop |
| 43 | sysop |
| 51 | bureaucrat |
| 51 | sysop |
| 52 | abusefilter |
| 52 | afttest |
| 59 | sysop |
| 62 | sysop |
| 63 | sysop |
+---------+----------------+
20 rows in set (0.00 sec)