don't use integer primary key as it accepts null even when defined as 'not null'
tweaked tests to fit integer unique not null (instead of integer primary key)