[taler-anastasis] 04/06: remove bogus unique constraint

[gnunet]

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.