Contents

class CreateBitPlayerContentProviders < ActiveRecord::Migration
  def change
    create_table :bit_player_content_providers do |t|
      t.string :type, null: false
      t.string :source_content_type
      t.integer :source_content_id
      t.references :bit_player_content_module, null: false
      t.integer :position, null: false, default: 1

      t.timestamps
    end

    add_index :bit_player_content_providers, :bit_player_content_module_id, name: "content_module_index"

    reversible do |dir|
      dir.up do
        execute <<-SQL
          ALTER TABLE bit_player_content_providers
            ADD CONSTRAINT fk_content_providers_modules
            FOREIGN KEY (bit_player_content_module_id)
            REFERENCES bit_player_content_modules(id)
        SQL
      end

      dir.down do
        execute <<-SQL
          ALTER TABLE bit_player_content_providers
            DROP CONSTRAINT fk_content_providers_modules
        SQL
      end
    end
  end
end

Version data entries

18 entries across 18 versions & 1 rubygems

Version	Path
bit_player-0.4.10	db/migrate/20140305201300_create_bit_player_content_providers.rb
bit_player-0.4.9	db/migrate/20140305201300_create_bit_player_content_providers.rb
bit_player-0.5.0	db/migrate/20140305201300_create_bit_player_content_providers.rb
bit_player-0.4.4	db/migrate/20140305201300_create_bit_player_content_providers.rb
bit_player-0.4.3	db/migrate/20140305201300_create_bit_player_content_providers.rb
bit_player-0.4.2	db/migrate/20140305201300_create_bit_player_content_providers.rb
bit_player-0.4.1	db/migrate/20140305201300_create_bit_player_content_providers.rb
bit_player-0.4.0	db/migrate/20140305201300_create_bit_player_content_providers.rb
bit_player-0.3.0	db/migrate/20140305201300_create_bit_player_content_providers.rb
bit_player-0.2.5	db/migrate/20140305201300_create_bit_player_content_providers.rb
bit_player-0.2.3	db/migrate/20140305201300_create_bit_player_content_providers.rb
bit_player-0.2.2	db/migrate/20140305201300_create_bit_player_content_providers.rb
bit_player-0.2.1	db/migrate/20140305201300_create_bit_player_content_providers.rb
bit_player-0.2.0	db/migrate/20140305201300_create_bit_player_content_providers.rb
bit_player-0.1.4	db/migrate/20140305201300_create_bit_player_content_providers.rb
bit_player-0.1.3	db/migrate/20140305201300_create_bit_player_content_providers.rb
bit_player-0.1.2	db/migrate/20140305201300_create_bit_player_content_providers.rb
bit_player-0.1.1	db/migrate/20140305201300_create_bit_player_content_providers.rb