X-Git-Url: https://pd.if.org/git/?p=zpackage;a=blobdiff_plain;f=schema%2Fmain.sql;h=85546d9321e0a2e9b484894472a7fe1f1685269f;hp=b0675509e1a6884e8b2ba6560a91350111bed3fd;hb=09490cd2433e3c37a0d85220b4f12f01e6740d46;hpb=b6f9b692cd319ffbe43fbd191b13613532d82e37 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 );