if NOT exists (select * from dbo.sysobjects where name ='SER_SERVICIOS')
BEGIN

	PRINT 'Agregando Tabla: SER_SERVICIOS'


	CREATE TABLE [dbo].[SER_SERVICIOS](
		[TIPO_SERV] [char](1) NOT NULL,
		[COD_SERV] [tinyint] NOT NULL,
		[DESCRI] [char](50) NULL,
		[GENERACC] [bit] NULL,
		[GENERACAJA] [bit] NULL,
		[TIPCARCONS] [tinyint] NULL,
		[porcAcep] [numeric](6, 3) NULL,
		[cod_comp] [char](6) NULL,
		[cod_ctacon] [char](6) NULL,
		[bCuotaUnica] [bit] NULL,
		[bGrandesConsu] [bit] NULL,
		[lCobroBanco] [bit] NULL,
	 CONSTRAINT [PK_SER_SERVICIOS] PRIMARY KEY NONCLUSTERED
	(
		[TIPO_SERV] ASC,
		[COD_SERV] 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]

END
GO

SET ANSI_PADDING OFF
GO

IF NOT EXISTS(select * from dbo.syscolumns where ID = (select ID from dbo.sysobjects where name ='SER_SERVICIOS')  AND name ='cod_comp' )
begin
	PRINT 'Nueva Columna TABLA : SER_SERVICIOS - COLUMNA : cod_comp'
	ALTER TABLE dbo.SER_SERVICIOS ADD cod_comp char(6) NULL
end