diff options
author | Yorhel <git@yorhel.nl> | 2022-04-05 11:15:39 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2022-04-05 12:52:06 +0200 |
commit | 220f88425e6dfe0be88cacdb3c9ad8b17e38ddb2 (patch) | |
tree | 6db4bccceeb34370a5726a9930a8009e28cafc0f /util | |
parent | 74ac7376cc39a43f53074da5be3e9573aa566510 (diff) |
Releases: Add "has ero" flag
Diffstat (limited to 'util')
-rw-r--r-- | util/updates/2022-04-05-releases-has-ero.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/util/updates/2022-04-05-releases-has-ero.sql b/util/updates/2022-04-05-releases-has-ero.sql new file mode 100644 index 00000000..f31d9f04 --- /dev/null +++ b/util/updates/2022-04-05-releases-has-ero.sql @@ -0,0 +1,5 @@ +ALTER TABLE releases ADD COLUMN has_ero boolean NOT NULL DEFAULT FALSE; +ALTER TABLE releases_hist ADD COLUMN has_ero boolean NOT NULL DEFAULT FALSE; +UPDATE releases SET has_ero = TRUE WHERE minage = 18; +UPDATE releases_hist SET has_ero = TRUE WHERE minage = 18; +\i sql/editfunc.sql |