Contents

class FilterMail < ActiveRecord::Migration
  def self.up
		add_column :subscribers, :filter, :integer, :default => 0
		execute 'ALTER TABLE subscribers ADD id SERIAL PRIMARY KEY'
		execute 'ALTER TABLE subscribers ADD created_on timestamptz NOT NULL DEFAULT now();'
		execute 'ALTER TABLE subscribers RENAME TO subscriptions'
    create_table :person_mails do |t|
			t.column :mail_id, :string, :null => false
			t.column :person_id, :string
			t.column :created_on, :datetime, :null => false
    end
  end

  def self.down
		execute 'ALTER TABLE subscriptions RENAME TO subscribers'
		remove_column :subscribers, :id
		remove_column :subscribers, :filter
		remove_column :subscribers, :created_on
    drop_table :person_mails
  end
end

Version data entries

6 entries across 6 versions & 1 rubygems

Version	Path
parlement-0.10	db/migrate/005_filter_mail.rb
parlement-0.11	db/migrate/005_filter_mail.rb
parlement-0.12	db/migrate/005_filter_mail.rb
parlement-0.13	db/migrate/005_filter_mail.rb
parlement-0.14	db/migrate/005_filter_mail.rb
parlement-0.17	db/migrate/005_filter_mail.rb