summaryrefslogtreecommitdiff
path: root/src/exchangedb/0002-wads_in.sql
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2022-11-27 18:40:44 +0100
committerChristian Grothoff <christian@grothoff.org>2022-11-27 18:40:44 +0100
commitf2ba02aab2b9bbd976107ecc4ac7e7d657a9d73a (patch)
tree2b573c5ec895fbca1663a9e0efa6102890f68bbc /src/exchangedb/0002-wads_in.sql
parentbbf3e6fe03f1f9f8c7d342004f65bab9f7b1b91c (diff)
downloadexchange-f2ba02aab2b9bbd976107ecc4ac7e7d657a9d73a.tar.gz
exchange-f2ba02aab2b9bbd976107ecc4ac7e7d657a9d73a.tar.bz2
exchange-f2ba02aab2b9bbd976107ecc4ac7e7d657a9d73a.zip
more sql refactoring
Diffstat (limited to 'src/exchangedb/0002-wads_in.sql')
-rw-r--r--src/exchangedb/0002-wads_in.sql14
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 $$;