Skip to content

Instantly share code, notes, and snippets.

@mattsimpson
Created June 10, 2015 02:01
Show Gist options
  • Save mattsimpson/cc38248220c22ff29a12 to your computer and use it in GitHub Desktop.
Save mattsimpson/cc38248220c22ff29a12 to your computer and use it in GitHub Desktop.
Enabling Panopto community module in all program websites.
INSERT INTO `community_modules` SELECT NULL, a.`community_id`, 9, 1
FROM `communities` AS a
LEFT JOIN `community_modules` AS b
ON a.`community_id` = b.`community_id`
AND b.`module_id` = '9'
WHERE a.`category_id` = '5'
AND b.`module_id` IS NULL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment