prazy1208/text2sql

1-- Migration: add app_schema.few_shot_agent_output (Few-Shot Agent output persistence).2-- Run once on databases created before this table existed.3-- Safe if the table already exists.4 5CREATE TABLE IF NOT EXISTS app_schema.few_shot_agent_output (6    id                  SERIAL PRIMARY KEY,7    intent_output_id    INT NOT NULL REFERENCES app_schema.intent_agent_output(id) ON DELETE CASCADE,8    few_shot_examples   JSONB NOT NULL DEFAULT '[]'::jsonb,9    created_at          TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,10    UNIQUE (intent_output_id)11);12 13COMMENT ON TABLE app_schema.few_shot_agent_output IS 'Few-Shot Agent: selected few_shot_examples for one intent_agent_output row';14