added updates to sql schema from v1.0