6 lines
424 B
SQL
6 lines
424 B
SQL
SET search_path TO analytics, public;
|
|
ALTER TABLE interaction_events ADD COLUMN trigger_source text NOT NULL DEFAULT 'unknown';
|
|
ALTER TABLE interaction_events ADD CONSTRAINT interaction_trigger_source CHECK(trigger_source IN ('game','player','unknown'));
|
|
CREATE INDEX prompt_source_time ON interaction_events(game_id,kind,trigger_source,started_at DESC);
|
|
INSERT INTO schema_migrations(version) VALUES('005_prompt_sources');
|