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.