summaryrefslogtreecommitdiff
path: root/www/wiki/maintenance/archives/patch-slot_roles.sql
blob: 0b13caa8d08a70e096184ed21f7486fb9e4e008c (plain)
1
2
3
4
5
6
7
8
9
10
--
-- Normalization table for role names
--
CREATE TABLE /*_*/slot_roles (
  role_id smallint PRIMARY KEY AUTO_INCREMENT,
  role_name varbinary(64) NOT NULL
) /*$wgDBTableOptions*/;

-- Index for looking of the internal ID of for a name
CREATE UNIQUE INDEX /*i*/role_name ON /*_*/slot_roles (role_name);