db: more consistently set primary keys to be unique, not nullable and without default Setting primary_key will (in general) automatically set autoincrement and setting a default is just odd.