Skip to content

Instantly share code, notes, and snippets.

@novotnyr
Created March 17, 2014 10:18
Show Gist options
  • Save novotnyr/9596959 to your computer and use it in GitHub Desktop.
Save novotnyr/9596959 to your computer and use it in GitHub Desktop.
public class DayGridDatabaseOpenHelper extends SQLiteOpenHelper {
public DayGridDatabaseOpenHelper(Context context) {
super(context, Database.NAME, DEFAULT_CURSOR_FACTORY, Database.VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
String sql = "CREATE TABLE %s (" +
"%s INTEGER PRIMARY KEY AUTOINCREMENT, " +
"%s DATE NOT NULL, " +
"%s INTEGER NOT NULL" +
")";
sql = String.format(sql,
Database.DayColor.TABLE_NAME,
Database.DayColor._ID,
Database.DayColor.TIMESTAMP,
Database.DayColor.COLOR);
db.execSQL(sql);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// not supported
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment