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

`tag` table should not store userid

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 3.3.4, 3.4.1, 3.5
    • Fix Version/s: None
    • Component/s: Tags
    • Labels:
      None
    • Affected Branches:
      MOODLE_33_STABLE, MOODLE_34_STABLE, MOODLE_35_STABLE

      Description

      The tag table stores, amongst others, a userid field.

      This userid field needs to be dropped as it has no real purpose and contains incorrect data.

      The tag table has a unique constraint containing the tagcollid, and name, but does not consider the userid.

      Replication
      1. Create two courses and two editing teachers (or above)
      2. Edit the first course as the first user, and tag it with something new (e.g. abc)
      3. Edit the second course as the second user and expand the Tag section:
        1. Note how there are no suggestions at the moment
      4. Enter the same tag (abc) and save changes
      5. Inspect the tag table in the database:
        1. Note how there is only one entry for your new tag
        2. Note how that entry has the userid of the first user to use the tag

      Why does this matter? Because GDPR.t

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              dobedobedoh Andrew Nicols
              Participants:
              Component watchers:
              Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona), Víctor Déniz Falcón
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: