The Source Code - Multilevel Security for Relational Databases - page 165

GO
CREATE TABLE [dbo].[tblMarking](
[CategoryID] [int] NOT NULL,
[MarkingRoleName] [nvarchar](50) NOT NULL,
[MarkingString] [nvarchar](50) NULL,
[Description] [nvarchar](50) NULL,
[RoleType] [nvarchar](50) NULL,
[InternallyGenerated] [nvarchar](50) NULL,
CONSTRAINT [PK_tblMarking] PRIMARY KEY CLUSTERED
(
[CategoryID] ASC,
[MarkingRoleName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_
PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[tblMarkingHierarchy](
[ParentCategoryID] [int] NOT NULL,
[ParentMarkingRoleName] [nvarchar](50) NOT NULL,
[ChildCategoryID] [int] NOT NULL,
[ChildMarkingRoleName] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_tblMarkingHierarchy] PRIMARY KEY
CLUSTERED
(
[ParentCategoryID] ASC,
[ParentMarkingRoleName] ASC,
[ChildCategoryID] ASC,
[ChildMarkingRoleName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_
PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[tblUniqueLabel](
[ID] [int] NOT NULL,
[Label] [nvarchar](50) NULL,
[KeyName] [nvarchar](50) NULL,
[CertName] [nvarchar](50) NULL,
CONSTRAINT [PK_tblUniqueLabel] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_
PAGE_LOCKS = ON) ON [PRIMARY]