10 lines
831 B
SQL
10 lines
831 B
SQL
|
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;
|