if not exists (select 1 from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'ort_reporteTecnico' and COLUMN_NAME = 'diagnostico')
begin
	ALTER TABLE ort_reporteTecnico ADD diagnostico varchar(8000) not null default ''
end
go

if not exists (select 1 from _columnas where tabla = 'ort_reporteTecnico' and columna = 'diagnostico')
begin
	INSERT INTO [dbo].[_columnas]
           ([tabla]
           ,[columna]
           ,[mostrarEnGrilla]
           ,[ordenGrilla]
           ,[requerido]
           ,[tipo]
           ,[defecto]
           ,[tamano]
           ,[dependiente]
           ,[id_seccionAtributo]
           ,[mostrarEnAPI]
           ,[ordenEdicion])
     VALUES
           ('ort_reporteTecnico'
           ,'diagnostico'
           ,1
           ,0
           ,0
           ,'varchar'
           ,'('''')'
           ,8000
           ,NULL
           ,0
           ,1
           ,1)
end
