Enable course collaboration tool

This SQL would update inactive hyperlinks to be come active:

UPDATE content_handlers
SET available_ind = 'Y'
WHERE pk1 in (
SELECT ch.pk1
FROM content_handlers ch
JOIN course_content_handlers cch
ON ch.pk1 = cch.content_handlers_pk1
--AND cch.crsmain_pk1 = 10150 -- uncomment this to restrict the update to particular course(s)
WHERE ch.available_ind = 'N'
AND ch.name IN ('resource/x-bb-vclink.name', 'resource/x-bb-chatlink.name'));


As always, one should test this on a development system (copy of production) prior to running it in production, just to be sure there are no unwanted side effects.