Strange DEFAULT NULL in PostgreSQL (and derived H2) database schema

[pavelhoral]

I have came across strange DEFAULT NULL declarations in PostgreSQL schema (and derived H2 schema) on columns, where NULL value really does not make sense. I would love this to be investigated a bit and potentially fixed...

Example (not sure NULL objecttype would be a valid value):

CREATE TABLE openidm.objecttypes (
  id BIGSERIAL NOT NULL,
  objecttype VARCHAR(255) DEFAULT NULL,
  PRIMARY KEY (id),
  CONSTRAINT idx_objecttypes_objecttype UNIQUE (objecttype)
);

Refs:

• https://github.com/WrenSecurity/wrenidm/blob/c84d0e59c7ad52195d4fde1dcc2b9ce95c674b5c/openidm-zip/src/main/resources/db/postgresql/scripts/openidm.pgsql
• https://github.com/WrenSecurity/wrenidm/blob/c84d0e59c7ad52195d4fde1dcc2b9ce95c674b5c/openidm-zip/src/main/resources/db/h2/scripts/openidm.sql