aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/0002-policy_fulfillments.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/exchangedb/0002-policy_fulfillments.sql')
-rw-r--r--src/exchangedb/0002-policy_fulfillments.sql16
1 files changed, 1 insertions, 15 deletions
diff --git a/src/exchangedb/0002-policy_fulfillments.sql b/src/exchangedb/0002-policy_fulfillments.sql
index 6c01081af..54f44df52 100644
--- a/src/exchangedb/0002-policy_fulfillments.sql
+++ b/src/exchangedb/0002-policy_fulfillments.sql
@@ -16,7 +16,7 @@
-- FIXME: this table should be sharded!
-CREATE TABLE IF NOT EXISTS policy_fulfillments
+CREATE TABLE policy_fulfillments
(fulfillment_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY
,fulfillment_timestamp INT8 NOT NULL
,fulfillment_proof VARCHAR
@@ -33,17 +33,3 @@ COMMENT ON COLUMN policy_fulfillments.h_fulfillment_proof
IS 'Hash of the fulfillment_proof';
COMMENT ON COLUMN policy_fulfillments.policy_hash_codes
IS 'Concatenation of the policy_hash_code of all policy_details that are fulfilled by this proof';
-
-
-INSERT INTO exchange_tables
- (name
- ,version
- ,action
- ,partitioned
- ,by_range)
- VALUES
- ('policy_fulfillments'
- ,'exchange-0002'
- ,'create'
- ,FALSE -- BAD! FIXME!
- ,FALSE);