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
);
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