38 files changed, 214 insertions, 29 deletions

diff --git a/db/migrate/20090129204750_create_nodes.rb b/db/migrate/20090129204750_create_nodes.rb
index e7cd562..e26dd39 100644
--- a/db/migrate/20090129204750_create_nodes.rb
+++ b/db/migrate/20090129204750_create_nodes.rb
@@ -1,4 +1,4 @@
-class CreateNodes < ActiveRecord::Migration
+class CreateNodes < ActiveRecord::Migration[4.2]
   def self.up
     create_table :nodes do |t|
       t.string :slug
diff --git a/db/migrate/20090129205013_add_missing_columns_for_nested_set_for_node.rb b/db/migrate/20090129205013_add_missing_columns_for_nested_set_for_node.rb
index f8f8404..2aa4241 100644
--- a/db/migrate/20090129205013_add_missing_columns_for_nested_set_for_node.rb
+++ b/db/migrate/20090129205013_add_missing_columns_for_nested_set_for_node.rb
@@ -1,4 +1,4 @@
-class AddMissingColumnsForNestedSetForNode < ActiveRecord::Migration
+class AddMissingColumnsForNestedSetForNode < ActiveRecord::Migration[4.2]
   def self.up
     add_column :nodes, :lft, :integer
     add_column :nodes, :rgt, :integer
diff --git a/db/migrate/20090131113802_create_pages.rb b/db/migrate/20090131113802_create_pages.rb
index 6a38038..bba9cad 100644
--- a/db/migrate/20090131113802_create_pages.rb
+++ b/db/migrate/20090131113802_create_pages.rb
@@ -1,4 +1,4 @@
-class CreatePages < ActiveRecord::Migration
+class CreatePages < ActiveRecord::Migration[4.2]
   def self.up
     create_table :pages do |t|
       t.integer :node_id
diff --git a/db/migrate/20090131213536_add_published_at_to_pages.rb b/db/migrate/20090131213536_add_published_at_to_pages.rb
index 0e4ee62..1a57deb 100644
--- a/db/migrate/20090131213536_add_published_at_to_pages.rb
+++ b/db/migrate/20090131213536_add_published_at_to_pages.rb
@@ -1,4 +1,4 @@
-class AddPublishedAtToPages < ActiveRecord::Migration
+class AddPublishedAtToPages < ActiveRecord::Migration[4.2]
   def self.up
     add_column :pages, :published_at, :datetime
   end
diff --git a/db/migrate/20090201211523_add_join_table_for_flags_pages.rb b/db/migrate/20090201211523_add_join_table_for_flags_pages.rb
index 99eb9c9..cda4af4b 100644
--- a/db/migrate/20090201211523_add_join_table_for_flags_pages.rb
+++ b/db/migrate/20090201211523_add_join_table_for_flags_pages.rb
@@ -1,4 +1,4 @@
-class AddJoinTableForFlagsPages < ActiveRecord::Migration
+class AddJoinTableForFlagsPages < ActiveRecord::Migration[4.2]
   def self.up
     create_table :flags_pages, :id => false do |t|
       t.integer :flag_id
diff --git a/db/migrate/20090206201554_add_head_id_to_node.rb b/db/migrate/20090206201554_add_head_id_to_node.rb
index 7f4af4f..0e580c7 100644
--- a/db/migrate/20090206201554_add_head_id_to_node.rb
+++ b/db/migrate/20090206201554_add_head_id_to_node.rb
@@ -1,4 +1,4 @@
-class AddHeadIdToNode < ActiveRecord::Migration
+class AddHeadIdToNode < ActiveRecord::Migration[4.2]
   def self.up
     add_column :nodes, :head_id, :integer
   end
diff --git a/db/migrate/20090208130829_create_users.rb b/db/migrate/20090208130829_create_users.rb
index e91193c..1bd5228 100644
--- a/db/migrate/20090208130829_create_users.rb
+++ b/db/migrate/20090208130829_create_users.rb
@@ -1,4 +1,4 @@
-class CreateUsers < ActiveRecord::Migration
+class CreateUsers < ActiveRecord::Migration[4.2]
   def self.up
     create_table :users do |t|
       t.string :login
diff --git a/db/migrate/20090208130906_add_user_id_to_pages.rb b/db/migrate/20090208130906_add_user_id_to_pages.rb
index 02ebdef..4172829 100644
--- a/db/migrate/20090208130906_add_user_id_to_pages.rb
+++ b/db/migrate/20090208130906_add_user_id_to_pages.rb
@@ -1,4 +1,4 @@
-class AddUserIdToPages < ActiveRecord::Migration
+class AddUserIdToPages < ActiveRecord::Migration[4.2]
   def self.up
     add_column :pages, :user_id, :integer
   end
diff --git a/db/migrate/20090211220524_create_permissions.rb b/db/migrate/20090211220524_create_permissions.rb
index 2e007a4..4ef6bc4 100644
--- a/db/migrate/20090211220524_create_permissions.rb
+++ b/db/migrate/20090211220524_create_permissions.rb
@@ -1,4 +1,4 @@
-class CreatePermissions < ActiveRecord::Migration
+class CreatePermissions < ActiveRecord::Migration[4.2]
   def self.up
     create_table :permissions do |t|
       t.boolean :granted
diff --git a/db/migrate/20090301104237_add_draft_id_to_nodes.rb b/db/migrate/20090301104237_add_draft_id_to_nodes.rb
index a0ea672..32a79e5 100644
--- a/db/migrate/20090301104237_add_draft_id_to_nodes.rb
+++ b/db/migrate/20090301104237_add_draft_id_to_nodes.rb
@@ -1,4 +1,4 @@
-class AddDraftIdToNodes < ActiveRecord::Migration
+class AddDraftIdToNodes < ActiveRecord::Migration[4.2]
   def self.up
     add_column :nodes, :draft_id, :integer
   end
diff --git a/db/migrate/20090302184350_add_template_column_to_pages.rb b/db/migrate/20090302184350_add_template_column_to_pages.rb
index e3aac66..c4d2ca3 100644
--- a/db/migrate/20090302184350_add_template_column_to_pages.rb
+++ b/db/migrate/20090302184350_add_template_column_to_pages.rb
@@ -1,4 +1,4 @@
-class AddTemplateColumnToPages < ActiveRecord::Migration
+class AddTemplateColumnToPages < ActiveRecord::Migration[4.2]
   def self.up
     add_column :pages, :template, :string
   end
diff --git a/db/migrate/20090302215335_rename_template_to_template_name.rb b/db/migrate/20090302215335_rename_template_to_template_name.rb
index 288209e..6efe523 100644
--- a/db/migrate/20090302215335_rename_template_to_template_name.rb
+++ b/db/migrate/20090302215335_rename_template_to_template_name.rb
@@ -1,4 +1,4 @@
-class RenameTemplateToTemplateName < ActiveRecord::Migration
+class RenameTemplateToTemplateName < ActiveRecord::Migration[4.2]
   def self.up
     rename_column :pages, :template, :template_name
   end
diff --git a/db/migrate/20090316194152_create_events.rb b/db/migrate/20090316194152_create_events.rb
index 7f44fdf..4bf1174 100644
--- a/db/migrate/20090316194152_create_events.rb
+++ b/db/migrate/20090316194152_create_events.rb
@@ -1,4 +1,4 @@
-class CreateEvents < ActiveRecord::Migration
+class CreateEvents < ActiveRecord::Migration[4.2]
   def self.up
     create_table :events do |t|
       t.datetime :start_time
diff --git a/db/migrate/20090316195143_create_occurrences.rb b/db/migrate/20090316195143_create_occurrences.rb
index e0df07b..e397e3c 100644
--- a/db/migrate/20090316195143_create_occurrences.rb
+++ b/db/migrate/20090316195143_create_occurrences.rb
@@ -1,4 +1,4 @@
-class CreateOccurrences < ActiveRecord::Migration
+class CreateOccurrences < ActiveRecord::Migration[4.2]
   def self.up
     create_table :occurrences do |t|
       t.string :summary
diff --git a/db/migrate/20090318203913_add_location_to_event.rb b/db/migrate/20090318203913_add_location_to_event.rb
index 5345781..40dfbf1 100644
--- a/db/migrate/20090318203913_add_location_to_event.rb
+++ b/db/migrate/20090318203913_add_location_to_event.rb
@@ -1,4 +1,4 @@
-class AddLocationToEvent < ActiveRecord::Migration
+class AddLocationToEvent < ActiveRecord::Migration[4.2]
   def self.up
     add_column :events, :location, :text
   end
diff --git a/db/migrate/20090318212438_remove_summary_column_from_occurrences.rb b/db/migrate/20090318212438_remove_summary_column_from_occurrences.rb
index 7110987..101b87c 100644
--- a/db/migrate/20090318212438_remove_summary_column_from_occurrences.rb
+++ b/db/migrate/20090318212438_remove_summary_column_from_occurrences.rb
@@ -1,4 +1,4 @@
-class RemoveSummaryColumnFromOccurrences < ActiveRecord::Migration
+class RemoveSummaryColumnFromOccurrences < ActiveRecord::Migration[4.2]
   def self.up
     remove_column :occurrences, :summary
   end
diff --git a/db/migrate/20090321150359_add_locking_user_id_to_nodes.rb b/db/migrate/20090321150359_add_locking_user_id_to_nodes.rb
index b40dd71..32332c6 100644
--- a/db/migrate/20090321150359_add_locking_user_id_to_nodes.rb
+++ b/db/migrate/20090321150359_add_locking_user_id_to_nodes.rb
@@ -1,4 +1,4 @@
-class AddLockingUserIdToNodes < ActiveRecord::Migration
+class AddLockingUserIdToNodes < ActiveRecord::Migration[4.2]
   def self.up
     add_column :nodes, :locking_user_id, :integer
   end
diff --git a/db/migrate/20090401190026_add_full_name_to_users.rb b/db/migrate/20090401190026_add_full_name_to_users.rb
index a2599e7..8bac436 100644
--- a/db/migrate/20090401190026_add_full_name_to_users.rb
+++ b/db/migrate/20090401190026_add_full_name_to_users.rb
@@ -1,4 +1,4 @@
-class AddFullNameToUsers < ActiveRecord::Migration
+class AddFullNameToUsers < ActiveRecord::Migration[4.2]
   def self.up
   end
 
diff --git a/db/migrate/20090424085851_create_assets.rb b/db/migrate/20090424085851_create_assets.rb
index c7f1796..f6373b1 100644
--- a/db/migrate/20090424085851_create_assets.rb
+++ b/db/migrate/20090424085851_create_assets.rb
@@ -1,4 +1,4 @@
-class CreateAssets < ActiveRecord::Migration
+class CreateAssets < ActiveRecord::Migration[4.2]
   def self.up
     create_table :assets do |t|
       t.string    :name
diff --git a/db/migrate/20090719180204_create_menu_items.rb b/db/migrate/20090719180204_create_menu_items.rb
index a05012a..daf9597 100644
--- a/db/migrate/20090719180204_create_menu_items.rb
+++ b/db/migrate/20090719180204_create_menu_items.rb
@@ -1,4 +1,4 @@
-class CreateMenuItems < ActiveRecord::Migration
+class CreateMenuItems < ActiveRecord::Migration[4.2]
   def self.up
     create_table :menu_items do |t|
       t.integer :node_id
diff --git a/db/migrate/20090809104800_add_position_to_menu_items.rb b/db/migrate/20090809104800_add_position_to_menu_items.rb
index 97ff6f9..19f7825 100644
--- a/db/migrate/20090809104800_add_position_to_menu_items.rb
+++ b/db/migrate/20090809104800_add_position_to_menu_items.rb
@@ -1,4 +1,4 @@
-class AddPositionToMenuItems < ActiveRecord::Migration
+class AddPositionToMenuItems < ActiveRecord::Migration[4.2]
   def self.up
     add_column :menu_items, :position, :integer
   end
diff --git a/db/migrate/20090815220058_migrate_tagging_tables.rb b/db/migrate/20090815220058_migrate_tagging_tables.rb
index e28a16e..23848da 100644
--- a/db/migrate/20090815220058_migrate_tagging_tables.rb
+++ b/db/migrate/20090815220058_migrate_tagging_tables.rb
@@ -1,4 +1,4 @@
-class MigrateTaggingTables < ActiveRecord::Migration
+class MigrateTaggingTables < ActiveRecord::Migration[4.2]
   def self.up
     add_column :tags,     :taggings_count, :integer, :default => 0, :null => false
     add_column :taggings, :user_id, :integer
diff --git a/db/migrate/20090901051946_create_related_assets.rb b/db/migrate/20090901051946_create_related_assets.rb
index 849bf19..9c7b5bc 100644
--- a/db/migrate/20090901051946_create_related_assets.rb
+++ b/db/migrate/20090901051946_create_related_assets.rb
@@ -1,4 +1,4 @@
-class CreateRelatedAssets < ActiveRecord::Migration
+class CreateRelatedAssets < ActiveRecord::Migration[4.2]
   def self.up
     create_table :related_assets do |t|
       t.integer :asset_id
diff --git a/db/migrate/20090901095657_add_indices.rb b/db/migrate/20090901095657_add_indices.rb
index 6dd54b2..15d3d77 100644
--- a/db/migrate/20090901095657_add_indices.rb
+++ b/db/migrate/20090901095657_add_indices.rb
@@ -1,4 +1,4 @@
-class AddIndices < ActiveRecord::Migration
+class AddIndices < ActiveRecord::Migration[4.2]
   def self.up
     change_table :pages do |t|
       t.index :id
diff --git a/db/migrate/20090907103525_add_type_column_to_menu_items.rb b/db/migrate/20090907103525_add_type_column_to_menu_items.rb
index dda0f9c..ae935da 100644
--- a/db/migrate/20090907103525_add_type_column_to_menu_items.rb
+++ b/db/migrate/20090907103525_add_type_column_to_menu_items.rb
@@ -1,4 +1,4 @@
-class AddTypeColumnToMenuItems < ActiveRecord::Migration
+class AddTypeColumnToMenuItems < ActiveRecord::Migration[4.2]
   def self.up
     add_column :menu_items, :type, :string
   end
diff --git a/db/migrate/20090907111533_add_type_id_to_menu_items.rb b/db/migrate/20090907111533_add_type_id_to_menu_items.rb
index 5000e92..ea6790a 100644
--- a/db/migrate/20090907111533_add_type_id_to_menu_items.rb
+++ b/db/migrate/20090907111533_add_type_id_to_menu_items.rb
@@ -1,4 +1,4 @@
-class AddTypeIdToMenuItems < ActiveRecord::Migration
+class AddTypeIdToMenuItems < ActiveRecord::Migration[4.2]
   def self.up
     add_column :menu_items, :type_id, :integer
   end
diff --git a/db/migrate/20090909113832_add_staged_slug_and_parent_id.rb b/db/migrate/20090909113832_add_staged_slug_and_parent_id.rb
index ab883ca..2a65445 100644
--- a/db/migrate/20090909113832_add_staged_slug_and_parent_id.rb
+++ b/db/migrate/20090909113832_add_staged_slug_and_parent_id.rb
@@ -1,4 +1,4 @@
-class AddStagedSlugAndParentId < ActiveRecord::Migration
+class AddStagedSlugAndParentId < ActiveRecord::Migration[4.2]
   def self.up
     add_column :nodes, :staged_slug,      :string
     add_column :nodes, :staged_parent_id, :integer
diff --git a/db/migrate/20090917180422_add_admin_flag_to_user.rb b/db/migrate/20090917180422_add_admin_flag_to_user.rb
index d15c866..e33f5dd 100644
--- a/db/migrate/20090917180422_add_admin_flag_to_user.rb
+++ b/db/migrate/20090917180422_add_admin_flag_to_user.rb
@@ -1,4 +1,4 @@
-class AddAdminFlagToUser < ActiveRecord::Migration
+class AddAdminFlagToUser < ActiveRecord::Migration[4.2]
   def self.up
     add_column :users, :admin, :boolean
   end
diff --git a/db/migrate/20091111154113_add_editor_id_to_pages.rb b/db/migrate/20091111154113_add_editor_id_to_pages.rb
index 971b8a3..bc13240 100644
--- a/db/migrate/20091111154113_add_editor_id_to_pages.rb
+++ b/db/migrate/20091111154113_add_editor_id_to_pages.rb
@@ -1,4 +1,4 @@
-class AddEditorIdToPages < ActiveRecord::Migration
+class AddEditorIdToPages < ActiveRecord::Migration[4.2]
   def self.up
     add_column :pages, :editor_id, :integer
   end
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..4dad8a9
--- /dev/null
+++ b/db/migrate/20260623232228_upgrade_taggings_for_acts_as_taggable_on.rb
@@ -0,0 +1,19 @@
+class UpgradeTaggingsForActsAsTaggableOn < ActiveRecord::Migration[4.2]
+  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
diff --git a/db/migrate/20260624035149_acts_as_taggable_on_migration.acts_as_taggable_on_engine.rb b/db/migrate/20260624035149_acts_as_taggable_on_migration.acts_as_taggable_on_engine.rb
new file mode 100644
index 0000000..35daedd
--- /dev/null
+++ b/db/migrate/20260624035149_acts_as_taggable_on_migration.acts_as_taggable_on_engine.rb
@@ -0,0 +1,31 @@
+# This migration comes from acts_as_taggable_on_engine (originally 1)
+class ActsAsTaggableOnMigration < ActiveRecord::Migration[4.2]
+  def self.up
+    create_table :tags do |t|
+      t.string :name
+    end
+
+    create_table :taggings do |t|
+      t.references :tag
+
+      # You should make sure that the column created is
+      # long enough to store the required class names.
+      t.references :taggable, polymorphic: true
+      t.references :tagger, polymorphic: true
+
+      # Limit is created to prevent MySQL error on index
+      # length for MyISAM table type: http://bit.ly/vgW2Ql
+      t.string :context, limit: 128
+
+      t.datetime :created_at
+    end
+
+    add_index :taggings, :tag_id
+    add_index :taggings, [:taggable_id, :taggable_type, :context]
+  end
+
+  def self.down
+    drop_table :taggings
+    drop_table :tags
+  end
+end
diff --git a/db/migrate/20260624035150_add_missing_unique_indices.acts_as_taggable_on_engine.rb b/db/migrate/20260624035150_add_missing_unique_indices.acts_as_taggable_on_engine.rb
new file mode 100644
index 0000000..52f9ab5
--- /dev/null
+++ b/db/migrate/20260624035150_add_missing_unique_indices.acts_as_taggable_on_engine.rb
@@ -0,0 +1,20 @@
+# This migration comes from acts_as_taggable_on_engine (originally 2)
+class AddMissingUniqueIndices < ActiveRecord::Migration[4.2]
+  def self.up
+    add_index :tags, :name, unique: true
+
+    remove_index :taggings, :tag_id
+    remove_index :taggings, [:taggable_id, :taggable_type, :context]
+    add_index :taggings,
+              [:tag_id, :taggable_id, :taggable_type, :context, :tagger_id, :tagger_type],
+              unique: true, name: 'taggings_idx'
+  end
+
+  def self.down
+    remove_index :tags, :name
+
+    remove_index :taggings, name: 'taggings_idx'
+    add_index :taggings, :tag_id
+    add_index :taggings, [:taggable_id, :taggable_type, :context]
+  end
+end
diff --git a/db/migrate/20260624035151_add_taggings_counter_cache_to_tags.acts_as_taggable_on_engine.rb b/db/migrate/20260624035151_add_taggings_counter_cache_to_tags.acts_as_taggable_on_engine.rb
new file mode 100644
index 0000000..5a3f71a
--- /dev/null
+++ b/db/migrate/20260624035151_add_taggings_counter_cache_to_tags.acts_as_taggable_on_engine.rb
@@ -0,0 +1,15 @@
+# This migration comes from acts_as_taggable_on_engine (originally 3)
+class AddTaggingsCounterCacheToTags < ActiveRecord::Migration[4.2]
+  def self.up
+    add_column :tags, :taggings_count, :integer, default: 0
+
+    ActsAsTaggableOn::Tag.reset_column_information
+    ActsAsTaggableOn::Tag.find_each do |tag|
+      ActsAsTaggableOn::Tag.reset_counters(tag.id, :taggings)
+    end
+  end
+
+  def self.down
+    remove_column :tags, :taggings_count
+  end
+end
diff --git a/db/migrate/20260624035152_add_missing_taggable_index.acts_as_taggable_on_engine.rb b/db/migrate/20260624035152_add_missing_taggable_index.acts_as_taggable_on_engine.rb
new file mode 100644
index 0000000..f287376
--- /dev/null
+++ b/db/migrate/20260624035152_add_missing_taggable_index.acts_as_taggable_on_engine.rb
@@ -0,0 +1,10 @@
+# This migration comes from acts_as_taggable_on_engine (originally 4)
+class AddMissingTaggableIndex < ActiveRecord::Migration[4.2]
+  def self.up
+    add_index :taggings, [:taggable_id, :taggable_type, :context]
+  end
+
+  def self.down
+    remove_index :taggings, [:taggable_id, :taggable_type, :context]
+  end
+end
diff --git a/db/migrate/20260624035153_change_collation_for_tag_names.acts_as_taggable_on_engine.rb b/db/migrate/20260624035153_change_collation_for_tag_names.acts_as_taggable_on_engine.rb
new file mode 100644
index 0000000..4c144a8
--- /dev/null
+++ b/db/migrate/20260624035153_change_collation_for_tag_names.acts_as_taggable_on_engine.rb
@@ -0,0 +1,10 @@
+# This migration comes from acts_as_taggable_on_engine (originally 5)
+# This migration is added to circumvent issue #623 and have special characters
+# work properly
+class ChangeCollationForTagNames < ActiveRecord::Migration[4.2]
+  def up
+    if ActsAsTaggableOn::Utils.using_mysql?
+      execute("ALTER TABLE tags MODIFY name varchar(255) CHARACTER SET utf8 COLLATE utf8_bin;")
+    end
+  end
+end
diff --git a/db/migrate/20260625031409_add_missing_indexes_on_taggings.acts_as_taggable_on_engine.rb b/db/migrate/20260625031409_add_missing_indexes_on_taggings.acts_as_taggable_on_engine.rb
new file mode 100644
index 0000000..7c39589
--- /dev/null
+++ b/db/migrate/20260625031409_add_missing_indexes_on_taggings.acts_as_taggable_on_engine.rb
@@ -0,0 +1,23 @@
+# This migration comes from acts_as_taggable_on_engine (originally 6)
+if ActiveRecord.gem_version >= Gem::Version.new('5.0')
+  class AddMissingIndexesOnTaggings < ActiveRecord::Migration[4.2]; end
+else
+  class AddMissingIndexesOnTaggings < ActiveRecord::Migration; end
+end
+AddMissingIndexesOnTaggings.class_eval do
+  def change
+    add_index ActsAsTaggableOn.taggings_table, :tag_id unless index_exists? ActsAsTaggableOn.taggings_table, :tag_id
+    add_index ActsAsTaggableOn.taggings_table, :taggable_id unless index_exists? ActsAsTaggableOn.taggings_table, :taggable_id
+    add_index ActsAsTaggableOn.taggings_table, :taggable_type unless index_exists? ActsAsTaggableOn.taggings_table, :taggable_type
+    add_index ActsAsTaggableOn.taggings_table, :tagger_id unless index_exists? ActsAsTaggableOn.taggings_table, :tagger_id
+    add_index ActsAsTaggableOn.taggings_table, :context unless index_exists? ActsAsTaggableOn.taggings_table, :context
+
+    unless index_exists? ActsAsTaggableOn.taggings_table, [:tagger_id, :tagger_type]
+      add_index ActsAsTaggableOn.taggings_table, [:tagger_id, :tagger_type]
+    end
+
+    unless index_exists? ActsAsTaggableOn.taggings_table, [:taggable_id, :taggable_type, :tagger_id, :context], name: 'taggings_idy'
+      add_index ActsAsTaggableOn.taggings_table, [:taggable_id, :taggable_type, :tagger_id, :context], name: 'taggings_idy'
+    end
+  end
+end
diff --git a/db/migrate/20260626025705_add_search_vector_to_page_translations.rb b/db/migrate/20260626025705_add_search_vector_to_page_translations.rb
new file mode 100644
index 0000000..0747637
--- /dev/null
+++ b/db/migrate/20260626025705_add_search_vector_to_page_translations.rb
@@ -0,0 +1,47 @@
+class AddSearchVectorToPageTranslations < ActiveRecord::Migration[7.2]
+  def up
+    add_column :page_translations, :search_vector, :tsvector
+
+    execute <<~SQL
+      UPDATE page_translations
+      SET search_vector = to_tsvector(
+        'simple',
+        coalesce(title, '') || ' ' ||
+        coalesce(abstract, '') || ' ' ||
+        coalesce(body, '')
+      )
+    SQL
+
+    add_index :page_translations, :search_vector,
+              using: :gin,
+              name: 'index_page_translations_on_search_vector'
+
+    execute <<~SQL
+      CREATE OR REPLACE FUNCTION page_translations_search_vector_update()
+      RETURNS trigger AS $$
+      BEGIN
+        NEW.search_vector := to_tsvector(
+          'simple',
+          coalesce(NEW.title, '') || ' ' ||
+          coalesce(NEW.abstract, '') || ' ' ||
+          coalesce(NEW.body, '')
+        );
+        RETURN NEW;
+      END;
+      $$ LANGUAGE plpgsql;
+
+      CREATE TRIGGER page_translations_search_vector_trigger
+      BEFORE INSERT OR UPDATE ON page_translations
+      FOR EACH ROW EXECUTE PROCEDURE page_translations_search_vector_update();
+    SQL
+  end
+
+  def down
+    execute <<~SQL
+      DROP TRIGGER IF EXISTS page_translations_search_vector_trigger ON page_translations;
+      DROP FUNCTION IF EXISTS page_translations_search_vector_update();
+    SQL
+    remove_index :page_translations, name: 'index_page_translations_on_search_vector'
+    remove_column :page_translations, :search_vector
+  end
+end
diff --git a/db/migrate/20260626222953_remove_root_locale_from_page_translations.rb b/db/migrate/20260626222953_remove_root_locale_from_page_translations.rb
new file mode 100644
index 0000000..51fcfbc
--- /dev/null
+++ b/db/migrate/20260626222953_remove_root_locale_from_page_translations.rb
@@ -0,0 +1,10 @@
+class RemoveRootLocaleFromPageTranslations < ActiveRecord::Migration[7.2]
+  def up
+    count = execute("DELETE FROM page_translations WHERE locale = 'root'").cmd_tuples
+    say "Deleted #{count} root locale records from page_translations"
+  end
+
+  def down
+    raise ActiveRecord::IrreversibleMigration
+  end
+end