From 90c9c16f0e96ed08ce6ad93159f2aa8052acb1af Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Sat, 13 Nov 2010 19:26:29 +0300 Subject: schema: add index on ttrss_tags --- schema/ttrss_schema_pgsql.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index 152af5dd3..9c20681ad 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -215,6 +215,7 @@ create table ttrss_tags (id serial not null primary key, post_int_id integer references ttrss_user_entries(int_id) ON DELETE CASCADE not null); create index ttrss_tags_owner_uid_index on ttrss_tags(owner_uid); +create index ttrss_tags_post_int_id_idx on ttrss_tags(post_int_id); create table ttrss_version (schema_version int not null); -- cgit v1.2.3