Project

General

Profile

Actions

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:

0%

Estimated time:
0.50 h
Resolution:
Wont fix
Affected version:

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

Actions

Also available in: Atom PDF