From 6bb15d29daac4b39d2b184928d5c4fa50e7456ab Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Sat, 17 Nov 2007 14:01:24 +0000 Subject: - Patch #192348 by douggreen and bjaspan: fixed database inconsistencies. --- modules/search/search.install | 2 +- modules/system/system.install | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) (limited to 'modules') diff --git a/modules/search/search.install b/modules/search/search.install index 168e17959..ff8f692de 100644 --- a/modules/search/search.install +++ b/modules/search/search.install @@ -55,7 +55,7 @@ function search_schema() { 'description' => t('Set to force node reindexing.'), ), ), - 'indexes' => array('sid_type' => array('sid', 'type')), + 'unique keys' => array('sid_type' => array('sid', 'type')), ); $schema['search_index'] = array( diff --git a/modules/system/system.install b/modules/system/system.install index f51c2e54c..03250d52c 100644 --- a/modules/system/system.install +++ b/modules/system/system.install @@ -4515,7 +4515,7 @@ function system_update_6036() { // Since it's possible that some existing sites have duplicates, // create the index using the IGNORE keyword, which ignores duplicate errors. // However, pgsql doesn't support it - $ret[] = update_sql("ALTER IGNORE TABLE {search_index} ADD UNIQUE KEY sid_word_type (sid, word, type)"); + $ret[] = update_sql("ALTER IGNORE TABLE {search_index} ADD UNIQUE KEY word_sid_type (word, sid, type)"); $ret[] = update_sql("ALTER IGNORE TABLE {search_dataset} ADD UNIQUE KEY sid_type (sid, type)"); } else { -- cgit v1.2.3