From bf9fb81f75de8fd29050967fcd6f4f87ecae1cd3 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@madoka.volgo-balt.ru>
Date: Sun, 14 Nov 2010 17:29:07 +0300
Subject: schema: add ttrss_entries(updated) idx

---
 schema/ttrss_schema_pgsql.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'schema/ttrss_schema_pgsql.sql')

diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index 3db139037..dd62d17b0 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -128,6 +128,7 @@ create table ttrss_entries (id serial not null primary key,
 create index ttrss_entries_guid_index on ttrss_entries(guid);
 -- create index ttrss_entries_title_index on ttrss_entries(title);
 create index ttrss_entries_date_entered_index on ttrss_entries(date_entered);
+create index ttrss_entries_updated_idx on ttrss_entries(updated);
 
 create table ttrss_user_entries (
 	int_id serial not null primary key,
-- 
cgit v1.2.3

