-- Fee breakdown per bet, so a settled round records not just what was paid but
-- what was deducted and why. The ledger already carries the money; this makes
-- the split queryable for reporting without re-deriving it.

ALTER TABLE bets ADD COLUMN rake_msat     BIGINT NOT NULL DEFAULT 0;
ALTER TABLE bets ADD COLUMN rounding_msat BIGINT NOT NULL DEFAULT 0;

ALTER TABLE bets ADD CONSTRAINT bet_fees_non_negative
    CHECK (rake_msat >= 0 AND rounding_msat >= 0);