libtransport.git Changeset - e0d85521ed0b

Changeset - e0d85521ed0b

Parent rev.

Child rev.

[Not reviewed]

0 1 0

HanzZ - 14 years ago 2011-10-05 21:56:07
hanzz.k@gmail.com

Use INSERT IGNORE for db_version

1 file changed with 1 insertions and 1 deletions:

src/mysqlbackend.cpp

0 comments (0 inline, 0 general)

src/mysqlbackend.cpp

➞

Show inline comments

@@ @@ -368,13 +368,13 @@ bool MySQLBackend::createDatabase() { @@
 		exec("CREATE TABLE IF NOT EXISTS `" + m_prefix + "db_version` ("
 				"`ver` int(10) unsigned NOT NULL default '1',"
 				"UNIQUE KEY `ver` (`ver`)"
 			") ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;");
 		exec("INSERT INTO db_version (ver) VALUES ('2');");
+		exec("INSERT IGNORE INTO db_version (ver) VALUES ('2');");
+	}
 	return true;
+}
 bool MySQLBackend::exec(const std::string &query) {

0 comments (0 inline, 0 general)