make Haketilo proxy recognize identical items when updating from repository

1 files changed, 7 insertions, 6 deletions

diff --git a/src/hydrilla/proxy/tables.sql b/src/hydrilla/proxy/tables.sql
index aa98081..863c989 100644
--- a/src/hydrilla/proxy/tables.sql
+++ b/src/hydrilla/proxy/tables.sql
@@ -176,18 +176,19 @@ CREATE TABLE mapping_statuses(
 );
 
 CREATE TABLE item_versions(
-        item_version_id     INTEGER PRIMARY KEY,
+        item_version_id     INTEGER  PRIMARY KEY,
 
-	item_id             INTEGER NOT NULL,
-        version             VARCHAR NOT NULL,
+	item_id             INTEGER  NOT NULL,
+        version             VARCHAR  NOT NULL,
 	-- "installed" determines whether item is INSTALLED, is NOT_INSTALLED or
 	-- it FAILED_TO_INSTALL when last tried. If "required" in a row of
 	-- "mapping_statuses is set to TRUE, the mapping version and all
 	-- resource versions corresponding to it are supposed to have
 	-- "installed" set to 'I'.
-	installed           CHAR(1) NOT NULL,
-	repo_iteration_id   INTEGER NOT NULL,
-	definition          BLOB    NOT NULL,
+	installed           CHAR(1)  NOT NULL,
+	repo_iteration_id   INTEGER  NOT NULL,
+	definition          BLOB     NOT NULL,
+	definition_sha256   CHAR(64) NOT NULL,
 
         UNIQUE (item_id, version, repo_iteration_id),
 	-- Constraint below needed to allow foreign key from "mapping_statuses".