Added index to the history table.

[gnucomo.git] / src / database / create.sql

diff --git a/src/database/create.sql b/src/database/create.sql
index 362fd86..1c3ba8d 100644 (file)
--- a/src/database/create.sql
+++ b/src/database/create.sql
@@ -12,7 +12,10 @@
 -- DBA create the database and give access permissions.
 --
 --  $Log: create.sql,v $
---  Revision 1.14  2003-07-09 07:14:59  arjen
+--  Revision 1.15  2003-08-05 07:43:24  arjen
+--  Added index to the history table.
+--
+--  Revision 1.14  2003/07/09 07:14:59  arjen
 --  New database tables: notification_check, notification_check_buffer,
 --  notification_check_line and object_statistics.
 --
@@ -160,6 +163,8 @@ CREATE TABLE "history"
 
 );
 
+CREATE INDEX history_pid_mod  ON history(paramid, modified);
+
 --
 --