[brigmcneil]

I think the latter would work - it basically makes ID + retired status = primary key