more work on SQL refactoring

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);