Contents

class AddInvoiceAddressToInvoice < ActiveRecord::Migration[7.1]
  def change
    add_column :comee_core_invoices, :invoice_address_id, :bigint

    reversible do |dir|
      sql = <<-SQL
        UPDATE comee_core_invoices
        SET invoice_address_id = comee_core_sales_orders.invoice_address_id
        FROM comee_core_sales_orders
        WHERE comee_core_invoices.sales_order_id = comee_core_sales_orders.id
      SQL
      dir.up do
        execute sql
      end
    end
    change_column_null :comee_core_invoices, :invoice_address_id, false
    add_foreign_key :comee_core_invoices, :comee_core_client_addresses, column: :invoice_address_id
    add_index :comee_core_invoices, :invoice_address_id, name: "ia_on_cci_indx"
  end
end

Version data entries

26 entries across 26 versions & 1 rubygems

Version	Path
comee_core-0.3.62	db/migrate/20240721035647_add_invoice_address_to_invoice.rb
comee_core-0.3.61	db/migrate/20240721035647_add_invoice_address_to_invoice.rb
comee_core-0.3.60	db/migrate/20240721035647_add_invoice_address_to_invoice.rb
comee_core-0.3.59	db/migrate/20240721035647_add_invoice_address_to_invoice.rb
comee_core-0.3.58	db/migrate/20240721035647_add_invoice_address_to_invoice.rb
comee_core-0.3.57	db/migrate/20240721035647_add_invoice_address_to_invoice.rb
comee_core-0.3.56	db/migrate/20240721035647_add_invoice_address_to_invoice.rb
comee_core-0.3.55	db/migrate/20240721035647_add_invoice_address_to_invoice.rb
comee_core-0.3.54	db/migrate/20240721035647_add_invoice_address_to_invoice.rb
comee_core-0.3.53	db/migrate/20240721035647_add_invoice_address_to_invoice.rb
comee_core-0.3.51	db/migrate/20240721035647_add_invoice_address_to_invoice.rb
comee_core-0.3.50	db/migrate/20240721035647_add_invoice_address_to_invoice.rb
comee_core-0.3.49	db/migrate/20240721035647_add_invoice_address_to_invoice.rb
comee_core-0.3.48	db/migrate/20240721035647_add_invoice_address_to_invoice.rb
comee_core-0.3.47	db/migrate/20240721035647_add_invoice_address_to_invoice.rb
comee_core-0.3.46	db/migrate/20240721035647_add_invoice_address_to_invoice.rb
comee_core-0.3.45	db/migrate/20240721035647_add_invoice_address_to_invoice.rb
comee_core-0.3.44	db/migrate/20240721035647_add_invoice_address_to_invoice.rb
comee_core-0.3.43	db/migrate/20240721035647_add_invoice_address_to_invoice.rb
comee_core-0.3.42	db/migrate/20240721035647_add_invoice_address_to_invoice.rb