From 4de19d9296137f7797aa3bb227aa8fb9a3d8264d Mon Sep 17 00:00:00 2001
From: toyomoyo <toyomoyo>
Date: Fri, 20 Apr 2007 01:39:22 +0000
Subject: [PATCH] adding a new key

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

diff --git a/lib/db/install.xml b/lib/db/install.xml
index 6ad88b63f3..98f9892b15 100644
--- a/lib/db/install.xml
+++ b/lib/db/install.xml
@@ -1,5 +1,5 @@
 <?xml version="1.0" encoding="UTF-8" ?>
-<XMLDB PATH="lib/db" VERSION="20070418" COMMENT="XMLDB file for core Moodle tables"
+<XMLDB PATH="lib/db" VERSION="20070420" COMMENT="XMLDB file for core Moodle tables"
     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
     xsi:noNamespaceSchemaLocation="../../lib/xmldb/xmldb.xsd"
 >
@@ -1195,7 +1195,8 @@
         <FIELD NAME="handlerfunction" TYPE="text" LENGTH="medium" NOTNULL="false" SEQUENCE="false" ENUM="false" COMMENT="serialized string or array describing function, suitable to be passed to call_user_func()" PREVIOUS="handlerfile"/>
       </FIELDS>
       <KEYS>
-        <KEY NAME="primary" TYPE="primary" FIELDS="id" COMMENT="primary key of the table, please edit me"/>
+        <KEY NAME="primary" TYPE="primary" FIELDS="id" COMMENT="primary key of the table, please edit me" NEXT="eventname-handlermodule"/>
+        <KEY NAME="eventname-handlermodule" TYPE="unique" FIELDS="eventname, handlermodule" PREVIOUS="primary"/>
       </KEYS>
       <INDEXES>
         <INDEX NAME="eventname" UNIQUE="false" FIELDS="eventname"/>
-- 
2.39.5