CREATE DATABASE [TeliMan]
GO
USE [TeliMan]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TeliRef](
	[ID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_TeliRef_ID]  DEFAULT (newid()),
	[CompletePhoneNumber] [varchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
	[PhoneNumber] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
	[PhoneField] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
	[Id1] [varchar](900) COLLATE Latin1_General_CI_AS NULL,
	[Id2] [varchar](900) COLLATE Latin1_General_CI_AS NULL,
	[Id3] [varchar](900) COLLATE Latin1_General_CI_AS NULL,
	[ValidRecord] [bit] NULL,
	[FirstName] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
	[LastName] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
	[Company] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
	[DBName] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
	[Type] [varchar](2555) COLLATE Latin1_General_CI_AS NULL,
	[Email] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
	[Country] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
	[ZIPCode] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
	[Street] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
	[City] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
	[Autolaunch] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
	[PictureDisplay] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
	[ExtraField] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
	
 CONSTRAINT [PK_TeliRef] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[BCIEvents](
	[ID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_BCIEvents_ID]  DEFAULT (newid()),
	[IDUser] [varchar](max) NULL,
	[Datum] [datetime] NULL,	
	[Callingid] [varchar](50) NULL,
	[Calledid] [varchar](50) NULL,
	[Status] [varchar](50) NULL,
	[Cryst] [varchar](50) NULL,
	[Cpl] [varchar](50) NULL,
	[EmailSent] [bit] NULL,
 CONSTRAINT [PK_BCIEvents] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Status] ON [dbo].[BCIEvents] 
(
	[Status] 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
CREATE NONCLUSTERED INDEX [IX_EmailSent] ON [dbo].[BCIEvents] 
(
	[EmailSent] 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
CREATE TABLE [dbo].[TeliUsers](
	[IDUser] [uniqueidentifier] NOT NULL CONSTRAINT [DF_TeliUsers_IDUser]  DEFAULT (newid()),
	[LineName] [varchar](50) NULL,
	[UserName] [varchar](50) NULL,
	[PhoneNumber] [varchar](50) NULL,
	[Email] [varchar](50) NULL,
 CONSTRAINT [PK_TeliUsers] PRIMARY KEY CLUSTERED 
(
	[IDUser] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [IX_TeliUsers] ON [dbo].[TeliUsers] 
(
	[PhoneNumber] 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:  Table [dbo].[Protocol]    Script Date: 09/18/2008 13:41:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Protocol](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[hCall] [bigint] NULL,
	[Benutzer] [varchar](80) NULL,
	[Line] [varchar](50) NULL,
	[MasterLine] [varchar](50) NULL,
	[Origin] [bigint] NULL,
	[Telefonnummer] [varchar](50) NULL,
	[CompletePhoneNumber] [varchar](50) NULL,
	[CalledID] [varchar](50) NULL,
	[TimeStart] [numeric](18, 10) NOT NULL CONSTRAINT [DF_Protocol_TimeStart]  DEFAULT ((0)),
	[TimeConnect] [numeric](18, 10) NOT NULL CONSTRAINT [DF_Protocol_TimeConnect]  DEFAULT ((0)),
	[TimeEnd] [numeric](18, 10) NOT NULL CONSTRAINT [DF_Protocol_TimeEnd]  DEFAULT ((0)),
	[Start] [varchar](20) NULL,
	[Connect] [varchar](20) NULL,
	[End] [varchar](20) NULL,
	[Status] [bigint] NOT NULL CONSTRAINT [DF_Protocol_Status]  DEFAULT ((0)),
	[Duration] [bigint] NOT NULL CONSTRAINT [DF_Protocol_Duration]  DEFAULT ((0)),
	[Provider] [varchar](50) NULL,
	[Price] [numeric](18, 10) NOT NULL CONSTRAINT [DF_Protocol_Price]  DEFAULT ((0)),
	[Percent] [numeric](18, 10) NOT NULL CONSTRAINT [DF_Protocol_Percent]  DEFAULT ((0)),
	[UserOnline] [smallint] NOT NULL CONSTRAINT [DF_Protocol_UserOnline]  DEFAULT ((0)),
	[Abgeholt] [smallint] NOT NULL CONSTRAINT [DF_Protocol_Abgeholt]  DEFAULT ((0)),
	[CPhoneNumber] [varchar](50) NULL,
	[Outgoing] [smallint] NOT NULL CONSTRAINT [DF_Protocol_Outgoing]  DEFAULT ((0)),
	[CallType] [varchar](50) NULL,
	[RedirectingID] [varchar](50) NULL,
	[RedirectionID] [varchar](50) NULL,
	[Show] [smallint] NOT NULL CONSTRAINT [DF_Protocol_Show]  DEFAULT ((0)),
	[Name1] [varchar](255) NULL,
	[Name2] [varchar](255) NULL,
	[Company] [varchar](255) NULL,
	[LastChange] [numeric](18, 10) NOT NULL CONSTRAINT [DF_Protocol_LastChange]  DEFAULT (CONVERT([numeric](18,10),getdate(),(0))),
	[UserGroupID] [int] NOT NULL CONSTRAINT [DF_Protocol_UserGroupID]  DEFAULT ((0)),
	[Marked] [smallint] NOT NULL CONSTRAINT [DF_Protocol_Marked]  DEFAULT ((0)),
	[Email] [varchar](255) NULL,
	[ExtraField] [varchar](50) NULL,
	[RedirectChecked] [smallint] NOT NULL CONSTRAINT [DF_Protocol_RedirectChecked]  DEFAULT ((0)),
	[Redirected] [smallint] NOT NULL CONSTRAINT [DF_Protocol_Redirected]  DEFAULT ((0)),
	[Picked] [smallint] NOT NULL CONSTRAINT [DF_Protocol_Picked]  DEFAULT ((0)),
	[RedDestLine] [varchar](30) NULL,
	[RedDestRecId] [bigint] NOT NULL CONSTRAINT [DF_Protocol_RedDestRecId]  DEFAULT ((0)),
	[CallBackHoursRange] [real] NOT NULL CONSTRAINT [DF_Protocol_CallBackHoursRange]  DEFAULT ((0)),
	[CallBackFoundOutgoing] [smallint] NOT NULL CONSTRAINT [DF_Protocol_CallBackFoundOutgoing]  DEFAULT ((0)),
	[CallBackFoundRecId] [bigint] NOT NULL CONSTRAINT [DF_Protocol_CallBackFoundRecId]  DEFAULT ((0)),
 CONSTRAINT [PK_Protocol] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Index [IX_Duration]    Script Date: 09/03/2008 09:57:32 ******/
CREATE NONCLUSTERED INDEX [IX_Duration] ON [dbo].[Protocol] 
(
	[Duration] 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_Line]    Script Date: 09/03/2008 09:58:04 ******/
CREATE NONCLUSTERED INDEX [IX_Line] ON [dbo].[Protocol] 
(
	[Line] 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_Telefonnummer]    Script Date: 09/03/2008 09:58:37 ******/
CREATE NONCLUSTERED INDEX [IX_Telefonnummer] ON [dbo].[Protocol] 
(
	[Telefonnummer] 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_TimeStart]    Script Date: 09/03/2008 09:59:07 ******/
CREATE NONCLUSTERED INDEX [IX_TimeStart] ON [dbo].[Protocol] 
(
	[TimeStart] 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_LastChange]    Script Date: 09/08/2008 14:16:58 ******/
CREATE NONCLUSTERED INDEX [IX_LastChange] ON [dbo].[Protocol] 
(
	[LastChange] 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_Marked]    Script Date: 09/08/2008 14:17:59 ******/
CREATE NONCLUSTERED INDEX [IX_Marked] ON [dbo].[Protocol] 
(
	[Marked] 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_CompletePhoneNumber]    Script Date: 09/22/2008 13:37:00 ******/
CREATE NONCLUSTERED INDEX [IX_CompletePhoneNumber] ON [dbo].[Protocol] 
(
	[CompletePhoneNumber] 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_UserGroupID]    Script Date: 09/26/2008 09:40:06 ******/
CREATE NONCLUSTERED INDEX [IX_UserGroupID] ON [dbo].[Protocol] 
(
	[UserGroupID] 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_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]
GO
/****** Object:  Index [IX_CompletePhoneNumber]    Script Date: 09/10/2008 09:52:12 ******/
CREATE NONCLUSTERED INDEX [IX_CompletePhoneNumber] ON [dbo].[TeliRef] 
(
	[CompletePhoneNumber] 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_PhoneNumber]    Script Date: 09/10/2008 09:52:38 ******/
CREATE NONCLUSTERED INDEX [IX_PhoneNumber] ON [dbo].[TeliRef] 
(
	[PhoneNumber] 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_Id1]    Script Date: 09/10/2008 09:53:01 ******/
CREATE NONCLUSTERED INDEX [IX_Id1] ON [dbo].[TeliRef] 
(
	[Id1] 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_Id2]    Script Date: 09/10/2008 09:53:12 ******/
CREATE NONCLUSTERED INDEX [IX_Id2] ON [dbo].[TeliRef] 
(
	[Id2] 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_Id3]    Script Date: 09/10/2008 09:53:25 ******/
CREATE NONCLUSTERED INDEX [IX_Id3] ON [dbo].[TeliRef] 
(
	[Id3] 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_FirstName]    Script Date: 09/10/2008 09:53:46 ******/
CREATE NONCLUSTERED INDEX [IX_FirstName] ON [dbo].[TeliRef] 
(
	[FirstName] 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_LastName]    Script Date: 09/10/2008 09:54:02 ******/
CREATE NONCLUSTERED INDEX [IX_LastName] ON [dbo].[TeliRef] 
(
	[LastName] 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_Company]    Script Date: 09/10/2008 09:54:20 ******/
CREATE NONCLUSTERED INDEX [IX_Company] ON [dbo].[TeliRef] 
(
	[Company] 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
GRANT CREATE TABLE TO [TeliMan]
GO
GRANT DELETE TO [TeliMan]
GO
GRANT EXECUTE TO [TeliMan]
GO
GRANT INSERT TO [TeliMan]
GO
GRANT SELECT TO [TeliMan]
GO
GRANT UPDATE TO [TeliMan]
GO
USE [TeliMan]
GO
