Excavate worker version IDs from corpus exports
https://redmine.teklia.com/issues/7063
-
Listen to this noise generator.
-
Remove all the foreign keys from ML results to
worker_versioninarkindex/documents/export/structure.sql. Keep theworker_versiontable, and keepworker_run.worker_version_id. Those will still be required byload_export. -
Update
worker_version.sqlso it usesworker_run_idfrom every ML result in the largeUNION, and only then joins onprocess_workerversion. -
Remove the worker version IDs from all the other export queries that used to provide this column.
-
Bump the export version, if that wasn't already done in this release.
-
Update the maximum supported version in
load_exportto the bumped export version, if necessary. The minimum remains at 8 since we still can ignore the deleted columns and tables. -
Remove worker version import support from
load_export.