Manual:user_rights table
From Linux Web Expert
| ↑ Manual:Contents | <translate> MediaWiki database layout</translate> | <translate> <tvar name=1>user_rights</tvar> table</translate> |
1.4
| MediaWiki version: |
The user_rights table is not used in the MediaWiki 1.5 release, and can be safely deleted.
- ur_user: The user's user_id
- ur_rights: The rights for that user
Schema summary
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.4</tvar> is unsupported version</translate>"> 1.4
| MediaWiki version: |
DESCRIBE user_rights;
+-----------+-----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-----------------+------+-----+---------+-------+ | ur_user | int(5) unsigned | NO | PRI | NULL | | | ur_rights | tinyblob | NO | | NULL | | +-----------+-----------------+------+-----+---------+-------+
Indexes
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.4</tvar> is unsupported version</translate>"> 1.4
| MediaWiki version: |
SHOW INDEX IN user_rights;
+-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | user_rights | 0 | ur_user | 1 | ur_user | A | 0 | NULL | NULL | | BTREE | | | +-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
