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);