package de.eightbitboy.hijacr.data.database;

import android.provider.BaseColumns;

public class ComicDatabaseContract {

	public ComicDatabaseContract() {
	}

	public static abstract class ComicDataEntry implements BaseColumns {
		public static final String TABLE_NAME = "comicdata";
		public static final String COLUMN_KEY = "title";
		public static final String COLUMN_PROGRESS_URL = "progressurl";
		public static final String COLUMN_PROGRESS_NUMBER = "progressnumber";

		//TODO add some statements for creating and deleting table
		public static final String CREATE_TABLE = "";
	}
}

@@ -223,16 +223,115 @@
 lumns %7B%0A
+%09%09private static final String TEXT_TYPE = %22 TEXT%22;%0A%09%09private static final String COMMA_SEP = %22,%22;%0A%0A
 %09%09public
@@ -377,16 +377,16 @@
 cdata%22;%0A
-
 %09%09public
@@ -573,66 +573,231 @@
 %0A%0A%09%09
-//TODO add some statements for creating and deleting table
+public static final String CREATE_TABLE =%0A%09%09%09%09%22CREATE TABLE %22 + TABLE_NAME + %22 (%22 +%0A%09%09%09%09%09%09_ID + %22 INTEGER PRIMARY KEY,%22 +%0A%09%09%09%09%09%09COLUMN_KEY + TEXT_TYPE + COMMA_SEP +%0A%09%09%09%09%09%09COLUMN_PROGRESS_URL + TEXT_TYPE + COMMA_SEP + %22 )%22;%0A
 %0A%09%09p
@@ -814,38 +814,36 @@
 ic final String 
-CREATE
+DROP
 _TABLE = %22%22;%0A%09%7D%0A
@@ -836,16 +836,50 @@
 ABLE = %22
-%22
+DROP TABLE IF EXISTS %22 + TABLE_NAME
 ;%0A%09%7D%0A%7D%0A

Add database statement