-- 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.
--
);
+CREATE INDEX history_pid_mod ON history(paramid, modified);
+
--
--
$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
/*