Advertisement
Guest User

Untitled

a guest
Aug 14th, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.27 KB | None | 0 0
  1. INSERT INTO `_organization_custom_property` (`org_id`, `name`, `property_value`)
  2. SELECT `dbid`, 'hasUserGroupsWithoutFullPlus', 'true'
  3. FROM `_organization` AS org
  4. WHERE org.`license`=4
  5. AND EXISTS(SELECT 1 FROM `_usergroups` WHERE deleted=false AND org_id=org.`dbid`);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement