From 388e9ab212468166c4ce9e8c2d0fdf4464e81c57 Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Wed, 9 Aug 2006 11:56:02 +0000
Subject: [PATCH] One more FK in blocks system.

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

diff --git a/blocks/db/install.xml b/blocks/db/install.xml
index 5669530262..b231f37fc6 100644
--- a/blocks/db/install.xml
+++ b/blocks/db/install.xml
@@ -1,5 +1,5 @@
 <?xml version="1.0" encoding="UTF-8" ?>
-<XMLDB PATH="blocks/db" VERSION="20060807" COMMENT="XMLDB file for Moodle block tables">
+<XMLDB PATH="blocks/db" VERSION="20060809" COMMENT="XMLDB file for Moodle block tables">
   <TABLES>
     <TABLE NAME="block" COMMENT="to store installed blocks" NEXT="block_instance">
       <FIELDS>
@@ -27,7 +27,8 @@
         <FIELD NAME="configdata" TYPE="text" LENGTH="small" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="visible"/>
       </FIELDS>
       <KEYS>
-        <KEY NAME="primary" TYPE="primary" FIELDS="id"/>
+        <KEY NAME="primary" TYPE="primary" FIELDS="id" NEXT="blockid"/>
+        <KEY NAME="blockid" TYPE="foreign" FIELDS="blockid" REFTABLE="block" REFFIELDS="id" PREVIOUS="primary"/>
       </KEYS>
       <INDEXES>
         <INDEX NAME="pageid" UNIQUE="false" FIELDS="pageid" NEXT="pagetype"/>
-- 
2.39.5