summaryrefslogtreecommitdiff
path: root/util/updates/update_2.16.sql
blob: 8ffbd6ae4707560fe65d4a1a8126d01c8f94660f (plain)
1
2
3
4
5
6

-- remove the NOT NULL from rr.minage and use -1 when unknown
UPDATE releases_rev SET minage = -1 WHERE minage IS NULL;
ALTER TABLE releases_rev ALTER COLUMN minage SET DEFAULT -1;
ALTER TABLE releases_rev ALTER COLUMN minage DROP NOT NULL;