Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-63835

Add index conversationid-userid to message_conversation_members table

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Deferred
    • Icon: Minor Minor
    • None
    • 3.6
    • Messages
    • MOODLE_36_STABLE
    • MDL-63835_master
    • Hide
      Test 1
      1. Do a fresh install.
      2. View the database table 'message_conversation_members'.
      3. Confirm there is a unique index for conversationid-userid.
      Test 2
      1. Do git checkout 208950cff04f87e16eb008cd395c2222ec6934a7
      2. Install your site.
      3. Do git checkout master
      4. Perform the upgrade.
      5. Confirm there is a unique index for conversationid-userid.
      Show
      Test 1 Do a fresh install. View the database table 'message_conversation_members'. Confirm there is a unique index for conversationid-userid . Test 2 Do git checkout 208950cff04f87e16eb008cd395c2222ec6934a7 Install your site. Do git checkout master Perform the upgrade. Confirm there is a unique index for conversationid-userid .

      At this moment in time a user can not be in the same conversation twice - if this does happen then it is a bug. Adding an index would prevent duplicate records and alert us to errors quicker.

            Unassigned Unassigned
            markn Mark Nelson
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.