CREATE FULLTEXT CATALOG [PROCAD] WITH ACCENT_SENSITIVITY = ON
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE FULLTEXT INDEX ON [EDM_BLOCK](
[B_C00] LANGUAGE 'Neutral', 
[B_C01] LANGUAGE 'Neutral', 
[B_C02] LANGUAGE 'Neutral', 
[B_C03] LANGUAGE 'Neutral', 
[B_C04] LANGUAGE 'Neutral', 
[B_C05] LANGUAGE 'Neutral', 
[B_C06] LANGUAGE 'Neutral', 
[B_C07] LANGUAGE 'Neutral', 
[B_C08] LANGUAGE 'Neutral', 
[B_C09] LANGUAGE 'Neutral', 
[B_C10] LANGUAGE 'Neutral', 
[B_C11] LANGUAGE 'Neutral', 
[B_C12] LANGUAGE 'Neutral', 
[B_C13] LANGUAGE 'Neutral', 
[B_C14] LANGUAGE 'Neutral', 
[B_C15] LANGUAGE 'Neutral', 
[B_C16] LANGUAGE 'Neutral', 
[B_C17] LANGUAGE 'Neutral', 
[B_C18] LANGUAGE 'Neutral', 
[B_C19] LANGUAGE 'Neutral', 
[B_M00] LANGUAGE 'Neutral', 
[B_M01] LANGUAGE 'Neutral', 
[B_M02] LANGUAGE 'Neutral', 
[B_M03] LANGUAGE 'Neutral', 
[B_M04] LANGUAGE 'Neutral')
KEY INDEX [UI_B_BLOCK_ID]ON ([PROCAD], FILEGROUP [PRIMARY])
WITH (CHANGE_TRACKING = AUTO, STOPLIST = SYSTEM)
  
GO
CREATE FULLTEXT INDEX ON [DOKSTAMM](
[DO_ARCHUSER] LANGUAGE 'Neutral', 
[DO_CLIENT] LANGUAGE 'Neutral', 
[DO_CUSER] LANGUAGE 'Neutral', 
[DO_DCUSER] LANGUAGE 'Neutral', 
[DO_DDUSER] LANGUAGE 'Neutral', 
[DO_DMUSER] LANGUAGE 'Neutral', 
[DO_DRUSER] LANGUAGE 'Neutral', 
[DO_DSUSER] LANGUAGE 'Neutral', 
[DO_DUSER] LANGUAGE 'Neutral', 
[DO_DWUSER] LANGUAGE 'Neutral', 
[DO_EXT] LANGUAGE 'Neutral', 
[DO_FSTL1] LANGUAGE 'Neutral', 
[DO_FSTL10] LANGUAGE 'Neutral', 
[DO_FSTL11] LANGUAGE 'Neutral', 
[DO_FSTL12] LANGUAGE 'Neutral', 
[DO_FSTL13] LANGUAGE 'Neutral', 
[DO_FSTL14] LANGUAGE 'Neutral', 
[DO_FSTL15] LANGUAGE 'Neutral', 
[DO_FSTL16] LANGUAGE 'Neutral', 
[DO_FSTL17] LANGUAGE 'Neutral', 
[DO_FSTL18] LANGUAGE 'Neutral', 
[DO_FSTL19] LANGUAGE 'Neutral', 
[DO_FSTL2] LANGUAGE 'Neutral', 
[DO_FSTL20] LANGUAGE 'Neutral', 
[DO_FSTL21] LANGUAGE 'Neutral', 
[DO_FSTL22] LANGUAGE 'Neutral', 
[DO_FSTL23] LANGUAGE 'Neutral', 
[DO_FSTL24] LANGUAGE 'Neutral', 
[DO_FSTL25] LANGUAGE 'Neutral', 
[DO_FSTL26] LANGUAGE 'Neutral', 
[DO_FSTL27] LANGUAGE 'Neutral', 
[DO_FSTL28] LANGUAGE 'Neutral', 
[DO_FSTL29] LANGUAGE 'Neutral', 
[DO_FSTL3] LANGUAGE 'Neutral', 
[DO_FSTL30] LANGUAGE 'Neutral', 
[DO_FSTL31] LANGUAGE 'Neutral', 
[DO_FSTL32] LANGUAGE 'Neutral', 
[DO_FSTL33] LANGUAGE 'Neutral', 
[DO_FSTL34] LANGUAGE 'Neutral', 
[DO_FSTL35] LANGUAGE 'Neutral', 
[DO_FSTL36] LANGUAGE 'Neutral', 
[DO_FSTL37] LANGUAGE 'Neutral', 
[DO_FSTL38] LANGUAGE 'Neutral', 
[DO_FSTL39] LANGUAGE 'Neutral', 
[DO_FSTL4] LANGUAGE 'Neutral', 
[DO_FSTL40] LANGUAGE 'Neutral', 
[DO_FSTL5] LANGUAGE 'Neutral', 
[DO_FSTL6] LANGUAGE 'Neutral', 
[DO_FSTL7] LANGUAGE 'Neutral', 
[DO_FSTL8] LANGUAGE 'Neutral', 
[DO_FSTL9] LANGUAGE 'Neutral', 
[DO_GUID] LANGUAGE 'Neutral', 
[DO_LTAG1] LANGUAGE 'Neutral', 
[DO_LTAG10] LANGUAGE 'Neutral', 
[DO_LTAG2] LANGUAGE 'Neutral', 
[DO_LTAG3] LANGUAGE 'Neutral', 
[DO_LTAG4] LANGUAGE 'Neutral', 
[DO_LTAG5] LANGUAGE 'Neutral', 
[DO_LTAG6] LANGUAGE 'Neutral', 
[DO_LTAG7] LANGUAGE 'Neutral', 
[DO_LTAG8] LANGUAGE 'Neutral', 
[DO_LTAG9] LANGUAGE 'Neutral', 
[DO_MUSER] LANGUAGE 'Neutral', 
[DO_NAME] LANGUAGE 'Neutral', 
[DO_NDFEXTENSION] LANGUAGE 'Neutral', 
[DO_PPSERROR] LANGUAGE 'Neutral', 
[DO_TAG1] LANGUAGE 'Neutral', 
[DO_TAG10] LANGUAGE 'Neutral', 
[DO_TAG2] LANGUAGE 'Neutral', 
[DO_TAG3] LANGUAGE 'Neutral', 
[DO_TAG4] LANGUAGE 'Neutral', 
[DO_TAG5] LANGUAGE 'Neutral', 
[DO_TAG6] LANGUAGE 'Neutral', 
[DO_TAG7] LANGUAGE 'Neutral', 
[DO_TAG8] LANGUAGE 'Neutral', 
[DO_TAG9] LANGUAGE 'Neutral', 
[DO_VERS] LANGUAGE 'Neutral', 
[DO_WUSER] LANGUAGE 'Neutral')
KEY INDEX [PK_DOKSTAMM]ON ([PROCAD], FILEGROUP [PRIMARY])
WITH (CHANGE_TRACKING = AUTO, STOPLIST = SYSTEM)

GO
CREATE FULLTEXT INDEX ON [DOKTYP](
[DY_NAM] LANGUAGE 'Neutral')
KEY INDEX [PK_DOKTYP]ON ([PROCAD], FILEGROUP [PRIMARY])
WITH (CHANGE_TRACKING = AUTO, STOPLIST = SYSTEM)

GO
CREATE FULLTEXT INDEX ON [DOKVAR](
[DV_VSTL1] LANGUAGE 'Neutral',
[DV_VSTL2] LANGUAGE 'Neutral',
[DV_VSTL3] LANGUAGE 'Neutral',
[DV_VSTL4] LANGUAGE 'Neutral',
[DV_VSTL5] LANGUAGE 'Neutral',
[DV_VSTL6] LANGUAGE 'Neutral',
[DV_VSTL7] LANGUAGE 'Neutral',
[DV_VSTL8] LANGUAGE 'Neutral',
[DV_VSTL9] LANGUAGE 'Neutral',
[DV_VSTL10] LANGUAGE 'Neutral',
[DV_VSTL11] LANGUAGE 'Neutral',
[DV_VSTL12] LANGUAGE 'Neutral',
[DV_VSTL13] LANGUAGE 'Neutral',
[DV_VSTL14] LANGUAGE 'Neutral',
[DV_VSTL15] LANGUAGE 'Neutral',
[DV_VSTL16] LANGUAGE 'Neutral',
[DV_VSTL17] LANGUAGE 'Neutral',
[DV_VSTL18] LANGUAGE 'Neutral',
[DV_VSTL19] LANGUAGE 'Neutral',
[DV_VSTL20] LANGUAGE 'Neutral',
[DV_VSTL21] LANGUAGE 'Neutral',
[DV_VSTL22] LANGUAGE 'Neutral',
[DV_VSTL23] LANGUAGE 'Neutral',
[DV_VSTL24] LANGUAGE 'Neutral',
[DV_VSTL25] LANGUAGE 'Neutral',
[DV_VSTL26] LANGUAGE 'Neutral',
[DV_VSTL27] LANGUAGE 'Neutral',
[DV_VSTL28] LANGUAGE 'Neutral',
[DV_VSTL29] LANGUAGE 'Neutral',
[DV_VSTL30] LANGUAGE 'Neutral',
[DV_VSTL31] LANGUAGE 'Neutral',
[DV_VSTL32] LANGUAGE 'Neutral',
[DV_VSTL33] LANGUAGE 'Neutral',
[DV_VSTL34] LANGUAGE 'Neutral',
[DV_VSTL35] LANGUAGE 'Neutral',
[DV_VSTH1] LANGUAGE 'Neutral',
[DV_VSTH2] LANGUAGE 'Neutral',
[DV_VSTH3] LANGUAGE 'Neutral',
[DV_VSTH4] LANGUAGE 'Neutral')
KEY INDEX [PK_DOKVAR]ON ([PROCAD], FILEGROUP [PRIMARY])
WITH (CHANGE_TRACKING = AUTO, STOPLIST = SYSTEM)

GO
CREATE FULLTEXT INDEX ON [DOKVAR1](
[D1_VSTL36] LANGUAGE 'Neutral',
[D1_VSTL37] LANGUAGE 'Neutral',
[D1_VSTL38] LANGUAGE 'Neutral',
[D1_VSTL39] LANGUAGE 'Neutral',
[D1_VSTL40] LANGUAGE 'Neutral',
[D1_VSTL41] LANGUAGE 'Neutral',
[D1_VSTL42] LANGUAGE 'Neutral',
[D1_VSTL43] LANGUAGE 'Neutral',
[D1_VSTL44] LANGUAGE 'Neutral',
[D1_VSTL45] LANGUAGE 'Neutral',
[D1_VSTL46] LANGUAGE 'Neutral',
[D1_VSTL47] LANGUAGE 'Neutral',
[D1_VSTL48] LANGUAGE 'Neutral',
[D1_VSTL49] LANGUAGE 'Neutral',
[D1_VSTL50] LANGUAGE 'Neutral',
[D1_VSTH5] LANGUAGE 'Neutral',
[D1_VSTH6] LANGUAGE 'Neutral',
[D1_VSTH7] LANGUAGE 'Neutral',
[D1_VSTH8] LANGUAGE 'Neutral',
[D1_VSTH9] LANGUAGE 'Neutral',
[D1_VSTH10] LANGUAGE 'Neutral',
[D1_VSTH11] LANGUAGE 'Neutral',
[D1_VSTH12] LANGUAGE 'Neutral',
[D1_VSTH13] LANGUAGE 'Neutral',
[D1_VSTH14] LANGUAGE 'Neutral',
[D1_VSTH15] LANGUAGE 'Neutral',
[D1_VSTH16] LANGUAGE 'Neutral',
[D1_VSTH17] LANGUAGE 'Neutral',
[D1_VSTH18] LANGUAGE 'Neutral',
[D1_VSTH19] LANGUAGE 'Neutral',
[D1_VSTH20] LANGUAGE 'Neutral',
[D1_VSTH21] LANGUAGE 'Neutral',
[D1_VSTH22] LANGUAGE 'Neutral',
[D1_VSTH23] LANGUAGE 'Neutral',
[D1_VSTH24] LANGUAGE 'Neutral',
[D1_VSTH25] LANGUAGE 'Neutral',
[D1_VSTH26] LANGUAGE 'Neutral',
[D1_VSTH27] LANGUAGE 'Neutral',
[D1_VSTH28] LANGUAGE 'Neutral',
[D1_VSTH29] LANGUAGE 'Neutral',
[D1_VSTH30] LANGUAGE 'Neutral')
KEY INDEX [PK_DOKVAR1]ON ([PROCAD], FILEGROUP [PRIMARY])
WITH (CHANGE_TRACKING = AUTO, STOPLIST = SYSTEM)

GO
CREATE FULLTEXT INDEX ON [DOKVAR2](
[D2_VSTL51] LANGUAGE 'Neutral',
[D2_VSTL52] LANGUAGE 'Neutral',
[D2_VSTL53] LANGUAGE 'Neutral',
[D2_VSTL54] LANGUAGE 'Neutral',
[D2_VSTL55] LANGUAGE 'Neutral',
[D2_VSTL56] LANGUAGE 'Neutral',
[D2_VSTL57] LANGUAGE 'Neutral',
[D2_VSTL58] LANGUAGE 'Neutral',
[D2_VSTL59] LANGUAGE 'Neutral',
[D2_VSTL60] LANGUAGE 'Neutral',
[D2_VSTL61] LANGUAGE 'Neutral',
[D2_VSTL62] LANGUAGE 'Neutral',
[D2_VSTL63] LANGUAGE 'Neutral',
[D2_VSTL64] LANGUAGE 'Neutral',
[D2_VSTL65] LANGUAGE 'Neutral',
[D2_VSTL66] LANGUAGE 'Neutral',
[D2_VSTL67] LANGUAGE 'Neutral',
[D2_VSTL68] LANGUAGE 'Neutral',
[D2_VSTL69] LANGUAGE 'Neutral',
[D2_VSTL70] LANGUAGE 'Neutral',
[D2_VSTL71] LANGUAGE 'Neutral',
[D2_VSTL72] LANGUAGE 'Neutral',
[D2_VSTL73] LANGUAGE 'Neutral',
[D2_VSTL74] LANGUAGE 'Neutral',
[D2_VSTL75] LANGUAGE 'Neutral',
[D2_VSTL76] LANGUAGE 'Neutral',
[D2_VSTL77] LANGUAGE 'Neutral',
[D2_VSTL78] LANGUAGE 'Neutral',
[D2_VSTL79] LANGUAGE 'Neutral',
[D2_VSTL80] LANGUAGE 'Neutral',
[D2_VSTL81] LANGUAGE 'Neutral',
[D2_VSTL82] LANGUAGE 'Neutral',
[D2_VSTL83] LANGUAGE 'Neutral',
[D2_VSTL84] LANGUAGE 'Neutral',
[D2_VSTL85] LANGUAGE 'Neutral',
[D2_VSTL86] LANGUAGE 'Neutral',
[D2_VSTL87] LANGUAGE 'Neutral',
[D2_VSTL88] LANGUAGE 'Neutral',
[D2_VSTL89] LANGUAGE 'Neutral',
[D2_VSTL90] LANGUAGE 'Neutral')
KEY INDEX [PK_DOKVAR2]ON ([PROCAD], FILEGROUP [PRIMARY])
WITH (CHANGE_TRACKING = AUTO, STOPLIST = SYSTEM)

GO
CREATE FULLTEXT INDEX ON [EDM_MULTILINEFIELD](
[MLF_STRING] LANGUAGE 'Neutral')
KEY INDEX [PK_EDM_MULTILINEFIELD]ON ([PROCAD], FILEGROUP [PRIMARY])
WITH (CHANGE_TRACKING = AUTO, STOPLIST = SYSTEM)

GO
CREATE FULLTEXT INDEX ON [NFSTAMM](
[NFT_ANID] LANGUAGE 'Neutral', 
[NFT_ART] LANGUAGE 'Neutral', 
[NFT_BEM] LANGUAGE 'Neutral', 
[NFT_KON] LANGUAGE 'Neutral', 
[NFT_MKON] LANGUAGE 'Neutral', 
[NFT_NAM1] LANGUAGE 'Neutral', 
[NFT_NAM2] LANGUAGE 'Neutral', 
[NFT_STH0] LANGUAGE 'Neutral', 
[NFT_STH1] LANGUAGE 'Neutral', 
[NFT_STH10] LANGUAGE 'Neutral', 
[NFT_STH11] LANGUAGE 'Neutral', 
[NFT_STH12] LANGUAGE 'Neutral', 
[NFT_STH13] LANGUAGE 'Neutral', 
[NFT_STH14] LANGUAGE 'Neutral', 
[NFT_STH15] LANGUAGE 'Neutral', 
[NFT_STH16] LANGUAGE 'Neutral', 
[NFT_STH17] LANGUAGE 'Neutral', 
[NFT_STH18] LANGUAGE 'Neutral', 
[NFT_STH19] LANGUAGE 'Neutral', 
[NFT_STH2] LANGUAGE 'Neutral', 
[NFT_STH20] LANGUAGE 'Neutral', 
[NFT_STH21] LANGUAGE 'Neutral', 
[NFT_STH22] LANGUAGE 'Neutral', 
[NFT_STH23] LANGUAGE 'Neutral', 
[NFT_STH24] LANGUAGE 'Neutral', 
[NFT_STH25] LANGUAGE 'Neutral', 
[NFT_STH26] LANGUAGE 'Neutral', 
[NFT_STH27] LANGUAGE 'Neutral', 
[NFT_STH28] LANGUAGE 'Neutral', 
[NFT_STH29] LANGUAGE 'Neutral', 
[NFT_STH3] LANGUAGE 'Neutral', 
[NFT_STH4] LANGUAGE 'Neutral', 
[NFT_STH5] LANGUAGE 'Neutral', 
[NFT_STH6] LANGUAGE 'Neutral', 
[NFT_STH7] LANGUAGE 'Neutral', 
[NFT_STH8] LANGUAGE 'Neutral', 
[NFT_STH9] LANGUAGE 'Neutral', 
[NFT_STK0] LANGUAGE 'Neutral', 
[NFT_STK1] LANGUAGE 'Neutral', 
[NFT_STK2] LANGUAGE 'Neutral', 
[NFT_STK3] LANGUAGE 'Neutral', 
[NFT_STK4] LANGUAGE 'Neutral', 
[NFT_STK5] LANGUAGE 'Neutral', 
[NFT_STK6] LANGUAGE 'Neutral', 
[NFT_STK7] LANGUAGE 'Neutral', 
[NFT_STK8] LANGUAGE 'Neutral', 
[NFT_STK9] LANGUAGE 'Neutral', 
[NFT_STL0] LANGUAGE 'Neutral', 
[NFT_STL1] LANGUAGE 'Neutral', 
[NFT_STL10] LANGUAGE 'Neutral', 
[NFT_STL11] LANGUAGE 'Neutral', 
[NFT_STL12] LANGUAGE 'Neutral', 
[NFT_STL13] LANGUAGE 'Neutral', 
[NFT_STL14] LANGUAGE 'Neutral', 
[NFT_STL15] LANGUAGE 'Neutral', 
[NFT_STL16] LANGUAGE 'Neutral', 
[NFT_STL17] LANGUAGE 'Neutral', 
[NFT_STL18] LANGUAGE 'Neutral', 
[NFT_STL19] LANGUAGE 'Neutral', 
[NFT_STL2] LANGUAGE 'Neutral', 
[NFT_STL20] LANGUAGE 'Neutral', 
[NFT_STL21] LANGUAGE 'Neutral', 
[NFT_STL22] LANGUAGE 'Neutral', 
[NFT_STL23] LANGUAGE 'Neutral', 
[NFT_STL24] LANGUAGE 'Neutral', 
[NFT_STL25] LANGUAGE 'Neutral', 
[NFT_STL26] LANGUAGE 'Neutral', 
[NFT_STL27] LANGUAGE 'Neutral', 
[NFT_STL28] LANGUAGE 'Neutral', 
[NFT_STL29] LANGUAGE 'Neutral', 
[NFT_STL3] LANGUAGE 'Neutral', 
[NFT_STL30] LANGUAGE 'Neutral', 
[NFT_STL31] LANGUAGE 'Neutral', 
[NFT_STL32] LANGUAGE 'Neutral', 
[NFT_STL33] LANGUAGE 'Neutral', 
[NFT_STL34] LANGUAGE 'Neutral', 
[NFT_STL35] LANGUAGE 'Neutral', 
[NFT_STL36] LANGUAGE 'Neutral', 
[NFT_STL37] LANGUAGE 'Neutral', 
[NFT_STL38] LANGUAGE 'Neutral', 
[NFT_STL39] LANGUAGE 'Neutral', 
[NFT_STL4] LANGUAGE 'Neutral', 
[NFT_STL40] LANGUAGE 'Neutral', 
[NFT_STL41] LANGUAGE 'Neutral', 
[NFT_STL42] LANGUAGE 'Neutral', 
[NFT_STL43] LANGUAGE 'Neutral', 
[NFT_STL44] LANGUAGE 'Neutral', 
[NFT_STL45] LANGUAGE 'Neutral', 
[NFT_STL46] LANGUAGE 'Neutral', 
[NFT_STL47] LANGUAGE 'Neutral', 
[NFT_STL48] LANGUAGE 'Neutral', 
[NFT_STL49] LANGUAGE 'Neutral', 
[NFT_STL5] LANGUAGE 'Neutral', 
[NFT_STL50] LANGUAGE 'Neutral', 
[NFT_STL51] LANGUAGE 'Neutral', 
[NFT_STL52] LANGUAGE 'Neutral', 
[NFT_STL53] LANGUAGE 'Neutral', 
[NFT_STL54] LANGUAGE 'Neutral', 
[NFT_STL55] LANGUAGE 'Neutral', 
[NFT_STL56] LANGUAGE 'Neutral', 
[NFT_STL57] LANGUAGE 'Neutral', 
[NFT_STL58] LANGUAGE 'Neutral', 
[NFT_STL59] LANGUAGE 'Neutral', 
[NFT_STL6] LANGUAGE 'Neutral', 
[NFT_STL7] LANGUAGE 'Neutral', 
[NFT_STL8] LANGUAGE 'Neutral', 
[NFT_STL9] LANGUAGE 'Neutral', 
[NFT_VERW_STL1] LANGUAGE 'Neutral', 
[NFT_VERW_STL2] LANGUAGE 'Neutral', 
[NFT_VERW_STL3] LANGUAGE 'Neutral', 
[NFT_VERW_STL4] LANGUAGE 'Neutral', 
[NFT_VERW_STL5] LANGUAGE 'Neutral')
KEY INDEX [PK_NFSTAMM]ON ([PROCAD], FILEGROUP [PRIMARY])
WITH (CHANGE_TRACKING = AUTO, STOPLIST = SYSTEM)

GO
CREATE FULLTEXT INDEX ON [NVSTAMM](
[NVT_STL0] LANGUAGE 'Neutral', 
[NVT_STL1] LANGUAGE 'Neutral', 
[NVT_STL2] LANGUAGE 'Neutral', 
[NVT_STL3] LANGUAGE 'Neutral', 
[NVT_STL4] LANGUAGE 'Neutral')
KEY INDEX [PK_NVSTAMM]ON ([PROCAD], FILEGROUP [PRIMARY])
WITH (CHANGE_TRACKING = AUTO, STOPLIST = SYSTEM)

GO
CREATE FULLTEXT INDEX ON [PROJEKT](
[PJ_BESCHR0] LANGUAGE 'Neutral', 
[PJ_BESCHR1] LANGUAGE 'Neutral', 
[PJ_BESCHR10] LANGUAGE 'Neutral', 
[PJ_BESCHR11] LANGUAGE 'Neutral', 
[PJ_BESCHR12] LANGUAGE 'Neutral', 
[PJ_BESCHR13] LANGUAGE 'Neutral', 
[PJ_BESCHR14] LANGUAGE 'Neutral', 
[PJ_BESCHR15] LANGUAGE 'Neutral', 
[PJ_BESCHR16] LANGUAGE 'Neutral', 
[PJ_BESCHR17] LANGUAGE 'Neutral', 
[PJ_BESCHR18] LANGUAGE 'Neutral', 
[PJ_BESCHR19] LANGUAGE 'Neutral', 
[PJ_BESCHR2] LANGUAGE 'Neutral', 
[PJ_BESCHR20] LANGUAGE 'Neutral', 
[PJ_BESCHR21] LANGUAGE 'Neutral', 
[PJ_BESCHR22] LANGUAGE 'Neutral', 
[PJ_BESCHR23] LANGUAGE 'Neutral', 
[PJ_BESCHR24] LANGUAGE 'Neutral', 
[PJ_BESCHR25] LANGUAGE 'Neutral', 
[PJ_BESCHR26] LANGUAGE 'Neutral', 
[PJ_BESCHR27] LANGUAGE 'Neutral', 
[PJ_BESCHR28] LANGUAGE 'Neutral', 
[PJ_BESCHR29] LANGUAGE 'Neutral', 
[PJ_BESCHR3] LANGUAGE 'Neutral', 
[PJ_BESCHR4] LANGUAGE 'Neutral', 
[PJ_BESCHR5] LANGUAGE 'Neutral', 
[PJ_BESCHR6] LANGUAGE 'Neutral', 
[PJ_BESCHR7] LANGUAGE 'Neutral', 
[PJ_BESCHR8] LANGUAGE 'Neutral', 
[PJ_BESCHR9] LANGUAGE 'Neutral', 
[PJ_ERSTL] LANGUAGE 'Neutral', 
[PJ_MODIF] LANGUAGE 'Neutral', 
[PJ_NAME] LANGUAGE 'Neutral', 
[PJ_STH0] LANGUAGE 'Neutral', 
[PJ_STH1] LANGUAGE 'Neutral', 
[PJ_STH10] LANGUAGE 'Neutral', 
[PJ_STH11] LANGUAGE 'Neutral', 
[PJ_STH12] LANGUAGE 'Neutral', 
[PJ_STH13] LANGUAGE 'Neutral', 
[PJ_STH14] LANGUAGE 'Neutral', 
[PJ_STH15] LANGUAGE 'Neutral', 
[PJ_STH16] LANGUAGE 'Neutral', 
[PJ_STH17] LANGUAGE 'Neutral', 
[PJ_STH18] LANGUAGE 'Neutral', 
[PJ_STH19] LANGUAGE 'Neutral', 
[PJ_STH2] LANGUAGE 'Neutral', 
[PJ_STH3] LANGUAGE 'Neutral', 
[PJ_STH4] LANGUAGE 'Neutral', 
[PJ_STH5] LANGUAGE 'Neutral', 
[PJ_STH6] LANGUAGE 'Neutral', 
[PJ_STH7] LANGUAGE 'Neutral', 
[PJ_STH8] LANGUAGE 'Neutral', 
[PJ_STH9] LANGUAGE 'Neutral', 
[PJ_WUSER] LANGUAGE 'Neutral')
KEY INDEX [PK_PROJEKT]ON ([PROCAD], FILEGROUP [PRIMARY])
WITH (CHANGE_TRACKING = AUTO, STOPLIST = SYSTEM)

GO
CREATE FULLTEXT INDEX ON [PRP_PROCESS](
[C_CREATOR] LANGUAGE 'Neutral', 
[C_DESCRIPTION] LANGUAGE 'Neutral', 
[C_FILENAME] LANGUAGE 'Neutral', 
[C_MODIFIER] LANGUAGE 'Neutral', 
[C_NAME] LANGUAGE 'Neutral', 
[C_STRING1] LANGUAGE 'Neutral', 
[C_STRING10] LANGUAGE 'Neutral', 
[C_STRING11] LANGUAGE 'Neutral', 
[C_STRING12] LANGUAGE 'Neutral', 
[C_STRING13] LANGUAGE 'Neutral', 
[C_STRING14] LANGUAGE 'Neutral', 
[C_STRING15] LANGUAGE 'Neutral', 
[C_STRING16] LANGUAGE 'Neutral', 
[C_STRING17] LANGUAGE 'Neutral', 
[C_STRING18] LANGUAGE 'Neutral', 
[C_STRING19] LANGUAGE 'Neutral', 
[C_STRING2] LANGUAGE 'Neutral', 
[C_STRING20] LANGUAGE 'Neutral', 
[C_STRING21] LANGUAGE 'Neutral', 
[C_STRING22] LANGUAGE 'Neutral', 
[C_STRING23] LANGUAGE 'Neutral', 
[C_STRING24] LANGUAGE 'Neutral', 
[C_STRING25] LANGUAGE 'Neutral', 
[C_STRING26] LANGUAGE 'Neutral', 
[C_STRING27] LANGUAGE 'Neutral', 
[C_STRING28] LANGUAGE 'Neutral', 
[C_STRING29] LANGUAGE 'Neutral', 
[C_STRING3] LANGUAGE 'Neutral', 
[C_STRING30] LANGUAGE 'Neutral', 
[C_STRING31] LANGUAGE 'Neutral', 
[C_STRING32] LANGUAGE 'Neutral', 
[C_STRING33] LANGUAGE 'Neutral', 
[C_STRING34] LANGUAGE 'Neutral', 
[C_STRING35] LANGUAGE 'Neutral', 
[C_STRING36] LANGUAGE 'Neutral', 
[C_STRING37] LANGUAGE 'Neutral', 
[C_STRING38] LANGUAGE 'Neutral', 
[C_STRING39] LANGUAGE 'Neutral', 
[C_STRING4] LANGUAGE 'Neutral', 
[C_STRING40] LANGUAGE 'Neutral', 
[C_STRING41] LANGUAGE 'Neutral', 
[C_STRING42] LANGUAGE 'Neutral', 
[C_STRING43] LANGUAGE 'Neutral', 
[C_STRING44] LANGUAGE 'Neutral', 
[C_STRING45] LANGUAGE 'Neutral', 
[C_STRING46] LANGUAGE 'Neutral', 
[C_STRING47] LANGUAGE 'Neutral', 
[C_STRING48] LANGUAGE 'Neutral', 
[C_STRING49] LANGUAGE 'Neutral', 
[C_STRING5] LANGUAGE 'Neutral', 
[C_STRING50] LANGUAGE 'Neutral', 
[C_STRING6] LANGUAGE 'Neutral', 
[C_STRING7] LANGUAGE 'Neutral', 
[C_STRING8] LANGUAGE 'Neutral', 
[C_STRING9] LANGUAGE 'Neutral')
KEY INDEX [PK_PRP_PROCESS]ON ([PROCAD], FILEGROUP [PRIMARY])
WITH (CHANGE_TRACKING = AUTO, STOPLIST = SYSTEM)

GO
CREATE FULLTEXT INDEX ON [PRT_TASK](
[C_CREATOR] LANGUAGE 'Neutral', 
[C_DESCRIPTION] LANGUAGE 'Neutral', 
[C_MODIFIER] LANGUAGE 'Neutral', 
[C_NAME] LANGUAGE 'Neutral', 
[C_NOTES] LANGUAGE 'Neutral', 
[C_STRING1] LANGUAGE 'Neutral', 
[C_STRING10] LANGUAGE 'Neutral', 
[C_STRING11] LANGUAGE 'Neutral', 
[C_STRING12] LANGUAGE 'Neutral', 
[C_STRING13] LANGUAGE 'Neutral', 
[C_STRING14] LANGUAGE 'Neutral', 
[C_STRING15] LANGUAGE 'Neutral', 
[C_STRING16] LANGUAGE 'Neutral', 
[C_STRING17] LANGUAGE 'Neutral', 
[C_STRING18] LANGUAGE 'Neutral', 
[C_STRING19] LANGUAGE 'Neutral', 
[C_STRING2] LANGUAGE 'Neutral', 
[C_STRING20] LANGUAGE 'Neutral', 
[C_STRING21] LANGUAGE 'Neutral', 
[C_STRING22] LANGUAGE 'Neutral', 
[C_STRING23] LANGUAGE 'Neutral', 
[C_STRING24] LANGUAGE 'Neutral', 
[C_STRING25] LANGUAGE 'Neutral', 
[C_STRING26] LANGUAGE 'Neutral', 
[C_STRING27] LANGUAGE 'Neutral', 
[C_STRING28] LANGUAGE 'Neutral', 
[C_STRING29] LANGUAGE 'Neutral', 
[C_STRING3] LANGUAGE 'Neutral', 
[C_STRING30] LANGUAGE 'Neutral', 
[C_STRING31] LANGUAGE 'Neutral', 
[C_STRING32] LANGUAGE 'Neutral', 
[C_STRING33] LANGUAGE 'Neutral', 
[C_STRING34] LANGUAGE 'Neutral', 
[C_STRING35] LANGUAGE 'Neutral', 
[C_STRING36] LANGUAGE 'Neutral', 
[C_STRING37] LANGUAGE 'Neutral', 
[C_STRING38] LANGUAGE 'Neutral', 
[C_STRING39] LANGUAGE 'Neutral', 
[C_STRING4] LANGUAGE 'Neutral', 
[C_STRING40] LANGUAGE 'Neutral', 
[C_STRING41] LANGUAGE 'Neutral', 
[C_STRING42] LANGUAGE 'Neutral', 
[C_STRING43] LANGUAGE 'Neutral', 
[C_STRING44] LANGUAGE 'Neutral', 
[C_STRING45] LANGUAGE 'Neutral', 
[C_STRING46] LANGUAGE 'Neutral', 
[C_STRING47] LANGUAGE 'Neutral', 
[C_STRING48] LANGUAGE 'Neutral', 
[C_STRING49] LANGUAGE 'Neutral', 
[C_STRING5] LANGUAGE 'Neutral', 
[C_STRING50] LANGUAGE 'Neutral', 
[C_STRING6] LANGUAGE 'Neutral', 
[C_STRING7] LANGUAGE 'Neutral', 
[C_STRING8] LANGUAGE 'Neutral', 
[C_STRING9] LANGUAGE 'Neutral')
KEY INDEX [PK_PRT_TASK]ON ([PROCAD], FILEGROUP [PRIMARY])
WITH (CHANGE_TRACKING = AUTO, STOPLIST = SYSTEM)

GO
CREATE FULLTEXT INDEX ON [TRANSMITTAL](
[TRAMI_BESCHR0] LANGUAGE 'Neutral', 
[TRAMI_BESCHR1] LANGUAGE 'Neutral', 
[TRAMI_BESCHR10] LANGUAGE 'Neutral', 
[TRAMI_BESCHR11] LANGUAGE 'Neutral', 
[TRAMI_BESCHR12] LANGUAGE 'Neutral', 
[TRAMI_BESCHR13] LANGUAGE 'Neutral', 
[TRAMI_BESCHR14] LANGUAGE 'Neutral', 
[TRAMI_BESCHR15] LANGUAGE 'Neutral', 
[TRAMI_BESCHR16] LANGUAGE 'Neutral', 
[TRAMI_BESCHR17] LANGUAGE 'Neutral', 
[TRAMI_BESCHR18] LANGUAGE 'Neutral', 
[TRAMI_BESCHR19] LANGUAGE 'Neutral', 
[TRAMI_BESCHR2] LANGUAGE 'Neutral', 
[TRAMI_BESCHR3] LANGUAGE 'Neutral', 
[TRAMI_BESCHR4] LANGUAGE 'Neutral', 
[TRAMI_BESCHR5] LANGUAGE 'Neutral', 
[TRAMI_BESCHR6] LANGUAGE 'Neutral', 
[TRAMI_BESCHR7] LANGUAGE 'Neutral', 
[TRAMI_BESCHR8] LANGUAGE 'Neutral', 
[TRAMI_BESCHR9] LANGUAGE 'Neutral', 
[TRAMI_BESCHRL0] LANGUAGE 'Neutral', 
[TRAMI_BESCHRL1] LANGUAGE 'Neutral', 
[TRAMI_BESCHRL2] LANGUAGE 'Neutral', 
[TRAMI_BESCHRL3] LANGUAGE 'Neutral', 
[TRAMI_BESCHRL4] LANGUAGE 'Neutral', 
[TRAMI_CTAG0] LANGUAGE 'Neutral', 
[TRAMI_CTAG1] LANGUAGE 'Neutral', 
[TRAMI_CTAG2] LANGUAGE 'Neutral', 
[TRAMI_CTAG3] LANGUAGE 'Neutral', 
[TRAMI_DNAME] LANGUAGE 'Neutral', 
[TRAMI_ERSTL] LANGUAGE 'Neutral', 
[TRAMI_EXTERNAL] LANGUAGE 'Neutral', 
[TRAMI_INTERNAL] LANGUAGE 'Neutral', 
[TRAMI_MODIF] LANGUAGE 'Neutral', 
[TRAMI_NAME] LANGUAGE 'Neutral')
KEY INDEX [PK_TRANSMITTAL]ON ([PROCAD], FILEGROUP [PRIMARY])
WITH (CHANGE_TRACKING = AUTO, STOPLIST = SYSTEM)

GO

CREATE FULLTEXT INDEX ON [dbo].[SMA_FOLDER](
[C_CREATEDBY] LANGUAGE [Neutral], 
[C_DESCRIPTION] LANGUAGE [Neutral], 
[C_MODIFIEDBY] LANGUAGE [Neutral], 
[C_NAME] LANGUAGE [Neutral], 
[C_STRING1] LANGUAGE [Neutral], 
[C_STRING10] LANGUAGE [Neutral], 
[C_STRING11] LANGUAGE [Neutral], 
[C_STRING12] LANGUAGE [Neutral], 
[C_STRING13] LANGUAGE [Neutral], 
[C_STRING14] LANGUAGE [Neutral], 
[C_STRING15] LANGUAGE [Neutral], 
[C_STRING16] LANGUAGE [Neutral], 
[C_STRING17] LANGUAGE [Neutral], 
[C_STRING18] LANGUAGE [Neutral], 
[C_STRING19] LANGUAGE [Neutral], 
[C_STRING2] LANGUAGE [Neutral], 
[C_STRING20] LANGUAGE [Neutral], 
[C_STRING21] LANGUAGE [Neutral], 
[C_STRING22] LANGUAGE [Neutral], 
[C_STRING23] LANGUAGE [Neutral], 
[C_STRING24] LANGUAGE [Neutral], 
[C_STRING25] LANGUAGE [Neutral], 
[C_STRING26] LANGUAGE [Neutral], 
[C_STRING27] LANGUAGE [Neutral], 
[C_STRING28] LANGUAGE [Neutral], 
[C_STRING29] LANGUAGE [Neutral], 
[C_STRING3] LANGUAGE [Neutral], 
[C_STRING30] LANGUAGE [Neutral], 
[C_STRING31] LANGUAGE [Neutral], 
[C_STRING32] LANGUAGE [Neutral], 
[C_STRING33] LANGUAGE [Neutral], 
[C_STRING34] LANGUAGE [Neutral], 
[C_STRING35] LANGUAGE [Neutral], 
[C_STRING36] LANGUAGE [Neutral], 
[C_STRING37] LANGUAGE [Neutral], 
[C_STRING38] LANGUAGE [Neutral], 
[C_STRING39] LANGUAGE [Neutral],
[C_STRING4] LANGUAGE [Neutral], 
[C_STRING40] LANGUAGE [Neutral], 
[C_STRING5] LANGUAGE [Neutral], 
[C_STRING6] LANGUAGE [Neutral], 
[C_STRING7] LANGUAGE [Neutral], 
[C_STRING8] LANGUAGE [Neutral], 
[C_STRING9] LANGUAGE [Neutral])
KEY INDEX [PK_SMA_FOLDER]ON ([PROCAD], FILEGROUP [PRIMARY])
WITH (CHANGE_TRACKING = AUTO, STOPLIST = SYSTEM)

GO