Contents

class CreateHasAttributeTables < ActiveRecord::Migration
  def up
    unless table_exists?(:attribute_types)
      create_table :attribute_types do |t|
        t.string :internal_identifier
        t.string :description
        t.string :data_type

        t.timestamps
      end

      add_index :attribute_types, :internal_identifier,  :name => ':attribute_types_iid_idx'
    end
    unless table_exists?(:attribute_values)
      create_table :attribute_values do |t|
        t.integer :attributed_record_id
        t.string :attributed_record_type
        t.references :attribute_type
        t.string  :value

        t.timestamps
      end

      add_index :attribute_values, [:attributed_record_id, :attributed_record_type], :name => 'attribute_values_attributed_record_idx'
      add_index :attribute_values, :attribute_type_id,  :name => 'attribute_values_attributed_type_idx'
      add_index :attribute_values, :value,  :name => 'attribute_values_value_idx'
    end
  end

  def down
    if table_exists?(:attribute_types)
      drop_table :attribute_types
    end
    if table_exists?(:attribute_values)
      drop_table :attribute_values
    end
  end
end

Version data entries

20 entries across 20 versions & 1 rubygems

Version	Path
erp_tech_svcs-3.1.8	db/migrate/20111117183144_create_has_attribute_tables.rb
erp_tech_svcs-3.1.7	db/migrate/20111117183144_create_has_attribute_tables.rb
erp_tech_svcs-3.1.5	db/migrate/20111117183144_create_has_attribute_tables.rb
erp_tech_svcs-3.1.4	db/migrate/20111117183144_create_has_attribute_tables.rb
erp_tech_svcs-3.1.3	db/migrate/20111117183144_create_has_attribute_tables.rb
erp_tech_svcs-3.1.2	db/migrate/20111117183144_create_has_attribute_tables.rb
erp_tech_svcs-3.1.1	db/migrate/20111117183144_create_has_attribute_tables.rb
erp_tech_svcs-3.0.12	db/migrate/20111117183144_create_has_attribute_tables.rb
erp_tech_svcs-3.1.0	db/migrate/20111117183144_create_has_attribute_tables.rb
erp_tech_svcs-3.0.11	db/migrate/20111117183144_create_has_attribute_tables.rb
erp_tech_svcs-3.0.10	db/migrate/20111117183144_create_has_attribute_tables.rb
erp_tech_svcs-3.0.9	db/migrate/20111117183144_create_has_attribute_tables.rb
erp_tech_svcs-3.0.8	db/migrate/20111117183144_create_has_attribute_tables.rb
erp_tech_svcs-3.0.7	db/migrate/20111117183144_create_has_attribute_tables.rb
erp_tech_svcs-3.0.6	db/migrate/20111117183144_create_has_attribute_tables.rb
erp_tech_svcs-3.0.5	db/migrate/20111117183144_create_has_attribute_tables.rb
erp_tech_svcs-3.0.4	db/migrate/20111117183144_create_has_attribute_tables.rb
erp_tech_svcs-3.0.3	db/migrate/20111117183144_create_has_attribute_tables.rb
erp_tech_svcs-3.0.2	db/migrate/20111117183144_create_has_attribute_tables.rb
erp_tech_svcs-3.0.1	db/migrate/20111117183144_create_has_attribute_tables.rb