Defect #8028: Migration error under MSSQL 2000 - Redmine

Actions

Copy link

Defect #8028

closed

Migration error under MSSQL 2000

Added by Petr Pospisil over 13 years ago. Updated about 7 years ago.

Status:

Closed

Priority:

Normal

Assignee:

Category:

Database

Target version:

Start date:

2011-03-31

Due date:

% Done:

Estimated time:

0.50 h

Resolution:

Wont fix

Affected version:

1.1.2

Description

Hello,

I tried to install the Redmine on MSSQL 2000 and I had to change a migration file, because some kind of error occured on MSSQL side. (cannot change a column because it is in use by other object)

091_change_changesets_revision_to_string.rb
-------------------------------------------
line 3 change_column :changesets, :revision, :string, :null => false
-------------------------------------------

patched:
remove_index :changesets, :name => :changesets_repos_rev
change_column :changesets, :revision, :string, :null => false
add_index :changesets, [:repository_id, :revision], :unique => true, :name => :changesets_repos_rev

Regards
Petr