CREATE TABLE [dbo].[ReportSettings_UserPermissions]
(
[ReportSettingsID] [int] NOT NULL,
[UserPermissionsID] [int] NOT NULL,
[OrderIndex] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ReportSettings_UserPermissions] ADD CONSTRAINT [PK_ReportSettings_UserPermissions_ReportSettingsID_UserPermissionsID] PRIMARY KEY CLUSTERED ([ReportSettingsID], [UserPermissionsID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ReportSettings_UserPermissions] ADD CONSTRAINT [FK_ReportSettings_UserPermissions_ReportSettingsID_ReportSettings_ID] FOREIGN KEY ([ReportSettingsID]) REFERENCES [dbo].[ReportSettings] ([ID]) ON DELETE CASCADE ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[ReportSettings_UserPermissions] ADD CONSTRAINT [FK_ReportSettings_UserPermissions_UserPermissionsID_UserPermissions_UserPermissionsID] FOREIGN KEY ([UserPermissionsID]) REFERENCES [dbo].[UserPermissions] ([UserPermissionsID])
GO