[Midnightbsd-cvs] src [12056] trunk/lib/libmport/db.c: allow nulls

laffer1 at midnightbsd.org laffer1 at midnightbsd.org
Wed Sep 19 08:54:05 EDT 2018


Revision: 12056
          http://svnweb.midnightbsd.org/src/?rev=12056
Author:   laffer1
Date:     2018-09-19 08:54:03 -0400 (Wed, 19 Sep 2018)
Log Message:
-----------
allow nulls

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

Modified: trunk/lib/libmport/db.c
===================================================================
--- trunk/lib/libmport/db.c	2018-09-18 22:50:35 UTC (rev 12055)
+++ trunk/lib/libmport/db.c	2018-09-19 12:54:03 UTC (rev 12056)
@@ -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 NOT NULL default '1.0', cpe text, locked int NOT NULL default '0', deprecated text default '', expiration_date int64 NOT NULL default '0', no_provide_shlib int NOT NULL default '0', flavor text default '')");
+	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 NOT NULL default '1.0', cpe text, locked int NOT NULL default '0', deprecated text default '', expiration_date int64 NOT NULL default '0', no_provide_shlib int default '0', flavor text default '')");
 	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)");
 



More information about the Midnightbsd-cvs mailing list