/*Debes tener en cuenta antes de ejecutar todo el script, la longitud de las extensiones.*/

USE [Asistel]
/*Insertas en los  costos base el tipo internas*/
insert into TblBaseCost values ('Internas')
go
/* NOTA:Verificar la longitud de las extensiones.

Insertas aquí el perfil para tarificación.

*/
insert into TblPerfil values ('Internas','XXXX','4','4','TblInternas',0,'','','','','','')
go
/*NOTA:Verificar la longitud de las extensiones.

Insertas el tipo de la llamada

*/
insert into TblCallTypes values ('INT','Llamada Interna','4','4')
go
/*Se inserta el costo en cada carrier.*/

insert into TblCarrierCost values (1,21,0,0)
go
insert into TblCarrierCost values (2,21,0,0)
go
/*Se inserta la troncal previa que resultara del script.*/

insert into tblTrunks (trunk_strunk, Trunk_sDescription, Trunk_lPbxId, Trunk_lCarrierId) values ('000INT','Internas',1,0)
go

/*Aquí creamos la tabla que manejara los rangos de las extensiones.*/

/****** Object:  Table [dbo].[TblInternas]    Script Date: 07/23/2010 17:59:45 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

create TABLE [dbo].[TblInternas](
    [Internas_lId] [int] IDENTITY(1,1) NOT NULL,
    [Internas_sNir] [nvarchar](20) NOT NULL,
    [Internas_sPlace] [nvarchar](50) NOT NULL,
    [Internas_sState] [nvarchar](20) NULL,
    [Internas_sCountry] [nvarchar](20) NULL,
    [Internas_lRegionId] [int] NOT NULL,
    [Internas_lBaseCostId] [int] NOT NULL,
    [Internas_lCalltypeId] [int] NOT NULL,
    [Internas_lNumberStart] [bigint] NOT NULL,
    [Internas_lNumberEnd] [bigint] NOT NULL,
CONSTRAINT [PK_TblInternas] PRIMARY KEY CLUSTERED
(
    [Internas_lId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[TblInternas]  WITH NOCHECK ADD  CONSTRAINT [FK_TblInternas_TblBaseCost] FOREIGN KEY([Internas_lBaseCostId])
REFERENCES [dbo].[TblBaseCost] ([BaseCost_lId])
GO

ALTER TABLE [dbo].[TblInternas] CHECK CONSTRAINT [FK_TblInternas_TblBaseCost]
GO

ALTER TABLE [dbo].[TblInternas]  WITH NOCHECK ADD  CONSTRAINT [FK_TblInternas_TblCallTypes] FOREIGN KEY([Internas_lCalltypeId])
REFERENCES [dbo].[TblCallTypes] ([CallType_lId])
GO

ALTER TABLE [dbo].[TblInternas] CHECK CONSTRAINT [FK_TblInternas_TblCallTypes]
GO

ALTER TABLE [dbo].[TblInternas]  WITH NOCHECK ADD  CONSTRAINT [FK_TblInternas_tblRegion] FOREIGN KEY([Internas_lRegionId])
REFERENCES [dbo].[tblRegion] ([Region_lId])
GO

ALTER TABLE [dbo].[TblInternas] CHECK CONSTRAINT [FK_TblInternas_tblRegion]
GO

/*Insertamos los rangos de cada serie de extensiones para tarificarlas.*/

insert into TblInternas values ('1','Llamada Interna','NULL','NULL',0,21,16,'1000','1999')
insert into TblInternas values ('2','Llamada Interna','NULL','NULL',0,21,16,'2000','2999')
insert into TblInternas values ('3','Llamada Interna','NULL','NULL',0,21,16,'2000','3999')
insert into TblInternas values ('4','Llamada Interna','NULL','NULL',0,21,16,'4000','4999')
insert into TblInternas values ('5','Llamada Interna','NULL','NULL',0,21,16,'5000','5999')
insert into TblInternas values ('6','Llamada Interna','NULL','NULL',0,21,16,'6000','6999')
insert into TblInternas values ('7','Llamada Interna','NULL','NULL',0,21,16,'7000','7999')
insert into TblInternas values ('8','Llamada Interna','NULL','NULL',0,21,16,'8000','8999')
insert into TblInternas values ('9','Llamada Interna','NULL','NULL',0,21,16,'9000','9999')