A tight asymptotic bound on the size of constant-weight conflict-avoiding codes