Reindex Erupe Guild

ErupeReindexGuild.sql

do
$$
declare guild_to_resort integer := <guild id>;

declare f record;
declare i integer := 2;
declare char_id integer;
begin
	for f in select gc.id 
		from public.guild_characters gc
		join public.guilds g on g.id = gc.guild_id
		where gc.guild_id = guild_to_resort
		and gc.id != g.leader_id
	loop
	update public.guild_characters gc
	set order_index = i
	where id = f.id;
	i = i + 1;
	end loop;
	update public.guild_characters gc
	set order_index = 1
	where id = (select leader_id from guilds where id = guild_to_resort);
end;
$$