mimetype: Migrate to indexed data as text

Note: migration currently running in production

Related T818

Test Plan

tox

---

Migrated from D714 (view on Phabricator)

sql/upgrades/117.sql

@@ -3,6 +3,9 @@
 -- to_version: 117
 -- description: Add fulltext search index for origin intrinsic metadata
 
+insert into dbversion(version, release, description)
+values(117, now(), 'Work In Progress');
+
 alter table origin_intrinsic_metadata add column metadata_tsvector tsvector;
 update origin_intrinsic_metadata set metadata_tsvector = to_tsvector('pg_catalog.simple', metadata);
 create index origin_intrinsic_metadata_fulltext_idx on origin_intrinsic_metadata using gin (metadata_tsvector);

[Antoine R. Dumont]

Unrelated to the main diff