X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/2c52b067168084265ed577104fe1fa2677c6e620..0b24e77812c03adc6e7497bd6d01d1dadbeeed1a:/db/migrate/025_add_end_time_to_changesets.rb diff --git a/db/migrate/025_add_end_time_to_changesets.rb b/db/migrate/025_add_end_time_to_changesets.rb index 553fd9e2a..4941b72b9 100644 --- a/db/migrate/025_add_end_time_to_changesets.rb +++ b/db/migrate/025_add_end_time_to_changesets.rb @@ -7,8 +7,8 @@ class AddEndTimeToChangesets < ActiveRecord::Migration # it appears that execute will only accept string arguments, so # this is an ugly, ugly hack to get some sort of mysql/postgres # independence. now i have to go wash my brain with bleach. - #execute("update changesets set closed_at=(now()-'1 hour') where open=(1=0)") - #execute("update changesets set closed_at=(now()+'1 hour') where open=(1=1)") + execute("update changesets set closed_at=(now()-#{interval_constant('1 hour')}) where open=(1=0)") + execute("update changesets set closed_at=(now()+#{interval_constant('1 hour')}) where open=(1=1)") # remove the open column as it is unnecessary now and denormalises # the table.