add checksum column to packages table

[zpackage] / db.sql

diff --git a/db.sql b/db.sql
index 7ad22b9593f66bf990be3ce9db5b0e2d62f73cd4..be2a3b3725ba2c89ddeedc1a953dc4b72a208a9f 100644 (file)
--- a/db.sql
+++ b/db.sql
@@ -23,6 +23,7 @@ create table packages (
        packager        text,
        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)
 )
 without rowid