private void createGroup(final Connection connection,
                             final int id,
                             final String name) {
        final long now = System.currentTimeMillis();

        // Create index volume groups
//        final Map<String, Integer> groupNameToIdMap = new HashMap<>();
        final String insertSql = "" +
                "INSERT INTO index_volume_group (" +
                " id," +
                " version," +
                " create_time_ms," +
                " create_user," +
                " update_time_ms," +
                " update_user," +
                " name)" +
                " VALUES (?,?,?,?,?,?,?)";

        try (final PreparedStatement insert = connection.prepareStatement(insertSql)) {
            insert.setInt(1, id);
            insert.setInt(2, 1);
            insert.setLong(3, now);
            insert.setString(4, "migration");
            insert.setLong(5, now);
            insert.setString(6, "migration");
            insert.setString(7, name);
            insert.executeUpdate();
        } catch (final SQLException e) {
            throw new RuntimeException("Error creating index vol group with id " + id + ", name " + name +
                    ": " + e.getMessage(), e);
        }
    }
@return A map of index UUIDs to lists of the volumes they use. We'll need both, hence the map.
stroom-legacy/stroom-legacy-db-migration/src/main/java/stroom/legacy/db/migration/V07_00_00_1502__Index.java