fix blurbs to work with db constraints. update locations for prototek groups