Make unique constraint for work_item_type_custom_lifecycles more strict

Based on feedback in !205712 (comment 2777777566)

But I think our DB uniqueness constraint on (namespace_id, work_item_type_id, lifecycle_id) is not strict enough. Should this be (namespace_id, work_item_type_id) instead? 🤔