Added index to the history table.

[gnucomo.git] / src / gcm_daemon / classes / gnucomo_db_version.php

diff --git a/src/gcm_daemon/classes/gnucomo_db_version.php b/src/gcm_daemon/classes/gnucomo_db_version.php
index ff05e7e..caea052 100644 (file)
--- a/src/gcm_daemon/classes/gnucomo_db_version.php
+++ b/src/gcm_daemon/classes/gnucomo_db_version.php
@@ -425,6 +425,10 @@ case 40:
      $local_sql  = "CREATE INDEX obj_stat_objid ON object_statistics USING btree (objectid)";
      $dbms->query($local_sql);
 
+case 41:
+     $local_sql = "CREATE INDEX history_pid_mod  ON history(paramid, modified)";
+     $dbms->query($local_sql);
+
 //These columns have to be removed when a new version of PGSQL has become mainstream that supportsa DROP COLUMN
 /*