diff options
author | Cedric Zwahlen <cedric.zwahlen@students.bfh.ch> | 2024-04-16 18:54:24 +0200 |
---|---|---|
committer | Cedric Zwahlen <cedric.zwahlen@students.bfh.ch> | 2024-04-19 20:47:34 +0200 |
commit | ba725b627efe5d5a6b4131898c7ee643fce85380 (patch) | |
tree | 01aad63c0e7a12f37e026fc64d1fc8f839fda5ce /src/auditordb/0002-auditor_denomination_pending.sql | |
parent | 962bcbc6a6bd10f3bbe80766278c36b02f53c7e4 (diff) | |
download | exchange-ba725b627efe5d5a6b4131898c7ee643fce85380.tar.gz exchange-ba725b627efe5d5a6b4131898c7ee643fce85380.tar.bz2 exchange-ba725b627efe5d5a6b4131898c7ee643fce85380.zip |
Fix various CRUD bugs
Diffstat (limited to 'src/auditordb/0002-auditor_denomination_pending.sql')
-rw-r--r-- | src/auditordb/0002-auditor_denomination_pending.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/auditordb/0002-auditor_denomination_pending.sql b/src/auditordb/0002-auditor_denomination_pending.sql index c52e8c0cf..6c1239d7b 100644 --- a/src/auditordb/0002-auditor_denomination_pending.sql +++ b/src/auditordb/0002-auditor_denomination_pending.sql @@ -15,7 +15,8 @@ -- CREATE TABLE auditor_denomination_pending - (denom_pub_hash BYTEA PRIMARY KEY CHECK (LENGTH(denom_pub_hash)=64) + (row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE, + denom_pub_hash BYTEA PRIMARY KEY CHECK (LENGTH(denom_pub_hash)=64) ,denom_balance taler_amount NOT NULL ,denom_loss taler_amount NOT NULL ,num_issued INT8 NOT NULL |