diff options
| author | Christian Grothoff <christian@grothoff.org> | 2023-07-29 23:01:06 +0200 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2023-07-29 23:01:15 +0200 |
| commit | e47e5c0cfba7746263775e8bbd4064b640f69020 (patch) | |
| tree | 4d853f7e1d065a198b32dd14d38df179cf288e15 /src/exchangedb/0002-aggregation_transient.sql | |
| parent | ecf6b2750bb6ed9157aece72602dd042a50e36f3 (diff) | |
| download | exchange-e47e5c0cfba7746263775e8bbd4064b640f69020.tar.gz exchange-e47e5c0cfba7746263775e8bbd4064b640f69020.tar.bz2 exchange-e47e5c0cfba7746263775e8bbd4064b640f69020.zip | |
migration to new amount style for exchangedb
Diffstat (limited to 'src/exchangedb/0002-aggregation_transient.sql')
| -rw-r--r-- | src/exchangedb/0002-aggregation_transient.sql | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/src/exchangedb/0002-aggregation_transient.sql b/src/exchangedb/0002-aggregation_transient.sql index 2d77e63ca..851342d81 100644 --- a/src/exchangedb/0002-aggregation_transient.sql +++ b/src/exchangedb/0002-aggregation_transient.sql @@ -25,8 +25,7 @@ DECLARE BEGIN PERFORM create_partitioned_table( 'CREATE TABLE %I ' - '(amount_val INT8 NOT NULL' - ',amount_frac INT4 NOT NULL' + '(amount taler_amount NOT NULL' ',wire_target_h_payto BYTEA CHECK (LENGTH(wire_target_h_payto)=32)' ',merchant_pub BYTEA CHECK (LENGTH(merchant_pub)=32)' ',exchange_account_section TEXT NOT NULL' @@ -44,7 +43,7 @@ BEGIN ); PERFORM comment_partitioned_column( 'Sum of all of the aggregated deposits (without deposit fees)' - ,'amount_val' + ,'amount' ,table_name ,shard_suffix ); |