Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO `_organization_custom_property` (`org_id`, `name`, `property_value`, `visible`)
- SELECT `dbid`, 'hasUserGroupsWithoutFullPlus', 'true', true
- FROM `_organization` AS org
- WHERE org.`license`=4
- AND EXISTS(SELECT 1 FROM `_usergroups` WHERE deleted=false AND org_id=org.`dbid`)
- AND NOT EXISTS(SELECT 1 FROM `_organization_custom_property` WHERE `name`='hasUserGroupsWithoutFullPlus' AND `property_value`='true');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement