maintenance/archives/patch-slot_roles.sql

   1 --
   2 -- Normalization table for role names
   3 --
   4 CREATE TABLE /*_*/slot_roles (
   5   role_id smallint PRIMARY KEY AUTO_INCREMENT,
   6   role_name varbinary(64) NOT NULL
   7 ) /*$wgDBTableOptions*/;
   8
   9 -- Index for looking of the internal ID of for a name
  10 CREATE UNIQUE INDEX /*i*/role_name ON /*_*/slot_roles (role_name);