Author: akv
Date: 2010-01-17 01:47:28 +0100 (Sun, 17 Jan 2010)
New Revision: 3019

Modified:
   branches/rawstudio-ng-color/src/rs-library.c
Log:
Only insert version if it's not inserted when creating tables.

Modified: branches/rawstudio-ng-color/src/rs-library.c
===================================================================
--- branches/rawstudio-ng-color/src/rs-library.c        2010-01-17 00:32:46 UTC 
(rev 3018)
+++ branches/rawstudio-ng-color/src/rs-library.c        2010-01-17 00:47:28 UTC 
(rev 3019)
@@ -290,11 +290,17 @@
        rc = sqlite3_step(stmt);
        sqlite3_finalize(stmt);
 
-       /* Set current version */
-       rc = sqlite3_prepare_v2(db, "insert into version (version) values 
(?1);", -1, &stmt, NULL);
-       rc = sqlite3_bind_int(stmt, 1, LIBRARY_VERSION);
+       rc = sqlite3_prepare_v2(db, "select * from version", -1, &stmt, NULL);
        rc = sqlite3_step(stmt);
        sqlite3_finalize(stmt);
+       if (rc != SQLITE_ROW)
+       {
+               /* Set current version */
+               rc = sqlite3_prepare_v2(db, "insert into version (version) 
values (?1);", -1, &stmt, NULL);
+               rc = sqlite3_bind_int(stmt, 1, LIBRARY_VERSION);
+               rc = sqlite3_step(stmt);
+               sqlite3_finalize(stmt);
+       }
 
        return SQLITE_OK;
 }


_______________________________________________
Rawstudio-commit mailing list
[email protected]
http://rawstudio.org/cgi-bin/mailman/listinfo/rawstudio-commit

Reply via email to