
/****** Object:  Index [IX_RECH_NAME]    Script Date: 28.11.2017 15:30:44 ******/
CREATE NONCLUSTERED INDEX [IX_RECH_NAME] ON [dbo].[ABSCHLAG]
(
	[RECH_NAME] ASC,
	[VER_TYPE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO


/****** Object:  Index [IX_RECH_NAME]    Script Date: 28.11.2017 15:34:34 ******/
CREATE NONCLUSTERED INDEX [IX_RECH_NAME] ON [dbo].[HOLZINFO]
(
	[RECH_NAME] ASC,
	[VER_TYPE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO


/****** Object:  Index [IX_R_NAME]    Script Date: 28.11.2017 15:34:55 ******/
CREATE NONCLUSTERED INDEX [IX_R_NAME] ON [dbo].[HEADERRECH]
(
	[R_NAME] ASC,
	[VER_TYPE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO


/****** Object:  Index [IX_A1_NAME]    Script Date: 28.11.2017 15:37:12 ******/
CREATE NONCLUSTERED INDEX [IX_A1_NAME] ON [dbo].[LOGS_RECH]
(
	[A1_NAME] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO


/****** Object:  Index [IX_A1_NAME]    Script Date: 28.11.2017 15:37:12 ******/
CREATE NONCLUSTERED INDEX [IX_A2_NAME] ON [dbo].[LOGS_RECH]
(
	[A2_NAME] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

/****** Object:  Index [IX_R_NAME]    Script Date: 28.11.2017 15:38:38 ******/
CREATE NONCLUSTERED INDEX [IX_R_NAME] ON [dbo].[RECHNUNGSJOURNAL]
(
	[R_NAME] ASC,
	[VER_TYPE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE NONCLUSTERED INDEX [IX_R_NAME] ON [dbo].[NN_POSITIONEN]
(
	[NN_NAME] ASC,
	[VER_TYPE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)

GO


SET ANSI_PADDING ON

CREATE NONCLUSTERED INDEX [IX_NAME] ON [dbo].[MODELS]
(
	[NAME] ASC,
	[RELATION] ASC,
	[ID_USER] ASC,
	[NICHT_ANDERBAR] ASC,
	[ID_ACCESS_LEVELS] ASC
)
INCLUDE ( 	[ID]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]


