This repository has been archived on 2021-11-24. You can view files and clone it, but cannot push or open issues or pull requests.
phone_app/db/migrate/20200930164402_add_caches_to_line_stocks.rb
2021-08-23 10:26:02 +02:00

28 lines
1.6 KiB
Ruby

class AddCachesToLineStocks < ActiveRecord::Migration[6.0]
def change
add_column :line_stocks, :cc_price_ht_available, :decimal, :precision => 14, :scale => 2
add_column :line_stocks, :cc_price_ht_used, :decimal, :precision => 14, :scale => 2
add_column :line_stocks, :cc_price_u_ht, :decimal, :precision => 14, :scale => 2
add_column :line_stocks, :cc_price_u_kg_ht, :decimal, :precision => 14, :scale => 2
add_column :line_stocks, :cc_qte_kg, :decimal, :precision => 14, :scale => 2
add_column :line_stocks, :cc_qte_kg_per_unit, :decimal, :precision => 14, :scale => 2
add_column :line_stocks, :cc_qte_kg_available, :decimal, :precision => 14, :scale => 2
add_column :line_stocks, :cc_qte_kg_used, :decimal, :precision => 14, :scale => 2
add_column :line_stocks, :ac_price_ht_available, :decimal, :precision => 14, :scale => 2
add_column :line_stocks, :ac_price_ht_used, :decimal, :precision => 14, :scale => 2
add_column :line_stocks, :ac_price_u_ht, :decimal, :precision => 14, :scale => 2
add_column :line_stocks, :ac_price_u_kg_ht, :decimal, :precision => 14, :scale => 2
add_column :line_stocks, :ac_qte_kg, :decimal, :precision => 14, :scale => 2
add_column :line_stocks, :ac_qte_kg_per_unit, :decimal, :precision => 14, :scale => 2
add_column :line_stocks, :ac_qte_kg_available, :decimal, :precision => 14, :scale => 2
add_column :line_stocks, :ac_qte_kg_used, :decimal, :precision => 14, :scale => 2
LineStock.find_each do |ls|
ls.save
end
end
end