maintenance/mssql/archives/patch-slot_roles.sql

   1 --
   2 -- Normalization table for role names
   3 --
   4 CREATE TABLE /*_*/slot_roles (
   5   role_id smallint NOT NULL CONSTRAINT PK_slot_roles PRIMARY KEY IDENTITY,
   6   role_name nvarchar(64) NOT NULL
   7 );
   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);