FTS-1975: Make the "fts-schema-8.1.0" consistent with previous "fts-schema-8.0.1" and "fts-diff-8.1.0" applied
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
missingFORCE_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
typevarchar(100)
instead ofvarchar(50)
int_job, t_job_backup, t_file, t_file_backup
- Additional index
idx_transfer_host_finish_time(transfer_host, finish_time)
ont_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