class CreateInvPhotographerBillings < ActiveRecord::Migration[6.0]
  def change
    create_table :inv_photographer_billings do |t|
      t.integer "user_id", null: false
      t.integer "billing_type_id", null: false
      t.string "number"
      t.string "sub_number"
      t.integer "photographer_billing_company_id"
      t.date "date"
      t.date "deadline"
      t.decimal "paid", precision: 10, scale: 3, default: "0.0", null: false
      t.integer "discount_type_id", null: false
      t.text "conditions"
      t.decimal "total", precision: 10, scale: 3, default: "0.0", null: false
      t.decimal "discount", precision: 10, scale: 3, default: "0.0", null: false
      t.decimal "total_ht", precision: 10, scale: 3, default: "0.0", null: false
      t.decimal "general_discount", precision: 10, scale: 3, default: "0.0", null: false
      t.decimal "total_ht_final", precision: 10, scale: 3, default: "0.0", null: false
      t.decimal "vat", precision: 10, scale: 3, default: "0.0", null: false
      t.decimal "total_ttc", precision: 10, scale: 3, default: "0.0", null: false
      t.text "state", null: false
      t.text "heading"
      t.index "user_id"
      t.index "photographer_billing_company_id", name: "index_photographer_billing_company_id"
    end

    parameter = Parameter.find_by(key: 'billing')
    parameter.update_columns(value: 'agency') if parameter&.value == '1'
  end
end