Spaces:

alesamodio
/

Socrates_docker

Sleeping

App Files Files Community

Socrates_docker / characters /shared /user_profiles_met_characters.sql

AlessandroAmodioNGI

Claude Opus 4.8 (1M context)

fix: Cielo gender/pushiness/proactive, first-contact greeting, empty-reply guard

0588737 4 months ago

Raw History Blame Contribute Delete

670 Bytes

-- met_characters: which characters a user has already been introduced to.
-- Used by db_introductions.py / first_contact_instruction() so each character gives
-- a one-line self-introduction only on the very first turn with a given user.
--
-- Stored on user_profiles (keyed by id = user_id, the table that actually exists;
-- there is no public.users — auth users live in auth.users). It is deliberately NOT
-- added to TRACKED_FIELDS, so the profile classifier never reads or overwrites it;
-- db_introductions.py accesses it with its own targeted queries.

alter table public.user_profiles
    add column if not exists met_characters text[] not null default '{}';

	-- met_characters: which characters a user has already been introduced to.
	-- Used by db_introductions.py / first_contact_instruction() so each character gives
	-- a one-line self-introduction only on the very first turn with a given user.
	--
	-- Stored on user_profiles (keyed by id = user_id, the table that actually exists;
	-- there is no public.users — auth users live in auth.users). It is deliberately NOT
	-- added to TRACKED_FIELDS, so the profile classifier never reads or overwrites it;
	-- db_introductions.py accesses it with its own targeted queries.

	alter table public.user_profiles
	add column if not exists met_characters text[] not null default '{}';