diff options
author | Louise Crow <louise.crow@gmail.com> | 2012-11-20 16:09:00 +0000 |
---|---|---|
committer | Louise Crow <louise.crow@gmail.com> | 2012-11-20 16:09:00 +0000 |
commit | b0d9551a83c4a101ac808f1c35f66dd138cbc0f1 (patch) | |
tree | 10eb03a8c4b186bbcf1bd5b275a05fb7e9c8c776 | |
parent | 05d7d032283647a3ee1e8631b089510b9ecfee14 (diff) |
Remove old code.
-rw-r--r-- | db/migrate/098_fix_public_body_translations.rb | 12 |
1 files changed, 2 insertions, 10 deletions
diff --git a/db/migrate/098_fix_public_body_translations.rb b/db/migrate/098_fix_public_body_translations.rb index 5788d7dde..25f36336f 100644 --- a/db/migrate/098_fix_public_body_translations.rb +++ b/db/migrate/098_fix_public_body_translations.rb @@ -15,18 +15,10 @@ class FixPublicBodyTranslations < ActiveRecord::Migration where first_letter is null ; SQL - -# execute <<-SQL -# update public_body_translations -# set publication_scheme = public_bodies.publication_scheme -# from public_bodies -# where public_body_translations.public_body_id = public_bodies.id -# and public_body_translations.publication_scheme is null -# ; -# SQL + execute <<-SQL update public_body_translations - set publication_scheme = (SELECT public_bodies.publication_scheme FROM public_bodies WHERE + set publication_scheme = (SELECT public_bodies.publication_scheme FROM public_bodies WHERE public_body_translations.public_body_id = public_bodies.id ) where public_body_translations.publication_scheme is null ; |