1 files changed, 6 insertions, 4 deletions
diff --git a/src/auditordb/0002-auditor_exchange_signkeys.sql b/src/auditordb/0002-auditor_exchange_signkeys.sql
index 64349a2ff..289b60ed9 100644
--- a/src/auditordb/0002-auditor_exchange_signkeys.sql
+++ b/src/auditordb/0002-auditor_exchange_signkeys.sql
@@ -15,11 +15,13 @@
 --
 
 CREATE TABLE auditor_exchange_signkeys
-  (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 INT8 NOT NULL
-  ,ep_expire_sign INT8 NOT NULL
-  ,ep_expire_legal INT8 NOT NULL
+  ,ep_valid_from BIGINT NOT NULL
+  ,ep_expire_sign BIGINT NOT NULL
+  ,ep_expire_legal BIGINT NOT NULL,
+   suppressed BOOLEAN NOT NULL DEFAULT FALSE
   );
 COMMENT ON TABLE auditor_exchange_signkeys
   IS 'list of the online signing keys of exchanges we are auditing';