##// END OF EJS Templates
fixed migration scripts to work with mysql 5 running in strict mode...
Jean-Philippe Lang -
r346:59e3802c7476
parent child
Show More
@@ -49,7 +49,7 class Setup < ActiveRecord::Migration
49 t.column "type", :string, :limit => 30, :default => "", :null => false
49 t.column "type", :string, :limit => 30, :default => "", :null => false
50 t.column "name", :string, :limit => 30, :default => "", :null => false
50 t.column "name", :string, :limit => 30, :default => "", :null => false
51 t.column "field_format", :string, :limit => 30, :default => "", :null => false
51 t.column "field_format", :string, :limit => 30, :default => "", :null => false
52 t.column "possible_values", :text, :default => ""
52 t.column "possible_values", :text
53 t.column "regexp", :string, :default => ""
53 t.column "regexp", :string, :default => ""
54 t.column "min_length", :integer, :default => 0, :null => false
54 t.column "min_length", :integer, :default => 0, :null => false
55 t.column "max_length", :integer, :default => 0, :null => false
55 t.column "max_length", :integer, :default => 0, :null => false
@@ -71,14 +71,14 class Setup < ActiveRecord::Migration
71 t.column "customized_type", :string, :limit => 30, :default => "", :null => false
71 t.column "customized_type", :string, :limit => 30, :default => "", :null => false
72 t.column "customized_id", :integer, :default => 0, :null => false
72 t.column "customized_id", :integer, :default => 0, :null => false
73 t.column "custom_field_id", :integer, :default => 0, :null => false
73 t.column "custom_field_id", :integer, :default => 0, :null => false
74 t.column "value", :text, :default => "", :null => false
74 t.column "value", :text
75 end
75 end
76
76
77 create_table "documents", :force => true do |t|
77 create_table "documents", :force => true do |t|
78 t.column "project_id", :integer, :default => 0, :null => false
78 t.column "project_id", :integer, :default => 0, :null => false
79 t.column "category_id", :integer, :default => 0, :null => false
79 t.column "category_id", :integer, :default => 0, :null => false
80 t.column "title", :string, :limit => 60, :default => "", :null => false
80 t.column "title", :string, :limit => 60, :default => "", :null => false
81 t.column "description", :text, :default => ""
81 t.column "description", :text
82 t.column "created_on", :timestamp
82 t.column "created_on", :timestamp
83 end
83 end
84
84
@@ -100,7 +100,7 class Setup < ActiveRecord::Migration
100 t.column "issue_id", :integer, :default => 0, :null => false
100 t.column "issue_id", :integer, :default => 0, :null => false
101 t.column "status_id", :integer, :default => 0, :null => false
101 t.column "status_id", :integer, :default => 0, :null => false
102 t.column "author_id", :integer, :default => 0, :null => false
102 t.column "author_id", :integer, :default => 0, :null => false
103 t.column "notes", :text, :default => ""
103 t.column "notes", :text
104 t.column "created_on", :timestamp
104 t.column "created_on", :timestamp
105 end
105 end
106
106
@@ -117,7 +117,7 class Setup < ActiveRecord::Migration
117 t.column "tracker_id", :integer, :default => 0, :null => false
117 t.column "tracker_id", :integer, :default => 0, :null => false
118 t.column "project_id", :integer, :default => 0, :null => false
118 t.column "project_id", :integer, :default => 0, :null => false
119 t.column "subject", :string, :default => "", :null => false
119 t.column "subject", :string, :default => "", :null => false
120 t.column "description", :text, :default => "", :null => false
120 t.column "description", :text
121 t.column "due_date", :date
121 t.column "due_date", :date
122 t.column "category_id", :integer
122 t.column "category_id", :integer
123 t.column "status_id", :integer, :default => 0, :null => false
123 t.column "status_id", :integer, :default => 0, :null => false
@@ -143,7 +143,7 class Setup < ActiveRecord::Migration
143 t.column "project_id", :integer
143 t.column "project_id", :integer
144 t.column "title", :string, :limit => 60, :default => "", :null => false
144 t.column "title", :string, :limit => 60, :default => "", :null => false
145 t.column "summary", :string, :limit => 255, :default => ""
145 t.column "summary", :string, :limit => 255, :default => ""
146 t.column "description", :text, :default => "", :null => false
146 t.column "description", :text
147 t.column "author_id", :integer, :default => 0, :null => false
147 t.column "author_id", :integer, :default => 0, :null => false
148 t.column "created_on", :timestamp
148 t.column "created_on", :timestamp
149 end
149 end
@@ -4,7 +4,7 class CreateComments < ActiveRecord::Migration
4 t.column :commented_type, :string, :limit => 30, :default => "", :null => false
4 t.column :commented_type, :string, :limit => 30, :default => "", :null => false
5 t.column :commented_id, :integer, :default => 0, :null => false
5 t.column :commented_id, :integer, :default => 0, :null => false
6 t.column :author_id, :integer, :default => 0, :null => false
6 t.column :author_id, :integer, :default => 0, :null => false
7 t.column :comment, :text, :default => "", :null => false
7 t.column :comment, :text
8 t.column :created_on, :datetime, :null => false
8 t.column :created_on, :datetime, :null => false
9 t.column :updated_on, :datetime, :null => false
9 t.column :updated_on, :datetime, :null => false
10 end
10 end
@@ -3,7 +3,7 class CreateWikiContents < ActiveRecord::Migration
3 create_table :wiki_contents do |t|
3 create_table :wiki_contents do |t|
4 t.column :page_id, :integer, :null => false
4 t.column :page_id, :integer, :null => false
5 t.column :author_id, :integer
5 t.column :author_id, :integer
6 t.column :text, :text, :default => "", :null => false
6 t.column :text, :text
7 t.column :comment, :string, :limit => 255, :default => ""
7 t.column :comment, :string, :limit => 255, :default => ""
8 t.column :updated_on, :datetime, :null => false
8 t.column :updated_on, :datetime, :null => false
9 t.column :version, :integer, :null => false
9 t.column :version, :integer, :null => false
General Comments 0
You need to be logged in to leave comments. Login now