I imported my usergroups from vB and now I want to adapt the usergroups to the xF permission system. Therefor I would like to copy the primary user group ID to the secondary_group_ids field and replace the primary user group ID with 2/default. The problem is not to lose the existing secondary Ids. Is this possible with SQL?
1. query: UPDATE xf_user SET secondary_group_ids = 11 WHERE user_group_id = 11; 2. query: UPDATE xf_user SET user_group_id = 2 WHERE user_group_id = 11;
thank you - all the best,