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

When I set $foreign_keys=true in in sql_generator.php, the ddl is not created.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: 1.9.5
    • Fix Version/s: None
    • Component/s: Database SQL/XMLDB
    • Labels:
      None
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_19_STABLE

      Description

      It seems that , $foreign_keys = true in sql_generator.php, foreign keys are defined on each table immediately after the table is created, even if the referenced table has not yet been created. To get the foreign keys, I changed sql_generator.php to create all the foreign keys only after creating all of the tables. A diff is attached.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

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

                  Dates

                  • Created:
                    Updated:
                    Resolved: