view db/migrate/20131218183023_delete_orphan_time_entries_custom_values.rb @ 1556:81dd71991dc1 feature_1136

hg-hash option does not appear reliable ("Not updating refs/notes/hg (new tip XXX does not contain YYY")

class DeleteOrphanTimeEntriesCustomValues < ActiveRecord::Migration
  def up
    CustomValue.where("customized_type = ? AND NOT EXISTS (SELECT 1 FROM #{TimeEntry.table_name} t WHERE t.id = customized_id)", "TimeEntry").delete_all
  end

  def down
    # nop
  end
end