From e3e051cc0de5b76fa974a83ef69c3fe003012725 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Wed, 30 Jun 2004 07:26:02 +0000 Subject: - Patch #8585 by Junyor: sort blog items by creation date. Added some database indices. --- database/database.pgsql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'database/database.pgsql') diff --git a/database/database.pgsql b/database/database.pgsql index 73c737a33..65a18c73c 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -336,6 +336,8 @@ CREATE INDEX node_status_idx ON node(status); CREATE INDEX node_uid_idx ON node(uid); CREATE INDEX node_moderate_idx ON node (moderate); CREATE INDEX node_promote_status_idx ON node (promote, status); +CREATE INDEX node_created ON node(created); +CREATE INDEX node_changed ON node(changed); -- -- Table structure for table 'node_counter' -- cgit v1.2.3