Manual:user_rights table

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

DESCRIBEuser_rights;

+-----------+-----------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-----------------+------+-----+---------+-------+
| ur_user | int(5) unsigned | NO | PRI | NULL | |
| ur_rights | tinyblob | NO | | NULL | |
+-----------+-----------------+------+-----+---------+-------+

SHOWINDEXINuser_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 | | |
+-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

• MediaWiki database tables