[Koha-cvs] koha/updater updatedatabase [rel_3_0]

[paul poulain]

CVSROOT:	/sources/koha
Module name:	koha
Branch:		rel_3_0
Changes by:	paul poulain <tipaul>	07/01/30 10:50:19

Modified files:
	updater        : updatedatabase 

Log message:
	adding 2 usefull indexes to biblioitems table

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/updater/updatedatabase?cvsroot=koha&only_with_tag=rel_3_0&r1=1.157.2.54&r2=1.157.2.55

Patches:
Index: updatedatabase
===================================================================
RCS file: /sources/koha/koha/updater/updatedatabase,v
retrieving revision 1.157.2.54
retrieving revision 1.157.2.55
diff -u -b -r1.157.2.54 -r1.157.2.55
--- updatedatabase	29 Jan 2007 16:45:52 -0000	1.157.2.54
+++ updatedatabase	30 Jan 2007 10:50:19 -0000	1.157.2.55
@@ -1,6 +1,6 @@
 #!/usr/bin/perl
 
-# $Id: updatedatabase,v 1.157.2.54 2007/01/29 16:45:52 toins Exp $
+# $Id: updatedatabase,v 1.157.2.55 2007/01/30 10:50:19 tipaul Exp $
 
 # Database Updater
 # This script checks for required updates to the database.
@@ -1027,22 +1027,6 @@
 #         {    indexname => 'index detail'
 #         }
 #    ],
-    shelfcontents => [
-        {    indexname => 'shelfnumber',
-            content => 'shelfnumber',
-        },
-        {    indexname => 'itemnumber',
-            content => 'itemnumber',
-        }
-    ],
-    items => [
-        {    indexname => 'homebranch',
-            content => 'homebranch',
-        },
-        {    indexname => 'holdingbranch',
-            content => 'holdingbranch',
-        }
-    ],
     aqbooksellers => [
         {    indexname => 'PRIMARY',
             content => 'id',
@@ -1067,6 +1051,21 @@
             content => 'bookfundid',
         },
     ],
+    biblioitems => [
+        {    indexname => 'isbn',
+            content => 'isbn',
+        },
+        {    indexname => 'publishercode',
+            content => 'publishercode',
+        },
+    ],
+    branches => [
+        {
+            indexname => 'branchcode',
+            content   => 'branchcode',
+    
+        }
+    ],
     currency => [
         {    indexname => 'PRIMARY',
             content => 'currency',
@@ -1077,24 +1076,30 @@
         {
             indexname => 'categorycode',
             content   => 'categorycode',
-    
         }
     ],
-     
+    items => [
+        {    indexname => 'homebranch',
+            content => 'homebranch',
+        },
+        {    indexname => 'holdingbranch',
+            content => 'holdingbranch',
+        }
+    ],
     itemtypes => [
         {
             indexname => 'itemtype',
             content   => 'itemtype',
-    
         }
     ],
-    branches => [
-        {
-            indexname => 'branchcode',
-            content   => 'branchcode',
-    
+    shelfcontents => [
+        {    indexname => 'shelfnumber',
+            content => 'shelfnumber',
+        },
+        {    indexname => 'itemnumber',
+            content => 'itemnumber',
         }
-    ]
+    ],
 );
 
 my %foreign_keys = (
@@ -1956,6 +1961,9 @@
 exit;
 
 # $Log: updatedatabase,v $
+# Revision 1.157.2.55  2007/01/30 10:50:19  tipaul
+# adding 2 usefull indexes to biblioitems table
+#
 # Revision 1.157.2.54  2007/01/29 16:45:52  toins
 # * adding a new default authorised value : SUGGEST.
 # SUGGEST give some reasons to accept or reject a suggestion.