don't update "parent" since it now references to the rank.id column which is the old "pre" column