XenForo 2 make all users' primary group the registered group

commands.sql

UPDATE xf_user
SET secondary_group_ids = CONCAT(user_group_id, ',', secondary_group_ids)
WHERE LENGTH(secondary_group_ids) > 0
  AND user_group_id <> 2;

UPDATE xf_user
SET secondary_group_ids = user_group_id
WHERE secondary_group_ids = ''
  AND user_group_id <> 2;

UPDATE xf_user
SET user_group_id = 2;

UPDATE xf_user_group_relation
SET is_primary = 0
WHERE user_group_id <> 2;

INSERT IGNORE xf_user_group_relation (user_id, user_group_id, is_primary)
SELECT user_id, 2, 1
FROM xf_user;