summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2010-12-19 19:10:25 +0100
committerYorhel <git@yorhel.nl>2010-12-19 19:10:25 +0100
commit720ab3e394547b1fa82b42fbefd36bb4abb81cb0 (patch)
tree502045c3bd714059d898dc8a12c56cb9265d4daa
parent234864cf99fd0eb30cdc561e29dda14a1536cacc (diff)
SQL: Synchronised the current index definitions with schema.sql
-rw-r--r--util/sql/schema.sql5
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);
+