From 88c9a015c16bcfc6312f539c13a320aa40d91aa9 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Mon, 1 Jun 2009 22:07:10 +0000
Subject: - Patch #111011 by Josh Waihi: adding foreign key specifications.

---
 modules/node/node.install | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'modules/node/node.install')

diff --git a/modules/node/node.install b/modules/node/node.install
index c6151d262..aa278adba 100644
--- a/modules/node/node.install
+++ b/modules/node/node.install
@@ -124,6 +124,10 @@ function node_schema() {
     'unique keys' => array(
       'vid' => array('vid'),
     ),
+    'foreign keys' => array(
+      'vid' => array('node_revision' => 'vid'),
+      'uid' => array('users' => 'uid'),
+    ),
     'primary key' => array('nid'),
   );
 
@@ -177,6 +181,7 @@ function node_schema() {
       ),
     ),
     'primary key' => array('nid', 'gid', 'realm'),
+    'foreign keys' => array('node' => 'nid'),
   );
 
   $schema['node_revision'] = array(
@@ -244,6 +249,10 @@ function node_schema() {
       'uid' => array('uid'),
     ),
     'primary key' => array('vid'),
+    'foreign keys' => array(
+      'node' => 'nid',
+      'users' => 'uid'
+    ),
   );
 
   $schema['node_type'] = array(
-- 
cgit v1.2.3