diff options
author | Christian Grothoff <christian@grothoff.org> | 2023-07-30 14:02:40 +0200 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2023-07-30 14:02:40 +0200 |
commit | a29f04189c8b7457ede0b3ac01222b88853325a8 (patch) | |
tree | c00400029ee53863481c2e30ffea5c275685733c /src/exchangedb/0002-legitimization_processes.sql | |
parent | afa706914fefc90812c0bda01341e1dcfca06840 (diff) | |
download | exchange-a29f04189c8b7457ede0b3ac01222b88853325a8.tar.xz |
unify to TEXT instead of mixing TEXT and VARCHAR
Diffstat (limited to 'src/exchangedb/0002-legitimization_processes.sql')
-rw-r--r-- | src/exchangedb/0002-legitimization_processes.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/src/exchangedb/0002-legitimization_processes.sql b/src/exchangedb/0002-legitimization_processes.sql index 544d58cd2..5b70108ea 100644 --- a/src/exchangedb/0002-legitimization_processes.sql +++ b/src/exchangedb/0002-legitimization_processes.sql @@ -15,7 +15,7 @@ -- CREATE FUNCTION create_table_legitimization_processes( - IN shard_suffix VARCHAR DEFAULT NULL + IN shard_suffix TEXT DEFAULT NULL ) RETURNS VOID LANGUAGE plpgsql @@ -26,9 +26,9 @@ BEGIN '(legitimization_process_serial_id BIGINT GENERATED BY DEFAULT AS IDENTITY' ',h_payto BYTEA NOT NULL CHECK (LENGTH(h_payto)=32)' ',expiration_time INT8 NOT NULL DEFAULT (0)' - ',provider_section VARCHAR NOT NULL' - ',provider_user_id VARCHAR DEFAULT NULL' - ',provider_legitimization_id VARCHAR DEFAULT NULL' + ',provider_section TEXT NOT NULL' + ',provider_user_id TEXT DEFAULT NULL' + ',provider_legitimization_id TEXT DEFAULT NULL' ',finished BOOLEAN DEFAULT (FALSE)' ',UNIQUE (h_payto, provider_section)' ') %s ;' @@ -89,13 +89,13 @@ $$; -- We need a separate function for this, as we call create_table only once but need to add -- those constraints to each partition which gets created CREATE FUNCTION constrain_table_legitimization_processes( - IN partition_suffix VARCHAR + IN partition_suffix TEXT ) RETURNS void LANGUAGE plpgsql AS $$ DECLARE - partition_name VARCHAR; + partition_name TEXT; BEGIN partition_name = concat_ws('_', 'legitimization_processes', partition_suffix); |