default_groups - how to adjust.

[Bookworm]

Here's the list of web/client users from my /etc/passwd account.
The issue I'm having is that I had to manually rebuild the client list in sys_user, because apparently what's listed in the clients table is duplicated in sys_user, which was destroyed by the upgrade process. (I didn't realize that it was in sys_user because of the duplication, including passwords)

web1:x:5003:5004::/var/www/clients/client1/web1:/bin/false
web2:x:5004:5004::/var/www/clients/client1/web2:/bin/false
web3:x:5005:5005::/var/www/clients/client8/web3:/bin/false
web4:x:5006:5005::/var/www/clients/client8/web4:/bin/false
web5:x:5007:5006::/var/www/clients/client9/web5:/bin/false
web6:x:5008:5006::/var/www/clients/client9/web6:/bin/false
web7:x:5009:5007::/var/www/clients/client10/web7:/bin/false
web8:x:5010:5008::/var/www/clients/client3/web8:/bin/false
web9:x:5011:5009::/var/www/clients/client5/web9:/bin/false
web10:x:5012:5010::/var/www/clients/client4/web10:/bin/false
web11:x:5013:5011::/var/www/clients/client2/web11:/bin/false
web12:x:5014:5012::/var/www/clients/client11/web12:/bin/false
web13:x:5015:5013::/var/www/clients/client6/web13:/bin/false
web14:x:5016:5009::/var/www/clients/client5/web14:/bin/false
web15:x:5017:5009::/var/www/clients/client5/web15:/bin/false
web16:x:5018:5014::/var/www/clients/client7/web16:/bin/false
web17:x:5019:5010::/var/www/clients/client4/web17:/bin/false
web18:x:5020:5015::/var/www/clients/client12/web18:/bin/false
web19:x:5021:5015::/var/www/clients/client12/web19:/bin/false

Here's the group listing

client1:x:5004:apache
client8:x:5005:
client9:x:5006:
client10:x:5007:
client3:x:5008:
client5:x:5009:
client4:x:5010:
client2:x:5011:
client11:x:5012:
client6:x:5013:
client7:x:5014:
client12:x:5015:

Here's the issue. In '/etc/group', the groups aren't in order of the actual clients themselves. Are default_group and group in sys_user supposed to equate to the last two digits of /etc/group's location? So client11 would be group 12/default_group 12, and client2 would be group 11? Frankly, I don't understand how the 'group' listing ended up out of order. You'd think they would be created when you created clients, not when you created sites.

I have things roughly functioning, but I'd like to know if I need to adjust the sys_user table for the client groups.

[till]

Are default_group and group in sys_user supposed to equate to the last two digits of /etc/group's location?

No. The group names in /etc/group correspond to the client ID's in the client table, the sys_user table is only for the ispconfig interace and not linked to any linux users or groups.