- Patch #164532 by catch, pwolanin, David Strauss, et al.: improve table indicies for common queries.

1 files changed, 3 insertions, 3 deletions

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')
     ),
   );