-- Migration: Remove unique constraint from resident_stays to allow multiple beds per resident
-- Purpose: Allow a single resident to have multiple active stays in different beds simultaneously
-- Created: 2026-05-12

-- Drop the unique constraint that enforces one active stay per resident
DROP INDEX IF EXISTS public.uq_resident_stays_active;

-- Verify the migration was successful
-- SELECT * FROM pg_indexes WHERE schemaname = 'public' AND tablename = 'resident_stays' AND indexname = 'uq_resident_stays_active';
