CREATE TABLE [dbo].[AdminHistoryAdminRole]
(
[AdminHistoryAdminRoleId] [int] NOT NULL IDENTITY(1, 1),
[AdminRoleFid] [int] NOT NULL,
[IsTracked] [bit] NOT NULL CONSTRAINT [DF_AdminHistoryScreen_IsTracked] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AdminHistoryAdminRole] ADD CONSTRAINT [PK_AdminHistoryAdminRole] PRIMARY KEY CLUSTERED  ([AdminHistoryAdminRoleId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AdminHistoryAdminRole] ADD CONSTRAINT [IX_AdminHistoryAdminRole_AdminRole] UNIQUE NONCLUSTERED  ([AdminRoleFid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AdminHistoryAdminRole] ADD CONSTRAINT [FK_AdminHistoryAdminRole_AdminRole] FOREIGN KEY ([AdminRoleFid]) REFERENCES [dbo].[AdminRole] ([AdminRoleID])
GO
GRANT SELECT ON  [dbo].[AdminHistoryAdminRole] TO [MssExec]
GRANT INSERT ON  [dbo].[AdminHistoryAdminRole] TO [MssExec]
GRANT DELETE ON  [dbo].[AdminHistoryAdminRole] TO [MssExec]
GRANT UPDATE ON  [dbo].[AdminHistoryAdminRole] TO [MssExec]
GO