Index: src/libchcore/TSQLiteTaskManagerSchema.cpp =================================================================== diff -u -N -r0c5027d5173ab0daeba6aa6b735a2b11d4cd2164 -ra99c8baeb8f6c237603df46c0f5c4cf943152c09 --- src/libchcore/TSQLiteTaskManagerSchema.cpp (.../TSQLiteTaskManagerSchema.cpp) (revision 0c5027d5173ab0daeba6aa6b735a2b11d4cd2164) +++ src/libchcore/TSQLiteTaskManagerSchema.cpp (.../TSQLiteTaskManagerSchema.cpp) (revision a99c8baeb8f6c237603df46c0f5c4cf943152c09) @@ -45,13 +45,24 @@ if(tVersion.GetVersion() == 0) { TSQLiteStatement tStatement(spDatabase); + tStatement.Prepare(_T("CREATE TABLE tasks(id BIGINT UNIQUE PRIMARY KEY, task_order INT NOT NULL, path VARCHAR(32768) NOT NULL)")); tStatement.Step(); // and finally set the database version to current one tVersion.SetVersion(1); } + if(tVersion.GetVersion() == 1) + { + TSQLiteStatement tStatement(spDatabase); + tStatement.Prepare(_T("CREATE TABLE obsolete_tasks(id BIGINT UNIQUE PRIMARY KEY, path VARCHAR(32768) NOT NULL)")); + tStatement.Step(); + + // and finally set the database version to current one + tVersion.SetVersion(2); + } + tTransaction.Commit(); }