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

Backport OPENIDM-2728: Database creation scripts missing primary and foreign keys on some tables

    Details

      Description

      Several tables created by the 'openidm.sql' scripts (/openidm/db/scripts/[DB Type]/openidm.sql) are missing primary keys:

      clusterobjectproperties
      configobjectproperties
      genericobjectproperties
      managedobjectproperties
      schedobjectproperties

      This seems to be the case across all database options

      Furthermore, the following tables : schedobjectproperties, clusterobjectproperties do not have a Foreign Key constraint.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                mark.offutt Mark Offutt
                Reporter:
                mark.offutt Mark Offutt
                QA Assignee:
                Jakub Janoska
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: