X-Git-Url: https://pd.if.org/git/?a=blobdiff_plain;f=schema%2Fmain.sql;h=85546d9321e0a2e9b484894472a7fe1f1685269f;hb=09490cd2433e3c37a0d85220b4f12f01e6740d46;hp=b0675509e1a6884e8b2ba6560a91350111bed3fd;hpb=d697639ca6483bdee0ab043f85a2266fe7c62956;p=zpackage

diff --git a/schema/main.sql b/schema/main.sql
index b067550..85546d9 100644
--- a/schema/main.sql
+++ b/schema/main.sql
@@ -325,13 +325,15 @@ select printf('%s-%s-%s', package, version, release) as pkgid, *
 from scripts
 ;
 
--- package dependencies: table of package, dependency, dep type (package, soname)
+-- package dependencies: table of package, dependency, dep type (package,
+	-- soname)
+-- how to specify min/max/exact
 create table packagedeps (
 	package	text,
 	version	text,
 	release	integer,
-	requires text, -- package, can be partial
-	primary key (package,version,release,package),
+	requires text, -- package, can be partial, minimum
+	primary key (package,version,release,requires),
 	foreign key (package,version,release) references packages (package,version,release) on delete cascade on update cascade
 );