[GNUnet-SVN] r5886 - GNUnet/src/applications/sqstore_sqlite

[gnunet]

Author: grothoff
Date: 2007-12-12 20:40:21 -0700 (Wed, 12 Dec 2007)
New Revision: 5886

Modified:
   GNUnet/src/applications/sqstore_sqlite/sqlite.c
Log:
always run index creation

Modified: GNUnet/src/applications/sqstore_sqlite/sqlite.c
===================================================================
--- GNUnet/src/applications/sqstore_sqlite/sqlite.c     2007-12-13 03:26:42 UTC 
(rev 5885)
+++ GNUnet/src/applications/sqstore_sqlite/sqlite.c     2007-12-13 03:40:21 UTC 
(rev 5886)
@@ -183,6 +183,7 @@
                        NULL, NULL, ENULL));
   sqlite3_exec (dbh, "DROP INDEX idx_comb1", NULL, NULL, ENULL);
   sqlite3_exec (dbh, "DROP INDEX idx_comb2", NULL, NULL, ENULL);
+  sqlite3_exec (dbh, "DROP INDEX idx_comb6", NULL, NULL, ENULL);
   CHECK (SQLITE_OK ==
          sqlite3_exec (dbh,
                        "CREATE INDEX idx_comb3 ON gn070 (prio,anonLevel)",
@@ -195,10 +196,6 @@
          sqlite3_exec (dbh,
                        "CREATE INDEX idx_comb5 ON gn070 (expire,hash)",
                        NULL, NULL, ENULL));
-  CHECK (SQLITE_OK ==
-         sqlite3_exec (dbh,
-                       "CREATE INDEX idx_comb6 ON gn070 (prio,type,hash)",
-                       NULL, NULL, ENULL));
 }
 
 /**
@@ -277,9 +274,9 @@
           GNUNET_free (ret);
           return NULL;
         }
-      createIndices (ret->dbh);
     }
   sqlite3_finalize (stmt);
+  createIndices (ret->dbh);
 
   CHECK (SQLITE_OK ==
          sq_prepare (ret->dbh,