Contents

class CleanupContentsTable < ActiveRecord::Migration
  def self.up
    remove_index(:contents, :article_id) rescue nil

    remove_column :contents, :article_id rescue nil
    remove_column :contents, :email 
    remove_column :contents, :url
    remove_column :contents, :ip
    remove_column :contents, :blog_name
    remove_column :contents, :status_confirmed

    add_index :contents, :published
    add_index :contents, :text_filter_id
  end

  def self.down
    remove_index :contents, :published
    remove_index :contents, :text_filter_id

    add_column :contents, :article_id, :integer
    add_column :contents, :email, :string
    add_column :contents, :url, :string
    add_column :contents, :ip, :string, :limit => 40
    add_column :contents, :blog_name, :string
    add_column :contents, :status_confirmed, :boolean

    add_index :contents, :article_id
  end
end

Version data entries

13 entries across 13 versions & 1 rubygems

Version	Path
typo-5.0.2	db/migrate/060_cleanup_contents_table.rb
typo-5.0.1	db/migrate/060_cleanup_contents_table.rb
typo-5.0.3.98.1	db/migrate/060_cleanup_contents_table.rb
typo-5.0.3.98	db/migrate/060_cleanup_contents_table.rb
typo-5.0	db/migrate/060_cleanup_contents_table.rb
typo-5.1.1	db/migrate/060_cleanup_contents_table.rb
typo-5.1.2	db/migrate/060_cleanup_contents_table.rb
typo-5.1.3	db/migrate/060_cleanup_contents_table.rb
typo-5.1	db/migrate/060_cleanup_contents_table.rb
typo-5.1.98	db/migrate/060_cleanup_contents_table.rb
typo-5.2	db/migrate/060_cleanup_contents_table.rb
typo-5.2.98	db/migrate/060_cleanup_contents_table.rb
typo-5.3	db/migrate/060_cleanup_contents_table.rb