script.sql

GRANT ALL PRIVILEGES ON DATABASE rinha TO postgres;

create table "clients" ("id" serial not null primary key, "limite" integer not null, "saldo" integer not null default '0');
create table "transactions" ("id" serial not null primary key, "client_id" integer not null, "valor" integer not null, "tipo" varchar(1) not null, "descricao" varchar(10) not null, "realizad_em" varchar(255) not null);
create index "transactions_client_id_id_index" on "transactions" ("client_id", "id");
insert into "clients" ("id", "limite") values (1, 100000), (2, 80000), (3, 1000000), (4, 10000000), (5, 500000) on conflict ("id") do update set "id" = "excluded"."id", "limite" = "excluded"."limite";