drop table if exists tint1, tint2, ttext1, ttext2;

CREATE COLLATION ignore_accent_case (provider = icu, deterministic = false, locale = 'und-u-ks-level1');

create table tint1 as
  select (-log(random())*10000)::int as x from generate_series(1,1000000);
create table tint2 as
  select (-log(random())*10000)::int as x from generate_series(1,1000000);

create table ttext1 (x text collate ignore_accent_case);
insert into ttext1
  select md5((-log(random())*10000)::int::text) as x from generate_series(1,1000000);

create table ttext2 (x text collate ignore_accent_case);
insert into ttext2
  select md5((-log(random())*10000)::int::text) as x from generate_series(1,1000000);
