exchange

commit 03cfd2b1e548c24f6572f58d3838f8d5b12c7501
parent 6d16958a5c28c4f96d14aae051f30ffd4df00527
Author: Christian Grothoff <christian@grothoff.org>
Date:   Mon, 13 Jun 2022 09:44:56 +0200

-add default(0)

Diffstat:
M
src/exchangedb/common-0001.sql
 | 
8
++++----

1 file changed, 4 insertions(+), 4 deletions(-)
diff --git a/src/exchangedb/common-0001.sql b/src/exchangedb/common-0001.sql
@@ -104,8 +104,8 @@ BEGIN
     'CREATE TABLE IF NOT EXISTS %I'
       '(reserve_uuid BIGINT GENERATED BY DEFAULT AS IDENTITY'
       ',reserve_pub BYTEA PRIMARY KEY CHECK(LENGTH(reserve_pub)=32)'
-      ',current_balance_val INT8 NOT NULL'
-      ',current_balance_frac INT4 NOT NULL'
+      ',current_balance_val INT8 NOT NULL DEFAULT(0)'
+      ',current_balance_frac INT4 NOT NULL DEFAULT(0)'
       ',purses_active INT8 NOT NULL DEFAULT(0)'
       ',purses_allowed INT8 NOT NULL DEFAULT(0)'
       ',kyc_required BOOLEAN NOT NULL DEFAULT(FALSE)'
@@ -396,8 +396,8 @@ BEGIN
       ',coin_pub BYTEA NOT NULL PRIMARY KEY CHECK (LENGTH(coin_pub)=32)'
       ',age_commitment_hash BYTEA CHECK (LENGTH(age_commitment_hash)=32)'
       ',denom_sig BYTEA NOT NULL'
-      ',remaining_val INT8 NOT NULL'
-      ',remaining_frac INT4 NOT NULL'
+      ',remaining_val INT8 NOT NULL DEFAULT(0)'
+      ',remaining_frac INT4 NOT NULL DEFAULT(0)'
     ') %s ;'
     ,table_name
     ,'PARTITION BY HASH (coin_pub)' -- FIXME: or include denominations_serial? or multi-level partitioning?;