Contents

class AddForeignKeyIndicesAndNullConstraints < ActiveRecord::Migration[4.2]
  def change
    change_column_null :alchemy_cells, :page_id, false, 0
    change_column_null :alchemy_contents, :element_id, false, 0
    change_column_null :alchemy_contents, :essence_id, false, 0
    change_column_null :alchemy_contents, :essence_type, false, 'Alchemy::EssenceText'
    change_column_null :alchemy_elements, :page_id, false, 0
    change_column_null :alchemy_folded_pages, :page_id, false, 0
    change_column_null :alchemy_folded_pages, :user_id, false, 0
    change_column_null :alchemy_languages, :site_id, false, 0

    add_index :alchemy_cells, :page_id
    add_index :alchemy_contents, [:essence_id, :essence_type], unique: true
    add_index :alchemy_elements, :cell_id
    add_index :alchemy_essence_files, :attachment_id
    add_index :alchemy_essence_pictures, :picture_id
    add_index :alchemy_folded_pages, [:page_id, :user_id], unique: true
    add_index :alchemy_legacy_page_urls, :page_id
  end
end

Version data entries

9 entries across 9 versions & 1 rubygems

Version	Path
alchemy_cms-4.0.6	db/migrate/20160927205604_add_foreign_key_indices_and_null_constraints.rb
alchemy_cms-4.0.5	db/migrate/20160927205604_add_foreign_key_indices_and_null_constraints.rb
alchemy_cms-4.0.4	db/migrate/20160927205604_add_foreign_key_indices_and_null_constraints.rb
alchemy_cms-4.0.3	db/migrate/20160927205604_add_foreign_key_indices_and_null_constraints.rb
alchemy_cms-4.0.2	db/migrate/20160927205604_add_foreign_key_indices_and_null_constraints.rb
alchemy_cms-4.0.1	db/migrate/20160927205604_add_foreign_key_indices_and_null_constraints.rb
alchemy_cms-4.0.0	db/migrate/20160927205604_add_foreign_key_indices_and_null_constraints.rb
alchemy_cms-4.0.0.rc2	db/migrate/20160927205604_add_foreign_key_indices_and_null_constraints.rb
alchemy_cms-4.0.0.rc1	db/migrate/20160927205604_add_foreign_key_indices_and_null_constraints.rb