Contents

class AddPagesUrlPart < ActiveRecord::Migration
  def self.up
    add_column :skyline_pages, :url_part, :string, :null => false
    execute "UPDATE skyline_pages SET url_part = CONCAT('page-', position)"
    execute "UPDATE skyline_pages SET url_part = NULL where page_id is NULL"
  end

  def self.down
    remove_column :skyline_pages, :url_part
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
skylinecms-3.0.7	db/migrate/20090526090049_add_pages_url_part.rb