diff options
Diffstat (limited to 'src/exchangedb/0002-wads_in.sql')
-rw-r--r-- | src/exchangedb/0002-wads_in.sql | 13 |
1 files changed, 6 insertions, 7 deletions
diff --git a/src/exchangedb/0002-wads_in.sql b/src/exchangedb/0002-wads_in.sql index 013b16350..479589ba4 100644 --- a/src/exchangedb/0002-wads_in.sql +++ b/src/exchangedb/0002-wads_in.sql @@ -15,21 +15,20 @@ -- CREATE FUNCTION create_table_wads_in( - IN partition_suffix VARCHAR DEFAULT NULL + IN partition_suffix TEXT DEFAULT NULL ) RETURNS VOID LANGUAGE plpgsql AS $$ DECLARE - table_name VARCHAR DEFAULT 'wads_in'; + table_name TEXT DEFAULT 'wads_in'; BEGIN PERFORM create_partitioned_table( 'CREATE TABLE %I ' '(wad_in_serial_id BIGINT GENERATED BY DEFAULT AS IDENTITY' ',wad_id BYTEA PRIMARY KEY CHECK (LENGTH(wad_id)=24)' ',origin_exchange_url TEXT NOT NULL' - ',amount_val INT8 NOT NULL' - ',amount_frac INT4 NOT NULL' + ',amount taler_amount NOT NULL' ',arrival_time INT8 NOT NULL' ',UNIQUE (wad_id, origin_exchange_url)' ') %s ;' @@ -56,7 +55,7 @@ BEGIN ); PERFORM comment_partitioned_column( 'Actual amount that was received by our exchange' - ,'amount_val' + ,'amount' ,table_name ,partition_suffix ); @@ -70,13 +69,13 @@ END $$; CREATE FUNCTION constrain_table_wads_in( - IN partition_suffix VARCHAR + IN partition_suffix TEXT ) RETURNS VOID LANGUAGE plpgsql AS $$ DECLARE - table_name VARCHAR DEFAULT 'wads_in'; + table_name TEXT DEFAULT 'wads_in'; BEGIN table_name = concat_ws('_', table_name, partition_suffix); EXECUTE FORMAT ( |