diff options
Diffstat (limited to 'src/analysis/db/items/bookmark.c')
-rw-r--r-- | src/analysis/db/items/bookmark.c | 18 |
1 files changed, 14 insertions, 4 deletions
diff --git a/src/analysis/db/items/bookmark.c b/src/analysis/db/items/bookmark.c index 2fa2544..712a5eb 100644 --- a/src/analysis/db/items/bookmark.c +++ b/src/analysis/db/items/bookmark.c @@ -747,17 +747,27 @@ GBookmarkCollection *g_bookmark_collection_new(void) static bool g_bookmark_collection_create_db_table(const GBookmarkCollection *collec, sqlite3 *db) { - char *sql; /* Requête à exécuter */ - int ret; /* Bilan de la création */ + const char *sql; /* Patron de Requête SQL */ + char *addr_fields; /* Champs pour l'adresse */ + char *request; /* Requête à exécuter */ char *msg; /* Message d'erreur */ + int ret; /* Bilan de la création */ sql = "CREATE TABLE Bookmarks (" \ SQLITE_DB_ITEM_CREATE ", " \ - SQLITE_SIMPLE_VMPA_CREATE ", " \ + "%%s, " \ SQLITE_RLESTR_CREATE("comment") \ ");"; + addr_fields = create_vmpa_db_table(NULL); + + asprintf(&request, sql, addr_fields); + ret = sqlite3_exec(db, sql, NULL, NULL, &msg); + + free(addr_fields); + free(request); + if (ret != SQLITE_OK) { fprintf(stderr, "sqlite3_exec(): %s\n", msg); @@ -791,7 +801,7 @@ static bool g_bookmark_collection_setup_load(GBookmarkCollection *collec, bound_ values, count); if (!status) return false; - if (!setup_load_for_vmpa(NULL, NULL, values, count)) + if (!setup_load_for_vmpa(NULL, values, count)) return false; if (!setup_load_of_rle_string(NULL, "comment", values, count)) |