SET NOCOUNT ON;
USE PerfTest;
GO

-- Only for development: Drop certificate
IF EXISTS (
	SELECT 1
	FROM sys.certificates
	WHERE name = N'PerfTestCert'
) BEGIN
	PRINT 'Drop certificate';
	DROP CERTIFICATE PerfTestCert;
END;
GO

-- Only for development: Drop master key
IF EXISTS (
	SELECT 1
	FROM sys.symmetric_keys
	WHERE name = '##MS_DatabaseMasterKey##'
) BEGIN
	PRINT 'Drop master key';
	DROP MASTER KEY;
END;
GO

-- Create master key
IF NOT EXISTS (
	SELECT 1
	FROM sys.symmetric_keys
	WHERE name = '##MS_DatabaseMasterKey##'
) BEGIN
	PRINT 'Create master key';
	CREATE MASTER KEY ENCRYPTION BY PASSWORD = N'dbJ0u7n4!';
END;
GO

-- Create certificate
IF NOT EXISTS (
	SELECT 1
	FROM sys.certificates
	WHERE name = N'PerfTestCert'
) BEGIN
	PRINT 'Create certificate';
	CREATE CERTIFICATE PerfTestCert WITH SUBJECT = N'PerfTest';
END;
GO

-- Create symmetric key
IF NOT EXISTS (
	SELECT 1
	FROM sys.symmetric_keys
	WHERE name = 'PerfTestKey'
) BEGIN
	PRINT 'Create key';
	CREATE SYMMETRIC KEY PerfTestKey
	WITH ALGORITHM = RC4_128	-- AES is not available on Windows XP
--	WITH ALGORITHM = AES_256
	ENCRYPTION BY CERTIFICATE PerfTestCert;
END;
GO

PRINT '<< DONE >>'
GO