tkk6FwE5

1List<AlarmHolder> oldAlarms = getAllAlarms(database);
2
3    database.execSQL("DROP TABLE IF EXISTS " + TABLE_ALARMS);
4    database.execSQL(buildAlarmTable());
5
6    App.getInstance().cancelAllAlarms(oldAlarms);
7
8    for (AlarmHolder alarm : oldAlarms) {
9        alarm.setMALID(alarm.getId());
10        alarm.setId(-1);
11        insertAlarm(alarm, database);
12    }
13
14    List<AlarmHolder> upgradedAlarms = getAllAlarms(database);
15	
16private String buildAlarmTable() {
17    return "CREATE TABLE IF NOT EXISTS " + TABLE_ALARMS +
18            "(" + KEY_ALARM_ID + " INTEGER PRIMARY KEY NOT NULL," +
19            KEY_ALARM_NAME + " TEXT," +
20            KEY_ALARM_TIME + " INTEGER" +
21            ")";
22}
23	
24public String buildAlarmTable() {
25    return "CREATE TABLE IF NOT EXISTS " + TABLE_ALARMS +
26            "(" + KEY_ALARM_ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
27            KEY_ALARM_NAME + " TEXT," +
28            KEY_ALARM_TIME + " INTEGER, " +
29            KEY_ALARM_MALID + " INTEGER" +
30            ")";
31}