From 6f398232e6184897aaefe88c17c3f36b57cb5fd9 Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Sat, 12 Aug 2006 21:40:30 +0000
Subject: [PATCH] Added une foreign+unique key

---
 mod/quiz/db/install.xml | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/mod/quiz/db/install.xml b/mod/quiz/db/install.xml
index e5faf002e5..026480fb78 100755
--- a/mod/quiz/db/install.xml
+++ b/mod/quiz/db/install.xml
@@ -1,5 +1,5 @@
 <?xml version="1.0" encoding="UTF-8" ?>
-<XMLDB PATH="mod/quiz/db" VERSION="20060811" COMMENT="XMLDB file for Moodle mod/quiz">
+<XMLDB PATH="mod/quiz/db" VERSION="20060812" COMMENT="XMLDB file for Moodle mod/quiz">
   <TABLES>
     <TABLE NAME="question_categories" COMMENT="Categories are for grouping questions" NEXT="question">
       <FIELDS>
@@ -215,7 +215,7 @@
       </FIELDS>
       <KEYS>
         <KEY NAME="primary" TYPE="primary" FIELDS="id" COMMENT="Primary key for quiz_attempts" NEXT="uniqueid"/>
-        <KEY NAME="uniqueid" TYPE="foreign" FIELDS="uniqueid" REFTABLE="question_attempts" REFFIELDS="id" PREVIOUS="primary" NEXT="quiz"/>
+        <KEY NAME="uniqueid" TYPE="foreign-unique" FIELDS="uniqueid" REFTABLE="question_attempts" REFFIELDS="id" PREVIOUS="primary" NEXT="quiz"/>
         <KEY NAME="quiz" TYPE="foreign" FIELDS="quiz" REFTABLE="quiz" REFFIELDS="id" PREVIOUS="uniqueid"/>
       </KEYS>
       <INDEXES>
-- 
2.39.5