[Midnightbsd-cvs] src: db_schema.c: Updated the schema to make the conflicts and the

[ctriv at midnightbsd.org]

Log Message:
-----------
Updated the schema to make the conflicts and the depends a bit more
normalized.

Modified Files:
--------------
    src/lib/libmport:
        db_schema.c (r1.1 -> r1.2)

-------------- next part --------------
Index: db_schema.c
===================================================================
RCS file: /home/cvs/src/lib/libmport/db_schema.c,v
retrieving revision 1.1
retrieving revision 1.2
diff -Llib/libmport/db_schema.c -Llib/libmport/db_schema.c -u -r1.1 -r1.2
--- lib/libmport/db_schema.c
+++ lib/libmport/db_schema.c
@@ -40,8 +40,8 @@
 {
   run_sql(db, "CREATE TABLE assets (pkg text not NULL, type int NOT NULL, data text, checksum text)");
   run_sql(db, "CREATE TABLE package  (pkg text NOT NULL, version text NOT NULL, lang text, options text, date int NOT NULL)");
-  run_sql(db, "CREATE TABLE conflicts (pkg text NOT NULL, conflict text NOT NULL)");
-  run_sql(db, "CREATE TABLE depends   (pkg text NOT NULL, depend text NOT NULL)");
+  run_sql(db, "CREATE TABLE conflicts (pkg text NOT NULL, conflict_pkg text NOT NULL, conflict_version text NOT NULL)");
+  run_sql(db, "CREATE TABLE depends   (pkg text NOT NULL, depend_pkgname text NOT NULL, depend_pkgversion text NOT NULL, depend_port text NOT NULL)");
 }
 
 static void run_sql(sqlite3 *db, const char *sql)