Contents

class LastActivity < ActiveRecord::Migration
  def self.up
		add_column :elts, :last_activity, :datetime
		execute 'UPDATE elts SET last_activity = (SELECT MAX(created_on) FROM elts c WHERE elts.lft <= c.lft AND c.rgt <= elts.rgt)'
  end

  def self.down
		remove_column :elts, :last_activity
  end
end

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
parlement-0.11	db/migrate/006_last_activity.rb
parlement-0.12	db/migrate/006_last_activity.rb
parlement-0.13	db/migrate/006_last_activity.rb
parlement-0.14	db/migrate/006_last_activity.rb
parlement-0.17	db/migrate/006_last_activity.rb