| @@ -1,13 +1,32 | |||
|
|
1 | 1 | class ChangeChangesetsRevisionToString < ActiveRecord::Migration |
|
|
2 | 2 | def self.up |
|
|
3 | remove_index :changesets, :name => :changesets_repos_rev | |
|
|
3 | # Some backends (eg. SQLServer 2012) do not support changing the type | |
|
|
4 | # of an indexed column so the index needs to be dropped first | |
|
|
5 | # BUT this index is renamed with some backends (at least SQLite3) for | |
|
|
6 | # some (unknown) reasons, thus we check for the other name as well | |
|
|
7 | # so we don't end up with 2 identical indexes | |
|
|
8 | if index_exists? :changesets, [:repository_id, :revision], :name => :changesets_repos_rev | |
|
|
9 | remove_index :changesets, :name => :changesets_repos_rev | |
|
|
10 | end | |
|
|
11 | if index_exists? :changesets, [:repository_id, :revision], :name => :altered_changesets_repos_rev | |
|
|
12 | remove_index :changesets, :name => :altered_changesets_repos_rev | |
|
|
13 | end | |
|
|
14 | ||
|
|
4 | 15 | change_column :changesets, :revision, :string, :null => false |
|
|
16 | ||
|
|
5 | 17 | add_index :changesets, [:repository_id, :revision], :unique => true, :name => :changesets_repos_rev |
|
|
6 | 18 | end |
|
|
7 | 19 | |
|
|
8 | 20 | def self.down |
|
|
9 |
|
|
|
|
21 | if index_exists? :changesets, :changesets_repos_rev | |
|
|
22 | remove_index :changesets, :name => :changesets_repos_rev | |
|
|
23 | end | |
|
|
24 | if index_exists? :changesets, [:repository_id, :revision], :name => :altered_changesets_repos_rev | |
|
|
25 | remove_index :changesets, :name => :altered_changesets_repos_rev | |
|
|
26 | end | |
|
|
27 | ||
|
|
10 | 28 | change_column :changesets, :revision, :integer, :null => false |
|
|
29 | ||
|
|
11 | 30 | add_index :changesets, [:repository_id, :revision], :unique => true, :name => :changesets_repos_rev |
|
|
12 | 31 | end |
|
|
13 | 32 | end |
General Comments 0
You need to be logged in to leave comments.
Login now