diff options
Diffstat (limited to 'util')
-rw-r--r-- | util/sql/schema.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql index 4daa2f1c..a68a901d 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -421,3 +421,8 @@ ALTER TABLE votes ADD FOREIGN KEY (vid) REFERENCES vn ALTER TABLE wlists ADD FOREIGN KEY (uid) REFERENCES users (id) ON DELETE CASCADE; ALTER TABLE wlists ADD FOREIGN KEY (vid) REFERENCES vn (id); + + +CREATE INDEX releases_vn_vid ON releases_vn (vid); +CREATE INDEX tags_vn_date ON tags_vn (date); + |