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

Make userid,fieldid unique in user_info_data

    XMLWordPrintable

Details

    • MySQL
    • MOODLE_26_STABLE
    • MOODLE_27_STABLE
    • Hide

      Testing upgrade:

      • Insert duplicate records in mdl_user_info_data for the same userid/fieldid.
      • Run upgrade.
      • Verify that upgrade succeeds and no duplicate entries exists in mdl_user_info_data.
      • Create a user profile field via standard ui
      • Create a script that try to insert records with same userid,fieldid into mdl_user_info_data table and verify that this insertions will fail at database level
      Show
      Testing upgrade: Insert duplicate records in mdl_user_info_data for the same userid/fieldid. Run upgrade. Verify that upgrade succeeds and no duplicate entries exists in mdl_user_info_data. Create a user profile field via standard ui Create a script that try to insert records with same userid,fieldid into mdl_user_info_data table and verify that this insertions will fail at database level

    Description

      Looking at the custom profile fields API and use cases, it seems that the key added by MDL-17201 should be unique.

      Attachments

        Issue Links

          Activity

            People

              danielneis Daniel Neis Araujo
              danielneis Daniel Neis Araujo
              Rex Lorenzo Rex Lorenzo
              Marina Glancy Marina Glancy
              Marina Glancy Marina Glancy
              Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                12/May/14