From d58d49bb9a85cd1ce5ab0622a9121f0ad183d43d Mon Sep 17 00:00:00 2001 From: tipaul Date: Thu, 17 Jun 2004 15:19:44 +0000 Subject: [PATCH] missing Marc_Search index on marc_word --- updater/updatedatabase | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/updater/updatedatabase b/updater/updatedatabase index 705975424f..3fbf4ff998 100755 --- a/updater/updatedatabase +++ b/updater/updatedatabase @@ -1168,6 +1168,7 @@ if ($marc_word{subfieldid}) { $dbh->do("update marc_word set tagsubfield=concat(tag,subfieldid)"); $dbh->do("alter table marc_word drop tag"); $dbh->do("alter table marc_word drop subfieldid"); + $dbh->do("create index Search_Marc on marc_word (tagsubfield,word)"); } # Populate tables with required data @@ -1220,6 +1221,9 @@ $sth->finish; exit; # $Log$ +# Revision 1.85 2004/06/17 15:19:44 tipaul +# missing Marc_Search index on marc_word +# # Revision 1.84 2004/06/17 08:25:21 tipaul # DB modifs : merging tag & subfield in marc_word table # -- 2.39.5