class UpdateStorageLocationsFromArchitecture < ActiveRecord::Migration[8.1]
  def change
    change_table :storage_locations do |t|
      # Add defaults for boolean fields
      t.change_default :writable, false
      t.change_default :enabled, true
      t.change_default :scan_subdirectories, true
      t.change_default :priority, 0

      # Add location_type default and make required fields not null
      t.change_default :location_type, 0
      t.change_null :location_type, false

      # Make name required
      t.change_null :name, false
    end

    # Add indexes as specified in architecture
    add_index :storage_locations, :name, unique: true
    add_index :storage_locations, :location_type
    add_index :storage_locations, :enabled
    add_index :storage_locations, :priority
  end
end