KGRKJGETMRETU895U-589TY5MIGM5JGB5SDFESFREWTGR54TY
Server : Apache/2.4.58 (Win64) OpenSSL/3.1.3 PHP/8.2.12
System : Windows NT SERVER-PC 10.0 build 26200 (Windows 11) AMD64
User : ServerPC ( 0)
PHP Version : 8.2.12
Disable Function : NONE
Directory :  C:/Windows/Microsoft.NET/Framework64/v4.0.30319/SQL/en/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : C:/Windows/Microsoft.NET/Framework64/v4.0.30319/SQL/en/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

Anon7 - 2021