-- Add 'timeline_event' to submission_items item_type constraint
ALTER TABLE public.submission_items 
DROP CONSTRAINT IF EXISTS submission_items_item_type_check;

ALTER TABLE public.submission_items 
ADD CONSTRAINT submission_items_item_type_check 
CHECK (item_type IN (
  'park',
  'ride',
  'review',
  'photo',
  'ride_model',
  'manufacturer',
  'operator',
  'designer',
  'property_owner',
  'photo_edit',
  'photo_delete',
  'milestone',
  'timeline_event'
));

COMMENT ON CONSTRAINT submission_items_item_type_check ON public.submission_items IS 
'Allowed item types: entities (park, ride, etc.), special ops (photo_edit, photo_delete), and events (milestone, timeline_event)';