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/user/user.install | 10 ++++++++++
 1 file changed, 10 insertions(+)

(limited to 'modules/user')

diff --git a/modules/user/user.install b/modules/user/user.install
index 9fb394d4e..5fdc54ecb 100644
--- a/modules/user/user.install
+++ b/modules/user/user.install
@@ -44,6 +44,9 @@ function user_schema() {
       'authname' => array('authname'),
     ),
     'primary key' => array('aid'),
+    'foreign keys' => array(
+      'uid' => array('users' => 'uid'),
+    ),
   );
 
   $schema['role_permission'] = array(
@@ -67,6 +70,9 @@ function user_schema() {
     'indexes' => array(
       'permission' => array('permission'),
     ),
+    'foreign keys' => array(
+      'rid' => array('role' => 'rid'),
+    ),
   );
 
   $schema['role'] = array(
@@ -228,6 +234,10 @@ function user_schema() {
     'indexes' => array(
       'rid' => array('rid'),
     ),
+    'foreign keys' => array(
+      'uid' => array('users' => 'uid'),
+      'rid' => array('role' => 'rid'),
+    ),
   );
 
   return $schema;
-- 
cgit v1.2.3