Twice Shell

[ EDITING: SqlPersistenceProviderSchema.sql ]

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

[ CLOSE ]

Name	Size	Attr	Date	Action
[FILE] DropSqlPersistenceProviderLogic.sql	2.34 KB	---A	18-08-09 10:26	DL REN ATTR DEL
[FILE] DropSqlPersistenceProviderSchema.sql	1.29 KB	---A	18-08-09 10:26	DL REN ATTR DEL
[FILE] SqlPersistenceProviderLogic.sql	13.17 KB	---A	18-08-09 10:26	DL REN ATTR DEL
[FILE] SqlPersistenceProviderSchema.sql	2.09 KB	---A	18-08-09 10:26	DL REN ATTR DEL

TWICE

[ EDITING: SqlPersistenceProviderSchema.sql ]