summaryrefslogtreecommitdiff
path: root/src/exchangedb/exchange-0002.sql
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2021-01-08 19:11:36 +0100
committerChristian Grothoff <christian@grothoff.org>2021-01-08 19:11:36 +0100
commit7ef7d793de662ae17f959f11c69ba6c4de171173 (patch)
tree6b763984a9b69dff4257b67c04e7e292a92136ab /src/exchangedb/exchange-0002.sql
parent13555448b67f41f1dad97a0116b3f82870c58cbd (diff)
downloadexchange-7ef7d793de662ae17f959f11c69ba6c4de171173.tar.gz
exchange-7ef7d793de662ae17f959f11c69ba6c4de171173.tar.bz2
exchange-7ef7d793de662ae17f959f11c69ba6c4de171173.zip
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.sql8
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