UPDATE  Sys_ObjetosApp SET IndObj = (IndObj + 1) where IdGrupo = 'TESDOC' AND SubModulo ='TES' and IndObj > 20
GO
INSERT INTO dbo.Sys_ObjetosApp (IdObj, IdGrupo,	SubModulo, IndObj, Nombre, Formulario, Permisos, NivelMinimo, NomArchivo)
VALUES
('FRMNOVRESV','TESDOC','TES',21,'Novedades de Reservas (Vehículos)','FRMDNVRTEV','S',0,NULL)
GO
ALTER TABLE dbo.Trn_TraEspConceptos   
DROP CONSTRAINT PK_Trn_TraEspConceptos;   
GO
ALTER TABLE dbo.Trn_TraEspConceptos ADD
IdVehiculo VARCHAR(10) NOT NULL DEFAULT '0'
GO
ALTER TABLE dbo.Trn_TraEspConceptos
ALTER COLUMN Cliente BIT NOT NULL
GO
ALTER TABLE dbo.Trn_TraEspConceptos
ALTER COLUMN Conductor BIT NOT NULL
GO
ALTER TABLE dbo.Trn_TraEspConceptos
ALTER COLUMN vehiculo BIT NOT NULL
GO
ALTER TABLE dbo.Trn_TraEspConceptos ADD
CONSTRAINT PK_Trn_TraEspConceptos PRIMARY KEY(TipDoc,Documento,IdCia,Item,Cliente,Conductor,Vehiculo,ItemDoc)
GO
ALTER TABLE dbo.Trn_TraEspConceptos ADD
CONSTRAINT FK_Trn_TraEspConceptos_Vehiculos FOREIGN KEY(IdVehiculo)
REFERENCES dbo.Vehiculos(IdVehiculo)
GO