-- V013_add_medicine_activity_types.sql
-- Migration V013: Add 'medicine' and 'activity' to allowed activity types

-- Drop the existing constraint
ALTER TABLE activities DROP CONSTRAINT IF EXISTS activities_type_check;

-- Add the new constraint with medicine and activity included
ALTER TABLE activities ADD CONSTRAINT activities_type_check
    CHECK (type IN ('feeding', 'sleep', 'diaper', 'growth', 'medication', 'medicine', 'temperature', 'milestone', 'activity'));
