On Nexus 3.71.0, after the migration from OrientDB to H2 all "auto increment" columns in the H2 database have been reset to start at "1"

unique_index.sh

#!/bin/bash

NEXUS_BIN=/opt/sonatype/nexus
NEXUS_DATA=/opt/sonatype/sonatype-work/nexus3
h2sql() {
    echo "> $@" >&2
    java -cp "$NEXUS_BIN"/system/com/h2database/h2/*/h2-*.jar org.h2.tools.Shell -url jdbc:h2:"$NEXUS_DATA"/db/nexus -sql "$@"
}

schema=$(h2sql "SCRIPT NODATA")
echo "$schema" | while read line; do
    if [[ $line =~ ^CREATE\ CACHED\ TABLE\ \"PUBLIC\"\.\"([^\"]+)\" ]]; then
        tbl="${BASH_REMATCH[1]}"
    elif [[ $line =~ ^\"([^\"]+)\"\ .*\ GENERATED\ BY\ DEFAULT ]]; then
        col="${BASH_REMATCH[1]}"
        h2sql "ALTER TABLE $tbl ALTER COLUMN $col RESTART WITH SELECT max($col) + 1 FROM $tbl"
    fi
done