aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/common-0001.sql
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2022-04-23 19:01:28 +0200
committerChristian Grothoff <christian@grothoff.org>2022-04-23 19:01:28 +0200
commitb054c969cbd84f7ed0f61da3db6a8168b944318f (patch)
treec0ffbd484e5edfa11382fbdc2a50f225371509dc /src/exchangedb/common-0001.sql
parentcf358f9546c89d9a52c444d18def703547a9d223 (diff)
downloadexchange-b054c969cbd84f7ed0f61da3db6a8168b944318f.tar.gz
exchange-b054c969cbd84f7ed0f61da3db6a8168b944318f.tar.bz2
exchange-b054c969cbd84f7ed0f61da3db6a8168b944318f.zip
-add more accounting fields to reserve table
Diffstat (limited to 'src/exchangedb/common-0001.sql')
-rw-r--r--src/exchangedb/common-0001.sql6
1 files changed, 5 insertions, 1 deletions
diff --git a/src/exchangedb/common-0001.sql b/src/exchangedb/common-0001.sql
index 1bf3e6308..a96b91fa1 100644
--- a/src/exchangedb/common-0001.sql
+++ b/src/exchangedb/common-0001.sql
@@ -106,6 +106,10 @@ BEGIN
',reserve_pub BYTEA PRIMARY KEY CHECK(LENGTH(reserve_pub)=32)'
',current_balance_val INT8 NOT NULL'
',current_balance_frac INT4 NOT NULL'
+ ',purses_active INT8 NOT NULL DEFAULT(0)'
+ ',purses_allowed INT8 NOT NULL DEFAULT(0)'
+ ',kyc_required BOOLEAN NOT NULL DEFAULT(FALSE)'
+ ',kyc_passed BOOLEAN NOT NULL DEFAULT(FALSE)'
',expiration_date INT8 NOT NULL'
',gc_date INT8 NOT NULL'
') %s ;'
@@ -2331,7 +2335,7 @@ BEGIN
DROP CONSTRAINT IF EXISTS wads_in_pkey CASCADE
,DROP CONSTRAINT IF EXISTS wads_in_wad_id_origin_exchange_url_key
;
-
+
ALTER TABLE IF EXISTS wad_in_entries
DROP CONSTRAINT IF EXISTS wad_in_entries_pkey CASCADE
;