asas

class ChangePageToSectionPageInSiteTemplates < ActiveRecord::Migration

  def up
    remove_index :site_templates, :site_section_id
    remove_index :site_templates, :page_id
    remove_column :site_templates, :page_id
    remove_column :site_templates, :site_section_id

    add_column :site_templates, :site_section_id, :integer, default: 0, null: false

    SiteTemplate.reset_column_information
    SiteTemplate.all.each do |template|
      template.site_section = template.site.site_sections.includes(:section).where("'sections'.'code' = 'core'").first
      template.save!
    end

    change_column :site_templates, :site_section_id, :integer, null: false

    add_column :site_templates, :section_page_id, :integer
    add_index :site_templates, :site_section_id
    add_index :site_templates, :section_page_id
  end

  def down
    remove_column :site_templates, :site_section_id
    remove_column :site_templates, :section_page_id
    remove_index :site_templates, :site_section_id
    remove_index :site_templates, :section_page_id
  end
end