zeitgeist team mailing list archive

[noreply@xxxxxxxxxxxxx]

------------------------------------------------------------
revno: 315
committer: Siegfried-Angel Gevatter Pujals <siegfried@xxxxxxxxxxxx>
branch nick: bluebird
timestamp: Fri 2011-10-14 20:26:09 +0200
message:
  Remove old comment, move PRAGMA to the right place.
modified:
  src/sql-schema.vala


--
lp:~zeitgeist/zeitgeist/bluebird
https://code.launchpad.net/~zeitgeist/zeitgeist/bluebird

Your team Zeitgeist Framework Team is subscribed to branch lp:~zeitgeist/zeitgeist/bluebird.
To unsubscribe from this branch go to https://code.launchpad.net/~zeitgeist/zeitgeist/bluebird/+edit-subscription

=== modified file 'src/sql-schema.vala'
--- src/sql-schema.vala	2011-10-14 17:47:31 +0000
+++ src/sql-schema.vala	2011-10-14 18:26:09 +0000
@@ -35,10 +35,6 @@
         public static void ensure_schema (Sqlite.Database database)
             throws EngineError
         {
-            // TODO: PRAGMA: WAL
-
-            exec_query (database, "PRAGMA journal_mode = WAL;");
-
             //if (Constants.DATABASE_FILE_PATH != ":memory:" && !new_db)
             // assume temporary memory backed DBs are good
             // check_core_schema_upgrade
@@ -49,6 +45,8 @@
         public static void create_schema (Sqlite.Database database)
             throws EngineError
         {
+            exec_query (database, "PRAGMA journal_mode = WAL");
+
             // URI
             exec_query (database, """
                 CREATE TABLE IF NOT EXISTS uri (