diff options
Diffstat (limited to 'src/org/fox/ttrss/DatabaseHelper.java')
| -rw-r--r-- | src/org/fox/ttrss/DatabaseHelper.java | 26 |
1 files changed, 21 insertions, 5 deletions
diff --git a/src/org/fox/ttrss/DatabaseHelper.java b/src/org/fox/ttrss/DatabaseHelper.java index f98d606d..35d564a0 100644 --- a/src/org/fox/ttrss/DatabaseHelper.java +++ b/src/org/fox/ttrss/DatabaseHelper.java @@ -10,14 +10,16 @@ public class DatabaseHelper extends SQLiteOpenHelper { private final String TAG = this.getClass().getSimpleName();
public static final String DATABASE_NAME = "LocalStorage";
+ public static final int DATABASE_VERSION = 4;
public DatabaseHelper(Context context) {
- super(context, DATABASE_NAME, null, 1);
+ super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
- Log.d(TAG, "onCreate");
+ db.execSQL("DROP TABLE IF EXISTS feeds;");
+ db.execSQL("DROP TABLE IF EXISTS articles;");
db.execSQL("CREATE TABLE IF NOT EXISTS feeds (" +
BaseColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
@@ -26,14 +28,28 @@ public class DatabaseHelper extends SQLiteOpenHelper { "unread INTEGER, " +
"has_icon BOOLEAN, " +
"cat_id INTEGER, " +
- "last_updated INTEGER)");
+ "last_updated INTEGER, " +
+ "count INTEGER" +
+ ");");
+ db.execSQL("CREATE TABLE IF NOT EXISTS articles (" +
+ BaseColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
+ "unread BOOLEAN, " +
+ "marked BOOLEAN, " +
+ "published BOOLEAN, " +
+ "updated INTEGER, " +
+ "is_updated BOOLEAN, " +
+ "title TEXT, " +
+ "link TEXT, " +
+ "feed_id INTEGER, " +
+ "tags TEXT, " +
+ "content TEXT" +
+ ");");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
- // TODO Auto-generated method stub
-
+ onCreate(db);
}
}
|