diff options
Diffstat (limited to 'util/updates')
| -rw-r--r-- | util/updates/update_1.22.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/util/updates/update_1.22.sql b/util/updates/update_1.22.sql index 9a81b2c6..897b0a2b 100644 --- a/util/updates/update_1.22.sql +++ b/util/updates/update_1.22.sql @@ -27,3 +27,8 @@ ALTER TABLE changes ADD FOREIGN KEY (causedby) REFERENCES changes (id) DEFERRABL ALTER TABLE threads_posts ALTER COLUMN num TYPE smallint; ALTER TABLE threads ADD FOREIGN KEY (id, count) REFERENCES threads_posts (tid, num) DEFERRABLE INITIALLY DEFERRED; + +-- screenshots now have a relation with releases +ALTER TABLE vn_screenshots ADD COLUMN rid integer DEFAULT NULL REFERENCES releases (id) DEFERRABLE INITIALLY DEFERRED; + + |