summaryrefslogtreecommitdiff
path: root/database/database.pgsql
diff options
context:
space:
mode:
Diffstat (limited to 'database/database.pgsql')
-rw-r--r--database/database.pgsql1
1 files changed, 1 insertions, 0 deletions
diff --git a/database/database.pgsql b/database/database.pgsql
index 339549516..375281dfa 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -168,6 +168,7 @@ CREATE TABLE cache (
headers text default '',
PRIMARY KEY (cid)
);
+CREATE INDEX cache_expire_idx ON cache(expire);
--
-- Table structure for comments