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);
|