gistfile3.txt

reserved-dhcp-165-124-223-118:migrate davidyip$ RAILS_ENV=development rake db:migrate
(in /Users/davidyip/Projects/pathcore/pathcore)
== 20080812182649 AddUniqueIndexToCollectionGroupsRequisitionIdentifier: migrating 
-- add_index(:collection_groups, :requisition_identifier, {:unique=>true})
rake aborted!
SQLite3::SQLException: SQL logic error or missing database: CREATE UNIQUE INDEX "index_collection_groups_on_requisition_identifier" ON "collection_groups" ("requisition_identifier")

gistfile4.txt

migration.rb

class AddUniqueIndexToCollectionGroupsRequisitionIdentifier < ActiveRecord::Migration
  def self.up
    add_index :collection_groups, :requisition_identifier, :unique => true
  end

  def self.down
    remove_index :collection_groups, :requisition_identifier
  end
end

schema.rb

ActiveRecord::Schema.define(:version => 20080811154437) do
  create_table "collection_groups", :force => true do |t|
    t.string   "time_point"
    t.string   "requisition_identifier"
    t.string   "cufs_account_number"
    t.string   "principal_investigator"
    t.integer  "participation_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  ...
end