/********** CREATE FULLTEXT INDEXES ***********/

 

 

IF NOT EXISTS (SELECT 1 FROM sys.fulltext_catalogs WHERE [name] = 'ftCatalog')
BEGIN
	CREATE FULLTEXT CATALOG ftCatalog AS DEFAULT;
END

 

 

IF OBJECTPROPERTY ( object_id('fshInvestmentSearch'), 'TableHasActiveFulltextIndex') = 0 
BEGIN
	CREATE FULLTEXT INDEX ON dbo.[fshInvestmentSearch] ([SearchValues]) KEY INDEX [PK_fshInvestmentSearch] ON ftCatalog WITH CHANGE_TRACKING AUTO; 
END

 

IF OBJECTPROPERTY ( object_id('fshUnifiedEntitiesSearch'), 'TableHasActiveFulltextIndex') = 0 
BEGIN
	CREATE FULLTEXT INDEX ON dbo.[fshUnifiedEntitiesSearch] ([SearchValues]) KEY INDEX [PK_fshUnifiedEntitiesSearch] ON ftCatalog WITH CHANGE_TRACKING AUTO; 
END

 

 

IF OBJECTPROPERTY ( object_id('fshQuickEntitiesSearch'), 'TableHasActiveFulltextIndex') = 0 
BEGIN
	CREATE FULLTEXT INDEX ON dbo.[fshQuickEntitiesSearch] ([SearchValues]) KEY INDEX [PK_fshQuickEntitiesSearch] ON ftCatalog WITH CHANGE_TRACKING AUTO; 
END

 

 

IF OBJECTPROPERTY ( object_id('fshQuickContactsSearch'), 'TableHasActiveFulltextIndex') = 0 
BEGIN
	CREATE FULLTEXT INDEX ON dbo.[fshQuickContactsSearch] ([SearchValues]) KEY INDEX [PK_fshQuickContactsSearch] ON ftCatalog WITH CHANGE_TRACKING AUTO; 
END

 

 

IF OBJECTPROPERTY ( object_id('fshNominalSearch'), 'TableHasActiveFulltextIndex') = 0 
BEGIN
	CREATE FULLTEXT INDEX ON dbo.[fshNominalSearch] ([SearchValues]) KEY INDEX [PK_fshNominalSearch] ON ftCatalog WITH CHANGE_TRACKING AUTO; 
END

 

IF OBJECTPROPERTY ( object_id('fshFundNominalSearch'), 'TableHasActiveFulltextIndex') = 0 
BEGIN
	CREATE FULLTEXT INDEX ON dbo.[fshFundNominalSearch] ([SearchValues]) KEY INDEX [PK_fshFundNominalSearch] ON ftCatalog WITH CHANGE_TRACKING AUTO; 
END

 

IF OBJECTPROPERTY ( object_id('fshFundSearch'), 'TableHasActiveFulltextIndex') = 0 
BEGIN
	CREATE FULLTEXT INDEX ON dbo.[fshFundSearch] ([SearchValues]) KEY INDEX [PK_fshFundSearch] ON ftCatalog WITH CHANGE_TRACKING AUTO; 
END

 

IF OBJECTPROPERTY ( object_id('fshAssetSearch'), 'TableHasActiveFulltextIndex') = 0 
BEGIN
	CREATE FULLTEXT INDEX ON dbo.[fshAssetSearch] ([SearchValues]) KEY INDEX [PK_fshAssetSearch] ON ftCatalog WITH CHANGE_TRACKING AUTO; 
END

 

 

IF OBJECTPROPERTY ( object_id('fshAddressSearch'), 'TableHasActiveFulltextIndex') = 0 
BEGIN
	CREATE FULLTEXT INDEX ON dbo.[fshAddressSearch] ([SearchValues]) KEY INDEX [PK_fshAddressSearch] ON ftCatalog WITH CHANGE_TRACKING AUTO; 
END

 

 

IF OBJECTPROPERTY ( object_id('fshRegisterSearch'), 'TableHasActiveFulltextIndex') = 0 
BEGIN
	CREATE FULLTEXT INDEX ON dbo.[fshRegisterSearch] ([SearchValues]) KEY INDEX [PK_fshRegisterSearch] ON ftCatalog WITH CHANGE_TRACKING AUTO; 
END
GO