summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-05-22 14:53:37 +0200
committerYorhel <git@yorhel.nl>2009-05-22 14:58:23 +0200
commitaaf5fba44b029ed83f290e6d4c5b9ed872d504b5 (patch)
tree75b413d7a6e0cd0bb1f9a662b48c473d81411d50 /util
parent55e67a4c4f690b14c06e2a6b2c6608e2305dceb6 (diff)
Added resolution field to release entries
TODO: - Update d3 - Add filter to /r
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;
+