1 files changed, 51 insertions, 0 deletions
diff --git a/src/org/ryuslash/Dailies/SQLiteHelper.java b/src/org/ryuslash/Dailies/SQLiteHelper.java
new file mode 100644
index 0000000..0934f4e
--- /dev/null
+++ b/src/org/ryuslash/Dailies/SQLiteHelper.java
@@ -0,0 +1,51 @@
+package org.ryuslash.Dailies;
+
+import android.content.Context;
+import android.database.sqlite.SQLiteDatabase;
+import android.database.sqlite.SQLiteOpenHelper;
+import android.util.Log;
+
+public class SQLiteHelper extends SQLiteOpenHelper
+{
+    public static final String TABLE_DAILY = "daily";
+    public static final String COLUMN_ID = "id";
+    public static final String COLUMN_TITLE = "title";
+    public static final String COLUMN_ALARM = "alarm";
+    public static final String COLUMN_HOUR = "hour";
+    public static final String COLUMN_MINUTE = "minute";
+    public static final String COLUMN_LAST_COMPLETED = "last_completed";
+
+    private static final String DATABASE_NAME = "dailies.db";
+    private static final int DATABASE_VERSION = 1;
+
+    private static final String TABLE_DAILY_CREATE =
+        "CREATE TABLE " + TABLE_DAILY + " ("
+        + COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
+        + COLUMN_TITLE + " TEXT NOT NULL, "
+        + COLUMN_ALARM + " INTEGER NOT NULL, "
+        + COLUMN_HOUR + " INTEGER NULL, "
+        + COLUMN_MINUTE + " INTEGER NULL, "
+        + COLUMN_LAST_COMPLETED + " TEXT NULL "
+        + ");";
+
+    public SQLiteHelper(Context context)
+    {
+        super(context, DATABASE_NAME, null, DATABASE_VERSION);
+    }
+
+    @Override
+    public void onCreate(SQLiteDatabase database)
+    {
+        database.execSQL(TABLE_DAILY_CREATE);
+    }
+
+    @Override
+    public void onUpgrade(SQLiteDatabase db, int oldV, int newV)
+    {
+        Log.w(SQLiteHelper.class.getName(),
+              "Upgrading database from version " + oldV + " to "
+              + newV + ", which will destroy all old data");
+        db.execSQL("DROP TABLE IF EXISTS " + TABLE_DAILY);
+        onCreate(db);
+    }
+}