diff options
| author | Christian Grothoff <christian@grothoff.org> | 2021-01-08 19:11:36 +0100 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2021-01-08 19:11:36 +0100 |
| commit | 7ef7d793de662ae17f959f11c69ba6c4de171173 (patch) | |
| tree | 6b763984a9b69dff4257b67c04e7e292a92136ab /src/exchangedb/exchange-0002.sql | |
| parent | 13555448b67f41f1dad97a0116b3f82870c58cbd (diff) | |
use auditor_uuid instead of auditor_pub as foreign key
Diffstat (limited to 'src/exchangedb/exchange-0002.sql')
| -rw-r--r-- | src/exchangedb/exchange-0002.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/src/exchangedb/exchange-0002.sql b/src/exchangedb/exchange-0002.sql index 11564367a..78903fb5a 100644 --- a/src/exchangedb/exchange-0002.sql +++ b/src/exchangedb/exchange-0002.sql @@ -166,15 +166,15 @@ COMMENT ON COLUMN auditors.last_change CREATE TABLE IF NOT EXISTS auditor_denom_sigs (auditor_denom_serial BIGSERIAL UNIQUE - ,auditor_pub BYTEA NOT NULL REFERENCES auditors (auditor_pub) ON DELETE CASCADE + ,auditor_uuid INT8 NOT NULL REFERENCES auditors (auditor_uuid) ON DELETE CASCADE ,denominations_serial INT8 NOT NULL REFERENCES denominations (denominations_serial) ON DELETE CASCADE ,auditor_sig BYTEA CHECK (LENGTH(auditor_sig)=64) - ,PRIMARY KEY (denominations_serial, auditor_pub) + ,PRIMARY KEY (denominations_serial, auditor_uuid) ); COMMENT ON TABLE auditor_denom_sigs IS 'Table with auditor signatures on exchange denomination keys.'; -COMMENT ON COLUMN auditor_denom_sigs.auditor_pub - IS 'Public key of the auditor.'; +COMMENT ON COLUMN auditor_denom_sigs.auditor_uuid + IS 'Identifies the auditor.'; COMMENT ON COLUMN auditor_denom_sigs.denominations_serial IS 'Denomination the signature is for.'; COMMENT ON COLUMN auditor_denom_sigs.auditor_sig |