class AddInfosToOrderHistLines < ActiveRecord::Migration[6.0]
  def change
    add_column :order_hist_lines, :cc_montant_ht, :decimal,   :precision => 14,   :scale => 2
    add_column :order_hist_lines, :cc_montant_ht_remise, :decimal,   :precision => 14,   :scale => 2
    add_column :order_hist_lines, :cc_montant_ht_com, :decimal,   :precision => 14,   :scale => 2
    add_column :order_hist_lines, :cc_cout_achat_ht, :decimal,   :precision => 14,   :scale => 2
    add_column :order_hist_lines, :cc_marge_brut_hors_remise, :decimal,   :precision => 14,   :scale => 2
    add_column :order_hist_lines, :cc_marge_brut_remise, :decimal,   :precision => 14,   :scale => 2
    add_column :order_hist_lines, :cc_marge_net, :decimal,   :precision => 14,   :scale => 2
    add_column :order_hist_lines, :cc_marge_brut_hors_remise_pa, :decimal,   :precision => 14,   :scale => 2
    add_column :order_hist_lines, :cc_marge_brut_remise_pa, :decimal,   :precision => 14,   :scale => 2
    add_column :order_hist_lines, :cc_marge_net_ht_pa, :decimal,   :precision => 14,   :scale => 2
    
    add_column :order_hist_lines, :ac_montant_ht, :decimal,   :precision => 14,   :scale => 2
    add_column :order_hist_lines, :ac_montant_ht_remise, :decimal,   :precision => 14,   :scale => 2
    add_column :order_hist_lines, :ac_montant_ht_com, :decimal,   :precision => 14,   :scale => 2
    add_column :order_hist_lines, :ac_cout_achat_ht, :decimal,   :precision => 14,   :scale => 2
    add_column :order_hist_lines, :ac_marge_brut_hors_remise, :decimal,   :precision => 14,   :scale => 2
    add_column :order_hist_lines, :ac_marge_brut_remise, :decimal,   :precision => 14,   :scale => 2
    add_column :order_hist_lines, :ac_marge_net, :decimal,   :precision => 14,   :scale => 2
    add_column :order_hist_lines, :ac_marge_brut_hors_remise_pa, :decimal,   :precision => 14,   :scale => 2
    add_column :order_hist_lines, :ac_marge_brut_remise_pa, :decimal,   :precision => 14,   :scale => 2
    add_column :order_hist_lines, :ac_marge_net_ht_pa, :decimal,   :precision => 14,   :scale => 2
    
  end
end
