From f976b25c1edf0bc4871cb66b1c20e8b3b5669a6d Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@fakecake.org>
Date: Thu, 8 Sep 2011 20:05:00 +0400
Subject: rework authentication base feedlist adapter on sqlite

---
 src/org/fox/ttrss/DatabaseHelper.java | 39 +++++++++++++++++++++++++++++++++++
 1 file changed, 39 insertions(+)
 create mode 100644 src/org/fox/ttrss/DatabaseHelper.java

(limited to 'src/org/fox/ttrss/DatabaseHelper.java')

diff --git a/src/org/fox/ttrss/DatabaseHelper.java b/src/org/fox/ttrss/DatabaseHelper.java
new file mode 100644
index 00000000..f98d606d
--- /dev/null
+++ b/src/org/fox/ttrss/DatabaseHelper.java
@@ -0,0 +1,39 @@
+package org.fox.ttrss;
+import android.content.Context;
+import android.database.sqlite.SQLiteDatabase;
+import android.database.sqlite.SQLiteOpenHelper;
+import android.provider.BaseColumns;
+import android.util.Log;
+
+
+public class DatabaseHelper extends SQLiteOpenHelper {
+
+	private final String TAG = this.getClass().getSimpleName();
+	public static final String DATABASE_NAME = "LocalStorage";
+	
+	public DatabaseHelper(Context context) {
+		super(context, DATABASE_NAME, null, 1);
+	}
+	
+	@Override
+	public void onCreate(SQLiteDatabase db) {
+		Log.d(TAG, "onCreate");
+		
+		db.execSQL("CREATE TABLE IF NOT EXISTS feeds (" +
+                BaseColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
+                "feed_url TEXT, " +
+                "title TEXT, " +
+                "unread INTEGER, " +
+                "has_icon BOOLEAN, " +
+                "cat_id INTEGER, " +
+                "last_updated INTEGER)");                
+
+	}
+
+	@Override
+	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
+		// TODO Auto-generated method stub
+
+	}
+
+}
-- 
cgit v1.2.3-54-g00ecf