SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

DECLARE @localized_string_AddRole_Failed nvarchar(256)
SET @localized_string_AddRole_Failed = N'Failed adding the ''persistenceUsers'' role'

DECLARE @ret INT, @Error INT
IF NOT EXISTS( SELECT 1 FROM [dbo].[sysusers] WHERE name=N'persistenceUsers' AND issqlrole=1 )
 BEGIN

    EXEC @ret = sp_addrole N'persistenceUsers'

    SELECT @Error = @@ERROR

    IF @ret <> 0 OR @Error <> 0
        RAISERROR( @localized_string_AddRole_Failed, 16, -1 )
 END
GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InstanceData]') AND TYPE IN (N'U'))
    DROP TABLE [dbo].[InstanceData]
GO
CREATE TABLE [dbo].[InstanceData](
    [id] [uniqueidentifier] NOT NULL,
    [instance] [image] NULL,
    [instanceXml] [xml] NULL,
    [created] [datetime] NOT NULL,
    [lastUpdated] [datetime] NOT NULL,
    [lockOwner] [uniqueidentifier] NULL,
    [lockExpiration] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX id_index
    ON [dbo].[InstanceData] ([id])
    WITH IGNORE_DUP_KEY
GO