- QSqlQuery q(mDb);
- if (!q.exec("SELECT name, length, flags FROM data;")) {
- QSqlError err = mDb.lastError();
+ QSqlQuery q(db);
+
+ // Check if the 'suffix' column exists
+ if (q.exec("SELECT suffix from data;")) {
+ return true;
+ }
+
+ // Add the 'suffix' columnt
+ if (!q.exec("ALTER TABLE data ADD COLUMN suffix TEXT;")) {
+ QSqlError err = db.lastError();
+ EVAF_ERROR("Failed to upgrade table \'data\' : %s", qPrintable(err.text()));
+ return false;
+ }
+
+ return true;
+}
+
+bool StorageImpl::loadData(QSqlDatabase & db)
+{
+ QSqlQuery q(db);
+ if (!q.exec("SELECT name, suffix, length, flags FROM data;")) {
+ QSqlError err = db.lastError();