static final String DB = "shiftCal.db";
static final int DB_VERSION = 1;
static final String CREATE_TABLE = "create table mytable ( _id integer primary key autoincrement, data integer not null );";
static final String DROP_TABLE = "drop table mytable;";

private static class MySQLiteOpenHelper extends SQLiteOpenHelper {
    public MySQLiteOpenHelper(Context c) {
        super(c, DB, null, DB_VERSION);
    }
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(CREATE_TABLE);
    }
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL(DROP_TABLE);
        onCreate(db);
    }
}

@@ -94,24 +94,28 @@
 CREATE_TABLE
+_CAL
  = %22create t
@@ -128,17 +128,16 @@
 ytable (
- 
 _id inte
@@ -174,27 +174,246 @@
  dat
-a integer not null 
+e numeric not null, shift integer not null);%22;%0Astatic final String CREATE_TABLE_SHIFT = %22create table mytable (_id integer primary key autoincrement, shift integer not null, title text not null, color text not null, order integer not null
 );%22;
@@ -668,24 +668,24 @@
 abase db) %7B%0A
-
         db.e
@@ -699,24 +699,68 @@
 CREATE_TABLE
+_CAL);%0A        db.execSQL(CREATE_TABLE_SHIFT
 );%0A    %7D%0A   

add create tables