From 8409cec0dfd904bb0bcd3b0a808d6babacff3f5b Mon Sep 17 00:00:00 2001
From: tjhunt <tjhunt>
Date: Thu, 23 Oct 2008 07:30:12 +0000
Subject: [PATCH] qtype database definitions: MDL-16978 Lots of foreign key
definitions in install.xml files erroniously link to the questions table. It
should be question.
---
question/type/calculated/db/install.xml | 2 +-
question/type/match/db/install.xml | 4 ++--
question/type/multianswer/db/install.xml | 2 +-
question/type/multichoice/db/install.xml | 2 +-
question/type/numerical/db/install.xml | 2 +-
question/type/randomsamatch/db/install.xml | 2 +-
question/type/shortanswer/db/install.xml | 2 +-
question/type/truefalse/db/install.xml | 2 +-
8 files changed, 9 insertions(+), 9 deletions(-)
diff --git a/question/type/calculated/db/install.xml b/question/type/calculated/db/install.xml
index 2ff9edad0b..a4eebafb15 100644
--- a/question/type/calculated/db/install.xml
+++ b/question/type/calculated/db/install.xml
@@ -13,7 +13,7 @@
</FIELDS>
<KEYS>
<KEY NAME="primary" TYPE="primary" FIELDS="id" NEXT="question"/>
- <KEY NAME="question" TYPE="foreign" FIELDS="question" REFTABLE="questions" REFFIELDS="id" PREVIOUS="primary"/>
+ <KEY NAME="question" TYPE="foreign" FIELDS="question" REFTABLE="question" REFFIELDS="id" PREVIOUS="primary"/>
</KEYS>
<INDEXES>
<INDEX NAME="answer" UNIQUE="false" FIELDS="answer"/>
diff --git a/question/type/match/db/install.xml b/question/type/match/db/install.xml
index f02bbec075..39eb05114d 100644
--- a/question/type/match/db/install.xml
+++ b/question/type/match/db/install.xml
@@ -10,7 +10,7 @@
</FIELDS>
<KEYS>
<KEY NAME="primary" TYPE="primary" FIELDS="id" NEXT="question"/>
- <KEY NAME="question" TYPE="foreign" FIELDS="question" REFTABLE="questions" REFFIELDS="id" PREVIOUS="primary"/>
+ <KEY NAME="question" TYPE="foreign" FIELDS="question" REFTABLE="question" REFFIELDS="id" PREVIOUS="primary"/>
</KEYS>
</TABLE>
<TABLE NAME="question_match_sub" COMMENT="Defines the subquestions that make up a matching question" PREVIOUS="question_match">
@@ -23,7 +23,7 @@
</FIELDS>
<KEYS>
<KEY NAME="primary" TYPE="primary" FIELDS="id" NEXT="question"/>
- <KEY NAME="question" TYPE="foreign" FIELDS="question" REFTABLE="questions" REFFIELDS="id" PREVIOUS="primary"/>
+ <KEY NAME="question" TYPE="foreign" FIELDS="question" REFTABLE="question" REFFIELDS="id" PREVIOUS="primary"/>
</KEYS>
</TABLE>
</TABLES>
diff --git a/question/type/multianswer/db/install.xml b/question/type/multianswer/db/install.xml
index 90f056f994..2b1f27054d 100644
--- a/question/type/multianswer/db/install.xml
+++ b/question/type/multianswer/db/install.xml
@@ -9,7 +9,7 @@
</FIELDS>
<KEYS>
<KEY NAME="primary" TYPE="primary" FIELDS="id" NEXT="question"/>
- <KEY NAME="question" TYPE="foreign" FIELDS="question" REFTABLE="questions" REFFIELDS="id" PREVIOUS="primary"/>
+ <KEY NAME="question" TYPE="foreign" FIELDS="question" REFTABLE="question" REFFIELDS="id" PREVIOUS="primary"/>
</KEYS>
</TABLE>
</TABLES>
diff --git a/question/type/multichoice/db/install.xml b/question/type/multichoice/db/install.xml
index 8c32728467..0c3183a718 100644
--- a/question/type/multichoice/db/install.xml
+++ b/question/type/multichoice/db/install.xml
@@ -19,7 +19,7 @@
</FIELDS>
<KEYS>
<KEY NAME="primary" TYPE="primary" FIELDS="id" NEXT="question"/>
- <KEY NAME="question" TYPE="foreign" FIELDS="question" REFTABLE="questions" REFFIELDS="id" PREVIOUS="primary"/>
+ <KEY NAME="question" TYPE="foreign" FIELDS="question" REFTABLE="question" REFFIELDS="id" PREVIOUS="primary"/>
</KEYS>
</TABLE>
</TABLES>
diff --git a/question/type/numerical/db/install.xml b/question/type/numerical/db/install.xml
index 7c350d5893..81223fd3e6 100644
--- a/question/type/numerical/db/install.xml
+++ b/question/type/numerical/db/install.xml
@@ -10,7 +10,7 @@
</FIELDS>
<KEYS>
<KEY NAME="primary" TYPE="primary" FIELDS="id" NEXT="question"/>
- <KEY NAME="question" TYPE="foreign" FIELDS="question" REFTABLE="questions" REFFIELDS="id" PREVIOUS="primary"/>
+ <KEY NAME="question" TYPE="foreign" FIELDS="question" REFTABLE="question" REFFIELDS="id" PREVIOUS="primary"/>
</KEYS>
<INDEXES>
<INDEX NAME="answer" UNIQUE="false" FIELDS="answer"/>
diff --git a/question/type/randomsamatch/db/install.xml b/question/type/randomsamatch/db/install.xml
index b1f93e815b..9500076eed 100644
--- a/question/type/randomsamatch/db/install.xml
+++ b/question/type/randomsamatch/db/install.xml
@@ -9,7 +9,7 @@
</FIELDS>
<KEYS>
<KEY NAME="primary" TYPE="primary" FIELDS="id" NEXT="question"/>
- <KEY NAME="question" TYPE="foreign" FIELDS="question" REFTABLE="questions" REFFIELDS="id" PREVIOUS="primary"/>
+ <KEY NAME="question" TYPE="foreign" FIELDS="question" REFTABLE="question" REFFIELDS="id" PREVIOUS="primary"/>
</KEYS>
</TABLE>
</TABLES>
diff --git a/question/type/shortanswer/db/install.xml b/question/type/shortanswer/db/install.xml
index 086e6f9244..f6e4030349 100644
--- a/question/type/shortanswer/db/install.xml
+++ b/question/type/shortanswer/db/install.xml
@@ -10,7 +10,7 @@
</FIELDS>
<KEYS>
<KEY NAME="primary" TYPE="primary" FIELDS="id" NEXT="question"/>
- <KEY NAME="question" TYPE="foreign" FIELDS="question" REFTABLE="questions" REFFIELDS="id" PREVIOUS="primary"/>
+ <KEY NAME="question" TYPE="foreign" FIELDS="question" REFTABLE="question" REFFIELDS="id" PREVIOUS="primary"/>
</KEYS>
</TABLE>
</TABLES>
diff --git a/question/type/truefalse/db/install.xml b/question/type/truefalse/db/install.xml
index b31563e962..8e259f13fe 100644
--- a/question/type/truefalse/db/install.xml
+++ b/question/type/truefalse/db/install.xml
@@ -10,7 +10,7 @@
</FIELDS>
<KEYS>
<KEY NAME="primary" TYPE="primary" FIELDS="id" NEXT="question"/>
- <KEY NAME="question" TYPE="foreign" FIELDS="question" REFTABLE="questions" REFFIELDS="id" PREVIOUS="primary"/>
+ <KEY NAME="question" TYPE="foreign" FIELDS="question" REFTABLE="question" REFFIELDS="id" PREVIOUS="primary"/>
</KEYS>
</TABLE>
</TABLES>
--
2.39.5