### ### Description of mysql tables: RatingChangeAdmin ### Here you'll find some infos about all the rating tables. Important Notes: ########################################################################### ## --- RatingChangeAdmin --- Description: Table containing rating-changes done by admin. Needed because rating-changes need to be taken into account on rating-recalculations. Possible rating-changes are reset of confidence-interval relative to rating, and change of Players.Rating2 itself. Reset of confidence-interval will apply after rating-change (if there is one, see Changes-field). | Field | Type | Null | Key | Default | Extra | +---------+------------+------+-----+---------------------+----------------+ | ID | int(11) | NO | PRI | NULL | auto_increment | | uid | int(11) | NO | MUL | NULL | | | Created | datetime | NO | MUL | 0000-00-00 00:00:00 | | | Changes | tinyint(4) | NO | | 0 | | | Rating | double | NO | | -9999 | | ## Fields: * uid : FK to Players.ID * Created : date of change * Changes : bitmask of executed changes - 1 = bit set if rating-confidence-interval has been resetted - 2 = bit set if rating has been changed, then Rating-field is meaningful * Rating : new rating changed at Created-time if (Changes & 2) set