[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[taler-anastasis] 04/06: remove bogus unique constraint
From: |
gnunet |
Subject: |
[taler-anastasis] 04/06: remove bogus unique constraint |
Date: |
Sat, 13 Mar 2021 19:23:26 +0100 |
This is an automated email from the git hooks/post-receive script.
grothoff pushed a commit to branch master
in repository anastasis.
commit b1adb968e8011a01ec0f723a59f9b52e8b898833
Author: Christian Grothoff <christian@grothoff.org>
AuthorDate: Sat Mar 13 18:15:02 2021 +0100
remove bogus unique constraint
---
src/backend/anastasis-httpd_truth_upload.c | 1 -
src/stasis/stasis-0001.sql | 18 +++++++++++++++++-
2 files changed, 17 insertions(+), 2 deletions(-)
diff --git a/src/backend/anastasis-httpd_truth_upload.c
b/src/backend/anastasis-httpd_truth_upload.c
index 575ff1f..dec029f 100644
--- a/src/backend/anastasis-httpd_truth_upload.c
+++ b/src/backend/anastasis-httpd_truth_upload.c
@@ -546,7 +546,6 @@ AH_handler_truth_post (
}
}
-
} /* end 'if (NULL == tuc)' */
if (NULL != tuc->resp)
diff --git a/src/stasis/stasis-0001.sql b/src/stasis/stasis-0001.sql
index 8bca886..3bea436 100644
--- a/src/stasis/stasis-0001.sql
+++ b/src/stasis/stasis-0001.sql
@@ -150,7 +150,7 @@ COMMENT ON COLUMN anastasis_recoverydocument.recovery_data
CREATE TABLE IF NOT EXISTS anastasis_challengecode
- (truth_uuid BYTEA PRIMARY KEY CHECK(LENGTH(truth_uuid)=32) NOT NULL,
+ (truth_uuid BYTEA CHECK(LENGTH(truth_uuid)=32) NOT NULL,
code INT8 NOT NULL,
creation_date INT8 NOT NULL,
expiration_date INT8 NOT NULL,
@@ -171,5 +171,21 @@ COMMENT ON COLUMN anastasis_challengecode.expiration_date
COMMENT ON COLUMN anastasis_challengecode.retry_counter
IS 'How many tries are left for this code must be > 0';
+CREATE INDEX IF NOT EXISTS anastasis_challengecode_uuid_index
+ ON anastasis_challengecode
+ (truth_uuid,expiration_date);
+
+COMMENT ON INDEX anastasis_challengecode_uuid_index
+ IS 'for challenge lookup';
+
+
+CREATE INDEX IF NOT EXISTS anastasis_challengecode_expiration_index
+ ON anastasis_challengecode
+ (uuid,expiration_date);
+
+COMMENT ON INDEX anastasis_challengecode_expiration_index
+ IS 'for challenge garbage collection';
+
+
-- Complete transaction
COMMIT;
--
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.
- [taler-anastasis] branch master updated (04827aa -> e715a2d), gnunet, 2021/03/13
- [taler-anastasis] 04/06: remove bogus unique constraint,
gnunet <=
- [taler-anastasis] 01/06: fix #6572, gnunet, 2021/03/13
- [taler-anastasis] 03/06: add long polling support for payment on challenge solving, gnunet, 2021/03/13
- [taler-anastasis] 05/06: fix index, gnunet, 2021/03/13
- [taler-anastasis] 02/06: fix #6752, gnunet, 2021/03/13
- [taler-anastasis] 06/06: fix #6748, gnunet, 2021/03/13