db/migrate/20160110133824_create_loc_ids.rb

class CreateLocIds < ActiveRecord::Migration
  def up
    create_table :loc_ids do |t|
      t.text :locid, null: false
      t.integer :specific_id, null: false
      t.string :specific_type, null: false

      t.timestamps
    end
    add_index :loc_ids, :locid, unique: true
  end

  def down
    drop_table :loc_ids
    remove_index :loc_ids, :locid
  end
end