Andrew7234/consolidate migrations

[Andrew7234]

Consolidates our rather long list of migrations from ~32 -> 5. Although this PR is intended to be deployed on a fresh database, operators can redeploy with this version and then manually update their existing deployments by going into the db and running update schema_migrations set version = 5. This will allow future migrations (which will now start at 06_... to properly apply to the database.

Functionally, this PR is mostly a no-op, with two exceptions:

• chain.blocks.metadata was removed because it was not being used. It was likely an artifact from years ago.
• There was a missing permission for the new history.staking_events table; it has been granted properly as of this PR.

Validation:
Comparison of the dumped database schema (using pg_dump -s) for main branch / feature branch:

> diff main.sql new.sql

Explanation: chain.blocks.metadata was removed; gas_limit, size_limit, and epoch were reordered.
354a355,357
>     gas_limit public.uint_numeric DEFAULT 0 NOT NULL,
>     size_limit public.uint_numeric DEFAULT 0 NOT NULL,
>     epoch public.uint63 DEFAULT 0 NOT NULL,
358,361d360
<     metadata jsonb,
<     gas_limit public.uint_numeric DEFAULT 0 NOT NULL,
<     epoch public.uint63 DEFAULT 0 NOT NULL,
<     size_limit public.uint_numeric DEFAULT 0 NOT NULL,

Explanation: reordering of columns
638a638,639
>     title text,
>     description text,
649,651c650
<     invalid_votes public.uint_numeric DEFAULT 0 NOT NULL,
<     title text,
<     description text
---
>     invalid_votes public.uint_numeric DEFAULT 0 NOT NULL
806a806,808
>     fee_symbol text DEFAULT ''::text NOT NULL,
>     fee_proxy_module text,
>     fee_proxy_id bytea,
813a816
>     amount_symbol text,
821a825,830
>     oasis_encrypted_format public.call_format,
>     oasis_encrypted_public_key bytea,
>     oasis_encrypted_data_nonce bytea,
>     oasis_encrypted_data_data bytea,
>     oasis_encrypted_result_nonce bytea,
>     oasis_encrypted_result_data bytea,
829,838d837
<     amount_symbol text,
<     fee_symbol text DEFAULT ''::text NOT NULL,
<     fee_proxy_module text,
<     fee_proxy_id bytea,
<     oasis_encrypted_format public.call_format,
<     oasis_encrypted_public_key bytea,
<     oasis_encrypted_data_nonce bytea,
<     oasis_encrypted_data_data bytea,
<     oasis_encrypted_result_nonce bytea,
<     oasis_encrypted_result_data bytea,

Explanation: chain.transactions.body column was reordered.
889a889
>     body jsonb,
892,893c892
<     message text,
<     body jsonb
---
>     message text

Explanation: A previous migration (`20_consensus_debonding_delegations...`) created a new `chain.debonding_delegations_new` table which was populated and then renamed to `chain.debonding_delegations` to replace the old table of the same name. The rename did not apply to the constraints, which kept the `_new` suffix in their names. After this PR, the constraints now reflect the table name since the rename migration no longer occurs.
1162c1161
< -- Name: debonding_delegations debonding_delegations_new_pkey; Type: CONSTRAINT; Schema: chain; Owner: rwuser
---
> -- Name: debonding_delegations debonding_delegations_pkey; Type: CONSTRAINT; Schema: chain; Owner: rwuser
1166c1165
<     ADD CONSTRAINT debonding_delegations_new_pkey PRIMARY KEY (delegatee, delegator, debond_end);
---
>     ADD CONSTRAINT debonding_delegations_pkey PRIMARY KEY (delegatee, delegator, debond_end);
1769c1768
< -- Name: debonding_delegations debonding_delegations_new_delegatee_fkey; Type: FK CONSTRAINT; Schema: chain; Owner: rwuser
---
> -- Name: debonding_delegations debonding_delegations_delegatee_fkey; Type: FK CONSTRAINT; Schema: chain; Owner: rwuser
1773c1772
<     ADD CONSTRAINT debonding_delegations_new_delegatee_fkey FOREIGN KEY (delegatee) REFERENCES chain.accounts(address) DEFERRABLE INITIALLY DEFERRED;
---
>     ADD CONSTRAINT debonding_delegations_delegatee_fkey FOREIGN KEY (delegatee) REFERENCES chain.accounts(address) DEFERRABLE INITIALLY DEFERRED;
1777c1776
< -- Name: debonding_delegations debonding_delegations_new_delegator_fkey; Type: FK CONSTRAINT; Schema: chain; Owner: rwuser
---
> -- Name: debonding_delegations debonding_delegations_delegator_fkey; Type: FK CONSTRAINT; Schema: chain; Owner: rwuser
1781c1780
<     ADD CONSTRAINT debonding_delegations_new_delegator_fkey FOREIGN KEY (delegator) REFERENCES chain.accounts(address) DEFERRABLE INITIALLY DEFERRED;
---
>     ADD CONSTRAINT debonding_delegations_delegator_fkey FOREIGN KEY (delegator) REFERENCES chain.accounts(address) DEFERRABLE INITIALLY DEFERRED;

Explanation: This wasn't granted properly before; fixed in this PR
2197a2197,2203
> -- Name: TABLE escrow_events; Type: ACL; Schema: history; Owner: rwuser
> GRANT SELECT ON TABLE history.escrow_events TO PUBLIC;
>
>
> --

[ptrus]

I should have named this index ix_transactions_method_block (as it was here in the comment).