alter_203_transition.sql

Clone Tools
  • last updated a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
LDEV-2903: remove upgrade sql scripts as now they are done by autopatch

  1. … 18 more files in changeset.
[LDEV-1229] Add unique index on transitions

For the 2.0.3 updater, existing duplicate rows need to be deleted from the lams_learning_transition table, this SQL code has been added to the alter_203_transition.sql

LDEV-1229: Add a unique key on the activity columns in transition. Somehow we are ending up with duplicate rows in the database, which stops the design being opened. This will stop the bad data being written to the database.

    • -0
    • +7
    ./alter_203_transition.sql
  1. … 3 more files in changeset.