-- Division / season tracking (one row per profile, reset each season)
CREATE TABLE IF NOT EXISTS seasons (
    profile_id TEXT PRIMARY KEY,
    division INTEGER NOT NULL DEFAULT 5,
    season_number INTEGER NOT NULL DEFAULT 1,
    season_points INTEGER NOT NULL DEFAULT 0,
    matches_played INTEGER NOT NULL DEFAULT 0,
    wins INTEGER NOT NULL DEFAULT 0,
    draws INTEGER NOT NULL DEFAULT 0,
    losses INTEGER NOT NULL DEFAULT 0,
    started_at TEXT NOT NULL
);

-- Pack open history: store which card_ids came out of each open
ALTER TABLE packs ADD COLUMN opened_cards TEXT;
ALTER TABLE packs ADD COLUMN opened_at TEXT;

-- Club cosmetic customization
ALTER TABLE clubs ADD COLUMN manager_name TEXT DEFAULT 'Player Manager';