if not exists (select * FROM INFORMATION_SCHEMA.COLUMNS where Table_Name='doc_pendienteDocumento'  and column_name = 'id_reporteTecnico' )
begin  
ALTER TABLE [doc_pendienteDocumento] ADD [id_reporteTecnico] int NOT NULL DEFAULT 0 FOREIGN KEY (id_reporteTecnico) REFERENCES ort_reporteTecnico (id)
end

if not exists (select * FROM INFORMATION_SCHEMA.COLUMNS where Table_Name='doc_documentoComentario'  and column_name = 'id_reporteTecnico' )
begin  
ALTER TABLE [doc_documentoComentario] ADD [id_reporteTecnico] int NOT NULL DEFAULT 0 FOREIGN KEY (id_reporteTecnico) REFERENCES ort_reporteTecnico (id)
end
