Skip to content

Add column IS_REPACK_VO and respective constraints to VIRTUAL_ORGANIZATION table

Joao Afonso requested to merge cta-31 into main

Summary

Added logic to allow enabling a default VO for repacking operations:

  • Add column IS_REPACK_VO to VIRTUAL_ORGANIZATION table.
  • Constraint IS_REPACK_VO to the values 0 or 1 (boolean).
  • Constraint IS_REPACK_VO to the values 1 or NULL (boolean).
  • Only allow one entry in the table to have a IS_REPACK_VO value of 1:
    • Achieved by adding a UNIQUE INDEX on NULLIF(IS_REPACK_VO, '0')
    • Achieved by adding a UNIQUE INDEX on IS_REPACK_VO (NULL entries will be ignored)

References

CTA#31 (closed)

Edited by Joao Afonso

Merge request reports