summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
Diffstat (limited to 'util')
-rw-r--r--util/dump.sql3
-rw-r--r--util/updates/update_2.4.sql6
2 files changed, 8 insertions, 1 deletions
diff --git a/util/dump.sql b/util/dump.sql
index 81343307..b33ae540 100644
--- a/util/dump.sql
+++ b/util/dump.sql
@@ -115,7 +115,8 @@ CREATE TABLE releases_rev (
minage smallint NOT NULL DEFAULT -1,
gtin bigint NOT NULL DEFAULT 0,
patch boolean NOT NULL DEFAULT FALSE,
- catalog varchar(50) NOT NULL DEFAULT ''
+ catalog varchar(50) NOT NULL DEFAULT '',
+ resolution smallint NOT NULL DEFAULT 0
);
-- releases_vn
diff --git a/util/updates/update_2.4.sql b/util/updates/update_2.4.sql
index 03b18dd7..c784d361 100644
--- a/util/updates/update_2.4.sql
+++ b/util/updates/update_2.4.sql
@@ -31,3 +31,9 @@ END;
$$ LANGUAGE plpgsql;
SELECT tag_vn_calc();
+
+
+-- resolution field to releases
+
+ALTER TABLE releases_rev ADD COLUMN resolution smallint NOT NULL DEFAULT 0;
+