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 <k.m.fort@…>	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