o s Gi6@s ddlZddlmZddZdS)N)settingscsvttjIdH}|dIdH|dIdH|dIdH|dIdH|dIdH|IdHdS)Na CREATE TABLE IF NOT EXISTS matches ( match_id TEXT PRIMARY KEY, home_team TEXT, away_team TEXT, home_goals INTEGER, away_goals INTEGER, status TEXT, start_time TIMESTAMP, competition TEXT, url TEXT ); a CREATE TABLE IF NOT EXISTS predictions ( match_id TEXT PRIMARY KEY, p1 REAL, px REAL, p2 REAL, lambda_home REAL, lambda_away REAL, confidence REAL, created_at TIMESTAMP DEFAULT now() ); z CREATE TABLE IF NOT EXISTS match_events ( id SERIAL PRIMARY KEY, match_id TEXT, event_type TEXT, event_minute INTEGER, created_at TIMESTAMP DEFAULT now() ); z CREATE TABLE IF NOT EXISTS metric_aggregates ( id SERIAL PRIMARY KEY, name TEXT, value REAL, updated_at TIMESTAMP DEFAULT now() ); z CREATE TABLE IF NOT EXISTS team_stats ( team_id TEXT PRIMARY KEY, team_name TEXT, attack REAL, defense REAL, updated_at TIMESTAMP DEFAULT now() ); )asyncpgconnectr DATABASE_URLexecuteclose)connr 5/var/www/www-root/data/www/77.83.87.30/database/db.pyinit_dbs   r )rconfigrr r r r r s