Add column IS_REPACK_VO and respective constraints to VIRTUAL_ORGANIZATION table
Summary
Added logic to allow enabling a default VO for repacking operations:
- Add column
IS_REPACK_VO
toVIRTUAL_ORGANIZATION
table. ConstraintIS_REPACK_VO
to the values0
or1
(boolean).- Constraint
IS_REPACK_VO
to the values1
orNULL
(boolean). - Only allow one entry in the table to have a
IS_REPACK_VO
value of1
:Achieved by adding aUNIQUE INDEX
onNULLIF(IS_REPACK_VO, '0')
- Achieved by adding a
UNIQUE INDEX
onIS_REPACK_VO
(NULL
entries will be ignored)
References
Edited by Joao Afonso