Chris@0: class ChangeChangesetsRevisionToString < ActiveRecord::Migration
Chris@0:   def self.up
Chris@1295:     # Some backends (eg. SQLServer 2012) do not support changing the type
Chris@1295:     # of an indexed column so the index needs to be dropped first
Chris@1295:     # BUT this index is renamed with some backends (at least SQLite3) for
Chris@1295:     # some (unknown) reasons, thus we check for the other name as well
Chris@1295:     # so we don't end up with 2 identical indexes
Chris@1295:     if index_exists? :changesets, [:repository_id, :revision], :name => :changesets_repos_rev
Chris@1295:       remove_index  :changesets, :name => :changesets_repos_rev
Chris@1295:     end
Chris@1295:     if index_exists? :changesets, [:repository_id, :revision], :name => :altered_changesets_repos_rev
Chris@1295:       remove_index  :changesets, :name => :altered_changesets_repos_rev
Chris@1295:     end
Chris@1295: 
Chris@0:     change_column :changesets, :revision, :string, :null => false
Chris@1295: 
Chris@1295:     add_index :changesets, [:repository_id, :revision], :unique => true, :name => :changesets_repos_rev
Chris@0:   end
Chris@0: 
Chris@0:   def self.down
Chris@1295:     if index_exists? :changesets, :changesets_repos_rev
Chris@1295:       remove_index  :changesets, :name => :changesets_repos_rev
Chris@1295:     end
Chris@1295:     if index_exists? :changesets, [:repository_id, :revision], :name => :altered_changesets_repos_rev
Chris@1295:       remove_index  :changesets, :name => :altered_changesets_repos_rev
Chris@1295:     end
Chris@1295: 
Chris@0:     change_column :changesets, :revision, :integer, :null => false
Chris@1295: 
Chris@1295:     add_index :changesets, [:repository_id, :revision], :unique => true, :name => :changesets_repos_rev
Chris@0:   end
Chris@0: end