Manual:user_rights table
Appearance
↑ Manual:Contents | MediaWiki database layout | user_rights table |
MediaWiki version: | 1.4 |
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
[edit]MediaWiki version: | 1.4 |
DESCRIBE user_rights;
+-----------+-----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-----------------+------+-----+---------+-------+ | ur_user | int(5) unsigned | NO | PRI | NULL | | | ur_rights | tinyblob | NO | | NULL | | +-----------+-----------------+------+-----+---------+-------+
Indexes
[edit]MediaWiki version: | 1.4 |
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 | | | +-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+