CoolFace
Apppublic

prazy1208/text2sql

sourceHugging Faceupdated 4mo agoView on Hugging Face
0likes
migration_add_column_agent_output.sql14 linesDownload Raw Back to scripts
1-- Migration: add app_schema.column_agent_output (Column Agent 5b).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.column_agent_output (6    id                      SERIAL PRIMARY KEY,7    table_agent_output_id   INT NOT NULL REFERENCES app_schema.table_agent_output(id) ON DELETE CASCADE,8    selected_columns        JSONB NOT NULL DEFAULT '{}'::jsonb,9    created_at              TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,10    UNIQUE (table_agent_output_id)11);12 13COMMENT ON TABLE app_schema.column_agent_output IS 'Column Agent: selected_columns (per table) for one table_agent_output row';14