*** profile.install	Tue Jan  2 12:01:40 2007
--- profile.install.new	Tue Jan  2 12:15:28 2007
***************
*** 32,38 ****
          uid int unsigned default '0',
          value text,
          KEY uid (uid),
!         KEY fid (fid)
        ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
        break;
  
--- 32,38 ----
          uid int unsigned default '0',
          value text,
          KEY uid (uid),
!         UNIQUE KEY fiduid (fid, uid)
        ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
        break;
  
***************
*** 62,68 ****
          value text
        )");
        db_query("CREATE INDEX {profile_values}_uid_idx ON {profile_values} (uid)");
!       db_query("CREATE INDEX {profile_values}_fid_idx ON {profile_values} (fid)");
        break;
    }
  }
--- 62,68 ----
          value text
        )");
        db_query("CREATE INDEX {profile_values}_uid_idx ON {profile_values} (uid)");
!       db_query("CREATE UNIQUE INDEX {profile_values}_fiduid_idx ON {profile_values} (fid, uid)");
        break;
    }
  }