Select next available ID
## Select the next available UID
## Do not delete users from unixuid and unix gid as there id’s may get re-used
########################################
[sql]
SELECT min( r1.uid ) +1 AS next_available_uid
FROM unixuid AS r1
LEFT OUTER
JOIN unixuid AS r2 ON r2.uid = r1.uid +1
WHERE r1.uid >200
AND r2.uid IS NULL”;
[/sql]