1 files changed, 10 insertions, 0 deletions
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;