build_time integer default (strftime('%s', 'now')),
install_time integer,
checksum text, -- checksum of package contents. null for incompleted packages
- primary key (package,version,release)
+ primary key (package,version,release),
+ check (typeof(release) = 'integer'),
+ check (release > 0)
+ -- TODO enforce name and release conventions
)
without rowid
;