DROP TRIGGER elder_persona_config_changed ON subject_voice_agent;
DROP TRIGGER elder_persona_consent_changed ON consent_record;
DROP TRIGGER elder_persona_profile_changed ON subject_profile;
DROP FUNCTION elder_persona_config_changed();
DROP FUNCTION elder_persona_consent_changed();
DROP FUNCTION elder_persona_profile_changed();
DROP FUNCTION queue_elder_persona_sync(uuid);
DROP INDEX elder_persona_retry_idx;
ALTER TABLE subject_voice_agent DROP COLUMN persona_base_role,DROP COLUMN persona_revision,DROP COLUMN persona_synced_revision,DROP COLUMN persona_sync_state,DROP COLUMN persona_sync_attempts,DROP COLUMN persona_next_retry_at,DROP COLUMN persona_error_code,DROP COLUMN persona_synced_at,DROP COLUMN persona_digest,DROP COLUMN persona_memory_allowed,DROP COLUMN persona_voice_allowed,DROP COLUMN persona_session_dirty;