diff options
| author | Louise Crow <louise.crow@gmail.com> | 2012-11-20 16:07:51 +0000 |
|---|---|---|
| committer | Louise Crow <louise.crow@gmail.com> | 2012-11-20 16:07:51 +0000 |
| commit | 05d7d032283647a3ee1e8631b089510b9ecfee14 (patch) | |
| tree | 66709569c9c7014bb1787db7b5e1274918db10f8 | |
| parent | fc9515ea08c3c53ef761e0a76e7704e7a23a1ee7 (diff) | |
| parent | a8bcbfb548f75635800205ae3cc56b69f731d10f (diff) | |
Merge remote-tracking branch 'stefan_github/develop' into develop
| -rw-r--r-- | db/migrate/098_fix_public_body_translations.rb | 15 |
1 files changed, 11 insertions, 4 deletions
diff --git a/db/migrate/098_fix_public_body_translations.rb b/db/migrate/098_fix_public_body_translations.rb index 9bcefb1c0..5788d7dde 100644 --- a/db/migrate/098_fix_public_body_translations.rb +++ b/db/migrate/098_fix_public_body_translations.rb @@ -16,12 +16,19 @@ class FixPublicBodyTranslations < ActiveRecord::Migration ; 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 = 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 + 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 ; SQL end |