+create table packagestatus (
+ pkgid text primary key,
+ status text, -- installed installing removed upgraded
+ -- asof timestamp
+ asof integer default (strftime('%s', 'now'))
+);
+
+create table packagetags (
+ -- package id triple
+ package text,
+ version text,
+ release integer,
+ tag text,
+ set_time integer default (strftime('%s', 'now')),
+ primary key (package,version,release,tag),
+ foreign key (package,version,release) references packages (package,version,release) on delete cascade
+);
+