diff options
| author | Dries Buytaert <dries@buytaert.net> | 2004-06-30 07:26:02 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2004-06-30 07:26:02 +0000 |
| commit | e3e051cc0de5b76fa974a83ef69c3fe003012725 (patch) | |
| tree | d5ee810f0f5a730317b7f1e0e7f459c515f7b003 /database/database.pgsql | |
| parent | 4f001824232f774e84da6bb03bb362a15e5f2590 (diff) | |
| download | brdo-e3e051cc0de5b76fa974a83ef69c3fe003012725.tar.gz brdo-e3e051cc0de5b76fa974a83ef69c3fe003012725.tar.bz2 | |
- Patch #8585 by Junyor: sort blog items by creation date. Added some database indices.
Diffstat (limited to 'database/database.pgsql')
| -rw-r--r-- | database/database.pgsql | 2 |
1 files changed, 2 insertions, 0 deletions
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' |