Sha256: 80445444b21f06da57e6425f7115c9c1555191396d3d94a3a665a43f2d14fb93

Contents?: true

Size: 823 Bytes

Versions: 16

Compression:

Stored size: 823 Bytes

Contents

class CreateSocialNetworkingGoals < ActiveRecord::Migration
  def change
    create_table :social_networking_goals do |t|
      t.string :description, null: false
      t.integer :participant_id, null: false
      t.boolean :is_completed, null: false, default: false
      t.boolean :is_deleted, null: false, default: false
      t.date :due_on

      t.timestamps
    end

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

      dir.down do
        execute <<-SQL
          ALTER TABLE social_networking_goals
            DROP CONSTRAINT IF EXISTS fk_goals_participants
        SQL
      end
    end
  end
end

Version data entries

16 entries across 16 versions & 1 rubygems

Version Path
social_networking-0.13.3 db/migrate/20140904201719_create_social_networking_goals.rb
social_networking-0.13.2 db/migrate/20140904201719_create_social_networking_goals.rb
social_networking-0.13.1 db/migrate/20140904201719_create_social_networking_goals.rb
social_networking-0.13.0 db/migrate/20140904201719_create_social_networking_goals.rb
social_networking-0.12.0 db/migrate/20140904201719_create_social_networking_goals.rb
social_networking-0.11.8 db/migrate/20140904201719_create_social_networking_goals.rb
social_networking-0.11.7 db/migrate/20140904201719_create_social_networking_goals.rb
social_networking-0.11.6 db/migrate/20140904201719_create_social_networking_goals.rb
social_networking-0.11.5 db/migrate/20140904201719_create_social_networking_goals.rb
social_networking-0.11.4 db/migrate/20140904201719_create_social_networking_goals.rb
social_networking-0.11.3 db/migrate/20140904201719_create_social_networking_goals.rb
social_networking-0.11.2 db/migrate/20140904201719_create_social_networking_goals.rb
social_networking-0.11.1 db/migrate/20140904201719_create_social_networking_goals.rb
social_networking-0.11.0 db/migrate/20140904201719_create_social_networking_goals.rb
social_networking-0.10.0 db/migrate/20140904201719_create_social_networking_goals.rb
social_networking-0.9.3 db/migrate/20140904201719_create_social_networking_goals.rb