exchange

commit 20638c434033b17d97aa1e92c9bc77f358085ebd
parent 31307720181bbaf0a420f93043e9765b7f217119
Author: Christian Grothoff <christian@grothoff.org>
Date:   Sun, 15 Sep 2024 11:34:26 +0200

-fix SQL

Diffstat:
M
src/auditordb/0002-auditor_exchange_signkeys.sql
 | 
4
++--
M
src/auditordb/pg_insert_exchange_signkey.c
 | 
6
+++---

2 files changed, 5 insertions(+), 5 deletions(-)
diff --git a/src/auditordb/0002-auditor_exchange_signkeys.sql b/src/auditordb/0002-auditor_exchange_signkeys.sql
@@ -15,8 +15,8 @@
 --
 
 CREATE TABLE auditor_exchange_signkeys
-  (row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE,
-      exchange_pub BYTEA PRIMARY KEY CHECK (LENGTH(exchange_pub)=32)
+  (row_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE
+  ,exchange_pub BYTEA PRIMARY KEY CHECK (LENGTH(exchange_pub)=32)
   ,master_sig BYTEA NOT NULL CHECK (LENGTH(master_sig)=64)
   ,ep_valid_from BIGINT NOT NULL
   ,ep_expire_sign BIGINT NOT NULL
diff --git a/src/auditordb/pg_insert_exchange_signkey.c b/src/auditordb/pg_insert_exchange_signkey.c
@@ -44,9 +44,9 @@ TAH_PG_insert_exchange_signkey (
   PREPARE (pg,
            "auditor_insert_exchange_signkey",
            "INSERT INTO auditor_exchange_signkeys "
-           "(ep_start"
-           ",ep_expire"
-           ",ep_end"
+           "(ep_valid_from"
+           ",ep_expire_sign"
+           ",ep_expire_legal"
            ",exchange_pub"
            ",master_sig"
            ") VALUES ($1,$2,$3,$4,$5);"