aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorLouise Crow <louise.crow@gmail.com>2012-11-20 16:09:00 +0000
committerLouise Crow <louise.crow@gmail.com>2012-11-20 16:09:00 +0000
commitb0d9551a83c4a101ac808f1c35f66dd138cbc0f1 (patch)
tree10eb03a8c4b186bbcf1bd5b275a05fb7e9c8c776
parent05d7d032283647a3ee1e8631b089510b9ecfee14 (diff)
Remove old code.
-rw-r--r--db/migrate/098_fix_public_body_translations.rb12
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
;