Fix taggings_idx

2 files changed, 12 insertions, 4 deletions

diff --git a/db/migrate/20150921081619_rename_taggings_idx.rb b/db/migrate/20150921081619_rename_taggings_idx.rb
new file mode 100644
index 0000000..ceeb6da
--- /dev/null
+++ b/db/migrate/20150921081619_rename_taggings_idx.rb
@@ -0,0 +1,8 @@
+class RenameTaggingsIdx < ActiveRecord::Migration
+  def up
+    remove_index :ci_taggings, name: 'taggings_idx'
+    add_index :ci_taggings,
+              [:tag_id, :taggable_id, :taggable_type, :context, :tagger_id, :tagger_type],
+              unique: true, name: 'ci_taggings_idx'
+  end
+end
diff --git a/db/schema.rb b/db/schema.rb
index 5838ded..75b3fe6 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -11,7 +11,7 @@
 #
 # It's strongly recommended that you check this file into your version control system.
 
-ActiveRecord::Schema.define(version: 20150914102123) do
+ActiveRecord::Schema.define(version: 20150921081619) do
 
   # These are extensions that must be enabled in order to support this database
   enable_extension "plpgsql"
@@ -168,7 +168,7 @@ ActiveRecord::Schema.define(version: 20150914102123) do
     t.datetime "created_at"
   end
 
-  add_index "ci_taggings", ["tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type"], name: "taggings_idx", unique: true, using: :btree
+  add_index "ci_taggings", ["tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type"], name: "ci_taggings_idx", unique: true, using: :btree
   add_index "ci_taggings", ["taggable_id", "taggable_type", "context"], name: "index_ci_taggings_on_taggable_id_and_taggable_type_and_context", using: :btree
 
   create_table "ci_tags", force: true do |t|
@@ -221,7 +221,7 @@ ActiveRecord::Schema.define(version: 20150914102123) do
     t.datetime "updated_at"
   end
 
-  add_index "sessions", ["session_id"], name: "index_sessions_on_session_id", using: :btree
-  add_index "sessions", ["updated_at"], name: "index_sessions_on_updated_at", using: :btree
+  add_index "sessions", ["session_id"], name: "index_ci_sessions_on_session_id", using: :btree
+  add_index "sessions", ["updated_at"], name: "index_ci_sessions_on_updated_at", using: :btree
 
 end