aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/common-0001.sql
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2022-05-07 23:45:17 +0200
committerChristian Grothoff <christian@grothoff.org>2022-05-07 23:45:17 +0200
commit6b8e732bf8d8bfae268e7f5a9a09af9167fd0d47 (patch)
tree6a0eb06a4b084f4085badaefe4db5ebe2bcabd52 /src/exchangedb/common-0001.sql
parent5f6d5bc3fcad284107e3e7d5f992f887895473fa (diff)
downloadexchange-6b8e732bf8d8bfae268e7f5a9a09af9167fd0d47.tar.xz
-pub
Diffstat (limited to 'src/exchangedb/common-0001.sql')
-rw-r--r--src/exchangedb/common-0001.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/src/exchangedb/common-0001.sql b/src/exchangedb/common-0001.sql
index 6d45c22ea..861e85475 100644
--- a/src/exchangedb/common-0001.sql
+++ b/src/exchangedb/common-0001.sql
@@ -1161,11 +1161,17 @@ BEGIN
'(purse_requests_serial_id BIGINT GENERATED BY DEFAULT AS IDENTITY' --UNIQUE
',purse_pub BYTEA NOT NULL CHECK (LENGTH(purse_pub)=32)'
',merge_pub BYTEA NOT NULL CHECK (LENGTH(merge_pub)=32)'
+ ',purse_creation INT8 NOT NULL'
',purse_expiration INT8 NOT NULL'
',h_contract_terms BYTEA NOT NULL CHECK (LENGTH(h_contract_terms)=64)'
',age_limit INT4 NOT NULL'
+ ',refunded BOOLEAN NOT NULL DEFAULT(FALSE)'
+ ',finished BOOLEAN NOT NULL DEFAULT(FALSE)'
+ ',in_reserve_quota BOOLEAN NOT NULL DEFAULT(FALSE)'
',amount_with_fee_val INT8 NOT NULL'
',amount_with_fee_frac INT4 NOT NULL'
+ ',purse_fee_val INT8 NOT NULL'
+ ',purse_fee_frac INT4 NOT NULL'
',balance_val INT8 NOT NULL DEFAULT (0)'
',balance_frac INT4 NOT NULL DEFAULT (0)'
',purse_sig BYTEA NOT NULL CHECK(LENGTH(purse_sig)=64)'