Contents

class CreateBitCoreContentModules < ActiveRecord::Migration
  def change
    create_table :bit_core_content_modules do |t|
      t.string :title, null: false
      t.integer :position, null: false, default: 1
      t.integer :bit_core_tool_id, null: false

      t.timestamps
    end

    reversible do |dir|
      dir.up do
        execute <<-SQL
          ALTER TABLE bit_core_content_modules
            ADD CONSTRAINT bit_core_content_module_position UNIQUE (bit_core_tool_id, position)
            DEFERRABLE INITIALLY IMMEDIATE
        SQL

        execute <<-SQL
          ALTER TABLE bit_core_content_modules
            ADD CONSTRAINT fk_content_modules_tools
            FOREIGN KEY (bit_core_tool_id)
            REFERENCES bit_core_tools(id)
        SQL
      end

      dir.down do
        execute <<-SQL
          ALTER TABLE bit_core_content_modules
            DROP CONSTRAINT fk_content_modules_tools
        SQL

        execute <<-SQL
          ALTER TABLE bit_core_content_modules
            DROP CONSTRAINT IF EXISTS bit_core_content_module_position
        SQL
      end
    end
  end
end

Version data entries

16 entries across 16 versions & 1 rubygems

Version	Path
bit_core-1.4.7	db/migrate/20140415211458_create_bit_core_content_modules.rb
bit_core-2.0.0.beta2	db/migrate/20140415211458_create_bit_core_content_modules.rb
bit_core-2.0.0.beta1	db/migrate/20140415211458_create_bit_core_content_modules.rb
bit_core-1.4.6	db/migrate/20140415211458_create_bit_core_content_modules.rb
bit_core-1.4.5	db/migrate/20140415211458_create_bit_core_content_modules.rb
bit_core-1.2.2	db/migrate/20140415211458_create_bit_core_content_modules.rb
bit_core-1.2.1	db/migrate/20140415211458_create_bit_core_content_modules.rb
bit_core-1.2.0	db/migrate/20140415211458_create_bit_core_content_modules.rb
bit_core-1.1.6	db/migrate/20140415211458_create_bit_core_content_modules.rb
bit_core-1.1.5	db/migrate/20140415211458_create_bit_core_content_modules.rb
bit_core-1.1.4	db/migrate/20140415211458_create_bit_core_content_modules.rb
bit_core-1.1.3	db/migrate/20140415211458_create_bit_core_content_modules.rb
bit_core-1.1.2	db/migrate/20140415211458_create_bit_core_content_modules.rb
bit_core-1.1.1	db/migrate/20140415211458_create_bit_core_content_modules.rb
bit_core-1.1.0	db/migrate/20140415211458_create_bit_core_content_modules.rb
bit_core-1.0.0	db/migrate/20140415211458_create_bit_core_content_modules.rb