Moodle

Improve XMLDB PHP code generation when one field has related indexes or keys

Details

  • Type: Sub-task Sub-task
  • Status: Closed Closed
  • Priority: Minor Minor
  • Resolution: Duplicate
  • Affects Version/s: 1.9
  • Fix Version/s: 2.0
  • Component/s: Database SQL/XMLDB
  • Labels:
    None
  • Environment:
    any
  • Database:
    Any
  • Affected Branches:
    MOODLE_19_STABLE
  • Fixed Branches:
    MOODLE_20_STABLE

Description

When obtaining PHP from the XMLDB editor (to be used in upgrade scripts). Make it a bit clever, detenting when one field has associated indexes / keys and providing the needed code to perform the modification properly:

1) Drop indexes / keys
2) Modify the field
3) Re-create indexes / keys

Ciao

Issue Links

This issue duplicates:
MDL-9271 XMLDB: Keys are lost when changing table settings Minor Open

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Martin Dougiamas added a comment -

Pushing new feature forward to 2.0

Show
Martin Dougiamas added a comment - Pushing new feature forward to 2.0
Hide
Permalink
Eloy Lafuente (stronk7) added a comment -

Resolving this as duplicate of MDL-9271 where the research and decision about how to fix this problem is evolving right no.

Show
Eloy Lafuente (stronk7) added a comment - Resolving this as duplicate of MDL-9271 where the research and decision about how to fix this problem is evolving right no.

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved:
Atlassian JIRA (v4.4.3#663-r165197) | Report a problem
Powered by a free Atlassian JIRA open source license for Moodle. Try JIRA - bug tracking software for your team.