No duplicate of primary key names

A constraint named client_id_pk was used by two different tables. This is fine when running mysql. But, using this for postgresql is not allowed. 
Changed the generated primary keys to be unique.