ALTER TABLE `sys_user` ADD `resetToken` varchar(50) NOT NULL AFTER `locked`;

UPDATE `sys_user` AS user, (SELECT receiver, SUM(score) AS score FROM `sys_score` WHERE score > 0 AND module = 'score' AND method = 'gift' GROUP BY receiver) AS score SET user.levelScore = user.levelScore - score.score WHERE user.account = score.receiver;
