Create unique index on allocation versions for each of the publication states
Create unique index on allocation versions for each of the publication booleans when it is true.
This will ensure that only one pair can have "true" for each of the three publication booleans.