summaryrefslogtreecommitdiff
path: root/util/updates/update_1.22.sql
diff options
context:
space:
mode:
authoryorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b>2008-08-27 11:05:59 +0000
committeryorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b>2008-08-27 11:05:59 +0000
commitba035329e131ab342fe3c873f98b01b1c383b248 (patch)
tree875a7ebe64509c4183adb93cfe7cb551d1452edd /util/updates/update_1.22.sql
parent5d04638c123a8d2e34c4c56d3e90ecd6e6749117 (diff)
Added release link to screenshots
git-svn-id: svn://vndb.org/vndb@103 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
Diffstat (limited to 'util/updates/update_1.22.sql')
-rw-r--r--util/updates/update_1.22.sql5
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;
+
+