diff options
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' |