Таблица competition_user

CREATE TABLE competition_user (
id int(11) NOT NULL AUTO_INCREMENT,
week int(11) DEFAULT NULL,
user_id int(11) DEFAULT NULL,
platform int(11) DEFAULT NULL,
group_id int(11) DEFAULT NULL,
score int(11) NOT NULL DEFAULT '0',
position int(11) NOT NULL DEFAULT '0',
read int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (id),
UNIQUE KEY ix_week_user (week,user_id),
KEY ix_group (group_id)
) ENGINE=InnoDB AUTO_INCREMENT=55924 DEFAULT CHARSET=utf8mb4;