Database changes - CustomerID

From 5.3.x or lower to 5.4.x

If you are upgrading from version 5.3.x or lower to 5.4.x you must make the following alteration to the PostgreSQL database.

ALTER TABLE CIDTASSIGNMENTREQUESTS ADD CIDCLASTNOTIFIED TIMESTAMP;

Failure to add this database field when upgrading to CustomerID 5.4.x may result in errors, depending on use cases used.

From 5.0.x to 5.1.x

If you are upgrading from version 5.0.x you can use the existing PostgreSQL database as is. There have been some changes, but they are backwards compatible.
Here are the added indexes: 

CREATE INDEX CIDIDX_CIDTORGANIZATIONS_CIDCFRIENDLYNAME ON CIDTORGANIZATIONS (CIDCFRIENDLYNAME);
CREATE INDEX CIDIDX_CIDTORGANIZATIONS_CIDCFRIENDLYNAME_LOWER ON CIDTORGANIZATIONS (LOWER(CIDCFRIENDLYNAME));
CREATE INDEX CIDIDX_CIDTMANDATES_CIDCMANDATENAME ON CIDTMANDATES (CIDCMANDATENAME);

Here are the changed column definitions: 
In table CIDTUSERCUSTOMATTRIBUTES:

CIDCATTRIBUTEVALUE VARCHAR(1024) NOT NULL
->
CIDCATTRIBUTEVALUE VARCHAR(2048) NOT NULL

In table CIDTORGANIZATIONCUSTOMATTRIBUTES: 

CIDCATTRIBUTEVALUE VARCHAR(255) NOT NULL
->
CIDCATTRIBUTEVALUE VARCHAR(2048) NOT NULL