ALTER TABLE `users` MODIFY COLUMN `colorHex` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '000000',
 MODIFY COLUMN `nameColorHex` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '000000';
UPDATE users AS a
SET statuses = (
    SELECT COUNT(statusId)
    FROM statuses AS b
    WHERE b.senderId = a.userId AND
          b.removedTime = 0
);