* feat: alter db columns with TEXT type used as JSON to JSON type

* test: update hash connstants

* fix: drop foreign key for sqlite

* fix: do not change text type fo sqlite

* test: fix after json changes

* fix: keep translations.translated_fields as TEXT

* fix: update schema revisions in TestConstants and add recursive sorting in JsonSchema

* test: add TestConstants for revisions

---------

Co-authored-by: Stefano Rosanelli <stefano.rosanelli@gmail.com>