Bug: CLI group creation does not auto-increment ID

[robere2]

In the CLI, the ID is manually set when creating groups, which causes PostgreSQL to not increment the auto-increment value for the ID column. When a user tries to insert another group, it will always fail, since the auto-increment value is still set to 1 however a group with ID 1 already exists ("Guest").

There are two possible solutions to this:

1. Do not insert the ID manually, and then assert that the IDs are correct at the end of the insert(s).
2. Insert the IDs manually and then manually update the auto-increment value afterwards.

Technically, the ID of the groups shouldn't matter, but in my opinion, we should assert that the default groups are IDs 1-3 just in case.

[robere2]

auto-increment value can be updated via:

SELECT setval('groups_id_seq', (SELECT MAX(id) FROM groups) + 1, false);

This can also be done manually until this issue is fixed.