challenger

commit 53fde71916d6ab0fe02ff1ff5223363bc44e3d04
parent 2c0f25cbe7df11678fd8a1bab917b6039bb5e941
Author: Christian Grothoff <grothoff@gnunet.org>
Date:   Tue, 14 Jul 2026 19:36:54 +0200

schema hygene

Diffstat:
M
src/challengerdb/challenger-0004.sql
 | 
8
++++++++

1 file changed, 8 insertions(+), 0 deletions(-)
diff --git a/src/challengerdb/challenger-0004.sql b/src/challengerdb/challenger-0004.sql
@@ -43,4 +43,12 @@ ALTER TABLE validations
     REFERENCES clients (client_serial_id)
     ON DELETE CASCADE;
 
+-- These should really be primary keys
+ALTER TABLE validations
+  ADD CONSTRAINT serial_pkey PRIMARY KEY (validation_serial_id);
+DROP INDEX validations_serial; -- no longer needed
+ALTER TABLE clients
+  ADD CONSTRAINT serial_pkey PRIMARY KEY (client_serial_id);
+DROP INDEX clients_serial; -- no longer needed
+
 COMMIT;