[Midnightbsd-cvs] mports [18890] trunk/Tools/magus/schema.sql: add type column

[laffer1 at midnightbsd.org]

Revision: 18890
          http://svnweb.midnightbsd.org/mports/?rev=18890
Author:   laffer1
Date:     2015-05-09 17:18:16 -0400 (Sat, 09 May 2015)
Log Message:
-----------
add type column

Modified Paths:
--------------
    trunk/Tools/magus/schema.sql

Modified: trunk/Tools/magus/schema.sql
===================================================================
--- trunk/Tools/magus/schema.sql	2015-05-09 21:16:17 UTC (rev 18889)
+++ trunk/Tools/magus/schema.sql	2015-05-09 21:18:16 UTC (rev 18890)
@@ -21,7 +21,9 @@
 DROP TABLE "depends" CASCADE\g
 CREATE TABLE  "depends" (
    "port"   int NOT NULL, 
-   "dependency"   int NOT NULL
+   "dependency"   int NOT NULL,
+   "type" character varying(10) NOT NULL,
+   primary key ("port", "dependency", "type")
 )  ;
 CREATE INDEX "depends_port_idx" ON "depends" USING btree ("port");
 CREATE INDEX "depends_dependency_idx" ON "depends" USING btree ("dependency");