X-Git-Url: https://pd.if.org/git/?a=blobdiff_plain;f=db.sql;h=d74803da8800e5115cacc3f7e3c8cd6e7277f931;hb=c9b5db2d4b9c4691bbcc2c61a47c4fc279eb057b;hp=041c06efdf24e9524b7457a8627c7d2ff036df5e;hpb=f72f5c784b3c7e525d59e11e25bd2d241f0bc53a;p=zpackage

diff --git a/db.sql b/db.sql
index 041c06e..d74803d 100644
--- 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