diff options
author | Yorhel <git@yorhel.nl> | 2010-12-19 19:10:25 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2010-12-19 19:10:25 +0100 |
commit | 720ab3e394547b1fa82b42fbefd36bb4abb81cb0 (patch) | |
tree | 502045c3bd714059d898dc8a12c56cb9265d4daa | |
parent | 234864cf99fd0eb30cdc561e29dda14a1536cacc (diff) |
SQL: Synchronised the current index definitions with schema.sql
-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); + |