38 lines
4.4 KiB
Transact-SQL
38 lines
4.4 KiB
Transact-SQL
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_UserUIItemSettings_UIItems]') AND parent_object_id = OBJECT_ID(N'[dbo].[UIItemSettings]'))
|
||
ALTER TABLE [dbo].[UIItemSettings] DROP CONSTRAINT [FK_UserUIItemSettings_UIItems]
|
||
GO
|
||
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_UserUIItemSettings_DataPROUsers]') AND parent_object_id = OBJECT_ID(N'[dbo].[UIItemSettings]'))
|
||
ALTER TABLE [dbo].[UIItemSettings] DROP CONSTRAINT [FK_UserUIItemSettings_DataPROUsers]
|
||
GO
|
||
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UIItemSettings]') AND type in (N'U'))
|
||
DROP TABLE [dbo].[UIItemSettings]
|
||
GO
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UIItemSettings]') AND type in (N'U'))
|
||
BEGIN
|
||
CREATE TABLE [dbo].[UIItemSettings](
|
||
[UserID] [int] NOT NULL,
|
||
[UIItemID] [bigint] NOT NULL,
|
||
[Permission] [smallint] NOT NULL,
|
||
[Visible] [bit] NOT NULL
|
||
) ON [PRIMARY]
|
||
END
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_UserUIItemSettings_DataPROUsers]') AND parent_object_id = OBJECT_ID(N'[dbo].[UIItemSettings]'))
|
||
ALTER TABLE [dbo].[UIItemSettings] WITH CHECK ADD CONSTRAINT [FK_UserUIItemSettings_DataPROUsers] FOREIGN KEY([UserID])
|
||
REFERENCES [dbo].[Users] ([ID])
|
||
GO
|
||
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_UserUIItemSettings_DataPROUsers]') AND parent_object_id = OBJECT_ID(N'[dbo].[UIItemSettings]'))
|
||
ALTER TABLE [dbo].[UIItemSettings] CHECK CONSTRAINT [FK_UserUIItemSettings_DataPROUsers]
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_UserUIItemSettings_UIItems]') AND parent_object_id = OBJECT_ID(N'[dbo].[UIItemSettings]'))
|
||
ALTER TABLE [dbo].[UIItemSettings] WITH CHECK ADD CONSTRAINT [FK_UserUIItemSettings_UIItems] FOREIGN KEY([UIItemID])
|
||
REFERENCES [dbo].[UIItems] ([ID])
|
||
GO
|
||
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_UserUIItemSettings_UIItems]') AND parent_object_id = OBJECT_ID(N'[dbo].[UIItemSettings]'))
|
||
ALTER TABLE [dbo].[UIItemSettings] CHECK CONSTRAINT [FK_UserUIItemSettings_UIItems]
|
||
GO
|