summaryrefslogtreecommitdiff
path: root/src/exchangedb/0002-auditors.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/exchangedb/0002-auditors.sql')
-rw-r--r--src/exchangedb/0002-auditors.sql16
1 files changed, 1 insertions, 15 deletions
diff --git a/src/exchangedb/0002-auditors.sql b/src/exchangedb/0002-auditors.sql
index 3c18eef86..32ec8446a 100644
--- a/src/exchangedb/0002-auditors.sql
+++ b/src/exchangedb/0002-auditors.sql
@@ -15,7 +15,7 @@
--
-CREATE TABLE IF NOT EXISTS auditors
+CREATE TABLE auditors
(auditor_uuid BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE
,auditor_pub BYTEA PRIMARY KEY CHECK (LENGTH(auditor_pub)=32)
,auditor_name VARCHAR NOT NULL
@@ -33,17 +33,3 @@ COMMENT ON COLUMN auditors.is_active
IS 'true if we are currently supporting the use of this auditor.';
COMMENT ON COLUMN auditors.last_change
IS 'Latest time when active status changed. Used to detect replays of old messages.';
-
-
-INSERT INTO exchange_tables
- (name
- ,version
- ,action
- ,partitioned
- ,by_range)
- VALUES
- ('auditors'
- ,'exchange-0001'
- ,'create'
- ,FALSE
- ,FALSE);