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 org_id=org.`dbid`
- AND `name`='hasUserGroupsWithoutFullPlus'
- AND `property_value`='true'
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement