[Midnightbsd-cvs] src [12054] trunk/lib/libmport: add locked, change field to nullable

[laffer1 at midnightbsd.org]

Revision: 12054
          http://svnweb.midnightbsd.org/src/?rev=12054
Author:   laffer1
Date:     2018-09-18 13:34:28 -0400 (Tue, 18 Sep 2018)
Log Message:
-----------
add locked, change field to nullable

Modified Paths:
--------------
    trunk/lib/libmport/db.c
    trunk/lib/libmport/pkgmeta.c

Modified: trunk/lib/libmport/db.c
===================================================================
--- trunk/lib/libmport/db.c	2018-09-18 13:18:19 UTC (rev 12053)
+++ trunk/lib/libmport/db.c	2018-09-18 17:34:28 UTC (rev 12054)
@@ -347,7 +347,7 @@
 mport_generate_master_schema(sqlite3 *db) 
 {
 
-	RUN_SQL(db, "CREATE TABLE IF NOT EXISTS packages (pkg text NOT NULL, version text NOT NULL, origin text NOT NULL, prefix text NOT NULL, lang text, options text, status text default 'dirty', comment text, os_release text, cpe text, locked int NOT NULL, deprecated text, expiration_date int64, no_provide_shlib int NOT NULL, flavor text)");
+	RUN_SQL(db, "CREATE TABLE IF NOT EXISTS packages (pkg text NOT NULL, version text NOT NULL, origin text NOT NULL, prefix text NOT NULL, lang text, options text, status text default 'dirty', comment text, os_release text, cpe text, locked int NOT NULL, deprecated text, expiration_date int64, no_provide_shlib int, flavor text)");
 	RUN_SQL(db, "CREATE UNIQUE INDEX IF NOT EXISTS packages_pkg ON packages (pkg)");
 	RUN_SQL(db, "CREATE INDEX IF NOT EXISTS packages_origin ON packages (origin)");
 

Modified: trunk/lib/libmport/pkgmeta.c
===================================================================
--- trunk/lib/libmport/pkgmeta.c	2018-09-18 13:18:19 UTC (rev 12053)
+++ trunk/lib/libmport/pkgmeta.c	2018-09-18 17:34:28 UTC (rev 12054)
@@ -132,7 +132,7 @@
     }
 
     if (mport_db_prepare(db, &stmt,
-                         "SELECT pkg, version, origin, lang, prefix, comment, os_release, cpe, deprecated, expiration_date, no_provide_shlib, flavor FROM stub.packages") !=
+                         "SELECT pkg, version, origin, lang, prefix, comment, os_release, cpe, 0 as locked, deprecated, expiration_date, no_provide_shlib, flavor FROM stub.packages") !=
         MPORT_OK) {
         sqlite3_finalize(stmt);
         RETURN_CURRENT_ERROR;