It seems like all sql backends have weird configurations: See https://github.com/dphi/pdns-debian/commit/80405812a940b62882537bb9859f722934b73674 for a suggestion on how to fix the inital table creation, which would be a first step! (I did not have a look at how updates to existing tables can be integrated.)