1 files changed, 10 insertions, 0 deletions

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