summaryrefslogtreecommitdiff
path: root/www/wiki/maintenance/mssql/archives/patch-slot_roles.sql
blob: 228510cd03852d3a554064e9e8b5b9d11860c19f (plain)
1
2
3
4
5
6
7
8
9
10
--
-- Normalization table for role names
--
CREATE TABLE /*_*/slot_roles (
  role_id smallint NOT NULL CONSTRAINT PK_slot_roles PRIMARY KEY IDENTITY,
  role_name nvarchar(64) NOT NULL
);

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