Schema changes when upgrading the application - Data360_DQ+ - 12.0

When upgrading the application, you will need to run a number of SQL statements on ApplicationDb (PostgreSQL). The statements that you need to run depend on your currently installed version.

ALTER TABLE caf_verdefcontentdep ALTER COLUMN fromfieldpath TYPE text,
ALTER COLUMN tofieldpath TYPE text;
CREATE EXTENSION IF NOT EXISTS pg_trgm;
ALTER TABLE caf_secdatakey ALTER COLUMN keydata TYPE varchar(1000);

CREATE EXTENSION IF NOT EXISTS pg_trgm;
ALTER TABLE caf_secdatakey ALTER COLUMN keydata TYPE varchar(1000);

ALTER TABLE caf_secdatakey ALTER COLUMN keydata TYPE varchar(1000);