User:RichMorin/mw user groups

From Meta, a Wikimedia project coordination wiki

User permissions have been broken out to a separate table; this allows sites with a shared user table to have different permissions assigned to a user in each project.

This table replaces the old user_rights field, which used a comma-separated blob.


Inter-table Relationships[edit]

  • ug_user - user ID ( user.user_id)


MySQL Table Description[edit]

mysql> desc mw_user_groups;
+----------+-----------------+------+-----+---------+-------+
| Field    | Type            | Null | Key | Default | Extra |
+----------+-----------------+------+-----+---------+-------+
| ug_user  | int(5) unsigned |      | PRI | 0       |       |
| ug_group | char(16)        |      | PRI |         |       |
+----------+-----------------+------+-----+---------+-------+
2 rows in set


Annotated Table Creation Code[edit]

-- User permissions have been broken out to a separate table;
-- this allows sites with a shared user table to have different
-- permissions assigned to a user in each project.
--
-- This table replaces the old user_rights field,
-- which used a comma-separated blob.

CREATE TABLE /*$wgDBprefix*/user_groups (

  -- Key to user_id

  ug_user             int(5)         unsigned     NOT NULL  default '0',
  
  -- Group names are short symbolic string keys.
  -- The set of group names is open-ended, though in practice
  -- only some predefined ones are likely to be used.
  --
  -- At runtime, $wgGroupPermissions will associate group keys
  -- with particular permissions.  A user will have the combined
  -- permissions of any group they're explicitly in, plus
  -- the implicit '*' and 'user' groups.

  ug_group            char(16)                    NOT NULL  default '',
  
PRIMARY KEY           (ug_user, ug_group),
KEY                   (ug_group)

) ENGINE=InnoDB;