agent_submissions_setup.sql

-- 1. 添加 agent_submissions_data JSON 列
ALTER TABLE trading_decisions
ADD COLUMN IF NOT EXISTS agent_submissions_data JSONB;

-- 2. 初始化数据（在 InvestorAgent, 2025-08-01, BTC, gpt_4.1 这一行）
UPDATE trading_decisions
SET agent_submissions_data = '[]'::jsonb
WHERE agent_name = 'InvestorAgent'
  AND date = '2025-08-01'
  AND asset = 'BTC'
  AND model = 'gpt_4.1';

-- 3. 验证（可选）
SELECT agent_name, date, asset, model, agent_submissions_data
FROM trading_decisions
WHERE agent_name = 'InvestorAgent'
  AND date = '2025-08-01'
  AND asset = 'BTC'
  AND model = 'gpt_4.1';