summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2021-11-15 11:37:56 +0100
committerYorhel <git@yorhel.nl>2021-11-15 11:37:58 +0100
commite822056651fd5d72b57fd06980c3def12ebbe349 (patch)
tree5bda9b83ef2400ebcca77385905ba9d68bec77a8 /util
parent5f87c138de277519732176475cd618c9d7ee61f7 (diff)
Make release type a property of the release<->vn relation
That is, allow a release to have different types per VN, such as a complete release for one VN that includes a trial for another.
Diffstat (limited to 'util')
-rw-r--r--util/updates/2021-11-15-release-vn-type.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/util/updates/2021-11-15-release-vn-type.sql b/util/updates/2021-11-15-release-vn-type.sql
new file mode 100644
index 00000000..54916086
--- /dev/null
+++ b/util/updates/2021-11-15-release-vn-type.sql
@@ -0,0 +1,12 @@
+BEGIN;
+ALTER TABLE releases_vn ADD COLUMN rtype release_type NOT NULL DEFAULT 'complete';
+ALTER TABLE releases_vn_hist ADD COLUMN rtype release_type NOT NULL DEFAULT 'complete';
+ALTER TABLE releases_vn ALTER COLUMN rtype DROP DEFAULT;
+ALTER TABLE releases_vn_hist ALTER COLUMN rtype DROP DEFAULT;
+UPDATE releases_vn SET rtype = type FROM releases r WHERE r.id = releases_vn.id;
+UPDATE releases_vn_hist SET rtype = type FROM releases_hist r WHERE r.chid = releases_vn_hist.chid;
+ALTER TABLE releases DROP COLUMN type;
+ALTER TABLE releases_hist DROP COLUMN type;
+\i sql/editfunc.sql
+\i sql/func.sql
+COMMIT;