USE [TeliMan]
/*Drop*/
GO
/****** Object:  Index [IX_hCall]    Script Date: 02/09/2009 10:18:20 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Protocol]') AND name = N'IX_hCall')
DROP INDEX [IX_hCall] ON [dbo].[Protocol] WITH ( ONLINE = OFF )
GO
/****** Object:  Index [IX_Origin]    Script Date: 02/09/2009 10:18:53 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Protocol]') AND name = N'IX_Origin')
DROP INDEX [IX_Origin] ON [dbo].[Protocol] WITH ( ONLINE = OFF )
GO
/****** Object:  Index [IX_TimeConnect]    Script Date: 02/09/2009 10:19:27 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Protocol]') AND name = N'IX_TimeConnect')
DROP INDEX [IX_TimeConnect] ON [dbo].[Protocol] WITH ( ONLINE = OFF )
GO
/****** Object:  Index [IX_TimeEnd]    Script Date: 02/09/2009 10:19:49 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Protocol]') AND name = N'IX_TimeEnd')
DROP INDEX [IX_TimeEnd] ON [dbo].[Protocol] WITH ( ONLINE = OFF )
GO
/****** Object:  Index [IX_Status]    Script Date: 02/09/2009 10:20:16 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Protocol]') AND name = N'IX_Status')
DROP INDEX [IX_Status] ON [dbo].[Protocol] WITH ( ONLINE = OFF )
/*Create*/
GO
/****** Object:  Index [IX_Benutzer]    Script Date: 02/09/2009 10:08:21 ******/
CREATE NONCLUSTERED INDEX [IX_Benutzer] ON [dbo].[Protocol] 
(
	[Benutzer] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_CalledID]    Script Date: 02/09/2009 10:10:16 ******/
CREATE NONCLUSTERED INDEX [IX_CalledID] ON [dbo].[Protocol] 
(
	[CalledID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_Provider]    Script Date: 02/09/2009 10:11:27 ******/
CREATE NONCLUSTERED INDEX [IX_Provider] ON [dbo].[Protocol] 
(
	[Provider] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_Abgeholt]    Script Date: 02/09/2009 10:12:26 ******/
CREATE NONCLUSTERED INDEX [IX_Abgeholt] ON [dbo].[Protocol] 
(
	[Abgeholt] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_Outgoing]    Script Date: 02/09/2009 10:13:19 ******/
CREATE NONCLUSTERED INDEX [IX_Outgoing] ON [dbo].[Protocol] 
(
	[Outgoing] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_CallType]    Script Date: 02/09/2009 10:14:13 ******/
CREATE NONCLUSTERED INDEX [IX_CallType] ON [dbo].[Protocol] 
(
	[CallType] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_RedirectingID]    Script Date: 02/09/2009 10:15:08 ******/
CREATE NONCLUSTERED INDEX [IX_RedirectingID] ON [dbo].[Protocol] 
(
	[RedirectingID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_RedirectionID]    Script Date: 02/09/2009 10:15:57 ******/
CREATE NONCLUSTERED INDEX [IX_RedirectionID] ON [dbo].[Protocol] 
(
	[RedirectionID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
