Skip to content

FTS-1975: Make the "fts-schema-8.1.0" consistent with previous "fts-schema-8.0.1" and "fts-diff-8.1.0" applied

Mihai Patrascoiu requested to merge FTS-1975_fix_schema_8.1.0 into 3.12.x

As described in FTS-1975, the current fts-schema-8.1.0 provides an incomplete schema.

The following fields and/or values are missing:

  • t_file_backup.file_state missing FORCE_START value
  • t_file_backup.priority missing
  • t_file_backup.dest_surl_uauid missing
  • t_file_backup.staging_metadata missing
  • t_job_backup.os_project_id missing

Additional changes were noticed, which should be ported to the next v8.2.0 schema:

  • vo_name type varchar(100) instead of varchar(50) in t_job, t_job_backup, t_file, t_file_backup
  • Additional index idx_transfer_host_finish_time(transfer_host, finish_time) on t_file

This merge request addresses those inconsistencies.

Ultimately, fts-schema-8.1.0 should be equivalent with fts-schema-8.0.1 + fts-diff-8.1.0.sql.

Edited by Mihai Patrascoiu

Merge request reports