40 lines
1.7 KiB
Ruby
40 lines
1.7 KiB
Ruby
class AddNavToPFournisseurs < ActiveRecord::Migration[6.0]
|
|
def change
|
|
add_column :p_fournisseurs, :website, :string
|
|
add_column :p_fournisseurs, :siren, :string
|
|
add_column :p_fournisseurs, :ape, :string
|
|
add_column :p_fournisseurs, :tva_intra, :string
|
|
add_column :p_fournisseurs, :imported, :boolean
|
|
|
|
add_column :p_fournisseurs, :particular_id, :integer
|
|
|
|
add_column :p_fournisseurs, :nav_vat_posting_group, :string
|
|
add_column :p_fournisseurs, :nav_search_name, :string
|
|
add_column :p_fournisseurs, :nav_name_2, :string
|
|
add_column :p_fournisseurs, :nav_modified_by, :string
|
|
add_column :p_fournisseurs, :nav_sales_representative_code, :string
|
|
add_column :p_fournisseurs, :nav_customer_posting_group, :string
|
|
add_column :p_fournisseurs, :nav_payment_terms_code, :string
|
|
add_column :p_fournisseurs, :nav_invoice_disc_code, :string
|
|
add_column :p_fournisseurs, :nav_country_region_code, :string
|
|
add_column :p_fournisseurs, :nav_payment_method_code, :string
|
|
add_column :p_fournisseurs, :nav_gen_bus_posting_group, :string
|
|
add_column :p_fournisseurs, :nav_reminder_terms_code, :string
|
|
add_column :p_fournisseurs, :nav_no_series, :string
|
|
add_column :p_fournisseurs, :nav_vat_bus_posting_group, :string
|
|
add_column :p_fournisseurs, :nav_primary_contact_no, :string
|
|
|
|
add_column :p_fournisseurs, :nav_vendor_qualification, :string
|
|
add_column :p_fournisseurs, :nav_blocked, :string
|
|
add_column :p_fournisseurs, :nav_shipment_method_code, :string
|
|
add_column :p_fournisseurs, :nav_purchaser_code, :string
|
|
|
|
|
|
|
|
add_column :p_fournisseurs, :nav_last_date_modified, :datetime
|
|
|
|
|
|
|
|
end
|
|
end
|