diff options
| author | Andrew Dolgov <fox@madoka.volgo-balt.ru> | 2011-09-09 13:23:56 +0400 |
|---|---|---|
| committer | Andrew Dolgov <fox@madoka.volgo-balt.ru> | 2011-09-09 13:23:56 +0400 |
| commit | 7393ab7631bfe138263ea8ffe2be4e012908d6c9 (patch) | |
| tree | f8566f19e0f5cab65fd773c8939f24aa19442f9e /src/org/fox/ttrss/DatabaseHelper.java | |
| parent | 38028b1e7e47b239a4942c851a04c9903fc684c3 (diff) | |
various activity lifecycle-related fixes
Diffstat (limited to 'src/org/fox/ttrss/DatabaseHelper.java')
| -rw-r--r-- | src/org/fox/ttrss/DatabaseHelper.java | 5 |
1 files changed, 3 insertions, 2 deletions
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
|