@@ -0,0 +1,1411 @@
+package com.gmail.emerssso.srbase.database;%0A%0Aimport android.database.sqlite.SQLiteDatabase;%0Aimport android.util.Log;%0A%0Apublic class DailyTable %7B%0A%09public static final String TABLE_DAILY = %22daily%22;%0A%09public static final String COLUMN_ID = %22_id%22;%0A%09public static final String COLUMN_SR_ID = %22SR_id%22;%0A%09public static final String COLUMN_DATE = %22date%22;%0A%09public static final String COLUMN_START_TIME = %22start_time%22;%0A%09public static final String COLUMN_END_TIME = %22end_time%22;%0A%09public static final String COLUMN_TRAVEL_TIME = %22travel_time%22;%0A%09public static final String COLUMN_COMMENT = %22comment%22;%0A%09%0A%09private static final String DATABASE_CREATE = %22create table %22%0A%09%09%09+ TABLE_DAILY + %22(%22 + COLUMN_ID%0A%09%09%09+ %22 integer primary key autoincrement, %22%0A%09%09%09+ COLUMN_SR_ID + %22 text not null, %22%0A%09%09%09+ COLUMN_DATE + %22 text not null, %22%0A%09%09%09+ COLUMN_START_TIME + %22 text not null, %22%0A%09%09%09+ COLUMN_END_TIME + %22 text not null, %22%0A%09%09%09+ COLUMN_TRAVEL_TIME + %22 text not null, %22%0A%09%09%09+ COLUMN_COMMENT + %22 text not null);%22;%0A%09%0A%09public static void onCreate(SQLiteDatabase database) %7B%0A%09    database.execSQL(DATABASE_CREATE);%0A%09%7D%0A%09%0A%09public static void onUpgrade(SQLiteDatabase database, int oldVersion,%0A%09%09%09int newVersion) %7B%0A%09%09Log.w(SRTable.class.getName(), %22Upgrading database from version %22%0A%09%09%09%09+ oldVersion + %22 to %22 + newVersion%0A%09%09%09%09+ %22, which will destroy all old data%22);%0A%09%09database.execSQL(%22DROP TABLE IF EXISTS %22 + TABLE_DAILY);%0A%09%09onCreate(database);%0A%09%7D%0A%0A%7D%0A

Add DailyTable class