LZMQjjWV

1-- Drop clustered index so improper Cachekey Size can be fixed.
2IF EXISTS (SELECT * FROM sys.indexes WHERE name=N'{objectQualifier}PersistentCacheClusteredIndex' AND object_id = OBJECT_ID(N'[{objectQualifier}DnnSharp_PersistentCache]'))
3DROP INDEX [{objectQualifier}PersistentCacheClusteredIndex] ON {databaseOwner}[{objectQualifier}DnnSharp_PersistentCache]
4GO
5
6---- Fix improper Cachekey Size. Stripe has 101 characters.
7IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'{databaseOwner}[{objectQualifier}DnnSharp_PersistentCache]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
8ALTER TABLE {databaseOwner}[{objectQualifier}DnnSharp_PersistentCache] ALTER COLUMN Cachekey nvarchar(200)
9GO
10
11IF NOT EXISTS (SELECT * FROM sys.indexes WHERE name=N'{objectQualifier}PersistentCacheClusteredIndex' AND object_id = OBJECT_ID(N'[{objectQualifier}DnnSharp_PersistentCache]'))
12	CREATE CLUSTERED INDEX [{objectQualifier}PersistentCacheClusteredIndex] ON {databaseOwner}[{objectQualifier}DnnSharp_PersistentCache](CacheKey)
13
14GO