diff options
| author | Andrew Dolgov <fox+ttrss@fakecake.org> | 2013-04-26 01:37:55 -0700 |
|---|---|---|
| committer | Andrew Dolgov <fox+ttrss@fakecake.org> | 2013-04-26 01:37:55 -0700 |
| commit | 2bb0a6c44f778b19c70244f7c47457f7ecfa297c (patch) | |
| tree | 1f5b5dbc69839cc36b49a4b6d292becf2cb2fd8f /src/org/fox/ttrss/util/DatabaseHelper.java | |
| parent | f9889788fced67fe3c849eda7d40f460090e2020 (diff) | |
| parent | a771ad16cfade4e1f7a7c693e316188a138d7d65 (diff) | |
Merge pull request #28 from janxbar/master
Support for score and other minor enhancements
Diffstat (limited to 'src/org/fox/ttrss/util/DatabaseHelper.java')
| -rw-r--r-- | src/org/fox/ttrss/util/DatabaseHelper.java | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/src/org/fox/ttrss/util/DatabaseHelper.java b/src/org/fox/ttrss/util/DatabaseHelper.java index cf5380e0..572ff62e 100644 --- a/src/org/fox/ttrss/util/DatabaseHelper.java +++ b/src/org/fox/ttrss/util/DatabaseHelper.java @@ -10,7 +10,7 @@ public class DatabaseHelper extends SQLiteOpenHelper { @SuppressWarnings("unused") private final String TAG = this.getClass().getSimpleName(); public static final String DATABASE_NAME = "OfflineStorage.db"; - public static final int DATABASE_VERSION = 3; + public static final int DATABASE_VERSION = 4; public DatabaseHelper(Context context) { super(context, DATABASE_NAME, null, DATABASE_VERSION); @@ -18,11 +18,12 @@ public class DatabaseHelper extends SQLiteOpenHelper { @Override public void onCreate(SQLiteDatabase db) { + db.execSQL("DROP VIEW IF EXISTS cats_unread;"); + db.execSQL("DROP VIEW IF EXISTS feeds_unread;"); + db.execSQL("DROP TRIGGER IF EXISTS articles_set_modified;"); db.execSQL("DROP TABLE IF EXISTS categories;"); db.execSQL("DROP TABLE IF EXISTS feeds;"); db.execSQL("DROP TABLE IF EXISTS articles;"); - db.execSQL("DROP VIEW IF EXISTS feeds_unread;"); - db.execSQL("DROP TRIGGER IF EXISTS articles_set_modified;"); db.execSQL("CREATE TABLE IF NOT EXISTS feeds (" + BaseColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + @@ -42,6 +43,7 @@ public class DatabaseHelper extends SQLiteOpenHelper { "unread BOOLEAN, " + "marked BOOLEAN, " + "published BOOLEAN, " + + "score INTEGER, " + "updated INTEGER, " + "is_updated BOOLEAN, " + "title TEXT, " + @@ -49,6 +51,7 @@ public class DatabaseHelper extends SQLiteOpenHelper { "feed_id INTEGER, " + "tags TEXT, " + "content TEXT, " + + "author TEXT, " + "selected BOOLEAN, " + "modified BOOLEAN" + ");"); |