Advertisement
Guest User

Untitled

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