diff options
| author | Wojtek Kosior <koszko@koszko.org> | 2022-08-24 14:54:27 +0200 |
|---|---|---|
| committer | Wojtek Kosior <koszko@koszko.org> | 2022-09-09 13:55:05 +0200 |
| commit | aad33e091606555ef5989f88367b83851439e815 (patch) | |
| tree | 92c2c4f67e9c0b7e8fe2badfc9a9f973dc09a304 /src/hydrilla/proxy/tables.sql | |
| parent | 4fdaee237c39d4106fdad6462f4318713f060471 (diff) | |
| download | haketilo-hydrilla-aad33e091606555ef5989f88367b83851439e815.tar.gz haketilo-hydrilla-aad33e091606555ef5989f88367b83851439e815.zip | |
make Haketilo proxy recognize identical items when updating from repository
Diffstat (limited to 'src/hydrilla/proxy/tables.sql')
| -rw-r--r-- | src/hydrilla/proxy/tables.sql | 13 |
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". |