From f37cc4bb35cb8413b4baf37aa5247139168ccf4e Mon Sep 17 00:00:00 2001
From: toyomoyo <toyomoyo>
Date: Mon, 13 Aug 2007 02:11:59 +0000
Subject: [PATCH] MDL-10817, adding unique key courseid-coutcomeid during
 creation of grade_outcomes_courses

---
 lib/db/upgrade.php | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

diff --git a/lib/db/upgrade.php b/lib/db/upgrade.php
index b5199f15b9..1e856a6e8c 100644
--- a/lib/db/upgrade.php
+++ b/lib/db/upgrade.php
@@ -1459,9 +1459,10 @@ function xmldb_main_upgrade($oldversion=0) {
         $table->addKeyInfo('primary', XMLDB_KEY_PRIMARY, array('id'));
         $table->addKeyInfo('courseid', XMLDB_KEY_FOREIGN, array('courseid'), 'course', array('id'));
         $table->addKeyInfo('outcomeid', XMLDB_KEY_FOREIGN, array('outcomeid'), 'grade_outcomes', array('id'));
-
+        $table->addKeyInfo('courseid-outcomeid', XMLDB_KEY_UNIQUE, array('courseid', 'outcomeid'));
     /// Launch create table for grade_outcomes_courses
-        $result = $result && create_table($table);
+        $result = $result && create_table($table);        
+    
     }
 
 
-- 
2.39.5