diff options
| author | Jean-Philippe Lang <jp_lang@yahoo.fr> | 2007-03-19 18:12:35 +0000 |
|---|---|---|
| committer | Jean-Philippe Lang <jp_lang@yahoo.fr> | 2007-03-19 18:12:35 +0000 |
| commit | 59e3802c7476591cfa1d50c2008ecf9e67e75828 (patch) | |
| tree | 8dfcd68b50d290c5c1284de5b181469d6736a1fd /db/migrate/001_setup.rb | |
| parent | a1d2acd574f5761f245abb6d587ecca0c61c1382 (diff) | |
| download | redmine-59e3802c7476591cfa1d50c2008ecf9e67e75828.tar.gz redmine-59e3802c7476591cfa1d50c2008ecf9e67e75828.zip | |
fixed migration scripts to work with mysql 5 running in strict mode
git-svn-id: http://redmine.rubyforge.org/svn/trunk@349 e93f8b46-1217-0410-a6f0-8f06a7374b81
Diffstat (limited to 'db/migrate/001_setup.rb')
| -rw-r--r-- | db/migrate/001_setup.rb | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/db/migrate/001_setup.rb b/db/migrate/001_setup.rb index ee22c148b..3a30380f7 100644 --- a/db/migrate/001_setup.rb +++ b/db/migrate/001_setup.rb @@ -49,7 +49,7 @@ class Setup < ActiveRecord::Migration t.column "type", :string, :limit => 30, :default => "", :null => false
t.column "name", :string, :limit => 30, :default => "", :null => false
t.column "field_format", :string, :limit => 30, :default => "", :null => false
- t.column "possible_values", :text, :default => ""
+ t.column "possible_values", :text
t.column "regexp", :string, :default => ""
t.column "min_length", :integer, :default => 0, :null => false
t.column "max_length", :integer, :default => 0, :null => false
@@ -71,14 +71,14 @@ class Setup < ActiveRecord::Migration t.column "customized_type", :string, :limit => 30, :default => "", :null => false t.column "customized_id", :integer, :default => 0, :null => false t.column "custom_field_id", :integer, :default => 0, :null => false
- t.column "value", :text, :default => "", :null => false
+ t.column "value", :text
end
create_table "documents", :force => true do |t|
t.column "project_id", :integer, :default => 0, :null => false
t.column "category_id", :integer, :default => 0, :null => false
t.column "title", :string, :limit => 60, :default => "", :null => false
- t.column "description", :text, :default => ""
+ t.column "description", :text
t.column "created_on", :timestamp
end @@ -100,7 +100,7 @@ class Setup < ActiveRecord::Migration t.column "issue_id", :integer, :default => 0, :null => false
t.column "status_id", :integer, :default => 0, :null => false
t.column "author_id", :integer, :default => 0, :null => false
- t.column "notes", :text, :default => ""
+ t.column "notes", :text
t.column "created_on", :timestamp
end
@@ -117,7 +117,7 @@ class Setup < ActiveRecord::Migration t.column "tracker_id", :integer, :default => 0, :null => false
t.column "project_id", :integer, :default => 0, :null => false
t.column "subject", :string, :default => "", :null => false
- t.column "description", :text, :default => "", :null => false + t.column "description", :text t.column "due_date", :date
t.column "category_id", :integer
t.column "status_id", :integer, :default => 0, :null => false
@@ -143,7 +143,7 @@ class Setup < ActiveRecord::Migration t.column "project_id", :integer
t.column "title", :string, :limit => 60, :default => "", :null => false
t.column "summary", :string, :limit => 255, :default => ""
- t.column "description", :text, :default => "", :null => false
+ t.column "description", :text
t.column "author_id", :integer, :default => 0, :null => false
t.column "created_on", :timestamp
end |