id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc,mlocked 76,mythgame makes two Calls to the Database when only one will do the job.,Korey ,Isaac Richards,"By replacing these: ''query.exec(""DELETE FROM settings WHERE value='GameDBSchemaVer';""); query.exec(QString(""INSERT INTO settings (value, data, hostname) "" ""VALUES ('GameDBSchemaVer', %1, NULL);"").arg(newnumber)); '' with a sigle update. ''query.exec(QString(""UPDATE settings SET value='GameDBSchemaVer', data=%1, hostname=NULL WHERE value='GameDBSchemaVer';"").arg(newnumber)); '' One call to the database can be avoided. If the settings table does not have value=GameDBSchemaVer it will be created.",defect,closed,minor,unknown,mythgame,head,low,wontfix,"Database,query,query.exec",,0