From 6803650678c752db250be064c70bf652cc8b5733 Mon Sep 17 00:00:00 2001 From: Michael Tremer Date: Fri, 22 Jan 2021 12:04:07 +0000 Subject: [PATCH] libpakfire: db: Add files table Signed-off-by: Michael Tremer --- src/libpakfire/db.c | 25 +++++++++++++++++++++++++ 1 file changed, 25 insertions(+) diff --git a/src/libpakfire/db.c b/src/libpakfire/db.c index 859fca3a9..2dc69f90d 100644 --- a/src/libpakfire/db.c +++ b/src/libpakfire/db.c @@ -274,6 +274,31 @@ static int pakfire_db_create_schema(struct pakfire_db* db) { if (r) return r; + // Create files table + r = pakfire_db_execute(db, + "CREATE TABLE IF NOT EXISTS files(" + "id INTEGER PRIMARY KEY, " + "name TEXT, " + "pkg INTEGER, " + "size INTEGER, " + "type INTEGER, " + "config INTEGER, " + "datafile INTEGER, " + "mode INTEGER, " + "user TEXT, " + "'group' TEXT, " + "hash1 TEXT, " + "mtime INTEGER, " + "capabilities TEXT" + ")"); + if (r) + return 1; + + // files: Add index over packages + r = pakfire_db_execute(db, "CREATE INDEX IF NOT EXISTS files_pkg_index ON files(pkg)"); + if (r) + return 1; + return 0; } -- 2.47.2