projects
/
gnucomo.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
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);
$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
/*
//These columns have to be removed when a new version of PGSQL has become mainstream that supportsa DROP COLUMN
/*