Web   ·   Wiki   ·   Activities   ·   Blog   ·   Lists   ·   Chat   ·   Meeting   ·   Bugs   ·   Git   ·   Translate   ·   Archive   ·   People   ·   Donate
summaryrefslogtreecommitdiffstats
path: root/migrations
diff options
context:
space:
mode:
authorJeff Balogh <jbalogh@mozilla.com>2010-07-19 20:56:17 (GMT)
committer Jeff Balogh <jbalogh@mozilla.com>2010-07-20 23:26:03 (GMT)
commit947b5962464ff88105f2b2f1fb03664ff2c22618 (patch)
tree2ca0b5e4cb7df440e28644df3ee6170f4749b21c /migrations
parent3958e5eb9fea4b3272a22229681c2c50d9101e8e (diff)
pull all the creatured ids to avoid repeated calls
Diffstat (limited to 'migrations')
-rw-r--r--migrations/51-addoncategory-feature-idx.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/migrations/51-addoncategory-feature-idx.sql b/migrations/51-addoncategory-feature-idx.sql
new file mode 100644
index 0000000..9a42fd9
--- /dev/null
+++ b/migrations/51-addoncategory-feature-idx.sql
@@ -0,0 +1,4 @@
+CREATE INDEX feature_addon_idx ON addons_categories (feature, addon_id);
+
+-- This index is redundant.
+ALTER TABLE addons_categories DROP KEY tag_id;