Devart Forums

Code: Select all

CREATE TABLE [dbo].[Script] (
    [Script_ID] UNIQUEIDENTIFIER CONSTRAINT [DEF_Script_Script_ID] DEFAULT newid() NOT NULL,
    [Name] NVARCHAR(50) COLLATE Latin1_General_CI_AS NOT NULL,
    [OrderTag] INTEGER,
    [DBAGuid] UNIQUEIDENTIFIER,
    [SQL] NVARCHAR(max) COLLATE Latin1_General_CI_AS NOT NULL,
    [ScriptCondition_ID] UNIQUEIDENTIFIER,
    [ScriptOrder_ID] UNIQUEIDENTIFIER,
    [Predefined] BIT CONSTRAINT [DEF_Script_Predefined] DEFAULT 0 NOT NULL,
    [ArchiveMode] INTEGER CONSTRAINT [DEF_Script_ArchiveMode] DEFAULT 0 NOT NULL,
    CONSTRAINT [PK_Script_dbo] PRIMARY KEY NONCLUSTERED ([Script_ID])
)
GO

CREATE UNIQUE NONCLUSTERED INDEX [IDX_Script_1] ON [dbo].[Script] ([Predefined] ASC,[Name] ASC)
GO

CREATE TABLE [mgmt].[Script] (
    [Script_ID] UNIQUEIDENTIFIER NOT NULL,
    [Name] NVARCHAR(50) COLLATE Latin1_General_CI_AS NOT NULL,
    [OrderTag] INTEGER,
    [DBAGuid] UNIQUEIDENTIFIER,
    [SQL] NVARCHAR(max) COLLATE Latin1_General_CI_AS NOT NULL,
    [ScriptCondition_ID] UNIQUEIDENTIFIER,
    [ScriptOrder_ID] UNIQUEIDENTIFIER,
    [Predefined] BIT CONSTRAINT [DEF_Script_Predefined] DEFAULT 1 NOT NULL,
    [ArchiveMode] INTEGER CONSTRAINT [DEF_Script_ArchiveMode] DEFAULT 0 NOT NULL,
    CONSTRAINT [PK_Script_mgmt] PRIMARY KEY NONCLUSTERED ([Script_ID])
)
GO

CREATE UNIQUE NONCLUSTERED INDEX [IDX_Script_1_mgmt] ON [mgmt].[Script] ([Predefined] ASC,[Name] ASC)
GO