aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/exchange-0002.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/exchangedb/exchange-0002.sql')
-rw-r--r--src/exchangedb/exchange-0002.sql91
1 files changed, 90 insertions, 1 deletions
diff --git a/src/exchangedb/exchange-0002.sql b/src/exchangedb/exchange-0002.sql
index 78903fb5a..267247088 100644
--- a/src/exchangedb/exchange-0002.sql
+++ b/src/exchangedb/exchange-0002.sql
@@ -20,6 +20,8 @@ BEGIN;
-- Check patch versioning is in place.
SELECT _v.register_patch('exchange-0002', NULL, NULL);
+-- Need 'failed' bit to prevent hanging transfer tool in case
+-- bank API fails.
ALTER TABLE prewire
ADD failed BOOLEAN NOT NULL DEFAULT false;
@@ -143,6 +145,93 @@ ALTER TABLE refresh_revealed_coins
ALTER TABLE refresh_revealed_coins
DROP COLUMN denom_pub_hash;
+-- Change all foreign keys involving 'coin_pub' to use known_coin_id instead.
+ALTER TABLE recoup_refresh
+ ADD COLUMN known_coin_id INT8 REFERENCES known_coins (known_coin_id) ON DELETE CASCADE;
+UPDATE recoup_refresh
+ SET known_coin_id=d.known_coin_id
+ FROM recoup_refresh o
+ INNER JOIN known_coins d USING(coin_pub);
+ALTER TABLE recoup_refresh
+ ALTER COLUMN known_coin_id SET NOT NULL;
+ALTER TABLE recoup_refresh
+ DROP COLUMN coin_pub;
+
+ALTER TABLE recoup
+ ADD COLUMN known_coin_id INT8 REFERENCES known_coins (known_coin_id) ON DELETE CASCADE;
+UPDATE recoup
+ SET known_coin_id=d.known_coin_id
+ FROM recoup o
+ INNER JOIN known_coins d USING(coin_pub);
+ALTER TABLE recoup
+ ALTER COLUMN known_coin_id SET NOT NULL;
+ALTER TABLE recoup
+ DROP COLUMN coin_pub;
+
+ALTER TABLE refresh_commitments
+ ADD COLUMN old_known_coin_id INT8 REFERENCES known_coins (known_coin_id) ON DELETE CASCADE;
+UPDATE refresh_commitments
+ SET old_known_coin_id=d.known_coin_id
+ FROM refresh_commitments o
+ INNER JOIN known_coins d ON(o.old_coin_pub=d.coin_pub);
+ALTER TABLE refresh_commitments
+ ALTER COLUMN old_known_coin_id SET NOT NULL;
+ALTER TABLE refresh_commitments
+ DROP COLUMN old_coin_pub;
+
+ALTER TABLE deposits
+ ADD COLUMN known_coin_id INT8 REFERENCES known_coins (known_coin_id) ON DELETE CASCADE;
+UPDATE deposits
+ SET known_coin_id=d.known_coin_id
+ FROM deposits o
+ INNER JOIN known_coins d USING(coin_pub);
+ALTER TABLE deposits
+ ALTER COLUMN known_coin_id SET NOT NULL;
+ALTER TABLE deposits
+ DROP COLUMN coin_pub;
+
+ALTER TABLE refunds
+ ADD COLUMN known_coin_id INT8 REFERENCES known_coins (known_coin_id) ON DELETE CASCADE;
+UPDATE refunds
+ SET known_coin_id=d.known_coin_id
+ FROM refunds o
+ INNER JOIN known_coins d USING(coin_pub);
+ALTER TABLE refunds
+ ALTER COLUMN known_coin_id SET NOT NULL;
+ALTER TABLE refunds
+ DROP COLUMN coin_pub;
+
+-- Change 'h_blind_ev' in recoup table to 'reserve_out_serial_id'
+ALTER TABLE recoup
+ ADD COLUMN reserve_out_serial_id INT8 REFERENCES reserves_out (reserve_out_serial_id) ON DELETE CASCADE;
+UPDATE recoup
+ SET reserve_out_serial_id=d.reserve_out_serial_id
+ FROM recoup o
+ INNER JOIN reserves_out d USING(h_blind_ev);
+ALTER TABLE recoup
+ ALTER COLUMN reserve_out_serial_id SET NOT NULL;
+ALTER TABLE recoup
+ DROP COLUMN h_blind_ev;
+COMMENT ON COLUMN recoup.reserve_out_serial_id
+ IS 'Identifies the h_blind_ev of the recouped coin.';
+
+
+-- Change 'h_blind_ev' in recoup_refresh table to 'rrc_serial'
+ALTER TABLE recoup_refresh
+ ADD COLUMN rrc_serial INT8 REFERENCES refresh_revealed_coins (rrc_serial) ON DELETE CASCADE;
+UPDATE recoup_refresh
+ SET rrc_serial=d.rrc_serial
+ FROM recoup_refresh o
+ INNER JOIN refresh_revealed_coins d ON (d.h_coin_ev = o.h_blind_ev);
+ALTER TABLE recoup_refresh
+ ALTER COLUMN rrc_serial SET NOT NULL;
+ALTER TABLE recoup_refresh
+ DROP COLUMN h_blind_ev;
+COMMENT ON COLUMN recoup_refresh.rrc_serial
+ IS 'Identifies the h_blind_ev of the recouped coin (as h_coin_ev).';
+
+
+-- Create additional tables...
CREATE TABLE IF NOT EXISTS auditors
(auditor_uuid BIGSERIAL UNIQUE
@@ -225,7 +314,7 @@ COMMENT ON COLUMN wire_accounts.last_change
CREATE TABLE IF NOT EXISTS signkey_revocations
(signkey_revocations_serial_id BIGSERIAL UNIQUE
- ,exchange_pub BYTEA PRIMARY KEY REFERENCES exchange_sign_keys (exchange_pub) ON DELETE CASCADE
+ ,esk_serial INT8 PRIMARY KEY REFERENCES exchange_sign_keys (esk_serial) ON DELETE CASCADE
,master_sig BYTEA NOT NULL CHECK (LENGTH(master_sig)=64)
);
COMMENT ON TABLE signkey_revocations