Uploaded image for project: 'OpenIDM'
  1. OpenIDM
  2. OPENIDM-11089

Docs: Set repo objecttypes.objecttype to NOT NULL

    Details

    • Type: Story
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 6.5.0
    • Fix Version/s: 6.5.0
    • Component/s: _Update, documentation
    • Labels:
      None
    • Target Version/s:
    • Story Points:
      1
    • Sprint:
      OpenIDM Sprint 6.5-7, OpenIDM Sprint 6.5-8

      Description

      The column "objecttype" in the "openidm.objecttypes" table are defined differently for different databases that IDM supports. The "objecttype" for MSSQL and DB2 are defined as "NOT NULL". MySQL, Oracle, and PostgreSQL have "objecttype" defined as "NULL". An object type can never be null so we have changed the openidm.sql scripts for all DBs to consistently be “NOT NULL”.

      The following are database specific commands that can be executed to upgrade each repo from 6.0 -> 6.5.

      MySQL

      ALTER TABLE openidm.objecttypes MODIFY objecttype VARCHAR(255) NOT NULL;

      Oracle

      ALTER TABLE objecttypes MODIFY (objecttype NOT NULL)

       Postges

      ALTER TABLE objecttypes ALTER COLUMN objecttype SET NOT NULL;

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                nabil.maynard Nabil Maynard
                Reporter:
                emanuel.brici Emanuel Brici
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: