summaryrefslogtreecommitdiff
path: root/src/exchangedb/0002-policy_fulfillments.sql
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2023-07-30 14:02:40 +0200
committerChristian Grothoff <christian@grothoff.org>2023-07-30 14:02:40 +0200
commita29f04189c8b7457ede0b3ac01222b88853325a8 (patch)
treec00400029ee53863481c2e30ffea5c275685733c /src/exchangedb/0002-policy_fulfillments.sql
parentafa706914fefc90812c0bda01341e1dcfca06840 (diff)
downloadexchange-a29f04189c8b7457ede0b3ac01222b88853325a8.tar.gz
exchange-a29f04189c8b7457ede0b3ac01222b88853325a8.tar.bz2
exchange-a29f04189c8b7457ede0b3ac01222b88853325a8.zip
unify to TEXT instead of mixing TEXT and VARCHAR
Diffstat (limited to 'src/exchangedb/0002-policy_fulfillments.sql')
-rw-r--r--src/exchangedb/0002-policy_fulfillments.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/exchangedb/0002-policy_fulfillments.sql b/src/exchangedb/0002-policy_fulfillments.sql
index 54f44df52..c3e48f6db 100644
--- a/src/exchangedb/0002-policy_fulfillments.sql
+++ b/src/exchangedb/0002-policy_fulfillments.sql
@@ -19,7 +19,7 @@
CREATE TABLE policy_fulfillments
(fulfillment_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE PRIMARY KEY
,fulfillment_timestamp INT8 NOT NULL
- ,fulfillment_proof VARCHAR
+ ,fulfillment_proof TEXT
,h_fulfillment_proof BYTEA NOT NULL CHECK(LENGTH(h_fulfillment_proof) = 64) UNIQUE
,policy_hash_codes BYTEA NOT NULL CHECK(0 = MOD(LENGTH(policy_hash_codes), 16))
);