update client to use auto increment id