1 files changed, 19 insertions, 0 deletions

diff --git a/db/migrate/20260623232228_upgrade_taggings_for_acts_as_taggable_on.rb b/db/migrate/20260623232228_upgrade_taggings_for_acts_as_taggable_on.rb
new file mode 100644
index 0000000..5051239
--- /dev/null
+++ b/db/migrate/20260623232228_upgrade_taggings_for_acts_as_taggable_on.rb
@@ -0,0 +1,19 @@
+class UpgradeTaggingsForActsAsTaggableOn < ActiveRecord::Migration
+  def up
+    add_column :taggings, :context,     :string
+    add_column :taggings, :tagger_id,   :integer
+    add_column :taggings, :tagger_type, :string
+
+    # populate context for existing taggings
+    execute "UPDATE taggings SET context = 'tags'"
+
+    add_index :taggings, :context
+    add_index :taggings, [:tagger_id, :tagger_type]
+  end
+
+  def down
+    remove_column :taggings, :context
+    remove_column :taggings, :tagger_id
+    remove_column :taggings, :tagger_type
+  end
+end