diff options
author | Yorhel <git@yorhel.nl> | 2021-11-15 11:37:56 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2021-11-15 11:37:58 +0100 |
commit | e822056651fd5d72b57fd06980c3def12ebbe349 (patch) | |
tree | 5bda9b83ef2400ebcca77385905ba9d68bec77a8 /util | |
parent | 5f87c138de277519732176475cd618c9d7ee61f7 (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.sql | 12 |
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; |