Contents

class AddFirstPublishedAtToEntries < ActiveRecord::Migration
  def change
    add_column :pageflow_entries, :first_published_at, :datetime

    execute(<<-SQL)
      UPDATE pageflow_entries SET first_published_at = (
        SELECT MIN(published_at)
        FROM pageflow_revisions
        WHERE pageflow_revisions.entry_id = pageflow_entries.id
        LIMIT 1
      );
    SQL
  end
end

Version data entries

28 entries across 28 versions & 1 rubygems

Version	Path
pageflow-12.6.0	db/migrate/20151022080518_add_first_published_at_to_entries.rb
pageflow-12.5.0	db/migrate/20151022080518_add_first_published_at_to_entries.rb
pageflow-12.4.1	db/migrate/20151022080518_add_first_published_at_to_entries.rb
pageflow-12.4.0	db/migrate/20151022080518_add_first_published_at_to_entries.rb
pageflow-12.3.0	db/migrate/20151022080518_add_first_published_at_to_entries.rb
pageflow-12.2.0	db/migrate/20151022080518_add_first_published_at_to_entries.rb
pageflow-12.1.0	db/migrate/20151022080518_add_first_published_at_to_entries.rb
pageflow-12.0.4	db/migrate/20151022080518_add_first_published_at_to_entries.rb
pageflow-12.0.3	db/migrate/20151022080518_add_first_published_at_to_entries.rb
pageflow-12.0.2	db/migrate/20151022080518_add_first_published_at_to_entries.rb
pageflow-12.0.1	db/migrate/20151022080518_add_first_published_at_to_entries.rb
pageflow-12.0.0	db/migrate/20151022080518_add_first_published_at_to_entries.rb
pageflow-12.0.0.rc7	db/migrate/20151022080518_add_first_published_at_to_entries.rb
pageflow-12.0.0.rc6	db/migrate/20151022080518_add_first_published_at_to_entries.rb
pageflow-0.11.4	db/migrate/20151022080518_add_first_published_at_to_entries.rb
pageflow-12.0.0.rc5	db/migrate/20151022080518_add_first_published_at_to_entries.rb
pageflow-12.0.0.rc4	db/migrate/20151022080518_add_first_published_at_to_entries.rb
pageflow-12.0.0.rc3	db/migrate/20151022080518_add_first_published_at_to_entries.rb
pageflow-12.0.0.rc2	db/migrate/20151022080518_add_first_published_at_to_entries.rb
pageflow-12.0.0.rc1	db/migrate/20151022080518_add_first_published_at_to_entries.rb