From 433a13bc22300ed6d528659c78ace8c3b0abe701 Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Wed, 9 Aug 2006 15:45:27 +0000
Subject: [PATCH] index2fk performed

---
 enrol/authorize/db/install.xml | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

diff --git a/enrol/authorize/db/install.xml b/enrol/authorize/db/install.xml
index 409f1e86a9..c3726c30b2 100644
--- a/enrol/authorize/db/install.xml
+++ b/enrol/authorize/db/install.xml
@@ -1,5 +1,5 @@
 <?xml version="1.0" encoding="UTF-8" ?>
-<XMLDB PATH="enrol/authorize/db" VERSION="20060807" COMMENT="XMLDB file for Moodle enrol/authorize">
+<XMLDB PATH="enrol/authorize/db" VERSION="20060809" COMMENT="XMLDB file for Moodle enrol/authorize">
   <TABLES>
     <TABLE NAME="enrol_authorize" COMMENT="Holds all known information about authorize.net transactions" NEXT="enrol_authorize_refunds">
       <FIELDS>
@@ -35,11 +35,11 @@
         <FIELD NAME="settletime" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="transid"/>
       </FIELDS>
       <KEYS>
-        <KEY NAME="primary" TYPE="primary" FIELDS="id" COMMENT="Primary key for enrol_authorize_refunds"/>
+        <KEY NAME="primary" TYPE="primary" FIELDS="id" COMMENT="Primary key for enrol_authorize_refunds" NEXT="orderid"/>
+        <KEY NAME="orderid" TYPE="foreign" FIELDS="orderid" REFTABLE="enrol_authorize" REFFIELDS="id" COMMENT="Default comment for the key, please edit me" PREVIOUS="primary"/>
       </KEYS>
       <INDEXES>
-        <INDEX NAME="orderid" UNIQUE="false" FIELDS="orderid" NEXT="transid"/>
-        <INDEX NAME="transid" UNIQUE="false" FIELDS="transid" PREVIOUS="orderid"/>
+        <INDEX NAME="transid" UNIQUE="false" FIELDS="transid"/>
       </INDEXES>
     </TABLE>
   </TABLES>
-- 
2.39.5