From 7393ab7631bfe138263ea8ffe2be4e012908d6c9 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Fri, 9 Sep 2011 13:23:56 +0400 Subject: various activity lifecycle-related fixes --- src/org/fox/ttrss/DatabaseHelper.java | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'src/org/fox/ttrss/DatabaseHelper.java') diff --git a/src/org/fox/ttrss/DatabaseHelper.java b/src/org/fox/ttrss/DatabaseHelper.java index e9d350b9..b06a76f8 100644 --- a/src/org/fox/ttrss/DatabaseHelper.java +++ b/src/org/fox/ttrss/DatabaseHelper.java @@ -47,10 +47,11 @@ public class DatabaseHelper extends SQLiteOpenHelper { "content TEXT" + ");"); - db.execSQL("CREATE VIEW feeds_unread AS SELECT feeds._id AS _id, " + + db.execSQL("CREATE VIEW feeds_unread AS SELECT feeds."+BaseColumns._ID+" AS "+BaseColumns._ID+", " + "feeds.title AS title, " + "SUM(articles.unread) AS unread FROM feeds " + - "LEFT JOIN articles ON (articles.feed_id = feeds._id) GROUP BY feeds._id, feeds.title;"); + "LEFT JOIN articles ON (articles.feed_id = feeds."+BaseColumns._ID+") " + + "GROUP BY feeds."+BaseColumns._ID+", feeds.title;"); } @Override -- cgit v1.2.3-54-g00ecf