Contents

class CreateSiteMessages < ActiveRecord::Migration
  def change
    create_table :site_messages do |t|
      t.references :participant, index: true, null: false
      t.string :subject, null: false
      t.text :body, null: false

      t.timestamps
    end

    reversible do |dir|
      dir.up do
        execute <<-SQL
          ALTER TABLE site_messages
            ADD CONSTRAINT fk_site_messages_participants
            FOREIGN KEY (participant_id)
            REFERENCES participants(id)
        SQL
      end

      dir.down do
        execute <<-SQL
          ALTER TABLE site_messages
            DROP CONSTRAINT fk_site_messages_participants
        SQL
      end
    end
  end
end

Version data entries

68 entries across 68 versions & 1 rubygems

Version	Path
think_feel_do_engine-3.12.0	db/migrate/20141110190545_create_site_messages.rb
think_feel_do_engine-3.11.3	db/migrate/20141110190545_create_site_messages.rb
think_feel_do_engine-3.11.0	db/migrate/20141110190545_create_site_messages.rb
think_feel_do_engine-3.10.10	db/migrate/20141110190545_create_site_messages.rb
think_feel_do_engine-3.10.9	db/migrate/20141110190545_create_site_messages.rb
think_feel_do_engine-3.10.8	db/migrate/20141110190545_create_site_messages.rb
think_feel_do_engine-3.10.7	db/migrate/20141110190545_create_site_messages.rb
think_feel_do_engine-3.10.6	db/migrate/20141110190545_create_site_messages.rb