MDL-33555 fix invalid FK in mod_assign

There is no need to upgrade DB because we create only indexes now.

diff --git a/mod/assign/feedback/comments/db/install.xml b/mod/assign/feedback/comments/db/install.xml
index 3096e18..9435982 100644 (file)
--- a/mod/assign/feedback/comments/db/install.xml
+++ b/mod/assign/feedback/comments/db/install.xml
@@ -15,7 +15,7 @@
       <KEYS>
         <KEY NAME="primary" TYPE="primary" FIELDS="id" COMMENT="The unique id for this feedback" NEXT="assignment"/>
         <KEY NAME="assignment" TYPE="foreign" FIELDS="assignment" REFTABLE="assign" REFFIELDS="id" COMMENT="The assignment instance this feedback relates to." PREVIOUS="primary" NEXT="grade"/>
-        <KEY NAME="grade" TYPE="foreign" FIELDS="grade" REFTABLE="assign_grade" REFFIELDS="id" COMMENT="The grade instance this feedback relates to." PREVIOUS="assignment"/>
+        <KEY NAME="grade" TYPE="foreign" FIELDS="grade" REFTABLE="assign_grades" REFFIELDS="id" COMMENT="The grade instance this feedback relates to." PREVIOUS="assignment"/>
       </KEYS>
     </TABLE>
   </TABLES>

diff --git a/mod/assign/feedback/file/db/install.xml b/mod/assign/feedback/file/db/install.xml
index 7aa96c5..aecb0cc 100644 (file)
--- a/mod/assign/feedback/file/db/install.xml
+++ b/mod/assign/feedback/file/db/install.xml
@@ -14,7 +14,7 @@
       <KEYS>
         <KEY NAME="primary" TYPE="primary" FIELDS="id" COMMENT="Unique id for this feedback value." NEXT="assignment"/>
         <KEY NAME="assignment" TYPE="foreign" FIELDS="assignment" REFTABLE="assign" REFFIELDS="id" COMMENT="The assignment instance this feedback relates to." PREVIOUS="primary" NEXT="grade"/>
-        <KEY NAME="grade" TYPE="foreign" FIELDS="grade" REFTABLE="assign_grade" REFFIELDS="id" COMMENT="The grade instance this feedback relates to." PREVIOUS="assignment"/>
+        <KEY NAME="grade" TYPE="foreign" FIELDS="grade" REFTABLE="assign_grades" REFFIELDS="id" COMMENT="The grade instance this feedback relates to." PREVIOUS="assignment"/>
       </KEYS>
     </TABLE>
   </TABLES>