Advertisement
Guest User

Untitled

a guest
Aug 14th, 2018
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.42 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(SELECT 1 FROM `_usergroups` WHERE deleted=false AND org_id=org.`dbid`)
  6. 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