how to use auto increment in H2 DATABASE FILE code example
Example: h2 auto increment and unique
drop table test;
create table test(id bigint auto_increment, name varchar(255));
insert into test(name) values('hello');
insert into test(name) values('world');
select * from test;