Sha256: b01c6f528441519805789afc146e57a94f3468d5aa1b2b6f380a2bf1df9a9322

Contents?: true

Size: 303 Bytes

Versions: 5

Compression:

Stored size: 303 Bytes

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