From c8b1ddf26a299016c433c2901e519942d693430d Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Tue, 18 Dec 2007 12:59:22 +0000
Subject: - Patch #164532 by catch, pwolanin, David Strauss, et al.: improve
 table indicies for common queries.

---
 modules/profile/profile.install | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'modules/profile')

diff --git a/modules/profile/profile.install b/modules/profile/profile.install
index 1082fcb92..f05bccd80 100644
--- a/modules/profile/profile.install
+++ b/modules/profile/profile.install
@@ -119,14 +119,14 @@ function profile_schema() {
       'fid' => array(
         'type' => 'int',
         'unsigned' => TRUE,
-        'not null' => FALSE,
+        'not null' => TRUE,
         'default' => 0,
         'description' => t('The {profile_fields}.fid of the field.'),
       ),
       'uid' => array(
         'type' => 'int',
         'unsigned' => TRUE,
-        'not null' => FALSE,
+        'not null' => TRUE,
         'default' => 0,
         'description' => t('The {users}.uid of the profile user.'),
       ),
@@ -136,9 +136,9 @@ function profile_schema() {
         'description' => t('The value for the field.'),
       ),
     ),
+    'primary key' => array('uid', 'fid'),
     'indexes' => array(
       'fid' => array('fid'),
-      'uid' => array('uid')
     ),
   );
 
-- 
cgit v1.2.3