add program to generate a hash of package contents

[zpackage] / db.sql

diff --git a/db.sql b/db.sql
index 041c06efdf24e9524b7457a8627c7d2ff036df5e..d74803da8800e5115cacc3f7e3c8cd6e7277f931 100644 (file)
--- a/db.sql
+++ b/db.sql
@@ -33,7 +33,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
+       hash    text, -- see integ.c for package hash
        primary key (package,version,release),
        check (typeof(package) = 'text'),
        check (typeof(version) = 'text'),
@@ -74,7 +74,7 @@ begin
        packager = NEW.packager,
        build_time = NEW.build_time,
        install_time = NEW.install_time,
-       checksum = NEW.checksum
+       hash = NEW.hash
        where package = OLD.package
        and version = OLD.version
        and release = OLD.release
@@ -100,14 +100,6 @@ create table packagetags (
        foreign key (package,version,release) references packages (package,version,release) on delete cascade on update cascade
 );
 
--- packagefile hash is columns as text, joined with null bytes, then
--- sha256 sum of that
--- package checksum is package columns as text, joined with null bytes,
--- other than the checksum and install_time column
--- then that hashed.  finally, that hash, plus the ascii sorted
--- hashes of the package files all joined with newlines, hashed.
--- really don't like this.
-
 -- files contained in a package
 create table packagefiles (
        -- package id triple