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

Increase the length of Institution and Department fields in user table

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.6
    • Fix Version/s: 2.6
    • Component/s: Database SQL/XMLDB
    • Labels:
    • Testing Instructions:
      Hide

      Add and edit users with the fields "Department", "Institution" and "Address" over 200 chars (new limit is 255). Make sure the fields are updated.

      1. Add/edit user using the usual form
      2. Add/edit user(s) using the "Upload users" tool (both in xml and form)
      3. Add/edit user using webservices
      Show
      Add and edit users with the fields "Department", "Institution" and "Address" over 200 chars (new limit is 255). Make sure the fields are updated. Add/edit user using the usual form Add/edit user(s) using the "Upload users" tool (both in xml and form) Add/edit user using webservices
    • Affected Branches:
      MOODLE_26_STABLE
    • Fixed Branches:
      MOODLE_26_STABLE
    • Pull Master Branch:
      wip-MDL-41715-master

      Description

      The length of institution field in user table is 40,
      the length of department field is 30.

      This could be not enough for many institutions and their departments.

      Please, change the length of this fields to a large value, 100 or more.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Votes:
                1 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  18/Nov/13