Primary key should have not null element

Problem/Motivation

The module db schema should include not null as this can trigger an error:

 Syntax error or access violation: 1171 All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

(php7 + mysql 5.7)

Proposed resolution

Add the not null element to the schema. See attached patch.