diff options
author | Christian Grothoff <christian@grothoff.org> | 2022-11-27 18:40:44 +0100 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2022-11-27 18:40:44 +0100 |
commit | f2ba02aab2b9bbd976107ecc4ac7e7d657a9d73a (patch) | |
tree | 2b573c5ec895fbca1663a9e0efa6102890f68bbc /src/exchangedb/0002-wads_in.sql | |
parent | bbf3e6fe03f1f9f8c7d342004f65bab9f7b1b91c (diff) | |
download | exchange-f2ba02aab2b9bbd976107ecc4ac7e7d657a9d73a.tar.xz |
more sql refactoring
Diffstat (limited to 'src/exchangedb/0002-wads_in.sql')
-rw-r--r-- | src/exchangedb/0002-wads_in.sql | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/src/exchangedb/0002-wads_in.sql b/src/exchangedb/0002-wads_in.sql index dbbb02a7d..013b16350 100644 --- a/src/exchangedb/0002-wads_in.sql +++ b/src/exchangedb/0002-wads_in.sql @@ -15,7 +15,7 @@ -- CREATE FUNCTION create_table_wads_in( - IN shard_suffix VARCHAR DEFAULT NULL + IN partition_suffix VARCHAR DEFAULT NULL ) RETURNS VOID LANGUAGE plpgsql @@ -35,36 +35,36 @@ BEGIN ') %s ;' ,table_name ,'PARTITION BY HASH (wad_id)' - ,shard_suffix + ,partition_suffix ); PERFORM comment_partitioned_table( 'Incoming exchange-to-exchange wad wire transfers' ,table_name - ,shard_suffix + ,partition_suffix ); PERFORM comment_partitioned_column( 'Unique identifier of the wad, part of the wire transfer subject' ,'wad_id' ,table_name - ,shard_suffix + ,partition_suffix ); PERFORM comment_partitioned_column( 'Base URL of the originating URL, also part of the wire transfer subject' ,'origin_exchange_url' ,table_name - ,shard_suffix + ,partition_suffix ); PERFORM comment_partitioned_column( 'Actual amount that was received by our exchange' ,'amount_val' ,table_name - ,shard_suffix + ,partition_suffix ); PERFORM comment_partitioned_column( 'Time when the wad was received' ,'arrival_time' ,table_name - ,shard_suffix + ,partition_suffix ); END $$; |