From 49025df359896598da9e48790e096bcb16c3e8e7 Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Fri, 11 Aug 2006 18:36:47 +0000
Subject: [PATCH] Added one comment about recursive FK for the future.

---
 mod/forum/db/install.xml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/mod/forum/db/install.xml b/mod/forum/db/install.xml
index 92c8f6d503..557af63192 100644
--- a/mod/forum/db/install.xml
+++ b/mod/forum/db/install.xml
@@ -73,7 +73,7 @@
       <KEYS>
         <KEY NAME="primary" TYPE="primary" FIELDS="id" COMMENT="Primary key for forum_posts" NEXT="discussion"/>
         <KEY NAME="discussion" TYPE="foreign" FIELDS="discussion" REFTABLE="forum_discussions" REFFIELDS="id" PREVIOUS="primary" NEXT="parent"/>
-        <KEY NAME="parent" TYPE="foreign" FIELDS="parent" REFTABLE="forum_posts" REFFIELDS="id" PREVIOUS="discussion"/>
+        <KEY NAME="parent" TYPE="foreign" FIELDS="parent" REFTABLE="forum_posts" REFFIELDS="id" COMMENT="note that to make this recursive FK working someday, the parent field must be decalred NULL" PREVIOUS="discussion"/>
       </KEYS>
       <INDEXES>
         <INDEX NAME="userid" UNIQUE="false" FIELDS="userid" NEXT="created"/>
-- 
2.39.5