V68: Allow NULL slug for timestamp-mode publishing posts
Timestamp-mode posts are identified by (post_date, post_time), not by slug. The NOT NULL constraint on slug was incorrectly applied to all modes.
Changes
- Drop NOT NULL constraint on
slugcolumn inphoenix_kit_publishing_posts - Replace unique index
idx_publishing_posts_group_slugwith a partial index that only enforces uniqueness for slug-mode posts (where slug IS NOT NULL) - Add unique index on
(group_uuid, post_date, post_time)for timestamp-mode posts
All operations are idempotent.