-- Add deleted_at column to units table for soft delete functionality
ALTER TABLE units ADD COLUMN deleted_at TIMESTAMP WITH TIME ZONE;
CREATE INDEX idx_units_deleted_at ON units(deleted_at);