class CreateAlpReports < ActiveRecord::Migration
  def self.up
    create_table :alp_reports do |t|
      t.string :type
      t.datetime :date_from
      t.datetime :date_to
      t.decimal :downtime, :precision => 5, :scale => 2, :default => 0
      t.decimal :adm_downtime, :precision => 5, :scale => 2, :default => 0
      t.integer :category
      t.boolean :w_rain
      t.boolean :w_temp
      t.boolean :w_wind
      t.text :other_materials
      t.text :downtime_desc
      t.text :conflicts
      t.text :error_desc
      t.string :all_desc

      t.timestamps
    end
  end

  def self.down
    drop_table :alp_reports
  end
end