Change Foreign Key on metrics.clickstream from UPDATE/DELETE CASCADE to NULL

XMLWordPrintable

    • Type: Defect
    • Resolution: Done
    • Priority: Trivial
    • Recycle Bin
    • Affects Version/s: 1.2.0-BETA1
    • Component/s: Database
    • None

      The foreign key from metrics.clickstream to metrics.user_agent is the following:

      CONSTRAINT fkey_clickstream_2 FOREIGN KEY (user_agent_id)
            REFERENCES metrics.user_agent (id) MATCH FULL
            ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED


      We might consider changing the ON DELETE CASCADE to ON DELETE SET NULL since having a user_agent_id is not required.

              Assignee:
              Nathan Hook
              Reporter:
              Nathan Hook
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: