diff options
| author | Christian Grothoff <christian@grothoff.org> | 2024-09-15 11:34:26 +0200 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2024-09-15 11:34:26 +0200 |
| commit | 20638c434033b17d97aa1e92c9bc77f358085ebd (patch) | |
| tree | 53b4c4d8b7fc756c68ec69f7b66c7e6935ef2d54 /src | |
| parent | 31307720181bbaf0a420f93043e9765b7f217119 (diff) | |
-fix SQL
Diffstat (limited to 'src')
| -rw-r--r-- | src/auditordb/0002-auditor_exchange_signkeys.sql | 4 | ||||
| -rw-r--r-- | 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 index 25aa13cad..207a51b61 100644 --- 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 index c31456737..489e01721 100644 --- 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);" |