support for package dependencies

[zpackage] / schema / main.sql

diff --git a/schema/main.sql b/schema/main.sql
index c9c79a26e0f338920d9bfcf0894066a2ef23cc47..85546d9321e0a2e9b484894472a7fe1f1685269f 100644 (file)
--- 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
 );
 
@@ -372,7 +374,7 @@ create table zpmlog (
 
 create table notes (
        id      integer primary key, -- rowid alias
-       ts      text default (strftime('%Y-%m-%d %H:%M:%f', 'now')),
+       ts      text default (strftime('%Y-%m-%dT%H:%M:%f', 'now')),
        note    text not null,
        pkgid   text, -- package
        path    text, -- file path involved