Sha256: b5ad2c52a42e34e0314632ee5804498fc31b4a01f46fdc722bbed2881deef7c2

Contents?: true

Size: 1.47 KB

Versions: 20

Compression:

Stored size: 1.47 KB

Contents

# This migration comes from erp_base_erp_svcs (originally 20130211444444)
# This migration comes from erp_base_erp_svcs (originally 20130211444444)
class UpgradeCompassAeInstances < ActiveRecord::Migration
  def self.up
    unless columns(:compass_ae_instances).collect {|c| c.name}.include?('type')
      add_column :compass_ae_instances, :description, :string
      add_column :compass_ae_instances, :internal_identifier, :string
      add_column :compass_ae_instances, :type, :string
      add_column :compass_ae_instances, :schema, :string, :default => 'public'
      add_column :compass_ae_instances, :parent_id, :integer

      add_index :compass_ae_instances, :internal_identifier, :name => "iid_idx" 
      add_index :compass_ae_instances, :schema, :name => "schema_idx"
      add_index :compass_ae_instances, :type, :name => "type_idx"
      add_index :compass_ae_instances, :parent_id, :name => "parent_id_idx"
    end
  end

  unless table_exists?(:compass_ae_instance_party_roles)
    create_table :compass_ae_instance_party_roles do |t|
      t.string :description
      t.integer :compass_ae_instance_id
      t.integer :party_id
      t.integer :role_type_id
      
      t.timestamps
    end

    add_index :compass_ae_instance_party_roles, :compass_ae_instance_id, :name => "compass_ae_instance_id_idx"
    add_index :compass_ae_instance_party_roles, :party_id, :name => "party_id_idx"
    add_index :compass_ae_instance_party_roles, :role_type_id, :name => "role_type_id_idx"
  end
  
end

Version data entries

20 entries across 20 versions & 6 rubygems

Version Path
erp_tech_svcs-3.1.8 spec/dummy/db/migrate/20130220143261_upgrade_compass_ae_instances.erp_base_erp_svcs.rb
knitkit-2.1.14 spec/dummy/db/migrate/20130422154402_upgrade_compass_ae_instances.erp_base_erp_svcs.rb
knitkit-2.1.13 spec/dummy/db/migrate/20130422154402_upgrade_compass_ae_instances.erp_base_erp_svcs.rb
erp_app-3.1.14 spec/dummy/db/migrate/20130422163123_upgrade_compass_ae_instances.erp_base_erp_svcs.rb
knitkit-2.1.12 spec/dummy/db/migrate/20130422154402_upgrade_compass_ae_instances.erp_base_erp_svcs.rb
erp_tech_svcs-3.1.5 spec/dummy/db/migrate/20130220143261_upgrade_compass_ae_instances.erp_base_erp_svcs.rb
erp_app-3.1.12 spec/dummy/db/migrate/20130422163123_upgrade_compass_ae_instances.erp_base_erp_svcs.rb
erp_base_erp_svcs-3.1.5 spec/dummy/db/migrate/20130422154230_upgrade_compass_ae_instances.erp_base_erp_svcs.rb
knitkit-2.1.9 spec/dummy/db/migrate/20130422154402_upgrade_compass_ae_instances.erp_base_erp_svcs.rb
knitkit-2.1.8 spec/dummy/db/migrate/20130422154402_upgrade_compass_ae_instances.erp_base_erp_svcs.rb
erp_tech_svcs-3.1.4 spec/dummy/db/migrate/20130220143261_upgrade_compass_ae_instances.erp_base_erp_svcs.rb
erp_base_erp_svcs-3.1.4 spec/dummy/db/migrate/20130422154230_upgrade_compass_ae_instances.erp_base_erp_svcs.rb
erp_app-3.1.10 spec/dummy/db/migrate/20130422163123_upgrade_compass_ae_instances.erp_base_erp_svcs.rb
erp_app-3.1.8 spec/dummy/db/migrate/20130422163123_upgrade_compass_ae_instances.erp_base_erp_svcs.rb
erp_txns_and_accts-3.1.1 spec/dummy/db/migrate/20130422155325_upgrade_compass_ae_instances.erp_base_erp_svcs.rb
erp_commerce-3.1.3 spec/dummy/db/migrate/20130422155142_upgrade_compass_ae_instances.erp_base_erp_svcs.rb
knitkit-2.1.5 spec/dummy/db/migrate/20130422154402_upgrade_compass_ae_instances.erp_base_erp_svcs.rb
erp_app-3.1.6 spec/dummy/db/migrate/20130422153806_upgrade_compass_ae_instances.erp_base_erp_svcs.rb
erp_tech_svcs-3.1.3 spec/dummy/db/migrate/20130220143261_upgrade_compass_ae_instances.erp_base_erp_svcs.rb
erp_base_erp_svcs-3.1.3 spec/dummy/db/migrate/20130422154230_upgrade_compass_ae_instances.erp_base_erp_svcs.rb