summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorJean-Philippe Lang <jp_lang@yahoo.fr>2008-02-12 21:11:16 +0000
committerJean-Philippe Lang <jp_lang@yahoo.fr>2008-02-12 21:11:16 +0000
commita2626bbccf876fa290d0ee2b3c84168e6eb728da (patch)
tree7dfe6b0d87f98dc8733373f32cc4f983fb469cb2
parent616899d8793f3001c6d458276bebbd1b9cbe03ab (diff)
downloadredmine-a2626bbccf876fa290d0ee2b3c84168e6eb728da.tar.gz
redmine-a2626bbccf876fa290d0ee2b3c84168e6eb728da.zip
Fixed: not null constraints not removed with Postgresql.
git-svn-id: http://redmine.rubyforge.org/svn/trunk@1140 e93f8b46-1217-0410-a6f0-8f06a7374b81
-rw-r--r--db/migrate/048_allow_null_version_effective_date.rb2
-rw-r--r--db/migrate/076_allow_null_position.rb10
-rw-r--r--db/migrate/087_change_projects_description_to_text.rb2
3 files changed, 7 insertions, 7 deletions
diff --git a/db/migrate/048_allow_null_version_effective_date.rb b/db/migrate/048_allow_null_version_effective_date.rb
index 4b46bfe0e..82d2a33ec 100644
--- a/db/migrate/048_allow_null_version_effective_date.rb
+++ b/db/migrate/048_allow_null_version_effective_date.rb
@@ -1,6 +1,6 @@
class AllowNullVersionEffectiveDate < ActiveRecord::Migration
def self.up
- change_column :versions, :effective_date, :date, :default => nil
+ change_column :versions, :effective_date, :date, :default => nil, :null => true
end
def self.down
diff --git a/db/migrate/076_allow_null_position.rb b/db/migrate/076_allow_null_position.rb
index 45008d653..ece0370db 100644
--- a/db/migrate/076_allow_null_position.rb
+++ b/db/migrate/076_allow_null_position.rb
@@ -1,11 +1,11 @@
class AllowNullPosition < ActiveRecord::Migration
def self.up
# removes the 'not null' constraint on position fields
- change_column :issue_statuses, :position, :integer, :default => 1
- change_column :roles, :position, :integer, :default => 1
- change_column :trackers, :position, :integer, :default => 1
- change_column :boards, :position, :integer, :default => 1
- change_column :enumerations, :position, :integer, :default => 1
+ change_column :issue_statuses, :position, :integer, :default => 1, :null => true
+ change_column :roles, :position, :integer, :default => 1, :null => true
+ change_column :trackers, :position, :integer, :default => 1, :null => true
+ change_column :boards, :position, :integer, :default => 1, :null => true
+ change_column :enumerations, :position, :integer, :default => 1, :null => true
end
def self.down
diff --git a/db/migrate/087_change_projects_description_to_text.rb b/db/migrate/087_change_projects_description_to_text.rb
index 2829655d1..b06b0aa1c 100644
--- a/db/migrate/087_change_projects_description_to_text.rb
+++ b/db/migrate/087_change_projects_description_to_text.rb
@@ -1,6 +1,6 @@
class ChangeProjectsDescriptionToText < ActiveRecord::Migration
def self.up
- change_column :projects, :description, :text
+ change_column :projects, :description, :text, :null => true
end
def self.down