\jP vSrSSKrSSKrSSKrSSKrSrS\4Sjr\S:Xa\R"\"55 gg)z Crea le tabelle per la pipeline live (agente formazioni, snapshot quote, predizioni) come da design in docs/agent-01-formazioni-design.md. Idempotente: usa CREATE TABLE IF NOT EXISTS. Uso: python scripts/create_live_tables.py Na CREATE TABLE IF NOT EXISTS odds_snapshots ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, match_id INT UNSIGNED NOT NULL, taken_at DATETIME NOT NULL, stage VARCHAR(10) NOT NULL, -- 'S1', 'S2', 'closing' source VARCHAR(30) NOT NULL, -- 'football-data', 'odds-api', ... odds_home DECIMAL(7,3) NULL, odds_draw DECIMAL(7,3) NULL, odds_away DECIMAL(7,3) NULL, prob_home DECIMAL(6,4) NULL, -- normalizzate, senza margine prob_draw DECIMAL(6,4) NULL, prob_away DECIMAL(6,4) NULL, KEY idx_match_stage (match_id, stage), CONSTRAINT fk_snap_match FOREIGN KEY (match_id) REFERENCES matches (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS agent_signals ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, match_id INT UNSIGNED NOT NULL, agent VARCHAR(30) NOT NULL, -- 'formazioni' stage VARCHAR(10) NOT NULL, -- 'S1', 'S2' checked_at DATETIME NOT NULL, payload JSON NULL, -- output JSON grezzo dell'LLM delta_lambda_home DECIMAL(6,4) NULL, -- aggiustamento log-gol-attesi delta_lambda_away DECIMAL(6,4) NULL, confidence DECIMAL(4,3) NULL, model_version VARCHAR(40) NULL, -- versione prompt/pipeline KEY idx_match_agent (match_id, agent, stage), CONSTRAINT fk_signal_match FOREIGN KEY (match_id) REFERENCES matches (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS predictions ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, match_id INT UNSIGNED NOT NULL, made_at DATETIME NOT NULL, stage VARCHAR(10) NOT NULL, -- 'S1', 'S2' source ENUM('model', 'market', 'blend', 'agent_adj') NOT NULL, prob_home DECIMAL(6,4) NOT NULL, prob_draw DECIMAL(6,4) NOT NULL, prob_away DECIMAL(6,4) NOT NULL, details JSON NULL, -- es. segnali usati, pesi KEY idx_match_source (match_id, source, stage), CONSTRAINT fk_pred_match FOREIGN KEY (match_id) REFERENCES matches (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; returncf[R"SS9n[R"U5 UR 5n[ R "URURURURSS9nUR5n[RS5H+nUR5(dMURU5 M- UR!5 URS5 [#S5 UR%5Hun[#SU35 M UR'5 g ) Nz#Crea le tabelle della pipeline live) description tigertips)hostportuserpassworddatabase;z SHOW TABLESzTabelle nel database tigertips:z r)argparseArgumentParserconfig add_db_args parse_argspymysqlconnectrrr r cursorSCHEMAsplitstripexecutecommitprintfetchallclose)parserargsconncur statementnames 5C:\wamp64\www\Tigertips\scripts\create_live_tables.pymainr$As  $ $1V WF v    D ??   $(MMK ID ++-C\\#& ??   KK "' KKMKK  +,<<> 4&k"JJL __main__) __doc__r sysrrrintr$__name__exitr%r#r-sI  - ` c * zHHTVr%