implement an application process for one-off 1.0 payouts

[chadwhitacre]

To complement the Team application process we already have. Let's get this before the 1.0 refund announcement (#3539).

[chadwhitacre]

First pass:

[chadwhitacre]

Reopening for deployment.

[chadwhitacre]

Code deployed and all.sql started.

[chadwhitacre]

=> \i sql/1.0/all.sql
psql:sql/1.0/identify-receivers.sql:1: NOTICE:  table "receivers_1_0" does not exist, skipping
DROP TABLE
SELECT 2252
psql:sql/1.0/prep-numbers.sql:1: NOTICE:  table "numbers_1_0" does not exist, skipping
DROP TABLE
SELECT 2252
UPDATE 2
UPDATE 2252
UPDATE 2252
UPDATE 2164
UPDATE 5
UPDATE 154
UPDATE 207

[chadwhitacre]

=> select status_of_1_0_payout, count(*) from participants
group by status_of_1_0_payout order by count desc;
┌──────────────────────┬────────┐
│ status_of_1_0_payout │ count  │
├──────────────────────┼────────┤
│ completed            │ 110848 │
│ pending-application  │   1952 │
│ too-little           │    207 │
│ pending-payout       │      5 │
└──────────────────────┴────────┘
(4 rows)

[chadwhitacre]

=> select sum(balance) from participants where status_of_1_0_payout != 'completed';
┌───────────┐
│    sum    │
├───────────┤
│ 129113.10 │
└───────────┘
(1 row)

[chadwhitacre]

I think we're good!

[chadwhitacre]

=> select status_of_1_0_payout, count(*), sum(balance) from participants
group by status_of_1_0_payout order by sum desc;
┌──────────────────────┬────────┬───────────┐
│ status_of_1_0_payout │ count  │    sum    │
├──────────────────────┼────────┼───────────┤
│ pending-application  │   1952 │ 127447.47 │
│ completed            │ 110848 │  10272.68 │
│ pending-payout       │      5 │   1622.64 │
│ too-little           │    207 │     42.99 │
└──────────────────────┴────────┴───────────┘
(4 rows)