[PIM] - PostgreSQL validation fails at Hibernate after upgrade to Quarkus 2.7.5

After/when upgrading PIM to Quarkus 2.7.5, hibernate validation fails with the below error message.

wrong column type encountered in column [log] in table [migration_report_logs]; 
found [text (Types#VARCHAR)], but expecting [oid (Types#CLOB)

This requires a change in the Postgres DDL scritps for PIM to accommodate this hibernate change and avoid any potential issues at persistence/database layer when using hibernate/panache.