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

Index for links table (Oracle) should be unique

    Details

    • Story Points:
      0.5
    • Sprint:
      OpenIDM Sprint 54

      Description

      openidm/db/oracle/scripts/openidm.sql:

      PROMPT Creating Index idx_links_first on links ...
      CREATE INDEX idx_links_first ON links
      (
        linktype,
        firstid
      )
      ;
      PROMPT Creating Index idx_links_second on links ...
      CREATE INDEX idx_links_second ON links
      (
        linktype,
        secondid
      )
      

      These indexes should be unique as same as other RDBMS indexes.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                jason.vincent jason vincent
                Reporter:
                kohei kohei
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: